ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 1097 and state = "Alabama" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4409 | 4409 | 2020-03-19 | Mobile | Alabama | 1097 | 1 | 0 |
5179 | 5179 | 2020-03-20 | Mobile | Alabama | 1097 | 2 | 0 |
6096 | 6096 | 2020-03-21 | Mobile | Alabama | 1097 | 2 | 0 |
7130 | 7130 | 2020-03-22 | Mobile | Alabama | 1097 | 2 | 0 |
8270 | 8270 | 2020-03-23 | Mobile | Alabama | 1097 | 2 | 0 |
9497 | 9497 | 2020-03-24 | Mobile | Alabama | 1097 | 6 | 0 |
10863 | 10863 | 2020-03-25 | Mobile | Alabama | 1097 | 10 | 0 |
12402 | 12402 | 2020-03-26 | Mobile | Alabama | 1097 | 21 | 0 |
14063 | 14063 | 2020-03-27 | Mobile | Alabama | 1097 | 23 | 1 |
15841 | 15841 | 2020-03-28 | Mobile | Alabama | 1097 | 34 | 1 |
17725 | 17725 | 2020-03-29 | Mobile | Alabama | 1097 | 41 | 1 |
19697 | 19697 | 2020-03-30 | Mobile | Alabama | 1097 | 45 | 1 |
21769 | 21769 | 2020-03-31 | Mobile | Alabama | 1097 | 53 | 1 |
23925 | 23925 | 2020-04-01 | Mobile | Alabama | 1097 | 57 | 3 |
26147 | 26147 | 2020-04-02 | Mobile | Alabama | 1097 | 69 | 4 |
28444 | 28444 | 2020-04-03 | Mobile | Alabama | 1097 | 103 | 5 |
30801 | 30801 | 2020-04-04 | Mobile | Alabama | 1097 | 114 | 5 |
33205 | 33205 | 2020-04-05 | Mobile | Alabama | 1097 | 127 | 6 |
35644 | 35644 | 2020-04-06 | Mobile | Alabama | 1097 | 148 | 6 |
38132 | 38132 | 2020-04-07 | Mobile | Alabama | 1097 | 202 | 8 |
40674 | 40674 | 2020-04-08 | Mobile | Alabama | 1097 | 249 | 8 |
43247 | 43247 | 2020-04-09 | Mobile | Alabama | 1097 | 329 | 10 |
45845 | 45845 | 2020-04-10 | Mobile | Alabama | 1097 | 382 | 11 |
48474 | 48474 | 2020-04-11 | Mobile | Alabama | 1097 | 429 | 15 |
51136 | 51136 | 2020-04-12 | Mobile | Alabama | 1097 | 454 | 15 |
53814 | 53814 | 2020-04-13 | Mobile | Alabama | 1097 | 491 | 18 |
56506 | 56506 | 2020-04-14 | Mobile | Alabama | 1097 | 509 | 17 |
59214 | 59214 | 2020-04-15 | Mobile | Alabama | 1097 | 561 | 19 |
61932 | 61932 | 2020-04-16 | Mobile | Alabama | 1097 | 594 | 23 |
64665 | 64665 | 2020-04-17 | Mobile | Alabama | 1097 | 627 | 25 |
67413 | 67413 | 2020-04-18 | Mobile | Alabama | 1097 | 638 | 25 |
70175 | 70175 | 2020-04-19 | Mobile | Alabama | 1097 | 663 | 29 |
72944 | 72944 | 2020-04-20 | Mobile | Alabama | 1097 | 680 | 33 |
75720 | 75720 | 2020-04-21 | Mobile | Alabama | 1097 | 721 | 38 |
78503 | 78503 | 2020-04-22 | Mobile | Alabama | 1097 | 759 | 39 |
81296 | 81296 | 2020-04-23 | Mobile | Alabama | 1097 | 810 | 38 |
84097 | 84097 | 2020-04-24 | Mobile | Alabama | 1097 | 845 | 40 |
86905 | 86905 | 2020-04-25 | Mobile | Alabama | 1097 | 888 | 40 |
89721 | 89721 | 2020-04-26 | Mobile | Alabama | 1097 | 917 | 41 |
92539 | 92539 | 2020-04-27 | Mobile | Alabama | 1097 | 942 | 43 |
95369 | 95369 | 2020-04-28 | Mobile | Alabama | 1097 | 994 | 46 |
98214 | 98214 | 2020-04-29 | Mobile | Alabama | 1097 | 1041 | 53 |
101064 | 101064 | 2020-04-30 | Mobile | Alabama | 1097 | 1057 | 55 |
103919 | 103919 | 2020-05-01 | Mobile | Alabama | 1097 | 1099 | 61 |
106784 | 106784 | 2020-05-02 | Mobile | Alabama | 1097 | 1172 | 61 |
109653 | 109653 | 2020-05-03 | Mobile | Alabama | 1097 | 1198 | 62 |
112528 | 112528 | 2020-05-04 | Mobile | Alabama | 1097 | 1222 | 66 |
115411 | 115411 | 2020-05-05 | Mobile | Alabama | 1097 | 1265 | 71 |
118370 | 118370 | 2020-05-06 | Mobile | Alabama | 1097 | 1311 | 76 |
121336 | 121336 | 2020-05-07 | Mobile | Alabama | 1097 | 1355 | 78 |
124316 | 124316 | 2020-05-08 | Mobile | Alabama | 1097 | 1407 | 81 |
127301 | 127301 | 2020-05-09 | Mobile | Alabama | 1097 | 1452 | 83 |
130291 | 130291 | 2020-05-10 | Mobile | Alabama | 1097 | 1461 | 85 |
133281 | 133281 | 2020-05-11 | Mobile | Alabama | 1097 | 1474 | 90 |
136271 | 136271 | 2020-05-12 | Mobile | Alabama | 1097 | 1507 | 95 |
139262 | 139262 | 2020-05-13 | Mobile | Alabama | 1097 | 1545 | 96 |
142258 | 142258 | 2020-05-14 | Mobile | Alabama | 1097 | 1608 | 98 |
145257 | 145257 | 2020-05-15 | Mobile | Alabama | 1097 | 1653 | 100 |
148260 | 148260 | 2020-05-16 | Mobile | Alabama | 1097 | 1681 | 100 |
151269 | 151269 | 2020-05-17 | Mobile | Alabama | 1097 | 1701 | 101 |
154281 | 154281 | 2020-05-18 | Mobile | Alabama | 1097 | 1735 | 101 |
157297 | 157297 | 2020-05-19 | Mobile | Alabama | 1097 | 1751 | 103 |
160321 | 160321 | 2020-05-20 | Mobile | Alabama | 1097 | 1822 | 106 |
163349 | 163349 | 2020-05-21 | Mobile | Alabama | 1097 | 1874 | 107 |
166381 | 166381 | 2020-05-22 | Mobile | Alabama | 1097 | 1916 | 107 |
169417 | 169417 | 2020-05-23 | Mobile | Alabama | 1097 | 1982 | 109 |
172458 | 172458 | 2020-05-24 | Mobile | Alabama | 1097 | 1996 | 109 |
175501 | 175501 | 2020-05-25 | Mobile | Alabama | 1097 | 2033 | 111 |
178546 | 178546 | 2020-05-26 | Mobile | Alabama | 1097 | 2054 | 112 |
181590 | 181590 | 2020-05-27 | Mobile | Alabama | 1097 | 2085 | 112 |
184642 | 184642 | 2020-05-28 | Mobile | Alabama | 1097 | 2124 | 112 |
187699 | 187699 | 2020-05-29 | Mobile | Alabama | 1097 | 2162 | 114 |
190763 | 190763 | 2020-05-30 | Mobile | Alabama | 1097 | 2191 | 115 |
193829 | 193829 | 2020-05-31 | Mobile | Alabama | 1097 | 2239 | 116 |
196899 | 196899 | 2020-06-01 | Mobile | Alabama | 1097 | 2280 | 118 |
199972 | 199972 | 2020-06-02 | Mobile | Alabama | 1097 | 2292 | 118 |
203048 | 203048 | 2020-06-03 | Mobile | Alabama | 1097 | 2293 | 118 |
206127 | 206127 | 2020-06-04 | Mobile | Alabama | 1097 | 2330 | 118 |
209209 | 209209 | 2020-06-05 | Mobile | Alabama | 1097 | 2352 | 124 |
212294 | 212294 | 2020-06-06 | Mobile | Alabama | 1097 | 2394 | 125 |
215381 | 215381 | 2020-06-07 | Mobile | Alabama | 1097 | 2450 | 125 |
218471 | 218471 | 2020-06-08 | Mobile | Alabama | 1097 | 2478 | 124 |
221563 | 221563 | 2020-06-09 | Mobile | Alabama | 1097 | 2504 | 126 |
224659 | 224659 | 2020-06-10 | Mobile | Alabama | 1097 | 2563 | 127 |
227760 | 227760 | 2020-06-11 | Mobile | Alabama | 1097 | 2612 | 128 |
230864 | 230864 | 2020-06-12 | Mobile | Alabama | 1097 | 2642 | 129 |
233969 | 233969 | 2020-06-13 | Mobile | Alabama | 1097 | 2679 | 129 |
237076 | 237076 | 2020-06-14 | Mobile | Alabama | 1097 | 2716 | 129 |
240184 | 240184 | 2020-06-15 | Mobile | Alabama | 1097 | 2742 | 129 |
243295 | 243295 | 2020-06-16 | Mobile | Alabama | 1097 | 2790 | 129 |
246408 | 246408 | 2020-06-17 | Mobile | Alabama | 1097 | 2808 | 130 |
249520 | 249520 | 2020-06-18 | Mobile | Alabama | 1097 | 2856 | 131 |
252635 | 252635 | 2020-06-19 | Mobile | Alabama | 1097 | 2921 | 132 |
255754 | 255754 | 2020-06-20 | Mobile | Alabama | 1097 | 2954 | 133 |
258881 | 258881 | 2020-06-21 | Mobile | Alabama | 1097 | 3016 | 133 |
262008 | 262008 | 2020-06-22 | Mobile | Alabama | 1097 | 3036 | 133 |
265137 | 265137 | 2020-06-23 | Mobile | Alabama | 1097 | 3074 | 133 |
268266 | 268266 | 2020-06-24 | Mobile | Alabama | 1097 | 3186 | 135 |
271400 | 271400 | 2020-06-25 | Mobile | Alabama | 1097 | 3241 | 135 |
274540 | 274540 | 2020-06-26 | Mobile | Alabama | 1097 | 3294 | 135 |
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);