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

11 rows where cases = 2728 and state = "Arkansas" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips 6

state 1

  • Arkansas · 11 ✖
Link rowid date ▲ county state fips cases deaths
2148281 2148281 2022-01-25 Bradley Arkansas 5011 2728 43
1871984 1871984 2021-11-01 Franklin Arkansas 5047 2728 52
1868735 1868735 2021-10-31 Franklin Arkansas 5047 2728 52
1865486 1865486 2021-10-30 Franklin Arkansas 5047 2728 52
1673774 1673774 2021-09-01 Ashley Arkansas 5003 2728 39
1102310 1102310 2021-03-09 Carroll Arkansas 5015 2728 43
1099064 1099064 2021-03-08 Carroll Arkansas 5015 2728 43
1095816 1095816 2021-03-07 Carroll Arkansas 5015 2728 42
1092570 1092570 2021-03-06 Carroll Arkansas 5015 2728 42
881670 881670 2020-12-31 St. Francis Arkansas 5123 2728 20
599345 599345 2020-10-05 Faulkner Arkansas 5045 2728 22

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