johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
181 rows where country_or_region = "US" and deaths = 939 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 26
- South Carolina 23
- North Carolina 19
- Pennsylvania 16
- Massachusetts 15
- Florida 12
- Ohio 11
- Arizona 9
- Arkansas 8
- California 8
- New Jersey 8
- Missouri 7
- Tennessee 7
- Indiana 6
- New Hampshire 6
- Louisiana 4
- Colorado 3
- New York 3
- Virginia 3
- Alabama 2
- Georgia 2
- Idaho 2
- New Mexico 2
- Washington 2
- Maryland 1
- Texas 1
- Wisconsin 1
country_or_region 1
- US · 181 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2558911 | 2558911 | 2022-11-29 | US | North Carolina | Gaston | 37071 | 77369 | 939 | 0 | 35.29373559 | -81.17477045 | 2022-11-30 04:21:07 | Gaston, North Carolina, US | |
1241985 | 1241985 | 2022-11-28 | US | North Carolina | Gaston | 37071 | 77369 | 939 | 0 | 35.29373559 | -81.17477045 | 2022-11-29 04:21:05 | Gaston, North Carolina, US | |
3553973 | 3553973 | 2022-11-27 | US | North Carolina | Gaston | 37071 | 77369 | 939 | 0 | 35.29373559 | -81.17477045 | 2022-11-28 04:21:02 | Gaston, North Carolina, US | |
2102453 | 2102453 | 2022-11-26 | US | North Carolina | Gaston | 37071 | 77369 | 939 | 0 | 35.29373559 | -81.17477045 | 2022-11-27 04:21:05 | Gaston, North Carolina, US | |
489944 | 489944 | 2022-11-25 | US | North Carolina | Gaston | 37071 | 77369 | 939 | 0 | 35.29373559 | -81.17477045 | 2022-11-26 04:21:11 | Gaston, North Carolina, US | |
3525773 | 3525773 | 2022-11-24 | US | North Carolina | Gaston | 37071 | 77369 | 939 | 0 | 35.29373559 | -81.17477045 | 2022-11-25 04:21:06 | Gaston, North Carolina, US | |
3314556 | 3314556 | 2022-11-23 | US | North Carolina | Gaston | 37071 | 77369 | 939 | 0 | 35.29373559 | -81.17477045 | 2022-11-24 04:21:09 | Gaston, North Carolina, US | |
1622597 | 1622597 | 2022-11-22 | US | North Carolina | Gaston | 37071 | 77241 | 939 | 0 | 35.29373559 | -81.17477045 | 2022-11-23 04:21:06 | Gaston, North Carolina, US | |
3462485 | 3462485 | 2022-11-21 | US | North Carolina | Gaston | 37071 | 77241 | 939 | 0 | 35.29373559 | -81.17477045 | 2022-11-22 04:20:47 | Gaston, North Carolina, US | |
1642670 | 1642670 | 2022-11-20 | US | North Carolina | Gaston | 37071 | 77241 | 939 | 0 | 35.29373559 | -81.17477045 | 2022-11-21 04:21:05 | Gaston, North Carolina, US | |
2066227 | 2066227 | 2022-11-19 | US | North Carolina | Gaston | 37071 | 77241 | 939 | 0 | 35.29373559 | -81.17477045 | 2022-11-20 04:21:08 | Gaston, North Carolina, US | |
1757621 | 1757621 | 2022-11-18 | US | North Carolina | Gaston | 37071 | 77241 | 939 | 0 | 35.29373559 | -81.17477045 | 2022-11-19 04:21:14 | Gaston, North Carolina, US | |
3028614 | 3028614 | 2022-11-17 | US | North Carolina | Gaston | 37071 | 77241 | 939 | 0 | 35.29373559 | -81.17477045 | 2022-11-18 04:21:15 | Gaston, North Carolina, US | |
2488325 | 2488325 | 2022-11-16 | US | North Carolina | Gaston | 37071 | 77241 | 939 | 0 | 35.29373559 | -81.17477045 | 2022-11-17 04:21:11 | Gaston, North Carolina, US | |
2506529 | 2506529 | 2022-11-10 | US | Arkansas | Benton | 5007 | 74414 | 939 | 0 | 36.33644656 | -94.25680817 | 2022-11-11 04:21:22 | Benton, Arkansas, US | |
2431404 | 2431404 | 2022-11-09 | US | Arkansas | Benton | 5007 | 74399 | 939 | 0 | 36.33644656 | -94.25680817 | 2022-11-10 04:21:16 | Benton, Arkansas, US | |
480060 | 480060 | 2022-11-08 | US | Arkansas | Benton | 5007 | 74358 | 939 | 0 | 36.33644656 | -94.25680817 | 2022-11-09 04:21:22 | Benton, Arkansas, US | |
482260 | 482260 | 2022-11-08 | US | Pennsylvania | Cumberland | 42041 | 59511 | 939 | 0 | 40.1625372 | -77.26130755 | 2022-11-09 04:21:22 | Cumberland, Pennsylvania, US | |
2439210 | 2439210 | 2022-11-07 | US | Arkansas | Benton | 5007 | 74336 | 939 | 0 | 36.33644656 | -94.25680817 | 2022-11-08 04:21:21 | Benton, Arkansas, US | |
2441410 | 2441410 | 2022-11-07 | US | Pennsylvania | Cumberland | 42041 | 59511 | 939 | 0 | 40.1625372 | -77.26130755 | 2022-11-08 04:21:21 | Cumberland, Pennsylvania, US | |
1050308 | 1050308 | 2022-11-06 | US | Arkansas | Benton | 5007 | 74333 | 939 | 0 | 36.33644656 | -94.25680817 | 2022-11-07 04:21:26 | Benton, Arkansas, US | |
1052508 | 1052508 | 2022-11-06 | US | Pennsylvania | Cumberland | 42041 | 59511 | 939 | 0 | 40.1625372 | -77.26130755 | 2022-11-07 04:21:26 | Cumberland, Pennsylvania, US | |
620532 | 620532 | 2022-11-05 | US | Pennsylvania | Cumberland | 42041 | 59511 | 939 | 0 | 40.1625372 | -77.26130755 | 2022-11-06 04:21:24 | Cumberland, Pennsylvania, US | |
1025036 | 1025036 | 2022-11-04 | US | Pennsylvania | Cumberland | 42041 | 59511 | 939 | 0 | 40.1625372 | -77.26130755 | 2022-11-05 04:21:52 | Cumberland, Pennsylvania, US | |
433626 | 433626 | 2022-11-03 | US | New York | Rockland | 36087 | 110902 | 939 | 0 | 41.15027894 | -74.02560498 | 2022-11-04 04:22:11 | Rockland, New York, US | |
434027 | 434027 | 2022-11-03 | US | Pennsylvania | Cumberland | 42041 | 59511 | 939 | 0 | 40.1625372 | -77.26130755 | 2022-11-04 04:22:11 | Cumberland, Pennsylvania, US | |
852269 | 852269 | 2022-11-02 | US | Pennsylvania | Cumberland | 42041 | 59511 | 939 | 0 | 40.1625372 | -77.26130755 | 2022-11-03 04:22:05 | Cumberland, Pennsylvania, US | |
3756913 | 3756913 | 2022-10-13 | US | Washington | Clark | 53011 | 106112 | 939 | 0 | 45.77568046 | -122.4829204 | 2022-10-14 04:22:28 | Clark, Washington, US | |
3217738 | 3217738 | 2022-10-12 | US | Washington | Clark | 53011 | 106112 | 939 | 0 | 45.77568046 | -122.4829204 | 2022-10-13 04:22:39 | Clark, Washington, US | |
3995094 | 3995094 | 2022-09-27 | US | Arizona | Navajo | 4017 | 44097 | 939 | 0 | 35.3997715 | -110.3218983 | 2022-09-28 04:23:01 | Navajo, Arizona, US | |
2769422 | 2769422 | 2022-09-26 | US | Arizona | Navajo | 4017 | 44097 | 939 | 0 | 35.3997715 | -110.3218983 | 2022-09-27 04:23:01 | Navajo, Arizona, US | |
1977075 | 1977075 | 2022-09-25 | US | Arizona | Navajo | 4017 | 44097 | 939 | 0 | 35.3997715 | -110.3218983 | 2022-09-26 04:20:52 | Navajo, Arizona, US | |
2650242 | 2650242 | 2022-09-24 | US | Arizona | Navajo | 4017 | 44097 | 939 | 0 | 35.3997715 | -110.3218983 | 2022-09-25 04:23:31 | Navajo, Arizona, US | |
384682 | 384682 | 2022-09-23 | US | Arizona | Navajo | 4017 | 44097 | 939 | 0 | 35.3997715 | -110.3218983 | 2022-09-24 04:21:40 | Navajo, Arizona, US | |
1624748 | 1624748 | 2022-09-22 | US | Arizona | Navajo | 4017 | 44097 | 939 | 0 | 35.3997715 | -110.3218983 | 2022-09-23 04:23:13 | Navajo, Arizona, US | |
1370952 | 1370952 | 2022-09-21 | US | Arizona | Navajo | 4017 | 44097 | 939 | 0 | 35.3997715 | -110.3218983 | 2022-09-22 04:22:56 | Navajo, Arizona, US | |
3376353 | 3376353 | 2022-09-17 | US | Tennessee | Rutherford | 47149 | 109753 | 939 | 0 | 35.84591405 | -86.4107263 | 2022-09-18 04:22:50 | Rutherford, Tennessee, US | |
2358461 | 2358461 | 2022-09-16 | US | Tennessee | Rutherford | 47149 | 109732 | 939 | 0 | 35.84591405 | -86.4107263 | 2022-09-17 04:20:19 | Rutherford, Tennessee, US | |
3989618 | 3989618 | 2022-09-15 | US | Tennessee | Rutherford | 47149 | 109673 | 939 | 0 | 35.84591405 | -86.4107263 | 2022-09-16 04:21:19 | Rutherford, Tennessee, US | |
2009269 | 2009269 | 2022-08-04 | US | California | San Francisco | 6075 | 183046 | 939 | 0 | 37.75215114 | -122.4385672 | 2022-08-05 04:20:52 | San Francisco, California, US | |
1098696 | 1098696 | 2022-08-03 | US | California | San Francisco | 6075 | 182178 | 939 | 0 | 37.75215114 | -122.4385672 | 2022-08-04 04:20:58 | San Francisco, California, US | |
1405621 | 1405621 | 2022-08-02 | US | California | San Francisco | 6075 | 182163 | 939 | 0 | 37.75215114 | -122.4385672 | 2022-08-03 04:20:59 | San Francisco, California, US | |
3111645 | 3111645 | 2022-07-13 | US | New Hampshire | Hillsborough | 33011 | 107547 | 939 | 0 | 42.91537785 | -71.7200253 | 2022-07-14 04:20:57 | Hillsborough, New Hampshire, US | |
632068 | 632068 | 2022-07-12 | US | New Hampshire | Hillsborough | 33011 | 107489 | 939 | 0 | 42.91537785 | -71.7200253 | 2022-07-13 04:20:58 | Hillsborough, New Hampshire, US | |
1213712 | 1213712 | 2022-07-11 | US | New Hampshire | Hillsborough | 33011 | 107438 | 939 | 0 | 42.91537785 | -71.7200253 | 2022-07-12 04:20:51 | Hillsborough, New Hampshire, US | |
2791194 | 2791194 | 2022-07-10 | US | New Hampshire | Hillsborough | 33011 | 107282 | 939 | 0 | 42.91537785 | -71.7200253 | 2022-07-11 04:20:46 | Hillsborough, New Hampshire, US | |
144147 | 144147 | 2022-07-09 | US | New Hampshire | Hillsborough | 33011 | 107282 | 939 | 0 | 42.91537785 | -71.7200253 | 2022-07-10 04:20:54 | Hillsborough, New Hampshire, US | |
1419247 | 1419247 | 2022-07-08 | US | New Hampshire | Hillsborough | 33011 | 107282 | 939 | 0 | 42.91537785 | -71.7200253 | 2022-07-09 04:20:59 | Hillsborough, New Hampshire, US | |
3581982 | 3581982 | 2022-06-02 | US | Virginia | Henrico | 51087 | 70160 | 939 | 0 | 37.53460572 | -77.39326555 | 2022-06-03 04:20:58 | Henrico, Virginia, US | |
974275 | 974275 | 2022-06-01 | US | Virginia | Henrico | 51087 | 70019 | 939 | 0 | 37.53460572 | -77.39326555 | 2022-06-02 05:20:39 | Henrico, Virginia, US | |
232582 | 232582 | 2022-05-31 | US | Virginia | Henrico | 51087 | 69928 | 939 | 0 | 37.53460572 | -77.39326555 | 2022-06-01 04:20:55 | Henrico, Virginia, US | |
3186543 | 3186543 | 2022-05-30 | US | California | Imperial | 6025 | 67339 | 939 | 0 | 33.0393082 | -115.3669042 | 2022-05-31 04:20:51 | Imperial, California, US | |
3198692 | 3198692 | 2022-05-29 | US | California | Imperial | 6025 | 67203 | 939 | 0 | 33.0393082 | -115.3669042 | 2022-05-30 04:20:50 | Imperial, California, US | |
2725570 | 2725570 | 2022-05-28 | US | California | Imperial | 6025 | 67193 | 939 | 0 | 33.0393082 | -115.3669042 | 2022-05-29 04:20:53 | Imperial, California, US | |
1314751 | 1314751 | 2022-05-27 | US | California | Imperial | 6025 | 67188 | 939 | 0 | 33.0393082 | -115.3669042 | 2022-05-28 04:21:07 | Imperial, California, US | |
1851958 | 1851958 | 2022-05-26 | US | Missouri | St. Charles | 29183 | 96438 | 939 | 0 | 38.77875681 | -90.66662425 | 2022-05-27 04:20:56 | St. Charles, Missouri, US | |
2049834 | 2049834 | 2022-05-25 | US | Missouri | St. Charles | 29183 | 96438 | 939 | 0 | 38.77875681 | -90.66662425 | 2022-05-26 04:20:50 | St. Charles, Missouri, US | |
3001272 | 3001272 | 2022-05-24 | US | Missouri | St. Charles | 29183 | 96438 | 939 | 0 | 38.77875681 | -90.66662425 | 2022-05-25 04:20:56 | St. Charles, Missouri, US | |
3594993 | 3594993 | 2022-05-23 | US | Missouri | St. Charles | 29183 | 96438 | 939 | 0 | 38.77875681 | -90.66662425 | 2022-05-24 04:20:57 | St. Charles, Missouri, US | |
623845 | 623845 | 2022-05-22 | US | Missouri | St. Charles | 29183 | 96438 | 939 | 0 | 38.77875681 | -90.66662425 | 2022-05-26 04:20:50 | St. Charles, Missouri, US | |
1111541 | 1111541 | 2022-05-21 | US | Missouri | St. Charles | 29183 | 96438 | 939 | 0 | 38.77875681 | -90.66662425 | 2022-05-22 04:20:52 | St. Charles, Missouri, US | |
1171165 | 1171165 | 2022-05-20 | US | Missouri | St. Charles | 29183 | 96438 | 939 | 0 | 38.77875681 | -90.66662425 | 2022-05-21 04:20:58 | St. Charles, Missouri, US | |
466206 | 466206 | 2022-05-02 | US | South Carolina | Charleston | 45019 | 112277 | 939 | 0 | 32.82487866 | -79.96512315 | 2022-05-03 04:21:00 | Charleston, South Carolina, US | |
3918845 | 3918845 | 2022-05-01 | US | South Carolina | Charleston | 45019 | 112277 | 939 | 0 | 32.82487866 | -79.96512315 | 2022-05-02 04:21:10 | Charleston, South Carolina, US | |
2843649 | 2843649 | 2022-04-30 | US | South Carolina | Charleston | 45019 | 112277 | 939 | 0 | 32.82487866 | -79.96512315 | 2022-05-01 04:20:57 | Charleston, South Carolina, US | |
1159962 | 1159962 | 2022-04-29 | US | South Carolina | Charleston | 45019 | 112277 | 939 | 0 | 32.82487866 | -79.96512315 | 2022-04-30 04:21:05 | Charleston, South Carolina, US | |
1699144 | 1699144 | 2022-04-28 | US | South Carolina | Charleston | 45019 | 112277 | 939 | 0 | 32.82487866 | -79.96512315 | 2022-04-29 04:20:59 | Charleston, South Carolina, US | |
3854627 | 3854627 | 2022-04-27 | US | South Carolina | Charleston | 45019 | 112033 | 939 | 0 | 32.82487866 | -79.96512315 | 2022-04-28 04:20:47 | Charleston, South Carolina, US | |
3854657 | 3854657 | 2022-04-27 | US | South Carolina | Richland | 45079 | 122419 | 939 | 0 | 34.01791263 | -80.90267209 | 2022-04-28 04:20:47 | Richland, South Carolina, US | |
1329057 | 1329057 | 2022-04-26 | US | South Carolina | Charleston | 45019 | 112033 | 939 | 0 | 32.82487866 | -79.96512315 | 2022-04-27 04:20:52 | Charleston, South Carolina, US | |
1329087 | 1329087 | 2022-04-26 | US | South Carolina | Richland | 45079 | 122419 | 939 | 0 | 34.01791263 | -80.90267209 | 2022-04-27 04:20:52 | Richland, South Carolina, US | |
3725011 | 3725011 | 2022-04-25 | US | South Carolina | Charleston | 45019 | 112033 | 939 | 0 | 32.82487866 | -79.96512315 | 2022-04-26 04:20:51 | Charleston, South Carolina, US | |
3725041 | 3725041 | 2022-04-25 | US | South Carolina | Richland | 45079 | 122419 | 939 | 0 | 34.01791263 | -80.90267209 | 2022-04-26 04:20:51 | Richland, South Carolina, US | |
2031579 | 2031579 | 2022-04-24 | US | South Carolina | Charleston | 45019 | 112033 | 939 | 0 | 32.82487866 | -79.96512315 | 2022-04-25 04:20:56 | Charleston, South Carolina, US | |
2031609 | 2031609 | 2022-04-24 | US | South Carolina | Richland | 45079 | 122419 | 939 | 0 | 34.01791263 | -80.90267209 | 2022-04-25 04:20:56 | Richland, South Carolina, US | |
749154 | 749154 | 2022-04-23 | US | South Carolina | Charleston | 45019 | 112033 | 939 | 0 | 32.82487866 | -79.96512315 | 2022-04-24 04:20:56 | Charleston, South Carolina, US | |
749184 | 749184 | 2022-04-23 | US | South Carolina | Richland | 45079 | 122419 | 939 | 0 | 34.01791263 | -80.90267209 | 2022-04-24 04:20:56 | Richland, South Carolina, US | |
3439639 | 3439639 | 2022-04-22 | US | South Carolina | Charleston | 45019 | 112033 | 939 | 0 | 32.82487866 | -79.96512315 | 2022-04-23 04:20:50 | Charleston, South Carolina, US | |
3439669 | 3439669 | 2022-04-22 | US | South Carolina | Richland | 45079 | 122419 | 939 | 0 | 34.01791263 | -80.90267209 | 2022-04-23 04:20:50 | Richland, South Carolina, US | |
2895224 | 2895224 | 2022-04-21 | US | South Carolina | Charleston | 45019 | 112033 | 939 | 0 | 32.82487866 | -79.96512315 | 2022-04-22 04:20:45 | Charleston, South Carolina, US | |
2895254 | 2895254 | 2022-04-21 | US | South Carolina | Richland | 45079 | 122419 | 939 | 0 | 34.01791263 | -80.90267209 | 2022-04-22 04:20:45 | Richland, South Carolina, US | |
2310096 | 2310096 | 2022-04-20 | US | South Carolina | Charleston | 45019 | 112033 | 939 | 0 | 32.82487866 | -79.96512315 | 2022-04-21 04:20:46 | Charleston, South Carolina, US | |
2310126 | 2310126 | 2022-04-20 | US | South Carolina | Richland | 45079 | 122419 | 939 | 0 | 34.01791263 | -80.90267209 | 2022-04-21 04:20:46 | Richland, South Carolina, US | |
2254235 | 2254235 | 2022-04-19 | US | South Carolina | Charleston | 45019 | 112033 | 939 | 0 | 32.82487866 | -79.96512315 | 2022-04-20 04:20:45 | Charleston, South Carolina, US | |
2254265 | 2254265 | 2022-04-19 | US | South Carolina | Richland | 45079 | 122419 | 939 | 0 | 34.01791263 | -80.90267209 | 2022-04-20 04:20:45 | Richland, South Carolina, US | |
1723001 | 1723001 | 2022-03-25 | US | Ohio | Trumbull | 39155 | 41441 | 939 | 0 | 41.31735028 | -80.76109643 | 2022-03-26 04:20:23 | Trumbull, Ohio, US | |
1468489 | 1468489 | 2022-03-24 | US | Alabama | Madison | 1089 | 88955 | 939 | 0 | 34.76327133 | -86.55069633 | 2022-03-25 04:20:46 | Madison, Alabama, US | |
1470618 | 1470618 | 2022-03-24 | US | Ohio | Trumbull | 39155 | 41441 | 939 | 0 | 41.31735028 | -80.76109643 | 2022-03-25 04:20:46 | Trumbull, Ohio, US | |
3022663 | 3022663 | 2022-03-23 | US | Alabama | Madison | 1089 | 88948 | 939 | 0 | 34.76327133 | -86.55069633 | 2022-03-24 04:20:43 | Madison, Alabama, US | |
3024792 | 3024792 | 2022-03-23 | US | Ohio | Trumbull | 39155 | 41375 | 939 | 0 | 41.31735028 | -80.76109643 | 2022-03-24 04:20:43 | Trumbull, Ohio, US | |
2142840 | 2142840 | 2022-03-09 | US | Pennsylvania | Dauphin | 42043 | 58832 | 939 | 0 | 40.41377078 | -76.77993242 | 2022-03-10 04:20:48 | Dauphin, Pennsylvania, US | |
922351 | 922351 | 2022-03-08 | US | Pennsylvania | Dauphin | 42043 | 58821 | 939 | 0 | 40.41377078 | -76.77993242 | 2022-03-09 04:20:59 | Dauphin, Pennsylvania, US | |
1363269 | 1363269 | 2022-02-08 | US | Idaho | Ada | 16001 | 111361 | 939 | 0 | 43.4526575 | -116.24155159999998 | 2022-02-09 04:21:04 | Ada, Idaho, US | |
72007 | 72007 | 2022-02-07 | US | Idaho | Ada | 16001 | 110460 | 939 | 0 | 43.4526575 | -116.24155159999998 | 2022-02-08 04:21:15 | Ada, Idaho, US | |
2477549 | 2477549 | 2022-02-03 | US | Wisconsin | Waukesha | 55133 | 108698 | 939 | 0 | 43.01833055 | -88.30431188 | 2022-02-04 04:21:10 | Waukesha, Wisconsin, US | |
2659972 | 2659972 | 2022-01-31 | US | New Jersey | Somerset | 34035 | 64695 | 939 | 0 | 40.56465737 | -74.61683016 | 2022-02-01 04:21:11 | Somerset, New Jersey, US | |
3302389 | 3302389 | 2022-01-30 | US | New Jersey | Somerset | 34035 | 64625 | 939 | 0 | 40.56465737 | -74.61683016 | 2022-01-31 04:21:09 | Somerset, New Jersey, US | |
3064180 | 3064180 | 2022-01-29 | US | New Jersey | Somerset | 34035 | 64566 | 939 | 0 | 40.56465737 | -74.61683016 | 2022-01-30 04:21:26 | Somerset, New Jersey, US | |
3064485 | 3064485 | 2022-01-29 | US | Ohio | Lorain | 39093 | 64761 | 939 | 0 | 41.29553751 | -82.15083537 | 2022-01-30 04:21:26 | Lorain, Ohio, US | |
3427202 | 3427202 | 2022-01-21 | US | New York | Onondaga | 36067 | 96720 | 939 | 0 | 43.00491923 | -76.19971155 | 2022-01-22 04:21:13 | Onondaga, New York, 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]);