ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 18157 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193890 | 1193890 | 2021-04-06 | Tippecanoe | Indiana | 18157 | 21196 | 213 |
1190640 | 1190640 | 2021-04-05 | Tippecanoe | Indiana | 18157 | 21150 | 213 |
1187393 | 1187393 | 2021-04-04 | Tippecanoe | Indiana | 18157 | 21124 | 213 |
1184146 | 1184146 | 2021-04-03 | Tippecanoe | Indiana | 18157 | 21078 | 213 |
1180899 | 1180899 | 2021-04-02 | Tippecanoe | Indiana | 18157 | 21035 | 213 |
1177652 | 1177652 | 2021-04-01 | Tippecanoe | Indiana | 18157 | 20968 | 213 |
1174405 | 1174405 | 2021-03-31 | Tippecanoe | Indiana | 18157 | 20913 | 213 |
1171158 | 1171158 | 2021-03-30 | Tippecanoe | Indiana | 18157 | 20860 | 213 |
1167910 | 1167910 | 2021-03-29 | Tippecanoe | Indiana | 18157 | 20812 | 213 |
1164662 | 1164662 | 2021-03-28 | Tippecanoe | Indiana | 18157 | 20792 | 213 |
1161414 | 1161414 | 2021-03-27 | Tippecanoe | Indiana | 18157 | 20754 | 212 |
1158166 | 1158166 | 2021-03-26 | Tippecanoe | Indiana | 18157 | 20720 | 212 |
1154919 | 1154919 | 2021-03-25 | Tippecanoe | Indiana | 18157 | 20680 | 212 |
1151672 | 1151672 | 2021-03-24 | Tippecanoe | Indiana | 18157 | 20649 | 212 |
1148425 | 1148425 | 2021-03-23 | Tippecanoe | Indiana | 18157 | 20614 | 212 |
1145178 | 1145178 | 2021-03-22 | Tippecanoe | Indiana | 18157 | 20595 | 213 |
1141931 | 1141931 | 2021-03-21 | Tippecanoe | Indiana | 18157 | 20575 | 213 |
1138685 | 1138685 | 2021-03-20 | Tippecanoe | Indiana | 18157 | 20557 | 213 |
1135439 | 1135439 | 2021-03-19 | Tippecanoe | Indiana | 18157 | 20539 | 213 |
1132192 | 1132192 | 2021-03-18 | Tippecanoe | Indiana | 18157 | 20523 | 213 |
1128944 | 1128944 | 2021-03-17 | Tippecanoe | Indiana | 18157 | 20499 | 213 |
1125698 | 1125698 | 2021-03-16 | Tippecanoe | Indiana | 18157 | 20471 | 210 |
1122452 | 1122452 | 2021-03-15 | Tippecanoe | Indiana | 18157 | 20454 | 210 |
1119205 | 1119205 | 2021-03-14 | Tippecanoe | Indiana | 18157 | 20426 | 210 |
1115958 | 1115958 | 2021-03-13 | Tippecanoe | Indiana | 18157 | 20414 | 209 |
1112712 | 1112712 | 2021-03-12 | Tippecanoe | Indiana | 18157 | 20400 | 209 |
1109466 | 1109466 | 2021-03-11 | Tippecanoe | Indiana | 18157 | 20369 | 209 |
1106220 | 1106220 | 2021-03-10 | Tippecanoe | Indiana | 18157 | 20330 | 209 |
1102974 | 1102974 | 2021-03-09 | Tippecanoe | Indiana | 18157 | 20308 | 208 |
1099728 | 1099728 | 2021-03-08 | Tippecanoe | Indiana | 18157 | 20266 | 209 |
1096480 | 1096480 | 2021-03-07 | Tippecanoe | Indiana | 18157 | 20247 | 209 |
1093234 | 1093234 | 2021-03-06 | Tippecanoe | Indiana | 18157 | 20227 | 209 |
1089988 | 1089988 | 2021-03-05 | Tippecanoe | Indiana | 18157 | 20192 | 209 |
1086743 | 1086743 | 2021-03-04 | Tippecanoe | Indiana | 18157 | 20150 | 207 |
1083497 | 1083497 | 2021-03-03 | Tippecanoe | Indiana | 18157 | 20103 | 207 |
1080251 | 1080251 | 2021-03-02 | Tippecanoe | Indiana | 18157 | 20057 | 207 |
1077006 | 1077006 | 2021-03-01 | Tippecanoe | Indiana | 18157 | 20031 | 205 |
1073760 | 1073760 | 2021-02-28 | Tippecanoe | Indiana | 18157 | 20007 | 205 |
1070514 | 1070514 | 2021-02-27 | Tippecanoe | Indiana | 18157 | 19984 | 204 |
1067269 | 1067269 | 2021-02-26 | Tippecanoe | Indiana | 18157 | 19934 | 203 |
1064024 | 1064024 | 2021-02-25 | Tippecanoe | Indiana | 18157 | 19880 | 203 |
1060779 | 1060779 | 2021-02-24 | Tippecanoe | Indiana | 18157 | 19822 | 201 |
1057533 | 1057533 | 2021-02-23 | Tippecanoe | Indiana | 18157 | 19772 | 201 |
1054287 | 1054287 | 2021-02-22 | Tippecanoe | Indiana | 18157 | 19736 | 200 |
1051040 | 1051040 | 2021-02-21 | Tippecanoe | Indiana | 18157 | 19708 | 200 |
1047793 | 1047793 | 2021-02-20 | Tippecanoe | Indiana | 18157 | 19676 | 197 |
1044548 | 1044548 | 2021-02-19 | Tippecanoe | Indiana | 18157 | 19603 | 197 |
1041303 | 1041303 | 2021-02-18 | Tippecanoe | Indiana | 18157 | 19545 | 196 |
1038058 | 1038058 | 2021-02-17 | Tippecanoe | Indiana | 18157 | 19489 | 195 |
1034813 | 1034813 | 2021-02-16 | Tippecanoe | Indiana | 18157 | 19459 | 193 |
1031567 | 1031567 | 2021-02-15 | Tippecanoe | Indiana | 18157 | 19418 | 193 |
1028320 | 1028320 | 2021-02-14 | Tippecanoe | Indiana | 18157 | 19377 | 193 |
1025075 | 1025075 | 2021-02-13 | Tippecanoe | Indiana | 18157 | 19323 | 191 |
1021830 | 1021830 | 2021-02-12 | Tippecanoe | Indiana | 18157 | 19262 | 189 |
1018585 | 1018585 | 2021-02-11 | Tippecanoe | Indiana | 18157 | 19227 | 188 |
1015340 | 1015340 | 2021-02-10 | Tippecanoe | Indiana | 18157 | 19132 | 187 |
1012095 | 1012095 | 2021-02-09 | Tippecanoe | Indiana | 18157 | 19102 | 185 |
1008849 | 1008849 | 2021-02-08 | Tippecanoe | Indiana | 18157 | 19027 | 184 |
1005603 | 1005603 | 2021-02-07 | Tippecanoe | Indiana | 18157 | 18989 | 179 |
1002357 | 1002357 | 2021-02-06 | Tippecanoe | Indiana | 18157 | 18975 | 177 |
999111 | 999111 | 2021-02-05 | Tippecanoe | Indiana | 18157 | 18820 | 176 |
995865 | 995865 | 2021-02-04 | Tippecanoe | Indiana | 18157 | 18747 | 175 |
992619 | 992619 | 2021-02-03 | Tippecanoe | Indiana | 18157 | 18669 | 157 |
989373 | 989373 | 2021-02-02 | Tippecanoe | Indiana | 18157 | 18629 | 154 |
986126 | 986126 | 2021-02-01 | Tippecanoe | Indiana | 18157 | 18570 | 152 |
982879 | 982879 | 2021-01-31 | Tippecanoe | Indiana | 18157 | 18513 | 151 |
979633 | 979633 | 2021-01-30 | Tippecanoe | Indiana | 18157 | 18459 | 151 |
976387 | 976387 | 2021-01-29 | Tippecanoe | Indiana | 18157 | 18414 | 150 |
973142 | 973142 | 2021-01-28 | Tippecanoe | Indiana | 18157 | 18313 | 149 |
969897 | 969897 | 2021-01-27 | Tippecanoe | Indiana | 18157 | 18246 | 147 |
966653 | 966653 | 2021-01-26 | Tippecanoe | Indiana | 18157 | 18154 | 145 |
963408 | 963408 | 2021-01-25 | Tippecanoe | Indiana | 18157 | 18112 | 142 |
960163 | 960163 | 2021-01-24 | Tippecanoe | Indiana | 18157 | 18047 | 141 |
956917 | 956917 | 2021-01-23 | Tippecanoe | Indiana | 18157 | 17974 | 139 |
953672 | 953672 | 2021-01-22 | Tippecanoe | Indiana | 18157 | 17909 | 134 |
950427 | 950427 | 2021-01-21 | Tippecanoe | Indiana | 18157 | 17803 | 131 |
947181 | 947181 | 2021-01-20 | Tippecanoe | Indiana | 18157 | 17705 | 129 |
943934 | 943934 | 2021-01-19 | Tippecanoe | Indiana | 18157 | 17642 | 126 |
940689 | 940689 | 2021-01-18 | Tippecanoe | Indiana | 18157 | 17486 | 123 |
937444 | 937444 | 2021-01-17 | Tippecanoe | Indiana | 18157 | 17426 | 122 |
934199 | 934199 | 2021-01-16 | Tippecanoe | Indiana | 18157 | 17309 | 122 |
930954 | 930954 | 2021-01-15 | Tippecanoe | Indiana | 18157 | 17164 | 119 |
927709 | 927709 | 2021-01-14 | Tippecanoe | Indiana | 18157 | 17002 | 117 |
924463 | 924463 | 2021-01-13 | Tippecanoe | Indiana | 18157 | 16893 | 116 |
921218 | 921218 | 2021-01-12 | Tippecanoe | Indiana | 18157 | 16811 | 115 |
917973 | 917973 | 2021-01-11 | Tippecanoe | Indiana | 18157 | 16749 | 113 |
914728 | 914728 | 2021-01-10 | Tippecanoe | Indiana | 18157 | 16612 | 113 |
911483 | 911483 | 2021-01-09 | Tippecanoe | Indiana | 18157 | 16495 | 111 |
908238 | 908238 | 2021-01-08 | Tippecanoe | Indiana | 18157 | 16299 | 110 |
904992 | 904992 | 2021-01-07 | Tippecanoe | Indiana | 18157 | 16050 | 106 |
901747 | 901747 | 2021-01-06 | Tippecanoe | Indiana | 18157 | 15873 | 102 |
898502 | 898502 | 2021-01-05 | Tippecanoe | Indiana | 18157 | 15618 | 101 |
895257 | 895257 | 2021-01-04 | Tippecanoe | Indiana | 18157 | 15517 | 98 |
892010 | 892010 | 2021-01-03 | Tippecanoe | Indiana | 18157 | 15382 | 94 |
888764 | 888764 | 2021-01-02 | Tippecanoe | Indiana | 18157 | 15315 | 93 |
885518 | 885518 | 2021-01-01 | Tippecanoe | Indiana | 18157 | 15179 | 91 |
882273 | 882273 | 2020-12-31 | Tippecanoe | Indiana | 18157 | 15018 | 88 |
879028 | 879028 | 2020-12-30 | Tippecanoe | Indiana | 18157 | 14796 | 84 |
875783 | 875783 | 2020-12-29 | Tippecanoe | Indiana | 18157 | 14673 | 81 |
872538 | 872538 | 2020-12-28 | Tippecanoe | Indiana | 18157 | 14553 | 73 |
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);