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 |
---|---|---|---|---|---|---|---|
1193840 | 1193840 | 2021-04-06 | Hamilton | Indiana | 18057 | 33795 | 423 |
1190590 | 1190590 | 2021-04-05 | Hamilton | Indiana | 18057 | 33766 | 423 |
1187343 | 1187343 | 2021-04-04 | Hamilton | Indiana | 18057 | 33735 | 423 |
1184096 | 1184096 | 2021-04-03 | Hamilton | Indiana | 18057 | 33698 | 423 |
1180849 | 1180849 | 2021-04-02 | Hamilton | Indiana | 18057 | 33635 | 422 |
1177602 | 1177602 | 2021-04-01 | Hamilton | Indiana | 18057 | 33567 | 422 |
1174355 | 1174355 | 2021-03-31 | Hamilton | Indiana | 18057 | 33490 | 422 |
1171108 | 1171108 | 2021-03-30 | Hamilton | Indiana | 18057 | 33427 | 422 |
1167860 | 1167860 | 2021-03-29 | Hamilton | Indiana | 18057 | 33390 | 421 |
1164612 | 1164612 | 2021-03-28 | Hamilton | Indiana | 18057 | 33346 | 421 |
1161364 | 1161364 | 2021-03-27 | Hamilton | Indiana | 18057 | 33301 | 421 |
1158116 | 1158116 | 2021-03-26 | Hamilton | Indiana | 18057 | 33241 | 421 |
1154869 | 1154869 | 2021-03-25 | Hamilton | Indiana | 18057 | 33192 | 421 |
1151622 | 1151622 | 2021-03-24 | Hamilton | Indiana | 18057 | 33148 | 421 |
1148375 | 1148375 | 2021-03-23 | Hamilton | Indiana | 18057 | 33104 | 420 |
1145128 | 1145128 | 2021-03-22 | Hamilton | Indiana | 18057 | 33078 | 420 |
1141881 | 1141881 | 2021-03-21 | Hamilton | Indiana | 18057 | 33046 | 420 |
1138635 | 1138635 | 2021-03-20 | Hamilton | Indiana | 18057 | 33011 | 420 |
1135389 | 1135389 | 2021-03-19 | Hamilton | Indiana | 18057 | 32954 | 420 |
1132142 | 1132142 | 2021-03-18 | Hamilton | Indiana | 18057 | 32916 | 419 |
1128894 | 1128894 | 2021-03-17 | Hamilton | Indiana | 18057 | 32862 | 418 |
1125648 | 1125648 | 2021-03-16 | Hamilton | Indiana | 18057 | 32823 | 418 |
1122402 | 1122402 | 2021-03-15 | Hamilton | Indiana | 18057 | 32785 | 418 |
1119155 | 1119155 | 2021-03-14 | Hamilton | Indiana | 18057 | 32766 | 418 |
1115908 | 1115908 | 2021-03-13 | Hamilton | Indiana | 18057 | 32745 | 418 |
1112662 | 1112662 | 2021-03-12 | Hamilton | Indiana | 18057 | 32701 | 417 |
1109416 | 1109416 | 2021-03-11 | Hamilton | Indiana | 18057 | 32670 | 417 |
1106170 | 1106170 | 2021-03-10 | Hamilton | Indiana | 18057 | 32631 | 416 |
1102924 | 1102924 | 2021-03-09 | Hamilton | Indiana | 18057 | 32586 | 416 |
1099678 | 1099678 | 2021-03-08 | Hamilton | Indiana | 18057 | 32568 | 416 |
1096430 | 1096430 | 2021-03-07 | Hamilton | Indiana | 18057 | 32535 | 416 |
1093184 | 1093184 | 2021-03-06 | Hamilton | Indiana | 18057 | 32491 | 416 |
1089938 | 1089938 | 2021-03-05 | Hamilton | Indiana | 18057 | 32277 | 416 |
1086693 | 1086693 | 2021-03-04 | Hamilton | Indiana | 18057 | 32228 | 416 |
1083447 | 1083447 | 2021-03-03 | Hamilton | Indiana | 18057 | 32184 | 416 |
1080201 | 1080201 | 2021-03-02 | Hamilton | Indiana | 18057 | 32166 | 416 |
1076956 | 1076956 | 2021-03-01 | Hamilton | Indiana | 18057 | 32144 | 415 |
1073710 | 1073710 | 2021-02-28 | Hamilton | Indiana | 18057 | 32101 | 414 |
1070464 | 1070464 | 2021-02-27 | Hamilton | Indiana | 18057 | 32071 | 414 |
1067219 | 1067219 | 2021-02-26 | Hamilton | Indiana | 18057 | 32015 | 414 |
1063974 | 1063974 | 2021-02-25 | Hamilton | Indiana | 18057 | 31973 | 412 |
1060729 | 1060729 | 2021-02-24 | Hamilton | Indiana | 18057 | 31928 | 411 |
1057483 | 1057483 | 2021-02-23 | Hamilton | Indiana | 18057 | 31883 | 410 |
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 |
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);