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-12-15 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 |
---|---|---|---|---|---|---|
56399 | 56399 | 2022-12-15 | Alabama | 1 | 1561557 | 21178 |
56400 | 56400 | 2022-12-15 | Alaska | 2 | 301071 | 1390 |
56401 | 56401 | 2022-12-15 | American Samoa | 60 | 8265 | 34 |
56402 | 56402 | 2022-12-15 | Arizona | 4 | 2365080 | 31929 |
56403 | 56403 | 2022-12-15 | Arkansas | 5 | 977088 | 12663 |
56404 | 56404 | 2022-12-15 | California | 6 | 11685057 | 100350 |
56405 | 56405 | 2022-12-15 | Colorado | 8 | 1723043 | 13769 |
56406 | 56406 | 2022-12-15 | Connecticut | 9 | 936976 | 11659 |
56407 | 56407 | 2022-12-15 | Delaware | 10 | 319477 | 3185 |
56408 | 56408 | 2022-12-15 | District of Columbia | 11 | 172626 | 1407 |
56409 | 56409 | 2022-12-15 | Florida | 12 | 7226875 | 83200 |
56410 | 56410 | 2022-12-15 | Georgia | 13 | 2876843 | 39810 |
56411 | 56411 | 2022-12-15 | Guam | 66 | 60543 | 411 |
56412 | 56412 | 2022-12-15 | Hawaii | 15 | 360969 | 1745 |
56413 | 56413 | 2022-12-15 | Idaho | 16 | 509287 | 5301 |
56414 | 56414 | 2022-12-15 | Illinois | 17 | 3934504 | 40477 |
56415 | 56415 | 2022-12-15 | Indiana | 18 | 1987017 | 25303 |
56416 | 56416 | 2022-12-15 | Iowa | 19 | 880770 | 10345 |
56417 | 56417 | 2022-12-15 | Kansas | 20 | 910226 | 9834 |
56418 | 56418 | 2022-12-15 | Kentucky | 21 | 1650511 | 17667 |
56419 | 56419 | 2022-12-15 | Louisiana | 22 | 1482269 | 18324 |
56420 | 56420 | 2022-12-15 | Maine | 23 | 304098 | 2802 |
56421 | 56421 | 2022-12-15 | Maryland | 24 | 1303048 | 15936 |
56422 | 56422 | 2022-12-15 | Massachusetts | 25 | 2134100 | 22683 |
56423 | 56423 | 2022-12-15 | Michigan | 26 | 2963404 | 40510 |
56424 | 56424 | 2022-12-15 | Minnesota | 27 | 1725293 | 14220 |
56425 | 56425 | 2022-12-15 | Mississippi | 28 | 946657 | 13093 |
56426 | 56426 | 2022-12-15 | Missouri | 29 | 1727729 | 23195 |
56427 | 56427 | 2022-12-15 | Montana | 30 | 320409 | 3628 |
56428 | 56428 | 2022-12-15 | Nebraska | 31 | 550012 | 4834 |
56429 | 56429 | 2022-12-15 | Nevada | 32 | 871644 | 11811 |
56430 | 56430 | 2022-12-15 | New Hampshire | 33 | 364282 | 2839 |
56431 | 56431 | 2022-12-15 | New Jersey | 34 | 2885988 | 35331 |
56432 | 56432 | 2022-12-15 | New Mexico | 35 | 654580 | 8778 |
56433 | 56433 | 2022-12-15 | New York | 36 | 6468605 | 77331 |
56434 | 56434 | 2022-12-15 | North Carolina | 37 | 3300138 | 28760 |
56435 | 56435 | 2022-12-15 | North Dakota | 38 | 278399 | 2461 |
56436 | 56436 | 2022-12-15 | Northern Mariana Islands | 69 | 13227 | 41 |
56437 | 56437 | 2022-12-15 | Ohio | 39 | 3276630 | 40874 |
56438 | 56438 | 2022-12-15 | Oklahoma | 40 | 1237781 | 16033 |
56439 | 56439 | 2022-12-15 | Oregon | 41 | 933108 | 8940 |
56440 | 56440 | 2022-12-15 | Pennsylvania | 42 | 3388571 | 48746 |
56441 | 56441 | 2022-12-15 | Puerto Rico | 72 | 1066412 | 5463 |
56442 | 56442 | 2022-12-15 | Rhode Island | 44 | 441692 | 3808 |
56443 | 56443 | 2022-12-15 | South Carolina | 45 | 1751646 | 19346 |
56444 | 56444 | 2022-12-15 | South Dakota | 46 | 270809 | 3135 |
56445 | 56445 | 2022-12-15 | Tennessee | 47 | 2348275 | 28183 |
56446 | 56446 | 2022-12-15 | Texas | 48 | 8049132 | 92527 |
56447 | 56447 | 2022-12-15 | Utah | 49 | 1070006 | 5161 |
56448 | 56448 | 2022-12-15 | Vermont | 50 | 147657 | 781 |
56449 | 56449 | 2022-12-15 | Virgin Islands | 78 | 23679 | 126 |
56450 | 56450 | 2022-12-15 | Virginia | 51 | 2173547 | 22709 |
56451 | 56451 | 2022-12-15 | Washington | 53 | 1871929 | 14929 |
56452 | 56452 | 2022-12-15 | West Virginia | 54 | 618893 | 7783 |
56453 | 56453 | 2022-12-15 | Wisconsin | 55 | 1944979 | 15780 |
56454 | 56454 | 2022-12-15 | Wyoming | 56 | 182198 | 1951 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );