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 cases = 27 and county = "Jackson" sorted by date descending

✎ View and edit SQL

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

fips 12

county 1

  • Jackson · 32 ✖
Link rowid date ▲ county state fips cases deaths
559571 559571 2020-09-22 Jackson South Dakota 46071 27 1
320760 320760 2020-07-10 Jackson Ohio 39079 27 0
317583 317583 2020-07-09 Jackson Ohio 39079 27 0
309127 309127 2020-07-06 Jackson Wisconsin 55053 27 1
305363 305363 2020-07-05 Jackson Tennessee 47087 27 0
305958 305958 2020-07-05 Jackson Wisconsin 55053 27 1
302794 302794 2020-07-04 Jackson Wisconsin 55053 27 1
297371 297371 2020-07-03 Jackson Iowa 19097 27 0
299630 299630 2020-07-03 Jackson Wisconsin 55053 27 1
294213 294213 2020-07-02 Jackson Iowa 19097 27 0
296468 296468 2020-07-02 Jackson Wisconsin 55053 27 1
290369 290369 2020-07-01 Jackson Arkansas 5067 27 0
293313 293313 2020-07-01 Jackson Wisconsin 55053 27 1
287218 287218 2020-06-30 Jackson Arkansas 5067 27 0
290160 290160 2020-06-30 Jackson Wisconsin 55053 27 1
284072 284072 2020-06-29 Jackson Arkansas 5067 27 0
280926 280926 2020-06-28 Jackson Arkansas 5067 27 0
270860 270860 2020-06-24 Jackson Texas 48239 27 1
267726 267726 2020-06-23 Jackson Texas 48239 27 1
214308 214308 2020-06-06 Jackson Oklahoma 40065 27 3
211222 211222 2020-06-05 Jackson Oklahoma 40065 27 3
208140 208140 2020-06-04 Jackson Oklahoma 40065 27 3
205059 205059 2020-06-03 Jackson Oklahoma 40065 27 3
201982 201982 2020-06-02 Jackson Oklahoma 40065 27 3
198907 198907 2020-06-01 Jackson Oklahoma 40065 27 3
195834 195834 2020-05-31 Jackson Oklahoma 40065 27 3
192765 192765 2020-05-30 Jackson Oklahoma 40065 27 3
51520 51520 2020-04-12 Jackson Georgia 13157 27 1
53648 53648 2020-04-12 Jackson West Virginia 54035 27 1
46376 46376 2020-04-10 Jackson Illinois 17077 27 2
30073 30073 2020-04-03 Jackson Oregon 41029 27 0
27740 27740 2020-04-02 Jackson Oregon 41029 27 0

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