ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where cases = 2, county = "Dewey" and fips = 40043 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
235990 | 235990 | 2020-06-13 | Dewey | Oklahoma | 40043 | 2 | 0 |
232885 | 232885 | 2020-06-12 | Dewey | Oklahoma | 40043 | 2 | 0 |
229780 | 229780 | 2020-06-11 | Dewey | Oklahoma | 40043 | 2 | 0 |
226676 | 226676 | 2020-06-10 | Dewey | Oklahoma | 40043 | 2 | 0 |
195825 | 195825 | 2020-05-31 | Dewey | Oklahoma | 40043 | 2 | 0 |
192756 | 192756 | 2020-05-30 | Dewey | Oklahoma | 40043 | 2 | 0 |
189691 | 189691 | 2020-05-29 | Dewey | Oklahoma | 40043 | 2 | 0 |
162292 | 162292 | 2020-05-20 | Dewey | Oklahoma | 40043 | 2 | 0 |
159265 | 159265 | 2020-05-19 | Dewey | Oklahoma | 40043 | 2 | 0 |
156244 | 156244 | 2020-05-18 | Dewey | Oklahoma | 40043 | 2 | 0 |
153227 | 153227 | 2020-05-17 | Dewey | Oklahoma | 40043 | 2 | 0 |
150216 | 150216 | 2020-05-16 | Dewey | Oklahoma | 40043 | 2 | 0 |
147209 | 147209 | 2020-05-15 | Dewey | Oklahoma | 40043 | 2 | 0 |
144208 | 144208 | 2020-05-14 | Dewey | Oklahoma | 40043 | 2 | 0 |
141213 | 141213 | 2020-05-13 | Dewey | Oklahoma | 40043 | 2 | 0 |
138217 | 138217 | 2020-05-12 | Dewey | Oklahoma | 40043 | 2 | 0 |
135227 | 135227 | 2020-05-11 | Dewey | Oklahoma | 40043 | 2 | 0 |
132236 | 132236 | 2020-05-10 | Dewey | Oklahoma | 40043 | 2 | 0 |
129247 | 129247 | 2020-05-09 | Dewey | Oklahoma | 40043 | 2 | 0 |
126258 | 126258 | 2020-05-08 | Dewey | Oklahoma | 40043 | 2 | 0 |
123275 | 123275 | 2020-05-07 | Dewey | Oklahoma | 40043 | 2 | 0 |
120298 | 120298 | 2020-05-06 | Dewey | Oklahoma | 40043 | 2 | 0 |
117337 | 117337 | 2020-05-05 | Dewey | Oklahoma | 40043 | 2 | 0 |
114456 | 114456 | 2020-05-04 | Dewey | Oklahoma | 40043 | 2 | 0 |
111574 | 111574 | 2020-05-03 | Dewey | Oklahoma | 40043 | 2 | 0 |
108700 | 108700 | 2020-05-02 | Dewey | Oklahoma | 40043 | 2 | 0 |
105833 | 105833 | 2020-05-01 | Dewey | Oklahoma | 40043 | 2 | 0 |
102970 | 102970 | 2020-04-30 | Dewey | Oklahoma | 40043 | 2 | 0 |
100117 | 100117 | 2020-04-29 | Dewey | Oklahoma | 40043 | 2 | 0 |
97268 | 97268 | 2020-04-28 | Dewey | Oklahoma | 40043 | 2 | 0 |
94430 | 94430 | 2020-04-27 | Dewey | Oklahoma | 40043 | 2 | 0 |
91604 | 91604 | 2020-04-26 | Dewey | Oklahoma | 40043 | 2 | 0 |
88788 | 88788 | 2020-04-25 | Dewey | Oklahoma | 40043 | 2 | 0 |
85974 | 85974 | 2020-04-24 | Dewey | Oklahoma | 40043 | 2 | 0 |
83170 | 83170 | 2020-04-23 | Dewey | Oklahoma | 40043 | 2 | 0 |
80371 | 80371 | 2020-04-22 | Dewey | Oklahoma | 40043 | 2 | 0 |
77581 | 77581 | 2020-04-21 | Dewey | Oklahoma | 40043 | 2 | 0 |
74799 | 74799 | 2020-04-20 | Dewey | Oklahoma | 40043 | 2 | 0 |
72024 | 72024 | 2020-04-19 | Dewey | Oklahoma | 40043 | 2 | 0 |
69257 | 69257 | 2020-04-18 | Dewey | Oklahoma | 40043 | 2 | 0 |
66500 | 66500 | 2020-04-17 | Dewey | Oklahoma | 40043 | 2 | 0 |
63757 | 63757 | 2020-04-16 | Dewey | Oklahoma | 40043 | 2 | 0 |
61031 | 61031 | 2020-04-15 | Dewey | Oklahoma | 40043 | 2 | 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);