ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Fayette" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536702 | 536702 | 2020-09-15 | Fayette | Pennsylvania | 42051 | 750 | 7 |
533466 | 533466 | 2020-09-14 | Fayette | Pennsylvania | 42051 | 747 | 7 |
530231 | 530231 | 2020-09-13 | Fayette | Pennsylvania | 42051 | 740 | 7 |
526994 | 526994 | 2020-09-12 | Fayette | Pennsylvania | 42051 | 740 | 7 |
523758 | 523758 | 2020-09-11 | Fayette | Pennsylvania | 42051 | 733 | 7 |
520522 | 520522 | 2020-09-10 | Fayette | Pennsylvania | 42051 | 728 | 7 |
517286 | 517286 | 2020-09-09 | Fayette | Pennsylvania | 42051 | 722 | 7 |
514051 | 514051 | 2020-09-08 | Fayette | Pennsylvania | 42051 | 714 | 6 |
510818 | 510818 | 2020-09-07 | Fayette | Pennsylvania | 42051 | 715 | 6 |
507585 | 507585 | 2020-09-06 | Fayette | Pennsylvania | 42051 | 711 | 6 |
504353 | 504353 | 2020-09-05 | Fayette | Pennsylvania | 42051 | 708 | 6 |
501119 | 501119 | 2020-09-04 | Fayette | Pennsylvania | 42051 | 705 | 6 |
497885 | 497885 | 2020-09-03 | Fayette | Pennsylvania | 42051 | 703 | 6 |
494652 | 494652 | 2020-09-02 | Fayette | Pennsylvania | 42051 | 699 | 6 |
491418 | 491418 | 2020-09-01 | Fayette | Pennsylvania | 42051 | 694 | 6 |
488185 | 488185 | 2020-08-31 | Fayette | Pennsylvania | 42051 | 692 | 6 |
484952 | 484952 | 2020-08-30 | Fayette | Pennsylvania | 42051 | 689 | 6 |
481717 | 481717 | 2020-08-29 | Fayette | Pennsylvania | 42051 | 683 | 6 |
478483 | 478483 | 2020-08-28 | Fayette | Pennsylvania | 42051 | 681 | 6 |
475250 | 475250 | 2020-08-27 | Fayette | Pennsylvania | 42051 | 674 | 6 |
472016 | 472016 | 2020-08-26 | Fayette | Pennsylvania | 42051 | 665 | 6 |
468784 | 468784 | 2020-08-25 | Fayette | Pennsylvania | 42051 | 663 | 6 |
465556 | 465556 | 2020-08-24 | Fayette | Pennsylvania | 42051 | 661 | 6 |
462327 | 462327 | 2020-08-23 | Fayette | Pennsylvania | 42051 | 658 | 6 |
459099 | 459099 | 2020-08-22 | Fayette | Pennsylvania | 42051 | 656 | 6 |
455871 | 455871 | 2020-08-21 | Fayette | Pennsylvania | 42051 | 653 | 6 |
452643 | 452643 | 2020-08-20 | Fayette | Pennsylvania | 42051 | 644 | 6 |
449415 | 449415 | 2020-08-19 | Fayette | Pennsylvania | 42051 | 639 | 6 |
446187 | 446187 | 2020-08-18 | Fayette | Pennsylvania | 42051 | 631 | 6 |
442961 | 442961 | 2020-08-17 | Fayette | Pennsylvania | 42051 | 628 | 6 |
439734 | 439734 | 2020-08-16 | Fayette | Pennsylvania | 42051 | 624 | 6 |
436509 | 436509 | 2020-08-15 | Fayette | Pennsylvania | 42051 | 613 | 6 |
433282 | 433282 | 2020-08-14 | Fayette | Pennsylvania | 42051 | 609 | 6 |
430056 | 430056 | 2020-08-13 | Fayette | Pennsylvania | 42051 | 595 | 6 |
426831 | 426831 | 2020-08-12 | Fayette | Pennsylvania | 42051 | 582 | 6 |
423608 | 423608 | 2020-08-11 | Fayette | Pennsylvania | 42051 | 562 | 6 |
420385 | 420385 | 2020-08-10 | Fayette | Pennsylvania | 42051 | 501 | 5 |
417165 | 417165 | 2020-08-09 | Fayette | Pennsylvania | 42051 | 494 | 5 |
413944 | 413944 | 2020-08-08 | Fayette | Pennsylvania | 42051 | 485 | 5 |
410724 | 410724 | 2020-08-07 | Fayette | Pennsylvania | 42051 | 472 | 5 |
407504 | 407504 | 2020-08-06 | Fayette | Pennsylvania | 42051 | 465 | 5 |
404285 | 404285 | 2020-08-05 | Fayette | Pennsylvania | 42051 | 431 | 4 |
401067 | 401067 | 2020-08-04 | Fayette | Pennsylvania | 42051 | 423 | 4 |
397852 | 397852 | 2020-08-03 | Fayette | Pennsylvania | 42051 | 414 | 4 |
394635 | 394635 | 2020-08-02 | Fayette | Pennsylvania | 42051 | 408 | 4 |
391419 | 391419 | 2020-08-01 | Fayette | Pennsylvania | 42051 | 403 | 4 |
388202 | 388202 | 2020-07-31 | Fayette | Pennsylvania | 42051 | 387 | 4 |
384985 | 384985 | 2020-07-30 | Fayette | Pennsylvania | 42051 | 363 | 4 |
381767 | 381767 | 2020-07-29 | Fayette | Pennsylvania | 42051 | 352 | 4 |
378550 | 378550 | 2020-07-28 | Fayette | Pennsylvania | 42051 | 336 | 4 |
375334 | 375334 | 2020-07-27 | Fayette | Pennsylvania | 42051 | 314 | 4 |
372121 | 372121 | 2020-07-26 | Fayette | Pennsylvania | 42051 | 311 | 4 |
368909 | 368909 | 2020-07-25 | Fayette | Pennsylvania | 42051 | 307 | 4 |
365700 | 365700 | 2020-07-24 | Fayette | Pennsylvania | 42051 | 301 | 4 |
362494 | 362494 | 2020-07-23 | Fayette | Pennsylvania | 42051 | 294 | 4 |
359288 | 359288 | 2020-07-22 | Fayette | Pennsylvania | 42051 | 288 | 4 |
356084 | 356084 | 2020-07-21 | Fayette | Pennsylvania | 42051 | 279 | 4 |
352881 | 352881 | 2020-07-20 | Fayette | Pennsylvania | 42051 | 272 | 4 |
349678 | 349678 | 2020-07-19 | Fayette | Pennsylvania | 42051 | 262 | 4 |
346478 | 346478 | 2020-07-18 | Fayette | Pennsylvania | 42051 | 255 | 4 |
343278 | 343278 | 2020-07-17 | Fayette | Pennsylvania | 42051 | 235 | 4 |
340080 | 340080 | 2020-07-16 | Fayette | Pennsylvania | 42051 | 223 | 4 |
336883 | 336883 | 2020-07-15 | Fayette | Pennsylvania | 42051 | 220 | 4 |
333689 | 333689 | 2020-07-14 | Fayette | Pennsylvania | 42051 | 213 | 4 |
330497 | 330497 | 2020-07-13 | Fayette | Pennsylvania | 42051 | 202 | 4 |
327311 | 327311 | 2020-07-12 | Fayette | Pennsylvania | 42051 | 196 | 4 |
324126 | 324126 | 2020-07-11 | Fayette | Pennsylvania | 42051 | 194 | 4 |
320946 | 320946 | 2020-07-10 | Fayette | Pennsylvania | 42051 | 178 | 4 |
317768 | 317768 | 2020-07-09 | Fayette | Pennsylvania | 42051 | 163 | 4 |
314595 | 314595 | 2020-07-08 | Fayette | Pennsylvania | 42051 | 160 | 4 |
311423 | 311423 | 2020-07-07 | Fayette | Pennsylvania | 42051 | 149 | 4 |
308254 | 308254 | 2020-07-06 | Fayette | Pennsylvania | 42051 | 147 | 4 |
305087 | 305087 | 2020-07-05 | Fayette | Pennsylvania | 42051 | 140 | 4 |
301924 | 301924 | 2020-07-04 | Fayette | Pennsylvania | 42051 | 135 | 4 |
298760 | 298760 | 2020-07-03 | Fayette | Pennsylvania | 42051 | 132 | 4 |
295601 | 295601 | 2020-07-02 | Fayette | Pennsylvania | 42051 | 127 | 4 |
292445 | 292445 | 2020-07-01 | Fayette | Pennsylvania | 42051 | 117 | 4 |
289293 | 289293 | 2020-06-30 | Fayette | Pennsylvania | 42051 | 116 | 4 |
286142 | 286142 | 2020-06-29 | Fayette | Pennsylvania | 42051 | 112 | 4 |
282997 | 282997 | 2020-06-28 | Fayette | Pennsylvania | 42051 | 111 | 4 |
279851 | 279851 | 2020-06-27 | Fayette | Pennsylvania | 42051 | 110 | 4 |
276703 | 276703 | 2020-06-26 | Fayette | Pennsylvania | 42051 | 106 | 4 |
273556 | 273556 | 2020-06-25 | Fayette | Pennsylvania | 42051 | 104 | 4 |
270417 | 270417 | 2020-06-24 | Fayette | Pennsylvania | 42051 | 104 | 4 |
267283 | 267283 | 2020-06-23 | Fayette | Pennsylvania | 42051 | 104 | 4 |
264155 | 264155 | 2020-06-22 | Fayette | Pennsylvania | 42051 | 104 | 4 |
261027 | 261027 | 2020-06-21 | Fayette | Pennsylvania | 42051 | 104 | 4 |
257900 | 257900 | 2020-06-20 | Fayette | Pennsylvania | 42051 | 103 | 4 |
254774 | 254774 | 2020-06-19 | Fayette | Pennsylvania | 42051 | 103 | 4 |
251659 | 251659 | 2020-06-18 | Fayette | Pennsylvania | 42051 | 100 | 4 |
248544 | 248544 | 2020-06-17 | Fayette | Pennsylvania | 42051 | 98 | 4 |
245431 | 245431 | 2020-06-16 | Fayette | Pennsylvania | 42051 | 95 | 4 |
242319 | 242319 | 2020-06-15 | Fayette | Pennsylvania | 42051 | 95 | 4 |
239210 | 239210 | 2020-06-14 | Fayette | Pennsylvania | 42051 | 95 | 4 |
236102 | 236102 | 2020-06-13 | Fayette | Pennsylvania | 42051 | 95 | 4 |
232997 | 232997 | 2020-06-12 | Fayette | Pennsylvania | 42051 | 95 | 4 |
229892 | 229892 | 2020-06-11 | Fayette | Pennsylvania | 42051 | 96 | 4 |
226788 | 226788 | 2020-06-10 | Fayette | Pennsylvania | 42051 | 95 | 4 |
223688 | 223688 | 2020-06-09 | Fayette | Pennsylvania | 42051 | 95 | 4 |
220593 | 220593 | 2020-06-08 | Fayette | Pennsylvania | 42051 | 95 | 4 |
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);