ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Collier" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 274 ✖
- 551 104
- 0 19
- 869 18
- 962 14
- 992 14
- 998 14
- 773 12
- 505 8
- 720 8
- 854 8
- 878 8
- 980 8
- 49 7
- 85 7
- 719 7
- 833 7
- 862 7
- 881 7
- 884 7
- 886 7
- 889 7
- 894 7
- 904 7
- 926 7
- 946 7
- 969 7
- 970 7
- 987 7
- 995 7
- 256 6
- 849 6
- 875 6
- 984 6
- 3 5
- 27 5
- 60 5
- 267 5
- 490 5
- 492 5
- 542 5
- 544 5
- 867 5
- 1 4
- 2 4
- 15 4
- 37 4
- 192 4
- 228 4
- 259 4
- 280 4
- 386 4
- 516 4
- 538 4
- 713 4
- 5 3
- 8 3
- 21 3
- 46 3
- 57 3
- 64 3
- 70 3
- 94 3
- 117 3
- 124 3
- 163 3
- 176 3
- 184 3
- 202 3
- 216 3
- 249 3
- 253 3
- 255 3
- 279 3
- 363 3
- 404 3
- 422 3
- 459 3
- 465 3
- 481 3
- 506 3
- 514 3
- 528 3
- 539 3
- 823 3
- 1000 3
- 4 2
- 10 2
- 40 2
- 45 2
- 56 2
- 59 2
- 61 2
- 71 2
- 107 2
- 114 2
- 120 2
- 129 2
- 136 2
- 151 2
- 180 2
- 211 2
- 234 2
- 237 2
- 239 2
- 268 2
- 273 2
- 276 2
- 303 2
- 308 2
- 310 2
- 315 2
- 317 2
- 325 2
- 326 2
- 332 2
- 339 2
- 420 2
- 430 2
- 440 2
- 443 2
- 461 2
- 472 2
- 498 2
- 517 2
- 531 2
- 533 2
- 535 2
- 6 1
- 9 1
- 14 1
- 16 1
- 17 1
- 19 1
- 22 1
- 25 1
- 28 1
- 32 1
- 34 1
- 35 1
- 41 1
- 42 1
- 53 1
- 55 1
- 65 1
- 67 1
- 74 1
- 81 1
- 82 1
- 91 1
- 96 1
- 99 1
- 100 1
- 104 1
- 105 1
- 109 1
- 118 1
- 121 1
- 122 1
- 130 1
- 131 1
- 133 1
- 143 1
- 146 1
- 148 1
- 152 1
- 154 1
- 159 1
- 160 1
- 161 1
- 162 1
- 166 1
- 170 1
- 172 1
- 174 1
- 177 1
- 181 1
- 182 1
- 187 1
- 188 1
- 193 1
- 194 1
- 196 1
- 201 1
- 205 1
- 208 1
- 218 1
- 221 1
- 224 1
- 225 1
- 230 1
- 232 1
- 242 1
- 243 1
- 244 1
- 245 1
- 246 1
- 251 1
- 260 1
- 261 1
- 265 1
- 269 1
- 281 1
- 284 1
- 285 1
- 289 1
- 293 1
- 294 1
- 295 1
- 299 1
- 306 1
- 312 1
- 314 1
- 321 1
- 322 1
- 328 1
- 331 1
- 333 1
- 341 1
- 346 1
- 350 1
- 354 1
- 360 1
- 361 1
- 367 1
- 370 1
- 371 1
- 375 1
- 376 1
- 377 1
- 381 1
- 382 1
- 394 1
- 396 1
- 398 1
- 402 1
- 403 1
- 410 1
- 413 1
- 414 1
- 419 1
- 426 1
- 428 1
- 431 1
- 433 1
- 434 1
- 438 1
- 448 1
- 450 1
- 452 1
- 462 1
- 463 1
- 464 1
- 469 1
- 477 1
- 479 1
- 480 1
- 484 1
- 488 1
- 496 1
- 500 1
- 504 1
- 507 1
- 510 1
- 515 1
- 522 1
- 524 1
- 525 1
- 527 1
- 530 1
- 532 1
- 536 1
- 540 1
- 543 1
- 549 1
state 1
- Florida 795
fips 1
- 12021 795
county 1
- Collier · 795 ✖
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
1035 | 1035 | 2020-03-10 | Collier | Florida | 12021 | 3 | 0 |
1204 | 1204 | 2020-03-11 | Collier | Florida | 12021 | 3 | 0 |
1414 | 1414 | 2020-03-12 | Collier | Florida | 12021 | 3 | 0 |
1680 | 1680 | 2020-03-13 | Collier | Florida | 12021 | 3 | 0 |
2002 | 2002 | 2020-03-14 | Collier | Florida | 12021 | 3 | 0 |
2386 | 2386 | 2020-03-15 | Collier | Florida | 12021 | 5 | 0 |
2821 | 2821 | 2020-03-16 | Collier | Florida | 12021 | 6 | 0 |
3305 | 3305 | 2020-03-17 | Collier | Florida | 12021 | 7 | 0 |
3862 | 3862 | 2020-03-18 | Collier | Florida | 12021 | 13 | 0 |
4527 | 4527 | 2020-03-19 | Collier | Florida | 12021 | 18 | 0 |
5306 | 5306 | 2020-03-20 | Collier | Florida | 12021 | 25 | 0 |
6234 | 6234 | 2020-03-21 | Collier | Florida | 12021 | 28 | 0 |
7271 | 7271 | 2020-03-22 | Collier | Florida | 12021 | 33 | 0 |
8417 | 8417 | 2020-03-23 | Collier | Florida | 12021 | 39 | 0 |
9662 | 9662 | 2020-03-24 | Collier | Florida | 12021 | 41 | 0 |
11036 | 11036 | 2020-03-25 | Collier | Florida | 12021 | 57 | 0 |
12584 | 12584 | 2020-03-26 | Collier | Florida | 12021 | 67 | 0 |
14253 | 14253 | 2020-03-27 | Collier | Florida | 12021 | 85 | 0 |
16037 | 16037 | 2020-03-28 | Collier | Florida | 12021 | 95 | 0 |
17929 | 17929 | 2020-03-29 | Collier | Florida | 12021 | 111 | 1 |
19909 | 19909 | 2020-03-30 | Collier | Florida | 12021 | 127 | 1 |
21987 | 21987 | 2020-03-31 | Collier | Florida | 12021 | 146 | 1 |
24146 | 24146 | 2020-04-01 | Collier | Florida | 12021 | 158 | 1 |
26376 | 26376 | 2020-04-02 | Collier | Florida | 12021 | 178 | 2 |
28678 | 28678 | 2020-04-03 | Collier | Florida | 12021 | 203 | 2 |
31036 | 31036 | 2020-04-04 | Collier | Florida | 12021 | 221 | 2 |
33442 | 33442 | 2020-04-05 | Collier | Florida | 12021 | 231 | 2 |
35887 | 35887 | 2020-04-06 | Collier | Florida | 12021 | 249 | 3 |
38377 | 38377 | 2020-04-07 | Collier | Florida | 12021 | 271 | 3 |
40920 | 40920 | 2020-04-08 | Collier | Florida | 12021 | 282 | 3 |
43494 | 43494 | 2020-04-09 | Collier | Florida | 12021 | 303 | 3 |
46095 | 46095 | 2020-04-10 | Collier | Florida | 12021 | 327 | 3 |
48725 | 48725 | 2020-04-11 | Collier | Florida | 12021 | 352 | 4 |
51386 | 51386 | 2020-04-12 | Collier | Florida | 12021 | 361 | 4 |
54066 | 54066 | 2020-04-13 | Collier | Florida | 12021 | 376 | 5 |
56758 | 56758 | 2020-04-14 | Collier | Florida | 12021 | 380 | 5 |
59466 | 59466 | 2020-04-15 | Collier | Florida | 12021 | 396 | 5 |
62185 | 62185 | 2020-04-16 | Collier | Florida | 12021 | 416 | 6 |
64918 | 64918 | 2020-04-17 | Collier | Florida | 12021 | 445 | 8 |
67666 | 67666 | 2020-04-18 | Collier | Florida | 12021 | 457 | 8 |
70428 | 70428 | 2020-04-19 | Collier | Florida | 12021 | 463 | 8 |
73197 | 73197 | 2020-04-20 | Collier | Florida | 12021 | 470 | 9 |
75973 | 75973 | 2020-04-21 | Collier | Florida | 12021 | 477 | 10 |
78757 | 78757 | 2020-04-22 | Collier | Florida | 12021 | 483 | 10 |
81551 | 81551 | 2020-04-23 | Collier | Florida | 12021 | 507 | 14 |
84351 | 84351 | 2020-04-24 | Collier | Florida | 12021 | 526 | 15 |
87159 | 87159 | 2020-04-25 | Collier | Florida | 12021 | 535 | 15 |
89976 | 89976 | 2020-04-26 | Collier | Florida | 12021 | 552 | 15 |
92794 | 92794 | 2020-04-27 | Collier | Florida | 12021 | 562 | 15 |
95626 | 95626 | 2020-04-28 | Collier | Florida | 12021 | 568 | 16 |
98471 | 98471 | 2020-04-29 | Collier | Florida | 12021 | 581 | 17 |
101321 | 101321 | 2020-04-30 | Collier | Florida | 12021 | 596 | 19 |
104176 | 104176 | 2020-05-01 | Collier | Florida | 12021 | 610 | 21 |
107041 | 107041 | 2020-05-02 | Collier | Florida | 12021 | 628 | 21 |
109910 | 109910 | 2020-05-03 | Collier | Florida | 12021 | 640 | 21 |
112785 | 112785 | 2020-05-04 | Collier | Florida | 12021 | 653 | 22 |
115668 | 115668 | 2020-05-05 | Collier | Florida | 12021 | 656 | 25 |
118628 | 118628 | 2020-05-06 | Collier | Florida | 12021 | 677 | 27 |
121597 | 121597 | 2020-05-07 | Collier | Florida | 12021 | 705 | 27 |
124576 | 124576 | 2020-05-08 | Collier | Florida | 12021 | 712 | 27 |
127563 | 127563 | 2020-05-09 | Collier | Florida | 12021 | 734 | 27 |
130554 | 130554 | 2020-05-10 | Collier | Florida | 12021 | 752 | 27 |
133545 | 133545 | 2020-05-11 | Collier | Florida | 12021 | 766 | 28 |
136534 | 136534 | 2020-05-12 | Collier | Florida | 12021 | 843 | 32 |
139525 | 139525 | 2020-05-13 | Collier | Florida | 12021 | 864 | 34 |
142521 | 142521 | 2020-05-14 | Collier | Florida | 12021 | 882 | 35 |
145521 | 145521 | 2020-05-15 | Collier | Florida | 12021 | 915 | 37 |
148524 | 148524 | 2020-05-16 | Collier | Florida | 12021 | 923 | 37 |
151533 | 151533 | 2020-05-17 | Collier | Florida | 12021 | 948 | 37 |
154545 | 154545 | 2020-05-18 | Collier | Florida | 12021 | 1006 | 37 |
157561 | 157561 | 2020-05-19 | Collier | Florida | 12021 | 1030 | 40 |
160587 | 160587 | 2020-05-20 | Collier | Florida | 12021 | 1058 | 40 |
163615 | 163615 | 2020-05-21 | Collier | Florida | 12021 | 1112 | 41 |
166648 | 166648 | 2020-05-22 | Collier | Florida | 12021 | 1160 | 42 |
169685 | 169685 | 2020-05-23 | Collier | Florida | 12021 | 1195 | 45 |
172726 | 172726 | 2020-05-24 | Collier | Florida | 12021 | 1251 | 45 |
175769 | 175769 | 2020-05-25 | Collier | Florida | 12021 | 1282 | 46 |
178813 | 178813 | 2020-05-26 | Collier | Florida | 12021 | 1305 | 46 |
181857 | 181857 | 2020-05-27 | Collier | Florida | 12021 | 1334 | 46 |
184911 | 184911 | 2020-05-28 | Collier | Florida | 12021 | 1401 | 49 |
187967 | 187967 | 2020-05-29 | Collier | Florida | 12021 | 1454 | 49 |
191032 | 191032 | 2020-05-30 | Collier | Florida | 12021 | 1514 | 49 |
194099 | 194099 | 2020-05-31 | Collier | Florida | 12021 | 1539 | 49 |
197169 | 197169 | 2020-06-01 | Collier | Florida | 12021 | 1580 | 49 |
200242 | 200242 | 2020-06-02 | Collier | Florida | 12021 | 1605 | 49 |
203318 | 203318 | 2020-06-03 | Collier | Florida | 12021 | 1679 | 49 |
206398 | 206398 | 2020-06-04 | Collier | Florida | 12021 | 1814 | 53 |
209479 | 209479 | 2020-06-05 | Collier | Florida | 12021 | 1874 | 55 |
212564 | 212564 | 2020-06-06 | Collier | Florida | 12021 | 1968 | 56 |
215651 | 215651 | 2020-06-07 | Collier | Florida | 12021 | 2039 | 56 |
218742 | 218742 | 2020-06-08 | Collier | Florida | 12021 | 2070 | 57 |
221837 | 221837 | 2020-06-09 | Collier | Florida | 12021 | 2128 | 57 |
224932 | 224932 | 2020-06-10 | Collier | Florida | 12021 | 2230 | 57 |
228034 | 228034 | 2020-06-11 | Collier | Florida | 12021 | 2291 | 59 |
231137 | 231137 | 2020-06-12 | Collier | Florida | 12021 | 2364 | 59 |
234243 | 234243 | 2020-06-13 | Collier | Florida | 12021 | 2435 | 60 |
237350 | 237350 | 2020-06-14 | Collier | Florida | 12021 | 2526 | 60 |
240458 | 240458 | 2020-06-15 | Collier | Florida | 12021 | 2592 | 60 |
243569 | 243569 | 2020-06-16 | Collier | Florida | 12021 | 2729 | 60 |
246682 | 246682 | 2020-06-17 | Collier | Florida | 12021 | 2817 | 60 |
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);