ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Burke" 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 |
---|---|---|---|---|---|---|---|
922447 | 922447 | 2021-01-12 | Burke | North Dakota | 38013 | 201 | 1 |
919202 | 919202 | 2021-01-11 | Burke | North Dakota | 38013 | 201 | 1 |
915957 | 915957 | 2021-01-10 | Burke | North Dakota | 38013 | 201 | 1 |
912712 | 912712 | 2021-01-09 | Burke | North Dakota | 38013 | 201 | 1 |
909467 | 909467 | 2021-01-08 | Burke | North Dakota | 38013 | 201 | 1 |
906222 | 906222 | 2021-01-07 | Burke | North Dakota | 38013 | 201 | 1 |
902976 | 902976 | 2021-01-06 | Burke | North Dakota | 38013 | 201 | 1 |
899731 | 899731 | 2021-01-05 | Burke | North Dakota | 38013 | 201 | 1 |
896486 | 896486 | 2021-01-04 | Burke | North Dakota | 38013 | 201 | 1 |
893240 | 893240 | 2021-01-03 | Burke | North Dakota | 38013 | 200 | 1 |
889994 | 889994 | 2021-01-02 | Burke | North Dakota | 38013 | 200 | 1 |
886747 | 886747 | 2021-01-01 | Burke | North Dakota | 38013 | 200 | 1 |
883502 | 883502 | 2020-12-31 | Burke | North Dakota | 38013 | 200 | 1 |
880257 | 880257 | 2020-12-30 | Burke | North Dakota | 38013 | 200 | 1 |
877012 | 877012 | 2020-12-29 | Burke | North Dakota | 38013 | 199 | 1 |
873767 | 873767 | 2020-12-28 | Burke | North Dakota | 38013 | 197 | 1 |
870522 | 870522 | 2020-12-27 | Burke | North Dakota | 38013 | 197 | 1 |
867277 | 867277 | 2020-12-26 | Burke | North Dakota | 38013 | 196 | 1 |
864032 | 864032 | 2020-12-25 | Burke | North Dakota | 38013 | 196 | 1 |
860787 | 860787 | 2020-12-24 | Burke | North Dakota | 38013 | 195 | 1 |
857542 | 857542 | 2020-12-23 | Burke | North Dakota | 38013 | 195 | 1 |
854297 | 854297 | 2020-12-22 | Burke | North Dakota | 38013 | 194 | 1 |
851052 | 851052 | 2020-12-21 | Burke | North Dakota | 38013 | 192 | 1 |
847807 | 847807 | 2020-12-20 | Burke | North Dakota | 38013 | 192 | 1 |
844562 | 844562 | 2020-12-19 | Burke | North Dakota | 38013 | 192 | 1 |
841316 | 841316 | 2020-12-18 | Burke | North Dakota | 38013 | 192 | 1 |
838071 | 838071 | 2020-12-17 | Burke | North Dakota | 38013 | 192 | 1 |
834825 | 834825 | 2020-12-16 | Burke | North Dakota | 38013 | 192 | 1 |
831579 | 831579 | 2020-12-15 | Burke | North Dakota | 38013 | 193 | 1 |
828332 | 828332 | 2020-12-14 | Burke | North Dakota | 38013 | 192 | 1 |
825086 | 825086 | 2020-12-13 | Burke | North Dakota | 38013 | 192 | 1 |
821839 | 821839 | 2020-12-12 | Burke | North Dakota | 38013 | 192 | 1 |
818593 | 818593 | 2020-12-11 | Burke | North Dakota | 38013 | 192 | 1 |
815347 | 815347 | 2020-12-10 | Burke | North Dakota | 38013 | 191 | 1 |
812102 | 812102 | 2020-12-09 | Burke | North Dakota | 38013 | 190 | 1 |
808857 | 808857 | 2020-12-08 | Burke | North Dakota | 38013 | 185 | 1 |
805612 | 805612 | 2020-12-07 | Burke | North Dakota | 38013 | 185 | 1 |
802367 | 802367 | 2020-12-06 | Burke | North Dakota | 38013 | 184 | 1 |
799122 | 799122 | 2020-12-05 | Burke | North Dakota | 38013 | 182 | 1 |
795877 | 795877 | 2020-12-04 | Burke | North Dakota | 38013 | 182 | 1 |
792632 | 792632 | 2020-12-03 | Burke | North Dakota | 38013 | 181 | 1 |
789387 | 789387 | 2020-12-02 | Burke | North Dakota | 38013 | 179 | 1 |
786142 | 786142 | 2020-12-01 | Burke | North Dakota | 38013 | 179 | 1 |
782898 | 782898 | 2020-11-30 | Burke | North Dakota | 38013 | 179 | 1 |
779652 | 779652 | 2020-11-29 | Burke | North Dakota | 38013 | 179 | 1 |
776407 | 776407 | 2020-11-28 | Burke | North Dakota | 38013 | 177 | 1 |
773162 | 773162 | 2020-11-27 | Burke | North Dakota | 38013 | 175 | 1 |
769917 | 769917 | 2020-11-26 | Burke | North Dakota | 38013 | 175 | 1 |
766671 | 766671 | 2020-11-25 | Burke | North Dakota | 38013 | 168 | 1 |
763426 | 763426 | 2020-11-24 | Burke | North Dakota | 38013 | 169 | 1 |
760181 | 760181 | 2020-11-23 | Burke | North Dakota | 38013 | 166 | 1 |
756935 | 756935 | 2020-11-22 | Burke | North Dakota | 38013 | 165 | 1 |
753688 | 753688 | 2020-11-21 | Burke | North Dakota | 38013 | 164 | 1 |
750442 | 750442 | 2020-11-20 | Burke | North Dakota | 38013 | 161 | 1 |
747196 | 747196 | 2020-11-19 | Burke | North Dakota | 38013 | 154 | 1 |
743950 | 743950 | 2020-11-18 | Burke | North Dakota | 38013 | 154 | 1 |
740703 | 740703 | 2020-11-17 | Burke | North Dakota | 38013 | 152 | 1 |
737458 | 737458 | 2020-11-16 | Burke | North Dakota | 38013 | 146 | 1 |
734214 | 734214 | 2020-11-15 | Burke | North Dakota | 38013 | 146 | 1 |
730968 | 730968 | 2020-11-14 | Burke | North Dakota | 38013 | 145 | 1 |
727724 | 727724 | 2020-11-13 | Burke | North Dakota | 38013 | 134 | 1 |
724480 | 724480 | 2020-11-12 | Burke | North Dakota | 38013 | 128 | 1 |
721237 | 721237 | 2020-11-11 | Burke | North Dakota | 38013 | 120 | 1 |
717994 | 717994 | 2020-11-10 | Burke | North Dakota | 38013 | 117 | 1 |
714751 | 714751 | 2020-11-09 | Burke | North Dakota | 38013 | 114 | 1 |
711507 | 711507 | 2020-11-08 | Burke | North Dakota | 38013 | 114 | 1 |
708263 | 708263 | 2020-11-07 | Burke | North Dakota | 38013 | 112 | 1 |
705020 | 705020 | 2020-11-06 | Burke | North Dakota | 38013 | 106 | 1 |
701777 | 701777 | 2020-11-05 | Burke | North Dakota | 38013 | 103 | 1 |
698533 | 698533 | 2020-11-04 | Burke | North Dakota | 38013 | 98 | 1 |
695290 | 695290 | 2020-11-03 | Burke | North Dakota | 38013 | 93 | 1 |
692048 | 692048 | 2020-11-02 | Burke | North Dakota | 38013 | 88 | 1 |
688804 | 688804 | 2020-11-01 | Burke | North Dakota | 38013 | 86 | 1 |
685559 | 685559 | 2020-10-31 | Burke | North Dakota | 38013 | 86 | 1 |
682316 | 682316 | 2020-10-30 | Burke | North Dakota | 38013 | 82 | 1 |
679073 | 679073 | 2020-10-29 | Burke | North Dakota | 38013 | 79 | 1 |
675830 | 675830 | 2020-10-28 | Burke | North Dakota | 38013 | 71 | 1 |
672587 | 672587 | 2020-10-27 | Burke | North Dakota | 38013 | 66 | 1 |
669345 | 669345 | 2020-10-26 | Burke | North Dakota | 38013 | 63 | 1 |
666101 | 666101 | 2020-10-25 | Burke | North Dakota | 38013 | 62 | 1 |
662856 | 662856 | 2020-10-24 | Burke | North Dakota | 38013 | 61 | 1 |
659612 | 659612 | 2020-10-23 | Burke | North Dakota | 38013 | 61 | 1 |
656368 | 656368 | 2020-10-22 | Burke | North Dakota | 38013 | 60 | 1 |
653123 | 653123 | 2020-10-21 | Burke | North Dakota | 38013 | 55 | 1 |
649878 | 649878 | 2020-10-20 | Burke | North Dakota | 38013 | 51 | 1 |
646634 | 646634 | 2020-10-19 | Burke | North Dakota | 38013 | 46 | 1 |
643388 | 643388 | 2020-10-18 | Burke | North Dakota | 38013 | 45 | 1 |
640140 | 640140 | 2020-10-17 | Burke | North Dakota | 38013 | 45 | 1 |
636894 | 636894 | 2020-10-16 | Burke | North Dakota | 38013 | 45 | 1 |
633648 | 633648 | 2020-10-15 | Burke | North Dakota | 38013 | 45 | 1 |
630403 | 630403 | 2020-10-14 | Burke | North Dakota | 38013 | 44 | 1 |
627159 | 627159 | 2020-10-13 | Burke | North Dakota | 38013 | 44 | 1 |
623917 | 623917 | 2020-10-12 | Burke | North Dakota | 38013 | 45 | 1 |
620674 | 620674 | 2020-10-11 | Burke | North Dakota | 38013 | 45 | 1 |
617432 | 617432 | 2020-10-10 | Burke | North Dakota | 38013 | 43 | 1 |
614190 | 614190 | 2020-10-09 | Burke | North Dakota | 38013 | 43 | 1 |
610949 | 610949 | 2020-10-08 | Burke | North Dakota | 38013 | 40 | 1 |
607707 | 607707 | 2020-10-07 | Burke | North Dakota | 38013 | 40 | 1 |
604464 | 604464 | 2020-10-06 | Burke | North Dakota | 38013 | 39 | 1 |
601222 | 601222 | 2020-10-05 | Burke | North Dakota | 38013 | 38 | 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);