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 |
---|---|---|---|---|---|---|---|
1054237 | 1054237 | 2021-02-22 | Hamilton | Indiana | 18057 | 31843 | 406 |
1050990 | 1050990 | 2021-02-21 | Hamilton | Indiana | 18057 | 31798 | 405 |
1047743 | 1047743 | 2021-02-20 | Hamilton | Indiana | 18057 | 31665 | 394 |
1044498 | 1044498 | 2021-02-19 | Hamilton | Indiana | 18057 | 31595 | 394 |
1041253 | 1041253 | 2021-02-18 | Hamilton | Indiana | 18057 | 31555 | 392 |
1038008 | 1038008 | 2021-02-17 | Hamilton | Indiana | 18057 | 31504 | 391 |
1034763 | 1034763 | 2021-02-16 | Hamilton | Indiana | 18057 | 31450 | 391 |
1031517 | 1031517 | 2021-02-15 | Hamilton | Indiana | 18057 | 31401 | 389 |
1028270 | 1028270 | 2021-02-14 | Hamilton | Indiana | 18057 | 31365 | 389 |
1025025 | 1025025 | 2021-02-13 | Hamilton | Indiana | 18057 | 31308 | 388 |
1021780 | 1021780 | 2021-02-12 | Hamilton | Indiana | 18057 | 31255 | 386 |
1018535 | 1018535 | 2021-02-11 | Hamilton | Indiana | 18057 | 31190 | 384 |
1015290 | 1015290 | 2021-02-10 | Hamilton | Indiana | 18057 | 31100 | 384 |
1012045 | 1012045 | 2021-02-09 | Hamilton | Indiana | 18057 | 31034 | 383 |
1008799 | 1008799 | 2021-02-08 | Hamilton | Indiana | 18057 | 30986 | 381 |
1005553 | 1005553 | 2021-02-07 | Hamilton | Indiana | 18057 | 30949 | 380 |
1002307 | 1002307 | 2021-02-06 | Hamilton | Indiana | 18057 | 30878 | 378 |
999061 | 999061 | 2021-02-05 | Hamilton | Indiana | 18057 | 30782 | 378 |
995815 | 995815 | 2021-02-04 | Hamilton | Indiana | 18057 | 30729 | 377 |
992569 | 992569 | 2021-02-03 | Hamilton | Indiana | 18057 | 30587 | 338 |
989323 | 989323 | 2021-02-02 | Hamilton | Indiana | 18057 | 30524 | 338 |
986076 | 986076 | 2021-02-01 | Hamilton | Indiana | 18057 | 30430 | 338 |
982829 | 982829 | 2021-01-31 | Hamilton | Indiana | 18057 | 30330 | 338 |
979583 | 979583 | 2021-01-30 | Hamilton | Indiana | 18057 | 30232 | 338 |
976337 | 976337 | 2021-01-29 | Hamilton | Indiana | 18057 | 30117 | 337 |
973092 | 973092 | 2021-01-28 | Hamilton | Indiana | 18057 | 30017 | 337 |
969847 | 969847 | 2021-01-27 | Hamilton | Indiana | 18057 | 29884 | 335 |
966603 | 966603 | 2021-01-26 | Hamilton | Indiana | 18057 | 29794 | 331 |
963358 | 963358 | 2021-01-25 | Hamilton | Indiana | 18057 | 29691 | 330 |
960113 | 960113 | 2021-01-24 | Hamilton | Indiana | 18057 | 29588 | 330 |
956867 | 956867 | 2021-01-23 | Hamilton | Indiana | 18057 | 29436 | 330 |
953622 | 953622 | 2021-01-22 | Hamilton | Indiana | 18057 | 29282 | 330 |
950377 | 950377 | 2021-01-21 | Hamilton | Indiana | 18057 | 29081 | 330 |
947131 | 947131 | 2021-01-20 | Hamilton | Indiana | 18057 | 28860 | 329 |
943884 | 943884 | 2021-01-19 | Hamilton | Indiana | 18057 | 28726 | 323 |
940639 | 940639 | 2021-01-18 | Hamilton | Indiana | 18057 | 28575 | 320 |
937394 | 937394 | 2021-01-17 | Hamilton | Indiana | 18057 | 28413 | 319 |
934149 | 934149 | 2021-01-16 | Hamilton | Indiana | 18057 | 28220 | 318 |
930904 | 930904 | 2021-01-15 | Hamilton | Indiana | 18057 | 27971 | 318 |
927659 | 927659 | 2021-01-14 | Hamilton | Indiana | 18057 | 27717 | 318 |
924413 | 924413 | 2021-01-13 | Hamilton | Indiana | 18057 | 27468 | 317 |
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 |
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);