ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 12035 and state = "Florida" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
7276 | 7276 | 2020-03-22 | Flagler | Florida | 12035 | 1 | 0 |
8422 | 8422 | 2020-03-23 | Flagler | Florida | 12035 | 3 | 0 |
9667 | 9667 | 2020-03-24 | Flagler | Florida | 12035 | 4 | 0 |
11041 | 11041 | 2020-03-25 | Flagler | Florida | 12035 | 6 | 0 |
12589 | 12589 | 2020-03-26 | Flagler | Florida | 12035 | 8 | 0 |
14258 | 14258 | 2020-03-27 | Flagler | Florida | 12035 | 12 | 0 |
16042 | 16042 | 2020-03-28 | Flagler | Florida | 12035 | 13 | 0 |
17934 | 17934 | 2020-03-29 | Flagler | Florida | 12035 | 13 | 0 |
19914 | 19914 | 2020-03-30 | Flagler | Florida | 12035 | 15 | 0 |
21992 | 21992 | 2020-03-31 | Flagler | Florida | 12035 | 18 | 0 |
24151 | 24151 | 2020-04-01 | Flagler | Florida | 12035 | 24 | 0 |
26381 | 26381 | 2020-04-02 | Flagler | Florida | 12035 | 25 | 1 |
28683 | 28683 | 2020-04-03 | Flagler | Florida | 12035 | 28 | 1 |
31042 | 31042 | 2020-04-04 | Flagler | Florida | 12035 | 29 | 1 |
33448 | 33448 | 2020-04-05 | Flagler | Florida | 12035 | 31 | 1 |
35893 | 35893 | 2020-04-06 | Flagler | Florida | 12035 | 34 | 1 |
38383 | 38383 | 2020-04-07 | Flagler | Florida | 12035 | 35 | 1 |
40926 | 40926 | 2020-04-08 | Flagler | Florida | 12035 | 36 | 1 |
43500 | 43500 | 2020-04-09 | Flagler | Florida | 12035 | 41 | 1 |
46101 | 46101 | 2020-04-10 | Flagler | Florida | 12035 | 44 | 1 |
48731 | 48731 | 2020-04-11 | Flagler | Florida | 12035 | 46 | 1 |
51392 | 51392 | 2020-04-12 | Flagler | Florida | 12035 | 45 | 2 |
54072 | 54072 | 2020-04-13 | Flagler | Florida | 12035 | 45 | 2 |
56764 | 56764 | 2020-04-14 | Flagler | Florida | 12035 | 45 | 2 |
59472 | 59472 | 2020-04-15 | Flagler | Florida | 12035 | 46 | 2 |
62191 | 62191 | 2020-04-16 | Flagler | Florida | 12035 | 50 | 2 |
64924 | 64924 | 2020-04-17 | Flagler | Florida | 12035 | 55 | 2 |
67672 | 67672 | 2020-04-18 | Flagler | Florida | 12035 | 66 | 2 |
70434 | 70434 | 2020-04-19 | Flagler | Florida | 12035 | 75 | 2 |
73203 | 73203 | 2020-04-20 | Flagler | Florida | 12035 | 76 | 2 |
75979 | 75979 | 2020-04-21 | Flagler | Florida | 12035 | 78 | 2 |
78763 | 78763 | 2020-04-22 | Flagler | Florida | 12035 | 78 | 2 |
81557 | 81557 | 2020-04-23 | Flagler | Florida | 12035 | 106 | 2 |
84357 | 84357 | 2020-04-24 | Flagler | Florida | 12035 | 106 | 2 |
87165 | 87165 | 2020-04-25 | Flagler | Florida | 12035 | 116 | 2 |
89982 | 89982 | 2020-04-26 | Flagler | Florida | 12035 | 121 | 2 |
92800 | 92800 | 2020-04-27 | Flagler | Florida | 12035 | 127 | 2 |
95632 | 95632 | 2020-04-28 | Flagler | Florida | 12035 | 131 | 2 |
98477 | 98477 | 2020-04-29 | Flagler | Florida | 12035 | 133 | 2 |
101327 | 101327 | 2020-04-30 | Flagler | Florida | 12035 | 133 | 2 |
104182 | 104182 | 2020-05-01 | Flagler | Florida | 12035 | 134 | 2 |
107047 | 107047 | 2020-05-02 | Flagler | Florida | 12035 | 138 | 3 |
109916 | 109916 | 2020-05-03 | Flagler | Florida | 12035 | 140 | 3 |
112791 | 112791 | 2020-05-04 | Flagler | Florida | 12035 | 140 | 3 |
115674 | 115674 | 2020-05-05 | Flagler | Florida | 12035 | 141 | 4 |
118634 | 118634 | 2020-05-06 | Flagler | Florida | 12035 | 142 | 4 |
121603 | 121603 | 2020-05-07 | Flagler | Florida | 12035 | 145 | 4 |
124582 | 124582 | 2020-05-08 | Flagler | Florida | 12035 | 147 | 3 |
127569 | 127569 | 2020-05-09 | Flagler | Florida | 12035 | 147 | 4 |
130560 | 130560 | 2020-05-10 | Flagler | Florida | 12035 | 147 | 4 |
133551 | 133551 | 2020-05-11 | Flagler | Florida | 12035 | 147 | 4 |
136540 | 136540 | 2020-05-12 | Flagler | Florida | 12035 | 147 | 4 |
139531 | 139531 | 2020-05-13 | Flagler | Florida | 12035 | 148 | 4 |
142527 | 142527 | 2020-05-14 | Flagler | Florida | 12035 | 148 | 4 |
145527 | 145527 | 2020-05-15 | Flagler | Florida | 12035 | 153 | 4 |
148530 | 148530 | 2020-05-16 | Flagler | Florida | 12035 | 156 | 4 |
151539 | 151539 | 2020-05-17 | Flagler | Florida | 12035 | 156 | 4 |
154551 | 154551 | 2020-05-18 | Flagler | Florida | 12035 | 160 | 4 |
157567 | 157567 | 2020-05-19 | Flagler | Florida | 12035 | 167 | 4 |
160593 | 160593 | 2020-05-20 | Flagler | Florida | 12035 | 169 | 4 |
163621 | 163621 | 2020-05-21 | Flagler | Florida | 12035 | 172 | 4 |
166654 | 166654 | 2020-05-22 | Flagler | Florida | 12035 | 173 | 4 |
169691 | 169691 | 2020-05-23 | Flagler | Florida | 12035 | 173 | 4 |
172732 | 172732 | 2020-05-24 | Flagler | Florida | 12035 | 177 | 4 |
175775 | 175775 | 2020-05-25 | Flagler | Florida | 12035 | 177 | 4 |
178819 | 178819 | 2020-05-26 | Flagler | Florida | 12035 | 177 | 4 |
181863 | 181863 | 2020-05-27 | Flagler | Florida | 12035 | 178 | 4 |
184917 | 184917 | 2020-05-28 | Flagler | Florida | 12035 | 179 | 4 |
187973 | 187973 | 2020-05-29 | Flagler | Florida | 12035 | 182 | 4 |
191038 | 191038 | 2020-05-30 | Flagler | Florida | 12035 | 185 | 4 |
194105 | 194105 | 2020-05-31 | Flagler | Florida | 12035 | 189 | 4 |
197175 | 197175 | 2020-06-01 | Flagler | Florida | 12035 | 189 | 4 |
200248 | 200248 | 2020-06-02 | Flagler | Florida | 12035 | 190 | 4 |
203324 | 203324 | 2020-06-03 | Flagler | Florida | 12035 | 191 | 4 |
206404 | 206404 | 2020-06-04 | Flagler | Florida | 12035 | 193 | 4 |
209485 | 209485 | 2020-06-05 | Flagler | Florida | 12035 | 195 | 4 |
212570 | 212570 | 2020-06-06 | Flagler | Florida | 12035 | 195 | 4 |
215657 | 215657 | 2020-06-07 | Flagler | Florida | 12035 | 195 | 4 |
218748 | 218748 | 2020-06-08 | Flagler | Florida | 12035 | 195 | 4 |
221843 | 221843 | 2020-06-09 | Flagler | Florida | 12035 | 195 | 4 |
224938 | 224938 | 2020-06-10 | Flagler | Florida | 12035 | 200 | 4 |
228040 | 228040 | 2020-06-11 | Flagler | Florida | 12035 | 201 | 4 |
231143 | 231143 | 2020-06-12 | Flagler | Florida | 12035 | 202 | 5 |
234249 | 234249 | 2020-06-13 | Flagler | Florida | 12035 | 204 | 5 |
237356 | 237356 | 2020-06-14 | Flagler | Florida | 12035 | 207 | 5 |
240464 | 240464 | 2020-06-15 | Flagler | Florida | 12035 | 207 | 5 |
243575 | 243575 | 2020-06-16 | Flagler | Florida | 12035 | 208 | 5 |
246688 | 246688 | 2020-06-17 | Flagler | Florida | 12035 | 214 | 5 |
249800 | 249800 | 2020-06-18 | Flagler | Florida | 12035 | 216 | 5 |
252915 | 252915 | 2020-06-19 | Flagler | Florida | 12035 | 216 | 5 |
256034 | 256034 | 2020-06-20 | Flagler | Florida | 12035 | 224 | 5 |
259161 | 259161 | 2020-06-21 | Flagler | Florida | 12035 | 226 | 5 |
262288 | 262288 | 2020-06-22 | Flagler | Florida | 12035 | 237 | 5 |
265416 | 265416 | 2020-06-23 | Flagler | Florida | 12035 | 244 | 5 |
268546 | 268546 | 2020-06-24 | Flagler | Florida | 12035 | 250 | 5 |
271682 | 271682 | 2020-06-25 | Flagler | Florida | 12035 | 261 | 5 |
274822 | 274822 | 2020-06-26 | Flagler | Florida | 12035 | 274 | 5 |
277970 | 277970 | 2020-06-27 | Flagler | Florida | 12035 | 279 | 5 |
281117 | 281117 | 2020-06-28 | Flagler | Florida | 12035 | 293 | 5 |
284263 | 284263 | 2020-06-29 | Flagler | Florida | 12035 | 302 | 5 |
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);