ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
7,750 rows where county = "Hamilton" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
952204 | 952204 | 2021-01-21 | Hamilton | Tennessee | 47065 | 36652 | 337 |
952364 | 952364 | 2021-01-21 | Hamilton | Texas | 48193 | 582 | 22 |
946745 | 946745 | 2021-01-20 | Hamilton | Florida | 12047 | 1441 | 15 |
947033 | 947033 | 2021-01-20 | Hamilton | Illinois | 17065 | 720 | 17 |
947131 | 947131 | 2021-01-20 | Hamilton | Indiana | 18057 | 28860 | 329 |
947234 | 947234 | 2021-01-20 | Hamilton | Iowa | 19079 | 1607 | 30 |
947332 | 947332 | 2021-01-20 | Hamilton | Kansas | 20075 | 197 | 0 |
948110 | 948110 | 2021-01-20 | Hamilton | Nebraska | 31081 | 812 | 16 |
948266 | 948266 | 2021-01-20 | Hamilton | New York | 36041 | 147 | 1 |
948491 | 948491 | 2021-01-20 | Hamilton | Ohio | 39061 | 62391 | 443 |
948959 | 948959 | 2021-01-20 | Hamilton | Tennessee | 47065 | 36447 | 332 |
949119 | 949119 | 2021-01-20 | Hamilton | Texas | 48193 | 552 | 21 |
943498 | 943498 | 2021-01-19 | Hamilton | Florida | 12047 | 1428 | 15 |
943786 | 943786 | 2021-01-19 | Hamilton | Illinois | 17065 | 717 | 17 |
943884 | 943884 | 2021-01-19 | Hamilton | Indiana | 18057 | 28726 | 323 |
943987 | 943987 | 2021-01-19 | Hamilton | Iowa | 19079 | 1600 | 29 |
944085 | 944085 | 2021-01-19 | Hamilton | Kansas | 20075 | 195 | 0 |
944863 | 944863 | 2021-01-19 | Hamilton | Nebraska | 31081 | 812 | 16 |
945019 | 945019 | 2021-01-19 | Hamilton | New York | 36041 | 146 | 1 |
945245 | 945245 | 2021-01-19 | Hamilton | Ohio | 39061 | 61931 | 441 |
945713 | 945713 | 2021-01-19 | Hamilton | Tennessee | 47065 | 36233 | 330 |
945873 | 945873 | 2021-01-19 | Hamilton | Texas | 48193 | 546 | 21 |
940253 | 940253 | 2021-01-18 | Hamilton | Florida | 12047 | 1424 | 15 |
940541 | 940541 | 2021-01-18 | Hamilton | Illinois | 17065 | 716 | 17 |
940639 | 940639 | 2021-01-18 | Hamilton | Indiana | 18057 | 28575 | 320 |
940742 | 940742 | 2021-01-18 | Hamilton | Iowa | 19079 | 1587 | 29 |
940840 | 940840 | 2021-01-18 | Hamilton | Kansas | 20075 | 195 | 0 |
941618 | 941618 | 2021-01-18 | Hamilton | Nebraska | 31081 | 812 | 16 |
941773 | 941773 | 2021-01-18 | Hamilton | New York | 36041 | 146 | 1 |
941998 | 941998 | 2021-01-18 | Hamilton | Ohio | 39061 | 61629 | 439 |
942466 | 942466 | 2021-01-18 | Hamilton | Tennessee | 47065 | 35891 | 327 |
942626 | 942626 | 2021-01-18 | Hamilton | Texas | 48193 | 546 | 21 |
937008 | 937008 | 2021-01-17 | Hamilton | Florida | 12047 | 1416 | 15 |
937296 | 937296 | 2021-01-17 | Hamilton | Illinois | 17065 | 714 | 16 |
937394 | 937394 | 2021-01-17 | Hamilton | Indiana | 18057 | 28413 | 319 |
937497 | 937497 | 2021-01-17 | Hamilton | Iowa | 19079 | 1579 | 29 |
937595 | 937595 | 2021-01-17 | Hamilton | Kansas | 20075 | 195 | 0 |
938373 | 938373 | 2021-01-17 | Hamilton | Nebraska | 31081 | 803 | 16 |
938528 | 938528 | 2021-01-17 | Hamilton | New York | 36041 | 145 | 1 |
938753 | 938753 | 2021-01-17 | Hamilton | Ohio | 39061 | 61350 | 439 |
939221 | 939221 | 2021-01-17 | Hamilton | Tennessee | 47065 | 35891 | 326 |
939381 | 939381 | 2021-01-17 | Hamilton | Texas | 48193 | 546 | 21 |
933763 | 933763 | 2021-01-16 | Hamilton | Florida | 12047 | 1412 | 15 |
934051 | 934051 | 2021-01-16 | Hamilton | Illinois | 17065 | 711 | 16 |
934149 | 934149 | 2021-01-16 | Hamilton | Indiana | 18057 | 28220 | 318 |
934252 | 934252 | 2021-01-16 | Hamilton | Iowa | 19079 | 1578 | 29 |
934350 | 934350 | 2021-01-16 | Hamilton | Kansas | 20075 | 195 | 0 |
935128 | 935128 | 2021-01-16 | Hamilton | Nebraska | 31081 | 803 | 16 |
935283 | 935283 | 2021-01-16 | Hamilton | New York | 36041 | 145 | 1 |
935508 | 935508 | 2021-01-16 | Hamilton | Ohio | 39061 | 60913 | 438 |
935976 | 935976 | 2021-01-16 | Hamilton | Tennessee | 47065 | 35708 | 326 |
936136 | 936136 | 2021-01-16 | Hamilton | Texas | 48193 | 545 | 21 |
930518 | 930518 | 2021-01-15 | Hamilton | Florida | 12047 | 1404 | 15 |
930806 | 930806 | 2021-01-15 | Hamilton | Illinois | 17065 | 709 | 16 |
930904 | 930904 | 2021-01-15 | Hamilton | Indiana | 18057 | 27971 | 318 |
931007 | 931007 | 2021-01-15 | Hamilton | Iowa | 19079 | 1577 | 28 |
931105 | 931105 | 2021-01-15 | Hamilton | Kansas | 20075 | 195 | 0 |
931883 | 931883 | 2021-01-15 | Hamilton | Nebraska | 31081 | 803 | 16 |
932038 | 932038 | 2021-01-15 | Hamilton | New York | 36041 | 143 | 1 |
932263 | 932263 | 2021-01-15 | Hamilton | Ohio | 39061 | 60343 | 438 |
932731 | 932731 | 2021-01-15 | Hamilton | Tennessee | 47065 | 35557 | 325 |
932891 | 932891 | 2021-01-15 | Hamilton | Texas | 48193 | 542 | 20 |
927273 | 927273 | 2021-01-14 | Hamilton | Florida | 12047 | 1389 | 15 |
927561 | 927561 | 2021-01-14 | Hamilton | Illinois | 17065 | 705 | 15 |
927659 | 927659 | 2021-01-14 | Hamilton | Indiana | 18057 | 27717 | 318 |
927762 | 927762 | 2021-01-14 | Hamilton | Iowa | 19079 | 1568 | 28 |
927860 | 927860 | 2021-01-14 | Hamilton | Kansas | 20075 | 195 | 0 |
928638 | 928638 | 2021-01-14 | Hamilton | Nebraska | 31081 | 792 | 16 |
928793 | 928793 | 2021-01-14 | Hamilton | New York | 36041 | 143 | 1 |
929018 | 929018 | 2021-01-14 | Hamilton | Ohio | 39061 | 59783 | 436 |
929486 | 929486 | 2021-01-14 | Hamilton | Tennessee | 47065 | 35328 | 323 |
929646 | 929646 | 2021-01-14 | Hamilton | Texas | 48193 | 519 | 19 |
924027 | 924027 | 2021-01-13 | Hamilton | Florida | 12047 | 1373 | 15 |
924315 | 924315 | 2021-01-13 | Hamilton | Illinois | 17065 | 697 | 15 |
924413 | 924413 | 2021-01-13 | Hamilton | Indiana | 18057 | 27468 | 317 |
924516 | 924516 | 2021-01-13 | Hamilton | Iowa | 19079 | 1563 | 28 |
924614 | 924614 | 2021-01-13 | Hamilton | Kansas | 20075 | 195 | 0 |
925392 | 925392 | 2021-01-13 | Hamilton | Nebraska | 31081 | 792 | 16 |
925548 | 925548 | 2021-01-13 | Hamilton | New York | 36041 | 141 | 1 |
925773 | 925773 | 2021-01-13 | Hamilton | Ohio | 39061 | 59040 | 427 |
926241 | 926241 | 2021-01-13 | Hamilton | Tennessee | 47065 | 35100 | 322 |
926401 | 926401 | 2021-01-13 | Hamilton | Texas | 48193 | 518 | 19 |
920782 | 920782 | 2021-01-12 | Hamilton | Florida | 12047 | 1367 | 15 |
921070 | 921070 | 2021-01-12 | Hamilton | Illinois | 17065 | 670 | 14 |
921168 | 921168 | 2021-01-12 | Hamilton | Indiana | 18057 | 27267 | 312 |
921271 | 921271 | 2021-01-12 | Hamilton | Iowa | 19079 | 1552 | 28 |
921369 | 921369 | 2021-01-12 | Hamilton | Kansas | 20075 | 194 | 0 |
922147 | 922147 | 2021-01-12 | Hamilton | Nebraska | 31081 | 783 | 16 |
922302 | 922302 | 2021-01-12 | Hamilton | New York | 36041 | 140 | 1 |
922527 | 922527 | 2021-01-12 | Hamilton | Ohio | 39061 | 58503 | 426 |
922995 | 922995 | 2021-01-12 | Hamilton | Tennessee | 47065 | 34744 | 319 |
923155 | 923155 | 2021-01-12 | Hamilton | Texas | 48193 | 517 | 18 |
917537 | 917537 | 2021-01-11 | Hamilton | Florida | 12047 | 1356 | 15 |
917825 | 917825 | 2021-01-11 | Hamilton | Illinois | 17065 | 667 | 13 |
917923 | 917923 | 2021-01-11 | Hamilton | Indiana | 18057 | 27067 | 309 |
918026 | 918026 | 2021-01-11 | Hamilton | Iowa | 19079 | 1542 | 26 |
918124 | 918124 | 2021-01-11 | Hamilton | Kansas | 20075 | 194 | 0 |
918902 | 918902 | 2021-01-11 | Hamilton | Nebraska | 31081 | 783 | 16 |
919057 | 919057 | 2021-01-11 | Hamilton | New York | 36041 | 133 | 1 |
919282 | 919282 | 2021-01-11 | Hamilton | Ohio | 39061 | 57879 | 426 |
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);