ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,555 rows where county = "Northumberland" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501895 | 2501895 | 2022-05-13 | Northumberland | Pennsylvania | 42097 | 23172 | 534 |
2502597 | 2502597 | 2022-05-13 | Northumberland | Virginia | 51133 | 2216 | 46 |
2498637 | 2498637 | 2022-05-12 | Northumberland | Pennsylvania | 42097 | 23172 | 534 |
2499339 | 2499339 | 2022-05-12 | Northumberland | Virginia | 51133 | 2211 | 46 |
2495379 | 2495379 | 2022-05-11 | Northumberland | Pennsylvania | 42097 | 23172 | 534 |
2496081 | 2496081 | 2022-05-11 | Northumberland | Virginia | 51133 | 2207 | 46 |
2492121 | 2492121 | 2022-05-10 | Northumberland | Pennsylvania | 42097 | 23013 | 534 |
2492823 | 2492823 | 2022-05-10 | Northumberland | Virginia | 51133 | 2207 | 46 |
2488863 | 2488863 | 2022-05-09 | Northumberland | Pennsylvania | 42097 | 23013 | 534 |
2489565 | 2489565 | 2022-05-09 | Northumberland | Virginia | 51133 | 2206 | 46 |
2485606 | 2485606 | 2022-05-08 | Northumberland | Pennsylvania | 42097 | 23013 | 534 |
2486308 | 2486308 | 2022-05-08 | Northumberland | Virginia | 51133 | 2198 | 46 |
2482348 | 2482348 | 2022-05-07 | Northumberland | Pennsylvania | 42097 | 23013 | 534 |
2483050 | 2483050 | 2022-05-07 | Northumberland | Virginia | 51133 | 2198 | 46 |
2479090 | 2479090 | 2022-05-06 | Northumberland | Pennsylvania | 42097 | 23013 | 534 |
2479792 | 2479792 | 2022-05-06 | Northumberland | Virginia | 51133 | 2198 | 46 |
2475832 | 2475832 | 2022-05-05 | Northumberland | Pennsylvania | 42097 | 23013 | 534 |
2476534 | 2476534 | 2022-05-05 | Northumberland | Virginia | 51133 | 2196 | 46 |
2472575 | 2472575 | 2022-05-04 | Northumberland | Pennsylvania | 42097 | 23013 | 534 |
2473276 | 2473276 | 2022-05-04 | Northumberland | Virginia | 51133 | 2193 | 46 |
2469319 | 2469319 | 2022-05-03 | Northumberland | Pennsylvania | 42097 | 22985 | 534 |
2470020 | 2470020 | 2022-05-03 | Northumberland | Virginia | 51133 | 2190 | 46 |
2466063 | 2466063 | 2022-05-02 | Northumberland | Pennsylvania | 42097 | 22973 | 533 |
2466764 | 2466764 | 2022-05-02 | Northumberland | Virginia | 51133 | 2190 | 46 |
2462808 | 2462808 | 2022-05-01 | Northumberland | Pennsylvania | 42097 | 22969 | 533 |
2463509 | 2463509 | 2022-05-01 | Northumberland | Virginia | 51133 | 2179 | 46 |
2459552 | 2459552 | 2022-04-30 | Northumberland | Pennsylvania | 42097 | 22964 | 533 |
2460253 | 2460253 | 2022-04-30 | Northumberland | Virginia | 51133 | 2179 | 46 |
2456296 | 2456296 | 2022-04-29 | Northumberland | Pennsylvania | 42097 | 22952 | 533 |
2456997 | 2456997 | 2022-04-29 | Northumberland | Virginia | 51133 | 2179 | 46 |
2453040 | 2453040 | 2022-04-28 | Northumberland | Pennsylvania | 42097 | 22936 | 533 |
2453741 | 2453741 | 2022-04-28 | Northumberland | Virginia | 51133 | 2177 | 46 |
2449784 | 2449784 | 2022-04-27 | Northumberland | Pennsylvania | 42097 | 22919 | 533 |
2450485 | 2450485 | 2022-04-27 | Northumberland | Virginia | 51133 | 2175 | 46 |
2446527 | 2446527 | 2022-04-26 | Northumberland | Pennsylvania | 42097 | 22906 | 533 |
2447228 | 2447228 | 2022-04-26 | Northumberland | Virginia | 51133 | 2172 | 46 |
2443272 | 2443272 | 2022-04-25 | Northumberland | Pennsylvania | 42097 | 22893 | 533 |
2443973 | 2443973 | 2022-04-25 | Northumberland | Virginia | 51133 | 2173 | 46 |
2440016 | 2440016 | 2022-04-24 | Northumberland | Pennsylvania | 42097 | 22892 | 533 |
2440717 | 2440717 | 2022-04-24 | Northumberland | Virginia | 51133 | 2172 | 46 |
2436760 | 2436760 | 2022-04-23 | Northumberland | Pennsylvania | 42097 | 22889 | 533 |
2437461 | 2437461 | 2022-04-23 | Northumberland | Virginia | 51133 | 2172 | 46 |
2433504 | 2433504 | 2022-04-22 | Northumberland | Pennsylvania | 42097 | 22881 | 533 |
2434205 | 2434205 | 2022-04-22 | Northumberland | Virginia | 51133 | 2172 | 46 |
2430248 | 2430248 | 2022-04-21 | Northumberland | Pennsylvania | 42097 | 22877 | 533 |
2430949 | 2430949 | 2022-04-21 | Northumberland | Virginia | 51133 | 2172 | 46 |
2426992 | 2426992 | 2022-04-20 | Northumberland | Pennsylvania | 42097 | 22865 | 530 |
2427693 | 2427693 | 2022-04-20 | Northumberland | Virginia | 51133 | 2170 | 46 |
2423736 | 2423736 | 2022-04-19 | Northumberland | Pennsylvania | 42097 | 22857 | 530 |
2424437 | 2424437 | 2022-04-19 | Northumberland | Virginia | 51133 | 2170 | 46 |
2420480 | 2420480 | 2022-04-18 | Northumberland | Pennsylvania | 42097 | 22851 | 530 |
2421181 | 2421181 | 2022-04-18 | Northumberland | Virginia | 51133 | 2170 | 46 |
2417224 | 2417224 | 2022-04-17 | Northumberland | Pennsylvania | 42097 | 22850 | 530 |
2417925 | 2417925 | 2022-04-17 | Northumberland | Virginia | 51133 | 2169 | 46 |
2413968 | 2413968 | 2022-04-16 | Northumberland | Pennsylvania | 42097 | 22845 | 530 |
2414669 | 2414669 | 2022-04-16 | Northumberland | Virginia | 51133 | 2169 | 46 |
2410712 | 2410712 | 2022-04-15 | Northumberland | Pennsylvania | 42097 | 22842 | 530 |
2411413 | 2411413 | 2022-04-15 | Northumberland | Virginia | 51133 | 2169 | 46 |
2407456 | 2407456 | 2022-04-14 | Northumberland | Pennsylvania | 42097 | 22837 | 530 |
2408157 | 2408157 | 2022-04-14 | Northumberland | Virginia | 51133 | 2169 | 46 |
2404200 | 2404200 | 2022-04-13 | Northumberland | Pennsylvania | 42097 | 22834 | 530 |
2404901 | 2404901 | 2022-04-13 | Northumberland | Virginia | 51133 | 2168 | 46 |
2400945 | 2400945 | 2022-04-12 | Northumberland | Pennsylvania | 42097 | 22829 | 530 |
2401646 | 2401646 | 2022-04-12 | Northumberland | Virginia | 51133 | 2166 | 46 |
2397690 | 2397690 | 2022-04-11 | Northumberland | Pennsylvania | 42097 | 22826 | 530 |
2398391 | 2398391 | 2022-04-11 | Northumberland | Virginia | 51133 | 2166 | 46 |
2394435 | 2394435 | 2022-04-10 | Northumberland | Pennsylvania | 42097 | 22826 | 530 |
2395136 | 2395136 | 2022-04-10 | Northumberland | Virginia | 51133 | 2165 | 46 |
2391179 | 2391179 | 2022-04-09 | Northumberland | Pennsylvania | 42097 | 22821 | 530 |
2391880 | 2391880 | 2022-04-09 | Northumberland | Virginia | 51133 | 2165 | 46 |
2387923 | 2387923 | 2022-04-08 | Northumberland | Pennsylvania | 42097 | 22816 | 530 |
2388624 | 2388624 | 2022-04-08 | Northumberland | Virginia | 51133 | 2165 | 46 |
2384668 | 2384668 | 2022-04-07 | Northumberland | Pennsylvania | 42097 | 22812 | 529 |
2385369 | 2385369 | 2022-04-07 | Northumberland | Virginia | 51133 | 2165 | 45 |
2381413 | 2381413 | 2022-04-06 | Northumberland | Pennsylvania | 42097 | 22808 | 529 |
2382114 | 2382114 | 2022-04-06 | Northumberland | Virginia | 51133 | 2164 | 45 |
2378158 | 2378158 | 2022-04-05 | Northumberland | Pennsylvania | 42097 | 22802 | 529 |
2378859 | 2378859 | 2022-04-05 | Northumberland | Virginia | 51133 | 2163 | 44 |
2374904 | 2374904 | 2022-04-04 | Northumberland | Pennsylvania | 42097 | 22798 | 529 |
2375605 | 2375605 | 2022-04-04 | Northumberland | Virginia | 51133 | 2163 | 44 |
2371652 | 2371652 | 2022-04-03 | Northumberland | Pennsylvania | 42097 | 22794 | 529 |
2372353 | 2372353 | 2022-04-03 | Northumberland | Virginia | 51133 | 2162 | 44 |
2368399 | 2368399 | 2022-04-02 | Northumberland | Pennsylvania | 42097 | 22794 | 529 |
2369100 | 2369100 | 2022-04-02 | Northumberland | Virginia | 51133 | 2162 | 44 |
2365146 | 2365146 | 2022-04-01 | Northumberland | Pennsylvania | 42097 | 22788 | 529 |
2365847 | 2365847 | 2022-04-01 | Northumberland | Virginia | 51133 | 2162 | 44 |
2361893 | 2361893 | 2022-03-31 | Northumberland | Pennsylvania | 42097 | 22782 | 529 |
2362594 | 2362594 | 2022-03-31 | Northumberland | Virginia | 51133 | 2162 | 44 |
2358639 | 2358639 | 2022-03-30 | Northumberland | Pennsylvania | 42097 | 22780 | 529 |
2359340 | 2359340 | 2022-03-30 | Northumberland | Virginia | 51133 | 2162 | 44 |
2355385 | 2355385 | 2022-03-29 | Northumberland | Pennsylvania | 42097 | 22779 | 529 |
2356086 | 2356086 | 2022-03-29 | Northumberland | Virginia | 51133 | 2162 | 44 |
2352132 | 2352132 | 2022-03-28 | Northumberland | Pennsylvania | 42097 | 22773 | 529 |
2352833 | 2352833 | 2022-03-28 | Northumberland | Virginia | 51133 | 2162 | 44 |
2348880 | 2348880 | 2022-03-27 | Northumberland | Pennsylvania | 42097 | 22771 | 529 |
2349581 | 2349581 | 2022-03-27 | Northumberland | Virginia | 51133 | 2162 | 44 |
2345627 | 2345627 | 2022-03-26 | Northumberland | Pennsylvania | 42097 | 22768 | 529 |
2346328 | 2346328 | 2022-03-26 | Northumberland | Virginia | 51133 | 2162 | 44 |
2342374 | 2342374 | 2022-03-25 | Northumberland | Pennsylvania | 42097 | 22766 | 529 |
2343075 | 2343075 | 2022-03-25 | Northumberland | Virginia | 51133 | 2162 | 44 |
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);