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 2021-06-29 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 |
---|---|---|---|---|---|---|
26580 | 26580 | 2021-06-29 | Alabama | 1 | 550451 | 11338 |
26581 | 26581 | 2021-06-29 | Alaska | 2 | 70581 | 357 |
26582 | 26582 | 2021-06-29 | Arizona | 4 | 894106 | 17930 |
26583 | 26583 | 2021-06-29 | Arkansas | 5 | 348699 | 5905 |
26584 | 26584 | 2021-06-29 | California | 6 | 3818311 | 63610 |
26585 | 26585 | 2021-06-29 | Colorado | 8 | 560407 | 6940 |
26586 | 26586 | 2021-06-29 | Connecticut | 9 | 349301 | 8276 |
26587 | 26587 | 2021-06-29 | Delaware | 10 | 109712 | 1694 |
26588 | 26588 | 2021-06-29 | District of Columbia | 11 | 49347 | 1141 |
26589 | 26589 | 2021-06-29 | Florida | 12 | 2327165 | 37836 |
26590 | 26590 | 2021-06-29 | Georgia | 13 | 1109016 | 20702 |
26591 | 26591 | 2021-06-29 | Guam | 66 | 9317 | 141 |
26592 | 26592 | 2021-06-29 | Hawaii | 15 | 36344 | 513 |
26593 | 26593 | 2021-06-29 | Idaho | 16 | 194977 | 2151 |
26594 | 26594 | 2021-06-29 | Illinois | 17 | 1395442 | 25667 |
26595 | 26595 | 2021-06-29 | Indiana | 18 | 756877 | 13844 |
26596 | 26596 | 2021-06-29 | Iowa | 19 | 373735 | 6134 |
26597 | 26597 | 2021-06-29 | Kansas | 20 | 319160 | 5182 |
26598 | 26598 | 2021-06-29 | Kentucky | 21 | 465686 | 7264 |
26599 | 26599 | 2021-06-29 | Louisiana | 22 | 480876 | 10732 |
26600 | 26600 | 2021-06-29 | Maine | 23 | 69021 | 858 |
26601 | 26601 | 2021-06-29 | Maryland | 24 | 462434 | 9740 |
26602 | 26602 | 2021-06-29 | Massachusetts | 25 | 709873 | 17993 |
26603 | 26603 | 2021-06-29 | Michigan | 26 | 998305 | 20982 |
26604 | 26604 | 2021-06-29 | Minnesota | 27 | 605390 | 7680 |
26605 | 26605 | 2021-06-29 | Mississippi | 28 | 321408 | 7412 |
26606 | 26606 | 2021-06-29 | Missouri | 29 | 633549 | 9928 |
26607 | 26607 | 2021-06-29 | Montana | 30 | 113797 | 1665 |
26608 | 26608 | 2021-06-29 | Nebraska | 31 | 224725 | 2520 |
26609 | 26609 | 2021-06-29 | Nevada | 32 | 333154 | 5678 |
26610 | 26610 | 2021-06-29 | New Hampshire | 33 | 99481 | 1371 |
26611 | 26611 | 2021-06-29 | New Jersey | 34 | 1023200 | 26444 |
26612 | 26612 | 2021-06-29 | New Mexico | 35 | 205484 | 4340 |
26613 | 26613 | 2021-06-29 | New York | 36 | 2112872 | 53093 |
26614 | 26614 | 2021-06-29 | North Carolina | 37 | 1014376 | 13443 |
26615 | 26615 | 2021-06-29 | North Dakota | 38 | 110711 | 1559 |
26616 | 26616 | 2021-06-29 | Northern Mariana Islands | 69 | 183 | 2 |
26617 | 26617 | 2021-06-29 | Ohio | 39 | 1111124 | 20309 |
26618 | 26618 | 2021-06-29 | Oklahoma | 40 | 457575 | 7384 |
26619 | 26619 | 2021-06-29 | Oregon | 41 | 208504 | 2799 |
26620 | 26620 | 2021-06-29 | Pennsylvania | 42 | 1216430 | 27717 |
26621 | 26621 | 2021-06-29 | Puerto Rico | 72 | 173636 | 2547 |
26622 | 26622 | 2021-06-29 | Rhode Island | 44 | 152589 | 2728 |
26623 | 26623 | 2021-06-29 | South Carolina | 45 | 596712 | 9817 |
26624 | 26624 | 2021-06-29 | South Dakota | 46 | 124521 | 2033 |
26625 | 26625 | 2021-06-29 | Tennessee | 47 | 854043 | 12463 |
26626 | 26626 | 2021-06-29 | Texas | 48 | 2990978 | 52494 |
26627 | 26627 | 2021-06-29 | Utah | 49 | 414636 | 2368 |
26628 | 26628 | 2021-06-29 | Vermont | 50 | 24406 | 256 |
26629 | 26629 | 2021-06-29 | Virgin Islands | 78 | 3858 | 30 |
26630 | 26630 | 2021-06-29 | Virginia | 51 | 680065 | 11412 |
26631 | 26631 | 2021-06-29 | Washington | 53 | 453307 | 5963 |
26632 | 26632 | 2021-06-29 | West Virginia | 54 | 163992 | 2879 |
26633 | 26633 | 2021-06-29 | Wisconsin | 55 | 677743 | 8126 |
26634 | 26634 | 2021-06-29 | Wyoming | 56 | 62195 | 747 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );