ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Montgomery" and state = "Pennsylvania" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
242339 | 242339 | 2020-06-15 | Montgomery | Pennsylvania | 42091 | 7930 | 777 |
245451 | 245451 | 2020-06-16 | Montgomery | Pennsylvania | 42091 | 7950 | 778 |
248564 | 248564 | 2020-06-17 | Montgomery | Pennsylvania | 42091 | 7990 | 778 |
251679 | 251679 | 2020-06-18 | Montgomery | Pennsylvania | 42091 | 8014 | 780 |
254794 | 254794 | 2020-06-19 | Montgomery | Pennsylvania | 42091 | 8046 | 780 |
257920 | 257920 | 2020-06-20 | Montgomery | Pennsylvania | 42091 | 8076 | 783 |
261047 | 261047 | 2020-06-21 | Montgomery | Pennsylvania | 42091 | 8103 | 784 |
264175 | 264175 | 2020-06-22 | Montgomery | Pennsylvania | 42091 | 8123 | 784 |
267303 | 267303 | 2020-06-23 | Montgomery | Pennsylvania | 42091 | 8159 | 787 |
270437 | 270437 | 2020-06-24 | Montgomery | Pennsylvania | 42091 | 8188 | 791 |
273576 | 273576 | 2020-06-25 | Montgomery | Pennsylvania | 42091 | 8244 | 792 |
276723 | 276723 | 2020-06-26 | Montgomery | Pennsylvania | 42091 | 8301 | 794 |
279871 | 279871 | 2020-06-27 | Montgomery | Pennsylvania | 42091 | 8351 | 798 |
283017 | 283017 | 2020-06-28 | Montgomery | Pennsylvania | 42091 | 8377 | 798 |
286162 | 286162 | 2020-06-29 | Montgomery | Pennsylvania | 42091 | 8413 | 798 |
289313 | 289313 | 2020-06-30 | Montgomery | Pennsylvania | 42091 | 8448 | 801 |
292465 | 292465 | 2020-07-01 | Montgomery | Pennsylvania | 42091 | 8483 | 801 |
295621 | 295621 | 2020-07-02 | Montgomery | Pennsylvania | 42091 | 8514 | 806 |
298780 | 298780 | 2020-07-03 | Montgomery | Pennsylvania | 42091 | 8562 | 810 |
301944 | 301944 | 2020-07-04 | Montgomery | Pennsylvania | 42091 | 8589 | 810 |
305107 | 305107 | 2020-07-05 | Montgomery | Pennsylvania | 42091 | 8610 | 811 |
308274 | 308274 | 2020-07-06 | Montgomery | Pennsylvania | 42091 | 8634 | 811 |
311443 | 311443 | 2020-07-07 | Montgomery | Pennsylvania | 42091 | 8682 | 815 |
314615 | 314615 | 2020-07-08 | Montgomery | Pennsylvania | 42091 | 8718 | 818 |
317788 | 317788 | 2020-07-09 | Montgomery | Pennsylvania | 42091 | 8749 | 822 |
320966 | 320966 | 2020-07-10 | Montgomery | Pennsylvania | 42091 | 8790 | 826 |
324146 | 324146 | 2020-07-11 | Montgomery | Pennsylvania | 42091 | 8828 | 829 |
327331 | 327331 | 2020-07-12 | Montgomery | Pennsylvania | 42091 | 8856 | 829 |
330517 | 330517 | 2020-07-13 | Montgomery | Pennsylvania | 42091 | 8876 | 829 |
333709 | 333709 | 2020-07-14 | Montgomery | Pennsylvania | 42091 | 8907 | 829 |
336903 | 336903 | 2020-07-15 | Montgomery | Pennsylvania | 42091 | 8972 | 832 |
340100 | 340100 | 2020-07-16 | Montgomery | Pennsylvania | 42091 | 8999 | 835 |
343298 | 343298 | 2020-07-17 | Montgomery | Pennsylvania | 42091 | 9060 | 836 |
346498 | 346498 | 2020-07-18 | Montgomery | Pennsylvania | 42091 | 9091 | 837 |
349698 | 349698 | 2020-07-19 | Montgomery | Pennsylvania | 42091 | 9148 | 837 |
352901 | 352901 | 2020-07-20 | Montgomery | Pennsylvania | 42091 | 9182 | 837 |
356104 | 356104 | 2020-07-21 | Montgomery | Pennsylvania | 42091 | 9222 | 837 |
359308 | 359308 | 2020-07-22 | Montgomery | Pennsylvania | 42091 | 9282 | 839 |
362514 | 362514 | 2020-07-23 | Montgomery | Pennsylvania | 42091 | 9311 | 842 |
365720 | 365720 | 2020-07-24 | Montgomery | Pennsylvania | 42091 | 9385 | 844 |
368929 | 368929 | 2020-07-25 | Montgomery | Pennsylvania | 42091 | 9444 | 844 |
372141 | 372141 | 2020-07-26 | Montgomery | Pennsylvania | 42091 | 9492 | 844 |
375354 | 375354 | 2020-07-27 | Montgomery | Pennsylvania | 42091 | 9555 | 844 |
378570 | 378570 | 2020-07-28 | Montgomery | Pennsylvania | 42091 | 9621 | 845 |
381787 | 381787 | 2020-07-29 | Montgomery | Pennsylvania | 42091 | 9673 | 846 |
385005 | 385005 | 2020-07-30 | Montgomery | Pennsylvania | 42091 | 9723 | 847 |
388222 | 388222 | 2020-07-31 | Montgomery | Pennsylvania | 42091 | 9761 | 848 |
391439 | 391439 | 2020-08-01 | Montgomery | Pennsylvania | 42091 | 9813 | 850 |
394655 | 394655 | 2020-08-02 | Montgomery | Pennsylvania | 42091 | 9835 | 850 |
397872 | 397872 | 2020-08-03 | Montgomery | Pennsylvania | 42091 | 9870 | 850 |
401087 | 401087 | 2020-08-04 | Montgomery | Pennsylvania | 42091 | 9908 | 851 |
404305 | 404305 | 2020-08-05 | Montgomery | Pennsylvania | 42091 | 9952 | 853 |
407524 | 407524 | 2020-08-06 | Montgomery | Pennsylvania | 42091 | 9983 | 855 |
410744 | 410744 | 2020-08-07 | Montgomery | Pennsylvania | 42091 | 10015 | 855 |
413964 | 413964 | 2020-08-08 | Montgomery | Pennsylvania | 42091 | 10077 | 857 |
417185 | 417185 | 2020-08-09 | Montgomery | Pennsylvania | 42091 | 10121 | 857 |
420405 | 420405 | 2020-08-10 | Montgomery | Pennsylvania | 42091 | 10149 | 857 |
423628 | 423628 | 2020-08-11 | Montgomery | Pennsylvania | 42091 | 10187 | 858 |
426851 | 426851 | 2020-08-12 | Montgomery | Pennsylvania | 42091 | 10219 | 859 |
430076 | 430076 | 2020-08-13 | Montgomery | Pennsylvania | 42091 | 10264 | 859 |
433302 | 433302 | 2020-08-14 | Montgomery | Pennsylvania | 42091 | 10307 | 859 |
436529 | 436529 | 2020-08-15 | Montgomery | Pennsylvania | 42091 | 10361 | 859 |
439754 | 439754 | 2020-08-16 | Montgomery | Pennsylvania | 42091 | 10405 | 859 |
442981 | 442981 | 2020-08-17 | Montgomery | Pennsylvania | 42091 | 10433 | 859 |
446207 | 446207 | 2020-08-18 | Montgomery | Pennsylvania | 42091 | 10479 | 859 |
449435 | 449435 | 2020-08-19 | Montgomery | Pennsylvania | 42091 | 10523 | 860 |
452663 | 452663 | 2020-08-20 | Montgomery | Pennsylvania | 42091 | 10568 | 860 |
455891 | 455891 | 2020-08-21 | Montgomery | Pennsylvania | 42091 | 10607 | 861 |
459119 | 459119 | 2020-08-22 | Montgomery | Pennsylvania | 42091 | 10667 | 861 |
462347 | 462347 | 2020-08-23 | Montgomery | Pennsylvania | 42091 | 10713 | 861 |
465576 | 465576 | 2020-08-24 | Montgomery | Pennsylvania | 42091 | 10755 | 861 |
468804 | 468804 | 2020-08-25 | Montgomery | Pennsylvania | 42091 | 10784 | 862 |
472036 | 472036 | 2020-08-26 | Montgomery | Pennsylvania | 42091 | 10818 | 862 |
475270 | 475270 | 2020-08-27 | Montgomery | Pennsylvania | 42091 | 10871 | 861 |
478503 | 478503 | 2020-08-28 | Montgomery | Pennsylvania | 42091 | 10912 | 861 |
481737 | 481737 | 2020-08-29 | Montgomery | Pennsylvania | 42091 | 10947 | 861 |
484972 | 484972 | 2020-08-30 | Montgomery | Pennsylvania | 42091 | 10996 | 861 |
488205 | 488205 | 2020-08-31 | Montgomery | Pennsylvania | 42091 | 11035 | 861 |
491438 | 491438 | 2020-09-01 | Montgomery | Pennsylvania | 42091 | 11093 | 863 |
494672 | 494672 | 2020-09-02 | Montgomery | Pennsylvania | 42091 | 11126 | 863 |
497905 | 497905 | 2020-09-03 | Montgomery | Pennsylvania | 42091 | 11189 | 863 |
501139 | 501139 | 2020-09-04 | Montgomery | Pennsylvania | 42091 | 11237 | 863 |
504373 | 504373 | 2020-09-05 | Montgomery | Pennsylvania | 42091 | 11300 | 863 |
507605 | 507605 | 2020-09-06 | Montgomery | Pennsylvania | 42091 | 11346 | 863 |
510838 | 510838 | 2020-09-07 | Montgomery | Pennsylvania | 42091 | 11392 | 863 |
514071 | 514071 | 2020-09-08 | Montgomery | Pennsylvania | 42091 | 11434 | 864 |
517306 | 517306 | 2020-09-09 | Montgomery | Pennsylvania | 42091 | 11475 | 864 |
520542 | 520542 | 2020-09-10 | Montgomery | Pennsylvania | 42091 | 11510 | 865 |
523778 | 523778 | 2020-09-11 | Montgomery | Pennsylvania | 42091 | 11537 | 867 |
527014 | 527014 | 2020-09-12 | Montgomery | Pennsylvania | 42091 | 11578 | 867 |
530251 | 530251 | 2020-09-13 | Montgomery | Pennsylvania | 42091 | 11578 | 867 |
533486 | 533486 | 2020-09-14 | Montgomery | Pennsylvania | 42091 | 11657 | 868 |
536722 | 536722 | 2020-09-15 | Montgomery | Pennsylvania | 42091 | 11710 | 868 |
539959 | 539959 | 2020-09-16 | Montgomery | Pennsylvania | 42091 | 11738 | 869 |
543195 | 543195 | 2020-09-17 | Montgomery | Pennsylvania | 42091 | 11800 | 869 |
546432 | 546432 | 2020-09-18 | Montgomery | Pennsylvania | 42091 | 11855 | 869 |
549671 | 549671 | 2020-09-19 | Montgomery | Pennsylvania | 42091 | 11897 | 870 |
552910 | 552910 | 2020-09-20 | Montgomery | Pennsylvania | 42091 | 11932 | 874 |
556147 | 556147 | 2020-09-21 | Montgomery | Pennsylvania | 42091 | 11962 | 874 |
559384 | 559384 | 2020-09-22 | Montgomery | Pennsylvania | 42091 | 11992 | 876 |
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);