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 = "Westmoreland" 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 · 771 ✖

fips 1

county 1

  • Westmoreland · 771 ✖
Link rowid date ▲ county state fips cases deaths
2502637 2502637 2022-05-13 Westmoreland Virginia 51193 3284 52
2499379 2499379 2022-05-12 Westmoreland Virginia 51193 3278 52
2496121 2496121 2022-05-11 Westmoreland Virginia 51193 3276 52
2492863 2492863 2022-05-10 Westmoreland Virginia 51193 3278 52
2489605 2489605 2022-05-09 Westmoreland Virginia 51193 3278 52
2486348 2486348 2022-05-08 Westmoreland Virginia 51193 3274 51
2483090 2483090 2022-05-07 Westmoreland Virginia 51193 3274 51
2479832 2479832 2022-05-06 Westmoreland Virginia 51193 3274 51
2476574 2476574 2022-05-05 Westmoreland Virginia 51193 3271 51
2473316 2473316 2022-05-04 Westmoreland Virginia 51193 3268 51
2470060 2470060 2022-05-03 Westmoreland Virginia 51193 3267 51
2466804 2466804 2022-05-02 Westmoreland Virginia 51193 3265 51
2463549 2463549 2022-05-01 Westmoreland Virginia 51193 3263 51
2460293 2460293 2022-04-30 Westmoreland Virginia 51193 3263 51
2457037 2457037 2022-04-29 Westmoreland Virginia 51193 3263 51
2453781 2453781 2022-04-28 Westmoreland Virginia 51193 3262 51
2450525 2450525 2022-04-27 Westmoreland Virginia 51193 3261 51
2447269 2447269 2022-04-26 Westmoreland Virginia 51193 3259 51
2444013 2444013 2022-04-25 Westmoreland Virginia 51193 3258 51
2440757 2440757 2022-04-24 Westmoreland Virginia 51193 3256 51
2437501 2437501 2022-04-23 Westmoreland Virginia 51193 3256 51
2434245 2434245 2022-04-22 Westmoreland Virginia 51193 3256 51
2430989 2430989 2022-04-21 Westmoreland Virginia 51193 3256 51
2427733 2427733 2022-04-20 Westmoreland Virginia 51193 3256 51
2424477 2424477 2022-04-19 Westmoreland Virginia 51193 3256 51
2421221 2421221 2022-04-18 Westmoreland Virginia 51193 3256 51
2417965 2417965 2022-04-17 Westmoreland Virginia 51193 3256 51
2414709 2414709 2022-04-16 Westmoreland Virginia 51193 3256 51
2411453 2411453 2022-04-15 Westmoreland Virginia 51193 3256 51
2408197 2408197 2022-04-14 Westmoreland Virginia 51193 3252 51
2404941 2404941 2022-04-13 Westmoreland Virginia 51193 3254 51
2401686 2401686 2022-04-12 Westmoreland Virginia 51193 3254 51
2398431 2398431 2022-04-11 Westmoreland Virginia 51193 3253 50
2395176 2395176 2022-04-10 Westmoreland Virginia 51193 3252 50
2391920 2391920 2022-04-09 Westmoreland Virginia 51193 3252 50
2388664 2388664 2022-04-08 Westmoreland Virginia 51193 3252 50
2385409 2385409 2022-04-07 Westmoreland Virginia 51193 3251 50
2382154 2382154 2022-04-06 Westmoreland Virginia 51193 3251 50
2378899 2378899 2022-04-05 Westmoreland Virginia 51193 3250 50
2375645 2375645 2022-04-04 Westmoreland Virginia 51193 3246 50
2372393 2372393 2022-04-03 Westmoreland Virginia 51193 3245 50
2369140 2369140 2022-04-02 Westmoreland Virginia 51193 3245 50
2365887 2365887 2022-04-01 Westmoreland Virginia 51193 3245 50
2362634 2362634 2022-03-31 Westmoreland Virginia 51193 3243 50
2359380 2359380 2022-03-30 Westmoreland Virginia 51193 3244 50
2356126 2356126 2022-03-29 Westmoreland Virginia 51193 3244 50
2352873 2352873 2022-03-28 Westmoreland Virginia 51193 3242 50
2349621 2349621 2022-03-27 Westmoreland Virginia 51193 3242 50
2346368 2346368 2022-03-26 Westmoreland Virginia 51193 3242 50
2343115 2343115 2022-03-25 Westmoreland Virginia 51193 3242 50
2339862 2339862 2022-03-24 Westmoreland Virginia 51193 3241 50
2336609 2336609 2022-03-23 Westmoreland Virginia 51193 3241 50
2333355 2333355 2022-03-22 Westmoreland Virginia 51193 3236 50
2330101 2330101 2022-03-21 Westmoreland Virginia 51193 3236 50
2326849 2326849 2022-03-20 Westmoreland Virginia 51193 3233 50
2323596 2323596 2022-03-19 Westmoreland Virginia 51193 3233 50
2320342 2320342 2022-03-18 Westmoreland Virginia 51193 3233 50
2317088 2317088 2022-03-17 Westmoreland Virginia 51193 3230 50
2313835 2313835 2022-03-16 Westmoreland Virginia 51193 3228 50
2310582 2310582 2022-03-15 Westmoreland Virginia 51193 3225 50
2307329 2307329 2022-03-14 Westmoreland Virginia 51193 3225 50
2304078 2304078 2022-03-13 Westmoreland Virginia 51193 3224 50
2300826 2300826 2022-03-12 Westmoreland Virginia 51193 3224 50
2297574 2297574 2022-03-11 Westmoreland Virginia 51193 3224 50
2294322 2294322 2022-03-10 Westmoreland Virginia 51193 3224 49
2291070 2291070 2022-03-09 Westmoreland Virginia 51193 3222 49
2287818 2287818 2022-03-08 Westmoreland Virginia 51193 3221 49
2284566 2284566 2022-03-07 Westmoreland Virginia 51193 3219 49
2281314 2281314 2022-03-06 Westmoreland Virginia 51193 3216 48
2278061 2278061 2022-03-05 Westmoreland Virginia 51193 3216 48
2274808 2274808 2022-03-04 Westmoreland Virginia 51193 3216 48
2271555 2271555 2022-03-03 Westmoreland Virginia 51193 3216 47
2268303 2268303 2022-03-02 Westmoreland Virginia 51193 3210 47
2265050 2265050 2022-03-01 Westmoreland Virginia 51193 3208 47
2261800 2261800 2022-02-28 Westmoreland Virginia 51193 3208 46
2258549 2258549 2022-02-27 Westmoreland Virginia 51193 3206 46
2255298 2255298 2022-02-26 Westmoreland Virginia 51193 3206 46
2252047 2252047 2022-02-25 Westmoreland Virginia 51193 3206 46
2248796 2248796 2022-02-24 Westmoreland Virginia 51193 3205 46
2245545 2245545 2022-02-23 Westmoreland Virginia 51193 3201 46
2242294 2242294 2022-02-22 Westmoreland Virginia 51193 3197 46
2239043 2239043 2022-02-21 Westmoreland Virginia 51193 3193 46
2235792 2235792 2022-02-20 Westmoreland Virginia 51193 3183 45
2232541 2232541 2022-02-19 Westmoreland Virginia 51193 3183 45
2229290 2229290 2022-02-18 Westmoreland Virginia 51193 3183 45
2226039 2226039 2022-02-17 Westmoreland Virginia 51193 3181 45
2222788 2222788 2022-02-16 Westmoreland Virginia 51193 3178 44
2219537 2219537 2022-02-15 Westmoreland Virginia 51193 3177 43
2216287 2216287 2022-02-14 Westmoreland Virginia 51193 3176 43
2213036 2213036 2022-02-13 Westmoreland Virginia 51193 3168 42
2209783 2209783 2022-02-12 Westmoreland Virginia 51193 3168 42
2206530 2206530 2022-02-11 Westmoreland Virginia 51193 3168 42
2203277 2203277 2022-02-10 Westmoreland Virginia 51193 3167 42
2200023 2200023 2022-02-09 Westmoreland Virginia 51193 3159 42
2196769 2196769 2022-02-08 Westmoreland Virginia 51193 3153 42
2193514 2193514 2022-02-07 Westmoreland Virginia 51193 3146 42
2190261 2190261 2022-02-06 Westmoreland Virginia 51193 3121 41
2187008 2187008 2022-02-05 Westmoreland Virginia 51193 3121 41
2183755 2183755 2022-02-04 Westmoreland Virginia 51193 3121 41
2180503 2180503 2022-02-03 Westmoreland Virginia 51193 3106 41

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