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-14 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 |
---|---|---|---|---|---|---|
51247 | 51247 | 2022-09-14 | Alabama | 1 | 1511092 | 20321 |
51248 | 51248 | 2022-09-14 | Alaska | 2 | 295121 | 1321 |
51249 | 51249 | 2022-09-14 | American Samoa | 60 | 8217 | 34 |
51250 | 51250 | 2022-09-14 | Arizona | 4 | 2264159 | 31244 |
51251 | 51251 | 2022-09-14 | Arkansas | 5 | 943944 | 11970 |
51252 | 51252 | 2022-09-14 | California | 6 | 11171759 | 95521 |
51253 | 51253 | 2022-09-14 | Colorado | 8 | 1649212 | 13426 |
51254 | 51254 | 2022-09-14 | Connecticut | 9 | 885767 | 11317 |
51255 | 51255 | 2022-09-14 | Delaware | 10 | 305284 | 3080 |
51256 | 51256 | 2022-09-14 | District of Columbia | 11 | 167242 | 1382 |
51257 | 51257 | 2022-09-14 | Florida | 12 | 7082717 | 80647 |
51258 | 51258 | 2022-09-14 | Georgia | 13 | 2809555 | 38468 |
51259 | 51259 | 2022-09-14 | Guam | 66 | 59304 | 395 |
51260 | 51260 | 2022-09-14 | Hawaii | 15 | 333547 | 1662 |
51261 | 51261 | 2022-09-14 | Idaho | 16 | 492685 | 5145 |
51262 | 51262 | 2022-09-14 | Illinois | 17 | 3734881 | 39498 |
51263 | 51263 | 2022-09-14 | Indiana | 18 | 1912563 | 24557 |
51264 | 51264 | 2022-09-14 | Iowa | 19 | 850932 | 9994 |
51265 | 51265 | 2022-09-14 | Kansas | 20 | 873582 | 9072 |
51266 | 51266 | 2022-09-14 | Kentucky | 21 | 1574948 | 16822 |
51267 | 51267 | 2022-09-14 | Louisiana | 22 | 1446738 | 17955 |
51268 | 51268 | 2022-09-14 | Maine | 23 | 285670 | 2561 |
51269 | 51269 | 2022-09-14 | Maryland | 24 | 1236570 | 15285 |
51270 | 51270 | 2022-09-14 | Massachusetts | 25 | 2021331 | 21536 |
51271 | 51271 | 2022-09-14 | Michigan | 26 | 2804588 | 38317 |
51272 | 51272 | 2022-09-14 | Minnesota | 27 | 1645653 | 13509 |
51273 | 51273 | 2022-09-14 | Mississippi | 28 | 922493 | 12853 |
51274 | 51274 | 2022-09-14 | Missouri | 29 | 1648081 | 21552 |
51275 | 51275 | 2022-09-14 | Montana | 30 | 306981 | 3509 |
51276 | 51276 | 2022-09-14 | Nebraska | 31 | 534299 | 4490 |
51277 | 51277 | 2022-09-14 | Nevada | 32 | 844294 | 11427 |
51278 | 51278 | 2022-09-14 | New Hampshire | 33 | 346949 | 2678 |
51279 | 51279 | 2022-09-14 | New Jersey | 34 | 2703340 | 34651 |
51280 | 51280 | 2022-09-14 | New Mexico | 35 | 615162 | 8499 |
51281 | 51281 | 2022-09-14 | New York | 36 | 6031598 | 70733 |
51282 | 51282 | 2022-09-14 | North Carolina | 37 | 3162491 | 26424 |
51283 | 51283 | 2022-09-14 | North Dakota | 38 | 266273 | 2401 |
51284 | 51284 | 2022-09-14 | Northern Mariana Islands | 69 | 13155 | 40 |
51285 | 51285 | 2022-09-14 | Ohio | 39 | 3096557 | 39576 |
51286 | 51286 | 2022-09-14 | Oklahoma | 40 | 1186780 | 14765 |
51287 | 51287 | 2022-09-14 | Oregon | 41 | 885963 | 8492 |
51288 | 51288 | 2022-09-14 | Pennsylvania | 42 | 3220994 | 46970 |
51289 | 51289 | 2022-09-14 | Puerto Rico | 72 | 977587 | 5053 |
51290 | 51290 | 2022-09-14 | Rhode Island | 44 | 420175 | 3652 |
51291 | 51291 | 2022-09-14 | South Carolina | 45 | 1696746 | 18316 |
51292 | 51292 | 2022-09-14 | South Dakota | 46 | 259683 | 3014 |
51293 | 51293 | 2022-09-14 | Tennessee | 47 | 2263911 | 27267 |
51294 | 51294 | 2022-09-14 | Texas | 48 | 7826318 | 90673 |
51295 | 51295 | 2022-09-14 | Utah | 49 | 1032402 | 4989 |
51296 | 51296 | 2022-09-14 | Vermont | 50 | 141282 | 715 |
51297 | 51297 | 2022-09-14 | Virgin Islands | 78 | 22970 | 123 |
51298 | 51298 | 2022-09-14 | Virginia | 51 | 2066675 | 21646 |
51299 | 51299 | 2022-09-14 | Washington | 53 | 1796368 | 14195 |
51300 | 51300 | 2022-09-14 | West Virginia | 54 | 593806 | 7351 |
51301 | 51301 | 2022-09-14 | Wisconsin | 55 | 1848935 | 15160 |
51302 | 51302 | 2022-09-14 | 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 );