ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
117 rows where cases = 4251 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Minnesota 10
- Texas 9
- Virginia 8
- Michigan 7
- South Carolina 7
- California 6
- Louisiana 6
- Illinois 5
- New York 5
- Ohio 5
- Maine 4
- Tennessee 4
- Wisconsin 4
- Georgia 3
- Indiana 3
- Iowa 3
- Kentucky 3
- West Virginia 3
- Alabama 2
- Arkansas 2
- Idaho 2
- Kansas 2
- Missouri 2
- North Carolina 2
- Pennsylvania 2
- Puerto Rico 2
- Florida 1
- Maryland 1
- Mississippi 1
- New Jersey 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2487954 | 2487954 | 2022-05-09 | Wadena | Minnesota | 27159 | 4251 | 55 |
2438847 | 2438847 | 2022-04-24 | LaSalle | Louisiana | 22059 | 4251 | 59 |
2435591 | 2435591 | 2022-04-23 | LaSalle | Louisiana | 22059 | 4251 | 59 |
2432335 | 2432335 | 2022-04-22 | LaSalle | Louisiana | 22059 | 4251 | 59 |
2429079 | 2429079 | 2022-04-21 | LaSalle | Louisiana | 22059 | 4251 | 59 |
2420614 | 2420614 | 2022-04-18 | Lee | South Carolina | 45061 | 4251 | 94 |
2417358 | 2417358 | 2022-04-17 | Lee | South Carolina | 45061 | 4251 | 94 |
2418042 | 2418042 | 2022-04-17 | Morgan | West Virginia | 54065 | 4251 | 69 |
2414102 | 2414102 | 2022-04-16 | Lee | South Carolina | 45061 | 4251 | 94 |
2414786 | 2414786 | 2022-04-16 | Morgan | West Virginia | 54065 | 4251 | 69 |
2410846 | 2410846 | 2022-04-15 | Lee | South Carolina | 45061 | 4251 | 94 |
2411530 | 2411530 | 2022-04-15 | Morgan | West Virginia | 54065 | 4251 | 69 |
2407590 | 2407590 | 2022-04-14 | Lee | South Carolina | 45061 | 4251 | 94 |
2404334 | 2404334 | 2022-04-13 | Lee | South Carolina | 45061 | 4251 | 94 |
2401079 | 2401079 | 2022-04-12 | Lee | South Carolina | 45061 | 4251 | 94 |
2328246 | 2328246 | 2022-03-21 | Washington | Maine | 23029 | 4251 | 52 |
2324993 | 2324993 | 2022-03-20 | Washington | Maine | 23029 | 4251 | 52 |
2321739 | 2321739 | 2022-03-19 | Washington | Maine | 23029 | 4251 | 52 |
2246854 | 2246854 | 2022-02-24 | Union | Kentucky | 21225 | 4251 | 54 |
2243603 | 2243603 | 2022-02-23 | Union | Kentucky | 21225 | 4251 | 54 |
2213629 | 2213629 | 2022-02-14 | Ben Hill | Georgia | 13017 | 4251 | 114 |
2212815 | 2212815 | 2022-02-13 | Shelby | Texas | 48419 | 4251 | 124 |
2189559 | 2189559 | 2022-02-06 | Coamo | Puerto Rico | 72043 | 4251 | |
2178641 | 2178641 | 2022-02-03 | Knox | Maine | 23013 | 4251 | 22 |
2170003 | 2170003 | 2022-01-31 | Montour | Pennsylvania | 42093 | 4251 | 84 |
2156277 | 2156277 | 2022-01-27 | Texas | Missouri | 29215 | 4251 | 79 |
2115826 | 2115826 | 2022-01-15 | Del Norte | California | 6015 | 4251 | 43 |
2112575 | 2112575 | 2022-01-14 | Del Norte | California | 6015 | 4251 | 43 |
2109323 | 2109323 | 2022-01-13 | Del Norte | California | 6015 | 4251 | 43 |
2102422 | 2102422 | 2022-01-10 | Staunton city | Virginia | 51790 | 4251 | 89 |
2077986 | 2077986 | 2022-01-03 | Martin | Minnesota | 27091 | 4251 | 52 |
2079634 | 2079634 | 2022-01-03 | Page | Virginia | 51139 | 4251 | 92 |
2009534 | 2009534 | 2021-12-13 | Union | Louisiana | 22111 | 4251 | 112 |
1968712 | 1968712 | 2021-11-30 | Smith | Tennessee | 47159 | 4251 | 53 |
1964416 | 1964416 | 2021-11-29 | Miller | Missouri | 29131 | 4251 | 100 |
1921855 | 1921855 | 2021-11-16 | Clare | Michigan | 26035 | 4251 | 112 |
1918605 | 1918605 | 2021-11-15 | Clare | Michigan | 26035 | 4251 | 112 |
1912057 | 1912057 | 2021-11-13 | Dorchester | Maryland | 24019 | 4251 | 84 |
1904865 | 1904865 | 2021-11-11 | Sumter | Georgia | 13261 | 4251 | 136 |
1901615 | 1901615 | 2021-11-10 | Sumter | Georgia | 13261 | 4251 | 136 |
1861588 | 1861588 | 2021-10-28 | Hockley | Texas | 48219 | 4251 | 132 |
1858339 | 1858339 | 2021-10-27 | Hockley | Texas | 48219 | 4251 | 132 |
1842609 | 1842609 | 2021-10-23 | Bibb | Alabama | 1007 | 4251 | 86 |
1842751 | 1842751 | 2021-10-23 | Jackson | Arkansas | 5067 | 4251 | 42 |
1816732 | 1816732 | 2021-10-15 | Carroll | Arkansas | 5015 | 4251 | 73 |
1818496 | 1818496 | 2021-10-15 | Orleans | New York | 36073 | 4251 | 87 |
1815417 | 1815417 | 2021-10-14 | Stutsman | North Dakota | 38093 | 4251 | 85 |
1799880 | 1799880 | 2021-10-09 | Kleberg | Texas | 48273 | 4251 | 125 |
1791208 | 1791208 | 2021-10-07 | Latah | Idaho | 16057 | 4251 | 25 |
1784807 | 1784807 | 2021-10-05 | Saline | Illinois | 17165 | 4251 | 84 |
1780667 | 1780667 | 2021-10-03 | Smyth | Virginia | 51173 | 4251 | 103 |
1777417 | 1777417 | 2021-10-02 | Smyth | Virginia | 51173 | 4251 | 103 |
1773784 | 1773784 | 2021-10-01 | Cass | Texas | 48067 | 4251 | 126 |
1774167 | 1774167 | 2021-10-01 | Smyth | Virginia | 51173 | 4251 | 103 |
1767803 | 1767803 | 2021-09-29 | Green | Wisconsin | 55045 | 4251 | 26 |
1723868 | 1723868 | 2021-09-16 | Simpson | Mississippi | 28127 | 4251 | 110 |
1721735 | 1721735 | 2021-09-15 | Overton | Tennessee | 47133 | 4251 | 65 |
1713212 | 1713212 | 2021-09-13 | Bonner | Idaho | 16017 | 4251 | 51 |
1678809 | 1678809 | 2021-09-02 | Warren | New York | 36113 | 4251 | 73 |
1666321 | 1666321 | 2021-08-29 | Trujillo Alto | Puerto Rico | 72139 | 4251 | |
1619774 | 1619774 | 2021-08-15 | Beltrami | Minnesota | 27007 | 4251 | 65 |
1616526 | 1616526 | 2021-08-14 | Beltrami | Minnesota | 27007 | 4251 | 65 |
1613278 | 1613278 | 2021-08-13 | Beltrami | Minnesota | 27007 | 4251 | 65 |
1573164 | 1573164 | 2021-08-01 | Lake | California | 6033 | 4251 | 66 |
1569916 | 1569916 | 2021-07-31 | Lake | California | 6033 | 4251 | 66 |
1566668 | 1566668 | 2021-07-30 | Lake | California | 6033 | 4251 | 66 |
1556009 | 1556009 | 2021-07-26 | Campbell | Tennessee | 47013 | 4251 | 62 |
1535028 | 1535028 | 2021-07-20 | Franklin | Kentucky | 21073 | 4251 | 58 |
1513880 | 1513880 | 2021-07-13 | Weakley | Tennessee | 47183 | 4251 | 69 |
1467187 | 1467187 | 2021-06-29 | Morrison | Minnesota | 27097 | 4251 | 62 |
1468506 | 1468506 | 2021-06-29 | Erath | Texas | 48143 | 4251 | 70 |
1463942 | 1463942 | 2021-06-28 | Morrison | Minnesota | 27097 | 4251 | 62 |
1460697 | 1460697 | 2021-06-27 | Morrison | Minnesota | 27097 | 4251 | 62 |
1457452 | 1457452 | 2021-06-26 | Morrison | Minnesota | 27097 | 4251 | 62 |
1454207 | 1454207 | 2021-06-25 | Morrison | Minnesota | 27097 | 4251 | 62 |
1436222 | 1436222 | 2021-06-19 | Wharton | Texas | 48481 | 4251 | 117 |
1392480 | 1392480 | 2021-06-06 | Sanilac | Michigan | 26151 | 4251 | 121 |
1389235 | 1389235 | 2021-06-05 | Sanilac | Michigan | 26151 | 4251 | 121 |
1385990 | 1385990 | 2021-06-04 | Sanilac | Michigan | 26151 | 4251 | 120 |
1386546 | 1386546 | 2021-06-04 | Montgomery | New York | 36057 | 4251 | 124 |
1318564 | 1318564 | 2021-05-14 | Ashland | Ohio | 39005 | 4251 | 90 |
1315339 | 1315339 | 2021-05-13 | Fulton | Ohio | 39051 | 4251 | 69 |
1291170 | 1291170 | 2021-05-06 | Jefferson | Illinois | 17081 | 4251 | 120 |
1268753 | 1268753 | 2021-04-29 | Lyon | Kansas | 20111 | 4251 | 84 |
1269931 | 1269931 | 2021-04-29 | Putnam | Ohio | 39137 | 4251 | 100 |
1265506 | 1265506 | 2021-04-28 | Lyon | Kansas | 20111 | 4251 | 84 |
1231795 | 1231795 | 2021-04-17 | Danville city | Virginia | 51590 | 4251 | 133 |
1226474 | 1226474 | 2021-04-16 | Wapello | Iowa | 19179 | 4251 | 120 |
1206835 | 1206835 | 2021-04-10 | Harrison | Indiana | 18061 | 4251 | 72 |
1203587 | 1203587 | 2021-04-09 | Harrison | Indiana | 18061 | 4251 | 72 |
1106590 | 1106590 | 2021-03-10 | Lincoln | Louisiana | 22061 | 4251 | 89 |
1088609 | 1088609 | 2021-03-04 | Burnet | Texas | 48053 | 4251 | 60 |
1089127 | 1089127 | 2021-03-04 | Douglas | Wisconsin | 55031 | 4251 | 41 |
1066291 | 1066291 | 2021-02-25 | Washington | Virginia | 51191 | 4251 | 93 |
1036956 | 1036956 | 2021-02-16 | Albemarle | Virginia | 51003 | 4251 | 39 |
1016458 | 1016458 | 2021-02-10 | Wayne | New York | 36117 | 4251 | 59 |
1007026 | 1007026 | 2021-02-07 | Osage | Oklahoma | 40113 | 4251 | 40 |
967936 | 967936 | 2021-01-26 | Auglaize | Ohio | 39011 | 4251 | 66 |
956058 | 956058 | 2021-01-22 | Dunn | Wisconsin | 55033 | 4251 | 26 |
931031 | 931031 | 2021-01-15 | Marshall | Iowa | 19127 | 4251 | 61 |
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);