ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where fips = 42091 and state = "Pennsylvania" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
727 | 727 | 2020-03-07 | Montgomery | Pennsylvania | 42091 | 2 | 0 |
836 | 836 | 2020-03-08 | Montgomery | Pennsylvania | 42091 | 4 | 0 |
965 | 965 | 2020-03-09 | Montgomery | Pennsylvania | 42091 | 7 | 0 |
1117 | 1117 | 2020-03-10 | Montgomery | Pennsylvania | 42091 | 8 | 0 |
1311 | 1311 | 2020-03-11 | Montgomery | Pennsylvania | 42091 | 9 | 0 |
1555 | 1555 | 2020-03-12 | Montgomery | Pennsylvania | 42091 | 13 | 0 |
1853 | 1853 | 2020-03-13 | Montgomery | Pennsylvania | 42091 | 18 | 0 |
2215 | 2215 | 2020-03-14 | Montgomery | Pennsylvania | 42091 | 20 | 0 |
2637 | 2637 | 2020-03-15 | Montgomery | Pennsylvania | 42091 | 24 | 0 |
3102 | 3102 | 2020-03-16 | Montgomery | Pennsylvania | 42091 | 30 | 0 |
3632 | 3632 | 2020-03-17 | Montgomery | Pennsylvania | 42091 | 32 | 0 |
4250 | 4250 | 2020-03-18 | Montgomery | Pennsylvania | 42091 | 42 | 0 |
4991 | 4991 | 2020-03-19 | Montgomery | Pennsylvania | 42091 | 47 | 0 |
5863 | 5863 | 2020-03-20 | Montgomery | Pennsylvania | 42091 | 59 | 0 |
6866 | 6866 | 2020-03-21 | Montgomery | Pennsylvania | 42091 | 77 | 0 |
7985 | 7985 | 2020-03-22 | Montgomery | Pennsylvania | 42091 | 110 | 1 |
9196 | 9196 | 2020-03-23 | Montgomery | Pennsylvania | 42091 | 129 | 2 |
10520 | 10520 | 2020-03-24 | Montgomery | Pennsylvania | 42091 | 144 | 2 |
11985 | 11985 | 2020-03-25 | Montgomery | Pennsylvania | 42091 | 172 | 2 |
13606 | 13606 | 2020-03-26 | Montgomery | Pennsylvania | 42091 | 282 | 2 |
15352 | 15352 | 2020-03-27 | Montgomery | Pennsylvania | 42091 | 374 | 4 |
17203 | 17203 | 2020-03-28 | Montgomery | Pennsylvania | 42091 | 411 | 5 |
19142 | 19142 | 2020-03-29 | Montgomery | Pennsylvania | 42091 | 488 | 5 |
21192 | 21192 | 2020-03-30 | Montgomery | Pennsylvania | 42091 | 540 | 5 |
23328 | 23328 | 2020-03-31 | Montgomery | Pennsylvania | 42091 | 570 | 6 |
25526 | 25526 | 2020-04-01 | Montgomery | Pennsylvania | 42091 | 649 | 8 |
27799 | 27799 | 2020-04-02 | Montgomery | Pennsylvania | 42091 | 735 | 9 |
30133 | 30133 | 2020-04-03 | Montgomery | Pennsylvania | 42091 | 875 | 11 |
32523 | 32523 | 2020-04-04 | Montgomery | Pennsylvania | 42091 | 982 | 17 |
34959 | 34959 | 2020-04-05 | Montgomery | Pennsylvania | 42091 | 1111 | 22 |
37434 | 37434 | 2020-04-06 | Montgomery | Pennsylvania | 42091 | 1230 | 22 |
39957 | 39957 | 2020-04-07 | Montgomery | Pennsylvania | 42091 | 1359 | 30 |
42517 | 42517 | 2020-04-08 | Montgomery | Pennsylvania | 42091 | 1521 | 37 |
45103 | 45103 | 2020-04-09 | Montgomery | Pennsylvania | 42091 | 1693 | 37 |
47720 | 47720 | 2020-04-10 | Montgomery | Pennsylvania | 42091 | 1889 | 62 |
50377 | 50377 | 2020-04-11 | Montgomery | Pennsylvania | 42091 | 2053 | 68 |
53050 | 53050 | 2020-04-12 | Montgomery | Pennsylvania | 42091 | 2164 | 68 |
55735 | 55735 | 2020-04-13 | Montgomery | Pennsylvania | 42091 | 2285 | 91 |
58438 | 58438 | 2020-04-14 | Montgomery | Pennsylvania | 42091 | 2354 | 109 |
61153 | 61153 | 2020-04-15 | Montgomery | Pennsylvania | 42091 | 2475 | 120 |
63879 | 63879 | 2020-04-16 | Montgomery | Pennsylvania | 42091 | 2544 | 128 |
66625 | 66625 | 2020-04-17 | Montgomery | Pennsylvania | 42091 | 2684 | 135 |
69383 | 69383 | 2020-04-18 | Montgomery | Pennsylvania | 42091 | 2781 | 147 |
72150 | 72150 | 2020-04-19 | Montgomery | Pennsylvania | 42091 | 2913 | 164 |
74925 | 74925 | 2020-04-20 | Montgomery | Pennsylvania | 42091 | 3040 | 184 |
77707 | 77707 | 2020-04-21 | Montgomery | Pennsylvania | 42091 | 3154 | 223 |
80497 | 80497 | 2020-04-22 | Montgomery | Pennsylvania | 42091 | 3294 | 230 |
83296 | 83296 | 2020-04-23 | Montgomery | Pennsylvania | 42091 | 3395 | 204 |
86100 | 86100 | 2020-04-24 | Montgomery | Pennsylvania | 42091 | 3525 | 208 |
88914 | 88914 | 2020-04-25 | Montgomery | Pennsylvania | 42091 | 3627 | 214 |
91730 | 91730 | 2020-04-26 | Montgomery | Pennsylvania | 42091 | 3733 | 217 |
94557 | 94557 | 2020-04-27 | Montgomery | Pennsylvania | 42091 | 3817 | 232 |
97396 | 97396 | 2020-04-28 | Montgomery | Pennsylvania | 42091 | 4043 | 249 |
100245 | 100245 | 2020-04-29 | Montgomery | Pennsylvania | 42091 | 4177 | 329 |
103098 | 103098 | 2020-04-30 | Montgomery | Pennsylvania | 42091 | 4307 | 351 |
105961 | 105961 | 2020-05-01 | Montgomery | Pennsylvania | 42091 | 4406 | 362 |
108828 | 108828 | 2020-05-02 | Montgomery | Pennsylvania | 42091 | 4487 | 369 |
111702 | 111702 | 2020-05-03 | Montgomery | Pennsylvania | 42091 | 4552 | 381 |
114584 | 114584 | 2020-05-04 | Montgomery | Pennsylvania | 42091 | 4645 | 382 |
117465 | 117465 | 2020-05-05 | Montgomery | Pennsylvania | 42091 | 4687 | 443 |
120427 | 120427 | 2020-05-06 | Montgomery | Pennsylvania | 42091 | 4827 | 471 |
123404 | 123404 | 2020-05-07 | Montgomery | Pennsylvania | 42091 | 4915 | 506 |
126387 | 126387 | 2020-05-08 | Montgomery | Pennsylvania | 42091 | 5037 | 515 |
129376 | 129376 | 2020-05-09 | Montgomery | Pennsylvania | 42091 | 5116 | 523 |
132365 | 132365 | 2020-05-10 | Montgomery | Pennsylvania | 42091 | 5260 | 525 |
135356 | 135356 | 2020-05-11 | Montgomery | Pennsylvania | 42091 | 5292 | 525 |
138346 | 138346 | 2020-05-12 | Montgomery | Pennsylvania | 42091 | 5442 | 534 |
141342 | 141342 | 2020-05-13 | Montgomery | Pennsylvania | 42091 | 5513 | 556 |
144338 | 144338 | 2020-05-14 | Montgomery | Pennsylvania | 42091 | 5583 | 587 |
147339 | 147339 | 2020-05-15 | Montgomery | Pennsylvania | 42091 | 5697 | 608 |
150346 | 150346 | 2020-05-16 | Montgomery | Pennsylvania | 42091 | 5797 | 614 |
153357 | 153357 | 2020-05-17 | Montgomery | Pennsylvania | 42091 | 5872 | 620 |
156374 | 156374 | 2020-05-18 | Montgomery | Pennsylvania | 42091 | 6012 | 566 |
159395 | 159395 | 2020-05-19 | Montgomery | Pennsylvania | 42091 | 6063 | 575 |
162422 | 162422 | 2020-05-20 | Montgomery | Pennsylvania | 42091 | 6154 | 596 |
165451 | 165451 | 2020-05-21 | Montgomery | Pennsylvania | 42091 | 6268 | 607 |
168487 | 168487 | 2020-05-22 | Montgomery | Pennsylvania | 42091 | 6366 | 619 |
171526 | 171526 | 2020-05-23 | Montgomery | Pennsylvania | 42091 | 6464 | 633 |
174568 | 174568 | 2020-05-24 | Montgomery | Pennsylvania | 42091 | 6525 | 633 |
177612 | 177612 | 2020-05-25 | Montgomery | Pennsylvania | 42091 | 6576 | 633 |
180655 | 180655 | 2020-05-26 | Montgomery | Pennsylvania | 42091 | 6598 | 635 |
183705 | 183705 | 2020-05-27 | Montgomery | Pennsylvania | 42091 | 6738 | 662 |
186762 | 186762 | 2020-05-28 | Montgomery | Pennsylvania | 42091 | 6811 | 675 |
189823 | 189823 | 2020-05-29 | Montgomery | Pennsylvania | 42091 | 6906 | 677 |
192888 | 192888 | 2020-05-30 | Montgomery | Pennsylvania | 42091 | 7006 | 682 |
195957 | 195957 | 2020-05-31 | Montgomery | Pennsylvania | 42091 | 7061 | 684 |
199030 | 199030 | 2020-06-01 | Montgomery | Pennsylvania | 42091 | 7093 | 693 |
202105 | 202105 | 2020-06-02 | Montgomery | Pennsylvania | 42091 | 7172 | 699 |
205182 | 205182 | 2020-06-03 | Montgomery | Pennsylvania | 42091 | 7242 | 702 |
208263 | 208263 | 2020-06-04 | Montgomery | Pennsylvania | 42091 | 7351 | 713 |
211345 | 211345 | 2020-06-05 | Montgomery | Pennsylvania | 42091 | 7416 | 721 |
214431 | 214431 | 2020-06-06 | Montgomery | Pennsylvania | 42091 | 7542 | 724 |
217521 | 217521 | 2020-06-07 | Montgomery | Pennsylvania | 42091 | 7582 | 725 |
220613 | 220613 | 2020-06-08 | Montgomery | Pennsylvania | 42091 | 7610 | 727 |
223708 | 223708 | 2020-06-09 | Montgomery | Pennsylvania | 42091 | 7672 | 740 |
226808 | 226808 | 2020-06-10 | Montgomery | Pennsylvania | 42091 | 7709 | 762 |
229912 | 229912 | 2020-06-11 | Montgomery | Pennsylvania | 42091 | 7754 | 765 |
233017 | 233017 | 2020-06-12 | Montgomery | Pennsylvania | 42091 | 7834 | 768 |
236122 | 236122 | 2020-06-13 | Montgomery | Pennsylvania | 42091 | 7865 | 768 |
239230 | 239230 | 2020-06-14 | Montgomery | Pennsylvania | 42091 | 7898 | 768 |
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);