ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 42027 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388190 | 388190 | 2020-07-31 | Centre | Pennsylvania | 42027 | 357 | 10 |
384973 | 384973 | 2020-07-30 | Centre | Pennsylvania | 42027 | 353 | 10 |
381755 | 381755 | 2020-07-29 | Centre | Pennsylvania | 42027 | 370 | 10 |
378538 | 378538 | 2020-07-28 | Centre | Pennsylvania | 42027 | 365 | 10 |
375322 | 375322 | 2020-07-27 | Centre | Pennsylvania | 42027 | 357 | 9 |
372109 | 372109 | 2020-07-26 | Centre | Pennsylvania | 42027 | 356 | 9 |
368897 | 368897 | 2020-07-25 | Centre | Pennsylvania | 42027 | 313 | 9 |
365688 | 365688 | 2020-07-24 | Centre | Pennsylvania | 42027 | 306 | 9 |
362482 | 362482 | 2020-07-23 | Centre | Pennsylvania | 42027 | 304 | 9 |
359276 | 359276 | 2020-07-22 | Centre | Pennsylvania | 42027 | 299 | 9 |
356072 | 356072 | 2020-07-21 | Centre | Pennsylvania | 42027 | 294 | 9 |
352869 | 352869 | 2020-07-20 | Centre | Pennsylvania | 42027 | 288 | 9 |
349666 | 349666 | 2020-07-19 | Centre | Pennsylvania | 42027 | 279 | 9 |
346466 | 346466 | 2020-07-18 | Centre | Pennsylvania | 42027 | 277 | 9 |
343266 | 343266 | 2020-07-17 | Centre | Pennsylvania | 42027 | 270 | 9 |
340068 | 340068 | 2020-07-16 | Centre | Pennsylvania | 42027 | 262 | 9 |
336871 | 336871 | 2020-07-15 | Centre | Pennsylvania | 42027 | 262 | 8 |
333677 | 333677 | 2020-07-14 | Centre | Pennsylvania | 42027 | 253 | 8 |
330485 | 330485 | 2020-07-13 | Centre | Pennsylvania | 42027 | 251 | 8 |
327299 | 327299 | 2020-07-12 | Centre | Pennsylvania | 42027 | 243 | 8 |
324114 | 324114 | 2020-07-11 | Centre | Pennsylvania | 42027 | 241 | 8 |
320934 | 320934 | 2020-07-10 | Centre | Pennsylvania | 42027 | 239 | 8 |
317756 | 317756 | 2020-07-09 | Centre | Pennsylvania | 42027 | 235 | 8 |
314583 | 314583 | 2020-07-08 | Centre | Pennsylvania | 42027 | 232 | 8 |
311411 | 311411 | 2020-07-07 | Centre | Pennsylvania | 42027 | 230 | 8 |
308242 | 308242 | 2020-07-06 | Centre | Pennsylvania | 42027 | 228 | 8 |
305075 | 305075 | 2020-07-05 | Centre | Pennsylvania | 42027 | 227 | 8 |
301912 | 301912 | 2020-07-04 | Centre | Pennsylvania | 42027 | 224 | 7 |
298748 | 298748 | 2020-07-03 | Centre | Pennsylvania | 42027 | 218 | 7 |
295589 | 295589 | 2020-07-02 | Centre | Pennsylvania | 42027 | 211 | 7 |
292433 | 292433 | 2020-07-01 | Centre | Pennsylvania | 42027 | 205 | 7 |
289281 | 289281 | 2020-06-30 | Centre | Pennsylvania | 42027 | 201 | 7 |
286130 | 286130 | 2020-06-29 | Centre | Pennsylvania | 42027 | 201 | 7 |
282985 | 282985 | 2020-06-28 | Centre | Pennsylvania | 42027 | 201 | 7 |
279839 | 279839 | 2020-06-27 | Centre | Pennsylvania | 42027 | 200 | 7 |
276691 | 276691 | 2020-06-26 | Centre | Pennsylvania | 42027 | 198 | 6 |
273544 | 273544 | 2020-06-25 | Centre | Pennsylvania | 42027 | 197 | 6 |
270405 | 270405 | 2020-06-24 | Centre | Pennsylvania | 42027 | 196 | 6 |
267271 | 267271 | 2020-06-23 | Centre | Pennsylvania | 42027 | 195 | 6 |
264143 | 264143 | 2020-06-22 | Centre | Pennsylvania | 42027 | 184 | 6 |
261015 | 261015 | 2020-06-21 | Centre | Pennsylvania | 42027 | 180 | 6 |
257888 | 257888 | 2020-06-20 | Centre | Pennsylvania | 42027 | 180 | 6 |
254762 | 254762 | 2020-06-19 | Centre | Pennsylvania | 42027 | 176 | 6 |
251647 | 251647 | 2020-06-18 | Centre | Pennsylvania | 42027 | 172 | 6 |
248532 | 248532 | 2020-06-17 | Centre | Pennsylvania | 42027 | 172 | 6 |
245419 | 245419 | 2020-06-16 | Centre | Pennsylvania | 42027 | 177 | 6 |
242307 | 242307 | 2020-06-15 | Centre | Pennsylvania | 42027 | 171 | 6 |
239198 | 239198 | 2020-06-14 | Centre | Pennsylvania | 42027 | 169 | 7 |
236090 | 236090 | 2020-06-13 | Centre | Pennsylvania | 42027 | 167 | 7 |
232985 | 232985 | 2020-06-12 | Centre | Pennsylvania | 42027 | 165 | 7 |
229880 | 229880 | 2020-06-11 | Centre | Pennsylvania | 42027 | 158 | 7 |
226776 | 226776 | 2020-06-10 | Centre | Pennsylvania | 42027 | 158 | 7 |
223676 | 223676 | 2020-06-09 | Centre | Pennsylvania | 42027 | 157 | 7 |
220581 | 220581 | 2020-06-08 | Centre | Pennsylvania | 42027 | 157 | 7 |
217489 | 217489 | 2020-06-07 | Centre | Pennsylvania | 42027 | 156 | 7 |
214399 | 214399 | 2020-06-06 | Centre | Pennsylvania | 42027 | 155 | 7 |
211313 | 211313 | 2020-06-05 | Centre | Pennsylvania | 42027 | 154 | 7 |
208231 | 208231 | 2020-06-04 | Centre | Pennsylvania | 42027 | 154 | 7 |
205150 | 205150 | 2020-06-03 | Centre | Pennsylvania | 42027 | 154 | 7 |
202073 | 202073 | 2020-06-02 | Centre | Pennsylvania | 42027 | 154 | 7 |
198998 | 198998 | 2020-06-01 | Centre | Pennsylvania | 42027 | 154 | 7 |
195925 | 195925 | 2020-05-31 | Centre | Pennsylvania | 42027 | 153 | 7 |
192856 | 192856 | 2020-05-30 | Centre | Pennsylvania | 42027 | 152 | 7 |
189791 | 189791 | 2020-05-29 | Centre | Pennsylvania | 42027 | 151 | 6 |
186730 | 186730 | 2020-05-28 | Centre | Pennsylvania | 42027 | 150 | 6 |
183673 | 183673 | 2020-05-27 | Centre | Pennsylvania | 42027 | 149 | 6 |
180623 | 180623 | 2020-05-26 | Centre | Pennsylvania | 42027 | 148 | 6 |
177580 | 177580 | 2020-05-25 | Centre | Pennsylvania | 42027 | 147 | 6 |
174536 | 174536 | 2020-05-24 | Centre | Pennsylvania | 42027 | 146 | 6 |
171494 | 171494 | 2020-05-23 | Centre | Pennsylvania | 42027 | 143 | 6 |
168455 | 168455 | 2020-05-22 | Centre | Pennsylvania | 42027 | 138 | 5 |
165419 | 165419 | 2020-05-21 | Centre | Pennsylvania | 42027 | 136 | 5 |
162390 | 162390 | 2020-05-20 | Centre | Pennsylvania | 42027 | 133 | 5 |
159363 | 159363 | 2020-05-19 | Centre | Pennsylvania | 42027 | 132 | 5 |
156342 | 156342 | 2020-05-18 | Centre | Pennsylvania | 42027 | 133 | 5 |
153325 | 153325 | 2020-05-17 | Centre | Pennsylvania | 42027 | 131 | 6 |
150314 | 150314 | 2020-05-16 | Centre | Pennsylvania | 42027 | 129 | 6 |
147307 | 147307 | 2020-05-15 | Centre | Pennsylvania | 42027 | 129 | 6 |
144306 | 144306 | 2020-05-14 | Centre | Pennsylvania | 42027 | 128 | 6 |
141310 | 141310 | 2020-05-13 | Centre | Pennsylvania | 42027 | 126 | 4 |
138314 | 138314 | 2020-05-12 | Centre | Pennsylvania | 42027 | 122 | 2 |
135324 | 135324 | 2020-05-11 | Centre | Pennsylvania | 42027 | 119 | 2 |
132333 | 132333 | 2020-05-10 | Centre | Pennsylvania | 42027 | 119 | 2 |
129344 | 129344 | 2020-05-09 | Centre | Pennsylvania | 42027 | 117 | 2 |
126355 | 126355 | 2020-05-08 | Centre | Pennsylvania | 42027 | 117 | 2 |
123372 | 123372 | 2020-05-07 | Centre | Pennsylvania | 42027 | 116 | 2 |
120395 | 120395 | 2020-05-06 | Centre | Pennsylvania | 42027 | 113 | 2 |
117433 | 117433 | 2020-05-05 | Centre | Pennsylvania | 42027 | 106 | 2 |
114552 | 114552 | 2020-05-04 | Centre | Pennsylvania | 42027 | 105 | 2 |
111670 | 111670 | 2020-05-03 | Centre | Pennsylvania | 42027 | 102 | 2 |
108796 | 108796 | 2020-05-02 | Centre | Pennsylvania | 42027 | 96 | 2 |
105929 | 105929 | 2020-05-01 | Centre | Pennsylvania | 42027 | 96 | 2 |
103066 | 103066 | 2020-04-30 | Centre | Pennsylvania | 42027 | 96 | 2 |
100213 | 100213 | 2020-04-29 | Centre | Pennsylvania | 42027 | 95 | 2 |
97364 | 97364 | 2020-04-28 | Centre | Pennsylvania | 42027 | 93 | 2 |
94525 | 94525 | 2020-04-27 | Centre | Pennsylvania | 42027 | 87 | 2 |
91698 | 91698 | 2020-04-26 | Centre | Pennsylvania | 42027 | 81 | 2 |
88882 | 88882 | 2020-04-25 | Centre | Pennsylvania | 42027 | 81 | 2 |
86068 | 86068 | 2020-04-24 | Centre | Pennsylvania | 42027 | 77 | 2 |
83264 | 83264 | 2020-04-23 | Centre | Pennsylvania | 42027 | 76 | 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);