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 |
---|---|---|---|---|---|---|---|
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 |
729708 | 729708 | 2020-11-14 | Marion | Indiana | 18097 | 34807 | 872 |
726465 | 726465 | 2020-11-13 | Marion | Indiana | 18097 | 33752 | 869 |
723222 | 723222 | 2020-11-12 | Marion | Indiana | 18097 | 33135 | 867 |
719979 | 719979 | 2020-11-11 | Marion | Indiana | 18097 | 32204 | 863 |
716736 | 716736 | 2020-11-10 | Marion | Indiana | 18097 | 31495 | 861 |
713492 | 713492 | 2020-11-09 | Marion | Indiana | 18097 | 30956 | 857 |
710248 | 710248 | 2020-11-08 | Marion | Indiana | 18097 | 30597 | 857 |
707004 | 707004 | 2020-11-07 | Marion | Indiana | 18097 | 30171 | 856 |
703761 | 703761 | 2020-11-06 | Marion | Indiana | 18097 | 29621 | 854 |
700519 | 700519 | 2020-11-05 | Marion | Indiana | 18097 | 29219 | 853 |
697275 | 697275 | 2020-11-04 | Marion | Indiana | 18097 | 28839 | 851 |
694033 | 694033 | 2020-11-03 | Marion | Indiana | 18097 | 28446 | 850 |
690790 | 690790 | 2020-11-02 | Marion | Indiana | 18097 | 28165 | 850 |
687545 | 687545 | 2020-11-01 | Marion | Indiana | 18097 | 27861 | 850 |
684301 | 684301 | 2020-10-31 | Marion | Indiana | 18097 | 27627 | 850 |
681058 | 681058 | 2020-10-30 | Marion | Indiana | 18097 | 27279 | 850 |
677815 | 677815 | 2020-10-29 | Marion | Indiana | 18097 | 26979 | 850 |
674572 | 674572 | 2020-10-28 | Marion | Indiana | 18097 | 26620 | 848 |
671330 | 671330 | 2020-10-27 | Marion | Indiana | 18097 | 26427 | 849 |
668087 | 668087 | 2020-10-26 | Marion | Indiana | 18097 | 26227 | 846 |
664843 | 664843 | 2020-10-25 | Marion | Indiana | 18097 | 26043 | 846 |
661598 | 661598 | 2020-10-24 | Marion | Indiana | 18097 | 25863 | 845 |
658354 | 658354 | 2020-10-23 | Marion | Indiana | 18097 | 25565 | 843 |
655109 | 655109 | 2020-10-22 | Marion | Indiana | 18097 | 25324 | 839 |
651864 | 651864 | 2020-10-21 | Marion | Indiana | 18097 | 25079 | 838 |
648620 | 648620 | 2020-10-20 | Marion | Indiana | 18097 | 24871 | 837 |
645375 | 645375 | 2020-10-19 | Marion | Indiana | 18097 | 24738 | 834 |
642128 | 642128 | 2020-10-18 | Marion | Indiana | 18097 | 24584 | 833 |
638881 | 638881 | 2020-10-17 | Marion | Indiana | 18097 | 24464 | 833 |
635635 | 635635 | 2020-10-16 | Marion | Indiana | 18097 | 24208 | 830 |
632389 | 632389 | 2020-10-15 | Marion | Indiana | 18097 | 24026 | 829 |
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);