ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72073 and state = "Puerto Rico" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
430135 | 430135 | 2020-08-13 | Jayuya | Puerto Rico | 72073 | 180 | |
433361 | 433361 | 2020-08-14 | Jayuya | Puerto Rico | 72073 | 182 | |
436588 | 436588 | 2020-08-15 | Jayuya | Puerto Rico | 72073 | 183 | |
439813 | 439813 | 2020-08-16 | Jayuya | Puerto Rico | 72073 | 183 | |
443040 | 443040 | 2020-08-17 | Jayuya | Puerto Rico | 72073 | 184 | |
446266 | 446266 | 2020-08-18 | Jayuya | Puerto Rico | 72073 | 186 | |
449494 | 449494 | 2020-08-19 | Jayuya | Puerto Rico | 72073 | 186 | |
452722 | 452722 | 2020-08-20 | Jayuya | Puerto Rico | 72073 | 186 | |
455950 | 455950 | 2020-08-21 | Jayuya | Puerto Rico | 72073 | 189 | |
459178 | 459178 | 2020-08-22 | Jayuya | Puerto Rico | 72073 | 190 | |
462406 | 462406 | 2020-08-23 | Jayuya | Puerto Rico | 72073 | 190 | |
465635 | 465635 | 2020-08-24 | Jayuya | Puerto Rico | 72073 | 197 | |
468863 | 468863 | 2020-08-25 | Jayuya | Puerto Rico | 72073 | 197 | |
472095 | 472095 | 2020-08-26 | Jayuya | Puerto Rico | 72073 | 197 | |
475329 | 475329 | 2020-08-27 | Jayuya | Puerto Rico | 72073 | 198 | |
478562 | 478562 | 2020-08-28 | Jayuya | Puerto Rico | 72073 | 203 | |
481796 | 481796 | 2020-08-29 | Jayuya | Puerto Rico | 72073 | 204 | |
485031 | 485031 | 2020-08-30 | Jayuya | Puerto Rico | 72073 | 205 | |
488264 | 488264 | 2020-08-31 | Jayuya | Puerto Rico | 72073 | 206 | |
491497 | 491497 | 2020-09-01 | Jayuya | Puerto Rico | 72073 | 206 | |
494731 | 494731 | 2020-09-02 | Jayuya | Puerto Rico | 72073 | 206 | |
497964 | 497964 | 2020-09-03 | Jayuya | Puerto Rico | 72073 | 207 | |
501198 | 501198 | 2020-09-04 | Jayuya | Puerto Rico | 72073 | 207 | |
504432 | 504432 | 2020-09-05 | Jayuya | Puerto Rico | 72073 | 210 | |
507664 | 507664 | 2020-09-06 | Jayuya | Puerto Rico | 72073 | 209 | |
510897 | 510897 | 2020-09-07 | Jayuya | Puerto Rico | 72073 | 211 | |
514130 | 514130 | 2020-09-08 | Jayuya | Puerto Rico | 72073 | 211 | |
517365 | 517365 | 2020-09-09 | Jayuya | Puerto Rico | 72073 | 211 | |
520601 | 520601 | 2020-09-10 | Jayuya | Puerto Rico | 72073 | 214 | |
523837 | 523837 | 2020-09-11 | Jayuya | Puerto Rico | 72073 | 214 | |
527073 | 527073 | 2020-09-12 | Jayuya | Puerto Rico | 72073 | 214 | |
530310 | 530310 | 2020-09-13 | Jayuya | Puerto Rico | 72073 | 218 | |
533545 | 533545 | 2020-09-14 | Jayuya | Puerto Rico | 72073 | 218 | |
536781 | 536781 | 2020-09-15 | Jayuya | Puerto Rico | 72073 | 218 | |
540018 | 540018 | 2020-09-16 | Jayuya | Puerto Rico | 72073 | 219 | |
543254 | 543254 | 2020-09-17 | Jayuya | Puerto Rico | 72073 | 219 | |
546491 | 546491 | 2020-09-18 | Jayuya | Puerto Rico | 72073 | 219 | |
549730 | 549730 | 2020-09-19 | Jayuya | Puerto Rico | 72073 | 219 | |
552969 | 552969 | 2020-09-20 | Jayuya | Puerto Rico | 72073 | 223 | |
556206 | 556206 | 2020-09-21 | Jayuya | Puerto Rico | 72073 | 225 | |
559443 | 559443 | 2020-09-22 | Jayuya | Puerto Rico | 72073 | 225 | |
562680 | 562680 | 2020-09-23 | Jayuya | Puerto Rico | 72073 | 225 | |
565921 | 565921 | 2020-09-24 | Jayuya | Puerto Rico | 72073 | 225 | |
569162 | 569162 | 2020-09-25 | Jayuya | Puerto Rico | 72073 | 228 | |
572404 | 572404 | 2020-09-26 | Jayuya | Puerto Rico | 72073 | 228 | |
575648 | 575648 | 2020-09-27 | Jayuya | Puerto Rico | 72073 | 228 | |
578889 | 578889 | 2020-09-28 | Jayuya | Puerto Rico | 72073 | 230 | |
582129 | 582129 | 2020-09-29 | Jayuya | Puerto Rico | 72073 | 233 | |
585369 | 585369 | 2020-09-30 | Jayuya | Puerto Rico | 72073 | 233 | |
588609 | 588609 | 2020-10-01 | Jayuya | Puerto Rico | 72073 | 235 | |
591850 | 591850 | 2020-10-02 | Jayuya | Puerto Rico | 72073 | 236 | |
595091 | 595091 | 2020-10-03 | Jayuya | Puerto Rico | 72073 | 243 | |
598334 | 598334 | 2020-10-04 | Jayuya | Puerto Rico | 72073 | 246 | |
601577 | 601577 | 2020-10-05 | Jayuya | Puerto Rico | 72073 | 252 | |
604819 | 604819 | 2020-10-06 | Jayuya | Puerto Rico | 72073 | 253 | |
608062 | 608062 | 2020-10-07 | Jayuya | Puerto Rico | 72073 | 253 | |
611304 | 611304 | 2020-10-08 | Jayuya | Puerto Rico | 72073 | 256 | |
614545 | 614545 | 2020-10-09 | Jayuya | Puerto Rico | 72073 | 259 | |
617787 | 617787 | 2020-10-10 | Jayuya | Puerto Rico | 72073 | 262 | |
621030 | 621030 | 2020-10-11 | Jayuya | Puerto Rico | 72073 | 262 | |
624273 | 624273 | 2020-10-12 | Jayuya | Puerto Rico | 72073 | 267 | |
627515 | 627515 | 2020-10-13 | Jayuya | Puerto Rico | 72073 | 267 | |
630759 | 630759 | 2020-10-14 | Jayuya | Puerto Rico | 72073 | 267 | |
634004 | 634004 | 2020-10-15 | Jayuya | Puerto Rico | 72073 | 270 | |
637250 | 637250 | 2020-10-16 | Jayuya | Puerto Rico | 72073 | 271 | |
640496 | 640496 | 2020-10-17 | Jayuya | Puerto Rico | 72073 | 271 | |
643744 | 643744 | 2020-10-18 | Jayuya | Puerto Rico | 72073 | 272 | |
646990 | 646990 | 2020-10-19 | Jayuya | Puerto Rico | 72073 | 274 | |
650234 | 650234 | 2020-10-20 | Jayuya | Puerto Rico | 72073 | 277 | |
653479 | 653479 | 2020-10-21 | Jayuya | Puerto Rico | 72073 | 277 | |
656724 | 656724 | 2020-10-22 | Jayuya | Puerto Rico | 72073 | 276 | |
659968 | 659968 | 2020-10-23 | Jayuya | Puerto Rico | 72073 | 277 | |
663212 | 663212 | 2020-10-24 | Jayuya | Puerto Rico | 72073 | 279 | |
666457 | 666457 | 2020-10-25 | Jayuya | Puerto Rico | 72073 | 283 | |
669701 | 669701 | 2020-10-26 | Jayuya | Puerto Rico | 72073 | 284 | |
672943 | 672943 | 2020-10-27 | Jayuya | Puerto Rico | 72073 | 284 | |
676186 | 676186 | 2020-10-28 | Jayuya | Puerto Rico | 72073 | 284 | |
679429 | 679429 | 2020-10-29 | Jayuya | Puerto Rico | 72073 | 288 | |
682672 | 682672 | 2020-10-30 | Jayuya | Puerto Rico | 72073 | 290 | |
685915 | 685915 | 2020-10-31 | Jayuya | Puerto Rico | 72073 | 292 | |
689160 | 689160 | 2020-11-01 | Jayuya | Puerto Rico | 72073 | 292 | |
692404 | 692404 | 2020-11-02 | Jayuya | Puerto Rico | 72073 | 301 | |
695646 | 695646 | 2020-11-03 | Jayuya | Puerto Rico | 72073 | 301 | |
698889 | 698889 | 2020-11-04 | Jayuya | Puerto Rico | 72073 | 301 | |
702133 | 702133 | 2020-11-05 | Jayuya | Puerto Rico | 72073 | 308 | |
705376 | 705376 | 2020-11-06 | Jayuya | Puerto Rico | 72073 | 311 | |
708619 | 708619 | 2020-11-07 | Jayuya | Puerto Rico | 72073 | 311 | |
711863 | 711863 | 2020-11-08 | Jayuya | Puerto Rico | 72073 | 315 | |
715107 | 715107 | 2020-11-09 | Jayuya | Puerto Rico | 72073 | 317 | |
718350 | 718350 | 2020-11-10 | Jayuya | Puerto Rico | 72073 | 317 | |
721593 | 721593 | 2020-11-11 | Jayuya | Puerto Rico | 72073 | 318 | |
724836 | 724836 | 2020-11-12 | Jayuya | Puerto Rico | 72073 | 325 | |
728080 | 728080 | 2020-11-13 | Jayuya | Puerto Rico | 72073 | 328 | |
731324 | 731324 | 2020-11-14 | Jayuya | Puerto Rico | 72073 | 331 | |
734570 | 734570 | 2020-11-15 | Jayuya | Puerto Rico | 72073 | 332 | |
737814 | 737814 | 2020-11-16 | Jayuya | Puerto Rico | 72073 | 339 | |
741060 | 741060 | 2020-11-17 | Jayuya | Puerto Rico | 72073 | 341 | |
744307 | 744307 | 2020-11-18 | Jayuya | Puerto Rico | 72073 | 341 | |
747553 | 747553 | 2020-11-19 | Jayuya | Puerto Rico | 72073 | 342 | |
750799 | 750799 | 2020-11-20 | Jayuya | Puerto Rico | 72073 | 342 |
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);