ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Franklin" and fips = 37069 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
5759 | 5759 | 2020-03-20 | Franklin | North Carolina | 37069 | 4 | 0 |
6756 | 6756 | 2020-03-21 | Franklin | North Carolina | 37069 | 4 | 0 |
7855 | 7855 | 2020-03-22 | Franklin | North Carolina | 37069 | 4 | 0 |
9056 | 9056 | 2020-03-23 | Franklin | North Carolina | 37069 | 4 | 0 |
10364 | 10364 | 2020-03-24 | Franklin | North Carolina | 37069 | 5 | 0 |
11805 | 11805 | 2020-03-25 | Franklin | North Carolina | 37069 | 5 | 0 |
13409 | 13409 | 2020-03-26 | Franklin | North Carolina | 37069 | 5 | 0 |
15143 | 15143 | 2020-03-27 | Franklin | North Carolina | 37069 | 5 | 0 |
16975 | 16975 | 2020-03-28 | Franklin | North Carolina | 37069 | 5 | 0 |
18905 | 18905 | 2020-03-29 | Franklin | North Carolina | 37069 | 5 | 0 |
20945 | 20945 | 2020-03-30 | Franklin | North Carolina | 37069 | 6 | 0 |
23071 | 23071 | 2020-03-31 | Franklin | North Carolina | 37069 | 11 | 0 |
25265 | 25265 | 2020-04-01 | Franklin | North Carolina | 37069 | 11 | 0 |
27527 | 27527 | 2020-04-02 | Franklin | North Carolina | 37069 | 12 | 0 |
29853 | 29853 | 2020-04-03 | Franklin | North Carolina | 37069 | 13 | 0 |
32240 | 32240 | 2020-04-04 | Franklin | North Carolina | 37069 | 14 | 0 |
34671 | 34671 | 2020-04-05 | Franklin | North Carolina | 37069 | 14 | 0 |
37140 | 37140 | 2020-04-06 | Franklin | North Carolina | 37069 | 15 | 0 |
39655 | 39655 | 2020-04-07 | Franklin | North Carolina | 37069 | 17 | 0 |
42212 | 42212 | 2020-04-08 | Franklin | North Carolina | 37069 | 23 | 1 |
44795 | 44795 | 2020-04-09 | Franklin | North Carolina | 37069 | 23 | 1 |
47408 | 47408 | 2020-04-10 | Franklin | North Carolina | 37069 | 26 | 1 |
50063 | 50063 | 2020-04-11 | Franklin | North Carolina | 37069 | 27 | 1 |
52736 | 52736 | 2020-04-12 | Franklin | North Carolina | 37069 | 64 | 0 |
58119 | 58119 | 2020-04-14 | Franklin | North Carolina | 37069 | 66 | 2 |
60833 | 60833 | 2020-04-15 | Franklin | North Carolina | 37069 | 66 | 3 |
63559 | 63559 | 2020-04-16 | Franklin | North Carolina | 37069 | 66 | 5 |
55419 | 55419 | 2020-04-13 | Franklin | North Carolina | 37069 | 67 | 0 |
66302 | 66302 | 2020-04-17 | Franklin | North Carolina | 37069 | 67 | 5 |
69059 | 69059 | 2020-04-18 | Franklin | North Carolina | 37069 | 69 | 7 |
71825 | 71825 | 2020-04-19 | Franklin | North Carolina | 37069 | 69 | 7 |
74600 | 74600 | 2020-04-20 | Franklin | North Carolina | 37069 | 71 | 7 |
77381 | 77381 | 2020-04-21 | Franklin | North Carolina | 37069 | 74 | 11 |
80170 | 80170 | 2020-04-22 | Franklin | North Carolina | 37069 | 75 | 13 |
82969 | 82969 | 2020-04-23 | Franklin | North Carolina | 37069 | 77 | 13 |
85773 | 85773 | 2020-04-24 | Franklin | North Carolina | 37069 | 87 | 14 |
88585 | 88585 | 2020-04-25 | Franklin | North Carolina | 37069 | 92 | 14 |
91400 | 91400 | 2020-04-26 | Franklin | North Carolina | 37069 | 95 | 14 |
94226 | 94226 | 2020-04-27 | Franklin | North Carolina | 37069 | 100 | 14 |
99909 | 99909 | 2020-04-29 | Franklin | North Carolina | 37069 | 100 | 18 |
97062 | 97062 | 2020-04-28 | Franklin | North Carolina | 37069 | 102 | 18 |
102762 | 102762 | 2020-04-30 | Franklin | North Carolina | 37069 | 104 | 19 |
105624 | 105624 | 2020-05-01 | Franklin | North Carolina | 37069 | 104 | 19 |
108491 | 108491 | 2020-05-02 | Franklin | North Carolina | 37069 | 104 | 19 |
111364 | 111364 | 2020-05-03 | Franklin | North Carolina | 37069 | 105 | 19 |
114245 | 114245 | 2020-05-04 | Franklin | North Carolina | 37069 | 105 | 19 |
117125 | 117125 | 2020-05-05 | Franklin | North Carolina | 37069 | 106 | 19 |
120086 | 120086 | 2020-05-06 | Franklin | North Carolina | 37069 | 106 | 20 |
123061 | 123061 | 2020-05-07 | Franklin | North Carolina | 37069 | 111 | 20 |
126044 | 126044 | 2020-05-08 | Franklin | North Carolina | 37069 | 111 | 20 |
129033 | 129033 | 2020-05-09 | Franklin | North Carolina | 37069 | 111 | 20 |
132022 | 132022 | 2020-05-10 | Franklin | North Carolina | 37069 | 111 | 20 |
135013 | 135013 | 2020-05-11 | Franklin | North Carolina | 37069 | 111 | 20 |
138003 | 138003 | 2020-05-12 | Franklin | North Carolina | 37069 | 114 | 20 |
140999 | 140999 | 2020-05-13 | Franklin | North Carolina | 37069 | 119 | 20 |
143994 | 143994 | 2020-05-14 | Franklin | North Carolina | 37069 | 121 | 20 |
146995 | 146995 | 2020-05-15 | Franklin | North Carolina | 37069 | 121 | 20 |
150002 | 150002 | 2020-05-16 | Franklin | North Carolina | 37069 | 121 | 20 |
153012 | 153012 | 2020-05-17 | Franklin | North Carolina | 37069 | 122 | 20 |
156029 | 156029 | 2020-05-18 | Franklin | North Carolina | 37069 | 124 | 20 |
159048 | 159048 | 2020-05-19 | Franklin | North Carolina | 37069 | 129 | 20 |
162075 | 162075 | 2020-05-20 | Franklin | North Carolina | 37069 | 131 | 20 |
165104 | 165104 | 2020-05-21 | Franklin | North Carolina | 37069 | 137 | 20 |
168139 | 168139 | 2020-05-22 | Franklin | North Carolina | 37069 | 138 | 20 |
171178 | 171178 | 2020-05-23 | Franklin | North Carolina | 37069 | 141 | 20 |
174220 | 174220 | 2020-05-24 | Franklin | North Carolina | 37069 | 141 | 20 |
177264 | 177264 | 2020-05-25 | Franklin | North Carolina | 37069 | 145 | 20 |
180307 | 180307 | 2020-05-26 | Franklin | North Carolina | 37069 | 146 | 20 |
183355 | 183355 | 2020-05-27 | Franklin | North Carolina | 37069 | 151 | 20 |
186412 | 186412 | 2020-05-28 | Franklin | North Carolina | 37069 | 154 | 20 |
189472 | 189472 | 2020-05-29 | Franklin | North Carolina | 37069 | 157 | 20 |
192536 | 192536 | 2020-05-30 | Franklin | North Carolina | 37069 | 159 | 21 |
195606 | 195606 | 2020-05-31 | Franklin | North Carolina | 37069 | 159 | 21 |
198679 | 198679 | 2020-06-01 | Franklin | North Carolina | 37069 | 159 | 21 |
201753 | 201753 | 2020-06-02 | Franklin | North Carolina | 37069 | 162 | 21 |
204830 | 204830 | 2020-06-03 | Franklin | North Carolina | 37069 | 167 | 21 |
207911 | 207911 | 2020-06-04 | Franklin | North Carolina | 37069 | 169 | 21 |
210993 | 210993 | 2020-06-05 | Franklin | North Carolina | 37069 | 179 | 21 |
214077 | 214077 | 2020-06-06 | Franklin | North Carolina | 37069 | 185 | 21 |
217167 | 217167 | 2020-06-07 | Franklin | North Carolina | 37069 | 185 | 21 |
220259 | 220259 | 2020-06-08 | Franklin | North Carolina | 37069 | 190 | 21 |
223353 | 223353 | 2020-06-09 | Franklin | North Carolina | 37069 | 193 | 21 |
226453 | 226453 | 2020-06-10 | Franklin | North Carolina | 37069 | 197 | 21 |
229557 | 229557 | 2020-06-11 | Franklin | North Carolina | 37069 | 202 | 21 |
232662 | 232662 | 2020-06-12 | Franklin | North Carolina | 37069 | 209 | 21 |
235767 | 235767 | 2020-06-13 | Franklin | North Carolina | 37069 | 221 | 21 |
238875 | 238875 | 2020-06-14 | Franklin | North Carolina | 37069 | 230 | 21 |
241984 | 241984 | 2020-06-15 | Franklin | North Carolina | 37069 | 231 | 21 |
245096 | 245096 | 2020-06-16 | Franklin | North Carolina | 37069 | 232 | 21 |
248209 | 248209 | 2020-06-17 | Franklin | North Carolina | 37069 | 237 | 21 |
251324 | 251324 | 2020-06-18 | Franklin | North Carolina | 37069 | 244 | 21 |
254439 | 254439 | 2020-06-19 | Franklin | North Carolina | 37069 | 259 | 21 |
257562 | 257562 | 2020-06-20 | Franklin | North Carolina | 37069 | 264 | 21 |
260689 | 260689 | 2020-06-21 | Franklin | North Carolina | 37069 | 280 | 21 |
263817 | 263817 | 2020-06-22 | Franklin | North Carolina | 37069 | 284 | 21 |
266945 | 266945 | 2020-06-23 | Franklin | North Carolina | 37069 | 287 | 21 |
270079 | 270079 | 2020-06-24 | Franklin | North Carolina | 37069 | 295 | 21 |
273218 | 273218 | 2020-06-25 | Franklin | North Carolina | 37069 | 301 | 21 |
276364 | 276364 | 2020-06-26 | Franklin | North Carolina | 37069 | 309 | 21 |
279512 | 279512 | 2020-06-27 | Franklin | North Carolina | 37069 | 326 | 21 |
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);