ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
757 rows where county = "Wayne" and fips = 17191 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386631 | 386631 | 2020-07-31 | Wayne | Illinois | 17191 | 40 | 1 |
383413 | 383413 | 2020-07-30 | Wayne | Illinois | 17191 | 35 | 1 |
380196 | 380196 | 2020-07-29 | Wayne | Illinois | 17191 | 34 | 1 |
376979 | 376979 | 2020-07-28 | Wayne | Illinois | 17191 | 32 | 1 |
373764 | 373764 | 2020-07-27 | Wayne | Illinois | 17191 | 32 | 1 |
370552 | 370552 | 2020-07-26 | Wayne | Illinois | 17191 | 29 | 1 |
367342 | 367342 | 2020-07-25 | Wayne | Illinois | 17191 | 28 | 1 |
364135 | 364135 | 2020-07-24 | Wayne | Illinois | 17191 | 27 | 1 |
360928 | 360928 | 2020-07-23 | Wayne | Illinois | 17191 | 27 | 1 |
357723 | 357723 | 2020-07-22 | Wayne | Illinois | 17191 | 27 | 1 |
354521 | 354521 | 2020-07-21 | Wayne | Illinois | 17191 | 27 | 1 |
351319 | 351319 | 2020-07-20 | Wayne | Illinois | 17191 | 27 | 1 |
348119 | 348119 | 2020-07-19 | Wayne | Illinois | 17191 | 25 | 1 |
344918 | 344918 | 2020-07-18 | Wayne | Illinois | 17191 | 22 | 1 |
341718 | 341718 | 2020-07-17 | Wayne | Illinois | 17191 | 20 | 1 |
338522 | 338522 | 2020-07-16 | Wayne | Illinois | 17191 | 20 | 1 |
335326 | 335326 | 2020-07-15 | Wayne | Illinois | 17191 | 19 | 1 |
332133 | 332133 | 2020-07-14 | Wayne | Illinois | 17191 | 21 | 1 |
328946 | 328946 | 2020-07-13 | Wayne | Illinois | 17191 | 19 | 1 |
325760 | 325760 | 2020-07-12 | Wayne | Illinois | 17191 | 19 | 1 |
322579 | 322579 | 2020-07-11 | Wayne | Illinois | 17191 | 18 | 1 |
319400 | 319400 | 2020-07-10 | Wayne | Illinois | 17191 | 16 | 1 |
316227 | 316227 | 2020-07-09 | Wayne | Illinois | 17191 | 15 | 1 |
313053 | 313053 | 2020-07-08 | Wayne | Illinois | 17191 | 15 | 1 |
309883 | 309883 | 2020-07-07 | Wayne | Illinois | 17191 | 15 | 1 |
306715 | 306715 | 2020-07-06 | Wayne | Illinois | 17191 | 14 | 1 |
303550 | 303550 | 2020-07-05 | Wayne | Illinois | 17191 | 14 | 1 |
300386 | 300386 | 2020-07-04 | Wayne | Illinois | 17191 | 14 | 1 |
297224 | 297224 | 2020-07-03 | Wayne | Illinois | 17191 | 14 | 1 |
294066 | 294066 | 2020-07-02 | Wayne | Illinois | 17191 | 14 | 1 |
290912 | 290912 | 2020-07-01 | Wayne | Illinois | 17191 | 14 | 1 |
287762 | 287762 | 2020-06-30 | Wayne | Illinois | 17191 | 14 | 1 |
284613 | 284613 | 2020-06-29 | Wayne | Illinois | 17191 | 13 | 1 |
281468 | 281468 | 2020-06-28 | Wayne | Illinois | 17191 | 12 | 1 |
278320 | 278320 | 2020-06-27 | Wayne | Illinois | 17191 | 12 | 1 |
275172 | 275172 | 2020-06-26 | Wayne | Illinois | 17191 | 12 | 1 |
272030 | 272030 | 2020-06-25 | Wayne | Illinois | 17191 | 12 | 1 |
268893 | 268893 | 2020-06-24 | Wayne | Illinois | 17191 | 11 | 1 |
265763 | 265763 | 2020-06-23 | Wayne | Illinois | 17191 | 11 | 1 |
262635 | 262635 | 2020-06-22 | Wayne | Illinois | 17191 | 11 | 1 |
259508 | 259508 | 2020-06-21 | Wayne | Illinois | 17191 | 11 | 1 |
256382 | 256382 | 2020-06-20 | Wayne | Illinois | 17191 | 11 | 1 |
253262 | 253262 | 2020-06-19 | Wayne | Illinois | 17191 | 11 | 1 |
250147 | 250147 | 2020-06-18 | Wayne | Illinois | 17191 | 10 | 1 |
247035 | 247035 | 2020-06-17 | Wayne | Illinois | 17191 | 9 | 1 |
243922 | 243922 | 2020-06-16 | Wayne | Illinois | 17191 | 9 | 1 |
240811 | 240811 | 2020-06-15 | Wayne | Illinois | 17191 | 9 | 1 |
237703 | 237703 | 2020-06-14 | Wayne | Illinois | 17191 | 9 | 1 |
234596 | 234596 | 2020-06-13 | Wayne | Illinois | 17191 | 9 | 1 |
231490 | 231490 | 2020-06-12 | Wayne | Illinois | 17191 | 9 | 1 |
228387 | 228387 | 2020-06-11 | Wayne | Illinois | 17191 | 9 | 1 |
225285 | 225285 | 2020-06-10 | Wayne | Illinois | 17191 | 9 | 1 |
222190 | 222190 | 2020-06-09 | Wayne | Illinois | 17191 | 9 | 1 |
219095 | 219095 | 2020-06-08 | Wayne | Illinois | 17191 | 9 | 1 |
216003 | 216003 | 2020-06-07 | Wayne | Illinois | 17191 | 9 | 1 |
212916 | 212916 | 2020-06-06 | Wayne | Illinois | 17191 | 9 | 1 |
209831 | 209831 | 2020-06-05 | Wayne | Illinois | 17191 | 9 | 1 |
206750 | 206750 | 2020-06-04 | Wayne | Illinois | 17191 | 9 | 1 |
203670 | 203670 | 2020-06-03 | Wayne | Illinois | 17191 | 9 | 1 |
200594 | 200594 | 2020-06-02 | Wayne | Illinois | 17191 | 9 | 1 |
197521 | 197521 | 2020-06-01 | Wayne | Illinois | 17191 | 9 | 1 |
194451 | 194451 | 2020-05-31 | Wayne | Illinois | 17191 | 9 | 1 |
191384 | 191384 | 2020-05-30 | Wayne | Illinois | 17191 | 9 | 1 |
188319 | 188319 | 2020-05-29 | Wayne | Illinois | 17191 | 9 | 1 |
185261 | 185261 | 2020-05-28 | Wayne | Illinois | 17191 | 9 | 1 |
182207 | 182207 | 2020-05-27 | Wayne | Illinois | 17191 | 9 | 1 |
179163 | 179163 | 2020-05-26 | Wayne | Illinois | 17191 | 9 | 1 |
176119 | 176119 | 2020-05-25 | Wayne | Illinois | 17191 | 9 | 1 |
173075 | 173075 | 2020-05-24 | Wayne | Illinois | 17191 | 9 | 1 |
170034 | 170034 | 2020-05-23 | Wayne | Illinois | 17191 | 9 | 1 |
166997 | 166997 | 2020-05-22 | Wayne | Illinois | 17191 | 9 | 1 |
163964 | 163964 | 2020-05-21 | Wayne | Illinois | 17191 | 9 | 1 |
160936 | 160936 | 2020-05-20 | Wayne | Illinois | 17191 | 9 | 1 |
157910 | 157910 | 2020-05-19 | Wayne | Illinois | 17191 | 9 | 1 |
154894 | 154894 | 2020-05-18 | Wayne | Illinois | 17191 | 9 | 1 |
151882 | 151882 | 2020-05-17 | Wayne | Illinois | 17191 | 9 | 1 |
148873 | 148873 | 2020-05-16 | Wayne | Illinois | 17191 | 8 | 1 |
145869 | 145869 | 2020-05-15 | Wayne | Illinois | 17191 | 8 | 1 |
142869 | 142869 | 2020-05-14 | Wayne | Illinois | 17191 | 11 | 1 |
139873 | 139873 | 2020-05-13 | Wayne | Illinois | 17191 | 10 | 0 |
136881 | 136881 | 2020-05-12 | Wayne | Illinois | 17191 | 3 | 0 |
133892 | 133892 | 2020-05-11 | Wayne | Illinois | 17191 | 3 | 0 |
130902 | 130902 | 2020-05-10 | Wayne | Illinois | 17191 | 3 | 0 |
127911 | 127911 | 2020-05-09 | Wayne | Illinois | 17191 | 3 | 0 |
124924 | 124924 | 2020-05-08 | Wayne | Illinois | 17191 | 3 | 0 |
121944 | 121944 | 2020-05-07 | Wayne | Illinois | 17191 | 2 | 0 |
118974 | 118974 | 2020-05-06 | Wayne | Illinois | 17191 | 2 | 0 |
116014 | 116014 | 2020-05-05 | Wayne | Illinois | 17191 | 2 | 0 |
113131 | 113131 | 2020-05-04 | Wayne | Illinois | 17191 | 2 | 0 |
110256 | 110256 | 2020-05-03 | Wayne | Illinois | 17191 | 2 | 0 |
107386 | 107386 | 2020-05-02 | Wayne | Illinois | 17191 | 2 | 0 |
104521 | 104521 | 2020-05-01 | Wayne | Illinois | 17191 | 2 | 0 |
101665 | 101665 | 2020-04-30 | Wayne | Illinois | 17191 | 2 | 0 |
98814 | 98814 | 2020-04-29 | Wayne | Illinois | 17191 | 2 | 0 |
95970 | 95970 | 2020-04-28 | Wayne | Illinois | 17191 | 2 | 0 |
93138 | 93138 | 2020-04-27 | Wayne | Illinois | 17191 | 2 | 0 |
90319 | 90319 | 2020-04-26 | Wayne | Illinois | 17191 | 2 | 0 |
87503 | 87503 | 2020-04-25 | Wayne | Illinois | 17191 | 2 | 0 |
84693 | 84693 | 2020-04-24 | Wayne | Illinois | 17191 | 2 | 0 |
81893 | 81893 | 2020-04-23 | Wayne | Illinois | 17191 | 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);