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

32 rows where county = "Litchfield" and deaths = 138 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

county 1

  • Litchfield · 32 ✖
Link rowid date ▲ county state fips cases deaths
492683 492683 2020-09-02 Litchfield Connecticut 9005 1717 138
489450 489450 2020-09-01 Litchfield Connecticut 9005 1713 138
486217 486217 2020-08-31 Litchfield Connecticut 9005 1709 138
421649 421649 2020-08-11 Litchfield Connecticut 9005 1618 138
418428 418428 2020-08-10 Litchfield Connecticut 9005 1615 138
415207 415207 2020-08-09 Litchfield Connecticut 9005 1610 138
411987 411987 2020-08-08 Litchfield Connecticut 9005 1610 138
408768 408768 2020-08-07 Litchfield Connecticut 9005 1610 138
405548 405548 2020-08-06 Litchfield Connecticut 9005 1607 138
402330 402330 2020-08-05 Litchfield Connecticut 9005 1606 138
399114 399114 2020-08-04 Litchfield Connecticut 9005 1600 138
395898 395898 2020-08-03 Litchfield Connecticut 9005 1598 138
392682 392682 2020-08-02 Litchfield Connecticut 9005 1597 138
389465 389465 2020-08-01 Litchfield Connecticut 9005 1597 138
386248 386248 2020-07-31 Litchfield Connecticut 9005 1597 138
383030 383030 2020-07-30 Litchfield Connecticut 9005 1599 138
379813 379813 2020-07-29 Litchfield Connecticut 9005 1593 138
376596 376596 2020-07-28 Litchfield Connecticut 9005 1570 138
373382 373382 2020-07-27 Litchfield Connecticut 9005 1568 138
370170 370170 2020-07-26 Litchfield Connecticut 9005 1560 138
366960 366960 2020-07-25 Litchfield Connecticut 9005 1560 138
363753 363753 2020-07-24 Litchfield Connecticut 9005 1560 138
360546 360546 2020-07-23 Litchfield Connecticut 9005 1530 138
357341 357341 2020-07-22 Litchfield Connecticut 9005 1530 138
354138 354138 2020-07-21 Litchfield Connecticut 9005 1525 138
350936 350936 2020-07-20 Litchfield Connecticut 9005 1524 138
347735 347735 2020-07-19 Litchfield Connecticut 9005 1523 138
344535 344535 2020-07-18 Litchfield Connecticut 9005 1523 138
341336 341336 2020-07-17 Litchfield Connecticut 9005 1523 138
338139 338139 2020-07-16 Litchfield Connecticut 9005 1520 138
334944 334944 2020-07-15 Litchfield Connecticut 9005 1517 138
331751 331751 2020-07-14 Litchfield Connecticut 9005 1512 138

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