ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Wayne" and fips = 42127 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637209 | 637209 | 2020-10-16 | Wayne | Pennsylvania | 42127 | 277 | 12 |
633963 | 633963 | 2020-10-15 | Wayne | Pennsylvania | 42127 | 273 | 12 |
630718 | 630718 | 2020-10-14 | Wayne | Pennsylvania | 42127 | 268 | 12 |
627474 | 627474 | 2020-10-13 | Wayne | Pennsylvania | 42127 | 266 | 12 |
624232 | 624232 | 2020-10-12 | Wayne | Pennsylvania | 42127 | 265 | 12 |
620989 | 620989 | 2020-10-11 | Wayne | Pennsylvania | 42127 | 265 | 12 |
617746 | 617746 | 2020-10-10 | Wayne | Pennsylvania | 42127 | 264 | 12 |
614504 | 614504 | 2020-10-09 | Wayne | Pennsylvania | 42127 | 263 | 12 |
611263 | 611263 | 2020-10-08 | Wayne | Pennsylvania | 42127 | 260 | 12 |
608021 | 608021 | 2020-10-07 | Wayne | Pennsylvania | 42127 | 260 | 11 |
604778 | 604778 | 2020-10-06 | Wayne | Pennsylvania | 42127 | 257 | 11 |
601536 | 601536 | 2020-10-05 | Wayne | Pennsylvania | 42127 | 256 | 11 |
598293 | 598293 | 2020-10-04 | Wayne | Pennsylvania | 42127 | 256 | 11 |
595050 | 595050 | 2020-10-03 | Wayne | Pennsylvania | 42127 | 253 | 11 |
591809 | 591809 | 2020-10-02 | Wayne | Pennsylvania | 42127 | 253 | 10 |
588568 | 588568 | 2020-10-01 | Wayne | Pennsylvania | 42127 | 245 | 10 |
585328 | 585328 | 2020-09-30 | Wayne | Pennsylvania | 42127 | 238 | 10 |
582088 | 582088 | 2020-09-29 | Wayne | Pennsylvania | 42127 | 237 | 10 |
578848 | 578848 | 2020-09-28 | Wayne | Pennsylvania | 42127 | 234 | 10 |
575607 | 575607 | 2020-09-27 | Wayne | Pennsylvania | 42127 | 232 | 10 |
572363 | 572363 | 2020-09-26 | Wayne | Pennsylvania | 42127 | 226 | 10 |
569121 | 569121 | 2020-09-25 | Wayne | Pennsylvania | 42127 | 224 | 10 |
565880 | 565880 | 2020-09-24 | Wayne | Pennsylvania | 42127 | 223 | 10 |
562639 | 562639 | 2020-09-23 | Wayne | Pennsylvania | 42127 | 222 | 10 |
559402 | 559402 | 2020-09-22 | Wayne | Pennsylvania | 42127 | 220 | 10 |
556165 | 556165 | 2020-09-21 | Wayne | Pennsylvania | 42127 | 218 | 10 |
552928 | 552928 | 2020-09-20 | Wayne | Pennsylvania | 42127 | 216 | 10 |
549689 | 549689 | 2020-09-19 | Wayne | Pennsylvania | 42127 | 214 | 10 |
546450 | 546450 | 2020-09-18 | Wayne | Pennsylvania | 42127 | 211 | 10 |
543213 | 543213 | 2020-09-17 | Wayne | Pennsylvania | 42127 | 208 | 10 |
539977 | 539977 | 2020-09-16 | Wayne | Pennsylvania | 42127 | 204 | 10 |
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 |
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);