ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Patillas" and state = "Puerto Rico" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
117540 | 117540 | 2020-05-05 | Patillas | Puerto Rico | 72109 | 13 | |
120502 | 120502 | 2020-05-06 | Patillas | Puerto Rico | 72109 | 17 | |
123479 | 123479 | 2020-05-07 | Patillas | Puerto Rico | 72109 | 20 | |
126462 | 126462 | 2020-05-08 | Patillas | Puerto Rico | 72109 | 20 | |
129451 | 129451 | 2020-05-09 | Patillas | Puerto Rico | 72109 | 20 | |
132440 | 132440 | 2020-05-10 | Patillas | Puerto Rico | 72109 | 20 | |
135431 | 135431 | 2020-05-11 | Patillas | Puerto Rico | 72109 | 21 | |
138421 | 138421 | 2020-05-12 | Patillas | Puerto Rico | 72109 | 22 | |
141417 | 141417 | 2020-05-13 | Patillas | Puerto Rico | 72109 | 22 | |
144413 | 144413 | 2020-05-14 | Patillas | Puerto Rico | 72109 | 22 | |
147414 | 147414 | 2020-05-15 | Patillas | Puerto Rico | 72109 | 23 | |
150422 | 150422 | 2020-05-16 | Patillas | Puerto Rico | 72109 | 23 | |
153433 | 153433 | 2020-05-17 | Patillas | Puerto Rico | 72109 | 23 | |
156450 | 156450 | 2020-05-18 | Patillas | Puerto Rico | 72109 | 24 | |
159471 | 159471 | 2020-05-19 | Patillas | Puerto Rico | 72109 | 25 | |
162498 | 162498 | 2020-05-20 | Patillas | Puerto Rico | 72109 | 27 | |
165527 | 165527 | 2020-05-21 | Patillas | Puerto Rico | 72109 | 27 | |
168563 | 168563 | 2020-05-22 | Patillas | Puerto Rico | 72109 | 27 | |
171602 | 171602 | 2020-05-23 | Patillas | Puerto Rico | 72109 | 29 | |
174644 | 174644 | 2020-05-24 | Patillas | Puerto Rico | 72109 | 29 | |
177688 | 177688 | 2020-05-25 | Patillas | Puerto Rico | 72109 | 29 | |
180731 | 180731 | 2020-05-26 | Patillas | Puerto Rico | 72109 | 31 | |
183781 | 183781 | 2020-05-27 | Patillas | Puerto Rico | 72109 | 31 | |
186838 | 186838 | 2020-05-28 | Patillas | Puerto Rico | 72109 | 31 | |
189900 | 189900 | 2020-05-29 | Patillas | Puerto Rico | 72109 | 31 | |
192965 | 192965 | 2020-05-30 | Patillas | Puerto Rico | 72109 | 33 | |
196034 | 196034 | 2020-05-31 | Patillas | Puerto Rico | 72109 | 33 | |
199107 | 199107 | 2020-06-01 | Patillas | Puerto Rico | 72109 | 33 | |
202182 | 202182 | 2020-06-02 | Patillas | Puerto Rico | 72109 | 34 | |
205259 | 205259 | 2020-06-03 | Patillas | Puerto Rico | 72109 | 34 | |
208340 | 208340 | 2020-06-04 | Patillas | Puerto Rico | 72109 | 38 | |
211422 | 211422 | 2020-06-05 | Patillas | Puerto Rico | 72109 | 38 | |
214508 | 214508 | 2020-06-06 | Patillas | Puerto Rico | 72109 | 41 | |
217598 | 217598 | 2020-06-07 | Patillas | Puerto Rico | 72109 | 41 | |
220690 | 220690 | 2020-06-08 | Patillas | Puerto Rico | 72109 | 41 | |
223785 | 223785 | 2020-06-09 | Patillas | Puerto Rico | 72109 | 42 | |
226885 | 226885 | 2020-06-10 | Patillas | Puerto Rico | 72109 | 42 | |
229989 | 229989 | 2020-06-11 | Patillas | Puerto Rico | 72109 | 42 | |
233094 | 233094 | 2020-06-12 | Patillas | Puerto Rico | 72109 | 43 | |
236199 | 236199 | 2020-06-13 | Patillas | Puerto Rico | 72109 | 43 | |
239307 | 239307 | 2020-06-14 | Patillas | Puerto Rico | 72109 | 43 | |
242416 | 242416 | 2020-06-15 | Patillas | Puerto Rico | 72109 | 44 | |
245528 | 245528 | 2020-06-16 | Patillas | Puerto Rico | 72109 | 44 | |
248641 | 248641 | 2020-06-17 | Patillas | Puerto Rico | 72109 | 44 | |
251756 | 251756 | 2020-06-18 | Patillas | Puerto Rico | 72109 | 46 | |
254871 | 254871 | 2020-06-19 | Patillas | Puerto Rico | 72109 | 48 | |
257997 | 257997 | 2020-06-20 | Patillas | Puerto Rico | 72109 | 48 | |
261124 | 261124 | 2020-06-21 | Patillas | Puerto Rico | 72109 | 48 | |
264252 | 264252 | 2020-06-22 | Patillas | Puerto Rico | 72109 | 48 | |
267380 | 267380 | 2020-06-23 | Patillas | Puerto Rico | 72109 | 50 | |
270514 | 270514 | 2020-06-24 | Patillas | Puerto Rico | 72109 | 52 | |
273653 | 273653 | 2020-06-25 | Patillas | Puerto Rico | 72109 | 52 | |
276800 | 276800 | 2020-06-26 | Patillas | Puerto Rico | 72109 | 52 | |
279948 | 279948 | 2020-06-27 | Patillas | Puerto Rico | 72109 | 54 | |
283094 | 283094 | 2020-06-28 | Patillas | Puerto Rico | 72109 | 57 | |
286239 | 286239 | 2020-06-29 | Patillas | Puerto Rico | 72109 | 59 | |
289390 | 289390 | 2020-06-30 | Patillas | Puerto Rico | 72109 | 59 | |
292542 | 292542 | 2020-07-01 | Patillas | Puerto Rico | 72109 | 59 | |
295698 | 295698 | 2020-07-02 | Patillas | Puerto Rico | 72109 | 59 | |
298857 | 298857 | 2020-07-03 | Patillas | Puerto Rico | 72109 | 59 | |
302021 | 302021 | 2020-07-04 | Patillas | Puerto Rico | 72109 | 60 | |
305184 | 305184 | 2020-07-05 | Patillas | Puerto Rico | 72109 | 60 | |
308351 | 308351 | 2020-07-06 | Patillas | Puerto Rico | 72109 | 62 | |
311520 | 311520 | 2020-07-07 | Patillas | Puerto Rico | 72109 | 63 | |
314692 | 314692 | 2020-07-08 | Patillas | Puerto Rico | 72109 | 64 | |
317865 | 317865 | 2020-07-09 | Patillas | Puerto Rico | 72109 | 64 | |
321043 | 321043 | 2020-07-10 | Patillas | Puerto Rico | 72109 | 66 | |
324223 | 324223 | 2020-07-11 | Patillas | Puerto Rico | 72109 | 66 | |
327408 | 327408 | 2020-07-12 | Patillas | Puerto Rico | 72109 | 66 | |
330594 | 330594 | 2020-07-13 | Patillas | Puerto Rico | 72109 | 68 | |
333786 | 333786 | 2020-07-14 | Patillas | Puerto Rico | 72109 | 68 | |
336980 | 336980 | 2020-07-15 | Patillas | Puerto Rico | 72109 | 68 | |
340177 | 340177 | 2020-07-16 | Patillas | Puerto Rico | 72109 | 68 | |
343375 | 343375 | 2020-07-17 | Patillas | Puerto Rico | 72109 | 69 | |
346575 | 346575 | 2020-07-18 | Patillas | Puerto Rico | 72109 | 70 | |
349775 | 349775 | 2020-07-19 | Patillas | Puerto Rico | 72109 | 70 | |
352978 | 352978 | 2020-07-20 | Patillas | Puerto Rico | 72109 | 70 | |
356181 | 356181 | 2020-07-21 | Patillas | Puerto Rico | 72109 | 75 | |
359385 | 359385 | 2020-07-22 | Patillas | Puerto Rico | 72109 | 77 | |
362591 | 362591 | 2020-07-23 | Patillas | Puerto Rico | 72109 | 83 | |
365797 | 365797 | 2020-07-24 | Patillas | Puerto Rico | 72109 | 85 | |
369006 | 369006 | 2020-07-25 | Patillas | Puerto Rico | 72109 | 85 | |
372218 | 372218 | 2020-07-26 | Patillas | Puerto Rico | 72109 | 85 | |
375431 | 375431 | 2020-07-27 | Patillas | Puerto Rico | 72109 | 85 | |
378647 | 378647 | 2020-07-28 | Patillas | Puerto Rico | 72109 | 88 | |
381864 | 381864 | 2020-07-29 | Patillas | Puerto Rico | 72109 | 90 | |
385082 | 385082 | 2020-07-30 | Patillas | Puerto Rico | 72109 | 92 | |
388299 | 388299 | 2020-07-31 | Patillas | Puerto Rico | 72109 | 92 | |
391516 | 391516 | 2020-08-01 | Patillas | Puerto Rico | 72109 | 95 | |
394732 | 394732 | 2020-08-02 | Patillas | Puerto Rico | 72109 | 95 | |
397949 | 397949 | 2020-08-03 | Patillas | Puerto Rico | 72109 | 97 | |
401164 | 401164 | 2020-08-04 | Patillas | Puerto Rico | 72109 | 97 | |
404382 | 404382 | 2020-08-05 | Patillas | Puerto Rico | 72109 | 97 | |
407601 | 407601 | 2020-08-06 | Patillas | Puerto Rico | 72109 | 98 | |
410821 | 410821 | 2020-08-07 | Patillas | Puerto Rico | 72109 | 99 | |
414041 | 414041 | 2020-08-08 | Patillas | Puerto Rico | 72109 | 102 | |
417262 | 417262 | 2020-08-09 | Patillas | Puerto Rico | 72109 | 104 | |
420482 | 420482 | 2020-08-10 | Patillas | Puerto Rico | 72109 | 107 | |
423705 | 423705 | 2020-08-11 | Patillas | Puerto Rico | 72109 | 107 | |
426928 | 426928 | 2020-08-12 | Patillas | Puerto Rico | 72109 | 108 |
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);