ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Vega Baja" and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
417281 | 417281 | 2020-08-09 | Vega Baja | Puerto Rico | 72145 | 406 | |
414060 | 414060 | 2020-08-08 | Vega Baja | Puerto Rico | 72145 | 393 | |
410840 | 410840 | 2020-08-07 | Vega Baja | Puerto Rico | 72145 | 373 | |
407620 | 407620 | 2020-08-06 | Vega Baja | Puerto Rico | 72145 | 356 | |
404401 | 404401 | 2020-08-05 | Vega Baja | Puerto Rico | 72145 | 349 | |
401183 | 401183 | 2020-08-04 | Vega Baja | Puerto Rico | 72145 | 321 | |
397968 | 397968 | 2020-08-03 | Vega Baja | Puerto Rico | 72145 | 313 | |
394751 | 394751 | 2020-08-02 | Vega Baja | Puerto Rico | 72145 | 308 | |
391535 | 391535 | 2020-08-01 | Vega Baja | Puerto Rico | 72145 | 303 | |
388318 | 388318 | 2020-07-31 | Vega Baja | Puerto Rico | 72145 | 290 | |
385101 | 385101 | 2020-07-30 | Vega Baja | Puerto Rico | 72145 | 282 | |
381883 | 381883 | 2020-07-29 | Vega Baja | Puerto Rico | 72145 | 269 | |
378666 | 378666 | 2020-07-28 | Vega Baja | Puerto Rico | 72145 | 266 | |
375450 | 375450 | 2020-07-27 | Vega Baja | Puerto Rico | 72145 | 263 | |
372237 | 372237 | 2020-07-26 | Vega Baja | Puerto Rico | 72145 | 260 | |
369025 | 369025 | 2020-07-25 | Vega Baja | Puerto Rico | 72145 | 250 | |
365816 | 365816 | 2020-07-24 | Vega Baja | Puerto Rico | 72145 | 239 | |
362610 | 362610 | 2020-07-23 | Vega Baja | Puerto Rico | 72145 | 224 | |
359404 | 359404 | 2020-07-22 | Vega Baja | Puerto Rico | 72145 | 216 | |
356200 | 356200 | 2020-07-21 | Vega Baja | Puerto Rico | 72145 | 210 | |
352997 | 352997 | 2020-07-20 | Vega Baja | Puerto Rico | 72145 | 191 | |
349794 | 349794 | 2020-07-19 | Vega Baja | Puerto Rico | 72145 | 181 | |
346594 | 346594 | 2020-07-18 | Vega Baja | Puerto Rico | 72145 | 167 | |
343394 | 343394 | 2020-07-17 | Vega Baja | Puerto Rico | 72145 | 157 | |
340196 | 340196 | 2020-07-16 | Vega Baja | Puerto Rico | 72145 | 149 | |
336999 | 336999 | 2020-07-15 | Vega Baja | Puerto Rico | 72145 | 142 | |
333805 | 333805 | 2020-07-14 | Vega Baja | Puerto Rico | 72145 | 137 | |
330613 | 330613 | 2020-07-13 | Vega Baja | Puerto Rico | 72145 | 132 | |
327427 | 327427 | 2020-07-12 | Vega Baja | Puerto Rico | 72145 | 125 | |
324242 | 324242 | 2020-07-11 | Vega Baja | Puerto Rico | 72145 | 117 | |
321062 | 321062 | 2020-07-10 | Vega Baja | Puerto Rico | 72145 | 114 | |
317884 | 317884 | 2020-07-09 | Vega Baja | Puerto Rico | 72145 | 105 | |
314711 | 314711 | 2020-07-08 | Vega Baja | Puerto Rico | 72145 | 102 | |
311539 | 311539 | 2020-07-07 | Vega Baja | Puerto Rico | 72145 | 100 | |
308370 | 308370 | 2020-07-06 | Vega Baja | Puerto Rico | 72145 | 99 | |
305203 | 305203 | 2020-07-05 | Vega Baja | Puerto Rico | 72145 | 92 | |
302040 | 302040 | 2020-07-04 | Vega Baja | Puerto Rico | 72145 | 92 | |
298876 | 298876 | 2020-07-03 | Vega Baja | Puerto Rico | 72145 | 90 | |
295717 | 295717 | 2020-07-02 | Vega Baja | Puerto Rico | 72145 | 89 | |
292561 | 292561 | 2020-07-01 | Vega Baja | Puerto Rico | 72145 | 89 | |
289409 | 289409 | 2020-06-30 | Vega Baja | Puerto Rico | 72145 | 89 | |
286258 | 286258 | 2020-06-29 | Vega Baja | Puerto Rico | 72145 | 86 | |
283113 | 283113 | 2020-06-28 | Vega Baja | Puerto Rico | 72145 | 84 | |
279967 | 279967 | 2020-06-27 | Vega Baja | Puerto Rico | 72145 | 83 | |
276819 | 276819 | 2020-06-26 | Vega Baja | Puerto Rico | 72145 | 82 | |
273672 | 273672 | 2020-06-25 | Vega Baja | Puerto Rico | 72145 | 81 | |
270533 | 270533 | 2020-06-24 | Vega Baja | Puerto Rico | 72145 | 78 | |
267399 | 267399 | 2020-06-23 | Vega Baja | Puerto Rico | 72145 | 78 | |
264271 | 264271 | 2020-06-22 | Vega Baja | Puerto Rico | 72145 | 75 | |
261143 | 261143 | 2020-06-21 | Vega Baja | Puerto Rico | 72145 | 75 | |
258016 | 258016 | 2020-06-20 | Vega Baja | Puerto Rico | 72145 | 76 | |
254890 | 254890 | 2020-06-19 | Vega Baja | Puerto Rico | 72145 | 71 | |
251775 | 251775 | 2020-06-18 | Vega Baja | Puerto Rico | 72145 | 70 | |
248660 | 248660 | 2020-06-17 | Vega Baja | Puerto Rico | 72145 | 69 | |
245547 | 245547 | 2020-06-16 | Vega Baja | Puerto Rico | 72145 | 69 | |
242435 | 242435 | 2020-06-15 | Vega Baja | Puerto Rico | 72145 | 69 | |
239326 | 239326 | 2020-06-14 | Vega Baja | Puerto Rico | 72145 | 68 | |
236218 | 236218 | 2020-06-13 | Vega Baja | Puerto Rico | 72145 | 67 | |
233113 | 233113 | 2020-06-12 | Vega Baja | Puerto Rico | 72145 | 66 | |
230008 | 230008 | 2020-06-11 | Vega Baja | Puerto Rico | 72145 | 65 | |
226904 | 226904 | 2020-06-10 | Vega Baja | Puerto Rico | 72145 | 64 | |
223804 | 223804 | 2020-06-09 | Vega Baja | Puerto Rico | 72145 | 64 | |
220709 | 220709 | 2020-06-08 | Vega Baja | Puerto Rico | 72145 | 63 | |
217617 | 217617 | 2020-06-07 | Vega Baja | Puerto Rico | 72145 | 61 | |
214527 | 214527 | 2020-06-06 | Vega Baja | Puerto Rico | 72145 | 59 | |
211441 | 211441 | 2020-06-05 | Vega Baja | Puerto Rico | 72145 | 58 | |
208359 | 208359 | 2020-06-04 | Vega Baja | Puerto Rico | 72145 | 55 | |
205278 | 205278 | 2020-06-03 | Vega Baja | Puerto Rico | 72145 | 47 | |
202201 | 202201 | 2020-06-02 | Vega Baja | Puerto Rico | 72145 | 46 | |
199126 | 199126 | 2020-06-01 | Vega Baja | Puerto Rico | 72145 | 43 | |
196053 | 196053 | 2020-05-31 | Vega Baja | Puerto Rico | 72145 | 42 | |
192984 | 192984 | 2020-05-30 | Vega Baja | Puerto Rico | 72145 | 41 | |
189919 | 189919 | 2020-05-29 | Vega Baja | Puerto Rico | 72145 | 39 | |
186857 | 186857 | 2020-05-28 | Vega Baja | Puerto Rico | 72145 | 38 | |
183800 | 183800 | 2020-05-27 | Vega Baja | Puerto Rico | 72145 | 37 | |
180750 | 180750 | 2020-05-26 | Vega Baja | Puerto Rico | 72145 | 37 | |
177707 | 177707 | 2020-05-25 | Vega Baja | Puerto Rico | 72145 | 36 | |
174663 | 174663 | 2020-05-24 | Vega Baja | Puerto Rico | 72145 | 35 | |
171621 | 171621 | 2020-05-23 | Vega Baja | Puerto Rico | 72145 | 35 | |
168582 | 168582 | 2020-05-22 | Vega Baja | Puerto Rico | 72145 | 34 | |
165546 | 165546 | 2020-05-21 | Vega Baja | Puerto Rico | 72145 | 33 | |
162517 | 162517 | 2020-05-20 | Vega Baja | Puerto Rico | 72145 | 33 | |
159490 | 159490 | 2020-05-19 | Vega Baja | Puerto Rico | 72145 | 33 | |
156469 | 156469 | 2020-05-18 | Vega Baja | Puerto Rico | 72145 | 33 | |
153452 | 153452 | 2020-05-17 | Vega Baja | Puerto Rico | 72145 | 32 | |
150441 | 150441 | 2020-05-16 | Vega Baja | Puerto Rico | 72145 | 32 | |
147433 | 147433 | 2020-05-15 | Vega Baja | Puerto Rico | 72145 | 31 | |
144432 | 144432 | 2020-05-14 | Vega Baja | Puerto Rico | 72145 | 30 | |
141436 | 141436 | 2020-05-13 | Vega Baja | Puerto Rico | 72145 | 30 | |
138440 | 138440 | 2020-05-12 | Vega Baja | Puerto Rico | 72145 | 30 | |
135450 | 135450 | 2020-05-11 | Vega Baja | Puerto Rico | 72145 | 30 | |
132459 | 132459 | 2020-05-10 | Vega Baja | Puerto Rico | 72145 | 29 | |
129470 | 129470 | 2020-05-09 | Vega Baja | Puerto Rico | 72145 | 29 | |
126481 | 126481 | 2020-05-08 | Vega Baja | Puerto Rico | 72145 | 29 | |
123498 | 123498 | 2020-05-07 | Vega Baja | Puerto Rico | 72145 | 27 | |
120521 | 120521 | 2020-05-06 | Vega Baja | Puerto Rico | 72145 | 22 | |
117559 | 117559 | 2020-05-05 | Vega Baja | Puerto Rico | 72145 | 21 |
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);