ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 42031 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501862 | 2501862 | 2022-05-13 | Clarion | Pennsylvania | 42031 | 8323 | 202 |
2498604 | 2498604 | 2022-05-12 | Clarion | Pennsylvania | 42031 | 8323 | 202 |
2495346 | 2495346 | 2022-05-11 | Clarion | Pennsylvania | 42031 | 8323 | 202 |
2492088 | 2492088 | 2022-05-10 | Clarion | Pennsylvania | 42031 | 8274 | 202 |
2488830 | 2488830 | 2022-05-09 | Clarion | Pennsylvania | 42031 | 8274 | 202 |
2485573 | 2485573 | 2022-05-08 | Clarion | Pennsylvania | 42031 | 8274 | 202 |
2482315 | 2482315 | 2022-05-07 | Clarion | Pennsylvania | 42031 | 8274 | 202 |
2479057 | 2479057 | 2022-05-06 | Clarion | Pennsylvania | 42031 | 8274 | 202 |
2475799 | 2475799 | 2022-05-05 | Clarion | Pennsylvania | 42031 | 8274 | 202 |
2472542 | 2472542 | 2022-05-04 | Clarion | Pennsylvania | 42031 | 8274 | 202 |
2469286 | 2469286 | 2022-05-03 | Clarion | Pennsylvania | 42031 | 8271 | 202 |
2466030 | 2466030 | 2022-05-02 | Clarion | Pennsylvania | 42031 | 8263 | 202 |
2462775 | 2462775 | 2022-05-01 | Clarion | Pennsylvania | 42031 | 8261 | 202 |
2459519 | 2459519 | 2022-04-30 | Clarion | Pennsylvania | 42031 | 8260 | 202 |
2456263 | 2456263 | 2022-04-29 | Clarion | Pennsylvania | 42031 | 8258 | 202 |
2453007 | 2453007 | 2022-04-28 | Clarion | Pennsylvania | 42031 | 8253 | 202 |
2449751 | 2449751 | 2022-04-27 | Clarion | Pennsylvania | 42031 | 8252 | 202 |
2446494 | 2446494 | 2022-04-26 | Clarion | Pennsylvania | 42031 | 8247 | 202 |
2443239 | 2443239 | 2022-04-25 | Clarion | Pennsylvania | 42031 | 8247 | 202 |
2439983 | 2439983 | 2022-04-24 | Clarion | Pennsylvania | 42031 | 8247 | 202 |
2436727 | 2436727 | 2022-04-23 | Clarion | Pennsylvania | 42031 | 8247 | 202 |
2433471 | 2433471 | 2022-04-22 | Clarion | Pennsylvania | 42031 | 8242 | 202 |
2430215 | 2430215 | 2022-04-21 | Clarion | Pennsylvania | 42031 | 8242 | 202 |
2426959 | 2426959 | 2022-04-20 | Clarion | Pennsylvania | 42031 | 8242 | 202 |
2423703 | 2423703 | 2022-04-19 | Clarion | Pennsylvania | 42031 | 8241 | 202 |
2420447 | 2420447 | 2022-04-18 | Clarion | Pennsylvania | 42031 | 8236 | 202 |
2417191 | 2417191 | 2022-04-17 | Clarion | Pennsylvania | 42031 | 8236 | 202 |
2413935 | 2413935 | 2022-04-16 | Clarion | Pennsylvania | 42031 | 8235 | 202 |
2410679 | 2410679 | 2022-04-15 | Clarion | Pennsylvania | 42031 | 8232 | 202 |
2407423 | 2407423 | 2022-04-14 | Clarion | Pennsylvania | 42031 | 8232 | 202 |
2404167 | 2404167 | 2022-04-13 | Clarion | Pennsylvania | 42031 | 8232 | 202 |
2400912 | 2400912 | 2022-04-12 | Clarion | Pennsylvania | 42031 | 8232 | 202 |
2397657 | 2397657 | 2022-04-11 | Clarion | Pennsylvania | 42031 | 8230 | 203 |
2394402 | 2394402 | 2022-04-10 | Clarion | Pennsylvania | 42031 | 8229 | 203 |
2391146 | 2391146 | 2022-04-09 | Clarion | Pennsylvania | 42031 | 8229 | 203 |
2387890 | 2387890 | 2022-04-08 | Clarion | Pennsylvania | 42031 | 8229 | 203 |
2384635 | 2384635 | 2022-04-07 | Clarion | Pennsylvania | 42031 | 8227 | 203 |
2381380 | 2381380 | 2022-04-06 | Clarion | Pennsylvania | 42031 | 8226 | 203 |
2378125 | 2378125 | 2022-04-05 | Clarion | Pennsylvania | 42031 | 8224 | 203 |
2374871 | 2374871 | 2022-04-04 | Clarion | Pennsylvania | 42031 | 8223 | 203 |
2371619 | 2371619 | 2022-04-03 | Clarion | Pennsylvania | 42031 | 8222 | 203 |
2368366 | 2368366 | 2022-04-02 | Clarion | Pennsylvania | 42031 | 8222 | 203 |
2365113 | 2365113 | 2022-04-01 | Clarion | Pennsylvania | 42031 | 8220 | 203 |
2361860 | 2361860 | 2022-03-31 | Clarion | Pennsylvania | 42031 | 8220 | 203 |
2358606 | 2358606 | 2022-03-30 | Clarion | Pennsylvania | 42031 | 8219 | 203 |
2355352 | 2355352 | 2022-03-29 | Clarion | Pennsylvania | 42031 | 8216 | 203 |
2352099 | 2352099 | 2022-03-28 | Clarion | Pennsylvania | 42031 | 8216 | 203 |
2348847 | 2348847 | 2022-03-27 | Clarion | Pennsylvania | 42031 | 8216 | 203 |
2345594 | 2345594 | 2022-03-26 | Clarion | Pennsylvania | 42031 | 8214 | 203 |
2342341 | 2342341 | 2022-03-25 | Clarion | Pennsylvania | 42031 | 8213 | 203 |
2339088 | 2339088 | 2022-03-24 | Clarion | Pennsylvania | 42031 | 8212 | 202 |
2335834 | 2335834 | 2022-03-23 | Clarion | Pennsylvania | 42031 | 8208 | 201 |
2332580 | 2332580 | 2022-03-22 | Clarion | Pennsylvania | 42031 | 8206 | 201 |
2329327 | 2329327 | 2022-03-21 | Clarion | Pennsylvania | 42031 | 8207 | 201 |
2326075 | 2326075 | 2022-03-20 | Clarion | Pennsylvania | 42031 | 8207 | 201 |
2322822 | 2322822 | 2022-03-19 | Clarion | Pennsylvania | 42031 | 8206 | 201 |
2319568 | 2319568 | 2022-03-18 | Clarion | Pennsylvania | 42031 | 8201 | 201 |
2316314 | 2316314 | 2022-03-17 | Clarion | Pennsylvania | 42031 | 8199 | 201 |
2313061 | 2313061 | 2022-03-16 | Clarion | Pennsylvania | 42031 | 8198 | 201 |
2309808 | 2309808 | 2022-03-15 | Clarion | Pennsylvania | 42031 | 8198 | 200 |
2306555 | 2306555 | 2022-03-14 | Clarion | Pennsylvania | 42031 | 8198 | 199 |
2303304 | 2303304 | 2022-03-13 | Clarion | Pennsylvania | 42031 | 8196 | 199 |
2300052 | 2300052 | 2022-03-12 | Clarion | Pennsylvania | 42031 | 8192 | 199 |
2296800 | 2296800 | 2022-03-11 | Clarion | Pennsylvania | 42031 | 8189 | 199 |
2293548 | 2293548 | 2022-03-10 | Clarion | Pennsylvania | 42031 | 8185 | 199 |
2290296 | 2290296 | 2022-03-09 | Clarion | Pennsylvania | 42031 | 8182 | 199 |
2287044 | 2287044 | 2022-03-08 | Clarion | Pennsylvania | 42031 | 8177 | 199 |
2283792 | 2283792 | 2022-03-07 | Clarion | Pennsylvania | 42031 | 8175 | 198 |
2280540 | 2280540 | 2022-03-06 | Clarion | Pennsylvania | 42031 | 8175 | 198 |
2277287 | 2277287 | 2022-03-05 | Clarion | Pennsylvania | 42031 | 8175 | 198 |
2274034 | 2274034 | 2022-03-04 | Clarion | Pennsylvania | 42031 | 8172 | 198 |
2270781 | 2270781 | 2022-03-03 | Clarion | Pennsylvania | 42031 | 8169 | 197 |
2267529 | 2267529 | 2022-03-02 | Clarion | Pennsylvania | 42031 | 8167 | 197 |
2264276 | 2264276 | 2022-03-01 | Clarion | Pennsylvania | 42031 | 8161 | 197 |
2261026 | 2261026 | 2022-02-28 | Clarion | Pennsylvania | 42031 | 8156 | 197 |
2257775 | 2257775 | 2022-02-27 | Clarion | Pennsylvania | 42031 | 8156 | 197 |
2254524 | 2254524 | 2022-02-26 | Clarion | Pennsylvania | 42031 | 8152 | 197 |
2251273 | 2251273 | 2022-02-25 | Clarion | Pennsylvania | 42031 | 8146 | 197 |
2248022 | 2248022 | 2022-02-24 | Clarion | Pennsylvania | 42031 | 8137 | 197 |
2244771 | 2244771 | 2022-02-23 | Clarion | Pennsylvania | 42031 | 8134 | 197 |
2241520 | 2241520 | 2022-02-22 | Clarion | Pennsylvania | 42031 | 8127 | 194 |
2238269 | 2238269 | 2022-02-21 | Clarion | Pennsylvania | 42031 | 8122 | 194 |
2235018 | 2235018 | 2022-02-20 | Clarion | Pennsylvania | 42031 | 8122 | 194 |
2231767 | 2231767 | 2022-02-19 | Clarion | Pennsylvania | 42031 | 8117 | 193 |
2228516 | 2228516 | 2022-02-18 | Clarion | Pennsylvania | 42031 | 8119 | 193 |
2225265 | 2225265 | 2022-02-17 | Clarion | Pennsylvania | 42031 | 8086 | 193 |
2222014 | 2222014 | 2022-02-16 | Clarion | Pennsylvania | 42031 | 8061 | 193 |
2218763 | 2218763 | 2022-02-15 | Clarion | Pennsylvania | 42031 | 8055 | 193 |
2215512 | 2215512 | 2022-02-14 | Clarion | Pennsylvania | 42031 | 8054 | 193 |
2212261 | 2212261 | 2022-02-13 | Clarion | Pennsylvania | 42031 | 8050 | 193 |
2209008 | 2209008 | 2022-02-12 | Clarion | Pennsylvania | 42031 | 8043 | 193 |
2205755 | 2205755 | 2022-02-11 | Clarion | Pennsylvania | 42031 | 8026 | 193 |
2202502 | 2202502 | 2022-02-10 | Clarion | Pennsylvania | 42031 | 8024 | 193 |
2199248 | 2199248 | 2022-02-09 | Clarion | Pennsylvania | 42031 | 8011 | 193 |
2195994 | 2195994 | 2022-02-08 | Clarion | Pennsylvania | 42031 | 7995 | 193 |
2192740 | 2192740 | 2022-02-07 | Clarion | Pennsylvania | 42031 | 8014 | 190 |
2189486 | 2189486 | 2022-02-06 | Clarion | Pennsylvania | 42031 | 7994 | 190 |
2186233 | 2186233 | 2022-02-05 | Clarion | Pennsylvania | 42031 | 7983 | 190 |
2182981 | 2182981 | 2022-02-04 | Clarion | Pennsylvania | 42031 | 7958 | 190 |
2179729 | 2179729 | 2022-02-03 | Clarion | Pennsylvania | 42031 | 7947 | 190 |
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);