ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 18097 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054257 | 1054257 | 2021-02-22 | Marion | Indiana | 18097 | 90249 | 1691 |
1051010 | 1051010 | 2021-02-21 | Marion | Indiana | 18097 | 90130 | 1688 |
1047763 | 1047763 | 2021-02-20 | Marion | Indiana | 18097 | 90044 | 1685 |
1044518 | 1044518 | 2021-02-19 | Marion | Indiana | 18097 | 89906 | 1685 |
1041273 | 1041273 | 2021-02-18 | Marion | Indiana | 18097 | 89788 | 1682 |
1038028 | 1038028 | 2021-02-17 | Marion | Indiana | 18097 | 89705 | 1681 |
1034783 | 1034783 | 2021-02-16 | Marion | Indiana | 18097 | 89611 | 1681 |
1031537 | 1031537 | 2021-02-15 | Marion | Indiana | 18097 | 89506 | 1676 |
1028290 | 1028290 | 2021-02-14 | Marion | Indiana | 18097 | 89381 | 1675 |
1025045 | 1025045 | 2021-02-13 | Marion | Indiana | 18097 | 89241 | 1674 |
1021800 | 1021800 | 2021-02-12 | Marion | Indiana | 18097 | 89085 | 1669 |
1018555 | 1018555 | 2021-02-11 | Marion | Indiana | 18097 | 88899 | 1665 |
1015310 | 1015310 | 2021-02-10 | Marion | Indiana | 18097 | 88712 | 1662 |
1012065 | 1012065 | 2021-02-09 | Marion | Indiana | 18097 | 88543 | 1655 |
1008819 | 1008819 | 2021-02-08 | Marion | Indiana | 18097 | 88398 | 1644 |
1005573 | 1005573 | 2021-02-07 | Marion | Indiana | 18097 | 88252 | 1640 |
1002327 | 1002327 | 2021-02-06 | Marion | Indiana | 18097 | 87981 | 1632 |
999081 | 999081 | 2021-02-05 | Marion | Indiana | 18097 | 87697 | 1624 |
995835 | 995835 | 2021-02-04 | Marion | Indiana | 18097 | 87497 | 1619 |
992589 | 992589 | 2021-02-03 | Marion | Indiana | 18097 | 87218 | 1440 |
989343 | 989343 | 2021-02-02 | Marion | Indiana | 18097 | 87059 | 1436 |
986096 | 986096 | 2021-02-01 | Marion | Indiana | 18097 | 86856 | 1425 |
982849 | 982849 | 2021-01-31 | Marion | Indiana | 18097 | 86603 | 1423 |
979603 | 979603 | 2021-01-30 | Marion | Indiana | 18097 | 86414 | 1422 |
976357 | 976357 | 2021-01-29 | Marion | Indiana | 18097 | 86093 | 1413 |
973112 | 973112 | 2021-01-28 | Marion | Indiana | 18097 | 85741 | 1409 |
969867 | 969867 | 2021-01-27 | Marion | Indiana | 18097 | 85414 | 1405 |
966623 | 966623 | 2021-01-26 | Marion | Indiana | 18097 | 85122 | 1405 |
963378 | 963378 | 2021-01-25 | Marion | Indiana | 18097 | 84884 | 1401 |
960133 | 960133 | 2021-01-24 | Marion | Indiana | 18097 | 84634 | 1399 |
956887 | 956887 | 2021-01-23 | Marion | Indiana | 18097 | 84245 | 1398 |
953642 | 953642 | 2021-01-22 | Marion | Indiana | 18097 | 83820 | 1394 |
950397 | 950397 | 2021-01-21 | Marion | Indiana | 18097 | 83308 | 1385 |
947151 | 947151 | 2021-01-20 | Marion | Indiana | 18097 | 82828 | 1380 |
943904 | 943904 | 2021-01-19 | Marion | Indiana | 18097 | 82482 | 1374 |
940659 | 940659 | 2021-01-18 | Marion | Indiana | 18097 | 82090 | 1364 |
937414 | 937414 | 2021-01-17 | Marion | Indiana | 18097 | 81755 | 1360 |
934169 | 934169 | 2021-01-16 | Marion | Indiana | 18097 | 81265 | 1359 |
930924 | 930924 | 2021-01-15 | Marion | Indiana | 18097 | 80752 | 1349 |
927679 | 927679 | 2021-01-14 | Marion | Indiana | 18097 | 80078 | 1345 |
924433 | 924433 | 2021-01-13 | Marion | Indiana | 18097 | 79548 | 1334 |
921188 | 921188 | 2021-01-12 | Marion | Indiana | 18097 | 79099 | 1329 |
917943 | 917943 | 2021-01-11 | Marion | Indiana | 18097 | 78630 | 1312 |
914698 | 914698 | 2021-01-10 | Marion | Indiana | 18097 | 78078 | 1306 |
911453 | 911453 | 2021-01-09 | Marion | Indiana | 18097 | 77458 | 1302 |
908208 | 908208 | 2021-01-08 | Marion | Indiana | 18097 | 76554 | 1292 |
904962 | 904962 | 2021-01-07 | Marion | Indiana | 18097 | 75694 | 1281 |
901717 | 901717 | 2021-01-06 | Marion | Indiana | 18097 | 74627 | 1268 |
898472 | 898472 | 2021-01-05 | Marion | Indiana | 18097 | 73842 | 1252 |
895227 | 895227 | 2021-01-04 | Marion | Indiana | 18097 | 73341 | 1235 |
891980 | 891980 | 2021-01-03 | Marion | Indiana | 18097 | 72892 | 1234 |
888734 | 888734 | 2021-01-02 | Marion | Indiana | 18097 | 72459 | 1225 |
885488 | 885488 | 2021-01-01 | Marion | Indiana | 18097 | 71677 | 1218 |
882243 | 882243 | 2020-12-31 | Marion | Indiana | 18097 | 70801 | 1206 |
878998 | 878998 | 2020-12-30 | Marion | Indiana | 18097 | 69987 | 1189 |
875753 | 875753 | 2020-12-29 | Marion | Indiana | 18097 | 69335 | 1176 |
872508 | 872508 | 2020-12-28 | Marion | Indiana | 18097 | 68627 | 1158 |
869263 | 869263 | 2020-12-27 | Marion | Indiana | 18097 | 68327 | 1151 |
866018 | 866018 | 2020-12-26 | Marion | Indiana | 18097 | 68025 | 1149 |
862773 | 862773 | 2020-12-25 | Marion | Indiana | 18097 | 67491 | 1146 |
859528 | 859528 | 2020-12-24 | Marion | Indiana | 18097 | 66703 | 1138 |
856283 | 856283 | 2020-12-23 | Marion | Indiana | 18097 | 65901 | 1125 |
853038 | 853038 | 2020-12-22 | Marion | Indiana | 18097 | 65255 | 1117 |
849793 | 849793 | 2020-12-21 | Marion | Indiana | 18097 | 64739 | 1102 |
846548 | 846548 | 2020-12-20 | Marion | Indiana | 18097 | 64119 | 1100 |
843302 | 843302 | 2020-12-19 | Marion | Indiana | 18097 | 63190 | 1093 |
840057 | 840057 | 2020-12-18 | Marion | Indiana | 18097 | 62555 | 1085 |
836812 | 836812 | 2020-12-17 | Marion | Indiana | 18097 | 61563 | 1078 |
833566 | 833566 | 2020-12-16 | Marion | Indiana | 18097 | 60670 | 1066 |
830319 | 830319 | 2020-12-15 | Marion | Indiana | 18097 | 59718 | 1048 |
827073 | 827073 | 2020-12-14 | Marion | Indiana | 18097 | 59116 | 1033 |
823826 | 823826 | 2020-12-13 | Marion | Indiana | 18097 | 58276 | 1022 |
820580 | 820580 | 2020-12-12 | Marion | Indiana | 18097 | 57361 | 1016 |
817334 | 817334 | 2020-12-11 | Marion | Indiana | 18097 | 56430 | 1008 |
814088 | 814088 | 2020-12-10 | Marion | Indiana | 18097 | 55399 | 997 |
810843 | 810843 | 2020-12-09 | Marion | Indiana | 18097 | 54387 | 990 |
807598 | 807598 | 2020-12-08 | Marion | Indiana | 18097 | 53696 | 987 |
804353 | 804353 | 2020-12-07 | Marion | Indiana | 18097 | 52919 | 977 |
801108 | 801108 | 2020-12-06 | Marion | Indiana | 18097 | 52056 | 973 |
797863 | 797863 | 2020-12-05 | Marion | Indiana | 18097 | 51069 | 967 |
794618 | 794618 | 2020-12-04 | Marion | Indiana | 18097 | 50080 | 959 |
791373 | 791373 | 2020-12-03 | Marion | Indiana | 18097 | 48921 | 951 |
788128 | 788128 | 2020-12-02 | Marion | Indiana | 18097 | 47945 | 950 |
784884 | 784884 | 2020-12-01 | Marion | Indiana | 18097 | 47064 | 940 |
781639 | 781639 | 2020-11-30 | Marion | Indiana | 18097 | 46309 | 925 |
778393 | 778393 | 2020-11-29 | Marion | Indiana | 18097 | 45550 | 920 |
775148 | 775148 | 2020-11-28 | Marion | Indiana | 18097 | 44972 | 918 |
771903 | 771903 | 2020-11-27 | Marion | Indiana | 18097 | 44364 | 913 |
768658 | 768658 | 2020-11-26 | Marion | Indiana | 18097 | 43569 | 910 |
765412 | 765412 | 2020-11-25 | Marion | Indiana | 18097 | 42819 | 904 |
762167 | 762167 | 2020-11-24 | Marion | Indiana | 18097 | 42131 | 904 |
758922 | 758922 | 2020-11-23 | Marion | Indiana | 18097 | 41508 | 900 |
755675 | 755675 | 2020-11-22 | Marion | Indiana | 18097 | 40974 | 899 |
752429 | 752429 | 2020-11-21 | Marion | Indiana | 18097 | 40035 | 892 |
749183 | 749183 | 2020-11-20 | Marion | Indiana | 18097 | 39300 | 889 |
745937 | 745937 | 2020-11-19 | Marion | Indiana | 18097 | 38501 | 884 |
742690 | 742690 | 2020-11-18 | Marion | Indiana | 18097 | 37726 | 881 |
739443 | 739443 | 2020-11-17 | Marion | Indiana | 18097 | 37048 | 880 |
736199 | 736199 | 2020-11-16 | Marion | Indiana | 18097 | 36180 | 876 |
732953 | 732953 | 2020-11-15 | Marion | Indiana | 18097 | 35590 | 874 |
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);