ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Limestone" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
293424 | 293424 | 2020-07-02 | Limestone | Alabama | 1083 | 434 | 0 |
290271 | 290271 | 2020-07-01 | Limestone | Alabama | 1083 | 413 | 0 |
287121 | 287121 | 2020-06-30 | Limestone | Alabama | 1083 | 407 | 0 |
283975 | 283975 | 2020-06-29 | Limestone | Alabama | 1083 | 398 | 0 |
280829 | 280829 | 2020-06-28 | Limestone | Alabama | 1083 | 363 | 0 |
277681 | 277681 | 2020-06-27 | Limestone | Alabama | 1083 | 355 | 0 |
274533 | 274533 | 2020-06-26 | Limestone | Alabama | 1083 | 338 | 0 |
271393 | 271393 | 2020-06-25 | Limestone | Alabama | 1083 | 321 | 0 |
268259 | 268259 | 2020-06-24 | Limestone | Alabama | 1083 | 297 | 0 |
265130 | 265130 | 2020-06-23 | Limestone | Alabama | 1083 | 285 | 0 |
262001 | 262001 | 2020-06-22 | Limestone | Alabama | 1083 | 275 | 0 |
258874 | 258874 | 2020-06-21 | Limestone | Alabama | 1083 | 271 | 0 |
255747 | 255747 | 2020-06-20 | Limestone | Alabama | 1083 | 267 | 0 |
252628 | 252628 | 2020-06-19 | Limestone | Alabama | 1083 | 262 | 0 |
249513 | 249513 | 2020-06-18 | Limestone | Alabama | 1083 | 257 | 0 |
246401 | 246401 | 2020-06-17 | Limestone | Alabama | 1083 | 244 | 0 |
243288 | 243288 | 2020-06-16 | Limestone | Alabama | 1083 | 238 | 0 |
240177 | 240177 | 2020-06-15 | Limestone | Alabama | 1083 | 228 | 0 |
237069 | 237069 | 2020-06-14 | Limestone | Alabama | 1083 | 217 | 0 |
233962 | 233962 | 2020-06-13 | Limestone | Alabama | 1083 | 199 | 0 |
230857 | 230857 | 2020-06-12 | Limestone | Alabama | 1083 | 177 | 0 |
227753 | 227753 | 2020-06-11 | Limestone | Alabama | 1083 | 164 | 0 |
224652 | 224652 | 2020-06-10 | Limestone | Alabama | 1083 | 153 | 0 |
221556 | 221556 | 2020-06-09 | Limestone | Alabama | 1083 | 146 | 0 |
218464 | 218464 | 2020-06-08 | Limestone | Alabama | 1083 | 137 | 0 |
215374 | 215374 | 2020-06-07 | Limestone | Alabama | 1083 | 125 | 0 |
212287 | 212287 | 2020-06-06 | Limestone | Alabama | 1083 | 121 | 0 |
209202 | 209202 | 2020-06-05 | Limestone | Alabama | 1083 | 112 | 0 |
206120 | 206120 | 2020-06-04 | Limestone | Alabama | 1083 | 110 | 0 |
203041 | 203041 | 2020-06-03 | Limestone | Alabama | 1083 | 110 | 0 |
199965 | 199965 | 2020-06-02 | Limestone | Alabama | 1083 | 110 | 0 |
196892 | 196892 | 2020-06-01 | Limestone | Alabama | 1083 | 110 | 0 |
193822 | 193822 | 2020-05-31 | Limestone | Alabama | 1083 | 106 | 0 |
190756 | 190756 | 2020-05-30 | Limestone | Alabama | 1083 | 94 | 0 |
187692 | 187692 | 2020-05-29 | Limestone | Alabama | 1083 | 92 | 0 |
184635 | 184635 | 2020-05-28 | Limestone | Alabama | 1083 | 87 | 0 |
181583 | 181583 | 2020-05-27 | Limestone | Alabama | 1083 | 86 | 0 |
178539 | 178539 | 2020-05-26 | Limestone | Alabama | 1083 | 82 | 0 |
175494 | 175494 | 2020-05-25 | Limestone | Alabama | 1083 | 77 | 0 |
172451 | 172451 | 2020-05-24 | Limestone | Alabama | 1083 | 74 | 0 |
169410 | 169410 | 2020-05-23 | Limestone | Alabama | 1083 | 72 | 0 |
166374 | 166374 | 2020-05-22 | Limestone | Alabama | 1083 | 72 | 0 |
163342 | 163342 | 2020-05-21 | Limestone | Alabama | 1083 | 71 | 0 |
160314 | 160314 | 2020-05-20 | Limestone | Alabama | 1083 | 69 | 0 |
157290 | 157290 | 2020-05-19 | Limestone | Alabama | 1083 | 65 | 0 |
154274 | 154274 | 2020-05-18 | Limestone | Alabama | 1083 | 65 | 0 |
151262 | 151262 | 2020-05-17 | Limestone | Alabama | 1083 | 64 | 0 |
148253 | 148253 | 2020-05-16 | Limestone | Alabama | 1083 | 64 | 0 |
145250 | 145250 | 2020-05-15 | Limestone | Alabama | 1083 | 64 | 0 |
142251 | 142251 | 2020-05-14 | Limestone | Alabama | 1083 | 62 | 0 |
139255 | 139255 | 2020-05-13 | Limestone | Alabama | 1083 | 60 | 0 |
136264 | 136264 | 2020-05-12 | Limestone | Alabama | 1083 | 58 | 0 |
133274 | 133274 | 2020-05-11 | Limestone | Alabama | 1083 | 57 | 0 |
130284 | 130284 | 2020-05-10 | Limestone | Alabama | 1083 | 57 | 0 |
127294 | 127294 | 2020-05-09 | Limestone | Alabama | 1083 | 57 | 0 |
124309 | 124309 | 2020-05-08 | Limestone | Alabama | 1083 | 55 | 0 |
121329 | 121329 | 2020-05-07 | Limestone | Alabama | 1083 | 54 | 0 |
118363 | 118363 | 2020-05-06 | Limestone | Alabama | 1083 | 49 | 0 |
115404 | 115404 | 2020-05-05 | Limestone | Alabama | 1083 | 48 | 0 |
112521 | 112521 | 2020-05-04 | Limestone | Alabama | 1083 | 47 | 0 |
109646 | 109646 | 2020-05-03 | Limestone | Alabama | 1083 | 45 | 0 |
106777 | 106777 | 2020-05-02 | Limestone | Alabama | 1083 | 44 | 0 |
103912 | 103912 | 2020-05-01 | Limestone | Alabama | 1083 | 44 | 0 |
101057 | 101057 | 2020-04-30 | Limestone | Alabama | 1083 | 44 | 0 |
98207 | 98207 | 2020-04-29 | Limestone | Alabama | 1083 | 44 | 0 |
95362 | 95362 | 2020-04-28 | Limestone | Alabama | 1083 | 44 | 0 |
92532 | 92532 | 2020-04-27 | Limestone | Alabama | 1083 | 42 | 0 |
89714 | 89714 | 2020-04-26 | Limestone | Alabama | 1083 | 41 | 0 |
86898 | 86898 | 2020-04-25 | Limestone | Alabama | 1083 | 41 | 0 |
84090 | 84090 | 2020-04-24 | Limestone | Alabama | 1083 | 41 | 0 |
81289 | 81289 | 2020-04-23 | Limestone | Alabama | 1083 | 40 | 0 |
78496 | 78496 | 2020-04-22 | Limestone | Alabama | 1083 | 38 | 0 |
75713 | 75713 | 2020-04-21 | Limestone | Alabama | 1083 | 40 | 0 |
72937 | 72937 | 2020-04-20 | Limestone | Alabama | 1083 | 40 | 0 |
70168 | 70168 | 2020-04-19 | Limestone | Alabama | 1083 | 40 | 0 |
67406 | 67406 | 2020-04-18 | Limestone | Alabama | 1083 | 40 | 0 |
64658 | 64658 | 2020-04-17 | Limestone | Alabama | 1083 | 40 | 0 |
61925 | 61925 | 2020-04-16 | Limestone | Alabama | 1083 | 38 | 0 |
59207 | 59207 | 2020-04-15 | Limestone | Alabama | 1083 | 38 | 0 |
56499 | 56499 | 2020-04-14 | Limestone | Alabama | 1083 | 37 | 0 |
53807 | 53807 | 2020-04-13 | Limestone | Alabama | 1083 | 37 | 0 |
51129 | 51129 | 2020-04-12 | Limestone | Alabama | 1083 | 37 | 0 |
48467 | 48467 | 2020-04-11 | Limestone | Alabama | 1083 | 36 | 0 |
45838 | 45838 | 2020-04-10 | Limestone | Alabama | 1083 | 36 | 0 |
43240 | 43240 | 2020-04-09 | Limestone | Alabama | 1083 | 35 | 0 |
40667 | 40667 | 2020-04-08 | Limestone | Alabama | 1083 | 32 | 0 |
38125 | 38125 | 2020-04-07 | Limestone | Alabama | 1083 | 32 | 0 |
35637 | 35637 | 2020-04-06 | Limestone | Alabama | 1083 | 33 | 0 |
33198 | 33198 | 2020-04-05 | Limestone | Alabama | 1083 | 32 | 0 |
30794 | 30794 | 2020-04-04 | Limestone | Alabama | 1083 | 31 | 0 |
28437 | 28437 | 2020-04-03 | Limestone | Alabama | 1083 | 30 | 0 |
26140 | 26140 | 2020-04-02 | Limestone | Alabama | 1083 | 25 | 0 |
23918 | 23918 | 2020-04-01 | Limestone | Alabama | 1083 | 23 | 0 |
21762 | 21762 | 2020-03-31 | Limestone | Alabama | 1083 | 22 | 0 |
19690 | 19690 | 2020-03-30 | Limestone | Alabama | 1083 | 20 | 0 |
17718 | 17718 | 2020-03-29 | Limestone | Alabama | 1083 | 16 | 0 |
15835 | 15835 | 2020-03-28 | Limestone | Alabama | 1083 | 16 | 0 |
14057 | 14057 | 2020-03-27 | Limestone | Alabama | 1083 | 16 | 0 |
12396 | 12396 | 2020-03-26 | Limestone | Alabama | 1083 | 13 | 0 |
10859 | 10859 | 2020-03-25 | Limestone | Alabama | 1083 | 6 | 0 |
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);