ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where county = "Jefferson" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386575 | 386575 | 2020-07-31 | Jefferson | Illinois | 17081 | 176 | 17 |
383357 | 383357 | 2020-07-30 | Jefferson | Illinois | 17081 | 171 | 17 |
380140 | 380140 | 2020-07-29 | Jefferson | Illinois | 17081 | 169 | 17 |
376923 | 376923 | 2020-07-28 | Jefferson | Illinois | 17081 | 163 | 17 |
373708 | 373708 | 2020-07-27 | Jefferson | Illinois | 17081 | 162 | 17 |
370496 | 370496 | 2020-07-26 | Jefferson | Illinois | 17081 | 155 | 17 |
367286 | 367286 | 2020-07-25 | Jefferson | Illinois | 17081 | 153 | 17 |
364079 | 364079 | 2020-07-24 | Jefferson | Illinois | 17081 | 151 | 17 |
360872 | 360872 | 2020-07-23 | Jefferson | Illinois | 17081 | 142 | 17 |
357667 | 357667 | 2020-07-22 | Jefferson | Illinois | 17081 | 138 | 17 |
354465 | 354465 | 2020-07-21 | Jefferson | Illinois | 17081 | 137 | 17 |
351263 | 351263 | 2020-07-20 | Jefferson | Illinois | 17081 | 136 | 17 |
348063 | 348063 | 2020-07-19 | Jefferson | Illinois | 17081 | 130 | 17 |
344862 | 344862 | 2020-07-18 | Jefferson | Illinois | 17081 | 127 | 17 |
341662 | 341662 | 2020-07-17 | Jefferson | Illinois | 17081 | 125 | 17 |
338466 | 338466 | 2020-07-16 | Jefferson | Illinois | 17081 | 124 | 17 |
335270 | 335270 | 2020-07-15 | Jefferson | Illinois | 17081 | 123 | 17 |
332077 | 332077 | 2020-07-14 | Jefferson | Illinois | 17081 | 117 | 17 |
328890 | 328890 | 2020-07-13 | Jefferson | Illinois | 17081 | 115 | 17 |
325704 | 325704 | 2020-07-12 | Jefferson | Illinois | 17081 | 114 | 17 |
322523 | 322523 | 2020-07-11 | Jefferson | Illinois | 17081 | 114 | 17 |
319344 | 319344 | 2020-07-10 | Jefferson | Illinois | 17081 | 115 | 17 |
316171 | 316171 | 2020-07-09 | Jefferson | Illinois | 17081 | 113 | 17 |
312997 | 312997 | 2020-07-08 | Jefferson | Illinois | 17081 | 111 | 17 |
309827 | 309827 | 2020-07-07 | Jefferson | Illinois | 17081 | 107 | 17 |
306659 | 306659 | 2020-07-06 | Jefferson | Illinois | 17081 | 107 | 17 |
303494 | 303494 | 2020-07-05 | Jefferson | Illinois | 17081 | 107 | 17 |
300330 | 300330 | 2020-07-04 | Jefferson | Illinois | 17081 | 106 | 17 |
297168 | 297168 | 2020-07-03 | Jefferson | Illinois | 17081 | 106 | 17 |
294011 | 294011 | 2020-07-02 | Jefferson | Illinois | 17081 | 107 | 17 |
290857 | 290857 | 2020-07-01 | Jefferson | Illinois | 17081 | 107 | 17 |
287707 | 287707 | 2020-06-30 | Jefferson | Illinois | 17081 | 107 | 17 |
284558 | 284558 | 2020-06-29 | Jefferson | Illinois | 17081 | 107 | 17 |
281413 | 281413 | 2020-06-28 | Jefferson | Illinois | 17081 | 106 | 17 |
278265 | 278265 | 2020-06-27 | Jefferson | Illinois | 17081 | 106 | 17 |
275117 | 275117 | 2020-06-26 | Jefferson | Illinois | 17081 | 105 | 17 |
271975 | 271975 | 2020-06-25 | Jefferson | Illinois | 17081 | 105 | 17 |
268838 | 268838 | 2020-06-24 | Jefferson | Illinois | 17081 | 107 | 17 |
265708 | 265708 | 2020-06-23 | Jefferson | Illinois | 17081 | 104 | 17 |
262580 | 262580 | 2020-06-22 | Jefferson | Illinois | 17081 | 104 | 16 |
259453 | 259453 | 2020-06-21 | Jefferson | Illinois | 17081 | 104 | 16 |
256327 | 256327 | 2020-06-20 | Jefferson | Illinois | 17081 | 104 | 16 |
253207 | 253207 | 2020-06-19 | Jefferson | Illinois | 17081 | 104 | 16 |
250092 | 250092 | 2020-06-18 | Jefferson | Illinois | 17081 | 104 | 16 |
246980 | 246980 | 2020-06-17 | Jefferson | Illinois | 17081 | 104 | 16 |
243867 | 243867 | 2020-06-16 | Jefferson | Illinois | 17081 | 104 | 16 |
240756 | 240756 | 2020-06-15 | Jefferson | Illinois | 17081 | 104 | 16 |
237648 | 237648 | 2020-06-14 | Jefferson | Illinois | 17081 | 104 | 16 |
234541 | 234541 | 2020-06-13 | Jefferson | Illinois | 17081 | 103 | 16 |
231435 | 231435 | 2020-06-12 | Jefferson | Illinois | 17081 | 103 | 16 |
228332 | 228332 | 2020-06-11 | Jefferson | Illinois | 17081 | 101 | 16 |
225230 | 225230 | 2020-06-10 | Jefferson | Illinois | 17081 | 101 | 16 |
222135 | 222135 | 2020-06-09 | Jefferson | Illinois | 17081 | 101 | 16 |
219040 | 219040 | 2020-06-08 | Jefferson | Illinois | 17081 | 101 | 16 |
215949 | 215949 | 2020-06-07 | Jefferson | Illinois | 17081 | 101 | 16 |
212862 | 212862 | 2020-06-06 | Jefferson | Illinois | 17081 | 101 | 16 |
209777 | 209777 | 2020-06-05 | Jefferson | Illinois | 17081 | 101 | 16 |
206696 | 206696 | 2020-06-04 | Jefferson | Illinois | 17081 | 101 | 16 |
203616 | 203616 | 2020-06-03 | Jefferson | Illinois | 17081 | 101 | 16 |
200540 | 200540 | 2020-06-02 | Jefferson | Illinois | 17081 | 101 | 16 |
197467 | 197467 | 2020-06-01 | Jefferson | Illinois | 17081 | 101 | 16 |
194397 | 194397 | 2020-05-31 | Jefferson | Illinois | 17081 | 101 | 16 |
191330 | 191330 | 2020-05-30 | Jefferson | Illinois | 17081 | 101 | 16 |
188265 | 188265 | 2020-05-29 | Jefferson | Illinois | 17081 | 101 | 16 |
185207 | 185207 | 2020-05-28 | Jefferson | Illinois | 17081 | 101 | 16 |
182153 | 182153 | 2020-05-27 | Jefferson | Illinois | 17081 | 101 | 16 |
179109 | 179109 | 2020-05-26 | Jefferson | Illinois | 17081 | 101 | 16 |
176065 | 176065 | 2020-05-25 | Jefferson | Illinois | 17081 | 101 | 16 |
173021 | 173021 | 2020-05-24 | Jefferson | Illinois | 17081 | 101 | 16 |
169980 | 169980 | 2020-05-23 | Jefferson | Illinois | 17081 | 100 | 16 |
166943 | 166943 | 2020-05-22 | Jefferson | Illinois | 17081 | 99 | 16 |
163910 | 163910 | 2020-05-21 | Jefferson | Illinois | 17081 | 99 | 16 |
160882 | 160882 | 2020-05-20 | Jefferson | Illinois | 17081 | 100 | 17 |
157856 | 157856 | 2020-05-19 | Jefferson | Illinois | 17081 | 100 | 17 |
154840 | 154840 | 2020-05-18 | Jefferson | Illinois | 17081 | 99 | 17 |
151828 | 151828 | 2020-05-17 | Jefferson | Illinois | 17081 | 98 | 17 |
148819 | 148819 | 2020-05-16 | Jefferson | Illinois | 17081 | 98 | 17 |
145816 | 145816 | 2020-05-15 | Jefferson | Illinois | 17081 | 98 | 17 |
142816 | 142816 | 2020-05-14 | Jefferson | Illinois | 17081 | 98 | 17 |
139820 | 139820 | 2020-05-13 | Jefferson | Illinois | 17081 | 97 | 16 |
136828 | 136828 | 2020-05-12 | Jefferson | Illinois | 17081 | 95 | 15 |
133839 | 133839 | 2020-05-11 | Jefferson | Illinois | 17081 | 94 | 15 |
130848 | 130848 | 2020-05-10 | Jefferson | Illinois | 17081 | 97 | 15 |
127857 | 127857 | 2020-05-09 | Jefferson | Illinois | 17081 | 94 | 15 |
124870 | 124870 | 2020-05-08 | Jefferson | Illinois | 17081 | 89 | 15 |
121891 | 121891 | 2020-05-07 | Jefferson | Illinois | 17081 | 88 | 15 |
118921 | 118921 | 2020-05-06 | Jefferson | Illinois | 17081 | 86 | 15 |
115961 | 115961 | 2020-05-05 | Jefferson | Illinois | 17081 | 86 | 15 |
113078 | 113078 | 2020-05-04 | Jefferson | Illinois | 17081 | 87 | 15 |
110203 | 110203 | 2020-05-03 | Jefferson | Illinois | 17081 | 86 | 15 |
107333 | 107333 | 2020-05-02 | Jefferson | Illinois | 17081 | 84 | 14 |
104468 | 104468 | 2020-05-01 | Jefferson | Illinois | 17081 | 85 | 12 |
101612 | 101612 | 2020-04-30 | Jefferson | Illinois | 17081 | 83 | 12 |
98761 | 98761 | 2020-04-29 | Jefferson | Illinois | 17081 | 80 | 11 |
95917 | 95917 | 2020-04-28 | Jefferson | Illinois | 17081 | 81 | 9 |
93085 | 93085 | 2020-04-27 | Jefferson | Illinois | 17081 | 83 | 8 |
90266 | 90266 | 2020-04-26 | Jefferson | Illinois | 17081 | 83 | 5 |
87450 | 87450 | 2020-04-25 | Jefferson | Illinois | 17081 | 80 | 2 |
84640 | 84640 | 2020-04-24 | Jefferson | Illinois | 17081 | 80 | 2 |
81840 | 81840 | 2020-04-23 | Jefferson | Illinois | 17081 | 77 | 1 |
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);