ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 45045 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176637 | 2176637 | 2022-02-02 | Greenville | South Carolina | 45045 | 166045 | 1672 |
2173383 | 2173383 | 2022-02-01 | Greenville | South Carolina | 45045 | 165022 | 1672 |
2170131 | 2170131 | 2022-01-31 | Greenville | South Carolina | 45045 | 164441 | 1666 |
2166877 | 2166877 | 2022-01-30 | Greenville | South Carolina | 45045 | 159827 | 1632 |
2163622 | 2163622 | 2022-01-29 | Greenville | South Carolina | 45045 | 159827 | 1632 |
2160367 | 2160367 | 2022-01-28 | Greenville | South Carolina | 45045 | 159827 | 1632 |
2157111 | 2157111 | 2022-01-27 | Greenville | South Carolina | 45045 | 158094 | 1621 |
2153858 | 2153858 | 2022-01-26 | Greenville | South Carolina | 45045 | 157063 | 1621 |
2150606 | 2150606 | 2022-01-25 | Greenville | South Carolina | 45045 | 149844 | 1621 |
2147354 | 2147354 | 2022-01-24 | Greenville | South Carolina | 45045 | 149844 | 1621 |
2144100 | 2144100 | 2022-01-23 | Greenville | South Carolina | 45045 | 149844 | 1621 |
2140845 | 2140845 | 2022-01-22 | Greenville | South Carolina | 45045 | 149844 | 1621 |
2137589 | 2137589 | 2022-01-21 | Greenville | South Carolina | 45045 | 149844 | 1621 |
2134335 | 2134335 | 2022-01-20 | Greenville | South Carolina | 45045 | 148471 | 1615 |
2131083 | 2131083 | 2022-01-19 | Greenville | South Carolina | 45045 | 147276 | 1613 |
2127829 | 2127829 | 2022-01-18 | Greenville | South Carolina | 45045 | 145770 | 1613 |
2124577 | 2124577 | 2022-01-17 | Greenville | South Carolina | 45045 | 135501 | 1601 |
2121325 | 2121325 | 2022-01-16 | Greenville | South Carolina | 45045 | 135501 | 1601 |
2118073 | 2118073 | 2022-01-15 | Greenville | South Carolina | 45045 | 135501 | 1601 |
2114822 | 2114822 | 2022-01-14 | Greenville | South Carolina | 45045 | 135501 | 1601 |
2111570 | 2111570 | 2022-01-13 | Greenville | South Carolina | 45045 | 132731 | 1591 |
2108318 | 2108318 | 2022-01-12 | Greenville | South Carolina | 45045 | 131064 | 1589 |
2105067 | 2105067 | 2022-01-11 | Greenville | South Carolina | 45045 | 129795 | 1582 |
2101816 | 2101816 | 2022-01-10 | Greenville | South Carolina | 45045 | 128738 | 1582 |
2098565 | 2098565 | 2022-01-09 | Greenville | South Carolina | 45045 | 123333 | 1579 |
2095313 | 2095313 | 2022-01-08 | Greenville | South Carolina | 45045 | 123333 | 1579 |
2092061 | 2092061 | 2022-01-07 | Greenville | South Carolina | 45045 | 123333 | 1579 |
2088809 | 2088809 | 2022-01-06 | Greenville | South Carolina | 45045 | 121769 | 1579 |
2085558 | 2085558 | 2022-01-05 | Greenville | South Carolina | 45045 | 119687 | 1576 |
2082306 | 2082306 | 2022-01-04 | Greenville | South Carolina | 45045 | 118977 | 1571 |
2079054 | 2079054 | 2022-01-03 | Greenville | South Carolina | 45045 | 114621 | 1565 |
2075803 | 2075803 | 2022-01-02 | Greenville | South Carolina | 45045 | 114621 | 1565 |
2072552 | 2072552 | 2022-01-01 | Greenville | South Carolina | 45045 | 114621 | 1565 |
2069301 | 2069301 | 2021-12-31 | Greenville | South Carolina | 45045 | 114621 | 1565 |
2066050 | 2066050 | 2021-12-30 | Greenville | South Carolina | 45045 | 113552 | 1564 |
2062800 | 2062800 | 2021-12-29 | Greenville | South Carolina | 45045 | 112757 | 1564 |
2059550 | 2059550 | 2021-12-28 | Greenville | South Carolina | 45045 | 110808 | 1558 |
2056301 | 2056301 | 2021-12-27 | Greenville | South Carolina | 45045 | 110808 | 1558 |
2053052 | 2053052 | 2021-12-26 | Greenville | South Carolina | 45045 | 110808 | 1558 |
2049802 | 2049802 | 2021-12-25 | Greenville | South Carolina | 45045 | 110808 | 1558 |
2046552 | 2046552 | 2021-12-24 | Greenville | South Carolina | 45045 | 110808 | 1558 |
2043302 | 2043302 | 2021-12-23 | Greenville | South Carolina | 45045 | 110808 | 1558 |
2040053 | 2040053 | 2021-12-22 | Greenville | South Carolina | 45045 | 110588 | 1555 |
2036803 | 2036803 | 2021-12-21 | Greenville | South Carolina | 45045 | 110456 | 1555 |
2033553 | 2033553 | 2021-12-20 | Greenville | South Carolina | 45045 | 110336 | 1553 |
2030303 | 2030303 | 2021-12-19 | Greenville | South Carolina | 45045 | 109877 | 1547 |
2027052 | 2027052 | 2021-12-18 | Greenville | South Carolina | 45045 | 109877 | 1547 |
2023801 | 2023801 | 2021-12-17 | Greenville | South Carolina | 45045 | 109877 | 1547 |
2020550 | 2020550 | 2021-12-16 | Greenville | South Carolina | 45045 | 109710 | 1546 |
2017299 | 2017299 | 2021-12-15 | Greenville | South Carolina | 45045 | 109573 | 1543 |
2014049 | 2014049 | 2021-12-14 | Greenville | South Carolina | 45045 | 109462 | 1543 |
2010798 | 2010798 | 2021-12-13 | Greenville | South Carolina | 45045 | 109359 | 1542 |
2007547 | 2007547 | 2021-12-12 | Greenville | South Carolina | 45045 | 109023 | 1535 |
2004296 | 2004296 | 2021-12-11 | Greenville | South Carolina | 45045 | 109023 | 1535 |
2001045 | 2001045 | 2021-12-10 | Greenville | South Carolina | 45045 | 109023 | 1535 |
1997795 | 1997795 | 2021-12-09 | Greenville | South Carolina | 45045 | 108855 | 1530 |
1994544 | 1994544 | 2021-12-08 | Greenville | South Carolina | 45045 | 108705 | 1530 |
1991293 | 1991293 | 2021-12-07 | Greenville | South Carolina | 45045 | 108588 | 1529 |
1988042 | 1988042 | 2021-12-06 | Greenville | South Carolina | 45045 | 108497 | 1529 |
1984792 | 1984792 | 2021-12-05 | Greenville | South Carolina | 45045 | 108113 | 1524 |
1981542 | 1981542 | 2021-12-04 | Greenville | South Carolina | 45045 | 108113 | 1524 |
1978292 | 1978292 | 2021-12-03 | Greenville | South Carolina | 45045 | 108113 | 1524 |
1975042 | 1975042 | 2021-12-02 | Greenville | South Carolina | 45045 | 107942 | 1524 |
1971793 | 1971793 | 2021-12-01 | Greenville | South Carolina | 45045 | 107810 | 1518 |
1968543 | 1968543 | 2021-11-30 | Greenville | South Carolina | 45045 | 107730 | 1517 |
1965292 | 1965292 | 2021-11-29 | Greenville | South Carolina | 45045 | 107669 | 1517 |
1962040 | 1962040 | 2021-11-28 | Greenville | South Carolina | 45045 | 107386 | 1514 |
1958789 | 1958789 | 2021-11-27 | Greenville | South Carolina | 45045 | 107386 | 1514 |
1955538 | 1955538 | 2021-11-26 | Greenville | South Carolina | 45045 | 107386 | 1514 |
1952287 | 1952287 | 2021-11-25 | Greenville | South Carolina | 45045 | 107296 | 1510 |
1949036 | 1949036 | 2021-11-24 | Greenville | South Carolina | 45045 | 107296 | 1510 |
1945785 | 1945785 | 2021-11-23 | Greenville | South Carolina | 45045 | 107241 | 1510 |
1942534 | 1942534 | 2021-11-22 | Greenville | South Carolina | 45045 | 107169 | 1509 |
1939284 | 1939284 | 2021-11-21 | Greenville | South Carolina | 45045 | 106890 | 1501 |
1936034 | 1936034 | 2021-11-20 | Greenville | South Carolina | 45045 | 106890 | 1501 |
1932784 | 1932784 | 2021-11-19 | Greenville | South Carolina | 45045 | 106890 | 1501 |
1929533 | 1929533 | 2021-11-18 | Greenville | South Carolina | 45045 | 106768 | 1497 |
1926283 | 1926283 | 2021-11-17 | Greenville | South Carolina | 45045 | 106670 | 1489 |
1923033 | 1923033 | 2021-11-16 | Greenville | South Carolina | 45045 | 106619 | 1488 |
1919784 | 1919784 | 2021-11-15 | Greenville | South Carolina | 45045 | 106556 | 1487 |
1916534 | 1916534 | 2021-11-14 | Greenville | South Carolina | 45045 | 106302 | 1474 |
1913284 | 1913284 | 2021-11-13 | Greenville | South Carolina | 45045 | 106302 | 1474 |
1910034 | 1910034 | 2021-11-12 | Greenville | South Carolina | 45045 | 106302 | 1474 |
1906785 | 1906785 | 2021-11-11 | Greenville | South Carolina | 45045 | 106066 | 1466 |
1903536 | 1903536 | 2021-11-10 | Greenville | South Carolina | 45045 | 106066 | 1466 |
1900286 | 1900286 | 2021-11-09 | Greenville | South Carolina | 45045 | 105996 | 1464 |
1897036 | 1897036 | 2021-11-08 | Greenville | South Carolina | 45045 | 105922 | 1464 |
1893786 | 1893786 | 2021-11-07 | Greenville | South Carolina | 45045 | 105684 | 1456 |
1890536 | 1890536 | 2021-11-06 | Greenville | South Carolina | 45045 | 105684 | 1456 |
1887286 | 1887286 | 2021-11-05 | Greenville | South Carolina | 45045 | 105684 | 1456 |
1884036 | 1884036 | 2021-11-04 | Greenville | South Carolina | 45045 | 105562 | 1456 |
1880787 | 1880787 | 2021-11-03 | Greenville | South Carolina | 45045 | 105461 | 1451 |
1877538 | 1877538 | 2021-11-02 | Greenville | South Carolina | 45045 | 105394 | 1446 |
1874289 | 1874289 | 2021-11-01 | Greenville | South Carolina | 45045 | 105335 | 1445 |
1871040 | 1871040 | 2021-10-31 | Greenville | South Carolina | 45045 | 105019 | 1441 |
1867791 | 1867791 | 2021-10-30 | Greenville | South Carolina | 45045 | 105019 | 1441 |
1864542 | 1864542 | 2021-10-29 | Greenville | South Carolina | 45045 | 105019 | 1441 |
1861293 | 1861293 | 2021-10-28 | Greenville | South Carolina | 45045 | 104862 | 1432 |
1858044 | 1858044 | 2021-10-27 | Greenville | South Carolina | 45045 | 104746 | 1420 |
1854795 | 1854795 | 2021-10-26 | Greenville | South Carolina | 45045 | 104667 | 1419 |
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);