ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 36019 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 |
---|---|---|---|---|---|---|---|
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 |
314168 | 314168 | 2020-07-08 | Clinton | New York | 36019 | 106 | 4 |
310997 | 310997 | 2020-07-07 | Clinton | New York | 36019 | 105 | 4 |
307829 | 307829 | 2020-07-06 | Clinton | New York | 36019 | 103 | 4 |
304662 | 304662 | 2020-07-05 | Clinton | New York | 36019 | 103 | 4 |
301499 | 301499 | 2020-07-04 | Clinton | New York | 36019 | 101 | 4 |
298336 | 298336 | 2020-07-03 | Clinton | New York | 36019 | 101 | 4 |
295176 | 295176 | 2020-07-02 | Clinton | New York | 36019 | 101 | 4 |
292021 | 292021 | 2020-07-01 | Clinton | New York | 36019 | 101 | 4 |
288869 | 288869 | 2020-06-30 | Clinton | New York | 36019 | 101 | 4 |
285719 | 285719 | 2020-06-29 | Clinton | New York | 36019 | 101 | 4 |
282574 | 282574 | 2020-06-28 | Clinton | New York | 36019 | 101 | 4 |
279428 | 279428 | 2020-06-27 | Clinton | New York | 36019 | 101 | 4 |
276280 | 276280 | 2020-06-26 | Clinton | New York | 36019 | 101 | 4 |
273134 | 273134 | 2020-06-25 | Clinton | New York | 36019 | 101 | 4 |
269995 | 269995 | 2020-06-24 | Clinton | New York | 36019 | 100 | 4 |
266861 | 266861 | 2020-06-23 | Clinton | New York | 36019 | 100 | 4 |
263733 | 263733 | 2020-06-22 | Clinton | New York | 36019 | 100 | 4 |
260605 | 260605 | 2020-06-21 | Clinton | New York | 36019 | 100 | 4 |
257478 | 257478 | 2020-06-20 | Clinton | New York | 36019 | 100 | 4 |
254355 | 254355 | 2020-06-19 | Clinton | New York | 36019 | 99 | 4 |
251240 | 251240 | 2020-06-18 | Clinton | New York | 36019 | 99 | 4 |
248125 | 248125 | 2020-06-17 | Clinton | New York | 36019 | 99 | 4 |
245012 | 245012 | 2020-06-16 | Clinton | New York | 36019 | 99 | 4 |
241900 | 241900 | 2020-06-15 | Clinton | New York | 36019 | 98 | 4 |
238791 | 238791 | 2020-06-14 | Clinton | New York | 36019 | 98 | 4 |
235683 | 235683 | 2020-06-13 | Clinton | New York | 36019 | 98 | 4 |
232578 | 232578 | 2020-06-12 | Clinton | New York | 36019 | 98 | 4 |
229473 | 229473 | 2020-06-11 | Clinton | New York | 36019 | 98 | 4 |
226369 | 226369 | 2020-06-10 | Clinton | New York | 36019 | 97 | 4 |
223269 | 223269 | 2020-06-09 | Clinton | New York | 36019 | 97 | 4 |
220175 | 220175 | 2020-06-08 | Clinton | New York | 36019 | 97 | 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);