ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Lancaster" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388212 | 388212 | 2020-07-31 | Lancaster | Pennsylvania | 42071 | 5525 | 406 |
384995 | 384995 | 2020-07-30 | Lancaster | Pennsylvania | 42071 | 5488 | 406 |
381777 | 381777 | 2020-07-29 | Lancaster | Pennsylvania | 42071 | 5414 | 405 |
378560 | 378560 | 2020-07-28 | Lancaster | Pennsylvania | 42071 | 5376 | 403 |
375344 | 375344 | 2020-07-27 | Lancaster | Pennsylvania | 42071 | 5328 | 401 |
372131 | 372131 | 2020-07-26 | Lancaster | Pennsylvania | 42071 | 5311 | 401 |
368919 | 368919 | 2020-07-25 | Lancaster | Pennsylvania | 42071 | 5263 | 401 |
365710 | 365710 | 2020-07-24 | Lancaster | Pennsylvania | 42071 | 5228 | 400 |
362504 | 362504 | 2020-07-23 | Lancaster | Pennsylvania | 42071 | 5190 | 395 |
359298 | 359298 | 2020-07-22 | Lancaster | Pennsylvania | 42071 | 5158 | 393 |
356094 | 356094 | 2020-07-21 | Lancaster | Pennsylvania | 42071 | 5122 | 392 |
352891 | 352891 | 2020-07-20 | Lancaster | Pennsylvania | 42071 | 5084 | 392 |
349688 | 349688 | 2020-07-19 | Lancaster | Pennsylvania | 42071 | 5052 | 392 |
346488 | 346488 | 2020-07-18 | Lancaster | Pennsylvania | 42071 | 5019 | 392 |
343288 | 343288 | 2020-07-17 | Lancaster | Pennsylvania | 42071 | 4988 | 390 |
340090 | 340090 | 2020-07-16 | Lancaster | Pennsylvania | 42071 | 4951 | 388 |
336893 | 336893 | 2020-07-15 | Lancaster | Pennsylvania | 42071 | 4906 | 388 |
333699 | 333699 | 2020-07-14 | Lancaster | Pennsylvania | 42071 | 4876 | 386 |
330507 | 330507 | 2020-07-13 | Lancaster | Pennsylvania | 42071 | 4851 | 383 |
327321 | 327321 | 2020-07-12 | Lancaster | Pennsylvania | 42071 | 4844 | 383 |
324136 | 324136 | 2020-07-11 | Lancaster | Pennsylvania | 42071 | 4816 | 383 |
320956 | 320956 | 2020-07-10 | Lancaster | Pennsylvania | 42071 | 4783 | 382 |
317778 | 317778 | 2020-07-09 | Lancaster | Pennsylvania | 42071 | 4711 | 377 |
314605 | 314605 | 2020-07-08 | Lancaster | Pennsylvania | 42071 | 4673 | 372 |
311433 | 311433 | 2020-07-07 | Lancaster | Pennsylvania | 42071 | 4623 | 372 |
308264 | 308264 | 2020-07-06 | Lancaster | Pennsylvania | 42071 | 4602 | 367 |
305097 | 305097 | 2020-07-05 | Lancaster | Pennsylvania | 42071 | 4589 | 367 |
301934 | 301934 | 2020-07-04 | Lancaster | Pennsylvania | 42071 | 4572 | 366 |
298770 | 298770 | 2020-07-03 | Lancaster | Pennsylvania | 42071 | 4530 | 365 |
295611 | 295611 | 2020-07-02 | Lancaster | Pennsylvania | 42071 | 4504 | 365 |
292455 | 292455 | 2020-07-01 | Lancaster | Pennsylvania | 42071 | 4464 | 357 |
289303 | 289303 | 2020-06-30 | Lancaster | Pennsylvania | 42071 | 4442 | 357 |
286152 | 286152 | 2020-06-29 | Lancaster | Pennsylvania | 42071 | 4414 | 356 |
283007 | 283007 | 2020-06-28 | Lancaster | Pennsylvania | 42071 | 4388 | 356 |
279861 | 279861 | 2020-06-27 | Lancaster | Pennsylvania | 42071 | 4326 | 355 |
276713 | 276713 | 2020-06-26 | Lancaster | Pennsylvania | 42071 | 4280 | 354 |
273566 | 273566 | 2020-06-25 | Lancaster | Pennsylvania | 42071 | 4212 | 354 |
270427 | 270427 | 2020-06-24 | Lancaster | Pennsylvania | 42071 | 4152 | 352 |
267293 | 267293 | 2020-06-23 | Lancaster | Pennsylvania | 42071 | 4106 | 350 |
264165 | 264165 | 2020-06-22 | Lancaster | Pennsylvania | 42071 | 4029 | 347 |
261037 | 261037 | 2020-06-21 | Lancaster | Pennsylvania | 42071 | 3999 | 346 |
257910 | 257910 | 2020-06-20 | Lancaster | Pennsylvania | 42071 | 3949 | 346 |
254784 | 254784 | 2020-06-19 | Lancaster | Pennsylvania | 42071 | 3911 | 344 |
251669 | 251669 | 2020-06-18 | Lancaster | Pennsylvania | 42071 | 3867 | 341 |
248554 | 248554 | 2020-06-17 | Lancaster | Pennsylvania | 42071 | 3830 | 336 |
245441 | 245441 | 2020-06-16 | Lancaster | Pennsylvania | 42071 | 3802 | 333 |
242329 | 242329 | 2020-06-15 | Lancaster | Pennsylvania | 42071 | 3777 | 331 |
239220 | 239220 | 2020-06-14 | Lancaster | Pennsylvania | 42071 | 3752 | 329 |
236112 | 236112 | 2020-06-13 | Lancaster | Pennsylvania | 42071 | 3719 | 329 |
233007 | 233007 | 2020-06-12 | Lancaster | Pennsylvania | 42071 | 3682 | 325 |
229902 | 229902 | 2020-06-11 | Lancaster | Pennsylvania | 42071 | 3632 | 322 |
226798 | 226798 | 2020-06-10 | Lancaster | Pennsylvania | 42071 | 3600 | 322 |
223698 | 223698 | 2020-06-09 | Lancaster | Pennsylvania | 42071 | 3554 | 320 |
220603 | 220603 | 2020-06-08 | Lancaster | Pennsylvania | 42071 | 3503 | 318 |
217511 | 217511 | 2020-06-07 | Lancaster | Pennsylvania | 42071 | 3461 | 318 |
214421 | 214421 | 2020-06-06 | Lancaster | Pennsylvania | 42071 | 3404 | 317 |
211335 | 211335 | 2020-06-05 | Lancaster | Pennsylvania | 42071 | 3337 | 317 |
208253 | 208253 | 2020-06-04 | Lancaster | Pennsylvania | 42071 | 3301 | 315 |
205172 | 205172 | 2020-06-03 | Lancaster | Pennsylvania | 42071 | 3267 | 310 |
202095 | 202095 | 2020-06-02 | Lancaster | Pennsylvania | 42071 | 3218 | 306 |
199020 | 199020 | 2020-06-01 | Lancaster | Pennsylvania | 42071 | 3189 | 297 |
195947 | 195947 | 2020-05-31 | Lancaster | Pennsylvania | 42071 | 3161 | 297 |
192878 | 192878 | 2020-05-30 | Lancaster | Pennsylvania | 42071 | 3131 | 295 |
189813 | 189813 | 2020-05-29 | Lancaster | Pennsylvania | 42071 | 3105 | 292 |
186752 | 186752 | 2020-05-28 | Lancaster | Pennsylvania | 42071 | 3056 | 291 |
183695 | 183695 | 2020-05-27 | Lancaster | Pennsylvania | 42071 | 3031 | 285 |
180645 | 180645 | 2020-05-26 | Lancaster | Pennsylvania | 42071 | 2985 | 283 |
177602 | 177602 | 2020-05-25 | Lancaster | Pennsylvania | 42071 | 2896 | 281 |
174558 | 174558 | 2020-05-24 | Lancaster | Pennsylvania | 42071 | 2854 | 281 |
171516 | 171516 | 2020-05-23 | Lancaster | Pennsylvania | 42071 | 2790 | 280 |
168477 | 168477 | 2020-05-22 | Lancaster | Pennsylvania | 42071 | 2736 | 278 |
165441 | 165441 | 2020-05-21 | Lancaster | Pennsylvania | 42071 | 2690 | 277 |
162412 | 162412 | 2020-05-20 | Lancaster | Pennsylvania | 42071 | 2599 | 271 |
159385 | 159385 | 2020-05-19 | Lancaster | Pennsylvania | 42071 | 2593 | 267 |
156364 | 156364 | 2020-05-18 | Lancaster | Pennsylvania | 42071 | 2552 | 263 |
153347 | 153347 | 2020-05-17 | Lancaster | Pennsylvania | 42071 | 2508 | 258 |
150336 | 150336 | 2020-05-16 | Lancaster | Pennsylvania | 42071 | 2470 | 255 |
147329 | 147329 | 2020-05-15 | Lancaster | Pennsylvania | 42071 | 2428 | 253 |
144328 | 144328 | 2020-05-14 | Lancaster | Pennsylvania | 42071 | 2364 | 249 |
141332 | 141332 | 2020-05-13 | Lancaster | Pennsylvania | 42071 | 2325 | 245 |
138336 | 138336 | 2020-05-12 | Lancaster | Pennsylvania | 42071 | 2295 | 241 |
135346 | 135346 | 2020-05-11 | Lancaster | Pennsylvania | 42071 | 2256 | 239 |
132355 | 132355 | 2020-05-10 | Lancaster | Pennsylvania | 42071 | 2223 | 233 |
129366 | 129366 | 2020-05-09 | Lancaster | Pennsylvania | 42071 | 2185 | 228 |
126377 | 126377 | 2020-05-08 | Lancaster | Pennsylvania | 42071 | 2122 | 222 |
123394 | 123394 | 2020-05-07 | Lancaster | Pennsylvania | 42071 | 2070 | 216 |
120417 | 120417 | 2020-05-06 | Lancaster | Pennsylvania | 42071 | 2041 | 209 |
117455 | 117455 | 2020-05-05 | Lancaster | Pennsylvania | 42071 | 2018 | 206 |
114574 | 114574 | 2020-05-04 | Lancaster | Pennsylvania | 42071 | 1991 | 198 |
111692 | 111692 | 2020-05-03 | Lancaster | Pennsylvania | 42071 | 1936 | 191 |
108818 | 108818 | 2020-05-02 | Lancaster | Pennsylvania | 42071 | 1904 | 188 |
105951 | 105951 | 2020-05-01 | Lancaster | Pennsylvania | 42071 | 1820 | 183 |
103088 | 103088 | 2020-04-30 | Lancaster | Pennsylvania | 42071 | 1765 | 173 |
100235 | 100235 | 2020-04-29 | Lancaster | Pennsylvania | 42071 | 1703 | 170 |
97386 | 97386 | 2020-04-28 | Lancaster | Pennsylvania | 42071 | 1678 | 164 |
94547 | 94547 | 2020-04-27 | Lancaster | Pennsylvania | 42071 | 1633 | 152 |
91720 | 91720 | 2020-04-26 | Lancaster | Pennsylvania | 42071 | 1577 | 145 |
88904 | 88904 | 2020-04-25 | Lancaster | Pennsylvania | 42071 | 1501 | 140 |
86090 | 86090 | 2020-04-24 | Lancaster | Pennsylvania | 42071 | 1451 | 139 |
83286 | 83286 | 2020-04-23 | Lancaster | Pennsylvania | 42071 | 1359 | 131 |
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);