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 state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, date (date)
county 4
- St. Croix 768
- St. John 768
- St. Thomas 768
- Unknown 188
state 1
- Virgin Islands · 2,492 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2268 | 2268 | 2020-03-14 | Unknown | Virgin Islands | 1 | 0 | |
2695 | 2695 | 2020-03-15 | Unknown | Virgin Islands | 1 | 0 | |
3167 | 3167 | 2020-03-16 | Unknown | Virgin Islands | 2 | 0 | |
3703 | 3703 | 2020-03-17 | Unknown | Virgin Islands | 2 | 0 | |
4335 | 4335 | 2020-03-18 | Unknown | Virgin Islands | 3 | 0 | |
5091 | 5091 | 2020-03-19 | Unknown | Virgin Islands | 3 | 0 | |
5987 | 5987 | 2020-03-20 | Unknown | Virgin Islands | 6 | 0 | |
7012 | 7012 | 2020-03-21 | Unknown | Virgin Islands | 6 | 0 | |
8142 | 8142 | 2020-03-22 | Unknown | Virgin Islands | 17 | 0 | |
9363 | 9363 | 2020-03-23 | Unknown | Virgin Islands | 17 | 0 | |
10709 | 10709 | 2020-03-24 | Unknown | Virgin Islands | 17 | 0 | |
12221 | 12221 | 2020-03-25 | Unknown | Virgin Islands | 17 | 0 | |
13857 | 13857 | 2020-03-26 | Unknown | Virgin Islands | 17 | 0 | |
15623 | 15623 | 2020-03-27 | Unknown | Virgin Islands | 19 | 0 | |
17497 | 17497 | 2020-03-28 | Unknown | Virgin Islands | 19 | 0 | |
19456 | 19456 | 2020-03-29 | Unknown | Virgin Islands | 23 | 0 | |
21519 | 21519 | 2020-03-30 | Unknown | Virgin Islands | 30 | 0 | |
23658 | 23658 | 2020-03-31 | Unknown | Virgin Islands | 30 | 0 | |
25873 | 25873 | 2020-04-01 | Unknown | Virgin Islands | 30 | 0 | |
28162 | 28162 | 2020-04-02 | Unknown | Virgin Islands | 37 | 0 | |
30505 | 30505 | 2020-04-03 | Unknown | Virgin Islands | 38 | 0 | |
32903 | 32903 | 2020-04-04 | Unknown | Virgin Islands | 42 | 0 | |
35341 | 35341 | 2020-04-05 | Unknown | Virgin Islands | 42 | 0 | |
37819 | 37819 | 2020-04-06 | St. Croix | Virgin Islands | 78010 | 13 | 0 |
37820 | 37820 | 2020-04-06 | St. John | Virgin Islands | 78020 | 2 | 0 |
37821 | 37821 | 2020-04-06 | St. Thomas | Virgin Islands | 78030 | 29 | 0 |
37822 | 37822 | 2020-04-06 | Unknown | Virgin Islands | 0 | 1 | |
40349 | 40349 | 2020-04-07 | St. Croix | Virgin Islands | 78010 | 14 | 0 |
40350 | 40350 | 2020-04-07 | St. John | Virgin Islands | 78020 | 2 | 0 |
40351 | 40351 | 2020-04-07 | St. Thomas | Virgin Islands | 78030 | 29 | 0 |
40352 | 40352 | 2020-04-07 | Unknown | Virgin Islands | 0 | 1 | |
42918 | 42918 | 2020-04-08 | St. Croix | Virgin Islands | 78010 | 14 | 0 |
42919 | 42919 | 2020-04-08 | St. John | Virgin Islands | 78020 | 2 | 0 |
42920 | 42920 | 2020-04-08 | St. Thomas | Virgin Islands | 78030 | 30 | 0 |
42921 | 42921 | 2020-04-08 | Unknown | Virgin Islands | 0 | 1 | |
45512 | 45512 | 2020-04-09 | St. Croix | Virgin Islands | 78010 | 14 | 0 |
45513 | 45513 | 2020-04-09 | St. John | Virgin Islands | 78020 | 2 | 0 |
45514 | 45514 | 2020-04-09 | St. Thomas | Virgin Islands | 78030 | 34 | 0 |
45515 | 45515 | 2020-04-09 | Unknown | Virgin Islands | 0 | 1 | |
48136 | 48136 | 2020-04-10 | St. Croix | Virgin Islands | 78010 | 14 | 0 |
48137 | 48137 | 2020-04-10 | St. John | Virgin Islands | 78020 | 2 | 0 |
48138 | 48138 | 2020-04-10 | St. Thomas | Virgin Islands | 78030 | 35 | 0 |
48139 | 48139 | 2020-04-10 | Unknown | Virgin Islands | 0 | 1 | |
50794 | 50794 | 2020-04-11 | St. Croix | Virgin Islands | 78010 | 14 | 0 |
50795 | 50795 | 2020-04-11 | St. John | Virgin Islands | 78020 | 2 | 0 |
50796 | 50796 | 2020-04-11 | St. Thomas | Virgin Islands | 78030 | 35 | 0 |
50797 | 50797 | 2020-04-11 | Unknown | Virgin Islands | 0 | 1 | |
53469 | 53469 | 2020-04-12 | St. Croix | Virgin Islands | 78010 | 14 | 0 |
53470 | 53470 | 2020-04-12 | St. John | Virgin Islands | 78020 | 2 | 0 |
53471 | 53471 | 2020-04-12 | St. Thomas | Virgin Islands | 78030 | 35 | 0 |
53472 | 53472 | 2020-04-12 | Unknown | Virgin Islands | 0 | 1 | |
56158 | 56158 | 2020-04-13 | St. Croix | Virgin Islands | 78010 | 14 | 0 |
56159 | 56159 | 2020-04-13 | St. John | Virgin Islands | 78020 | 2 | 0 |
56160 | 56160 | 2020-04-13 | St. Thomas | Virgin Islands | 78030 | 35 | 0 |
56161 | 56161 | 2020-04-13 | Unknown | Virgin Islands | 0 | 1 | |
58864 | 58864 | 2020-04-14 | St. Croix | Virgin Islands | 78010 | 14 | 0 |
58865 | 58865 | 2020-04-14 | St. John | Virgin Islands | 78020 | 2 | 0 |
58866 | 58866 | 2020-04-14 | St. Thomas | Virgin Islands | 78030 | 35 | 0 |
58867 | 58867 | 2020-04-14 | Unknown | Virgin Islands | 0 | 1 | |
61583 | 61583 | 2020-04-15 | St. Croix | Virgin Islands | 78010 | 14 | 0 |
61584 | 61584 | 2020-04-15 | St. John | Virgin Islands | 78020 | 2 | 0 |
61585 | 61585 | 2020-04-15 | St. Thomas | Virgin Islands | 78030 | 35 | 0 |
61586 | 61586 | 2020-04-15 | Unknown | Virgin Islands | 0 | 1 | |
64315 | 64315 | 2020-04-16 | St. Croix | Virgin Islands | 78010 | 14 | 0 |
64316 | 64316 | 2020-04-16 | St. John | Virgin Islands | 78020 | 2 | 0 |
64317 | 64317 | 2020-04-16 | St. Thomas | Virgin Islands | 78030 | 35 | 0 |
64318 | 64318 | 2020-04-16 | Unknown | Virgin Islands | 0 | 1 | |
67063 | 67063 | 2020-04-17 | St. Croix | Virgin Islands | 78010 | 15 | 0 |
67064 | 67064 | 2020-04-17 | St. John | Virgin Islands | 78020 | 2 | 0 |
67065 | 67065 | 2020-04-17 | St. Thomas | Virgin Islands | 78030 | 36 | 0 |
67066 | 67066 | 2020-04-17 | Unknown | Virgin Islands | 0 | 2 | |
69825 | 69825 | 2020-04-18 | St. Croix | Virgin Islands | 78010 | 15 | 0 |
69826 | 69826 | 2020-04-18 | St. John | Virgin Islands | 78020 | 2 | 0 |
69827 | 69827 | 2020-04-18 | St. Thomas | Virgin Islands | 78030 | 36 | 0 |
69828 | 69828 | 2020-04-18 | Unknown | Virgin Islands | 0 | 3 | |
72595 | 72595 | 2020-04-19 | St. Croix | Virgin Islands | 78010 | 15 | 0 |
72596 | 72596 | 2020-04-19 | St. John | Virgin Islands | 78020 | 2 | 0 |
72597 | 72597 | 2020-04-19 | St. Thomas | Virgin Islands | 78030 | 36 | 0 |
72598 | 72598 | 2020-04-19 | Unknown | Virgin Islands | 0 | 3 | |
75371 | 75371 | 2020-04-20 | St. Croix | Virgin Islands | 78010 | 16 | 0 |
75372 | 75372 | 2020-04-20 | St. John | Virgin Islands | 78020 | 2 | 0 |
75373 | 75373 | 2020-04-20 | St. Thomas | Virgin Islands | 78030 | 36 | 0 |
75374 | 75374 | 2020-04-20 | Unknown | Virgin Islands | 0 | 3 | |
78153 | 78153 | 2020-04-21 | St. Croix | Virgin Islands | 78010 | 16 | 0 |
78154 | 78154 | 2020-04-21 | St. John | Virgin Islands | 78020 | 2 | 0 |
78155 | 78155 | 2020-04-21 | St. Thomas | Virgin Islands | 78030 | 36 | 0 |
78156 | 78156 | 2020-04-21 | Unknown | Virgin Islands | 0 | 3 | |
80945 | 80945 | 2020-04-22 | St. Croix | Virgin Islands | 78010 | 16 | 0 |
80946 | 80946 | 2020-04-22 | St. John | Virgin Islands | 78020 | 2 | 0 |
80947 | 80947 | 2020-04-22 | St. Thomas | Virgin Islands | 78030 | 36 | 0 |
80948 | 80948 | 2020-04-22 | Unknown | Virgin Islands | 0 | 3 | |
83746 | 83746 | 2020-04-23 | St. Croix | Virgin Islands | 78010 | 16 | 0 |
83747 | 83747 | 2020-04-23 | St. John | Virgin Islands | 78020 | 2 | 0 |
83748 | 83748 | 2020-04-23 | St. Thomas | Virgin Islands | 78030 | 36 | 0 |
83749 | 83749 | 2020-04-23 | Unknown | Virgin Islands | 0 | 3 | |
86553 | 86553 | 2020-04-24 | St. Croix | Virgin Islands | 78010 | 17 | 0 |
86554 | 86554 | 2020-04-24 | St. John | Virgin Islands | 78020 | 2 | 0 |
86555 | 86555 | 2020-04-24 | St. Thomas | Virgin Islands | 78030 | 36 | 0 |
86556 | 86556 | 2020-04-24 | Unknown | Virgin Islands | 0 | 3 | |
89368 | 89368 | 2020-04-25 | St. Croix | Virgin Islands | 78010 | 19 | 0 |
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);