ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 42001 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 210 ✖
- 190 33
- 189 25
- 0 22
- 26 20
- 23 19
- 5 15
- 27 15
- 186 15
- 358 15
- 360 14
- 20 13
- 1 12
- 192 11
- 361 11
- 362 11
- 8 10
- 25 10
- 191 10
- 12 9
- 183 9
- 2 8
- 13 8
- 148 8
- 158 8
- 182 8
- 9 7
- 14 7
- 24 7
- 161 7
- 241 7
- 354 7
- 4 6
- 7 6
- 15 6
- 34 6
- 45 6
- 142 6
- 144 6
- 155 6
- 163 6
- 171 6
- 177 6
- 206 6
- 248 6
- 347 6
- 11 5
- 22 5
- 150 5
- 152 5
- 169 5
- 188 5
- 194 5
- 196 5
- 199 5
- 274 5
- 349 5
- 357 5
- 6 4
- 17 4
- 31 4
- 39 4
- 47 4
- 159 4
- 168 4
- 197 4
- 211 4
- 219 4
- 231 4
- 254 4
- 266 4
- 300 4
- 344 4
- 52 3
- 53 3
- 64 3
- 71 3
- 137 3
- 147 3
- 162 3
- 225 3
- 233 3
- 235 3
- 242 3
- 289 3
- 310 3
- 323 3
- 343 3
- 356 3
- 364 3
- 10 2
- 18 2
- 46 2
- 49 2
- 54 2
- 61 2
- 74 2
- 90 2
- 108 2
- 124 2
- 140 2
- 145 2
- 151 2
- 156 2
- 166 2
- 180 2
- 181 2
- 187 2
- 193 2
- 210 2
- 217 2
- 224 2
- 230 2
- 243 2
- 256 2
- 261 2
- 314 2
- 321 2
- 345 2
- 353 2
- 16 1
- 19 1
- 21 1
- 28 1
- 29 1
- 32 1
- 33 1
- 36 1
- 37 1
- 40 1
- 42 1
- 48 1
- 50 1
- 51 1
- 56 1
- 57 1
- 66 1
- 68 1
- 77 1
- 81 1
- 88 1
- 91 1
- 92 1
- 95 1
- 101 1
- 111 1
- 112 1
- 114 1
- 115 1
- 116 1
- 120 1
- 122 1
- 123 1
- 125 1
- 126 1
- 128 1
- 130 1
- 135 1
- 141 1
- 146 1
- 153 1
- 157 1
- 170 1
- 173 1
- 174 1
- 176 1
- 184 1
- 185 1
- 200 1
- 205 1
- 215 1
- 218 1
- 220 1
- 221 1
- 229 1
- 238 1
- 240 1
- 246 1
- 247 1
- 251 1
- 252 1
- 253 1
- 258 1
- 260 1
- 262 1
- 264 1
- 265 1
- 268 1
- 273 1
- 282 1
- 284 1
- 286 1
- 288 1
- 290 1
- 293 1
- 294 1
- 298 1
- 301 1
- 304 1
- 309 1
- 326 1
- 329 1
- 333 1
- 335 1
- 337 1
- 338 1
- 339 1
- 342 1
- 351 1
- 355 1
- 359 1
state 1
- Pennsylvania 787
fips 1
- 42001 · 787 ✖
county 1
- Adams 787
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501847 | 2501847 | 2022-05-13 | Adams | Pennsylvania | 42001 | 25114 | 364 |
2498589 | 2498589 | 2022-05-12 | Adams | Pennsylvania | 42001 | 25114 | 364 |
2495331 | 2495331 | 2022-05-11 | Adams | Pennsylvania | 42001 | 25114 | 364 |
2492073 | 2492073 | 2022-05-10 | Adams | Pennsylvania | 42001 | 24996 | 362 |
2488815 | 2488815 | 2022-05-09 | Adams | Pennsylvania | 42001 | 24996 | 362 |
2485558 | 2485558 | 2022-05-08 | Adams | Pennsylvania | 42001 | 24996 | 362 |
2482300 | 2482300 | 2022-05-07 | Adams | Pennsylvania | 42001 | 24996 | 362 |
2479042 | 2479042 | 2022-05-06 | Adams | Pennsylvania | 42001 | 24996 | 362 |
2475784 | 2475784 | 2022-05-05 | Adams | Pennsylvania | 42001 | 24996 | 362 |
2472527 | 2472527 | 2022-05-04 | Adams | Pennsylvania | 42001 | 24996 | 362 |
2469271 | 2469271 | 2022-05-03 | Adams | Pennsylvania | 42001 | 24983 | 362 |
2466015 | 2466015 | 2022-05-02 | Adams | Pennsylvania | 42001 | 24964 | 362 |
2462760 | 2462760 | 2022-05-01 | Adams | Pennsylvania | 42001 | 24952 | 362 |
2459504 | 2459504 | 2022-04-30 | Adams | Pennsylvania | 42001 | 24945 | 362 |
2456248 | 2456248 | 2022-04-29 | Adams | Pennsylvania | 42001 | 24926 | 361 |
2452992 | 2452992 | 2022-04-28 | Adams | Pennsylvania | 42001 | 24910 | 361 |
2449736 | 2449736 | 2022-04-27 | Adams | Pennsylvania | 42001 | 24888 | 361 |
2446479 | 2446479 | 2022-04-26 | Adams | Pennsylvania | 42001 | 24870 | 361 |
2443224 | 2443224 | 2022-04-25 | Adams | Pennsylvania | 42001 | 24855 | 361 |
2439968 | 2439968 | 2022-04-24 | Adams | Pennsylvania | 42001 | 24849 | 361 |
2436712 | 2436712 | 2022-04-23 | Adams | Pennsylvania | 42001 | 24846 | 361 |
2433456 | 2433456 | 2022-04-22 | Adams | Pennsylvania | 42001 | 24837 | 361 |
2430200 | 2430200 | 2022-04-21 | Adams | Pennsylvania | 42001 | 24828 | 361 |
2426944 | 2426944 | 2022-04-20 | Adams | Pennsylvania | 42001 | 24821 | 361 |
2423688 | 2423688 | 2022-04-19 | Adams | Pennsylvania | 42001 | 24814 | 361 |
2420432 | 2420432 | 2022-04-18 | Adams | Pennsylvania | 42001 | 24809 | 360 |
2417176 | 2417176 | 2022-04-17 | Adams | Pennsylvania | 42001 | 24807 | 360 |
2413920 | 2413920 | 2022-04-16 | Adams | Pennsylvania | 42001 | 24806 | 360 |
2410664 | 2410664 | 2022-04-15 | Adams | Pennsylvania | 42001 | 24804 | 360 |
2407408 | 2407408 | 2022-04-14 | Adams | Pennsylvania | 42001 | 24794 | 360 |
2404152 | 2404152 | 2022-04-13 | Adams | Pennsylvania | 42001 | 24780 | 360 |
2400897 | 2400897 | 2022-04-12 | Adams | Pennsylvania | 42001 | 24774 | 360 |
2397642 | 2397642 | 2022-04-11 | Adams | Pennsylvania | 42001 | 24764 | 360 |
2394387 | 2394387 | 2022-04-10 | Adams | Pennsylvania | 42001 | 24762 | 360 |
2391131 | 2391131 | 2022-04-09 | Adams | Pennsylvania | 42001 | 24757 | 360 |
2387875 | 2387875 | 2022-04-08 | Adams | Pennsylvania | 42001 | 24743 | 360 |
2384620 | 2384620 | 2022-04-07 | Adams | Pennsylvania | 42001 | 24735 | 360 |
2381365 | 2381365 | 2022-04-06 | Adams | Pennsylvania | 42001 | 24730 | 360 |
2378110 | 2378110 | 2022-04-05 | Adams | Pennsylvania | 42001 | 24712 | 360 |
2374856 | 2374856 | 2022-04-04 | Adams | Pennsylvania | 42001 | 24709 | 359 |
2371604 | 2371604 | 2022-04-03 | Adams | Pennsylvania | 42001 | 24695 | 358 |
2368351 | 2368351 | 2022-04-02 | Adams | Pennsylvania | 42001 | 24695 | 358 |
2365098 | 2365098 | 2022-04-01 | Adams | Pennsylvania | 42001 | 24693 | 358 |
2361845 | 2361845 | 2022-03-31 | Adams | Pennsylvania | 42001 | 24688 | 358 |
2358591 | 2358591 | 2022-03-30 | Adams | Pennsylvania | 42001 | 24677 | 358 |
2355337 | 2355337 | 2022-03-29 | Adams | Pennsylvania | 42001 | 24672 | 358 |
2352084 | 2352084 | 2022-03-28 | Adams | Pennsylvania | 42001 | 24670 | 358 |
2348832 | 2348832 | 2022-03-27 | Adams | Pennsylvania | 42001 | 24670 | 358 |
2345579 | 2345579 | 2022-03-26 | Adams | Pennsylvania | 42001 | 24670 | 358 |
2342326 | 2342326 | 2022-03-25 | Adams | Pennsylvania | 42001 | 24664 | 358 |
2339073 | 2339073 | 2022-03-24 | Adams | Pennsylvania | 42001 | 24661 | 358 |
2335819 | 2335819 | 2022-03-23 | Adams | Pennsylvania | 42001 | 24659 | 358 |
2332565 | 2332565 | 2022-03-22 | Adams | Pennsylvania | 42001 | 24659 | 358 |
2329312 | 2329312 | 2022-03-21 | Adams | Pennsylvania | 42001 | 24655 | 358 |
2326060 | 2326060 | 2022-03-20 | Adams | Pennsylvania | 42001 | 24654 | 358 |
2322807 | 2322807 | 2022-03-19 | Adams | Pennsylvania | 42001 | 24652 | 357 |
2319553 | 2319553 | 2022-03-18 | Adams | Pennsylvania | 42001 | 24649 | 357 |
2316299 | 2316299 | 2022-03-17 | Adams | Pennsylvania | 42001 | 24645 | 357 |
2313046 | 2313046 | 2022-03-16 | Adams | Pennsylvania | 42001 | 24638 | 357 |
2309793 | 2309793 | 2022-03-15 | Adams | Pennsylvania | 42001 | 24629 | 357 |
2306540 | 2306540 | 2022-03-14 | Adams | Pennsylvania | 42001 | 24625 | 356 |
2303289 | 2303289 | 2022-03-13 | Adams | Pennsylvania | 42001 | 24622 | 356 |
2300037 | 2300037 | 2022-03-12 | Adams | Pennsylvania | 42001 | 24621 | 356 |
2296785 | 2296785 | 2022-03-11 | Adams | Pennsylvania | 42001 | 24615 | 355 |
2293533 | 2293533 | 2022-03-10 | Adams | Pennsylvania | 42001 | 24614 | 354 |
2290281 | 2290281 | 2022-03-09 | Adams | Pennsylvania | 42001 | 24614 | 354 |
2287029 | 2287029 | 2022-03-08 | Adams | Pennsylvania | 42001 | 24612 | 354 |
2283777 | 2283777 | 2022-03-07 | Adams | Pennsylvania | 42001 | 24609 | 354 |
2280525 | 2280525 | 2022-03-06 | Adams | Pennsylvania | 42001 | 24606 | 354 |
2277272 | 2277272 | 2022-03-05 | Adams | Pennsylvania | 42001 | 24604 | 354 |
2274019 | 2274019 | 2022-03-04 | Adams | Pennsylvania | 42001 | 24597 | 354 |
2270766 | 2270766 | 2022-03-03 | Adams | Pennsylvania | 42001 | 24592 | 353 |
2267514 | 2267514 | 2022-03-02 | Adams | Pennsylvania | 42001 | 24578 | 353 |
2264261 | 2264261 | 2022-03-01 | Adams | Pennsylvania | 42001 | 24572 | 351 |
2261011 | 2261011 | 2022-02-28 | Adams | Pennsylvania | 42001 | 24574 | 349 |
2257760 | 2257760 | 2022-02-27 | Adams | Pennsylvania | 42001 | 24570 | 349 |
2254509 | 2254509 | 2022-02-26 | Adams | Pennsylvania | 42001 | 24562 | 349 |
2251258 | 2251258 | 2022-02-25 | Adams | Pennsylvania | 42001 | 24462 | 349 |
2248007 | 2248007 | 2022-02-24 | Adams | Pennsylvania | 42001 | 24452 | 349 |
2244756 | 2244756 | 2022-02-23 | Adams | Pennsylvania | 42001 | 24434 | 347 |
2241505 | 2241505 | 2022-02-22 | Adams | Pennsylvania | 42001 | 24430 | 347 |
2238254 | 2238254 | 2022-02-21 | Adams | Pennsylvania | 42001 | 24414 | 347 |
2235003 | 2235003 | 2022-02-20 | Adams | Pennsylvania | 42001 | 24414 | 347 |
2231752 | 2231752 | 2022-02-19 | Adams | Pennsylvania | 42001 | 24397 | 347 |
2228501 | 2228501 | 2022-02-18 | Adams | Pennsylvania | 42001 | 24365 | 347 |
2225250 | 2225250 | 2022-02-17 | Adams | Pennsylvania | 42001 | 24343 | 345 |
2221999 | 2221999 | 2022-02-16 | Adams | Pennsylvania | 42001 | 24308 | 345 |
2218748 | 2218748 | 2022-02-15 | Adams | Pennsylvania | 42001 | 24294 | 344 |
2215497 | 2215497 | 2022-02-14 | Adams | Pennsylvania | 42001 | 24277 | 344 |
2212246 | 2212246 | 2022-02-13 | Adams | Pennsylvania | 42001 | 24261 | 344 |
2208993 | 2208993 | 2022-02-12 | Adams | Pennsylvania | 42001 | 24236 | 344 |
2205740 | 2205740 | 2022-02-11 | Adams | Pennsylvania | 42001 | 24200 | 343 |
2202487 | 2202487 | 2022-02-10 | Adams | Pennsylvania | 42001 | 24167 | 343 |
2199233 | 2199233 | 2022-02-09 | Adams | Pennsylvania | 42001 | 24122 | 343 |
2195979 | 2195979 | 2022-02-08 | Adams | Pennsylvania | 42001 | 24090 | 342 |
2192725 | 2192725 | 2022-02-07 | Adams | Pennsylvania | 42001 | 24093 | 339 |
2189471 | 2189471 | 2022-02-06 | Adams | Pennsylvania | 42001 | 24052 | 338 |
2186218 | 2186218 | 2022-02-05 | Adams | Pennsylvania | 42001 | 24005 | 337 |
2182966 | 2182966 | 2022-02-04 | Adams | Pennsylvania | 42001 | 23923 | 335 |
2179714 | 2179714 | 2022-02-03 | Adams | Pennsylvania | 42001 | 23880 | 333 |
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);