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

765 rows where county = "St. Clair" and state = "Missouri" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

  • Missouri · 765 ✖

fips 1

county 1

  • St. Clair · 765 ✖
Link rowid date ▲ county state fips cases deaths
2501176 2501176 2022-05-13 St. Clair Missouri 29185 2102 36
2497918 2497918 2022-05-12 St. Clair Missouri 29185 2101 36
2494660 2494660 2022-05-11 St. Clair Missouri 29185 2101 36
2491402 2491402 2022-05-10 St. Clair Missouri 29185 2101 36
2488144 2488144 2022-05-09 St. Clair Missouri 29185 2101 36
2484887 2484887 2022-05-08 St. Clair Missouri 29185 2101 36
2481629 2481629 2022-05-07 St. Clair Missouri 29185 2101 36
2478371 2478371 2022-05-06 St. Clair Missouri 29185 2101 36
2475113 2475113 2022-05-05 St. Clair Missouri 29185 2102 35
2471856 2471856 2022-05-04 St. Clair Missouri 29185 2102 34
2468600 2468600 2022-05-03 St. Clair Missouri 29185 2102 34
2465344 2465344 2022-05-02 St. Clair Missouri 29185 2102 34
2462089 2462089 2022-05-01 St. Clair Missouri 29185 2102 34
2458833 2458833 2022-04-30 St. Clair Missouri 29185 2102 34
2455577 2455577 2022-04-29 St. Clair Missouri 29185 2102 34
2452321 2452321 2022-04-28 St. Clair Missouri 29185 2102 34
2449065 2449065 2022-04-27 St. Clair Missouri 29185 2102 34
2445808 2445808 2022-04-26 St. Clair Missouri 29185 2102 34
2442553 2442553 2022-04-25 St. Clair Missouri 29185 2102 34
2439297 2439297 2022-04-24 St. Clair Missouri 29185 2102 34
2436041 2436041 2022-04-23 St. Clair Missouri 29185 2102 34
2432785 2432785 2022-04-22 St. Clair Missouri 29185 2102 34
2429529 2429529 2022-04-21 St. Clair Missouri 29185 2102 34
2426273 2426273 2022-04-20 St. Clair Missouri 29185 2102 34
2423017 2423017 2022-04-19 St. Clair Missouri 29185 2102 34
2419760 2419760 2022-04-18 St. Clair Missouri 29185 2102 34
2416505 2416505 2022-04-17 St. Clair Missouri 29185 2102 34
2413249 2413249 2022-04-16 St. Clair Missouri 29185 2102 34
2409993 2409993 2022-04-15 St. Clair Missouri 29185 2102 34
2406737 2406737 2022-04-14 St. Clair Missouri 29185 2102 34
2403481 2403481 2022-04-13 St. Clair Missouri 29185 2102 34
2400226 2400226 2022-04-12 St. Clair Missouri 29185 2102 34
2396971 2396971 2022-04-11 St. Clair Missouri 29185 2102 34
2393716 2393716 2022-04-10 St. Clair Missouri 29185 2102 34
2390460 2390460 2022-04-09 St. Clair Missouri 29185 2102 34
2387204 2387204 2022-04-08 St. Clair Missouri 29185 2102 34
2383949 2383949 2022-04-07 St. Clair Missouri 29185 2102 34
2380694 2380694 2022-04-06 St. Clair Missouri 29185 2102 34
2377439 2377439 2022-04-05 St. Clair Missouri 29185 2102 34
2374186 2374186 2022-04-04 St. Clair Missouri 29185 2102 34
2370934 2370934 2022-04-03 St. Clair Missouri 29185 2102 34
2367681 2367681 2022-04-02 St. Clair Missouri 29185 2102 34
2364428 2364428 2022-04-01 St. Clair Missouri 29185 2102 34
2361174 2361174 2022-03-31 St. Clair Missouri 29185 2102 34
2357920 2357920 2022-03-30 St. Clair Missouri 29185 2102 34
2354667 2354667 2022-03-29 St. Clair Missouri 29185 2102 34
2351414 2351414 2022-03-28 St. Clair Missouri 29185 2102 34
2348162 2348162 2022-03-27 St. Clair Missouri 29185 2101 34
2344909 2344909 2022-03-26 St. Clair Missouri 29185 2101 34
2341656 2341656 2022-03-25 St. Clair Missouri 29185 2101 34
2338403 2338403 2022-03-24 St. Clair Missouri 29185 2100 33
2335149 2335149 2022-03-23 St. Clair Missouri 29185 2099 33
2331895 2331895 2022-03-22 St. Clair Missouri 29185 2099 33
2328642 2328642 2022-03-21 St. Clair Missouri 29185 2099 33
2325390 2325390 2022-03-20 St. Clair Missouri 29185 2098 33
2322136 2322136 2022-03-19 St. Clair Missouri 29185 2098 33
2318882 2318882 2022-03-18 St. Clair Missouri 29185 2098 33
2315629 2315629 2022-03-17 St. Clair Missouri 29185 2098 33
2312376 2312376 2022-03-16 St. Clair Missouri 29185 2096 33
2309123 2309123 2022-03-15 St. Clair Missouri 29185 2096 33
2305871 2305871 2022-03-14 St. Clair Missouri 29185 2096 32
2302620 2302620 2022-03-13 St. Clair Missouri 29185 2096 32
2299368 2299368 2022-03-12 St. Clair Missouri 29185 2096 32
2296116 2296116 2022-03-11 St. Clair Missouri 29185 2096 32
2292864 2292864 2022-03-10 St. Clair Missouri 29185 2096 32
2289612 2289612 2022-03-09 St. Clair Missouri 29185 2096 32
2286360 2286360 2022-03-08 St. Clair Missouri 29185 2096 32
2283108 2283108 2022-03-07 St. Clair Missouri 29185 2096 32
2279855 2279855 2022-03-06 St. Clair Missouri 29185 2094 32
2276602 2276602 2022-03-05 St. Clair Missouri 29185 2094 32
2273349 2273349 2022-03-04 St. Clair Missouri 29185 2094 32
2270097 2270097 2022-03-03 St. Clair Missouri 29185 2092 32
2266844 2266844 2022-03-02 St. Clair Missouri 29185 2092 32
2263593 2263593 2022-03-01 St. Clair Missouri 29185 2090 32
2260342 2260342 2022-02-28 St. Clair Missouri 29185 2090 32
2257091 2257091 2022-02-27 St. Clair Missouri 29185 2089 32
2253840 2253840 2022-02-26 St. Clair Missouri 29185 2089 32
2250589 2250589 2022-02-25 St. Clair Missouri 29185 2089 32
2247338 2247338 2022-02-24 St. Clair Missouri 29185 2088 32
2244087 2244087 2022-02-23 St. Clair Missouri 29185 2084 31
2240836 2240836 2022-02-22 St. Clair Missouri 29185 2082 31
2237585 2237585 2022-02-21 St. Clair Missouri 29185 2078 31
2234334 2234334 2022-02-20 St. Clair Missouri 29185 2078 31
2231083 2231083 2022-02-19 St. Clair Missouri 29185 2078 31
2227832 2227832 2022-02-18 St. Clair Missouri 29185 2078 31
2224581 2224581 2022-02-17 St. Clair Missouri 29185 2078 31
2221330 2221330 2022-02-16 St. Clair Missouri 29185 2072 31
2218079 2218079 2022-02-15 St. Clair Missouri 29185 2070 31
2214828 2214828 2022-02-14 St. Clair Missouri 29185 2066 31
2211576 2211576 2022-02-13 St. Clair Missouri 29185 2056 31
2208323 2208323 2022-02-12 St. Clair Missouri 29185 2056 31
2205070 2205070 2022-02-11 St. Clair Missouri 29185 2056 31
2201817 2201817 2022-02-10 St. Clair Missouri 29185 2056 31
2198563 2198563 2022-02-09 St. Clair Missouri 29185 2050 31
2195309 2195309 2022-02-08 St. Clair Missouri 29185 2036 31
2192055 2192055 2022-02-07 St. Clair Missouri 29185 2026 30
2188802 2188802 2022-02-06 St. Clair Missouri 29185 2024 30
2185549 2185549 2022-02-05 St. Clair Missouri 29185 2020 30
2182297 2182297 2022-02-04 St. Clair Missouri 29185 2015 30
2179045 2179045 2022-02-03 St. Clair Missouri 29185 2007 30

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