Geography Tables

Overview

Data is joinable across all Cybersyn products that have a GEO_ID. Data Commons’ unique geographic identifiers were used to form the core of the GEOGRAPHY_INDEX and related tables below. Cybersyn expanded geographic coverage using data from Statistics Canada and the US Census Bureau. Boundaries, in particular, are from these two sources.

Our goal is to create a single, unified schema across public and proprietary datasets. The Cybersyn schema aims to strike a balance between flexibility to accommodate arbitrarily shaped data along with consistency in core tables. Refer to Cybersyn Concepts for more details.

Tables & Cybersyn Products

Table	Description	Cybersyn Products
GEOGRAPHY_INDEX	Provides a unique GEO_ID with its associated GEO_NAME and LEVEL (e.g. City, CensusZipCodeTabulationArea, County). ISO codes are provided for a geography where applicable	Consumer Spending, Enterprise, Government Essentials, Financial & Economic Essentials, SEC Filings, Canada Government Essentials, US Housing & Real Estate Essentials, US Points of Interest & Addresses, Weather & Environmental Essentials, Crime Statistics, US Insurance & Healthcare Provider Foundation, LLM Training Essentials
GEOGRAPHY_CHARACTERISTICS	Various types of geographic characteristic relationships (e.g. GEOJSON coordinates, WKT coordinates, state abbreviations, and FIPS 10-4 codes) with an associated RELATIONSHIP_START_DATE and RELATIONSHIP_END_DATE by GEO_ID.	Enterprise, Government Essentials, Canada Government Essentials, US Housing & Real Estate, US Points of Interest & Addresses
GEOGRAPHY_RELATIONSHIPS	Relationships between geographic entities of differing levels. Includes relationships of type 'overlaps' and type 'contains'. For example, it provides a GEO_ID for a zip code that overlaps with a city, and it details a GEO_ID for a state that contains a particular census tract.	Consumer Spending, Enterprise, Government Essentials, Financial & Economic Essentials, Canada Government Essentials, US Housing & Real Estate Essentials, US Points of Interest & Addresses, Weather & Environmental Essentials, US Insurance & Healthcare Provider Foundation, LLM Training Essentials
GEOGRAPHY_HIERARCHY	Hierarchical relationships between a PARENT_GEO_ID and GEO_ID (e.g. country/USA is parent to geoID/01, which is representative of the state of Alabama).	Enterprise, Financial & Economic Essentials, Canada Government Essentials
GEOGRAPHY_OVERLAPS	Overlapping geographic relationships between the GEO_ID and OVERLAPS_WITH (e.g. overlap between a county and a zip code).	Enterprise, Financial & Economic Essentials