johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
703 rows where country_or_region = "US" and deaths = 413 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Texas 144
- Indiana 71
- Pennsylvania 49
- Georgia 42
- Virginia 30
- Louisiana 25
- Massachusetts 22
- Florida 20
- Ohio 19
- Michigan 18
- South Carolina 18
- North Carolina 17
- Washington 15
- New York 14
- Oklahoma 14
- Arkansas 13
- Maryland 13
- Utah 12
- California 11
- Illinois 11
- Alabama 10
- West Virginia 10
- Iowa 9
- Minnesota 9
- Missouri 9
- Wisconsin 9
- Arizona 8
- Mississippi 8
- Delaware 7
- Hawaii 7
- …
country_or_region 1
- US · 703 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756064 | 2756064 | 2022-12-29 | US | Texas | Liberty | 48291 | 21641 | 413 | 0 | 30.15152688 | -94.81205615 | 2022-12-30 04:21:04 | Liberty, Texas, US | |
1077070 | 1077070 | 2022-12-28 | US | Texas | Liberty | 48291 | 21641 | 413 | 0 | 30.15152688 | -94.81205615 | 2022-12-29 04:21:01 | Liberty, Texas, US | |
331067 | 331067 | 2022-12-27 | US | Texas | Liberty | 48291 | 21574 | 413 | 0 | 30.15152688 | -94.81205615 | 2022-12-28 04:21:04 | Liberty, Texas, US | |
221140 | 221140 | 2022-12-26 | US | Texas | Liberty | 48291 | 21574 | 413 | 0 | 30.15152688 | -94.81205615 | 2022-12-27 04:21:07 | Liberty, Texas, US | |
3225597 | 3225597 | 2022-12-25 | US | Texas | Liberty | 48291 | 21574 | 413 | 0 | 30.15152688 | -94.81205615 | 2022-12-26 04:21:06 | Liberty, Texas, US | |
1021511 | 1021511 | 2022-12-24 | US | Texas | Liberty | 48291 | 21574 | 413 | 0 | 30.15152688 | -94.81205615 | 2022-12-25 04:21:04 | Liberty, Texas, US | |
693534 | 693534 | 2022-12-23 | US | Texas | Liberty | 48291 | 21574 | 413 | 0 | 30.15152688 | -94.81205615 | 2022-12-24 04:21:02 | Liberty, Texas, US | |
2182744 | 2182744 | 2022-12-22 | US | Texas | Liberty | 48291 | 21574 | 413 | 0 | 30.15152688 | -94.81205615 | 2022-12-23 04:21:04 | Liberty, Texas, US | |
454548 | 454548 | 2022-12-21 | US | Texas | Liberty | 48291 | 21574 | 413 | 0 | 30.15152688 | -94.81205615 | 2022-12-22 04:20:56 | Liberty, Texas, US | |
349903 | 349903 | 2022-12-14 | US | Massachusetts | Hampshire | 25015 | 38011 | 413 | 0 | 42.33997957 | -72.65898478 | 2022-12-15 04:20:58 | Hampshire, Massachusetts, US | |
309491 | 309491 | 2022-12-13 | US | Massachusetts | Hampshire | 25015 | 38011 | 413 | 0 | 42.33997957 | -72.65898478 | 2022-12-14 04:21:04 | Hampshire, Massachusetts, US | |
1150552 | 1150552 | 2022-12-12 | US | Massachusetts | Hampshire | 25015 | 38011 | 413 | 0 | 42.33997957 | -72.65898478 | 2022-12-13 04:21:01 | Hampshire, Massachusetts, US | |
870406 | 870406 | 2022-12-11 | US | Massachusetts | Hampshire | 25015 | 38011 | 413 | 0 | 42.33997957 | -72.65898478 | 2022-12-12 04:21:01 | Hampshire, Massachusetts, US | |
258936 | 258936 | 2022-12-10 | US | Massachusetts | Hampshire | 25015 | 38011 | 413 | 0 | 42.33997957 | -72.65898478 | 2022-12-11 04:20:50 | Hampshire, Massachusetts, US | |
3937650 | 3937650 | 2022-12-09 | US | Massachusetts | Hampshire | 25015 | 38011 | 413 | 0 | 42.33997957 | -72.65898478 | 2022-12-10 04:21:02 | Hampshire, Massachusetts, US | |
3378982 | 3378982 | 2022-12-08 | US | Massachusetts | Hampshire | 25015 | 38011 | 413 | 0 | 42.33997957 | -72.65898478 | 2022-12-09 04:21:05 | Hampshire, Massachusetts, US | |
3552349 | 3552349 | 2022-11-27 | US | Florida | Flagler | 12035 | 27754 | 413 | 0 | 29.45933576 | -81.31508595 | 2022-11-28 04:21:02 | Flagler, Florida, US | |
2100829 | 2100829 | 2022-11-26 | US | Florida | Flagler | 12035 | 27754 | 413 | 0 | 29.45933576 | -81.31508595 | 2022-11-27 04:21:05 | Flagler, Florida, US | |
488320 | 488320 | 2022-11-25 | US | Florida | Flagler | 12035 | 27754 | 413 | 0 | 29.45933576 | -81.31508595 | 2022-11-26 04:21:11 | Flagler, Florida, US | |
3524149 | 3524149 | 2022-11-24 | US | Florida | Flagler | 12035 | 27754 | 413 | 0 | 29.45933576 | -81.31508595 | 2022-11-25 04:21:06 | Flagler, Florida, US | |
3312932 | 3312932 | 2022-11-23 | US | Florida | Flagler | 12035 | 27754 | 413 | 0 | 29.45933576 | -81.31508595 | 2022-11-24 04:21:09 | Flagler, Florida, US | |
1620973 | 1620973 | 2022-11-22 | US | Florida | Flagler | 12035 | 27754 | 413 | 0 | 29.45933576 | -81.31508595 | 2022-11-23 04:21:06 | Flagler, Florida, US | |
3460861 | 3460861 | 2022-11-21 | US | Florida | Flagler | 12035 | 27754 | 413 | 0 | 29.45933576 | -81.31508595 | 2022-11-22 04:20:47 | Flagler, Florida, US | |
1641046 | 1641046 | 2022-11-20 | US | Florida | Flagler | 12035 | 27754 | 413 | 0 | 29.45933576 | -81.31508595 | 2022-11-21 04:21:05 | Flagler, Florida, US | |
2064603 | 2064603 | 2022-11-19 | US | Florida | Flagler | 12035 | 27754 | 413 | 0 | 29.45933576 | -81.31508595 | 2022-11-20 04:21:08 | Flagler, Florida, US | |
1755997 | 1755997 | 2022-11-18 | US | Florida | Flagler | 12035 | 27754 | 413 | 0 | 29.45933576 | -81.31508595 | 2022-11-19 04:21:14 | Flagler, Florida, US | |
3026990 | 3026990 | 2022-11-17 | US | Florida | Flagler | 12035 | 27627 | 413 | 0 | 29.45933576 | -81.31508595 | 2022-11-18 04:21:15 | Flagler, Florida, US | |
2486701 | 2486701 | 2022-11-16 | US | Florida | Flagler | 12035 | 27627 | 413 | 0 | 29.45933576 | -81.31508595 | 2022-11-17 04:21:11 | Flagler, Florida, US | |
292712 | 292712 | 2022-11-15 | US | Florida | Flagler | 12035 | 27627 | 413 | 0 | 29.45933576 | -81.31508595 | 2022-11-16 04:21:09 | Flagler, Florida, US | |
541301 | 541301 | 2022-10-26 | US | Oklahoma | Comanche | 40031 | 37114 | 413 | 0 | 34.65973764 | -98.47195055 | 2022-10-27 04:22:01 | Comanche, Oklahoma, US | |
1832702 | 1832702 | 2022-10-25 | US | Oklahoma | Comanche | 40031 | 37114 | 413 | 0 | 34.65973764 | -98.47195055 | 2022-10-26 04:22:19 | Comanche, Oklahoma, US | |
796963 | 796963 | 2022-10-24 | US | Oklahoma | Comanche | 40031 | 37114 | 413 | 0 | 34.65973764 | -98.47195055 | 2022-10-25 04:21:53 | Comanche, Oklahoma, US | |
3279418 | 3279418 | 2022-10-23 | US | Oklahoma | Comanche | 40031 | 37114 | 413 | 0 | 34.65973764 | -98.47195055 | 2022-10-24 04:22:29 | Comanche, Oklahoma, US | |
2270456 | 2270456 | 2022-10-22 | US | Oklahoma | Comanche | 40031 | 37114 | 413 | 0 | 34.65973764 | -98.47195055 | 2022-10-23 04:22:46 | Comanche, Oklahoma, US | |
1594756 | 1594756 | 2022-10-21 | US | Oklahoma | Comanche | 40031 | 37114 | 413 | 0 | 34.65973764 | -98.47195055 | 2022-10-22 04:22:53 | Comanche, Oklahoma, US | |
2274472 | 2274472 | 2022-10-20 | US | Oklahoma | Comanche | 40031 | 37114 | 413 | 0 | 34.65973764 | -98.47195055 | 2022-10-21 04:22:23 | Comanche, Oklahoma, US | |
200807 | 200807 | 2022-10-19 | US | Oklahoma | Comanche | 40031 | 37076 | 413 | 0 | 34.65973764 | -98.47195055 | 2022-10-20 04:22:59 | Comanche, Oklahoma, US | |
2759468 | 2759468 | 2022-10-18 | US | Oklahoma | Comanche | 40031 | 37076 | 413 | 0 | 34.65973764 | -98.47195055 | 2022-10-19 04:22:26 | Comanche, Oklahoma, US | |
2027302 | 2027302 | 2022-10-17 | US | Oklahoma | Comanche | 40031 | 37076 | 413 | 0 | 34.65973764 | -98.47195055 | 2022-10-18 04:22:42 | Comanche, Oklahoma, US | |
2027600 | 2027600 | 2022-10-17 | US | South Carolina | Sumter | 45085 | 32937 | 413 | 0 | 33.91826534 | -80.37942316 | 2022-10-18 04:22:42 | Sumter, South Carolina, US | |
2162080 | 2162080 | 2022-10-16 | US | Oklahoma | Comanche | 40031 | 37076 | 413 | 0 | 34.65973764 | -98.47195055 | 2022-10-17 04:20:31 | Comanche, Oklahoma, US | |
2162378 | 2162378 | 2022-10-16 | US | South Carolina | Sumter | 45085 | 32937 | 413 | 0 | 33.91826534 | -80.37942316 | 2022-10-17 04:20:31 | Sumter, South Carolina, US | |
518277 | 518277 | 2022-10-15 | US | Oklahoma | Comanche | 40031 | 37076 | 413 | 0 | 34.65973764 | -98.47195055 | 2022-10-16 04:22:39 | Comanche, Oklahoma, US | |
518575 | 518575 | 2022-10-15 | US | South Carolina | Sumter | 45085 | 32937 | 413 | 0 | 33.91826534 | -80.37942316 | 2022-10-16 04:22:39 | Sumter, South Carolina, US | |
2035334 | 2035334 | 2022-10-14 | US | Oklahoma | Comanche | 40031 | 37076 | 413 | 0 | 34.65973764 | -98.47195055 | 2022-10-15 04:22:00 | Comanche, Oklahoma, US | |
2035632 | 2035632 | 2022-10-14 | US | South Carolina | Sumter | 45085 | 32937 | 413 | 0 | 33.91826534 | -80.37942316 | 2022-10-15 04:22:00 | Sumter, South Carolina, US | |
3756022 | 3756022 | 2022-10-13 | US | Oklahoma | Comanche | 40031 | 37076 | 413 | 0 | 34.65973764 | -98.47195055 | 2022-10-14 04:22:28 | Comanche, Oklahoma, US | |
3756320 | 3756320 | 2022-10-13 | US | South Carolina | Sumter | 45085 | 32937 | 413 | 0 | 33.91826534 | -80.37942316 | 2022-10-14 04:22:28 | Sumter, South Carolina, US | |
3756953 | 3756953 | 2022-10-13 | US | West Virginia | Cabell | 54011 | 32472 | 413 | 0 | 38.42424062 | -82.23855912 | 2022-10-14 04:22:28 | Cabell, West Virginia, US | |
3217145 | 3217145 | 2022-10-12 | US | South Carolina | Sumter | 45085 | 32937 | 413 | 0 | 33.91826534 | -80.37942316 | 2022-10-13 04:22:39 | Sumter, South Carolina, US | |
3217778 | 3217778 | 2022-10-12 | US | West Virginia | Cabell | 54011 | 32467 | 413 | 0 | 38.42424062 | -82.23855912 | 2022-10-13 04:22:39 | Cabell, West Virginia, US | |
3252994 | 3252994 | 2022-10-11 | US | South Carolina | Sumter | 45085 | 32937 | 413 | 0 | 33.91826534 | -80.37942316 | 2022-10-12 04:22:51 | Sumter, South Carolina, US | |
3253627 | 3253627 | 2022-10-11 | US | West Virginia | Cabell | 54011 | 32466 | 413 | 0 | 38.42424062 | -82.23855912 | 2022-10-12 04:22:51 | Cabell, West Virginia, US | |
2970886 | 2970886 | 2022-10-10 | US | West Virginia | Cabell | 54011 | 32443 | 413 | 0 | 38.42424062 | -82.23855912 | 2022-10-11 04:23:05 | Cabell, West Virginia, US | |
3100922 | 3100922 | 2022-10-09 | US | West Virginia | Cabell | 54011 | 32443 | 413 | 0 | 38.42424062 | -82.23855912 | 2022-10-10 04:22:32 | Cabell, West Virginia, US | |
4006147 | 4006147 | 2022-10-08 | US | West Virginia | Cabell | 54011 | 32443 | 413 | 0 | 38.42424062 | -82.23855912 | 2022-10-09 04:21:16 | Cabell, West Virginia, US | |
399744 | 399744 | 2022-10-07 | US | West Virginia | Cabell | 54011 | 32443 | 413 | 0 | 38.42424062 | -82.23855912 | 2022-10-08 04:22:56 | Cabell, West Virginia, US | |
2532861 | 2532861 | 2022-10-06 | US | West Virginia | Cabell | 54011 | 32437 | 413 | 0 | 38.42424062 | -82.23855912 | 2022-10-07 04:23:08 | Cabell, West Virginia, US | |
1814255 | 1814255 | 2022-10-05 | US | West Virginia | Cabell | 54011 | 32432 | 413 | 0 | 38.42424062 | -82.23855912 | 2022-10-06 04:21:22 | Cabell, West Virginia, US | |
131828 | 131828 | 2022-10-04 | US | Indiana | Clark | 18019 | 37084 | 413 | 0 | 38.48015445 | -85.70510334 | 2022-10-05 04:23:06 | Clark, Indiana, US | |
134229 | 134229 | 2022-10-04 | US | West Virginia | Cabell | 54011 | 32423 | 413 | 0 | 38.42424062 | -82.23855912 | 2022-10-05 04:23:06 | Cabell, West Virginia, US | |
2686775 | 2686775 | 2022-10-03 | US | Indiana | Clark | 18019 | 37084 | 413 | 0 | 38.48015445 | -85.70510334 | 2022-10-04 04:22:55 | Clark, Indiana, US | |
2260842 | 2260842 | 2022-10-02 | US | Indiana | Clark | 18019 | 37084 | 413 | 0 | 38.48015445 | -85.70510334 | 2022-10-03 04:23:11 | Clark, Indiana, US | |
2996368 | 2996368 | 2022-10-01 | US | Indiana | Clark | 18019 | 37084 | 413 | 0 | 38.48015445 | -85.70510334 | 2022-10-02 04:21:23 | Clark, Indiana, US | |
854694 | 854694 | 2022-09-30 | US | Indiana | Clark | 18019 | 37084 | 413 | 0 | 38.48015445 | -85.70510334 | 2022-10-01 04:23:01 | Clark, Indiana, US | |
2376620 | 2376620 | 2022-09-29 | US | Indiana | Clark | 18019 | 37084 | 413 | 0 | 38.48015445 | -85.70510334 | 2022-09-30 04:23:09 | Clark, Indiana, US | |
1561171 | 1561171 | 2022-09-28 | US | Indiana | Clark | 18019 | 37084 | 413 | 0 | 38.48015445 | -85.70510334 | 2022-09-29 04:22:34 | Clark, Indiana, US | |
1563201 | 1563201 | 2022-09-28 | US | Texas | Guadalupe | 48187 | 43510 | 413 | 0 | 29.58165339 | -97.94786822 | 2022-09-29 04:22:34 | Guadalupe, Texas, US | |
3995714 | 3995714 | 2022-09-27 | US | Indiana | Clark | 18019 | 37045 | 413 | 0 | 38.48015445 | -85.70510334 | 2022-09-28 04:23:01 | Clark, Indiana, US | |
3997744 | 3997744 | 2022-09-27 | US | Texas | Guadalupe | 48187 | 43510 | 413 | 0 | 29.58165339 | -97.94786822 | 2022-09-28 04:23:01 | Guadalupe, Texas, US | |
2770042 | 2770042 | 2022-09-26 | US | Indiana | Clark | 18019 | 37045 | 413 | 0 | 38.48015445 | -85.70510334 | 2022-09-27 04:23:01 | Clark, Indiana, US | |
2772072 | 2772072 | 2022-09-26 | US | Texas | Guadalupe | 48187 | 43510 | 413 | 0 | 29.58165339 | -97.94786822 | 2022-09-27 04:23:01 | Guadalupe, Texas, US | |
1977695 | 1977695 | 2022-09-25 | US | Indiana | Clark | 18019 | 37007 | 413 | 0 | 38.48015445 | -85.70510334 | 2022-09-26 04:20:52 | Clark, Indiana, US | |
1979725 | 1979725 | 2022-09-25 | US | Texas | Guadalupe | 48187 | 43476 | 413 | 0 | 29.58165339 | -97.94786822 | 2022-09-26 04:20:52 | Guadalupe, Texas, US | |
2650862 | 2650862 | 2022-09-24 | US | Indiana | Clark | 18019 | 37007 | 413 | 0 | 38.48015445 | -85.70510334 | 2022-09-25 04:23:31 | Clark, Indiana, US | |
2652892 | 2652892 | 2022-09-24 | US | Texas | Guadalupe | 48187 | 43476 | 413 | 0 | 29.58165339 | -97.94786822 | 2022-09-25 04:23:31 | Guadalupe, Texas, US | |
385302 | 385302 | 2022-09-23 | US | Indiana | Clark | 18019 | 37007 | 413 | 0 | 38.48015445 | -85.70510334 | 2022-09-24 04:21:40 | Clark, Indiana, US | |
387332 | 387332 | 2022-09-23 | US | Texas | Guadalupe | 48187 | 43476 | 413 | 0 | 29.58165339 | -97.94786822 | 2022-09-24 04:21:40 | Guadalupe, Texas, US | |
1625368 | 1625368 | 2022-09-22 | US | Indiana | Clark | 18019 | 36976 | 413 | 0 | 38.48015445 | -85.70510334 | 2022-09-23 04:23:13 | Clark, Indiana, US | |
1627398 | 1627398 | 2022-09-22 | US | Texas | Guadalupe | 48187 | 43462 | 413 | 0 | 29.58165339 | -97.94786822 | 2022-09-23 04:23:13 | Guadalupe, Texas, US | |
1371572 | 1371572 | 2022-09-21 | US | Indiana | Clark | 18019 | 36976 | 413 | 0 | 38.48015445 | -85.70510334 | 2022-09-22 04:22:56 | Clark, Indiana, US | |
1372094 | 1372094 | 2022-09-21 | US | Massachusetts | Berkshire | 25003 | 31308 | 413 | 0 | 42.37428441 | -73.20524838 | 2022-09-22 04:22:56 | Berkshire, Massachusetts, US | |
1373602 | 1373602 | 2022-09-21 | US | Texas | Guadalupe | 48187 | 43462 | 413 | 0 | 29.58165339 | -97.94786822 | 2022-09-22 04:22:56 | Guadalupe, Texas, US | |
2018324 | 2018324 | 2022-09-20 | US | Massachusetts | Berkshire | 25003 | 31308 | 413 | 0 | 42.37428441 | -73.20524838 | 2022-09-21 04:23:22 | Berkshire, Massachusetts, US | |
2019832 | 2019832 | 2022-09-20 | US | Texas | Guadalupe | 48187 | 43430 | 413 | 0 | 29.58165339 | -97.94786822 | 2022-09-21 04:23:22 | Guadalupe, Texas, US | |
3572155 | 3572155 | 2022-09-19 | US | Maine | Cumberland | 23005 | 60032 | 413 | 0 | 43.8370751 | -70.37226999 | 2022-09-20 04:22:48 | Cumberland, Maine, US | |
3572197 | 3572197 | 2022-09-19 | US | Massachusetts | Berkshire | 25003 | 31308 | 413 | 0 | 42.37428441 | -73.20524838 | 2022-09-20 04:22:48 | Berkshire, Massachusetts, US | |
3573705 | 3573705 | 2022-09-19 | US | Texas | Guadalupe | 48187 | 43430 | 413 | 0 | 29.58165339 | -97.94786822 | 2022-09-20 04:22:48 | Guadalupe, Texas, US | |
420894 | 420894 | 2022-09-18 | US | Maine | Cumberland | 23005 | 60032 | 413 | 0 | 43.8370751 | -70.37226999 | 2022-09-19 04:21:49 | Cumberland, Maine, US | |
420936 | 420936 | 2022-09-18 | US | Massachusetts | Berkshire | 25003 | 31308 | 413 | 0 | 42.37428441 | -73.20524838 | 2022-09-19 04:21:49 | Berkshire, Massachusetts, US | |
422444 | 422444 | 2022-09-18 | US | Texas | Guadalupe | 48187 | 43368 | 413 | 0 | 29.58165339 | -97.94786822 | 2022-09-19 04:21:49 | Guadalupe, Texas, US | |
3374918 | 3374918 | 2022-09-17 | US | Maine | Cumberland | 23005 | 60032 | 413 | 0 | 43.8370751 | -70.37226999 | 2022-09-18 04:22:50 | Cumberland, Maine, US | |
3374960 | 3374960 | 2022-09-17 | US | Massachusetts | Berkshire | 25003 | 31308 | 413 | 0 | 42.37428441 | -73.20524838 | 2022-09-18 04:22:50 | Berkshire, Massachusetts, US | |
3376468 | 3376468 | 2022-09-17 | US | Texas | Guadalupe | 48187 | 43368 | 413 | 0 | 29.58165339 | -97.94786822 | 2022-09-18 04:22:50 | Guadalupe, Texas, US | |
2357026 | 2357026 | 2022-09-16 | US | Maine | Cumberland | 23005 | 59995 | 413 | 0 | 43.8370751 | -70.37226999 | 2022-09-17 04:20:19 | Cumberland, Maine, US | |
2357068 | 2357068 | 2022-09-16 | US | Massachusetts | Berkshire | 25003 | 31308 | 413 | 0 | 42.37428441 | -73.20524838 | 2022-09-17 04:20:19 | Berkshire, Massachusetts, US | |
2358576 | 2358576 | 2022-09-16 | US | Texas | Guadalupe | 48187 | 43368 | 413 | 0 | 29.58165339 | -97.94786822 | 2022-09-17 04:20:19 | Guadalupe, Texas, US | |
3988183 | 3988183 | 2022-09-15 | US | Maine | Cumberland | 23005 | 59936 | 413 | 0 | 43.8370751 | -70.37226999 | 2022-09-16 04:21:19 | Cumberland, Maine, US | |
3988225 | 3988225 | 2022-09-15 | US | Massachusetts | Berkshire | 25003 | 31308 | 413 | 0 | 42.37428441 | -73.20524838 | 2022-09-16 04:21:19 | Berkshire, Massachusetts, US | |
3989733 | 3989733 | 2022-09-15 | US | Texas | Guadalupe | 48187 | 43322 | 413 | 0 | 29.58165339 | -97.94786822 | 2022-09-16 04:21:19 | Guadalupe, Texas, 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]);