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 2021-12-24 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 |
---|---|---|---|---|---|---|
36463 | 36463 | 2021-12-24 | Alabama | 1 | 865636 | 16418 |
36464 | 36464 | 2021-12-24 | Alaska | 2 | 154269 | 952 |
36465 | 36465 | 2021-12-24 | American Samoa | 60 | 11 | 0 |
36466 | 36466 | 2021-12-24 | Arizona | 4 | 1351213 | 23913 |
36467 | 36467 | 2021-12-24 | Arkansas | 5 | 548967 | 9044 |
36468 | 36468 | 2021-12-24 | California | 6 | 5291605 | 76317 |
36469 | 36469 | 2021-12-24 | Colorado | 8 | 889465 | 10277 |
36470 | 36470 | 2021-12-24 | Connecticut | 9 | 474557 | 9077 |
36471 | 36471 | 2021-12-24 | Delaware | 10 | 170009 | 2271 |
36472 | 36472 | 2021-12-24 | District of Columbia | 11 | 79565 | 1207 |
36473 | 36473 | 2021-12-24 | Florida | 12 | 3864213 | 62347 |
36474 | 36474 | 2021-12-24 | Georgia | 13 | 1698099 | 30061 |
36475 | 36475 | 2021-12-24 | Guam | 66 | 20396 | 271 |
36476 | 36476 | 2021-12-24 | Hawaii | 15 | 95454 | 1075 |
36477 | 36477 | 2021-12-24 | Idaho | 16 | 315786 | 4102 |
36478 | 36478 | 2021-12-24 | Illinois | 17 | 2025804 | 30566 |
36479 | 36479 | 2021-12-24 | Indiana | 18 | 1204621 | 18696 |
36480 | 36480 | 2021-12-24 | Iowa | 19 | 563955 | 7799 |
36481 | 36481 | 2021-12-24 | Kansas | 20 | 506519 | 6979 |
36482 | 36482 | 2021-12-24 | Kentucky | 21 | 841060 | 11964 |
36483 | 36483 | 2021-12-24 | Louisiana | 22 | 790373 | 14953 |
36484 | 36484 | 2021-12-24 | Maine | 23 | 141780 | 1475 |
36485 | 36485 | 2021-12-24 | Maryland | 24 | 638612 | 11255 |
36486 | 36486 | 2021-12-24 | Massachusetts | 25 | 1055519 | 20050 |
36487 | 36487 | 2021-12-24 | Michigan | 26 | 1642383 | 28310 |
36488 | 36488 | 2021-12-24 | Minnesota | 27 | 996358 | 10440 |
36489 | 36489 | 2021-12-24 | Mississippi | 28 | 525502 | 10393 |
36490 | 36490 | 2021-12-24 | Missouri | 29 | 991121 | 16022 |
36491 | 36491 | 2021-12-24 | Montana | 30 | 195881 | 2896 |
36492 | 36492 | 2021-12-24 | Nebraska | 31 | 331081 | 3317 |
36493 | 36493 | 2021-12-24 | Nevada | 32 | 489279 | 8364 |
36494 | 36494 | 2021-12-24 | New Hampshire | 33 | 189987 | 1877 |
36495 | 36495 | 2021-12-24 | New Jersey | 34 | 1410275 | 28848 |
36496 | 36496 | 2021-12-24 | New Mexico | 35 | 342649 | 5747 |
36497 | 36497 | 2021-12-24 | New York | 36 | 3098290 | 58422 |
36498 | 36498 | 2021-12-24 | North Carolina | 37 | 1607774 | 19243 |
36499 | 36499 | 2021-12-24 | North Dakota | 38 | 171237 | 2040 |
36500 | 36500 | 2021-12-24 | Northern Mariana Islands | 69 | 2737 | 8 |
36501 | 36501 | 2021-12-24 | Ohio | 39 | 1910991 | 28720 |
36502 | 36502 | 2021-12-24 | Oklahoma | 40 | 694210 | 11503 |
36503 | 36503 | 2021-12-24 | Oregon | 41 | 410565 | 5598 |
36504 | 36504 | 2021-12-24 | Pennsylvania | 42 | 1937793 | 36050 |
36505 | 36505 | 2021-12-24 | Puerto Rico | 72 | 241643 | 3288 |
36506 | 36506 | 2021-12-24 | Rhode Island | 44 | 217228 | 3018 |
36507 | 36507 | 2021-12-24 | South Carolina | 45 | 944574 | 14550 |
36508 | 36508 | 2021-12-24 | South Dakota | 46 | 175677 | 2456 |
36509 | 36509 | 2021-12-24 | Tennessee | 47 | 1336088 | 20181 |
36510 | 36510 | 2021-12-24 | Texas | 48 | 4469813 | 75635 |
36511 | 36511 | 2021-12-24 | Utah | 49 | 623853 | 3754 |
36512 | 36512 | 2021-12-24 | Vermont | 50 | 60265 | 460 |
36513 | 36513 | 2021-12-24 | Virgin Islands | 78 | 7763 | 88 |
36514 | 36514 | 2021-12-24 | Virginia | 51 | 1049336 | 15294 |
36515 | 36515 | 2021-12-24 | Washington | 53 | 817678 | 9828 |
36516 | 36516 | 2021-12-24 | West Virginia | 54 | 319035 | 5251 |
36517 | 36517 | 2021-12-24 | Wisconsin | 55 | 1083571 | 11017 |
36518 | 36518 | 2021-12-24 | Wyoming | 56 | 114242 | 1526 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );