ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where cases = 136 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
876103 | 876103 | 2020-12-29 | Robertson | Kentucky | 21201 | 136 | 5 |
791705 | 791705 | 2020-12-03 | Menifee | Kentucky | 21165 | 136 | 1 |
788460 | 788460 | 2020-12-02 | Menifee | Kentucky | 21165 | 136 | 1 |
746298 | 746298 | 2020-11-19 | Trimble | Kentucky | 21223 | 136 | 0 |
681313 | 681313 | 2020-10-30 | Bath | Kentucky | 21011 | 136 | 1 |
681373 | 681373 | 2020-10-30 | Leslie | Kentucky | 21131 | 136 | 1 |
655457 | 655457 | 2020-10-22 | Powell | Kentucky | 21197 | 136 | 0 |
613259 | 613259 | 2020-10-09 | Mason | Kentucky | 21161 | 136 | 2 |
577539 | 577539 | 2020-09-28 | Breckinridge | Kentucky | 21027 | 136 | 2 |
574297 | 574297 | 2020-09-27 | Breckinridge | Kentucky | 21027 | 136 | 2 |
571054 | 571054 | 2020-09-26 | Breckinridge | Kentucky | 21027 | 136 | 2 |
545167 | 545167 | 2020-09-18 | Fulton | Kentucky | 21075 | 136 | 2 |
538660 | 538660 | 2020-09-16 | Anderson | Kentucky | 21005 | 136 | 1 |
535478 | 535478 | 2020-09-15 | Johnson | Kentucky | 21115 | 136 | 1 |
532243 | 532243 | 2020-09-14 | Johnson | Kentucky | 21115 | 136 | 1 |
529006 | 529006 | 2020-09-13 | Johnson | Kentucky | 21115 | 136 | 1 |
529065 | 529065 | 2020-09-13 | Webster | Kentucky | 21233 | 136 | 2 |
525770 | 525770 | 2020-09-12 | Johnson | Kentucky | 21115 | 136 | 1 |
525829 | 525829 | 2020-09-12 | Webster | Kentucky | 21233 | 136 | 2 |
516035 | 516035 | 2020-09-09 | Edmonson | Kentucky | 21061 | 136 | 12 |
477244 | 477244 | 2020-08-28 | Grant | Kentucky | 21081 | 136 | 6 |
470782 | 470782 | 2020-08-26 | Green | Kentucky | 21087 | 136 | 6 |
464316 | 464316 | 2020-08-24 | Floyd | Kentucky | 21071 | 136 | 2 |
461131 | 461131 | 2020-08-23 | Meade | Kentucky | 21163 | 136 | 3 |
457904 | 457904 | 2020-08-22 | Meade | Kentucky | 21163 | 136 | 3 |
454676 | 454676 | 2020-08-21 | Meade | Kentucky | 21163 | 136 | 3 |
432060 | 432060 | 2020-08-14 | Henry | Kentucky | 21103 | 136 | 1 |
428888 | 428888 | 2020-08-13 | Spencer | Kentucky | 21215 | 136 | 0 |
416001 | 416001 | 2020-08-09 | Taylor | Kentucky | 21217 | 136 | 2 |
393484 | 393484 | 2020-08-02 | Whitley | Kentucky | 21235 | 136 | 1 |
383821 | 383821 | 2020-07-30 | Simpson | Kentucky | 21213 | 136 | 6 |
380518 | 380518 | 2020-07-29 | Carroll | Kentucky | 21041 | 136 | 2 |
377306 | 377306 | 2020-07-28 | Clay | Kentucky | 21051 | 136 | 4 |
342123 | 342123 | 2020-07-17 | Scott | Kentucky | 21209 | 136 | 0 |
307012 | 307012 | 2020-07-06 | Adair | Kentucky | 21001 | 136 | 19 |
269233 | 269233 | 2020-06-24 | Hardin | Kentucky | 21093 | 136 | 5 |
247339 | 247339 | 2020-06-17 | Bullitt | Kentucky | 21029 | 136 | 4 |
241102 | 241102 | 2020-06-15 | Allen | Kentucky | 21003 | 136 | 4 |
231822 | 231822 | 2020-06-12 | Grayson | Kentucky | 21085 | 136 | 10 |
185617 | 185617 | 2020-05-28 | Logan | Kentucky | 21141 | 136 | 3 |
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);