ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
57,238 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 56
- Washington 1,073
- Illinois 1,069
- California 1,068
- Arizona 1,067
- Massachusetts 1,061
- Wisconsin 1,058
- Texas 1,051
- Nebraska 1,045
- Utah 1,038
- Oregon 1,034
- Florida 1,032
- New York 1,032
- Rhode Island 1,032
- Georgia 1,031
- New Hampshire 1,031
- North Carolina 1,030
- New Jersey 1,029
- Tennessee 1,029
- Colorado 1,028
- Maryland 1,028
- Nevada 1,028
- South Carolina 1,028
- Hawaii 1,027
- Indiana 1,027
- Kentucky 1,027
- Minnesota 1,027
- Oklahoma 1,027
- Pennsylvania 1,027
- Vermont 1,027
- Virginia 1,027
- District of Columbia 1,026
- Kansas 1,026
- Missouri 1,026
- Connecticut 1,025
- Iowa 1,025
- Louisiana 1,024
- Ohio 1,024
- South Dakota 1,024
- Michigan 1,023
- Wyoming 1,023
- Arkansas 1,022
- Delaware 1,022
- Mississippi 1,022
- New Mexico 1,022
- North Dakota 1,022
- Alaska 1,021
- Maine 1,021
- Alabama 1,020
- Idaho 1,020
- Montana 1,020
- Puerto Rico 1,020
- Virgin Islands 1,020
- Guam 1,018
- West Virginia 1,017
- Northern Mariana Islands 1,005
- American Samoa 462
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
57171 | 57171 | 2022-12-28 | South Carolina | 45 | 1770059 | 19385 |
57172 | 57172 | 2022-12-28 | South Dakota | 46 | 271856 | 3138 |
57173 | 57173 | 2022-12-28 | Tennessee | 47 | 2367936 | 28274 |
57174 | 57174 | 2022-12-28 | Texas | 48 | 8113137 | 92704 |
57175 | 57175 | 2022-12-28 | Utah | 49 | 1072888 | 5177 |
57176 | 57176 | 2022-12-28 | Vermont | 50 | 148393 | 791 |
57177 | 57177 | 2022-12-28 | Virgin Islands | 78 | 23764 | 127 |
57178 | 57178 | 2022-12-28 | Virginia | 51 | 2199302 | 22793 |
57179 | 57179 | 2022-12-28 | Washington | 53 | 1883676 | 15067 |
57180 | 57180 | 2022-12-28 | West Virginia | 54 | 623541 | 7786 |
57181 | 57181 | 2022-12-28 | Wisconsin | 55 | 1958296 | 15848 |
57182 | 57182 | 2022-12-28 | Wyoming | 56 | 182847 | 1959 |
57071 | 57071 | 2022-12-27 | Alabama | 1 | 1568934 | 21208 |
57072 | 57072 | 2022-12-27 | Alaska | 2 | 301774 | 1408 |
57073 | 57073 | 2022-12-27 | American Samoa | 60 | 8266 | 34 |
57074 | 57074 | 2022-12-27 | Arizona | 4 | 2373361 | 32038 |
57075 | 57075 | 2022-12-27 | Arkansas | 5 | 982272 | 12690 |
57076 | 57076 | 2022-12-27 | California | 6 | 11779543 | 100668 |
57077 | 57077 | 2022-12-27 | Colorado | 8 | 1731997 | 13859 |
57078 | 57078 | 2022-12-27 | Connecticut | 9 | 945045 | 11733 |
57079 | 57079 | 2022-12-27 | Delaware | 10 | 320581 | 3205 |
57080 | 57080 | 2022-12-27 | District of Columbia | 11 | 173626 | 1411 |
57081 | 57081 | 2022-12-27 | Florida | 12 | 7269428 | 83606 |
57082 | 57082 | 2022-12-27 | Georgia | 13 | 2888123 | 39913 |
57083 | 57083 | 2022-12-27 | Guam | 66 | 60845 | 412 |
57084 | 57084 | 2022-12-27 | Hawaii | 15 | 362117 | 1755 |
57085 | 57085 | 2022-12-27 | Idaho | 16 | 510665 | 5316 |
57086 | 57086 | 2022-12-27 | Illinois | 17 | 3967450 | 40627 |
57087 | 57087 | 2022-12-27 | Indiana | 18 | 1996253 | 25303 |
57088 | 57088 | 2022-12-27 | Iowa | 19 | 884263 | 10389 |
57089 | 57089 | 2022-12-27 | Kansas | 20 | 914380 | 9850 |
57090 | 57090 | 2022-12-27 | Kentucky | 21 | 1666033 | 17751 |
57091 | 57091 | 2022-12-27 | Louisiana | 22 | 1507707 | 18345 |
57092 | 57092 | 2022-12-27 | Maine | 23 | 305603 | 2803 |
57093 | 57093 | 2022-12-27 | Maryland | 24 | 1311673 | 15985 |
57094 | 57094 | 2022-12-27 | Massachusetts | 25 | 2144967 | 22793 |
57095 | 57095 | 2022-12-27 | Michigan | 26 | 2979504 | 40715 |
57096 | 57096 | 2022-12-27 | Minnesota | 27 | 1731172 | 14273 |
57097 | 57097 | 2022-12-27 | Mississippi | 28 | 955145 | 13124 |
57098 | 57098 | 2022-12-27 | Missouri | 29 | 1742348 | 23272 |
57099 | 57099 | 2022-12-27 | Montana | 30 | 322552 | 3635 |
57100 | 57100 | 2022-12-27 | Nebraska | 31 | 555157 | 4842 |
57101 | 57101 | 2022-12-27 | Nevada | 32 | 874117 | 11838 |
57102 | 57102 | 2022-12-27 | New Hampshire | 33 | 366749 | 2851 |
57103 | 57103 | 2022-12-27 | New Jersey | 34 | 2916729 | 35457 |
57104 | 57104 | 2022-12-27 | New Mexico | 35 | 658042 | 8807 |
57105 | 57105 | 2022-12-27 | New York | 36 | 6543018 | 77577 |
57106 | 57106 | 2022-12-27 | North Carolina | 37 | 3316814 | 28789 |
57107 | 57107 | 2022-12-27 | North Dakota | 38 | 280043 | 2469 |
57108 | 57108 | 2022-12-27 | Northern Mariana Islands | 69 | 13236 | 41 |
57109 | 57109 | 2022-12-27 | Ohio | 39 | 3294521 | 40949 |
57110 | 57110 | 2022-12-27 | Oklahoma | 40 | 1244121 | 16041 |
57111 | 57111 | 2022-12-27 | Oregon | 41 | 936721 | 8953 |
57112 | 57112 | 2022-12-27 | Pennsylvania | 42 | 3403953 | 48881 |
57113 | 57113 | 2022-12-27 | Puerto Rico | 72 | 1081824 | 5509 |
57114 | 57114 | 2022-12-27 | Rhode Island | 44 | 443645 | 3800 |
57115 | 57115 | 2022-12-27 | South Carolina | 45 | 1770059 | 19385 |
57116 | 57116 | 2022-12-27 | South Dakota | 46 | 271433 | 3136 |
57117 | 57117 | 2022-12-27 | Tennessee | 47 | 2358463 | 28262 |
57118 | 57118 | 2022-12-27 | Texas | 48 | 8080404 | 92630 |
57119 | 57119 | 2022-12-27 | Utah | 49 | 1072888 | 5177 |
57120 | 57120 | 2022-12-27 | Vermont | 50 | 148031 | 791 |
57121 | 57121 | 2022-12-27 | Virgin Islands | 78 | 23734 | 127 |
57122 | 57122 | 2022-12-27 | Virginia | 51 | 2196867 | 22786 |
57123 | 57123 | 2022-12-27 | Washington | 53 | 1879139 | 15021 |
57124 | 57124 | 2022-12-27 | West Virginia | 54 | 623080 | 7786 |
57125 | 57125 | 2022-12-27 | Wisconsin | 55 | 1956956 | 15827 |
57126 | 57126 | 2022-12-27 | Wyoming | 56 | 182847 | 1959 |
57015 | 57015 | 2022-12-26 | Alabama | 1 | 1568934 | 21208 |
57016 | 57016 | 2022-12-26 | Alaska | 2 | 301449 | 1408 |
57017 | 57017 | 2022-12-26 | American Samoa | 60 | 8266 | 34 |
57018 | 57018 | 2022-12-26 | Arizona | 4 | 2373361 | 32038 |
57019 | 57019 | 2022-12-26 | Arkansas | 5 | 981964 | 12690 |
57020 | 57020 | 2022-12-26 | California | 6 | 11772585 | 100628 |
57021 | 57021 | 2022-12-26 | Colorado | 8 | 1731721 | 13859 |
57022 | 57022 | 2022-12-26 | Connecticut | 9 | 944755 | 11733 |
57023 | 57023 | 2022-12-26 | Delaware | 10 | 320581 | 3205 |
57024 | 57024 | 2022-12-26 | District of Columbia | 11 | 173626 | 1411 |
57025 | 57025 | 2022-12-26 | Florida | 12 | 7269428 | 83606 |
57026 | 57026 | 2022-12-26 | Georgia | 13 | 2888123 | 39913 |
57027 | 57027 | 2022-12-26 | Guam | 66 | 60727 | 412 |
57028 | 57028 | 2022-12-26 | Hawaii | 15 | 362117 | 1755 |
57029 | 57029 | 2022-12-26 | Idaho | 16 | 510661 | 5316 |
57030 | 57030 | 2022-12-26 | Illinois | 17 | 3960888 | 40610 |
57031 | 57031 | 2022-12-26 | Indiana | 18 | 1996253 | 25303 |
57032 | 57032 | 2022-12-26 | Iowa | 19 | 884263 | 10389 |
57033 | 57033 | 2022-12-26 | Kansas | 20 | 914344 | 9850 |
57034 | 57034 | 2022-12-26 | Kentucky | 21 | 1657664 | 17708 |
57035 | 57035 | 2022-12-26 | Louisiana | 22 | 1507707 | 18345 |
57036 | 57036 | 2022-12-26 | Maine | 23 | 305600 | 2803 |
57037 | 57037 | 2022-12-26 | Maryland | 24 | 1311672 | 15985 |
57038 | 57038 | 2022-12-26 | Massachusetts | 25 | 2144967 | 22793 |
57039 | 57039 | 2022-12-26 | Michigan | 26 | 2977727 | 40659 |
57040 | 57040 | 2022-12-26 | Minnesota | 27 | 1731172 | 14273 |
57041 | 57041 | 2022-12-26 | Mississippi | 28 | 951070 | 13113 |
57042 | 57042 | 2022-12-26 | Missouri | 29 | 1736293 | 23252 |
57043 | 57043 | 2022-12-26 | Montana | 30 | 322437 | 3635 |
57044 | 57044 | 2022-12-26 | Nebraska | 31 | 554953 | 4841 |
57045 | 57045 | 2022-12-26 | Nevada | 32 | 874117 | 11838 |
57046 | 57046 | 2022-12-26 | New Hampshire | 33 | 366116 | 2851 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );