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 deaths = 167 and fips = 22005 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

  • 22005 · 34 ✖

county 1

Link rowid date ▲ county state fips cases deaths
1460446 1460446 2021-06-27 Ascension Louisiana 22005 12845 167
1457201 1457201 2021-06-26 Ascension Louisiana 22005 12845 167
1453956 1453956 2021-06-25 Ascension Louisiana 22005 12845 167
1450710 1450710 2021-06-24 Ascension Louisiana 22005 12839 167
1447465 1447465 2021-06-23 Ascension Louisiana 22005 12832 167
1444220 1444220 2021-06-22 Ascension Louisiana 22005 12812 167
1440975 1440975 2021-06-21 Ascension Louisiana 22005 12809 167
1437728 1437728 2021-06-20 Ascension Louisiana 22005 12788 167
1434481 1434481 2021-06-19 Ascension Louisiana 22005 12788 167
1431235 1431235 2021-06-18 Ascension Louisiana 22005 12788 167
1427990 1427990 2021-06-17 Ascension Louisiana 22005 12780 167
1424745 1424745 2021-06-16 Ascension Louisiana 22005 12775 167
1421497 1421497 2021-06-15 Ascension Louisiana 22005 12749 167
1418252 1418252 2021-06-14 Ascension Louisiana 22005 12735 167
1415006 1415006 2021-06-13 Ascension Louisiana 22005 12712 167
1411761 1411761 2021-06-12 Ascension Louisiana 22005 12712 167
1408516 1408516 2021-06-11 Ascension Louisiana 22005 12712 167
1405270 1405270 2021-06-10 Ascension Louisiana 22005 12707 167
1402025 1402025 2021-06-09 Ascension Louisiana 22005 12696 167
1398780 1398780 2021-06-08 Ascension Louisiana 22005 12682 167
1395533 1395533 2021-06-07 Ascension Louisiana 22005 12664 167
1392288 1392288 2021-06-06 Ascension Louisiana 22005 12650 167
1389043 1389043 2021-06-05 Ascension Louisiana 22005 12650 167
1385798 1385798 2021-06-04 Ascension Louisiana 22005 12650 167
1382552 1382552 2021-06-03 Ascension Louisiana 22005 12631 167
1379307 1379307 2021-06-02 Ascension Louisiana 22005 12621 167
1376061 1376061 2021-06-01 Ascension Louisiana 22005 12600 167
1372816 1372816 2021-05-31 Ascension Louisiana 22005 12571 167
1369571 1369571 2021-05-30 Ascension Louisiana 22005 12571 167
1366325 1366325 2021-05-29 Ascension Louisiana 22005 12571 167
1363079 1363079 2021-05-28 Ascension Louisiana 22005 12571 167
1359832 1359832 2021-05-27 Ascension Louisiana 22005 12570 167
1356586 1356586 2021-05-26 Ascension Louisiana 22005 12563 167
1353340 1353340 2021-05-25 Ascension Louisiana 22005 12528 167

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