ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,557 rows where county = "Westmoreland" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501911 | 2501911 | 2022-05-13 | Westmoreland | Pennsylvania | 42129 | 81006 | 1378 |
2502637 | 2502637 | 2022-05-13 | Westmoreland | Virginia | 51193 | 3284 | 52 |
2498653 | 2498653 | 2022-05-12 | Westmoreland | Pennsylvania | 42129 | 81006 | 1378 |
2499379 | 2499379 | 2022-05-12 | Westmoreland | Virginia | 51193 | 3278 | 52 |
2495395 | 2495395 | 2022-05-11 | Westmoreland | Pennsylvania | 42129 | 81006 | 1378 |
2496121 | 2496121 | 2022-05-11 | Westmoreland | Virginia | 51193 | 3276 | 52 |
2492137 | 2492137 | 2022-05-10 | Westmoreland | Pennsylvania | 42129 | 80538 | 1376 |
2492863 | 2492863 | 2022-05-10 | Westmoreland | Virginia | 51193 | 3278 | 52 |
2488879 | 2488879 | 2022-05-09 | Westmoreland | Pennsylvania | 42129 | 80538 | 1376 |
2489605 | 2489605 | 2022-05-09 | Westmoreland | Virginia | 51193 | 3278 | 52 |
2485622 | 2485622 | 2022-05-08 | Westmoreland | Pennsylvania | 42129 | 80538 | 1376 |
2486348 | 2486348 | 2022-05-08 | Westmoreland | Virginia | 51193 | 3274 | 51 |
2482364 | 2482364 | 2022-05-07 | Westmoreland | Pennsylvania | 42129 | 80538 | 1376 |
2483090 | 2483090 | 2022-05-07 | Westmoreland | Virginia | 51193 | 3274 | 51 |
2479106 | 2479106 | 2022-05-06 | Westmoreland | Pennsylvania | 42129 | 80538 | 1376 |
2479832 | 2479832 | 2022-05-06 | Westmoreland | Virginia | 51193 | 3274 | 51 |
2475848 | 2475848 | 2022-05-05 | Westmoreland | Pennsylvania | 42129 | 80538 | 1376 |
2476574 | 2476574 | 2022-05-05 | Westmoreland | Virginia | 51193 | 3271 | 51 |
2472591 | 2472591 | 2022-05-04 | Westmoreland | Pennsylvania | 42129 | 80538 | 1376 |
2473316 | 2473316 | 2022-05-04 | Westmoreland | Virginia | 51193 | 3268 | 51 |
2469335 | 2469335 | 2022-05-03 | Westmoreland | Pennsylvania | 42129 | 80490 | 1376 |
2470060 | 2470060 | 2022-05-03 | Westmoreland | Virginia | 51193 | 3267 | 51 |
2466079 | 2466079 | 2022-05-02 | Westmoreland | Pennsylvania | 42129 | 80457 | 1373 |
2466804 | 2466804 | 2022-05-02 | Westmoreland | Virginia | 51193 | 3265 | 51 |
2462824 | 2462824 | 2022-05-01 | Westmoreland | Pennsylvania | 42129 | 80440 | 1373 |
2463549 | 2463549 | 2022-05-01 | Westmoreland | Virginia | 51193 | 3263 | 51 |
2459568 | 2459568 | 2022-04-30 | Westmoreland | Pennsylvania | 42129 | 80391 | 1373 |
2460293 | 2460293 | 2022-04-30 | Westmoreland | Virginia | 51193 | 3263 | 51 |
2456312 | 2456312 | 2022-04-29 | Westmoreland | Pennsylvania | 42129 | 80343 | 1373 |
2457037 | 2457037 | 2022-04-29 | Westmoreland | Virginia | 51193 | 3263 | 51 |
2453056 | 2453056 | 2022-04-28 | Westmoreland | Pennsylvania | 42129 | 80301 | 1373 |
2453781 | 2453781 | 2022-04-28 | Westmoreland | Virginia | 51193 | 3262 | 51 |
2449800 | 2449800 | 2022-04-27 | Westmoreland | Pennsylvania | 42129 | 80236 | 1373 |
2450525 | 2450525 | 2022-04-27 | Westmoreland | Virginia | 51193 | 3261 | 51 |
2446543 | 2446543 | 2022-04-26 | Westmoreland | Pennsylvania | 42129 | 80170 | 1373 |
2447269 | 2447269 | 2022-04-26 | Westmoreland | Virginia | 51193 | 3259 | 51 |
2443288 | 2443288 | 2022-04-25 | Westmoreland | Pennsylvania | 42129 | 80142 | 1374 |
2444013 | 2444013 | 2022-04-25 | Westmoreland | Virginia | 51193 | 3258 | 51 |
2440032 | 2440032 | 2022-04-24 | Westmoreland | Pennsylvania | 42129 | 80105 | 1374 |
2440757 | 2440757 | 2022-04-24 | Westmoreland | Virginia | 51193 | 3256 | 51 |
2436776 | 2436776 | 2022-04-23 | Westmoreland | Pennsylvania | 42129 | 80087 | 1374 |
2437501 | 2437501 | 2022-04-23 | Westmoreland | Virginia | 51193 | 3256 | 51 |
2433520 | 2433520 | 2022-04-22 | Westmoreland | Pennsylvania | 42129 | 80035 | 1374 |
2434245 | 2434245 | 2022-04-22 | Westmoreland | Virginia | 51193 | 3256 | 51 |
2430264 | 2430264 | 2022-04-21 | Westmoreland | Pennsylvania | 42129 | 80008 | 1374 |
2430989 | 2430989 | 2022-04-21 | Westmoreland | Virginia | 51193 | 3256 | 51 |
2427008 | 2427008 | 2022-04-20 | Westmoreland | Pennsylvania | 42129 | 79972 | 1372 |
2427733 | 2427733 | 2022-04-20 | Westmoreland | Virginia | 51193 | 3256 | 51 |
2423752 | 2423752 | 2022-04-19 | Westmoreland | Pennsylvania | 42129 | 79925 | 1372 |
2424477 | 2424477 | 2022-04-19 | Westmoreland | Virginia | 51193 | 3256 | 51 |
2420496 | 2420496 | 2022-04-18 | Westmoreland | Pennsylvania | 42129 | 79893 | 1370 |
2421221 | 2421221 | 2022-04-18 | Westmoreland | Virginia | 51193 | 3256 | 51 |
2417240 | 2417240 | 2022-04-17 | Westmoreland | Pennsylvania | 42129 | 79885 | 1370 |
2417965 | 2417965 | 2022-04-17 | Westmoreland | Virginia | 51193 | 3256 | 51 |
2413984 | 2413984 | 2022-04-16 | Westmoreland | Pennsylvania | 42129 | 79875 | 1370 |
2414709 | 2414709 | 2022-04-16 | Westmoreland | Virginia | 51193 | 3256 | 51 |
2410728 | 2410728 | 2022-04-15 | Westmoreland | Pennsylvania | 42129 | 79835 | 1370 |
2411453 | 2411453 | 2022-04-15 | Westmoreland | Virginia | 51193 | 3256 | 51 |
2407472 | 2407472 | 2022-04-14 | Westmoreland | Pennsylvania | 42129 | 79818 | 1370 |
2408197 | 2408197 | 2022-04-14 | Westmoreland | Virginia | 51193 | 3252 | 51 |
2404216 | 2404216 | 2022-04-13 | Westmoreland | Pennsylvania | 42129 | 79792 | 1369 |
2404941 | 2404941 | 2022-04-13 | Westmoreland | Virginia | 51193 | 3254 | 51 |
2400961 | 2400961 | 2022-04-12 | Westmoreland | Pennsylvania | 42129 | 79759 | 1369 |
2401686 | 2401686 | 2022-04-12 | Westmoreland | Virginia | 51193 | 3254 | 51 |
2397706 | 2397706 | 2022-04-11 | Westmoreland | Pennsylvania | 42129 | 79738 | 1367 |
2398431 | 2398431 | 2022-04-11 | Westmoreland | Virginia | 51193 | 3253 | 50 |
2394451 | 2394451 | 2022-04-10 | Westmoreland | Pennsylvania | 42129 | 79726 | 1367 |
2395176 | 2395176 | 2022-04-10 | Westmoreland | Virginia | 51193 | 3252 | 50 |
2391195 | 2391195 | 2022-04-09 | Westmoreland | Pennsylvania | 42129 | 79714 | 1367 |
2391920 | 2391920 | 2022-04-09 | Westmoreland | Virginia | 51193 | 3252 | 50 |
2387939 | 2387939 | 2022-04-08 | Westmoreland | Pennsylvania | 42129 | 79699 | 1367 |
2388664 | 2388664 | 2022-04-08 | Westmoreland | Virginia | 51193 | 3252 | 50 |
2384684 | 2384684 | 2022-04-07 | Westmoreland | Pennsylvania | 42129 | 79675 | 1367 |
2385409 | 2385409 | 2022-04-07 | Westmoreland | Virginia | 51193 | 3251 | 50 |
2381429 | 2381429 | 2022-04-06 | Westmoreland | Pennsylvania | 42129 | 79652 | 1367 |
2382154 | 2382154 | 2022-04-06 | Westmoreland | Virginia | 51193 | 3251 | 50 |
2378174 | 2378174 | 2022-04-05 | Westmoreland | Pennsylvania | 42129 | 79631 | 1366 |
2378899 | 2378899 | 2022-04-05 | Westmoreland | Virginia | 51193 | 3250 | 50 |
2374920 | 2374920 | 2022-04-04 | Westmoreland | Pennsylvania | 42129 | 79612 | 1365 |
2375645 | 2375645 | 2022-04-04 | Westmoreland | Virginia | 51193 | 3246 | 50 |
2371668 | 2371668 | 2022-04-03 | Westmoreland | Pennsylvania | 42129 | 79603 | 1364 |
2372393 | 2372393 | 2022-04-03 | Westmoreland | Virginia | 51193 | 3245 | 50 |
2368415 | 2368415 | 2022-04-02 | Westmoreland | Pennsylvania | 42129 | 79603 | 1364 |
2369140 | 2369140 | 2022-04-02 | Westmoreland | Virginia | 51193 | 3245 | 50 |
2365162 | 2365162 | 2022-04-01 | Westmoreland | Pennsylvania | 42129 | 79584 | 1363 |
2365887 | 2365887 | 2022-04-01 | Westmoreland | Virginia | 51193 | 3245 | 50 |
2361909 | 2361909 | 2022-03-31 | Westmoreland | Pennsylvania | 42129 | 79566 | 1362 |
2362634 | 2362634 | 2022-03-31 | Westmoreland | Virginia | 51193 | 3243 | 50 |
2358655 | 2358655 | 2022-03-30 | Westmoreland | Pennsylvania | 42129 | 79556 | 1362 |
2359380 | 2359380 | 2022-03-30 | Westmoreland | Virginia | 51193 | 3244 | 50 |
2355401 | 2355401 | 2022-03-29 | Westmoreland | Pennsylvania | 42129 | 79541 | 1362 |
2356126 | 2356126 | 2022-03-29 | Westmoreland | Virginia | 51193 | 3244 | 50 |
2352148 | 2352148 | 2022-03-28 | Westmoreland | Pennsylvania | 42129 | 79529 | 1362 |
2352873 | 2352873 | 2022-03-28 | Westmoreland | Virginia | 51193 | 3242 | 50 |
2348896 | 2348896 | 2022-03-27 | Westmoreland | Pennsylvania | 42129 | 79523 | 1362 |
2349621 | 2349621 | 2022-03-27 | Westmoreland | Virginia | 51193 | 3242 | 50 |
2345643 | 2345643 | 2022-03-26 | Westmoreland | Pennsylvania | 42129 | 79518 | 1362 |
2346368 | 2346368 | 2022-03-26 | Westmoreland | Virginia | 51193 | 3242 | 50 |
2342390 | 2342390 | 2022-03-25 | Westmoreland | Pennsylvania | 42129 | 79514 | 1361 |
2343115 | 2343115 | 2022-03-25 | Westmoreland | Virginia | 51193 | 3242 | 50 |
Advanced export
JSON shape: default, array, newline-delimited
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);