ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 12075 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
293734 | 293734 | 2020-07-02 | Levy | Florida | 12075 | 182 | 1 |
290580 | 290580 | 2020-07-01 | Levy | Florida | 12075 | 181 | 1 |
287429 | 287429 | 2020-06-30 | Levy | Florida | 12075 | 174 | 1 |
284283 | 284283 | 2020-06-29 | Levy | Florida | 12075 | 173 | 1 |
281137 | 281137 | 2020-06-28 | Levy | Florida | 12075 | 171 | 1 |
277990 | 277990 | 2020-06-27 | Levy | Florida | 12075 | 168 | 1 |
274842 | 274842 | 2020-06-26 | Levy | Florida | 12075 | 165 | 1 |
271702 | 271702 | 2020-06-25 | Levy | Florida | 12075 | 157 | 1 |
268566 | 268566 | 2020-06-24 | Levy | Florida | 12075 | 154 | 1 |
265436 | 265436 | 2020-06-23 | Levy | Florida | 12075 | 151 | 1 |
262308 | 262308 | 2020-06-22 | Levy | Florida | 12075 | 147 | 1 |
259181 | 259181 | 2020-06-21 | Levy | Florida | 12075 | 139 | 1 |
256054 | 256054 | 2020-06-20 | Levy | Florida | 12075 | 137 | 1 |
252935 | 252935 | 2020-06-19 | Levy | Florida | 12075 | 137 | 1 |
249820 | 249820 | 2020-06-18 | Levy | Florida | 12075 | 132 | 1 |
246708 | 246708 | 2020-06-17 | Levy | Florida | 12075 | 131 | 1 |
243595 | 243595 | 2020-06-16 | Levy | Florida | 12075 | 127 | 1 |
240484 | 240484 | 2020-06-15 | Levy | Florida | 12075 | 101 | 1 |
237376 | 237376 | 2020-06-14 | Levy | Florida | 12075 | 100 | 1 |
234269 | 234269 | 2020-06-13 | Levy | Florida | 12075 | 100 | 1 |
231163 | 231163 | 2020-06-12 | Levy | Florida | 12075 | 98 | 1 |
228060 | 228060 | 2020-06-11 | Levy | Florida | 12075 | 95 | 1 |
224958 | 224958 | 2020-06-10 | Levy | Florida | 12075 | 90 | 1 |
221863 | 221863 | 2020-06-09 | Levy | Florida | 12075 | 90 | 1 |
218768 | 218768 | 2020-06-08 | Levy | Florida | 12075 | 73 | 1 |
215677 | 215677 | 2020-06-07 | Levy | Florida | 12075 | 60 | 1 |
212590 | 212590 | 2020-06-06 | Levy | Florida | 12075 | 58 | 1 |
209505 | 209505 | 2020-06-05 | Levy | Florida | 12075 | 55 | 1 |
206424 | 206424 | 2020-06-04 | Levy | Florida | 12075 | 38 | 1 |
203344 | 203344 | 2020-06-03 | Levy | Florida | 12075 | 35 | 1 |
200268 | 200268 | 2020-06-02 | Levy | Florida | 12075 | 35 | 1 |
197195 | 197195 | 2020-06-01 | Levy | Florida | 12075 | 34 | 1 |
194125 | 194125 | 2020-05-31 | Levy | Florida | 12075 | 32 | 1 |
191058 | 191058 | 2020-05-30 | Levy | Florida | 12075 | 31 | 1 |
187993 | 187993 | 2020-05-29 | Levy | Florida | 12075 | 31 | 0 |
184937 | 184937 | 2020-05-28 | Levy | Florida | 12075 | 30 | 0 |
181883 | 181883 | 2020-05-27 | Levy | Florida | 12075 | 30 | 0 |
178839 | 178839 | 2020-05-26 | Levy | Florida | 12075 | 30 | 0 |
175795 | 175795 | 2020-05-25 | Levy | Florida | 12075 | 29 | 0 |
172752 | 172752 | 2020-05-24 | Levy | Florida | 12075 | 27 | 0 |
169711 | 169711 | 2020-05-23 | Levy | Florida | 12075 | 27 | 0 |
166674 | 166674 | 2020-05-22 | Levy | Florida | 12075 | 27 | 0 |
163641 | 163641 | 2020-05-21 | Levy | Florida | 12075 | 27 | 0 |
160613 | 160613 | 2020-05-20 | Levy | Florida | 12075 | 27 | 0 |
157587 | 157587 | 2020-05-19 | Levy | Florida | 12075 | 25 | 0 |
154571 | 154571 | 2020-05-18 | Levy | Florida | 12075 | 25 | 0 |
151559 | 151559 | 2020-05-17 | Levy | Florida | 12075 | 25 | 0 |
148550 | 148550 | 2020-05-16 | Levy | Florida | 12075 | 24 | 0 |
145547 | 145547 | 2020-05-15 | Levy | Florida | 12075 | 24 | 0 |
142547 | 142547 | 2020-05-14 | Levy | Florida | 12075 | 22 | 0 |
139551 | 139551 | 2020-05-13 | Levy | Florida | 12075 | 22 | 0 |
136560 | 136560 | 2020-05-12 | Levy | Florida | 12075 | 22 | 0 |
133571 | 133571 | 2020-05-11 | Levy | Florida | 12075 | 20 | 0 |
130580 | 130580 | 2020-05-10 | Levy | Florida | 12075 | 20 | 0 |
127589 | 127589 | 2020-05-09 | Levy | Florida | 12075 | 20 | 0 |
124602 | 124602 | 2020-05-08 | Levy | Florida | 12075 | 20 | 0 |
121623 | 121623 | 2020-05-07 | Levy | Florida | 12075 | 20 | 0 |
118654 | 118654 | 2020-05-06 | Levy | Florida | 12075 | 20 | 0 |
115694 | 115694 | 2020-05-05 | Levy | Florida | 12075 | 20 | 0 |
112811 | 112811 | 2020-05-04 | Levy | Florida | 12075 | 20 | 0 |
109936 | 109936 | 2020-05-03 | Levy | Florida | 12075 | 19 | 0 |
107067 | 107067 | 2020-05-02 | Levy | Florida | 12075 | 19 | 0 |
104202 | 104202 | 2020-05-01 | Levy | Florida | 12075 | 19 | 0 |
101347 | 101347 | 2020-04-30 | Levy | Florida | 12075 | 19 | 0 |
98497 | 98497 | 2020-04-29 | Levy | Florida | 12075 | 18 | 0 |
95652 | 95652 | 2020-04-28 | Levy | Florida | 12075 | 18 | 0 |
92820 | 92820 | 2020-04-27 | Levy | Florida | 12075 | 13 | 0 |
90002 | 90002 | 2020-04-26 | Levy | Florida | 12075 | 13 | 0 |
87185 | 87185 | 2020-04-25 | Levy | Florida | 12075 | 13 | 0 |
84377 | 84377 | 2020-04-24 | Levy | Florida | 12075 | 13 | 0 |
81577 | 81577 | 2020-04-23 | Levy | Florida | 12075 | 13 | 0 |
78783 | 78783 | 2020-04-22 | Levy | Florida | 12075 | 13 | 0 |
75999 | 75999 | 2020-04-21 | Levy | Florida | 12075 | 12 | 0 |
73223 | 73223 | 2020-04-20 | Levy | Florida | 12075 | 12 | 0 |
70454 | 70454 | 2020-04-19 | Levy | Florida | 12075 | 12 | 0 |
67692 | 67692 | 2020-04-18 | Levy | Florida | 12075 | 11 | 0 |
64944 | 64944 | 2020-04-17 | Levy | Florida | 12075 | 9 | 0 |
62211 | 62211 | 2020-04-16 | Levy | Florida | 12075 | 9 | 0 |
59492 | 59492 | 2020-04-15 | Levy | Florida | 12075 | 9 | 0 |
56784 | 56784 | 2020-04-14 | Levy | Florida | 12075 | 7 | 0 |
54092 | 54092 | 2020-04-13 | Levy | Florida | 12075 | 7 | 0 |
51412 | 51412 | 2020-04-12 | Levy | Florida | 12075 | 8 | 0 |
48751 | 48751 | 2020-04-11 | Levy | Florida | 12075 | 7 | 0 |
46121 | 46121 | 2020-04-10 | Levy | Florida | 12075 | 6 | 0 |
43520 | 43520 | 2020-04-09 | Levy | Florida | 12075 | 6 | 0 |
40946 | 40946 | 2020-04-08 | Levy | Florida | 12075 | 6 | 0 |
38402 | 38402 | 2020-04-07 | Levy | Florida | 12075 | 5 | 0 |
35911 | 35911 | 2020-04-06 | Levy | Florida | 12075 | 4 | 0 |
33465 | 33465 | 2020-04-05 | Levy | Florida | 12075 | 4 | 0 |
31059 | 31059 | 2020-04-04 | Levy | Florida | 12075 | 2 | 0 |
28699 | 28699 | 2020-04-03 | Levy | Florida | 12075 | 2 | 0 |
26396 | 26396 | 2020-04-02 | Levy | Florida | 12075 | 2 | 0 |
24166 | 24166 | 2020-04-01 | Levy | Florida | 12075 | 2 | 0 |
22005 | 22005 | 2020-03-31 | Levy | Florida | 12075 | 2 | 0 |
19927 | 19927 | 2020-03-30 | Levy | Florida | 12075 | 2 | 0 |
17946 | 17946 | 2020-03-29 | Levy | Florida | 12075 | 2 | 0 |
16053 | 16053 | 2020-03-28 | Levy | Florida | 12075 | 1 | 0 |
14268 | 14268 | 2020-03-27 | Levy | Florida | 12075 | 1 | 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);