ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 36083 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 |
---|---|---|---|---|---|---|---|
536299 | 536299 | 2020-09-15 | Rensselaer | New York | 36083 | 884 | 42 |
533063 | 533063 | 2020-09-14 | Rensselaer | New York | 36083 | 879 | 42 |
529828 | 529828 | 2020-09-13 | Rensselaer | New York | 36083 | 879 | 42 |
526591 | 526591 | 2020-09-12 | Rensselaer | New York | 36083 | 876 | 42 |
523355 | 523355 | 2020-09-11 | Rensselaer | New York | 36083 | 870 | 42 |
520119 | 520119 | 2020-09-10 | Rensselaer | New York | 36083 | 867 | 42 |
516883 | 516883 | 2020-09-09 | Rensselaer | New York | 36083 | 866 | 42 |
513648 | 513648 | 2020-09-08 | Rensselaer | New York | 36083 | 865 | 42 |
510415 | 510415 | 2020-09-07 | Rensselaer | New York | 36083 | 860 | 42 |
507182 | 507182 | 2020-09-06 | Rensselaer | New York | 36083 | 859 | 42 |
503950 | 503950 | 2020-09-05 | Rensselaer | New York | 36083 | 858 | 42 |
500716 | 500716 | 2020-09-04 | Rensselaer | New York | 36083 | 854 | 42 |
497482 | 497482 | 2020-09-03 | Rensselaer | New York | 36083 | 848 | 42 |
494249 | 494249 | 2020-09-02 | Rensselaer | New York | 36083 | 844 | 42 |
491015 | 491015 | 2020-09-01 | Rensselaer | New York | 36083 | 841 | 41 |
487782 | 487782 | 2020-08-31 | Rensselaer | New York | 36083 | 838 | 41 |
484549 | 484549 | 2020-08-30 | Rensselaer | New York | 36083 | 833 | 41 |
481314 | 481314 | 2020-08-29 | Rensselaer | New York | 36083 | 830 | 41 |
478081 | 478081 | 2020-08-28 | Rensselaer | New York | 36083 | 826 | 41 |
474848 | 474848 | 2020-08-27 | Rensselaer | New York | 36083 | 823 | 41 |
471614 | 471614 | 2020-08-26 | Rensselaer | New York | 36083 | 822 | 41 |
468382 | 468382 | 2020-08-25 | Rensselaer | New York | 36083 | 819 | 41 |
465154 | 465154 | 2020-08-24 | Rensselaer | New York | 36083 | 818 | 41 |
461925 | 461925 | 2020-08-23 | Rensselaer | New York | 36083 | 817 | 41 |
458697 | 458697 | 2020-08-22 | Rensselaer | New York | 36083 | 813 | 41 |
455469 | 455469 | 2020-08-21 | Rensselaer | New York | 36083 | 810 | 41 |
452241 | 452241 | 2020-08-20 | Rensselaer | New York | 36083 | 809 | 41 |
449013 | 449013 | 2020-08-19 | Rensselaer | New York | 36083 | 804 | 41 |
445785 | 445785 | 2020-08-18 | Rensselaer | New York | 36083 | 801 | 41 |
442559 | 442559 | 2020-08-17 | Rensselaer | New York | 36083 | 795 | 41 |
439332 | 439332 | 2020-08-16 | Rensselaer | New York | 36083 | 795 | 40 |
436107 | 436107 | 2020-08-15 | Rensselaer | New York | 36083 | 789 | 39 |
432881 | 432881 | 2020-08-14 | Rensselaer | New York | 36083 | 785 | 39 |
429655 | 429655 | 2020-08-13 | Rensselaer | New York | 36083 | 782 | 39 |
426430 | 426430 | 2020-08-12 | Rensselaer | New York | 36083 | 780 | 38 |
423207 | 423207 | 2020-08-11 | Rensselaer | New York | 36083 | 770 | 38 |
419984 | 419984 | 2020-08-10 | Rensselaer | New York | 36083 | 766 | 38 |
416764 | 416764 | 2020-08-09 | Rensselaer | New York | 36083 | 765 | 37 |
413543 | 413543 | 2020-08-08 | Rensselaer | New York | 36083 | 761 | 36 |
410323 | 410323 | 2020-08-07 | Rensselaer | New York | 36083 | 759 | 35 |
407103 | 407103 | 2020-08-06 | Rensselaer | New York | 36083 | 758 | 35 |
403884 | 403884 | 2020-08-05 | Rensselaer | New York | 36083 | 755 | 39 |
400666 | 400666 | 2020-08-04 | Rensselaer | New York | 36083 | 748 | 39 |
397451 | 397451 | 2020-08-03 | Rensselaer | New York | 36083 | 740 | 39 |
394234 | 394234 | 2020-08-02 | Rensselaer | New York | 36083 | 736 | 39 |
391018 | 391018 | 2020-08-01 | Rensselaer | New York | 36083 | 734 | 39 |
387801 | 387801 | 2020-07-31 | Rensselaer | New York | 36083 | 724 | 39 |
384584 | 384584 | 2020-07-30 | Rensselaer | New York | 36083 | 718 | 39 |
381366 | 381366 | 2020-07-29 | Rensselaer | New York | 36083 | 694 | 39 |
378149 | 378149 | 2020-07-28 | Rensselaer | New York | 36083 | 690 | 39 |
374933 | 374933 | 2020-07-27 | Rensselaer | New York | 36083 | 687 | 39 |
371721 | 371721 | 2020-07-26 | Rensselaer | New York | 36083 | 684 | 39 |
368509 | 368509 | 2020-07-25 | Rensselaer | New York | 36083 | 681 | 39 |
365300 | 365300 | 2020-07-24 | Rensselaer | New York | 36083 | 676 | 39 |
362094 | 362094 | 2020-07-23 | Rensselaer | New York | 36083 | 669 | 39 |
358888 | 358888 | 2020-07-22 | Rensselaer | New York | 36083 | 668 | 39 |
355684 | 355684 | 2020-07-21 | Rensselaer | New York | 36083 | 658 | 39 |
352481 | 352481 | 2020-07-20 | Rensselaer | New York | 36083 | 653 | 39 |
349278 | 349278 | 2020-07-19 | Rensselaer | New York | 36083 | 651 | 39 |
346077 | 346077 | 2020-07-18 | Rensselaer | New York | 36083 | 650 | 39 |
342878 | 342878 | 2020-07-17 | Rensselaer | New York | 36083 | 643 | 38 |
339680 | 339680 | 2020-07-16 | Rensselaer | New York | 36083 | 639 | 38 |
336484 | 336484 | 2020-07-15 | Rensselaer | New York | 36083 | 632 | 38 |
333290 | 333290 | 2020-07-14 | Rensselaer | New York | 36083 | 625 | 38 |
330100 | 330100 | 2020-07-13 | Rensselaer | New York | 36083 | 617 | 38 |
326913 | 326913 | 2020-07-12 | Rensselaer | New York | 36083 | 616 | 38 |
323729 | 323729 | 2020-07-11 | Rensselaer | New York | 36083 | 593 | 38 |
320549 | 320549 | 2020-07-10 | Rensselaer | New York | 36083 | 588 | 38 |
317372 | 317372 | 2020-07-09 | Rensselaer | New York | 36083 | 586 | 38 |
314198 | 314198 | 2020-07-08 | Rensselaer | New York | 36083 | 580 | 38 |
311027 | 311027 | 2020-07-07 | Rensselaer | New York | 36083 | 571 | 38 |
307859 | 307859 | 2020-07-06 | Rensselaer | New York | 36083 | 568 | 38 |
304692 | 304692 | 2020-07-05 | Rensselaer | New York | 36083 | 565 | 37 |
301529 | 301529 | 2020-07-04 | Rensselaer | New York | 36083 | 563 | 37 |
298366 | 298366 | 2020-07-03 | Rensselaer | New York | 36083 | 559 | 37 |
295206 | 295206 | 2020-07-02 | Rensselaer | New York | 36083 | 556 | 37 |
292051 | 292051 | 2020-07-01 | Rensselaer | New York | 36083 | 555 | 37 |
288899 | 288899 | 2020-06-30 | Rensselaer | New York | 36083 | 553 | 37 |
285749 | 285749 | 2020-06-29 | Rensselaer | New York | 36083 | 553 | 37 |
282604 | 282604 | 2020-06-28 | Rensselaer | New York | 36083 | 551 | 37 |
279458 | 279458 | 2020-06-27 | Rensselaer | New York | 36083 | 550 | 37 |
276310 | 276310 | 2020-06-26 | Rensselaer | New York | 36083 | 549 | 37 |
273164 | 273164 | 2020-06-25 | Rensselaer | New York | 36083 | 541 | 37 |
270025 | 270025 | 2020-06-24 | Rensselaer | New York | 36083 | 534 | 37 |
266891 | 266891 | 2020-06-23 | Rensselaer | New York | 36083 | 533 | 37 |
263763 | 263763 | 2020-06-22 | Rensselaer | New York | 36083 | 528 | 37 |
260635 | 260635 | 2020-06-21 | Rensselaer | New York | 36083 | 524 | 37 |
257508 | 257508 | 2020-06-20 | Rensselaer | New York | 36083 | 521 | 37 |
254385 | 254385 | 2020-06-19 | Rensselaer | New York | 36083 | 519 | 36 |
251270 | 251270 | 2020-06-18 | Rensselaer | New York | 36083 | 515 | 36 |
248155 | 248155 | 2020-06-17 | Rensselaer | New York | 36083 | 515 | 37 |
245042 | 245042 | 2020-06-16 | Rensselaer | New York | 36083 | 514 | 34 |
241930 | 241930 | 2020-06-15 | Rensselaer | New York | 36083 | 514 | 34 |
238821 | 238821 | 2020-06-14 | Rensselaer | New York | 36083 | 513 | 34 |
235713 | 235713 | 2020-06-13 | Rensselaer | New York | 36083 | 511 | 34 |
232608 | 232608 | 2020-06-12 | Rensselaer | New York | 36083 | 510 | 33 |
229503 | 229503 | 2020-06-11 | Rensselaer | New York | 36083 | 508 | 33 |
226399 | 226399 | 2020-06-10 | Rensselaer | New York | 36083 | 507 | 33 |
223299 | 223299 | 2020-06-09 | Rensselaer | New York | 36083 | 505 | 32 |
220205 | 220205 | 2020-06-08 | Rensselaer | New York | 36083 | 503 | 32 |
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);