ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where fips = 78020 and state = "Virgin Islands" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
37820 | 37820 | 2020-04-06 | St. John | Virgin Islands | 78020 | 2 | 0 |
40350 | 40350 | 2020-04-07 | St. John | Virgin Islands | 78020 | 2 | 0 |
42919 | 42919 | 2020-04-08 | St. John | Virgin Islands | 78020 | 2 | 0 |
45513 | 45513 | 2020-04-09 | St. John | Virgin Islands | 78020 | 2 | 0 |
48137 | 48137 | 2020-04-10 | St. John | Virgin Islands | 78020 | 2 | 0 |
50795 | 50795 | 2020-04-11 | St. John | Virgin Islands | 78020 | 2 | 0 |
53470 | 53470 | 2020-04-12 | St. John | Virgin Islands | 78020 | 2 | 0 |
56159 | 56159 | 2020-04-13 | St. John | Virgin Islands | 78020 | 2 | 0 |
58865 | 58865 | 2020-04-14 | St. John | Virgin Islands | 78020 | 2 | 0 |
61584 | 61584 | 2020-04-15 | St. John | Virgin Islands | 78020 | 2 | 0 |
64316 | 64316 | 2020-04-16 | St. John | Virgin Islands | 78020 | 2 | 0 |
67064 | 67064 | 2020-04-17 | St. John | Virgin Islands | 78020 | 2 | 0 |
69826 | 69826 | 2020-04-18 | St. John | Virgin Islands | 78020 | 2 | 0 |
72596 | 72596 | 2020-04-19 | St. John | Virgin Islands | 78020 | 2 | 0 |
75372 | 75372 | 2020-04-20 | St. John | Virgin Islands | 78020 | 2 | 0 |
78154 | 78154 | 2020-04-21 | St. John | Virgin Islands | 78020 | 2 | 0 |
80946 | 80946 | 2020-04-22 | St. John | Virgin Islands | 78020 | 2 | 0 |
83747 | 83747 | 2020-04-23 | St. John | Virgin Islands | 78020 | 2 | 0 |
86554 | 86554 | 2020-04-24 | St. John | Virgin Islands | 78020 | 2 | 0 |
89369 | 89369 | 2020-04-25 | St. John | Virgin Islands | 78020 | 2 | 0 |
92186 | 92186 | 2020-04-26 | St. John | Virgin Islands | 78020 | 2 | 0 |
95015 | 95015 | 2020-04-27 | St. John | Virgin Islands | 78020 | 2 | 0 |
97857 | 97857 | 2020-04-28 | St. John | Virgin Islands | 78020 | 2 | 0 |
100707 | 100707 | 2020-04-29 | St. John | Virgin Islands | 78020 | 2 | 0 |
103562 | 103562 | 2020-04-30 | St. John | Virgin Islands | 78020 | 2 | 0 |
106426 | 106426 | 2020-05-01 | St. John | Virgin Islands | 78020 | 2 | 0 |
109295 | 109295 | 2020-05-02 | St. John | Virgin Islands | 78020 | 2 | 0 |
112169 | 112169 | 2020-05-03 | St. John | Virgin Islands | 78020 | 2 | 0 |
115052 | 115052 | 2020-05-04 | St. John | Virgin Islands | 78020 | 2 | 0 |
118011 | 118011 | 2020-05-05 | St. John | Virgin Islands | 78020 | 2 | 0 |
120975 | 120975 | 2020-05-06 | St. John | Virgin Islands | 78020 | 2 | 0 |
123956 | 123956 | 2020-05-07 | St. John | Virgin Islands | 78020 | 2 | 0 |
126941 | 126941 | 2020-05-08 | St. John | Virgin Islands | 78020 | 2 | 0 |
129930 | 129930 | 2020-05-09 | St. John | Virgin Islands | 78020 | 2 | 0 |
132920 | 132920 | 2020-05-10 | St. John | Virgin Islands | 78020 | 2 | 0 |
135910 | 135910 | 2020-05-11 | St. John | Virgin Islands | 78020 | 2 | 0 |
138901 | 138901 | 2020-05-12 | St. John | Virgin Islands | 78020 | 2 | 0 |
141897 | 141897 | 2020-05-13 | St. John | Virgin Islands | 78020 | 2 | 0 |
144894 | 144894 | 2020-05-14 | St. John | Virgin Islands | 78020 | 2 | 0 |
147897 | 147897 | 2020-05-15 | St. John | Virgin Islands | 78020 | 2 | 0 |
150906 | 150906 | 2020-05-16 | St. John | Virgin Islands | 78020 | 2 | 0 |
153917 | 153917 | 2020-05-17 | St. John | Virgin Islands | 78020 | 2 | 0 |
156934 | 156934 | 2020-05-18 | St. John | Virgin Islands | 78020 | 2 | 0 |
159958 | 159958 | 2020-05-19 | St. John | Virgin Islands | 78020 | 2 | 0 |
162986 | 162986 | 2020-05-20 | St. John | Virgin Islands | 78020 | 2 | 0 |
166015 | 166015 | 2020-05-21 | St. John | Virgin Islands | 78020 | 2 | 0 |
169051 | 169051 | 2020-05-22 | St. John | Virgin Islands | 78020 | 2 | 0 |
172092 | 172092 | 2020-05-23 | St. John | Virgin Islands | 78020 | 2 | 0 |
175135 | 175135 | 2020-05-24 | St. John | Virgin Islands | 78020 | 2 | 0 |
178180 | 178180 | 2020-05-25 | St. John | Virgin Islands | 78020 | 2 | 0 |
181224 | 181224 | 2020-05-26 | St. John | Virgin Islands | 78020 | 2 | 0 |
184275 | 184275 | 2020-05-27 | St. John | Virgin Islands | 78020 | 2 | 0 |
187332 | 187332 | 2020-05-28 | St. John | Virgin Islands | 78020 | 2 | 0 |
190396 | 190396 | 2020-05-29 | St. John | Virgin Islands | 78020 | 2 | 0 |
193462 | 193462 | 2020-05-30 | St. John | Virgin Islands | 78020 | 2 | 0 |
196532 | 196532 | 2020-05-31 | St. John | Virgin Islands | 78020 | 2 | 0 |
199605 | 199605 | 2020-06-01 | St. John | Virgin Islands | 78020 | 2 | 0 |
202681 | 202681 | 2020-06-02 | St. John | Virgin Islands | 78020 | 2 | 0 |
205760 | 205760 | 2020-06-03 | St. John | Virgin Islands | 78020 | 2 | 0 |
208842 | 208842 | 2020-06-04 | St. John | Virgin Islands | 78020 | 2 | 0 |
211927 | 211927 | 2020-06-05 | St. John | Virgin Islands | 78020 | 2 | 0 |
215014 | 215014 | 2020-06-06 | St. John | Virgin Islands | 78020 | 2 | 0 |
218104 | 218104 | 2020-06-07 | St. John | Virgin Islands | 78020 | 2 | 0 |
221196 | 221196 | 2020-06-08 | St. John | Virgin Islands | 78020 | 2 | 0 |
224292 | 224292 | 2020-06-09 | St. John | Virgin Islands | 78020 | 2 | 0 |
227392 | 227392 | 2020-06-10 | St. John | Virgin Islands | 78020 | 2 | 0 |
230496 | 230496 | 2020-06-11 | St. John | Virgin Islands | 78020 | 2 | 0 |
233601 | 233601 | 2020-06-12 | St. John | Virgin Islands | 78020 | 2 | 0 |
236708 | 236708 | 2020-06-13 | St. John | Virgin Islands | 78020 | 2 | 0 |
239816 | 239816 | 2020-06-14 | St. John | Virgin Islands | 78020 | 3 | 0 |
242927 | 242927 | 2020-06-15 | St. John | Virgin Islands | 78020 | 3 | 0 |
246039 | 246039 | 2020-06-16 | St. John | Virgin Islands | 78020 | 3 | 0 |
249151 | 249151 | 2020-06-17 | St. John | Virgin Islands | 78020 | 3 | 0 |
252266 | 252266 | 2020-06-18 | St. John | Virgin Islands | 78020 | 4 | 0 |
255384 | 255384 | 2020-06-19 | St. John | Virgin Islands | 78020 | 4 | 0 |
258511 | 258511 | 2020-06-20 | St. John | Virgin Islands | 78020 | 4 | 0 |
261638 | 261638 | 2020-06-21 | St. John | Virgin Islands | 78020 | 4 | 0 |
264767 | 264767 | 2020-06-22 | St. John | Virgin Islands | 78020 | 4 | 0 |
267896 | 267896 | 2020-06-23 | St. John | Virgin Islands | 78020 | 4 | 0 |
271030 | 271030 | 2020-06-24 | St. John | Virgin Islands | 78020 | 4 | 0 |
274170 | 274170 | 2020-06-25 | St. John | Virgin Islands | 78020 | 4 | 0 |
277318 | 277318 | 2020-06-26 | St. John | Virgin Islands | 78020 | 4 | 0 |
280466 | 280466 | 2020-06-27 | St. John | Virgin Islands | 78020 | 4 | 0 |
283612 | 283612 | 2020-06-28 | St. John | Virgin Islands | 78020 | 4 | 0 |
286758 | 286758 | 2020-06-29 | St. John | Virgin Islands | 78020 | 4 | 0 |
289908 | 289908 | 2020-06-30 | St. John | Virgin Islands | 78020 | 4 | 0 |
293061 | 293061 | 2020-07-01 | St. John | Virgin Islands | 78020 | 4 | 0 |
296216 | 296216 | 2020-07-02 | St. John | Virgin Islands | 78020 | 4 | 0 |
299378 | 299378 | 2020-07-03 | St. John | Virgin Islands | 78020 | 4 | 0 |
302542 | 302542 | 2020-07-04 | St. John | Virgin Islands | 78020 | 4 | 0 |
305706 | 305706 | 2020-07-05 | St. John | Virgin Islands | 78020 | 4 | 0 |
308874 | 308874 | 2020-07-06 | St. John | Virgin Islands | 78020 | 4 | 0 |
312043 | 312043 | 2020-07-07 | St. John | Virgin Islands | 78020 | 4 | 0 |
315217 | 315217 | 2020-07-08 | St. John | Virgin Islands | 78020 | 6 | 0 |
318390 | 318390 | 2020-07-09 | St. John | Virgin Islands | 78020 | 6 | 0 |
321569 | 321569 | 2020-07-10 | St. John | Virgin Islands | 78020 | 6 | 0 |
324750 | 324750 | 2020-07-11 | St. John | Virgin Islands | 78020 | 6 | 0 |
327935 | 327935 | 2020-07-12 | St. John | Virgin Islands | 78020 | 6 | 0 |
331121 | 331121 | 2020-07-13 | St. John | Virgin Islands | 78020 | 7 | 0 |
334314 | 334314 | 2020-07-14 | St. John | Virgin Islands | 78020 | 9 | 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);