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 689
- Indiana 684
- Ohio 683
- Iowa 682
- West Virginia 678
- Kentucky 674
- Maine 673
- Georgia 667
- Illinois 666
- Tennessee 625
fips 10
county 1
- Hancock · 6,721 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174655 | 2174655 | 2022-02-02 | Hancock | Georgia | 13141 | 1519 | 86 |
2174830 | 2174830 | 2022-02-02 | Hancock | Illinois | 17067 | 4144 | 53 |
2174929 | 2174929 | 2022-02-02 | Hancock | Indiana | 18059 | 20152 | 238 |
2175032 | 2175032 | 2022-02-02 | Hancock | Iowa | 19081 | 2700 | 45 |
2175242 | 2175242 | 2022-02-02 | Hancock | Kentucky | 21091 | 2288 | 19 |
2175386 | 2175386 | 2022-02-02 | Hancock | Maine | 23009 | 5174 | 71 |
2175633 | 2175633 | 2022-02-02 | Hancock | Mississippi | 28045 | 11118 | 145 |
2176291 | 2176291 | 2022-02-02 | Hancock | Ohio | 39063 | 16655 | 242 |
2176760 | 2176760 | 2022-02-02 | Hancock | Tennessee | 47067 | 1789 | 29 |
2177311 | 2177311 | 2022-02-02 | Hancock | West Virginia | 54029 | 6391 | 130 |
2171402 | 2171402 | 2022-02-01 | Hancock | Georgia | 13141 | 1516 | 86 |
2171577 | 2171577 | 2022-02-01 | Hancock | Illinois | 17067 | 4127 | 53 |
2171676 | 2171676 | 2022-02-01 | Hancock | Indiana | 18059 | 20071 | 235 |
2171779 | 2171779 | 2022-02-01 | Hancock | Iowa | 19081 | 2649 | 45 |
2171989 | 2171989 | 2022-02-01 | Hancock | Kentucky | 21091 | 2271 | 19 |
2172133 | 2172133 | 2022-02-01 | Hancock | Maine | 23009 | 5144 | 71 |
2172380 | 2172380 | 2022-02-01 | Hancock | Mississippi | 28045 | 11033 | 142 |
2173037 | 2173037 | 2022-02-01 | Hancock | Ohio | 39063 | 16601 | 242 |
2173506 | 2173506 | 2022-02-01 | Hancock | Tennessee | 47067 | 1670 | 29 |
2174058 | 2174058 | 2022-02-01 | Hancock | West Virginia | 54029 | 6372 | 130 |
2168149 | 2168149 | 2022-01-31 | Hancock | Georgia | 13141 | 1511 | 86 |
2168324 | 2168324 | 2022-01-31 | Hancock | Illinois | 17067 | 4109 | 53 |
2168423 | 2168423 | 2022-01-31 | Hancock | Indiana | 18059 | 20040 | 234 |
2168526 | 2168526 | 2022-01-31 | Hancock | Iowa | 19081 | 2649 | 45 |
2168736 | 2168736 | 2022-01-31 | Hancock | Kentucky | 21091 | 2259 | 19 |
2168880 | 2168880 | 2022-01-31 | Hancock | Maine | 23009 | 5124 | 70 |
2169127 | 2169127 | 2022-01-31 | Hancock | Mississippi | 28045 | 10899 | 142 |
2169785 | 2169785 | 2022-01-31 | Hancock | Ohio | 39063 | 16553 | 241 |
2170254 | 2170254 | 2022-01-31 | Hancock | Tennessee | 47067 | 1670 | 29 |
2170806 | 2170806 | 2022-01-31 | Hancock | West Virginia | 54029 | 6357 | 130 |
2164894 | 2164894 | 2022-01-30 | Hancock | Georgia | 13141 | 1500 | 86 |
2165069 | 2165069 | 2022-01-30 | Hancock | Illinois | 17067 | 4051 | 53 |
2165168 | 2165168 | 2022-01-30 | Hancock | Indiana | 18059 | 19786 | 234 |
2165271 | 2165271 | 2022-01-30 | Hancock | Iowa | 19081 | 2649 | 45 |
2165481 | 2165481 | 2022-01-30 | Hancock | Kentucky | 21091 | 2209 | 19 |
2165625 | 2165625 | 2022-01-30 | Hancock | Maine | 23009 | 5124 | 70 |
2165872 | 2165872 | 2022-01-30 | Hancock | Mississippi | 28045 | 10636 | 142 |
2166530 | 2166530 | 2022-01-30 | Hancock | Ohio | 39063 | 16528 | 241 |
2167000 | 2167000 | 2022-01-30 | Hancock | Tennessee | 47067 | 1670 | 29 |
2167553 | 2167553 | 2022-01-30 | Hancock | West Virginia | 54029 | 6339 | 130 |
2161639 | 2161639 | 2022-01-29 | Hancock | Georgia | 13141 | 1500 | 86 |
2161814 | 2161814 | 2022-01-29 | Hancock | Illinois | 17067 | 4051 | 53 |
2161913 | 2161913 | 2022-01-29 | Hancock | Indiana | 18059 | 19786 | 234 |
2162016 | 2162016 | 2022-01-29 | Hancock | Iowa | 19081 | 2649 | 45 |
2162226 | 2162226 | 2022-01-29 | Hancock | Kentucky | 21091 | 2209 | 19 |
2162370 | 2162370 | 2022-01-29 | Hancock | Maine | 23009 | 5124 | 70 |
2162617 | 2162617 | 2022-01-29 | Hancock | Mississippi | 28045 | 10636 | 142 |
2163275 | 2163275 | 2022-01-29 | Hancock | Ohio | 39063 | 16494 | 241 |
2163745 | 2163745 | 2022-01-29 | Hancock | Tennessee | 47067 | 1670 | 29 |
2164298 | 2164298 | 2022-01-29 | Hancock | West Virginia | 54029 | 6312 | 130 |
2158383 | 2158383 | 2022-01-28 | Hancock | Georgia | 13141 | 1500 | 86 |
2158559 | 2158559 | 2022-01-28 | Hancock | Illinois | 17067 | 4051 | 53 |
2158658 | 2158658 | 2022-01-28 | Hancock | Indiana | 18059 | 19786 | 234 |
2158761 | 2158761 | 2022-01-28 | Hancock | Iowa | 19081 | 2649 | 45 |
2158971 | 2158971 | 2022-01-28 | Hancock | Kentucky | 21091 | 2209 | 19 |
2159115 | 2159115 | 2022-01-28 | Hancock | Maine | 23009 | 5104 | 70 |
2159362 | 2159362 | 2022-01-28 | Hancock | Mississippi | 28045 | 10636 | 142 |
2160020 | 2160020 | 2022-01-28 | Hancock | Ohio | 39063 | 16440 | 241 |
2160490 | 2160490 | 2022-01-28 | Hancock | Tennessee | 47067 | 1670 | 29 |
2161043 | 2161043 | 2022-01-28 | Hancock | West Virginia | 54029 | 6318 | 130 |
2155130 | 2155130 | 2022-01-27 | Hancock | Georgia | 13141 | 1487 | 86 |
2155305 | 2155305 | 2022-01-27 | Hancock | Illinois | 17067 | 4002 | 53 |
2155404 | 2155404 | 2022-01-27 | Hancock | Indiana | 18059 | 19553 | 234 |
2155507 | 2155507 | 2022-01-27 | Hancock | Iowa | 19081 | 2649 | 45 |
2155717 | 2155717 | 2022-01-27 | Hancock | Kentucky | 21091 | 2176 | 19 |
2155861 | 2155861 | 2022-01-27 | Hancock | Maine | 23009 | 5017 | 68 |
2156108 | 2156108 | 2022-01-27 | Hancock | Mississippi | 28045 | 10533 | 142 |
2156765 | 2156765 | 2022-01-27 | Hancock | Ohio | 39063 | 16375 | 237 |
2157234 | 2157234 | 2022-01-27 | Hancock | Tennessee | 47067 | 1670 | 29 |
2157787 | 2157787 | 2022-01-27 | Hancock | West Virginia | 54029 | 6281 | 130 |
2151877 | 2151877 | 2022-01-26 | Hancock | Georgia | 13141 | 1483 | 86 |
2152052 | 2152052 | 2022-01-26 | Hancock | Illinois | 17067 | 3974 | 53 |
2152151 | 2152151 | 2022-01-26 | Hancock | Indiana | 18059 | 19400 | 232 |
2152254 | 2152254 | 2022-01-26 | Hancock | Iowa | 19081 | 2649 | 45 |
2152464 | 2152464 | 2022-01-26 | Hancock | Kentucky | 21091 | 2139 | 19 |
2152608 | 2152608 | 2022-01-26 | Hancock | Maine | 23009 | 4998 | 68 |
2152855 | 2152855 | 2022-01-26 | Hancock | Mississippi | 28045 | 10415 | 141 |
2153512 | 2153512 | 2022-01-26 | Hancock | Ohio | 39063 | 16306 | 237 |
2153981 | 2153981 | 2022-01-26 | Hancock | Tennessee | 47067 | 1670 | 29 |
2154534 | 2154534 | 2022-01-26 | Hancock | West Virginia | 54029 | 6201 | 130 |
2148625 | 2148625 | 2022-01-25 | Hancock | Georgia | 13141 | 1477 | 85 |
2148800 | 2148800 | 2022-01-25 | Hancock | Illinois | 17067 | 3954 | 53 |
2148899 | 2148899 | 2022-01-25 | Hancock | Indiana | 18059 | 19354 | 229 |
2149002 | 2149002 | 2022-01-25 | Hancock | Iowa | 19081 | 2573 | 45 |
2149212 | 2149212 | 2022-01-25 | Hancock | Kentucky | 21091 | 2104 | 19 |
2149356 | 2149356 | 2022-01-25 | Hancock | Maine | 23009 | 4943 | 68 |
2149603 | 2149603 | 2022-01-25 | Hancock | Mississippi | 28045 | 10339 | 141 |
2150260 | 2150260 | 2022-01-25 | Hancock | Ohio | 39063 | 16125 | 237 |
2150729 | 2150729 | 2022-01-25 | Hancock | Tennessee | 47067 | 1584 | 29 |
2151281 | 2151281 | 2022-01-25 | Hancock | West Virginia | 54029 | 6149 | 130 |
2145373 | 2145373 | 2022-01-24 | Hancock | Georgia | 13141 | 1450 | 84 |
2145548 | 2145548 | 2022-01-24 | Hancock | Illinois | 17067 | 3915 | 53 |
2145647 | 2145647 | 2022-01-24 | Hancock | Indiana | 18059 | 19345 | 227 |
2145750 | 2145750 | 2022-01-24 | Hancock | Iowa | 19081 | 2573 | 45 |
2145960 | 2145960 | 2022-01-24 | Hancock | Kentucky | 21091 | 2085 | 19 |
2146104 | 2146104 | 2022-01-24 | Hancock | Maine | 23009 | 4924 | 68 |
2146351 | 2146351 | 2022-01-24 | Hancock | Mississippi | 28045 | 10282 | 141 |
2147008 | 2147008 | 2022-01-24 | Hancock | Ohio | 39063 | 16115 | 232 |
2147477 | 2147477 | 2022-01-24 | Hancock | Tennessee | 47067 | 1584 | 29 |
2148029 | 2148029 | 2022-01-24 | Hancock | West Virginia | 54029 | 6115 | 130 |
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);