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-08-12 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 |
---|---|---|---|---|---|---|
49399 | 49399 | 2022-08-12 | Alabama | 1 | 1449812 | 20026 |
49400 | 49400 | 2022-08-12 | Alaska | 2 | 287355 | 1290 |
49401 | 49401 | 2022-08-12 | American Samoa | 60 | 7471 | 33 |
49402 | 49402 | 2022-08-12 | Arizona | 4 | 2224964 | 30901 |
49403 | 49403 | 2022-08-12 | Arkansas | 5 | 915733 | 11812 |
49404 | 49404 | 2022-08-12 | California | 6 | 10898548 | 94234 |
49405 | 49405 | 2022-08-12 | Colorado | 8 | 1620671 | 13282 |
49406 | 49406 | 2022-08-12 | Connecticut | 9 | 863913 | 11165 |
49407 | 49407 | 2022-08-12 | Delaware | 10 | 298262 | 3036 |
49408 | 49408 | 2022-08-12 | District of Columbia | 11 | 164373 | 1374 |
49409 | 49409 | 2022-08-12 | Florida | 12 | 6909416 | 78559 |
49410 | 49410 | 2022-08-12 | Georgia | 13 | 2723200 | 37780 |
49411 | 49411 | 2022-08-12 | Guam | 66 | 57594 | 386 |
49412 | 49412 | 2022-08-12 | Hawaii | 15 | 324519 | 1603 |
49413 | 49413 | 2022-08-12 | Idaho | 16 | 484122 | 5063 |
49414 | 49414 | 2022-08-12 | Illinois | 17 | 3627267 | 39108 |
49415 | 49415 | 2022-08-12 | Indiana | 18 | 1859196 | 24222 |
49416 | 49416 | 2022-08-12 | Iowa | 19 | 828444 | 9850 |
49417 | 49417 | 2022-08-12 | Kansas | 20 | 848733 | 8993 |
49418 | 49418 | 2022-08-12 | Kentucky | 21 | 1504877 | 16464 |
49419 | 49419 | 2022-08-12 | Louisiana | 22 | 1400265 | 17699 |
49420 | 49420 | 2022-08-12 | Maine | 23 | 278715 | 2493 |
49421 | 49421 | 2022-08-12 | Maryland | 24 | 1201609 | 15059 |
49422 | 49422 | 2022-08-12 | Massachusetts | 25 | 1987385 | 21285 |
49423 | 49423 | 2022-08-12 | Michigan | 26 | 2708622 | 37671 |
49424 | 49424 | 2022-08-12 | Minnesota | 27 | 1611246 | 13362 |
49425 | 49425 | 2022-08-12 | Mississippi | 28 | 892291 | 12720 |
49426 | 49426 | 2022-08-12 | Missouri | 29 | 1604194 | 21251 |
49427 | 49427 | 2022-08-12 | Montana | 30 | 300859 | 3481 |
49428 | 49428 | 2022-08-12 | Nebraska | 31 | 522491 | 4394 |
49429 | 49429 | 2022-08-12 | Nevada | 32 | 834897 | 11316 |
49430 | 49430 | 2022-08-12 | New Hampshire | 33 | 341134 | 2640 |
49431 | 49431 | 2022-08-12 | New Jersey | 34 | 2634282 | 34396 |
49432 | 49432 | 2022-08-12 | New Mexico | 35 | 601422 | 8314 |
49433 | 49433 | 2022-08-12 | New York | 36 | 5888845 | 69976 |
49434 | 49434 | 2022-08-12 | North Carolina | 37 | 3047625 | 25734 |
49435 | 49435 | 2022-08-12 | North Dakota | 38 | 261045 | 2373 |
49436 | 49436 | 2022-08-12 | Northern Mariana Islands | 69 | 12871 | 39 |
49437 | 49437 | 2022-08-12 | Ohio | 39 | 3002043 | 39220 |
49438 | 49438 | 2022-08-12 | Oklahoma | 40 | 1144252 | 14623 |
49439 | 49439 | 2022-08-12 | Oregon | 41 | 864935 | 8267 |
49440 | 49440 | 2022-08-12 | Pennsylvania | 42 | 3131000 | 46398 |
49441 | 49441 | 2022-08-12 | Puerto Rico | 72 | 919855 | 4842 |
49442 | 49442 | 2022-08-12 | Rhode Island | 44 | 413259 | 3632 |
49443 | 49443 | 2022-08-12 | South Carolina | 45 | 1637108 | 18215 |
49444 | 49444 | 2022-08-12 | South Dakota | 46 | 253232 | 2973 |
49445 | 49445 | 2022-08-12 | Tennessee | 47 | 2179883 | 26938 |
49446 | 49446 | 2022-08-12 | Texas | 48 | 7588881 | 89859 |
49447 | 49447 | 2022-08-12 | Utah | 49 | 1020399 | 4940 |
49448 | 49448 | 2022-08-12 | Vermont | 50 | 138779 | 699 |
49449 | 49449 | 2022-08-12 | Virgin Islands | 78 | 22075 | 122 |
49450 | 49450 | 2022-08-12 | Virginia | 51 | 1993874 | 21145 |
49451 | 49451 | 2022-08-12 | Washington | 53 | 1761081 | 13872 |
49452 | 49452 | 2022-08-12 | West Virginia | 54 | 567426 | 7203 |
49453 | 49453 | 2022-08-12 | Wisconsin | 55 | 1803143 | 14980 |
49454 | 49454 | 2022-08-12 | Wyoming | 56 | 172473 | 1865 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );