ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where fips = 18063 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054240 | 1054240 | 2021-02-22 | Hendricks | Indiana | 18063 | 15759 | 313 |
1050993 | 1050993 | 2021-02-21 | Hendricks | Indiana | 18063 | 15737 | 313 |
1047746 | 1047746 | 2021-02-20 | Hendricks | Indiana | 18063 | 15715 | 314 |
1044501 | 1044501 | 2021-02-19 | Hendricks | Indiana | 18063 | 15678 | 314 |
1041256 | 1041256 | 2021-02-18 | Hendricks | Indiana | 18063 | 15689 | 310 |
1038011 | 1038011 | 2021-02-17 | Hendricks | Indiana | 18063 | 15637 | 310 |
1034766 | 1034766 | 2021-02-16 | Hendricks | Indiana | 18063 | 15610 | 309 |
1031520 | 1031520 | 2021-02-15 | Hendricks | Indiana | 18063 | 15592 | 308 |
1028273 | 1028273 | 2021-02-14 | Hendricks | Indiana | 18063 | 15568 | 308 |
1025028 | 1025028 | 2021-02-13 | Hendricks | Indiana | 18063 | 15539 | 307 |
1021783 | 1021783 | 2021-02-12 | Hendricks | Indiana | 18063 | 15515 | 307 |
1018538 | 1018538 | 2021-02-11 | Hendricks | Indiana | 18063 | 15457 | 307 |
1015293 | 1015293 | 2021-02-10 | Hendricks | Indiana | 18063 | 15428 | 306 |
1012048 | 1012048 | 2021-02-09 | Hendricks | Indiana | 18063 | 15385 | 305 |
1008802 | 1008802 | 2021-02-08 | Hendricks | Indiana | 18063 | 15339 | 303 |
1005556 | 1005556 | 2021-02-07 | Hendricks | Indiana | 18063 | 15318 | 303 |
1002310 | 1002310 | 2021-02-06 | Hendricks | Indiana | 18063 | 15277 | 303 |
999064 | 999064 | 2021-02-05 | Hendricks | Indiana | 18063 | 15212 | 302 |
995818 | 995818 | 2021-02-04 | Hendricks | Indiana | 18063 | 15151 | 300 |
992572 | 992572 | 2021-02-03 | Hendricks | Indiana | 18063 | 15067 | 282 |
989326 | 989326 | 2021-02-02 | Hendricks | Indiana | 18063 | 15028 | 282 |
986079 | 986079 | 2021-02-01 | Hendricks | Indiana | 18063 | 15001 | 280 |
982832 | 982832 | 2021-01-31 | Hendricks | Indiana | 18063 | 14946 | 280 |
979586 | 979586 | 2021-01-30 | Hendricks | Indiana | 18063 | 14928 | 280 |
976340 | 976340 | 2021-01-29 | Hendricks | Indiana | 18063 | 14844 | 277 |
973095 | 973095 | 2021-01-28 | Hendricks | Indiana | 18063 | 14732 | 273 |
969850 | 969850 | 2021-01-27 | Hendricks | Indiana | 18063 | 14672 | 272 |
966606 | 966606 | 2021-01-26 | Hendricks | Indiana | 18063 | 14604 | 273 |
963361 | 963361 | 2021-01-25 | Hendricks | Indiana | 18063 | 14538 | 270 |
960116 | 960116 | 2021-01-24 | Hendricks | Indiana | 18063 | 14493 | 268 |
956870 | 956870 | 2021-01-23 | Hendricks | Indiana | 18063 | 14454 | 268 |
953625 | 953625 | 2021-01-22 | Hendricks | Indiana | 18063 | 14347 | 267 |
950380 | 950380 | 2021-01-21 | Hendricks | Indiana | 18063 | 14240 | 266 |
947134 | 947134 | 2021-01-20 | Hendricks | Indiana | 18063 | 14126 | 263 |
943887 | 943887 | 2021-01-19 | Hendricks | Indiana | 18063 | 14062 | 261 |
940642 | 940642 | 2021-01-18 | Hendricks | Indiana | 18063 | 13983 | 261 |
937397 | 937397 | 2021-01-17 | Hendricks | Indiana | 18063 | 13922 | 260 |
934152 | 934152 | 2021-01-16 | Hendricks | Indiana | 18063 | 13845 | 260 |
930907 | 930907 | 2021-01-15 | Hendricks | Indiana | 18063 | 13749 | 257 |
927662 | 927662 | 2021-01-14 | Hendricks | Indiana | 18063 | 13612 | 255 |
924416 | 924416 | 2021-01-13 | Hendricks | Indiana | 18063 | 13422 | 254 |
921171 | 921171 | 2021-01-12 | Hendricks | Indiana | 18063 | 13317 | 251 |
917926 | 917926 | 2021-01-11 | Hendricks | Indiana | 18063 | 13225 | 250 |
914681 | 914681 | 2021-01-10 | Hendricks | Indiana | 18063 | 13122 | 249 |
911436 | 911436 | 2021-01-09 | Hendricks | Indiana | 18063 | 13001 | 248 |
908191 | 908191 | 2021-01-08 | Hendricks | Indiana | 18063 | 12835 | 247 |
904945 | 904945 | 2021-01-07 | Hendricks | Indiana | 18063 | 12591 | 246 |
901700 | 901700 | 2021-01-06 | Hendricks | Indiana | 18063 | 12340 | 246 |
898455 | 898455 | 2021-01-05 | Hendricks | Indiana | 18063 | 12188 | 244 |
895210 | 895210 | 2021-01-04 | Hendricks | Indiana | 18063 | 12111 | 240 |
891963 | 891963 | 2021-01-03 | Hendricks | Indiana | 18063 | 11994 | 237 |
888717 | 888717 | 2021-01-02 | Hendricks | Indiana | 18063 | 11919 | 235 |
885471 | 885471 | 2021-01-01 | Hendricks | Indiana | 18063 | 11709 | 235 |
882226 | 882226 | 2020-12-31 | Hendricks | Indiana | 18063 | 11514 | 228 |
878981 | 878981 | 2020-12-30 | Hendricks | Indiana | 18063 | 11281 | 225 |
875736 | 875736 | 2020-12-29 | Hendricks | Indiana | 18063 | 11165 | 224 |
872491 | 872491 | 2020-12-28 | Hendricks | Indiana | 18063 | 11012 | 222 |
869246 | 869246 | 2020-12-27 | Hendricks | Indiana | 18063 | 10963 | 222 |
866001 | 866001 | 2020-12-26 | Hendricks | Indiana | 18063 | 10909 | 220 |
862756 | 862756 | 2020-12-25 | Hendricks | Indiana | 18063 | 10754 | 219 |
859511 | 859511 | 2020-12-24 | Hendricks | Indiana | 18063 | 10614 | 219 |
856266 | 856266 | 2020-12-23 | Hendricks | Indiana | 18063 | 10409 | 218 |
853021 | 853021 | 2020-12-22 | Hendricks | Indiana | 18063 | 10289 | 215 |
849776 | 849776 | 2020-12-21 | Hendricks | Indiana | 18063 | 10158 | 210 |
846531 | 846531 | 2020-12-20 | Hendricks | Indiana | 18063 | 10063 | 210 |
843285 | 843285 | 2020-12-19 | Hendricks | Indiana | 18063 | 9872 | 210 |
840040 | 840040 | 2020-12-18 | Hendricks | Indiana | 18063 | 9721 | 207 |
836795 | 836795 | 2020-12-17 | Hendricks | Indiana | 18063 | 9575 | 205 |
833549 | 833549 | 2020-12-16 | Hendricks | Indiana | 18063 | 9401 | 205 |
830302 | 830302 | 2020-12-15 | Hendricks | Indiana | 18063 | 9235 | 203 |
827056 | 827056 | 2020-12-14 | Hendricks | Indiana | 18063 | 9151 | 201 |
823809 | 823809 | 2020-12-13 | Hendricks | Indiana | 18063 | 9037 | 201 |
820563 | 820563 | 2020-12-12 | Hendricks | Indiana | 18063 | 8874 | 198 |
817317 | 817317 | 2020-12-11 | Hendricks | Indiana | 18063 | 8675 | 195 |
814071 | 814071 | 2020-12-10 | Hendricks | Indiana | 18063 | 8438 | 192 |
810826 | 810826 | 2020-12-09 | Hendricks | Indiana | 18063 | 8292 | 188 |
807581 | 807581 | 2020-12-08 | Hendricks | Indiana | 18063 | 8177 | 187 |
804336 | 804336 | 2020-12-07 | Hendricks | Indiana | 18063 | 8088 | 186 |
801091 | 801091 | 2020-12-06 | Hendricks | Indiana | 18063 | 7933 | 183 |
797846 | 797846 | 2020-12-05 | Hendricks | Indiana | 18063 | 7765 | 183 |
794601 | 794601 | 2020-12-04 | Hendricks | Indiana | 18063 | 7604 | 182 |
791356 | 791356 | 2020-12-03 | Hendricks | Indiana | 18063 | 7392 | 182 |
788111 | 788111 | 2020-12-02 | Hendricks | Indiana | 18063 | 7180 | 180 |
784867 | 784867 | 2020-12-01 | Hendricks | Indiana | 18063 | 6996 | 179 |
781622 | 781622 | 2020-11-30 | Hendricks | Indiana | 18063 | 6855 | 179 |
778376 | 778376 | 2020-11-29 | Hendricks | Indiana | 18063 | 6709 | 175 |
775131 | 775131 | 2020-11-28 | Hendricks | Indiana | 18063 | 6551 | 175 |
771886 | 771886 | 2020-11-27 | Hendricks | Indiana | 18063 | 6447 | 175 |
768641 | 768641 | 2020-11-26 | Hendricks | Indiana | 18063 | 6302 | 175 |
765395 | 765395 | 2020-11-25 | Hendricks | Indiana | 18063 | 6133 | 174 |
762150 | 762150 | 2020-11-24 | Hendricks | Indiana | 18063 | 5979 | 173 |
758905 | 758905 | 2020-11-23 | Hendricks | Indiana | 18063 | 5842 | 171 |
755658 | 755658 | 2020-11-22 | Hendricks | Indiana | 18063 | 5754 | 171 |
752412 | 752412 | 2020-11-21 | Hendricks | Indiana | 18063 | 5574 | 170 |
749166 | 749166 | 2020-11-20 | Hendricks | Indiana | 18063 | 5444 | 170 |
745920 | 745920 | 2020-11-19 | Hendricks | Indiana | 18063 | 5314 | 170 |
742673 | 742673 | 2020-11-18 | Hendricks | Indiana | 18063 | 5148 | 169 |
739426 | 739426 | 2020-11-17 | Hendricks | Indiana | 18063 | 5008 | 170 |
736182 | 736182 | 2020-11-16 | Hendricks | Indiana | 18063 | 4893 | 167 |
732936 | 732936 | 2020-11-15 | Hendricks | Indiana | 18063 | 4796 | 165 |
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);