ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 1091 and state = "Alabama" 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 |
---|---|---|---|---|---|---|---|
2499620 | 2499620 | 2022-05-13 | Marengo | Alabama | 1091 | 5196 | 108 |
2496362 | 2496362 | 2022-05-12 | Marengo | Alabama | 1091 | 5195 | 108 |
2493104 | 2493104 | 2022-05-11 | Marengo | Alabama | 1091 | 5194 | 108 |
2489846 | 2489846 | 2022-05-10 | Marengo | Alabama | 1091 | 5193 | 108 |
2486589 | 2486589 | 2022-05-09 | Marengo | Alabama | 1091 | 5192 | 108 |
2483331 | 2483331 | 2022-05-08 | Marengo | Alabama | 1091 | 5191 | 108 |
2480073 | 2480073 | 2022-05-07 | Marengo | Alabama | 1091 | 5191 | 108 |
2476815 | 2476815 | 2022-05-06 | Marengo | Alabama | 1091 | 5191 | 108 |
2473557 | 2473557 | 2022-05-05 | Marengo | Alabama | 1091 | 5191 | 108 |
2470300 | 2470300 | 2022-05-04 | Marengo | Alabama | 1091 | 5190 | 108 |
2467044 | 2467044 | 2022-05-03 | Marengo | Alabama | 1091 | 5190 | 108 |
2463789 | 2463789 | 2022-05-02 | Marengo | Alabama | 1091 | 5190 | 108 |
2460533 | 2460533 | 2022-05-01 | Marengo | Alabama | 1091 | 5190 | 108 |
2457277 | 2457277 | 2022-04-30 | Marengo | Alabama | 1091 | 5190 | 108 |
2454021 | 2454021 | 2022-04-29 | Marengo | Alabama | 1091 | 5190 | 108 |
2450765 | 2450765 | 2022-04-28 | Marengo | Alabama | 1091 | 5190 | 108 |
2447509 | 2447509 | 2022-04-27 | Marengo | Alabama | 1091 | 5190 | 108 |
2444253 | 2444253 | 2022-04-26 | Marengo | Alabama | 1091 | 5190 | 108 |
2440997 | 2440997 | 2022-04-25 | Marengo | Alabama | 1091 | 5189 | 108 |
2437741 | 2437741 | 2022-04-24 | Marengo | Alabama | 1091 | 5188 | 108 |
2434485 | 2434485 | 2022-04-23 | Marengo | Alabama | 1091 | 5188 | 108 |
2431229 | 2431229 | 2022-04-22 | Marengo | Alabama | 1091 | 5188 | 108 |
2427973 | 2427973 | 2022-04-21 | Marengo | Alabama | 1091 | 5188 | 108 |
2424717 | 2424717 | 2022-04-20 | Marengo | Alabama | 1091 | 5188 | 108 |
2421461 | 2421461 | 2022-04-19 | Marengo | Alabama | 1091 | 5188 | 108 |
2418205 | 2418205 | 2022-04-18 | Marengo | Alabama | 1091 | 5187 | 108 |
2414949 | 2414949 | 2022-04-17 | Marengo | Alabama | 1091 | 5187 | 108 |
2411693 | 2411693 | 2022-04-16 | Marengo | Alabama | 1091 | 5187 | 108 |
2408437 | 2408437 | 2022-04-15 | Marengo | Alabama | 1091 | 5187 | 108 |
2405181 | 2405181 | 2022-04-14 | Marengo | Alabama | 1091 | 5185 | 108 |
2401926 | 2401926 | 2022-04-13 | Marengo | Alabama | 1091 | 5185 | 108 |
2398671 | 2398671 | 2022-04-12 | Marengo | Alabama | 1091 | 5185 | 108 |
2395416 | 2395416 | 2022-04-11 | Marengo | Alabama | 1091 | 5185 | 108 |
2392160 | 2392160 | 2022-04-10 | Marengo | Alabama | 1091 | 5185 | 108 |
2388904 | 2388904 | 2022-04-09 | Marengo | Alabama | 1091 | 5185 | 108 |
2385649 | 2385649 | 2022-04-08 | Marengo | Alabama | 1091 | 5185 | 108 |
2382394 | 2382394 | 2022-04-07 | Marengo | Alabama | 1091 | 5185 | 108 |
2379139 | 2379139 | 2022-04-06 | Marengo | Alabama | 1091 | 5184 | 108 |
2375885 | 2375885 | 2022-04-05 | Marengo | Alabama | 1091 | 5183 | 108 |
2372633 | 2372633 | 2022-04-04 | Marengo | Alabama | 1091 | 5182 | 108 |
2369380 | 2369380 | 2022-04-03 | Marengo | Alabama | 1091 | 5177 | 108 |
2366127 | 2366127 | 2022-04-02 | Marengo | Alabama | 1091 | 5177 | 108 |
2362874 | 2362874 | 2022-04-01 | Marengo | Alabama | 1091 | 5177 | 108 |
2359620 | 2359620 | 2022-03-31 | Marengo | Alabama | 1091 | 5176 | 108 |
2356366 | 2356366 | 2022-03-30 | Marengo | Alabama | 1091 | 5174 | 108 |
2353113 | 2353113 | 2022-03-29 | Marengo | Alabama | 1091 | 5174 | 108 |
2349861 | 2349861 | 2022-03-28 | Marengo | Alabama | 1091 | 5173 | 107 |
2346608 | 2346608 | 2022-03-27 | Marengo | Alabama | 1091 | 5169 | 107 |
2343355 | 2343355 | 2022-03-26 | Marengo | Alabama | 1091 | 5169 | 107 |
2340102 | 2340102 | 2022-03-25 | Marengo | Alabama | 1091 | 5169 | 107 |
2336849 | 2336849 | 2022-03-24 | Marengo | Alabama | 1091 | 5168 | 106 |
2333595 | 2333595 | 2022-03-23 | Marengo | Alabama | 1091 | 5166 | 106 |
2330341 | 2330341 | 2022-03-22 | Marengo | Alabama | 1091 | 5166 | 106 |
2327089 | 2327089 | 2022-03-21 | Marengo | Alabama | 1091 | 5165 | 106 |
2323836 | 2323836 | 2022-03-20 | Marengo | Alabama | 1091 | 5162 | 106 |
2320582 | 2320582 | 2022-03-19 | Marengo | Alabama | 1091 | 5162 | 106 |
2317328 | 2317328 | 2022-03-18 | Marengo | Alabama | 1091 | 5162 | 106 |
2314075 | 2314075 | 2022-03-17 | Marengo | Alabama | 1091 | 5161 | 104 |
2310822 | 2310822 | 2022-03-16 | Marengo | Alabama | 1091 | 5161 | 104 |
2307569 | 2307569 | 2022-03-15 | Marengo | Alabama | 1091 | 5160 | 104 |
2304318 | 2304318 | 2022-03-14 | Marengo | Alabama | 1091 | 5159 | 104 |
2301066 | 2301066 | 2022-03-13 | Marengo | Alabama | 1091 | 5157 | 104 |
2297814 | 2297814 | 2022-03-12 | Marengo | Alabama | 1091 | 5157 | 104 |
2294562 | 2294562 | 2022-03-11 | Marengo | Alabama | 1091 | 5157 | 104 |
2291310 | 2291310 | 2022-03-10 | Marengo | Alabama | 1091 | 5155 | 104 |
2288058 | 2288058 | 2022-03-09 | Marengo | Alabama | 1091 | 5155 | 104 |
2284806 | 2284806 | 2022-03-08 | Marengo | Alabama | 1091 | 5153 | 104 |
2281554 | 2281554 | 2022-03-07 | Marengo | Alabama | 1091 | 5153 | 103 |
2278301 | 2278301 | 2022-03-06 | Marengo | Alabama | 1091 | 5150 | 103 |
2275048 | 2275048 | 2022-03-05 | Marengo | Alabama | 1091 | 5150 | 103 |
2271795 | 2271795 | 2022-03-04 | Marengo | Alabama | 1091 | 5150 | 103 |
2268543 | 2268543 | 2022-03-03 | Marengo | Alabama | 1091 | 5150 | 103 |
2265290 | 2265290 | 2022-03-02 | Marengo | Alabama | 1091 | 5150 | 103 |
2262040 | 2262040 | 2022-03-01 | Marengo | Alabama | 1091 | 5150 | 103 |
2258789 | 2258789 | 2022-02-28 | Marengo | Alabama | 1091 | 5150 | 103 |
2255538 | 2255538 | 2022-02-27 | Marengo | Alabama | 1091 | 5150 | 103 |
2252287 | 2252287 | 2022-02-26 | Marengo | Alabama | 1091 | 5149 | 103 |
2249036 | 2249036 | 2022-02-25 | Marengo | Alabama | 1091 | 5145 | 103 |
2245785 | 2245785 | 2022-02-24 | Marengo | Alabama | 1091 | 5145 | 103 |
2242534 | 2242534 | 2022-02-23 | Marengo | Alabama | 1091 | 5142 | 103 |
2239283 | 2239283 | 2022-02-22 | Marengo | Alabama | 1091 | 5139 | 103 |
2236032 | 2236032 | 2022-02-21 | Marengo | Alabama | 1091 | 5132 | 103 |
2232781 | 2232781 | 2022-02-20 | Marengo | Alabama | 1091 | 5132 | 103 |
2229530 | 2229530 | 2022-02-19 | Marengo | Alabama | 1091 | 5129 | 103 |
2226279 | 2226279 | 2022-02-18 | Marengo | Alabama | 1091 | 5128 | 103 |
2223028 | 2223028 | 2022-02-17 | Marengo | Alabama | 1091 | 5100 | 101 |
2219777 | 2219777 | 2022-02-16 | Marengo | Alabama | 1091 | 5013 | 99 |
2216527 | 2216527 | 2022-02-15 | Marengo | Alabama | 1091 | 4858 | 97 |
2213276 | 2213276 | 2022-02-14 | Marengo | Alabama | 1091 | 4693 | 97 |
2210023 | 2210023 | 2022-02-13 | Marengo | Alabama | 1091 | 4693 | 97 |
2206770 | 2206770 | 2022-02-12 | Marengo | Alabama | 1091 | 4685 | 97 |
2203517 | 2203517 | 2022-02-11 | Marengo | Alabama | 1091 | 4647 | 97 |
2200263 | 2200263 | 2022-02-10 | Marengo | Alabama | 1091 | 4637 | 97 |
2197009 | 2197009 | 2022-02-09 | Marengo | Alabama | 1091 | 4632 | 97 |
2193754 | 2193754 | 2022-02-08 | Marengo | Alabama | 1091 | 4621 | 97 |
2190501 | 2190501 | 2022-02-07 | Marengo | Alabama | 1091 | 4613 | 97 |
2187248 | 2187248 | 2022-02-06 | Marengo | Alabama | 1091 | 4603 | 97 |
2183995 | 2183995 | 2022-02-05 | Marengo | Alabama | 1091 | 4603 | 97 |
2180743 | 2180743 | 2022-02-04 | Marengo | Alabama | 1091 | 4597 | 97 |
2177492 | 2177492 | 2022-02-03 | Marengo | Alabama | 1091 | 4563 | 96 |
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);