ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Highlands" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 206 ✖
- 366 109
- 9 23
- 8 21
- 7 18
- 560 18
- 562 14
- 569 14
- 574 14
- 682 14
- 514 12
- 558 12
- 11 11
- 69 9
- 1 8
- 495 8
- 554 8
- 661 8
- 13 7
- 472 7
- 537 7
- 570 7
- 571 7
- 588 7
- 593 7
- 615 7
- 632 7
- 643 7
- 651 7
- 675 7
- 678 7
- 684 7
- 685 7
- 81 6
- 307 6
- 545 6
- 669 6
- 0 5
- 2 5
- 6 5
- 37 5
- 143 5
- 308 5
- 311 5
- 5 4
- 10 4
- 12 4
- 15 4
- 22 4
- 53 4
- 67 4
- 97 4
- 100 4
- 146 4
- 298 4
- 313 4
- 351 4
- 357 4
- 361 4
- 453 4
- 4 3
- 16 3
- 29 3
- 41 3
- 82 3
- 86 3
- 91 3
- 110 3
- 114 3
- 118 3
- 129 3
- 198 3
- 199 3
- 206 3
- 232 3
- 244 3
- 263 3
- 282 3
- 321 3
- 329 3
- 342 3
- 358 3
- 363 3
- 365 3
- 527 3
- 686 3
- 26 2
- 30 2
- 40 2
- 57 2
- 77 2
- 89 2
- 102 2
- 103 2
- 113 2
- 119 2
- 123 2
- 128 2
- 133 2
- 149 2
- 160 2
- 165 2
- 180 2
- 186 2
- 204 2
- 217 2
- 225 2
- 274 2
- 280 2
- 286 2
- 291 2
- 304 2
- 312 2
- 314 2
- 317 2
- 322 2
- 323 2
- 328 2
- 331 2
- 338 2
- 341 2
- 350 2
- 24 1
- 25 1
- 34 1
- 36 1
- 42 1
- 47 1
- 50 1
- 60 1
- 62 1
- 70 1
- 78 1
- 79 1
- 80 1
- 90 1
- 92 1
- 94 1
- 99 1
- 101 1
- 105 1
- 111 1
- 120 1
- 121 1
- 124 1
- 125 1
- 126 1
- 132 1
- 137 1
- 138 1
- 148 1
- 172 1
- 175 1
- 181 1
- 182 1
- 183 1
- 185 1
- 188 1
- 189 1
- 191 1
- 193 1
- 197 1
- 201 1
- 202 1
- 208 1
- 210 1
- 212 1
- 214 1
- 220 1
- 226 1
- 227 1
- 231 1
- 236 1
- 237 1
- 242 1
- 247 1
- 250 1
- 258 1
- 259 1
- 260 1
- 266 1
- 267 1
- 272 1
- 290 1
- 292 1
- 294 1
- 296 1
- 297 1
- 299 1
- 303 1
- 316 1
- 320 1
- 326 1
- 330 1
- 332 1
- 334 1
- 335 1
- 337 1
- 340 1
- 343 1
- 345 1
- 349 1
- 352 1
- 356 1
- 360 1
- 362 1
- 364 1
state 1
- Florida 784
fips 1
- 12055 784
county 1
- Highlands · 784 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
6238 | 6238 | 2020-03-21 | Highlands | Florida | 12055 | 1 | 0 |
7278 | 7278 | 2020-03-22 | Highlands | Florida | 12055 | 1 | 0 |
8424 | 8424 | 2020-03-23 | Highlands | Florida | 12055 | 2 | 0 |
9669 | 9669 | 2020-03-24 | Highlands | Florida | 12055 | 4 | 0 |
11044 | 11044 | 2020-03-25 | Highlands | Florida | 12055 | 5 | 0 |
12592 | 12592 | 2020-03-26 | Highlands | Florida | 12055 | 5 | 1 |
14261 | 14261 | 2020-03-27 | Highlands | Florida | 12055 | 6 | 1 |
16046 | 16046 | 2020-03-28 | Highlands | Florida | 12055 | 10 | 1 |
17939 | 17939 | 2020-03-29 | Highlands | Florida | 12055 | 12 | 1 |
19919 | 19919 | 2020-03-30 | Highlands | Florida | 12055 | 14 | 1 |
21997 | 21997 | 2020-03-31 | Highlands | Florida | 12055 | 17 | 1 |
24158 | 24158 | 2020-04-01 | Highlands | Florida | 12055 | 21 | 1 |
26388 | 26388 | 2020-04-02 | Highlands | Florida | 12055 | 24 | 1 |
28691 | 28691 | 2020-04-03 | Highlands | Florida | 12055 | 26 | 2 |
31050 | 31050 | 2020-04-04 | Highlands | Florida | 12055 | 30 | 2 |
33456 | 33456 | 2020-04-05 | Highlands | Florida | 12055 | 35 | 2 |
35902 | 35902 | 2020-04-06 | Highlands | Florida | 12055 | 36 | 2 |
38393 | 38393 | 2020-04-07 | Highlands | Florida | 12055 | 37 | 2 |
40936 | 40936 | 2020-04-08 | Highlands | Florida | 12055 | 44 | 4 |
43510 | 43510 | 2020-04-09 | Highlands | Florida | 12055 | 46 | 4 |
46111 | 46111 | 2020-04-10 | Highlands | Florida | 12055 | 47 | 4 |
48741 | 48741 | 2020-04-11 | Highlands | Florida | 12055 | 54 | 5 |
51402 | 51402 | 2020-04-12 | Highlands | Florida | 12055 | 56 | 5 |
54082 | 54082 | 2020-04-13 | Highlands | Florida | 12055 | 61 | 5 |
56774 | 56774 | 2020-04-14 | Highlands | Florida | 12055 | 62 | 5 |
59482 | 59482 | 2020-04-15 | Highlands | Florida | 12055 | 64 | 6 |
62201 | 62201 | 2020-04-16 | Highlands | Florida | 12055 | 66 | 6 |
64934 | 64934 | 2020-04-17 | Highlands | Florida | 12055 | 66 | 6 |
67682 | 67682 | 2020-04-18 | Highlands | Florida | 12055 | 66 | 6 |
70444 | 70444 | 2020-04-19 | Highlands | Florida | 12055 | 70 | 6 |
73213 | 73213 | 2020-04-20 | Highlands | Florida | 12055 | 71 | 7 |
75989 | 75989 | 2020-04-21 | Highlands | Florida | 12055 | 71 | 7 |
78773 | 78773 | 2020-04-22 | Highlands | Florida | 12055 | 71 | 7 |
81567 | 81567 | 2020-04-23 | Highlands | Florida | 12055 | 74 | 7 |
84367 | 84367 | 2020-04-24 | Highlands | Florida | 12055 | 76 | 7 |
87175 | 87175 | 2020-04-25 | Highlands | Florida | 12055 | 76 | 7 |
89992 | 89992 | 2020-04-26 | Highlands | Florida | 12055 | 76 | 7 |
92810 | 92810 | 2020-04-27 | Highlands | Florida | 12055 | 80 | 7 |
95642 | 95642 | 2020-04-28 | Highlands | Florida | 12055 | 81 | 7 |
98487 | 98487 | 2020-04-29 | Highlands | Florida | 12055 | 81 | 7 |
101337 | 101337 | 2020-04-30 | Highlands | Florida | 12055 | 81 | 7 |
104192 | 104192 | 2020-05-01 | Highlands | Florida | 12055 | 84 | 7 |
107057 | 107057 | 2020-05-02 | Highlands | Florida | 12055 | 86 | 7 |
109926 | 109926 | 2020-05-03 | Highlands | Florida | 12055 | 85 | 7 |
112801 | 112801 | 2020-05-04 | Highlands | Florida | 12055 | 87 | 7 |
115684 | 115684 | 2020-05-05 | Highlands | Florida | 12055 | 88 | 7 |
118644 | 118644 | 2020-05-06 | Highlands | Florida | 12055 | 87 | 7 |
121613 | 121613 | 2020-05-07 | Highlands | Florida | 12055 | 90 | 7 |
124592 | 124592 | 2020-05-08 | Highlands | Florida | 12055 | 93 | 8 |
127579 | 127579 | 2020-05-09 | Highlands | Florida | 12055 | 96 | 8 |
130570 | 130570 | 2020-05-10 | Highlands | Florida | 12055 | 98 | 8 |
133561 | 133561 | 2020-05-11 | Highlands | Florida | 12055 | 99 | 8 |
136550 | 136550 | 2020-05-12 | Highlands | Florida | 12055 | 99 | 8 |
139541 | 139541 | 2020-05-13 | Highlands | Florida | 12055 | 100 | 8 |
142537 | 142537 | 2020-05-14 | Highlands | Florida | 12055 | 103 | 8 |
145537 | 145537 | 2020-05-15 | Highlands | Florida | 12055 | 103 | 8 |
148540 | 148540 | 2020-05-16 | Highlands | Florida | 12055 | 104 | 8 |
151549 | 151549 | 2020-05-17 | Highlands | Florida | 12055 | 104 | 8 |
154561 | 154561 | 2020-05-18 | Highlands | Florida | 12055 | 104 | 8 |
157577 | 157577 | 2020-05-19 | Highlands | Florida | 12055 | 107 | 8 |
160603 | 160603 | 2020-05-20 | Highlands | Florida | 12055 | 107 | 8 |
163631 | 163631 | 2020-05-21 | Highlands | Florida | 12055 | 110 | 8 |
166664 | 166664 | 2020-05-22 | Highlands | Florida | 12055 | 111 | 8 |
169701 | 169701 | 2020-05-23 | Highlands | Florida | 12055 | 112 | 8 |
172742 | 172742 | 2020-05-24 | Highlands | Florida | 12055 | 113 | 8 |
175785 | 175785 | 2020-05-25 | Highlands | Florida | 12055 | 114 | 8 |
178829 | 178829 | 2020-05-26 | Highlands | Florida | 12055 | 114 | 8 |
181873 | 181873 | 2020-05-27 | Highlands | Florida | 12055 | 114 | 8 |
184927 | 184927 | 2020-05-28 | Highlands | Florida | 12055 | 119 | 8 |
187983 | 187983 | 2020-05-29 | Highlands | Florida | 12055 | 120 | 9 |
191048 | 191048 | 2020-05-30 | Highlands | Florida | 12055 | 127 | 9 |
194115 | 194115 | 2020-05-31 | Highlands | Florida | 12055 | 129 | 9 |
197185 | 197185 | 2020-06-01 | Highlands | Florida | 12055 | 130 | 9 |
200258 | 200258 | 2020-06-02 | Highlands | Florida | 12055 | 132 | 9 |
203334 | 203334 | 2020-06-03 | Highlands | Florida | 12055 | 134 | 9 |
206414 | 206414 | 2020-06-04 | Highlands | Florida | 12055 | 138 | 9 |
209495 | 209495 | 2020-06-05 | Highlands | Florida | 12055 | 141 | 9 |
212580 | 212580 | 2020-06-06 | Highlands | Florida | 12055 | 143 | 9 |
215667 | 215667 | 2020-06-07 | Highlands | Florida | 12055 | 146 | 9 |
218758 | 218758 | 2020-06-08 | Highlands | Florida | 12055 | 150 | 9 |
221853 | 221853 | 2020-06-09 | Highlands | Florida | 12055 | 150 | 9 |
224948 | 224948 | 2020-06-10 | Highlands | Florida | 12055 | 153 | 9 |
228050 | 228050 | 2020-06-11 | Highlands | Florida | 12055 | 160 | 9 |
231153 | 231153 | 2020-06-12 | Highlands | Florida | 12055 | 169 | 9 |
234259 | 234259 | 2020-06-13 | Highlands | Florida | 12055 | 170 | 9 |
237366 | 237366 | 2020-06-14 | Highlands | Florida | 12055 | 171 | 9 |
240474 | 240474 | 2020-06-15 | Highlands | Florida | 12055 | 172 | 9 |
243585 | 243585 | 2020-06-16 | Highlands | Florida | 12055 | 192 | 9 |
246698 | 246698 | 2020-06-17 | Highlands | Florida | 12055 | 197 | 9 |
249810 | 249810 | 2020-06-18 | Highlands | Florida | 12055 | 200 | 9 |
252925 | 252925 | 2020-06-19 | Highlands | Florida | 12055 | 206 | 9 |
256044 | 256044 | 2020-06-20 | Highlands | Florida | 12055 | 215 | 9 |
259171 | 259171 | 2020-06-21 | Highlands | Florida | 12055 | 226 | 10 |
262298 | 262298 | 2020-06-22 | Highlands | Florida | 12055 | 238 | 10 |
265426 | 265426 | 2020-06-23 | Highlands | Florida | 12055 | 258 | 10 |
268556 | 268556 | 2020-06-24 | Highlands | Florida | 12055 | 270 | 10 |
271692 | 271692 | 2020-06-25 | Highlands | Florida | 12055 | 279 | 11 |
274832 | 274832 | 2020-06-26 | Highlands | Florida | 12055 | 284 | 11 |
277980 | 277980 | 2020-06-27 | Highlands | Florida | 12055 | 373 | 11 |
281127 | 281127 | 2020-06-28 | Highlands | Florida | 12055 | 324 | 11 |
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);