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 descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1196034 | 1196034 | 2021-04-06 | Unknown | Virgin Islands | 1 | 0 | |
1192786 | 1192786 | 2021-04-05 | Unknown | Virgin Islands | 1 | 0 | |
1160310 | 1160310 | 2021-03-26 | Unknown | Virgin Islands | 0 | 1 | |
359917 | 359917 | 2020-07-22 | Unknown | Virgin Islands | 0 | 7 | |
356712 | 356712 | 2020-07-21 | Unknown | Virgin Islands | 0 | 6 | |
353509 | 353509 | 2020-07-20 | Unknown | Virgin Islands | 0 | 6 | |
350307 | 350307 | 2020-07-19 | Unknown | Virgin Islands | 0 | 6 | |
347106 | 347106 | 2020-07-18 | Unknown | Virgin Islands | 0 | 6 | |
343906 | 343906 | 2020-07-17 | Unknown | Virgin Islands | 0 | 6 | |
340707 | 340707 | 2020-07-16 | Unknown | Virgin Islands | 0 | 6 | |
337511 | 337511 | 2020-07-15 | Unknown | Virgin Islands | 0 | 6 | |
334316 | 334316 | 2020-07-14 | Unknown | Virgin Islands | 0 | 6 | |
331123 | 331123 | 2020-07-13 | Unknown | Virgin Islands | 0 | 6 | |
327937 | 327937 | 2020-07-12 | Unknown | Virgin Islands | 0 | 6 | |
324752 | 324752 | 2020-07-11 | Unknown | Virgin Islands | 0 | 6 | |
321571 | 321571 | 2020-07-10 | Unknown | Virgin Islands | 0 | 6 | |
318392 | 318392 | 2020-07-09 | Unknown | Virgin Islands | 0 | 6 | |
315219 | 315219 | 2020-07-08 | Unknown | Virgin Islands | 0 | 6 | |
312045 | 312045 | 2020-07-07 | Unknown | Virgin Islands | 0 | 6 | |
308876 | 308876 | 2020-07-06 | Unknown | Virgin Islands | 0 | 6 | |
305708 | 305708 | 2020-07-05 | Unknown | Virgin Islands | 0 | 6 | |
302544 | 302544 | 2020-07-04 | Unknown | Virgin Islands | 0 | 6 | |
299380 | 299380 | 2020-07-03 | Unknown | Virgin Islands | 0 | 6 | |
296218 | 296218 | 2020-07-02 | Unknown | Virgin Islands | 0 | 6 | |
293063 | 293063 | 2020-07-01 | Unknown | Virgin Islands | 0 | 6 | |
289910 | 289910 | 2020-06-30 | Unknown | Virgin Islands | 0 | 6 | |
286760 | 286760 | 2020-06-29 | Unknown | Virgin Islands | 0 | 6 | |
283614 | 283614 | 2020-06-28 | Unknown | Virgin Islands | 0 | 6 | |
280468 | 280468 | 2020-06-27 | Unknown | Virgin Islands | 0 | 6 | |
277320 | 277320 | 2020-06-26 | Unknown | Virgin Islands | 0 | 6 | |
274172 | 274172 | 2020-06-25 | Unknown | Virgin Islands | 0 | 6 | |
271032 | 271032 | 2020-06-24 | Unknown | Virgin Islands | 0 | 6 | |
267898 | 267898 | 2020-06-23 | Unknown | Virgin Islands | 0 | 6 | |
264769 | 264769 | 2020-06-22 | Unknown | Virgin Islands | 0 | 6 | |
261640 | 261640 | 2020-06-21 | Unknown | Virgin Islands | 0 | 6 | |
258513 | 258513 | 2020-06-20 | Unknown | Virgin Islands | 0 | 6 | |
255386 | 255386 | 2020-06-19 | Unknown | Virgin Islands | 0 | 6 | |
252268 | 252268 | 2020-06-18 | Unknown | Virgin Islands | 0 | 6 | |
249153 | 249153 | 2020-06-17 | Unknown | Virgin Islands | 0 | 6 | |
246041 | 246041 | 2020-06-16 | Unknown | Virgin Islands | 0 | 6 | |
242929 | 242929 | 2020-06-15 | Unknown | Virgin Islands | 0 | 6 | |
239818 | 239818 | 2020-06-14 | Unknown | Virgin Islands | 0 | 6 | |
236710 | 236710 | 2020-06-13 | Unknown | Virgin Islands | 0 | 6 | |
233603 | 233603 | 2020-06-12 | Unknown | Virgin Islands | 0 | 6 | |
230498 | 230498 | 2020-06-11 | Unknown | Virgin Islands | 0 | 6 | |
227394 | 227394 | 2020-06-10 | Unknown | Virgin Islands | 0 | 6 | |
224294 | 224294 | 2020-06-09 | Unknown | Virgin Islands | 0 | 6 | |
221198 | 221198 | 2020-06-08 | Unknown | Virgin Islands | 0 | 6 | |
218106 | 218106 | 2020-06-07 | Unknown | Virgin Islands | 0 | 6 | |
215016 | 215016 | 2020-06-06 | Unknown | Virgin Islands | 0 | 6 | |
211929 | 211929 | 2020-06-05 | Unknown | Virgin Islands | 0 | 6 | |
208844 | 208844 | 2020-06-04 | Unknown | Virgin Islands | 0 | 6 | |
205762 | 205762 | 2020-06-03 | Unknown | Virgin Islands | 0 | 6 | |
202683 | 202683 | 2020-06-02 | Unknown | Virgin Islands | 0 | 6 | |
199607 | 199607 | 2020-06-01 | Unknown | Virgin Islands | 0 | 6 | |
196534 | 196534 | 2020-05-31 | Unknown | Virgin Islands | 0 | 6 | |
193464 | 193464 | 2020-05-30 | Unknown | Virgin Islands | 0 | 6 | |
190398 | 190398 | 2020-05-29 | Unknown | Virgin Islands | 0 | 6 | |
187334 | 187334 | 2020-05-28 | Unknown | Virgin Islands | 0 | 6 | |
184277 | 184277 | 2020-05-27 | Unknown | Virgin Islands | 0 | 6 | |
181226 | 181226 | 2020-05-26 | Unknown | Virgin Islands | 0 | 6 | |
178182 | 178182 | 2020-05-25 | Unknown | Virgin Islands | 0 | 6 | |
175137 | 175137 | 2020-05-24 | Unknown | Virgin Islands | 0 | 6 | |
172094 | 172094 | 2020-05-23 | Unknown | Virgin Islands | 0 | 6 | |
169053 | 169053 | 2020-05-22 | Unknown | Virgin Islands | 0 | 6 | |
166017 | 166017 | 2020-05-21 | Unknown | Virgin Islands | 0 | 6 | |
162988 | 162988 | 2020-05-20 | Unknown | Virgin Islands | 0 | 6 | |
159960 | 159960 | 2020-05-19 | Unknown | Virgin Islands | 0 | 6 | |
156936 | 156936 | 2020-05-18 | Unknown | Virgin Islands | 0 | 6 | |
153919 | 153919 | 2020-05-17 | Unknown | Virgin Islands | 0 | 6 | |
150908 | 150908 | 2020-05-16 | Unknown | Virgin Islands | 0 | 6 | |
147899 | 147899 | 2020-05-15 | Unknown | Virgin Islands | 0 | 6 | |
144896 | 144896 | 2020-05-14 | Unknown | Virgin Islands | 0 | 6 | |
141899 | 141899 | 2020-05-13 | Unknown | Virgin Islands | 0 | 6 | |
138903 | 138903 | 2020-05-12 | Unknown | Virgin Islands | 0 | 6 | |
135912 | 135912 | 2020-05-11 | Unknown | Virgin Islands | 0 | 5 | |
132922 | 132922 | 2020-05-10 | Unknown | Virgin Islands | 0 | 4 | |
129932 | 129932 | 2020-05-09 | Unknown | Virgin Islands | 0 | 4 | |
126943 | 126943 | 2020-05-08 | Unknown | Virgin Islands | 0 | 4 | |
123958 | 123958 | 2020-05-07 | Unknown | Virgin Islands | 0 | 4 | |
120977 | 120977 | 2020-05-06 | Unknown | Virgin Islands | 0 | 4 | |
118013 | 118013 | 2020-05-05 | Unknown | Virgin Islands | 0 | 4 | |
115054 | 115054 | 2020-05-04 | Unknown | Virgin Islands | 0 | 4 | |
112171 | 112171 | 2020-05-03 | Unknown | Virgin Islands | 0 | 4 | |
109297 | 109297 | 2020-05-02 | Unknown | Virgin Islands | 0 | 4 | |
106428 | 106428 | 2020-05-01 | Unknown | Virgin Islands | 0 | 4 | |
103564 | 103564 | 2020-04-30 | Unknown | Virgin Islands | 0 | 4 | |
100709 | 100709 | 2020-04-29 | Unknown | Virgin Islands | 0 | 4 | |
97859 | 97859 | 2020-04-28 | Unknown | Virgin Islands | 0 | 4 | |
95017 | 95017 | 2020-04-27 | Unknown | Virgin Islands | 0 | 4 | |
92188 | 92188 | 2020-04-26 | Unknown | Virgin Islands | 0 | 4 | |
89371 | 89371 | 2020-04-25 | Unknown | Virgin Islands | 0 | 3 | |
86556 | 86556 | 2020-04-24 | Unknown | Virgin Islands | 0 | 3 | |
83749 | 83749 | 2020-04-23 | Unknown | Virgin Islands | 0 | 3 | |
80948 | 80948 | 2020-04-22 | Unknown | Virgin Islands | 0 | 3 | |
78156 | 78156 | 2020-04-21 | Unknown | Virgin Islands | 0 | 3 | |
75374 | 75374 | 2020-04-20 | Unknown | Virgin Islands | 0 | 3 | |
72598 | 72598 | 2020-04-19 | Unknown | Virgin Islands | 0 | 3 | |
69828 | 69828 | 2020-04-18 | Unknown | Virgin Islands | 0 | 3 | |
67066 | 67066 | 2020-04-17 | Unknown | Virgin Islands | 0 | 2 |
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);