ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
57,238 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- Washington 451
- Illinois 447
- California 446
- Arizona 445
- Massachusetts 439
- Wisconsin 436
- Texas 429
- Nebraska 423
- Utah 416
- Oregon 412
- Florida 410
- New York 410
- Rhode Island 410
- Georgia 409
- New Hampshire 409
- North Carolina 408
- New Jersey 407
- Tennessee 407
- Colorado 406
- Maryland 406
- Nevada 406
- Hawaii 405
- Indiana 405
- Kentucky 405
- Minnesota 405
- Oklahoma 405
- Pennsylvania 405
- South Carolina 405
- Vermont 405
- Virginia 405
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
22500 | 22500 | 2021-04-15 | Tennessee | 47 | 814809 | 11942 |
22501 | 22501 | 2021-04-15 | Texas | 48 | 2840297 | 49607 |
22502 | 22502 | 2021-04-15 | Utah | 49 | 391694 | 2162 |
22503 | 22503 | 2021-04-15 | Vermont | 50 | 21664 | 240 |
22504 | 22504 | 2021-04-15 | Virgin Islands | 78 | 3022 | 26 |
22505 | 22505 | 2021-04-15 | Virginia | 51 | 641626 | 10529 |
22506 | 22506 | 2021-04-15 | Washington | 53 | 383951 | 5412 |
22507 | 22507 | 2021-04-15 | West Virginia | 54 | 147596 | 2772 |
22508 | 22508 | 2021-04-15 | Wisconsin | 55 | 649388 | 7406 |
22509 | 22509 | 2021-04-15 | Wyoming | 56 | 57203 | 703 |
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 |
22345 | 22345 | 2021-04-13 | Alabama | 1 | 520503 | 10722 |
22346 | 22346 | 2021-04-13 | Alaska | 2 | 64809 | 300 |
22347 | 22347 | 2021-04-13 | Arizona | 4 | 850860 | 17105 |
22348 | 22348 | 2021-04-13 | Arkansas | 5 | 332446 | 5673 |
22349 | 22349 | 2021-04-13 | California | 6 | 3706904 | 60535 |
22350 | 22350 | 2021-04-13 | Colorado | 8 | 484079 | 6306 |
22351 | 22351 | 2021-04-13 | Connecticut | 9 | 325689 | 7974 |
22352 | 22352 | 2021-04-13 | Delaware | 10 | 99135 | 1587 |
22353 | 22353 | 2021-04-13 | District of Columbia | 11 | 46016 | 1085 |
22354 | 22354 | 2021-04-13 | Florida | 12 | 2134906 | 34119 |
22355 | 22355 | 2021-04-13 | Georgia | 13 | 1052708 | 18944 |
22356 | 22356 | 2021-04-13 | Guam | 66 | 8816 | 137 |
22357 | 22357 | 2021-04-13 | Hawaii | 15 | 31175 | 468 |
22358 | 22358 | 2021-04-13 | Idaho | 16 | 184119 | 2002 |
22359 | 22359 | 2021-04-13 | Illinois | 17 | 1288969 | 23826 |
22360 | 22360 | 2021-04-13 | Indiana | 18 | 704072 | 13167 |
22361 | 22361 | 2021-04-13 | Iowa | 19 | 357739 | 5858 |
22362 | 22362 | 2021-04-13 | Kansas | 20 | 306998 | 4930 |
22363 | 22363 | 2021-04-13 | Kentucky | 21 | 437685 | 6358 |
22364 | 22364 | 2021-04-13 | Louisiana | 22 | 450279 | 10255 |
22365 | 22365 | 2021-04-13 | Maine | 23 | 54827 | 753 |
22366 | 22366 | 2021-04-13 | Maryland | 24 | 428985 | 8484 |
22367 | 22367 | 2021-04-13 | Massachusetts | 25 | 662699 | 17413 |
22368 | 22368 | 2021-04-13 | Michigan | 26 | 839486 | 17648 |
22369 | 22369 | 2021-04-13 | Minnesota | 27 | 545482 | 7040 |
22370 | 22370 | 2021-04-13 | Mississippi | 28 | 307836 | 7119 |
22371 | 22371 | 2021-04-13 | Missouri | 29 | 596651 | 9077 |
22372 | 22372 | 2021-04-13 | Montana | 30 | 106536 | 1526 |
22373 | 22373 | 2021-04-13 | Nebraska | 31 | 214682 | 2335 |
22374 | 22374 | 2021-04-13 | Nevada | 32 | 308755 | 5339 |
22375 | 22375 | 2021-04-13 | New Hampshire | 33 | 89605 | 1257 |
22376 | 22376 | 2021-04-13 | New Jersey | 34 | 959920 | 24945 |
22377 | 22377 | 2021-04-13 | New Mexico | 35 | 194164 | 3990 |
22378 | 22378 | 2021-04-13 | New York | 36 | 1965610 | 50745 |
22379 | 22379 | 2021-04-13 | North Carolina | 37 | 937761 | 12335 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );