ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where fips = 36111 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 |
---|---|---|---|---|---|---|---|
922334 | 922334 | 2021-01-12 | Ulster | New York | 36111 | 7038 | 175 |
919089 | 919089 | 2021-01-11 | Ulster | New York | 36111 | 6927 | 170 |
915844 | 915844 | 2021-01-10 | Ulster | New York | 36111 | 6835 | 167 |
912599 | 912599 | 2021-01-09 | Ulster | New York | 36111 | 6677 | 165 |
909354 | 909354 | 2021-01-08 | Ulster | New York | 36111 | 6557 | 158 |
906109 | 906109 | 2021-01-07 | Ulster | New York | 36111 | 6417 | 154 |
902863 | 902863 | 2021-01-06 | Ulster | New York | 36111 | 6304 | 151 |
899618 | 899618 | 2021-01-05 | Ulster | New York | 36111 | 6186 | 151 |
896373 | 896373 | 2021-01-04 | Ulster | New York | 36111 | 6089 | 149 |
893127 | 893127 | 2021-01-03 | Ulster | New York | 36111 | 6019 | 146 |
889881 | 889881 | 2021-01-02 | Ulster | New York | 36111 | 5935 | 145 |
886634 | 886634 | 2021-01-01 | Ulster | New York | 36111 | 5816 | 143 |
883389 | 883389 | 2020-12-31 | Ulster | New York | 36111 | 5679 | 141 |
880144 | 880144 | 2020-12-30 | Ulster | New York | 36111 | 5572 | 140 |
876899 | 876899 | 2020-12-29 | Ulster | New York | 36111 | 5498 | 140 |
873654 | 873654 | 2020-12-28 | Ulster | New York | 36111 | 5436 | 139 |
870409 | 870409 | 2020-12-27 | Ulster | New York | 36111 | 5380 | 138 |
867164 | 867164 | 2020-12-26 | Ulster | New York | 36111 | 5328 | 136 |
863919 | 863919 | 2020-12-25 | Ulster | New York | 36111 | 5241 | 136 |
860674 | 860674 | 2020-12-24 | Ulster | New York | 36111 | 5164 | 135 |
857429 | 857429 | 2020-12-23 | Ulster | New York | 36111 | 5079 | 135 |
854184 | 854184 | 2020-12-22 | Ulster | New York | 36111 | 5001 | 134 |
850939 | 850939 | 2020-12-21 | Ulster | New York | 36111 | 4926 | 132 |
847694 | 847694 | 2020-12-20 | Ulster | New York | 36111 | 4850 | 131 |
844449 | 844449 | 2020-12-19 | Ulster | New York | 36111 | 4791 | 129 |
841203 | 841203 | 2020-12-18 | Ulster | New York | 36111 | 4736 | 125 |
837958 | 837958 | 2020-12-17 | Ulster | New York | 36111 | 4614 | 120 |
834712 | 834712 | 2020-12-16 | Ulster | New York | 36111 | 4547 | 118 |
831466 | 831466 | 2020-12-15 | Ulster | New York | 36111 | 4485 | 118 |
828219 | 828219 | 2020-12-14 | Ulster | New York | 36111 | 4393 | 116 |
824973 | 824973 | 2020-12-13 | Ulster | New York | 36111 | 4327 | 116 |
821726 | 821726 | 2020-12-12 | Ulster | New York | 36111 | 4251 | 114 |
818480 | 818480 | 2020-12-11 | Ulster | New York | 36111 | 4176 | 111 |
815234 | 815234 | 2020-12-10 | Ulster | New York | 36111 | 4103 | 108 |
811989 | 811989 | 2020-12-09 | Ulster | New York | 36111 | 4029 | 108 |
808744 | 808744 | 2020-12-08 | Ulster | New York | 36111 | 3974 | 104 |
805499 | 805499 | 2020-12-07 | Ulster | New York | 36111 | 3897 | 103 |
802254 | 802254 | 2020-12-06 | Ulster | New York | 36111 | 3858 | 100 |
799009 | 799009 | 2020-12-05 | Ulster | New York | 36111 | 3773 | 95 |
795764 | 795764 | 2020-12-04 | Ulster | New York | 36111 | 3697 | 94 |
792519 | 792519 | 2020-12-03 | Ulster | New York | 36111 | 3606 | 94 |
789274 | 789274 | 2020-12-02 | Ulster | New York | 36111 | 3499 | 94 |
786029 | 786029 | 2020-12-01 | Ulster | New York | 36111 | 3434 | 94 |
782785 | 782785 | 2020-11-30 | Ulster | New York | 36111 | 3381 | 94 |
779539 | 779539 | 2020-11-29 | Ulster | New York | 36111 | 3325 | 93 |
776294 | 776294 | 2020-11-28 | Ulster | New York | 36111 | 3276 | 93 |
773049 | 773049 | 2020-11-27 | Ulster | New York | 36111 | 3238 | 93 |
769804 | 769804 | 2020-11-26 | Ulster | New York | 36111 | 3180 | 93 |
766558 | 766558 | 2020-11-25 | Ulster | New York | 36111 | 3141 | 93 |
763313 | 763313 | 2020-11-24 | Ulster | New York | 36111 | 3109 | 92 |
760068 | 760068 | 2020-11-23 | Ulster | New York | 36111 | 3073 | 90 |
756822 | 756822 | 2020-11-22 | Ulster | New York | 36111 | 3023 | 90 |
753575 | 753575 | 2020-11-21 | Ulster | New York | 36111 | 3004 | 90 |
750329 | 750329 | 2020-11-20 | Ulster | New York | 36111 | 2969 | 89 |
747083 | 747083 | 2020-11-19 | Ulster | New York | 36111 | 2937 | 89 |
743837 | 743837 | 2020-11-18 | Ulster | New York | 36111 | 2865 | 88 |
740590 | 740590 | 2020-11-17 | Ulster | New York | 36111 | 2835 | 87 |
737345 | 737345 | 2020-11-16 | Ulster | New York | 36111 | 2800 | 87 |
734101 | 734101 | 2020-11-15 | Ulster | New York | 36111 | 2788 | 87 |
730855 | 730855 | 2020-11-14 | Ulster | New York | 36111 | 2768 | 87 |
727611 | 727611 | 2020-11-13 | Ulster | New York | 36111 | 2738 | 87 |
724367 | 724367 | 2020-11-12 | Ulster | New York | 36111 | 2717 | 87 |
721124 | 721124 | 2020-11-11 | Ulster | New York | 36111 | 2694 | 87 |
717881 | 717881 | 2020-11-10 | Ulster | New York | 36111 | 2670 | 87 |
714638 | 714638 | 2020-11-09 | Ulster | New York | 36111 | 2647 | 87 |
711394 | 711394 | 2020-11-08 | Ulster | New York | 36111 | 2626 | 87 |
708150 | 708150 | 2020-11-07 | Ulster | New York | 36111 | 2607 | 87 |
704907 | 704907 | 2020-11-06 | Ulster | New York | 36111 | 2599 | 87 |
701664 | 701664 | 2020-11-05 | Ulster | New York | 36111 | 2588 | 87 |
698420 | 698420 | 2020-11-04 | Ulster | New York | 36111 | 2575 | 87 |
695177 | 695177 | 2020-11-03 | Ulster | New York | 36111 | 2568 | 86 |
691935 | 691935 | 2020-11-02 | Ulster | New York | 36111 | 2559 | 86 |
688691 | 688691 | 2020-11-01 | Ulster | New York | 36111 | 2556 | 86 |
685446 | 685446 | 2020-10-31 | Ulster | New York | 36111 | 2547 | 86 |
682203 | 682203 | 2020-10-30 | Ulster | New York | 36111 | 2538 | 86 |
678960 | 678960 | 2020-10-29 | Ulster | New York | 36111 | 2531 | 85 |
675717 | 675717 | 2020-10-28 | Ulster | New York | 36111 | 2518 | 85 |
672474 | 672474 | 2020-10-27 | Ulster | New York | 36111 | 2515 | 85 |
669232 | 669232 | 2020-10-26 | Ulster | New York | 36111 | 2500 | 84 |
665988 | 665988 | 2020-10-25 | Ulster | New York | 36111 | 2471 | 84 |
662743 | 662743 | 2020-10-24 | Ulster | New York | 36111 | 2459 | 84 |
659499 | 659499 | 2020-10-23 | Ulster | New York | 36111 | 2450 | 84 |
656255 | 656255 | 2020-10-22 | Ulster | New York | 36111 | 2436 | 84 |
653010 | 653010 | 2020-10-21 | Ulster | New York | 36111 | 2428 | 84 |
649765 | 649765 | 2020-10-20 | Ulster | New York | 36111 | 2419 | 84 |
646521 | 646521 | 2020-10-19 | Ulster | New York | 36111 | 2415 | 84 |
643275 | 643275 | 2020-10-18 | Ulster | New York | 36111 | 2411 | 84 |
640027 | 640027 | 2020-10-17 | Ulster | New York | 36111 | 2402 | 84 |
636781 | 636781 | 2020-10-16 | Ulster | New York | 36111 | 2395 | 84 |
633535 | 633535 | 2020-10-15 | Ulster | New York | 36111 | 2392 | 84 |
630290 | 630290 | 2020-10-14 | Ulster | New York | 36111 | 2386 | 84 |
627046 | 627046 | 2020-10-13 | Ulster | New York | 36111 | 2377 | 84 |
623804 | 623804 | 2020-10-12 | Ulster | New York | 36111 | 2366 | 84 |
620561 | 620561 | 2020-10-11 | Ulster | New York | 36111 | 2358 | 84 |
617319 | 617319 | 2020-10-10 | Ulster | New York | 36111 | 2355 | 84 |
614077 | 614077 | 2020-10-09 | Ulster | New York | 36111 | 2349 | 84 |
610836 | 610836 | 2020-10-08 | Ulster | New York | 36111 | 2343 | 84 |
607594 | 607594 | 2020-10-07 | Ulster | New York | 36111 | 2335 | 84 |
604351 | 604351 | 2020-10-06 | Ulster | New York | 36111 | 2329 | 84 |
601109 | 601109 | 2020-10-05 | Ulster | New York | 36111 | 2324 | 84 |
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);