ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 1131 and state = "Alabama" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
10876 | 10876 | 2020-03-25 | Wilcox | Alabama | 1131 | 1 | 0 |
12415 | 12415 | 2020-03-26 | Wilcox | Alabama | 1131 | 2 | 0 |
14077 | 14077 | 2020-03-27 | Wilcox | Alabama | 1131 | 2 | 0 |
15856 | 15856 | 2020-03-28 | Wilcox | Alabama | 1131 | 2 | 0 |
17740 | 17740 | 2020-03-29 | Wilcox | Alabama | 1131 | 2 | 0 |
19713 | 19713 | 2020-03-30 | Wilcox | Alabama | 1131 | 2 | 0 |
21785 | 21785 | 2020-03-31 | Wilcox | Alabama | 1131 | 3 | 0 |
23941 | 23941 | 2020-04-01 | Wilcox | Alabama | 1131 | 3 | 0 |
26163 | 26163 | 2020-04-02 | Wilcox | Alabama | 1131 | 5 | 0 |
28460 | 28460 | 2020-04-03 | Wilcox | Alabama | 1131 | 6 | 0 |
30817 | 30817 | 2020-04-04 | Wilcox | Alabama | 1131 | 11 | 0 |
33221 | 33221 | 2020-04-05 | Wilcox | Alabama | 1131 | 12 | 0 |
35660 | 35660 | 2020-04-06 | Wilcox | Alabama | 1131 | 13 | 0 |
38148 | 38148 | 2020-04-07 | Wilcox | Alabama | 1131 | 13 | 0 |
40690 | 40690 | 2020-04-08 | Wilcox | Alabama | 1131 | 13 | 0 |
43264 | 43264 | 2020-04-09 | Wilcox | Alabama | 1131 | 17 | 0 |
45862 | 45862 | 2020-04-10 | Wilcox | Alabama | 1131 | 18 | 0 |
48491 | 48491 | 2020-04-11 | Wilcox | Alabama | 1131 | 25 | 0 |
51153 | 51153 | 2020-04-12 | Wilcox | Alabama | 1131 | 30 | 0 |
53831 | 53831 | 2020-04-13 | Wilcox | Alabama | 1131 | 31 | 0 |
56523 | 56523 | 2020-04-14 | Wilcox | Alabama | 1131 | 31 | 0 |
59231 | 59231 | 2020-04-15 | Wilcox | Alabama | 1131 | 38 | 0 |
61949 | 61949 | 2020-04-16 | Wilcox | Alabama | 1131 | 40 | 0 |
64682 | 64682 | 2020-04-17 | Wilcox | Alabama | 1131 | 40 | 0 |
67430 | 67430 | 2020-04-18 | Wilcox | Alabama | 1131 | 45 | 0 |
70192 | 70192 | 2020-04-19 | Wilcox | Alabama | 1131 | 47 | 1 |
72961 | 72961 | 2020-04-20 | Wilcox | Alabama | 1131 | 49 | 1 |
75737 | 75737 | 2020-04-21 | Wilcox | Alabama | 1131 | 49 | 1 |
78520 | 78520 | 2020-04-22 | Wilcox | Alabama | 1131 | 50 | 1 |
81313 | 81313 | 2020-04-23 | Wilcox | Alabama | 1131 | 52 | 0 |
84114 | 84114 | 2020-04-24 | Wilcox | Alabama | 1131 | 53 | 1 |
86922 | 86922 | 2020-04-25 | Wilcox | Alabama | 1131 | 53 | 1 |
89738 | 89738 | 2020-04-26 | Wilcox | Alabama | 1131 | 56 | 1 |
92556 | 92556 | 2020-04-27 | Wilcox | Alabama | 1131 | 58 | 1 |
95386 | 95386 | 2020-04-28 | Wilcox | Alabama | 1131 | 60 | 1 |
98231 | 98231 | 2020-04-29 | Wilcox | Alabama | 1131 | 62 | 1 |
101081 | 101081 | 2020-04-30 | Wilcox | Alabama | 1131 | 66 | 2 |
103936 | 103936 | 2020-05-01 | Wilcox | Alabama | 1131 | 67 | 3 |
106801 | 106801 | 2020-05-02 | Wilcox | Alabama | 1131 | 71 | 3 |
109670 | 109670 | 2020-05-03 | Wilcox | Alabama | 1131 | 72 | 3 |
112545 | 112545 | 2020-05-04 | Wilcox | Alabama | 1131 | 72 | 4 |
115428 | 115428 | 2020-05-05 | Wilcox | Alabama | 1131 | 72 | 4 |
118387 | 118387 | 2020-05-06 | Wilcox | Alabama | 1131 | 73 | 4 |
121353 | 121353 | 2020-05-07 | Wilcox | Alabama | 1131 | 73 | 4 |
124333 | 124333 | 2020-05-08 | Wilcox | Alabama | 1131 | 77 | 4 |
127318 | 127318 | 2020-05-09 | Wilcox | Alabama | 1131 | 80 | 4 |
130308 | 130308 | 2020-05-10 | Wilcox | Alabama | 1131 | 81 | 4 |
133298 | 133298 | 2020-05-11 | Wilcox | Alabama | 1131 | 85 | 4 |
136288 | 136288 | 2020-05-12 | Wilcox | Alabama | 1131 | 87 | 4 |
139279 | 139279 | 2020-05-13 | Wilcox | Alabama | 1131 | 89 | 5 |
142275 | 142275 | 2020-05-14 | Wilcox | Alabama | 1131 | 89 | 5 |
145274 | 145274 | 2020-05-15 | Wilcox | Alabama | 1131 | 92 | 5 |
148277 | 148277 | 2020-05-16 | Wilcox | Alabama | 1131 | 93 | 5 |
151286 | 151286 | 2020-05-17 | Wilcox | Alabama | 1131 | 94 | 5 |
154298 | 154298 | 2020-05-18 | Wilcox | Alabama | 1131 | 95 | 5 |
157314 | 157314 | 2020-05-19 | Wilcox | Alabama | 1131 | 97 | 5 |
160338 | 160338 | 2020-05-20 | Wilcox | Alabama | 1131 | 108 | 6 |
163366 | 163366 | 2020-05-21 | Wilcox | Alabama | 1131 | 110 | 6 |
166398 | 166398 | 2020-05-22 | Wilcox | Alabama | 1131 | 110 | 6 |
169434 | 169434 | 2020-05-23 | Wilcox | Alabama | 1131 | 113 | 7 |
172475 | 172475 | 2020-05-24 | Wilcox | Alabama | 1131 | 118 | 7 |
175518 | 175518 | 2020-05-25 | Wilcox | Alabama | 1131 | 118 | 7 |
178563 | 178563 | 2020-05-26 | Wilcox | Alabama | 1131 | 122 | 7 |
181607 | 181607 | 2020-05-27 | Wilcox | Alabama | 1131 | 132 | 7 |
184659 | 184659 | 2020-05-28 | Wilcox | Alabama | 1131 | 134 | 7 |
187716 | 187716 | 2020-05-29 | Wilcox | Alabama | 1131 | 141 | 7 |
190780 | 190780 | 2020-05-30 | Wilcox | Alabama | 1131 | 144 | 7 |
193846 | 193846 | 2020-05-31 | Wilcox | Alabama | 1131 | 148 | 7 |
196916 | 196916 | 2020-06-01 | Wilcox | Alabama | 1131 | 151 | 7 |
199989 | 199989 | 2020-06-02 | Wilcox | Alabama | 1131 | 153 | 7 |
203065 | 203065 | 2020-06-03 | Wilcox | Alabama | 1131 | 155 | 7 |
206144 | 206144 | 2020-06-04 | Wilcox | Alabama | 1131 | 159 | 7 |
209226 | 209226 | 2020-06-05 | Wilcox | Alabama | 1131 | 160 | 7 |
212311 | 212311 | 2020-06-06 | Wilcox | Alabama | 1131 | 169 | 7 |
215398 | 215398 | 2020-06-07 | Wilcox | Alabama | 1131 | 171 | 7 |
218488 | 218488 | 2020-06-08 | Wilcox | Alabama | 1131 | 175 | 7 |
221580 | 221580 | 2020-06-09 | Wilcox | Alabama | 1131 | 181 | 7 |
224676 | 224676 | 2020-06-10 | Wilcox | Alabama | 1131 | 185 | 8 |
227777 | 227777 | 2020-06-11 | Wilcox | Alabama | 1131 | 192 | 8 |
230881 | 230881 | 2020-06-12 | Wilcox | Alabama | 1131 | 202 | 8 |
233986 | 233986 | 2020-06-13 | Wilcox | Alabama | 1131 | 218 | 8 |
237093 | 237093 | 2020-06-14 | Wilcox | Alabama | 1131 | 223 | 8 |
240201 | 240201 | 2020-06-15 | Wilcox | Alabama | 1131 | 225 | 8 |
243312 | 243312 | 2020-06-16 | Wilcox | Alabama | 1131 | 228 | 8 |
246425 | 246425 | 2020-06-17 | Wilcox | Alabama | 1131 | 232 | 8 |
249537 | 249537 | 2020-06-18 | Wilcox | Alabama | 1131 | 240 | 8 |
252652 | 252652 | 2020-06-19 | Wilcox | Alabama | 1131 | 242 | 8 |
255771 | 255771 | 2020-06-20 | Wilcox | Alabama | 1131 | 244 | 8 |
258898 | 258898 | 2020-06-21 | Wilcox | Alabama | 1131 | 246 | 8 |
262025 | 262025 | 2020-06-22 | Wilcox | Alabama | 1131 | 248 | 8 |
265154 | 265154 | 2020-06-23 | Wilcox | Alabama | 1131 | 253 | 8 |
268283 | 268283 | 2020-06-24 | Wilcox | Alabama | 1131 | 259 | 8 |
271417 | 271417 | 2020-06-25 | Wilcox | Alabama | 1131 | 263 | 8 |
274557 | 274557 | 2020-06-26 | Wilcox | Alabama | 1131 | 269 | 8 |
280853 | 280853 | 2020-06-28 | Wilcox | Alabama | 1131 | 272 | 8 |
277705 | 277705 | 2020-06-27 | Wilcox | Alabama | 1131 | 273 | 8 |
283999 | 283999 | 2020-06-29 | Wilcox | Alabama | 1131 | 280 | 8 |
287145 | 287145 | 2020-06-30 | Wilcox | Alabama | 1131 | 280 | 8 |
290295 | 290295 | 2020-07-01 | Wilcox | Alabama | 1131 | 282 | 8 |
293448 | 293448 | 2020-07-02 | Wilcox | Alabama | 1131 | 287 | 8 |
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);