ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 18163 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193893 | 1193893 | 2021-04-06 | Vanderburgh | Indiana | 18163 | 21856 | 397 |
1190643 | 1190643 | 2021-04-05 | Vanderburgh | Indiana | 18163 | 21845 | 396 |
1187396 | 1187396 | 2021-04-04 | Vanderburgh | Indiana | 18163 | 21841 | 396 |
1184149 | 1184149 | 2021-04-03 | Vanderburgh | Indiana | 18163 | 21823 | 396 |
1180902 | 1180902 | 2021-04-02 | Vanderburgh | Indiana | 18163 | 21805 | 396 |
1177655 | 1177655 | 2021-04-01 | Vanderburgh | Indiana | 18163 | 21785 | 395 |
1174408 | 1174408 | 2021-03-31 | Vanderburgh | Indiana | 18163 | 21762 | 395 |
1171161 | 1171161 | 2021-03-30 | Vanderburgh | Indiana | 18163 | 21738 | 395 |
1167913 | 1167913 | 2021-03-29 | Vanderburgh | Indiana | 18163 | 21719 | 394 |
1164665 | 1164665 | 2021-03-28 | Vanderburgh | Indiana | 18163 | 21709 | 394 |
1161417 | 1161417 | 2021-03-27 | Vanderburgh | Indiana | 18163 | 21689 | 393 |
1158169 | 1158169 | 2021-03-26 | Vanderburgh | Indiana | 18163 | 21672 | 393 |
1154922 | 1154922 | 2021-03-25 | Vanderburgh | Indiana | 18163 | 21658 | 393 |
1151675 | 1151675 | 2021-03-24 | Vanderburgh | Indiana | 18163 | 21634 | 393 |
1148428 | 1148428 | 2021-03-23 | Vanderburgh | Indiana | 18163 | 21603 | 392 |
1145181 | 1145181 | 2021-03-22 | Vanderburgh | Indiana | 18163 | 21594 | 391 |
1141934 | 1141934 | 2021-03-21 | Vanderburgh | Indiana | 18163 | 21586 | 391 |
1138688 | 1138688 | 2021-03-20 | Vanderburgh | Indiana | 18163 | 21579 | 391 |
1135442 | 1135442 | 2021-03-19 | Vanderburgh | Indiana | 18163 | 21564 | 391 |
1132195 | 1132195 | 2021-03-18 | Vanderburgh | Indiana | 18163 | 21540 | 391 |
1128947 | 1128947 | 2021-03-17 | Vanderburgh | Indiana | 18163 | 21521 | 391 |
1125701 | 1125701 | 2021-03-16 | Vanderburgh | Indiana | 18163 | 21503 | 391 |
1122455 | 1122455 | 2021-03-15 | Vanderburgh | Indiana | 18163 | 21494 | 391 |
1119208 | 1119208 | 2021-03-14 | Vanderburgh | Indiana | 18163 | 21487 | 391 |
1115961 | 1115961 | 2021-03-13 | Vanderburgh | Indiana | 18163 | 21473 | 390 |
1112715 | 1112715 | 2021-03-12 | Vanderburgh | Indiana | 18163 | 21450 | 390 |
1109469 | 1109469 | 2021-03-11 | Vanderburgh | Indiana | 18163 | 21418 | 389 |
1106223 | 1106223 | 2021-03-10 | Vanderburgh | Indiana | 18163 | 21394 | 388 |
1102977 | 1102977 | 2021-03-09 | Vanderburgh | Indiana | 18163 | 21368 | 388 |
1099731 | 1099731 | 2021-03-08 | Vanderburgh | Indiana | 18163 | 21357 | 388 |
1096483 | 1096483 | 2021-03-07 | Vanderburgh | Indiana | 18163 | 21353 | 388 |
1093237 | 1093237 | 2021-03-06 | Vanderburgh | Indiana | 18163 | 21336 | 388 |
1089991 | 1089991 | 2021-03-05 | Vanderburgh | Indiana | 18163 | 21325 | 388 |
1086746 | 1086746 | 2021-03-04 | Vanderburgh | Indiana | 18163 | 21310 | 388 |
1083500 | 1083500 | 2021-03-03 | Vanderburgh | Indiana | 18163 | 21293 | 385 |
1080254 | 1080254 | 2021-03-02 | Vanderburgh | Indiana | 18163 | 21271 | 385 |
1077009 | 1077009 | 2021-03-01 | Vanderburgh | Indiana | 18163 | 21257 | 384 |
1073763 | 1073763 | 2021-02-28 | Vanderburgh | Indiana | 18163 | 21255 | 384 |
1070517 | 1070517 | 2021-02-27 | Vanderburgh | Indiana | 18163 | 21235 | 383 |
1067272 | 1067272 | 2021-02-26 | Vanderburgh | Indiana | 18163 | 21202 | 383 |
1064027 | 1064027 | 2021-02-25 | Vanderburgh | Indiana | 18163 | 21183 | 383 |
1060782 | 1060782 | 2021-02-24 | Vanderburgh | Indiana | 18163 | 21158 | 383 |
1057536 | 1057536 | 2021-02-23 | Vanderburgh | Indiana | 18163 | 21125 | 383 |
1054290 | 1054290 | 2021-02-22 | Vanderburgh | Indiana | 18163 | 21096 | 381 |
1051043 | 1051043 | 2021-02-21 | Vanderburgh | Indiana | 18163 | 21077 | 377 |
1047796 | 1047796 | 2021-02-20 | Vanderburgh | Indiana | 18163 | 21058 | 376 |
1044551 | 1044551 | 2021-02-19 | Vanderburgh | Indiana | 18163 | 21024 | 376 |
1041306 | 1041306 | 2021-02-18 | Vanderburgh | Indiana | 18163 | 20996 | 376 |
1038061 | 1038061 | 2021-02-17 | Vanderburgh | Indiana | 18163 | 20968 | 375 |
1034816 | 1034816 | 2021-02-16 | Vanderburgh | Indiana | 18163 | 20955 | 375 |
1031570 | 1031570 | 2021-02-15 | Vanderburgh | Indiana | 18163 | 20916 | 375 |
1028323 | 1028323 | 2021-02-14 | Vanderburgh | Indiana | 18163 | 20895 | 375 |
1025078 | 1025078 | 2021-02-13 | Vanderburgh | Indiana | 18163 | 20857 | 374 |
1021833 | 1021833 | 2021-02-12 | Vanderburgh | Indiana | 18163 | 20804 | 371 |
1018588 | 1018588 | 2021-02-11 | Vanderburgh | Indiana | 18163 | 20757 | 369 |
1015343 | 1015343 | 2021-02-10 | Vanderburgh | Indiana | 18163 | 20720 | 368 |
1012098 | 1012098 | 2021-02-09 | Vanderburgh | Indiana | 18163 | 20647 | 362 |
1008852 | 1008852 | 2021-02-08 | Vanderburgh | Indiana | 18163 | 20612 | 361 |
1005606 | 1005606 | 2021-02-07 | Vanderburgh | Indiana | 18163 | 20580 | 360 |
1002360 | 1002360 | 2021-02-06 | Vanderburgh | Indiana | 18163 | 20514 | 355 |
999114 | 999114 | 2021-02-05 | Vanderburgh | Indiana | 18163 | 20381 | 353 |
995868 | 995868 | 2021-02-04 | Vanderburgh | Indiana | 18163 | 20350 | 352 |
992622 | 992622 | 2021-02-03 | Vanderburgh | Indiana | 18163 | 20302 | 267 |
989376 | 989376 | 2021-02-02 | Vanderburgh | Indiana | 18163 | 20237 | 266 |
986129 | 986129 | 2021-02-01 | Vanderburgh | Indiana | 18163 | 20187 | 264 |
982882 | 982882 | 2021-01-31 | Vanderburgh | Indiana | 18163 | 20131 | 264 |
979636 | 979636 | 2021-01-30 | Vanderburgh | Indiana | 18163 | 20078 | 264 |
976390 | 976390 | 2021-01-29 | Vanderburgh | Indiana | 18163 | 20004 | 264 |
973145 | 973145 | 2021-01-28 | Vanderburgh | Indiana | 18163 | 19913 | 261 |
969900 | 969900 | 2021-01-27 | Vanderburgh | Indiana | 18163 | 19803 | 260 |
966656 | 966656 | 2021-01-26 | Vanderburgh | Indiana | 18163 | 19687 | 259 |
963411 | 963411 | 2021-01-25 | Vanderburgh | Indiana | 18163 | 19618 | 254 |
960166 | 960166 | 2021-01-24 | Vanderburgh | Indiana | 18163 | 19521 | 254 |
956920 | 956920 | 2021-01-23 | Vanderburgh | Indiana | 18163 | 19419 | 253 |
953675 | 953675 | 2021-01-22 | Vanderburgh | Indiana | 18163 | 19300 | 252 |
950430 | 950430 | 2021-01-21 | Vanderburgh | Indiana | 18163 | 19168 | 250 |
947184 | 947184 | 2021-01-20 | Vanderburgh | Indiana | 18163 | 19020 | 247 |
943937 | 943937 | 2021-01-19 | Vanderburgh | Indiana | 18163 | 18864 | 240 |
940692 | 940692 | 2021-01-18 | Vanderburgh | Indiana | 18163 | 18767 | 217 |
937447 | 937447 | 2021-01-17 | Vanderburgh | Indiana | 18163 | 18651 | 217 |
934202 | 934202 | 2021-01-16 | Vanderburgh | Indiana | 18163 | 18527 | 217 |
930957 | 930957 | 2021-01-15 | Vanderburgh | Indiana | 18163 | 18374 | 216 |
927712 | 927712 | 2021-01-14 | Vanderburgh | Indiana | 18163 | 18200 | 215 |
924466 | 924466 | 2021-01-13 | Vanderburgh | Indiana | 18163 | 18041 | 214 |
921221 | 921221 | 2021-01-12 | Vanderburgh | Indiana | 18163 | 17871 | 213 |
917976 | 917976 | 2021-01-11 | Vanderburgh | Indiana | 18163 | 17694 | 211 |
914731 | 914731 | 2021-01-10 | Vanderburgh | Indiana | 18163 | 17547 | 211 |
911486 | 911486 | 2021-01-09 | Vanderburgh | Indiana | 18163 | 17380 | 211 |
908241 | 908241 | 2021-01-08 | Vanderburgh | Indiana | 18163 | 17170 | 211 |
904995 | 904995 | 2021-01-07 | Vanderburgh | Indiana | 18163 | 16997 | 211 |
901750 | 901750 | 2021-01-06 | Vanderburgh | Indiana | 18163 | 16719 | 211 |
898505 | 898505 | 2021-01-05 | Vanderburgh | Indiana | 18163 | 16484 | 210 |
895260 | 895260 | 2021-01-04 | Vanderburgh | Indiana | 18163 | 16266 | 208 |
892013 | 892013 | 2021-01-03 | Vanderburgh | Indiana | 18163 | 16099 | 208 |
888767 | 888767 | 2021-01-02 | Vanderburgh | Indiana | 18163 | 16000 | 205 |
885521 | 885521 | 2021-01-01 | Vanderburgh | Indiana | 18163 | 15793 | 204 |
882276 | 882276 | 2020-12-31 | Vanderburgh | Indiana | 18163 | 15554 | 203 |
879031 | 879031 | 2020-12-30 | Vanderburgh | Indiana | 18163 | 15241 | 201 |
875786 | 875786 | 2020-12-29 | Vanderburgh | Indiana | 18163 | 15070 | 194 |
872541 | 872541 | 2020-12-28 | Vanderburgh | Indiana | 18163 | 14949 | 192 |
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);