ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 42031 and state = "Pennsylvania" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
17179 | 17179 | 2020-03-28 | Clarion | Pennsylvania | 42031 | 1 | 0 |
19117 | 19117 | 2020-03-29 | Clarion | Pennsylvania | 42031 | 1 | 0 |
21167 | 21167 | 2020-03-30 | Clarion | Pennsylvania | 42031 | 1 | 0 |
23303 | 23303 | 2020-03-31 | Clarion | Pennsylvania | 42031 | 3 | 0 |
25501 | 25501 | 2020-04-01 | Clarion | Pennsylvania | 42031 | 4 | 0 |
27773 | 27773 | 2020-04-02 | Clarion | Pennsylvania | 42031 | 4 | 0 |
30106 | 30106 | 2020-04-03 | Clarion | Pennsylvania | 42031 | 4 | 0 |
32496 | 32496 | 2020-04-04 | Clarion | Pennsylvania | 42031 | 4 | 0 |
34931 | 34931 | 2020-04-05 | Clarion | Pennsylvania | 42031 | 5 | 0 |
37406 | 37406 | 2020-04-06 | Clarion | Pennsylvania | 42031 | 6 | 0 |
39927 | 39927 | 2020-04-07 | Clarion | Pennsylvania | 42031 | 9 | 0 |
42487 | 42487 | 2020-04-08 | Clarion | Pennsylvania | 42031 | 8 | 0 |
45073 | 45073 | 2020-04-09 | Clarion | Pennsylvania | 42031 | 8 | 0 |
47690 | 47690 | 2020-04-10 | Clarion | Pennsylvania | 42031 | 10 | 0 |
50347 | 50347 | 2020-04-11 | Clarion | Pennsylvania | 42031 | 15 | 0 |
53020 | 53020 | 2020-04-12 | Clarion | Pennsylvania | 42031 | 15 | 0 |
55705 | 55705 | 2020-04-13 | Clarion | Pennsylvania | 42031 | 16 | 0 |
58408 | 58408 | 2020-04-14 | Clarion | Pennsylvania | 42031 | 16 | 0 |
61123 | 61123 | 2020-04-15 | Clarion | Pennsylvania | 42031 | 16 | 0 |
63849 | 63849 | 2020-04-16 | Clarion | Pennsylvania | 42031 | 17 | 0 |
66595 | 66595 | 2020-04-17 | Clarion | Pennsylvania | 42031 | 18 | 0 |
69353 | 69353 | 2020-04-18 | Clarion | Pennsylvania | 42031 | 18 | 1 |
72120 | 72120 | 2020-04-19 | Clarion | Pennsylvania | 42031 | 18 | 1 |
74895 | 74895 | 2020-04-20 | Clarion | Pennsylvania | 42031 | 18 | 1 |
77677 | 77677 | 2020-04-21 | Clarion | Pennsylvania | 42031 | 18 | 1 |
80467 | 80467 | 2020-04-22 | Clarion | Pennsylvania | 42031 | 19 | 1 |
83266 | 83266 | 2020-04-23 | Clarion | Pennsylvania | 42031 | 20 | 1 |
86070 | 86070 | 2020-04-24 | Clarion | Pennsylvania | 42031 | 22 | 1 |
88884 | 88884 | 2020-04-25 | Clarion | Pennsylvania | 42031 | 22 | 1 |
91700 | 91700 | 2020-04-26 | Clarion | Pennsylvania | 42031 | 22 | 1 |
94527 | 94527 | 2020-04-27 | Clarion | Pennsylvania | 42031 | 22 | 1 |
97366 | 97366 | 2020-04-28 | Clarion | Pennsylvania | 42031 | 23 | 1 |
100215 | 100215 | 2020-04-29 | Clarion | Pennsylvania | 42031 | 23 | 1 |
103068 | 103068 | 2020-04-30 | Clarion | Pennsylvania | 42031 | 23 | 1 |
105931 | 105931 | 2020-05-01 | Clarion | Pennsylvania | 42031 | 23 | 1 |
108798 | 108798 | 2020-05-02 | Clarion | Pennsylvania | 42031 | 23 | 1 |
111672 | 111672 | 2020-05-03 | Clarion | Pennsylvania | 42031 | 23 | 1 |
114554 | 114554 | 2020-05-04 | Clarion | Pennsylvania | 42031 | 23 | 1 |
117435 | 117435 | 2020-05-05 | Clarion | Pennsylvania | 42031 | 23 | 1 |
120397 | 120397 | 2020-05-06 | Clarion | Pennsylvania | 42031 | 23 | 1 |
123374 | 123374 | 2020-05-07 | Clarion | Pennsylvania | 42031 | 23 | 1 |
126357 | 126357 | 2020-05-08 | Clarion | Pennsylvania | 42031 | 23 | 1 |
129346 | 129346 | 2020-05-09 | Clarion | Pennsylvania | 42031 | 23 | 1 |
132335 | 132335 | 2020-05-10 | Clarion | Pennsylvania | 42031 | 23 | 1 |
135326 | 135326 | 2020-05-11 | Clarion | Pennsylvania | 42031 | 23 | 1 |
138316 | 138316 | 2020-05-12 | Clarion | Pennsylvania | 42031 | 23 | 1 |
141312 | 141312 | 2020-05-13 | Clarion | Pennsylvania | 42031 | 24 | 1 |
144308 | 144308 | 2020-05-14 | Clarion | Pennsylvania | 42031 | 24 | 1 |
147309 | 147309 | 2020-05-15 | Clarion | Pennsylvania | 42031 | 24 | 1 |
150316 | 150316 | 2020-05-16 | Clarion | Pennsylvania | 42031 | 24 | 1 |
153327 | 153327 | 2020-05-17 | Clarion | Pennsylvania | 42031 | 24 | 1 |
156344 | 156344 | 2020-05-18 | Clarion | Pennsylvania | 42031 | 24 | 2 |
159365 | 159365 | 2020-05-19 | Clarion | Pennsylvania | 42031 | 24 | 2 |
162392 | 162392 | 2020-05-20 | Clarion | Pennsylvania | 42031 | 25 | 2 |
165421 | 165421 | 2020-05-21 | Clarion | Pennsylvania | 42031 | 25 | 2 |
168457 | 168457 | 2020-05-22 | Clarion | Pennsylvania | 42031 | 25 | 2 |
171496 | 171496 | 2020-05-23 | Clarion | Pennsylvania | 42031 | 28 | 2 |
174538 | 174538 | 2020-05-24 | Clarion | Pennsylvania | 42031 | 29 | 2 |
177582 | 177582 | 2020-05-25 | Clarion | Pennsylvania | 42031 | 29 | 2 |
180625 | 180625 | 2020-05-26 | Clarion | Pennsylvania | 42031 | 29 | 2 |
183675 | 183675 | 2020-05-27 | Clarion | Pennsylvania | 42031 | 25 | 2 |
186732 | 186732 | 2020-05-28 | Clarion | Pennsylvania | 42031 | 25 | 2 |
189793 | 189793 | 2020-05-29 | Clarion | Pennsylvania | 42031 | 26 | 2 |
192858 | 192858 | 2020-05-30 | Clarion | Pennsylvania | 42031 | 27 | 2 |
195927 | 195927 | 2020-05-31 | Clarion | Pennsylvania | 42031 | 27 | 2 |
199000 | 199000 | 2020-06-01 | Clarion | Pennsylvania | 42031 | 27 | 2 |
202075 | 202075 | 2020-06-02 | Clarion | Pennsylvania | 42031 | 27 | 2 |
205152 | 205152 | 2020-06-03 | Clarion | Pennsylvania | 42031 | 27 | 2 |
208233 | 208233 | 2020-06-04 | Clarion | Pennsylvania | 42031 | 27 | 2 |
211315 | 211315 | 2020-06-05 | Clarion | Pennsylvania | 42031 | 27 | 2 |
214401 | 214401 | 2020-06-06 | Clarion | Pennsylvania | 42031 | 27 | 2 |
217491 | 217491 | 2020-06-07 | Clarion | Pennsylvania | 42031 | 27 | 2 |
220583 | 220583 | 2020-06-08 | Clarion | Pennsylvania | 42031 | 27 | 2 |
223678 | 223678 | 2020-06-09 | Clarion | Pennsylvania | 42031 | 29 | 2 |
226778 | 226778 | 2020-06-10 | Clarion | Pennsylvania | 42031 | 30 | 2 |
229882 | 229882 | 2020-06-11 | Clarion | Pennsylvania | 42031 | 30 | 2 |
232987 | 232987 | 2020-06-12 | Clarion | Pennsylvania | 42031 | 30 | 2 |
236092 | 236092 | 2020-06-13 | Clarion | Pennsylvania | 42031 | 31 | 2 |
239200 | 239200 | 2020-06-14 | Clarion | Pennsylvania | 42031 | 31 | 2 |
242309 | 242309 | 2020-06-15 | Clarion | Pennsylvania | 42031 | 31 | 2 |
245421 | 245421 | 2020-06-16 | Clarion | Pennsylvania | 42031 | 31 | 2 |
248534 | 248534 | 2020-06-17 | Clarion | Pennsylvania | 42031 | 31 | 2 |
251649 | 251649 | 2020-06-18 | Clarion | Pennsylvania | 42031 | 31 | 2 |
254764 | 254764 | 2020-06-19 | Clarion | Pennsylvania | 42031 | 31 | 2 |
257890 | 257890 | 2020-06-20 | Clarion | Pennsylvania | 42031 | 31 | 2 |
261017 | 261017 | 2020-06-21 | Clarion | Pennsylvania | 42031 | 31 | 2 |
264145 | 264145 | 2020-06-22 | Clarion | Pennsylvania | 42031 | 31 | 2 |
267273 | 267273 | 2020-06-23 | Clarion | Pennsylvania | 42031 | 33 | 2 |
270407 | 270407 | 2020-06-24 | Clarion | Pennsylvania | 42031 | 33 | 2 |
273546 | 273546 | 2020-06-25 | Clarion | Pennsylvania | 42031 | 33 | 2 |
276693 | 276693 | 2020-06-26 | Clarion | Pennsylvania | 42031 | 33 | 2 |
279841 | 279841 | 2020-06-27 | Clarion | Pennsylvania | 42031 | 33 | 2 |
282987 | 282987 | 2020-06-28 | Clarion | Pennsylvania | 42031 | 35 | 2 |
286132 | 286132 | 2020-06-29 | Clarion | Pennsylvania | 42031 | 34 | 2 |
289283 | 289283 | 2020-06-30 | Clarion | Pennsylvania | 42031 | 34 | 2 |
292435 | 292435 | 2020-07-01 | Clarion | Pennsylvania | 42031 | 35 | 2 |
295591 | 295591 | 2020-07-02 | Clarion | Pennsylvania | 42031 | 36 | 2 |
298750 | 298750 | 2020-07-03 | Clarion | Pennsylvania | 42031 | 40 | 2 |
301914 | 301914 | 2020-07-04 | Clarion | Pennsylvania | 42031 | 42 | 2 |
305077 | 305077 | 2020-07-05 | Clarion | Pennsylvania | 42031 | 48 | 2 |
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);