johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
13,149 rows where confirmed = 4 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
These facets timed out: province_or_state
country_or_region >30
- US 11,379
- United Kingdom 783
- Marshall Islands 415
- Vanuatu 189
- Australia 68
- France 60
- Sao Tome and Principe 22
- Canada 21
- Lesotho 19
- Japan 17
- Gambia 13
- South Sudan 13
- Mainland China 12
- Senegal 9
- Congo (Brazzaville) 6
- Botswana 5
- New Zealand 5
- Solomon Islands 5
- Bhutan 4
- Cuba 4
- Denmark 4
- Eswatini 4
- Guinea 4
- Holy See 4
- South Korea 4
- United Arab Emirates 4
- Bulgaria 3
- Chile 3
- Georgia 3
- Germany 3
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756574 | 2756574 | 2022-12-29 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-12-30 04:21:04 | Pitcairn Islands, United Kingdom | |||
2755546 | 2755546 | 2022-12-29 | US | Oregon | Unassigned | 90041 | 4 | 0 | 0 | 45.99712889 | -124.15728200000001 | 2022-12-30 04:21:04 | Unassigned, Oregon, US | |
2754474 | 2754474 | 2022-12-29 | US | Maine | Unassigned | 90023 | 4 | 0 | 0 | 46.65926321 | 0.0 | 2022-12-30 04:21:04 | Unassigned, Maine, US | |
2753940 | 2753940 | 2022-12-29 | US | Illinois | Out of IL | 80017 | 4 | 0 | 0 | 42.36542373 | 0.0 | 2022-12-30 04:21:04 | Out of IL, Illinois, US | |
1077580 | 1077580 | 2022-12-28 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-12-29 04:21:01 | Pitcairn Islands, United Kingdom | |||
1076552 | 1076552 | 2022-12-28 | US | Oregon | Unassigned | 90041 | 4 | 0 | 0 | 45.99712889 | -124.15728200000001 | 2022-12-29 04:21:01 | Unassigned, Oregon, US | |
331577 | 331577 | 2022-12-27 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-12-28 04:21:04 | Pitcairn Islands, United Kingdom | |||
330549 | 330549 | 2022-12-27 | US | Oregon | Unassigned | 90041 | 4 | 0 | 0 | 45.99712889 | -124.15728200000001 | 2022-12-28 04:21:04 | Unassigned, Oregon, US | |
221650 | 221650 | 2022-12-26 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-12-27 04:21:07 | Pitcairn Islands, United Kingdom | |||
220622 | 220622 | 2022-12-26 | US | Oregon | Unassigned | 90041 | 4 | 0 | 0 | 45.99712889 | -124.15728200000001 | 2022-12-27 04:21:07 | Unassigned, Oregon, US | |
3226107 | 3226107 | 2022-12-25 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-12-26 04:21:06 | Pitcairn Islands, United Kingdom | |||
3225079 | 3225079 | 2022-12-25 | US | Oregon | Unassigned | 90041 | 4 | 0 | 0 | 45.99712889 | -124.15728200000001 | 2022-12-26 04:21:06 | Unassigned, Oregon, US | |
1022021 | 1022021 | 2022-12-24 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-12-25 04:21:04 | Pitcairn Islands, United Kingdom | |||
1020993 | 1020993 | 2022-12-24 | US | Oregon | Unassigned | 90041 | 4 | 0 | 0 | 45.99712889 | -124.15728200000001 | 2022-12-25 04:21:04 | Unassigned, Oregon, US | |
694044 | 694044 | 2022-12-23 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-12-24 04:21:02 | Pitcairn Islands, United Kingdom | |||
693016 | 693016 | 2022-12-23 | US | Oregon | Unassigned | 90041 | 4 | 0 | 0 | 45.99712889 | -124.15728200000001 | 2022-12-24 04:21:02 | Unassigned, Oregon, US | |
2183254 | 2183254 | 2022-12-22 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-12-23 04:21:04 | Pitcairn Islands, United Kingdom | |||
2182226 | 2182226 | 2022-12-22 | US | Oregon | Unassigned | 90041 | 4 | 0 | 0 | 45.99712889 | -124.15728200000001 | 2022-12-23 04:21:04 | Unassigned, Oregon, US | |
2180620 | 2180620 | 2022-12-22 | US | Illinois | Out of IL | 80017 | 4 | 0 | 0 | 42.36542373 | 0.0 | 2022-12-23 04:21:04 | Out of IL, Illinois, US | |
455058 | 455058 | 2022-12-21 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-12-22 04:20:56 | Pitcairn Islands, United Kingdom | |||
454030 | 454030 | 2022-12-21 | US | Oregon | Unassigned | 90041 | 4 | 0 | 0 | 45.99712889 | -124.15728200000001 | 2022-12-22 04:20:56 | Unassigned, Oregon, US | |
2955057 | 2955057 | 2022-12-20 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-12-21 04:21:03 | Pitcairn Islands, United Kingdom | |||
2954029 | 2954029 | 2022-12-20 | US | Oregon | Unassigned | 90041 | 4 | 0 | 0 | 45.99712889 | -124.15728200000001 | 2022-12-21 04:21:03 | Unassigned, Oregon, US | |
3177459 | 3177459 | 2022-12-19 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-12-20 04:21:04 | Pitcairn Islands, United Kingdom | |||
3176431 | 3176431 | 2022-12-19 | US | Oregon | Unassigned | 90041 | 4 | 0 | 0 | 45.99712889 | -124.15728200000001 | 2022-12-20 04:21:04 | Unassigned, Oregon, US | |
1631976 | 1631976 | 2022-12-18 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-12-19 04:21:03 | Pitcairn Islands, United Kingdom | |||
1630948 | 1630948 | 2022-12-18 | US | Oregon | Unassigned | 90041 | 4 | 0 | 0 | 45.99712889 | -124.15728200000001 | 2022-12-19 04:21:03 | Unassigned, Oregon, US | |
507355 | 507355 | 2022-12-17 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-12-18 04:21:03 | Pitcairn Islands, United Kingdom | |||
506327 | 506327 | 2022-12-17 | US | Oregon | Unassigned | 90041 | 4 | 0 | 0 | 45.99712889 | -124.15728200000001 | 2022-12-18 04:21:03 | Unassigned, Oregon, US | |
3327927 | 3327927 | 2022-12-16 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-12-17 04:21:04 | Pitcairn Islands, United Kingdom | |||
3326899 | 3326899 | 2022-12-16 | US | Oregon | Unassigned | 90041 | 4 | 0 | 0 | 45.99712889 | -124.15728200000001 | 2022-12-17 04:21:04 | Unassigned, Oregon, US | |
546439 | 546439 | 2022-12-15 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-12-16 04:21:01 | Pitcairn Islands, United Kingdom | |||
545411 | 545411 | 2022-12-15 | US | Oregon | Unassigned | 90041 | 4 | 0 | 0 | 45.99712889 | -124.15728200000001 | 2022-12-16 04:21:01 | Unassigned, Oregon, US | |
351967 | 351967 | 2022-12-14 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-12-15 04:20:58 | Pitcairn Islands, United Kingdom | |||
350939 | 350939 | 2022-12-14 | US | Oregon | Unassigned | 90041 | 4 | 0 | 0 | 45.99712889 | -124.15728200000001 | 2022-12-15 04:20:58 | Unassigned, Oregon, US | |
311555 | 311555 | 2022-12-13 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-12-14 04:21:04 | Pitcairn Islands, United Kingdom | |||
1152616 | 1152616 | 2022-12-12 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-12-13 04:21:01 | Pitcairn Islands, United Kingdom | |||
872470 | 872470 | 2022-12-11 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-12-12 04:21:01 | Pitcairn Islands, United Kingdom | |||
261000 | 261000 | 2022-12-10 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-12-11 04:20:50 | Pitcairn Islands, United Kingdom | |||
3939714 | 3939714 | 2022-12-09 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-12-10 04:21:02 | Pitcairn Islands, United Kingdom | |||
3381046 | 3381046 | 2022-12-08 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-12-09 04:21:05 | Pitcairn Islands, United Kingdom | |||
1988317 | 1988317 | 2022-12-07 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-12-08 04:21:07 | Pitcairn Islands, United Kingdom | |||
3717840 | 3717840 | 2022-12-06 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-12-07 04:20:58 | Pitcairn Islands, United Kingdom | |||
2418545 | 2418545 | 2022-12-05 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-12-06 04:21:03 | Pitcairn Islands, United Kingdom | |||
722153 | 722153 | 2022-12-04 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-12-05 04:20:58 | Pitcairn Islands, United Kingdom | |||
2820442 | 2820442 | 2022-12-03 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-12-04 04:20:56 | Pitcairn Islands, United Kingdom | |||
837298 | 837298 | 2022-12-02 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-12-03 04:21:02 | Pitcairn Islands, United Kingdom | |||
2139828 | 2139828 | 2022-12-01 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-12-02 04:21:07 | Pitcairn Islands, United Kingdom | |||
1968244 | 1968244 | 2022-11-30 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-12-01 04:21:03 | Pitcairn Islands, United Kingdom | |||
2560258 | 2560258 | 2022-11-29 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-30 04:21:07 | Pitcairn Islands, United Kingdom | |||
1243332 | 1243332 | 2022-11-28 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-29 04:21:05 | Pitcairn Islands, United Kingdom | |||
3555320 | 3555320 | 2022-11-27 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-28 04:21:02 | Pitcairn Islands, United Kingdom | |||
2103800 | 2103800 | 2022-11-26 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-27 04:21:05 | Pitcairn Islands, United Kingdom | |||
491291 | 491291 | 2022-11-25 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-26 04:21:11 | Pitcairn Islands, United Kingdom | |||
3527120 | 3527120 | 2022-11-24 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-25 04:21:06 | Pitcairn Islands, United Kingdom | |||
3315903 | 3315903 | 2022-11-23 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-24 04:21:09 | Pitcairn Islands, United Kingdom | |||
1623944 | 1623944 | 2022-11-22 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-23 04:21:06 | Pitcairn Islands, United Kingdom | |||
3463832 | 3463832 | 2022-11-21 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-22 04:20:47 | Pitcairn Islands, United Kingdom | |||
1644017 | 1644017 | 2022-11-20 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-21 04:21:05 | Pitcairn Islands, United Kingdom | |||
2067574 | 2067574 | 2022-11-19 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-20 04:21:08 | Pitcairn Islands, United Kingdom | |||
1758968 | 1758968 | 2022-11-18 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-19 04:21:14 | Pitcairn Islands, United Kingdom | |||
3029961 | 3029961 | 2022-11-17 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-18 04:21:15 | Pitcairn Islands, United Kingdom | |||
2489672 | 2489672 | 2022-11-16 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-17 04:21:11 | Pitcairn Islands, United Kingdom | |||
295683 | 295683 | 2022-11-15 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-16 04:21:09 | Pitcairn Islands, United Kingdom | |||
3600713 | 3600713 | 2022-11-14 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-15 04:21:16 | Pitcairn Islands, United Kingdom | |||
3598079 | 3598079 | 2022-11-14 | US | Illinois | Out of IL | 80017 | 4 | 0 | 0 | 42.36542373 | 0.0 | 2022-11-15 04:21:16 | Out of IL, Illinois, US | |
315571 | 315571 | 2022-11-13 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-14 04:21:09 | Pitcairn Islands, United Kingdom | |||
312937 | 312937 | 2022-11-13 | US | Illinois | Out of IL | 80017 | 4 | 0 | 0 | 42.36542373 | 0.0 | 2022-11-14 04:21:09 | Out of IL, Illinois, US | |
66732 | 66732 | 2022-11-12 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-13 04:21:14 | Pitcairn Islands, United Kingdom | |||
64098 | 64098 | 2022-11-12 | US | Illinois | Out of IL | 80017 | 4 | 0 | 0 | 42.36542373 | 0.0 | 2022-11-13 04:21:14 | Out of IL, Illinois, US | |
2930894 | 2930894 | 2022-11-11 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-12 04:20:41 | Pitcairn Islands, United Kingdom | |||
2509730 | 2509730 | 2022-11-10 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-11 04:21:22 | Pitcairn Islands, United Kingdom | |||
2434605 | 2434605 | 2022-11-09 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-10 04:21:16 | Pitcairn Islands, United Kingdom | |||
483261 | 483261 | 2022-11-08 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-09 04:21:22 | Pitcairn Islands, United Kingdom | |||
2442411 | 2442411 | 2022-11-07 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-08 04:21:21 | Pitcairn Islands, United Kingdom | |||
1053509 | 1053509 | 2022-11-06 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-07 04:21:26 | Pitcairn Islands, United Kingdom | |||
1050875 | 1050875 | 2022-11-06 | US | Illinois | Out of IL | 80017 | 4 | 0 | 0 | 42.36542373 | 0.0 | 2022-11-07 04:21:26 | Out of IL, Illinois, US | |
621533 | 621533 | 2022-11-05 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-06 04:21:24 | Pitcairn Islands, United Kingdom | |||
618899 | 618899 | 2022-11-05 | US | Illinois | Out of IL | 80017 | 4 | 0 | 0 | 42.36542373 | 0.0 | 2022-11-06 04:21:24 | Out of IL, Illinois, US | |
1026037 | 1026037 | 2022-11-04 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-05 04:21:52 | Pitcairn Islands, United Kingdom | |||
1023937 | 1023937 | 2022-11-04 | US | Maine | Unassigned | 90023 | 4 | 0 | 0 | 46.65926321 | 0.0 | 2022-11-05 04:21:52 | Unassigned, Maine, US | |
1023403 | 1023403 | 2022-11-04 | US | Illinois | Out of IL | 80017 | 4 | 0 | 0 | 42.36542373 | 0.0 | 2022-11-05 04:21:52 | Out of IL, Illinois, US | |
435028 | 435028 | 2022-11-03 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-04 04:22:11 | Pitcairn Islands, United Kingdom | |||
853270 | 853270 | 2022-11-02 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-03 04:22:05 | Pitcairn Islands, United Kingdom | |||
714121 | 714121 | 2022-11-01 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-02 04:22:09 | Pitcairn Islands, United Kingdom | |||
3288570 | 3288570 | 2022-10-31 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-01 04:22:36 | Pitcairn Islands, United Kingdom | |||
3285936 | 3285936 | 2022-10-31 | US | Illinois | Out of IL | 80017 | 4 | 0 | 0 | 42.36542373 | 0.0 | 2022-11-01 04:22:36 | Out of IL, Illinois, US | |
323603 | 323603 | 2022-10-30 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-10-31 04:21:36 | Pitcairn Islands, United Kingdom | |||
915879 | 915879 | 2022-10-29 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-10-30 04:22:14 | Pitcairn Islands, United Kingdom | |||
1370148 | 1370148 | 2022-10-28 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-10-29 04:21:13 | Pitcairn Islands, United Kingdom | |||
1368048 | 1368048 | 2022-10-28 | US | Maine | Unassigned | 90023 | 4 | 0 | 0 | 46.65926321 | 0.0 | 2022-10-29 04:21:13 | Unassigned, Maine, US | |
3042003 | 3042003 | 2022-10-27 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-10-28 04:22:31 | Pitcairn Islands, United Kingdom | |||
542423 | 542423 | 2022-10-26 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-10-27 04:22:01 | Pitcairn Islands, United Kingdom | |||
1833824 | 1833824 | 2022-10-25 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-10-26 04:22:19 | Pitcairn Islands, United Kingdom | |||
798085 | 798085 | 2022-10-24 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-10-25 04:21:53 | Pitcairn Islands, United Kingdom | |||
3280540 | 3280540 | 2022-10-23 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-10-24 04:22:29 | Pitcairn Islands, United Kingdom | |||
2271578 | 2271578 | 2022-10-22 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-10-23 04:22:46 | Pitcairn Islands, United Kingdom | |||
1595878 | 1595878 | 2022-10-21 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-10-22 04:22:53 | Pitcairn Islands, United Kingdom | |||
2275594 | 2275594 | 2022-10-20 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-10-21 04:22:23 | Pitcairn Islands, United Kingdom | |||
201929 | 201929 | 2022-10-19 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-10-20 04:22:59 | Pitcairn Islands, United Kingdom |
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]);