ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 29047 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535939 | 535939 | 2020-09-15 | Clay | Missouri | 29047 | 1642 | 39 |
532704 | 532704 | 2020-09-14 | Clay | Missouri | 29047 | 1624 | 39 |
529468 | 529468 | 2020-09-13 | Clay | Missouri | 29047 | 1608 | 39 |
526232 | 526232 | 2020-09-12 | Clay | Missouri | 29047 | 1589 | 39 |
522996 | 522996 | 2020-09-11 | Clay | Missouri | 29047 | 1561 | 39 |
519759 | 519759 | 2020-09-10 | Clay | Missouri | 29047 | 1541 | 39 |
516524 | 516524 | 2020-09-09 | Clay | Missouri | 29047 | 1530 | 39 |
513290 | 513290 | 2020-09-08 | Clay | Missouri | 29047 | 1512 | 39 |
510058 | 510058 | 2020-09-07 | Clay | Missouri | 29047 | 1506 | 39 |
506825 | 506825 | 2020-09-06 | Clay | Missouri | 29047 | 1493 | 39 |
503592 | 503592 | 2020-09-05 | Clay | Missouri | 29047 | 1481 | 39 |
500358 | 500358 | 2020-09-04 | Clay | Missouri | 29047 | 1455 | 38 |
497124 | 497124 | 2020-09-03 | Clay | Missouri | 29047 | 1443 | 37 |
493891 | 493891 | 2020-09-02 | Clay | Missouri | 29047 | 1412 | 37 |
490657 | 490657 | 2020-09-01 | Clay | Missouri | 29047 | 1403 | 37 |
487424 | 487424 | 2020-08-31 | Clay | Missouri | 29047 | 1381 | 37 |
484190 | 484190 | 2020-08-30 | Clay | Missouri | 29047 | 1363 | 36 |
480955 | 480955 | 2020-08-29 | Clay | Missouri | 29047 | 1355 | 36 |
477723 | 477723 | 2020-08-28 | Clay | Missouri | 29047 | 1346 | 36 |
474490 | 474490 | 2020-08-27 | Clay | Missouri | 29047 | 1323 | 36 |
471258 | 471258 | 2020-08-26 | Clay | Missouri | 29047 | 1309 | 34 |
468028 | 468028 | 2020-08-25 | Clay | Missouri | 29047 | 1285 | 34 |
464799 | 464799 | 2020-08-24 | Clay | Missouri | 29047 | 1269 | 34 |
461568 | 461568 | 2020-08-23 | Clay | Missouri | 29047 | 1261 | 34 |
458341 | 458341 | 2020-08-22 | Clay | Missouri | 29047 | 1245 | 34 |
455113 | 455113 | 2020-08-21 | Clay | Missouri | 29047 | 1210 | 34 |
451885 | 451885 | 2020-08-20 | Clay | Missouri | 29047 | 1194 | 34 |
448657 | 448657 | 2020-08-19 | Clay | Missouri | 29047 | 1180 | 34 |
445431 | 445431 | 2020-08-18 | Clay | Missouri | 29047 | 1167 | 34 |
442205 | 442205 | 2020-08-17 | Clay | Missouri | 29047 | 1158 | 33 |
438978 | 438978 | 2020-08-16 | Clay | Missouri | 29047 | 1143 | 32 |
435753 | 435753 | 2020-08-15 | Clay | Missouri | 29047 | 1133 | 32 |
432527 | 432527 | 2020-08-14 | Clay | Missouri | 29047 | 1126 | 32 |
429300 | 429300 | 2020-08-13 | Clay | Missouri | 29047 | 1098 | 32 |
426076 | 426076 | 2020-08-12 | Clay | Missouri | 29047 | 1087 | 27 |
422854 | 422854 | 2020-08-11 | Clay | Missouri | 29047 | 1064 | 27 |
419632 | 419632 | 2020-08-10 | Clay | Missouri | 29047 | 1053 | 27 |
416411 | 416411 | 2020-08-09 | Clay | Missouri | 29047 | 1037 | 27 |
413191 | 413191 | 2020-08-08 | Clay | Missouri | 29047 | 1011 | 27 |
409971 | 409971 | 2020-08-07 | Clay | Missouri | 29047 | 1011 | 27 |
406751 | 406751 | 2020-08-06 | Clay | Missouri | 29047 | 984 | 24 |
403533 | 403533 | 2020-08-05 | Clay | Missouri | 29047 | 974 | 22 |
400316 | 400316 | 2020-08-04 | Clay | Missouri | 29047 | 944 | 22 |
397102 | 397102 | 2020-08-03 | Clay | Missouri | 29047 | 914 | 22 |
393886 | 393886 | 2020-08-02 | Clay | Missouri | 29047 | 900 | 22 |
390669 | 390669 | 2020-08-01 | Clay | Missouri | 29047 | 896 | 22 |
387452 | 387452 | 2020-07-31 | Clay | Missouri | 29047 | 882 | 22 |
384234 | 384234 | 2020-07-30 | Clay | Missouri | 29047 | 857 | 22 |
381018 | 381018 | 2020-07-29 | Clay | Missouri | 29047 | 826 | 22 |
377801 | 377801 | 2020-07-28 | Clay | Missouri | 29047 | 784 | 22 |
374586 | 374586 | 2020-07-27 | Clay | Missouri | 29047 | 744 | 22 |
371374 | 371374 | 2020-07-26 | Clay | Missouri | 29047 | 717 | 22 |
368163 | 368163 | 2020-07-25 | Clay | Missouri | 29047 | 705 | 22 |
364955 | 364955 | 2020-07-24 | Clay | Missouri | 29047 | 688 | 22 |
361748 | 361748 | 2020-07-23 | Clay | Missouri | 29047 | 685 | 22 |
358543 | 358543 | 2020-07-22 | Clay | Missouri | 29047 | 655 | 22 |
355340 | 355340 | 2020-07-21 | Clay | Missouri | 29047 | 646 | 21 |
352138 | 352138 | 2020-07-20 | Clay | Missouri | 29047 | 630 | 21 |
348938 | 348938 | 2020-07-19 | Clay | Missouri | 29047 | 625 | 20 |
345737 | 345737 | 2020-07-18 | Clay | Missouri | 29047 | 617 | 20 |
342537 | 342537 | 2020-07-17 | Clay | Missouri | 29047 | 607 | 20 |
339341 | 339341 | 2020-07-16 | Clay | Missouri | 29047 | 597 | 20 |
336145 | 336145 | 2020-07-15 | Clay | Missouri | 29047 | 589 | 20 |
332952 | 332952 | 2020-07-14 | Clay | Missouri | 29047 | 579 | 20 |
329765 | 329765 | 2020-07-13 | Clay | Missouri | 29047 | 565 | 20 |
326579 | 326579 | 2020-07-12 | Clay | Missouri | 29047 | 558 | 20 |
323396 | 323396 | 2020-07-11 | Clay | Missouri | 29047 | 557 | 20 |
320217 | 320217 | 2020-07-10 | Clay | Missouri | 29047 | 550 | 20 |
317042 | 317042 | 2020-07-09 | Clay | Missouri | 29047 | 539 | 20 |
313868 | 313868 | 2020-07-08 | Clay | Missouri | 29047 | 526 | 20 |
310698 | 310698 | 2020-07-07 | Clay | Missouri | 29047 | 510 | 17 |
307530 | 307530 | 2020-07-06 | Clay | Missouri | 29047 | 504 | 17 |
304363 | 304363 | 2020-07-05 | Clay | Missouri | 29047 | 500 | 16 |
301199 | 301199 | 2020-07-04 | Clay | Missouri | 29047 | 493 | 16 |
298036 | 298036 | 2020-07-03 | Clay | Missouri | 29047 | 478 | 16 |
294878 | 294878 | 2020-07-02 | Clay | Missouri | 29047 | 472 | 16 |
291724 | 291724 | 2020-07-01 | Clay | Missouri | 29047 | 460 | 16 |
288573 | 288573 | 2020-06-30 | Clay | Missouri | 29047 | 454 | 16 |
285423 | 285423 | 2020-06-29 | Clay | Missouri | 29047 | 443 | 14 |
282278 | 282278 | 2020-06-28 | Clay | Missouri | 29047 | 431 | 12 |
279130 | 279130 | 2020-06-27 | Clay | Missouri | 29047 | 414 | 12 |
275982 | 275982 | 2020-06-26 | Clay | Missouri | 29047 | 406 | 12 |
272839 | 272839 | 2020-06-25 | Clay | Missouri | 29047 | 386 | 11 |
269701 | 269701 | 2020-06-24 | Clay | Missouri | 29047 | 375 | 11 |
266568 | 266568 | 2020-06-23 | Clay | Missouri | 29047 | 367 | 9 |
263442 | 263442 | 2020-06-22 | Clay | Missouri | 29047 | 348 | 9 |
260314 | 260314 | 2020-06-21 | Clay | Missouri | 29047 | 342 | 9 |
257188 | 257188 | 2020-06-20 | Clay | Missouri | 29047 | 342 | 9 |
254068 | 254068 | 2020-06-19 | Clay | Missouri | 29047 | 334 | 9 |
250953 | 250953 | 2020-06-18 | Clay | Missouri | 29047 | 319 | 8 |
247840 | 247840 | 2020-06-17 | Clay | Missouri | 29047 | 305 | 8 |
244727 | 244727 | 2020-06-16 | Clay | Missouri | 29047 | 299 | 7 |
241616 | 241616 | 2020-06-15 | Clay | Missouri | 29047 | 298 | 6 |
238507 | 238507 | 2020-06-14 | Clay | Missouri | 29047 | 295 | 3 |
235400 | 235400 | 2020-06-13 | Clay | Missouri | 29047 | 295 | 3 |
232294 | 232294 | 2020-06-12 | Clay | Missouri | 29047 | 295 | 3 |
229190 | 229190 | 2020-06-11 | Clay | Missouri | 29047 | 291 | 3 |
226087 | 226087 | 2020-06-10 | Clay | Missouri | 29047 | 263 | 3 |
222989 | 222989 | 2020-06-09 | Clay | Missouri | 29047 | 255 | 3 |
219894 | 219894 | 2020-06-08 | Clay | Missouri | 29047 | 243 | 3 |
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);