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 132
- Illinois 128
- California 127
- Arizona 126
- Massachusetts 120
- Wisconsin 117
- Texas 110
- Nebraska 104
- Utah 97
- Oregon 94
- Rhode Island 92
- Florida 91
- New York 91
- Georgia 90
- New Hampshire 90
- North Carolina 89
- New Jersey 88
- Tennessee 88
- Colorado 87
- Maryland 87
- Nevada 87
- Oklahoma 87
- Pennsylvania 87
- South Carolina 87
- Hawaii 86
- Indiana 86
- Kentucky 86
- Minnesota 86
- Vermont 86
- Virginia 86
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
4945 | 4945 | 2020-05-31 | North Dakota | 38 | 2580 | 64 |
4946 | 4946 | 2020-05-31 | Northern Mariana Islands | 69 | 22 | 2 |
4947 | 4947 | 2020-05-31 | Ohio | 39 | 35513 | 2155 |
4948 | 4948 | 2020-05-31 | Oklahoma | 40 | 6506 | 334 |
4949 | 4949 | 2020-05-31 | Oregon | 41 | 4243 | 153 |
4950 | 4950 | 2020-05-31 | Pennsylvania | 42 | 76218 | 5555 |
4951 | 4951 | 2020-05-31 | Puerto Rico | 72 | 3776 | 136 |
4952 | 4952 | 2020-05-31 | Rhode Island | 44 | 14928 | 718 |
4953 | 4953 | 2020-05-31 | South Carolina | 45 | 11861 | 494 |
4954 | 4954 | 2020-05-31 | South Dakota | 46 | 4993 | 62 |
4955 | 4955 | 2020-05-31 | Tennessee | 47 | 22832 | 360 |
4956 | 4956 | 2020-05-31 | Texas | 48 | 64974 | 1683 |
4957 | 4957 | 2020-05-31 | Utah | 49 | 9829 | 113 |
4958 | 4958 | 2020-05-31 | Vermont | 50 | 981 | 55 |
4959 | 4959 | 2020-05-31 | Virgin Islands | 78 | 70 | 6 |
4960 | 4960 | 2020-05-31 | Virginia | 51 | 44607 | 1375 |
4961 | 4961 | 2020-05-31 | Washington | 53 | 22814 | 1126 |
4962 | 4962 | 2020-05-31 | West Virginia | 54 | 2010 | 75 |
4963 | 4963 | 2020-05-31 | Wisconsin | 55 | 18684 | 594 |
4964 | 4964 | 2020-05-31 | Wyoming | 56 | 903 | 16 |
4855 | 4855 | 2020-05-30 | Alabama | 1 | 17359 | 618 |
4856 | 4856 | 2020-05-30 | Alaska | 2 | 441 | 8 |
4857 | 4857 | 2020-05-30 | Arizona | 4 | 19255 | 903 |
4858 | 4858 | 2020-05-30 | Arkansas | 5 | 7013 | 133 |
4859 | 4859 | 2020-05-30 | California | 6 | 110100 | 4214 |
4860 | 4860 | 2020-05-30 | Colorado | 8 | 26084 | 1443 |
4861 | 4861 | 2020-05-30 | Connecticut | 9 | 42022 | 3912 |
4862 | 4862 | 2020-05-30 | Delaware | 10 | 9422 | 361 |
4863 | 4863 | 2020-05-30 | District of Columbia | 11 | 8717 | 462 |
4864 | 4864 | 2020-05-30 | Florida | 12 | 55416 | 2446 |
4865 | 4865 | 2020-05-30 | Georgia | 13 | 44336 | 1973 |
4866 | 4866 | 2020-05-30 | Guam | 66 | 1141 | 6 |
4867 | 4867 | 2020-05-30 | Hawaii | 15 | 641 | 17 |
4868 | 4868 | 2020-05-30 | Idaho | 16 | 2840 | 82 |
4869 | 4869 | 2020-05-30 | Illinois | 17 | 119290 | 5368 |
4870 | 4870 | 2020-05-30 | Indiana | 18 | 35064 | 2125 |
4871 | 4871 | 2020-05-30 | Iowa | 19 | 19336 | 531 |
4872 | 4872 | 2020-05-30 | Kansas | 20 | 9847 | 209 |
4873 | 4873 | 2020-05-30 | Kentucky | 21 | 9887 | 441 |
4874 | 4874 | 2020-05-30 | Louisiana | 22 | 39682 | 2785 |
4875 | 4875 | 2020-05-30 | Maine | 23 | 2282 | 89 |
4876 | 4876 | 2020-05-30 | Maryland | 24 | 52662 | 2509 |
4877 | 4877 | 2020-05-30 | Massachusetts | 25 | 96301 | 6768 |
4878 | 4878 | 2020-05-30 | Michigan | 26 | 56848 | 5463 |
4879 | 4879 | 2020-05-30 | Minnesota | 27 | 24200 | 1036 |
4880 | 4880 | 2020-05-30 | Mississippi | 28 | 15229 | 723 |
4881 | 4881 | 2020-05-30 | Missouri | 29 | 13118 | 782 |
4882 | 4882 | 2020-05-30 | Montana | 30 | 505 | 17 |
4883 | 4883 | 2020-05-30 | Nebraska | 31 | 13905 | 177 |
4884 | 4884 | 2020-05-30 | Nevada | 32 | 8519 | 417 |
4885 | 4885 | 2020-05-30 | New Hampshire | 33 | 4545 | 242 |
4886 | 4886 | 2020-05-30 | New Jersey | 34 | 159608 | 11634 |
4887 | 4887 | 2020-05-30 | New Mexico | 35 | 7624 | 351 |
4888 | 4888 | 2020-05-30 | New York | 36 | 374471 | 29612 |
4889 | 4889 | 2020-05-30 | North Carolina | 37 | 27761 | 903 |
4890 | 4890 | 2020-05-30 | North Dakota | 38 | 2557 | 63 |
4891 | 4891 | 2020-05-30 | Northern Mariana Islands | 69 | 22 | 2 |
4892 | 4892 | 2020-05-30 | Ohio | 39 | 35034 | 2149 |
4893 | 4893 | 2020-05-30 | Oklahoma | 40 | 6418 | 334 |
4894 | 4894 | 2020-05-30 | Oregon | 41 | 4185 | 153 |
4895 | 4895 | 2020-05-30 | Pennsylvania | 42 | 75789 | 5537 |
4896 | 4896 | 2020-05-30 | Puerto Rico | 72 | 3718 | 133 |
4897 | 4897 | 2020-05-30 | Rhode Island | 44 | 14819 | 711 |
4898 | 4898 | 2020-05-30 | South Carolina | 45 | 11394 | 487 |
4899 | 4899 | 2020-05-30 | South Dakota | 46 | 4960 | 62 |
4900 | 4900 | 2020-05-30 | Tennessee | 47 | 22676 | 360 |
4901 | 4901 | 2020-05-30 | Texas | 48 | 63396 | 1676 |
4902 | 4902 | 2020-05-30 | Utah | 49 | 9551 | 112 |
4903 | 4903 | 2020-05-30 | Vermont | 50 | 977 | 55 |
4904 | 4904 | 2020-05-30 | Virgin Islands | 78 | 70 | 6 |
4905 | 4905 | 2020-05-30 | Virginia | 51 | 43611 | 1370 |
4906 | 4906 | 2020-05-30 | Washington | 53 | 22618 | 1126 |
4907 | 4907 | 2020-05-30 | West Virginia | 54 | 1989 | 75 |
4908 | 4908 | 2020-05-30 | Wisconsin | 55 | 18515 | 588 |
4909 | 4909 | 2020-05-30 | Wyoming | 56 | 898 | 16 |
4800 | 4800 | 2020-05-29 | Alabama | 1 | 17031 | 610 |
4801 | 4801 | 2020-05-29 | Alaska | 2 | 436 | 8 |
4802 | 4802 | 2020-05-29 | Arizona | 4 | 18465 | 885 |
4803 | 4803 | 2020-05-29 | Arkansas | 5 | 6777 | 132 |
4804 | 4804 | 2020-05-29 | California | 6 | 107043 | 4144 |
4805 | 4805 | 2020-05-29 | Colorado | 8 | 25602 | 1437 |
4806 | 4806 | 2020-05-29 | Connecticut | 9 | 41762 | 3868 |
4807 | 4807 | 2020-05-29 | Delaware | 10 | 9236 | 356 |
4808 | 4808 | 2020-05-29 | District of Columbia | 11 | 8538 | 460 |
4809 | 4809 | 2020-05-29 | Florida | 12 | 54489 | 2412 |
4810 | 4810 | 2020-05-29 | Georgia | 13 | 43888 | 1953 |
4811 | 4811 | 2020-05-29 | Guam | 66 | 1141 | 6 |
4812 | 4812 | 2020-05-29 | Hawaii | 15 | 639 | 17 |
4813 | 4813 | 2020-05-29 | Idaho | 16 | 2804 | 82 |
4814 | 4814 | 2020-05-29 | Illinois | 17 | 117794 | 5308 |
4815 | 4815 | 2020-05-29 | Indiana | 18 | 34399 | 2110 |
4816 | 4816 | 2020-05-29 | Iowa | 19 | 19019 | 525 |
4817 | 4817 | 2020-05-29 | Kansas | 20 | 9826 | 209 |
4818 | 4818 | 2020-05-29 | Kentucky | 21 | 9688 | 434 |
4819 | 4819 | 2020-05-29 | Louisiana | 22 | 38907 | 2766 |
4820 | 4820 | 2020-05-29 | Maine | 23 | 2226 | 85 |
4821 | 4821 | 2020-05-29 | Maryland | 24 | 51631 | 2466 |
4822 | 4822 | 2020-05-29 | Massachusetts | 25 | 95512 | 6718 |
4823 | 4823 | 2020-05-29 | Michigan | 26 | 56589 | 5406 |
4824 | 4824 | 2020-05-29 | Minnesota | 27 | 23541 | 1006 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );