ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Franklin" and fips = 1059 sorted by state descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▲ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
8260 | 8260 | 2020-03-23 | Franklin | Alabama | 1059 | 1 | 0 |
9487 | 9487 | 2020-03-24 | Franklin | Alabama | 1059 | 1 | 0 |
10851 | 10851 | 2020-03-25 | Franklin | Alabama | 1059 | 2 | 0 |
12388 | 12388 | 2020-03-26 | Franklin | Alabama | 1059 | 3 | 0 |
14048 | 14048 | 2020-03-27 | Franklin | Alabama | 1059 | 3 | 0 |
15826 | 15826 | 2020-03-28 | Franklin | Alabama | 1059 | 3 | 0 |
17709 | 17709 | 2020-03-29 | Franklin | Alabama | 1059 | 3 | 0 |
19680 | 19680 | 2020-03-30 | Franklin | Alabama | 1059 | 3 | 0 |
21752 | 21752 | 2020-03-31 | Franklin | Alabama | 1059 | 3 | 0 |
23908 | 23908 | 2020-04-01 | Franklin | Alabama | 1059 | 3 | 0 |
26130 | 26130 | 2020-04-02 | Franklin | Alabama | 1059 | 4 | 0 |
28426 | 28426 | 2020-04-03 | Franklin | Alabama | 1059 | 5 | 0 |
30783 | 30783 | 2020-04-04 | Franklin | Alabama | 1059 | 6 | 0 |
33187 | 33187 | 2020-04-05 | Franklin | Alabama | 1059 | 6 | 0 |
35626 | 35626 | 2020-04-06 | Franklin | Alabama | 1059 | 7 | 0 |
38114 | 38114 | 2020-04-07 | Franklin | Alabama | 1059 | 7 | 0 |
40656 | 40656 | 2020-04-08 | Franklin | Alabama | 1059 | 7 | 0 |
43229 | 43229 | 2020-04-09 | Franklin | Alabama | 1059 | 8 | 0 |
45827 | 45827 | 2020-04-10 | Franklin | Alabama | 1059 | 8 | 0 |
48456 | 48456 | 2020-04-11 | Franklin | Alabama | 1059 | 8 | 0 |
51117 | 51117 | 2020-04-12 | Franklin | Alabama | 1059 | 10 | 0 |
53795 | 53795 | 2020-04-13 | Franklin | Alabama | 1059 | 10 | 0 |
56487 | 56487 | 2020-04-14 | Franklin | Alabama | 1059 | 12 | 1 |
59195 | 59195 | 2020-04-15 | Franklin | Alabama | 1059 | 17 | 1 |
61913 | 61913 | 2020-04-16 | Franklin | Alabama | 1059 | 17 | 1 |
64646 | 64646 | 2020-04-17 | Franklin | Alabama | 1059 | 18 | 1 |
67394 | 67394 | 2020-04-18 | Franklin | Alabama | 1059 | 17 | 0 |
70156 | 70156 | 2020-04-19 | Franklin | Alabama | 1059 | 17 | 0 |
72925 | 72925 | 2020-04-20 | Franklin | Alabama | 1059 | 18 | 0 |
75701 | 75701 | 2020-04-21 | Franklin | Alabama | 1059 | 18 | 0 |
78484 | 78484 | 2020-04-22 | Franklin | Alabama | 1059 | 22 | 0 |
81277 | 81277 | 2020-04-23 | Franklin | Alabama | 1059 | 25 | 0 |
84078 | 84078 | 2020-04-24 | Franklin | Alabama | 1059 | 32 | 0 |
86886 | 86886 | 2020-04-25 | Franklin | Alabama | 1059 | 38 | 0 |
89702 | 89702 | 2020-04-26 | Franklin | Alabama | 1059 | 41 | 0 |
92520 | 92520 | 2020-04-27 | Franklin | Alabama | 1059 | 43 | 0 |
95350 | 95350 | 2020-04-28 | Franklin | Alabama | 1059 | 44 | 0 |
98195 | 98195 | 2020-04-29 | Franklin | Alabama | 1059 | 45 | 0 |
101045 | 101045 | 2020-04-30 | Franklin | Alabama | 1059 | 58 | 0 |
103900 | 103900 | 2020-05-01 | Franklin | Alabama | 1059 | 78 | 0 |
106765 | 106765 | 2020-05-02 | Franklin | Alabama | 1059 | 100 | 0 |
109634 | 109634 | 2020-05-03 | Franklin | Alabama | 1059 | 132 | 0 |
112509 | 112509 | 2020-05-04 | Franklin | Alabama | 1059 | 136 | 0 |
115392 | 115392 | 2020-05-05 | Franklin | Alabama | 1059 | 152 | 0 |
118351 | 118351 | 2020-05-06 | Franklin | Alabama | 1059 | 164 | 1 |
121317 | 121317 | 2020-05-07 | Franklin | Alabama | 1059 | 184 | 1 |
124297 | 124297 | 2020-05-08 | Franklin | Alabama | 1059 | 202 | 1 |
127282 | 127282 | 2020-05-09 | Franklin | Alabama | 1059 | 216 | 1 |
130272 | 130272 | 2020-05-10 | Franklin | Alabama | 1059 | 226 | 1 |
133262 | 133262 | 2020-05-11 | Franklin | Alabama | 1059 | 247 | 2 |
136252 | 136252 | 2020-05-12 | Franklin | Alabama | 1059 | 264 | 3 |
139243 | 139243 | 2020-05-13 | Franklin | Alabama | 1059 | 270 | 3 |
142239 | 142239 | 2020-05-14 | Franklin | Alabama | 1059 | 288 | 3 |
145238 | 145238 | 2020-05-15 | Franklin | Alabama | 1059 | 309 | 4 |
148241 | 148241 | 2020-05-16 | Franklin | Alabama | 1059 | 329 | 4 |
151250 | 151250 | 2020-05-17 | Franklin | Alabama | 1059 | 334 | 4 |
154262 | 154262 | 2020-05-18 | Franklin | Alabama | 1059 | 344 | 4 |
157278 | 157278 | 2020-05-19 | Franklin | Alabama | 1059 | 364 | 4 |
160302 | 160302 | 2020-05-20 | Franklin | Alabama | 1059 | 399 | 5 |
163330 | 163330 | 2020-05-21 | Franklin | Alabama | 1059 | 411 | 5 |
166362 | 166362 | 2020-05-22 | Franklin | Alabama | 1059 | 422 | 5 |
169398 | 169398 | 2020-05-23 | Franklin | Alabama | 1059 | 435 | 6 |
172439 | 172439 | 2020-05-24 | Franklin | Alabama | 1059 | 447 | 6 |
175482 | 175482 | 2020-05-25 | Franklin | Alabama | 1059 | 467 | 6 |
178527 | 178527 | 2020-05-26 | Franklin | Alabama | 1059 | 486 | 6 |
181571 | 181571 | 2020-05-27 | Franklin | Alabama | 1059 | 498 | 6 |
184623 | 184623 | 2020-05-28 | Franklin | Alabama | 1059 | 514 | 7 |
187680 | 187680 | 2020-05-29 | Franklin | Alabama | 1059 | 540 | 7 |
190744 | 190744 | 2020-05-30 | Franklin | Alabama | 1059 | 545 | 7 |
193810 | 193810 | 2020-05-31 | Franklin | Alabama | 1059 | 556 | 7 |
196880 | 196880 | 2020-06-01 | Franklin | Alabama | 1059 | 565 | 8 |
199953 | 199953 | 2020-06-02 | Franklin | Alabama | 1059 | 579 | 8 |
203029 | 203029 | 2020-06-03 | Franklin | Alabama | 1059 | 581 | 8 |
206108 | 206108 | 2020-06-04 | Franklin | Alabama | 1059 | 588 | 8 |
209190 | 209190 | 2020-06-05 | Franklin | Alabama | 1059 | 596 | 9 |
212275 | 212275 | 2020-06-06 | Franklin | Alabama | 1059 | 611 | 9 |
215362 | 215362 | 2020-06-07 | Franklin | Alabama | 1059 | 620 | 9 |
218452 | 218452 | 2020-06-08 | Franklin | Alabama | 1059 | 628 | 10 |
221544 | 221544 | 2020-06-09 | Franklin | Alabama | 1059 | 634 | 10 |
224640 | 224640 | 2020-06-10 | Franklin | Alabama | 1059 | 637 | 10 |
227741 | 227741 | 2020-06-11 | Franklin | Alabama | 1059 | 655 | 10 |
230845 | 230845 | 2020-06-12 | Franklin | Alabama | 1059 | 668 | 10 |
233950 | 233950 | 2020-06-13 | Franklin | Alabama | 1059 | 713 | 10 |
237057 | 237057 | 2020-06-14 | Franklin | Alabama | 1059 | 727 | 10 |
240165 | 240165 | 2020-06-15 | Franklin | Alabama | 1059 | 734 | 10 |
243276 | 243276 | 2020-06-16 | Franklin | Alabama | 1059 | 741 | 10 |
246389 | 246389 | 2020-06-17 | Franklin | Alabama | 1059 | 758 | 10 |
249501 | 249501 | 2020-06-18 | Franklin | Alabama | 1059 | 764 | 10 |
252616 | 252616 | 2020-06-19 | Franklin | Alabama | 1059 | 773 | 10 |
255735 | 255735 | 2020-06-20 | Franklin | Alabama | 1059 | 776 | 10 |
258862 | 258862 | 2020-06-21 | Franklin | Alabama | 1059 | 782 | 10 |
261989 | 261989 | 2020-06-22 | Franklin | Alabama | 1059 | 783 | 10 |
265118 | 265118 | 2020-06-23 | Franklin | Alabama | 1059 | 788 | 10 |
268247 | 268247 | 2020-06-24 | Franklin | Alabama | 1059 | 803 | 10 |
271381 | 271381 | 2020-06-25 | Franklin | Alabama | 1059 | 816 | 11 |
274521 | 274521 | 2020-06-26 | Franklin | Alabama | 1059 | 830 | 11 |
277669 | 277669 | 2020-06-27 | Franklin | Alabama | 1059 | 833 | 11 |
280817 | 280817 | 2020-06-28 | Franklin | Alabama | 1059 | 839 | 11 |
283963 | 283963 | 2020-06-29 | Franklin | Alabama | 1059 | 835 | 11 |
287109 | 287109 | 2020-06-30 | Franklin | Alabama | 1059 | 847 | 13 |
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);