ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Lauderdale" and state = "Alabama" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5175 | 5175 | 2020-03-20 | Lauderdale | Alabama | 1077 | 1 | 0 |
6091 | 6091 | 2020-03-21 | Lauderdale | Alabama | 1077 | 2 | 0 |
7125 | 7125 | 2020-03-22 | Lauderdale | Alabama | 1077 | 2 | 0 |
8265 | 8265 | 2020-03-23 | Lauderdale | Alabama | 1077 | 3 | 0 |
9492 | 9492 | 2020-03-24 | Lauderdale | Alabama | 1077 | 3 | 0 |
10856 | 10856 | 2020-03-25 | Lauderdale | Alabama | 1077 | 7 | 0 |
12393 | 12393 | 2020-03-26 | Lauderdale | Alabama | 1077 | 9 | 1 |
14054 | 14054 | 2020-03-27 | Lauderdale | Alabama | 1077 | 11 | 1 |
15832 | 15832 | 2020-03-28 | Lauderdale | Alabama | 1077 | 13 | 1 |
17715 | 17715 | 2020-03-29 | Lauderdale | Alabama | 1077 | 12 | 1 |
19687 | 19687 | 2020-03-30 | Lauderdale | Alabama | 1077 | 12 | 1 |
21759 | 21759 | 2020-03-31 | Lauderdale | Alabama | 1077 | 12 | 1 |
23915 | 23915 | 2020-04-01 | Lauderdale | Alabama | 1077 | 12 | 1 |
26137 | 26137 | 2020-04-02 | Lauderdale | Alabama | 1077 | 14 | 2 |
28434 | 28434 | 2020-04-03 | Lauderdale | Alabama | 1077 | 14 | 2 |
30791 | 30791 | 2020-04-04 | Lauderdale | Alabama | 1077 | 16 | 2 |
33195 | 33195 | 2020-04-05 | Lauderdale | Alabama | 1077 | 16 | 2 |
35634 | 35634 | 2020-04-06 | Lauderdale | Alabama | 1077 | 16 | 2 |
38122 | 38122 | 2020-04-07 | Lauderdale | Alabama | 1077 | 18 | 2 |
40664 | 40664 | 2020-04-08 | Lauderdale | Alabama | 1077 | 19 | 2 |
43237 | 43237 | 2020-04-09 | Lauderdale | Alabama | 1077 | 20 | 3 |
45835 | 45835 | 2020-04-10 | Lauderdale | Alabama | 1077 | 20 | 3 |
48464 | 48464 | 2020-04-11 | Lauderdale | Alabama | 1077 | 21 | 4 |
51126 | 51126 | 2020-04-12 | Lauderdale | Alabama | 1077 | 21 | 4 |
53804 | 53804 | 2020-04-13 | Lauderdale | Alabama | 1077 | 22 | 4 |
56496 | 56496 | 2020-04-14 | Lauderdale | Alabama | 1077 | 22 | 4 |
59204 | 59204 | 2020-04-15 | Lauderdale | Alabama | 1077 | 22 | 4 |
61922 | 61922 | 2020-04-16 | Lauderdale | Alabama | 1077 | 22 | 4 |
64655 | 64655 | 2020-04-17 | Lauderdale | Alabama | 1077 | 23 | 4 |
67403 | 67403 | 2020-04-18 | Lauderdale | Alabama | 1077 | 23 | 4 |
70165 | 70165 | 2020-04-19 | Lauderdale | Alabama | 1077 | 23 | 4 |
72934 | 72934 | 2020-04-20 | Lauderdale | Alabama | 1077 | 24 | 4 |
75710 | 75710 | 2020-04-21 | Lauderdale | Alabama | 1077 | 25 | 4 |
78493 | 78493 | 2020-04-22 | Lauderdale | Alabama | 1077 | 25 | 3 |
81286 | 81286 | 2020-04-23 | Lauderdale | Alabama | 1077 | 25 | 3 |
84087 | 84087 | 2020-04-24 | Lauderdale | Alabama | 1077 | 25 | 2 |
86895 | 86895 | 2020-04-25 | Lauderdale | Alabama | 1077 | 27 | 2 |
89711 | 89711 | 2020-04-26 | Lauderdale | Alabama | 1077 | 31 | 2 |
92529 | 92529 | 2020-04-27 | Lauderdale | Alabama | 1077 | 31 | 2 |
95359 | 95359 | 2020-04-28 | Lauderdale | Alabama | 1077 | 30 | 2 |
98204 | 98204 | 2020-04-29 | Lauderdale | Alabama | 1077 | 33 | 2 |
101054 | 101054 | 2020-04-30 | Lauderdale | Alabama | 1077 | 38 | 2 |
103909 | 103909 | 2020-05-01 | Lauderdale | Alabama | 1077 | 50 | 2 |
106774 | 106774 | 2020-05-02 | Lauderdale | Alabama | 1077 | 56 | 2 |
109643 | 109643 | 2020-05-03 | Lauderdale | Alabama | 1077 | 61 | 2 |
112518 | 112518 | 2020-05-04 | Lauderdale | Alabama | 1077 | 63 | 2 |
115401 | 115401 | 2020-05-05 | Lauderdale | Alabama | 1077 | 68 | 2 |
118360 | 118360 | 2020-05-06 | Lauderdale | Alabama | 1077 | 71 | 2 |
121326 | 121326 | 2020-05-07 | Lauderdale | Alabama | 1077 | 79 | 2 |
124306 | 124306 | 2020-05-08 | Lauderdale | Alabama | 1077 | 87 | 2 |
127291 | 127291 | 2020-05-09 | Lauderdale | Alabama | 1077 | 88 | 2 |
130281 | 130281 | 2020-05-10 | Lauderdale | Alabama | 1077 | 92 | 2 |
133271 | 133271 | 2020-05-11 | Lauderdale | Alabama | 1077 | 96 | 2 |
136261 | 136261 | 2020-05-12 | Lauderdale | Alabama | 1077 | 99 | 2 |
139252 | 139252 | 2020-05-13 | Lauderdale | Alabama | 1077 | 102 | 2 |
142248 | 142248 | 2020-05-14 | Lauderdale | Alabama | 1077 | 109 | 2 |
145247 | 145247 | 2020-05-15 | Lauderdale | Alabama | 1077 | 110 | 2 |
148250 | 148250 | 2020-05-16 | Lauderdale | Alabama | 1077 | 113 | 2 |
151259 | 151259 | 2020-05-17 | Lauderdale | Alabama | 1077 | 113 | 2 |
154271 | 154271 | 2020-05-18 | Lauderdale | Alabama | 1077 | 115 | 2 |
157287 | 157287 | 2020-05-19 | Lauderdale | Alabama | 1077 | 116 | 2 |
160311 | 160311 | 2020-05-20 | Lauderdale | Alabama | 1077 | 117 | 2 |
163339 | 163339 | 2020-05-21 | Lauderdale | Alabama | 1077 | 119 | 2 |
166371 | 166371 | 2020-05-22 | Lauderdale | Alabama | 1077 | 122 | 2 |
169407 | 169407 | 2020-05-23 | Lauderdale | Alabama | 1077 | 126 | 2 |
172448 | 172448 | 2020-05-24 | Lauderdale | Alabama | 1077 | 128 | 2 |
175491 | 175491 | 2020-05-25 | Lauderdale | Alabama | 1077 | 135 | 2 |
178536 | 178536 | 2020-05-26 | Lauderdale | Alabama | 1077 | 141 | 2 |
181580 | 181580 | 2020-05-27 | Lauderdale | Alabama | 1077 | 145 | 2 |
184632 | 184632 | 2020-05-28 | Lauderdale | Alabama | 1077 | 153 | 2 |
187689 | 187689 | 2020-05-29 | Lauderdale | Alabama | 1077 | 156 | 2 |
190753 | 190753 | 2020-05-30 | Lauderdale | Alabama | 1077 | 161 | 2 |
193819 | 193819 | 2020-05-31 | Lauderdale | Alabama | 1077 | 164 | 2 |
196889 | 196889 | 2020-06-01 | Lauderdale | Alabama | 1077 | 167 | 2 |
199962 | 199962 | 2020-06-02 | Lauderdale | Alabama | 1077 | 168 | 2 |
203038 | 203038 | 2020-06-03 | Lauderdale | Alabama | 1077 | 170 | 2 |
206117 | 206117 | 2020-06-04 | Lauderdale | Alabama | 1077 | 173 | 2 |
209199 | 209199 | 2020-06-05 | Lauderdale | Alabama | 1077 | 176 | 2 |
212284 | 212284 | 2020-06-06 | Lauderdale | Alabama | 1077 | 182 | 2 |
215371 | 215371 | 2020-06-07 | Lauderdale | Alabama | 1077 | 185 | 2 |
218461 | 218461 | 2020-06-08 | Lauderdale | Alabama | 1077 | 189 | 3 |
221553 | 221553 | 2020-06-09 | Lauderdale | Alabama | 1077 | 193 | 3 |
224649 | 224649 | 2020-06-10 | Lauderdale | Alabama | 1077 | 198 | 3 |
227750 | 227750 | 2020-06-11 | Lauderdale | Alabama | 1077 | 209 | 3 |
230854 | 230854 | 2020-06-12 | Lauderdale | Alabama | 1077 | 218 | 3 |
233959 | 233959 | 2020-06-13 | Lauderdale | Alabama | 1077 | 232 | 3 |
237066 | 237066 | 2020-06-14 | Lauderdale | Alabama | 1077 | 236 | 3 |
240174 | 240174 | 2020-06-15 | Lauderdale | Alabama | 1077 | 251 | 3 |
243285 | 243285 | 2020-06-16 | Lauderdale | Alabama | 1077 | 262 | 4 |
246398 | 246398 | 2020-06-17 | Lauderdale | Alabama | 1077 | 267 | 4 |
249510 | 249510 | 2020-06-18 | Lauderdale | Alabama | 1077 | 282 | 4 |
252625 | 252625 | 2020-06-19 | Lauderdale | Alabama | 1077 | 290 | 4 |
255744 | 255744 | 2020-06-20 | Lauderdale | Alabama | 1077 | 295 | 4 |
258871 | 258871 | 2020-06-21 | Lauderdale | Alabama | 1077 | 298 | 4 |
261998 | 261998 | 2020-06-22 | Lauderdale | Alabama | 1077 | 299 | 4 |
265127 | 265127 | 2020-06-23 | Lauderdale | Alabama | 1077 | 308 | 4 |
268256 | 268256 | 2020-06-24 | Lauderdale | Alabama | 1077 | 325 | 4 |
271390 | 271390 | 2020-06-25 | Lauderdale | Alabama | 1077 | 334 | 4 |
274530 | 274530 | 2020-06-26 | Lauderdale | Alabama | 1077 | 354 | 4 |
277678 | 277678 | 2020-06-27 | Lauderdale | Alabama | 1077 | 365 | 4 |
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);