ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
188 rows where county = "Unknown" and state = "Virgin Islands" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 | |
37822 | 37822 | 2020-04-06 | Unknown | Virgin Islands | 0 | 1 | |
40352 | 40352 | 2020-04-07 | Unknown | Virgin Islands | 0 | 1 | |
42921 | 42921 | 2020-04-08 | Unknown | Virgin Islands | 0 | 1 | |
45515 | 45515 | 2020-04-09 | Unknown | Virgin Islands | 0 | 1 | |
48139 | 48139 | 2020-04-10 | Unknown | Virgin Islands | 0 | 1 | |
50797 | 50797 | 2020-04-11 | Unknown | Virgin Islands | 0 | 1 | |
53472 | 53472 | 2020-04-12 | Unknown | Virgin Islands | 0 | 1 | |
56161 | 56161 | 2020-04-13 | Unknown | Virgin Islands | 0 | 1 | |
58867 | 58867 | 2020-04-14 | Unknown | Virgin Islands | 0 | 1 | |
61586 | 61586 | 2020-04-15 | Unknown | Virgin Islands | 0 | 1 | |
64318 | 64318 | 2020-04-16 | Unknown | Virgin Islands | 0 | 1 | |
67066 | 67066 | 2020-04-17 | Unknown | Virgin Islands | 0 | 2 | |
69828 | 69828 | 2020-04-18 | Unknown | Virgin Islands | 0 | 3 | |
72598 | 72598 | 2020-04-19 | Unknown | Virgin Islands | 0 | 3 | |
75374 | 75374 | 2020-04-20 | Unknown | Virgin Islands | 0 | 3 | |
78156 | 78156 | 2020-04-21 | Unknown | Virgin Islands | 0 | 3 | |
80948 | 80948 | 2020-04-22 | Unknown | Virgin Islands | 0 | 3 | |
83749 | 83749 | 2020-04-23 | Unknown | Virgin Islands | 0 | 3 | |
86556 | 86556 | 2020-04-24 | Unknown | Virgin Islands | 0 | 3 | |
89371 | 89371 | 2020-04-25 | Unknown | Virgin Islands | 0 | 3 | |
92188 | 92188 | 2020-04-26 | Unknown | Virgin Islands | 0 | 4 | |
95017 | 95017 | 2020-04-27 | Unknown | Virgin Islands | 0 | 4 | |
97859 | 97859 | 2020-04-28 | Unknown | Virgin Islands | 0 | 4 | |
100709 | 100709 | 2020-04-29 | Unknown | Virgin Islands | 0 | 4 | |
103564 | 103564 | 2020-04-30 | Unknown | Virgin Islands | 0 | 4 | |
106428 | 106428 | 2020-05-01 | Unknown | Virgin Islands | 0 | 4 | |
109297 | 109297 | 2020-05-02 | Unknown | Virgin Islands | 0 | 4 | |
112171 | 112171 | 2020-05-03 | Unknown | Virgin Islands | 0 | 4 | |
115054 | 115054 | 2020-05-04 | Unknown | Virgin Islands | 0 | 4 | |
118013 | 118013 | 2020-05-05 | Unknown | Virgin Islands | 0 | 4 | |
120977 | 120977 | 2020-05-06 | Unknown | Virgin Islands | 0 | 4 | |
123958 | 123958 | 2020-05-07 | Unknown | Virgin Islands | 0 | 4 | |
126943 | 126943 | 2020-05-08 | Unknown | Virgin Islands | 0 | 4 | |
129932 | 129932 | 2020-05-09 | Unknown | Virgin Islands | 0 | 4 | |
132922 | 132922 | 2020-05-10 | Unknown | Virgin Islands | 0 | 4 | |
135912 | 135912 | 2020-05-11 | Unknown | Virgin Islands | 0 | 5 | |
138903 | 138903 | 2020-05-12 | Unknown | Virgin Islands | 0 | 6 | |
141899 | 141899 | 2020-05-13 | Unknown | Virgin Islands | 0 | 6 | |
144896 | 144896 | 2020-05-14 | Unknown | Virgin Islands | 0 | 6 | |
147899 | 147899 | 2020-05-15 | Unknown | Virgin Islands | 0 | 6 | |
150908 | 150908 | 2020-05-16 | Unknown | Virgin Islands | 0 | 6 | |
153919 | 153919 | 2020-05-17 | Unknown | Virgin Islands | 0 | 6 | |
156936 | 156936 | 2020-05-18 | Unknown | Virgin Islands | 0 | 6 | |
159960 | 159960 | 2020-05-19 | Unknown | Virgin Islands | 0 | 6 | |
162988 | 162988 | 2020-05-20 | Unknown | Virgin Islands | 0 | 6 | |
166017 | 166017 | 2020-05-21 | Unknown | Virgin Islands | 0 | 6 | |
169053 | 169053 | 2020-05-22 | Unknown | Virgin Islands | 0 | 6 | |
172094 | 172094 | 2020-05-23 | Unknown | Virgin Islands | 0 | 6 | |
175137 | 175137 | 2020-05-24 | Unknown | Virgin Islands | 0 | 6 | |
178182 | 178182 | 2020-05-25 | Unknown | Virgin Islands | 0 | 6 | |
181226 | 181226 | 2020-05-26 | Unknown | Virgin Islands | 0 | 6 | |
184277 | 184277 | 2020-05-27 | Unknown | Virgin Islands | 0 | 6 | |
187334 | 187334 | 2020-05-28 | Unknown | Virgin Islands | 0 | 6 | |
190398 | 190398 | 2020-05-29 | Unknown | Virgin Islands | 0 | 6 | |
193464 | 193464 | 2020-05-30 | Unknown | Virgin Islands | 0 | 6 | |
196534 | 196534 | 2020-05-31 | Unknown | Virgin Islands | 0 | 6 | |
199607 | 199607 | 2020-06-01 | Unknown | Virgin Islands | 0 | 6 | |
202683 | 202683 | 2020-06-02 | Unknown | Virgin Islands | 0 | 6 | |
205762 | 205762 | 2020-06-03 | Unknown | Virgin Islands | 0 | 6 | |
208844 | 208844 | 2020-06-04 | Unknown | Virgin Islands | 0 | 6 | |
211929 | 211929 | 2020-06-05 | Unknown | Virgin Islands | 0 | 6 | |
215016 | 215016 | 2020-06-06 | Unknown | Virgin Islands | 0 | 6 | |
218106 | 218106 | 2020-06-07 | Unknown | Virgin Islands | 0 | 6 | |
221198 | 221198 | 2020-06-08 | Unknown | Virgin Islands | 0 | 6 | |
224294 | 224294 | 2020-06-09 | Unknown | Virgin Islands | 0 | 6 | |
227394 | 227394 | 2020-06-10 | Unknown | Virgin Islands | 0 | 6 | |
230498 | 230498 | 2020-06-11 | Unknown | Virgin Islands | 0 | 6 | |
233603 | 233603 | 2020-06-12 | Unknown | Virgin Islands | 0 | 6 | |
236710 | 236710 | 2020-06-13 | Unknown | Virgin Islands | 0 | 6 | |
239818 | 239818 | 2020-06-14 | Unknown | Virgin Islands | 0 | 6 | |
242929 | 242929 | 2020-06-15 | Unknown | Virgin Islands | 0 | 6 | |
246041 | 246041 | 2020-06-16 | Unknown | Virgin Islands | 0 | 6 | |
249153 | 249153 | 2020-06-17 | Unknown | Virgin Islands | 0 | 6 | |
252268 | 252268 | 2020-06-18 | Unknown | Virgin Islands | 0 | 6 | |
255386 | 255386 | 2020-06-19 | Unknown | Virgin Islands | 0 | 6 | |
258513 | 258513 | 2020-06-20 | Unknown | Virgin Islands | 0 | 6 | |
261640 | 261640 | 2020-06-21 | Unknown | Virgin Islands | 0 | 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);