ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
7,721 rows where county = "Hancock" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 10
- Mississippi 303
- Indiana 298
- Ohio 297
- Iowa 296
- West Virginia 292
- Kentucky 288
- Maine 287
- Georgia 281
- Illinois 280
- Tennessee 239
fips 10
county 1
- Hancock · 2,861 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
920897 | 920897 | 2021-01-12 | Hancock | Georgia | 13141 | 755 | 48 |
921071 | 921071 | 2021-01-12 | Hancock | Illinois | 17067 | 1443 | 32 |
921169 | 921169 | 2021-01-12 | Hancock | Indiana | 18059 | 6126 | 94 |
921272 | 921272 | 2021-01-12 | Hancock | Iowa | 19081 | 1264 | 24 |
921483 | 921483 | 2021-01-12 | Hancock | Kentucky | 21091 | 583 | 13 |
921627 | 921627 | 2021-01-12 | Hancock | Maine | 23009 | 647 | 23 |
921874 | 921874 | 2021-01-12 | Hancock | Mississippi | 28045 | 2383 | 57 |
922528 | 922528 | 2021-01-12 | Hancock | Ohio | 39063 | 5206 | 88 |
922996 | 922996 | 2021-01-12 | Hancock | Tennessee | 47067 | 384 | 6 |
923547 | 923547 | 2021-01-12 | Hancock | West Virginia | 54029 | 2200 | 61 |
917652 | 917652 | 2021-01-11 | Hancock | Georgia | 13141 | 751 | 48 |
917826 | 917826 | 2021-01-11 | Hancock | Illinois | 17067 | 1430 | 32 |
917924 | 917924 | 2021-01-11 | Hancock | Indiana | 18059 | 6084 | 91 |
918027 | 918027 | 2021-01-11 | Hancock | Iowa | 19081 | 1258 | 24 |
918238 | 918238 | 2021-01-11 | Hancock | Kentucky | 21091 | 572 | 13 |
918382 | 918382 | 2021-01-11 | Hancock | Maine | 23009 | 625 | 23 |
918629 | 918629 | 2021-01-11 | Hancock | Mississippi | 28045 | 2370 | 56 |
919283 | 919283 | 2021-01-11 | Hancock | Ohio | 39063 | 5160 | 85 |
919751 | 919751 | 2021-01-11 | Hancock | Tennessee | 47067 | 380 | 6 |
920302 | 920302 | 2021-01-11 | Hancock | West Virginia | 54029 | 2173 | 61 |
914407 | 914407 | 2021-01-10 | Hancock | Georgia | 13141 | 749 | 48 |
914581 | 914581 | 2021-01-10 | Hancock | Illinois | 17067 | 1422 | 32 |
914679 | 914679 | 2021-01-10 | Hancock | Indiana | 18059 | 6023 | 91 |
914782 | 914782 | 2021-01-10 | Hancock | Iowa | 19081 | 1254 | 24 |
914993 | 914993 | 2021-01-10 | Hancock | Kentucky | 21091 | 569 | 13 |
915137 | 915137 | 2021-01-10 | Hancock | Maine | 23009 | 621 | 23 |
915384 | 915384 | 2021-01-10 | Hancock | Mississippi | 28045 | 2357 | 56 |
916038 | 916038 | 2021-01-10 | Hancock | Ohio | 39063 | 5120 | 85 |
916506 | 916506 | 2021-01-10 | Hancock | Tennessee | 47067 | 381 | 6 |
917057 | 917057 | 2021-01-10 | Hancock | West Virginia | 54029 | 2162 | 57 |
911162 | 911162 | 2021-01-09 | Hancock | Georgia | 13141 | 739 | 48 |
911336 | 911336 | 2021-01-09 | Hancock | Illinois | 17067 | 1418 | 32 |
911434 | 911434 | 2021-01-09 | Hancock | Indiana | 18059 | 5952 | 91 |
911537 | 911537 | 2021-01-09 | Hancock | Iowa | 19081 | 1250 | 24 |
911748 | 911748 | 2021-01-09 | Hancock | Kentucky | 21091 | 566 | 13 |
911892 | 911892 | 2021-01-09 | Hancock | Maine | 23009 | 619 | 23 |
912139 | 912139 | 2021-01-09 | Hancock | Mississippi | 28045 | 2320 | 56 |
912793 | 912793 | 2021-01-09 | Hancock | Ohio | 39063 | 5075 | 85 |
913261 | 913261 | 2021-01-09 | Hancock | Tennessee | 47067 | 376 | 6 |
913812 | 913812 | 2021-01-09 | Hancock | West Virginia | 54029 | 2143 | 57 |
907917 | 907917 | 2021-01-08 | Hancock | Georgia | 13141 | 728 | 48 |
908091 | 908091 | 2021-01-08 | Hancock | Illinois | 17067 | 1407 | 32 |
908189 | 908189 | 2021-01-08 | Hancock | Indiana | 18059 | 5881 | 91 |
908292 | 908292 | 2021-01-08 | Hancock | Iowa | 19081 | 1246 | 24 |
908503 | 908503 | 2021-01-08 | Hancock | Kentucky | 21091 | 556 | 13 |
908647 | 908647 | 2021-01-08 | Hancock | Maine | 23009 | 611 | 22 |
908894 | 908894 | 2021-01-08 | Hancock | Mississippi | 28045 | 2290 | 57 |
909548 | 909548 | 2021-01-08 | Hancock | Ohio | 39063 | 4995 | 85 |
910016 | 910016 | 2021-01-08 | Hancock | Tennessee | 47067 | 368 | 6 |
910567 | 910567 | 2021-01-08 | Hancock | West Virginia | 54029 | 2126 | 56 |
904671 | 904671 | 2021-01-07 | Hancock | Georgia | 13141 | 721 | 48 |
904845 | 904845 | 2021-01-07 | Hancock | Illinois | 17067 | 1401 | 32 |
904943 | 904943 | 2021-01-07 | Hancock | Indiana | 18059 | 5799 | 91 |
905046 | 905046 | 2021-01-07 | Hancock | Iowa | 19081 | 1236 | 24 |
905257 | 905257 | 2021-01-07 | Hancock | Kentucky | 21091 | 540 | 12 |
905401 | 905401 | 2021-01-07 | Hancock | Maine | 23009 | 608 | 16 |
905648 | 905648 | 2021-01-07 | Hancock | Mississippi | 28045 | 2252 | 56 |
906303 | 906303 | 2021-01-07 | Hancock | Ohio | 39063 | 4951 | 85 |
906771 | 906771 | 2021-01-07 | Hancock | Tennessee | 47067 | 366 | 5 |
907322 | 907322 | 2021-01-07 | Hancock | West Virginia | 54029 | 2083 | 55 |
901426 | 901426 | 2021-01-06 | Hancock | Georgia | 13141 | 712 | 48 |
901600 | 901600 | 2021-01-06 | Hancock | Illinois | 17067 | 1383 | 31 |
901698 | 901698 | 2021-01-06 | Hancock | Indiana | 18059 | 5651 | 91 |
901801 | 901801 | 2021-01-06 | Hancock | Iowa | 19081 | 1222 | 24 |
902012 | 902012 | 2021-01-06 | Hancock | Kentucky | 21091 | 529 | 12 |
902156 | 902156 | 2021-01-06 | Hancock | Maine | 23009 | 600 | 13 |
902403 | 902403 | 2021-01-06 | Hancock | Mississippi | 28045 | 2204 | 56 |
903057 | 903057 | 2021-01-06 | Hancock | Ohio | 39063 | 4918 | 82 |
903525 | 903525 | 2021-01-06 | Hancock | Tennessee | 47067 | 356 | 5 |
904076 | 904076 | 2021-01-06 | Hancock | West Virginia | 54029 | 2060 | 52 |
898181 | 898181 | 2021-01-05 | Hancock | Georgia | 13141 | 701 | 48 |
898355 | 898355 | 2021-01-05 | Hancock | Illinois | 17067 | 1356 | 30 |
898453 | 898453 | 2021-01-05 | Hancock | Indiana | 18059 | 5536 | 90 |
898556 | 898556 | 2021-01-05 | Hancock | Iowa | 19081 | 1208 | 24 |
898767 | 898767 | 2021-01-05 | Hancock | Kentucky | 21091 | 501 | 12 |
898911 | 898911 | 2021-01-05 | Hancock | Maine | 23009 | 592 | 13 |
899158 | 899158 | 2021-01-05 | Hancock | Mississippi | 28045 | 2167 | 56 |
899812 | 899812 | 2021-01-05 | Hancock | Ohio | 39063 | 4820 | 82 |
900280 | 900280 | 2021-01-05 | Hancock | Tennessee | 47067 | 354 | 5 |
900831 | 900831 | 2021-01-05 | Hancock | West Virginia | 54029 | 2031 | 49 |
894936 | 894936 | 2021-01-04 | Hancock | Georgia | 13141 | 691 | 48 |
895110 | 895110 | 2021-01-04 | Hancock | Illinois | 17067 | 1346 | 30 |
895208 | 895208 | 2021-01-04 | Hancock | Indiana | 18059 | 5484 | 87 |
895311 | 895311 | 2021-01-04 | Hancock | Iowa | 19081 | 1198 | 24 |
895522 | 895522 | 2021-01-04 | Hancock | Kentucky | 21091 | 492 | 12 |
895666 | 895666 | 2021-01-04 | Hancock | Maine | 23009 | 570 | 13 |
895913 | 895913 | 2021-01-04 | Hancock | Mississippi | 28045 | 2138 | 55 |
896567 | 896567 | 2021-01-04 | Hancock | Ohio | 39063 | 4784 | 81 |
897035 | 897035 | 2021-01-04 | Hancock | Tennessee | 47067 | 340 | 5 |
897586 | 897586 | 2021-01-04 | Hancock | West Virginia | 54029 | 1997 | 43 |
891689 | 891689 | 2021-01-03 | Hancock | Georgia | 13141 | 686 | 48 |
891863 | 891863 | 2021-01-03 | Hancock | Illinois | 17067 | 1335 | 30 |
891961 | 891961 | 2021-01-03 | Hancock | Indiana | 18059 | 5407 | 86 |
892064 | 892064 | 2021-01-03 | Hancock | Iowa | 19081 | 1189 | 24 |
892275 | 892275 | 2021-01-03 | Hancock | Kentucky | 21091 | 485 | 12 |
892419 | 892419 | 2021-01-03 | Hancock | Maine | 23009 | 557 | 13 |
892666 | 892666 | 2021-01-03 | Hancock | Mississippi | 28045 | 2108 | 55 |
893321 | 893321 | 2021-01-03 | Hancock | Ohio | 39063 | 4759 | 81 |
893789 | 893789 | 2021-01-03 | Hancock | Tennessee | 47067 | 339 | 5 |
894340 | 894340 | 2021-01-03 | Hancock | West Virginia | 54029 | 1996 | 42 |
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);