ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
655 rows where county = "Adams" and fips = 38001 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922441 | 922441 | 2021-01-12 | Adams | North Dakota | 38001 | 212 | 2 |
919196 | 919196 | 2021-01-11 | Adams | North Dakota | 38001 | 212 | 2 |
915951 | 915951 | 2021-01-10 | Adams | North Dakota | 38001 | 209 | 2 |
912706 | 912706 | 2021-01-09 | Adams | North Dakota | 38001 | 203 | 2 |
909461 | 909461 | 2021-01-08 | Adams | North Dakota | 38001 | 198 | 2 |
906216 | 906216 | 2021-01-07 | Adams | North Dakota | 38001 | 195 | 2 |
902970 | 902970 | 2021-01-06 | Adams | North Dakota | 38001 | 193 | 2 |
899725 | 899725 | 2021-01-05 | Adams | North Dakota | 38001 | 192 | 2 |
896480 | 896480 | 2021-01-04 | Adams | North Dakota | 38001 | 192 | 2 |
893234 | 893234 | 2021-01-03 | Adams | North Dakota | 38001 | 190 | 2 |
889988 | 889988 | 2021-01-02 | Adams | North Dakota | 38001 | 190 | 2 |
886741 | 886741 | 2021-01-01 | Adams | North Dakota | 38001 | 190 | 2 |
883496 | 883496 | 2020-12-31 | Adams | North Dakota | 38001 | 190 | 2 |
880251 | 880251 | 2020-12-30 | Adams | North Dakota | 38001 | 190 | 2 |
877006 | 877006 | 2020-12-29 | Adams | North Dakota | 38001 | 190 | 2 |
873761 | 873761 | 2020-12-28 | Adams | North Dakota | 38001 | 190 | 2 |
870516 | 870516 | 2020-12-27 | Adams | North Dakota | 38001 | 190 | 2 |
867271 | 867271 | 2020-12-26 | Adams | North Dakota | 38001 | 190 | 2 |
864026 | 864026 | 2020-12-25 | Adams | North Dakota | 38001 | 190 | 2 |
860781 | 860781 | 2020-12-24 | Adams | North Dakota | 38001 | 190 | 2 |
857536 | 857536 | 2020-12-23 | Adams | North Dakota | 38001 | 190 | 2 |
854291 | 854291 | 2020-12-22 | Adams | North Dakota | 38001 | 190 | 2 |
851046 | 851046 | 2020-12-21 | Adams | North Dakota | 38001 | 194 | 2 |
847801 | 847801 | 2020-12-20 | Adams | North Dakota | 38001 | 194 | 2 |
844556 | 844556 | 2020-12-19 | Adams | North Dakota | 38001 | 194 | 2 |
841310 | 841310 | 2020-12-18 | Adams | North Dakota | 38001 | 194 | 2 |
838065 | 838065 | 2020-12-17 | Adams | North Dakota | 38001 | 190 | 2 |
834819 | 834819 | 2020-12-16 | Adams | North Dakota | 38001 | 189 | 2 |
831573 | 831573 | 2020-12-15 | Adams | North Dakota | 38001 | 190 | 1 |
828326 | 828326 | 2020-12-14 | Adams | North Dakota | 38001 | 190 | 1 |
825080 | 825080 | 2020-12-13 | Adams | North Dakota | 38001 | 190 | 0 |
821833 | 821833 | 2020-12-12 | Adams | North Dakota | 38001 | 189 | 0 |
818587 | 818587 | 2020-12-11 | Adams | North Dakota | 38001 | 188 | 0 |
815341 | 815341 | 2020-12-10 | Adams | North Dakota | 38001 | 188 | 0 |
812096 | 812096 | 2020-12-09 | Adams | North Dakota | 38001 | 187 | 0 |
808851 | 808851 | 2020-12-08 | Adams | North Dakota | 38001 | 187 | 0 |
805606 | 805606 | 2020-12-07 | Adams | North Dakota | 38001 | 187 | 0 |
802361 | 802361 | 2020-12-06 | Adams | North Dakota | 38001 | 184 | 0 |
799116 | 799116 | 2020-12-05 | Adams | North Dakota | 38001 | 183 | 0 |
795871 | 795871 | 2020-12-04 | Adams | North Dakota | 38001 | 182 | 0 |
792626 | 792626 | 2020-12-03 | Adams | North Dakota | 38001 | 183 | 0 |
789381 | 789381 | 2020-12-02 | Adams | North Dakota | 38001 | 177 | 0 |
786136 | 786136 | 2020-12-01 | Adams | North Dakota | 38001 | 177 | 0 |
782892 | 782892 | 2020-11-30 | Adams | North Dakota | 38001 | 175 | 0 |
779646 | 779646 | 2020-11-29 | Adams | North Dakota | 38001 | 173 | 0 |
776401 | 776401 | 2020-11-28 | Adams | North Dakota | 38001 | 169 | 0 |
773156 | 773156 | 2020-11-27 | Adams | North Dakota | 38001 | 165 | 0 |
769911 | 769911 | 2020-11-26 | Adams | North Dakota | 38001 | 162 | 0 |
766665 | 766665 | 2020-11-25 | Adams | North Dakota | 38001 | 160 | 0 |
763420 | 763420 | 2020-11-24 | Adams | North Dakota | 38001 | 158 | 0 |
760175 | 760175 | 2020-11-23 | Adams | North Dakota | 38001 | 157 | 0 |
756929 | 756929 | 2020-11-22 | Adams | North Dakota | 38001 | 157 | 0 |
753682 | 753682 | 2020-11-21 | Adams | North Dakota | 38001 | 155 | 0 |
750436 | 750436 | 2020-11-20 | Adams | North Dakota | 38001 | 149 | 0 |
747190 | 747190 | 2020-11-19 | Adams | North Dakota | 38001 | 146 | 0 |
743944 | 743944 | 2020-11-18 | Adams | North Dakota | 38001 | 143 | 0 |
740697 | 740697 | 2020-11-17 | Adams | North Dakota | 38001 | 135 | 0 |
737452 | 737452 | 2020-11-16 | Adams | North Dakota | 38001 | 132 | 0 |
734208 | 734208 | 2020-11-15 | Adams | North Dakota | 38001 | 130 | 0 |
730962 | 730962 | 2020-11-14 | Adams | North Dakota | 38001 | 129 | 0 |
727718 | 727718 | 2020-11-13 | Adams | North Dakota | 38001 | 124 | 0 |
724474 | 724474 | 2020-11-12 | Adams | North Dakota | 38001 | 123 | 0 |
721231 | 721231 | 2020-11-11 | Adams | North Dakota | 38001 | 119 | 0 |
717988 | 717988 | 2020-11-10 | Adams | North Dakota | 38001 | 119 | 0 |
714745 | 714745 | 2020-11-09 | Adams | North Dakota | 38001 | 116 | 0 |
711501 | 711501 | 2020-11-08 | Adams | North Dakota | 38001 | 115 | 0 |
708257 | 708257 | 2020-11-07 | Adams | North Dakota | 38001 | 114 | 0 |
705014 | 705014 | 2020-11-06 | Adams | North Dakota | 38001 | 109 | 0 |
701771 | 701771 | 2020-11-05 | Adams | North Dakota | 38001 | 109 | 0 |
698527 | 698527 | 2020-11-04 | Adams | North Dakota | 38001 | 105 | 0 |
695284 | 695284 | 2020-11-03 | Adams | North Dakota | 38001 | 100 | 0 |
692042 | 692042 | 2020-11-02 | Adams | North Dakota | 38001 | 95 | 0 |
688798 | 688798 | 2020-11-01 | Adams | North Dakota | 38001 | 91 | 0 |
685553 | 685553 | 2020-10-31 | Adams | North Dakota | 38001 | 90 | 0 |
682310 | 682310 | 2020-10-30 | Adams | North Dakota | 38001 | 89 | 0 |
679067 | 679067 | 2020-10-29 | Adams | North Dakota | 38001 | 85 | 0 |
675824 | 675824 | 2020-10-28 | Adams | North Dakota | 38001 | 80 | 0 |
672581 | 672581 | 2020-10-27 | Adams | North Dakota | 38001 | 79 | 0 |
669339 | 669339 | 2020-10-26 | Adams | North Dakota | 38001 | 75 | 0 |
666095 | 666095 | 2020-10-25 | Adams | North Dakota | 38001 | 73 | 0 |
662850 | 662850 | 2020-10-24 | Adams | North Dakota | 38001 | 73 | 0 |
659606 | 659606 | 2020-10-23 | Adams | North Dakota | 38001 | 69 | 0 |
656362 | 656362 | 2020-10-22 | Adams | North Dakota | 38001 | 65 | 0 |
653117 | 653117 | 2020-10-21 | Adams | North Dakota | 38001 | 62 | 0 |
649872 | 649872 | 2020-10-20 | Adams | North Dakota | 38001 | 59 | 0 |
646628 | 646628 | 2020-10-19 | Adams | North Dakota | 38001 | 59 | 0 |
643382 | 643382 | 2020-10-18 | Adams | North Dakota | 38001 | 54 | 0 |
640134 | 640134 | 2020-10-17 | Adams | North Dakota | 38001 | 51 | 0 |
636888 | 636888 | 2020-10-16 | Adams | North Dakota | 38001 | 49 | 0 |
633642 | 633642 | 2020-10-15 | Adams | North Dakota | 38001 | 49 | 0 |
630397 | 630397 | 2020-10-14 | Adams | North Dakota | 38001 | 44 | 0 |
627153 | 627153 | 2020-10-13 | Adams | North Dakota | 38001 | 42 | 0 |
623911 | 623911 | 2020-10-12 | Adams | North Dakota | 38001 | 40 | 0 |
620668 | 620668 | 2020-10-11 | Adams | North Dakota | 38001 | 38 | 0 |
617426 | 617426 | 2020-10-10 | Adams | North Dakota | 38001 | 38 | 0 |
614184 | 614184 | 2020-10-09 | Adams | North Dakota | 38001 | 30 | 0 |
610943 | 610943 | 2020-10-08 | Adams | North Dakota | 38001 | 29 | 0 |
607701 | 607701 | 2020-10-07 | Adams | North Dakota | 38001 | 28 | 0 |
604458 | 604458 | 2020-10-06 | Adams | North Dakota | 38001 | 28 | 0 |
601216 | 601216 | 2020-10-05 | Adams | North Dakota | 38001 | 27 | 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);