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 367
- Illinois 363
- California 362
- Arizona 361
- Massachusetts 355
- Wisconsin 352
- Texas 345
- Nebraska 339
- Utah 332
- Oregon 329
- Rhode Island 327
- Florida 326
- New York 326
- Georgia 325
- New Hampshire 325
- North Carolina 324
- New Jersey 323
- Tennessee 323
- Colorado 322
- Maryland 322
- Nevada 322
- Oklahoma 322
- Pennsylvania 322
- South Carolina 322
- Hawaii 321
- Indiana 321
- Kentucky 321
- Minnesota 321
- Vermont 321
- Virginia 321
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
17870 | 17870 | 2021-01-21 | North Dakota | 38 | 96392 | 1422 |
17871 | 17871 | 2021-01-21 | Northern Mariana Islands | 69 | 129 | 2 |
17872 | 17872 | 2021-01-21 | Ohio | 39 | 849704 | 10518 |
17873 | 17873 | 2021-01-21 | Oklahoma | 40 | 363046 | 3140 |
17874 | 17874 | 2021-01-21 | Oregon | 41 | 135973 | 1850 |
17875 | 17875 | 2021-01-21 | Pennsylvania | 42 | 794632 | 20128 |
17876 | 17876 | 2021-01-21 | Puerto Rico | 72 | 122343 | 1732 |
17877 | 17877 | 2021-01-21 | Rhode Island | 44 | 108786 | 2076 |
17878 | 17878 | 2021-01-21 | South Carolina | 45 | 404492 | 6373 |
17879 | 17879 | 2021-01-21 | South Dakota | 46 | 106400 | 1673 |
17880 | 17880 | 2021-01-21 | Tennessee | 47 | 685037 | 8606 |
17881 | 17881 | 2021-01-21 | Texas | 48 | 2207935 | 34075 |
17882 | 17882 | 2021-01-21 | Utah | 49 | 330469 | 1548 |
17883 | 17883 | 2021-01-21 | Vermont | 50 | 10580 | 168 |
17884 | 17884 | 2021-01-21 | Virgin Islands | 78 | 2305 | 24 |
17885 | 17885 | 2021-01-21 | Virginia | 51 | 459604 | 5940 |
17886 | 17886 | 2021-01-21 | Washington | 53 | 300420 | 4131 |
17887 | 17887 | 2021-01-21 | West Virginia | 54 | 112617 | 1849 |
17888 | 17888 | 2021-01-21 | Wisconsin | 55 | 575688 | 6091 |
17889 | 17889 | 2021-01-21 | Wyoming | 56 | 50424 | 550 |
17780 | 17780 | 2021-01-20 | Alabama | 1 | 429655 | 6283 |
17781 | 17781 | 2021-01-20 | Alaska | 2 | 52081 | 244 |
17782 | 17782 | 2021-01-20 | Arizona | 4 | 693706 | 11564 |
17783 | 17783 | 2021-01-20 | Arkansas | 5 | 276114 | 4441 |
17784 | 17784 | 2021-01-20 | California | 6 | 3090794 | 35001 |
17785 | 17785 | 2021-01-20 | Colorado | 8 | 381414 | 5509 |
17786 | 17786 | 2021-01-20 | Connecticut | 9 | 234134 | 6726 |
17787 | 17787 | 2021-01-20 | Delaware | 10 | 71775 | 1026 |
17788 | 17788 | 2021-01-20 | District of Columbia | 11 | 34403 | 863 |
17789 | 17789 | 2021-01-20 | Florida | 12 | 1601003 | 24577 |
17790 | 17790 | 2021-01-20 | Georgia | 13 | 812454 | 12373 |
17791 | 17791 | 2021-01-20 | Guam | 66 | 8484 | 129 |
17792 | 17792 | 2021-01-20 | Hawaii | 15 | 24551 | 322 |
17793 | 17793 | 2021-01-20 | Idaho | 16 | 157745 | 1637 |
17794 | 17794 | 2021-01-20 | Illinois | 17 | 1084134 | 20285 |
17795 | 17795 | 2021-01-20 | Indiana | 18 | 601380 | 9529 |
17796 | 17796 | 2021-01-20 | Iowa | 19 | 308787 | 4394 |
17797 | 17797 | 2021-01-20 | Kansas | 20 | 266251 | 3584 |
17798 | 17798 | 2021-01-20 | Kentucky | 21 | 337788 | 3540 |
17799 | 17799 | 2021-01-20 | Louisiana | 22 | 374582 | 8383 |
17800 | 17800 | 2021-01-20 | Maine | 23 | 34963 | 530 |
17801 | 17801 | 2021-01-20 | Maryland | 24 | 332558 | 6689 |
17802 | 17802 | 2021-01-20 | Massachusetts | 25 | 481040 | 13829 |
17803 | 17803 | 2021-01-20 | Michigan | 26 | 587963 | 14759 |
17804 | 17804 | 2021-01-20 | Minnesota | 27 | 449560 | 6047 |
17805 | 17805 | 2021-01-20 | Mississippi | 28 | 256827 | 5638 |
17806 | 17806 | 2021-01-20 | Missouri | 29 | 479480 | 6868 |
17807 | 17807 | 2021-01-20 | Montana | 30 | 90349 | 1094 |
17808 | 17808 | 2021-01-20 | Nebraska | 31 | 185656 | 1936 |
17809 | 17809 | 2021-01-20 | Nevada | 32 | 265228 | 3869 |
17810 | 17810 | 2021-01-20 | New Hampshire | 33 | 59437 | 950 |
17811 | 17811 | 2021-01-20 | New Jersey | 34 | 641140 | 20667 |
17812 | 17812 | 2021-01-20 | New Mexico | 35 | 165835 | 3011 |
17813 | 17813 | 2021-01-20 | New York | 36 | 1280068 | 41148 |
17814 | 17814 | 2021-01-20 | North Carolina | 37 | 691760 | 8267 |
17815 | 17815 | 2021-01-20 | North Dakota | 38 | 96244 | 1409 |
17816 | 17816 | 2021-01-20 | Northern Mariana Islands | 69 | 129 | 2 |
17817 | 17817 | 2021-01-20 | Ohio | 39 | 842433 | 10409 |
17818 | 17818 | 2021-01-20 | Oklahoma | 40 | 360360 | 3085 |
17819 | 17819 | 2021-01-20 | Oregon | 41 | 135143 | 1841 |
17820 | 17820 | 2021-01-20 | Pennsylvania | 42 | 789029 | 19868 |
17821 | 17821 | 2021-01-20 | Puerto Rico | 72 | 122128 | 1717 |
17822 | 17822 | 2021-01-20 | Rhode Island | 44 | 107876 | 2058 |
17823 | 17823 | 2021-01-20 | South Carolina | 45 | 399843 | 6328 |
17824 | 17824 | 2021-01-20 | South Dakota | 46 | 106063 | 1667 |
17825 | 17825 | 2021-01-20 | Tennessee | 47 | 681451 | 8477 |
17826 | 17826 | 2021-01-20 | Texas | 48 | 2186469 | 33632 |
17827 | 17827 | 2021-01-20 | Utah | 49 | 328380 | 1518 |
17828 | 17828 | 2021-01-20 | Vermont | 50 | 10471 | 165 |
17829 | 17829 | 2021-01-20 | Virgin Islands | 78 | 2305 | 24 |
17830 | 17830 | 2021-01-20 | Virginia | 51 | 455591 | 5861 |
17831 | 17831 | 2021-01-20 | Washington | 53 | 298487 | 4021 |
17832 | 17832 | 2021-01-20 | West Virginia | 54 | 111677 | 1836 |
17833 | 17833 | 2021-01-20 | Wisconsin | 55 | 573119 | 6036 |
17834 | 17834 | 2021-01-20 | Wyoming | 56 | 50124 | 550 |
17725 | 17725 | 2021-01-19 | Alabama | 1 | 426543 | 6126 |
17726 | 17726 | 2021-01-19 | Alaska | 2 | 51914 | 221 |
17727 | 17727 | 2021-01-19 | Arizona | 4 | 686028 | 11266 |
17728 | 17728 | 2021-01-19 | Arkansas | 5 | 273594 | 4386 |
17729 | 17729 | 2021-01-19 | California | 6 | 3071465 | 34390 |
17730 | 17730 | 2021-01-19 | Colorado | 8 | 379999 | 5473 |
17731 | 17731 | 2021-01-19 | Connecticut | 9 | 232219 | 6682 |
17732 | 17732 | 2021-01-19 | Delaware | 10 | 71311 | 1021 |
17733 | 17733 | 2021-01-19 | District of Columbia | 11 | 34259 | 861 |
17734 | 17734 | 2021-01-19 | Florida | 12 | 1589089 | 24435 |
17735 | 17735 | 2021-01-19 | Georgia | 13 | 804508 | 12179 |
17736 | 17736 | 2021-01-19 | Guam | 66 | 8484 | 129 |
17737 | 17737 | 2021-01-19 | Hawaii | 15 | 24483 | 321 |
17738 | 17738 | 2021-01-19 | Idaho | 16 | 157069 | 1639 |
17739 | 17739 | 2021-01-19 | Illinois | 17 | 1079307 | 20154 |
17740 | 17740 | 2021-01-19 | Indiana | 18 | 598494 | 9466 |
17741 | 17741 | 2021-01-19 | Iowa | 19 | 307302 | 4332 |
17742 | 17742 | 2021-01-19 | Kansas | 20 | 262727 | 3526 |
17743 | 17743 | 2021-01-19 | Kentucky | 21 | 334347 | 3489 |
17744 | 17744 | 2021-01-19 | Louisiana | 22 | 372089 | 8324 |
17745 | 17745 | 2021-01-19 | Maine | 23 | 34262 | 519 |
17746 | 17746 | 2021-01-19 | Maryland | 24 | 330390 | 6650 |
17747 | 17747 | 2021-01-19 | Massachusetts | 25 | 476526 | 13749 |
17748 | 17748 | 2021-01-19 | Michigan | 26 | 585548 | 14724 |
17749 | 17749 | 2021-01-19 | Minnesota | 27 | 448336 | 6013 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );