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)
Suggested facets: date (date)
state >30
- Washington 1,074
- Illinois 1,071
- California 1,070
- Arizona 1,069
- Massachusetts 1,063
- Wisconsin 1,059
- Texas 1,052
- Nebraska 1,047
- Utah 1,039
- Oregon 1,036
- Florida 1,034
- New York 1,034
- Rhode Island 1,034
- Georgia 1,033
- New Hampshire 1,033
- North Carolina 1,032
- New Jersey 1,031
- Colorado 1,030
- Maryland 1,030
- Nevada 1,030
- Tennessee 1,030
- Hawaii 1,029
- Indiana 1,029
- Kentucky 1,029
- Minnesota 1,029
- Oklahoma 1,029
- Pennsylvania 1,029
- South Carolina 1,029
- District of Columbia 1,028
- Kansas 1,028
- …
| Link | rowid | date ▲ | state | fips | cases | deaths |
|---|---|---|---|---|---|---|
| 57183 | 57183 | 2022-12-29 | Alabama | 1 | 1573637 | 21208 |
| 57184 | 57184 | 2022-12-29 | Alaska | 2 | 301774 | 1408 |
| 57185 | 57185 | 2022-12-29 | American Samoa | 60 | 8266 | 34 |
| 57186 | 57186 | 2022-12-29 | Arizona | 4 | 2378334 | 32182 |
| 57187 | 57187 | 2022-12-29 | Arkansas | 5 | 983942 | 12697 |
| 57188 | 57188 | 2022-12-29 | California | 6 | 11822939 | 100837 |
| 57189 | 57189 | 2022-12-29 | Colorado | 8 | 1733812 | 13891 |
| 57190 | 57190 | 2022-12-29 | Connecticut | 9 | 947016 | 11770 |
| 57191 | 57191 | 2022-12-29 | Delaware | 10 | 321888 | 3206 |
| 57192 | 57192 | 2022-12-29 | District of Columbia | 11 | 173626 | 1411 |
| 57193 | 57193 | 2022-12-29 | Florida | 12 | 7269428 | 83606 |
| 57194 | 57194 | 2022-12-29 | Georgia | 13 | 2898584 | 39964 |
| 57195 | 57195 | 2022-12-29 | Guam | 66 | 60845 | 412 |
| 57196 | 57196 | 2022-12-29 | Hawaii | 15 | 363188 | 1758 |
| 57197 | 57197 | 2022-12-29 | Idaho | 16 | 511718 | 5329 |
| 57198 | 57198 | 2022-12-29 | Illinois | 17 | 3973551 | 40657 |
| 57199 | 57199 | 2022-12-29 | Indiana | 18 | 2002760 | 25364 |
| 57200 | 57200 | 2022-12-29 | Iowa | 19 | 886411 | 10424 |
| 57201 | 57201 | 2022-12-29 | Kansas | 20 | 917091 | 9852 |
| 57202 | 57202 | 2022-12-29 | Kentucky | 21 | 1666033 | 17751 |
| 57203 | 57203 | 2022-12-29 | Louisiana | 22 | 1514113 | 18370 |
| 57204 | 57204 | 2022-12-29 | Maine | 23 | 306215 | 2807 |
| 57205 | 57205 | 2022-12-29 | Maryland | 24 | 1316937 | 16020 |
| 57206 | 57206 | 2022-12-29 | Massachusetts | 25 | 2154886 | 22940 |
| 57207 | 57207 | 2022-12-29 | Michigan | 26 | 2988654 | 40767 |
| 57208 | 57208 | 2022-12-29 | Minnesota | 27 | 1736893 | 14320 |
| 57209 | 57209 | 2022-12-29 | Mississippi | 28 | 955145 | 13124 |
| 57210 | 57210 | 2022-12-29 | Missouri | 29 | 1743114 | 23280 |
| 57211 | 57211 | 2022-12-29 | Montana | 30 | 322552 | 3635 |
| 57212 | 57212 | 2022-12-29 | Nebraska | 31 | 555377 | 4843 |
| 57213 | 57213 | 2022-12-29 | Nevada | 32 | 876118 | 11880 |
| 57214 | 57214 | 2022-12-29 | New Hampshire | 33 | 367243 | 2853 |
| 57215 | 57215 | 2022-12-29 | New Jersey | 34 | 2923180 | 35486 |
| 57216 | 57216 | 2022-12-29 | New Mexico | 35 | 658690 | 8822 |
| 57217 | 57217 | 2022-12-29 | New York | 36 | 6552600 | 77677 |
| 57218 | 57218 | 2022-12-29 | North Carolina | 37 | 3316814 | 28789 |
| 57219 | 57219 | 2022-12-29 | North Dakota | 38 | 280043 | 2474 |
| 57220 | 57220 | 2022-12-29 | Northern Mariana Islands | 69 | 13236 | 41 |
| 57221 | 57221 | 2022-12-29 | Ohio | 39 | 3307568 | 41018 |
| 57222 | 57222 | 2022-12-29 | Oklahoma | 40 | 1250013 | 16054 |
| 57223 | 57223 | 2022-12-29 | Oregon | 41 | 939303 | 8967 |
| 57224 | 57224 | 2022-12-29 | Pennsylvania | 42 | 3416142 | 48972 |
| 57225 | 57225 | 2022-12-29 | Puerto Rico | 72 | 1084004 | 5530 |
| 57226 | 57226 | 2022-12-29 | Rhode Island | 44 | 443645 | 3800 |
| 57227 | 57227 | 2022-12-29 | South Carolina | 45 | 1770059 | 19385 |
| 57228 | 57228 | 2022-12-29 | South Dakota | 46 | 271856 | 3138 |
| 57229 | 57229 | 2022-12-29 | Tennessee | 47 | 2367936 | 28274 |
| 57230 | 57230 | 2022-12-29 | Texas | 48 | 8113137 | 92707 |
| 57231 | 57231 | 2022-12-29 | Utah | 49 | 1075137 | 5187 |
| 57232 | 57232 | 2022-12-29 | Vermont | 50 | 148393 | 791 |
| 57233 | 57233 | 2022-12-29 | Virgin Islands | 78 | 23769 | 127 |
| 57234 | 57234 | 2022-12-29 | Virginia | 51 | 2202436 | 22793 |
| 57235 | 57235 | 2022-12-29 | Washington | 53 | 1883676 | 15067 |
| 57236 | 57236 | 2022-12-29 | West Virginia | 54 | 624174 | 7786 |
| 57237 | 57237 | 2022-12-29 | Wisconsin | 55 | 1959643 | 15858 |
| 57238 | 57238 | 2022-12-29 | Wyoming | 56 | 182847 | 1959 |
| 57127 | 57127 | 2022-12-28 | Alabama | 1 | 1568934 | 21208 |
| 57128 | 57128 | 2022-12-28 | Alaska | 2 | 301774 | 1408 |
| 57129 | 57129 | 2022-12-28 | American Samoa | 60 | 8266 | 34 |
| 57130 | 57130 | 2022-12-28 | Arizona | 4 | 2378334 | 32182 |
| 57131 | 57131 | 2022-12-28 | Arkansas | 5 | 983004 | 12694 |
| 57132 | 57132 | 2022-12-28 | California | 6 | 11781729 | 100702 |
| 57133 | 57133 | 2022-12-28 | Colorado | 8 | 1732984 | 13882 |
| 57134 | 57134 | 2022-12-28 | Connecticut | 9 | 946236 | 11766 |
| 57135 | 57135 | 2022-12-28 | Delaware | 10 | 321888 | 3206 |
| 57136 | 57136 | 2022-12-28 | District of Columbia | 11 | 173626 | 1411 |
| 57137 | 57137 | 2022-12-28 | Florida | 12 | 7269428 | 83606 |
| 57138 | 57138 | 2022-12-28 | Georgia | 13 | 2898584 | 39964 |
| 57139 | 57139 | 2022-12-28 | Guam | 66 | 60845 | 412 |
| 57140 | 57140 | 2022-12-28 | Hawaii | 15 | 363188 | 1758 |
| 57141 | 57141 | 2022-12-28 | Idaho | 16 | 511690 | 5329 |
| 57142 | 57142 | 2022-12-28 | Illinois | 17 | 3970204 | 40633 |
| 57143 | 57143 | 2022-12-28 | Indiana | 18 | 2002760 | 25364 |
| 57144 | 57144 | 2022-12-28 | Iowa | 19 | 886408 | 10425 |
| 57145 | 57145 | 2022-12-28 | Kansas | 20 | 917091 | 9850 |
| 57146 | 57146 | 2022-12-28 | Kentucky | 21 | 1666033 | 17751 |
| 57147 | 57147 | 2022-12-28 | Louisiana | 22 | 1514113 | 18370 |
| 57148 | 57148 | 2022-12-28 | Maine | 23 | 305984 | 2807 |
| 57149 | 57149 | 2022-12-28 | Maryland | 24 | 1315246 | 16007 |
| 57150 | 57150 | 2022-12-28 | Massachusetts | 25 | 2144967 | 22793 |
| 57151 | 57151 | 2022-12-28 | Michigan | 26 | 2979504 | 40715 |
| 57152 | 57152 | 2022-12-28 | Minnesota | 27 | 1731172 | 14273 |
| 57153 | 57153 | 2022-12-28 | Mississippi | 28 | 955145 | 13124 |
| 57154 | 57154 | 2022-12-28 | Missouri | 29 | 1742713 | 23277 |
| 57155 | 57155 | 2022-12-28 | Montana | 30 | 322552 | 3635 |
| 57156 | 57156 | 2022-12-28 | Nebraska | 31 | 555157 | 4842 |
| 57157 | 57157 | 2022-12-28 | Nevada | 32 | 874117 | 11880 |
| 57158 | 57158 | 2022-12-28 | New Hampshire | 33 | 366952 | 2852 |
| 57159 | 57159 | 2022-12-28 | New Jersey | 34 | 2919724 | 35469 |
| 57160 | 57160 | 2022-12-28 | New Mexico | 35 | 658364 | 8807 |
| 57161 | 57161 | 2022-12-28 | New York | 36 | 6546293 | 77619 |
| 57162 | 57162 | 2022-12-28 | North Carolina | 37 | 3316814 | 28789 |
| 57163 | 57163 | 2022-12-28 | North Dakota | 38 | 280043 | 2469 |
| 57164 | 57164 | 2022-12-28 | Northern Mariana Islands | 69 | 13236 | 41 |
| 57165 | 57165 | 2022-12-28 | Ohio | 39 | 3294521 | 40949 |
| 57166 | 57166 | 2022-12-28 | Oklahoma | 40 | 1244121 | 16041 |
| 57167 | 57167 | 2022-12-28 | Oregon | 41 | 939303 | 8967 |
| 57168 | 57168 | 2022-12-28 | Pennsylvania | 42 | 3416142 | 48972 |
| 57169 | 57169 | 2022-12-28 | Puerto Rico | 72 | 1082619 | 5519 |
| 57170 | 57170 | 2022-12-28 | Rhode Island | 44 | 443645 | 3800 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );