johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
71,726 rows where province_or_state = "Puerto Rico" sorted by combined_key
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
411003 | 411003 | 2021-07-28 | US | Puerto Rico | Adjuntas | 72001 | 472 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-07-29 04:21:33 | Adjuntas, Puerto Rico, US | |
422053 | 422053 | 2022-09-18 | US | Puerto Rico | Adjuntas | 72001 | 5451 | 0 | 0 | 18.180117 | -66.754367 | 2022-09-19 04:21:49 | Adjuntas, Puerto Rico, US | |
426063 | 426063 | 2021-10-10 | US | Puerto Rico | Adjuntas | 72001 | 583 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-10-11 04:21:31 | Adjuntas, Puerto Rico, US | |
430030 | 430030 | 2020-09-07 | US | Puerto Rico | Adjuntas | 72001 | 131 | 0 | 0 | 131 | 18.180117000000006 | -66.754367 | 2020-09-08 04:28:25 | Adjuntas, Puerto Rico, US |
434075 | 434075 | 2022-11-03 | US | Puerto Rico | Adjuntas | 72001 | 5877 | 0 | 0 | 18.180117 | -66.754367 | 2022-11-04 04:22:11 | Adjuntas, Puerto Rico, US | |
438059 | 438059 | 2021-01-21 | US | Puerto Rico | Adjuntas | 72001 | 358 | 0 | 0 | 358 | 18.180117000000006 | -66.754367 | 2021-01-22 05:22:10 | Adjuntas, Puerto Rico, US |
439079 | 439079 | 2020-07-26 | US | Puerto Rico | Adjuntas | 72001 | 77 | 0 | 0 | 77 | 18.180117000000006 | -66.754367 | 2020-07-27 04:35:02 | Adjuntas, Puerto Rico, US |
446067 | 446067 | 2021-10-20 | US | Puerto Rico | Adjuntas | 72001 | 584 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-10-21 04:21:18 | Adjuntas, Puerto Rico, US | |
450084 | 450084 | 2021-11-17 | US | Puerto Rico | Adjuntas | 72001 | 595 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-11-18 04:21:33 | Adjuntas, Puerto Rico, US | |
454105 | 454105 | 2022-12-21 | US | Puerto Rico | Adjuntas | 72001 | 6351 | 0 | 0 | 18.180117 | -66.754367 | 2022-12-22 04:20:56 | Adjuntas, Puerto Rico, US | |
455095 | 455095 | 2020-08-07 | US | Puerto Rico | Adjuntas | 72001 | 92 | 0 | 0 | 92 | 18.180117000000006 | -66.754367 | 2020-08-08 04:34:53 | Adjuntas, Puerto Rico, US |
462093 | 462093 | 2022-02-02 | US | Puerto Rico | Adjuntas | 72001 | 1979 | 0 | 0 | 18.180117000000006 | -66.754367 | 2022-02-03 04:21:21 | Adjuntas, Puerto Rico, US | |
466110 | 466110 | 2022-05-02 | US | Puerto Rico | Adjuntas | 72001 | 2420 | 0 | 0 | 18.180117 | -66.754367 | 2022-05-03 04:21:00 | Adjuntas, Puerto Rico, US | |
470124 | 470124 | 2021-10-07 | US | Puerto Rico | Adjuntas | 72001 | 582 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-10-08 04:21:25 | Adjuntas, Puerto Rico, US | |
474115 | 474115 | 2021-02-19 | US | Puerto Rico | Adjuntas | 72001 | 375 | 0 | 0 | 375 | 18.180117000000006 | -66.754367 | 2021-02-20 05:22:51 | Adjuntas, Puerto Rico, US |
478157 | 478157 | 2022-06-26 | US | Puerto Rico | Adjuntas | 72001 | 3981 | 0 | 0 | 18.180117 | -66.754367 | 2022-06-27 04:21:00 | Adjuntas, Puerto Rico, US | |
482308 | 482308 | 2022-11-08 | US | Puerto Rico | Adjuntas | 72001 | 5907 | 0 | 0 | 18.180117 | -66.754367 | 2022-11-09 04:21:22 | Adjuntas, Puerto Rico, US | |
486299 | 486299 | 2021-07-19 | US | Puerto Rico | Adjuntas | 72001 | 470 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-07-20 04:21:48 | Adjuntas, Puerto Rico, US | |
490338 | 490338 | 2022-11-25 | US | Puerto Rico | Adjuntas | 72001 | 6046 | 0 | 0 | 18.180117 | -66.754367 | 2022-11-26 04:21:11 | Adjuntas, Puerto Rico, US | |
494348 | 494348 | 2021-10-14 | US | Puerto Rico | Adjuntas | 72001 | 584 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-10-15 04:21:26 | Adjuntas, Puerto Rico, US | |
498365 | 498365 | 2021-11-06 | US | Puerto Rico | Adjuntas | 72001 | 588 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-11-07 04:21:53 | Adjuntas, Puerto Rico, US | |
502382 | 502382 | 2022-04-02 | US | Puerto Rico | Adjuntas | 72001 | 2130 | 0 | 0 | 18.180117000000006 | -66.754367 | 2022-04-03 04:20:48 | Adjuntas, Puerto Rico, US | |
506402 | 506402 | 2022-12-17 | US | Puerto Rico | Adjuntas | 72001 | 6326 | 0 | 0 | 18.180117 | -66.754367 | 2022-12-18 04:21:03 | Adjuntas, Puerto Rico, US | |
510393 | 510393 | 2021-08-14 | US | Puerto Rico | Adjuntas | 72001 | 490 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-08-15 04:21:41 | Adjuntas, Puerto Rico, US | |
514407 | 514407 | 2021-08-19 | US | Puerto Rico | Adjuntas | 72001 | 498 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-08-20 04:21:33 | Adjuntas, Puerto Rico, US | |
518446 | 518446 | 2022-10-15 | US | Puerto Rico | Adjuntas | 72001 | 5591 | 0 | 0 | 18.180117 | -66.754367 | 2022-10-16 04:22:39 | Adjuntas, Puerto Rico, US | |
525563 | 525563 | 2021-06-09 | US | Puerto Rico | Adjuntas | 72001 | 467 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-06-10 04:23:17 | Adjuntas, Puerto Rico, US | |
533409 | 533409 | 2021-02-22 | US | Puerto Rico | Adjuntas | 72001 | 376 | 0 | 0 | 376 | 18.180117000000006 | -66.754367 | 2021-02-23 05:23:41 | Adjuntas, Puerto Rico, US |
537448 | 537448 | 2021-10-27 | US | Puerto Rico | Adjuntas | 72001 | 585 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-10-28 04:22:08 | Adjuntas, Puerto Rico, US | |
541470 | 541470 | 2022-10-26 | US | Puerto Rico | Adjuntas | 72001 | 5737 | 0 | 0 | 18.180117 | -66.754367 | 2022-10-27 04:22:01 | Adjuntas, Puerto Rico, US | |
545486 | 545486 | 2022-12-15 | US | Puerto Rico | Adjuntas | 72001 | 6313 | 0 | 0 | 18.180117 | -66.754367 | 2022-12-16 04:21:01 | Adjuntas, Puerto Rico, US | |
549447 | 549447 | 2020-09-12 | US | Puerto Rico | Adjuntas | 72001 | 135 | 0 | 0 | 135 | 18.180117000000006 | -66.754367 | 2020-09-13 04:30:52 | Adjuntas, Puerto Rico, US |
553487 | 553487 | 2021-12-08 | US | Puerto Rico | Adjuntas | 72001 | 624 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-12-09 04:22:49 | Adjuntas, Puerto Rico, US | |
557503 | 557503 | 2022-01-16 | US | Puerto Rico | Adjuntas | 72001 | 1656 | 0 | 0 | 18.180117000000006 | -66.754367 | 2022-01-17 04:21:08 | Adjuntas, Puerto Rico, US | |
561521 | 561521 | 2022-06-16 | US | Puerto Rico | Adjuntas | 72001 | 3770 | 0 | 0 | 18.180117 | -66.754367 | 2022-06-17 04:20:56 | Adjuntas, Puerto Rico, US | |
565675 | 565675 | 2021-06-22 | US | Puerto Rico | Adjuntas | 72001 | 468 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-06-23 04:21:46 | Adjuntas, Puerto Rico, US | |
569816 | 569816 | 2021-10-29 | US | Puerto Rico | Adjuntas | 72001 | 585 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-10-30 04:22:03 | Adjuntas, Puerto Rico, US | |
577546 | 577546 | 2022-02-25 | US | Puerto Rico | Adjuntas | 72001 | 2049 | 0 | 0 | 18.180117000000006 | -66.754367 | 2022-02-26 04:21:12 | Adjuntas, Puerto Rico, US | |
581541 | 581541 | 2021-07-13 | US | Puerto Rico | Adjuntas | 72001 | 469 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-07-14 04:21:35 | Adjuntas, Puerto Rico, US | |
585516 | 585516 | 2020-08-13 | US | Puerto Rico | Adjuntas | 72001 | 98 | 0 | 0 | 98 | 18.180117000000006 | -66.754367 | 2020-08-14 04:51:19 | Adjuntas, Puerto Rico, US |
592337 | 592337 | 2021-08-08 | US | Puerto Rico | Adjuntas | 72001 | 478 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-08-09 04:21:24 | Adjuntas, Puerto Rico, US | |
596373 | 596373 | 2022-07-01 | US | Puerto Rico | Adjuntas | 72001 | 4124 | 0 | 0 | 18.180117 | -66.754367 | 2022-07-02 04:21:16 | Adjuntas, Puerto Rico, US | |
600386 | 600386 | 2021-10-19 | US | Puerto Rico | Adjuntas | 72001 | 584 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-10-20 04:21:00 | Adjuntas, Puerto Rico, US | |
604401 | 604401 | 2021-09-23 | US | Puerto Rico | Adjuntas | 72001 | 577 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-09-24 04:21:44 | Adjuntas, Puerto Rico, US | |
608394 | 608394 | 2021-04-09 | US | Puerto Rico | Adjuntas | 72001 | 416 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-04-10 04:20:59 | Adjuntas, Puerto Rico, US | |
612378 | 612378 | 2020-08-29 | US | Puerto Rico | Adjuntas | 72001 | 119 | 0 | 0 | 119 | 18.180117000000006 | -66.754367 | 2020-08-30 04:28:22 | Adjuntas, Puerto Rico, US |
616391 | 616391 | 2021-02-08 | US | Puerto Rico | Adjuntas | 72001 | 369 | 0 | 0 | 369 | 18.180117000000006 | -66.754367 | 2021-02-09 05:23:30 | Adjuntas, Puerto Rico, US |
620580 | 620580 | 2022-11-05 | US | Puerto Rico | Adjuntas | 72001 | 5892 | 0 | 0 | 18.180117 | -66.754367 | 2022-11-06 04:21:24 | Adjuntas, Puerto Rico, US | |
624593 | 624593 | 2022-05-22 | US | Puerto Rico | Adjuntas | 72001 | 3144 | 0 | 0 | 18.180117 | -66.754367 | 2022-05-26 04:20:50 | Adjuntas, Puerto Rico, US | |
628587 | 628587 | 2021-07-10 | US | Puerto Rico | Adjuntas | 72001 | 469 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-07-11 04:21:43 | Adjuntas, Puerto Rico, US | |
632623 | 632623 | 2022-07-12 | US | Puerto Rico | Adjuntas | 72001 | 4303 | 0 | 0 | 18.180117 | -66.754367 | 2022-07-13 04:20:58 | Adjuntas, Puerto Rico, US | |
636636 | 636636 | 2021-10-13 | US | Puerto Rico | Adjuntas | 72001 | 583 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-10-14 04:21:29 | Adjuntas, Puerto Rico, US | |
640627 | 640627 | 2021-03-31 | US | Puerto Rico | Adjuntas | 72001 | 397 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-04-01 04:27:05 | Adjuntas, Puerto Rico, US | |
644647 | 644647 | 2021-09-07 | US | Puerto Rico | Adjuntas | 72001 | 559 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-09-08 04:21:31 | Adjuntas, Puerto Rico, US | |
648657 | 648657 | 2021-05-05 | US | Puerto Rico | Adjuntas | 72001 | 460 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-05-06 04:20:38 | Adjuntas, Puerto Rico, US | |
652675 | 652675 | 2021-08-09 | US | Puerto Rico | Adjuntas | 72001 | 482 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-08-10 04:21:27 | Adjuntas, Puerto Rico, US | |
656708 | 656708 | 2021-10-22 | US | Puerto Rico | Adjuntas | 72001 | 584 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-10-23 04:21:32 | Adjuntas, Puerto Rico, US | |
661028 | 661028 | 2022-05-13 | US | Puerto Rico | Adjuntas | 72001 | 2729 | 0 | 0 | 18.180117 | -66.754367 | 2022-05-14 04:20:48 | Adjuntas, Puerto Rico, US | |
665029 | 665029 | 2020-08-11 | US | Puerto Rico | Adjuntas | 72001 | 95 | 0 | 0 | 95 | 18.180117000000006 | -66.754367 | 2020-08-12 04:27:29 | Adjuntas, Puerto Rico, US |
668972 | 668972 | 2020-09-16 | US | Puerto Rico | Adjuntas | 72001 | 141 | 0 | 0 | 141 | 18.180117 | -66.754367 | 2020-09-17 04:22:00 | Adjuntas, Puerto Rico, US |
673014 | 673014 | 2022-07-21 | US | Puerto Rico | Adjuntas | 72001 | 4506 | 0 | 0 | 18.180117 | -66.754367 | 2022-07-22 04:21:15 | Adjuntas, Puerto Rico, US | |
677030 | 677030 | 2022-07-30 | US | Puerto Rico | Adjuntas | 72001 | 4745 | 0 | 0 | 18.180117 | -66.754367 | 2022-07-31 04:21:02 | Adjuntas, Puerto Rico, US | |
681013 | 681013 | 2020-11-23 | US | Puerto Rico | Adjuntas | 72001 | 147 | 0 | 0 | 147 | 18.180117000000006 | -66.754367 | 2020-11-24 05:27:31 | Adjuntas, Puerto Rico, US |
685053 | 685053 | 2021-10-24 | US | Puerto Rico | Adjuntas | 72001 | 584 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-10-25 04:22:31 | Adjuntas, Puerto Rico, US | |
689070 | 689070 | 2021-11-13 | US | Puerto Rico | Adjuntas | 72001 | 595 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-11-14 04:21:31 | Adjuntas, Puerto Rico, US | |
693091 | 693091 | 2022-12-23 | US | Puerto Rico | Adjuntas | 72001 | 6391 | 0 | 0 | 18.180117 | -66.754367 | 2022-12-24 04:21:02 | Adjuntas, Puerto Rico, US | |
697103 | 697103 | 2022-03-17 | US | Puerto Rico | Adjuntas | 72001 | 2108 | 0 | 0 | 18.180117000000006 | -66.754367 | 2022-03-18 04:20:55 | Adjuntas, Puerto Rico, US | |
701118 | 701118 | 2021-11-04 | US | Puerto Rico | Adjuntas | 72001 | 587 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-11-05 04:21:54 | Adjuntas, Puerto Rico, US | |
705108 | 705108 | 2021-03-16 | US | Puerto Rico | Adjuntas | 72001 | 384 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-03-17 05:25:07 | Adjuntas, Puerto Rico, US | |
709146 | 709146 | 2021-09-29 | US | Puerto Rico | Adjuntas | 72001 | 579 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-09-30 04:21:20 | Adjuntas, Puerto Rico, US | |
713168 | 713168 | 2022-11-01 | US | Puerto Rico | Adjuntas | 72001 | 5837 | 0 | 0 | 18.180117 | -66.754367 | 2022-11-02 04:22:09 | Adjuntas, Puerto Rico, US | |
717179 | 717179 | 2021-11-12 | US | Puerto Rico | Adjuntas | 72001 | 595 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-11-13 04:21:38 | Adjuntas, Puerto Rico, US | |
721200 | 721200 | 2022-12-04 | US | Puerto Rico | Adjuntas | 72001 | 6162 | 0 | 0 | 18.180117 | -66.754367 | 2022-12-05 04:20:58 | Adjuntas, Puerto Rico, US | |
725211 | 725211 | 2021-11-20 | US | Puerto Rico | Adjuntas | 72001 | 596 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-11-21 04:22:13 | Adjuntas, Puerto Rico, US | |
729203 | 729203 | 2021-05-22 | US | Puerto Rico | Adjuntas | 72001 | 466 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-05-23 04:20:51 | Adjuntas, Puerto Rico, US | |
733241 | 733241 | 2021-12-27 | US | Puerto Rico | Adjuntas | 72001 | 748 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-12-28 04:21:47 | Adjuntas, Puerto Rico, US | |
741002 | 741002 | 2020-12-02 | US | Puerto Rico | Adjuntas | 72001 | 159 | 0 | 0 | 159 | 18.180117000000006 | -66.754367 | 2020-12-03 05:28:22 | Adjuntas, Puerto Rico, US |
745017 | 745017 | 2021-02-20 | US | Puerto Rico | Adjuntas | 72001 | 376 | 0 | 0 | 376 | 18.180117000000006 | -66.754367 | 2021-02-21 05:24:33 | Adjuntas, Puerto Rico, US |
749058 | 749058 | 2022-04-23 | US | Puerto Rico | Adjuntas | 72001 | 2269 | 0 | 0 | 18.180117000000006 | -66.754367 | 2022-04-24 04:20:56 | Adjuntas, Puerto Rico, US | |
750052 | 750052 | 2020-08-01 | US | Puerto Rico | Adjuntas | 72001 | 85 | 0 | 0 | 85 | 18.180117000000006 | -66.754367 | 2020-08-02 04:34:47 | Adjuntas, Puerto Rico, US |
757001 | 757001 | 2020-10-28 | US | Puerto Rico | Adjuntas | 72001 | 180 | 0 | 0 | 180 | 18.180117000000006 | -66.754367 | 2020-10-29 04:24:49 | Adjuntas, Puerto Rico, US |
761041 | 761041 | 2021-11-26 | US | Puerto Rico | Adjuntas | 72001 | 602 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-11-27 04:22:45 | Adjuntas, Puerto Rico, US | |
765011 | 765011 | 2020-10-18 | US | Puerto Rico | Adjuntas | 72001 | 168 | 0 | 0 | 168 | 18.180117000000006 | -66.754367 | 2020-10-19 04:24:16 | Adjuntas, Puerto Rico, US |
769021 | 769021 | 2020-12-29 | US | Puerto Rico | Adjuntas | 72001 | 309 | 0 | 0 | 309 | 18.180117000000006 | -66.754367 | 2020-12-30 05:22:34 | Adjuntas, Puerto Rico, US |
773061 | 773061 | 2021-10-23 | US | Puerto Rico | Adjuntas | 72001 | 584 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-10-24 04:21:22 | Adjuntas, Puerto Rico, US | |
777049 | 777049 | 2021-01-12 | US | Puerto Rico | Adjuntas | 72001 | 347 | 0 | 0 | 347 | 18.180117000000006 | -66.754367 | 2021-01-13 05:22:15 | Adjuntas, Puerto Rico, US |
781070 | 781070 | 2021-07-08 | US | Puerto Rico | Adjuntas | 72001 | 468 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-07-09 04:21:21 | Adjuntas, Puerto Rico, US | |
785104 | 785104 | 2021-12-13 | US | Puerto Rico | Adjuntas | 72001 | 627 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-12-14 04:22:38 | Adjuntas, Puerto Rico, US | |
789073 | 789073 | 2020-10-15 | US | Puerto Rico | Adjuntas | 72001 | 166 | 0 | 0 | 166 | 18.180117000000006 | -66.754367 | 2020-10-16 04:24:01 | Adjuntas, Puerto Rico, US |
793086 | 793086 | 2021-02-04 | US | Puerto Rico | Adjuntas | 72001 | 367 | 0 | 0 | 367 | 18.180117000000006 | -66.754367 | 2021-02-05 05:22:38 | Adjuntas, Puerto Rico, US |
797132 | 797132 | 2022-10-24 | US | Puerto Rico | Adjuntas | 72001 | 5708 | 0 | 0 | 18.180117 | -66.754367 | 2022-10-25 04:21:53 | Adjuntas, Puerto Rico, US | |
801143 | 801143 | 2021-12-22 | US | Puerto Rico | Adjuntas | 72001 | 677 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-12-23 04:21:21 | Adjuntas, Puerto Rico, US | |
812286 | 812286 | 2021-09-20 | US | Puerto Rico | Adjuntas | 72001 | 574 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-09-21 04:21:26 | Adjuntas, Puerto Rico, US | |
816270 | 816270 | 2020-09-05 | US | Puerto Rico | Adjuntas | 72001 | 128 | 0 | 0 | 128 | 18.180117000000006 | -66.754367 | 2020-09-06 04:28:33 | Adjuntas, Puerto Rico, US |
820262 | 820262 | 2020-10-09 | US | Puerto Rico | Adjuntas | 72001 | 161 | 0 | 0 | 161 | 18.180117000000006 | -66.754367 | 2020-10-10 04:23:57 | Adjuntas, Puerto Rico, US |
824271 | 824271 | 2020-11-19 | US | Puerto Rico | Adjuntas | 72001 | 137 | 0 | 0 | 137 | 18.180117000000006 | -66.754367 | 2020-11-20 05:26:28 | Adjuntas, Puerto Rico, US |
828289 | 828289 | 2021-06-06 | US | Puerto Rico | Adjuntas | 72001 | 467 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-06-07 04:22:51 | Adjuntas, Puerto Rico, US | |
832306 | 832306 | 2021-07-09 | US | Puerto Rico | Adjuntas | 72001 | 468 | 0 | 0 | 18.180117000000006 | -66.754367 | 2021-07-10 04:21:25 | Adjuntas, Puerto Rico, US | |
836345 | 836345 | 2022-12-02 | US | Puerto Rico | Adjuntas | 72001 | 6133 | 0 | 0 | 18.180117 | -66.754367 | 2022-12-03 04:21:02 | Adjuntas, Puerto Rico, US | |
840299 | 840299 | 2020-08-17 | US | Puerto Rico | Adjuntas | 72001 | 102 | 0 | 0 | 102 | 18.180117000000006 | -66.754367 | 2020-08-18 04:27:56 | Adjuntas, Puerto Rico, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);