ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where "date" is on date 2022-01-21 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 56
- Alabama 1
- Alaska 1
- American Samoa 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 |
---|---|---|---|---|---|---|
38031 | 38031 | 2022-01-21 | Alabama | 1 | 1120881 | 16824 |
38032 | 38032 | 2022-01-21 | Alaska | 2 | 194133 | 1027 |
38033 | 38033 | 2022-01-21 | American Samoa | 60 | 18 | 0 |
38034 | 38034 | 2022-01-21 | Arizona | 4 | 1701949 | 25502 |
38035 | 38035 | 2022-01-21 | Arkansas | 5 | 726716 | 9484 |
38036 | 38036 | 2022-01-21 | California | 6 | 7621774 | 78700 |
38037 | 38037 | 2022-01-21 | Colorado | 8 | 1186421 | 10974 |
38038 | 38038 | 2022-01-21 | Connecticut | 9 | 671674 | 9769 |
38039 | 38039 | 2022-01-21 | Delaware | 10 | 236022 | 2457 |
38040 | 38040 | 2022-01-21 | District of Columbia | 11 | 127200 | 1267 |
38041 | 38041 | 2022-01-21 | Florida | 12 | 5281000 | 63763 |
38042 | 38042 | 2022-01-21 | Georgia | 13 | 2171163 | 31066 |
38043 | 38043 | 2022-01-21 | Guam | 66 | 26726 | 277 |
38044 | 38044 | 2022-01-21 | Hawaii | 15 | 190551 | 1134 |
38045 | 38045 | 2022-01-21 | Idaho | 16 | 356265 | 4325 |
38046 | 38046 | 2022-01-21 | Illinois | 17 | 2777353 | 33446 |
38047 | 38047 | 2022-01-21 | Indiana | 18 | 1528366 | 20751 |
38048 | 38048 | 2022-01-21 | Iowa | 19 | 669705 | 8317 |
38049 | 38049 | 2022-01-21 | Kansas | 20 | 681740 | 7352 |
38050 | 38050 | 2022-01-21 | Kentucky | 21 | 1067360 | 12719 |
38051 | 38051 | 2022-01-21 | Louisiana | 22 | 1060022 | 15324 |
38052 | 38052 | 2022-01-21 | Maine | 23 | 165691 | 1693 |
38053 | 38053 | 2022-01-21 | Maryland | 24 | 927349 | 13003 |
38054 | 38054 | 2022-01-21 | Massachusetts | 25 | 1535986 | 21402 |
38055 | 38055 | 2022-01-21 | Michigan | 26 | 2118580 | 31466 |
38056 | 38056 | 2022-01-21 | Minnesota | 27 | 1216874 | 11291 |
38057 | 38057 | 2022-01-21 | Mississippi | 28 | 681382 | 10721 |
38058 | 38058 | 2022-01-21 | Missouri | 29 | 1266288 | 17245 |
38059 | 38059 | 2022-01-21 | Montana | 30 | 222716 | 2980 |
38060 | 38060 | 2022-01-21 | Nebraska | 31 | 413056 | 3569 |
38061 | 38061 | 2022-01-21 | Nevada | 32 | 614505 | 8736 |
38062 | 38062 | 2022-01-21 | New Hampshire | 33 | 257793 | 2135 |
38063 | 38063 | 2022-01-21 | New Jersey | 34 | 2049573 | 30618 |
38064 | 38064 | 2022-01-21 | New Mexico | 35 | 437934 | 6261 |
38065 | 38065 | 2022-01-21 | New York | 36 | 4638987 | 62543 |
38066 | 38066 | 2022-01-21 | North Carolina | 37 | 2204205 | 20204 |
38067 | 38067 | 2022-01-21 | North Dakota | 38 | 208047 | 2114 |
38068 | 38068 | 2022-01-21 | Northern Mariana Islands | 69 | 4166 | 21 |
38069 | 38069 | 2022-01-21 | Ohio | 39 | 2480566 | 31987 |
38070 | 38070 | 2022-01-21 | Oklahoma | 40 | 880342 | 11873 |
38071 | 38071 | 2022-01-21 | Oregon | 41 | 570892 | 5936 |
38072 | 38072 | 2022-01-21 | Pennsylvania | 42 | 2542816 | 39362 |
38073 | 38073 | 2022-01-21 | Puerto Rico | 72 | 466116 | 3631 |
38074 | 38074 | 2022-01-21 | Rhode Island | 44 | 327109 | 3240 |
38075 | 38075 | 2022-01-21 | South Carolina | 45 | 1265710 | 15108 |
38076 | 38076 | 2022-01-21 | South Dakota | 46 | 216656 | 2601 |
38077 | 38077 | 2022-01-21 | Tennessee | 47 | 1672693 | 21672 |
38078 | 38078 | 2022-01-21 | Texas | 48 | 5813105 | 78171 |
38079 | 38079 | 2022-01-21 | Utah | 49 | 826149 | 4030 |
38080 | 38080 | 2022-01-21 | Vermont | 50 | 96415 | 514 |
38081 | 38081 | 2022-01-21 | Virgin Islands | 78 | 14028 | 94 |
38082 | 38082 | 2022-01-21 | Virginia | 51 | 1451713 | 15853 |
38083 | 38083 | 2022-01-21 | Washington | 53 | 1157736 | 10474 |
38084 | 38084 | 2022-01-21 | West Virginia | 54 | 407131 | 5609 |
38085 | 38085 | 2022-01-21 | Wisconsin | 55 | 1446213 | 11946 |
38086 | 38086 | 2022-01-21 | Wyoming | 56 | 135369 | 1601 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );