ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
31 rows where cases = 24 and county = "Jefferson" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 8
- Oregon 15
- Ohio 6
- Wisconsin 4
- Pennsylvania 2
- Florida 1
- Idaho 1
- Mississippi 1
- Tennessee 1
county 1
- Jefferson · 31 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
319286 | 319286 | 2020-07-10 | Jefferson | Idaho | 16051 | 24 | 0 |
295608 | 295608 | 2020-07-02 | Jefferson | Pennsylvania | 42065 | 24 | 1 |
292452 | 292452 | 2020-07-01 | Jefferson | Pennsylvania | 42065 | 24 | 1 |
183640 | 183640 | 2020-05-27 | Jefferson | Oregon | 41031 | 24 | 0 |
180591 | 180591 | 2020-05-26 | Jefferson | Oregon | 41031 | 24 | 0 |
177548 | 177548 | 2020-05-25 | Jefferson | Oregon | 41031 | 24 | 0 |
162358 | 162358 | 2020-05-20 | Jefferson | Oregon | 41031 | 24 | 0 |
159331 | 159331 | 2020-05-19 | Jefferson | Oregon | 41031 | 24 | 0 |
156310 | 156310 | 2020-05-18 | Jefferson | Oregon | 41031 | 24 | 0 |
153293 | 153293 | 2020-05-17 | Jefferson | Oregon | 41031 | 24 | 0 |
150282 | 150282 | 2020-05-16 | Jefferson | Oregon | 41031 | 24 | 0 |
147275 | 147275 | 2020-05-15 | Jefferson | Oregon | 41031 | 24 | 0 |
144274 | 144274 | 2020-05-14 | Jefferson | Oregon | 41031 | 24 | 0 |
141278 | 141278 | 2020-05-13 | Jefferson | Oregon | 41031 | 24 | 0 |
138282 | 138282 | 2020-05-12 | Jefferson | Oregon | 41031 | 24 | 0 |
135292 | 135292 | 2020-05-11 | Jefferson | Oregon | 41031 | 24 | 0 |
132301 | 132301 | 2020-05-10 | Jefferson | Oregon | 41031 | 24 | 0 |
129312 | 129312 | 2020-05-09 | Jefferson | Oregon | 41031 | 24 | 0 |
116713 | 116713 | 2020-05-05 | Jefferson | Mississippi | 28063 | 24 | 0 |
111866 | 111866 | 2020-05-03 | Jefferson | Tennessee | 47089 | 24 | 0 |
67687 | 67687 | 2020-04-18 | Jefferson | Florida | 12065 | 24 | 1 |
66435 | 66435 | 2020-04-17 | Jefferson | Ohio | 39081 | 24 | 0 |
63692 | 63692 | 2020-04-16 | Jefferson | Ohio | 39081 | 24 | 0 |
64556 | 64556 | 2020-04-16 | Jefferson | Wisconsin | 55055 | 24 | 0 |
60966 | 60966 | 2020-04-15 | Jefferson | Ohio | 39081 | 24 | 0 |
61823 | 61823 | 2020-04-15 | Jefferson | Wisconsin | 55055 | 24 | 0 |
58251 | 58251 | 2020-04-14 | Jefferson | Ohio | 39081 | 24 | 0 |
59104 | 59104 | 2020-04-14 | Jefferson | Wisconsin | 55055 | 24 | 0 |
55550 | 55550 | 2020-04-13 | Jefferson | Ohio | 39081 | 24 | 0 |
56397 | 56397 | 2020-04-13 | Jefferson | Wisconsin | 55055 | 24 | 0 |
52866 | 52866 | 2020-04-12 | Jefferson | Ohio | 39081 | 24 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
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);