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-03 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 |
---|---|---|---|---|---|---|
11785 | 11785 | 2020-10-03 | Alabama | 1 | 158380 | 2558 |
11786 | 11786 | 2020-10-03 | Alaska | 2 | 9111 | 54 |
11787 | 11787 | 2020-10-03 | Arizona | 4 | 220403 | 5705 |
11788 | 11788 | 2020-10-03 | Arkansas | 5 | 86525 | 1407 |
11789 | 11789 | 2020-10-03 | California | 6 | 831495 | 16122 |
11790 | 11790 | 2020-10-03 | Colorado | 8 | 72929 | 2071 |
11791 | 11791 | 2020-10-03 | Connecticut | 9 | 58297 | 4513 |
11792 | 11792 | 2020-10-03 | Delaware | 10 | 21125 | 645 |
11793 | 11793 | 2020-10-03 | District of Columbia | 11 | 15473 | 629 |
11794 | 11794 | 2020-10-03 | Florida | 12 | 714583 | 14627 |
11795 | 11795 | 2020-10-03 | Georgia | 13 | 305941 | 6972 |
11796 | 11796 | 2020-10-03 | Guam | 66 | 3668 | 52 |
11797 | 11797 | 2020-10-03 | Hawaii | 15 | 12887 | 152 |
11798 | 11798 | 2020-10-03 | Idaho | 16 | 43702 | 480 |
11799 | 11799 | 2020-10-03 | Illinois | 17 | 303807 | 9033 |
11800 | 11800 | 2020-10-03 | Indiana | 18 | 126414 | 3669 |
11801 | 11801 | 2020-10-03 | Iowa | 19 | 92302 | 1381 |
11802 | 11802 | 2020-10-03 | Kansas | 20 | 62446 | 698 |
11803 | 11803 | 2020-10-03 | Kentucky | 21 | 75576 | 1239 |
11804 | 11804 | 2020-10-03 | Louisiana | 22 | 168826 | 5545 |
11805 | 11805 | 2020-10-03 | Maine | 23 | 5486 | 142 |
11806 | 11806 | 2020-10-03 | Maryland | 24 | 127194 | 3957 |
11807 | 11807 | 2020-10-03 | Massachusetts | 25 | 134303 | 9507 |
11808 | 11808 | 2020-10-03 | Michigan | 26 | 141236 | 7125 |
11809 | 11809 | 2020-10-03 | Minnesota | 27 | 102840 | 2126 |
11810 | 11810 | 2020-10-03 | Mississippi | 28 | 100167 | 3011 |
11811 | 11811 | 2020-10-03 | Missouri | 29 | 134826 | 2220 |
11812 | 11812 | 2020-10-03 | Montana | 30 | 14490 | 186 |
11813 | 11813 | 2020-10-03 | Nebraska | 31 | 47403 | 503 |
11814 | 11814 | 2020-10-03 | Nevada | 32 | 81829 | 1623 |
11815 | 11815 | 2020-10-03 | New Hampshire | 33 | 8597 | 442 |
11816 | 11816 | 2020-10-03 | New Jersey | 34 | 209363 | 16135 |
11817 | 11817 | 2020-10-03 | New Mexico | 35 | 30296 | 890 |
11818 | 11818 | 2020-10-03 | New York | 36 | 468081 | 32794 |
11819 | 11819 | 2020-10-03 | North Carolina | 37 | 217049 | 3647 |
11820 | 11820 | 2020-10-03 | North Dakota | 38 | 23137 | 274 |
11821 | 11821 | 2020-10-03 | Northern Mariana Islands | 69 | 70 | 2 |
11822 | 11822 | 2020-10-03 | Ohio | 39 | 157966 | 4925 |
11823 | 11823 | 2020-10-03 | Oklahoma | 40 | 90748 | 1051 |
11824 | 11824 | 2020-10-03 | Oregon | 41 | 34512 | 572 |
11825 | 11825 | 2020-10-03 | Pennsylvania | 42 | 166270 | 8271 |
11826 | 11826 | 2020-10-03 | Puerto Rico | 72 | 50375 | 681 |
11827 | 11827 | 2020-10-03 | Rhode Island | 44 | 25076 | 1118 |
11828 | 11828 | 2020-10-03 | South Carolina | 45 | 150891 | 3442 |
11829 | 11829 | 2020-10-03 | South Dakota | 46 | 23986 | 248 |
11830 | 11830 | 2020-10-03 | Tennessee | 47 | 196870 | 2534 |
11831 | 11831 | 2020-10-03 | Texas | 48 | 799411 | 16440 |
11832 | 11832 | 2020-10-03 | Utah | 49 | 76231 | 476 |
11833 | 11833 | 2020-10-03 | Vermont | 50 | 1778 | 58 |
11834 | 11834 | 2020-10-03 | Virgin Islands | 78 | 1327 | 20 |
11835 | 11835 | 2020-10-03 | Virginia | 51 | 150803 | 3270 |
11836 | 11836 | 2020-10-03 | Washington | 53 | 93160 | 2238 |
11837 | 11837 | 2020-10-03 | West Virginia | 54 | 16468 | 357 |
11838 | 11838 | 2020-10-03 | Wisconsin | 55 | 138018 | 1383 |
11839 | 11839 | 2020-10-03 | Wyoming | 56 | 6365 | 53 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );