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

785 rows where county = "Clay" and fips = 27027 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

  • 27027 · 785 ✖

county 1

  • Clay · 785 ✖
Link rowid date ▲ county state fips cases deaths
2500918 2500918 2022-05-13 Clay Minnesota 27027 20161 124
2497660 2497660 2022-05-12 Clay Minnesota 27027 20138 124
2494402 2494402 2022-05-11 Clay Minnesota 27027 20112 124
2491144 2491144 2022-05-10 Clay Minnesota 27027 20087 124
2487887 2487887 2022-05-09 Clay Minnesota 27027 20066 124
2484629 2484629 2022-05-08 Clay Minnesota 27027 20034 124
2481371 2481371 2022-05-07 Clay Minnesota 27027 20034 124
2478113 2478113 2022-05-06 Clay Minnesota 27027 20034 124
2474855 2474855 2022-05-05 Clay Minnesota 27027 20010 124
2471598 2471598 2022-05-04 Clay Minnesota 27027 19985 124
2468342 2468342 2022-05-03 Clay Minnesota 27027 19968 124
2465087 2465087 2022-05-02 Clay Minnesota 27027 19947 124
2461831 2461831 2022-05-01 Clay Minnesota 27027 19920 124
2458575 2458575 2022-04-30 Clay Minnesota 27027 19920 124
2455319 2455319 2022-04-29 Clay Minnesota 27027 19920 124
2452063 2452063 2022-04-28 Clay Minnesota 27027 19895 124
2448807 2448807 2022-04-27 Clay Minnesota 27027 19876 124
2445551 2445551 2022-04-26 Clay Minnesota 27027 19869 124
2442295 2442295 2022-04-25 Clay Minnesota 27027 19849 124
2439039 2439039 2022-04-24 Clay Minnesota 27027 19843 124
2435783 2435783 2022-04-23 Clay Minnesota 27027 19843 124
2432527 2432527 2022-04-22 Clay Minnesota 27027 19843 124
2429271 2429271 2022-04-21 Clay Minnesota 27027 19833 124
2426015 2426015 2022-04-20 Clay Minnesota 27027 19819 124
2422759 2422759 2022-04-19 Clay Minnesota 27027 19811 124
2419503 2419503 2022-04-18 Clay Minnesota 27027 19801 124
2416247 2416247 2022-04-17 Clay Minnesota 27027 19794 123
2412991 2412991 2022-04-16 Clay Minnesota 27027 19794 123
2409735 2409735 2022-04-15 Clay Minnesota 27027 19794 123
2406479 2406479 2022-04-14 Clay Minnesota 27027 19786 123
2403223 2403223 2022-04-13 Clay Minnesota 27027 19782 123
2399969 2399969 2022-04-12 Clay Minnesota 27027 19776 123
2396713 2396713 2022-04-11 Clay Minnesota 27027 19773 123
2393458 2393458 2022-04-10 Clay Minnesota 27027 19764 123
2390202 2390202 2022-04-09 Clay Minnesota 27027 19764 123
2386946 2386946 2022-04-08 Clay Minnesota 27027 19764 123
2383691 2383691 2022-04-07 Clay Minnesota 27027 19759 123
2380436 2380436 2022-04-06 Clay Minnesota 27027 19752 123
2377181 2377181 2022-04-05 Clay Minnesota 27027 19749 123
2373929 2373929 2022-04-04 Clay Minnesota 27027 19745 123
2370676 2370676 2022-04-03 Clay Minnesota 27027 19743 123
2367423 2367423 2022-04-02 Clay Minnesota 27027 19743 123
2364170 2364170 2022-04-01 Clay Minnesota 27027 19743 123
2360916 2360916 2022-03-31 Clay Minnesota 27027 19739 123
2357662 2357662 2022-03-30 Clay Minnesota 27027 19731 122
2354409 2354409 2022-03-29 Clay Minnesota 27027 19730 122
2351157 2351157 2022-03-28 Clay Minnesota 27027 19725 122
2347904 2347904 2022-03-27 Clay Minnesota 27027 19717 122
2344651 2344651 2022-03-26 Clay Minnesota 27027 19717 122
2341398 2341398 2022-03-25 Clay Minnesota 27027 19717 122
2338145 2338145 2022-03-24 Clay Minnesota 27027 19715 122
2334891 2334891 2022-03-23 Clay Minnesota 27027 19713 122
2331637 2331637 2022-03-22 Clay Minnesota 27027 19706 122
2328385 2328385 2022-03-21 Clay Minnesota 27027 19707 122
2325132 2325132 2022-03-20 Clay Minnesota 27027 19703 122
2321878 2321878 2022-03-19 Clay Minnesota 27027 19703 122
2318624 2318624 2022-03-18 Clay Minnesota 27027 19703 122
2315371 2315371 2022-03-17 Clay Minnesota 27027 19690 122
2312118 2312118 2022-03-16 Clay Minnesota 27027 19681 122
2308865 2308865 2022-03-15 Clay Minnesota 27027 19671 122
2305614 2305614 2022-03-14 Clay Minnesota 27027 19665 121
2302362 2302362 2022-03-13 Clay Minnesota 27027 19659 121
2299110 2299110 2022-03-12 Clay Minnesota 27027 19659 121
2295858 2295858 2022-03-11 Clay Minnesota 27027 19659 121
2292606 2292606 2022-03-10 Clay Minnesota 27027 19555 121
2289354 2289354 2022-03-09 Clay Minnesota 27027 19552 121
2286103 2286103 2022-03-08 Clay Minnesota 27027 19544 121
2282851 2282851 2022-03-07 Clay Minnesota 27027 19527 121
2279598 2279598 2022-03-06 Clay Minnesota 27027 19521 120
2276345 2276345 2022-03-05 Clay Minnesota 27027 19521 120
2273092 2273092 2022-03-04 Clay Minnesota 27027 19521 120
2269840 2269840 2022-03-03 Clay Minnesota 27027 19490 120
2266587 2266587 2022-03-02 Clay Minnesota 27027 19475 120
2263336 2263336 2022-03-01 Clay Minnesota 27027 19487 120
2260085 2260085 2022-02-28 Clay Minnesota 27027 19465 119
2256834 2256834 2022-02-27 Clay Minnesota 27027 19434 119
2253583 2253583 2022-02-26 Clay Minnesota 27027 19434 119
2250332 2250332 2022-02-25 Clay Minnesota 27027 19434 119
2247081 2247081 2022-02-24 Clay Minnesota 27027 19415 119
2243830 2243830 2022-02-23 Clay Minnesota 27027 19387 119
2240579 2240579 2022-02-22 Clay Minnesota 27027 19304 119
2237328 2237328 2022-02-21 Clay Minnesota 27027 19256 118
2234077 2234077 2022-02-20 Clay Minnesota 27027 19256 118
2230826 2230826 2022-02-19 Clay Minnesota 27027 19256 118
2227575 2227575 2022-02-18 Clay Minnesota 27027 19256 118
2224324 2224324 2022-02-17 Clay Minnesota 27027 19044 118
2221073 2221073 2022-02-16 Clay Minnesota 27027 19016 118
2217822 2217822 2022-02-15 Clay Minnesota 27027 18941 118
2214571 2214571 2022-02-14 Clay Minnesota 27027 18792 117
2211319 2211319 2022-02-13 Clay Minnesota 27027 18613 117
2208066 2208066 2022-02-12 Clay Minnesota 27027 18613 117
2204813 2204813 2022-02-11 Clay Minnesota 27027 18613 117
2201560 2201560 2022-02-10 Clay Minnesota 27027 18525 117
2198306 2198306 2022-02-09 Clay Minnesota 27027 18418 117
2195052 2195052 2022-02-08 Clay Minnesota 27027 18291 117
2191798 2191798 2022-02-07 Clay Minnesota 27027 18072 117
2188545 2188545 2022-02-06 Clay Minnesota 27027 17915 117
2185292 2185292 2022-02-05 Clay Minnesota 27027 17915 117
2182040 2182040 2022-02-04 Clay Minnesota 27027 17915 117
2178788 2178788 2022-02-03 Clay Minnesota 27027 17804 117

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