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,786 rows where county = "Henry" 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

  • Henry · 7,786 ✖
Link rowid date ▲ county state fips cases deaths
2499608 2499608 2022-05-13 Henry Alabama 1067 4584 76
2500040 2500040 2022-05-13 Henry Georgia 13151 58353 688
2500213 2500213 2022-05-13 Henry Illinois 17073 12884 150
2500312 2500312 2022-05-13 Henry Indiana 18065 13055 231
2500416 2500416 2022-05-13 Henry Iowa 19087 5573 74
2500630 2500630 2022-05-13 Henry Kentucky 21103 4836 52
2501117 2501117 2022-05-13 Henry Missouri 29083 5758 86
2501678 2501678 2022-05-13 Henry Ohio 39069 6485 106
2502150 2502150 2022-05-13 Henry Tennessee 47079 8310 163
2502569 2502569 2022-05-13 Henry Virginia 51089 12205 266
2496350 2496350 2022-05-12 Henry Alabama 1067 4582 76
2496782 2496782 2022-05-12 Henry Georgia 13151 58353 688
2496955 2496955 2022-05-12 Henry Illinois 17073 12873 150
2497054 2497054 2022-05-12 Henry Indiana 18065 13044 231
2497158 2497158 2022-05-12 Henry Iowa 19087 5573 74
2497372 2497372 2022-05-12 Henry Kentucky 21103 4836 52
2497859 2497859 2022-05-12 Henry Missouri 29083 5750 86
2498420 2498420 2022-05-12 Henry Ohio 39069 6485 106
2498892 2498892 2022-05-12 Henry Tennessee 47079 8310 163
2499311 2499311 2022-05-12 Henry Virginia 51089 12189 266
2493092 2493092 2022-05-11 Henry Alabama 1067 4581 76
2493524 2493524 2022-05-11 Henry Georgia 13151 58353 688
2493697 2493697 2022-05-11 Henry Illinois 17073 12854 150
2493796 2493796 2022-05-11 Henry Indiana 18065 13044 231
2493900 2493900 2022-05-11 Henry Iowa 19087 5573 74
2494114 2494114 2022-05-11 Henry Kentucky 21103 4836 52
2494601 2494601 2022-05-11 Henry Missouri 29083 5750 86
2495162 2495162 2022-05-11 Henry Ohio 39069 6466 106
2495634 2495634 2022-05-11 Henry Tennessee 47079 8310 163
2496053 2496053 2022-05-11 Henry Virginia 51089 12179 266
2489834 2489834 2022-05-10 Henry Alabama 1067 4579 76
2490266 2490266 2022-05-10 Henry Georgia 13151 58148 687
2490439 2490439 2022-05-10 Henry Illinois 17073 12840 150
2490538 2490538 2022-05-10 Henry Indiana 18065 13037 231
2490642 2490642 2022-05-10 Henry Iowa 19087 5566 74
2490856 2490856 2022-05-10 Henry Kentucky 21103 4836 52
2491343 2491343 2022-05-10 Henry Missouri 29083 5750 86
2491904 2491904 2022-05-10 Henry Ohio 39069 6466 106
2492376 2492376 2022-05-10 Henry Tennessee 47079 8285 161
2492795 2492795 2022-05-10 Henry Virginia 51089 12164 266
2486577 2486577 2022-05-09 Henry Alabama 1067 4577 76
2487009 2487009 2022-05-09 Henry Georgia 13151 58148 687
2487182 2487182 2022-05-09 Henry Illinois 17073 12830 150
2487281 2487281 2022-05-09 Henry Indiana 18065 13037 231
2487385 2487385 2022-05-09 Henry Iowa 19087 5566 74
2487599 2487599 2022-05-09 Henry Kentucky 21103 4836 52
2488085 2488085 2022-05-09 Henry Missouri 29083 5750 86
2488646 2488646 2022-05-09 Henry Ohio 39069 6466 106
2489118 2489118 2022-05-09 Henry Tennessee 47079 8285 161
2489537 2489537 2022-05-09 Henry Virginia 51089 12146 265
2483319 2483319 2022-05-08 Henry Alabama 1067 4574 76
2483751 2483751 2022-05-08 Henry Georgia 13151 58146 687
2483924 2483924 2022-05-08 Henry Illinois 17073 12812 150
2484023 2484023 2022-05-08 Henry Indiana 18065 13020 231
2484127 2484127 2022-05-08 Henry Iowa 19087 5566 74
2484341 2484341 2022-05-08 Henry Kentucky 21103 4807 52
2484828 2484828 2022-05-08 Henry Missouri 29083 5750 86
2485389 2485389 2022-05-08 Henry Ohio 39069 6466 106
2485861 2485861 2022-05-08 Henry Tennessee 47079 8285 161
2486280 2486280 2022-05-08 Henry Virginia 51089 12127 265
2480061 2480061 2022-05-07 Henry Alabama 1067 4574 76
2480493 2480493 2022-05-07 Henry Georgia 13151 58146 687
2480666 2480666 2022-05-07 Henry Illinois 17073 12812 150
2480765 2480765 2022-05-07 Henry Indiana 18065 13020 231
2480869 2480869 2022-05-07 Henry Iowa 19087 5566 74
2481083 2481083 2022-05-07 Henry Kentucky 21103 4807 52
2481570 2481570 2022-05-07 Henry Missouri 29083 5750 86
2482131 2482131 2022-05-07 Henry Ohio 39069 6466 106
2482603 2482603 2022-05-07 Henry Tennessee 47079 8285 161
2483022 2483022 2022-05-07 Henry Virginia 51089 12127 265
2476803 2476803 2022-05-06 Henry Alabama 1067 4574 76
2477235 2477235 2022-05-06 Henry Georgia 13151 58146 687
2477408 2477408 2022-05-06 Henry Illinois 17073 12812 150
2477507 2477507 2022-05-06 Henry Indiana 18065 13020 231
2477611 2477611 2022-05-06 Henry Iowa 19087 5566 74
2477825 2477825 2022-05-06 Henry Kentucky 21103 4807 52
2478312 2478312 2022-05-06 Henry Missouri 29083 5750 86
2478873 2478873 2022-05-06 Henry Ohio 39069 6466 106
2479345 2479345 2022-05-06 Henry Tennessee 47079 8285 161
2479764 2479764 2022-05-06 Henry Virginia 51089 12127 265
2473545 2473545 2022-05-05 Henry Alabama 1067 4572 76
2473977 2473977 2022-05-05 Henry Georgia 13151 58146 687
2474150 2474150 2022-05-05 Henry Illinois 17073 12804 150
2474249 2474249 2022-05-05 Henry Indiana 18065 13020 231
2474353 2474353 2022-05-05 Henry Iowa 19087 5566 74
2474567 2474567 2022-05-05 Henry Kentucky 21103 4807 52
2475054 2475054 2022-05-05 Henry Missouri 29083 5741 86
2475615 2475615 2022-05-05 Henry Ohio 39069 6466 106
2476087 2476087 2022-05-05 Henry Tennessee 47079 8285 161
2476506 2476506 2022-05-05 Henry Virginia 51089 12107 265
2470288 2470288 2022-05-04 Henry Alabama 1067 4572 76
2470720 2470720 2022-05-04 Henry Georgia 13151 58146 687
2470893 2470893 2022-05-04 Henry Illinois 17073 12795 149
2470992 2470992 2022-05-04 Henry Indiana 18065 13020 231
2471096 2471096 2022-05-04 Henry Iowa 19087 5566 74
2471310 2471310 2022-05-04 Henry Kentucky 21103 4807 52
2471797 2471797 2022-05-04 Henry Missouri 29083 5741 83
2472358 2472358 2022-05-04 Henry Ohio 39069 6449 106
2472830 2472830 2022-05-04 Henry Tennessee 47079 8285 161
2473248 2473248 2022-05-04 Henry Virginia 51089 12093 265

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