ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 18091 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054253 | 1054253 | 2021-02-22 | LaPorte | Indiana | 18091 | 9726 | 197 |
1051006 | 1051006 | 2021-02-21 | LaPorte | Indiana | 18091 | 9717 | 197 |
1047759 | 1047759 | 2021-02-20 | LaPorte | Indiana | 18091 | 9701 | 197 |
1044514 | 1044514 | 2021-02-19 | LaPorte | Indiana | 18091 | 9682 | 197 |
1041269 | 1041269 | 2021-02-18 | LaPorte | Indiana | 18091 | 9661 | 197 |
1038024 | 1038024 | 2021-02-17 | LaPorte | Indiana | 18091 | 9651 | 196 |
1034779 | 1034779 | 2021-02-16 | LaPorte | Indiana | 18091 | 9609 | 196 |
1031533 | 1031533 | 2021-02-15 | LaPorte | Indiana | 18091 | 9601 | 196 |
1028286 | 1028286 | 2021-02-14 | LaPorte | Indiana | 18091 | 9594 | 196 |
1025041 | 1025041 | 2021-02-13 | LaPorte | Indiana | 18091 | 9581 | 196 |
1021796 | 1021796 | 2021-02-12 | LaPorte | Indiana | 18091 | 9573 | 195 |
1018551 | 1018551 | 2021-02-11 | LaPorte | Indiana | 18091 | 9559 | 194 |
1015306 | 1015306 | 2021-02-10 | LaPorte | Indiana | 18091 | 9537 | 194 |
1012061 | 1012061 | 2021-02-09 | LaPorte | Indiana | 18091 | 9527 | 194 |
1008815 | 1008815 | 2021-02-08 | LaPorte | Indiana | 18091 | 9520 | 192 |
1005569 | 1005569 | 2021-02-07 | LaPorte | Indiana | 18091 | 9504 | 192 |
1002323 | 1002323 | 2021-02-06 | LaPorte | Indiana | 18091 | 9490 | 192 |
999077 | 999077 | 2021-02-05 | LaPorte | Indiana | 18091 | 9470 | 192 |
995831 | 995831 | 2021-02-04 | LaPorte | Indiana | 18091 | 9451 | 191 |
992585 | 992585 | 2021-02-03 | LaPorte | Indiana | 18091 | 9420 | 175 |
989339 | 989339 | 2021-02-02 | LaPorte | Indiana | 18091 | 9409 | 175 |
986092 | 986092 | 2021-02-01 | LaPorte | Indiana | 18091 | 9392 | 173 |
982845 | 982845 | 2021-01-31 | LaPorte | Indiana | 18091 | 9376 | 173 |
979599 | 979599 | 2021-01-30 | LaPorte | Indiana | 18091 | 9356 | 173 |
976353 | 976353 | 2021-01-29 | LaPorte | Indiana | 18091 | 9336 | 172 |
973108 | 973108 | 2021-01-28 | LaPorte | Indiana | 18091 | 9257 | 169 |
969863 | 969863 | 2021-01-27 | LaPorte | Indiana | 18091 | 9198 | 168 |
966619 | 966619 | 2021-01-26 | LaPorte | Indiana | 18091 | 9182 | 167 |
963374 | 963374 | 2021-01-25 | LaPorte | Indiana | 18091 | 9154 | 167 |
960129 | 960129 | 2021-01-24 | LaPorte | Indiana | 18091 | 9112 | 167 |
956883 | 956883 | 2021-01-23 | LaPorte | Indiana | 18091 | 9074 | 166 |
953638 | 953638 | 2021-01-22 | LaPorte | Indiana | 18091 | 9016 | 165 |
950393 | 950393 | 2021-01-21 | LaPorte | Indiana | 18091 | 8981 | 163 |
947147 | 947147 | 2021-01-20 | LaPorte | Indiana | 18091 | 8934 | 162 |
943900 | 943900 | 2021-01-19 | LaPorte | Indiana | 18091 | 8876 | 161 |
940655 | 940655 | 2021-01-18 | LaPorte | Indiana | 18091 | 8834 | 158 |
937410 | 937410 | 2021-01-17 | LaPorte | Indiana | 18091 | 8780 | 158 |
934165 | 934165 | 2021-01-16 | LaPorte | Indiana | 18091 | 8730 | 156 |
930920 | 930920 | 2021-01-15 | LaPorte | Indiana | 18091 | 8673 | 156 |
927675 | 927675 | 2021-01-14 | LaPorte | Indiana | 18091 | 8598 | 156 |
924429 | 924429 | 2021-01-13 | LaPorte | Indiana | 18091 | 8480 | 155 |
921184 | 921184 | 2021-01-12 | LaPorte | Indiana | 18091 | 8420 | 155 |
917939 | 917939 | 2021-01-11 | LaPorte | Indiana | 18091 | 8377 | 154 |
914694 | 914694 | 2021-01-10 | LaPorte | Indiana | 18091 | 8310 | 153 |
911449 | 911449 | 2021-01-09 | LaPorte | Indiana | 18091 | 8241 | 152 |
908204 | 908204 | 2021-01-08 | LaPorte | Indiana | 18091 | 8166 | 151 |
904958 | 904958 | 2021-01-07 | LaPorte | Indiana | 18091 | 8014 | 148 |
901713 | 901713 | 2021-01-06 | LaPorte | Indiana | 18091 | 7956 | 146 |
898468 | 898468 | 2021-01-05 | LaPorte | Indiana | 18091 | 7895 | 144 |
895223 | 895223 | 2021-01-04 | LaPorte | Indiana | 18091 | 7841 | 142 |
891976 | 891976 | 2021-01-03 | LaPorte | Indiana | 18091 | 7798 | 142 |
888730 | 888730 | 2021-01-02 | LaPorte | Indiana | 18091 | 7744 | 141 |
885484 | 885484 | 2021-01-01 | LaPorte | Indiana | 18091 | 7658 | 140 |
882239 | 882239 | 2020-12-31 | LaPorte | Indiana | 18091 | 7561 | 139 |
878994 | 878994 | 2020-12-30 | LaPorte | Indiana | 18091 | 7423 | 137 |
875749 | 875749 | 2020-12-29 | LaPorte | Indiana | 18091 | 7350 | 135 |
872504 | 872504 | 2020-12-28 | LaPorte | Indiana | 18091 | 7293 | 131 |
869259 | 869259 | 2020-12-27 | LaPorte | Indiana | 18091 | 7230 | 130 |
866014 | 866014 | 2020-12-26 | LaPorte | Indiana | 18091 | 7189 | 128 |
862769 | 862769 | 2020-12-25 | LaPorte | Indiana | 18091 | 7131 | 128 |
859524 | 859524 | 2020-12-24 | LaPorte | Indiana | 18091 | 7049 | 127 |
856279 | 856279 | 2020-12-23 | LaPorte | Indiana | 18091 | 6915 | 126 |
853034 | 853034 | 2020-12-22 | LaPorte | Indiana | 18091 | 6865 | 124 |
849789 | 849789 | 2020-12-21 | LaPorte | Indiana | 18091 | 6777 | 124 |
846544 | 846544 | 2020-12-20 | LaPorte | Indiana | 18091 | 6713 | 124 |
843298 | 843298 | 2020-12-19 | LaPorte | Indiana | 18091 | 6622 | 122 |
840053 | 840053 | 2020-12-18 | LaPorte | Indiana | 18091 | 6562 | 122 |
836808 | 836808 | 2020-12-17 | LaPorte | Indiana | 18091 | 6448 | 120 |
833562 | 833562 | 2020-12-16 | LaPorte | Indiana | 18091 | 6327 | 119 |
830315 | 830315 | 2020-12-15 | LaPorte | Indiana | 18091 | 6263 | 117 |
827069 | 827069 | 2020-12-14 | LaPorte | Indiana | 18091 | 6188 | 117 |
823822 | 823822 | 2020-12-13 | LaPorte | Indiana | 18091 | 6133 | 117 |
820576 | 820576 | 2020-12-12 | LaPorte | Indiana | 18091 | 6057 | 115 |
817330 | 817330 | 2020-12-11 | LaPorte | Indiana | 18091 | 5917 | 114 |
814084 | 814084 | 2020-12-10 | LaPorte | Indiana | 18091 | 5824 | 113 |
810839 | 810839 | 2020-12-09 | LaPorte | Indiana | 18091 | 5789 | 112 |
807594 | 807594 | 2020-12-08 | LaPorte | Indiana | 18091 | 5740 | 111 |
804349 | 804349 | 2020-12-07 | LaPorte | Indiana | 18091 | 5644 | 110 |
801104 | 801104 | 2020-12-06 | LaPorte | Indiana | 18091 | 5570 | 109 |
797859 | 797859 | 2020-12-05 | LaPorte | Indiana | 18091 | 5465 | 109 |
794614 | 794614 | 2020-12-04 | LaPorte | Indiana | 18091 | 5384 | 107 |
791369 | 791369 | 2020-12-03 | LaPorte | Indiana | 18091 | 5298 | 106 |
788124 | 788124 | 2020-12-02 | LaPorte | Indiana | 18091 | 5178 | 105 |
784880 | 784880 | 2020-12-01 | LaPorte | Indiana | 18091 | 5107 | 102 |
781635 | 781635 | 2020-11-30 | LaPorte | Indiana | 18091 | 5026 | 98 |
778389 | 778389 | 2020-11-29 | LaPorte | Indiana | 18091 | 4935 | 98 |
775144 | 775144 | 2020-11-28 | LaPorte | Indiana | 18091 | 4869 | 98 |
771899 | 771899 | 2020-11-27 | LaPorte | Indiana | 18091 | 4818 | 97 |
768654 | 768654 | 2020-11-26 | LaPorte | Indiana | 18091 | 4753 | 96 |
765408 | 765408 | 2020-11-25 | LaPorte | Indiana | 18091 | 4662 | 96 |
762163 | 762163 | 2020-11-24 | LaPorte | Indiana | 18091 | 4578 | 95 |
758918 | 758918 | 2020-11-23 | LaPorte | Indiana | 18091 | 4475 | 95 |
755671 | 755671 | 2020-11-22 | LaPorte | Indiana | 18091 | 4374 | 93 |
752425 | 752425 | 2020-11-21 | LaPorte | Indiana | 18091 | 4307 | 90 |
749179 | 749179 | 2020-11-20 | LaPorte | Indiana | 18091 | 4200 | 88 |
745933 | 745933 | 2020-11-19 | LaPorte | Indiana | 18091 | 4086 | 86 |
742686 | 742686 | 2020-11-18 | LaPorte | Indiana | 18091 | 4007 | 84 |
739439 | 739439 | 2020-11-17 | LaPorte | Indiana | 18091 | 3904 | 83 |
736195 | 736195 | 2020-11-16 | LaPorte | Indiana | 18091 | 3852 | 82 |
732949 | 732949 | 2020-11-15 | LaPorte | Indiana | 18091 | 3764 | 82 |
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);