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 county
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 |
---|---|---|---|---|---|---|---|
1757 | 1757 | 2020-03-13 | Bay | Michigan | 26017 | 1 | 0 |
2100 | 2100 | 2020-03-14 | Bay | Michigan | 26017 | 1 | 0 |
2503 | 2503 | 2020-03-15 | Bay | Michigan | 26017 | 1 | 0 |
2953 | 2953 | 2020-03-16 | Bay | Michigan | 26017 | 1 | 0 |
3454 | 3454 | 2020-03-17 | Bay | Michigan | 26017 | 1 | 0 |
4037 | 4037 | 2020-03-18 | Bay | Michigan | 26017 | 1 | 0 |
4742 | 4742 | 2020-03-19 | Bay | Michigan | 26017 | 1 | 0 |
5561 | 5561 | 2020-03-20 | Bay | Michigan | 26017 | 1 | 0 |
6228 | 6228 | 2020-03-21 | Bay | Florida | 12005 | 1 | 0 |
6523 | 6523 | 2020-03-21 | Bay | Michigan | 26017 | 1 | 0 |
7264 | 7264 | 2020-03-22 | Bay | Florida | 12005 | 1 | 0 |
7600 | 7600 | 2020-03-22 | Bay | Michigan | 26017 | 1 | 0 |
8410 | 8410 | 2020-03-23 | Bay | Florida | 12005 | 1 | 0 |
8772 | 8772 | 2020-03-23 | Bay | Michigan | 26017 | 1 | 0 |
9655 | 9655 | 2020-03-24 | Bay | Florida | 12005 | 1 | 0 |
10061 | 10061 | 2020-03-24 | Bay | Michigan | 26017 | 2 | 0 |
11029 | 11029 | 2020-03-25 | Bay | Florida | 12005 | 3 | 0 |
11473 | 11473 | 2020-03-25 | Bay | Michigan | 26017 | 3 | 0 |
12577 | 12577 | 2020-03-26 | Bay | Florida | 12005 | 3 | 0 |
13054 | 13054 | 2020-03-26 | Bay | Michigan | 26017 | 4 | 0 |
14246 | 14246 | 2020-03-27 | Bay | Florida | 12005 | 4 | 0 |
14762 | 14762 | 2020-03-27 | Bay | Michigan | 26017 | 4 | 0 |
16030 | 16030 | 2020-03-28 | Bay | Florida | 12005 | 5 | 0 |
16582 | 16582 | 2020-03-28 | Bay | Michigan | 26017 | 4 | 0 |
17922 | 17922 | 2020-03-29 | Bay | Florida | 12005 | 6 | 0 |
18497 | 18497 | 2020-03-29 | Bay | Michigan | 26017 | 5 | 0 |
19902 | 19902 | 2020-03-30 | Bay | Florida | 12005 | 6 | 0 |
20514 | 20514 | 2020-03-30 | Bay | Michigan | 26017 | 9 | 0 |
21979 | 21979 | 2020-03-31 | Bay | Florida | 12005 | 8 | 0 |
22624 | 22624 | 2020-03-31 | Bay | Michigan | 26017 | 9 | 0 |
24138 | 24138 | 2020-04-01 | Bay | Florida | 12005 | 13 | 0 |
24803 | 24803 | 2020-04-01 | Bay | Michigan | 26017 | 10 | 0 |
26368 | 26368 | 2020-04-02 | Bay | Florida | 12005 | 15 | 0 |
27055 | 27055 | 2020-04-02 | Bay | Michigan | 26017 | 16 | 0 |
28670 | 28670 | 2020-04-03 | Bay | Florida | 12005 | 18 | 0 |
29373 | 29373 | 2020-04-03 | Bay | Michigan | 26017 | 18 | 0 |
31028 | 31028 | 2020-04-04 | Bay | Florida | 12005 | 23 | 1 |
31751 | 31751 | 2020-04-04 | Bay | Michigan | 26017 | 24 | 0 |
33434 | 33434 | 2020-04-05 | Bay | Florida | 12005 | 24 | 1 |
34176 | 34176 | 2020-04-05 | Bay | Michigan | 26017 | 30 | 0 |
35879 | 35879 | 2020-04-06 | Bay | Florida | 12005 | 24 | 1 |
36635 | 36635 | 2020-04-06 | Bay | Michigan | 26017 | 30 | 0 |
38369 | 38369 | 2020-04-07 | Bay | Florida | 12005 | 25 | 1 |
39143 | 39143 | 2020-04-07 | Bay | Michigan | 26017 | 31 | 0 |
40912 | 40912 | 2020-04-08 | Bay | Florida | 12005 | 28 | 1 |
41695 | 41695 | 2020-04-08 | Bay | Michigan | 26017 | 39 | 0 |
43486 | 43486 | 2020-04-09 | Bay | Florida | 12005 | 34 | 1 |
44271 | 44271 | 2020-04-09 | Bay | Michigan | 26017 | 42 | 0 |
46087 | 46087 | 2020-04-10 | Bay | Florida | 12005 | 36 | 1 |
46879 | 46879 | 2020-04-10 | Bay | Michigan | 26017 | 48 | 0 |
48717 | 48717 | 2020-04-11 | Bay | Florida | 12005 | 36 | 1 |
49522 | 49522 | 2020-04-11 | Bay | Michigan | 26017 | 53 | 0 |
51378 | 51378 | 2020-04-12 | Bay | Florida | 12005 | 37 | 1 |
52192 | 52192 | 2020-04-12 | Bay | Michigan | 26017 | 54 | 2 |
54058 | 54058 | 2020-04-13 | Bay | Florida | 12005 | 39 | 1 |
54873 | 54873 | 2020-04-13 | Bay | Michigan | 26017 | 59 | 2 |
56750 | 56750 | 2020-04-14 | Bay | Florida | 12005 | 38 | 2 |
57571 | 57571 | 2020-04-14 | Bay | Michigan | 26017 | 60 | 2 |
59458 | 59458 | 2020-04-15 | Bay | Florida | 12005 | 39 | 2 |
60281 | 60281 | 2020-04-15 | Bay | Michigan | 26017 | 64 | 2 |
62177 | 62177 | 2020-04-16 | Bay | Florida | 12005 | 42 | 2 |
63003 | 63003 | 2020-04-16 | Bay | Michigan | 26017 | 67 | 2 |
64910 | 64910 | 2020-04-17 | Bay | Florida | 12005 | 43 | 2 |
65741 | 65741 | 2020-04-17 | Bay | Michigan | 26017 | 69 | 2 |
67658 | 67658 | 2020-04-18 | Bay | Florida | 12005 | 48 | 2 |
68491 | 68491 | 2020-04-18 | Bay | Michigan | 26017 | 79 | 2 |
70420 | 70420 | 2020-04-19 | Bay | Florida | 12005 | 55 | 2 |
71255 | 71255 | 2020-04-19 | Bay | Michigan | 26017 | 82 | 2 |
73189 | 73189 | 2020-04-20 | Bay | Florida | 12005 | 57 | 2 |
74027 | 74027 | 2020-04-20 | Bay | Michigan | 26017 | 85 | 2 |
75965 | 75965 | 2020-04-21 | Bay | Florida | 12005 | 58 | 2 |
76807 | 76807 | 2020-04-21 | Bay | Michigan | 26017 | 86 | 2 |
78749 | 78749 | 2020-04-22 | Bay | Florida | 12005 | 59 | 2 |
79593 | 79593 | 2020-04-22 | Bay | Michigan | 26017 | 93 | 2 |
81543 | 81543 | 2020-04-23 | Bay | Florida | 12005 | 60 | 2 |
82388 | 82388 | 2020-04-23 | Bay | Michigan | 26017 | 102 | 2 |
84343 | 84343 | 2020-04-24 | Bay | Florida | 12005 | 63 | 2 |
85192 | 85192 | 2020-04-24 | Bay | Michigan | 26017 | 107 | 2 |
87151 | 87151 | 2020-04-25 | Bay | Florida | 12005 | 63 | 2 |
88002 | 88002 | 2020-04-25 | Bay | Michigan | 26017 | 114 | 2 |
89968 | 89968 | 2020-04-26 | Bay | Florida | 12005 | 65 | 2 |
90818 | 90818 | 2020-04-26 | Bay | Michigan | 26017 | 115 | 2 |
92786 | 92786 | 2020-04-27 | Bay | Florida | 12005 | 68 | 2 |
93639 | 93639 | 2020-04-27 | Bay | Michigan | 26017 | 122 | 3 |
95618 | 95618 | 2020-04-28 | Bay | Florida | 12005 | 70 | 2 |
96474 | 96474 | 2020-04-28 | Bay | Michigan | 26017 | 135 | 4 |
98463 | 98463 | 2020-04-29 | Bay | Florida | 12005 | 70 | 2 |
99320 | 99320 | 2020-04-29 | Bay | Michigan | 26017 | 142 | 4 |
101313 | 101313 | 2020-04-30 | Bay | Florida | 12005 | 72 | 3 |
102172 | 102172 | 2020-04-30 | Bay | Michigan | 26017 | 143 | 4 |
104168 | 104168 | 2020-05-01 | Bay | Florida | 12005 | 72 | 3 |
105032 | 105032 | 2020-05-01 | Bay | Michigan | 26017 | 150 | 6 |
107033 | 107033 | 2020-05-02 | Bay | Florida | 12005 | 75 | 3 |
107896 | 107896 | 2020-05-02 | Bay | Michigan | 26017 | 158 | 6 |
109902 | 109902 | 2020-05-03 | Bay | Florida | 12005 | 76 | 3 |
110768 | 110768 | 2020-05-03 | Bay | Michigan | 26017 | 157 | 6 |
112777 | 112777 | 2020-05-04 | Bay | Florida | 12005 | 76 | 3 |
113646 | 113646 | 2020-05-04 | Bay | Michigan | 26017 | 161 | 8 |
115660 | 115660 | 2020-05-05 | Bay | Florida | 12005 | 76 | 3 |
116527 | 116527 | 2020-05-05 | Bay | Michigan | 26017 | 162 | 8 |
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);