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 countyFIPS

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid countyFIPS ▼ County Name State stateFIPS date cases deaths
6391 6391 0 Statewide Unallocated AL 1 1/24/20 0 0
6459 6459 0 Statewide Unallocated AK 2 1/24/20 0 0
6490 6490 0 Statewide Unallocated AZ 4 1/24/20 0 0
6506 6506 0 Statewide Unallocated AR 5 1/24/20 0 0
6582 6582 0 Statewide Unallocated CA 6 1/24/20 0 0
6642 6642 0 Statewide Unallocated CO 8 1/24/20 0 0
6707 6707 0 Statewide Unallocated CT 9 1/24/20 0 0
6716 6716 0 Statewide Unallocated DE 10 1/24/20 0 0
6721 6721 0 Statewide Unallocated FL 12 1/24/20 0 0
6789 6789 0 Statewide Unallocated GA 13 1/24/20 0 0
6949 6949 0 Statewide Unallocated HI 15 1/24/20 0 0
6955 6955 0 Statewide Unallocated ID 16 1/24/20 0 0
7000 7000 0 Statewide Unallocated IL 17 1/24/20 0 0
7103 7103 0 Statewide Unallocated IN 18 1/24/20 0 0
7196 7196 0 Statewide Unallocated IA 19 1/24/20 0 0
7296 7296 0 Statewide Unallocated KS 20 1/24/20 0 0
7402 7402 0 Statewide Unallocated KY 21 1/24/20 0 0
7523 7523 0 Statewide Unallocated LA 22 1/24/20 0 0
7588 7588 0 Statewide Unallocated ME 23 1/24/20 0 0
7605 7605 0 Statewide Unallocated MD 24 1/24/20 0 0
7630 7630 0 Statewide Unallocated MA 25 1/24/20 0 0
7645 7645 0 Statewide Unallocated MI 26 1/24/20 0 0
7729 7729 0 Statewide Unallocated MN 27 1/24/20 0 0
7817 7817 0 Statewide Unallocated MS 28 1/24/20 0 0
7900 7900 0 Statewide Unallocated MO 29 1/24/20 0 0
8016 8016 0 Statewide Unallocated MT 30 1/24/20 0 0
8073 8073 0 Statewide Unallocated NE 31 1/24/20 0 0
8167 8167 0 Statewide Unallocated NV 32 1/24/20 0 0
8185 8185 0 Statewide Unallocated NH 33 1/24/20 0 0
8196 8196 0 Statewide Unallocated NJ 34 1/24/20 0 0
8218 8218 0 Statewide Unallocated NM 35 1/24/20 0 0
8252 8252 0 Statewide Unallocated NY 36 1/24/20 0 0
8316 8316 0 Statewide Unallocated NC 37 1/24/20 0 0
8417 8417 0 Statewide Unallocated ND 38 1/24/20 0 0
8471 8471 0 Statewide Unallocated OH 39 1/24/20 0 0
8560 8560 0 Statewide Unallocated OK 40 1/24/20 0 0
8638 8638 0 Statewide Unallocated OR 41 1/24/20 0 0
8675 8675 0 Statewide Unallocated PA 42 1/24/20 0 0
8743 8743 0 Statewide Unallocated RI 44 1/24/20 0 0
8749 8749 0 Statewide Unallocated SC 45 1/24/20 0 0
8796 8796 0 Statewide Unallocated SD 46 1/24/20 0 0
8863 8863 0 Statewide Unallocated TN 47 1/24/20 0 0
8959 8959 0 Statewide Unallocated TX 48 1/24/20 0 0
9214 9214 0 Statewide Unallocated UT 49 1/24/20 0 0
9244 9244 0 Statewide Unallocated VT 50 1/24/20 0 0
9259 9259 0 Statewide Unallocated VA 51 1/24/20 0 0
9393 9393 0 Statewide Unallocated WA 53 1/24/20 0 0
9433 9433 0 Statewide Unallocated WV 54 1/24/20 0 0
9489 9489 0 Statewide Unallocated WI 55 1/24/20 0 0
9562 9562 0 Statewide Unallocated WY 56 1/24/20 0 0
9586 9586 0 Statewide Unallocated AL 1 1/25/20 0 0
9654 9654 0 Statewide Unallocated AK 2 1/25/20 0 0
9685 9685 0 Statewide Unallocated AZ 4 1/25/20 0 0
9701 9701 0 Statewide Unallocated AR 5 1/25/20 0 0
9777 9777 0 Statewide Unallocated CA 6 1/25/20 0 0
9837 9837 0 Statewide Unallocated CO 8 1/25/20 0 0
9902 9902 0 Statewide Unallocated CT 9 1/25/20 0 0
9911 9911 0 Statewide Unallocated DE 10 1/25/20 0 0
9916 9916 0 Statewide Unallocated FL 12 1/25/20 0 0
9984 9984 0 Statewide Unallocated GA 13 1/25/20 0 0
10144 10144 0 Statewide Unallocated HI 15 1/25/20 0 0
10150 10150 0 Statewide Unallocated ID 16 1/25/20 0 0
10195 10195 0 Statewide Unallocated IL 17 1/25/20 0 0
10298 10298 0 Statewide Unallocated IN 18 1/25/20 0 0
10391 10391 0 Statewide Unallocated IA 19 1/25/20 0 0
10491 10491 0 Statewide Unallocated KS 20 1/25/20 0 0
10597 10597 0 Statewide Unallocated KY 21 1/25/20 0 0
10718 10718 0 Statewide Unallocated LA 22 1/25/20 0 0
10783 10783 0 Statewide Unallocated ME 23 1/25/20 0 0
10800 10800 0 Statewide Unallocated MD 24 1/25/20 0 0
10825 10825 0 Statewide Unallocated MA 25 1/25/20 0 0
10840 10840 0 Statewide Unallocated MI 26 1/25/20 0 0
10924 10924 0 Statewide Unallocated MN 27 1/25/20 0 0
11012 11012 0 Statewide Unallocated MS 28 1/25/20 0 0
11095 11095 0 Statewide Unallocated MO 29 1/25/20 0 0
11211 11211 0 Statewide Unallocated MT 30 1/25/20 0 0
11268 11268 0 Statewide Unallocated NE 31 1/25/20 0 0
11362 11362 0 Statewide Unallocated NV 32 1/25/20 0 0
11380 11380 0 Statewide Unallocated NH 33 1/25/20 0 0
11391 11391 0 Statewide Unallocated NJ 34 1/25/20 0 0
11413 11413 0 Statewide Unallocated NM 35 1/25/20 0 0
11447 11447 0 Statewide Unallocated NY 36 1/25/20 0 0
11511 11511 0 Statewide Unallocated NC 37 1/25/20 0 0
11612 11612 0 Statewide Unallocated ND 38 1/25/20 0 0
11666 11666 0 Statewide Unallocated OH 39 1/25/20 0 0
11755 11755 0 Statewide Unallocated OK 40 1/25/20 0 0
11833 11833 0 Statewide Unallocated OR 41 1/25/20 0 0
11870 11870 0 Statewide Unallocated PA 42 1/25/20 0 0
11938 11938 0 Statewide Unallocated RI 44 1/25/20 0 0
11944 11944 0 Statewide Unallocated SC 45 1/25/20 0 0
11991 11991 0 Statewide Unallocated SD 46 1/25/20 0 0
12058 12058 0 Statewide Unallocated TN 47 1/25/20 0 0
12154 12154 0 Statewide Unallocated TX 48 1/25/20 0 0
12409 12409 0 Statewide Unallocated UT 49 1/25/20 0 0
12439 12439 0 Statewide Unallocated VT 50 1/25/20 0 0
12454 12454 0 Statewide Unallocated VA 51 1/25/20 0 0
12588 12588 0 Statewide Unallocated WA 53 1/25/20 0 0
12628 12628 0 Statewide Unallocated WV 54 1/25/20 0 0
12684 12684 0 Statewide Unallocated WI 55 1/25/20 0 0
12757 12757 0 Statewide Unallocated WY 56 1/25/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
);