ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Union" and fips = 37179 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176191 | 2176191 | 2022-02-02 | Union | North Carolina | 37179 | 58141 | 425 |
2172938 | 2172938 | 2022-02-01 | Union | North Carolina | 37179 | 57841 | 425 |
2169685 | 2169685 | 2022-01-31 | Union | North Carolina | 37179 | 57632 | 423 |
2166430 | 2166430 | 2022-01-30 | Union | North Carolina | 37179 | 56693 | 420 |
2163175 | 2163175 | 2022-01-29 | Union | North Carolina | 37179 | 56693 | 420 |
2159920 | 2159920 | 2022-01-28 | Union | North Carolina | 37179 | 56693 | 420 |
2156665 | 2156665 | 2022-01-27 | Union | North Carolina | 37179 | 56271 | 417 |
2153412 | 2153412 | 2022-01-26 | Union | North Carolina | 37179 | 55199 | 416 |
2150160 | 2150160 | 2022-01-25 | Union | North Carolina | 37179 | 54710 | 413 |
2146908 | 2146908 | 2022-01-24 | Union | North Carolina | 37179 | 54370 | 413 |
2143654 | 2143654 | 2022-01-23 | Union | North Carolina | 37179 | 52721 | 412 |
2140399 | 2140399 | 2022-01-22 | Union | North Carolina | 37179 | 52721 | 412 |
2137143 | 2137143 | 2022-01-21 | Union | North Carolina | 37179 | 52721 | 412 |
2133890 | 2133890 | 2022-01-20 | Union | North Carolina | 37179 | 51910 | 412 |
2130638 | 2130638 | 2022-01-19 | Union | North Carolina | 37179 | 51323 | 407 |
2127384 | 2127384 | 2022-01-18 | Union | North Carolina | 37179 | 50769 | 405 |
2124132 | 2124132 | 2022-01-17 | Union | North Carolina | 37179 | 48328 | 403 |
2120880 | 2120880 | 2022-01-16 | Union | North Carolina | 37179 | 48328 | 403 |
2117628 | 2117628 | 2022-01-15 | Union | North Carolina | 37179 | 48328 | 403 |
2114377 | 2114377 | 2022-01-14 | Union | North Carolina | 37179 | 48328 | 403 |
2111125 | 2111125 | 2022-01-13 | Union | North Carolina | 37179 | 47552 | 403 |
2107873 | 2107873 | 2022-01-12 | Union | North Carolina | 37179 | 46880 | 402 |
2104622 | 2104622 | 2022-01-11 | Union | North Carolina | 37179 | 46230 | 401 |
2101371 | 2101371 | 2022-01-10 | Union | North Carolina | 37179 | 45888 | 401 |
2098120 | 2098120 | 2022-01-09 | Union | North Carolina | 37179 | 44422 | 396 |
2094868 | 2094868 | 2022-01-08 | Union | North Carolina | 37179 | 44422 | 396 |
2091616 | 2091616 | 2022-01-07 | Union | North Carolina | 37179 | 44422 | 396 |
2088365 | 2088365 | 2022-01-06 | Union | North Carolina | 37179 | 43897 | 394 |
2085113 | 2085113 | 2022-01-05 | Union | North Carolina | 37179 | 43365 | 390 |
2081861 | 2081861 | 2022-01-04 | Union | North Carolina | 37179 | 42817 | 390 |
2078609 | 2078609 | 2022-01-03 | Union | North Carolina | 37179 | 42568 | 390 |
2075358 | 2075358 | 2022-01-02 | Union | North Carolina | 37179 | 41687 | 390 |
2072107 | 2072107 | 2022-01-01 | Union | North Carolina | 37179 | 41687 | 390 |
2068856 | 2068856 | 2021-12-31 | Union | North Carolina | 37179 | 41687 | 390 |
2065605 | 2065605 | 2021-12-30 | Union | North Carolina | 37179 | 41365 | 388 |
2062355 | 2062355 | 2021-12-29 | Union | North Carolina | 37179 | 40980 | 388 |
2059106 | 2059106 | 2021-12-28 | Union | North Carolina | 37179 | 40779 | 388 |
2055857 | 2055857 | 2021-12-27 | Union | North Carolina | 37179 | 40023 | 383 |
2052607 | 2052607 | 2021-12-26 | Union | North Carolina | 37179 | 40023 | 383 |
2049357 | 2049357 | 2021-12-25 | Union | North Carolina | 37179 | 40023 | 383 |
2046107 | 2046107 | 2021-12-24 | Union | North Carolina | 37179 | 40023 | 383 |
2042857 | 2042857 | 2021-12-23 | Union | North Carolina | 37179 | 40023 | 383 |
2039608 | 2039608 | 2021-12-22 | Union | North Carolina | 37179 | 40023 | 383 |
2036358 | 2036358 | 2021-12-21 | Union | North Carolina | 37179 | 39906 | 383 |
2033108 | 2033108 | 2021-12-20 | Union | North Carolina | 37179 | 39821 | 383 |
2029858 | 2029858 | 2021-12-19 | Union | North Carolina | 37179 | 39586 | 380 |
2026607 | 2026607 | 2021-12-18 | Union | North Carolina | 37179 | 39586 | 380 |
2023356 | 2023356 | 2021-12-17 | Union | North Carolina | 37179 | 39586 | 380 |
2020105 | 2020105 | 2021-12-16 | Union | North Carolina | 37179 | 39478 | 379 |
2016854 | 2016854 | 2021-12-15 | Union | North Carolina | 37179 | 39388 | 378 |
2013604 | 2013604 | 2021-12-14 | Union | North Carolina | 37179 | 39296 | 375 |
2010353 | 2010353 | 2021-12-13 | Union | North Carolina | 37179 | 39230 | 375 |
2007102 | 2007102 | 2021-12-12 | Union | North Carolina | 37179 | 39021 | 374 |
2003851 | 2003851 | 2021-12-11 | Union | North Carolina | 37179 | 39021 | 374 |
2000600 | 2000600 | 2021-12-10 | Union | North Carolina | 37179 | 39021 | 374 |
1997350 | 1997350 | 2021-12-09 | Union | North Carolina | 37179 | 38911 | 374 |
1994099 | 1994099 | 2021-12-08 | Union | North Carolina | 37179 | 38810 | 374 |
1990848 | 1990848 | 2021-12-07 | Union | North Carolina | 37179 | 38720 | 372 |
1987597 | 1987597 | 2021-12-06 | Union | North Carolina | 37179 | 38646 | 372 |
1984347 | 1984347 | 2021-12-05 | Union | North Carolina | 37179 | 38422 | 368 |
1981097 | 1981097 | 2021-12-04 | Union | North Carolina | 37179 | 38422 | 368 |
1977847 | 1977847 | 2021-12-03 | Union | North Carolina | 37179 | 38422 | 368 |
1974597 | 1974597 | 2021-12-02 | Union | North Carolina | 37179 | 38290 | 367 |
1971348 | 1971348 | 2021-12-01 | Union | North Carolina | 37179 | 38177 | 364 |
1968098 | 1968098 | 2021-11-30 | Union | North Carolina | 37179 | 38106 | 363 |
1964847 | 1964847 | 2021-11-29 | Union | North Carolina | 37179 | 38050 | 363 |
1961595 | 1961595 | 2021-11-28 | Union | North Carolina | 37179 | 37764 | 362 |
1958344 | 1958344 | 2021-11-27 | Union | North Carolina | 37179 | 37764 | 362 |
1955093 | 1955093 | 2021-11-26 | Union | North Carolina | 37179 | 37764 | 362 |
1951842 | 1951842 | 2021-11-25 | Union | North Carolina | 37179 | 37764 | 362 |
1948591 | 1948591 | 2021-11-24 | Union | North Carolina | 37179 | 37764 | 362 |
1945340 | 1945340 | 2021-11-23 | Union | North Carolina | 37179 | 37689 | 361 |
1942089 | 1942089 | 2021-11-22 | Union | North Carolina | 37179 | 37664 | 361 |
1938839 | 1938839 | 2021-11-21 | Union | North Carolina | 37179 | 37486 | 357 |
1935589 | 1935589 | 2021-11-20 | Union | North Carolina | 37179 | 37486 | 357 |
1932339 | 1932339 | 2021-11-19 | Union | North Carolina | 37179 | 37486 | 357 |
1929088 | 1929088 | 2021-11-18 | Union | North Carolina | 37179 | 37414 | 357 |
1925838 | 1925838 | 2021-11-17 | Union | North Carolina | 37179 | 37332 | 357 |
1922589 | 1922589 | 2021-11-16 | Union | North Carolina | 37179 | 37228 | 355 |
1919339 | 1919339 | 2021-11-15 | Union | North Carolina | 37179 | 37178 | 355 |
1916089 | 1916089 | 2021-11-14 | Union | North Carolina | 37179 | 37010 | 353 |
1912839 | 1912839 | 2021-11-13 | Union | North Carolina | 37179 | 37010 | 353 |
1909589 | 1909589 | 2021-11-12 | Union | North Carolina | 37179 | 37010 | 353 |
1906340 | 1906340 | 2021-11-11 | Union | North Carolina | 37179 | 36875 | 351 |
1903091 | 1903091 | 2021-11-10 | Union | North Carolina | 37179 | 36875 | 351 |
1899841 | 1899841 | 2021-11-09 | Union | North Carolina | 37179 | 36823 | 349 |
1896591 | 1896591 | 2021-11-08 | Union | North Carolina | 37179 | 36773 | 347 |
1893341 | 1893341 | 2021-11-07 | Union | North Carolina | 37179 | 36665 | 346 |
1890091 | 1890091 | 2021-11-06 | Union | North Carolina | 37179 | 36665 | 346 |
1886841 | 1886841 | 2021-11-05 | Union | North Carolina | 37179 | 36665 | 346 |
1883592 | 1883592 | 2021-11-04 | Union | North Carolina | 37179 | 36615 | 345 |
1880343 | 1880343 | 2021-11-03 | Union | North Carolina | 37179 | 36562 | 344 |
1877094 | 1877094 | 2021-11-02 | Union | North Carolina | 37179 | 36515 | 340 |
1873845 | 1873845 | 2021-11-01 | Union | North Carolina | 37179 | 36483 | 339 |
1870596 | 1870596 | 2021-10-31 | Union | North Carolina | 37179 | 36383 | 338 |
1867347 | 1867347 | 2021-10-30 | Union | North Carolina | 37179 | 36383 | 338 |
1864098 | 1864098 | 2021-10-29 | Union | North Carolina | 37179 | 36383 | 338 |
1860849 | 1860849 | 2021-10-28 | Union | North Carolina | 37179 | 36331 | 335 |
1857600 | 1857600 | 2021-10-27 | Union | North Carolina | 37179 | 36270 | 335 |
1854351 | 1854351 | 2021-10-26 | Union | North Carolina | 37179 | 36220 | 335 |
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);