county_fips (view)

Data source: Vaccinate The States

3,232 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE VIEW county_fips as
    select
        states.abbreviation as state,
        STATEFP as state_fips,
        STATEFP || COUNTYFP as county_fips,
        counties.NAME as county_name
    from
        counties
        join states on counties.STATEFP = states.fips
    order by
        state,
        county_fips;