ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
68 rows where cases = 1, county = "Pope" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
332112 | 332112 | 2020-07-14 | Pope | Illinois | 17151 | 1 | 0 |
328925 | 328925 | 2020-07-13 | Pope | Illinois | 17151 | 1 | 0 |
325739 | 325739 | 2020-07-12 | Pope | Illinois | 17151 | 1 | 0 |
322558 | 322558 | 2020-07-11 | Pope | Illinois | 17151 | 1 | 0 |
319379 | 319379 | 2020-07-10 | Pope | Illinois | 17151 | 1 | 0 |
316206 | 316206 | 2020-07-09 | Pope | Illinois | 17151 | 1 | 0 |
313032 | 313032 | 2020-07-08 | Pope | Illinois | 17151 | 1 | 0 |
309862 | 309862 | 2020-07-07 | Pope | Illinois | 17151 | 1 | 0 |
306694 | 306694 | 2020-07-06 | Pope | Illinois | 17151 | 1 | 0 |
303529 | 303529 | 2020-07-05 | Pope | Illinois | 17151 | 1 | 0 |
300365 | 300365 | 2020-07-04 | Pope | Illinois | 17151 | 1 | 0 |
297203 | 297203 | 2020-07-03 | Pope | Illinois | 17151 | 1 | 0 |
294046 | 294046 | 2020-07-02 | Pope | Illinois | 17151 | 1 | 0 |
290892 | 290892 | 2020-07-01 | Pope | Illinois | 17151 | 1 | 0 |
287742 | 287742 | 2020-06-30 | Pope | Illinois | 17151 | 1 | 0 |
284593 | 284593 | 2020-06-29 | Pope | Illinois | 17151 | 1 | 0 |
281448 | 281448 | 2020-06-28 | Pope | Illinois | 17151 | 1 | 0 |
278300 | 278300 | 2020-06-27 | Pope | Illinois | 17151 | 1 | 0 |
275152 | 275152 | 2020-06-26 | Pope | Illinois | 17151 | 1 | 0 |
272010 | 272010 | 2020-06-25 | Pope | Illinois | 17151 | 1 | 0 |
268873 | 268873 | 2020-06-24 | Pope | Illinois | 17151 | 1 | 0 |
265743 | 265743 | 2020-06-23 | Pope | Illinois | 17151 | 1 | 0 |
262615 | 262615 | 2020-06-22 | Pope | Illinois | 17151 | 1 | 0 |
259488 | 259488 | 2020-06-21 | Pope | Illinois | 17151 | 1 | 0 |
256362 | 256362 | 2020-06-20 | Pope | Illinois | 17151 | 1 | 0 |
253242 | 253242 | 2020-06-19 | Pope | Illinois | 17151 | 1 | 0 |
250127 | 250127 | 2020-06-18 | Pope | Illinois | 17151 | 1 | 0 |
247015 | 247015 | 2020-06-17 | Pope | Illinois | 17151 | 1 | 0 |
243902 | 243902 | 2020-06-16 | Pope | Illinois | 17151 | 1 | 0 |
240791 | 240791 | 2020-06-15 | Pope | Illinois | 17151 | 1 | 0 |
237683 | 237683 | 2020-06-14 | Pope | Illinois | 17151 | 1 | 0 |
234576 | 234576 | 2020-06-13 | Pope | Illinois | 17151 | 1 | 0 |
231470 | 231470 | 2020-06-12 | Pope | Illinois | 17151 | 1 | 0 |
228367 | 228367 | 2020-06-11 | Pope | Illinois | 17151 | 1 | 0 |
225265 | 225265 | 2020-06-10 | Pope | Illinois | 17151 | 1 | 0 |
222170 | 222170 | 2020-06-09 | Pope | Illinois | 17151 | 1 | 0 |
219075 | 219075 | 2020-06-08 | Pope | Illinois | 17151 | 1 | 0 |
215984 | 215984 | 2020-06-07 | Pope | Illinois | 17151 | 1 | 0 |
212897 | 212897 | 2020-06-06 | Pope | Illinois | 17151 | 1 | 0 |
209812 | 209812 | 2020-06-05 | Pope | Illinois | 17151 | 1 | 0 |
206731 | 206731 | 2020-06-04 | Pope | Illinois | 17151 | 1 | 0 |
203651 | 203651 | 2020-06-03 | Pope | Illinois | 17151 | 1 | 0 |
200575 | 200575 | 2020-06-02 | Pope | Illinois | 17151 | 1 | 0 |
197502 | 197502 | 2020-06-01 | Pope | Illinois | 17151 | 1 | 0 |
194432 | 194432 | 2020-05-31 | Pope | Illinois | 17151 | 1 | 0 |
191365 | 191365 | 2020-05-30 | Pope | Illinois | 17151 | 1 | 0 |
188300 | 188300 | 2020-05-29 | Pope | Illinois | 17151 | 1 | 0 |
185242 | 185242 | 2020-05-28 | Pope | Illinois | 17151 | 1 | 0 |
182188 | 182188 | 2020-05-27 | Pope | Illinois | 17151 | 1 | 0 |
179144 | 179144 | 2020-05-26 | Pope | Illinois | 17151 | 1 | 0 |
176100 | 176100 | 2020-05-25 | Pope | Illinois | 17151 | 1 | 0 |
173056 | 173056 | 2020-05-24 | Pope | Illinois | 17151 | 1 | 0 |
170015 | 170015 | 2020-05-23 | Pope | Illinois | 17151 | 1 | 0 |
166978 | 166978 | 2020-05-22 | Pope | Illinois | 17151 | 1 | 0 |
163945 | 163945 | 2020-05-21 | Pope | Illinois | 17151 | 1 | 0 |
160917 | 160917 | 2020-05-20 | Pope | Illinois | 17151 | 1 | 0 |
157891 | 157891 | 2020-05-19 | Pope | Illinois | 17151 | 1 | 0 |
154875 | 154875 | 2020-05-18 | Pope | Illinois | 17151 | 1 | 0 |
151863 | 151863 | 2020-05-17 | Pope | Illinois | 17151 | 1 | 0 |
148854 | 148854 | 2020-05-16 | Pope | Illinois | 17151 | 1 | 0 |
145851 | 145851 | 2020-05-15 | Pope | Illinois | 17151 | 1 | 0 |
142851 | 142851 | 2020-05-14 | Pope | Illinois | 17151 | 1 | 0 |
139855 | 139855 | 2020-05-13 | Pope | Illinois | 17151 | 1 | 0 |
136863 | 136863 | 2020-05-12 | Pope | Illinois | 17151 | 1 | 0 |
133874 | 133874 | 2020-05-11 | Pope | Illinois | 17151 | 1 | 0 |
130883 | 130883 | 2020-05-10 | Pope | Illinois | 17151 | 1 | 0 |
127892 | 127892 | 2020-05-09 | Pope | Illinois | 17151 | 1 | 0 |
124905 | 124905 | 2020-05-08 | Pope | Illinois | 17151 | 1 | 0 |
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);