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)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2339121 | 2339121 | 2022-03-24 | Northumberland | Pennsylvania | 42097 | 22761 | 528 |
2339822 | 2339822 | 2022-03-24 | Northumberland | Virginia | 51133 | 2161 | 44 |
2335867 | 2335867 | 2022-03-23 | Northumberland | Pennsylvania | 42097 | 22757 | 527 |
2336568 | 2336568 | 2022-03-23 | Northumberland | Virginia | 51133 | 2160 | 44 |
2332613 | 2332613 | 2022-03-22 | Northumberland | Pennsylvania | 42097 | 22751 | 527 |
2333314 | 2333314 | 2022-03-22 | Northumberland | Virginia | 51133 | 2157 | 44 |
2329360 | 2329360 | 2022-03-21 | Northumberland | Pennsylvania | 42097 | 22749 | 526 |
2330061 | 2330061 | 2022-03-21 | Northumberland | Virginia | 51133 | 2157 | 44 |
2326108 | 2326108 | 2022-03-20 | Northumberland | Pennsylvania | 42097 | 22748 | 526 |
2326809 | 2326809 | 2022-03-20 | Northumberland | Virginia | 51133 | 2153 | 44 |
2322855 | 2322855 | 2022-03-19 | Northumberland | Pennsylvania | 42097 | 22747 | 526 |
2323556 | 2323556 | 2022-03-19 | Northumberland | Virginia | 51133 | 2153 | 44 |
2319601 | 2319601 | 2022-03-18 | Northumberland | Pennsylvania | 42097 | 22740 | 526 |
2320302 | 2320302 | 2022-03-18 | Northumberland | Virginia | 51133 | 2153 | 44 |
2316347 | 2316347 | 2022-03-17 | Northumberland | Pennsylvania | 42097 | 22735 | 526 |
2317048 | 2317048 | 2022-03-17 | Northumberland | Virginia | 51133 | 2153 | 43 |
2313094 | 2313094 | 2022-03-16 | Northumberland | Pennsylvania | 42097 | 22729 | 526 |
2313795 | 2313795 | 2022-03-16 | Northumberland | Virginia | 51133 | 2153 | 43 |
2309841 | 2309841 | 2022-03-15 | Northumberland | Pennsylvania | 42097 | 22724 | 526 |
2310542 | 2310542 | 2022-03-15 | Northumberland | Virginia | 51133 | 2152 | 43 |
2306588 | 2306588 | 2022-03-14 | Northumberland | Pennsylvania | 42097 | 22725 | 526 |
2307289 | 2307289 | 2022-03-14 | Northumberland | Virginia | 51133 | 2152 | 43 |
2303337 | 2303337 | 2022-03-13 | Northumberland | Pennsylvania | 42097 | 22724 | 526 |
2304038 | 2304038 | 2022-03-13 | Northumberland | Virginia | 51133 | 2147 | 43 |
2300085 | 2300085 | 2022-03-12 | Northumberland | Pennsylvania | 42097 | 22719 | 526 |
2300786 | 2300786 | 2022-03-12 | Northumberland | Virginia | 51133 | 2147 | 43 |
2296833 | 2296833 | 2022-03-11 | Northumberland | Pennsylvania | 42097 | 22716 | 526 |
2297534 | 2297534 | 2022-03-11 | Northumberland | Virginia | 51133 | 2147 | 43 |
2293581 | 2293581 | 2022-03-10 | Northumberland | Pennsylvania | 42097 | 22708 | 525 |
2294282 | 2294282 | 2022-03-10 | Northumberland | Virginia | 51133 | 2146 | 43 |
2290329 | 2290329 | 2022-03-09 | Northumberland | Pennsylvania | 42097 | 22699 | 525 |
2291030 | 2291030 | 2022-03-09 | Northumberland | Virginia | 51133 | 2144 | 43 |
2287077 | 2287077 | 2022-03-08 | Northumberland | Pennsylvania | 42097 | 22687 | 525 |
2287778 | 2287778 | 2022-03-08 | Northumberland | Virginia | 51133 | 2144 | 43 |
2283825 | 2283825 | 2022-03-07 | Northumberland | Pennsylvania | 42097 | 22681 | 522 |
2284526 | 2284526 | 2022-03-07 | Northumberland | Virginia | 51133 | 2143 | 43 |
2280573 | 2280573 | 2022-03-06 | Northumberland | Pennsylvania | 42097 | 22680 | 522 |
2281274 | 2281274 | 2022-03-06 | Northumberland | Virginia | 51133 | 2147 | 43 |
2277320 | 2277320 | 2022-03-05 | Northumberland | Pennsylvania | 42097 | 22677 | 521 |
2278021 | 2278021 | 2022-03-05 | Northumberland | Virginia | 51133 | 2147 | 43 |
2274067 | 2274067 | 2022-03-04 | Northumberland | Pennsylvania | 42097 | 22672 | 521 |
2274768 | 2274768 | 2022-03-04 | Northumberland | Virginia | 51133 | 2147 | 43 |
2270814 | 2270814 | 2022-03-03 | Northumberland | Pennsylvania | 42097 | 22663 | 521 |
2271515 | 2271515 | 2022-03-03 | Northumberland | Virginia | 51133 | 2146 | 43 |
2267562 | 2267562 | 2022-03-02 | Northumberland | Pennsylvania | 42097 | 22645 | 521 |
2268263 | 2268263 | 2022-03-02 | Northumberland | Virginia | 51133 | 2144 | 43 |
2264309 | 2264309 | 2022-03-01 | Northumberland | Pennsylvania | 42097 | 22632 | 521 |
2265010 | 2265010 | 2022-03-01 | Northumberland | Virginia | 51133 | 2142 | 43 |
2261059 | 2261059 | 2022-02-28 | Northumberland | Pennsylvania | 42097 | 22622 | 519 |
2261760 | 2261760 | 2022-02-28 | Northumberland | Virginia | 51133 | 2142 | 43 |
2257808 | 2257808 | 2022-02-27 | Northumberland | Pennsylvania | 42097 | 22616 | 519 |
2258509 | 2258509 | 2022-02-27 | Northumberland | Virginia | 51133 | 2140 | 43 |
2254557 | 2254557 | 2022-02-26 | Northumberland | Pennsylvania | 42097 | 22609 | 519 |
2255258 | 2255258 | 2022-02-26 | Northumberland | Virginia | 51133 | 2140 | 43 |
2251306 | 2251306 | 2022-02-25 | Northumberland | Pennsylvania | 42097 | 22596 | 517 |
2252007 | 2252007 | 2022-02-25 | Northumberland | Virginia | 51133 | 2140 | 43 |
2248055 | 2248055 | 2022-02-24 | Northumberland | Pennsylvania | 42097 | 22588 | 515 |
2248756 | 2248756 | 2022-02-24 | Northumberland | Virginia | 51133 | 2139 | 43 |
2244804 | 2244804 | 2022-02-23 | Northumberland | Pennsylvania | 42097 | 22575 | 514 |
2245505 | 2245505 | 2022-02-23 | Northumberland | Virginia | 51133 | 2135 | 43 |
2241553 | 2241553 | 2022-02-22 | Northumberland | Pennsylvania | 42097 | 22551 | 512 |
2242254 | 2242254 | 2022-02-22 | Northumberland | Virginia | 51133 | 2136 | 43 |
2238302 | 2238302 | 2022-02-21 | Northumberland | Pennsylvania | 42097 | 22521 | 512 |
2239003 | 2239003 | 2022-02-21 | Northumberland | Virginia | 51133 | 2135 | 43 |
2235051 | 2235051 | 2022-02-20 | Northumberland | Pennsylvania | 42097 | 22521 | 512 |
2235752 | 2235752 | 2022-02-20 | Northumberland | Virginia | 51133 | 2126 | 43 |
2231800 | 2231800 | 2022-02-19 | Northumberland | Pennsylvania | 42097 | 22505 | 511 |
2232501 | 2232501 | 2022-02-19 | Northumberland | Virginia | 51133 | 2126 | 43 |
2228549 | 2228549 | 2022-02-18 | Northumberland | Pennsylvania | 42097 | 22472 | 511 |
2229250 | 2229250 | 2022-02-18 | Northumberland | Virginia | 51133 | 2126 | 43 |
2225298 | 2225298 | 2022-02-17 | Northumberland | Pennsylvania | 42097 | 22445 | 510 |
2225999 | 2225999 | 2022-02-17 | Northumberland | Virginia | 51133 | 2123 | 42 |
2222047 | 2222047 | 2022-02-16 | Northumberland | Pennsylvania | 42097 | 22424 | 508 |
2222748 | 2222748 | 2022-02-16 | Northumberland | Virginia | 51133 | 2124 | 42 |
2218796 | 2218796 | 2022-02-15 | Northumberland | Pennsylvania | 42097 | 22386 | 504 |
2219497 | 2219497 | 2022-02-15 | Northumberland | Virginia | 51133 | 2123 | 42 |
2215545 | 2215545 | 2022-02-14 | Northumberland | Pennsylvania | 42097 | 22357 | 504 |
2216247 | 2216247 | 2022-02-14 | Northumberland | Virginia | 51133 | 2119 | 42 |
2212294 | 2212294 | 2022-02-13 | Northumberland | Pennsylvania | 42097 | 22338 | 504 |
2212996 | 2212996 | 2022-02-13 | Northumberland | Virginia | 51133 | 2107 | 41 |
2209041 | 2209041 | 2022-02-12 | Northumberland | Pennsylvania | 42097 | 22325 | 504 |
2209743 | 2209743 | 2022-02-12 | Northumberland | Virginia | 51133 | 2107 | 41 |
2205788 | 2205788 | 2022-02-11 | Northumberland | Pennsylvania | 42097 | 22294 | 504 |
2206490 | 2206490 | 2022-02-11 | Northumberland | Virginia | 51133 | 2107 | 41 |
2202535 | 2202535 | 2022-02-10 | Northumberland | Pennsylvania | 42097 | 22242 | 504 |
2203237 | 2203237 | 2022-02-10 | Northumberland | Virginia | 51133 | 2102 | 41 |
2199281 | 2199281 | 2022-02-09 | Northumberland | Pennsylvania | 42097 | 22207 | 504 |
2199983 | 2199983 | 2022-02-09 | Northumberland | Virginia | 51133 | 2092 | 41 |
2196027 | 2196027 | 2022-02-08 | Northumberland | Pennsylvania | 42097 | 22140 | 504 |
2196729 | 2196729 | 2022-02-08 | Northumberland | Virginia | 51133 | 2079 | 41 |
2192773 | 2192773 | 2022-02-07 | Northumberland | Pennsylvania | 42097 | 22154 | 502 |
2193474 | 2193474 | 2022-02-07 | Northumberland | Virginia | 51133 | 2073 | 41 |
2189519 | 2189519 | 2022-02-06 | Northumberland | Pennsylvania | 42097 | 22089 | 501 |
2190221 | 2190221 | 2022-02-06 | Northumberland | Virginia | 51133 | 2044 | 41 |
2186266 | 2186266 | 2022-02-05 | Northumberland | Pennsylvania | 42097 | 22067 | 501 |
2186968 | 2186968 | 2022-02-05 | Northumberland | Virginia | 51133 | 2044 | 41 |
2183014 | 2183014 | 2022-02-04 | Northumberland | Pennsylvania | 42097 | 21977 | 499 |
2183715 | 2183715 | 2022-02-04 | Northumberland | Virginia | 51133 | 2044 | 41 |
2179762 | 2179762 | 2022-02-03 | Northumberland | Pennsylvania | 42097 | 21887 | 498 |
2180463 | 2180463 | 2022-02-03 | Northumberland | Virginia | 51133 | 2036 | 41 |
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);