ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
206 rows where deaths = 86 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 |
---|---|---|---|---|---|---|---|
2499584 | 2499584 | 2022-05-13 | Cherokee | Alabama | 1019 | 5131 | 86 |
2496326 | 2496326 | 2022-05-12 | Cherokee | Alabama | 1019 | 5131 | 86 |
2493068 | 2493068 | 2022-05-11 | Cherokee | Alabama | 1019 | 5134 | 86 |
2489810 | 2489810 | 2022-05-10 | Cherokee | Alabama | 1019 | 5130 | 86 |
2486553 | 2486553 | 2022-05-09 | Cherokee | Alabama | 1019 | 5128 | 86 |
2483295 | 2483295 | 2022-05-08 | Cherokee | Alabama | 1019 | 5127 | 86 |
2480037 | 2480037 | 2022-05-07 | Cherokee | Alabama | 1019 | 5127 | 86 |
2476779 | 2476779 | 2022-05-06 | Cherokee | Alabama | 1019 | 5127 | 86 |
2473521 | 2473521 | 2022-05-05 | Cherokee | Alabama | 1019 | 5126 | 86 |
2470264 | 2470264 | 2022-05-04 | Cherokee | Alabama | 1019 | 5126 | 86 |
2467008 | 2467008 | 2022-05-03 | Cherokee | Alabama | 1019 | 5126 | 86 |
2463753 | 2463753 | 2022-05-02 | Cherokee | Alabama | 1019 | 5125 | 86 |
2460497 | 2460497 | 2022-05-01 | Cherokee | Alabama | 1019 | 5126 | 86 |
2457241 | 2457241 | 2022-04-30 | Cherokee | Alabama | 1019 | 5126 | 86 |
2453985 | 2453985 | 2022-04-29 | Cherokee | Alabama | 1019 | 5126 | 86 |
2450729 | 2450729 | 2022-04-28 | Cherokee | Alabama | 1019 | 5126 | 86 |
2447473 | 2447473 | 2022-04-27 | Cherokee | Alabama | 1019 | 5125 | 86 |
2444217 | 2444217 | 2022-04-26 | Cherokee | Alabama | 1019 | 5125 | 86 |
2440961 | 2440961 | 2022-04-25 | Cherokee | Alabama | 1019 | 5124 | 86 |
2437705 | 2437705 | 2022-04-24 | Cherokee | Alabama | 1019 | 5124 | 86 |
2434449 | 2434449 | 2022-04-23 | Cherokee | Alabama | 1019 | 5124 | 86 |
2431193 | 2431193 | 2022-04-22 | Cherokee | Alabama | 1019 | 5124 | 86 |
2427937 | 2427937 | 2022-04-21 | Cherokee | Alabama | 1019 | 5124 | 86 |
2424681 | 2424681 | 2022-04-20 | Cherokee | Alabama | 1019 | 5124 | 86 |
2421425 | 2421425 | 2022-04-19 | Cherokee | Alabama | 1019 | 5122 | 86 |
2418169 | 2418169 | 2022-04-18 | Cherokee | Alabama | 1019 | 5120 | 86 |
2414913 | 2414913 | 2022-04-17 | Cherokee | Alabama | 1019 | 5120 | 86 |
2411657 | 2411657 | 2022-04-16 | Cherokee | Alabama | 1019 | 5120 | 86 |
2408401 | 2408401 | 2022-04-15 | Cherokee | Alabama | 1019 | 5120 | 86 |
2405145 | 2405145 | 2022-04-14 | Cherokee | Alabama | 1019 | 5118 | 86 |
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 |
2239258 | 2239258 | 2022-02-22 | Crenshaw | Alabama | 1041 | 3765 | 86 |
2236007 | 2236007 | 2022-02-21 | Crenshaw | Alabama | 1041 | 3763 | 86 |
2232756 | 2232756 | 2022-02-20 | Crenshaw | Alabama | 1041 | 3763 | 86 |
2229505 | 2229505 | 2022-02-19 | Crenshaw | Alabama | 1041 | 3762 | 86 |
2226254 | 2226254 | 2022-02-18 | Crenshaw | Alabama | 1041 | 3763 | 86 |
2223003 | 2223003 | 2022-02-17 | Crenshaw | Alabama | 1041 | 3760 | 86 |
2219752 | 2219752 | 2022-02-16 | Crenshaw | Alabama | 1041 | 3755 | 86 |
2167717 | 2167717 | 2022-01-31 | Fayette | Alabama | 1057 | 4380 | 86 |
2164462 | 2164462 | 2022-01-30 | Fayette | Alabama | 1057 | 4363 | 86 |
2161207 | 2161207 | 2022-01-29 | Fayette | Alabama | 1057 | 4354 | 86 |
2157951 | 2157951 | 2022-01-28 | Fayette | Alabama | 1057 | 4161 | 86 |
2154698 | 2154698 | 2022-01-27 | Fayette | Alabama | 1057 | 4161 | 86 |
2151445 | 2151445 | 2022-01-26 | Fayette | Alabama | 1057 | 4161 | 86 |
2148193 | 2148193 | 2022-01-25 | Fayette | Alabama | 1057 | 4161 | 86 |
2144941 | 2144941 | 2022-01-24 | Fayette | Alabama | 1057 | 4161 | 86 |
2141686 | 2141686 | 2022-01-23 | Fayette | Alabama | 1057 | 4144 | 86 |
2138430 | 2138430 | 2022-01-22 | Fayette | Alabama | 1057 | 4117 | 86 |
2135175 | 2135175 | 2022-01-21 | Fayette | Alabama | 1057 | 4036 | 86 |
2131923 | 2131923 | 2022-01-20 | Fayette | Alabama | 1057 | 3968 | 86 |
2128669 | 2128669 | 2022-01-19 | Fayette | Alabama | 1057 | 3905 | 86 |
2125416 | 2125416 | 2022-01-18 | Fayette | Alabama | 1057 | 3826 | 86 |
2122164 | 2122164 | 2022-01-17 | Fayette | Alabama | 1057 | 3810 | 86 |
2118912 | 2118912 | 2022-01-16 | Fayette | Alabama | 1057 | 3782 | 86 |
2115660 | 2115660 | 2022-01-15 | Fayette | Alabama | 1057 | 3630 | 86 |
2112408 | 2112408 | 2022-01-14 | Fayette | Alabama | 1057 | 3630 | 86 |
2109156 | 2109156 | 2022-01-13 | Fayette | Alabama | 1057 | 3630 | 86 |
2105905 | 2105905 | 2022-01-12 | Fayette | Alabama | 1057 | 3630 | 86 |
2102654 | 2102654 | 2022-01-11 | Fayette | Alabama | 1057 | 3605 | 86 |
2099403 | 2099403 | 2022-01-10 | Fayette | Alabama | 1057 | 3575 | 86 |
2096152 | 2096152 | 2022-01-09 | Fayette | Alabama | 1057 | 3555 | 86 |
2092900 | 2092900 | 2022-01-08 | Fayette | Alabama | 1057 | 3539 | 86 |
2089648 | 2089648 | 2022-01-07 | Fayette | Alabama | 1057 | 3522 | 86 |
2086397 | 2086397 | 2022-01-06 | Fayette | Alabama | 1057 | 3497 | 86 |
2083145 | 2083145 | 2022-01-05 | Fayette | Alabama | 1057 | 3478 | 86 |
2079893 | 2079893 | 2022-01-04 | Fayette | Alabama | 1057 | 3458 | 86 |
2076641 | 2076641 | 2022-01-03 | Fayette | Alabama | 1057 | 3446 | 86 |
2073390 | 2073390 | 2022-01-02 | Fayette | Alabama | 1057 | 3440 | 86 |
2070139 | 2070139 | 2022-01-01 | Fayette | Alabama | 1057 | 3417 | 86 |
2066888 | 2066888 | 2021-12-31 | Fayette | Alabama | 1057 | 3417 | 86 |
2063638 | 2063638 | 2021-12-30 | Fayette | Alabama | 1057 | 3407 | 86 |
2060388 | 2060388 | 2021-12-29 | Fayette | Alabama | 1057 | 3395 | 86 |
2057139 | 2057139 | 2021-12-28 | Fayette | Alabama | 1057 | 3392 | 86 |
2053890 | 2053890 | 2021-12-27 | Fayette | Alabama | 1057 | 3387 | 86 |
2050640 | 2050640 | 2021-12-26 | Fayette | Alabama | 1057 | 3387 | 86 |
2047390 | 2047390 | 2021-12-25 | Fayette | Alabama | 1057 | 3385 | 86 |
2044140 | 2044140 | 2021-12-24 | Fayette | Alabama | 1057 | 3383 | 86 |
2040891 | 2040891 | 2021-12-23 | Fayette | Alabama | 1057 | 3380 | 86 |
2037641 | 2037641 | 2021-12-22 | Fayette | Alabama | 1057 | 3375 | 86 |
2034391 | 2034391 | 2021-12-21 | Fayette | Alabama | 1057 | 3363 | 86 |
2031141 | 2031141 | 2021-12-20 | Fayette | Alabama | 1057 | 3363 | 86 |
2027890 | 2027890 | 2021-12-19 | Fayette | Alabama | 1057 | 3363 | 86 |
2024639 | 2024639 | 2021-12-18 | Fayette | Alabama | 1057 | 3362 | 86 |
2021388 | 2021388 | 2021-12-17 | Fayette | Alabama | 1057 | 3361 | 86 |
2018137 | 2018137 | 2021-12-16 | Fayette | Alabama | 1057 | 3350 | 86 |
2014887 | 2014887 | 2021-12-15 | Fayette | Alabama | 1057 | 3347 | 86 |
2011636 | 2011636 | 2021-12-14 | Fayette | Alabama | 1057 | 3345 | 86 |
2008369 | 2008369 | 2021-12-13 | Clarke | Alabama | 1025 | 4865 | 86 |
2005118 | 2005118 | 2021-12-12 | Clarke | Alabama | 1025 | 4865 | 86 |
2001867 | 2001867 | 2021-12-11 | Clarke | Alabama | 1025 | 4865 | 86 |
1998617 | 1998617 | 2021-12-10 | Clarke | Alabama | 1025 | 4864 | 86 |
1995366 | 1995366 | 2021-12-09 | Clarke | Alabama | 1025 | 4864 | 86 |
1992115 | 1992115 | 2021-12-08 | Clarke | Alabama | 1025 | 4862 | 86 |
1988864 | 1988864 | 2021-12-07 | Clarke | Alabama | 1025 | 4859 | 86 |
1985614 | 1985614 | 2021-12-06 | Clarke | Alabama | 1025 | 4860 | 86 |
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);