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

20 rows where county = "Winn", deaths = 18 and state = "Louisiana" sorted by date descending

✎ View and edit SQL

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

Suggested facets: cases, date (date)

state 1

  • Louisiana · 20 ✖

fips 1

county 1

  • Winn · 20 ✖
Link rowid date ▲ county state fips cases deaths
593913 593913 2020-10-03 Winn Louisiana 22127 639 18
590672 590672 2020-10-02 Winn Louisiana 22127 639 18
587431 587431 2020-10-01 Winn Louisiana 22127 635 18
584191 584191 2020-09-30 Winn Louisiana 22127 634 18
580951 580951 2020-09-29 Winn Louisiana 22127 632 18
577710 577710 2020-09-28 Winn Louisiana 22127 627 18
574468 574468 2020-09-27 Winn Louisiana 22127 628 18
571225 571225 2020-09-26 Winn Louisiana 22127 622 18
567983 567983 2020-09-25 Winn Louisiana 22127 622 18
564743 564743 2020-09-24 Winn Louisiana 22127 619 18
561503 561503 2020-09-23 Winn Louisiana 22127 616 18
558267 558267 2020-09-22 Winn Louisiana 22127 611 18
555030 555030 2020-09-21 Winn Louisiana 22127 606 18
551791 551791 2020-09-20 Winn Louisiana 22127 608 18
548552 548552 2020-09-19 Winn Louisiana 22127 603 18
545314 545314 2020-09-18 Winn Louisiana 22127 603 18
542078 542078 2020-09-17 Winn Louisiana 22127 597 18
538842 538842 2020-09-16 Winn Louisiana 22127 597 18
535605 535605 2020-09-15 Winn Louisiana 22127 598 18
532370 532370 2020-09-14 Winn Louisiana 22127 592 18

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