ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
110 rows where deaths = 78 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490145 | 2490145 | 2022-05-10 | Gulf | Florida | 12045 | 4292 | 78 |
2486888 | 2486888 | 2022-05-09 | Gulf | Florida | 12045 | 4292 | 78 |
2483630 | 2483630 | 2022-05-08 | Gulf | Florida | 12045 | 4292 | 78 |
2480372 | 2480372 | 2022-05-07 | Gulf | Florida | 12045 | 4292 | 78 |
2477114 | 2477114 | 2022-05-06 | Gulf | Florida | 12045 | 4292 | 78 |
2473856 | 2473856 | 2022-05-05 | Gulf | Florida | 12045 | 4283 | 78 |
2470599 | 2470599 | 2022-05-04 | Gulf | Florida | 12045 | 4283 | 78 |
2216832 | 2216832 | 2022-02-15 | Holmes | Florida | 12059 | 5303 | 78 |
2213581 | 2213581 | 2022-02-14 | Holmes | Florida | 12059 | 5303 | 78 |
2210329 | 2210329 | 2022-02-13 | Holmes | Florida | 12059 | 5303 | 78 |
2207076 | 2207076 | 2022-02-12 | Holmes | Florida | 12059 | 5303 | 78 |
2203823 | 2203823 | 2022-02-11 | Holmes | Florida | 12059 | 5303 | 78 |
2200570 | 2200570 | 2022-02-10 | Holmes | Florida | 12059 | 5214 | 78 |
2197316 | 2197316 | 2022-02-09 | Holmes | Florida | 12059 | 5214 | 78 |
1823497 | 1823497 | 2021-10-17 | Union | Florida | 12125 | 3056 | 78 |
1820248 | 1820248 | 2021-10-16 | Union | Florida | 12125 | 3056 | 78 |
1816999 | 1816999 | 2021-10-15 | Union | Florida | 12125 | 3056 | 78 |
1813751 | 1813751 | 2021-10-14 | Union | Florida | 12125 | 3049 | 78 |
1810502 | 1810502 | 2021-10-13 | Union | Florida | 12125 | 3049 | 78 |
1807253 | 1807253 | 2021-10-12 | Union | Florida | 12125 | 3049 | 78 |
1804002 | 1804002 | 2021-10-11 | Union | Florida | 12125 | 3049 | 78 |
1800753 | 1800753 | 2021-10-10 | Union | Florida | 12125 | 3049 | 78 |
1797504 | 1797504 | 2021-10-09 | Union | Florida | 12125 | 3049 | 78 |
1794255 | 1794255 | 2021-10-08 | Union | Florida | 12125 | 3049 | 78 |
1791007 | 1791007 | 2021-10-07 | Union | Florida | 12125 | 3035 | 78 |
1787758 | 1787758 | 2021-10-06 | Union | Florida | 12125 | 3035 | 78 |
1784509 | 1784509 | 2021-10-05 | Union | Florida | 12125 | 3035 | 78 |
1781260 | 1781260 | 2021-10-04 | Union | Florida | 12125 | 3035 | 78 |
1778010 | 1778010 | 2021-10-03 | Union | Florida | 12125 | 3035 | 78 |
1774734 | 1774734 | 2021-10-02 | Levy | Florida | 12075 | 6850 | 78 |
1774741 | 1774741 | 2021-10-02 | Monroe | Florida | 12087 | 10264 | 78 |
1774760 | 1774760 | 2021-10-02 | Union | Florida | 12125 | 3035 | 78 |
1771484 | 1771484 | 2021-10-01 | Levy | Florida | 12075 | 6850 | 78 |
1771491 | 1771491 | 2021-10-01 | Monroe | Florida | 12087 | 10264 | 78 |
1771510 | 1771510 | 2021-10-01 | Union | Florida | 12125 | 3035 | 78 |
1768235 | 1768235 | 2021-09-30 | Levy | Florida | 12075 | 6768 | 78 |
1768242 | 1768242 | 2021-09-30 | Monroe | Florida | 12087 | 10135 | 78 |
1768261 | 1768261 | 2021-09-30 | Union | Florida | 12125 | 3014 | 78 |
1764986 | 1764986 | 2021-09-29 | Levy | Florida | 12075 | 6768 | 78 |
1764993 | 1764993 | 2021-09-29 | Monroe | Florida | 12087 | 10135 | 78 |
1765012 | 1765012 | 2021-09-29 | Union | Florida | 12125 | 3014 | 78 |
1761737 | 1761737 | 2021-09-28 | Levy | Florida | 12075 | 6768 | 78 |
1761744 | 1761744 | 2021-09-28 | Monroe | Florida | 12087 | 10135 | 78 |
1761763 | 1761763 | 2021-09-28 | Union | Florida | 12125 | 3014 | 78 |
1758489 | 1758489 | 2021-09-27 | Levy | Florida | 12075 | 6768 | 78 |
1758496 | 1758496 | 2021-09-27 | Monroe | Florida | 12087 | 10135 | 78 |
1758515 | 1758515 | 2021-09-27 | Union | Florida | 12125 | 3014 | 78 |
1755241 | 1755241 | 2021-09-26 | Levy | Florida | 12075 | 6768 | 78 |
1755248 | 1755248 | 2021-09-26 | Monroe | Florida | 12087 | 10135 | 78 |
1755267 | 1755267 | 2021-09-26 | Union | Florida | 12125 | 3014 | 78 |
1751993 | 1751993 | 2021-09-25 | Levy | Florida | 12075 | 6768 | 78 |
1752000 | 1752000 | 2021-09-25 | Monroe | Florida | 12087 | 10135 | 78 |
1752019 | 1752019 | 2021-09-25 | Union | Florida | 12125 | 3014 | 78 |
1225935 | 1225935 | 2021-04-16 | Hendry | Florida | 12051 | 4580 | 78 |
1222688 | 1222688 | 2021-04-15 | Hendry | Florida | 12051 | 4571 | 78 |
1219440 | 1219440 | 2021-04-14 | Hendry | Florida | 12051 | 4560 | 78 |
1118758 | 1118758 | 2021-03-14 | DeSoto | Florida | 12027 | 3934 | 78 |
1079838 | 1079838 | 2021-03-02 | Okeechobee | Florida | 12093 | 3571 | 78 |
1076593 | 1076593 | 2021-03-01 | Okeechobee | Florida | 12093 | 3564 | 78 |
1073347 | 1073347 | 2021-02-28 | Okeechobee | Florida | 12093 | 3562 | 78 |
1034372 | 1034372 | 2021-02-16 | Gadsden | Florida | 12039 | 5333 | 78 |
1031126 | 1031126 | 2021-02-15 | Gadsden | Florida | 12039 | 5324 | 78 |
950013 | 950013 | 2021-01-21 | Nassau | Florida | 12089 | 6468 | 78 |
709821 | 709821 | 2020-11-08 | Alachua | Florida | 12001 | 11123 | 78 |
706577 | 706577 | 2020-11-07 | Alachua | Florida | 12001 | 11082 | 78 |
703334 | 703334 | 2020-11-06 | Alachua | Florida | 12001 | 11047 | 78 |
700091 | 700091 | 2020-11-05 | Alachua | Florida | 12001 | 10996 | 78 |
696847 | 696847 | 2020-11-04 | Alachua | Florida | 12001 | 10913 | 78 |
693605 | 693605 | 2020-11-03 | Alachua | Florida | 12001 | 10842 | 78 |
693665 | 693665 | 2020-11-03 | Suwannee | Florida | 12121 | 3034 | 78 |
690362 | 690362 | 2020-11-02 | Alachua | Florida | 12001 | 10760 | 78 |
690422 | 690422 | 2020-11-02 | Suwannee | Florida | 12121 | 3028 | 78 |
687117 | 687117 | 2020-11-01 | Alachua | Florida | 12001 | 10706 | 78 |
687177 | 687177 | 2020-11-01 | Suwannee | Florida | 12121 | 3022 | 78 |
683933 | 683933 | 2020-10-31 | Suwannee | Florida | 12121 | 3015 | 78 |
677398 | 677398 | 2020-10-29 | Columbia | Florida | 12023 | 4255 | 78 |
657983 | 657983 | 2020-10-23 | St. Johns | Florida | 12109 | 6193 | 78 |
654738 | 654738 | 2020-10-22 | St. Johns | Florida | 12109 | 6150 | 78 |
654741 | 654741 | 2020-10-22 | Suwannee | Florida | 12121 | 2949 | 78 |
651493 | 651493 | 2020-10-21 | St. Johns | Florida | 12109 | 6084 | 78 |
651496 | 651496 | 2020-10-21 | Suwannee | Florida | 12121 | 2940 | 78 |
648249 | 648249 | 2020-10-20 | St. Johns | Florida | 12109 | 6038 | 78 |
645004 | 645004 | 2020-10-19 | St. Johns | Florida | 12109 | 5990 | 78 |
641756 | 641756 | 2020-10-18 | St. Johns | Florida | 12109 | 5979 | 78 |
638509 | 638509 | 2020-10-17 | St. Johns | Florida | 12109 | 5944 | 78 |
635264 | 635264 | 2020-10-16 | St. Johns | Florida | 12109 | 5900 | 78 |
632018 | 632018 | 2020-10-15 | St. Johns | Florida | 12109 | 5862 | 78 |
632020 | 632020 | 2020-10-15 | Sumter | Florida | 12119 | 2716 | 78 |
599589 | 599589 | 2020-10-05 | Santa Rosa | Florida | 12113 | 5437 | 78 |
596346 | 596346 | 2020-10-04 | Santa Rosa | Florida | 12113 | 5430 | 78 |
593104 | 593104 | 2020-10-03 | Santa Rosa | Florida | 12113 | 5420 | 78 |
589864 | 589864 | 2020-10-02 | Santa Rosa | Florida | 12113 | 5397 | 78 |
531535 | 531535 | 2020-09-14 | Highlands | Florida | 12055 | 2005 | 78 |
486231 | 486231 | 2020-08-31 | Bay | Florida | 12005 | 5363 | 78 |
482996 | 482996 | 2020-08-30 | Bay | Florida | 12005 | 5355 | 78 |
479762 | 479762 | 2020-08-29 | Bay | Florida | 12005 | 5341 | 78 |
476529 | 476529 | 2020-08-28 | Bay | Florida | 12005 | 5315 | 78 |
457177 | 457177 | 2020-08-22 | Indian River | Florida | 12061 | 2736 | 78 |
392735 | 392735 | 2020-08-02 | Martin | Florida | 12085 | 3637 | 78 |
341406 | 341406 | 2020-07-17 | St. Lucie | Florida | 12111 | 3411 | 78 |
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);