ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Saratoga" 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 |
---|---|---|---|---|---|---|---|
536301 | 536301 | 2020-09-15 | Saratoga | New York | 36091 | 965 | 15 |
533065 | 533065 | 2020-09-14 | Saratoga | New York | 36091 | 964 | 15 |
529830 | 529830 | 2020-09-13 | Saratoga | New York | 36091 | 961 | 15 |
526593 | 526593 | 2020-09-12 | Saratoga | New York | 36091 | 955 | 15 |
523357 | 523357 | 2020-09-11 | Saratoga | New York | 36091 | 943 | 15 |
520121 | 520121 | 2020-09-10 | Saratoga | New York | 36091 | 918 | 15 |
516885 | 516885 | 2020-09-09 | Saratoga | New York | 36091 | 911 | 15 |
513650 | 513650 | 2020-09-08 | Saratoga | New York | 36091 | 900 | 15 |
510417 | 510417 | 2020-09-07 | Saratoga | New York | 36091 | 893 | 15 |
507184 | 507184 | 2020-09-06 | Saratoga | New York | 36091 | 889 | 15 |
503952 | 503952 | 2020-09-05 | Saratoga | New York | 36091 | 877 | 15 |
500718 | 500718 | 2020-09-04 | Saratoga | New York | 36091 | 868 | 15 |
497484 | 497484 | 2020-09-03 | Saratoga | New York | 36091 | 863 | 15 |
494251 | 494251 | 2020-09-02 | Saratoga | New York | 36091 | 852 | 15 |
491017 | 491017 | 2020-09-01 | Saratoga | New York | 36091 | 846 | 15 |
487784 | 487784 | 2020-08-31 | Saratoga | New York | 36091 | 844 | 15 |
484551 | 484551 | 2020-08-30 | Saratoga | New York | 36091 | 842 | 15 |
481316 | 481316 | 2020-08-29 | Saratoga | New York | 36091 | 832 | 15 |
478083 | 478083 | 2020-08-28 | Saratoga | New York | 36091 | 832 | 15 |
474850 | 474850 | 2020-08-27 | Saratoga | New York | 36091 | 829 | 15 |
471616 | 471616 | 2020-08-26 | Saratoga | New York | 36091 | 824 | 15 |
468384 | 468384 | 2020-08-25 | Saratoga | New York | 36091 | 824 | 15 |
465156 | 465156 | 2020-08-24 | Saratoga | New York | 36091 | 816 | 15 |
461927 | 461927 | 2020-08-23 | Saratoga | New York | 36091 | 815 | 15 |
458699 | 458699 | 2020-08-22 | Saratoga | New York | 36091 | 813 | 15 |
455471 | 455471 | 2020-08-21 | Saratoga | New York | 36091 | 808 | 15 |
452243 | 452243 | 2020-08-20 | Saratoga | New York | 36091 | 802 | 15 |
449015 | 449015 | 2020-08-19 | Saratoga | New York | 36091 | 800 | 15 |
445787 | 445787 | 2020-08-18 | Saratoga | New York | 36091 | 800 | 15 |
442561 | 442561 | 2020-08-17 | Saratoga | New York | 36091 | 795 | 15 |
439334 | 439334 | 2020-08-16 | Saratoga | New York | 36091 | 792 | 15 |
436109 | 436109 | 2020-08-15 | Saratoga | New York | 36091 | 783 | 15 |
432883 | 432883 | 2020-08-14 | Saratoga | New York | 36091 | 782 | 15 |
429657 | 429657 | 2020-08-13 | Saratoga | New York | 36091 | 774 | 15 |
426432 | 426432 | 2020-08-12 | Saratoga | New York | 36091 | 768 | 15 |
423209 | 423209 | 2020-08-11 | Saratoga | New York | 36091 | 767 | 15 |
419986 | 419986 | 2020-08-10 | Saratoga | New York | 36091 | 760 | 15 |
416766 | 416766 | 2020-08-09 | Saratoga | New York | 36091 | 757 | 15 |
413545 | 413545 | 2020-08-08 | Saratoga | New York | 36091 | 755 | 15 |
410325 | 410325 | 2020-08-07 | Saratoga | New York | 36091 | 752 | 15 |
407105 | 407105 | 2020-08-06 | Saratoga | New York | 36091 | 747 | 15 |
403886 | 403886 | 2020-08-05 | Saratoga | New York | 36091 | 744 | 5 |
400668 | 400668 | 2020-08-04 | Saratoga | New York | 36091 | 739 | 5 |
397453 | 397453 | 2020-08-03 | Saratoga | New York | 36091 | 733 | 5 |
394236 | 394236 | 2020-08-02 | Saratoga | New York | 36091 | 732 | 5 |
391020 | 391020 | 2020-08-01 | Saratoga | New York | 36091 | 726 | 5 |
387803 | 387803 | 2020-07-31 | Saratoga | New York | 36091 | 715 | 5 |
384586 | 384586 | 2020-07-30 | Saratoga | New York | 36091 | 709 | 5 |
381368 | 381368 | 2020-07-29 | Saratoga | New York | 36091 | 701 | 5 |
378151 | 378151 | 2020-07-28 | Saratoga | New York | 36091 | 691 | 5 |
374935 | 374935 | 2020-07-27 | Saratoga | New York | 36091 | 688 | 5 |
371723 | 371723 | 2020-07-26 | Saratoga | New York | 36091 | 685 | 5 |
368511 | 368511 | 2020-07-25 | Saratoga | New York | 36091 | 679 | 5 |
365302 | 365302 | 2020-07-24 | Saratoga | New York | 36091 | 665 | 5 |
362096 | 362096 | 2020-07-23 | Saratoga | New York | 36091 | 663 | 5 |
358890 | 358890 | 2020-07-22 | Saratoga | New York | 36091 | 650 | 5 |
355686 | 355686 | 2020-07-21 | Saratoga | New York | 36091 | 646 | 5 |
352483 | 352483 | 2020-07-20 | Saratoga | New York | 36091 | 639 | 5 |
349280 | 349280 | 2020-07-19 | Saratoga | New York | 36091 | 637 | 5 |
346079 | 346079 | 2020-07-18 | Saratoga | New York | 36091 | 635 | 5 |
342880 | 342880 | 2020-07-17 | Saratoga | New York | 36091 | 630 | 5 |
339682 | 339682 | 2020-07-16 | Saratoga | New York | 36091 | 624 | 5 |
336486 | 336486 | 2020-07-15 | Saratoga | New York | 36091 | 623 | 5 |
333292 | 333292 | 2020-07-14 | Saratoga | New York | 36091 | 616 | 5 |
330102 | 330102 | 2020-07-13 | Saratoga | New York | 36091 | 610 | 5 |
326915 | 326915 | 2020-07-12 | Saratoga | New York | 36091 | 602 | 5 |
323731 | 323731 | 2020-07-11 | Saratoga | New York | 36091 | 595 | 5 |
320551 | 320551 | 2020-07-10 | Saratoga | New York | 36091 | 587 | 5 |
317374 | 317374 | 2020-07-09 | Saratoga | New York | 36091 | 585 | 5 |
314200 | 314200 | 2020-07-08 | Saratoga | New York | 36091 | 582 | 5 |
311029 | 311029 | 2020-07-07 | Saratoga | New York | 36091 | 578 | 5 |
307861 | 307861 | 2020-07-06 | Saratoga | New York | 36091 | 572 | 5 |
304694 | 304694 | 2020-07-05 | Saratoga | New York | 36091 | 566 | 5 |
301531 | 301531 | 2020-07-04 | Saratoga | New York | 36091 | 562 | 5 |
298368 | 298368 | 2020-07-03 | Saratoga | New York | 36091 | 561 | 5 |
295208 | 295208 | 2020-07-02 | Saratoga | New York | 36091 | 555 | 5 |
292053 | 292053 | 2020-07-01 | Saratoga | New York | 36091 | 550 | 5 |
288901 | 288901 | 2020-06-30 | Saratoga | New York | 36091 | 549 | 5 |
285751 | 285751 | 2020-06-29 | Saratoga | New York | 36091 | 549 | 5 |
282606 | 282606 | 2020-06-28 | Saratoga | New York | 36091 | 548 | 5 |
279460 | 279460 | 2020-06-27 | Saratoga | New York | 36091 | 546 | 5 |
276312 | 276312 | 2020-06-26 | Saratoga | New York | 36091 | 540 | 5 |
273166 | 273166 | 2020-06-25 | Saratoga | New York | 36091 | 540 | 5 |
270027 | 270027 | 2020-06-24 | Saratoga | New York | 36091 | 538 | 5 |
266893 | 266893 | 2020-06-23 | Saratoga | New York | 36091 | 538 | 5 |
263765 | 263765 | 2020-06-22 | Saratoga | New York | 36091 | 535 | 5 |
260637 | 260637 | 2020-06-21 | Saratoga | New York | 36091 | 533 | 5 |
257510 | 257510 | 2020-06-20 | Saratoga | New York | 36091 | 531 | 5 |
254387 | 254387 | 2020-06-19 | Saratoga | New York | 36091 | 528 | 5 |
251272 | 251272 | 2020-06-18 | Saratoga | New York | 36091 | 526 | 5 |
248157 | 248157 | 2020-06-17 | Saratoga | New York | 36091 | 523 | 5 |
245044 | 245044 | 2020-06-16 | Saratoga | New York | 36091 | 522 | 5 |
241932 | 241932 | 2020-06-15 | Saratoga | New York | 36091 | 517 | 5 |
238823 | 238823 | 2020-06-14 | Saratoga | New York | 36091 | 515 | 5 |
235715 | 235715 | 2020-06-13 | Saratoga | New York | 36091 | 514 | 5 |
232610 | 232610 | 2020-06-12 | Saratoga | New York | 36091 | 514 | 5 |
229505 | 229505 | 2020-06-11 | Saratoga | New York | 36091 | 513 | 5 |
226401 | 226401 | 2020-06-10 | Saratoga | New York | 36091 | 511 | 5 |
223301 | 223301 | 2020-06-09 | Saratoga | New York | 36091 | 511 | 5 |
220207 | 220207 | 2020-06-08 | Saratoga | New York | 36091 | 504 | 5 |
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);