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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
31328 | 31328 | 2020-04-04 | Pike | Illinois | 17149 | 1 | 0 |
33738 | 33738 | 2020-04-05 | Pike | Illinois | 17149 | 1 | 0 |
36190 | 36190 | 2020-04-06 | Pike | Illinois | 17149 | 1 | 0 |
38686 | 38686 | 2020-04-07 | Pike | Illinois | 17149 | 1 | 0 |
41231 | 41231 | 2020-04-08 | Pike | Illinois | 17149 | 1 | 0 |
43805 | 43805 | 2020-04-09 | Pike | Illinois | 17149 | 1 | 0 |
46409 | 46409 | 2020-04-10 | Pike | Illinois | 17149 | 1 | 0 |
49042 | 49042 | 2020-04-11 | Pike | Illinois | 17149 | 1 | 0 |
51704 | 51704 | 2020-04-12 | Pike | Illinois | 17149 | 1 | 0 |
54385 | 54385 | 2020-04-13 | Pike | Illinois | 17149 | 1 | 0 |
57078 | 57078 | 2020-04-14 | Pike | Illinois | 17149 | 1 | 0 |
59785 | 59785 | 2020-04-15 | Pike | Illinois | 17149 | 1 | 0 |
62506 | 62506 | 2020-04-16 | Pike | Illinois | 17149 | 1 | 0 |
65239 | 65239 | 2020-04-17 | Pike | Illinois | 17149 | 1 | 0 |
67988 | 67988 | 2020-04-18 | Pike | Illinois | 17149 | 1 | 0 |
70750 | 70750 | 2020-04-19 | Pike | Illinois | 17149 | 1 | 0 |
73520 | 73520 | 2020-04-20 | Pike | Illinois | 17149 | 1 | 0 |
76297 | 76297 | 2020-04-21 | Pike | Illinois | 17149 | 1 | 0 |
79081 | 79081 | 2020-04-22 | Pike | Illinois | 17149 | 1 | 0 |
81874 | 81874 | 2020-04-23 | Pike | Illinois | 17149 | 1 | 0 |
84674 | 84674 | 2020-04-24 | Pike | Illinois | 17149 | 1 | 0 |
87484 | 87484 | 2020-04-25 | Pike | Illinois | 17149 | 1 | 0 |
90300 | 90300 | 2020-04-26 | Pike | Illinois | 17149 | 1 | 0 |
93119 | 93119 | 2020-04-27 | Pike | Illinois | 17149 | 1 | 0 |
95951 | 95951 | 2020-04-28 | Pike | Illinois | 17149 | 1 | 0 |
98795 | 98795 | 2020-04-29 | Pike | Illinois | 17149 | 1 | 0 |
101646 | 101646 | 2020-04-30 | Pike | Illinois | 17149 | 1 | 0 |
104502 | 104502 | 2020-05-01 | Pike | Illinois | 17149 | 1 | 0 |
107367 | 107367 | 2020-05-02 | Pike | Illinois | 17149 | 1 | 0 |
110237 | 110237 | 2020-05-03 | Pike | Illinois | 17149 | 1 | 0 |
113112 | 113112 | 2020-05-04 | Pike | Illinois | 17149 | 1 | 0 |
115995 | 115995 | 2020-05-05 | Pike | Illinois | 17149 | 1 | 0 |
118955 | 118955 | 2020-05-06 | Pike | Illinois | 17149 | 1 | 0 |
121925 | 121925 | 2020-05-07 | Pike | Illinois | 17149 | 1 | 0 |
124904 | 124904 | 2020-05-08 | Pike | Illinois | 17149 | 1 | 0 |
127891 | 127891 | 2020-05-09 | Pike | Illinois | 17149 | 1 | 0 |
130882 | 130882 | 2020-05-10 | Pike | Illinois | 17149 | 1 | 0 |
133873 | 133873 | 2020-05-11 | Pike | Illinois | 17149 | 1 | 0 |
136862 | 136862 | 2020-05-12 | Pike | Illinois | 17149 | 1 | 0 |
139854 | 139854 | 2020-05-13 | Pike | Illinois | 17149 | 1 | 0 |
142850 | 142850 | 2020-05-14 | Pike | Illinois | 17149 | 1 | 0 |
145850 | 145850 | 2020-05-15 | Pike | Illinois | 17149 | 1 | 0 |
148853 | 148853 | 2020-05-16 | Pike | Illinois | 17149 | 1 | 0 |
151862 | 151862 | 2020-05-17 | Pike | Illinois | 17149 | 1 | 0 |
154874 | 154874 | 2020-05-18 | Pike | Illinois | 17149 | 1 | 0 |
157890 | 157890 | 2020-05-19 | Pike | Illinois | 17149 | 1 | 0 |
160916 | 160916 | 2020-05-20 | Pike | Illinois | 17149 | 1 | 0 |
163944 | 163944 | 2020-05-21 | Pike | Illinois | 17149 | 1 | 0 |
166977 | 166977 | 2020-05-22 | Pike | Illinois | 17149 | 1 | 0 |
170014 | 170014 | 2020-05-23 | Pike | Illinois | 17149 | 1 | 0 |
173055 | 173055 | 2020-05-24 | Pike | Illinois | 17149 | 1 | 0 |
176099 | 176099 | 2020-05-25 | Pike | Illinois | 17149 | 1 | 0 |
179143 | 179143 | 2020-05-26 | Pike | Illinois | 17149 | 1 | 0 |
182187 | 182187 | 2020-05-27 | Pike | Illinois | 17149 | 1 | 0 |
185241 | 185241 | 2020-05-28 | Pike | Illinois | 17149 | 1 | 0 |
188299 | 188299 | 2020-05-29 | Pike | Illinois | 17149 | 1 | 0 |
191364 | 191364 | 2020-05-30 | Pike | Illinois | 17149 | 1 | 0 |
194431 | 194431 | 2020-05-31 | Pike | Illinois | 17149 | 1 | 0 |
197501 | 197501 | 2020-06-01 | Pike | Illinois | 17149 | 1 | 0 |
200574 | 200574 | 2020-06-02 | Pike | Illinois | 17149 | 1 | 0 |
203650 | 203650 | 2020-06-03 | Pike | Illinois | 17149 | 1 | 0 |
206730 | 206730 | 2020-06-04 | Pike | Illinois | 17149 | 1 | 0 |
209811 | 209811 | 2020-06-05 | Pike | Illinois | 17149 | 1 | 0 |
212896 | 212896 | 2020-06-06 | Pike | Illinois | 17149 | 1 | 0 |
215983 | 215983 | 2020-06-07 | Pike | Illinois | 17149 | 1 | 0 |
219074 | 219074 | 2020-06-08 | Pike | Illinois | 17149 | 1 | 0 |
222169 | 222169 | 2020-06-09 | Pike | Illinois | 17149 | 1 | 0 |
225264 | 225264 | 2020-06-10 | Pike | Illinois | 17149 | 1 | 0 |
228366 | 228366 | 2020-06-11 | Pike | Illinois | 17149 | 1 | 0 |
231469 | 231469 | 2020-06-12 | Pike | Illinois | 17149 | 2 | 0 |
234575 | 234575 | 2020-06-13 | Pike | Illinois | 17149 | 2 | 0 |
237682 | 237682 | 2020-06-14 | Pike | Illinois | 17149 | 2 | 0 |
240790 | 240790 | 2020-06-15 | Pike | Illinois | 17149 | 2 | 0 |
243901 | 243901 | 2020-06-16 | Pike | Illinois | 17149 | 2 | 0 |
247014 | 247014 | 2020-06-17 | Pike | Illinois | 17149 | 2 | 0 |
250126 | 250126 | 2020-06-18 | Pike | Illinois | 17149 | 2 | 0 |
253241 | 253241 | 2020-06-19 | Pike | Illinois | 17149 | 2 | 0 |
256361 | 256361 | 2020-06-20 | Pike | Illinois | 17149 | 2 | 0 |
259487 | 259487 | 2020-06-21 | Pike | Illinois | 17149 | 2 | 0 |
262614 | 262614 | 2020-06-22 | Pike | Illinois | 17149 | 2 | 0 |
265742 | 265742 | 2020-06-23 | Pike | Illinois | 17149 | 2 | 0 |
268872 | 268872 | 2020-06-24 | Pike | Illinois | 17149 | 2 | 0 |
272009 | 272009 | 2020-06-25 | Pike | Illinois | 17149 | 2 | 0 |
275151 | 275151 | 2020-06-26 | Pike | Illinois | 17149 | 2 | 0 |
278299 | 278299 | 2020-06-27 | Pike | Illinois | 17149 | 2 | 0 |
281447 | 281447 | 2020-06-28 | Pike | Illinois | 17149 | 2 | 0 |
284592 | 284592 | 2020-06-29 | Pike | Illinois | 17149 | 2 | 0 |
287741 | 287741 | 2020-06-30 | Pike | Illinois | 17149 | 2 | 0 |
290891 | 290891 | 2020-07-01 | Pike | Illinois | 17149 | 2 | 0 |
294045 | 294045 | 2020-07-02 | Pike | Illinois | 17149 | 3 | 0 |
297202 | 297202 | 2020-07-03 | Pike | Illinois | 17149 | 3 | 0 |
300364 | 300364 | 2020-07-04 | Pike | Illinois | 17149 | 3 | 0 |
303528 | 303528 | 2020-07-05 | Pike | Illinois | 17149 | 3 | 0 |
306693 | 306693 | 2020-07-06 | Pike | Illinois | 17149 | 3 | 0 |
309861 | 309861 | 2020-07-07 | Pike | Illinois | 17149 | 4 | 0 |
313031 | 313031 | 2020-07-08 | Pike | Illinois | 17149 | 5 | 0 |
316205 | 316205 | 2020-07-09 | Pike | Illinois | 17149 | 5 | 0 |
319378 | 319378 | 2020-07-10 | Pike | Illinois | 17149 | 6 | 0 |
322557 | 322557 | 2020-07-11 | Pike | Illinois | 17149 | 6 | 0 |
325738 | 325738 | 2020-07-12 | Pike | Illinois | 17149 | 7 | 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);