ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Rockland" 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 |
---|---|---|---|---|---|---|---|
636769 | 636769 | 2020-10-16 | Rockland | New York | 36087 | 17063 | 509 |
633523 | 633523 | 2020-10-15 | Rockland | New York | 36087 | 16972 | 509 |
630278 | 630278 | 2020-10-14 | Rockland | New York | 36087 | 16891 | 509 |
627034 | 627034 | 2020-10-13 | Rockland | New York | 36087 | 16829 | 509 |
623792 | 623792 | 2020-10-12 | Rockland | New York | 36087 | 16760 | 509 |
620549 | 620549 | 2020-10-11 | Rockland | New York | 36087 | 16717 | 509 |
617307 | 617307 | 2020-10-10 | Rockland | New York | 36087 | 16690 | 509 |
614065 | 614065 | 2020-10-09 | Rockland | New York | 36087 | 16599 | 509 |
610824 | 610824 | 2020-10-08 | Rockland | New York | 36087 | 16454 | 509 |
607582 | 607582 | 2020-10-07 | Rockland | New York | 36087 | 16256 | 509 |
604339 | 604339 | 2020-10-06 | Rockland | New York | 36087 | 16190 | 509 |
601097 | 601097 | 2020-10-05 | Rockland | New York | 36087 | 16071 | 509 |
597854 | 597854 | 2020-10-04 | Rockland | New York | 36087 | 16016 | 509 |
594611 | 594611 | 2020-10-03 | Rockland | New York | 36087 | 15973 | 509 |
591370 | 591370 | 2020-10-02 | Rockland | New York | 36087 | 15849 | 509 |
588129 | 588129 | 2020-10-01 | Rockland | New York | 36087 | 15636 | 509 |
584889 | 584889 | 2020-09-30 | Rockland | New York | 36087 | 15452 | 509 |
581648 | 581648 | 2020-09-29 | Rockland | New York | 36087 | 15342 | 509 |
578408 | 578408 | 2020-09-28 | Rockland | New York | 36087 | 15277 | 509 |
575167 | 575167 | 2020-09-27 | Rockland | New York | 36087 | 15167 | 509 |
571923 | 571923 | 2020-09-26 | Rockland | New York | 36087 | 15100 | 509 |
568681 | 568681 | 2020-09-25 | Rockland | New York | 36087 | 15045 | 509 |
565440 | 565440 | 2020-09-24 | Rockland | New York | 36087 | 14998 | 509 |
562199 | 562199 | 2020-09-23 | Rockland | New York | 36087 | 14954 | 509 |
558962 | 558962 | 2020-09-22 | Rockland | New York | 36087 | 14891 | 509 |
555725 | 555725 | 2020-09-21 | Rockland | New York | 36087 | 14833 | 509 |
552488 | 552488 | 2020-09-20 | Rockland | New York | 36087 | 14823 | 509 |
549249 | 549249 | 2020-09-19 | Rockland | New York | 36087 | 14801 | 509 |
546010 | 546010 | 2020-09-18 | Rockland | New York | 36087 | 14747 | 509 |
542773 | 542773 | 2020-09-17 | Rockland | New York | 36087 | 14698 | 509 |
539537 | 539537 | 2020-09-16 | Rockland | New York | 36087 | 14660 | 509 |
536300 | 536300 | 2020-09-15 | Rockland | New York | 36087 | 14617 | 509 |
533064 | 533064 | 2020-09-14 | Rockland | New York | 36087 | 14581 | 509 |
529829 | 529829 | 2020-09-13 | Rockland | New York | 36087 | 14547 | 509 |
526592 | 526592 | 2020-09-12 | Rockland | New York | 36087 | 14530 | 509 |
523356 | 523356 | 2020-09-11 | Rockland | New York | 36087 | 14510 | 509 |
520120 | 520120 | 2020-09-10 | Rockland | New York | 36087 | 14480 | 509 |
516884 | 516884 | 2020-09-09 | Rockland | New York | 36087 | 14459 | 508 |
513649 | 513649 | 2020-09-08 | Rockland | New York | 36087 | 14439 | 508 |
510416 | 510416 | 2020-09-07 | Rockland | New York | 36087 | 14418 | 508 |
507183 | 507183 | 2020-09-06 | Rockland | New York | 36087 | 14396 | 508 |
503951 | 503951 | 2020-09-05 | Rockland | New York | 36087 | 14382 | 508 |
500717 | 500717 | 2020-09-04 | Rockland | New York | 36087 | 14358 | 508 |
497483 | 497483 | 2020-09-03 | Rockland | New York | 36087 | 14334 | 508 |
494250 | 494250 | 2020-09-02 | Rockland | New York | 36087 | 14305 | 508 |
491016 | 491016 | 2020-09-01 | Rockland | New York | 36087 | 14271 | 508 |
487783 | 487783 | 2020-08-31 | Rockland | New York | 36087 | 14255 | 508 |
484550 | 484550 | 2020-08-30 | Rockland | New York | 36087 | 14233 | 508 |
481315 | 481315 | 2020-08-29 | Rockland | New York | 36087 | 14218 | 508 |
478082 | 478082 | 2020-08-28 | Rockland | New York | 36087 | 14197 | 508 |
474849 | 474849 | 2020-08-27 | Rockland | New York | 36087 | 14183 | 508 |
471615 | 471615 | 2020-08-26 | Rockland | New York | 36087 | 14161 | 508 |
468383 | 468383 | 2020-08-25 | Rockland | New York | 36087 | 14149 | 508 |
465155 | 465155 | 2020-08-24 | Rockland | New York | 36087 | 14139 | 508 |
461926 | 461926 | 2020-08-23 | Rockland | New York | 36087 | 14129 | 508 |
458698 | 458698 | 2020-08-22 | Rockland | New York | 36087 | 14118 | 508 |
455470 | 455470 | 2020-08-21 | Rockland | New York | 36087 | 14106 | 508 |
452242 | 452242 | 2020-08-20 | Rockland | New York | 36087 | 14089 | 507 |
449014 | 449014 | 2020-08-19 | Rockland | New York | 36087 | 14067 | 507 |
445786 | 445786 | 2020-08-18 | Rockland | New York | 36087 | 14053 | 507 |
442560 | 442560 | 2020-08-17 | Rockland | New York | 36087 | 14011 | 507 |
439333 | 439333 | 2020-08-16 | Rockland | New York | 36087 | 14007 | 507 |
436108 | 436108 | 2020-08-15 | Rockland | New York | 36087 | 13997 | 507 |
432882 | 432882 | 2020-08-14 | Rockland | New York | 36087 | 13981 | 507 |
429656 | 429656 | 2020-08-13 | Rockland | New York | 36087 | 13973 | 507 |
426431 | 426431 | 2020-08-12 | Rockland | New York | 36087 | 13966 | 507 |
423208 | 423208 | 2020-08-11 | Rockland | New York | 36087 | 13954 | 507 |
419985 | 419985 | 2020-08-10 | Rockland | New York | 36087 | 13949 | 507 |
416765 | 416765 | 2020-08-09 | Rockland | New York | 36087 | 13942 | 507 |
413544 | 413544 | 2020-08-08 | Rockland | New York | 36087 | 13936 | 507 |
410324 | 410324 | 2020-08-07 | Rockland | New York | 36087 | 13925 | 507 |
407104 | 407104 | 2020-08-06 | Rockland | New York | 36087 | 13918 | 507 |
403885 | 403885 | 2020-08-05 | Rockland | New York | 36087 | 13903 | 470 |
400667 | 400667 | 2020-08-04 | Rockland | New York | 36087 | 13893 | 470 |
397452 | 397452 | 2020-08-03 | Rockland | New York | 36087 | 13885 | 470 |
394235 | 394235 | 2020-08-02 | Rockland | New York | 36087 | 13882 | 470 |
391019 | 391019 | 2020-08-01 | Rockland | New York | 36087 | 13880 | 470 |
387802 | 387802 | 2020-07-31 | Rockland | New York | 36087 | 13864 | 470 |
384585 | 384585 | 2020-07-30 | Rockland | New York | 36087 | 13860 | 470 |
381367 | 381367 | 2020-07-29 | Rockland | New York | 36087 | 13852 | 470 |
378150 | 378150 | 2020-07-28 | Rockland | New York | 36087 | 13845 | 470 |
374934 | 374934 | 2020-07-27 | Rockland | New York | 36087 | 13841 | 470 |
371722 | 371722 | 2020-07-26 | Rockland | New York | 36087 | 13839 | 470 |
368510 | 368510 | 2020-07-25 | Rockland | New York | 36087 | 13837 | 470 |
365301 | 365301 | 2020-07-24 | Rockland | New York | 36087 | 13830 | 470 |
362095 | 362095 | 2020-07-23 | Rockland | New York | 36087 | 13820 | 470 |
358889 | 358889 | 2020-07-22 | Rockland | New York | 36087 | 13812 | 469 |
355685 | 355685 | 2020-07-21 | Rockland | New York | 36087 | 13806 | 469 |
352482 | 352482 | 2020-07-20 | Rockland | New York | 36087 | 13798 | 469 |
349279 | 349279 | 2020-07-19 | Rockland | New York | 36087 | 13793 | 469 |
346078 | 346078 | 2020-07-18 | Rockland | New York | 36087 | 13784 | 469 |
342879 | 342879 | 2020-07-17 | Rockland | New York | 36087 | 13775 | 469 |
339681 | 339681 | 2020-07-16 | Rockland | New York | 36087 | 13763 | 469 |
336485 | 336485 | 2020-07-15 | Rockland | New York | 36087 | 13743 | 469 |
333291 | 333291 | 2020-07-14 | Rockland | New York | 36087 | 13733 | 469 |
330101 | 330101 | 2020-07-13 | Rockland | New York | 36087 | 13719 | 469 |
326914 | 326914 | 2020-07-12 | Rockland | New York | 36087 | 13716 | 469 |
323730 | 323730 | 2020-07-11 | Rockland | New York | 36087 | 13700 | 469 |
320550 | 320550 | 2020-07-10 | Rockland | New York | 36087 | 13691 | 469 |
317373 | 317373 | 2020-07-09 | Rockland | New York | 36087 | 13683 | 469 |
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);