ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,474 rows where county = "Dewey" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
39840 | 39840 | 2020-04-07 | Dewey | Oklahoma | 40043 | 1 | 0 |
42400 | 42400 | 2020-04-08 | Dewey | Oklahoma | 40043 | 1 | 0 |
44986 | 44986 | 2020-04-09 | Dewey | Oklahoma | 40043 | 1 | 0 |
47601 | 47601 | 2020-04-10 | Dewey | Oklahoma | 40043 | 1 | 0 |
50257 | 50257 | 2020-04-11 | Dewey | Oklahoma | 40043 | 1 | 0 |
52930 | 52930 | 2020-04-12 | Dewey | Oklahoma | 40043 | 1 | 0 |
55615 | 55615 | 2020-04-13 | Dewey | Oklahoma | 40043 | 1 | 0 |
58316 | 58316 | 2020-04-14 | Dewey | Oklahoma | 40043 | 1 | 0 |
61031 | 61031 | 2020-04-15 | Dewey | Oklahoma | 40043 | 2 | 0 |
63757 | 63757 | 2020-04-16 | Dewey | Oklahoma | 40043 | 2 | 0 |
66500 | 66500 | 2020-04-17 | Dewey | Oklahoma | 40043 | 2 | 0 |
69257 | 69257 | 2020-04-18 | Dewey | Oklahoma | 40043 | 2 | 0 |
72024 | 72024 | 2020-04-19 | Dewey | Oklahoma | 40043 | 2 | 0 |
74799 | 74799 | 2020-04-20 | Dewey | Oklahoma | 40043 | 2 | 0 |
77581 | 77581 | 2020-04-21 | Dewey | Oklahoma | 40043 | 2 | 0 |
80371 | 80371 | 2020-04-22 | Dewey | Oklahoma | 40043 | 2 | 0 |
83170 | 83170 | 2020-04-23 | Dewey | Oklahoma | 40043 | 2 | 0 |
85974 | 85974 | 2020-04-24 | Dewey | Oklahoma | 40043 | 2 | 0 |
88788 | 88788 | 2020-04-25 | Dewey | Oklahoma | 40043 | 2 | 0 |
91604 | 91604 | 2020-04-26 | Dewey | Oklahoma | 40043 | 2 | 0 |
94430 | 94430 | 2020-04-27 | Dewey | Oklahoma | 40043 | 2 | 0 |
97268 | 97268 | 2020-04-28 | Dewey | Oklahoma | 40043 | 2 | 0 |
100117 | 100117 | 2020-04-29 | Dewey | Oklahoma | 40043 | 2 | 0 |
102970 | 102970 | 2020-04-30 | Dewey | Oklahoma | 40043 | 2 | 0 |
105833 | 105833 | 2020-05-01 | Dewey | Oklahoma | 40043 | 2 | 0 |
108700 | 108700 | 2020-05-02 | Dewey | Oklahoma | 40043 | 2 | 0 |
111574 | 111574 | 2020-05-03 | Dewey | Oklahoma | 40043 | 2 | 0 |
114456 | 114456 | 2020-05-04 | Dewey | Oklahoma | 40043 | 2 | 0 |
117337 | 117337 | 2020-05-05 | Dewey | Oklahoma | 40043 | 2 | 0 |
120298 | 120298 | 2020-05-06 | Dewey | Oklahoma | 40043 | 2 | 0 |
123275 | 123275 | 2020-05-07 | Dewey | Oklahoma | 40043 | 2 | 0 |
126258 | 126258 | 2020-05-08 | Dewey | Oklahoma | 40043 | 2 | 0 |
129247 | 129247 | 2020-05-09 | Dewey | Oklahoma | 40043 | 2 | 0 |
132236 | 132236 | 2020-05-10 | Dewey | Oklahoma | 40043 | 2 | 0 |
135227 | 135227 | 2020-05-11 | Dewey | Oklahoma | 40043 | 2 | 0 |
138217 | 138217 | 2020-05-12 | Dewey | Oklahoma | 40043 | 2 | 0 |
141213 | 141213 | 2020-05-13 | Dewey | Oklahoma | 40043 | 2 | 0 |
144208 | 144208 | 2020-05-14 | Dewey | Oklahoma | 40043 | 2 | 0 |
147209 | 147209 | 2020-05-15 | Dewey | Oklahoma | 40043 | 2 | 0 |
150216 | 150216 | 2020-05-16 | Dewey | Oklahoma | 40043 | 2 | 0 |
153227 | 153227 | 2020-05-17 | Dewey | Oklahoma | 40043 | 2 | 0 |
156244 | 156244 | 2020-05-18 | Dewey | Oklahoma | 40043 | 2 | 0 |
159265 | 159265 | 2020-05-19 | Dewey | Oklahoma | 40043 | 2 | 0 |
162292 | 162292 | 2020-05-20 | Dewey | Oklahoma | 40043 | 2 | 0 |
165321 | 165321 | 2020-05-21 | Dewey | Oklahoma | 40043 | 3 | 0 |
168357 | 168357 | 2020-05-22 | Dewey | Oklahoma | 40043 | 3 | 0 |
171396 | 171396 | 2020-05-23 | Dewey | Oklahoma | 40043 | 3 | 0 |
174438 | 174438 | 2020-05-24 | Dewey | Oklahoma | 40043 | 3 | 0 |
177482 | 177482 | 2020-05-25 | Dewey | Oklahoma | 40043 | 3 | 0 |
180525 | 180525 | 2020-05-26 | Dewey | Oklahoma | 40043 | 4 | 0 |
183574 | 183574 | 2020-05-27 | Dewey | Oklahoma | 40043 | 4 | 0 |
186631 | 186631 | 2020-05-28 | Dewey | Oklahoma | 40043 | 4 | 0 |
189691 | 189691 | 2020-05-29 | Dewey | Oklahoma | 40043 | 2 | 0 |
192756 | 192756 | 2020-05-30 | Dewey | Oklahoma | 40043 | 2 | 0 |
195825 | 195825 | 2020-05-31 | Dewey | Oklahoma | 40043 | 2 | 0 |
198898 | 198898 | 2020-06-01 | Dewey | Oklahoma | 40043 | 3 | 0 |
201973 | 201973 | 2020-06-02 | Dewey | Oklahoma | 40043 | 3 | 0 |
205050 | 205050 | 2020-06-03 | Dewey | Oklahoma | 40043 | 3 | 0 |
208131 | 208131 | 2020-06-04 | Dewey | Oklahoma | 40043 | 3 | 0 |
211213 | 211213 | 2020-06-05 | Dewey | Oklahoma | 40043 | 3 | 0 |
214299 | 214299 | 2020-06-06 | Dewey | Oklahoma | 40043 | 3 | 0 |
214600 | 214600 | 2020-06-06 | Dewey | South Dakota | 46041 | 1 | 0 |
217389 | 217389 | 2020-06-07 | Dewey | Oklahoma | 40043 | 3 | 0 |
217690 | 217690 | 2020-06-07 | Dewey | South Dakota | 46041 | 1 | 0 |
220481 | 220481 | 2020-06-08 | Dewey | Oklahoma | 40043 | 3 | 0 |
220782 | 220782 | 2020-06-08 | Dewey | South Dakota | 46041 | 1 | 0 |
223576 | 223576 | 2020-06-09 | Dewey | Oklahoma | 40043 | 3 | 0 |
223877 | 223877 | 2020-06-09 | Dewey | South Dakota | 46041 | 1 | 0 |
226676 | 226676 | 2020-06-10 | Dewey | Oklahoma | 40043 | 2 | 0 |
226977 | 226977 | 2020-06-10 | Dewey | South Dakota | 46041 | 1 | 0 |
229780 | 229780 | 2020-06-11 | Dewey | Oklahoma | 40043 | 2 | 0 |
230081 | 230081 | 2020-06-11 | Dewey | South Dakota | 46041 | 2 | 0 |
232885 | 232885 | 2020-06-12 | Dewey | Oklahoma | 40043 | 2 | 0 |
233186 | 233186 | 2020-06-12 | Dewey | South Dakota | 46041 | 2 | 0 |
235990 | 235990 | 2020-06-13 | Dewey | Oklahoma | 40043 | 2 | 0 |
236291 | 236291 | 2020-06-13 | Dewey | South Dakota | 46041 | 2 | 0 |
239098 | 239098 | 2020-06-14 | Dewey | Oklahoma | 40043 | 4 | 0 |
239399 | 239399 | 2020-06-14 | Dewey | South Dakota | 46041 | 2 | 0 |
242207 | 242207 | 2020-06-15 | Dewey | Oklahoma | 40043 | 5 | 0 |
242509 | 242509 | 2020-06-15 | Dewey | South Dakota | 46041 | 2 | 0 |
245319 | 245319 | 2020-06-16 | Dewey | Oklahoma | 40043 | 4 | 0 |
245621 | 245621 | 2020-06-16 | Dewey | South Dakota | 46041 | 4 | 0 |
248432 | 248432 | 2020-06-17 | Dewey | Oklahoma | 40043 | 4 | 0 |
248734 | 248734 | 2020-06-17 | Dewey | South Dakota | 46041 | 4 | 0 |
251547 | 251547 | 2020-06-18 | Dewey | Oklahoma | 40043 | 4 | 0 |
251849 | 251849 | 2020-06-18 | Dewey | South Dakota | 46041 | 4 | 0 |
254662 | 254662 | 2020-06-19 | Dewey | Oklahoma | 40043 | 4 | 0 |
254964 | 254964 | 2020-06-19 | Dewey | South Dakota | 46041 | 4 | 0 |
257788 | 257788 | 2020-06-20 | Dewey | Oklahoma | 40043 | 4 | 0 |
258090 | 258090 | 2020-06-20 | Dewey | South Dakota | 46041 | 4 | 0 |
260914 | 260914 | 2020-06-21 | Dewey | Oklahoma | 40043 | 4 | 0 |
261217 | 261217 | 2020-06-21 | Dewey | South Dakota | 46041 | 4 | 0 |
264042 | 264042 | 2020-06-22 | Dewey | Oklahoma | 40043 | 4 | 0 |
264345 | 264345 | 2020-06-22 | Dewey | South Dakota | 46041 | 4 | 0 |
267170 | 267170 | 2020-06-23 | Dewey | Oklahoma | 40043 | 4 | 0 |
267473 | 267473 | 2020-06-23 | Dewey | South Dakota | 46041 | 4 | 0 |
270304 | 270304 | 2020-06-24 | Dewey | Oklahoma | 40043 | 4 | 0 |
270607 | 270607 | 2020-06-24 | Dewey | South Dakota | 46041 | 4 | 0 |
273443 | 273443 | 2020-06-25 | Dewey | Oklahoma | 40043 | 4 | 0 |
273746 | 273746 | 2020-06-25 | Dewey | South Dakota | 46041 | 4 | 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);