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 = "Lunenburg", deaths = 13 and state = "Virginia" sorted by date descending

✎ View and edit SQL

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

Suggested facets: cases, date (date)

state 1

  • Virginia · 32 ✖

fips 1

county 1

  • Lunenburg · 32 ✖
Link rowid date ▲ county state fips cases deaths
1342226 1342226 2021-05-21 Lunenburg Virginia 51111 773 13
1338978 1338978 2021-05-20 Lunenburg Virginia 51111 771 13
1335731 1335731 2021-05-19 Lunenburg Virginia 51111 770 13
1332484 1332484 2021-05-18 Lunenburg Virginia 51111 769 13
1329237 1329237 2021-05-17 Lunenburg Virginia 51111 768 13
1325991 1325991 2021-05-16 Lunenburg Virginia 51111 768 13
1322745 1322745 2021-05-15 Lunenburg Virginia 51111 767 13
1319499 1319499 2021-05-14 Lunenburg Virginia 51111 766 13
1316251 1316251 2021-05-13 Lunenburg Virginia 51111 767 13
1313005 1313005 2021-05-12 Lunenburg Virginia 51111 765 13
1309758 1309758 2021-05-11 Lunenburg Virginia 51111 763 13
1306512 1306512 2021-05-10 Lunenburg Virginia 51111 763 13
1303266 1303266 2021-05-09 Lunenburg Virginia 51111 763 13
1300019 1300019 2021-05-08 Lunenburg Virginia 51111 761 13
1296772 1296772 2021-05-07 Lunenburg Virginia 51111 762 13
1293526 1293526 2021-05-06 Lunenburg Virginia 51111 762 13
1290280 1290280 2021-05-05 Lunenburg Virginia 51111 762 13
1287034 1287034 2021-05-04 Lunenburg Virginia 51111 761 13
1283788 1283788 2021-05-03 Lunenburg Virginia 51111 761 13
1280541 1280541 2021-05-02 Lunenburg Virginia 51111 761 13
1277294 1277294 2021-05-01 Lunenburg Virginia 51111 761 13
1274047 1274047 2021-04-30 Lunenburg Virginia 51111 757 13
1270800 1270800 2021-04-29 Lunenburg Virginia 51111 754 13
1267553 1267553 2021-04-28 Lunenburg Virginia 51111 751 13
1264306 1264306 2021-04-27 Lunenburg Virginia 51111 746 13
1261059 1261059 2021-04-26 Lunenburg Virginia 51111 745 13
1257812 1257812 2021-04-25 Lunenburg Virginia 51111 745 13
1254565 1254565 2021-04-24 Lunenburg Virginia 51111 744 13
1251318 1251318 2021-04-23 Lunenburg Virginia 51111 743 13
1248071 1248071 2021-04-22 Lunenburg Virginia 51111 740 13
1244824 1244824 2021-04-21 Lunenburg Virginia 51111 739 13
1241577 1241577 2021-04-20 Lunenburg Virginia 51111 739 13

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