ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Alachua" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
534744 | 534744 | 2020-09-15 | Alachua | Florida | 12001 | 6657 | 42 |
531509 | 531509 | 2020-09-14 | Alachua | Florida | 12001 | 6555 | 40 |
528272 | 528272 | 2020-09-13 | Alachua | Florida | 12001 | 6401 | 40 |
525036 | 525036 | 2020-09-12 | Alachua | Florida | 12001 | 6241 | 40 |
521800 | 521800 | 2020-09-11 | Alachua | Florida | 12001 | 6029 | 40 |
518563 | 518563 | 2020-09-10 | Alachua | Florida | 12001 | 5898 | 36 |
515328 | 515328 | 2020-09-09 | Alachua | Florida | 12001 | 5812 | 33 |
512095 | 512095 | 2020-09-08 | Alachua | Florida | 12001 | 5722 | 33 |
508862 | 508862 | 2020-09-07 | Alachua | Florida | 12001 | 5633 | 33 |
505630 | 505630 | 2020-09-06 | Alachua | Florida | 12001 | 5582 | 33 |
502396 | 502396 | 2020-09-05 | Alachua | Florida | 12001 | 5498 | 33 |
499162 | 499162 | 2020-09-04 | Alachua | Florida | 12001 | 5409 | 33 |
495929 | 495929 | 2020-09-03 | Alachua | Florida | 12001 | 5345 | 33 |
492695 | 492695 | 2020-09-02 | Alachua | Florida | 12001 | 5303 | 33 |
489462 | 489462 | 2020-09-01 | Alachua | Florida | 12001 | 5251 | 33 |
486229 | 486229 | 2020-08-31 | Alachua | Florida | 12001 | 5196 | 33 |
482994 | 482994 | 2020-08-30 | Alachua | Florida | 12001 | 5193 | 33 |
479760 | 479760 | 2020-08-29 | Alachua | Florida | 12001 | 5165 | 33 |
476527 | 476527 | 2020-08-28 | Alachua | Florida | 12001 | 5117 | 31 |
473294 | 473294 | 2020-08-27 | Alachua | Florida | 12001 | 5082 | 31 |
470062 | 470062 | 2020-08-26 | Alachua | Florida | 12001 | 5053 | 31 |
466833 | 466833 | 2020-08-25 | Alachua | Florida | 12001 | 5023 | 31 |
463604 | 463604 | 2020-08-24 | Alachua | Florida | 12001 | 4981 | 31 |
460375 | 460375 | 2020-08-23 | Alachua | Florida | 12001 | 4950 | 31 |
457148 | 457148 | 2020-08-22 | Alachua | Florida | 12001 | 4919 | 31 |
453920 | 453920 | 2020-08-21 | Alachua | Florida | 12001 | 4865 | 31 |
450692 | 450692 | 2020-08-20 | Alachua | Florida | 12001 | 4813 | 31 |
447464 | 447464 | 2020-08-19 | Alachua | Florida | 12001 | 4759 | 31 |
444237 | 444237 | 2020-08-18 | Alachua | Florida | 12001 | 4713 | 29 |
441011 | 441011 | 2020-08-17 | Alachua | Florida | 12001 | 4670 | 29 |
437785 | 437785 | 2020-08-16 | Alachua | Florida | 12001 | 4629 | 28 |
434559 | 434559 | 2020-08-15 | Alachua | Florida | 12001 | 4544 | 28 |
431334 | 431334 | 2020-08-14 | Alachua | Florida | 12001 | 4483 | 27 |
428106 | 428106 | 2020-08-13 | Alachua | Florida | 12001 | 4391 | 26 |
424882 | 424882 | 2020-08-12 | Alachua | Florida | 12001 | 4309 | 26 |
421661 | 421661 | 2020-08-11 | Alachua | Florida | 12001 | 4246 | 26 |
418440 | 418440 | 2020-08-10 | Alachua | Florida | 12001 | 4171 | 26 |
415219 | 415219 | 2020-08-09 | Alachua | Florida | 12001 | 4142 | 26 |
411999 | 411999 | 2020-08-08 | Alachua | Florida | 12001 | 4088 | 26 |
408780 | 408780 | 2020-08-07 | Alachua | Florida | 12001 | 4006 | 26 |
405560 | 405560 | 2020-08-06 | Alachua | Florida | 12001 | 3952 | 25 |
402342 | 402342 | 2020-08-05 | Alachua | Florida | 12001 | 3862 | 25 |
399126 | 399126 | 2020-08-04 | Alachua | Florida | 12001 | 3808 | 25 |
395910 | 395910 | 2020-08-03 | Alachua | Florida | 12001 | 3749 | 23 |
392694 | 392694 | 2020-08-02 | Alachua | Florida | 12001 | 3662 | 23 |
389477 | 389477 | 2020-08-01 | Alachua | Florida | 12001 | 3590 | 21 |
386260 | 386260 | 2020-07-31 | Alachua | Florida | 12001 | 3526 | 21 |
383042 | 383042 | 2020-07-30 | Alachua | Florida | 12001 | 3448 | 20 |
379825 | 379825 | 2020-07-29 | Alachua | Florida | 12001 | 3353 | 20 |
376608 | 376608 | 2020-07-28 | Alachua | Florida | 12001 | 3297 | 20 |
373394 | 373394 | 2020-07-27 | Alachua | Florida | 12001 | 3186 | 20 |
370182 | 370182 | 2020-07-26 | Alachua | Florida | 12001 | 3144 | 20 |
366972 | 366972 | 2020-07-25 | Alachua | Florida | 12001 | 3050 | 18 |
363765 | 363765 | 2020-07-24 | Alachua | Florida | 12001 | 2984 | 16 |
360558 | 360558 | 2020-07-23 | Alachua | Florida | 12001 | 2890 | 16 |
357353 | 357353 | 2020-07-22 | Alachua | Florida | 12001 | 2809 | 15 |
354150 | 354150 | 2020-07-21 | Alachua | Florida | 12001 | 2737 | 14 |
350948 | 350948 | 2020-07-20 | Alachua | Florida | 12001 | 2683 | 14 |
347747 | 347747 | 2020-07-19 | Alachua | Florida | 12001 | 2619 | 13 |
344547 | 344547 | 2020-07-18 | Alachua | Florida | 12001 | 2531 | 12 |
341348 | 341348 | 2020-07-17 | Alachua | Florida | 12001 | 2465 | 12 |
338151 | 338151 | 2020-07-16 | Alachua | Florida | 12001 | 2397 | 12 |
334956 | 334956 | 2020-07-15 | Alachua | Florida | 12001 | 2322 | 12 |
331763 | 331763 | 2020-07-14 | Alachua | Florida | 12001 | 2258 | 12 |
328576 | 328576 | 2020-07-13 | Alachua | Florida | 12001 | 2173 | 12 |
325390 | 325390 | 2020-07-12 | Alachua | Florida | 12001 | 2098 | 12 |
322209 | 322209 | 2020-07-11 | Alachua | Florida | 12001 | 2043 | 12 |
319030 | 319030 | 2020-07-10 | Alachua | Florida | 12001 | 1978 | 12 |
315857 | 315857 | 2020-07-09 | Alachua | Florida | 12001 | 1871 | 12 |
312682 | 312682 | 2020-07-08 | Alachua | Florida | 12001 | 1792 | 12 |
309512 | 309512 | 2020-07-07 | Alachua | Florida | 12001 | 1701 | 12 |
306344 | 306344 | 2020-07-06 | Alachua | Florida | 12001 | 1636 | 12 |
303180 | 303180 | 2020-07-05 | Alachua | Florida | 12001 | 1578 | 12 |
300016 | 300016 | 2020-07-04 | Alachua | Florida | 12001 | 1506 | 12 |
296854 | 296854 | 2020-07-03 | Alachua | Florida | 12001 | 1423 | 12 |
293698 | 293698 | 2020-07-02 | Alachua | Florida | 12001 | 1332 | 12 |
290544 | 290544 | 2020-07-01 | Alachua | Florida | 12001 | 1245 | 12 |
287393 | 287393 | 2020-06-30 | Alachua | Florida | 12001 | 1197 | 12 |
284247 | 284247 | 2020-06-29 | Alachua | Florida | 12001 | 1159 | 12 |
281101 | 281101 | 2020-06-28 | Alachua | Florida | 12001 | 1124 | 12 |
277954 | 277954 | 2020-06-27 | Alachua | Florida | 12001 | 1033 | 12 |
274806 | 274806 | 2020-06-26 | Alachua | Florida | 12001 | 945 | 12 |
271666 | 271666 | 2020-06-25 | Alachua | Florida | 12001 | 863 | 11 |
268530 | 268530 | 2020-06-24 | Alachua | Florida | 12001 | 807 | 11 |
265400 | 265400 | 2020-06-23 | Alachua | Florida | 12001 | 760 | 11 |
262272 | 262272 | 2020-06-22 | Alachua | Florida | 12001 | 738 | 11 |
259145 | 259145 | 2020-06-21 | Alachua | Florida | 12001 | 716 | 11 |
256018 | 256018 | 2020-06-20 | Alachua | Florida | 12001 | 673 | 11 |
252899 | 252899 | 2020-06-19 | Alachua | Florida | 12001 | 633 | 11 |
249784 | 249784 | 2020-06-18 | Alachua | Florida | 12001 | 600 | 11 |
246672 | 246672 | 2020-06-17 | Alachua | Florida | 12001 | 580 | 10 |
243559 | 243559 | 2020-06-16 | Alachua | Florida | 12001 | 564 | 10 |
240448 | 240448 | 2020-06-15 | Alachua | Florida | 12001 | 551 | 10 |
237340 | 237340 | 2020-06-14 | Alachua | Florida | 12001 | 541 | 10 |
234233 | 234233 | 2020-06-13 | Alachua | Florida | 12001 | 531 | 10 |
231127 | 231127 | 2020-06-12 | Alachua | Florida | 12001 | 506 | 10 |
228024 | 228024 | 2020-06-11 | Alachua | Florida | 12001 | 443 | 9 |
224922 | 224922 | 2020-06-10 | Alachua | Florida | 12001 | 412 | 8 |
221827 | 221827 | 2020-06-09 | Alachua | Florida | 12001 | 404 | 8 |
218732 | 218732 | 2020-06-08 | Alachua | Florida | 12001 | 399 | 8 |
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);