ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where "date" is on date 2020-10-21 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- Alabama 1
- Alaska 1
- Arizona 1
- Arkansas 1
- California 1
- Colorado 1
- Connecticut 1
- Delaware 1
- District of Columbia 1
- Florida 1
- Georgia 1
- Guam 1
- Hawaii 1
- Idaho 1
- Illinois 1
- Indiana 1
- Iowa 1
- Kansas 1
- Kentucky 1
- Louisiana 1
- Maine 1
- Maryland 1
- Massachusetts 1
- Michigan 1
- Minnesota 1
- Mississippi 1
- Missouri 1
- Montana 1
- Nebraska 1
- Nevada 1
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
12775 | 12775 | 2020-10-21 | Alabama | 1 | 175674 | 2828 |
12776 | 12776 | 2020-10-21 | Alaska | 2 | 12559 | 64 |
12777 | 12777 | 2020-10-21 | Arizona | 4 | 233948 | 5854 |
12778 | 12778 | 2020-10-21 | Arkansas | 5 | 101596 | 1751 |
12779 | 12779 | 2020-10-21 | California | 6 | 890154 | 17189 |
12780 | 12780 | 2020-10-21 | Colorado | 8 | 89245 | 2220 |
12781 | 12781 | 2020-10-21 | Connecticut | 9 | 64871 | 4567 |
12782 | 12782 | 2020-10-21 | Delaware | 10 | 23375 | 670 |
12783 | 12783 | 2020-10-21 | District of Columbia | 11 | 16498 | 642 |
12784 | 12784 | 2020-10-21 | Florida | 12 | 762525 | 16209 |
12785 | 12785 | 2020-10-21 | Georgia | 13 | 353449 | 7523 |
12786 | 12786 | 2020-10-21 | Guam | 66 | 4937 | 69 |
12787 | 12787 | 2020-10-21 | Hawaii | 15 | 14379 | 202 |
12788 | 12788 | 2020-10-21 | Idaho | 16 | 55922 | 551 |
12789 | 12789 | 2020-10-21 | Illinois | 17 | 360160 | 9622 |
12790 | 12790 | 2020-10-21 | Indiana | 18 | 154822 | 4023 |
12791 | 12791 | 2020-10-21 | Iowa | 19 | 110444 | 1594 |
12792 | 12792 | 2020-10-21 | Kansas | 20 | 76299 | 952 |
12793 | 12793 | 2020-10-21 | Kentucky | 21 | 93110 | 1424 |
12794 | 12794 | 2020-10-21 | Louisiana | 22 | 181132 | 5790 |
12795 | 12795 | 2020-10-21 | Maine | 23 | 6027 | 146 |
12796 | 12796 | 2020-10-21 | Maryland | 24 | 137720 | 4058 |
12797 | 12797 | 2020-10-21 | Massachusetts | 25 | 146166 | 9780 |
12798 | 12798 | 2020-10-21 | Michigan | 26 | 167857 | 7420 |
12799 | 12799 | 2020-10-21 | Minnesota | 27 | 126644 | 2334 |
12800 | 12800 | 2020-10-21 | Mississippi | 28 | 112123 | 3223 |
12801 | 12801 | 2020-10-21 | Missouri | 29 | 167435 | 2716 |
12802 | 12802 | 2020-10-21 | Montana | 30 | 24818 | 276 |
12803 | 12803 | 2020-10-21 | Nebraska | 31 | 60308 | 586 |
12804 | 12804 | 2020-10-21 | Nevada | 32 | 92193 | 1735 |
12805 | 12805 | 2020-10-21 | New Hampshire | 33 | 9917 | 469 |
12806 | 12806 | 2020-10-21 | New Jersey | 34 | 225012 | 16245 |
12807 | 12807 | 2020-10-21 | New Mexico | 35 | 38715 | 950 |
12808 | 12808 | 2020-10-21 | New York | 36 | 493245 | 33005 |
12809 | 12809 | 2020-10-21 | North Carolina | 37 | 251010 | 4063 |
12810 | 12810 | 2020-10-21 | North Dakota | 38 | 34170 | 427 |
12811 | 12811 | 2020-10-21 | Northern Mariana Islands | 69 | 88 | 2 |
12812 | 12812 | 2020-10-21 | Ohio | 39 | 188005 | 5149 |
12813 | 12813 | 2020-10-21 | Oklahoma | 40 | 110855 | 1210 |
12814 | 12814 | 2020-10-21 | Oregon | 41 | 40458 | 638 |
12815 | 12815 | 2020-10-21 | Pennsylvania | 42 | 191347 | 8629 |
12816 | 12816 | 2020-10-21 | Puerto Rico | 72 | 58830 | 774 |
12817 | 12817 | 2020-10-21 | Rhode Island | 44 | 29123 | 1169 |
12818 | 12818 | 2020-10-21 | South Carolina | 45 | 166357 | 3708 |
12819 | 12819 | 2020-10-21 | South Dakota | 46 | 35044 | 333 |
12820 | 12820 | 2020-10-21 | Tennessee | 47 | 232100 | 2946 |
12821 | 12821 | 2020-10-21 | Texas | 48 | 886421 | 17743 |
12822 | 12822 | 2020-10-21 | Utah | 49 | 98037 | 558 |
12823 | 12823 | 2020-10-21 | Vermont | 50 | 1971 | 58 |
12824 | 12824 | 2020-10-21 | Virgin Islands | 78 | 1337 | 21 |
12825 | 12825 | 2020-10-21 | Virginia | 51 | 168772 | 3515 |
12826 | 12826 | 2020-10-21 | Washington | 53 | 104624 | 2384 |
12827 | 12827 | 2020-10-21 | West Virginia | 54 | 20734 | 413 |
12828 | 12828 | 2020-10-21 | Wisconsin | 55 | 192225 | 1707 |
12829 | 12829 | 2020-10-21 | Wyoming | 56 | 9848 | 61 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );