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-09-19 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 |
---|---|---|---|---|---|---|
51527 | 51527 | 2022-09-19 | Alabama | 1 | 1514795 | 20345 |
51528 | 51528 | 2022-09-19 | Alaska | 2 | 295121 | 1321 |
51529 | 51529 | 2022-09-19 | American Samoa | 60 | 8217 | 34 |
51530 | 51530 | 2022-09-19 | Arizona | 4 | 2264159 | 31244 |
51531 | 51531 | 2022-09-19 | Arkansas | 5 | 946576 | 11993 |
51532 | 51532 | 2022-09-19 | California | 6 | 11199912 | 95680 |
51533 | 51533 | 2022-09-19 | Colorado | 8 | 1653463 | 13450 |
51534 | 51534 | 2022-09-19 | Connecticut | 9 | 888862 | 11331 |
51535 | 51535 | 2022-09-19 | Delaware | 10 | 306374 | 3086 |
51536 | 51536 | 2022-09-19 | District of Columbia | 11 | 167489 | 1382 |
51537 | 51537 | 2022-09-19 | Florida | 12 | 7095615 | 80949 |
51538 | 51538 | 2022-09-19 | Georgia | 13 | 2809555 | 38468 |
51539 | 51539 | 2022-09-19 | Guam | 66 | 59339 | 395 |
51540 | 51540 | 2022-09-19 | Hawaii | 15 | 333547 | 1662 |
51541 | 51541 | 2022-09-19 | Idaho | 16 | 493668 | 5161 |
51542 | 51542 | 2022-09-19 | Illinois | 17 | 3744944 | 39551 |
51543 | 51543 | 2022-09-19 | Indiana | 18 | 1915905 | 24605 |
51544 | 51544 | 2022-09-19 | Iowa | 19 | 852206 | 9994 |
51545 | 51545 | 2022-09-19 | Kansas | 20 | 873582 | 9097 |
51546 | 51546 | 2022-09-19 | Kentucky | 21 | 1583569 | 16902 |
51547 | 51547 | 2022-09-19 | Louisiana | 22 | 1449815 | 17982 |
51548 | 51548 | 2022-09-19 | Maine | 23 | 286567 | 2566 |
51549 | 51549 | 2022-09-19 | Maryland | 24 | 1239990 | 15311 |
51550 | 51550 | 2022-09-19 | Massachusetts | 25 | 2030335 | 21588 |
51551 | 51551 | 2022-09-19 | Michigan | 26 | 2804588 | 38317 |
51552 | 51552 | 2022-09-19 | Minnesota | 27 | 1651999 | 13558 |
51553 | 51553 | 2022-09-19 | Mississippi | 28 | 922493 | 12853 |
51554 | 51554 | 2022-09-19 | Missouri | 29 | 1655420 | 21593 |
51555 | 51555 | 2022-09-19 | Montana | 30 | 308301 | 3513 |
51556 | 51556 | 2022-09-19 | Nebraska | 31 | 534818 | 4490 |
51557 | 51557 | 2022-09-19 | Nevada | 32 | 845879 | 11445 |
51558 | 51558 | 2022-09-19 | New Hampshire | 33 | 347415 | 2684 |
51559 | 51559 | 2022-09-19 | New Jersey | 34 | 2713791 | 34684 |
51560 | 51560 | 2022-09-19 | New Mexico | 35 | 616125 | 8523 |
51561 | 51561 | 2022-09-19 | New York | 36 | 6055837 | 70802 |
51562 | 51562 | 2022-09-19 | North Carolina | 37 | 3162491 | 26424 |
51563 | 51563 | 2022-09-19 | North Dakota | 38 | 267287 | 2411 |
51564 | 51564 | 2022-09-19 | Northern Mariana Islands | 69 | 13155 | 40 |
51565 | 51565 | 2022-09-19 | Ohio | 39 | 3117109 | 39675 |
51566 | 51566 | 2022-09-19 | Oklahoma | 40 | 1190969 | 14784 |
51567 | 51567 | 2022-09-19 | Oregon | 41 | 885963 | 8492 |
51568 | 51568 | 2022-09-19 | Pennsylvania | 42 | 3222783 | 46970 |
51569 | 51569 | 2022-09-19 | Puerto Rico | 72 | 981287 | 5074 |
51570 | 51570 | 2022-09-19 | Rhode Island | 44 | 421739 | 3661 |
51571 | 51571 | 2022-09-19 | South Carolina | 45 | 1696746 | 18316 |
51572 | 51572 | 2022-09-19 | South Dakota | 46 | 259683 | 3014 |
51573 | 51573 | 2022-09-19 | Tennessee | 47 | 2268357 | 27346 |
51574 | 51574 | 2022-09-19 | Texas | 48 | 7848768 | 90760 |
51575 | 51575 | 2022-09-19 | Utah | 49 | 1034893 | 5001 |
51576 | 51576 | 2022-09-19 | Vermont | 50 | 141282 | 715 |
51577 | 51577 | 2022-09-19 | Virgin Islands | 78 | 23065 | 123 |
51578 | 51578 | 2022-09-19 | Virginia | 51 | 2074003 | 21693 |
51579 | 51579 | 2022-09-19 | Washington | 53 | 1803850 | 14247 |
51580 | 51580 | 2022-09-19 | West Virginia | 54 | 596267 | 7367 |
51581 | 51581 | 2022-09-19 | Wisconsin | 55 | 1851892 | 15190 |
51582 | 51582 | 2022-09-19 | Wyoming | 56 | 175746 | 1888 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );