ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where cases = 11339 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 18
- Indiana 5
- Louisiana 4
- Michigan 4
- North Carolina 4
- Georgia 3
- Mississippi 3
- Ohio 2
- Tennessee 2
- Texas 2
- Arkansas 1
- Colorado 1
- Connecticut 1
- District of Columbia 1
- Iowa 1
- Maine 1
- New York 1
- South Carolina 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2471422 | 2471422 | 2022-05-04 | St. Bernard | Louisiana | 22087 | 11339 | 111 |
2370054 | 2370054 | 2022-04-03 | DeKalb | Indiana | 18033 | 11339 | 149 |
2366801 | 2366801 | 2022-04-02 | DeKalb | Indiana | 18033 | 11339 | 149 |
2363548 | 2363548 | 2022-04-01 | DeKalb | Indiana | 18033 | 11339 | 149 |
2194837 | 2194837 | 2022-02-08 | Avoyelles | Louisiana | 22009 | 11339 | 191 |
2188642 | 2188642 | 2022-02-06 | Hancock | Mississippi | 28045 | 11339 | 145 |
2185389 | 2185389 | 2022-02-05 | Hancock | Mississippi | 28045 | 11339 | 145 |
2186020 | 2186020 | 2022-02-05 | Auglaize | Ohio | 39011 | 11339 | 163 |
2182137 | 2182137 | 2022-02-04 | Hancock | Mississippi | 28045 | 11339 | 145 |
2149336 | 2149336 | 2022-01-25 | St. Martin | Louisiana | 22099 | 11339 | 168 |
2030604 | 2030604 | 2021-12-19 | Hunt | Texas | 48231 | 11339 | 314 |
1870455 | 1870455 | 2021-10-31 | Chemung | New York | 36015 | 11339 | 164 |
1852671 | 1852671 | 2021-10-26 | Tolland | Connecticut | 9013 | 11339 | 198 |
1847843 | 1847843 | 2021-10-24 | Rutherford | North Carolina | 37161 | 11339 | 308 |
1844593 | 1844593 | 2021-10-23 | Rutherford | North Carolina | 37161 | 11339 | 308 |
1841343 | 1841343 | 2021-10-22 | Rutherford | North Carolina | 37161 | 11339 | 308 |
1719577 | 1719577 | 2021-09-15 | Dougherty | Georgia | 13095 | 11339 | 354 |
1695076 | 1695076 | 2021-09-07 | Caldwell | North Carolina | 37027 | 11339 | 111 |
1577454 | 1577454 | 2021-08-02 | Allegan | Michigan | 26005 | 11339 | 162 |
1574206 | 1574206 | 2021-08-01 | Allegan | Michigan | 26005 | 11339 | 162 |
1570958 | 1570958 | 2021-07-31 | Allegan | Michigan | 26005 | 11339 | 162 |
1567710 | 1567710 | 2021-07-30 | Allegan | Michigan | 26005 | 11339 | 162 |
1474971 | 1474971 | 2021-07-01 | Comal | Texas | 48091 | 11339 | 325 |
1283388 | 1283388 | 2021-05-03 | Putnam | Tennessee | 47141 | 11339 | 174 |
1219849 | 1219849 | 2021-04-14 | Monroe | Indiana | 18105 | 11339 | 168 |
1207304 | 1207304 | 2021-04-10 | York | Maine | 23031 | 11339 | 127 |
1111900 | 1111900 | 2021-03-11 | Walworth | Wisconsin | 55127 | 11339 | 150 |
1100107 | 1100107 | 2021-03-08 | Rapides | Louisiana | 22079 | 11339 | 296 |
1060169 | 1060169 | 2021-02-24 | Saline | Arkansas | 5125 | 11339 | 163 |
1049159 | 1049159 | 2021-02-20 | Wood | Ohio | 39173 | 11339 | 190 |
979279 | 979279 | 2021-01-30 | Coweta | Georgia | 13077 | 11339 | 116 |
929348 | 929348 | 2021-01-14 | Beaufort | South Carolina | 45013 | 11339 | 121 |
895322 | 895322 | 2021-01-04 | Johnson | Iowa | 19103 | 11339 | 47 |
872303 | 872303 | 2020-12-28 | Whitfield | Georgia | 13313 | 11339 | 116 |
854908 | 854908 | 2020-12-22 | Wilson | Tennessee | 47189 | 11339 | 115 |
700544 | 700544 | 2020-11-05 | St. Joseph | Indiana | 18141 | 11339 | 193 |
492634 | 492634 | 2020-09-02 | Denver | Colorado | 8031 | 11339 | 434 |
350947 | 350947 | 2020-07-20 | District of Columbia | District of Columbia | 11001 | 11339 | 579 |
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);