ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Franklin" and state = "Pennsylvania" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
282999 | 282999 | 2020-06-28 | Franklin | Pennsylvania | 42055 | 913 | 42 |
286144 | 286144 | 2020-06-29 | Franklin | Pennsylvania | 42055 | 915 | 42 |
289295 | 289295 | 2020-06-30 | Franklin | Pennsylvania | 42055 | 925 | 43 |
292447 | 292447 | 2020-07-01 | Franklin | Pennsylvania | 42055 | 940 | 43 |
295603 | 295603 | 2020-07-02 | Franklin | Pennsylvania | 42055 | 950 | 44 |
298762 | 298762 | 2020-07-03 | Franklin | Pennsylvania | 42055 | 954 | 44 |
301926 | 301926 | 2020-07-04 | Franklin | Pennsylvania | 42055 | 955 | 44 |
305089 | 305089 | 2020-07-05 | Franklin | Pennsylvania | 42055 | 956 | 44 |
308256 | 308256 | 2020-07-06 | Franklin | Pennsylvania | 42055 | 958 | 44 |
311425 | 311425 | 2020-07-07 | Franklin | Pennsylvania | 42055 | 970 | 44 |
314597 | 314597 | 2020-07-08 | Franklin | Pennsylvania | 42055 | 984 | 44 |
317770 | 317770 | 2020-07-09 | Franklin | Pennsylvania | 42055 | 989 | 46 |
320948 | 320948 | 2020-07-10 | Franklin | Pennsylvania | 42055 | 993 | 46 |
324128 | 324128 | 2020-07-11 | Franklin | Pennsylvania | 42055 | 997 | 46 |
327313 | 327313 | 2020-07-12 | Franklin | Pennsylvania | 42055 | 1003 | 46 |
330499 | 330499 | 2020-07-13 | Franklin | Pennsylvania | 42055 | 1006 | 46 |
333691 | 333691 | 2020-07-14 | Franklin | Pennsylvania | 42055 | 1016 | 46 |
336885 | 336885 | 2020-07-15 | Franklin | Pennsylvania | 42055 | 1019 | 46 |
340082 | 340082 | 2020-07-16 | Franklin | Pennsylvania | 42055 | 1033 | 46 |
343280 | 343280 | 2020-07-17 | Franklin | Pennsylvania | 42055 | 1043 | 46 |
346480 | 346480 | 2020-07-18 | Franklin | Pennsylvania | 42055 | 1052 | 46 |
349680 | 349680 | 2020-07-19 | Franklin | Pennsylvania | 42055 | 1061 | 46 |
352883 | 352883 | 2020-07-20 | Franklin | Pennsylvania | 42055 | 1074 | 46 |
356086 | 356086 | 2020-07-21 | Franklin | Pennsylvania | 42055 | 1096 | 46 |
359290 | 359290 | 2020-07-22 | Franklin | Pennsylvania | 42055 | 1109 | 46 |
362496 | 362496 | 2020-07-23 | Franklin | Pennsylvania | 42055 | 1146 | 46 |
365702 | 365702 | 2020-07-24 | Franklin | Pennsylvania | 42055 | 1176 | 46 |
368911 | 368911 | 2020-07-25 | Franklin | Pennsylvania | 42055 | 1186 | 46 |
372123 | 372123 | 2020-07-26 | Franklin | Pennsylvania | 42055 | 1191 | 46 |
375336 | 375336 | 2020-07-27 | Franklin | Pennsylvania | 42055 | 1201 | 46 |
378552 | 378552 | 2020-07-28 | Franklin | Pennsylvania | 42055 | 1223 | 46 |
381769 | 381769 | 2020-07-29 | Franklin | Pennsylvania | 42055 | 1231 | 46 |
384987 | 384987 | 2020-07-30 | Franklin | Pennsylvania | 42055 | 1259 | 46 |
388204 | 388204 | 2020-07-31 | Franklin | Pennsylvania | 42055 | 1268 | 46 |
391421 | 391421 | 2020-08-01 | Franklin | Pennsylvania | 42055 | 1276 | 46 |
394637 | 394637 | 2020-08-02 | Franklin | Pennsylvania | 42055 | 1281 | 46 |
397854 | 397854 | 2020-08-03 | Franklin | Pennsylvania | 42055 | 1284 | 46 |
401069 | 401069 | 2020-08-04 | Franklin | Pennsylvania | 42055 | 1294 | 46 |
404287 | 404287 | 2020-08-05 | Franklin | Pennsylvania | 42055 | 1305 | 46 |
407506 | 407506 | 2020-08-06 | Franklin | Pennsylvania | 42055 | 1323 | 46 |
410726 | 410726 | 2020-08-07 | Franklin | Pennsylvania | 42055 | 1328 | 46 |
413946 | 413946 | 2020-08-08 | Franklin | Pennsylvania | 42055 | 1343 | 46 |
417167 | 417167 | 2020-08-09 | Franklin | Pennsylvania | 42055 | 1350 | 46 |
420387 | 420387 | 2020-08-10 | Franklin | Pennsylvania | 42055 | 1368 | 46 |
423610 | 423610 | 2020-08-11 | Franklin | Pennsylvania | 42055 | 1375 | 46 |
426833 | 426833 | 2020-08-12 | Franklin | Pennsylvania | 42055 | 1385 | 46 |
430058 | 430058 | 2020-08-13 | Franklin | Pennsylvania | 42055 | 1393 | 46 |
433284 | 433284 | 2020-08-14 | Franklin | Pennsylvania | 42055 | 1407 | 46 |
436511 | 436511 | 2020-08-15 | Franklin | Pennsylvania | 42055 | 1415 | 46 |
439736 | 439736 | 2020-08-16 | Franklin | Pennsylvania | 42055 | 1416 | 46 |
442963 | 442963 | 2020-08-17 | Franklin | Pennsylvania | 42055 | 1417 | 46 |
446189 | 446189 | 2020-08-18 | Franklin | Pennsylvania | 42055 | 1427 | 46 |
449417 | 449417 | 2020-08-19 | Franklin | Pennsylvania | 42055 | 1432 | 46 |
452645 | 452645 | 2020-08-20 | Franklin | Pennsylvania | 42055 | 1439 | 46 |
455873 | 455873 | 2020-08-21 | Franklin | Pennsylvania | 42055 | 1448 | 46 |
459101 | 459101 | 2020-08-22 | Franklin | Pennsylvania | 42055 | 1457 | 46 |
462329 | 462329 | 2020-08-23 | Franklin | Pennsylvania | 42055 | 1469 | 46 |
465558 | 465558 | 2020-08-24 | Franklin | Pennsylvania | 42055 | 1472 | 46 |
468786 | 468786 | 2020-08-25 | Franklin | Pennsylvania | 42055 | 1483 | 46 |
472018 | 472018 | 2020-08-26 | Franklin | Pennsylvania | 42055 | 1488 | 46 |
475252 | 475252 | 2020-08-27 | Franklin | Pennsylvania | 42055 | 1493 | 46 |
478485 | 478485 | 2020-08-28 | Franklin | Pennsylvania | 42055 | 1499 | 46 |
481719 | 481719 | 2020-08-29 | Franklin | Pennsylvania | 42055 | 1504 | 46 |
484954 | 484954 | 2020-08-30 | Franklin | Pennsylvania | 42055 | 1508 | 46 |
488187 | 488187 | 2020-08-31 | Franklin | Pennsylvania | 42055 | 1514 | 46 |
491420 | 491420 | 2020-09-01 | Franklin | Pennsylvania | 42055 | 1525 | 47 |
494654 | 494654 | 2020-09-02 | Franklin | Pennsylvania | 42055 | 1540 | 47 |
497887 | 497887 | 2020-09-03 | Franklin | Pennsylvania | 42055 | 1550 | 47 |
501121 | 501121 | 2020-09-04 | Franklin | Pennsylvania | 42055 | 1559 | 47 |
504355 | 504355 | 2020-09-05 | Franklin | Pennsylvania | 42055 | 1572 | 47 |
507587 | 507587 | 2020-09-06 | Franklin | Pennsylvania | 42055 | 1572 | 47 |
510820 | 510820 | 2020-09-07 | Franklin | Pennsylvania | 42055 | 1576 | 47 |
514053 | 514053 | 2020-09-08 | Franklin | Pennsylvania | 42055 | 1583 | 47 |
517288 | 517288 | 2020-09-09 | Franklin | Pennsylvania | 42055 | 1616 | 48 |
520524 | 520524 | 2020-09-10 | Franklin | Pennsylvania | 42055 | 1620 | 49 |
523760 | 523760 | 2020-09-11 | Franklin | Pennsylvania | 42055 | 1633 | 49 |
526996 | 526996 | 2020-09-12 | Franklin | Pennsylvania | 42055 | 1642 | 49 |
530233 | 530233 | 2020-09-13 | Franklin | Pennsylvania | 42055 | 1642 | 49 |
533468 | 533468 | 2020-09-14 | Franklin | Pennsylvania | 42055 | 1658 | 49 |
536704 | 536704 | 2020-09-15 | Franklin | Pennsylvania | 42055 | 1677 | 49 |
539941 | 539941 | 2020-09-16 | Franklin | Pennsylvania | 42055 | 1679 | 49 |
543177 | 543177 | 2020-09-17 | Franklin | Pennsylvania | 42055 | 1691 | 49 |
546414 | 546414 | 2020-09-18 | Franklin | Pennsylvania | 42055 | 1701 | 49 |
549653 | 549653 | 2020-09-19 | Franklin | Pennsylvania | 42055 | 1710 | 49 |
552892 | 552892 | 2020-09-20 | Franklin | Pennsylvania | 42055 | 1714 | 49 |
556129 | 556129 | 2020-09-21 | Franklin | Pennsylvania | 42055 | 1719 | 50 |
559366 | 559366 | 2020-09-22 | Franklin | Pennsylvania | 42055 | 1738 | 50 |
562603 | 562603 | 2020-09-23 | Franklin | Pennsylvania | 42055 | 1747 | 50 |
565844 | 565844 | 2020-09-24 | Franklin | Pennsylvania | 42055 | 1749 | 50 |
569085 | 569085 | 2020-09-25 | Franklin | Pennsylvania | 42055 | 1757 | 50 |
572327 | 572327 | 2020-09-26 | Franklin | Pennsylvania | 42055 | 1763 | 50 |
575571 | 575571 | 2020-09-27 | Franklin | Pennsylvania | 42055 | 1774 | 50 |
578812 | 578812 | 2020-09-28 | Franklin | Pennsylvania | 42055 | 1777 | 50 |
582052 | 582052 | 2020-09-29 | Franklin | Pennsylvania | 42055 | 1790 | 50 |
585292 | 585292 | 2020-09-30 | Franklin | Pennsylvania | 42055 | 1795 | 50 |
588532 | 588532 | 2020-10-01 | Franklin | Pennsylvania | 42055 | 1798 | 51 |
591773 | 591773 | 2020-10-02 | Franklin | Pennsylvania | 42055 | 1807 | 51 |
595014 | 595014 | 2020-10-03 | Franklin | Pennsylvania | 42055 | 1807 | 51 |
598257 | 598257 | 2020-10-04 | Franklin | Pennsylvania | 42055 | 1835 | 51 |
601500 | 601500 | 2020-10-05 | Franklin | Pennsylvania | 42055 | 1835 | 52 |
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);