ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Jackson" and state = "Missouri" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
272862 | 272862 | 2020-06-25 | Jackson | Missouri | 29095 | 1074 | 36 |
276005 | 276005 | 2020-06-26 | Jackson | Missouri | 29095 | 1103 | 36 |
279153 | 279153 | 2020-06-27 | Jackson | Missouri | 29095 | 1132 | 35 |
282301 | 282301 | 2020-06-28 | Jackson | Missouri | 29095 | 1149 | 36 |
285446 | 285446 | 2020-06-29 | Jackson | Missouri | 29095 | 1172 | 36 |
288596 | 288596 | 2020-06-30 | Jackson | Missouri | 29095 | 1210 | 36 |
291747 | 291747 | 2020-07-01 | Jackson | Missouri | 29095 | 1233 | 37 |
294901 | 294901 | 2020-07-02 | Jackson | Missouri | 29095 | 1257 | 39 |
298059 | 298059 | 2020-07-03 | Jackson | Missouri | 29095 | 1306 | 39 |
301222 | 301222 | 2020-07-04 | Jackson | Missouri | 29095 | 1361 | 40 |
304386 | 304386 | 2020-07-05 | Jackson | Missouri | 29095 | 1367 | 40 |
307553 | 307553 | 2020-07-06 | Jackson | Missouri | 29095 | 1399 | 40 |
310721 | 310721 | 2020-07-07 | Jackson | Missouri | 29095 | 1436 | 42 |
313892 | 313892 | 2020-07-08 | Jackson | Missouri | 29095 | 1479 | 42 |
317066 | 317066 | 2020-07-09 | Jackson | Missouri | 29095 | 1527 | 42 |
320241 | 320241 | 2020-07-10 | Jackson | Missouri | 29095 | 1612 | 42 |
323420 | 323420 | 2020-07-11 | Jackson | Missouri | 29095 | 1657 | 43 |
326603 | 326603 | 2020-07-12 | Jackson | Missouri | 29095 | 1743 | 44 |
329789 | 329789 | 2020-07-13 | Jackson | Missouri | 29095 | 1781 | 44 |
332976 | 332976 | 2020-07-14 | Jackson | Missouri | 29095 | 1806 | 46 |
336169 | 336169 | 2020-07-15 | Jackson | Missouri | 29095 | 1936 | 46 |
339365 | 339365 | 2020-07-16 | Jackson | Missouri | 29095 | 1962 | 46 |
342561 | 342561 | 2020-07-17 | Jackson | Missouri | 29095 | 2077 | 46 |
345761 | 345761 | 2020-07-18 | Jackson | Missouri | 29095 | 2077 | 46 |
348962 | 348962 | 2020-07-19 | Jackson | Missouri | 29095 | 2209 | 47 |
352162 | 352162 | 2020-07-20 | Jackson | Missouri | 29095 | 2220 | 47 |
355364 | 355364 | 2020-07-21 | Jackson | Missouri | 29095 | 2330 | 48 |
358567 | 358567 | 2020-07-22 | Jackson | Missouri | 29095 | 2407 | 48 |
361772 | 361772 | 2020-07-23 | Jackson | Missouri | 29095 | 2466 | 50 |
364979 | 364979 | 2020-07-24 | Jackson | Missouri | 29095 | 2554 | 53 |
368187 | 368187 | 2020-07-25 | Jackson | Missouri | 29095 | 2554 | 53 |
371398 | 371398 | 2020-07-26 | Jackson | Missouri | 29095 | 2642 | 55 |
374610 | 374610 | 2020-07-27 | Jackson | Missouri | 29095 | 2774 | 56 |
377825 | 377825 | 2020-07-28 | Jackson | Missouri | 29095 | 2852 | 55 |
381042 | 381042 | 2020-07-29 | Jackson | Missouri | 29095 | 2957 | 55 |
384258 | 384258 | 2020-07-30 | Jackson | Missouri | 29095 | 3189 | 56 |
387476 | 387476 | 2020-07-31 | Jackson | Missouri | 29095 | 3320 | 57 |
390693 | 390693 | 2020-08-01 | Jackson | Missouri | 29095 | 3396 | 59 |
393910 | 393910 | 2020-08-02 | Jackson | Missouri | 29095 | 3450 | 59 |
397126 | 397126 | 2020-08-03 | Jackson | Missouri | 29095 | 3537 | 59 |
400340 | 400340 | 2020-08-04 | Jackson | Missouri | 29095 | 3639 | 59 |
403557 | 403557 | 2020-08-05 | Jackson | Missouri | 29095 | 3713 | 61 |
406775 | 406775 | 2020-08-06 | Jackson | Missouri | 29095 | 3810 | 62 |
409995 | 409995 | 2020-08-07 | Jackson | Missouri | 29095 | 3909 | 64 |
413215 | 413215 | 2020-08-08 | Jackson | Missouri | 29095 | 3909 | 64 |
416435 | 416435 | 2020-08-09 | Jackson | Missouri | 29095 | 4014 | 64 |
419656 | 419656 | 2020-08-10 | Jackson | Missouri | 29095 | 4083 | 65 |
422878 | 422878 | 2020-08-11 | Jackson | Missouri | 29095 | 4155 | 66 |
426100 | 426100 | 2020-08-12 | Jackson | Missouri | 29095 | 4272 | 66 |
429324 | 429324 | 2020-08-13 | Jackson | Missouri | 29095 | 4363 | 66 |
432551 | 432551 | 2020-08-14 | Jackson | Missouri | 29095 | 4451 | 66 |
435777 | 435777 | 2020-08-15 | Jackson | Missouri | 29095 | 4523 | 66 |
439002 | 439002 | 2020-08-16 | Jackson | Missouri | 29095 | 4560 | 66 |
442229 | 442229 | 2020-08-17 | Jackson | Missouri | 29095 | 4640 | 66 |
445455 | 445455 | 2020-08-18 | Jackson | Missouri | 29095 | 4712 | 67 |
448681 | 448681 | 2020-08-19 | Jackson | Missouri | 29095 | 4758 | 67 |
451909 | 451909 | 2020-08-20 | Jackson | Missouri | 29095 | 4828 | 70 |
455137 | 455137 | 2020-08-21 | Jackson | Missouri | 29095 | 4869 | 71 |
458365 | 458365 | 2020-08-22 | Jackson | Missouri | 29095 | 5005 | 71 |
461592 | 461592 | 2020-08-23 | Jackson | Missouri | 29095 | 5038 | 71 |
464823 | 464823 | 2020-08-24 | Jackson | Missouri | 29095 | 5071 | 71 |
468052 | 468052 | 2020-08-25 | Jackson | Missouri | 29095 | 5116 | 73 |
471282 | 471282 | 2020-08-26 | Jackson | Missouri | 29095 | 5184 | 75 |
474514 | 474514 | 2020-08-27 | Jackson | Missouri | 29095 | 5254 | 77 |
477747 | 477747 | 2020-08-28 | Jackson | Missouri | 29095 | 5324 | 77 |
480979 | 480979 | 2020-08-29 | Jackson | Missouri | 29095 | 5386 | 77 |
484214 | 484214 | 2020-08-30 | Jackson | Missouri | 29095 | 5462 | 77 |
487448 | 487448 | 2020-08-31 | Jackson | Missouri | 29095 | 5521 | 77 |
490681 | 490681 | 2020-09-01 | Jackson | Missouri | 29095 | 5606 | 78 |
493915 | 493915 | 2020-09-02 | Jackson | Missouri | 29095 | 5707 | 78 |
497148 | 497148 | 2020-09-03 | Jackson | Missouri | 29095 | 5773 | 81 |
500382 | 500382 | 2020-09-04 | Jackson | Missouri | 29095 | 5819 | 82 |
503616 | 503616 | 2020-09-05 | Jackson | Missouri | 29095 | 5942 | 83 |
506849 | 506849 | 2020-09-06 | Jackson | Missouri | 29095 | 6002 | 83 |
510082 | 510082 | 2020-09-07 | Jackson | Missouri | 29095 | 6038 | 83 |
513314 | 513314 | 2020-09-08 | Jackson | Missouri | 29095 | 6083 | 84 |
516548 | 516548 | 2020-09-09 | Jackson | Missouri | 29095 | 6168 | 84 |
519783 | 519783 | 2020-09-10 | Jackson | Missouri | 29095 | 6232 | 85 |
523020 | 523020 | 2020-09-11 | Jackson | Missouri | 29095 | 6313 | 85 |
526256 | 526256 | 2020-09-12 | Jackson | Missouri | 29095 | 6407 | 85 |
529492 | 529492 | 2020-09-13 | Jackson | Missouri | 29095 | 6473 | 87 |
532728 | 532728 | 2020-09-14 | Jackson | Missouri | 29095 | 6527 | 87 |
535963 | 535963 | 2020-09-15 | Jackson | Missouri | 29095 | 6609 | 88 |
539200 | 539200 | 2020-09-16 | Jackson | Missouri | 29095 | 6695 | 89 |
542436 | 542436 | 2020-09-17 | Jackson | Missouri | 29095 | 6796 | 90 |
545673 | 545673 | 2020-09-18 | Jackson | Missouri | 29095 | 6912 | 92 |
548911 | 548911 | 2020-09-19 | Jackson | Missouri | 29095 | 6987 | 92 |
552150 | 552150 | 2020-09-20 | Jackson | Missouri | 29095 | 7064 | 80 |
555388 | 555388 | 2020-09-21 | Jackson | Missouri | 29095 | 7141 | 93 |
558625 | 558625 | 2020-09-22 | Jackson | Missouri | 29095 | 7178 | 95 |
561862 | 561862 | 2020-09-23 | Jackson | Missouri | 29095 | 7218 | 100 |
565102 | 565102 | 2020-09-24 | Jackson | Missouri | 29095 | 7291 | 99 |
568342 | 568342 | 2020-09-25 | Jackson | Missouri | 29095 | 7400 | 99 |
571584 | 571584 | 2020-09-26 | Jackson | Missouri | 29095 | 7470 | 99 |
574827 | 574827 | 2020-09-27 | Jackson | Missouri | 29095 | 7512 | 99 |
578068 | 578068 | 2020-09-28 | Jackson | Missouri | 29095 | 7588 | 101 |
581309 | 581309 | 2020-09-29 | Jackson | Missouri | 29095 | 7588 | 102 |
584550 | 584550 | 2020-09-30 | Jackson | Missouri | 29095 | 7460 | 102 |
587790 | 587790 | 2020-10-01 | Jackson | Missouri | 29095 | 7533 | 102 |
591031 | 591031 | 2020-10-02 | Jackson | Missouri | 29095 | 7629 | 103 |
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);