ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Vega Alta" and state = "Puerto Rico" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
117558 | 117558 | 2020-05-05 | Vega Alta | Puerto Rico | 72143 | 27 | |
120520 | 120520 | 2020-05-06 | Vega Alta | Puerto Rico | 72143 | 27 | |
123497 | 123497 | 2020-05-07 | Vega Alta | Puerto Rico | 72143 | 28 | |
126480 | 126480 | 2020-05-08 | Vega Alta | Puerto Rico | 72143 | 28 | |
129469 | 129469 | 2020-05-09 | Vega Alta | Puerto Rico | 72143 | 28 | |
132458 | 132458 | 2020-05-10 | Vega Alta | Puerto Rico | 72143 | 28 | |
135449 | 135449 | 2020-05-11 | Vega Alta | Puerto Rico | 72143 | 29 | |
138439 | 138439 | 2020-05-12 | Vega Alta | Puerto Rico | 72143 | 30 | |
141435 | 141435 | 2020-05-13 | Vega Alta | Puerto Rico | 72143 | 30 | |
144431 | 144431 | 2020-05-14 | Vega Alta | Puerto Rico | 72143 | 31 | |
147432 | 147432 | 2020-05-15 | Vega Alta | Puerto Rico | 72143 | 32 | |
150440 | 150440 | 2020-05-16 | Vega Alta | Puerto Rico | 72143 | 34 | |
153451 | 153451 | 2020-05-17 | Vega Alta | Puerto Rico | 72143 | 35 | |
156468 | 156468 | 2020-05-18 | Vega Alta | Puerto Rico | 72143 | 35 | |
159489 | 159489 | 2020-05-19 | Vega Alta | Puerto Rico | 72143 | 35 | |
162516 | 162516 | 2020-05-20 | Vega Alta | Puerto Rico | 72143 | 36 | |
165545 | 165545 | 2020-05-21 | Vega Alta | Puerto Rico | 72143 | 36 | |
168581 | 168581 | 2020-05-22 | Vega Alta | Puerto Rico | 72143 | 37 | |
171620 | 171620 | 2020-05-23 | Vega Alta | Puerto Rico | 72143 | 38 | |
174662 | 174662 | 2020-05-24 | Vega Alta | Puerto Rico | 72143 | 38 | |
177706 | 177706 | 2020-05-25 | Vega Alta | Puerto Rico | 72143 | 38 | |
180749 | 180749 | 2020-05-26 | Vega Alta | Puerto Rico | 72143 | 39 | |
183799 | 183799 | 2020-05-27 | Vega Alta | Puerto Rico | 72143 | 39 | |
186856 | 186856 | 2020-05-28 | Vega Alta | Puerto Rico | 72143 | 39 | |
189918 | 189918 | 2020-05-29 | Vega Alta | Puerto Rico | 72143 | 39 | |
192983 | 192983 | 2020-05-30 | Vega Alta | Puerto Rico | 72143 | 39 | |
196052 | 196052 | 2020-05-31 | Vega Alta | Puerto Rico | 72143 | 39 | |
199125 | 199125 | 2020-06-01 | Vega Alta | Puerto Rico | 72143 | 40 | |
202200 | 202200 | 2020-06-02 | Vega Alta | Puerto Rico | 72143 | 40 | |
205277 | 205277 | 2020-06-03 | Vega Alta | Puerto Rico | 72143 | 41 | |
208358 | 208358 | 2020-06-04 | Vega Alta | Puerto Rico | 72143 | 48 | |
211440 | 211440 | 2020-06-05 | Vega Alta | Puerto Rico | 72143 | 48 | |
214526 | 214526 | 2020-06-06 | Vega Alta | Puerto Rico | 72143 | 50 | |
217616 | 217616 | 2020-06-07 | Vega Alta | Puerto Rico | 72143 | 50 | |
220708 | 220708 | 2020-06-08 | Vega Alta | Puerto Rico | 72143 | 50 | |
223803 | 223803 | 2020-06-09 | Vega Alta | Puerto Rico | 72143 | 53 | |
226903 | 226903 | 2020-06-10 | Vega Alta | Puerto Rico | 72143 | 54 | |
230007 | 230007 | 2020-06-11 | Vega Alta | Puerto Rico | 72143 | 54 | |
233112 | 233112 | 2020-06-12 | Vega Alta | Puerto Rico | 72143 | 54 | |
236217 | 236217 | 2020-06-13 | Vega Alta | Puerto Rico | 72143 | 54 | |
239325 | 239325 | 2020-06-14 | Vega Alta | Puerto Rico | 72143 | 55 | |
242434 | 242434 | 2020-06-15 | Vega Alta | Puerto Rico | 72143 | 56 | |
245546 | 245546 | 2020-06-16 | Vega Alta | Puerto Rico | 72143 | 60 | |
248659 | 248659 | 2020-06-17 | Vega Alta | Puerto Rico | 72143 | 60 | |
251774 | 251774 | 2020-06-18 | Vega Alta | Puerto Rico | 72143 | 63 | |
254889 | 254889 | 2020-06-19 | Vega Alta | Puerto Rico | 72143 | 65 | |
258015 | 258015 | 2020-06-20 | Vega Alta | Puerto Rico | 72143 | 69 | |
261142 | 261142 | 2020-06-21 | Vega Alta | Puerto Rico | 72143 | 69 | |
264270 | 264270 | 2020-06-22 | Vega Alta | Puerto Rico | 72143 | 69 | |
267398 | 267398 | 2020-06-23 | Vega Alta | Puerto Rico | 72143 | 72 | |
270532 | 270532 | 2020-06-24 | Vega Alta | Puerto Rico | 72143 | 73 | |
273671 | 273671 | 2020-06-25 | Vega Alta | Puerto Rico | 72143 | 77 | |
298875 | 298875 | 2020-07-03 | Vega Alta | Puerto Rico | 72143 | 77 | |
302039 | 302039 | 2020-07-04 | Vega Alta | Puerto Rico | 72143 | 77 | |
305202 | 305202 | 2020-07-05 | Vega Alta | Puerto Rico | 72143 | 77 | |
286257 | 286257 | 2020-06-29 | Vega Alta | Puerto Rico | 72143 | 78 | |
289408 | 289408 | 2020-06-30 | Vega Alta | Puerto Rico | 72143 | 78 | |
292560 | 292560 | 2020-07-01 | Vega Alta | Puerto Rico | 72143 | 78 | |
295716 | 295716 | 2020-07-02 | Vega Alta | Puerto Rico | 72143 | 79 | |
308369 | 308369 | 2020-07-06 | Vega Alta | Puerto Rico | 72143 | 81 | |
311538 | 311538 | 2020-07-07 | Vega Alta | Puerto Rico | 72143 | 82 | |
314710 | 314710 | 2020-07-08 | Vega Alta | Puerto Rico | 72143 | 82 | |
279966 | 279966 | 2020-06-27 | Vega Alta | Puerto Rico | 72143 | 83 | |
276818 | 276818 | 2020-06-26 | Vega Alta | Puerto Rico | 72143 | 84 | |
283112 | 283112 | 2020-06-28 | Vega Alta | Puerto Rico | 72143 | 84 | |
317883 | 317883 | 2020-07-09 | Vega Alta | Puerto Rico | 72143 | 88 | |
321061 | 321061 | 2020-07-10 | Vega Alta | Puerto Rico | 72143 | 89 | |
324241 | 324241 | 2020-07-11 | Vega Alta | Puerto Rico | 72143 | 92 | |
327426 | 327426 | 2020-07-12 | Vega Alta | Puerto Rico | 72143 | 95 | |
330612 | 330612 | 2020-07-13 | Vega Alta | Puerto Rico | 72143 | 99 | |
333804 | 333804 | 2020-07-14 | Vega Alta | Puerto Rico | 72143 | 102 | |
336998 | 336998 | 2020-07-15 | Vega Alta | Puerto Rico | 72143 | 104 | |
340195 | 340195 | 2020-07-16 | Vega Alta | Puerto Rico | 72143 | 108 | |
343393 | 343393 | 2020-07-17 | Vega Alta | Puerto Rico | 72143 | 109 | |
346593 | 346593 | 2020-07-18 | Vega Alta | Puerto Rico | 72143 | 115 | |
349793 | 349793 | 2020-07-19 | Vega Alta | Puerto Rico | 72143 | 117 | |
352996 | 352996 | 2020-07-20 | Vega Alta | Puerto Rico | 72143 | 124 | |
356199 | 356199 | 2020-07-21 | Vega Alta | Puerto Rico | 72143 | 129 | |
359403 | 359403 | 2020-07-22 | Vega Alta | Puerto Rico | 72143 | 129 | |
362609 | 362609 | 2020-07-23 | Vega Alta | Puerto Rico | 72143 | 130 | |
365815 | 365815 | 2020-07-24 | Vega Alta | Puerto Rico | 72143 | 136 | |
369024 | 369024 | 2020-07-25 | Vega Alta | Puerto Rico | 72143 | 145 | |
372236 | 372236 | 2020-07-26 | Vega Alta | Puerto Rico | 72143 | 149 | |
375449 | 375449 | 2020-07-27 | Vega Alta | Puerto Rico | 72143 | 155 | |
378665 | 378665 | 2020-07-28 | Vega Alta | Puerto Rico | 72143 | 157 | |
381882 | 381882 | 2020-07-29 | Vega Alta | Puerto Rico | 72143 | 163 | |
385100 | 385100 | 2020-07-30 | Vega Alta | Puerto Rico | 72143 | 165 | |
388317 | 388317 | 2020-07-31 | Vega Alta | Puerto Rico | 72143 | 167 | |
391534 | 391534 | 2020-08-01 | Vega Alta | Puerto Rico | 72143 | 176 | |
394750 | 394750 | 2020-08-02 | Vega Alta | Puerto Rico | 72143 | 181 | |
397967 | 397967 | 2020-08-03 | Vega Alta | Puerto Rico | 72143 | 186 | |
401182 | 401182 | 2020-08-04 | Vega Alta | Puerto Rico | 72143 | 186 | |
404400 | 404400 | 2020-08-05 | Vega Alta | Puerto Rico | 72143 | 195 | |
407619 | 407619 | 2020-08-06 | Vega Alta | Puerto Rico | 72143 | 198 | |
410839 | 410839 | 2020-08-07 | Vega Alta | Puerto Rico | 72143 | 212 | |
414059 | 414059 | 2020-08-08 | Vega Alta | Puerto Rico | 72143 | 224 | |
417280 | 417280 | 2020-08-09 | Vega Alta | Puerto Rico | 72143 | 242 | |
420500 | 420500 | 2020-08-10 | Vega Alta | Puerto Rico | 72143 | 250 | |
423723 | 423723 | 2020-08-11 | Vega Alta | Puerto Rico | 72143 | 258 | |
426946 | 426946 | 2020-08-12 | Vega Alta | Puerto Rico | 72143 | 266 |
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);