ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where county = "Pike" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386609 | 386609 | 2020-07-31 | Pike | Illinois | 17149 | 13 | 0 |
383391 | 383391 | 2020-07-30 | Pike | Illinois | 17149 | 12 | 0 |
380174 | 380174 | 2020-07-29 | Pike | Illinois | 17149 | 11 | 0 |
376957 | 376957 | 2020-07-28 | Pike | Illinois | 17149 | 11 | 0 |
373742 | 373742 | 2020-07-27 | Pike | Illinois | 17149 | 11 | 0 |
370530 | 370530 | 2020-07-26 | Pike | Illinois | 17149 | 11 | 0 |
367320 | 367320 | 2020-07-25 | Pike | Illinois | 17149 | 10 | 0 |
364113 | 364113 | 2020-07-24 | Pike | Illinois | 17149 | 9 | 0 |
360906 | 360906 | 2020-07-23 | Pike | Illinois | 17149 | 9 | 0 |
357701 | 357701 | 2020-07-22 | Pike | Illinois | 17149 | 9 | 0 |
354499 | 354499 | 2020-07-21 | Pike | Illinois | 17149 | 9 | 0 |
351297 | 351297 | 2020-07-20 | Pike | Illinois | 17149 | 9 | 0 |
348097 | 348097 | 2020-07-19 | Pike | Illinois | 17149 | 9 | 0 |
344896 | 344896 | 2020-07-18 | Pike | Illinois | 17149 | 9 | 0 |
341696 | 341696 | 2020-07-17 | Pike | Illinois | 17149 | 9 | 0 |
338500 | 338500 | 2020-07-16 | Pike | Illinois | 17149 | 9 | 0 |
335304 | 335304 | 2020-07-15 | Pike | Illinois | 17149 | 8 | 0 |
332111 | 332111 | 2020-07-14 | Pike | Illinois | 17149 | 8 | 0 |
328924 | 328924 | 2020-07-13 | Pike | Illinois | 17149 | 8 | 0 |
325738 | 325738 | 2020-07-12 | Pike | Illinois | 17149 | 7 | 0 |
322557 | 322557 | 2020-07-11 | Pike | Illinois | 17149 | 6 | 0 |
319378 | 319378 | 2020-07-10 | Pike | Illinois | 17149 | 6 | 0 |
316205 | 316205 | 2020-07-09 | Pike | Illinois | 17149 | 5 | 0 |
313031 | 313031 | 2020-07-08 | Pike | Illinois | 17149 | 5 | 0 |
309861 | 309861 | 2020-07-07 | Pike | Illinois | 17149 | 4 | 0 |
306693 | 306693 | 2020-07-06 | Pike | Illinois | 17149 | 3 | 0 |
303528 | 303528 | 2020-07-05 | Pike | Illinois | 17149 | 3 | 0 |
300364 | 300364 | 2020-07-04 | Pike | Illinois | 17149 | 3 | 0 |
297202 | 297202 | 2020-07-03 | Pike | Illinois | 17149 | 3 | 0 |
294045 | 294045 | 2020-07-02 | Pike | Illinois | 17149 | 3 | 0 |
290891 | 290891 | 2020-07-01 | Pike | Illinois | 17149 | 2 | 0 |
287741 | 287741 | 2020-06-30 | Pike | Illinois | 17149 | 2 | 0 |
284592 | 284592 | 2020-06-29 | Pike | Illinois | 17149 | 2 | 0 |
281447 | 281447 | 2020-06-28 | Pike | Illinois | 17149 | 2 | 0 |
278299 | 278299 | 2020-06-27 | Pike | Illinois | 17149 | 2 | 0 |
275151 | 275151 | 2020-06-26 | Pike | Illinois | 17149 | 2 | 0 |
272009 | 272009 | 2020-06-25 | Pike | Illinois | 17149 | 2 | 0 |
268872 | 268872 | 2020-06-24 | Pike | Illinois | 17149 | 2 | 0 |
265742 | 265742 | 2020-06-23 | Pike | Illinois | 17149 | 2 | 0 |
262614 | 262614 | 2020-06-22 | Pike | Illinois | 17149 | 2 | 0 |
259487 | 259487 | 2020-06-21 | Pike | Illinois | 17149 | 2 | 0 |
256361 | 256361 | 2020-06-20 | Pike | Illinois | 17149 | 2 | 0 |
253241 | 253241 | 2020-06-19 | Pike | Illinois | 17149 | 2 | 0 |
250126 | 250126 | 2020-06-18 | Pike | Illinois | 17149 | 2 | 0 |
247014 | 247014 | 2020-06-17 | Pike | Illinois | 17149 | 2 | 0 |
243901 | 243901 | 2020-06-16 | Pike | Illinois | 17149 | 2 | 0 |
240790 | 240790 | 2020-06-15 | Pike | Illinois | 17149 | 2 | 0 |
237682 | 237682 | 2020-06-14 | Pike | Illinois | 17149 | 2 | 0 |
234575 | 234575 | 2020-06-13 | Pike | Illinois | 17149 | 2 | 0 |
231469 | 231469 | 2020-06-12 | Pike | Illinois | 17149 | 2 | 0 |
228366 | 228366 | 2020-06-11 | Pike | Illinois | 17149 | 1 | 0 |
225264 | 225264 | 2020-06-10 | Pike | Illinois | 17149 | 1 | 0 |
222169 | 222169 | 2020-06-09 | Pike | Illinois | 17149 | 1 | 0 |
219074 | 219074 | 2020-06-08 | Pike | Illinois | 17149 | 1 | 0 |
215983 | 215983 | 2020-06-07 | Pike | Illinois | 17149 | 1 | 0 |
212896 | 212896 | 2020-06-06 | Pike | Illinois | 17149 | 1 | 0 |
209811 | 209811 | 2020-06-05 | Pike | Illinois | 17149 | 1 | 0 |
206730 | 206730 | 2020-06-04 | Pike | Illinois | 17149 | 1 | 0 |
203650 | 203650 | 2020-06-03 | Pike | Illinois | 17149 | 1 | 0 |
200574 | 200574 | 2020-06-02 | Pike | Illinois | 17149 | 1 | 0 |
197501 | 197501 | 2020-06-01 | Pike | Illinois | 17149 | 1 | 0 |
194431 | 194431 | 2020-05-31 | Pike | Illinois | 17149 | 1 | 0 |
191364 | 191364 | 2020-05-30 | Pike | Illinois | 17149 | 1 | 0 |
188299 | 188299 | 2020-05-29 | Pike | Illinois | 17149 | 1 | 0 |
185241 | 185241 | 2020-05-28 | Pike | Illinois | 17149 | 1 | 0 |
182187 | 182187 | 2020-05-27 | Pike | Illinois | 17149 | 1 | 0 |
179143 | 179143 | 2020-05-26 | Pike | Illinois | 17149 | 1 | 0 |
176099 | 176099 | 2020-05-25 | Pike | Illinois | 17149 | 1 | 0 |
173055 | 173055 | 2020-05-24 | Pike | Illinois | 17149 | 1 | 0 |
170014 | 170014 | 2020-05-23 | Pike | Illinois | 17149 | 1 | 0 |
166977 | 166977 | 2020-05-22 | Pike | Illinois | 17149 | 1 | 0 |
163944 | 163944 | 2020-05-21 | Pike | Illinois | 17149 | 1 | 0 |
160916 | 160916 | 2020-05-20 | Pike | Illinois | 17149 | 1 | 0 |
157890 | 157890 | 2020-05-19 | Pike | Illinois | 17149 | 1 | 0 |
154874 | 154874 | 2020-05-18 | Pike | Illinois | 17149 | 1 | 0 |
151862 | 151862 | 2020-05-17 | Pike | Illinois | 17149 | 1 | 0 |
148853 | 148853 | 2020-05-16 | Pike | Illinois | 17149 | 1 | 0 |
145850 | 145850 | 2020-05-15 | Pike | Illinois | 17149 | 1 | 0 |
142850 | 142850 | 2020-05-14 | Pike | Illinois | 17149 | 1 | 0 |
139854 | 139854 | 2020-05-13 | Pike | Illinois | 17149 | 1 | 0 |
136862 | 136862 | 2020-05-12 | Pike | Illinois | 17149 | 1 | 0 |
133873 | 133873 | 2020-05-11 | Pike | Illinois | 17149 | 1 | 0 |
130882 | 130882 | 2020-05-10 | Pike | Illinois | 17149 | 1 | 0 |
127891 | 127891 | 2020-05-09 | Pike | Illinois | 17149 | 1 | 0 |
124904 | 124904 | 2020-05-08 | Pike | Illinois | 17149 | 1 | 0 |
121925 | 121925 | 2020-05-07 | Pike | Illinois | 17149 | 1 | 0 |
118955 | 118955 | 2020-05-06 | Pike | Illinois | 17149 | 1 | 0 |
115995 | 115995 | 2020-05-05 | Pike | Illinois | 17149 | 1 | 0 |
113112 | 113112 | 2020-05-04 | Pike | Illinois | 17149 | 1 | 0 |
110237 | 110237 | 2020-05-03 | Pike | Illinois | 17149 | 1 | 0 |
107367 | 107367 | 2020-05-02 | Pike | Illinois | 17149 | 1 | 0 |
104502 | 104502 | 2020-05-01 | Pike | Illinois | 17149 | 1 | 0 |
101646 | 101646 | 2020-04-30 | Pike | Illinois | 17149 | 1 | 0 |
98795 | 98795 | 2020-04-29 | Pike | Illinois | 17149 | 1 | 0 |
95951 | 95951 | 2020-04-28 | Pike | Illinois | 17149 | 1 | 0 |
93119 | 93119 | 2020-04-27 | Pike | Illinois | 17149 | 1 | 0 |
90300 | 90300 | 2020-04-26 | Pike | Illinois | 17149 | 1 | 0 |
87484 | 87484 | 2020-04-25 | Pike | Illinois | 17149 | 1 | 0 |
84674 | 84674 | 2020-04-24 | Pike | Illinois | 17149 | 1 | 0 |
81874 | 81874 | 2020-04-23 | Pike | Illinois | 17149 | 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);