ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where fips = 36059 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 |
---|---|---|---|---|---|---|---|
922310 | 922310 | 2021-01-12 | Nassau | New York | 36059 | 105497 | 2496 |
919065 | 919065 | 2021-01-11 | Nassau | New York | 36059 | 104078 | 2489 |
915820 | 915820 | 2021-01-10 | Nassau | New York | 36059 | 102584 | 2482 |
912575 | 912575 | 2021-01-09 | Nassau | New York | 36059 | 101181 | 2470 |
909330 | 909330 | 2021-01-08 | Nassau | New York | 36059 | 99439 | 2462 |
906085 | 906085 | 2021-01-07 | Nassau | New York | 36059 | 97746 | 2452 |
902839 | 902839 | 2021-01-06 | Nassau | New York | 36059 | 96112 | 2445 |
899594 | 899594 | 2021-01-05 | Nassau | New York | 36059 | 94379 | 2431 |
896349 | 896349 | 2021-01-04 | Nassau | New York | 36059 | 93106 | 2428 |
893103 | 893103 | 2021-01-03 | Nassau | New York | 36059 | 92035 | 2420 |
889857 | 889857 | 2021-01-02 | Nassau | New York | 36059 | 90869 | 2409 |
886610 | 886610 | 2021-01-01 | Nassau | New York | 36059 | 89460 | 2401 |
883365 | 883365 | 2020-12-31 | Nassau | New York | 36059 | 87904 | 2390 |
880120 | 880120 | 2020-12-30 | Nassau | New York | 36059 | 86296 | 2381 |
876875 | 876875 | 2020-12-29 | Nassau | New York | 36059 | 85023 | 2374 |
873630 | 873630 | 2020-12-28 | Nassau | New York | 36059 | 84044 | 2366 |
870385 | 870385 | 2020-12-27 | Nassau | New York | 36059 | 83045 | 2363 |
867140 | 867140 | 2020-12-26 | Nassau | New York | 36059 | 82233 | 2359 |
863895 | 863895 | 2020-12-25 | Nassau | New York | 36059 | 81099 | 2356 |
860650 | 860650 | 2020-12-24 | Nassau | New York | 36059 | 80003 | 2354 |
857405 | 857405 | 2020-12-23 | Nassau | New York | 36059 | 78983 | 2346 |
854160 | 854160 | 2020-12-22 | Nassau | New York | 36059 | 77968 | 2337 |
850915 | 850915 | 2020-12-21 | Nassau | New York | 36059 | 77088 | 2331 |
847670 | 847670 | 2020-12-20 | Nassau | New York | 36059 | 76322 | 2325 |
844425 | 844425 | 2020-12-19 | Nassau | New York | 36059 | 75421 | 2318 |
841179 | 841179 | 2020-12-18 | Nassau | New York | 36059 | 74658 | 2314 |
837934 | 837934 | 2020-12-17 | Nassau | New York | 36059 | 73757 | 2309 |
834688 | 834688 | 2020-12-16 | Nassau | New York | 36059 | 72904 | 2306 |
831442 | 831442 | 2020-12-15 | Nassau | New York | 36059 | 72122 | 2304 |
828195 | 828195 | 2020-12-14 | Nassau | New York | 36059 | 71214 | 2300 |
824949 | 824949 | 2020-12-13 | Nassau | New York | 36059 | 70475 | 2297 |
821702 | 821702 | 2020-12-12 | Nassau | New York | 36059 | 69636 | 2294 |
818456 | 818456 | 2020-12-11 | Nassau | New York | 36059 | 68737 | 2293 |
815210 | 815210 | 2020-12-10 | Nassau | New York | 36059 | 67978 | 2292 |
811965 | 811965 | 2020-12-09 | Nassau | New York | 36059 | 67203 | 2285 |
808720 | 808720 | 2020-12-08 | Nassau | New York | 36059 | 66495 | 2278 |
805475 | 805475 | 2020-12-07 | Nassau | New York | 36059 | 65632 | 2273 |
802230 | 802230 | 2020-12-06 | Nassau | New York | 36059 | 65098 | 2269 |
798985 | 798985 | 2020-12-05 | Nassau | New York | 36059 | 64359 | 2269 |
795740 | 795740 | 2020-12-04 | Nassau | New York | 36059 | 63661 | 2266 |
792495 | 792495 | 2020-12-03 | Nassau | New York | 36059 | 62745 | 2264 |
789250 | 789250 | 2020-12-02 | Nassau | New York | 36059 | 61988 | 2262 |
786005 | 786005 | 2020-12-01 | Nassau | New York | 36059 | 61162 | 2260 |
782761 | 782761 | 2020-11-30 | Nassau | New York | 36059 | 60701 | 2257 |
779515 | 779515 | 2020-11-29 | Nassau | New York | 36059 | 60181 | 2256 |
776270 | 776270 | 2020-11-28 | Nassau | New York | 36059 | 59700 | 2251 |
773025 | 773025 | 2020-11-27 | Nassau | New York | 36059 | 59238 | 2248 |
769780 | 769780 | 2020-11-26 | Nassau | New York | 36059 | 58567 | 2248 |
766534 | 766534 | 2020-11-25 | Nassau | New York | 36059 | 57985 | 2244 |
763289 | 763289 | 2020-11-24 | Nassau | New York | 36059 | 57489 | 2244 |
760044 | 760044 | 2020-11-23 | Nassau | New York | 36059 | 57127 | 2241 |
756798 | 756798 | 2020-11-22 | Nassau | New York | 36059 | 56706 | 2240 |
753551 | 753551 | 2020-11-21 | Nassau | New York | 36059 | 56269 | 2239 |
750305 | 750305 | 2020-11-20 | Nassau | New York | 36059 | 55875 | 2238 |
747059 | 747059 | 2020-11-19 | Nassau | New York | 36059 | 55486 | 2238 |
743813 | 743813 | 2020-11-18 | Nassau | New York | 36059 | 55112 | 2236 |
740566 | 740566 | 2020-11-17 | Nassau | New York | 36059 | 54715 | 2234 |
737321 | 737321 | 2020-11-16 | Nassau | New York | 36059 | 54309 | 2233 |
734077 | 734077 | 2020-11-15 | Nassau | New York | 36059 | 54014 | 2231 |
730831 | 730831 | 2020-11-14 | Nassau | New York | 36059 | 53688 | 2229 |
727587 | 727587 | 2020-11-13 | Nassau | New York | 36059 | 53271 | 2229 |
724343 | 724343 | 2020-11-12 | Nassau | New York | 36059 | 52897 | 2226 |
721100 | 721100 | 2020-11-11 | Nassau | New York | 36059 | 52575 | 2226 |
717857 | 717857 | 2020-11-10 | Nassau | New York | 36059 | 52173 | 2224 |
714614 | 714614 | 2020-11-09 | Nassau | New York | 36059 | 51895 | 2222 |
711370 | 711370 | 2020-11-08 | Nassau | New York | 36059 | 51682 | 2222 |
708126 | 708126 | 2020-11-07 | Nassau | New York | 36059 | 51418 | 2221 |
704883 | 704883 | 2020-11-06 | Nassau | New York | 36059 | 51164 | 2220 |
701640 | 701640 | 2020-11-05 | Nassau | New York | 36059 | 50918 | 2218 |
698396 | 698396 | 2020-11-04 | Nassau | New York | 36059 | 50702 | 2218 |
695153 | 695153 | 2020-11-03 | Nassau | New York | 36059 | 50602 | 2216 |
691911 | 691911 | 2020-11-02 | Nassau | New York | 36059 | 50407 | 2216 |
688667 | 688667 | 2020-11-01 | Nassau | New York | 36059 | 50294 | 2216 |
685422 | 685422 | 2020-10-31 | Nassau | New York | 36059 | 50153 | 2215 |
682179 | 682179 | 2020-10-30 | Nassau | New York | 36059 | 50007 | 2216 |
678936 | 678936 | 2020-10-29 | Nassau | New York | 36059 | 49841 | 2215 |
675693 | 675693 | 2020-10-28 | Nassau | New York | 36059 | 49663 | 2214 |
672450 | 672450 | 2020-10-27 | Nassau | New York | 36059 | 49496 | 2213 |
669208 | 669208 | 2020-10-26 | Nassau | New York | 36059 | 49377 | 2209 |
665964 | 665964 | 2020-10-25 | Nassau | New York | 36059 | 49312 | 2209 |
662719 | 662719 | 2020-10-24 | Nassau | New York | 36059 | 49203 | 2209 |
659475 | 659475 | 2020-10-23 | Nassau | New York | 36059 | 49042 | 2208 |
656231 | 656231 | 2020-10-22 | Nassau | New York | 36059 | 48941 | 2208 |
652986 | 652986 | 2020-10-21 | Nassau | New York | 36059 | 48864 | 2208 |
649741 | 649741 | 2020-10-20 | Nassau | New York | 36059 | 48731 | 2208 |
646497 | 646497 | 2020-10-19 | Nassau | New York | 36059 | 48657 | 2208 |
643251 | 643251 | 2020-10-18 | Nassau | New York | 36059 | 48596 | 2208 |
640003 | 640003 | 2020-10-17 | Nassau | New York | 36059 | 48494 | 2208 |
636757 | 636757 | 2020-10-16 | Nassau | New York | 36059 | 48377 | 2208 |
633511 | 633511 | 2020-10-15 | Nassau | New York | 36059 | 48272 | 2205 |
630266 | 630266 | 2020-10-14 | Nassau | New York | 36059 | 48184 | 2205 |
627022 | 627022 | 2020-10-13 | Nassau | New York | 36059 | 48099 | 2205 |
623780 | 623780 | 2020-10-12 | Nassau | New York | 36059 | 47998 | 2204 |
620537 | 620537 | 2020-10-11 | Nassau | New York | 36059 | 47933 | 2204 |
617295 | 617295 | 2020-10-10 | Nassau | New York | 36059 | 47841 | 2204 |
614053 | 614053 | 2020-10-09 | Nassau | New York | 36059 | 47736 | 2204 |
610812 | 610812 | 2020-10-08 | Nassau | New York | 36059 | 47656 | 2204 |
607570 | 607570 | 2020-10-07 | Nassau | New York | 36059 | 47516 | 2204 |
604327 | 604327 | 2020-10-06 | Nassau | New York | 36059 | 47392 | 2204 |
601085 | 601085 | 2020-10-05 | Nassau | New York | 36059 | 47302 | 2204 |
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);