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 |
---|---|---|---|---|---|---|---|
1485573 | 1485573 | 2021-07-05 | Mesa | Colorado | 8077 | 17405 | 253 |
1482327 | 1482327 | 2021-07-04 | Mesa | Colorado | 8077 | 17396 | 253 |
1479080 | 1479080 | 2021-07-03 | Mesa | Colorado | 8077 | 17366 | 252 |
1475834 | 1475834 | 2021-07-02 | Mesa | Colorado | 8077 | 17299 | 251 |
1472588 | 1472588 | 2021-07-01 | Mesa | Colorado | 8077 | 17246 | 251 |
1469342 | 1469342 | 2021-06-30 | Mesa | Colorado | 8077 | 17168 | 250 |
1466097 | 1466097 | 2021-06-29 | Mesa | Colorado | 8077 | 17116 | 249 |
1462852 | 1462852 | 2021-06-28 | Mesa | Colorado | 8077 | 17070 | 249 |
1459607 | 1459607 | 2021-06-27 | Mesa | Colorado | 8077 | 17045 | 249 |
1456362 | 1456362 | 2021-06-26 | Mesa | Colorado | 8077 | 17013 | 248 |
1453117 | 1453117 | 2021-06-25 | Mesa | Colorado | 8077 | 16951 | 248 |
1449871 | 1449871 | 2021-06-24 | Mesa | Colorado | 8077 | 16907 | 247 |
1446626 | 1446626 | 2021-06-23 | Mesa | Colorado | 8077 | 16828 | 246 |
1443381 | 1443381 | 2021-06-22 | Mesa | Colorado | 8077 | 16793 | 244 |
1440136 | 1440136 | 2021-06-21 | Mesa | Colorado | 8077 | 16762 | 244 |
1436889 | 1436889 | 2021-06-20 | Mesa | Colorado | 8077 | 16726 | 244 |
1433642 | 1433642 | 2021-06-19 | Mesa | Colorado | 8077 | 16689 | 244 |
1430396 | 1430396 | 2021-06-18 | Mesa | Colorado | 8077 | 16650 | 242 |
1427151 | 1427151 | 2021-06-17 | Mesa | Colorado | 8077 | 16608 | 241 |
1423906 | 1423906 | 2021-06-16 | Mesa | Colorado | 8077 | 16564 | 240 |
1420658 | 1420658 | 2021-06-15 | Mesa | Colorado | 8077 | 16527 | 239 |
1417413 | 1417413 | 2021-06-14 | Mesa | Colorado | 8077 | 16516 | 239 |
1414167 | 1414167 | 2021-06-13 | Mesa | Colorado | 8077 | 16486 | 239 |
1410922 | 1410922 | 2021-06-12 | Mesa | Colorado | 8077 | 16443 | 239 |
1407677 | 1407677 | 2021-06-11 | Mesa | Colorado | 8077 | 16397 | 239 |
1404431 | 1404431 | 2021-06-10 | Mesa | Colorado | 8077 | 16355 | 238 |
1401186 | 1401186 | 2021-06-09 | Mesa | Colorado | 8077 | 16301 | 236 |
1397941 | 1397941 | 2021-06-08 | Mesa | Colorado | 8077 | 16246 | 235 |
1394694 | 1394694 | 2021-06-07 | Mesa | Colorado | 8077 | 16195 | 234 |
1391449 | 1391449 | 2021-06-06 | Mesa | Colorado | 8077 | 16156 | 232 |
1388204 | 1388204 | 2021-06-05 | Mesa | Colorado | 8077 | 16110 | 232 |
1384959 | 1384959 | 2021-06-04 | Mesa | Colorado | 8077 | 16050 | 232 |
1381713 | 1381713 | 2021-06-03 | Mesa | Colorado | 8077 | 15961 | 232 |
1378468 | 1378468 | 2021-06-02 | Mesa | Colorado | 8077 | 15891 | 230 |
1375222 | 1375222 | 2021-06-01 | Mesa | Colorado | 8077 | 15848 | 230 |
1371977 | 1371977 | 2021-05-31 | Mesa | Colorado | 8077 | 15825 | 230 |
1368732 | 1368732 | 2021-05-30 | Mesa | Colorado | 8077 | 15791 | 230 |
1365486 | 1365486 | 2021-05-29 | Mesa | Colorado | 8077 | 15739 | 230 |
1362240 | 1362240 | 2021-05-28 | Mesa | Colorado | 8077 | 15683 | 227 |
1358993 | 1358993 | 2021-05-27 | Mesa | Colorado | 8077 | 15602 | 227 |
1355747 | 1355747 | 2021-05-26 | Mesa | Colorado | 8077 | 15535 | 223 |
1352501 | 1352501 | 2021-05-25 | Mesa | Colorado | 8077 | 15492 | 222 |
1349255 | 1349255 | 2021-05-24 | Mesa | Colorado | 8077 | 15395 | 222 |
1346008 | 1346008 | 2021-05-23 | Mesa | Colorado | 8077 | 15361 | 222 |
1342760 | 1342760 | 2021-05-22 | Mesa | Colorado | 8077 | 15346 | 222 |
1339512 | 1339512 | 2021-05-21 | Mesa | Colorado | 8077 | 15291 | 222 |
1336265 | 1336265 | 2021-05-20 | Mesa | Colorado | 8077 | 15253 | 221 |
1333018 | 1333018 | 2021-05-19 | Mesa | Colorado | 8077 | 15194 | 219 |
1329771 | 1329771 | 2021-05-18 | Mesa | Colorado | 8077 | 15133 | 219 |
1326524 | 1326524 | 2021-05-17 | Mesa | Colorado | 8077 | 15099 | 218 |
1323278 | 1323278 | 2021-05-16 | Mesa | Colorado | 8077 | 15064 | 218 |
1320032 | 1320032 | 2021-05-15 | Mesa | Colorado | 8077 | 15036 | 218 |
1316785 | 1316785 | 2021-05-14 | Mesa | Colorado | 8077 | 14987 | 218 |
1313538 | 1313538 | 2021-05-13 | Mesa | Colorado | 8077 | 14899 | 218 |
1310291 | 1310291 | 2021-05-12 | Mesa | Colorado | 8077 | 14834 | 217 |
1307045 | 1307045 | 2021-05-11 | Mesa | Colorado | 8077 | 14807 | 216 |
1303799 | 1303799 | 2021-05-10 | Mesa | Colorado | 8077 | 14768 | 216 |
1300552 | 1300552 | 2021-05-09 | Mesa | Colorado | 8077 | 14736 | 216 |
1297305 | 1297305 | 2021-05-08 | Mesa | Colorado | 8077 | 14708 | 216 |
1294059 | 1294059 | 2021-05-07 | Mesa | Colorado | 8077 | 14623 | 215 |
1290813 | 1290813 | 2021-05-06 | Mesa | Colorado | 8077 | 14592 | 215 |
1287567 | 1287567 | 2021-05-05 | Mesa | Colorado | 8077 | 14539 | 215 |
1284321 | 1284321 | 2021-05-04 | Mesa | Colorado | 8077 | 14514 | 213 |
1281074 | 1281074 | 2021-05-03 | Mesa | Colorado | 8077 | 14482 | 212 |
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 |
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);