ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Venango" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501907 | 2501907 | 2022-05-13 | Venango | Pennsylvania | 42121 | 11406 | 241 |
2498649 | 2498649 | 2022-05-12 | Venango | Pennsylvania | 42121 | 11406 | 241 |
2495391 | 2495391 | 2022-05-11 | Venango | Pennsylvania | 42121 | 11406 | 241 |
2492133 | 2492133 | 2022-05-10 | Venango | Pennsylvania | 42121 | 11327 | 240 |
2488875 | 2488875 | 2022-05-09 | Venango | Pennsylvania | 42121 | 11327 | 240 |
2485618 | 2485618 | 2022-05-08 | Venango | Pennsylvania | 42121 | 11327 | 240 |
2482360 | 2482360 | 2022-05-07 | Venango | Pennsylvania | 42121 | 11327 | 240 |
2479102 | 2479102 | 2022-05-06 | Venango | Pennsylvania | 42121 | 11327 | 240 |
2475844 | 2475844 | 2022-05-05 | Venango | Pennsylvania | 42121 | 11327 | 240 |
2472587 | 2472587 | 2022-05-04 | Venango | Pennsylvania | 42121 | 11327 | 240 |
2469331 | 2469331 | 2022-05-03 | Venango | Pennsylvania | 42121 | 11323 | 240 |
2466075 | 2466075 | 2022-05-02 | Venango | Pennsylvania | 42121 | 11308 | 238 |
2462820 | 2462820 | 2022-05-01 | Venango | Pennsylvania | 42121 | 11303 | 238 |
2459564 | 2459564 | 2022-04-30 | Venango | Pennsylvania | 42121 | 11300 | 238 |
2456308 | 2456308 | 2022-04-29 | Venango | Pennsylvania | 42121 | 11297 | 238 |
2453052 | 2453052 | 2022-04-28 | Venango | Pennsylvania | 42121 | 11292 | 238 |
2449796 | 2449796 | 2022-04-27 | Venango | Pennsylvania | 42121 | 11285 | 238 |
2446539 | 2446539 | 2022-04-26 | Venango | Pennsylvania | 42121 | 11277 | 238 |
2443284 | 2443284 | 2022-04-25 | Venango | Pennsylvania | 42121 | 11274 | 238 |
2440028 | 2440028 | 2022-04-24 | Venango | Pennsylvania | 42121 | 11273 | 238 |
2436772 | 2436772 | 2022-04-23 | Venango | Pennsylvania | 42121 | 11273 | 238 |
2433516 | 2433516 | 2022-04-22 | Venango | Pennsylvania | 42121 | 11269 | 238 |
2430260 | 2430260 | 2022-04-21 | Venango | Pennsylvania | 42121 | 11268 | 238 |
2427004 | 2427004 | 2022-04-20 | Venango | Pennsylvania | 42121 | 11262 | 238 |
2423748 | 2423748 | 2022-04-19 | Venango | Pennsylvania | 42121 | 11262 | 238 |
2420492 | 2420492 | 2022-04-18 | Venango | Pennsylvania | 42121 | 11257 | 238 |
2417236 | 2417236 | 2022-04-17 | Venango | Pennsylvania | 42121 | 11256 | 238 |
2413980 | 2413980 | 2022-04-16 | Venango | Pennsylvania | 42121 | 11255 | 238 |
2410724 | 2410724 | 2022-04-15 | Venango | Pennsylvania | 42121 | 11253 | 238 |
2407468 | 2407468 | 2022-04-14 | Venango | Pennsylvania | 42121 | 11250 | 238 |
2404212 | 2404212 | 2022-04-13 | Venango | Pennsylvania | 42121 | 11249 | 238 |
2400957 | 2400957 | 2022-04-12 | Venango | Pennsylvania | 42121 | 11243 | 238 |
2397702 | 2397702 | 2022-04-11 | Venango | Pennsylvania | 42121 | 11243 | 237 |
2394447 | 2394447 | 2022-04-10 | Venango | Pennsylvania | 42121 | 11243 | 237 |
2391191 | 2391191 | 2022-04-09 | Venango | Pennsylvania | 42121 | 11243 | 237 |
2387935 | 2387935 | 2022-04-08 | Venango | Pennsylvania | 42121 | 11242 | 237 |
2384680 | 2384680 | 2022-04-07 | Venango | Pennsylvania | 42121 | 11240 | 237 |
2381425 | 2381425 | 2022-04-06 | Venango | Pennsylvania | 42121 | 11237 | 237 |
2378170 | 2378170 | 2022-04-05 | Venango | Pennsylvania | 42121 | 11235 | 237 |
2374916 | 2374916 | 2022-04-04 | Venango | Pennsylvania | 42121 | 11235 | 237 |
2371664 | 2371664 | 2022-04-03 | Venango | Pennsylvania | 42121 | 11234 | 237 |
2368411 | 2368411 | 2022-04-02 | Venango | Pennsylvania | 42121 | 11234 | 237 |
2365158 | 2365158 | 2022-04-01 | Venango | Pennsylvania | 42121 | 11232 | 237 |
2361905 | 2361905 | 2022-03-31 | Venango | Pennsylvania | 42121 | 11232 | 236 |
2358651 | 2358651 | 2022-03-30 | Venango | Pennsylvania | 42121 | 11231 | 236 |
2355397 | 2355397 | 2022-03-29 | Venango | Pennsylvania | 42121 | 11230 | 236 |
2352144 | 2352144 | 2022-03-28 | Venango | Pennsylvania | 42121 | 11229 | 236 |
2348892 | 2348892 | 2022-03-27 | Venango | Pennsylvania | 42121 | 11228 | 236 |
2345639 | 2345639 | 2022-03-26 | Venango | Pennsylvania | 42121 | 11228 | 236 |
2342386 | 2342386 | 2022-03-25 | Venango | Pennsylvania | 42121 | 11228 | 236 |
2339133 | 2339133 | 2022-03-24 | Venango | Pennsylvania | 42121 | 11227 | 236 |
2335879 | 2335879 | 2022-03-23 | Venango | Pennsylvania | 42121 | 11227 | 236 |
2332625 | 2332625 | 2022-03-22 | Venango | Pennsylvania | 42121 | 11227 | 236 |
2329372 | 2329372 | 2022-03-21 | Venango | Pennsylvania | 42121 | 11226 | 236 |
2326120 | 2326120 | 2022-03-20 | Venango | Pennsylvania | 42121 | 11224 | 236 |
2322867 | 2322867 | 2022-03-19 | Venango | Pennsylvania | 42121 | 11223 | 236 |
2319613 | 2319613 | 2022-03-18 | Venango | Pennsylvania | 42121 | 11221 | 236 |
2316359 | 2316359 | 2022-03-17 | Venango | Pennsylvania | 42121 | 11217 | 236 |
2313106 | 2313106 | 2022-03-16 | Venango | Pennsylvania | 42121 | 11216 | 234 |
2309853 | 2309853 | 2022-03-15 | Venango | Pennsylvania | 42121 | 11214 | 234 |
2306600 | 2306600 | 2022-03-14 | Venango | Pennsylvania | 42121 | 11213 | 234 |
2303349 | 2303349 | 2022-03-13 | Venango | Pennsylvania | 42121 | 11210 | 234 |
2300097 | 2300097 | 2022-03-12 | Venango | Pennsylvania | 42121 | 11207 | 234 |
2296845 | 2296845 | 2022-03-11 | Venango | Pennsylvania | 42121 | 11205 | 234 |
2293593 | 2293593 | 2022-03-10 | Venango | Pennsylvania | 42121 | 11200 | 233 |
2290341 | 2290341 | 2022-03-09 | Venango | Pennsylvania | 42121 | 11196 | 233 |
2287089 | 2287089 | 2022-03-08 | Venango | Pennsylvania | 42121 | 11194 | 233 |
2283837 | 2283837 | 2022-03-07 | Venango | Pennsylvania | 42121 | 11191 | 233 |
2280585 | 2280585 | 2022-03-06 | Venango | Pennsylvania | 42121 | 11191 | 233 |
2277332 | 2277332 | 2022-03-05 | Venango | Pennsylvania | 42121 | 11189 | 232 |
2274079 | 2274079 | 2022-03-04 | Venango | Pennsylvania | 42121 | 11181 | 232 |
2270826 | 2270826 | 2022-03-03 | Venango | Pennsylvania | 42121 | 11175 | 231 |
2267574 | 2267574 | 2022-03-02 | Venango | Pennsylvania | 42121 | 11167 | 229 |
2264321 | 2264321 | 2022-03-01 | Venango | Pennsylvania | 42121 | 11161 | 229 |
2261071 | 2261071 | 2022-02-28 | Venango | Pennsylvania | 42121 | 11160 | 229 |
2257820 | 2257820 | 2022-02-27 | Venango | Pennsylvania | 42121 | 11158 | 229 |
2254569 | 2254569 | 2022-02-26 | Venango | Pennsylvania | 42121 | 11154 | 229 |
2251318 | 2251318 | 2022-02-25 | Venango | Pennsylvania | 42121 | 11152 | 229 |
2248067 | 2248067 | 2022-02-24 | Venango | Pennsylvania | 42121 | 11149 | 229 |
2244816 | 2244816 | 2022-02-23 | Venango | Pennsylvania | 42121 | 11141 | 229 |
2241565 | 2241565 | 2022-02-22 | Venango | Pennsylvania | 42121 | 11128 | 228 |
2238314 | 2238314 | 2022-02-21 | Venango | Pennsylvania | 42121 | 11122 | 228 |
2235063 | 2235063 | 2022-02-20 | Venango | Pennsylvania | 42121 | 11122 | 228 |
2231812 | 2231812 | 2022-02-19 | Venango | Pennsylvania | 42121 | 11116 | 229 |
2228561 | 2228561 | 2022-02-18 | Venango | Pennsylvania | 42121 | 11102 | 229 |
2225310 | 2225310 | 2022-02-17 | Venango | Pennsylvania | 42121 | 11084 | 229 |
2222059 | 2222059 | 2022-02-16 | Venango | Pennsylvania | 42121 | 11066 | 228 |
2218808 | 2218808 | 2022-02-15 | Venango | Pennsylvania | 42121 | 11063 | 227 |
2215557 | 2215557 | 2022-02-14 | Venango | Pennsylvania | 42121 | 11056 | 227 |
2212306 | 2212306 | 2022-02-13 | Venango | Pennsylvania | 42121 | 11053 | 227 |
2209053 | 2209053 | 2022-02-12 | Venango | Pennsylvania | 42121 | 11037 | 227 |
2205800 | 2205800 | 2022-02-11 | Venango | Pennsylvania | 42121 | 11017 | 227 |
2202547 | 2202547 | 2022-02-10 | Venango | Pennsylvania | 42121 | 11009 | 227 |
2199293 | 2199293 | 2022-02-09 | Venango | Pennsylvania | 42121 | 10985 | 225 |
2196039 | 2196039 | 2022-02-08 | Venango | Pennsylvania | 42121 | 10962 | 225 |
2192785 | 2192785 | 2022-02-07 | Venango | Pennsylvania | 42121 | 10961 | 222 |
2189531 | 2189531 | 2022-02-06 | Venango | Pennsylvania | 42121 | 10945 | 222 |
2186278 | 2186278 | 2022-02-05 | Venango | Pennsylvania | 42121 | 10933 | 222 |
2183026 | 2183026 | 2022-02-04 | Venango | Pennsylvania | 42121 | 10897 | 222 |
2179774 | 2179774 | 2022-02-03 | Venango | Pennsylvania | 42121 | 10868 | 222 |
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);