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-16 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 |
---|---|---|---|---|---|---|
25865 | 25865 | 2021-06-16 | Alabama | 1 | 548323 | 11288 |
25866 | 25866 | 2021-06-16 | Alaska | 2 | 70183 | 356 |
25867 | 25867 | 2021-06-16 | Arizona | 4 | 888005 | 17791 |
25868 | 25868 | 2021-06-16 | Arkansas | 5 | 344657 | 5867 |
25869 | 25869 | 2021-06-16 | California | 6 | 3805390 | 63224 |
25870 | 25870 | 2021-06-16 | Colorado | 8 | 555248 | 6852 |
25871 | 25871 | 2021-06-16 | Connecticut | 9 | 348560 | 8265 |
25872 | 25872 | 2021-06-16 | Delaware | 10 | 109418 | 1679 |
25873 | 25873 | 2021-06-16 | District of Columbia | 11 | 49223 | 1139 |
25874 | 25874 | 2021-06-16 | Florida | 12 | 2307628 | 37448 |
25875 | 25875 | 2021-06-16 | Georgia | 13 | 1105234 | 20544 |
25876 | 25876 | 2021-06-16 | Guam | 66 | 9230 | 140 |
25877 | 25877 | 2021-06-16 | Hawaii | 15 | 35831 | 504 |
25878 | 25878 | 2021-06-16 | Idaho | 16 | 193997 | 2125 |
25879 | 25879 | 2021-06-16 | Illinois | 17 | 1392390 | 25531 |
25880 | 25880 | 2021-06-16 | Indiana | 18 | 753511 | 13763 |
25881 | 25881 | 2021-06-16 | Iowa | 19 | 372837 | 6109 |
25882 | 25882 | 2021-06-16 | Kansas | 20 | 317938 | 5161 |
25883 | 25883 | 2021-06-16 | Kentucky | 21 | 463895 | 7222 |
25884 | 25884 | 2021-06-16 | Louisiana | 22 | 476792 | 10670 |
25885 | 25885 | 2021-06-16 | Maine | 23 | 68683 | 853 |
25886 | 25886 | 2021-06-16 | Maryland | 24 | 461687 | 9695 |
25887 | 25887 | 2021-06-16 | Massachusetts | 25 | 709080 | 17953 |
25888 | 25888 | 2021-06-16 | Michigan | 26 | 996275 | 20808 |
25889 | 25889 | 2021-06-16 | Minnesota | 27 | 604145 | 7616 |
25890 | 25890 | 2021-06-16 | Mississippi | 28 | 319511 | 7368 |
25891 | 25891 | 2021-06-16 | Missouri | 29 | 623594 | 9828 |
25892 | 25892 | 2021-06-16 | Montana | 30 | 113128 | 1649 |
25893 | 25893 | 2021-06-16 | Nebraska | 31 | 224267 | 2517 |
25894 | 25894 | 2021-06-16 | Nevada | 32 | 328194 | 5635 |
25895 | 25895 | 2021-06-16 | New Hampshire | 33 | 99196 | 1364 |
25896 | 25896 | 2021-06-16 | New Jersey | 34 | 1020326 | 26352 |
25897 | 25897 | 2021-06-16 | New Mexico | 35 | 204472 | 4307 |
25898 | 25898 | 2021-06-16 | New York | 36 | 2108535 | 52995 |
25899 | 25899 | 2021-06-16 | North Carolina | 37 | 1010306 | 13333 |
25900 | 25900 | 2021-06-16 | North Dakota | 38 | 110523 | 1553 |
25901 | 25901 | 2021-06-16 | Northern Mariana Islands | 69 | 183 | 2 |
25902 | 25902 | 2021-06-16 | Ohio | 39 | 1107902 | 20122 |
25903 | 25903 | 2021-06-16 | Oklahoma | 40 | 455145 | 7354 |
25904 | 25904 | 2021-06-16 | Oregon | 41 | 205780 | 2775 |
25905 | 25905 | 2021-06-16 | Pennsylvania | 42 | 1214051 | 27582 |
25906 | 25906 | 2021-06-16 | Puerto Rico | 72 | 173075 | 2538 |
25907 | 25907 | 2021-06-16 | Rhode Island | 44 | 152333 | 2723 |
25908 | 25908 | 2021-06-16 | South Carolina | 45 | 595310 | 9786 |
25909 | 25909 | 2021-06-16 | South Dakota | 46 | 124382 | 2026 |
25910 | 25910 | 2021-06-16 | Tennessee | 47 | 852863 | 12405 |
25911 | 25911 | 2021-06-16 | Texas | 48 | 2975716 | 52185 |
25912 | 25912 | 2021-06-16 | Utah | 49 | 410447 | 2324 |
25913 | 25913 | 2021-06-16 | Vermont | 50 | 24348 | 256 |
25914 | 25914 | 2021-06-16 | Virgin Islands | 78 | 3729 | 30 |
25915 | 25915 | 2021-06-16 | Virginia | 51 | 678226 | 11330 |
25916 | 25916 | 2021-06-16 | Washington | 53 | 447781 | 5850 |
25917 | 25917 | 2021-06-16 | West Virginia | 54 | 163311 | 2861 |
25918 | 25918 | 2021-06-16 | Wisconsin | 55 | 676655 | 8041 |
25919 | 25919 | 2021-06-16 | Wyoming | 56 | 61359 | 734 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );