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-08-06 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 |
---|---|---|---|---|---|---|
49063 | 49063 | 2022-08-06 | Alabama | 1 | 1436458 | 19974 |
49064 | 49064 | 2022-08-06 | Alaska | 2 | 285126 | 1270 |
49065 | 49065 | 2022-08-06 | American Samoa | 60 | 7952 | 33 |
49066 | 49066 | 2022-08-06 | Arizona | 4 | 2211463 | 30842 |
49067 | 49067 | 2022-08-06 | Arkansas | 5 | 910322 | 11763 |
49068 | 49068 | 2022-08-06 | California | 6 | 10807573 | 93919 |
49069 | 49069 | 2022-08-06 | Colorado | 8 | 1612845 | 13243 |
49070 | 49070 | 2022-08-06 | Connecticut | 9 | 858702 | 11138 |
49071 | 49071 | 2022-08-06 | Delaware | 10 | 296190 | 3026 |
49072 | 49072 | 2022-08-06 | District of Columbia | 11 | 163429 | 1369 |
49073 | 49073 | 2022-08-06 | Florida | 12 | 6855234 | 78047 |
49074 | 49074 | 2022-08-06 | Georgia | 13 | 2699050 | 37640 |
49075 | 49075 | 2022-08-06 | Guam | 66 | 56894 | 383 |
49076 | 49076 | 2022-08-06 | Hawaii | 15 | 321378 | 1589 |
49077 | 49077 | 2022-08-06 | Idaho | 16 | 481670 | 5056 |
49078 | 49078 | 2022-08-06 | Illinois | 17 | 3600719 | 38966 |
49079 | 49079 | 2022-08-06 | Indiana | 18 | 1843622 | 24154 |
49080 | 49080 | 2022-08-06 | Iowa | 19 | 822796 | 9817 |
49081 | 49081 | 2022-08-06 | Kansas | 20 | 842437 | 8993 |
49082 | 49082 | 2022-08-06 | Kentucky | 21 | 1488702 | 16397 |
49083 | 49083 | 2022-08-06 | Louisiana | 22 | 1389464 | 17633 |
49084 | 49084 | 2022-08-06 | Maine | 23 | 277459 | 2493 |
49085 | 49085 | 2022-08-06 | Maryland | 24 | 1190679 | 15011 |
49086 | 49086 | 2022-08-06 | Massachusetts | 25 | 1977503 | 21224 |
49087 | 49087 | 2022-08-06 | Michigan | 26 | 2692485 | 37534 |
49088 | 49088 | 2022-08-06 | Minnesota | 27 | 1601006 | 13320 |
49089 | 49089 | 2022-08-06 | Mississippi | 28 | 883465 | 12684 |
49090 | 49090 | 2022-08-06 | Missouri | 29 | 1595069 | 21192 |
49091 | 49091 | 2022-08-06 | Montana | 30 | 298992 | 3481 |
49092 | 49092 | 2022-08-06 | Nebraska | 31 | 519584 | 4370 |
49093 | 49093 | 2022-08-06 | Nevada | 32 | 831629 | 11258 |
49094 | 49094 | 2022-08-06 | New Hampshire | 33 | 339766 | 2634 |
49095 | 49095 | 2022-08-06 | New Jersey | 34 | 2617438 | 34335 |
49096 | 49096 | 2022-08-06 | New Mexico | 35 | 596599 | 8284 |
49097 | 49097 | 2022-08-06 | New York | 36 | 5850790 | 69794 |
49098 | 49098 | 2022-08-06 | North Carolina | 37 | 3016613 | 25697 |
49099 | 49099 | 2022-08-06 | North Dakota | 38 | 259270 | 2366 |
49100 | 49100 | 2022-08-06 | Northern Mariana Islands | 69 | 12732 | 38 |
49101 | 49101 | 2022-08-06 | Ohio | 39 | 2976027 | 39133 |
49102 | 49102 | 2022-08-06 | Oklahoma | 40 | 1132714 | 14593 |
49103 | 49103 | 2022-08-06 | Oregon | 41 | 858796 | 8211 |
49104 | 49104 | 2022-08-06 | Pennsylvania | 42 | 3108489 | 46279 |
49105 | 49105 | 2022-08-06 | Puerto Rico | 72 | 903695 | 4803 |
49106 | 49106 | 2022-08-06 | Rhode Island | 44 | 412477 | 3632 |
49107 | 49107 | 2022-08-06 | South Carolina | 45 | 1621121 | 18208 |
49108 | 49108 | 2022-08-06 | South Dakota | 46 | 251860 | 2963 |
49109 | 49109 | 2022-08-06 | Tennessee | 47 | 2162514 | 26814 |
49110 | 49110 | 2022-08-06 | Texas | 48 | 7519908 | 89643 |
49111 | 49111 | 2022-08-06 | Utah | 49 | 1015707 | 4928 |
49112 | 49112 | 2022-08-06 | Vermont | 50 | 138145 | 693 |
49113 | 49113 | 2022-08-06 | Virgin Islands | 78 | 21957 | 121 |
49114 | 49114 | 2022-08-06 | Virginia | 51 | 1975007 | 21054 |
49115 | 49115 | 2022-08-06 | Washington | 53 | 1749173 | 13769 |
49116 | 49116 | 2022-08-06 | West Virginia | 54 | 561275 | 7184 |
49117 | 49117 | 2022-08-06 | Wisconsin | 55 | 1790884 | 14946 |
49118 | 49118 | 2022-08-06 | Wyoming | 56 | 171322 | 1856 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );