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-31 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|
50463 | 50463 | 2022-08-31 | Alabama | 1 | 1491815 | 20113 |
50464 | 50464 | 2022-08-31 | Alaska | 2 | 292817 | 1297 |
50465 | 50465 | 2022-08-31 | American Samoa | 60 | 8168 | 34 |
50466 | 50466 | 2022-08-31 | Arizona | 4 | 2254374 | 31114 |
50467 | 50467 | 2022-08-31 | Arkansas | 5 | 932639 | 11918 |
50468 | 50468 | 2022-08-31 | California | 6 | 11091425 | 95001 |
50469 | 50469 | 2022-08-31 | Colorado | 8 | 1638142 | 13370 |
50470 | 50470 | 2022-08-31 | Connecticut | 9 | 875076 | 11269 |
50471 | 50471 | 2022-08-31 | Delaware | 10 | 302738 | 3042 |
50472 | 50472 | 2022-08-31 | District of Columbia | 11 | 166166 | 1381 |
50473 | 50473 | 2022-08-31 | Florida | 12 | 7025348 | 79853 |
50474 | 50474 | 2022-08-31 | Georgia | 13 | 2788282 | 38218 |
50475 | 50475 | 2022-08-31 | Guam | 66 | 58916 | 390 |
50476 | 50476 | 2022-08-31 | Hawaii | 15 | 331095 | 1641 |
50477 | 50477 | 2022-08-31 | Idaho | 16 | 489511 | 5118 |
50478 | 50478 | 2022-08-31 | Illinois | 17 | 3694055 | 39328 |
50479 | 50479 | 2022-08-31 | Indiana | 18 | 1895799 | 24418 |
50480 | 50480 | 2022-08-31 | Iowa | 19 | 842647 | 9940 |
50481 | 50481 | 2022-08-31 | Kansas | 20 | 864871 | 9019 |
50482 | 50482 | 2022-08-31 | Kentucky | 21 | 1551511 | 16679 |
50483 | 50483 | 2022-08-31 | Louisiana | 22 | 1431011 | 17871 |
50484 | 50484 | 2022-08-31 | Maine | 23 | 282808 | 2512 |
50485 | 50485 | 2022-08-31 | Maryland | 24 | 1223380 | 15188 |
50486 | 50486 | 2022-08-31 | Massachusetts | 25 | 2005250 | 21390 |
50487 | 50487 | 2022-08-31 | Michigan | 26 | 2770359 | 38038 |
50488 | 50488 | 2022-08-31 | Minnesota | 27 | 1630819 | 13429 |
50489 | 50489 | 2022-08-31 | Mississippi | 28 | 913049 | 12794 |
50490 | 50490 | 2022-08-31 | Missouri | 29 | 1628044 | 21428 |
50491 | 50491 | 2022-08-31 | Montana | 30 | 304498 | 3504 |
50492 | 50492 | 2022-08-31 | Nebraska | 31 | 529808 | 4455 |
50493 | 50493 | 2022-08-31 | Nevada | 32 | 841577 | 11400 |
50494 | 50494 | 2022-08-31 | New Hampshire | 33 | 344381 | 2662 |
50495 | 50495 | 2022-08-31 | New Jersey | 34 | 2676938 | 34562 |
50496 | 50496 | 2022-08-31 | New Mexico | 35 | 611310 | 8449 |
50497 | 50497 | 2022-08-31 | New York | 36 | 5975934 | 70403 |
50498 | 50498 | 2022-08-31 | North Carolina | 37 | 3120821 | 26345 |
50499 | 50499 | 2022-08-31 | North Dakota | 38 | 264517 | 2395 |
50500 | 50500 | 2022-08-31 | Northern Mariana Islands | 69 | 13120 | 40 |
50501 | 50501 | 2022-08-31 | Ohio | 39 | 3049546 | 39406 |
50502 | 50502 | 2022-08-31 | Oklahoma | 40 | 1170225 | 14670 |
50503 | 50503 | 2022-08-31 | Oregon | 41 | 878148 | 8412 |
50504 | 50504 | 2022-08-31 | Pennsylvania | 42 | 3185902 | 46716 |
50505 | 50505 | 2022-08-31 | Puerto Rico | 72 | 957228 | 4971 |
50506 | 50506 | 2022-08-31 | Rhode Island | 44 | 416638 | 3643 |
50507 | 50507 | 2022-08-31 | South Carolina | 45 | 1674281 | 18263 |
50508 | 50508 | 2022-08-31 | South Dakota | 46 | 257547 | 2993 |
50509 | 50509 | 2022-08-31 | Tennessee | 47 | 2239401 | 27164 |
50510 | 50510 | 2022-08-31 | Texas | 48 | 7738083 | 90390 |
50511 | 50511 | 2022-08-31 | Utah | 49 | 1027083 | 4968 |
50512 | 50512 | 2022-08-31 | Vermont | 50 | 140308 | 707 |
50513 | 50513 | 2022-08-31 | Virgin Islands | 78 | 22711 | 122 |
50514 | 50514 | 2022-08-31 | Virginia | 51 | 2040106 | 21416 |
50515 | 50515 | 2022-08-31 | Washington | 53 | 1784891 | 14079 |
50516 | 50516 | 2022-08-31 | West Virginia | 54 | 582666 | 7286 |
50517 | 50517 | 2022-08-31 | Wisconsin | 55 | 1832397 | 15072 |
50518 | 50518 | 2022-08-31 | Wyoming | 56 | 174828 | 1881 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );