ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
729 rows where fips = 29065 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535948 | 535948 | 2020-09-15 | Dent | Missouri | 29065 | 94 | 0 |
532713 | 532713 | 2020-09-14 | Dent | Missouri | 29065 | 87 | 0 |
529477 | 529477 | 2020-09-13 | Dent | Missouri | 29065 | 84 | 0 |
526241 | 526241 | 2020-09-12 | Dent | Missouri | 29065 | 80 | 0 |
523005 | 523005 | 2020-09-11 | Dent | Missouri | 29065 | 69 | 0 |
519768 | 519768 | 2020-09-10 | Dent | Missouri | 29065 | 61 | 0 |
516533 | 516533 | 2020-09-09 | Dent | Missouri | 29065 | 58 | 0 |
513299 | 513299 | 2020-09-08 | Dent | Missouri | 29065 | 56 | 0 |
510067 | 510067 | 2020-09-07 | Dent | Missouri | 29065 | 55 | 0 |
506834 | 506834 | 2020-09-06 | Dent | Missouri | 29065 | 55 | 0 |
503601 | 503601 | 2020-09-05 | Dent | Missouri | 29065 | 51 | 0 |
500367 | 500367 | 2020-09-04 | Dent | Missouri | 29065 | 46 | 0 |
497133 | 497133 | 2020-09-03 | Dent | Missouri | 29065 | 44 | 0 |
493900 | 493900 | 2020-09-02 | Dent | Missouri | 29065 | 43 | 0 |
490666 | 490666 | 2020-09-01 | Dent | Missouri | 29065 | 39 | 0 |
487433 | 487433 | 2020-08-31 | Dent | Missouri | 29065 | 39 | 0 |
484199 | 484199 | 2020-08-30 | Dent | Missouri | 29065 | 38 | 0 |
480964 | 480964 | 2020-08-29 | Dent | Missouri | 29065 | 36 | 0 |
477732 | 477732 | 2020-08-28 | Dent | Missouri | 29065 | 33 | 0 |
474499 | 474499 | 2020-08-27 | Dent | Missouri | 29065 | 33 | 0 |
471267 | 471267 | 2020-08-26 | Dent | Missouri | 29065 | 33 | 0 |
468037 | 468037 | 2020-08-25 | Dent | Missouri | 29065 | 31 | 0 |
464808 | 464808 | 2020-08-24 | Dent | Missouri | 29065 | 32 | 0 |
461577 | 461577 | 2020-08-23 | Dent | Missouri | 29065 | 31 | 0 |
458350 | 458350 | 2020-08-22 | Dent | Missouri | 29065 | 30 | 0 |
455122 | 455122 | 2020-08-21 | Dent | Missouri | 29065 | 30 | 0 |
451894 | 451894 | 2020-08-20 | Dent | Missouri | 29065 | 26 | 0 |
448666 | 448666 | 2020-08-19 | Dent | Missouri | 29065 | 25 | 0 |
445440 | 445440 | 2020-08-18 | Dent | Missouri | 29065 | 22 | 0 |
442214 | 442214 | 2020-08-17 | Dent | Missouri | 29065 | 23 | 0 |
438987 | 438987 | 2020-08-16 | Dent | Missouri | 29065 | 23 | 0 |
435762 | 435762 | 2020-08-15 | Dent | Missouri | 29065 | 20 | 0 |
432536 | 432536 | 2020-08-14 | Dent | Missouri | 29065 | 18 | 0 |
429309 | 429309 | 2020-08-13 | Dent | Missouri | 29065 | 16 | 0 |
426085 | 426085 | 2020-08-12 | Dent | Missouri | 29065 | 15 | 0 |
422863 | 422863 | 2020-08-11 | Dent | Missouri | 29065 | 12 | 0 |
419641 | 419641 | 2020-08-10 | Dent | Missouri | 29065 | 12 | 0 |
416420 | 416420 | 2020-08-09 | Dent | Missouri | 29065 | 11 | 0 |
413200 | 413200 | 2020-08-08 | Dent | Missouri | 29065 | 10 | 0 |
409980 | 409980 | 2020-08-07 | Dent | Missouri | 29065 | 10 | 0 |
406760 | 406760 | 2020-08-06 | Dent | Missouri | 29065 | 10 | 0 |
403542 | 403542 | 2020-08-05 | Dent | Missouri | 29065 | 9 | 0 |
400325 | 400325 | 2020-08-04 | Dent | Missouri | 29065 | 9 | 0 |
397111 | 397111 | 2020-08-03 | Dent | Missouri | 29065 | 9 | 0 |
393895 | 393895 | 2020-08-02 | Dent | Missouri | 29065 | 9 | 0 |
390678 | 390678 | 2020-08-01 | Dent | Missouri | 29065 | 9 | 0 |
387461 | 387461 | 2020-07-31 | Dent | Missouri | 29065 | 9 | 0 |
384243 | 384243 | 2020-07-30 | Dent | Missouri | 29065 | 9 | 0 |
381027 | 381027 | 2020-07-29 | Dent | Missouri | 29065 | 9 | 0 |
377810 | 377810 | 2020-07-28 | Dent | Missouri | 29065 | 9 | 0 |
374595 | 374595 | 2020-07-27 | Dent | Missouri | 29065 | 9 | 0 |
371383 | 371383 | 2020-07-26 | Dent | Missouri | 29065 | 9 | 0 |
368172 | 368172 | 2020-07-25 | Dent | Missouri | 29065 | 9 | 0 |
364964 | 364964 | 2020-07-24 | Dent | Missouri | 29065 | 9 | 0 |
361757 | 361757 | 2020-07-23 | Dent | Missouri | 29065 | 9 | 0 |
358552 | 358552 | 2020-07-22 | Dent | Missouri | 29065 | 10 | 0 |
355349 | 355349 | 2020-07-21 | Dent | Missouri | 29065 | 10 | 0 |
352147 | 352147 | 2020-07-20 | Dent | Missouri | 29065 | 10 | 0 |
348947 | 348947 | 2020-07-19 | Dent | Missouri | 29065 | 10 | 0 |
345746 | 345746 | 2020-07-18 | Dent | Missouri | 29065 | 10 | 0 |
342546 | 342546 | 2020-07-17 | Dent | Missouri | 29065 | 9 | 0 |
339350 | 339350 | 2020-07-16 | Dent | Missouri | 29065 | 9 | 0 |
336154 | 336154 | 2020-07-15 | Dent | Missouri | 29065 | 9 | 0 |
332961 | 332961 | 2020-07-14 | Dent | Missouri | 29065 | 9 | 0 |
329774 | 329774 | 2020-07-13 | Dent | Missouri | 29065 | 5 | 0 |
326588 | 326588 | 2020-07-12 | Dent | Missouri | 29065 | 5 | 0 |
323405 | 323405 | 2020-07-11 | Dent | Missouri | 29065 | 5 | 0 |
320226 | 320226 | 2020-07-10 | Dent | Missouri | 29065 | 5 | 0 |
317051 | 317051 | 2020-07-09 | Dent | Missouri | 29065 | 5 | 0 |
313877 | 313877 | 2020-07-08 | Dent | Missouri | 29065 | 5 | 0 |
310707 | 310707 | 2020-07-07 | Dent | Missouri | 29065 | 5 | 0 |
307539 | 307539 | 2020-07-06 | Dent | Missouri | 29065 | 5 | 0 |
304372 | 304372 | 2020-07-05 | Dent | Missouri | 29065 | 5 | 0 |
301208 | 301208 | 2020-07-04 | Dent | Missouri | 29065 | 5 | 0 |
298045 | 298045 | 2020-07-03 | Dent | Missouri | 29065 | 5 | 0 |
294887 | 294887 | 2020-07-02 | Dent | Missouri | 29065 | 5 | 0 |
291733 | 291733 | 2020-07-01 | Dent | Missouri | 29065 | 5 | 0 |
288582 | 288582 | 2020-06-30 | Dent | Missouri | 29065 | 5 | 0 |
285432 | 285432 | 2020-06-29 | Dent | Missouri | 29065 | 5 | 0 |
282287 | 282287 | 2020-06-28 | Dent | Missouri | 29065 | 5 | 0 |
279139 | 279139 | 2020-06-27 | Dent | Missouri | 29065 | 3 | 0 |
275991 | 275991 | 2020-06-26 | Dent | Missouri | 29065 | 3 | 0 |
272848 | 272848 | 2020-06-25 | Dent | Missouri | 29065 | 3 | 0 |
269710 | 269710 | 2020-06-24 | Dent | Missouri | 29065 | 2 | 0 |
266577 | 266577 | 2020-06-23 | Dent | Missouri | 29065 | 2 | 0 |
263451 | 263451 | 2020-06-22 | Dent | Missouri | 29065 | 1 | 0 |
260323 | 260323 | 2020-06-21 | Dent | Missouri | 29065 | 1 | 0 |
257197 | 257197 | 2020-06-20 | Dent | Missouri | 29065 | 1 | 0 |
254077 | 254077 | 2020-06-19 | Dent | Missouri | 29065 | 1 | 0 |
250962 | 250962 | 2020-06-18 | Dent | Missouri | 29065 | 1 | 0 |
247849 | 247849 | 2020-06-17 | Dent | Missouri | 29065 | 1 | 0 |
244736 | 244736 | 2020-06-16 | Dent | Missouri | 29065 | 1 | 0 |
241625 | 241625 | 2020-06-15 | Dent | Missouri | 29065 | 1 | 0 |
238515 | 238515 | 2020-06-14 | Dent | Missouri | 29065 | 1 | 0 |
235408 | 235408 | 2020-06-13 | Dent | Missouri | 29065 | 1 | 0 |
232302 | 232302 | 2020-06-12 | Dent | Missouri | 29065 | 1 | 0 |
229198 | 229198 | 2020-06-11 | Dent | Missouri | 29065 | 1 | 0 |
226095 | 226095 | 2020-06-10 | Dent | Missouri | 29065 | 1 | 0 |
222997 | 222997 | 2020-06-09 | Dent | Missouri | 29065 | 1 | 0 |
219902 | 219902 | 2020-06-08 | Dent | Missouri | 29065 | 1 | 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);