ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 42055 and state = "Pennsylvania" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- 2020-04-18 1
- …
state 1
- Pennsylvania · 785 ✖
fips 1
- 42055 · 785 ✖
county 1
- Franklin 785
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5856 | 5856 | 2020-03-20 | Franklin | Pennsylvania | 42055 | 1 | 0 |
6859 | 6859 | 2020-03-21 | Franklin | Pennsylvania | 42055 | 1 | 0 |
7977 | 7977 | 2020-03-22 | Franklin | Pennsylvania | 42055 | 1 | 0 |
9188 | 9188 | 2020-03-23 | Franklin | Pennsylvania | 42055 | 1 | 0 |
10511 | 10511 | 2020-03-24 | Franklin | Pennsylvania | 42055 | 3 | 0 |
11973 | 11973 | 2020-03-25 | Franklin | Pennsylvania | 42055 | 5 | 0 |
13593 | 13593 | 2020-03-26 | Franklin | Pennsylvania | 42055 | 5 | 0 |
15339 | 15339 | 2020-03-27 | Franklin | Pennsylvania | 42055 | 5 | 0 |
17188 | 17188 | 2020-03-28 | Franklin | Pennsylvania | 42055 | 7 | 0 |
19126 | 19126 | 2020-03-29 | Franklin | Pennsylvania | 42055 | 11 | 0 |
21176 | 21176 | 2020-03-30 | Franklin | Pennsylvania | 42055 | 12 | 0 |
23312 | 23312 | 2020-03-31 | Franklin | Pennsylvania | 42055 | 19 | 0 |
25510 | 25510 | 2020-04-01 | Franklin | Pennsylvania | 42055 | 21 | 0 |
27783 | 27783 | 2020-04-02 | Franklin | Pennsylvania | 42055 | 23 | 0 |
30117 | 30117 | 2020-04-03 | Franklin | Pennsylvania | 42055 | 26 | 0 |
32507 | 32507 | 2020-04-04 | Franklin | Pennsylvania | 42055 | 27 | 0 |
34942 | 34942 | 2020-04-05 | Franklin | Pennsylvania | 42055 | 30 | 0 |
37417 | 37417 | 2020-04-06 | Franklin | Pennsylvania | 42055 | 32 | 0 |
39939 | 39939 | 2020-04-07 | Franklin | Pennsylvania | 42055 | 39 | 0 |
42499 | 42499 | 2020-04-08 | Franklin | Pennsylvania | 42055 | 43 | 0 |
45085 | 45085 | 2020-04-09 | Franklin | Pennsylvania | 42055 | 52 | 0 |
47702 | 47702 | 2020-04-10 | Franklin | Pennsylvania | 42055 | 57 | 0 |
50359 | 50359 | 2020-04-11 | Franklin | Pennsylvania | 42055 | 59 | 0 |
53032 | 53032 | 2020-04-12 | Franklin | Pennsylvania | 42055 | 64 | 0 |
55717 | 55717 | 2020-04-13 | Franklin | Pennsylvania | 42055 | 66 | 0 |
58420 | 58420 | 2020-04-14 | Franklin | Pennsylvania | 42055 | 69 | 0 |
61135 | 61135 | 2020-04-15 | Franklin | Pennsylvania | 42055 | 78 | 0 |
63861 | 63861 | 2020-04-16 | Franklin | Pennsylvania | 42055 | 80 | 0 |
66607 | 66607 | 2020-04-17 | Franklin | Pennsylvania | 42055 | 89 | 0 |
69365 | 69365 | 2020-04-18 | Franklin | Pennsylvania | 42055 | 106 | 0 |
72132 | 72132 | 2020-04-19 | Franklin | Pennsylvania | 42055 | 111 | 0 |
74907 | 74907 | 2020-04-20 | Franklin | Pennsylvania | 42055 | 115 | 0 |
77689 | 77689 | 2020-04-21 | Franklin | Pennsylvania | 42055 | 143 | 10 |
80479 | 80479 | 2020-04-22 | Franklin | Pennsylvania | 42055 | 152 | 10 |
83278 | 83278 | 2020-04-23 | Franklin | Pennsylvania | 42055 | 151 | 10 |
86082 | 86082 | 2020-04-24 | Franklin | Pennsylvania | 42055 | 164 | 10 |
88896 | 88896 | 2020-04-25 | Franklin | Pennsylvania | 42055 | 181 | 10 |
91712 | 91712 | 2020-04-26 | Franklin | Pennsylvania | 42055 | 205 | 10 |
94539 | 94539 | 2020-04-27 | Franklin | Pennsylvania | 42055 | 227 | 10 |
97378 | 97378 | 2020-04-28 | Franklin | Pennsylvania | 42055 | 237 | 10 |
100227 | 100227 | 2020-04-29 | Franklin | Pennsylvania | 42055 | 264 | 10 |
103080 | 103080 | 2020-04-30 | Franklin | Pennsylvania | 42055 | 284 | 10 |
105943 | 105943 | 2020-05-01 | Franklin | Pennsylvania | 42055 | 313 | 10 |
108810 | 108810 | 2020-05-02 | Franklin | Pennsylvania | 42055 | 325 | 10 |
111684 | 111684 | 2020-05-03 | Franklin | Pennsylvania | 42055 | 351 | 10 |
114566 | 114566 | 2020-05-04 | Franklin | Pennsylvania | 42055 | 377 | 10 |
117447 | 117447 | 2020-05-05 | Franklin | Pennsylvania | 42055 | 396 | 10 |
120409 | 120409 | 2020-05-06 | Franklin | Pennsylvania | 42055 | 406 | 10 |
123386 | 123386 | 2020-05-07 | Franklin | Pennsylvania | 42055 | 425 | 11 |
126369 | 126369 | 2020-05-08 | Franklin | Pennsylvania | 42055 | 452 | 11 |
129358 | 129358 | 2020-05-09 | Franklin | Pennsylvania | 42055 | 478 | 12 |
132347 | 132347 | 2020-05-10 | Franklin | Pennsylvania | 42055 | 493 | 12 |
135338 | 135338 | 2020-05-11 | Franklin | Pennsylvania | 42055 | 513 | 12 |
138328 | 138328 | 2020-05-12 | Franklin | Pennsylvania | 42055 | 522 | 12 |
141324 | 141324 | 2020-05-13 | Franklin | Pennsylvania | 42055 | 545 | 13 |
144320 | 144320 | 2020-05-14 | Franklin | Pennsylvania | 42055 | 563 | 15 |
147321 | 147321 | 2020-05-15 | Franklin | Pennsylvania | 42055 | 580 | 17 |
150328 | 150328 | 2020-05-16 | Franklin | Pennsylvania | 42055 | 601 | 13 |
153339 | 153339 | 2020-05-17 | Franklin | Pennsylvania | 42055 | 621 | 13 |
156356 | 156356 | 2020-05-18 | Franklin | Pennsylvania | 42055 | 631 | 25 |
159377 | 159377 | 2020-05-19 | Franklin | Pennsylvania | 42055 | 644 | 27 |
162404 | 162404 | 2020-05-20 | Franklin | Pennsylvania | 42055 | 662 | 27 |
165433 | 165433 | 2020-05-21 | Franklin | Pennsylvania | 42055 | 677 | 28 |
168469 | 168469 | 2020-05-22 | Franklin | Pennsylvania | 42055 | 697 | 28 |
171508 | 171508 | 2020-05-23 | Franklin | Pennsylvania | 42055 | 711 | 29 |
174550 | 174550 | 2020-05-24 | Franklin | Pennsylvania | 42055 | 734 | 29 |
177594 | 177594 | 2020-05-25 | Franklin | Pennsylvania | 42055 | 740 | 29 |
180637 | 180637 | 2020-05-26 | Franklin | Pennsylvania | 42055 | 746 | 29 |
183687 | 183687 | 2020-05-27 | Franklin | Pennsylvania | 42055 | 756 | 30 |
186744 | 186744 | 2020-05-28 | Franklin | Pennsylvania | 42055 | 759 | 31 |
189805 | 189805 | 2020-05-29 | Franklin | Pennsylvania | 42055 | 762 | 34 |
192870 | 192870 | 2020-05-30 | Franklin | Pennsylvania | 42055 | 767 | 35 |
195939 | 195939 | 2020-05-31 | Franklin | Pennsylvania | 42055 | 774 | 35 |
199012 | 199012 | 2020-06-01 | Franklin | Pennsylvania | 42055 | 777 | 35 |
202087 | 202087 | 2020-06-02 | Franklin | Pennsylvania | 42055 | 781 | 36 |
205164 | 205164 | 2020-06-03 | Franklin | Pennsylvania | 42055 | 782 | 37 |
208245 | 208245 | 2020-06-04 | Franklin | Pennsylvania | 42055 | 785 | 38 |
211327 | 211327 | 2020-06-05 | Franklin | Pennsylvania | 42055 | 788 | 39 |
214413 | 214413 | 2020-06-06 | Franklin | Pennsylvania | 42055 | 792 | 39 |
217503 | 217503 | 2020-06-07 | Franklin | Pennsylvania | 42055 | 795 | 39 |
220595 | 220595 | 2020-06-08 | Franklin | Pennsylvania | 42055 | 798 | 39 |
223690 | 223690 | 2020-06-09 | Franklin | Pennsylvania | 42055 | 800 | 39 |
226790 | 226790 | 2020-06-10 | Franklin | Pennsylvania | 42055 | 807 | 39 |
229894 | 229894 | 2020-06-11 | Franklin | Pennsylvania | 42055 | 827 | 40 |
232999 | 232999 | 2020-06-12 | Franklin | Pennsylvania | 42055 | 837 | 42 |
236104 | 236104 | 2020-06-13 | Franklin | Pennsylvania | 42055 | 843 | 42 |
239212 | 239212 | 2020-06-14 | Franklin | Pennsylvania | 42055 | 842 | 42 |
242321 | 242321 | 2020-06-15 | Franklin | Pennsylvania | 42055 | 843 | 42 |
245433 | 245433 | 2020-06-16 | Franklin | Pennsylvania | 42055 | 849 | 42 |
248546 | 248546 | 2020-06-17 | Franklin | Pennsylvania | 42055 | 852 | 42 |
251661 | 251661 | 2020-06-18 | Franklin | Pennsylvania | 42055 | 855 | 42 |
254776 | 254776 | 2020-06-19 | Franklin | Pennsylvania | 42055 | 872 | 42 |
257902 | 257902 | 2020-06-20 | Franklin | Pennsylvania | 42055 | 876 | 42 |
261029 | 261029 | 2020-06-21 | Franklin | Pennsylvania | 42055 | 879 | 42 |
264157 | 264157 | 2020-06-22 | Franklin | Pennsylvania | 42055 | 882 | 42 |
267285 | 267285 | 2020-06-23 | Franklin | Pennsylvania | 42055 | 891 | 42 |
270419 | 270419 | 2020-06-24 | Franklin | Pennsylvania | 42055 | 896 | 42 |
273558 | 273558 | 2020-06-25 | Franklin | Pennsylvania | 42055 | 900 | 42 |
276705 | 276705 | 2020-06-26 | Franklin | Pennsylvania | 42055 | 902 | 42 |
279853 | 279853 | 2020-06-27 | Franklin | Pennsylvania | 42055 | 912 | 42 |
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);