ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Franklin" and state = "Maine" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
13005 | 13005 | 2020-03-26 | Franklin | Maine | 23007 | 1 | 0 |
14713 | 14713 | 2020-03-27 | Franklin | Maine | 23007 | 1 | 0 |
16533 | 16533 | 2020-03-28 | Franklin | Maine | 23007 | 2 | 0 |
18447 | 18447 | 2020-03-29 | Franklin | Maine | 23007 | 2 | 0 |
20463 | 20463 | 2020-03-30 | Franklin | Maine | 23007 | 2 | 0 |
22572 | 22572 | 2020-03-31 | Franklin | Maine | 23007 | 2 | 0 |
24748 | 24748 | 2020-04-01 | Franklin | Maine | 23007 | 2 | 0 |
26999 | 26999 | 2020-04-02 | Franklin | Maine | 23007 | 3 | 0 |
29317 | 29317 | 2020-04-03 | Franklin | Maine | 23007 | 4 | 0 |
31695 | 31695 | 2020-04-04 | Franklin | Maine | 23007 | 4 | 0 |
34120 | 34120 | 2020-04-05 | Franklin | Maine | 23007 | 4 | 0 |
36579 | 36579 | 2020-04-06 | Franklin | Maine | 23007 | 5 | 0 |
39087 | 39087 | 2020-04-07 | Franklin | Maine | 23007 | 5 | 0 |
41639 | 41639 | 2020-04-08 | Franklin | Maine | 23007 | 5 | 0 |
44215 | 44215 | 2020-04-09 | Franklin | Maine | 23007 | 7 | 0 |
46823 | 46823 | 2020-04-10 | Franklin | Maine | 23007 | 7 | 0 |
49465 | 49465 | 2020-04-11 | Franklin | Maine | 23007 | 7 | 0 |
52135 | 52135 | 2020-04-12 | Franklin | Maine | 23007 | 8 | 0 |
54816 | 54816 | 2020-04-13 | Franklin | Maine | 23007 | 8 | 0 |
57514 | 57514 | 2020-04-14 | Franklin | Maine | 23007 | 8 | 0 |
60222 | 60222 | 2020-04-15 | Franklin | Maine | 23007 | 9 | 0 |
62943 | 62943 | 2020-04-16 | Franklin | Maine | 23007 | 9 | 0 |
65682 | 65682 | 2020-04-17 | Franklin | Maine | 23007 | 10 | 0 |
68431 | 68431 | 2020-04-18 | Franklin | Maine | 23007 | 11 | 0 |
71194 | 71194 | 2020-04-19 | Franklin | Maine | 23007 | 12 | 0 |
73966 | 73966 | 2020-04-20 | Franklin | Maine | 23007 | 13 | 0 |
76746 | 76746 | 2020-04-21 | Franklin | Maine | 23007 | 13 | 0 |
79532 | 79532 | 2020-04-22 | Franklin | Maine | 23007 | 14 | 0 |
82328 | 82328 | 2020-04-23 | Franklin | Maine | 23007 | 14 | 0 |
85132 | 85132 | 2020-04-24 | Franklin | Maine | 23007 | 26 | 0 |
87941 | 87941 | 2020-04-25 | Franklin | Maine | 23007 | 27 | 1 |
90757 | 90757 | 2020-04-26 | Franklin | Maine | 23007 | 27 | 1 |
93578 | 93578 | 2020-04-27 | Franklin | Maine | 23007 | 27 | 1 |
96413 | 96413 | 2020-04-28 | Franklin | Maine | 23007 | 27 | 1 |
99259 | 99259 | 2020-04-29 | Franklin | Maine | 23007 | 27 | 1 |
102111 | 102111 | 2020-04-30 | Franklin | Maine | 23007 | 27 | 1 |
104972 | 104972 | 2020-05-01 | Franklin | Maine | 23007 | 28 | 1 |
107836 | 107836 | 2020-05-02 | Franklin | Maine | 23007 | 28 | 1 |
110708 | 110708 | 2020-05-03 | Franklin | Maine | 23007 | 29 | 1 |
113585 | 113585 | 2020-05-04 | Franklin | Maine | 23007 | 29 | 1 |
116467 | 116467 | 2020-05-05 | Franklin | Maine | 23007 | 29 | 1 |
119428 | 119428 | 2020-05-06 | Franklin | Maine | 23007 | 29 | 1 |
122399 | 122399 | 2020-05-07 | Franklin | Maine | 23007 | 31 | 1 |
125381 | 125381 | 2020-05-08 | Franklin | Maine | 23007 | 31 | 1 |
128368 | 128368 | 2020-05-09 | Franklin | Maine | 23007 | 31 | 1 |
131358 | 131358 | 2020-05-10 | Franklin | Maine | 23007 | 31 | 1 |
134349 | 134349 | 2020-05-11 | Franklin | Maine | 23007 | 31 | 1 |
137339 | 137339 | 2020-05-12 | Franklin | Maine | 23007 | 31 | 1 |
140333 | 140333 | 2020-05-13 | Franklin | Maine | 23007 | 31 | 1 |
143328 | 143328 | 2020-05-14 | Franklin | Maine | 23007 | 31 | 1 |
146328 | 146328 | 2020-05-15 | Franklin | Maine | 23007 | 33 | 1 |
149333 | 149333 | 2020-05-16 | Franklin | Maine | 23007 | 33 | 1 |
152344 | 152344 | 2020-05-17 | Franklin | Maine | 23007 | 33 | 1 |
155358 | 155358 | 2020-05-18 | Franklin | Maine | 23007 | 33 | 1 |
158376 | 158376 | 2020-05-19 | Franklin | Maine | 23007 | 33 | 1 |
161402 | 161402 | 2020-05-20 | Franklin | Maine | 23007 | 34 | 1 |
164431 | 164431 | 2020-05-21 | Franklin | Maine | 23007 | 35 | 1 |
167467 | 167467 | 2020-05-22 | Franklin | Maine | 23007 | 36 | 1 |
170505 | 170505 | 2020-05-23 | Franklin | Maine | 23007 | 36 | 1 |
173546 | 173546 | 2020-05-24 | Franklin | Maine | 23007 | 36 | 1 |
176590 | 176590 | 2020-05-25 | Franklin | Maine | 23007 | 36 | 1 |
179634 | 179634 | 2020-05-26 | Franklin | Maine | 23007 | 36 | 1 |
182679 | 182679 | 2020-05-27 | Franklin | Maine | 23007 | 36 | 1 |
185734 | 185734 | 2020-05-28 | Franklin | Maine | 23007 | 36 | 1 |
188792 | 188792 | 2020-05-29 | Franklin | Maine | 23007 | 36 | 1 |
191856 | 191856 | 2020-05-30 | Franklin | Maine | 23007 | 36 | 1 |
194924 | 194924 | 2020-05-31 | Franklin | Maine | 23007 | 36 | 1 |
197995 | 197995 | 2020-06-01 | Franklin | Maine | 23007 | 36 | 1 |
201067 | 201067 | 2020-06-02 | Franklin | Maine | 23007 | 36 | 1 |
204144 | 204144 | 2020-06-03 | Franklin | Maine | 23007 | 36 | 1 |
207225 | 207225 | 2020-06-04 | Franklin | Maine | 23007 | 36 | 1 |
210306 | 210306 | 2020-06-05 | Franklin | Maine | 23007 | 36 | 1 |
213391 | 213391 | 2020-06-06 | Franklin | Maine | 23007 | 36 | 1 |
216478 | 216478 | 2020-06-07 | Franklin | Maine | 23007 | 36 | 1 |
219570 | 219570 | 2020-06-08 | Franklin | Maine | 23007 | 36 | 1 |
222665 | 222665 | 2020-06-09 | Franklin | Maine | 23007 | 36 | 1 |
225761 | 225761 | 2020-06-10 | Franklin | Maine | 23007 | 36 | 1 |
228863 | 228863 | 2020-06-11 | Franklin | Maine | 23007 | 36 | 1 |
231967 | 231967 | 2020-06-12 | Franklin | Maine | 23007 | 37 | 1 |
235072 | 235072 | 2020-06-13 | Franklin | Maine | 23007 | 37 | 1 |
238179 | 238179 | 2020-06-14 | Franklin | Maine | 23007 | 37 | 1 |
241288 | 241288 | 2020-06-15 | Franklin | Maine | 23007 | 37 | 1 |
244399 | 244399 | 2020-06-16 | Franklin | Maine | 23007 | 37 | 1 |
247512 | 247512 | 2020-06-17 | Franklin | Maine | 23007 | 37 | 1 |
250624 | 250624 | 2020-06-18 | Franklin | Maine | 23007 | 37 | 1 |
253739 | 253739 | 2020-06-19 | Franklin | Maine | 23007 | 38 | 1 |
256859 | 256859 | 2020-06-20 | Franklin | Maine | 23007 | 38 | 1 |
259985 | 259985 | 2020-06-21 | Franklin | Maine | 23007 | 38 | 1 |
263114 | 263114 | 2020-06-22 | Franklin | Maine | 23007 | 38 | 1 |
266241 | 266241 | 2020-06-23 | Franklin | Maine | 23007 | 38 | 1 |
269374 | 269374 | 2020-06-24 | Franklin | Maine | 23007 | 38 | 1 |
272510 | 272510 | 2020-06-25 | Franklin | Maine | 23007 | 38 | 1 |
275653 | 275653 | 2020-06-26 | Franklin | Maine | 23007 | 38 | 1 |
278801 | 278801 | 2020-06-27 | Franklin | Maine | 23007 | 39 | 1 |
281949 | 281949 | 2020-06-28 | Franklin | Maine | 23007 | 39 | 1 |
285095 | 285095 | 2020-06-29 | Franklin | Maine | 23007 | 41 | 1 |
288244 | 288244 | 2020-06-30 | Franklin | Maine | 23007 | 41 | 1 |
291395 | 291395 | 2020-07-01 | Franklin | Maine | 23007 | 41 | 1 |
294549 | 294549 | 2020-07-02 | Franklin | Maine | 23007 | 40 | 1 |
297707 | 297707 | 2020-07-03 | Franklin | Maine | 23007 | 40 | 1 |
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);