ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Seminole" and state = "Florida" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
256074 | 256074 | 2020-06-20 | Seminole | Florida | 12117 | 1189 | 14 |
259201 | 259201 | 2020-06-21 | Seminole | Florida | 12117 | 1265 | 15 |
262328 | 262328 | 2020-06-22 | Seminole | Florida | 12117 | 1361 | 16 |
265456 | 265456 | 2020-06-23 | Seminole | Florida | 12117 | 1451 | 16 |
268586 | 268586 | 2020-06-24 | Seminole | Florida | 12117 | 1624 | 16 |
271722 | 271722 | 2020-06-25 | Seminole | Florida | 12117 | 1768 | 16 |
274862 | 274862 | 2020-06-26 | Seminole | Florida | 12117 | 1966 | 16 |
278010 | 278010 | 2020-06-27 | Seminole | Florida | 12117 | 2202 | 16 |
281157 | 281157 | 2020-06-28 | Seminole | Florida | 12117 | 2366 | 16 |
284303 | 284303 | 2020-06-29 | Seminole | Florida | 12117 | 2477 | 16 |
287449 | 287449 | 2020-06-30 | Seminole | Florida | 12117 | 2566 | 16 |
290600 | 290600 | 2020-07-01 | Seminole | Florida | 12117 | 2682 | 17 |
293754 | 293754 | 2020-07-02 | Seminole | Florida | 12117 | 2837 | 17 |
296910 | 296910 | 2020-07-03 | Seminole | Florida | 12117 | 2987 | 20 |
300072 | 300072 | 2020-07-04 | Seminole | Florida | 12117 | 3205 | 20 |
303236 | 303236 | 2020-07-05 | Seminole | Florida | 12117 | 3339 | 20 |
306400 | 306400 | 2020-07-06 | Seminole | Florida | 12117 | 3430 | 20 |
309568 | 309568 | 2020-07-07 | Seminole | Florida | 12117 | 3522 | 20 |
312738 | 312738 | 2020-07-08 | Seminole | Florida | 12117 | 3652 | 20 |
315913 | 315913 | 2020-07-09 | Seminole | Florida | 12117 | 3806 | 21 |
319086 | 319086 | 2020-07-10 | Seminole | Florida | 12117 | 3967 | 21 |
322265 | 322265 | 2020-07-11 | Seminole | Florida | 12117 | 4083 | 23 |
325446 | 325446 | 2020-07-12 | Seminole | Florida | 12117 | 4229 | 24 |
328632 | 328632 | 2020-07-13 | Seminole | Florida | 12117 | 4466 | 24 |
331819 | 331819 | 2020-07-14 | Seminole | Florida | 12117 | 4536 | 25 |
335012 | 335012 | 2020-07-15 | Seminole | Florida | 12117 | 4665 | 28 |
338207 | 338207 | 2020-07-16 | Seminole | Florida | 12117 | 4842 | 31 |
341404 | 341404 | 2020-07-17 | Seminole | Florida | 12117 | 5030 | 33 |
344603 | 344603 | 2020-07-18 | Seminole | Florida | 12117 | 5150 | 41 |
347803 | 347803 | 2020-07-19 | Seminole | Florida | 12117 | 5329 | 43 |
351004 | 351004 | 2020-07-20 | Seminole | Florida | 12117 | 5411 | 45 |
354206 | 354206 | 2020-07-21 | Seminole | Florida | 12117 | 5519 | 46 |
357409 | 357409 | 2020-07-22 | Seminole | Florida | 12117 | 5633 | 51 |
360614 | 360614 | 2020-07-23 | Seminole | Florida | 12117 | 5736 | 56 |
363821 | 363821 | 2020-07-24 | Seminole | Florida | 12117 | 5852 | 60 |
367028 | 367028 | 2020-07-25 | Seminole | Florida | 12117 | 5969 | 65 |
370238 | 370238 | 2020-07-26 | Seminole | Florida | 12117 | 6034 | 66 |
373450 | 373450 | 2020-07-27 | Seminole | Florida | 12117 | 6116 | 68 |
376664 | 376664 | 2020-07-28 | Seminole | Florida | 12117 | 6231 | 71 |
379881 | 379881 | 2020-07-29 | Seminole | Florida | 12117 | 6333 | 72 |
383098 | 383098 | 2020-07-30 | Seminole | Florida | 12117 | 6419 | 72 |
386316 | 386316 | 2020-07-31 | Seminole | Florida | 12117 | 6487 | 82 |
389533 | 389533 | 2020-08-01 | Seminole | Florida | 12117 | 6566 | 84 |
392750 | 392750 | 2020-08-02 | Seminole | Florida | 12117 | 6639 | 87 |
395966 | 395966 | 2020-08-03 | Seminole | Florida | 12117 | 6687 | 88 |
399182 | 399182 | 2020-08-04 | Seminole | Florida | 12117 | 6760 | 89 |
402398 | 402398 | 2020-08-05 | Seminole | Florida | 12117 | 6826 | 105 |
405616 | 405616 | 2020-08-06 | Seminole | Florida | 12117 | 6932 | 109 |
408836 | 408836 | 2020-08-07 | Seminole | Florida | 12117 | 6976 | 110 |
412055 | 412055 | 2020-08-08 | Seminole | Florida | 12117 | 7048 | 118 |
415275 | 415275 | 2020-08-09 | Seminole | Florida | 12117 | 7118 | 119 |
418496 | 418496 | 2020-08-10 | Seminole | Florida | 12117 | 7152 | 119 |
421717 | 421717 | 2020-08-11 | Seminole | Florida | 12117 | 7219 | 130 |
424938 | 424938 | 2020-08-12 | Seminole | Florida | 12117 | 7264 | 137 |
428162 | 428162 | 2020-08-13 | Seminole | Florida | 12117 | 7323 | 138 |
431390 | 431390 | 2020-08-14 | Seminole | Florida | 12117 | 7370 | 143 |
434615 | 434615 | 2020-08-15 | Seminole | Florida | 12117 | 7424 | 145 |
437841 | 437841 | 2020-08-16 | Seminole | Florida | 12117 | 7471 | 145 |
441067 | 441067 | 2020-08-17 | Seminole | Florida | 12117 | 7492 | 145 |
444293 | 444293 | 2020-08-18 | Seminole | Florida | 12117 | 7530 | 151 |
447520 | 447520 | 2020-08-19 | Seminole | Florida | 12117 | 7568 | 153 |
450748 | 450748 | 2020-08-20 | Seminole | Florida | 12117 | 7641 | 152 |
453976 | 453976 | 2020-08-21 | Seminole | Florida | 12117 | 7673 | 160 |
457204 | 457204 | 2020-08-22 | Seminole | Florida | 12117 | 7735 | 161 |
460431 | 460431 | 2020-08-23 | Seminole | Florida | 12117 | 7756 | 162 |
463660 | 463660 | 2020-08-24 | Seminole | Florida | 12117 | 7778 | 163 |
466889 | 466889 | 2020-08-25 | Seminole | Florida | 12117 | 7811 | 164 |
470118 | 470118 | 2020-08-26 | Seminole | Florida | 12117 | 7839 | 169 |
473350 | 473350 | 2020-08-27 | Seminole | Florida | 12117 | 7896 | 169 |
476583 | 476583 | 2020-08-28 | Seminole | Florida | 12117 | 7934 | 172 |
479816 | 479816 | 2020-08-29 | Seminole | Florida | 12117 | 7979 | 172 |
483050 | 483050 | 2020-08-30 | Seminole | Florida | 12117 | 8006 | 172 |
486285 | 486285 | 2020-08-31 | Seminole | Florida | 12117 | 8029 | 172 |
489518 | 489518 | 2020-09-01 | Seminole | Florida | 12117 | 8173 | 173 |
492751 | 492751 | 2020-09-02 | Seminole | Florida | 12117 | 8198 | 173 |
495985 | 495985 | 2020-09-03 | Seminole | Florida | 12117 | 8240 | 175 |
499218 | 499218 | 2020-09-04 | Seminole | Florida | 12117 | 8299 | 177 |
502452 | 502452 | 2020-09-05 | Seminole | Florida | 12117 | 8325 | 179 |
505686 | 505686 | 2020-09-06 | Seminole | Florida | 12117 | 8361 | 182 |
508918 | 508918 | 2020-09-07 | Seminole | Florida | 12117 | 8382 | 182 |
512151 | 512151 | 2020-09-08 | Seminole | Florida | 12117 | 8412 | 183 |
515384 | 515384 | 2020-09-09 | Seminole | Florida | 12117 | 8437 | 184 |
518619 | 518619 | 2020-09-10 | Seminole | Florida | 12117 | 8459 | 189 |
521856 | 521856 | 2020-09-11 | Seminole | Florida | 12117 | 8492 | 193 |
525092 | 525092 | 2020-09-12 | Seminole | Florida | 12117 | 8532 | 193 |
528328 | 528328 | 2020-09-13 | Seminole | Florida | 12117 | 8552 | 193 |
531565 | 531565 | 2020-09-14 | Seminole | Florida | 12117 | 8568 | 193 |
534800 | 534800 | 2020-09-15 | Seminole | Florida | 12117 | 8613 | 193 |
538036 | 538036 | 2020-09-16 | Seminole | Florida | 12117 | 8635 | 196 |
541273 | 541273 | 2020-09-17 | Seminole | Florida | 12117 | 8694 | 197 |
544509 | 544509 | 2020-09-18 | Seminole | Florida | 12117 | 8742 | 199 |
547747 | 547747 | 2020-09-19 | Seminole | Florida | 12117 | 8794 | 200 |
550986 | 550986 | 2020-09-20 | Seminole | Florida | 12117 | 8836 | 200 |
554225 | 554225 | 2020-09-21 | Seminole | Florida | 12117 | 8860 | 200 |
557462 | 557462 | 2020-09-22 | Seminole | Florida | 12117 | 8887 | 200 |
560698 | 560698 | 2020-09-23 | Seminole | Florida | 12117 | 8911 | 207 |
563938 | 563938 | 2020-09-24 | Seminole | Florida | 12117 | 8909 | 207 |
567178 | 567178 | 2020-09-25 | Seminole | Florida | 12117 | 8946 | 207 |
570420 | 570420 | 2020-09-26 | Seminole | Florida | 12117 | 8972 | 208 |
573662 | 573662 | 2020-09-27 | Seminole | Florida | 12117 | 8998 | 208 |
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);