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-25 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 |
---|---|---|---|---|---|---|
36519 | 36519 | 2021-12-25 | Alabama | 1 | 868085 | 16418 |
36520 | 36520 | 2021-12-25 | Alaska | 2 | 154269 | 952 |
36521 | 36521 | 2021-12-25 | American Samoa | 60 | 11 | 0 |
36522 | 36522 | 2021-12-25 | Arizona | 4 | 1354708 | 23983 |
36523 | 36523 | 2021-12-25 | Arkansas | 5 | 549991 | 9058 |
36524 | 36524 | 2021-12-25 | California | 6 | 5291605 | 76319 |
36525 | 36525 | 2021-12-25 | Colorado | 8 | 890682 | 10277 |
36526 | 36526 | 2021-12-25 | Connecticut | 9 | 474557 | 9077 |
36527 | 36527 | 2021-12-25 | Delaware | 10 | 171563 | 2271 |
36528 | 36528 | 2021-12-25 | District of Columbia | 11 | 79565 | 1207 |
36529 | 36529 | 2021-12-25 | Florida | 12 | 3864213 | 62347 |
36530 | 36530 | 2021-12-25 | Georgia | 13 | 1698099 | 30061 |
36531 | 36531 | 2021-12-25 | Guam | 66 | 20396 | 271 |
36532 | 36532 | 2021-12-25 | Hawaii | 15 | 97022 | 1079 |
36533 | 36533 | 2021-12-25 | Idaho | 16 | 315786 | 4102 |
36534 | 36534 | 2021-12-25 | Illinois | 17 | 2025804 | 30566 |
36535 | 36535 | 2021-12-25 | Indiana | 18 | 1204621 | 18696 |
36536 | 36536 | 2021-12-25 | Iowa | 19 | 563955 | 7799 |
36537 | 36537 | 2021-12-25 | Kansas | 20 | 506519 | 6979 |
36538 | 36538 | 2021-12-25 | Kentucky | 21 | 841343 | 11964 |
36539 | 36539 | 2021-12-25 | Louisiana | 22 | 790373 | 14953 |
36540 | 36540 | 2021-12-25 | Maine | 23 | 141780 | 1475 |
36541 | 36541 | 2021-12-25 | Maryland | 24 | 638612 | 11255 |
36542 | 36542 | 2021-12-25 | Massachusetts | 25 | 1055519 | 20050 |
36543 | 36543 | 2021-12-25 | Michigan | 26 | 1642383 | 28310 |
36544 | 36544 | 2021-12-25 | Minnesota | 27 | 996358 | 10440 |
36545 | 36545 | 2021-12-25 | Mississippi | 28 | 525502 | 10393 |
36546 | 36546 | 2021-12-25 | Missouri | 29 | 991121 | 16022 |
36547 | 36547 | 2021-12-25 | Montana | 30 | 195881 | 2896 |
36548 | 36548 | 2021-12-25 | Nebraska | 31 | 331081 | 3317 |
36549 | 36549 | 2021-12-25 | Nevada | 32 | 489279 | 8364 |
36550 | 36550 | 2021-12-25 | New Hampshire | 33 | 189987 | 1877 |
36551 | 36551 | 2021-12-25 | New Jersey | 34 | 1429756 | 28854 |
36552 | 36552 | 2021-12-25 | New Mexico | 35 | 342649 | 5747 |
36553 | 36553 | 2021-12-25 | New York | 36 | 3098290 | 58422 |
36554 | 36554 | 2021-12-25 | North Carolina | 37 | 1607774 | 19243 |
36555 | 36555 | 2021-12-25 | North Dakota | 38 | 171404 | 2040 |
36556 | 36556 | 2021-12-25 | Northern Mariana Islands | 69 | 2737 | 8 |
36557 | 36557 | 2021-12-25 | Ohio | 39 | 1910991 | 28720 |
36558 | 36558 | 2021-12-25 | Oklahoma | 40 | 694210 | 11503 |
36559 | 36559 | 2021-12-25 | Oregon | 41 | 410565 | 5598 |
36560 | 36560 | 2021-12-25 | Pennsylvania | 42 | 1947649 | 36050 |
36561 | 36561 | 2021-12-25 | Puerto Rico | 72 | 258897 | 3291 |
36562 | 36562 | 2021-12-25 | Rhode Island | 44 | 217228 | 3018 |
36563 | 36563 | 2021-12-25 | South Carolina | 45 | 944574 | 14550 |
36564 | 36564 | 2021-12-25 | South Dakota | 46 | 175677 | 2456 |
36565 | 36565 | 2021-12-25 | Tennessee | 47 | 1336088 | 20181 |
36566 | 36566 | 2021-12-25 | Texas | 48 | 4469813 | 75635 |
36567 | 36567 | 2021-12-25 | Utah | 49 | 623853 | 3754 |
36568 | 36568 | 2021-12-25 | Vermont | 50 | 60265 | 460 |
36569 | 36569 | 2021-12-25 | Virgin Islands | 78 | 7763 | 88 |
36570 | 36570 | 2021-12-25 | Virginia | 51 | 1049336 | 15294 |
36571 | 36571 | 2021-12-25 | Washington | 53 | 817678 | 9828 |
36572 | 36572 | 2021-12-25 | West Virginia | 54 | 319035 | 5251 |
36573 | 36573 | 2021-12-25 | Wisconsin | 55 | 1083571 | 11017 |
36574 | 36574 | 2021-12-25 | 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 );