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

762 rows where county = "Rock" and fips = 27133 sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

fips 1

  • 27133 · 762 ✖

county 1

  • Rock · 762 ✖
Link rowid date ▲ county state fips cases deaths
2500971 2500971 2022-05-13 Rock Minnesota 27133 2348 34
2497713 2497713 2022-05-12 Rock Minnesota 27133 2346 34
2494455 2494455 2022-05-11 Rock Minnesota 27133 2344 34
2491197 2491197 2022-05-10 Rock Minnesota 27133 2344 34
2487940 2487940 2022-05-09 Rock Minnesota 27133 2343 34
2484682 2484682 2022-05-08 Rock Minnesota 27133 2343 34
2481424 2481424 2022-05-07 Rock Minnesota 27133 2343 34
2478166 2478166 2022-05-06 Rock Minnesota 27133 2343 34
2474908 2474908 2022-05-05 Rock Minnesota 27133 2340 34
2471651 2471651 2022-05-04 Rock Minnesota 27133 2339 34
2468395 2468395 2022-05-03 Rock Minnesota 27133 2339 34
2465140 2465140 2022-05-02 Rock Minnesota 27133 2338 34
2461884 2461884 2022-05-01 Rock Minnesota 27133 2336 34
2458628 2458628 2022-04-30 Rock Minnesota 27133 2336 34
2455372 2455372 2022-04-29 Rock Minnesota 27133 2336 34
2452116 2452116 2022-04-28 Rock Minnesota 27133 2336 34
2448860 2448860 2022-04-27 Rock Minnesota 27133 2333 34
2445604 2445604 2022-04-26 Rock Minnesota 27133 2333 34
2442348 2442348 2022-04-25 Rock Minnesota 27133 2332 34
2439092 2439092 2022-04-24 Rock Minnesota 27133 2332 34
2435836 2435836 2022-04-23 Rock Minnesota 27133 2332 34
2432580 2432580 2022-04-22 Rock Minnesota 27133 2332 34
2429324 2429324 2022-04-21 Rock Minnesota 27133 2332 34
2426068 2426068 2022-04-20 Rock Minnesota 27133 2332 34
2422812 2422812 2022-04-19 Rock Minnesota 27133 2331 34
2419556 2419556 2022-04-18 Rock Minnesota 27133 2331 34
2416300 2416300 2022-04-17 Rock Minnesota 27133 2331 34
2413044 2413044 2022-04-16 Rock Minnesota 27133 2331 34
2409788 2409788 2022-04-15 Rock Minnesota 27133 2331 34
2406532 2406532 2022-04-14 Rock Minnesota 27133 2331 34
2403276 2403276 2022-04-13 Rock Minnesota 27133 2331 34
2400022 2400022 2022-04-12 Rock Minnesota 27133 2330 34
2396766 2396766 2022-04-11 Rock Minnesota 27133 2330 34
2393511 2393511 2022-04-10 Rock Minnesota 27133 2330 34
2390255 2390255 2022-04-09 Rock Minnesota 27133 2330 34
2386999 2386999 2022-04-08 Rock Minnesota 27133 2330 34
2383744 2383744 2022-04-07 Rock Minnesota 27133 2329 34
2380489 2380489 2022-04-06 Rock Minnesota 27133 2328 34
2377234 2377234 2022-04-05 Rock Minnesota 27133 2327 33
2373982 2373982 2022-04-04 Rock Minnesota 27133 2327 33
2370729 2370729 2022-04-03 Rock Minnesota 27133 2327 33
2367476 2367476 2022-04-02 Rock Minnesota 27133 2327 33
2364223 2364223 2022-04-01 Rock Minnesota 27133 2327 33
2360969 2360969 2022-03-31 Rock Minnesota 27133 2327 33
2357715 2357715 2022-03-30 Rock Minnesota 27133 2327 33
2354462 2354462 2022-03-29 Rock Minnesota 27133 2327 33
2351210 2351210 2022-03-28 Rock Minnesota 27133 2325 33
2347957 2347957 2022-03-27 Rock Minnesota 27133 2325 33
2344704 2344704 2022-03-26 Rock Minnesota 27133 2325 33
2341451 2341451 2022-03-25 Rock Minnesota 27133 2325 33
2338198 2338198 2022-03-24 Rock Minnesota 27133 2325 33
2334944 2334944 2022-03-23 Rock Minnesota 27133 2325 33
2331690 2331690 2022-03-22 Rock Minnesota 27133 2325 33
2328438 2328438 2022-03-21 Rock Minnesota 27133 2324 33
2325185 2325185 2022-03-20 Rock Minnesota 27133 2324 33
2321931 2321931 2022-03-19 Rock Minnesota 27133 2324 33
2318677 2318677 2022-03-18 Rock Minnesota 27133 2324 33
2315424 2315424 2022-03-17 Rock Minnesota 27133 2324 33
2312171 2312171 2022-03-16 Rock Minnesota 27133 2323 33
2308918 2308918 2022-03-15 Rock Minnesota 27133 2323 33
2305667 2305667 2022-03-14 Rock Minnesota 27133 2323 33
2302415 2302415 2022-03-13 Rock Minnesota 27133 2323 33
2299163 2299163 2022-03-12 Rock Minnesota 27133 2323 33
2295911 2295911 2022-03-11 Rock Minnesota 27133 2323 33
2292659 2292659 2022-03-10 Rock Minnesota 27133 2315 33
2289407 2289407 2022-03-09 Rock Minnesota 27133 2314 33
2286156 2286156 2022-03-08 Rock Minnesota 27133 2314 33
2282904 2282904 2022-03-07 Rock Minnesota 27133 2314 33
2279651 2279651 2022-03-06 Rock Minnesota 27133 2312 33
2276398 2276398 2022-03-05 Rock Minnesota 27133 2312 33
2273145 2273145 2022-03-04 Rock Minnesota 27133 2312 33
2269893 2269893 2022-03-03 Rock Minnesota 27133 2311 33
2266640 2266640 2022-03-02 Rock Minnesota 27133 2310 33
2263389 2263389 2022-03-01 Rock Minnesota 27133 2307 33
2260138 2260138 2022-02-28 Rock Minnesota 27133 2306 33
2256887 2256887 2022-02-27 Rock Minnesota 27133 2305 33
2253636 2253636 2022-02-26 Rock Minnesota 27133 2305 33
2250385 2250385 2022-02-25 Rock Minnesota 27133 2305 33
2247134 2247134 2022-02-24 Rock Minnesota 27133 2305 33
2243883 2243883 2022-02-23 Rock Minnesota 27133 2304 33
2240632 2240632 2022-02-22 Rock Minnesota 27133 2303 33
2237381 2237381 2022-02-21 Rock Minnesota 27133 2305 33
2234130 2234130 2022-02-20 Rock Minnesota 27133 2305 33
2230879 2230879 2022-02-19 Rock Minnesota 27133 2305 33
2227628 2227628 2022-02-18 Rock Minnesota 27133 2305 33
2224377 2224377 2022-02-17 Rock Minnesota 27133 2298 33
2221126 2221126 2022-02-16 Rock Minnesota 27133 2297 33
2217875 2217875 2022-02-15 Rock Minnesota 27133 2297 33
2214624 2214624 2022-02-14 Rock Minnesota 27133 2296 32
2211372 2211372 2022-02-13 Rock Minnesota 27133 2295 32
2208119 2208119 2022-02-12 Rock Minnesota 27133 2295 32
2204866 2204866 2022-02-11 Rock Minnesota 27133 2295 32
2201613 2201613 2022-02-10 Rock Minnesota 27133 2293 32
2198359 2198359 2022-02-09 Rock Minnesota 27133 2285 32
2195105 2195105 2022-02-08 Rock Minnesota 27133 2282 32
2191851 2191851 2022-02-07 Rock Minnesota 27133 2271 32
2188598 2188598 2022-02-06 Rock Minnesota 27133 2265 32
2185345 2185345 2022-02-05 Rock Minnesota 27133 2265 32
2182093 2182093 2022-02-04 Rock Minnesota 27133 2265 32
2178841 2178841 2022-02-03 Rock Minnesota 27133 2257 32

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