ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72129 and state = "Puerto Rico" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
117550 | 117550 | 2020-05-05 | San Lorenzo | Puerto Rico | 72129 | 15 | |
120512 | 120512 | 2020-05-06 | San Lorenzo | Puerto Rico | 72129 | 16 | |
123489 | 123489 | 2020-05-07 | San Lorenzo | Puerto Rico | 72129 | 16 | |
126472 | 126472 | 2020-05-08 | San Lorenzo | Puerto Rico | 72129 | 19 | |
129461 | 129461 | 2020-05-09 | San Lorenzo | Puerto Rico | 72129 | 19 | |
132450 | 132450 | 2020-05-10 | San Lorenzo | Puerto Rico | 72129 | 19 | |
135441 | 135441 | 2020-05-11 | San Lorenzo | Puerto Rico | 72129 | 20 | |
138431 | 138431 | 2020-05-12 | San Lorenzo | Puerto Rico | 72129 | 20 | |
141427 | 141427 | 2020-05-13 | San Lorenzo | Puerto Rico | 72129 | 20 | |
144423 | 144423 | 2020-05-14 | San Lorenzo | Puerto Rico | 72129 | 22 | |
147424 | 147424 | 2020-05-15 | San Lorenzo | Puerto Rico | 72129 | 23 | |
150432 | 150432 | 2020-05-16 | San Lorenzo | Puerto Rico | 72129 | 23 | |
153443 | 153443 | 2020-05-17 | San Lorenzo | Puerto Rico | 72129 | 25 | |
156460 | 156460 | 2020-05-18 | San Lorenzo | Puerto Rico | 72129 | 25 | |
159481 | 159481 | 2020-05-19 | San Lorenzo | Puerto Rico | 72129 | 27 | |
162508 | 162508 | 2020-05-20 | San Lorenzo | Puerto Rico | 72129 | 31 | |
165537 | 165537 | 2020-05-21 | San Lorenzo | Puerto Rico | 72129 | 31 | |
168573 | 168573 | 2020-05-22 | San Lorenzo | Puerto Rico | 72129 | 34 | |
171612 | 171612 | 2020-05-23 | San Lorenzo | Puerto Rico | 72129 | 34 | |
174654 | 174654 | 2020-05-24 | San Lorenzo | Puerto Rico | 72129 | 34 | |
177698 | 177698 | 2020-05-25 | San Lorenzo | Puerto Rico | 72129 | 34 | |
180741 | 180741 | 2020-05-26 | San Lorenzo | Puerto Rico | 72129 | 35 | |
183791 | 183791 | 2020-05-27 | San Lorenzo | Puerto Rico | 72129 | 36 | |
186848 | 186848 | 2020-05-28 | San Lorenzo | Puerto Rico | 72129 | 37 | |
189910 | 189910 | 2020-05-29 | San Lorenzo | Puerto Rico | 72129 | 40 | |
192975 | 192975 | 2020-05-30 | San Lorenzo | Puerto Rico | 72129 | 41 | |
196044 | 196044 | 2020-05-31 | San Lorenzo | Puerto Rico | 72129 | 41 | |
199117 | 199117 | 2020-06-01 | San Lorenzo | Puerto Rico | 72129 | 42 | |
202192 | 202192 | 2020-06-02 | San Lorenzo | Puerto Rico | 72129 | 42 | |
205269 | 205269 | 2020-06-03 | San Lorenzo | Puerto Rico | 72129 | 42 | |
208350 | 208350 | 2020-06-04 | San Lorenzo | Puerto Rico | 72129 | 45 | |
211432 | 211432 | 2020-06-05 | San Lorenzo | Puerto Rico | 72129 | 46 | |
214518 | 214518 | 2020-06-06 | San Lorenzo | Puerto Rico | 72129 | 49 | |
217608 | 217608 | 2020-06-07 | San Lorenzo | Puerto Rico | 72129 | 49 | |
220700 | 220700 | 2020-06-08 | San Lorenzo | Puerto Rico | 72129 | 50 | |
223795 | 223795 | 2020-06-09 | San Lorenzo | Puerto Rico | 72129 | 54 | |
226895 | 226895 | 2020-06-10 | San Lorenzo | Puerto Rico | 72129 | 55 | |
229999 | 229999 | 2020-06-11 | San Lorenzo | Puerto Rico | 72129 | 55 | |
233104 | 233104 | 2020-06-12 | San Lorenzo | Puerto Rico | 72129 | 58 | |
236209 | 236209 | 2020-06-13 | San Lorenzo | Puerto Rico | 72129 | 59 | |
239317 | 239317 | 2020-06-14 | San Lorenzo | Puerto Rico | 72129 | 60 | |
242426 | 242426 | 2020-06-15 | San Lorenzo | Puerto Rico | 72129 | 60 | |
245538 | 245538 | 2020-06-16 | San Lorenzo | Puerto Rico | 72129 | 60 | |
248651 | 248651 | 2020-06-17 | San Lorenzo | Puerto Rico | 72129 | 62 | |
251766 | 251766 | 2020-06-18 | San Lorenzo | Puerto Rico | 72129 | 62 | |
254881 | 254881 | 2020-06-19 | San Lorenzo | Puerto Rico | 72129 | 62 | |
258007 | 258007 | 2020-06-20 | San Lorenzo | Puerto Rico | 72129 | 62 | |
261134 | 261134 | 2020-06-21 | San Lorenzo | Puerto Rico | 72129 | 62 | |
264262 | 264262 | 2020-06-22 | San Lorenzo | Puerto Rico | 72129 | 62 | |
267390 | 267390 | 2020-06-23 | San Lorenzo | Puerto Rico | 72129 | 62 | |
270524 | 270524 | 2020-06-24 | San Lorenzo | Puerto Rico | 72129 | 63 | |
273663 | 273663 | 2020-06-25 | San Lorenzo | Puerto Rico | 72129 | 63 | |
276810 | 276810 | 2020-06-26 | San Lorenzo | Puerto Rico | 72129 | 63 | |
279958 | 279958 | 2020-06-27 | San Lorenzo | Puerto Rico | 72129 | 63 | |
283104 | 283104 | 2020-06-28 | San Lorenzo | Puerto Rico | 72129 | 63 | |
286249 | 286249 | 2020-06-29 | San Lorenzo | Puerto Rico | 72129 | 65 | |
289400 | 289400 | 2020-06-30 | San Lorenzo | Puerto Rico | 72129 | 66 | |
292552 | 292552 | 2020-07-01 | San Lorenzo | Puerto Rico | 72129 | 66 | |
295708 | 295708 | 2020-07-02 | San Lorenzo | Puerto Rico | 72129 | 66 | |
298867 | 298867 | 2020-07-03 | San Lorenzo | Puerto Rico | 72129 | 68 | |
302031 | 302031 | 2020-07-04 | San Lorenzo | Puerto Rico | 72129 | 69 | |
305194 | 305194 | 2020-07-05 | San Lorenzo | Puerto Rico | 72129 | 70 | |
308361 | 308361 | 2020-07-06 | San Lorenzo | Puerto Rico | 72129 | 72 | |
311530 | 311530 | 2020-07-07 | San Lorenzo | Puerto Rico | 72129 | 73 | |
314702 | 314702 | 2020-07-08 | San Lorenzo | Puerto Rico | 72129 | 73 | |
317875 | 317875 | 2020-07-09 | San Lorenzo | Puerto Rico | 72129 | 74 | |
321053 | 321053 | 2020-07-10 | San Lorenzo | Puerto Rico | 72129 | 76 | |
324233 | 324233 | 2020-07-11 | San Lorenzo | Puerto Rico | 72129 | 76 | |
327418 | 327418 | 2020-07-12 | San Lorenzo | Puerto Rico | 72129 | 76 | |
330604 | 330604 | 2020-07-13 | San Lorenzo | Puerto Rico | 72129 | 77 | |
333796 | 333796 | 2020-07-14 | San Lorenzo | Puerto Rico | 72129 | 77 | |
336990 | 336990 | 2020-07-15 | San Lorenzo | Puerto Rico | 72129 | 78 | |
340187 | 340187 | 2020-07-16 | San Lorenzo | Puerto Rico | 72129 | 79 | |
343385 | 343385 | 2020-07-17 | San Lorenzo | Puerto Rico | 72129 | 80 | |
346585 | 346585 | 2020-07-18 | San Lorenzo | Puerto Rico | 72129 | 82 | |
349785 | 349785 | 2020-07-19 | San Lorenzo | Puerto Rico | 72129 | 87 | |
352988 | 352988 | 2020-07-20 | San Lorenzo | Puerto Rico | 72129 | 93 | |
356191 | 356191 | 2020-07-21 | San Lorenzo | Puerto Rico | 72129 | 96 | |
359395 | 359395 | 2020-07-22 | San Lorenzo | Puerto Rico | 72129 | 98 | |
362601 | 362601 | 2020-07-23 | San Lorenzo | Puerto Rico | 72129 | 101 | |
365807 | 365807 | 2020-07-24 | San Lorenzo | Puerto Rico | 72129 | 107 | |
369016 | 369016 | 2020-07-25 | San Lorenzo | Puerto Rico | 72129 | 110 | |
372228 | 372228 | 2020-07-26 | San Lorenzo | Puerto Rico | 72129 | 117 | |
375441 | 375441 | 2020-07-27 | San Lorenzo | Puerto Rico | 72129 | 117 | |
378657 | 378657 | 2020-07-28 | San Lorenzo | Puerto Rico | 72129 | 119 | |
381874 | 381874 | 2020-07-29 | San Lorenzo | Puerto Rico | 72129 | 121 | |
385092 | 385092 | 2020-07-30 | San Lorenzo | Puerto Rico | 72129 | 124 | |
388309 | 388309 | 2020-07-31 | San Lorenzo | Puerto Rico | 72129 | 127 | |
391526 | 391526 | 2020-08-01 | San Lorenzo | Puerto Rico | 72129 | 136 | |
394742 | 394742 | 2020-08-02 | San Lorenzo | Puerto Rico | 72129 | 138 | |
397959 | 397959 | 2020-08-03 | San Lorenzo | Puerto Rico | 72129 | 142 | |
401174 | 401174 | 2020-08-04 | San Lorenzo | Puerto Rico | 72129 | 143 | |
404392 | 404392 | 2020-08-05 | San Lorenzo | Puerto Rico | 72129 | 147 | |
407611 | 407611 | 2020-08-06 | San Lorenzo | Puerto Rico | 72129 | 147 | |
410831 | 410831 | 2020-08-07 | San Lorenzo | Puerto Rico | 72129 | 162 | |
414051 | 414051 | 2020-08-08 | San Lorenzo | Puerto Rico | 72129 | 169 | |
417272 | 417272 | 2020-08-09 | San Lorenzo | Puerto Rico | 72129 | 174 | |
420492 | 420492 | 2020-08-10 | San Lorenzo | Puerto Rico | 72129 | 179 | |
423715 | 423715 | 2020-08-11 | San Lorenzo | Puerto Rico | 72129 | 183 | |
426938 | 426938 | 2020-08-12 | San Lorenzo | Puerto Rico | 72129 | 186 |
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);