ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Clinton" and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636738 | 636738 | 2020-10-16 | Clinton | New York | 36019 | 190 | 5 |
633492 | 633492 | 2020-10-15 | Clinton | New York | 36019 | 187 | 5 |
630247 | 630247 | 2020-10-14 | Clinton | New York | 36019 | 183 | 5 |
627003 | 627003 | 2020-10-13 | Clinton | New York | 36019 | 182 | 5 |
623761 | 623761 | 2020-10-12 | Clinton | New York | 36019 | 179 | 5 |
620518 | 620518 | 2020-10-11 | Clinton | New York | 36019 | 179 | 5 |
617276 | 617276 | 2020-10-10 | Clinton | New York | 36019 | 178 | 5 |
614034 | 614034 | 2020-10-09 | Clinton | New York | 36019 | 178 | 5 |
610793 | 610793 | 2020-10-08 | Clinton | New York | 36019 | 177 | 5 |
607551 | 607551 | 2020-10-07 | Clinton | New York | 36019 | 173 | 5 |
604308 | 604308 | 2020-10-06 | Clinton | New York | 36019 | 173 | 5 |
601066 | 601066 | 2020-10-05 | Clinton | New York | 36019 | 170 | 5 |
597823 | 597823 | 2020-10-04 | Clinton | New York | 36019 | 166 | 5 |
594580 | 594580 | 2020-10-03 | Clinton | New York | 36019 | 165 | 5 |
591339 | 591339 | 2020-10-02 | Clinton | New York | 36019 | 164 | 5 |
588098 | 588098 | 2020-10-01 | Clinton | New York | 36019 | 162 | 5 |
584858 | 584858 | 2020-09-30 | Clinton | New York | 36019 | 162 | 5 |
581617 | 581617 | 2020-09-29 | Clinton | New York | 36019 | 162 | 5 |
578377 | 578377 | 2020-09-28 | Clinton | New York | 36019 | 161 | 5 |
575136 | 575136 | 2020-09-27 | Clinton | New York | 36019 | 160 | 5 |
571892 | 571892 | 2020-09-26 | Clinton | New York | 36019 | 159 | 5 |
568650 | 568650 | 2020-09-25 | Clinton | New York | 36019 | 158 | 5 |
565409 | 565409 | 2020-09-24 | Clinton | New York | 36019 | 157 | 5 |
562168 | 562168 | 2020-09-23 | Clinton | New York | 36019 | 156 | 5 |
558931 | 558931 | 2020-09-22 | Clinton | New York | 36019 | 155 | 5 |
555694 | 555694 | 2020-09-21 | Clinton | New York | 36019 | 154 | 5 |
552457 | 552457 | 2020-09-20 | Clinton | New York | 36019 | 154 | 5 |
549218 | 549218 | 2020-09-19 | Clinton | New York | 36019 | 154 | 5 |
545979 | 545979 | 2020-09-18 | Clinton | New York | 36019 | 154 | 5 |
542742 | 542742 | 2020-09-17 | Clinton | New York | 36019 | 154 | 5 |
539506 | 539506 | 2020-09-16 | Clinton | New York | 36019 | 154 | 5 |
536269 | 536269 | 2020-09-15 | Clinton | New York | 36019 | 154 | 5 |
533033 | 533033 | 2020-09-14 | Clinton | New York | 36019 | 153 | 5 |
529798 | 529798 | 2020-09-13 | Clinton | New York | 36019 | 153 | 5 |
526561 | 526561 | 2020-09-12 | Clinton | New York | 36019 | 152 | 5 |
523325 | 523325 | 2020-09-11 | Clinton | New York | 36019 | 152 | 5 |
520089 | 520089 | 2020-09-10 | Clinton | New York | 36019 | 152 | 5 |
516853 | 516853 | 2020-09-09 | Clinton | New York | 36019 | 152 | 5 |
513618 | 513618 | 2020-09-08 | Clinton | New York | 36019 | 152 | 5 |
510385 | 510385 | 2020-09-07 | Clinton | New York | 36019 | 152 | 5 |
507152 | 507152 | 2020-09-06 | Clinton | New York | 36019 | 152 | 5 |
503920 | 503920 | 2020-09-05 | Clinton | New York | 36019 | 152 | 5 |
500686 | 500686 | 2020-09-04 | Clinton | New York | 36019 | 152 | 5 |
497452 | 497452 | 2020-09-03 | Clinton | New York | 36019 | 152 | 5 |
494219 | 494219 | 2020-09-02 | Clinton | New York | 36019 | 151 | 5 |
490985 | 490985 | 2020-09-01 | Clinton | New York | 36019 | 151 | 5 |
487752 | 487752 | 2020-08-31 | Clinton | New York | 36019 | 150 | 5 |
484519 | 484519 | 2020-08-30 | Clinton | New York | 36019 | 150 | 5 |
481284 | 481284 | 2020-08-29 | Clinton | New York | 36019 | 150 | 5 |
478051 | 478051 | 2020-08-28 | Clinton | New York | 36019 | 149 | 5 |
474818 | 474818 | 2020-08-27 | Clinton | New York | 36019 | 148 | 5 |
471584 | 471584 | 2020-08-26 | Clinton | New York | 36019 | 147 | 5 |
468352 | 468352 | 2020-08-25 | Clinton | New York | 36019 | 146 | 5 |
465124 | 465124 | 2020-08-24 | Clinton | New York | 36019 | 142 | 5 |
461895 | 461895 | 2020-08-23 | Clinton | New York | 36019 | 141 | 5 |
458667 | 458667 | 2020-08-22 | Clinton | New York | 36019 | 141 | 5 |
455439 | 455439 | 2020-08-21 | Clinton | New York | 36019 | 136 | 5 |
452211 | 452211 | 2020-08-20 | Clinton | New York | 36019 | 135 | 4 |
448983 | 448983 | 2020-08-19 | Clinton | New York | 36019 | 134 | 4 |
445755 | 445755 | 2020-08-18 | Clinton | New York | 36019 | 134 | 4 |
442529 | 442529 | 2020-08-17 | Clinton | New York | 36019 | 133 | 4 |
439302 | 439302 | 2020-08-16 | Clinton | New York | 36019 | 132 | 4 |
436077 | 436077 | 2020-08-15 | Clinton | New York | 36019 | 131 | 4 |
432851 | 432851 | 2020-08-14 | Clinton | New York | 36019 | 130 | 4 |
429625 | 429625 | 2020-08-13 | Clinton | New York | 36019 | 129 | 4 |
426400 | 426400 | 2020-08-12 | Clinton | New York | 36019 | 129 | 4 |
423177 | 423177 | 2020-08-11 | Clinton | New York | 36019 | 129 | 4 |
419954 | 419954 | 2020-08-10 | Clinton | New York | 36019 | 128 | 4 |
416734 | 416734 | 2020-08-09 | Clinton | New York | 36019 | 127 | 4 |
413513 | 413513 | 2020-08-08 | Clinton | New York | 36019 | 127 | 4 |
410293 | 410293 | 2020-08-07 | Clinton | New York | 36019 | 127 | 4 |
407073 | 407073 | 2020-08-06 | Clinton | New York | 36019 | 127 | 4 |
403854 | 403854 | 2020-08-05 | Clinton | New York | 36019 | 127 | 4 |
400636 | 400636 | 2020-08-04 | Clinton | New York | 36019 | 127 | 4 |
397421 | 397421 | 2020-08-03 | Clinton | New York | 36019 | 127 | 4 |
394204 | 394204 | 2020-08-02 | Clinton | New York | 36019 | 127 | 4 |
390988 | 390988 | 2020-08-01 | Clinton | New York | 36019 | 127 | 4 |
387771 | 387771 | 2020-07-31 | Clinton | New York | 36019 | 126 | 4 |
384554 | 384554 | 2020-07-30 | Clinton | New York | 36019 | 125 | 4 |
381336 | 381336 | 2020-07-29 | Clinton | New York | 36019 | 123 | 4 |
378119 | 378119 | 2020-07-28 | Clinton | New York | 36019 | 123 | 4 |
374903 | 374903 | 2020-07-27 | Clinton | New York | 36019 | 120 | 4 |
371691 | 371691 | 2020-07-26 | Clinton | New York | 36019 | 120 | 4 |
368479 | 368479 | 2020-07-25 | Clinton | New York | 36019 | 119 | 4 |
365270 | 365270 | 2020-07-24 | Clinton | New York | 36019 | 117 | 4 |
362064 | 362064 | 2020-07-23 | Clinton | New York | 36019 | 114 | 4 |
358858 | 358858 | 2020-07-22 | Clinton | New York | 36019 | 114 | 4 |
355654 | 355654 | 2020-07-21 | Clinton | New York | 36019 | 114 | 4 |
352451 | 352451 | 2020-07-20 | Clinton | New York | 36019 | 113 | 4 |
349248 | 349248 | 2020-07-19 | Clinton | New York | 36019 | 113 | 4 |
346047 | 346047 | 2020-07-18 | Clinton | New York | 36019 | 111 | 4 |
342848 | 342848 | 2020-07-17 | Clinton | New York | 36019 | 111 | 4 |
339650 | 339650 | 2020-07-16 | Clinton | New York | 36019 | 111 | 4 |
336454 | 336454 | 2020-07-15 | Clinton | New York | 36019 | 111 | 4 |
333260 | 333260 | 2020-07-14 | Clinton | New York | 36019 | 110 | 4 |
330070 | 330070 | 2020-07-13 | Clinton | New York | 36019 | 109 | 4 |
326883 | 326883 | 2020-07-12 | Clinton | New York | 36019 | 109 | 4 |
323699 | 323699 | 2020-07-11 | Clinton | New York | 36019 | 108 | 4 |
320519 | 320519 | 2020-07-10 | Clinton | New York | 36019 | 107 | 4 |
317342 | 317342 | 2020-07-09 | Clinton | New York | 36019 | 107 | 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);