ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
104 rows where county = "Fayette", deaths = 4 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
404285 | 404285 | 2020-08-05 | Fayette | Pennsylvania | 42051 | 431 | 4 |
401067 | 401067 | 2020-08-04 | Fayette | Pennsylvania | 42051 | 423 | 4 |
397852 | 397852 | 2020-08-03 | Fayette | Pennsylvania | 42051 | 414 | 4 |
394635 | 394635 | 2020-08-02 | Fayette | Pennsylvania | 42051 | 408 | 4 |
391419 | 391419 | 2020-08-01 | Fayette | Pennsylvania | 42051 | 403 | 4 |
388202 | 388202 | 2020-07-31 | Fayette | Pennsylvania | 42051 | 387 | 4 |
384985 | 384985 | 2020-07-30 | Fayette | Pennsylvania | 42051 | 363 | 4 |
381767 | 381767 | 2020-07-29 | Fayette | Pennsylvania | 42051 | 352 | 4 |
378550 | 378550 | 2020-07-28 | Fayette | Pennsylvania | 42051 | 336 | 4 |
375334 | 375334 | 2020-07-27 | Fayette | Pennsylvania | 42051 | 314 | 4 |
372121 | 372121 | 2020-07-26 | Fayette | Pennsylvania | 42051 | 311 | 4 |
368909 | 368909 | 2020-07-25 | Fayette | Pennsylvania | 42051 | 307 | 4 |
365700 | 365700 | 2020-07-24 | Fayette | Pennsylvania | 42051 | 301 | 4 |
362494 | 362494 | 2020-07-23 | Fayette | Pennsylvania | 42051 | 294 | 4 |
359288 | 359288 | 2020-07-22 | Fayette | Pennsylvania | 42051 | 288 | 4 |
356084 | 356084 | 2020-07-21 | Fayette | Pennsylvania | 42051 | 279 | 4 |
352881 | 352881 | 2020-07-20 | Fayette | Pennsylvania | 42051 | 272 | 4 |
349678 | 349678 | 2020-07-19 | Fayette | Pennsylvania | 42051 | 262 | 4 |
346478 | 346478 | 2020-07-18 | Fayette | Pennsylvania | 42051 | 255 | 4 |
343278 | 343278 | 2020-07-17 | Fayette | Pennsylvania | 42051 | 235 | 4 |
340080 | 340080 | 2020-07-16 | Fayette | Pennsylvania | 42051 | 223 | 4 |
336883 | 336883 | 2020-07-15 | Fayette | Pennsylvania | 42051 | 220 | 4 |
333689 | 333689 | 2020-07-14 | Fayette | Pennsylvania | 42051 | 213 | 4 |
330497 | 330497 | 2020-07-13 | Fayette | Pennsylvania | 42051 | 202 | 4 |
327311 | 327311 | 2020-07-12 | Fayette | Pennsylvania | 42051 | 196 | 4 |
324126 | 324126 | 2020-07-11 | Fayette | Pennsylvania | 42051 | 194 | 4 |
320946 | 320946 | 2020-07-10 | Fayette | Pennsylvania | 42051 | 178 | 4 |
317768 | 317768 | 2020-07-09 | Fayette | Pennsylvania | 42051 | 163 | 4 |
314595 | 314595 | 2020-07-08 | Fayette | Pennsylvania | 42051 | 160 | 4 |
311423 | 311423 | 2020-07-07 | Fayette | Pennsylvania | 42051 | 149 | 4 |
308254 | 308254 | 2020-07-06 | Fayette | Pennsylvania | 42051 | 147 | 4 |
305087 | 305087 | 2020-07-05 | Fayette | Pennsylvania | 42051 | 140 | 4 |
301924 | 301924 | 2020-07-04 | Fayette | Pennsylvania | 42051 | 135 | 4 |
298760 | 298760 | 2020-07-03 | Fayette | Pennsylvania | 42051 | 132 | 4 |
295601 | 295601 | 2020-07-02 | Fayette | Pennsylvania | 42051 | 127 | 4 |
292445 | 292445 | 2020-07-01 | Fayette | Pennsylvania | 42051 | 117 | 4 |
289293 | 289293 | 2020-06-30 | Fayette | Pennsylvania | 42051 | 116 | 4 |
286142 | 286142 | 2020-06-29 | Fayette | Pennsylvania | 42051 | 112 | 4 |
282997 | 282997 | 2020-06-28 | Fayette | Pennsylvania | 42051 | 111 | 4 |
279851 | 279851 | 2020-06-27 | Fayette | Pennsylvania | 42051 | 110 | 4 |
276703 | 276703 | 2020-06-26 | Fayette | Pennsylvania | 42051 | 106 | 4 |
273556 | 273556 | 2020-06-25 | Fayette | Pennsylvania | 42051 | 104 | 4 |
270417 | 270417 | 2020-06-24 | Fayette | Pennsylvania | 42051 | 104 | 4 |
267283 | 267283 | 2020-06-23 | Fayette | Pennsylvania | 42051 | 104 | 4 |
264155 | 264155 | 2020-06-22 | Fayette | Pennsylvania | 42051 | 104 | 4 |
261027 | 261027 | 2020-06-21 | Fayette | Pennsylvania | 42051 | 104 | 4 |
257900 | 257900 | 2020-06-20 | Fayette | Pennsylvania | 42051 | 103 | 4 |
254774 | 254774 | 2020-06-19 | Fayette | Pennsylvania | 42051 | 103 | 4 |
251659 | 251659 | 2020-06-18 | Fayette | Pennsylvania | 42051 | 100 | 4 |
248544 | 248544 | 2020-06-17 | Fayette | Pennsylvania | 42051 | 98 | 4 |
245431 | 245431 | 2020-06-16 | Fayette | Pennsylvania | 42051 | 95 | 4 |
242319 | 242319 | 2020-06-15 | Fayette | Pennsylvania | 42051 | 95 | 4 |
239210 | 239210 | 2020-06-14 | Fayette | Pennsylvania | 42051 | 95 | 4 |
236102 | 236102 | 2020-06-13 | Fayette | Pennsylvania | 42051 | 95 | 4 |
232997 | 232997 | 2020-06-12 | Fayette | Pennsylvania | 42051 | 95 | 4 |
229892 | 229892 | 2020-06-11 | Fayette | Pennsylvania | 42051 | 96 | 4 |
226788 | 226788 | 2020-06-10 | Fayette | Pennsylvania | 42051 | 95 | 4 |
223688 | 223688 | 2020-06-09 | Fayette | Pennsylvania | 42051 | 95 | 4 |
220593 | 220593 | 2020-06-08 | Fayette | Pennsylvania | 42051 | 95 | 4 |
217501 | 217501 | 2020-06-07 | Fayette | Pennsylvania | 42051 | 95 | 4 |
214411 | 214411 | 2020-06-06 | Fayette | Pennsylvania | 42051 | 95 | 4 |
211325 | 211325 | 2020-06-05 | Fayette | Pennsylvania | 42051 | 95 | 4 |
208243 | 208243 | 2020-06-04 | Fayette | Pennsylvania | 42051 | 95 | 4 |
205162 | 205162 | 2020-06-03 | Fayette | Pennsylvania | 42051 | 95 | 4 |
202085 | 202085 | 2020-06-02 | Fayette | Pennsylvania | 42051 | 95 | 4 |
199010 | 199010 | 2020-06-01 | Fayette | Pennsylvania | 42051 | 95 | 4 |
195937 | 195937 | 2020-05-31 | Fayette | Pennsylvania | 42051 | 95 | 4 |
192868 | 192868 | 2020-05-30 | Fayette | Pennsylvania | 42051 | 95 | 4 |
189803 | 189803 | 2020-05-29 | Fayette | Pennsylvania | 42051 | 95 | 4 |
186742 | 186742 | 2020-05-28 | Fayette | Pennsylvania | 42051 | 95 | 4 |
183685 | 183685 | 2020-05-27 | Fayette | Pennsylvania | 42051 | 95 | 4 |
180635 | 180635 | 2020-05-26 | Fayette | Pennsylvania | 42051 | 95 | 4 |
177592 | 177592 | 2020-05-25 | Fayette | Pennsylvania | 42051 | 94 | 4 |
174548 | 174548 | 2020-05-24 | Fayette | Pennsylvania | 42051 | 94 | 4 |
171506 | 171506 | 2020-05-23 | Fayette | Pennsylvania | 42051 | 94 | 4 |
168467 | 168467 | 2020-05-22 | Fayette | Pennsylvania | 42051 | 93 | 4 |
165431 | 165431 | 2020-05-21 | Fayette | Pennsylvania | 42051 | 93 | 4 |
162402 | 162402 | 2020-05-20 | Fayette | Pennsylvania | 42051 | 93 | 4 |
159375 | 159375 | 2020-05-19 | Fayette | Pennsylvania | 42051 | 92 | 4 |
156354 | 156354 | 2020-05-18 | Fayette | Pennsylvania | 42051 | 91 | 4 |
153337 | 153337 | 2020-05-17 | Fayette | Pennsylvania | 42051 | 89 | 4 |
150326 | 150326 | 2020-05-16 | Fayette | Pennsylvania | 42051 | 88 | 4 |
147319 | 147319 | 2020-05-15 | Fayette | Pennsylvania | 42051 | 87 | 4 |
144318 | 144318 | 2020-05-14 | Fayette | Pennsylvania | 42051 | 87 | 4 |
141322 | 141322 | 2020-05-13 | Fayette | Pennsylvania | 42051 | 85 | 4 |
138326 | 138326 | 2020-05-12 | Fayette | Pennsylvania | 42051 | 85 | 4 |
135336 | 135336 | 2020-05-11 | Fayette | Pennsylvania | 42051 | 85 | 4 |
132345 | 132345 | 2020-05-10 | Fayette | Pennsylvania | 42051 | 85 | 4 |
129356 | 129356 | 2020-05-09 | Fayette | Pennsylvania | 42051 | 85 | 4 |
126367 | 126367 | 2020-05-08 | Fayette | Pennsylvania | 42051 | 84 | 4 |
123384 | 123384 | 2020-05-07 | Fayette | Pennsylvania | 42051 | 84 | 4 |
120407 | 120407 | 2020-05-06 | Fayette | Pennsylvania | 42051 | 84 | 4 |
117445 | 117445 | 2020-05-05 | Fayette | Pennsylvania | 42051 | 84 | 4 |
114564 | 114564 | 2020-05-04 | Fayette | Pennsylvania | 42051 | 83 | 4 |
111682 | 111682 | 2020-05-03 | Fayette | Pennsylvania | 42051 | 83 | 4 |
108808 | 108808 | 2020-05-02 | Fayette | Pennsylvania | 42051 | 82 | 4 |
105941 | 105941 | 2020-05-01 | Fayette | Pennsylvania | 42051 | 81 | 4 |
103078 | 103078 | 2020-04-30 | Fayette | Pennsylvania | 42051 | 80 | 4 |
100225 | 100225 | 2020-04-29 | Fayette | Pennsylvania | 42051 | 80 | 4 |
97376 | 97376 | 2020-04-28 | Fayette | Pennsylvania | 42051 | 79 | 4 |
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);