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

41 rows where county = "Shelby", deaths = 37 and fips = 18145 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 18145 · 41 ✖

county 1

  • Shelby · 41 ✖
Link rowid date ▲ county state fips cases deaths
648643 648643 2020-10-20 Shelby Indiana 18145 1309 37
645398 645398 2020-10-19 Shelby Indiana 18145 1298 37
642151 642151 2020-10-18 Shelby Indiana 18145 1284 37
638904 638904 2020-10-17 Shelby Indiana 18145 1280 37
635658 635658 2020-10-16 Shelby Indiana 18145 1270 37
632412 632412 2020-10-15 Shelby Indiana 18145 1250 37
629168 629168 2020-10-14 Shelby Indiana 18145 1241 37
625925 625925 2020-10-13 Shelby Indiana 18145 1237 37
622683 622683 2020-10-12 Shelby Indiana 18145 1222 37
619439 619439 2020-10-11 Shelby Indiana 18145 1220 37
616197 616197 2020-10-10 Shelby Indiana 18145 1216 37
612956 612956 2020-10-09 Shelby Indiana 18145 1208 37
609714 609714 2020-10-08 Shelby Indiana 18145 1201 37
606471 606471 2020-10-07 Shelby Indiana 18145 1197 37
603229 603229 2020-10-06 Shelby Indiana 18145 1195 37
599986 599986 2020-10-05 Shelby Indiana 18145 1192 37
596744 596744 2020-10-04 Shelby Indiana 18145 1191 37
593502 593502 2020-10-03 Shelby Indiana 18145 1186 37
590261 590261 2020-10-02 Shelby Indiana 18145 1183 37
587020 587020 2020-10-01 Shelby Indiana 18145 1182 37
583780 583780 2020-09-30 Shelby Indiana 18145 1179 37
580541 580541 2020-09-29 Shelby Indiana 18145 1171 37
577300 577300 2020-09-28 Shelby Indiana 18145 1168 37
574058 574058 2020-09-27 Shelby Indiana 18145 1165 37
570815 570815 2020-09-26 Shelby Indiana 18145 1162 37
567573 567573 2020-09-25 Shelby Indiana 18145 1157 37
564333 564333 2020-09-24 Shelby Indiana 18145 1151 37
561093 561093 2020-09-23 Shelby Indiana 18145 1149 37
557857 557857 2020-09-22 Shelby Indiana 18145 1146 37
554620 554620 2020-09-21 Shelby Indiana 18145 1140 37
551381 551381 2020-09-20 Shelby Indiana 18145 1140 37
548142 548142 2020-09-19 Shelby Indiana 18145 1138 37
544904 544904 2020-09-18 Shelby Indiana 18145 1134 37
541668 541668 2020-09-17 Shelby Indiana 18145 1128 37
538431 538431 2020-09-16 Shelby Indiana 18145 1123 37
535195 535195 2020-09-15 Shelby Indiana 18145 1122 37
531960 531960 2020-09-14 Shelby Indiana 18145 1120 37
528723 528723 2020-09-13 Shelby Indiana 18145 1118 37
525487 525487 2020-09-12 Shelby Indiana 18145 1114 37
522251 522251 2020-09-11 Shelby Indiana 18145 1109 37
519014 519014 2020-09-10 Shelby Indiana 18145 1103 37

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