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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- 2020-04-18 1
- 2020-04-19 1
- 2020-04-20 1
- 2020-04-21 1
- 2020-04-22 1
- 2020-04-23 1
- …
state 1
- Illinois 780
fips 1
- 17041 · 780 ✖
county 1
- Douglas · 780 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
11200 | 11200 | 2020-03-25 | Douglas | Illinois | 17041 | 1 | 0 |
12755 | 12755 | 2020-03-26 | Douglas | Illinois | 17041 | 1 | 0 |
14431 | 14431 | 2020-03-27 | Douglas | Illinois | 17041 | 1 | 0 |
16225 | 16225 | 2020-03-28 | Douglas | Illinois | 17041 | 1 | 0 |
18124 | 18124 | 2020-03-29 | Douglas | Illinois | 17041 | 1 | 0 |
20126 | 20126 | 2020-03-30 | Douglas | Illinois | 17041 | 1 | 0 |
22217 | 22217 | 2020-03-31 | Douglas | Illinois | 17041 | 3 | 0 |
24385 | 24385 | 2020-04-01 | Douglas | Illinois | 17041 | 8 | 0 |
26618 | 26618 | 2020-04-02 | Douglas | Illinois | 17041 | 8 | 0 |
28926 | 28926 | 2020-04-03 | Douglas | Illinois | 17041 | 9 | 0 |
31288 | 31288 | 2020-04-04 | Douglas | Illinois | 17041 | 9 | 0 |
33697 | 33697 | 2020-04-05 | Douglas | Illinois | 17041 | 9 | 0 |
36148 | 36148 | 2020-04-06 | Douglas | Illinois | 17041 | 10 | 0 |
38643 | 38643 | 2020-04-07 | Douglas | Illinois | 17041 | 10 | 0 |
41187 | 41187 | 2020-04-08 | Douglas | Illinois | 17041 | 10 | 0 |
43761 | 43761 | 2020-04-09 | Douglas | Illinois | 17041 | 11 | 0 |
46363 | 46363 | 2020-04-10 | Douglas | Illinois | 17041 | 11 | 0 |
48994 | 48994 | 2020-04-11 | Douglas | Illinois | 17041 | 11 | 0 |
51656 | 51656 | 2020-04-12 | Douglas | Illinois | 17041 | 11 | 0 |
54336 | 54336 | 2020-04-13 | Douglas | Illinois | 17041 | 11 | 0 |
57029 | 57029 | 2020-04-14 | Douglas | Illinois | 17041 | 11 | 0 |
59736 | 59736 | 2020-04-15 | Douglas | Illinois | 17041 | 11 | 0 |
62457 | 62457 | 2020-04-16 | Douglas | Illinois | 17041 | 12 | 0 |
65189 | 65189 | 2020-04-17 | Douglas | Illinois | 17041 | 12 | 0 |
67937 | 67937 | 2020-04-18 | Douglas | Illinois | 17041 | 12 | 0 |
70699 | 70699 | 2020-04-19 | Douglas | Illinois | 17041 | 12 | 0 |
73469 | 73469 | 2020-04-20 | Douglas | Illinois | 17041 | 12 | 0 |
76245 | 76245 | 2020-04-21 | Douglas | Illinois | 17041 | 12 | 0 |
79029 | 79029 | 2020-04-22 | Douglas | Illinois | 17041 | 12 | 0 |
81822 | 81822 | 2020-04-23 | Douglas | Illinois | 17041 | 12 | 0 |
84622 | 84622 | 2020-04-24 | Douglas | Illinois | 17041 | 12 | 0 |
87432 | 87432 | 2020-04-25 | Douglas | Illinois | 17041 | 12 | 0 |
90248 | 90248 | 2020-04-26 | Douglas | Illinois | 17041 | 13 | 0 |
93067 | 93067 | 2020-04-27 | Douglas | Illinois | 17041 | 14 | 0 |
95899 | 95899 | 2020-04-28 | Douglas | Illinois | 17041 | 14 | 0 |
98743 | 98743 | 2020-04-29 | Douglas | Illinois | 17041 | 14 | 0 |
101594 | 101594 | 2020-04-30 | Douglas | Illinois | 17041 | 14 | 0 |
104450 | 104450 | 2020-05-01 | Douglas | Illinois | 17041 | 16 | 0 |
107315 | 107315 | 2020-05-02 | Douglas | Illinois | 17041 | 19 | 0 |
110185 | 110185 | 2020-05-03 | Douglas | Illinois | 17041 | 20 | 0 |
113060 | 113060 | 2020-05-04 | Douglas | Illinois | 17041 | 20 | 0 |
115943 | 115943 | 2020-05-05 | Douglas | Illinois | 17041 | 20 | 0 |
118903 | 118903 | 2020-05-06 | Douglas | Illinois | 17041 | 20 | 0 |
121873 | 121873 | 2020-05-07 | Douglas | Illinois | 17041 | 20 | 0 |
124852 | 124852 | 2020-05-08 | Douglas | Illinois | 17041 | 20 | 0 |
127839 | 127839 | 2020-05-09 | Douglas | Illinois | 17041 | 20 | 0 |
130830 | 130830 | 2020-05-10 | Douglas | Illinois | 17041 | 20 | 0 |
133821 | 133821 | 2020-05-11 | Douglas | Illinois | 17041 | 20 | 0 |
136810 | 136810 | 2020-05-12 | Douglas | Illinois | 17041 | 20 | 0 |
139801 | 139801 | 2020-05-13 | Douglas | Illinois | 17041 | 22 | 0 |
142797 | 142797 | 2020-05-14 | Douglas | Illinois | 17041 | 22 | 0 |
145797 | 145797 | 2020-05-15 | Douglas | Illinois | 17041 | 22 | 0 |
148800 | 148800 | 2020-05-16 | Douglas | Illinois | 17041 | 23 | 0 |
151809 | 151809 | 2020-05-17 | Douglas | Illinois | 17041 | 23 | 0 |
154821 | 154821 | 2020-05-18 | Douglas | Illinois | 17041 | 26 | 0 |
157837 | 157837 | 2020-05-19 | Douglas | Illinois | 17041 | 26 | 0 |
160863 | 160863 | 2020-05-20 | Douglas | Illinois | 17041 | 26 | 0 |
163891 | 163891 | 2020-05-21 | Douglas | Illinois | 17041 | 26 | 0 |
166924 | 166924 | 2020-05-22 | Douglas | Illinois | 17041 | 27 | 0 |
169961 | 169961 | 2020-05-23 | Douglas | Illinois | 17041 | 27 | 0 |
173002 | 173002 | 2020-05-24 | Douglas | Illinois | 17041 | 28 | 0 |
176046 | 176046 | 2020-05-25 | Douglas | Illinois | 17041 | 27 | 0 |
179090 | 179090 | 2020-05-26 | Douglas | Illinois | 17041 | 28 | 0 |
182134 | 182134 | 2020-05-27 | Douglas | Illinois | 17041 | 26 | 0 |
185188 | 185188 | 2020-05-28 | Douglas | Illinois | 17041 | 26 | 0 |
188245 | 188245 | 2020-05-29 | Douglas | Illinois | 17041 | 26 | 0 |
191310 | 191310 | 2020-05-30 | Douglas | Illinois | 17041 | 27 | 0 |
194377 | 194377 | 2020-05-31 | Douglas | Illinois | 17041 | 28 | 0 |
197447 | 197447 | 2020-06-01 | Douglas | Illinois | 17041 | 28 | 0 |
200520 | 200520 | 2020-06-02 | Douglas | Illinois | 17041 | 28 | 0 |
203596 | 203596 | 2020-06-03 | Douglas | Illinois | 17041 | 28 | 0 |
206676 | 206676 | 2020-06-04 | Douglas | Illinois | 17041 | 28 | 0 |
209757 | 209757 | 2020-06-05 | Douglas | Illinois | 17041 | 28 | 0 |
212842 | 212842 | 2020-06-06 | Douglas | Illinois | 17041 | 28 | 0 |
215929 | 215929 | 2020-06-07 | Douglas | Illinois | 17041 | 28 | 0 |
219020 | 219020 | 2020-06-08 | Douglas | Illinois | 17041 | 29 | 0 |
222115 | 222115 | 2020-06-09 | Douglas | Illinois | 17041 | 29 | 0 |
225210 | 225210 | 2020-06-10 | Douglas | Illinois | 17041 | 30 | 0 |
228312 | 228312 | 2020-06-11 | Douglas | Illinois | 17041 | 30 | 0 |
231415 | 231415 | 2020-06-12 | Douglas | Illinois | 17041 | 33 | 0 |
234521 | 234521 | 2020-06-13 | Douglas | Illinois | 17041 | 35 | 0 |
237628 | 237628 | 2020-06-14 | Douglas | Illinois | 17041 | 38 | 0 |
240736 | 240736 | 2020-06-15 | Douglas | Illinois | 17041 | 38 | 0 |
243847 | 243847 | 2020-06-16 | Douglas | Illinois | 17041 | 38 | 0 |
246960 | 246960 | 2020-06-17 | Douglas | Illinois | 17041 | 39 | 0 |
250072 | 250072 | 2020-06-18 | Douglas | Illinois | 17041 | 40 | 0 |
253187 | 253187 | 2020-06-19 | Douglas | Illinois | 17041 | 42 | 0 |
256307 | 256307 | 2020-06-20 | Douglas | Illinois | 17041 | 42 | 0 |
259433 | 259433 | 2020-06-21 | Douglas | Illinois | 17041 | 42 | 0 |
262560 | 262560 | 2020-06-22 | Douglas | Illinois | 17041 | 42 | 0 |
265688 | 265688 | 2020-06-23 | Douglas | Illinois | 17041 | 42 | 0 |
268818 | 268818 | 2020-06-24 | Douglas | Illinois | 17041 | 43 | 0 |
271955 | 271955 | 2020-06-25 | Douglas | Illinois | 17041 | 45 | 0 |
275097 | 275097 | 2020-06-26 | Douglas | Illinois | 17041 | 45 | 0 |
278245 | 278245 | 2020-06-27 | Douglas | Illinois | 17041 | 47 | 0 |
281393 | 281393 | 2020-06-28 | Douglas | Illinois | 17041 | 48 | 0 |
284538 | 284538 | 2020-06-29 | Douglas | Illinois | 17041 | 50 | 0 |
287687 | 287687 | 2020-06-30 | Douglas | Illinois | 17041 | 52 | 0 |
290837 | 290837 | 2020-07-01 | Douglas | Illinois | 17041 | 52 | 0 |
293991 | 293991 | 2020-07-02 | Douglas | Illinois | 17041 | 53 | 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);