ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 12117 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386316 | 386316 | 2020-07-31 | Seminole | Florida | 12117 | 6487 | 82 |
383098 | 383098 | 2020-07-30 | Seminole | Florida | 12117 | 6419 | 72 |
379881 | 379881 | 2020-07-29 | Seminole | Florida | 12117 | 6333 | 72 |
376664 | 376664 | 2020-07-28 | Seminole | Florida | 12117 | 6231 | 71 |
373450 | 373450 | 2020-07-27 | Seminole | Florida | 12117 | 6116 | 68 |
370238 | 370238 | 2020-07-26 | Seminole | Florida | 12117 | 6034 | 66 |
367028 | 367028 | 2020-07-25 | Seminole | Florida | 12117 | 5969 | 65 |
363821 | 363821 | 2020-07-24 | Seminole | Florida | 12117 | 5852 | 60 |
360614 | 360614 | 2020-07-23 | Seminole | Florida | 12117 | 5736 | 56 |
357409 | 357409 | 2020-07-22 | Seminole | Florida | 12117 | 5633 | 51 |
354206 | 354206 | 2020-07-21 | Seminole | Florida | 12117 | 5519 | 46 |
351004 | 351004 | 2020-07-20 | Seminole | Florida | 12117 | 5411 | 45 |
347803 | 347803 | 2020-07-19 | Seminole | Florida | 12117 | 5329 | 43 |
344603 | 344603 | 2020-07-18 | Seminole | Florida | 12117 | 5150 | 41 |
341404 | 341404 | 2020-07-17 | Seminole | Florida | 12117 | 5030 | 33 |
338207 | 338207 | 2020-07-16 | Seminole | Florida | 12117 | 4842 | 31 |
335012 | 335012 | 2020-07-15 | Seminole | Florida | 12117 | 4665 | 28 |
331819 | 331819 | 2020-07-14 | Seminole | Florida | 12117 | 4536 | 25 |
328632 | 328632 | 2020-07-13 | Seminole | Florida | 12117 | 4466 | 24 |
325446 | 325446 | 2020-07-12 | Seminole | Florida | 12117 | 4229 | 24 |
322265 | 322265 | 2020-07-11 | Seminole | Florida | 12117 | 4083 | 23 |
319086 | 319086 | 2020-07-10 | Seminole | Florida | 12117 | 3967 | 21 |
315913 | 315913 | 2020-07-09 | Seminole | Florida | 12117 | 3806 | 21 |
312738 | 312738 | 2020-07-08 | Seminole | Florida | 12117 | 3652 | 20 |
309568 | 309568 | 2020-07-07 | Seminole | Florida | 12117 | 3522 | 20 |
306400 | 306400 | 2020-07-06 | Seminole | Florida | 12117 | 3430 | 20 |
303236 | 303236 | 2020-07-05 | Seminole | Florida | 12117 | 3339 | 20 |
300072 | 300072 | 2020-07-04 | Seminole | Florida | 12117 | 3205 | 20 |
296910 | 296910 | 2020-07-03 | Seminole | Florida | 12117 | 2987 | 20 |
293754 | 293754 | 2020-07-02 | Seminole | Florida | 12117 | 2837 | 17 |
290600 | 290600 | 2020-07-01 | Seminole | Florida | 12117 | 2682 | 17 |
287449 | 287449 | 2020-06-30 | Seminole | Florida | 12117 | 2566 | 16 |
284303 | 284303 | 2020-06-29 | Seminole | Florida | 12117 | 2477 | 16 |
281157 | 281157 | 2020-06-28 | Seminole | Florida | 12117 | 2366 | 16 |
278010 | 278010 | 2020-06-27 | Seminole | Florida | 12117 | 2202 | 16 |
274862 | 274862 | 2020-06-26 | Seminole | Florida | 12117 | 1966 | 16 |
271722 | 271722 | 2020-06-25 | Seminole | Florida | 12117 | 1768 | 16 |
268586 | 268586 | 2020-06-24 | Seminole | Florida | 12117 | 1624 | 16 |
265456 | 265456 | 2020-06-23 | Seminole | Florida | 12117 | 1451 | 16 |
262328 | 262328 | 2020-06-22 | Seminole | Florida | 12117 | 1361 | 16 |
259201 | 259201 | 2020-06-21 | Seminole | Florida | 12117 | 1265 | 15 |
256074 | 256074 | 2020-06-20 | Seminole | Florida | 12117 | 1189 | 14 |
252955 | 252955 | 2020-06-19 | Seminole | Florida | 12117 | 1101 | 14 |
249840 | 249840 | 2020-06-18 | Seminole | Florida | 12117 | 976 | 14 |
246728 | 246728 | 2020-06-17 | Seminole | Florida | 12117 | 876 | 13 |
243615 | 243615 | 2020-06-16 | Seminole | Florida | 12117 | 836 | 13 |
240504 | 240504 | 2020-06-15 | Seminole | Florida | 12117 | 790 | 13 |
237396 | 237396 | 2020-06-14 | Seminole | Florida | 12117 | 759 | 13 |
234289 | 234289 | 2020-06-13 | Seminole | Florida | 12117 | 709 | 13 |
231183 | 231183 | 2020-06-12 | Seminole | Florida | 12117 | 663 | 12 |
228080 | 228080 | 2020-06-11 | Seminole | Florida | 12117 | 621 | 12 |
224978 | 224978 | 2020-06-10 | Seminole | Florida | 12117 | 585 | 12 |
221883 | 221883 | 2020-06-09 | Seminole | Florida | 12117 | 556 | 12 |
218788 | 218788 | 2020-06-08 | Seminole | Florida | 12117 | 542 | 12 |
215697 | 215697 | 2020-06-07 | Seminole | Florida | 12117 | 532 | 12 |
212610 | 212610 | 2020-06-06 | Seminole | Florida | 12117 | 521 | 12 |
209525 | 209525 | 2020-06-05 | Seminole | Florida | 12117 | 515 | 12 |
206444 | 206444 | 2020-06-04 | Seminole | Florida | 12117 | 512 | 12 |
203364 | 203364 | 2020-06-03 | Seminole | Florida | 12117 | 505 | 12 |
200288 | 200288 | 2020-06-02 | Seminole | Florida | 12117 | 493 | 12 |
197215 | 197215 | 2020-06-01 | Seminole | Florida | 12117 | 491 | 12 |
194145 | 194145 | 2020-05-31 | Seminole | Florida | 12117 | 490 | 12 |
191078 | 191078 | 2020-05-30 | Seminole | Florida | 12117 | 484 | 12 |
188013 | 188013 | 2020-05-29 | Seminole | Florida | 12117 | 481 | 12 |
184957 | 184957 | 2020-05-28 | Seminole | Florida | 12117 | 474 | 12 |
181903 | 181903 | 2020-05-27 | Seminole | Florida | 12117 | 471 | 12 |
178859 | 178859 | 2020-05-26 | Seminole | Florida | 12117 | 465 | 12 |
175815 | 175815 | 2020-05-25 | Seminole | Florida | 12117 | 461 | 12 |
172772 | 172772 | 2020-05-24 | Seminole | Florida | 12117 | 459 | 12 |
169731 | 169731 | 2020-05-23 | Seminole | Florida | 12117 | 454 | 12 |
166694 | 166694 | 2020-05-22 | Seminole | Florida | 12117 | 449 | 12 |
163661 | 163661 | 2020-05-21 | Seminole | Florida | 12117 | 445 | 12 |
160633 | 160633 | 2020-05-20 | Seminole | Florida | 12117 | 444 | 13 |
157607 | 157607 | 2020-05-19 | Seminole | Florida | 12117 | 442 | 12 |
154591 | 154591 | 2020-05-18 | Seminole | Florida | 12117 | 435 | 12 |
151579 | 151579 | 2020-05-17 | Seminole | Florida | 12117 | 432 | 12 |
148570 | 148570 | 2020-05-16 | Seminole | Florida | 12117 | 431 | 12 |
145567 | 145567 | 2020-05-15 | Seminole | Florida | 12117 | 429 | 11 |
142567 | 142567 | 2020-05-14 | Seminole | Florida | 12117 | 426 | 11 |
139571 | 139571 | 2020-05-13 | Seminole | Florida | 12117 | 422 | 11 |
136580 | 136580 | 2020-05-12 | Seminole | Florida | 12117 | 418 | 11 |
133591 | 133591 | 2020-05-11 | Seminole | Florida | 12117 | 415 | 11 |
130600 | 130600 | 2020-05-10 | Seminole | Florida | 12117 | 415 | 11 |
127609 | 127609 | 2020-05-09 | Seminole | Florida | 12117 | 411 | 11 |
124622 | 124622 | 2020-05-08 | Seminole | Florida | 12117 | 410 | 10 |
121643 | 121643 | 2020-05-07 | Seminole | Florida | 12117 | 410 | 8 |
118674 | 118674 | 2020-05-06 | Seminole | Florida | 12117 | 408 | 8 |
115714 | 115714 | 2020-05-05 | Seminole | Florida | 12117 | 403 | 8 |
112831 | 112831 | 2020-05-04 | Seminole | Florida | 12117 | 396 | 8 |
109956 | 109956 | 2020-05-03 | Seminole | Florida | 12117 | 394 | 8 |
107087 | 107087 | 2020-05-02 | Seminole | Florida | 12117 | 395 | 8 |
104222 | 104222 | 2020-05-01 | Seminole | Florida | 12117 | 385 | 8 |
101367 | 101367 | 2020-04-30 | Seminole | Florida | 12117 | 379 | 8 |
98517 | 98517 | 2020-04-29 | Seminole | Florida | 12117 | 373 | 8 |
95672 | 95672 | 2020-04-28 | Seminole | Florida | 12117 | 374 | 8 |
92840 | 92840 | 2020-04-27 | Seminole | Florida | 12117 | 367 | 8 |
90022 | 90022 | 2020-04-26 | Seminole | Florida | 12117 | 357 | 8 |
87205 | 87205 | 2020-04-25 | Seminole | Florida | 12117 | 351 | 8 |
84397 | 84397 | 2020-04-24 | Seminole | Florida | 12117 | 348 | 8 |
81597 | 81597 | 2020-04-23 | Seminole | Florida | 12117 | 340 | 7 |
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);