ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72039 and state = "Puerto Rico" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
430117 | 430117 | 2020-08-13 | Ciales | Puerto Rico | 72039 | 163 | |
433343 | 433343 | 2020-08-14 | Ciales | Puerto Rico | 72039 | 165 | |
436570 | 436570 | 2020-08-15 | Ciales | Puerto Rico | 72039 | 168 | |
439795 | 439795 | 2020-08-16 | Ciales | Puerto Rico | 72039 | 170 | |
443022 | 443022 | 2020-08-17 | Ciales | Puerto Rico | 72039 | 171 | |
446248 | 446248 | 2020-08-18 | Ciales | Puerto Rico | 72039 | 172 | |
449476 | 449476 | 2020-08-19 | Ciales | Puerto Rico | 72039 | 173 | |
452704 | 452704 | 2020-08-20 | Ciales | Puerto Rico | 72039 | 174 | |
455932 | 455932 | 2020-08-21 | Ciales | Puerto Rico | 72039 | 178 | |
459160 | 459160 | 2020-08-22 | Ciales | Puerto Rico | 72039 | 179 | |
462388 | 462388 | 2020-08-23 | Ciales | Puerto Rico | 72039 | 180 | |
465617 | 465617 | 2020-08-24 | Ciales | Puerto Rico | 72039 | 180 | |
468845 | 468845 | 2020-08-25 | Ciales | Puerto Rico | 72039 | 182 | |
472077 | 472077 | 2020-08-26 | Ciales | Puerto Rico | 72039 | 182 | |
475311 | 475311 | 2020-08-27 | Ciales | Puerto Rico | 72039 | 186 | |
478544 | 478544 | 2020-08-28 | Ciales | Puerto Rico | 72039 | 187 | |
481778 | 481778 | 2020-08-29 | Ciales | Puerto Rico | 72039 | 188 | |
485013 | 485013 | 2020-08-30 | Ciales | Puerto Rico | 72039 | 189 | |
488246 | 488246 | 2020-08-31 | Ciales | Puerto Rico | 72039 | 190 | |
491479 | 491479 | 2020-09-01 | Ciales | Puerto Rico | 72039 | 190 | |
494713 | 494713 | 2020-09-02 | Ciales | Puerto Rico | 72039 | 192 | |
497946 | 497946 | 2020-09-03 | Ciales | Puerto Rico | 72039 | 192 | |
501180 | 501180 | 2020-09-04 | Ciales | Puerto Rico | 72039 | 192 | |
504414 | 504414 | 2020-09-05 | Ciales | Puerto Rico | 72039 | 192 | |
507646 | 507646 | 2020-09-06 | Ciales | Puerto Rico | 72039 | 192 | |
510879 | 510879 | 2020-09-07 | Ciales | Puerto Rico | 72039 | 194 | |
514112 | 514112 | 2020-09-08 | Ciales | Puerto Rico | 72039 | 193 | |
517347 | 517347 | 2020-09-09 | Ciales | Puerto Rico | 72039 | 193 | |
520583 | 520583 | 2020-09-10 | Ciales | Puerto Rico | 72039 | 195 | |
523819 | 523819 | 2020-09-11 | Ciales | Puerto Rico | 72039 | 198 | |
527055 | 527055 | 2020-09-12 | Ciales | Puerto Rico | 72039 | 199 | |
530292 | 530292 | 2020-09-13 | Ciales | Puerto Rico | 72039 | 200 | |
533527 | 533527 | 2020-09-14 | Ciales | Puerto Rico | 72039 | 201 | |
536763 | 536763 | 2020-09-15 | Ciales | Puerto Rico | 72039 | 202 | |
540000 | 540000 | 2020-09-16 | Ciales | Puerto Rico | 72039 | 201 | |
543236 | 543236 | 2020-09-17 | Ciales | Puerto Rico | 72039 | 203 | |
546473 | 546473 | 2020-09-18 | Ciales | Puerto Rico | 72039 | 207 | |
549712 | 549712 | 2020-09-19 | Ciales | Puerto Rico | 72039 | 212 | |
552951 | 552951 | 2020-09-20 | Ciales | Puerto Rico | 72039 | 215 | |
556188 | 556188 | 2020-09-21 | Ciales | Puerto Rico | 72039 | 218 | |
559425 | 559425 | 2020-09-22 | Ciales | Puerto Rico | 72039 | 218 | |
562662 | 562662 | 2020-09-23 | Ciales | Puerto Rico | 72039 | 220 | |
565903 | 565903 | 2020-09-24 | Ciales | Puerto Rico | 72039 | 228 | |
569144 | 569144 | 2020-09-25 | Ciales | Puerto Rico | 72039 | 237 | |
572386 | 572386 | 2020-09-26 | Ciales | Puerto Rico | 72039 | 243 | |
575630 | 575630 | 2020-09-27 | Ciales | Puerto Rico | 72039 | 252 | |
578871 | 578871 | 2020-09-28 | Ciales | Puerto Rico | 72039 | 253 | |
582111 | 582111 | 2020-09-29 | Ciales | Puerto Rico | 72039 | 259 | |
585351 | 585351 | 2020-09-30 | Ciales | Puerto Rico | 72039 | 270 | |
588591 | 588591 | 2020-10-01 | Ciales | Puerto Rico | 72039 | 281 | |
591832 | 591832 | 2020-10-02 | Ciales | Puerto Rico | 72039 | 288 | |
595073 | 595073 | 2020-10-03 | Ciales | Puerto Rico | 72039 | 290 | |
598316 | 598316 | 2020-10-04 | Ciales | Puerto Rico | 72039 | 290 | |
601559 | 601559 | 2020-10-05 | Ciales | Puerto Rico | 72039 | 292 | |
604801 | 604801 | 2020-10-06 | Ciales | Puerto Rico | 72039 | 293 | |
608044 | 608044 | 2020-10-07 | Ciales | Puerto Rico | 72039 | 293 | |
611286 | 611286 | 2020-10-08 | Ciales | Puerto Rico | 72039 | 294 | |
614527 | 614527 | 2020-10-09 | Ciales | Puerto Rico | 72039 | 300 | |
617769 | 617769 | 2020-10-10 | Ciales | Puerto Rico | 72039 | 302 | |
621012 | 621012 | 2020-10-11 | Ciales | Puerto Rico | 72039 | 302 | |
624255 | 624255 | 2020-10-12 | Ciales | Puerto Rico | 72039 | 304 | |
627497 | 627497 | 2020-10-13 | Ciales | Puerto Rico | 72039 | 304 | |
630741 | 630741 | 2020-10-14 | Ciales | Puerto Rico | 72039 | 310 | |
633986 | 633986 | 2020-10-15 | Ciales | Puerto Rico | 72039 | 312 | |
637232 | 637232 | 2020-10-16 | Ciales | Puerto Rico | 72039 | 314 | |
640478 | 640478 | 2020-10-17 | Ciales | Puerto Rico | 72039 | 315 | |
643726 | 643726 | 2020-10-18 | Ciales | Puerto Rico | 72039 | 317 | |
646972 | 646972 | 2020-10-19 | Ciales | Puerto Rico | 72039 | 319 | |
650216 | 650216 | 2020-10-20 | Ciales | Puerto Rico | 72039 | 320 | |
653461 | 653461 | 2020-10-21 | Ciales | Puerto Rico | 72039 | 320 | |
656706 | 656706 | 2020-10-22 | Ciales | Puerto Rico | 72039 | 320 | |
659950 | 659950 | 2020-10-23 | Ciales | Puerto Rico | 72039 | 323 | |
663194 | 663194 | 2020-10-24 | Ciales | Puerto Rico | 72039 | 323 | |
666439 | 666439 | 2020-10-25 | Ciales | Puerto Rico | 72039 | 327 | |
669683 | 669683 | 2020-10-26 | Ciales | Puerto Rico | 72039 | 332 | |
672925 | 672925 | 2020-10-27 | Ciales | Puerto Rico | 72039 | 334 | |
676168 | 676168 | 2020-10-28 | Ciales | Puerto Rico | 72039 | 334 | |
679411 | 679411 | 2020-10-29 | Ciales | Puerto Rico | 72039 | 344 | |
682654 | 682654 | 2020-10-30 | Ciales | Puerto Rico | 72039 | 349 | |
685897 | 685897 | 2020-10-31 | Ciales | Puerto Rico | 72039 | 352 | |
689142 | 689142 | 2020-11-01 | Ciales | Puerto Rico | 72039 | 352 | |
692386 | 692386 | 2020-11-02 | Ciales | Puerto Rico | 72039 | 364 | |
695628 | 695628 | 2020-11-03 | Ciales | Puerto Rico | 72039 | 367 | |
698871 | 698871 | 2020-11-04 | Ciales | Puerto Rico | 72039 | 367 | |
702115 | 702115 | 2020-11-05 | Ciales | Puerto Rico | 72039 | 367 | |
705358 | 705358 | 2020-11-06 | Ciales | Puerto Rico | 72039 | 384 | |
708601 | 708601 | 2020-11-07 | Ciales | Puerto Rico | 72039 | 384 | |
711845 | 711845 | 2020-11-08 | Ciales | Puerto Rico | 72039 | 391 | |
715089 | 715089 | 2020-11-09 | Ciales | Puerto Rico | 72039 | 393 | |
718332 | 718332 | 2020-11-10 | Ciales | Puerto Rico | 72039 | 394 | |
721575 | 721575 | 2020-11-11 | Ciales | Puerto Rico | 72039 | 396 | |
724818 | 724818 | 2020-11-12 | Ciales | Puerto Rico | 72039 | 412 | |
728062 | 728062 | 2020-11-13 | Ciales | Puerto Rico | 72039 | 419 | |
731306 | 731306 | 2020-11-14 | Ciales | Puerto Rico | 72039 | 419 | |
734552 | 734552 | 2020-11-15 | Ciales | Puerto Rico | 72039 | 423 | |
737796 | 737796 | 2020-11-16 | Ciales | Puerto Rico | 72039 | 428 | |
741042 | 741042 | 2020-11-17 | Ciales | Puerto Rico | 72039 | 430 | |
744289 | 744289 | 2020-11-18 | Ciales | Puerto Rico | 72039 | 433 | |
747535 | 747535 | 2020-11-19 | Ciales | Puerto Rico | 72039 | 436 | |
750781 | 750781 | 2020-11-20 | Ciales | Puerto Rico | 72039 | 448 |
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);