GEO_TABLE

Queries that source from GEO_TABLE table

geoDetail

What is in the GEO_TABLE table?

Results are returned as a json, pySpark DataFrame, or pandas DataFrame (default).

feature	description	example
zip	Postal Zone Improvement Plan (ZIP) code corresponding to a geographic area	36511
zip3	First three digits of the zip code	365
county_code	US Government's Federal Information Processing Standards (FIPS) code for state-county combination.	1003
county	Name and State of the corresponding county	baldwin county, al
county_pop	US Census estimated population of the County population	246,435
county_growth_rate	US Census estimated County population growth trend	2.96%
metro	US Census Bureau metropolitan and micropolitan statistical area	mobile-daphne-fairhope, al
metro_location	Centrality of the county as it relates to the corresponding Metro	central
state_code	Two digit code representing a US State	AL
state	Full name of US State	alabama
state_pop	US Census estimated population of the State population	4,670,054
state_growth_rate	US Census estimated State population growth trend	0.55%
division	Nine minor State groupings as defined by the US Census Bureau	east south central
division_pop	US Census estimated population of the Division population	17,113,731
division_growth_rate	US Census estimated Division population growth trend	0.62%
region	Four major State groupings as defined by the US Census Bureau	south
region_pop	US Census estimated population of the Region population	120,425,628
region_growth_rate	US Census estimated Region population growth trend	1.14%

Helper Function within the CareQuery API to help understand the underlying GEO_TABLE dataset.

# import package
from care_query.care_query import CareQuery

# instantiate and connect
cq = CareQuery(email = "your-email", 
               token = "your-api-token")

# return details 
print(cq.glossary.table_detail('GEO_TABLE'))