ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where fips = 42065 and state = "Pennsylvania" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
39944 | 39944 | 2020-04-07 | Jefferson | Pennsylvania | 42065 | 1 | 0 |
42504 | 42504 | 2020-04-08 | Jefferson | Pennsylvania | 42065 | 1 | 0 |
45090 | 45090 | 2020-04-09 | Jefferson | Pennsylvania | 42065 | 1 | 0 |
47707 | 47707 | 2020-04-10 | Jefferson | Pennsylvania | 42065 | 1 | 0 |
50364 | 50364 | 2020-04-11 | Jefferson | Pennsylvania | 42065 | 1 | 0 |
53037 | 53037 | 2020-04-12 | Jefferson | Pennsylvania | 42065 | 2 | 0 |
55722 | 55722 | 2020-04-13 | Jefferson | Pennsylvania | 42065 | 2 | 0 |
58425 | 58425 | 2020-04-14 | Jefferson | Pennsylvania | 42065 | 2 | 0 |
61140 | 61140 | 2020-04-15 | Jefferson | Pennsylvania | 42065 | 2 | 0 |
63866 | 63866 | 2020-04-16 | Jefferson | Pennsylvania | 42065 | 2 | 0 |
66612 | 66612 | 2020-04-17 | Jefferson | Pennsylvania | 42065 | 2 | 0 |
69370 | 69370 | 2020-04-18 | Jefferson | Pennsylvania | 42065 | 2 | 0 |
72137 | 72137 | 2020-04-19 | Jefferson | Pennsylvania | 42065 | 2 | 0 |
74912 | 74912 | 2020-04-20 | Jefferson | Pennsylvania | 42065 | 3 | 0 |
77694 | 77694 | 2020-04-21 | Jefferson | Pennsylvania | 42065 | 3 | 0 |
80484 | 80484 | 2020-04-22 | Jefferson | Pennsylvania | 42065 | 3 | 0 |
83283 | 83283 | 2020-04-23 | Jefferson | Pennsylvania | 42065 | 4 | 0 |
86087 | 86087 | 2020-04-24 | Jefferson | Pennsylvania | 42065 | 4 | 0 |
88901 | 88901 | 2020-04-25 | Jefferson | Pennsylvania | 42065 | 4 | 0 |
91717 | 91717 | 2020-04-26 | Jefferson | Pennsylvania | 42065 | 4 | 0 |
94544 | 94544 | 2020-04-27 | Jefferson | Pennsylvania | 42065 | 4 | 0 |
97383 | 97383 | 2020-04-28 | Jefferson | Pennsylvania | 42065 | 4 | 0 |
100232 | 100232 | 2020-04-29 | Jefferson | Pennsylvania | 42065 | 4 | 0 |
103085 | 103085 | 2020-04-30 | Jefferson | Pennsylvania | 42065 | 4 | 0 |
105948 | 105948 | 2020-05-01 | Jefferson | Pennsylvania | 42065 | 4 | 0 |
108815 | 108815 | 2020-05-02 | Jefferson | Pennsylvania | 42065 | 6 | 0 |
111689 | 111689 | 2020-05-03 | Jefferson | Pennsylvania | 42065 | 6 | 0 |
114571 | 114571 | 2020-05-04 | Jefferson | Pennsylvania | 42065 | 6 | 0 |
117452 | 117452 | 2020-05-05 | Jefferson | Pennsylvania | 42065 | 6 | 0 |
120414 | 120414 | 2020-05-06 | Jefferson | Pennsylvania | 42065 | 7 | 0 |
123391 | 123391 | 2020-05-07 | Jefferson | Pennsylvania | 42065 | 7 | 0 |
126374 | 126374 | 2020-05-08 | Jefferson | Pennsylvania | 42065 | 7 | 0 |
129363 | 129363 | 2020-05-09 | Jefferson | Pennsylvania | 42065 | 7 | 0 |
132352 | 132352 | 2020-05-10 | Jefferson | Pennsylvania | 42065 | 7 | 0 |
135343 | 135343 | 2020-05-11 | Jefferson | Pennsylvania | 42065 | 7 | 0 |
138333 | 138333 | 2020-05-12 | Jefferson | Pennsylvania | 42065 | 7 | 0 |
141329 | 141329 | 2020-05-13 | Jefferson | Pennsylvania | 42065 | 7 | 0 |
144325 | 144325 | 2020-05-14 | Jefferson | Pennsylvania | 42065 | 7 | 0 |
147326 | 147326 | 2020-05-15 | Jefferson | Pennsylvania | 42065 | 7 | 0 |
150333 | 150333 | 2020-05-16 | Jefferson | Pennsylvania | 42065 | 7 | 0 |
153344 | 153344 | 2020-05-17 | Jefferson | Pennsylvania | 42065 | 7 | 0 |
156361 | 156361 | 2020-05-18 | Jefferson | Pennsylvania | 42065 | 7 | 0 |
159382 | 159382 | 2020-05-19 | Jefferson | Pennsylvania | 42065 | 7 | 0 |
162409 | 162409 | 2020-05-20 | Jefferson | Pennsylvania | 42065 | 7 | 0 |
165438 | 165438 | 2020-05-21 | Jefferson | Pennsylvania | 42065 | 7 | 0 |
168474 | 168474 | 2020-05-22 | Jefferson | Pennsylvania | 42065 | 7 | 0 |
171513 | 171513 | 2020-05-23 | Jefferson | Pennsylvania | 42065 | 7 | 0 |
174555 | 174555 | 2020-05-24 | Jefferson | Pennsylvania | 42065 | 7 | 0 |
177599 | 177599 | 2020-05-25 | Jefferson | Pennsylvania | 42065 | 7 | 0 |
180642 | 180642 | 2020-05-26 | Jefferson | Pennsylvania | 42065 | 7 | 0 |
183692 | 183692 | 2020-05-27 | Jefferson | Pennsylvania | 42065 | 7 | 0 |
186749 | 186749 | 2020-05-28 | Jefferson | Pennsylvania | 42065 | 7 | 0 |
189810 | 189810 | 2020-05-29 | Jefferson | Pennsylvania | 42065 | 7 | 0 |
192875 | 192875 | 2020-05-30 | Jefferson | Pennsylvania | 42065 | 9 | 0 |
195944 | 195944 | 2020-05-31 | Jefferson | Pennsylvania | 42065 | 9 | 0 |
199017 | 199017 | 2020-06-01 | Jefferson | Pennsylvania | 42065 | 9 | 0 |
202092 | 202092 | 2020-06-02 | Jefferson | Pennsylvania | 42065 | 12 | 0 |
205169 | 205169 | 2020-06-03 | Jefferson | Pennsylvania | 42065 | 14 | 0 |
208250 | 208250 | 2020-06-04 | Jefferson | Pennsylvania | 42065 | 14 | 0 |
211332 | 211332 | 2020-06-05 | Jefferson | Pennsylvania | 42065 | 15 | 0 |
214418 | 214418 | 2020-06-06 | Jefferson | Pennsylvania | 42065 | 16 | 0 |
217508 | 217508 | 2020-06-07 | Jefferson | Pennsylvania | 42065 | 16 | 0 |
220600 | 220600 | 2020-06-08 | Jefferson | Pennsylvania | 42065 | 16 | 0 |
223695 | 223695 | 2020-06-09 | Jefferson | Pennsylvania | 42065 | 16 | 0 |
226795 | 226795 | 2020-06-10 | Jefferson | Pennsylvania | 42065 | 16 | 0 |
229899 | 229899 | 2020-06-11 | Jefferson | Pennsylvania | 42065 | 16 | 0 |
233004 | 233004 | 2020-06-12 | Jefferson | Pennsylvania | 42065 | 18 | 1 |
236109 | 236109 | 2020-06-13 | Jefferson | Pennsylvania | 42065 | 18 | 1 |
239217 | 239217 | 2020-06-14 | Jefferson | Pennsylvania | 42065 | 18 | 1 |
242326 | 242326 | 2020-06-15 | Jefferson | Pennsylvania | 42065 | 19 | 1 |
245438 | 245438 | 2020-06-16 | Jefferson | Pennsylvania | 42065 | 19 | 1 |
248551 | 248551 | 2020-06-17 | Jefferson | Pennsylvania | 42065 | 19 | 1 |
251666 | 251666 | 2020-06-18 | Jefferson | Pennsylvania | 42065 | 20 | 1 |
254781 | 254781 | 2020-06-19 | Jefferson | Pennsylvania | 42065 | 20 | 1 |
257907 | 257907 | 2020-06-20 | Jefferson | Pennsylvania | 42065 | 20 | 1 |
261034 | 261034 | 2020-06-21 | Jefferson | Pennsylvania | 42065 | 20 | 1 |
264162 | 264162 | 2020-06-22 | Jefferson | Pennsylvania | 42065 | 20 | 1 |
267290 | 267290 | 2020-06-23 | Jefferson | Pennsylvania | 42065 | 21 | 1 |
270424 | 270424 | 2020-06-24 | Jefferson | Pennsylvania | 42065 | 21 | 1 |
273563 | 273563 | 2020-06-25 | Jefferson | Pennsylvania | 42065 | 21 | 1 |
276710 | 276710 | 2020-06-26 | Jefferson | Pennsylvania | 42065 | 21 | 1 |
279858 | 279858 | 2020-06-27 | Jefferson | Pennsylvania | 42065 | 21 | 1 |
283004 | 283004 | 2020-06-28 | Jefferson | Pennsylvania | 42065 | 21 | 1 |
286149 | 286149 | 2020-06-29 | Jefferson | Pennsylvania | 42065 | 21 | 1 |
289300 | 289300 | 2020-06-30 | Jefferson | Pennsylvania | 42065 | 22 | 1 |
292452 | 292452 | 2020-07-01 | Jefferson | Pennsylvania | 42065 | 24 | 1 |
295608 | 295608 | 2020-07-02 | Jefferson | Pennsylvania | 42065 | 24 | 1 |
298767 | 298767 | 2020-07-03 | Jefferson | Pennsylvania | 42065 | 25 | 1 |
301931 | 301931 | 2020-07-04 | Jefferson | Pennsylvania | 42065 | 28 | 1 |
305094 | 305094 | 2020-07-05 | Jefferson | Pennsylvania | 42065 | 30 | 1 |
308261 | 308261 | 2020-07-06 | Jefferson | Pennsylvania | 42065 | 30 | 1 |
311430 | 311430 | 2020-07-07 | Jefferson | Pennsylvania | 42065 | 30 | 1 |
314602 | 314602 | 2020-07-08 | Jefferson | Pennsylvania | 42065 | 33 | 1 |
317775 | 317775 | 2020-07-09 | Jefferson | Pennsylvania | 42065 | 34 | 1 |
320953 | 320953 | 2020-07-10 | Jefferson | Pennsylvania | 42065 | 37 | 1 |
324133 | 324133 | 2020-07-11 | Jefferson | Pennsylvania | 42065 | 37 | 1 |
327318 | 327318 | 2020-07-12 | Jefferson | Pennsylvania | 42065 | 37 | 1 |
330504 | 330504 | 2020-07-13 | Jefferson | Pennsylvania | 42065 | 39 | 1 |
333696 | 333696 | 2020-07-14 | Jefferson | Pennsylvania | 42065 | 41 | 1 |
336890 | 336890 | 2020-07-15 | Jefferson | Pennsylvania | 42065 | 41 | 1 |
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);