ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Mercer" and state = "Pennsylvania" 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 |
---|---|---|---|---|---|---|---|
2501889 | 2501889 | 2022-05-13 | Mercer | Pennsylvania | 42085 | 23612 | 498 |
2498631 | 2498631 | 2022-05-12 | Mercer | Pennsylvania | 42085 | 23612 | 498 |
2495373 | 2495373 | 2022-05-11 | Mercer | Pennsylvania | 42085 | 23612 | 498 |
2492115 | 2492115 | 2022-05-10 | Mercer | Pennsylvania | 42085 | 23500 | 498 |
2488857 | 2488857 | 2022-05-09 | Mercer | Pennsylvania | 42085 | 23500 | 498 |
2485600 | 2485600 | 2022-05-08 | Mercer | Pennsylvania | 42085 | 23500 | 498 |
2482342 | 2482342 | 2022-05-07 | Mercer | Pennsylvania | 42085 | 23500 | 498 |
2479084 | 2479084 | 2022-05-06 | Mercer | Pennsylvania | 42085 | 23500 | 498 |
2475826 | 2475826 | 2022-05-05 | Mercer | Pennsylvania | 42085 | 23500 | 498 |
2472569 | 2472569 | 2022-05-04 | Mercer | Pennsylvania | 42085 | 23500 | 498 |
2469313 | 2469313 | 2022-05-03 | Mercer | Pennsylvania | 42085 | 23486 | 498 |
2466057 | 2466057 | 2022-05-02 | Mercer | Pennsylvania | 42085 | 23476 | 498 |
2462802 | 2462802 | 2022-05-01 | Mercer | Pennsylvania | 42085 | 23470 | 497 |
2459546 | 2459546 | 2022-04-30 | Mercer | Pennsylvania | 42085 | 23459 | 497 |
2456290 | 2456290 | 2022-04-29 | Mercer | Pennsylvania | 42085 | 23449 | 496 |
2453034 | 2453034 | 2022-04-28 | Mercer | Pennsylvania | 42085 | 23436 | 496 |
2449778 | 2449778 | 2022-04-27 | Mercer | Pennsylvania | 42085 | 23424 | 496 |
2446521 | 2446521 | 2022-04-26 | Mercer | Pennsylvania | 42085 | 23407 | 496 |
2443266 | 2443266 | 2022-04-25 | Mercer | Pennsylvania | 42085 | 23398 | 496 |
2440010 | 2440010 | 2022-04-24 | Mercer | Pennsylvania | 42085 | 23394 | 496 |
2436754 | 2436754 | 2022-04-23 | Mercer | Pennsylvania | 42085 | 23391 | 496 |
2433498 | 2433498 | 2022-04-22 | Mercer | Pennsylvania | 42085 | 23378 | 496 |
2430242 | 2430242 | 2022-04-21 | Mercer | Pennsylvania | 42085 | 23373 | 496 |
2426986 | 2426986 | 2022-04-20 | Mercer | Pennsylvania | 42085 | 23368 | 496 |
2423730 | 2423730 | 2022-04-19 | Mercer | Pennsylvania | 42085 | 23361 | 496 |
2420474 | 2420474 | 2022-04-18 | Mercer | Pennsylvania | 42085 | 23353 | 496 |
2417218 | 2417218 | 2022-04-17 | Mercer | Pennsylvania | 42085 | 23352 | 496 |
2413962 | 2413962 | 2022-04-16 | Mercer | Pennsylvania | 42085 | 23348 | 496 |
2410706 | 2410706 | 2022-04-15 | Mercer | Pennsylvania | 42085 | 23339 | 496 |
2407450 | 2407450 | 2022-04-14 | Mercer | Pennsylvania | 42085 | 23336 | 496 |
2404194 | 2404194 | 2022-04-13 | Mercer | Pennsylvania | 42085 | 23333 | 496 |
2400939 | 2400939 | 2022-04-12 | Mercer | Pennsylvania | 42085 | 23328 | 496 |
2397684 | 2397684 | 2022-04-11 | Mercer | Pennsylvania | 42085 | 23319 | 496 |
2394429 | 2394429 | 2022-04-10 | Mercer | Pennsylvania | 42085 | 23319 | 496 |
2391173 | 2391173 | 2022-04-09 | Mercer | Pennsylvania | 42085 | 23314 | 496 |
2387917 | 2387917 | 2022-04-08 | Mercer | Pennsylvania | 42085 | 23308 | 496 |
2384662 | 2384662 | 2022-04-07 | Mercer | Pennsylvania | 42085 | 23306 | 496 |
2381407 | 2381407 | 2022-04-06 | Mercer | Pennsylvania | 42085 | 23300 | 496 |
2378152 | 2378152 | 2022-04-05 | Mercer | Pennsylvania | 42085 | 23298 | 496 |
2374898 | 2374898 | 2022-04-04 | Mercer | Pennsylvania | 42085 | 23294 | 496 |
2371646 | 2371646 | 2022-04-03 | Mercer | Pennsylvania | 42085 | 23291 | 496 |
2368393 | 2368393 | 2022-04-02 | Mercer | Pennsylvania | 42085 | 23291 | 496 |
2365140 | 2365140 | 2022-04-01 | Mercer | Pennsylvania | 42085 | 23284 | 496 |
2361887 | 2361887 | 2022-03-31 | Mercer | Pennsylvania | 42085 | 23282 | 496 |
2358633 | 2358633 | 2022-03-30 | Mercer | Pennsylvania | 42085 | 23280 | 496 |
2355379 | 2355379 | 2022-03-29 | Mercer | Pennsylvania | 42085 | 23278 | 496 |
2352126 | 2352126 | 2022-03-28 | Mercer | Pennsylvania | 42085 | 23276 | 496 |
2348874 | 2348874 | 2022-03-27 | Mercer | Pennsylvania | 42085 | 23275 | 496 |
2345621 | 2345621 | 2022-03-26 | Mercer | Pennsylvania | 42085 | 23272 | 496 |
2342368 | 2342368 | 2022-03-25 | Mercer | Pennsylvania | 42085 | 23270 | 496 |
2339115 | 2339115 | 2022-03-24 | Mercer | Pennsylvania | 42085 | 23269 | 496 |
2335861 | 2335861 | 2022-03-23 | Mercer | Pennsylvania | 42085 | 23265 | 495 |
2332607 | 2332607 | 2022-03-22 | Mercer | Pennsylvania | 42085 | 23262 | 495 |
2329354 | 2329354 | 2022-03-21 | Mercer | Pennsylvania | 42085 | 23262 | 495 |
2326102 | 2326102 | 2022-03-20 | Mercer | Pennsylvania | 42085 | 23259 | 495 |
2322849 | 2322849 | 2022-03-19 | Mercer | Pennsylvania | 42085 | 23259 | 495 |
2319595 | 2319595 | 2022-03-18 | Mercer | Pennsylvania | 42085 | 23257 | 495 |
2316341 | 2316341 | 2022-03-17 | Mercer | Pennsylvania | 42085 | 23249 | 495 |
2313088 | 2313088 | 2022-03-16 | Mercer | Pennsylvania | 42085 | 23247 | 494 |
2309835 | 2309835 | 2022-03-15 | Mercer | Pennsylvania | 42085 | 23241 | 494 |
2306582 | 2306582 | 2022-03-14 | Mercer | Pennsylvania | 42085 | 23238 | 493 |
2303331 | 2303331 | 2022-03-13 | Mercer | Pennsylvania | 42085 | 23238 | 493 |
2300079 | 2300079 | 2022-03-12 | Mercer | Pennsylvania | 42085 | 23236 | 493 |
2296827 | 2296827 | 2022-03-11 | Mercer | Pennsylvania | 42085 | 23232 | 492 |
2293575 | 2293575 | 2022-03-10 | Mercer | Pennsylvania | 42085 | 23224 | 491 |
2290323 | 2290323 | 2022-03-09 | Mercer | Pennsylvania | 42085 | 23212 | 490 |
2287071 | 2287071 | 2022-03-08 | Mercer | Pennsylvania | 42085 | 23208 | 490 |
2283819 | 2283819 | 2022-03-07 | Mercer | Pennsylvania | 42085 | 23202 | 490 |
2280567 | 2280567 | 2022-03-06 | Mercer | Pennsylvania | 42085 | 23201 | 490 |
2277314 | 2277314 | 2022-03-05 | Mercer | Pennsylvania | 42085 | 23198 | 488 |
2274061 | 2274061 | 2022-03-04 | Mercer | Pennsylvania | 42085 | 23193 | 488 |
2270808 | 2270808 | 2022-03-03 | Mercer | Pennsylvania | 42085 | 23184 | 487 |
2267556 | 2267556 | 2022-03-02 | Mercer | Pennsylvania | 42085 | 23180 | 486 |
2264303 | 2264303 | 2022-03-01 | Mercer | Pennsylvania | 42085 | 23172 | 484 |
2261053 | 2261053 | 2022-02-28 | Mercer | Pennsylvania | 42085 | 23167 | 483 |
2257802 | 2257802 | 2022-02-27 | Mercer | Pennsylvania | 42085 | 23160 | 483 |
2254551 | 2254551 | 2022-02-26 | Mercer | Pennsylvania | 42085 | 23157 | 482 |
2251300 | 2251300 | 2022-02-25 | Mercer | Pennsylvania | 42085 | 23147 | 482 |
2248049 | 2248049 | 2022-02-24 | Mercer | Pennsylvania | 42085 | 23136 | 482 |
2244798 | 2244798 | 2022-02-23 | Mercer | Pennsylvania | 42085 | 23121 | 482 |
2241547 | 2241547 | 2022-02-22 | Mercer | Pennsylvania | 42085 | 23109 | 481 |
2238296 | 2238296 | 2022-02-21 | Mercer | Pennsylvania | 42085 | 23094 | 481 |
2235045 | 2235045 | 2022-02-20 | Mercer | Pennsylvania | 42085 | 23094 | 481 |
2231794 | 2231794 | 2022-02-19 | Mercer | Pennsylvania | 42085 | 23084 | 480 |
2228543 | 2228543 | 2022-02-18 | Mercer | Pennsylvania | 42085 | 23058 | 480 |
2225292 | 2225292 | 2022-02-17 | Mercer | Pennsylvania | 42085 | 23026 | 480 |
2222041 | 2222041 | 2022-02-16 | Mercer | Pennsylvania | 42085 | 22998 | 479 |
2218790 | 2218790 | 2022-02-15 | Mercer | Pennsylvania | 42085 | 22981 | 479 |
2215539 | 2215539 | 2022-02-14 | Mercer | Pennsylvania | 42085 | 22965 | 478 |
2212288 | 2212288 | 2022-02-13 | Mercer | Pennsylvania | 42085 | 22949 | 478 |
2209035 | 2209035 | 2022-02-12 | Mercer | Pennsylvania | 42085 | 22932 | 478 |
2205782 | 2205782 | 2022-02-11 | Mercer | Pennsylvania | 42085 | 22883 | 478 |
2202529 | 2202529 | 2022-02-10 | Mercer | Pennsylvania | 42085 | 22865 | 478 |
2199275 | 2199275 | 2022-02-09 | Mercer | Pennsylvania | 42085 | 22833 | 477 |
2196021 | 2196021 | 2022-02-08 | Mercer | Pennsylvania | 42085 | 22802 | 477 |
2192767 | 2192767 | 2022-02-07 | Mercer | Pennsylvania | 42085 | 22868 | 474 |
2189513 | 2189513 | 2022-02-06 | Mercer | Pennsylvania | 42085 | 22803 | 474 |
2186260 | 2186260 | 2022-02-05 | Mercer | Pennsylvania | 42085 | 22790 | 474 |
2183008 | 2183008 | 2022-02-04 | Mercer | Pennsylvania | 42085 | 22717 | 471 |
2179756 | 2179756 | 2022-02-03 | Mercer | Pennsylvania | 42085 | 22681 | 465 |
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);