johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,408 rows where deaths = 308 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 1,125
- Maldives 70
- Niger 41
- Russia 33
- Japan 25
- Sweden 17
- Ukraine 12
- India 8
- Colombia 6
- Finland 5
- Italy 4
- Malaysia 4
- Peru 4
- Chile 3
- Netherlands 3
- Spain 3
- Angola 2
- Bahamas 2
- Bahrain 2
- Cabo Verde 2
- Congo (Kinshasa) 2
- Cote d'Ivoire 2
- France 2
- Germany 2
- Israel 2
- Mali 2
- Pakistan 2
- United Kingdom 2
- Australia 1
- Barbados 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756152 | 2756152 | 2022-12-29 | US | Texas | Val Verde | 48465 | 15740 | 308 | 0 | 29.89149232 | -101.1525205 | 2022-12-30 04:21:04 | Val Verde, Texas, US | |
2755170 | 2755170 | 2022-12-29 | US | New York | Rensselaer | 36083 | 40780 | 308 | 0 | 42.71348136 | -73.51089874 | 2022-12-30 04:21:04 | Rensselaer, New York, US | |
2753878 | 2753878 | 2022-12-29 | US | Illinois | Champaign | 17019 | 83838 | 308 | 0 | 40.13919438 | -88.20046615 | 2022-12-30 04:21:04 | Champaign, Illinois, US | |
1077158 | 1077158 | 2022-12-28 | US | Texas | Val Verde | 48465 | 15740 | 308 | 0 | 29.89149232 | -101.1525205 | 2022-12-29 04:21:01 | Val Verde, Texas, US | |
331155 | 331155 | 2022-12-27 | US | Texas | Val Verde | 48465 | 15723 | 308 | 0 | 29.89149232 | -101.1525205 | 2022-12-28 04:21:04 | Val Verde, Texas, US | |
221228 | 221228 | 2022-12-26 | US | Texas | Val Verde | 48465 | 15723 | 308 | 0 | 29.89149232 | -101.1525205 | 2022-12-27 04:21:07 | Val Verde, Texas, US | |
3225685 | 3225685 | 2022-12-25 | US | Texas | Val Verde | 48465 | 15723 | 308 | 0 | 29.89149232 | -101.1525205 | 2022-12-26 04:21:06 | Val Verde, Texas, US | |
1021599 | 1021599 | 2022-12-24 | US | Texas | Val Verde | 48465 | 15723 | 308 | 0 | 29.89149232 | -101.1525205 | 2022-12-25 04:21:04 | Val Verde, Texas, US | |
693622 | 693622 | 2022-12-23 | US | Texas | Val Verde | 48465 | 15723 | 308 | 0 | 29.89149232 | -101.1525205 | 2022-12-24 04:21:02 | Val Verde, Texas, US | |
2182832 | 2182832 | 2022-12-22 | US | Texas | Val Verde | 48465 | 15723 | 308 | 0 | 29.89149232 | -101.1525205 | 2022-12-23 04:21:04 | Val Verde, Texas, US | |
454636 | 454636 | 2022-12-21 | US | Texas | Val Verde | 48465 | 15723 | 308 | 0 | 29.89149232 | -101.1525205 | 2022-12-22 04:20:56 | Val Verde, Texas, US | |
2954635 | 2954635 | 2022-12-20 | US | Texas | Val Verde | 48465 | 15707 | 308 | 0 | 29.89149232 | -101.1525205 | 2022-12-21 04:21:03 | Val Verde, Texas, US | |
3177037 | 3177037 | 2022-12-19 | US | Texas | Val Verde | 48465 | 15707 | 308 | 0 | 29.89149232 | -101.1525205 | 2022-12-20 04:21:04 | Val Verde, Texas, US | |
1631554 | 1631554 | 2022-12-18 | US | Texas | Val Verde | 48465 | 15707 | 308 | 0 | 29.89149232 | -101.1525205 | 2022-12-19 04:21:03 | Val Verde, Texas, US | |
506933 | 506933 | 2022-12-17 | US | Texas | Val Verde | 48465 | 15707 | 308 | 0 | 29.89149232 | -101.1525205 | 2022-12-18 04:21:03 | Val Verde, Texas, US | |
3327505 | 3327505 | 2022-12-16 | US | Texas | Val Verde | 48465 | 15707 | 308 | 0 | 29.89149232 | -101.1525205 | 2022-12-17 04:21:04 | Val Verde, Texas, US | |
546017 | 546017 | 2022-12-15 | US | Texas | Val Verde | 48465 | 15707 | 308 | 0 | 29.89149232 | -101.1525205 | 2022-12-16 04:21:01 | Val Verde, Texas, US | |
351703 | 351703 | 2022-12-14 | US | Virginia | Roanoke | 51161 | 26770 | 308 | 0 | 37.26865804 | -80.06396753 | 2022-12-15 04:20:58 | Roanoke, Virginia, US | |
351545 | 351545 | 2022-12-14 | US | Texas | Val Verde | 48465 | 15707 | 308 | 0 | 29.89149232 | -101.1525205 | 2022-12-15 04:20:58 | Val Verde, Texas, US | |
311291 | 311291 | 2022-12-13 | US | Virginia | Roanoke | 51161 | 26755 | 308 | 0 | 37.26865804 | -80.06396753 | 2022-12-14 04:21:04 | Roanoke, Virginia, US | |
311133 | 311133 | 2022-12-13 | US | Texas | Val Verde | 48465 | 15699 | 308 | 0 | 29.89149232 | -101.1525205 | 2022-12-14 04:21:04 | Val Verde, Texas, US | |
308846 | 308846 | 2022-12-13 | US | Idaho | Twin Falls | 16083 | 27907 | 308 | 0 | 42.35440512 | -114.6685381 | 2022-12-14 04:21:04 | Twin Falls, Idaho, US | |
1152352 | 1152352 | 2022-12-12 | US | Virginia | Roanoke | 51161 | 26736 | 308 | 0 | 37.26865804 | -80.06396753 | 2022-12-13 04:21:01 | Roanoke, Virginia, US | |
1152194 | 1152194 | 2022-12-12 | US | Texas | Val Verde | 48465 | 15699 | 308 | 0 | 29.89149232 | -101.1525205 | 2022-12-13 04:21:01 | Val Verde, Texas, US | |
1149907 | 1149907 | 2022-12-12 | US | Idaho | Twin Falls | 16083 | 27907 | 308 | 0 | 42.35440512 | -114.6685381 | 2022-12-13 04:21:01 | Twin Falls, Idaho, US | |
872206 | 872206 | 2022-12-11 | US | Virginia | Roanoke | 51161 | 26692 | 308 | 0 | 37.26865804 | -80.06396753 | 2022-12-12 04:21:01 | Roanoke, Virginia, US | |
872048 | 872048 | 2022-12-11 | US | Texas | Val Verde | 48465 | 15699 | 308 | 0 | 29.89149232 | -101.1525205 | 2022-12-12 04:21:01 | Val Verde, Texas, US | |
869761 | 869761 | 2022-12-11 | US | Idaho | Twin Falls | 16083 | 27907 | 308 | 0 | 42.35440512 | -114.6685381 | 2022-12-12 04:21:01 | Twin Falls, Idaho, US | |
260736 | 260736 | 2022-12-10 | US | Virginia | Roanoke | 51161 | 26692 | 308 | 0 | 37.26865804 | -80.06396753 | 2022-12-11 04:20:50 | Roanoke, Virginia, US | |
260578 | 260578 | 2022-12-10 | US | Texas | Val Verde | 48465 | 15699 | 308 | 0 | 29.89149232 | -101.1525205 | 2022-12-11 04:20:50 | Val Verde, Texas, US | |
258291 | 258291 | 2022-12-10 | US | Idaho | Twin Falls | 16083 | 27907 | 308 | 0 | 42.35440512 | -114.6685381 | 2022-12-11 04:20:50 | Twin Falls, Idaho, US | |
3939450 | 3939450 | 2022-12-09 | US | Virginia | Roanoke | 51161 | 26692 | 308 | 0 | 37.26865804 | -80.06396753 | 2022-12-10 04:21:02 | Roanoke, Virginia, US | |
3939292 | 3939292 | 2022-12-09 | US | Texas | Val Verde | 48465 | 15699 | 308 | 0 | 29.89149232 | -101.1525205 | 2022-12-10 04:21:02 | Val Verde, Texas, US | |
3937005 | 3937005 | 2022-12-09 | US | Idaho | Twin Falls | 16083 | 27907 | 308 | 0 | 42.35440512 | -114.6685381 | 2022-12-10 04:21:02 | Twin Falls, Idaho, US | |
3936073 | 3936073 | 2022-12-09 | Japan | Wakayama | 165407 | 308 | 0 | 33.911879 | 135.505446 | 2022-12-10 04:21:02 | Wakayama, Japan | |||
3380624 | 3380624 | 2022-12-08 | US | Texas | Val Verde | 48465 | 15699 | 308 | 0 | 29.89149232 | -101.1525205 | 2022-12-09 04:21:05 | Val Verde, Texas, US | |
3378337 | 3378337 | 2022-12-08 | US | Idaho | Twin Falls | 16083 | 27907 | 308 | 0 | 42.35440512 | -114.6685381 | 2022-12-09 04:21:05 | Twin Falls, Idaho, US | |
1987895 | 1987895 | 2022-12-07 | US | Texas | Val Verde | 48465 | 15699 | 308 | 0 | 29.89149232 | -101.1525205 | 2022-12-08 04:21:07 | Val Verde, Texas, US | |
1985608 | 1985608 | 2022-12-07 | US | Idaho | Twin Falls | 16083 | 27907 | 308 | 0 | 42.35440512 | -114.6685381 | 2022-12-08 04:21:07 | Twin Falls, Idaho, US | |
1985475 | 1985475 | 2022-12-07 | US | Georgia | Jackson | 13157 | 23774 | 308 | 0 | 34.13794553 | -83.56814788 | 2022-12-08 04:21:07 | Jackson, Georgia, US | |
3717418 | 3717418 | 2022-12-06 | US | Texas | Val Verde | 48465 | 15689 | 308 | 0 | 29.89149232 | -101.1525205 | 2022-12-07 04:20:58 | Val Verde, Texas, US | |
3715131 | 3715131 | 2022-12-06 | US | Idaho | Twin Falls | 16083 | 27786 | 308 | 0 | 42.35440512 | -114.6685381 | 2022-12-07 04:20:58 | Twin Falls, Idaho, US | |
3714998 | 3714998 | 2022-12-06 | US | Georgia | Jackson | 13157 | 23774 | 308 | 0 | 34.13794553 | -83.56814788 | 2022-12-07 04:20:58 | Jackson, Georgia, US | |
2418123 | 2418123 | 2022-12-05 | US | Texas | Val Verde | 48465 | 15689 | 308 | 0 | 29.89149232 | -101.1525205 | 2022-12-06 04:21:03 | Val Verde, Texas, US | |
2417708 | 2417708 | 2022-12-05 | US | South Carolina | Laurens | 45059 | 21871 | 308 | 0 | 34.48244419 | -82.00490796 | 2022-12-06 04:21:03 | Laurens, South Carolina, US | |
2415836 | 2415836 | 2022-12-05 | US | Idaho | Twin Falls | 16083 | 27786 | 308 | 0 | 42.35440512 | -114.6685381 | 2022-12-06 04:21:03 | Twin Falls, Idaho, US | |
2415703 | 2415703 | 2022-12-05 | US | Georgia | Jackson | 13157 | 23774 | 308 | 0 | 34.13794553 | -83.56814788 | 2022-12-06 04:21:03 | Jackson, Georgia, US | |
2415375 | 2415375 | 2022-12-05 | US | Arkansas | Jefferson | 5069 | 21682 | 308 | 0 | 34.26767081 | -91.92619839 | 2022-12-06 04:21:03 | Jefferson, Arkansas, US | |
721731 | 721731 | 2022-12-04 | US | Texas | Val Verde | 48465 | 15689 | 308 | 0 | 29.89149232 | -101.1525205 | 2022-12-05 04:20:58 | Val Verde, Texas, US | |
721316 | 721316 | 2022-12-04 | US | South Carolina | Laurens | 45059 | 21871 | 308 | 0 | 34.48244419 | -82.00490796 | 2022-12-05 04:20:58 | Laurens, South Carolina, US | |
719444 | 719444 | 2022-12-04 | US | Idaho | Twin Falls | 16083 | 27786 | 308 | 0 | 42.35440512 | -114.6685381 | 2022-12-05 04:20:58 | Twin Falls, Idaho, US | |
719311 | 719311 | 2022-12-04 | US | Georgia | Jackson | 13157 | 23774 | 308 | 0 | 34.13794553 | -83.56814788 | 2022-12-05 04:20:58 | Jackson, Georgia, US | |
718983 | 718983 | 2022-12-04 | US | Arkansas | Jefferson | 5069 | 21679 | 308 | 0 | 34.26767081 | -91.92619839 | 2022-12-05 04:20:58 | Jefferson, Arkansas, US | |
2820020 | 2820020 | 2022-12-03 | US | Texas | Val Verde | 48465 | 15689 | 308 | 0 | 29.89149232 | -101.1525205 | 2022-12-04 04:20:56 | Val Verde, Texas, US | |
2819605 | 2819605 | 2022-12-03 | US | South Carolina | Laurens | 45059 | 21871 | 308 | 0 | 34.48244419 | -82.00490796 | 2022-12-04 04:20:56 | Laurens, South Carolina, US | |
2817733 | 2817733 | 2022-12-03 | US | Idaho | Twin Falls | 16083 | 27786 | 308 | 0 | 42.35440512 | -114.6685381 | 2022-12-04 04:20:56 | Twin Falls, Idaho, US | |
2817600 | 2817600 | 2022-12-03 | US | Georgia | Jackson | 13157 | 23774 | 308 | 0 | 34.13794553 | -83.56814788 | 2022-12-04 04:20:56 | Jackson, Georgia, US | |
2817272 | 2817272 | 2022-12-03 | US | Arkansas | Jefferson | 5069 | 21681 | 308 | 0 | 34.26767081 | -91.92619839 | 2022-12-04 04:20:56 | Jefferson, Arkansas, US | |
836876 | 836876 | 2022-12-02 | US | Texas | Val Verde | 48465 | 15689 | 308 | 0 | 29.89149232 | -101.1525205 | 2022-12-03 04:21:02 | Val Verde, Texas, US | |
836461 | 836461 | 2022-12-02 | US | South Carolina | Laurens | 45059 | 21871 | 308 | 0 | 34.48244419 | -82.00490796 | 2022-12-03 04:21:02 | Laurens, South Carolina, US | |
834589 | 834589 | 2022-12-02 | US | Idaho | Twin Falls | 16083 | 27786 | 308 | 0 | 42.35440512 | -114.6685381 | 2022-12-03 04:21:02 | Twin Falls, Idaho, US | |
834456 | 834456 | 2022-12-02 | US | Georgia | Jackson | 13157 | 23774 | 308 | 0 | 34.13794553 | -83.56814788 | 2022-12-03 04:21:02 | Jackson, Georgia, US | |
834128 | 834128 | 2022-12-02 | US | Arkansas | Jefferson | 5069 | 21669 | 308 | 0 | 34.26767081 | -91.92619839 | 2022-12-03 04:21:02 | Jefferson, Arkansas, US | |
2139406 | 2139406 | 2022-12-01 | US | Texas | Val Verde | 48465 | 15689 | 308 | 0 | 29.89149232 | -101.1525205 | 2022-12-02 04:21:07 | Val Verde, Texas, US | |
2138991 | 2138991 | 2022-12-01 | US | South Carolina | Laurens | 45059 | 21871 | 308 | 0 | 34.48244419 | -82.00490796 | 2022-12-02 04:21:07 | Laurens, South Carolina, US | |
2137119 | 2137119 | 2022-12-01 | US | Idaho | Twin Falls | 16083 | 27786 | 308 | 0 | 42.35440512 | -114.6685381 | 2022-12-02 04:21:07 | Twin Falls, Idaho, US | |
2136986 | 2136986 | 2022-12-01 | US | Georgia | Jackson | 13157 | 23774 | 308 | 0 | 34.13794553 | -83.56814788 | 2022-12-02 04:21:07 | Jackson, Georgia, US | |
2136658 | 2136658 | 2022-12-01 | US | Arkansas | Jefferson | 5069 | 21650 | 308 | 0 | 34.26767081 | -91.92619839 | 2022-12-02 04:21:07 | Jefferson, Arkansas, US | |
1967822 | 1967822 | 2022-11-30 | US | Texas | Val Verde | 48465 | 15689 | 308 | 0 | 29.89149232 | -101.1525205 | 2022-12-01 04:21:03 | Val Verde, Texas, US | |
1967407 | 1967407 | 2022-11-30 | US | South Carolina | Laurens | 45059 | 21871 | 308 | 0 | 34.48244419 | -82.00490796 | 2022-12-01 04:21:03 | Laurens, South Carolina, US | |
1965535 | 1965535 | 2022-11-30 | US | Idaho | Twin Falls | 16083 | 27786 | 308 | 0 | 42.35440512 | -114.6685381 | 2022-12-01 04:21:03 | Twin Falls, Idaho, US | |
1965402 | 1965402 | 2022-11-30 | US | Georgia | Jackson | 13157 | 23774 | 308 | 0 | 34.13794553 | -83.56814788 | 2022-12-01 04:21:03 | Jackson, Georgia, US | |
1965074 | 1965074 | 2022-11-30 | US | Arkansas | Jefferson | 5069 | 21634 | 308 | 0 | 34.26767081 | -91.92619839 | 2022-12-01 04:21:03 | Jefferson, Arkansas, US | |
2559836 | 2559836 | 2022-11-29 | US | Texas | Val Verde | 48465 | 15687 | 308 | 0 | 29.89149232 | -101.1525205 | 2022-11-30 04:21:07 | Val Verde, Texas, US | |
2559421 | 2559421 | 2022-11-29 | US | South Carolina | Laurens | 45059 | 21871 | 308 | 0 | 34.48244419 | -82.00490796 | 2022-11-30 04:21:07 | Laurens, South Carolina, US | |
2557549 | 2557549 | 2022-11-29 | US | Idaho | Twin Falls | 16083 | 27704 | 308 | 0 | 42.35440512 | -114.6685381 | 2022-11-30 04:21:07 | Twin Falls, Idaho, US | |
2557416 | 2557416 | 2022-11-29 | US | Georgia | Jackson | 13157 | 23721 | 308 | 0 | 34.13794553 | -83.56814788 | 2022-11-30 04:21:07 | Jackson, Georgia, US | |
2557088 | 2557088 | 2022-11-29 | US | Arkansas | Jefferson | 5069 | 21625 | 308 | 0 | 34.26767081 | -91.92619839 | 2022-11-30 04:21:07 | Jefferson, Arkansas, US | |
2556977 | 2556977 | 2022-11-29 | US | Alabama | Limestone | 1083 | 30186 | 308 | 0 | 34.81185586 | -86.98310072 | 2022-11-30 04:21:07 | Limestone, Alabama, US | |
1242910 | 1242910 | 2022-11-28 | US | Texas | Val Verde | 48465 | 15687 | 308 | 0 | 29.89149232 | -101.1525205 | 2022-11-29 04:21:05 | Val Verde, Texas, US | |
1242495 | 1242495 | 2022-11-28 | US | South Carolina | Laurens | 45059 | 21806 | 308 | 0 | 34.48244419 | -82.00490796 | 2022-11-29 04:21:05 | Laurens, South Carolina, US | |
1240623 | 1240623 | 2022-11-28 | US | Idaho | Twin Falls | 16083 | 27704 | 308 | 0 | 42.35440512 | -114.6685381 | 2022-11-29 04:21:05 | Twin Falls, Idaho, US | |
1240490 | 1240490 | 2022-11-28 | US | Georgia | Jackson | 13157 | 23721 | 308 | 0 | 34.13794553 | -83.56814788 | 2022-11-29 04:21:05 | Jackson, Georgia, US | |
1240162 | 1240162 | 2022-11-28 | US | Arkansas | Jefferson | 5069 | 21619 | 308 | 0 | 34.26767081 | -91.92619839 | 2022-11-29 04:21:05 | Jefferson, Arkansas, US | |
1240051 | 1240051 | 2022-11-28 | US | Alabama | Limestone | 1083 | 30186 | 308 | 0 | 34.81185586 | -86.98310072 | 2022-11-29 04:21:05 | Limestone, Alabama, US | |
3554898 | 3554898 | 2022-11-27 | US | Texas | Val Verde | 48465 | 15686 | 308 | 0 | 29.89149232 | -101.1525205 | 2022-11-28 04:21:02 | Val Verde, Texas, US | |
3554483 | 3554483 | 2022-11-27 | US | South Carolina | Laurens | 45059 | 21806 | 308 | 0 | 34.48244419 | -82.00490796 | 2022-11-28 04:21:02 | Laurens, South Carolina, US | |
3552611 | 3552611 | 2022-11-27 | US | Idaho | Twin Falls | 16083 | 27704 | 308 | 0 | 42.35440512 | -114.6685381 | 2022-11-28 04:21:02 | Twin Falls, Idaho, US | |
3552478 | 3552478 | 2022-11-27 | US | Georgia | Jackson | 13157 | 23721 | 308 | 0 | 34.13794553 | -83.56814788 | 2022-11-28 04:21:02 | Jackson, Georgia, US | |
3552150 | 3552150 | 2022-11-27 | US | Arkansas | Jefferson | 5069 | 21618 | 308 | 0 | 34.26767081 | -91.92619839 | 2022-11-28 04:21:02 | Jefferson, Arkansas, US | |
3552039 | 3552039 | 2022-11-27 | US | Alabama | Limestone | 1083 | 30186 | 308 | 0 | 34.81185586 | -86.98310072 | 2022-11-28 04:21:02 | Limestone, Alabama, US | |
2103378 | 2103378 | 2022-11-26 | US | Texas | Val Verde | 48465 | 15686 | 308 | 0 | 29.89149232 | -101.1525205 | 2022-11-27 04:21:05 | Val Verde, Texas, US | |
2102963 | 2102963 | 2022-11-26 | US | South Carolina | Laurens | 45059 | 21806 | 308 | 0 | 34.48244419 | -82.00490796 | 2022-11-27 04:21:05 | Laurens, South Carolina, US | |
2101091 | 2101091 | 2022-11-26 | US | Idaho | Twin Falls | 16083 | 27704 | 308 | 0 | 42.35440512 | -114.6685381 | 2022-11-27 04:21:05 | Twin Falls, Idaho, US | |
2100958 | 2100958 | 2022-11-26 | US | Georgia | Jackson | 13157 | 23721 | 308 | 0 | 34.13794553 | -83.56814788 | 2022-11-27 04:21:05 | Jackson, Georgia, US | |
2100630 | 2100630 | 2022-11-26 | US | Arkansas | Jefferson | 5069 | 21615 | 308 | 0 | 34.26767081 | -91.92619839 | 2022-11-27 04:21:05 | Jefferson, Arkansas, US | |
2100519 | 2100519 | 2022-11-26 | US | Alabama | Limestone | 1083 | 30186 | 308 | 0 | 34.81185586 | -86.98310072 | 2022-11-27 04:21:05 | Limestone, Alabama, US | |
490869 | 490869 | 2022-11-25 | US | Texas | Val Verde | 48465 | 15686 | 308 | 0 | 29.89149232 | -101.1525205 | 2022-11-26 04:21:11 | Val Verde, Texas, US | |
490454 | 490454 | 2022-11-25 | US | South Carolina | Laurens | 45059 | 21806 | 308 | 0 | 34.48244419 | -82.00490796 | 2022-11-26 04:21:11 | Laurens, South Carolina, US | |
488582 | 488582 | 2022-11-25 | US | Idaho | Twin Falls | 16083 | 27704 | 308 | 0 | 42.35440512 | -114.6685381 | 2022-11-26 04:21:11 | Twin Falls, Idaho, 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]);