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 2021-11-17 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 |
---|---|---|---|---|---|---|
34391 | 34391 | 2021-11-17 | Alabama | 1 | 840991 | 16025 |
34392 | 34392 | 2021-11-17 | Alaska | 2 | 146080 | 822 |
34393 | 34393 | 2021-11-17 | American Samoa | 60 | 5 | 0 |
34394 | 34394 | 2021-11-17 | Arizona | 4 | 1223892 | 21752 |
34395 | 34395 | 2021-11-17 | Arkansas | 5 | 521553 | 8595 |
34396 | 34396 | 2021-11-17 | California | 6 | 5024415 | 73614 |
34397 | 34397 | 2021-11-17 | Colorado | 8 | 800762 | 8974 |
34398 | 34398 | 2021-11-17 | Connecticut | 9 | 411311 | 8834 |
34399 | 34399 | 2021-11-17 | Delaware | 10 | 148674 | 2143 |
34400 | 34400 | 2021-11-17 | District of Columbia | 11 | 65793 | 1195 |
34401 | 34401 | 2021-11-17 | Florida | 12 | 3674581 | 60846 |
34402 | 34402 | 2021-11-17 | Georgia | 13 | 1617515 | 28935 |
34403 | 34403 | 2021-11-17 | Guam | 66 | 19984 | 261 |
34404 | 34404 | 2021-11-17 | Hawaii | 15 | 83270 | 982 |
34405 | 34405 | 2021-11-17 | Idaho | 16 | 301866 | 3802 |
34406 | 34406 | 2021-11-17 | Illinois | 17 | 1757813 | 29083 |
34407 | 34407 | 2021-11-17 | Indiana | 18 | 1065388 | 17191 |
34408 | 34408 | 2021-11-17 | Iowa | 19 | 509761 | 7268 |
34409 | 34409 | 2021-11-17 | Kansas | 20 | 453815 | 6664 |
34410 | 34410 | 2021-11-17 | Kentucky | 21 | 771874 | 10442 |
34411 | 34411 | 2021-11-17 | Louisiana | 22 | 766391 | 14724 |
34412 | 34412 | 2021-11-17 | Maine | 23 | 113132 | 1243 |
34413 | 34413 | 2021-11-17 | Maryland | 24 | 574067 | 11086 |
34414 | 34414 | 2021-11-17 | Massachusetts | 25 | 884299 | 19235 |
34415 | 34415 | 2021-11-17 | Michigan | 26 | 1385354 | 24659 |
34416 | 34416 | 2021-11-17 | Minnesota | 27 | 861359 | 9217 |
34417 | 34417 | 2021-11-17 | Mississippi | 28 | 509942 | 10217 |
34418 | 34418 | 2021-11-17 | Missouri | 29 | 893829 | 13135 |
34419 | 34419 | 2021-11-17 | Montana | 30 | 187006 | 2524 |
34420 | 34420 | 2021-11-17 | Nebraska | 31 | 299149 | 3085 |
34421 | 34421 | 2021-11-17 | Nevada | 32 | 463265 | 7883 |
34422 | 34422 | 2021-11-17 | New Hampshire | 33 | 148718 | 1648 |
34423 | 34423 | 2021-11-17 | New Jersey | 34 | 1223455 | 28220 |
34424 | 34424 | 2021-11-17 | New Mexico | 35 | 298313 | 5217 |
34425 | 34425 | 2021-11-17 | New York | 36 | 2643081 | 56584 |
34426 | 34426 | 2021-11-17 | North Carolina | 37 | 1512266 | 18534 |
34427 | 34427 | 2021-11-17 | North Dakota | 38 | 156776 | 1867 |
34428 | 34428 | 2021-11-17 | Northern Mariana Islands | 69 | 408 | 3 |
34429 | 34429 | 2021-11-17 | Ohio | 39 | 1620436 | 25813 |
34430 | 34430 | 2021-11-17 | Oklahoma | 40 | 656574 | 10879 |
34431 | 34431 | 2021-11-17 | Oregon | 41 | 381842 | 4873 |
34432 | 34432 | 2021-11-17 | Pennsylvania | 42 | 1660087 | 32633 |
34433 | 34433 | 2021-11-17 | Puerto Rico | 72 | 220386 | 3259 |
34434 | 34434 | 2021-11-17 | Rhode Island | 44 | 185254 | 2902 |
34435 | 34435 | 2021-11-17 | South Carolina | 45 | 909905 | 14064 |
34436 | 34436 | 2021-11-17 | South Dakota | 46 | 161474 | 2297 |
34437 | 34437 | 2021-11-17 | Tennessee | 47 | 1271153 | 16650 |
34438 | 34438 | 2021-11-17 | Texas | 48 | 4288395 | 73357 |
34439 | 34439 | 2021-11-17 | Utah | 49 | 579497 | 3398 |
34440 | 34440 | 2021-11-17 | Vermont | 50 | 45456 | 398 |
34441 | 34441 | 2021-11-17 | Virgin Islands | 78 | 7380 | 84 |
34442 | 34442 | 2021-11-17 | Virginia | 51 | 949803 | 14443 |
34443 | 34443 | 2021-11-17 | Washington | 53 | 761304 | 9108 |
34444 | 34444 | 2021-11-17 | West Virginia | 54 | 285135 | 4698 |
34445 | 34445 | 2021-11-17 | Wisconsin | 55 | 937369 | 9777 |
34446 | 34446 | 2021-11-17 | Wyoming | 56 | 108658 | 1347 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );