ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 37027 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2111049 | 2111049 | 2022-01-13 | Caldwell | North Carolina | 37027 | 16740 | 232 |
2107797 | 2107797 | 2022-01-12 | Caldwell | North Carolina | 37027 | 16524 | 232 |
2104546 | 2104546 | 2022-01-11 | Caldwell | North Carolina | 37027 | 16357 | 233 |
2101295 | 2101295 | 2022-01-10 | Caldwell | North Carolina | 37027 | 16202 | 233 |
2098044 | 2098044 | 2022-01-09 | Caldwell | North Carolina | 37027 | 15776 | 233 |
2094792 | 2094792 | 2022-01-08 | Caldwell | North Carolina | 37027 | 15776 | 233 |
2091540 | 2091540 | 2022-01-07 | Caldwell | North Carolina | 37027 | 15776 | 233 |
2088289 | 2088289 | 2022-01-06 | Caldwell | North Carolina | 37027 | 15647 | 233 |
2085037 | 2085037 | 2022-01-05 | Caldwell | North Carolina | 37027 | 15454 | 233 |
2081785 | 2081785 | 2022-01-04 | Caldwell | North Carolina | 37027 | 15300 | 232 |
2078533 | 2078533 | 2022-01-03 | Caldwell | North Carolina | 37027 | 15250 | 232 |
2075282 | 2075282 | 2022-01-02 | Caldwell | North Carolina | 37027 | 15010 | 231 |
2072031 | 2072031 | 2022-01-01 | Caldwell | North Carolina | 37027 | 15010 | 231 |
2068780 | 2068780 | 2021-12-31 | Caldwell | North Carolina | 37027 | 15010 | 231 |
2065529 | 2065529 | 2021-12-30 | Caldwell | North Carolina | 37027 | 14896 | 231 |
2062279 | 2062279 | 2021-12-29 | Caldwell | North Carolina | 37027 | 14785 | 231 |
2059030 | 2059030 | 2021-12-28 | Caldwell | North Carolina | 37027 | 14717 | 231 |
2055781 | 2055781 | 2021-12-27 | Caldwell | North Carolina | 37027 | 14514 | 231 |
2052531 | 2052531 | 2021-12-26 | Caldwell | North Carolina | 37027 | 14514 | 231 |
2049281 | 2049281 | 2021-12-25 | Caldwell | North Carolina | 37027 | 14514 | 231 |
2046031 | 2046031 | 2021-12-24 | Caldwell | North Carolina | 37027 | 14514 | 231 |
2042781 | 2042781 | 2021-12-23 | Caldwell | North Carolina | 37027 | 14514 | 231 |
2039532 | 2039532 | 2021-12-22 | Caldwell | North Carolina | 37027 | 14514 | 231 |
2036282 | 2036282 | 2021-12-21 | Caldwell | North Carolina | 37027 | 14457 | 231 |
2033032 | 2033032 | 2021-12-20 | Caldwell | North Carolina | 37027 | 14423 | 231 |
2029782 | 2029782 | 2021-12-19 | Caldwell | North Carolina | 37027 | 14335 | 230 |
2026531 | 2026531 | 2021-12-18 | Caldwell | North Carolina | 37027 | 14335 | 230 |
2023280 | 2023280 | 2021-12-17 | Caldwell | North Carolina | 37027 | 14335 | 230 |
2020029 | 2020029 | 2021-12-16 | Caldwell | North Carolina | 37027 | 14301 | 230 |
2016778 | 2016778 | 2021-12-15 | Caldwell | North Carolina | 37027 | 14247 | 230 |
2013528 | 2013528 | 2021-12-14 | Caldwell | North Carolina | 37027 | 14218 | 230 |
2010277 | 2010277 | 2021-12-13 | Caldwell | North Carolina | 37027 | 14201 | 230 |
2007026 | 2007026 | 2021-12-12 | Caldwell | North Carolina | 37027 | 14141 | 230 |
2003775 | 2003775 | 2021-12-11 | Caldwell | North Carolina | 37027 | 14141 | 230 |
2000524 | 2000524 | 2021-12-10 | Caldwell | North Carolina | 37027 | 14141 | 230 |
1997274 | 1997274 | 2021-12-09 | Caldwell | North Carolina | 37027 | 14100 | 230 |
1994023 | 1994023 | 2021-12-08 | Caldwell | North Carolina | 37027 | 14076 | 230 |
1990772 | 1990772 | 2021-12-07 | Caldwell | North Carolina | 37027 | 14055 | 230 |
1987521 | 1987521 | 2021-12-06 | Caldwell | North Carolina | 37027 | 14041 | 230 |
1984271 | 1984271 | 2021-12-05 | Caldwell | North Carolina | 37027 | 13994 | 228 |
1981021 | 1981021 | 2021-12-04 | Caldwell | North Carolina | 37027 | 13994 | 228 |
1977771 | 1977771 | 2021-12-03 | Caldwell | North Carolina | 37027 | 13994 | 228 |
1974521 | 1974521 | 2021-12-02 | Caldwell | North Carolina | 37027 | 13972 | 228 |
1971272 | 1971272 | 2021-12-01 | Caldwell | North Carolina | 37027 | 13959 | 228 |
1968022 | 1968022 | 2021-11-30 | Caldwell | North Carolina | 37027 | 13949 | 227 |
1964771 | 1964771 | 2021-11-29 | Caldwell | North Carolina | 37027 | 13947 | 225 |
1961519 | 1961519 | 2021-11-28 | Caldwell | North Carolina | 37027 | 13905 | 224 |
1958268 | 1958268 | 2021-11-27 | Caldwell | North Carolina | 37027 | 13905 | 224 |
1955017 | 1955017 | 2021-11-26 | Caldwell | North Carolina | 37027 | 13905 | 224 |
1951766 | 1951766 | 2021-11-25 | Caldwell | North Carolina | 37027 | 13905 | 224 |
1948515 | 1948515 | 2021-11-24 | Caldwell | North Carolina | 37027 | 13905 | 224 |
1945264 | 1945264 | 2021-11-23 | Caldwell | North Carolina | 37027 | 13895 | 224 |
1942013 | 1942013 | 2021-11-22 | Caldwell | North Carolina | 37027 | 13879 | 223 |
1938763 | 1938763 | 2021-11-21 | Caldwell | North Carolina | 37027 | 13840 | 223 |
1935513 | 1935513 | 2021-11-20 | Caldwell | North Carolina | 37027 | 13840 | 223 |
1932263 | 1932263 | 2021-11-19 | Caldwell | North Carolina | 37027 | 13840 | 223 |
1929012 | 1929012 | 2021-11-18 | Caldwell | North Carolina | 37027 | 13804 | 223 |
1925762 | 1925762 | 2021-11-17 | Caldwell | North Carolina | 37027 | 13782 | 217 |
1922513 | 1922513 | 2021-11-16 | Caldwell | North Carolina | 37027 | 13764 | 217 |
1919263 | 1919263 | 2021-11-15 | Caldwell | North Carolina | 37027 | 13739 | 217 |
1916013 | 1916013 | 2021-11-14 | Caldwell | North Carolina | 37027 | 13711 | 217 |
1912763 | 1912763 | 2021-11-13 | Caldwell | North Carolina | 37027 | 13711 | 217 |
1909513 | 1909513 | 2021-11-12 | Caldwell | North Carolina | 37027 | 13711 | 217 |
1906264 | 1906264 | 2021-11-11 | Caldwell | North Carolina | 37027 | 13672 | 217 |
1903015 | 1903015 | 2021-11-10 | Caldwell | North Carolina | 37027 | 13672 | 217 |
1899765 | 1899765 | 2021-11-09 | Caldwell | North Carolina | 37027 | 13657 | 216 |
1896515 | 1896515 | 2021-11-08 | Caldwell | North Carolina | 37027 | 13651 | 216 |
1893265 | 1893265 | 2021-11-07 | Caldwell | North Carolina | 37027 | 13607 | 216 |
1890015 | 1890015 | 2021-11-06 | Caldwell | North Carolina | 37027 | 13607 | 216 |
1886765 | 1886765 | 2021-11-05 | Caldwell | North Carolina | 37027 | 13607 | 216 |
1883516 | 1883516 | 2021-11-04 | Caldwell | North Carolina | 37027 | 13600 | 215 |
1880267 | 1880267 | 2021-11-03 | Caldwell | North Carolina | 37027 | 13577 | 215 |
1877018 | 1877018 | 2021-11-02 | Caldwell | North Carolina | 37027 | 13541 | 215 |
1873769 | 1873769 | 2021-11-01 | Caldwell | North Carolina | 37027 | 13520 | 215 |
1870520 | 1870520 | 2021-10-31 | Caldwell | North Carolina | 37027 | 13418 | 214 |
1867271 | 1867271 | 2021-10-30 | Caldwell | North Carolina | 37027 | 13418 | 214 |
1864022 | 1864022 | 2021-10-29 | Caldwell | North Carolina | 37027 | 13418 | 214 |
1860773 | 1860773 | 2021-10-28 | Caldwell | North Carolina | 37027 | 13341 | 214 |
1857524 | 1857524 | 2021-10-27 | Caldwell | North Carolina | 37027 | 13308 | 213 |
1854275 | 1854275 | 2021-10-26 | Caldwell | North Carolina | 37027 | 13270 | 213 |
1851026 | 1851026 | 2021-10-25 | Caldwell | North Carolina | 37027 | 13246 | 213 |
1847776 | 1847776 | 2021-10-24 | Caldwell | North Carolina | 37027 | 13156 | 213 |
1844526 | 1844526 | 2021-10-23 | Caldwell | North Carolina | 37027 | 13156 | 213 |
1841276 | 1841276 | 2021-10-22 | Caldwell | North Carolina | 37027 | 13156 | 213 |
1838027 | 1838027 | 2021-10-21 | Caldwell | North Carolina | 37027 | 13144 | 213 |
1834778 | 1834778 | 2021-10-20 | Caldwell | North Carolina | 37027 | 13121 | 212 |
1831529 | 1831529 | 2021-10-19 | Caldwell | North Carolina | 37027 | 13099 | 209 |
1828280 | 1828280 | 2021-10-18 | Caldwell | North Carolina | 37027 | 13084 | 209 |
1825031 | 1825031 | 2021-10-17 | Caldwell | North Carolina | 37027 | 13023 | 204 |
1821782 | 1821782 | 2021-10-16 | Caldwell | North Carolina | 37027 | 13023 | 204 |
1818533 | 1818533 | 2021-10-15 | Caldwell | North Carolina | 37027 | 13023 | 204 |
1815284 | 1815284 | 2021-10-14 | Caldwell | North Carolina | 37027 | 13004 | 204 |
1812036 | 1812036 | 2021-10-13 | Caldwell | North Carolina | 37027 | 12976 | 200 |
1808787 | 1808787 | 2021-10-12 | Caldwell | North Carolina | 37027 | 12951 | 199 |
1805536 | 1805536 | 2021-10-11 | Caldwell | North Carolina | 37027 | 12923 | 198 |
1802287 | 1802287 | 2021-10-10 | Caldwell | North Carolina | 37027 | 12849 | 198 |
1799038 | 1799038 | 2021-10-09 | Caldwell | North Carolina | 37027 | 12849 | 198 |
1795789 | 1795789 | 2021-10-08 | Caldwell | North Carolina | 37027 | 12849 | 198 |
1792540 | 1792540 | 2021-10-07 | Caldwell | North Carolina | 37027 | 12808 | 197 |
1789291 | 1789291 | 2021-10-06 | Caldwell | North Carolina | 37027 | 12776 | 193 |
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);