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-08-24 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 |
---|---|---|---|---|---|---|
9585 | 9585 | 2020-08-24 | Alabama | 1 | 116710 | 2024 |
9586 | 9586 | 2020-08-24 | Alaska | 2 | 5626 | 30 |
9587 | 9587 | 2020-08-24 | Arizona | 4 | 198421 | 4775 |
9588 | 9588 | 2020-08-24 | Arkansas | 5 | 56894 | 696 |
9589 | 9589 | 2020-08-24 | California | 6 | 676236 | 12250 |
9590 | 9590 | 2020-08-24 | Colorado | 8 | 55700 | 1926 |
9591 | 9591 | 2020-08-24 | Connecticut | 9 | 52011 | 4460 |
9592 | 9592 | 2020-08-24 | Delaware | 10 | 16942 | 604 |
9593 | 9593 | 2020-08-24 | District of Columbia | 11 | 13639 | 604 |
9594 | 9594 | 2020-08-24 | Florida | 12 | 602821 | 10396 |
9595 | 9595 | 2020-08-24 | Georgia | 13 | 239612 | 5045 |
9596 | 9596 | 2020-08-24 | Guam | 66 | 1876 | 8 |
9597 | 9597 | 2020-08-24 | Hawaii | 15 | 6746 | 48 |
9598 | 9598 | 2020-08-24 | Idaho | 16 | 30260 | 315 |
9599 | 9599 | 2020-08-24 | Illinois | 17 | 224056 | 8123 |
9600 | 9600 | 2020-08-24 | Indiana | 18 | 89602 | 3225 |
9601 | 9601 | 2020-08-24 | Iowa | 19 | 56941 | 1047 |
9602 | 9602 | 2020-08-24 | Kansas | 20 | 39008 | 432 |
9603 | 9603 | 2020-08-24 | Kentucky | 21 | 46057 | 909 |
9604 | 9604 | 2020-08-24 | Louisiana | 22 | 143707 | 4764 |
9605 | 9605 | 2020-08-24 | Maine | 23 | 4356 | 131 |
9606 | 9606 | 2020-08-24 | Maryland | 24 | 105168 | 3694 |
9607 | 9607 | 2020-08-24 | Massachusetts | 25 | 126022 | 8949 |
9608 | 9608 | 2020-08-24 | Michigan | 26 | 107816 | 6665 |
9609 | 9609 | 2020-08-24 | Minnesota | 27 | 70344 | 1817 |
9610 | 9610 | 2020-08-24 | Mississippi | 28 | 78405 | 2248 |
9611 | 9611 | 2020-08-24 | Missouri | 29 | 77254 | 1533 |
9612 | 9612 | 2020-08-24 | Montana | 30 | 6510 | 91 |
9613 | 9613 | 2020-08-24 | Nebraska | 31 | 32047 | 384 |
9614 | 9614 | 2020-08-24 | Nevada | 32 | 66073 | 1200 |
9615 | 9615 | 2020-08-24 | New Hampshire | 33 | 7134 | 429 |
9616 | 9616 | 2020-08-24 | New Jersey | 34 | 191548 | 15946 |
9617 | 9617 | 2020-08-24 | New Mexico | 35 | 24469 | 747 |
9618 | 9618 | 2020-08-24 | New York | 36 | 434866 | 32489 |
9619 | 9619 | 2020-08-24 | North Carolina | 37 | 156927 | 2567 |
9620 | 9620 | 2020-08-24 | North Dakota | 38 | 10004 | 141 |
9621 | 9621 | 2020-08-24 | Northern Mariana Islands | 69 | 54 | 2 |
9622 | 9622 | 2020-08-24 | Ohio | 39 | 115651 | 3986 |
9623 | 9623 | 2020-08-24 | Oklahoma | 40 | 53522 | 730 |
9624 | 9624 | 2020-08-24 | Oregon | 41 | 25174 | 432 |
9625 | 9625 | 2020-08-24 | Pennsylvania | 42 | 134246 | 7642 |
9626 | 9626 | 2020-08-24 | Puerto Rico | 72 | 30618 | 390 |
9627 | 9627 | 2020-08-24 | Rhode Island | 44 | 21302 | 1035 |
9628 | 9628 | 2020-08-24 | South Carolina | 45 | 112551 | 2511 |
9629 | 9629 | 2020-08-24 | South Dakota | 46 | 11425 | 161 |
9630 | 9630 | 2020-08-24 | Tennessee | 47 | 141675 | 1578 |
9631 | 9631 | 2020-08-24 | Texas | 48 | 607621 | 11824 |
9632 | 9632 | 2020-08-24 | Utah | 49 | 49451 | 391 |
9633 | 9633 | 2020-08-24 | Vermont | 50 | 1566 | 58 |
9634 | 9634 | 2020-08-24 | Virgin Islands | 78 | 998 | 12 |
9635 | 9635 | 2020-08-24 | Virginia | 51 | 113630 | 2471 |
9636 | 9636 | 2020-08-24 | Washington | 53 | 74292 | 1953 |
9637 | 9637 | 2020-08-24 | West Virginia | 54 | 9312 | 179 |
9638 | 9638 | 2020-08-24 | Wisconsin | 55 | 75755 | 1093 |
9639 | 9639 | 2020-08-24 | Wyoming | 56 | 3603 | 37 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );