ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 1113 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499631 | 2499631 | 2022-05-13 | Russell | Alabama | 1113 | 10112 | 93 |
2496373 | 2496373 | 2022-05-12 | Russell | Alabama | 1113 | 10111 | 93 |
2493115 | 2493115 | 2022-05-11 | Russell | Alabama | 1113 | 10109 | 93 |
2489857 | 2489857 | 2022-05-10 | Russell | Alabama | 1113 | 10109 | 93 |
2486600 | 2486600 | 2022-05-09 | Russell | Alabama | 1113 | 10106 | 93 |
2483342 | 2483342 | 2022-05-08 | Russell | Alabama | 1113 | 10101 | 93 |
2480084 | 2480084 | 2022-05-07 | Russell | Alabama | 1113 | 10101 | 93 |
2476826 | 2476826 | 2022-05-06 | Russell | Alabama | 1113 | 10101 | 93 |
2473568 | 2473568 | 2022-05-05 | Russell | Alabama | 1113 | 10099 | 93 |
2470311 | 2470311 | 2022-05-04 | Russell | Alabama | 1113 | 10089 | 93 |
2467055 | 2467055 | 2022-05-03 | Russell | Alabama | 1113 | 10088 | 93 |
2463800 | 2463800 | 2022-05-02 | Russell | Alabama | 1113 | 10088 | 93 |
2460544 | 2460544 | 2022-05-01 | Russell | Alabama | 1113 | 10086 | 93 |
2457288 | 2457288 | 2022-04-30 | Russell | Alabama | 1113 | 10086 | 93 |
2454032 | 2454032 | 2022-04-29 | Russell | Alabama | 1113 | 10086 | 93 |
2450776 | 2450776 | 2022-04-28 | Russell | Alabama | 1113 | 10085 | 93 |
2447520 | 2447520 | 2022-04-27 | Russell | Alabama | 1113 | 10083 | 93 |
2444264 | 2444264 | 2022-04-26 | Russell | Alabama | 1113 | 10083 | 92 |
2441008 | 2441008 | 2022-04-25 | Russell | Alabama | 1113 | 10081 | 92 |
2437752 | 2437752 | 2022-04-24 | Russell | Alabama | 1113 | 10070 | 92 |
2434496 | 2434496 | 2022-04-23 | Russell | Alabama | 1113 | 10070 | 92 |
2431240 | 2431240 | 2022-04-22 | Russell | Alabama | 1113 | 10070 | 92 |
2427984 | 2427984 | 2022-04-21 | Russell | Alabama | 1113 | 10067 | 91 |
2424728 | 2424728 | 2022-04-20 | Russell | Alabama | 1113 | 10064 | 91 |
2421472 | 2421472 | 2022-04-19 | Russell | Alabama | 1113 | 10064 | 91 |
2418216 | 2418216 | 2022-04-18 | Russell | Alabama | 1113 | 10062 | 91 |
2414960 | 2414960 | 2022-04-17 | Russell | Alabama | 1113 | 10062 | 91 |
2411704 | 2411704 | 2022-04-16 | Russell | Alabama | 1113 | 10062 | 91 |
2408448 | 2408448 | 2022-04-15 | Russell | Alabama | 1113 | 10062 | 91 |
2405192 | 2405192 | 2022-04-14 | Russell | Alabama | 1113 | 10060 | 91 |
2401937 | 2401937 | 2022-04-13 | Russell | Alabama | 1113 | 10058 | 91 |
2398682 | 2398682 | 2022-04-12 | Russell | Alabama | 1113 | 10057 | 91 |
2395427 | 2395427 | 2022-04-11 | Russell | Alabama | 1113 | 10057 | 89 |
2392171 | 2392171 | 2022-04-10 | Russell | Alabama | 1113 | 10051 | 89 |
2388915 | 2388915 | 2022-04-09 | Russell | Alabama | 1113 | 10051 | 89 |
2385660 | 2385660 | 2022-04-08 | Russell | Alabama | 1113 | 10051 | 89 |
2382405 | 2382405 | 2022-04-07 | Russell | Alabama | 1113 | 10050 | 89 |
2379150 | 2379150 | 2022-04-06 | Russell | Alabama | 1113 | 10050 | 89 |
2375896 | 2375896 | 2022-04-05 | Russell | Alabama | 1113 | 10049 | 88 |
2372644 | 2372644 | 2022-04-04 | Russell | Alabama | 1113 | 10042 | 88 |
2369391 | 2369391 | 2022-04-03 | Russell | Alabama | 1113 | 10040 | 88 |
2366138 | 2366138 | 2022-04-02 | Russell | Alabama | 1113 | 10040 | 88 |
2362885 | 2362885 | 2022-04-01 | Russell | Alabama | 1113 | 10040 | 88 |
2359631 | 2359631 | 2022-03-31 | Russell | Alabama | 1113 | 10039 | 87 |
2356377 | 2356377 | 2022-03-30 | Russell | Alabama | 1113 | 10037 | 87 |
2353124 | 2353124 | 2022-03-29 | Russell | Alabama | 1113 | 10037 | 87 |
2349872 | 2349872 | 2022-03-28 | Russell | Alabama | 1113 | 10034 | 87 |
2346619 | 2346619 | 2022-03-27 | Russell | Alabama | 1113 | 10029 | 86 |
2343366 | 2343366 | 2022-03-26 | Russell | Alabama | 1113 | 10029 | 86 |
2340113 | 2340113 | 2022-03-25 | Russell | Alabama | 1113 | 10029 | 86 |
2336860 | 2336860 | 2022-03-24 | Russell | Alabama | 1113 | 10026 | 86 |
2333606 | 2333606 | 2022-03-23 | Russell | Alabama | 1113 | 10025 | 86 |
2330352 | 2330352 | 2022-03-22 | Russell | Alabama | 1113 | 10023 | 86 |
2327100 | 2327100 | 2022-03-21 | Russell | Alabama | 1113 | 10021 | 84 |
2323847 | 2323847 | 2022-03-20 | Russell | Alabama | 1113 | 10019 | 84 |
2320593 | 2320593 | 2022-03-19 | Russell | Alabama | 1113 | 10019 | 84 |
2317339 | 2317339 | 2022-03-18 | Russell | Alabama | 1113 | 10019 | 84 |
2314086 | 2314086 | 2022-03-17 | Russell | Alabama | 1113 | 10018 | 84 |
2310833 | 2310833 | 2022-03-16 | Russell | Alabama | 1113 | 10018 | 84 |
2307580 | 2307580 | 2022-03-15 | Russell | Alabama | 1113 | 10018 | 84 |
2304329 | 2304329 | 2022-03-14 | Russell | Alabama | 1113 | 10017 | 84 |
2301077 | 2301077 | 2022-03-13 | Russell | Alabama | 1113 | 10018 | 84 |
2297825 | 2297825 | 2022-03-12 | Russell | Alabama | 1113 | 10018 | 84 |
2294573 | 2294573 | 2022-03-11 | Russell | Alabama | 1113 | 10018 | 84 |
2291321 | 2291321 | 2022-03-10 | Russell | Alabama | 1113 | 10015 | 84 |
2288069 | 2288069 | 2022-03-09 | Russell | Alabama | 1113 | 10012 | 83 |
2284817 | 2284817 | 2022-03-08 | Russell | Alabama | 1113 | 10011 | 82 |
2281565 | 2281565 | 2022-03-07 | Russell | Alabama | 1113 | 10010 | 82 |
2278312 | 2278312 | 2022-03-06 | Russell | Alabama | 1113 | 10001 | 81 |
2275059 | 2275059 | 2022-03-05 | Russell | Alabama | 1113 | 10001 | 81 |
2271806 | 2271806 | 2022-03-04 | Russell | Alabama | 1113 | 10001 | 81 |
2268554 | 2268554 | 2022-03-03 | Russell | Alabama | 1113 | 10000 | 81 |
2265301 | 2265301 | 2022-03-02 | Russell | Alabama | 1113 | 9999 | 79 |
2262051 | 2262051 | 2022-03-01 | Russell | Alabama | 1113 | 9992 | 79 |
2258800 | 2258800 | 2022-02-28 | Russell | Alabama | 1113 | 9988 | 79 |
2255549 | 2255549 | 2022-02-27 | Russell | Alabama | 1113 | 9985 | 79 |
2252298 | 2252298 | 2022-02-26 | Russell | Alabama | 1113 | 9979 | 79 |
2249047 | 2249047 | 2022-02-25 | Russell | Alabama | 1113 | 9978 | 78 |
2245796 | 2245796 | 2022-02-24 | Russell | Alabama | 1113 | 9973 | 78 |
2242545 | 2242545 | 2022-02-23 | Russell | Alabama | 1113 | 9969 | 78 |
2239294 | 2239294 | 2022-02-22 | Russell | Alabama | 1113 | 9959 | 78 |
2236043 | 2236043 | 2022-02-21 | Russell | Alabama | 1113 | 9954 | 78 |
2232792 | 2232792 | 2022-02-20 | Russell | Alabama | 1113 | 9952 | 78 |
2229541 | 2229541 | 2022-02-19 | Russell | Alabama | 1113 | 9949 | 78 |
2226290 | 2226290 | 2022-02-18 | Russell | Alabama | 1113 | 9941 | 78 |
2223039 | 2223039 | 2022-02-17 | Russell | Alabama | 1113 | 9935 | 77 |
2219788 | 2219788 | 2022-02-16 | Russell | Alabama | 1113 | 9930 | 77 |
2216538 | 2216538 | 2022-02-15 | Russell | Alabama | 1113 | 9914 | 75 |
2213287 | 2213287 | 2022-02-14 | Russell | Alabama | 1113 | 9902 | 75 |
2210034 | 2210034 | 2022-02-13 | Russell | Alabama | 1113 | 9893 | 75 |
2206781 | 2206781 | 2022-02-12 | Russell | Alabama | 1113 | 9880 | 75 |
2203528 | 2203528 | 2022-02-11 | Russell | Alabama | 1113 | 9720 | 75 |
2200274 | 2200274 | 2022-02-10 | Russell | Alabama | 1113 | 9701 | 75 |
2197020 | 2197020 | 2022-02-09 | Russell | Alabama | 1113 | 9691 | 75 |
2193765 | 2193765 | 2022-02-08 | Russell | Alabama | 1113 | 9675 | 74 |
2190512 | 2190512 | 2022-02-07 | Russell | Alabama | 1113 | 9653 | 74 |
2187259 | 2187259 | 2022-02-06 | Russell | Alabama | 1113 | 9618 | 74 |
2184006 | 2184006 | 2022-02-05 | Russell | Alabama | 1113 | 9618 | 74 |
2180754 | 2180754 | 2022-02-04 | Russell | Alabama | 1113 | 9601 | 74 |
2177503 | 2177503 | 2022-02-03 | Russell | Alabama | 1113 | 9549 | 71 |
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);