us-states
Data source: Big Local News · About: big-local-datasette
11,399 rows sorted by state
This data as json, copyable, CSV (advanced)
date (date) ✖
- 2020-03-28 55
- 2020-03-29 55
- 2020-03-30 55
- 2020-03-31 55
- 2020-04-01 55
- 2020-04-02 55
- 2020-04-03 55
- 2020-04-04 55
- 2020-04-05 55
- 2020-04-06 55
- 2020-04-07 55
- 2020-04-08 55
- 2020-04-09 55
- 2020-04-10 55
- 2020-04-11 55
- 2020-04-12 55
- 2020-04-13 55
- 2020-04-14 55
- 2020-04-15 55
- 2020-04-16 55
- 2020-04-17 55
- 2020-04-18 55
- 2020-04-19 55
- 2020-04-20 55
- 2020-04-21 55
- 2020-04-22 55
- 2020-04-23 55
- 2020-04-24 55
- 2020-04-25 55
- 2020-04-26 55
- ...
Link | rowid | date | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|
587 | 587 | 2020-03-13 | Alabama | 1 | 6 | 0 |
638 | 638 | 2020-03-14 | Alabama | 1 | 12 | 0 |
690 | 690 | 2020-03-15 | Alabama | 1 | 23 | 0 |
743 | 743 | 2020-03-16 | Alabama | 1 | 29 | 0 |
796 | 796 | 2020-03-17 | Alabama | 1 | 39 | 0 |
850 | 850 | 2020-03-18 | Alabama | 1 | 51 | 0 |
904 | 904 | 2020-03-19 | Alabama | 1 | 78 | 0 |
958 | 958 | 2020-03-20 | Alabama | 1 | 106 | 0 |
1012 | 1012 | 2020-03-21 | Alabama | 1 | 131 | 0 |
1066 | 1066 | 2020-03-22 | Alabama | 1 | 157 | 0 |
1120 | 1120 | 2020-03-23 | Alabama | 1 | 196 | 0 |
1174 | 1174 | 2020-03-24 | Alabama | 1 | 242 | 0 |
1228 | 1228 | 2020-03-25 | Alabama | 1 | 386 | 1 |
1282 | 1282 | 2020-03-26 | Alabama | 1 | 538 | 3 |
1336 | 1336 | 2020-03-27 | Alabama | 1 | 639 | 4 |
1390 | 1390 | 2020-03-28 | Alabama | 1 | 720 | 4 |
1445 | 1445 | 2020-03-29 | Alabama | 1 | 830 | 5 |
1500 | 1500 | 2020-03-30 | Alabama | 1 | 947 | 11 |
1555 | 1555 | 2020-03-31 | Alabama | 1 | 999 | 14 |
1610 | 1610 | 2020-04-01 | Alabama | 1 | 1108 | 28 |
1665 | 1665 | 2020-04-02 | Alabama | 1 | 1270 | 32 |
1720 | 1720 | 2020-04-03 | Alabama | 1 | 1535 | 38 |
1775 | 1775 | 2020-04-04 | Alabama | 1 | 1632 | 44 |
1830 | 1830 | 2020-04-05 | Alabama | 1 | 1840 | 45 |
1885 | 1885 | 2020-04-06 | Alabama | 1 | 2005 | 53 |
1940 | 1940 | 2020-04-07 | Alabama | 1 | 2197 | 64 |
1995 | 1995 | 2020-04-08 | Alabama | 1 | 2498 | 67 |
2050 | 2050 | 2020-04-09 | Alabama | 1 | 2838 | 78 |
2105 | 2105 | 2020-04-10 | Alabama | 1 | 3008 | 80 |
2160 | 2160 | 2020-04-11 | Alabama | 1 | 3262 | 93 |
2215 | 2215 | 2020-04-12 | Alabama | 1 | 3583 | 93 |
2270 | 2270 | 2020-04-13 | Alabama | 1 | 3805 | 104 |
2325 | 2325 | 2020-04-14 | Alabama | 1 | 3953 | 114 |
2380 | 2380 | 2020-04-15 | Alabama | 1 | 4241 | 123 |
2435 | 2435 | 2020-04-16 | Alabama | 1 | 4404 | 137 |
2490 | 2490 | 2020-04-17 | Alabama | 1 | 4572 | 151 |
2545 | 2545 | 2020-04-18 | Alabama | 1 | 4723 | 147 |
2600 | 2600 | 2020-04-19 | Alabama | 1 | 4903 | 160 |
2655 | 2655 | 2020-04-20 | Alabama | 1 | 5078 | 164 |
2710 | 2710 | 2020-04-21 | Alabama | 1 | 5327 | 186 |
2765 | 2765 | 2020-04-22 | Alabama | 1 | 5610 | 201 |
2820 | 2820 | 2020-04-23 | Alabama | 1 | 5832 | 197 |
2875 | 2875 | 2020-04-24 | Alabama | 1 | 6026 | 209 |
2930 | 2930 | 2020-04-25 | Alabama | 1 | 6213 | 213 |
2985 | 2985 | 2020-04-26 | Alabama | 1 | 6421 | 219 |
3040 | 3040 | 2020-04-27 | Alabama | 1 | 6539 | 228 |
3095 | 3095 | 2020-04-28 | Alabama | 1 | 6750 | 242 |
3150 | 3150 | 2020-04-29 | Alabama | 1 | 6925 | 262 |
3205 | 3205 | 2020-04-30 | Alabama | 1 | 7068 | 272 |
3260 | 3260 | 2020-05-01 | Alabama | 1 | 7294 | 289 |
3315 | 3315 | 2020-05-02 | Alabama | 1 | 7611 | 288 |
3370 | 3370 | 2020-05-03 | Alabama | 1 | 7888 | 290 |
3425 | 3425 | 2020-05-04 | Alabama | 1 | 8112 | 298 |
3480 | 3480 | 2020-05-05 | Alabama | 1 | 8437 | 315 |
3535 | 3535 | 2020-05-06 | Alabama | 1 | 8691 | 343 |
3590 | 3590 | 2020-05-07 | Alabama | 1 | 9046 | 369 |
3645 | 3645 | 2020-05-08 | Alabama | 1 | 9385 | 383 |
3700 | 3700 | 2020-05-09 | Alabama | 1 | 9668 | 390 |
3755 | 3755 | 2020-05-10 | Alabama | 1 | 9889 | 393 |
3810 | 3810 | 2020-05-11 | Alabama | 1 | 10164 | 403 |
3865 | 3865 | 2020-05-12 | Alabama | 1 | 10464 | 435 |
3920 | 3920 | 2020-05-13 | Alabama | 1 | 10700 | 450 |
3975 | 3975 | 2020-05-14 | Alabama | 1 | 11101 | 473 |
4030 | 4030 | 2020-05-15 | Alabama | 1 | 11373 | 483 |
4085 | 4085 | 2020-05-16 | Alabama | 1 | 11674 | 485 |
4140 | 4140 | 2020-05-17 | Alabama | 1 | 11771 | 488 |
4195 | 4195 | 2020-05-18 | Alabama | 1 | 12086 | 489 |
4250 | 4250 | 2020-05-19 | Alabama | 1 | 12376 | 504 |
4305 | 4305 | 2020-05-20 | Alabama | 1 | 13052 | 522 |
4360 | 4360 | 2020-05-21 | Alabama | 1 | 13414 | 529 |
4415 | 4415 | 2020-05-22 | Alabama | 1 | 13670 | 541 |
4470 | 4470 | 2020-05-23 | Alabama | 1 | 14149 | 549 |
4525 | 4525 | 2020-05-24 | Alabama | 1 | 14478 | 551 |
4580 | 4580 | 2020-05-25 | Alabama | 1 | 14986 | 566 |
4635 | 4635 | 2020-05-26 | Alabama | 1 | 15650 | 580 |
4690 | 4690 | 2020-05-27 | Alabama | 1 | 16032 | 583 |
4745 | 4745 | 2020-05-28 | Alabama | 1 | 16530 | 591 |
4800 | 4800 | 2020-05-29 | Alabama | 1 | 17031 | 610 |
4855 | 4855 | 2020-05-30 | Alabama | 1 | 17359 | 618 |
4910 | 4910 | 2020-05-31 | Alabama | 1 | 17952 | 630 |
4965 | 4965 | 2020-06-01 | Alabama | 1 | 18534 | 646 |
5020 | 5020 | 2020-06-02 | Alabama | 1 | 18771 | 653 |
5075 | 5075 | 2020-06-03 | Alabama | 1 | 18851 | 653 |
5130 | 5130 | 2020-06-04 | Alabama | 1 | 19072 | 653 |
5185 | 5185 | 2020-06-05 | Alabama | 1 | 19387 | 676 |
5240 | 5240 | 2020-06-06 | Alabama | 1 | 20043 | 689 |
5295 | 5295 | 2020-06-07 | Alabama | 1 | 20500 | 692 |
5350 | 5350 | 2020-06-08 | Alabama | 1 | 20925 | 718 |
5405 | 5405 | 2020-06-09 | Alabama | 1 | 21422 | 729 |
5460 | 5460 | 2020-06-10 | Alabama | 1 | 21989 | 744 |
5515 | 5515 | 2020-06-11 | Alabama | 1 | 22845 | 755 |
5570 | 5570 | 2020-06-12 | Alabama | 1 | 23710 | 769 |
5625 | 5625 | 2020-06-13 | Alabama | 1 | 24601 | 773 |
5680 | 5680 | 2020-06-14 | Alabama | 1 | 25615 | 773 |
5735 | 5735 | 2020-06-15 | Alabama | 1 | 26272 | 774 |
5790 | 5790 | 2020-06-16 | Alabama | 1 | 26912 | 785 |
5845 | 5845 | 2020-06-17 | Alabama | 1 | 27312 | 790 |
5900 | 5900 | 2020-06-18 | Alabama | 1 | 28206 | 810 |
5955 | 5955 | 2020-06-19 | Alabama | 1 | 29002 | 822 |
6010 | 6010 | 2020-06-20 | Alabama | 1 | 29549 | 838 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [us-states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );