ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Unknown" and state = "Florida" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
78810 | 78810 | 2020-04-22 | Unknown | Florida | 0 | 34 | |
7305 | 7305 | 2020-03-22 | Unknown | Florida | 1 | 0 | |
8451 | 8451 | 2020-03-23 | Unknown | Florida | 1 | 0 | |
11071 | 11071 | 2020-03-25 | Unknown | Florida | 1 | 0 | |
54119 | 54119 | 2020-04-13 | Unknown | Florida | 1 | 0 | |
87212 | 87212 | 2020-04-25 | Unknown | Florida | 1 | 0 | |
92847 | 92847 | 2020-04-27 | Unknown | Florida | 1 | 0 | |
1612334 | 1612334 | 2021-08-13 | Unknown | Florida | 1 | 3793 | |
1680543 | 1680543 | 2021-09-03 | Unknown | Florida | 1 | 9351 | |
1683794 | 1683794 | 2021-09-04 | Unknown | Florida | 1 | 9351 | |
1687044 | 1687044 | 2021-09-05 | Unknown | Florida | 1 | 9351 | |
1690294 | 1690294 | 2021-09-06 | Unknown | Florida | 1 | 9351 | |
1794256 | 1794256 | 2021-10-08 | Unknown | Florida | 1 | 1367 | |
1817000 | 1817000 | 2021-10-15 | Unknown | Florida | 1 | 1182 | |
1839743 | 1839743 | 2021-10-22 | Unknown | Florida | 1 | 929 | |
1842993 | 1842993 | 2021-10-23 | Unknown | Florida | 1 | 929 | |
1846243 | 1846243 | 2021-10-24 | Unknown | Florida | 1 | 929 | |
1885232 | 1885232 | 2021-11-05 | Unknown | Florida | 1 | 686 | |
1907981 | 1907981 | 2021-11-12 | Unknown | Florida | 1 | 299 | |
1930729 | 1930729 | 2021-11-19 | Unknown | Florida | 1 | 356 | |
38428 | 38428 | 2020-04-07 | Unknown | Florida | 2 | 0 | |
40972 | 40972 | 2020-04-08 | Unknown | Florida | 2 | 0 | |
43546 | 43546 | 2020-04-09 | Unknown | Florida | 2 | 0 | |
46148 | 46148 | 2020-04-10 | Unknown | Florida | 2 | 0 | |
48778 | 48778 | 2020-04-11 | Unknown | Florida | 2 | 0 | |
51439 | 51439 | 2020-04-12 | Unknown | Florida | 2 | 0 | |
1566851 | 1566851 | 2021-07-30 | Unknown | Florida | 2 | 2106 | |
1570099 | 1570099 | 2021-07-31 | Unknown | Florida | 2 | 2106 | |
1573347 | 1573347 | 2021-08-01 | Unknown | Florida | 2 | 2106 | |
1576595 | 1576595 | 2021-08-02 | Unknown | Florida | 2 | 2106 | |
1589592 | 1589592 | 2021-08-06 | Unknown | Florida | 2 | 2722 | |
1592841 | 1592841 | 2021-08-07 | Unknown | Florida | 2 | 2722 | |
1596090 | 1596090 | 2021-08-08 | Unknown | Florida | 2 | 2722 | |
1599339 | 1599339 | 2021-08-09 | Unknown | Florida | 2 | 2961 | |
1703290 | 1703290 | 2021-09-10 | Unknown | Florida | 2 | 11799 | |
1862489 | 1862489 | 2021-10-29 | Unknown | Florida | 2 | 867 | |
2044498 | 2044498 | 2021-12-24 | Unknown | Florida | 2 | 127 | |
2047748 | 2047748 | 2021-12-25 | Unknown | Florida | 2 | 127 | |
2050998 | 2050998 | 2021-12-26 | Unknown | Florida | 2 | 127 | |
2294903 | 2294903 | 2022-03-11 | Unknown | Florida | 2 | 863 | |
2298155 | 2298155 | 2022-03-12 | Unknown | Florida | 2 | 863 | |
2301407 | 2301407 | 2022-03-13 | Unknown | Florida | 2 | 863 | |
2340443 | 2340443 | 2022-03-25 | Unknown | Florida | 2 | 427 | |
2343696 | 2343696 | 2022-03-26 | Unknown | Florida | 2 | 427 | |
2346949 | 2346949 | 2022-03-27 | Unknown | Florida | 2 | 427 | |
56811 | 56811 | 2020-04-14 | Unknown | Florida | 3 | 0 | |
62238 | 62238 | 2020-04-16 | Unknown | Florida | 3 | 0 | |
67719 | 67719 | 2020-04-18 | Unknown | Florida | 3 | 0 | |
70481 | 70481 | 2020-04-19 | Unknown | Florida | 3 | 0 | |
73250 | 73250 | 2020-04-20 | Unknown | Florida | 3 | 0 | |
1498662 | 1498662 | 2021-07-09 | Unknown | Florida | 3 | 1184 | |
1501908 | 1501908 | 2021-07-10 | Unknown | Florida | 3 | 1184 | |
1505154 | 1505154 | 2021-07-11 | Unknown | Florida | 3 | 1184 | |
1508400 | 1508400 | 2021-07-12 | Unknown | Florida | 3 | 1184 | |
1521388 | 1521388 | 2021-07-16 | Unknown | Florida | 3 | 1415 | |
1524636 | 1524636 | 2021-07-17 | Unknown | Florida | 3 | 1422 | |
1527883 | 1527883 | 2021-07-18 | Unknown | Florida | 3 | 1422 | |
1531130 | 1531130 | 2021-07-19 | Unknown | Florida | 3 | 1422 | |
1544120 | 1544120 | 2021-07-23 | Unknown | Florida | 3 | 1697 | |
1547367 | 1547367 | 2021-07-24 | Unknown | Florida | 3 | 1697 | |
1550614 | 1550614 | 2021-07-25 | Unknown | Florida | 3 | 1697 | |
1553861 | 1553861 | 2021-07-26 | Unknown | Florida | 3 | 1697 | |
1726024 | 1726024 | 2021-09-17 | Unknown | Florida | 3 | 2468 | |
2385990 | 2385990 | 2022-04-08 | Unknown | Florida | 3 | 247 | |
2431570 | 2431570 | 2022-04-22 | Unknown | Florida | 3 | 133 | |
2434826 | 2434826 | 2022-04-23 | Unknown | Florida | 3 | 133 | |
2438082 | 2438082 | 2022-04-24 | Unknown | Florida | 3 | 133 | |
2477156 | 2477156 | 2022-05-06 | Unknown | Florida | 3 | 102 | |
33490 | 33490 | 2020-04-05 | Unknown | Florida | 4 | 0 | |
64971 | 64971 | 2020-04-17 | Unknown | Florida | 4 | 0 | |
76026 | 76026 | 2020-04-21 | Unknown | Florida | 4 | 0 | |
95679 | 95679 | 2020-04-28 | Unknown | Florida | 4 | 0 | |
1748771 | 1748771 | 2021-09-24 | Unknown | Florida | 4 | 2340 | |
35936 | 35936 | 2020-04-06 | Unknown | Florida | 5 | 0 | |
1635068 | 1635068 | 2021-08-20 | Unknown | Florida | 5 | 5279 | |
1657810 | 1657810 | 2021-08-27 | Unknown | Florida | 5 | 7006 | |
2067247 | 2067247 | 2021-12-31 | Unknown | Florida | 5 | 162 | |
2070498 | 2070498 | 2022-01-01 | Unknown | Florida | 5 | 162 | |
2073749 | 2073749 | 2022-01-02 | Unknown | Florida | 5 | 162 | |
2077000 | 2077000 | 2022-01-03 | Unknown | Florida | 5 | 162 | |
2272137 | 2272137 | 2022-03-04 | Unknown | Florida | 6 | 1207 | |
98524 | 98524 | 2020-04-29 | Unknown | Florida | 7 | 0 | |
101374 | 101374 | 2020-04-30 | Unknown | Florida | 7 | 0 | |
104229 | 104229 | 2020-05-01 | Unknown | Florida | 8 | 0 | |
26421 | 26421 | 2020-04-02 | Unknown | Florida | 9 | 0 | |
107094 | 107094 | 2020-05-02 | Unknown | Florida | 9 | 0 | |
9696 | 9696 | 2020-03-24 | Unknown | Florida | 10 | 0 | |
28724 | 28724 | 2020-04-03 | Unknown | Florida | 10 | 0 | |
31084 | 31084 | 2020-04-04 | Unknown | Florida | 10 | 0 | |
1771511 | 1771511 | 2021-10-01 | Unknown | Florida | 11 | 1719 | |
109963 | 109963 | 2020-05-03 | Unknown | Florida | 12 | 0 | |
112838 | 112838 | 2020-05-04 | Unknown | Florida | 12 | 0 | |
115721 | 115721 | 2020-05-05 | Unknown | Florida | 14 | 0 | |
118681 | 118681 | 2020-05-06 | Unknown | Florida | 31 | 0 | |
121650 | 121650 | 2020-05-07 | Unknown | Florida | 33 | 0 | |
124629 | 124629 | 2020-05-08 | Unknown | Florida | 33 | 0 | |
2249377 | 2249377 | 2022-02-25 | Unknown | Florida | 40 | 888 | |
127616 | 127616 | 2020-05-09 | Unknown | Florida | 49 | 0 | |
130607 | 130607 | 2020-05-10 | Unknown | Florida | 50 | 0 | |
133598 | 133598 | 2020-05-11 | Unknown | Florida | 50 | 0 |
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);