ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
171 rows where deaths = 84 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2493102 | 2493102 | 2022-05-11 | Macon | Alabama | 1087 | 3881 | 84 |
2489844 | 2489844 | 2022-05-10 | Macon | Alabama | 1087 | 3879 | 84 |
2486587 | 2486587 | 2022-05-09 | Macon | Alabama | 1087 | 3874 | 84 |
2483329 | 2483329 | 2022-05-08 | Macon | Alabama | 1087 | 3874 | 84 |
2480071 | 2480071 | 2022-05-07 | Macon | Alabama | 1087 | 3874 | 84 |
2476813 | 2476813 | 2022-05-06 | Macon | Alabama | 1087 | 3874 | 84 |
2473555 | 2473555 | 2022-05-05 | Macon | Alabama | 1087 | 3874 | 84 |
2470298 | 2470298 | 2022-05-04 | Macon | Alabama | 1087 | 3874 | 84 |
2467042 | 2467042 | 2022-05-03 | Macon | Alabama | 1087 | 3872 | 84 |
2463787 | 2463787 | 2022-05-02 | Macon | Alabama | 1087 | 3872 | 84 |
2460531 | 2460531 | 2022-05-01 | Macon | Alabama | 1087 | 3870 | 84 |
2457275 | 2457275 | 2022-04-30 | Macon | Alabama | 1087 | 3870 | 84 |
2454019 | 2454019 | 2022-04-29 | Macon | Alabama | 1087 | 3870 | 84 |
2450763 | 2450763 | 2022-04-28 | Macon | Alabama | 1087 | 3869 | 84 |
2447507 | 2447507 | 2022-04-27 | Macon | Alabama | 1087 | 3868 | 84 |
2444251 | 2444251 | 2022-04-26 | Macon | Alabama | 1087 | 3866 | 84 |
2440995 | 2440995 | 2022-04-25 | Macon | Alabama | 1087 | 3866 | 84 |
2437739 | 2437739 | 2022-04-24 | Macon | Alabama | 1087 | 3865 | 84 |
2434483 | 2434483 | 2022-04-23 | Macon | Alabama | 1087 | 3865 | 84 |
2431227 | 2431227 | 2022-04-22 | Macon | Alabama | 1087 | 3865 | 84 |
2427971 | 2427971 | 2022-04-21 | Macon | Alabama | 1087 | 3865 | 84 |
2424715 | 2424715 | 2022-04-20 | Macon | Alabama | 1087 | 3865 | 84 |
2421459 | 2421459 | 2022-04-19 | Macon | Alabama | 1087 | 3864 | 84 |
2418203 | 2418203 | 2022-04-18 | Macon | Alabama | 1087 | 3863 | 84 |
2414947 | 2414947 | 2022-04-17 | Macon | Alabama | 1087 | 3863 | 84 |
2411691 | 2411691 | 2022-04-16 | Macon | Alabama | 1087 | 3863 | 84 |
2408435 | 2408435 | 2022-04-15 | Macon | Alabama | 1087 | 3863 | 84 |
2405179 | 2405179 | 2022-04-14 | Macon | Alabama | 1087 | 3863 | 84 |
2327100 | 2327100 | 2022-03-21 | Russell | Alabama | 1113 | 10021 | 84 |
2323800 | 2323800 | 2022-03-20 | Cherokee | Alabama | 1019 | 5109 | 84 |
2323847 | 2323847 | 2022-03-20 | Russell | Alabama | 1113 | 10019 | 84 |
2320546 | 2320546 | 2022-03-19 | Cherokee | Alabama | 1019 | 5109 | 84 |
2320593 | 2320593 | 2022-03-19 | Russell | Alabama | 1113 | 10019 | 84 |
2317292 | 2317292 | 2022-03-18 | Cherokee | Alabama | 1019 | 5109 | 84 |
2317339 | 2317339 | 2022-03-18 | Russell | Alabama | 1113 | 10019 | 84 |
2314039 | 2314039 | 2022-03-17 | Cherokee | Alabama | 1019 | 5108 | 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 |
2213251 | 2213251 | 2022-02-14 | Crenshaw | Alabama | 1041 | 3744 | 84 |
2209998 | 2209998 | 2022-02-13 | Crenshaw | Alabama | 1041 | 3741 | 84 |
2206745 | 2206745 | 2022-02-12 | Crenshaw | Alabama | 1041 | 3741 | 84 |
2203492 | 2203492 | 2022-02-11 | Crenshaw | Alabama | 1041 | 3739 | 84 |
2200238 | 2200238 | 2022-02-10 | Crenshaw | Alabama | 1041 | 3727 | 84 |
2196984 | 2196984 | 2022-02-09 | Crenshaw | Alabama | 1041 | 3712 | 84 |
2193729 | 2193729 | 2022-02-08 | Crenshaw | Alabama | 1041 | 3696 | 84 |
2190476 | 2190476 | 2022-02-07 | Crenshaw | Alabama | 1041 | 3687 | 84 |
2187223 | 2187223 | 2022-02-06 | Crenshaw | Alabama | 1041 | 3679 | 84 |
2183970 | 2183970 | 2022-02-05 | Crenshaw | Alabama | 1041 | 3679 | 84 |
2180718 | 2180718 | 2022-02-04 | Crenshaw | Alabama | 1041 | 3673 | 84 |
2170944 | 2170944 | 2022-02-01 | Barbour | Alabama | 1005 | 5276 | 84 |
2167691 | 2167691 | 2022-01-31 | Barbour | Alabama | 1005 | 5263 | 84 |
2164436 | 2164436 | 2022-01-30 | Barbour | Alabama | 1005 | 5241 | 84 |
2161181 | 2161181 | 2022-01-29 | Barbour | Alabama | 1005 | 5224 | 84 |
1894624 | 1894624 | 2021-11-08 | Fayette | Alabama | 1057 | 3117 | 84 |
1891374 | 1891374 | 2021-11-07 | Fayette | Alabama | 1057 | 3116 | 84 |
1888124 | 1888124 | 2021-11-06 | Fayette | Alabama | 1057 | 3117 | 84 |
1884858 | 1884858 | 2021-11-05 | Clarke | Alabama | 1025 | 4809 | 84 |
1884899 | 1884899 | 2021-11-05 | Pickens | Alabama | 1107 | 3269 | 84 |
1881609 | 1881609 | 2021-11-04 | Clarke | Alabama | 1025 | 4815 | 84 |
1881650 | 1881650 | 2021-11-04 | Pickens | Alabama | 1107 | 3266 | 84 |
1878360 | 1878360 | 2021-11-03 | Clarke | Alabama | 1025 | 4784 | 84 |
1878401 | 1878401 | 2021-11-03 | Pickens | Alabama | 1107 | 3260 | 84 |
1875111 | 1875111 | 2021-11-02 | Clarke | Alabama | 1025 | 4782 | 84 |
1875152 | 1875152 | 2021-11-02 | Pickens | Alabama | 1107 | 3256 | 84 |
1871862 | 1871862 | 2021-11-01 | Clarke | Alabama | 1025 | 4778 | 84 |
1871903 | 1871903 | 2021-11-01 | Pickens | Alabama | 1107 | 3249 | 84 |
1868613 | 1868613 | 2021-10-31 | Clarke | Alabama | 1025 | 4778 | 84 |
1868654 | 1868654 | 2021-10-31 | Pickens | Alabama | 1107 | 3249 | 84 |
1865364 | 1865364 | 2021-10-30 | Clarke | Alabama | 1025 | 4777 | 84 |
1865405 | 1865405 | 2021-10-30 | Pickens | Alabama | 1107 | 3246 | 84 |
1862115 | 1862115 | 2021-10-29 | Clarke | Alabama | 1025 | 4777 | 84 |
1862156 | 1862156 | 2021-10-29 | Pickens | Alabama | 1107 | 3241 | 84 |
1858866 | 1858866 | 2021-10-28 | Clarke | Alabama | 1025 | 4776 | 84 |
1858907 | 1858907 | 2021-10-28 | Pickens | Alabama | 1107 | 3240 | 84 |
1855617 | 1855617 | 2021-10-27 | Clarke | Alabama | 1025 | 4776 | 84 |
1855658 | 1855658 | 2021-10-27 | Pickens | Alabama | 1107 | 3212 | 84 |
1852368 | 1852368 | 2021-10-26 | Clarke | Alabama | 1025 | 4772 | 84 |
1852409 | 1852409 | 2021-10-26 | Pickens | Alabama | 1107 | 3173 | 84 |
1849118 | 1849118 | 2021-10-25 | Clarke | Alabama | 1025 | 4758 | 84 |
1849159 | 1849159 | 2021-10-25 | Pickens | Alabama | 1107 | 3165 | 84 |
1845868 | 1845868 | 2021-10-24 | Clarke | Alabama | 1025 | 4757 | 84 |
1845909 | 1845909 | 2021-10-24 | Pickens | Alabama | 1107 | 3163 | 84 |
1842618 | 1842618 | 2021-10-23 | Clarke | Alabama | 1025 | 4755 | 84 |
1842659 | 1842659 | 2021-10-23 | Pickens | Alabama | 1107 | 3162 | 84 |
1839369 | 1839369 | 2021-10-22 | Clarke | Alabama | 1025 | 4754 | 84 |
1748417 | 1748417 | 2021-09-24 | Hale | Alabama | 1065 | 2915 | 84 |
1693212 | 1693212 | 2021-09-07 | Pike | Alabama | 1109 | 4152 | 84 |
1689963 | 1689963 | 2021-09-06 | Pike | Alabama | 1109 | 4140 | 84 |
1686713 | 1686713 | 2021-09-05 | Pike | Alabama | 1109 | 4133 | 84 |
1683463 | 1683463 | 2021-09-04 | Pike | Alabama | 1109 | 4109 | 84 |
1680212 | 1680212 | 2021-09-03 | Pike | Alabama | 1109 | 4082 | 84 |
1676964 | 1676964 | 2021-09-02 | Pike | Alabama | 1109 | 4054 | 84 |
1673717 | 1673717 | 2021-09-01 | Pike | Alabama | 1109 | 4019 | 84 |
1670469 | 1670469 | 2021-08-31 | Pike | Alabama | 1109 | 3989 | 84 |
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);