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 55
- Washington 369
- Illinois 365
- California 364
- Arizona 363
- Massachusetts 357
- Wisconsin 354
- Texas 347
- Nebraska 341
- Utah 334
- Oregon 330
- Florida 328
- New York 328
- Rhode Island 328
- Georgia 327
- New Hampshire 327
- North Carolina 326
- New Jersey 325
- Tennessee 325
- Colorado 324
- Maryland 324
- Nevada 324
- Hawaii 323
- Indiana 323
- Kentucky 323
- Minnesota 323
- Oklahoma 323
- Pennsylvania 323
- South Carolina 323
- Vermont 323
- Virginia 323
- District of Columbia 322
- Kansas 322
- Missouri 322
- Connecticut 321
- Iowa 321
- Louisiana 320
- Ohio 320
- Michigan 319
- South Dakota 319
- Wyoming 319
- Arkansas 318
- Delaware 318
- Mississippi 318
- New Mexico 318
- North Dakota 318
- Alaska 317
- Maine 317
- Alabama 316
- Idaho 316
- Montana 316
- Puerto Rico 316
- Virgin Islands 316
- Guam 314
- West Virginia 313
- Northern Mariana Islands 301
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
17990 | 17990 | 2021-01-23 | Tennessee | 47 | 692048 | 8736 |
17991 | 17991 | 2021-01-23 | Texas | 48 | 2240136 | 34859 |
17992 | 17992 | 2021-01-23 | Utah | 49 | 334889 | 1582 |
17993 | 17993 | 2021-01-23 | Vermont | 50 | 10908 | 170 |
17994 | 17994 | 2021-01-23 | Virgin Islands | 78 | 2341 | 24 |
17995 | 17995 | 2021-01-23 | Virginia | 51 | 468655 | 6079 |
17996 | 17996 | 2021-01-23 | Washington | 53 | 304107 | 4182 |
17997 | 17997 | 2021-01-23 | West Virginia | 54 | 114752 | 1872 |
17998 | 17998 | 2021-01-23 | Wisconsin | 55 | 580003 | 6187 |
17999 | 17999 | 2021-01-23 | Wyoming | 56 | 50583 | 571 |
17890 | 17890 | 2021-01-22 | Alabama | 1 | 436087 | 6486 |
17891 | 17891 | 2021-01-22 | Alaska | 2 | 52572 | 245 |
17892 | 17892 | 2021-01-22 | Arizona | 4 | 710273 | 12014 |
17893 | 17893 | 2021-01-22 | Arkansas | 5 | 281382 | 4549 |
17894 | 17894 | 2021-01-22 | California | 6 | 3141404 | 36326 |
17895 | 17895 | 2021-01-22 | Colorado | 8 | 385153 | 5548 |
17896 | 17896 | 2021-01-22 | Connecticut | 9 | 237815 | 6819 |
17897 | 17897 | 2021-01-22 | Delaware | 10 | 73233 | 1027 |
17898 | 17898 | 2021-01-22 | District of Columbia | 11 | 34905 | 867 |
17899 | 17899 | 2021-01-22 | Florida | 12 | 1627595 | 25010 |
17900 | 17900 | 2021-01-22 | Georgia | 13 | 829023 | 12653 |
17901 | 17901 | 2021-01-22 | Guam | 66 | 8516 | 129 |
17902 | 17902 | 2021-01-22 | Hawaii | 15 | 24823 | 329 |
17903 | 17903 | 2021-01-22 | Idaho | 16 | 159000 | 1669 |
17904 | 17904 | 2021-01-22 | Illinois | 17 | 1095917 | 20535 |
17905 | 17905 | 2021-01-22 | Indiana | 18 | 608498 | 9642 |
17906 | 17906 | 2021-01-22 | Iowa | 19 | 311695 | 4478 |
17907 | 17907 | 2021-01-22 | Kansas | 20 | 269611 | 3598 |
17908 | 17908 | 2021-01-22 | Kentucky | 21 | 344565 | 3626 |
17909 | 17909 | 2021-01-22 | Louisiana | 22 | 380255 | 8483 |
17910 | 17910 | 2021-01-22 | Maine | 23 | 36274 | 540 |
17911 | 17911 | 2021-01-22 | Maryland | 24 | 337129 | 6792 |
17912 | 17912 | 2021-01-22 | Massachusetts | 25 | 491452 | 13987 |
17913 | 17913 | 2021-01-22 | Michigan | 26 | 593068 | 14940 |
17914 | 17914 | 2021-01-22 | Minnesota | 27 | 452336 | 6100 |
17915 | 17915 | 2021-01-22 | Mississippi | 28 | 261167 | 5713 |
17916 | 17916 | 2021-01-22 | Missouri | 29 | 484370 | 6932 |
17917 | 17917 | 2021-01-22 | Montana | 30 | 91145 | 1106 |
17918 | 17918 | 2021-01-22 | Nebraska | 31 | 187496 | 1960 |
17919 | 17919 | 2021-01-22 | Nevada | 32 | 268344 | 3967 |
17920 | 17920 | 2021-01-22 | New Hampshire | 33 | 60951 | 971 |
17921 | 17921 | 2021-01-22 | New Jersey | 34 | 650388 | 20875 |
17922 | 17922 | 2021-01-22 | New Mexico | 35 | 167731 | 3079 |
17923 | 17923 | 2021-01-22 | New York | 36 | 1309660 | 41530 |
17924 | 17924 | 2021-01-22 | North Carolina | 37 | 706948 | 8511 |
17925 | 17925 | 2021-01-22 | North Dakota | 38 | 96592 | 1428 |
17926 | 17926 | 2021-01-22 | Northern Mariana Islands | 69 | 129 | 2 |
17927 | 17927 | 2021-01-22 | Ohio | 39 | 853982 | 10599 |
17928 | 17928 | 2021-01-22 | Oklahoma | 40 | 365992 | 3187 |
17929 | 17929 | 2021-01-22 | Oregon | 41 | 136839 | 1874 |
17930 | 17930 | 2021-01-22 | Pennsylvania | 42 | 799948 | 20322 |
17931 | 17931 | 2021-01-22 | Puerto Rico | 72 | 122897 | 1761 |
17932 | 17932 | 2021-01-22 | Rhode Island | 44 | 109735 | 2083 |
17933 | 17933 | 2021-01-22 | South Carolina | 45 | 409188 | 6404 |
17934 | 17934 | 2021-01-22 | South Dakota | 46 | 106716 | 1684 |
17935 | 17935 | 2021-01-22 | Tennessee | 47 | 688782 | 8695 |
17936 | 17936 | 2021-01-22 | Texas | 48 | 2226203 | 34496 |
17937 | 17937 | 2021-01-22 | Utah | 49 | 333118 | 1571 |
17938 | 17938 | 2021-01-22 | Vermont | 50 | 10759 | 169 |
17939 | 17939 | 2021-01-22 | Virgin Islands | 78 | 2321 | 24 |
17940 | 17940 | 2021-01-22 | Virginia | 51 | 463751 | 6002 |
17941 | 17941 | 2021-01-22 | Washington | 53 | 302546 | 4178 |
17942 | 17942 | 2021-01-22 | West Virginia | 54 | 113615 | 1856 |
17943 | 17943 | 2021-01-22 | Wisconsin | 55 | 577991 | 6140 |
17944 | 17944 | 2021-01-22 | Wyoming | 56 | 50583 | 571 |
17835 | 17835 | 2021-01-21 | Alabama | 1 | 432536 | 6379 |
17836 | 17836 | 2021-01-21 | Alaska | 2 | 52282 | 245 |
17837 | 17837 | 2021-01-21 | Arizona | 4 | 703249 | 11813 |
17838 | 17838 | 2021-01-21 | Arkansas | 5 | 279220 | 4496 |
17839 | 17839 | 2021-01-21 | California | 6 | 3116369 | 35704 |
17840 | 17840 | 2021-01-21 | Colorado | 8 | 382918 | 5523 |
17841 | 17841 | 2021-01-21 | Connecticut | 9 | 235796 | 6774 |
17842 | 17842 | 2021-01-21 | Delaware | 10 | 72523 | 1027 |
17843 | 17843 | 2021-01-21 | District of Columbia | 11 | 34612 | 864 |
17844 | 17844 | 2021-01-21 | Florida | 12 | 1613876 | 24738 |
17845 | 17845 | 2021-01-21 | Georgia | 13 | 820513 | 12484 |
17846 | 17846 | 2021-01-21 | Guam | 66 | 8497 | 129 |
17847 | 17847 | 2021-01-21 | Hawaii | 15 | 24663 | 325 |
17848 | 17848 | 2021-01-21 | Idaho | 16 | 158400 | 1658 |
17849 | 17849 | 2021-01-21 | Illinois | 17 | 1089010 | 20423 |
17850 | 17850 | 2021-01-21 | Indiana | 18 | 605004 | 9593 |
17851 | 17851 | 2021-01-21 | Iowa | 19 | 310440 | 4445 |
17852 | 17852 | 2021-01-21 | Kansas | 20 | 266562 | 3575 |
17853 | 17853 | 2021-01-21 | Kentucky | 21 | 341343 | 3584 |
17854 | 17854 | 2021-01-21 | Louisiana | 22 | 378318 | 8442 |
17855 | 17855 | 2021-01-21 | Maine | 23 | 35638 | 536 |
17856 | 17856 | 2021-01-21 | Maryland | 24 | 334725 | 6735 |
17857 | 17857 | 2021-01-21 | Massachusetts | 25 | 486180 | 13906 |
17858 | 17858 | 2021-01-21 | Michigan | 26 | 590546 | 14922 |
17859 | 17859 | 2021-01-21 | Minnesota | 27 | 450830 | 6079 |
17860 | 17860 | 2021-01-21 | Mississippi | 28 | 259117 | 5668 |
17861 | 17861 | 2021-01-21 | Missouri | 29 | 481962 | 6909 |
17862 | 17862 | 2021-01-21 | Montana | 30 | 90742 | 1102 |
17863 | 17863 | 2021-01-21 | Nebraska | 31 | 186472 | 1949 |
17864 | 17864 | 2021-01-21 | Nevada | 32 | 266643 | 3915 |
17865 | 17865 | 2021-01-21 | New Hampshire | 33 | 60294 | 962 |
17866 | 17866 | 2021-01-21 | New Jersey | 34 | 646188 | 20760 |
17867 | 17867 | 2021-01-21 | New Mexico | 35 | 166823 | 3046 |
17868 | 17868 | 2021-01-21 | New York | 36 | 1293976 | 41348 |
17869 | 17869 | 2021-01-21 | North Carolina | 37 | 697660 | 8397 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );