ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Hancock" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1278276 | 1278276 | 2021-05-02 | Hancock | Indiana | 18059 | 8214 | 143 |
1275029 | 1275029 | 2021-05-01 | Hancock | Indiana | 18059 | 8197 | 143 |
1271782 | 1271782 | 2021-04-30 | Hancock | Indiana | 18059 | 8187 | 143 |
1268535 | 1268535 | 2021-04-29 | Hancock | Indiana | 18059 | 8157 | 143 |
1265288 | 1265288 | 2021-04-28 | Hancock | Indiana | 18059 | 8134 | 143 |
1262041 | 1262041 | 2021-04-27 | Hancock | Indiana | 18059 | 8113 | 143 |
1258794 | 1258794 | 2021-04-26 | Hancock | Indiana | 18059 | 8106 | 143 |
1255547 | 1255547 | 2021-04-25 | Hancock | Indiana | 18059 | 8095 | 143 |
1252300 | 1252300 | 2021-04-24 | Hancock | Indiana | 18059 | 8079 | 143 |
1249053 | 1249053 | 2021-04-23 | Hancock | Indiana | 18059 | 8063 | 143 |
1245806 | 1245806 | 2021-04-22 | Hancock | Indiana | 18059 | 8056 | 143 |
1242559 | 1242559 | 2021-04-21 | Hancock | Indiana | 18059 | 8039 | 143 |
1239312 | 1239312 | 2021-04-20 | Hancock | Indiana | 18059 | 8025 | 143 |
1236065 | 1236065 | 2021-04-19 | Hancock | Indiana | 18059 | 8015 | 143 |
1232818 | 1232818 | 2021-04-18 | Hancock | Indiana | 18059 | 8004 | 143 |
1229569 | 1229569 | 2021-04-17 | Hancock | Indiana | 18059 | 7989 | 143 |
1226321 | 1226321 | 2021-04-16 | Hancock | Indiana | 18059 | 7979 | 143 |
1223074 | 1223074 | 2021-04-15 | Hancock | Indiana | 18059 | 7964 | 143 |
1219826 | 1219826 | 2021-04-14 | Hancock | Indiana | 18059 | 7947 | 143 |
1216578 | 1216578 | 2021-04-13 | Hancock | Indiana | 18059 | 7921 | 143 |
1213331 | 1213331 | 2021-04-12 | Hancock | Indiana | 18059 | 7903 | 143 |
1210083 | 1210083 | 2021-04-11 | Hancock | Indiana | 18059 | 7891 | 143 |
1206834 | 1206834 | 2021-04-10 | Hancock | Indiana | 18059 | 7867 | 141 |
1203586 | 1203586 | 2021-04-09 | Hancock | Indiana | 18059 | 7843 | 141 |
1200338 | 1200338 | 2021-04-08 | Hancock | Indiana | 18059 | 7829 | 141 |
1197089 | 1197089 | 2021-04-07 | Hancock | Indiana | 18059 | 7809 | 141 |
1193841 | 1193841 | 2021-04-06 | Hancock | Indiana | 18059 | 7793 | 140 |
1190591 | 1190591 | 2021-04-05 | Hancock | Indiana | 18059 | 7797 | 140 |
1187344 | 1187344 | 2021-04-04 | Hancock | Indiana | 18059 | 7779 | 140 |
1184097 | 1184097 | 2021-04-03 | Hancock | Indiana | 18059 | 7761 | 140 |
1180850 | 1180850 | 2021-04-02 | Hancock | Indiana | 18059 | 7747 | 140 |
1177603 | 1177603 | 2021-04-01 | Hancock | Indiana | 18059 | 7729 | 140 |
1174356 | 1174356 | 2021-03-31 | Hancock | Indiana | 18059 | 7714 | 140 |
1171109 | 1171109 | 2021-03-30 | Hancock | Indiana | 18059 | 7709 | 140 |
1167861 | 1167861 | 2021-03-29 | Hancock | Indiana | 18059 | 7699 | 139 |
1164613 | 1164613 | 2021-03-28 | Hancock | Indiana | 18059 | 7684 | 139 |
1161365 | 1161365 | 2021-03-27 | Hancock | Indiana | 18059 | 7671 | 139 |
1158117 | 1158117 | 2021-03-26 | Hancock | Indiana | 18059 | 7671 | 139 |
1154870 | 1154870 | 2021-03-25 | Hancock | Indiana | 18059 | 7657 | 139 |
1151623 | 1151623 | 2021-03-24 | Hancock | Indiana | 18059 | 7644 | 139 |
1148376 | 1148376 | 2021-03-23 | Hancock | Indiana | 18059 | 7645 | 139 |
1145129 | 1145129 | 2021-03-22 | Hancock | Indiana | 18059 | 7638 | 139 |
1141882 | 1141882 | 2021-03-21 | Hancock | Indiana | 18059 | 7629 | 139 |
1138636 | 1138636 | 2021-03-20 | Hancock | Indiana | 18059 | 7616 | 139 |
1135390 | 1135390 | 2021-03-19 | Hancock | Indiana | 18059 | 7598 | 139 |
1132143 | 1132143 | 2021-03-18 | Hancock | Indiana | 18059 | 7582 | 139 |
1128895 | 1128895 | 2021-03-17 | Hancock | Indiana | 18059 | 7576 | 139 |
1125649 | 1125649 | 2021-03-16 | Hancock | Indiana | 18059 | 7563 | 139 |
1122403 | 1122403 | 2021-03-15 | Hancock | Indiana | 18059 | 7564 | 139 |
1119156 | 1119156 | 2021-03-14 | Hancock | Indiana | 18059 | 7559 | 139 |
1115909 | 1115909 | 2021-03-13 | Hancock | Indiana | 18059 | 7549 | 139 |
1112663 | 1112663 | 2021-03-12 | Hancock | Indiana | 18059 | 7541 | 139 |
1109417 | 1109417 | 2021-03-11 | Hancock | Indiana | 18059 | 7526 | 139 |
1106171 | 1106171 | 2021-03-10 | Hancock | Indiana | 18059 | 7511 | 138 |
1102925 | 1102925 | 2021-03-09 | Hancock | Indiana | 18059 | 7504 | 138 |
1099679 | 1099679 | 2021-03-08 | Hancock | Indiana | 18059 | 7500 | 138 |
1096431 | 1096431 | 2021-03-07 | Hancock | Indiana | 18059 | 7495 | 138 |
1093185 | 1093185 | 2021-03-06 | Hancock | Indiana | 18059 | 7486 | 138 |
1089939 | 1089939 | 2021-03-05 | Hancock | Indiana | 18059 | 7463 | 138 |
1086694 | 1086694 | 2021-03-04 | Hancock | Indiana | 18059 | 7452 | 137 |
1083448 | 1083448 | 2021-03-03 | Hancock | Indiana | 18059 | 7442 | 136 |
1080202 | 1080202 | 2021-03-02 | Hancock | Indiana | 18059 | 7433 | 136 |
1076957 | 1076957 | 2021-03-01 | Hancock | Indiana | 18059 | 7433 | 135 |
1073711 | 1073711 | 2021-02-28 | Hancock | Indiana | 18059 | 7428 | 135 |
1070465 | 1070465 | 2021-02-27 | Hancock | Indiana | 18059 | 7418 | 134 |
1067220 | 1067220 | 2021-02-26 | Hancock | Indiana | 18059 | 7423 | 134 |
1063975 | 1063975 | 2021-02-25 | Hancock | Indiana | 18059 | 7416 | 132 |
1060730 | 1060730 | 2021-02-24 | Hancock | Indiana | 18059 | 7403 | 132 |
1057484 | 1057484 | 2021-02-23 | Hancock | Indiana | 18059 | 7386 | 132 |
1054238 | 1054238 | 2021-02-22 | Hancock | Indiana | 18059 | 7377 | 131 |
1050991 | 1050991 | 2021-02-21 | Hancock | Indiana | 18059 | 7372 | 131 |
1047744 | 1047744 | 2021-02-20 | Hancock | Indiana | 18059 | 7388 | 132 |
1044499 | 1044499 | 2021-02-19 | Hancock | Indiana | 18059 | 7375 | 132 |
1041254 | 1041254 | 2021-02-18 | Hancock | Indiana | 18059 | 7366 | 132 |
1038009 | 1038009 | 2021-02-17 | Hancock | Indiana | 18059 | 7359 | 132 |
1034764 | 1034764 | 2021-02-16 | Hancock | Indiana | 18059 | 7344 | 131 |
1031518 | 1031518 | 2021-02-15 | Hancock | Indiana | 18059 | 7341 | 131 |
1028271 | 1028271 | 2021-02-14 | Hancock | Indiana | 18059 | 7332 | 130 |
1025026 | 1025026 | 2021-02-13 | Hancock | Indiana | 18059 | 7314 | 130 |
1021781 | 1021781 | 2021-02-12 | Hancock | Indiana | 18059 | 7303 | 130 |
1018536 | 1018536 | 2021-02-11 | Hancock | Indiana | 18059 | 7283 | 130 |
1015291 | 1015291 | 2021-02-10 | Hancock | Indiana | 18059 | 7260 | 130 |
1012046 | 1012046 | 2021-02-09 | Hancock | Indiana | 18059 | 7244 | 130 |
1008800 | 1008800 | 2021-02-08 | Hancock | Indiana | 18059 | 7220 | 130 |
1005554 | 1005554 | 2021-02-07 | Hancock | Indiana | 18059 | 7209 | 129 |
1002308 | 1002308 | 2021-02-06 | Hancock | Indiana | 18059 | 7179 | 129 |
999062 | 999062 | 2021-02-05 | Hancock | Indiana | 18059 | 7127 | 127 |
995816 | 995816 | 2021-02-04 | Hancock | Indiana | 18059 | 7107 | 127 |
992570 | 992570 | 2021-02-03 | Hancock | Indiana | 18059 | 7070 | 114 |
989324 | 989324 | 2021-02-02 | Hancock | Indiana | 18059 | 7044 | 113 |
986077 | 986077 | 2021-02-01 | Hancock | Indiana | 18059 | 7018 | 112 |
982830 | 982830 | 2021-01-31 | Hancock | Indiana | 18059 | 6991 | 111 |
979584 | 979584 | 2021-01-30 | Hancock | Indiana | 18059 | 6937 | 111 |
976338 | 976338 | 2021-01-29 | Hancock | Indiana | 18059 | 6912 | 110 |
973093 | 973093 | 2021-01-28 | Hancock | Indiana | 18059 | 6883 | 110 |
969848 | 969848 | 2021-01-27 | Hancock | Indiana | 18059 | 6854 | 109 |
966604 | 966604 | 2021-01-26 | Hancock | Indiana | 18059 | 6805 | 109 |
963359 | 963359 | 2021-01-25 | Hancock | Indiana | 18059 | 6804 | 107 |
960114 | 960114 | 2021-01-24 | Hancock | Indiana | 18059 | 6763 | 107 |
956868 | 956868 | 2021-01-23 | Hancock | Indiana | 18059 | 6719 | 107 |
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);