ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "St. Joseph" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500898 | 2500898 | 2022-05-13 | St. Joseph | Michigan | 26149 | 13812 | 208 |
2497640 | 2497640 | 2022-05-12 | St. Joseph | Michigan | 26149 | 13812 | 208 |
2494382 | 2494382 | 2022-05-11 | St. Joseph | Michigan | 26149 | 13812 | 208 |
2491124 | 2491124 | 2022-05-10 | St. Joseph | Michigan | 26149 | 13757 | 208 |
2487867 | 2487867 | 2022-05-09 | St. Joseph | Michigan | 26149 | 13757 | 208 |
2484609 | 2484609 | 2022-05-08 | St. Joseph | Michigan | 26149 | 13757 | 208 |
2481351 | 2481351 | 2022-05-07 | St. Joseph | Michigan | 26149 | 13757 | 208 |
2478093 | 2478093 | 2022-05-06 | St. Joseph | Michigan | 26149 | 13757 | 208 |
2474835 | 2474835 | 2022-05-05 | St. Joseph | Michigan | 26149 | 13757 | 208 |
2471578 | 2471578 | 2022-05-04 | St. Joseph | Michigan | 26149 | 13757 | 208 |
2468322 | 2468322 | 2022-05-03 | St. Joseph | Michigan | 26149 | 13736 | 208 |
2465067 | 2465067 | 2022-05-02 | St. Joseph | Michigan | 26149 | 13736 | 208 |
2461811 | 2461811 | 2022-05-01 | St. Joseph | Michigan | 26149 | 13736 | 208 |
2458555 | 2458555 | 2022-04-30 | St. Joseph | Michigan | 26149 | 13736 | 208 |
2455299 | 2455299 | 2022-04-29 | St. Joseph | Michigan | 26149 | 13736 | 208 |
2452043 | 2452043 | 2022-04-28 | St. Joseph | Michigan | 26149 | 13736 | 208 |
2448787 | 2448787 | 2022-04-27 | St. Joseph | Michigan | 26149 | 13736 | 208 |
2445531 | 2445531 | 2022-04-26 | St. Joseph | Michigan | 26149 | 13715 | 207 |
2442275 | 2442275 | 2022-04-25 | St. Joseph | Michigan | 26149 | 13715 | 207 |
2439019 | 2439019 | 2022-04-24 | St. Joseph | Michigan | 26149 | 13715 | 207 |
2435763 | 2435763 | 2022-04-23 | St. Joseph | Michigan | 26149 | 13715 | 207 |
2432507 | 2432507 | 2022-04-22 | St. Joseph | Michigan | 26149 | 13715 | 207 |
2429251 | 2429251 | 2022-04-21 | St. Joseph | Michigan | 26149 | 13715 | 207 |
2425995 | 2425995 | 2022-04-20 | St. Joseph | Michigan | 26149 | 13715 | 207 |
2422739 | 2422739 | 2022-04-19 | St. Joseph | Michigan | 26149 | 13692 | 207 |
2419483 | 2419483 | 2022-04-18 | St. Joseph | Michigan | 26149 | 13692 | 207 |
2416227 | 2416227 | 2022-04-17 | St. Joseph | Michigan | 26149 | 13692 | 207 |
2412971 | 2412971 | 2022-04-16 | St. Joseph | Michigan | 26149 | 13692 | 207 |
2409715 | 2409715 | 2022-04-15 | St. Joseph | Michigan | 26149 | 13692 | 207 |
2406459 | 2406459 | 2022-04-14 | St. Joseph | Michigan | 26149 | 13692 | 207 |
2403203 | 2403203 | 2022-04-13 | St. Joseph | Michigan | 26149 | 13692 | 207 |
2399949 | 2399949 | 2022-04-12 | St. Joseph | Michigan | 26149 | 13667 | 204 |
2396693 | 2396693 | 2022-04-11 | St. Joseph | Michigan | 26149 | 13667 | 204 |
2393438 | 2393438 | 2022-04-10 | St. Joseph | Michigan | 26149 | 13667 | 204 |
2390182 | 2390182 | 2022-04-09 | St. Joseph | Michigan | 26149 | 13667 | 204 |
2386926 | 2386926 | 2022-04-08 | St. Joseph | Michigan | 26149 | 13667 | 204 |
2383671 | 2383671 | 2022-04-07 | St. Joseph | Michigan | 26149 | 13667 | 204 |
2380416 | 2380416 | 2022-04-06 | St. Joseph | Michigan | 26149 | 13667 | 204 |
2377161 | 2377161 | 2022-04-05 | St. Joseph | Michigan | 26149 | 13655 | 204 |
2373909 | 2373909 | 2022-04-04 | St. Joseph | Michigan | 26149 | 13655 | 204 |
2370656 | 2370656 | 2022-04-03 | St. Joseph | Michigan | 26149 | 13655 | 204 |
2367403 | 2367403 | 2022-04-02 | St. Joseph | Michigan | 26149 | 13655 | 204 |
2364150 | 2364150 | 2022-04-01 | St. Joseph | Michigan | 26149 | 13655 | 204 |
2360896 | 2360896 | 2022-03-31 | St. Joseph | Michigan | 26149 | 13651 | 204 |
2357642 | 2357642 | 2022-03-30 | St. Joseph | Michigan | 26149 | 13651 | 204 |
2354389 | 2354389 | 2022-03-29 | St. Joseph | Michigan | 26149 | 13643 | 205 |
2351137 | 2351137 | 2022-03-28 | St. Joseph | Michigan | 26149 | 13643 | 205 |
2347884 | 2347884 | 2022-03-27 | St. Joseph | Michigan | 26149 | 13641 | 205 |
2344631 | 2344631 | 2022-03-26 | St. Joseph | Michigan | 26149 | 13641 | 205 |
2341378 | 2341378 | 2022-03-25 | St. Joseph | Michigan | 26149 | 13641 | 205 |
2338125 | 2338125 | 2022-03-24 | St. Joseph | Michigan | 26149 | 13640 | 205 |
2334871 | 2334871 | 2022-03-23 | St. Joseph | Michigan | 26149 | 13640 | 205 |
2331617 | 2331617 | 2022-03-22 | St. Joseph | Michigan | 26149 | 13636 | 205 |
2328365 | 2328365 | 2022-03-21 | St. Joseph | Michigan | 26149 | 13636 | 205 |
2325112 | 2325112 | 2022-03-20 | St. Joseph | Michigan | 26149 | 13635 | 205 |
2321858 | 2321858 | 2022-03-19 | St. Joseph | Michigan | 26149 | 13635 | 205 |
2318604 | 2318604 | 2022-03-18 | St. Joseph | Michigan | 26149 | 13635 | 205 |
2315351 | 2315351 | 2022-03-17 | St. Joseph | Michigan | 26149 | 13629 | 205 |
2312098 | 2312098 | 2022-03-16 | St. Joseph | Michigan | 26149 | 13629 | 205 |
2308845 | 2308845 | 2022-03-15 | St. Joseph | Michigan | 26149 | 13626 | 204 |
2305594 | 2305594 | 2022-03-14 | St. Joseph | Michigan | 26149 | 13626 | 204 |
2302342 | 2302342 | 2022-03-13 | St. Joseph | Michigan | 26149 | 13616 | 204 |
2299090 | 2299090 | 2022-03-12 | St. Joseph | Michigan | 26149 | 13616 | 204 |
2295838 | 2295838 | 2022-03-11 | St. Joseph | Michigan | 26149 | 13616 | 204 |
2292586 | 2292586 | 2022-03-10 | St. Joseph | Michigan | 26149 | 13610 | 204 |
2289334 | 2289334 | 2022-03-09 | St. Joseph | Michigan | 26149 | 13610 | 204 |
2286083 | 2286083 | 2022-03-08 | St. Joseph | Michigan | 26149 | 13596 | 199 |
2282831 | 2282831 | 2022-03-07 | St. Joseph | Michigan | 26149 | 13596 | 199 |
2279578 | 2279578 | 2022-03-06 | St. Joseph | Michigan | 26149 | 13592 | 199 |
2276325 | 2276325 | 2022-03-05 | St. Joseph | Michigan | 26149 | 13592 | 199 |
2273072 | 2273072 | 2022-03-04 | St. Joseph | Michigan | 26149 | 13592 | 199 |
2269820 | 2269820 | 2022-03-03 | St. Joseph | Michigan | 26149 | 13588 | 199 |
2266567 | 2266567 | 2022-03-02 | St. Joseph | Michigan | 26149 | 13588 | 199 |
2263316 | 2263316 | 2022-03-01 | St. Joseph | Michigan | 26149 | 13581 | 196 |
2260065 | 2260065 | 2022-02-28 | St. Joseph | Michigan | 26149 | 13581 | 196 |
2256814 | 2256814 | 2022-02-27 | St. Joseph | Michigan | 26149 | 13572 | 196 |
2253563 | 2253563 | 2022-02-26 | St. Joseph | Michigan | 26149 | 13572 | 196 |
2250312 | 2250312 | 2022-02-25 | St. Joseph | Michigan | 26149 | 13572 | 196 |
2247061 | 2247061 | 2022-02-24 | St. Joseph | Michigan | 26149 | 13553 | 196 |
2243810 | 2243810 | 2022-02-23 | St. Joseph | Michigan | 26149 | 13553 | 196 |
2240559 | 2240559 | 2022-02-22 | St. Joseph | Michigan | 26149 | 13515 | 192 |
2237308 | 2237308 | 2022-02-21 | St. Joseph | Michigan | 26149 | 13515 | 192 |
2234057 | 2234057 | 2022-02-20 | St. Joseph | Michigan | 26149 | 13515 | 192 |
2230806 | 2230806 | 2022-02-19 | St. Joseph | Michigan | 26149 | 13489 | 191 |
2227555 | 2227555 | 2022-02-18 | St. Joseph | Michigan | 26149 | 13489 | 191 |
2224304 | 2224304 | 2022-02-17 | St. Joseph | Michigan | 26149 | 13489 | 191 |
2221053 | 2221053 | 2022-02-16 | St. Joseph | Michigan | 26149 | 13489 | 191 |
2217802 | 2217802 | 2022-02-15 | St. Joseph | Michigan | 26149 | 13453 | 189 |
2214551 | 2214551 | 2022-02-14 | St. Joseph | Michigan | 26149 | 13453 | 189 |
2211299 | 2211299 | 2022-02-13 | St. Joseph | Michigan | 26149 | 13436 | 189 |
2208046 | 2208046 | 2022-02-12 | St. Joseph | Michigan | 26149 | 13436 | 189 |
2204793 | 2204793 | 2022-02-11 | St. Joseph | Michigan | 26149 | 13436 | 189 |
2201540 | 2201540 | 2022-02-10 | St. Joseph | Michigan | 26149 | 13415 | 188 |
2198286 | 2198286 | 2022-02-09 | St. Joseph | Michigan | 26149 | 13415 | 188 |
2195032 | 2195032 | 2022-02-08 | St. Joseph | Michigan | 26149 | 13370 | 186 |
2191778 | 2191778 | 2022-02-07 | St. Joseph | Michigan | 26149 | 13370 | 186 |
2188525 | 2188525 | 2022-02-06 | St. Joseph | Michigan | 26149 | 13307 | 186 |
2185272 | 2185272 | 2022-02-05 | St. Joseph | Michigan | 26149 | 13307 | 186 |
2182020 | 2182020 | 2022-02-04 | St. Joseph | Michigan | 26149 | 13307 | 186 |
2178768 | 2178768 | 2022-02-03 | St. Joseph | Michigan | 26149 | 13238 | 183 |
Advanced export
JSON shape: default, array, newline-delimited
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);