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

775 rows where county = "Henry" and state = "Virginia" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Virginia · 775 ✖

fips 1

county 1

  • Henry · 775 ✖
Link rowid date ▲ county state fips cases deaths
2502569 2502569 2022-05-13 Henry Virginia 51089 12205 266
2499311 2499311 2022-05-12 Henry Virginia 51089 12189 266
2496053 2496053 2022-05-11 Henry Virginia 51089 12179 266
2492795 2492795 2022-05-10 Henry Virginia 51089 12164 266
2489537 2489537 2022-05-09 Henry Virginia 51089 12146 265
2486280 2486280 2022-05-08 Henry Virginia 51089 12127 265
2483022 2483022 2022-05-07 Henry Virginia 51089 12127 265
2479764 2479764 2022-05-06 Henry Virginia 51089 12127 265
2476506 2476506 2022-05-05 Henry Virginia 51089 12107 265
2473248 2473248 2022-05-04 Henry Virginia 51089 12093 265
2469992 2469992 2022-05-03 Henry Virginia 51089 12074 265
2466736 2466736 2022-05-02 Henry Virginia 51089 12057 264
2463481 2463481 2022-05-01 Henry Virginia 51089 12019 264
2460225 2460225 2022-04-30 Henry Virginia 51089 12019 264
2456969 2456969 2022-04-29 Henry Virginia 51089 12019 264
2453713 2453713 2022-04-28 Henry Virginia 51089 11997 263
2450457 2450457 2022-04-27 Henry Virginia 51089 11983 263
2447200 2447200 2022-04-26 Henry Virginia 51089 11967 263
2443945 2443945 2022-04-25 Henry Virginia 51089 11953 263
2440689 2440689 2022-04-24 Henry Virginia 51089 11887 264
2437433 2437433 2022-04-23 Henry Virginia 51089 11887 264
2434177 2434177 2022-04-22 Henry Virginia 51089 11887 264
2430921 2430921 2022-04-21 Henry Virginia 51089 11869 264
2427665 2427665 2022-04-20 Henry Virginia 51089 11850 264
2424409 2424409 2022-04-19 Henry Virginia 51089 11836 263
2421153 2421153 2022-04-18 Henry Virginia 51089 11814 262
2417897 2417897 2022-04-17 Henry Virginia 51089 11791 261
2414641 2414641 2022-04-16 Henry Virginia 51089 11791 261
2411385 2411385 2022-04-15 Henry Virginia 51089 11791 261
2408129 2408129 2022-04-14 Henry Virginia 51089 11778 261
2404873 2404873 2022-04-13 Henry Virginia 51089 11769 261
2401618 2401618 2022-04-12 Henry Virginia 51089 11761 261
2398363 2398363 2022-04-11 Henry Virginia 51089 11753 261
2395108 2395108 2022-04-10 Henry Virginia 51089 11732 261
2391852 2391852 2022-04-09 Henry Virginia 51089 11732 261
2388596 2388596 2022-04-08 Henry Virginia 51089 11732 261
2385341 2385341 2022-04-07 Henry Virginia 51089 11717 260
2382086 2382086 2022-04-06 Henry Virginia 51089 11679 260
2378831 2378831 2022-04-05 Henry Virginia 51089 11668 260
2375577 2375577 2022-04-04 Henry Virginia 51089 11653 260
2372325 2372325 2022-04-03 Henry Virginia 51089 11626 260
2369072 2369072 2022-04-02 Henry Virginia 51089 11626 260
2365819 2365819 2022-04-01 Henry Virginia 51089 11626 260
2362566 2362566 2022-03-31 Henry Virginia 51089 11621 260
2359312 2359312 2022-03-30 Henry Virginia 51089 11600 260
2356058 2356058 2022-03-29 Henry Virginia 51089 11599 260
2352805 2352805 2022-03-28 Henry Virginia 51089 11591 260
2349553 2349553 2022-03-27 Henry Virginia 51089 11584 260
2346300 2346300 2022-03-26 Henry Virginia 51089 11584 260
2343047 2343047 2022-03-25 Henry Virginia 51089 11584 260
2339794 2339794 2022-03-24 Henry Virginia 51089 11575 259
2336540 2336540 2022-03-23 Henry Virginia 51089 11560 258
2333286 2333286 2022-03-22 Henry Virginia 51089 11544 255
2330033 2330033 2022-03-21 Henry Virginia 51089 11544 255
2326781 2326781 2022-03-20 Henry Virginia 51089 11483 254
2323528 2323528 2022-03-19 Henry Virginia 51089 11483 254
2320274 2320274 2022-03-18 Henry Virginia 51089 11483 254
2317020 2317020 2022-03-17 Henry Virginia 51089 11411 253
2313767 2313767 2022-03-16 Henry Virginia 51089 11360 253
2310514 2310514 2022-03-15 Henry Virginia 51089 11312 251
2307261 2307261 2022-03-14 Henry Virginia 51089 11294 250
2304010 2304010 2022-03-13 Henry Virginia 51089 11292 247
2300758 2300758 2022-03-12 Henry Virginia 51089 11292 247
2297506 2297506 2022-03-11 Henry Virginia 51089 11292 247
2294254 2294254 2022-03-10 Henry Virginia 51089 11276 247
2291002 2291002 2022-03-09 Henry Virginia 51089 11277 246
2287750 2287750 2022-03-08 Henry Virginia 51089 11272 245
2284498 2284498 2022-03-07 Henry Virginia 51089 11271 243
2281246 2281246 2022-03-06 Henry Virginia 51089 11249 242
2277993 2277993 2022-03-05 Henry Virginia 51089 11249 242
2274740 2274740 2022-03-04 Henry Virginia 51089 11249 242
2271487 2271487 2022-03-03 Henry Virginia 51089 11245 241
2268235 2268235 2022-03-02 Henry Virginia 51089 11244 241
2264982 2264982 2022-03-01 Henry Virginia 51089 11241 241
2261732 2261732 2022-02-28 Henry Virginia 51089 11233 241
2258481 2258481 2022-02-27 Henry Virginia 51089 11202 237
2255230 2255230 2022-02-26 Henry Virginia 51089 11202 237
2251979 2251979 2022-02-25 Henry Virginia 51089 11202 237
2248728 2248728 2022-02-24 Henry Virginia 51089 11192 237
2245477 2245477 2022-02-23 Henry Virginia 51089 11176 235
2242226 2242226 2022-02-22 Henry Virginia 51089 11161 234
2238975 2238975 2022-02-21 Henry Virginia 51089 11159 233
2235724 2235724 2022-02-20 Henry Virginia 51089 11036 233
2232473 2232473 2022-02-19 Henry Virginia 51089 11036 233
2229222 2229222 2022-02-18 Henry Virginia 51089 11036 233
2225971 2225971 2022-02-17 Henry Virginia 51089 11007 233
2222720 2222720 2022-02-16 Henry Virginia 51089 10944 231
2219469 2219469 2022-02-15 Henry Virginia 51089 10885 230
2216219 2216219 2022-02-14 Henry Virginia 51089 10801 228
2212968 2212968 2022-02-13 Henry Virginia 51089 10645 227
2209715 2209715 2022-02-12 Henry Virginia 51089 10645 227
2206462 2206462 2022-02-11 Henry Virginia 51089 10645 227
2203209 2203209 2022-02-10 Henry Virginia 51089 10615 227
2199955 2199955 2022-02-09 Henry Virginia 51089 10577 227
2196701 2196701 2022-02-08 Henry Virginia 51089 10554 225
2193446 2193446 2022-02-07 Henry Virginia 51089 10525 224
2190193 2190193 2022-02-06 Henry Virginia 51089 10452 221
2186940 2186940 2022-02-05 Henry Virginia 51089 10452 221
2183687 2183687 2022-02-04 Henry Virginia 51089 10452 221
2180435 2180435 2022-02-03 Henry Virginia 51089 10370 221

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