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 134
- Illinois 130
- California 129
- Arizona 128
- Massachusetts 122
- Wisconsin 119
- Texas 112
- Nebraska 106
- Utah 99
- Oregon 95
- Florida 93
- New York 93
- Rhode Island 93
- Georgia 92
- New Hampshire 92
- North Carolina 91
- New Jersey 90
- Tennessee 90
- Colorado 89
- Maryland 89
- Nevada 89
- Hawaii 88
- Indiana 88
- Kentucky 88
- Minnesota 88
- Oklahoma 88
- Pennsylvania 88
- South Carolina 88
- Vermont 88
- Virginia 88
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
5065 | 5065 | 2020-06-02 | Tennessee | 47 | 24498 | 378 |
5066 | 5066 | 2020-06-02 | Texas | 48 | 67966 | 1732 |
5067 | 5067 | 2020-06-02 | Utah | 49 | 10237 | 113 |
5068 | 5068 | 2020-06-02 | Vermont | 50 | 988 | 55 |
5069 | 5069 | 2020-06-02 | Virgin Islands | 78 | 70 | 6 |
5070 | 5070 | 2020-06-02 | Virginia | 51 | 46239 | 1407 |
5071 | 5071 | 2020-06-02 | Washington | 53 | 23608 | 1139 |
5072 | 5072 | 2020-06-02 | West Virginia | 54 | 2056 | 78 |
5073 | 5073 | 2020-06-02 | Wisconsin | 55 | 19223 | 610 |
5074 | 5074 | 2020-06-02 | Wyoming | 56 | 912 | 17 |
4965 | 4965 | 2020-06-01 | Alabama | 1 | 18534 | 646 |
4966 | 4966 | 2020-06-01 | Alaska | 2 | 476 | 8 |
4967 | 4967 | 2020-06-01 | Arizona | 4 | 20123 | 918 |
4968 | 4968 | 2020-06-01 | Arkansas | 5 | 7443 | 133 |
4969 | 4969 | 2020-06-01 | California | 6 | 115643 | 4287 |
4970 | 4970 | 2020-06-01 | Colorado | 8 | 26563 | 1458 |
4971 | 4971 | 2020-06-01 | Connecticut | 9 | 42740 | 3964 |
4972 | 4972 | 2020-06-01 | Delaware | 10 | 9605 | 368 |
4973 | 4973 | 2020-06-01 | District of Columbia | 11 | 8857 | 468 |
4974 | 4974 | 2020-06-01 | Florida | 12 | 56822 | 2459 |
4975 | 4975 | 2020-06-01 | Georgia | 13 | 45757 | 2057 |
4976 | 4976 | 2020-06-01 | Guam | 66 | 1144 | 6 |
4977 | 4977 | 2020-06-01 | Hawaii | 15 | 642 | 17 |
4978 | 4978 | 2020-06-01 | Idaho | 16 | 2908 | 83 |
4979 | 4979 | 2020-06-01 | Illinois | 17 | 121666 | 5458 |
4980 | 4980 | 2020-06-01 | Indiana | 18 | 35684 | 2142 |
4981 | 4981 | 2020-06-01 | Iowa | 19 | 19789 | 558 |
4982 | 4982 | 2020-06-01 | Kansas | 20 | 10103 | 217 |
4983 | 4983 | 2020-06-01 | Kentucky | 21 | 10150 | 445 |
4984 | 4984 | 2020-06-01 | Louisiana | 22 | 40452 | 2801 |
4985 | 4985 | 2020-06-01 | Maine | 23 | 2349 | 89 |
4986 | 4986 | 2020-06-01 | Maryland | 24 | 54035 | 2552 |
4987 | 4987 | 2020-06-01 | Massachusetts | 25 | 100805 | 7035 |
4988 | 4988 | 2020-06-01 | Michigan | 26 | 58435 | 5525 |
4989 | 4989 | 2020-06-01 | Minnesota | 27 | 25218 | 1060 |
4990 | 4990 | 2020-06-01 | Mississippi | 28 | 15752 | 739 |
4991 | 4991 | 2020-06-01 | Missouri | 29 | 13523 | 786 |
4992 | 4992 | 2020-06-01 | Montana | 30 | 519 | 17 |
4993 | 4993 | 2020-06-01 | Nebraska | 31 | 14345 | 183 |
4994 | 4994 | 2020-06-01 | Nevada | 32 | 8701 | 420 |
4995 | 4995 | 2020-06-01 | New Hampshire | 33 | 4685 | 245 |
4996 | 4996 | 2020-06-01 | New Jersey | 34 | 160918 | 11721 |
4997 | 4997 | 2020-06-01 | New Mexico | 35 | 7800 | 362 |
4998 | 4998 | 2020-06-01 | New York | 36 | 376520 | 29766 |
4999 | 4999 | 2020-06-01 | North Carolina | 37 | 29368 | 923 |
5000 | 5000 | 2020-06-01 | North Dakota | 38 | 2628 | 64 |
5001 | 5001 | 2020-06-01 | Northern Mariana Islands | 69 | 22 | 2 |
5002 | 5002 | 2020-06-01 | Ohio | 39 | 35984 | 2206 |
5003 | 5003 | 2020-06-01 | Oklahoma | 40 | 6573 | 334 |
5004 | 5004 | 2020-06-01 | Oregon | 41 | 4303 | 154 |
5005 | 5005 | 2020-06-01 | Pennsylvania | 42 | 76734 | 5574 |
5006 | 5006 | 2020-06-01 | Puerto Rico | 72 | 3873 | 136 |
5007 | 5007 | 2020-06-01 | Rhode Island | 44 | 14991 | 720 |
5008 | 5008 | 2020-06-01 | South Carolina | 45 | 12148 | 500 |
5009 | 5009 | 2020-06-01 | South Dakota | 46 | 5034 | 62 |
5010 | 5010 | 2020-06-01 | Tennessee | 47 | 23242 | 361 |
5011 | 5011 | 2020-06-01 | Texas | 48 | 66081 | 1695 |
5012 | 5012 | 2020-06-01 | Utah | 49 | 10026 | 113 |
5013 | 5013 | 2020-06-01 | Vermont | 50 | 983 | 55 |
5014 | 5014 | 2020-06-01 | Virgin Islands | 78 | 70 | 6 |
5015 | 5015 | 2020-06-01 | Virginia | 51 | 45398 | 1392 |
5016 | 5016 | 2020-06-01 | Washington | 53 | 23272 | 1133 |
5017 | 5017 | 2020-06-01 | West Virginia | 54 | 2028 | 76 |
5018 | 5018 | 2020-06-01 | Wisconsin | 55 | 18825 | 597 |
5019 | 5019 | 2020-06-01 | Wyoming | 56 | 910 | 17 |
4910 | 4910 | 2020-05-31 | Alabama | 1 | 17952 | 630 |
4911 | 4911 | 2020-05-31 | Alaska | 2 | 469 | 8 |
4912 | 4912 | 2020-05-31 | Arizona | 4 | 19936 | 906 |
4913 | 4913 | 2020-05-31 | Arkansas | 5 | 7253 | 133 |
4914 | 4914 | 2020-05-31 | California | 6 | 113114 | 4242 |
4915 | 4915 | 2020-05-31 | Colorado | 8 | 26364 | 1445 |
4916 | 4916 | 2020-05-31 | Connecticut | 9 | 42201 | 3944 |
4917 | 4917 | 2020-05-31 | Delaware | 10 | 9498 | 366 |
4918 | 4918 | 2020-05-31 | District of Columbia | 11 | 8801 | 466 |
4919 | 4919 | 2020-05-31 | Florida | 12 | 56155 | 2450 |
4920 | 4920 | 2020-05-31 | Georgia | 13 | 45051 | 2019 |
4921 | 4921 | 2020-05-31 | Guam | 66 | 1144 | 6 |
4922 | 4922 | 2020-05-31 | Hawaii | 15 | 642 | 17 |
4923 | 4923 | 2020-05-31 | Idaho | 16 | 2855 | 82 |
4924 | 4924 | 2020-05-31 | Illinois | 17 | 120588 | 5426 |
4925 | 4925 | 2020-05-31 | Indiana | 18 | 35429 | 2134 |
4926 | 4926 | 2020-05-31 | Iowa | 19 | 19621 | 537 |
4927 | 4927 | 2020-05-31 | Kansas | 20 | 9878 | 211 |
4928 | 4928 | 2020-05-31 | Kentucky | 21 | 9937 | 441 |
4929 | 4929 | 2020-05-31 | Louisiana | 22 | 40021 | 2791 |
4930 | 4930 | 2020-05-31 | Maine | 23 | 2325 | 89 |
4931 | 4931 | 2020-05-31 | Maryland | 24 | 53456 | 2532 |
4932 | 4932 | 2020-05-31 | Massachusetts | 25 | 96965 | 6846 |
4933 | 4933 | 2020-05-31 | Michigan | 26 | 57355 | 5491 |
4934 | 4934 | 2020-05-31 | Minnesota | 27 | 24860 | 1050 |
4935 | 4935 | 2020-05-31 | Mississippi | 28 | 15501 | 734 |
4936 | 4936 | 2020-05-31 | Missouri | 29 | 13297 | 784 |
4937 | 4937 | 2020-05-31 | Montana | 30 | 515 | 17 |
4938 | 4938 | 2020-05-31 | Nebraska | 31 | 14101 | 178 |
4939 | 4939 | 2020-05-31 | Nevada | 32 | 8628 | 419 |
4940 | 4940 | 2020-05-31 | New Hampshire | 33 | 4651 | 245 |
4941 | 4941 | 2020-05-31 | New Jersey | 34 | 160445 | 11698 |
4942 | 4942 | 2020-05-31 | New Mexico | 35 | 7689 | 356 |
4943 | 4943 | 2020-05-31 | New York | 36 | 375575 | 29699 |
4944 | 4944 | 2020-05-31 | North Carolina | 37 | 28686 | 911 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );