ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Wayne" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536740 | 536740 | 2020-09-15 | Wayne | Pennsylvania | 42127 | 204 | 10 |
533504 | 533504 | 2020-09-14 | Wayne | Pennsylvania | 42127 | 202 | 10 |
530269 | 530269 | 2020-09-13 | Wayne | Pennsylvania | 42127 | 201 | 10 |
527032 | 527032 | 2020-09-12 | Wayne | Pennsylvania | 42127 | 201 | 10 |
523796 | 523796 | 2020-09-11 | Wayne | Pennsylvania | 42127 | 198 | 10 |
520560 | 520560 | 2020-09-10 | Wayne | Pennsylvania | 42127 | 195 | 10 |
517324 | 517324 | 2020-09-09 | Wayne | Pennsylvania | 42127 | 196 | 10 |
514089 | 514089 | 2020-09-08 | Wayne | Pennsylvania | 42127 | 195 | 10 |
510856 | 510856 | 2020-09-07 | Wayne | Pennsylvania | 42127 | 195 | 10 |
507623 | 507623 | 2020-09-06 | Wayne | Pennsylvania | 42127 | 192 | 10 |
504391 | 504391 | 2020-09-05 | Wayne | Pennsylvania | 42127 | 188 | 10 |
501157 | 501157 | 2020-09-04 | Wayne | Pennsylvania | 42127 | 185 | 10 |
497923 | 497923 | 2020-09-03 | Wayne | Pennsylvania | 42127 | 181 | 10 |
494690 | 494690 | 2020-09-02 | Wayne | Pennsylvania | 42127 | 181 | 10 |
491456 | 491456 | 2020-09-01 | Wayne | Pennsylvania | 42127 | 178 | 10 |
488223 | 488223 | 2020-08-31 | Wayne | Pennsylvania | 42127 | 175 | 10 |
484990 | 484990 | 2020-08-30 | Wayne | Pennsylvania | 42127 | 175 | 10 |
481755 | 481755 | 2020-08-29 | Wayne | Pennsylvania | 42127 | 177 | 10 |
478521 | 478521 | 2020-08-28 | Wayne | Pennsylvania | 42127 | 176 | 10 |
475288 | 475288 | 2020-08-27 | Wayne | Pennsylvania | 42127 | 175 | 10 |
472054 | 472054 | 2020-08-26 | Wayne | Pennsylvania | 42127 | 175 | 10 |
468822 | 468822 | 2020-08-25 | Wayne | Pennsylvania | 42127 | 175 | 10 |
465594 | 465594 | 2020-08-24 | Wayne | Pennsylvania | 42127 | 171 | 10 |
462365 | 462365 | 2020-08-23 | Wayne | Pennsylvania | 42127 | 170 | 10 |
459137 | 459137 | 2020-08-22 | Wayne | Pennsylvania | 42127 | 169 | 10 |
455909 | 455909 | 2020-08-21 | Wayne | Pennsylvania | 42127 | 169 | 10 |
452681 | 452681 | 2020-08-20 | Wayne | Pennsylvania | 42127 | 168 | 10 |
449453 | 449453 | 2020-08-19 | Wayne | Pennsylvania | 42127 | 165 | 10 |
446225 | 446225 | 2020-08-18 | Wayne | Pennsylvania | 42127 | 165 | 10 |
442999 | 442999 | 2020-08-17 | Wayne | Pennsylvania | 42127 | 164 | 10 |
439772 | 439772 | 2020-08-16 | Wayne | Pennsylvania | 42127 | 164 | 10 |
436547 | 436547 | 2020-08-15 | Wayne | Pennsylvania | 42127 | 162 | 10 |
433320 | 433320 | 2020-08-14 | Wayne | Pennsylvania | 42127 | 162 | 10 |
430094 | 430094 | 2020-08-13 | Wayne | Pennsylvania | 42127 | 162 | 10 |
426869 | 426869 | 2020-08-12 | Wayne | Pennsylvania | 42127 | 162 | 10 |
423646 | 423646 | 2020-08-11 | Wayne | Pennsylvania | 42127 | 162 | 10 |
420423 | 420423 | 2020-08-10 | Wayne | Pennsylvania | 42127 | 162 | 9 |
417203 | 417203 | 2020-08-09 | Wayne | Pennsylvania | 42127 | 160 | 9 |
413982 | 413982 | 2020-08-08 | Wayne | Pennsylvania | 42127 | 160 | 9 |
410762 | 410762 | 2020-08-07 | Wayne | Pennsylvania | 42127 | 158 | 9 |
407542 | 407542 | 2020-08-06 | Wayne | Pennsylvania | 42127 | 157 | 8 |
404323 | 404323 | 2020-08-05 | Wayne | Pennsylvania | 42127 | 157 | 8 |
401105 | 401105 | 2020-08-04 | Wayne | Pennsylvania | 42127 | 157 | 8 |
397890 | 397890 | 2020-08-03 | Wayne | Pennsylvania | 42127 | 158 | 8 |
394673 | 394673 | 2020-08-02 | Wayne | Pennsylvania | 42127 | 158 | 8 |
391457 | 391457 | 2020-08-01 | Wayne | Pennsylvania | 42127 | 158 | 8 |
388240 | 388240 | 2020-07-31 | Wayne | Pennsylvania | 42127 | 158 | 8 |
385023 | 385023 | 2020-07-30 | Wayne | Pennsylvania | 42127 | 157 | 8 |
381805 | 381805 | 2020-07-29 | Wayne | Pennsylvania | 42127 | 156 | 8 |
378588 | 378588 | 2020-07-28 | Wayne | Pennsylvania | 42127 | 154 | 8 |
375372 | 375372 | 2020-07-27 | Wayne | Pennsylvania | 42127 | 154 | 8 |
372159 | 372159 | 2020-07-26 | Wayne | Pennsylvania | 42127 | 153 | 8 |
368947 | 368947 | 2020-07-25 | Wayne | Pennsylvania | 42127 | 152 | 8 |
365738 | 365738 | 2020-07-24 | Wayne | Pennsylvania | 42127 | 151 | 8 |
362532 | 362532 | 2020-07-23 | Wayne | Pennsylvania | 42127 | 151 | 8 |
359326 | 359326 | 2020-07-22 | Wayne | Pennsylvania | 42127 | 148 | 8 |
356122 | 356122 | 2020-07-21 | Wayne | Pennsylvania | 42127 | 149 | 8 |
352919 | 352919 | 2020-07-20 | Wayne | Pennsylvania | 42127 | 149 | 8 |
349716 | 349716 | 2020-07-19 | Wayne | Pennsylvania | 42127 | 148 | 8 |
346516 | 346516 | 2020-07-18 | Wayne | Pennsylvania | 42127 | 148 | 8 |
343316 | 343316 | 2020-07-17 | Wayne | Pennsylvania | 42127 | 148 | 8 |
340118 | 340118 | 2020-07-16 | Wayne | Pennsylvania | 42127 | 144 | 8 |
336921 | 336921 | 2020-07-15 | Wayne | Pennsylvania | 42127 | 143 | 8 |
333727 | 333727 | 2020-07-14 | Wayne | Pennsylvania | 42127 | 141 | 8 |
330535 | 330535 | 2020-07-13 | Wayne | Pennsylvania | 42127 | 141 | 8 |
327349 | 327349 | 2020-07-12 | Wayne | Pennsylvania | 42127 | 141 | 8 |
324164 | 324164 | 2020-07-11 | Wayne | Pennsylvania | 42127 | 141 | 8 |
320984 | 320984 | 2020-07-10 | Wayne | Pennsylvania | 42127 | 141 | 8 |
317806 | 317806 | 2020-07-09 | Wayne | Pennsylvania | 42127 | 141 | 8 |
314633 | 314633 | 2020-07-08 | Wayne | Pennsylvania | 42127 | 141 | 8 |
311461 | 311461 | 2020-07-07 | Wayne | Pennsylvania | 42127 | 141 | 9 |
308292 | 308292 | 2020-07-06 | Wayne | Pennsylvania | 42127 | 141 | 9 |
305125 | 305125 | 2020-07-05 | Wayne | Pennsylvania | 42127 | 141 | 9 |
301962 | 301962 | 2020-07-04 | Wayne | Pennsylvania | 42127 | 141 | 9 |
298798 | 298798 | 2020-07-03 | Wayne | Pennsylvania | 42127 | 142 | 9 |
295639 | 295639 | 2020-07-02 | Wayne | Pennsylvania | 42127 | 140 | 9 |
292483 | 292483 | 2020-07-01 | Wayne | Pennsylvania | 42127 | 140 | 9 |
289331 | 289331 | 2020-06-30 | Wayne | Pennsylvania | 42127 | 140 | 9 |
286180 | 286180 | 2020-06-29 | Wayne | Pennsylvania | 42127 | 139 | 9 |
283035 | 283035 | 2020-06-28 | Wayne | Pennsylvania | 42127 | 139 | 9 |
279889 | 279889 | 2020-06-27 | Wayne | Pennsylvania | 42127 | 138 | 9 |
276741 | 276741 | 2020-06-26 | Wayne | Pennsylvania | 42127 | 138 | 9 |
273594 | 273594 | 2020-06-25 | Wayne | Pennsylvania | 42127 | 133 | 9 |
270455 | 270455 | 2020-06-24 | Wayne | Pennsylvania | 42127 | 131 | 9 |
267321 | 267321 | 2020-06-23 | Wayne | Pennsylvania | 42127 | 131 | 9 |
264193 | 264193 | 2020-06-22 | Wayne | Pennsylvania | 42127 | 130 | 9 |
261065 | 261065 | 2020-06-21 | Wayne | Pennsylvania | 42127 | 130 | 9 |
257938 | 257938 | 2020-06-20 | Wayne | Pennsylvania | 42127 | 130 | 9 |
254812 | 254812 | 2020-06-19 | Wayne | Pennsylvania | 42127 | 129 | 9 |
251697 | 251697 | 2020-06-18 | Wayne | Pennsylvania | 42127 | 128 | 9 |
248582 | 248582 | 2020-06-17 | Wayne | Pennsylvania | 42127 | 126 | 9 |
245469 | 245469 | 2020-06-16 | Wayne | Pennsylvania | 42127 | 126 | 9 |
242357 | 242357 | 2020-06-15 | Wayne | Pennsylvania | 42127 | 126 | 9 |
239248 | 239248 | 2020-06-14 | Wayne | Pennsylvania | 42127 | 126 | 9 |
236140 | 236140 | 2020-06-13 | Wayne | Pennsylvania | 42127 | 126 | 9 |
233035 | 233035 | 2020-06-12 | Wayne | Pennsylvania | 42127 | 125 | 9 |
229930 | 229930 | 2020-06-11 | Wayne | Pennsylvania | 42127 | 125 | 9 |
226826 | 226826 | 2020-06-10 | Wayne | Pennsylvania | 42127 | 123 | 9 |
223726 | 223726 | 2020-06-09 | Wayne | Pennsylvania | 42127 | 124 | 9 |
220631 | 220631 | 2020-06-08 | Wayne | Pennsylvania | 42127 | 124 | 9 |
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);