census

Census

Reverse ETL from warehouse to tools.

Census model and sync configs for syncing warehouse data to operational tools.

Configuration Recipes6

censusRbeginner
Combining Multiple Character Columns in Census Data

Learn how to merge multiple character columns into a single identifier in your Census data using R.

Census · Marketing
censusSQLintermediate
Calculating Median County Population by State in BigQuery

Learn how to compute the median county population and the number of counties per state using BigQuery's PERCENTILE_CONT function.

Census · Marketing
censusPythonbeginner
Extracting Census Data from a Web Table and Saving as CSV

Learn how to extract a demographic table from a Census report webpage and save it as a CSV file using Python.

Census · Marketing
censusSQLintermediate
Calculating User Distances Using Census Data

This article outlines an approach to calculate distances between users based on their zip codes using Census data and the Haversine formula.

Census · Marketing
censusRbeginner
Converting File Sizes in R: Bytes to KB, MB, and More

Learn how to convert file sizes from bytes to more readable formats like KB and MB in R using built-in functions.

Census · Marketing
censusPythonintermediate
Identifying Census Tracts Using GeoJSON and Python

Learn how to efficiently determine which census tract a given coordinate falls into using Python and GeoJSON data.

Census · Marketing