ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 21213 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500685 | 2500685 | 2022-05-13 | Simpson | Kentucky | 21213 | 5635 | 94 |
2497427 | 2497427 | 2022-05-12 | Simpson | Kentucky | 21213 | 5635 | 94 |
2494169 | 2494169 | 2022-05-11 | Simpson | Kentucky | 21213 | 5635 | 94 |
2490911 | 2490911 | 2022-05-10 | Simpson | Kentucky | 21213 | 5635 | 94 |
2487654 | 2487654 | 2022-05-09 | Simpson | Kentucky | 21213 | 5635 | 94 |
2484396 | 2484396 | 2022-05-08 | Simpson | Kentucky | 21213 | 5627 | 92 |
2481138 | 2481138 | 2022-05-07 | Simpson | Kentucky | 21213 | 5627 | 92 |
2477880 | 2477880 | 2022-05-06 | Simpson | Kentucky | 21213 | 5627 | 92 |
2474622 | 2474622 | 2022-05-05 | Simpson | Kentucky | 21213 | 5627 | 92 |
2471365 | 2471365 | 2022-05-04 | Simpson | Kentucky | 21213 | 5627 | 92 |
2468109 | 2468109 | 2022-05-03 | Simpson | Kentucky | 21213 | 5627 | 92 |
2464854 | 2464854 | 2022-05-02 | Simpson | Kentucky | 21213 | 5627 | 92 |
2461598 | 2461598 | 2022-05-01 | Simpson | Kentucky | 21213 | 5622 | 91 |
2458342 | 2458342 | 2022-04-30 | Simpson | Kentucky | 21213 | 5622 | 91 |
2455086 | 2455086 | 2022-04-29 | Simpson | Kentucky | 21213 | 5622 | 91 |
2451830 | 2451830 | 2022-04-28 | Simpson | Kentucky | 21213 | 5622 | 91 |
2448574 | 2448574 | 2022-04-27 | Simpson | Kentucky | 21213 | 5622 | 91 |
2445318 | 2445318 | 2022-04-26 | Simpson | Kentucky | 21213 | 5622 | 91 |
2442062 | 2442062 | 2022-04-25 | Simpson | Kentucky | 21213 | 5622 | 91 |
2438806 | 2438806 | 2022-04-24 | Simpson | Kentucky | 21213 | 5622 | 91 |
2435550 | 2435550 | 2022-04-23 | Simpson | Kentucky | 21213 | 5622 | 91 |
2432294 | 2432294 | 2022-04-22 | Simpson | Kentucky | 21213 | 5622 | 91 |
2429038 | 2429038 | 2022-04-21 | Simpson | Kentucky | 21213 | 5622 | 91 |
2425782 | 2425782 | 2022-04-20 | Simpson | Kentucky | 21213 | 5622 | 91 |
2422526 | 2422526 | 2022-04-19 | Simpson | Kentucky | 21213 | 5622 | 91 |
2419270 | 2419270 | 2022-04-18 | Simpson | Kentucky | 21213 | 5622 | 91 |
2416014 | 2416014 | 2022-04-17 | Simpson | Kentucky | 21213 | 5610 | 90 |
2412758 | 2412758 | 2022-04-16 | Simpson | Kentucky | 21213 | 5610 | 90 |
2409502 | 2409502 | 2022-04-15 | Simpson | Kentucky | 21213 | 5610 | 90 |
2406246 | 2406246 | 2022-04-14 | Simpson | Kentucky | 21213 | 5610 | 90 |
2402990 | 2402990 | 2022-04-13 | Simpson | Kentucky | 21213 | 5610 | 90 |
2399736 | 2399736 | 2022-04-12 | Simpson | Kentucky | 21213 | 5610 | 90 |
2396480 | 2396480 | 2022-04-11 | Simpson | Kentucky | 21213 | 5610 | 90 |
2393225 | 2393225 | 2022-04-10 | Simpson | Kentucky | 21213 | 5611 | 89 |
2389969 | 2389969 | 2022-04-09 | Simpson | Kentucky | 21213 | 5611 | 89 |
2386713 | 2386713 | 2022-04-08 | Simpson | Kentucky | 21213 | 5611 | 89 |
2383458 | 2383458 | 2022-04-07 | Simpson | Kentucky | 21213 | 5611 | 89 |
2380203 | 2380203 | 2022-04-06 | Simpson | Kentucky | 21213 | 5611 | 89 |
2376948 | 2376948 | 2022-04-05 | Simpson | Kentucky | 21213 | 5611 | 89 |
2373696 | 2373696 | 2022-04-04 | Simpson | Kentucky | 21213 | 5611 | 89 |
2370443 | 2370443 | 2022-04-03 | Simpson | Kentucky | 21213 | 5612 | 89 |
2367190 | 2367190 | 2022-04-02 | Simpson | Kentucky | 21213 | 5612 | 89 |
2363937 | 2363937 | 2022-04-01 | Simpson | Kentucky | 21213 | 5612 | 89 |
2360683 | 2360683 | 2022-03-31 | Simpson | Kentucky | 21213 | 5612 | 89 |
2357429 | 2357429 | 2022-03-30 | Simpson | Kentucky | 21213 | 5612 | 89 |
2354176 | 2354176 | 2022-03-29 | Simpson | Kentucky | 21213 | 5612 | 89 |
2350924 | 2350924 | 2022-03-28 | Simpson | Kentucky | 21213 | 5612 | 89 |
2347671 | 2347671 | 2022-03-27 | Simpson | Kentucky | 21213 | 5610 | 89 |
2344418 | 2344418 | 2022-03-26 | Simpson | Kentucky | 21213 | 5610 | 89 |
2341165 | 2341165 | 2022-03-25 | Simpson | Kentucky | 21213 | 5610 | 89 |
2337912 | 2337912 | 2022-03-24 | Simpson | Kentucky | 21213 | 5610 | 89 |
2334658 | 2334658 | 2022-03-23 | Simpson | Kentucky | 21213 | 5610 | 89 |
2331404 | 2331404 | 2022-03-22 | Simpson | Kentucky | 21213 | 5610 | 89 |
2328152 | 2328152 | 2022-03-21 | Simpson | Kentucky | 21213 | 5610 | 89 |
2324899 | 2324899 | 2022-03-20 | Simpson | Kentucky | 21213 | 5601 | 89 |
2321645 | 2321645 | 2022-03-19 | Simpson | Kentucky | 21213 | 5601 | 89 |
2318391 | 2318391 | 2022-03-18 | Simpson | Kentucky | 21213 | 5601 | 89 |
2315138 | 2315138 | 2022-03-17 | Simpson | Kentucky | 21213 | 5601 | 89 |
2311885 | 2311885 | 2022-03-16 | Simpson | Kentucky | 21213 | 5601 | 89 |
2308632 | 2308632 | 2022-03-15 | Simpson | Kentucky | 21213 | 5601 | 89 |
2305381 | 2305381 | 2022-03-14 | Simpson | Kentucky | 21213 | 5601 | 89 |
2302129 | 2302129 | 2022-03-13 | Simpson | Kentucky | 21213 | 5593 | 88 |
2298877 | 2298877 | 2022-03-12 | Simpson | Kentucky | 21213 | 5593 | 88 |
2295625 | 2295625 | 2022-03-11 | Simpson | Kentucky | 21213 | 5593 | 88 |
2292373 | 2292373 | 2022-03-10 | Simpson | Kentucky | 21213 | 5593 | 88 |
2289121 | 2289121 | 2022-03-09 | Simpson | Kentucky | 21213 | 5593 | 88 |
2285870 | 2285870 | 2022-03-08 | Simpson | Kentucky | 21213 | 5593 | 88 |
2282618 | 2282618 | 2022-03-07 | Simpson | Kentucky | 21213 | 5593 | 88 |
2279365 | 2279365 | 2022-03-06 | Simpson | Kentucky | 21213 | 5592 | 87 |
2276112 | 2276112 | 2022-03-05 | Simpson | Kentucky | 21213 | 5592 | 87 |
2272859 | 2272859 | 2022-03-04 | Simpson | Kentucky | 21213 | 5592 | 87 |
2269607 | 2269607 | 2022-03-03 | Simpson | Kentucky | 21213 | 5592 | 84 |
2266354 | 2266354 | 2022-03-02 | Simpson | Kentucky | 21213 | 5594 | 84 |
2263103 | 2263103 | 2022-03-01 | Simpson | Kentucky | 21213 | 5589 | 84 |
2259852 | 2259852 | 2022-02-28 | Simpson | Kentucky | 21213 | 5583 | 84 |
2256601 | 2256601 | 2022-02-27 | Simpson | Kentucky | 21213 | 5583 | 84 |
2253350 | 2253350 | 2022-02-26 | Simpson | Kentucky | 21213 | 5583 | 84 |
2250099 | 2250099 | 2022-02-25 | Simpson | Kentucky | 21213 | 5583 | 84 |
2246848 | 2246848 | 2022-02-24 | Simpson | Kentucky | 21213 | 5573 | 82 |
2243597 | 2243597 | 2022-02-23 | Simpson | Kentucky | 21213 | 5573 | 82 |
2240346 | 2240346 | 2022-02-22 | Simpson | Kentucky | 21213 | 5571 | 82 |
2237095 | 2237095 | 2022-02-21 | Simpson | Kentucky | 21213 | 5560 | 82 |
2233844 | 2233844 | 2022-02-20 | Simpson | Kentucky | 21213 | 5543 | 81 |
2230593 | 2230593 | 2022-02-19 | Simpson | Kentucky | 21213 | 5543 | 81 |
2227342 | 2227342 | 2022-02-18 | Simpson | Kentucky | 21213 | 5543 | 81 |
2224091 | 2224091 | 2022-02-17 | Simpson | Kentucky | 21213 | 5526 | 79 |
2220840 | 2220840 | 2022-02-16 | Simpson | Kentucky | 21213 | 5502 | 79 |
2217589 | 2217589 | 2022-02-15 | Simpson | Kentucky | 21213 | 5480 | 79 |
2214338 | 2214338 | 2022-02-14 | Simpson | Kentucky | 21213 | 5464 | 79 |
2211086 | 2211086 | 2022-02-13 | Simpson | Kentucky | 21213 | 5423 | 79 |
2207833 | 2207833 | 2022-02-12 | Simpson | Kentucky | 21213 | 5423 | 79 |
2204580 | 2204580 | 2022-02-11 | Simpson | Kentucky | 21213 | 5423 | 79 |
2201327 | 2201327 | 2022-02-10 | Simpson | Kentucky | 21213 | 5407 | 79 |
2198073 | 2198073 | 2022-02-09 | Simpson | Kentucky | 21213 | 5387 | 79 |
2194819 | 2194819 | 2022-02-08 | Simpson | Kentucky | 21213 | 5369 | 79 |
2191565 | 2191565 | 2022-02-07 | Simpson | Kentucky | 21213 | 5349 | 79 |
2188312 | 2188312 | 2022-02-06 | Simpson | Kentucky | 21213 | 5308 | 79 |
2185059 | 2185059 | 2022-02-05 | Simpson | Kentucky | 21213 | 5308 | 79 |
2181807 | 2181807 | 2022-02-04 | Simpson | Kentucky | 21213 | 5308 | 79 |
2178556 | 2178556 | 2022-02-03 | Simpson | Kentucky | 21213 | 5284 | 79 |
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);