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-04-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 |
---|---|---|---|---|---|---|
22400 | 22400 | 2021-04-14 | Alabama | 1 | 520780 | 10728 |
22401 | 22401 | 2021-04-14 | Alaska | 2 | 65008 | 300 |
22402 | 22402 | 2021-04-14 | Arizona | 4 | 851276 | 17109 |
22403 | 22403 | 2021-04-14 | Arkansas | 5 | 332666 | 5680 |
22404 | 22404 | 2021-04-14 | California | 6 | 3709392 | 60710 |
22405 | 22405 | 2021-04-14 | Colorado | 8 | 486277 | 6309 |
22406 | 22406 | 2021-04-14 | Connecticut | 9 | 327298 | 7984 |
22407 | 22407 | 2021-04-14 | Delaware | 10 | 99515 | 1591 |
22408 | 22408 | 2021-04-14 | District of Columbia | 11 | 46209 | 1088 |
22409 | 22409 | 2021-04-14 | Florida | 12 | 2141678 | 34163 |
22410 | 22410 | 2021-04-14 | Georgia | 13 | 1054406 | 18995 |
22411 | 22411 | 2021-04-14 | Guam | 66 | 8820 | 137 |
22412 | 22412 | 2021-04-14 | Hawaii | 15 | 31242 | 470 |
22413 | 22413 | 2021-04-14 | Idaho | 16 | 184427 | 2008 |
22414 | 22414 | 2021-04-14 | Illinois | 17 | 1292456 | 23865 |
22415 | 22415 | 2021-04-14 | Indiana | 18 | 705268 | 13187 |
22416 | 22416 | 2021-04-14 | Iowa | 19 | 358395 | 5858 |
22417 | 22417 | 2021-04-14 | Kansas | 20 | 307622 | 4944 |
22418 | 22418 | 2021-04-14 | Kentucky | 21 | 438463 | 6380 |
22419 | 22419 | 2021-04-14 | Louisiana | 22 | 450673 | 10264 |
22420 | 22420 | 2021-04-14 | Maine | 23 | 55374 | 757 |
22421 | 22421 | 2021-04-14 | Maryland | 24 | 430537 | 8493 |
22422 | 22422 | 2021-04-14 | Massachusetts | 25 | 664943 | 17427 |
22423 | 22423 | 2021-04-14 | Michigan | 26 | 848824 | 17683 |
22424 | 22424 | 2021-04-14 | Minnesota | 27 | 547179 | 7056 |
22425 | 22425 | 2021-04-14 | Mississippi | 28 | 308111 | 7122 |
22426 | 22426 | 2021-04-14 | Missouri | 29 | 597506 | 9101 |
22427 | 22427 | 2021-04-14 | Montana | 30 | 106747 | 1526 |
22428 | 22428 | 2021-04-14 | Nebraska | 31 | 215074 | 2327 |
22429 | 22429 | 2021-04-14 | Nevada | 32 | 309150 | 5353 |
22430 | 22430 | 2021-04-14 | New Hampshire | 33 | 89983 | 1261 |
22431 | 22431 | 2021-04-14 | New Jersey | 34 | 963483 | 24987 |
22432 | 22432 | 2021-04-14 | New Mexico | 35 | 194378 | 3998 |
22433 | 22433 | 2021-04-14 | New York | 36 | 1971610 | 50839 |
22434 | 22434 | 2021-04-14 | North Carolina | 37 | 940109 | 12353 |
22435 | 22435 | 2021-04-14 | North Dakota | 38 | 105246 | 1505 |
22436 | 22436 | 2021-04-14 | Northern Mariana Islands | 69 | 160 | 2 |
22437 | 22437 | 2021-04-14 | Ohio | 39 | 1045945 | 18917 |
22438 | 22438 | 2021-04-14 | Oklahoma | 40 | 444288 | 6697 |
22439 | 22439 | 2021-04-14 | Oregon | 41 | 172206 | 2463 |
22440 | 22440 | 2021-04-14 | Pennsylvania | 42 | 1093491 | 25580 |
22441 | 22441 | 2021-04-14 | Puerto Rico | 72 | 150981 | 2174 |
22442 | 22442 | 2021-04-14 | Rhode Island | 44 | 143251 | 2642 |
22443 | 22443 | 2021-04-14 | South Carolina | 45 | 564931 | 9304 |
22444 | 22444 | 2021-04-14 | South Dakota | 46 | 120379 | 1948 |
22445 | 22445 | 2021-04-14 | Tennessee | 47 | 813127 | 11934 |
22446 | 22446 | 2021-04-14 | Texas | 48 | 2836974 | 49524 |
22447 | 22447 | 2021-04-14 | Utah | 49 | 391238 | 2161 |
22448 | 22448 | 2021-04-14 | Vermont | 50 | 21488 | 237 |
22449 | 22449 | 2021-04-14 | Virgin Islands | 78 | 3005 | 26 |
22450 | 22450 | 2021-04-14 | Virginia | 51 | 640211 | 10510 |
22451 | 22451 | 2021-04-14 | Washington | 53 | 382627 | 5407 |
22452 | 22452 | 2021-04-14 | West Virginia | 54 | 147203 | 2756 |
22453 | 22453 | 2021-04-14 | Wisconsin | 55 | 648304 | 7402 |
22454 | 22454 | 2021-04-14 | Wyoming | 56 | 57127 | 703 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );