ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where county = "Clinton" 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 |
---|---|---|---|---|---|---|---|
2501864 | 2501864 | 2022-05-13 | Clinton | Pennsylvania | 42035 | 9157 | 127 |
2498606 | 2498606 | 2022-05-12 | Clinton | Pennsylvania | 42035 | 9157 | 127 |
2495348 | 2495348 | 2022-05-11 | Clinton | Pennsylvania | 42035 | 9157 | 127 |
2492090 | 2492090 | 2022-05-10 | Clinton | Pennsylvania | 42035 | 9096 | 127 |
2488832 | 2488832 | 2022-05-09 | Clinton | Pennsylvania | 42035 | 9096 | 127 |
2485575 | 2485575 | 2022-05-08 | Clinton | Pennsylvania | 42035 | 9096 | 127 |
2482317 | 2482317 | 2022-05-07 | Clinton | Pennsylvania | 42035 | 9096 | 127 |
2479059 | 2479059 | 2022-05-06 | Clinton | Pennsylvania | 42035 | 9096 | 127 |
2475801 | 2475801 | 2022-05-05 | Clinton | Pennsylvania | 42035 | 9096 | 127 |
2472544 | 2472544 | 2022-05-04 | Clinton | Pennsylvania | 42035 | 9096 | 127 |
2469288 | 2469288 | 2022-05-03 | Clinton | Pennsylvania | 42035 | 9089 | 126 |
2466032 | 2466032 | 2022-05-02 | Clinton | Pennsylvania | 42035 | 9085 | 126 |
2462777 | 2462777 | 2022-05-01 | Clinton | Pennsylvania | 42035 | 9085 | 126 |
2459521 | 2459521 | 2022-04-30 | Clinton | Pennsylvania | 42035 | 9085 | 126 |
2456265 | 2456265 | 2022-04-29 | Clinton | Pennsylvania | 42035 | 9081 | 126 |
2453009 | 2453009 | 2022-04-28 | Clinton | Pennsylvania | 42035 | 9077 | 126 |
2449753 | 2449753 | 2022-04-27 | Clinton | Pennsylvania | 42035 | 9077 | 126 |
2446496 | 2446496 | 2022-04-26 | Clinton | Pennsylvania | 42035 | 9071 | 126 |
2443241 | 2443241 | 2022-04-25 | Clinton | Pennsylvania | 42035 | 9069 | 126 |
2439985 | 2439985 | 2022-04-24 | Clinton | Pennsylvania | 42035 | 9069 | 126 |
2436729 | 2436729 | 2022-04-23 | Clinton | Pennsylvania | 42035 | 9066 | 126 |
2433473 | 2433473 | 2022-04-22 | Clinton | Pennsylvania | 42035 | 9062 | 126 |
2430217 | 2430217 | 2022-04-21 | Clinton | Pennsylvania | 42035 | 9060 | 126 |
2426961 | 2426961 | 2022-04-20 | Clinton | Pennsylvania | 42035 | 9058 | 124 |
2423705 | 2423705 | 2022-04-19 | Clinton | Pennsylvania | 42035 | 9052 | 124 |
2420449 | 2420449 | 2022-04-18 | Clinton | Pennsylvania | 42035 | 9051 | 124 |
2417193 | 2417193 | 2022-04-17 | Clinton | Pennsylvania | 42035 | 9049 | 124 |
2413937 | 2413937 | 2022-04-16 | Clinton | Pennsylvania | 42035 | 9047 | 124 |
2410681 | 2410681 | 2022-04-15 | Clinton | Pennsylvania | 42035 | 9045 | 124 |
2407425 | 2407425 | 2022-04-14 | Clinton | Pennsylvania | 42035 | 9040 | 124 |
2404169 | 2404169 | 2022-04-13 | Clinton | Pennsylvania | 42035 | 9039 | 124 |
2400914 | 2400914 | 2022-04-12 | Clinton | Pennsylvania | 42035 | 9036 | 124 |
2397659 | 2397659 | 2022-04-11 | Clinton | Pennsylvania | 42035 | 9034 | 124 |
2394404 | 2394404 | 2022-04-10 | Clinton | Pennsylvania | 42035 | 9034 | 124 |
2391148 | 2391148 | 2022-04-09 | Clinton | Pennsylvania | 42035 | 9034 | 124 |
2387892 | 2387892 | 2022-04-08 | Clinton | Pennsylvania | 42035 | 9034 | 124 |
2384637 | 2384637 | 2022-04-07 | Clinton | Pennsylvania | 42035 | 9034 | 124 |
2381382 | 2381382 | 2022-04-06 | Clinton | Pennsylvania | 42035 | 9032 | 124 |
2378127 | 2378127 | 2022-04-05 | Clinton | Pennsylvania | 42035 | 9030 | 124 |
2374873 | 2374873 | 2022-04-04 | Clinton | Pennsylvania | 42035 | 9029 | 124 |
2371621 | 2371621 | 2022-04-03 | Clinton | Pennsylvania | 42035 | 9029 | 124 |
2368368 | 2368368 | 2022-04-02 | Clinton | Pennsylvania | 42035 | 9029 | 124 |
2365115 | 2365115 | 2022-04-01 | Clinton | Pennsylvania | 42035 | 9028 | 124 |
2361862 | 2361862 | 2022-03-31 | Clinton | Pennsylvania | 42035 | 9028 | 124 |
2358608 | 2358608 | 2022-03-30 | Clinton | Pennsylvania | 42035 | 9028 | 124 |
2355354 | 2355354 | 2022-03-29 | Clinton | Pennsylvania | 42035 | 9027 | 124 |
2352101 | 2352101 | 2022-03-28 | Clinton | Pennsylvania | 42035 | 9026 | 124 |
2348849 | 2348849 | 2022-03-27 | Clinton | Pennsylvania | 42035 | 9026 | 124 |
2345596 | 2345596 | 2022-03-26 | Clinton | Pennsylvania | 42035 | 9025 | 124 |
2342343 | 2342343 | 2022-03-25 | Clinton | Pennsylvania | 42035 | 9023 | 124 |
2339090 | 2339090 | 2022-03-24 | Clinton | Pennsylvania | 42035 | 9021 | 124 |
2335836 | 2335836 | 2022-03-23 | Clinton | Pennsylvania | 42035 | 9020 | 124 |
2332582 | 2332582 | 2022-03-22 | Clinton | Pennsylvania | 42035 | 9017 | 124 |
2329329 | 2329329 | 2022-03-21 | Clinton | Pennsylvania | 42035 | 9016 | 124 |
2326077 | 2326077 | 2022-03-20 | Clinton | Pennsylvania | 42035 | 9016 | 124 |
2322824 | 2322824 | 2022-03-19 | Clinton | Pennsylvania | 42035 | 9016 | 124 |
2319570 | 2319570 | 2022-03-18 | Clinton | Pennsylvania | 42035 | 9014 | 124 |
2316316 | 2316316 | 2022-03-17 | Clinton | Pennsylvania | 42035 | 9010 | 124 |
2313063 | 2313063 | 2022-03-16 | Clinton | Pennsylvania | 42035 | 9010 | 124 |
2309810 | 2309810 | 2022-03-15 | Clinton | Pennsylvania | 42035 | 9007 | 124 |
2306557 | 2306557 | 2022-03-14 | Clinton | Pennsylvania | 42035 | 9002 | 124 |
2303306 | 2303306 | 2022-03-13 | Clinton | Pennsylvania | 42035 | 9001 | 124 |
2300054 | 2300054 | 2022-03-12 | Clinton | Pennsylvania | 42035 | 9001 | 124 |
2296802 | 2296802 | 2022-03-11 | Clinton | Pennsylvania | 42035 | 8998 | 124 |
2293550 | 2293550 | 2022-03-10 | Clinton | Pennsylvania | 42035 | 8996 | 124 |
2290298 | 2290298 | 2022-03-09 | Clinton | Pennsylvania | 42035 | 8995 | 124 |
2287046 | 2287046 | 2022-03-08 | Clinton | Pennsylvania | 42035 | 8993 | 124 |
2283794 | 2283794 | 2022-03-07 | Clinton | Pennsylvania | 42035 | 8992 | 124 |
2280542 | 2280542 | 2022-03-06 | Clinton | Pennsylvania | 42035 | 8990 | 124 |
2277289 | 2277289 | 2022-03-05 | Clinton | Pennsylvania | 42035 | 8989 | 124 |
2274036 | 2274036 | 2022-03-04 | Clinton | Pennsylvania | 42035 | 8987 | 124 |
2270783 | 2270783 | 2022-03-03 | Clinton | Pennsylvania | 42035 | 8981 | 124 |
2267531 | 2267531 | 2022-03-02 | Clinton | Pennsylvania | 42035 | 8978 | 124 |
2264278 | 2264278 | 2022-03-01 | Clinton | Pennsylvania | 42035 | 8975 | 124 |
2261028 | 2261028 | 2022-02-28 | Clinton | Pennsylvania | 42035 | 8971 | 123 |
2257777 | 2257777 | 2022-02-27 | Clinton | Pennsylvania | 42035 | 8967 | 123 |
2254526 | 2254526 | 2022-02-26 | Clinton | Pennsylvania | 42035 | 8965 | 123 |
2251275 | 2251275 | 2022-02-25 | Clinton | Pennsylvania | 42035 | 8956 | 123 |
2248024 | 2248024 | 2022-02-24 | Clinton | Pennsylvania | 42035 | 8948 | 123 |
2244773 | 2244773 | 2022-02-23 | Clinton | Pennsylvania | 42035 | 8943 | 123 |
2241522 | 2241522 | 2022-02-22 | Clinton | Pennsylvania | 42035 | 8931 | 123 |
2238271 | 2238271 | 2022-02-21 | Clinton | Pennsylvania | 42035 | 8915 | 123 |
2235020 | 2235020 | 2022-02-20 | Clinton | Pennsylvania | 42035 | 8915 | 123 |
2231769 | 2231769 | 2022-02-19 | Clinton | Pennsylvania | 42035 | 8911 | 123 |
2228518 | 2228518 | 2022-02-18 | Clinton | Pennsylvania | 42035 | 8899 | 123 |
2225267 | 2225267 | 2022-02-17 | Clinton | Pennsylvania | 42035 | 8888 | 122 |
2222016 | 2222016 | 2022-02-16 | Clinton | Pennsylvania | 42035 | 8875 | 121 |
2218765 | 2218765 | 2022-02-15 | Clinton | Pennsylvania | 42035 | 8844 | 121 |
2215514 | 2215514 | 2022-02-14 | Clinton | Pennsylvania | 42035 | 8826 | 120 |
2212263 | 2212263 | 2022-02-13 | Clinton | Pennsylvania | 42035 | 8819 | 120 |
2209010 | 2209010 | 2022-02-12 | Clinton | Pennsylvania | 42035 | 8810 | 120 |
2205757 | 2205757 | 2022-02-11 | Clinton | Pennsylvania | 42035 | 8784 | 120 |
2202504 | 2202504 | 2022-02-10 | Clinton | Pennsylvania | 42035 | 8766 | 120 |
2199250 | 2199250 | 2022-02-09 | Clinton | Pennsylvania | 42035 | 8753 | 120 |
2195996 | 2195996 | 2022-02-08 | Clinton | Pennsylvania | 42035 | 8715 | 119 |
2192742 | 2192742 | 2022-02-07 | Clinton | Pennsylvania | 42035 | 8704 | 117 |
2189488 | 2189488 | 2022-02-06 | Clinton | Pennsylvania | 42035 | 8692 | 117 |
2186235 | 2186235 | 2022-02-05 | Clinton | Pennsylvania | 42035 | 8677 | 117 |
2182983 | 2182983 | 2022-02-04 | Clinton | Pennsylvania | 42035 | 8647 | 117 |
2179731 | 2179731 | 2022-02-03 | Clinton | Pennsylvania | 42035 | 8615 | 117 |
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);