ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
747 rows where county = "Douglas" and fips = 46043 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922917 | 922917 | 2021-01-12 | Douglas | South Dakota | 46043 | 396 | 9 |
919672 | 919672 | 2021-01-11 | Douglas | South Dakota | 46043 | 396 | 9 |
916427 | 916427 | 2021-01-10 | Douglas | South Dakota | 46043 | 395 | 9 |
913182 | 913182 | 2021-01-09 | Douglas | South Dakota | 46043 | 391 | 9 |
909937 | 909937 | 2021-01-08 | Douglas | South Dakota | 46043 | 391 | 9 |
906692 | 906692 | 2021-01-07 | Douglas | South Dakota | 46043 | 388 | 9 |
903446 | 903446 | 2021-01-06 | Douglas | South Dakota | 46043 | 388 | 8 |
900201 | 900201 | 2021-01-05 | Douglas | South Dakota | 46043 | 386 | 8 |
896956 | 896956 | 2021-01-04 | Douglas | South Dakota | 46043 | 385 | 8 |
893710 | 893710 | 2021-01-03 | Douglas | South Dakota | 46043 | 385 | 8 |
890464 | 890464 | 2021-01-02 | Douglas | South Dakota | 46043 | 383 | 7 |
887217 | 887217 | 2021-01-01 | Douglas | South Dakota | 46043 | 382 | 7 |
883972 | 883972 | 2020-12-31 | Douglas | South Dakota | 46043 | 382 | 7 |
880727 | 880727 | 2020-12-30 | Douglas | South Dakota | 46043 | 381 | 7 |
877482 | 877482 | 2020-12-29 | Douglas | South Dakota | 46043 | 378 | 7 |
874237 | 874237 | 2020-12-28 | Douglas | South Dakota | 46043 | 378 | 7 |
870992 | 870992 | 2020-12-27 | Douglas | South Dakota | 46043 | 378 | 7 |
867747 | 867747 | 2020-12-26 | Douglas | South Dakota | 46043 | 374 | 7 |
864502 | 864502 | 2020-12-25 | Douglas | South Dakota | 46043 | 372 | 7 |
861257 | 861257 | 2020-12-24 | Douglas | South Dakota | 46043 | 372 | 7 |
858012 | 858012 | 2020-12-23 | Douglas | South Dakota | 46043 | 372 | 7 |
854767 | 854767 | 2020-12-22 | Douglas | South Dakota | 46043 | 367 | 7 |
851522 | 851522 | 2020-12-21 | Douglas | South Dakota | 46043 | 364 | 7 |
848277 | 848277 | 2020-12-20 | Douglas | South Dakota | 46043 | 363 | 7 |
845032 | 845032 | 2020-12-19 | Douglas | South Dakota | 46043 | 361 | 7 |
841786 | 841786 | 2020-12-18 | Douglas | South Dakota | 46043 | 353 | 6 |
838541 | 838541 | 2020-12-17 | Douglas | South Dakota | 46043 | 348 | 6 |
835295 | 835295 | 2020-12-16 | Douglas | South Dakota | 46043 | 346 | 6 |
832049 | 832049 | 2020-12-15 | Douglas | South Dakota | 46043 | 343 | 6 |
828802 | 828802 | 2020-12-14 | Douglas | South Dakota | 46043 | 341 | 6 |
825556 | 825556 | 2020-12-13 | Douglas | South Dakota | 46043 | 341 | 6 |
822309 | 822309 | 2020-12-12 | Douglas | South Dakota | 46043 | 336 | 6 |
819063 | 819063 | 2020-12-11 | Douglas | South Dakota | 46043 | 332 | 6 |
815817 | 815817 | 2020-12-10 | Douglas | South Dakota | 46043 | 329 | 5 |
812571 | 812571 | 2020-12-09 | Douglas | South Dakota | 46043 | 328 | 5 |
809327 | 809327 | 2020-12-08 | Douglas | South Dakota | 46043 | 322 | 5 |
806082 | 806082 | 2020-12-07 | Douglas | South Dakota | 46043 | 318 | 5 |
802837 | 802837 | 2020-12-06 | Douglas | South Dakota | 46043 | 318 | 5 |
799592 | 799592 | 2020-12-05 | Douglas | South Dakota | 46043 | 318 | 5 |
796347 | 796347 | 2020-12-04 | Douglas | South Dakota | 46043 | 316 | 5 |
793102 | 793102 | 2020-12-03 | Douglas | South Dakota | 46043 | 312 | 5 |
789857 | 789857 | 2020-12-02 | Douglas | South Dakota | 46043 | 305 | 5 |
786612 | 786612 | 2020-12-01 | Douglas | South Dakota | 46043 | 295 | 5 |
783368 | 783368 | 2020-11-30 | Douglas | South Dakota | 46043 | 294 | 5 |
780123 | 780123 | 2020-11-29 | Douglas | South Dakota | 46043 | 294 | 5 |
776877 | 776877 | 2020-11-28 | Douglas | South Dakota | 46043 | 293 | 5 |
773632 | 773632 | 2020-11-27 | Douglas | South Dakota | 46043 | 289 | 5 |
770387 | 770387 | 2020-11-26 | Douglas | South Dakota | 46043 | 283 | 5 |
767141 | 767141 | 2020-11-25 | Douglas | South Dakota | 46043 | 283 | 5 |
763896 | 763896 | 2020-11-24 | Douglas | South Dakota | 46043 | 279 | 5 |
760651 | 760651 | 2020-11-23 | Douglas | South Dakota | 46043 | 276 | 5 |
757406 | 757406 | 2020-11-22 | Douglas | South Dakota | 46043 | 274 | 5 |
754159 | 754159 | 2020-11-21 | Douglas | South Dakota | 46043 | 272 | 5 |
750913 | 750913 | 2020-11-20 | Douglas | South Dakota | 46043 | 269 | 5 |
747667 | 747667 | 2020-11-19 | Douglas | South Dakota | 46043 | 267 | 5 |
744421 | 744421 | 2020-11-18 | Douglas | South Dakota | 46043 | 264 | 5 |
741174 | 741174 | 2020-11-17 | Douglas | South Dakota | 46043 | 260 | 5 |
737928 | 737928 | 2020-11-16 | Douglas | South Dakota | 46043 | 258 | 5 |
734684 | 734684 | 2020-11-15 | Douglas | South Dakota | 46043 | 252 | 5 |
731438 | 731438 | 2020-11-14 | Douglas | South Dakota | 46043 | 246 | 5 |
728194 | 728194 | 2020-11-13 | Douglas | South Dakota | 46043 | 240 | 5 |
724950 | 724950 | 2020-11-12 | Douglas | South Dakota | 46043 | 236 | 5 |
721707 | 721707 | 2020-11-11 | Douglas | South Dakota | 46043 | 234 | 5 |
718464 | 718464 | 2020-11-10 | Douglas | South Dakota | 46043 | 224 | 5 |
715221 | 715221 | 2020-11-09 | Douglas | South Dakota | 46043 | 222 | 5 |
711977 | 711977 | 2020-11-08 | Douglas | South Dakota | 46043 | 222 | 5 |
708733 | 708733 | 2020-11-07 | Douglas | South Dakota | 46043 | 215 | 5 |
705490 | 705490 | 2020-11-06 | Douglas | South Dakota | 46043 | 211 | 5 |
702247 | 702247 | 2020-11-05 | Douglas | South Dakota | 46043 | 201 | 5 |
699003 | 699003 | 2020-11-04 | Douglas | South Dakota | 46043 | 189 | 5 |
695760 | 695760 | 2020-11-03 | Douglas | South Dakota | 46043 | 185 | 5 |
692518 | 692518 | 2020-11-02 | Douglas | South Dakota | 46043 | 180 | 5 |
689274 | 689274 | 2020-11-01 | Douglas | South Dakota | 46043 | 180 | 5 |
686029 | 686029 | 2020-10-31 | Douglas | South Dakota | 46043 | 177 | 4 |
682786 | 682786 | 2020-10-30 | Douglas | South Dakota | 46043 | 169 | 4 |
679543 | 679543 | 2020-10-29 | Douglas | South Dakota | 46043 | 165 | 4 |
676300 | 676300 | 2020-10-28 | Douglas | South Dakota | 46043 | 165 | 4 |
673057 | 673057 | 2020-10-27 | Douglas | South Dakota | 46043 | 161 | 4 |
669815 | 669815 | 2020-10-26 | Douglas | South Dakota | 46043 | 160 | 4 |
666571 | 666571 | 2020-10-25 | Douglas | South Dakota | 46043 | 159 | 4 |
663326 | 663326 | 2020-10-24 | Douglas | South Dakota | 46043 | 157 | 4 |
660082 | 660082 | 2020-10-23 | Douglas | South Dakota | 46043 | 155 | 4 |
656838 | 656838 | 2020-10-22 | Douglas | South Dakota | 46043 | 154 | 4 |
653593 | 653593 | 2020-10-21 | Douglas | South Dakota | 46043 | 151 | 4 |
650348 | 650348 | 2020-10-20 | Douglas | South Dakota | 46043 | 150 | 4 |
647104 | 647104 | 2020-10-19 | Douglas | South Dakota | 46043 | 148 | 4 |
643858 | 643858 | 2020-10-18 | Douglas | South Dakota | 46043 | 148 | 4 |
640610 | 640610 | 2020-10-17 | Douglas | South Dakota | 46043 | 146 | 4 |
637364 | 637364 | 2020-10-16 | Douglas | South Dakota | 46043 | 145 | 3 |
634118 | 634118 | 2020-10-15 | Douglas | South Dakota | 46043 | 142 | 2 |
630873 | 630873 | 2020-10-14 | Douglas | South Dakota | 46043 | 136 | 2 |
627629 | 627629 | 2020-10-13 | Douglas | South Dakota | 46043 | 133 | 1 |
624387 | 624387 | 2020-10-12 | Douglas | South Dakota | 46043 | 133 | 1 |
621144 | 621144 | 2020-10-11 | Douglas | South Dakota | 46043 | 133 | 1 |
617901 | 617901 | 2020-10-10 | Douglas | South Dakota | 46043 | 125 | 1 |
614659 | 614659 | 2020-10-09 | Douglas | South Dakota | 46043 | 119 | 1 |
611418 | 611418 | 2020-10-08 | Douglas | South Dakota | 46043 | 115 | 1 |
608176 | 608176 | 2020-10-07 | Douglas | South Dakota | 46043 | 111 | 1 |
604933 | 604933 | 2020-10-06 | Douglas | South Dakota | 46043 | 103 | 1 |
601691 | 601691 | 2020-10-05 | Douglas | South Dakota | 46043 | 103 | 1 |
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);