ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
271 rows where cases = 12 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
600313 | 600313 | 2020-10-05 | Robertson | Kentucky | 21201 | 12 | 1 |
597071 | 597071 | 2020-10-04 | Robertson | Kentucky | 21201 | 12 | 0 |
593829 | 593829 | 2020-10-03 | Robertson | Kentucky | 21201 | 12 | 0 |
590588 | 590588 | 2020-10-02 | Robertson | Kentucky | 21201 | 12 | 0 |
587347 | 587347 | 2020-10-01 | Robertson | Kentucky | 21201 | 12 | 0 |
584107 | 584107 | 2020-09-30 | Robertson | Kentucky | 21201 | 12 | 0 |
580867 | 580867 | 2020-09-29 | Robertson | Kentucky | 21201 | 12 | 0 |
577626 | 577626 | 2020-09-28 | Robertson | Kentucky | 21201 | 12 | 0 |
574384 | 574384 | 2020-09-27 | Robertson | Kentucky | 21201 | 12 | 0 |
571141 | 571141 | 2020-09-26 | Robertson | Kentucky | 21201 | 12 | 0 |
567899 | 567899 | 2020-09-25 | Robertson | Kentucky | 21201 | 12 | 0 |
564659 | 564659 | 2020-09-24 | Robertson | Kentucky | 21201 | 12 | 0 |
561419 | 561419 | 2020-09-23 | Robertson | Kentucky | 21201 | 12 | 0 |
558183 | 558183 | 2020-09-22 | Robertson | Kentucky | 21201 | 12 | 0 |
554946 | 554946 | 2020-09-21 | Robertson | Kentucky | 21201 | 12 | 0 |
551707 | 551707 | 2020-09-20 | Robertson | Kentucky | 21201 | 12 | 0 |
548468 | 548468 | 2020-09-19 | Robertson | Kentucky | 21201 | 12 | 0 |
545230 | 545230 | 2020-09-18 | Robertson | Kentucky | 21201 | 12 | 0 |
541994 | 541994 | 2020-09-17 | Robertson | Kentucky | 21201 | 12 | 0 |
538758 | 538758 | 2020-09-16 | Robertson | Kentucky | 21201 | 12 | 0 |
535521 | 535521 | 2020-09-15 | Robertson | Kentucky | 21201 | 12 | 0 |
532286 | 532286 | 2020-09-14 | Robertson | Kentucky | 21201 | 12 | 0 |
529049 | 529049 | 2020-09-13 | Robertson | Kentucky | 21201 | 12 | 0 |
525813 | 525813 | 2020-09-12 | Robertson | Kentucky | 21201 | 12 | 0 |
496670 | 496670 | 2020-09-03 | Lee | Kentucky | 21129 | 12 | 0 |
490203 | 490203 | 2020-09-01 | Lee | Kentucky | 21129 | 12 | 0 |
486970 | 486970 | 2020-08-31 | Lee | Kentucky | 21129 | 12 | 0 |
483735 | 483735 | 2020-08-30 | Lee | Kentucky | 21129 | 12 | 0 |
474035 | 474035 | 2020-08-27 | Lee | Kentucky | 21129 | 12 | 0 |
470803 | 470803 | 2020-08-26 | Lee | Kentucky | 21129 | 12 | 0 |
422430 | 422430 | 2020-08-11 | Owsley | Kentucky | 21189 | 12 | 0 |
419208 | 419208 | 2020-08-10 | Owsley | Kentucky | 21189 | 12 | 0 |
415987 | 415987 | 2020-08-09 | Owsley | Kentucky | 21189 | 12 | 0 |
406327 | 406327 | 2020-08-06 | Owsley | Kentucky | 21189 | 12 | 0 |
406351 | 406351 | 2020-08-06 | Wolfe | Kentucky | 21237 | 12 | 0 |
403109 | 403109 | 2020-08-05 | Owsley | Kentucky | 21189 | 12 | 0 |
396615 | 396615 | 2020-08-03 | Estill | Kentucky | 21065 | 12 | 0 |
393399 | 393399 | 2020-08-02 | Estill | Kentucky | 21065 | 12 | 0 |
390182 | 390182 | 2020-08-01 | Estill | Kentucky | 21065 | 12 | 0 |
386965 | 386965 | 2020-07-31 | Estill | Kentucky | 21065 | 12 | 0 |
345245 | 345245 | 2020-07-18 | Clinton | Kentucky | 21053 | 12 | 0 |
345271 | 345271 | 2020-07-18 | Hickman | Kentucky | 21105 | 12 | 0 |
342045 | 342045 | 2020-07-17 | Clinton | Kentucky | 21053 | 12 | 0 |
342071 | 342071 | 2020-07-17 | Hickman | Kentucky | 21105 | 12 | 0 |
338849 | 338849 | 2020-07-16 | Clinton | Kentucky | 21053 | 12 | 0 |
338880 | 338880 | 2020-07-16 | Johnson | Kentucky | 21115 | 12 | 0 |
338899 | 338899 | 2020-07-16 | Martin | Kentucky | 21159 | 12 | 0 |
335684 | 335684 | 2020-07-15 | Johnson | Kentucky | 21115 | 12 | 0 |
335692 | 335692 | 2020-07-15 | Leslie | Kentucky | 21131 | 12 | 0 |
335703 | 335703 | 2020-07-15 | Martin | Kentucky | 21159 | 12 | 0 |
332461 | 332461 | 2020-07-14 | Crittenden | Kentucky | 21055 | 12 | 1 |
332491 | 332491 | 2020-07-14 | Johnson | Kentucky | 21115 | 12 | 0 |
332510 | 332510 | 2020-07-14 | Martin | Kentucky | 21159 | 12 | 0 |
332524 | 332524 | 2020-07-14 | Nicholas | Kentucky | 21181 | 12 | 0 |
329274 | 329274 | 2020-07-13 | Crittenden | Kentucky | 21055 | 12 | 1 |
329323 | 329323 | 2020-07-13 | Martin | Kentucky | 21159 | 12 | 0 |
329337 | 329337 | 2020-07-13 | Nicholas | Kentucky | 21181 | 12 | 0 |
326088 | 326088 | 2020-07-12 | Crittenden | Kentucky | 21055 | 12 | 1 |
326137 | 326137 | 2020-07-12 | Martin | Kentucky | 21159 | 12 | 0 |
326151 | 326151 | 2020-07-12 | Nicholas | Kentucky | 21181 | 12 | 0 |
322954 | 322954 | 2020-07-11 | Martin | Kentucky | 21159 | 12 | 0 |
319775 | 319775 | 2020-07-10 | Martin | Kentucky | 21159 | 12 | 0 |
319786 | 319786 | 2020-07-10 | Morgan | Kentucky | 21175 | 12 | 0 |
316536 | 316536 | 2020-07-09 | Breathitt | Kentucky | 21025 | 12 | 0 |
316611 | 316611 | 2020-07-09 | Morgan | Kentucky | 21175 | 12 | 0 |
313362 | 313362 | 2020-07-08 | Breathitt | Kentucky | 21025 | 12 | 0 |
310192 | 310192 | 2020-07-07 | Breathitt | Kentucky | 21025 | 12 | 0 |
310239 | 310239 | 2020-07-07 | Knott | Kentucky | 21119 | 12 | 0 |
278696 | 278696 | 2020-06-27 | Menifee | Kentucky | 21165 | 12 | 0 |
275471 | 275471 | 2020-06-26 | Bath | Kentucky | 21011 | 12 | 1 |
275548 | 275548 | 2020-06-26 | Menifee | Kentucky | 21165 | 12 | 0 |
272405 | 272405 | 2020-06-25 | Menifee | Kentucky | 21165 | 12 | 0 |
269269 | 269269 | 2020-06-24 | Menifee | Kentucky | 21165 | 12 | 0 |
266136 | 266136 | 2020-06-23 | Menifee | Kentucky | 21165 | 12 | 0 |
262961 | 262961 | 2020-06-22 | Fleming | Kentucky | 21069 | 12 | 0 |
263041 | 263041 | 2020-06-22 | Wayne | Kentucky | 21231 | 12 | 0 |
259832 | 259832 | 2020-06-21 | Fleming | Kentucky | 21069 | 12 | 0 |
259912 | 259912 | 2020-06-21 | Wayne | Kentucky | 21231 | 12 | 0 |
256688 | 256688 | 2020-06-20 | Caldwell | Kentucky | 21033 | 12 | 0 |
256706 | 256706 | 2020-06-20 | Fleming | Kentucky | 21069 | 12 | 0 |
256786 | 256786 | 2020-06-20 | Wayne | Kentucky | 21231 | 12 | 0 |
253568 | 253568 | 2020-06-19 | Caldwell | Kentucky | 21033 | 12 | 0 |
253586 | 253586 | 2020-06-19 | Fleming | Kentucky | 21069 | 12 | 0 |
250453 | 250453 | 2020-06-18 | Caldwell | Kentucky | 21033 | 12 | 0 |
250497 | 250497 | 2020-06-18 | Knox | Kentucky | 21121 | 12 | 0 |
247341 | 247341 | 2020-06-17 | Caldwell | Kentucky | 21033 | 12 | 0 |
247362 | 247362 | 2020-06-17 | Fulton | Kentucky | 21075 | 12 | 0 |
247385 | 247385 | 2020-06-17 | Knox | Kentucky | 21121 | 12 | 0 |
244228 | 244228 | 2020-06-16 | Caldwell | Kentucky | 21033 | 12 | 0 |
244249 | 244249 | 2020-06-16 | Fulton | Kentucky | 21075 | 12 | 0 |
244257 | 244257 | 2020-06-16 | Hancock | Kentucky | 21091 | 12 | 0 |
241117 | 241117 | 2020-06-15 | Caldwell | Kentucky | 21033 | 12 | 0 |
241138 | 241138 | 2020-06-15 | Fulton | Kentucky | 21075 | 12 | 0 |
241146 | 241146 | 2020-06-15 | Hancock | Kentucky | 21091 | 12 | 0 |
238008 | 238008 | 2020-06-14 | Caldwell | Kentucky | 21033 | 12 | 0 |
238029 | 238029 | 2020-06-14 | Fulton | Kentucky | 21075 | 12 | 0 |
238037 | 238037 | 2020-06-14 | Hancock | Kentucky | 21091 | 12 | 0 |
234901 | 234901 | 2020-06-13 | Caldwell | Kentucky | 21033 | 12 | 0 |
234922 | 234922 | 2020-06-13 | Fulton | Kentucky | 21075 | 12 | 0 |
231796 | 231796 | 2020-06-12 | Caldwell | Kentucky | 21033 | 12 | 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);