ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

66 rows where cases = 94 and state = "Kentucky" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • Kentucky · 66 ✖
Link rowid date ▲ county state fips cases deaths
691122 691122 2020-11-02 Menifee Kentucky 21165 94 1
671673 671673 2020-10-27 Owsley Kentucky 21189 94 1
642449 642449 2020-10-18 Lyon Kentucky 21143 94 4
622914 622914 2020-10-12 Bath Kentucky 21011 94 1
619670 619670 2020-10-11 Bath Kentucky 21011 94 1
616428 616428 2020-10-10 Bath Kentucky 21011 94 1
613187 613187 2020-10-09 Bath Kentucky 21011 94 1
609945 609945 2020-10-08 Bath Kentucky 21011 94 1
606774 606774 2020-10-07 Martin Kentucky 21159 94 3
600258 600258 2020-10-05 Hancock Kentucky 21091 94 0
600282 600282 2020-10-05 Livingston Kentucky 21139 94 1
597040 597040 2020-10-04 Livingston Kentucky 21139 94 1
571139 571139 2020-09-26 Powell Kentucky 21197 94 0
528987 528987 2020-09-13 Gallatin Kentucky 21077 94 8
529015 529015 2020-09-13 Letcher Kentucky 21133 94 2
522503 522503 2020-09-11 Clinton Kentucky 21053 94 2
519267 519267 2020-09-10 Crittenden Kentucky 21055 94 1
519324 519324 2020-09-10 Metcalfe Kentucky 21169 94 2
516021 516021 2020-09-09 Caldwell Kentucky 21033 94 0
503132 503132 2020-09-05 Knott Kentucky 21119 94 1
493483 493483 2020-09-02 Trigg Kentucky 21221 94 0
477319 477319 2020-08-28 Wayne Kentucky 21231 94 0
474083 474083 2020-08-27 Union Kentucky 21225 94 1
474086 474086 2020-08-27 Wayne Kentucky 21231 94 0
444914 444914 2020-08-18 Anderson Kentucky 21005 94 1
428789 428789 2020-08-13 Bourbon Kentucky 21017 94 1
425565 425565 2020-08-12 Bourbon Kentucky 21017 94 1
422421 422421 2020-08-11 Monroe Kentucky 21171 94 2
419199 419199 2020-08-10 Monroe Kentucky 21171 94 2
415978 415978 2020-08-09 Monroe Kentucky 21171 94 2
412708 412708 2020-08-08 Floyd Kentucky 21071 94 2
412758 412758 2020-08-08 Monroe Kentucky 21171 94 2
409488 409488 2020-08-07 Floyd Kentucky 21071 94 2
399842 399842 2020-08-04 Greenup Kentucky 21089 94 1
396634 396634 2020-08-03 Henry Kentucky 21103 94 2
393397 393397 2020-08-02 Edmonson Kentucky 21061 94 12
393416 393416 2020-08-02 Hart Kentucky 21099 94 0
390180 390180 2020-08-01 Edmonson Kentucky 21061 94 12
390199 390199 2020-08-01 Hart Kentucky 21099 94 0
386954 386954 2020-07-31 Carter Kentucky 21043 94 1
386963 386963 2020-07-31 Edmonson Kentucky 21061 94 12
386982 386982 2020-07-31 Hart Kentucky 21099 94 0
387040 387040 2020-07-31 Spencer Kentucky 21215 94 0
377355 377355 2020-07-28 Marion Kentucky 21155 94 0
374174 374174 2020-07-27 Taylor Kentucky 21217 94 1
370971 370971 2020-07-26 Whitley Kentucky 21235 94 1
367747 367747 2020-07-25 Russell Kentucky 21207 94 5
364447 364447 2020-07-24 Boyle Kentucky 21021 94 0
364523 364523 2020-07-24 Montgomery Kentucky 21173 94 0
354897 354897 2020-07-21 Marshall Kentucky 21157 94 2
338929 338929 2020-07-16 Simpson Kentucky 21213 94 3
326083 326083 2020-07-12 Casey Kentucky 21045 94 2
326121 326121 2020-07-12 Knox Kentucky 21121 94 5
322938 322938 2020-07-11 Knox Kentucky 21121 94 5
310197 310197 2020-07-07 Calloway Kentucky 21035 94 1
291306 291306 2020-07-01 Pulaski Kentucky 21199 94 2
288156 288156 2020-06-30 Pulaski Kentucky 21199 94 2
285007 285007 2020-06-29 Pulaski Kentucky 21199 94 2
269211 269211 2020-06-24 Clark Kentucky 21049 94 4
269241 269241 2020-06-24 Jackson Kentucky 21109 94 13
259870 259870 2020-06-21 Madison Kentucky 21151 94 1
256744 256744 2020-06-20 Madison Kentucky 21151 94 1
161217 161217 2020-05-20 Adair Kentucky 21001 94 17
158192 158192 2020-05-19 Adair Kentucky 21001 94 17
155242 155242 2020-05-18 Logan Kentucky 21141 94 3
82156 82156 2020-04-23 Boone Kentucky 21015 94 2

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);