geographyNameVarchar(70)The name of the geographygeographyIdVarchar(14)The identifying number of the geography. For identification purposes, each geography is assigned a FIPS code (Federal Information Processing Standard code) by the U.S. Census Bureau rankIntegerThe rank of the attributemyAreaIndicatorVarchar(1)An indication of whether a user has selected "rank my area" for that geography (True or False)stateFipsVarchar(2)The FIPS code of the state. For identification purposes, each state is assigned a two digit FIPS code (Federal Information Processing Standard code) by the U.S. Census BureauAllGROUPBrackets rank results of a query when a full list of geographies is returned FirstTenGROUPBrackets the first 10 rank results of a query myAreaGROUPBrackets the area in which a user selects "rank my area", along with 10 closest rank results (five above, five below)LastTenGROUPBrackets the last 10 rank results of a querypopulationNumeric(10,0)The population of the selected geographyhouseholdsNumeric(10,0)The number of households in the selected geographyageBetween20to34Numeric(6,5)The percent of population in a given geography with an age between 20 and 34 ageBetween35to59Numeric(6,5)The percent of population in a given geography with an age between 35 and 59 ageBetween5to19Numeric(6,5)The percent of population in a given geography with an age between 5 and 19 ageGreaterThan60Numeric(6,5)The percent of population in a given geography with an age greater than 60 ageUnder5Numeric(6,5)The percent of population in a given geography with an age less than 5 educationBachelorOrGreaterNumeric(6,5)The percent of population in a given geography with a bachelor's degree or highereducationHighSchoolGraduateNumeric(6,5)The percent of population in a given geography with a high school diploma or higherincomeBelowPovertyNumeric(6,5)The percent of households in a given geography below the 100% poverty levelincomeBetween100to200Numeric(6,5)The percent of households in a given geography with an income between $100,000 and $200,000incomeBetween25to50Numeric(6,5)The percent of households in a given geography with an income between $25,000 and $50,000incomeBetween50to100Numeric(6,5)The percent of households in a given geography with an income between $50,000 and $100,000incomeGreater200Numeric(6,5)The percent of households in a given geography with an income greater than $200,000incomeLessThan25Numeric(6,5)The percent of households in a given geography with an income less than $25,000landAreaNumeric(38,8)The land area of a given geography (in square miles)medianIncomeNumeric(15,5)The median household income of a given geographyraceAsianNumeric(6,5)The percent of population in a given geography of Asian descentraceBlackNumeric(6,5)The percent of population in a given geography of African American descentraceHispanicNumeric(6,5)The percent of population in a given geography of Hispanic descentraceNativeAmericanNumeric(6,5)The percent of population in a given geography of Native American descentraceWhiteNumeric(6,5)The percent of population in a given geography of Caucasian descentproviderEquals0Numeric(6,5)The percent of households or population in a given geography with access to 0 providers (Any technology)providerGreaterThan1Numeric(6,5)The percent of households or population in a given geography with access to 1 or more providers (Any technology)providerGreaterThan2Numeric(6,5)The percent of households or population in a given geography with access to 2 or more providers (Any technology)providerGreaterThan3Numeric(6,5)The percent of households or population in a given geography with access to 3 or more providers (Any technology)providerGreaterThan4Numeric(6,5)The percent of households or population in a given geography with access to 4 or more providers (Any technology)providerGreaterThan5Numeric(6,5)The percent of households or population in a given geography with access to 5 or more providers (Any technology)providerGreaterThan6Numeric(6,5)The percent of households or population in a given geography with access to 6 or more providers (Any technology)providerGreaterThan7Numeric(6,5)The percent of households or population in a given geography with access to 7 or more providers (Any technology)providerGreaterThan8Numeric(6,5)The percent of households or population in a given geography with access to 8 or more providers (Any technology)wirelessProviderEquals0Numeric(6,5)The percent of households or population in a given geography with access to 0 wireless providers (excludes satellite)wirelessProviderGreaterThan1Numeric(6,5)The percent of households or population in a given geography with access to 1 or more wireless providers (excludes satellite)wirelessProviderGreaterThan2Numeric(6,5)The percent of households or population in a given geography with access to 2 or more wireless providers (excludes satellite)wirelessProviderGreaterThan3Numeric(6,5)The percent of households or population in a given geography with access to 3 or more wireless providers (excludes satellite)wirelessProviderGreaterThan4Numeric(6,5)The percent of households or population in a given geography with access to 4 or more wireless providers (excludes satellite)wirelessProviderGreaterThan5Numeric(6,5)The percent of households or population in a given geography with access to 5 or more wireless providers (excludes satellite)wirelessProviderGreaterThan6Numeric(6,5)The percent of households or population in a given geography with access to 6 or more wireless providers (excludes satellite)wirelessProviderGreaterThan7Numeric(6,5)The percent of households or population in a given geography with access to 7 or more wireless providers (excludes satellite)wirelessProviderGreaterThan8Numeric(6,5)The percent of households or population in a given geography with access to 8 or more wireless providers (excludes satellite)wirelineProviderEquals0Numeric(6,5)The percent of households or population in a given geography with access to 0 wireline providerswirelineProviderGreaterThan1Numeric(6,5)The percent of households or population in a given geography with access to 1 or more wireline providerswirelineProviderGreaterThan2Numeric(6,5)The percent of households or population in a given geography with access to 2 or more wireline providerswirelineProviderGreaterThan3Numeric(6,5)The percent of households or population in a given geography with access to 3 or more wireline providerswirelineProviderGreaterThan4Numeric(6,5)The percent of households or population in a given geography with access to 4 or more wireline providerswirelineProviderGreaterThan5Numeric(6,5)The percent of households or population in a given geography with access to 5 or more wireline providerswirelineProviderGreaterThan6Numeric(6,5)The percent of households or population in a given geography with access to 6 or more wireline providerswirelineProviderGreaterThan7Numeric(6,5)The percent of households or population in a given geography with access to 7 or more wireline providerswirelineProviderGreaterThan8Numeric(6,5)The percent of households or population in a given geography with access to 8 or more wireline providersdownloadSpeedGreaterThan100000kNumeric(6,5)The percent of households or population in a given geography with access to download speeds greater than 100 mbps downloadSpeedGreaterThan10000kNumeric(6,5)The percent of households or population in a given geography with access to download speeds greater than 10 mbps downloadSpeedGreaterThan1500kNumeric(6,5)The percent of households or population in a given geography with access to download speeds greater than 1.5 mbps downloadSpeedGreaterThan1GigNumeric(6,5)The percent of households or population in a given geography with access to download speeds greater than 1 gbps downloadSpeedGreaterThan25000kNumeric(6,5)The percent of households or population in a given geography with access to download speeds greater than 25 mbps downloadSpeedGreaterThan3000kNumeric(6,5)The percent of households or population in a given geography with access to download speeds greater than 3 mbps downloadSpeedGreaterThan3000kAndUploadSpeedGreaterThan768kNumeric(6,5)The percent of households or population in a given geography with access to download speeds greater than 3 mbps and upload speeds greater than 768 kbpsdownloadSpeedGreaterThan50000kNumeric(6,5)The percent of households or population in a given geography with access to download speeds greater than 50 mbps downloadSpeedGreaterThan6000kNumeric(6,5)The percent of households or population in a given geography with access to download speeds greater than 6 mbps downloadSpeedGreaterThan768kNumeric(6,5)The percent of households or population in a given geography with access to download speeds greater than 768 kbps downloadSpeedGreaterThan768kAndUploadSpeedGreaterThan200kNumeric(6,5)The percent of households or population in a given geography with access to download speeds greater than 768 kbps and upload speeds greater than 200 kbpsuploadSpeedGreaterThan100000kNumeric(6,5)The percent of households or population in a given geography with access to upload speeds greater than 100 mbps uploadSpeedGreaterThan10000kNumeric(6,5)The percent of households or population in a given geography with access to upload speeds greater than 10 mbps uploadSpeedGreaterThan1500kNumeric(6,5)The percent of households or population in a given geography with access to upload speeds greater than 1.5 mbps uploadSpeedGreaterThan1GigNumeric(6,5)The percent of households or population in a given geography with access to upload speeds greater than 1 gbps uploadSpeedGreaterThan200kNumeric(6,5)The percent of households or population in a given geography with access to upload speeds greater than 200 kbps uploadSpeedGreaterThan25000kNumeric(6,5)The percent of households or population in a given geography with access to upload speeds greater than 25 mbps uploadSpeedGreaterThan3000kNumeric(6,5)The percent of households or population in a given geography with access to upload speeds greater than 3 mbps uploadSpeedGreaterThan50000kNumeric(6,5)The percent of households or population in a given geography with access to upload speeds greater than 50 mbps uploadSpeedGreaterThan6000kNumeric(6,5)The percent of households or population in a given geography with access to upload speeds greater than 6 mbps uploadSpeedGreaterThan768kNumeric(6,5)The percent of households or population in a given geography with access to upload speeds greater than 768 kbps uploadSpeedLessThan200kNumeric(6,5)The percent of households or population in a given geography with access to upload speeds less than 200 kbps anyTechnologyNumeric(6,5)The percent of households or population in a given geography with access to any broadband technologyanyWirelessNumeric(6,5)The percent of households or population in a given geography with access to any wireless technology (excluding satellite)anyWirelineNumeric(6,5)The percent of households or population in a given geography with access to any wireline technology asymmetricDslNumeric(6,5)The percent of households or population in a given geography with access to asymmetric DSL technologycableNumeric(6,5)The percent of households or population in a given geography with access to cable technologycableDocsisNumeric(6,5)The percent of households or population in a given geography with access to cable DOCSIS 3.0 technologycableOtherNumeric(6,5)The percent of households or population in a given geography with access to other cable technologiescopperNumeric(6,5)The percent of households or population in a given geography with access to copper technologydslNumeric(6,5)The percent of households or population in a given geography with access to DSL technologyfixedWirelessNumeric(6,5)The percent of households or population in a given geography with access to fixed wireless technologyfixedWirelessLicensedNumeric(6,5)The percent of households or population in a given geography with access to licensed fixed wireless technologyfixedWirelessUnlicensedNumeric(6,5)The percent of households or population in a given geography with access to unlicensed fixed wireless technologymobileWirelessNumeric(6,5)The percent of households or population in a given geography with access to mobile wireless technologyopticalFiberNumeric(6,5)The percent of households or population in a given geography with access to optical fiber technologyotherTechnologyNumeric(6,5)The percent of households or population in a given geography with access to other technologies powerlineNumeric(6,5)The percent of households or population in a given geography with access to electric powerline technologysatelliteNumeric(6,5)The percent of households or population in a given geography with access to satellite technologysymmetricDslNumeric(6,5)The percent of households or population in a given geography with access to symmetric DSL technology