ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
117 rows where cases = 3940 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Montana 12
- Indiana 9
- Iowa 8
- Georgia 7
- Texas 7
- Illinois 6
- Michigan 6
- Mississippi 5
- North Carolina 5
- Tennessee 5
- Kentucky 4
- West Virginia 4
- Arkansas 3
- Idaho 3
- Kansas 3
- Louisiana 3
- Nebraska 3
- New York 3
- Ohio 3
- Colorado 2
- Maine 2
- Puerto Rico 2
- Utah 2
- Washington 2
- Alabama 1
- California 1
- Maryland 1
- Massachusetts 1
- Minnesota 1
- Missouri 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502686 | 2502686 | 2022-05-13 | Braxton | West Virginia | 54007 | 3940 | 43 |
2374220 | 2374220 | 2022-04-04 | Glacier | Montana | 30035 | 3940 | 69 |
2370968 | 2370968 | 2022-04-03 | Glacier | Montana | 30035 | 3940 | 69 |
2367715 | 2367715 | 2022-04-02 | Glacier | Montana | 30035 | 3940 | 69 |
2364462 | 2364462 | 2022-04-01 | Glacier | Montana | 30035 | 3940 | 69 |
2361208 | 2361208 | 2022-03-31 | Glacier | Montana | 30035 | 3940 | 69 |
2357954 | 2357954 | 2022-03-30 | Glacier | Montana | 30035 | 3940 | 69 |
2354701 | 2354701 | 2022-03-29 | Glacier | Montana | 30035 | 3940 | 69 |
2351448 | 2351448 | 2022-03-28 | Glacier | Montana | 30035 | 3940 | 69 |
2348196 | 2348196 | 2022-03-27 | Glacier | Montana | 30035 | 3940 | 69 |
2344943 | 2344943 | 2022-03-26 | Glacier | Montana | 30035 | 3940 | 69 |
2341690 | 2341690 | 2022-03-25 | Glacier | Montana | 30035 | 3940 | 69 |
2338437 | 2338437 | 2022-03-24 | Glacier | Montana | 30035 | 3940 | 69 |
2224111 | 2224111 | 2022-02-17 | Bienville | Louisiana | 22013 | 3940 | 105 |
2217177 | 2217177 | 2022-02-15 | Warren | Illinois | 17187 | 3940 | 81 |
2203100 | 2203100 | 2022-02-10 | Zavala | Texas | 48507 | 3940 | 59 |
2194528 | 2194528 | 2022-02-08 | Clay | Iowa | 19041 | 3940 | 40 |
2191274 | 2191274 | 2022-02-07 | Clay | Iowa | 19041 | 3940 | 40 |
2187991 | 2187991 | 2022-02-06 | Vermillion | Indiana | 18165 | 3940 | 68 |
2188021 | 2188021 | 2022-02-06 | Clay | Iowa | 19041 | 3940 | 40 |
2184738 | 2184738 | 2022-02-05 | Vermillion | Indiana | 18165 | 3940 | 68 |
2184768 | 2184768 | 2022-02-05 | Clay | Iowa | 19041 | 3940 | 40 |
2181486 | 2181486 | 2022-02-04 | Vermillion | Indiana | 18165 | 3940 | 68 |
2181516 | 2181516 | 2022-02-04 | Clay | Iowa | 19041 | 3940 | 40 |
2178119 | 2178119 | 2022-02-03 | Moultrie | Illinois | 17139 | 3940 | 50 |
2178265 | 2178265 | 2022-02-03 | Clay | Iowa | 19041 | 3940 | 40 |
2174866 | 2174866 | 2022-02-02 | Moultrie | Illinois | 17139 | 3940 | 50 |
2175012 | 2175012 | 2022-02-02 | Clay | Iowa | 19041 | 3940 | 40 |
2165958 | 2165958 | 2022-01-30 | Cooper | Missouri | 29053 | 3940 | 71 |
2145050 | 2145050 | 2022-01-24 | Grant | Arkansas | 5053 | 3940 | 53 |
2134279 | 2134279 | 2022-01-20 | Morovis | Puerto Rico | 72101 | 3940 | |
2103828 | 2103828 | 2022-01-11 | Waldo | Maine | 23027 | 3940 | 44 |
2098825 | 2098825 | 2022-01-09 | Fayette | Texas | 48149 | 3940 | 95 |
2086037 | 2086037 | 2022-01-05 | Orleans | Vermont | 50019 | 3940 | 31 |
2081176 | 2081176 | 2022-01-04 | Osceola | Michigan | 26133 | 3940 | 63 |
2077924 | 2077924 | 2022-01-03 | Osceola | Michigan | 26133 | 3940 | 63 |
2041325 | 2041325 | 2021-12-23 | Harris | Georgia | 13145 | 3940 | 96 |
2028366 | 2028366 | 2021-12-19 | Pike | Georgia | 13231 | 3940 | 73 |
2025115 | 2025115 | 2021-12-18 | Pike | Georgia | 13231 | 3940 | 73 |
2021864 | 2021864 | 2021-12-17 | Pike | Georgia | 13231 | 3940 | 73 |
2005551 | 2005551 | 2021-12-12 | Fannin | Georgia | 13111 | 3940 | 114 |
2002300 | 2002300 | 2021-12-11 | Fannin | Georgia | 13111 | 3940 | 114 |
1999050 | 1999050 | 2021-12-10 | Fannin | Georgia | 13111 | 3940 | 114 |
1979006 | 1979006 | 2021-12-03 | Wyoming | West Virginia | 54109 | 3940 | 71 |
1953220 | 1953220 | 2021-11-26 | Cleburne | Arkansas | 5023 | 3940 | 95 |
1915788 | 1915788 | 2021-11-14 | Dawson | Nebraska | 31047 | 3940 | 33 |
1912538 | 1912538 | 2021-11-13 | Dawson | Nebraska | 31047 | 3940 | 33 |
1909288 | 1909288 | 2021-11-12 | Dawson | Nebraska | 31047 | 3940 | 33 |
1859598 | 1859598 | 2021-10-28 | Jennings | Indiana | 18079 | 3940 | 66 |
1856793 | 1856793 | 2021-10-27 | Aroostook | Maine | 23003 | 3940 | 79 |
1755975 | 1755975 | 2021-09-26 | Ohio | Kentucky | 21183 | 3940 | 71 |
1752727 | 1752727 | 2021-09-25 | Ohio | Kentucky | 21183 | 3940 | 71 |
1749478 | 1749478 | 2021-09-24 | Ohio | Kentucky | 21183 | 3940 | 71 |
1736015 | 1736015 | 2021-09-20 | Fayette | Illinois | 17051 | 3940 | 59 |
1732724 | 1732724 | 2021-09-19 | Latah | Idaho | 16057 | 3940 | 21 |
1729474 | 1729474 | 2021-09-18 | Latah | Idaho | 16057 | 3940 | 21 |
1726224 | 1726224 | 2021-09-17 | Latah | Idaho | 16057 | 3940 | 21 |
1676739 | 1676739 | 2021-09-01 | Kittitas | Washington | 53037 | 3940 | 41 |
1650804 | 1650804 | 2021-08-24 | Marshall | West Virginia | 54051 | 3940 | 81 |
1610028 | 1610028 | 2021-08-12 | Becker | Minnesota | 27005 | 3940 | 58 |
1611435 | 1611435 | 2021-08-12 | Hopkins | Texas | 48223 | 3940 | 116 |
1571820 | 1571820 | 2021-07-31 | Logan | Ohio | 39091 | 3940 | 79 |
1562536 | 1562536 | 2021-07-28 | Henderson | Tennessee | 47077 | 3940 | 78 |
1545862 | 1545862 | 2021-07-23 | Preble | Ohio | 39135 | 3940 | 107 |
1526106 | 1526106 | 2021-07-17 | Cortland | New York | 36023 | 3940 | 64 |
1522859 | 1522859 | 2021-07-16 | Cortland | New York | 36023 | 3940 | 64 |
1519611 | 1519611 | 2021-07-15 | Cortland | New York | 36023 | 3940 | 64 |
1516493 | 1516493 | 2021-07-14 | Scotland | North Carolina | 37165 | 3940 | 88 |
1512697 | 1512697 | 2021-07-13 | Hancock | Mississippi | 28045 | 3940 | 88 |
1495769 | 1495769 | 2021-07-08 | Jasper | Indiana | 18073 | 3940 | 57 |
1494679 | 1494679 | 2021-07-07 | Sanpete | Utah | 49039 | 3940 | 23 |
1346503 | 1346503 | 2021-05-23 | Steuben | Indiana | 18151 | 3940 | 59 |
1320486 | 1320486 | 2021-05-15 | Huntington | Indiana | 18069 | 3940 | 82 |
1302656 | 1302656 | 2021-05-09 | Ponce | Puerto Rico | 72113 | 3940 | |
1274579 | 1274579 | 2021-05-01 | Logan | Colorado | 8075 | 3940 | 67 |
1246389 | 1246389 | 2021-04-22 | Sanilac | Michigan | 26151 | 3940 | 100 |
1233357 | 1233357 | 2021-04-18 | Hillsdale | Michigan | 26059 | 3940 | 82 |
1230109 | 1230109 | 2021-04-17 | Hillsdale | Michigan | 26059 | 3940 | 82 |
1226240 | 1226240 | 2021-04-16 | Lee | Illinois | 17103 | 3940 | 89 |
1226893 | 1226893 | 2021-04-16 | Newaygo | Michigan | 26123 | 3940 | 56 |
1228558 | 1228558 | 2021-04-16 | Franklin | Virginia | 51067 | 3940 | 73 |
1192724 | 1192724 | 2021-04-05 | Wharton | Texas | 48481 | 3940 | 112 |
1145114 | 1145114 | 2021-03-22 | DeKalb | Indiana | 18033 | 3940 | 83 |
1139965 | 1139965 | 2021-03-20 | Ashland | Ohio | 39005 | 3940 | 85 |
1104775 | 1104775 | 2021-03-09 | Marshall | Tennessee | 47117 | 3940 | 57 |
1093634 | 1093634 | 2021-03-06 | Webster | Louisiana | 22119 | 3940 | 97 |
1090388 | 1090388 | 2021-03-05 | Webster | Louisiana | 22119 | 3940 | 97 |
1066702 | 1066702 | 2021-02-26 | Nevada | California | 6057 | 3940 | 74 |
1057794 | 1057794 | 2021-02-23 | Graves | Kentucky | 21083 | 3940 | 70 |
1038737 | 1038737 | 2021-02-17 | Marshall | Mississippi | 28093 | 3940 | 92 |
1005772 | 1005772 | 2021-02-07 | Lyon | Kansas | 20111 | 3940 | 73 |
1002526 | 1002526 | 2021-02-06 | Lyon | Kansas | 20111 | 3940 | 73 |
1004711 | 1004711 | 2021-02-06 | Putnam | West Virginia | 54079 | 3940 | 73 |
999280 | 999280 | 2021-02-05 | Lyon | Kansas | 20111 | 3940 | 73 |
996573 | 996573 | 2021-02-04 | Warren | Mississippi | 28149 | 3940 | 110 |
980788 | 980788 | 2021-01-30 | Edgecombe | North Carolina | 37065 | 3940 | 90 |
977542 | 977542 | 2021-01-29 | Edgecombe | North Carolina | 37065 | 3940 | 90 |
978183 | 978183 | 2021-01-29 | Lincoln | Tennessee | 47103 | 3940 | 53 |
971713 | 971713 | 2021-01-27 | Rhea | Tennessee | 47143 | 3940 | 60 |
963376 | 963376 | 2021-01-25 | Lawrence | Indiana | 18093 | 3940 | 83 |
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);