ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42 rows where cases = 225 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 30
county 30
- Hopkins 7
- Clay 2
- Hickman 2
- Lincoln 2
- Marion 2
- Robertson 2
- Spencer 2
- Anderson 1
- Ballard 1
- Boyle 1
- Campbell 1
- Christian 1
- Clinton 1
- Crittenden 1
- Fleming 1
- Gallatin 1
- Grant 1
- Greenup 1
- Henry 1
- Laurel 1
- Marshall 1
- McCreary 1
- Monroe 1
- Nicholas 1
- Pulaski 1
- Russell 1
- Simpson 1
- Trigg 1
- Trimble 1
- Washington 1
state 1
- Kentucky · 42 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1281891 | 1281891 | 2021-05-03 | Robertson | Kentucky | 21201 | 225 | 14 |
1278644 | 1278644 | 2021-05-02 | Robertson | Kentucky | 21201 | 225 | 14 |
892282 | 892282 | 2021-01-03 | Hickman | Kentucky | 21105 | 225 | 5 |
889036 | 889036 | 2021-01-02 | Hickman | Kentucky | 21105 | 225 | 5 |
866271 | 866271 | 2020-12-26 | Ballard | Kentucky | 21007 | 225 | 2 |
843642 | 843642 | 2020-12-19 | Nicholas | Kentucky | 21181 | 225 | 3 |
807959 | 807959 | 2020-12-08 | Trimble | Kentucky | 21223 | 225 | 0 |
775436 | 775436 | 2020-11-28 | Gallatin | Kentucky | 21077 | 225 | 9 |
762444 | 762444 | 2020-11-24 | Crittenden | Kentucky | 21055 | 225 | 1 |
707288 | 707288 | 2020-11-07 | Fleming | Kentucky | 21069 | 225 | 0 |
665207 | 665207 | 2020-10-25 | Washington | Kentucky | 21229 | 225 | 2 |
655399 | 655399 | 2020-10-22 | Grant | Kentucky | 21081 | 225 | 6 |
652140 | 652140 | 2020-10-21 | Clinton | Kentucky | 21053 | 225 | 4 |
648871 | 648871 | 2020-10-20 | Anderson | Kentucky | 21005 | 225 | 1 |
639241 | 639241 | 2020-10-17 | Trigg | Kentucky | 21221 | 225 | 0 |
635936 | 635936 | 2020-10-16 | Henry | Kentucky | 21103 | 225 | 2 |
619744 | 619744 | 2020-10-11 | McCreary | Kentucky | 21147 | 225 | 1 |
610025 | 610025 | 2020-10-08 | Monroe | Kentucky | 21171 | 225 | 4 |
600320 | 600320 | 2020-10-05 | Spencer | Kentucky | 21215 | 225 | 0 |
597039 | 597039 | 2020-10-04 | Lincoln | Kentucky | 21137 | 225 | 15 |
597078 | 597078 | 2020-10-04 | Spencer | Kentucky | 21215 | 225 | 0 |
593797 | 593797 | 2020-10-03 | Lincoln | Kentucky | 21137 | 225 | 15 |
571115 | 571115 | 2020-09-26 | Marion | Kentucky | 21155 | 225 | 10 |
567873 | 567873 | 2020-09-25 | Marion | Kentucky | 21155 | 225 | 10 |
519250 | 519250 | 2020-09-10 | Boyle | Kentucky | 21021 | 225 | 0 |
519315 | 519315 | 2020-09-10 | Marshall | Kentucky | 21157 | 225 | 2 |
519343 | 519343 | 2020-09-10 | Russell | Kentucky | 21207 | 225 | 6 |
499865 | 499865 | 2020-09-04 | Clay | Kentucky | 21051 | 225 | 6 |
496631 | 496631 | 2020-09-03 | Clay | Kentucky | 21051 | 225 | 6 |
493417 | 493417 | 2020-09-02 | Greenup | Kentucky | 21089 | 225 | 2 |
490245 | 490245 | 2020-09-01 | Simpson | Kentucky | 21213 | 225 | 7 |
370953 | 370953 | 2020-07-26 | Pulaski | Kentucky | 21199 | 225 | 2 |
342081 | 342081 | 2020-07-17 | Laurel | Kentucky | 21125 | 225 | 4 |
272346 | 272346 | 2020-06-25 | Christian | Kentucky | 21047 | 225 | 4 |
256690 | 256690 | 2020-06-20 | Campbell | Kentucky | 21037 | 225 | 12 |
222531 | 222531 | 2020-06-09 | Hopkins | Kentucky | 21107 | 225 | 32 |
219436 | 219436 | 2020-06-08 | Hopkins | Kentucky | 21107 | 225 | 32 |
216344 | 216344 | 2020-06-07 | Hopkins | Kentucky | 21107 | 225 | 32 |
213257 | 213257 | 2020-06-06 | Hopkins | Kentucky | 21107 | 225 | 32 |
210172 | 210172 | 2020-06-05 | Hopkins | Kentucky | 21107 | 225 | 32 |
207091 | 207091 | 2020-06-04 | Hopkins | Kentucky | 21107 | 225 | 32 |
204010 | 204010 | 2020-06-03 | Hopkins | Kentucky | 21107 | 225 | 32 |
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);