ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
747 rows where county = "Douglas" and fips = 46043 sorted by county descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
94644 | 94644 | 2020-04-27 | Douglas | South Dakota | 46043 | 1 | 0 |
97484 | 97484 | 2020-04-28 | Douglas | South Dakota | 46043 | 1 | 0 |
100334 | 100334 | 2020-04-29 | Douglas | South Dakota | 46043 | 1 | 0 |
103187 | 103187 | 2020-04-30 | Douglas | South Dakota | 46043 | 1 | 0 |
106050 | 106050 | 2020-05-01 | Douglas | South Dakota | 46043 | 1 | 0 |
108917 | 108917 | 2020-05-02 | Douglas | South Dakota | 46043 | 1 | 0 |
111791 | 111791 | 2020-05-03 | Douglas | South Dakota | 46043 | 1 | 0 |
114673 | 114673 | 2020-05-04 | Douglas | South Dakota | 46043 | 1 | 0 |
117629 | 117629 | 2020-05-05 | Douglas | South Dakota | 46043 | 1 | 0 |
120591 | 120591 | 2020-05-06 | Douglas | South Dakota | 46043 | 1 | 0 |
123569 | 123569 | 2020-05-07 | Douglas | South Dakota | 46043 | 1 | 0 |
126552 | 126552 | 2020-05-08 | Douglas | South Dakota | 46043 | 1 | 0 |
129541 | 129541 | 2020-05-09 | Douglas | South Dakota | 46043 | 1 | 0 |
132530 | 132530 | 2020-05-10 | Douglas | South Dakota | 46043 | 1 | 0 |
135521 | 135521 | 2020-05-11 | Douglas | South Dakota | 46043 | 1 | 0 |
138511 | 138511 | 2020-05-12 | Douglas | South Dakota | 46043 | 1 | 0 |
141507 | 141507 | 2020-05-13 | Douglas | South Dakota | 46043 | 1 | 0 |
144503 | 144503 | 2020-05-14 | Douglas | South Dakota | 46043 | 1 | 0 |
147504 | 147504 | 2020-05-15 | Douglas | South Dakota | 46043 | 1 | 0 |
150512 | 150512 | 2020-05-16 | Douglas | South Dakota | 46043 | 1 | 0 |
153523 | 153523 | 2020-05-17 | Douglas | South Dakota | 46043 | 1 | 0 |
156540 | 156540 | 2020-05-18 | Douglas | South Dakota | 46043 | 1 | 0 |
159561 | 159561 | 2020-05-19 | Douglas | South Dakota | 46043 | 1 | 0 |
162588 | 162588 | 2020-05-20 | Douglas | South Dakota | 46043 | 1 | 0 |
165617 | 165617 | 2020-05-21 | Douglas | South Dakota | 46043 | 1 | 0 |
168653 | 168653 | 2020-05-22 | Douglas | South Dakota | 46043 | 1 | 0 |
171692 | 171692 | 2020-05-23 | Douglas | South Dakota | 46043 | 2 | 0 |
174734 | 174734 | 2020-05-24 | Douglas | South Dakota | 46043 | 2 | 0 |
177778 | 177778 | 2020-05-25 | Douglas | South Dakota | 46043 | 3 | 0 |
180821 | 180821 | 2020-05-26 | Douglas | South Dakota | 46043 | 3 | 0 |
183871 | 183871 | 2020-05-27 | Douglas | South Dakota | 46043 | 3 | 0 |
186928 | 186928 | 2020-05-28 | Douglas | South Dakota | 46043 | 3 | 0 |
189990 | 189990 | 2020-05-29 | Douglas | South Dakota | 46043 | 3 | 0 |
193055 | 193055 | 2020-05-30 | Douglas | South Dakota | 46043 | 3 | 0 |
196124 | 196124 | 2020-05-31 | Douglas | South Dakota | 46043 | 3 | 0 |
199197 | 199197 | 2020-06-01 | Douglas | South Dakota | 46043 | 3 | 0 |
202272 | 202272 | 2020-06-02 | Douglas | South Dakota | 46043 | 3 | 0 |
205350 | 205350 | 2020-06-03 | Douglas | South Dakota | 46043 | 3 | 0 |
208432 | 208432 | 2020-06-04 | Douglas | South Dakota | 46043 | 3 | 0 |
211514 | 211514 | 2020-06-05 | Douglas | South Dakota | 46043 | 3 | 0 |
214601 | 214601 | 2020-06-06 | Douglas | South Dakota | 46043 | 3 | 0 |
217691 | 217691 | 2020-06-07 | Douglas | South Dakota | 46043 | 4 | 0 |
220783 | 220783 | 2020-06-08 | Douglas | South Dakota | 46043 | 4 | 0 |
223878 | 223878 | 2020-06-09 | Douglas | South Dakota | 46043 | 4 | 0 |
226978 | 226978 | 2020-06-10 | Douglas | South Dakota | 46043 | 4 | 0 |
230082 | 230082 | 2020-06-11 | Douglas | South Dakota | 46043 | 4 | 0 |
233187 | 233187 | 2020-06-12 | Douglas | South Dakota | 46043 | 4 | 0 |
236292 | 236292 | 2020-06-13 | Douglas | South Dakota | 46043 | 4 | 0 |
239400 | 239400 | 2020-06-14 | Douglas | South Dakota | 46043 | 4 | 0 |
242510 | 242510 | 2020-06-15 | Douglas | South Dakota | 46043 | 4 | 0 |
245622 | 245622 | 2020-06-16 | Douglas | South Dakota | 46043 | 4 | 0 |
248735 | 248735 | 2020-06-17 | Douglas | South Dakota | 46043 | 4 | 0 |
251850 | 251850 | 2020-06-18 | Douglas | South Dakota | 46043 | 4 | 0 |
254965 | 254965 | 2020-06-19 | Douglas | South Dakota | 46043 | 4 | 0 |
258091 | 258091 | 2020-06-20 | Douglas | South Dakota | 46043 | 4 | 0 |
261218 | 261218 | 2020-06-21 | Douglas | South Dakota | 46043 | 4 | 0 |
264346 | 264346 | 2020-06-22 | Douglas | South Dakota | 46043 | 4 | 0 |
267474 | 267474 | 2020-06-23 | Douglas | South Dakota | 46043 | 4 | 0 |
270608 | 270608 | 2020-06-24 | Douglas | South Dakota | 46043 | 4 | 0 |
273747 | 273747 | 2020-06-25 | Douglas | South Dakota | 46043 | 4 | 0 |
276894 | 276894 | 2020-06-26 | Douglas | South Dakota | 46043 | 4 | 0 |
280042 | 280042 | 2020-06-27 | Douglas | South Dakota | 46043 | 4 | 0 |
283188 | 283188 | 2020-06-28 | Douglas | South Dakota | 46043 | 4 | 0 |
286333 | 286333 | 2020-06-29 | Douglas | South Dakota | 46043 | 4 | 0 |
289484 | 289484 | 2020-06-30 | Douglas | South Dakota | 46043 | 4 | 0 |
292636 | 292636 | 2020-07-01 | Douglas | South Dakota | 46043 | 4 | 0 |
295792 | 295792 | 2020-07-02 | Douglas | South Dakota | 46043 | 5 | 0 |
298952 | 298952 | 2020-07-03 | Douglas | South Dakota | 46043 | 7 | 0 |
302116 | 302116 | 2020-07-04 | Douglas | South Dakota | 46043 | 7 | 0 |
305279 | 305279 | 2020-07-05 | Douglas | South Dakota | 46043 | 9 | 0 |
308446 | 308446 | 2020-07-06 | Douglas | South Dakota | 46043 | 9 | 0 |
311615 | 311615 | 2020-07-07 | Douglas | South Dakota | 46043 | 10 | 0 |
314788 | 314788 | 2020-07-08 | Douglas | South Dakota | 46043 | 10 | 0 |
317961 | 317961 | 2020-07-09 | Douglas | South Dakota | 46043 | 10 | 0 |
321139 | 321139 | 2020-07-10 | Douglas | South Dakota | 46043 | 10 | 0 |
324319 | 324319 | 2020-07-11 | Douglas | South Dakota | 46043 | 10 | 0 |
327504 | 327504 | 2020-07-12 | Douglas | South Dakota | 46043 | 10 | 0 |
330690 | 330690 | 2020-07-13 | Douglas | South Dakota | 46043 | 10 | 0 |
333882 | 333882 | 2020-07-14 | Douglas | South Dakota | 46043 | 10 | 0 |
337076 | 337076 | 2020-07-15 | Douglas | South Dakota | 46043 | 10 | 0 |
340273 | 340273 | 2020-07-16 | Douglas | South Dakota | 46043 | 10 | 0 |
343471 | 343471 | 2020-07-17 | Douglas | South Dakota | 46043 | 12 | 0 |
346671 | 346671 | 2020-07-18 | Douglas | South Dakota | 46043 | 13 | 0 |
349871 | 349871 | 2020-07-19 | Douglas | South Dakota | 46043 | 14 | 0 |
353074 | 353074 | 2020-07-20 | Douglas | South Dakota | 46043 | 15 | 0 |
356277 | 356277 | 2020-07-21 | Douglas | South Dakota | 46043 | 15 | 0 |
359481 | 359481 | 2020-07-22 | Douglas | South Dakota | 46043 | 15 | 0 |
362687 | 362687 | 2020-07-23 | Douglas | South Dakota | 46043 | 16 | 0 |
365893 | 365893 | 2020-07-24 | Douglas | South Dakota | 46043 | 16 | 0 |
369102 | 369102 | 2020-07-25 | Douglas | South Dakota | 46043 | 16 | 0 |
372314 | 372314 | 2020-07-26 | Douglas | South Dakota | 46043 | 16 | 0 |
375527 | 375527 | 2020-07-27 | Douglas | South Dakota | 46043 | 16 | 0 |
378743 | 378743 | 2020-07-28 | Douglas | South Dakota | 46043 | 16 | 0 |
381960 | 381960 | 2020-07-29 | Douglas | South Dakota | 46043 | 16 | 0 |
385178 | 385178 | 2020-07-30 | Douglas | South Dakota | 46043 | 16 | 0 |
388395 | 388395 | 2020-07-31 | Douglas | South Dakota | 46043 | 16 | 0 |
391612 | 391612 | 2020-08-01 | Douglas | South Dakota | 46043 | 16 | 0 |
394828 | 394828 | 2020-08-02 | Douglas | South Dakota | 46043 | 16 | 0 |
398045 | 398045 | 2020-08-03 | Douglas | South Dakota | 46043 | 16 | 0 |
401260 | 401260 | 2020-08-04 | Douglas | South Dakota | 46043 | 16 | 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);