ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 42027 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 198 ✖
- 11 55
- 228 42
- 213 38
- 0 28
- 7 24
- 6 23
- 348 23
- 2 22
- 224 20
- 10 17
- 346 17
- 220 15
- 230 13
- 232 13
- 9 12
- 8 11
- 345 11
- 235 10
- 222 9
- 241 8
- 244 8
- 349 8
- 15 7
- 16 7
- 208 7
- 225 7
- 237 7
- 258 7
- 227 6
- 246 6
- 5 5
- 193 5
- 206 5
- 229 5
- 231 5
- 333 5
- 335 5
- 347 5
- 1 4
- 13 4
- 22 4
- 23 4
- 48 4
- 131 4
- 215 4
- 219 4
- 226 4
- 233 4
- 283 4
- 305 4
- 321 4
- 326 4
- 19 3
- 24 3
- 35 3
- 200 3
- 211 3
- 214 3
- 217 3
- 221 3
- 234 3
- 242 3
- 250 3
- 267 3
- 289 3
- 298 3
- 332 3
- 343 3
- 351 3
- 12 2
- 14 2
- 20 2
- 79 2
- 118 2
- 124 2
- 145 2
- 150 2
- 171 2
- 185 2
- 201 2
- 203 2
- 209 2
- 243 2
- 247 2
- 248 2
- 251 2
- 253 2
- 254 2
- 255 2
- 264 2
- 265 2
- 268 2
- 275 2
- 301 2
- 316 2
- 338 2
- 344 2
- 4 1
- 17 1
- 18 1
- 21 1
- 25 1
- 28 1
- 33 1
- 34 1
- 38 1
- 42 1
- 57 1
- 59 1
- 68 1
- 73 1
- 77 1
- 81 1
- 85 1
- 90 1
- 96 1
- 100 1
- 104 1
- 106 1
- 110 1
- 113 1
- 122 1
- 125 1
- 127 1
- 132 1
- 135 1
- 138 1
- 139 1
- 142 1
- 143 1
- 146 1
- 147 1
- 148 1
- 152 1
- 153 1
- 158 1
- 162 1
- 166 1
- 167 1
- 169 1
- 173 1
- 175 1
- 179 1
- 181 1
- 183 1
- 186 1
- 188 1
- 191 1
- 195 1
- 199 1
- 202 1
- 204 1
- 205 1
- 207 1
- 210 1
- 216 1
- 223 1
- 236 1
- 256 1
- 260 1
- 261 1
- 263 1
- 270 1
- 271 1
- 272 1
- 273 1
- 276 1
- 278 1
- 280 1
- 281 1
- 286 1
- 287 1
- 288 1
- 291 1
- 292 1
- 293 1
- 294 1
- 295 1
- 300 1
- 304 1
- 306 1
- 309 1
- 313 1
- 315 1
- 317 1
- 318 1
- 319 1
- 320 1
- 324 1
- 327 1
- 328 1
- 329 1
- 330 1
- 331 1
- 336 1
- 337 1
- 341 1
- 342 1
state 1
- Pennsylvania 785
fips 1
- 42027 · 785 ✖
county 1
- Centre 785
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501860 | 2501860 | 2022-05-13 | Centre | Pennsylvania | 42027 | 36016 | 351 |
2498602 | 2498602 | 2022-05-12 | Centre | Pennsylvania | 42027 | 36016 | 351 |
2495344 | 2495344 | 2022-05-11 | Centre | Pennsylvania | 42027 | 36016 | 351 |
2492086 | 2492086 | 2022-05-10 | Centre | Pennsylvania | 42027 | 35736 | 349 |
2488828 | 2488828 | 2022-05-09 | Centre | Pennsylvania | 42027 | 35736 | 349 |
2485571 | 2485571 | 2022-05-08 | Centre | Pennsylvania | 42027 | 35736 | 349 |
2482313 | 2482313 | 2022-05-07 | Centre | Pennsylvania | 42027 | 35736 | 349 |
2479055 | 2479055 | 2022-05-06 | Centre | Pennsylvania | 42027 | 35736 | 349 |
2475797 | 2475797 | 2022-05-05 | Centre | Pennsylvania | 42027 | 35736 | 349 |
2472540 | 2472540 | 2022-05-04 | Centre | Pennsylvania | 42027 | 35736 | 349 |
2469284 | 2469284 | 2022-05-03 | Centre | Pennsylvania | 42027 | 35703 | 349 |
2466028 | 2466028 | 2022-05-02 | Centre | Pennsylvania | 42027 | 35677 | 348 |
2462773 | 2462773 | 2022-05-01 | Centre | Pennsylvania | 42027 | 35666 | 348 |
2459517 | 2459517 | 2022-04-30 | Centre | Pennsylvania | 42027 | 35651 | 348 |
2456261 | 2456261 | 2022-04-29 | Centre | Pennsylvania | 42027 | 35625 | 348 |
2453005 | 2453005 | 2022-04-28 | Centre | Pennsylvania | 42027 | 35590 | 348 |
2449749 | 2449749 | 2022-04-27 | Centre | Pennsylvania | 42027 | 35552 | 348 |
2446492 | 2446492 | 2022-04-26 | Centre | Pennsylvania | 42027 | 35518 | 348 |
2443237 | 2443237 | 2022-04-25 | Centre | Pennsylvania | 42027 | 35503 | 348 |
2439981 | 2439981 | 2022-04-24 | Centre | Pennsylvania | 42027 | 35496 | 348 |
2436725 | 2436725 | 2022-04-23 | Centre | Pennsylvania | 42027 | 35482 | 348 |
2433469 | 2433469 | 2022-04-22 | Centre | Pennsylvania | 42027 | 35459 | 348 |
2430213 | 2430213 | 2022-04-21 | Centre | Pennsylvania | 42027 | 35435 | 348 |
2426957 | 2426957 | 2022-04-20 | Centre | Pennsylvania | 42027 | 35412 | 348 |
2423701 | 2423701 | 2022-04-19 | Centre | Pennsylvania | 42027 | 35388 | 348 |
2420445 | 2420445 | 2022-04-18 | Centre | Pennsylvania | 42027 | 35360 | 348 |
2417189 | 2417189 | 2022-04-17 | Centre | Pennsylvania | 42027 | 35355 | 348 |
2413933 | 2413933 | 2022-04-16 | Centre | Pennsylvania | 42027 | 35344 | 348 |
2410677 | 2410677 | 2022-04-15 | Centre | Pennsylvania | 42027 | 35314 | 348 |
2407421 | 2407421 | 2022-04-14 | Centre | Pennsylvania | 42027 | 35295 | 348 |
2404165 | 2404165 | 2022-04-13 | Centre | Pennsylvania | 42027 | 35270 | 348 |
2400910 | 2400910 | 2022-04-12 | Centre | Pennsylvania | 42027 | 35245 | 348 |
2397655 | 2397655 | 2022-04-11 | Centre | Pennsylvania | 42027 | 35221 | 348 |
2394400 | 2394400 | 2022-04-10 | Centre | Pennsylvania | 42027 | 35212 | 348 |
2391144 | 2391144 | 2022-04-09 | Centre | Pennsylvania | 42027 | 35194 | 347 |
2387888 | 2387888 | 2022-04-08 | Centre | Pennsylvania | 42027 | 35169 | 347 |
2384633 | 2384633 | 2022-04-07 | Centre | Pennsylvania | 42027 | 35155 | 347 |
2381378 | 2381378 | 2022-04-06 | Centre | Pennsylvania | 42027 | 35138 | 347 |
2378123 | 2378123 | 2022-04-05 | Centre | Pennsylvania | 42027 | 35121 | 347 |
2374869 | 2374869 | 2022-04-04 | Centre | Pennsylvania | 42027 | 35105 | 346 |
2371617 | 2371617 | 2022-04-03 | Centre | Pennsylvania | 42027 | 35097 | 346 |
2368364 | 2368364 | 2022-04-02 | Centre | Pennsylvania | 42027 | 35097 | 346 |
2365111 | 2365111 | 2022-04-01 | Centre | Pennsylvania | 42027 | 35093 | 346 |
2361858 | 2361858 | 2022-03-31 | Centre | Pennsylvania | 42027 | 35087 | 346 |
2358604 | 2358604 | 2022-03-30 | Centre | Pennsylvania | 42027 | 35073 | 346 |
2355350 | 2355350 | 2022-03-29 | Centre | Pennsylvania | 42027 | 35063 | 346 |
2352097 | 2352097 | 2022-03-28 | Centre | Pennsylvania | 42027 | 35048 | 345 |
2348845 | 2348845 | 2022-03-27 | Centre | Pennsylvania | 42027 | 35044 | 345 |
2345592 | 2345592 | 2022-03-26 | Centre | Pennsylvania | 42027 | 35039 | 345 |
2342339 | 2342339 | 2022-03-25 | Centre | Pennsylvania | 42027 | 35031 | 345 |
2339086 | 2339086 | 2022-03-24 | Centre | Pennsylvania | 42027 | 35019 | 346 |
2335832 | 2335832 | 2022-03-23 | Centre | Pennsylvania | 42027 | 35011 | 346 |
2332578 | 2332578 | 2022-03-22 | Centre | Pennsylvania | 42027 | 34996 | 346 |
2329325 | 2329325 | 2022-03-21 | Centre | Pennsylvania | 42027 | 34992 | 346 |
2326073 | 2326073 | 2022-03-20 | Centre | Pennsylvania | 42027 | 34985 | 346 |
2322820 | 2322820 | 2022-03-19 | Centre | Pennsylvania | 42027 | 34984 | 346 |
2319566 | 2319566 | 2022-03-18 | Centre | Pennsylvania | 42027 | 34966 | 346 |
2316312 | 2316312 | 2022-03-17 | Centre | Pennsylvania | 42027 | 34956 | 346 |
2313059 | 2313059 | 2022-03-16 | Centre | Pennsylvania | 42027 | 34944 | 346 |
2309806 | 2309806 | 2022-03-15 | Centre | Pennsylvania | 42027 | 34928 | 346 |
2306553 | 2306553 | 2022-03-14 | Centre | Pennsylvania | 42027 | 34908 | 345 |
2303302 | 2303302 | 2022-03-13 | Centre | Pennsylvania | 42027 | 34905 | 345 |
2300050 | 2300050 | 2022-03-12 | Centre | Pennsylvania | 42027 | 34902 | 345 |
2296798 | 2296798 | 2022-03-11 | Centre | Pennsylvania | 42027 | 34891 | 345 |
2293546 | 2293546 | 2022-03-10 | Centre | Pennsylvania | 42027 | 34876 | 345 |
2290294 | 2290294 | 2022-03-09 | Centre | Pennsylvania | 42027 | 34867 | 345 |
2287042 | 2287042 | 2022-03-08 | Centre | Pennsylvania | 42027 | 34862 | 345 |
2283790 | 2283790 | 2022-03-07 | Centre | Pennsylvania | 42027 | 34850 | 344 |
2280538 | 2280538 | 2022-03-06 | Centre | Pennsylvania | 42027 | 34847 | 344 |
2277285 | 2277285 | 2022-03-05 | Centre | Pennsylvania | 42027 | 34838 | 343 |
2274032 | 2274032 | 2022-03-04 | Centre | Pennsylvania | 42027 | 34820 | 343 |
2270779 | 2270779 | 2022-03-03 | Centre | Pennsylvania | 42027 | 34794 | 343 |
2267527 | 2267527 | 2022-03-02 | Centre | Pennsylvania | 42027 | 34772 | 342 |
2264274 | 2264274 | 2022-03-01 | Centre | Pennsylvania | 42027 | 34741 | 341 |
2261024 | 2261024 | 2022-02-28 | Centre | Pennsylvania | 42027 | 34715 | 338 |
2257773 | 2257773 | 2022-02-27 | Centre | Pennsylvania | 42027 | 34708 | 338 |
2254522 | 2254522 | 2022-02-26 | Centre | Pennsylvania | 42027 | 34693 | 337 |
2251271 | 2251271 | 2022-02-25 | Centre | Pennsylvania | 42027 | 34668 | 336 |
2248020 | 2248020 | 2022-02-24 | Centre | Pennsylvania | 42027 | 34638 | 335 |
2244769 | 2244769 | 2022-02-23 | Centre | Pennsylvania | 42027 | 34611 | 335 |
2241518 | 2241518 | 2022-02-22 | Centre | Pennsylvania | 42027 | 34575 | 335 |
2238267 | 2238267 | 2022-02-21 | Centre | Pennsylvania | 42027 | 34530 | 335 |
2235016 | 2235016 | 2022-02-20 | Centre | Pennsylvania | 42027 | 34530 | 335 |
2231765 | 2231765 | 2022-02-19 | Centre | Pennsylvania | 42027 | 34492 | 333 |
2228514 | 2228514 | 2022-02-18 | Centre | Pennsylvania | 42027 | 34437 | 333 |
2225263 | 2225263 | 2022-02-17 | Centre | Pennsylvania | 42027 | 34385 | 333 |
2222012 | 2222012 | 2022-02-16 | Centre | Pennsylvania | 42027 | 34337 | 333 |
2218761 | 2218761 | 2022-02-15 | Centre | Pennsylvania | 42027 | 34302 | 333 |
2215510 | 2215510 | 2022-02-14 | Centre | Pennsylvania | 42027 | 34263 | 332 |
2212259 | 2212259 | 2022-02-13 | Centre | Pennsylvania | 42027 | 34240 | 332 |
2209006 | 2209006 | 2022-02-12 | Centre | Pennsylvania | 42027 | 34210 | 332 |
2205753 | 2205753 | 2022-02-11 | Centre | Pennsylvania | 42027 | 34117 | 331 |
2202500 | 2202500 | 2022-02-10 | Centre | Pennsylvania | 42027 | 34068 | 330 |
2199246 | 2199246 | 2022-02-09 | Centre | Pennsylvania | 42027 | 33998 | 329 |
2195992 | 2195992 | 2022-02-08 | Centre | Pennsylvania | 42027 | 33921 | 328 |
2192738 | 2192738 | 2022-02-07 | Centre | Pennsylvania | 42027 | 33997 | 327 |
2189484 | 2189484 | 2022-02-06 | Centre | Pennsylvania | 42027 | 33859 | 326 |
2186231 | 2186231 | 2022-02-05 | Centre | Pennsylvania | 42027 | 33814 | 326 |
2182979 | 2182979 | 2022-02-04 | Centre | Pennsylvania | 42027 | 33689 | 326 |
2179727 | 2179727 | 2022-02-03 | Centre | Pennsylvania | 42027 | 33604 | 326 |
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);