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 deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- 2020-04-18 1
- 2020-04-19 1
- 2020-04-20 1
- 2020-04-21 1
- 2020-04-22 1
- 2020-04-23 1
- …
state 1
- South Dakota · 780 ✖
fips 1
- 46093 780
county 1
- Meade · 780 ✖
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
12055 | 12055 | 2020-03-25 | Meade | South Dakota | 46093 | 1 | 0 |
13677 | 13677 | 2020-03-26 | Meade | South Dakota | 46093 | 1 | 0 |
15427 | 15427 | 2020-03-27 | Meade | South Dakota | 46093 | 1 | 0 |
17285 | 17285 | 2020-03-28 | Meade | South Dakota | 46093 | 1 | 0 |
19228 | 19228 | 2020-03-29 | Meade | South Dakota | 46093 | 1 | 0 |
21281 | 21281 | 2020-03-30 | Meade | South Dakota | 46093 | 1 | 0 |
23419 | 23419 | 2020-03-31 | Meade | South Dakota | 46093 | 1 | 0 |
25617 | 25617 | 2020-04-01 | Meade | South Dakota | 46093 | 1 | 0 |
27894 | 27894 | 2020-04-02 | Meade | South Dakota | 46093 | 1 | 0 |
30229 | 30229 | 2020-04-03 | Meade | South Dakota | 46093 | 1 | 0 |
32620 | 32620 | 2020-04-04 | Meade | South Dakota | 46093 | 1 | 0 |
35056 | 35056 | 2020-04-05 | Meade | South Dakota | 46093 | 1 | 0 |
37531 | 37531 | 2020-04-06 | Meade | South Dakota | 46093 | 1 | 0 |
40054 | 40054 | 2020-04-07 | Meade | South Dakota | 46093 | 1 | 0 |
42614 | 42614 | 2020-04-08 | Meade | South Dakota | 46093 | 1 | 0 |
45202 | 45202 | 2020-04-09 | Meade | South Dakota | 46093 | 1 | 0 |
47819 | 47819 | 2020-04-10 | Meade | South Dakota | 46093 | 1 | 0 |
50476 | 50476 | 2020-04-11 | Meade | South Dakota | 46093 | 1 | 0 |
53149 | 53149 | 2020-04-12 | Meade | South Dakota | 46093 | 1 | 0 |
55835 | 55835 | 2020-04-13 | Meade | South Dakota | 46093 | 1 | 0 |
58538 | 58538 | 2020-04-14 | Meade | South Dakota | 46093 | 1 | 0 |
61253 | 61253 | 2020-04-15 | Meade | South Dakota | 46093 | 1 | 0 |
63979 | 63979 | 2020-04-16 | Meade | South Dakota | 46093 | 1 | 0 |
66725 | 66725 | 2020-04-17 | Meade | South Dakota | 46093 | 1 | 0 |
69483 | 69483 | 2020-04-18 | Meade | South Dakota | 46093 | 1 | 0 |
72250 | 72250 | 2020-04-19 | Meade | South Dakota | 46093 | 1 | 0 |
75025 | 75025 | 2020-04-20 | Meade | South Dakota | 46093 | 1 | 0 |
77807 | 77807 | 2020-04-21 | Meade | South Dakota | 46093 | 1 | 0 |
80597 | 80597 | 2020-04-22 | Meade | South Dakota | 46093 | 1 | 0 |
83396 | 83396 | 2020-04-23 | Meade | South Dakota | 46093 | 1 | 0 |
86200 | 86200 | 2020-04-24 | Meade | South Dakota | 46093 | 1 | 0 |
89015 | 89015 | 2020-04-25 | Meade | South Dakota | 46093 | 1 | 0 |
91832 | 91832 | 2020-04-26 | Meade | South Dakota | 46093 | 1 | 0 |
94660 | 94660 | 2020-04-27 | Meade | South Dakota | 46093 | 1 | 0 |
97500 | 97500 | 2020-04-28 | Meade | South Dakota | 46093 | 1 | 0 |
100350 | 100350 | 2020-04-29 | Meade | South Dakota | 46093 | 1 | 0 |
103203 | 103203 | 2020-04-30 | Meade | South Dakota | 46093 | 1 | 0 |
106066 | 106066 | 2020-05-01 | Meade | South Dakota | 46093 | 1 | 0 |
108933 | 108933 | 2020-05-02 | Meade | South Dakota | 46093 | 1 | 0 |
111807 | 111807 | 2020-05-03 | Meade | South Dakota | 46093 | 1 | 0 |
114689 | 114689 | 2020-05-04 | Meade | South Dakota | 46093 | 1 | 0 |
117645 | 117645 | 2020-05-05 | Meade | South Dakota | 46093 | 2 | 0 |
120608 | 120608 | 2020-05-06 | Meade | South Dakota | 46093 | 2 | 0 |
123586 | 123586 | 2020-05-07 | Meade | South Dakota | 46093 | 2 | 0 |
126569 | 126569 | 2020-05-08 | Meade | South Dakota | 46093 | 3 | 0 |
129558 | 129558 | 2020-05-09 | Meade | South Dakota | 46093 | 3 | 0 |
132547 | 132547 | 2020-05-10 | Meade | South Dakota | 46093 | 3 | 0 |
135538 | 135538 | 2020-05-11 | Meade | South Dakota | 46093 | 4 | 0 |
138528 | 138528 | 2020-05-12 | Meade | South Dakota | 46093 | 4 | 0 |
141524 | 141524 | 2020-05-13 | Meade | South Dakota | 46093 | 5 | 0 |
144520 | 144520 | 2020-05-14 | Meade | South Dakota | 46093 | 5 | 0 |
147521 | 147521 | 2020-05-15 | Meade | South Dakota | 46093 | 5 | 0 |
150529 | 150529 | 2020-05-16 | Meade | South Dakota | 46093 | 5 | 0 |
153540 | 153540 | 2020-05-17 | Meade | South Dakota | 46093 | 5 | 0 |
156557 | 156557 | 2020-05-18 | Meade | South Dakota | 46093 | 5 | 0 |
159578 | 159578 | 2020-05-19 | Meade | South Dakota | 46093 | 5 | 0 |
162605 | 162605 | 2020-05-20 | Meade | South Dakota | 46093 | 5 | 0 |
165634 | 165634 | 2020-05-21 | Meade | South Dakota | 46093 | 5 | 0 |
168670 | 168670 | 2020-05-22 | Meade | South Dakota | 46093 | 6 | 0 |
171709 | 171709 | 2020-05-23 | Meade | South Dakota | 46093 | 7 | 0 |
174752 | 174752 | 2020-05-24 | Meade | South Dakota | 46093 | 10 | 0 |
177796 | 177796 | 2020-05-25 | Meade | South Dakota | 46093 | 10 | 0 |
180839 | 180839 | 2020-05-26 | Meade | South Dakota | 46093 | 10 | 0 |
183889 | 183889 | 2020-05-27 | Meade | South Dakota | 46093 | 10 | 0 |
186946 | 186946 | 2020-05-28 | Meade | South Dakota | 46093 | 10 | 0 |
190010 | 190010 | 2020-05-29 | Meade | South Dakota | 46093 | 13 | 0 |
193075 | 193075 | 2020-05-30 | Meade | South Dakota | 46093 | 18 | 0 |
196145 | 196145 | 2020-05-31 | Meade | South Dakota | 46093 | 19 | 0 |
199218 | 199218 | 2020-06-01 | Meade | South Dakota | 46093 | 21 | 0 |
202293 | 202293 | 2020-06-02 | Meade | South Dakota | 46093 | 22 | 0 |
205372 | 205372 | 2020-06-03 | Meade | South Dakota | 46093 | 22 | 0 |
208454 | 208454 | 2020-06-04 | Meade | South Dakota | 46093 | 24 | 0 |
211536 | 211536 | 2020-06-05 | Meade | South Dakota | 46093 | 24 | 1 |
214623 | 214623 | 2020-06-06 | Meade | South Dakota | 46093 | 24 | 1 |
217713 | 217713 | 2020-06-07 | Meade | South Dakota | 46093 | 24 | 1 |
220805 | 220805 | 2020-06-08 | Meade | South Dakota | 46093 | 26 | 1 |
223900 | 223900 | 2020-06-09 | Meade | South Dakota | 46093 | 26 | 1 |
227000 | 227000 | 2020-06-10 | Meade | South Dakota | 46093 | 28 | 1 |
230104 | 230104 | 2020-06-11 | Meade | South Dakota | 46093 | 28 | 1 |
233209 | 233209 | 2020-06-12 | Meade | South Dakota | 46093 | 30 | 1 |
236314 | 236314 | 2020-06-13 | Meade | South Dakota | 46093 | 33 | 1 |
239422 | 239422 | 2020-06-14 | Meade | South Dakota | 46093 | 36 | 1 |
242532 | 242532 | 2020-06-15 | Meade | South Dakota | 46093 | 37 | 1 |
245644 | 245644 | 2020-06-16 | Meade | South Dakota | 46093 | 39 | 1 |
248757 | 248757 | 2020-06-17 | Meade | South Dakota | 46093 | 39 | 1 |
251872 | 251872 | 2020-06-18 | Meade | South Dakota | 46093 | 40 | 1 |
254987 | 254987 | 2020-06-19 | Meade | South Dakota | 46093 | 41 | 1 |
258113 | 258113 | 2020-06-20 | Meade | South Dakota | 46093 | 42 | 1 |
261240 | 261240 | 2020-06-21 | Meade | South Dakota | 46093 | 42 | 1 |
264368 | 264368 | 2020-06-22 | Meade | South Dakota | 46093 | 43 | 1 |
267496 | 267496 | 2020-06-23 | Meade | South Dakota | 46093 | 43 | 1 |
270630 | 270630 | 2020-06-24 | Meade | South Dakota | 46093 | 43 | 1 |
273769 | 273769 | 2020-06-25 | Meade | South Dakota | 46093 | 44 | 1 |
276916 | 276916 | 2020-06-26 | Meade | South Dakota | 46093 | 46 | 1 |
280064 | 280064 | 2020-06-27 | Meade | South Dakota | 46093 | 47 | 1 |
283210 | 283210 | 2020-06-28 | Meade | South Dakota | 46093 | 47 | 1 |
286355 | 286355 | 2020-06-29 | Meade | South Dakota | 46093 | 47 | 1 |
289506 | 289506 | 2020-06-30 | Meade | South Dakota | 46093 | 48 | 1 |
292658 | 292658 | 2020-07-01 | Meade | South Dakota | 46093 | 49 | 1 |
295814 | 295814 | 2020-07-02 | Meade | South Dakota | 46093 | 49 | 1 |
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);