ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 29157 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387509 | 387509 | 2020-07-31 | Perry | Missouri | 29157 | 201 | 4 |
384291 | 384291 | 2020-07-30 | Perry | Missouri | 29157 | 194 | 4 |
381075 | 381075 | 2020-07-29 | Perry | Missouri | 29157 | 191 | 3 |
377858 | 377858 | 2020-07-28 | Perry | Missouri | 29157 | 192 | 3 |
374643 | 374643 | 2020-07-27 | Perry | Missouri | 29157 | 188 | 3 |
371431 | 371431 | 2020-07-26 | Perry | Missouri | 29157 | 187 | 3 |
368220 | 368220 | 2020-07-25 | Perry | Missouri | 29157 | 187 | 3 |
365012 | 365012 | 2020-07-24 | Perry | Missouri | 29157 | 186 | 3 |
361805 | 361805 | 2020-07-23 | Perry | Missouri | 29157 | 185 | 3 |
358600 | 358600 | 2020-07-22 | Perry | Missouri | 29157 | 184 | 3 |
355397 | 355397 | 2020-07-21 | Perry | Missouri | 29157 | 183 | 3 |
352195 | 352195 | 2020-07-20 | Perry | Missouri | 29157 | 182 | 3 |
348995 | 348995 | 2020-07-19 | Perry | Missouri | 29157 | 179 | 3 |
345794 | 345794 | 2020-07-18 | Perry | Missouri | 29157 | 178 | 3 |
342594 | 342594 | 2020-07-17 | Perry | Missouri | 29157 | 178 | 3 |
339398 | 339398 | 2020-07-16 | Perry | Missouri | 29157 | 176 | 3 |
336202 | 336202 | 2020-07-15 | Perry | Missouri | 29157 | 176 | 3 |
333009 | 333009 | 2020-07-14 | Perry | Missouri | 29157 | 172 | 3 |
329822 | 329822 | 2020-07-13 | Perry | Missouri | 29157 | 172 | 3 |
326636 | 326636 | 2020-07-12 | Perry | Missouri | 29157 | 170 | 3 |
323453 | 323453 | 2020-07-11 | Perry | Missouri | 29157 | 170 | 3 |
320274 | 320274 | 2020-07-10 | Perry | Missouri | 29157 | 168 | 3 |
317099 | 317099 | 2020-07-09 | Perry | Missouri | 29157 | 168 | 1 |
313925 | 313925 | 2020-07-08 | Perry | Missouri | 29157 | 164 | 1 |
310754 | 310754 | 2020-07-07 | Perry | Missouri | 29157 | 163 | 1 |
307586 | 307586 | 2020-07-06 | Perry | Missouri | 29157 | 156 | 0 |
304419 | 304419 | 2020-07-05 | Perry | Missouri | 29157 | 151 | 0 |
301255 | 301255 | 2020-07-04 | Perry | Missouri | 29157 | 149 | 0 |
298092 | 298092 | 2020-07-03 | Perry | Missouri | 29157 | 149 | 0 |
294934 | 294934 | 2020-07-02 | Perry | Missouri | 29157 | 147 | 0 |
291780 | 291780 | 2020-07-01 | Perry | Missouri | 29157 | 146 | 0 |
288629 | 288629 | 2020-06-30 | Perry | Missouri | 29157 | 146 | 0 |
285479 | 285479 | 2020-06-29 | Perry | Missouri | 29157 | 134 | 0 |
282334 | 282334 | 2020-06-28 | Perry | Missouri | 29157 | 126 | 0 |
279186 | 279186 | 2020-06-27 | Perry | Missouri | 29157 | 123 | 0 |
276038 | 276038 | 2020-06-26 | Perry | Missouri | 29157 | 119 | 0 |
272895 | 272895 | 2020-06-25 | Perry | Missouri | 29157 | 112 | 0 |
269756 | 269756 | 2020-06-24 | Perry | Missouri | 29157 | 111 | 0 |
266623 | 266623 | 2020-06-23 | Perry | Missouri | 29157 | 111 | 0 |
263497 | 263497 | 2020-06-22 | Perry | Missouri | 29157 | 104 | 0 |
260369 | 260369 | 2020-06-21 | Perry | Missouri | 29157 | 102 | 0 |
257243 | 257243 | 2020-06-20 | Perry | Missouri | 29157 | 91 | 0 |
254122 | 254122 | 2020-06-19 | Perry | Missouri | 29157 | 88 | 0 |
251007 | 251007 | 2020-06-18 | Perry | Missouri | 29157 | 87 | 0 |
247894 | 247894 | 2020-06-17 | Perry | Missouri | 29157 | 87 | 0 |
244781 | 244781 | 2020-06-16 | Perry | Missouri | 29157 | 86 | 0 |
241670 | 241670 | 2020-06-15 | Perry | Missouri | 29157 | 85 | 0 |
238560 | 238560 | 2020-06-14 | Perry | Missouri | 29157 | 84 | 0 |
235453 | 235453 | 2020-06-13 | Perry | Missouri | 29157 | 84 | 0 |
232347 | 232347 | 2020-06-12 | Perry | Missouri | 29157 | 80 | 0 |
229243 | 229243 | 2020-06-11 | Perry | Missouri | 29157 | 79 | 0 |
226140 | 226140 | 2020-06-10 | Perry | Missouri | 29157 | 75 | 0 |
223041 | 223041 | 2020-06-09 | Perry | Missouri | 29157 | 75 | 0 |
219946 | 219946 | 2020-06-08 | Perry | Missouri | 29157 | 71 | 0 |
216854 | 216854 | 2020-06-07 | Perry | Missouri | 29157 | 70 | 0 |
213766 | 213766 | 2020-06-06 | Perry | Missouri | 29157 | 69 | 0 |
210682 | 210682 | 2020-06-05 | Perry | Missouri | 29157 | 69 | 0 |
207601 | 207601 | 2020-06-04 | Perry | Missouri | 29157 | 65 | 0 |
204520 | 204520 | 2020-06-03 | Perry | Missouri | 29157 | 64 | 0 |
201443 | 201443 | 2020-06-02 | Perry | Missouri | 29157 | 63 | 0 |
198370 | 198370 | 2020-06-01 | Perry | Missouri | 29157 | 61 | 0 |
195299 | 195299 | 2020-05-31 | Perry | Missouri | 29157 | 57 | 0 |
192229 | 192229 | 2020-05-30 | Perry | Missouri | 29157 | 57 | 0 |
189165 | 189165 | 2020-05-29 | Perry | Missouri | 29157 | 55 | 0 |
186107 | 186107 | 2020-05-28 | Perry | Missouri | 29157 | 50 | 0 |
183051 | 183051 | 2020-05-27 | Perry | Missouri | 29157 | 50 | 0 |
180004 | 180004 | 2020-05-26 | Perry | Missouri | 29157 | 49 | 0 |
176960 | 176960 | 2020-05-25 | Perry | Missouri | 29157 | 49 | 0 |
173917 | 173917 | 2020-05-24 | Perry | Missouri | 29157 | 49 | 0 |
170875 | 170875 | 2020-05-23 | Perry | Missouri | 29157 | 49 | 0 |
167836 | 167836 | 2020-05-22 | Perry | Missouri | 29157 | 48 | 0 |
164800 | 164800 | 2020-05-21 | Perry | Missouri | 29157 | 48 | 0 |
161771 | 161771 | 2020-05-20 | Perry | Missouri | 29157 | 47 | 0 |
158745 | 158745 | 2020-05-19 | Perry | Missouri | 29157 | 47 | 0 |
155727 | 155727 | 2020-05-18 | Perry | Missouri | 29157 | 47 | 0 |
152713 | 152713 | 2020-05-17 | Perry | Missouri | 29157 | 46 | 0 |
149702 | 149702 | 2020-05-16 | Perry | Missouri | 29157 | 46 | 0 |
146697 | 146697 | 2020-05-15 | Perry | Missouri | 29157 | 46 | 0 |
143696 | 143696 | 2020-05-14 | Perry | Missouri | 29157 | 46 | 0 |
140701 | 140701 | 2020-05-13 | Perry | Missouri | 29157 | 46 | 0 |
137707 | 137707 | 2020-05-12 | Perry | Missouri | 29157 | 45 | 0 |
134717 | 134717 | 2020-05-11 | Perry | Missouri | 29157 | 45 | 0 |
131726 | 131726 | 2020-05-10 | Perry | Missouri | 29157 | 45 | 0 |
128736 | 128736 | 2020-05-09 | Perry | Missouri | 29157 | 45 | 0 |
125748 | 125748 | 2020-05-08 | Perry | Missouri | 29157 | 45 | 0 |
122766 | 122766 | 2020-05-07 | Perry | Missouri | 29157 | 44 | 0 |
119792 | 119792 | 2020-05-06 | Perry | Missouri | 29157 | 44 | 0 |
116832 | 116832 | 2020-05-05 | Perry | Missouri | 29157 | 43 | 0 |
113950 | 113950 | 2020-05-04 | Perry | Missouri | 29157 | 43 | 0 |
111071 | 111071 | 2020-05-03 | Perry | Missouri | 29157 | 43 | 0 |
108199 | 108199 | 2020-05-02 | Perry | Missouri | 29157 | 43 | 0 |
105334 | 105334 | 2020-05-01 | Perry | Missouri | 29157 | 43 | 0 |
102473 | 102473 | 2020-04-30 | Perry | Missouri | 29157 | 43 | 0 |
99621 | 99621 | 2020-04-29 | Perry | Missouri | 29157 | 43 | 0 |
96775 | 96775 | 2020-04-28 | Perry | Missouri | 29157 | 41 | 0 |
93939 | 93939 | 2020-04-27 | Perry | Missouri | 29157 | 41 | 0 |
91118 | 91118 | 2020-04-26 | Perry | Missouri | 29157 | 41 | 0 |
88302 | 88302 | 2020-04-25 | Perry | Missouri | 29157 | 39 | 0 |
85492 | 85492 | 2020-04-24 | Perry | Missouri | 29157 | 39 | 0 |
82688 | 82688 | 2020-04-23 | Perry | Missouri | 29157 | 38 | 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);