covid_casesdeaths_reshaped_bln
Data source: Big Local News · About: big-local-datasette
1,191,735 rows sorted by countyFIPS
This data as json, copyable, CSV (advanced)
Link | rowid | countyFIPS ▼ | County Name | State | stateFIPS | date | cases | deaths |
---|---|---|---|---|---|---|---|---|
1 | 1 | 0 | Statewide Unallocated | AL | 1 | 1/22/20 | 0 | 0 |
69 | 69 | 0 | Statewide Unallocated | AK | 2 | 1/22/20 | 0 | 0 |
100 | 100 | 0 | Statewide Unallocated | AZ | 4 | 1/22/20 | 0 | 0 |
116 | 116 | 0 | Statewide Unallocated | AR | 5 | 1/22/20 | 0 | 0 |
192 | 192 | 0 | Statewide Unallocated | CA | 6 | 1/22/20 | 0 | 0 |
252 | 252 | 0 | Statewide Unallocated | CO | 8 | 1/22/20 | 0 | 0 |
317 | 317 | 0 | Statewide Unallocated | CT | 9 | 1/22/20 | 0 | 0 |
326 | 326 | 0 | Statewide Unallocated | DE | 10 | 1/22/20 | 0 | 0 |
331 | 331 | 0 | Statewide Unallocated | FL | 12 | 1/22/20 | 0 | 0 |
399 | 399 | 0 | Statewide Unallocated | GA | 13 | 1/22/20 | 0 | 0 |
559 | 559 | 0 | Statewide Unallocated | HI | 15 | 1/22/20 | 0 | 0 |
565 | 565 | 0 | Statewide Unallocated | ID | 16 | 1/22/20 | 0 | 0 |
610 | 610 | 0 | Statewide Unallocated | IL | 17 | 1/22/20 | 0 | 0 |
713 | 713 | 0 | Statewide Unallocated | IN | 18 | 1/22/20 | 0 | 0 |
806 | 806 | 0 | Statewide Unallocated | IA | 19 | 1/22/20 | 0 | 0 |
906 | 906 | 0 | Statewide Unallocated | KS | 20 | 1/22/20 | 0 | 0 |
1012 | 1012 | 0 | Statewide Unallocated | KY | 21 | 1/22/20 | 0 | 0 |
1133 | 1133 | 0 | Statewide Unallocated | LA | 22 | 1/22/20 | 0 | 0 |
1198 | 1198 | 0 | Statewide Unallocated | ME | 23 | 1/22/20 | 0 | 0 |
1215 | 1215 | 0 | Statewide Unallocated | MD | 24 | 1/22/20 | 0 | 0 |
1240 | 1240 | 0 | Statewide Unallocated | MA | 25 | 1/22/20 | 0 | 0 |
1255 | 1255 | 0 | Statewide Unallocated | MI | 26 | 1/22/20 | 0 | 0 |
1339 | 1339 | 0 | Statewide Unallocated | MN | 27 | 1/22/20 | 0 | 0 |
1427 | 1427 | 0 | Statewide Unallocated | MS | 28 | 1/22/20 | 0 | 0 |
1510 | 1510 | 0 | Statewide Unallocated | MO | 29 | 1/22/20 | 0 | 0 |
1626 | 1626 | 0 | Statewide Unallocated | MT | 30 | 1/22/20 | 0 | 0 |
1683 | 1683 | 0 | Statewide Unallocated | NE | 31 | 1/22/20 | 0 | 0 |
1777 | 1777 | 0 | Statewide Unallocated | NV | 32 | 1/22/20 | 0 | 0 |
1795 | 1795 | 0 | Statewide Unallocated | NH | 33 | 1/22/20 | 0 | 0 |
1806 | 1806 | 0 | Statewide Unallocated | NJ | 34 | 1/22/20 | 0 | 0 |
1828 | 1828 | 0 | Statewide Unallocated | NM | 35 | 1/22/20 | 0 | 0 |
1862 | 1862 | 0 | Statewide Unallocated | NY | 36 | 1/22/20 | 0 | 0 |
1926 | 1926 | 0 | Statewide Unallocated | NC | 37 | 1/22/20 | 0 | 0 |
2027 | 2027 | 0 | Statewide Unallocated | ND | 38 | 1/22/20 | 0 | 0 |
2081 | 2081 | 0 | Statewide Unallocated | OH | 39 | 1/22/20 | 0 | 0 |
2170 | 2170 | 0 | Statewide Unallocated | OK | 40 | 1/22/20 | 0 | 0 |
2248 | 2248 | 0 | Statewide Unallocated | OR | 41 | 1/22/20 | 0 | 0 |
2285 | 2285 | 0 | Statewide Unallocated | PA | 42 | 1/22/20 | 0 | 0 |
2353 | 2353 | 0 | Statewide Unallocated | RI | 44 | 1/22/20 | 0 | 0 |
2359 | 2359 | 0 | Statewide Unallocated | SC | 45 | 1/22/20 | 0 | 0 |
2406 | 2406 | 0 | Statewide Unallocated | SD | 46 | 1/22/20 | 0 | 0 |
2473 | 2473 | 0 | Statewide Unallocated | TN | 47 | 1/22/20 | 0 | 0 |
2569 | 2569 | 0 | Statewide Unallocated | TX | 48 | 1/22/20 | 0 | 0 |
2824 | 2824 | 0 | Statewide Unallocated | UT | 49 | 1/22/20 | 0 | 0 |
2854 | 2854 | 0 | Statewide Unallocated | VT | 50 | 1/22/20 | 0 | 0 |
2869 | 2869 | 0 | Statewide Unallocated | VA | 51 | 1/22/20 | 0 | 0 |
3003 | 3003 | 0 | Statewide Unallocated | WA | 53 | 1/22/20 | 0 | 0 |
3043 | 3043 | 0 | Statewide Unallocated | WV | 54 | 1/22/20 | 0 | 0 |
3099 | 3099 | 0 | Statewide Unallocated | WI | 55 | 1/22/20 | 0 | 0 |
3172 | 3172 | 0 | Statewide Unallocated | WY | 56 | 1/22/20 | 0 | 0 |
3196 | 3196 | 0 | Statewide Unallocated | AL | 1 | 1/23/20 | 0 | 0 |
3264 | 3264 | 0 | Statewide Unallocated | AK | 2 | 1/23/20 | 0 | 0 |
3295 | 3295 | 0 | Statewide Unallocated | AZ | 4 | 1/23/20 | 0 | 0 |
3311 | 3311 | 0 | Statewide Unallocated | AR | 5 | 1/23/20 | 0 | 0 |
3387 | 3387 | 0 | Statewide Unallocated | CA | 6 | 1/23/20 | 0 | 0 |
3447 | 3447 | 0 | Statewide Unallocated | CO | 8 | 1/23/20 | 0 | 0 |
3512 | 3512 | 0 | Statewide Unallocated | CT | 9 | 1/23/20 | 0 | 0 |
3521 | 3521 | 0 | Statewide Unallocated | DE | 10 | 1/23/20 | 0 | 0 |
3526 | 3526 | 0 | Statewide Unallocated | FL | 12 | 1/23/20 | 0 | 0 |
3594 | 3594 | 0 | Statewide Unallocated | GA | 13 | 1/23/20 | 0 | 0 |
3754 | 3754 | 0 | Statewide Unallocated | HI | 15 | 1/23/20 | 0 | 0 |
3760 | 3760 | 0 | Statewide Unallocated | ID | 16 | 1/23/20 | 0 | 0 |
3805 | 3805 | 0 | Statewide Unallocated | IL | 17 | 1/23/20 | 0 | 0 |
3908 | 3908 | 0 | Statewide Unallocated | IN | 18 | 1/23/20 | 0 | 0 |
4001 | 4001 | 0 | Statewide Unallocated | IA | 19 | 1/23/20 | 0 | 0 |
4101 | 4101 | 0 | Statewide Unallocated | KS | 20 | 1/23/20 | 0 | 0 |
4207 | 4207 | 0 | Statewide Unallocated | KY | 21 | 1/23/20 | 0 | 0 |
4328 | 4328 | 0 | Statewide Unallocated | LA | 22 | 1/23/20 | 0 | 0 |
4393 | 4393 | 0 | Statewide Unallocated | ME | 23 | 1/23/20 | 0 | 0 |
4410 | 4410 | 0 | Statewide Unallocated | MD | 24 | 1/23/20 | 0 | 0 |
4435 | 4435 | 0 | Statewide Unallocated | MA | 25 | 1/23/20 | 0 | 0 |
4450 | 4450 | 0 | Statewide Unallocated | MI | 26 | 1/23/20 | 0 | 0 |
4534 | 4534 | 0 | Statewide Unallocated | MN | 27 | 1/23/20 | 0 | 0 |
4622 | 4622 | 0 | Statewide Unallocated | MS | 28 | 1/23/20 | 0 | 0 |
4705 | 4705 | 0 | Statewide Unallocated | MO | 29 | 1/23/20 | 0 | 0 |
4821 | 4821 | 0 | Statewide Unallocated | MT | 30 | 1/23/20 | 0 | 0 |
4878 | 4878 | 0 | Statewide Unallocated | NE | 31 | 1/23/20 | 0 | 0 |
4972 | 4972 | 0 | Statewide Unallocated | NV | 32 | 1/23/20 | 0 | 0 |
4990 | 4990 | 0 | Statewide Unallocated | NH | 33 | 1/23/20 | 0 | 0 |
5001 | 5001 | 0 | Statewide Unallocated | NJ | 34 | 1/23/20 | 0 | 0 |
5023 | 5023 | 0 | Statewide Unallocated | NM | 35 | 1/23/20 | 0 | 0 |
5057 | 5057 | 0 | Statewide Unallocated | NY | 36 | 1/23/20 | 0 | 0 |
5121 | 5121 | 0 | Statewide Unallocated | NC | 37 | 1/23/20 | 0 | 0 |
5222 | 5222 | 0 | Statewide Unallocated | ND | 38 | 1/23/20 | 0 | 0 |
5276 | 5276 | 0 | Statewide Unallocated | OH | 39 | 1/23/20 | 0 | 0 |
5365 | 5365 | 0 | Statewide Unallocated | OK | 40 | 1/23/20 | 0 | 0 |
5443 | 5443 | 0 | Statewide Unallocated | OR | 41 | 1/23/20 | 0 | 0 |
5480 | 5480 | 0 | Statewide Unallocated | PA | 42 | 1/23/20 | 0 | 0 |
5548 | 5548 | 0 | Statewide Unallocated | RI | 44 | 1/23/20 | 0 | 0 |
5554 | 5554 | 0 | Statewide Unallocated | SC | 45 | 1/23/20 | 0 | 0 |
5601 | 5601 | 0 | Statewide Unallocated | SD | 46 | 1/23/20 | 0 | 0 |
5668 | 5668 | 0 | Statewide Unallocated | TN | 47 | 1/23/20 | 0 | 0 |
5764 | 5764 | 0 | Statewide Unallocated | TX | 48 | 1/23/20 | 0 | 0 |
6019 | 6019 | 0 | Statewide Unallocated | UT | 49 | 1/23/20 | 0 | 0 |
6049 | 6049 | 0 | Statewide Unallocated | VT | 50 | 1/23/20 | 0 | 0 |
6064 | 6064 | 0 | Statewide Unallocated | VA | 51 | 1/23/20 | 0 | 0 |
6198 | 6198 | 0 | Statewide Unallocated | WA | 53 | 1/23/20 | 0 | 0 |
6238 | 6238 | 0 | Statewide Unallocated | WV | 54 | 1/23/20 | 0 | 0 |
6294 | 6294 | 0 | Statewide Unallocated | WI | 55 | 1/23/20 | 0 | 0 |
6367 | 6367 | 0 | Statewide Unallocated | WY | 56 | 1/23/20 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [covid_casesdeaths_reshaped_bln] ( [countyFIPS] INTEGER, [County Name] TEXT, [State] TEXT, [stateFIPS] INTEGER, [date] TEXT, [cases] INTEGER, [deaths] INTEGER );