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-23 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 56
- 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
- Nevada 1
- New Hampshire 1
- New Jersey 1
- New Mexico 1
- New York 1
- North Carolina 1
- North Dakota 1
- Northern Mariana Islands 1
- Ohio 1
- Oklahoma 1
- Oregon 1
- Pennsylvania 1
- Puerto Rico 1
- Rhode Island 1
- South Carolina 1
- South Dakota 1
- Tennessee 1
- Texas 1
- Utah 1
- Vermont 1
- Virgin Islands 1
- Virginia 1
- Washington 1
- West Virginia 1
- Wisconsin 1
- Wyoming 1
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
56847 | 56847 | 2022-12-23 | Alabama | 1 | 1568934 | 21208 |
56848 | 56848 | 2022-12-23 | Alaska | 2 | 301449 | 1408 |
56849 | 56849 | 2022-12-23 | American Samoa | 60 | 8266 | 34 |
56850 | 56850 | 2022-12-23 | Arizona | 4 | 2373361 | 32038 |
56851 | 56851 | 2022-12-23 | Arkansas | 5 | 981276 | 12690 |
56852 | 56852 | 2022-12-23 | California | 6 | 11772574 | 100628 |
56853 | 56853 | 2022-12-23 | Colorado | 8 | 1730237 | 13857 |
56854 | 56854 | 2022-12-23 | Connecticut | 9 | 943284 | 11733 |
56855 | 56855 | 2022-12-23 | Delaware | 10 | 320581 | 3205 |
56856 | 56856 | 2022-12-23 | District of Columbia | 11 | 173626 | 1411 |
56857 | 56857 | 2022-12-23 | Florida | 12 | 7269428 | 83606 |
56858 | 56858 | 2022-12-23 | Georgia | 13 | 2888123 | 39913 |
56859 | 56859 | 2022-12-23 | Guam | 66 | 60727 | 412 |
56860 | 56860 | 2022-12-23 | Hawaii | 15 | 362117 | 1755 |
56861 | 56861 | 2022-12-23 | Idaho | 16 | 510661 | 5316 |
56862 | 56862 | 2022-12-23 | Illinois | 17 | 3960888 | 40610 |
56863 | 56863 | 2022-12-23 | Indiana | 18 | 1996253 | 25303 |
56864 | 56864 | 2022-12-23 | Iowa | 19 | 884263 | 10391 |
56865 | 56865 | 2022-12-23 | Kansas | 20 | 914344 | 9850 |
56866 | 56866 | 2022-12-23 | Kentucky | 21 | 1657664 | 17708 |
56867 | 56867 | 2022-12-23 | Louisiana | 22 | 1507707 | 18345 |
56868 | 56868 | 2022-12-23 | Maine | 23 | 305446 | 2803 |
56869 | 56869 | 2022-12-23 | Maryland | 24 | 1311672 | 15985 |
56870 | 56870 | 2022-12-23 | Massachusetts | 25 | 2144967 | 22793 |
56871 | 56871 | 2022-12-23 | Michigan | 26 | 2977727 | 40659 |
56872 | 56872 | 2022-12-23 | Minnesota | 27 | 1731172 | 14273 |
56873 | 56873 | 2022-12-23 | Mississippi | 28 | 951070 | 13113 |
56874 | 56874 | 2022-12-23 | Missouri | 29 | 1736293 | 23252 |
56875 | 56875 | 2022-12-23 | Montana | 30 | 322437 | 3635 |
56876 | 56876 | 2022-12-23 | Nebraska | 31 | 554953 | 4841 |
56877 | 56877 | 2022-12-23 | Nevada | 32 | 874117 | 11838 |
56878 | 56878 | 2022-12-23 | New Hampshire | 33 | 366116 | 2851 |
56879 | 56879 | 2022-12-23 | New Jersey | 34 | 2908733 | 35446 |
56880 | 56880 | 2022-12-23 | New Mexico | 35 | 657140 | 8802 |
56881 | 56881 | 2022-12-23 | New York | 36 | 6523020 | 77546 |
56882 | 56882 | 2022-12-23 | North Carolina | 37 | 3316814 | 28789 |
56883 | 56883 | 2022-12-23 | North Dakota | 38 | 280043 | 2469 |
56884 | 56884 | 2022-12-23 | Northern Mariana Islands | 69 | 13236 | 41 |
56885 | 56885 | 2022-12-23 | Ohio | 39 | 3294521 | 40949 |
56886 | 56886 | 2022-12-23 | Oklahoma | 40 | 1244121 | 16041 |
56887 | 56887 | 2022-12-23 | Oregon | 41 | 936721 | 8953 |
56888 | 56888 | 2022-12-23 | Pennsylvania | 42 | 3403177 | 48881 |
56889 | 56889 | 2022-12-23 | Puerto Rico | 72 | 1078239 | 5502 |
56890 | 56890 | 2022-12-23 | Rhode Island | 44 | 443645 | 3800 |
56891 | 56891 | 2022-12-23 | South Carolina | 45 | 1760204 | 19368 |
56892 | 56892 | 2022-12-23 | South Dakota | 46 | 271433 | 3136 |
56893 | 56893 | 2022-12-23 | Tennessee | 47 | 2358463 | 28262 |
56894 | 56894 | 2022-12-23 | Texas | 48 | 8080404 | 92628 |
56895 | 56895 | 2022-12-23 | Utah | 49 | 1072888 | 5177 |
56896 | 56896 | 2022-12-23 | Vermont | 50 | 148031 | 791 |
56897 | 56897 | 2022-12-23 | Virgin Islands | 78 | 23734 | 127 |
56898 | 56898 | 2022-12-23 | Virginia | 51 | 2190699 | 22773 |
56899 | 56899 | 2022-12-23 | Washington | 53 | 1879139 | 15021 |
56900 | 56900 | 2022-12-23 | West Virginia | 54 | 621614 | 7786 |
56901 | 56901 | 2022-12-23 | Wisconsin | 55 | 1954481 | 15826 |
56902 | 56902 | 2022-12-23 | 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 );