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 |
---|---|---|---|---|---|---|---|
534745 | 534745 | 2020-09-15 | Baker | Florida | 12003 | 1341 | 8 |
531510 | 531510 | 2020-09-14 | Baker | Florida | 12003 | 1330 | 7 |
528273 | 528273 | 2020-09-13 | Baker | Florida | 12003 | 1319 | 7 |
525037 | 525037 | 2020-09-12 | Baker | Florida | 12003 | 1307 | 7 |
521801 | 521801 | 2020-09-11 | Baker | Florida | 12003 | 1301 | 7 |
518564 | 518564 | 2020-09-10 | Baker | Florida | 12003 | 1286 | 6 |
515329 | 515329 | 2020-09-09 | Baker | Florida | 12003 | 1281 | 6 |
512096 | 512096 | 2020-09-08 | Baker | Florida | 12003 | 1273 | 6 |
508863 | 508863 | 2020-09-07 | Baker | Florida | 12003 | 1271 | 6 |
505631 | 505631 | 2020-09-06 | Baker | Florida | 12003 | 1259 | 6 |
502397 | 502397 | 2020-09-05 | Baker | Florida | 12003 | 1248 | 6 |
499163 | 499163 | 2020-09-04 | Baker | Florida | 12003 | 1238 | 6 |
495930 | 495930 | 2020-09-03 | Baker | Florida | 12003 | 1231 | 6 |
492696 | 492696 | 2020-09-02 | Baker | Florida | 12003 | 1212 | 6 |
489463 | 489463 | 2020-09-01 | Baker | Florida | 12003 | 1164 | 6 |
486230 | 486230 | 2020-08-31 | Baker | Florida | 12003 | 1153 | 5 |
482995 | 482995 | 2020-08-30 | Baker | Florida | 12003 | 1151 | 5 |
479761 | 479761 | 2020-08-29 | Baker | Florida | 12003 | 1148 | 5 |
476528 | 476528 | 2020-08-28 | Baker | Florida | 12003 | 1143 | 4 |
473295 | 473295 | 2020-08-27 | Baker | Florida | 12003 | 1136 | 4 |
470063 | 470063 | 2020-08-26 | Baker | Florida | 12003 | 1132 | 4 |
466834 | 466834 | 2020-08-25 | Baker | Florida | 12003 | 1118 | 4 |
463605 | 463605 | 2020-08-24 | Baker | Florida | 12003 | 1118 | 4 |
460376 | 460376 | 2020-08-23 | Baker | Florida | 12003 | 1117 | 4 |
457149 | 457149 | 2020-08-22 | Baker | Florida | 12003 | 1111 | 4 |
453921 | 453921 | 2020-08-21 | Baker | Florida | 12003 | 1108 | 4 |
450693 | 450693 | 2020-08-20 | Baker | Florida | 12003 | 1098 | 4 |
447465 | 447465 | 2020-08-19 | Baker | Florida | 12003 | 1088 | 4 |
444238 | 444238 | 2020-08-18 | Baker | Florida | 12003 | 1086 | 4 |
441012 | 441012 | 2020-08-17 | Baker | Florida | 12003 | 1078 | 4 |
437786 | 437786 | 2020-08-16 | Baker | Florida | 12003 | 1077 | 4 |
434560 | 434560 | 2020-08-15 | Baker | Florida | 12003 | 1070 | 4 |
431335 | 431335 | 2020-08-14 | Baker | Florida | 12003 | 1059 | 4 |
428107 | 428107 | 2020-08-13 | Baker | Florida | 12003 | 1052 | 4 |
424883 | 424883 | 2020-08-12 | Baker | Florida | 12003 | 1044 | 4 |
421662 | 421662 | 2020-08-11 | Baker | Florida | 12003 | 964 | 4 |
418441 | 418441 | 2020-08-10 | Baker | Florida | 12003 | 932 | 4 |
415220 | 415220 | 2020-08-09 | Baker | Florida | 12003 | 907 | 4 |
412000 | 412000 | 2020-08-08 | Baker | Florida | 12003 | 827 | 4 |
408781 | 408781 | 2020-08-07 | Baker | Florida | 12003 | 630 | 4 |
405561 | 405561 | 2020-08-06 | Baker | Florida | 12003 | 528 | 4 |
402343 | 402343 | 2020-08-05 | Baker | Florida | 12003 | 429 | 4 |
399127 | 399127 | 2020-08-04 | Baker | Florida | 12003 | 423 | 4 |
395911 | 395911 | 2020-08-03 | Baker | Florida | 12003 | 403 | 4 |
392695 | 392695 | 2020-08-02 | Baker | Florida | 12003 | 386 | 4 |
389478 | 389478 | 2020-08-01 | Baker | Florida | 12003 | 371 | 4 |
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 |
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);