ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Jackson" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
382757 | 382757 | 2020-07-30 | Jackson | Alabama | 1071 | 730 | 5 |
379540 | 379540 | 2020-07-29 | Jackson | Alabama | 1071 | 700 | 5 |
376324 | 376324 | 2020-07-28 | Jackson | Alabama | 1071 | 679 | 5 |
373110 | 373110 | 2020-07-27 | Jackson | Alabama | 1071 | 665 | 5 |
369898 | 369898 | 2020-07-26 | Jackson | Alabama | 1071 | 658 | 5 |
366688 | 366688 | 2020-07-25 | Jackson | Alabama | 1071 | 648 | 5 |
363481 | 363481 | 2020-07-24 | Jackson | Alabama | 1071 | 635 | 5 |
360275 | 360275 | 2020-07-23 | Jackson | Alabama | 1071 | 620 | 4 |
357070 | 357070 | 2020-07-22 | Jackson | Alabama | 1071 | 604 | 4 |
353867 | 353867 | 2020-07-21 | Jackson | Alabama | 1071 | 589 | 4 |
350665 | 350665 | 2020-07-20 | Jackson | Alabama | 1071 | 582 | 4 |
347464 | 347464 | 2020-07-19 | Jackson | Alabama | 1071 | 567 | 4 |
344264 | 344264 | 2020-07-18 | Jackson | Alabama | 1071 | 552 | 4 |
341065 | 341065 | 2020-07-17 | Jackson | Alabama | 1071 | 546 | 4 |
337869 | 337869 | 2020-07-16 | Jackson | Alabama | 1071 | 521 | 4 |
334674 | 334674 | 2020-07-15 | Jackson | Alabama | 1071 | 517 | 4 |
331481 | 331481 | 2020-07-14 | Jackson | Alabama | 1071 | 477 | 3 |
328295 | 328295 | 2020-07-13 | Jackson | Alabama | 1071 | 447 | 3 |
325109 | 325109 | 2020-07-12 | Jackson | Alabama | 1071 | 440 | 3 |
321928 | 321928 | 2020-07-11 | Jackson | Alabama | 1071 | 422 | 3 |
318749 | 318749 | 2020-07-10 | Jackson | Alabama | 1071 | 406 | 3 |
315576 | 315576 | 2020-07-09 | Jackson | Alabama | 1071 | 378 | 3 |
312401 | 312401 | 2020-07-08 | Jackson | Alabama | 1071 | 347 | 3 |
309232 | 309232 | 2020-07-07 | Jackson | Alabama | 1071 | 306 | 3 |
306063 | 306063 | 2020-07-06 | Jackson | Alabama | 1071 | 288 | 3 |
302899 | 302899 | 2020-07-05 | Jackson | Alabama | 1071 | 277 | 3 |
299735 | 299735 | 2020-07-04 | Jackson | Alabama | 1071 | 272 | 3 |
296573 | 296573 | 2020-07-03 | Jackson | Alabama | 1071 | 267 | 3 |
293418 | 293418 | 2020-07-02 | Jackson | Alabama | 1071 | 256 | 3 |
290265 | 290265 | 2020-07-01 | Jackson | Alabama | 1071 | 242 | 3 |
287115 | 287115 | 2020-06-30 | Jackson | Alabama | 1071 | 214 | 3 |
283969 | 283969 | 2020-06-29 | Jackson | Alabama | 1071 | 208 | 3 |
280823 | 280823 | 2020-06-28 | Jackson | Alabama | 1071 | 200 | 3 |
277675 | 277675 | 2020-06-27 | Jackson | Alabama | 1071 | 198 | 3 |
274527 | 274527 | 2020-06-26 | Jackson | Alabama | 1071 | 200 | 3 |
271387 | 271387 | 2020-06-25 | Jackson | Alabama | 1071 | 182 | 3 |
268253 | 268253 | 2020-06-24 | Jackson | Alabama | 1071 | 166 | 3 |
265124 | 265124 | 2020-06-23 | Jackson | Alabama | 1071 | 162 | 3 |
261995 | 261995 | 2020-06-22 | Jackson | Alabama | 1071 | 155 | 3 |
258868 | 258868 | 2020-06-21 | Jackson | Alabama | 1071 | 152 | 3 |
255741 | 255741 | 2020-06-20 | Jackson | Alabama | 1071 | 150 | 3 |
252622 | 252622 | 2020-06-19 | Jackson | Alabama | 1071 | 150 | 3 |
249507 | 249507 | 2020-06-18 | Jackson | Alabama | 1071 | 142 | 3 |
246395 | 246395 | 2020-06-17 | Jackson | Alabama | 1071 | 137 | 3 |
243282 | 243282 | 2020-06-16 | Jackson | Alabama | 1071 | 128 | 3 |
240171 | 240171 | 2020-06-15 | Jackson | Alabama | 1071 | 125 | 3 |
237063 | 237063 | 2020-06-14 | Jackson | Alabama | 1071 | 125 | 3 |
233956 | 233956 | 2020-06-13 | Jackson | Alabama | 1071 | 126 | 3 |
230851 | 230851 | 2020-06-12 | Jackson | Alabama | 1071 | 116 | 3 |
227747 | 227747 | 2020-06-11 | Jackson | Alabama | 1071 | 110 | 3 |
224646 | 224646 | 2020-06-10 | Jackson | Alabama | 1071 | 104 | 3 |
221550 | 221550 | 2020-06-09 | Jackson | Alabama | 1071 | 100 | 3 |
218458 | 218458 | 2020-06-08 | Jackson | Alabama | 1071 | 97 | 3 |
215368 | 215368 | 2020-06-07 | Jackson | Alabama | 1071 | 93 | 3 |
212281 | 212281 | 2020-06-06 | Jackson | Alabama | 1071 | 91 | 3 |
209196 | 209196 | 2020-06-05 | Jackson | Alabama | 1071 | 89 | 3 |
206114 | 206114 | 2020-06-04 | Jackson | Alabama | 1071 | 86 | 3 |
203035 | 203035 | 2020-06-03 | Jackson | Alabama | 1071 | 86 | 3 |
199959 | 199959 | 2020-06-02 | Jackson | Alabama | 1071 | 86 | 3 |
196886 | 196886 | 2020-06-01 | Jackson | Alabama | 1071 | 84 | 2 |
193816 | 193816 | 2020-05-31 | Jackson | Alabama | 1071 | 78 | 2 |
190750 | 190750 | 2020-05-30 | Jackson | Alabama | 1071 | 77 | 2 |
187686 | 187686 | 2020-05-29 | Jackson | Alabama | 1071 | 76 | 2 |
184629 | 184629 | 2020-05-28 | Jackson | Alabama | 1071 | 75 | 2 |
181577 | 181577 | 2020-05-27 | Jackson | Alabama | 1071 | 74 | 2 |
178533 | 178533 | 2020-05-26 | Jackson | Alabama | 1071 | 72 | 2 |
175488 | 175488 | 2020-05-25 | Jackson | Alabama | 1071 | 71 | 2 |
172445 | 172445 | 2020-05-24 | Jackson | Alabama | 1071 | 69 | 2 |
169404 | 169404 | 2020-05-23 | Jackson | Alabama | 1071 | 69 | 2 |
166368 | 166368 | 2020-05-22 | Jackson | Alabama | 1071 | 69 | 2 |
163336 | 163336 | 2020-05-21 | Jackson | Alabama | 1071 | 69 | 2 |
160308 | 160308 | 2020-05-20 | Jackson | Alabama | 1071 | 66 | 2 |
157284 | 157284 | 2020-05-19 | Jackson | Alabama | 1071 | 63 | 2 |
154268 | 154268 | 2020-05-18 | Jackson | Alabama | 1071 | 64 | 2 |
151256 | 151256 | 2020-05-17 | Jackson | Alabama | 1071 | 63 | 2 |
148247 | 148247 | 2020-05-16 | Jackson | Alabama | 1071 | 63 | 2 |
145244 | 145244 | 2020-05-15 | Jackson | Alabama | 1071 | 61 | 2 |
142245 | 142245 | 2020-05-14 | Jackson | Alabama | 1071 | 60 | 2 |
139249 | 139249 | 2020-05-13 | Jackson | Alabama | 1071 | 60 | 2 |
136258 | 136258 | 2020-05-12 | Jackson | Alabama | 1071 | 60 | 2 |
133268 | 133268 | 2020-05-11 | Jackson | Alabama | 1071 | 60 | 2 |
130278 | 130278 | 2020-05-10 | Jackson | Alabama | 1071 | 60 | 2 |
127288 | 127288 | 2020-05-09 | Jackson | Alabama | 1071 | 59 | 2 |
124303 | 124303 | 2020-05-08 | Jackson | Alabama | 1071 | 59 | 2 |
121323 | 121323 | 2020-05-07 | Jackson | Alabama | 1071 | 56 | 2 |
118357 | 118357 | 2020-05-06 | Jackson | Alabama | 1071 | 53 | 2 |
115398 | 115398 | 2020-05-05 | Jackson | Alabama | 1071 | 53 | 2 |
112515 | 112515 | 2020-05-04 | Jackson | Alabama | 1071 | 50 | 2 |
109640 | 109640 | 2020-05-03 | Jackson | Alabama | 1071 | 50 | 2 |
106771 | 106771 | 2020-05-02 | Jackson | Alabama | 1071 | 50 | 2 |
103906 | 103906 | 2020-05-01 | Jackson | Alabama | 1071 | 49 | 2 |
101051 | 101051 | 2020-04-30 | Jackson | Alabama | 1071 | 48 | 2 |
98201 | 98201 | 2020-04-29 | Jackson | Alabama | 1071 | 47 | 2 |
95356 | 95356 | 2020-04-28 | Jackson | Alabama | 1071 | 46 | 2 |
92526 | 92526 | 2020-04-27 | Jackson | Alabama | 1071 | 45 | 2 |
89708 | 89708 | 2020-04-26 | Jackson | Alabama | 1071 | 45 | 2 |
86892 | 86892 | 2020-04-25 | Jackson | Alabama | 1071 | 45 | 2 |
84084 | 84084 | 2020-04-24 | Jackson | Alabama | 1071 | 45 | 2 |
81283 | 81283 | 2020-04-23 | Jackson | Alabama | 1071 | 43 | 2 |
78490 | 78490 | 2020-04-22 | Jackson | Alabama | 1071 | 42 | 2 |
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);