us-states
Data source: Big Local News · About: big-local-datasette
11,399 rows sorted by fips
This data as json, copyable, CSV (advanced)
| Link | rowid | date | state | fips ▼ | cases | deaths |
|---|---|---|---|---|---|---|
| 6065 | 6065 | 2020-06-21 | Alabama | 1 | 30021 | 839 |
| 6120 | 6120 | 2020-06-22 | Alabama | 1 | 30454 | 841 |
| 6175 | 6175 | 2020-06-23 | Alabama | 1 | 31097 | 864 |
| 6230 | 6230 | 2020-06-24 | Alabama | 1 | 32064 | 891 |
| 6285 | 6285 | 2020-06-25 | Alabama | 1 | 33206 | 896 |
| 6340 | 6340 | 2020-06-26 | Alabama | 1 | 34183 | 907 |
| 6395 | 6395 | 2020-06-27 | Alabama | 1 | 35083 | 919 |
| 6450 | 6450 | 2020-06-28 | Alabama | 1 | 35441 | 919 |
| 6505 | 6505 | 2020-06-29 | Alabama | 1 | 37175 | 929 |
| 6560 | 6560 | 2020-06-30 | Alabama | 1 | 38045 | 950 |
| 6615 | 6615 | 2020-07-01 | Alabama | 1 | 38962 | 972 |
| 6670 | 6670 | 2020-07-02 | Alabama | 1 | 40111 | 985 |
| 6725 | 6725 | 2020-07-03 | Alabama | 1 | 41865 | 1006 |
| 6780 | 6780 | 2020-07-04 | Alabama | 1 | 42862 | 1007 |
| 6835 | 6835 | 2020-07-05 | Alabama | 1 | 43953 | 1007 |
| 6890 | 6890 | 2020-07-06 | Alabama | 1 | 44878 | 1007 |
| 6945 | 6945 | 2020-07-07 | Alabama | 1 | 45785 | 1033 |
| 7000 | 7000 | 2020-07-08 | Alabama | 1 | 46962 | 1058 |
| 7055 | 7055 | 2020-07-09 | Alabama | 1 | 49174 | 1068 |
| 7110 | 7110 | 2020-07-10 | Alabama | 1 | 50508 | 1104 |
| 7165 | 7165 | 2020-07-11 | Alabama | 1 | 51947 | 1114 |
| 7220 | 7220 | 2020-07-12 | Alabama | 1 | 53587 | 1121 |
| 7275 | 7275 | 2020-07-13 | Alabama | 1 | 55545 | 1124 |
| 7330 | 7330 | 2020-07-14 | Alabama | 1 | 57255 | 1164 |
| 7385 | 7385 | 2020-07-15 | Alabama | 1 | 59067 | 1211 |
| 7440 | 7440 | 2020-07-16 | Alabama | 1 | 61088 | 1230 |
| 7495 | 7495 | 2020-07-17 | Alabama | 1 | 63091 | 1265 |
| 7550 | 7550 | 2020-07-18 | Alabama | 1 | 65234 | 1286 |
| 7605 | 7605 | 2020-07-19 | Alabama | 1 | 67011 | 1287 |
| 7660 | 7660 | 2020-07-20 | Alabama | 1 | 68891 | 1291 |
| 7715 | 7715 | 2020-07-21 | Alabama | 1 | 70358 | 1303 |
| 7770 | 7770 | 2020-07-22 | Alabama | 1 | 71813 | 1364 |
| 7825 | 7825 | 2020-07-23 | Alabama | 1 | 74212 | 1397 |
| 7880 | 7880 | 2020-07-24 | Alabama | 1 | 76005 | 1438 |
| 7935 | 7935 | 2020-07-25 | Alabama | 1 | 78130 | 1456 |
| 7990 | 7990 | 2020-07-26 | Alabama | 1 | 79294 | 1473 |
| 8045 | 8045 | 2020-07-27 | Alabama | 1 | 81115 | 1491 |
| 8100 | 8100 | 2020-07-28 | Alabama | 1 | 82366 | 1491 |
| 8155 | 8155 | 2020-07-29 | Alabama | 1 | 83782 | 1538 |
| 8210 | 8210 | 2020-07-30 | Alabama | 1 | 85762 | 1565 |
| 8265 | 8265 | 2020-07-31 | Alabama | 1 | 87723 | 1580 |
| 8320 | 8320 | 2020-08-01 | Alabama | 1 | 89349 | 1603 |
| 8375 | 8375 | 2020-08-02 | Alabama | 1 | 91444 | 1627 |
| 8430 | 8430 | 2020-08-03 | Alabama | 1 | 92661 | 1633 |
| 8485 | 8485 | 2020-08-04 | Alabama | 1 | 93702 | 1666 |
| 8540 | 8540 | 2020-08-05 | Alabama | 1 | 94654 | 1695 |
| 8595 | 8595 | 2020-08-06 | Alabama | 1 | 96592 | 1714 |
| 8650 | 8650 | 2020-08-07 | Alabama | 1 | 98301 | 1735 |
| 8705 | 8705 | 2020-08-08 | Alabama | 1 | 100173 | 1755 |
| 8760 | 8760 | 2020-08-09 | Alabama | 1 | 101334 | 1768 |
| 8815 | 8815 | 2020-08-10 | Alabama | 1 | 103020 | 1797 |
| 8870 | 8870 | 2020-08-11 | Alabama | 1 | 103851 | 1847 |
| 8925 | 8925 | 2020-08-12 | Alabama | 1 | 104786 | 1882 |
| 8980 | 8980 | 2020-08-13 | Alabama | 1 | 105557 | 1890 |
| 9035 | 9035 | 2020-08-14 | Alabama | 1 | 106309 | 1893 |
| 9090 | 9090 | 2020-08-15 | Alabama | 1 | 107580 | 1896 |
| 9145 | 9145 | 2020-08-16 | Alabama | 1 | 108433 | 1898 |
| 9200 | 9200 | 2020-08-17 | Alabama | 1 | 109004 | 1925 |
| 9255 | 9255 | 2020-08-18 | Alabama | 1 | 110361 | 1936 |
| 9310 | 9310 | 2020-08-19 | Alabama | 1 | 111478 | 1944 |
| 9365 | 9365 | 2020-08-20 | Alabama | 1 | 112449 | 1974 |
| 9420 | 9420 | 2020-08-21 | Alabama | 1 | 113632 | 1996 |
| 9475 | 9475 | 2020-08-22 | Alabama | 1 | 114532 | 2011 |
| 9530 | 9530 | 2020-08-23 | Alabama | 1 | 115060 | 2013 |
| 9585 | 9585 | 2020-08-24 | Alabama | 1 | 116710 | 2024 |
| 9640 | 9640 | 2020-08-25 | Alabama | 1 | 117242 | 2037 |
| 9695 | 9695 | 2020-08-26 | Alabama | 1 | 119254 | 2045 |
| 9750 | 9750 | 2020-08-27 | Alabama | 1 | 121023 | 2076 |
| 9805 | 9805 | 2020-08-28 | Alabama | 1 | 122185 | 2107 |
| 9860 | 9860 | 2020-08-29 | Alabama | 1 | 123889 | 2152 |
| 9915 | 9915 | 2020-08-30 | Alabama | 1 | 125235 | 2162 |
| 9970 | 9970 | 2020-08-31 | Alabama | 1 | 126058 | 2182 |
| 10025 | 10025 | 2020-09-01 | Alabama | 1 | 127616 | 2200 |
| 10080 | 10080 | 2020-09-02 | Alabama | 1 | 128239 | 2217 |
| 10135 | 10135 | 2020-09-03 | Alabama | 1 | 129285 | 2233 |
| 10190 | 10190 | 2020-09-04 | Alabama | 1 | 130393 | 2266 |
| 10245 | 10245 | 2020-09-05 | Alabama | 1 | 131803 | 2275 |
| 10300 | 10300 | 2020-09-06 | Alabama | 1 | 132314 | 2276 |
| 10355 | 10355 | 2020-09-07 | Alabama | 1 | 132973 | 2276 |
| 10410 | 10410 | 2020-09-08 | Alabama | 1 | 133606 | 2277 |
| 10465 | 10465 | 2020-09-09 | Alabama | 1 | 134417 | 2285 |
| 10520 | 10520 | 2020-09-10 | Alabama | 1 | 135565 | 2301 |
| 10575 | 10575 | 2020-09-11 | Alabama | 1 | 136703 | 2333 |
| 10630 | 10630 | 2020-09-12 | Alabama | 1 | 137646 | 2350 |
| 10685 | 10685 | 2020-09-13 | Alabama | 1 | 138755 | 2351 |
| 10740 | 10740 | 2020-09-14 | Alabama | 1 | 139459 | 2355 |
| 10795 | 10795 | 2020-09-15 | Alabama | 1 | 140160 | 2387 |
| 10850 | 10850 | 2020-09-16 | Alabama | 1 | 141087 | 2392 |
| 10905 | 10905 | 2020-09-17 | Alabama | 1 | 141757 | 2401 |
| 10960 | 10960 | 2020-09-18 | Alabama | 1 | 142863 | 2428 |
| 11015 | 11015 | 2020-09-19 | Alabama | 1 | 144164 | 2437 |
| 11070 | 11070 | 2020-09-20 | Alabama | 1 | 144962 | 2437 |
| 11125 | 11125 | 2020-09-21 | Alabama | 1 | 145780 | 2439 |
| 11180 | 11180 | 2020-09-22 | Alabama | 1 | 146584 | 2457 |
| 11235 | 11235 | 2020-09-23 | Alabama | 1 | 147153 | 2488 |
| 11290 | 11290 | 2020-09-24 | Alabama | 1 | 148206 | 2506 |
| 11345 | 11345 | 2020-09-25 | Alabama | 1 | 150658 | 2491 |
| 540 | 540 | 2020-03-12 | Alaska | 2 | 1 | 0 |
| 588 | 588 | 2020-03-13 | Alaska | 2 | 1 | 0 |
| 639 | 639 | 2020-03-14 | Alaska | 2 | 1 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [us-states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );