ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 38059 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 |
---|---|---|---|---|---|---|---|
1195142 | 1195142 | 2021-04-06 | Morton | North Dakota | 38059 | 5043 | 98 |
1191894 | 1191894 | 2021-04-05 | Morton | North Dakota | 38059 | 5039 | 98 |
1188645 | 1188645 | 2021-04-04 | Morton | North Dakota | 38059 | 5037 | 98 |
1185398 | 1185398 | 2021-04-03 | Morton | North Dakota | 38059 | 5036 | 98 |
1182151 | 1182151 | 2021-04-02 | Morton | North Dakota | 38059 | 5025 | 98 |
1178904 | 1178904 | 2021-04-01 | Morton | North Dakota | 38059 | 5019 | 98 |
1175657 | 1175657 | 2021-03-31 | Morton | North Dakota | 38059 | 5011 | 98 |
1172410 | 1172410 | 2021-03-30 | Morton | North Dakota | 38059 | 5009 | 98 |
1169163 | 1169163 | 2021-03-29 | Morton | North Dakota | 38059 | 5005 | 98 |
1165915 | 1165915 | 2021-03-28 | Morton | North Dakota | 38059 | 5002 | 98 |
1162667 | 1162667 | 2021-03-27 | Morton | North Dakota | 38059 | 4999 | 98 |
1159418 | 1159418 | 2021-03-26 | Morton | North Dakota | 38059 | 4992 | 98 |
1156171 | 1156171 | 2021-03-25 | Morton | North Dakota | 38059 | 4989 | 98 |
1152924 | 1152924 | 2021-03-24 | Morton | North Dakota | 38059 | 4986 | 98 |
1149677 | 1149677 | 2021-03-23 | Morton | North Dakota | 38059 | 4979 | 98 |
1146430 | 1146430 | 2021-03-22 | Morton | North Dakota | 38059 | 4979 | 97 |
1143183 | 1143183 | 2021-03-21 | Morton | North Dakota | 38059 | 4976 | 97 |
1139936 | 1139936 | 2021-03-20 | Morton | North Dakota | 38059 | 4976 | 97 |
1136690 | 1136690 | 2021-03-19 | Morton | North Dakota | 38059 | 4975 | 97 |
1133444 | 1133444 | 2021-03-18 | Morton | North Dakota | 38059 | 4974 | 97 |
1130196 | 1130196 | 2021-03-17 | Morton | North Dakota | 38059 | 4972 | 97 |
1126949 | 1126949 | 2021-03-16 | Morton | North Dakota | 38059 | 4969 | 97 |
1123703 | 1123703 | 2021-03-15 | Morton | North Dakota | 38059 | 4964 | 97 |
1120457 | 1120457 | 2021-03-14 | Morton | North Dakota | 38059 | 4962 | 97 |
1117210 | 1117210 | 2021-03-13 | Morton | North Dakota | 38059 | 4961 | 97 |
1113963 | 1113963 | 2021-03-12 | Morton | North Dakota | 38059 | 4961 | 97 |
1110717 | 1110717 | 2021-03-11 | Morton | North Dakota | 38059 | 4953 | 96 |
1107471 | 1107471 | 2021-03-10 | Morton | North Dakota | 38059 | 4951 | 96 |
1104225 | 1104225 | 2021-03-09 | Morton | North Dakota | 38059 | 4949 | 95 |
1100979 | 1100979 | 2021-03-08 | Morton | North Dakota | 38059 | 4949 | 95 |
1097733 | 1097733 | 2021-03-07 | Morton | North Dakota | 38059 | 4948 | 95 |
1094485 | 1094485 | 2021-03-06 | Morton | North Dakota | 38059 | 4947 | 95 |
1091239 | 1091239 | 2021-03-05 | Morton | North Dakota | 38059 | 4949 | 94 |
1087994 | 1087994 | 2021-03-04 | Morton | North Dakota | 38059 | 4948 | 94 |
1084749 | 1084749 | 2021-03-03 | Morton | North Dakota | 38059 | 4945 | 94 |
1081503 | 1081503 | 2021-03-02 | Morton | North Dakota | 38059 | 4942 | 94 |
1078257 | 1078257 | 2021-03-01 | Morton | North Dakota | 38059 | 4941 | 94 |
1075012 | 1075012 | 2021-02-28 | Morton | North Dakota | 38059 | 4941 | 94 |
1071766 | 1071766 | 2021-02-27 | Morton | North Dakota | 38059 | 4939 | 94 |
1068520 | 1068520 | 2021-02-26 | Morton | North Dakota | 38059 | 4936 | 94 |
1065275 | 1065275 | 2021-02-25 | Morton | North Dakota | 38059 | 4934 | 94 |
1062031 | 1062031 | 2021-02-24 | Morton | North Dakota | 38059 | 4932 | 94 |
1058785 | 1058785 | 2021-02-23 | Morton | North Dakota | 38059 | 4930 | 94 |
1055539 | 1055539 | 2021-02-22 | Morton | North Dakota | 38059 | 4924 | 94 |
1052293 | 1052293 | 2021-02-21 | Morton | North Dakota | 38059 | 4923 | 94 |
1049046 | 1049046 | 2021-02-20 | Morton | North Dakota | 38059 | 4920 | 94 |
1045799 | 1045799 | 2021-02-19 | Morton | North Dakota | 38059 | 4916 | 94 |
1042554 | 1042554 | 2021-02-18 | Morton | North Dakota | 38059 | 4913 | 94 |
1039309 | 1039309 | 2021-02-17 | Morton | North Dakota | 38059 | 4907 | 94 |
1036064 | 1036064 | 2021-02-16 | Morton | North Dakota | 38059 | 4904 | 94 |
1032819 | 1032819 | 2021-02-15 | Morton | North Dakota | 38059 | 4890 | 94 |
1029573 | 1029573 | 2021-02-14 | Morton | North Dakota | 38059 | 4889 | 94 |
1026326 | 1026326 | 2021-02-13 | Morton | North Dakota | 38059 | 4885 | 94 |
1023081 | 1023081 | 2021-02-12 | Morton | North Dakota | 38059 | 4885 | 94 |
1019836 | 1019836 | 2021-02-11 | Morton | North Dakota | 38059 | 4879 | 94 |
1016591 | 1016591 | 2021-02-10 | Morton | North Dakota | 38059 | 4873 | 94 |
1013346 | 1013346 | 2021-02-09 | Morton | North Dakota | 38059 | 4877 | 93 |
1010101 | 1010101 | 2021-02-08 | Morton | North Dakota | 38059 | 4884 | 93 |
1006855 | 1006855 | 2021-02-07 | Morton | North Dakota | 38059 | 4883 | 93 |
1003609 | 1003609 | 2021-02-06 | Morton | North Dakota | 38059 | 4880 | 93 |
1000363 | 1000363 | 2021-02-05 | Morton | North Dakota | 38059 | 4875 | 93 |
997117 | 997117 | 2021-02-04 | Morton | North Dakota | 38059 | 4865 | 93 |
993871 | 993871 | 2021-02-03 | Morton | North Dakota | 38059 | 4859 | 93 |
990625 | 990625 | 2021-02-02 | Morton | North Dakota | 38059 | 4851 | 93 |
987379 | 987379 | 2021-02-01 | Morton | North Dakota | 38059 | 4848 | 93 |
984132 | 984132 | 2021-01-31 | Morton | North Dakota | 38059 | 4840 | 93 |
980885 | 980885 | 2021-01-30 | Morton | North Dakota | 38059 | 4839 | 93 |
977639 | 977639 | 2021-01-29 | Morton | North Dakota | 38059 | 4836 | 93 |
974394 | 974394 | 2021-01-28 | Morton | North Dakota | 38059 | 4833 | 93 |
971149 | 971149 | 2021-01-27 | Morton | North Dakota | 38059 | 4827 | 93 |
967904 | 967904 | 2021-01-26 | Morton | North Dakota | 38059 | 4824 | 93 |
964660 | 964660 | 2021-01-25 | Morton | North Dakota | 38059 | 4817 | 93 |
961415 | 961415 | 2021-01-24 | Morton | North Dakota | 38059 | 4815 | 93 |
958170 | 958170 | 2021-01-23 | Morton | North Dakota | 38059 | 4812 | 93 |
954924 | 954924 | 2021-01-22 | Morton | North Dakota | 38059 | 4808 | 93 |
951679 | 951679 | 2021-01-21 | Morton | North Dakota | 38059 | 4796 | 92 |
948434 | 948434 | 2021-01-20 | Morton | North Dakota | 38059 | 4792 | 92 |
945188 | 945188 | 2021-01-19 | Morton | North Dakota | 38059 | 4787 | 92 |
941941 | 941941 | 2021-01-18 | Morton | North Dakota | 38059 | 4785 | 92 |
938696 | 938696 | 2021-01-17 | Morton | North Dakota | 38059 | 4782 | 92 |
935451 | 935451 | 2021-01-16 | Morton | North Dakota | 38059 | 4774 | 92 |
932206 | 932206 | 2021-01-15 | Morton | North Dakota | 38059 | 4773 | 92 |
928961 | 928961 | 2021-01-14 | Morton | North Dakota | 38059 | 4764 | 92 |
925716 | 925716 | 2021-01-13 | Morton | North Dakota | 38059 | 4753 | 92 |
922470 | 922470 | 2021-01-12 | Morton | North Dakota | 38059 | 4739 | 92 |
919225 | 919225 | 2021-01-11 | Morton | North Dakota | 38059 | 4727 | 92 |
915980 | 915980 | 2021-01-10 | Morton | North Dakota | 38059 | 4724 | 92 |
912735 | 912735 | 2021-01-09 | Morton | North Dakota | 38059 | 4715 | 92 |
909490 | 909490 | 2021-01-08 | Morton | North Dakota | 38059 | 4712 | 92 |
906245 | 906245 | 2021-01-07 | Morton | North Dakota | 38059 | 4696 | 91 |
902999 | 902999 | 2021-01-06 | Morton | North Dakota | 38059 | 4693 | 91 |
899754 | 899754 | 2021-01-05 | Morton | North Dakota | 38059 | 4673 | 90 |
896509 | 896509 | 2021-01-04 | Morton | North Dakota | 38059 | 4666 | 90 |
893263 | 893263 | 2021-01-03 | Morton | North Dakota | 38059 | 4654 | 90 |
890017 | 890017 | 2021-01-02 | Morton | North Dakota | 38059 | 4648 | 90 |
886770 | 886770 | 2021-01-01 | Morton | North Dakota | 38059 | 4638 | 90 |
883525 | 883525 | 2020-12-31 | Morton | North Dakota | 38059 | 4629 | 88 |
880280 | 880280 | 2020-12-30 | Morton | North Dakota | 38059 | 4620 | 87 |
877035 | 877035 | 2020-12-29 | Morton | North Dakota | 38059 | 4606 | 87 |
873790 | 873790 | 2020-12-28 | Morton | North Dakota | 38059 | 4599 | 87 |
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);