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 = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635905 | 635905 | 2020-10-16 | Carroll | Kentucky | 21041 | 208 | 5 |
632659 | 632659 | 2020-10-15 | Carroll | Kentucky | 21041 | 207 | 5 |
629415 | 629415 | 2020-10-14 | Carroll | Kentucky | 21041 | 206 | 5 |
626171 | 626171 | 2020-10-13 | Carroll | Kentucky | 21041 | 207 | 5 |
622929 | 622929 | 2020-10-12 | Carroll | Kentucky | 21041 | 209 | 5 |
619685 | 619685 | 2020-10-11 | Carroll | Kentucky | 21041 | 209 | 5 |
616443 | 616443 | 2020-10-10 | Carroll | Kentucky | 21041 | 207 | 5 |
613202 | 613202 | 2020-10-09 | Carroll | Kentucky | 21041 | 206 | 5 |
609960 | 609960 | 2020-10-08 | Carroll | Kentucky | 21041 | 203 | 5 |
606718 | 606718 | 2020-10-07 | Carroll | Kentucky | 21041 | 203 | 5 |
603476 | 603476 | 2020-10-06 | Carroll | Kentucky | 21041 | 203 | 5 |
600233 | 600233 | 2020-10-05 | Carroll | Kentucky | 21041 | 203 | 5 |
596991 | 596991 | 2020-10-04 | Carroll | Kentucky | 21041 | 203 | 5 |
593749 | 593749 | 2020-10-03 | Carroll | Kentucky | 21041 | 203 | 5 |
590508 | 590508 | 2020-10-02 | Carroll | Kentucky | 21041 | 202 | 5 |
587267 | 587267 | 2020-10-01 | Carroll | Kentucky | 21041 | 202 | 5 |
584027 | 584027 | 2020-09-30 | Carroll | Kentucky | 21041 | 202 | 5 |
580787 | 580787 | 2020-09-29 | Carroll | Kentucky | 21041 | 201 | 5 |
577546 | 577546 | 2020-09-28 | Carroll | Kentucky | 21041 | 199 | 5 |
574304 | 574304 | 2020-09-27 | Carroll | Kentucky | 21041 | 199 | 5 |
571061 | 571061 | 2020-09-26 | Carroll | Kentucky | 21041 | 199 | 5 |
567819 | 567819 | 2020-09-25 | Carroll | Kentucky | 21041 | 199 | 5 |
564579 | 564579 | 2020-09-24 | Carroll | Kentucky | 21041 | 196 | 5 |
561339 | 561339 | 2020-09-23 | Carroll | Kentucky | 21041 | 196 | 5 |
558103 | 558103 | 2020-09-22 | Carroll | Kentucky | 21041 | 195 | 5 |
554866 | 554866 | 2020-09-21 | Carroll | Kentucky | 21041 | 195 | 5 |
551627 | 551627 | 2020-09-20 | Carroll | Kentucky | 21041 | 195 | 5 |
548388 | 548388 | 2020-09-19 | Carroll | Kentucky | 21041 | 195 | 5 |
545150 | 545150 | 2020-09-18 | Carroll | Kentucky | 21041 | 195 | 5 |
541914 | 541914 | 2020-09-17 | Carroll | Kentucky | 21041 | 195 | 5 |
538678 | 538678 | 2020-09-16 | Carroll | Kentucky | 21041 | 195 | 5 |
535441 | 535441 | 2020-09-15 | Carroll | Kentucky | 21041 | 195 | 5 |
532206 | 532206 | 2020-09-14 | Carroll | Kentucky | 21041 | 195 | 5 |
528969 | 528969 | 2020-09-13 | Carroll | Kentucky | 21041 | 195 | 5 |
525733 | 525733 | 2020-09-12 | Carroll | Kentucky | 21041 | 195 | 5 |
522497 | 522497 | 2020-09-11 | Carroll | Kentucky | 21041 | 194 | 5 |
519260 | 519260 | 2020-09-10 | Carroll | Kentucky | 21041 | 194 | 5 |
516025 | 516025 | 2020-09-09 | Carroll | Kentucky | 21041 | 194 | 5 |
512792 | 512792 | 2020-09-08 | Carroll | Kentucky | 21041 | 195 | 5 |
509560 | 509560 | 2020-09-07 | Carroll | Kentucky | 21041 | 195 | 5 |
506327 | 506327 | 2020-09-06 | Carroll | Kentucky | 21041 | 195 | 5 |
503093 | 503093 | 2020-09-05 | Carroll | Kentucky | 21041 | 195 | 5 |
499860 | 499860 | 2020-09-04 | Carroll | Kentucky | 21041 | 194 | 5 |
496626 | 496626 | 2020-09-03 | Carroll | Kentucky | 21041 | 193 | 4 |
493393 | 493393 | 2020-09-02 | Carroll | Kentucky | 21041 | 191 | 4 |
490159 | 490159 | 2020-09-01 | Carroll | Kentucky | 21041 | 192 | 4 |
486926 | 486926 | 2020-08-31 | Carroll | Kentucky | 21041 | 189 | 3 |
483691 | 483691 | 2020-08-30 | Carroll | Kentucky | 21041 | 191 | 3 |
480457 | 480457 | 2020-08-29 | Carroll | Kentucky | 21041 | 191 | 3 |
477224 | 477224 | 2020-08-28 | Carroll | Kentucky | 21041 | 190 | 3 |
473991 | 473991 | 2020-08-27 | Carroll | Kentucky | 21041 | 190 | 2 |
470759 | 470759 | 2020-08-26 | Carroll | Kentucky | 21041 | 188 | 2 |
467530 | 467530 | 2020-08-25 | Carroll | Kentucky | 21041 | 187 | 2 |
464301 | 464301 | 2020-08-24 | Carroll | Kentucky | 21041 | 187 | 2 |
461070 | 461070 | 2020-08-23 | Carroll | Kentucky | 21041 | 184 | 2 |
457843 | 457843 | 2020-08-22 | Carroll | Kentucky | 21041 | 184 | 2 |
454615 | 454615 | 2020-08-21 | Carroll | Kentucky | 21041 | 175 | 2 |
451387 | 451387 | 2020-08-20 | Carroll | Kentucky | 21041 | 175 | 2 |
448159 | 448159 | 2020-08-19 | Carroll | Kentucky | 21041 | 170 | 2 |
444932 | 444932 | 2020-08-18 | Carroll | Kentucky | 21041 | 170 | 2 |
441706 | 441706 | 2020-08-17 | Carroll | Kentucky | 21041 | 170 | 2 |
438479 | 438479 | 2020-08-16 | Carroll | Kentucky | 21041 | 170 | 2 |
435254 | 435254 | 2020-08-15 | Carroll | Kentucky | 21041 | 170 | 2 |
432029 | 432029 | 2020-08-14 | Carroll | Kentucky | 21041 | 170 | 2 |
428801 | 428801 | 2020-08-13 | Carroll | Kentucky | 21041 | 164 | 2 |
425577 | 425577 | 2020-08-12 | Carroll | Kentucky | 21041 | 164 | 2 |
422356 | 422356 | 2020-08-11 | Carroll | Kentucky | 21041 | 159 | 2 |
419134 | 419134 | 2020-08-10 | Carroll | Kentucky | 21041 | 158 | 2 |
415913 | 415913 | 2020-08-09 | Carroll | Kentucky | 21041 | 158 | 2 |
412693 | 412693 | 2020-08-08 | Carroll | Kentucky | 21041 | 158 | 2 |
409473 | 409473 | 2020-08-07 | Carroll | Kentucky | 21041 | 150 | 2 |
406253 | 406253 | 2020-08-06 | Carroll | Kentucky | 21041 | 150 | 2 |
403035 | 403035 | 2020-08-05 | Carroll | Kentucky | 21041 | 148 | 2 |
399818 | 399818 | 2020-08-04 | Carroll | Kentucky | 21041 | 145 | 2 |
396603 | 396603 | 2020-08-03 | Carroll | Kentucky | 21041 | 142 | 2 |
393387 | 393387 | 2020-08-02 | Carroll | Kentucky | 21041 | 141 | 2 |
390170 | 390170 | 2020-08-01 | Carroll | Kentucky | 21041 | 140 | 2 |
386953 | 386953 | 2020-07-31 | Carroll | Kentucky | 21041 | 140 | 2 |
383735 | 383735 | 2020-07-30 | Carroll | Kentucky | 21041 | 138 | 2 |
380518 | 380518 | 2020-07-29 | Carroll | Kentucky | 21041 | 136 | 2 |
377301 | 377301 | 2020-07-28 | Carroll | Kentucky | 21041 | 135 | 2 |
374086 | 374086 | 2020-07-27 | Carroll | Kentucky | 21041 | 134 | 2 |
370874 | 370874 | 2020-07-26 | Carroll | Kentucky | 21041 | 134 | 2 |
367664 | 367664 | 2020-07-25 | Carroll | Kentucky | 21041 | 134 | 2 |
364457 | 364457 | 2020-07-24 | Carroll | Kentucky | 21041 | 134 | 2 |
361250 | 361250 | 2020-07-23 | Carroll | Kentucky | 21041 | 133 | 2 |
358045 | 358045 | 2020-07-22 | Carroll | Kentucky | 21041 | 128 | 2 |
354842 | 354842 | 2020-07-21 | Carroll | Kentucky | 21041 | 125 | 2 |
351640 | 351640 | 2020-07-20 | Carroll | Kentucky | 21041 | 125 | 2 |
348440 | 348440 | 2020-07-19 | Carroll | Kentucky | 21041 | 126 | 2 |
345239 | 345239 | 2020-07-18 | Carroll | Kentucky | 21041 | 106 | 2 |
342039 | 342039 | 2020-07-17 | Carroll | Kentucky | 21041 | 100 | 2 |
338843 | 338843 | 2020-07-16 | Carroll | Kentucky | 21041 | 97 | 1 |
335647 | 335647 | 2020-07-15 | Carroll | Kentucky | 21041 | 96 | 1 |
332454 | 332454 | 2020-07-14 | Carroll | Kentucky | 21041 | 88 | 1 |
329267 | 329267 | 2020-07-13 | Carroll | Kentucky | 21041 | 85 | 1 |
326081 | 326081 | 2020-07-12 | Carroll | Kentucky | 21041 | 85 | 1 |
322898 | 322898 | 2020-07-11 | Carroll | Kentucky | 21041 | 77 | 1 |
319719 | 319719 | 2020-07-10 | Carroll | Kentucky | 21041 | 69 | 1 |
316544 | 316544 | 2020-07-09 | Carroll | Kentucky | 21041 | 65 | 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);