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 |
---|---|---|---|---|---|---|---|
535996 | 535996 | 2020-09-15 | Perry | Missouri | 29157 | 533 | 4 |
532761 | 532761 | 2020-09-14 | Perry | Missouri | 29157 | 527 | 4 |
529525 | 529525 | 2020-09-13 | Perry | Missouri | 29157 | 516 | 4 |
526289 | 526289 | 2020-09-12 | Perry | Missouri | 29157 | 503 | 4 |
523053 | 523053 | 2020-09-11 | Perry | Missouri | 29157 | 481 | 4 |
519816 | 519816 | 2020-09-10 | Perry | Missouri | 29157 | 466 | 4 |
516581 | 516581 | 2020-09-09 | Perry | Missouri | 29157 | 448 | 4 |
513347 | 513347 | 2020-09-08 | Perry | Missouri | 29157 | 448 | 4 |
510115 | 510115 | 2020-09-07 | Perry | Missouri | 29157 | 446 | 4 |
506882 | 506882 | 2020-09-06 | Perry | Missouri | 29157 | 441 | 4 |
503649 | 503649 | 2020-09-05 | Perry | Missouri | 29157 | 435 | 4 |
500415 | 500415 | 2020-09-04 | Perry | Missouri | 29157 | 423 | 4 |
497181 | 497181 | 2020-09-03 | Perry | Missouri | 29157 | 422 | 4 |
493948 | 493948 | 2020-09-02 | Perry | Missouri | 29157 | 412 | 4 |
490714 | 490714 | 2020-09-01 | Perry | Missouri | 29157 | 395 | 4 |
487481 | 487481 | 2020-08-31 | Perry | Missouri | 29157 | 394 | 4 |
484247 | 484247 | 2020-08-30 | Perry | Missouri | 29157 | 388 | 4 |
481012 | 481012 | 2020-08-29 | Perry | Missouri | 29157 | 369 | 4 |
477780 | 477780 | 2020-08-28 | Perry | Missouri | 29157 | 360 | 4 |
474547 | 474547 | 2020-08-27 | Perry | Missouri | 29157 | 347 | 4 |
471315 | 471315 | 2020-08-26 | Perry | Missouri | 29157 | 324 | 4 |
468085 | 468085 | 2020-08-25 | Perry | Missouri | 29157 | 308 | 4 |
464856 | 464856 | 2020-08-24 | Perry | Missouri | 29157 | 297 | 4 |
461625 | 461625 | 2020-08-23 | Perry | Missouri | 29157 | 292 | 4 |
458398 | 458398 | 2020-08-22 | Perry | Missouri | 29157 | 284 | 4 |
455170 | 455170 | 2020-08-21 | Perry | Missouri | 29157 | 280 | 4 |
451942 | 451942 | 2020-08-20 | Perry | Missouri | 29157 | 274 | 4 |
448714 | 448714 | 2020-08-19 | Perry | Missouri | 29157 | 275 | 4 |
445488 | 445488 | 2020-08-18 | Perry | Missouri | 29157 | 264 | 4 |
442262 | 442262 | 2020-08-17 | Perry | Missouri | 29157 | 263 | 4 |
439035 | 439035 | 2020-08-16 | Perry | Missouri | 29157 | 256 | 4 |
435810 | 435810 | 2020-08-15 | Perry | Missouri | 29157 | 255 | 4 |
432584 | 432584 | 2020-08-14 | Perry | Missouri | 29157 | 254 | 4 |
429357 | 429357 | 2020-08-13 | Perry | Missouri | 29157 | 249 | 4 |
426133 | 426133 | 2020-08-12 | Perry | Missouri | 29157 | 244 | 4 |
422911 | 422911 | 2020-08-11 | Perry | Missouri | 29157 | 235 | 4 |
419689 | 419689 | 2020-08-10 | Perry | Missouri | 29157 | 232 | 4 |
416468 | 416468 | 2020-08-09 | Perry | Missouri | 29157 | 225 | 4 |
413248 | 413248 | 2020-08-08 | Perry | Missouri | 29157 | 223 | 4 |
410028 | 410028 | 2020-08-07 | Perry | Missouri | 29157 | 223 | 4 |
406808 | 406808 | 2020-08-06 | Perry | Missouri | 29157 | 218 | 4 |
403590 | 403590 | 2020-08-05 | Perry | Missouri | 29157 | 214 | 4 |
400373 | 400373 | 2020-08-04 | Perry | Missouri | 29157 | 211 | 4 |
397159 | 397159 | 2020-08-03 | Perry | Missouri | 29157 | 208 | 4 |
393943 | 393943 | 2020-08-02 | Perry | Missouri | 29157 | 206 | 4 |
390726 | 390726 | 2020-08-01 | Perry | Missouri | 29157 | 202 | 4 |
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 |
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);