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 282
- St. John 282
- St. Thomas 282
- Unknown 131
state 1
- Virgin Islands · 977 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923358 | 923358 | 2021-01-12 | St. Croix | Virgin Islands | 78010 | 892 | 8 |
923359 | 923359 | 2021-01-12 | St. John | Virgin Islands | 78020 | 178 | 1 |
923360 | 923360 | 2021-01-12 | St. Thomas | Virgin Islands | 78030 | 1096 | 15 |
920113 | 920113 | 2021-01-11 | St. Croix | Virgin Islands | 78010 | 835 | 7 |
920114 | 920114 | 2021-01-11 | St. John | Virgin Islands | 78020 | 175 | 1 |
920115 | 920115 | 2021-01-11 | St. Thomas | Virgin Islands | 78030 | 1032 | 15 |
916868 | 916868 | 2021-01-10 | St. Croix | Virgin Islands | 78010 | 835 | 7 |
916869 | 916869 | 2021-01-10 | St. John | Virgin Islands | 78020 | 175 | 1 |
916870 | 916870 | 2021-01-10 | St. Thomas | Virgin Islands | 78030 | 1032 | 15 |
913623 | 913623 | 2021-01-09 | St. Croix | Virgin Islands | 78010 | 835 | 7 |
913624 | 913624 | 2021-01-09 | St. John | Virgin Islands | 78020 | 175 | 1 |
913625 | 913625 | 2021-01-09 | St. Thomas | Virgin Islands | 78030 | 1032 | 15 |
910378 | 910378 | 2021-01-08 | St. Croix | Virgin Islands | 78010 | 835 | 7 |
910379 | 910379 | 2021-01-08 | St. John | Virgin Islands | 78020 | 175 | 1 |
910380 | 910380 | 2021-01-08 | St. Thomas | Virgin Islands | 78030 | 1032 | 15 |
907133 | 907133 | 2021-01-07 | St. Croix | Virgin Islands | 78010 | 835 | 7 |
907134 | 907134 | 2021-01-07 | St. John | Virgin Islands | 78020 | 175 | 1 |
907135 | 907135 | 2021-01-07 | St. Thomas | Virgin Islands | 78030 | 1032 | 15 |
903887 | 903887 | 2021-01-06 | St. Croix | Virgin Islands | 78010 | 835 | 7 |
903888 | 903888 | 2021-01-06 | St. John | Virgin Islands | 78020 | 175 | 1 |
903889 | 903889 | 2021-01-06 | St. Thomas | Virgin Islands | 78030 | 1032 | 15 |
900642 | 900642 | 2021-01-05 | St. Croix | Virgin Islands | 78010 | 835 | 7 |
900643 | 900643 | 2021-01-05 | St. John | Virgin Islands | 78020 | 175 | 1 |
900644 | 900644 | 2021-01-05 | St. Thomas | Virgin Islands | 78030 | 1032 | 15 |
897397 | 897397 | 2021-01-04 | St. Croix | Virgin Islands | 78010 | 835 | 7 |
897398 | 897398 | 2021-01-04 | St. John | Virgin Islands | 78020 | 175 | 1 |
897399 | 897399 | 2021-01-04 | St. Thomas | Virgin Islands | 78030 | 1032 | 15 |
894151 | 894151 | 2021-01-03 | St. Croix | Virgin Islands | 78010 | 835 | 7 |
894152 | 894152 | 2021-01-03 | St. John | Virgin Islands | 78020 | 175 | 1 |
894153 | 894153 | 2021-01-03 | St. Thomas | Virgin Islands | 78030 | 1032 | 15 |
890905 | 890905 | 2021-01-02 | St. Croix | Virgin Islands | 78010 | 835 | 7 |
890906 | 890906 | 2021-01-02 | St. John | Virgin Islands | 78020 | 175 | 1 |
890907 | 890907 | 2021-01-02 | St. Thomas | Virgin Islands | 78030 | 1032 | 15 |
887658 | 887658 | 2021-01-01 | St. Croix | Virgin Islands | 78010 | 830 | 7 |
887659 | 887659 | 2021-01-01 | St. John | Virgin Islands | 78020 | 174 | 1 |
887660 | 887660 | 2021-01-01 | St. Thomas | Virgin Islands | 78030 | 1032 | 15 |
884413 | 884413 | 2020-12-31 | St. Croix | Virgin Islands | 78010 | 829 | 7 |
884414 | 884414 | 2020-12-31 | St. John | Virgin Islands | 78020 | 174 | 1 |
884415 | 884415 | 2020-12-31 | St. Thomas | Virgin Islands | 78030 | 1028 | 15 |
881168 | 881168 | 2020-12-30 | St. Croix | Virgin Islands | 78010 | 822 | 7 |
881169 | 881169 | 2020-12-30 | St. John | Virgin Islands | 78020 | 168 | 1 |
881170 | 881170 | 2020-12-30 | St. Thomas | Virgin Islands | 78030 | 1020 | 15 |
877923 | 877923 | 2020-12-29 | St. Croix | Virgin Islands | 78010 | 809 | 7 |
877924 | 877924 | 2020-12-29 | St. John | Virgin Islands | 78020 | 166 | 1 |
877925 | 877925 | 2020-12-29 | St. Thomas | Virgin Islands | 78030 | 1004 | 15 |
874678 | 874678 | 2020-12-28 | St. Croix | Virgin Islands | 78010 | 809 | 7 |
874679 | 874679 | 2020-12-28 | St. John | Virgin Islands | 78020 | 166 | 1 |
874680 | 874680 | 2020-12-28 | St. Thomas | Virgin Islands | 78030 | 1004 | 15 |
871433 | 871433 | 2020-12-27 | St. Croix | Virgin Islands | 78010 | 809 | 7 |
871434 | 871434 | 2020-12-27 | St. John | Virgin Islands | 78020 | 166 | 1 |
871435 | 871435 | 2020-12-27 | St. Thomas | Virgin Islands | 78030 | 1004 | 15 |
868188 | 868188 | 2020-12-26 | St. Croix | Virgin Islands | 78010 | 809 | 7 |
868189 | 868189 | 2020-12-26 | St. John | Virgin Islands | 78020 | 166 | 1 |
868190 | 868190 | 2020-12-26 | St. Thomas | Virgin Islands | 78030 | 1004 | 15 |
864943 | 864943 | 2020-12-25 | St. Croix | Virgin Islands | 78010 | 809 | 7 |
864944 | 864944 | 2020-12-25 | St. John | Virgin Islands | 78020 | 166 | 1 |
864945 | 864945 | 2020-12-25 | St. Thomas | Virgin Islands | 78030 | 1004 | 15 |
861698 | 861698 | 2020-12-24 | St. Croix | Virgin Islands | 78010 | 799 | 7 |
861699 | 861699 | 2020-12-24 | St. John | Virgin Islands | 78020 | 166 | 1 |
861700 | 861700 | 2020-12-24 | St. Thomas | Virgin Islands | 78030 | 1002 | 15 |
858453 | 858453 | 2020-12-23 | St. Croix | Virgin Islands | 78010 | 794 | 7 |
858454 | 858454 | 2020-12-23 | St. John | Virgin Islands | 78020 | 166 | 1 |
858455 | 858455 | 2020-12-23 | St. Thomas | Virgin Islands | 78030 | 990 | 15 |
855208 | 855208 | 2020-12-22 | St. Croix | Virgin Islands | 78010 | 782 | 7 |
855209 | 855209 | 2020-12-22 | St. John | Virgin Islands | 78020 | 165 | 1 |
855210 | 855210 | 2020-12-22 | St. Thomas | Virgin Islands | 78030 | 987 | 15 |
851963 | 851963 | 2020-12-21 | St. Croix | Virgin Islands | 78010 | 777 | 7 |
851964 | 851964 | 2020-12-21 | St. John | Virgin Islands | 78020 | 158 | 1 |
851965 | 851965 | 2020-12-21 | St. Thomas | Virgin Islands | 78030 | 986 | 15 |
848718 | 848718 | 2020-12-20 | St. Croix | Virgin Islands | 78010 | 777 | 7 |
848719 | 848719 | 2020-12-20 | St. John | Virgin Islands | 78020 | 158 | 1 |
848720 | 848720 | 2020-12-20 | St. Thomas | Virgin Islands | 78030 | 986 | 15 |
845473 | 845473 | 2020-12-19 | St. Croix | Virgin Islands | 78010 | 769 | 7 |
845474 | 845474 | 2020-12-19 | St. John | Virgin Islands | 78020 | 158 | 1 |
845475 | 845475 | 2020-12-19 | St. Thomas | Virgin Islands | 78030 | 983 | 15 |
842227 | 842227 | 2020-12-18 | St. Croix | Virgin Islands | 78010 | 762 | 7 |
842228 | 842228 | 2020-12-18 | St. John | Virgin Islands | 78020 | 158 | 1 |
842229 | 842229 | 2020-12-18 | St. Thomas | Virgin Islands | 78030 | 980 | 15 |
838982 | 838982 | 2020-12-17 | St. Croix | Virgin Islands | 78010 | 753 | 7 |
838983 | 838983 | 2020-12-17 | St. John | Virgin Islands | 78020 | 151 | 1 |
838984 | 838984 | 2020-12-17 | St. Thomas | Virgin Islands | 78030 | 974 | 15 |
835736 | 835736 | 2020-12-16 | St. Croix | Virgin Islands | 78010 | 715 | 7 |
835737 | 835737 | 2020-12-16 | St. John | Virgin Islands | 78020 | 147 | 1 |
835738 | 835738 | 2020-12-16 | St. Thomas | Virgin Islands | 78030 | 966 | 15 |
832490 | 832490 | 2020-12-15 | St. Croix | Virgin Islands | 78010 | 715 | 7 |
832491 | 832491 | 2020-12-15 | St. John | Virgin Islands | 78020 | 147 | 1 |
832492 | 832492 | 2020-12-15 | St. Thomas | Virgin Islands | 78030 | 966 | 15 |
829243 | 829243 | 2020-12-14 | St. Croix | Virgin Islands | 78010 | 705 | 7 |
829244 | 829244 | 2020-12-14 | St. John | Virgin Islands | 78020 | 145 | 1 |
829245 | 829245 | 2020-12-14 | St. Thomas | Virgin Islands | 78030 | 957 | 15 |
825997 | 825997 | 2020-12-13 | St. Croix | Virgin Islands | 78010 | 697 | 7 |
825998 | 825998 | 2020-12-13 | St. John | Virgin Islands | 78020 | 145 | 1 |
825999 | 825999 | 2020-12-13 | St. Thomas | Virgin Islands | 78030 | 949 | 15 |
822750 | 822750 | 2020-12-12 | St. Croix | Virgin Islands | 78010 | 697 | 7 |
822751 | 822751 | 2020-12-12 | St. John | Virgin Islands | 78020 | 145 | 1 |
822752 | 822752 | 2020-12-12 | St. Thomas | Virgin Islands | 78030 | 949 | 15 |
819504 | 819504 | 2020-12-11 | St. Croix | Virgin Islands | 78010 | 697 | 7 |
819505 | 819505 | 2020-12-11 | St. John | Virgin Islands | 78020 | 145 | 1 |
819506 | 819506 | 2020-12-11 | St. Thomas | Virgin Islands | 78030 | 949 | 15 |
816258 | 816258 | 2020-12-10 | St. Croix | Virgin Islands | 78010 | 667 | 7 |
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);