johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
895 rows where combined_key = "Anasco, Puerto Rico, US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
province_or_state 1
- Puerto Rico 895
country_or_region 1
- US 895
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755626 | 2755626 | 2022-12-29 | US | Puerto Rico | Anasco | 72011 | 7875 | 0 | 0 | 18.287985 | -67.120611 | 2022-12-30 04:21:04 | Anasco, Puerto Rico, US | |
1076632 | 1076632 | 2022-12-28 | US | Puerto Rico | Anasco | 72011 | 7857 | 0 | 0 | 18.287985 | -67.120611 | 2022-12-29 04:21:01 | Anasco, Puerto Rico, US | |
330629 | 330629 | 2022-12-27 | US | Puerto Rico | Anasco | 72011 | 7850 | 0 | 0 | 18.287985 | -67.120611 | 2022-12-28 04:21:04 | Anasco, Puerto Rico, US | |
220702 | 220702 | 2022-12-26 | US | Puerto Rico | Anasco | 72011 | 7827 | 0 | 0 | 18.287985 | -67.120611 | 2022-12-27 04:21:07 | Anasco, Puerto Rico, US | |
3225159 | 3225159 | 2022-12-25 | US | Puerto Rico | Anasco | 72011 | 7827 | 0 | 0 | 18.287985 | -67.120611 | 2022-12-26 04:21:06 | Anasco, Puerto Rico, US | |
1021073 | 1021073 | 2022-12-24 | US | Puerto Rico | Anasco | 72011 | 7827 | 0 | 0 | 18.287985 | -67.120611 | 2022-12-25 04:21:04 | Anasco, Puerto Rico, US | |
693096 | 693096 | 2022-12-23 | US | Puerto Rico | Anasco | 72011 | 7813 | 0 | 0 | 18.287985 | -67.120611 | 2022-12-24 04:21:02 | Anasco, Puerto Rico, US | |
2182306 | 2182306 | 2022-12-22 | US | Puerto Rico | Anasco | 72011 | 7807 | 0 | 0 | 18.287985 | -67.120611 | 2022-12-23 04:21:04 | Anasco, Puerto Rico, US | |
454110 | 454110 | 2022-12-21 | US | Puerto Rico | Anasco | 72011 | 7785 | 0 | 0 | 18.287985 | -67.120611 | 2022-12-22 04:20:56 | Anasco, Puerto Rico, US | |
2954109 | 2954109 | 2022-12-20 | US | Puerto Rico | Anasco | 72011 | 7779 | 0 | 0 | 18.287985 | -67.120611 | 2022-12-21 04:21:03 | Anasco, Puerto Rico, US | |
3176511 | 3176511 | 2022-12-19 | US | Puerto Rico | Anasco | 72011 | 7779 | 0 | 0 | 18.287985 | -67.120611 | 2022-12-20 04:21:04 | Anasco, Puerto Rico, US | |
1631028 | 1631028 | 2022-12-18 | US | Puerto Rico | Anasco | 72011 | 7772 | 0 | 0 | 18.287985 | -67.120611 | 2022-12-19 04:21:03 | Anasco, Puerto Rico, US | |
506407 | 506407 | 2022-12-17 | US | Puerto Rico | Anasco | 72011 | 7758 | 0 | 0 | 18.287985 | -67.120611 | 2022-12-18 04:21:03 | Anasco, Puerto Rico, US | |
3326979 | 3326979 | 2022-12-16 | US | Puerto Rico | Anasco | 72011 | 7745 | 0 | 0 | 18.287985 | -67.120611 | 2022-12-17 04:21:04 | Anasco, Puerto Rico, US | |
545491 | 545491 | 2022-12-15 | US | Puerto Rico | Anasco | 72011 | 7729 | 0 | 0 | 18.287985 | -67.120611 | 2022-12-16 04:21:01 | Anasco, Puerto Rico, US | |
351019 | 351019 | 2022-12-14 | US | Puerto Rico | Anasco | 72011 | 7716 | 0 | 0 | 18.287985 | -67.120611 | 2022-12-15 04:20:58 | Anasco, Puerto Rico, US | |
310607 | 310607 | 2022-12-13 | US | Puerto Rico | Anasco | 72011 | 7697 | 0 | 0 | 18.287985 | -67.120611 | 2022-12-14 04:21:04 | Anasco, Puerto Rico, US | |
1151668 | 1151668 | 2022-12-12 | US | Puerto Rico | Anasco | 72011 | 7697 | 0 | 0 | 18.287985 | -67.120611 | 2022-12-13 04:21:01 | Anasco, Puerto Rico, US | |
871522 | 871522 | 2022-12-11 | US | Puerto Rico | Anasco | 72011 | 7690 | 0 | 0 | 18.287985 | -67.120611 | 2022-12-12 04:21:01 | Anasco, Puerto Rico, US | |
260052 | 260052 | 2022-12-10 | US | Puerto Rico | Anasco | 72011 | 7685 | 0 | 0 | 18.287985 | -67.120611 | 2022-12-11 04:20:50 | Anasco, Puerto Rico, US | |
3938766 | 3938766 | 2022-12-09 | US | Puerto Rico | Anasco | 72011 | 7675 | 0 | 0 | 18.287985 | -67.120611 | 2022-12-10 04:21:02 | Anasco, Puerto Rico, US | |
3380098 | 3380098 | 2022-12-08 | US | Puerto Rico | Anasco | 72011 | 7646 | 0 | 0 | 18.287985 | -67.120611 | 2022-12-09 04:21:05 | Anasco, Puerto Rico, US | |
1987369 | 1987369 | 2022-12-07 | US | Puerto Rico | Anasco | 72011 | 7628 | 0 | 0 | 18.287985 | -67.120611 | 2022-12-08 04:21:07 | Anasco, Puerto Rico, US | |
3716892 | 3716892 | 2022-12-06 | US | Puerto Rico | Anasco | 72011 | 7614 | 0 | 0 | 18.287985 | -67.120611 | 2022-12-07 04:20:58 | Anasco, Puerto Rico, US | |
2417597 | 2417597 | 2022-12-05 | US | Puerto Rico | Anasco | 72011 | 7613 | 0 | 0 | 18.287985 | -67.120611 | 2022-12-06 04:21:03 | Anasco, Puerto Rico, US | |
721205 | 721205 | 2022-12-04 | US | Puerto Rico | Anasco | 72011 | 7607 | 0 | 0 | 18.287985 | -67.120611 | 2022-12-05 04:20:58 | Anasco, Puerto Rico, US | |
2819494 | 2819494 | 2022-12-03 | US | Puerto Rico | Anasco | 72011 | 7600 | 0 | 0 | 18.287985 | -67.120611 | 2022-12-04 04:20:56 | Anasco, Puerto Rico, US | |
836350 | 836350 | 2022-12-02 | US | Puerto Rico | Anasco | 72011 | 7594 | 0 | 0 | 18.287985 | -67.120611 | 2022-12-03 04:21:02 | Anasco, Puerto Rico, US | |
2138880 | 2138880 | 2022-12-01 | US | Puerto Rico | Anasco | 72011 | 7571 | 0 | 0 | 18.287985 | -67.120611 | 2022-12-02 04:21:07 | Anasco, Puerto Rico, US | |
1967296 | 1967296 | 2022-11-30 | US | Puerto Rico | Anasco | 72011 | 7571 | 0 | 0 | 18.287985 | -67.120611 | 2022-12-01 04:21:03 | Anasco, Puerto Rico, US | |
2559310 | 2559310 | 2022-11-29 | US | Puerto Rico | Anasco | 72011 | 7558 | 0 | 0 | 18.287985 | -67.120611 | 2022-11-30 04:21:07 | Anasco, Puerto Rico, US | |
1242384 | 1242384 | 2022-11-28 | US | Puerto Rico | Anasco | 72011 | 7554 | 0 | 0 | 18.287985 | -67.120611 | 2022-11-29 04:21:05 | Anasco, Puerto Rico, US | |
3554372 | 3554372 | 2022-11-27 | US | Puerto Rico | Anasco | 72011 | 7554 | 0 | 0 | 18.287985 | -67.120611 | 2022-11-28 04:21:02 | Anasco, Puerto Rico, US | |
2102852 | 2102852 | 2022-11-26 | US | Puerto Rico | Anasco | 72011 | 7547 | 0 | 0 | 18.287985 | -67.120611 | 2022-11-27 04:21:05 | Anasco, Puerto Rico, US | |
490343 | 490343 | 2022-11-25 | US | Puerto Rico | Anasco | 72011 | 7547 | 0 | 0 | 18.287985 | -67.120611 | 2022-11-26 04:21:11 | Anasco, Puerto Rico, US | |
3526172 | 3526172 | 2022-11-24 | US | Puerto Rico | Anasco | 72011 | 7547 | 0 | 0 | 18.287985 | -67.120611 | 2022-11-25 04:21:06 | Anasco, Puerto Rico, US | |
3314955 | 3314955 | 2022-11-23 | US | Puerto Rico | Anasco | 72011 | 7538 | 0 | 0 | 18.287985 | -67.120611 | 2022-11-24 04:21:09 | Anasco, Puerto Rico, US | |
1622996 | 1622996 | 2022-11-22 | US | Puerto Rico | Anasco | 72011 | 7523 | 0 | 0 | 18.287985 | -67.120611 | 2022-11-23 04:21:06 | Anasco, Puerto Rico, US | |
3462884 | 3462884 | 2022-11-21 | US | Puerto Rico | Anasco | 72011 | 7518 | 0 | 0 | 18.287985 | -67.120611 | 2022-11-22 04:20:47 | Anasco, Puerto Rico, US | |
1643069 | 1643069 | 2022-11-20 | US | Puerto Rico | Anasco | 72011 | 7518 | 0 | 0 | 18.287985 | -67.120611 | 2022-11-21 04:21:05 | Anasco, Puerto Rico, US | |
2066626 | 2066626 | 2022-11-19 | US | Puerto Rico | Anasco | 72011 | 7510 | 0 | 0 | 18.287985 | -67.120611 | 2022-11-20 04:21:08 | Anasco, Puerto Rico, US | |
1758020 | 1758020 | 2022-11-18 | US | Puerto Rico | Anasco | 72011 | 7498 | 0 | 0 | 18.287985 | -67.120611 | 2022-11-19 04:21:14 | Anasco, Puerto Rico, US | |
3029013 | 3029013 | 2022-11-17 | US | Puerto Rico | Anasco | 72011 | 7473 | 0 | 0 | 18.287985 | -67.120611 | 2022-11-18 04:21:15 | Anasco, Puerto Rico, US | |
2488724 | 2488724 | 2022-11-16 | US | Puerto Rico | Anasco | 72011 | 7473 | 0 | 0 | 18.287985 | -67.120611 | 2022-11-17 04:21:11 | Anasco, Puerto Rico, US | |
294735 | 294735 | 2022-11-15 | US | Puerto Rico | Anasco | 72011 | 7451 | 0 | 0 | 18.287985 | -67.120611 | 2022-11-16 04:21:09 | Anasco, Puerto Rico, US | |
3599765 | 3599765 | 2022-11-14 | US | Puerto Rico | Anasco | 72011 | 7451 | 0 | 0 | 18.287985 | -67.120611 | 2022-11-15 04:21:16 | Anasco, Puerto Rico, US | |
314623 | 314623 | 2022-11-13 | US | Puerto Rico | Anasco | 72011 | 7444 | 0 | 0 | 18.287985 | -67.120611 | 2022-11-14 04:21:09 | Anasco, Puerto Rico, US | |
65784 | 65784 | 2022-11-12 | US | Puerto Rico | Anasco | 72011 | 7444 | 0 | 0 | 18.287985 | -67.120611 | 2022-11-13 04:21:14 | Anasco, Puerto Rico, US | |
2929946 | 2929946 | 2022-11-11 | US | Puerto Rico | Anasco | 72011 | 7432 | 0 | 0 | 18.287985 | -67.120611 | 2022-11-12 04:20:41 | Anasco, Puerto Rico, US | |
2508782 | 2508782 | 2022-11-10 | US | Puerto Rico | Anasco | 72011 | 7422 | 0 | 0 | 18.287985 | -67.120611 | 2022-11-11 04:21:22 | Anasco, Puerto Rico, US | |
2433657 | 2433657 | 2022-11-09 | US | Puerto Rico | Anasco | 72011 | 7402 | 0 | 0 | 18.287985 | -67.120611 | 2022-11-10 04:21:16 | Anasco, Puerto Rico, US | |
482313 | 482313 | 2022-11-08 | US | Puerto Rico | Anasco | 72011 | 7394 | 0 | 0 | 18.287985 | -67.120611 | 2022-11-09 04:21:22 | Anasco, Puerto Rico, US | |
2441463 | 2441463 | 2022-11-07 | US | Puerto Rico | Anasco | 72011 | 7394 | 0 | 0 | 18.287985 | -67.120611 | 2022-11-08 04:21:21 | Anasco, Puerto Rico, US | |
1052561 | 1052561 | 2022-11-06 | US | Puerto Rico | Anasco | 72011 | 7388 | 0 | 0 | 18.287985 | -67.120611 | 2022-11-07 04:21:26 | Anasco, Puerto Rico, US | |
620585 | 620585 | 2022-11-05 | US | Puerto Rico | Anasco | 72011 | 7383 | 0 | 0 | 18.287985 | -67.120611 | 2022-11-06 04:21:24 | Anasco, Puerto Rico, US | |
1025089 | 1025089 | 2022-11-04 | US | Puerto Rico | Anasco | 72011 | 7379 | 0 | 0 | 18.287985 | -67.120611 | 2022-11-05 04:21:52 | Anasco, Puerto Rico, US | |
434080 | 434080 | 2022-11-03 | US | Puerto Rico | Anasco | 72011 | 7371 | 0 | 0 | 18.287985 | -67.120611 | 2022-11-04 04:22:11 | Anasco, Puerto Rico, US | |
852322 | 852322 | 2022-11-02 | US | Puerto Rico | Anasco | 72011 | 7355 | 0 | 0 | 18.287985 | -67.120611 | 2022-11-03 04:22:05 | Anasco, Puerto Rico, US | |
713173 | 713173 | 2022-11-01 | US | Puerto Rico | Anasco | 72011 | 7349 | 0 | 0 | 18.287985 | -67.120611 | 2022-11-02 04:22:09 | Anasco, Puerto Rico, US | |
3287622 | 3287622 | 2022-10-31 | US | Puerto Rico | Anasco | 72011 | 7349 | 0 | 0 | 18.287985 | -67.120611 | 2022-11-01 04:22:36 | Anasco, Puerto Rico, US | |
322655 | 322655 | 2022-10-30 | US | Puerto Rico | Anasco | 72011 | 7343 | 0 | 0 | 18.287985 | -67.120611 | 2022-10-31 04:21:36 | Anasco, Puerto Rico, US | |
914931 | 914931 | 2022-10-29 | US | Puerto Rico | Anasco | 72011 | 7340 | 0 | 0 | 18.287985 | -67.120611 | 2022-10-30 04:22:14 | Anasco, Puerto Rico, US | |
1369200 | 1369200 | 2022-10-28 | US | Puerto Rico | Anasco | 72011 | 7335 | 0 | 0 | 18.287985 | -67.120611 | 2022-10-29 04:21:13 | Anasco, Puerto Rico, US | |
3041055 | 3041055 | 2022-10-27 | US | Puerto Rico | Anasco | 72011 | 7316 | 0 | 0 | 18.287985 | -67.120611 | 2022-10-28 04:22:31 | Anasco, Puerto Rico, US | |
541475 | 541475 | 2022-10-26 | US | Puerto Rico | Anasco | 72011 | 7308 | 0 | 0 | 18.287985 | -67.120611 | 2022-10-27 04:22:01 | Anasco, Puerto Rico, US | |
1832876 | 1832876 | 2022-10-25 | US | Puerto Rico | Anasco | 72011 | 7296 | 0 | 0 | 18.287985 | -67.120611 | 2022-10-26 04:22:19 | Anasco, Puerto Rico, US | |
797137 | 797137 | 2022-10-24 | US | Puerto Rico | Anasco | 72011 | 7291 | 0 | 0 | 18.287985 | -67.120611 | 2022-10-25 04:21:53 | Anasco, Puerto Rico, US | |
3279592 | 3279592 | 2022-10-23 | US | Puerto Rico | Anasco | 72011 | 7291 | 0 | 0 | 18.287985 | -67.120611 | 2022-10-24 04:22:29 | Anasco, Puerto Rico, US | |
2270630 | 2270630 | 2022-10-22 | US | Puerto Rico | Anasco | 72011 | 7244 | 0 | 0 | 18.287985 | -67.120611 | 2022-10-23 04:22:46 | Anasco, Puerto Rico, US | |
1594930 | 1594930 | 2022-10-21 | US | Puerto Rico | Anasco | 72011 | 7244 | 0 | 0 | 18.287985 | -67.120611 | 2022-10-22 04:22:53 | Anasco, Puerto Rico, US | |
2274646 | 2274646 | 2022-10-20 | US | Puerto Rico | Anasco | 72011 | 7244 | 0 | 0 | 18.287985 | -67.120611 | 2022-10-21 04:22:23 | Anasco, Puerto Rico, US | |
200981 | 200981 | 2022-10-19 | US | Puerto Rico | Anasco | 72011 | 7244 | 0 | 0 | 18.287985 | -67.120611 | 2022-10-20 04:22:59 | Anasco, Puerto Rico, US | |
2759642 | 2759642 | 2022-10-18 | US | Puerto Rico | Anasco | 72011 | 7216 | 0 | 0 | 18.287985 | -67.120611 | 2022-10-19 04:22:26 | Anasco, Puerto Rico, US | |
2027476 | 2027476 | 2022-10-17 | US | Puerto Rico | Anasco | 72011 | 7216 | 0 | 0 | 18.287985 | -67.120611 | 2022-10-18 04:22:42 | Anasco, Puerto Rico, US | |
2162254 | 2162254 | 2022-10-16 | US | Puerto Rico | Anasco | 72011 | 7212 | 0 | 0 | 18.287985 | -67.120611 | 2022-10-17 04:20:31 | Anasco, Puerto Rico, US | |
518451 | 518451 | 2022-10-15 | US | Puerto Rico | Anasco | 72011 | 7189 | 0 | 0 | 18.287985 | -67.120611 | 2022-10-16 04:22:39 | Anasco, Puerto Rico, US | |
2035508 | 2035508 | 2022-10-14 | US | Puerto Rico | Anasco | 72011 | 7189 | 0 | 0 | 18.287985 | -67.120611 | 2022-10-15 04:22:00 | Anasco, Puerto Rico, US | |
3756196 | 3756196 | 2022-10-13 | US | Puerto Rico | Anasco | 72011 | 7173 | 0 | 0 | 18.287985 | -67.120611 | 2022-10-14 04:22:28 | Anasco, Puerto Rico, US | |
3217021 | 3217021 | 2022-10-12 | US | Puerto Rico | Anasco | 72011 | 7165 | 0 | 0 | 18.287985 | -67.120611 | 2022-10-13 04:22:39 | Anasco, Puerto Rico, US | |
3252870 | 3252870 | 2022-10-11 | US | Puerto Rico | Anasco | 72011 | 7158 | 0 | 0 | 18.287985 | -67.120611 | 2022-10-12 04:22:51 | Anasco, Puerto Rico, US | |
2970129 | 2970129 | 2022-10-10 | US | Puerto Rico | Anasco | 72011 | 7154 | 0 | 0 | 18.287985 | -67.120611 | 2022-10-11 04:23:05 | Anasco, Puerto Rico, US | |
3100165 | 3100165 | 2022-10-09 | US | Puerto Rico | Anasco | 72011 | 7147 | 0 | 0 | 18.287985 | -67.120611 | 2022-10-10 04:22:32 | Anasco, Puerto Rico, US | |
4005390 | 4005390 | 2022-10-08 | US | Puerto Rico | Anasco | 72011 | 7134 | 0 | 0 | 18.287985 | -67.120611 | 2022-10-09 04:21:16 | Anasco, Puerto Rico, US | |
398987 | 398987 | 2022-10-07 | US | Puerto Rico | Anasco | 72011 | 7130 | 0 | 0 | 18.287985 | -67.120611 | 2022-10-08 04:22:56 | Anasco, Puerto Rico, US | |
2532104 | 2532104 | 2022-10-06 | US | Puerto Rico | Anasco | 72011 | 7123 | 0 | 0 | 18.287985 | -67.120611 | 2022-10-07 04:23:08 | Anasco, Puerto Rico, US | |
1813498 | 1813498 | 2022-10-05 | US | Puerto Rico | Anasco | 72011 | 7108 | 0 | 0 | 18.287985 | -67.120611 | 2022-10-06 04:21:22 | Anasco, Puerto Rico, US | |
133472 | 133472 | 2022-10-04 | US | Puerto Rico | Anasco | 72011 | 7098 | 0 | 0 | 18.287985 | -67.120611 | 2022-10-05 04:23:06 | Anasco, Puerto Rico, US | |
2688419 | 2688419 | 2022-10-03 | US | Puerto Rico | Anasco | 72011 | 7097 | 0 | 0 | 18.287985 | -67.120611 | 2022-10-04 04:22:55 | Anasco, Puerto Rico, US | |
2262486 | 2262486 | 2022-10-02 | US | Puerto Rico | Anasco | 72011 | 7089 | 0 | 0 | 18.287985 | -67.120611 | 2022-10-03 04:23:11 | Anasco, Puerto Rico, US | |
2998012 | 2998012 | 2022-10-01 | US | Puerto Rico | Anasco | 72011 | 7083 | 0 | 0 | 18.287985 | -67.120611 | 2022-10-02 04:21:23 | Anasco, Puerto Rico, US | |
856338 | 856338 | 2022-09-30 | US | Puerto Rico | Anasco | 72011 | 7079 | 0 | 0 | 18.287985 | -67.120611 | 2022-10-01 04:23:01 | Anasco, Puerto Rico, US | |
2378264 | 2378264 | 2022-09-29 | US | Puerto Rico | Anasco | 72011 | 7070 | 0 | 0 | 18.287985 | -67.120611 | 2022-09-30 04:23:09 | Anasco, Puerto Rico, US | |
1562815 | 1562815 | 2022-09-28 | US | Puerto Rico | Anasco | 72011 | 7035 | 0 | 0 | 18.287985 | -67.120611 | 2022-09-29 04:22:34 | Anasco, Puerto Rico, US | |
3997358 | 3997358 | 2022-09-27 | US | Puerto Rico | Anasco | 72011 | 7033 | 0 | 0 | 18.287985 | -67.120611 | 2022-09-28 04:23:01 | Anasco, Puerto Rico, US | |
2771686 | 2771686 | 2022-09-26 | US | Puerto Rico | Anasco | 72011 | 7033 | 0 | 0 | 18.287985 | -67.120611 | 2022-09-27 04:23:01 | Anasco, Puerto Rico, US | |
1979339 | 1979339 | 2022-09-25 | US | Puerto Rico | Anasco | 72011 | 7028 | 0 | 0 | 18.287985 | -67.120611 | 2022-09-26 04:20:52 | Anasco, Puerto Rico, US | |
2652506 | 2652506 | 2022-09-24 | US | Puerto Rico | Anasco | 72011 | 7010 | 0 | 0 | 18.287985 | -67.120611 | 2022-09-25 04:23:31 | Anasco, Puerto Rico, US | |
386946 | 386946 | 2022-09-23 | US | Puerto Rico | Anasco | 72011 | 7002 | 0 | 0 | 18.287985 | -67.120611 | 2022-09-24 04:21:40 | Anasco, Puerto Rico, US | |
1627012 | 1627012 | 2022-09-22 | US | Puerto Rico | Anasco | 72011 | 7001 | 0 | 0 | 18.287985 | -67.120611 | 2022-09-23 04:23:13 | Anasco, Puerto Rico, US | |
1373216 | 1373216 | 2022-09-21 | US | Puerto Rico | Anasco | 72011 | 6998 | 0 | 0 | 18.287985 | -67.120611 | 2022-09-22 04:22:56 | Anasco, 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]);