HRSA
Area Health Resources File
County panel of facilities, doctors, nurse practitioners and physician assistants, shortage flags, and rurality.
Published by HRSA
Finest detail county
Tables 3
How we use this · on 8 desks
“How many doctors and nurse practitioners does this county have?”
Where you'll see it
- CareSite Ops: Facility dossier
- Health Markets: Help, Money and rules, What goes with it
- Health Care Loans & Sales: Facility dossier
- Region Brief: All counties, At a glance, Compare places, Start here, and 3 more
- Disaster Readiness: Build a region, Know the risk
- Rural Development: Check an address, County profile
- Legislative: Help
- Business & Site Planning: Farms & food, Pick a site
- AI & Spreadsheets: at Level 3, link it into Excel or Google Sheets, download it, or ask your AI assistant about it
What we added
- Matched to the same county codes as every other source, so it lines up cleanly with all of them
- Connecticut's new planning regions filled in, where the agency still reports the old counties
- Refreshed every week
Variable list
Sample of 25 rows out of about 157,245
· 14 columns
| release_year | release_label | variable | field_number | data_year | label | characteristics | source | csv_name | col_start | width | decimals | is_char | n_counties |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1999 | 1999-2000 | f00001 | F00001 | No data | Blank | No data | No data | No data | 1 | 1 | 0 | 1 | 0 |
| 1999 | 1999-2000 | f00002 | F00002 | No data | Header - Mod FIPS St & Cty Code | No data | Derived From GSA | No data | 2 | 5 | 0 | 1 | 3082 |
| 1999 | 1999-2000 | f00003 | F00003 | No data | Entity Of File | Equals 'AARF ' | No data | No data | 7 | 5 | 0 | 1 | 3082 |
| 1999 | 1999-2000 | f00004 | F00004 | No data | Secondary Entity Of File | Mod FIPS St & Cty Code | Derived From GSA | No data | 12 | 20 | 0 | 1 | 3082 |
| 1999 | 1999-2000 | f00005 | F00005 | No data | Date Of File | Equals '1999' | No data | No data | 32 | 4 | 0 | 1 | 3082 |
| 1999 | 1999-2000 | f00006 | F00006 | No data | Date Of Creation | Equals '99059' | No data | No data | 36 | 5 | 0 | 0 | 3082 |
| 1999 | 1999-2000 | f00007 | F00007 | No data | File Length | Equals '31615' | No data | No data | 41 | 5 | 0 | 0 | 3082 |
| 1999 | 1999-2000 | f00008 | F00008 | No data | State Name | No data | No data | No data | 46 | 19 | 0 | 1 | 3082 |
| 1999 | 1999-2000 | f00010 | F00010 | No data | County Name | No data | DDH,9-33 | No data | 67 | 25 | 0 | 1 | 3082 |
| 1999 | 1999-2000 | f00011 | F00011 | No data | FIPS State Code | No data | Derived From GSA | No data | 122 | 2 | 0 | 1 | 3082 |
| 1999 | 1999-2000 | f00012 | F00012 | No data | Mod FIPS County Code | Independent Cities Recoded | Derived From GSA | No data | 124 | 3 | 0 | 1 | 3082 |
| 1999 | 1999-2000 | f0001779 | F00017 | 1979 | PSRO Area Code | (Fips St Code + Area Code) | Federal Register | No data | 160 | 4 | 0 | 0 | 3082 |
| 1999 | 1999-2000 | f0002095 | F00020 | 1995 | Rural/Urban Continuum Code | No data | ERS Dept of Agriculture | No data | 241 | 2 | 0 | 1 | 3082 |
| 1999 | 1999-2000 | f00023 | F00023 | No data | Federal Region Code | No data | DHHS | No data | 267 | 2 | 0 | 1 | 3082 |
| 1999 | 1999-2000 | f0008466 | F00084 | 1966 | Active Pharmacists | No data | NCHS Man, 40-45 | No data | 12330 | 6 | 0 | 0 | 3082 |
| 1999 | 1999-2000 | f0008473 | F00084 | 1973 | Active Pharmacists | Active For 1974 | 73-74 Act Pharm Tape | No data | 12324 | 6 | 0 | 0 | 3082 |
| 1999 | 1999-2000 | f0008672 | F00086 | 1972 | Optometrists (Weighted) | Act, Non-Fed, W/Exception | St & Cty Dist Optm | No data | 12402 | 6 | 0 | 0 | 3082 |
| 1999 | 1999-2000 | f0008968 | F00089 | 1968 | Podiatrists, Total | Fed & Non-Fed;Active | NCHS Man, 64-69 | No data | 12430 | 6 | 0 | 0 | 3082 |
| 1999 | 1999-2000 | f0008974 | F00089 | 1974 | Podiatrists (Weighted), Total | Fed & Non-Fed;Active | NCHS Pod Tape | No data | 12424 | 6 | 0 | 0 | 3082 |
| 1999 | 1999-2000 | f0009166 | F00091 | 1966 | Active R.N.'s | No data | NCHS Man,52-57 | No data | 12519 | 6 | 0 | 0 | 3082 |
| 1999 | 1999-2000 | f0009172 | F00091 | 1972 | Active R.N.'s | Total Employed In Nursing | ANA Tape,38-42 | No data | 12513 | 6 | 0 | 0 | 3082 |
| 1999 | 1999-2000 | f0009872 | F00098 | 1972 | Licensed Dental Hygienists | No data | Post,Census Bureau Lic | No data | 12183 | 6 | 0 | 0 | 3082 |
| 1999 | 1999-2000 | f0017970 | F00179 | 1970 | Census Population (100's) | In Hundreds (Total Resident) | Pop, Add Tot In Ranges | No data | 20396 | 7 | 0 | 0 | 3082 |
| 1999 | 1999-2000 | f0020870 | F00208 | 1970 | Census Households (100's) | In Hundreds | '70 Census Of Pop | No data | 23536 | 5 | 0 | 0 | 3082 |
| 1999 | 1999-2000 | f0022070 | F00220 | 1970 | Pers Income, Under $3000 | Families + Unrelated Indiv. | 4th Count Pop | No data | 29004 | 6 | 0 | 0 | 3082 |
Need the whole thing? Spreadsheet links, downloads, and AI access come with Level 3.
See pricing