NewsSearch
Query the Bing news search engine.
Table Specific Information
Select
When querying this table, the Bing API requires the SearchTerms parameter. For example, to search Bing News for the term 'bing' use the following query:
SELECT * FROM NewsSearch WHERE SearchTerms = 'bing'
You can also specify a search safety level:
SELECT * FROM NewsSearch WHERE SearchTerms = 'bing' AND SafeSearch = 'Moderate'
Columns
| Name | Type | Description |
| Title | String | The title of the search result. |
| Description | String | The HTML title of the search result. |
| URL | String | The URL of the search result. |
| Thumbnail | String | The source of the search result. This often is the company name. |
| DatePublished | Datetime | The date of the search result. |
| Category | String | The news category. |
| ProviderName | String | The news provider. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| SearchTerms | String | The search expression. |
| Market | String | The type of the source that triggered the event.
The allowed values are ar-XA, bg-BG, cs-CZ, da-DK, de-AT, de-CH, de-DE, el-GR, en-AU, en-CA, en-G, en-ID, en-IE, en-IN, en-MY, en-NZ, en-PH, en-SG, en-US, en-XA, en-ZA, es-AR, es-CL, es-MX, es-US, es-XL, et-EE, fi-FI, fr-BE, fr-CA, fr-CH, fr-FR, he-IL, hr-HR, hu-HU, it-IT, ja-JP, ko-KR, lt-LT, lv-LV, nb-NO, nl-BE, nl-NL, pl-PL, pt-BR, pt-PT, ro-RO, ru-RU, sk-SK, sl-SI, sv-SE, th-TH, tr-TR, uk-UA, zh-CN, zh-HK, zh-TW. |
| SafeSearch | String | The search safety level.
The allowed values are Strict, Moderate, Off. |
| Country | String | A 2-character country code of the country where the results come from.
The allowed values are AR, AU, AT, BE, BR, CA, CL, DK, FI, FR, DE, HK, IN, ID, IE, IT, JP, KR, MY, MX, NL, NZ, NO, CN, PL, PT, PH, RU, SA, ZA, ES, SE, CH, TW, TR, GB, US. |
| Freshness | String | Filter images by when Bing discovered the image.
The allowed values are Day, Week, Month. |