ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Wayne" and fips = 42127 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 |
---|---|---|---|---|---|---|---|
2501910 | 2501910 | 2022-05-13 | Wayne | Pennsylvania | 42127 | 10460 | 172 |
2498652 | 2498652 | 2022-05-12 | Wayne | Pennsylvania | 42127 | 10460 | 172 |
2495394 | 2495394 | 2022-05-11 | Wayne | Pennsylvania | 42127 | 10460 | 172 |
2492136 | 2492136 | 2022-05-10 | Wayne | Pennsylvania | 42127 | 10350 | 172 |
2488878 | 2488878 | 2022-05-09 | Wayne | Pennsylvania | 42127 | 10350 | 172 |
2485621 | 2485621 | 2022-05-08 | Wayne | Pennsylvania | 42127 | 10350 | 172 |
2482363 | 2482363 | 2022-05-07 | Wayne | Pennsylvania | 42127 | 10350 | 172 |
2479105 | 2479105 | 2022-05-06 | Wayne | Pennsylvania | 42127 | 10350 | 172 |
2475847 | 2475847 | 2022-05-05 | Wayne | Pennsylvania | 42127 | 10350 | 172 |
2472590 | 2472590 | 2022-05-04 | Wayne | Pennsylvania | 42127 | 10350 | 172 |
2469334 | 2469334 | 2022-05-03 | Wayne | Pennsylvania | 42127 | 10335 | 171 |
2466078 | 2466078 | 2022-05-02 | Wayne | Pennsylvania | 42127 | 10318 | 171 |
2462823 | 2462823 | 2022-05-01 | Wayne | Pennsylvania | 42127 | 10314 | 171 |
2459567 | 2459567 | 2022-04-30 | Wayne | Pennsylvania | 42127 | 10313 | 171 |
2456311 | 2456311 | 2022-04-29 | Wayne | Pennsylvania | 42127 | 10306 | 171 |
2453055 | 2453055 | 2022-04-28 | Wayne | Pennsylvania | 42127 | 10287 | 170 |
2449799 | 2449799 | 2022-04-27 | Wayne | Pennsylvania | 42127 | 10276 | 170 |
2446542 | 2446542 | 2022-04-26 | Wayne | Pennsylvania | 42127 | 10264 | 170 |
2443287 | 2443287 | 2022-04-25 | Wayne | Pennsylvania | 42127 | 10256 | 170 |
2440031 | 2440031 | 2022-04-24 | Wayne | Pennsylvania | 42127 | 10248 | 170 |
2436775 | 2436775 | 2022-04-23 | Wayne | Pennsylvania | 42127 | 10240 | 170 |
2433519 | 2433519 | 2022-04-22 | Wayne | Pennsylvania | 42127 | 10231 | 170 |
2430263 | 2430263 | 2022-04-21 | Wayne | Pennsylvania | 42127 | 10219 | 170 |
2427007 | 2427007 | 2022-04-20 | Wayne | Pennsylvania | 42127 | 10210 | 170 |
2423751 | 2423751 | 2022-04-19 | Wayne | Pennsylvania | 42127 | 10205 | 169 |
2420495 | 2420495 | 2022-04-18 | Wayne | Pennsylvania | 42127 | 10195 | 169 |
2417239 | 2417239 | 2022-04-17 | Wayne | Pennsylvania | 42127 | 10191 | 169 |
2413983 | 2413983 | 2022-04-16 | Wayne | Pennsylvania | 42127 | 10188 | 169 |
2410727 | 2410727 | 2022-04-15 | Wayne | Pennsylvania | 42127 | 10176 | 169 |
2407471 | 2407471 | 2022-04-14 | Wayne | Pennsylvania | 42127 | 10168 | 169 |
2404215 | 2404215 | 2022-04-13 | Wayne | Pennsylvania | 42127 | 10157 | 169 |
2400960 | 2400960 | 2022-04-12 | Wayne | Pennsylvania | 42127 | 10151 | 169 |
2397705 | 2397705 | 2022-04-11 | Wayne | Pennsylvania | 42127 | 10147 | 169 |
2394450 | 2394450 | 2022-04-10 | Wayne | Pennsylvania | 42127 | 10145 | 169 |
2391194 | 2391194 | 2022-04-09 | Wayne | Pennsylvania | 42127 | 10141 | 169 |
2387938 | 2387938 | 2022-04-08 | Wayne | Pennsylvania | 42127 | 10136 | 169 |
2384683 | 2384683 | 2022-04-07 | Wayne | Pennsylvania | 42127 | 10130 | 169 |
2381428 | 2381428 | 2022-04-06 | Wayne | Pennsylvania | 42127 | 10127 | 169 |
2378173 | 2378173 | 2022-04-05 | Wayne | Pennsylvania | 42127 | 10123 | 169 |
2374919 | 2374919 | 2022-04-04 | Wayne | Pennsylvania | 42127 | 10116 | 169 |
2371667 | 2371667 | 2022-04-03 | Wayne | Pennsylvania | 42127 | 10115 | 169 |
2368414 | 2368414 | 2022-04-02 | Wayne | Pennsylvania | 42127 | 10115 | 169 |
2365161 | 2365161 | 2022-04-01 | Wayne | Pennsylvania | 42127 | 10110 | 169 |
2361908 | 2361908 | 2022-03-31 | Wayne | Pennsylvania | 42127 | 10101 | 169 |
2358654 | 2358654 | 2022-03-30 | Wayne | Pennsylvania | 42127 | 10101 | 169 |
2355400 | 2355400 | 2022-03-29 | Wayne | Pennsylvania | 42127 | 10095 | 169 |
2352147 | 2352147 | 2022-03-28 | Wayne | Pennsylvania | 42127 | 10088 | 169 |
2348895 | 2348895 | 2022-03-27 | Wayne | Pennsylvania | 42127 | 10087 | 169 |
2345642 | 2345642 | 2022-03-26 | Wayne | Pennsylvania | 42127 | 10086 | 169 |
2342389 | 2342389 | 2022-03-25 | Wayne | Pennsylvania | 42127 | 10083 | 168 |
2339136 | 2339136 | 2022-03-24 | Wayne | Pennsylvania | 42127 | 10080 | 168 |
2335882 | 2335882 | 2022-03-23 | Wayne | Pennsylvania | 42127 | 10075 | 168 |
2332628 | 2332628 | 2022-03-22 | Wayne | Pennsylvania | 42127 | 10072 | 168 |
2329375 | 2329375 | 2022-03-21 | Wayne | Pennsylvania | 42127 | 10069 | 167 |
2326123 | 2326123 | 2022-03-20 | Wayne | Pennsylvania | 42127 | 10066 | 167 |
2322870 | 2322870 | 2022-03-19 | Wayne | Pennsylvania | 42127 | 10067 | 167 |
2319616 | 2319616 | 2022-03-18 | Wayne | Pennsylvania | 42127 | 10061 | 167 |
2316362 | 2316362 | 2022-03-17 | Wayne | Pennsylvania | 42127 | 10058 | 167 |
2313109 | 2313109 | 2022-03-16 | Wayne | Pennsylvania | 42127 | 10050 | 167 |
2309856 | 2309856 | 2022-03-15 | Wayne | Pennsylvania | 42127 | 10048 | 167 |
2306603 | 2306603 | 2022-03-14 | Wayne | Pennsylvania | 42127 | 10042 | 167 |
2303352 | 2303352 | 2022-03-13 | Wayne | Pennsylvania | 42127 | 10041 | 167 |
2300100 | 2300100 | 2022-03-12 | Wayne | Pennsylvania | 42127 | 10040 | 167 |
2296848 | 2296848 | 2022-03-11 | Wayne | Pennsylvania | 42127 | 10035 | 167 |
2293596 | 2293596 | 2022-03-10 | Wayne | Pennsylvania | 42127 | 10032 | 167 |
2290344 | 2290344 | 2022-03-09 | Wayne | Pennsylvania | 42127 | 10026 | 166 |
2287092 | 2287092 | 2022-03-08 | Wayne | Pennsylvania | 42127 | 10022 | 166 |
2283840 | 2283840 | 2022-03-07 | Wayne | Pennsylvania | 42127 | 10016 | 166 |
2280588 | 2280588 | 2022-03-06 | Wayne | Pennsylvania | 42127 | 10012 | 166 |
2277335 | 2277335 | 2022-03-05 | Wayne | Pennsylvania | 42127 | 10008 | 166 |
2274082 | 2274082 | 2022-03-04 | Wayne | Pennsylvania | 42127 | 10004 | 166 |
2270829 | 2270829 | 2022-03-03 | Wayne | Pennsylvania | 42127 | 9998 | 165 |
2267577 | 2267577 | 2022-03-02 | Wayne | Pennsylvania | 42127 | 9995 | 164 |
2264324 | 2264324 | 2022-03-01 | Wayne | Pennsylvania | 42127 | 9988 | 164 |
2261074 | 2261074 | 2022-02-28 | Wayne | Pennsylvania | 42127 | 9979 | 163 |
2257823 | 2257823 | 2022-02-27 | Wayne | Pennsylvania | 42127 | 9978 | 163 |
2254572 | 2254572 | 2022-02-26 | Wayne | Pennsylvania | 42127 | 9975 | 163 |
2251321 | 2251321 | 2022-02-25 | Wayne | Pennsylvania | 42127 | 9961 | 161 |
2248070 | 2248070 | 2022-02-24 | Wayne | Pennsylvania | 42127 | 9954 | 161 |
2244819 | 2244819 | 2022-02-23 | Wayne | Pennsylvania | 42127 | 9936 | 161 |
2241568 | 2241568 | 2022-02-22 | Wayne | Pennsylvania | 42127 | 9924 | 160 |
2238317 | 2238317 | 2022-02-21 | Wayne | Pennsylvania | 42127 | 9903 | 160 |
2235066 | 2235066 | 2022-02-20 | Wayne | Pennsylvania | 42127 | 9903 | 160 |
2231815 | 2231815 | 2022-02-19 | Wayne | Pennsylvania | 42127 | 9900 | 160 |
2228564 | 2228564 | 2022-02-18 | Wayne | Pennsylvania | 42127 | 9871 | 160 |
2225313 | 2225313 | 2022-02-17 | Wayne | Pennsylvania | 42127 | 9854 | 160 |
2222062 | 2222062 | 2022-02-16 | Wayne | Pennsylvania | 42127 | 9842 | 160 |
2218811 | 2218811 | 2022-02-15 | Wayne | Pennsylvania | 42127 | 9826 | 159 |
2215560 | 2215560 | 2022-02-14 | Wayne | Pennsylvania | 42127 | 9815 | 159 |
2212309 | 2212309 | 2022-02-13 | Wayne | Pennsylvania | 42127 | 9810 | 159 |
2209056 | 2209056 | 2022-02-12 | Wayne | Pennsylvania | 42127 | 9804 | 159 |
2205803 | 2205803 | 2022-02-11 | Wayne | Pennsylvania | 42127 | 9786 | 156 |
2202550 | 2202550 | 2022-02-10 | Wayne | Pennsylvania | 42127 | 9778 | 156 |
2199296 | 2199296 | 2022-02-09 | Wayne | Pennsylvania | 42127 | 9758 | 156 |
2196042 | 2196042 | 2022-02-08 | Wayne | Pennsylvania | 42127 | 9736 | 156 |
2192788 | 2192788 | 2022-02-07 | Wayne | Pennsylvania | 42127 | 9736 | 154 |
2189534 | 2189534 | 2022-02-06 | Wayne | Pennsylvania | 42127 | 9706 | 154 |
2186281 | 2186281 | 2022-02-05 | Wayne | Pennsylvania | 42127 | 9698 | 154 |
2183029 | 2183029 | 2022-02-04 | Wayne | Pennsylvania | 42127 | 9671 | 154 |
2179777 | 2179777 | 2022-02-03 | Wayne | Pennsylvania | 42127 | 9632 | 154 |
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);