ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
91 rows where cases = 5747 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 12
- Florida 9
- Georgia 8
- Kentucky 8
- Louisiana 5
- South Carolina 5
- North Carolina 4
- Ohio 4
- Nebraska 3
- Puerto Rico 3
- Arkansas 2
- California 2
- Indiana 2
- Iowa 2
- Kansas 2
- Michigan 2
- Mississippi 2
- Tennessee 2
- Washington 2
- Alabama 1
- Alaska 1
- Arizona 1
- Minnesota 1
- Missouri 1
- Nevada 1
- New York 1
- Oklahoma 1
- Pennsylvania 1
- Utah 1
- Wisconsin 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2427311 | 2427311 | 2022-04-20 | Austin | Texas | 48015 | 5747 | 73 |
2372027 | 2372027 | 2022-04-03 | Dimmit | Texas | 48127 | 5747 | 51 |
2368774 | 2368774 | 2022-04-02 | Dimmit | Texas | 48127 | 5747 | 51 |
2365521 | 2365521 | 2022-04-01 | Dimmit | Texas | 48127 | 5747 | 51 |
2323248 | 2323248 | 2022-03-19 | Frio | Texas | 48163 | 5747 | 92 |
2302104 | 2302104 | 2022-03-13 | Meade | Kentucky | 21163 | 5747 | 64 |
2298852 | 2298852 | 2022-03-12 | Meade | Kentucky | 21163 | 5747 | 64 |
2295600 | 2295600 | 2022-03-11 | Meade | Kentucky | 21163 | 5747 | 64 |
2292348 | 2292348 | 2022-03-10 | Meade | Kentucky | 21163 | 5747 | 64 |
2289096 | 2289096 | 2022-03-09 | Meade | Kentucky | 21163 | 5747 | 64 |
2285845 | 2285845 | 2022-03-08 | Meade | Kentucky | 21163 | 5747 | 64 |
2282593 | 2282593 | 2022-03-07 | Meade | Kentucky | 21163 | 5747 | 64 |
2283455 | 2283455 | 2022-03-07 | Greene | North Carolina | 37079 | 5747 | 56 |
2195177 | 2195177 | 2022-02-08 | Newton | Mississippi | 28101 | 5747 | 92 |
2196157 | 2196157 | 2022-02-08 | Jasper | South Carolina | 45053 | 5747 | 88 |
2188791 | 2188791 | 2022-02-06 | Randolph | Missouri | 29175 | 5747 | 92 |
2174943 | 2174943 | 2022-02-02 | LaGrange | Indiana | 18087 | 5747 | 99 |
2138405 | 2138405 | 2022-01-22 | Bibb | Alabama | 1007 | 5747 | 95 |
2089611 | 2089611 | 2022-01-06 | Park | Wyoming | 56029 | 5747 | 121 |
2079517 | 2079517 | 2022-01-03 | Uintah | Utah | 49047 | 5747 | 54 |
2007569 | 2007569 | 2021-12-12 | Williamsburg | South Carolina | 45089 | 5747 | 129 |
2004318 | 2004318 | 2021-12-11 | Williamsburg | South Carolina | 45089 | 5747 | 129 |
2001067 | 2001067 | 2021-12-10 | Williamsburg | South Carolina | 45089 | 5747 | 129 |
1997920 | 1997920 | 2021-12-09 | Hardin | Tennessee | 47071 | 5747 | 91 |
1994669 | 1994669 | 2021-12-08 | Hardin | Tennessee | 47071 | 5747 | 91 |
1982854 | 1982854 | 2021-12-05 | Pickens | Georgia | 13227 | 5747 | 120 |
1979604 | 1979604 | 2021-12-04 | Pickens | Georgia | 13227 | 5747 | 120 |
1976354 | 1976354 | 2021-12-03 | Pickens | Georgia | 13227 | 5747 | 120 |
1961990 | 1961990 | 2021-11-28 | Ponce | Puerto Rico | 72113 | 5747 | |
1958739 | 1958739 | 2021-11-27 | Ponce | Puerto Rico | 72113 | 5747 | |
1938585 | 1938585 | 2021-11-21 | Platte | Nebraska | 31141 | 5747 | 56 |
1935335 | 1935335 | 2021-11-20 | Platte | Nebraska | 31141 | 5747 | 56 |
1932085 | 1932085 | 2021-11-19 | Platte | Nebraska | 31141 | 5747 | 56 |
1895094 | 1895094 | 2021-11-08 | Oconee | Georgia | 13219 | 5747 | 82 |
1891844 | 1891844 | 2021-11-07 | Oconee | Georgia | 13219 | 5747 | 82 |
1888594 | 1888594 | 2021-11-06 | Oconee | Georgia | 13219 | 5747 | 82 |
1890497 | 1890497 | 2021-11-06 | Toa Alta | Puerto Rico | 72135 | 5747 | |
1885344 | 1885344 | 2021-11-05 | Oconee | Georgia | 13219 | 5747 | 82 |
1864966 | 1864966 | 2021-10-29 | Washington | Texas | 48477 | 5747 | 128 |
1853620 | 1853620 | 2021-10-26 | Delta | Michigan | 26041 | 5747 | 104 |
1850371 | 1850371 | 2021-10-25 | Delta | Michigan | 26041 | 5747 | 104 |
1829458 | 1829458 | 2021-10-18 | Whitman | Washington | 53075 | 5747 | 68 |
1807753 | 1807753 | 2021-10-12 | Unknown | Iowa | 5747 | 0 | |
1769954 | 1769954 | 2021-09-30 | Crawford | Ohio | 39033 | 5747 | 119 |
1722713 | 1722713 | 2021-09-16 | Baker | Florida | 12003 | 5747 | 90 |
1719464 | 1719464 | 2021-09-15 | Baker | Florida | 12003 | 5747 | 90 |
1716216 | 1716216 | 2021-09-14 | Baker | Florida | 12003 | 5747 | 90 |
1712970 | 1712970 | 2021-09-13 | Baker | Florida | 12003 | 5747 | 62 |
1709723 | 1709723 | 2021-09-12 | Baker | Florida | 12003 | 5747 | 62 |
1706476 | 1706476 | 2021-09-11 | Baker | Florida | 12003 | 5747 | 62 |
1703228 | 1703228 | 2021-09-10 | Baker | Florida | 12003 | 5747 | 62 |
1629337 | 1629337 | 2021-08-18 | Lincoln | Louisiana | 22061 | 5747 | 100 |
1599151 | 1599151 | 2021-08-09 | Humboldt | California | 6023 | 5747 | 56 |
1568567 | 1568567 | 2021-07-30 | Jefferson | Ohio | 39081 | 5747 | 162 |
1551399 | 1551399 | 2021-07-25 | St. Mary | Louisiana | 22101 | 5747 | 147 |
1548152 | 1548152 | 2021-07-24 | St. Mary | Louisiana | 22101 | 5747 | 147 |
1544905 | 1544905 | 2021-07-23 | St. Mary | Louisiana | 22101 | 5747 | 147 |
1461425 | 1461425 | 2021-06-27 | Lawrence | Ohio | 39087 | 5747 | 103 |
1458180 | 1458180 | 2021-06-26 | Lawrence | Ohio | 39087 | 5747 | 103 |
1426271 | 1426271 | 2021-06-16 | Caldwell | Texas | 48055 | 5747 | 99 |
1404074 | 1404074 | 2021-06-09 | Grant | Wisconsin | 55043 | 5747 | 93 |
1383329 | 1383329 | 2021-06-03 | Wayne | New York | 36117 | 5747 | 68 |
1365962 | 1365962 | 2021-05-29 | Noble | Indiana | 18113 | 5747 | 88 |
1297908 | 1297908 | 2021-05-08 | Warren | Iowa | 19181 | 5747 | 88 |
1291453 | 1291453 | 2021-05-06 | Ford | Kansas | 20057 | 5747 | 74 |
1288207 | 1288207 | 2021-05-05 | Ford | Kansas | 20057 | 5747 | 74 |
1280173 | 1280173 | 2021-05-02 | Atascosa | Texas | 48013 | 5747 | 150 |
1275635 | 1275635 | 2021-05-01 | Chisago | Minnesota | 27025 | 5747 | 51 |
1276926 | 1276926 | 2021-05-01 | Atascosa | Texas | 48013 | 5747 | 150 |
1211308 | 1211308 | 2021-04-11 | Lee | North Carolina | 37105 | 5747 | 75 |
1208059 | 1208059 | 2021-04-10 | Lee | North Carolina | 37105 | 5747 | 75 |
1204811 | 1204811 | 2021-04-09 | Lee | North Carolina | 37105 | 5747 | 75 |
1173780 | 1173780 | 2021-03-31 | Mississippi | Arkansas | 5093 | 5747 | 106 |
1156900 | 1156900 | 2021-03-25 | Lamar | Texas | 48277 | 5747 | 152 |
1153653 | 1153653 | 2021-03-24 | Lamar | Texas | 48277 | 5747 | 152 |
1091364 | 1091364 | 2021-03-05 | Carter | Oklahoma | 40019 | 5747 | 60 |
1087411 | 1087411 | 2021-03-04 | Lafayette | Mississippi | 28071 | 5747 | 113 |
1060363 | 1060363 | 2021-02-24 | Monroe | Florida | 12087 | 5747 | 46 |
1001928 | 1001928 | 2021-02-06 | Jackson | Florida | 12063 | 5747 | 134 |
1000093 | 1000093 | 2021-02-05 | Carson City | Nevada | 32510 | 5747 | 106 |
986369 | 986369 | 2021-02-01 | Christian | Kentucky | 21047 | 5747 | 74 |
971738 | 971738 | 2021-01-27 | Anderson | Texas | 48001 | 5747 | 86 |
959457 | 959457 | 2021-01-24 | Fairbanks North Star Borough | Alaska | 2090 | 5747 | 25 |
870818 | 870818 | 2020-12-27 | Monroe | Pennsylvania | 42089 | 5747 | 193 |
824244 | 824244 | 2020-12-13 | St. Landry | Louisiana | 22097 | 5747 | 180 |
810265 | 810265 | 2020-12-09 | Saline | Arkansas | 5125 | 5747 | 68 |
692472 | 692472 | 2020-11-02 | Florence | South Carolina | 45041 | 5747 | 203 |
553951 | 553951 | 2020-09-21 | Navajo | Arizona | 4017 | 5747 | 232 |
531682 | 531682 | 2020-09-14 | Muscogee | Georgia | 13215 | 5747 | 159 |
434444 | 434444 | 2020-08-15 | Marin | California | 6041 | 5747 | 82 |
401857 | 401857 | 2020-08-04 | Pierce | Washington | 53053 | 5747 | 138 |
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);