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 |
---|---|---|---|---|---|---|---|
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 |
869293 | 869293 | 2020-12-27 | Tippecanoe | Indiana | 18157 | 14513 | 72 |
866048 | 866048 | 2020-12-26 | Tippecanoe | Indiana | 18157 | 14429 | 71 |
862803 | 862803 | 2020-12-25 | Tippecanoe | Indiana | 18157 | 14302 | 71 |
859558 | 859558 | 2020-12-24 | Tippecanoe | Indiana | 18157 | 14133 | 70 |
856313 | 856313 | 2020-12-23 | Tippecanoe | Indiana | 18157 | 13977 | 70 |
853068 | 853068 | 2020-12-22 | Tippecanoe | Indiana | 18157 | 13855 | 69 |
849823 | 849823 | 2020-12-21 | Tippecanoe | Indiana | 18157 | 13713 | 66 |
846578 | 846578 | 2020-12-20 | Tippecanoe | Indiana | 18157 | 13546 | 66 |
843332 | 843332 | 2020-12-19 | Tippecanoe | Indiana | 18157 | 13395 | 66 |
840087 | 840087 | 2020-12-18 | Tippecanoe | Indiana | 18157 | 13242 | 65 |
836842 | 836842 | 2020-12-17 | Tippecanoe | Indiana | 18157 | 13083 | 54 |
833596 | 833596 | 2020-12-16 | Tippecanoe | Indiana | 18157 | 12876 | 53 |
830349 | 830349 | 2020-12-15 | Tippecanoe | Indiana | 18157 | 12704 | 52 |
827103 | 827103 | 2020-12-14 | Tippecanoe | Indiana | 18157 | 12523 | 52 |
823856 | 823856 | 2020-12-13 | Tippecanoe | Indiana | 18157 | 12256 | 51 |
820610 | 820610 | 2020-12-12 | Tippecanoe | Indiana | 18157 | 12150 | 51 |
817364 | 817364 | 2020-12-11 | Tippecanoe | Indiana | 18157 | 11866 | 48 |
814118 | 814118 | 2020-12-10 | Tippecanoe | Indiana | 18157 | 11638 | 43 |
810873 | 810873 | 2020-12-09 | Tippecanoe | Indiana | 18157 | 11441 | 42 |
807628 | 807628 | 2020-12-08 | Tippecanoe | Indiana | 18157 | 11259 | 39 |
804383 | 804383 | 2020-12-07 | Tippecanoe | Indiana | 18157 | 11067 | 39 |
801138 | 801138 | 2020-12-06 | Tippecanoe | Indiana | 18157 | 10846 | 38 |
797893 | 797893 | 2020-12-05 | Tippecanoe | Indiana | 18157 | 10688 | 38 |
794648 | 794648 | 2020-12-04 | Tippecanoe | Indiana | 18157 | 10413 | 37 |
791403 | 791403 | 2020-12-03 | Tippecanoe | Indiana | 18157 | 10126 | 36 |
788158 | 788158 | 2020-12-02 | Tippecanoe | Indiana | 18157 | 9914 | 34 |
784914 | 784914 | 2020-12-01 | Tippecanoe | Indiana | 18157 | 9651 | 34 |
781669 | 781669 | 2020-11-30 | Tippecanoe | Indiana | 18157 | 9484 | 31 |
778423 | 778423 | 2020-11-29 | Tippecanoe | Indiana | 18157 | 9205 | 31 |
775178 | 775178 | 2020-11-28 | Tippecanoe | Indiana | 18157 | 9077 | 31 |
771933 | 771933 | 2020-11-27 | Tippecanoe | Indiana | 18157 | 8970 | 30 |
768688 | 768688 | 2020-11-26 | Tippecanoe | Indiana | 18157 | 8809 | 30 |
765442 | 765442 | 2020-11-25 | Tippecanoe | Indiana | 18157 | 8590 | 28 |
762197 | 762197 | 2020-11-24 | Tippecanoe | Indiana | 18157 | 8452 | 28 |
758952 | 758952 | 2020-11-23 | Tippecanoe | Indiana | 18157 | 8270 | 28 |
755705 | 755705 | 2020-11-22 | Tippecanoe | Indiana | 18157 | 8079 | 28 |
752459 | 752459 | 2020-11-21 | Tippecanoe | Indiana | 18157 | 7868 | 28 |
749213 | 749213 | 2020-11-20 | Tippecanoe | Indiana | 18157 | 7627 | 26 |
745967 | 745967 | 2020-11-19 | Tippecanoe | Indiana | 18157 | 7418 | 26 |
742720 | 742720 | 2020-11-18 | Tippecanoe | Indiana | 18157 | 7156 | 25 |
739473 | 739473 | 2020-11-17 | Tippecanoe | Indiana | 18157 | 6984 | 24 |
736229 | 736229 | 2020-11-16 | Tippecanoe | Indiana | 18157 | 6814 | 24 |
732983 | 732983 | 2020-11-15 | Tippecanoe | Indiana | 18157 | 6570 | 24 |
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);