ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
433 rows where deaths = 44 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Henry 65
- Randolph 60
- Bullock 47
- Greene 42
- Cleburne 23
- Perry 23
- Monroe 14
- Dale 13
- Elmore 11
- Calhoun 10
- Cherokee 10
- Crenshaw 9
- Wilcox 8
- Butler 7
- Limestone 7
- Lowndes 7
- Escambia 6
- Etowah 6
- Lawrence 6
- Sumter 6
- Autauga 5
- Dallas 4
- Hale 4
- Montgomery 4
- Tuscaloosa 4
- Chambers 3
- Lee 3
- Madison 3
- Pickens 3
- Winston 3
- …
state 1
- Alabama · 433 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2401933 | 2401933 | 2022-04-13 | Perry | Alabama | 1105 | 2092 | 44 |
2398678 | 2398678 | 2022-04-12 | Perry | Alabama | 1105 | 2092 | 44 |
2395423 | 2395423 | 2022-04-11 | Perry | Alabama | 1105 | 2092 | 44 |
2392167 | 2392167 | 2022-04-10 | Perry | Alabama | 1105 | 2092 | 44 |
2388911 | 2388911 | 2022-04-09 | Perry | Alabama | 1105 | 2092 | 44 |
2385656 | 2385656 | 2022-04-08 | Perry | Alabama | 1105 | 2092 | 44 |
2382401 | 2382401 | 2022-04-07 | Perry | Alabama | 1105 | 2092 | 44 |
2379146 | 2379146 | 2022-04-06 | Perry | Alabama | 1105 | 2091 | 44 |
2375892 | 2375892 | 2022-04-05 | Perry | Alabama | 1105 | 2091 | 44 |
2372640 | 2372640 | 2022-04-04 | Perry | Alabama | 1105 | 2091 | 44 |
2369387 | 2369387 | 2022-04-03 | Perry | Alabama | 1105 | 2091 | 44 |
2366134 | 2366134 | 2022-04-02 | Perry | Alabama | 1105 | 2091 | 44 |
2362881 | 2362881 | 2022-04-01 | Perry | Alabama | 1105 | 2091 | 44 |
2359627 | 2359627 | 2022-03-31 | Perry | Alabama | 1105 | 2091 | 44 |
2356373 | 2356373 | 2022-03-30 | Perry | Alabama | 1105 | 2091 | 44 |
2353120 | 2353120 | 2022-03-29 | Perry | Alabama | 1105 | 2091 | 44 |
2349868 | 2349868 | 2022-03-28 | Perry | Alabama | 1105 | 2091 | 44 |
2346615 | 2346615 | 2022-03-27 | Perry | Alabama | 1105 | 2091 | 44 |
2343362 | 2343362 | 2022-03-26 | Perry | Alabama | 1105 | 2091 | 44 |
2340109 | 2340109 | 2022-03-25 | Perry | Alabama | 1105 | 2091 | 44 |
2336856 | 2336856 | 2022-03-24 | Perry | Alabama | 1105 | 2091 | 44 |
2333602 | 2333602 | 2022-03-23 | Perry | Alabama | 1105 | 2091 | 44 |
2330348 | 2330348 | 2022-03-22 | Perry | Alabama | 1105 | 2090 | 44 |
2314095 | 2314095 | 2022-03-17 | Wilcox | Alabama | 1131 | 2871 | 44 |
2310842 | 2310842 | 2022-03-16 | Wilcox | Alabama | 1131 | 2871 | 44 |
2307589 | 2307589 | 2022-03-15 | Wilcox | Alabama | 1131 | 2869 | 44 |
2304338 | 2304338 | 2022-03-14 | Wilcox | Alabama | 1131 | 2869 | 44 |
2301086 | 2301086 | 2022-03-13 | Wilcox | Alabama | 1131 | 2869 | 44 |
2297834 | 2297834 | 2022-03-12 | Wilcox | Alabama | 1131 | 2869 | 44 |
2294582 | 2294582 | 2022-03-11 | Wilcox | Alabama | 1131 | 2869 | 44 |
2291330 | 2291330 | 2022-03-10 | Wilcox | Alabama | 1131 | 2869 | 44 |
2216541 | 2216541 | 2022-02-15 | Sumter | Alabama | 1119 | 2395 | 44 |
2213290 | 2213290 | 2022-02-14 | Sumter | Alabama | 1119 | 2370 | 44 |
2210037 | 2210037 | 2022-02-13 | Sumter | Alabama | 1119 | 2369 | 44 |
2206784 | 2206784 | 2022-02-12 | Sumter | Alabama | 1119 | 2366 | 44 |
2203531 | 2203531 | 2022-02-11 | Sumter | Alabama | 1119 | 2343 | 44 |
2200277 | 2200277 | 2022-02-10 | Sumter | Alabama | 1119 | 2337 | 44 |
1930361 | 1930361 | 2021-11-19 | Coosa | Alabama | 1037 | 1833 | 44 |
1920599 | 1920599 | 2021-11-16 | Bullock | Alabama | 1011 | 1524 | 44 |
1917349 | 1917349 | 2021-11-15 | Bullock | Alabama | 1011 | 1523 | 44 |
1914099 | 1914099 | 2021-11-14 | Bullock | Alabama | 1011 | 1523 | 44 |
1910849 | 1910849 | 2021-11-13 | Bullock | Alabama | 1011 | 1521 | 44 |
1907600 | 1907600 | 2021-11-12 | Bullock | Alabama | 1011 | 1520 | 44 |
1907626 | 1907626 | 2021-11-12 | Greene | Alabama | 1063 | 1293 | 44 |
1904351 | 1904351 | 2021-11-11 | Bullock | Alabama | 1011 | 1519 | 44 |
1904377 | 1904377 | 2021-11-11 | Greene | Alabama | 1063 | 1293 | 44 |
1901101 | 1901101 | 2021-11-10 | Bullock | Alabama | 1011 | 1519 | 44 |
1901127 | 1901127 | 2021-11-10 | Greene | Alabama | 1063 | 1288 | 44 |
1897851 | 1897851 | 2021-11-09 | Bullock | Alabama | 1011 | 1520 | 44 |
1897877 | 1897877 | 2021-11-09 | Greene | Alabama | 1063 | 1287 | 44 |
1894601 | 1894601 | 2021-11-08 | Bullock | Alabama | 1011 | 1525 | 44 |
1894627 | 1894627 | 2021-11-08 | Greene | Alabama | 1063 | 1284 | 44 |
1891351 | 1891351 | 2021-11-07 | Bullock | Alabama | 1011 | 1525 | 44 |
1891377 | 1891377 | 2021-11-07 | Greene | Alabama | 1063 | 1284 | 44 |
1888101 | 1888101 | 2021-11-06 | Bullock | Alabama | 1011 | 1524 | 44 |
1888127 | 1888127 | 2021-11-06 | Greene | Alabama | 1063 | 1284 | 44 |
1884851 | 1884851 | 2021-11-05 | Bullock | Alabama | 1011 | 1525 | 44 |
1884877 | 1884877 | 2021-11-05 | Greene | Alabama | 1063 | 1284 | 44 |
1881602 | 1881602 | 2021-11-04 | Bullock | Alabama | 1011 | 1524 | 44 |
1881628 | 1881628 | 2021-11-04 | Greene | Alabama | 1063 | 1284 | 44 |
1878353 | 1878353 | 2021-11-03 | Bullock | Alabama | 1011 | 1524 | 44 |
1878379 | 1878379 | 2021-11-03 | Greene | Alabama | 1063 | 1284 | 44 |
1875104 | 1875104 | 2021-11-02 | Bullock | Alabama | 1011 | 1526 | 44 |
1875130 | 1875130 | 2021-11-02 | Greene | Alabama | 1063 | 1280 | 44 |
1871855 | 1871855 | 2021-11-01 | Bullock | Alabama | 1011 | 1526 | 44 |
1871881 | 1871881 | 2021-11-01 | Greene | Alabama | 1063 | 1278 | 44 |
1868606 | 1868606 | 2021-10-31 | Bullock | Alabama | 1011 | 1526 | 44 |
1868632 | 1868632 | 2021-10-31 | Greene | Alabama | 1063 | 1277 | 44 |
1865357 | 1865357 | 2021-10-30 | Bullock | Alabama | 1011 | 1526 | 44 |
1865383 | 1865383 | 2021-10-30 | Greene | Alabama | 1063 | 1277 | 44 |
1862108 | 1862108 | 2021-10-29 | Bullock | Alabama | 1011 | 1527 | 44 |
1862134 | 1862134 | 2021-10-29 | Greene | Alabama | 1063 | 1277 | 44 |
1858859 | 1858859 | 2021-10-28 | Bullock | Alabama | 1011 | 1527 | 44 |
1858885 | 1858885 | 2021-10-28 | Greene | Alabama | 1063 | 1277 | 44 |
1855636 | 1855636 | 2021-10-27 | Greene | Alabama | 1063 | 1267 | 44 |
1852361 | 1852361 | 2021-10-26 | Bullock | Alabama | 1011 | 1518 | 44 |
1852387 | 1852387 | 2021-10-26 | Greene | Alabama | 1063 | 1267 | 44 |
1849111 | 1849111 | 2021-10-25 | Bullock | Alabama | 1011 | 1517 | 44 |
1849137 | 1849137 | 2021-10-25 | Greene | Alabama | 1063 | 1267 | 44 |
1845861 | 1845861 | 2021-10-24 | Bullock | Alabama | 1011 | 1517 | 44 |
1845887 | 1845887 | 2021-10-24 | Greene | Alabama | 1063 | 1267 | 44 |
1842611 | 1842611 | 2021-10-23 | Bullock | Alabama | 1011 | 1516 | 44 |
1842637 | 1842637 | 2021-10-23 | Greene | Alabama | 1063 | 1267 | 44 |
1839362 | 1839362 | 2021-10-22 | Bullock | Alabama | 1011 | 1516 | 44 |
1839388 | 1839388 | 2021-10-22 | Greene | Alabama | 1063 | 1266 | 44 |
1836113 | 1836113 | 2021-10-21 | Bullock | Alabama | 1011 | 1516 | 44 |
1836139 | 1836139 | 2021-10-21 | Greene | Alabama | 1063 | 1266 | 44 |
1832864 | 1832864 | 2021-10-20 | Bullock | Alabama | 1011 | 1516 | 44 |
1832890 | 1832890 | 2021-10-20 | Greene | Alabama | 1063 | 1262 | 44 |
1829615 | 1829615 | 2021-10-19 | Bullock | Alabama | 1011 | 1517 | 44 |
1829641 | 1829641 | 2021-10-19 | Greene | Alabama | 1063 | 1258 | 44 |
1826366 | 1826366 | 2021-10-18 | Bullock | Alabama | 1011 | 1517 | 44 |
1826392 | 1826392 | 2021-10-18 | Greene | Alabama | 1063 | 1258 | 44 |
1823117 | 1823117 | 2021-10-17 | Bullock | Alabama | 1011 | 1517 | 44 |
1823143 | 1823143 | 2021-10-17 | Greene | Alabama | 1063 | 1258 | 44 |
1819868 | 1819868 | 2021-10-16 | Bullock | Alabama | 1011 | 1517 | 44 |
1819894 | 1819894 | 2021-10-16 | Greene | Alabama | 1063 | 1255 | 44 |
1816619 | 1816619 | 2021-10-15 | Bullock | Alabama | 1011 | 1517 | 44 |
1816645 | 1816645 | 2021-10-15 | Greene | Alabama | 1063 | 1255 | 44 |
1813371 | 1813371 | 2021-10-14 | Bullock | Alabama | 1011 | 1517 | 44 |
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);