ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 42103 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
257926 | 257926 | 2020-06-20 | Pike | Pennsylvania | 42103 | 487 | 20 |
261053 | 261053 | 2020-06-21 | Pike | Pennsylvania | 42103 | 489 | 20 |
264181 | 264181 | 2020-06-22 | Pike | Pennsylvania | 42103 | 489 | 20 |
267309 | 267309 | 2020-06-23 | Pike | Pennsylvania | 42103 | 489 | 20 |
270443 | 270443 | 2020-06-24 | Pike | Pennsylvania | 42103 | 489 | 20 |
273582 | 273582 | 2020-06-25 | Pike | Pennsylvania | 42103 | 489 | 20 |
276729 | 276729 | 2020-06-26 | Pike | Pennsylvania | 42103 | 489 | 20 |
279877 | 279877 | 2020-06-27 | Pike | Pennsylvania | 42103 | 492 | 20 |
283023 | 283023 | 2020-06-28 | Pike | Pennsylvania | 42103 | 493 | 20 |
286168 | 286168 | 2020-06-29 | Pike | Pennsylvania | 42103 | 494 | 20 |
289319 | 289319 | 2020-06-30 | Pike | Pennsylvania | 42103 | 496 | 20 |
292471 | 292471 | 2020-07-01 | Pike | Pennsylvania | 42103 | 496 | 20 |
295627 | 295627 | 2020-07-02 | Pike | Pennsylvania | 42103 | 498 | 20 |
298786 | 298786 | 2020-07-03 | Pike | Pennsylvania | 42103 | 500 | 21 |
301950 | 301950 | 2020-07-04 | Pike | Pennsylvania | 42103 | 502 | 21 |
305113 | 305113 | 2020-07-05 | Pike | Pennsylvania | 42103 | 503 | 21 |
308280 | 308280 | 2020-07-06 | Pike | Pennsylvania | 42103 | 503 | 21 |
311449 | 311449 | 2020-07-07 | Pike | Pennsylvania | 42103 | 504 | 21 |
314621 | 314621 | 2020-07-08 | Pike | Pennsylvania | 42103 | 504 | 21 |
317794 | 317794 | 2020-07-09 | Pike | Pennsylvania | 42103 | 504 | 21 |
320972 | 320972 | 2020-07-10 | Pike | Pennsylvania | 42103 | 504 | 21 |
324152 | 324152 | 2020-07-11 | Pike | Pennsylvania | 42103 | 504 | 21 |
327337 | 327337 | 2020-07-12 | Pike | Pennsylvania | 42103 | 504 | 21 |
330523 | 330523 | 2020-07-13 | Pike | Pennsylvania | 42103 | 505 | 21 |
333715 | 333715 | 2020-07-14 | Pike | Pennsylvania | 42103 | 507 | 21 |
336909 | 336909 | 2020-07-15 | Pike | Pennsylvania | 42103 | 508 | 21 |
340106 | 340106 | 2020-07-16 | Pike | Pennsylvania | 42103 | 509 | 21 |
343304 | 343304 | 2020-07-17 | Pike | Pennsylvania | 42103 | 509 | 21 |
346504 | 346504 | 2020-07-18 | Pike | Pennsylvania | 42103 | 511 | 21 |
349704 | 349704 | 2020-07-19 | Pike | Pennsylvania | 42103 | 513 | 21 |
352907 | 352907 | 2020-07-20 | Pike | Pennsylvania | 42103 | 514 | 21 |
356110 | 356110 | 2020-07-21 | Pike | Pennsylvania | 42103 | 515 | 21 |
359314 | 359314 | 2020-07-22 | Pike | Pennsylvania | 42103 | 517 | 21 |
362520 | 362520 | 2020-07-23 | Pike | Pennsylvania | 42103 | 517 | 21 |
365726 | 365726 | 2020-07-24 | Pike | Pennsylvania | 42103 | 519 | 21 |
368935 | 368935 | 2020-07-25 | Pike | Pennsylvania | 42103 | 521 | 21 |
372147 | 372147 | 2020-07-26 | Pike | Pennsylvania | 42103 | 523 | 21 |
375360 | 375360 | 2020-07-27 | Pike | Pennsylvania | 42103 | 523 | 21 |
378576 | 378576 | 2020-07-28 | Pike | Pennsylvania | 42103 | 524 | 21 |
381793 | 381793 | 2020-07-29 | Pike | Pennsylvania | 42103 | 524 | 21 |
385011 | 385011 | 2020-07-30 | Pike | Pennsylvania | 42103 | 524 | 21 |
388228 | 388228 | 2020-07-31 | Pike | Pennsylvania | 42103 | 524 | 21 |
391445 | 391445 | 2020-08-01 | Pike | Pennsylvania | 42103 | 524 | 21 |
394661 | 394661 | 2020-08-02 | Pike | Pennsylvania | 42103 | 525 | 21 |
397878 | 397878 | 2020-08-03 | Pike | Pennsylvania | 42103 | 526 | 21 |
401093 | 401093 | 2020-08-04 | Pike | Pennsylvania | 42103 | 526 | 21 |
404311 | 404311 | 2020-08-05 | Pike | Pennsylvania | 42103 | 526 | 21 |
407530 | 407530 | 2020-08-06 | Pike | Pennsylvania | 42103 | 526 | 21 |
410750 | 410750 | 2020-08-07 | Pike | Pennsylvania | 42103 | 526 | 21 |
413970 | 413970 | 2020-08-08 | Pike | Pennsylvania | 42103 | 526 | 21 |
417191 | 417191 | 2020-08-09 | Pike | Pennsylvania | 42103 | 526 | 21 |
420411 | 420411 | 2020-08-10 | Pike | Pennsylvania | 42103 | 526 | 21 |
423634 | 423634 | 2020-08-11 | Pike | Pennsylvania | 42103 | 526 | 21 |
426857 | 426857 | 2020-08-12 | Pike | Pennsylvania | 42103 | 526 | 21 |
430082 | 430082 | 2020-08-13 | Pike | Pennsylvania | 42103 | 527 | 21 |
433308 | 433308 | 2020-08-14 | Pike | Pennsylvania | 42103 | 527 | 21 |
436535 | 436535 | 2020-08-15 | Pike | Pennsylvania | 42103 | 527 | 21 |
439760 | 439760 | 2020-08-16 | Pike | Pennsylvania | 42103 | 528 | 21 |
442987 | 442987 | 2020-08-17 | Pike | Pennsylvania | 42103 | 528 | 21 |
446213 | 446213 | 2020-08-18 | Pike | Pennsylvania | 42103 | 528 | 21 |
449441 | 449441 | 2020-08-19 | Pike | Pennsylvania | 42103 | 529 | 21 |
452669 | 452669 | 2020-08-20 | Pike | Pennsylvania | 42103 | 531 | 21 |
455897 | 455897 | 2020-08-21 | Pike | Pennsylvania | 42103 | 532 | 21 |
459125 | 459125 | 2020-08-22 | Pike | Pennsylvania | 42103 | 533 | 21 |
462353 | 462353 | 2020-08-23 | Pike | Pennsylvania | 42103 | 533 | 21 |
465582 | 465582 | 2020-08-24 | Pike | Pennsylvania | 42103 | 535 | 21 |
468810 | 468810 | 2020-08-25 | Pike | Pennsylvania | 42103 | 535 | 21 |
472042 | 472042 | 2020-08-26 | Pike | Pennsylvania | 42103 | 536 | 21 |
475276 | 475276 | 2020-08-27 | Pike | Pennsylvania | 42103 | 537 | 21 |
478509 | 478509 | 2020-08-28 | Pike | Pennsylvania | 42103 | 539 | 21 |
481743 | 481743 | 2020-08-29 | Pike | Pennsylvania | 42103 | 542 | 21 |
484978 | 484978 | 2020-08-30 | Pike | Pennsylvania | 42103 | 542 | 21 |
488211 | 488211 | 2020-08-31 | Pike | Pennsylvania | 42103 | 542 | 21 |
491444 | 491444 | 2020-09-01 | Pike | Pennsylvania | 42103 | 543 | 21 |
494678 | 494678 | 2020-09-02 | Pike | Pennsylvania | 42103 | 544 | 21 |
497911 | 497911 | 2020-09-03 | Pike | Pennsylvania | 42103 | 543 | 21 |
501145 | 501145 | 2020-09-04 | Pike | Pennsylvania | 42103 | 543 | 21 |
504379 | 504379 | 2020-09-05 | Pike | Pennsylvania | 42103 | 544 | 21 |
507611 | 507611 | 2020-09-06 | Pike | Pennsylvania | 42103 | 546 | 21 |
510844 | 510844 | 2020-09-07 | Pike | Pennsylvania | 42103 | 547 | 21 |
514077 | 514077 | 2020-09-08 | Pike | Pennsylvania | 42103 | 547 | 21 |
517312 | 517312 | 2020-09-09 | Pike | Pennsylvania | 42103 | 548 | 21 |
520548 | 520548 | 2020-09-10 | Pike | Pennsylvania | 42103 | 549 | 21 |
523784 | 523784 | 2020-09-11 | Pike | Pennsylvania | 42103 | 553 | 21 |
527020 | 527020 | 2020-09-12 | Pike | Pennsylvania | 42103 | 554 | 21 |
530257 | 530257 | 2020-09-13 | Pike | Pennsylvania | 42103 | 554 | 21 |
533492 | 533492 | 2020-09-14 | Pike | Pennsylvania | 42103 | 555 | 21 |
536728 | 536728 | 2020-09-15 | Pike | Pennsylvania | 42103 | 557 | 21 |
539965 | 539965 | 2020-09-16 | Pike | Pennsylvania | 42103 | 559 | 21 |
543201 | 543201 | 2020-09-17 | Pike | Pennsylvania | 42103 | 561 | 21 |
546438 | 546438 | 2020-09-18 | Pike | Pennsylvania | 42103 | 564 | 21 |
549677 | 549677 | 2020-09-19 | Pike | Pennsylvania | 42103 | 565 | 21 |
552916 | 552916 | 2020-09-20 | Pike | Pennsylvania | 42103 | 566 | 22 |
556153 | 556153 | 2020-09-21 | Pike | Pennsylvania | 42103 | 566 | 22 |
559390 | 559390 | 2020-09-22 | Pike | Pennsylvania | 42103 | 570 | 22 |
562627 | 562627 | 2020-09-23 | Pike | Pennsylvania | 42103 | 571 | 22 |
565868 | 565868 | 2020-09-24 | Pike | Pennsylvania | 42103 | 572 | 22 |
569109 | 569109 | 2020-09-25 | Pike | Pennsylvania | 42103 | 572 | 22 |
572351 | 572351 | 2020-09-26 | Pike | Pennsylvania | 42103 | 574 | 22 |
575595 | 575595 | 2020-09-27 | Pike | Pennsylvania | 42103 | 577 | 22 |
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);