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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635504 | 635504 | 2020-10-16 | Douglas | Illinois | 17041 | 470 | 8 |
632258 | 632258 | 2020-10-15 | Douglas | Illinois | 17041 | 447 | 8 |
629014 | 629014 | 2020-10-14 | Douglas | Illinois | 17041 | 420 | 8 |
625771 | 625771 | 2020-10-13 | Douglas | Illinois | 17041 | 398 | 8 |
622529 | 622529 | 2020-10-12 | Douglas | Illinois | 17041 | 385 | 8 |
619285 | 619285 | 2020-10-11 | Douglas | Illinois | 17041 | 375 | 7 |
616043 | 616043 | 2020-10-10 | Douglas | Illinois | 17041 | 368 | 7 |
612802 | 612802 | 2020-10-09 | Douglas | Illinois | 17041 | 364 | 7 |
609560 | 609560 | 2020-10-08 | Douglas | Illinois | 17041 | 363 | 7 |
606317 | 606317 | 2020-10-07 | Douglas | Illinois | 17041 | 357 | 7 |
603075 | 603075 | 2020-10-06 | Douglas | Illinois | 17041 | 352 | 7 |
599832 | 599832 | 2020-10-05 | Douglas | Illinois | 17041 | 347 | 7 |
596590 | 596590 | 2020-10-04 | Douglas | Illinois | 17041 | 345 | 7 |
593348 | 593348 | 2020-10-03 | Douglas | Illinois | 17041 | 337 | 7 |
590107 | 590107 | 2020-10-02 | Douglas | Illinois | 17041 | 330 | 7 |
586866 | 586866 | 2020-10-01 | Douglas | Illinois | 17041 | 326 | 7 |
583626 | 583626 | 2020-09-30 | Douglas | Illinois | 17041 | 318 | 7 |
580387 | 580387 | 2020-09-29 | Douglas | Illinois | 17041 | 316 | 7 |
577146 | 577146 | 2020-09-28 | Douglas | Illinois | 17041 | 314 | 7 |
573904 | 573904 | 2020-09-27 | Douglas | Illinois | 17041 | 312 | 7 |
570661 | 570661 | 2020-09-26 | Douglas | Illinois | 17041 | 308 | 7 |
567419 | 567419 | 2020-09-25 | Douglas | Illinois | 17041 | 303 | 7 |
564179 | 564179 | 2020-09-24 | Douglas | Illinois | 17041 | 293 | 7 |
560939 | 560939 | 2020-09-23 | Douglas | Illinois | 17041 | 285 | 7 |
557703 | 557703 | 2020-09-22 | Douglas | Illinois | 17041 | 281 | 6 |
554466 | 554466 | 2020-09-21 | Douglas | Illinois | 17041 | 280 | 6 |
551227 | 551227 | 2020-09-20 | Douglas | Illinois | 17041 | 275 | 6 |
547988 | 547988 | 2020-09-19 | Douglas | Illinois | 17041 | 273 | 5 |
544750 | 544750 | 2020-09-18 | Douglas | Illinois | 17041 | 272 | 5 |
541514 | 541514 | 2020-09-17 | Douglas | Illinois | 17041 | 269 | 5 |
538277 | 538277 | 2020-09-16 | Douglas | Illinois | 17041 | 268 | 5 |
535041 | 535041 | 2020-09-15 | Douglas | Illinois | 17041 | 267 | 5 |
531806 | 531806 | 2020-09-14 | Douglas | Illinois | 17041 | 262 | 5 |
528569 | 528569 | 2020-09-13 | Douglas | Illinois | 17041 | 260 | 5 |
525333 | 525333 | 2020-09-12 | Douglas | Illinois | 17041 | 254 | 5 |
522097 | 522097 | 2020-09-11 | Douglas | Illinois | 17041 | 249 | 5 |
518860 | 518860 | 2020-09-10 | Douglas | Illinois | 17041 | 247 | 5 |
515625 | 515625 | 2020-09-09 | Douglas | Illinois | 17041 | 242 | 5 |
512392 | 512392 | 2020-09-08 | Douglas | Illinois | 17041 | 240 | 5 |
509159 | 509159 | 2020-09-07 | Douglas | Illinois | 17041 | 241 | 5 |
505927 | 505927 | 2020-09-06 | Douglas | Illinois | 17041 | 242 | 5 |
502693 | 502693 | 2020-09-05 | Douglas | Illinois | 17041 | 237 | 5 |
499459 | 499459 | 2020-09-04 | Douglas | Illinois | 17041 | 235 | 5 |
496226 | 496226 | 2020-09-03 | Douglas | Illinois | 17041 | 232 | 5 |
492992 | 492992 | 2020-09-02 | Douglas | Illinois | 17041 | 231 | 5 |
489759 | 489759 | 2020-09-01 | Douglas | Illinois | 17041 | 223 | 5 |
486526 | 486526 | 2020-08-31 | Douglas | Illinois | 17041 | 222 | 5 |
483291 | 483291 | 2020-08-30 | Douglas | Illinois | 17041 | 217 | 5 |
480057 | 480057 | 2020-08-29 | Douglas | Illinois | 17041 | 211 | 5 |
476824 | 476824 | 2020-08-28 | Douglas | Illinois | 17041 | 207 | 5 |
473591 | 473591 | 2020-08-27 | Douglas | Illinois | 17041 | 202 | 4 |
470359 | 470359 | 2020-08-26 | Douglas | Illinois | 17041 | 198 | 4 |
467130 | 467130 | 2020-08-25 | Douglas | Illinois | 17041 | 195 | 4 |
463901 | 463901 | 2020-08-24 | Douglas | Illinois | 17041 | 189 | 4 |
460672 | 460672 | 2020-08-23 | Douglas | Illinois | 17041 | 189 | 4 |
457445 | 457445 | 2020-08-22 | Douglas | Illinois | 17041 | 185 | 4 |
454217 | 454217 | 2020-08-21 | Douglas | Illinois | 17041 | 178 | 3 |
450989 | 450989 | 2020-08-20 | Douglas | Illinois | 17041 | 167 | 3 |
447761 | 447761 | 2020-08-19 | Douglas | Illinois | 17041 | 161 | 3 |
444534 | 444534 | 2020-08-18 | Douglas | Illinois | 17041 | 152 | 3 |
441308 | 441308 | 2020-08-17 | Douglas | Illinois | 17041 | 151 | 3 |
438082 | 438082 | 2020-08-16 | Douglas | Illinois | 17041 | 146 | 3 |
434856 | 434856 | 2020-08-15 | Douglas | Illinois | 17041 | 140 | 3 |
431631 | 431631 | 2020-08-14 | Douglas | Illinois | 17041 | 135 | 3 |
428403 | 428403 | 2020-08-13 | Douglas | Illinois | 17041 | 133 | 3 |
425179 | 425179 | 2020-08-12 | Douglas | Illinois | 17041 | 129 | 3 |
421958 | 421958 | 2020-08-11 | Douglas | Illinois | 17041 | 122 | 2 |
418735 | 418735 | 2020-08-10 | Douglas | Illinois | 17041 | 122 | 2 |
415514 | 415514 | 2020-08-09 | Douglas | Illinois | 17041 | 116 | 2 |
412294 | 412294 | 2020-08-08 | Douglas | Illinois | 17041 | 115 | 2 |
409075 | 409075 | 2020-08-07 | Douglas | Illinois | 17041 | 108 | 2 |
405855 | 405855 | 2020-08-06 | Douglas | Illinois | 17041 | 106 | 2 |
402637 | 402637 | 2020-08-05 | Douglas | Illinois | 17041 | 104 | 2 |
399421 | 399421 | 2020-08-04 | Douglas | Illinois | 17041 | 103 | 2 |
396205 | 396205 | 2020-08-03 | Douglas | Illinois | 17041 | 102 | 2 |
392989 | 392989 | 2020-08-02 | Douglas | Illinois | 17041 | 102 | 2 |
389772 | 389772 | 2020-08-01 | Douglas | Illinois | 17041 | 102 | 2 |
386555 | 386555 | 2020-07-31 | Douglas | Illinois | 17041 | 103 | 2 |
383337 | 383337 | 2020-07-30 | Douglas | Illinois | 17041 | 103 | 2 |
380120 | 380120 | 2020-07-29 | Douglas | Illinois | 17041 | 103 | 2 |
376903 | 376903 | 2020-07-28 | Douglas | Illinois | 17041 | 101 | 2 |
373688 | 373688 | 2020-07-27 | Douglas | Illinois | 17041 | 96 | 1 |
370476 | 370476 | 2020-07-26 | Douglas | Illinois | 17041 | 94 | 1 |
367266 | 367266 | 2020-07-25 | Douglas | Illinois | 17041 | 92 | 1 |
364059 | 364059 | 2020-07-24 | Douglas | Illinois | 17041 | 92 | 1 |
360852 | 360852 | 2020-07-23 | Douglas | Illinois | 17041 | 92 | 1 |
357647 | 357647 | 2020-07-22 | Douglas | Illinois | 17041 | 89 | 0 |
354445 | 354445 | 2020-07-21 | Douglas | Illinois | 17041 | 84 | 0 |
351243 | 351243 | 2020-07-20 | Douglas | Illinois | 17041 | 80 | 0 |
348043 | 348043 | 2020-07-19 | Douglas | Illinois | 17041 | 76 | 0 |
344842 | 344842 | 2020-07-18 | Douglas | Illinois | 17041 | 74 | 0 |
341642 | 341642 | 2020-07-17 | Douglas | Illinois | 17041 | 71 | 0 |
338446 | 338446 | 2020-07-16 | Douglas | Illinois | 17041 | 66 | 0 |
335250 | 335250 | 2020-07-15 | Douglas | Illinois | 17041 | 62 | 0 |
332057 | 332057 | 2020-07-14 | Douglas | Illinois | 17041 | 61 | 0 |
328870 | 328870 | 2020-07-13 | Douglas | Illinois | 17041 | 61 | 0 |
325684 | 325684 | 2020-07-12 | Douglas | Illinois | 17041 | 61 | 0 |
322503 | 322503 | 2020-07-11 | Douglas | Illinois | 17041 | 61 | 0 |
319324 | 319324 | 2020-07-10 | Douglas | Illinois | 17041 | 55 | 0 |
316151 | 316151 | 2020-07-09 | Douglas | Illinois | 17041 | 55 | 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);