ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72045 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 |
---|---|---|---|---|---|---|---|
637235 | 637235 | 2020-10-16 | Comerio | Puerto Rico | 72045 | 267 | |
633989 | 633989 | 2020-10-15 | Comerio | Puerto Rico | 72045 | 266 | |
630744 | 630744 | 2020-10-14 | Comerio | Puerto Rico | 72045 | 266 | |
627500 | 627500 | 2020-10-13 | Comerio | Puerto Rico | 72045 | 266 | |
624258 | 624258 | 2020-10-12 | Comerio | Puerto Rico | 72045 | 266 | |
621015 | 621015 | 2020-10-11 | Comerio | Puerto Rico | 72045 | 265 | |
617772 | 617772 | 2020-10-10 | Comerio | Puerto Rico | 72045 | 264 | |
614530 | 614530 | 2020-10-09 | Comerio | Puerto Rico | 72045 | 264 | |
611289 | 611289 | 2020-10-08 | Comerio | Puerto Rico | 72045 | 262 | |
608047 | 608047 | 2020-10-07 | Comerio | Puerto Rico | 72045 | 261 | |
604804 | 604804 | 2020-10-06 | Comerio | Puerto Rico | 72045 | 261 | |
601562 | 601562 | 2020-10-05 | Comerio | Puerto Rico | 72045 | 261 | |
598319 | 598319 | 2020-10-04 | Comerio | Puerto Rico | 72045 | 261 | |
595076 | 595076 | 2020-10-03 | Comerio | Puerto Rico | 72045 | 260 | |
591835 | 591835 | 2020-10-02 | Comerio | Puerto Rico | 72045 | 257 | |
588594 | 588594 | 2020-10-01 | Comerio | Puerto Rico | 72045 | 254 | |
585354 | 585354 | 2020-09-30 | Comerio | Puerto Rico | 72045 | 254 | |
582114 | 582114 | 2020-09-29 | Comerio | Puerto Rico | 72045 | 254 | |
578874 | 578874 | 2020-09-28 | Comerio | Puerto Rico | 72045 | 252 | |
575633 | 575633 | 2020-09-27 | Comerio | Puerto Rico | 72045 | 250 | |
572389 | 572389 | 2020-09-26 | Comerio | Puerto Rico | 72045 | 249 | |
569147 | 569147 | 2020-09-25 | Comerio | Puerto Rico | 72045 | 249 | |
565906 | 565906 | 2020-09-24 | Comerio | Puerto Rico | 72045 | 244 | |
562665 | 562665 | 2020-09-23 | Comerio | Puerto Rico | 72045 | 236 | |
559428 | 559428 | 2020-09-22 | Comerio | Puerto Rico | 72045 | 236 | |
556191 | 556191 | 2020-09-21 | Comerio | Puerto Rico | 72045 | 235 | |
552954 | 552954 | 2020-09-20 | Comerio | Puerto Rico | 72045 | 230 | |
549715 | 549715 | 2020-09-19 | Comerio | Puerto Rico | 72045 | 222 | |
546476 | 546476 | 2020-09-18 | Comerio | Puerto Rico | 72045 | 204 | |
543239 | 543239 | 2020-09-17 | Comerio | Puerto Rico | 72045 | 201 | |
540003 | 540003 | 2020-09-16 | Comerio | Puerto Rico | 72045 | 198 | |
536766 | 536766 | 2020-09-15 | Comerio | Puerto Rico | 72045 | 198 | |
533530 | 533530 | 2020-09-14 | Comerio | Puerto Rico | 72045 | 197 | |
530295 | 530295 | 2020-09-13 | Comerio | Puerto Rico | 72045 | 195 | |
527058 | 527058 | 2020-09-12 | Comerio | Puerto Rico | 72045 | 191 | |
523822 | 523822 | 2020-09-11 | Comerio | Puerto Rico | 72045 | 181 | |
520586 | 520586 | 2020-09-10 | Comerio | Puerto Rico | 72045 | 175 | |
517350 | 517350 | 2020-09-09 | Comerio | Puerto Rico | 72045 | 175 | |
514115 | 514115 | 2020-09-08 | Comerio | Puerto Rico | 72045 | 175 | |
510882 | 510882 | 2020-09-07 | Comerio | Puerto Rico | 72045 | 175 | |
507649 | 507649 | 2020-09-06 | Comerio | Puerto Rico | 72045 | 174 | |
504417 | 504417 | 2020-09-05 | Comerio | Puerto Rico | 72045 | 174 | |
501183 | 501183 | 2020-09-04 | Comerio | Puerto Rico | 72045 | 173 | |
497949 | 497949 | 2020-09-03 | Comerio | Puerto Rico | 72045 | 174 | |
494716 | 494716 | 2020-09-02 | Comerio | Puerto Rico | 72045 | 174 | |
491482 | 491482 | 2020-09-01 | Comerio | Puerto Rico | 72045 | 174 | |
488249 | 488249 | 2020-08-31 | Comerio | Puerto Rico | 72045 | 173 | |
485016 | 485016 | 2020-08-30 | Comerio | Puerto Rico | 72045 | 170 | |
481781 | 481781 | 2020-08-29 | Comerio | Puerto Rico | 72045 | 167 | |
478547 | 478547 | 2020-08-28 | Comerio | Puerto Rico | 72045 | 166 | |
475314 | 475314 | 2020-08-27 | Comerio | Puerto Rico | 72045 | 164 | |
472080 | 472080 | 2020-08-26 | Comerio | Puerto Rico | 72045 | 160 | |
468848 | 468848 | 2020-08-25 | Comerio | Puerto Rico | 72045 | 160 | |
465620 | 465620 | 2020-08-24 | Comerio | Puerto Rico | 72045 | 160 | |
462391 | 462391 | 2020-08-23 | Comerio | Puerto Rico | 72045 | 156 | |
459163 | 459163 | 2020-08-22 | Comerio | Puerto Rico | 72045 | 154 | |
455935 | 455935 | 2020-08-21 | Comerio | Puerto Rico | 72045 | 150 | |
452707 | 452707 | 2020-08-20 | Comerio | Puerto Rico | 72045 | 146 | |
449479 | 449479 | 2020-08-19 | Comerio | Puerto Rico | 72045 | 144 | |
446251 | 446251 | 2020-08-18 | Comerio | Puerto Rico | 72045 | 144 | |
443025 | 443025 | 2020-08-17 | Comerio | Puerto Rico | 72045 | 141 | |
439798 | 439798 | 2020-08-16 | Comerio | Puerto Rico | 72045 | 138 | |
436573 | 436573 | 2020-08-15 | Comerio | Puerto Rico | 72045 | 137 | |
433346 | 433346 | 2020-08-14 | Comerio | Puerto Rico | 72045 | 132 | |
430120 | 430120 | 2020-08-13 | Comerio | Puerto Rico | 72045 | 131 | |
426895 | 426895 | 2020-08-12 | Comerio | Puerto Rico | 72045 | 130 | |
423672 | 423672 | 2020-08-11 | Comerio | Puerto Rico | 72045 | 122 | |
420449 | 420449 | 2020-08-10 | Comerio | Puerto Rico | 72045 | 122 | |
417229 | 417229 | 2020-08-09 | Comerio | Puerto Rico | 72045 | 117 | |
414008 | 414008 | 2020-08-08 | Comerio | Puerto Rico | 72045 | 115 | |
410788 | 410788 | 2020-08-07 | Comerio | Puerto Rico | 72045 | 114 | |
407568 | 407568 | 2020-08-06 | Comerio | Puerto Rico | 72045 | 113 | |
404349 | 404349 | 2020-08-05 | Comerio | Puerto Rico | 72045 | 112 | |
401131 | 401131 | 2020-08-04 | Comerio | Puerto Rico | 72045 | 112 | |
397916 | 397916 | 2020-08-03 | Comerio | Puerto Rico | 72045 | 110 | |
394699 | 394699 | 2020-08-02 | Comerio | Puerto Rico | 72045 | 105 | |
391483 | 391483 | 2020-08-01 | Comerio | Puerto Rico | 72045 | 102 | |
388266 | 388266 | 2020-07-31 | Comerio | Puerto Rico | 72045 | 99 | |
385049 | 385049 | 2020-07-30 | Comerio | Puerto Rico | 72045 | 97 | |
381831 | 381831 | 2020-07-29 | Comerio | Puerto Rico | 72045 | 95 | |
378614 | 378614 | 2020-07-28 | Comerio | Puerto Rico | 72045 | 95 | |
375398 | 375398 | 2020-07-27 | Comerio | Puerto Rico | 72045 | 94 | |
372185 | 372185 | 2020-07-26 | Comerio | Puerto Rico | 72045 | 94 | |
368973 | 368973 | 2020-07-25 | Comerio | Puerto Rico | 72045 | 92 | |
365764 | 365764 | 2020-07-24 | Comerio | Puerto Rico | 72045 | 89 | |
362558 | 362558 | 2020-07-23 | Comerio | Puerto Rico | 72045 | 86 | |
359352 | 359352 | 2020-07-22 | Comerio | Puerto Rico | 72045 | 84 | |
356148 | 356148 | 2020-07-21 | Comerio | Puerto Rico | 72045 | 84 | |
352945 | 352945 | 2020-07-20 | Comerio | Puerto Rico | 72045 | 84 | |
349742 | 349742 | 2020-07-19 | Comerio | Puerto Rico | 72045 | 82 | |
346542 | 346542 | 2020-07-18 | Comerio | Puerto Rico | 72045 | 76 | |
343342 | 343342 | 2020-07-17 | Comerio | Puerto Rico | 72045 | 75 | |
340144 | 340144 | 2020-07-16 | Comerio | Puerto Rico | 72045 | 71 | |
336947 | 336947 | 2020-07-15 | Comerio | Puerto Rico | 72045 | 69 | |
333753 | 333753 | 2020-07-14 | Comerio | Puerto Rico | 72045 | 69 | |
330561 | 330561 | 2020-07-13 | Comerio | Puerto Rico | 72045 | 69 | |
327375 | 327375 | 2020-07-12 | Comerio | Puerto Rico | 72045 | 64 | |
324190 | 324190 | 2020-07-11 | Comerio | Puerto Rico | 72045 | 58 | |
321010 | 321010 | 2020-07-10 | Comerio | Puerto Rico | 72045 | 55 | |
317832 | 317832 | 2020-07-09 | Comerio | Puerto Rico | 72045 | 55 |
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);