ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Green" and fips = 21087 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2337849 | 2337849 | 2022-03-24 | Green | Kentucky | 21087 | 3668 | 40 |
2334595 | 2334595 | 2022-03-23 | Green | Kentucky | 21087 | 3668 | 40 |
2331341 | 2331341 | 2022-03-22 | Green | Kentucky | 21087 | 3668 | 40 |
2328089 | 2328089 | 2022-03-21 | Green | Kentucky | 21087 | 3668 | 40 |
2324836 | 2324836 | 2022-03-20 | Green | Kentucky | 21087 | 3602 | 40 |
2321582 | 2321582 | 2022-03-19 | Green | Kentucky | 21087 | 3602 | 40 |
2318328 | 2318328 | 2022-03-18 | Green | Kentucky | 21087 | 3602 | 40 |
2315075 | 2315075 | 2022-03-17 | Green | Kentucky | 21087 | 3602 | 40 |
2311822 | 2311822 | 2022-03-16 | Green | Kentucky | 21087 | 3602 | 40 |
2308569 | 2308569 | 2022-03-15 | Green | Kentucky | 21087 | 3602 | 40 |
2305318 | 2305318 | 2022-03-14 | Green | Kentucky | 21087 | 3602 | 40 |
2302066 | 2302066 | 2022-03-13 | Green | Kentucky | 21087 | 3540 | 40 |
2298814 | 2298814 | 2022-03-12 | Green | Kentucky | 21087 | 3540 | 40 |
2295562 | 2295562 | 2022-03-11 | Green | Kentucky | 21087 | 3540 | 40 |
2292310 | 2292310 | 2022-03-10 | Green | Kentucky | 21087 | 3540 | 40 |
2289058 | 2289058 | 2022-03-09 | Green | Kentucky | 21087 | 3540 | 40 |
2285807 | 2285807 | 2022-03-08 | Green | Kentucky | 21087 | 3540 | 40 |
2282555 | 2282555 | 2022-03-07 | Green | Kentucky | 21087 | 3540 | 40 |
2279302 | 2279302 | 2022-03-06 | Green | Kentucky | 21087 | 3526 | 40 |
2276049 | 2276049 | 2022-03-05 | Green | Kentucky | 21087 | 3526 | 40 |
2272796 | 2272796 | 2022-03-04 | Green | Kentucky | 21087 | 3526 | 40 |
2269544 | 2269544 | 2022-03-03 | Green | Kentucky | 21087 | 3509 | 40 |
2266291 | 2266291 | 2022-03-02 | Green | Kentucky | 21087 | 3499 | 40 |
2263040 | 2263040 | 2022-03-01 | Green | Kentucky | 21087 | 3484 | 40 |
2259789 | 2259789 | 2022-02-28 | Green | Kentucky | 21087 | 3470 | 40 |
2256538 | 2256538 | 2022-02-27 | Green | Kentucky | 21087 | 3456 | 40 |
2253287 | 2253287 | 2022-02-26 | Green | Kentucky | 21087 | 3456 | 40 |
2250036 | 2250036 | 2022-02-25 | Green | Kentucky | 21087 | 3456 | 40 |
2246785 | 2246785 | 2022-02-24 | Green | Kentucky | 21087 | 3452 | 40 |
2243534 | 2243534 | 2022-02-23 | Green | Kentucky | 21087 | 3452 | 40 |
2240283 | 2240283 | 2022-02-22 | Green | Kentucky | 21087 | 3444 | 40 |
2237032 | 2237032 | 2022-02-21 | Green | Kentucky | 21087 | 3437 | 40 |
2233781 | 2233781 | 2022-02-20 | Green | Kentucky | 21087 | 3419 | 40 |
2230530 | 2230530 | 2022-02-19 | Green | Kentucky | 21087 | 3419 | 40 |
2227279 | 2227279 | 2022-02-18 | Green | Kentucky | 21087 | 3419 | 40 |
2224028 | 2224028 | 2022-02-17 | Green | Kentucky | 21087 | 3404 | 40 |
2220777 | 2220777 | 2022-02-16 | Green | Kentucky | 21087 | 3387 | 40 |
2217526 | 2217526 | 2022-02-15 | Green | Kentucky | 21087 | 3369 | 40 |
2214275 | 2214275 | 2022-02-14 | Green | Kentucky | 21087 | 3369 | 40 |
2211023 | 2211023 | 2022-02-13 | Green | Kentucky | 21087 | 3309 | 40 |
2207770 | 2207770 | 2022-02-12 | Green | Kentucky | 21087 | 3309 | 40 |
2204517 | 2204517 | 2022-02-11 | Green | Kentucky | 21087 | 3309 | 40 |
2201264 | 2201264 | 2022-02-10 | Green | Kentucky | 21087 | 3293 | 40 |
2198010 | 2198010 | 2022-02-09 | Green | Kentucky | 21087 | 3284 | 40 |
2194756 | 2194756 | 2022-02-08 | Green | Kentucky | 21087 | 3263 | 40 |
2191502 | 2191502 | 2022-02-07 | Green | Kentucky | 21087 | 3252 | 40 |
2188249 | 2188249 | 2022-02-06 | Green | Kentucky | 21087 | 3241 | 40 |
2184996 | 2184996 | 2022-02-05 | Green | Kentucky | 21087 | 3241 | 40 |
2181744 | 2181744 | 2022-02-04 | Green | Kentucky | 21087 | 3241 | 40 |
2178493 | 2178493 | 2022-02-03 | Green | Kentucky | 21087 | 3219 | 40 |
2175240 | 2175240 | 2022-02-02 | Green | Kentucky | 21087 | 3195 | 40 |
2171987 | 2171987 | 2022-02-01 | Green | Kentucky | 21087 | 3157 | 40 |
2168734 | 2168734 | 2022-01-31 | Green | Kentucky | 21087 | 3138 | 40 |
2165479 | 2165479 | 2022-01-30 | Green | Kentucky | 21087 | 3082 | 40 |
2162224 | 2162224 | 2022-01-29 | Green | Kentucky | 21087 | 3082 | 40 |
2158969 | 2158969 | 2022-01-28 | Green | Kentucky | 21087 | 3082 | 40 |
2155715 | 2155715 | 2022-01-27 | Green | Kentucky | 21087 | 3055 | 40 |
2152462 | 2152462 | 2022-01-26 | Green | Kentucky | 21087 | 3036 | 40 |
2149210 | 2149210 | 2022-01-25 | Green | Kentucky | 21087 | 3003 | 40 |
2145958 | 2145958 | 2022-01-24 | Green | Kentucky | 21087 | 2985 | 40 |
2142703 | 2142703 | 2022-01-23 | Green | Kentucky | 21087 | 2919 | 40 |
2139448 | 2139448 | 2022-01-22 | Green | Kentucky | 21087 | 2919 | 40 |
2136192 | 2136192 | 2022-01-21 | Green | Kentucky | 21087 | 2919 | 40 |
2132940 | 2132940 | 2022-01-20 | Green | Kentucky | 21087 | 2888 | 40 |
2129687 | 2129687 | 2022-01-19 | Green | Kentucky | 21087 | 2872 | 40 |
2126433 | 2126433 | 2022-01-18 | Green | Kentucky | 21087 | 2848 | 40 |
2123181 | 2123181 | 2022-01-17 | Green | Kentucky | 21087 | 2803 | 40 |
2119929 | 2119929 | 2022-01-16 | Green | Kentucky | 21087 | 2803 | 40 |
2116677 | 2116677 | 2022-01-15 | Green | Kentucky | 21087 | 2803 | 40 |
2113426 | 2113426 | 2022-01-14 | Green | Kentucky | 21087 | 2803 | 40 |
2110174 | 2110174 | 2022-01-13 | Green | Kentucky | 21087 | 2789 | 40 |
2106923 | 2106923 | 2022-01-12 | Green | Kentucky | 21087 | 2766 | 40 |
2103672 | 2103672 | 2022-01-11 | Green | Kentucky | 21087 | 2747 | 40 |
2100421 | 2100421 | 2022-01-10 | Green | Kentucky | 21087 | 2744 | 40 |
2097170 | 2097170 | 2022-01-09 | Green | Kentucky | 21087 | 2732 | 40 |
2093918 | 2093918 | 2022-01-08 | Green | Kentucky | 21087 | 2732 | 40 |
2090666 | 2090666 | 2022-01-07 | Green | Kentucky | 21087 | 2732 | 40 |
2087415 | 2087415 | 2022-01-06 | Green | Kentucky | 21087 | 2719 | 40 |
2084163 | 2084163 | 2022-01-05 | Green | Kentucky | 21087 | 2705 | 39 |
2080911 | 2080911 | 2022-01-04 | Green | Kentucky | 21087 | 2691 | 39 |
2077659 | 2077659 | 2022-01-03 | Green | Kentucky | 21087 | 2687 | 39 |
2074408 | 2074408 | 2022-01-02 | Green | Kentucky | 21087 | 2674 | 39 |
2071157 | 2071157 | 2022-01-01 | Green | Kentucky | 21087 | 2674 | 39 |
2067906 | 2067906 | 2021-12-31 | Green | Kentucky | 21087 | 2674 | 39 |
2064655 | 2064655 | 2021-12-30 | Green | Kentucky | 21087 | 2674 | 39 |
2061405 | 2061405 | 2021-12-29 | Green | Kentucky | 21087 | 2668 | 39 |
2058156 | 2058156 | 2021-12-28 | Green | Kentucky | 21087 | 2656 | 39 |
2054907 | 2054907 | 2021-12-27 | Green | Kentucky | 21087 | 2647 | 39 |
2051657 | 2051657 | 2021-12-26 | Green | Kentucky | 21087 | 2642 | 39 |
2048407 | 2048407 | 2021-12-25 | Green | Kentucky | 21087 | 2642 | 39 |
2045157 | 2045157 | 2021-12-24 | Green | Kentucky | 21087 | 2642 | 39 |
2041908 | 2041908 | 2021-12-23 | Green | Kentucky | 21087 | 2642 | 39 |
2038658 | 2038658 | 2021-12-22 | Green | Kentucky | 21087 | 2629 | 39 |
2035408 | 2035408 | 2021-12-21 | Green | Kentucky | 21087 | 2629 | 39 |
2032158 | 2032158 | 2021-12-20 | Green | Kentucky | 21087 | 2627 | 38 |
2028907 | 2028907 | 2021-12-19 | Green | Kentucky | 21087 | 2626 | 38 |
2025656 | 2025656 | 2021-12-18 | Green | Kentucky | 21087 | 2626 | 38 |
2022405 | 2022405 | 2021-12-17 | Green | Kentucky | 21087 | 2626 | 38 |
2019154 | 2019154 | 2021-12-16 | Green | Kentucky | 21087 | 2615 | 38 |
2015904 | 2015904 | 2021-12-15 | Green | Kentucky | 21087 | 2615 | 38 |
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);