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

783 rows where county = "Brown" and state = "South Dakota" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • South Dakota · 783 ✖

fips 1

county 1

  • Brown · 783 ✖
Link rowid date ▲ county state fips cases deaths
2502050 2502050 2022-05-13 Brown South Dakota 46013 10344 121
2498792 2498792 2022-05-12 Brown South Dakota 46013 10344 121
2495534 2495534 2022-05-11 Brown South Dakota 46013 10344 121
2492276 2492276 2022-05-10 Brown South Dakota 46013 10327 121
2489018 2489018 2022-05-09 Brown South Dakota 46013 10327 121
2485761 2485761 2022-05-08 Brown South Dakota 46013 10327 121
2482503 2482503 2022-05-07 Brown South Dakota 46013 10327 121
2479245 2479245 2022-05-06 Brown South Dakota 46013 10327 121
2475987 2475987 2022-05-05 Brown South Dakota 46013 10327 121
2472730 2472730 2022-05-04 Brown South Dakota 46013 10327 121
2469474 2469474 2022-05-03 Brown South Dakota 46013 10320 121
2466218 2466218 2022-05-02 Brown South Dakota 46013 10320 121
2462963 2462963 2022-05-01 Brown South Dakota 46013 10320 121
2459707 2459707 2022-04-30 Brown South Dakota 46013 10320 121
2456451 2456451 2022-04-29 Brown South Dakota 46013 10320 121
2453195 2453195 2022-04-28 Brown South Dakota 46013 10320 121
2449939 2449939 2022-04-27 Brown South Dakota 46013 10320 121
2446682 2446682 2022-04-26 Brown South Dakota 46013 10303 121
2443427 2443427 2022-04-25 Brown South Dakota 46013 10303 121
2440171 2440171 2022-04-24 Brown South Dakota 46013 10303 121
2436915 2436915 2022-04-23 Brown South Dakota 46013 10303 121
2433659 2433659 2022-04-22 Brown South Dakota 46013 10303 121
2430403 2430403 2022-04-21 Brown South Dakota 46013 10303 121
2427147 2427147 2022-04-20 Brown South Dakota 46013 10303 121
2423891 2423891 2022-04-19 Brown South Dakota 46013 10293 121
2420635 2420635 2022-04-18 Brown South Dakota 46013 10293 121
2417379 2417379 2022-04-17 Brown South Dakota 46013 10293 121
2414123 2414123 2022-04-16 Brown South Dakota 46013 10293 121
2410867 2410867 2022-04-15 Brown South Dakota 46013 10293 121
2407611 2407611 2022-04-14 Brown South Dakota 46013 10293 121
2404355 2404355 2022-04-13 Brown South Dakota 46013 10293 121
2401100 2401100 2022-04-12 Brown South Dakota 46013 10289 121
2397845 2397845 2022-04-11 Brown South Dakota 46013 10289 121
2394590 2394590 2022-04-10 Brown South Dakota 46013 10289 121
2391334 2391334 2022-04-09 Brown South Dakota 46013 10289 121
2388078 2388078 2022-04-08 Brown South Dakota 46013 10289 121
2384823 2384823 2022-04-07 Brown South Dakota 46013 10289 121
2381568 2381568 2022-04-06 Brown South Dakota 46013 10289 121
2378313 2378313 2022-04-05 Brown South Dakota 46013 10277 121
2375059 2375059 2022-04-04 Brown South Dakota 46013 10277 121
2371807 2371807 2022-04-03 Brown South Dakota 46013 10277 121
2368554 2368554 2022-04-02 Brown South Dakota 46013 10277 121
2365301 2365301 2022-04-01 Brown South Dakota 46013 10277 121
2362048 2362048 2022-03-31 Brown South Dakota 46013 10277 121
2358794 2358794 2022-03-30 Brown South Dakota 46013 10277 121
2355540 2355540 2022-03-29 Brown South Dakota 46013 10271 121
2352287 2352287 2022-03-28 Brown South Dakota 46013 10271 121
2349035 2349035 2022-03-27 Brown South Dakota 46013 10271 121
2345782 2345782 2022-03-26 Brown South Dakota 46013 10271 121
2342529 2342529 2022-03-25 Brown South Dakota 46013 10271 121
2339276 2339276 2022-03-24 Brown South Dakota 46013 10271 121
2336022 2336022 2022-03-23 Brown South Dakota 46013 10271 121
2332768 2332768 2022-03-22 Brown South Dakota 46013 10263 121
2329515 2329515 2022-03-21 Brown South Dakota 46013 10263 121
2326263 2326263 2022-03-20 Brown South Dakota 46013 10263 121
2323010 2323010 2022-03-19 Brown South Dakota 46013 10263 121
2319756 2319756 2022-03-18 Brown South Dakota 46013 10263 121
2316502 2316502 2022-03-17 Brown South Dakota 46013 10260 121
2313249 2313249 2022-03-16 Brown South Dakota 46013 10258 121
2309996 2309996 2022-03-15 Brown South Dakota 46013 10256 120
2306743 2306743 2022-03-14 Brown South Dakota 46013 10255 120
2303492 2303492 2022-03-13 Brown South Dakota 46013 10251 120
2300240 2300240 2022-03-12 Brown South Dakota 46013 10251 120
2296988 2296988 2022-03-11 Brown South Dakota 46013 10251 120
2293736 2293736 2022-03-10 Brown South Dakota 46013 10245 120
2290484 2290484 2022-03-09 Brown South Dakota 46013 10240 119
2287232 2287232 2022-03-08 Brown South Dakota 46013 10233 119
2283980 2283980 2022-03-07 Brown South Dakota 46013 10226 117
2280728 2280728 2022-03-06 Brown South Dakota 46013 10218 117
2277475 2277475 2022-03-05 Brown South Dakota 46013 10218 117
2274222 2274222 2022-03-04 Brown South Dakota 46013 10218 117
2270969 2270969 2022-03-03 Brown South Dakota 46013 10215 117
2267717 2267717 2022-03-02 Brown South Dakota 46013 10209 117
2264464 2264464 2022-03-01 Brown South Dakota 46013 10201 116
2261214 2261214 2022-02-28 Brown South Dakota 46013 10192 116
2257963 2257963 2022-02-27 Brown South Dakota 46013 10185 116
2254712 2254712 2022-02-26 Brown South Dakota 46013 10185 116
2251461 2251461 2022-02-25 Brown South Dakota 46013 10185 116
2248210 2248210 2022-02-24 Brown South Dakota 46013 10182 115
2244959 2244959 2022-02-23 Brown South Dakota 46013 10159 115
2241708 2241708 2022-02-22 Brown South Dakota 46013 10132 115
2238457 2238457 2022-02-21 Brown South Dakota 46013 10125 115
2235206 2235206 2022-02-20 Brown South Dakota 46013 10125 115
2231955 2231955 2022-02-19 Brown South Dakota 46013 10125 115
2228704 2228704 2022-02-18 Brown South Dakota 46013 10125 115
2225453 2225453 2022-02-17 Brown South Dakota 46013 10116 115
2222202 2222202 2022-02-16 Brown South Dakota 46013 10095 115
2218951 2218951 2022-02-15 Brown South Dakota 46013 10075 115
2215700 2215700 2022-02-14 Brown South Dakota 46013 10060 115
2212449 2212449 2022-02-13 Brown South Dakota 46013 10049 114
2209196 2209196 2022-02-12 Brown South Dakota 46013 10049 114
2205943 2205943 2022-02-11 Brown South Dakota 46013 10049 114
2202690 2202690 2022-02-10 Brown South Dakota 46013 10032 114
2199436 2199436 2022-02-09 Brown South Dakota 46013 10022 114
2196182 2196182 2022-02-08 Brown South Dakota 46013 9985 114
2192928 2192928 2022-02-07 Brown South Dakota 46013 9958 114
2189674 2189674 2022-02-06 Brown South Dakota 46013 9923 114
2186421 2186421 2022-02-05 Brown South Dakota 46013 9923 114
2183169 2183169 2022-02-04 Brown South Dakota 46013 9923 114
2179917 2179917 2022-02-03 Brown South Dakota 46013 9882 113

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