ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

778 rows where county = "Greene" and state = "Alabama" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

state 1

  • Alabama · 778 ✖

fips 1

county 1

  • Greene · 778 ✖
Link rowid date ▲ county state fips cases deaths
2499606 2499606 2022-05-13 Greene Alabama 1063 1877 49
2496348 2496348 2022-05-12 Greene Alabama 1063 1876 49
2493090 2493090 2022-05-11 Greene Alabama 1063 1876 49
2489832 2489832 2022-05-10 Greene Alabama 1063 1875 49
2486575 2486575 2022-05-09 Greene Alabama 1063 1875 49
2483317 2483317 2022-05-08 Greene Alabama 1063 1875 49
2480059 2480059 2022-05-07 Greene Alabama 1063 1875 49
2476801 2476801 2022-05-06 Greene Alabama 1063 1875 49
2473543 2473543 2022-05-05 Greene Alabama 1063 1875 49
2470286 2470286 2022-05-04 Greene Alabama 1063 1875 49
2467030 2467030 2022-05-03 Greene Alabama 1063 1875 49
2463775 2463775 2022-05-02 Greene Alabama 1063 1875 48
2460519 2460519 2022-05-01 Greene Alabama 1063 1875 48
2457263 2457263 2022-04-30 Greene Alabama 1063 1875 48
2454007 2454007 2022-04-29 Greene Alabama 1063 1875 48
2450751 2450751 2022-04-28 Greene Alabama 1063 1875 48
2447495 2447495 2022-04-27 Greene Alabama 1063 1875 48
2444239 2444239 2022-04-26 Greene Alabama 1063 1875 48
2440983 2440983 2022-04-25 Greene Alabama 1063 1874 48
2437727 2437727 2022-04-24 Greene Alabama 1063 1873 48
2434471 2434471 2022-04-23 Greene Alabama 1063 1873 48
2431215 2431215 2022-04-22 Greene Alabama 1063 1873 48
2427959 2427959 2022-04-21 Greene Alabama 1063 1871 48
2424703 2424703 2022-04-20 Greene Alabama 1063 1871 48
2421447 2421447 2022-04-19 Greene Alabama 1063 1871 48
2418191 2418191 2022-04-18 Greene Alabama 1063 1871 48
2414935 2414935 2022-04-17 Greene Alabama 1063 1871 48
2411679 2411679 2022-04-16 Greene Alabama 1063 1871 48
2408423 2408423 2022-04-15 Greene Alabama 1063 1871 48
2405167 2405167 2022-04-14 Greene Alabama 1063 1871 48
2401912 2401912 2022-04-13 Greene Alabama 1063 1871 48
2398657 2398657 2022-04-12 Greene Alabama 1063 1870 48
2395402 2395402 2022-04-11 Greene Alabama 1063 1869 48
2392146 2392146 2022-04-10 Greene Alabama 1063 1869 48
2388890 2388890 2022-04-09 Greene Alabama 1063 1869 48
2385635 2385635 2022-04-08 Greene Alabama 1063 1869 48
2382380 2382380 2022-04-07 Greene Alabama 1063 1868 48
2379125 2379125 2022-04-06 Greene Alabama 1063 1868 48
2375871 2375871 2022-04-05 Greene Alabama 1063 1868 48
2372619 2372619 2022-04-04 Greene Alabama 1063 1868 48
2369366 2369366 2022-04-03 Greene Alabama 1063 1868 48
2366113 2366113 2022-04-02 Greene Alabama 1063 1868 48
2362860 2362860 2022-04-01 Greene Alabama 1063 1868 48
2359606 2359606 2022-03-31 Greene Alabama 1063 1868 48
2356352 2356352 2022-03-30 Greene Alabama 1063 1868 48
2353099 2353099 2022-03-29 Greene Alabama 1063 1868 48
2349847 2349847 2022-03-28 Greene Alabama 1063 1866 48
2346594 2346594 2022-03-27 Greene Alabama 1063 1866 48
2343341 2343341 2022-03-26 Greene Alabama 1063 1866 48
2340088 2340088 2022-03-25 Greene Alabama 1063 1866 48
2336835 2336835 2022-03-24 Greene Alabama 1063 1865 48
2333581 2333581 2022-03-23 Greene Alabama 1063 1864 48
2330327 2330327 2022-03-22 Greene Alabama 1063 1863 48
2327075 2327075 2022-03-21 Greene Alabama 1063 1863 48
2323822 2323822 2022-03-20 Greene Alabama 1063 1863 48
2320568 2320568 2022-03-19 Greene Alabama 1063 1863 48
2317314 2317314 2022-03-18 Greene Alabama 1063 1863 48
2314061 2314061 2022-03-17 Greene Alabama 1063 1862 48
2310808 2310808 2022-03-16 Greene Alabama 1063 1862 48
2307555 2307555 2022-03-15 Greene Alabama 1063 1860 48
2304304 2304304 2022-03-14 Greene Alabama 1063 1860 48
2301052 2301052 2022-03-13 Greene Alabama 1063 1859 48
2297800 2297800 2022-03-12 Greene Alabama 1063 1859 48
2294548 2294548 2022-03-11 Greene Alabama 1063 1859 48
2291296 2291296 2022-03-10 Greene Alabama 1063 1859 48
2288044 2288044 2022-03-09 Greene Alabama 1063 1858 48
2284792 2284792 2022-03-08 Greene Alabama 1063 1856 48
2281540 2281540 2022-03-07 Greene Alabama 1063 1856 48
2278287 2278287 2022-03-06 Greene Alabama 1063 1856 48
2275034 2275034 2022-03-05 Greene Alabama 1063 1856 48
2271781 2271781 2022-03-04 Greene Alabama 1063 1856 48
2268529 2268529 2022-03-03 Greene Alabama 1063 1855 48
2265276 2265276 2022-03-02 Greene Alabama 1063 1854 48
2262026 2262026 2022-03-01 Greene Alabama 1063 1853 48
2258775 2258775 2022-02-28 Greene Alabama 1063 1852 48
2255524 2255524 2022-02-27 Greene Alabama 1063 1852 48
2252273 2252273 2022-02-26 Greene Alabama 1063 1852 48
2249022 2249022 2022-02-25 Greene Alabama 1063 1848 48
2245771 2245771 2022-02-24 Greene Alabama 1063 1848 48
2242520 2242520 2022-02-23 Greene Alabama 1063 1848 48
2239269 2239269 2022-02-22 Greene Alabama 1063 1848 48
2236018 2236018 2022-02-21 Greene Alabama 1063 1848 48
2232767 2232767 2022-02-20 Greene Alabama 1063 1847 48
2229516 2229516 2022-02-19 Greene Alabama 1063 1845 48
2226265 2226265 2022-02-18 Greene Alabama 1063 1844 48
2223014 2223014 2022-02-17 Greene Alabama 1063 1844 48
2219763 2219763 2022-02-16 Greene Alabama 1063 1825 48
2216513 2216513 2022-02-15 Greene Alabama 1063 1802 48
2213262 2213262 2022-02-14 Greene Alabama 1063 1787 48
2210009 2210009 2022-02-13 Greene Alabama 1063 1787 48
2206756 2206756 2022-02-12 Greene Alabama 1063 1786 48
2203503 2203503 2022-02-11 Greene Alabama 1063 1777 48
2200249 2200249 2022-02-10 Greene Alabama 1063 1774 48
2196995 2196995 2022-02-09 Greene Alabama 1063 1772 48
2193740 2193740 2022-02-08 Greene Alabama 1063 1770 47
2190487 2190487 2022-02-07 Greene Alabama 1063 1769 47
2187234 2187234 2022-02-06 Greene Alabama 1063 1763 47
2183981 2183981 2022-02-05 Greene Alabama 1063 1763 47
2180729 2180729 2022-02-04 Greene Alabama 1063 1760 47
2177478 2177478 2022-02-03 Greene Alabama 1063 1756 47

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);