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-05-07 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 |
---|---|---|---|---|---|---|
3590 | 3590 | 2020-05-07 | Alabama | 1 | 9046 | 369 |
3591 | 3591 | 2020-05-07 | Alaska | 2 | 373 | 8 |
3592 | 3592 | 2020-05-07 | Arizona | 4 | 9945 | 450 |
3593 | 3593 | 2020-05-07 | Arkansas | 5 | 3694 | 88 |
3594 | 3594 | 2020-05-07 | California | 6 | 62481 | 2561 |
3595 | 3595 | 2020-05-07 | Colorado | 8 | 18264 | 942 |
3596 | 3596 | 2020-05-07 | Connecticut | 9 | 31784 | 2797 |
3597 | 3597 | 2020-05-07 | Delaware | 10 | 5939 | 202 |
3598 | 3598 | 2020-05-07 | District of Columbia | 11 | 5654 | 285 |
3599 | 3599 | 2020-05-07 | Florida | 12 | 38820 | 1599 |
3600 | 3600 | 2020-05-07 | Georgia | 13 | 30524 | 1332 |
3601 | 3601 | 2020-05-07 | Guam | 66 | 1118 | 6 |
3602 | 3602 | 2020-05-07 | Hawaii | 15 | 619 | 17 |
3603 | 3603 | 2020-05-07 | Idaho | 16 | 2178 | 67 |
3604 | 3604 | 2020-05-07 | Illinois | 17 | 70802 | 3139 |
3605 | 3605 | 2020-05-07 | Indiana | 18 | 22942 | 1414 |
3606 | 3606 | 2020-05-07 | Iowa | 19 | 11059 | 231 |
3607 | 3607 | 2020-05-07 | Kansas | 20 | 6240 | 164 |
3608 | 3608 | 2020-05-07 | Kentucky | 21 | 6173 | 302 |
3609 | 3609 | 2020-05-07 | Louisiana | 22 | 30725 | 2208 |
3610 | 3610 | 2020-05-07 | Maine | 23 | 1330 | 62 |
3611 | 3611 | 2020-05-07 | Maryland | 24 | 29476 | 1503 |
3612 | 3612 | 2020-05-07 | Massachusetts | 25 | 73721 | 4552 |
3613 | 3613 | 2020-05-07 | Michigan | 26 | 45643 | 4343 |
3614 | 3614 | 2020-05-07 | Minnesota | 27 | 9364 | 508 |
3615 | 3615 | 2020-05-07 | Mississippi | 28 | 8686 | 396 |
3616 | 3616 | 2020-05-07 | Missouri | 29 | 9409 | 449 |
3617 | 3617 | 2020-05-07 | Montana | 30 | 456 | 16 |
3618 | 3618 | 2020-05-07 | Nebraska | 31 | 7190 | 91 |
3619 | 3619 | 2020-05-07 | Nevada | 32 | 5858 | 293 |
3620 | 3620 | 2020-05-07 | New Hampshire | 33 | 2843 | 114 |
3621 | 3621 | 2020-05-07 | New Jersey | 34 | 133635 | 8801 |
3622 | 3622 | 2020-05-07 | New Mexico | 35 | 4492 | 172 |
3623 | 3623 | 2020-05-07 | New York | 36 | 332931 | 26206 |
3624 | 3624 | 2020-05-07 | North Carolina | 37 | 13431 | 521 |
3625 | 3625 | 2020-05-07 | North Dakota | 38 | 1371 | 31 |
3626 | 3626 | 2020-05-07 | Northern Mariana Islands | 69 | 15 | 2 |
3627 | 3627 | 2020-05-07 | Ohio | 39 | 22131 | 1271 |
3628 | 3628 | 2020-05-07 | Oklahoma | 40 | 4330 | 260 |
3629 | 3629 | 2020-05-07 | Oregon | 41 | 2989 | 121 |
3630 | 3630 | 2020-05-07 | Pennsylvania | 42 | 56149 | 3599 |
3631 | 3631 | 2020-05-07 | Puerto Rico | 72 | 2031 | 102 |
3632 | 3632 | 2020-05-07 | Rhode Island | 44 | 10530 | 388 |
3633 | 3633 | 2020-05-07 | South Carolina | 45 | 7142 | 316 |
3634 | 3634 | 2020-05-07 | South Dakota | 46 | 2905 | 31 |
3635 | 3635 | 2020-05-07 | Tennessee | 47 | 14108 | 238 |
3636 | 3636 | 2020-05-07 | Texas | 48 | 36682 | 1016 |
3637 | 3637 | 2020-05-07 | Utah | 49 | 5724 | 61 |
3638 | 3638 | 2020-05-07 | Vermont | 50 | 916 | 53 |
3639 | 3639 | 2020-05-07 | Virgin Islands | 78 | 68 | 4 |
3640 | 3640 | 2020-05-07 | Virginia | 51 | 21570 | 769 |
3641 | 3641 | 2020-05-07 | Washington | 53 | 17187 | 903 |
3642 | 3642 | 2020-05-07 | West Virginia | 54 | 1298 | 51 |
3643 | 3643 | 2020-05-07 | Wisconsin | 55 | 9369 | 374 |
3644 | 3644 | 2020-05-07 | Wyoming | 56 | 635 | 7 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );