Spaces:
Running on CPU Upgrade
Running on CPU Upgrade
| <html lang=en dir=ltr class="docs-wrapper plugin-docs plugin-id-default docs-version-current docs-doc-page docs-doc-id-data-sources/census-acs" data-has-hydrated=false><head><meta charset=UTF-8><meta name=generator content="Docusaurus v3.10.0"><title data-rh=true>Census American Community Survey (ACS) | Open Navigator</title><meta data-rh=true name=viewport content="width=device-width, initial-scale=1.0"/><meta data-rh=true property=og:image content=https://www.communityone.com/img/docusaurus-social-card.jpg /><meta data-rh=true name=twitter:image content=https://www.communityone.com/img/docusaurus-social-card.jpg /><meta data-rh=true property=og:url content=https://www.communityone.com/docs/data-sources/census-acs /><meta data-rh=true property=og:locale content=en /><meta data-rh=true name=docusaurus_locale content=en /><meta data-rh=true name=docsearch:language content=en /><meta data-rh=true name=keywords content="civic engagement, policy tracking, meeting minutes, nonprofit tracking, municipal government, advocacy, open data, local government"/><meta data-rh=true property=og:type content=website /><meta data-rh=true property=og:site_name content="Open Navigator"/><meta data-rh=true name=twitter:card content=summary_large_image /><meta data-rh=true name=docusaurus_version content=current /><meta data-rh=true name=docusaurus_tag content=docs-default-current /><meta data-rh=true name=docsearch:version content=current /><meta data-rh=true name=docsearch:docusaurus_tag content=docs-default-current /><meta data-rh=true property=og:title content="Census American Community Survey (ACS) | Open Navigator"/><meta data-rh=true name=description content="Add demographic, economic, housing, and social data from the U.S. Census Bureau's American Community Survey to enrich your civic engagement analysis."/><meta data-rh=true property=og:description content="Add demographic, economic, housing, and social data from the U.S. Census Bureau's American Community Survey to enrich your civic engagement analysis."/><link data-rh=true rel=icon href=/img/favicon.ico /><link data-rh=true rel=canonical href=https://www.communityone.com/docs/data-sources/census-acs /><link data-rh=true rel=alternate href=https://www.communityone.com/docs/data-sources/census-acs hreflang=en /><link data-rh=true rel=alternate href=https://www.communityone.com/docs/data-sources/census-acs hreflang=x-default /><link rel=alternate type=application/rss+xml href=/blog/rss.xml title="Open Navigator RSS Feed"><link rel=alternate type=application/atom+xml href=/blog/atom.xml title="Open Navigator Atom Feed"><link rel=preconnect href=https://www.google-analytics.com><link rel=preconnect href=https://www.googletagmanager.com><script async src="https://www.googletagmanager.com/gtag/js?id=G-5EQV815915"></script><script>function gtag(){dataLayer.push(arguments)}window.dataLayer=window.dataLayer||[],gtag("js",new Date),gtag("config","G-5EQV815915",{anonymize_ip:!0})</script><link rel=stylesheet href=/assets/css/styles.c89d6b2d.css /><script src=/assets/js/runtime~main.c8fa085e.js defer></script><script src=/assets/js/main.6e24e536.js defer></script></head><body><svg style="display: none;"><defs> | |
| <symbol id=theme-svg-external-link viewBox="0 0 24 24"><path fill=currentColor d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"/></symbol> | |
| </defs></svg> | |
| <script>!function(){var t=function(){try{return new URLSearchParams(window.location.search).get("docusaurus-theme")}catch(t){}}()||function(){try{return window.localStorage.getItem("theme-7e9")}catch(t){}}();document.documentElement.setAttribute("data-theme",t||(window.matchMedia("(prefers-color-scheme: dark)").matches?"dark":"light")),document.documentElement.setAttribute("data-theme-choice",t||"system")}(),function(){try{for(var[t,e]of new URLSearchParams(window.location.search).entries())if(t.startsWith("docusaurus-data-")){var a=t.replace("docusaurus-data-","data-");document.documentElement.setAttribute(a,e)}}catch(t){}}()</script><div id=__docusaurus><link rel=preload as=image href=/img/communityone_logo.svg /><script type=application/ld+json>{"@context":"https://schema.org","@type":"Organization","address":{"@type":"PostalAddress","addressCountry":"US","addressLocality":"Tuscaloosa","addressRegion":"AL","postalCode":"35406","streetAddress":"5617 Lakeridge Court"},"contactPoint":{"@type":"ContactPoint","availableLanguage":["English"],"contactType":"Customer Service","email":"johnbowyer@communityone.com"},"description":"Track 90,000+ jurisdictions, 1.8M nonprofits, and analyze meeting minutes with AI. The open path to everything local.","email":"johnbowyer@communityone.com","legalName":"CommunityOne","logo":"https://www.communityone.com/img/communityone_logo.svg","name":"CommunityOne","sameAs":["https://www.facebook.com/communityone","https://www.instagram.com/communityone","https://twitter.com/communityone","https://www.linkedin.com/company/communityone","https://www.youtube.com/@communityone","https://discord.gg/communityone","https://github.com/getcommunityone/open-navigator"],"url":"https://www.communityone.com"}</script><script type=application/ld+json>{"@context":"https://schema.org","@type":"WebSite","alternateName":"CommunityOne Open Navigator","description":"AI-powered civic engagement platform tracking jurisdictions, nonprofits, and government meetings","name":"Open Navigator","potentialAction":{"@type":"SearchAction","query-input":"required name=search_term_string","target":{"@type":"EntryPoint","urlTemplate":"https://www.communityone.com/search?q={search_term_string}"}},"url":"https://www.communityone.com"}</script><script type=application/ld+json>{"@context":"https://schema.org","@type":"SoftwareApplication","aggregateRating":{"@type":"AggregateRating","ratingCount":"1","ratingValue":"5"},"applicationCategory":"BusinessApplication","description":"Track 90,000+ jurisdictions, 1.8M nonprofits, and analyze meeting minutes with AI","featureList":["Track 90,000+ jurisdictions","Monitor 1.8M nonprofits","Analyze meeting minutes","Legislative bill tracking","Campaign finance data"],"name":"Open Navigator","offers":{"@type":"Offer","price":"0","priceCurrency":"USD"},"operatingSystem":"Web","screenshot":"https://www.communityone.com/img/docusaurus-social-card.jpg","softwareVersion":"1.0.0"}</script><div role=region aria-label="Skip to main content"><a class=skipToContent_fXgn href=#__docusaurus_skipToContent_fallback>Skip to main content</a></div><nav aria-label=Main class="theme-layout-navbar navbar navbar--fixed-top"><div class=navbar__inner><div class="theme-layout-navbar-left navbar__items"><button aria-label="Toggle navigation bar" aria-expanded=false class="navbar__toggle clean-btn" type=button><svg width=30 height=30 viewBox="0 0 30 30" aria-hidden=true><path stroke=currentColor stroke-linecap=round stroke-miterlimit=10 stroke-width=2 d="M4 7h22M4 15h22M4 23h22"/></svg></button><a href=https://www.communityone.com target=_self rel="noopener noreferrer" class=navbar__brand><div class=navbar__logo><img src=/img/communityone_logo.svg alt="CommunityOne Logo" class="themedComponent_mlkZ themedComponent--light_NVdE"/><img src=/img/communityone_logo.svg alt="CommunityOne Logo" class="themedComponent_mlkZ themedComponent--dark_xIcU"/></div><b class="navbar__title text--truncate">Open Navigator Home</b></a><a class="navbar__item navbar__link" href=/docs/intro>Getting Started</a><a class="navbar__item navbar__link" href=/docs/for-families>Families & Individuals</a><a class="navbar__item navbar__link" href=/docs/for-advocates>Policy Makers</a><a class="navbar__item navbar__link" href=/docs/for-developers>Developers</a><a class="navbar__item navbar__link" href=/docs/data-sources/citations>Data and Terms</a><a class="navbar__item navbar__link" href=/blog>Blog</a></div><div class="theme-layout-navbar-right navbar__items navbar__items--right"><a href=https://github.com/getcommunityone/open-navigator-for-engagement target=_blank rel="noopener noreferrer" class="navbar__item navbar__link">GitHub<svg width=13.5 height=13.5 aria-label="(opens in new tab)" class=iconExternalLink_nPIU><use href=#theme-svg-external-link /></svg></a><div class="toggle_vylO colorModeToggle_DEke"><button class="clean-btn toggleButton_gllP toggleButtonDisabled_aARS" type=button disabled title="system mode" aria-label="Switch between dark and light mode (currently system mode)"><svg viewBox="0 0 24 24" width=24 height=24 aria-hidden=true class="toggleIcon_g3eP lightToggleIcon_pyhR"><path fill=currentColor d="M12,9c1.65,0,3,1.35,3,3s-1.35,3-3,3s-3-1.35-3-3S10.35,9,12,9 M12,7c-2.76,0-5,2.24-5,5s2.24,5,5,5s5-2.24,5-5 S14.76,7,12,7L12,7z M2,13l2,0c0.55,0,1-0.45,1-1s-0.45-1-1-1l-2,0c-0.55,0-1,0.45-1,1S1.45,13,2,13z M20,13l2,0c0.55,0,1-0.45,1-1 s-0.45-1-1-1l-2,0c-0.55,0-1,0.45-1,1S19.45,13,20,13z M11,2v2c0,0.55,0.45,1,1,1s1-0.45,1-1V2c0-0.55-0.45-1-1-1S11,1.45,11,2z M11,20v2c0,0.55,0.45,1,1,1s1-0.45,1-1v-2c0-0.55-0.45-1-1-1C11.45,19,11,19.45,11,20z M5.99,4.58c-0.39-0.39-1.03-0.39-1.41,0 c-0.39,0.39-0.39,1.03,0,1.41l1.06,1.06c0.39,0.39,1.03,0.39,1.41,0s0.39-1.03,0-1.41L5.99,4.58z M18.36,16.95 c-0.39-0.39-1.03-0.39-1.41,0c-0.39,0.39-0.39,1.03,0,1.41l1.06,1.06c0.39,0.39,1.03,0.39,1.41,0c0.39-0.39,0.39-1.03,0-1.41 L18.36,16.95z M19.42,5.99c0.39-0.39,0.39-1.03,0-1.41c-0.39-0.39-1.03-0.39-1.41,0l-1.06,1.06c-0.39,0.39-0.39,1.03,0,1.41 s1.03,0.39,1.41,0L19.42,5.99z M7.05,18.36c0.39-0.39,0.39-1.03,0-1.41c-0.39-0.39-1.03-0.39-1.41,0l-1.06,1.06 c-0.39,0.39-0.39,1.03,0,1.41s1.03,0.39,1.41,0L7.05,18.36z"/></svg><svg viewBox="0 0 24 24" width=24 height=24 aria-hidden=true class="toggleIcon_g3eP darkToggleIcon_wfgR"><path fill=currentColor d="M9.37,5.51C9.19,6.15,9.1,6.82,9.1,7.5c0,4.08,3.32,7.4,7.4,7.4c0.68,0,1.35-0.09,1.99-0.27C17.45,17.19,14.93,19,12,19 c-3.86,0-7-3.14-7-7C5,9.07,6.81,6.55,9.37,5.51z M12,3c-4.97,0-9,4.03-9,9s4.03,9,9,9s9-4.03,9-9c0-0.46-0.04-0.92-0.1-1.36 c-0.98,1.37-2.58,2.26-4.4,2.26c-2.98,0-5.4-2.42-5.4-5.4c0-1.81,0.89-3.42,2.26-4.4C12.92,3.04,12.46,3,12,3L12,3z"/></svg><svg viewBox="0 0 24 24" width=24 height=24 aria-hidden=true class="toggleIcon_g3eP systemToggleIcon_QzmC"><path fill=currentColor d="m12 21c4.971 0 9-4.029 9-9s-4.029-9-9-9-9 4.029-9 9 4.029 9 9 9zm4.95-13.95c1.313 1.313 2.05 3.093 2.05 4.95s-0.738 3.637-2.05 4.95c-1.313 1.313-3.093 2.05-4.95 2.05v-14c1.857 0 3.637 0.737 4.95 2.05z"/></svg></button></div><div class=navbarSearchContainer_Bca1></div></div></div><div role=presentation class=navbar-sidebar__backdrop></div></nav><div id=__docusaurus_skipToContent_fallback class="theme-layout-main main-wrapper mainWrapper_z2l0"><div class=docsWrapper_hBAB><button aria-label="Scroll back to top" class="clean-btn theme-back-to-top-button backToTopButton_sjWU" type=button></button><div class=docRoot_UBD9><main class="docMainContainer_TBSr docMainContainerEnhanced_lQrH"><div class="container padding-top--md padding-bottom--lg"><div class=row><div class="col docItemCol_VOVn"><div class=docItemContainer_Djhp><article><div class="tocCollapsible_ETCw theme-doc-toc-mobile tocMobile_ITEo"><button type=button class="clean-btn tocCollapsibleButton_TO0P">On this page</button></div><div class="theme-doc-markdown markdown"><header><h1>Census American Community Survey (ACS)</h1></header> | |
| <p>Add demographic, economic, housing, and social data from the U.S. Census Bureau's American Community Survey to enrich your civic engagement analysis.</p> | |
| <h2 class="anchor anchorTargetStickyNavbar_Vzrq" id=overview>Overview<a href=#overview class=hash-link aria-label="Direct link to Overview" title="Direct link to Overview" translate=no></a></h2> | |
| <p>The <strong>American Community Survey (ACS)</strong> is the premier source for detailed population and housing information about America. It provides data for communities across the United States, Puerto Rico, and Island Areas.</p> | |
| <h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=whats-included>What's Included<a href=#whats-included class=hash-link aria-label="Direct link to What's Included" title="Direct link to What's Included" translate=no></a></h3> | |
| <ul> | |
| <li class=""><strong>Demographics</strong>: Age, race, ethnicity, language, citizenship</li> | |
| <li class=""><strong>Economics</strong>: Income, poverty, employment, occupation</li> | |
| <li class=""><strong>Housing</strong>: Occupancy, value, rent, housing costs</li> | |
| <li class=""><strong>Education</strong>: School enrollment, educational attainment</li> | |
| <li class=""><strong>Health</strong>: Health insurance coverage by age and type</li> | |
| <li class=""><strong>Social</strong>: Disability status, veteran status, commuting</li> | |
| </ul> | |
| <h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=acs-vs-census-of-governments>ACS vs. Census of Governments<a href=#acs-vs-census-of-governments class=hash-link aria-label="Direct link to ACS vs. Census of Governments" title="Direct link to ACS vs. Census of Governments" translate=no></a></h3> | |
| <table><thead><tr><th>Dataset<th>Purpose<th>What it Measures<tbody><tr><td><strong>Census of Governments</strong><td>Jurisdiction discovery<td>Lists all government entities (cities, counties, districts)<tr><td><strong>American Community Survey (ACS)</strong><td>Community demographics<td>Population characteristics, economics, housing</table> | |
| <p><strong>Use both together</strong>: Census of Governments tells you <em>which</em> jurisdictions exist, ACS tells you <em>about the people</em> who live there.</p> | |
| <h2 class="anchor anchorTargetStickyNavbar_Vzrq" id=-quick-start>🚀 Quick Start<a href=#-quick-start class=hash-link aria-label="Direct link to 🚀 Quick Start" title="Direct link to 🚀 Quick Start" translate=no></a></h2> | |
| <h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=1-get-a-census-api-key-recommended>1. Get a Census API Key (Recommended)<a href=#1-get-a-census-api-key-recommended class=hash-link aria-label="Direct link to 1. Get a Census API Key (Recommended)" title="Direct link to 1. Get a Census API Key (Recommended)" translate=no></a></h3> | |
| <p>While optional, an API key increases your rate limit from 500 to 5,000 requests per day.</p> | |
| <ol> | |
| <li class="">Visit: <a href=https://api.census.gov/data/key_signup.html target=_blank rel="noopener noreferrer" class="">https://api.census.gov/data/key_signup.html</a></li> | |
| <li class="">Enter your email and organization</li> | |
| <li class="">Check email for API key</li> | |
| <li class="">Add to <code>.env</code> file:</li> | |
| </ol> | |
| <div class="language-bash codeBlockContainer_Ckt0 theme-code-block" style=--prism-color:#393A34;--prism-background-color:#f6f8fa><div class=codeBlockContent_QJqH><pre tabindex=0 class="prism-code language-bash codeBlock_bY9V thin-scrollbar" style=color:#393A34;background-color:#f6f8fa><code class=codeBlockLines_e6Vv><div class=token-line style=color:#393A34><span class="token plain">CENSUS_API_KEY=your_key_here</span><br/></div></code></pre></div></div> | |
| <h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=2-run-the-acs-ingestion-script>2. Run the ACS Ingestion Script<a href=#2-run-the-acs-ingestion-script class=hash-link aria-label="Direct link to 2. Run the ACS Ingestion Script" title="Direct link to 2. Run the ACS Ingestion Script" translate=no></a></h3> | |
| <div class="language-bash codeBlockContainer_Ckt0 theme-code-block" style=--prism-color:#393A34;--prism-background-color:#f6f8fa><div class=codeBlockContent_QJqH><pre tabindex=0 class="prism-code language-bash codeBlock_bY9V thin-scrollbar" style=color:#393A34;background-color:#f6f8fa><code class=codeBlockLines_e6Vv><div class=token-line style=color:#393A34><span class="token plain"># Activate virtual environment</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">source .venv/bin/activate</span><br/></div><div class=token-line style=color:#393A34><span class="token plain" style=display:inline-block></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"># Navigate to script directory</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">cd scripts/datasources/census</span><br/></div><div class=token-line style=color:#393A34><span class="token plain" style=display:inline-block></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"># Run the example (downloads sample data)</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">python acs_ingestion.py</span><br/></div></code></pre></div></div> | |
| <p>This will:</p> | |
| <ul> | |
| <li class="">Download median household income for all U.S. counties</li> | |
| <li class="">Download health insurance data for California</li> | |
| <li class="">Cache data to <code>data/cache/acs/</code></li> | |
| </ul> | |
| <h2 class="anchor anchorTargetStickyNavbar_Vzrq" id=-available-data-tables>📊 Available Data Tables<a href=#-available-data-tables class=hash-link aria-label="Direct link to 📊 Available Data Tables" title="Direct link to 📊 Available Data Tables" translate=no></a></h2> | |
| <h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=demographics>Demographics<a href=#demographics class=hash-link aria-label="Direct link to Demographics" title="Direct link to Demographics" translate=no></a></h3> | |
| <table><thead><tr><th>Table Code<th>Description<th>Use Case<tbody><tr><td>B01001<td>Sex by Age<td>Identify communities with children (dental screening priority)<tr><td>B02001<td>Race<td>Analyze health equity across racial groups<tr><td>B03002<td>Hispanic or Latino Origin by Race<td>Understand demographic composition<tr><td>B05001<td>Nativity and Citizenship Status<td>Language access planning<tr><td>B16001<td>Language Spoken at Home<td>Multilingual outreach needs</table> | |
| <h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=economics>Economics<a href=#economics class=hash-link aria-label="Direct link to Economics" title="Direct link to Economics" translate=no></a></h3> | |
| <table><thead><tr><th>Table Code<th>Description<th>Use Case<tbody><tr><td>B19013<td>Median Household Income<td>Target low-income communities for programs<tr><td>B17001<td>Poverty Status<td>Medicaid eligibility analysis<tr><td>B23025<td>Employment Status<td>Economic health assessment<tr><td>C24010<td>Sex by Occupation<td>Workforce composition</table> | |
| <h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=health-insurance--critical-for-oral-health-policy>Health Insurance ⭐ <strong>Critical for Oral Health Policy</strong><a href=#health-insurance--critical-for-oral-health-policy class=hash-link aria-label="Direct link to health-insurance--critical-for-oral-health-policy" title="Direct link to health-insurance--critical-for-oral-health-policy" translate=no></a></h3> | |
| <table><thead><tr><th>Table Code<th>Description<th>Use Case<tbody><tr><td>B27001<td>Health Insurance Coverage Status by Age<td>Overall insurance coverage rates<tr><td>B27010<td>Health Insurance Coverage (Under 19)<td><strong>Child dental insurance coverage</strong><tr><td>C27007<td>Medicaid/Means-Tested Public Coverage<td>Medicaid enrollment by community</table> | |
| <h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=education>Education<a href=#education class=hash-link aria-label="Direct link to Education" title="Direct link to Education" translate=no></a></h3> | |
| <table><thead><tr><th>Table Code<th>Description<th>Use Case<tbody><tr><td>B15003<td>Educational Attainment<td>Community education levels<tr><td>B14001<td>School Enrollment by Age<td>Number of school-aged children</table> | |
| <h2 class="anchor anchorTargetStickyNavbar_Vzrq" id=-usage-examples>💻 Usage Examples<a href=#-usage-examples class=hash-link aria-label="Direct link to 💻 Usage Examples" title="Direct link to 💻 Usage Examples" translate=no></a></h2> | |
| <h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=example-1-download-data-for-all-counties>Example 1: Download Data for All Counties<a href=#example-1-download-data-for-all-counties class=hash-link aria-label="Direct link to Example 1: Download Data for All Counties" title="Direct link to Example 1: Download Data for All Counties" translate=no></a></h3> | |
| <div class="language-python codeBlockContainer_Ckt0 theme-code-block" style=--prism-color:#393A34;--prism-background-color:#f6f8fa><div class=codeBlockContent_QJqH><pre tabindex=0 class="prism-code language-python codeBlock_bY9V thin-scrollbar" style=color:#393A34;background-color:#f6f8fa><code class=codeBlockLines_e6Vv><div class=token-line style=color:#393A34><span class="token keyword" style=color:#00009f>import</span><span class="token plain"> asyncio</span><br/></div><div class=token-line style=color:#393A34><span class="token plain"></span><span class="token keyword" style=color:#00009f>from</span><span class="token plain"> pathlib </span><span class="token keyword" style=color:#00009f>import</span><span class="token plain"> Path</span><br/></div><div class=token-line style=color:#393A34><span class="token plain"></span><span class="token keyword" style=color:#00009f>from</span><span class="token plain"> scripts</span><span class="token punctuation" style=color:#393A34>.</span><span class="token plain">datasources</span><span class="token punctuation" style=color:#393A34>.</span><span class="token plain">census</span><span class="token punctuation" style=color:#393A34>.</span><span class="token plain">acs_ingestion </span><span class="token keyword" style=color:#00009f>import</span><span class="token plain"> ACSDataIngestion</span><br/></div><div class=token-line style=color:#393A34><span class="token plain" style=display:inline-block></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"></span><span class="token keyword" style=color:#00009f>async</span><span class="token plain"> </span><span class="token keyword" style=color:#00009f>def</span><span class="token plain"> </span><span class="token function" style=color:#d73a49>download_county_data</span><span class="token punctuation" style=color:#393A34>(</span><span class="token punctuation" style=color:#393A34>)</span><span class="token punctuation" style=color:#393A34>:</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token comment" style=color:#999988;font-style:italic># Initialize with default cache directory</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> acs </span><span class="token operator" style=color:#393A34>=</span><span class="token plain"> ACSDataIngestion</span><span class="token punctuation" style=color:#393A34>(</span><span class="token punctuation" style=color:#393A34>)</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token comment" style=color:#999988;font-style:italic># Download median household income for all U.S. counties</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> income_df </span><span class="token operator" style=color:#393A34>=</span><span class="token plain"> </span><span class="token keyword" style=color:#00009f>await</span><span class="token plain"> acs</span><span class="token punctuation" style=color:#393A34>.</span><span class="token plain">download_acs_data_api</span><span class="token punctuation" style=color:#393A34>(</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> table</span><span class="token operator" style=color:#393A34>=</span><span class="token string" style=color:#e3116c>"B19013"</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"> </span><span class="token comment" style=color:#999988;font-style:italic># Median household income</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> geography</span><span class="token operator" style=color:#393A34>=</span><span class="token string" style=color:#e3116c>"county"</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"> </span><span class="token comment" style=color:#999988;font-style:italic># County level</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> state</span><span class="token operator" style=color:#393A34>=</span><span class="token string" style=color:#e3116c>"*"</span><span class="token plain"> </span><span class="token comment" style=color:#999988;font-style:italic># All states</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token punctuation" style=color:#393A34>)</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token keyword" style=color:#00009f>print</span><span class="token punctuation" style=color:#393A34>(</span><span class="token string-interpolation string" style=color:#e3116c>f"Downloaded </span><span class="token string-interpolation interpolation punctuation" style=color:#393A34>{</span><span class="token string-interpolation interpolation builtin">len</span><span class="token string-interpolation interpolation punctuation" style=color:#393A34>(</span><span class="token string-interpolation interpolation">income_df</span><span class="token string-interpolation interpolation punctuation" style=color:#393A34>)</span><span class="token string-interpolation interpolation punctuation" style=color:#393A34>}</span><span class="token string-interpolation string" style=color:#e3116c> counties"</span><span class="token punctuation" style=color:#393A34>)</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token keyword" style=color:#00009f>print</span><span class="token punctuation" style=color:#393A34>(</span><span class="token plain">income_df</span><span class="token punctuation" style=color:#393A34>.</span><span class="token plain">head</span><span class="token punctuation" style=color:#393A34>(</span><span class="token punctuation" style=color:#393A34>)</span><span class="token punctuation" style=color:#393A34>)</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain" style=display:inline-block></span><br/></div><div class=token-line style=color:#393A34><span class="token plain">asyncio</span><span class="token punctuation" style=color:#393A34>.</span><span class="token plain">run</span><span class="token punctuation" style=color:#393A34>(</span><span class="token plain">download_county_data</span><span class="token punctuation" style=color:#393A34>(</span><span class="token punctuation" style=color:#393A34>)</span><span class="token punctuation" style=color:#393A34>)</span><br/></div></code></pre></div></div> | |
| <h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=example-2-child-health-insurance-coverage>Example 2: Child Health Insurance Coverage<a href=#example-2-child-health-insurance-coverage class=hash-link aria-label="Direct link to Example 2: Child Health Insurance Coverage" title="Direct link to Example 2: Child Health Insurance Coverage" translate=no></a></h3> | |
| <p><strong>Critical for oral health policy analysis!</strong></p> | |
| <div class="language-python codeBlockContainer_Ckt0 theme-code-block" style=--prism-color:#393A34;--prism-background-color:#f6f8fa><div class=codeBlockContent_QJqH><pre tabindex=0 class="prism-code language-python codeBlock_bY9V thin-scrollbar" style=color:#393A34;background-color:#f6f8fa><code class=codeBlockLines_e6Vv><div class=token-line style=color:#393A34><span class="token keyword" style=color:#00009f>async</span><span class="token plain"> </span><span class="token keyword" style=color:#00009f>def</span><span class="token plain"> </span><span class="token function" style=color:#d73a49>analyze_child_insurance</span><span class="token punctuation" style=color:#393A34>(</span><span class="token punctuation" style=color:#393A34>)</span><span class="token punctuation" style=color:#393A34>:</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> acs </span><span class="token operator" style=color:#393A34>=</span><span class="token plain"> ACSDataIngestion</span><span class="token punctuation" style=color:#393A34>(</span><span class="token punctuation" style=color:#393A34>)</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token comment" style=color:#999988;font-style:italic># Download health insurance for children under 19</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> child_insurance_df </span><span class="token operator" style=color:#393A34>=</span><span class="token plain"> </span><span class="token keyword" style=color:#00009f>await</span><span class="token plain"> acs</span><span class="token punctuation" style=color:#393A34>.</span><span class="token plain">download_acs_data_api</span><span class="token punctuation" style=color:#393A34>(</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> table</span><span class="token operator" style=color:#393A34>=</span><span class="token string" style=color:#e3116c>"B27010"</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"> </span><span class="token comment" style=color:#999988;font-style:italic># Health insurance (Under 19)</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> geography</span><span class="token operator" style=color:#393A34>=</span><span class="token string" style=color:#e3116c>"county"</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> state</span><span class="token operator" style=color:#393A34>=</span><span class="token string" style=color:#e3116c>"*"</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token punctuation" style=color:#393A34>)</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token comment" style=color:#999988;font-style:italic># This table includes:</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token comment" style=color:#999988;font-style:italic># - With health insurance</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token comment" style=color:#999988;font-style:italic># - With public coverage (Medicaid/CHIP)</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token comment" style=color:#999988;font-style:italic># - With private coverage</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token comment" style=color:#999988;font-style:italic># - No health insurance</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token keyword" style=color:#00009f>return</span><span class="token plain"> child_insurance_df</span><br/></div><div class=token-line style=color:#393A34><span class="token plain" style=display:inline-block></span><br/></div><div class=token-line style=color:#393A34><span class="token plain">df </span><span class="token operator" style=color:#393A34>=</span><span class="token plain"> asyncio</span><span class="token punctuation" style=color:#393A34>.</span><span class="token plain">run</span><span class="token punctuation" style=color:#393A34>(</span><span class="token plain">analyze_child_insurance</span><span class="token punctuation" style=color:#393A34>(</span><span class="token punctuation" style=color:#393A34>)</span><span class="token punctuation" style=color:#393A34>)</span><br/></div></code></pre></div></div> | |
| <h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=example-3-download-multiple-tables-at-once>Example 3: Download Multiple Tables at Once<a href=#example-3-download-multiple-tables-at-once class=hash-link aria-label="Direct link to Example 3: Download Multiple Tables at Once" title="Direct link to Example 3: Download Multiple Tables at Once" translate=no></a></h3> | |
| <div class="language-python codeBlockContainer_Ckt0 theme-code-block" style=--prism-color:#393A34;--prism-background-color:#f6f8fa><div class=codeBlockContent_QJqH><pre tabindex=0 class="prism-code language-python codeBlock_bY9V thin-scrollbar" style=color:#393A34;background-color:#f6f8fa><code class=codeBlockLines_e6Vv><div class=token-line style=color:#393A34><span class="token keyword" style=color:#00009f>async</span><span class="token plain"> </span><span class="token keyword" style=color:#00009f>def</span><span class="token plain"> </span><span class="token function" style=color:#d73a49>download_comprehensive_data</span><span class="token punctuation" style=color:#393A34>(</span><span class="token punctuation" style=color:#393A34>)</span><span class="token punctuation" style=color:#393A34>:</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> acs </span><span class="token operator" style=color:#393A34>=</span><span class="token plain"> ACSDataIngestion</span><span class="token punctuation" style=color:#393A34>(</span><span class="token punctuation" style=color:#393A34>)</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token comment" style=color:#999988;font-style:italic># Download all key demographic tables for California</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> ca_data </span><span class="token operator" style=color:#393A34>=</span><span class="token plain"> </span><span class="token keyword" style=color:#00009f>await</span><span class="token plain"> acs</span><span class="token punctuation" style=color:#393A34>.</span><span class="token plain">download_all_demographics</span><span class="token punctuation" style=color:#393A34>(</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> geography</span><span class="token operator" style=color:#393A34>=</span><span class="token string" style=color:#e3116c>"county"</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> state</span><span class="token operator" style=color:#393A34>=</span><span class="token string" style=color:#e3116c>"06"</span><span class="token plain"> </span><span class="token comment" style=color:#999988;font-style:italic># California FIPS code</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token punctuation" style=color:#393A34>)</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token comment" style=color:#999988;font-style:italic># Returns dictionary with multiple DataFrames</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token keyword" style=color:#00009f>for</span><span class="token plain"> table_code</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"> df </span><span class="token keyword" style=color:#00009f>in</span><span class="token plain"> ca_data</span><span class="token punctuation" style=color:#393A34>.</span><span class="token plain">items</span><span class="token punctuation" style=color:#393A34>(</span><span class="token punctuation" style=color:#393A34>)</span><span class="token punctuation" style=color:#393A34>:</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token keyword" style=color:#00009f>print</span><span class="token punctuation" style=color:#393A34>(</span><span class="token string-interpolation string" style=color:#e3116c>f"</span><span class="token string-interpolation interpolation punctuation" style=color:#393A34>{</span><span class="token string-interpolation interpolation">table_code</span><span class="token string-interpolation interpolation punctuation" style=color:#393A34>}</span><span class="token string-interpolation string" style=color:#e3116c>: </span><span class="token string-interpolation interpolation punctuation" style=color:#393A34>{</span><span class="token string-interpolation interpolation builtin">len</span><span class="token string-interpolation interpolation punctuation" style=color:#393A34>(</span><span class="token string-interpolation interpolation">df</span><span class="token string-interpolation interpolation punctuation" style=color:#393A34>)</span><span class="token string-interpolation interpolation punctuation" style=color:#393A34>}</span><span class="token string-interpolation string" style=color:#e3116c> counties"</span><span class="token punctuation" style=color:#393A34>)</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain" style=display:inline-block></span><br/></div><div class=token-line style=color:#393A34><span class="token plain">asyncio</span><span class="token punctuation" style=color:#393A34>.</span><span class="token plain">run</span><span class="token punctuation" style=color:#393A34>(</span><span class="token plain">download_comprehensive_data</span><span class="token punctuation" style=color:#393A34>(</span><span class="token punctuation" style=color:#393A34>)</span><span class="token punctuation" style=color:#393A34>)</span><br/></div></code></pre></div></div> | |
| <h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=example-4-use-cached-data>Example 4: Use Cached Data<a href=#example-4-use-cached-data class=hash-link aria-label="Direct link to Example 4: Use Cached Data" title="Direct link to Example 4: Use Cached Data" translate=no></a></h3> | |
| <div class="language-python codeBlockContainer_Ckt0 theme-code-block" style=--prism-color:#393A34;--prism-background-color:#f6f8fa><div class=codeBlockContent_QJqH><pre tabindex=0 class="prism-code language-python codeBlock_bY9V thin-scrollbar" style=color:#393A34;background-color:#f6f8fa><code class=codeBlockLines_e6Vv><div class=token-line style=color:#393A34><span class="token plain">acs </span><span class="token operator" style=color:#393A34>=</span><span class="token plain"> ACSDataIngestion</span><span class="token punctuation" style=color:#393A34>(</span><span class="token punctuation" style=color:#393A34>)</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain" style=display:inline-block></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"></span><span class="token comment" style=color:#999988;font-style:italic># First call downloads from API</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain">df1 </span><span class="token operator" style=color:#393A34>=</span><span class="token plain"> </span><span class="token keyword" style=color:#00009f>await</span><span class="token plain"> acs</span><span class="token punctuation" style=color:#393A34>.</span><span class="token plain">download_acs_data_api</span><span class="token punctuation" style=color:#393A34>(</span><span class="token string" style=color:#e3116c>"B19013"</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"> </span><span class="token string" style=color:#e3116c>"county"</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"> </span><span class="token string" style=color:#e3116c>"*"</span><span class="token punctuation" style=color:#393A34>)</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain" style=display:inline-block></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"></span><span class="token comment" style=color:#999988;font-style:italic># Subsequent calls use cached Parquet file (instant!)</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain">df2 </span><span class="token operator" style=color:#393A34>=</span><span class="token plain"> acs</span><span class="token punctuation" style=color:#393A34>.</span><span class="token plain">get_cached_data</span><span class="token punctuation" style=color:#393A34>(</span><span class="token string" style=color:#e3116c>"B19013"</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"> </span><span class="token string" style=color:#e3116c>"county"</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"> </span><span class="token string" style=color:#e3116c>"*"</span><span class="token punctuation" style=color:#393A34>)</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain" style=display:inline-block></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"></span><span class="token keyword" style=color:#00009f>print</span><span class="token punctuation" style=color:#393A34>(</span><span class="token string-interpolation string" style=color:#e3116c>f"Same data: </span><span class="token string-interpolation interpolation punctuation" style=color:#393A34>{</span><span class="token string-interpolation interpolation">df1</span><span class="token string-interpolation interpolation punctuation" style=color:#393A34>.</span><span class="token string-interpolation interpolation">equals</span><span class="token string-interpolation interpolation punctuation" style=color:#393A34>(</span><span class="token string-interpolation interpolation">df2</span><span class="token string-interpolation interpolation punctuation" style=color:#393A34>)</span><span class="token string-interpolation interpolation punctuation" style=color:#393A34>}</span><span class="token string-interpolation string" style=color:#e3116c>"</span><span class="token punctuation" style=color:#393A34>)</span><span class="token plain"> </span><span class="token comment" style=color:#999988;font-style:italic># True</span><br/></div></code></pre></div></div> | |
| <h2 class="anchor anchorTargetStickyNavbar_Vzrq" id=️-data-storage-options>🗄️ Data Storage Options<a href=#️-data-storage-options class=hash-link aria-label="Direct link to 🗄️ Data Storage Options" title="Direct link to 🗄️ Data Storage Options" translate=no></a></h2> | |
| <h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=option-1-default-cache-recommended-for-development>Option 1: Default Cache (Recommended for Development)<a href=#option-1-default-cache-recommended-for-development class=hash-link aria-label="Direct link to Option 1: Default Cache (Recommended for Development)" title="Direct link to Option 1: Default Cache (Recommended for Development)" translate=no></a></h3> | |
| <div class="language-python codeBlockContainer_Ckt0 theme-code-block" style=--prism-color:#393A34;--prism-background-color:#f6f8fa><div class=codeBlockContent_QJqH><pre tabindex=0 class="prism-code language-python codeBlock_bY9V thin-scrollbar" style=color:#393A34;background-color:#f6f8fa><code class=codeBlockLines_e6Vv><div class=token-line style=color:#393A34><span class="token comment" style=color:#999988;font-style:italic># Uses data/cache/acs/ in project directory</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain">acs </span><span class="token operator" style=color:#393A34>=</span><span class="token plain"> ACSDataIngestion</span><span class="token punctuation" style=color:#393A34>(</span><span class="token punctuation" style=color:#393A34>)</span><br/></div></code></pre></div></div> | |
| <p><strong>Location</strong>: <code>/home/developer/projects/open-navigator/data/cache/acs/</code></p> | |
| <h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=option-2-d-drive-windows>Option 2: D Drive (Windows)<a href=#option-2-d-drive-windows class=hash-link aria-label="Direct link to Option 2: D Drive (Windows)" title="Direct link to Option 2: D Drive (Windows)" translate=no></a></h3> | |
| <div class="language-python codeBlockContainer_Ckt0 theme-code-block" style=--prism-color:#393A34;--prism-background-color:#f6f8fa><div class=codeBlockContent_QJqH><pre tabindex=0 class="prism-code language-python codeBlock_bY9V thin-scrollbar" style=color:#393A34;background-color:#f6f8fa><code class=codeBlockLines_e6Vv><div class=token-line style=color:#393A34><span class="token keyword" style=color:#00009f>from</span><span class="token plain"> pathlib </span><span class="token keyword" style=color:#00009f>import</span><span class="token plain"> Path</span><br/></div><div class=token-line style=color:#393A34><span class="token plain" style=display:inline-block></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"></span><span class="token comment" style=color:#999988;font-style:italic># Store all ACS data on D drive</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain">acs </span><span class="token operator" style=color:#393A34>=</span><span class="token plain"> ACSDataIngestion</span><span class="token punctuation" style=color:#393A34>(</span><span class="token plain">data_dir</span><span class="token operator" style=color:#393A34>=</span><span class="token plain">Path</span><span class="token punctuation" style=color:#393A34>(</span><span class="token string" style=color:#e3116c>"D:/open-navigator-data/acs"</span><span class="token punctuation" style=color:#393A34>)</span><span class="token punctuation" style=color:#393A34>)</span><br/></div></code></pre></div></div> | |
| <p><strong>Location</strong>: <code>D:\open-navigator-data\acs\</code></p> | |
| <h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=option-3-external-drive-linuxmac>Option 3: External Drive (Linux/Mac)<a href=#option-3-external-drive-linuxmac class=hash-link aria-label="Direct link to Option 3: External Drive (Linux/Mac)" title="Direct link to Option 3: External Drive (Linux/Mac)" translate=no></a></h3> | |
| <div class="language-python codeBlockContainer_Ckt0 theme-code-block" style=--prism-color:#393A34;--prism-background-color:#f6f8fa><div class=codeBlockContent_QJqH><pre tabindex=0 class="prism-code language-python codeBlock_bY9V thin-scrollbar" style=color:#393A34;background-color:#f6f8fa><code class=codeBlockLines_e6Vv><div class=token-line style=color:#393A34><span class="token comment" style=color:#999988;font-style:italic># Mount external drive first, then:</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain">acs </span><span class="token operator" style=color:#393A34>=</span><span class="token plain"> ACSDataIngestion</span><span class="token punctuation" style=color:#393A34>(</span><span class="token plain">data_dir</span><span class="token operator" style=color:#393A34>=</span><span class="token plain">Path</span><span class="token punctuation" style=color:#393A34>(</span><span class="token string" style=color:#e3116c>"/mnt/external/acs-data"</span><span class="token punctuation" style=color:#393A34>)</span><span class="token punctuation" style=color:#393A34>)</span><br/></div></code></pre></div></div> | |
| <p><strong>Location</strong>: <code>/mnt/external/acs-data/</code></p> | |
| <h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=option-4-network-storage>Option 4: Network Storage<a href=#option-4-network-storage class=hash-link aria-label="Direct link to Option 4: Network Storage" title="Direct link to Option 4: Network Storage" translate=no></a></h3> | |
| <div class="language-python codeBlockContainer_Ckt0 theme-code-block" style=--prism-color:#393A34;--prism-background-color:#f6f8fa><div class=codeBlockContent_QJqH><pre tabindex=0 class="prism-code language-python codeBlock_bY9V thin-scrollbar" style=color:#393A34;background-color:#f6f8fa><code class=codeBlockLines_e6Vv><div class=token-line style=color:#393A34><span class="token comment" style=color:#999988;font-style:italic># For shared team access</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain">acs </span><span class="token operator" style=color:#393A34>=</span><span class="token plain"> ACSDataIngestion</span><span class="token punctuation" style=color:#393A34>(</span><span class="token plain">data_dir</span><span class="token operator" style=color:#393A34>=</span><span class="token plain">Path</span><span class="token punctuation" style=color:#393A34>(</span><span class="token string" style=color:#e3116c>"//server/shared/acs"</span><span class="token punctuation" style=color:#393A34>)</span><span class="token punctuation" style=color:#393A34>)</span><br/></div></code></pre></div></div> | |
| <h2 class="anchor anchorTargetStickyNavbar_Vzrq" id=-data-file-format>📁 Data File Format<a href=#-data-file-format class=hash-link aria-label="Direct link to 📁 Data File Format" title="Direct link to 📁 Data File Format" translate=no></a></h2> | |
| <p>Downloaded data is cached as <strong>Parquet files</strong> for fast loading:</p> | |
| <div class="language-text codeBlockContainer_Ckt0 theme-code-block" style=--prism-color:#393A34;--prism-background-color:#f6f8fa><div class=codeBlockContent_QJqH><pre tabindex=0 class="prism-code language-text codeBlock_bY9V thin-scrollbar" style=color:#393A34;background-color:#f6f8fa><code class=codeBlockLines_e6Vv><div class=token-line style=color:#393A34><span class="token plain">data/cache/acs/</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">├── B19013_county_*_2022.parquet # Median income, all counties</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">├── B27010_county_06_2022.parquet # Child insurance, CA only</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">├── B01001_place_*_2022.parquet # Age/sex, all cities</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">└── acs_2022_ALL/ # Bulk download (if used)</span><br/></div></code></pre></div></div> | |
| <p><strong>Parquet advantages</strong>:</p> | |
| <ul> | |
| <li class="">10x smaller than CSV</li> | |
| <li class="">100x faster to load</li> | |
| <li class="">Preserves data types</li> | |
| <li class="">Columnar storage (efficient queries)</li> | |
| </ul> | |
| <h2 class="anchor anchorTargetStickyNavbar_Vzrq" id=-geography-levels>🌍 Geography Levels<a href=#-geography-levels class=hash-link aria-label="Direct link to 🌍 Geography Levels" title="Direct link to 🌍 Geography Levels" translate=no></a></h2> | |
| <p>ACS data is available at multiple geographic levels:</p> | |
| <table><thead><tr><th>Level<th>Code<th>Example<th>Records (approx.)<tbody><tr><td><strong>National</strong><td><code>us</code><td>United States<td>1<tr><td><strong>State</strong><td><code>state</code><td>California, Texas<td>50<tr><td><strong>County</strong><td><code>county</code><td>Los Angeles County<td>3,200<tr><td><strong>Place</strong><td><code>place</code><td>San Francisco city<td>19,500<tr><td><strong>Tract</strong><td><code>tract</code><td>Neighborhood-level<td>85,000<tr><td><strong>County Subdivision</strong><td><code>cousub</code><td>Townships<td>36,000</table> | |
| <p><strong>Choose based on your analysis needs</strong>:</p> | |
| <ul> | |
| <li class=""><strong>State-level</strong>: Policy comparison across states</li> | |
| <li class=""><strong>County-level</strong>: Regional analysis</li> | |
| <li class=""><strong>Place-level</strong>: City-specific programs</li> | |
| <li class=""><strong>Tract-level</strong>: Neighborhood targeting (large datasets!)</li> | |
| </ul> | |
| <h2 class="anchor anchorTargetStickyNavbar_Vzrq" id=-integration-with-open-navigator>🔗 Integration with Open Navigator<a href=#-integration-with-open-navigator class=hash-link aria-label="Direct link to 🔗 Integration with Open Navigator" title="Direct link to 🔗 Integration with Open Navigator" translate=no></a></h2> | |
| <h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=enriching-jurisdiction-data>Enriching Jurisdiction Data<a href=#enriching-jurisdiction-data class=hash-link aria-label="Direct link to Enriching Jurisdiction Data" title="Direct link to Enriching Jurisdiction Data" translate=no></a></h3> | |
| <p>Combine ACS demographics with jurisdiction discovery:</p> | |
| <div class="language-python codeBlockContainer_Ckt0 theme-code-block" style=--prism-color:#393A34;--prism-background-color:#f6f8fa><div class=codeBlockContent_QJqH><pre tabindex=0 class="prism-code language-python codeBlock_bY9V thin-scrollbar" style=color:#393A34;background-color:#f6f8fa><code class=codeBlockLines_e6Vv><div class=token-line style=color:#393A34><span class="token keyword" style=color:#00009f>from</span><span class="token plain"> discovery</span><span class="token punctuation" style=color:#393A34>.</span><span class="token plain">census_ingestion </span><span class="token keyword" style=color:#00009f>import</span><span class="token plain"> CensusGovernmentIngestion</span><br/></div><div class=token-line style=color:#393A34><span class="token plain"></span><span class="token keyword" style=color:#00009f>from</span><span class="token plain"> scripts</span><span class="token punctuation" style=color:#393A34>.</span><span class="token plain">datasources</span><span class="token punctuation" style=color:#393A34>.</span><span class="token plain">census</span><span class="token punctuation" style=color:#393A34>.</span><span class="token plain">acs_ingestion </span><span class="token keyword" style=color:#00009f>import</span><span class="token plain"> ACSDataIngestion</span><br/></div><div class=token-line style=color:#393A34><span class="token plain" style=display:inline-block></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"></span><span class="token comment" style=color:#999988;font-style:italic># Step 1: Get list of all counties</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain">census </span><span class="token operator" style=color:#393A34>=</span><span class="token plain"> CensusGovernmentIngestion</span><span class="token punctuation" style=color:#393A34>(</span><span class="token punctuation" style=color:#393A34>)</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain">counties_df </span><span class="token operator" style=color:#393A34>=</span><span class="token plain"> </span><span class="token keyword" style=color:#00009f>await</span><span class="token plain"> census</span><span class="token punctuation" style=color:#393A34>.</span><span class="token plain">download_census_data</span><span class="token punctuation" style=color:#393A34>(</span><span class="token string" style=color:#e3116c>"counties"</span><span class="token punctuation" style=color:#393A34>)</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain" style=display:inline-block></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"></span><span class="token comment" style=color:#999988;font-style:italic># Step 2: Add demographic data from ACS</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain">acs </span><span class="token operator" style=color:#393A34>=</span><span class="token plain"> ACSDataIngestion</span><span class="token punctuation" style=color:#393A34>(</span><span class="token punctuation" style=color:#393A34>)</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain">demographics </span><span class="token operator" style=color:#393A34>=</span><span class="token plain"> </span><span class="token keyword" style=color:#00009f>await</span><span class="token plain"> acs</span><span class="token punctuation" style=color:#393A34>.</span><span class="token plain">download_acs_data_api</span><span class="token punctuation" style=color:#393A34>(</span><span class="token string" style=color:#e3116c>"B19013"</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"> </span><span class="token string" style=color:#e3116c>"county"</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"> </span><span class="token string" style=color:#e3116c>"*"</span><span class="token punctuation" style=color:#393A34>)</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain" style=display:inline-block></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"></span><span class="token comment" style=color:#999988;font-style:italic># Step 3: Join on FIPS code</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain">enriched </span><span class="token operator" style=color:#393A34>=</span><span class="token plain"> counties_df</span><span class="token punctuation" style=color:#393A34>.</span><span class="token plain">merge</span><span class="token punctuation" style=color:#393A34>(</span><span class="token plain">demographics</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"> on</span><span class="token operator" style=color:#393A34>=</span><span class="token string" style=color:#e3116c>"fips"</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"> how</span><span class="token operator" style=color:#393A34>=</span><span class="token string" style=color:#e3116c>"left"</span><span class="token punctuation" style=color:#393A34>)</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain" style=display:inline-block></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"></span><span class="token comment" style=color:#999988;font-style:italic># Now you have: county name, URL, population, AND median income!</span><br/></div></code></pre></div></div> | |
| <h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=targeting-high-need-communities>Targeting High-Need Communities<a href=#targeting-high-need-communities class=hash-link aria-label="Direct link to Targeting High-Need Communities" title="Direct link to Targeting High-Need Communities" translate=no></a></h3> | |
| <p>Identify counties for oral health program targeting:</p> | |
| <div class="language-python codeBlockContainer_Ckt0 theme-code-block" style=--prism-color:#393A34;--prism-background-color:#f6f8fa><div class=codeBlockContent_QJqH><pre tabindex=0 class="prism-code language-python codeBlock_bY9V thin-scrollbar" style=color:#393A34;background-color:#f6f8fa><code class=codeBlockLines_e6Vv><div class=token-line style=color:#393A34><span class="token keyword" style=color:#00009f>async</span><span class="token plain"> </span><span class="token keyword" style=color:#00009f>def</span><span class="token plain"> </span><span class="token function" style=color:#d73a49>find_high_need_counties</span><span class="token punctuation" style=color:#393A34>(</span><span class="token punctuation" style=color:#393A34>)</span><span class="token punctuation" style=color:#393A34>:</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> acs </span><span class="token operator" style=color:#393A34>=</span><span class="token plain"> ACSDataIngestion</span><span class="token punctuation" style=color:#393A34>(</span><span class="token punctuation" style=color:#393A34>)</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token comment" style=color:#999988;font-style:italic># Get poverty data</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> poverty_df </span><span class="token operator" style=color:#393A34>=</span><span class="token plain"> </span><span class="token keyword" style=color:#00009f>await</span><span class="token plain"> acs</span><span class="token punctuation" style=color:#393A34>.</span><span class="token plain">download_acs_data_api</span><span class="token punctuation" style=color:#393A34>(</span><span class="token string" style=color:#e3116c>"B17001"</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"> </span><span class="token string" style=color:#e3116c>"county"</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"> </span><span class="token string" style=color:#e3116c>"*"</span><span class="token punctuation" style=color:#393A34>)</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token comment" style=color:#999988;font-style:italic># Get child health insurance</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> child_insurance_df </span><span class="token operator" style=color:#393A34>=</span><span class="token plain"> </span><span class="token keyword" style=color:#00009f>await</span><span class="token plain"> acs</span><span class="token punctuation" style=color:#393A34>.</span><span class="token plain">download_acs_data_api</span><span class="token punctuation" style=color:#393A34>(</span><span class="token string" style=color:#e3116c>"B27010"</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"> </span><span class="token string" style=color:#e3116c>"county"</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"> </span><span class="token string" style=color:#e3116c>"*"</span><span class="token punctuation" style=color:#393A34>)</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token comment" style=color:#999988;font-style:italic># Combine datasets</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> combined </span><span class="token operator" style=color:#393A34>=</span><span class="token plain"> poverty_df</span><span class="token punctuation" style=color:#393A34>.</span><span class="token plain">merge</span><span class="token punctuation" style=color:#393A34>(</span><span class="token plain">child_insurance_df</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"> on</span><span class="token operator" style=color:#393A34>=</span><span class="token punctuation" style=color:#393A34>[</span><span class="token string" style=color:#e3116c>"state"</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"> </span><span class="token string" style=color:#e3116c>"county"</span><span class="token punctuation" style=color:#393A34>]</span><span class="token punctuation" style=color:#393A34>)</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token comment" style=color:#999988;font-style:italic># Filter for high poverty + low insurance coverage</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> high_need </span><span class="token operator" style=color:#393A34>=</span><span class="token plain"> combined</span><span class="token punctuation" style=color:#393A34>[</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token punctuation" style=color:#393A34>(</span><span class="token plain">combined</span><span class="token punctuation" style=color:#393A34>[</span><span class="token string" style=color:#e3116c>"poverty_rate"</span><span class="token punctuation" style=color:#393A34>]</span><span class="token plain"> </span><span class="token operator" style=color:#393A34>></span><span class="token plain"> </span><span class="token number" style=color:#36acaa>0.15</span><span class="token punctuation" style=color:#393A34>)</span><span class="token plain"> </span><span class="token operator" style=color:#393A34>&</span><span class="token plain"> </span><span class="token comment" style=color:#999988;font-style:italic># > 15% poverty</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token punctuation" style=color:#393A34>(</span><span class="token plain">combined</span><span class="token punctuation" style=color:#393A34>[</span><span class="token string" style=color:#e3116c>"uninsured_children"</span><span class="token punctuation" style=color:#393A34>]</span><span class="token plain"> </span><span class="token operator" style=color:#393A34>></span><span class="token plain"> </span><span class="token number" style=color:#36acaa>100</span><span class="token punctuation" style=color:#393A34>)</span><span class="token plain"> </span><span class="token comment" style=color:#999988;font-style:italic># > 100 uninsured kids</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token punctuation" style=color:#393A34>]</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token keyword" style=color:#00009f>return</span><span class="token plain"> high_need</span><br/></div></code></pre></div></div> | |
| <h2 class="anchor anchorTargetStickyNavbar_Vzrq" id=-performance-tips>⚡ Performance Tips<a href=#-performance-tips class=hash-link aria-label="Direct link to ⚡ Performance Tips" title="Direct link to ⚡ Performance Tips" translate=no></a></h2> | |
| <h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=1-use-state-filters>1. Use State Filters<a href=#1-use-state-filters class=hash-link aria-label="Direct link to 1. Use State Filters" title="Direct link to 1. Use State Filters" translate=no></a></h3> | |
| <div class="language-python codeBlockContainer_Ckt0 theme-code-block" style=--prism-color:#393A34;--prism-background-color:#f6f8fa><div class=codeBlockContent_QJqH><pre tabindex=0 class="prism-code language-python codeBlock_bY9V thin-scrollbar" style=color:#393A34;background-color:#f6f8fa><code class=codeBlockLines_e6Vv><div class=token-line style=color:#393A34><span class="token comment" style=color:#999988;font-style:italic># ❌ Slow: Downloads all 3,200 counties</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain">all_counties </span><span class="token operator" style=color:#393A34>=</span><span class="token plain"> </span><span class="token keyword" style=color:#00009f>await</span><span class="token plain"> acs</span><span class="token punctuation" style=color:#393A34>.</span><span class="token plain">download_acs_data_api</span><span class="token punctuation" style=color:#393A34>(</span><span class="token string" style=color:#e3116c>"B19013"</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"> </span><span class="token string" style=color:#e3116c>"county"</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"> </span><span class="token string" style=color:#e3116c>"*"</span><span class="token punctuation" style=color:#393A34>)</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain" style=display:inline-block></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"></span><span class="token comment" style=color:#999988;font-style:italic># ✅ Fast: Downloads only California's 58 counties</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain">ca_counties </span><span class="token operator" style=color:#393A34>=</span><span class="token plain"> </span><span class="token keyword" style=color:#00009f>await</span><span class="token plain"> acs</span><span class="token punctuation" style=color:#393A34>.</span><span class="token plain">download_acs_data_api</span><span class="token punctuation" style=color:#393A34>(</span><span class="token string" style=color:#e3116c>"B19013"</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"> </span><span class="token string" style=color:#e3116c>"county"</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"> </span><span class="token string" style=color:#e3116c>"06"</span><span class="token punctuation" style=color:#393A34>)</span><br/></div></code></pre></div></div> | |
| <h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=2-leverage-caching>2. Leverage Caching<a href=#2-leverage-caching class=hash-link aria-label="Direct link to 2. Leverage Caching" title="Direct link to 2. Leverage Caching" translate=no></a></h3> | |
| <div class="language-python codeBlockContainer_Ckt0 theme-code-block" style=--prism-color:#393A34;--prism-background-color:#f6f8fa><div class=codeBlockContent_QJqH><pre tabindex=0 class="prism-code language-python codeBlock_bY9V thin-scrollbar" style=color:#393A34;background-color:#f6f8fa><code class=codeBlockLines_e6Vv><div class=token-line style=color:#393A34><span class="token comment" style=color:#999988;font-style:italic># First run: Downloads from API (slow)</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain">df1 </span><span class="token operator" style=color:#393A34>=</span><span class="token plain"> </span><span class="token keyword" style=color:#00009f>await</span><span class="token plain"> acs</span><span class="token punctuation" style=color:#393A34>.</span><span class="token plain">download_acs_data_api</span><span class="token punctuation" style=color:#393A34>(</span><span class="token string" style=color:#e3116c>"B19013"</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"> </span><span class="token string" style=color:#e3116c>"county"</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"> </span><span class="token string" style=color:#e3116c>"*"</span><span class="token punctuation" style=color:#393A34>)</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain" style=display:inline-block></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"></span><span class="token comment" style=color:#999988;font-style:italic># Second run: Loads from Parquet cache (instant!)</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain">df2 </span><span class="token operator" style=color:#393A34>=</span><span class="token plain"> acs</span><span class="token punctuation" style=color:#393A34>.</span><span class="token plain">get_cached_data</span><span class="token punctuation" style=color:#393A34>(</span><span class="token string" style=color:#e3116c>"B19013"</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"> </span><span class="token string" style=color:#e3116c>"county"</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"> </span><span class="token string" style=color:#e3116c>"*"</span><span class="token punctuation" style=color:#393A34>)</span><br/></div></code></pre></div></div> | |
| <h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=3-download-multiple-tables-in-parallel>3. Download Multiple Tables in Parallel<a href=#3-download-multiple-tables-in-parallel class=hash-link aria-label="Direct link to 3. Download Multiple Tables in Parallel" title="Direct link to 3. Download Multiple Tables in Parallel" translate=no></a></h3> | |
| <div class="language-python codeBlockContainer_Ckt0 theme-code-block" style=--prism-color:#393A34;--prism-background-color:#f6f8fa><div class=codeBlockContent_QJqH><pre tabindex=0 class="prism-code language-python codeBlock_bY9V thin-scrollbar" style=color:#393A34;background-color:#f6f8fa><code class=codeBlockLines_e6Vv><div class=token-line style=color:#393A34><span class="token keyword" style=color:#00009f>async</span><span class="token plain"> </span><span class="token keyword" style=color:#00009f>def</span><span class="token plain"> </span><span class="token function" style=color:#d73a49>parallel_download</span><span class="token punctuation" style=color:#393A34>(</span><span class="token punctuation" style=color:#393A34>)</span><span class="token punctuation" style=color:#393A34>:</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> acs </span><span class="token operator" style=color:#393A34>=</span><span class="token plain"> ACSDataIngestion</span><span class="token punctuation" style=color:#393A34>(</span><span class="token punctuation" style=color:#393A34>)</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token comment" style=color:#999988;font-style:italic># Download 3 tables simultaneously</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> results </span><span class="token operator" style=color:#393A34>=</span><span class="token plain"> </span><span class="token keyword" style=color:#00009f>await</span><span class="token plain"> asyncio</span><span class="token punctuation" style=color:#393A34>.</span><span class="token plain">gather</span><span class="token punctuation" style=color:#393A34>(</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> acs</span><span class="token punctuation" style=color:#393A34>.</span><span class="token plain">download_acs_data_api</span><span class="token punctuation" style=color:#393A34>(</span><span class="token string" style=color:#e3116c>"B19013"</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"> </span><span class="token string" style=color:#e3116c>"county"</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"> </span><span class="token string" style=color:#e3116c>"*"</span><span class="token punctuation" style=color:#393A34>)</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> acs</span><span class="token punctuation" style=color:#393A34>.</span><span class="token plain">download_acs_data_api</span><span class="token punctuation" style=color:#393A34>(</span><span class="token string" style=color:#e3116c>"B27010"</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"> </span><span class="token string" style=color:#e3116c>"county"</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"> </span><span class="token string" style=color:#e3116c>"*"</span><span class="token punctuation" style=color:#393A34>)</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> acs</span><span class="token punctuation" style=color:#393A34>.</span><span class="token plain">download_acs_data_api</span><span class="token punctuation" style=color:#393A34>(</span><span class="token string" style=color:#e3116c>"B17001"</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"> </span><span class="token string" style=color:#e3116c>"county"</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"> </span><span class="token string" style=color:#e3116c>"*"</span><span class="token punctuation" style=color:#393A34>)</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token punctuation" style=color:#393A34>)</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> income_df</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"> insurance_df</span><span class="token punctuation" style=color:#393A34>,</span><span class="token plain"> poverty_df </span><span class="token operator" style=color:#393A34>=</span><span class="token plain"> results</span><br/></div></code></pre></div></div> | |
| <h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=4-avoid-bulk-downloads-unless-necessary>4. Avoid Bulk Downloads (Unless Necessary)<a href=#4-avoid-bulk-downloads-unless-necessary class=hash-link aria-label="Direct link to 4. Avoid Bulk Downloads (Unless Necessary)" title="Direct link to 4. Avoid Bulk Downloads (Unless Necessary)" translate=no></a></h3> | |
| <p>The Census Bureau offers bulk downloads of ALL ACS data:</p> | |
| <div class="language-python codeBlockContainer_Ckt0 theme-code-block" style=--prism-color:#393A34;--prism-background-color:#f6f8fa><div class=codeBlockContent_QJqH><pre tabindex=0 class="prism-code language-python codeBlock_bY9V thin-scrollbar" style=color:#393A34;background-color:#f6f8fa><code class=codeBlockLines_e6Vv><div class=token-line style=color:#393A34><span class="token comment" style=color:#999988;font-style:italic># ⚠️ WARNING: This downloads 15 GB!</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"></span><span class="token keyword" style=color:#00009f>await</span><span class="token plain"> acs</span><span class="token punctuation" style=color:#393A34>.</span><span class="token plain">download_bulk_files</span><span class="token punctuation" style=color:#393A34>(</span><span class="token plain">state</span><span class="token operator" style=color:#393A34>=</span><span class="token string" style=color:#e3116c>"ALL"</span><span class="token punctuation" style=color:#393A34>)</span><br/></div></code></pre></div></div> | |
| <p><strong>Use bulk downloads only if</strong>:</p> | |
| <ul> | |
| <li class="">You need 100+ tables</li> | |
| <li class="">You need tract-level data for entire U.S.</li> | |
| <li class="">You're doing large-scale research</li> | |
| </ul> | |
| <p><strong>Otherwise</strong>: Use targeted API downloads (much faster!)</p> | |
| <h2 class="anchor anchorTargetStickyNavbar_Vzrq" id=-resources>📚 Resources<a href=#-resources class=hash-link aria-label="Direct link to 📚 Resources" title="Direct link to 📚 Resources" translate=no></a></h2> | |
| <h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=official-documentation>Official Documentation<a href=#official-documentation class=hash-link aria-label="Direct link to Official Documentation" title="Direct link to Official Documentation" translate=no></a></h3> | |
| <ul> | |
| <li class=""><strong>ACS Homepage</strong>: <a href=https://www.census.gov/programs-surveys/acs target=_blank rel="noopener noreferrer" class="">https://www.census.gov/programs-surveys/acs</a></li> | |
| <li class=""><strong>Table Shells</strong>: <a href=https://www.census.gov/programs-surveys/acs/technical-documentation/table-shells.html target=_blank rel="noopener noreferrer" class="">https://www.census.gov/programs-surveys/acs/technical-documentation/table-shells.html</a></li> | |
| <li class=""><strong>API Documentation</strong>: <a href=https://www.census.gov/data/developers/data-sets/acs-5year.html target=_blank rel="noopener noreferrer" class="">https://www.census.gov/data/developers/data-sets/acs-5year.html</a></li> | |
| <li class=""><strong>Data Profiles</strong>: <a href=https://www.census.gov/acs/www/data/data-tables-and-tools/data-profiles/ target=_blank rel="noopener noreferrer" class="">https://www.census.gov/acs/www/data/data-tables-and-tools/data-profiles/</a></li> | |
| </ul> | |
| <h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=understanding-acs-data>Understanding ACS Data<a href=#understanding-acs-data class=hash-link aria-label="Direct link to Understanding ACS Data" title="Direct link to Understanding ACS Data" translate=no></a></h3> | |
| <ul> | |
| <li class=""><strong>ACS 101</strong>: <a href=https://www.census.gov/programs-surveys/acs/about.html target=_blank rel="noopener noreferrer" class="">https://www.census.gov/programs-surveys/acs/about.html</a></li> | |
| <li class=""><strong>When to Use ACS vs. Decennial Census</strong>: <a href=https://www.census.gov/programs-surveys/acs/guidance.html target=_blank rel="noopener noreferrer" class="">https://www.census.gov/programs-surveys/acs/guidance.html</a></li> | |
| <li class=""><strong>Margin of Error</strong>: ACS is a sample survey, all estimates have MOE</li> | |
| <li class=""><strong>5-Year vs. 1-Year Estimates</strong>: Use 5-year for small areas (more reliable)</li> | |
| </ul> | |
| <h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=state-fips-codes>State FIPS Codes<a href=#state-fips-codes class=hash-link aria-label="Direct link to State FIPS Codes" title="Direct link to State FIPS Codes" translate=no></a></h3> | |
| <p>Common state codes for API queries:</p> | |
| <table><thead><tr><th>State<th>FIPS<th>State<th>FIPS<tbody><tr><td>Alabama<td>01<td>Montana<td>30<tr><td>Alaska<td>02<td>Nebraska<td>31<tr><td>Arizona<td>04<td>Nevada<td>32<tr><td>Arkansas<td>05<td>New Hampshire<td>33<tr><td>California<td>06<td>New Jersey<td>34<tr><td>Colorado<td>08<td>New Mexico<td>35<tr><td>Connecticut<td>09<td>New York<td>36<tr><td>Delaware<td>10<td>North Carolina<td>37<tr><td>Florida<td>12<td>Ohio<td>39<tr><td>Georgia<td>13<td>Oklahoma<td>40<tr><td>Hawaii<td>15<td>Oregon<td>41<tr><td>Illinois<td>17<td>Pennsylvania<td>42<tr><td>Indiana<td>18<td>Texas<td>48<tr><td>Iowa<td>19<td>Utah<td>49<tr><td>Kansas<td>20<td>Virginia<td>51<tr><td>Louisiana<td>22<td>Washington<td>53<tr><td>Massachusetts<td>25<td>Wisconsin<td>55<tr><td>Michigan<td>26<td><td></table> | |
| <p><strong>Full list</strong>: <a href=https://www.census.gov/library/reference/code-lists/ansi/ansi-codes-for-states.html target=_blank rel="noopener noreferrer" class="">https://www.census.gov/library/reference/code-lists/ansi/ansi-codes-for-states.html</a></p> | |
| <h2 class="anchor anchorTargetStickyNavbar_Vzrq" id=-troubleshooting>🆘 Troubleshooting<a href=#-troubleshooting class=hash-link aria-label="Direct link to 🆘 Troubleshooting" title="Direct link to 🆘 Troubleshooting" translate=no></a></h2> | |
| <h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=api-request-failed-403>"API request failed: 403"<a href=#api-request-failed-403 class=hash-link aria-label='Direct link to "API request failed: 403"' title='Direct link to "API request failed: 403"' translate=no></a></h3> | |
| <p><strong>Cause</strong>: Rate limit exceeded (500 requests/day without API key)</p> | |
| <p><strong>Fix</strong>: Get a Census API key (see Quick Start above)</p> | |
| <h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=module-configsettings-has-no-attribute-census_api_key>"Module 'config.settings' has no attribute 'CENSUS_API_KEY'"<a href=#module-configsettings-has-no-attribute-census_api_key class=hash-link aria-label="Direct link to "Module 'config.settings' has no attribute 'CENSUS_API_KEY'"" title="Direct link to "Module 'config.settings' has no attribute 'CENSUS_API_KEY'"" translate=no></a></h3> | |
| <p><strong>Cause</strong>: API key not set in configuration</p> | |
| <p><strong>Fix</strong>: Add to <code>.env</code> file:</p> | |
| <div class="language-bash codeBlockContainer_Ckt0 theme-code-block" style=--prism-color:#393A34;--prism-background-color:#f6f8fa><div class=codeBlockContent_QJqH><pre tabindex=0 class="prism-code language-bash codeBlock_bY9V thin-scrollbar" style=color:#393A34;background-color:#f6f8fa><code class=codeBlockLines_e6Vv><div class=token-line style=color:#393A34><span class="token plain">CENSUS_API_KEY=your_key_here</span><br/></div></code></pre></div></div> | |
| <h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=no-data-returned-for-this-geography>"No data returned for this geography"<a href=#no-data-returned-for-this-geography class=hash-link aria-label='Direct link to "No data returned for this geography"' title='Direct link to "No data returned for this geography"' translate=no></a></h3> | |
| <p><strong>Cause</strong>: Not all tables are available at all geography levels</p> | |
| <p><strong>Fix</strong>: Check Census API documentation for table availability by geography</p> | |
| <h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=downloads-are-slow>Downloads are slow<a href=#downloads-are-slow class=hash-link aria-label="Direct link to Downloads are slow" title="Direct link to Downloads are slow" translate=no></a></h3> | |
| <p><strong>Solutions</strong>:</p> | |
| <ol> | |
| <li class="">Use state filters instead of <code>"*"</code></li> | |
| <li class="">Use cached data for repeated queries</li> | |
| <li class="">Download during off-peak hours (late night/early morning EST)</li> | |
| <li class="">Consider bulk downloads if you need many tables</li> | |
| </ol> | |
| <h2 class="anchor anchorTargetStickyNavbar_Vzrq" id=-next-steps>🔮 Next Steps<a href=#-next-steps class=hash-link aria-label="Direct link to 🔮 Next Steps" title="Direct link to 🔮 Next Steps" translate=no></a></h2> | |
| <ol> | |
| <li class=""><strong>Explore Available Tables</strong>: Run <code>acs.list_available_tables()</code></li> | |
| <li class=""><strong>Download Sample Data</strong>: Try the examples in this guide</li> | |
| <li class=""><strong>Join with Jurisdictions</strong>: Combine ACS demographics with jurisdiction URLs</li> | |
| <li class=""><strong>Build Dashboards</strong>: Create visualizations of demographic data</li> | |
| <li class=""><strong>Target Programs</strong>: Use poverty/insurance data to prioritize outreach</li> | |
| </ol> | |
| <h2 class="anchor anchorTargetStickyNavbar_Vzrq" id=related-documentation>Related Documentation<a href=#related-documentation class=hash-link aria-label="Direct link to Related Documentation" title="Direct link to Related Documentation" translate=no></a></h2> | |
| <ul> | |
| <li class=""><a class="" href=/docs/data-sources/census-governments.md>Census of Governments</a> - Jurisdiction discovery</li> | |
| <li class=""><a class="" href=/docs/data-sources/citations>Data Sources Overview</a> - All data sources</li> | |
| <li class=""><a class="" href=/docs/deployment/d-drive-configuration>D Drive Configuration</a> - External storage setup</li> | |
| </ul></div><footer class="theme-doc-footer docusaurus-mt-lg"><div class="row margin-top--sm theme-doc-footer-edit-meta-row"><div class="col noPrint_WFHX"><a href=https://github.com/getcommunityone/open-navigator-for-engagement/tree/main/website/docs/data-sources/census-acs.md target=_blank rel="noopener noreferrer" class=theme-edit-this-page><svg fill=currentColor height=20 width=20 viewBox="0 0 40 40" class=iconEdit_Z9Sw aria-hidden=true><g><path d="m34.5 11.7l-3 3.1-6.3-6.3 3.1-3q0.5-0.5 1.2-0.5t1.1 0.5l3.9 3.9q0.5 0.4 0.5 1.1t-0.5 1.2z m-29.5 17.1l18.4-18.5 6.3 6.3-18.4 18.4h-6.3v-6.2z"/></g></svg>Edit this page</a></div><div class="col lastUpdated_JAkA"></div></div></footer></article><nav class="docusaurus-mt-lg pagination-nav" aria-label="Docs pages"></nav></div></div><div class="col col--3"><div class="tableOfContents_bqdL thin-scrollbar theme-doc-toc-desktop"><ul class="table-of-contents table-of-contents__left-border"><li><a href=#overview class="table-of-contents__link toc-highlight">Overview</a><ul><li><a href=#whats-included class="table-of-contents__link toc-highlight">What's Included</a><li><a href=#acs-vs-census-of-governments class="table-of-contents__link toc-highlight">ACS vs. Census of Governments</a></ul><li><a href=#-quick-start class="table-of-contents__link toc-highlight">🚀 Quick Start</a><ul><li><a href=#1-get-a-census-api-key-recommended class="table-of-contents__link toc-highlight">1. Get a Census API Key (Recommended)</a><li><a href=#2-run-the-acs-ingestion-script class="table-of-contents__link toc-highlight">2. Run the ACS Ingestion Script</a></ul><li><a href=#-available-data-tables class="table-of-contents__link toc-highlight">📊 Available Data Tables</a><ul><li><a href=#demographics class="table-of-contents__link toc-highlight">Demographics</a><li><a href=#economics class="table-of-contents__link toc-highlight">Economics</a><li><a href=#health-insurance--critical-for-oral-health-policy class="table-of-contents__link toc-highlight">Health Insurance ⭐ <strong>Critical for Oral Health Policy</strong></a><li><a href=#education class="table-of-contents__link toc-highlight">Education</a></ul><li><a href=#-usage-examples class="table-of-contents__link toc-highlight">💻 Usage Examples</a><ul><li><a href=#example-1-download-data-for-all-counties class="table-of-contents__link toc-highlight">Example 1: Download Data for All Counties</a><li><a href=#example-2-child-health-insurance-coverage class="table-of-contents__link toc-highlight">Example 2: Child Health Insurance Coverage</a><li><a href=#example-3-download-multiple-tables-at-once class="table-of-contents__link toc-highlight">Example 3: Download Multiple Tables at Once</a><li><a href=#example-4-use-cached-data class="table-of-contents__link toc-highlight">Example 4: Use Cached Data</a></ul><li><a href=#️-data-storage-options class="table-of-contents__link toc-highlight">🗄️ Data Storage Options</a><ul><li><a href=#option-1-default-cache-recommended-for-development class="table-of-contents__link toc-highlight">Option 1: Default Cache (Recommended for Development)</a><li><a href=#option-2-d-drive-windows class="table-of-contents__link toc-highlight">Option 2: D Drive (Windows)</a><li><a href=#option-3-external-drive-linuxmac class="table-of-contents__link toc-highlight">Option 3: External Drive (Linux/Mac)</a><li><a href=#option-4-network-storage class="table-of-contents__link toc-highlight">Option 4: Network Storage</a></ul><li><a href=#-data-file-format class="table-of-contents__link toc-highlight">📁 Data File Format</a><li><a href=#-geography-levels class="table-of-contents__link toc-highlight">🌍 Geography Levels</a><li><a href=#-integration-with-open-navigator class="table-of-contents__link toc-highlight">🔗 Integration with Open Navigator</a><ul><li><a href=#enriching-jurisdiction-data class="table-of-contents__link toc-highlight">Enriching Jurisdiction Data</a><li><a href=#targeting-high-need-communities class="table-of-contents__link toc-highlight">Targeting High-Need Communities</a></ul><li><a href=#-performance-tips class="table-of-contents__link toc-highlight">⚡ Performance Tips</a><ul><li><a href=#1-use-state-filters class="table-of-contents__link toc-highlight">1. Use State Filters</a><li><a href=#2-leverage-caching class="table-of-contents__link toc-highlight">2. Leverage Caching</a><li><a href=#3-download-multiple-tables-in-parallel class="table-of-contents__link toc-highlight">3. Download Multiple Tables in Parallel</a><li><a href=#4-avoid-bulk-downloads-unless-necessary class="table-of-contents__link toc-highlight">4. Avoid Bulk Downloads (Unless Necessary)</a></ul><li><a href=#-resources class="table-of-contents__link toc-highlight">📚 Resources</a><ul><li><a href=#official-documentation class="table-of-contents__link toc-highlight">Official Documentation</a><li><a href=#understanding-acs-data class="table-of-contents__link toc-highlight">Understanding ACS Data</a><li><a href=#state-fips-codes class="table-of-contents__link toc-highlight">State FIPS Codes</a></ul><li><a href=#-troubleshooting class="table-of-contents__link toc-highlight">🆘 Troubleshooting</a><ul><li><a href=#api-request-failed-403 class="table-of-contents__link toc-highlight">"API request failed: 403"</a><li><a href=#module-configsettings-has-no-attribute-census_api_key class="table-of-contents__link toc-highlight">"Module 'config.settings' has no attribute 'CENSUS_API_KEY'"</a><li><a href=#no-data-returned-for-this-geography class="table-of-contents__link toc-highlight">"No data returned for this geography"</a><li><a href=#downloads-are-slow class="table-of-contents__link toc-highlight">Downloads are slow</a></ul><li><a href=#-next-steps class="table-of-contents__link toc-highlight">🔮 Next Steps</a><li><a href=#related-documentation class="table-of-contents__link toc-highlight">Related Documentation</a></ul></div></div></div></div></main></div></div></div><footer class="theme-layout-footer footer footer--dark"><div class="container container-fluid"><div class="row footer__links"><div class="theme-layout-footer-column col footer__col"><div class=footer__title>Documentation</div><ul class="footer__items clean-list"><li class=footer__item><a class=footer__link-item href=/docs/intro>Getting Started</a><li class=footer__item><a class=footer__link-item href=/docs/data-sources/citations>Citations & Data Sources</a><li class=footer__item><a class=footer__link-item href=/docs/data-sources/overview>Data Sources</a><li class=footer__item><a class=footer__link-item href=/docs/for-developers>For Developers</a></ul></div><div class="theme-layout-footer-column col footer__col"><div class=footer__title>Resources</div><ul class="footer__items clean-list"><li class=footer__item><a href=https://www.communityone.com target=_blank rel="noopener noreferrer" class=footer__link-item>Launch Open Navigator<svg width=13.5 height=13.5 aria-label="(opens in new tab)" class=iconExternalLink_nPIU><use href=#theme-svg-external-link /></svg></a><li class=footer__item><a href=https://github.com/getcommunityone/open-navigator-for-engagement target=_blank rel="noopener noreferrer" class=footer__link-item>GitHub<svg width=13.5 height=13.5 aria-label="(opens in new tab)" class=iconExternalLink_nPIU><use href=#theme-svg-external-link /></svg></a><li class=footer__item><a href=https://www.groundvue.org/ target=_blank rel="noopener noreferrer" class=footer__link-item>GroundVue (Partner)<svg width=13.5 height=13.5 aria-label="(opens in new tab)" class=iconExternalLink_nPIU><use href=#theme-svg-external-link /></svg></a></ul></div><div class="theme-layout-footer-column col footer__col"><div class=footer__title>Community</div><ul class="footer__items clean-list"><li class=footer__item><a href=https://www.instagram.com/getcommunityone/ target=_blank rel="noopener noreferrer" class=footer__link-item>Instagram<svg width=13.5 height=13.5 aria-label="(opens in new tab)" class=iconExternalLink_nPIU><use href=#theme-svg-external-link /></svg></a><li class=footer__item><a href=https://www.facebook.com/getcommunityone target=_blank rel="noopener noreferrer" class=footer__link-item>Facebook<svg width=13.5 height=13.5 aria-label="(opens in new tab)" class=iconExternalLink_nPIU><use href=#theme-svg-external-link /></svg></a><li class=footer__item><a href=https://x.com/getcommunityone/ target=_blank rel="noopener noreferrer" class=footer__link-item>X (Twitter)<svg width=13.5 height=13.5 aria-label="(opens in new tab)" class=iconExternalLink_nPIU><use href=#theme-svg-external-link /></svg></a><li class=footer__item><a href=https://www.linkedin.com/company/getcommunityone target=_blank rel="noopener noreferrer" class=footer__link-item>LinkedIn<svg width=13.5 height=13.5 aria-label="(opens in new tab)" class=iconExternalLink_nPIU><use href=#theme-svg-external-link /></svg></a><li class=footer__item><a href=https://www.youtube.com/@getcommunityone target=_blank rel="noopener noreferrer" class=footer__link-item>YouTube<svg width=13.5 height=13.5 aria-label="(opens in new tab)" class=iconExternalLink_nPIU><use href=#theme-svg-external-link /></svg></a><li class=footer__item><a href=https://discord.gg/uH6Dytek target=_blank rel="noopener noreferrer" class=footer__link-item>Discord<svg width=13.5 height=13.5 aria-label="(opens in new tab)" class=iconExternalLink_nPIU><use href=#theme-svg-external-link /></svg></a></ul></div><div class="theme-layout-footer-column col footer__col"><div class=footer__title>Legal</div><ul class="footer__items clean-list"><li class=footer__item><a class=footer__link-item href=/docs/legal/privacy-policy>Privacy Policy</a><li class=footer__item><a class=footer__link-item href=/docs/legal/terms-of-service>Terms of Service</a><li class=footer__item><a class=footer__link-item href=/docs/legal/data-provider-terms>Data Provider Terms</a></ul></div><div class="theme-layout-footer-column col footer__col"><div class=footer__title>More</div><ul class="footer__items clean-list"><li class=footer__item><a class=footer__link-item href=/blog>Blog</a><li class=footer__item><a href=https://github.com/getcommunityone/open-navigator-for-engagement/blob/main/LICENSE target=_blank rel="noopener noreferrer" class=footer__link-item>License (MIT)<svg width=13.5 height=13.5 aria-label="(opens in new tab)" class=iconExternalLink_nPIU><use href=#theme-svg-external-link /></svg></a></ul></div></div><div class="footer__bottom text--center"><div class=footer__copyright>Copyright © 2026 Community One. Built with Docusaurus.</div></div></div></footer></div></body> |