ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Coffee", fips = 1031 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 |
---|---|---|---|---|---|---|---|
2499590 | 2499590 | 2022-05-13 | Coffee | Alabama | 1031 | 13643 | 231 |
2496332 | 2496332 | 2022-05-12 | Coffee | Alabama | 1031 | 13638 | 231 |
2493074 | 2493074 | 2022-05-11 | Coffee | Alabama | 1031 | 13632 | 231 |
2489816 | 2489816 | 2022-05-10 | Coffee | Alabama | 1031 | 13632 | 231 |
2486559 | 2486559 | 2022-05-09 | Coffee | Alabama | 1031 | 13628 | 231 |
2483301 | 2483301 | 2022-05-08 | Coffee | Alabama | 1031 | 13615 | 231 |
2480043 | 2480043 | 2022-05-07 | Coffee | Alabama | 1031 | 13615 | 231 |
2476785 | 2476785 | 2022-05-06 | Coffee | Alabama | 1031 | 13615 | 231 |
2473527 | 2473527 | 2022-05-05 | Coffee | Alabama | 1031 | 13614 | 231 |
2470270 | 2470270 | 2022-05-04 | Coffee | Alabama | 1031 | 13608 | 231 |
2467014 | 2467014 | 2022-05-03 | Coffee | Alabama | 1031 | 13608 | 231 |
2463759 | 2463759 | 2022-05-02 | Coffee | Alabama | 1031 | 13603 | 231 |
2460503 | 2460503 | 2022-05-01 | Coffee | Alabama | 1031 | 13599 | 231 |
2457247 | 2457247 | 2022-04-30 | Coffee | Alabama | 1031 | 13599 | 231 |
2453991 | 2453991 | 2022-04-29 | Coffee | Alabama | 1031 | 13599 | 231 |
2450735 | 2450735 | 2022-04-28 | Coffee | Alabama | 1031 | 13596 | 231 |
2447479 | 2447479 | 2022-04-27 | Coffee | Alabama | 1031 | 13593 | 231 |
2444223 | 2444223 | 2022-04-26 | Coffee | Alabama | 1031 | 13591 | 231 |
2440967 | 2440967 | 2022-04-25 | Coffee | Alabama | 1031 | 13591 | 231 |
2437711 | 2437711 | 2022-04-24 | Coffee | Alabama | 1031 | 13588 | 231 |
2434455 | 2434455 | 2022-04-23 | Coffee | Alabama | 1031 | 13588 | 231 |
2431199 | 2431199 | 2022-04-22 | Coffee | Alabama | 1031 | 13588 | 231 |
2427943 | 2427943 | 2022-04-21 | Coffee | Alabama | 1031 | 13583 | 231 |
2424687 | 2424687 | 2022-04-20 | Coffee | Alabama | 1031 | 13579 | 231 |
2421431 | 2421431 | 2022-04-19 | Coffee | Alabama | 1031 | 13577 | 231 |
2418175 | 2418175 | 2022-04-18 | Coffee | Alabama | 1031 | 13576 | 231 |
2414919 | 2414919 | 2022-04-17 | Coffee | Alabama | 1031 | 13576 | 231 |
2411663 | 2411663 | 2022-04-16 | Coffee | Alabama | 1031 | 13576 | 231 |
2408407 | 2408407 | 2022-04-15 | Coffee | Alabama | 1031 | 13576 | 231 |
2405151 | 2405151 | 2022-04-14 | Coffee | Alabama | 1031 | 13572 | 231 |
2401896 | 2401896 | 2022-04-13 | Coffee | Alabama | 1031 | 13571 | 231 |
2398641 | 2398641 | 2022-04-12 | Coffee | Alabama | 1031 | 13567 | 231 |
2395386 | 2395386 | 2022-04-11 | Coffee | Alabama | 1031 | 13566 | 231 |
2392130 | 2392130 | 2022-04-10 | Coffee | Alabama | 1031 | 13566 | 231 |
2388874 | 2388874 | 2022-04-09 | Coffee | Alabama | 1031 | 13566 | 231 |
2385619 | 2385619 | 2022-04-08 | Coffee | Alabama | 1031 | 13566 | 231 |
2382364 | 2382364 | 2022-04-07 | Coffee | Alabama | 1031 | 13565 | 231 |
2379109 | 2379109 | 2022-04-06 | Coffee | Alabama | 1031 | 13564 | 231 |
2375855 | 2375855 | 2022-04-05 | Coffee | Alabama | 1031 | 13562 | 231 |
2372603 | 2372603 | 2022-04-04 | Coffee | Alabama | 1031 | 13560 | 231 |
2369350 | 2369350 | 2022-04-03 | Coffee | Alabama | 1031 | 13556 | 231 |
2366097 | 2366097 | 2022-04-02 | Coffee | Alabama | 1031 | 13556 | 231 |
2362844 | 2362844 | 2022-04-01 | Coffee | Alabama | 1031 | 13556 | 231 |
2359590 | 2359590 | 2022-03-31 | Coffee | Alabama | 1031 | 13556 | 231 |
2356336 | 2356336 | 2022-03-30 | Coffee | Alabama | 1031 | 13553 | 231 |
2353083 | 2353083 | 2022-03-29 | Coffee | Alabama | 1031 | 13551 | 231 |
2349831 | 2349831 | 2022-03-28 | Coffee | Alabama | 1031 | 13551 | 230 |
2346578 | 2346578 | 2022-03-27 | Coffee | Alabama | 1031 | 13344 | 230 |
2343325 | 2343325 | 2022-03-26 | Coffee | Alabama | 1031 | 13344 | 230 |
2340072 | 2340072 | 2022-03-25 | Coffee | Alabama | 1031 | 13344 | 230 |
2336819 | 2336819 | 2022-03-24 | Coffee | Alabama | 1031 | 13343 | 230 |
2333565 | 2333565 | 2022-03-23 | Coffee | Alabama | 1031 | 13338 | 230 |
2330311 | 2330311 | 2022-03-22 | Coffee | Alabama | 1031 | 13337 | 230 |
2327059 | 2327059 | 2022-03-21 | Coffee | Alabama | 1031 | 13337 | 230 |
2323806 | 2323806 | 2022-03-20 | Coffee | Alabama | 1031 | 13337 | 230 |
2320552 | 2320552 | 2022-03-19 | Coffee | Alabama | 1031 | 13337 | 230 |
2317298 | 2317298 | 2022-03-18 | Coffee | Alabama | 1031 | 13337 | 230 |
2314045 | 2314045 | 2022-03-17 | Coffee | Alabama | 1031 | 13337 | 230 |
2310792 | 2310792 | 2022-03-16 | Coffee | Alabama | 1031 | 13335 | 229 |
2307539 | 2307539 | 2022-03-15 | Coffee | Alabama | 1031 | 13333 | 229 |
2304288 | 2304288 | 2022-03-14 | Coffee | Alabama | 1031 | 13329 | 229 |
2301036 | 2301036 | 2022-03-13 | Coffee | Alabama | 1031 | 13330 | 228 |
2297784 | 2297784 | 2022-03-12 | Coffee | Alabama | 1031 | 13330 | 228 |
2294532 | 2294532 | 2022-03-11 | Coffee | Alabama | 1031 | 13330 | 228 |
2291280 | 2291280 | 2022-03-10 | Coffee | Alabama | 1031 | 13325 | 228 |
2288028 | 2288028 | 2022-03-09 | Coffee | Alabama | 1031 | 13325 | 228 |
2284776 | 2284776 | 2022-03-08 | Coffee | Alabama | 1031 | 13324 | 227 |
2281524 | 2281524 | 2022-03-07 | Coffee | Alabama | 1031 | 13321 | 226 |
2278271 | 2278271 | 2022-03-06 | Coffee | Alabama | 1031 | 13312 | 224 |
2275018 | 2275018 | 2022-03-05 | Coffee | Alabama | 1031 | 13312 | 224 |
2271765 | 2271765 | 2022-03-04 | Coffee | Alabama | 1031 | 13312 | 224 |
2268513 | 2268513 | 2022-03-03 | Coffee | Alabama | 1031 | 13310 | 222 |
2265260 | 2265260 | 2022-03-02 | Coffee | Alabama | 1031 | 13303 | 221 |
2262010 | 2262010 | 2022-03-01 | Coffee | Alabama | 1031 | 13301 | 221 |
2258759 | 2258759 | 2022-02-28 | Coffee | Alabama | 1031 | 13296 | 221 |
2255508 | 2255508 | 2022-02-27 | Coffee | Alabama | 1031 | 13295 | 221 |
2252257 | 2252257 | 2022-02-26 | Coffee | Alabama | 1031 | 13293 | 221 |
2249006 | 2249006 | 2022-02-25 | Coffee | Alabama | 1031 | 13290 | 221 |
2245755 | 2245755 | 2022-02-24 | Coffee | Alabama | 1031 | 13284 | 219 |
2242504 | 2242504 | 2022-02-23 | Coffee | Alabama | 1031 | 13279 | 216 |
2239253 | 2239253 | 2022-02-22 | Coffee | Alabama | 1031 | 13272 | 216 |
2236002 | 2236002 | 2022-02-21 | Coffee | Alabama | 1031 | 13266 | 216 |
2232751 | 2232751 | 2022-02-20 | Coffee | Alabama | 1031 | 13262 | 216 |
2229500 | 2229500 | 2022-02-19 | Coffee | Alabama | 1031 | 13259 | 216 |
2226249 | 2226249 | 2022-02-18 | Coffee | Alabama | 1031 | 13254 | 216 |
2222998 | 2222998 | 2022-02-17 | Coffee | Alabama | 1031 | 13249 | 215 |
2219747 | 2219747 | 2022-02-16 | Coffee | Alabama | 1031 | 13235 | 215 |
2216497 | 2216497 | 2022-02-15 | Coffee | Alabama | 1031 | 13222 | 215 |
2213246 | 2213246 | 2022-02-14 | Coffee | Alabama | 1031 | 13212 | 213 |
2209993 | 2209993 | 2022-02-13 | Coffee | Alabama | 1031 | 13206 | 213 |
2206740 | 2206740 | 2022-02-12 | Coffee | Alabama | 1031 | 13196 | 213 |
2203487 | 2203487 | 2022-02-11 | Coffee | Alabama | 1031 | 13180 | 213 |
2200233 | 2200233 | 2022-02-10 | Coffee | Alabama | 1031 | 13164 | 213 |
2196979 | 2196979 | 2022-02-09 | Coffee | Alabama | 1031 | 13141 | 212 |
2193724 | 2193724 | 2022-02-08 | Coffee | Alabama | 1031 | 13096 | 212 |
2190471 | 2190471 | 2022-02-07 | Coffee | Alabama | 1031 | 13040 | 212 |
2187218 | 2187218 | 2022-02-06 | Coffee | Alabama | 1031 | 13002 | 211 |
2183965 | 2183965 | 2022-02-05 | Coffee | Alabama | 1031 | 13002 | 211 |
2180713 | 2180713 | 2022-02-04 | Coffee | Alabama | 1031 | 12987 | 211 |
2177462 | 2177462 | 2022-02-03 | Coffee | Alabama | 1031 | 12905 | 208 |
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);