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 descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388204 | 388204 | 2020-07-31 | Franklin | Pennsylvania | 42055 | 1268 | 46 |
384987 | 384987 | 2020-07-30 | Franklin | Pennsylvania | 42055 | 1259 | 46 |
381769 | 381769 | 2020-07-29 | Franklin | Pennsylvania | 42055 | 1231 | 46 |
378552 | 378552 | 2020-07-28 | Franklin | Pennsylvania | 42055 | 1223 | 46 |
375336 | 375336 | 2020-07-27 | Franklin | Pennsylvania | 42055 | 1201 | 46 |
372123 | 372123 | 2020-07-26 | Franklin | Pennsylvania | 42055 | 1191 | 46 |
368911 | 368911 | 2020-07-25 | Franklin | Pennsylvania | 42055 | 1186 | 46 |
365702 | 365702 | 2020-07-24 | Franklin | Pennsylvania | 42055 | 1176 | 46 |
362496 | 362496 | 2020-07-23 | Franklin | Pennsylvania | 42055 | 1146 | 46 |
359290 | 359290 | 2020-07-22 | Franklin | Pennsylvania | 42055 | 1109 | 46 |
356086 | 356086 | 2020-07-21 | Franklin | Pennsylvania | 42055 | 1096 | 46 |
352883 | 352883 | 2020-07-20 | Franklin | Pennsylvania | 42055 | 1074 | 46 |
349680 | 349680 | 2020-07-19 | Franklin | Pennsylvania | 42055 | 1061 | 46 |
346480 | 346480 | 2020-07-18 | Franklin | Pennsylvania | 42055 | 1052 | 46 |
343280 | 343280 | 2020-07-17 | Franklin | Pennsylvania | 42055 | 1043 | 46 |
340082 | 340082 | 2020-07-16 | Franklin | Pennsylvania | 42055 | 1033 | 46 |
336885 | 336885 | 2020-07-15 | Franklin | Pennsylvania | 42055 | 1019 | 46 |
333691 | 333691 | 2020-07-14 | Franklin | Pennsylvania | 42055 | 1016 | 46 |
330499 | 330499 | 2020-07-13 | Franklin | Pennsylvania | 42055 | 1006 | 46 |
327313 | 327313 | 2020-07-12 | Franklin | Pennsylvania | 42055 | 1003 | 46 |
324128 | 324128 | 2020-07-11 | Franklin | Pennsylvania | 42055 | 997 | 46 |
320948 | 320948 | 2020-07-10 | Franklin | Pennsylvania | 42055 | 993 | 46 |
317770 | 317770 | 2020-07-09 | Franklin | Pennsylvania | 42055 | 989 | 46 |
314597 | 314597 | 2020-07-08 | Franklin | Pennsylvania | 42055 | 984 | 44 |
311425 | 311425 | 2020-07-07 | Franklin | Pennsylvania | 42055 | 970 | 44 |
308256 | 308256 | 2020-07-06 | Franklin | Pennsylvania | 42055 | 958 | 44 |
305089 | 305089 | 2020-07-05 | Franklin | Pennsylvania | 42055 | 956 | 44 |
301926 | 301926 | 2020-07-04 | Franklin | Pennsylvania | 42055 | 955 | 44 |
298762 | 298762 | 2020-07-03 | Franklin | Pennsylvania | 42055 | 954 | 44 |
295603 | 295603 | 2020-07-02 | Franklin | Pennsylvania | 42055 | 950 | 44 |
292447 | 292447 | 2020-07-01 | Franklin | Pennsylvania | 42055 | 940 | 43 |
289295 | 289295 | 2020-06-30 | Franklin | Pennsylvania | 42055 | 925 | 43 |
286144 | 286144 | 2020-06-29 | Franklin | Pennsylvania | 42055 | 915 | 42 |
282999 | 282999 | 2020-06-28 | Franklin | Pennsylvania | 42055 | 913 | 42 |
279853 | 279853 | 2020-06-27 | Franklin | Pennsylvania | 42055 | 912 | 42 |
276705 | 276705 | 2020-06-26 | Franklin | Pennsylvania | 42055 | 902 | 42 |
273558 | 273558 | 2020-06-25 | Franklin | Pennsylvania | 42055 | 900 | 42 |
270419 | 270419 | 2020-06-24 | Franklin | Pennsylvania | 42055 | 896 | 42 |
267285 | 267285 | 2020-06-23 | Franklin | Pennsylvania | 42055 | 891 | 42 |
264157 | 264157 | 2020-06-22 | Franklin | Pennsylvania | 42055 | 882 | 42 |
261029 | 261029 | 2020-06-21 | Franklin | Pennsylvania | 42055 | 879 | 42 |
257902 | 257902 | 2020-06-20 | Franklin | Pennsylvania | 42055 | 876 | 42 |
254776 | 254776 | 2020-06-19 | Franklin | Pennsylvania | 42055 | 872 | 42 |
251661 | 251661 | 2020-06-18 | Franklin | Pennsylvania | 42055 | 855 | 42 |
248546 | 248546 | 2020-06-17 | Franklin | Pennsylvania | 42055 | 852 | 42 |
245433 | 245433 | 2020-06-16 | Franklin | Pennsylvania | 42055 | 849 | 42 |
242321 | 242321 | 2020-06-15 | Franklin | Pennsylvania | 42055 | 843 | 42 |
239212 | 239212 | 2020-06-14 | Franklin | Pennsylvania | 42055 | 842 | 42 |
236104 | 236104 | 2020-06-13 | Franklin | Pennsylvania | 42055 | 843 | 42 |
232999 | 232999 | 2020-06-12 | Franklin | Pennsylvania | 42055 | 837 | 42 |
229894 | 229894 | 2020-06-11 | Franklin | Pennsylvania | 42055 | 827 | 40 |
226790 | 226790 | 2020-06-10 | Franklin | Pennsylvania | 42055 | 807 | 39 |
223690 | 223690 | 2020-06-09 | Franklin | Pennsylvania | 42055 | 800 | 39 |
220595 | 220595 | 2020-06-08 | Franklin | Pennsylvania | 42055 | 798 | 39 |
217503 | 217503 | 2020-06-07 | Franklin | Pennsylvania | 42055 | 795 | 39 |
214413 | 214413 | 2020-06-06 | Franklin | Pennsylvania | 42055 | 792 | 39 |
211327 | 211327 | 2020-06-05 | Franklin | Pennsylvania | 42055 | 788 | 39 |
208245 | 208245 | 2020-06-04 | Franklin | Pennsylvania | 42055 | 785 | 38 |
205164 | 205164 | 2020-06-03 | Franklin | Pennsylvania | 42055 | 782 | 37 |
202087 | 202087 | 2020-06-02 | Franklin | Pennsylvania | 42055 | 781 | 36 |
199012 | 199012 | 2020-06-01 | Franklin | Pennsylvania | 42055 | 777 | 35 |
195939 | 195939 | 2020-05-31 | Franklin | Pennsylvania | 42055 | 774 | 35 |
192870 | 192870 | 2020-05-30 | Franklin | Pennsylvania | 42055 | 767 | 35 |
189805 | 189805 | 2020-05-29 | Franklin | Pennsylvania | 42055 | 762 | 34 |
186744 | 186744 | 2020-05-28 | Franklin | Pennsylvania | 42055 | 759 | 31 |
183687 | 183687 | 2020-05-27 | Franklin | Pennsylvania | 42055 | 756 | 30 |
180637 | 180637 | 2020-05-26 | Franklin | Pennsylvania | 42055 | 746 | 29 |
177594 | 177594 | 2020-05-25 | Franklin | Pennsylvania | 42055 | 740 | 29 |
174550 | 174550 | 2020-05-24 | Franklin | Pennsylvania | 42055 | 734 | 29 |
171508 | 171508 | 2020-05-23 | Franklin | Pennsylvania | 42055 | 711 | 29 |
168469 | 168469 | 2020-05-22 | Franklin | Pennsylvania | 42055 | 697 | 28 |
165433 | 165433 | 2020-05-21 | Franklin | Pennsylvania | 42055 | 677 | 28 |
162404 | 162404 | 2020-05-20 | Franklin | Pennsylvania | 42055 | 662 | 27 |
159377 | 159377 | 2020-05-19 | Franklin | Pennsylvania | 42055 | 644 | 27 |
156356 | 156356 | 2020-05-18 | Franklin | Pennsylvania | 42055 | 631 | 25 |
153339 | 153339 | 2020-05-17 | Franklin | Pennsylvania | 42055 | 621 | 13 |
150328 | 150328 | 2020-05-16 | Franklin | Pennsylvania | 42055 | 601 | 13 |
147321 | 147321 | 2020-05-15 | Franklin | Pennsylvania | 42055 | 580 | 17 |
144320 | 144320 | 2020-05-14 | Franklin | Pennsylvania | 42055 | 563 | 15 |
141324 | 141324 | 2020-05-13 | Franklin | Pennsylvania | 42055 | 545 | 13 |
138328 | 138328 | 2020-05-12 | Franklin | Pennsylvania | 42055 | 522 | 12 |
135338 | 135338 | 2020-05-11 | Franklin | Pennsylvania | 42055 | 513 | 12 |
132347 | 132347 | 2020-05-10 | Franklin | Pennsylvania | 42055 | 493 | 12 |
129358 | 129358 | 2020-05-09 | Franklin | Pennsylvania | 42055 | 478 | 12 |
126369 | 126369 | 2020-05-08 | Franklin | Pennsylvania | 42055 | 452 | 11 |
123386 | 123386 | 2020-05-07 | Franklin | Pennsylvania | 42055 | 425 | 11 |
120409 | 120409 | 2020-05-06 | Franklin | Pennsylvania | 42055 | 406 | 10 |
117447 | 117447 | 2020-05-05 | Franklin | Pennsylvania | 42055 | 396 | 10 |
114566 | 114566 | 2020-05-04 | Franklin | Pennsylvania | 42055 | 377 | 10 |
111684 | 111684 | 2020-05-03 | Franklin | Pennsylvania | 42055 | 351 | 10 |
108810 | 108810 | 2020-05-02 | Franklin | Pennsylvania | 42055 | 325 | 10 |
105943 | 105943 | 2020-05-01 | Franklin | Pennsylvania | 42055 | 313 | 10 |
103080 | 103080 | 2020-04-30 | Franklin | Pennsylvania | 42055 | 284 | 10 |
100227 | 100227 | 2020-04-29 | Franklin | Pennsylvania | 42055 | 264 | 10 |
97378 | 97378 | 2020-04-28 | Franklin | Pennsylvania | 42055 | 237 | 10 |
94539 | 94539 | 2020-04-27 | Franklin | Pennsylvania | 42055 | 227 | 10 |
91712 | 91712 | 2020-04-26 | Franklin | Pennsylvania | 42055 | 205 | 10 |
88896 | 88896 | 2020-04-25 | Franklin | Pennsylvania | 42055 | 181 | 10 |
86082 | 86082 | 2020-04-24 | Franklin | Pennsylvania | 42055 | 164 | 10 |
83278 | 83278 | 2020-04-23 | Franklin | Pennsylvania | 42055 | 151 | 10 |
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);