ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
759 rows where county = "Miller" and fips = 29131 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
60558 | 60558 | 2020-04-15 | Miller | Missouri | 29131 | 1 | 0 |
63280 | 63280 | 2020-04-16 | Miller | Missouri | 29131 | 1 | 0 |
66020 | 66020 | 2020-04-17 | Miller | Missouri | 29131 | 1 | 0 |
68774 | 68774 | 2020-04-18 | Miller | Missouri | 29131 | 1 | 0 |
71541 | 71541 | 2020-04-19 | Miller | Missouri | 29131 | 1 | 0 |
74314 | 74314 | 2020-04-20 | Miller | Missouri | 29131 | 1 | 0 |
77095 | 77095 | 2020-04-21 | Miller | Missouri | 29131 | 1 | 0 |
79881 | 79881 | 2020-04-22 | Miller | Missouri | 29131 | 1 | 0 |
82677 | 82677 | 2020-04-23 | Miller | Missouri | 29131 | 1 | 0 |
85481 | 85481 | 2020-04-24 | Miller | Missouri | 29131 | 1 | 0 |
88291 | 88291 | 2020-04-25 | Miller | Missouri | 29131 | 1 | 0 |
91107 | 91107 | 2020-04-26 | Miller | Missouri | 29131 | 1 | 0 |
93928 | 93928 | 2020-04-27 | Miller | Missouri | 29131 | 1 | 0 |
96764 | 96764 | 2020-04-28 | Miller | Missouri | 29131 | 1 | 0 |
99610 | 99610 | 2020-04-29 | Miller | Missouri | 29131 | 1 | 0 |
102462 | 102462 | 2020-04-30 | Miller | Missouri | 29131 | 1 | 0 |
105323 | 105323 | 2020-05-01 | Miller | Missouri | 29131 | 1 | 0 |
108188 | 108188 | 2020-05-02 | Miller | Missouri | 29131 | 2 | 0 |
111060 | 111060 | 2020-05-03 | Miller | Missouri | 29131 | 2 | 0 |
113939 | 113939 | 2020-05-04 | Miller | Missouri | 29131 | 2 | 0 |
116821 | 116821 | 2020-05-05 | Miller | Missouri | 29131 | 2 | 0 |
119781 | 119781 | 2020-05-06 | Miller | Missouri | 29131 | 2 | 0 |
122755 | 122755 | 2020-05-07 | Miller | Missouri | 29131 | 3 | 0 |
125737 | 125737 | 2020-05-08 | Miller | Missouri | 29131 | 3 | 0 |
128725 | 128725 | 2020-05-09 | Miller | Missouri | 29131 | 3 | 0 |
131715 | 131715 | 2020-05-10 | Miller | Missouri | 29131 | 3 | 0 |
134706 | 134706 | 2020-05-11 | Miller | Missouri | 29131 | 3 | 0 |
137696 | 137696 | 2020-05-12 | Miller | Missouri | 29131 | 4 | 0 |
140690 | 140690 | 2020-05-13 | Miller | Missouri | 29131 | 4 | 0 |
143685 | 143685 | 2020-05-14 | Miller | Missouri | 29131 | 4 | 0 |
146686 | 146686 | 2020-05-15 | Miller | Missouri | 29131 | 4 | 0 |
149691 | 149691 | 2020-05-16 | Miller | Missouri | 29131 | 4 | 0 |
152702 | 152702 | 2020-05-17 | Miller | Missouri | 29131 | 4 | 0 |
155716 | 155716 | 2020-05-18 | Miller | Missouri | 29131 | 4 | 0 |
158734 | 158734 | 2020-05-19 | Miller | Missouri | 29131 | 4 | 0 |
161760 | 161760 | 2020-05-20 | Miller | Missouri | 29131 | 4 | 0 |
164789 | 164789 | 2020-05-21 | Miller | Missouri | 29131 | 4 | 0 |
167825 | 167825 | 2020-05-22 | Miller | Missouri | 29131 | 4 | 0 |
170864 | 170864 | 2020-05-23 | Miller | Missouri | 29131 | 4 | 0 |
173906 | 173906 | 2020-05-24 | Miller | Missouri | 29131 | 4 | 0 |
176949 | 176949 | 2020-05-25 | Miller | Missouri | 29131 | 4 | 0 |
179993 | 179993 | 2020-05-26 | Miller | Missouri | 29131 | 4 | 0 |
183039 | 183039 | 2020-05-27 | Miller | Missouri | 29131 | 4 | 0 |
186095 | 186095 | 2020-05-28 | Miller | Missouri | 29131 | 4 | 0 |
189153 | 189153 | 2020-05-29 | Miller | Missouri | 29131 | 4 | 0 |
192217 | 192217 | 2020-05-30 | Miller | Missouri | 29131 | 4 | 0 |
195287 | 195287 | 2020-05-31 | Miller | Missouri | 29131 | 4 | 0 |
198358 | 198358 | 2020-06-01 | Miller | Missouri | 29131 | 4 | 0 |
201431 | 201431 | 2020-06-02 | Miller | Missouri | 29131 | 4 | 0 |
204508 | 204508 | 2020-06-03 | Miller | Missouri | 29131 | 4 | 0 |
207589 | 207589 | 2020-06-04 | Miller | Missouri | 29131 | 4 | 0 |
210670 | 210670 | 2020-06-05 | Miller | Missouri | 29131 | 4 | 0 |
213754 | 213754 | 2020-06-06 | Miller | Missouri | 29131 | 4 | 0 |
216842 | 216842 | 2020-06-07 | Miller | Missouri | 29131 | 4 | 0 |
219934 | 219934 | 2020-06-08 | Miller | Missouri | 29131 | 4 | 0 |
223029 | 223029 | 2020-06-09 | Miller | Missouri | 29131 | 4 | 0 |
226128 | 226128 | 2020-06-10 | Miller | Missouri | 29131 | 5 | 0 |
229231 | 229231 | 2020-06-11 | Miller | Missouri | 29131 | 4 | 0 |
232335 | 232335 | 2020-06-12 | Miller | Missouri | 29131 | 4 | 0 |
235441 | 235441 | 2020-06-13 | Miller | Missouri | 29131 | 4 | 0 |
238548 | 238548 | 2020-06-14 | Miller | Missouri | 29131 | 4 | 0 |
241658 | 241658 | 2020-06-15 | Miller | Missouri | 29131 | 6 | 0 |
244769 | 244769 | 2020-06-16 | Miller | Missouri | 29131 | 7 | 0 |
247882 | 247882 | 2020-06-17 | Miller | Missouri | 29131 | 7 | 0 |
250995 | 250995 | 2020-06-18 | Miller | Missouri | 29131 | 8 | 0 |
254110 | 254110 | 2020-06-19 | Miller | Missouri | 29131 | 8 | 0 |
257230 | 257230 | 2020-06-20 | Miller | Missouri | 29131 | 10 | 0 |
260356 | 260356 | 2020-06-21 | Miller | Missouri | 29131 | 10 | 0 |
263484 | 263484 | 2020-06-22 | Miller | Missouri | 29131 | 11 | 0 |
266610 | 266610 | 2020-06-23 | Miller | Missouri | 29131 | 11 | 0 |
269743 | 269743 | 2020-06-24 | Miller | Missouri | 29131 | 11 | 0 |
272882 | 272882 | 2020-06-25 | Miller | Missouri | 29131 | 11 | 0 |
276025 | 276025 | 2020-06-26 | Miller | Missouri | 29131 | 12 | 0 |
279173 | 279173 | 2020-06-27 | Miller | Missouri | 29131 | 12 | 0 |
282321 | 282321 | 2020-06-28 | Miller | Missouri | 29131 | 12 | 0 |
285466 | 285466 | 2020-06-29 | Miller | Missouri | 29131 | 14 | 0 |
288616 | 288616 | 2020-06-30 | Miller | Missouri | 29131 | 15 | 0 |
291767 | 291767 | 2020-07-01 | Miller | Missouri | 29131 | 15 | 0 |
294921 | 294921 | 2020-07-02 | Miller | Missouri | 29131 | 17 | 0 |
298079 | 298079 | 2020-07-03 | Miller | Missouri | 29131 | 19 | 0 |
301242 | 301242 | 2020-07-04 | Miller | Missouri | 29131 | 19 | 0 |
304406 | 304406 | 2020-07-05 | Miller | Missouri | 29131 | 19 | 0 |
307573 | 307573 | 2020-07-06 | Miller | Missouri | 29131 | 19 | 0 |
310741 | 310741 | 2020-07-07 | Miller | Missouri | 29131 | 20 | 0 |
313912 | 313912 | 2020-07-08 | Miller | Missouri | 29131 | 22 | 0 |
317086 | 317086 | 2020-07-09 | Miller | Missouri | 29131 | 22 | 0 |
320261 | 320261 | 2020-07-10 | Miller | Missouri | 29131 | 23 | 0 |
323440 | 323440 | 2020-07-11 | Miller | Missouri | 29131 | 24 | 0 |
326623 | 326623 | 2020-07-12 | Miller | Missouri | 29131 | 24 | 0 |
329809 | 329809 | 2020-07-13 | Miller | Missouri | 29131 | 25 | 0 |
332996 | 332996 | 2020-07-14 | Miller | Missouri | 29131 | 28 | 0 |
336189 | 336189 | 2020-07-15 | Miller | Missouri | 29131 | 29 | 0 |
339385 | 339385 | 2020-07-16 | Miller | Missouri | 29131 | 31 | 0 |
342581 | 342581 | 2020-07-17 | Miller | Missouri | 29131 | 35 | 0 |
345781 | 345781 | 2020-07-18 | Miller | Missouri | 29131 | 41 | 0 |
348982 | 348982 | 2020-07-19 | Miller | Missouri | 29131 | 42 | 0 |
352182 | 352182 | 2020-07-20 | Miller | Missouri | 29131 | 42 | 0 |
355384 | 355384 | 2020-07-21 | Miller | Missouri | 29131 | 44 | 0 |
358587 | 358587 | 2020-07-22 | Miller | Missouri | 29131 | 43 | 0 |
361792 | 361792 | 2020-07-23 | Miller | Missouri | 29131 | 50 | 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);