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-25 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|
12995 | 12995 | 2020-10-25 | Alabama | 1 | 184355 | 2866 |
12996 | 12996 | 2020-10-25 | Alaska | 2 | 13968 | 64 |
12997 | 12997 | 2020-10-25 | Arizona | 4 | 238200 | 5874 |
12998 | 12998 | 2020-10-25 | Arkansas | 5 | 106115 | 1812 |
12999 | 12999 | 2020-10-25 | California | 6 | 909345 | 17358 |
13000 | 13000 | 2020-10-25 | Colorado | 8 | 95742 | 2244 |
13001 | 13001 | 2020-10-25 | Connecticut | 9 | 66052 | 4577 |
13002 | 13002 | 2020-10-25 | Delaware | 10 | 23961 | 681 |
13003 | 13003 | 2020-10-25 | District of Columbia | 11 | 16767 | 642 |
13004 | 13004 | 2020-10-25 | Florida | 12 | 778628 | 16428 |
13005 | 13005 | 2020-10-25 | Georgia | 13 | 360344 | 7626 |
13006 | 13006 | 2020-10-25 | Guam | 66 | 5185 | 72 |
13007 | 13007 | 2020-10-25 | Hawaii | 15 | 14823 | 211 |
13008 | 13008 | 2020-10-25 | Idaho | 16 | 59344 | 574 |
13009 | 13009 | 2020-10-25 | Illinois | 17 | 380065 | 9788 |
13010 | 13010 | 2020-10-25 | Indiana | 18 | 165038 | 4130 |
13011 | 13011 | 2020-10-25 | Iowa | 19 | 116238 | 1635 |
13012 | 13012 | 2020-10-25 | Kansas | 20 | 78241 | 975 |
13013 | 13013 | 2020-10-25 | Kentucky | 21 | 98730 | 1472 |
13014 | 13014 | 2020-10-25 | Louisiana | 22 | 183575 | 5837 |
13015 | 13015 | 2020-10-25 | Maine | 23 | 6201 | 146 |
13016 | 13016 | 2020-10-25 | Maryland | 24 | 140770 | 4096 |
13017 | 13017 | 2020-10-25 | Massachusetts | 25 | 150565 | 9864 |
13018 | 13018 | 2020-10-25 | Michigan | 26 | 175515 | 7522 |
13019 | 13019 | 2020-10-25 | Minnesota | 27 | 133855 | 2402 |
13020 | 13020 | 2020-10-25 | Mississippi | 28 | 115088 | 3255 |
13021 | 13021 | 2020-10-25 | Missouri | 29 | 175243 | 2857 |
13022 | 13022 | 2020-10-25 | Montana | 30 | 27880 | 298 |
13023 | 13023 | 2020-10-25 | Nebraska | 31 | 63849 | 608 |
13024 | 13024 | 2020-10-25 | Nevada | 32 | 95798 | 1748 |
13025 | 13025 | 2020-10-25 | New Hampshire | 33 | 10328 | 473 |
13026 | 13026 | 2020-10-25 | New Jersey | 34 | 230257 | 16285 |
13027 | 13027 | 2020-10-25 | New Mexico | 35 | 41863 | 967 |
13028 | 13028 | 2020-10-25 | New York | 36 | 500201 | 33059 |
13029 | 13029 | 2020-10-25 | North Carolina | 37 | 260128 | 4183 |
13030 | 13030 | 2020-10-25 | North Dakota | 38 | 37724 | 461 |
13031 | 13031 | 2020-10-25 | Northern Mariana Islands | 69 | 88 | 2 |
13032 | 13032 | 2020-10-25 | Ohio | 39 | 198115 | 5206 |
13033 | 13033 | 2020-10-25 | Oklahoma | 40 | 116736 | 1249 |
13034 | 13034 | 2020-10-25 | Oregon | 41 | 42101 | 654 |
13035 | 13035 | 2020-10-25 | Pennsylvania | 42 | 198756 | 8730 |
13036 | 13036 | 2020-10-25 | Puerto Rico | 72 | 62503 | 801 |
13037 | 13037 | 2020-10-25 | Rhode Island | 44 | 30118 | 1177 |
13038 | 13038 | 2020-10-25 | South Carolina | 45 | 170678 | 3802 |
13039 | 13039 | 2020-10-25 | South Dakota | 46 | 39203 | 375 |
13040 | 13040 | 2020-10-25 | Tennessee | 47 | 243508 | 3105 |
13041 | 13041 | 2020-10-25 | Texas | 48 | 910592 | 18042 |
13042 | 13042 | 2020-10-25 | Utah | 49 | 105053 | 572 |
13043 | 13043 | 2020-10-25 | Vermont | 50 | 2073 | 58 |
13044 | 13044 | 2020-10-25 | Virgin Islands | 78 | 1346 | 21 |
13045 | 13045 | 2020-10-25 | Virginia | 51 | 173371 | 3579 |
13046 | 13046 | 2020-10-25 | Washington | 53 | 107270 | 2396 |
13047 | 13047 | 2020-10-25 | West Virginia | 54 | 21906 | 423 |
13048 | 13048 | 2020-10-25 | Wisconsin | 55 | 208917 | 1814 |
13049 | 13049 | 2020-10-25 | Wyoming | 56 | 11041 | 68 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );