ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Jo Daviess" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535063 | 535063 | 2020-09-15 | Jo Daviess | Illinois | 17085 | 217 | 2 |
531828 | 531828 | 2020-09-14 | Jo Daviess | Illinois | 17085 | 215 | 2 |
528591 | 528591 | 2020-09-13 | Jo Daviess | Illinois | 17085 | 212 | 2 |
525355 | 525355 | 2020-09-12 | Jo Daviess | Illinois | 17085 | 210 | 2 |
522119 | 522119 | 2020-09-11 | Jo Daviess | Illinois | 17085 | 204 | 2 |
518882 | 518882 | 2020-09-10 | Jo Daviess | Illinois | 17085 | 200 | 2 |
515647 | 515647 | 2020-09-09 | Jo Daviess | Illinois | 17085 | 200 | 2 |
512414 | 512414 | 2020-09-08 | Jo Daviess | Illinois | 17085 | 199 | 2 |
509181 | 509181 | 2020-09-07 | Jo Daviess | Illinois | 17085 | 198 | 2 |
505949 | 505949 | 2020-09-06 | Jo Daviess | Illinois | 17085 | 196 | 2 |
502715 | 502715 | 2020-09-05 | Jo Daviess | Illinois | 17085 | 195 | 2 |
499481 | 499481 | 2020-09-04 | Jo Daviess | Illinois | 17085 | 190 | 2 |
496248 | 496248 | 2020-09-03 | Jo Daviess | Illinois | 17085 | 183 | 2 |
493014 | 493014 | 2020-09-02 | Jo Daviess | Illinois | 17085 | 177 | 2 |
489781 | 489781 | 2020-09-01 | Jo Daviess | Illinois | 17085 | 177 | 2 |
486548 | 486548 | 2020-08-31 | Jo Daviess | Illinois | 17085 | 176 | 2 |
483313 | 483313 | 2020-08-30 | Jo Daviess | Illinois | 17085 | 173 | 2 |
480079 | 480079 | 2020-08-29 | Jo Daviess | Illinois | 17085 | 173 | 2 |
476846 | 476846 | 2020-08-28 | Jo Daviess | Illinois | 17085 | 173 | 2 |
473613 | 473613 | 2020-08-27 | Jo Daviess | Illinois | 17085 | 171 | 2 |
470381 | 470381 | 2020-08-26 | Jo Daviess | Illinois | 17085 | 171 | 2 |
467152 | 467152 | 2020-08-25 | Jo Daviess | Illinois | 17085 | 168 | 2 |
463923 | 463923 | 2020-08-24 | Jo Daviess | Illinois | 17085 | 166 | 2 |
460694 | 460694 | 2020-08-23 | Jo Daviess | Illinois | 17085 | 165 | 2 |
457467 | 457467 | 2020-08-22 | Jo Daviess | Illinois | 17085 | 159 | 2 |
454239 | 454239 | 2020-08-21 | Jo Daviess | Illinois | 17085 | 154 | 2 |
451011 | 451011 | 2020-08-20 | Jo Daviess | Illinois | 17085 | 152 | 2 |
447783 | 447783 | 2020-08-19 | Jo Daviess | Illinois | 17085 | 149 | 2 |
444556 | 444556 | 2020-08-18 | Jo Daviess | Illinois | 17085 | 148 | 2 |
441330 | 441330 | 2020-08-17 | Jo Daviess | Illinois | 17085 | 145 | 2 |
438104 | 438104 | 2020-08-16 | Jo Daviess | Illinois | 17085 | 141 | 1 |
434878 | 434878 | 2020-08-15 | Jo Daviess | Illinois | 17085 | 140 | 1 |
431653 | 431653 | 2020-08-14 | Jo Daviess | Illinois | 17085 | 139 | 1 |
428425 | 428425 | 2020-08-13 | Jo Daviess | Illinois | 17085 | 136 | 1 |
425201 | 425201 | 2020-08-12 | Jo Daviess | Illinois | 17085 | 133 | 1 |
421980 | 421980 | 2020-08-11 | Jo Daviess | Illinois | 17085 | 130 | 1 |
418757 | 418757 | 2020-08-10 | Jo Daviess | Illinois | 17085 | 127 | 1 |
415536 | 415536 | 2020-08-09 | Jo Daviess | Illinois | 17085 | 125 | 1 |
412316 | 412316 | 2020-08-08 | Jo Daviess | Illinois | 17085 | 124 | 1 |
409097 | 409097 | 2020-08-07 | Jo Daviess | Illinois | 17085 | 124 | 1 |
405877 | 405877 | 2020-08-06 | Jo Daviess | Illinois | 17085 | 121 | 1 |
402659 | 402659 | 2020-08-05 | Jo Daviess | Illinois | 17085 | 119 | 1 |
399443 | 399443 | 2020-08-04 | Jo Daviess | Illinois | 17085 | 116 | 1 |
396227 | 396227 | 2020-08-03 | Jo Daviess | Illinois | 17085 | 113 | 1 |
393011 | 393011 | 2020-08-02 | Jo Daviess | Illinois | 17085 | 112 | 1 |
389794 | 389794 | 2020-08-01 | Jo Daviess | Illinois | 17085 | 112 | 1 |
386577 | 386577 | 2020-07-31 | Jo Daviess | Illinois | 17085 | 110 | 1 |
383359 | 383359 | 2020-07-30 | Jo Daviess | Illinois | 17085 | 108 | 1 |
380142 | 380142 | 2020-07-29 | Jo Daviess | Illinois | 17085 | 106 | 1 |
376925 | 376925 | 2020-07-28 | Jo Daviess | Illinois | 17085 | 103 | 1 |
373710 | 373710 | 2020-07-27 | Jo Daviess | Illinois | 17085 | 99 | 1 |
370498 | 370498 | 2020-07-26 | Jo Daviess | Illinois | 17085 | 96 | 1 |
367288 | 367288 | 2020-07-25 | Jo Daviess | Illinois | 17085 | 92 | 1 |
364081 | 364081 | 2020-07-24 | Jo Daviess | Illinois | 17085 | 88 | 1 |
360874 | 360874 | 2020-07-23 | Jo Daviess | Illinois | 17085 | 84 | 1 |
357669 | 357669 | 2020-07-22 | Jo Daviess | Illinois | 17085 | 80 | 1 |
354467 | 354467 | 2020-07-21 | Jo Daviess | Illinois | 17085 | 70 | 1 |
351265 | 351265 | 2020-07-20 | Jo Daviess | Illinois | 17085 | 66 | 1 |
348065 | 348065 | 2020-07-19 | Jo Daviess | Illinois | 17085 | 64 | 1 |
344864 | 344864 | 2020-07-18 | Jo Daviess | Illinois | 17085 | 63 | 1 |
341664 | 341664 | 2020-07-17 | Jo Daviess | Illinois | 17085 | 58 | 1 |
338468 | 338468 | 2020-07-16 | Jo Daviess | Illinois | 17085 | 58 | 1 |
335272 | 335272 | 2020-07-15 | Jo Daviess | Illinois | 17085 | 57 | 1 |
332079 | 332079 | 2020-07-14 | Jo Daviess | Illinois | 17085 | 55 | 1 |
328892 | 328892 | 2020-07-13 | Jo Daviess | Illinois | 17085 | 56 | 1 |
325706 | 325706 | 2020-07-12 | Jo Daviess | Illinois | 17085 | 55 | 1 |
322525 | 322525 | 2020-07-11 | Jo Daviess | Illinois | 17085 | 54 | 1 |
319346 | 319346 | 2020-07-10 | Jo Daviess | Illinois | 17085 | 52 | 1 |
316173 | 316173 | 2020-07-09 | Jo Daviess | Illinois | 17085 | 49 | 1 |
312999 | 312999 | 2020-07-08 | Jo Daviess | Illinois | 17085 | 49 | 1 |
309829 | 309829 | 2020-07-07 | Jo Daviess | Illinois | 17085 | 47 | 1 |
306661 | 306661 | 2020-07-06 | Jo Daviess | Illinois | 17085 | 47 | 1 |
303496 | 303496 | 2020-07-05 | Jo Daviess | Illinois | 17085 | 46 | 1 |
300332 | 300332 | 2020-07-04 | Jo Daviess | Illinois | 17085 | 45 | 1 |
297170 | 297170 | 2020-07-03 | Jo Daviess | Illinois | 17085 | 46 | 1 |
294013 | 294013 | 2020-07-02 | Jo Daviess | Illinois | 17085 | 45 | 1 |
290859 | 290859 | 2020-07-01 | Jo Daviess | Illinois | 17085 | 44 | 1 |
287709 | 287709 | 2020-06-30 | Jo Daviess | Illinois | 17085 | 42 | 1 |
284560 | 284560 | 2020-06-29 | Jo Daviess | Illinois | 17085 | 42 | 1 |
281415 | 281415 | 2020-06-28 | Jo Daviess | Illinois | 17085 | 42 | 1 |
278267 | 278267 | 2020-06-27 | Jo Daviess | Illinois | 17085 | 40 | 1 |
275119 | 275119 | 2020-06-26 | Jo Daviess | Illinois | 17085 | 40 | 1 |
271977 | 271977 | 2020-06-25 | Jo Daviess | Illinois | 17085 | 39 | 1 |
268840 | 268840 | 2020-06-24 | Jo Daviess | Illinois | 17085 | 39 | 1 |
265710 | 265710 | 2020-06-23 | Jo Daviess | Illinois | 17085 | 38 | 1 |
262582 | 262582 | 2020-06-22 | Jo Daviess | Illinois | 17085 | 38 | 1 |
259455 | 259455 | 2020-06-21 | Jo Daviess | Illinois | 17085 | 38 | 1 |
256329 | 256329 | 2020-06-20 | Jo Daviess | Illinois | 17085 | 38 | 1 |
253209 | 253209 | 2020-06-19 | Jo Daviess | Illinois | 17085 | 35 | 1 |
250094 | 250094 | 2020-06-18 | Jo Daviess | Illinois | 17085 | 35 | 1 |
246982 | 246982 | 2020-06-17 | Jo Daviess | Illinois | 17085 | 35 | 1 |
243869 | 243869 | 2020-06-16 | Jo Daviess | Illinois | 17085 | 35 | 1 |
240758 | 240758 | 2020-06-15 | Jo Daviess | Illinois | 17085 | 34 | 1 |
237650 | 237650 | 2020-06-14 | Jo Daviess | Illinois | 17085 | 34 | 1 |
234543 | 234543 | 2020-06-13 | Jo Daviess | Illinois | 17085 | 34 | 1 |
231437 | 231437 | 2020-06-12 | Jo Daviess | Illinois | 17085 | 34 | 1 |
228334 | 228334 | 2020-06-11 | Jo Daviess | Illinois | 17085 | 34 | 1 |
225232 | 225232 | 2020-06-10 | Jo Daviess | Illinois | 17085 | 33 | 1 |
222137 | 222137 | 2020-06-09 | Jo Daviess | Illinois | 17085 | 33 | 1 |
219042 | 219042 | 2020-06-08 | Jo Daviess | Illinois | 17085 | 34 | 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);