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

46 rows where date = "2020-03-27" and state = "Kentucky" sorted by date descending

✎ View and edit SQL

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

Suggested facets: cases, deaths, date (date)

state 1

  • Kentucky · 46 ✖
Link rowid date ▲ county state fips cases deaths
14610 14610 2020-03-27 Allen Kentucky 21003 1 0
14611 14611 2020-03-27 Anderson Kentucky 21005 2 1
14612 14612 2020-03-27 Boone Kentucky 21015 3 0
14613 14613 2020-03-27 Bourbon Kentucky 21017 2 1
14614 14614 2020-03-27 Breathitt Kentucky 21025 2 0
14615 14615 2020-03-27 Bullitt Kentucky 21029 2 0
14616 14616 2020-03-27 Calloway Kentucky 21035 2 0
14617 14617 2020-03-27 Campbell Kentucky 21037 2 0
14618 14618 2020-03-27 Christian Kentucky 21047 6 0
14619 14619 2020-03-27 Clark Kentucky 21049 5 0
14620 14620 2020-03-27 Daviess Kentucky 21059 15 0
14621 14621 2020-03-27 Fayette Kentucky 21067 37 1
14622 14622 2020-03-27 Franklin Kentucky 21073 3 0
14623 14623 2020-03-27 Grayson Kentucky 21085 2 0
14624 14624 2020-03-27 Hardin Kentucky 21093 5 0
14625 14625 2020-03-27 Harrison Kentucky 21097 11 0
14626 14626 2020-03-27 Henderson Kentucky 21101 5 0
14627 14627 2020-03-27 Hopkins Kentucky 21107 1 1
14628 14628 2020-03-27 Jefferson Kentucky 21111 76 4
14629 14629 2020-03-27 Jessamine Kentucky 21113 10 0
14630 14630 2020-03-27 Kenton Kentucky 21117 15 0
14631 14631 2020-03-27 Larue Kentucky 21123 1 0
14632 14632 2020-03-27 Laurel Kentucky 21125 1 0
14633 14633 2020-03-27 Logan Kentucky 21141 2 0
14634 14634 2020-03-27 Lyon Kentucky 21143 1 0
14635 14635 2020-03-27 Madison Kentucky 21151 5 0
14636 14636 2020-03-27 Martin Kentucky 21159 1 0
14637 14637 2020-03-27 Mason Kentucky 21161 1 0
14638 14638 2020-03-27 McCracken Kentucky 21145 2 0
14639 14639 2020-03-27 McCreary Kentucky 21147 1 0
14640 14640 2020-03-27 Menifee Kentucky 21165 2 0
14641 14641 2020-03-27 Mercer Kentucky 21167 1 0
14642 14642 2020-03-27 Montgomery Kentucky 21173 2 0
14643 14643 2020-03-27 Muhlenberg Kentucky 21177 2 0
14644 14644 2020-03-27 Nelson Kentucky 21179 2 0
14645 14645 2020-03-27 Oldham Kentucky 21185 3 0
14646 14646 2020-03-27 Pulaski Kentucky 21199 7 0
14647 14647 2020-03-27 Scott Kentucky 21209 3 0
14648 14648 2020-03-27 Simpson Kentucky 21213 2 0
14649 14649 2020-03-27 Spencer Kentucky 21215 1 0
14650 14650 2020-03-27 Union Kentucky 21225 1 0
14651 14651 2020-03-27 Unknown Kentucky   41 0
14652 14652 2020-03-27 Warren Kentucky 21227 8 0
14653 14653 2020-03-27 Wayne Kentucky 21231 1 0
14654 14654 2020-03-27 Webster Kentucky 21233 1 0
14655 14655 2020-03-27 Woodford Kentucky 21239 3 0

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