ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Jackson" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386573 | 386573 | 2020-07-31 | Jackson | Illinois | 17077 | 616 | 19 |
383355 | 383355 | 2020-07-30 | Jackson | Illinois | 17077 | 591 | 19 |
380138 | 380138 | 2020-07-29 | Jackson | Illinois | 17077 | 572 | 19 |
376921 | 376921 | 2020-07-28 | Jackson | Illinois | 17077 | 556 | 19 |
373706 | 373706 | 2020-07-27 | Jackson | Illinois | 17077 | 544 | 19 |
370494 | 370494 | 2020-07-26 | Jackson | Illinois | 17077 | 530 | 19 |
367284 | 367284 | 2020-07-25 | Jackson | Illinois | 17077 | 487 | 19 |
364077 | 364077 | 2020-07-24 | Jackson | Illinois | 17077 | 463 | 19 |
360870 | 360870 | 2020-07-23 | Jackson | Illinois | 17077 | 450 | 19 |
357665 | 357665 | 2020-07-22 | Jackson | Illinois | 17077 | 434 | 19 |
354463 | 354463 | 2020-07-21 | Jackson | Illinois | 17077 | 420 | 19 |
351261 | 351261 | 2020-07-20 | Jackson | Illinois | 17077 | 420 | 19 |
348061 | 348061 | 2020-07-19 | Jackson | Illinois | 17077 | 400 | 19 |
344860 | 344860 | 2020-07-18 | Jackson | Illinois | 17077 | 389 | 19 |
341660 | 341660 | 2020-07-17 | Jackson | Illinois | 17077 | 381 | 19 |
338464 | 338464 | 2020-07-16 | Jackson | Illinois | 17077 | 373 | 19 |
335268 | 335268 | 2020-07-15 | Jackson | Illinois | 17077 | 366 | 19 |
332075 | 332075 | 2020-07-14 | Jackson | Illinois | 17077 | 359 | 19 |
328888 | 328888 | 2020-07-13 | Jackson | Illinois | 17077 | 357 | 19 |
325702 | 325702 | 2020-07-12 | Jackson | Illinois | 17077 | 356 | 19 |
322521 | 322521 | 2020-07-11 | Jackson | Illinois | 17077 | 351 | 19 |
319342 | 319342 | 2020-07-10 | Jackson | Illinois | 17077 | 347 | 19 |
316169 | 316169 | 2020-07-09 | Jackson | Illinois | 17077 | 345 | 19 |
312995 | 312995 | 2020-07-08 | Jackson | Illinois | 17077 | 343 | 19 |
309825 | 309825 | 2020-07-07 | Jackson | Illinois | 17077 | 340 | 19 |
306657 | 306657 | 2020-07-06 | Jackson | Illinois | 17077 | 340 | 19 |
303492 | 303492 | 2020-07-05 | Jackson | Illinois | 17077 | 339 | 19 |
300328 | 300328 | 2020-07-04 | Jackson | Illinois | 17077 | 336 | 19 |
297166 | 297166 | 2020-07-03 | Jackson | Illinois | 17077 | 335 | 19 |
294009 | 294009 | 2020-07-02 | Jackson | Illinois | 17077 | 333 | 19 |
290855 | 290855 | 2020-07-01 | Jackson | Illinois | 17077 | 332 | 19 |
287705 | 287705 | 2020-06-30 | Jackson | Illinois | 17077 | 332 | 19 |
284556 | 284556 | 2020-06-29 | Jackson | Illinois | 17077 | 329 | 19 |
281411 | 281411 | 2020-06-28 | Jackson | Illinois | 17077 | 329 | 19 |
278263 | 278263 | 2020-06-27 | Jackson | Illinois | 17077 | 329 | 19 |
275115 | 275115 | 2020-06-26 | Jackson | Illinois | 17077 | 329 | 19 |
271973 | 271973 | 2020-06-25 | Jackson | Illinois | 17077 | 328 | 19 |
268836 | 268836 | 2020-06-24 | Jackson | Illinois | 17077 | 325 | 19 |
265706 | 265706 | 2020-06-23 | Jackson | Illinois | 17077 | 325 | 18 |
262578 | 262578 | 2020-06-22 | Jackson | Illinois | 17077 | 324 | 18 |
259451 | 259451 | 2020-06-21 | Jackson | Illinois | 17077 | 323 | 18 |
256325 | 256325 | 2020-06-20 | Jackson | Illinois | 17077 | 322 | 18 |
253205 | 253205 | 2020-06-19 | Jackson | Illinois | 17077 | 321 | 18 |
250090 | 250090 | 2020-06-18 | Jackson | Illinois | 17077 | 321 | 18 |
246978 | 246978 | 2020-06-17 | Jackson | Illinois | 17077 | 321 | 18 |
243865 | 243865 | 2020-06-16 | Jackson | Illinois | 17077 | 320 | 15 |
240754 | 240754 | 2020-06-15 | Jackson | Illinois | 17077 | 317 | 13 |
237646 | 237646 | 2020-06-14 | Jackson | Illinois | 17077 | 315 | 13 |
234539 | 234539 | 2020-06-13 | Jackson | Illinois | 17077 | 313 | 13 |
231433 | 231433 | 2020-06-12 | Jackson | Illinois | 17077 | 311 | 12 |
228330 | 228330 | 2020-06-11 | Jackson | Illinois | 17077 | 307 | 12 |
225228 | 225228 | 2020-06-10 | Jackson | Illinois | 17077 | 307 | 11 |
222133 | 222133 | 2020-06-09 | Jackson | Illinois | 17077 | 304 | 11 |
219038 | 219038 | 2020-06-08 | Jackson | Illinois | 17077 | 301 | 11 |
215947 | 215947 | 2020-06-07 | Jackson | Illinois | 17077 | 301 | 11 |
212860 | 212860 | 2020-06-06 | Jackson | Illinois | 17077 | 300 | 11 |
209775 | 209775 | 2020-06-05 | Jackson | Illinois | 17077 | 300 | 10 |
206694 | 206694 | 2020-06-04 | Jackson | Illinois | 17077 | 296 | 10 |
203614 | 203614 | 2020-06-03 | Jackson | Illinois | 17077 | 293 | 10 |
200538 | 200538 | 2020-06-02 | Jackson | Illinois | 17077 | 289 | 10 |
197465 | 197465 | 2020-06-01 | Jackson | Illinois | 17077 | 289 | 10 |
194395 | 194395 | 2020-05-31 | Jackson | Illinois | 17077 | 286 | 10 |
191328 | 191328 | 2020-05-30 | Jackson | Illinois | 17077 | 282 | 10 |
188263 | 188263 | 2020-05-29 | Jackson | Illinois | 17077 | 268 | 10 |
185205 | 185205 | 2020-05-28 | Jackson | Illinois | 17077 | 256 | 10 |
182151 | 182151 | 2020-05-27 | Jackson | Illinois | 17077 | 242 | 10 |
179107 | 179107 | 2020-05-26 | Jackson | Illinois | 17077 | 228 | 10 |
176063 | 176063 | 2020-05-25 | Jackson | Illinois | 17077 | 228 | 10 |
173019 | 173019 | 2020-05-24 | Jackson | Illinois | 17077 | 219 | 10 |
169978 | 169978 | 2020-05-23 | Jackson | Illinois | 17077 | 207 | 10 |
166941 | 166941 | 2020-05-22 | Jackson | Illinois | 17077 | 197 | 10 |
163908 | 163908 | 2020-05-21 | Jackson | Illinois | 17077 | 192 | 10 |
160880 | 160880 | 2020-05-20 | Jackson | Illinois | 17077 | 187 | 10 |
157854 | 157854 | 2020-05-19 | Jackson | Illinois | 17077 | 186 | 10 |
154838 | 154838 | 2020-05-18 | Jackson | Illinois | 17077 | 181 | 10 |
151826 | 151826 | 2020-05-17 | Jackson | Illinois | 17077 | 181 | 10 |
148817 | 148817 | 2020-05-16 | Jackson | Illinois | 17077 | 181 | 10 |
145814 | 145814 | 2020-05-15 | Jackson | Illinois | 17077 | 177 | 10 |
142814 | 142814 | 2020-05-14 | Jackson | Illinois | 17077 | 175 | 10 |
139818 | 139818 | 2020-05-13 | Jackson | Illinois | 17077 | 171 | 10 |
136826 | 136826 | 2020-05-12 | Jackson | Illinois | 17077 | 167 | 10 |
133837 | 133837 | 2020-05-11 | Jackson | Illinois | 17077 | 166 | 10 |
130846 | 130846 | 2020-05-10 | Jackson | Illinois | 17077 | 167 | 10 |
127855 | 127855 | 2020-05-09 | Jackson | Illinois | 17077 | 162 | 10 |
124868 | 124868 | 2020-05-08 | Jackson | Illinois | 17077 | 161 | 10 |
121889 | 121889 | 2020-05-07 | Jackson | Illinois | 17077 | 157 | 10 |
118919 | 118919 | 2020-05-06 | Jackson | Illinois | 17077 | 154 | 9 |
115959 | 115959 | 2020-05-05 | Jackson | Illinois | 17077 | 146 | 9 |
113076 | 113076 | 2020-05-04 | Jackson | Illinois | 17077 | 140 | 9 |
110201 | 110201 | 2020-05-03 | Jackson | Illinois | 17077 | 139 | 9 |
107331 | 107331 | 2020-05-02 | Jackson | Illinois | 17077 | 125 | 9 |
104466 | 104466 | 2020-05-01 | Jackson | Illinois | 17077 | 120 | 9 |
101610 | 101610 | 2020-04-30 | Jackson | Illinois | 17077 | 107 | 7 |
98759 | 98759 | 2020-04-29 | Jackson | Illinois | 17077 | 82 | 7 |
95915 | 95915 | 2020-04-28 | Jackson | Illinois | 17077 | 75 | 7 |
93083 | 93083 | 2020-04-27 | Jackson | Illinois | 17077 | 68 | 7 |
90264 | 90264 | 2020-04-26 | Jackson | Illinois | 17077 | 67 | 7 |
87448 | 87448 | 2020-04-25 | Jackson | Illinois | 17077 | 56 | 7 |
84638 | 84638 | 2020-04-24 | Jackson | Illinois | 17077 | 56 | 7 |
81838 | 81838 | 2020-04-23 | Jackson | Illinois | 17077 | 53 | 7 |
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);