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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388222 | 388222 | 2020-07-31 | Montgomery | Pennsylvania | 42091 | 9761 | 848 |
385005 | 385005 | 2020-07-30 | Montgomery | Pennsylvania | 42091 | 9723 | 847 |
381787 | 381787 | 2020-07-29 | Montgomery | Pennsylvania | 42091 | 9673 | 846 |
378570 | 378570 | 2020-07-28 | Montgomery | Pennsylvania | 42091 | 9621 | 845 |
375354 | 375354 | 2020-07-27 | Montgomery | Pennsylvania | 42091 | 9555 | 844 |
372141 | 372141 | 2020-07-26 | Montgomery | Pennsylvania | 42091 | 9492 | 844 |
368929 | 368929 | 2020-07-25 | Montgomery | Pennsylvania | 42091 | 9444 | 844 |
365720 | 365720 | 2020-07-24 | Montgomery | Pennsylvania | 42091 | 9385 | 844 |
362514 | 362514 | 2020-07-23 | Montgomery | Pennsylvania | 42091 | 9311 | 842 |
359308 | 359308 | 2020-07-22 | Montgomery | Pennsylvania | 42091 | 9282 | 839 |
356104 | 356104 | 2020-07-21 | Montgomery | Pennsylvania | 42091 | 9222 | 837 |
352901 | 352901 | 2020-07-20 | Montgomery | Pennsylvania | 42091 | 9182 | 837 |
349698 | 349698 | 2020-07-19 | Montgomery | Pennsylvania | 42091 | 9148 | 837 |
346498 | 346498 | 2020-07-18 | Montgomery | Pennsylvania | 42091 | 9091 | 837 |
343298 | 343298 | 2020-07-17 | Montgomery | Pennsylvania | 42091 | 9060 | 836 |
340100 | 340100 | 2020-07-16 | Montgomery | Pennsylvania | 42091 | 8999 | 835 |
336903 | 336903 | 2020-07-15 | Montgomery | Pennsylvania | 42091 | 8972 | 832 |
333709 | 333709 | 2020-07-14 | Montgomery | Pennsylvania | 42091 | 8907 | 829 |
330517 | 330517 | 2020-07-13 | Montgomery | Pennsylvania | 42091 | 8876 | 829 |
327331 | 327331 | 2020-07-12 | Montgomery | Pennsylvania | 42091 | 8856 | 829 |
324146 | 324146 | 2020-07-11 | Montgomery | Pennsylvania | 42091 | 8828 | 829 |
320966 | 320966 | 2020-07-10 | Montgomery | Pennsylvania | 42091 | 8790 | 826 |
317788 | 317788 | 2020-07-09 | Montgomery | Pennsylvania | 42091 | 8749 | 822 |
314615 | 314615 | 2020-07-08 | Montgomery | Pennsylvania | 42091 | 8718 | 818 |
311443 | 311443 | 2020-07-07 | Montgomery | Pennsylvania | 42091 | 8682 | 815 |
308274 | 308274 | 2020-07-06 | Montgomery | Pennsylvania | 42091 | 8634 | 811 |
305107 | 305107 | 2020-07-05 | Montgomery | Pennsylvania | 42091 | 8610 | 811 |
301944 | 301944 | 2020-07-04 | Montgomery | Pennsylvania | 42091 | 8589 | 810 |
298780 | 298780 | 2020-07-03 | Montgomery | Pennsylvania | 42091 | 8562 | 810 |
295621 | 295621 | 2020-07-02 | Montgomery | Pennsylvania | 42091 | 8514 | 806 |
292465 | 292465 | 2020-07-01 | Montgomery | Pennsylvania | 42091 | 8483 | 801 |
289313 | 289313 | 2020-06-30 | Montgomery | Pennsylvania | 42091 | 8448 | 801 |
286162 | 286162 | 2020-06-29 | Montgomery | Pennsylvania | 42091 | 8413 | 798 |
283017 | 283017 | 2020-06-28 | Montgomery | Pennsylvania | 42091 | 8377 | 798 |
279871 | 279871 | 2020-06-27 | Montgomery | Pennsylvania | 42091 | 8351 | 798 |
276723 | 276723 | 2020-06-26 | Montgomery | Pennsylvania | 42091 | 8301 | 794 |
273576 | 273576 | 2020-06-25 | Montgomery | Pennsylvania | 42091 | 8244 | 792 |
270437 | 270437 | 2020-06-24 | Montgomery | Pennsylvania | 42091 | 8188 | 791 |
267303 | 267303 | 2020-06-23 | Montgomery | Pennsylvania | 42091 | 8159 | 787 |
264175 | 264175 | 2020-06-22 | Montgomery | Pennsylvania | 42091 | 8123 | 784 |
261047 | 261047 | 2020-06-21 | Montgomery | Pennsylvania | 42091 | 8103 | 784 |
257920 | 257920 | 2020-06-20 | Montgomery | Pennsylvania | 42091 | 8076 | 783 |
254794 | 254794 | 2020-06-19 | Montgomery | Pennsylvania | 42091 | 8046 | 780 |
251679 | 251679 | 2020-06-18 | Montgomery | Pennsylvania | 42091 | 8014 | 780 |
248564 | 248564 | 2020-06-17 | Montgomery | Pennsylvania | 42091 | 7990 | 778 |
245451 | 245451 | 2020-06-16 | Montgomery | Pennsylvania | 42091 | 7950 | 778 |
242339 | 242339 | 2020-06-15 | Montgomery | Pennsylvania | 42091 | 7930 | 777 |
239230 | 239230 | 2020-06-14 | Montgomery | Pennsylvania | 42091 | 7898 | 768 |
236122 | 236122 | 2020-06-13 | Montgomery | Pennsylvania | 42091 | 7865 | 768 |
233017 | 233017 | 2020-06-12 | Montgomery | Pennsylvania | 42091 | 7834 | 768 |
229912 | 229912 | 2020-06-11 | Montgomery | Pennsylvania | 42091 | 7754 | 765 |
226808 | 226808 | 2020-06-10 | Montgomery | Pennsylvania | 42091 | 7709 | 762 |
223708 | 223708 | 2020-06-09 | Montgomery | Pennsylvania | 42091 | 7672 | 740 |
220613 | 220613 | 2020-06-08 | Montgomery | Pennsylvania | 42091 | 7610 | 727 |
217521 | 217521 | 2020-06-07 | Montgomery | Pennsylvania | 42091 | 7582 | 725 |
214431 | 214431 | 2020-06-06 | Montgomery | Pennsylvania | 42091 | 7542 | 724 |
211345 | 211345 | 2020-06-05 | Montgomery | Pennsylvania | 42091 | 7416 | 721 |
208263 | 208263 | 2020-06-04 | Montgomery | Pennsylvania | 42091 | 7351 | 713 |
205182 | 205182 | 2020-06-03 | Montgomery | Pennsylvania | 42091 | 7242 | 702 |
202105 | 202105 | 2020-06-02 | Montgomery | Pennsylvania | 42091 | 7172 | 699 |
199030 | 199030 | 2020-06-01 | Montgomery | Pennsylvania | 42091 | 7093 | 693 |
195957 | 195957 | 2020-05-31 | Montgomery | Pennsylvania | 42091 | 7061 | 684 |
192888 | 192888 | 2020-05-30 | Montgomery | Pennsylvania | 42091 | 7006 | 682 |
189823 | 189823 | 2020-05-29 | Montgomery | Pennsylvania | 42091 | 6906 | 677 |
186762 | 186762 | 2020-05-28 | Montgomery | Pennsylvania | 42091 | 6811 | 675 |
183705 | 183705 | 2020-05-27 | Montgomery | Pennsylvania | 42091 | 6738 | 662 |
180655 | 180655 | 2020-05-26 | Montgomery | Pennsylvania | 42091 | 6598 | 635 |
177612 | 177612 | 2020-05-25 | Montgomery | Pennsylvania | 42091 | 6576 | 633 |
174568 | 174568 | 2020-05-24 | Montgomery | Pennsylvania | 42091 | 6525 | 633 |
171526 | 171526 | 2020-05-23 | Montgomery | Pennsylvania | 42091 | 6464 | 633 |
168487 | 168487 | 2020-05-22 | Montgomery | Pennsylvania | 42091 | 6366 | 619 |
165451 | 165451 | 2020-05-21 | Montgomery | Pennsylvania | 42091 | 6268 | 607 |
162422 | 162422 | 2020-05-20 | Montgomery | Pennsylvania | 42091 | 6154 | 596 |
159395 | 159395 | 2020-05-19 | Montgomery | Pennsylvania | 42091 | 6063 | 575 |
156374 | 156374 | 2020-05-18 | Montgomery | Pennsylvania | 42091 | 6012 | 566 |
153357 | 153357 | 2020-05-17 | Montgomery | Pennsylvania | 42091 | 5872 | 620 |
150346 | 150346 | 2020-05-16 | Montgomery | Pennsylvania | 42091 | 5797 | 614 |
147339 | 147339 | 2020-05-15 | Montgomery | Pennsylvania | 42091 | 5697 | 608 |
144338 | 144338 | 2020-05-14 | Montgomery | Pennsylvania | 42091 | 5583 | 587 |
141342 | 141342 | 2020-05-13 | Montgomery | Pennsylvania | 42091 | 5513 | 556 |
138346 | 138346 | 2020-05-12 | Montgomery | Pennsylvania | 42091 | 5442 | 534 |
135356 | 135356 | 2020-05-11 | Montgomery | Pennsylvania | 42091 | 5292 | 525 |
132365 | 132365 | 2020-05-10 | Montgomery | Pennsylvania | 42091 | 5260 | 525 |
129376 | 129376 | 2020-05-09 | Montgomery | Pennsylvania | 42091 | 5116 | 523 |
126387 | 126387 | 2020-05-08 | Montgomery | Pennsylvania | 42091 | 5037 | 515 |
123404 | 123404 | 2020-05-07 | Montgomery | Pennsylvania | 42091 | 4915 | 506 |
120427 | 120427 | 2020-05-06 | Montgomery | Pennsylvania | 42091 | 4827 | 471 |
117465 | 117465 | 2020-05-05 | Montgomery | Pennsylvania | 42091 | 4687 | 443 |
114584 | 114584 | 2020-05-04 | Montgomery | Pennsylvania | 42091 | 4645 | 382 |
111702 | 111702 | 2020-05-03 | Montgomery | Pennsylvania | 42091 | 4552 | 381 |
108828 | 108828 | 2020-05-02 | Montgomery | Pennsylvania | 42091 | 4487 | 369 |
105961 | 105961 | 2020-05-01 | Montgomery | Pennsylvania | 42091 | 4406 | 362 |
103098 | 103098 | 2020-04-30 | Montgomery | Pennsylvania | 42091 | 4307 | 351 |
100245 | 100245 | 2020-04-29 | Montgomery | Pennsylvania | 42091 | 4177 | 329 |
97396 | 97396 | 2020-04-28 | Montgomery | Pennsylvania | 42091 | 4043 | 249 |
94557 | 94557 | 2020-04-27 | Montgomery | Pennsylvania | 42091 | 3817 | 232 |
91730 | 91730 | 2020-04-26 | Montgomery | Pennsylvania | 42091 | 3733 | 217 |
88914 | 88914 | 2020-04-25 | Montgomery | Pennsylvania | 42091 | 3627 | 214 |
86100 | 86100 | 2020-04-24 | Montgomery | Pennsylvania | 42091 | 3525 | 208 |
83296 | 83296 | 2020-04-23 | Montgomery | Pennsylvania | 42091 | 3395 | 204 |
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);