ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Union" and fips = 12125 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635269 | 635269 | 2020-10-16 | Union | Florida | 12125 | 1066 | 27 |
632023 | 632023 | 2020-10-15 | Union | Florida | 12125 | 1058 | 26 |
628779 | 628779 | 2020-10-14 | Union | Florida | 12125 | 1041 | 25 |
625536 | 625536 | 2020-10-13 | Union | Florida | 12125 | 1037 | 25 |
622293 | 622293 | 2020-10-12 | Union | Florida | 12125 | 1029 | 25 |
619050 | 619050 | 2020-10-11 | Union | Florida | 12125 | 1029 | 25 |
615808 | 615808 | 2020-10-10 | Union | Florida | 12125 | 1016 | 24 |
612567 | 612567 | 2020-10-09 | Union | Florida | 12125 | 1016 | 24 |
609325 | 609325 | 2020-10-08 | Union | Florida | 12125 | 1012 | 23 |
606082 | 606082 | 2020-10-07 | Union | Florida | 12125 | 1009 | 23 |
602840 | 602840 | 2020-10-06 | Union | Florida | 12125 | 1001 | 23 |
599597 | 599597 | 2020-10-05 | Union | Florida | 12125 | 1000 | 18 |
596354 | 596354 | 2020-10-04 | Union | Florida | 12125 | 992 | 18 |
593112 | 593112 | 2020-10-03 | Union | Florida | 12125 | 989 | 17 |
589872 | 589872 | 2020-10-02 | Union | Florida | 12125 | 986 | 17 |
586631 | 586631 | 2020-10-01 | Union | Florida | 12125 | 980 | 16 |
583391 | 583391 | 2020-09-30 | Union | Florida | 12125 | 969 | 16 |
580152 | 580152 | 2020-09-29 | Union | Florida | 12125 | 966 | 15 |
576911 | 576911 | 2020-09-28 | Union | Florida | 12125 | 956 | 14 |
573668 | 573668 | 2020-09-27 | Union | Florida | 12125 | 955 | 14 |
570426 | 570426 | 2020-09-26 | Union | Florida | 12125 | 935 | 14 |
567184 | 567184 | 2020-09-25 | Union | Florida | 12125 | 926 | 13 |
563944 | 563944 | 2020-09-24 | Union | Florida | 12125 | 914 | 12 |
560704 | 560704 | 2020-09-23 | Union | Florida | 12125 | 903 | 12 |
557468 | 557468 | 2020-09-22 | Union | Florida | 12125 | 895 | 12 |
554231 | 554231 | 2020-09-21 | Union | Florida | 12125 | 885 | 12 |
550992 | 550992 | 2020-09-20 | Union | Florida | 12125 | 884 | 12 |
547753 | 547753 | 2020-09-19 | Union | Florida | 12125 | 874 | 12 |
544515 | 544515 | 2020-09-18 | Union | Florida | 12125 | 858 | 12 |
541279 | 541279 | 2020-09-17 | Union | Florida | 12125 | 839 | 10 |
538042 | 538042 | 2020-09-16 | Union | Florida | 12125 | 824 | 10 |
534806 | 534806 | 2020-09-15 | Union | Florida | 12125 | 820 | 8 |
531571 | 531571 | 2020-09-14 | Union | Florida | 12125 | 795 | 7 |
528334 | 528334 | 2020-09-13 | Union | Florida | 12125 | 798 | 7 |
525098 | 525098 | 2020-09-12 | Union | Florida | 12125 | 790 | 7 |
521862 | 521862 | 2020-09-11 | Union | Florida | 12125 | 779 | 6 |
518625 | 518625 | 2020-09-10 | Union | Florida | 12125 | 731 | 5 |
515390 | 515390 | 2020-09-09 | Union | Florida | 12125 | 715 | 5 |
512157 | 512157 | 2020-09-08 | Union | Florida | 12125 | 706 | 5 |
508924 | 508924 | 2020-09-07 | Union | Florida | 12125 | 690 | 5 |
505692 | 505692 | 2020-09-06 | Union | Florida | 12125 | 664 | 5 |
502458 | 502458 | 2020-09-05 | Union | Florida | 12125 | 654 | 5 |
499224 | 499224 | 2020-09-04 | Union | Florida | 12125 | 644 | 5 |
495991 | 495991 | 2020-09-03 | Union | Florida | 12125 | 636 | 5 |
492757 | 492757 | 2020-09-02 | Union | Florida | 12125 | 619 | 5 |
489524 | 489524 | 2020-09-01 | Union | Florida | 12125 | 603 | 5 |
486291 | 486291 | 2020-08-31 | Union | Florida | 12125 | 594 | 5 |
483056 | 483056 | 2020-08-30 | Union | Florida | 12125 | 592 | 5 |
479822 | 479822 | 2020-08-29 | Union | Florida | 12125 | 572 | 5 |
476589 | 476589 | 2020-08-28 | Union | Florida | 12125 | 569 | 5 |
473356 | 473356 | 2020-08-27 | Union | Florida | 12125 | 561 | 5 |
470124 | 470124 | 2020-08-26 | Union | Florida | 12125 | 547 | 5 |
466895 | 466895 | 2020-08-25 | Union | Florida | 12125 | 535 | 5 |
463666 | 463666 | 2020-08-24 | Union | Florida | 12125 | 533 | 5 |
460437 | 460437 | 2020-08-23 | Union | Florida | 12125 | 530 | 5 |
457210 | 457210 | 2020-08-22 | Union | Florida | 12125 | 526 | 5 |
453982 | 453982 | 2020-08-21 | Union | Florida | 12125 | 514 | 5 |
450754 | 450754 | 2020-08-20 | Union | Florida | 12125 | 505 | 5 |
447526 | 447526 | 2020-08-19 | Union | Florida | 12125 | 501 | 5 |
444299 | 444299 | 2020-08-18 | Union | Florida | 12125 | 493 | 5 |
441073 | 441073 | 2020-08-17 | Union | Florida | 12125 | 489 | 5 |
437847 | 437847 | 2020-08-16 | Union | Florida | 12125 | 488 | 5 |
434621 | 434621 | 2020-08-15 | Union | Florida | 12125 | 481 | 5 |
431396 | 431396 | 2020-08-14 | Union | Florida | 12125 | 459 | 5 |
428168 | 428168 | 2020-08-13 | Union | Florida | 12125 | 456 | 5 |
424944 | 424944 | 2020-08-12 | Union | Florida | 12125 | 448 | 5 |
421723 | 421723 | 2020-08-11 | Union | Florida | 12125 | 435 | 5 |
418502 | 418502 | 2020-08-10 | Union | Florida | 12125 | 374 | 5 |
415281 | 415281 | 2020-08-09 | Union | Florida | 12125 | 310 | 5 |
412061 | 412061 | 2020-08-08 | Union | Florida | 12125 | 297 | 5 |
408842 | 408842 | 2020-08-07 | Union | Florida | 12125 | 291 | 4 |
405622 | 405622 | 2020-08-06 | Union | Florida | 12125 | 244 | 4 |
402404 | 402404 | 2020-08-05 | Union | Florida | 12125 | 259 | 4 |
399188 | 399188 | 2020-08-04 | Union | Florida | 12125 | 227 | 4 |
395972 | 395972 | 2020-08-03 | Union | Florida | 12125 | 225 | 4 |
392756 | 392756 | 2020-08-02 | Union | Florida | 12125 | 225 | 4 |
389539 | 389539 | 2020-08-01 | Union | Florida | 12125 | 218 | 4 |
386322 | 386322 | 2020-07-31 | Union | Florida | 12125 | 215 | 4 |
383104 | 383104 | 2020-07-30 | Union | Florida | 12125 | 206 | 4 |
379887 | 379887 | 2020-07-29 | Union | Florida | 12125 | 200 | 4 |
376670 | 376670 | 2020-07-28 | Union | Florida | 12125 | 247 | 4 |
373456 | 373456 | 2020-07-27 | Union | Florida | 12125 | 234 | 4 |
370244 | 370244 | 2020-07-26 | Union | Florida | 12125 | 212 | 4 |
367034 | 367034 | 2020-07-25 | Union | Florida | 12125 | 183 | 4 |
363827 | 363827 | 2020-07-24 | Union | Florida | 12125 | 178 | 3 |
360620 | 360620 | 2020-07-23 | Union | Florida | 12125 | 169 | 3 |
357415 | 357415 | 2020-07-22 | Union | Florida | 12125 | 161 | 3 |
354212 | 354212 | 2020-07-21 | Union | Florida | 12125 | 145 | 3 |
351010 | 351010 | 2020-07-20 | Union | Florida | 12125 | 142 | 3 |
347809 | 347809 | 2020-07-19 | Union | Florida | 12125 | 142 | 3 |
344609 | 344609 | 2020-07-18 | Union | Florida | 12125 | 141 | 2 |
341410 | 341410 | 2020-07-17 | Union | Florida | 12125 | 139 | 2 |
338213 | 338213 | 2020-07-16 | Union | Florida | 12125 | 133 | 2 |
335018 | 335018 | 2020-07-15 | Union | Florida | 12125 | 123 | 2 |
331825 | 331825 | 2020-07-14 | Union | Florida | 12125 | 120 | 2 |
328638 | 328638 | 2020-07-13 | Union | Florida | 12125 | 114 | 2 |
325452 | 325452 | 2020-07-12 | Union | Florida | 12125 | 114 | 2 |
322271 | 322271 | 2020-07-11 | Union | Florida | 12125 | 109 | 2 |
319092 | 319092 | 2020-07-10 | Union | Florida | 12125 | 105 | 2 |
315919 | 315919 | 2020-07-09 | Union | Florida | 12125 | 101 | 2 |
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);