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-22 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 |
---|---|---|---|---|---|---|
56791 | 56791 | 2022-12-22 | Alabama | 1 | 1568934 | 21208 |
56792 | 56792 | 2022-12-22 | Alaska | 2 | 301449 | 1408 |
56793 | 56793 | 2022-12-22 | American Samoa | 60 | 8266 | 34 |
56794 | 56794 | 2022-12-22 | Arizona | 4 | 2373361 | 32038 |
56795 | 56795 | 2022-12-22 | Arkansas | 5 | 980736 | 12684 |
56796 | 56796 | 2022-12-22 | California | 6 | 11769634 | 100606 |
56797 | 56797 | 2022-12-22 | Colorado | 8 | 1729516 | 13831 |
56798 | 56798 | 2022-12-22 | Connecticut | 9 | 942022 | 11733 |
56799 | 56799 | 2022-12-22 | Delaware | 10 | 320581 | 3205 |
56800 | 56800 | 2022-12-22 | District of Columbia | 11 | 173626 | 1411 |
56801 | 56801 | 2022-12-22 | Florida | 12 | 7269428 | 83606 |
56802 | 56802 | 2022-12-22 | Georgia | 13 | 2888123 | 39913 |
56803 | 56803 | 2022-12-22 | Guam | 66 | 60727 | 412 |
56804 | 56804 | 2022-12-22 | Hawaii | 15 | 362117 | 1755 |
56805 | 56805 | 2022-12-22 | Idaho | 16 | 510656 | 5316 |
56806 | 56806 | 2022-12-22 | Illinois | 17 | 3957136 | 40586 |
56807 | 56807 | 2022-12-22 | Indiana | 18 | 1996253 | 25303 |
56808 | 56808 | 2022-12-22 | Iowa | 19 | 884263 | 10391 |
56809 | 56809 | 2022-12-22 | Kansas | 20 | 914319 | 9844 |
56810 | 56810 | 2022-12-22 | Kentucky | 21 | 1657664 | 17708 |
56811 | 56811 | 2022-12-22 | Louisiana | 22 | 1507707 | 18345 |
56812 | 56812 | 2022-12-22 | Maine | 23 | 305306 | 2803 |
56813 | 56813 | 2022-12-22 | Maryland | 24 | 1310411 | 15979 |
56814 | 56814 | 2022-12-22 | Massachusetts | 25 | 2144967 | 22793 |
56815 | 56815 | 2022-12-22 | Michigan | 26 | 2977727 | 40659 |
56816 | 56816 | 2022-12-22 | Minnesota | 27 | 1731172 | 14273 |
56817 | 56817 | 2022-12-22 | Mississippi | 28 | 951070 | 13113 |
56818 | 56818 | 2022-12-22 | Missouri | 29 | 1736053 | 23251 |
56819 | 56819 | 2022-12-22 | Montana | 30 | 321522 | 3632 |
56820 | 56820 | 2022-12-22 | Nebraska | 31 | 553378 | 4840 |
56821 | 56821 | 2022-12-22 | Nevada | 32 | 874117 | 11838 |
56822 | 56822 | 2022-12-22 | New Hampshire | 33 | 365847 | 2850 |
56823 | 56823 | 2022-12-22 | New Jersey | 34 | 2905434 | 35429 |
56824 | 56824 | 2022-12-22 | New Mexico | 35 | 656836 | 8794 |
56825 | 56825 | 2022-12-22 | New York | 36 | 6515108 | 77514 |
56826 | 56826 | 2022-12-22 | North Carolina | 37 | 3316814 | 28789 |
56827 | 56827 | 2022-12-22 | North Dakota | 38 | 279330 | 2469 |
56828 | 56828 | 2022-12-22 | Northern Mariana Islands | 69 | 13236 | 41 |
56829 | 56829 | 2022-12-22 | Ohio | 39 | 3294521 | 40949 |
56830 | 56830 | 2022-12-22 | Oklahoma | 40 | 1244121 | 16041 |
56831 | 56831 | 2022-12-22 | Oregon | 41 | 936721 | 8953 |
56832 | 56832 | 2022-12-22 | Pennsylvania | 42 | 3403177 | 48881 |
56833 | 56833 | 2022-12-22 | Puerto Rico | 72 | 1076489 | 5499 |
56834 | 56834 | 2022-12-22 | Rhode Island | 44 | 443645 | 3800 |
56835 | 56835 | 2022-12-22 | South Carolina | 45 | 1760204 | 19368 |
56836 | 56836 | 2022-12-22 | South Dakota | 46 | 271433 | 3136 |
56837 | 56837 | 2022-12-22 | Tennessee | 47 | 2358463 | 28262 |
56838 | 56838 | 2022-12-22 | Texas | 48 | 8080404 | 92625 |
56839 | 56839 | 2022-12-22 | Utah | 49 | 1072888 | 5177 |
56840 | 56840 | 2022-12-22 | Vermont | 50 | 148031 | 791 |
56841 | 56841 | 2022-12-22 | Virgin Islands | 78 | 23728 | 127 |
56842 | 56842 | 2022-12-22 | Virginia | 51 | 2188049 | 22763 |
56843 | 56843 | 2022-12-22 | Washington | 53 | 1879139 | 15021 |
56844 | 56844 | 2022-12-22 | West Virginia | 54 | 621614 | 7786 |
56845 | 56845 | 2022-12-22 | Wisconsin | 55 | 1953390 | 15819 |
56846 | 56846 | 2022-12-22 | Wyoming | 56 | 182581 | 1959 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );