ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 34021 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175998 | 2175998 | 2022-02-02 | Mercer | New Jersey | 34021 | 72633 | 1185 |
2172745 | 2172745 | 2022-02-01 | Mercer | New Jersey | 34021 | 72444 | 1183 |
2169492 | 2169492 | 2022-01-31 | Mercer | New Jersey | 34021 | 72305 | 1178 |
2166237 | 2166237 | 2022-01-30 | Mercer | New Jersey | 34021 | 72207 | 1178 |
2162982 | 2162982 | 2022-01-29 | Mercer | New Jersey | 34021 | 72111 | 1178 |
2159727 | 2159727 | 2022-01-28 | Mercer | New Jersey | 34021 | 71915 | 1176 |
2156473 | 2156473 | 2022-01-27 | Mercer | New Jersey | 34021 | 71604 | 1170 |
2153220 | 2153220 | 2022-01-26 | Mercer | New Jersey | 34021 | 71310 | 1164 |
2149968 | 2149968 | 2022-01-25 | Mercer | New Jersey | 34021 | 71037 | 1159 |
2146716 | 2146716 | 2022-01-24 | Mercer | New Jersey | 34021 | 70774 | 1150 |
2143461 | 2143461 | 2022-01-23 | Mercer | New Jersey | 34021 | 70560 | 1149 |
2140206 | 2140206 | 2022-01-22 | Mercer | New Jersey | 34021 | 70243 | 1149 |
2136950 | 2136950 | 2022-01-21 | Mercer | New Jersey | 34021 | 69857 | 1143 |
2133698 | 2133698 | 2022-01-20 | Mercer | New Jersey | 34021 | 69332 | 1142 |
2130445 | 2130445 | 2022-01-19 | Mercer | New Jersey | 34021 | 68799 | 1136 |
2127191 | 2127191 | 2022-01-18 | Mercer | New Jersey | 34021 | 68463 | 1127 |
2123939 | 2123939 | 2022-01-17 | Mercer | New Jersey | 34021 | 67859 | 1121 |
2120687 | 2120687 | 2022-01-16 | Mercer | New Jersey | 34021 | 67499 | 1121 |
2117435 | 2117435 | 2022-01-15 | Mercer | New Jersey | 34021 | 66737 | 1120 |
2114184 | 2114184 | 2022-01-14 | Mercer | New Jersey | 34021 | 65987 | 1115 |
2110932 | 2110932 | 2022-01-13 | Mercer | New Jersey | 34021 | 65039 | 1113 |
2107681 | 2107681 | 2022-01-12 | Mercer | New Jersey | 34021 | 64033 | 1103 |
2104430 | 2104430 | 2022-01-11 | Mercer | New Jersey | 34021 | 63104 | 1097 |
2101179 | 2101179 | 2022-01-10 | Mercer | New Jersey | 34021 | 62012 | 1090 |
2097928 | 2097928 | 2022-01-09 | Mercer | New Jersey | 34021 | 61101 | 1090 |
2094676 | 2094676 | 2022-01-08 | Mercer | New Jersey | 34021 | 60064 | 1090 |
2091424 | 2091424 | 2022-01-07 | Mercer | New Jersey | 34021 | 58851 | 1086 |
2088173 | 2088173 | 2022-01-06 | Mercer | New Jersey | 34021 | 57431 | 1084 |
2084921 | 2084921 | 2022-01-05 | Mercer | New Jersey | 34021 | 56241 | 1082 |
2081669 | 2081669 | 2022-01-04 | Mercer | New Jersey | 34021 | 54761 | 1079 |
2078417 | 2078417 | 2022-01-03 | Mercer | New Jersey | 34021 | 53771 | 1075 |
2075166 | 2075166 | 2022-01-02 | Mercer | New Jersey | 34021 | 53265 | 1075 |
2071915 | 2071915 | 2022-01-01 | Mercer | New Jersey | 34021 | 52396 | 1074 |
2068664 | 2068664 | 2021-12-31 | Mercer | New Jersey | 34021 | 51226 | 1072 |
2065413 | 2065413 | 2021-12-30 | Mercer | New Jersey | 34021 | 50027 | 1069 |
2062163 | 2062163 | 2021-12-29 | Mercer | New Jersey | 34021 | 48851 | 1067 |
2058914 | 2058914 | 2021-12-28 | Mercer | New Jersey | 34021 | 48073 | 1065 |
2055665 | 2055665 | 2021-12-27 | Mercer | New Jersey | 34021 | 47645 | 1063 |
2052415 | 2052415 | 2021-12-26 | Mercer | New Jersey | 34021 | 47355 | 1064 |
2049165 | 2049165 | 2021-12-25 | Mercer | New Jersey | 34021 | 47018 | 1064 |
2045915 | 2045915 | 2021-12-24 | Mercer | New Jersey | 34021 | 46601 | 1064 |
2042665 | 2042665 | 2021-12-23 | Mercer | New Jersey | 34021 | 46062 | 1063 |
2039416 | 2039416 | 2021-12-22 | Mercer | New Jersey | 34021 | 45565 | 1063 |
2036166 | 2036166 | 2021-12-21 | Mercer | New Jersey | 34021 | 45231 | 1062 |
2032916 | 2032916 | 2021-12-20 | Mercer | New Jersey | 34021 | 45010 | 1060 |
2029665 | 2029665 | 2021-12-19 | Mercer | New Jersey | 34021 | 44798 | 1059 |
2026414 | 2026414 | 2021-12-18 | Mercer | New Jersey | 34021 | 44572 | 1059 |
2023163 | 2023163 | 2021-12-17 | Mercer | New Jersey | 34021 | 44380 | 1054 |
2019912 | 2019912 | 2021-12-16 | Mercer | New Jersey | 34021 | 44148 | 1054 |
2016662 | 2016662 | 2021-12-15 | Mercer | New Jersey | 34021 | 43918 | 1053 |
2013411 | 2013411 | 2021-12-14 | Mercer | New Jersey | 34021 | 43744 | 1049 |
2010160 | 2010160 | 2021-12-13 | Mercer | New Jersey | 34021 | 43619 | 1049 |
2006909 | 2006909 | 2021-12-12 | Mercer | New Jersey | 34021 | 43493 | 1048 |
2003658 | 2003658 | 2021-12-11 | Mercer | New Jersey | 34021 | 43348 | 1048 |
2000408 | 2000408 | 2021-12-10 | Mercer | New Jersey | 34021 | 43178 | 1048 |
1997157 | 1997157 | 2021-12-09 | Mercer | New Jersey | 34021 | 42997 | 1043 |
1993906 | 1993906 | 2021-12-08 | Mercer | New Jersey | 34021 | 42810 | 1043 |
1990655 | 1990655 | 2021-12-07 | Mercer | New Jersey | 34021 | 42640 | 1041 |
1987405 | 1987405 | 2021-12-06 | Mercer | New Jersey | 34021 | 42518 | 1038 |
1984155 | 1984155 | 2021-12-05 | Mercer | New Jersey | 34021 | 42410 | 1037 |
1980905 | 1980905 | 2021-12-04 | Mercer | New Jersey | 34021 | 42309 | 1037 |
1977655 | 1977655 | 2021-12-03 | Mercer | New Jersey | 34021 | 42155 | 1037 |
1974405 | 1974405 | 2021-12-02 | Mercer | New Jersey | 34021 | 41999 | 1034 |
1971156 | 1971156 | 2021-12-01 | Mercer | New Jersey | 34021 | 41834 | 1033 |
1967906 | 1967906 | 2021-11-30 | Mercer | New Jersey | 34021 | 41725 | 1033 |
1964654 | 1964654 | 2021-11-29 | Mercer | New Jersey | 34021 | 41585 | 1031 |
1961403 | 1961403 | 2021-11-28 | Mercer | New Jersey | 34021 | 41502 | 1030 |
1958152 | 1958152 | 2021-11-27 | Mercer | New Jersey | 34021 | 41426 | 1030 |
1954901 | 1954901 | 2021-11-26 | Mercer | New Jersey | 34021 | 41359 | 1029 |
1951650 | 1951650 | 2021-11-25 | Mercer | New Jersey | 34021 | 41270 | 1029 |
1948399 | 1948399 | 2021-11-24 | Mercer | New Jersey | 34021 | 41106 | 1029 |
1945148 | 1945148 | 2021-11-23 | Mercer | New Jersey | 34021 | 41016 | 1027 |
1941897 | 1941897 | 2021-11-22 | Mercer | New Jersey | 34021 | 40921 | 1025 |
1938647 | 1938647 | 2021-11-21 | Mercer | New Jersey | 34021 | 40853 | 1025 |
1935397 | 1935397 | 2021-11-20 | Mercer | New Jersey | 34021 | 40794 | 1024 |
1932147 | 1932147 | 2021-11-19 | Mercer | New Jersey | 34021 | 40724 | 1023 |
1928896 | 1928896 | 2021-11-18 | Mercer | New Jersey | 34021 | 40653 | 1023 |
1925646 | 1925646 | 2021-11-17 | Mercer | New Jersey | 34021 | 40564 | 1023 |
1922397 | 1922397 | 2021-11-16 | Mercer | New Jersey | 34021 | 40505 | 1023 |
1919147 | 1919147 | 2021-11-15 | Mercer | New Jersey | 34021 | 40431 | 1021 |
1915897 | 1915897 | 2021-11-14 | Mercer | New Jersey | 34021 | 40370 | 1021 |
1912647 | 1912647 | 2021-11-13 | Mercer | New Jersey | 34021 | 40303 | 1021 |
1909397 | 1909397 | 2021-11-12 | Mercer | New Jersey | 34021 | 40246 | 1021 |
1906148 | 1906148 | 2021-11-11 | Mercer | New Jersey | 34021 | 40175 | 1021 |
1902899 | 1902899 | 2021-11-10 | Mercer | New Jersey | 34021 | 40124 | 1021 |
1899649 | 1899649 | 2021-11-09 | Mercer | New Jersey | 34021 | 40066 | 1021 |
1896399 | 1896399 | 2021-11-08 | Mercer | New Jersey | 34021 | 40007 | 1019 |
1893149 | 1893149 | 2021-11-07 | Mercer | New Jersey | 34021 | 39978 | 1018 |
1889899 | 1889899 | 2021-11-06 | Mercer | New Jersey | 34021 | 39949 | 1018 |
1886649 | 1886649 | 2021-11-05 | Mercer | New Jersey | 34021 | 39900 | 1017 |
1883400 | 1883400 | 2021-11-04 | Mercer | New Jersey | 34021 | 39838 | 1016 |
1880151 | 1880151 | 2021-11-03 | Mercer | New Jersey | 34021 | 39778 | 1016 |
1876902 | 1876902 | 2021-11-02 | Mercer | New Jersey | 34021 | 39718 | 1015 |
1873653 | 1873653 | 2021-11-01 | Mercer | New Jersey | 34021 | 39658 | 1014 |
1870404 | 1870404 | 2021-10-31 | Mercer | New Jersey | 34021 | 39636 | 1014 |
1867155 | 1867155 | 2021-10-30 | Mercer | New Jersey | 34021 | 39590 | 1014 |
1863906 | 1863906 | 2021-10-29 | Mercer | New Jersey | 34021 | 39556 | 1013 |
1860657 | 1860657 | 2021-10-28 | Mercer | New Jersey | 34021 | 39493 | 1013 |
1857408 | 1857408 | 2021-10-27 | Mercer | New Jersey | 34021 | 39446 | 1013 |
1854159 | 1854159 | 2021-10-26 | Mercer | New Jersey | 34021 | 39397 | 1012 |
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);