ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 18057 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921168 | 921168 | 2021-01-12 | Hamilton | Indiana | 18057 | 27267 | 312 |
917923 | 917923 | 2021-01-11 | Hamilton | Indiana | 18057 | 27067 | 309 |
914678 | 914678 | 2021-01-10 | Hamilton | Indiana | 18057 | 26811 | 307 |
911433 | 911433 | 2021-01-09 | Hamilton | Indiana | 18057 | 26538 | 307 |
908188 | 908188 | 2021-01-08 | Hamilton | Indiana | 18057 | 26186 | 306 |
904942 | 904942 | 2021-01-07 | Hamilton | Indiana | 18057 | 25885 | 306 |
901697 | 901697 | 2021-01-06 | Hamilton | Indiana | 18057 | 25457 | 305 |
898452 | 898452 | 2021-01-05 | Hamilton | Indiana | 18057 | 25177 | 304 |
895207 | 895207 | 2021-01-04 | Hamilton | Indiana | 18057 | 24963 | 301 |
891960 | 891960 | 2021-01-03 | Hamilton | Indiana | 18057 | 24794 | 297 |
888714 | 888714 | 2021-01-02 | Hamilton | Indiana | 18057 | 24551 | 295 |
885468 | 885468 | 2021-01-01 | Hamilton | Indiana | 18057 | 24289 | 295 |
882223 | 882223 | 2020-12-31 | Hamilton | Indiana | 18057 | 23956 | 288 |
878978 | 878978 | 2020-12-30 | Hamilton | Indiana | 18057 | 23585 | 286 |
875733 | 875733 | 2020-12-29 | Hamilton | Indiana | 18057 | 23322 | 284 |
872488 | 872488 | 2020-12-28 | Hamilton | Indiana | 18057 | 23037 | 281 |
869243 | 869243 | 2020-12-27 | Hamilton | Indiana | 18057 | 22870 | 278 |
865998 | 865998 | 2020-12-26 | Hamilton | Indiana | 18057 | 22737 | 277 |
862753 | 862753 | 2020-12-25 | Hamilton | Indiana | 18057 | 22520 | 275 |
859508 | 859508 | 2020-12-24 | Hamilton | Indiana | 18057 | 22222 | 272 |
856263 | 856263 | 2020-12-23 | Hamilton | Indiana | 18057 | 21908 | 265 |
853018 | 853018 | 2020-12-22 | Hamilton | Indiana | 18057 | 21662 | 260 |
849773 | 849773 | 2020-12-21 | Hamilton | Indiana | 18057 | 21403 | 249 |
846528 | 846528 | 2020-12-20 | Hamilton | Indiana | 18057 | 21156 | 248 |
843282 | 843282 | 2020-12-19 | Hamilton | Indiana | 18057 | 20817 | 247 |
840037 | 840037 | 2020-12-18 | Hamilton | Indiana | 18057 | 20623 | 244 |
836792 | 836792 | 2020-12-17 | Hamilton | Indiana | 18057 | 20223 | 243 |
833546 | 833546 | 2020-12-16 | Hamilton | Indiana | 18057 | 19885 | 240 |
830299 | 830299 | 2020-12-15 | Hamilton | Indiana | 18057 | 19555 | 228 |
827053 | 827053 | 2020-12-14 | Hamilton | Indiana | 18057 | 19278 | 223 |
823806 | 823806 | 2020-12-13 | Hamilton | Indiana | 18057 | 19048 | 223 |
820560 | 820560 | 2020-12-12 | Hamilton | Indiana | 18057 | 18666 | 221 |
817314 | 817314 | 2020-12-11 | Hamilton | Indiana | 18057 | 18298 | 217 |
814068 | 814068 | 2020-12-10 | Hamilton | Indiana | 18057 | 17940 | 216 |
810823 | 810823 | 2020-12-09 | Hamilton | Indiana | 18057 | 17542 | 211 |
807578 | 807578 | 2020-12-08 | Hamilton | Indiana | 18057 | 17246 | 202 |
804333 | 804333 | 2020-12-07 | Hamilton | Indiana | 18057 | 16984 | 197 |
801088 | 801088 | 2020-12-06 | Hamilton | Indiana | 18057 | 16664 | 196 |
797843 | 797843 | 2020-12-05 | Hamilton | Indiana | 18057 | 16325 | 196 |
794598 | 794598 | 2020-12-04 | Hamilton | Indiana | 18057 | 15931 | 195 |
791353 | 791353 | 2020-12-03 | Hamilton | Indiana | 18057 | 15494 | 193 |
788108 | 788108 | 2020-12-02 | Hamilton | Indiana | 18057 | 15009 | 192 |
784864 | 784864 | 2020-12-01 | Hamilton | Indiana | 18057 | 14654 | 185 |
781619 | 781619 | 2020-11-30 | Hamilton | Indiana | 18057 | 14400 | 182 |
778373 | 778373 | 2020-11-29 | Hamilton | Indiana | 18057 | 14097 | 181 |
775128 | 775128 | 2020-11-28 | Hamilton | Indiana | 18057 | 13866 | 180 |
771883 | 771883 | 2020-11-27 | Hamilton | Indiana | 18057 | 13648 | 180 |
768638 | 768638 | 2020-11-26 | Hamilton | Indiana | 18057 | 13412 | 179 |
765392 | 765392 | 2020-11-25 | Hamilton | Indiana | 18057 | 13047 | 177 |
762147 | 762147 | 2020-11-24 | Hamilton | Indiana | 18057 | 12732 | 177 |
758902 | 758902 | 2020-11-23 | Hamilton | Indiana | 18057 | 12495 | 174 |
755655 | 755655 | 2020-11-22 | Hamilton | Indiana | 18057 | 12261 | 173 |
752409 | 752409 | 2020-11-21 | Hamilton | Indiana | 18057 | 11925 | 170 |
749163 | 749163 | 2020-11-20 | Hamilton | Indiana | 18057 | 11621 | 170 |
745917 | 745917 | 2020-11-19 | Hamilton | Indiana | 18057 | 11307 | 167 |
742670 | 742670 | 2020-11-18 | Hamilton | Indiana | 18057 | 10940 | 165 |
739423 | 739423 | 2020-11-17 | Hamilton | Indiana | 18057 | 10683 | 164 |
736179 | 736179 | 2020-11-16 | Hamilton | Indiana | 18057 | 10435 | 163 |
732933 | 732933 | 2020-11-15 | Hamilton | Indiana | 18057 | 10224 | 163 |
729688 | 729688 | 2020-11-14 | Hamilton | Indiana | 18057 | 9925 | 163 |
726445 | 726445 | 2020-11-13 | Hamilton | Indiana | 18057 | 9624 | 163 |
723202 | 723202 | 2020-11-12 | Hamilton | Indiana | 18057 | 9350 | 161 |
719959 | 719959 | 2020-11-11 | Hamilton | Indiana | 18057 | 9023 | 159 |
716716 | 716716 | 2020-11-10 | Hamilton | Indiana | 18057 | 8822 | 157 |
713472 | 713472 | 2020-11-09 | Hamilton | Indiana | 18057 | 8624 | 150 |
710228 | 710228 | 2020-11-08 | Hamilton | Indiana | 18057 | 8451 | 145 |
706984 | 706984 | 2020-11-07 | Hamilton | Indiana | 18057 | 8220 | 145 |
703741 | 703741 | 2020-11-06 | Hamilton | Indiana | 18057 | 7955 | 141 |
700499 | 700499 | 2020-11-05 | Hamilton | Indiana | 18057 | 7724 | 141 |
697255 | 697255 | 2020-11-04 | Hamilton | Indiana | 18057 | 7504 | 140 |
694013 | 694013 | 2020-11-03 | Hamilton | Indiana | 18057 | 7316 | 140 |
690770 | 690770 | 2020-11-02 | Hamilton | Indiana | 18057 | 7232 | 135 |
687525 | 687525 | 2020-11-01 | Hamilton | Indiana | 18057 | 7118 | 134 |
684281 | 684281 | 2020-10-31 | Hamilton | Indiana | 18057 | 6985 | 133 |
681038 | 681038 | 2020-10-30 | Hamilton | Indiana | 18057 | 6832 | 131 |
677795 | 677795 | 2020-10-29 | Hamilton | Indiana | 18057 | 6730 | 129 |
674552 | 674552 | 2020-10-28 | Hamilton | Indiana | 18057 | 6574 | 128 |
671310 | 671310 | 2020-10-27 | Hamilton | Indiana | 18057 | 6495 | 126 |
668067 | 668067 | 2020-10-26 | Hamilton | Indiana | 18057 | 6433 | 124 |
664823 | 664823 | 2020-10-25 | Hamilton | Indiana | 18057 | 6368 | 123 |
661578 | 661578 | 2020-10-24 | Hamilton | Indiana | 18057 | 6326 | 123 |
658334 | 658334 | 2020-10-23 | Hamilton | Indiana | 18057 | 6248 | 122 |
655089 | 655089 | 2020-10-22 | Hamilton | Indiana | 18057 | 6150 | 122 |
651844 | 651844 | 2020-10-21 | Hamilton | Indiana | 18057 | 6032 | 122 |
648600 | 648600 | 2020-10-20 | Hamilton | Indiana | 18057 | 5994 | 122 |
645355 | 645355 | 2020-10-19 | Hamilton | Indiana | 18057 | 5955 | 122 |
642108 | 642108 | 2020-10-18 | Hamilton | Indiana | 18057 | 5904 | 122 |
638861 | 638861 | 2020-10-17 | Hamilton | Indiana | 18057 | 5854 | 121 |
635615 | 635615 | 2020-10-16 | Hamilton | Indiana | 18057 | 5791 | 121 |
632369 | 632369 | 2020-10-15 | Hamilton | Indiana | 18057 | 5691 | 121 |
629125 | 629125 | 2020-10-14 | Hamilton | Indiana | 18057 | 5635 | 121 |
625882 | 625882 | 2020-10-13 | Hamilton | Indiana | 18057 | 5593 | 121 |
622640 | 622640 | 2020-10-12 | Hamilton | Indiana | 18057 | 5561 | 119 |
619396 | 619396 | 2020-10-11 | Hamilton | Indiana | 18057 | 5508 | 119 |
616154 | 616154 | 2020-10-10 | Hamilton | Indiana | 18057 | 5473 | 119 |
612913 | 612913 | 2020-10-09 | Hamilton | Indiana | 18057 | 5414 | 119 |
609671 | 609671 | 2020-10-08 | Hamilton | Indiana | 18057 | 5357 | 119 |
606428 | 606428 | 2020-10-07 | Hamilton | Indiana | 18057 | 5317 | 119 |
603186 | 603186 | 2020-10-06 | Hamilton | Indiana | 18057 | 5277 | 120 |
599943 | 599943 | 2020-10-05 | Hamilton | Indiana | 18057 | 5257 | 119 |
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);