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-03-17 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 55
- 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
- New Hampshire 1
- New Jersey 1
- New Mexico 1
- New York 1
- North Carolina 1
- North Dakota 1
- Northern Mariana Islands 1
- Ohio 1
- Oklahoma 1
- Oregon 1
- Pennsylvania 1
- Puerto Rico 1
- Rhode Island 1
- South Carolina 1
- South Dakota 1
- Tennessee 1
- Texas 1
- Utah 1
- Vermont 1
- Virgin Islands 1
- Virginia 1
- Washington 1
- West Virginia 1
- Wisconsin 1
- Wyoming 1
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
20860 | 20860 | 2021-03-17 | Alabama | 1 | 509476 | 10363 |
20861 | 20861 | 2021-03-17 | Alaska | 2 | 60451 | 293 |
20862 | 20862 | 2021-03-17 | Arizona | 4 | 834329 | 16586 |
20863 | 20863 | 2021-03-17 | Arkansas | 5 | 327781 | 5507 |
20864 | 20864 | 2021-03-17 | California | 6 | 3631857 | 56976 |
20865 | 20865 | 2021-03-17 | Colorado | 8 | 447840 | 6136 |
20866 | 20866 | 2021-03-17 | Connecticut | 9 | 294328 | 7807 |
20867 | 20867 | 2021-03-17 | Delaware | 10 | 91123 | 1516 |
20868 | 20868 | 2021-03-17 | District of Columbia | 11 | 42811 | 1044 |
20869 | 20869 | 2021-03-17 | Florida | 12 | 1989016 | 32503 |
20870 | 20870 | 2021-03-17 | Georgia | 13 | 1013340 | 17801 |
20871 | 20871 | 2021-03-17 | Guam | 66 | 8745 | 135 |
20872 | 20872 | 2021-03-17 | Hawaii | 15 | 28423 | 448 |
20873 | 20873 | 2021-03-17 | Idaho | 16 | 176589 | 1937 |
20874 | 20874 | 2021-03-17 | Illinois | 17 | 1217258 | 23255 |
20875 | 20875 | 2021-03-17 | Indiana | 18 | 677705 | 12893 |
20876 | 20876 | 2021-03-17 | Iowa | 19 | 344268 | 5668 |
20877 | 20877 | 2021-03-17 | Kansas | 20 | 301763 | 4837 |
20878 | 20878 | 2021-03-17 | Kentucky | 21 | 421780 | 5197 |
20879 | 20879 | 2021-03-17 | Louisiana | 22 | 439002 | 9955 |
20880 | 20880 | 2021-03-17 | Maine | 23 | 47591 | 725 |
20881 | 20881 | 2021-03-17 | Maryland | 24 | 395817 | 8099 |
20882 | 20882 | 2021-03-17 | Massachusetts | 25 | 606377 | 16732 |
20883 | 20883 | 2021-03-17 | Michigan | 26 | 679274 | 16800 |
20884 | 20884 | 2021-03-17 | Minnesota | 27 | 500030 | 6824 |
20885 | 20885 | 2021-03-17 | Mississippi | 28 | 301602 | 6936 |
20886 | 20886 | 2021-03-17 | Missouri | 29 | 580040 | 8806 |
20887 | 20887 | 2021-03-17 | Montana | 30 | 102602 | 1398 |
20888 | 20888 | 2021-03-17 | Nebraska | 31 | 205896 | 2238 |
20889 | 20889 | 2021-03-17 | Nevada | 32 | 300177 | 5148 |
20890 | 20890 | 2021-03-17 | New Hampshire | 33 | 79367 | 1202 |
20891 | 20891 | 2021-03-17 | New Jersey | 34 | 848875 | 24004 |
20892 | 20892 | 2021-03-17 | New Mexico | 35 | 188907 | 3874 |
20893 | 20893 | 2021-03-17 | New York | 36 | 1762032 | 48686 |
20894 | 20894 | 2021-03-17 | North Carolina | 37 | 890484 | 11783 |
20895 | 20895 | 2021-03-17 | North Dakota | 38 | 101315 | 1490 |
20896 | 20896 | 2021-03-17 | Northern Mariana Islands | 69 | 157 | 2 |
20897 | 20897 | 2021-03-17 | Ohio | 39 | 993681 | 17992 |
20898 | 20898 | 2021-03-17 | Oklahoma | 40 | 433516 | 4788 |
20899 | 20899 | 2021-03-17 | Oregon | 41 | 160348 | 2358 |
20900 | 20900 | 2021-03-17 | Pennsylvania | 42 | 979065 | 24749 |
20901 | 20901 | 2021-03-17 | Puerto Rico | 72 | 136893 | 2083 |
20902 | 20902 | 2021-03-17 | Rhode Island | 44 | 132184 | 2588 |
20903 | 20903 | 2021-03-17 | South Carolina | 45 | 536100 | 8933 |
20904 | 20904 | 2021-03-17 | South Dakota | 46 | 114966 | 1915 |
20905 | 20905 | 2021-03-17 | Tennessee | 47 | 781593 | 11555 |
20906 | 20906 | 2021-03-17 | Texas | 48 | 2739163 | 47000 |
20907 | 20907 | 2021-03-17 | Utah | 49 | 379838 | 2037 |
20908 | 20908 | 2021-03-17 | Vermont | 50 | 17106 | 217 |
20909 | 20909 | 2021-03-17 | Virgin Islands | 78 | 2767 | 25 |
20910 | 20910 | 2021-03-17 | Virginia | 51 | 598468 | 10154 |
20911 | 20911 | 2021-03-17 | Washington | 53 | 354906 | 5212 |
20912 | 20912 | 2021-03-17 | West Virginia | 54 | 136334 | 2565 |
20913 | 20913 | 2021-03-17 | Wisconsin | 55 | 627266 | 7203 |
20914 | 20914 | 2021-03-17 | Wyoming | 56 | 55449 | 693 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );