ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Perry" and fips = 42099 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 |
---|---|---|---|---|---|---|---|
2501896 | 2501896 | 2022-05-13 | Perry | Pennsylvania | 42099 | 8873 | 185 |
2498638 | 2498638 | 2022-05-12 | Perry | Pennsylvania | 42099 | 8873 | 185 |
2495380 | 2495380 | 2022-05-11 | Perry | Pennsylvania | 42099 | 8873 | 185 |
2492122 | 2492122 | 2022-05-10 | Perry | Pennsylvania | 42099 | 8857 | 184 |
2488864 | 2488864 | 2022-05-09 | Perry | Pennsylvania | 42099 | 8857 | 184 |
2485607 | 2485607 | 2022-05-08 | Perry | Pennsylvania | 42099 | 8857 | 184 |
2482349 | 2482349 | 2022-05-07 | Perry | Pennsylvania | 42099 | 8857 | 184 |
2479091 | 2479091 | 2022-05-06 | Perry | Pennsylvania | 42099 | 8857 | 184 |
2475833 | 2475833 | 2022-05-05 | Perry | Pennsylvania | 42099 | 8857 | 184 |
2472576 | 2472576 | 2022-05-04 | Perry | Pennsylvania | 42099 | 8857 | 184 |
2469320 | 2469320 | 2022-05-03 | Perry | Pennsylvania | 42099 | 8855 | 184 |
2466064 | 2466064 | 2022-05-02 | Perry | Pennsylvania | 42099 | 8854 | 184 |
2462809 | 2462809 | 2022-05-01 | Perry | Pennsylvania | 42099 | 8853 | 184 |
2459553 | 2459553 | 2022-04-30 | Perry | Pennsylvania | 42099 | 8853 | 184 |
2456297 | 2456297 | 2022-04-29 | Perry | Pennsylvania | 42099 | 8852 | 184 |
2453041 | 2453041 | 2022-04-28 | Perry | Pennsylvania | 42099 | 8850 | 184 |
2449785 | 2449785 | 2022-04-27 | Perry | Pennsylvania | 42099 | 8847 | 184 |
2446528 | 2446528 | 2022-04-26 | Perry | Pennsylvania | 42099 | 8844 | 184 |
2443273 | 2443273 | 2022-04-25 | Perry | Pennsylvania | 42099 | 8844 | 184 |
2440017 | 2440017 | 2022-04-24 | Perry | Pennsylvania | 42099 | 8844 | 184 |
2436761 | 2436761 | 2022-04-23 | Perry | Pennsylvania | 42099 | 8842 | 184 |
2433505 | 2433505 | 2022-04-22 | Perry | Pennsylvania | 42099 | 8841 | 184 |
2430249 | 2430249 | 2022-04-21 | Perry | Pennsylvania | 42099 | 8839 | 184 |
2426993 | 2426993 | 2022-04-20 | Perry | Pennsylvania | 42099 | 8836 | 184 |
2423737 | 2423737 | 2022-04-19 | Perry | Pennsylvania | 42099 | 8836 | 184 |
2420481 | 2420481 | 2022-04-18 | Perry | Pennsylvania | 42099 | 8836 | 184 |
2417225 | 2417225 | 2022-04-17 | Perry | Pennsylvania | 42099 | 8835 | 184 |
2413969 | 2413969 | 2022-04-16 | Perry | Pennsylvania | 42099 | 8835 | 184 |
2410713 | 2410713 | 2022-04-15 | Perry | Pennsylvania | 42099 | 8835 | 184 |
2407457 | 2407457 | 2022-04-14 | Perry | Pennsylvania | 42099 | 8833 | 184 |
2404201 | 2404201 | 2022-04-13 | Perry | Pennsylvania | 42099 | 8831 | 184 |
2400946 | 2400946 | 2022-04-12 | Perry | Pennsylvania | 42099 | 8829 | 184 |
2397691 | 2397691 | 2022-04-11 | Perry | Pennsylvania | 42099 | 8828 | 184 |
2394436 | 2394436 | 2022-04-10 | Perry | Pennsylvania | 42099 | 8828 | 184 |
2391180 | 2391180 | 2022-04-09 | Perry | Pennsylvania | 42099 | 8827 | 184 |
2387924 | 2387924 | 2022-04-08 | Perry | Pennsylvania | 42099 | 8827 | 184 |
2384669 | 2384669 | 2022-04-07 | Perry | Pennsylvania | 42099 | 8825 | 184 |
2381414 | 2381414 | 2022-04-06 | Perry | Pennsylvania | 42099 | 8824 | 183 |
2378159 | 2378159 | 2022-04-05 | Perry | Pennsylvania | 42099 | 8823 | 183 |
2374905 | 2374905 | 2022-04-04 | Perry | Pennsylvania | 42099 | 8821 | 183 |
2371653 | 2371653 | 2022-04-03 | Perry | Pennsylvania | 42099 | 8818 | 183 |
2368400 | 2368400 | 2022-04-02 | Perry | Pennsylvania | 42099 | 8818 | 183 |
2365147 | 2365147 | 2022-04-01 | Perry | Pennsylvania | 42099 | 8818 | 183 |
2361894 | 2361894 | 2022-03-31 | Perry | Pennsylvania | 42099 | 8817 | 183 |
2358640 | 2358640 | 2022-03-30 | Perry | Pennsylvania | 42099 | 8817 | 183 |
2355386 | 2355386 | 2022-03-29 | Perry | Pennsylvania | 42099 | 8816 | 183 |
2352133 | 2352133 | 2022-03-28 | Perry | Pennsylvania | 42099 | 8815 | 183 |
2348881 | 2348881 | 2022-03-27 | Perry | Pennsylvania | 42099 | 8814 | 183 |
2345628 | 2345628 | 2022-03-26 | Perry | Pennsylvania | 42099 | 8814 | 183 |
2342375 | 2342375 | 2022-03-25 | Perry | Pennsylvania | 42099 | 8814 | 183 |
2339122 | 2339122 | 2022-03-24 | Perry | Pennsylvania | 42099 | 8812 | 183 |
2335868 | 2335868 | 2022-03-23 | Perry | Pennsylvania | 42099 | 8811 | 183 |
2332614 | 2332614 | 2022-03-22 | Perry | Pennsylvania | 42099 | 8811 | 183 |
2329361 | 2329361 | 2022-03-21 | Perry | Pennsylvania | 42099 | 8811 | 182 |
2326109 | 2326109 | 2022-03-20 | Perry | Pennsylvania | 42099 | 8811 | 182 |
2322856 | 2322856 | 2022-03-19 | Perry | Pennsylvania | 42099 | 8811 | 182 |
2319602 | 2319602 | 2022-03-18 | Perry | Pennsylvania | 42099 | 8809 | 182 |
2316348 | 2316348 | 2022-03-17 | Perry | Pennsylvania | 42099 | 8806 | 182 |
2313095 | 2313095 | 2022-03-16 | Perry | Pennsylvania | 42099 | 8806 | 182 |
2309842 | 2309842 | 2022-03-15 | Perry | Pennsylvania | 42099 | 8805 | 181 |
2306589 | 2306589 | 2022-03-14 | Perry | Pennsylvania | 42099 | 8804 | 181 |
2303338 | 2303338 | 2022-03-13 | Perry | Pennsylvania | 42099 | 8803 | 181 |
2300086 | 2300086 | 2022-03-12 | Perry | Pennsylvania | 42099 | 8803 | 181 |
2296834 | 2296834 | 2022-03-11 | Perry | Pennsylvania | 42099 | 8798 | 181 |
2293582 | 2293582 | 2022-03-10 | Perry | Pennsylvania | 42099 | 8797 | 180 |
2290330 | 2290330 | 2022-03-09 | Perry | Pennsylvania | 42099 | 8795 | 180 |
2287078 | 2287078 | 2022-03-08 | Perry | Pennsylvania | 42099 | 8791 | 180 |
2283826 | 2283826 | 2022-03-07 | Perry | Pennsylvania | 42099 | 8787 | 180 |
2280574 | 2280574 | 2022-03-06 | Perry | Pennsylvania | 42099 | 8783 | 180 |
2277321 | 2277321 | 2022-03-05 | Perry | Pennsylvania | 42099 | 8781 | 180 |
2274068 | 2274068 | 2022-03-04 | Perry | Pennsylvania | 42099 | 8775 | 180 |
2270815 | 2270815 | 2022-03-03 | Perry | Pennsylvania | 42099 | 8773 | 180 |
2267563 | 2267563 | 2022-03-02 | Perry | Pennsylvania | 42099 | 8770 | 180 |
2264310 | 2264310 | 2022-03-01 | Perry | Pennsylvania | 42099 | 8766 | 180 |
2261060 | 2261060 | 2022-02-28 | Perry | Pennsylvania | 42099 | 8766 | 179 |
2257809 | 2257809 | 2022-02-27 | Perry | Pennsylvania | 42099 | 8767 | 179 |
2254558 | 2254558 | 2022-02-26 | Perry | Pennsylvania | 42099 | 8766 | 179 |
2251307 | 2251307 | 2022-02-25 | Perry | Pennsylvania | 42099 | 8760 | 178 |
2248056 | 2248056 | 2022-02-24 | Perry | Pennsylvania | 42099 | 8756 | 178 |
2244805 | 2244805 | 2022-02-23 | Perry | Pennsylvania | 42099 | 8748 | 178 |
2241554 | 2241554 | 2022-02-22 | Perry | Pennsylvania | 42099 | 8744 | 178 |
2238303 | 2238303 | 2022-02-21 | Perry | Pennsylvania | 42099 | 8735 | 178 |
2235052 | 2235052 | 2022-02-20 | Perry | Pennsylvania | 42099 | 8735 | 178 |
2231801 | 2231801 | 2022-02-19 | Perry | Pennsylvania | 42099 | 8733 | 177 |
2228550 | 2228550 | 2022-02-18 | Perry | Pennsylvania | 42099 | 8713 | 177 |
2225299 | 2225299 | 2022-02-17 | Perry | Pennsylvania | 42099 | 8708 | 177 |
2222048 | 2222048 | 2022-02-16 | Perry | Pennsylvania | 42099 | 8694 | 176 |
2218797 | 2218797 | 2022-02-15 | Perry | Pennsylvania | 42099 | 8686 | 176 |
2215546 | 2215546 | 2022-02-14 | Perry | Pennsylvania | 42099 | 8672 | 175 |
2212295 | 2212295 | 2022-02-13 | Perry | Pennsylvania | 42099 | 8664 | 174 |
2209042 | 2209042 | 2022-02-12 | Perry | Pennsylvania | 42099 | 8652 | 174 |
2205789 | 2205789 | 2022-02-11 | Perry | Pennsylvania | 42099 | 8637 | 174 |
2202536 | 2202536 | 2022-02-10 | Perry | Pennsylvania | 42099 | 8617 | 174 |
2199282 | 2199282 | 2022-02-09 | Perry | Pennsylvania | 42099 | 8605 | 174 |
2196028 | 2196028 | 2022-02-08 | Perry | Pennsylvania | 42099 | 8596 | 175 |
2192774 | 2192774 | 2022-02-07 | Perry | Pennsylvania | 42099 | 8601 | 174 |
2189520 | 2189520 | 2022-02-06 | Perry | Pennsylvania | 42099 | 8579 | 174 |
2186267 | 2186267 | 2022-02-05 | Perry | Pennsylvania | 42099 | 8566 | 174 |
2183015 | 2183015 | 2022-02-04 | Perry | Pennsylvania | 42099 | 8525 | 174 |
2179763 | 2179763 | 2022-02-03 | Perry | Pennsylvania | 42099 | 8491 | 172 |
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);