ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 18067 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1278280 | 1278280 | 2021-05-02 | Howard | Indiana | 18067 | 9816 | 219 |
1275033 | 1275033 | 2021-05-01 | Howard | Indiana | 18067 | 9804 | 218 |
1271786 | 1271786 | 2021-04-30 | Howard | Indiana | 18067 | 9790 | 218 |
1268539 | 1268539 | 2021-04-29 | Howard | Indiana | 18067 | 9782 | 218 |
1265292 | 1265292 | 2021-04-28 | Howard | Indiana | 18067 | 9766 | 218 |
1262045 | 1262045 | 2021-04-27 | Howard | Indiana | 18067 | 9758 | 217 |
1258798 | 1258798 | 2021-04-26 | Howard | Indiana | 18067 | 9754 | 216 |
1255551 | 1255551 | 2021-04-25 | Howard | Indiana | 18067 | 9751 | 216 |
1252304 | 1252304 | 2021-04-24 | Howard | Indiana | 18067 | 9740 | 215 |
1249057 | 1249057 | 2021-04-23 | Howard | Indiana | 18067 | 9729 | 215 |
1245810 | 1245810 | 2021-04-22 | Howard | Indiana | 18067 | 9722 | 215 |
1242563 | 1242563 | 2021-04-21 | Howard | Indiana | 18067 | 9708 | 215 |
1239316 | 1239316 | 2021-04-20 | Howard | Indiana | 18067 | 9687 | 215 |
1236069 | 1236069 | 2021-04-19 | Howard | Indiana | 18067 | 9674 | 215 |
1232822 | 1232822 | 2021-04-18 | Howard | Indiana | 18067 | 9672 | 215 |
1229573 | 1229573 | 2021-04-17 | Howard | Indiana | 18067 | 9662 | 215 |
1226325 | 1226325 | 2021-04-16 | Howard | Indiana | 18067 | 9639 | 215 |
1223078 | 1223078 | 2021-04-15 | Howard | Indiana | 18067 | 9627 | 215 |
1219830 | 1219830 | 2021-04-14 | Howard | Indiana | 18067 | 9616 | 215 |
1216582 | 1216582 | 2021-04-13 | Howard | Indiana | 18067 | 9600 | 215 |
1213335 | 1213335 | 2021-04-12 | Howard | Indiana | 18067 | 9594 | 215 |
1210087 | 1210087 | 2021-04-11 | Howard | Indiana | 18067 | 9582 | 215 |
1206838 | 1206838 | 2021-04-10 | Howard | Indiana | 18067 | 9565 | 215 |
1203590 | 1203590 | 2021-04-09 | Howard | Indiana | 18067 | 9548 | 215 |
1200342 | 1200342 | 2021-04-08 | Howard | Indiana | 18067 | 9534 | 215 |
1197093 | 1197093 | 2021-04-07 | Howard | Indiana | 18067 | 9525 | 215 |
1193845 | 1193845 | 2021-04-06 | Howard | Indiana | 18067 | 9510 | 215 |
1190595 | 1190595 | 2021-04-05 | Howard | Indiana | 18067 | 9506 | 215 |
1187348 | 1187348 | 2021-04-04 | Howard | Indiana | 18067 | 9498 | 215 |
1184101 | 1184101 | 2021-04-03 | Howard | Indiana | 18067 | 9487 | 215 |
1180854 | 1180854 | 2021-04-02 | Howard | Indiana | 18067 | 9478 | 215 |
1177607 | 1177607 | 2021-04-01 | Howard | Indiana | 18067 | 9461 | 213 |
1174360 | 1174360 | 2021-03-31 | Howard | Indiana | 18067 | 9434 | 213 |
1171113 | 1171113 | 2021-03-30 | Howard | Indiana | 18067 | 9409 | 213 |
1167865 | 1167865 | 2021-03-29 | Howard | Indiana | 18067 | 9406 | 213 |
1164617 | 1164617 | 2021-03-28 | Howard | Indiana | 18067 | 9397 | 213 |
1161369 | 1161369 | 2021-03-27 | Howard | Indiana | 18067 | 9382 | 213 |
1158121 | 1158121 | 2021-03-26 | Howard | Indiana | 18067 | 9363 | 213 |
1154874 | 1154874 | 2021-03-25 | Howard | Indiana | 18067 | 9349 | 213 |
1151627 | 1151627 | 2021-03-24 | Howard | Indiana | 18067 | 9337 | 212 |
1148380 | 1148380 | 2021-03-23 | Howard | Indiana | 18067 | 9322 | 212 |
1145133 | 1145133 | 2021-03-22 | Howard | Indiana | 18067 | 9298 | 212 |
1141886 | 1141886 | 2021-03-21 | Howard | Indiana | 18067 | 9290 | 212 |
1138640 | 1138640 | 2021-03-20 | Howard | Indiana | 18067 | 9278 | 211 |
1135394 | 1135394 | 2021-03-19 | Howard | Indiana | 18067 | 9270 | 211 |
1132147 | 1132147 | 2021-03-18 | Howard | Indiana | 18067 | 9258 | 211 |
1128899 | 1128899 | 2021-03-17 | Howard | Indiana | 18067 | 9247 | 211 |
1125653 | 1125653 | 2021-03-16 | Howard | Indiana | 18067 | 9231 | 210 |
1122407 | 1122407 | 2021-03-15 | Howard | Indiana | 18067 | 9221 | 209 |
1119160 | 1119160 | 2021-03-14 | Howard | Indiana | 18067 | 9215 | 208 |
1115913 | 1115913 | 2021-03-13 | Howard | Indiana | 18067 | 9204 | 208 |
1112667 | 1112667 | 2021-03-12 | Howard | Indiana | 18067 | 9197 | 208 |
1109421 | 1109421 | 2021-03-11 | Howard | Indiana | 18067 | 9182 | 208 |
1106175 | 1106175 | 2021-03-10 | Howard | Indiana | 18067 | 9166 | 207 |
1102929 | 1102929 | 2021-03-09 | Howard | Indiana | 18067 | 9147 | 207 |
1099683 | 1099683 | 2021-03-08 | Howard | Indiana | 18067 | 9145 | 207 |
1096435 | 1096435 | 2021-03-07 | Howard | Indiana | 18067 | 9138 | 207 |
1093189 | 1093189 | 2021-03-06 | Howard | Indiana | 18067 | 9123 | 205 |
1089943 | 1089943 | 2021-03-05 | Howard | Indiana | 18067 | 9106 | 203 |
1086698 | 1086698 | 2021-03-04 | Howard | Indiana | 18067 | 9094 | 203 |
1083452 | 1083452 | 2021-03-03 | Howard | Indiana | 18067 | 9086 | 202 |
1080206 | 1080206 | 2021-03-02 | Howard | Indiana | 18067 | 9070 | 202 |
1076961 | 1076961 | 2021-03-01 | Howard | Indiana | 18067 | 9067 | 201 |
1073715 | 1073715 | 2021-02-28 | Howard | Indiana | 18067 | 9066 | 201 |
1070469 | 1070469 | 2021-02-27 | Howard | Indiana | 18067 | 9058 | 200 |
1067224 | 1067224 | 2021-02-26 | Howard | Indiana | 18067 | 9049 | 199 |
1063979 | 1063979 | 2021-02-25 | Howard | Indiana | 18067 | 9041 | 199 |
1060734 | 1060734 | 2021-02-24 | Howard | Indiana | 18067 | 9035 | 198 |
1057488 | 1057488 | 2021-02-23 | Howard | Indiana | 18067 | 9028 | 198 |
1054242 | 1054242 | 2021-02-22 | Howard | Indiana | 18067 | 9024 | 196 |
1050995 | 1050995 | 2021-02-21 | Howard | Indiana | 18067 | 9014 | 195 |
1047748 | 1047748 | 2021-02-20 | Howard | Indiana | 18067 | 9010 | 195 |
1044503 | 1044503 | 2021-02-19 | Howard | Indiana | 18067 | 9002 | 194 |
1041258 | 1041258 | 2021-02-18 | Howard | Indiana | 18067 | 8996 | 194 |
1038013 | 1038013 | 2021-02-17 | Howard | Indiana | 18067 | 8994 | 191 |
1034768 | 1034768 | 2021-02-16 | Howard | Indiana | 18067 | 8985 | 190 |
1031522 | 1031522 | 2021-02-15 | Howard | Indiana | 18067 | 8969 | 187 |
1028275 | 1028275 | 2021-02-14 | Howard | Indiana | 18067 | 8962 | 186 |
1025030 | 1025030 | 2021-02-13 | Howard | Indiana | 18067 | 8942 | 184 |
1021785 | 1021785 | 2021-02-12 | Howard | Indiana | 18067 | 8921 | 184 |
1018540 | 1018540 | 2021-02-11 | Howard | Indiana | 18067 | 8899 | 179 |
1015295 | 1015295 | 2021-02-10 | Howard | Indiana | 18067 | 8875 | 178 |
1012050 | 1012050 | 2021-02-09 | Howard | Indiana | 18067 | 8847 | 178 |
1008804 | 1008804 | 2021-02-08 | Howard | Indiana | 18067 | 8840 | 178 |
1005558 | 1005558 | 2021-02-07 | Howard | Indiana | 18067 | 8829 | 177 |
1002312 | 1002312 | 2021-02-06 | Howard | Indiana | 18067 | 8802 | 176 |
999066 | 999066 | 2021-02-05 | Howard | Indiana | 18067 | 8750 | 174 |
995820 | 995820 | 2021-02-04 | Howard | Indiana | 18067 | 8723 | 174 |
992574 | 992574 | 2021-02-03 | Howard | Indiana | 18067 | 8691 | 157 |
989328 | 989328 | 2021-02-02 | Howard | Indiana | 18067 | 8651 | 156 |
986081 | 986081 | 2021-02-01 | Howard | Indiana | 18067 | 8610 | 156 |
982834 | 982834 | 2021-01-31 | Howard | Indiana | 18067 | 8589 | 156 |
979588 | 979588 | 2021-01-30 | Howard | Indiana | 18067 | 8550 | 156 |
976342 | 976342 | 2021-01-29 | Howard | Indiana | 18067 | 8492 | 156 |
973097 | 973097 | 2021-01-28 | Howard | Indiana | 18067 | 8448 | 154 |
969852 | 969852 | 2021-01-27 | Howard | Indiana | 18067 | 8391 | 154 |
966608 | 966608 | 2021-01-26 | Howard | Indiana | 18067 | 8335 | 151 |
963363 | 963363 | 2021-01-25 | Howard | Indiana | 18067 | 8302 | 147 |
960118 | 960118 | 2021-01-24 | Howard | Indiana | 18067 | 8278 | 147 |
956872 | 956872 | 2021-01-23 | Howard | Indiana | 18067 | 8246 | 147 |
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);