ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where "date" is on date 2021-07-15 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- Alabama 1
- Alaska 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
- Nevada 1
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
27460 | 27460 | 2021-07-15 | Alabama | 1 | 557578 | 11439 |
27461 | 27461 | 2021-07-15 | Alaska | 2 | 71539 | 364 |
27462 | 27462 | 2021-07-15 | Arizona | 4 | 904865 | 18083 |
27463 | 27463 | 2021-07-15 | Arkansas | 5 | 361238 | 5981 |
27464 | 27464 | 2021-07-15 | California | 6 | 3925591 | 64041 |
27465 | 27465 | 2021-07-15 | Colorado | 8 | 567852 | 7025 |
27466 | 27466 | 2021-07-15 | Connecticut | 9 | 350536 | 8282 |
27467 | 27467 | 2021-07-15 | Delaware | 10 | 110231 | 1696 |
27468 | 27468 | 2021-07-15 | District of Columbia | 11 | 49615 | 1145 |
27469 | 27469 | 2021-07-15 | Florida | 12 | 2390079 | 38327 |
27470 | 27470 | 2021-07-15 | Georgia | 13 | 1120085 | 20851 |
27471 | 27471 | 2021-07-15 | Guam | 66 | 9442 | 143 |
27472 | 27472 | 2021-07-15 | Hawaii | 15 | 37318 | 519 |
27473 | 27473 | 2021-07-15 | Idaho | 16 | 196773 | 2172 |
27474 | 27474 | 2021-07-15 | Illinois | 17 | 1403369 | 25814 |
27475 | 27475 | 2021-07-15 | Indiana | 18 | 762976 | 13939 |
27476 | 27476 | 2021-07-15 | Iowa | 19 | 375321 | 6158 |
27477 | 27477 | 2021-07-15 | Kansas | 20 | 322773 | 5220 |
27478 | 27478 | 2021-07-15 | Kentucky | 21 | 470012 | 7323 |
27479 | 27479 | 2021-07-15 | Louisiana | 22 | 494340 | 10821 |
27480 | 27480 | 2021-07-15 | Maine | 23 | 69373 | 877 |
27481 | 27481 | 2021-07-15 | Maryland | 24 | 463882 | 9773 |
27482 | 27482 | 2021-07-15 | Massachusetts | 25 | 711943 | 18017 |
27483 | 27483 | 2021-07-15 | Michigan | 26 | 1001120 | 21077 |
27484 | 27484 | 2021-07-15 | Minnesota | 27 | 607371 | 7725 |
27485 | 27485 | 2021-07-15 | Mississippi | 28 | 326270 | 7460 |
27486 | 27486 | 2021-07-15 | Missouri | 29 | 656203 | 10095 |
27487 | 27487 | 2021-07-15 | Montana | 30 | 114685 | 1686 |
27488 | 27488 | 2021-07-15 | Nebraska | 31 | 225711 | 2535 |
27489 | 27489 | 2021-07-15 | Nevada | 32 | 342230 | 5752 |
27490 | 27490 | 2021-07-15 | New Hampshire | 33 | 99875 | 1381 |
27491 | 27491 | 2021-07-15 | New Jersey | 34 | 1027460 | 26529 |
27492 | 27492 | 2021-07-15 | New Mexico | 35 | 207002 | 4374 |
27493 | 27493 | 2021-07-15 | New York | 36 | 2121529 | 53175 |
27494 | 27494 | 2021-07-15 | North Carolina | 37 | 1022938 | 13529 |
27495 | 27495 | 2021-07-15 | North Dakota | 38 | 110989 | 1567 |
27496 | 27496 | 2021-07-15 | Northern Mariana Islands | 69 | 187 | 2 |
27497 | 27497 | 2021-07-15 | Ohio | 39 | 1115789 | 20411 |
27498 | 27498 | 2021-07-15 | Oklahoma | 40 | 463857 | 7417 |
27499 | 27499 | 2021-07-15 | Oregon | 41 | 211654 | 2837 |
27500 | 27500 | 2021-07-15 | Pennsylvania | 42 | 1219722 | 27779 |
27501 | 27501 | 2021-07-15 | Puerto Rico | 72 | 174715 | 2559 |
27502 | 27502 | 2021-07-15 | Rhode Island | 44 | 152927 | 2736 |
27503 | 27503 | 2021-07-15 | South Carolina | 45 | 601232 | 9865 |
27504 | 27504 | 2021-07-15 | South Dakota | 46 | 124750 | 2040 |
27505 | 27505 | 2021-07-15 | Tennessee | 47 | 859655 | 12538 |
27506 | 27506 | 2021-07-15 | Texas | 48 | 3026074 | 52892 |
27507 | 27507 | 2021-07-15 | Utah | 49 | 422046 | 2410 |
27508 | 27508 | 2021-07-15 | Vermont | 50 | 24529 | 258 |
27509 | 27509 | 2021-07-15 | Virgin Islands | 78 | 4119 | 32 |
27510 | 27510 | 2021-07-15 | Virginia | 51 | 684054 | 11471 |
27511 | 27511 | 2021-07-15 | Washington | 53 | 460730 | 6086 |
27512 | 27512 | 2021-07-15 | West Virginia | 54 | 164843 | 2917 |
27513 | 27513 | 2021-07-15 | Wisconsin | 55 | 679816 | 8198 |
27514 | 27514 | 2021-07-15 | Wyoming | 56 | 63455 | 760 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );