ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Warren" and fips = 42123 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637207 | 637207 | 2020-10-16 | Warren | Pennsylvania | 42123 | 59 | 1 |
633961 | 633961 | 2020-10-15 | Warren | Pennsylvania | 42123 | 58 | 1 |
630716 | 630716 | 2020-10-14 | Warren | Pennsylvania | 42123 | 58 | 1 |
627472 | 627472 | 2020-10-13 | Warren | Pennsylvania | 42123 | 57 | 1 |
624230 | 624230 | 2020-10-12 | Warren | Pennsylvania | 42123 | 56 | 1 |
620987 | 620987 | 2020-10-11 | Warren | Pennsylvania | 42123 | 56 | 1 |
617744 | 617744 | 2020-10-10 | Warren | Pennsylvania | 42123 | 52 | 1 |
614502 | 614502 | 2020-10-09 | Warren | Pennsylvania | 42123 | 50 | 1 |
611261 | 611261 | 2020-10-08 | Warren | Pennsylvania | 42123 | 46 | 1 |
608019 | 608019 | 2020-10-07 | Warren | Pennsylvania | 42123 | 46 | 1 |
604776 | 604776 | 2020-10-06 | Warren | Pennsylvania | 42123 | 46 | 1 |
601534 | 601534 | 2020-10-05 | Warren | Pennsylvania | 42123 | 45 | 1 |
598291 | 598291 | 2020-10-04 | Warren | Pennsylvania | 42123 | 45 | 1 |
595048 | 595048 | 2020-10-03 | Warren | Pennsylvania | 42123 | 44 | 1 |
591807 | 591807 | 2020-10-02 | Warren | Pennsylvania | 42123 | 44 | 1 |
588566 | 588566 | 2020-10-01 | Warren | Pennsylvania | 42123 | 44 | 1 |
585326 | 585326 | 2020-09-30 | Warren | Pennsylvania | 42123 | 44 | 1 |
582086 | 582086 | 2020-09-29 | Warren | Pennsylvania | 42123 | 44 | 1 |
578846 | 578846 | 2020-09-28 | Warren | Pennsylvania | 42123 | 43 | 1 |
575605 | 575605 | 2020-09-27 | Warren | Pennsylvania | 42123 | 43 | 1 |
572361 | 572361 | 2020-09-26 | Warren | Pennsylvania | 42123 | 43 | 1 |
569119 | 569119 | 2020-09-25 | Warren | Pennsylvania | 42123 | 42 | 1 |
565878 | 565878 | 2020-09-24 | Warren | Pennsylvania | 42123 | 42 | 1 |
562637 | 562637 | 2020-09-23 | Warren | Pennsylvania | 42123 | 42 | 1 |
559400 | 559400 | 2020-09-22 | Warren | Pennsylvania | 42123 | 42 | 1 |
556163 | 556163 | 2020-09-21 | Warren | Pennsylvania | 42123 | 42 | 1 |
552926 | 552926 | 2020-09-20 | Warren | Pennsylvania | 42123 | 42 | 1 |
549687 | 549687 | 2020-09-19 | Warren | Pennsylvania | 42123 | 42 | 1 |
546448 | 546448 | 2020-09-18 | Warren | Pennsylvania | 42123 | 42 | 1 |
543211 | 543211 | 2020-09-17 | Warren | Pennsylvania | 42123 | 42 | 1 |
539975 | 539975 | 2020-09-16 | Warren | Pennsylvania | 42123 | 42 | 1 |
536738 | 536738 | 2020-09-15 | Warren | Pennsylvania | 42123 | 43 | 1 |
533502 | 533502 | 2020-09-14 | Warren | Pennsylvania | 42123 | 41 | 1 |
530267 | 530267 | 2020-09-13 | Warren | Pennsylvania | 42123 | 40 | 1 |
527030 | 527030 | 2020-09-12 | Warren | Pennsylvania | 42123 | 40 | 1 |
523794 | 523794 | 2020-09-11 | Warren | Pennsylvania | 42123 | 40 | 1 |
520558 | 520558 | 2020-09-10 | Warren | Pennsylvania | 42123 | 40 | 1 |
517322 | 517322 | 2020-09-09 | Warren | Pennsylvania | 42123 | 40 | 1 |
514087 | 514087 | 2020-09-08 | Warren | Pennsylvania | 42123 | 37 | 1 |
510854 | 510854 | 2020-09-07 | Warren | Pennsylvania | 42123 | 37 | 1 |
507621 | 507621 | 2020-09-06 | Warren | Pennsylvania | 42123 | 37 | 1 |
504389 | 504389 | 2020-09-05 | Warren | Pennsylvania | 42123 | 36 | 1 |
501155 | 501155 | 2020-09-04 | Warren | Pennsylvania | 42123 | 36 | 1 |
497921 | 497921 | 2020-09-03 | Warren | Pennsylvania | 42123 | 34 | 1 |
494688 | 494688 | 2020-09-02 | Warren | Pennsylvania | 42123 | 31 | 1 |
491454 | 491454 | 2020-09-01 | Warren | Pennsylvania | 42123 | 28 | 1 |
488221 | 488221 | 2020-08-31 | Warren | Pennsylvania | 42123 | 27 | 1 |
484988 | 484988 | 2020-08-30 | Warren | Pennsylvania | 42123 | 27 | 1 |
481753 | 481753 | 2020-08-29 | Warren | Pennsylvania | 42123 | 27 | 1 |
478519 | 478519 | 2020-08-28 | Warren | Pennsylvania | 42123 | 27 | 1 |
475286 | 475286 | 2020-08-27 | Warren | Pennsylvania | 42123 | 26 | 1 |
472052 | 472052 | 2020-08-26 | Warren | Pennsylvania | 42123 | 26 | 1 |
468820 | 468820 | 2020-08-25 | Warren | Pennsylvania | 42123 | 26 | 1 |
465592 | 465592 | 2020-08-24 | Warren | Pennsylvania | 42123 | 26 | 1 |
462363 | 462363 | 2020-08-23 | Warren | Pennsylvania | 42123 | 26 | 1 |
459135 | 459135 | 2020-08-22 | Warren | Pennsylvania | 42123 | 25 | 1 |
455907 | 455907 | 2020-08-21 | Warren | Pennsylvania | 42123 | 26 | 1 |
452679 | 452679 | 2020-08-20 | Warren | Pennsylvania | 42123 | 23 | 1 |
449451 | 449451 | 2020-08-19 | Warren | Pennsylvania | 42123 | 23 | 1 |
446223 | 446223 | 2020-08-18 | Warren | Pennsylvania | 42123 | 23 | 1 |
442997 | 442997 | 2020-08-17 | Warren | Pennsylvania | 42123 | 23 | 1 |
439770 | 439770 | 2020-08-16 | Warren | Pennsylvania | 42123 | 23 | 1 |
436545 | 436545 | 2020-08-15 | Warren | Pennsylvania | 42123 | 23 | 1 |
433318 | 433318 | 2020-08-14 | Warren | Pennsylvania | 42123 | 22 | 1 |
430092 | 430092 | 2020-08-13 | Warren | Pennsylvania | 42123 | 22 | 1 |
426867 | 426867 | 2020-08-12 | Warren | Pennsylvania | 42123 | 23 | 1 |
423644 | 423644 | 2020-08-11 | Warren | Pennsylvania | 42123 | 23 | 1 |
420421 | 420421 | 2020-08-10 | Warren | Pennsylvania | 42123 | 23 | 1 |
417201 | 417201 | 2020-08-09 | Warren | Pennsylvania | 42123 | 23 | 1 |
413980 | 413980 | 2020-08-08 | Warren | Pennsylvania | 42123 | 23 | 1 |
410760 | 410760 | 2020-08-07 | Warren | Pennsylvania | 42123 | 22 | 1 |
407540 | 407540 | 2020-08-06 | Warren | Pennsylvania | 42123 | 20 | 1 |
404321 | 404321 | 2020-08-05 | Warren | Pennsylvania | 42123 | 20 | 1 |
401103 | 401103 | 2020-08-04 | Warren | Pennsylvania | 42123 | 20 | 1 |
397888 | 397888 | 2020-08-03 | Warren | Pennsylvania | 42123 | 19 | 1 |
394671 | 394671 | 2020-08-02 | Warren | Pennsylvania | 42123 | 18 | 1 |
391455 | 391455 | 2020-08-01 | Warren | Pennsylvania | 42123 | 16 | 1 |
388238 | 388238 | 2020-07-31 | Warren | Pennsylvania | 42123 | 15 | 1 |
385021 | 385021 | 2020-07-30 | Warren | Pennsylvania | 42123 | 15 | 1 |
381803 | 381803 | 2020-07-29 | Warren | Pennsylvania | 42123 | 15 | 1 |
378586 | 378586 | 2020-07-28 | Warren | Pennsylvania | 42123 | 14 | 1 |
375370 | 375370 | 2020-07-27 | Warren | Pennsylvania | 42123 | 14 | 1 |
372157 | 372157 | 2020-07-26 | Warren | Pennsylvania | 42123 | 14 | 1 |
368945 | 368945 | 2020-07-25 | Warren | Pennsylvania | 42123 | 14 | 1 |
365736 | 365736 | 2020-07-24 | Warren | Pennsylvania | 42123 | 14 | 1 |
362530 | 362530 | 2020-07-23 | Warren | Pennsylvania | 42123 | 14 | 1 |
359324 | 359324 | 2020-07-22 | Warren | Pennsylvania | 42123 | 14 | 1 |
356120 | 356120 | 2020-07-21 | Warren | Pennsylvania | 42123 | 14 | 1 |
352917 | 352917 | 2020-07-20 | Warren | Pennsylvania | 42123 | 13 | 1 |
349714 | 349714 | 2020-07-19 | Warren | Pennsylvania | 42123 | 13 | 1 |
346514 | 346514 | 2020-07-18 | Warren | Pennsylvania | 42123 | 12 | 1 |
343314 | 343314 | 2020-07-17 | Warren | Pennsylvania | 42123 | 11 | 1 |
340116 | 340116 | 2020-07-16 | Warren | Pennsylvania | 42123 | 11 | 1 |
336919 | 336919 | 2020-07-15 | Warren | Pennsylvania | 42123 | 11 | 1 |
333725 | 333725 | 2020-07-14 | Warren | Pennsylvania | 42123 | 10 | 1 |
330533 | 330533 | 2020-07-13 | Warren | Pennsylvania | 42123 | 10 | 1 |
327347 | 327347 | 2020-07-12 | Warren | Pennsylvania | 42123 | 10 | 1 |
324162 | 324162 | 2020-07-11 | Warren | Pennsylvania | 42123 | 9 | 1 |
320982 | 320982 | 2020-07-10 | Warren | Pennsylvania | 42123 | 9 | 1 |
317804 | 317804 | 2020-07-09 | Warren | Pennsylvania | 42123 | 7 | 1 |
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);