ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
769 rows where county = "McLean" and fips = 21149 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 |
---|---|---|---|---|---|---|---|
2500659 | 2500659 | 2022-05-13 | McLean | Kentucky | 21149 | 2621 | 53 |
2497401 | 2497401 | 2022-05-12 | McLean | Kentucky | 21149 | 2621 | 53 |
2494143 | 2494143 | 2022-05-11 | McLean | Kentucky | 21149 | 2621 | 53 |
2490885 | 2490885 | 2022-05-10 | McLean | Kentucky | 21149 | 2621 | 53 |
2487628 | 2487628 | 2022-05-09 | McLean | Kentucky | 21149 | 2621 | 53 |
2484370 | 2484370 | 2022-05-08 | McLean | Kentucky | 21149 | 2618 | 50 |
2481112 | 2481112 | 2022-05-07 | McLean | Kentucky | 21149 | 2618 | 50 |
2477854 | 2477854 | 2022-05-06 | McLean | Kentucky | 21149 | 2618 | 50 |
2474596 | 2474596 | 2022-05-05 | McLean | Kentucky | 21149 | 2618 | 50 |
2471339 | 2471339 | 2022-05-04 | McLean | Kentucky | 21149 | 2618 | 50 |
2468083 | 2468083 | 2022-05-03 | McLean | Kentucky | 21149 | 2618 | 50 |
2464828 | 2464828 | 2022-05-02 | McLean | Kentucky | 21149 | 2618 | 50 |
2461572 | 2461572 | 2022-05-01 | McLean | Kentucky | 21149 | 2616 | 50 |
2458316 | 2458316 | 2022-04-30 | McLean | Kentucky | 21149 | 2616 | 50 |
2455060 | 2455060 | 2022-04-29 | McLean | Kentucky | 21149 | 2616 | 50 |
2451804 | 2451804 | 2022-04-28 | McLean | Kentucky | 21149 | 2616 | 50 |
2448548 | 2448548 | 2022-04-27 | McLean | Kentucky | 21149 | 2616 | 50 |
2445292 | 2445292 | 2022-04-26 | McLean | Kentucky | 21149 | 2616 | 50 |
2442036 | 2442036 | 2022-04-25 | McLean | Kentucky | 21149 | 2616 | 50 |
2438780 | 2438780 | 2022-04-24 | McLean | Kentucky | 21149 | 2616 | 50 |
2435524 | 2435524 | 2022-04-23 | McLean | Kentucky | 21149 | 2616 | 50 |
2432268 | 2432268 | 2022-04-22 | McLean | Kentucky | 21149 | 2616 | 50 |
2429012 | 2429012 | 2022-04-21 | McLean | Kentucky | 21149 | 2616 | 50 |
2425756 | 2425756 | 2022-04-20 | McLean | Kentucky | 21149 | 2616 | 50 |
2422500 | 2422500 | 2022-04-19 | McLean | Kentucky | 21149 | 2616 | 50 |
2419244 | 2419244 | 2022-04-18 | McLean | Kentucky | 21149 | 2616 | 50 |
2415988 | 2415988 | 2022-04-17 | McLean | Kentucky | 21149 | 2613 | 50 |
2412732 | 2412732 | 2022-04-16 | McLean | Kentucky | 21149 | 2613 | 50 |
2409476 | 2409476 | 2022-04-15 | McLean | Kentucky | 21149 | 2613 | 50 |
2406220 | 2406220 | 2022-04-14 | McLean | Kentucky | 21149 | 2613 | 50 |
2402964 | 2402964 | 2022-04-13 | McLean | Kentucky | 21149 | 2613 | 50 |
2399710 | 2399710 | 2022-04-12 | McLean | Kentucky | 21149 | 2613 | 50 |
2396454 | 2396454 | 2022-04-11 | McLean | Kentucky | 21149 | 2613 | 50 |
2393199 | 2393199 | 2022-04-10 | McLean | Kentucky | 21149 | 2609 | 50 |
2389943 | 2389943 | 2022-04-09 | McLean | Kentucky | 21149 | 2609 | 50 |
2386687 | 2386687 | 2022-04-08 | McLean | Kentucky | 21149 | 2609 | 50 |
2383432 | 2383432 | 2022-04-07 | McLean | Kentucky | 21149 | 2609 | 50 |
2380177 | 2380177 | 2022-04-06 | McLean | Kentucky | 21149 | 2609 | 50 |
2376922 | 2376922 | 2022-04-05 | McLean | Kentucky | 21149 | 2609 | 50 |
2373670 | 2373670 | 2022-04-04 | McLean | Kentucky | 21149 | 2609 | 50 |
2370417 | 2370417 | 2022-04-03 | McLean | Kentucky | 21149 | 2607 | 49 |
2367164 | 2367164 | 2022-04-02 | McLean | Kentucky | 21149 | 2607 | 49 |
2363911 | 2363911 | 2022-04-01 | McLean | Kentucky | 21149 | 2607 | 49 |
2360657 | 2360657 | 2022-03-31 | McLean | Kentucky | 21149 | 2607 | 49 |
2357403 | 2357403 | 2022-03-30 | McLean | Kentucky | 21149 | 2607 | 49 |
2354150 | 2354150 | 2022-03-29 | McLean | Kentucky | 21149 | 2607 | 49 |
2350898 | 2350898 | 2022-03-28 | McLean | Kentucky | 21149 | 2607 | 49 |
2347645 | 2347645 | 2022-03-27 | McLean | Kentucky | 21149 | 2604 | 47 |
2344392 | 2344392 | 2022-03-26 | McLean | Kentucky | 21149 | 2604 | 47 |
2341139 | 2341139 | 2022-03-25 | McLean | Kentucky | 21149 | 2604 | 47 |
2337886 | 2337886 | 2022-03-24 | McLean | Kentucky | 21149 | 2604 | 47 |
2334632 | 2334632 | 2022-03-23 | McLean | Kentucky | 21149 | 2604 | 47 |
2331378 | 2331378 | 2022-03-22 | McLean | Kentucky | 21149 | 2604 | 47 |
2328126 | 2328126 | 2022-03-21 | McLean | Kentucky | 21149 | 2604 | 47 |
2324873 | 2324873 | 2022-03-20 | McLean | Kentucky | 21149 | 2603 | 47 |
2321619 | 2321619 | 2022-03-19 | McLean | Kentucky | 21149 | 2603 | 47 |
2318365 | 2318365 | 2022-03-18 | McLean | Kentucky | 21149 | 2603 | 47 |
2315112 | 2315112 | 2022-03-17 | McLean | Kentucky | 21149 | 2603 | 47 |
2311859 | 2311859 | 2022-03-16 | McLean | Kentucky | 21149 | 2603 | 47 |
2308606 | 2308606 | 2022-03-15 | McLean | Kentucky | 21149 | 2603 | 47 |
2305355 | 2305355 | 2022-03-14 | McLean | Kentucky | 21149 | 2603 | 47 |
2302103 | 2302103 | 2022-03-13 | McLean | Kentucky | 21149 | 2596 | 45 |
2298851 | 2298851 | 2022-03-12 | McLean | Kentucky | 21149 | 2596 | 45 |
2295599 | 2295599 | 2022-03-11 | McLean | Kentucky | 21149 | 2596 | 45 |
2292347 | 2292347 | 2022-03-10 | McLean | Kentucky | 21149 | 2596 | 45 |
2289095 | 2289095 | 2022-03-09 | McLean | Kentucky | 21149 | 2598 | 46 |
2285844 | 2285844 | 2022-03-08 | McLean | Kentucky | 21149 | 2598 | 46 |
2282592 | 2282592 | 2022-03-07 | McLean | Kentucky | 21149 | 2598 | 46 |
2279339 | 2279339 | 2022-03-06 | McLean | Kentucky | 21149 | 2598 | 46 |
2276086 | 2276086 | 2022-03-05 | McLean | Kentucky | 21149 | 2598 | 46 |
2272833 | 2272833 | 2022-03-04 | McLean | Kentucky | 21149 | 2598 | 46 |
2269581 | 2269581 | 2022-03-03 | McLean | Kentucky | 21149 | 2599 | 46 |
2266328 | 2266328 | 2022-03-02 | McLean | Kentucky | 21149 | 2596 | 46 |
2263077 | 2263077 | 2022-03-01 | McLean | Kentucky | 21149 | 2595 | 45 |
2259826 | 2259826 | 2022-02-28 | McLean | Kentucky | 21149 | 2593 | 45 |
2256575 | 2256575 | 2022-02-27 | McLean | Kentucky | 21149 | 2592 | 45 |
2253324 | 2253324 | 2022-02-26 | McLean | Kentucky | 21149 | 2592 | 45 |
2250073 | 2250073 | 2022-02-25 | McLean | Kentucky | 21149 | 2592 | 45 |
2246822 | 2246822 | 2022-02-24 | McLean | Kentucky | 21149 | 2586 | 45 |
2243571 | 2243571 | 2022-02-23 | McLean | Kentucky | 21149 | 2586 | 45 |
2240320 | 2240320 | 2022-02-22 | McLean | Kentucky | 21149 | 2586 | 45 |
2237069 | 2237069 | 2022-02-21 | McLean | Kentucky | 21149 | 2586 | 45 |
2233818 | 2233818 | 2022-02-20 | McLean | Kentucky | 21149 | 2582 | 45 |
2230567 | 2230567 | 2022-02-19 | McLean | Kentucky | 21149 | 2582 | 45 |
2227316 | 2227316 | 2022-02-18 | McLean | Kentucky | 21149 | 2582 | 45 |
2224065 | 2224065 | 2022-02-17 | McLean | Kentucky | 21149 | 2580 | 45 |
2220814 | 2220814 | 2022-02-16 | McLean | Kentucky | 21149 | 2577 | 45 |
2217563 | 2217563 | 2022-02-15 | McLean | Kentucky | 21149 | 2572 | 44 |
2214312 | 2214312 | 2022-02-14 | McLean | Kentucky | 21149 | 2572 | 44 |
2211060 | 2211060 | 2022-02-13 | McLean | Kentucky | 21149 | 2539 | 44 |
2207807 | 2207807 | 2022-02-12 | McLean | Kentucky | 21149 | 2539 | 44 |
2204554 | 2204554 | 2022-02-11 | McLean | Kentucky | 21149 | 2539 | 44 |
2201301 | 2201301 | 2022-02-10 | McLean | Kentucky | 21149 | 2527 | 44 |
2198047 | 2198047 | 2022-02-09 | McLean | Kentucky | 21149 | 2519 | 44 |
2194793 | 2194793 | 2022-02-08 | McLean | Kentucky | 21149 | 2507 | 44 |
2191539 | 2191539 | 2022-02-07 | McLean | Kentucky | 21149 | 2499 | 44 |
2188286 | 2188286 | 2022-02-06 | McLean | Kentucky | 21149 | 2483 | 44 |
2185033 | 2185033 | 2022-02-05 | McLean | Kentucky | 21149 | 2483 | 44 |
2181781 | 2181781 | 2022-02-04 | McLean | Kentucky | 21149 | 2483 | 44 |
2178530 | 2178530 | 2022-02-03 | McLean | Kentucky | 21149 | 2475 | 44 |
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);