ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
132 rows where cases = 4180 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 13
- Tennessee 10
- Texas 10
- Iowa 8
- Minnesota 8
- Montana 7
- North Carolina 7
- California 6
- Alabama 5
- Maryland 5
- Colorado 4
- Kentucky 4
- Louisiana 4
- Mississippi 4
- Oregon 4
- West Virginia 4
- Illinois 3
- Ohio 3
- Virginia 3
- Wisconsin 3
- Indiana 2
- Michigan 2
- Missouri 2
- Pennsylvania 2
- Puerto Rico 2
- Arkansas 1
- Florida 1
- Hawaii 1
- Nebraska 1
- New Hampshire 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2450208 | 2450208 | 2022-04-27 | Houston | Texas | 48225 | 4180 | 111 |
2446951 | 2446951 | 2022-04-26 | Houston | Texas | 48225 | 4180 | 111 |
2443696 | 2443696 | 2022-04-25 | Houston | Texas | 48225 | 4180 | 111 |
2440440 | 2440440 | 2022-04-24 | Houston | Texas | 48225 | 4180 | 111 |
2427793 | 2427793 | 2022-04-20 | Hardy | West Virginia | 54031 | 4180 | 49 |
2424537 | 2424537 | 2022-04-19 | Hardy | West Virginia | 54031 | 4180 | 49 |
2417259 | 2417259 | 2022-04-17 | Catano | Puerto Rico | 72033 | 4180 | |
2357827 | 2357827 | 2022-03-30 | Benton | Missouri | 29015 | 4180 | 103 |
2326562 | 2326562 | 2022-03-20 | Lavaca | Texas | 48285 | 4180 | 117 |
2255783 | 2255783 | 2022-02-27 | Otero | Colorado | 8089 | 4180 | 125 |
2252532 | 2252532 | 2022-02-26 | Otero | Colorado | 8089 | 4180 | 125 |
2249281 | 2249281 | 2022-02-25 | Otero | Colorado | 8089 | 4180 | 125 |
2246349 | 2246349 | 2022-02-24 | Carroll | Illinois | 17015 | 4180 | 47 |
2216377 | 2216377 | 2022-02-14 | Taylor | West Virginia | 54091 | 4180 | 60 |
2177585 | 2177585 | 2022-02-03 | Grant | Arkansas | 5053 | 4180 | 54 |
2170457 | 2170457 | 2022-01-31 | Lamb | Texas | 48279 | 4180 | 104 |
2151906 | 2151906 | 2022-01-26 | Meriwether | Georgia | 13199 | 4180 | 125 |
2149218 | 2149218 | 2022-01-25 | Henry | Kentucky | 21103 | 4180 | 40 |
2151137 | 2151137 | 2022-01-25 | Fluvanna | Virginia | 51065 | 4180 | 33 |
2145420 | 2145420 | 2022-01-24 | Putnam | Georgia | 13237 | 4180 | 92 |
2128416 | 2128416 | 2022-01-18 | Powhatan | Virginia | 51145 | 4180 | 34 |
2096570 | 2096570 | 2022-01-09 | Fannin | Georgia | 13111 | 4180 | 118 |
2092874 | 2092874 | 2022-01-08 | Barbour | Alabama | 1005 | 4180 | 83 |
2093318 | 2093318 | 2022-01-08 | Fannin | Georgia | 13111 | 4180 | 118 |
2090066 | 2090066 | 2022-01-07 | Fannin | Georgia | 13111 | 4180 | 118 |
2086815 | 2086815 | 2022-01-06 | Fannin | Georgia | 13111 | 4180 | 118 |
2087134 | 2087134 | 2022-01-06 | Owen | Indiana | 18119 | 4180 | 87 |
2083563 | 2083563 | 2022-01-05 | Fannin | Georgia | 13111 | 4180 | 118 |
2080947 | 2080947 | 2022-01-04 | McCreary | Kentucky | 21147 | 4180 | 68 |
2077695 | 2077695 | 2022-01-03 | McCreary | Kentucky | 21147 | 4180 | 68 |
2071321 | 2071321 | 2022-01-01 | Caroline | Maryland | 24011 | 4180 | 57 |
2068070 | 2068070 | 2021-12-31 | Caroline | Maryland | 24011 | 4180 | 57 |
2064819 | 2064819 | 2021-12-30 | Caroline | Maryland | 24011 | 4180 | 57 |
2062432 | 2062432 | 2021-12-29 | Carroll | Ohio | 39019 | 4180 | 90 |
2036745 | 2036745 | 2021-12-21 | Mayaguez | Puerto Rico | 72097 | 4180 | |
2009462 | 2009462 | 2021-12-13 | Russell | Kentucky | 21207 | 4180 | 64 |
1996123 | 1996123 | 2021-12-09 | Posey | Indiana | 18129 | 4180 | 44 |
1943846 | 1943846 | 2021-11-23 | Peach | Georgia | 13225 | 4180 | 110 |
1939078 | 1939078 | 2021-11-21 | Columbia | Oregon | 41009 | 4180 | 51 |
1935828 | 1935828 | 2021-11-20 | Columbia | Oregon | 41009 | 4180 | 51 |
1932578 | 1932578 | 2021-11-19 | Columbia | Oregon | 41009 | 4180 | 51 |
1928420 | 1928420 | 2021-11-18 | Wexford | Michigan | 26165 | 4180 | 62 |
1925170 | 1925170 | 2021-11-17 | Wexford | Michigan | 26165 | 4180 | 62 |
1882810 | 1882810 | 2021-11-04 | Dorchester | Maryland | 24019 | 4180 | 83 |
1880956 | 1880956 | 2021-11-03 | Smith | Tennessee | 47159 | 4180 | 52 |
1872342 | 1872342 | 2021-11-01 | Monroe | Georgia | 13207 | 4180 | 148 |
1870005 | 1870005 | 2021-10-31 | Todd | Minnesota | 27153 | 4180 | 37 |
1866756 | 1866756 | 2021-10-30 | Todd | Minnesota | 27153 | 4180 | 37 |
1863507 | 1863507 | 2021-10-29 | Todd | Minnesota | 27153 | 4180 | 37 |
1851655 | 1851655 | 2021-10-25 | DeKalb | Tennessee | 47041 | 4180 | 70 |
1848405 | 1848405 | 2021-10-24 | DeKalb | Tennessee | 47041 | 4180 | 70 |
1845155 | 1845155 | 2021-10-23 | DeKalb | Tennessee | 47041 | 4180 | 70 |
1841451 | 1841451 | 2021-10-22 | Hardin | Ohio | 39065 | 4180 | 80 |
1841905 | 1841905 | 2021-10-22 | DeKalb | Tennessee | 47041 | 4180 | 70 |
1783864 | 1783864 | 2021-10-04 | Isle of Wight | Virginia | 51093 | 4180 | 82 |
1773027 | 1773027 | 2021-10-01 | Washington | New York | 36115 | 4180 | 65 |
1765790 | 1765790 | 2021-09-29 | Richland | Louisiana | 22083 | 4180 | 75 |
1697792 | 1697792 | 2021-09-08 | Polk | Minnesota | 27119 | 4180 | 75 |
1631737 | 1631737 | 2021-08-19 | Summit | Colorado | 8117 | 4180 | 8 |
1601269 | 1601269 | 2021-08-09 | Pike | Pennsylvania | 42103 | 4180 | 54 |
1561629 | 1561629 | 2021-07-28 | Silver Bow | Montana | 30093 | 4180 | 86 |
1558381 | 1558381 | 2021-07-27 | Silver Bow | Montana | 30093 | 4180 | 86 |
1555134 | 1555134 | 2021-07-26 | Silver Bow | Montana | 30093 | 4180 | 86 |
1551887 | 1551887 | 2021-07-25 | Silver Bow | Montana | 30093 | 4180 | 86 |
1548640 | 1548640 | 2021-07-24 | Silver Bow | Montana | 30093 | 4180 | 86 |
1545393 | 1545393 | 2021-07-23 | Silver Bow | Montana | 30093 | 4180 | 86 |
1542814 | 1542814 | 2021-07-22 | Wayne | Pennsylvania | 42127 | 4180 | 84 |
1486750 | 1486750 | 2021-07-05 | Monroe | Mississippi | 28095 | 4180 | 136 |
1487221 | 1487221 | 2021-07-05 | Davie | North Carolina | 37059 | 4180 | 40 |
1483504 | 1483504 | 2021-07-04 | Monroe | Mississippi | 28095 | 4180 | 136 |
1483975 | 1483975 | 2021-07-04 | Davie | North Carolina | 37059 | 4180 | 40 |
1480258 | 1480258 | 2021-07-03 | Monroe | Mississippi | 28095 | 4180 | 136 |
1480729 | 1480729 | 2021-07-03 | Davie | North Carolina | 37059 | 4180 | 40 |
1477011 | 1477011 | 2021-07-02 | Monroe | Mississippi | 28095 | 4180 | 136 |
1477482 | 1477482 | 2021-07-02 | Davie | North Carolina | 37059 | 4180 | 40 |
1443576 | 1443576 | 2021-06-22 | Liberty | Georgia | 13179 | 4180 | 67 |
1403762 | 1403762 | 2021-06-09 | Washington | Texas | 48477 | 4180 | 94 |
1375307 | 1375307 | 2021-06-01 | Okeechobee | Florida | 12093 | 4180 | 89 |
1348344 | 1348344 | 2021-05-23 | Weakley | Tennessee | 47183 | 4180 | 67 |
1345096 | 1345096 | 2021-05-22 | Weakley | Tennessee | 47183 | 4180 | 67 |
1341848 | 1341848 | 2021-05-21 | Weakley | Tennessee | 47183 | 4180 | 67 |
1304360 | 1304360 | 2021-05-10 | Jasper | Iowa | 19099 | 4180 | 71 |
1301475 | 1301475 | 2021-05-09 | Calvert | Maryland | 24009 | 4180 | 78 |
1286731 | 1286731 | 2021-05-04 | Erath | Texas | 48143 | 4180 | 68 |
1283374 | 1283374 | 2021-05-03 | Marshall | Tennessee | 47117 | 4180 | 58 |
1266618 | 1266618 | 2021-04-28 | Ashland | Ohio | 39005 | 4180 | 89 |
1242382 | 1242382 | 2021-04-21 | Maui | Hawaii | 15009 | 4180 | 47 |
1227317 | 1227317 | 2021-04-16 | Madison | Nebraska | 31119 | 4180 | 42 |
1210859 | 1210859 | 2021-04-11 | Butler | Missouri | 29023 | 4180 | 40 |
1167934 | 1167934 | 2021-03-29 | Buena Vista | Iowa | 19021 | 4180 | 39 |
1164686 | 1164686 | 2021-03-28 | Buena Vista | Iowa | 19021 | 4180 | 39 |
1161438 | 1161438 | 2021-03-27 | Buena Vista | Iowa | 19021 | 4180 | 39 |
1159859 | 1159859 | 2021-03-26 | Codington | South Dakota | 46029 | 4180 | 80 |
1147673 | 1147673 | 2021-03-23 | Franklin | Alabama | 1059 | 4180 | 82 |
1144426 | 1144426 | 2021-03-22 | Franklin | Alabama | 1059 | 4180 | 82 |
1142035 | 1142035 | 2021-03-21 | Wapello | Iowa | 19179 | 4180 | 114 |
1142330 | 1142330 | 2021-03-21 | Washington | Louisiana | 22117 | 4180 | 125 |
1138789 | 1138789 | 2021-03-20 | Wapello | Iowa | 19179 | 4180 | 114 |
1139084 | 1139084 | 2021-03-20 | Washington | Louisiana | 22117 | 4180 | 125 |
1135838 | 1135838 | 2021-03-19 | Washington | Louisiana | 22117 | 4180 | 125 |
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);