ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
104 rows where deaths = 129 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 |
---|---|---|---|---|---|---|---|
2499581 | 2499581 | 2022-05-13 | Butler | Alabama | 1013 | 5068 | 129 |
2496323 | 2496323 | 2022-05-12 | Butler | Alabama | 1013 | 5068 | 129 |
2493065 | 2493065 | 2022-05-11 | Butler | Alabama | 1013 | 5068 | 129 |
2489807 | 2489807 | 2022-05-10 | Butler | Alabama | 1013 | 5068 | 129 |
2486550 | 2486550 | 2022-05-09 | Butler | Alabama | 1013 | 5068 | 129 |
2483292 | 2483292 | 2022-05-08 | Butler | Alabama | 1013 | 5067 | 129 |
2480034 | 2480034 | 2022-05-07 | Butler | Alabama | 1013 | 5067 | 129 |
2476776 | 2476776 | 2022-05-06 | Butler | Alabama | 1013 | 5067 | 129 |
2473518 | 2473518 | 2022-05-05 | Butler | Alabama | 1013 | 5067 | 129 |
2470261 | 2470261 | 2022-05-04 | Butler | Alabama | 1013 | 5067 | 129 |
2467005 | 2467005 | 2022-05-03 | Butler | Alabama | 1013 | 5066 | 129 |
2463750 | 2463750 | 2022-05-02 | Butler | Alabama | 1013 | 5066 | 129 |
2460494 | 2460494 | 2022-05-01 | Butler | Alabama | 1013 | 5064 | 129 |
2457238 | 2457238 | 2022-04-30 | Butler | Alabama | 1013 | 5064 | 129 |
2453982 | 2453982 | 2022-04-29 | Butler | Alabama | 1013 | 5064 | 129 |
2450726 | 2450726 | 2022-04-28 | Butler | Alabama | 1013 | 5064 | 129 |
2447470 | 2447470 | 2022-04-27 | Butler | Alabama | 1013 | 5064 | 129 |
2444214 | 2444214 | 2022-04-26 | Butler | Alabama | 1013 | 5064 | 129 |
2440958 | 2440958 | 2022-04-25 | Butler | Alabama | 1013 | 5063 | 129 |
2437702 | 2437702 | 2022-04-24 | Butler | Alabama | 1013 | 5063 | 129 |
2434446 | 2434446 | 2022-04-23 | Butler | Alabama | 1013 | 5063 | 129 |
2431190 | 2431190 | 2022-04-22 | Butler | Alabama | 1013 | 5063 | 129 |
2427934 | 2427934 | 2022-04-21 | Butler | Alabama | 1013 | 5061 | 129 |
2424678 | 2424678 | 2022-04-20 | Butler | Alabama | 1013 | 5059 | 129 |
2421422 | 2421422 | 2022-04-19 | Butler | Alabama | 1013 | 5059 | 129 |
2418166 | 2418166 | 2022-04-18 | Butler | Alabama | 1013 | 5056 | 129 |
2414910 | 2414910 | 2022-04-17 | Butler | Alabama | 1013 | 5056 | 129 |
2411654 | 2411654 | 2022-04-16 | Butler | Alabama | 1013 | 5056 | 129 |
2408398 | 2408398 | 2022-04-15 | Butler | Alabama | 1013 | 5056 | 129 |
2405142 | 2405142 | 2022-04-14 | Butler | Alabama | 1013 | 5055 | 129 |
2405202 | 2405202 | 2022-04-14 | Winston | Alabama | 1133 | 7563 | 129 |
2401887 | 2401887 | 2022-04-13 | Butler | Alabama | 1013 | 5054 | 129 |
2401947 | 2401947 | 2022-04-13 | Winston | Alabama | 1133 | 7565 | 129 |
2398632 | 2398632 | 2022-04-12 | Butler | Alabama | 1013 | 5052 | 129 |
2398692 | 2398692 | 2022-04-12 | Winston | Alabama | 1133 | 7565 | 129 |
2395377 | 2395377 | 2022-04-11 | Butler | Alabama | 1013 | 5052 | 129 |
2395437 | 2395437 | 2022-04-11 | Winston | Alabama | 1133 | 7566 | 129 |
2392121 | 2392121 | 2022-04-10 | Butler | Alabama | 1013 | 5052 | 129 |
2392181 | 2392181 | 2022-04-10 | Winston | Alabama | 1133 | 7566 | 129 |
2388865 | 2388865 | 2022-04-09 | Butler | Alabama | 1013 | 5052 | 129 |
2388925 | 2388925 | 2022-04-09 | Winston | Alabama | 1133 | 7566 | 129 |
2385610 | 2385610 | 2022-04-08 | Butler | Alabama | 1013 | 5052 | 129 |
2385670 | 2385670 | 2022-04-08 | Winston | Alabama | 1133 | 7566 | 129 |
2382355 | 2382355 | 2022-04-07 | Butler | Alabama | 1013 | 5052 | 129 |
2382415 | 2382415 | 2022-04-07 | Winston | Alabama | 1133 | 7568 | 129 |
2379100 | 2379100 | 2022-04-06 | Butler | Alabama | 1013 | 5052 | 129 |
2379160 | 2379160 | 2022-04-06 | Winston | Alabama | 1133 | 7572 | 129 |
2375906 | 2375906 | 2022-04-05 | Winston | Alabama | 1133 | 7572 | 129 |
2372654 | 2372654 | 2022-04-04 | Winston | Alabama | 1133 | 7573 | 129 |
2369401 | 2369401 | 2022-04-03 | Winston | Alabama | 1133 | 7572 | 129 |
2366148 | 2366148 | 2022-04-02 | Winston | Alabama | 1133 | 7572 | 129 |
2362895 | 2362895 | 2022-04-01 | Winston | Alabama | 1133 | 7572 | 129 |
2359641 | 2359641 | 2022-03-31 | Winston | Alabama | 1133 | 7570 | 129 |
2356387 | 2356387 | 2022-03-30 | Winston | Alabama | 1133 | 7570 | 129 |
2353134 | 2353134 | 2022-03-29 | Winston | Alabama | 1133 | 7570 | 129 |
2242518 | 2242518 | 2022-02-23 | Franklin | Alabama | 1059 | 9779 | 129 |
1966142 | 1966142 | 2021-11-30 | Lawrence | Alabama | 1079 | 4831 | 129 |
1962890 | 1962890 | 2021-11-29 | Lawrence | Alabama | 1079 | 4826 | 129 |
1959639 | 1959639 | 2021-11-28 | Lawrence | Alabama | 1079 | 4826 | 129 |
1956388 | 1956388 | 2021-11-27 | Lawrence | Alabama | 1079 | 4826 | 129 |
1953137 | 1953137 | 2021-11-26 | Lawrence | Alabama | 1079 | 4826 | 129 |
1949886 | 1949886 | 2021-11-25 | Lawrence | Alabama | 1079 | 4826 | 129 |
1946642 | 1946642 | 2021-11-24 | Marion | Alabama | 1093 | 5394 | 129 |
1943391 | 1943391 | 2021-11-23 | Marion | Alabama | 1093 | 5392 | 129 |
1940141 | 1940141 | 2021-11-22 | Marion | Alabama | 1093 | 5385 | 129 |
1936891 | 1936891 | 2021-11-21 | Marion | Alabama | 1093 | 5383 | 129 |
1933641 | 1933641 | 2021-11-20 | Marion | Alabama | 1093 | 5381 | 129 |
1930389 | 1930389 | 2021-11-19 | Marion | Alabama | 1093 | 5375 | 129 |
1927139 | 1927139 | 2021-11-18 | Marion | Alabama | 1093 | 5374 | 129 |
1884876 | 1884876 | 2021-11-05 | Geneva | Alabama | 1061 | 4605 | 129 |
1829636 | 1829636 | 2021-10-19 | Escambia | Alabama | 1053 | 6750 | 129 |
1725648 | 1725648 | 2021-09-17 | Chilton | Alabama | 1021 | 6215 | 129 |
1621712 | 1621712 | 2021-08-16 | Covington | Alabama | 1039 | 5209 | 129 |
1618464 | 1618464 | 2021-08-15 | Covington | Alabama | 1039 | 5204 | 129 |
1488551 | 1488551 | 2021-07-06 | Coffee | Alabama | 1031 | 5684 | 129 |
1485304 | 1485304 | 2021-07-05 | Coffee | Alabama | 1031 | 5684 | 129 |
1482058 | 1482058 | 2021-07-04 | Coffee | Alabama | 1031 | 5684 | 129 |
1478811 | 1478811 | 2021-07-03 | Coffee | Alabama | 1031 | 5684 | 129 |
1475565 | 1475565 | 2021-07-02 | Coffee | Alabama | 1031 | 5684 | 129 |
1202870 | 1202870 | 2021-04-09 | Colbert | Alabama | 1033 | 6199 | 129 |
1199622 | 1199622 | 2021-04-08 | Colbert | Alabama | 1033 | 6196 | 129 |
1196373 | 1196373 | 2021-04-07 | Colbert | Alabama | 1033 | 6193 | 129 |
1128167 | 1128167 | 2021-03-17 | Blount | Alabama | 1009 | 6371 | 129 |
1124921 | 1124921 | 2021-03-16 | Blount | Alabama | 1009 | 6361 | 129 |
1121675 | 1121675 | 2021-03-15 | Blount | Alabama | 1009 | 6353 | 129 |
1118428 | 1118428 | 2021-03-14 | Blount | Alabama | 1009 | 6291 | 129 |
1115181 | 1115181 | 2021-03-13 | Blount | Alabama | 1009 | 6288 | 129 |
1111935 | 1111935 | 2021-03-12 | Blount | Alabama | 1009 | 6282 | 129 |
1108689 | 1108689 | 2021-03-11 | Blount | Alabama | 1009 | 6274 | 129 |
1105443 | 1105443 | 2021-03-10 | Blount | Alabama | 1009 | 6260 | 129 |
1017865 | 1017865 | 2021-02-11 | Tallapoosa | Alabama | 1123 | 3387 | 129 |
949698 | 949698 | 2021-01-21 | Morgan | Alabama | 1103 | 12447 | 129 |
930208 | 930208 | 2021-01-15 | Houston | Alabama | 1069 | 8474 | 129 |
826330 | 826330 | 2020-12-14 | Calhoun | Alabama | 1015 | 7872 | 129 |
823083 | 823083 | 2020-12-13 | Calhoun | Alabama | 1015 | 7813 | 129 |
819837 | 819837 | 2020-12-12 | Calhoun | Alabama | 1015 | 7760 | 129 |
816591 | 816591 | 2020-12-11 | Calhoun | Alabama | 1015 | 7658 | 129 |
813345 | 813345 | 2020-12-10 | Calhoun | Alabama | 1015 | 7534 | 129 |
745232 | 745232 | 2020-11-19 | Madison | Alabama | 1089 | 11834 | 129 |
243295 | 243295 | 2020-06-16 | Mobile | Alabama | 1097 | 2790 | 129 |
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);