ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Mohave" and state = "Arizona" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1413987 | 1413987 | 2021-06-13 | Mohave | Arizona | 4015 | 23308 | 744 |
1410742 | 1410742 | 2021-06-12 | Mohave | Arizona | 4015 | 23300 | 744 |
1407497 | 1407497 | 2021-06-11 | Mohave | Arizona | 4015 | 23276 | 743 |
1404251 | 1404251 | 2021-06-10 | Mohave | Arizona | 4015 | 23245 | 743 |
1401006 | 1401006 | 2021-06-09 | Mohave | Arizona | 4015 | 23220 | 741 |
1397761 | 1397761 | 2021-06-08 | Mohave | Arizona | 4015 | 23195 | 741 |
1394514 | 1394514 | 2021-06-07 | Mohave | Arizona | 4015 | 23179 | 740 |
1391269 | 1391269 | 2021-06-06 | Mohave | Arizona | 4015 | 23159 | 740 |
1388024 | 1388024 | 2021-06-05 | Mohave | Arizona | 4015 | 23145 | 740 |
1384779 | 1384779 | 2021-06-04 | Mohave | Arizona | 4015 | 23137 | 739 |
1381533 | 1381533 | 2021-06-03 | Mohave | Arizona | 4015 | 23112 | 738 |
1378288 | 1378288 | 2021-06-02 | Mohave | Arizona | 4015 | 23099 | 738 |
1375042 | 1375042 | 2021-06-01 | Mohave | Arizona | 4015 | 23077 | 735 |
1371797 | 1371797 | 2021-05-31 | Mohave | Arizona | 4015 | 23077 | 735 |
1368551 | 1368551 | 2021-05-30 | Mohave | Arizona | 4015 | 23062 | 735 |
1365305 | 1365305 | 2021-05-29 | Mohave | Arizona | 4015 | 23068 | 736 |
1362059 | 1362059 | 2021-05-28 | Mohave | Arizona | 4015 | 23052 | 735 |
1358813 | 1358813 | 2021-05-27 | Mohave | Arizona | 4015 | 23045 | 734 |
1355567 | 1355567 | 2021-05-26 | Mohave | Arizona | 4015 | 23007 | 733 |
1352321 | 1352321 | 2021-05-25 | Mohave | Arizona | 4015 | 22984 | 732 |
1349075 | 1349075 | 2021-05-24 | Mohave | Arizona | 4015 | 22963 | 727 |
1345827 | 1345827 | 2021-05-23 | Mohave | Arizona | 4015 | 22937 | 727 |
1342579 | 1342579 | 2021-05-22 | Mohave | Arizona | 4015 | 22935 | 727 |
1339331 | 1339331 | 2021-05-21 | Mohave | Arizona | 4015 | 22927 | 725 |
1336084 | 1336084 | 2021-05-20 | Mohave | Arizona | 4015 | 22911 | 725 |
1332837 | 1332837 | 2021-05-19 | Mohave | Arizona | 4015 | 22898 | 725 |
1329590 | 1329590 | 2021-05-18 | Mohave | Arizona | 4015 | 22887 | 725 |
1326344 | 1326344 | 2021-05-17 | Mohave | Arizona | 4015 | 22874 | 724 |
1323098 | 1323098 | 2021-05-16 | Mohave | Arizona | 4015 | 22866 | 724 |
1319852 | 1319852 | 2021-05-15 | Mohave | Arizona | 4015 | 22866 | 724 |
1316604 | 1316604 | 2021-05-14 | Mohave | Arizona | 4015 | 22854 | 724 |
1313358 | 1313358 | 2021-05-13 | Mohave | Arizona | 4015 | 22847 | 723 |
1310111 | 1310111 | 2021-05-12 | Mohave | Arizona | 4015 | 22830 | 723 |
1306865 | 1306865 | 2021-05-11 | Mohave | Arizona | 4015 | 22819 | 723 |
1303619 | 1303619 | 2021-05-10 | Mohave | Arizona | 4015 | 22810 | 721 |
1300372 | 1300372 | 2021-05-09 | Mohave | Arizona | 4015 | 22798 | 721 |
1297125 | 1297125 | 2021-05-08 | Mohave | Arizona | 4015 | 22797 | 721 |
1293879 | 1293879 | 2021-05-07 | Mohave | Arizona | 4015 | 22779 | 719 |
1290633 | 1290633 | 2021-05-06 | Mohave | Arizona | 4015 | 22763 | 717 |
1287387 | 1287387 | 2021-05-05 | Mohave | Arizona | 4015 | 22748 | 717 |
1284141 | 1284141 | 2021-05-04 | Mohave | Arizona | 4015 | 22724 | 716 |
1280894 | 1280894 | 2021-05-03 | Mohave | Arizona | 4015 | 22709 | 715 |
1277647 | 1277647 | 2021-05-02 | Mohave | Arizona | 4015 | 22693 | 715 |
1274400 | 1274400 | 2021-05-01 | Mohave | Arizona | 4015 | 22678 | 715 |
1271153 | 1271153 | 2021-04-30 | Mohave | Arizona | 4015 | 22659 | 712 |
1267906 | 1267906 | 2021-04-29 | Mohave | Arizona | 4015 | 22637 | 711 |
1264659 | 1264659 | 2021-04-28 | Mohave | Arizona | 4015 | 22620 | 711 |
1261412 | 1261412 | 2021-04-27 | Mohave | Arizona | 4015 | 22607 | 711 |
1258165 | 1258165 | 2021-04-26 | Mohave | Arizona | 4015 | 22580 | 711 |
1254918 | 1254918 | 2021-04-25 | Mohave | Arizona | 4015 | 22560 | 711 |
1251671 | 1251671 | 2021-04-24 | Mohave | Arizona | 4015 | 22558 | 710 |
1248424 | 1248424 | 2021-04-23 | Mohave | Arizona | 4015 | 22524 | 708 |
1245177 | 1245177 | 2021-04-22 | Mohave | Arizona | 4015 | 22494 | 706 |
1241930 | 1241930 | 2021-04-21 | Mohave | Arizona | 4015 | 22474 | 704 |
1238683 | 1238683 | 2021-04-20 | Mohave | Arizona | 4015 | 22454 | 704 |
1235436 | 1235436 | 2021-04-19 | Mohave | Arizona | 4015 | 22426 | 698 |
1232188 | 1232188 | 2021-04-18 | Mohave | Arizona | 4015 | 22415 | 698 |
1228940 | 1228940 | 2021-04-17 | Mohave | Arizona | 4015 | 22413 | 698 |
1225692 | 1225692 | 2021-04-16 | Mohave | Arizona | 4015 | 22390 | 697 |
1222445 | 1222445 | 2021-04-15 | Mohave | Arizona | 4015 | 22360 | 695 |
1219197 | 1219197 | 2021-04-14 | Mohave | Arizona | 4015 | 22353 | 693 |
1215949 | 1215949 | 2021-04-13 | Mohave | Arizona | 4015 | 22344 | 692 |
1212702 | 1212702 | 2021-04-12 | Mohave | Arizona | 4015 | 22324 | 692 |
1209453 | 1209453 | 2021-04-11 | Mohave | Arizona | 4015 | 22315 | 692 |
1206205 | 1206205 | 2021-04-10 | Mohave | Arizona | 4015 | 22309 | 692 |
1202957 | 1202957 | 2021-04-09 | Mohave | Arizona | 4015 | 22295 | 692 |
1199709 | 1199709 | 2021-04-08 | Mohave | Arizona | 4015 | 22271 | 691 |
1196460 | 1196460 | 2021-04-07 | Mohave | Arizona | 4015 | 22252 | 691 |
1193212 | 1193212 | 2021-04-06 | Mohave | Arizona | 4015 | 22238 | 691 |
1189962 | 1189962 | 2021-04-05 | Mohave | Arizona | 4015 | 22221 | 690 |
1186715 | 1186715 | 2021-04-04 | Mohave | Arizona | 4015 | 22201 | 690 |
1183468 | 1183468 | 2021-04-03 | Mohave | Arizona | 4015 | 22189 | 690 |
1180221 | 1180221 | 2021-04-02 | Mohave | Arizona | 4015 | 22168 | 690 |
1176974 | 1176974 | 2021-04-01 | Mohave | Arizona | 4015 | 22141 | 688 |
1173727 | 1173727 | 2021-03-31 | Mohave | Arizona | 4015 | 22122 | 687 |
1170480 | 1170480 | 2021-03-30 | Mohave | Arizona | 4015 | 22093 | 684 |
1167232 | 1167232 | 2021-03-29 | Mohave | Arizona | 4015 | 22075 | 683 |
1163984 | 1163984 | 2021-03-28 | Mohave | Arizona | 4015 | 22063 | 683 |
1160736 | 1160736 | 2021-03-27 | Mohave | Arizona | 4015 | 22055 | 683 |
1157488 | 1157488 | 2021-03-26 | Mohave | Arizona | 4015 | 22041 | 684 |
1154241 | 1154241 | 2021-03-25 | Mohave | Arizona | 4015 | 22003 | 680 |
1150994 | 1150994 | 2021-03-24 | Mohave | Arizona | 4015 | 21989 | 677 |
1147747 | 1147747 | 2021-03-23 | Mohave | Arizona | 4015 | 21968 | 677 |
1144500 | 1144500 | 2021-03-22 | Mohave | Arizona | 4015 | 21938 | 673 |
1141253 | 1141253 | 2021-03-21 | Mohave | Arizona | 4015 | 21922 | 673 |
1138007 | 1138007 | 2021-03-20 | Mohave | Arizona | 4015 | 21896 | 673 |
1134761 | 1134761 | 2021-03-19 | Mohave | Arizona | 4015 | 21794 | 672 |
1131513 | 1131513 | 2021-03-18 | Mohave | Arizona | 4015 | 21777 | 669 |
1128266 | 1128266 | 2021-03-17 | Mohave | Arizona | 4015 | 21715 | 667 |
1125020 | 1125020 | 2021-03-16 | Mohave | Arizona | 4015 | 21676 | 666 |
1121774 | 1121774 | 2021-03-15 | Mohave | Arizona | 4015 | 21657 | 665 |
1118527 | 1118527 | 2021-03-14 | Mohave | Arizona | 4015 | 21637 | 665 |
1115280 | 1115280 | 2021-03-13 | Mohave | Arizona | 4015 | 21603 | 665 |
1112034 | 1112034 | 2021-03-12 | Mohave | Arizona | 4015 | 21583 | 662 |
1108788 | 1108788 | 2021-03-11 | Mohave | Arizona | 4015 | 21502 | 659 |
1105542 | 1105542 | 2021-03-10 | Mohave | Arizona | 4015 | 21484 | 658 |
1102296 | 1102296 | 2021-03-09 | Mohave | Arizona | 4015 | 21445 | 658 |
1099050 | 1099050 | 2021-03-08 | Mohave | Arizona | 4015 | 21429 | 656 |
1095802 | 1095802 | 2021-03-07 | Mohave | Arizona | 4015 | 21406 | 656 |
1092556 | 1092556 | 2021-03-06 | Mohave | Arizona | 4015 | 21375 | 655 |
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);