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-07-02 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 |
---|---|---|---|---|---|---|
26745 | 26745 | 2021-07-02 | Alabama | 1 | 551298 | 11358 |
26746 | 26746 | 2021-07-02 | Alaska | 2 | 70774 | 360 |
26747 | 26747 | 2021-07-02 | Arizona | 4 | 895873 | 17961 |
26748 | 26748 | 2021-07-02 | Arkansas | 5 | 350579 | 5913 |
26749 | 26749 | 2021-07-02 | California | 6 | 3868398 | 63649 |
26750 | 26750 | 2021-07-02 | Colorado | 8 | 561922 | 6956 |
26751 | 26751 | 2021-07-02 | Connecticut | 9 | 349476 | 8279 |
26752 | 26752 | 2021-07-02 | Delaware | 10 | 109820 | 1695 |
26753 | 26753 | 2021-07-02 | District of Columbia | 11 | 49378 | 1141 |
26754 | 26754 | 2021-07-02 | Florida | 12 | 2337613 | 37985 |
26755 | 26755 | 2021-07-02 | Georgia | 13 | 1111032 | 20748 |
26756 | 26756 | 2021-07-02 | Guam | 66 | 9342 | 141 |
26757 | 26757 | 2021-07-02 | Hawaii | 15 | 36508 | 515 |
26758 | 26758 | 2021-07-02 | Idaho | 16 | 195249 | 2160 |
26759 | 26759 | 2021-07-02 | Illinois | 17 | 1396606 | 25696 |
26760 | 26760 | 2021-07-02 | Indiana | 18 | 758078 | 13863 |
26761 | 26761 | 2021-07-02 | Iowa | 19 | 374054 | 6142 |
26762 | 26762 | 2021-07-02 | Kansas | 20 | 319991 | 5192 |
26763 | 26763 | 2021-07-02 | Kentucky | 21 | 466278 | 7280 |
26764 | 26764 | 2021-07-02 | Louisiana | 22 | 482560 | 10757 |
26765 | 26765 | 2021-07-02 | Maine | 23 | 69069 | 860 |
26766 | 26766 | 2021-07-02 | Maryland | 24 | 462656 | 9746 |
26767 | 26767 | 2021-07-02 | Massachusetts | 25 | 710138 | 17998 |
26768 | 26768 | 2021-07-02 | Michigan | 26 | 998973 | 20995 |
26769 | 26769 | 2021-07-02 | Minnesota | 27 | 605642 | 7698 |
26770 | 26770 | 2021-07-02 | Mississippi | 28 | 322186 | 7419 |
26771 | 26771 | 2021-07-02 | Missouri | 29 | 637390 | 9953 |
26772 | 26772 | 2021-07-02 | Montana | 30 | 113981 | 1666 |
26773 | 26773 | 2021-07-02 | Nebraska | 31 | 224848 | 2520 |
26774 | 26774 | 2021-07-02 | Nevada | 32 | 334763 | 5697 |
26775 | 26775 | 2021-07-02 | New Hampshire | 33 | 99555 | 1372 |
26776 | 26776 | 2021-07-02 | New Jersey | 34 | 1023923 | 26468 |
26777 | 26777 | 2021-07-02 | New Mexico | 35 | 205715 | 4346 |
26778 | 26778 | 2021-07-02 | New York | 36 | 2114018 | 53109 |
26779 | 26779 | 2021-07-02 | North Carolina | 37 | 1015363 | 13447 |
26780 | 26780 | 2021-07-02 | North Dakota | 38 | 110760 | 1559 |
26781 | 26781 | 2021-07-02 | Northern Mariana Islands | 69 | 183 | 2 |
26782 | 26782 | 2021-07-02 | Ohio | 39 | 1112088 | 20344 |
26783 | 26783 | 2021-07-02 | Oklahoma | 40 | 458483 | 7388 |
26784 | 26784 | 2021-07-02 | Oregon | 41 | 209082 | 2811 |
26785 | 26785 | 2021-07-02 | Pennsylvania | 42 | 1217115 | 27692 |
26786 | 26786 | 2021-07-02 | Puerto Rico | 72 | 173721 | 2550 |
26787 | 26787 | 2021-07-02 | Rhode Island | 44 | 152643 | 2730 |
26788 | 26788 | 2021-07-02 | South Carolina | 45 | 597261 | 9830 |
26789 | 26789 | 2021-07-02 | South Dakota | 46 | 124582 | 2038 |
26790 | 26790 | 2021-07-02 | Tennessee | 47 | 854656 | 12483 |
26791 | 26791 | 2021-07-02 | Texas | 48 | 2997152 | 52597 |
26792 | 26792 | 2021-07-02 | Utah | 49 | 416181 | 2378 |
26793 | 26793 | 2021-07-02 | Vermont | 50 | 24419 | 258 |
26794 | 26794 | 2021-07-02 | Virgin Islands | 78 | 3895 | 30 |
26795 | 26795 | 2021-07-02 | Virginia | 51 | 680744 | 11423 |
26796 | 26796 | 2021-07-02 | Washington | 53 | 454484 | 5994 |
26797 | 26797 | 2021-07-02 | West Virginia | 54 | 164149 | 2899 |
26798 | 26798 | 2021-07-02 | Wisconsin | 55 | 678067 | 8135 |
26799 | 26799 | 2021-07-02 | Wyoming | 56 | 62445 | 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 );