ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where fips = 18113 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1391925 | 1391925 | 2021-06-06 | Noble | Indiana | 18113 | 5769 | 88 |
1388680 | 1388680 | 2021-06-05 | Noble | Indiana | 18113 | 5769 | 88 |
1385435 | 1385435 | 2021-06-04 | Noble | Indiana | 18113 | 5766 | 88 |
1382189 | 1382189 | 2021-06-03 | Noble | Indiana | 18113 | 5762 | 88 |
1378944 | 1378944 | 2021-06-02 | Noble | Indiana | 18113 | 5757 | 88 |
1375698 | 1375698 | 2021-06-01 | Noble | Indiana | 18113 | 5750 | 88 |
1372453 | 1372453 | 2021-05-31 | Noble | Indiana | 18113 | 5750 | 88 |
1369208 | 1369208 | 2021-05-30 | Noble | Indiana | 18113 | 5750 | 88 |
1365962 | 1365962 | 2021-05-29 | Noble | Indiana | 18113 | 5747 | 88 |
1362716 | 1362716 | 2021-05-28 | Noble | Indiana | 18113 | 5744 | 88 |
1359469 | 1359469 | 2021-05-27 | Noble | Indiana | 18113 | 5736 | 88 |
1356223 | 1356223 | 2021-05-26 | Noble | Indiana | 18113 | 5732 | 88 |
1352977 | 1352977 | 2021-05-25 | Noble | Indiana | 18113 | 5728 | 88 |
1349731 | 1349731 | 2021-05-24 | Noble | Indiana | 18113 | 5724 | 87 |
1346484 | 1346484 | 2021-05-23 | Noble | Indiana | 18113 | 5718 | 87 |
1343236 | 1343236 | 2021-05-22 | Noble | Indiana | 18113 | 5711 | 87 |
1339988 | 1339988 | 2021-05-21 | Noble | Indiana | 18113 | 5701 | 87 |
1336741 | 1336741 | 2021-05-20 | Noble | Indiana | 18113 | 5692 | 87 |
1333494 | 1333494 | 2021-05-19 | Noble | Indiana | 18113 | 5678 | 87 |
1330247 | 1330247 | 2021-05-18 | Noble | Indiana | 18113 | 5670 | 87 |
1327000 | 1327000 | 2021-05-17 | Noble | Indiana | 18113 | 5663 | 87 |
1323754 | 1323754 | 2021-05-16 | Noble | Indiana | 18113 | 5654 | 87 |
1320508 | 1320508 | 2021-05-15 | Noble | Indiana | 18113 | 5648 | 87 |
1317261 | 1317261 | 2021-05-14 | Noble | Indiana | 18113 | 5640 | 87 |
1314014 | 1314014 | 2021-05-13 | Noble | Indiana | 18113 | 5631 | 87 |
1310767 | 1310767 | 2021-05-12 | Noble | Indiana | 18113 | 5626 | 87 |
1307521 | 1307521 | 2021-05-11 | Noble | Indiana | 18113 | 5617 | 87 |
1304275 | 1304275 | 2021-05-10 | Noble | Indiana | 18113 | 5612 | 86 |
1301028 | 1301028 | 2021-05-09 | Noble | Indiana | 18113 | 5607 | 86 |
1297781 | 1297781 | 2021-05-08 | Noble | Indiana | 18113 | 5602 | 86 |
1294535 | 1294535 | 2021-05-07 | Noble | Indiana | 18113 | 5592 | 86 |
1291289 | 1291289 | 2021-05-06 | Noble | Indiana | 18113 | 5586 | 86 |
1288043 | 1288043 | 2021-05-05 | Noble | Indiana | 18113 | 5569 | 86 |
1284797 | 1284797 | 2021-05-04 | Noble | Indiana | 18113 | 5561 | 86 |
1281550 | 1281550 | 2021-05-03 | Noble | Indiana | 18113 | 5549 | 86 |
1278303 | 1278303 | 2021-05-02 | Noble | Indiana | 18113 | 5545 | 86 |
1275056 | 1275056 | 2021-05-01 | Noble | Indiana | 18113 | 5536 | 86 |
1271809 | 1271809 | 2021-04-30 | Noble | Indiana | 18113 | 5530 | 86 |
1268562 | 1268562 | 2021-04-29 | Noble | Indiana | 18113 | 5517 | 86 |
1265315 | 1265315 | 2021-04-28 | Noble | Indiana | 18113 | 5507 | 86 |
1262068 | 1262068 | 2021-04-27 | Noble | Indiana | 18113 | 5495 | 86 |
1258821 | 1258821 | 2021-04-26 | Noble | Indiana | 18113 | 5490 | 86 |
1255574 | 1255574 | 2021-04-25 | Noble | Indiana | 18113 | 5485 | 86 |
1252327 | 1252327 | 2021-04-24 | Noble | Indiana | 18113 | 5473 | 86 |
1249080 | 1249080 | 2021-04-23 | Noble | Indiana | 18113 | 5458 | 86 |
1245833 | 1245833 | 2021-04-22 | Noble | Indiana | 18113 | 5449 | 86 |
1242586 | 1242586 | 2021-04-21 | Noble | Indiana | 18113 | 5440 | 86 |
1239339 | 1239339 | 2021-04-20 | Noble | Indiana | 18113 | 5430 | 86 |
1236092 | 1236092 | 2021-04-19 | Noble | Indiana | 18113 | 5430 | 86 |
1232845 | 1232845 | 2021-04-18 | Noble | Indiana | 18113 | 5428 | 86 |
1229596 | 1229596 | 2021-04-17 | Noble | Indiana | 18113 | 5410 | 86 |
1226348 | 1226348 | 2021-04-16 | Noble | Indiana | 18113 | 5397 | 86 |
1223101 | 1223101 | 2021-04-15 | Noble | Indiana | 18113 | 5383 | 86 |
1219853 | 1219853 | 2021-04-14 | Noble | Indiana | 18113 | 5373 | 86 |
1216605 | 1216605 | 2021-04-13 | Noble | Indiana | 18113 | 5359 | 86 |
1213358 | 1213358 | 2021-04-12 | Noble | Indiana | 18113 | 5353 | 86 |
1210110 | 1210110 | 2021-04-11 | Noble | Indiana | 18113 | 5353 | 86 |
1206861 | 1206861 | 2021-04-10 | Noble | Indiana | 18113 | 5329 | 86 |
1203613 | 1203613 | 2021-04-09 | Noble | Indiana | 18113 | 5327 | 86 |
1200365 | 1200365 | 2021-04-08 | Noble | Indiana | 18113 | 5319 | 86 |
1197116 | 1197116 | 2021-04-07 | Noble | Indiana | 18113 | 5315 | 85 |
1193868 | 1193868 | 2021-04-06 | Noble | Indiana | 18113 | 5295 | 85 |
1190618 | 1190618 | 2021-04-05 | Noble | Indiana | 18113 | 5290 | 84 |
1187371 | 1187371 | 2021-04-04 | Noble | Indiana | 18113 | 5278 | 84 |
1184124 | 1184124 | 2021-04-03 | Noble | Indiana | 18113 | 5273 | 84 |
1180877 | 1180877 | 2021-04-02 | Noble | Indiana | 18113 | 5267 | 84 |
1177630 | 1177630 | 2021-04-01 | Noble | Indiana | 18113 | 5258 | 83 |
1174383 | 1174383 | 2021-03-31 | Noble | Indiana | 18113 | 5255 | 83 |
1171136 | 1171136 | 2021-03-30 | Noble | Indiana | 18113 | 5245 | 83 |
1167888 | 1167888 | 2021-03-29 | Noble | Indiana | 18113 | 5239 | 83 |
1164640 | 1164640 | 2021-03-28 | Noble | Indiana | 18113 | 5238 | 83 |
1161392 | 1161392 | 2021-03-27 | Noble | Indiana | 18113 | 5236 | 82 |
1158144 | 1158144 | 2021-03-26 | Noble | Indiana | 18113 | 5232 | 82 |
1154897 | 1154897 | 2021-03-25 | Noble | Indiana | 18113 | 5222 | 82 |
1151650 | 1151650 | 2021-03-24 | Noble | Indiana | 18113 | 5216 | 82 |
1148403 | 1148403 | 2021-03-23 | Noble | Indiana | 18113 | 5205 | 82 |
1145156 | 1145156 | 2021-03-22 | Noble | Indiana | 18113 | 5202 | 82 |
1141909 | 1141909 | 2021-03-21 | Noble | Indiana | 18113 | 5200 | 82 |
1138663 | 1138663 | 2021-03-20 | Noble | Indiana | 18113 | 5194 | 82 |
1135417 | 1135417 | 2021-03-19 | Noble | Indiana | 18113 | 5189 | 82 |
1132170 | 1132170 | 2021-03-18 | Noble | Indiana | 18113 | 5184 | 82 |
1128922 | 1128922 | 2021-03-17 | Noble | Indiana | 18113 | 5180 | 82 |
1125676 | 1125676 | 2021-03-16 | Noble | Indiana | 18113 | 5177 | 82 |
1122430 | 1122430 | 2021-03-15 | Noble | Indiana | 18113 | 5175 | 82 |
1119183 | 1119183 | 2021-03-14 | Noble | Indiana | 18113 | 5173 | 82 |
1115936 | 1115936 | 2021-03-13 | Noble | Indiana | 18113 | 5165 | 82 |
1112690 | 1112690 | 2021-03-12 | Noble | Indiana | 18113 | 5159 | 82 |
1109444 | 1109444 | 2021-03-11 | Noble | Indiana | 18113 | 5152 | 81 |
1106198 | 1106198 | 2021-03-10 | Noble | Indiana | 18113 | 5150 | 81 |
1102952 | 1102952 | 2021-03-09 | Noble | Indiana | 18113 | 5145 | 81 |
1099706 | 1099706 | 2021-03-08 | Noble | Indiana | 18113 | 5144 | 81 |
1096458 | 1096458 | 2021-03-07 | Noble | Indiana | 18113 | 5142 | 81 |
1093212 | 1093212 | 2021-03-06 | Noble | Indiana | 18113 | 5135 | 81 |
1089966 | 1089966 | 2021-03-05 | Noble | Indiana | 18113 | 5113 | 81 |
1086721 | 1086721 | 2021-03-04 | Noble | Indiana | 18113 | 5109 | 81 |
1083475 | 1083475 | 2021-03-03 | Noble | Indiana | 18113 | 5105 | 81 |
1080229 | 1080229 | 2021-03-02 | Noble | Indiana | 18113 | 5101 | 81 |
1076984 | 1076984 | 2021-03-01 | Noble | Indiana | 18113 | 5097 | 81 |
1073738 | 1073738 | 2021-02-28 | Noble | Indiana | 18113 | 5094 | 81 |
1070492 | 1070492 | 2021-02-27 | Noble | Indiana | 18113 | 5089 | 81 |
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);