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 |
---|---|---|---|---|---|---|---|
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 |
919750 | 919750 | 2021-01-11 | Hamilton | Tennessee | 47065 | 34254 | 313 |
919910 | 919910 | 2021-01-11 | Hamilton | Texas | 48193 | 517 | 18 |
914292 | 914292 | 2021-01-10 | Hamilton | Florida | 12047 | 1355 | 15 |
914580 | 914580 | 2021-01-10 | Hamilton | Illinois | 17065 | 665 | 12 |
914678 | 914678 | 2021-01-10 | Hamilton | Indiana | 18057 | 26811 | 307 |
914781 | 914781 | 2021-01-10 | Hamilton | Iowa | 19079 | 1539 | 26 |
914879 | 914879 | 2021-01-10 | Hamilton | Kansas | 20075 | 194 | 0 |
915657 | 915657 | 2021-01-10 | Hamilton | Nebraska | 31081 | 767 | 16 |
915812 | 915812 | 2021-01-10 | Hamilton | New York | 36041 | 132 | 1 |
916037 | 916037 | 2021-01-10 | Hamilton | Ohio | 39061 | 57384 | 425 |
916505 | 916505 | 2021-01-10 | Hamilton | Tennessee | 47065 | 33829 | 305 |
916665 | 916665 | 2021-01-10 | Hamilton | Texas | 48193 | 510 | 18 |
911047 | 911047 | 2021-01-09 | Hamilton | Florida | 12047 | 1348 | 15 |
911335 | 911335 | 2021-01-09 | Hamilton | Illinois | 17065 | 663 | 12 |
911433 | 911433 | 2021-01-09 | Hamilton | Indiana | 18057 | 26538 | 307 |
911536 | 911536 | 2021-01-09 | Hamilton | Iowa | 19079 | 1538 | 26 |
911634 | 911634 | 2021-01-09 | Hamilton | Kansas | 20075 | 194 | 0 |
912412 | 912412 | 2021-01-09 | Hamilton | Nebraska | 31081 | 761 | 16 |
912567 | 912567 | 2021-01-09 | Hamilton | New York | 36041 | 129 | 1 |
912792 | 912792 | 2021-01-09 | Hamilton | Ohio | 39061 | 56947 | 425 |
913260 | 913260 | 2021-01-09 | Hamilton | Tennessee | 47065 | 33639 | 300 |
913420 | 913420 | 2021-01-09 | Hamilton | Texas | 48193 | 501 | 18 |
907802 | 907802 | 2021-01-08 | Hamilton | Florida | 12047 | 1339 | 15 |
908090 | 908090 | 2021-01-08 | Hamilton | Illinois | 17065 | 647 | 11 |
908188 | 908188 | 2021-01-08 | Hamilton | Indiana | 18057 | 26186 | 306 |
908291 | 908291 | 2021-01-08 | Hamilton | Iowa | 19079 | 1535 | 26 |
908389 | 908389 | 2021-01-08 | Hamilton | Kansas | 20075 | 194 | 0 |
909167 | 909167 | 2021-01-08 | Hamilton | Nebraska | 31081 | 761 | 16 |
909322 | 909322 | 2021-01-08 | Hamilton | New York | 36041 | 128 | 1 |
909547 | 909547 | 2021-01-08 | Hamilton | Ohio | 39061 | 56256 | 425 |
910015 | 910015 | 2021-01-08 | Hamilton | Tennessee | 47065 | 33139 | 299 |
910175 | 910175 | 2021-01-08 | Hamilton | Texas | 48193 | 499 | 18 |
904556 | 904556 | 2021-01-07 | Hamilton | Florida | 12047 | 1328 | 15 |
904844 | 904844 | 2021-01-07 | Hamilton | Illinois | 17065 | 639 | 11 |
904942 | 904942 | 2021-01-07 | Hamilton | Indiana | 18057 | 25885 | 306 |
905045 | 905045 | 2021-01-07 | Hamilton | Iowa | 19079 | 1532 | 25 |
905143 | 905143 | 2021-01-07 | Hamilton | Kansas | 20075 | 190 | 0 |
905921 | 905921 | 2021-01-07 | Hamilton | Nebraska | 31081 | 749 | 16 |
906077 | 906077 | 2021-01-07 | Hamilton | New York | 36041 | 124 | 1 |
906302 | 906302 | 2021-01-07 | Hamilton | Ohio | 39061 | 55652 | 423 |
906770 | 906770 | 2021-01-07 | Hamilton | Tennessee | 47065 | 32484 | 292 |
906930 | 906930 | 2021-01-07 | Hamilton | Texas | 48193 | 499 | 18 |
901311 | 901311 | 2021-01-06 | Hamilton | Florida | 12047 | 1320 | 15 |
901599 | 901599 | 2021-01-06 | Hamilton | Illinois | 17065 | 625 | 11 |
901697 | 901697 | 2021-01-06 | Hamilton | Indiana | 18057 | 25457 | 305 |
901800 | 901800 | 2021-01-06 | Hamilton | Iowa | 19079 | 1527 | 25 |
901898 | 901898 | 2021-01-06 | Hamilton | Kansas | 20075 | 190 | 0 |
902676 | 902676 | 2021-01-06 | Hamilton | Nebraska | 31081 | 749 | 16 |
902831 | 902831 | 2021-01-06 | Hamilton | New York | 36041 | 122 | 1 |
903056 | 903056 | 2021-01-06 | Hamilton | Ohio | 39061 | 54992 | 423 |
903524 | 903524 | 2021-01-06 | Hamilton | Tennessee | 47065 | 31878 | 286 |
903684 | 903684 | 2021-01-06 | Hamilton | Texas | 48193 | 495 | 17 |
898066 | 898066 | 2021-01-05 | Hamilton | Florida | 12047 | 1309 | 15 |
898354 | 898354 | 2021-01-05 | Hamilton | Illinois | 17065 | 619 | 11 |
898452 | 898452 | 2021-01-05 | Hamilton | Indiana | 18057 | 25177 | 304 |
898555 | 898555 | 2021-01-05 | Hamilton | Iowa | 19079 | 1520 | 24 |
898653 | 898653 | 2021-01-05 | Hamilton | Kansas | 20075 | 189 | 0 |
899431 | 899431 | 2021-01-05 | Hamilton | Nebraska | 31081 | 732 | 16 |
899586 | 899586 | 2021-01-05 | Hamilton | New York | 36041 | 121 | 1 |
899811 | 899811 | 2021-01-05 | Hamilton | Ohio | 39061 | 54379 | 421 |
900279 | 900279 | 2021-01-05 | Hamilton | Tennessee | 47065 | 31353 | 283 |
900439 | 900439 | 2021-01-05 | Hamilton | Texas | 48193 | 494 | 17 |
894821 | 894821 | 2021-01-04 | Hamilton | Florida | 12047 | 1305 | 15 |
895109 | 895109 | 2021-01-04 | Hamilton | Illinois | 17065 | 615 | 10 |
895207 | 895207 | 2021-01-04 | Hamilton | Indiana | 18057 | 24963 | 301 |
895310 | 895310 | 2021-01-04 | Hamilton | Iowa | 19079 | 1514 | 24 |
895408 | 895408 | 2021-01-04 | Hamilton | Kansas | 20075 | 189 | 0 |
896186 | 896186 | 2021-01-04 | Hamilton | Nebraska | 31081 | 727 | 16 |
896341 | 896341 | 2021-01-04 | Hamilton | New York | 36041 | 120 | 1 |
896566 | 896566 | 2021-01-04 | Hamilton | Ohio | 39061 | 53797 | 419 |
897034 | 897034 | 2021-01-04 | Hamilton | Tennessee | 47065 | 30810 | 282 |
897194 | 897194 | 2021-01-04 | Hamilton | Texas | 48193 | 493 | 17 |
891574 | 891574 | 2021-01-03 | Hamilton | Florida | 12047 | 1299 | 15 |
891862 | 891862 | 2021-01-03 | Hamilton | Illinois | 17065 | 610 | 10 |
891960 | 891960 | 2021-01-03 | Hamilton | Indiana | 18057 | 24794 | 297 |
892063 | 892063 | 2021-01-03 | Hamilton | Iowa | 19079 | 1493 | 24 |
892161 | 892161 | 2021-01-03 | Hamilton | Kansas | 20075 | 188 | 0 |
892939 | 892939 | 2021-01-03 | Hamilton | Nebraska | 31081 | 720 | 15 |
893095 | 893095 | 2021-01-03 | Hamilton | New York | 36041 | 119 | 1 |
893320 | 893320 | 2021-01-03 | Hamilton | Ohio | 39061 | 53404 | 419 |
893788 | 893788 | 2021-01-03 | Hamilton | Tennessee | 47065 | 30333 | 276 |
893948 | 893948 | 2021-01-03 | Hamilton | Texas | 48193 | 493 | 17 |
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);