ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 38085 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
17030 | 17030 | 2020-03-28 | Sioux | North Dakota | 38085 | 1 | 0 |
18964 | 18964 | 2020-03-29 | Sioux | North Dakota | 38085 | 1 | 0 |
21007 | 21007 | 2020-03-30 | Sioux | North Dakota | 38085 | 1 | 0 |
23138 | 23138 | 2020-03-31 | Sioux | North Dakota | 38085 | 1 | 0 |
25333 | 25333 | 2020-04-01 | Sioux | North Dakota | 38085 | 1 | 0 |
27599 | 27599 | 2020-04-02 | Sioux | North Dakota | 38085 | 1 | 0 |
29927 | 29927 | 2020-04-03 | Sioux | North Dakota | 38085 | 1 | 0 |
32315 | 32315 | 2020-04-04 | Sioux | North Dakota | 38085 | 1 | 0 |
34748 | 34748 | 2020-04-05 | Sioux | North Dakota | 38085 | 1 | 0 |
37217 | 37217 | 2020-04-06 | Sioux | North Dakota | 38085 | 1 | 0 |
39734 | 39734 | 2020-04-07 | Sioux | North Dakota | 38085 | 1 | 0 |
42291 | 42291 | 2020-04-08 | Sioux | North Dakota | 38085 | 1 | 0 |
44876 | 44876 | 2020-04-09 | Sioux | North Dakota | 38085 | 1 | 0 |
47490 | 47490 | 2020-04-10 | Sioux | North Dakota | 38085 | 1 | 0 |
50146 | 50146 | 2020-04-11 | Sioux | North Dakota | 38085 | 1 | 0 |
52819 | 52819 | 2020-04-12 | Sioux | North Dakota | 38085 | 1 | 0 |
55503 | 55503 | 2020-04-13 | Sioux | North Dakota | 38085 | 1 | 0 |
58204 | 58204 | 2020-04-14 | Sioux | North Dakota | 38085 | 1 | 0 |
60918 | 60918 | 2020-04-15 | Sioux | North Dakota | 38085 | 1 | 0 |
63644 | 63644 | 2020-04-16 | Sioux | North Dakota | 38085 | 1 | 0 |
66387 | 66387 | 2020-04-17 | Sioux | North Dakota | 38085 | 1 | 0 |
69144 | 69144 | 2020-04-18 | Sioux | North Dakota | 38085 | 1 | 0 |
71911 | 71911 | 2020-04-19 | Sioux | North Dakota | 38085 | 1 | 0 |
74686 | 74686 | 2020-04-20 | Sioux | North Dakota | 38085 | 1 | 0 |
77467 | 77467 | 2020-04-21 | Sioux | North Dakota | 38085 | 2 | 0 |
80256 | 80256 | 2020-04-22 | Sioux | North Dakota | 38085 | 1 | 0 |
83055 | 83055 | 2020-04-23 | Sioux | North Dakota | 38085 | 1 | 0 |
85859 | 85859 | 2020-04-24 | Sioux | North Dakota | 38085 | 1 | 0 |
88673 | 88673 | 2020-04-25 | Sioux | North Dakota | 38085 | 1 | 0 |
91489 | 91489 | 2020-04-26 | Sioux | North Dakota | 38085 | 1 | 0 |
94315 | 94315 | 2020-04-27 | Sioux | North Dakota | 38085 | 1 | 0 |
97152 | 97152 | 2020-04-28 | Sioux | North Dakota | 38085 | 1 | 0 |
100001 | 100001 | 2020-04-29 | Sioux | North Dakota | 38085 | 1 | 0 |
102854 | 102854 | 2020-04-30 | Sioux | North Dakota | 38085 | 1 | 0 |
105717 | 105717 | 2020-05-01 | Sioux | North Dakota | 38085 | 1 | 0 |
108584 | 108584 | 2020-05-02 | Sioux | North Dakota | 38085 | 1 | 0 |
111458 | 111458 | 2020-05-03 | Sioux | North Dakota | 38085 | 1 | 0 |
114339 | 114339 | 2020-05-04 | Sioux | North Dakota | 38085 | 1 | 0 |
117220 | 117220 | 2020-05-05 | Sioux | North Dakota | 38085 | 1 | 0 |
120181 | 120181 | 2020-05-06 | Sioux | North Dakota | 38085 | 1 | 0 |
123157 | 123157 | 2020-05-07 | Sioux | North Dakota | 38085 | 1 | 0 |
126140 | 126140 | 2020-05-08 | Sioux | North Dakota | 38085 | 1 | 0 |
129129 | 129129 | 2020-05-09 | Sioux | North Dakota | 38085 | 1 | 0 |
132118 | 132118 | 2020-05-10 | Sioux | North Dakota | 38085 | 1 | 0 |
135109 | 135109 | 2020-05-11 | Sioux | North Dakota | 38085 | 1 | 0 |
138099 | 138099 | 2020-05-12 | Sioux | North Dakota | 38085 | 1 | 0 |
141095 | 141095 | 2020-05-13 | Sioux | North Dakota | 38085 | 1 | 0 |
144090 | 144090 | 2020-05-14 | Sioux | North Dakota | 38085 | 1 | 0 |
147091 | 147091 | 2020-05-15 | Sioux | North Dakota | 38085 | 1 | 0 |
150098 | 150098 | 2020-05-16 | Sioux | North Dakota | 38085 | 1 | 0 |
153108 | 153108 | 2020-05-17 | Sioux | North Dakota | 38085 | 1 | 0 |
156125 | 156125 | 2020-05-18 | Sioux | North Dakota | 38085 | 2 | 0 |
159145 | 159145 | 2020-05-19 | Sioux | North Dakota | 38085 | 2 | 0 |
162172 | 162172 | 2020-05-20 | Sioux | North Dakota | 38085 | 2 | 0 |
165201 | 165201 | 2020-05-21 | Sioux | North Dakota | 38085 | 2 | 0 |
168237 | 168237 | 2020-05-22 | Sioux | North Dakota | 38085 | 2 | 0 |
171276 | 171276 | 2020-05-23 | Sioux | North Dakota | 38085 | 2 | 0 |
174318 | 174318 | 2020-05-24 | Sioux | North Dakota | 38085 | 2 | 0 |
177362 | 177362 | 2020-05-25 | Sioux | North Dakota | 38085 | 2 | 0 |
180405 | 180405 | 2020-05-26 | Sioux | North Dakota | 38085 | 2 | 0 |
183453 | 183453 | 2020-05-27 | Sioux | North Dakota | 38085 | 2 | 0 |
186510 | 186510 | 2020-05-28 | Sioux | North Dakota | 38085 | 2 | 0 |
189570 | 189570 | 2020-05-29 | Sioux | North Dakota | 38085 | 2 | 0 |
192634 | 192634 | 2020-05-30 | Sioux | North Dakota | 38085 | 2 | 0 |
195704 | 195704 | 2020-05-31 | Sioux | North Dakota | 38085 | 2 | 0 |
198777 | 198777 | 2020-06-01 | Sioux | North Dakota | 38085 | 1 | 0 |
201852 | 201852 | 2020-06-02 | Sioux | North Dakota | 38085 | 1 | 0 |
204929 | 204929 | 2020-06-03 | Sioux | North Dakota | 38085 | 1 | 0 |
208010 | 208010 | 2020-06-04 | Sioux | North Dakota | 38085 | 1 | 0 |
211092 | 211092 | 2020-06-05 | Sioux | North Dakota | 38085 | 2 | 0 |
214178 | 214178 | 2020-06-06 | Sioux | North Dakota | 38085 | 2 | 0 |
217268 | 217268 | 2020-06-07 | Sioux | North Dakota | 38085 | 2 | 0 |
220360 | 220360 | 2020-06-08 | Sioux | North Dakota | 38085 | 2 | 0 |
223455 | 223455 | 2020-06-09 | Sioux | North Dakota | 38085 | 2 | 0 |
226555 | 226555 | 2020-06-10 | Sioux | North Dakota | 38085 | 2 | 0 |
229659 | 229659 | 2020-06-11 | Sioux | North Dakota | 38085 | 2 | 0 |
232764 | 232764 | 2020-06-12 | Sioux | North Dakota | 38085 | 3 | 0 |
235869 | 235869 | 2020-06-13 | Sioux | North Dakota | 38085 | 3 | 0 |
238977 | 238977 | 2020-06-14 | Sioux | North Dakota | 38085 | 3 | 0 |
242086 | 242086 | 2020-06-15 | Sioux | North Dakota | 38085 | 4 | 0 |
245198 | 245198 | 2020-06-16 | Sioux | North Dakota | 38085 | 4 | 0 |
248311 | 248311 | 2020-06-17 | Sioux | North Dakota | 38085 | 7 | 0 |
251426 | 251426 | 2020-06-18 | Sioux | North Dakota | 38085 | 10 | 0 |
254541 | 254541 | 2020-06-19 | Sioux | North Dakota | 38085 | 12 | 0 |
257666 | 257666 | 2020-06-20 | Sioux | North Dakota | 38085 | 12 | 0 |
260793 | 260793 | 2020-06-21 | Sioux | North Dakota | 38085 | 12 | 0 |
263921 | 263921 | 2020-06-22 | Sioux | North Dakota | 38085 | 19 | 0 |
267049 | 267049 | 2020-06-23 | Sioux | North Dakota | 38085 | 19 | 0 |
270183 | 270183 | 2020-06-24 | Sioux | North Dakota | 38085 | 20 | 0 |
273322 | 273322 | 2020-06-25 | Sioux | North Dakota | 38085 | 20 | 0 |
276469 | 276469 | 2020-06-26 | Sioux | North Dakota | 38085 | 20 | 0 |
279617 | 279617 | 2020-06-27 | Sioux | North Dakota | 38085 | 21 | 0 |
282763 | 282763 | 2020-06-28 | Sioux | North Dakota | 38085 | 21 | 0 |
285908 | 285908 | 2020-06-29 | Sioux | North Dakota | 38085 | 24 | 0 |
289058 | 289058 | 2020-06-30 | Sioux | North Dakota | 38085 | 24 | 0 |
292210 | 292210 | 2020-07-01 | Sioux | North Dakota | 38085 | 24 | 0 |
295365 | 295365 | 2020-07-02 | Sioux | North Dakota | 38085 | 23 | 0 |
298525 | 298525 | 2020-07-03 | Sioux | North Dakota | 38085 | 25 | 0 |
301688 | 301688 | 2020-07-04 | Sioux | North Dakota | 38085 | 25 | 0 |
304851 | 304851 | 2020-07-05 | Sioux | North Dakota | 38085 | 25 | 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);