ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
171 rows where deaths = 30 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499935 | 2499935 | 2022-05-13 | Liberty | Florida | 12077 | 2507 | 30 |
2496677 | 2496677 | 2022-05-12 | Liberty | Florida | 12077 | 2507 | 30 |
2493419 | 2493419 | 2022-05-11 | Liberty | Florida | 12077 | 2507 | 30 |
2490161 | 2490161 | 2022-05-10 | Liberty | Florida | 12077 | 2507 | 30 |
2486904 | 2486904 | 2022-05-09 | Liberty | Florida | 12077 | 2507 | 30 |
2483646 | 2483646 | 2022-05-08 | Liberty | Florida | 12077 | 2507 | 30 |
2480388 | 2480388 | 2022-05-07 | Liberty | Florida | 12077 | 2507 | 30 |
2477130 | 2477130 | 2022-05-06 | Liberty | Florida | 12077 | 2507 | 30 |
2473872 | 2473872 | 2022-05-05 | Liberty | Florida | 12077 | 2500 | 30 |
2470615 | 2470615 | 2022-05-04 | Liberty | Florida | 12077 | 2500 | 30 |
2467359 | 2467359 | 2022-05-03 | Liberty | Florida | 12077 | 2500 | 30 |
2464104 | 2464104 | 2022-05-02 | Liberty | Florida | 12077 | 2500 | 30 |
2460848 | 2460848 | 2022-05-01 | Liberty | Florida | 12077 | 2500 | 30 |
2457592 | 2457592 | 2022-04-30 | Liberty | Florida | 12077 | 2500 | 30 |
2454336 | 2454336 | 2022-04-29 | Liberty | Florida | 12077 | 2500 | 30 |
2451080 | 2451080 | 2022-04-28 | Liberty | Florida | 12077 | 2500 | 30 |
2447824 | 2447824 | 2022-04-27 | Liberty | Florida | 12077 | 2500 | 30 |
2444568 | 2444568 | 2022-04-26 | Liberty | Florida | 12077 | 2500 | 30 |
2441312 | 2441312 | 2022-04-25 | Liberty | Florida | 12077 | 2500 | 30 |
2438056 | 2438056 | 2022-04-24 | Liberty | Florida | 12077 | 2500 | 30 |
2434800 | 2434800 | 2022-04-23 | Liberty | Florida | 12077 | 2500 | 30 |
2431544 | 2431544 | 2022-04-22 | Liberty | Florida | 12077 | 2500 | 30 |
2428288 | 2428288 | 2022-04-21 | Liberty | Florida | 12077 | 2498 | 30 |
2425032 | 2425032 | 2022-04-20 | Liberty | Florida | 12077 | 2498 | 30 |
2421776 | 2421776 | 2022-04-19 | Liberty | Florida | 12077 | 2498 | 30 |
2418520 | 2418520 | 2022-04-18 | Liberty | Florida | 12077 | 2498 | 30 |
2415264 | 2415264 | 2022-04-17 | Liberty | Florida | 12077 | 2498 | 30 |
2412008 | 2412008 | 2022-04-16 | Liberty | Florida | 12077 | 2498 | 30 |
2408752 | 2408752 | 2022-04-15 | Liberty | Florida | 12077 | 2498 | 30 |
2405496 | 2405496 | 2022-04-14 | Liberty | Florida | 12077 | 2498 | 30 |
2402241 | 2402241 | 2022-04-13 | Liberty | Florida | 12077 | 2498 | 30 |
2398986 | 2398986 | 2022-04-12 | Liberty | Florida | 12077 | 2498 | 30 |
2395731 | 2395731 | 2022-04-11 | Liberty | Florida | 12077 | 2498 | 30 |
2392475 | 2392475 | 2022-04-10 | Liberty | Florida | 12077 | 2498 | 30 |
2389219 | 2389219 | 2022-04-09 | Liberty | Florida | 12077 | 2498 | 30 |
2385964 | 2385964 | 2022-04-08 | Liberty | Florida | 12077 | 2498 | 30 |
2382709 | 2382709 | 2022-04-07 | Liberty | Florida | 12077 | 2496 | 30 |
2379454 | 2379454 | 2022-04-06 | Liberty | Florida | 12077 | 2496 | 30 |
2376200 | 2376200 | 2022-04-05 | Liberty | Florida | 12077 | 2496 | 30 |
2372948 | 2372948 | 2022-04-04 | Liberty | Florida | 12077 | 2496 | 30 |
2369695 | 2369695 | 2022-04-03 | Liberty | Florida | 12077 | 2496 | 30 |
2366442 | 2366442 | 2022-04-02 | Liberty | Florida | 12077 | 2496 | 30 |
2363189 | 2363189 | 2022-04-01 | Liberty | Florida | 12077 | 2496 | 30 |
2359935 | 2359935 | 2022-03-31 | Liberty | Florida | 12077 | 2496 | 30 |
2356681 | 2356681 | 2022-03-30 | Liberty | Florida | 12077 | 2496 | 30 |
1774711 | 1774711 | 2021-10-02 | Dixie | Florida | 12029 | 2877 | 30 |
1771461 | 1771461 | 2021-10-01 | Dixie | Florida | 12029 | 2877 | 30 |
1768212 | 1768212 | 2021-09-30 | Dixie | Florida | 12029 | 2851 | 30 |
1764963 | 1764963 | 2021-09-29 | Dixie | Florida | 12029 | 2851 | 30 |
1761714 | 1761714 | 2021-09-28 | Dixie | Florida | 12029 | 2851 | 30 |
1758466 | 1758466 | 2021-09-27 | Dixie | Florida | 12029 | 2851 | 30 |
1755218 | 1755218 | 2021-09-26 | Dixie | Florida | 12029 | 2851 | 30 |
1751970 | 1751970 | 2021-09-25 | Dixie | Florida | 12029 | 2851 | 30 |
1079815 | 1079815 | 2021-03-02 | Hardee | Florida | 12049 | 2800 | 30 |
1040880 | 1040880 | 2021-02-18 | Levy | Florida | 12075 | 2787 | 30 |
1037635 | 1037635 | 2021-02-17 | Levy | Florida | 12075 | 2776 | 30 |
1034373 | 1034373 | 2021-02-16 | Gilchrist | Florida | 12041 | 1317 | 30 |
1034390 | 1034390 | 2021-02-16 | Levy | Florida | 12075 | 2763 | 30 |
1031127 | 1031127 | 2021-02-15 | Gilchrist | Florida | 12041 | 1298 | 30 |
959772 | 959772 | 2021-01-24 | Washington | Florida | 12133 | 2363 | 30 |
956526 | 956526 | 2021-01-23 | Washington | Florida | 12133 | 2345 | 30 |
953281 | 953281 | 2021-01-22 | Washington | Florida | 12133 | 2326 | 30 |
950036 | 950036 | 2021-01-21 | Washington | Florida | 12133 | 2315 | 30 |
946784 | 946784 | 2021-01-20 | Taylor | Florida | 12123 | 2309 | 30 |
946790 | 946790 | 2021-01-20 | Washington | Florida | 12133 | 2295 | 30 |
943537 | 943537 | 2021-01-19 | Taylor | Florida | 12123 | 2296 | 30 |
943543 | 943543 | 2021-01-19 | Washington | Florida | 12133 | 2282 | 30 |
940292 | 940292 | 2021-01-18 | Taylor | Florida | 12123 | 2280 | 30 |
940298 | 940298 | 2021-01-18 | Washington | Florida | 12133 | 2273 | 30 |
937047 | 937047 | 2021-01-17 | Taylor | Florida | 12123 | 2274 | 30 |
937053 | 937053 | 2021-01-17 | Washington | Florida | 12133 | 2263 | 30 |
933808 | 933808 | 2021-01-16 | Washington | Florida | 12133 | 2261 | 30 |
930563 | 930563 | 2021-01-15 | Washington | Florida | 12133 | 2244 | 30 |
927272 | 927272 | 2021-01-14 | Gulf | Florida | 12045 | 1514 | 30 |
927318 | 927318 | 2021-01-14 | Washington | Florida | 12133 | 2226 | 30 |
924026 | 924026 | 2021-01-13 | Gulf | Florida | 12045 | 1501 | 30 |
924072 | 924072 | 2021-01-13 | Washington | Florida | 12133 | 2197 | 30 |
920781 | 920781 | 2021-01-12 | Gulf | Florida | 12045 | 1485 | 30 |
920788 | 920788 | 2021-01-12 | Holmes | Florida | 12059 | 1903 | 30 |
920827 | 920827 | 2021-01-12 | Washington | Florida | 12133 | 2179 | 30 |
917582 | 917582 | 2021-01-11 | Washington | Florida | 12133 | 2166 | 30 |
914298 | 914298 | 2021-01-10 | Holmes | Florida | 12059 | 1882 | 30 |
914337 | 914337 | 2021-01-10 | Washington | Florida | 12133 | 2161 | 30 |
911053 | 911053 | 2021-01-09 | Holmes | Florida | 12059 | 1877 | 30 |
911092 | 911092 | 2021-01-09 | Washington | Florida | 12133 | 2158 | 30 |
907808 | 907808 | 2021-01-08 | Holmes | Florida | 12059 | 1852 | 30 |
907847 | 907847 | 2021-01-08 | Washington | Florida | 12133 | 2138 | 30 |
904562 | 904562 | 2021-01-07 | Holmes | Florida | 12059 | 1839 | 30 |
904601 | 904601 | 2021-01-07 | Washington | Florida | 12133 | 2118 | 30 |
901356 | 901356 | 2021-01-06 | Washington | Florida | 12133 | 2086 | 30 |
898111 | 898111 | 2021-01-05 | Washington | Florida | 12133 | 2057 | 30 |
894866 | 894866 | 2021-01-04 | Washington | Florida | 12133 | 2048 | 30 |
891619 | 891619 | 2021-01-03 | Washington | Florida | 12133 | 2030 | 30 |
888372 | 888372 | 2021-01-02 | Washington | Florida | 12133 | 2017 | 30 |
885127 | 885127 | 2021-01-01 | Washington | Florida | 12133 | 1971 | 30 |
881882 | 881882 | 2020-12-31 | Washington | Florida | 12133 | 1971 | 30 |
878637 | 878637 | 2020-12-30 | Washington | Florida | 12133 | 1936 | 30 |
875392 | 875392 | 2020-12-29 | Washington | Florida | 12133 | 1919 | 30 |
872147 | 872147 | 2020-12-28 | Washington | Florida | 12133 | 1907 | 30 |
868902 | 868902 | 2020-12-27 | Washington | Florida | 12133 | 1907 | 30 |
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);