johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
895 rows where combined_key = "Aguada, Puerto Rico, US", country_or_region = "US" and province_or_state = "Puerto Rico" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755622 | 2755622 | 2022-12-29 | US | Puerto Rico | Aguada | 72003 | 12246 | 0 | 0 | 18.360255 | -67.175131 | 2022-12-30 04:21:04 | Aguada, Puerto Rico, US | |
1076628 | 1076628 | 2022-12-28 | US | Puerto Rico | Aguada | 72003 | 12234 | 0 | 0 | 18.360255 | -67.175131 | 2022-12-29 04:21:01 | Aguada, Puerto Rico, US | |
330625 | 330625 | 2022-12-27 | US | Puerto Rico | Aguada | 72003 | 12217 | 0 | 0 | 18.360255 | -67.175131 | 2022-12-28 04:21:04 | Aguada, Puerto Rico, US | |
220698 | 220698 | 2022-12-26 | US | Puerto Rico | Aguada | 72003 | 12205 | 0 | 0 | 18.360255 | -67.175131 | 2022-12-27 04:21:07 | Aguada, Puerto Rico, US | |
3225155 | 3225155 | 2022-12-25 | US | Puerto Rico | Aguada | 72003 | 12205 | 0 | 0 | 18.360255 | -67.175131 | 2022-12-26 04:21:06 | Aguada, Puerto Rico, US | |
1021069 | 1021069 | 2022-12-24 | US | Puerto Rico | Aguada | 72003 | 12205 | 0 | 0 | 18.360255 | -67.175131 | 2022-12-25 04:21:04 | Aguada, Puerto Rico, US | |
693092 | 693092 | 2022-12-23 | US | Puerto Rico | Aguada | 72003 | 12197 | 0 | 0 | 18.360255 | -67.175131 | 2022-12-24 04:21:02 | Aguada, Puerto Rico, US | |
2182302 | 2182302 | 2022-12-22 | US | Puerto Rico | Aguada | 72003 | 12175 | 0 | 0 | 18.360255 | -67.175131 | 2022-12-23 04:21:04 | Aguada, Puerto Rico, US | |
454106 | 454106 | 2022-12-21 | US | Puerto Rico | Aguada | 72003 | 12149 | 0 | 0 | 18.360255 | -67.175131 | 2022-12-22 04:20:56 | Aguada, Puerto Rico, US | |
2954105 | 2954105 | 2022-12-20 | US | Puerto Rico | Aguada | 72003 | 12140 | 0 | 0 | 18.360255 | -67.175131 | 2022-12-21 04:21:03 | Aguada, Puerto Rico, US | |
3176507 | 3176507 | 2022-12-19 | US | Puerto Rico | Aguada | 72003 | 12138 | 0 | 0 | 18.360255 | -67.175131 | 2022-12-20 04:21:04 | Aguada, Puerto Rico, US | |
1631024 | 1631024 | 2022-12-18 | US | Puerto Rico | Aguada | 72003 | 12129 | 0 | 0 | 18.360255 | -67.175131 | 2022-12-19 04:21:03 | Aguada, Puerto Rico, US | |
506403 | 506403 | 2022-12-17 | US | Puerto Rico | Aguada | 72003 | 12101 | 0 | 0 | 18.360255 | -67.175131 | 2022-12-18 04:21:03 | Aguada, Puerto Rico, US | |
3326975 | 3326975 | 2022-12-16 | US | Puerto Rico | Aguada | 72003 | 12079 | 0 | 0 | 18.360255 | -67.175131 | 2022-12-17 04:21:04 | Aguada, Puerto Rico, US | |
545487 | 545487 | 2022-12-15 | US | Puerto Rico | Aguada | 72003 | 12065 | 0 | 0 | 18.360255 | -67.175131 | 2022-12-16 04:21:01 | Aguada, Puerto Rico, US | |
351015 | 351015 | 2022-12-14 | US | Puerto Rico | Aguada | 72003 | 12052 | 0 | 0 | 18.360255 | -67.175131 | 2022-12-15 04:20:58 | Aguada, Puerto Rico, US | |
310603 | 310603 | 2022-12-13 | US | Puerto Rico | Aguada | 72003 | 12034 | 0 | 0 | 18.360255 | -67.175131 | 2022-12-14 04:21:04 | Aguada, Puerto Rico, US | |
1151664 | 1151664 | 2022-12-12 | US | Puerto Rico | Aguada | 72003 | 12029 | 0 | 0 | 18.360255 | -67.175131 | 2022-12-13 04:21:01 | Aguada, Puerto Rico, US | |
871518 | 871518 | 2022-12-11 | US | Puerto Rico | Aguada | 72003 | 12024 | 0 | 0 | 18.360255 | -67.175131 | 2022-12-12 04:21:01 | Aguada, Puerto Rico, US | |
260048 | 260048 | 2022-12-10 | US | Puerto Rico | Aguada | 72003 | 12008 | 0 | 0 | 18.360255 | -67.175131 | 2022-12-11 04:20:50 | Aguada, Puerto Rico, US | |
3938762 | 3938762 | 2022-12-09 | US | Puerto Rico | Aguada | 72003 | 11998 | 0 | 0 | 18.360255 | -67.175131 | 2022-12-10 04:21:02 | Aguada, Puerto Rico, US | |
3380094 | 3380094 | 2022-12-08 | US | Puerto Rico | Aguada | 72003 | 11981 | 0 | 0 | 18.360255 | -67.175131 | 2022-12-09 04:21:05 | Aguada, Puerto Rico, US | |
1987365 | 1987365 | 2022-12-07 | US | Puerto Rico | Aguada | 72003 | 11966 | 0 | 0 | 18.360255 | -67.175131 | 2022-12-08 04:21:07 | Aguada, Puerto Rico, US | |
3716888 | 3716888 | 2022-12-06 | US | Puerto Rico | Aguada | 72003 | 11950 | 0 | 0 | 18.360255 | -67.175131 | 2022-12-07 04:20:58 | Aguada, Puerto Rico, US | |
2417593 | 2417593 | 2022-12-05 | US | Puerto Rico | Aguada | 72003 | 11948 | 0 | 0 | 18.360255 | -67.175131 | 2022-12-06 04:21:03 | Aguada, Puerto Rico, US | |
721201 | 721201 | 2022-12-04 | US | Puerto Rico | Aguada | 72003 | 11943 | 0 | 0 | 18.360255 | -67.175131 | 2022-12-05 04:20:58 | Aguada, Puerto Rico, US | |
2819490 | 2819490 | 2022-12-03 | US | Puerto Rico | Aguada | 72003 | 11939 | 0 | 0 | 18.360255 | -67.175131 | 2022-12-04 04:20:56 | Aguada, Puerto Rico, US | |
836346 | 836346 | 2022-12-02 | US | Puerto Rico | Aguada | 72003 | 11925 | 0 | 0 | 18.360255 | -67.175131 | 2022-12-03 04:21:02 | Aguada, Puerto Rico, US | |
2138876 | 2138876 | 2022-12-01 | US | Puerto Rico | Aguada | 72003 | 11872 | 0 | 0 | 18.360255 | -67.175131 | 2022-12-02 04:21:07 | Aguada, Puerto Rico, US | |
1967292 | 1967292 | 2022-11-30 | US | Puerto Rico | Aguada | 72003 | 11872 | 0 | 0 | 18.360255 | -67.175131 | 2022-12-01 04:21:03 | Aguada, Puerto Rico, US | |
2559306 | 2559306 | 2022-11-29 | US | Puerto Rico | Aguada | 72003 | 11852 | 0 | 0 | 18.360255 | -67.175131 | 2022-11-30 04:21:07 | Aguada, Puerto Rico, US | |
1242380 | 1242380 | 2022-11-28 | US | Puerto Rico | Aguada | 72003 | 11848 | 0 | 0 | 18.360255 | -67.175131 | 2022-11-29 04:21:05 | Aguada, Puerto Rico, US | |
3554368 | 3554368 | 2022-11-27 | US | Puerto Rico | Aguada | 72003 | 11848 | 0 | 0 | 18.360255 | -67.175131 | 2022-11-28 04:21:02 | Aguada, Puerto Rico, US | |
2102848 | 2102848 | 2022-11-26 | US | Puerto Rico | Aguada | 72003 | 11821 | 0 | 0 | 18.360255 | -67.175131 | 2022-11-27 04:21:05 | Aguada, Puerto Rico, US | |
490339 | 490339 | 2022-11-25 | US | Puerto Rico | Aguada | 72003 | 11821 | 0 | 0 | 18.360255 | -67.175131 | 2022-11-26 04:21:11 | Aguada, Puerto Rico, US | |
3526168 | 3526168 | 2022-11-24 | US | Puerto Rico | Aguada | 72003 | 11821 | 0 | 0 | 18.360255 | -67.175131 | 2022-11-25 04:21:06 | Aguada, Puerto Rico, US | |
3314951 | 3314951 | 2022-11-23 | US | Puerto Rico | Aguada | 72003 | 11812 | 0 | 0 | 18.360255 | -67.175131 | 2022-11-24 04:21:09 | Aguada, Puerto Rico, US | |
1622992 | 1622992 | 2022-11-22 | US | Puerto Rico | Aguada | 72003 | 11801 | 0 | 0 | 18.360255 | -67.175131 | 2022-11-23 04:21:06 | Aguada, Puerto Rico, US | |
3462880 | 3462880 | 2022-11-21 | US | Puerto Rico | Aguada | 72003 | 11794 | 0 | 0 | 18.360255 | -67.175131 | 2022-11-22 04:20:47 | Aguada, Puerto Rico, US | |
1643065 | 1643065 | 2022-11-20 | US | Puerto Rico | Aguada | 72003 | 11794 | 0 | 0 | 18.360255 | -67.175131 | 2022-11-21 04:21:05 | Aguada, Puerto Rico, US | |
2066622 | 2066622 | 2022-11-19 | US | Puerto Rico | Aguada | 72003 | 11784 | 0 | 0 | 18.360255 | -67.175131 | 2022-11-20 04:21:08 | Aguada, Puerto Rico, US | |
1758016 | 1758016 | 2022-11-18 | US | Puerto Rico | Aguada | 72003 | 11770 | 0 | 0 | 18.360255 | -67.175131 | 2022-11-19 04:21:14 | Aguada, Puerto Rico, US | |
3029009 | 3029009 | 2022-11-17 | US | Puerto Rico | Aguada | 72003 | 11730 | 0 | 0 | 18.360255 | -67.175131 | 2022-11-18 04:21:15 | Aguada, Puerto Rico, US | |
2488720 | 2488720 | 2022-11-16 | US | Puerto Rico | Aguada | 72003 | 11730 | 0 | 0 | 18.360255 | -67.175131 | 2022-11-17 04:21:11 | Aguada, Puerto Rico, US | |
294731 | 294731 | 2022-11-15 | US | Puerto Rico | Aguada | 72003 | 11709 | 0 | 0 | 18.360255 | -67.175131 | 2022-11-16 04:21:09 | Aguada, Puerto Rico, US | |
3599761 | 3599761 | 2022-11-14 | US | Puerto Rico | Aguada | 72003 | 11709 | 0 | 0 | 18.360255 | -67.175131 | 2022-11-15 04:21:16 | Aguada, Puerto Rico, US | |
314619 | 314619 | 2022-11-13 | US | Puerto Rico | Aguada | 72003 | 11692 | 0 | 0 | 18.360255 | -67.175131 | 2022-11-14 04:21:09 | Aguada, Puerto Rico, US | |
65780 | 65780 | 2022-11-12 | US | Puerto Rico | Aguada | 72003 | 11692 | 0 | 0 | 18.360255 | -67.175131 | 2022-11-13 04:21:14 | Aguada, Puerto Rico, US | |
2929942 | 2929942 | 2022-11-11 | US | Puerto Rico | Aguada | 72003 | 11686 | 0 | 0 | 18.360255 | -67.175131 | 2022-11-12 04:20:41 | Aguada, Puerto Rico, US | |
2508778 | 2508778 | 2022-11-10 | US | Puerto Rico | Aguada | 72003 | 11668 | 0 | 0 | 18.360255 | -67.175131 | 2022-11-11 04:21:22 | Aguada, Puerto Rico, US | |
2433653 | 2433653 | 2022-11-09 | US | Puerto Rico | Aguada | 72003 | 11649 | 0 | 0 | 18.360255 | -67.175131 | 2022-11-10 04:21:16 | Aguada, Puerto Rico, US | |
482309 | 482309 | 2022-11-08 | US | Puerto Rico | Aguada | 72003 | 11641 | 0 | 0 | 18.360255 | -67.175131 | 2022-11-09 04:21:22 | Aguada, Puerto Rico, US | |
2441459 | 2441459 | 2022-11-07 | US | Puerto Rico | Aguada | 72003 | 11635 | 0 | 0 | 18.360255 | -67.175131 | 2022-11-08 04:21:21 | Aguada, Puerto Rico, US | |
1052557 | 1052557 | 2022-11-06 | US | Puerto Rico | Aguada | 72003 | 11628 | 0 | 0 | 18.360255 | -67.175131 | 2022-11-07 04:21:26 | Aguada, Puerto Rico, US | |
620581 | 620581 | 2022-11-05 | US | Puerto Rico | Aguada | 72003 | 11622 | 0 | 0 | 18.360255 | -67.175131 | 2022-11-06 04:21:24 | Aguada, Puerto Rico, US | |
1025085 | 1025085 | 2022-11-04 | US | Puerto Rico | Aguada | 72003 | 11609 | 0 | 0 | 18.360255 | -67.175131 | 2022-11-05 04:21:52 | Aguada, Puerto Rico, US | |
434076 | 434076 | 2022-11-03 | US | Puerto Rico | Aguada | 72003 | 11591 | 0 | 0 | 18.360255 | -67.175131 | 2022-11-04 04:22:11 | Aguada, Puerto Rico, US | |
852318 | 852318 | 2022-11-02 | US | Puerto Rico | Aguada | 72003 | 11573 | 0 | 0 | 18.360255 | -67.175131 | 2022-11-03 04:22:05 | Aguada, Puerto Rico, US | |
713169 | 713169 | 2022-11-01 | US | Puerto Rico | Aguada | 72003 | 11566 | 0 | 0 | 18.360255 | -67.175131 | 2022-11-02 04:22:09 | Aguada, Puerto Rico, US | |
3287618 | 3287618 | 2022-10-31 | US | Puerto Rico | Aguada | 72003 | 11566 | 0 | 0 | 18.360255 | -67.175131 | 2022-11-01 04:22:36 | Aguada, Puerto Rico, US | |
322651 | 322651 | 2022-10-30 | US | Puerto Rico | Aguada | 72003 | 11560 | 0 | 0 | 18.360255 | -67.175131 | 2022-10-31 04:21:36 | Aguada, Puerto Rico, US | |
914927 | 914927 | 2022-10-29 | US | Puerto Rico | Aguada | 72003 | 11548 | 0 | 0 | 18.360255 | -67.175131 | 2022-10-30 04:22:14 | Aguada, Puerto Rico, US | |
1369196 | 1369196 | 2022-10-28 | US | Puerto Rico | Aguada | 72003 | 11540 | 0 | 0 | 18.360255 | -67.175131 | 2022-10-29 04:21:13 | Aguada, Puerto Rico, US | |
3041051 | 3041051 | 2022-10-27 | US | Puerto Rico | Aguada | 72003 | 11521 | 0 | 0 | 18.360255 | -67.175131 | 2022-10-28 04:22:31 | Aguada, Puerto Rico, US | |
541471 | 541471 | 2022-10-26 | US | Puerto Rico | Aguada | 72003 | 11504 | 0 | 0 | 18.360255 | -67.175131 | 2022-10-27 04:22:01 | Aguada, Puerto Rico, US | |
1832872 | 1832872 | 2022-10-25 | US | Puerto Rico | Aguada | 72003 | 11497 | 0 | 0 | 18.360255 | -67.175131 | 2022-10-26 04:22:19 | Aguada, Puerto Rico, US | |
797133 | 797133 | 2022-10-24 | US | Puerto Rico | Aguada | 72003 | 11492 | 0 | 0 | 18.360255 | -67.175131 | 2022-10-25 04:21:53 | Aguada, Puerto Rico, US | |
3279588 | 3279588 | 2022-10-23 | US | Puerto Rico | Aguada | 72003 | 11487 | 0 | 0 | 18.360255 | -67.175131 | 2022-10-24 04:22:29 | Aguada, Puerto Rico, US | |
2270626 | 2270626 | 2022-10-22 | US | Puerto Rico | Aguada | 72003 | 11442 | 0 | 0 | 18.360255 | -67.175131 | 2022-10-23 04:22:46 | Aguada, Puerto Rico, US | |
1594926 | 1594926 | 2022-10-21 | US | Puerto Rico | Aguada | 72003 | 11442 | 0 | 0 | 18.360255 | -67.175131 | 2022-10-22 04:22:53 | Aguada, Puerto Rico, US | |
2274642 | 2274642 | 2022-10-20 | US | Puerto Rico | Aguada | 72003 | 11442 | 0 | 0 | 18.360255 | -67.175131 | 2022-10-21 04:22:23 | Aguada, Puerto Rico, US | |
200977 | 200977 | 2022-10-19 | US | Puerto Rico | Aguada | 72003 | 11442 | 0 | 0 | 18.360255 | -67.175131 | 2022-10-20 04:22:59 | Aguada, Puerto Rico, US | |
2759638 | 2759638 | 2022-10-18 | US | Puerto Rico | Aguada | 72003 | 11436 | 0 | 0 | 18.360255 | -67.175131 | 2022-10-19 04:22:26 | Aguada, Puerto Rico, US | |
2027472 | 2027472 | 2022-10-17 | US | Puerto Rico | Aguada | 72003 | 11433 | 0 | 0 | 18.360255 | -67.175131 | 2022-10-18 04:22:42 | Aguada, Puerto Rico, US | |
2162250 | 2162250 | 2022-10-16 | US | Puerto Rico | Aguada | 72003 | 11429 | 0 | 0 | 18.360255 | -67.175131 | 2022-10-17 04:20:31 | Aguada, Puerto Rico, US | |
518447 | 518447 | 2022-10-15 | US | Puerto Rico | Aguada | 72003 | 11406 | 0 | 0 | 18.360255 | -67.175131 | 2022-10-16 04:22:39 | Aguada, Puerto Rico, US | |
2035504 | 2035504 | 2022-10-14 | US | Puerto Rico | Aguada | 72003 | 11406 | 0 | 0 | 18.360255 | -67.175131 | 2022-10-15 04:22:00 | Aguada, Puerto Rico, US | |
3756192 | 3756192 | 2022-10-13 | US | Puerto Rico | Aguada | 72003 | 11390 | 0 | 0 | 18.360255 | -67.175131 | 2022-10-14 04:22:28 | Aguada, Puerto Rico, US | |
3217017 | 3217017 | 2022-10-12 | US | Puerto Rico | Aguada | 72003 | 11372 | 0 | 0 | 18.360255 | -67.175131 | 2022-10-13 04:22:39 | Aguada, Puerto Rico, US | |
3252866 | 3252866 | 2022-10-11 | US | Puerto Rico | Aguada | 72003 | 11369 | 0 | 0 | 18.360255 | -67.175131 | 2022-10-12 04:22:51 | Aguada, Puerto Rico, US | |
2970125 | 2970125 | 2022-10-10 | US | Puerto Rico | Aguada | 72003 | 11367 | 0 | 0 | 18.360255 | -67.175131 | 2022-10-11 04:23:05 | Aguada, Puerto Rico, US | |
3100161 | 3100161 | 2022-10-09 | US | Puerto Rico | Aguada | 72003 | 11361 | 0 | 0 | 18.360255 | -67.175131 | 2022-10-10 04:22:32 | Aguada, Puerto Rico, US | |
4005386 | 4005386 | 2022-10-08 | US | Puerto Rico | Aguada | 72003 | 11351 | 0 | 0 | 18.360255 | -67.175131 | 2022-10-09 04:21:16 | Aguada, Puerto Rico, US | |
398983 | 398983 | 2022-10-07 | US | Puerto Rico | Aguada | 72003 | 11337 | 0 | 0 | 18.360255 | -67.175131 | 2022-10-08 04:22:56 | Aguada, Puerto Rico, US | |
2532100 | 2532100 | 2022-10-06 | US | Puerto Rico | Aguada | 72003 | 11320 | 0 | 0 | 18.360255 | -67.175131 | 2022-10-07 04:23:08 | Aguada, Puerto Rico, US | |
1813494 | 1813494 | 2022-10-05 | US | Puerto Rico | Aguada | 72003 | 11314 | 0 | 0 | 18.360255 | -67.175131 | 2022-10-06 04:21:22 | Aguada, Puerto Rico, US | |
133468 | 133468 | 2022-10-04 | US | Puerto Rico | Aguada | 72003 | 11306 | 0 | 0 | 18.360255 | -67.175131 | 2022-10-05 04:23:06 | Aguada, Puerto Rico, US | |
2688415 | 2688415 | 2022-10-03 | US | Puerto Rico | Aguada | 72003 | 11303 | 0 | 0 | 18.360255 | -67.175131 | 2022-10-04 04:22:55 | Aguada, Puerto Rico, US | |
2262482 | 2262482 | 2022-10-02 | US | Puerto Rico | Aguada | 72003 | 11297 | 0 | 0 | 18.360255 | -67.175131 | 2022-10-03 04:23:11 | Aguada, Puerto Rico, US | |
2998008 | 2998008 | 2022-10-01 | US | Puerto Rico | Aguada | 72003 | 11286 | 0 | 0 | 18.360255 | -67.175131 | 2022-10-02 04:21:23 | Aguada, Puerto Rico, US | |
856334 | 856334 | 2022-09-30 | US | Puerto Rico | Aguada | 72003 | 11277 | 0 | 0 | 18.360255 | -67.175131 | 2022-10-01 04:23:01 | Aguada, Puerto Rico, US | |
2378260 | 2378260 | 2022-09-29 | US | Puerto Rico | Aguada | 72003 | 11259 | 0 | 0 | 18.360255 | -67.175131 | 2022-09-30 04:23:09 | Aguada, Puerto Rico, US | |
1562811 | 1562811 | 2022-09-28 | US | Puerto Rico | Aguada | 72003 | 11223 | 0 | 0 | 18.360255 | -67.175131 | 2022-09-29 04:22:34 | Aguada, Puerto Rico, US | |
3997354 | 3997354 | 2022-09-27 | US | Puerto Rico | Aguada | 72003 | 11218 | 0 | 0 | 18.360255 | -67.175131 | 2022-09-28 04:23:01 | Aguada, Puerto Rico, US | |
2771682 | 2771682 | 2022-09-26 | US | Puerto Rico | Aguada | 72003 | 11215 | 0 | 0 | 18.360255 | -67.175131 | 2022-09-27 04:23:01 | Aguada, Puerto Rico, US | |
1979335 | 1979335 | 2022-09-25 | US | Puerto Rico | Aguada | 72003 | 11208 | 0 | 0 | 18.360255 | -67.175131 | 2022-09-26 04:20:52 | Aguada, Puerto Rico, US | |
2652502 | 2652502 | 2022-09-24 | US | Puerto Rico | Aguada | 72003 | 11177 | 0 | 0 | 18.360255 | -67.175131 | 2022-09-25 04:23:31 | Aguada, Puerto Rico, US | |
386942 | 386942 | 2022-09-23 | US | Puerto Rico | Aguada | 72003 | 11157 | 0 | 0 | 18.360255 | -67.175131 | 2022-09-24 04:21:40 | Aguada, Puerto Rico, US | |
1627008 | 1627008 | 2022-09-22 | US | Puerto Rico | Aguada | 72003 | 11156 | 0 | 0 | 18.360255 | -67.175131 | 2022-09-23 04:23:13 | Aguada, Puerto Rico, US | |
1373212 | 1373212 | 2022-09-21 | US | Puerto Rico | Aguada | 72003 | 11154 | 0 | 0 | 18.360255 | -67.175131 | 2022-09-22 04:22:56 | Aguada, 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]);