ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 12039 and state = "Florida" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
11042 | 11042 | 2020-03-25 | Gadsden | Florida | 12039 | 1 | 0 |
12590 | 12590 | 2020-03-26 | Gadsden | Florida | 12039 | 1 | 0 |
14259 | 14259 | 2020-03-27 | Gadsden | Florida | 12039 | 1 | 0 |
16043 | 16043 | 2020-03-28 | Gadsden | Florida | 12039 | 1 | 0 |
17935 | 17935 | 2020-03-29 | Gadsden | Florida | 12039 | 1 | 0 |
19915 | 19915 | 2020-03-30 | Gadsden | Florida | 12039 | 1 | 0 |
21993 | 21993 | 2020-03-31 | Gadsden | Florida | 12039 | 1 | 0 |
24152 | 24152 | 2020-04-01 | Gadsden | Florida | 12039 | 1 | 0 |
26382 | 26382 | 2020-04-02 | Gadsden | Florida | 12039 | 1 | 0 |
28685 | 28685 | 2020-04-03 | Gadsden | Florida | 12039 | 2 | 0 |
31044 | 31044 | 2020-04-04 | Gadsden | Florida | 12039 | 3 | 0 |
33450 | 33450 | 2020-04-05 | Gadsden | Florida | 12039 | 3 | 0 |
35895 | 35895 | 2020-04-06 | Gadsden | Florida | 12039 | 4 | 0 |
38385 | 38385 | 2020-04-07 | Gadsden | Florida | 12039 | 5 | 0 |
40928 | 40928 | 2020-04-08 | Gadsden | Florida | 12039 | 8 | 0 |
43502 | 43502 | 2020-04-09 | Gadsden | Florida | 12039 | 11 | 0 |
46103 | 46103 | 2020-04-10 | Gadsden | Florida | 12039 | 13 | 0 |
48733 | 48733 | 2020-04-11 | Gadsden | Florida | 12039 | 13 | 0 |
51394 | 51394 | 2020-04-12 | Gadsden | Florida | 12039 | 16 | 0 |
54074 | 54074 | 2020-04-13 | Gadsden | Florida | 12039 | 35 | 0 |
56766 | 56766 | 2020-04-14 | Gadsden | Florida | 12039 | 37 | 0 |
59474 | 59474 | 2020-04-15 | Gadsden | Florida | 12039 | 40 | 0 |
62193 | 62193 | 2020-04-16 | Gadsden | Florida | 12039 | 43 | 0 |
64926 | 64926 | 2020-04-17 | Gadsden | Florida | 12039 | 46 | 0 |
67674 | 67674 | 2020-04-18 | Gadsden | Florida | 12039 | 47 | 0 |
70436 | 70436 | 2020-04-19 | Gadsden | Florida | 12039 | 50 | 0 |
73205 | 73205 | 2020-04-20 | Gadsden | Florida | 12039 | 56 | 0 |
75981 | 75981 | 2020-04-21 | Gadsden | Florida | 12039 | 56 | 0 |
78765 | 78765 | 2020-04-22 | Gadsden | Florida | 12039 | 57 | 0 |
81559 | 81559 | 2020-04-23 | Gadsden | Florida | 12039 | 68 | 0 |
84359 | 84359 | 2020-04-24 | Gadsden | Florida | 12039 | 78 | 0 |
87167 | 87167 | 2020-04-25 | Gadsden | Florida | 12039 | 79 | 0 |
89984 | 89984 | 2020-04-26 | Gadsden | Florida | 12039 | 80 | 0 |
92802 | 92802 | 2020-04-27 | Gadsden | Florida | 12039 | 86 | 0 |
95634 | 95634 | 2020-04-28 | Gadsden | Florida | 12039 | 93 | 0 |
98479 | 98479 | 2020-04-29 | Gadsden | Florida | 12039 | 93 | 0 |
101329 | 101329 | 2020-04-30 | Gadsden | Florida | 12039 | 94 | 0 |
104184 | 104184 | 2020-05-01 | Gadsden | Florida | 12039 | 102 | 0 |
107049 | 107049 | 2020-05-02 | Gadsden | Florida | 12039 | 104 | 0 |
109918 | 109918 | 2020-05-03 | Gadsden | Florida | 12039 | 106 | 0 |
112793 | 112793 | 2020-05-04 | Gadsden | Florida | 12039 | 112 | 0 |
115676 | 115676 | 2020-05-05 | Gadsden | Florida | 12039 | 114 | 0 |
118636 | 118636 | 2020-05-06 | Gadsden | Florida | 12039 | 119 | 0 |
121605 | 121605 | 2020-05-07 | Gadsden | Florida | 12039 | 120 | 0 |
124584 | 124584 | 2020-05-08 | Gadsden | Florida | 12039 | 122 | 0 |
127571 | 127571 | 2020-05-09 | Gadsden | Florida | 12039 | 127 | 0 |
130562 | 130562 | 2020-05-10 | Gadsden | Florida | 12039 | 127 | 0 |
133553 | 133553 | 2020-05-11 | Gadsden | Florida | 12039 | 129 | 0 |
136542 | 136542 | 2020-05-12 | Gadsden | Florida | 12039 | 136 | 0 |
139533 | 139533 | 2020-05-13 | Gadsden | Florida | 12039 | 138 | 1 |
142529 | 142529 | 2020-05-14 | Gadsden | Florida | 12039 | 139 | 1 |
145529 | 145529 | 2020-05-15 | Gadsden | Florida | 12039 | 179 | 1 |
148532 | 148532 | 2020-05-16 | Gadsden | Florida | 12039 | 211 | 1 |
151541 | 151541 | 2020-05-17 | Gadsden | Florida | 12039 | 222 | 1 |
154553 | 154553 | 2020-05-18 | Gadsden | Florida | 12039 | 239 | 1 |
157569 | 157569 | 2020-05-19 | Gadsden | Florida | 12039 | 241 | 1 |
160595 | 160595 | 2020-05-20 | Gadsden | Florida | 12039 | 244 | 1 |
163623 | 163623 | 2020-05-21 | Gadsden | Florida | 12039 | 248 | 1 |
166656 | 166656 | 2020-05-22 | Gadsden | Florida | 12039 | 251 | 1 |
169693 | 169693 | 2020-05-23 | Gadsden | Florida | 12039 | 254 | 1 |
172734 | 172734 | 2020-05-24 | Gadsden | Florida | 12039 | 254 | 1 |
175777 | 175777 | 2020-05-25 | Gadsden | Florida | 12039 | 263 | 1 |
178821 | 178821 | 2020-05-26 | Gadsden | Florida | 12039 | 265 | 1 |
181865 | 181865 | 2020-05-27 | Gadsden | Florida | 12039 | 267 | 1 |
184919 | 184919 | 2020-05-28 | Gadsden | Florida | 12039 | 267 | 1 |
187975 | 187975 | 2020-05-29 | Gadsden | Florida | 12039 | 268 | 2 |
191040 | 191040 | 2020-05-30 | Gadsden | Florida | 12039 | 268 | 2 |
194107 | 194107 | 2020-05-31 | Gadsden | Florida | 12039 | 272 | 2 |
197177 | 197177 | 2020-06-01 | Gadsden | Florida | 12039 | 275 | 2 |
200250 | 200250 | 2020-06-02 | Gadsden | Florida | 12039 | 277 | 3 |
203326 | 203326 | 2020-06-03 | Gadsden | Florida | 12039 | 284 | 3 |
206406 | 206406 | 2020-06-04 | Gadsden | Florida | 12039 | 287 | 3 |
209487 | 209487 | 2020-06-05 | Gadsden | Florida | 12039 | 288 | 4 |
212572 | 212572 | 2020-06-06 | Gadsden | Florida | 12039 | 292 | 4 |
215659 | 215659 | 2020-06-07 | Gadsden | Florida | 12039 | 293 | 4 |
218750 | 218750 | 2020-06-08 | Gadsden | Florida | 12039 | 293 | 4 |
221845 | 221845 | 2020-06-09 | Gadsden | Florida | 12039 | 295 | 4 |
224940 | 224940 | 2020-06-10 | Gadsden | Florida | 12039 | 297 | 4 |
228042 | 228042 | 2020-06-11 | Gadsden | Florida | 12039 | 299 | 4 |
231145 | 231145 | 2020-06-12 | Gadsden | Florida | 12039 | 301 | 4 |
234251 | 234251 | 2020-06-13 | Gadsden | Florida | 12039 | 300 | 4 |
237358 | 237358 | 2020-06-14 | Gadsden | Florida | 12039 | 303 | 4 |
240466 | 240466 | 2020-06-15 | Gadsden | Florida | 12039 | 304 | 4 |
243577 | 243577 | 2020-06-16 | Gadsden | Florida | 12039 | 308 | 5 |
246690 | 246690 | 2020-06-17 | Gadsden | Florida | 12039 | 311 | 5 |
249802 | 249802 | 2020-06-18 | Gadsden | Florida | 12039 | 315 | 5 |
252917 | 252917 | 2020-06-19 | Gadsden | Florida | 12039 | 318 | 6 |
256036 | 256036 | 2020-06-20 | Gadsden | Florida | 12039 | 321 | 6 |
259163 | 259163 | 2020-06-21 | Gadsden | Florida | 12039 | 321 | 6 |
262290 | 262290 | 2020-06-22 | Gadsden | Florida | 12039 | 325 | 6 |
265418 | 265418 | 2020-06-23 | Gadsden | Florida | 12039 | 328 | 6 |
268548 | 268548 | 2020-06-24 | Gadsden | Florida | 12039 | 331 | 6 |
271684 | 271684 | 2020-06-25 | Gadsden | Florida | 12039 | 336 | 6 |
274824 | 274824 | 2020-06-26 | Gadsden | Florida | 12039 | 351 | 6 |
277972 | 277972 | 2020-06-27 | Gadsden | Florida | 12039 | 364 | 7 |
281119 | 281119 | 2020-06-28 | Gadsden | Florida | 12039 | 372 | 7 |
284265 | 284265 | 2020-06-29 | Gadsden | Florida | 12039 | 375 | 7 |
287411 | 287411 | 2020-06-30 | Gadsden | Florida | 12039 | 378 | 7 |
290562 | 290562 | 2020-07-01 | Gadsden | Florida | 12039 | 388 | 7 |
293716 | 293716 | 2020-07-02 | Gadsden | Florida | 12039 | 405 | 7 |
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);