covid_casesdeaths_reshaped_bln

Table actions
Data provided via a collaboration between USAFacts and Big Local News. This is an ongoing effort to collect and distribute county-level data on confirmed coronavirus cases and deaths. Please cite USAFacts as the data provider. The three CSV files are the current version and will be updated daily around 8 a.m. The zipped archives are prior versions with a date stamp of when they were uploaded by Big Local News. See README for additional details

Data source: Big Local News · About: big-local-datasette

1,191,735 rows sorted by State

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid countyFIPS County Name State ▼ stateFIPS date cases deaths
9661 9661 2070 Dillingham Census Area AK 2 1/25/20 0 0
9662 9662 2090 Fairbanks North Star Borough AK 2 1/25/20 0 0
9663 9663 2100 Haines Borough AK 2 1/25/20 0 0
9664 9664 2105 Hoonah-Angoon Census Area AK 2 1/25/20 0 0
9665 9665 2110 City and Borough of Juneau AK 2 1/25/20 0 0
9666 9666 2122 Kenai Peninsula Borough AK 2 1/25/20 0 0
9667 9667 2130 Ketchikan Gateway Borough AK 2 1/25/20 0 0
9668 9668 2150 Kodiak Island Borough AK 2 1/25/20 0 0
9669 9669 2158 Kusilvak Census Area AK 2 1/25/20 0 0
9670 9670 2164 Lake and Peninsula Borough AK 2 1/25/20 0 0
9671 9671 2170 Matanuska-Susitna Borough AK 2 1/25/20 0 0
9672 9672 2180 Nome Census Area AK 2 1/25/20 0 0
9673 9673 2185 North Slope Borough AK 2 1/25/20 0 0
9674 9674 2188 Northwest Arctic Borough AK 2 1/25/20 0 0
9675 9675 2195 Petersburg Census Area AK 2 1/25/20 0 0
9676 9676 2198 Prince of Wales-Hyder Census Area AK 2 1/25/20 0 0
9677 9677 2220 Sitka City and Borough AK 2 1/25/20 0 0
9678 9678 2230 Skagway Municipality AK 2 1/25/20 0 0
9679 9679 2240 Southeast Fairbanks Census Area AK 2 1/25/20 0 0
9680 9680 2261 Valdez-Cordova Census Area AK 2 1/25/20 0 0
9681 9681 2270 Wade Hampton Census Area AK 2 1/25/20 0 0
9682 9682 2275 Wrangell City and Borough AK 2 1/25/20 0 0
9683 9683 2282 Yakutat City and Borough AK 2 1/25/20 0 0
9684 9684 2290 Yukon-Koyukuk Census Area AK 2 1/25/20 0 0
12849 12849 0 Statewide Unallocated AK 2 1/26/20 0 0
12850 12850 2013 Aleutians East Borough AK 2 1/26/20 0 0
12851 12851 2016 Aleutians West Census Area AK 2 1/26/20 0 0
12852 12852 2020 Municipality of Anchorage AK 2 1/26/20 0 0
12853 12853 2050 Bethel Census Area AK 2 1/26/20 0 0
12854 12854 2060 Bristol Bay Borough AK 2 1/26/20 0 0
12855 12855 2068 Denali Borough AK 2 1/26/20 0 0
12856 12856 2070 Dillingham Census Area AK 2 1/26/20 0 0
12857 12857 2090 Fairbanks North Star Borough AK 2 1/26/20 0 0
12858 12858 2100 Haines Borough AK 2 1/26/20 0 0
12859 12859 2105 Hoonah-Angoon Census Area AK 2 1/26/20 0 0
12860 12860 2110 City and Borough of Juneau AK 2 1/26/20 0 0
12861 12861 2122 Kenai Peninsula Borough AK 2 1/26/20 0 0
12862 12862 2130 Ketchikan Gateway Borough AK 2 1/26/20 0 0
12863 12863 2150 Kodiak Island Borough AK 2 1/26/20 0 0
12864 12864 2158 Kusilvak Census Area AK 2 1/26/20 0 0
12865 12865 2164 Lake and Peninsula Borough AK 2 1/26/20 0 0
12866 12866 2170 Matanuska-Susitna Borough AK 2 1/26/20 0 0
12867 12867 2180 Nome Census Area AK 2 1/26/20 0 0
12868 12868 2185 North Slope Borough AK 2 1/26/20 0 0
12869 12869 2188 Northwest Arctic Borough AK 2 1/26/20 0 0
12870 12870 2195 Petersburg Census Area AK 2 1/26/20 0 0
12871 12871 2198 Prince of Wales-Hyder Census Area AK 2 1/26/20 0 0
12872 12872 2220 Sitka City and Borough AK 2 1/26/20 0 0
12873 12873 2230 Skagway Municipality AK 2 1/26/20 0 0
12874 12874 2240 Southeast Fairbanks Census Area AK 2 1/26/20 0 0
12875 12875 2261 Valdez-Cordova Census Area AK 2 1/26/20 0 0
12876 12876 2270 Wade Hampton Census Area AK 2 1/26/20 0 0
12877 12877 2275 Wrangell City and Borough AK 2 1/26/20 0 0
12878 12878 2282 Yakutat City and Borough AK 2 1/26/20 0 0
12879 12879 2290 Yukon-Koyukuk Census Area AK 2 1/26/20 0 0
16044 16044 0 Statewide Unallocated AK 2 1/27/20 0 0
16045 16045 2013 Aleutians East Borough AK 2 1/27/20 0 0
16046 16046 2016 Aleutians West Census Area AK 2 1/27/20 0 0
16047 16047 2020 Municipality of Anchorage AK 2 1/27/20 0 0
16048 16048 2050 Bethel Census Area AK 2 1/27/20 0 0
16049 16049 2060 Bristol Bay Borough AK 2 1/27/20 0 0
16050 16050 2068 Denali Borough AK 2 1/27/20 0 0
16051 16051 2070 Dillingham Census Area AK 2 1/27/20 0 0
16052 16052 2090 Fairbanks North Star Borough AK 2 1/27/20 0 0
16053 16053 2100 Haines Borough AK 2 1/27/20 0 0
16054 16054 2105 Hoonah-Angoon Census Area AK 2 1/27/20 0 0
16055 16055 2110 City and Borough of Juneau AK 2 1/27/20 0 0
16056 16056 2122 Kenai Peninsula Borough AK 2 1/27/20 0 0
16057 16057 2130 Ketchikan Gateway Borough AK 2 1/27/20 0 0
16058 16058 2150 Kodiak Island Borough AK 2 1/27/20 0 0
16059 16059 2158 Kusilvak Census Area AK 2 1/27/20 0 0
16060 16060 2164 Lake and Peninsula Borough AK 2 1/27/20 0 0
16061 16061 2170 Matanuska-Susitna Borough AK 2 1/27/20 0 0
16062 16062 2180 Nome Census Area AK 2 1/27/20 0 0
16063 16063 2185 North Slope Borough AK 2 1/27/20 0 0
16064 16064 2188 Northwest Arctic Borough AK 2 1/27/20 0 0
16065 16065 2195 Petersburg Census Area AK 2 1/27/20 0 0
16066 16066 2198 Prince of Wales-Hyder Census Area AK 2 1/27/20 0 0
16067 16067 2220 Sitka City and Borough AK 2 1/27/20 0 0
16068 16068 2230 Skagway Municipality AK 2 1/27/20 0 0
16069 16069 2240 Southeast Fairbanks Census Area AK 2 1/27/20 0 0
16070 16070 2261 Valdez-Cordova Census Area AK 2 1/27/20 0 0
16071 16071 2270 Wade Hampton Census Area AK 2 1/27/20 0 0
16072 16072 2275 Wrangell City and Borough AK 2 1/27/20 0 0
16073 16073 2282 Yakutat City and Borough AK 2 1/27/20 0 0
16074 16074 2290 Yukon-Koyukuk Census Area AK 2 1/27/20 0 0
19239 19239 0 Statewide Unallocated AK 2 1/28/20 0 0
19240 19240 2013 Aleutians East Borough AK 2 1/28/20 0 0
19241 19241 2016 Aleutians West Census Area AK 2 1/28/20 0 0
19242 19242 2020 Municipality of Anchorage AK 2 1/28/20 0 0
19243 19243 2050 Bethel Census Area AK 2 1/28/20 0 0
19244 19244 2060 Bristol Bay Borough AK 2 1/28/20 0 0
19245 19245 2068 Denali Borough AK 2 1/28/20 0 0
19246 19246 2070 Dillingham Census Area AK 2 1/28/20 0 0
19247 19247 2090 Fairbanks North Star Borough AK 2 1/28/20 0 0
19248 19248 2100 Haines Borough AK 2 1/28/20 0 0
19249 19249 2105 Hoonah-Angoon Census Area AK 2 1/28/20 0 0
19250 19250 2110 City and Borough of Juneau AK 2 1/28/20 0 0
19251 19251 2122 Kenai Peninsula Borough AK 2 1/28/20 0 0
19252 19252 2130 Ketchikan Gateway Borough AK 2 1/28/20 0 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [covid_casesdeaths_reshaped_bln] (
   [countyFIPS] INTEGER,
   [County Name] TEXT,
   [State] TEXT,
   [stateFIPS] INTEGER,
   [date] TEXT,
   [cases] INTEGER,
   [deaths] INTEGER
);