ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Coosa" and state = "Alabama" 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 |
---|---|---|---|---|---|---|---|
2499593 | 2499593 | 2022-05-13 | Coosa | Alabama | 1037 | 2977 | 58 |
2496335 | 2496335 | 2022-05-12 | Coosa | Alabama | 1037 | 2975 | 58 |
2493077 | 2493077 | 2022-05-11 | Coosa | Alabama | 1037 | 2974 | 58 |
2489819 | 2489819 | 2022-05-10 | Coosa | Alabama | 1037 | 2974 | 58 |
2486562 | 2486562 | 2022-05-09 | Coosa | Alabama | 1037 | 2971 | 58 |
2483304 | 2483304 | 2022-05-08 | Coosa | Alabama | 1037 | 2970 | 58 |
2480046 | 2480046 | 2022-05-07 | Coosa | Alabama | 1037 | 2970 | 58 |
2476788 | 2476788 | 2022-05-06 | Coosa | Alabama | 1037 | 2970 | 58 |
2473530 | 2473530 | 2022-05-05 | Coosa | Alabama | 1037 | 2970 | 58 |
2470273 | 2470273 | 2022-05-04 | Coosa | Alabama | 1037 | 2969 | 58 |
2467017 | 2467017 | 2022-05-03 | Coosa | Alabama | 1037 | 2969 | 58 |
2463762 | 2463762 | 2022-05-02 | Coosa | Alabama | 1037 | 2968 | 58 |
2460506 | 2460506 | 2022-05-01 | Coosa | Alabama | 1037 | 2968 | 58 |
2457250 | 2457250 | 2022-04-30 | Coosa | Alabama | 1037 | 2968 | 58 |
2453994 | 2453994 | 2022-04-29 | Coosa | Alabama | 1037 | 2968 | 58 |
2450738 | 2450738 | 2022-04-28 | Coosa | Alabama | 1037 | 2968 | 58 |
2447482 | 2447482 | 2022-04-27 | Coosa | Alabama | 1037 | 2968 | 58 |
2444226 | 2444226 | 2022-04-26 | Coosa | Alabama | 1037 | 2967 | 58 |
2440970 | 2440970 | 2022-04-25 | Coosa | Alabama | 1037 | 2966 | 58 |
2437714 | 2437714 | 2022-04-24 | Coosa | Alabama | 1037 | 2966 | 58 |
2434458 | 2434458 | 2022-04-23 | Coosa | Alabama | 1037 | 2966 | 58 |
2431202 | 2431202 | 2022-04-22 | Coosa | Alabama | 1037 | 2966 | 58 |
2427946 | 2427946 | 2022-04-21 | Coosa | Alabama | 1037 | 2965 | 58 |
2424690 | 2424690 | 2022-04-20 | Coosa | Alabama | 1037 | 2964 | 58 |
2421434 | 2421434 | 2022-04-19 | Coosa | Alabama | 1037 | 2964 | 58 |
2418178 | 2418178 | 2022-04-18 | Coosa | Alabama | 1037 | 2964 | 58 |
2414922 | 2414922 | 2022-04-17 | Coosa | Alabama | 1037 | 2964 | 58 |
2411666 | 2411666 | 2022-04-16 | Coosa | Alabama | 1037 | 2964 | 58 |
2408410 | 2408410 | 2022-04-15 | Coosa | Alabama | 1037 | 2964 | 58 |
2405154 | 2405154 | 2022-04-14 | Coosa | Alabama | 1037 | 2963 | 58 |
2401899 | 2401899 | 2022-04-13 | Coosa | Alabama | 1037 | 2962 | 58 |
2398644 | 2398644 | 2022-04-12 | Coosa | Alabama | 1037 | 2962 | 58 |
2395389 | 2395389 | 2022-04-11 | Coosa | Alabama | 1037 | 2959 | 58 |
2392133 | 2392133 | 2022-04-10 | Coosa | Alabama | 1037 | 2958 | 58 |
2388877 | 2388877 | 2022-04-09 | Coosa | Alabama | 1037 | 2958 | 58 |
2385622 | 2385622 | 2022-04-08 | Coosa | Alabama | 1037 | 2958 | 58 |
2382367 | 2382367 | 2022-04-07 | Coosa | Alabama | 1037 | 2958 | 58 |
2379112 | 2379112 | 2022-04-06 | Coosa | Alabama | 1037 | 2958 | 58 |
2375858 | 2375858 | 2022-04-05 | Coosa | Alabama | 1037 | 2957 | 58 |
2372606 | 2372606 | 2022-04-04 | Coosa | Alabama | 1037 | 2957 | 58 |
2369353 | 2369353 | 2022-04-03 | Coosa | Alabama | 1037 | 2954 | 58 |
2366100 | 2366100 | 2022-04-02 | Coosa | Alabama | 1037 | 2954 | 58 |
2362847 | 2362847 | 2022-04-01 | Coosa | Alabama | 1037 | 2954 | 58 |
2359593 | 2359593 | 2022-03-31 | Coosa | Alabama | 1037 | 2953 | 58 |
2356339 | 2356339 | 2022-03-30 | Coosa | Alabama | 1037 | 2953 | 58 |
2353086 | 2353086 | 2022-03-29 | Coosa | Alabama | 1037 | 2950 | 58 |
2349834 | 2349834 | 2022-03-28 | Coosa | Alabama | 1037 | 2950 | 58 |
2346581 | 2346581 | 2022-03-27 | Coosa | Alabama | 1037 | 2950 | 58 |
2343328 | 2343328 | 2022-03-26 | Coosa | Alabama | 1037 | 2950 | 58 |
2340075 | 2340075 | 2022-03-25 | Coosa | Alabama | 1037 | 2950 | 58 |
2336822 | 2336822 | 2022-03-24 | Coosa | Alabama | 1037 | 2950 | 58 |
2333568 | 2333568 | 2022-03-23 | Coosa | Alabama | 1037 | 2946 | 58 |
2330314 | 2330314 | 2022-03-22 | Coosa | Alabama | 1037 | 2946 | 58 |
2327062 | 2327062 | 2022-03-21 | Coosa | Alabama | 1037 | 2943 | 58 |
2323809 | 2323809 | 2022-03-20 | Coosa | Alabama | 1037 | 2943 | 58 |
2320555 | 2320555 | 2022-03-19 | Coosa | Alabama | 1037 | 2943 | 58 |
2317301 | 2317301 | 2022-03-18 | Coosa | Alabama | 1037 | 2943 | 58 |
2314048 | 2314048 | 2022-03-17 | Coosa | Alabama | 1037 | 2942 | 58 |
2310795 | 2310795 | 2022-03-16 | Coosa | Alabama | 1037 | 2939 | 57 |
2307542 | 2307542 | 2022-03-15 | Coosa | Alabama | 1037 | 2935 | 57 |
2304291 | 2304291 | 2022-03-14 | Coosa | Alabama | 1037 | 2934 | 56 |
2301039 | 2301039 | 2022-03-13 | Coosa | Alabama | 1037 | 2932 | 56 |
2297787 | 2297787 | 2022-03-12 | Coosa | Alabama | 1037 | 2932 | 56 |
2294535 | 2294535 | 2022-03-11 | Coosa | Alabama | 1037 | 2932 | 56 |
2291283 | 2291283 | 2022-03-10 | Coosa | Alabama | 1037 | 2931 | 56 |
2288031 | 2288031 | 2022-03-09 | Coosa | Alabama | 1037 | 2932 | 56 |
2284779 | 2284779 | 2022-03-08 | Coosa | Alabama | 1037 | 2929 | 55 |
2281527 | 2281527 | 2022-03-07 | Coosa | Alabama | 1037 | 2923 | 55 |
2278274 | 2278274 | 2022-03-06 | Coosa | Alabama | 1037 | 2921 | 55 |
2275021 | 2275021 | 2022-03-05 | Coosa | Alabama | 1037 | 2921 | 55 |
2271768 | 2271768 | 2022-03-04 | Coosa | Alabama | 1037 | 2921 | 55 |
2268516 | 2268516 | 2022-03-03 | Coosa | Alabama | 1037 | 2920 | 55 |
2265263 | 2265263 | 2022-03-02 | Coosa | Alabama | 1037 | 2920 | 54 |
2262013 | 2262013 | 2022-03-01 | Coosa | Alabama | 1037 | 2916 | 54 |
2258762 | 2258762 | 2022-02-28 | Coosa | Alabama | 1037 | 2913 | 54 |
2255511 | 2255511 | 2022-02-27 | Coosa | Alabama | 1037 | 2913 | 54 |
2252260 | 2252260 | 2022-02-26 | Coosa | Alabama | 1037 | 2913 | 54 |
2249009 | 2249009 | 2022-02-25 | Coosa | Alabama | 1037 | 2912 | 54 |
2245758 | 2245758 | 2022-02-24 | Coosa | Alabama | 1037 | 2906 | 54 |
2242507 | 2242507 | 2022-02-23 | Coosa | Alabama | 1037 | 2904 | 54 |
2239256 | 2239256 | 2022-02-22 | Coosa | Alabama | 1037 | 2897 | 54 |
2236005 | 2236005 | 2022-02-21 | Coosa | Alabama | 1037 | 2896 | 54 |
2232754 | 2232754 | 2022-02-20 | Coosa | Alabama | 1037 | 2894 | 54 |
2229503 | 2229503 | 2022-02-19 | Coosa | Alabama | 1037 | 2892 | 54 |
2226252 | 2226252 | 2022-02-18 | Coosa | Alabama | 1037 | 2892 | 54 |
2223001 | 2223001 | 2022-02-17 | Coosa | Alabama | 1037 | 2883 | 53 |
2219750 | 2219750 | 2022-02-16 | Coosa | Alabama | 1037 | 2875 | 53 |
2216500 | 2216500 | 2022-02-15 | Coosa | Alabama | 1037 | 2870 | 53 |
2213249 | 2213249 | 2022-02-14 | Coosa | Alabama | 1037 | 2864 | 53 |
2209996 | 2209996 | 2022-02-13 | Coosa | Alabama | 1037 | 2864 | 53 |
2206743 | 2206743 | 2022-02-12 | Coosa | Alabama | 1037 | 2863 | 53 |
2203490 | 2203490 | 2022-02-11 | Coosa | Alabama | 1037 | 2863 | 53 |
2200236 | 2200236 | 2022-02-10 | Coosa | Alabama | 1037 | 2857 | 53 |
2196982 | 2196982 | 2022-02-09 | Coosa | Alabama | 1037 | 2848 | 53 |
2193727 | 2193727 | 2022-02-08 | Coosa | Alabama | 1037 | 2840 | 53 |
2190474 | 2190474 | 2022-02-07 | Coosa | Alabama | 1037 | 2834 | 53 |
2187221 | 2187221 | 2022-02-06 | Coosa | Alabama | 1037 | 2817 | 53 |
2183968 | 2183968 | 2022-02-05 | Coosa | Alabama | 1037 | 2817 | 53 |
2180716 | 2180716 | 2022-02-04 | Coosa | Alabama | 1037 | 2816 | 53 |
2177465 | 2177465 | 2022-02-03 | Coosa | Alabama | 1037 | 2800 | 53 |
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);