ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Meade" and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388419 | 388419 | 2020-07-31 | Meade | South Dakota | 46093 | 71 | 1 |
385202 | 385202 | 2020-07-30 | Meade | South Dakota | 46093 | 69 | 1 |
381984 | 381984 | 2020-07-29 | Meade | South Dakota | 46093 | 68 | 1 |
378767 | 378767 | 2020-07-28 | Meade | South Dakota | 46093 | 67 | 1 |
375551 | 375551 | 2020-07-27 | Meade | South Dakota | 46093 | 67 | 1 |
372338 | 372338 | 2020-07-26 | Meade | South Dakota | 46093 | 65 | 1 |
369126 | 369126 | 2020-07-25 | Meade | South Dakota | 46093 | 63 | 1 |
365917 | 365917 | 2020-07-24 | Meade | South Dakota | 46093 | 64 | 1 |
362711 | 362711 | 2020-07-23 | Meade | South Dakota | 46093 | 63 | 1 |
359505 | 359505 | 2020-07-22 | Meade | South Dakota | 46093 | 60 | 1 |
356301 | 356301 | 2020-07-21 | Meade | South Dakota | 46093 | 59 | 1 |
353098 | 353098 | 2020-07-20 | Meade | South Dakota | 46093 | 58 | 1 |
349895 | 349895 | 2020-07-19 | Meade | South Dakota | 46093 | 58 | 1 |
346695 | 346695 | 2020-07-18 | Meade | South Dakota | 46093 | 58 | 1 |
343495 | 343495 | 2020-07-17 | Meade | South Dakota | 46093 | 58 | 1 |
340297 | 340297 | 2020-07-16 | Meade | South Dakota | 46093 | 58 | 1 |
337100 | 337100 | 2020-07-15 | Meade | South Dakota | 46093 | 54 | 1 |
333906 | 333906 | 2020-07-14 | Meade | South Dakota | 46093 | 54 | 1 |
330714 | 330714 | 2020-07-13 | Meade | South Dakota | 46093 | 54 | 1 |
327528 | 327528 | 2020-07-12 | Meade | South Dakota | 46093 | 53 | 1 |
324343 | 324343 | 2020-07-11 | Meade | South Dakota | 46093 | 53 | 1 |
321163 | 321163 | 2020-07-10 | Meade | South Dakota | 46093 | 53 | 1 |
317985 | 317985 | 2020-07-09 | Meade | South Dakota | 46093 | 53 | 1 |
314812 | 314812 | 2020-07-08 | Meade | South Dakota | 46093 | 53 | 1 |
311638 | 311638 | 2020-07-07 | Meade | South Dakota | 46093 | 52 | 1 |
308469 | 308469 | 2020-07-06 | Meade | South Dakota | 46093 | 51 | 1 |
305301 | 305301 | 2020-07-05 | Meade | South Dakota | 46093 | 51 | 1 |
302138 | 302138 | 2020-07-04 | Meade | South Dakota | 46093 | 50 | 1 |
298974 | 298974 | 2020-07-03 | Meade | South Dakota | 46093 | 50 | 1 |
295814 | 295814 | 2020-07-02 | Meade | South Dakota | 46093 | 49 | 1 |
292658 | 292658 | 2020-07-01 | Meade | South Dakota | 46093 | 49 | 1 |
289506 | 289506 | 2020-06-30 | Meade | South Dakota | 46093 | 48 | 1 |
286355 | 286355 | 2020-06-29 | Meade | South Dakota | 46093 | 47 | 1 |
283210 | 283210 | 2020-06-28 | Meade | South Dakota | 46093 | 47 | 1 |
280064 | 280064 | 2020-06-27 | Meade | South Dakota | 46093 | 47 | 1 |
276916 | 276916 | 2020-06-26 | Meade | South Dakota | 46093 | 46 | 1 |
273769 | 273769 | 2020-06-25 | Meade | South Dakota | 46093 | 44 | 1 |
270630 | 270630 | 2020-06-24 | Meade | South Dakota | 46093 | 43 | 1 |
267496 | 267496 | 2020-06-23 | Meade | South Dakota | 46093 | 43 | 1 |
264368 | 264368 | 2020-06-22 | Meade | South Dakota | 46093 | 43 | 1 |
261240 | 261240 | 2020-06-21 | Meade | South Dakota | 46093 | 42 | 1 |
258113 | 258113 | 2020-06-20 | Meade | South Dakota | 46093 | 42 | 1 |
254987 | 254987 | 2020-06-19 | Meade | South Dakota | 46093 | 41 | 1 |
251872 | 251872 | 2020-06-18 | Meade | South Dakota | 46093 | 40 | 1 |
248757 | 248757 | 2020-06-17 | Meade | South Dakota | 46093 | 39 | 1 |
245644 | 245644 | 2020-06-16 | Meade | South Dakota | 46093 | 39 | 1 |
242532 | 242532 | 2020-06-15 | Meade | South Dakota | 46093 | 37 | 1 |
239422 | 239422 | 2020-06-14 | Meade | South Dakota | 46093 | 36 | 1 |
236314 | 236314 | 2020-06-13 | Meade | South Dakota | 46093 | 33 | 1 |
233209 | 233209 | 2020-06-12 | Meade | South Dakota | 46093 | 30 | 1 |
230104 | 230104 | 2020-06-11 | Meade | South Dakota | 46093 | 28 | 1 |
227000 | 227000 | 2020-06-10 | Meade | South Dakota | 46093 | 28 | 1 |
223900 | 223900 | 2020-06-09 | Meade | South Dakota | 46093 | 26 | 1 |
220805 | 220805 | 2020-06-08 | Meade | South Dakota | 46093 | 26 | 1 |
217713 | 217713 | 2020-06-07 | Meade | South Dakota | 46093 | 24 | 1 |
214623 | 214623 | 2020-06-06 | Meade | South Dakota | 46093 | 24 | 1 |
211536 | 211536 | 2020-06-05 | Meade | South Dakota | 46093 | 24 | 1 |
208454 | 208454 | 2020-06-04 | Meade | South Dakota | 46093 | 24 | 0 |
205372 | 205372 | 2020-06-03 | Meade | South Dakota | 46093 | 22 | 0 |
202293 | 202293 | 2020-06-02 | Meade | South Dakota | 46093 | 22 | 0 |
199218 | 199218 | 2020-06-01 | Meade | South Dakota | 46093 | 21 | 0 |
196145 | 196145 | 2020-05-31 | Meade | South Dakota | 46093 | 19 | 0 |
193075 | 193075 | 2020-05-30 | Meade | South Dakota | 46093 | 18 | 0 |
190010 | 190010 | 2020-05-29 | Meade | South Dakota | 46093 | 13 | 0 |
186946 | 186946 | 2020-05-28 | Meade | South Dakota | 46093 | 10 | 0 |
183889 | 183889 | 2020-05-27 | Meade | South Dakota | 46093 | 10 | 0 |
180839 | 180839 | 2020-05-26 | Meade | South Dakota | 46093 | 10 | 0 |
177796 | 177796 | 2020-05-25 | Meade | South Dakota | 46093 | 10 | 0 |
174752 | 174752 | 2020-05-24 | Meade | South Dakota | 46093 | 10 | 0 |
171709 | 171709 | 2020-05-23 | Meade | South Dakota | 46093 | 7 | 0 |
168670 | 168670 | 2020-05-22 | Meade | South Dakota | 46093 | 6 | 0 |
165634 | 165634 | 2020-05-21 | Meade | South Dakota | 46093 | 5 | 0 |
162605 | 162605 | 2020-05-20 | Meade | South Dakota | 46093 | 5 | 0 |
159578 | 159578 | 2020-05-19 | Meade | South Dakota | 46093 | 5 | 0 |
156557 | 156557 | 2020-05-18 | Meade | South Dakota | 46093 | 5 | 0 |
153540 | 153540 | 2020-05-17 | Meade | South Dakota | 46093 | 5 | 0 |
150529 | 150529 | 2020-05-16 | Meade | South Dakota | 46093 | 5 | 0 |
147521 | 147521 | 2020-05-15 | Meade | South Dakota | 46093 | 5 | 0 |
144520 | 144520 | 2020-05-14 | Meade | South Dakota | 46093 | 5 | 0 |
141524 | 141524 | 2020-05-13 | Meade | South Dakota | 46093 | 5 | 0 |
138528 | 138528 | 2020-05-12 | Meade | South Dakota | 46093 | 4 | 0 |
135538 | 135538 | 2020-05-11 | Meade | South Dakota | 46093 | 4 | 0 |
132547 | 132547 | 2020-05-10 | Meade | South Dakota | 46093 | 3 | 0 |
129558 | 129558 | 2020-05-09 | Meade | South Dakota | 46093 | 3 | 0 |
126569 | 126569 | 2020-05-08 | Meade | South Dakota | 46093 | 3 | 0 |
123586 | 123586 | 2020-05-07 | Meade | South Dakota | 46093 | 2 | 0 |
120608 | 120608 | 2020-05-06 | Meade | South Dakota | 46093 | 2 | 0 |
117645 | 117645 | 2020-05-05 | Meade | South Dakota | 46093 | 2 | 0 |
114689 | 114689 | 2020-05-04 | Meade | South Dakota | 46093 | 1 | 0 |
111807 | 111807 | 2020-05-03 | Meade | South Dakota | 46093 | 1 | 0 |
108933 | 108933 | 2020-05-02 | Meade | South Dakota | 46093 | 1 | 0 |
106066 | 106066 | 2020-05-01 | Meade | South Dakota | 46093 | 1 | 0 |
103203 | 103203 | 2020-04-30 | Meade | South Dakota | 46093 | 1 | 0 |
100350 | 100350 | 2020-04-29 | Meade | South Dakota | 46093 | 1 | 0 |
97500 | 97500 | 2020-04-28 | Meade | South Dakota | 46093 | 1 | 0 |
94660 | 94660 | 2020-04-27 | Meade | South Dakota | 46093 | 1 | 0 |
91832 | 91832 | 2020-04-26 | Meade | South Dakota | 46093 | 1 | 0 |
89015 | 89015 | 2020-04-25 | Meade | South Dakota | 46093 | 1 | 0 |
86200 | 86200 | 2020-04-24 | Meade | South Dakota | 46093 | 1 | 0 |
83396 | 83396 | 2020-04-23 | Meade | South Dakota | 46093 | 1 | 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);