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

771 rows where county = "Henry" and fips = 1067 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 1067 · 771 ✖

county 1

  • Henry · 771 ✖
Link rowid date ▲ county state fips cases deaths
2499608 2499608 2022-05-13 Henry Alabama 1067 4584 76
2496350 2496350 2022-05-12 Henry Alabama 1067 4582 76
2493092 2493092 2022-05-11 Henry Alabama 1067 4581 76
2489834 2489834 2022-05-10 Henry Alabama 1067 4579 76
2486577 2486577 2022-05-09 Henry Alabama 1067 4577 76
2483319 2483319 2022-05-08 Henry Alabama 1067 4574 76
2480061 2480061 2022-05-07 Henry Alabama 1067 4574 76
2476803 2476803 2022-05-06 Henry Alabama 1067 4574 76
2473545 2473545 2022-05-05 Henry Alabama 1067 4572 76
2470288 2470288 2022-05-04 Henry Alabama 1067 4572 76
2467032 2467032 2022-05-03 Henry Alabama 1067 4571 76
2463777 2463777 2022-05-02 Henry Alabama 1067 4572 75
2460521 2460521 2022-05-01 Henry Alabama 1067 4572 75
2457265 2457265 2022-04-30 Henry Alabama 1067 4572 75
2454009 2454009 2022-04-29 Henry Alabama 1067 4572 75
2450753 2450753 2022-04-28 Henry Alabama 1067 4572 75
2447497 2447497 2022-04-27 Henry Alabama 1067 4572 75
2444241 2444241 2022-04-26 Henry Alabama 1067 4571 75
2440985 2440985 2022-04-25 Henry Alabama 1067 4571 75
2437729 2437729 2022-04-24 Henry Alabama 1067 4571 75
2434473 2434473 2022-04-23 Henry Alabama 1067 4571 75
2431217 2431217 2022-04-22 Henry Alabama 1067 4571 75
2427961 2427961 2022-04-21 Henry Alabama 1067 4571 75
2424705 2424705 2022-04-20 Henry Alabama 1067 4571 75
2421449 2421449 2022-04-19 Henry Alabama 1067 4571 75
2418193 2418193 2022-04-18 Henry Alabama 1067 4571 75
2414937 2414937 2022-04-17 Henry Alabama 1067 4571 75
2411681 2411681 2022-04-16 Henry Alabama 1067 4571 75
2408425 2408425 2022-04-15 Henry Alabama 1067 4571 75
2405169 2405169 2022-04-14 Henry Alabama 1067 4571 75
2401914 2401914 2022-04-13 Henry Alabama 1067 4571 75
2398659 2398659 2022-04-12 Henry Alabama 1067 4571 75
2395404 2395404 2022-04-11 Henry Alabama 1067 4571 75
2392148 2392148 2022-04-10 Henry Alabama 1067 4571 75
2388892 2388892 2022-04-09 Henry Alabama 1067 4571 75
2385637 2385637 2022-04-08 Henry Alabama 1067 4571 75
2382382 2382382 2022-04-07 Henry Alabama 1067 4571 75
2379127 2379127 2022-04-06 Henry Alabama 1067 4571 75
2375873 2375873 2022-04-05 Henry Alabama 1067 4571 75
2372621 2372621 2022-04-04 Henry Alabama 1067 4571 75
2369368 2369368 2022-04-03 Henry Alabama 1067 4571 75
2366115 2366115 2022-04-02 Henry Alabama 1067 4571 75
2362862 2362862 2022-04-01 Henry Alabama 1067 4571 75
2359608 2359608 2022-03-31 Henry Alabama 1067 4571 75
2356354 2356354 2022-03-30 Henry Alabama 1067 4571 75
2353101 2353101 2022-03-29 Henry Alabama 1067 4571 75
2349849 2349849 2022-03-28 Henry Alabama 1067 4571 74
2346596 2346596 2022-03-27 Henry Alabama 1067 4451 74
2343343 2343343 2022-03-26 Henry Alabama 1067 4451 74
2340090 2340090 2022-03-25 Henry Alabama 1067 4451 74
2336837 2336837 2022-03-24 Henry Alabama 1067 4452 73
2333583 2333583 2022-03-23 Henry Alabama 1067 4450 73
2330329 2330329 2022-03-22 Henry Alabama 1067 4450 73
2327077 2327077 2022-03-21 Henry Alabama 1067 4450 73
2323824 2323824 2022-03-20 Henry Alabama 1067 4450 73
2320570 2320570 2022-03-19 Henry Alabama 1067 4450 73
2317316 2317316 2022-03-18 Henry Alabama 1067 4450 73
2314063 2314063 2022-03-17 Henry Alabama 1067 4450 73
2310810 2310810 2022-03-16 Henry Alabama 1067 4447 72
2307557 2307557 2022-03-15 Henry Alabama 1067 4447 72
2304306 2304306 2022-03-14 Henry Alabama 1067 4447 71
2301054 2301054 2022-03-13 Henry Alabama 1067 4447 71
2297802 2297802 2022-03-12 Henry Alabama 1067 4447 71
2294550 2294550 2022-03-11 Henry Alabama 1067 4447 71
2291298 2291298 2022-03-10 Henry Alabama 1067 4447 71
2288046 2288046 2022-03-09 Henry Alabama 1067 4446 71
2284794 2284794 2022-03-08 Henry Alabama 1067 4447 71
2281542 2281542 2022-03-07 Henry Alabama 1067 4446 70
2278289 2278289 2022-03-06 Henry Alabama 1067 4445 70
2275036 2275036 2022-03-05 Henry Alabama 1067 4445 70
2271783 2271783 2022-03-04 Henry Alabama 1067 4445 70
2268531 2268531 2022-03-03 Henry Alabama 1067 4444 70
2265278 2265278 2022-03-02 Henry Alabama 1067 4440 70
2262028 2262028 2022-03-01 Henry Alabama 1067 4439 70
2258777 2258777 2022-02-28 Henry Alabama 1067 4434 69
2255526 2255526 2022-02-27 Henry Alabama 1067 4433 69
2252275 2252275 2022-02-26 Henry Alabama 1067 4433 69
2249024 2249024 2022-02-25 Henry Alabama 1067 4430 69
2245773 2245773 2022-02-24 Henry Alabama 1067 4427 69
2242522 2242522 2022-02-23 Henry Alabama 1067 4422 69
2239271 2239271 2022-02-22 Henry Alabama 1067 4419 69
2236020 2236020 2022-02-21 Henry Alabama 1067 4416 69
2232769 2232769 2022-02-20 Henry Alabama 1067 4416 69
2229518 2229518 2022-02-19 Henry Alabama 1067 4415 69
2226267 2226267 2022-02-18 Henry Alabama 1067 4407 69
2223016 2223016 2022-02-17 Henry Alabama 1067 4403 69
2219765 2219765 2022-02-16 Henry Alabama 1067 4395 69
2216515 2216515 2022-02-15 Henry Alabama 1067 4389 68
2213264 2213264 2022-02-14 Henry Alabama 1067 4387 68
2210011 2210011 2022-02-13 Henry Alabama 1067 4385 68
2206758 2206758 2022-02-12 Henry Alabama 1067 4383 68
2203505 2203505 2022-02-11 Henry Alabama 1067 4374 68
2200251 2200251 2022-02-10 Henry Alabama 1067 4364 68
2196997 2196997 2022-02-09 Henry Alabama 1067 4355 67
2193742 2193742 2022-02-08 Henry Alabama 1067 4341 67
2190489 2190489 2022-02-07 Henry Alabama 1067 4320 67
2187236 2187236 2022-02-06 Henry Alabama 1067 4312 67
2183983 2183983 2022-02-05 Henry Alabama 1067 4312 67
2180731 2180731 2022-02-04 Henry Alabama 1067 4305 67
2177480 2177480 2022-02-03 Henry Alabama 1067 4256 67

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