ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

7,721 rows where county = "Hancock" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 10

fips 10

county 1

  • Hancock · 7,721 ✖
Link rowid date ▲ county state fips cases deaths
2500035 2500035 2022-05-13 Hancock Georgia 13141 1587 90
2500210 2500210 2022-05-13 Hancock Illinois 17067 4420 58
2500309 2500309 2022-05-13 Hancock Indiana 18059 20888 258
2500413 2500413 2022-05-13 Hancock Iowa 19081 2867 47
2500624 2500624 2022-05-13 Hancock Kentucky 21091 2498 25
2500768 2500768 2022-05-13 Hancock Maine 23009 7983 87
2501015 2501015 2022-05-13 Hancock Mississippi 28045 12277 152
2501675 2501675 2022-05-13 Hancock Ohio 39063 17253 277
2502144 2502144 2022-05-13 Hancock Tennessee 47067 2023 37
2502697 2502697 2022-05-13 Hancock West Virginia 54029 6809 142
2496777 2496777 2022-05-12 Hancock Georgia 13141 1587 90
2496952 2496952 2022-05-12 Hancock Illinois 17067 4419 58
2497051 2497051 2022-05-12 Hancock Indiana 18059 20849 258
2497155 2497155 2022-05-12 Hancock Iowa 19081 2867 47
2497366 2497366 2022-05-12 Hancock Kentucky 21091 2498 25
2497510 2497510 2022-05-12 Hancock Maine 23009 7954 87
2497757 2497757 2022-05-12 Hancock Mississippi 28045 12277 152
2498417 2498417 2022-05-12 Hancock Ohio 39063 17253 277
2498886 2498886 2022-05-12 Hancock Tennessee 47067 2023 37
2499439 2499439 2022-05-12 Hancock West Virginia 54029 6805 142
2493519 2493519 2022-05-11 Hancock Georgia 13141 1587 90
2493694 2493694 2022-05-11 Hancock Illinois 17067 4417 58
2493793 2493793 2022-05-11 Hancock Indiana 18059 20849 258
2493897 2493897 2022-05-11 Hancock Iowa 19081 2867 47
2494108 2494108 2022-05-11 Hancock Kentucky 21091 2498 25
2494252 2494252 2022-05-11 Hancock Maine 23009 7895 87
2494499 2494499 2022-05-11 Hancock Mississippi 28045 12277 152
2495159 2495159 2022-05-11 Hancock Ohio 39063 17193 277
2495628 2495628 2022-05-11 Hancock Tennessee 47067 2023 37
2496181 2496181 2022-05-11 Hancock West Virginia 54029 6797 142
2490261 2490261 2022-05-10 Hancock Georgia 13141 1586 90
2490436 2490436 2022-05-10 Hancock Illinois 17067 4413 58
2490535 2490535 2022-05-10 Hancock Indiana 18059 20831 258
2490639 2490639 2022-05-10 Hancock Iowa 19081 2848 47
2490850 2490850 2022-05-10 Hancock Kentucky 21091 2498 25
2490994 2490994 2022-05-10 Hancock Maine 23009 7843 87
2491241 2491241 2022-05-10 Hancock Mississippi 28045 12277 152
2491901 2491901 2022-05-10 Hancock Ohio 39063 17193 277
2492370 2492370 2022-05-10 Hancock Tennessee 47067 2013 37
2492923 2492923 2022-05-10 Hancock West Virginia 54029 6783 142
2487004 2487004 2022-05-09 Hancock Georgia 13141 1586 90
2487179 2487179 2022-05-09 Hancock Illinois 17067 4412 58
2487278 2487278 2022-05-09 Hancock Indiana 18059 20831 258
2487382 2487382 2022-05-09 Hancock Iowa 19081 2848 47
2487593 2487593 2022-05-09 Hancock Kentucky 21091 2498 25
2487737 2487737 2022-05-09 Hancock Maine 23009 7812 87
2487984 2487984 2022-05-09 Hancock Mississippi 28045 12277 152
2488643 2488643 2022-05-09 Hancock Ohio 39063 17193 277
2489112 2489112 2022-05-09 Hancock Tennessee 47067 2013 37
2489665 2489665 2022-05-09 Hancock West Virginia 54029 6783 142
2483746 2483746 2022-05-08 Hancock Georgia 13141 1586 90
2483921 2483921 2022-05-08 Hancock Illinois 17067 4408 58
2484020 2484020 2022-05-08 Hancock Indiana 18059 20778 258
2484124 2484124 2022-05-08 Hancock Iowa 19081 2848 47
2484335 2484335 2022-05-08 Hancock Kentucky 21091 2495 24
2484479 2484479 2022-05-08 Hancock Maine 23009 7793 87
2484726 2484726 2022-05-08 Hancock Mississippi 28045 12235 152
2485386 2485386 2022-05-08 Hancock Ohio 39063 17193 277
2485855 2485855 2022-05-08 Hancock Tennessee 47067 2013 37
2486408 2486408 2022-05-08 Hancock West Virginia 54029 6758 142
2480488 2480488 2022-05-07 Hancock Georgia 13141 1586 90
2480663 2480663 2022-05-07 Hancock Illinois 17067 4408 58
2480762 2480762 2022-05-07 Hancock Indiana 18059 20778 258
2480866 2480866 2022-05-07 Hancock Iowa 19081 2848 47
2481077 2481077 2022-05-07 Hancock Kentucky 21091 2495 24
2481221 2481221 2022-05-07 Hancock Maine 23009 7793 87
2481468 2481468 2022-05-07 Hancock Mississippi 28045 12235 152
2482128 2482128 2022-05-07 Hancock Ohio 39063 17193 277
2482597 2482597 2022-05-07 Hancock Tennessee 47067 2013 37
2483150 2483150 2022-05-07 Hancock West Virginia 54029 6758 142
2477230 2477230 2022-05-06 Hancock Georgia 13141 1586 90
2477405 2477405 2022-05-06 Hancock Illinois 17067 4408 58
2477504 2477504 2022-05-06 Hancock Indiana 18059 20778 258
2477608 2477608 2022-05-06 Hancock Iowa 19081 2848 47
2477819 2477819 2022-05-06 Hancock Kentucky 21091 2495 24
2477963 2477963 2022-05-06 Hancock Maine 23009 7757 87
2478210 2478210 2022-05-06 Hancock Mississippi 28045 12235 152
2478870 2478870 2022-05-06 Hancock Ohio 39063 17193 277
2479339 2479339 2022-05-06 Hancock Tennessee 47067 2013 37
2479892 2479892 2022-05-06 Hancock West Virginia 54029 6758 142
2473972 2473972 2022-05-05 Hancock Georgia 13141 1586 90
2474147 2474147 2022-05-05 Hancock Illinois 17067 4407 58
2474246 2474246 2022-05-05 Hancock Indiana 18059 20778 258
2474350 2474350 2022-05-05 Hancock Iowa 19081 2848 47
2474561 2474561 2022-05-05 Hancock Kentucky 21091 2495 24
2474705 2474705 2022-05-05 Hancock Maine 23009 7723 87
2474952 2474952 2022-05-05 Hancock Mississippi 28045 12235 152
2475612 2475612 2022-05-05 Hancock Ohio 39063 17193 277
2476081 2476081 2022-05-05 Hancock Tennessee 47067 2013 37
2476634 2476634 2022-05-05 Hancock West Virginia 54029 6752 142
2470715 2470715 2022-05-04 Hancock Georgia 13141 1586 90
2470890 2470890 2022-05-04 Hancock Illinois 17067 4404 58
2470989 2470989 2022-05-04 Hancock Indiana 18059 20778 258
2471093 2471093 2022-05-04 Hancock Iowa 19081 2848 47
2471304 2471304 2022-05-04 Hancock Kentucky 21091 2495 24
2471448 2471448 2022-05-04 Hancock Maine 23009 7702 85
2471695 2471695 2022-05-04 Hancock Mississippi 28045 12235 152
2472355 2472355 2022-05-04 Hancock Ohio 39063 17153 274
2472824 2472824 2022-05-04 Hancock Tennessee 47067 2013 37
2473376 2473376 2022-05-04 Hancock West Virginia 54029 6748 142

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);