US Census
Let AI connect your sources for you
Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.
Connect US Census to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Sync official US Census Bureau statistics. Get a free API key at api.census.gov. To sync a dataset beyond the built-in tables, fill in the custom query fields using the dataset directory at api.census.gov/data.html.
Configuration
| Option | Type | Required |
|---|---|---|
API key | password | Yes |
Custom query: dataset path | text | No |
Custom query: variables (get) | text | No |
Custom query: geography (for) | text | No |
Custom query: parent geography (in) | text | No |
Linking US Census to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select US Census
- Fill in the required configuration fields
- Click Next, select the tables you want to sync, and then press Import
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
AcsDemographicsByState | American Community Survey 5-year estimates (2020-2024) of population, income, housing, employment, and education for every US state. | Full refresh | — | — |
AcsDemographicsByCounty | American Community Survey 5-year estimates (2020-2024) of population, income, housing, employment, and education for every US county. | Full refresh | — | — |
DecennialPopulationByState | 2020 Decennial Census (PL 94-171) population and housing unit counts for every US state. | Full refresh | — | — |
DecennialPopulationByCounty | 2020 Decennial Census (PL 94-171) population and housing unit counts for every US county. | Full refresh | — | — |
CountyBusinessPatternsByState | County Business Patterns (2023) establishment, employment, and payroll totals for every US state. | Full refresh | — | — |
PopulationEstimatesByState | Population Estimates Program (vintage 2021) population and density for every US state. | Full refresh | — | — |