ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Mesa" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277827 | 1277827 | 2021-05-02 | Mesa | Colorado | 8077 | 14455 | 212 |
1274580 | 1274580 | 2021-05-01 | Mesa | Colorado | 8077 | 14422 | 212 |
1271333 | 1271333 | 2021-04-30 | Mesa | Colorado | 8077 | 14335 | 212 |
1268086 | 1268086 | 2021-04-29 | Mesa | Colorado | 8077 | 14303 | 212 |
1264839 | 1264839 | 2021-04-28 | Mesa | Colorado | 8077 | 14244 | 210 |
1261592 | 1261592 | 2021-04-27 | Mesa | Colorado | 8077 | 14228 | 210 |
1258345 | 1258345 | 2021-04-26 | Mesa | Colorado | 8077 | 14178 | 210 |
1255098 | 1255098 | 2021-04-25 | Mesa | Colorado | 8077 | 14178 | 210 |
1251851 | 1251851 | 2021-04-24 | Mesa | Colorado | 8077 | 14163 | 210 |
1248604 | 1248604 | 2021-04-23 | Mesa | Colorado | 8077 | 14124 | 210 |
1245357 | 1245357 | 2021-04-22 | Mesa | Colorado | 8077 | 14083 | 210 |
1242110 | 1242110 | 2021-04-21 | Mesa | Colorado | 8077 | 14057 | 210 |
1238863 | 1238863 | 2021-04-20 | Mesa | Colorado | 8077 | 14017 | 210 |
1235616 | 1235616 | 2021-04-19 | Mesa | Colorado | 8077 | 13986 | 209 |
1232369 | 1232369 | 2021-04-18 | Mesa | Colorado | 8077 | 13983 | 209 |
1229120 | 1229120 | 2021-04-17 | Mesa | Colorado | 8077 | 13972 | 209 |
1225872 | 1225872 | 2021-04-16 | Mesa | Colorado | 8077 | 13941 | 209 |
1222625 | 1222625 | 2021-04-15 | Mesa | Colorado | 8077 | 13910 | 209 |
1219377 | 1219377 | 2021-04-14 | Mesa | Colorado | 8077 | 13894 | 209 |
1216129 | 1216129 | 2021-04-13 | Mesa | Colorado | 8077 | 13874 | 209 |
1212882 | 1212882 | 2021-04-12 | Mesa | Colorado | 8077 | 13851 | 209 |
1209634 | 1209634 | 2021-04-11 | Mesa | Colorado | 8077 | 13841 | 209 |
1206385 | 1206385 | 2021-04-10 | Mesa | Colorado | 8077 | 13835 | 209 |
1203137 | 1203137 | 2021-04-09 | Mesa | Colorado | 8077 | 13818 | 209 |
1199889 | 1199889 | 2021-04-08 | Mesa | Colorado | 8077 | 13802 | 210 |
1196640 | 1196640 | 2021-04-07 | Mesa | Colorado | 8077 | 13772 | 209 |
1193392 | 1193392 | 2021-04-06 | Mesa | Colorado | 8077 | 13772 | 209 |
1190142 | 1190142 | 2021-04-05 | Mesa | Colorado | 8077 | 13765 | 209 |
1186895 | 1186895 | 2021-04-04 | Mesa | Colorado | 8077 | 13763 | 209 |
1183648 | 1183648 | 2021-04-03 | Mesa | Colorado | 8077 | 13755 | 209 |
1180401 | 1180401 | 2021-04-02 | Mesa | Colorado | 8077 | 13731 | 209 |
1177154 | 1177154 | 2021-04-01 | Mesa | Colorado | 8077 | 13724 | 209 |
1173907 | 1173907 | 2021-03-31 | Mesa | Colorado | 8077 | 13712 | 209 |
1170660 | 1170660 | 2021-03-30 | Mesa | Colorado | 8077 | 13701 | 209 |
1167412 | 1167412 | 2021-03-29 | Mesa | Colorado | 8077 | 13688 | 209 |
1164164 | 1164164 | 2021-03-28 | Mesa | Colorado | 8077 | 13682 | 209 |
1160916 | 1160916 | 2021-03-27 | Mesa | Colorado | 8077 | 13679 | 209 |
1157668 | 1157668 | 2021-03-26 | Mesa | Colorado | 8077 | 13659 | 209 |
1154421 | 1154421 | 2021-03-25 | Mesa | Colorado | 8077 | 13648 | 209 |
1151174 | 1151174 | 2021-03-24 | Mesa | Colorado | 8077 | 13646 | 209 |
1147927 | 1147927 | 2021-03-23 | Mesa | Colorado | 8077 | 13634 | 208 |
1144680 | 1144680 | 2021-03-22 | Mesa | Colorado | 8077 | 13626 | 208 |
1141433 | 1141433 | 2021-03-21 | Mesa | Colorado | 8077 | 13623 | 208 |
1138187 | 1138187 | 2021-03-20 | Mesa | Colorado | 8077 | 13618 | 208 |
1134941 | 1134941 | 2021-03-19 | Mesa | Colorado | 8077 | 13601 | 208 |
1131694 | 1131694 | 2021-03-18 | Mesa | Colorado | 8077 | 13578 | 208 |
1128446 | 1128446 | 2021-03-17 | Mesa | Colorado | 8077 | 13569 | 208 |
1125200 | 1125200 | 2021-03-16 | Mesa | Colorado | 8077 | 13561 | 206 |
1121954 | 1121954 | 2021-03-15 | Mesa | Colorado | 8077 | 13555 | 205 |
1118707 | 1118707 | 2021-03-14 | Mesa | Colorado | 8077 | 13552 | 205 |
1115460 | 1115460 | 2021-03-13 | Mesa | Colorado | 8077 | 13543 | 205 |
1112214 | 1112214 | 2021-03-12 | Mesa | Colorado | 8077 | 13539 | 203 |
1108968 | 1108968 | 2021-03-11 | Mesa | Colorado | 8077 | 13520 | 204 |
1105722 | 1105722 | 2021-03-10 | Mesa | Colorado | 8077 | 13509 | 201 |
1102476 | 1102476 | 2021-03-09 | Mesa | Colorado | 8077 | 13496 | 201 |
1099230 | 1099230 | 2021-03-08 | Mesa | Colorado | 8077 | 13487 | 201 |
1095982 | 1095982 | 2021-03-07 | Mesa | Colorado | 8077 | 13467 | 201 |
1092736 | 1092736 | 2021-03-06 | Mesa | Colorado | 8077 | 13467 | 201 |
1089490 | 1089490 | 2021-03-05 | Mesa | Colorado | 8077 | 13443 | 200 |
1086245 | 1086245 | 2021-03-04 | Mesa | Colorado | 8077 | 13416 | 200 |
1082999 | 1082999 | 2021-03-03 | Mesa | Colorado | 8077 | 13392 | 200 |
1079753 | 1079753 | 2021-03-02 | Mesa | Colorado | 8077 | 13368 | 199 |
1076508 | 1076508 | 2021-03-01 | Mesa | Colorado | 8077 | 13355 | 199 |
1073262 | 1073262 | 2021-02-28 | Mesa | Colorado | 8077 | 13299 | 199 |
1070016 | 1070016 | 2021-02-27 | Mesa | Colorado | 8077 | 13269 | 199 |
1066771 | 1066771 | 2021-02-26 | Mesa | Colorado | 8077 | 13179 | 197 |
1063526 | 1063526 | 2021-02-25 | Mesa | Colorado | 8077 | 13179 | 197 |
1060281 | 1060281 | 2021-02-24 | Mesa | Colorado | 8077 | 13145 | 195 |
1057035 | 1057035 | 2021-02-23 | Mesa | Colorado | 8077 | 13115 | 194 |
1053789 | 1053789 | 2021-02-22 | Mesa | Colorado | 8077 | 13097 | 190 |
1050542 | 1050542 | 2021-02-21 | Mesa | Colorado | 8077 | 13072 | 190 |
1047295 | 1047295 | 2021-02-20 | Mesa | Colorado | 8077 | 13062 | 190 |
1044050 | 1044050 | 2021-02-19 | Mesa | Colorado | 8077 | 13038 | 191 |
1040805 | 1040805 | 2021-02-18 | Mesa | Colorado | 8077 | 12985 | 191 |
1037560 | 1037560 | 2021-02-17 | Mesa | Colorado | 8077 | 12967 | 187 |
1034315 | 1034315 | 2021-02-16 | Mesa | Colorado | 8077 | 12913 | 186 |
1031069 | 1031069 | 2021-02-15 | Mesa | Colorado | 8077 | 12905 | 186 |
1027822 | 1027822 | 2021-02-14 | Mesa | Colorado | 8077 | 12903 | 185 |
1024577 | 1024577 | 2021-02-13 | Mesa | Colorado | 8077 | 12870 | 184 |
1021332 | 1021332 | 2021-02-12 | Mesa | Colorado | 8077 | 12854 | 182 |
1018087 | 1018087 | 2021-02-11 | Mesa | Colorado | 8077 | 12804 | 180 |
1014842 | 1014842 | 2021-02-10 | Mesa | Colorado | 8077 | 12712 | 180 |
1011597 | 1011597 | 2021-02-09 | Mesa | Colorado | 8077 | 12683 | 179 |
1008351 | 1008351 | 2021-02-08 | Mesa | Colorado | 8077 | 12650 | 179 |
1005105 | 1005105 | 2021-02-07 | Mesa | Colorado | 8077 | 12604 | 179 |
1001859 | 1001859 | 2021-02-06 | Mesa | Colorado | 8077 | 12572 | 178 |
998613 | 998613 | 2021-02-05 | Mesa | Colorado | 8077 | 12491 | 177 |
995367 | 995367 | 2021-02-04 | Mesa | Colorado | 8077 | 12401 | 174 |
992121 | 992121 | 2021-02-03 | Mesa | Colorado | 8077 | 12302 | 174 |
988875 | 988875 | 2021-02-02 | Mesa | Colorado | 8077 | 12254 | 173 |
985628 | 985628 | 2021-02-01 | Mesa | Colorado | 8077 | 12162 | 173 |
982381 | 982381 | 2021-01-31 | Mesa | Colorado | 8077 | 11950 | 169 |
979135 | 979135 | 2021-01-30 | Mesa | Colorado | 8077 | 11950 | 169 |
975890 | 975890 | 2021-01-29 | Mesa | Colorado | 8077 | 11950 | 169 |
972645 | 972645 | 2021-01-28 | Mesa | Colorado | 8077 | 11822 | 168 |
969400 | 969400 | 2021-01-27 | Mesa | Colorado | 8077 | 11750 | 165 |
966156 | 966156 | 2021-01-26 | Mesa | Colorado | 8077 | 11681 | 163 |
962911 | 962911 | 2021-01-25 | Mesa | Colorado | 8077 | 11539 | 161 |
959666 | 959666 | 2021-01-24 | Mesa | Colorado | 8077 | 11539 | 161 |
956420 | 956420 | 2021-01-23 | Mesa | Colorado | 8077 | 11485 | 161 |
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);