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

22 rows where cases = 3210 and state = "Arkansas" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

fips 4

county 4

state 1

  • Arkansas · 22 ✖
Link rowid date ▲ county state fips cases deaths
1800516 1800516 2021-10-10 Lawrence Arkansas 5075 3210 55
1238723 1238723 2021-04-20 Jackson Arkansas 5067 3210 38
1235476 1235476 2021-04-19 Jackson Arkansas 5067 3210 38
1232229 1232229 2021-04-18 Jackson Arkansas 5067 3210 38
1228980 1228980 2021-04-17 Jackson Arkansas 5067 3210 38
1225732 1225732 2021-04-16 Jackson Arkansas 5067 3210 38
1222485 1222485 2021-04-15 Jackson Arkansas 5067 3210 38
1219237 1219237 2021-04-14 Jackson Arkansas 5067 3210 38
1215989 1215989 2021-04-13 Jackson Arkansas 5067 3210 38
1212742 1212742 2021-04-12 Jackson Arkansas 5067 3210 38
1209494 1209494 2021-04-11 Jackson Arkansas 5067 3210 38
1206245 1206245 2021-04-10 Jackson Arkansas 5067 3210 38
1202997 1202997 2021-04-09 Jackson Arkansas 5067 3210 38
1199749 1199749 2021-04-08 Jackson Arkansas 5067 3210 38
1196500 1196500 2021-04-07 Jackson Arkansas 5067 3210 38
1193252 1193252 2021-04-06 Jackson Arkansas 5067 3210 38
1190002 1190002 2021-04-05 Jackson Arkansas 5067 3210 38
1186755 1186755 2021-04-04 Jackson Arkansas 5067 3210 38
1183508 1183508 2021-04-03 Jackson Arkansas 5067 3210 38
1180261 1180261 2021-04-02 Jackson Arkansas 5067 3210 38
949824 949824 2021-01-21 St. Francis Arkansas 5123 3210 29
732339 732339 2020-11-15 Garland Arkansas 5051 3210 86

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