ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Aguas Buenas" and state = "Puerto Rico" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
117490 | 117490 | 2020-05-05 | Aguas Buenas | Puerto Rico | 72007 | 22 | |
120452 | 120452 | 2020-05-06 | Aguas Buenas | Puerto Rico | 72007 | 22 | |
123429 | 123429 | 2020-05-07 | Aguas Buenas | Puerto Rico | 72007 | 23 | |
126412 | 126412 | 2020-05-08 | Aguas Buenas | Puerto Rico | 72007 | 26 | |
129401 | 129401 | 2020-05-09 | Aguas Buenas | Puerto Rico | 72007 | 26 | |
132390 | 132390 | 2020-05-10 | Aguas Buenas | Puerto Rico | 72007 | 26 | |
135381 | 135381 | 2020-05-11 | Aguas Buenas | Puerto Rico | 72007 | 27 | |
138371 | 138371 | 2020-05-12 | Aguas Buenas | Puerto Rico | 72007 | 28 | |
141367 | 141367 | 2020-05-13 | Aguas Buenas | Puerto Rico | 72007 | 29 | |
144363 | 144363 | 2020-05-14 | Aguas Buenas | Puerto Rico | 72007 | 30 | |
147364 | 147364 | 2020-05-15 | Aguas Buenas | Puerto Rico | 72007 | 30 | |
150371 | 150371 | 2020-05-16 | Aguas Buenas | Puerto Rico | 72007 | 31 | |
153382 | 153382 | 2020-05-17 | Aguas Buenas | Puerto Rico | 72007 | 31 | |
156399 | 156399 | 2020-05-18 | Aguas Buenas | Puerto Rico | 72007 | 31 | |
159420 | 159420 | 2020-05-19 | Aguas Buenas | Puerto Rico | 72007 | 31 | |
162447 | 162447 | 2020-05-20 | Aguas Buenas | Puerto Rico | 72007 | 31 | |
165476 | 165476 | 2020-05-21 | Aguas Buenas | Puerto Rico | 72007 | 32 | |
168512 | 168512 | 2020-05-22 | Aguas Buenas | Puerto Rico | 72007 | 33 | |
171551 | 171551 | 2020-05-23 | Aguas Buenas | Puerto Rico | 72007 | 34 | |
174593 | 174593 | 2020-05-24 | Aguas Buenas | Puerto Rico | 72007 | 34 | |
177637 | 177637 | 2020-05-25 | Aguas Buenas | Puerto Rico | 72007 | 34 | |
180680 | 180680 | 2020-05-26 | Aguas Buenas | Puerto Rico | 72007 | 34 | |
183730 | 183730 | 2020-05-27 | Aguas Buenas | Puerto Rico | 72007 | 34 | |
186787 | 186787 | 2020-05-28 | Aguas Buenas | Puerto Rico | 72007 | 35 | |
189848 | 189848 | 2020-05-29 | Aguas Buenas | Puerto Rico | 72007 | 37 | |
192913 | 192913 | 2020-05-30 | Aguas Buenas | Puerto Rico | 72007 | 37 | |
195982 | 195982 | 2020-05-31 | Aguas Buenas | Puerto Rico | 72007 | 38 | |
199055 | 199055 | 2020-06-01 | Aguas Buenas | Puerto Rico | 72007 | 38 | |
202130 | 202130 | 2020-06-02 | Aguas Buenas | Puerto Rico | 72007 | 39 | |
205207 | 205207 | 2020-06-03 | Aguas Buenas | Puerto Rico | 72007 | 39 | |
208288 | 208288 | 2020-06-04 | Aguas Buenas | Puerto Rico | 72007 | 43 | |
211370 | 211370 | 2020-06-05 | Aguas Buenas | Puerto Rico | 72007 | 43 | |
214456 | 214456 | 2020-06-06 | Aguas Buenas | Puerto Rico | 72007 | 45 | |
217546 | 217546 | 2020-06-07 | Aguas Buenas | Puerto Rico | 72007 | 45 | |
220638 | 220638 | 2020-06-08 | Aguas Buenas | Puerto Rico | 72007 | 45 | |
223733 | 223733 | 2020-06-09 | Aguas Buenas | Puerto Rico | 72007 | 46 | |
226833 | 226833 | 2020-06-10 | Aguas Buenas | Puerto Rico | 72007 | 47 | |
229937 | 229937 | 2020-06-11 | Aguas Buenas | Puerto Rico | 72007 | 47 | |
233042 | 233042 | 2020-06-12 | Aguas Buenas | Puerto Rico | 72007 | 48 | |
236147 | 236147 | 2020-06-13 | Aguas Buenas | Puerto Rico | 72007 | 50 | |
239255 | 239255 | 2020-06-14 | Aguas Buenas | Puerto Rico | 72007 | 50 | |
242364 | 242364 | 2020-06-15 | Aguas Buenas | Puerto Rico | 72007 | 51 | |
245476 | 245476 | 2020-06-16 | Aguas Buenas | Puerto Rico | 72007 | 52 | |
248589 | 248589 | 2020-06-17 | Aguas Buenas | Puerto Rico | 72007 | 54 | |
251704 | 251704 | 2020-06-18 | Aguas Buenas | Puerto Rico | 72007 | 54 | |
254819 | 254819 | 2020-06-19 | Aguas Buenas | Puerto Rico | 72007 | 55 | |
257945 | 257945 | 2020-06-20 | Aguas Buenas | Puerto Rico | 72007 | 56 | |
261072 | 261072 | 2020-06-21 | Aguas Buenas | Puerto Rico | 72007 | 56 | |
264200 | 264200 | 2020-06-22 | Aguas Buenas | Puerto Rico | 72007 | 56 | |
267328 | 267328 | 2020-06-23 | Aguas Buenas | Puerto Rico | 72007 | 56 | |
270462 | 270462 | 2020-06-24 | Aguas Buenas | Puerto Rico | 72007 | 57 | |
273601 | 273601 | 2020-06-25 | Aguas Buenas | Puerto Rico | 72007 | 57 | |
276748 | 276748 | 2020-06-26 | Aguas Buenas | Puerto Rico | 72007 | 57 | |
279896 | 279896 | 2020-06-27 | Aguas Buenas | Puerto Rico | 72007 | 57 | |
283042 | 283042 | 2020-06-28 | Aguas Buenas | Puerto Rico | 72007 | 58 | |
286187 | 286187 | 2020-06-29 | Aguas Buenas | Puerto Rico | 72007 | 59 | |
289338 | 289338 | 2020-06-30 | Aguas Buenas | Puerto Rico | 72007 | 59 | |
292490 | 292490 | 2020-07-01 | Aguas Buenas | Puerto Rico | 72007 | 59 | |
295646 | 295646 | 2020-07-02 | Aguas Buenas | Puerto Rico | 72007 | 59 | |
298805 | 298805 | 2020-07-03 | Aguas Buenas | Puerto Rico | 72007 | 59 | |
301969 | 301969 | 2020-07-04 | Aguas Buenas | Puerto Rico | 72007 | 59 | |
305132 | 305132 | 2020-07-05 | Aguas Buenas | Puerto Rico | 72007 | 59 | |
308299 | 308299 | 2020-07-06 | Aguas Buenas | Puerto Rico | 72007 | 60 | |
311468 | 311468 | 2020-07-07 | Aguas Buenas | Puerto Rico | 72007 | 63 | |
314640 | 314640 | 2020-07-08 | Aguas Buenas | Puerto Rico | 72007 | 63 | |
317813 | 317813 | 2020-07-09 | Aguas Buenas | Puerto Rico | 72007 | 63 | |
320991 | 320991 | 2020-07-10 | Aguas Buenas | Puerto Rico | 72007 | 64 | |
324171 | 324171 | 2020-07-11 | Aguas Buenas | Puerto Rico | 72007 | 66 | |
327356 | 327356 | 2020-07-12 | Aguas Buenas | Puerto Rico | 72007 | 68 | |
330542 | 330542 | 2020-07-13 | Aguas Buenas | Puerto Rico | 72007 | 69 | |
333734 | 333734 | 2020-07-14 | Aguas Buenas | Puerto Rico | 72007 | 69 | |
336928 | 336928 | 2020-07-15 | Aguas Buenas | Puerto Rico | 72007 | 72 | |
340125 | 340125 | 2020-07-16 | Aguas Buenas | Puerto Rico | 72007 | 72 | |
343323 | 343323 | 2020-07-17 | Aguas Buenas | Puerto Rico | 72007 | 73 | |
346523 | 346523 | 2020-07-18 | Aguas Buenas | Puerto Rico | 72007 | 77 | |
349723 | 349723 | 2020-07-19 | Aguas Buenas | Puerto Rico | 72007 | 80 | |
352926 | 352926 | 2020-07-20 | Aguas Buenas | Puerto Rico | 72007 | 81 | |
356129 | 356129 | 2020-07-21 | Aguas Buenas | Puerto Rico | 72007 | 82 | |
359333 | 359333 | 2020-07-22 | Aguas Buenas | Puerto Rico | 72007 | 83 | |
362539 | 362539 | 2020-07-23 | Aguas Buenas | Puerto Rico | 72007 | 85 | |
365745 | 365745 | 2020-07-24 | Aguas Buenas | Puerto Rico | 72007 | 87 | |
368954 | 368954 | 2020-07-25 | Aguas Buenas | Puerto Rico | 72007 | 91 | |
372166 | 372166 | 2020-07-26 | Aguas Buenas | Puerto Rico | 72007 | 94 | |
375379 | 375379 | 2020-07-27 | Aguas Buenas | Puerto Rico | 72007 | 94 | |
378595 | 378595 | 2020-07-28 | Aguas Buenas | Puerto Rico | 72007 | 97 | |
381812 | 381812 | 2020-07-29 | Aguas Buenas | Puerto Rico | 72007 | 99 | |
385030 | 385030 | 2020-07-30 | Aguas Buenas | Puerto Rico | 72007 | 102 | |
388247 | 388247 | 2020-07-31 | Aguas Buenas | Puerto Rico | 72007 | 102 | |
391464 | 391464 | 2020-08-01 | Aguas Buenas | Puerto Rico | 72007 | 107 | |
394680 | 394680 | 2020-08-02 | Aguas Buenas | Puerto Rico | 72007 | 111 | |
397897 | 397897 | 2020-08-03 | Aguas Buenas | Puerto Rico | 72007 | 114 | |
401112 | 401112 | 2020-08-04 | Aguas Buenas | Puerto Rico | 72007 | 115 | |
404330 | 404330 | 2020-08-05 | Aguas Buenas | Puerto Rico | 72007 | 117 | |
407549 | 407549 | 2020-08-06 | Aguas Buenas | Puerto Rico | 72007 | 118 | |
410769 | 410769 | 2020-08-07 | Aguas Buenas | Puerto Rico | 72007 | 123 | |
413989 | 413989 | 2020-08-08 | Aguas Buenas | Puerto Rico | 72007 | 126 | |
417210 | 417210 | 2020-08-09 | Aguas Buenas | Puerto Rico | 72007 | 129 | |
420430 | 420430 | 2020-08-10 | Aguas Buenas | Puerto Rico | 72007 | 133 | |
423653 | 423653 | 2020-08-11 | Aguas Buenas | Puerto Rico | 72007 | 137 | |
426876 | 426876 | 2020-08-12 | Aguas Buenas | Puerto Rico | 72007 | 138 |
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);