ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Sarasota" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
deaths 265 ✖
- 844 103
- 1326 18
- 1358 14
- 0 13
- 1205 12
- 100 10
- 751 10
- 1147 8
- 1293 8
- 1339 8
- 1551 8
- 98 7
- 1082 7
- 1277 7
- 1316 7
- 1344 7
- 1350 7
- 1352 7
- 1376 7
- 1381 7
- 1428 7
- 1455 7
- 1488 7
- 1503 7
- 1535 7
- 1575 7
- 1586 7
- 1597 7
- 1606 7
- 1611 7
- 1614 7
- 7 6
- 57 6
- 1291 6
- 1333 6
- 1562 6
- 2 5
- 32 5
- 77 5
- 96 5
- 216 5
- 371 5
- 563 5
- 676 5
- 785 5
- 807 5
- 812 5
- 829 5
- 842 5
- 1325 5
- 58 4
- 73 4
- 85 4
- 92 4
- 180 4
- 254 4
- 750 4
- 776 4
- 791 4
- 822 4
- 834 4
- 1051 4
- 47 3
- 91 3
- 94 3
- 113 3
- 121 3
- 173 3
- 202 3
- 233 3
- 246 3
- 344 3
- 351 3
- 512 3
- 514 3
- 624 3
- 650 3
- 742 3
- 804 3
- 805 3
- 1248 3
- 1620 3
- 3 2
- 10 2
- 12 2
- 17 2
- 23 2
- 42 2
- 80 2
- 89 2
- 95 2
- 97 2
- 115 2
- 130 2
- 263 2
- 280 2
- 311 2
- 330 2
- 338 2
- 348 2
- 356 2
- 357 2
- 358 2
- 387 2
- 388 2
- 389 2
- 393 2
- 398 2
- 399 2
- 427 2
- 466 2
- 468 2
- 488 2
- 502 2
- 509 2
- 539 2
- 541 2
- 544 2
- 606 2
- 651 2
- 701 2
- 715 2
- 730 2
- 749 2
- 787 2
- 795 2
- 800 2
- 808 2
- 811 2
- 820 2
- 825 2
- 843 2
- 1 1
- 8 1
- 14 1
- 16 1
- 22 1
- 28 1
- 30 1
- 31 1
- 39 1
- 44 1
- 48 1
- 49 1
- 51 1
- 54 1
- 63 1
- 65 1
- 67 1
- 70 1
- 76 1
- 82 1
- 86 1
- 88 1
- 106 1
- 107 1
- 108 1
- 109 1
- 110 1
- 116 1
- 119 1
- 120 1
- 128 1
- 129 1
- 138 1
- 139 1
- 147 1
- 162 1
- 166 1
- 167 1
- 174 1
- 178 1
- 179 1
- 181 1
- 187 1
- 191 1
- 198 1
- 201 1
- 204 1
- 211 1
- 212 1
- 221 1
- 225 1
- 231 1
- 239 1
- 241 1
- 245 1
- 247 1
- 248 1
- 251 1
- 253 1
- 256 1
- 258 1
- 261 1
- 264 1
- 265 1
- 268 1
- 271 1
- 278 1
- 284 1
- 286 1
- 290 1
- 291 1
- 301 1
- 307 1
- 309 1
- 314 1
- 326 1
- 327 1
- 329 1
- 333 1
- 340 1
- 343 1
- 345 1
- 350 1
- 352 1
- 359 1
- 364 1
- 382 1
- 391 1
- 415 1
- 416 1
- 421 1
- 428 1
- 441 1
- 445 1
- 450 1
- 454 1
- 465 1
- 467 1
- 499 1
- 500 1
- 507 1
- 556 1
- 557 1
- 560 1
- 602 1
- 604 1
- 605 1
- 610 1
- 615 1
- 625 1
- 628 1
- 638 1
- 671 1
- 674 1
- 700 1
- 704 1
- 718 1
- 724 1
- 725 1
- 743 1
- 747 1
- 775 1
- 777 1
- 793 1
- 798 1
- 799 1
- 806 1
- 809 1
- 827 1
- 828 1
- 833 1
- 835 1
- 837 1
state 1
- Florida 793
fips 1
- 12115 793
county 1
- Sarasota · 793 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
1426 | 1426 | 2020-03-12 | Sarasota | Florida | 12115 | 2 | 0 |
1694 | 1694 | 2020-03-13 | Sarasota | Florida | 12115 | 2 | 0 |
2016 | 2016 | 2020-03-14 | Sarasota | Florida | 12115 | 2 | 0 |
2400 | 2400 | 2020-03-15 | Sarasota | Florida | 12115 | 2 | 0 |
2837 | 2837 | 2020-03-16 | Sarasota | Florida | 12115 | 3 | 0 |
3322 | 3322 | 2020-03-17 | Sarasota | Florida | 12115 | 4 | 0 |
3880 | 3880 | 2020-03-18 | Sarasota | Florida | 12115 | 4 | 0 |
4549 | 4549 | 2020-03-19 | Sarasota | Florida | 12115 | 6 | 0 |
5329 | 5329 | 2020-03-20 | Sarasota | Florida | 12115 | 8 | 0 |
6260 | 6260 | 2020-03-21 | Sarasota | Florida | 12115 | 14 | 0 |
7300 | 7300 | 2020-03-22 | Sarasota | Florida | 12115 | 17 | 0 |
8446 | 8446 | 2020-03-23 | Sarasota | Florida | 12115 | 21 | 0 |
9691 | 9691 | 2020-03-24 | Sarasota | Florida | 12115 | 26 | 0 |
11066 | 11066 | 2020-03-25 | Sarasota | Florida | 12115 | 32 | 1 |
12614 | 12614 | 2020-03-26 | Sarasota | Florida | 12115 | 34 | 2 |
14284 | 14284 | 2020-03-27 | Sarasota | Florida | 12115 | 43 | 2 |
16069 | 16069 | 2020-03-28 | Sarasota | Florida | 12115 | 50 | 2 |
17962 | 17962 | 2020-03-29 | Sarasota | Florida | 12115 | 61 | 2 |
19943 | 19943 | 2020-03-30 | Sarasota | Florida | 12115 | 67 | 2 |
22021 | 22021 | 2020-03-31 | Sarasota | Florida | 12115 | 76 | 3 |
24184 | 24184 | 2020-04-01 | Sarasota | Florida | 12115 | 99 | 3 |
26414 | 26414 | 2020-04-02 | Sarasota | Florida | 12115 | 110 | 7 |
28717 | 28717 | 2020-04-03 | Sarasota | Florida | 12115 | 124 | 7 |
31077 | 31077 | 2020-04-04 | Sarasota | Florida | 12115 | 129 | 7 |
33483 | 33483 | 2020-04-05 | Sarasota | Florida | 12115 | 140 | 7 |
35929 | 35929 | 2020-04-06 | Sarasota | Florida | 12115 | 159 | 7 |
38420 | 38420 | 2020-04-07 | Sarasota | Florida | 12115 | 173 | 7 |
40964 | 40964 | 2020-04-08 | Sarasota | Florida | 12115 | 184 | 8 |
43538 | 43538 | 2020-04-09 | Sarasota | Florida | 12115 | 201 | 10 |
46140 | 46140 | 2020-04-10 | Sarasota | Florida | 12115 | 211 | 10 |
48770 | 48770 | 2020-04-11 | Sarasota | Florida | 12115 | 223 | 12 |
51431 | 51431 | 2020-04-12 | Sarasota | Florida | 12115 | 226 | 12 |
54111 | 54111 | 2020-04-13 | Sarasota | Florida | 12115 | 230 | 14 |
56803 | 56803 | 2020-04-14 | Sarasota | Florida | 12115 | 241 | 16 |
59511 | 59511 | 2020-04-15 | Sarasota | Florida | 12115 | 253 | 17 |
62230 | 62230 | 2020-04-16 | Sarasota | Florida | 12115 | 260 | 17 |
64963 | 64963 | 2020-04-17 | Sarasota | Florida | 12115 | 274 | 22 |
67711 | 67711 | 2020-04-18 | Sarasota | Florida | 12115 | 279 | 23 |
70473 | 70473 | 2020-04-19 | Sarasota | Florida | 12115 | 284 | 23 |
73242 | 73242 | 2020-04-20 | Sarasota | Florida | 12115 | 291 | 28 |
76018 | 76018 | 2020-04-21 | Sarasota | Florida | 12115 | 297 | 30 |
78802 | 78802 | 2020-04-22 | Sarasota | Florida | 12115 | 299 | 31 |
81596 | 81596 | 2020-04-23 | Sarasota | Florida | 12115 | 310 | 32 |
84396 | 84396 | 2020-04-24 | Sarasota | Florida | 12115 | 314 | 32 |
87204 | 87204 | 2020-04-25 | Sarasota | Florida | 12115 | 318 | 32 |
90021 | 90021 | 2020-04-26 | Sarasota | Florida | 12115 | 321 | 32 |
92839 | 92839 | 2020-04-27 | Sarasota | Florida | 12115 | 323 | 32 |
95671 | 95671 | 2020-04-28 | Sarasota | Florida | 12115 | 334 | 39 |
98516 | 98516 | 2020-04-29 | Sarasota | Florida | 12115 | 338 | 42 |
101366 | 101366 | 2020-04-30 | Sarasota | Florida | 12115 | 352 | 42 |
104221 | 104221 | 2020-05-01 | Sarasota | Florida | 12115 | 365 | 44 |
107086 | 107086 | 2020-05-02 | Sarasota | Florida | 12115 | 372 | 47 |
109955 | 109955 | 2020-05-03 | Sarasota | Florida | 12115 | 377 | 47 |
112830 | 112830 | 2020-05-04 | Sarasota | Florida | 12115 | 385 | 47 |
115713 | 115713 | 2020-05-05 | Sarasota | Florida | 12115 | 395 | 48 |
118673 | 118673 | 2020-05-06 | Sarasota | Florida | 12115 | 405 | 49 |
121642 | 121642 | 2020-05-07 | Sarasota | Florida | 12115 | 412 | 51 |
124621 | 124621 | 2020-05-08 | Sarasota | Florida | 12115 | 416 | 54 |
127608 | 127608 | 2020-05-09 | Sarasota | Florida | 12115 | 418 | 57 |
130599 | 130599 | 2020-05-10 | Sarasota | Florida | 12115 | 426 | 57 |
133590 | 133590 | 2020-05-11 | Sarasota | Florida | 12115 | 430 | 57 |
136579 | 136579 | 2020-05-12 | Sarasota | Florida | 12115 | 435 | 57 |
139570 | 139570 | 2020-05-13 | Sarasota | Florida | 12115 | 440 | 57 |
142566 | 142566 | 2020-05-14 | Sarasota | Florida | 12115 | 487 | 57 |
145566 | 145566 | 2020-05-15 | Sarasota | Florida | 12115 | 496 | 58 |
148569 | 148569 | 2020-05-16 | Sarasota | Florida | 12115 | 498 | 58 |
151578 | 151578 | 2020-05-17 | Sarasota | Florida | 12115 | 508 | 58 |
154590 | 154590 | 2020-05-18 | Sarasota | Florida | 12115 | 518 | 58 |
157606 | 157606 | 2020-05-19 | Sarasota | Florida | 12115 | 533 | 63 |
160632 | 160632 | 2020-05-20 | Sarasota | Florida | 12115 | 538 | 65 |
163660 | 163660 | 2020-05-21 | Sarasota | Florida | 12115 | 550 | 67 |
166693 | 166693 | 2020-05-22 | Sarasota | Florida | 12115 | 565 | 70 |
169730 | 169730 | 2020-05-23 | Sarasota | Florida | 12115 | 576 | 73 |
172771 | 172771 | 2020-05-24 | Sarasota | Florida | 12115 | 586 | 73 |
175814 | 175814 | 2020-05-25 | Sarasota | Florida | 12115 | 590 | 73 |
178858 | 178858 | 2020-05-26 | Sarasota | Florida | 12115 | 594 | 73 |
181902 | 181902 | 2020-05-27 | Sarasota | Florida | 12115 | 598 | 76 |
184956 | 184956 | 2020-05-28 | Sarasota | Florida | 12115 | 611 | 77 |
188012 | 188012 | 2020-05-29 | Sarasota | Florida | 12115 | 622 | 77 |
191077 | 191077 | 2020-05-30 | Sarasota | Florida | 12115 | 629 | 77 |
194144 | 194144 | 2020-05-31 | Sarasota | Florida | 12115 | 635 | 77 |
197214 | 197214 | 2020-06-01 | Sarasota | Florida | 12115 | 639 | 77 |
200287 | 200287 | 2020-06-02 | Sarasota | Florida | 12115 | 647 | 80 |
203363 | 203363 | 2020-06-03 | Sarasota | Florida | 12115 | 649 | 80 |
206443 | 206443 | 2020-06-04 | Sarasota | Florida | 12115 | 652 | 82 |
209524 | 209524 | 2020-06-05 | Sarasota | Florida | 12115 | 658 | 85 |
212609 | 212609 | 2020-06-06 | Sarasota | Florida | 12115 | 669 | 85 |
215696 | 215696 | 2020-06-07 | Sarasota | Florida | 12115 | 680 | 85 |
218787 | 218787 | 2020-06-08 | Sarasota | Florida | 12115 | 686 | 85 |
221882 | 221882 | 2020-06-09 | Sarasota | Florida | 12115 | 694 | 86 |
224977 | 224977 | 2020-06-10 | Sarasota | Florida | 12115 | 705 | 88 |
228079 | 228079 | 2020-06-11 | Sarasota | Florida | 12115 | 716 | 89 |
231182 | 231182 | 2020-06-12 | Sarasota | Florida | 12115 | 724 | 89 |
234288 | 234288 | 2020-06-13 | Sarasota | Florida | 12115 | 741 | 91 |
237395 | 237395 | 2020-06-14 | Sarasota | Florida | 12115 | 767 | 91 |
240503 | 240503 | 2020-06-15 | Sarasota | Florida | 12115 | 780 | 91 |
243614 | 243614 | 2020-06-16 | Sarasota | Florida | 12115 | 789 | 92 |
246727 | 246727 | 2020-06-17 | Sarasota | Florida | 12115 | 803 | 92 |
249839 | 249839 | 2020-06-18 | Sarasota | Florida | 12115 | 833 | 92 |
252954 | 252954 | 2020-06-19 | Sarasota | Florida | 12115 | 868 | 92 |
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);