ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where county = "McLeod" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500950 | 2500950 | 2022-05-13 | McLeod | Minnesota | 27085 | 10753 | 108 |
2497692 | 2497692 | 2022-05-12 | McLeod | Minnesota | 27085 | 10741 | 108 |
2494434 | 2494434 | 2022-05-11 | McLeod | Minnesota | 27085 | 10733 | 108 |
2491176 | 2491176 | 2022-05-10 | McLeod | Minnesota | 27085 | 10725 | 108 |
2487919 | 2487919 | 2022-05-09 | McLeod | Minnesota | 27085 | 10707 | 108 |
2484661 | 2484661 | 2022-05-08 | McLeod | Minnesota | 27085 | 10693 | 108 |
2481403 | 2481403 | 2022-05-07 | McLeod | Minnesota | 27085 | 10693 | 108 |
2478145 | 2478145 | 2022-05-06 | McLeod | Minnesota | 27085 | 10693 | 108 |
2474887 | 2474887 | 2022-05-05 | McLeod | Minnesota | 27085 | 10684 | 108 |
2471630 | 2471630 | 2022-05-04 | McLeod | Minnesota | 27085 | 10675 | 108 |
2468374 | 2468374 | 2022-05-03 | McLeod | Minnesota | 27085 | 10661 | 108 |
2465119 | 2465119 | 2022-05-02 | McLeod | Minnesota | 27085 | 10648 | 108 |
2461863 | 2461863 | 2022-05-01 | McLeod | Minnesota | 27085 | 10640 | 108 |
2458607 | 2458607 | 2022-04-30 | McLeod | Minnesota | 27085 | 10640 | 108 |
2455351 | 2455351 | 2022-04-29 | McLeod | Minnesota | 27085 | 10640 | 108 |
2452095 | 2452095 | 2022-04-28 | McLeod | Minnesota | 27085 | 10631 | 108 |
2448839 | 2448839 | 2022-04-27 | McLeod | Minnesota | 27085 | 10622 | 108 |
2445583 | 2445583 | 2022-04-26 | McLeod | Minnesota | 27085 | 10613 | 108 |
2442327 | 2442327 | 2022-04-25 | McLeod | Minnesota | 27085 | 10606 | 108 |
2439071 | 2439071 | 2022-04-24 | McLeod | Minnesota | 27085 | 10603 | 108 |
2435815 | 2435815 | 2022-04-23 | McLeod | Minnesota | 27085 | 10603 | 108 |
2432559 | 2432559 | 2022-04-22 | McLeod | Minnesota | 27085 | 10603 | 108 |
2429303 | 2429303 | 2022-04-21 | McLeod | Minnesota | 27085 | 10600 | 108 |
2426047 | 2426047 | 2022-04-20 | McLeod | Minnesota | 27085 | 10593 | 108 |
2422791 | 2422791 | 2022-04-19 | McLeod | Minnesota | 27085 | 10588 | 108 |
2419535 | 2419535 | 2022-04-18 | McLeod | Minnesota | 27085 | 10588 | 108 |
2416279 | 2416279 | 2022-04-17 | McLeod | Minnesota | 27085 | 10583 | 108 |
2413023 | 2413023 | 2022-04-16 | McLeod | Minnesota | 27085 | 10583 | 108 |
2409767 | 2409767 | 2022-04-15 | McLeod | Minnesota | 27085 | 10583 | 108 |
2406511 | 2406511 | 2022-04-14 | McLeod | Minnesota | 27085 | 10579 | 108 |
2403255 | 2403255 | 2022-04-13 | McLeod | Minnesota | 27085 | 10577 | 108 |
2400001 | 2400001 | 2022-04-12 | McLeod | Minnesota | 27085 | 10575 | 108 |
2396745 | 2396745 | 2022-04-11 | McLeod | Minnesota | 27085 | 10570 | 108 |
2393490 | 2393490 | 2022-04-10 | McLeod | Minnesota | 27085 | 10566 | 108 |
2390234 | 2390234 | 2022-04-09 | McLeod | Minnesota | 27085 | 10566 | 108 |
2386978 | 2386978 | 2022-04-08 | McLeod | Minnesota | 27085 | 10566 | 108 |
2383723 | 2383723 | 2022-04-07 | McLeod | Minnesota | 27085 | 10563 | 108 |
2380468 | 2380468 | 2022-04-06 | McLeod | Minnesota | 27085 | 10557 | 108 |
2377213 | 2377213 | 2022-04-05 | McLeod | Minnesota | 27085 | 10556 | 108 |
2373961 | 2373961 | 2022-04-04 | McLeod | Minnesota | 27085 | 10547 | 108 |
2370708 | 2370708 | 2022-04-03 | McLeod | Minnesota | 27085 | 10546 | 108 |
2367455 | 2367455 | 2022-04-02 | McLeod | Minnesota | 27085 | 10546 | 108 |
2364202 | 2364202 | 2022-04-01 | McLeod | Minnesota | 27085 | 10546 | 108 |
2360948 | 2360948 | 2022-03-31 | McLeod | Minnesota | 27085 | 10546 | 108 |
2357694 | 2357694 | 2022-03-30 | McLeod | Minnesota | 27085 | 10545 | 108 |
2354441 | 2354441 | 2022-03-29 | McLeod | Minnesota | 27085 | 10543 | 108 |
2351189 | 2351189 | 2022-03-28 | McLeod | Minnesota | 27085 | 10541 | 108 |
2347936 | 2347936 | 2022-03-27 | McLeod | Minnesota | 27085 | 10537 | 107 |
2344683 | 2344683 | 2022-03-26 | McLeod | Minnesota | 27085 | 10537 | 107 |
2341430 | 2341430 | 2022-03-25 | McLeod | Minnesota | 27085 | 10537 | 107 |
2338177 | 2338177 | 2022-03-24 | McLeod | Minnesota | 27085 | 10536 | 107 |
2334923 | 2334923 | 2022-03-23 | McLeod | Minnesota | 27085 | 10534 | 107 |
2331669 | 2331669 | 2022-03-22 | McLeod | Minnesota | 27085 | 10531 | 107 |
2328417 | 2328417 | 2022-03-21 | McLeod | Minnesota | 27085 | 10527 | 107 |
2325164 | 2325164 | 2022-03-20 | McLeod | Minnesota | 27085 | 10523 | 107 |
2321910 | 2321910 | 2022-03-19 | McLeod | Minnesota | 27085 | 10523 | 107 |
2318656 | 2318656 | 2022-03-18 | McLeod | Minnesota | 27085 | 10523 | 107 |
2315403 | 2315403 | 2022-03-17 | McLeod | Minnesota | 27085 | 10516 | 107 |
2312150 | 2312150 | 2022-03-16 | McLeod | Minnesota | 27085 | 10514 | 107 |
2308897 | 2308897 | 2022-03-15 | McLeod | Minnesota | 27085 | 10499 | 107 |
2305646 | 2305646 | 2022-03-14 | McLeod | Minnesota | 27085 | 10491 | 107 |
2302394 | 2302394 | 2022-03-13 | McLeod | Minnesota | 27085 | 10487 | 107 |
2299142 | 2299142 | 2022-03-12 | McLeod | Minnesota | 27085 | 10487 | 107 |
2295890 | 2295890 | 2022-03-11 | McLeod | Minnesota | 27085 | 10487 | 107 |
2292638 | 2292638 | 2022-03-10 | McLeod | Minnesota | 27085 | 10431 | 107 |
2289386 | 2289386 | 2022-03-09 | McLeod | Minnesota | 27085 | 10429 | 107 |
2286135 | 2286135 | 2022-03-08 | McLeod | Minnesota | 27085 | 10427 | 106 |
2282883 | 2282883 | 2022-03-07 | McLeod | Minnesota | 27085 | 10416 | 106 |
2279630 | 2279630 | 2022-03-06 | McLeod | Minnesota | 27085 | 10412 | 106 |
2276377 | 2276377 | 2022-03-05 | McLeod | Minnesota | 27085 | 10412 | 106 |
2273124 | 2273124 | 2022-03-04 | McLeod | Minnesota | 27085 | 10412 | 106 |
2269872 | 2269872 | 2022-03-03 | McLeod | Minnesota | 27085 | 10402 | 105 |
2266619 | 2266619 | 2022-03-02 | McLeod | Minnesota | 27085 | 10394 | 105 |
2263368 | 2263368 | 2022-03-01 | McLeod | Minnesota | 27085 | 10406 | 105 |
2260117 | 2260117 | 2022-02-28 | McLeod | Minnesota | 27085 | 10386 | 105 |
2256866 | 2256866 | 2022-02-27 | McLeod | Minnesota | 27085 | 10381 | 104 |
2253615 | 2253615 | 2022-02-26 | McLeod | Minnesota | 27085 | 10381 | 104 |
2250364 | 2250364 | 2022-02-25 | McLeod | Minnesota | 27085 | 10381 | 104 |
2247113 | 2247113 | 2022-02-24 | McLeod | Minnesota | 27085 | 10376 | 104 |
2243862 | 2243862 | 2022-02-23 | McLeod | Minnesota | 27085 | 10369 | 102 |
2240611 | 2240611 | 2022-02-22 | McLeod | Minnesota | 27085 | 10330 | 102 |
2237360 | 2237360 | 2022-02-21 | McLeod | Minnesota | 27085 | 10314 | 101 |
2234109 | 2234109 | 2022-02-20 | McLeod | Minnesota | 27085 | 10314 | 101 |
2230858 | 2230858 | 2022-02-19 | McLeod | Minnesota | 27085 | 10314 | 101 |
2227607 | 2227607 | 2022-02-18 | McLeod | Minnesota | 27085 | 10314 | 101 |
2224356 | 2224356 | 2022-02-17 | McLeod | Minnesota | 27085 | 10265 | 101 |
2221105 | 2221105 | 2022-02-16 | McLeod | Minnesota | 27085 | 10254 | 101 |
2217854 | 2217854 | 2022-02-15 | McLeod | Minnesota | 27085 | 10244 | 101 |
2214603 | 2214603 | 2022-02-14 | McLeod | Minnesota | 27085 | 10196 | 100 |
2211351 | 2211351 | 2022-02-13 | McLeod | Minnesota | 27085 | 10161 | 100 |
2208098 | 2208098 | 2022-02-12 | McLeod | Minnesota | 27085 | 10161 | 100 |
2204845 | 2204845 | 2022-02-11 | McLeod | Minnesota | 27085 | 10161 | 100 |
2201592 | 2201592 | 2022-02-10 | McLeod | Minnesota | 27085 | 10133 | 100 |
2198338 | 2198338 | 2022-02-09 | McLeod | Minnesota | 27085 | 10104 | 100 |
2195084 | 2195084 | 2022-02-08 | McLeod | Minnesota | 27085 | 10034 | 100 |
2191830 | 2191830 | 2022-02-07 | McLeod | Minnesota | 27085 | 9967 | 99 |
2188577 | 2188577 | 2022-02-06 | McLeod | Minnesota | 27085 | 9916 | 99 |
2185324 | 2185324 | 2022-02-05 | McLeod | Minnesota | 27085 | 9916 | 99 |
2182072 | 2182072 | 2022-02-04 | McLeod | Minnesota | 27085 | 9916 | 99 |
2178820 | 2178820 | 2022-02-03 | McLeod | Minnesota | 27085 | 9867 | 98 |
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);