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 = "Union" and fips = 46127 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 46127 · 778 ✖

county 1

  • Union · 778 ✖
Link rowid date ▲ county state fips cases deaths
2502107 2502107 2022-05-13 Union South Dakota 46127 4026 52
2498849 2498849 2022-05-12 Union South Dakota 46127 4026 52
2495591 2495591 2022-05-11 Union South Dakota 46127 4026 52
2492333 2492333 2022-05-10 Union South Dakota 46127 4012 52
2489075 2489075 2022-05-09 Union South Dakota 46127 4012 52
2485818 2485818 2022-05-08 Union South Dakota 46127 4012 52
2482560 2482560 2022-05-07 Union South Dakota 46127 4012 52
2479302 2479302 2022-05-06 Union South Dakota 46127 4012 52
2476044 2476044 2022-05-05 Union South Dakota 46127 4012 52
2472787 2472787 2022-05-04 Union South Dakota 46127 4012 52
2469531 2469531 2022-05-03 Union South Dakota 46127 4009 52
2466275 2466275 2022-05-02 Union South Dakota 46127 4009 52
2463020 2463020 2022-05-01 Union South Dakota 46127 4009 52
2459764 2459764 2022-04-30 Union South Dakota 46127 4009 52
2456508 2456508 2022-04-29 Union South Dakota 46127 4009 52
2453252 2453252 2022-04-28 Union South Dakota 46127 4009 52
2449996 2449996 2022-04-27 Union South Dakota 46127 4009 52
2446739 2446739 2022-04-26 Union South Dakota 46127 4006 52
2443484 2443484 2022-04-25 Union South Dakota 46127 4006 52
2440228 2440228 2022-04-24 Union South Dakota 46127 4006 52
2436972 2436972 2022-04-23 Union South Dakota 46127 4006 52
2433716 2433716 2022-04-22 Union South Dakota 46127 4006 52
2430460 2430460 2022-04-21 Union South Dakota 46127 4006 52
2427204 2427204 2022-04-20 Union South Dakota 46127 4006 52
2423948 2423948 2022-04-19 Union South Dakota 46127 4005 52
2420692 2420692 2022-04-18 Union South Dakota 46127 4005 52
2417436 2417436 2022-04-17 Union South Dakota 46127 4005 52
2414180 2414180 2022-04-16 Union South Dakota 46127 4005 52
2410924 2410924 2022-04-15 Union South Dakota 46127 4005 52
2407668 2407668 2022-04-14 Union South Dakota 46127 4005 52
2404412 2404412 2022-04-13 Union South Dakota 46127 4005 52
2401157 2401157 2022-04-12 Union South Dakota 46127 4006 52
2397902 2397902 2022-04-11 Union South Dakota 46127 4006 52
2394647 2394647 2022-04-10 Union South Dakota 46127 4006 52
2391391 2391391 2022-04-09 Union South Dakota 46127 4006 52
2388135 2388135 2022-04-08 Union South Dakota 46127 4006 52
2384880 2384880 2022-04-07 Union South Dakota 46127 4006 52
2381625 2381625 2022-04-06 Union South Dakota 46127 4006 52
2378370 2378370 2022-04-05 Union South Dakota 46127 4000 52
2375116 2375116 2022-04-04 Union South Dakota 46127 4000 52
2371864 2371864 2022-04-03 Union South Dakota 46127 4000 52
2368611 2368611 2022-04-02 Union South Dakota 46127 4000 52
2365358 2365358 2022-04-01 Union South Dakota 46127 4000 52
2362105 2362105 2022-03-31 Union South Dakota 46127 4000 52
2358851 2358851 2022-03-30 Union South Dakota 46127 4000 52
2355597 2355597 2022-03-29 Union South Dakota 46127 3998 52
2352344 2352344 2022-03-28 Union South Dakota 46127 3998 52
2349092 2349092 2022-03-27 Union South Dakota 46127 3998 52
2345839 2345839 2022-03-26 Union South Dakota 46127 3998 52
2342586 2342586 2022-03-25 Union South Dakota 46127 3998 52
2339333 2339333 2022-03-24 Union South Dakota 46127 3998 52
2336079 2336079 2022-03-23 Union South Dakota 46127 3998 52
2332825 2332825 2022-03-22 Union South Dakota 46127 3998 52
2329572 2329572 2022-03-21 Union South Dakota 46127 3998 52
2326320 2326320 2022-03-20 Union South Dakota 46127 3998 52
2323067 2323067 2022-03-19 Union South Dakota 46127 3998 52
2319813 2319813 2022-03-18 Union South Dakota 46127 3998 52
2316559 2316559 2022-03-17 Union South Dakota 46127 3998 52
2313306 2313306 2022-03-16 Union South Dakota 46127 3998 52
2310053 2310053 2022-03-15 Union South Dakota 46127 3998 52
2306800 2306800 2022-03-14 Union South Dakota 46127 3998 52
2303549 2303549 2022-03-13 Union South Dakota 46127 3999 52
2300297 2300297 2022-03-12 Union South Dakota 46127 3999 52
2297045 2297045 2022-03-11 Union South Dakota 46127 3999 52
2293793 2293793 2022-03-10 Union South Dakota 46127 3998 52
2290541 2290541 2022-03-09 Union South Dakota 46127 3997 52
2287289 2287289 2022-03-08 Union South Dakota 46127 3998 52
2284037 2284037 2022-03-07 Union South Dakota 46127 3995 51
2280785 2280785 2022-03-06 Union South Dakota 46127 3995 51
2277532 2277532 2022-03-05 Union South Dakota 46127 3995 51
2274279 2274279 2022-03-04 Union South Dakota 46127 3995 51
2271026 2271026 2022-03-03 Union South Dakota 46127 3994 51
2267774 2267774 2022-03-02 Union South Dakota 46127 3992 50
2264521 2264521 2022-03-01 Union South Dakota 46127 3990 49
2261271 2261271 2022-02-28 Union South Dakota 46127 3986 49
2258020 2258020 2022-02-27 Union South Dakota 46127 3982 49
2254769 2254769 2022-02-26 Union South Dakota 46127 3982 49
2251518 2251518 2022-02-25 Union South Dakota 46127 3982 49
2248267 2248267 2022-02-24 Union South Dakota 46127 3983 49
2245016 2245016 2022-02-23 Union South Dakota 46127 3985 49
2241765 2241765 2022-02-22 Union South Dakota 46127 3977 49
2238514 2238514 2022-02-21 Union South Dakota 46127 3976 49
2235263 2235263 2022-02-20 Union South Dakota 46127 3976 49
2232012 2232012 2022-02-19 Union South Dakota 46127 3976 49
2228761 2228761 2022-02-18 Union South Dakota 46127 3976 49
2225510 2225510 2022-02-17 Union South Dakota 46127 3969 49
2222259 2222259 2022-02-16 Union South Dakota 46127 3963 49
2219008 2219008 2022-02-15 Union South Dakota 46127 3960 49
2215757 2215757 2022-02-14 Union South Dakota 46127 3957 49
2212506 2212506 2022-02-13 Union South Dakota 46127 3953 49
2209253 2209253 2022-02-12 Union South Dakota 46127 3953 49
2206000 2206000 2022-02-11 Union South Dakota 46127 3953 49
2202747 2202747 2022-02-10 Union South Dakota 46127 3949 49
2199493 2199493 2022-02-09 Union South Dakota 46127 3944 49
2196239 2196239 2022-02-08 Union South Dakota 46127 3934 49
2192985 2192985 2022-02-07 Union South Dakota 46127 3926 49
2189731 2189731 2022-02-06 Union South Dakota 46127 3911 49
2186478 2186478 2022-02-05 Union South Dakota 46127 3911 49
2183226 2183226 2022-02-04 Union South Dakota 46127 3911 49
2179974 2179974 2022-02-03 Union South Dakota 46127 3907 49

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