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-11-20 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 |
---|---|---|---|---|---|---|
14425 | 14425 | 2020-11-20 | Alabama | 1 | 228373 | 3451 |
14426 | 14426 | 2020-11-20 | Alaska | 2 | 26403 | 95 |
14427 | 14427 | 2020-11-20 | Arizona | 4 | 292880 | 6427 |
14428 | 14428 | 2020-11-20 | Arkansas | 5 | 141916 | 2321 |
14429 | 14429 | 2020-11-20 | California | 6 | 1096427 | 18649 |
14430 | 14430 | 2020-11-20 | Colorado | 8 | 190100 | 2752 |
14431 | 14431 | 2020-11-20 | Connecticut | 9 | 101469 | 4828 |
14432 | 14432 | 2020-11-20 | Delaware | 10 | 30816 | 746 |
14433 | 14433 | 2020-11-20 | District of Columbia | 11 | 19808 | 669 |
14434 | 14434 | 2020-11-20 | Florida | 12 | 923410 | 17888 |
14435 | 14435 | 2020-11-20 | Georgia | 13 | 424759 | 8904 |
14436 | 14436 | 2020-11-20 | Guam | 66 | 7421 | 104 |
14437 | 14437 | 2020-11-20 | Hawaii | 15 | 17029 | 222 |
14438 | 14438 | 2020-11-20 | Idaho | 16 | 90346 | 849 |
14439 | 14439 | 2020-11-20 | Illinois | 17 | 635823 | 11814 |
14440 | 14440 | 2020-11-20 | Indiana | 18 | 284960 | 5206 |
14441 | 14441 | 2020-11-20 | Iowa | 19 | 205918 | 2159 |
14442 | 14442 | 2020-11-20 | Kansas | 20 | 137224 | 1410 |
14443 | 14443 | 2020-11-20 | Kentucky | 21 | 155625 | 1862 |
14444 | 14444 | 2020-11-20 | Louisiana | 22 | 216709 | 6233 |
14445 | 14445 | 2020-11-20 | Maine | 23 | 9958 | 173 |
14446 | 14446 | 2020-11-20 | Maryland | 24 | 177239 | 4398 |
14447 | 14447 | 2020-11-20 | Massachusetts | 25 | 200949 | 10469 |
14448 | 14448 | 2020-11-20 | Michigan | 26 | 320621 | 8776 |
14449 | 14449 | 2020-11-20 | Minnesota | 27 | 256756 | 3206 |
14450 | 14450 | 2020-11-20 | Mississippi | 28 | 140429 | 3642 |
14451 | 14451 | 2020-11-20 | Missouri | 29 | 275917 | 3675 |
14452 | 14452 | 2020-11-20 | Montana | 30 | 53346 | 575 |
14453 | 14453 | 2020-11-20 | Nebraska | 31 | 111915 | 925 |
14454 | 14454 | 2020-11-20 | Nevada | 32 | 130102 | 1987 |
14455 | 14455 | 2020-11-20 | New Hampshire | 33 | 16797 | 507 |
14456 | 14456 | 2020-11-20 | New Jersey | 34 | 299182 | 16712 |
14457 | 14457 | 2020-11-20 | New Mexico | 35 | 77098 | 1327 |
14458 | 14458 | 2020-11-20 | New York | 36 | 589605 | 33696 |
14459 | 14459 | 2020-11-20 | North Carolina | 37 | 330021 | 5012 |
14460 | 14460 | 2020-11-20 | North Dakota | 38 | 70022 | 824 |
14461 | 14461 | 2020-11-20 | Northern Mariana Islands | 69 | 103 | 2 |
14462 | 14462 | 2020-11-20 | Ohio | 39 | 335423 | 5955 |
14463 | 14463 | 2020-11-20 | Oklahoma | 40 | 167261 | 1603 |
14464 | 14464 | 2020-11-20 | Oregon | 41 | 62176 | 815 |
14465 | 14465 | 2020-11-20 | Pennsylvania | 42 | 301373 | 9748 |
14466 | 14466 | 2020-11-20 | Puerto Rico | 72 | 78950 | 991 |
14467 | 14467 | 2020-11-20 | Rhode Island | 44 | 48001 | 1294 |
14468 | 14468 | 2020-11-20 | South Carolina | 45 | 203161 | 4231 |
14469 | 14469 | 2020-11-20 | South Dakota | 46 | 71070 | 741 |
14470 | 14470 | 2020-11-20 | Tennessee | 47 | 325282 | 4156 |
14471 | 14471 | 2020-11-20 | Texas | 48 | 1153363 | 20872 |
14472 | 14472 | 2020-11-20 | Utah | 49 | 170644 | 776 |
14473 | 14473 | 2020-11-20 | Vermont | 50 | 3459 | 62 |
14474 | 14474 | 2020-11-20 | Virgin Islands | 78 | 1482 | 23 |
14475 | 14475 | 2020-11-20 | Virginia | 51 | 213331 | 3912 |
14476 | 14476 | 2020-11-20 | Washington | 53 | 147251 | 2738 |
14477 | 14477 | 2020-11-20 | West Virginia | 54 | 38480 | 639 |
14478 | 14478 | 2020-11-20 | Wisconsin | 55 | 365190 | 3106 |
14479 | 14479 | 2020-11-20 | Wyoming | 56 | 27129 | 176 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );