ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where fips = 38053 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 |
---|---|---|---|---|---|---|---|
1091236 | 1091236 | 2021-03-05 | McKenzie | North Dakota | 38053 | 1166 | 12 |
1087991 | 1087991 | 2021-03-04 | McKenzie | North Dakota | 38053 | 1166 | 12 |
1084746 | 1084746 | 2021-03-03 | McKenzie | North Dakota | 38053 | 1166 | 12 |
1081500 | 1081500 | 2021-03-02 | McKenzie | North Dakota | 38053 | 1163 | 12 |
1078254 | 1078254 | 2021-03-01 | McKenzie | North Dakota | 38053 | 1159 | 12 |
1075009 | 1075009 | 2021-02-28 | McKenzie | North Dakota | 38053 | 1159 | 12 |
1071763 | 1071763 | 2021-02-27 | McKenzie | North Dakota | 38053 | 1159 | 12 |
1068517 | 1068517 | 2021-02-26 | McKenzie | North Dakota | 38053 | 1159 | 11 |
1065272 | 1065272 | 2021-02-25 | McKenzie | North Dakota | 38053 | 1159 | 11 |
1062028 | 1062028 | 2021-02-24 | McKenzie | North Dakota | 38053 | 1159 | 11 |
1058782 | 1058782 | 2021-02-23 | McKenzie | North Dakota | 38053 | 1158 | 11 |
1055536 | 1055536 | 2021-02-22 | McKenzie | North Dakota | 38053 | 1156 | 11 |
1052290 | 1052290 | 2021-02-21 | McKenzie | North Dakota | 38053 | 1155 | 11 |
1049043 | 1049043 | 2021-02-20 | McKenzie | North Dakota | 38053 | 1155 | 11 |
1045796 | 1045796 | 2021-02-19 | McKenzie | North Dakota | 38053 | 1152 | 11 |
1042551 | 1042551 | 2021-02-18 | McKenzie | North Dakota | 38053 | 1150 | 11 |
1039306 | 1039306 | 2021-02-17 | McKenzie | North Dakota | 38053 | 1150 | 11 |
1036061 | 1036061 | 2021-02-16 | McKenzie | North Dakota | 38053 | 1149 | 11 |
1032816 | 1032816 | 2021-02-15 | McKenzie | North Dakota | 38053 | 1146 | 11 |
1029570 | 1029570 | 2021-02-14 | McKenzie | North Dakota | 38053 | 1146 | 11 |
1026323 | 1026323 | 2021-02-13 | McKenzie | North Dakota | 38053 | 1145 | 11 |
1023078 | 1023078 | 2021-02-12 | McKenzie | North Dakota | 38053 | 1144 | 11 |
1019833 | 1019833 | 2021-02-11 | McKenzie | North Dakota | 38053 | 1142 | 11 |
1016588 | 1016588 | 2021-02-10 | McKenzie | North Dakota | 38053 | 1141 | 11 |
1013343 | 1013343 | 2021-02-09 | McKenzie | North Dakota | 38053 | 1142 | 11 |
1010098 | 1010098 | 2021-02-08 | McKenzie | North Dakota | 38053 | 1142 | 11 |
1006852 | 1006852 | 2021-02-07 | McKenzie | North Dakota | 38053 | 1141 | 11 |
1003606 | 1003606 | 2021-02-06 | McKenzie | North Dakota | 38053 | 1141 | 11 |
1000360 | 1000360 | 2021-02-05 | McKenzie | North Dakota | 38053 | 1141 | 11 |
997114 | 997114 | 2021-02-04 | McKenzie | North Dakota | 38053 | 1139 | 11 |
993868 | 993868 | 2021-02-03 | McKenzie | North Dakota | 38053 | 1138 | 11 |
990622 | 990622 | 2021-02-02 | McKenzie | North Dakota | 38053 | 1135 | 11 |
987376 | 987376 | 2021-02-01 | McKenzie | North Dakota | 38053 | 1133 | 11 |
984129 | 984129 | 2021-01-31 | McKenzie | North Dakota | 38053 | 1133 | 11 |
980882 | 980882 | 2021-01-30 | McKenzie | North Dakota | 38053 | 1131 | 11 |
977636 | 977636 | 2021-01-29 | McKenzie | North Dakota | 38053 | 1129 | 11 |
974391 | 974391 | 2021-01-28 | McKenzie | North Dakota | 38053 | 1126 | 11 |
971146 | 971146 | 2021-01-27 | McKenzie | North Dakota | 38053 | 1123 | 11 |
967901 | 967901 | 2021-01-26 | McKenzie | North Dakota | 38053 | 1120 | 11 |
964657 | 964657 | 2021-01-25 | McKenzie | North Dakota | 38053 | 1116 | 11 |
961412 | 961412 | 2021-01-24 | McKenzie | North Dakota | 38053 | 1116 | 11 |
958167 | 958167 | 2021-01-23 | McKenzie | North Dakota | 38053 | 1114 | 11 |
954921 | 954921 | 2021-01-22 | McKenzie | North Dakota | 38053 | 1109 | 11 |
951676 | 951676 | 2021-01-21 | McKenzie | North Dakota | 38053 | 1105 | 11 |
948431 | 948431 | 2021-01-20 | McKenzie | North Dakota | 38053 | 1101 | 11 |
945185 | 945185 | 2021-01-19 | McKenzie | North Dakota | 38053 | 1100 | 11 |
941938 | 941938 | 2021-01-18 | McKenzie | North Dakota | 38053 | 1093 | 11 |
938693 | 938693 | 2021-01-17 | McKenzie | North Dakota | 38053 | 1091 | 11 |
935448 | 935448 | 2021-01-16 | McKenzie | North Dakota | 38053 | 1089 | 11 |
932203 | 932203 | 2021-01-15 | McKenzie | North Dakota | 38053 | 1085 | 11 |
928958 | 928958 | 2021-01-14 | McKenzie | North Dakota | 38053 | 1083 | 11 |
925713 | 925713 | 2021-01-13 | McKenzie | North Dakota | 38053 | 1081 | 11 |
922467 | 922467 | 2021-01-12 | McKenzie | North Dakota | 38053 | 1077 | 11 |
919222 | 919222 | 2021-01-11 | McKenzie | North Dakota | 38053 | 1072 | 11 |
915977 | 915977 | 2021-01-10 | McKenzie | North Dakota | 38053 | 1071 | 11 |
912732 | 912732 | 2021-01-09 | McKenzie | North Dakota | 38053 | 1067 | 11 |
909487 | 909487 | 2021-01-08 | McKenzie | North Dakota | 38053 | 1065 | 11 |
906242 | 906242 | 2021-01-07 | McKenzie | North Dakota | 38053 | 1061 | 11 |
902996 | 902996 | 2021-01-06 | McKenzie | North Dakota | 38053 | 1053 | 11 |
899751 | 899751 | 2021-01-05 | McKenzie | North Dakota | 38053 | 1044 | 11 |
896506 | 896506 | 2021-01-04 | McKenzie | North Dakota | 38053 | 1036 | 11 |
893260 | 893260 | 2021-01-03 | McKenzie | North Dakota | 38053 | 1036 | 11 |
890014 | 890014 | 2021-01-02 | McKenzie | North Dakota | 38053 | 1031 | 11 |
886767 | 886767 | 2021-01-01 | McKenzie | North Dakota | 38053 | 1029 | 11 |
883522 | 883522 | 2020-12-31 | McKenzie | North Dakota | 38053 | 1029 | 11 |
880277 | 880277 | 2020-12-30 | McKenzie | North Dakota | 38053 | 1025 | 10 |
877032 | 877032 | 2020-12-29 | McKenzie | North Dakota | 38053 | 1023 | 10 |
873787 | 873787 | 2020-12-28 | McKenzie | North Dakota | 38053 | 1020 | 10 |
870542 | 870542 | 2020-12-27 | McKenzie | North Dakota | 38053 | 1020 | 10 |
867297 | 867297 | 2020-12-26 | McKenzie | North Dakota | 38053 | 1019 | 10 |
864052 | 864052 | 2020-12-25 | McKenzie | North Dakota | 38053 | 1018 | 10 |
860807 | 860807 | 2020-12-24 | McKenzie | North Dakota | 38053 | 1017 | 10 |
857562 | 857562 | 2020-12-23 | McKenzie | North Dakota | 38053 | 1016 | 10 |
854317 | 854317 | 2020-12-22 | McKenzie | North Dakota | 38053 | 1011 | 10 |
851072 | 851072 | 2020-12-21 | McKenzie | North Dakota | 38053 | 1010 | 10 |
847827 | 847827 | 2020-12-20 | McKenzie | North Dakota | 38053 | 1009 | 10 |
844582 | 844582 | 2020-12-19 | McKenzie | North Dakota | 38053 | 1008 | 10 |
841336 | 841336 | 2020-12-18 | McKenzie | North Dakota | 38053 | 1006 | 10 |
838091 | 838091 | 2020-12-17 | McKenzie | North Dakota | 38053 | 996 | 10 |
834845 | 834845 | 2020-12-16 | McKenzie | North Dakota | 38053 | 987 | 10 |
831599 | 831599 | 2020-12-15 | McKenzie | North Dakota | 38053 | 978 | 10 |
828352 | 828352 | 2020-12-14 | McKenzie | North Dakota | 38053 | 971 | 10 |
825106 | 825106 | 2020-12-13 | McKenzie | North Dakota | 38053 | 970 | 10 |
821859 | 821859 | 2020-12-12 | McKenzie | North Dakota | 38053 | 966 | 10 |
818613 | 818613 | 2020-12-11 | McKenzie | North Dakota | 38053 | 963 | 10 |
815367 | 815367 | 2020-12-10 | McKenzie | North Dakota | 38053 | 959 | 10 |
812122 | 812122 | 2020-12-09 | McKenzie | North Dakota | 38053 | 950 | 9 |
808877 | 808877 | 2020-12-08 | McKenzie | North Dakota | 38053 | 932 | 8 |
805632 | 805632 | 2020-12-07 | McKenzie | North Dakota | 38053 | 932 | 8 |
802387 | 802387 | 2020-12-06 | McKenzie | North Dakota | 38053 | 931 | 7 |
799142 | 799142 | 2020-12-05 | McKenzie | North Dakota | 38053 | 925 | 7 |
795897 | 795897 | 2020-12-04 | McKenzie | North Dakota | 38053 | 920 | 7 |
792652 | 792652 | 2020-12-03 | McKenzie | North Dakota | 38053 | 913 | 7 |
789407 | 789407 | 2020-12-02 | McKenzie | North Dakota | 38053 | 898 | 7 |
786162 | 786162 | 2020-12-01 | McKenzie | North Dakota | 38053 | 891 | 7 |
782918 | 782918 | 2020-11-30 | McKenzie | North Dakota | 38053 | 883 | 7 |
779672 | 779672 | 2020-11-29 | McKenzie | North Dakota | 38053 | 881 | 7 |
776427 | 776427 | 2020-11-28 | McKenzie | North Dakota | 38053 | 878 | 6 |
773182 | 773182 | 2020-11-27 | McKenzie | North Dakota | 38053 | 874 | 6 |
769937 | 769937 | 2020-11-26 | McKenzie | North Dakota | 38053 | 869 | 6 |
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);