ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72067 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 |
---|---|---|---|---|---|---|---|
637247 | 637247 | 2020-10-16 | Hormigueros | Puerto Rico | 72067 | 191 | |
634001 | 634001 | 2020-10-15 | Hormigueros | Puerto Rico | 72067 | 191 | |
630756 | 630756 | 2020-10-14 | Hormigueros | Puerto Rico | 72067 | 190 | |
627512 | 627512 | 2020-10-13 | Hormigueros | Puerto Rico | 72067 | 190 | |
624270 | 624270 | 2020-10-12 | Hormigueros | Puerto Rico | 72067 | 190 | |
621027 | 621027 | 2020-10-11 | Hormigueros | Puerto Rico | 72067 | 190 | |
617784 | 617784 | 2020-10-10 | Hormigueros | Puerto Rico | 72067 | 187 | |
614542 | 614542 | 2020-10-09 | Hormigueros | Puerto Rico | 72067 | 187 | |
611301 | 611301 | 2020-10-08 | Hormigueros | Puerto Rico | 72067 | 185 | |
608059 | 608059 | 2020-10-07 | Hormigueros | Puerto Rico | 72067 | 183 | |
604816 | 604816 | 2020-10-06 | Hormigueros | Puerto Rico | 72067 | 183 | |
601574 | 601574 | 2020-10-05 | Hormigueros | Puerto Rico | 72067 | 180 | |
598331 | 598331 | 2020-10-04 | Hormigueros | Puerto Rico | 72067 | 179 | |
595088 | 595088 | 2020-10-03 | Hormigueros | Puerto Rico | 72067 | 179 | |
591847 | 591847 | 2020-10-02 | Hormigueros | Puerto Rico | 72067 | 179 | |
588606 | 588606 | 2020-10-01 | Hormigueros | Puerto Rico | 72067 | 178 | |
585366 | 585366 | 2020-09-30 | Hormigueros | Puerto Rico | 72067 | 175 | |
582126 | 582126 | 2020-09-29 | Hormigueros | Puerto Rico | 72067 | 175 | |
578886 | 578886 | 2020-09-28 | Hormigueros | Puerto Rico | 72067 | 175 | |
575645 | 575645 | 2020-09-27 | Hormigueros | Puerto Rico | 72067 | 174 | |
572401 | 572401 | 2020-09-26 | Hormigueros | Puerto Rico | 72067 | 172 | |
569159 | 569159 | 2020-09-25 | Hormigueros | Puerto Rico | 72067 | 168 | |
565918 | 565918 | 2020-09-24 | Hormigueros | Puerto Rico | 72067 | 166 | |
562677 | 562677 | 2020-09-23 | Hormigueros | Puerto Rico | 72067 | 162 | |
559440 | 559440 | 2020-09-22 | Hormigueros | Puerto Rico | 72067 | 162 | |
556203 | 556203 | 2020-09-21 | Hormigueros | Puerto Rico | 72067 | 160 | |
552966 | 552966 | 2020-09-20 | Hormigueros | Puerto Rico | 72067 | 157 | |
549727 | 549727 | 2020-09-19 | Hormigueros | Puerto Rico | 72067 | 153 | |
546488 | 546488 | 2020-09-18 | Hormigueros | Puerto Rico | 72067 | 145 | |
543251 | 543251 | 2020-09-17 | Hormigueros | Puerto Rico | 72067 | 144 | |
540015 | 540015 | 2020-09-16 | Hormigueros | Puerto Rico | 72067 | 143 | |
536778 | 536778 | 2020-09-15 | Hormigueros | Puerto Rico | 72067 | 142 | |
533542 | 533542 | 2020-09-14 | Hormigueros | Puerto Rico | 72067 | 143 | |
530307 | 530307 | 2020-09-13 | Hormigueros | Puerto Rico | 72067 | 141 | |
527070 | 527070 | 2020-09-12 | Hormigueros | Puerto Rico | 72067 | 139 | |
523834 | 523834 | 2020-09-11 | Hormigueros | Puerto Rico | 72067 | 131 | |
520598 | 520598 | 2020-09-10 | Hormigueros | Puerto Rico | 72067 | 130 | |
517362 | 517362 | 2020-09-09 | Hormigueros | Puerto Rico | 72067 | 130 | |
514127 | 514127 | 2020-09-08 | Hormigueros | Puerto Rico | 72067 | 130 | |
510894 | 510894 | 2020-09-07 | Hormigueros | Puerto Rico | 72067 | 130 | |
507661 | 507661 | 2020-09-06 | Hormigueros | Puerto Rico | 72067 | 128 | |
504429 | 504429 | 2020-09-05 | Hormigueros | Puerto Rico | 72067 | 128 | |
501195 | 501195 | 2020-09-04 | Hormigueros | Puerto Rico | 72067 | 128 | |
497961 | 497961 | 2020-09-03 | Hormigueros | Puerto Rico | 72067 | 128 | |
494728 | 494728 | 2020-09-02 | Hormigueros | Puerto Rico | 72067 | 128 | |
491494 | 491494 | 2020-09-01 | Hormigueros | Puerto Rico | 72067 | 124 | |
488261 | 488261 | 2020-08-31 | Hormigueros | Puerto Rico | 72067 | 124 | |
485028 | 485028 | 2020-08-30 | Hormigueros | Puerto Rico | 72067 | 124 | |
481793 | 481793 | 2020-08-29 | Hormigueros | Puerto Rico | 72067 | 121 | |
478559 | 478559 | 2020-08-28 | Hormigueros | Puerto Rico | 72067 | 119 | |
475326 | 475326 | 2020-08-27 | Hormigueros | Puerto Rico | 72067 | 118 | |
472092 | 472092 | 2020-08-26 | Hormigueros | Puerto Rico | 72067 | 118 | |
468860 | 468860 | 2020-08-25 | Hormigueros | Puerto Rico | 72067 | 118 | |
465632 | 465632 | 2020-08-24 | Hormigueros | Puerto Rico | 72067 | 118 | |
462403 | 462403 | 2020-08-23 | Hormigueros | Puerto Rico | 72067 | 118 | |
459175 | 459175 | 2020-08-22 | Hormigueros | Puerto Rico | 72067 | 118 | |
455947 | 455947 | 2020-08-21 | Hormigueros | Puerto Rico | 72067 | 112 | |
452719 | 452719 | 2020-08-20 | Hormigueros | Puerto Rico | 72067 | 111 | |
449491 | 449491 | 2020-08-19 | Hormigueros | Puerto Rico | 72067 | 111 | |
446263 | 446263 | 2020-08-18 | Hormigueros | Puerto Rico | 72067 | 111 | |
443037 | 443037 | 2020-08-17 | Hormigueros | Puerto Rico | 72067 | 111 | |
439810 | 439810 | 2020-08-16 | Hormigueros | Puerto Rico | 72067 | 109 | |
436585 | 436585 | 2020-08-15 | Hormigueros | Puerto Rico | 72067 | 108 | |
433358 | 433358 | 2020-08-14 | Hormigueros | Puerto Rico | 72067 | 102 | |
430132 | 430132 | 2020-08-13 | Hormigueros | Puerto Rico | 72067 | 100 | |
426907 | 426907 | 2020-08-12 | Hormigueros | Puerto Rico | 72067 | 98 | |
423684 | 423684 | 2020-08-11 | Hormigueros | Puerto Rico | 72067 | 98 | |
420461 | 420461 | 2020-08-10 | Hormigueros | Puerto Rico | 72067 | 97 | |
417241 | 417241 | 2020-08-09 | Hormigueros | Puerto Rico | 72067 | 91 | |
414020 | 414020 | 2020-08-08 | Hormigueros | Puerto Rico | 72067 | 90 | |
410800 | 410800 | 2020-08-07 | Hormigueros | Puerto Rico | 72067 | 88 | |
407580 | 407580 | 2020-08-06 | Hormigueros | Puerto Rico | 72067 | 85 | |
404361 | 404361 | 2020-08-05 | Hormigueros | Puerto Rico | 72067 | 84 | |
401143 | 401143 | 2020-08-04 | Hormigueros | Puerto Rico | 72067 | 84 | |
397928 | 397928 | 2020-08-03 | Hormigueros | Puerto Rico | 72067 | 81 | |
394711 | 394711 | 2020-08-02 | Hormigueros | Puerto Rico | 72067 | 81 | |
391495 | 391495 | 2020-08-01 | Hormigueros | Puerto Rico | 72067 | 80 | |
388278 | 388278 | 2020-07-31 | Hormigueros | Puerto Rico | 72067 | 79 | |
385061 | 385061 | 2020-07-30 | Hormigueros | Puerto Rico | 72067 | 79 | |
381843 | 381843 | 2020-07-29 | Hormigueros | Puerto Rico | 72067 | 77 | |
378626 | 378626 | 2020-07-28 | Hormigueros | Puerto Rico | 72067 | 76 | |
375410 | 375410 | 2020-07-27 | Hormigueros | Puerto Rico | 72067 | 76 | |
372197 | 372197 | 2020-07-26 | Hormigueros | Puerto Rico | 72067 | 76 | |
368985 | 368985 | 2020-07-25 | Hormigueros | Puerto Rico | 72067 | 73 | |
365776 | 365776 | 2020-07-24 | Hormigueros | Puerto Rico | 72067 | 71 | |
362570 | 362570 | 2020-07-23 | Hormigueros | Puerto Rico | 72067 | 71 | |
359364 | 359364 | 2020-07-22 | Hormigueros | Puerto Rico | 72067 | 68 | |
356160 | 356160 | 2020-07-21 | Hormigueros | Puerto Rico | 72067 | 67 | |
352957 | 352957 | 2020-07-20 | Hormigueros | Puerto Rico | 72067 | 63 | |
349754 | 349754 | 2020-07-19 | Hormigueros | Puerto Rico | 72067 | 61 | |
346554 | 346554 | 2020-07-18 | Hormigueros | Puerto Rico | 72067 | 57 | |
343354 | 343354 | 2020-07-17 | Hormigueros | Puerto Rico | 72067 | 58 | |
340156 | 340156 | 2020-07-16 | Hormigueros | Puerto Rico | 72067 | 53 | |
336959 | 336959 | 2020-07-15 | Hormigueros | Puerto Rico | 72067 | 47 | |
333765 | 333765 | 2020-07-14 | Hormigueros | Puerto Rico | 72067 | 46 | |
330573 | 330573 | 2020-07-13 | Hormigueros | Puerto Rico | 72067 | 44 | |
327387 | 327387 | 2020-07-12 | Hormigueros | Puerto Rico | 72067 | 40 | |
324202 | 324202 | 2020-07-11 | Hormigueros | Puerto Rico | 72067 | 38 | |
321022 | 321022 | 2020-07-10 | Hormigueros | Puerto Rico | 72067 | 38 | |
317844 | 317844 | 2020-07-09 | Hormigueros | Puerto Rico | 72067 | 33 |
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);