ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Douglas" and fips = 17041 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386555 | 386555 | 2020-07-31 | Douglas | Illinois | 17041 | 103 | 2 |
383337 | 383337 | 2020-07-30 | Douglas | Illinois | 17041 | 103 | 2 |
380120 | 380120 | 2020-07-29 | Douglas | Illinois | 17041 | 103 | 2 |
376903 | 376903 | 2020-07-28 | Douglas | Illinois | 17041 | 101 | 2 |
373688 | 373688 | 2020-07-27 | Douglas | Illinois | 17041 | 96 | 1 |
370476 | 370476 | 2020-07-26 | Douglas | Illinois | 17041 | 94 | 1 |
367266 | 367266 | 2020-07-25 | Douglas | Illinois | 17041 | 92 | 1 |
364059 | 364059 | 2020-07-24 | Douglas | Illinois | 17041 | 92 | 1 |
360852 | 360852 | 2020-07-23 | Douglas | Illinois | 17041 | 92 | 1 |
357647 | 357647 | 2020-07-22 | Douglas | Illinois | 17041 | 89 | 0 |
354445 | 354445 | 2020-07-21 | Douglas | Illinois | 17041 | 84 | 0 |
351243 | 351243 | 2020-07-20 | Douglas | Illinois | 17041 | 80 | 0 |
348043 | 348043 | 2020-07-19 | Douglas | Illinois | 17041 | 76 | 0 |
344842 | 344842 | 2020-07-18 | Douglas | Illinois | 17041 | 74 | 0 |
341642 | 341642 | 2020-07-17 | Douglas | Illinois | 17041 | 71 | 0 |
338446 | 338446 | 2020-07-16 | Douglas | Illinois | 17041 | 66 | 0 |
335250 | 335250 | 2020-07-15 | Douglas | Illinois | 17041 | 62 | 0 |
332057 | 332057 | 2020-07-14 | Douglas | Illinois | 17041 | 61 | 0 |
328870 | 328870 | 2020-07-13 | Douglas | Illinois | 17041 | 61 | 0 |
325684 | 325684 | 2020-07-12 | Douglas | Illinois | 17041 | 61 | 0 |
322503 | 322503 | 2020-07-11 | Douglas | Illinois | 17041 | 61 | 0 |
319324 | 319324 | 2020-07-10 | Douglas | Illinois | 17041 | 55 | 0 |
316151 | 316151 | 2020-07-09 | Douglas | Illinois | 17041 | 55 | 0 |
312977 | 312977 | 2020-07-08 | Douglas | Illinois | 17041 | 54 | 0 |
309807 | 309807 | 2020-07-07 | Douglas | Illinois | 17041 | 54 | 0 |
306639 | 306639 | 2020-07-06 | Douglas | Illinois | 17041 | 54 | 0 |
303474 | 303474 | 2020-07-05 | Douglas | Illinois | 17041 | 54 | 0 |
300310 | 300310 | 2020-07-04 | Douglas | Illinois | 17041 | 54 | 0 |
297148 | 297148 | 2020-07-03 | Douglas | Illinois | 17041 | 54 | 0 |
293991 | 293991 | 2020-07-02 | Douglas | Illinois | 17041 | 53 | 0 |
290837 | 290837 | 2020-07-01 | Douglas | Illinois | 17041 | 52 | 0 |
287687 | 287687 | 2020-06-30 | Douglas | Illinois | 17041 | 52 | 0 |
284538 | 284538 | 2020-06-29 | Douglas | Illinois | 17041 | 50 | 0 |
281393 | 281393 | 2020-06-28 | Douglas | Illinois | 17041 | 48 | 0 |
278245 | 278245 | 2020-06-27 | Douglas | Illinois | 17041 | 47 | 0 |
275097 | 275097 | 2020-06-26 | Douglas | Illinois | 17041 | 45 | 0 |
271955 | 271955 | 2020-06-25 | Douglas | Illinois | 17041 | 45 | 0 |
268818 | 268818 | 2020-06-24 | Douglas | Illinois | 17041 | 43 | 0 |
265688 | 265688 | 2020-06-23 | Douglas | Illinois | 17041 | 42 | 0 |
262560 | 262560 | 2020-06-22 | Douglas | Illinois | 17041 | 42 | 0 |
259433 | 259433 | 2020-06-21 | Douglas | Illinois | 17041 | 42 | 0 |
256307 | 256307 | 2020-06-20 | Douglas | Illinois | 17041 | 42 | 0 |
253187 | 253187 | 2020-06-19 | Douglas | Illinois | 17041 | 42 | 0 |
250072 | 250072 | 2020-06-18 | Douglas | Illinois | 17041 | 40 | 0 |
246960 | 246960 | 2020-06-17 | Douglas | Illinois | 17041 | 39 | 0 |
243847 | 243847 | 2020-06-16 | Douglas | Illinois | 17041 | 38 | 0 |
240736 | 240736 | 2020-06-15 | Douglas | Illinois | 17041 | 38 | 0 |
237628 | 237628 | 2020-06-14 | Douglas | Illinois | 17041 | 38 | 0 |
234521 | 234521 | 2020-06-13 | Douglas | Illinois | 17041 | 35 | 0 |
231415 | 231415 | 2020-06-12 | Douglas | Illinois | 17041 | 33 | 0 |
228312 | 228312 | 2020-06-11 | Douglas | Illinois | 17041 | 30 | 0 |
225210 | 225210 | 2020-06-10 | Douglas | Illinois | 17041 | 30 | 0 |
222115 | 222115 | 2020-06-09 | Douglas | Illinois | 17041 | 29 | 0 |
219020 | 219020 | 2020-06-08 | Douglas | Illinois | 17041 | 29 | 0 |
215929 | 215929 | 2020-06-07 | Douglas | Illinois | 17041 | 28 | 0 |
212842 | 212842 | 2020-06-06 | Douglas | Illinois | 17041 | 28 | 0 |
209757 | 209757 | 2020-06-05 | Douglas | Illinois | 17041 | 28 | 0 |
206676 | 206676 | 2020-06-04 | Douglas | Illinois | 17041 | 28 | 0 |
203596 | 203596 | 2020-06-03 | Douglas | Illinois | 17041 | 28 | 0 |
200520 | 200520 | 2020-06-02 | Douglas | Illinois | 17041 | 28 | 0 |
197447 | 197447 | 2020-06-01 | Douglas | Illinois | 17041 | 28 | 0 |
194377 | 194377 | 2020-05-31 | Douglas | Illinois | 17041 | 28 | 0 |
191310 | 191310 | 2020-05-30 | Douglas | Illinois | 17041 | 27 | 0 |
188245 | 188245 | 2020-05-29 | Douglas | Illinois | 17041 | 26 | 0 |
185188 | 185188 | 2020-05-28 | Douglas | Illinois | 17041 | 26 | 0 |
182134 | 182134 | 2020-05-27 | Douglas | Illinois | 17041 | 26 | 0 |
179090 | 179090 | 2020-05-26 | Douglas | Illinois | 17041 | 28 | 0 |
176046 | 176046 | 2020-05-25 | Douglas | Illinois | 17041 | 27 | 0 |
173002 | 173002 | 2020-05-24 | Douglas | Illinois | 17041 | 28 | 0 |
169961 | 169961 | 2020-05-23 | Douglas | Illinois | 17041 | 27 | 0 |
166924 | 166924 | 2020-05-22 | Douglas | Illinois | 17041 | 27 | 0 |
163891 | 163891 | 2020-05-21 | Douglas | Illinois | 17041 | 26 | 0 |
160863 | 160863 | 2020-05-20 | Douglas | Illinois | 17041 | 26 | 0 |
157837 | 157837 | 2020-05-19 | Douglas | Illinois | 17041 | 26 | 0 |
154821 | 154821 | 2020-05-18 | Douglas | Illinois | 17041 | 26 | 0 |
151809 | 151809 | 2020-05-17 | Douglas | Illinois | 17041 | 23 | 0 |
148800 | 148800 | 2020-05-16 | Douglas | Illinois | 17041 | 23 | 0 |
145797 | 145797 | 2020-05-15 | Douglas | Illinois | 17041 | 22 | 0 |
142797 | 142797 | 2020-05-14 | Douglas | Illinois | 17041 | 22 | 0 |
139801 | 139801 | 2020-05-13 | Douglas | Illinois | 17041 | 22 | 0 |
136810 | 136810 | 2020-05-12 | Douglas | Illinois | 17041 | 20 | 0 |
133821 | 133821 | 2020-05-11 | Douglas | Illinois | 17041 | 20 | 0 |
130830 | 130830 | 2020-05-10 | Douglas | Illinois | 17041 | 20 | 0 |
127839 | 127839 | 2020-05-09 | Douglas | Illinois | 17041 | 20 | 0 |
124852 | 124852 | 2020-05-08 | Douglas | Illinois | 17041 | 20 | 0 |
121873 | 121873 | 2020-05-07 | Douglas | Illinois | 17041 | 20 | 0 |
118903 | 118903 | 2020-05-06 | Douglas | Illinois | 17041 | 20 | 0 |
115943 | 115943 | 2020-05-05 | Douglas | Illinois | 17041 | 20 | 0 |
113060 | 113060 | 2020-05-04 | Douglas | Illinois | 17041 | 20 | 0 |
110185 | 110185 | 2020-05-03 | Douglas | Illinois | 17041 | 20 | 0 |
107315 | 107315 | 2020-05-02 | Douglas | Illinois | 17041 | 19 | 0 |
104450 | 104450 | 2020-05-01 | Douglas | Illinois | 17041 | 16 | 0 |
101594 | 101594 | 2020-04-30 | Douglas | Illinois | 17041 | 14 | 0 |
98743 | 98743 | 2020-04-29 | Douglas | Illinois | 17041 | 14 | 0 |
95899 | 95899 | 2020-04-28 | Douglas | Illinois | 17041 | 14 | 0 |
93067 | 93067 | 2020-04-27 | Douglas | Illinois | 17041 | 14 | 0 |
90248 | 90248 | 2020-04-26 | Douglas | Illinois | 17041 | 13 | 0 |
87432 | 87432 | 2020-04-25 | Douglas | Illinois | 17041 | 12 | 0 |
84622 | 84622 | 2020-04-24 | Douglas | Illinois | 17041 | 12 | 0 |
81822 | 81822 | 2020-04-23 | Douglas | Illinois | 17041 | 12 | 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);