ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Macoupin" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500232 | 2500232 | 2022-05-13 | Macoupin | Illinois | 17117 | 12975 | 171 |
2496974 | 2496974 | 2022-05-12 | Macoupin | Illinois | 17117 | 12956 | 171 |
2493716 | 2493716 | 2022-05-11 | Macoupin | Illinois | 17117 | 12949 | 171 |
2490458 | 2490458 | 2022-05-10 | Macoupin | Illinois | 17117 | 12942 | 171 |
2487201 | 2487201 | 2022-05-09 | Macoupin | Illinois | 17117 | 12928 | 171 |
2483943 | 2483943 | 2022-05-08 | Macoupin | Illinois | 17117 | 12906 | 171 |
2480685 | 2480685 | 2022-05-07 | Macoupin | Illinois | 17117 | 12906 | 171 |
2477427 | 2477427 | 2022-05-06 | Macoupin | Illinois | 17117 | 12906 | 171 |
2474169 | 2474169 | 2022-05-05 | Macoupin | Illinois | 17117 | 12894 | 171 |
2470912 | 2470912 | 2022-05-04 | Macoupin | Illinois | 17117 | 12886 | 171 |
2467656 | 2467656 | 2022-05-03 | Macoupin | Illinois | 17117 | 12882 | 171 |
2464401 | 2464401 | 2022-05-02 | Macoupin | Illinois | 17117 | 12870 | 171 |
2461145 | 2461145 | 2022-05-01 | Macoupin | Illinois | 17117 | 12858 | 171 |
2457889 | 2457889 | 2022-04-30 | Macoupin | Illinois | 17117 | 12858 | 171 |
2454633 | 2454633 | 2022-04-29 | Macoupin | Illinois | 17117 | 12858 | 171 |
2451377 | 2451377 | 2022-04-28 | Macoupin | Illinois | 17117 | 12850 | 171 |
2448121 | 2448121 | 2022-04-27 | Macoupin | Illinois | 17117 | 12843 | 171 |
2444865 | 2444865 | 2022-04-26 | Macoupin | Illinois | 17117 | 12838 | 171 |
2441609 | 2441609 | 2022-04-25 | Macoupin | Illinois | 17117 | 12831 | 171 |
2438353 | 2438353 | 2022-04-24 | Macoupin | Illinois | 17117 | 12816 | 171 |
2435097 | 2435097 | 2022-04-23 | Macoupin | Illinois | 17117 | 12816 | 171 |
2431841 | 2431841 | 2022-04-22 | Macoupin | Illinois | 17117 | 12816 | 171 |
2428585 | 2428585 | 2022-04-21 | Macoupin | Illinois | 17117 | 12807 | 171 |
2425329 | 2425329 | 2022-04-20 | Macoupin | Illinois | 17117 | 12801 | 171 |
2422073 | 2422073 | 2022-04-19 | Macoupin | Illinois | 17117 | 12796 | 171 |
2418817 | 2418817 | 2022-04-18 | Macoupin | Illinois | 17117 | 12790 | 171 |
2415561 | 2415561 | 2022-04-17 | Macoupin | Illinois | 17117 | 12784 | 171 |
2412305 | 2412305 | 2022-04-16 | Macoupin | Illinois | 17117 | 12784 | 171 |
2409049 | 2409049 | 2022-04-15 | Macoupin | Illinois | 17117 | 12784 | 171 |
2405793 | 2405793 | 2022-04-14 | Macoupin | Illinois | 17117 | 12782 | 171 |
2402538 | 2402538 | 2022-04-13 | Macoupin | Illinois | 17117 | 12780 | 171 |
2399283 | 2399283 | 2022-04-12 | Macoupin | Illinois | 17117 | 12779 | 171 |
2396028 | 2396028 | 2022-04-11 | Macoupin | Illinois | 17117 | 12779 | 171 |
2392772 | 2392772 | 2022-04-10 | Macoupin | Illinois | 17117 | 12771 | 171 |
2389516 | 2389516 | 2022-04-09 | Macoupin | Illinois | 17117 | 12771 | 171 |
2386261 | 2386261 | 2022-04-08 | Macoupin | Illinois | 17117 | 12771 | 171 |
2383006 | 2383006 | 2022-04-07 | Macoupin | Illinois | 17117 | 12769 | 171 |
2379751 | 2379751 | 2022-04-06 | Macoupin | Illinois | 17117 | 12766 | 171 |
2376497 | 2376497 | 2022-04-05 | Macoupin | Illinois | 17117 | 12764 | 171 |
2373245 | 2373245 | 2022-04-04 | Macoupin | Illinois | 17117 | 12756 | 170 |
2369992 | 2369992 | 2022-04-03 | Macoupin | Illinois | 17117 | 12747 | 170 |
2366739 | 2366739 | 2022-04-02 | Macoupin | Illinois | 17117 | 12747 | 170 |
2363486 | 2363486 | 2022-04-01 | Macoupin | Illinois | 17117 | 12747 | 170 |
2360232 | 2360232 | 2022-03-31 | Macoupin | Illinois | 17117 | 12746 | 170 |
2356978 | 2356978 | 2022-03-30 | Macoupin | Illinois | 17117 | 12747 | 170 |
2353725 | 2353725 | 2022-03-29 | Macoupin | Illinois | 17117 | 12739 | 170 |
2350473 | 2350473 | 2022-03-28 | Macoupin | Illinois | 17117 | 12733 | 170 |
2347220 | 2347220 | 2022-03-27 | Macoupin | Illinois | 17117 | 12728 | 170 |
2343967 | 2343967 | 2022-03-26 | Macoupin | Illinois | 17117 | 12728 | 170 |
2340714 | 2340714 | 2022-03-25 | Macoupin | Illinois | 17117 | 12728 | 170 |
2337461 | 2337461 | 2022-03-24 | Macoupin | Illinois | 17117 | 12724 | 170 |
2334207 | 2334207 | 2022-03-23 | Macoupin | Illinois | 17117 | 12720 | 169 |
2330953 | 2330953 | 2022-03-22 | Macoupin | Illinois | 17117 | 12711 | 168 |
2327701 | 2327701 | 2022-03-21 | Macoupin | Illinois | 17117 | 12708 | 168 |
2324448 | 2324448 | 2022-03-20 | Macoupin | Illinois | 17117 | 12703 | 168 |
2321194 | 2321194 | 2022-03-19 | Macoupin | Illinois | 17117 | 12703 | 168 |
2317940 | 2317940 | 2022-03-18 | Macoupin | Illinois | 17117 | 12703 | 168 |
2314687 | 2314687 | 2022-03-17 | Macoupin | Illinois | 17117 | 12701 | 168 |
2311434 | 2311434 | 2022-03-16 | Macoupin | Illinois | 17117 | 12697 | 168 |
2308181 | 2308181 | 2022-03-15 | Macoupin | Illinois | 17117 | 12692 | 168 |
2304930 | 2304930 | 2022-03-14 | Macoupin | Illinois | 17117 | 12687 | 167 |
2301678 | 2301678 | 2022-03-13 | Macoupin | Illinois | 17117 | 12681 | 166 |
2298426 | 2298426 | 2022-03-12 | Macoupin | Illinois | 17117 | 12681 | 166 |
2295174 | 2295174 | 2022-03-11 | Macoupin | Illinois | 17117 | 12681 | 166 |
2291922 | 2291922 | 2022-03-10 | Macoupin | Illinois | 17117 | 12677 | 166 |
2288670 | 2288670 | 2022-03-09 | Macoupin | Illinois | 17117 | 12673 | 166 |
2285419 | 2285419 | 2022-03-08 | Macoupin | Illinois | 17117 | 12668 | 166 |
2282167 | 2282167 | 2022-03-07 | Macoupin | Illinois | 17117 | 12666 | 166 |
2278914 | 2278914 | 2022-03-06 | Macoupin | Illinois | 17117 | 12653 | 166 |
2275661 | 2275661 | 2022-03-05 | Macoupin | Illinois | 17117 | 12653 | 166 |
2272408 | 2272408 | 2022-03-04 | Macoupin | Illinois | 17117 | 12653 | 166 |
2269156 | 2269156 | 2022-03-03 | Macoupin | Illinois | 17117 | 12651 | 166 |
2265903 | 2265903 | 2022-03-02 | Macoupin | Illinois | 17117 | 12648 | 166 |
2262652 | 2262652 | 2022-03-01 | Macoupin | Illinois | 17117 | 12644 | 166 |
2259401 | 2259401 | 2022-02-28 | Macoupin | Illinois | 17117 | 12630 | 166 |
2256150 | 2256150 | 2022-02-27 | Macoupin | Illinois | 17117 | 12611 | 166 |
2252899 | 2252899 | 2022-02-26 | Macoupin | Illinois | 17117 | 12611 | 166 |
2249648 | 2249648 | 2022-02-25 | Macoupin | Illinois | 17117 | 12611 | 166 |
2246397 | 2246397 | 2022-02-24 | Macoupin | Illinois | 17117 | 12598 | 166 |
2243146 | 2243146 | 2022-02-23 | Macoupin | Illinois | 17117 | 12587 | 166 |
2239895 | 2239895 | 2022-02-22 | Macoupin | Illinois | 17117 | 12576 | 166 |
2236644 | 2236644 | 2022-02-21 | Macoupin | Illinois | 17117 | 12549 | 165 |
2233393 | 2233393 | 2022-02-20 | Macoupin | Illinois | 17117 | 12549 | 165 |
2230142 | 2230142 | 2022-02-19 | Macoupin | Illinois | 17117 | 12549 | 165 |
2226891 | 2226891 | 2022-02-18 | Macoupin | Illinois | 17117 | 12549 | 165 |
2223640 | 2223640 | 2022-02-17 | Macoupin | Illinois | 17117 | 12537 | 165 |
2220389 | 2220389 | 2022-02-16 | Macoupin | Illinois | 17117 | 12529 | 165 |
2217138 | 2217138 | 2022-02-15 | Macoupin | Illinois | 17117 | 12518 | 163 |
2213887 | 2213887 | 2022-02-14 | Macoupin | Illinois | 17117 | 12505 | 163 |
2210635 | 2210635 | 2022-02-13 | Macoupin | Illinois | 17117 | 12447 | 162 |
2207382 | 2207382 | 2022-02-12 | Macoupin | Illinois | 17117 | 12447 | 162 |
2204129 | 2204129 | 2022-02-11 | Macoupin | Illinois | 17117 | 12447 | 162 |
2200876 | 2200876 | 2022-02-10 | Macoupin | Illinois | 17117 | 12447 | 162 |
2197622 | 2197622 | 2022-02-09 | Macoupin | Illinois | 17117 | 12420 | 161 |
2194368 | 2194368 | 2022-02-08 | Macoupin | Illinois | 17117 | 12392 | 158 |
2191114 | 2191114 | 2022-02-07 | Macoupin | Illinois | 17117 | 12361 | 158 |
2187861 | 2187861 | 2022-02-06 | Macoupin | Illinois | 17117 | 12314 | 158 |
2184608 | 2184608 | 2022-02-05 | Macoupin | Illinois | 17117 | 12314 | 158 |
2181356 | 2181356 | 2022-02-04 | Macoupin | Illinois | 17117 | 12314 | 158 |
2178105 | 2178105 | 2022-02-03 | Macoupin | Illinois | 17117 | 12262 | 157 |
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);