ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Hamilton" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1278275 | 1278275 | 2021-05-02 | Hamilton | Indiana | 18057 | 35334 | 426 |
1275028 | 1275028 | 2021-05-01 | Hamilton | Indiana | 18057 | 35275 | 426 |
1271781 | 1271781 | 2021-04-30 | Hamilton | Indiana | 18057 | 35218 | 426 |
1268534 | 1268534 | 2021-04-29 | Hamilton | Indiana | 18057 | 35141 | 426 |
1265287 | 1265287 | 2021-04-28 | Hamilton | Indiana | 18057 | 35077 | 426 |
1262040 | 1262040 | 2021-04-27 | Hamilton | Indiana | 18057 | 35018 | 425 |
1258793 | 1258793 | 2021-04-26 | Hamilton | Indiana | 18057 | 34974 | 425 |
1255546 | 1255546 | 2021-04-25 | Hamilton | Indiana | 18057 | 34937 | 425 |
1252299 | 1252299 | 2021-04-24 | Hamilton | Indiana | 18057 | 34878 | 425 |
1249052 | 1249052 | 2021-04-23 | Hamilton | Indiana | 18057 | 34820 | 424 |
1245805 | 1245805 | 2021-04-22 | Hamilton | Indiana | 18057 | 34755 | 424 |
1242558 | 1242558 | 2021-04-21 | Hamilton | Indiana | 18057 | 34689 | 424 |
1239311 | 1239311 | 2021-04-20 | Hamilton | Indiana | 18057 | 34626 | 424 |
1236064 | 1236064 | 2021-04-19 | Hamilton | Indiana | 18057 | 34595 | 423 |
1232817 | 1232817 | 2021-04-18 | Hamilton | Indiana | 18057 | 34543 | 423 |
1229568 | 1229568 | 2021-04-17 | Hamilton | Indiana | 18057 | 34495 | 423 |
1226320 | 1226320 | 2021-04-16 | Hamilton | Indiana | 18057 | 34415 | 424 |
1223073 | 1223073 | 2021-04-15 | Hamilton | Indiana | 18057 | 34335 | 423 |
1219825 | 1219825 | 2021-04-14 | Hamilton | Indiana | 18057 | 34259 | 423 |
1216577 | 1216577 | 2021-04-13 | Hamilton | Indiana | 18057 | 34200 | 423 |
1213330 | 1213330 | 2021-04-12 | Hamilton | Indiana | 18057 | 34134 | 423 |
1210082 | 1210082 | 2021-04-11 | Hamilton | Indiana | 18057 | 34075 | 423 |
1206833 | 1206833 | 2021-04-10 | Hamilton | Indiana | 18057 | 34028 | 423 |
1203585 | 1203585 | 2021-04-09 | Hamilton | Indiana | 18057 | 33968 | 423 |
1200337 | 1200337 | 2021-04-08 | Hamilton | Indiana | 18057 | 33914 | 423 |
1197088 | 1197088 | 2021-04-07 | Hamilton | Indiana | 18057 | 33848 | 423 |
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 |
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);