ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Burleigh" and state = "North Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
954902 | 954902 | 2021-01-22 | Burleigh | North Dakota | 38015 | 14130 | 184 |
951657 | 951657 | 2021-01-21 | Burleigh | North Dakota | 38015 | 14098 | 184 |
948412 | 948412 | 2021-01-20 | Burleigh | North Dakota | 38015 | 14075 | 182 |
945166 | 945166 | 2021-01-19 | Burleigh | North Dakota | 38015 | 14055 | 182 |
941919 | 941919 | 2021-01-18 | Burleigh | North Dakota | 38015 | 14038 | 182 |
938674 | 938674 | 2021-01-17 | Burleigh | North Dakota | 38015 | 14025 | 182 |
935429 | 935429 | 2021-01-16 | Burleigh | North Dakota | 38015 | 13997 | 182 |
932184 | 932184 | 2021-01-15 | Burleigh | North Dakota | 38015 | 13988 | 181 |
928939 | 928939 | 2021-01-14 | Burleigh | North Dakota | 38015 | 13966 | 181 |
925694 | 925694 | 2021-01-13 | Burleigh | North Dakota | 38015 | 13932 | 180 |
922448 | 922448 | 2021-01-12 | Burleigh | North Dakota | 38015 | 13909 | 180 |
919203 | 919203 | 2021-01-11 | Burleigh | North Dakota | 38015 | 13883 | 179 |
915958 | 915958 | 2021-01-10 | Burleigh | North Dakota | 38015 | 13870 | 179 |
912713 | 912713 | 2021-01-09 | Burleigh | North Dakota | 38015 | 13859 | 179 |
909468 | 909468 | 2021-01-08 | Burleigh | North Dakota | 38015 | 13853 | 179 |
906223 | 906223 | 2021-01-07 | Burleigh | North Dakota | 38015 | 13818 | 179 |
902977 | 902977 | 2021-01-06 | Burleigh | North Dakota | 38015 | 13789 | 179 |
899732 | 899732 | 2021-01-05 | Burleigh | North Dakota | 38015 | 13742 | 178 |
896487 | 896487 | 2021-01-04 | Burleigh | North Dakota | 38015 | 13728 | 178 |
893241 | 893241 | 2021-01-03 | Burleigh | North Dakota | 38015 | 13712 | 177 |
889995 | 889995 | 2021-01-02 | Burleigh | North Dakota | 38015 | 13695 | 177 |
886748 | 886748 | 2021-01-01 | Burleigh | North Dakota | 38015 | 13680 | 176 |
883503 | 883503 | 2020-12-31 | Burleigh | North Dakota | 38015 | 13643 | 175 |
880258 | 880258 | 2020-12-30 | Burleigh | North Dakota | 38015 | 13618 | 174 |
877013 | 877013 | 2020-12-29 | Burleigh | North Dakota | 38015 | 13584 | 172 |
873768 | 873768 | 2020-12-28 | Burleigh | North Dakota | 38015 | 13563 | 172 |
870523 | 870523 | 2020-12-27 | Burleigh | North Dakota | 38015 | 13545 | 170 |
867278 | 867278 | 2020-12-26 | Burleigh | North Dakota | 38015 | 13527 | 169 |
864033 | 864033 | 2020-12-25 | Burleigh | North Dakota | 38015 | 13514 | 169 |
860788 | 860788 | 2020-12-24 | Burleigh | North Dakota | 38015 | 13472 | 168 |
857543 | 857543 | 2020-12-23 | Burleigh | North Dakota | 38015 | 13441 | 162 |
854298 | 854298 | 2020-12-22 | Burleigh | North Dakota | 38015 | 13418 | 161 |
851053 | 851053 | 2020-12-21 | Burleigh | North Dakota | 38015 | 13385 | 161 |
847808 | 847808 | 2020-12-20 | Burleigh | North Dakota | 38015 | 13366 | 160 |
844563 | 844563 | 2020-12-19 | Burleigh | North Dakota | 38015 | 13347 | 160 |
841317 | 841317 | 2020-12-18 | Burleigh | North Dakota | 38015 | 13324 | 160 |
838072 | 838072 | 2020-12-17 | Burleigh | North Dakota | 38015 | 13274 | 159 |
834826 | 834826 | 2020-12-16 | Burleigh | North Dakota | 38015 | 13237 | 157 |
831580 | 831580 | 2020-12-15 | Burleigh | North Dakota | 38015 | 13206 | 152 |
828333 | 828333 | 2020-12-14 | Burleigh | North Dakota | 38015 | 13156 | 150 |
825087 | 825087 | 2020-12-13 | Burleigh | North Dakota | 38015 | 13107 | 148 |
821840 | 821840 | 2020-12-12 | Burleigh | North Dakota | 38015 | 13074 | 148 |
818594 | 818594 | 2020-12-11 | Burleigh | North Dakota | 38015 | 13022 | 144 |
815348 | 815348 | 2020-12-10 | Burleigh | North Dakota | 38015 | 12952 | 143 |
812103 | 812103 | 2020-12-09 | Burleigh | North Dakota | 38015 | 12872 | 138 |
808858 | 808858 | 2020-12-08 | Burleigh | North Dakota | 38015 | 12561 | 129 |
805613 | 805613 | 2020-12-07 | Burleigh | North Dakota | 38015 | 12561 | 129 |
802368 | 802368 | 2020-12-06 | Burleigh | North Dakota | 38015 | 12525 | 129 |
799123 | 799123 | 2020-12-05 | Burleigh | North Dakota | 38015 | 12445 | 128 |
795878 | 795878 | 2020-12-04 | Burleigh | North Dakota | 38015 | 12372 | 128 |
792633 | 792633 | 2020-12-03 | Burleigh | North Dakota | 38015 | 12240 | 127 |
789388 | 789388 | 2020-12-02 | Burleigh | North Dakota | 38015 | 12144 | 125 |
786143 | 786143 | 2020-12-01 | Burleigh | North Dakota | 38015 | 12036 | 123 |
782899 | 782899 | 2020-11-30 | Burleigh | North Dakota | 38015 | 12007 | 121 |
779653 | 779653 | 2020-11-29 | Burleigh | North Dakota | 38015 | 11933 | 121 |
776408 | 776408 | 2020-11-28 | Burleigh | North Dakota | 38015 | 11802 | 119 |
773163 | 773163 | 2020-11-27 | Burleigh | North Dakota | 38015 | 11711 | 119 |
769918 | 769918 | 2020-11-26 | Burleigh | North Dakota | 38015 | 11632 | 119 |
766672 | 766672 | 2020-11-25 | Burleigh | North Dakota | 38015 | 11474 | 117 |
763427 | 763427 | 2020-11-24 | Burleigh | North Dakota | 38015 | 11269 | 117 |
760182 | 760182 | 2020-11-23 | Burleigh | North Dakota | 38015 | 11153 | 115 |
756936 | 756936 | 2020-11-22 | Burleigh | North Dakota | 38015 | 11050 | 112 |
753689 | 753689 | 2020-11-21 | Burleigh | North Dakota | 38015 | 10892 | 112 |
750443 | 750443 | 2020-11-20 | Burleigh | North Dakota | 38015 | 10658 | 110 |
747197 | 747197 | 2020-11-19 | Burleigh | North Dakota | 38015 | 10474 | 110 |
743951 | 743951 | 2020-11-18 | Burleigh | North Dakota | 38015 | 10334 | 108 |
740704 | 740704 | 2020-11-17 | Burleigh | North Dakota | 38015 | 10145 | 105 |
737459 | 737459 | 2020-11-16 | Burleigh | North Dakota | 38015 | 10014 | 101 |
734215 | 734215 | 2020-11-15 | Burleigh | North Dakota | 38015 | 9897 | 101 |
730969 | 730969 | 2020-11-14 | Burleigh | North Dakota | 38015 | 9766 | 101 |
727725 | 727725 | 2020-11-13 | Burleigh | North Dakota | 38015 | 9502 | 99 |
724481 | 724481 | 2020-11-12 | Burleigh | North Dakota | 38015 | 9312 | 99 |
721238 | 721238 | 2020-11-11 | Burleigh | North Dakota | 38015 | 9084 | 99 |
717995 | 717995 | 2020-11-10 | Burleigh | North Dakota | 38015 | 8970 | 99 |
714752 | 714752 | 2020-11-09 | Burleigh | North Dakota | 38015 | 8835 | 91 |
711508 | 711508 | 2020-11-08 | Burleigh | North Dakota | 38015 | 8620 | 90 |
708264 | 708264 | 2020-11-07 | Burleigh | North Dakota | 38015 | 8478 | 90 |
705021 | 705021 | 2020-11-06 | Burleigh | North Dakota | 38015 | 8325 | 90 |
701778 | 701778 | 2020-11-05 | Burleigh | North Dakota | 38015 | 8084 | 86 |
698534 | 698534 | 2020-11-04 | Burleigh | North Dakota | 38015 | 7871 | 83 |
695291 | 695291 | 2020-11-03 | Burleigh | North Dakota | 38015 | 7740 | 83 |
692049 | 692049 | 2020-11-02 | Burleigh | North Dakota | 38015 | 7591 | 80 |
688805 | 688805 | 2020-11-01 | Burleigh | North Dakota | 38015 | 7486 | 79 |
685560 | 685560 | 2020-10-31 | Burleigh | North Dakota | 38015 | 7313 | 78 |
682317 | 682317 | 2020-10-30 | Burleigh | North Dakota | 38015 | 7171 | 78 |
679074 | 679074 | 2020-10-29 | Burleigh | North Dakota | 38015 | 6985 | 78 |
675831 | 675831 | 2020-10-28 | Burleigh | North Dakota | 38015 | 6817 | 78 |
672588 | 672588 | 2020-10-27 | Burleigh | North Dakota | 38015 | 6670 | 77 |
669346 | 669346 | 2020-10-26 | Burleigh | North Dakota | 38015 | 6484 | 76 |
666102 | 666102 | 2020-10-25 | Burleigh | North Dakota | 38015 | 6395 | 76 |
662857 | 662857 | 2020-10-24 | Burleigh | North Dakota | 38015 | 6284 | 75 |
659613 | 659613 | 2020-10-23 | Burleigh | North Dakota | 38015 | 6120 | 75 |
656369 | 656369 | 2020-10-22 | Burleigh | North Dakota | 38015 | 6020 | 74 |
653124 | 653124 | 2020-10-21 | Burleigh | North Dakota | 38015 | 5852 | 74 |
649879 | 649879 | 2020-10-20 | Burleigh | North Dakota | 38015 | 5812 | 72 |
646635 | 646635 | 2020-10-19 | Burleigh | North Dakota | 38015 | 5591 | 72 |
643389 | 643389 | 2020-10-18 | Burleigh | North Dakota | 38015 | 5473 | 70 |
640141 | 640141 | 2020-10-17 | Burleigh | North Dakota | 38015 | 5359 | 69 |
636895 | 636895 | 2020-10-16 | Burleigh | North Dakota | 38015 | 5211 | 68 |
633649 | 633649 | 2020-10-15 | Burleigh | North Dakota | 38015 | 5105 | 64 |
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);