ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
31 rows where cases = 10323 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2353959 | 2353959 | 2022-03-29 | Webster | Iowa | 19187 | 10323 | 161 |
2350707 | 2350707 | 2022-03-28 | Webster | Iowa | 19187 | 10323 | 161 |
2347454 | 2347454 | 2022-03-27 | Webster | Iowa | 19187 | 10323 | 161 |
2344201 | 2344201 | 2022-03-26 | Webster | Iowa | 19187 | 10323 | 161 |
2340948 | 2340948 | 2022-03-25 | Webster | Iowa | 19187 | 10323 | 161 |
2337508 | 2337508 | 2022-03-24 | Woodford | Illinois | 17203 | 10323 | 124 |
2337695 | 2337695 | 2022-03-24 | Webster | Iowa | 19187 | 10323 | 161 |
2334441 | 2334441 | 2022-03-23 | Webster | Iowa | 19187 | 10323 | 161 |
2285996 | 2285996 | 2022-03-08 | Franklin | Massachusetts | 25011 | 10323 | 170 |
2234829 | 2234829 | 2022-02-20 | Guernsey | Ohio | 39059 | 10323 | 140 |
2221197 | 2221197 | 2022-02-16 | Neshoba | Mississippi | 28099 | 10323 | 227 |
2208623 | 2208623 | 2022-02-12 | Tioga | New York | 36107 | 10323 | 81 |
2187962 | 2187962 | 2022-02-06 | Montgomery | Indiana | 18107 | 10323 | 153 |
2184709 | 2184709 | 2022-02-05 | Montgomery | Indiana | 18107 | 10323 | 153 |
2181457 | 2181457 | 2022-02-04 | Montgomery | Indiana | 18107 | 10323 | 153 |
2018819 | 2018819 | 2021-12-16 | Boone | Indiana | 18011 | 10323 | 136 |
1946284 | 1946284 | 2021-11-23 | Bedford | Virginia | 51019 | 10323 | 162 |
1928272 | 1928272 | 2021-11-18 | Vermilion | Louisiana | 22113 | 10323 | 192 |
1905426 | 1905426 | 2021-11-11 | McCracken | Kentucky | 21145 | 10323 | 180 |
1902176 | 1902176 | 2021-11-10 | McCracken | Kentucky | 21145 | 10323 | 180 |
1742679 | 1742679 | 2021-09-22 | Wayne | Indiana | 18177 | 10323 | 231 |
1673613 | 1673613 | 2021-08-31 | Ozaukee | Wisconsin | 55089 | 10323 | 111 |
1556744 | 1556744 | 2021-07-27 | Cullman | Alabama | 1043 | 10323 | 204 |
1540281 | 1540281 | 2021-07-21 | Spotsylvania | Virginia | 51177 | 10323 | 125 |
1470516 | 1470516 | 2021-06-30 | Madison | Mississippi | 28089 | 10323 | 227 |
1217242 | 1217242 | 2021-04-13 | Sherburne | Minnesota | 27141 | 10323 | 79 |
936586 | 936586 | 2021-01-16 | Eau Claire | Wisconsin | 55035 | 10323 | 103 |
814103 | 814103 | 2020-12-10 | Porter | Indiana | 18127 | 10323 | 116 |
754299 | 754299 | 2020-11-21 | Williamson | Tennessee | 47187 | 10323 | 72 |
284274 | 284274 | 2020-06-29 | Hillsborough | Florida | 12057 | 10323 | 135 |
244562 | 244562 | 2020-06-16 | Hennepin | Minnesota | 27053 | 10323 | 724 |
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);