ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Carroll" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635491 | 635491 | 2020-10-16 | Carroll | Illinois | 17015 | 336 | 7 |
632245 | 632245 | 2020-10-15 | Carroll | Illinois | 17015 | 328 | 7 |
629001 | 629001 | 2020-10-14 | Carroll | Illinois | 17015 | 293 | 6 |
625758 | 625758 | 2020-10-13 | Carroll | Illinois | 17015 | 287 | 6 |
622516 | 622516 | 2020-10-12 | Carroll | Illinois | 17015 | 277 | 6 |
619272 | 619272 | 2020-10-11 | Carroll | Illinois | 17015 | 274 | 6 |
616030 | 616030 | 2020-10-10 | Carroll | Illinois | 17015 | 266 | 6 |
612789 | 612789 | 2020-10-09 | Carroll | Illinois | 17015 | 261 | 6 |
609547 | 609547 | 2020-10-08 | Carroll | Illinois | 17015 | 259 | 6 |
606304 | 606304 | 2020-10-07 | Carroll | Illinois | 17015 | 252 | 6 |
603062 | 603062 | 2020-10-06 | Carroll | Illinois | 17015 | 251 | 6 |
599819 | 599819 | 2020-10-05 | Carroll | Illinois | 17015 | 245 | 6 |
596577 | 596577 | 2020-10-04 | Carroll | Illinois | 17015 | 243 | 6 |
593335 | 593335 | 2020-10-03 | Carroll | Illinois | 17015 | 242 | 6 |
590094 | 590094 | 2020-10-02 | Carroll | Illinois | 17015 | 243 | 6 |
586853 | 586853 | 2020-10-01 | Carroll | Illinois | 17015 | 242 | 6 |
583613 | 583613 | 2020-09-30 | Carroll | Illinois | 17015 | 238 | 6 |
580374 | 580374 | 2020-09-29 | Carroll | Illinois | 17015 | 233 | 5 |
577133 | 577133 | 2020-09-28 | Carroll | Illinois | 17015 | 235 | 5 |
573891 | 573891 | 2020-09-27 | Carroll | Illinois | 17015 | 230 | 5 |
570648 | 570648 | 2020-09-26 | Carroll | Illinois | 17015 | 227 | 4 |
567406 | 567406 | 2020-09-25 | Carroll | Illinois | 17015 | 228 | 4 |
564166 | 564166 | 2020-09-24 | Carroll | Illinois | 17015 | 218 | 4 |
560926 | 560926 | 2020-09-23 | Carroll | Illinois | 17015 | 217 | 4 |
557690 | 557690 | 2020-09-22 | Carroll | Illinois | 17015 | 212 | 4 |
554453 | 554453 | 2020-09-21 | Carroll | Illinois | 17015 | 204 | 4 |
551214 | 551214 | 2020-09-20 | Carroll | Illinois | 17015 | 204 | 4 |
547975 | 547975 | 2020-09-19 | Carroll | Illinois | 17015 | 204 | 4 |
544737 | 544737 | 2020-09-18 | Carroll | Illinois | 17015 | 202 | 4 |
541501 | 541501 | 2020-09-17 | Carroll | Illinois | 17015 | 200 | 4 |
538264 | 538264 | 2020-09-16 | Carroll | Illinois | 17015 | 198 | 4 |
535028 | 535028 | 2020-09-15 | Carroll | Illinois | 17015 | 195 | 4 |
531793 | 531793 | 2020-09-14 | Carroll | Illinois | 17015 | 194 | 4 |
528556 | 528556 | 2020-09-13 | Carroll | Illinois | 17015 | 159 | 4 |
525320 | 525320 | 2020-09-12 | Carroll | Illinois | 17015 | 158 | 4 |
522084 | 522084 | 2020-09-11 | Carroll | Illinois | 17015 | 157 | 4 |
518847 | 518847 | 2020-09-10 | Carroll | Illinois | 17015 | 156 | 4 |
515612 | 515612 | 2020-09-09 | Carroll | Illinois | 17015 | 151 | 4 |
512379 | 512379 | 2020-09-08 | Carroll | Illinois | 17015 | 150 | 4 |
509146 | 509146 | 2020-09-07 | Carroll | Illinois | 17015 | 149 | 4 |
505914 | 505914 | 2020-09-06 | Carroll | Illinois | 17015 | 148 | 4 |
502680 | 502680 | 2020-09-05 | Carroll | Illinois | 17015 | 148 | 4 |
499446 | 499446 | 2020-09-04 | Carroll | Illinois | 17015 | 146 | 4 |
496213 | 496213 | 2020-09-03 | Carroll | Illinois | 17015 | 138 | 4 |
492979 | 492979 | 2020-09-02 | Carroll | Illinois | 17015 | 138 | 4 |
489746 | 489746 | 2020-09-01 | Carroll | Illinois | 17015 | 135 | 4 |
486513 | 486513 | 2020-08-31 | Carroll | Illinois | 17015 | 134 | 4 |
483278 | 483278 | 2020-08-30 | Carroll | Illinois | 17015 | 133 | 4 |
480044 | 480044 | 2020-08-29 | Carroll | Illinois | 17015 | 132 | 4 |
476811 | 476811 | 2020-08-28 | Carroll | Illinois | 17015 | 131 | 4 |
473578 | 473578 | 2020-08-27 | Carroll | Illinois | 17015 | 125 | 4 |
470346 | 470346 | 2020-08-26 | Carroll | Illinois | 17015 | 115 | 4 |
467117 | 467117 | 2020-08-25 | Carroll | Illinois | 17015 | 113 | 4 |
463888 | 463888 | 2020-08-24 | Carroll | Illinois | 17015 | 115 | 4 |
460659 | 460659 | 2020-08-23 | Carroll | Illinois | 17015 | 114 | 4 |
457432 | 457432 | 2020-08-22 | Carroll | Illinois | 17015 | 111 | 4 |
454204 | 454204 | 2020-08-21 | Carroll | Illinois | 17015 | 104 | 4 |
450976 | 450976 | 2020-08-20 | Carroll | Illinois | 17015 | 97 | 4 |
447748 | 447748 | 2020-08-19 | Carroll | Illinois | 17015 | 94 | 4 |
444521 | 444521 | 2020-08-18 | Carroll | Illinois | 17015 | 92 | 4 |
441295 | 441295 | 2020-08-17 | Carroll | Illinois | 17015 | 89 | 4 |
438069 | 438069 | 2020-08-16 | Carroll | Illinois | 17015 | 84 | 4 |
434843 | 434843 | 2020-08-15 | Carroll | Illinois | 17015 | 79 | 4 |
431618 | 431618 | 2020-08-14 | Carroll | Illinois | 17015 | 72 | 4 |
428390 | 428390 | 2020-08-13 | Carroll | Illinois | 17015 | 68 | 4 |
425166 | 425166 | 2020-08-12 | Carroll | Illinois | 17015 | 64 | 4 |
421945 | 421945 | 2020-08-11 | Carroll | Illinois | 17015 | 61 | 4 |
418722 | 418722 | 2020-08-10 | Carroll | Illinois | 17015 | 59 | 4 |
415501 | 415501 | 2020-08-09 | Carroll | Illinois | 17015 | 56 | 4 |
412281 | 412281 | 2020-08-08 | Carroll | Illinois | 17015 | 54 | 4 |
409062 | 409062 | 2020-08-07 | Carroll | Illinois | 17015 | 50 | 4 |
405842 | 405842 | 2020-08-06 | Carroll | Illinois | 17015 | 48 | 4 |
402624 | 402624 | 2020-08-05 | Carroll | Illinois | 17015 | 46 | 4 |
399408 | 399408 | 2020-08-04 | Carroll | Illinois | 17015 | 46 | 3 |
396192 | 396192 | 2020-08-03 | Carroll | Illinois | 17015 | 46 | 3 |
392976 | 392976 | 2020-08-02 | Carroll | Illinois | 17015 | 45 | 3 |
389759 | 389759 | 2020-08-01 | Carroll | Illinois | 17015 | 44 | 3 |
386542 | 386542 | 2020-07-31 | Carroll | Illinois | 17015 | 43 | 3 |
383324 | 383324 | 2020-07-30 | Carroll | Illinois | 17015 | 43 | 3 |
380107 | 380107 | 2020-07-29 | Carroll | Illinois | 17015 | 39 | 3 |
376890 | 376890 | 2020-07-28 | Carroll | Illinois | 17015 | 36 | 2 |
373675 | 373675 | 2020-07-27 | Carroll | Illinois | 17015 | 35 | 2 |
370463 | 370463 | 2020-07-26 | Carroll | Illinois | 17015 | 33 | 2 |
367253 | 367253 | 2020-07-25 | Carroll | Illinois | 17015 | 29 | 2 |
364046 | 364046 | 2020-07-24 | Carroll | Illinois | 17015 | 29 | 2 |
360839 | 360839 | 2020-07-23 | Carroll | Illinois | 17015 | 27 | 2 |
357634 | 357634 | 2020-07-22 | Carroll | Illinois | 17015 | 24 | 2 |
354432 | 354432 | 2020-07-21 | Carroll | Illinois | 17015 | 24 | 2 |
351230 | 351230 | 2020-07-20 | Carroll | Illinois | 17015 | 23 | 2 |
348030 | 348030 | 2020-07-19 | Carroll | Illinois | 17015 | 23 | 2 |
344829 | 344829 | 2020-07-18 | Carroll | Illinois | 17015 | 24 | 2 |
341629 | 341629 | 2020-07-17 | Carroll | Illinois | 17015 | 22 | 2 |
338433 | 338433 | 2020-07-16 | Carroll | Illinois | 17015 | 21 | 2 |
335237 | 335237 | 2020-07-15 | Carroll | Illinois | 17015 | 21 | 2 |
332044 | 332044 | 2020-07-14 | Carroll | Illinois | 17015 | 21 | 2 |
328857 | 328857 | 2020-07-13 | Carroll | Illinois | 17015 | 21 | 2 |
325671 | 325671 | 2020-07-12 | Carroll | Illinois | 17015 | 21 | 2 |
322490 | 322490 | 2020-07-11 | Carroll | Illinois | 17015 | 20 | 2 |
319311 | 319311 | 2020-07-10 | Carroll | Illinois | 17015 | 21 | 2 |
316138 | 316138 | 2020-07-09 | Carroll | Illinois | 17015 | 21 | 2 |
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);