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-04-26 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- 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
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
43351 | 43351 | 2022-04-26 | Alabama | 1 | 1300076 | 19545 |
43352 | 43352 | 2022-04-26 | Alaska | 2 | 249901 | 1209 |
43353 | 43353 | 2022-04-26 | American Samoa | 60 | 5517 | 12 |
43354 | 43354 | 2022-04-26 | Arizona | 4 | 2019174 | 29852 |
43355 | 43355 | 2022-04-26 | Arkansas | 5 | 835247 | 11375 |
43356 | 43356 | 2022-04-26 | California | 6 | 9212572 | 90221 |
43357 | 43357 | 2022-04-26 | Colorado | 8 | 1384887 | 12321 |
43358 | 43358 | 2022-04-26 | Connecticut | 9 | 754924 | 10838 |
43359 | 43359 | 2022-04-26 | Delaware | 10 | 261762 | 2906 |
43360 | 43360 | 2022-04-26 | District of Columbia | 11 | 141355 | 1335 |
43361 | 43361 | 2022-04-26 | Florida | 12 | 5911764 | 73869 |
43362 | 43362 | 2022-04-26 | Georgia | 13 | 2439847 | 36217 |
43363 | 43363 | 2022-04-26 | Guam | 66 | 48989 | 355 |
43364 | 43364 | 2022-04-26 | Hawaii | 15 | 238763 | 1404 |
43365 | 43365 | 2022-04-26 | Idaho | 16 | 445778 | 4925 |
43366 | 43366 | 2022-04-26 | Illinois | 17 | 3130382 | 37872 |
43367 | 43367 | 2022-04-26 | Indiana | 18 | 1699213 | 23552 |
43368 | 43368 | 2022-04-26 | Iowa | 19 | 762557 | 9510 |
43369 | 43369 | 2022-04-26 | Kansas | 20 | 774680 | 8597 |
43370 | 43370 | 2022-04-26 | Kentucky | 21 | 1335910 | 15415 |
43371 | 43371 | 2022-04-26 | Louisiana | 22 | 1236996 | 17235 |
43372 | 43372 | 2022-04-26 | Maine | 23 | 242602 | 2282 |
43373 | 43373 | 2022-04-26 | Maryland | 24 | 1028290 | 14434 |
43374 | 43374 | 2022-04-26 | Massachusetts | 25 | 1746596 | 20238 |
43375 | 43375 | 2022-04-26 | Michigan | 26 | 2411464 | 35935 |
43376 | 43376 | 2022-04-26 | Minnesota | 27 | 1447835 | 12754 |
43377 | 43377 | 2022-04-26 | Mississippi | 28 | 797161 | 12436 |
43378 | 43378 | 2022-04-26 | Missouri | 29 | 1432689 | 20194 |
43379 | 43379 | 2022-04-26 | Montana | 30 | 273922 | 3322 |
43380 | 43380 | 2022-04-26 | Nebraska | 31 | 479545 | 4197 |
43381 | 43381 | 2022-04-26 | Nevada | 32 | 717604 | 10728 |
43382 | 43382 | 2022-04-26 | New Hampshire | 33 | 308653 | 2477 |
43383 | 43383 | 2022-04-26 | New Jersey | 34 | 2248959 | 33408 |
43384 | 43384 | 2022-04-26 | New Mexico | 35 | 521583 | 7456 |
43385 | 43385 | 2022-04-26 | New York | 36 | 5118962 | 67605 |
43386 | 43386 | 2022-04-26 | North Carolina | 37 | 2649978 | 23373 |
43387 | 43387 | 2022-04-26 | North Dakota | 38 | 240818 | 2310 |
43388 | 43388 | 2022-04-26 | Northern Mariana Islands | 69 | 11263 | 34 |
43389 | 43389 | 2022-04-26 | Ohio | 39 | 2688327 | 38360 |
43390 | 43390 | 2022-04-26 | Oklahoma | 40 | 1039952 | 14219 |
43391 | 43391 | 2022-04-26 | Oregon | 41 | 717505 | 7488 |
43392 | 43392 | 2022-04-26 | Pennsylvania | 42 | 2810781 | 44616 |
43393 | 43393 | 2022-04-26 | Puerto Rico | 72 | 553127 | 4192 |
43394 | 43394 | 2022-04-26 | Rhode Island | 44 | 369723 | 3538 |
43395 | 43395 | 2022-04-26 | South Carolina | 45 | 1472093 | 17734 |
43396 | 43396 | 2022-04-26 | South Dakota | 46 | 237535 | 2901 |
43397 | 43397 | 2022-04-26 | Tennessee | 47 | 1979699 | 25882 |
43398 | 43398 | 2022-04-26 | Texas | 48 | 6741552 | 88234 |
43399 | 43399 | 2022-04-26 | Utah | 49 | 930785 | 4740 |
43400 | 43400 | 2022-04-26 | Vermont | 50 | 122341 | 629 |
43401 | 43401 | 2022-04-26 | Virgin Islands | 78 | 16154 | 111 |
43402 | 43402 | 2022-04-26 | Virginia | 51 | 1696048 | 20187 |
43403 | 43403 | 2022-04-26 | Washington | 53 | 1490295 | 12721 |
43404 | 43404 | 2022-04-26 | West Virginia | 54 | 500444 | 6845 |
43405 | 43405 | 2022-04-26 | Wisconsin | 55 | 1605708 | 14411 |
43406 | 43406 | 2022-04-26 | Wyoming | 56 | 156550 | 1812 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );