ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Baker" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386261 | 386261 | 2020-07-31 | Baker | Florida | 12003 | 356 | 4 |
383043 | 383043 | 2020-07-30 | Baker | Florida | 12003 | 343 | 4 |
379826 | 379826 | 2020-07-29 | Baker | Florida | 12003 | 329 | 4 |
376609 | 376609 | 2020-07-28 | Baker | Florida | 12003 | 322 | 4 |
373395 | 373395 | 2020-07-27 | Baker | Florida | 12003 | 310 | 4 |
370183 | 370183 | 2020-07-26 | Baker | Florida | 12003 | 300 | 4 |
366973 | 366973 | 2020-07-25 | Baker | Florida | 12003 | 285 | 4 |
363766 | 363766 | 2020-07-24 | Baker | Florida | 12003 | 265 | 4 |
360559 | 360559 | 2020-07-23 | Baker | Florida | 12003 | 254 | 4 |
357354 | 357354 | 2020-07-22 | Baker | Florida | 12003 | 250 | 4 |
354151 | 354151 | 2020-07-21 | Baker | Florida | 12003 | 245 | 4 |
350949 | 350949 | 2020-07-20 | Baker | Florida | 12003 | 238 | 4 |
347748 | 347748 | 2020-07-19 | Baker | Florida | 12003 | 232 | 4 |
344548 | 344548 | 2020-07-18 | Baker | Florida | 12003 | 220 | 4 |
341349 | 341349 | 2020-07-17 | Baker | Florida | 12003 | 215 | 4 |
338152 | 338152 | 2020-07-16 | Baker | Florida | 12003 | 202 | 4 |
334957 | 334957 | 2020-07-15 | Baker | Florida | 12003 | 187 | 4 |
331764 | 331764 | 2020-07-14 | Baker | Florida | 12003 | 180 | 4 |
328577 | 328577 | 2020-07-13 | Baker | Florida | 12003 | 175 | 4 |
325391 | 325391 | 2020-07-12 | Baker | Florida | 12003 | 162 | 4 |
322210 | 322210 | 2020-07-11 | Baker | Florida | 12003 | 151 | 4 |
319031 | 319031 | 2020-07-10 | Baker | Florida | 12003 | 135 | 4 |
315858 | 315858 | 2020-07-09 | Baker | Florida | 12003 | 127 | 4 |
312683 | 312683 | 2020-07-08 | Baker | Florida | 12003 | 120 | 4 |
309513 | 309513 | 2020-07-07 | Baker | Florida | 12003 | 110 | 4 |
306345 | 306345 | 2020-07-06 | Baker | Florida | 12003 | 106 | 4 |
303181 | 303181 | 2020-07-05 | Baker | Florida | 12003 | 102 | 4 |
300017 | 300017 | 2020-07-04 | Baker | Florida | 12003 | 98 | 4 |
296855 | 296855 | 2020-07-03 | Baker | Florida | 12003 | 84 | 4 |
293699 | 293699 | 2020-07-02 | Baker | Florida | 12003 | 80 | 4 |
290545 | 290545 | 2020-07-01 | Baker | Florida | 12003 | 72 | 4 |
287394 | 287394 | 2020-06-30 | Baker | Florida | 12003 | 63 | 4 |
284248 | 284248 | 2020-06-29 | Baker | Florida | 12003 | 57 | 4 |
281102 | 281102 | 2020-06-28 | Baker | Florida | 12003 | 55 | 4 |
277955 | 277955 | 2020-06-27 | Baker | Florida | 12003 | 51 | 4 |
274807 | 274807 | 2020-06-26 | Baker | Florida | 12003 | 47 | 4 |
271667 | 271667 | 2020-06-25 | Baker | Florida | 12003 | 44 | 4 |
268531 | 268531 | 2020-06-24 | Baker | Florida | 12003 | 42 | 4 |
265401 | 265401 | 2020-06-23 | Baker | Florida | 12003 | 42 | 4 |
262273 | 262273 | 2020-06-22 | Baker | Florida | 12003 | 44 | 4 |
259146 | 259146 | 2020-06-21 | Baker | Florida | 12003 | 41 | 4 |
256019 | 256019 | 2020-06-20 | Baker | Florida | 12003 | 39 | 4 |
252900 | 252900 | 2020-06-19 | Baker | Florida | 12003 | 39 | 4 |
249785 | 249785 | 2020-06-18 | Baker | Florida | 12003 | 35 | 4 |
246673 | 246673 | 2020-06-17 | Baker | Florida | 12003 | 35 | 4 |
243560 | 243560 | 2020-06-16 | Baker | Florida | 12003 | 34 | 4 |
240449 | 240449 | 2020-06-15 | Baker | Florida | 12003 | 30 | 4 |
237341 | 237341 | 2020-06-14 | Baker | Florida | 12003 | 30 | 4 |
234234 | 234234 | 2020-06-13 | Baker | Florida | 12003 | 30 | 4 |
231128 | 231128 | 2020-06-12 | Baker | Florida | 12003 | 30 | 4 |
228025 | 228025 | 2020-06-11 | Baker | Florida | 12003 | 29 | 4 |
224923 | 224923 | 2020-06-10 | Baker | Florida | 12003 | 29 | 4 |
221828 | 221828 | 2020-06-09 | Baker | Florida | 12003 | 29 | 4 |
218733 | 218733 | 2020-06-08 | Baker | Florida | 12003 | 29 | 4 |
215642 | 215642 | 2020-06-07 | Baker | Florida | 12003 | 29 | 4 |
212555 | 212555 | 2020-06-06 | Baker | Florida | 12003 | 29 | 4 |
209470 | 209470 | 2020-06-05 | Baker | Florida | 12003 | 29 | 4 |
206389 | 206389 | 2020-06-04 | Baker | Florida | 12003 | 29 | 4 |
203309 | 203309 | 2020-06-03 | Baker | Florida | 12003 | 29 | 4 |
200233 | 200233 | 2020-06-02 | Baker | Florida | 12003 | 29 | 3 |
197160 | 197160 | 2020-06-01 | Baker | Florida | 12003 | 29 | 3 |
194090 | 194090 | 2020-05-31 | Baker | Florida | 12003 | 29 | 3 |
191023 | 191023 | 2020-05-30 | Baker | Florida | 12003 | 29 | 3 |
187958 | 187958 | 2020-05-29 | Baker | Florida | 12003 | 28 | 3 |
184902 | 184902 | 2020-05-28 | Baker | Florida | 12003 | 28 | 3 |
181848 | 181848 | 2020-05-27 | Baker | Florida | 12003 | 29 | 3 |
178804 | 178804 | 2020-05-26 | Baker | Florida | 12003 | 27 | 3 |
175760 | 175760 | 2020-05-25 | Baker | Florida | 12003 | 27 | 3 |
172717 | 172717 | 2020-05-24 | Baker | Florida | 12003 | 27 | 3 |
169676 | 169676 | 2020-05-23 | Baker | Florida | 12003 | 27 | 3 |
166639 | 166639 | 2020-05-22 | Baker | Florida | 12003 | 26 | 3 |
163606 | 163606 | 2020-05-21 | Baker | Florida | 12003 | 26 | 3 |
160578 | 160578 | 2020-05-20 | Baker | Florida | 12003 | 26 | 3 |
157552 | 157552 | 2020-05-19 | Baker | Florida | 12003 | 26 | 3 |
154536 | 154536 | 2020-05-18 | Baker | Florida | 12003 | 26 | 3 |
151524 | 151524 | 2020-05-17 | Baker | Florida | 12003 | 26 | 3 |
148515 | 148515 | 2020-05-16 | Baker | Florida | 12003 | 26 | 3 |
145512 | 145512 | 2020-05-15 | Baker | Florida | 12003 | 26 | 3 |
142512 | 142512 | 2020-05-14 | Baker | Florida | 12003 | 26 | 3 |
139516 | 139516 | 2020-05-13 | Baker | Florida | 12003 | 26 | 3 |
136525 | 136525 | 2020-05-12 | Baker | Florida | 12003 | 25 | 3 |
133536 | 133536 | 2020-05-11 | Baker | Florida | 12003 | 25 | 3 |
130545 | 130545 | 2020-05-10 | Baker | Florida | 12003 | 25 | 3 |
127554 | 127554 | 2020-05-09 | Baker | Florida | 12003 | 24 | 3 |
124567 | 124567 | 2020-05-08 | Baker | Florida | 12003 | 24 | 3 |
121588 | 121588 | 2020-05-07 | Baker | Florida | 12003 | 22 | 3 |
118619 | 118619 | 2020-05-06 | Baker | Florida | 12003 | 22 | 3 |
115659 | 115659 | 2020-05-05 | Baker | Florida | 12003 | 22 | 3 |
112776 | 112776 | 2020-05-04 | Baker | Florida | 12003 | 22 | 3 |
109901 | 109901 | 2020-05-03 | Baker | Florida | 12003 | 22 | 3 |
107032 | 107032 | 2020-05-02 | Baker | Florida | 12003 | 22 | 3 |
104167 | 104167 | 2020-05-01 | Baker | Florida | 12003 | 22 | 3 |
101312 | 101312 | 2020-04-30 | Baker | Florida | 12003 | 20 | 3 |
98462 | 98462 | 2020-04-29 | Baker | Florida | 12003 | 20 | 3 |
95617 | 95617 | 2020-04-28 | Baker | Florida | 12003 | 20 | 3 |
92785 | 92785 | 2020-04-27 | Baker | Florida | 12003 | 20 | 3 |
89967 | 89967 | 2020-04-26 | Baker | Florida | 12003 | 20 | 3 |
87150 | 87150 | 2020-04-25 | Baker | Florida | 12003 | 20 | 3 |
84342 | 84342 | 2020-04-24 | Baker | Florida | 12003 | 20 | 3 |
81542 | 81542 | 2020-04-23 | Baker | Florida | 12003 | 19 | 3 |
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);