ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,492 rows where state = "Virgin Islands" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 4
- St. Croix 194
- St. John 194
- St. Thomas 194
- Unknown 131
state 1
- Virgin Islands · 713 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637803 | 637803 | 2020-10-16 | St. Croix | Virgin Islands | 78010 | 491 | 6 |
637804 | 637804 | 2020-10-16 | St. John | Virgin Islands | 78020 | 66 | 1 |
637805 | 637805 | 2020-10-16 | St. Thomas | Virgin Islands | 78030 | 772 | 14 |
634558 | 634558 | 2020-10-15 | St. Croix | Virgin Islands | 78010 | 491 | 6 |
634559 | 634559 | 2020-10-15 | St. John | Virgin Islands | 78020 | 66 | 1 |
634560 | 634560 | 2020-10-15 | St. Thomas | Virgin Islands | 78030 | 772 | 14 |
631313 | 631313 | 2020-10-14 | St. Croix | Virgin Islands | 78010 | 491 | 6 |
631314 | 631314 | 2020-10-14 | St. John | Virgin Islands | 78020 | 65 | 1 |
631315 | 631315 | 2020-10-14 | St. Thomas | Virgin Islands | 78030 | 772 | 13 |
628069 | 628069 | 2020-10-13 | St. Croix | Virgin Islands | 78010 | 491 | 6 |
628070 | 628070 | 2020-10-13 | St. John | Virgin Islands | 78020 | 65 | 1 |
628071 | 628071 | 2020-10-13 | St. Thomas | Virgin Islands | 78030 | 772 | 13 |
624826 | 624826 | 2020-10-12 | St. Croix | Virgin Islands | 78010 | 489 | 6 |
624827 | 624827 | 2020-10-12 | St. John | Virgin Islands | 78020 | 65 | 1 |
624828 | 624828 | 2020-10-12 | St. Thomas | Virgin Islands | 78030 | 771 | 13 |
621583 | 621583 | 2020-10-11 | St. Croix | Virgin Islands | 78010 | 489 | 6 |
621584 | 621584 | 2020-10-11 | St. John | Virgin Islands | 78020 | 65 | 1 |
621585 | 621585 | 2020-10-11 | St. Thomas | Virgin Islands | 78030 | 771 | 13 |
618340 | 618340 | 2020-10-10 | St. Croix | Virgin Islands | 78010 | 489 | 6 |
618341 | 618341 | 2020-10-10 | St. John | Virgin Islands | 78020 | 65 | 1 |
618342 | 618342 | 2020-10-10 | St. Thomas | Virgin Islands | 78030 | 771 | 13 |
615098 | 615098 | 2020-10-09 | St. Croix | Virgin Islands | 78010 | 489 | 6 |
615099 | 615099 | 2020-10-09 | St. John | Virgin Islands | 78020 | 65 | 1 |
615100 | 615100 | 2020-10-09 | St. Thomas | Virgin Islands | 78030 | 770 | 13 |
611857 | 611857 | 2020-10-08 | St. Croix | Virgin Islands | 78010 | 489 | 6 |
611858 | 611858 | 2020-10-08 | St. John | Virgin Islands | 78020 | 65 | 1 |
611859 | 611859 | 2020-10-08 | St. Thomas | Virgin Islands | 78030 | 770 | 13 |
608615 | 608615 | 2020-10-07 | St. Croix | Virgin Islands | 78010 | 488 | 6 |
608616 | 608616 | 2020-10-07 | St. John | Virgin Islands | 78020 | 64 | 1 |
608617 | 608617 | 2020-10-07 | St. Thomas | Virgin Islands | 78030 | 770 | 13 |
605372 | 605372 | 2020-10-06 | St. Croix | Virgin Islands | 78010 | 488 | 6 |
605373 | 605373 | 2020-10-06 | St. John | Virgin Islands | 78020 | 64 | 1 |
605374 | 605374 | 2020-10-06 | St. Thomas | Virgin Islands | 78030 | 769 | 13 |
602130 | 602130 | 2020-10-05 | St. Croix | Virgin Islands | 78010 | 489 | 6 |
602131 | 602131 | 2020-10-05 | St. John | Virgin Islands | 78020 | 64 | 1 |
602132 | 602132 | 2020-10-05 | St. Thomas | Virgin Islands | 78030 | 769 | 13 |
598887 | 598887 | 2020-10-04 | St. Croix | Virgin Islands | 78010 | 495 | 6 |
598888 | 598888 | 2020-10-04 | St. John | Virgin Islands | 78020 | 64 | 1 |
598889 | 598889 | 2020-10-04 | St. Thomas | Virgin Islands | 78030 | 768 | 13 |
595644 | 595644 | 2020-10-03 | St. Croix | Virgin Islands | 78010 | 495 | 6 |
595645 | 595645 | 2020-10-03 | St. John | Virgin Islands | 78020 | 64 | 1 |
595646 | 595646 | 2020-10-03 | St. Thomas | Virgin Islands | 78030 | 768 | 13 |
592402 | 592402 | 2020-10-02 | St. Croix | Virgin Islands | 78010 | 496 | 6 |
592403 | 592403 | 2020-10-02 | St. John | Virgin Islands | 78020 | 64 | 1 |
592404 | 592404 | 2020-10-02 | St. Thomas | Virgin Islands | 78030 | 766 | 13 |
589162 | 589162 | 2020-10-01 | St. Croix | Virgin Islands | 78010 | 496 | 6 |
589163 | 589163 | 2020-10-01 | St. John | Virgin Islands | 78020 | 64 | 1 |
589164 | 589164 | 2020-10-01 | St. Thomas | Virgin Islands | 78030 | 766 | 13 |
585921 | 585921 | 2020-09-30 | St. Croix | Virgin Islands | 78010 | 494 | 6 |
585922 | 585922 | 2020-09-30 | St. John | Virgin Islands | 78020 | 60 | 1 |
585923 | 585923 | 2020-09-30 | St. Thomas | Virgin Islands | 78030 | 764 | 13 |
582681 | 582681 | 2020-09-29 | St. Croix | Virgin Islands | 78010 | 494 | 6 |
582682 | 582682 | 2020-09-29 | St. John | Virgin Islands | 78020 | 60 | 1 |
582683 | 582683 | 2020-09-29 | St. Thomas | Virgin Islands | 78030 | 764 | 13 |
579442 | 579442 | 2020-09-28 | St. Croix | Virgin Islands | 78010 | 494 | 6 |
579443 | 579443 | 2020-09-28 | St. John | Virgin Islands | 78020 | 60 | 1 |
579444 | 579444 | 2020-09-28 | St. Thomas | Virgin Islands | 78030 | 764 | 13 |
576201 | 576201 | 2020-09-27 | St. Croix | Virgin Islands | 78010 | 495 | 6 |
576202 | 576202 | 2020-09-27 | St. John | Virgin Islands | 78020 | 60 | 1 |
576203 | 576203 | 2020-09-27 | St. Thomas | Virgin Islands | 78030 | 762 | 12 |
572957 | 572957 | 2020-09-26 | St. Croix | Virgin Islands | 78010 | 495 | 6 |
572958 | 572958 | 2020-09-26 | St. John | Virgin Islands | 78020 | 60 | 1 |
572959 | 572959 | 2020-09-26 | St. Thomas | Virgin Islands | 78030 | 762 | 12 |
569715 | 569715 | 2020-09-25 | St. Croix | Virgin Islands | 78010 | 481 | 6 |
569716 | 569716 | 2020-09-25 | St. John | Virgin Islands | 78020 | 57 | 1 |
569717 | 569717 | 2020-09-25 | St. Thomas | Virgin Islands | 78030 | 758 | 12 |
566474 | 566474 | 2020-09-24 | St. Croix | Virgin Islands | 78010 | 475 | 6 |
566475 | 566475 | 2020-09-24 | St. John | Virgin Islands | 78020 | 57 | 1 |
566476 | 566476 | 2020-09-24 | St. Thomas | Virgin Islands | 78030 | 758 | 12 |
563233 | 563233 | 2020-09-23 | St. Croix | Virgin Islands | 78010 | 475 | 6 |
563234 | 563234 | 2020-09-23 | St. John | Virgin Islands | 78020 | 57 | 1 |
563235 | 563235 | 2020-09-23 | St. Thomas | Virgin Islands | 78030 | 758 | 12 |
559994 | 559994 | 2020-09-22 | St. Croix | Virgin Islands | 78010 | 465 | 6 |
559995 | 559995 | 2020-09-22 | St. John | Virgin Islands | 78020 | 57 | 1 |
559996 | 559996 | 2020-09-22 | St. Thomas | Virgin Islands | 78030 | 756 | 12 |
556758 | 556758 | 2020-09-21 | St. Croix | Virgin Islands | 78010 | 460 | 6 |
556759 | 556759 | 2020-09-21 | St. John | Virgin Islands | 78020 | 53 | 1 |
556760 | 556760 | 2020-09-21 | St. Thomas | Virgin Islands | 78030 | 756 | 12 |
553521 | 553521 | 2020-09-20 | St. Croix | Virgin Islands | 78010 | 460 | 6 |
553522 | 553522 | 2020-09-20 | St. John | Virgin Islands | 78020 | 53 | 1 |
553523 | 553523 | 2020-09-20 | St. Thomas | Virgin Islands | 78030 | 756 | 12 |
550282 | 550282 | 2020-09-19 | St. Croix | Virgin Islands | 78010 | 458 | 6 |
550283 | 550283 | 2020-09-19 | St. John | Virgin Islands | 78020 | 45 | 1 |
550284 | 550284 | 2020-09-19 | St. Thomas | Virgin Islands | 78030 | 754 | 12 |
547043 | 547043 | 2020-09-18 | St. Croix | Virgin Islands | 78010 | 458 | 6 |
547044 | 547044 | 2020-09-18 | St. John | Virgin Islands | 78020 | 45 | 1 |
547045 | 547045 | 2020-09-18 | St. Thomas | Virgin Islands | 78030 | 754 | 12 |
543806 | 543806 | 2020-09-17 | St. Croix | Virgin Islands | 78010 | 444 | 6 |
543807 | 543807 | 2020-09-17 | St. John | Virgin Islands | 78020 | 45 | 1 |
543808 | 543808 | 2020-09-17 | St. Thomas | Virgin Islands | 78030 | 749 | 12 |
540570 | 540570 | 2020-09-16 | St. Croix | Virgin Islands | 78010 | 443 | 6 |
540571 | 540571 | 2020-09-16 | St. John | Virgin Islands | 78020 | 45 | 1 |
540572 | 540572 | 2020-09-16 | St. Thomas | Virgin Islands | 78030 | 744 | 12 |
537333 | 537333 | 2020-09-15 | St. Croix | Virgin Islands | 78010 | 443 | 6 |
537334 | 537334 | 2020-09-15 | St. John | Virgin Islands | 78020 | 45 | 1 |
537335 | 537335 | 2020-09-15 | St. Thomas | Virgin Islands | 78030 | 744 | 12 |
534097 | 534097 | 2020-09-14 | St. Croix | Virgin Islands | 78010 | 441 | 6 |
534098 | 534098 | 2020-09-14 | St. John | Virgin Islands | 78020 | 44 | 1 |
534099 | 534099 | 2020-09-14 | St. Thomas | Virgin Islands | 78030 | 736 | 12 |
530862 | 530862 | 2020-09-13 | St. Croix | Virgin Islands | 78010 | 441 | 6 |
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);