ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
713 rows where county = "Douglas" and state = "Missouri" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
513300 | 513300 | 2020-09-08 | Douglas | Missouri | 29067 | 120 | 3 |
516534 | 516534 | 2020-09-09 | Douglas | Missouri | 29067 | 124 | 3 |
519769 | 519769 | 2020-09-10 | Douglas | Missouri | 29067 | 128 | 3 |
523006 | 523006 | 2020-09-11 | Douglas | Missouri | 29067 | 132 | 3 |
526242 | 526242 | 2020-09-12 | Douglas | Missouri | 29067 | 134 | 3 |
529478 | 529478 | 2020-09-13 | Douglas | Missouri | 29067 | 137 | 3 |
532714 | 532714 | 2020-09-14 | Douglas | Missouri | 29067 | 137 | 3 |
535949 | 535949 | 2020-09-15 | Douglas | Missouri | 29067 | 139 | 3 |
539186 | 539186 | 2020-09-16 | Douglas | Missouri | 29067 | 143 | 3 |
542422 | 542422 | 2020-09-17 | Douglas | Missouri | 29067 | 149 | 3 |
545659 | 545659 | 2020-09-18 | Douglas | Missouri | 29067 | 155 | 3 |
548897 | 548897 | 2020-09-19 | Douglas | Missouri | 29067 | 162 | 3 |
552136 | 552136 | 2020-09-20 | Douglas | Missouri | 29067 | 164 | 3 |
555374 | 555374 | 2020-09-21 | Douglas | Missouri | 29067 | 165 | 3 |
558611 | 558611 | 2020-09-22 | Douglas | Missouri | 29067 | 169 | 3 |
561848 | 561848 | 2020-09-23 | Douglas | Missouri | 29067 | 174 | 3 |
565088 | 565088 | 2020-09-24 | Douglas | Missouri | 29067 | 178 | 3 |
568328 | 568328 | 2020-09-25 | Douglas | Missouri | 29067 | 188 | 3 |
571570 | 571570 | 2020-09-26 | Douglas | Missouri | 29067 | 193 | 3 |
574813 | 574813 | 2020-09-27 | Douglas | Missouri | 29067 | 205 | 3 |
578054 | 578054 | 2020-09-28 | Douglas | Missouri | 29067 | 208 | 3 |
581295 | 581295 | 2020-09-29 | Douglas | Missouri | 29067 | 208 | 3 |
584536 | 584536 | 2020-09-30 | Douglas | Missouri | 29067 | 214 | 3 |
587776 | 587776 | 2020-10-01 | Douglas | Missouri | 29067 | 219 | 3 |
591017 | 591017 | 2020-10-02 | Douglas | Missouri | 29067 | 225 | 3 |
594258 | 594258 | 2020-10-03 | Douglas | Missouri | 29067 | 229 | 3 |
597499 | 597499 | 2020-10-04 | Douglas | Missouri | 29067 | 232 | 3 |
600742 | 600742 | 2020-10-05 | Douglas | Missouri | 29067 | 231 | 3 |
603984 | 603984 | 2020-10-06 | Douglas | Missouri | 29067 | 232 | 3 |
607227 | 607227 | 2020-10-07 | Douglas | Missouri | 29067 | 235 | 3 |
610469 | 610469 | 2020-10-08 | Douglas | Missouri | 29067 | 236 | 3 |
613711 | 613711 | 2020-10-09 | Douglas | Missouri | 29067 | 236 | 3 |
616952 | 616952 | 2020-10-10 | Douglas | Missouri | 29067 | 248 | 3 |
620194 | 620194 | 2020-10-11 | Douglas | Missouri | 29067 | 248 | 3 |
623437 | 623437 | 2020-10-12 | Douglas | Missouri | 29067 | 248 | 3 |
626679 | 626679 | 2020-10-13 | Douglas | Missouri | 29067 | 248 | 3 |
629923 | 629923 | 2020-10-14 | Douglas | Missouri | 29067 | 251 | 3 |
633168 | 633168 | 2020-10-15 | Douglas | Missouri | 29067 | 256 | 3 |
636414 | 636414 | 2020-10-16 | Douglas | Missouri | 29067 | 259 | 3 |
639660 | 639660 | 2020-10-17 | Douglas | Missouri | 29067 | 265 | 6 |
642908 | 642908 | 2020-10-18 | Douglas | Missouri | 29067 | 268 | 6 |
646154 | 646154 | 2020-10-19 | Douglas | Missouri | 29067 | 272 | 6 |
649398 | 649398 | 2020-10-20 | Douglas | Missouri | 29067 | 272 | 6 |
652643 | 652643 | 2020-10-21 | Douglas | Missouri | 29067 | 273 | 9 |
655888 | 655888 | 2020-10-22 | Douglas | Missouri | 29067 | 276 | 9 |
659133 | 659133 | 2020-10-23 | Douglas | Missouri | 29067 | 277 | 9 |
662377 | 662377 | 2020-10-24 | Douglas | Missouri | 29067 | 280 | 11 |
665622 | 665622 | 2020-10-25 | Douglas | Missouri | 29067 | 284 | 11 |
668866 | 668866 | 2020-10-26 | Douglas | Missouri | 29067 | 285 | 11 |
672108 | 672108 | 2020-10-27 | Douglas | Missouri | 29067 | 288 | 12 |
675351 | 675351 | 2020-10-28 | Douglas | Missouri | 29067 | 288 | 12 |
678593 | 678593 | 2020-10-29 | Douglas | Missouri | 29067 | 295 | 12 |
681837 | 681837 | 2020-10-30 | Douglas | Missouri | 29067 | 297 | 12 |
685080 | 685080 | 2020-10-31 | Douglas | Missouri | 29067 | 302 | 12 |
688324 | 688324 | 2020-11-01 | Douglas | Missouri | 29067 | 305 | 12 |
691569 | 691569 | 2020-11-02 | Douglas | Missouri | 29067 | 308 | 12 |
694811 | 694811 | 2020-11-03 | Douglas | Missouri | 29067 | 312 | 13 |
698054 | 698054 | 2020-11-04 | Douglas | Missouri | 29067 | 314 | 13 |
701298 | 701298 | 2020-11-05 | Douglas | Missouri | 29067 | 315 | 13 |
704540 | 704540 | 2020-11-06 | Douglas | Missouri | 29067 | 319 | 13 |
707783 | 707783 | 2020-11-07 | Douglas | Missouri | 29067 | 327 | 13 |
711027 | 711027 | 2020-11-08 | Douglas | Missouri | 29067 | 331 | 13 |
714271 | 714271 | 2020-11-09 | Douglas | Missouri | 29067 | 335 | 13 |
717515 | 717515 | 2020-11-10 | Douglas | Missouri | 29067 | 339 | 14 |
720758 | 720758 | 2020-11-11 | Douglas | Missouri | 29067 | 345 | 14 |
724001 | 724001 | 2020-11-12 | Douglas | Missouri | 29067 | 345 | 14 |
727244 | 727244 | 2020-11-13 | Douglas | Missouri | 29067 | 350 | 14 |
730487 | 730487 | 2020-11-14 | Douglas | Missouri | 29067 | 356 | 14 |
733732 | 733732 | 2020-11-15 | Douglas | Missouri | 29067 | 356 | 14 |
736978 | 736978 | 2020-11-16 | Douglas | Missouri | 29067 | 358 | 14 |
740222 | 740222 | 2020-11-17 | Douglas | Missouri | 29067 | 364 | 14 |
743469 | 743469 | 2020-11-18 | Douglas | Missouri | 29067 | 367 | 14 |
746716 | 746716 | 2020-11-19 | Douglas | Missouri | 29067 | 371 | 14 |
749962 | 749962 | 2020-11-20 | Douglas | Missouri | 29067 | 377 | 15 |
753208 | 753208 | 2020-11-21 | Douglas | Missouri | 29067 | 381 | 15 |
756454 | 756454 | 2020-11-22 | Douglas | Missouri | 29067 | 383 | 15 |
759701 | 759701 | 2020-11-23 | Douglas | Missouri | 29067 | 388 | 15 |
762946 | 762946 | 2020-11-24 | Douglas | Missouri | 29067 | 394 | 15 |
766191 | 766191 | 2020-11-25 | Douglas | Missouri | 29067 | 402 | 15 |
769437 | 769437 | 2020-11-26 | Douglas | Missouri | 29067 | 416 | 15 |
772682 | 772682 | 2020-11-27 | Douglas | Missouri | 29067 | 422 | 15 |
775927 | 775927 | 2020-11-28 | Douglas | Missouri | 29067 | 425 | 15 |
779172 | 779172 | 2020-11-29 | Douglas | Missouri | 29067 | 434 | 15 |
782418 | 782418 | 2020-11-30 | Douglas | Missouri | 29067 | 442 | 15 |
785662 | 785662 | 2020-12-01 | Douglas | Missouri | 29067 | 447 | 15 |
788907 | 788907 | 2020-12-02 | Douglas | Missouri | 29067 | 450 | 15 |
792152 | 792152 | 2020-12-03 | Douglas | Missouri | 29067 | 452 | 15 |
795397 | 795397 | 2020-12-04 | Douglas | Missouri | 29067 | 455 | 15 |
798642 | 798642 | 2020-12-05 | Douglas | Missouri | 29067 | 461 | 15 |
801887 | 801887 | 2020-12-06 | Douglas | Missouri | 29067 | 466 | 15 |
805132 | 805132 | 2020-12-07 | Douglas | Missouri | 29067 | 474 | 15 |
808377 | 808377 | 2020-12-08 | Douglas | Missouri | 29067 | 476 | 16 |
811622 | 811622 | 2020-12-09 | Douglas | Missouri | 29067 | 477 | 17 |
814867 | 814867 | 2020-12-10 | Douglas | Missouri | 29067 | 482 | 17 |
818113 | 818113 | 2020-12-11 | Douglas | Missouri | 29067 | 482 | 17 |
821359 | 821359 | 2020-12-12 | Douglas | Missouri | 29067 | 506 | 18 |
824605 | 824605 | 2020-12-13 | Douglas | Missouri | 29067 | 511 | 18 |
827852 | 827852 | 2020-12-14 | Douglas | Missouri | 29067 | 520 | 18 |
831098 | 831098 | 2020-12-15 | Douglas | Missouri | 29067 | 530 | 19 |
834345 | 834345 | 2020-12-16 | Douglas | Missouri | 29067 | 536 | 19 |
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);