ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Sullivan" 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 |
---|---|---|---|---|---|---|---|
636778 | 636778 | 2020-10-16 | Sullivan | New York | 36105 | 1668 | 37 |
633532 | 633532 | 2020-10-15 | Sullivan | New York | 36105 | 1663 | 37 |
630287 | 630287 | 2020-10-14 | Sullivan | New York | 36105 | 1659 | 37 |
627043 | 627043 | 2020-10-13 | Sullivan | New York | 36105 | 1655 | 37 |
623801 | 623801 | 2020-10-12 | Sullivan | New York | 36105 | 1650 | 37 |
620558 | 620558 | 2020-10-11 | Sullivan | New York | 36105 | 1649 | 37 |
617316 | 617316 | 2020-10-10 | Sullivan | New York | 36105 | 1645 | 37 |
614074 | 614074 | 2020-10-09 | Sullivan | New York | 36105 | 1643 | 37 |
610833 | 610833 | 2020-10-08 | Sullivan | New York | 36105 | 1633 | 37 |
607591 | 607591 | 2020-10-07 | Sullivan | New York | 36105 | 1629 | 37 |
604348 | 604348 | 2020-10-06 | Sullivan | New York | 36105 | 1623 | 37 |
601106 | 601106 | 2020-10-05 | Sullivan | New York | 36105 | 1616 | 37 |
597863 | 597863 | 2020-10-04 | Sullivan | New York | 36105 | 1615 | 37 |
594620 | 594620 | 2020-10-03 | Sullivan | New York | 36105 | 1614 | 37 |
591379 | 591379 | 2020-10-02 | Sullivan | New York | 36105 | 1610 | 37 |
588138 | 588138 | 2020-10-01 | Sullivan | New York | 36105 | 1607 | 37 |
584898 | 584898 | 2020-09-30 | Sullivan | New York | 36105 | 1604 | 37 |
581657 | 581657 | 2020-09-29 | Sullivan | New York | 36105 | 1600 | 37 |
578417 | 578417 | 2020-09-28 | Sullivan | New York | 36105 | 1594 | 37 |
575176 | 575176 | 2020-09-27 | Sullivan | New York | 36105 | 1591 | 37 |
571932 | 571932 | 2020-09-26 | Sullivan | New York | 36105 | 1583 | 37 |
568690 | 568690 | 2020-09-25 | Sullivan | New York | 36105 | 1581 | 37 |
565449 | 565449 | 2020-09-24 | Sullivan | New York | 36105 | 1580 | 37 |
562208 | 562208 | 2020-09-23 | Sullivan | New York | 36105 | 1576 | 37 |
558971 | 558971 | 2020-09-22 | Sullivan | New York | 36105 | 1573 | 37 |
555734 | 555734 | 2020-09-21 | Sullivan | New York | 36105 | 1573 | 37 |
552497 | 552497 | 2020-09-20 | Sullivan | New York | 36105 | 1571 | 37 |
549258 | 549258 | 2020-09-19 | Sullivan | New York | 36105 | 1570 | 37 |
546019 | 546019 | 2020-09-18 | Sullivan | New York | 36105 | 1568 | 37 |
542782 | 542782 | 2020-09-17 | Sullivan | New York | 36105 | 1565 | 37 |
539546 | 539546 | 2020-09-16 | Sullivan | New York | 36105 | 1561 | 37 |
536309 | 536309 | 2020-09-15 | Sullivan | New York | 36105 | 1559 | 37 |
533073 | 533073 | 2020-09-14 | Sullivan | New York | 36105 | 1557 | 37 |
529838 | 529838 | 2020-09-13 | Sullivan | New York | 36105 | 1553 | 37 |
526601 | 526601 | 2020-09-12 | Sullivan | New York | 36105 | 1549 | 37 |
523365 | 523365 | 2020-09-11 | Sullivan | New York | 36105 | 1548 | 37 |
520129 | 520129 | 2020-09-10 | Sullivan | New York | 36105 | 1548 | 37 |
516893 | 516893 | 2020-09-09 | Sullivan | New York | 36105 | 1544 | 37 |
513658 | 513658 | 2020-09-08 | Sullivan | New York | 36105 | 1544 | 37 |
510425 | 510425 | 2020-09-07 | Sullivan | New York | 36105 | 1544 | 37 |
507192 | 507192 | 2020-09-06 | Sullivan | New York | 36105 | 1543 | 37 |
503960 | 503960 | 2020-09-05 | Sullivan | New York | 36105 | 1543 | 37 |
500726 | 500726 | 2020-09-04 | Sullivan | New York | 36105 | 1540 | 37 |
497492 | 497492 | 2020-09-03 | Sullivan | New York | 36105 | 1537 | 37 |
494259 | 494259 | 2020-09-02 | Sullivan | New York | 36105 | 1534 | 37 |
491025 | 491025 | 2020-09-01 | Sullivan | New York | 36105 | 1530 | 37 |
487792 | 487792 | 2020-08-31 | Sullivan | New York | 36105 | 1529 | 37 |
484559 | 484559 | 2020-08-30 | Sullivan | New York | 36105 | 1521 | 37 |
481324 | 481324 | 2020-08-29 | Sullivan | New York | 36105 | 1516 | 37 |
478091 | 478091 | 2020-08-28 | Sullivan | New York | 36105 | 1515 | 37 |
474858 | 474858 | 2020-08-27 | Sullivan | New York | 36105 | 1506 | 37 |
471624 | 471624 | 2020-08-26 | Sullivan | New York | 36105 | 1499 | 37 |
468392 | 468392 | 2020-08-25 | Sullivan | New York | 36105 | 1499 | 37 |
465164 | 465164 | 2020-08-24 | Sullivan | New York | 36105 | 1495 | 37 |
461935 | 461935 | 2020-08-23 | Sullivan | New York | 36105 | 1495 | 37 |
458707 | 458707 | 2020-08-22 | Sullivan | New York | 36105 | 1495 | 37 |
455479 | 455479 | 2020-08-21 | Sullivan | New York | 36105 | 1495 | 37 |
452251 | 452251 | 2020-08-20 | Sullivan | New York | 36105 | 1495 | 37 |
449023 | 449023 | 2020-08-19 | Sullivan | New York | 36105 | 1494 | 37 |
445795 | 445795 | 2020-08-18 | Sullivan | New York | 36105 | 1493 | 37 |
442569 | 442569 | 2020-08-17 | Sullivan | New York | 36105 | 1493 | 37 |
439342 | 439342 | 2020-08-16 | Sullivan | New York | 36105 | 1493 | 37 |
436117 | 436117 | 2020-08-15 | Sullivan | New York | 36105 | 1493 | 37 |
432891 | 432891 | 2020-08-14 | Sullivan | New York | 36105 | 1491 | 37 |
429665 | 429665 | 2020-08-13 | Sullivan | New York | 36105 | 1491 | 37 |
426440 | 426440 | 2020-08-12 | Sullivan | New York | 36105 | 1491 | 37 |
423217 | 423217 | 2020-08-11 | Sullivan | New York | 36105 | 1490 | 37 |
419994 | 419994 | 2020-08-10 | Sullivan | New York | 36105 | 1489 | 37 |
416774 | 416774 | 2020-08-09 | Sullivan | New York | 36105 | 1489 | 37 |
413553 | 413553 | 2020-08-08 | Sullivan | New York | 36105 | 1488 | 37 |
410333 | 410333 | 2020-08-07 | Sullivan | New York | 36105 | 1488 | 37 |
407113 | 407113 | 2020-08-06 | Sullivan | New York | 36105 | 1485 | 37 |
403894 | 403894 | 2020-08-05 | Sullivan | New York | 36105 | 1485 | 32 |
400676 | 400676 | 2020-08-04 | Sullivan | New York | 36105 | 1484 | 32 |
397461 | 397461 | 2020-08-03 | Sullivan | New York | 36105 | 1483 | 32 |
394244 | 394244 | 2020-08-02 | Sullivan | New York | 36105 | 1483 | 32 |
391028 | 391028 | 2020-08-01 | Sullivan | New York | 36105 | 1483 | 32 |
387811 | 387811 | 2020-07-31 | Sullivan | New York | 36105 | 1480 | 32 |
384594 | 384594 | 2020-07-30 | Sullivan | New York | 36105 | 1479 | 32 |
381376 | 381376 | 2020-07-29 | Sullivan | New York | 36105 | 1476 | 32 |
378159 | 378159 | 2020-07-28 | Sullivan | New York | 36105 | 1476 | 32 |
374943 | 374943 | 2020-07-27 | Sullivan | New York | 36105 | 1476 | 32 |
371731 | 371731 | 2020-07-26 | Sullivan | New York | 36105 | 1476 | 32 |
368519 | 368519 | 2020-07-25 | Sullivan | New York | 36105 | 1476 | 32 |
365310 | 365310 | 2020-07-24 | Sullivan | New York | 36105 | 1475 | 32 |
362104 | 362104 | 2020-07-23 | Sullivan | New York | 36105 | 1475 | 32 |
358898 | 358898 | 2020-07-22 | Sullivan | New York | 36105 | 1473 | 32 |
355694 | 355694 | 2020-07-21 | Sullivan | New York | 36105 | 1473 | 32 |
352491 | 352491 | 2020-07-20 | Sullivan | New York | 36105 | 1473 | 32 |
349288 | 349288 | 2020-07-19 | Sullivan | New York | 36105 | 1473 | 32 |
346087 | 346087 | 2020-07-18 | Sullivan | New York | 36105 | 1473 | 31 |
342888 | 342888 | 2020-07-17 | Sullivan | New York | 36105 | 1469 | 31 |
339690 | 339690 | 2020-07-16 | Sullivan | New York | 36105 | 1469 | 31 |
336494 | 336494 | 2020-07-15 | Sullivan | New York | 36105 | 1467 | 31 |
333300 | 333300 | 2020-07-14 | Sullivan | New York | 36105 | 1466 | 31 |
330110 | 330110 | 2020-07-13 | Sullivan | New York | 36105 | 1465 | 31 |
326923 | 326923 | 2020-07-12 | Sullivan | New York | 36105 | 1465 | 31 |
323739 | 323739 | 2020-07-11 | Sullivan | New York | 36105 | 1464 | 31 |
320559 | 320559 | 2020-07-10 | Sullivan | New York | 36105 | 1464 | 31 |
317382 | 317382 | 2020-07-09 | Sullivan | New York | 36105 | 1460 | 31 |
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);