ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 34023 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175999 | 2175999 | 2022-02-02 | Middlesex | New Jersey | 34023 | 184150 | 2766 |
2172746 | 2172746 | 2022-02-01 | Middlesex | New Jersey | 34023 | 183715 | 2760 |
2169493 | 2169493 | 2022-01-31 | Middlesex | New Jersey | 34023 | 183481 | 2748 |
2166238 | 2166238 | 2022-01-30 | Middlesex | New Jersey | 34023 | 183324 | 2746 |
2162983 | 2162983 | 2022-01-29 | Middlesex | New Jersey | 34023 | 183149 | 2744 |
2159728 | 2159728 | 2022-01-28 | Middlesex | New Jersey | 34023 | 182691 | 2743 |
2156474 | 2156474 | 2022-01-27 | Middlesex | New Jersey | 34023 | 179551 | 2738 |
2153221 | 2153221 | 2022-01-26 | Middlesex | New Jersey | 34023 | 179039 | 2731 |
2149969 | 2149969 | 2022-01-25 | Middlesex | New Jersey | 34023 | 178525 | 2717 |
2146717 | 2146717 | 2022-01-24 | Middlesex | New Jersey | 34023 | 178036 | 2700 |
2143462 | 2143462 | 2022-01-23 | Middlesex | New Jersey | 34023 | 177626 | 2697 |
2140207 | 2140207 | 2022-01-22 | Middlesex | New Jersey | 34023 | 176999 | 2696 |
2136951 | 2136951 | 2022-01-21 | Middlesex | New Jersey | 34023 | 176259 | 2688 |
2133699 | 2133699 | 2022-01-20 | Middlesex | New Jersey | 34023 | 175371 | 2677 |
2130446 | 2130446 | 2022-01-19 | Middlesex | New Jersey | 34023 | 174534 | 2668 |
2127192 | 2127192 | 2022-01-18 | Middlesex | New Jersey | 34023 | 173769 | 2660 |
2123940 | 2123940 | 2022-01-17 | Middlesex | New Jersey | 34023 | 172926 | 2656 |
2120688 | 2120688 | 2022-01-16 | Middlesex | New Jersey | 34023 | 172151 | 2651 |
2117436 | 2117436 | 2022-01-15 | Middlesex | New Jersey | 34023 | 170825 | 2651 |
2114185 | 2114185 | 2022-01-14 | Middlesex | New Jersey | 34023 | 169492 | 2639 |
2110933 | 2110933 | 2022-01-13 | Middlesex | New Jersey | 34023 | 167448 | 2628 |
2107682 | 2107682 | 2022-01-12 | Middlesex | New Jersey | 34023 | 165614 | 2623 |
2104431 | 2104431 | 2022-01-11 | Middlesex | New Jersey | 34023 | 164057 | 2613 |
2101180 | 2101180 | 2022-01-10 | Middlesex | New Jersey | 34023 | 162189 | 2597 |
2097929 | 2097929 | 2022-01-09 | Middlesex | New Jersey | 34023 | 159953 | 2591 |
2094677 | 2094677 | 2022-01-08 | Middlesex | New Jersey | 34023 | 157690 | 2590 |
2091425 | 2091425 | 2022-01-07 | Middlesex | New Jersey | 34023 | 155121 | 2587 |
2088174 | 2088174 | 2022-01-06 | Middlesex | New Jersey | 34023 | 151676 | 2580 |
2084922 | 2084922 | 2022-01-05 | Middlesex | New Jersey | 34023 | 148452 | 2570 |
2081670 | 2081670 | 2022-01-04 | Middlesex | New Jersey | 34023 | 145193 | 2568 |
2078418 | 2078418 | 2022-01-03 | Middlesex | New Jersey | 34023 | 143044 | 2559 |
2075167 | 2075167 | 2022-01-02 | Middlesex | New Jersey | 34023 | 141411 | 2559 |
2071916 | 2071916 | 2022-01-01 | Middlesex | New Jersey | 34023 | 139124 | 2558 |
2068665 | 2068665 | 2021-12-31 | Middlesex | New Jersey | 34023 | 136135 | 2555 |
2065414 | 2065414 | 2021-12-30 | Middlesex | New Jersey | 34023 | 133240 | 2551 |
2062164 | 2062164 | 2021-12-29 | Middlesex | New Jersey | 34023 | 130453 | 2551 |
2058915 | 2058915 | 2021-12-28 | Middlesex | New Jersey | 34023 | 128358 | 2548 |
2055666 | 2055666 | 2021-12-27 | Middlesex | New Jersey | 34023 | 126884 | 2540 |
2052416 | 2052416 | 2021-12-26 | Middlesex | New Jersey | 34023 | 126032 | 2539 |
2049166 | 2049166 | 2021-12-25 | Middlesex | New Jersey | 34023 | 124879 | 2539 |
2045916 | 2045916 | 2021-12-24 | Middlesex | New Jersey | 34023 | 123320 | 2538 |
2042666 | 2042666 | 2021-12-23 | Middlesex | New Jersey | 34023 | 121682 | 2535 |
2039417 | 2039417 | 2021-12-22 | Middlesex | New Jersey | 34023 | 120059 | 2530 |
2036167 | 2036167 | 2021-12-21 | Middlesex | New Jersey | 34023 | 119175 | 2527 |
2032917 | 2032917 | 2021-12-20 | Middlesex | New Jersey | 34023 | 118521 | 2524 |
2029666 | 2029666 | 2021-12-19 | Middlesex | New Jersey | 34023 | 117953 | 2522 |
2026415 | 2026415 | 2021-12-18 | Middlesex | New Jersey | 34023 | 117329 | 2522 |
2023164 | 2023164 | 2021-12-17 | Middlesex | New Jersey | 34023 | 116748 | 2520 |
2019913 | 2019913 | 2021-12-16 | Middlesex | New Jersey | 34023 | 116196 | 2520 |
2016663 | 2016663 | 2021-12-15 | Middlesex | New Jersey | 34023 | 115599 | 2518 |
2013412 | 2013412 | 2021-12-14 | Middlesex | New Jersey | 34023 | 115163 | 2516 |
2010161 | 2010161 | 2021-12-13 | Middlesex | New Jersey | 34023 | 114769 | 2510 |
2006910 | 2006910 | 2021-12-12 | Middlesex | New Jersey | 34023 | 114494 | 2508 |
2003659 | 2003659 | 2021-12-11 | Middlesex | New Jersey | 34023 | 114193 | 2506 |
2000409 | 2000409 | 2021-12-10 | Middlesex | New Jersey | 34023 | 113798 | 2503 |
1997158 | 1997158 | 2021-12-09 | Middlesex | New Jersey | 34023 | 113349 | 2503 |
1993907 | 1993907 | 2021-12-08 | Middlesex | New Jersey | 34023 | 112804 | 2502 |
1990656 | 1990656 | 2021-12-07 | Middlesex | New Jersey | 34023 | 112442 | 2500 |
1987406 | 1987406 | 2021-12-06 | Middlesex | New Jersey | 34023 | 112159 | 2500 |
1984156 | 1984156 | 2021-12-05 | Middlesex | New Jersey | 34023 | 111935 | 2498 |
1980906 | 1980906 | 2021-12-04 | Middlesex | New Jersey | 34023 | 111650 | 2498 |
1977656 | 1977656 | 2021-12-03 | Middlesex | New Jersey | 34023 | 111321 | 2496 |
1974406 | 1974406 | 2021-12-02 | Middlesex | New Jersey | 34023 | 110982 | 2495 |
1971157 | 1971157 | 2021-12-01 | Middlesex | New Jersey | 34023 | 110664 | 2494 |
1967907 | 1967907 | 2021-11-30 | Middlesex | New Jersey | 34023 | 110405 | 2493 |
1964655 | 1964655 | 2021-11-29 | Middlesex | New Jersey | 34023 | 110133 | 2490 |
1961404 | 1961404 | 2021-11-28 | Middlesex | New Jersey | 34023 | 109969 | 2489 |
1958153 | 1958153 | 2021-11-27 | Middlesex | New Jersey | 34023 | 109814 | 2489 |
1954902 | 1954902 | 2021-11-26 | Middlesex | New Jersey | 34023 | 109715 | 2488 |
1951651 | 1951651 | 2021-11-25 | Middlesex | New Jersey | 34023 | 109556 | 2488 |
1948400 | 1948400 | 2021-11-24 | Middlesex | New Jersey | 34023 | 109346 | 2487 |
1945149 | 1945149 | 2021-11-23 | Middlesex | New Jersey | 34023 | 109170 | 2487 |
1941898 | 1941898 | 2021-11-22 | Middlesex | New Jersey | 34023 | 108985 | 2485 |
1938648 | 1938648 | 2021-11-21 | Middlesex | New Jersey | 34023 | 108871 | 2485 |
1935398 | 1935398 | 2021-11-20 | Middlesex | New Jersey | 34023 | 108730 | 2485 |
1932148 | 1932148 | 2021-11-19 | Middlesex | New Jersey | 34023 | 108583 | 2486 |
1928897 | 1928897 | 2021-11-18 | Middlesex | New Jersey | 34023 | 108443 | 2485 |
1925647 | 1925647 | 2021-11-17 | Middlesex | New Jersey | 34023 | 108248 | 2483 |
1922398 | 1922398 | 2021-11-16 | Middlesex | New Jersey | 34023 | 108095 | 2483 |
1919148 | 1919148 | 2021-11-15 | Middlesex | New Jersey | 34023 | 107982 | 2479 |
1915898 | 1915898 | 2021-11-14 | Middlesex | New Jersey | 34023 | 107911 | 2479 |
1912648 | 1912648 | 2021-11-13 | Middlesex | New Jersey | 34023 | 107783 | 2479 |
1909398 | 1909398 | 2021-11-12 | Middlesex | New Jersey | 34023 | 107672 | 2479 |
1906149 | 1906149 | 2021-11-11 | Middlesex | New Jersey | 34023 | 107549 | 2479 |
1902900 | 1902900 | 2021-11-10 | Middlesex | New Jersey | 34023 | 107414 | 2479 |
1899650 | 1899650 | 2021-11-09 | Middlesex | New Jersey | 34023 | 107308 | 2479 |
1896400 | 1896400 | 2021-11-08 | Middlesex | New Jersey | 34023 | 107193 | 2475 |
1893150 | 1893150 | 2021-11-07 | Middlesex | New Jersey | 34023 | 107117 | 2475 |
1889900 | 1889900 | 2021-11-06 | Middlesex | New Jersey | 34023 | 107032 | 2475 |
1886650 | 1886650 | 2021-11-05 | Middlesex | New Jersey | 34023 | 106938 | 2475 |
1883401 | 1883401 | 2021-11-04 | Middlesex | New Jersey | 34023 | 106845 | 2472 |
1880152 | 1880152 | 2021-11-03 | Middlesex | New Jersey | 34023 | 106705 | 2472 |
1876903 | 1876903 | 2021-11-02 | Middlesex | New Jersey | 34023 | 106624 | 2472 |
1873654 | 1873654 | 2021-11-01 | Middlesex | New Jersey | 34023 | 106555 | 2469 |
1870405 | 1870405 | 2021-10-31 | Middlesex | New Jersey | 34023 | 106507 | 2469 |
1867156 | 1867156 | 2021-10-30 | Middlesex | New Jersey | 34023 | 106431 | 2469 |
1863907 | 1863907 | 2021-10-29 | Middlesex | New Jersey | 34023 | 106341 | 2468 |
1860658 | 1860658 | 2021-10-28 | Middlesex | New Jersey | 34023 | 106271 | 2466 |
1857409 | 1857409 | 2021-10-27 | Middlesex | New Jersey | 34023 | 106166 | 2463 |
1854160 | 1854160 | 2021-10-26 | Middlesex | New Jersey | 34023 | 106076 | 2463 |
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);