ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 25009 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175428 | 2175428 | 2022-02-02 | Essex | Massachusetts | 25009 | 198689 | 2985 |
2172175 | 2172175 | 2022-02-01 | Essex | Massachusetts | 25009 | 198216 | 2976 |
2168922 | 2168922 | 2022-01-31 | Essex | Massachusetts | 25009 | 197960 | 2964 |
2165667 | 2165667 | 2022-01-30 | Essex | Massachusetts | 25009 | 196731 | 2951 |
2162412 | 2162412 | 2022-01-29 | Essex | Massachusetts | 25009 | 196731 | 2951 |
2159157 | 2159157 | 2022-01-28 | Essex | Massachusetts | 25009 | 196731 | 2951 |
2155903 | 2155903 | 2022-01-27 | Essex | Massachusetts | 25009 | 196066 | 2945 |
2152650 | 2152650 | 2022-01-26 | Essex | Massachusetts | 25009 | 195242 | 2932 |
2149398 | 2149398 | 2022-01-25 | Essex | Massachusetts | 25009 | 194465 | 2923 |
2146146 | 2146146 | 2022-01-24 | Essex | Massachusetts | 25009 | 193746 | 2903 |
2142891 | 2142891 | 2022-01-23 | Essex | Massachusetts | 25009 | 191083 | 2892 |
2139636 | 2139636 | 2022-01-22 | Essex | Massachusetts | 25009 | 191083 | 2892 |
2136380 | 2136380 | 2022-01-21 | Essex | Massachusetts | 25009 | 191083 | 2892 |
2133128 | 2133128 | 2022-01-20 | Essex | Massachusetts | 25009 | 189729 | 2875 |
2129875 | 2129875 | 2022-01-19 | Essex | Massachusetts | 25009 | 188286 | 2865 |
2126621 | 2126621 | 2022-01-18 | Essex | Massachusetts | 25009 | 186681 | 2838 |
2123369 | 2123369 | 2022-01-17 | Essex | Massachusetts | 25009 | 181006 | 2831 |
2120117 | 2120117 | 2022-01-16 | Essex | Massachusetts | 25009 | 181006 | 2831 |
2116865 | 2116865 | 2022-01-15 | Essex | Massachusetts | 25009 | 181006 | 2831 |
2113614 | 2113614 | 2022-01-14 | Essex | Massachusetts | 25009 | 181006 | 2831 |
2110362 | 2110362 | 2022-01-13 | Essex | Massachusetts | 25009 | 180115 | 2817 |
2107111 | 2107111 | 2022-01-12 | Essex | Massachusetts | 25009 | 177805 | 2811 |
2103860 | 2103860 | 2022-01-11 | Essex | Massachusetts | 25009 | 175240 | 2795 |
2100609 | 2100609 | 2022-01-10 | Essex | Massachusetts | 25009 | 173392 | 2780 |
2097358 | 2097358 | 2022-01-09 | Essex | Massachusetts | 25009 | 166430 | 2769 |
2094106 | 2094106 | 2022-01-08 | Essex | Massachusetts | 25009 | 166430 | 2769 |
2090854 | 2090854 | 2022-01-07 | Essex | Massachusetts | 25009 | 166430 | 2769 |
2087603 | 2087603 | 2022-01-06 | Essex | Massachusetts | 25009 | 162507 | 2759 |
2084351 | 2084351 | 2022-01-05 | Essex | Massachusetts | 25009 | 159515 | 2749 |
2081099 | 2081099 | 2022-01-04 | Essex | Massachusetts | 25009 | 155765 | 2746 |
2077847 | 2077847 | 2022-01-03 | Essex | Massachusetts | 25009 | 153925 | 2730 |
2074596 | 2074596 | 2022-01-02 | Essex | Massachusetts | 25009 | 149987 | 2722 |
2071345 | 2071345 | 2022-01-01 | Essex | Massachusetts | 25009 | 149987 | 2722 |
2068094 | 2068094 | 2021-12-31 | Essex | Massachusetts | 25009 | 149987 | 2722 |
2064843 | 2064843 | 2021-12-30 | Essex | Massachusetts | 25009 | 146881 | 2717 |
2061593 | 2061593 | 2021-12-29 | Essex | Massachusetts | 25009 | 143818 | 2712 |
2058344 | 2058344 | 2021-12-28 | Essex | Massachusetts | 25009 | 141523 | 2706 |
2055095 | 2055095 | 2021-12-27 | Essex | Massachusetts | 25009 | 140381 | 2700 |
2051845 | 2051845 | 2021-12-26 | Essex | Massachusetts | 25009 | 138812 | 2697 |
2048595 | 2048595 | 2021-12-25 | Essex | Massachusetts | 25009 | 138812 | 2697 |
2045345 | 2045345 | 2021-12-24 | Essex | Massachusetts | 25009 | 138812 | 2697 |
2042095 | 2042095 | 2021-12-23 | Essex | Massachusetts | 25009 | 137357 | 2690 |
2038846 | 2038846 | 2021-12-22 | Essex | Massachusetts | 25009 | 136197 | 2684 |
2035596 | 2035596 | 2021-12-21 | Essex | Massachusetts | 25009 | 135274 | 2678 |
2032346 | 2032346 | 2021-12-20 | Essex | Massachusetts | 25009 | 134532 | 2673 |
2029095 | 2029095 | 2021-12-19 | Essex | Massachusetts | 25009 | 132872 | 2662 |
2025844 | 2025844 | 2021-12-18 | Essex | Massachusetts | 25009 | 132872 | 2662 |
2022593 | 2022593 | 2021-12-17 | Essex | Massachusetts | 25009 | 132872 | 2662 |
2019342 | 2019342 | 2021-12-16 | Essex | Massachusetts | 25009 | 132127 | 2655 |
2016092 | 2016092 | 2021-12-15 | Essex | Massachusetts | 25009 | 131433 | 2647 |
2012841 | 2012841 | 2021-12-14 | Essex | Massachusetts | 25009 | 130702 | 2642 |
2009590 | 2009590 | 2021-12-13 | Essex | Massachusetts | 25009 | 130107 | 2632 |
2006339 | 2006339 | 2021-12-12 | Essex | Massachusetts | 25009 | 128724 | 2627 |
2003088 | 2003088 | 2021-12-11 | Essex | Massachusetts | 25009 | 128724 | 2627 |
1999838 | 1999838 | 2021-12-10 | Essex | Massachusetts | 25009 | 128724 | 2627 |
1996587 | 1996587 | 2021-12-09 | Essex | Massachusetts | 25009 | 128064 | 2623 |
1993336 | 1993336 | 2021-12-08 | Essex | Massachusetts | 25009 | 127345 | 2618 |
1990085 | 1990085 | 2021-12-07 | Essex | Massachusetts | 25009 | 126527 | 2616 |
1986835 | 1986835 | 2021-12-06 | Essex | Massachusetts | 25009 | 126012 | 2608 |
1983585 | 1983585 | 2021-12-05 | Essex | Massachusetts | 25009 | 124533 | 2604 |
1980335 | 1980335 | 2021-12-04 | Essex | Massachusetts | 25009 | 124533 | 2604 |
1977085 | 1977085 | 2021-12-03 | Essex | Massachusetts | 25009 | 124533 | 2604 |
1973835 | 1973835 | 2021-12-02 | Essex | Massachusetts | 25009 | 123763 | 2603 |
1970586 | 1970586 | 2021-12-01 | Essex | Massachusetts | 25009 | 123013 | 2601 |
1967336 | 1967336 | 2021-11-30 | Essex | Massachusetts | 25009 | 122302 | 2594 |
1964084 | 1964084 | 2021-11-29 | Essex | Massachusetts | 25009 | 121868 | 2589 |
1960833 | 1960833 | 2021-11-28 | Essex | Massachusetts | 25009 | 121070 | 2580 |
1957582 | 1957582 | 2021-11-27 | Essex | Massachusetts | 25009 | 121070 | 2580 |
1954331 | 1954331 | 2021-11-26 | Essex | Massachusetts | 25009 | 121070 | 2580 |
1951080 | 1951080 | 2021-11-25 | Essex | Massachusetts | 25009 | 120475 | 2576 |
1947829 | 1947829 | 2021-11-24 | Essex | Massachusetts | 25009 | 120475 | 2576 |
1944578 | 1944578 | 2021-11-23 | Essex | Massachusetts | 25009 | 119955 | 2571 |
1941327 | 1941327 | 2021-11-22 | Essex | Massachusetts | 25009 | 119580 | 2566 |
1938077 | 1938077 | 2021-11-21 | Essex | Massachusetts | 25009 | 118653 | 2561 |
1934827 | 1934827 | 2021-11-20 | Essex | Massachusetts | 25009 | 118653 | 2561 |
1931577 | 1931577 | 2021-11-19 | Essex | Massachusetts | 25009 | 118653 | 2561 |
1928326 | 1928326 | 2021-11-18 | Essex | Massachusetts | 25009 | 118320 | 2558 |
1925076 | 1925076 | 2021-11-17 | Essex | Massachusetts | 25009 | 117844 | 2555 |
1921827 | 1921827 | 2021-11-16 | Essex | Massachusetts | 25009 | 117338 | 2546 |
1918577 | 1918577 | 2021-11-15 | Essex | Massachusetts | 25009 | 117026 | 2542 |
1915327 | 1915327 | 2021-11-14 | Essex | Massachusetts | 25009 | 116274 | 2539 |
1912077 | 1912077 | 2021-11-13 | Essex | Massachusetts | 25009 | 116274 | 2539 |
1908827 | 1908827 | 2021-11-12 | Essex | Massachusetts | 25009 | 116274 | 2539 |
1905578 | 1905578 | 2021-11-11 | Essex | Massachusetts | 25009 | 115699 | 2534 |
1902329 | 1902329 | 2021-11-10 | Essex | Massachusetts | 25009 | 115699 | 2534 |
1899079 | 1899079 | 2021-11-09 | Essex | Massachusetts | 25009 | 115314 | 2533 |
1895829 | 1895829 | 2021-11-08 | Essex | Massachusetts | 25009 | 115105 | 2530 |
1892579 | 1892579 | 2021-11-07 | Essex | Massachusetts | 25009 | 114525 | 2530 |
1889329 | 1889329 | 2021-11-06 | Essex | Massachusetts | 25009 | 114525 | 2530 |
1886079 | 1886079 | 2021-11-05 | Essex | Massachusetts | 25009 | 114525 | 2530 |
1882830 | 1882830 | 2021-11-04 | Essex | Massachusetts | 25009 | 114233 | 2527 |
1879581 | 1879581 | 2021-11-03 | Essex | Massachusetts | 25009 | 114001 | 2523 |
1876332 | 1876332 | 2021-11-02 | Essex | Massachusetts | 25009 | 113769 | 2521 |
1873083 | 1873083 | 2021-11-01 | Essex | Massachusetts | 25009 | 113611 | 2515 |
1869834 | 1869834 | 2021-10-31 | Essex | Massachusetts | 25009 | 113176 | 2513 |
1866585 | 1866585 | 2021-10-30 | Essex | Massachusetts | 25009 | 113176 | 2513 |
1863336 | 1863336 | 2021-10-29 | Essex | Massachusetts | 25009 | 113176 | 2513 |
1860087 | 1860087 | 2021-10-28 | Essex | Massachusetts | 25009 | 113000 | 2511 |
1856838 | 1856838 | 2021-10-27 | Essex | Massachusetts | 25009 | 112825 | 2511 |
1853589 | 1853589 | 2021-10-26 | Essex | Massachusetts | 25009 | 112647 | 2510 |
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);