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
- Unknown 131
- St. Croix 117
- St. John 117
- St. Thomas 117
state 1
- Virgin Islands · 482 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388830 | 388830 | 2020-07-31 | St. Croix | Virgin Islands | 78010 | 256 | 4 |
388831 | 388831 | 2020-07-31 | St. John | Virgin Islands | 78020 | 16 | 0 |
388832 | 388832 | 2020-07-31 | St. Thomas | Virgin Islands | 78030 | 134 | 4 |
385613 | 385613 | 2020-07-30 | St. Croix | Virgin Islands | 78010 | 246 | 4 |
385614 | 385614 | 2020-07-30 | St. John | Virgin Islands | 78020 | 16 | 0 |
385615 | 385615 | 2020-07-30 | St. Thomas | Virgin Islands | 78030 | 123 | 4 |
382395 | 382395 | 2020-07-29 | St. Croix | Virgin Islands | 78010 | 246 | 4 |
382396 | 382396 | 2020-07-29 | St. John | Virgin Islands | 78020 | 16 | 0 |
382397 | 382397 | 2020-07-29 | St. Thomas | Virgin Islands | 78030 | 123 | 4 |
379178 | 379178 | 2020-07-28 | St. Croix | Virgin Islands | 78010 | 238 | 4 |
379179 | 379179 | 2020-07-28 | St. John | Virgin Islands | 78020 | 16 | 0 |
379180 | 379180 | 2020-07-28 | St. Thomas | Virgin Islands | 78030 | 121 | 3 |
375962 | 375962 | 2020-07-27 | St. Croix | Virgin Islands | 78010 | 238 | 4 |
375963 | 375963 | 2020-07-27 | St. John | Virgin Islands | 78020 | 16 | 0 |
375964 | 375964 | 2020-07-27 | St. Thomas | Virgin Islands | 78030 | 121 | 3 |
372748 | 372748 | 2020-07-26 | St. Croix | Virgin Islands | 78010 | 230 | 4 |
372749 | 372749 | 2020-07-26 | St. John | Virgin Islands | 78020 | 15 | 0 |
372750 | 372750 | 2020-07-26 | St. Thomas | Virgin Islands | 78030 | 116 | 3 |
369536 | 369536 | 2020-07-25 | St. Croix | Virgin Islands | 78010 | 223 | 4 |
369537 | 369537 | 2020-07-25 | St. John | Virgin Islands | 78020 | 15 | 0 |
369538 | 369538 | 2020-07-25 | St. Thomas | Virgin Islands | 78030 | 114 | 3 |
366327 | 366327 | 2020-07-24 | St. Croix | Virgin Islands | 78010 | 223 | 4 |
366328 | 366328 | 2020-07-24 | St. John | Virgin Islands | 78020 | 15 | 0 |
366329 | 366329 | 2020-07-24 | St. Thomas | Virgin Islands | 78030 | 114 | 3 |
363121 | 363121 | 2020-07-23 | St. Croix | Virgin Islands | 78010 | 216 | 4 |
363122 | 363122 | 2020-07-23 | St. John | Virgin Islands | 78020 | 15 | 0 |
363123 | 363123 | 2020-07-23 | St. Thomas | Virgin Islands | 78030 | 111 | 3 |
359914 | 359914 | 2020-07-22 | St. Croix | Virgin Islands | 78010 | 215 | 0 |
359915 | 359915 | 2020-07-22 | St. John | Virgin Islands | 78020 | 15 | 0 |
359916 | 359916 | 2020-07-22 | St. Thomas | Virgin Islands | 78030 | 106 | 0 |
359917 | 359917 | 2020-07-22 | Unknown | Virgin Islands | 0 | 7 | |
356709 | 356709 | 2020-07-21 | St. Croix | Virgin Islands | 78010 | 199 | 0 |
356710 | 356710 | 2020-07-21 | St. John | Virgin Islands | 78020 | 12 | 0 |
356711 | 356711 | 2020-07-21 | St. Thomas | Virgin Islands | 78030 | 97 | 0 |
356712 | 356712 | 2020-07-21 | Unknown | Virgin Islands | 0 | 6 | |
353506 | 353506 | 2020-07-20 | St. Croix | Virgin Islands | 78010 | 199 | 0 |
353507 | 353507 | 2020-07-20 | St. John | Virgin Islands | 78020 | 12 | 0 |
353508 | 353508 | 2020-07-20 | St. Thomas | Virgin Islands | 78030 | 97 | 0 |
353509 | 353509 | 2020-07-20 | Unknown | Virgin Islands | 0 | 6 | |
350304 | 350304 | 2020-07-19 | St. Croix | Virgin Islands | 78010 | 195 | 0 |
350305 | 350305 | 2020-07-19 | St. John | Virgin Islands | 78020 | 12 | 0 |
350306 | 350306 | 2020-07-19 | St. Thomas | Virgin Islands | 78030 | 90 | 0 |
350307 | 350307 | 2020-07-19 | Unknown | Virgin Islands | 0 | 6 | |
347103 | 347103 | 2020-07-18 | St. Croix | Virgin Islands | 78010 | 195 | 0 |
347104 | 347104 | 2020-07-18 | St. John | Virgin Islands | 78020 | 12 | 0 |
347105 | 347105 | 2020-07-18 | St. Thomas | Virgin Islands | 78030 | 90 | 0 |
347106 | 347106 | 2020-07-18 | Unknown | Virgin Islands | 0 | 6 | |
343903 | 343903 | 2020-07-17 | St. Croix | Virgin Islands | 78010 | 183 | 0 |
343904 | 343904 | 2020-07-17 | St. John | Virgin Islands | 78020 | 11 | 0 |
343905 | 343905 | 2020-07-17 | St. Thomas | Virgin Islands | 78030 | 89 | 0 |
343906 | 343906 | 2020-07-17 | Unknown | Virgin Islands | 0 | 6 | |
340704 | 340704 | 2020-07-16 | St. Croix | Virgin Islands | 78010 | 169 | 0 |
340705 | 340705 | 2020-07-16 | St. John | Virgin Islands | 78020 | 10 | 0 |
340706 | 340706 | 2020-07-16 | St. Thomas | Virgin Islands | 78030 | 84 | 0 |
340707 | 340707 | 2020-07-16 | Unknown | Virgin Islands | 0 | 6 | |
337508 | 337508 | 2020-07-15 | St. Croix | Virgin Islands | 78010 | 166 | 0 |
337509 | 337509 | 2020-07-15 | St. John | Virgin Islands | 78020 | 9 | 0 |
337510 | 337510 | 2020-07-15 | St. Thomas | Virgin Islands | 78030 | 74 | 0 |
337511 | 337511 | 2020-07-15 | Unknown | Virgin Islands | 0 | 6 | |
334313 | 334313 | 2020-07-14 | St. Croix | Virgin Islands | 78010 | 164 | 0 |
334314 | 334314 | 2020-07-14 | St. John | Virgin Islands | 78020 | 9 | 0 |
334315 | 334315 | 2020-07-14 | St. Thomas | Virgin Islands | 78030 | 70 | 0 |
334316 | 334316 | 2020-07-14 | Unknown | Virgin Islands | 0 | 6 | |
331120 | 331120 | 2020-07-13 | St. Croix | Virgin Islands | 78010 | 148 | 0 |
331121 | 331121 | 2020-07-13 | St. John | Virgin Islands | 78020 | 7 | 0 |
331122 | 331122 | 2020-07-13 | St. Thomas | Virgin Islands | 78030 | 62 | 0 |
331123 | 331123 | 2020-07-13 | Unknown | Virgin Islands | 0 | 6 | |
327934 | 327934 | 2020-07-12 | St. Croix | Virgin Islands | 78010 | 138 | 0 |
327935 | 327935 | 2020-07-12 | St. John | Virgin Islands | 78020 | 6 | 0 |
327936 | 327936 | 2020-07-12 | St. Thomas | Virgin Islands | 78030 | 62 | 0 |
327937 | 327937 | 2020-07-12 | Unknown | Virgin Islands | 0 | 6 | |
324749 | 324749 | 2020-07-11 | St. Croix | Virgin Islands | 78010 | 114 | 0 |
324750 | 324750 | 2020-07-11 | St. John | Virgin Islands | 78020 | 6 | 0 |
324751 | 324751 | 2020-07-11 | St. Thomas | Virgin Islands | 78030 | 61 | 0 |
324752 | 324752 | 2020-07-11 | Unknown | Virgin Islands | 0 | 6 | |
321568 | 321568 | 2020-07-10 | St. Croix | Virgin Islands | 78010 | 102 | 0 |
321569 | 321569 | 2020-07-10 | St. John | Virgin Islands | 78020 | 6 | 0 |
321570 | 321570 | 2020-07-10 | St. Thomas | Virgin Islands | 78030 | 59 | 0 |
321571 | 321571 | 2020-07-10 | Unknown | Virgin Islands | 0 | 6 | |
318389 | 318389 | 2020-07-09 | St. Croix | Virgin Islands | 78010 | 91 | 0 |
318390 | 318390 | 2020-07-09 | St. John | Virgin Islands | 78020 | 6 | 0 |
318391 | 318391 | 2020-07-09 | St. Thomas | Virgin Islands | 78030 | 56 | 0 |
318392 | 318392 | 2020-07-09 | Unknown | Virgin Islands | 0 | 6 | |
315216 | 315216 | 2020-07-08 | St. Croix | Virgin Islands | 78010 | 84 | 0 |
315217 | 315217 | 2020-07-08 | St. John | Virgin Islands | 78020 | 6 | 0 |
315218 | 315218 | 2020-07-08 | St. Thomas | Virgin Islands | 78030 | 54 | 0 |
315219 | 315219 | 2020-07-08 | Unknown | Virgin Islands | 0 | 6 | |
312042 | 312042 | 2020-07-07 | St. Croix | Virgin Islands | 78010 | 71 | 0 |
312043 | 312043 | 2020-07-07 | St. John | Virgin Islands | 78020 | 4 | 0 |
312044 | 312044 | 2020-07-07 | St. Thomas | Virgin Islands | 78030 | 47 | 0 |
312045 | 312045 | 2020-07-07 | Unknown | Virgin Islands | 0 | 6 | |
308873 | 308873 | 2020-07-06 | St. Croix | Virgin Islands | 78010 | 65 | 0 |
308874 | 308874 | 2020-07-06 | St. John | Virgin Islands | 78020 | 4 | 0 |
308875 | 308875 | 2020-07-06 | St. Thomas | Virgin Islands | 78030 | 47 | 0 |
308876 | 308876 | 2020-07-06 | Unknown | Virgin Islands | 0 | 6 | |
305705 | 305705 | 2020-07-05 | St. Croix | Virgin Islands | 78010 | 63 | 0 |
305706 | 305706 | 2020-07-05 | St. John | Virgin Islands | 78020 | 4 | 0 |
305707 | 305707 | 2020-07-05 | St. Thomas | Virgin Islands | 78030 | 45 | 0 |
305708 | 305708 | 2020-07-05 | Unknown | Virgin Islands | 0 | 6 | |
302541 | 302541 | 2020-07-04 | St. Croix | Virgin Islands | 78010 | 63 | 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);