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-20 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 |
---|---|---|---|---|---|---|
51583 | 51583 | 2022-09-20 | Alabama | 1 | 1515969 | 20367 |
51584 | 51584 | 2022-09-20 | Alaska | 2 | 295121 | 1321 |
51585 | 51585 | 2022-09-20 | American Samoa | 60 | 8217 | 34 |
51586 | 51586 | 2022-09-20 | Arizona | 4 | 2264159 | 31244 |
51587 | 51587 | 2022-09-20 | Arkansas | 5 | 947211 | 12017 |
51588 | 51588 | 2022-09-20 | California | 6 | 11201464 | 95695 |
51589 | 51589 | 2022-09-20 | Colorado | 8 | 1654266 | 13455 |
51590 | 51590 | 2022-09-20 | Connecticut | 9 | 889661 | 11343 |
51591 | 51591 | 2022-09-20 | Delaware | 10 | 306522 | 3086 |
51592 | 51592 | 2022-09-20 | District of Columbia | 11 | 167796 | 1382 |
51593 | 51593 | 2022-09-20 | Florida | 12 | 7098315 | 80954 |
51594 | 51594 | 2022-09-20 | Georgia | 13 | 2809555 | 38468 |
51595 | 51595 | 2022-09-20 | Guam | 66 | 59399 | 396 |
51596 | 51596 | 2022-09-20 | Hawaii | 15 | 333547 | 1662 |
51597 | 51597 | 2022-09-20 | Idaho | 16 | 493705 | 5161 |
51598 | 51598 | 2022-09-20 | Illinois | 17 | 3746966 | 39576 |
51599 | 51599 | 2022-09-20 | Indiana | 18 | 1915905 | 24614 |
51600 | 51600 | 2022-09-20 | Iowa | 19 | 853064 | 9994 |
51601 | 51601 | 2022-09-20 | Kansas | 20 | 873734 | 9095 |
51602 | 51602 | 2022-09-20 | Kentucky | 21 | 1583626 | 16902 |
51603 | 51603 | 2022-09-20 | Louisiana | 22 | 1450613 | 17988 |
51604 | 51604 | 2022-09-20 | Maine | 23 | 287032 | 2569 |
51605 | 51605 | 2022-09-20 | Maryland | 24 | 1241973 | 15329 |
51606 | 51606 | 2022-09-20 | Massachusetts | 25 | 2030335 | 21588 |
51607 | 51607 | 2022-09-20 | Michigan | 26 | 2813107 | 38415 |
51608 | 51608 | 2022-09-20 | Minnesota | 27 | 1651999 | 13558 |
51609 | 51609 | 2022-09-20 | Mississippi | 28 | 925596 | 12879 |
51610 | 51610 | 2022-09-20 | Missouri | 29 | 1656056 | 21593 |
51611 | 51611 | 2022-09-20 | Montana | 30 | 308301 | 3513 |
51612 | 51612 | 2022-09-20 | Nebraska | 31 | 535595 | 4490 |
51613 | 51613 | 2022-09-20 | Nevada | 32 | 846133 | 11446 |
51614 | 51614 | 2022-09-20 | New Hampshire | 33 | 347953 | 2687 |
51615 | 51615 | 2022-09-20 | New Jersey | 34 | 2715620 | 34694 |
51616 | 51616 | 2022-09-20 | New Mexico | 35 | 616360 | 8526 |
51617 | 51617 | 2022-09-20 | New York | 36 | 6059413 | 70850 |
51618 | 51618 | 2022-09-20 | North Carolina | 37 | 3162491 | 26424 |
51619 | 51619 | 2022-09-20 | North Dakota | 38 | 267287 | 2411 |
51620 | 51620 | 2022-09-20 | Northern Mariana Islands | 69 | 13166 | 40 |
51621 | 51621 | 2022-09-20 | Ohio | 39 | 3117109 | 39675 |
51622 | 51622 | 2022-09-20 | Oklahoma | 40 | 1192446 | 14784 |
51623 | 51623 | 2022-09-20 | Oregon | 41 | 885963 | 8492 |
51624 | 51624 | 2022-09-20 | Pennsylvania | 42 | 3222783 | 46970 |
51625 | 51625 | 2022-09-20 | Puerto Rico | 72 | 981287 | 5077 |
51626 | 51626 | 2022-09-20 | Rhode Island | 44 | 421739 | 3661 |
51627 | 51627 | 2022-09-20 | South Carolina | 45 | 1703439 | 18331 |
51628 | 51628 | 2022-09-20 | South Dakota | 46 | 259683 | 3014 |
51629 | 51629 | 2022-09-20 | Tennessee | 47 | 2270672 | 27356 |
51630 | 51630 | 2022-09-20 | Texas | 48 | 7849650 | 90760 |
51631 | 51631 | 2022-09-20 | Utah | 49 | 1034893 | 5001 |
51632 | 51632 | 2022-09-20 | Vermont | 50 | 141282 | 715 |
51633 | 51633 | 2022-09-20 | Virgin Islands | 78 | 23083 | 123 |
51634 | 51634 | 2022-09-20 | Virginia | 51 | 2075283 | 21712 |
51635 | 51635 | 2022-09-20 | Washington | 53 | 1803850 | 14247 |
51636 | 51636 | 2022-09-20 | West Virginia | 54 | 596709 | 7370 |
51637 | 51637 | 2022-09-20 | Wisconsin | 55 | 1855835 | 15213 |
51638 | 51638 | 2022-09-20 | Wyoming | 56 | 176256 | 1891 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );