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-13 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|
51191 | 51191 | 2022-09-13 | Alabama | 1 | 1509880 | 20317 |
51192 | 51192 | 2022-09-13 | Alaska | 2 | 293914 | 1297 |
51193 | 51193 | 2022-09-13 | American Samoa | 60 | 8217 | 34 |
51194 | 51194 | 2022-09-13 | Arizona | 4 | 2258040 | 31162 |
51195 | 51195 | 2022-09-13 | Arkansas | 5 | 942925 | 11964 |
51196 | 51196 | 2022-09-13 | California | 6 | 11169894 | 95472 |
51197 | 51197 | 2022-09-13 | Colorado | 8 | 1648568 | 13420 |
51198 | 51198 | 2022-09-13 | Connecticut | 9 | 884941 | 11316 |
51199 | 51199 | 2022-09-13 | Delaware | 10 | 305109 | 3080 |
51200 | 51200 | 2022-09-13 | District of Columbia | 11 | 166893 | 1382 |
51201 | 51201 | 2022-09-13 | Florida | 12 | 7078943 | 80564 |
51202 | 51202 | 2022-09-13 | Georgia | 13 | 2800323 | 38318 |
51203 | 51203 | 2022-09-13 | Guam | 66 | 59238 | 395 |
51204 | 51204 | 2022-09-13 | Hawaii | 15 | 332278 | 1652 |
51205 | 51205 | 2022-09-13 | Idaho | 16 | 492150 | 5134 |
51206 | 51206 | 2022-09-13 | Illinois | 17 | 3731968 | 39480 |
51207 | 51207 | 2022-09-13 | Indiana | 18 | 1910442 | 24557 |
51208 | 51208 | 2022-09-13 | Iowa | 19 | 849956 | 9968 |
51209 | 51209 | 2022-09-13 | Kansas | 20 | 869362 | 9051 |
51210 | 51210 | 2022-09-13 | Kentucky | 21 | 1574786 | 16822 |
51211 | 51211 | 2022-09-13 | Louisiana | 22 | 1445716 | 17939 |
51212 | 51212 | 2022-09-13 | Maine | 23 | 285306 | 2561 |
51213 | 51213 | 2022-09-13 | Maryland | 24 | 1235556 | 15274 |
51214 | 51214 | 2022-09-13 | Massachusetts | 25 | 2021331 | 21536 |
51215 | 51215 | 2022-09-13 | Michigan | 26 | 2796275 | 38271 |
51216 | 51216 | 2022-09-13 | Minnesota | 27 | 1645653 | 13509 |
51217 | 51217 | 2022-09-13 | Mississippi | 28 | 922493 | 12853 |
51218 | 51218 | 2022-09-13 | Missouri | 29 | 1646677 | 21549 |
51219 | 51219 | 2022-09-13 | Montana | 30 | 306981 | 3509 |
51220 | 51220 | 2022-09-13 | Nebraska | 31 | 534044 | 4490 |
51221 | 51221 | 2022-09-13 | Nevada | 32 | 844294 | 11427 |
51222 | 51222 | 2022-09-13 | New Hampshire | 33 | 346627 | 2676 |
51223 | 51223 | 2022-09-13 | New Jersey | 34 | 2701029 | 34643 |
51224 | 51224 | 2022-09-13 | New Mexico | 35 | 614890 | 8495 |
51225 | 51225 | 2022-09-13 | New York | 36 | 6026783 | 70697 |
51226 | 51226 | 2022-09-13 | North Carolina | 37 | 3141302 | 26375 |
51227 | 51227 | 2022-09-13 | North Dakota | 38 | 266273 | 2401 |
51228 | 51228 | 2022-09-13 | Northern Mariana Islands | 69 | 13155 | 40 |
51229 | 51229 | 2022-09-13 | Ohio | 39 | 3096557 | 39576 |
51230 | 51230 | 2022-09-13 | Oklahoma | 40 | 1186780 | 14765 |
51231 | 51231 | 2022-09-13 | Oregon | 41 | 885297 | 8481 |
51232 | 51232 | 2022-09-13 | Pennsylvania | 42 | 3203488 | 46831 |
51233 | 51233 | 2022-09-13 | Puerto Rico | 72 | 976519 | 5046 |
51234 | 51234 | 2022-09-13 | Rhode Island | 44 | 420175 | 3652 |
51235 | 51235 | 2022-09-13 | South Carolina | 45 | 1696746 | 18316 |
51236 | 51236 | 2022-09-13 | South Dakota | 46 | 258510 | 3002 |
51237 | 51237 | 2022-09-13 | Tennessee | 47 | 2262682 | 27258 |
51238 | 51238 | 2022-09-13 | Texas | 48 | 7817015 | 90622 |
51239 | 51239 | 2022-09-13 | Utah | 49 | 1032402 | 4989 |
51240 | 51240 | 2022-09-13 | Vermont | 50 | 140740 | 715 |
51241 | 51241 | 2022-09-13 | Virgin Islands | 78 | 22970 | 123 |
51242 | 51242 | 2022-09-13 | Virginia | 51 | 2064992 | 21631 |
51243 | 51243 | 2022-09-13 | Washington | 53 | 1796343 | 14195 |
51244 | 51244 | 2022-09-13 | West Virginia | 54 | 593041 | 7344 |
51245 | 51245 | 2022-09-13 | Wisconsin | 55 | 1847431 | 15157 |
51246 | 51246 | 2022-09-13 | Wyoming | 56 | 175746 | 1888 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );