ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,502,832 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 56
- Texas 168,366
- Georgia 108,889
- Virginia 89,958
- Kentucky 80,572
- Missouri 78,017
- Illinois 69,202
- Kansas 68,758
- North Carolina 67,909
- Iowa 67,070
- Tennessee 65,215
- Indiana 62,686
- Ohio 60,290
- Nebraska 59,949
- Minnesota 59,139
- Michigan 56,802
- Mississippi 55,972
- Oklahoma 52,201
- Arkansas 51,432
- Puerto Rico 50,576
- Wisconsin 48,865
- Florida 46,562
- Pennsylvania 45,808
- Alabama 45,612
- Louisiana 44,402
- Colorado 43,127
- South Dakota 43,018
- New York 39,950
- California 39,892
- West Virginia 36,793
- North Dakota 35,153
- Montana 35,112
- South Carolina 31,537
- Idaho 28,784
- Washington 27,022
- Oregon 24,219
- New Mexico 22,120
- Utah 19,949
- Alaska 17,770
- Maryland 17,145
- Wyoming 15,538
- New Jersey 15,239
- Maine 11,398
- Nevada 11,124
- Arizona 10,419
- Massachusetts 10,414
- Vermont 10,273
- New Hampshire 7,523
- Connecticut 6,191
- Rhode Island 4,110
- Hawaii 3,382
- Delaware 2,731
- Virgin Islands 2,184
- Northern Mariana Islands 1,441
- District of Columbia 698
- Guam 690
- American Samoa 139
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2178807 | 2178807 | 2022-02-03 | Kanabec | Minnesota | 27065 | 3313 | 53 |
2178808 | 2178808 | 2022-02-03 | Kandiyohi | Minnesota | 27067 | 12578 | 129 |
2178809 | 2178809 | 2022-02-03 | Kittson | Minnesota | 27069 | 983 | 26 |
2178810 | 2178810 | 2022-02-03 | Koochiching | Minnesota | 27071 | 2498 | 34 |
2178811 | 2178811 | 2022-02-03 | Lac qui Parle | Minnesota | 27073 | 1624 | 28 |
2178812 | 2178812 | 2022-02-03 | Lake | Minnesota | 27075 | 1905 | 26 |
2178813 | 2178813 | 2022-02-03 | Lake of the Woods | Minnesota | 27077 | 708 | 5 |
2178814 | 2178814 | 2022-02-03 | Le Sueur | Minnesota | 27079 | 6075 | 47 |
2178815 | 2178815 | 2022-02-03 | Lincoln | Minnesota | 27081 | 1167 | 5 |
2178816 | 2178816 | 2022-02-03 | Lyon | Minnesota | 27083 | 6805 | 70 |
2178817 | 2178817 | 2022-02-03 | Mahnomen | Minnesota | 27087 | 1450 | 17 |
2178818 | 2178818 | 2022-02-03 | Marshall | Minnesota | 27089 | 1905 | 23 |
2178819 | 2178819 | 2022-02-03 | Martin | Minnesota | 27091 | 5193 | 54 |
2178820 | 2178820 | 2022-02-03 | McLeod | Minnesota | 27085 | 9867 | 98 |
2178821 | 2178821 | 2022-02-03 | Meeker | Minnesota | 27093 | 5558 | 73 |
2178822 | 2178822 | 2022-02-03 | Mille Lacs | Minnesota | 27095 | 6830 | 103 |
2178823 | 2178823 | 2022-02-03 | Morrison | Minnesota | 27097 | 8542 | 94 |
2178824 | 2178824 | 2022-02-03 | Mower | Minnesota | 27099 | 11266 | 60 |
2178825 | 2178825 | 2022-02-03 | Murray | Minnesota | 27101 | 1947 | 15 |
2178826 | 2178826 | 2022-02-03 | Nicollet | Minnesota | 27103 | 7412 | 66 |
2178827 | 2178827 | 2022-02-03 | Nobles | Minnesota | 27105 | 6668 | 57 |
2178828 | 2178828 | 2022-02-03 | Norman | Minnesota | 27107 | 1389 | 13 |
2178829 | 2178829 | 2022-02-03 | Olmsted | Minnesota | 27109 | 37455 | 153 |
2178830 | 2178830 | 2022-02-03 | Otter Tail | Minnesota | 27111 | 12545 | 155 |
2178831 | 2178831 | 2022-02-03 | Pennington | Minnesota | 27113 | 3263 | 36 |
2178832 | 2178832 | 2022-02-03 | Pine | Minnesota | 27115 | 6593 | 59 |
2178833 | 2178833 | 2022-02-03 | Pipestone | Minnesota | 27117 | 1907 | 33 |
2178834 | 2178834 | 2022-02-03 | Polk | Minnesota | 27119 | 7853 | 95 |
2178835 | 2178835 | 2022-02-03 | Pope | Minnesota | 27121 | 2762 | 16 |
2178836 | 2178836 | 2022-02-03 | Ramsey | Minnesota | 27123 | 117123 | 1257 |
2178837 | 2178837 | 2022-02-03 | Red Lake | Minnesota | 27125 | 886 | 11 |
2178838 | 2178838 | 2022-02-03 | Redwood | Minnesota | 27127 | 3663 | 51 |
2178839 | 2178839 | 2022-02-03 | Renville | Minnesota | 27129 | 3403 | 53 |
2178840 | 2178840 | 2022-02-03 | Rice | Minnesota | 27131 | 16667 | 163 |
2178841 | 2178841 | 2022-02-03 | Rock | Minnesota | 27133 | 2257 | 32 |
2178842 | 2178842 | 2022-02-03 | Roseau | Minnesota | 27135 | 4228 | 41 |
2178843 | 2178843 | 2022-02-03 | Scott | Minnesota | 27139 | 38069 | 236 |
2178844 | 2178844 | 2022-02-03 | Sherburne | Minnesota | 27141 | 26109 | 168 |
2178845 | 2178845 | 2022-02-03 | Sibley | Minnesota | 27143 | 3288 | 23 |
2178846 | 2178846 | 2022-02-03 | St. Louis | Minnesota | 27137 | 42901 | 491 |
2178847 | 2178847 | 2022-02-03 | Stearns | Minnesota | 27145 | 47974 | 344 |
2178848 | 2178848 | 2022-02-03 | Steele | Minnesota | 27147 | 9719 | 50 |
2178849 | 2178849 | 2022-02-03 | Stevens | Minnesota | 27149 | 2454 | 12 |
2178850 | 2178850 | 2022-02-03 | Swift | Minnesota | 27151 | 2122 | 31 |
2178851 | 2178851 | 2022-02-03 | Todd | Minnesota | 27153 | 6263 | 54 |
2178852 | 2178852 | 2022-02-03 | Traverse | Minnesota | 27155 | 752 | 9 |
2178853 | 2178853 | 2022-02-03 | Unknown | Minnesota | 7666 | 150 | |
2178854 | 2178854 | 2022-02-03 | Wabasha | Minnesota | 27157 | 5159 | 15 |
2178855 | 2178855 | 2022-02-03 | Wadena | Minnesota | 27159 | 3892 | 48 |
2178856 | 2178856 | 2022-02-03 | Waseca | Minnesota | 27161 | 5209 | 38 |
2178857 | 2178857 | 2022-02-03 | Washington | Minnesota | 27163 | 63020 | 450 |
2178858 | 2178858 | 2022-02-03 | Watonwan | Minnesota | 27165 | 2707 | 22 |
2178859 | 2178859 | 2022-02-03 | Wilkin | Minnesota | 27167 | 1507 | 20 |
2178860 | 2178860 | 2022-02-03 | Winona | Minnesota | 27169 | 11580 | 67 |
2178861 | 2178861 | 2022-02-03 | Wright | Minnesota | 27171 | 34806 | 291 |
2178862 | 2178862 | 2022-02-03 | Yellow Medicine | Minnesota | 27173 | 2385 | 27 |
2178863 | 2178863 | 2022-02-03 | Adams | Mississippi | 28001 | 6554 | 133 |
2178864 | 2178864 | 2022-02-03 | Alcorn | Mississippi | 28003 | 9318 | 136 |
2178865 | 2178865 | 2022-02-03 | Amite | Mississippi | 28005 | 2999 | 61 |
2178866 | 2178866 | 2022-02-03 | Attala | Mississippi | 28007 | 4514 | 98 |
2178867 | 2178867 | 2022-02-03 | Benton | Mississippi | 28009 | 2142 | 46 |
2178868 | 2178868 | 2022-02-03 | Bolivar | Mississippi | 28011 | 8612 | 160 |
2178869 | 2178869 | 2022-02-03 | Calhoun | Mississippi | 28013 | 4367 | 56 |
2178870 | 2178870 | 2022-02-03 | Carroll | Mississippi | 28015 | 2441 | 46 |
2178871 | 2178871 | 2022-02-03 | Chickasaw | Mississippi | 28017 | 5236 | 84 |
2178872 | 2178872 | 2022-02-03 | Choctaw | Mississippi | 28019 | 1924 | 28 |
2178873 | 2178873 | 2022-02-03 | Claiborne | Mississippi | 28021 | 2074 | 45 |
2178874 | 2178874 | 2022-02-03 | Clarke | Mississippi | 28023 | 3961 | 98 |
2178875 | 2178875 | 2022-02-03 | Clay | Mississippi | 28025 | 4760 | 89 |
2178876 | 2178876 | 2022-02-03 | Coahoma | Mississippi | 28027 | 6084 | 119 |
2178877 | 2178877 | 2022-02-03 | Copiah | Mississippi | 28029 | 6531 | 101 |
2178878 | 2178878 | 2022-02-03 | Covington | Mississippi | 28031 | 6707 | 99 |
2178879 | 2178879 | 2022-02-03 | DeSoto | Mississippi | 28033 | 47274 | 494 |
2178880 | 2178880 | 2022-02-03 | Forrest | Mississippi | 28035 | 20382 | 281 |
2178881 | 2178881 | 2022-02-03 | Franklin | Mississippi | 28037 | 1806 | 35 |
2178882 | 2178882 | 2022-02-03 | George | Mississippi | 28039 | 6751 | 81 |
2178883 | 2178883 | 2022-02-03 | Greene | Mississippi | 28041 | 2961 | 51 |
2178884 | 2178884 | 2022-02-03 | Grenada | Mississippi | 28043 | 5224 | 122 |
2178885 | 2178885 | 2022-02-03 | Hancock | Mississippi | 28045 | 11235 | 145 |
2178886 | 2178886 | 2022-02-03 | Harrison | Mississippi | 28047 | 48647 | 600 |
2178887 | 2178887 | 2022-02-03 | Hinds | Mississippi | 28049 | 50166 | 709 |
2178888 | 2178888 | 2022-02-03 | Holmes | Mississippi | 28051 | 4213 | 98 |
2178889 | 2178889 | 2022-02-03 | Humphreys | Mississippi | 28053 | 1903 | 40 |
2178890 | 2178890 | 2022-02-03 | Issaquena | Mississippi | 28055 | 247 | 8 |
2178891 | 2178891 | 2022-02-03 | Itawamba | Mississippi | 28057 | 6964 | 123 |
2178892 | 2178892 | 2022-02-03 | Jackson | Mississippi | 28059 | 34863 | 406 |
2178893 | 2178893 | 2022-02-03 | Jasper | Mississippi | 28061 | 4545 | 67 |
2178894 | 2178894 | 2022-02-03 | Jefferson | Mississippi | 28063 | 1406 | 35 |
2178895 | 2178895 | 2022-02-03 | Jefferson Davis | Mississippi | 28065 | 2673 | 45 |
2178896 | 2178896 | 2022-02-03 | Jones | Mississippi | 28067 | 20101 | 265 |
2178897 | 2178897 | 2022-02-03 | Kemper | Mississippi | 28069 | 2079 | 44 |
2178898 | 2178898 | 2022-02-03 | Lafayette | Mississippi | 28071 | 14070 | 168 |
2178899 | 2178899 | 2022-02-03 | Lamar | Mississippi | 28073 | 16168 | 144 |
2178900 | 2178900 | 2022-02-03 | Lauderdale | Mississippi | 28075 | 17764 | 335 |
2178901 | 2178901 | 2022-02-03 | Lawrence | Mississippi | 28077 | 3333 | 46 |
2178902 | 2178902 | 2022-02-03 | Leake | Mississippi | 28079 | 5812 | 103 |
2178903 | 2178903 | 2022-02-03 | Lee | Mississippi | 28081 | 25209 | 271 |
2178904 | 2178904 | 2022-02-03 | Leflore | Mississippi | 28083 | 7098 | 154 |
2178905 | 2178905 | 2022-02-03 | Lincoln | Mississippi | 28085 | 7615 | 146 |
2178906 | 2178906 | 2022-02-03 | Lowndes | Mississippi | 28087 | 16433 | 216 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);