ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Clarion" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388192 | 388192 | 2020-07-31 | Clarion | Pennsylvania | 42031 | 75 | 2 |
384975 | 384975 | 2020-07-30 | Clarion | Pennsylvania | 42031 | 73 | 2 |
381757 | 381757 | 2020-07-29 | Clarion | Pennsylvania | 42031 | 72 | 2 |
378540 | 378540 | 2020-07-28 | Clarion | Pennsylvania | 42031 | 72 | 2 |
375324 | 375324 | 2020-07-27 | Clarion | Pennsylvania | 42031 | 72 | 2 |
372111 | 372111 | 2020-07-26 | Clarion | Pennsylvania | 42031 | 72 | 2 |
368899 | 368899 | 2020-07-25 | Clarion | Pennsylvania | 42031 | 72 | 2 |
365690 | 365690 | 2020-07-24 | Clarion | Pennsylvania | 42031 | 71 | 2 |
362484 | 362484 | 2020-07-23 | Clarion | Pennsylvania | 42031 | 71 | 2 |
359278 | 359278 | 2020-07-22 | Clarion | Pennsylvania | 42031 | 70 | 2 |
356074 | 356074 | 2020-07-21 | Clarion | Pennsylvania | 42031 | 69 | 2 |
352871 | 352871 | 2020-07-20 | Clarion | Pennsylvania | 42031 | 68 | 2 |
349668 | 349668 | 2020-07-19 | Clarion | Pennsylvania | 42031 | 67 | 2 |
346468 | 346468 | 2020-07-18 | Clarion | Pennsylvania | 42031 | 68 | 2 |
343268 | 343268 | 2020-07-17 | Clarion | Pennsylvania | 42031 | 67 | 2 |
340070 | 340070 | 2020-07-16 | Clarion | Pennsylvania | 42031 | 67 | 2 |
336873 | 336873 | 2020-07-15 | Clarion | Pennsylvania | 42031 | 66 | 2 |
333679 | 333679 | 2020-07-14 | Clarion | Pennsylvania | 42031 | 66 | 2 |
330487 | 330487 | 2020-07-13 | Clarion | Pennsylvania | 42031 | 63 | 2 |
327301 | 327301 | 2020-07-12 | Clarion | Pennsylvania | 42031 | 62 | 2 |
324116 | 324116 | 2020-07-11 | Clarion | Pennsylvania | 42031 | 60 | 2 |
320936 | 320936 | 2020-07-10 | Clarion | Pennsylvania | 42031 | 60 | 2 |
317758 | 317758 | 2020-07-09 | Clarion | Pennsylvania | 42031 | 49 | 2 |
314585 | 314585 | 2020-07-08 | Clarion | Pennsylvania | 42031 | 49 | 2 |
311413 | 311413 | 2020-07-07 | Clarion | Pennsylvania | 42031 | 48 | 2 |
308244 | 308244 | 2020-07-06 | Clarion | Pennsylvania | 42031 | 48 | 2 |
305077 | 305077 | 2020-07-05 | Clarion | Pennsylvania | 42031 | 48 | 2 |
301914 | 301914 | 2020-07-04 | Clarion | Pennsylvania | 42031 | 42 | 2 |
298750 | 298750 | 2020-07-03 | Clarion | Pennsylvania | 42031 | 40 | 2 |
295591 | 295591 | 2020-07-02 | Clarion | Pennsylvania | 42031 | 36 | 2 |
292435 | 292435 | 2020-07-01 | Clarion | Pennsylvania | 42031 | 35 | 2 |
289283 | 289283 | 2020-06-30 | Clarion | Pennsylvania | 42031 | 34 | 2 |
286132 | 286132 | 2020-06-29 | Clarion | Pennsylvania | 42031 | 34 | 2 |
282987 | 282987 | 2020-06-28 | Clarion | Pennsylvania | 42031 | 35 | 2 |
279841 | 279841 | 2020-06-27 | Clarion | Pennsylvania | 42031 | 33 | 2 |
276693 | 276693 | 2020-06-26 | Clarion | Pennsylvania | 42031 | 33 | 2 |
273546 | 273546 | 2020-06-25 | Clarion | Pennsylvania | 42031 | 33 | 2 |
270407 | 270407 | 2020-06-24 | Clarion | Pennsylvania | 42031 | 33 | 2 |
267273 | 267273 | 2020-06-23 | Clarion | Pennsylvania | 42031 | 33 | 2 |
264145 | 264145 | 2020-06-22 | Clarion | Pennsylvania | 42031 | 31 | 2 |
261017 | 261017 | 2020-06-21 | Clarion | Pennsylvania | 42031 | 31 | 2 |
257890 | 257890 | 2020-06-20 | Clarion | Pennsylvania | 42031 | 31 | 2 |
254764 | 254764 | 2020-06-19 | Clarion | Pennsylvania | 42031 | 31 | 2 |
251649 | 251649 | 2020-06-18 | Clarion | Pennsylvania | 42031 | 31 | 2 |
248534 | 248534 | 2020-06-17 | Clarion | Pennsylvania | 42031 | 31 | 2 |
245421 | 245421 | 2020-06-16 | Clarion | Pennsylvania | 42031 | 31 | 2 |
242309 | 242309 | 2020-06-15 | Clarion | Pennsylvania | 42031 | 31 | 2 |
239200 | 239200 | 2020-06-14 | Clarion | Pennsylvania | 42031 | 31 | 2 |
236092 | 236092 | 2020-06-13 | Clarion | Pennsylvania | 42031 | 31 | 2 |
232987 | 232987 | 2020-06-12 | Clarion | Pennsylvania | 42031 | 30 | 2 |
229882 | 229882 | 2020-06-11 | Clarion | Pennsylvania | 42031 | 30 | 2 |
226778 | 226778 | 2020-06-10 | Clarion | Pennsylvania | 42031 | 30 | 2 |
223678 | 223678 | 2020-06-09 | Clarion | Pennsylvania | 42031 | 29 | 2 |
220583 | 220583 | 2020-06-08 | Clarion | Pennsylvania | 42031 | 27 | 2 |
217491 | 217491 | 2020-06-07 | Clarion | Pennsylvania | 42031 | 27 | 2 |
214401 | 214401 | 2020-06-06 | Clarion | Pennsylvania | 42031 | 27 | 2 |
211315 | 211315 | 2020-06-05 | Clarion | Pennsylvania | 42031 | 27 | 2 |
208233 | 208233 | 2020-06-04 | Clarion | Pennsylvania | 42031 | 27 | 2 |
205152 | 205152 | 2020-06-03 | Clarion | Pennsylvania | 42031 | 27 | 2 |
202075 | 202075 | 2020-06-02 | Clarion | Pennsylvania | 42031 | 27 | 2 |
199000 | 199000 | 2020-06-01 | Clarion | Pennsylvania | 42031 | 27 | 2 |
195927 | 195927 | 2020-05-31 | Clarion | Pennsylvania | 42031 | 27 | 2 |
192858 | 192858 | 2020-05-30 | Clarion | Pennsylvania | 42031 | 27 | 2 |
189793 | 189793 | 2020-05-29 | Clarion | Pennsylvania | 42031 | 26 | 2 |
186732 | 186732 | 2020-05-28 | Clarion | Pennsylvania | 42031 | 25 | 2 |
183675 | 183675 | 2020-05-27 | Clarion | Pennsylvania | 42031 | 25 | 2 |
180625 | 180625 | 2020-05-26 | Clarion | Pennsylvania | 42031 | 29 | 2 |
177582 | 177582 | 2020-05-25 | Clarion | Pennsylvania | 42031 | 29 | 2 |
174538 | 174538 | 2020-05-24 | Clarion | Pennsylvania | 42031 | 29 | 2 |
171496 | 171496 | 2020-05-23 | Clarion | Pennsylvania | 42031 | 28 | 2 |
168457 | 168457 | 2020-05-22 | Clarion | Pennsylvania | 42031 | 25 | 2 |
165421 | 165421 | 2020-05-21 | Clarion | Pennsylvania | 42031 | 25 | 2 |
162392 | 162392 | 2020-05-20 | Clarion | Pennsylvania | 42031 | 25 | 2 |
159365 | 159365 | 2020-05-19 | Clarion | Pennsylvania | 42031 | 24 | 2 |
156344 | 156344 | 2020-05-18 | Clarion | Pennsylvania | 42031 | 24 | 2 |
153327 | 153327 | 2020-05-17 | Clarion | Pennsylvania | 42031 | 24 | 1 |
150316 | 150316 | 2020-05-16 | Clarion | Pennsylvania | 42031 | 24 | 1 |
147309 | 147309 | 2020-05-15 | Clarion | Pennsylvania | 42031 | 24 | 1 |
144308 | 144308 | 2020-05-14 | Clarion | Pennsylvania | 42031 | 24 | 1 |
141312 | 141312 | 2020-05-13 | Clarion | Pennsylvania | 42031 | 24 | 1 |
138316 | 138316 | 2020-05-12 | Clarion | Pennsylvania | 42031 | 23 | 1 |
135326 | 135326 | 2020-05-11 | Clarion | Pennsylvania | 42031 | 23 | 1 |
132335 | 132335 | 2020-05-10 | Clarion | Pennsylvania | 42031 | 23 | 1 |
129346 | 129346 | 2020-05-09 | Clarion | Pennsylvania | 42031 | 23 | 1 |
126357 | 126357 | 2020-05-08 | Clarion | Pennsylvania | 42031 | 23 | 1 |
123374 | 123374 | 2020-05-07 | Clarion | Pennsylvania | 42031 | 23 | 1 |
120397 | 120397 | 2020-05-06 | Clarion | Pennsylvania | 42031 | 23 | 1 |
117435 | 117435 | 2020-05-05 | Clarion | Pennsylvania | 42031 | 23 | 1 |
114554 | 114554 | 2020-05-04 | Clarion | Pennsylvania | 42031 | 23 | 1 |
111672 | 111672 | 2020-05-03 | Clarion | Pennsylvania | 42031 | 23 | 1 |
108798 | 108798 | 2020-05-02 | Clarion | Pennsylvania | 42031 | 23 | 1 |
105931 | 105931 | 2020-05-01 | Clarion | Pennsylvania | 42031 | 23 | 1 |
103068 | 103068 | 2020-04-30 | Clarion | Pennsylvania | 42031 | 23 | 1 |
100215 | 100215 | 2020-04-29 | Clarion | Pennsylvania | 42031 | 23 | 1 |
97366 | 97366 | 2020-04-28 | Clarion | Pennsylvania | 42031 | 23 | 1 |
94527 | 94527 | 2020-04-27 | Clarion | Pennsylvania | 42031 | 22 | 1 |
91700 | 91700 | 2020-04-26 | Clarion | Pennsylvania | 42031 | 22 | 1 |
88884 | 88884 | 2020-04-25 | Clarion | Pennsylvania | 42031 | 22 | 1 |
86070 | 86070 | 2020-04-24 | Clarion | Pennsylvania | 42031 | 22 | 1 |
83266 | 83266 | 2020-04-23 | Clarion | Pennsylvania | 42031 | 20 | 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);