ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
752 rows where county = "Carroll", fips = 29033 and state = "Missouri" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
79840 | 79840 | 2020-04-22 | Carroll | Missouri | 29033 | 1 | 0 |
82636 | 82636 | 2020-04-23 | Carroll | Missouri | 29033 | 1 | 0 |
85440 | 85440 | 2020-04-24 | Carroll | Missouri | 29033 | 3 | 0 |
88250 | 88250 | 2020-04-25 | Carroll | Missouri | 29033 | 3 | 0 |
91066 | 91066 | 2020-04-26 | Carroll | Missouri | 29033 | 3 | 0 |
93887 | 93887 | 2020-04-27 | Carroll | Missouri | 29033 | 2 | 0 |
96723 | 96723 | 2020-04-28 | Carroll | Missouri | 29033 | 2 | 0 |
99569 | 99569 | 2020-04-29 | Carroll | Missouri | 29033 | 2 | 0 |
102421 | 102421 | 2020-04-30 | Carroll | Missouri | 29033 | 2 | 0 |
105282 | 105282 | 2020-05-01 | Carroll | Missouri | 29033 | 2 | 0 |
108147 | 108147 | 2020-05-02 | Carroll | Missouri | 29033 | 2 | 0 |
111018 | 111018 | 2020-05-03 | Carroll | Missouri | 29033 | 2 | 0 |
113897 | 113897 | 2020-05-04 | Carroll | Missouri | 29033 | 2 | 0 |
116779 | 116779 | 2020-05-05 | Carroll | Missouri | 29033 | 2 | 0 |
119739 | 119739 | 2020-05-06 | Carroll | Missouri | 29033 | 2 | 0 |
122713 | 122713 | 2020-05-07 | Carroll | Missouri | 29033 | 3 | 0 |
125695 | 125695 | 2020-05-08 | Carroll | Missouri | 29033 | 3 | 0 |
128682 | 128682 | 2020-05-09 | Carroll | Missouri | 29033 | 3 | 0 |
131672 | 131672 | 2020-05-10 | Carroll | Missouri | 29033 | 3 | 0 |
134663 | 134663 | 2020-05-11 | Carroll | Missouri | 29033 | 3 | 0 |
137653 | 137653 | 2020-05-12 | Carroll | Missouri | 29033 | 4 | 0 |
140647 | 140647 | 2020-05-13 | Carroll | Missouri | 29033 | 4 | 0 |
143642 | 143642 | 2020-05-14 | Carroll | Missouri | 29033 | 4 | 0 |
146642 | 146642 | 2020-05-15 | Carroll | Missouri | 29033 | 7 | 0 |
149647 | 149647 | 2020-05-16 | Carroll | Missouri | 29033 | 7 | 0 |
152658 | 152658 | 2020-05-17 | Carroll | Missouri | 29033 | 7 | 0 |
155672 | 155672 | 2020-05-18 | Carroll | Missouri | 29033 | 7 | 0 |
158690 | 158690 | 2020-05-19 | Carroll | Missouri | 29033 | 7 | 0 |
161716 | 161716 | 2020-05-20 | Carroll | Missouri | 29033 | 7 | 0 |
164745 | 164745 | 2020-05-21 | Carroll | Missouri | 29033 | 7 | 0 |
167781 | 167781 | 2020-05-22 | Carroll | Missouri | 29033 | 7 | 0 |
170819 | 170819 | 2020-05-23 | Carroll | Missouri | 29033 | 7 | 0 |
173861 | 173861 | 2020-05-24 | Carroll | Missouri | 29033 | 7 | 0 |
176904 | 176904 | 2020-05-25 | Carroll | Missouri | 29033 | 7 | 0 |
179948 | 179948 | 2020-05-26 | Carroll | Missouri | 29033 | 7 | 0 |
182994 | 182994 | 2020-05-27 | Carroll | Missouri | 29033 | 7 | 0 |
186050 | 186050 | 2020-05-28 | Carroll | Missouri | 29033 | 8 | 0 |
189108 | 189108 | 2020-05-29 | Carroll | Missouri | 29033 | 8 | 0 |
192172 | 192172 | 2020-05-30 | Carroll | Missouri | 29033 | 8 | 0 |
195240 | 195240 | 2020-05-31 | Carroll | Missouri | 29033 | 8 | 0 |
198311 | 198311 | 2020-06-01 | Carroll | Missouri | 29033 | 8 | 0 |
201384 | 201384 | 2020-06-02 | Carroll | Missouri | 29033 | 8 | 0 |
204461 | 204461 | 2020-06-03 | Carroll | Missouri | 29033 | 8 | 0 |
207542 | 207542 | 2020-06-04 | Carroll | Missouri | 29033 | 9 | 0 |
210623 | 210623 | 2020-06-05 | Carroll | Missouri | 29033 | 9 | 0 |
213707 | 213707 | 2020-06-06 | Carroll | Missouri | 29033 | 9 | 0 |
216795 | 216795 | 2020-06-07 | Carroll | Missouri | 29033 | 9 | 0 |
219887 | 219887 | 2020-06-08 | Carroll | Missouri | 29033 | 9 | 0 |
222982 | 222982 | 2020-06-09 | Carroll | Missouri | 29033 | 9 | 0 |
226080 | 226080 | 2020-06-10 | Carroll | Missouri | 29033 | 9 | 0 |
229183 | 229183 | 2020-06-11 | Carroll | Missouri | 29033 | 9 | 0 |
232287 | 232287 | 2020-06-12 | Carroll | Missouri | 29033 | 9 | 0 |
235393 | 235393 | 2020-06-13 | Carroll | Missouri | 29033 | 10 | 0 |
238500 | 238500 | 2020-06-14 | Carroll | Missouri | 29033 | 10 | 0 |
241609 | 241609 | 2020-06-15 | Carroll | Missouri | 29033 | 10 | 0 |
244720 | 244720 | 2020-06-16 | Carroll | Missouri | 29033 | 11 | 0 |
247833 | 247833 | 2020-06-17 | Carroll | Missouri | 29033 | 11 | 0 |
250946 | 250946 | 2020-06-18 | Carroll | Missouri | 29033 | 11 | 0 |
254061 | 254061 | 2020-06-19 | Carroll | Missouri | 29033 | 11 | 0 |
257181 | 257181 | 2020-06-20 | Carroll | Missouri | 29033 | 11 | 0 |
260307 | 260307 | 2020-06-21 | Carroll | Missouri | 29033 | 11 | 0 |
263435 | 263435 | 2020-06-22 | Carroll | Missouri | 29033 | 11 | 0 |
266561 | 266561 | 2020-06-23 | Carroll | Missouri | 29033 | 11 | 0 |
269694 | 269694 | 2020-06-24 | Carroll | Missouri | 29033 | 11 | 0 |
272832 | 272832 | 2020-06-25 | Carroll | Missouri | 29033 | 11 | 0 |
275975 | 275975 | 2020-06-26 | Carroll | Missouri | 29033 | 11 | 0 |
279123 | 279123 | 2020-06-27 | Carroll | Missouri | 29033 | 11 | 0 |
282271 | 282271 | 2020-06-28 | Carroll | Missouri | 29033 | 11 | 0 |
285416 | 285416 | 2020-06-29 | Carroll | Missouri | 29033 | 11 | 0 |
288566 | 288566 | 2020-06-30 | Carroll | Missouri | 29033 | 11 | 0 |
291717 | 291717 | 2020-07-01 | Carroll | Missouri | 29033 | 12 | 0 |
294871 | 294871 | 2020-07-02 | Carroll | Missouri | 29033 | 12 | 0 |
298029 | 298029 | 2020-07-03 | Carroll | Missouri | 29033 | 14 | 0 |
301192 | 301192 | 2020-07-04 | Carroll | Missouri | 29033 | 16 | 0 |
304356 | 304356 | 2020-07-05 | Carroll | Missouri | 29033 | 16 | 0 |
307523 | 307523 | 2020-07-06 | Carroll | Missouri | 29033 | 19 | 0 |
310691 | 310691 | 2020-07-07 | Carroll | Missouri | 29033 | 20 | 0 |
313861 | 313861 | 2020-07-08 | Carroll | Missouri | 29033 | 20 | 0 |
317035 | 317035 | 2020-07-09 | Carroll | Missouri | 29033 | 25 | 0 |
320210 | 320210 | 2020-07-10 | Carroll | Missouri | 29033 | 25 | 0 |
323389 | 323389 | 2020-07-11 | Carroll | Missouri | 29033 | 26 | 0 |
326572 | 326572 | 2020-07-12 | Carroll | Missouri | 29033 | 31 | 0 |
329758 | 329758 | 2020-07-13 | Carroll | Missouri | 29033 | 38 | 0 |
332945 | 332945 | 2020-07-14 | Carroll | Missouri | 29033 | 39 | 0 |
336138 | 336138 | 2020-07-15 | Carroll | Missouri | 29033 | 41 | 0 |
339334 | 339334 | 2020-07-16 | Carroll | Missouri | 29033 | 42 | 0 |
342530 | 342530 | 2020-07-17 | Carroll | Missouri | 29033 | 43 | 0 |
345730 | 345730 | 2020-07-18 | Carroll | Missouri | 29033 | 47 | 0 |
348931 | 348931 | 2020-07-19 | Carroll | Missouri | 29033 | 48 | 0 |
352131 | 352131 | 2020-07-20 | Carroll | Missouri | 29033 | 48 | 0 |
355333 | 355333 | 2020-07-21 | Carroll | Missouri | 29033 | 49 | 0 |
358536 | 358536 | 2020-07-22 | Carroll | Missouri | 29033 | 53 | 0 |
361741 | 361741 | 2020-07-23 | Carroll | Missouri | 29033 | 54 | 0 |
364948 | 364948 | 2020-07-24 | Carroll | Missouri | 29033 | 61 | 0 |
368156 | 368156 | 2020-07-25 | Carroll | Missouri | 29033 | 69 | 0 |
371367 | 371367 | 2020-07-26 | Carroll | Missouri | 29033 | 71 | 0 |
374579 | 374579 | 2020-07-27 | Carroll | Missouri | 29033 | 74 | 0 |
377794 | 377794 | 2020-07-28 | Carroll | Missouri | 29033 | 79 | 0 |
381011 | 381011 | 2020-07-29 | Carroll | Missouri | 29033 | 84 | 0 |
384227 | 384227 | 2020-07-30 | Carroll | Missouri | 29033 | 89 | 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);