ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 12117 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 244 ✖
- 516 105
- 12 27
- 0 23
- 885 18
- 8 14
- 900 14
- 904 14
- 803 12
- 16 9
- 780 8
- 857 8
- 896 8
- 1065 8
- 11 7
- 745 7
- 833 7
- 866 7
- 914 7
- 922 7
- 935 7
- 979 7
- 1004 7
- 1022 7
- 1032 7
- 1057 7
- 1075 7
- 1082 7
- 1085 7
- 1088 7
- 1092 7
- 1095 7
- 1 6
- 2 6
- 13 6
- 20 6
- 449 6
- 843 6
- 891 6
- 1072 6
- 193 5
- 232 5
- 236 5
- 241 5
- 255 5
- 480 5
- 509 5
- 877 5
- 172 4
- 200 4
- 442 4
- 468 4
- 472 4
- 499 4
- 512 4
- 713 4
- 14 3
- 145 3
- 207 3
- 235 3
- 245 3
- 250 3
- 253 3
- 302 3
- 307 3
- 316 3
- 320 3
- 335 3
- 448 3
- 463 3
- 466 3
- 488 3
- 501 3
- 503 3
- 824 3
- 1096 3
- 4 2
- 5 2
- 6 2
- 17 2
- 21 2
- 24 2
- 72 2
- 119 2
- 169 2
- 173 2
- 182 2
- 208 2
- 228 2
- 233 2
- 266 2
- 267 2
- 268 2
- 274 2
- 276 2
- 283 2
- 301 2
- 303 2
- 311 2
- 314 2
- 317 2
- 340 2
- 353 2
- 358 2
- 373 2
- 382 2
- 387 2
- 389 2
- 398 2
- 404 2
- 405 2
- 411 2
- 418 2
- 422 2
- 423 2
- 430 2
- 443 2
- 445 2
- 470 2
- 473 2
- 478 2
- 482 2
- 486 2
- 493 2
- 504 2
- 510 2
- 3 1
- 7 1
- 10 1
- 15 1
- 23 1
- 25 1
- 28 1
- 31 1
- 33 1
- 41 1
- 43 1
- 45 1
- 46 1
- 51 1
- 56 1
- 60 1
- 65 1
- 66 1
- 68 1
- 71 1
- 82 1
- 84 1
- 87 1
- 88 1
- 89 1
- 105 1
- 109 1
- 110 1
- 118 1
- 130 1
- 137 1
- 138 1
- 143 1
- 151 1
- 152 1
- 153 1
- 160 1
- 161 1
- 162 1
- 163 1
- 164 1
- 175 1
- 177 1
- 179 1
- 183 1
- 184 1
- 189 1
- 196 1
- 197 1
- 199 1
- 209 1
- 211 1
- 214 1
- 216 1
- 222 1
- 226 1
- 227 1
- 229 1
- 230 1
- 231 1
- 234 1
- 237 1
- 238 1
- 243 1
- 258 1
- 259 1
- 261 1
- 265 1
- 273 1
- 279 1
- 280 1
- 282 1
- 284 1
- 289 1
- 290 1
- 291 1
- 294 1
- 296 1
- 297 1
- 299 1
- 300 1
- 305 1
- 309 1
- 313 1
- 319 1
- 324 1
- 326 1
- 329 1
- 333 1
- 341 1
- 346 1
- 359 1
- 363 1
- 369 1
- 372 1
- 378 1
- 385 1
- 386 1
- 394 1
- 396 1
- 399 1
- 410 1
- 419 1
- 434 1
- 437 1
- 438 1
- 444 1
- 450 1
- 461 1
- 471 1
- 475 1
- 476 1
- 477 1
- 487 1
- 489 1
- 495 1
- 497 1
- 507 1
- 508 1
state 1
- Florida 793
fips 1
- 12117 · 793 ✖
county 1
- Seminole 793
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
1427 | 1427 | 2020-03-12 | Seminole | Florida | 12117 | 1 | 0 |
1695 | 1695 | 2020-03-13 | Seminole | Florida | 12117 | 1 | 0 |
2017 | 2017 | 2020-03-14 | Seminole | Florida | 12117 | 1 | 0 |
2401 | 2401 | 2020-03-15 | Seminole | Florida | 12117 | 1 | 0 |
2838 | 2838 | 2020-03-16 | Seminole | Florida | 12117 | 4 | 0 |
3323 | 3323 | 2020-03-17 | Seminole | Florida | 12117 | 4 | 0 |
3881 | 3881 | 2020-03-18 | Seminole | Florida | 12117 | 7 | 0 |
4550 | 4550 | 2020-03-19 | Seminole | Florida | 12117 | 13 | 0 |
5330 | 5330 | 2020-03-20 | Seminole | Florida | 12117 | 13 | 0 |
6261 | 6261 | 2020-03-21 | Seminole | Florida | 12117 | 13 | 0 |
7301 | 7301 | 2020-03-22 | Seminole | Florida | 12117 | 19 | 0 |
8447 | 8447 | 2020-03-23 | Seminole | Florida | 12117 | 22 | 0 |
9692 | 9692 | 2020-03-24 | Seminole | Florida | 12117 | 25 | 0 |
11067 | 11067 | 2020-03-25 | Seminole | Florida | 12117 | 32 | 0 |
12615 | 12615 | 2020-03-26 | Seminole | Florida | 12117 | 40 | 0 |
14285 | 14285 | 2020-03-27 | Seminole | Florida | 12117 | 54 | 0 |
16070 | 16070 | 2020-03-28 | Seminole | Florida | 12117 | 68 | 0 |
17963 | 17963 | 2020-03-29 | Seminole | Florida | 12117 | 81 | 0 |
19944 | 19944 | 2020-03-30 | Seminole | Florida | 12117 | 88 | 0 |
22022 | 22022 | 2020-03-31 | Seminole | Florida | 12117 | 103 | 0 |
24185 | 24185 | 2020-04-01 | Seminole | Florida | 12117 | 128 | 0 |
26415 | 26415 | 2020-04-02 | Seminole | Florida | 12117 | 145 | 0 |
28718 | 28718 | 2020-04-03 | Seminole | Florida | 12117 | 163 | 0 |
31078 | 31078 | 2020-04-04 | Seminole | Florida | 12117 | 178 | 1 |
33484 | 33484 | 2020-04-05 | Seminole | Florida | 12117 | 191 | 1 |
35930 | 35930 | 2020-04-06 | Seminole | Florida | 12117 | 195 | 1 |
38421 | 38421 | 2020-04-07 | Seminole | Florida | 12117 | 202 | 1 |
40965 | 40965 | 2020-04-08 | Seminole | Florida | 12117 | 218 | 1 |
43539 | 43539 | 2020-04-09 | Seminole | Florida | 12117 | 229 | 1 |
46141 | 46141 | 2020-04-10 | Seminole | Florida | 12117 | 238 | 2 |
48771 | 48771 | 2020-04-11 | Seminole | Florida | 12117 | 242 | 2 |
51432 | 51432 | 2020-04-12 | Seminole | Florida | 12117 | 255 | 2 |
54112 | 54112 | 2020-04-13 | Seminole | Florida | 12117 | 268 | 2 |
56804 | 56804 | 2020-04-14 | Seminole | Florida | 12117 | 275 | 2 |
59512 | 59512 | 2020-04-15 | Seminole | Florida | 12117 | 284 | 2 |
62231 | 62231 | 2020-04-16 | Seminole | Florida | 12117 | 306 | 3 |
64964 | 64964 | 2020-04-17 | Seminole | Florida | 12117 | 313 | 4 |
67712 | 67712 | 2020-04-18 | Seminole | Florida | 12117 | 315 | 4 |
70474 | 70474 | 2020-04-19 | Seminole | Florida | 12117 | 320 | 5 |
73243 | 73243 | 2020-04-20 | Seminole | Florida | 12117 | 325 | 5 |
76019 | 76019 | 2020-04-21 | Seminole | Florida | 12117 | 328 | 6 |
78803 | 78803 | 2020-04-22 | Seminole | Florida | 12117 | 332 | 6 |
81597 | 81597 | 2020-04-23 | Seminole | Florida | 12117 | 340 | 7 |
84397 | 84397 | 2020-04-24 | Seminole | Florida | 12117 | 348 | 8 |
87205 | 87205 | 2020-04-25 | Seminole | Florida | 12117 | 351 | 8 |
90022 | 90022 | 2020-04-26 | Seminole | Florida | 12117 | 357 | 8 |
92840 | 92840 | 2020-04-27 | Seminole | Florida | 12117 | 367 | 8 |
95672 | 95672 | 2020-04-28 | Seminole | Florida | 12117 | 374 | 8 |
98517 | 98517 | 2020-04-29 | Seminole | Florida | 12117 | 373 | 8 |
101367 | 101367 | 2020-04-30 | Seminole | Florida | 12117 | 379 | 8 |
104222 | 104222 | 2020-05-01 | Seminole | Florida | 12117 | 385 | 8 |
107087 | 107087 | 2020-05-02 | Seminole | Florida | 12117 | 395 | 8 |
109956 | 109956 | 2020-05-03 | Seminole | Florida | 12117 | 394 | 8 |
112831 | 112831 | 2020-05-04 | Seminole | Florida | 12117 | 396 | 8 |
115714 | 115714 | 2020-05-05 | Seminole | Florida | 12117 | 403 | 8 |
118674 | 118674 | 2020-05-06 | Seminole | Florida | 12117 | 408 | 8 |
121643 | 121643 | 2020-05-07 | Seminole | Florida | 12117 | 410 | 8 |
124622 | 124622 | 2020-05-08 | Seminole | Florida | 12117 | 410 | 10 |
127609 | 127609 | 2020-05-09 | Seminole | Florida | 12117 | 411 | 11 |
130600 | 130600 | 2020-05-10 | Seminole | Florida | 12117 | 415 | 11 |
133591 | 133591 | 2020-05-11 | Seminole | Florida | 12117 | 415 | 11 |
136580 | 136580 | 2020-05-12 | Seminole | Florida | 12117 | 418 | 11 |
139571 | 139571 | 2020-05-13 | Seminole | Florida | 12117 | 422 | 11 |
142567 | 142567 | 2020-05-14 | Seminole | Florida | 12117 | 426 | 11 |
145567 | 145567 | 2020-05-15 | Seminole | Florida | 12117 | 429 | 11 |
148570 | 148570 | 2020-05-16 | Seminole | Florida | 12117 | 431 | 12 |
151579 | 151579 | 2020-05-17 | Seminole | Florida | 12117 | 432 | 12 |
154591 | 154591 | 2020-05-18 | Seminole | Florida | 12117 | 435 | 12 |
157607 | 157607 | 2020-05-19 | Seminole | Florida | 12117 | 442 | 12 |
160633 | 160633 | 2020-05-20 | Seminole | Florida | 12117 | 444 | 13 |
163661 | 163661 | 2020-05-21 | Seminole | Florida | 12117 | 445 | 12 |
166694 | 166694 | 2020-05-22 | Seminole | Florida | 12117 | 449 | 12 |
169731 | 169731 | 2020-05-23 | Seminole | Florida | 12117 | 454 | 12 |
172772 | 172772 | 2020-05-24 | Seminole | Florida | 12117 | 459 | 12 |
175815 | 175815 | 2020-05-25 | Seminole | Florida | 12117 | 461 | 12 |
178859 | 178859 | 2020-05-26 | Seminole | Florida | 12117 | 465 | 12 |
181903 | 181903 | 2020-05-27 | Seminole | Florida | 12117 | 471 | 12 |
184957 | 184957 | 2020-05-28 | Seminole | Florida | 12117 | 474 | 12 |
188013 | 188013 | 2020-05-29 | Seminole | Florida | 12117 | 481 | 12 |
191078 | 191078 | 2020-05-30 | Seminole | Florida | 12117 | 484 | 12 |
194145 | 194145 | 2020-05-31 | Seminole | Florida | 12117 | 490 | 12 |
197215 | 197215 | 2020-06-01 | Seminole | Florida | 12117 | 491 | 12 |
200288 | 200288 | 2020-06-02 | Seminole | Florida | 12117 | 493 | 12 |
203364 | 203364 | 2020-06-03 | Seminole | Florida | 12117 | 505 | 12 |
206444 | 206444 | 2020-06-04 | Seminole | Florida | 12117 | 512 | 12 |
209525 | 209525 | 2020-06-05 | Seminole | Florida | 12117 | 515 | 12 |
212610 | 212610 | 2020-06-06 | Seminole | Florida | 12117 | 521 | 12 |
215697 | 215697 | 2020-06-07 | Seminole | Florida | 12117 | 532 | 12 |
218788 | 218788 | 2020-06-08 | Seminole | Florida | 12117 | 542 | 12 |
221883 | 221883 | 2020-06-09 | Seminole | Florida | 12117 | 556 | 12 |
224978 | 224978 | 2020-06-10 | Seminole | Florida | 12117 | 585 | 12 |
228080 | 228080 | 2020-06-11 | Seminole | Florida | 12117 | 621 | 12 |
231183 | 231183 | 2020-06-12 | Seminole | Florida | 12117 | 663 | 12 |
234289 | 234289 | 2020-06-13 | Seminole | Florida | 12117 | 709 | 13 |
237396 | 237396 | 2020-06-14 | Seminole | Florida | 12117 | 759 | 13 |
240504 | 240504 | 2020-06-15 | Seminole | Florida | 12117 | 790 | 13 |
243615 | 243615 | 2020-06-16 | Seminole | Florida | 12117 | 836 | 13 |
246728 | 246728 | 2020-06-17 | Seminole | Florida | 12117 | 876 | 13 |
249840 | 249840 | 2020-06-18 | Seminole | Florida | 12117 | 976 | 14 |
252955 | 252955 | 2020-06-19 | Seminole | Florida | 12117 | 1101 | 14 |
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);