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

34 rows where county = "Shelby", deaths = 109 and fips = 18145 sorted by date descending

✎ View and edit SQL

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

Suggested facets: cases, date (date)

state 1

fips 1

  • 18145 · 34 ✖

county 1

  • Shelby · 34 ✖
Link rowid date ▲ county state fips cases deaths
1664695 1664695 2021-08-29 Shelby Indiana 18145 6662 109
1661447 1661447 2021-08-28 Shelby Indiana 18145 6662 109
1658199 1658199 2021-08-27 Shelby Indiana 18145 6662 109
1654951 1654951 2021-08-26 Shelby Indiana 18145 6604 109
1651704 1651704 2021-08-25 Shelby Indiana 18145 6573 109
1648455 1648455 2021-08-24 Shelby Indiana 18145 6523 109
1645207 1645207 2021-08-23 Shelby Indiana 18145 6498 109
1641958 1641958 2021-08-22 Shelby Indiana 18145 6425 109
1638708 1638708 2021-08-21 Shelby Indiana 18145 6425 109
1635458 1635458 2021-08-20 Shelby Indiana 18145 6425 109
1632208 1632208 2021-08-19 Shelby Indiana 18145 6406 109
1628961 1628961 2021-08-18 Shelby Indiana 18145 6384 109
1625714 1625714 2021-08-17 Shelby Indiana 18145 6363 109
1622467 1622467 2021-08-16 Shelby Indiana 18145 6340 109
1619220 1619220 2021-08-15 Shelby Indiana 18145 6311 109
1615972 1615972 2021-08-14 Shelby Indiana 18145 6311 109
1612723 1612723 2021-08-13 Shelby Indiana 18145 6311 109
1609475 1609475 2021-08-12 Shelby Indiana 18145 6293 109
1606226 1606226 2021-08-11 Shelby Indiana 18145 6279 109
1602977 1602977 2021-08-10 Shelby Indiana 18145 6255 109
1599728 1599728 2021-08-09 Shelby Indiana 18145 6231 109
1596480 1596480 2021-08-08 Shelby Indiana 18145 6209 109
1593231 1593231 2021-08-07 Shelby Indiana 18145 6209 109
1589982 1589982 2021-08-06 Shelby Indiana 18145 6209 109
1586733 1586733 2021-08-05 Shelby Indiana 18145 6198 109
1583483 1583483 2021-08-04 Shelby Indiana 18145 6187 109
1580233 1580233 2021-08-03 Shelby Indiana 18145 6149 109
1576984 1576984 2021-08-02 Shelby Indiana 18145 6141 109
1573736 1573736 2021-08-01 Shelby Indiana 18145 6129 109
1570488 1570488 2021-07-31 Shelby Indiana 18145 6129 109
1567240 1567240 2021-07-30 Shelby Indiana 18145 6129 109
1563992 1563992 2021-07-29 Shelby Indiana 18145 6117 109
1560744 1560744 2021-07-28 Shelby Indiana 18145 6116 109
1557497 1557497 2021-07-27 Shelby Indiana 18145 6107 109

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