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

793 rows where county = "St. Clair" and state = "Michigan" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Michigan · 793 ✖

fips 1

county 1

  • St. Clair · 793 ✖
Link rowid date ▲ county state fips cases deaths
2500897 2500897 2022-05-13 St. Clair Michigan 26147 41609 835
2497639 2497639 2022-05-12 St. Clair Michigan 26147 41609 835
2494381 2494381 2022-05-11 St. Clair Michigan 26147 41609 835
2491123 2491123 2022-05-10 St. Clair Michigan 26147 41550 834
2487866 2487866 2022-05-09 St. Clair Michigan 26147 41369 833
2484608 2484608 2022-05-08 St. Clair Michigan 26147 41369 833
2481350 2481350 2022-05-07 St. Clair Michigan 26147 41369 833
2478092 2478092 2022-05-06 St. Clair Michigan 26147 41369 833
2474834 2474834 2022-05-05 St. Clair Michigan 26147 41252 833
2471577 2471577 2022-05-04 St. Clair Michigan 26147 41252 833
2468321 2468321 2022-05-03 St. Clair Michigan 26147 41194 834
2465066 2465066 2022-05-02 St. Clair Michigan 26147 41118 834
2461810 2461810 2022-05-01 St. Clair Michigan 26147 41118 834
2458554 2458554 2022-04-30 St. Clair Michigan 26147 41063 834
2455298 2455298 2022-04-29 St. Clair Michigan 26147 41063 834
2452042 2452042 2022-04-28 St. Clair Michigan 26147 41037 834
2448786 2448786 2022-04-27 St. Clair Michigan 26147 40987 834
2445530 2445530 2022-04-26 St. Clair Michigan 26147 40953 834
2442274 2442274 2022-04-25 St. Clair Michigan 26147 40900 832
2439018 2439018 2022-04-24 St. Clair Michigan 26147 40890 832
2435762 2435762 2022-04-23 St. Clair Michigan 26147 40828 832
2432506 2432506 2022-04-22 St. Clair Michigan 26147 40828 832
2429250 2429250 2022-04-21 St. Clair Michigan 26147 40828 832
2425994 2425994 2022-04-20 St. Clair Michigan 26147 40814 832
2422738 2422738 2022-04-19 St. Clair Michigan 26147 40764 832
2419482 2419482 2022-04-18 St. Clair Michigan 26147 40738 831
2416226 2416226 2022-04-17 St. Clair Michigan 26147 40707 831
2412970 2412970 2022-04-16 St. Clair Michigan 26147 40707 831
2409714 2409714 2022-04-15 St. Clair Michigan 26147 40707 831
2406458 2406458 2022-04-14 St. Clair Michigan 26147 40676 831
2403202 2403202 2022-04-13 St. Clair Michigan 26147 40656 831
2399948 2399948 2022-04-12 St. Clair Michigan 26147 40644 828
2396692 2396692 2022-04-11 St. Clair Michigan 26147 40644 828
2393437 2393437 2022-04-10 St. Clair Michigan 26147 40644 828
2390181 2390181 2022-04-09 St. Clair Michigan 26147 40624 828
2386925 2386925 2022-04-08 St. Clair Michigan 26147 40624 828
2383670 2383670 2022-04-07 St. Clair Michigan 26147 40607 828
2380415 2380415 2022-04-06 St. Clair Michigan 26147 40549 828
2377160 2377160 2022-04-05 St. Clair Michigan 26147 40549 825
2373908 2373908 2022-04-04 St. Clair Michigan 26147 40549 825
2370655 2370655 2022-04-03 St. Clair Michigan 26147 40545 825
2367402 2367402 2022-04-02 St. Clair Michigan 26147 40526 825
2364149 2364149 2022-04-01 St. Clair Michigan 26147 40526 825
2360895 2360895 2022-03-31 St. Clair Michigan 26147 40514 825
2357641 2357641 2022-03-30 St. Clair Michigan 26147 40483 824
2354388 2354388 2022-03-29 St. Clair Michigan 26147 40467 824
2351136 2351136 2022-03-28 St. Clair Michigan 26147 40446 824
2347883 2347883 2022-03-27 St. Clair Michigan 26147 40442 824
2344630 2344630 2022-03-26 St. Clair Michigan 26147 40426 824
2341377 2341377 2022-03-25 St. Clair Michigan 26147 40426 824
2338124 2338124 2022-03-24 St. Clair Michigan 26147 40412 823
2334870 2334870 2022-03-23 St. Clair Michigan 26147 40394 823
2331616 2331616 2022-03-22 St. Clair Michigan 26147 40350 820
2328364 2328364 2022-03-21 St. Clair Michigan 26147 40350 820
2325111 2325111 2022-03-20 St. Clair Michigan 26147 40350 820
2321857 2321857 2022-03-19 St. Clair Michigan 26147 40334 820
2318603 2318603 2022-03-18 St. Clair Michigan 26147 40334 820
2315350 2315350 2022-03-17 St. Clair Michigan 26147 40308 819
2312097 2312097 2022-03-16 St. Clair Michigan 26147 40276 819
2308844 2308844 2022-03-15 St. Clair Michigan 26147 40270 817
2305593 2305593 2022-03-14 St. Clair Michigan 26147 40256 816
2302341 2302341 2022-03-13 St. Clair Michigan 26147 40256 816
2299089 2299089 2022-03-12 St. Clair Michigan 26147 40244 814
2295837 2295837 2022-03-11 St. Clair Michigan 26147 40244 814
2292585 2292585 2022-03-10 St. Clair Michigan 26147 40224 814
2289333 2289333 2022-03-09 St. Clair Michigan 26147 40196 811
2286082 2286082 2022-03-08 St. Clair Michigan 26147 40162 807
2282830 2282830 2022-03-07 St. Clair Michigan 26147 40157 807
2279577 2279577 2022-03-06 St. Clair Michigan 26147 40146 807
2276324 2276324 2022-03-05 St. Clair Michigan 26147 40115 807
2273071 2273071 2022-03-04 St. Clair Michigan 26147 40115 807
2269819 2269819 2022-03-03 St. Clair Michigan 26147 40115 807
2266566 2266566 2022-03-02 St. Clair Michigan 26147 40107 808
2263315 2263315 2022-03-01 St. Clair Michigan 26147 40087 803
2260064 2260064 2022-02-28 St. Clair Michigan 26147 40061 801
2256813 2256813 2022-02-27 St. Clair Michigan 26147 40061 801
2253562 2253562 2022-02-26 St. Clair Michigan 26147 40026 801
2250311 2250311 2022-02-25 St. Clair Michigan 26147 40026 801
2247060 2247060 2022-02-24 St. Clair Michigan 26147 40009 801
2243809 2243809 2022-02-23 St. Clair Michigan 26147 39954 795
2240558 2240558 2022-02-22 St. Clair Michigan 26147 39854 794
2237307 2237307 2022-02-21 St. Clair Michigan 26147 39826 793
2234056 2234056 2022-02-20 St. Clair Michigan 26147 39826 793
2230805 2230805 2022-02-19 St. Clair Michigan 26147 39773 788
2227554 2227554 2022-02-18 St. Clair Michigan 26147 39773 788
2224303 2224303 2022-02-17 St. Clair Michigan 26147 39737 788
2221052 2221052 2022-02-16 St. Clair Michigan 26147 39683 783
2217801 2217801 2022-02-15 St. Clair Michigan 26147 39656 782
2214550 2214550 2022-02-14 St. Clair Michigan 26147 39619 778
2211298 2211298 2022-02-13 St. Clair Michigan 26147 39600 778
2208045 2208045 2022-02-12 St. Clair Michigan 26147 39527 778
2204792 2204792 2022-02-11 St. Clair Michigan 26147 39527 778
2201539 2201539 2022-02-10 St. Clair Michigan 26147 39472 773
2198285 2198285 2022-02-09 St. Clair Michigan 26147 39398 771
2195031 2195031 2022-02-08 St. Clair Michigan 26147 39334 767
2191777 2191777 2022-02-07 St. Clair Michigan 26147 39248 765
2188524 2188524 2022-02-06 St. Clair Michigan 26147 39194 765
2185271 2185271 2022-02-05 St. Clair Michigan 26147 39081 765
2182019 2182019 2022-02-04 St. Clair Michigan 26147 39081 765
2178767 2178767 2022-02-03 St. Clair Michigan 26147 38986 759

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