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-11-03 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 |
---|---|---|---|---|---|---|
54047 | 54047 | 2022-11-03 | Alabama | 1 | 1534287 | 20558 |
54048 | 54048 | 2022-11-03 | Alaska | 2 | 298845 | 1369 |
54049 | 54049 | 2022-11-03 | American Samoa | 60 | 8257 | 34 |
54050 | 54050 | 2022-11-03 | Arizona | 4 | 2293015 | 31573 |
54051 | 54051 | 2022-11-03 | Arkansas | 5 | 960920 | 12506 |
54052 | 54052 | 2022-11-03 | California | 6 | 11383971 | 97064 |
54053 | 54053 | 2022-11-03 | Colorado | 8 | 1685037 | 13643 |
54054 | 54054 | 2022-11-03 | Connecticut | 9 | 914441 | 11478 |
54055 | 54055 | 2022-11-03 | Delaware | 10 | 313751 | 3147 |
54056 | 54056 | 2022-11-03 | District of Columbia | 11 | 170041 | 1397 |
54057 | 54057 | 2022-11-03 | Florida | 12 | 7149300 | 82176 |
54058 | 54058 | 2022-11-03 | Georgia | 13 | 2839500 | 39127 |
54059 | 54059 | 2022-11-03 | Guam | 66 | 59804 | 404 |
54060 | 54060 | 2022-11-03 | Hawaii | 15 | 354077 | 1708 |
54061 | 54061 | 2022-11-03 | Idaho | 16 | 501037 | 5228 |
54062 | 54062 | 2022-11-03 | Illinois | 17 | 3828247 | 40040 |
54063 | 54063 | 2022-11-03 | Indiana | 18 | 1942708 | 24950 |
54064 | 54064 | 2022-11-03 | Iowa | 19 | 864752 | 10207 |
54065 | 54065 | 2022-11-03 | Kansas | 20 | 890680 | 9632 |
54066 | 54066 | 2022-11-03 | Kentucky | 21 | 1618948 | 17322 |
54067 | 54067 | 2022-11-03 | Louisiana | 22 | 1463379 | 18193 |
54068 | 54068 | 2022-11-03 | Maine | 23 | 298179 | 2653 |
54069 | 54069 | 2022-11-03 | Maryland | 24 | 1272014 | 15585 |
54070 | 54070 | 2022-11-03 | Massachusetts | 25 | 2092838 | 22106 |
54071 | 54071 | 2022-11-03 | Michigan | 26 | 2897827 | 39407 |
54072 | 54072 | 2022-11-03 | Minnesota | 27 | 1691086 | 13873 |
54073 | 54073 | 2022-11-03 | Mississippi | 28 | 934401 | 12992 |
54074 | 54074 | 2022-11-03 | Missouri | 29 | 1690449 | 21869 |
54075 | 54075 | 2022-11-03 | Montana | 30 | 314811 | 3574 |
54076 | 54076 | 2022-11-03 | Nebraska | 31 | 535394 | 4562 |
54077 | 54077 | 2022-11-03 | Nevada | 32 | 854702 | 11570 |
54078 | 54078 | 2022-11-03 | New Hampshire | 33 | 357797 | 2764 |
54079 | 54079 | 2022-11-03 | New Jersey | 34 | 2803898 | 34935 |
54080 | 54080 | 2022-11-03 | New Mexico | 35 | 630082 | 8658 |
54081 | 54081 | 2022-11-03 | New York | 36 | 6253375 | 72505 |
54082 | 54082 | 2022-11-03 | North Carolina | 37 | 3246175 | 27244 |
54083 | 54083 | 2022-11-03 | North Dakota | 38 | 272812 | 2434 |
54084 | 54084 | 2022-11-03 | Northern Mariana Islands | 69 | 13212 | 41 |
54085 | 54085 | 2022-11-03 | Ohio | 39 | 3197300 | 40249 |
54086 | 54086 | 2022-11-03 | Oklahoma | 40 | 1211210 | 14992 |
54087 | 54087 | 2022-11-03 | Oregon | 41 | 910693 | 8726 |
54088 | 54088 | 2022-11-03 | Pennsylvania | 42 | 3317854 | 47840 |
54089 | 54089 | 2022-11-03 | Puerto Rico | 72 | 1018156 | 5268 |
54090 | 54090 | 2022-11-03 | Rhode Island | 44 | 433348 | 3705 |
54091 | 54091 | 2022-11-03 | South Carolina | 45 | 1725160 | 18633 |
54092 | 54092 | 2022-11-03 | South Dakota | 46 | 265019 | 3065 |
54093 | 54093 | 2022-11-03 | Tennessee | 47 | 2305487 | 27839 |
54094 | 54094 | 2022-11-03 | Texas | 48 | 7929279 | 91357 |
54095 | 54095 | 2022-11-03 | Utah | 49 | 1048168 | 5065 |
54096 | 54096 | 2022-11-03 | Vermont | 50 | 145409 | 754 |
54097 | 54097 | 2022-11-03 | Virgin Islands | 78 | 23311 | 124 |
54098 | 54098 | 2022-11-03 | Virginia | 51 | 2123638 | 22217 |
54099 | 54099 | 2022-11-03 | Washington | 53 | 1839241 | 14630 |
54100 | 54100 | 2022-11-03 | West Virginia | 54 | 608965 | 7534 |
54101 | 54101 | 2022-11-03 | Wisconsin | 55 | 1901398 | 15482 |
54102 | 54102 | 2022-11-03 | Wyoming | 56 | 178866 | 1914 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );