ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Grand Forks" 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 |
---|---|---|---|---|---|---|---|
1279565 | 1279565 | 2021-05-02 | Grand Forks | North Dakota | 38035 | 10540 | 77 |
1276318 | 1276318 | 2021-05-01 | Grand Forks | North Dakota | 38035 | 10536 | 77 |
1273071 | 1273071 | 2021-04-30 | Grand Forks | North Dakota | 38035 | 10516 | 77 |
1269824 | 1269824 | 2021-04-29 | Grand Forks | North Dakota | 38035 | 10498 | 77 |
1266577 | 1266577 | 2021-04-28 | Grand Forks | North Dakota | 38035 | 10491 | 77 |
1263330 | 1263330 | 2021-04-27 | Grand Forks | North Dakota | 38035 | 10474 | 77 |
1260083 | 1260083 | 2021-04-26 | Grand Forks | North Dakota | 38035 | 10463 | 77 |
1256836 | 1256836 | 2021-04-25 | Grand Forks | North Dakota | 38035 | 10447 | 77 |
1253589 | 1253589 | 2021-04-24 | Grand Forks | North Dakota | 38035 | 10438 | 77 |
1250342 | 1250342 | 2021-04-23 | Grand Forks | North Dakota | 38035 | 10431 | 77 |
1247095 | 1247095 | 2021-04-22 | Grand Forks | North Dakota | 38035 | 10420 | 77 |
1243848 | 1243848 | 2021-04-21 | Grand Forks | North Dakota | 38035 | 10406 | 77 |
1240601 | 1240601 | 2021-04-20 | Grand Forks | North Dakota | 38035 | 10386 | 77 |
1237354 | 1237354 | 2021-04-19 | Grand Forks | North Dakota | 38035 | 10363 | 77 |
1234107 | 1234107 | 2021-04-18 | Grand Forks | North Dakota | 38035 | 10358 | 77 |
1230859 | 1230859 | 2021-04-17 | Grand Forks | North Dakota | 38035 | 10345 | 77 |
1227611 | 1227611 | 2021-04-16 | Grand Forks | North Dakota | 38035 | 10334 | 77 |
1224363 | 1224363 | 2021-04-15 | Grand Forks | North Dakota | 38035 | 10316 | 77 |
1221116 | 1221116 | 2021-04-14 | Grand Forks | North Dakota | 38035 | 10292 | 77 |
1217868 | 1217868 | 2021-04-13 | Grand Forks | North Dakota | 38035 | 10278 | 77 |
1214620 | 1214620 | 2021-04-12 | Grand Forks | North Dakota | 38035 | 10261 | 77 |
1211373 | 1211373 | 2021-04-11 | Grand Forks | North Dakota | 38035 | 10253 | 77 |
1208124 | 1208124 | 2021-04-10 | Grand Forks | North Dakota | 38035 | 10245 | 77 |
1204876 | 1204876 | 2021-04-09 | Grand Forks | North Dakota | 38035 | 10227 | 77 |
1201628 | 1201628 | 2021-04-08 | Grand Forks | North Dakota | 38035 | 10204 | 77 |
1198379 | 1198379 | 2021-04-07 | Grand Forks | North Dakota | 38035 | 10174 | 77 |
1195130 | 1195130 | 2021-04-06 | Grand Forks | North Dakota | 38035 | 10141 | 77 |
1191882 | 1191882 | 2021-04-05 | Grand Forks | North Dakota | 38035 | 10124 | 76 |
1188633 | 1188633 | 2021-04-04 | Grand Forks | North Dakota | 38035 | 10120 | 76 |
1185386 | 1185386 | 2021-04-03 | Grand Forks | North Dakota | 38035 | 10119 | 76 |
1182139 | 1182139 | 2021-04-02 | Grand Forks | North Dakota | 38035 | 10099 | 76 |
1178892 | 1178892 | 2021-04-01 | Grand Forks | North Dakota | 38035 | 10082 | 76 |
1175645 | 1175645 | 2021-03-31 | Grand Forks | North Dakota | 38035 | 10066 | 76 |
1172398 | 1172398 | 2021-03-30 | Grand Forks | North Dakota | 38035 | 10041 | 76 |
1169151 | 1169151 | 2021-03-29 | Grand Forks | North Dakota | 38035 | 10016 | 76 |
1165903 | 1165903 | 2021-03-28 | Grand Forks | North Dakota | 38035 | 10012 | 76 |
1162655 | 1162655 | 2021-03-27 | Grand Forks | North Dakota | 38035 | 10007 | 76 |
1159406 | 1159406 | 2021-03-26 | Grand Forks | North Dakota | 38035 | 9999 | 76 |
1156159 | 1156159 | 2021-03-25 | Grand Forks | North Dakota | 38035 | 9990 | 76 |
1152912 | 1152912 | 2021-03-24 | Grand Forks | North Dakota | 38035 | 9964 | 76 |
1149665 | 1149665 | 2021-03-23 | Grand Forks | North Dakota | 38035 | 9950 | 76 |
1146418 | 1146418 | 2021-03-22 | Grand Forks | North Dakota | 38035 | 9932 | 76 |
1143171 | 1143171 | 2021-03-21 | Grand Forks | North Dakota | 38035 | 9927 | 76 |
1139924 | 1139924 | 2021-03-20 | Grand Forks | North Dakota | 38035 | 9923 | 76 |
1136678 | 1136678 | 2021-03-19 | Grand Forks | North Dakota | 38035 | 9915 | 76 |
1133432 | 1133432 | 2021-03-18 | Grand Forks | North Dakota | 38035 | 9907 | 76 |
1130184 | 1130184 | 2021-03-17 | Grand Forks | North Dakota | 38035 | 9897 | 76 |
1126937 | 1126937 | 2021-03-16 | Grand Forks | North Dakota | 38035 | 9886 | 76 |
1123691 | 1123691 | 2021-03-15 | Grand Forks | North Dakota | 38035 | 9874 | 76 |
1120445 | 1120445 | 2021-03-14 | Grand Forks | North Dakota | 38035 | 9872 | 76 |
1117198 | 1117198 | 2021-03-13 | Grand Forks | North Dakota | 38035 | 9871 | 76 |
1113951 | 1113951 | 2021-03-12 | Grand Forks | North Dakota | 38035 | 9860 | 76 |
1110705 | 1110705 | 2021-03-11 | Grand Forks | North Dakota | 38035 | 9852 | 76 |
1107459 | 1107459 | 2021-03-10 | Grand Forks | North Dakota | 38035 | 9844 | 76 |
1104213 | 1104213 | 2021-03-09 | Grand Forks | North Dakota | 38035 | 9842 | 76 |
1100967 | 1100967 | 2021-03-08 | Grand Forks | North Dakota | 38035 | 9838 | 76 |
1097721 | 1097721 | 2021-03-07 | Grand Forks | North Dakota | 38035 | 9836 | 76 |
1094473 | 1094473 | 2021-03-06 | Grand Forks | North Dakota | 38035 | 9831 | 76 |
1091227 | 1091227 | 2021-03-05 | Grand Forks | North Dakota | 38035 | 9830 | 76 |
1087982 | 1087982 | 2021-03-04 | Grand Forks | North Dakota | 38035 | 9824 | 76 |
1084737 | 1084737 | 2021-03-03 | Grand Forks | North Dakota | 38035 | 9819 | 76 |
1081491 | 1081491 | 2021-03-02 | Grand Forks | North Dakota | 38035 | 9814 | 76 |
1078245 | 1078245 | 2021-03-01 | Grand Forks | North Dakota | 38035 | 9808 | 75 |
1075000 | 1075000 | 2021-02-28 | Grand Forks | North Dakota | 38035 | 9807 | 75 |
1071754 | 1071754 | 2021-02-27 | Grand Forks | North Dakota | 38035 | 9807 | 75 |
1068508 | 1068508 | 2021-02-26 | Grand Forks | North Dakota | 38035 | 9801 | 75 |
1065263 | 1065263 | 2021-02-25 | Grand Forks | North Dakota | 38035 | 9789 | 75 |
1062019 | 1062019 | 2021-02-24 | Grand Forks | North Dakota | 38035 | 9781 | 75 |
1058773 | 1058773 | 2021-02-23 | Grand Forks | North Dakota | 38035 | 9773 | 75 |
1055527 | 1055527 | 2021-02-22 | Grand Forks | North Dakota | 38035 | 9772 | 75 |
1052281 | 1052281 | 2021-02-21 | Grand Forks | North Dakota | 38035 | 9769 | 75 |
1049034 | 1049034 | 2021-02-20 | Grand Forks | North Dakota | 38035 | 9764 | 74 |
1045787 | 1045787 | 2021-02-19 | Grand Forks | North Dakota | 38035 | 9756 | 74 |
1042542 | 1042542 | 2021-02-18 | Grand Forks | North Dakota | 38035 | 9749 | 74 |
1039297 | 1039297 | 2021-02-17 | Grand Forks | North Dakota | 38035 | 9742 | 73 |
1036052 | 1036052 | 2021-02-16 | Grand Forks | North Dakota | 38035 | 9728 | 73 |
1032807 | 1032807 | 2021-02-15 | Grand Forks | North Dakota | 38035 | 9708 | 73 |
1029561 | 1029561 | 2021-02-14 | Grand Forks | North Dakota | 38035 | 9704 | 73 |
1026314 | 1026314 | 2021-02-13 | Grand Forks | North Dakota | 38035 | 9701 | 73 |
1023069 | 1023069 | 2021-02-12 | Grand Forks | North Dakota | 38035 | 9695 | 73 |
1019824 | 1019824 | 2021-02-11 | Grand Forks | North Dakota | 38035 | 9680 | 73 |
1016579 | 1016579 | 2021-02-10 | Grand Forks | North Dakota | 38035 | 9667 | 73 |
1013334 | 1013334 | 2021-02-09 | Grand Forks | North Dakota | 38035 | 9683 | 73 |
1010089 | 1010089 | 2021-02-08 | Grand Forks | North Dakota | 38035 | 9677 | 73 |
1006843 | 1006843 | 2021-02-07 | Grand Forks | North Dakota | 38035 | 9677 | 73 |
1003597 | 1003597 | 2021-02-06 | Grand Forks | North Dakota | 38035 | 9675 | 73 |
1000351 | 1000351 | 2021-02-05 | Grand Forks | North Dakota | 38035 | 9684 | 73 |
997105 | 997105 | 2021-02-04 | Grand Forks | North Dakota | 38035 | 9676 | 72 |
993859 | 993859 | 2021-02-03 | Grand Forks | North Dakota | 38035 | 9673 | 72 |
990613 | 990613 | 2021-02-02 | Grand Forks | North Dakota | 38035 | 9664 | 72 |
987367 | 987367 | 2021-02-01 | Grand Forks | North Dakota | 38035 | 9656 | 72 |
984120 | 984120 | 2021-01-31 | Grand Forks | North Dakota | 38035 | 9654 | 72 |
980873 | 980873 | 2021-01-30 | Grand Forks | North Dakota | 38035 | 9647 | 72 |
977627 | 977627 | 2021-01-29 | Grand Forks | North Dakota | 38035 | 9635 | 72 |
974382 | 974382 | 2021-01-28 | Grand Forks | North Dakota | 38035 | 9624 | 72 |
971137 | 971137 | 2021-01-27 | Grand Forks | North Dakota | 38035 | 9603 | 72 |
967892 | 967892 | 2021-01-26 | Grand Forks | North Dakota | 38035 | 9600 | 72 |
964648 | 964648 | 2021-01-25 | Grand Forks | North Dakota | 38035 | 9587 | 72 |
961403 | 961403 | 2021-01-24 | Grand Forks | North Dakota | 38035 | 9578 | 72 |
958158 | 958158 | 2021-01-23 | Grand Forks | North Dakota | 38035 | 9567 | 72 |
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);