Enrich your CSV with US Census data

Drop a CSV that has a US state or county column. We'll append population, median household income, median home value, business establishment count, and state-level exclusion intensity from our Census Bundle (ACS 2023 5-year + CBP 2022).

Your data never leaves your browser. The CSV is parsed, enriched, and downloaded entirely client-side. No file is ever sent to Palavir or any server.

Drop your CSV here

or click below to browse. Max 50,000 rows. Stays in your browser.

How it works

  1. Drop in a CSV (or click to browse). Headers go in the first row.
  2. Pick the column that holds the geography — state abbreviation (TX), full state name (Texas), or county name. ZIP enrichment is not supported in V1; map ZIPs to county first.
  3. Toggle which enrichment columns to append. Default is all on.
  4. Preview the first 10 rows. If it looks right, hit Download enriched CSV. The download is a Blob URL — no round-trip to a server.

What columns get added

  • enrich_state_name — full state name resolved from your input.
  • enrich_population — county population if county provided, state population otherwise (ACS 2023, B01003_001E).
  • enrich_median_hh_income — county-level if county resolved, weighted-average state-level otherwise (ACS 2023, B19013_001E).
  • enrich_median_home_value — same county vs. state fallback (ACS 2023, B25077_001E).
  • enrich_establishment_count — total establishments from County Business Patterns 2022 (county-level if county provided).
  • enrich_exclusion_intensity_per_10k_estab — basis points equivalent. State-level OIG-LEIE exclusions per 10,000 business establishments. Higher = more exclusions per business.
  • enrich_match_level — "county", "state", or "unmatched".

Coverage

51 states + DC · 3,144 county / county-equivalent rows. Hard cap of 50,000 input rows to keep things responsive in the browser.

Next steps