ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Montour" and state = "Pennsylvania" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
286163 | 286163 | 2020-06-29 | Montour | Pennsylvania | 42093 | 73 | 0 |
289314 | 289314 | 2020-06-30 | Montour | Pennsylvania | 42093 | 73 | 1 |
292466 | 292466 | 2020-07-01 | Montour | Pennsylvania | 42093 | 74 | 1 |
295622 | 295622 | 2020-07-02 | Montour | Pennsylvania | 42093 | 75 | 1 |
298781 | 298781 | 2020-07-03 | Montour | Pennsylvania | 42093 | 75 | 1 |
301945 | 301945 | 2020-07-04 | Montour | Pennsylvania | 42093 | 75 | 2 |
305108 | 305108 | 2020-07-05 | Montour | Pennsylvania | 42093 | 76 | 2 |
308275 | 308275 | 2020-07-06 | Montour | Pennsylvania | 42093 | 76 | 2 |
311444 | 311444 | 2020-07-07 | Montour | Pennsylvania | 42093 | 76 | 2 |
314616 | 314616 | 2020-07-08 | Montour | Pennsylvania | 42093 | 76 | 2 |
317789 | 317789 | 2020-07-09 | Montour | Pennsylvania | 42093 | 76 | 2 |
320967 | 320967 | 2020-07-10 | Montour | Pennsylvania | 42093 | 77 | 2 |
324147 | 324147 | 2020-07-11 | Montour | Pennsylvania | 42093 | 77 | 2 |
327332 | 327332 | 2020-07-12 | Montour | Pennsylvania | 42093 | 79 | 2 |
330518 | 330518 | 2020-07-13 | Montour | Pennsylvania | 42093 | 79 | 2 |
333710 | 333710 | 2020-07-14 | Montour | Pennsylvania | 42093 | 80 | 2 |
336904 | 336904 | 2020-07-15 | Montour | Pennsylvania | 42093 | 81 | 2 |
340101 | 340101 | 2020-07-16 | Montour | Pennsylvania | 42093 | 82 | 2 |
343299 | 343299 | 2020-07-17 | Montour | Pennsylvania | 42093 | 84 | 2 |
346499 | 346499 | 2020-07-18 | Montour | Pennsylvania | 42093 | 84 | 2 |
349699 | 349699 | 2020-07-19 | Montour | Pennsylvania | 42093 | 84 | 2 |
352902 | 352902 | 2020-07-20 | Montour | Pennsylvania | 42093 | 86 | 2 |
359309 | 359309 | 2020-07-22 | Montour | Pennsylvania | 42093 | 86 | 3 |
362515 | 362515 | 2020-07-23 | Montour | Pennsylvania | 42093 | 86 | 3 |
356105 | 356105 | 2020-07-21 | Montour | Pennsylvania | 42093 | 87 | 3 |
365721 | 365721 | 2020-07-24 | Montour | Pennsylvania | 42093 | 87 | 3 |
368930 | 368930 | 2020-07-25 | Montour | Pennsylvania | 42093 | 89 | 3 |
372142 | 372142 | 2020-07-26 | Montour | Pennsylvania | 42093 | 91 | 3 |
375355 | 375355 | 2020-07-27 | Montour | Pennsylvania | 42093 | 91 | 3 |
378571 | 378571 | 2020-07-28 | Montour | Pennsylvania | 42093 | 92 | 3 |
381788 | 381788 | 2020-07-29 | Montour | Pennsylvania | 42093 | 92 | 3 |
385006 | 385006 | 2020-07-30 | Montour | Pennsylvania | 42093 | 93 | 3 |
388223 | 388223 | 2020-07-31 | Montour | Pennsylvania | 42093 | 93 | 3 |
391440 | 391440 | 2020-08-01 | Montour | Pennsylvania | 42093 | 93 | 3 |
394656 | 394656 | 2020-08-02 | Montour | Pennsylvania | 42093 | 93 | 3 |
397873 | 397873 | 2020-08-03 | Montour | Pennsylvania | 42093 | 93 | 3 |
401088 | 401088 | 2020-08-04 | Montour | Pennsylvania | 42093 | 94 | 3 |
404306 | 404306 | 2020-08-05 | Montour | Pennsylvania | 42093 | 97 | 3 |
407525 | 407525 | 2020-08-06 | Montour | Pennsylvania | 42093 | 98 | 3 |
410745 | 410745 | 2020-08-07 | Montour | Pennsylvania | 42093 | 100 | 3 |
413965 | 413965 | 2020-08-08 | Montour | Pennsylvania | 42093 | 101 | 3 |
417186 | 417186 | 2020-08-09 | Montour | Pennsylvania | 42093 | 102 | 3 |
420406 | 420406 | 2020-08-10 | Montour | Pennsylvania | 42093 | 102 | 3 |
423629 | 423629 | 2020-08-11 | Montour | Pennsylvania | 42093 | 104 | 3 |
426852 | 426852 | 2020-08-12 | Montour | Pennsylvania | 42093 | 104 | 3 |
430077 | 430077 | 2020-08-13 | Montour | Pennsylvania | 42093 | 106 | 3 |
433303 | 433303 | 2020-08-14 | Montour | Pennsylvania | 42093 | 106 | 3 |
436530 | 436530 | 2020-08-15 | Montour | Pennsylvania | 42093 | 110 | 3 |
439755 | 439755 | 2020-08-16 | Montour | Pennsylvania | 42093 | 112 | 3 |
442982 | 442982 | 2020-08-17 | Montour | Pennsylvania | 42093 | 113 | 3 |
446208 | 446208 | 2020-08-18 | Montour | Pennsylvania | 42093 | 116 | 3 |
449436 | 449436 | 2020-08-19 | Montour | Pennsylvania | 42093 | 116 | 3 |
452664 | 452664 | 2020-08-20 | Montour | Pennsylvania | 42093 | 119 | 3 |
455892 | 455892 | 2020-08-21 | Montour | Pennsylvania | 42093 | 122 | 3 |
459120 | 459120 | 2020-08-22 | Montour | Pennsylvania | 42093 | 123 | 3 |
462348 | 462348 | 2020-08-23 | Montour | Pennsylvania | 42093 | 123 | 3 |
465577 | 465577 | 2020-08-24 | Montour | Pennsylvania | 42093 | 123 | 3 |
468805 | 468805 | 2020-08-25 | Montour | Pennsylvania | 42093 | 124 | 4 |
472037 | 472037 | 2020-08-26 | Montour | Pennsylvania | 42093 | 126 | 4 |
475271 | 475271 | 2020-08-27 | Montour | Pennsylvania | 42093 | 126 | 4 |
478504 | 478504 | 2020-08-28 | Montour | Pennsylvania | 42093 | 129 | 4 |
481738 | 481738 | 2020-08-29 | Montour | Pennsylvania | 42093 | 129 | 5 |
488206 | 488206 | 2020-08-31 | Montour | Pennsylvania | 42093 | 132 | 5 |
484973 | 484973 | 2020-08-30 | Montour | Pennsylvania | 42093 | 133 | 5 |
491439 | 491439 | 2020-09-01 | Montour | Pennsylvania | 42093 | 133 | 5 |
494673 | 494673 | 2020-09-02 | Montour | Pennsylvania | 42093 | 137 | 5 |
497906 | 497906 | 2020-09-03 | Montour | Pennsylvania | 42093 | 139 | 5 |
501140 | 501140 | 2020-09-04 | Montour | Pennsylvania | 42093 | 141 | 5 |
504374 | 504374 | 2020-09-05 | Montour | Pennsylvania | 42093 | 143 | 5 |
507606 | 507606 | 2020-09-06 | Montour | Pennsylvania | 42093 | 144 | 5 |
510839 | 510839 | 2020-09-07 | Montour | Pennsylvania | 42093 | 147 | 5 |
514072 | 514072 | 2020-09-08 | Montour | Pennsylvania | 42093 | 150 | 5 |
517307 | 517307 | 2020-09-09 | Montour | Pennsylvania | 42093 | 154 | 5 |
520543 | 520543 | 2020-09-10 | Montour | Pennsylvania | 42093 | 154 | 5 |
523779 | 523779 | 2020-09-11 | Montour | Pennsylvania | 42093 | 158 | 5 |
527015 | 527015 | 2020-09-12 | Montour | Pennsylvania | 42093 | 160 | 5 |
530252 | 530252 | 2020-09-13 | Montour | Pennsylvania | 42093 | 160 | 5 |
533487 | 533487 | 2020-09-14 | Montour | Pennsylvania | 42093 | 161 | 5 |
536723 | 536723 | 2020-09-15 | Montour | Pennsylvania | 42093 | 161 | 5 |
539960 | 539960 | 2020-09-16 | Montour | Pennsylvania | 42093 | 162 | 5 |
543196 | 543196 | 2020-09-17 | Montour | Pennsylvania | 42093 | 162 | 5 |
546433 | 546433 | 2020-09-18 | Montour | Pennsylvania | 42093 | 162 | 5 |
549672 | 549672 | 2020-09-19 | Montour | Pennsylvania | 42093 | 162 | 5 |
552911 | 552911 | 2020-09-20 | Montour | Pennsylvania | 42093 | 164 | 5 |
556148 | 556148 | 2020-09-21 | Montour | Pennsylvania | 42093 | 164 | 5 |
559385 | 559385 | 2020-09-22 | Montour | Pennsylvania | 42093 | 164 | 5 |
562622 | 562622 | 2020-09-23 | Montour | Pennsylvania | 42093 | 164 | 5 |
565863 | 565863 | 2020-09-24 | Montour | Pennsylvania | 42093 | 165 | 5 |
569104 | 569104 | 2020-09-25 | Montour | Pennsylvania | 42093 | 168 | 5 |
572346 | 572346 | 2020-09-26 | Montour | Pennsylvania | 42093 | 170 | 5 |
582071 | 582071 | 2020-09-29 | Montour | Pennsylvania | 42093 | 173 | 5 |
575590 | 575590 | 2020-09-27 | Montour | Pennsylvania | 42093 | 174 | 5 |
578831 | 578831 | 2020-09-28 | Montour | Pennsylvania | 42093 | 174 | 5 |
585311 | 585311 | 2020-09-30 | Montour | Pennsylvania | 42093 | 185 | 5 |
588551 | 588551 | 2020-10-01 | Montour | Pennsylvania | 42093 | 195 | 5 |
598276 | 598276 | 2020-10-04 | Montour | Pennsylvania | 42093 | 198 | 5 |
591792 | 591792 | 2020-10-02 | Montour | Pennsylvania | 42093 | 200 | 5 |
595033 | 595033 | 2020-10-03 | Montour | Pennsylvania | 42093 | 200 | 5 |
601519 | 601519 | 2020-10-05 | Montour | Pennsylvania | 42093 | 216 | 5 |
604761 | 604761 | 2020-10-06 | Montour | Pennsylvania | 42093 | 218 | 5 |
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);