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-16 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 |
---|---|---|---|---|---|---|
51359 | 51359 | 2022-09-16 | Alabama | 1 | 1513159 | 20325 |
51360 | 51360 | 2022-09-16 | Alaska | 2 | 295121 | 1321 |
51361 | 51361 | 2022-09-16 | American Samoa | 60 | 8217 | 34 |
51362 | 51362 | 2022-09-16 | Arizona | 4 | 2264159 | 31244 |
51363 | 51363 | 2022-09-16 | Arkansas | 5 | 945449 | 11983 |
51364 | 51364 | 2022-09-16 | California | 6 | 11196447 | 95643 |
51365 | 51365 | 2022-09-16 | Colorado | 8 | 1652081 | 13443 |
51366 | 51366 | 2022-09-16 | Connecticut | 9 | 887501 | 11330 |
51367 | 51367 | 2022-09-16 | Delaware | 10 | 305772 | 3086 |
51368 | 51368 | 2022-09-16 | District of Columbia | 11 | 167420 | 1382 |
51369 | 51369 | 2022-09-16 | Florida | 12 | 7089180 | 80782 |
51370 | 51370 | 2022-09-16 | Georgia | 13 | 2809555 | 38468 |
51371 | 51371 | 2022-09-16 | Guam | 66 | 59339 | 395 |
51372 | 51372 | 2022-09-16 | Hawaii | 15 | 333547 | 1662 |
51373 | 51373 | 2022-09-16 | Idaho | 16 | 493183 | 5159 |
51374 | 51374 | 2022-09-16 | Illinois | 17 | 3740470 | 39536 |
51375 | 51375 | 2022-09-16 | Indiana | 18 | 1914351 | 24581 |
51376 | 51376 | 2022-09-16 | Iowa | 19 | 851233 | 9994 |
51377 | 51377 | 2022-09-16 | Kansas | 20 | 873582 | 9097 |
51378 | 51378 | 2022-09-16 | Kentucky | 21 | 1575215 | 16822 |
51379 | 51379 | 2022-09-16 | Louisiana | 22 | 1448503 | 17978 |
51380 | 51380 | 2022-09-16 | Maine | 23 | 286333 | 2564 |
51381 | 51381 | 2022-09-16 | Maryland | 24 | 1239006 | 15301 |
51382 | 51382 | 2022-09-16 | Massachusetts | 25 | 2030335 | 21588 |
51383 | 51383 | 2022-09-16 | Michigan | 26 | 2804588 | 38317 |
51384 | 51384 | 2022-09-16 | Minnesota | 27 | 1651999 | 13558 |
51385 | 51385 | 2022-09-16 | Mississippi | 28 | 922493 | 12853 |
51386 | 51386 | 2022-09-16 | Missouri | 29 | 1655068 | 21593 |
51387 | 51387 | 2022-09-16 | Montana | 30 | 308159 | 3512 |
51388 | 51388 | 2022-09-16 | Nebraska | 31 | 534818 | 4490 |
51389 | 51389 | 2022-09-16 | Nevada | 32 | 845491 | 11438 |
51390 | 51390 | 2022-09-16 | New Hampshire | 33 | 347415 | 2684 |
51391 | 51391 | 2022-09-16 | New Jersey | 34 | 2708594 | 34668 |
51392 | 51392 | 2022-09-16 | New Mexico | 35 | 615598 | 8517 |
51393 | 51393 | 2022-09-16 | New York | 36 | 6041536 | 70780 |
51394 | 51394 | 2022-09-16 | North Carolina | 37 | 3162491 | 26424 |
51395 | 51395 | 2022-09-16 | North Dakota | 38 | 267287 | 2411 |
51396 | 51396 | 2022-09-16 | Northern Mariana Islands | 69 | 13155 | 40 |
51397 | 51397 | 2022-09-16 | Ohio | 39 | 3117109 | 39675 |
51398 | 51398 | 2022-09-16 | Oklahoma | 40 | 1189193 | 14784 |
51399 | 51399 | 2022-09-16 | Oregon | 41 | 885963 | 8492 |
51400 | 51400 | 2022-09-16 | Pennsylvania | 42 | 3220994 | 46970 |
51401 | 51401 | 2022-09-16 | Puerto Rico | 72 | 980581 | 5066 |
51402 | 51402 | 2022-09-16 | Rhode Island | 44 | 421739 | 3661 |
51403 | 51403 | 2022-09-16 | South Carolina | 45 | 1696746 | 18316 |
51404 | 51404 | 2022-09-16 | South Dakota | 46 | 259683 | 3014 |
51405 | 51405 | 2022-09-16 | Tennessee | 47 | 2267019 | 27305 |
51406 | 51406 | 2022-09-16 | Texas | 48 | 7838132 | 90734 |
51407 | 51407 | 2022-09-16 | Utah | 49 | 1034893 | 5001 |
51408 | 51408 | 2022-09-16 | Vermont | 50 | 141282 | 715 |
51409 | 51409 | 2022-09-16 | Virgin Islands | 78 | 23031 | 123 |
51410 | 51410 | 2022-09-16 | Virginia | 51 | 2070182 | 21679 |
51411 | 51411 | 2022-09-16 | Washington | 53 | 1801179 | 14233 |
51412 | 51412 | 2022-09-16 | West Virginia | 54 | 595044 | 7364 |
51413 | 51413 | 2022-09-16 | Wisconsin | 55 | 1851892 | 15190 |
51414 | 51414 | 2022-09-16 | 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 );