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

30 rows where deaths = 212 and state = "California" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips 8

state 1

  • California · 30 ✖
Link rowid date ▲ county state fips cases deaths
2499770 2499770 2022-05-13 El Dorado California 6017 30508 212
2496512 2496512 2022-05-12 El Dorado California 6017 30428 212
2493254 2493254 2022-05-11 El Dorado California 6017 30428 212
2489996 2489996 2022-05-10 El Dorado California 6017 30428 212
1742116 1742116 2021-09-22 Santa Cruz California 6087 20195 212
1449830 1449830 2021-06-24 Yolo California 6113 14161 212
1446585 1446585 2021-06-23 Yolo California 6113 14157 212
1443340 1443340 2021-06-22 Yolo California 6113 14165 212
1440095 1440095 2021-06-21 Yolo California 6113 14160 212
1436848 1436848 2021-06-20 Yolo California 6113 14156 212
1433601 1433601 2021-06-19 Yolo California 6113 14148 212
1430355 1430355 2021-06-18 Yolo California 6113 14141 212
1427110 1427110 2021-06-17 Yolo California 6113 14135 212
1423865 1423865 2021-06-16 Yolo California 6113 14127 212
1420617 1420617 2021-06-15 Yolo California 6113 14123 212
1417372 1417372 2021-06-14 Yolo California 6113 14120 212
1414126 1414126 2021-06-13 Yolo California 6113 14118 212
1410881 1410881 2021-06-12 Yolo California 6113 14111 212
1407636 1407636 2021-06-11 Yolo California 6113 14107 212
1404390 1404390 2021-06-10 Yolo California 6113 14102 212
1401145 1401145 2021-06-09 Yolo California 6113 14099 212
871984 871984 2020-12-28 San Mateo California 6081 23681 212
868739 868739 2020-12-27 San Mateo California 6081 22908 212
865494 865494 2020-12-26 San Mateo California 6081 22568 212
862249 862249 2020-12-25 San Mateo California 6081 22241 212
859004 859004 2020-12-24 San Mateo California 6081 22241 212
596162 596162 2020-10-04 Contra Costa California 6013 17263 212
447378 447378 2020-08-19 Stanislaus California 6099 12935 212
424747 424747 2020-08-12 Alameda California 6001 14120 212
130444 130444 2020-05-10 Riverside California 6065 5039 212

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