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 |
---|---|---|---|---|---|---|---|
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 |
869296 | 869296 | 2020-12-27 | Vanderburgh | Indiana | 18163 | 14787 | 191 |
866051 | 866051 | 2020-12-26 | Vanderburgh | Indiana | 18163 | 14736 | 190 |
862806 | 862806 | 2020-12-25 | Vanderburgh | Indiana | 18163 | 14562 | 190 |
859561 | 859561 | 2020-12-24 | Vanderburgh | Indiana | 18163 | 14373 | 190 |
856316 | 856316 | 2020-12-23 | Vanderburgh | Indiana | 18163 | 14213 | 186 |
853071 | 853071 | 2020-12-22 | Vanderburgh | Indiana | 18163 | 13975 | 184 |
849826 | 849826 | 2020-12-21 | Vanderburgh | Indiana | 18163 | 13886 | 183 |
846581 | 846581 | 2020-12-20 | Vanderburgh | Indiana | 18163 | 13774 | 183 |
843335 | 843335 | 2020-12-19 | Vanderburgh | Indiana | 18163 | 13548 | 179 |
840090 | 840090 | 2020-12-18 | Vanderburgh | Indiana | 18163 | 13455 | 176 |
836845 | 836845 | 2020-12-17 | Vanderburgh | Indiana | 18163 | 13258 | 174 |
833599 | 833599 | 2020-12-16 | Vanderburgh | Indiana | 18163 | 13116 | 174 |
830352 | 830352 | 2020-12-15 | Vanderburgh | Indiana | 18163 | 12916 | 173 |
827106 | 827106 | 2020-12-14 | Vanderburgh | Indiana | 18163 | 12812 | 159 |
823859 | 823859 | 2020-12-13 | Vanderburgh | Indiana | 18163 | 12601 | 159 |
820613 | 820613 | 2020-12-12 | Vanderburgh | Indiana | 18163 | 12436 | 159 |
817367 | 817367 | 2020-12-11 | Vanderburgh | Indiana | 18163 | 12267 | 156 |
814121 | 814121 | 2020-12-10 | Vanderburgh | Indiana | 18163 | 12121 | 153 |
810876 | 810876 | 2020-12-09 | Vanderburgh | Indiana | 18163 | 12033 | 152 |
807631 | 807631 | 2020-12-08 | Vanderburgh | Indiana | 18163 | 11837 | 151 |
804386 | 804386 | 2020-12-07 | Vanderburgh | Indiana | 18163 | 11736 | 142 |
801141 | 801141 | 2020-12-06 | Vanderburgh | Indiana | 18163 | 11557 | 141 |
797896 | 797896 | 2020-12-05 | Vanderburgh | Indiana | 18163 | 11436 | 141 |
794651 | 794651 | 2020-12-04 | Vanderburgh | Indiana | 18163 | 11180 | 140 |
791406 | 791406 | 2020-12-03 | Vanderburgh | Indiana | 18163 | 10962 | 139 |
788161 | 788161 | 2020-12-02 | Vanderburgh | Indiana | 18163 | 10868 | 136 |
784917 | 784917 | 2020-12-01 | Vanderburgh | Indiana | 18163 | 10677 | 130 |
781672 | 781672 | 2020-11-30 | Vanderburgh | Indiana | 18163 | 10551 | 129 |
778426 | 778426 | 2020-11-29 | Vanderburgh | Indiana | 18163 | 10285 | 128 |
775181 | 775181 | 2020-11-28 | Vanderburgh | Indiana | 18163 | 10171 | 128 |
771936 | 771936 | 2020-11-27 | Vanderburgh | Indiana | 18163 | 10033 | 122 |
768691 | 768691 | 2020-11-26 | Vanderburgh | Indiana | 18163 | 9844 | 122 |
765445 | 765445 | 2020-11-25 | Vanderburgh | Indiana | 18163 | 9756 | 121 |
762200 | 762200 | 2020-11-24 | Vanderburgh | Indiana | 18163 | 9557 | 116 |
758955 | 758955 | 2020-11-23 | Vanderburgh | Indiana | 18163 | 9433 | 113 |
755708 | 755708 | 2020-11-22 | Vanderburgh | Indiana | 18163 | 9223 | 113 |
752462 | 752462 | 2020-11-21 | Vanderburgh | Indiana | 18163 | 9096 | 112 |
749216 | 749216 | 2020-11-20 | Vanderburgh | Indiana | 18163 | 8950 | 112 |
745970 | 745970 | 2020-11-19 | Vanderburgh | Indiana | 18163 | 8766 | 110 |
742723 | 742723 | 2020-11-18 | Vanderburgh | Indiana | 18163 | 8642 | 109 |
739476 | 739476 | 2020-11-17 | Vanderburgh | Indiana | 18163 | 8527 | 108 |
736232 | 736232 | 2020-11-16 | Vanderburgh | Indiana | 18163 | 8397 | 101 |
732986 | 732986 | 2020-11-15 | Vanderburgh | Indiana | 18163 | 8231 | 100 |
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);