johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
995 rows where deaths = 379 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 849
- Russia 21
- Sweden 16
- Japan 13
- Chile 10
- India 9
- Italy 9
- Burkina Faso 8
- Ukraine 8
- France 7
- Barbados 5
- Netherlands 5
- Peru 5
- Guinea 4
- Brazil 2
- Colombia 2
- Mexico 2
- United Arab Emirates 2
- Angola 1
- Bahrain 1
- Bosnia and Herzegovina 1
- Canada 1
- Czechia 1
- El Salvador 1
- Germany 1
- Greece 1
- Kuwait 1
- Mali 1
- Nepal 1
- Pakistan 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755555 | 2755555 | 2022-12-29 | US | Pennsylvania | Armstrong | 42005 | 17936 | 379 | 0 | 40.81665618 | -79.46290811 | 2022-12-30 04:21:04 | Armstrong, Pennsylvania, US | |
1076561 | 1076561 | 2022-12-28 | US | Pennsylvania | Armstrong | 42005 | 17936 | 379 | 0 | 40.81665618 | -79.46290811 | 2022-12-29 04:21:01 | Armstrong, Pennsylvania, US | |
331135 | 331135 | 2022-12-27 | US | Texas | Starr | 48427 | 23543 | 379 | 0 | 26.56150059 | -98.73892358 | 2022-12-28 04:21:04 | Starr, Texas, US | |
221208 | 221208 | 2022-12-26 | US | Texas | Starr | 48427 | 23543 | 379 | 0 | 26.56150059 | -98.73892358 | 2022-12-27 04:21:07 | Starr, Texas, US | |
3225665 | 3225665 | 2022-12-25 | US | Texas | Starr | 48427 | 23543 | 379 | 0 | 26.56150059 | -98.73892358 | 2022-12-26 04:21:06 | Starr, Texas, US | |
1021579 | 1021579 | 2022-12-24 | US | Texas | Starr | 48427 | 23543 | 379 | 0 | 26.56150059 | -98.73892358 | 2022-12-25 04:21:04 | Starr, Texas, US | |
693602 | 693602 | 2022-12-23 | US | Texas | Starr | 48427 | 23543 | 379 | 0 | 26.56150059 | -98.73892358 | 2022-12-24 04:21:02 | Starr, Texas, US | |
2182812 | 2182812 | 2022-12-22 | US | Texas | Starr | 48427 | 23543 | 379 | 0 | 26.56150059 | -98.73892358 | 2022-12-23 04:21:04 | Starr, Texas, US | |
454616 | 454616 | 2022-12-21 | US | Texas | Starr | 48427 | 23543 | 379 | 0 | 26.56150059 | -98.73892358 | 2022-12-22 04:20:56 | Starr, Texas, US | |
2954615 | 2954615 | 2022-12-20 | US | Texas | Starr | 48427 | 23474 | 379 | 0 | 26.56150059 | -98.73892358 | 2022-12-21 04:21:03 | Starr, Texas, US | |
3177017 | 3177017 | 2022-12-19 | US | Texas | Starr | 48427 | 23474 | 379 | 0 | 26.56150059 | -98.73892358 | 2022-12-20 04:21:04 | Starr, Texas, US | |
1631534 | 1631534 | 2022-12-18 | US | Texas | Starr | 48427 | 23474 | 379 | 0 | 26.56150059 | -98.73892358 | 2022-12-19 04:21:03 | Starr, Texas, US | |
506913 | 506913 | 2022-12-17 | US | Texas | Starr | 48427 | 23474 | 379 | 0 | 26.56150059 | -98.73892358 | 2022-12-18 04:21:03 | Starr, Texas, US | |
3327485 | 3327485 | 2022-12-16 | US | Texas | Starr | 48427 | 23474 | 379 | 0 | 26.56150059 | -98.73892358 | 2022-12-17 04:21:04 | Starr, Texas, US | |
545997 | 545997 | 2022-12-15 | US | Texas | Starr | 48427 | 23474 | 379 | 0 | 26.56150059 | -98.73892358 | 2022-12-16 04:21:01 | Starr, Texas, US | |
351525 | 351525 | 2022-12-14 | US | Texas | Starr | 48427 | 23474 | 379 | 0 | 26.56150059 | -98.73892358 | 2022-12-15 04:20:58 | Starr, Texas, US | |
307876 | 307876 | 2022-12-13 | Japan | Fukushima | 298953 | 379 | 0 | 37.378867 | 140.223295 | 2022-12-14 04:21:04 | Fukushima, Japan | |||
3717088 | 3717088 | 2022-12-06 | US | Tennessee | Anderson | 47001 | 26623 | 379 | 0 | 36.12684348 | -84.19965764 | 2022-12-07 04:20:58 | Anderson, Tennessee, US | |
3716832 | 3716832 | 2022-12-06 | US | Pennsylvania | Centre | 42027 | 42369 | 379 | 0 | 40.92058903 | -77.82200624 | 2022-12-07 04:20:58 | Centre, Pennsylvania, US | |
2417793 | 2417793 | 2022-12-05 | US | Tennessee | Anderson | 47001 | 26610 | 379 | 0 | 36.12684348 | -84.19965764 | 2022-12-06 04:21:03 | Anderson, Tennessee, US | |
2417537 | 2417537 | 2022-12-05 | US | Pennsylvania | Centre | 42027 | 42369 | 379 | 0 | 40.92058903 | -77.82200624 | 2022-12-06 04:21:03 | Centre, Pennsylvania, US | |
721401 | 721401 | 2022-12-04 | US | Tennessee | Anderson | 47001 | 26596 | 379 | 0 | 36.12684348 | -84.19965764 | 2022-12-05 04:20:58 | Anderson, Tennessee, US | |
721145 | 721145 | 2022-12-04 | US | Pennsylvania | Centre | 42027 | 42369 | 379 | 0 | 40.92058903 | -77.82200624 | 2022-12-05 04:20:58 | Centre, Pennsylvania, US | |
2819690 | 2819690 | 2022-12-03 | US | Tennessee | Anderson | 47001 | 26593 | 379 | 0 | 36.12684348 | -84.19965764 | 2022-12-04 04:20:56 | Anderson, Tennessee, US | |
2819434 | 2819434 | 2022-12-03 | US | Pennsylvania | Centre | 42027 | 42369 | 379 | 0 | 40.92058903 | -77.82200624 | 2022-12-04 04:20:56 | Centre, Pennsylvania, US | |
836546 | 836546 | 2022-12-02 | US | Tennessee | Anderson | 47001 | 26585 | 379 | 0 | 36.12684348 | -84.19965764 | 2022-12-03 04:21:02 | Anderson, Tennessee, US | |
836290 | 836290 | 2022-12-02 | US | Pennsylvania | Centre | 42027 | 42369 | 379 | 0 | 40.92058903 | -77.82200624 | 2022-12-03 04:21:02 | Centre, Pennsylvania, US | |
2139076 | 2139076 | 2022-12-01 | US | Tennessee | Anderson | 47001 | 26569 | 379 | 0 | 36.12684348 | -84.19965764 | 2022-12-02 04:21:07 | Anderson, Tennessee, US | |
2138820 | 2138820 | 2022-12-01 | US | Pennsylvania | Centre | 42027 | 42369 | 379 | 0 | 40.92058903 | -77.82200624 | 2022-12-02 04:21:07 | Centre, Pennsylvania, US | |
2137732 | 2137732 | 2022-12-01 | US | Maryland | Allegany | 24001 | 20763 | 379 | 0 | 39.62357628 | -78.69280486 | 2022-12-02 04:21:07 | Allegany, Maryland, US | |
1967236 | 1967236 | 2022-11-30 | US | Pennsylvania | Centre | 42027 | 42369 | 379 | 0 | 40.92058903 | -77.82200624 | 2022-12-01 04:21:03 | Centre, Pennsylvania, US | |
1966148 | 1966148 | 2022-11-30 | US | Maryland | Allegany | 24001 | 20751 | 379 | 0 | 39.62357628 | -78.69280486 | 2022-12-01 04:21:03 | Allegany, Maryland, US | |
2559250 | 2559250 | 2022-11-29 | US | Pennsylvania | Centre | 42027 | 42260 | 379 | 0 | 40.92058903 | -77.82200624 | 2022-11-30 04:21:07 | Centre, Pennsylvania, US | |
2558162 | 2558162 | 2022-11-29 | US | Maryland | Allegany | 24001 | 20730 | 379 | 0 | 39.62357628 | -78.69280486 | 2022-11-30 04:21:07 | Allegany, Maryland, US | |
2556608 | 2556608 | 2022-11-29 | Japan | Shiga | 271263 | 379 | 0 | 35.215827 | 136.138064 | 2022-11-30 04:21:07 | Shiga, Japan | |||
1242324 | 1242324 | 2022-11-28 | US | Pennsylvania | Centre | 42027 | 42260 | 379 | 0 | 40.92058903 | -77.82200624 | 2022-11-29 04:21:05 | Centre, Pennsylvania, US | |
1241236 | 1241236 | 2022-11-28 | US | Maryland | Allegany | 24001 | 20693 | 379 | 0 | 39.62357628 | -78.69280486 | 2022-11-29 04:21:05 | Allegany, Maryland, US | |
3554312 | 3554312 | 2022-11-27 | US | Pennsylvania | Centre | 42027 | 42260 | 379 | 0 | 40.92058903 | -77.82200624 | 2022-11-28 04:21:02 | Centre, Pennsylvania, US | |
3553224 | 3553224 | 2022-11-27 | US | Maryland | Allegany | 24001 | 20690 | 379 | 0 | 39.62357628 | -78.69280486 | 2022-11-28 04:21:02 | Allegany, Maryland, US | |
2102792 | 2102792 | 2022-11-26 | US | Pennsylvania | Centre | 42027 | 42260 | 379 | 0 | 40.92058903 | -77.82200624 | 2022-11-27 04:21:05 | Centre, Pennsylvania, US | |
2101704 | 2101704 | 2022-11-26 | US | Maryland | Allegany | 24001 | 20690 | 379 | 0 | 39.62357628 | -78.69280486 | 2022-11-27 04:21:05 | Allegany, Maryland, US | |
490283 | 490283 | 2022-11-25 | US | Pennsylvania | Centre | 42027 | 42260 | 379 | 0 | 40.92058903 | -77.82200624 | 2022-11-26 04:21:11 | Centre, Pennsylvania, US | |
489195 | 489195 | 2022-11-25 | US | Maryland | Allegany | 24001 | 20690 | 379 | 0 | 39.62357628 | -78.69280486 | 2022-11-26 04:21:11 | Allegany, Maryland, US | |
3526112 | 3526112 | 2022-11-24 | US | Pennsylvania | Centre | 42027 | 42260 | 379 | 0 | 40.92058903 | -77.82200624 | 2022-11-25 04:21:06 | Centre, Pennsylvania, US | |
3525024 | 3525024 | 2022-11-24 | US | Maryland | Allegany | 24001 | 20690 | 379 | 0 | 39.62357628 | -78.69280486 | 2022-11-25 04:21:06 | Allegany, Maryland, US | |
3314895 | 3314895 | 2022-11-23 | US | Pennsylvania | Centre | 42027 | 42260 | 379 | 0 | 40.92058903 | -77.82200624 | 2022-11-24 04:21:09 | Centre, Pennsylvania, US | |
3313807 | 3313807 | 2022-11-23 | US | Maryland | Allegany | 24001 | 20690 | 379 | 0 | 39.62357628 | -78.69280486 | 2022-11-24 04:21:09 | Allegany, Maryland, US | |
1622936 | 1622936 | 2022-11-22 | US | Pennsylvania | Centre | 42027 | 42155 | 379 | 0 | 40.92058903 | -77.82200624 | 2022-11-23 04:21:06 | Centre, Pennsylvania, US | |
1621848 | 1621848 | 2022-11-22 | US | Maryland | Allegany | 24001 | 20677 | 379 | 0 | 39.62357628 | -78.69280486 | 2022-11-23 04:21:06 | Allegany, Maryland, US | |
3462824 | 3462824 | 2022-11-21 | US | Pennsylvania | Centre | 42027 | 42155 | 379 | 0 | 40.92058903 | -77.82200624 | 2022-11-22 04:20:47 | Centre, Pennsylvania, US | |
3461736 | 3461736 | 2022-11-21 | US | Maryland | Allegany | 24001 | 20658 | 379 | 0 | 39.62357628 | -78.69280486 | 2022-11-22 04:20:47 | Allegany, Maryland, US | |
1643009 | 1643009 | 2022-11-20 | US | Pennsylvania | Centre | 42027 | 42155 | 379 | 0 | 40.92058903 | -77.82200624 | 2022-11-21 04:21:05 | Centre, Pennsylvania, US | |
1641921 | 1641921 | 2022-11-20 | US | Maryland | Allegany | 24001 | 20644 | 379 | 0 | 39.62357628 | -78.69280486 | 2022-11-21 04:21:05 | Allegany, Maryland, US | |
2066566 | 2066566 | 2022-11-19 | US | Pennsylvania | Centre | 42027 | 42155 | 379 | 0 | 40.92058903 | -77.82200624 | 2022-11-20 04:21:08 | Centre, Pennsylvania, US | |
2065478 | 2065478 | 2022-11-19 | US | Maryland | Allegany | 24001 | 20644 | 379 | 0 | 39.62357628 | -78.69280486 | 2022-11-20 04:21:08 | Allegany, Maryland, US | |
1757960 | 1757960 | 2022-11-18 | US | Pennsylvania | Centre | 42027 | 42155 | 379 | 0 | 40.92058903 | -77.82200624 | 2022-11-19 04:21:14 | Centre, Pennsylvania, US | |
1756872 | 1756872 | 2022-11-18 | US | Maryland | Allegany | 24001 | 20644 | 379 | 0 | 39.62357628 | -78.69280486 | 2022-11-19 04:21:14 | Allegany, Maryland, US | |
3028953 | 3028953 | 2022-11-17 | US | Pennsylvania | Centre | 42027 | 42155 | 379 | 0 | 40.92058903 | -77.82200624 | 2022-11-18 04:21:15 | Centre, Pennsylvania, US | |
3027865 | 3027865 | 2022-11-17 | US | Maryland | Allegany | 24001 | 20633 | 379 | 0 | 39.62357628 | -78.69280486 | 2022-11-18 04:21:15 | Allegany, Maryland, US | |
2488664 | 2488664 | 2022-11-16 | US | Pennsylvania | Centre | 42027 | 42155 | 379 | 0 | 40.92058903 | -77.82200624 | 2022-11-17 04:21:11 | Centre, Pennsylvania, US | |
2487576 | 2487576 | 2022-11-16 | US | Maryland | Allegany | 24001 | 20610 | 379 | 0 | 39.62357628 | -78.69280486 | 2022-11-17 04:21:11 | Allegany, Maryland, US | |
294678 | 294678 | 2022-11-15 | US | Pennsylvania | Clearfield | 42033 | 22955 | 379 | 0 | 41.00110782 | -78.47592663 | 2022-11-16 04:21:09 | Clearfield, Pennsylvania, US | |
294332 | 294332 | 2022-11-15 | US | North Carolina | Durham | 37063 | 96232 | 379 | 0 | 36.03638492 | -78.87608331 | 2022-11-16 04:21:09 | Durham, North Carolina, US | |
293587 | 293587 | 2022-11-15 | US | Maryland | Allegany | 24001 | 20597 | 379 | 0 | 39.62357628 | -78.69280486 | 2022-11-16 04:21:09 | Allegany, Maryland, US | |
3599708 | 3599708 | 2022-11-14 | US | Pennsylvania | Clearfield | 42033 | 22955 | 379 | 0 | 41.00110782 | -78.47592663 | 2022-11-15 04:21:16 | Clearfield, Pennsylvania, US | |
3599362 | 3599362 | 2022-11-14 | US | North Carolina | Durham | 37063 | 96232 | 379 | 0 | 36.03638492 | -78.87608331 | 2022-11-15 04:21:16 | Durham, North Carolina, US | |
3598617 | 3598617 | 2022-11-14 | US | Maryland | Allegany | 24001 | 20575 | 379 | 0 | 39.62357628 | -78.69280486 | 2022-11-15 04:21:16 | Allegany, Maryland, US | |
314566 | 314566 | 2022-11-13 | US | Pennsylvania | Clearfield | 42033 | 22955 | 379 | 0 | 41.00110782 | -78.47592663 | 2022-11-14 04:21:09 | Clearfield, Pennsylvania, US | |
314220 | 314220 | 2022-11-13 | US | North Carolina | Durham | 37063 | 96232 | 379 | 0 | 36.03638492 | -78.87608331 | 2022-11-14 04:21:09 | Durham, North Carolina, US | |
313475 | 313475 | 2022-11-13 | US | Maryland | Allegany | 24001 | 20569 | 379 | 0 | 39.62357628 | -78.69280486 | 2022-11-14 04:21:09 | Allegany, Maryland, US | |
65727 | 65727 | 2022-11-12 | US | Pennsylvania | Clearfield | 42033 | 22955 | 379 | 0 | 41.00110782 | -78.47592663 | 2022-11-13 04:21:14 | Clearfield, Pennsylvania, US | |
65381 | 65381 | 2022-11-12 | US | North Carolina | Durham | 37063 | 96232 | 379 | 0 | 36.03638492 | -78.87608331 | 2022-11-13 04:21:14 | Durham, North Carolina, US | |
64636 | 64636 | 2022-11-12 | US | Maryland | Allegany | 24001 | 20569 | 379 | 0 | 39.62357628 | -78.69280486 | 2022-11-13 04:21:14 | Allegany, Maryland, US | |
2929889 | 2929889 | 2022-11-11 | US | Pennsylvania | Clearfield | 42033 | 22955 | 379 | 0 | 41.00110782 | -78.47592663 | 2022-11-12 04:20:41 | Clearfield, Pennsylvania, US | |
2929543 | 2929543 | 2022-11-11 | US | North Carolina | Durham | 37063 | 96232 | 379 | 0 | 36.03638492 | -78.87608331 | 2022-11-12 04:20:41 | Durham, North Carolina, US | |
2928798 | 2928798 | 2022-11-11 | US | Maryland | Allegany | 24001 | 20569 | 379 | 0 | 39.62357628 | -78.69280486 | 2022-11-12 04:20:41 | Allegany, Maryland, US | |
2508725 | 2508725 | 2022-11-10 | US | Pennsylvania | Clearfield | 42033 | 22955 | 379 | 0 | 41.00110782 | -78.47592663 | 2022-11-11 04:21:22 | Clearfield, Pennsylvania, US | |
2508379 | 2508379 | 2022-11-10 | US | North Carolina | Durham | 37063 | 96232 | 379 | 0 | 36.03638492 | -78.87608331 | 2022-11-11 04:21:22 | Durham, North Carolina, US | |
2507634 | 2507634 | 2022-11-10 | US | Maryland | Allegany | 24001 | 20569 | 379 | 0 | 39.62357628 | -78.69280486 | 2022-11-11 04:21:22 | Allegany, Maryland, US | |
2433600 | 2433600 | 2022-11-09 | US | Pennsylvania | Clearfield | 42033 | 22955 | 379 | 0 | 41.00110782 | -78.47592663 | 2022-11-10 04:21:16 | Clearfield, Pennsylvania, US | |
2433254 | 2433254 | 2022-11-09 | US | North Carolina | Durham | 37063 | 96232 | 379 | 0 | 36.03638492 | -78.87608331 | 2022-11-10 04:21:16 | Durham, North Carolina, US | |
483032 | 483032 | 2022-11-08 | US | Washington | Cowlitz | 53015 | 26295 | 379 | 0 | 46.19074721 | -122.6782231 | 2022-11-09 04:21:22 | Cowlitz, Washington, US | |
482256 | 482256 | 2022-11-08 | US | Pennsylvania | Clearfield | 42033 | 22863 | 379 | 0 | 41.00110782 | -78.47592663 | 2022-11-09 04:21:22 | Clearfield, Pennsylvania, US | |
481910 | 481910 | 2022-11-08 | US | North Carolina | Durham | 37063 | 95971 | 379 | 0 | 36.03638492 | -78.87608331 | 2022-11-09 04:21:22 | Durham, North Carolina, US | |
2442182 | 2442182 | 2022-11-07 | US | Washington | Cowlitz | 53015 | 26295 | 379 | 0 | 46.19074721 | -122.6782231 | 2022-11-08 04:21:21 | Cowlitz, Washington, US | |
2441406 | 2441406 | 2022-11-07 | US | Pennsylvania | Clearfield | 42033 | 22863 | 379 | 0 | 41.00110782 | -78.47592663 | 2022-11-08 04:21:21 | Clearfield, Pennsylvania, US | |
2441060 | 2441060 | 2022-11-07 | US | North Carolina | Durham | 37063 | 95971 | 379 | 0 | 36.03638492 | -78.87608331 | 2022-11-08 04:21:21 | Durham, North Carolina, US | |
1053280 | 1053280 | 2022-11-06 | US | Washington | Cowlitz | 53015 | 26295 | 379 | 0 | 46.19074721 | -122.6782231 | 2022-11-07 04:21:26 | Cowlitz, Washington, US | |
1052504 | 1052504 | 2022-11-06 | US | Pennsylvania | Clearfield | 42033 | 22863 | 379 | 0 | 41.00110782 | -78.47592663 | 2022-11-07 04:21:26 | Clearfield, Pennsylvania, US | |
1052158 | 1052158 | 2022-11-06 | US | North Carolina | Durham | 37063 | 95971 | 379 | 0 | 36.03638492 | -78.87608331 | 2022-11-07 04:21:26 | Durham, North Carolina, US | |
621304 | 621304 | 2022-11-05 | US | Washington | Cowlitz | 53015 | 26295 | 379 | 0 | 46.19074721 | -122.6782231 | 2022-11-06 04:21:24 | Cowlitz, Washington, US | |
620528 | 620528 | 2022-11-05 | US | Pennsylvania | Clearfield | 42033 | 22863 | 379 | 0 | 41.00110782 | -78.47592663 | 2022-11-06 04:21:24 | Clearfield, Pennsylvania, US | |
620182 | 620182 | 2022-11-05 | US | North Carolina | Durham | 37063 | 95971 | 379 | 0 | 36.03638492 | -78.87608331 | 2022-11-06 04:21:24 | Durham, North Carolina, US | |
1025808 | 1025808 | 2022-11-04 | US | Washington | Cowlitz | 53015 | 26295 | 379 | 0 | 46.19074721 | -122.6782231 | 2022-11-05 04:21:52 | Cowlitz, Washington, US | |
1025032 | 1025032 | 2022-11-04 | US | Pennsylvania | Clearfield | 42033 | 22863 | 379 | 0 | 41.00110782 | -78.47592663 | 2022-11-05 04:21:52 | Clearfield, Pennsylvania, US | |
1024686 | 1024686 | 2022-11-04 | US | North Carolina | Durham | 37063 | 95971 | 379 | 0 | 36.03638492 | -78.87608331 | 2022-11-05 04:21:52 | Durham, North Carolina, US | |
434799 | 434799 | 2022-11-03 | US | Washington | Cowlitz | 53015 | 26295 | 379 | 0 | 46.19074721 | -122.6782231 | 2022-11-04 04:22:11 | Cowlitz, Washington, US | |
434023 | 434023 | 2022-11-03 | US | Pennsylvania | Clearfield | 42033 | 22863 | 379 | 0 | 41.00110782 | -78.47592663 | 2022-11-04 04:22:11 | Clearfield, Pennsylvania, US | |
433677 | 433677 | 2022-11-03 | US | North Carolina | Durham | 37063 | 95971 | 379 | 0 | 36.03638492 | -78.87608331 | 2022-11-04 04:22:11 | Durham, North Carolina, US | |
432368 | 432368 | 2022-11-03 | US | Illinois | Kankakee | 17091 | 34352 | 379 | 0 | 41.13746989 | -87.86205334 | 2022-11-04 04:22:11 | Kankakee, Illinois, 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]);