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-14 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 |
---|---|---|---|---|---|---|
27405 | 27405 | 2021-07-14 | Alabama | 1 | 556613 | 11428 |
27406 | 27406 | 2021-07-14 | Alaska | 2 | 71539 | 364 |
27407 | 27407 | 2021-07-14 | Arizona | 4 | 903851 | 18076 |
27408 | 27408 | 2021-07-14 | Arkansas | 5 | 360258 | 5977 |
27409 | 27409 | 2021-07-14 | California | 6 | 3921906 | 64002 |
27410 | 27410 | 2021-07-14 | Colorado | 8 | 567305 | 7023 |
27411 | 27411 | 2021-07-14 | Connecticut | 9 | 350386 | 8279 |
27412 | 27412 | 2021-07-14 | Delaware | 10 | 110182 | 1696 |
27413 | 27413 | 2021-07-14 | District of Columbia | 11 | 49574 | 1145 |
27414 | 27414 | 2021-07-14 | Florida | 12 | 2383068 | 38282 |
27415 | 27415 | 2021-07-14 | Georgia | 13 | 1118774 | 20832 |
27416 | 27416 | 2021-07-14 | Guam | 66 | 9440 | 143 |
27417 | 27417 | 2021-07-14 | Hawaii | 15 | 37175 | 518 |
27418 | 27418 | 2021-07-14 | Idaho | 16 | 196567 | 2167 |
27419 | 27419 | 2021-07-14 | Illinois | 17 | 1402545 | 25806 |
27420 | 27420 | 2021-07-14 | Indiana | 18 | 762419 | 13938 |
27421 | 27421 | 2021-07-14 | Iowa | 19 | 375278 | 6158 |
27422 | 27422 | 2021-07-14 | Kansas | 20 | 322725 | 5220 |
27423 | 27423 | 2021-07-14 | Kentucky | 21 | 469487 | 7318 |
27424 | 27424 | 2021-07-14 | Louisiana | 22 | 492840 | 10808 |
27425 | 27425 | 2021-07-14 | Maine | 23 | 69324 | 867 |
27426 | 27426 | 2021-07-14 | Maryland | 24 | 463704 | 9769 |
27427 | 27427 | 2021-07-14 | Massachusetts | 25 | 711676 | 18013 |
27428 | 27428 | 2021-07-14 | Michigan | 26 | 1001067 | 21077 |
27429 | 27429 | 2021-07-14 | Minnesota | 27 | 607162 | 7723 |
27430 | 27430 | 2021-07-14 | Mississippi | 28 | 325713 | 7456 |
27431 | 27431 | 2021-07-14 | Missouri | 29 | 653318 | 10083 |
27432 | 27432 | 2021-07-14 | Montana | 30 | 114617 | 1683 |
27433 | 27433 | 2021-07-14 | Nebraska | 31 | 225600 | 2535 |
27434 | 27434 | 2021-07-14 | Nevada | 32 | 341292 | 5737 |
27435 | 27435 | 2021-07-14 | New Hampshire | 33 | 99840 | 1381 |
27436 | 27436 | 2021-07-14 | New Jersey | 34 | 1027014 | 26520 |
27437 | 27437 | 2021-07-14 | New Mexico | 35 | 206846 | 4364 |
27438 | 27438 | 2021-07-14 | New York | 36 | 2120600 | 53170 |
27439 | 27439 | 2021-07-14 | North Carolina | 37 | 1021908 | 13522 |
27440 | 27440 | 2021-07-14 | North Dakota | 38 | 110957 | 1567 |
27441 | 27441 | 2021-07-14 | Northern Mariana Islands | 69 | 187 | 2 |
27442 | 27442 | 2021-07-14 | Ohio | 39 | 1115242 | 20411 |
27443 | 27443 | 2021-07-14 | Oklahoma | 40 | 463152 | 7417 |
27444 | 27444 | 2021-07-14 | Oregon | 41 | 211357 | 2830 |
27445 | 27445 | 2021-07-14 | Pennsylvania | 42 | 1219405 | 27769 |
27446 | 27446 | 2021-07-14 | Puerto Rico | 72 | 174589 | 2555 |
27447 | 27447 | 2021-07-14 | Rhode Island | 44 | 152873 | 2732 |
27448 | 27448 | 2021-07-14 | South Carolina | 45 | 600607 | 9860 |
27449 | 27449 | 2021-07-14 | South Dakota | 46 | 124750 | 2040 |
27450 | 27450 | 2021-07-14 | Tennessee | 47 | 859116 | 12535 |
27451 | 27451 | 2021-07-14 | Texas | 48 | 3023065 | 52855 |
27452 | 27452 | 2021-07-14 | Utah | 49 | 421393 | 2407 |
27453 | 27453 | 2021-07-14 | Vermont | 50 | 24516 | 258 |
27454 | 27454 | 2021-07-14 | Virgin Islands | 78 | 4104 | 32 |
27455 | 27455 | 2021-07-14 | Virginia | 51 | 683614 | 11467 |
27456 | 27456 | 2021-07-14 | Washington | 53 | 460015 | 6076 |
27457 | 27457 | 2021-07-14 | West Virginia | 54 | 164763 | 2916 |
27458 | 27458 | 2021-07-14 | Wisconsin | 55 | 679601 | 8196 |
27459 | 27459 | 2021-07-14 | Wyoming | 56 | 63331 | 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 );