ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
766 rows where fips = 46102 and state = "South Dakota" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
42616 | 42616 | 2020-04-08 | Oglala Lakota | South Dakota | 46102 | 1 | 0 |
45204 | 45204 | 2020-04-09 | Oglala Lakota | South Dakota | 46102 | 1 | 0 |
47822 | 47822 | 2020-04-10 | Oglala Lakota | South Dakota | 46102 | 1 | 0 |
50479 | 50479 | 2020-04-11 | Oglala Lakota | South Dakota | 46102 | 1 | 0 |
53152 | 53152 | 2020-04-12 | Oglala Lakota | South Dakota | 46102 | 1 | 0 |
55838 | 55838 | 2020-04-13 | Oglala Lakota | South Dakota | 46102 | 1 | 0 |
58541 | 58541 | 2020-04-14 | Oglala Lakota | South Dakota | 46102 | 1 | 0 |
61256 | 61256 | 2020-04-15 | Oglala Lakota | South Dakota | 46102 | 1 | 0 |
63983 | 63983 | 2020-04-16 | Oglala Lakota | South Dakota | 46102 | 1 | 0 |
66729 | 66729 | 2020-04-17 | Oglala Lakota | South Dakota | 46102 | 1 | 0 |
69487 | 69487 | 2020-04-18 | Oglala Lakota | South Dakota | 46102 | 1 | 0 |
72254 | 72254 | 2020-04-19 | Oglala Lakota | South Dakota | 46102 | 1 | 0 |
75029 | 75029 | 2020-04-20 | Oglala Lakota | South Dakota | 46102 | 1 | 0 |
77811 | 77811 | 2020-04-21 | Oglala Lakota | South Dakota | 46102 | 1 | 0 |
80601 | 80601 | 2020-04-22 | Oglala Lakota | South Dakota | 46102 | 1 | 0 |
83400 | 83400 | 2020-04-23 | Oglala Lakota | South Dakota | 46102 | 1 | 0 |
86204 | 86204 | 2020-04-24 | Oglala Lakota | South Dakota | 46102 | 1 | 0 |
89019 | 89019 | 2020-04-25 | Oglala Lakota | South Dakota | 46102 | 1 | 0 |
91836 | 91836 | 2020-04-26 | Oglala Lakota | South Dakota | 46102 | 1 | 0 |
94664 | 94664 | 2020-04-27 | Oglala Lakota | South Dakota | 46102 | 1 | 0 |
97504 | 97504 | 2020-04-28 | Oglala Lakota | South Dakota | 46102 | 1 | 0 |
100354 | 100354 | 2020-04-29 | Oglala Lakota | South Dakota | 46102 | 1 | 0 |
103207 | 103207 | 2020-04-30 | Oglala Lakota | South Dakota | 46102 | 1 | 0 |
106070 | 106070 | 2020-05-01 | Oglala Lakota | South Dakota | 46102 | 1 | 0 |
108937 | 108937 | 2020-05-02 | Oglala Lakota | South Dakota | 46102 | 1 | 0 |
111811 | 111811 | 2020-05-03 | Oglala Lakota | South Dakota | 46102 | 1 | 0 |
114693 | 114693 | 2020-05-04 | Oglala Lakota | South Dakota | 46102 | 1 | 0 |
117649 | 117649 | 2020-05-05 | Oglala Lakota | South Dakota | 46102 | 1 | 0 |
120612 | 120612 | 2020-05-06 | Oglala Lakota | South Dakota | 46102 | 2 | 0 |
123590 | 123590 | 2020-05-07 | Oglala Lakota | South Dakota | 46102 | 1 | 0 |
126573 | 126573 | 2020-05-08 | Oglala Lakota | South Dakota | 46102 | 1 | 0 |
129562 | 129562 | 2020-05-09 | Oglala Lakota | South Dakota | 46102 | 1 | 0 |
132551 | 132551 | 2020-05-10 | Oglala Lakota | South Dakota | 46102 | 1 | 0 |
135542 | 135542 | 2020-05-11 | Oglala Lakota | South Dakota | 46102 | 1 | 0 |
138532 | 138532 | 2020-05-12 | Oglala Lakota | South Dakota | 46102 | 1 | 0 |
141528 | 141528 | 2020-05-13 | Oglala Lakota | South Dakota | 46102 | 3 | 0 |
144524 | 144524 | 2020-05-14 | Oglala Lakota | South Dakota | 46102 | 3 | 0 |
147525 | 147525 | 2020-05-15 | Oglala Lakota | South Dakota | 46102 | 6 | 0 |
150533 | 150533 | 2020-05-16 | Oglala Lakota | South Dakota | 46102 | 9 | 0 |
153544 | 153544 | 2020-05-17 | Oglala Lakota | South Dakota | 46102 | 10 | 0 |
156561 | 156561 | 2020-05-18 | Oglala Lakota | South Dakota | 46102 | 10 | 0 |
159582 | 159582 | 2020-05-19 | Oglala Lakota | South Dakota | 46102 | 10 | 0 |
162609 | 162609 | 2020-05-20 | Oglala Lakota | South Dakota | 46102 | 14 | 0 |
165638 | 165638 | 2020-05-21 | Oglala Lakota | South Dakota | 46102 | 14 | 0 |
168674 | 168674 | 2020-05-22 | Oglala Lakota | South Dakota | 46102 | 15 | 0 |
171713 | 171713 | 2020-05-23 | Oglala Lakota | South Dakota | 46102 | 17 | 0 |
174756 | 174756 | 2020-05-24 | Oglala Lakota | South Dakota | 46102 | 17 | 0 |
177800 | 177800 | 2020-05-25 | Oglala Lakota | South Dakota | 46102 | 17 | 0 |
180843 | 180843 | 2020-05-26 | Oglala Lakota | South Dakota | 46102 | 17 | 0 |
183893 | 183893 | 2020-05-27 | Oglala Lakota | South Dakota | 46102 | 20 | 0 |
186950 | 186950 | 2020-05-28 | Oglala Lakota | South Dakota | 46102 | 21 | 0 |
190014 | 190014 | 2020-05-29 | Oglala Lakota | South Dakota | 46102 | 21 | 0 |
193079 | 193079 | 2020-05-30 | Oglala Lakota | South Dakota | 46102 | 25 | 0 |
196149 | 196149 | 2020-05-31 | Oglala Lakota | South Dakota | 46102 | 26 | 0 |
199222 | 199222 | 2020-06-01 | Oglala Lakota | South Dakota | 46102 | 31 | 0 |
202297 | 202297 | 2020-06-02 | Oglala Lakota | South Dakota | 46102 | 31 | 0 |
205376 | 205376 | 2020-06-03 | Oglala Lakota | South Dakota | 46102 | 32 | 0 |
208458 | 208458 | 2020-06-04 | Oglala Lakota | South Dakota | 46102 | 34 | 0 |
211540 | 211540 | 2020-06-05 | Oglala Lakota | South Dakota | 46102 | 35 | 0 |
214627 | 214627 | 2020-06-06 | Oglala Lakota | South Dakota | 46102 | 35 | 0 |
217717 | 217717 | 2020-06-07 | Oglala Lakota | South Dakota | 46102 | 39 | 0 |
220809 | 220809 | 2020-06-08 | Oglala Lakota | South Dakota | 46102 | 39 | 0 |
223904 | 223904 | 2020-06-09 | Oglala Lakota | South Dakota | 46102 | 40 | 0 |
227004 | 227004 | 2020-06-10 | Oglala Lakota | South Dakota | 46102 | 45 | 0 |
230108 | 230108 | 2020-06-11 | Oglala Lakota | South Dakota | 46102 | 45 | 0 |
233213 | 233213 | 2020-06-12 | Oglala Lakota | South Dakota | 46102 | 45 | 0 |
236319 | 236319 | 2020-06-13 | Oglala Lakota | South Dakota | 46102 | 45 | 0 |
239427 | 239427 | 2020-06-14 | Oglala Lakota | South Dakota | 46102 | 46 | 0 |
242537 | 242537 | 2020-06-15 | Oglala Lakota | South Dakota | 46102 | 46 | 0 |
245649 | 245649 | 2020-06-16 | Oglala Lakota | South Dakota | 46102 | 48 | 0 |
248762 | 248762 | 2020-06-17 | Oglala Lakota | South Dakota | 46102 | 49 | 0 |
251877 | 251877 | 2020-06-18 | Oglala Lakota | South Dakota | 46102 | 54 | 0 |
254992 | 254992 | 2020-06-19 | Oglala Lakota | South Dakota | 46102 | 53 | 0 |
258118 | 258118 | 2020-06-20 | Oglala Lakota | South Dakota | 46102 | 54 | 0 |
261245 | 261245 | 2020-06-21 | Oglala Lakota | South Dakota | 46102 | 55 | 0 |
264373 | 264373 | 2020-06-22 | Oglala Lakota | South Dakota | 46102 | 56 | 0 |
267501 | 267501 | 2020-06-23 | Oglala Lakota | South Dakota | 46102 | 59 | 0 |
270635 | 270635 | 2020-06-24 | Oglala Lakota | South Dakota | 46102 | 60 | 0 |
273774 | 273774 | 2020-06-25 | Oglala Lakota | South Dakota | 46102 | 65 | 0 |
276921 | 276921 | 2020-06-26 | Oglala Lakota | South Dakota | 46102 | 68 | 0 |
280069 | 280069 | 2020-06-27 | Oglala Lakota | South Dakota | 46102 | 83 | 0 |
283215 | 283215 | 2020-06-28 | Oglala Lakota | South Dakota | 46102 | 84 | 0 |
286360 | 286360 | 2020-06-29 | Oglala Lakota | South Dakota | 46102 | 85 | 0 |
289511 | 289511 | 2020-06-30 | Oglala Lakota | South Dakota | 46102 | 85 | 0 |
292663 | 292663 | 2020-07-01 | Oglala Lakota | South Dakota | 46102 | 87 | 0 |
295819 | 295819 | 2020-07-02 | Oglala Lakota | South Dakota | 46102 | 88 | 0 |
298979 | 298979 | 2020-07-03 | Oglala Lakota | South Dakota | 46102 | 89 | 0 |
302143 | 302143 | 2020-07-04 | Oglala Lakota | South Dakota | 46102 | 94 | 0 |
305306 | 305306 | 2020-07-05 | Oglala Lakota | South Dakota | 46102 | 95 | 0 |
308474 | 308474 | 2020-07-06 | Oglala Lakota | South Dakota | 46102 | 99 | 0 |
311643 | 311643 | 2020-07-07 | Oglala Lakota | South Dakota | 46102 | 100 | 0 |
314817 | 314817 | 2020-07-08 | Oglala Lakota | South Dakota | 46102 | 103 | 0 |
317990 | 317990 | 2020-07-09 | Oglala Lakota | South Dakota | 46102 | 108 | 0 |
321168 | 321168 | 2020-07-10 | Oglala Lakota | South Dakota | 46102 | 108 | 0 |
324348 | 324348 | 2020-07-11 | Oglala Lakota | South Dakota | 46102 | 109 | 0 |
327533 | 327533 | 2020-07-12 | Oglala Lakota | South Dakota | 46102 | 112 | 0 |
330719 | 330719 | 2020-07-13 | Oglala Lakota | South Dakota | 46102 | 112 | 0 |
333911 | 333911 | 2020-07-14 | Oglala Lakota | South Dakota | 46102 | 111 | 0 |
337105 | 337105 | 2020-07-15 | Oglala Lakota | South Dakota | 46102 | 118 | 0 |
340302 | 340302 | 2020-07-16 | Oglala Lakota | South Dakota | 46102 | 122 | 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);