ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Greene" and fips = 42059 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637175 | 637175 | 2020-10-16 | Greene | Pennsylvania | 42059 | 209 | 1 |
633929 | 633929 | 2020-10-15 | Greene | Pennsylvania | 42059 | 208 | 1 |
630684 | 630684 | 2020-10-14 | Greene | Pennsylvania | 42059 | 205 | 1 |
627440 | 627440 | 2020-10-13 | Greene | Pennsylvania | 42059 | 204 | 1 |
624198 | 624198 | 2020-10-12 | Greene | Pennsylvania | 42059 | 203 | 1 |
620955 | 620955 | 2020-10-11 | Greene | Pennsylvania | 42059 | 201 | 1 |
617712 | 617712 | 2020-10-10 | Greene | Pennsylvania | 42059 | 200 | 1 |
614470 | 614470 | 2020-10-09 | Greene | Pennsylvania | 42059 | 199 | 1 |
611229 | 611229 | 2020-10-08 | Greene | Pennsylvania | 42059 | 198 | 1 |
607987 | 607987 | 2020-10-07 | Greene | Pennsylvania | 42059 | 197 | 1 |
604744 | 604744 | 2020-10-06 | Greene | Pennsylvania | 42059 | 195 | 1 |
601502 | 601502 | 2020-10-05 | Greene | Pennsylvania | 42059 | 194 | 1 |
598259 | 598259 | 2020-10-04 | Greene | Pennsylvania | 42059 | 194 | 1 |
595016 | 595016 | 2020-10-03 | Greene | Pennsylvania | 42059 | 191 | 1 |
591775 | 591775 | 2020-10-02 | Greene | Pennsylvania | 42059 | 191 | 1 |
588534 | 588534 | 2020-10-01 | Greene | Pennsylvania | 42059 | 190 | 1 |
585294 | 585294 | 2020-09-30 | Greene | Pennsylvania | 42059 | 190 | 1 |
582054 | 582054 | 2020-09-29 | Greene | Pennsylvania | 42059 | 188 | 1 |
578814 | 578814 | 2020-09-28 | Greene | Pennsylvania | 42059 | 188 | 1 |
575573 | 575573 | 2020-09-27 | Greene | Pennsylvania | 42059 | 187 | 1 |
572329 | 572329 | 2020-09-26 | Greene | Pennsylvania | 42059 | 184 | 1 |
569087 | 569087 | 2020-09-25 | Greene | Pennsylvania | 42059 | 183 | 1 |
565846 | 565846 | 2020-09-24 | Greene | Pennsylvania | 42059 | 182 | 1 |
562605 | 562605 | 2020-09-23 | Greene | Pennsylvania | 42059 | 181 | 1 |
559368 | 559368 | 2020-09-22 | Greene | Pennsylvania | 42059 | 179 | 1 |
556131 | 556131 | 2020-09-21 | Greene | Pennsylvania | 42059 | 176 | 1 |
552894 | 552894 | 2020-09-20 | Greene | Pennsylvania | 42059 | 169 | 1 |
549655 | 549655 | 2020-09-19 | Greene | Pennsylvania | 42059 | 168 | 1 |
546416 | 546416 | 2020-09-18 | Greene | Pennsylvania | 42059 | 166 | 1 |
543179 | 543179 | 2020-09-17 | Greene | Pennsylvania | 42059 | 165 | 1 |
539943 | 539943 | 2020-09-16 | Greene | Pennsylvania | 42059 | 162 | 1 |
536706 | 536706 | 2020-09-15 | Greene | Pennsylvania | 42059 | 160 | 1 |
533470 | 533470 | 2020-09-14 | Greene | Pennsylvania | 42059 | 159 | 1 |
530235 | 530235 | 2020-09-13 | Greene | Pennsylvania | 42059 | 159 | 1 |
526998 | 526998 | 2020-09-12 | Greene | Pennsylvania | 42059 | 159 | 1 |
523762 | 523762 | 2020-09-11 | Greene | Pennsylvania | 42059 | 156 | 1 |
520526 | 520526 | 2020-09-10 | Greene | Pennsylvania | 42059 | 153 | 1 |
517290 | 517290 | 2020-09-09 | Greene | Pennsylvania | 42059 | 152 | 1 |
514055 | 514055 | 2020-09-08 | Greene | Pennsylvania | 42059 | 150 | 1 |
510822 | 510822 | 2020-09-07 | Greene | Pennsylvania | 42059 | 150 | 1 |
507589 | 507589 | 2020-09-06 | Greene | Pennsylvania | 42059 | 149 | 1 |
504357 | 504357 | 2020-09-05 | Greene | Pennsylvania | 42059 | 146 | 1 |
501123 | 501123 | 2020-09-04 | Greene | Pennsylvania | 42059 | 145 | 1 |
497889 | 497889 | 2020-09-03 | Greene | Pennsylvania | 42059 | 145 | 1 |
494656 | 494656 | 2020-09-02 | Greene | Pennsylvania | 42059 | 140 | 1 |
491422 | 491422 | 2020-09-01 | Greene | Pennsylvania | 42059 | 140 | 1 |
488189 | 488189 | 2020-08-31 | Greene | Pennsylvania | 42059 | 140 | 1 |
484956 | 484956 | 2020-08-30 | Greene | Pennsylvania | 42059 | 139 | 1 |
481721 | 481721 | 2020-08-29 | Greene | Pennsylvania | 42059 | 138 | 1 |
478487 | 478487 | 2020-08-28 | Greene | Pennsylvania | 42059 | 136 | 1 |
475254 | 475254 | 2020-08-27 | Greene | Pennsylvania | 42059 | 135 | 1 |
472020 | 472020 | 2020-08-26 | Greene | Pennsylvania | 42059 | 135 | 1 |
468788 | 468788 | 2020-08-25 | Greene | Pennsylvania | 42059 | 135 | 1 |
465560 | 465560 | 2020-08-24 | Greene | Pennsylvania | 42059 | 135 | 1 |
462331 | 462331 | 2020-08-23 | Greene | Pennsylvania | 42059 | 134 | 1 |
459103 | 459103 | 2020-08-22 | Greene | Pennsylvania | 42059 | 133 | 1 |
455875 | 455875 | 2020-08-21 | Greene | Pennsylvania | 42059 | 132 | 1 |
452647 | 452647 | 2020-08-20 | Greene | Pennsylvania | 42059 | 131 | 1 |
449419 | 449419 | 2020-08-19 | Greene | Pennsylvania | 42059 | 129 | 1 |
446191 | 446191 | 2020-08-18 | Greene | Pennsylvania | 42059 | 129 | 1 |
442965 | 442965 | 2020-08-17 | Greene | Pennsylvania | 42059 | 126 | 1 |
439738 | 439738 | 2020-08-16 | Greene | Pennsylvania | 42059 | 126 | 1 |
436513 | 436513 | 2020-08-15 | Greene | Pennsylvania | 42059 | 126 | 1 |
433286 | 433286 | 2020-08-14 | Greene | Pennsylvania | 42059 | 123 | 1 |
430060 | 430060 | 2020-08-13 | Greene | Pennsylvania | 42059 | 121 | 1 |
426835 | 426835 | 2020-08-12 | Greene | Pennsylvania | 42059 | 118 | 1 |
423612 | 423612 | 2020-08-11 | Greene | Pennsylvania | 42059 | 117 | 1 |
420389 | 420389 | 2020-08-10 | Greene | Pennsylvania | 42059 | 116 | 1 |
417169 | 417169 | 2020-08-09 | Greene | Pennsylvania | 42059 | 116 | 1 |
413948 | 413948 | 2020-08-08 | Greene | Pennsylvania | 42059 | 114 | 1 |
410728 | 410728 | 2020-08-07 | Greene | Pennsylvania | 42059 | 112 | 1 |
407508 | 407508 | 2020-08-06 | Greene | Pennsylvania | 42059 | 110 | 1 |
404289 | 404289 | 2020-08-05 | Greene | Pennsylvania | 42059 | 110 | 1 |
401071 | 401071 | 2020-08-04 | Greene | Pennsylvania | 42059 | 110 | 1 |
397856 | 397856 | 2020-08-03 | Greene | Pennsylvania | 42059 | 109 | 1 |
394639 | 394639 | 2020-08-02 | Greene | Pennsylvania | 42059 | 108 | 1 |
391423 | 391423 | 2020-08-01 | Greene | Pennsylvania | 42059 | 107 | 1 |
388206 | 388206 | 2020-07-31 | Greene | Pennsylvania | 42059 | 107 | 0 |
384989 | 384989 | 2020-07-30 | Greene | Pennsylvania | 42059 | 105 | 0 |
381771 | 381771 | 2020-07-29 | Greene | Pennsylvania | 42059 | 103 | 0 |
378554 | 378554 | 2020-07-28 | Greene | Pennsylvania | 42059 | 100 | 0 |
375338 | 375338 | 2020-07-27 | Greene | Pennsylvania | 42059 | 99 | 0 |
372125 | 372125 | 2020-07-26 | Greene | Pennsylvania | 42059 | 98 | 0 |
368913 | 368913 | 2020-07-25 | Greene | Pennsylvania | 42059 | 97 | 0 |
365704 | 365704 | 2020-07-24 | Greene | Pennsylvania | 42059 | 94 | 0 |
362498 | 362498 | 2020-07-23 | Greene | Pennsylvania | 42059 | 93 | 0 |
359292 | 359292 | 2020-07-22 | Greene | Pennsylvania | 42059 | 91 | 0 |
356088 | 356088 | 2020-07-21 | Greene | Pennsylvania | 42059 | 91 | 0 |
352885 | 352885 | 2020-07-20 | Greene | Pennsylvania | 42059 | 87 | 0 |
349682 | 349682 | 2020-07-19 | Greene | Pennsylvania | 42059 | 84 | 0 |
346482 | 346482 | 2020-07-18 | Greene | Pennsylvania | 42059 | 80 | 0 |
343282 | 343282 | 2020-07-17 | Greene | Pennsylvania | 42059 | 79 | 0 |
340084 | 340084 | 2020-07-16 | Greene | Pennsylvania | 42059 | 77 | 0 |
336887 | 336887 | 2020-07-15 | Greene | Pennsylvania | 42059 | 75 | 0 |
333693 | 333693 | 2020-07-14 | Greene | Pennsylvania | 42059 | 72 | 0 |
330501 | 330501 | 2020-07-13 | Greene | Pennsylvania | 42059 | 70 | 0 |
327315 | 327315 | 2020-07-12 | Greene | Pennsylvania | 42059 | 70 | 0 |
324130 | 324130 | 2020-07-11 | Greene | Pennsylvania | 42059 | 67 | 0 |
320950 | 320950 | 2020-07-10 | Greene | Pennsylvania | 42059 | 61 | 0 |
317772 | 317772 | 2020-07-09 | Greene | Pennsylvania | 42059 | 56 | 0 |
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);