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

778 rows where county = "Henry" and fips = 18065 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

  • 18065 · 778 ✖

county 1

  • Henry · 778 ✖
Link rowid date ▲ county state fips cases deaths
2500312 2500312 2022-05-13 Henry Indiana 18065 13055 231
2497054 2497054 2022-05-12 Henry Indiana 18065 13044 231
2493796 2493796 2022-05-11 Henry Indiana 18065 13044 231
2490538 2490538 2022-05-10 Henry Indiana 18065 13037 231
2487281 2487281 2022-05-09 Henry Indiana 18065 13037 231
2484023 2484023 2022-05-08 Henry Indiana 18065 13020 231
2480765 2480765 2022-05-07 Henry Indiana 18065 13020 231
2477507 2477507 2022-05-06 Henry Indiana 18065 13020 231
2474249 2474249 2022-05-05 Henry Indiana 18065 13020 231
2470992 2470992 2022-05-04 Henry Indiana 18065 13020 231
2467736 2467736 2022-05-03 Henry Indiana 18065 13013 231
2464481 2464481 2022-05-02 Henry Indiana 18065 13013 231
2461225 2461225 2022-05-01 Henry Indiana 18065 13008 231
2457969 2457969 2022-04-30 Henry Indiana 18065 13008 231
2454713 2454713 2022-04-29 Henry Indiana 18065 13008 231
2451457 2451457 2022-04-28 Henry Indiana 18065 13003 231
2448201 2448201 2022-04-27 Henry Indiana 18065 13003 231
2444945 2444945 2022-04-26 Henry Indiana 18065 12992 231
2441689 2441689 2022-04-25 Henry Indiana 18065 12992 231
2438433 2438433 2022-04-24 Henry Indiana 18065 12991 231
2435177 2435177 2022-04-23 Henry Indiana 18065 12991 231
2431921 2431921 2022-04-22 Henry Indiana 18065 12991 231
2428665 2428665 2022-04-21 Henry Indiana 18065 12986 230
2425409 2425409 2022-04-20 Henry Indiana 18065 12986 230
2422153 2422153 2022-04-19 Henry Indiana 18065 12984 230
2418897 2418897 2022-04-18 Henry Indiana 18065 12984 230
2415641 2415641 2022-04-17 Henry Indiana 18065 12980 230
2412385 2412385 2022-04-16 Henry Indiana 18065 12980 230
2409129 2409129 2022-04-15 Henry Indiana 18065 12980 230
2405873 2405873 2022-04-14 Henry Indiana 18065 12980 230
2402618 2402618 2022-04-13 Henry Indiana 18065 12980 230
2399363 2399363 2022-04-12 Henry Indiana 18065 12975 230
2396108 2396108 2022-04-11 Henry Indiana 18065 12975 230
2392852 2392852 2022-04-10 Henry Indiana 18065 12971 230
2389596 2389596 2022-04-09 Henry Indiana 18065 12971 230
2386341 2386341 2022-04-08 Henry Indiana 18065 12971 230
2383086 2383086 2022-04-07 Henry Indiana 18065 12969 230
2379831 2379831 2022-04-06 Henry Indiana 18065 12969 230
2376577 2376577 2022-04-05 Henry Indiana 18065 12965 230
2373325 2373325 2022-04-04 Henry Indiana 18065 12965 230
2370072 2370072 2022-04-03 Henry Indiana 18065 12965 230
2366819 2366819 2022-04-02 Henry Indiana 18065 12965 230
2363566 2363566 2022-04-01 Henry Indiana 18065 12965 230
2360312 2360312 2022-03-31 Henry Indiana 18065 12961 229
2357058 2357058 2022-03-30 Henry Indiana 18065 12961 229
2353805 2353805 2022-03-29 Henry Indiana 18065 12979 229
2350553 2350553 2022-03-28 Henry Indiana 18065 12976 229
2347300 2347300 2022-03-27 Henry Indiana 18065 12975 229
2344047 2344047 2022-03-26 Henry Indiana 18065 12975 229
2340794 2340794 2022-03-25 Henry Indiana 18065 12975 229
2337541 2337541 2022-03-24 Henry Indiana 18065 12973 228
2334287 2334287 2022-03-23 Henry Indiana 18065 12973 228
2331033 2331033 2022-03-22 Henry Indiana 18065 12971 228
2327781 2327781 2022-03-21 Henry Indiana 18065 12968 228
2324528 2324528 2022-03-20 Henry Indiana 18065 12960 228
2321274 2321274 2022-03-19 Henry Indiana 18065 12960 228
2318020 2318020 2022-03-18 Henry Indiana 18065 12960 228
2314767 2314767 2022-03-17 Henry Indiana 18065 12958 228
2311514 2311514 2022-03-16 Henry Indiana 18065 12956 228
2308261 2308261 2022-03-15 Henry Indiana 18065 12951 227
2305010 2305010 2022-03-14 Henry Indiana 18065 12948 227
2301758 2301758 2022-03-13 Henry Indiana 18065 12944 227
2298506 2298506 2022-03-12 Henry Indiana 18065 12944 227
2295254 2295254 2022-03-11 Henry Indiana 18065 12944 227
2292002 2292002 2022-03-10 Henry Indiana 18065 12941 227
2288750 2288750 2022-03-09 Henry Indiana 18065 12939 227
2285499 2285499 2022-03-08 Henry Indiana 18065 12930 227
2282247 2282247 2022-03-07 Henry Indiana 18065 12919 227
2278994 2278994 2022-03-06 Henry Indiana 18065 12914 227
2275741 2275741 2022-03-05 Henry Indiana 18065 12914 227
2272488 2272488 2022-03-04 Henry Indiana 18065 12914 227
2269236 2269236 2022-03-03 Henry Indiana 18065 12910 226
2265983 2265983 2022-03-02 Henry Indiana 18065 12906 226
2262732 2262732 2022-03-01 Henry Indiana 18065 12900 226
2259481 2259481 2022-02-28 Henry Indiana 18065 12896 226
2256230 2256230 2022-02-27 Henry Indiana 18065 12887 226
2252979 2252979 2022-02-26 Henry Indiana 18065 12887 226
2249728 2249728 2022-02-25 Henry Indiana 18065 12887 226
2246477 2246477 2022-02-24 Henry Indiana 18065 12878 224
2243226 2243226 2022-02-23 Henry Indiana 18065 12874 223
2239975 2239975 2022-02-22 Henry Indiana 18065 12858 223
2236724 2236724 2022-02-21 Henry Indiana 18065 12850 222
2233473 2233473 2022-02-20 Henry Indiana 18065 12834 222
2230222 2230222 2022-02-19 Henry Indiana 18065 12834 222
2226971 2226971 2022-02-18 Henry Indiana 18065 12834 222
2223720 2223720 2022-02-17 Henry Indiana 18065 12820 220
2220469 2220469 2022-02-16 Henry Indiana 18065 12810 219
2217218 2217218 2022-02-15 Henry Indiana 18065 12797 219
2213967 2213967 2022-02-14 Henry Indiana 18065 12781 218
2210715 2210715 2022-02-13 Henry Indiana 18065 12747 217
2207462 2207462 2022-02-12 Henry Indiana 18065 12747 217
2204209 2204209 2022-02-11 Henry Indiana 18065 12747 217
2200956 2200956 2022-02-10 Henry Indiana 18065 12723 217
2197702 2197702 2022-02-09 Henry Indiana 18065 12677 214
2194448 2194448 2022-02-08 Henry Indiana 18065 12677 214
2191194 2191194 2022-02-07 Henry Indiana 18065 12656 214
2187941 2187941 2022-02-06 Henry Indiana 18065 12623 214
2184688 2184688 2022-02-05 Henry Indiana 18065 12623 214
2181436 2181436 2022-02-04 Henry Indiana 18065 12623 214
2178185 2178185 2022-02-03 Henry Indiana 18065 12585 213

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