ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 18069 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1417867 | 1417867 | 2021-06-14 | Huntington | Indiana | 18069 | 4027 | 83 |
1414621 | 1414621 | 2021-06-13 | Huntington | Indiana | 18069 | 4026 | 83 |
1411376 | 1411376 | 2021-06-12 | Huntington | Indiana | 18069 | 4026 | 83 |
1408131 | 1408131 | 2021-06-11 | Huntington | Indiana | 18069 | 4026 | 83 |
1404885 | 1404885 | 2021-06-10 | Huntington | Indiana | 18069 | 4024 | 83 |
1401640 | 1401640 | 2021-06-09 | Huntington | Indiana | 18069 | 4020 | 83 |
1398395 | 1398395 | 2021-06-08 | Huntington | Indiana | 18069 | 4018 | 83 |
1395148 | 1395148 | 2021-06-07 | Huntington | Indiana | 18069 | 4016 | 83 |
1391903 | 1391903 | 2021-06-06 | Huntington | Indiana | 18069 | 4015 | 83 |
1388658 | 1388658 | 2021-06-05 | Huntington | Indiana | 18069 | 4015 | 83 |
1385413 | 1385413 | 2021-06-04 | Huntington | Indiana | 18069 | 4012 | 83 |
1382167 | 1382167 | 2021-06-03 | Huntington | Indiana | 18069 | 4011 | 83 |
1378922 | 1378922 | 2021-06-02 | Huntington | Indiana | 18069 | 4009 | 83 |
1375676 | 1375676 | 2021-06-01 | Huntington | Indiana | 18069 | 4009 | 82 |
1372431 | 1372431 | 2021-05-31 | Huntington | Indiana | 18069 | 4006 | 82 |
1369186 | 1369186 | 2021-05-30 | Huntington | Indiana | 18069 | 4006 | 82 |
1365940 | 1365940 | 2021-05-29 | Huntington | Indiana | 18069 | 4005 | 82 |
1362694 | 1362694 | 2021-05-28 | Huntington | Indiana | 18069 | 4000 | 82 |
1359447 | 1359447 | 2021-05-27 | Huntington | Indiana | 18069 | 3993 | 82 |
1356201 | 1356201 | 2021-05-26 | Huntington | Indiana | 18069 | 3990 | 82 |
1352955 | 1352955 | 2021-05-25 | Huntington | Indiana | 18069 | 3988 | 82 |
1349709 | 1349709 | 2021-05-24 | Huntington | Indiana | 18069 | 3983 | 82 |
1346462 | 1346462 | 2021-05-23 | Huntington | Indiana | 18069 | 3982 | 82 |
1343214 | 1343214 | 2021-05-22 | Huntington | Indiana | 18069 | 3978 | 82 |
1339966 | 1339966 | 2021-05-21 | Huntington | Indiana | 18069 | 3975 | 82 |
1336719 | 1336719 | 2021-05-20 | Huntington | Indiana | 18069 | 3969 | 82 |
1333472 | 1333472 | 2021-05-19 | Huntington | Indiana | 18069 | 3962 | 82 |
1330225 | 1330225 | 2021-05-18 | Huntington | Indiana | 18069 | 3955 | 82 |
1326978 | 1326978 | 2021-05-17 | Huntington | Indiana | 18069 | 3949 | 82 |
1323732 | 1323732 | 2021-05-16 | Huntington | Indiana | 18069 | 3947 | 82 |
1320486 | 1320486 | 2021-05-15 | Huntington | Indiana | 18069 | 3940 | 82 |
1317239 | 1317239 | 2021-05-14 | Huntington | Indiana | 18069 | 3938 | 82 |
1313992 | 1313992 | 2021-05-13 | Huntington | Indiana | 18069 | 3934 | 82 |
1310745 | 1310745 | 2021-05-12 | Huntington | Indiana | 18069 | 3927 | 82 |
1307499 | 1307499 | 2021-05-11 | Huntington | Indiana | 18069 | 3924 | 82 |
1304253 | 1304253 | 2021-05-10 | Huntington | Indiana | 18069 | 3916 | 82 |
1301006 | 1301006 | 2021-05-09 | Huntington | Indiana | 18069 | 3911 | 82 |
1297759 | 1297759 | 2021-05-08 | Huntington | Indiana | 18069 | 3905 | 82 |
1294513 | 1294513 | 2021-05-07 | Huntington | Indiana | 18069 | 3895 | 82 |
1291267 | 1291267 | 2021-05-06 | Huntington | Indiana | 18069 | 3879 | 82 |
1288021 | 1288021 | 2021-05-05 | Huntington | Indiana | 18069 | 3874 | 82 |
1284775 | 1284775 | 2021-05-04 | Huntington | Indiana | 18069 | 3868 | 82 |
1281528 | 1281528 | 2021-05-03 | Huntington | Indiana | 18069 | 3863 | 82 |
1278281 | 1278281 | 2021-05-02 | Huntington | Indiana | 18069 | 3860 | 82 |
1275034 | 1275034 | 2021-05-01 | Huntington | Indiana | 18069 | 3854 | 82 |
1271787 | 1271787 | 2021-04-30 | Huntington | Indiana | 18069 | 3852 | 82 |
1268540 | 1268540 | 2021-04-29 | Huntington | Indiana | 18069 | 3844 | 82 |
1265293 | 1265293 | 2021-04-28 | Huntington | Indiana | 18069 | 3838 | 82 |
1262046 | 1262046 | 2021-04-27 | Huntington | Indiana | 18069 | 3830 | 82 |
1258799 | 1258799 | 2021-04-26 | Huntington | Indiana | 18069 | 3825 | 82 |
1255552 | 1255552 | 2021-04-25 | Huntington | Indiana | 18069 | 3821 | 82 |
1252305 | 1252305 | 2021-04-24 | Huntington | Indiana | 18069 | 3818 | 82 |
1249058 | 1249058 | 2021-04-23 | Huntington | Indiana | 18069 | 3813 | 82 |
1245811 | 1245811 | 2021-04-22 | Huntington | Indiana | 18069 | 3809 | 82 |
1242564 | 1242564 | 2021-04-21 | Huntington | Indiana | 18069 | 3802 | 82 |
1239317 | 1239317 | 2021-04-20 | Huntington | Indiana | 18069 | 3806 | 82 |
1236070 | 1236070 | 2021-04-19 | Huntington | Indiana | 18069 | 3803 | 82 |
1232823 | 1232823 | 2021-04-18 | Huntington | Indiana | 18069 | 3799 | 82 |
1229574 | 1229574 | 2021-04-17 | Huntington | Indiana | 18069 | 3791 | 82 |
1226326 | 1226326 | 2021-04-16 | Huntington | Indiana | 18069 | 3779 | 82 |
1223079 | 1223079 | 2021-04-15 | Huntington | Indiana | 18069 | 3774 | 82 |
1219831 | 1219831 | 2021-04-14 | Huntington | Indiana | 18069 | 3769 | 82 |
1216583 | 1216583 | 2021-04-13 | Huntington | Indiana | 18069 | 3756 | 82 |
1213336 | 1213336 | 2021-04-12 | Huntington | Indiana | 18069 | 3746 | 82 |
1210088 | 1210088 | 2021-04-11 | Huntington | Indiana | 18069 | 3736 | 82 |
1206839 | 1206839 | 2021-04-10 | Huntington | Indiana | 18069 | 3723 | 82 |
1203591 | 1203591 | 2021-04-09 | Huntington | Indiana | 18069 | 3715 | 82 |
1200343 | 1200343 | 2021-04-08 | Huntington | Indiana | 18069 | 3712 | 82 |
1197094 | 1197094 | 2021-04-07 | Huntington | Indiana | 18069 | 3708 | 82 |
1193846 | 1193846 | 2021-04-06 | Huntington | Indiana | 18069 | 3700 | 82 |
1190596 | 1190596 | 2021-04-05 | Huntington | Indiana | 18069 | 3698 | 82 |
1187349 | 1187349 | 2021-04-04 | Huntington | Indiana | 18069 | 3696 | 82 |
1184102 | 1184102 | 2021-04-03 | Huntington | Indiana | 18069 | 3693 | 82 |
1180855 | 1180855 | 2021-04-02 | Huntington | Indiana | 18069 | 3689 | 82 |
1177608 | 1177608 | 2021-04-01 | Huntington | Indiana | 18069 | 3682 | 82 |
1174361 | 1174361 | 2021-03-31 | Huntington | Indiana | 18069 | 3675 | 81 |
1171114 | 1171114 | 2021-03-30 | Huntington | Indiana | 18069 | 3674 | 81 |
1167866 | 1167866 | 2021-03-29 | Huntington | Indiana | 18069 | 3672 | 81 |
1164618 | 1164618 | 2021-03-28 | Huntington | Indiana | 18069 | 3672 | 81 |
1161370 | 1161370 | 2021-03-27 | Huntington | Indiana | 18069 | 3670 | 81 |
1158122 | 1158122 | 2021-03-26 | Huntington | Indiana | 18069 | 3662 | 81 |
1154875 | 1154875 | 2021-03-25 | Huntington | Indiana | 18069 | 3653 | 81 |
1151628 | 1151628 | 2021-03-24 | Huntington | Indiana | 18069 | 3645 | 80 |
1148381 | 1148381 | 2021-03-23 | Huntington | Indiana | 18069 | 3630 | 80 |
1145134 | 1145134 | 2021-03-22 | Huntington | Indiana | 18069 | 3623 | 80 |
1141887 | 1141887 | 2021-03-21 | Huntington | Indiana | 18069 | 3619 | 80 |
1138641 | 1138641 | 2021-03-20 | Huntington | Indiana | 18069 | 3611 | 80 |
1135395 | 1135395 | 2021-03-19 | Huntington | Indiana | 18069 | 3603 | 80 |
1132148 | 1132148 | 2021-03-18 | Huntington | Indiana | 18069 | 3596 | 80 |
1128900 | 1128900 | 2021-03-17 | Huntington | Indiana | 18069 | 3579 | 80 |
1125654 | 1125654 | 2021-03-16 | Huntington | Indiana | 18069 | 3575 | 80 |
1122408 | 1122408 | 2021-03-15 | Huntington | Indiana | 18069 | 3574 | 80 |
1119161 | 1119161 | 2021-03-14 | Huntington | Indiana | 18069 | 3570 | 80 |
1115914 | 1115914 | 2021-03-13 | Huntington | Indiana | 18069 | 3561 | 80 |
1112668 | 1112668 | 2021-03-12 | Huntington | Indiana | 18069 | 3554 | 80 |
1109422 | 1109422 | 2021-03-11 | Huntington | Indiana | 18069 | 3537 | 80 |
1106176 | 1106176 | 2021-03-10 | Huntington | Indiana | 18069 | 3532 | 80 |
1102930 | 1102930 | 2021-03-09 | Huntington | Indiana | 18069 | 3525 | 80 |
1099684 | 1099684 | 2021-03-08 | Huntington | Indiana | 18069 | 3518 | 79 |
1096436 | 1096436 | 2021-03-07 | Huntington | Indiana | 18069 | 3512 | 78 |
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);