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. John 617
- St. Thomas 617
- St. Croix 616
- Unknown 160
state 1
- Virgin Islands · 2,010 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2011284 | 2011284 | 2021-12-13 | St. John | Virgin Islands | 78020 | 340 | 4 |
2011285 | 2011285 | 2021-12-13 | St. Thomas | Virgin Islands | 78030 | 3715 | 46 |
2008032 | 2008032 | 2021-12-12 | St. Croix | Virgin Islands | 78010 | 3545 | 37 |
2008033 | 2008033 | 2021-12-12 | St. John | Virgin Islands | 78020 | 339 | 4 |
2008034 | 2008034 | 2021-12-12 | St. Thomas | Virgin Islands | 78030 | 3704 | 46 |
2004781 | 2004781 | 2021-12-11 | St. Croix | Virgin Islands | 78010 | 3545 | 37 |
2004782 | 2004782 | 2021-12-11 | St. John | Virgin Islands | 78020 | 339 | 4 |
2004783 | 2004783 | 2021-12-11 | St. Thomas | Virgin Islands | 78030 | 3704 | 46 |
2001530 | 2001530 | 2021-12-10 | St. Croix | Virgin Islands | 78010 | 3545 | 37 |
2001531 | 2001531 | 2021-12-10 | St. John | Virgin Islands | 78020 | 339 | 4 |
2001532 | 2001532 | 2021-12-10 | St. Thomas | Virgin Islands | 78030 | 3704 | 46 |
1998280 | 1998280 | 2021-12-09 | St. Croix | Virgin Islands | 78010 | 3545 | 37 |
1998281 | 1998281 | 2021-12-09 | St. John | Virgin Islands | 78020 | 339 | 4 |
1998282 | 1998282 | 2021-12-09 | St. Thomas | Virgin Islands | 78030 | 3704 | 46 |
1995029 | 1995029 | 2021-12-08 | St. Croix | Virgin Islands | 78010 | 3541 | 37 |
1995030 | 1995030 | 2021-12-08 | St. John | Virgin Islands | 78020 | 338 | 4 |
1995031 | 1995031 | 2021-12-08 | St. Thomas | Virgin Islands | 78030 | 3703 | 46 |
1991778 | 1991778 | 2021-12-07 | St. Croix | Virgin Islands | 78010 | 3535 | 37 |
1991779 | 1991779 | 2021-12-07 | St. John | Virgin Islands | 78020 | 338 | 4 |
1991780 | 1991780 | 2021-12-07 | St. Thomas | Virgin Islands | 78030 | 3696 | 46 |
1988527 | 1988527 | 2021-12-06 | St. Croix | Virgin Islands | 78010 | 3516 | 37 |
1988528 | 1988528 | 2021-12-06 | St. John | Virgin Islands | 78020 | 338 | 4 |
1988529 | 1988529 | 2021-12-06 | St. Thomas | Virgin Islands | 78030 | 3695 | 46 |
1985277 | 1985277 | 2021-12-05 | St. Croix | Virgin Islands | 78010 | 3503 | 37 |
1985278 | 1985278 | 2021-12-05 | St. John | Virgin Islands | 78020 | 338 | 4 |
1985279 | 1985279 | 2021-12-05 | St. Thomas | Virgin Islands | 78030 | 3689 | 46 |
1982027 | 1982027 | 2021-12-04 | St. Croix | Virgin Islands | 78010 | 3503 | 37 |
1982028 | 1982028 | 2021-12-04 | St. John | Virgin Islands | 78020 | 338 | 4 |
1982029 | 1982029 | 2021-12-04 | St. Thomas | Virgin Islands | 78030 | 3689 | 46 |
1978777 | 1978777 | 2021-12-03 | St. Croix | Virgin Islands | 78010 | 3503 | 37 |
1978778 | 1978778 | 2021-12-03 | St. John | Virgin Islands | 78020 | 338 | 4 |
1978779 | 1978779 | 2021-12-03 | St. Thomas | Virgin Islands | 78030 | 3689 | 46 |
1975527 | 1975527 | 2021-12-02 | St. Croix | Virgin Islands | 78010 | 3499 | 37 |
1975528 | 1975528 | 2021-12-02 | St. John | Virgin Islands | 78020 | 338 | 4 |
1975529 | 1975529 | 2021-12-02 | St. Thomas | Virgin Islands | 78030 | 3688 | 46 |
1972278 | 1972278 | 2021-12-01 | St. Croix | Virgin Islands | 78010 | 3491 | 37 |
1972279 | 1972279 | 2021-12-01 | St. John | Virgin Islands | 78020 | 337 | 4 |
1972280 | 1972280 | 2021-12-01 | St. Thomas | Virgin Islands | 78030 | 3686 | 46 |
1969028 | 1969028 | 2021-11-30 | St. Croix | Virgin Islands | 78010 | 3488 | 37 |
1969029 | 1969029 | 2021-11-30 | St. John | Virgin Islands | 78020 | 337 | 3 |
1969030 | 1969030 | 2021-11-30 | St. Thomas | Virgin Islands | 78030 | 3686 | 46 |
1965777 | 1965777 | 2021-11-29 | St. Croix | Virgin Islands | 78010 | 3486 | 35 |
1965778 | 1965778 | 2021-11-29 | St. John | Virgin Islands | 78020 | 337 | 3 |
1965779 | 1965779 | 2021-11-29 | St. Thomas | Virgin Islands | 78030 | 3685 | 46 |
1965780 | 1965780 | 2021-11-29 | Unknown | Virgin Islands | 0 | 1 | |
1962525 | 1962525 | 2021-11-28 | St. Croix | Virgin Islands | 78010 | 3468 | 35 |
1962526 | 1962526 | 2021-11-28 | St. John | Virgin Islands | 78020 | 337 | 3 |
1962527 | 1962527 | 2021-11-28 | St. Thomas | Virgin Islands | 78030 | 3685 | 46 |
1962528 | 1962528 | 2021-11-28 | Unknown | Virgin Islands | 0 | 1 | |
1959274 | 1959274 | 2021-11-27 | St. Croix | Virgin Islands | 78010 | 3468 | 35 |
1959275 | 1959275 | 2021-11-27 | St. John | Virgin Islands | 78020 | 337 | 3 |
1959276 | 1959276 | 2021-11-27 | St. Thomas | Virgin Islands | 78030 | 3685 | 46 |
1959277 | 1959277 | 2021-11-27 | Unknown | Virgin Islands | 0 | 1 | |
1956023 | 1956023 | 2021-11-26 | St. Croix | Virgin Islands | 78010 | 3468 | 35 |
1956024 | 1956024 | 2021-11-26 | St. John | Virgin Islands | 78020 | 337 | 3 |
1956025 | 1956025 | 2021-11-26 | St. Thomas | Virgin Islands | 78030 | 3685 | 46 |
1956026 | 1956026 | 2021-11-26 | Unknown | Virgin Islands | 0 | 1 | |
1952772 | 1952772 | 2021-11-25 | St. Croix | Virgin Islands | 78010 | 3468 | 35 |
1952773 | 1952773 | 2021-11-25 | St. John | Virgin Islands | 78020 | 337 | 3 |
1952774 | 1952774 | 2021-11-25 | St. Thomas | Virgin Islands | 78030 | 3685 | 46 |
1952775 | 1952775 | 2021-11-25 | Unknown | Virgin Islands | 0 | 1 | |
1949521 | 1949521 | 2021-11-24 | St. Croix | Virgin Islands | 78010 | 3468 | 35 |
1949522 | 1949522 | 2021-11-24 | St. John | Virgin Islands | 78020 | 337 | 3 |
1949523 | 1949523 | 2021-11-24 | St. Thomas | Virgin Islands | 78030 | 3685 | 46 |
1949524 | 1949524 | 2021-11-24 | Unknown | Virgin Islands | 0 | 1 | |
1946270 | 1946270 | 2021-11-23 | St. Croix | Virgin Islands | 78010 | 3459 | 35 |
1946271 | 1946271 | 2021-11-23 | St. John | Virgin Islands | 78020 | 337 | 3 |
1946272 | 1946272 | 2021-11-23 | St. Thomas | Virgin Islands | 78030 | 3684 | 46 |
1946273 | 1946273 | 2021-11-23 | Unknown | Virgin Islands | 0 | 1 | |
1943019 | 1943019 | 2021-11-22 | St. Croix | Virgin Islands | 78010 | 3450 | 35 |
1943020 | 1943020 | 2021-11-22 | St. John | Virgin Islands | 78020 | 337 | 3 |
1943021 | 1943021 | 2021-11-22 | St. Thomas | Virgin Islands | 78030 | 3679 | 46 |
1943022 | 1943022 | 2021-11-22 | Unknown | Virgin Islands | 0 | 1 | |
1939769 | 1939769 | 2021-11-21 | St. Croix | Virgin Islands | 78010 | 3428 | 35 |
1939770 | 1939770 | 2021-11-21 | St. John | Virgin Islands | 78020 | 337 | 3 |
1939771 | 1939771 | 2021-11-21 | St. Thomas | Virgin Islands | 78030 | 3674 | 46 |
1939772 | 1939772 | 2021-11-21 | Unknown | Virgin Islands | 0 | 1 | |
1936519 | 1936519 | 2021-11-20 | St. Croix | Virgin Islands | 78010 | 3428 | 35 |
1936520 | 1936520 | 2021-11-20 | St. John | Virgin Islands | 78020 | 337 | 3 |
1936521 | 1936521 | 2021-11-20 | St. Thomas | Virgin Islands | 78030 | 3674 | 46 |
1936522 | 1936522 | 2021-11-20 | Unknown | Virgin Islands | 0 | 1 | |
1933269 | 1933269 | 2021-11-19 | St. Croix | Virgin Islands | 78010 | 3428 | 35 |
1933270 | 1933270 | 2021-11-19 | St. John | Virgin Islands | 78020 | 337 | 3 |
1933271 | 1933271 | 2021-11-19 | St. Thomas | Virgin Islands | 78030 | 3674 | 46 |
1933272 | 1933272 | 2021-11-19 | Unknown | Virgin Islands | 0 | 1 | |
1930018 | 1930018 | 2021-11-18 | St. Croix | Virgin Islands | 78010 | 3418 | 35 |
1930019 | 1930019 | 2021-11-18 | St. John | Virgin Islands | 78020 | 337 | 3 |
1930020 | 1930020 | 2021-11-18 | St. Thomas | Virgin Islands | 78030 | 3672 | 46 |
1926768 | 1926768 | 2021-11-17 | St. Croix | Virgin Islands | 78010 | 3375 | 35 |
1926769 | 1926769 | 2021-11-17 | St. John | Virgin Islands | 78020 | 337 | 3 |
1926770 | 1926770 | 2021-11-17 | St. Thomas | Virgin Islands | 78030 | 3668 | 46 |
1923518 | 1923518 | 2021-11-16 | St. Croix | Virgin Islands | 78010 | 3365 | 35 |
1923519 | 1923519 | 2021-11-16 | St. John | Virgin Islands | 78020 | 337 | 3 |
1923520 | 1923520 | 2021-11-16 | St. Thomas | Virgin Islands | 78030 | 3668 | 46 |
1920269 | 1920269 | 2021-11-15 | St. Croix | Virgin Islands | 78010 | 3365 | 35 |
1920270 | 1920270 | 2021-11-15 | St. John | Virgin Islands | 78020 | 337 | 3 |
1920271 | 1920271 | 2021-11-15 | St. Thomas | Virgin Islands | 78030 | 3668 | 46 |
1917019 | 1917019 | 2021-11-14 | St. Croix | Virgin Islands | 78010 | 3327 | 35 |
1917020 | 1917020 | 2021-11-14 | St. John | Virgin Islands | 78020 | 336 | 3 |
1917021 | 1917021 | 2021-11-14 | St. Thomas | Virgin Islands | 78030 | 3666 | 46 |
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);