ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,576 rows where county = "Bay" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, date (date)
deaths 353 ✖
- 394 110
- 0 44
- 3 36
- 31 36
- 2 31
- 4 30
- 355 27
- 354 19
- 694 18
- 353 17
- 687 15
- 577 14
- 581 14
- 821 14
- 30 13
- 655 12
- 29 11
- 346 11
- 367 11
- 1 10
- 5 10
- 8 10
- 393 10
- 365 9
- 377 9
- 9 8
- 52 8
- 55 8
- 145 8
- 373 8
- 639 8
- 700 8
- 802 8
- 46 7
- 370 7
- 467 7
- 556 7
- 564 7
- 575 7
- 582 7
- 584 7
- 610 7
- 673 7
- 703 7
- 704 7
- 707 7
- 708 7
- 711 7
- 713 7
- 729 7
- 740 7
- 755 7
- 767 7
- 778 7
- 792 7
- 811 7
- 817 7
- 820 7
- 825 7
- 41 6
- 45 6
- 62 6
- 132 6
- 180 6
- 281 6
- 366 6
- 368 6
- 375 6
- 376 6
- 379 6
- 387 6
- 392 6
- 684 6
- 698 6
- 806 6
- 15 5
- 16 5
- 19 5
- 27 5
- 35 5
- 43 5
- 48 5
- 50 5
- 51 5
- 54 5
- 78 5
- 91 5
- 94 5
- 190 5
- 294 5
- 297 5
- 300 5
- 307 5
- 344 5
- 351 5
- 363 5
- 382 5
- 386 5
- 391 5
- 423 5
- 471 5
- 510 5
- 531 5
- 540 5
- 562 5
- 570 5
- 690 5
- 21 4
- 22 4
- 24 4
- 68 4
- 71 4
- 79 4
- 80 4
- 111 4
- 113 4
- 120 4
- 133 4
- 134 4
- 141 4
- 152 4
- 157 4
- 173 4
- 193 4
- 236 4
- 255 4
- 266 4
- 274 4
- 283 4
- 287 4
- 296 4
- 308 4
- 309 4
- 313 4
- 321 4
- 322 4
- 343 4
- 348 4
- 357 4
- 359 4
- 361 4
- 369 4
- 385 4
- 388 4
- 589 4
- 6 3
- 14 3
- 28 3
- 36 3
- 39 3
- 64 3
- 66 3
- 86 3
- 89 3
- 104 3
- 122 3
- 138 3
- 159 3
- 164 3
- 186 3
- 187 3
- 197 3
- 218 3
- 227 3
- 246 3
- 253 3
- 290 3
- 299 3
- 302 3
- 311 3
- 312 3
- 318 3
- 335 3
- 339 3
- 341 3
- 356 3
- 358 3
- 380 3
- 397 3
- 407 3
- 415 3
- 435 3
- 449 3
- 456 3
- 492 3
- 516 3
- 548 3
- 572 3
- 588 3
- 667 3
- 827 3
- 10 2
- 23 2
- 40 2
- 42 2
- 53 2
- 65 2
- 67 2
- 69 2
- 76 2
- 81 2
- 84 2
- 87 2
- 93 2
- 102 2
- 119 2
- 125 2
- 127 2
- 128 2
- 135 2
- 146 2
- 147 2
- 150 2
- 154 2
- 176 2
- 203 2
- 209 2
- 213 2
- 214 2
- 223 2
- 230 2
- 257 2
- 258 2
- 263 2
- 275 2
- 277 2
- 284 2
- 288 2
- 292 2
- 293 2
- 298 2
- 314 2
- 315 2
- 316 2
- 319 2
- 323 2
- 328 2
- 330 2
- 340 2
- 345 2
- 352 2
- 360 2
- 364 2
- 374 2
- 381 2
- 389 2
- 399 2
- 404 2
- 411 2
- 413 2
- 418 2
- 426 2
- 430 2
- 436 2
- 444 2
- 454 2
- 455 2
- 461 2
- 478 2
- 485 2
- 493 2
- 500 2
- 514 2
- 515 2
- 523 2
- 538 2
- 544 2
- 551 2
- 561 2
- 569 2
- 571 2
- 573 2
- 11 1
- 12 1
- 13 1
- 18 1
- 26 1
- 32 1
- 37 1
- 57 1
- 59 1
- 60 1
- 61 1
- 63 1
- 72 1
- 73 1
- 74 1
- 77 1
- 82 1
- 83 1
- 85 1
- 88 1
- 90 1
- 92 1
- 97 1
- 98 1
- 101 1
- 105 1
- 107 1
- 108 1
- 114 1
- 117 1
- 126 1
- 131 1
- 142 1
- 148 1
- 156 1
- 163 1
- 170 1
- 172 1
- 177 1
- 184 1
- 188 1
- 196 1
- 199 1
- 201 1
- 202 1
- 205 1
- 207 1
- 208 1
- 212 1
- 219 1
- 225 1
- 233 1
- 239 1
- 240 1
- 251 1
- 259 1
- 261 1
- 262 1
- 264 1
- 267 1
- 268 1
- 269 1
- 276 1
- 285 1
- 295 1
- 304 1
- 306 1
- 310 1
- 324 1
- 325 1
- 327 1
- 329 1
- 331 1
- 333 1
- 334 1
- 338 1
- 347 1
- 362 1
- 384 1
- 390 1
- 396 1
county 1
- Bay · 1,576 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
6228 | 6228 | 2020-03-21 | Bay | Florida | 12005 | 1 | 0 |
7264 | 7264 | 2020-03-22 | Bay | Florida | 12005 | 1 | 0 |
8410 | 8410 | 2020-03-23 | Bay | Florida | 12005 | 1 | 0 |
9655 | 9655 | 2020-03-24 | Bay | Florida | 12005 | 1 | 0 |
11029 | 11029 | 2020-03-25 | Bay | Florida | 12005 | 3 | 0 |
12577 | 12577 | 2020-03-26 | Bay | Florida | 12005 | 3 | 0 |
14246 | 14246 | 2020-03-27 | Bay | Florida | 12005 | 4 | 0 |
16030 | 16030 | 2020-03-28 | Bay | Florida | 12005 | 5 | 0 |
17922 | 17922 | 2020-03-29 | Bay | Florida | 12005 | 6 | 0 |
19902 | 19902 | 2020-03-30 | Bay | Florida | 12005 | 6 | 0 |
21979 | 21979 | 2020-03-31 | Bay | Florida | 12005 | 8 | 0 |
24138 | 24138 | 2020-04-01 | Bay | Florida | 12005 | 13 | 0 |
26368 | 26368 | 2020-04-02 | Bay | Florida | 12005 | 15 | 0 |
28670 | 28670 | 2020-04-03 | Bay | Florida | 12005 | 18 | 0 |
31028 | 31028 | 2020-04-04 | Bay | Florida | 12005 | 23 | 1 |
33434 | 33434 | 2020-04-05 | Bay | Florida | 12005 | 24 | 1 |
35879 | 35879 | 2020-04-06 | Bay | Florida | 12005 | 24 | 1 |
38369 | 38369 | 2020-04-07 | Bay | Florida | 12005 | 25 | 1 |
40912 | 40912 | 2020-04-08 | Bay | Florida | 12005 | 28 | 1 |
43486 | 43486 | 2020-04-09 | Bay | Florida | 12005 | 34 | 1 |
46087 | 46087 | 2020-04-10 | Bay | Florida | 12005 | 36 | 1 |
48717 | 48717 | 2020-04-11 | Bay | Florida | 12005 | 36 | 1 |
51378 | 51378 | 2020-04-12 | Bay | Florida | 12005 | 37 | 1 |
54058 | 54058 | 2020-04-13 | Bay | Florida | 12005 | 39 | 1 |
56750 | 56750 | 2020-04-14 | Bay | Florida | 12005 | 38 | 2 |
59458 | 59458 | 2020-04-15 | Bay | Florida | 12005 | 39 | 2 |
62177 | 62177 | 2020-04-16 | Bay | Florida | 12005 | 42 | 2 |
64910 | 64910 | 2020-04-17 | Bay | Florida | 12005 | 43 | 2 |
67658 | 67658 | 2020-04-18 | Bay | Florida | 12005 | 48 | 2 |
70420 | 70420 | 2020-04-19 | Bay | Florida | 12005 | 55 | 2 |
73189 | 73189 | 2020-04-20 | Bay | Florida | 12005 | 57 | 2 |
75965 | 75965 | 2020-04-21 | Bay | Florida | 12005 | 58 | 2 |
78749 | 78749 | 2020-04-22 | Bay | Florida | 12005 | 59 | 2 |
81543 | 81543 | 2020-04-23 | Bay | Florida | 12005 | 60 | 2 |
84343 | 84343 | 2020-04-24 | Bay | Florida | 12005 | 63 | 2 |
87151 | 87151 | 2020-04-25 | Bay | Florida | 12005 | 63 | 2 |
89968 | 89968 | 2020-04-26 | Bay | Florida | 12005 | 65 | 2 |
92786 | 92786 | 2020-04-27 | Bay | Florida | 12005 | 68 | 2 |
95618 | 95618 | 2020-04-28 | Bay | Florida | 12005 | 70 | 2 |
98463 | 98463 | 2020-04-29 | Bay | Florida | 12005 | 70 | 2 |
101313 | 101313 | 2020-04-30 | Bay | Florida | 12005 | 72 | 3 |
104168 | 104168 | 2020-05-01 | Bay | Florida | 12005 | 72 | 3 |
107033 | 107033 | 2020-05-02 | Bay | Florida | 12005 | 75 | 3 |
109902 | 109902 | 2020-05-03 | Bay | Florida | 12005 | 76 | 3 |
112777 | 112777 | 2020-05-04 | Bay | Florida | 12005 | 76 | 3 |
115660 | 115660 | 2020-05-05 | Bay | Florida | 12005 | 76 | 3 |
118620 | 118620 | 2020-05-06 | Bay | Florida | 12005 | 76 | 3 |
121589 | 121589 | 2020-05-07 | Bay | Florida | 12005 | 76 | 3 |
124568 | 124568 | 2020-05-08 | Bay | Florida | 12005 | 76 | 3 |
127555 | 127555 | 2020-05-09 | Bay | Florida | 12005 | 76 | 3 |
130546 | 130546 | 2020-05-10 | Bay | Florida | 12005 | 76 | 3 |
133537 | 133537 | 2020-05-11 | Bay | Florida | 12005 | 76 | 3 |
136526 | 136526 | 2020-05-12 | Bay | Florida | 12005 | 77 | 3 |
139517 | 139517 | 2020-05-13 | Bay | Florida | 12005 | 77 | 3 |
142513 | 142513 | 2020-05-14 | Bay | Florida | 12005 | 78 | 3 |
145513 | 145513 | 2020-05-15 | Bay | Florida | 12005 | 80 | 3 |
148516 | 148516 | 2020-05-16 | Bay | Florida | 12005 | 83 | 3 |
151525 | 151525 | 2020-05-17 | Bay | Florida | 12005 | 84 | 3 |
154537 | 154537 | 2020-05-18 | Bay | Florida | 12005 | 85 | 3 |
157553 | 157553 | 2020-05-19 | Bay | Florida | 12005 | 86 | 3 |
160579 | 160579 | 2020-05-20 | Bay | Florida | 12005 | 86 | 3 |
163607 | 163607 | 2020-05-21 | Bay | Florida | 12005 | 87 | 3 |
166640 | 166640 | 2020-05-22 | Bay | Florida | 12005 | 92 | 3 |
169677 | 169677 | 2020-05-23 | Bay | Florida | 12005 | 94 | 3 |
172718 | 172718 | 2020-05-24 | Bay | Florida | 12005 | 95 | 3 |
175761 | 175761 | 2020-05-25 | Bay | Florida | 12005 | 97 | 3 |
178805 | 178805 | 2020-05-26 | Bay | Florida | 12005 | 97 | 3 |
181849 | 181849 | 2020-05-27 | Bay | Florida | 12005 | 97 | 3 |
184903 | 184903 | 2020-05-28 | Bay | Florida | 12005 | 97 | 3 |
187959 | 187959 | 2020-05-29 | Bay | Florida | 12005 | 98 | 3 |
191024 | 191024 | 2020-05-30 | Bay | Florida | 12005 | 97 | 3 |
194091 | 194091 | 2020-05-31 | Bay | Florida | 12005 | 98 | 3 |
197161 | 197161 | 2020-06-01 | Bay | Florida | 12005 | 100 | 3 |
200234 | 200234 | 2020-06-02 | Bay | Florida | 12005 | 99 | 3 |
203310 | 203310 | 2020-06-03 | Bay | Florida | 12005 | 105 | 3 |
206390 | 206390 | 2020-06-04 | Bay | Florida | 12005 | 111 | 4 |
209471 | 209471 | 2020-06-05 | Bay | Florida | 12005 | 115 | 4 |
212556 | 212556 | 2020-06-06 | Bay | Florida | 12005 | 123 | 4 |
215643 | 215643 | 2020-06-07 | Bay | Florida | 12005 | 130 | 4 |
218734 | 218734 | 2020-06-08 | Bay | Florida | 12005 | 132 | 4 |
221829 | 221829 | 2020-06-09 | Bay | Florida | 12005 | 133 | 4 |
224924 | 224924 | 2020-06-10 | Bay | Florida | 12005 | 135 | 4 |
228026 | 228026 | 2020-06-11 | Bay | Florida | 12005 | 135 | 4 |
231129 | 231129 | 2020-06-12 | Bay | Florida | 12005 | 139 | 4 |
234235 | 234235 | 2020-06-13 | Bay | Florida | 12005 | 141 | 4 |
237342 | 237342 | 2020-06-14 | Bay | Florida | 12005 | 145 | 4 |
240450 | 240450 | 2020-06-15 | Bay | Florida | 12005 | 153 | 4 |
243561 | 243561 | 2020-06-16 | Bay | Florida | 12005 | 157 | 4 |
246674 | 246674 | 2020-06-17 | Bay | Florida | 12005 | 161 | 4 |
249786 | 249786 | 2020-06-18 | Bay | Florida | 12005 | 167 | 4 |
252901 | 252901 | 2020-06-19 | Bay | Florida | 12005 | 175 | 4 |
256020 | 256020 | 2020-06-20 | Bay | Florida | 12005 | 188 | 4 |
259147 | 259147 | 2020-06-21 | Bay | Florida | 12005 | 190 | 4 |
262274 | 262274 | 2020-06-22 | Bay | Florida | 12005 | 205 | 4 |
265402 | 265402 | 2020-06-23 | Bay | Florida | 12005 | 230 | 4 |
268532 | 268532 | 2020-06-24 | Bay | Florida | 12005 | 240 | 4 |
271668 | 271668 | 2020-06-25 | Bay | Florida | 12005 | 248 | 4 |
274808 | 274808 | 2020-06-26 | Bay | Florida | 12005 | 287 | 4 |
277956 | 277956 | 2020-06-27 | Bay | Florida | 12005 | 305 | 4 |
281103 | 281103 | 2020-06-28 | Bay | Florida | 12005 | 322 | 4 |
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);