WeatherByCity

WeatherByCity datasource lets you create subscriptions for weather updates like rain, snow or temperature drop etc. in any location. Hooks Query Language lets you customize what data and when you want to receive.

Input Output Credits Freshness
City WeatherStatus OpenWeatherMap 1 minute

What you can get from this API

  • Get an update when it rains in any location
  • Get an update on sudden temperature drop in any location
  • Get an update when it snows in any location

How to use

As every datasource at Hooks, you can choose to pull the data in your preferred format or to set up a webhook to receive the data when something happens.  

As we offer many datasources, we have developed a custom SQL-Like language (Hooks Query Language) to be able to query each datasource in the same format. To create a subscription the first thing you need to do is to define an HQL query and then send this query to create subscription endpoint.

WeatherByCity datasource has a mandatory parameter City and you can use an optional WHERE clause where you can filter the output data (WeatherStatus) in order to receive just the data you need. Hooks will then call your webhook once new data is available for your query.

The output data is an array of WeatherStatus, where every row represents the forecast for one hour, including the current hour (that is not a forecast and has the attribute is_current=true).

Step 1: Find a City

WeatherByCity datasource has a mandatory parameter City. You should specify the City you want to get updates for using the FROM clause. For example, to create a subscription for “Get an update 24 hours before it rains in San Francisco”  you can use the following query: 

SELECT * FROM WeatherByCity
(name = 'San Francisco' 
AND country.name = 'United States'
AND subdivision.type = 'State' 
AND subdivision.name = 'California') 
WHERE weather_conditions.main = 'Rain'
AND start_datetime.countdown = 86400

You can also use a city geonames id to create the same subscription:

SELECT * FROM WeatherByCity
(geonameid = '5391959') 
WHERE weather_conditions.main='Rain' 
AND start_datetime.countdown <= 86400

Please make sure that City id or name refers to the city you’re looking for and the city exists in our database. If you use a wrong or ambiguous name or id, the HQL query will return an error and explain the reason.

You can use an ambiguous query to search for the cities inside our database. Hooks will return an “Entity query is ambiguous” error and show you the list of possible values:

SELECT * FROM WeatherByCity
(name = 'San Francisco' AND country.name = 'United States')

This query will return a list of all cities with a name San Francisco located in the United States:

{
    "status": "error",
    "error": {
        "message": "entity query is ambiguous"
    },
    "ambiguous_entities": [
        {
            "_entity_type": "City",
            "_id": "Geoname_5391959",
            "admin1_code": "CA",
            "admin2_code": "075",
            "admin3_code": null,
            "admin4_code": null,
            "alternative_names": [
                "Franciscopolis",
                "Frisco",
                "Gorad San-Francyska",
                "Kapalakiko",
                "Khiu-kim-san",
                "Khiu-kîm-sân",
                "Lungsod ng San Francisco",
                "New Albion",
                "SF",
                "SFO",
                "San Francisco",
                "San Franciscu",
                "San Francisko",
                "San Fransisco",
                "San Fransiskas",
                "San Fransisko",
                "San Frantzisko",
                "San Phransisko",
                "San-Francisko",
                "San-Fransisko",
                "Sanfrancisko",
                "Sao Francisco",
                "São Francisco",
                "Yerba Buena",
                "can pirancisko",
                "jiu jin shan",
                "saenpeulan",
                "saenpeulansiseuko",
                "saina pharansisako",
                "saina phransisko",
                "san f ran si s ko",
                "san fan shi",
                "san fransskw",
                "san fransyskw",
                "san fransyskۆ",
                "san phransisko",
                "sana phransisako ka'unti",
                "sana phransisko",
                "sanfuranshisuko",
                "sena phransisko",
                "sn prnsysqw",
                "syana phransisko",
                "Σαν Φρανσίσκο",
                "Горад Сан-Францыска",
                "Сан Франсиско",
                "Сан Франциско",
                "Сан-Франциско",
                "Сан-Франціско",
                "Սան Ֆրանցիսկո",
                "סאן פראנציסקא",
                "סן פרנסיסקו",
                "سان فرانسسکو",
                "سان فرانسيسكو",
                "سان فرانسیسکو",
                "سان فرانسیسکۆ",
                "सॅन फ्रान्सिस्को",
                "सैन फ्रांसिस्को",
                "स्यान फ्रान्सिस्को",
                "সান ফ্রান্সিসকো কাউন্টি",
                "সান ফ্রান্সিস্কো",
                "ਸੈਨ ਫਰਾਂਸਿਸਕੋ",
                "சான் பிரான்சிஸ்கோ",
                "శాన్ ఫ్రాన్సిస్కో",
                "സാൻ ഫ്രാൻസിസ്കോ",
                "සැන් ෆ්‍රැන්සිස්කෝ",
                "ซานฟรานซิสโก",
                "སན་ཧྥུ་རན་སིས་ཁོ",
                "ဆန်ဖရန်စစ္စကိုမြို့",
                "სან-ფრანცისკო",
                "サンフランシスコ",
                "三藩市",
                "旧金山",
                "舊金山",
                "샌프란",
                "샌프란시스코"
            ],
            "ascii_name": "San Francisco",
            "coordinates": "37.77493,-122.41942",
            "country": {
                "country_code_2": "US",
                "country_code_3": "USA",
                "country_numeric_code": "840",
                "name": "United States",
                "official_name": "United States of America"
            },
            "dem": "28",
            "elevation": 16,
            "feature_class": "P",
            "feature_code": "PPLA2",
            "geonameid": "5391959",
            "id": "Geoname_5391959",
            "modification_date": "2017-06-15",
            "name": "San Francisco",
            "population": 864816,
            "subdivision": {
                "country_code_2": "US",
                "name": "California",
                "subdivision_code": "US-CA",
                "type": "State"
            },
            "timezone": "America/Los_Angeles"
        },
        {
            "_entity_type": "City",
            "_id": "Geoname_5489563",
            "admin1_code": "NM",
            "admin2_code": "053",
            "admin3_code": null,
            "admin4_code": null,
            "alternative_names": [
                "San Francisco",
                "San Francisco del Rio Puerco"
            ],
            "ascii_name": "San Francisco",
            "coordinates": "34.3959,-106.83919",
            "country": {
                "country_code_2": "US",
                "country_code_3": "USA",
                "country_numeric_code": "840",
                "name": "United States",
                "official_name": "United States of America"
            },
            "dem": "1441",
            "elevation": 1442,
            "feature_class": "P",
            "feature_code": "PPL",
            "geonameid": "5489563",
            "id": "Geoname_5489563",
            "modification_date": "2006-01-15",
            "name": "San Francisco",
            "population": 0,
            "subdivision": {
                "country_code_2": "US",
                "name": "New Mexico",
                "subdivision_code": "US-NM",
                "type": "State"
            },
            "timezone": "America/Denver"
        },
        {
            "_entity_type": "City",
            "_id": "Geoname_5530064",
            "admin1_code": "TX",
            "admin2_code": "043",
            "admin3_code": null,
            "admin4_code": null,
            "alternative_names": [
                ""
            ],
            "ascii_name": "San Francisco",
            "coordinates": "29.89353,-102.40403",
            "country": {
                "country_code_2": "US",
                "country_code_3": "USA",
                "country_numeric_code": "840",
                "name": "United States",
                "official_name": "United States of America"
            },
            "dem": "540",
            "elevation": 544,
            "feature_class": "P",
            "feature_code": "PPL",
            "geonameid": "5530064",
            "id": "Geoname_5530064",
            "modification_date": "2006-01-15",
            "name": "San Francisco",
            "population": 0,
            "subdivision": {
                "country_code_2": "US",
                "name": "Texas",
                "subdivision_code": "US-TX",
                "type": "State"
            },
            "timezone": "America/Chicago"
        }
    ]
}

Optional: Pull the data

You can use fetch endpoint to request the data currently available for your HQL query. Hooks will return the latest data available for HQL query. The result may be empty if we currently don’t have any data available for your query.

To pull the data for “Get an update 24 hours before it rains in San Francisco” you can use:

curl -H "Content-type: application/json" -d '{
	"query": "SELECT * FROM WeatherByCity(geonameid = \'5391959\') 
                  WHERE weather_conditions.main = \'Rain\' and start_datetime.countdown <= 86400" }' 'http://api.hooksdata.io/v1/subscriptions'

This will return an empty result because there is no rain expected in San Francisco in the next 24 hours:

{
    "matches_count": 0,
    "results": []
}

To pull the data for “Clouds in San Francisco in the next 24 hours”, just change the WHERE condition to weather_conditions.main='Clouds':

curl -H "Content-type: application/json" -d '{
	"query": "SELECT * FROM WeatherByCity(geonameid = \'5391959\') 
                  WHERE weather_conditions.main = \'Clouds\' and start_datetime.countdown <= 86400" }' 'http://api.hooksdata.io/v1/subscriptions'

The above request will return:

{
    "matches_count": 9,
    "results": [
        {
            "_entity_type": "WeatherStatus",
            "_id": "WeatherStatus_Geoname_5391959-1519146000",
            "city": {
                "_entity_type": "City",
                "_id": "Geoname_5391959",
                "admin1_code": "CA",
                "admin2_code": "075",
                "admin3_code": null,
                "admin4_code": null,
                "alternative_names": [
                    "Franciscopolis",
                    "Frisco",
                    "Gorad San-Francyska",
                    "Kapalakiko",
                    "Khiu-kim-san",
                    "Khiu-kîm-sân",
                    "Lungsod ng San Francisco",
                    "New Albion",
                    "SF",
                    "SFO",
                    "San Francisco",
                    "San Franciscu",
                    "San Francisko",
                    "San Fransisco",
                    "San Fransiskas",
                    "San Fransisko",
                    "San Frantzisko",
                    "San Phransisko",
                    "San-Francisko",
                    "San-Fransisko",
                    "Sanfrancisko",
                    "Sao Francisco",
                    "São Francisco",
                    "Yerba Buena",
                    "can pirancisko",
                    "jiu jin shan",
                    "saenpeulan",
                    "saenpeulansiseuko",
                    "saina pharansisako",
                    "saina phransisko",
                    "san f ran si s ko",
                    "san fan shi",
                    "san fransskw",
                    "san fransyskw",
                    "san fransyskۆ",
                    "san phransisko",
                    "sana phransisako ka'unti",
                    "sana phransisko",
                    "sanfuranshisuko",
                    "sena phransisko",
                    "sn prnsysqw",
                    "syana phransisko",
                    "Σαν Φρανσίσκο",
                    "Горад Сан-Францыска",
                    "Сан Франсиско",
                    "Сан Франциско",
                    "Сан-Франциско",
                    "Сан-Франціско",
                    "Սան Ֆրանցիսկո",
                    "סאן פראנציסקא",
                    "סן פרנסיסקו",
                    "سان فرانسسکو",
                    "سان فرانسيسكو",
                    "سان فرانسیسکو",
                    "سان فرانسیسکۆ",
                    "सॅन फ्रान्सिस्को",
                    "सैन फ्रांसिस्को",
                    "स्यान फ्रान्सिस्को",
                    "সান ফ্রান্সিসকো কাউন্টি",
                    "সান ফ্রান্সিস্কো",
                    "ਸੈਨ ਫਰਾਂਸਿਸਕੋ",
                    "சான் பிரான்சிஸ்கோ",
                    "శాన్ ఫ్రాన్సిస్కో",
                    "സാൻ ഫ്രാൻസിസ്കോ",
                    "සැන් ෆ්‍රැන්සිස්කෝ",
                    "ซานฟรานซิสโก",
                    "སན་ཧྥུ་རན་སིས་ཁོ",
                    "ဆန်ဖရန်စစ္စကိုမြို့",
                    "სან-ფრანცისკო",
                    "サンフランシスコ",
                    "三藩市",
                    "旧金山",
                    "舊金山",
                    "샌프란",
                    "샌프란시스코"
                ],
                "ascii_name": "San Francisco",
                "coordinates": "37.77493,-122.41942",
                "country": {
                    "country_code_2": "US",
                    "country_code_3": "USA",
                    "country_numeric_code": "840",
                    "name": "United States",
                    "official_name": "United States of America"
                },
                "dem": "28",
                "elevation": 16,
                "feature_class": "P",
                "feature_code": "PPLA2",
                "geonameid": "5391959",
                "id": "Geoname_5391959",
                "modification_date": "2017-06-15",
                "name": "San Francisco",
                "population": 864816,
                "subdivision": {
                    "country_code_2": "US",
                    "name": "California",
                    "subdivision_code": "US-CA",
                    "type": "State"
                },
                "timezone": "America/Los_Angeles"
            },
            "features": {
                "clouds_percent": 48,
                "humidity_percent": 89,
                "pressure": {
                    "hPa": 1028.89,
                    "inHg": 30.38,
                    "mmHg": 771.73
                },
                "rain": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "snow": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "temperature": {
                    "celsius": 5.12,
                    "fahrenheit": 32
                },
                "wind_direction_degrees": 311.008,
                "wind_speed": {
                    "meters_per_second": 2.7,
                    "miles_per_hour": 6.04
                }
            },
            "is_current": false,
            "measure_time": {
                "countdown": 10531,
                "datetime": "2018-02-20T18:00:00+0000",
                "timestamp": 1519149600
            },
            "start_datetime": {
                "countdown": 6931,
                "datetime": "2018-02-20T17:00:00+0000",
                "timestamp": 1519146000
            },
            "weather_conditions": [
                {
                    "description": "scattered clouds",
                    "icon": "03d",
                    "icon_url": "http://openweathermap.org/img/w/03d",
                    "id": 802,
                    "main": "Clouds"
                }
            ]
        },
        {
            "_entity_type": "WeatherStatus",
            "_id": "WeatherStatus_Geoname_5391959-1519149600",
            "city": {
                "_entity_type": "City",
                "_id": "Geoname_5391959",
                "admin1_code": "CA",
                "admin2_code": "075",
                "admin3_code": null,
                "admin4_code": null,
                "alternative_names": [
                    "Franciscopolis",
                    "Frisco",
                    "Gorad San-Francyska",
                    "Kapalakiko",
                    "Khiu-kim-san",
                    "Khiu-kîm-sân",
                    "Lungsod ng San Francisco",
                    "New Albion",
                    "SF",
                    "SFO",
                    "San Francisco",
                    "San Franciscu",
                    "San Francisko",
                    "San Fransisco",
                    "San Fransiskas",
                    "San Fransisko",
                    "San Frantzisko",
                    "San Phransisko",
                    "San-Francisko",
                    "San-Fransisko",
                    "Sanfrancisko",
                    "Sao Francisco",
                    "São Francisco",
                    "Yerba Buena",
                    "can pirancisko",
                    "jiu jin shan",
                    "saenpeulan",
                    "saenpeulansiseuko",
                    "saina pharansisako",
                    "saina phransisko",
                    "san f ran si s ko",
                    "san fan shi",
                    "san fransskw",
                    "san fransyskw",
                    "san fransyskۆ",
                    "san phransisko",
                    "sana phransisako ka'unti",
                    "sana phransisko",
                    "sanfuranshisuko",
                    "sena phransisko",
                    "sn prnsysqw",
                    "syana phransisko",
                    "Σαν Φρανσίσκο",
                    "Горад Сан-Францыска",
                    "Сан Франсиско",
                    "Сан Франциско",
                    "Сан-Франциско",
                    "Сан-Франціско",
                    "Սան Ֆրանցիսկո",
                    "סאן פראנציסקא",
                    "סן פרנסיסקו",
                    "سان فرانسسکو",
                    "سان فرانسيسكو",
                    "سان فرانسیسکو",
                    "سان فرانسیسکۆ",
                    "सॅन फ्रान्सिस्को",
                    "सैन फ्रांसिस्को",
                    "स्यान फ्रान्सिस्को",
                    "সান ফ্রান্সিসকো কাউন্টি",
                    "সান ফ্রান্সিস্কো",
                    "ਸੈਨ ਫਰਾਂਸਿਸਕੋ",
                    "சான் பிரான்சிஸ்கோ",
                    "శాన్ ఫ్రాన్సిస్కో",
                    "സാൻ ഫ്രാൻസിസ്കോ",
                    "සැන් ෆ්‍රැන්සිස්කෝ",
                    "ซานฟรานซิสโก",
                    "སན་ཧྥུ་རན་སིས་ཁོ",
                    "ဆန်ဖရန်စစ္စကိုမြို့",
                    "სან-ფრანცისკო",
                    "サンフランシスコ",
                    "三藩市",
                    "旧金山",
                    "舊金山",
                    "샌프란",
                    "샌프란시스코"
                ],
                "ascii_name": "San Francisco",
                "coordinates": "37.77493,-122.41942",
                "country": {
                    "country_code_2": "US",
                    "country_code_3": "USA",
                    "country_numeric_code": "840",
                    "name": "United States",
                    "official_name": "United States of America"
                },
                "dem": "28",
                "elevation": 16,
                "feature_class": "P",
                "feature_code": "PPLA2",
                "geonameid": "5391959",
                "id": "Geoname_5391959",
                "modification_date": "2017-06-15",
                "name": "San Francisco",
                "population": 864816,
                "subdivision": {
                    "country_code_2": "US",
                    "name": "California",
                    "subdivision_code": "US-CA",
                    "type": "State"
                },
                "timezone": "America/Los_Angeles"
            },
            "features": {
                "clouds_percent": 48,
                "humidity_percent": 89,
                "pressure": {
                    "hPa": 1028.89,
                    "inHg": 30.38,
                    "mmHg": 771.73
                },
                "rain": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "snow": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "temperature": {
                    "celsius": 5.12,
                    "fahrenheit": 32
                },
                "wind_direction_degrees": 311.008,
                "wind_speed": {
                    "meters_per_second": 2.7,
                    "miles_per_hour": 6.04
                }
            },
            "is_current": false,
            "measure_time": {
                "countdown": 10531,
                "datetime": "2018-02-20T18:00:00+0000",
                "timestamp": 1519149600
            },
            "start_datetime": {
                "countdown": 10531,
                "datetime": "2018-02-20T18:00:00+0000",
                "timestamp": 1519149600
            },
            "weather_conditions": [
                {
                    "description": "scattered clouds",
                    "icon": "03d",
                    "icon_url": "http://openweathermap.org/img/w/03d",
                    "id": 802,
                    "main": "Clouds"
                }
            ]
        },
        {
            "_entity_type": "WeatherStatus",
            "_id": "WeatherStatus_Geoname_5391959-1519153200",
            "city": {
                "_entity_type": "City",
                "_id": "Geoname_5391959",
                "admin1_code": "CA",
                "admin2_code": "075",
                "admin3_code": null,
                "admin4_code": null,
                "alternative_names": [
                    "Franciscopolis",
                    "Frisco",
                    "Gorad San-Francyska",
                    "Kapalakiko",
                    "Khiu-kim-san",
                    "Khiu-kîm-sân",
                    "Lungsod ng San Francisco",
                    "New Albion",
                    "SF",
                    "SFO",
                    "San Francisco",
                    "San Franciscu",
                    "San Francisko",
                    "San Fransisco",
                    "San Fransiskas",
                    "San Fransisko",
                    "San Frantzisko",
                    "San Phransisko",
                    "San-Francisko",
                    "San-Fransisko",
                    "Sanfrancisko",
                    "Sao Francisco",
                    "São Francisco",
                    "Yerba Buena",
                    "can pirancisko",
                    "jiu jin shan",
                    "saenpeulan",
                    "saenpeulansiseuko",
                    "saina pharansisako",
                    "saina phransisko",
                    "san f ran si s ko",
                    "san fan shi",
                    "san fransskw",
                    "san fransyskw",
                    "san fransyskۆ",
                    "san phransisko",
                    "sana phransisako ka'unti",
                    "sana phransisko",
                    "sanfuranshisuko",
                    "sena phransisko",
                    "sn prnsysqw",
                    "syana phransisko",
                    "Σαν Φρανσίσκο",
                    "Горад Сан-Францыска",
                    "Сан Франсиско",
                    "Сан Франциско",
                    "Сан-Франциско",
                    "Сан-Франціско",
                    "Սան Ֆրանցիսկո",
                    "סאן פראנציסקא",
                    "סן פרנסיסקו",
                    "سان فرانسسکو",
                    "سان فرانسيسكو",
                    "سان فرانسیسکو",
                    "سان فرانسیسکۆ",
                    "सॅन फ्रान्सिस्को",
                    "सैन फ्रांसिस्को",
                    "स्यान फ्रान्सिस्को",
                    "সান ফ্রান্সিসকো কাউন্টি",
                    "সান ফ্রান্সিস্কো",
                    "ਸੈਨ ਫਰਾਂਸਿਸਕੋ",
                    "சான் பிரான்சிஸ்கோ",
                    "శాన్ ఫ్రాన్సిస్కో",
                    "സാൻ ഫ്രാൻസിസ്കോ",
                    "සැන් ෆ්‍රැන්සිස්කෝ",
                    "ซานฟรานซิสโก",
                    "སན་ཧྥུ་རན་སིས་ཁོ",
                    "ဆန်ဖရန်စစ္စကိုမြို့",
                    "სან-ფრანცისკო",
                    "サンフランシスコ",
                    "三藩市",
                    "旧金山",
                    "舊金山",
                    "샌프란",
                    "샌프란시스코"
                ],
                "ascii_name": "San Francisco",
                "coordinates": "37.77493,-122.41942",
                "country": {
                    "country_code_2": "US",
                    "country_code_3": "USA",
                    "country_numeric_code": "840",
                    "name": "United States",
                    "official_name": "United States of America"
                },
                "dem": "28",
                "elevation": 16,
                "feature_class": "P",
                "feature_code": "PPLA2",
                "geonameid": "5391959",
                "id": "Geoname_5391959",
                "modification_date": "2017-06-15",
                "name": "San Francisco",
                "population": 864816,
                "subdivision": {
                    "country_code_2": "US",
                    "name": "California",
                    "subdivision_code": "US-CA",
                    "type": "State"
                },
                "timezone": "America/Los_Angeles"
            },
            "features": {
                "clouds_percent": 48,
                "humidity_percent": 89,
                "pressure": {
                    "hPa": 1028.89,
                    "inHg": 30.38,
                    "mmHg": 771.73
                },
                "rain": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "snow": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "temperature": {
                    "celsius": 5.12,
                    "fahrenheit": 32
                },
                "wind_direction_degrees": 311.008,
                "wind_speed": {
                    "meters_per_second": 2.7,
                    "miles_per_hour": 6.04
                }
            },
            "is_current": false,
            "measure_time": {
                "countdown": 10531,
                "datetime": "2018-02-20T18:00:00+0000",
                "timestamp": 1519149600
            },
            "start_datetime": {
                "countdown": 14131,
                "datetime": "2018-02-20T19:00:00+0000",
                "timestamp": 1519153200
            },
            "weather_conditions": [
                {
                    "description": "scattered clouds",
                    "icon": "03d",
                    "icon_url": "http://openweathermap.org/img/w/03d",
                    "id": 802,
                    "main": "Clouds"
                }
            ]
        },
        {
            "_entity_type": "WeatherStatus",
            "_id": "WeatherStatus_Geoname_5391959-1519167600",
            "city": {
                "_entity_type": "City",
                "_id": "Geoname_5391959",
                "admin1_code": "CA",
                "admin2_code": "075",
                "admin3_code": null,
                "admin4_code": null,
                "alternative_names": [
                    "Franciscopolis",
                    "Frisco",
                    "Gorad San-Francyska",
                    "Kapalakiko",
                    "Khiu-kim-san",
                    "Khiu-kîm-sân",
                    "Lungsod ng San Francisco",
                    "New Albion",
                    "SF",
                    "SFO",
                    "San Francisco",
                    "San Franciscu",
                    "San Francisko",
                    "San Fransisco",
                    "San Fransiskas",
                    "San Fransisko",
                    "San Frantzisko",
                    "San Phransisko",
                    "San-Francisko",
                    "San-Fransisko",
                    "Sanfrancisko",
                    "Sao Francisco",
                    "São Francisco",
                    "Yerba Buena",
                    "can pirancisko",
                    "jiu jin shan",
                    "saenpeulan",
                    "saenpeulansiseuko",
                    "saina pharansisako",
                    "saina phransisko",
                    "san f ran si s ko",
                    "san fan shi",
                    "san fransskw",
                    "san fransyskw",
                    "san fransyskۆ",
                    "san phransisko",
                    "sana phransisako ka'unti",
                    "sana phransisko",
                    "sanfuranshisuko",
                    "sena phransisko",
                    "sn prnsysqw",
                    "syana phransisko",
                    "Σαν Φρανσίσκο",
                    "Горад Сан-Францыска",
                    "Сан Франсиско",
                    "Сан Франциско",
                    "Сан-Франциско",
                    "Сан-Франціско",
                    "Սան Ֆրանցիսկո",
                    "סאן פראנציסקא",
                    "סן פרנסיסקו",
                    "سان فرانسسکو",
                    "سان فرانسيسكو",
                    "سان فرانسیسکو",
                    "سان فرانسیسکۆ",
                    "सॅन फ्रान्सिस्को",
                    "सैन फ्रांसिस्को",
                    "स्यान फ्रान्सिस्को",
                    "সান ফ্রান্সিসকো কাউন্টি",
                    "সান ফ্রান্সিস্কো",
                    "ਸੈਨ ਫਰਾਂਸਿਸਕੋ",
                    "சான் பிரான்சிஸ்கோ",
                    "శాన్ ఫ్రాన్సిస్కో",
                    "സാൻ ഫ്രാൻസിസ്കോ",
                    "සැන් ෆ්‍රැන්සිස්කෝ",
                    "ซานฟรานซิสโก",
                    "སན་ཧྥུ་རན་སིས་ཁོ",
                    "ဆန်ဖရန်စစ္စကိုမြို့",
                    "სან-ფრანცისკო",
                    "サンフランシスコ",
                    "三藩市",
                    "旧金山",
                    "舊金山",
                    "샌프란",
                    "샌프란시스코"
                ],
                "ascii_name": "San Francisco",
                "coordinates": "37.77493,-122.41942",
                "country": {
                    "country_code_2": "US",
                    "country_code_3": "USA",
                    "country_numeric_code": "840",
                    "name": "United States",
                    "official_name": "United States of America"
                },
                "dem": "28",
                "elevation": 16,
                "feature_class": "P",
                "feature_code": "PPLA2",
                "geonameid": "5391959",
                "id": "Geoname_5391959",
                "modification_date": "2017-06-15",
                "name": "San Francisco",
                "population": 864816,
                "subdivision": {
                    "country_code_2": "US",
                    "name": "California",
                    "subdivision_code": "US-CA",
                    "type": "State"
                },
                "timezone": "America/Los_Angeles"
            },
            "features": {
                "clouds_percent": 68,
                "humidity_percent": 75,
                "pressure": {
                    "hPa": 1026.97,
                    "inHg": 30.33,
                    "mmHg": 770.29
                },
                "rain": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "snow": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "temperature": {
                    "celsius": 9.19,
                    "fahrenheit": 32
                },
                "wind_direction_degrees": 299.5,
                "wind_speed": {
                    "meters_per_second": 4.33,
                    "miles_per_hour": 9.69
                }
            },
            "is_current": false,
            "measure_time": {
                "countdown": 32131,
                "datetime": "2018-02-21T00:00:00+0000",
                "timestamp": 1519171200
            },
            "start_datetime": {
                "countdown": 28531,
                "datetime": "2018-02-20T23:00:00+0000",
                "timestamp": 1519167600
            },
            "weather_conditions": [
                {
                    "description": "broken clouds",
                    "icon": "04n",
                    "icon_url": "http://openweathermap.org/img/w/04n",
                    "id": 803,
                    "main": "Clouds"
                }
            ]
        },
        {
            "_entity_type": "WeatherStatus",
            "_id": "WeatherStatus_Geoname_5391959-1519171200",
            "city": {
                "_entity_type": "City",
                "_id": "Geoname_5391959",
                "admin1_code": "CA",
                "admin2_code": "075",
                "admin3_code": null,
                "admin4_code": null,
                "alternative_names": [
                    "Franciscopolis",
                    "Frisco",
                    "Gorad San-Francyska",
                    "Kapalakiko",
                    "Khiu-kim-san",
                    "Khiu-kîm-sân",
                    "Lungsod ng San Francisco",
                    "New Albion",
                    "SF",
                    "SFO",
                    "San Francisco",
                    "San Franciscu",
                    "San Francisko",
                    "San Fransisco",
                    "San Fransiskas",
                    "San Fransisko",
                    "San Frantzisko",
                    "San Phransisko",
                    "San-Francisko",
                    "San-Fransisko",
                    "Sanfrancisko",
                    "Sao Francisco",
                    "São Francisco",
                    "Yerba Buena",
                    "can pirancisko",
                    "jiu jin shan",
                    "saenpeulan",
                    "saenpeulansiseuko",
                    "saina pharansisako",
                    "saina phransisko",
                    "san f ran si s ko",
                    "san fan shi",
                    "san fransskw",
                    "san fransyskw",
                    "san fransyskۆ",
                    "san phransisko",
                    "sana phransisako ka'unti",
                    "sana phransisko",
                    "sanfuranshisuko",
                    "sena phransisko",
                    "sn prnsysqw",
                    "syana phransisko",
                    "Σαν Φρανσίσκο",
                    "Горад Сан-Францыска",
                    "Сан Франсиско",
                    "Сан Франциско",
                    "Сан-Франциско",
                    "Сан-Франціско",
                    "Սան Ֆրանցիսկո",
                    "סאן פראנציסקא",
                    "סן פרנסיסקו",
                    "سان فرانسسکو",
                    "سان فرانسيسكو",
                    "سان فرانسیسکو",
                    "سان فرانسیسکۆ",
                    "सॅन फ्रान्सिस्को",
                    "सैन फ्रांसिस्को",
                    "स्यान फ्रान्सिस्को",
                    "সান ফ্রান্সিসকো কাউন্টি",
                    "সান ফ্রান্সিস্কো",
                    "ਸੈਨ ਫਰਾਂਸਿਸਕੋ",
                    "சான் பிரான்சிஸ்கோ",
                    "శాన్ ఫ్రాన్సిస్కో",
                    "സാൻ ഫ്രാൻസിസ്കോ",
                    "සැන් ෆ්‍රැන්සිස්කෝ",
                    "ซานฟรานซิสโก",
                    "སན་ཧྥུ་རན་སིས་ཁོ",
                    "ဆန်ဖရန်စစ္စကိုမြို့",
                    "სან-ფრანცისკო",
                    "サンフランシスコ",
                    "三藩市",
                    "旧金山",
                    "舊金山",
                    "샌프란",
                    "샌프란시스코"
                ],
                "ascii_name": "San Francisco",
                "coordinates": "37.77493,-122.41942",
                "country": {
                    "country_code_2": "US",
                    "country_code_3": "USA",
                    "country_numeric_code": "840",
                    "name": "United States",
                    "official_name": "United States of America"
                },
                "dem": "28",
                "elevation": 16,
                "feature_class": "P",
                "feature_code": "PPLA2",
                "geonameid": "5391959",
                "id": "Geoname_5391959",
                "modification_date": "2017-06-15",
                "name": "San Francisco",
                "population": 864816,
                "subdivision": {
                    "country_code_2": "US",
                    "name": "California",
                    "subdivision_code": "US-CA",
                    "type": "State"
                },
                "timezone": "America/Los_Angeles"
            },
            "features": {
                "clouds_percent": 68,
                "humidity_percent": 75,
                "pressure": {
                    "hPa": 1026.97,
                    "inHg": 30.33,
                    "mmHg": 770.29
                },
                "rain": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "snow": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "temperature": {
                    "celsius": 9.19,
                    "fahrenheit": 32
                },
                "wind_direction_degrees": 299.5,
                "wind_speed": {
                    "meters_per_second": 4.33,
                    "miles_per_hour": 9.69
                }
            },
            "is_current": false,
            "measure_time": {
                "countdown": 32131,
                "datetime": "2018-02-21T00:00:00+0000",
                "timestamp": 1519171200
            },
            "start_datetime": {
                "countdown": 32131,
                "datetime": "2018-02-21T00:00:00+0000",
                "timestamp": 1519171200
            },
            "weather_conditions": [
                {
                    "description": "broken clouds",
                    "icon": "04n",
                    "icon_url": "http://openweathermap.org/img/w/04n",
                    "id": 803,
                    "main": "Clouds"
                }
            ]
        },
        {
            "_entity_type": "WeatherStatus",
            "_id": "WeatherStatus_Geoname_5391959-1519174800",
            "city": {
                "_entity_type": "City",
                "_id": "Geoname_5391959",
                "admin1_code": "CA",
                "admin2_code": "075",
                "admin3_code": null,
                "admin4_code": null,
                "alternative_names": [
                    "Franciscopolis",
                    "Frisco",
                    "Gorad San-Francyska",
                    "Kapalakiko",
                    "Khiu-kim-san",
                    "Khiu-kîm-sân",
                    "Lungsod ng San Francisco",
                    "New Albion",
                    "SF",
                    "SFO",
                    "San Francisco",
                    "San Franciscu",
                    "San Francisko",
                    "San Fransisco",
                    "San Fransiskas",
                    "San Fransisko",
                    "San Frantzisko",
                    "San Phransisko",
                    "San-Francisko",
                    "San-Fransisko",
                    "Sanfrancisko",
                    "Sao Francisco",
                    "São Francisco",
                    "Yerba Buena",
                    "can pirancisko",
                    "jiu jin shan",
                    "saenpeulan",
                    "saenpeulansiseuko",
                    "saina pharansisako",
                    "saina phransisko",
                    "san f ran si s ko",
                    "san fan shi",
                    "san fransskw",
                    "san fransyskw",
                    "san fransyskۆ",
                    "san phransisko",
                    "sana phransisako ka'unti",
                    "sana phransisko",
                    "sanfuranshisuko",
                    "sena phransisko",
                    "sn prnsysqw",
                    "syana phransisko",
                    "Σαν Φρανσίσκο",
                    "Горад Сан-Францыска",
                    "Сан Франсиско",
                    "Сан Франциско",
                    "Сан-Франциско",
                    "Сан-Франціско",
                    "Սան Ֆրանցիսկո",
                    "סאן פראנציסקא",
                    "סן פרנסיסקו",
                    "سان فرانسسکو",
                    "سان فرانسيسكو",
                    "سان فرانسیسکو",
                    "سان فرانسیسکۆ",
                    "सॅन फ्रान्सिस्को",
                    "सैन फ्रांसिस्को",
                    "स्यान फ्रान्सिस्को",
                    "সান ফ্রান্সিসকো কাউন্টি",
                    "সান ফ্রান্সিস্কো",
                    "ਸੈਨ ਫਰਾਂਸਿਸਕੋ",
                    "சான் பிரான்சிஸ்கோ",
                    "శాన్ ఫ్రాన్సిస్కో",
                    "സാൻ ഫ്രാൻസിസ്കോ",
                    "සැන් ෆ්‍රැන්සිස්කෝ",
                    "ซานฟรานซิสโก",
                    "སན་ཧྥུ་རན་སིས་ཁོ",
                    "ဆန်ဖရန်စစ္စကိုမြို့",
                    "სან-ფრანცისკო",
                    "サンフランシスコ",
                    "三藩市",
                    "旧金山",
                    "舊金山",
                    "샌프란",
                    "샌프란시스코"
                ],
                "ascii_name": "San Francisco",
                "coordinates": "37.77493,-122.41942",
                "country": {
                    "country_code_2": "US",
                    "country_code_3": "USA",
                    "country_numeric_code": "840",
                    "name": "United States",
                    "official_name": "United States of America"
                },
                "dem": "28",
                "elevation": 16,
                "feature_class": "P",
                "feature_code": "PPLA2",
                "geonameid": "5391959",
                "id": "Geoname_5391959",
                "modification_date": "2017-06-15",
                "name": "San Francisco",
                "population": 864816,
                "subdivision": {
                    "country_code_2": "US",
                    "name": "California",
                    "subdivision_code": "US-CA",
                    "type": "State"
                },
                "timezone": "America/Los_Angeles"
            },
            "features": {
                "clouds_percent": 68,
                "humidity_percent": 75,
                "pressure": {
                    "hPa": 1026.97,
                    "inHg": 30.33,
                    "mmHg": 770.29
                },
                "rain": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "snow": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "temperature": {
                    "celsius": 9.19,
                    "fahrenheit": 32
                },
                "wind_direction_degrees": 299.5,
                "wind_speed": {
                    "meters_per_second": 4.33,
                    "miles_per_hour": 9.69
                }
            },
            "is_current": false,
            "measure_time": {
                "countdown": 32131,
                "datetime": "2018-02-21T00:00:00+0000",
                "timestamp": 1519171200
            },
            "start_datetime": {
                "countdown": 35731,
                "datetime": "2018-02-21T01:00:00+0000",
                "timestamp": 1519174800
            },
            "weather_conditions": [
                {
                    "description": "broken clouds",
                    "icon": "04n",
                    "icon_url": "http://openweathermap.org/img/w/04n",
                    "id": 803,
                    "main": "Clouds"
                }
            ]
        },
        {
            "_entity_type": "WeatherStatus",
            "_id": "WeatherStatus_Geoname_5391959-1519178400",
            "city": {
                "_entity_type": "City",
                "_id": "Geoname_5391959",
                "admin1_code": "CA",
                "admin2_code": "075",
                "admin3_code": null,
                "admin4_code": null,
                "alternative_names": [
                    "Franciscopolis",
                    "Frisco",
                    "Gorad San-Francyska",
                    "Kapalakiko",
                    "Khiu-kim-san",
                    "Khiu-kîm-sân",
                    "Lungsod ng San Francisco",
                    "New Albion",
                    "SF",
                    "SFO",
                    "San Francisco",
                    "San Franciscu",
                    "San Francisko",
                    "San Fransisco",
                    "San Fransiskas",
                    "San Fransisko",
                    "San Frantzisko",
                    "San Phransisko",
                    "San-Francisko",
                    "San-Fransisko",
                    "Sanfrancisko",
                    "Sao Francisco",
                    "São Francisco",
                    "Yerba Buena",
                    "can pirancisko",
                    "jiu jin shan",
                    "saenpeulan",
                    "saenpeulansiseuko",
                    "saina pharansisako",
                    "saina phransisko",
                    "san f ran si s ko",
                    "san fan shi",
                    "san fransskw",
                    "san fransyskw",
                    "san fransyskۆ",
                    "san phransisko",
                    "sana phransisako ka'unti",
                    "sana phransisko",
                    "sanfuranshisuko",
                    "sena phransisko",
                    "sn prnsysqw",
                    "syana phransisko",
                    "Σαν Φρανσίσκο",
                    "Горад Сан-Францыска",
                    "Сан Франсиско",
                    "Сан Франциско",
                    "Сан-Франциско",
                    "Сан-Франціско",
                    "Սան Ֆրանցիսկո",
                    "סאן פראנציסקא",
                    "סן פרנסיסקו",
                    "سان فرانسسکو",
                    "سان فرانسيسكو",
                    "سان فرانسیسکو",
                    "سان فرانسیسکۆ",
                    "सॅन फ्रान्सिस्को",
                    "सैन फ्रांसिस्को",
                    "स्यान फ्रान्सिस्को",
                    "সান ফ্রান্সিসকো কাউন্টি",
                    "সান ফ্রান্সিস্কো",
                    "ਸੈਨ ਫਰਾਂਸਿਸਕੋ",
                    "சான் பிரான்சிஸ்கோ",
                    "శాన్ ఫ్రాన్సిస్కో",
                    "സാൻ ഫ്രാൻസിസ്കോ",
                    "සැන් ෆ්‍රැන්සිස්කෝ",
                    "ซานฟรานซิสโก",
                    "སན་ཧྥུ་རན་སིས་ཁོ",
                    "ဆန်ဖရန်စစ္စကိုမြို့",
                    "სან-ფრანცისკო",
                    "サンフランシスコ",
                    "三藩市",
                    "旧金山",
                    "舊金山",
                    "샌프란",
                    "샌프란시스코"
                ],
                "ascii_name": "San Francisco",
                "coordinates": "37.77493,-122.41942",
                "country": {
                    "country_code_2": "US",
                    "country_code_3": "USA",
                    "country_numeric_code": "840",
                    "name": "United States",
                    "official_name": "United States of America"
                },
                "dem": "28",
                "elevation": 16,
                "feature_class": "P",
                "feature_code": "PPLA2",
                "geonameid": "5391959",
                "id": "Geoname_5391959",
                "modification_date": "2017-06-15",
                "name": "San Francisco",
                "population": 864816,
                "subdivision": {
                    "country_code_2": "US",
                    "name": "California",
                    "subdivision_code": "US-CA",
                    "type": "State"
                },
                "timezone": "America/Los_Angeles"
            },
            "features": {
                "clouds_percent": 44,
                "humidity_percent": 83,
                "pressure": {
                    "hPa": 1027.12,
                    "inHg": 30.33,
                    "mmHg": 770.4
                },
                "rain": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "snow": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "temperature": {
                    "celsius": 8.36,
                    "fahrenheit": 32
                },
                "wind_direction_degrees": 297.002,
                "wind_speed": {
                    "meters_per_second": 3.42,
                    "miles_per_hour": 7.65
                }
            },
            "is_current": false,
            "measure_time": {
                "countdown": 42931,
                "datetime": "2018-02-21T03:00:00+0000",
                "timestamp": 1519182000
            },
            "start_datetime": {
                "countdown": 39331,
                "datetime": "2018-02-21T02:00:00+0000",
                "timestamp": 1519178400
            },
            "weather_conditions": [
                {
                    "description": "scattered clouds",
                    "icon": "03n",
                    "icon_url": "http://openweathermap.org/img/w/03n",
                    "id": 802,
                    "main": "Clouds"
                }
            ]
        },
        {
            "_entity_type": "WeatherStatus",
            "_id": "WeatherStatus_Geoname_5391959-1519182000",
            "city": {
                "_entity_type": "City",
                "_id": "Geoname_5391959",
                "admin1_code": "CA",
                "admin2_code": "075",
                "admin3_code": null,
                "admin4_code": null,
                "alternative_names": [
                    "Franciscopolis",
                    "Frisco",
                    "Gorad San-Francyska",
                    "Kapalakiko",
                    "Khiu-kim-san",
                    "Khiu-kîm-sân",
                    "Lungsod ng San Francisco",
                    "New Albion",
                    "SF",
                    "SFO",
                    "San Francisco",
                    "San Franciscu",
                    "San Francisko",
                    "San Fransisco",
                    "San Fransiskas",
                    "San Fransisko",
                    "San Frantzisko",
                    "San Phransisko",
                    "San-Francisko",
                    "San-Fransisko",
                    "Sanfrancisko",
                    "Sao Francisco",
                    "São Francisco",
                    "Yerba Buena",
                    "can pirancisko",
                    "jiu jin shan",
                    "saenpeulan",
                    "saenpeulansiseuko",
                    "saina pharansisako",
                    "saina phransisko",
                    "san f ran si s ko",
                    "san fan shi",
                    "san fransskw",
                    "san fransyskw",
                    "san fransyskۆ",
                    "san phransisko",
                    "sana phransisako ka'unti",
                    "sana phransisko",
                    "sanfuranshisuko",
                    "sena phransisko",
                    "sn prnsysqw",
                    "syana phransisko",
                    "Σαν Φρανσίσκο",
                    "Горад Сан-Францыска",
                    "Сан Франсиско",
                    "Сан Франциско",
                    "Сан-Франциско",
                    "Сан-Франціско",
                    "Սան Ֆրանցիսկո",
                    "סאן פראנציסקא",
                    "סן פרנסיסקו",
                    "سان فرانسسکو",
                    "سان فرانسيسكو",
                    "سان فرانسیسکو",
                    "سان فرانسیسکۆ",
                    "सॅन फ्रान्सिस्को",
                    "सैन फ्रांसिस्को",
                    "स्यान फ्रान्सिस्को",
                    "সান ফ্রান্সিসকো কাউন্টি",
                    "সান ফ্রান্সিস্কো",
                    "ਸੈਨ ਫਰਾਂਸਿਸਕੋ",
                    "சான் பிரான்சிஸ்கோ",
                    "శాన్ ఫ్రాన్సిస్కో",
                    "സാൻ ഫ്രാൻസിസ്കോ",
                    "සැන් ෆ්‍රැන්සිස්කෝ",
                    "ซานฟรานซิสโก",
                    "སན་ཧྥུ་རན་སིས་ཁོ",
                    "ဆန်ဖရန်စစ္စကိုမြို့",
                    "სან-ფრანცისკო",
                    "サンフランシスコ",
                    "三藩市",
                    "旧金山",
                    "舊金山",
                    "샌프란",
                    "샌프란시스코"
                ],
                "ascii_name": "San Francisco",
                "coordinates": "37.77493,-122.41942",
                "country": {
                    "country_code_2": "US",
                    "country_code_3": "USA",
                    "country_numeric_code": "840",
                    "name": "United States",
                    "official_name": "United States of America"
                },
                "dem": "28",
                "elevation": 16,
                "feature_class": "P",
                "feature_code": "PPLA2",
                "geonameid": "5391959",
                "id": "Geoname_5391959",
                "modification_date": "2017-06-15",
                "name": "San Francisco",
                "population": 864816,
                "subdivision": {
                    "country_code_2": "US",
                    "name": "California",
                    "subdivision_code": "US-CA",
                    "type": "State"
                },
                "timezone": "America/Los_Angeles"
            },
            "features": {
                "clouds_percent": 44,
                "humidity_percent": 83,
                "pressure": {
                    "hPa": 1027.12,
                    "inHg": 30.33,
                    "mmHg": 770.4
                },
                "rain": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "snow": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "temperature": {
                    "celsius": 8.36,
                    "fahrenheit": 32
                },
                "wind_direction_degrees": 297.002,
                "wind_speed": {
                    "meters_per_second": 3.42,
                    "miles_per_hour": 7.65
                }
            },
            "is_current": false,
            "measure_time": {
                "countdown": 42931,
                "datetime": "2018-02-21T03:00:00+0000",
                "timestamp": 1519182000
            },
            "start_datetime": {
                "countdown": 42931,
                "datetime": "2018-02-21T03:00:00+0000",
                "timestamp": 1519182000
            },
            "weather_conditions": [
                {
                    "description": "scattered clouds",
                    "icon": "03n",
                    "icon_url": "http://openweathermap.org/img/w/03n",
                    "id": 802,
                    "main": "Clouds"
                }
            ]
        },
        {
            "_entity_type": "WeatherStatus",
            "_id": "WeatherStatus_Geoname_5391959-1519185600",
            "city": {
                "_entity_type": "City",
                "_id": "Geoname_5391959",
                "admin1_code": "CA",
                "admin2_code": "075",
                "admin3_code": null,
                "admin4_code": null,
                "alternative_names": [
                    "Franciscopolis",
                    "Frisco",
                    "Gorad San-Francyska",
                    "Kapalakiko",
                    "Khiu-kim-san",
                    "Khiu-kîm-sân",
                    "Lungsod ng San Francisco",
                    "New Albion",
                    "SF",
                    "SFO",
                    "San Francisco",
                    "San Franciscu",
                    "San Francisko",
                    "San Fransisco",
                    "San Fransiskas",
                    "San Fransisko",
                    "San Frantzisko",
                    "San Phransisko",
                    "San-Francisko",
                    "San-Fransisko",
                    "Sanfrancisko",
                    "Sao Francisco",
                    "São Francisco",
                    "Yerba Buena",
                    "can pirancisko",
                    "jiu jin shan",
                    "saenpeulan",
                    "saenpeulansiseuko",
                    "saina pharansisako",
                    "saina phransisko",
                    "san f ran si s ko",
                    "san fan shi",
                    "san fransskw",
                    "san fransyskw",
                    "san fransyskۆ",
                    "san phransisko",
                    "sana phransisako ka'unti",
                    "sana phransisko",
                    "sanfuranshisuko",
                    "sena phransisko",
                    "sn prnsysqw",
                    "syana phransisko",
                    "Σαν Φρανσίσκο",
                    "Горад Сан-Францыска",
                    "Сан Франсиско",
                    "Сан Франциско",
                    "Сан-Франциско",
                    "Сан-Франціско",
                    "Սան Ֆրանցիսկո",
                    "סאן פראנציסקא",
                    "סן פרנסיסקו",
                    "سان فرانسسکو",
                    "سان فرانسيسكو",
                    "سان فرانسیسکو",
                    "سان فرانسیسکۆ",
                    "सॅन फ्रान्सिस्को",
                    "सैन फ्रांसिस्को",
                    "स्यान फ्रान्सिस्को",
                    "সান ফ্রান্সিসকো কাউন্টি",
                    "সান ফ্রান্সিস্কো",
                    "ਸੈਨ ਫਰਾਂਸਿਸਕੋ",
                    "சான் பிரான்சிஸ்கோ",
                    "శాన్ ఫ్రాన్సిస్కో",
                    "സാൻ ഫ്രാൻസിസ്കോ",
                    "සැන් ෆ්‍රැන්සිස්කෝ",
                    "ซานฟรานซิสโก",
                    "སན་ཧྥུ་རན་སིས་ཁོ",
                    "ဆန်ဖရန်စစ္စကိုမြို့",
                    "სან-ფრანცისკო",
                    "サンフランシスコ",
                    "三藩市",
                    "旧金山",
                    "舊金山",
                    "샌프란",
                    "샌프란시스코"
                ],
                "ascii_name": "San Francisco",
                "coordinates": "37.77493,-122.41942",
                "country": {
                    "country_code_2": "US",
                    "country_code_3": "USA",
                    "country_numeric_code": "840",
                    "name": "United States",
                    "official_name": "United States of America"
                },
                "dem": "28",
                "elevation": 16,
                "feature_class": "P",
                "feature_code": "PPLA2",
                "geonameid": "5391959",
                "id": "Geoname_5391959",
                "modification_date": "2017-06-15",
                "name": "San Francisco",
                "population": 864816,
                "subdivision": {
                    "country_code_2": "US",
                    "name": "California",
                    "subdivision_code": "US-CA",
                    "type": "State"
                },
                "timezone": "America/Los_Angeles"
            },
            "features": {
                "clouds_percent": 44,
                "humidity_percent": 83,
                "pressure": {
                    "hPa": 1027.12,
                    "inHg": 30.33,
                    "mmHg": 770.4
                },
                "rain": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "snow": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "temperature": {
                    "celsius": 8.36,
                    "fahrenheit": 32
                },
                "wind_direction_degrees": 297.002,
                "wind_speed": {
                    "meters_per_second": 3.42,
                    "miles_per_hour": 7.65
                }
            },
            "is_current": false,
            "measure_time": {
                "countdown": 42931,
                "datetime": "2018-02-21T03:00:00+0000",
                "timestamp": 1519182000
            },
            "start_datetime": {
                "countdown": 46531,
                "datetime": "2018-02-21T04:00:00+0000",
                "timestamp": 1519185600
            },
            "weather_conditions": [
                {
                    "description": "scattered clouds",
                    "icon": "03n",
                    "icon_url": "http://openweathermap.org/img/w/03n",
                    "id": 802,
                    "main": "Clouds"
                }
            ]
        }
    ]
}

The above example returns 9 hours in a day when there will be clouds in San Francisco in the next 24 hours.

You can see all the properties of the WeatherStatus entity and use any of them in the WHERE clause of HQL query:

{
            "_entity_type": "WeatherStatus",
            "_id": "WeatherStatus_Geoname_5391959-1519178400",
            "city": {
                "_entity_type": "City",
                "_id": "Geoname_5391959",
                "admin1_code": "CA",
                "admin2_code": "075",
                "admin3_code": null,
                "admin4_code": null,
                "alternative_names": [
                    "Franciscopolis",
                    "Frisco",
                    "Gorad San-Francyska",
                    "Kapalakiko",
                    "Khiu-kim-san",
                    "Khiu-kîm-sân",
                    "Lungsod ng San Francisco",
                    "New Albion",
                    "SF",
                    "SFO",
                    "San Francisco",
                    "San Franciscu",
                    "San Francisko",
                    "San Fransisco",
                    "San Fransiskas",
                    "San Fransisko",
                    "San Frantzisko",
                    "San Phransisko",
                    "San-Francisko",
                    "San-Fransisko",
                    "Sanfrancisko",
                    "Sao Francisco",
                    "São Francisco",
                    "Yerba Buena",
                    "can pirancisko",
                    "jiu jin shan",
                    "saenpeulan",
                    "saenpeulansiseuko",
                    "saina pharansisako",
                    "saina phransisko",
                    "san f ran si s ko",
                    "san fan shi",
                    "san fransskw",
                    "san fransyskw",
                    "san fransyskۆ",
                    "san phransisko",
                    "sana phransisako ka'unti",
                    "sana phransisko",
                    "sanfuranshisuko",
                    "sena phransisko",
                    "sn prnsysqw",
                    "syana phransisko",
                    "Σαν Φρανσίσκο",
                    "Горад Сан-Францыска",
                    "Сан Франсиско",
                    "Сан Франциско",
                    "Сан-Франциско",
                    "Сан-Франціско",
                    "Սան Ֆրանցիսկո",
                    "סאן פראנציסקא",
                    "סן פרנסיסקו",
                    "سان فرانسسکو",
                    "سان فرانسيسكو",
                    "سان فرانسیسکو",
                    "سان فرانسیسکۆ",
                    "सॅन फ्रान्सिस्को",
                    "सैन फ्रांसिस्को",
                    "स्यान फ्रान्सिस्को",
                    "সান ফ্রান্সিসকো কাউন্টি",
                    "সান ফ্রান্সিস্কো",
                    "ਸੈਨ ਫਰਾਂਸਿਸਕੋ",
                    "சான் பிரான்சிஸ்கோ",
                    "శాన్ ఫ్రాన్సిస్కో",
                    "സാൻ ഫ്രാൻസിസ്കോ",
                    "සැන් ෆ්\u200dරැන්සිස්කෝ",
                    "ซานฟรานซิสโก",
                    "སན་ཧྥུ་རན་སིས་ཁོ",
                    "ဆန်ဖရန်စစ္စကိုမြို့",
                    "სან-ფრანცისკო",
                    "サンフランシスコ",
                    "三藩市",
                    "旧金山",
                    "舊金山",
                    "샌프란",
                    "샌프란시스코"
                ],
                "ascii_name": "San Francisco",
                "coordinates": "37.77493,-122.41942",
                "country": {
                    "country_code_2": "US",
                    "country_code_3": "USA",
                    "country_numeric_code": "840",
                    "name": "United States",
                    "official_name": "United States of America"
                },
                "dem": "28",
                "elevation": 16,
                "feature_class": "P",
                "feature_code": "PPLA2",
                "geonameid": "5391959",
                "id": "Geoname_5391959",
                "modification_date": "2017-06-15",
                "name": "San Francisco",
                "population": 864816,
                "subdivision": {
                    "country_code_2": "US",
                    "name": "California",
                    "subdivision_code": "US-CA",
                    "type": "State"
                },
                "timezone": "America/Los_Angeles"
            },
            "features": {
                "clouds_percent": 44,
                "humidity_percent": 83,
                "pressure": {
                    "hPa": 1027.12,
                    "inHg": 30.33,
                    "mmHg": 770.4
                },
                "rain": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "snow": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "temperature": {
                    "celsius": 8.36,
                    "fahrenheit": 32
                },
                "wind_direction_degrees": 297.002,
                "wind_speed": {
                    "meters_per_second": 3.42,
                    "miles_per_hour": 7.65
                }
            },
            "is_current": false,
            "measure_time": {
                "countdown": 42931,
                "datetime": "2018-02-21T03:00:00+0000",
                "timestamp": 1519182000
            },
            "start_datetime": {
                "countdown": 39331,
                "datetime": "2018-02-21T02:00:00+0000",
                "timestamp": 1519178400
            },
            "weather_conditions": [
                {
                    "description": "scattered clouds",
                    "icon": "03n",
                    "icon_url": "http://openweathermap.org/img/w/03n",
                    "id": 802,
                    "main": "Clouds"
                }
            ]
        }

Step 2: Customize subscription

Hooks provide an elegant mechanism for creating subscriptions using Hooks Query Language. It has a similar notation to SQL and lets you define each subscription with a simple HQL query. 

To create a subscription to “Get an update 24 hours before it rains in San Francisco” you can use this HQL query:

SELECT * FROM WeatherByCity
(geonameid = '5391959')
WHERE weather_conditions.main = 'Rain' and
start_datetime.countdown <= 86400

Once this HQL query has new results – 24 hours before it rains in San Francisco – Hooks will send you WeatherStatus object to your webhook:

{
    "matches_count": 11,
    "results": [
        {
            "_entity_type": "WeatherStatus",
            "_id": "WeatherStatus_Geoname_5391959-1519189200",
            "city": {
                "_entity_type": "City",
                "_id": "Geoname_5391959",
                "admin1_code": "CA",
                "admin2_code": "075",
                "admin3_code": null,
                "admin4_code": null,
                "alternative_names": [
                    "Franciscopolis",
                    "Frisco",
                    "Gorad San-Francyska",
                    "Kapalakiko",
                    "Khiu-kim-san",
                    "Khiu-kîm-sân",
                    "Lungsod ng San Francisco",
                    "New Albion",
                    "SF",
                    "SFO",
                    "San Francisco",
                    "San Franciscu",
                    "San Francisko",
                    "San Fransisco",
                    "San Fransiskas",
                    "San Fransisko",
                    "San Frantzisko",
                    "San Phransisko",
                    "San-Francisko",
                    "San-Fransisko",
                    "Sanfrancisko",
                    "Sao Francisco",
                    "São Francisco",
                    "Yerba Buena",
                    "can pirancisko",
                    "jiu jin shan",
                    "saenpeulan",
                    "saenpeulansiseuko",
                    "saina pharansisako",
                    "saina phransisko",
                    "san f ran si s ko",
                    "san fan shi",
                    "san fransskw",
                    "san fransyskw",
                    "san fransyskۆ",
                    "san phransisko",
                    "sana phransisako ka'unti",
                    "sana phransisko",
                    "sanfuranshisuko",
                    "sena phransisko",
                    "sn prnsysqw",
                    "syana phransisko",
                    "Σαν Φρανσίσκο",
                    "Горад Сан-Францыска",
                    "Сан Франсиско",
                    "Сан Франциско",
                    "Сан-Франциско",
                    "Сан-Франціско",
                    "Սան Ֆրանցիսկո",
                    "סאן פראנציסקא",
                    "סן פרנסיסקו",
                    "سان فرانسسکو",
                    "سان فرانسيسكو",
                    "سان فرانسیسکو",
                    "سان فرانسیسکۆ",
                    "सॅन फ्रान्सिस्को",
                    "सैन फ्रांसिस्को",
                    "स्यान फ्रान्सिस्को",
                    "সান ফ্রান্সিসকো কাউন্টি",
                    "সান ফ্রান্সিস্কো",
                    "ਸੈਨ ਫਰਾਂਸਿਸਕੋ",
                    "சான் பிரான்சிஸ்கோ",
                    "శాన్ ఫ్రాన్సిస్కో",
                    "സാൻ ഫ്രാൻസിസ്കോ",
                    "සැන් ෆ්‍රැන්සිස්කෝ",
                    "ซานฟรานซิสโก",
                    "སན་ཧྥུ་རན་སིས་ཁོ",
                    "ဆန်ဖရန်စစ္စကိုမြို့",
                    "სან-ფრანცისკო",
                    "サンフランシスコ",
                    "三藩市",
                    "旧金山",
                    "舊金山",
                    "샌프란",
                    "샌프란시스코"
                ],
                "ascii_name": "San Francisco",
                "coordinates": "37.77493,-122.41942",
                "country": {
                    "country_code_2": "US",
                    "country_code_3": "USA",
                    "country_numeric_code": "840",
                    "name": "United States",
                    "official_name": "United States of America"
                },
                "dem": "28",
                "elevation": 16,
                "feature_class": "P",
                "feature_code": "PPLA2",
                "geonameid": "5391959",
                "id": "Geoname_5391959",
                "modification_date": "2017-06-15",
                "name": "San Francisco",
                "population": 864816,
                "subdivision": {
                    "country_code_2": "US",
                    "name": "California",
                    "subdivision_code": "US-CA",
                    "type": "State"
                },
                "timezone": "America/Los_Angeles"
            },
            "features": {
                "clouds_percent": 76,
                "humidity_percent": 100,
                "pressure": {
                    "hPa": 1027.26,
                    "inHg": 30.33,
                    "mmHg": 770.51
                },
                "rain": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "snow": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "temperature": {
                    "celsius": 6.73,
                    "fahrenheit": 32
                },
                "wind_direction_degrees": 290,
                "wind_speed": {
                    "meters_per_second": 2.76,
                    "miles_per_hour": 6.17
                }
            },
            "is_current": false,
            "measure_time": {
                "countdown": 51630,
                "datetime": "2018-02-21T06:00:00+0000",
                "timestamp": 1519192800
            },
            "start_datetime": {
                "countdown": 48030,
                "datetime": "2018-02-21T05:00:00+0000",
                "timestamp": 1519189200
            },
            "weather_conditions": [
                {
                    "description": "light rain",
                    "icon": "10n",
                    "icon_url": "http://openweathermap.org/img/w/10n",
                    "id": 500,
                    "main": "Rain"
                }
            ]
        },
        {
            "_entity_type": "WeatherStatus",
            "_id": "WeatherStatus_Geoname_5391959-1519192800",
            "city": {
                "_entity_type": "City",
                "_id": "Geoname_5391959",
                "admin1_code": "CA",
                "admin2_code": "075",
                "admin3_code": null,
                "admin4_code": null,
                "alternative_names": [
                    "Franciscopolis",
                    "Frisco",
                    "Gorad San-Francyska",
                    "Kapalakiko",
                    "Khiu-kim-san",
                    "Khiu-kîm-sân",
                    "Lungsod ng San Francisco",
                    "New Albion",
                    "SF",
                    "SFO",
                    "San Francisco",
                    "San Franciscu",
                    "San Francisko",
                    "San Fransisco",
                    "San Fransiskas",
                    "San Fransisko",
                    "San Frantzisko",
                    "San Phransisko",
                    "San-Francisko",
                    "San-Fransisko",
                    "Sanfrancisko",
                    "Sao Francisco",
                    "São Francisco",
                    "Yerba Buena",
                    "can pirancisko",
                    "jiu jin shan",
                    "saenpeulan",
                    "saenpeulansiseuko",
                    "saina pharansisako",
                    "saina phransisko",
                    "san f ran si s ko",
                    "san fan shi",
                    "san fransskw",
                    "san fransyskw",
                    "san fransyskۆ",
                    "san phransisko",
                    "sana phransisako ka'unti",
                    "sana phransisko",
                    "sanfuranshisuko",
                    "sena phransisko",
                    "sn prnsysqw",
                    "syana phransisko",
                    "Σαν Φρανσίσκο",
                    "Горад Сан-Францыска",
                    "Сан Франсиско",
                    "Сан Франциско",
                    "Сан-Франциско",
                    "Сан-Франціско",
                    "Սան Ֆրանցիսկո",
                    "סאן פראנציסקא",
                    "סן פרנסיסקו",
                    "سان فرانسسکو",
                    "سان فرانسيسكو",
                    "سان فرانسیسکو",
                    "سان فرانسیسکۆ",
                    "सॅन फ्रान्सिस्को",
                    "सैन फ्रांसिस्को",
                    "स्यान फ्रान्सिस्को",
                    "সান ফ্রান্সিসকো কাউন্টি",
                    "সান ফ্রান্সিস্কো",
                    "ਸੈਨ ਫਰਾਂਸਿਸਕੋ",
                    "சான் பிரான்சிஸ்கோ",
                    "శాన్ ఫ్రాన్సిస్కో",
                    "സാൻ ഫ്രാൻസിസ്കോ",
                    "සැන් ෆ්‍රැන්සිස්කෝ",
                    "ซานฟรานซิสโก",
                    "སན་ཧྥུ་རན་སིས་ཁོ",
                    "ဆန်ဖရန်စစ္စကိုမြို့",
                    "სან-ფრანცისკო",
                    "サンフランシスコ",
                    "三藩市",
                    "旧金山",
                    "舊金山",
                    "샌프란",
                    "샌프란시스코"
                ],
                "ascii_name": "San Francisco",
                "coordinates": "37.77493,-122.41942",
                "country": {
                    "country_code_2": "US",
                    "country_code_3": "USA",
                    "country_numeric_code": "840",
                    "name": "United States",
                    "official_name": "United States of America"
                },
                "dem": "28",
                "elevation": 16,
                "feature_class": "P",
                "feature_code": "PPLA2",
                "geonameid": "5391959",
                "id": "Geoname_5391959",
                "modification_date": "2017-06-15",
                "name": "San Francisco",
                "population": 864816,
                "subdivision": {
                    "country_code_2": "US",
                    "name": "California",
                    "subdivision_code": "US-CA",
                    "type": "State"
                },
                "timezone": "America/Los_Angeles"
            },
            "features": {
                "clouds_percent": 76,
                "humidity_percent": 100,
                "pressure": {
                    "hPa": 1027.26,
                    "inHg": 30.33,
                    "mmHg": 770.51
                },
                "rain": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "snow": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "temperature": {
                    "celsius": 6.73,
                    "fahrenheit": 32
                },
                "wind_direction_degrees": 290,
                "wind_speed": {
                    "meters_per_second": 2.76,
                    "miles_per_hour": 6.17
                }
            },
            "is_current": false,
            "measure_time": {
                "countdown": 51630,
                "datetime": "2018-02-21T06:00:00+0000",
                "timestamp": 1519192800
            },
            "start_datetime": {
                "countdown": 51630,
                "datetime": "2018-02-21T06:00:00+0000",
                "timestamp": 1519192800
            },
            "weather_conditions": [
                {
                    "description": "light rain",
                    "icon": "10n",
                    "icon_url": "http://openweathermap.org/img/w/10n",
                    "id": 500,
                    "main": "Rain"
                }
            ]
        },
        {
            "_entity_type": "WeatherStatus",
            "_id": "WeatherStatus_Geoname_5391959-1519196400",
            "city": {
                "_entity_type": "City",
                "_id": "Geoname_5391959",
                "admin1_code": "CA",
                "admin2_code": "075",
                "admin3_code": null,
                "admin4_code": null,
                "alternative_names": [
                    "Franciscopolis",
                    "Frisco",
                    "Gorad San-Francyska",
                    "Kapalakiko",
                    "Khiu-kim-san",
                    "Khiu-kîm-sân",
                    "Lungsod ng San Francisco",
                    "New Albion",
                    "SF",
                    "SFO",
                    "San Francisco",
                    "San Franciscu",
                    "San Francisko",
                    "San Fransisco",
                    "San Fransiskas",
                    "San Fransisko",
                    "San Frantzisko",
                    "San Phransisko",
                    "San-Francisko",
                    "San-Fransisko",
                    "Sanfrancisko",
                    "Sao Francisco",
                    "São Francisco",
                    "Yerba Buena",
                    "can pirancisko",
                    "jiu jin shan",
                    "saenpeulan",
                    "saenpeulansiseuko",
                    "saina pharansisako",
                    "saina phransisko",
                    "san f ran si s ko",
                    "san fan shi",
                    "san fransskw",
                    "san fransyskw",
                    "san fransyskۆ",
                    "san phransisko",
                    "sana phransisako ka'unti",
                    "sana phransisko",
                    "sanfuranshisuko",
                    "sena phransisko",
                    "sn prnsysqw",
                    "syana phransisko",
                    "Σαν Φρανσίσκο",
                    "Горад Сан-Францыска",
                    "Сан Франсиско",
                    "Сан Франциско",
                    "Сан-Франциско",
                    "Сан-Франціско",
                    "Սան Ֆրանցիսկո",
                    "סאן פראנציסקא",
                    "סן פרנסיסקו",
                    "سان فرانسسکو",
                    "سان فرانسيسكو",
                    "سان فرانسیسکو",
                    "سان فرانسیسکۆ",
                    "सॅन फ्रान्सिस्को",
                    "सैन फ्रांसिस्को",
                    "स्यान फ्रान्सिस्को",
                    "সান ফ্রান্সিসকো কাউন্টি",
                    "সান ফ্রান্সিস্কো",
                    "ਸੈਨ ਫਰਾਂਸਿਸਕੋ",
                    "சான் பிரான்சிஸ்கோ",
                    "శాన్ ఫ్రాన్సిస్కో",
                    "സാൻ ഫ്രാൻസിസ്കോ",
                    "සැන් ෆ්‍රැන්සිස්කෝ",
                    "ซานฟรานซิสโก",
                    "སན་ཧྥུ་རན་སིས་ཁོ",
                    "ဆန်ဖရန်စစ္စကိုမြို့",
                    "სან-ფრანცისკო",
                    "サンフランシスコ",
                    "三藩市",
                    "旧金山",
                    "舊金山",
                    "샌프란",
                    "샌프란시스코"
                ],
                "ascii_name": "San Francisco",
                "coordinates": "37.77493,-122.41942",
                "country": {
                    "country_code_2": "US",
                    "country_code_3": "USA",
                    "country_numeric_code": "840",
                    "name": "United States",
                    "official_name": "United States of America"
                },
                "dem": "28",
                "elevation": 16,
                "feature_class": "P",
                "feature_code": "PPLA2",
                "geonameid": "5391959",
                "id": "Geoname_5391959",
                "modification_date": "2017-06-15",
                "name": "San Francisco",
                "population": 864816,
                "subdivision": {
                    "country_code_2": "US",
                    "name": "California",
                    "subdivision_code": "US-CA",
                    "type": "State"
                },
                "timezone": "America/Los_Angeles"
            },
            "features": {
                "clouds_percent": 76,
                "humidity_percent": 100,
                "pressure": {
                    "hPa": 1027.26,
                    "inHg": 30.33,
                    "mmHg": 770.51
                },
                "rain": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "snow": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "temperature": {
                    "celsius": 6.73,
                    "fahrenheit": 32
                },
                "wind_direction_degrees": 290,
                "wind_speed": {
                    "meters_per_second": 2.76,
                    "miles_per_hour": 6.17
                }
            },
            "is_current": false,
            "measure_time": {
                "countdown": 51630,
                "datetime": "2018-02-21T06:00:00+0000",
                "timestamp": 1519192800
            },
            "start_datetime": {
                "countdown": 55230,
                "datetime": "2018-02-21T07:00:00+0000",
                "timestamp": 1519196400
            },
            "weather_conditions": [
                {
                    "description": "light rain",
                    "icon": "10n",
                    "icon_url": "http://openweathermap.org/img/w/10n",
                    "id": 500,
                    "main": "Rain"
                }
            ]
        },
        {
            "_entity_type": "WeatherStatus",
            "_id": "WeatherStatus_Geoname_5391959-1519200000",
            "city": {
                "_entity_type": "City",
                "_id": "Geoname_5391959",
                "admin1_code": "CA",
                "admin2_code": "075",
                "admin3_code": null,
                "admin4_code": null,
                "alternative_names": [
                    "Franciscopolis",
                    "Frisco",
                    "Gorad San-Francyska",
                    "Kapalakiko",
                    "Khiu-kim-san",
                    "Khiu-kîm-sân",
                    "Lungsod ng San Francisco",
                    "New Albion",
                    "SF",
                    "SFO",
                    "San Francisco",
                    "San Franciscu",
                    "San Francisko",
                    "San Fransisco",
                    "San Fransiskas",
                    "San Fransisko",
                    "San Frantzisko",
                    "San Phransisko",
                    "San-Francisko",
                    "San-Fransisko",
                    "Sanfrancisko",
                    "Sao Francisco",
                    "São Francisco",
                    "Yerba Buena",
                    "can pirancisko",
                    "jiu jin shan",
                    "saenpeulan",
                    "saenpeulansiseuko",
                    "saina pharansisako",
                    "saina phransisko",
                    "san f ran si s ko",
                    "san fan shi",
                    "san fransskw",
                    "san fransyskw",
                    "san fransyskۆ",
                    "san phransisko",
                    "sana phransisako ka'unti",
                    "sana phransisko",
                    "sanfuranshisuko",
                    "sena phransisko",
                    "sn prnsysqw",
                    "syana phransisko",
                    "Σαν Φρανσίσκο",
                    "Горад Сан-Францыска",
                    "Сан Франсиско",
                    "Сан Франциско",
                    "Сан-Франциско",
                    "Сан-Франціско",
                    "Սան Ֆրանցիսկո",
                    "סאן פראנציסקא",
                    "סן פרנסיסקו",
                    "سان فرانسسکو",
                    "سان فرانسيسكو",
                    "سان فرانسیسکو",
                    "سان فرانسیسکۆ",
                    "सॅन फ्रान्सिस्को",
                    "सैन फ्रांसिस्को",
                    "स्यान फ्रान्सिस्को",
                    "সান ফ্রান্সিসকো কাউন্টি",
                    "সান ফ্রান্সিস্কো",
                    "ਸੈਨ ਫਰਾਂਸਿਸਕੋ",
                    "சான் பிரான்சிஸ்கோ",
                    "శాన్ ఫ్రాన్సిస్కో",
                    "സാൻ ഫ്രാൻസിസ്കോ",
                    "සැන් ෆ්‍රැන්සිස්කෝ",
                    "ซานฟรานซิสโก",
                    "སན་ཧྥུ་རན་སིས་ཁོ",
                    "ဆန်ဖရန်စစ္စကိုမြို့",
                    "სან-ფრანცისკო",
                    "サンフランシスコ",
                    "三藩市",
                    "旧金山",
                    "舊金山",
                    "샌프란",
                    "샌프란시스코"
                ],
                "ascii_name": "San Francisco",
                "coordinates": "37.77493,-122.41942",
                "country": {
                    "country_code_2": "US",
                    "country_code_3": "USA",
                    "country_numeric_code": "840",
                    "name": "United States",
                    "official_name": "United States of America"
                },
                "dem": "28",
                "elevation": 16,
                "feature_class": "P",
                "feature_code": "PPLA2",
                "geonameid": "5391959",
                "id": "Geoname_5391959",
                "modification_date": "2017-06-15",
                "name": "San Francisco",
                "population": 864816,
                "subdivision": {
                    "country_code_2": "US",
                    "name": "California",
                    "subdivision_code": "US-CA",
                    "type": "State"
                },
                "timezone": "America/Los_Angeles"
            },
            "features": {
                "clouds_percent": 68,
                "humidity_percent": 100,
                "pressure": {
                    "hPa": 1026.7,
                    "inHg": 30.32,
                    "mmHg": 770.09
                },
                "rain": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "snow": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "temperature": {
                    "celsius": 5.3,
                    "fahrenheit": 32
                },
                "wind_direction_degrees": 261.003,
                "wind_speed": {
                    "meters_per_second": 1.38,
                    "miles_per_hour": 3.09
                }
            },
            "is_current": false,
            "measure_time": {
                "countdown": 62430,
                "datetime": "2018-02-21T09:00:00+0000",
                "timestamp": 1519203600
            },
            "start_datetime": {
                "countdown": 58830,
                "datetime": "2018-02-21T08:00:00+0000",
                "timestamp": 1519200000
            },
            "weather_conditions": [
                {
                    "description": "light rain",
                    "icon": "10n",
                    "icon_url": "http://openweathermap.org/img/w/10n",
                    "id": 500,
                    "main": "Rain"
                }
            ]
        },
        {
            "_entity_type": "WeatherStatus",
            "_id": "WeatherStatus_Geoname_5391959-1519203600",
            "city": {
                "_entity_type": "City",
                "_id": "Geoname_5391959",
                "admin1_code": "CA",
                "admin2_code": "075",
                "admin3_code": null,
                "admin4_code": null,
                "alternative_names": [
                    "Franciscopolis",
                    "Frisco",
                    "Gorad San-Francyska",
                    "Kapalakiko",
                    "Khiu-kim-san",
                    "Khiu-kîm-sân",
                    "Lungsod ng San Francisco",
                    "New Albion",
                    "SF",
                    "SFO",
                    "San Francisco",
                    "San Franciscu",
                    "San Francisko",
                    "San Fransisco",
                    "San Fransiskas",
                    "San Fransisko",
                    "San Frantzisko",
                    "San Phransisko",
                    "San-Francisko",
                    "San-Fransisko",
                    "Sanfrancisko",
                    "Sao Francisco",
                    "São Francisco",
                    "Yerba Buena",
                    "can pirancisko",
                    "jiu jin shan",
                    "saenpeulan",
                    "saenpeulansiseuko",
                    "saina pharansisako",
                    "saina phransisko",
                    "san f ran si s ko",
                    "san fan shi",
                    "san fransskw",
                    "san fransyskw",
                    "san fransyskۆ",
                    "san phransisko",
                    "sana phransisako ka'unti",
                    "sana phransisko",
                    "sanfuranshisuko",
                    "sena phransisko",
                    "sn prnsysqw",
                    "syana phransisko",
                    "Σαν Φρανσίσκο",
                    "Горад Сан-Францыска",
                    "Сан Франсиско",
                    "Сан Франциско",
                    "Сан-Франциско",
                    "Сан-Франціско",
                    "Սան Ֆրանցիսկո",
                    "סאן פראנציסקא",
                    "סן פרנסיסקו",
                    "سان فرانسسکو",
                    "سان فرانسيسكو",
                    "سان فرانسیسکو",
                    "سان فرانسیسکۆ",
                    "सॅन फ्रान्सिस्को",
                    "सैन फ्रांसिस्को",
                    "स्यान फ्रान्सिस्को",
                    "সান ফ্রান্সিসকো কাউন্টি",
                    "সান ফ্রান্সিস্কো",
                    "ਸੈਨ ਫਰਾਂਸਿਸਕੋ",
                    "சான் பிரான்சிஸ்கோ",
                    "శాన్ ఫ్రాన్సిస్కో",
                    "സാൻ ഫ്രാൻസിസ്കോ",
                    "සැන් ෆ්‍රැන්සිස්කෝ",
                    "ซานฟรานซิสโก",
                    "སན་ཧྥུ་རན་སིས་ཁོ",
                    "ဆန်ဖရန်စစ္စကိုမြို့",
                    "სან-ფრანცისკო",
                    "サンフランシスコ",
                    "三藩市",
                    "旧金山",
                    "舊金山",
                    "샌프란",
                    "샌프란시스코"
                ],
                "ascii_name": "San Francisco",
                "coordinates": "37.77493,-122.41942",
                "country": {
                    "country_code_2": "US",
                    "country_code_3": "USA",
                    "country_numeric_code": "840",
                    "name": "United States",
                    "official_name": "United States of America"
                },
                "dem": "28",
                "elevation": 16,
                "feature_class": "P",
                "feature_code": "PPLA2",
                "geonameid": "5391959",
                "id": "Geoname_5391959",
                "modification_date": "2017-06-15",
                "name": "San Francisco",
                "population": 864816,
                "subdivision": {
                    "country_code_2": "US",
                    "name": "California",
                    "subdivision_code": "US-CA",
                    "type": "State"
                },
                "timezone": "America/Los_Angeles"
            },
            "features": {
                "clouds_percent": 68,
                "humidity_percent": 100,
                "pressure": {
                    "hPa": 1026.7,
                    "inHg": 30.32,
                    "mmHg": 770.09
                },
                "rain": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "snow": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "temperature": {
                    "celsius": 5.3,
                    "fahrenheit": 32
                },
                "wind_direction_degrees": 261.003,
                "wind_speed": {
                    "meters_per_second": 1.38,
                    "miles_per_hour": 3.09
                }
            },
            "is_current": false,
            "measure_time": {
                "countdown": 62430,
                "datetime": "2018-02-21T09:00:00+0000",
                "timestamp": 1519203600
            },
            "start_datetime": {
                "countdown": 62430,
                "datetime": "2018-02-21T09:00:00+0000",
                "timestamp": 1519203600
            },
            "weather_conditions": [
                {
                    "description": "light rain",
                    "icon": "10n",
                    "icon_url": "http://openweathermap.org/img/w/10n",
                    "id": 500,
                    "main": "Rain"
                }
            ]
        },
        {
            "_entity_type": "WeatherStatus",
            "_id": "WeatherStatus_Geoname_5391959-1519207200",
            "city": {
                "_entity_type": "City",
                "_id": "Geoname_5391959",
                "admin1_code": "CA",
                "admin2_code": "075",
                "admin3_code": null,
                "admin4_code": null,
                "alternative_names": [
                    "Franciscopolis",
                    "Frisco",
                    "Gorad San-Francyska",
                    "Kapalakiko",
                    "Khiu-kim-san",
                    "Khiu-kîm-sân",
                    "Lungsod ng San Francisco",
                    "New Albion",
                    "SF",
                    "SFO",
                    "San Francisco",
                    "San Franciscu",
                    "San Francisko",
                    "San Fransisco",
                    "San Fransiskas",
                    "San Fransisko",
                    "San Frantzisko",
                    "San Phransisko",
                    "San-Francisko",
                    "San-Fransisko",
                    "Sanfrancisko",
                    "Sao Francisco",
                    "São Francisco",
                    "Yerba Buena",
                    "can pirancisko",
                    "jiu jin shan",
                    "saenpeulan",
                    "saenpeulansiseuko",
                    "saina pharansisako",
                    "saina phransisko",
                    "san f ran si s ko",
                    "san fan shi",
                    "san fransskw",
                    "san fransyskw",
                    "san fransyskۆ",
                    "san phransisko",
                    "sana phransisako ka'unti",
                    "sana phransisko",
                    "sanfuranshisuko",
                    "sena phransisko",
                    "sn prnsysqw",
                    "syana phransisko",
                    "Σαν Φρανσίσκο",
                    "Горад Сан-Францыска",
                    "Сан Франсиско",
                    "Сан Франциско",
                    "Сан-Франциско",
                    "Сан-Франціско",
                    "Սան Ֆրանցիսկո",
                    "סאן פראנציסקא",
                    "סן פרנסיסקו",
                    "سان فرانسسکو",
                    "سان فرانسيسكو",
                    "سان فرانسیسکو",
                    "سان فرانسیسکۆ",
                    "सॅन फ्रान्सिस्को",
                    "सैन फ्रांसिस्को",
                    "स्यान फ्रान्सिस्को",
                    "সান ফ্রান্সিসকো কাউন্টি",
                    "সান ফ্রান্সিস্কো",
                    "ਸੈਨ ਫਰਾਂਸਿਸਕੋ",
                    "சான் பிரான்சிஸ்கோ",
                    "శాన్ ఫ్రాన్సిస్కో",
                    "സാൻ ഫ്രാൻസിസ്കോ",
                    "සැන් ෆ්‍රැන්සිස්කෝ",
                    "ซานฟรานซิสโก",
                    "སན་ཧྥུ་རན་སིས་ཁོ",
                    "ဆန်ဖရန်စစ္စကိုမြို့",
                    "სან-ფრანცისკო",
                    "サンフランシスコ",
                    "三藩市",
                    "旧金山",
                    "舊金山",
                    "샌프란",
                    "샌프란시스코"
                ],
                "ascii_name": "San Francisco",
                "coordinates": "37.77493,-122.41942",
                "country": {
                    "country_code_2": "US",
                    "country_code_3": "USA",
                    "country_numeric_code": "840",
                    "name": "United States",
                    "official_name": "United States of America"
                },
                "dem": "28",
                "elevation": 16,
                "feature_class": "P",
                "feature_code": "PPLA2",
                "geonameid": "5391959",
                "id": "Geoname_5391959",
                "modification_date": "2017-06-15",
                "name": "San Francisco",
                "population": 864816,
                "subdivision": {
                    "country_code_2": "US",
                    "name": "California",
                    "subdivision_code": "US-CA",
                    "type": "State"
                },
                "timezone": "America/Los_Angeles"
            },
            "features": {
                "clouds_percent": 68,
                "humidity_percent": 100,
                "pressure": {
                    "hPa": 1026.7,
                    "inHg": 30.32,
                    "mmHg": 770.09
                },
                "rain": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "snow": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "temperature": {
                    "celsius": 5.3,
                    "fahrenheit": 32
                },
                "wind_direction_degrees": 261.003,
                "wind_speed": {
                    "meters_per_second": 1.38,
                    "miles_per_hour": 3.09
                }
            },
            "is_current": false,
            "measure_time": {
                "countdown": 62430,
                "datetime": "2018-02-21T09:00:00+0000",
                "timestamp": 1519203600
            },
            "start_datetime": {
                "countdown": 66030,
                "datetime": "2018-02-21T10:00:00+0000",
                "timestamp": 1519207200
            },
            "weather_conditions": [
                {
                    "description": "light rain",
                    "icon": "10n",
                    "icon_url": "http://openweathermap.org/img/w/10n",
                    "id": 500,
                    "main": "Rain"
                }
            ]
        },
        {
            "_entity_type": "WeatherStatus",
            "_id": "WeatherStatus_Geoname_5391959-1519210800",
            "city": {
                "_entity_type": "City",
                "_id": "Geoname_5391959",
                "admin1_code": "CA",
                "admin2_code": "075",
                "admin3_code": null,
                "admin4_code": null,
                "alternative_names": [
                    "Franciscopolis",
                    "Frisco",
                    "Gorad San-Francyska",
                    "Kapalakiko",
                    "Khiu-kim-san",
                    "Khiu-kîm-sân",
                    "Lungsod ng San Francisco",
                    "New Albion",
                    "SF",
                    "SFO",
                    "San Francisco",
                    "San Franciscu",
                    "San Francisko",
                    "San Fransisco",
                    "San Fransiskas",
                    "San Fransisko",
                    "San Frantzisko",
                    "San Phransisko",
                    "San-Francisko",
                    "San-Fransisko",
                    "Sanfrancisko",
                    "Sao Francisco",
                    "São Francisco",
                    "Yerba Buena",
                    "can pirancisko",
                    "jiu jin shan",
                    "saenpeulan",
                    "saenpeulansiseuko",
                    "saina pharansisako",
                    "saina phransisko",
                    "san f ran si s ko",
                    "san fan shi",
                    "san fransskw",
                    "san fransyskw",
                    "san fransyskۆ",
                    "san phransisko",
                    "sana phransisako ka'unti",
                    "sana phransisko",
                    "sanfuranshisuko",
                    "sena phransisko",
                    "sn prnsysqw",
                    "syana phransisko",
                    "Σαν Φρανσίσκο",
                    "Горад Сан-Францыска",
                    "Сан Франсиско",
                    "Сан Франциско",
                    "Сан-Франциско",
                    "Сан-Франціско",
                    "Սան Ֆրանցիսկո",
                    "סאן פראנציסקא",
                    "סן פרנסיסקו",
                    "سان فرانسسکو",
                    "سان فرانسيسكو",
                    "سان فرانسیسکو",
                    "سان فرانسیسکۆ",
                    "सॅन फ्रान्सिस्को",
                    "सैन फ्रांसिस्को",
                    "स्यान फ्रान्सिस्को",
                    "সান ফ্রান্সিসকো কাউন্টি",
                    "সান ফ্রান্সিস্কো",
                    "ਸੈਨ ਫਰਾਂਸਿਸਕੋ",
                    "சான் பிரான்சிஸ்கோ",
                    "శాన్ ఫ్రాన్సిస్కో",
                    "സാൻ ഫ്രാൻസിസ്കോ",
                    "සැන් ෆ්‍රැන්සිස්කෝ",
                    "ซานฟรานซิสโก",
                    "སན་ཧྥུ་རན་སིས་ཁོ",
                    "ဆန်ဖရန်စစ္စကိုမြို့",
                    "სან-ფრანცისკო",
                    "サンフランシスコ",
                    "三藩市",
                    "旧金山",
                    "舊金山",
                    "샌프란",
                    "샌프란시스코"
                ],
                "ascii_name": "San Francisco",
                "coordinates": "37.77493,-122.41942",
                "country": {
                    "country_code_2": "US",
                    "country_code_3": "USA",
                    "country_numeric_code": "840",
                    "name": "United States",
                    "official_name": "United States of America"
                },
                "dem": "28",
                "elevation": 16,
                "feature_class": "P",
                "feature_code": "PPLA2",
                "geonameid": "5391959",
                "id": "Geoname_5391959",
                "modification_date": "2017-06-15",
                "name": "San Francisco",
                "population": 864816,
                "subdivision": {
                    "country_code_2": "US",
                    "name": "California",
                    "subdivision_code": "US-CA",
                    "type": "State"
                },
                "timezone": "America/Los_Angeles"
            },
            "features": {
                "clouds_percent": 88,
                "humidity_percent": 100,
                "pressure": {
                    "hPa": 1026.41,
                    "inHg": 30.31,
                    "mmHg": 769.87
                },
                "rain": {
                    "inch_hour": 0,
                    "mm_hour": 0.06
                },
                "snow": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "temperature": {
                    "celsius": 5.14,
                    "fahrenheit": 32
                },
                "wind_direction_degrees": 46.5015,
                "wind_speed": {
                    "meters_per_second": 0.27,
                    "miles_per_hour": 0.6
                }
            },
            "is_current": false,
            "measure_time": {
                "countdown": 73230,
                "datetime": "2018-02-21T12:00:00+0000",
                "timestamp": 1519214400
            },
            "start_datetime": {
                "countdown": 69630,
                "datetime": "2018-02-21T11:00:00+0000",
                "timestamp": 1519210800
            },
            "weather_conditions": [
                {
                    "description": "light rain",
                    "icon": "10n",
                    "icon_url": "http://openweathermap.org/img/w/10n",
                    "id": 500,
                    "main": "Rain"
                }
            ]
        },
        {
            "_entity_type": "WeatherStatus",
            "_id": "WeatherStatus_Geoname_5391959-1519214400",
            "city": {
                "_entity_type": "City",
                "_id": "Geoname_5391959",
                "admin1_code": "CA",
                "admin2_code": "075",
                "admin3_code": null,
                "admin4_code": null,
                "alternative_names": [
                    "Franciscopolis",
                    "Frisco",
                    "Gorad San-Francyska",
                    "Kapalakiko",
                    "Khiu-kim-san",
                    "Khiu-kîm-sân",
                    "Lungsod ng San Francisco",
                    "New Albion",
                    "SF",
                    "SFO",
                    "San Francisco",
                    "San Franciscu",
                    "San Francisko",
                    "San Fransisco",
                    "San Fransiskas",
                    "San Fransisko",
                    "San Frantzisko",
                    "San Phransisko",
                    "San-Francisko",
                    "San-Fransisko",
                    "Sanfrancisko",
                    "Sao Francisco",
                    "São Francisco",
                    "Yerba Buena",
                    "can pirancisko",
                    "jiu jin shan",
                    "saenpeulan",
                    "saenpeulansiseuko",
                    "saina pharansisako",
                    "saina phransisko",
                    "san f ran si s ko",
                    "san fan shi",
                    "san fransskw",
                    "san fransyskw",
                    "san fransyskۆ",
                    "san phransisko",
                    "sana phransisako ka'unti",
                    "sana phransisko",
                    "sanfuranshisuko",
                    "sena phransisko",
                    "sn prnsysqw",
                    "syana phransisko",
                    "Σαν Φρανσίσκο",
                    "Горад Сан-Францыска",
                    "Сан Франсиско",
                    "Сан Франциско",
                    "Сан-Франциско",
                    "Сан-Франціско",
                    "Սան Ֆրանցիսկո",
                    "סאן פראנציסקא",
                    "סן פרנסיסקו",
                    "سان فرانسسکو",
                    "سان فرانسيسكو",
                    "سان فرانسیسکو",
                    "سان فرانسیسکۆ",
                    "सॅन फ्रान्सिस्को",
                    "सैन फ्रांसिस्को",
                    "स्यान फ्रान्सिस्को",
                    "সান ফ্রান্সিসকো কাউন্টি",
                    "সান ফ্রান্সিস্কো",
                    "ਸੈਨ ਫਰਾਂਸਿਸਕੋ",
                    "சான் பிரான்சிஸ்கோ",
                    "శాన్ ఫ్రాన్సిస్కో",
                    "സാൻ ഫ്രാൻസിസ്കോ",
                    "සැන් ෆ්‍රැන්සිස්කෝ",
                    "ซานฟรานซิสโก",
                    "སན་ཧྥུ་རན་སིས་ཁོ",
                    "ဆန်ဖရန်စစ္စကိုမြို့",
                    "სან-ფრანცისკო",
                    "サンフランシスコ",
                    "三藩市",
                    "旧金山",
                    "舊金山",
                    "샌프란",
                    "샌프란시스코"
                ],
                "ascii_name": "San Francisco",
                "coordinates": "37.77493,-122.41942",
                "country": {
                    "country_code_2": "US",
                    "country_code_3": "USA",
                    "country_numeric_code": "840",
                    "name": "United States",
                    "official_name": "United States of America"
                },
                "dem": "28",
                "elevation": 16,
                "feature_class": "P",
                "feature_code": "PPLA2",
                "geonameid": "5391959",
                "id": "Geoname_5391959",
                "modification_date": "2017-06-15",
                "name": "San Francisco",
                "population": 864816,
                "subdivision": {
                    "country_code_2": "US",
                    "name": "California",
                    "subdivision_code": "US-CA",
                    "type": "State"
                },
                "timezone": "America/Los_Angeles"
            },
            "features": {
                "clouds_percent": 88,
                "humidity_percent": 100,
                "pressure": {
                    "hPa": 1026.41,
                    "inHg": 30.31,
                    "mmHg": 769.87
                },
                "rain": {
                    "inch_hour": 0,
                    "mm_hour": 0.06
                },
                "snow": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "temperature": {
                    "celsius": 5.14,
                    "fahrenheit": 32
                },
                "wind_direction_degrees": 46.5015,
                "wind_speed": {
                    "meters_per_second": 0.27,
                    "miles_per_hour": 0.6
                }
            },
            "is_current": false,
            "measure_time": {
                "countdown": 73230,
                "datetime": "2018-02-21T12:00:00+0000",
                "timestamp": 1519214400
            },
            "start_datetime": {
                "countdown": 73230,
                "datetime": "2018-02-21T12:00:00+0000",
                "timestamp": 1519214400
            },
            "weather_conditions": [
                {
                    "description": "light rain",
                    "icon": "10n",
                    "icon_url": "http://openweathermap.org/img/w/10n",
                    "id": 500,
                    "main": "Rain"
                }
            ]
        },
        {
            "_entity_type": "WeatherStatus",
            "_id": "WeatherStatus_Geoname_5391959-1519218000",
            "city": {
                "_entity_type": "City",
                "_id": "Geoname_5391959",
                "admin1_code": "CA",
                "admin2_code": "075",
                "admin3_code": null,
                "admin4_code": null,
                "alternative_names": [
                    "Franciscopolis",
                    "Frisco",
                    "Gorad San-Francyska",
                    "Kapalakiko",
                    "Khiu-kim-san",
                    "Khiu-kîm-sân",
                    "Lungsod ng San Francisco",
                    "New Albion",
                    "SF",
                    "SFO",
                    "San Francisco",
                    "San Franciscu",
                    "San Francisko",
                    "San Fransisco",
                    "San Fransiskas",
                    "San Fransisko",
                    "San Frantzisko",
                    "San Phransisko",
                    "San-Francisko",
                    "San-Fransisko",
                    "Sanfrancisko",
                    "Sao Francisco",
                    "São Francisco",
                    "Yerba Buena",
                    "can pirancisko",
                    "jiu jin shan",
                    "saenpeulan",
                    "saenpeulansiseuko",
                    "saina pharansisako",
                    "saina phransisko",
                    "san f ran si s ko",
                    "san fan shi",
                    "san fransskw",
                    "san fransyskw",
                    "san fransyskۆ",
                    "san phransisko",
                    "sana phransisako ka'unti",
                    "sana phransisko",
                    "sanfuranshisuko",
                    "sena phransisko",
                    "sn prnsysqw",
                    "syana phransisko",
                    "Σαν Φρανσίσκο",
                    "Горад Сан-Францыска",
                    "Сан Франсиско",
                    "Сан Франциско",
                    "Сан-Франциско",
                    "Сан-Франціско",
                    "Սան Ֆրանցիսկո",
                    "סאן פראנציסקא",
                    "סן פרנסיסקו",
                    "سان فرانسسکو",
                    "سان فرانسيسكو",
                    "سان فرانسیسکو",
                    "سان فرانسیسکۆ",
                    "सॅन फ्रान्सिस्को",
                    "सैन फ्रांसिस्को",
                    "स्यान फ्रान्सिस्को",
                    "সান ফ্রান্সিসকো কাউন্টি",
                    "সান ফ্রান্সিস্কো",
                    "ਸੈਨ ਫਰਾਂਸਿਸਕੋ",
                    "சான் பிரான்சிஸ்கோ",
                    "శాన్ ఫ్రాన్సిస్కో",
                    "സാൻ ഫ്രാൻസിസ്കോ",
                    "සැන් ෆ්‍රැන්සිස්කෝ",
                    "ซานฟรานซิสโก",
                    "སན་ཧྥུ་རན་སིས་ཁོ",
                    "ဆန်ဖရန်စစ္စကိုမြို့",
                    "სან-ფრანცისკო",
                    "サンフランシスコ",
                    "三藩市",
                    "旧金山",
                    "舊金山",
                    "샌프란",
                    "샌프란시스코"
                ],
                "ascii_name": "San Francisco",
                "coordinates": "37.77493,-122.41942",
                "country": {
                    "country_code_2": "US",
                    "country_code_3": "USA",
                    "country_numeric_code": "840",
                    "name": "United States",
                    "official_name": "United States of America"
                },
                "dem": "28",
                "elevation": 16,
                "feature_class": "P",
                "feature_code": "PPLA2",
                "geonameid": "5391959",
                "id": "Geoname_5391959",
                "modification_date": "2017-06-15",
                "name": "San Francisco",
                "population": 864816,
                "subdivision": {
                    "country_code_2": "US",
                    "name": "California",
                    "subdivision_code": "US-CA",
                    "type": "State"
                },
                "timezone": "America/Los_Angeles"
            },
            "features": {
                "clouds_percent": 88,
                "humidity_percent": 100,
                "pressure": {
                    "hPa": 1026.41,
                    "inHg": 30.31,
                    "mmHg": 769.87
                },
                "rain": {
                    "inch_hour": 0,
                    "mm_hour": 0.06
                },
                "snow": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "temperature": {
                    "celsius": 5.14,
                    "fahrenheit": 32
                },
                "wind_direction_degrees": 46.5015,
                "wind_speed": {
                    "meters_per_second": 0.27,
                    "miles_per_hour": 0.6
                }
            },
            "is_current": false,
            "measure_time": {
                "countdown": 73230,
                "datetime": "2018-02-21T12:00:00+0000",
                "timestamp": 1519214400
            },
            "start_datetime": {
                "countdown": 76830,
                "datetime": "2018-02-21T13:00:00+0000",
                "timestamp": 1519218000
            },
            "weather_conditions": [
                {
                    "description": "light rain",
                    "icon": "10n",
                    "icon_url": "http://openweathermap.org/img/w/10n",
                    "id": 500,
                    "main": "Rain"
                }
            ]
        },
        {
            "_entity_type": "WeatherStatus",
            "_id": "WeatherStatus_Geoname_5391959-1519221600",
            "city": {
                "_entity_type": "City",
                "_id": "Geoname_5391959",
                "admin1_code": "CA",
                "admin2_code": "075",
                "admin3_code": null,
                "admin4_code": null,
                "alternative_names": [
                    "Franciscopolis",
                    "Frisco",
                    "Gorad San-Francyska",
                    "Kapalakiko",
                    "Khiu-kim-san",
                    "Khiu-kîm-sân",
                    "Lungsod ng San Francisco",
                    "New Albion",
                    "SF",
                    "SFO",
                    "San Francisco",
                    "San Franciscu",
                    "San Francisko",
                    "San Fransisco",
                    "San Fransiskas",
                    "San Fransisko",
                    "San Frantzisko",
                    "San Phransisko",
                    "San-Francisko",
                    "San-Fransisko",
                    "Sanfrancisko",
                    "Sao Francisco",
                    "São Francisco",
                    "Yerba Buena",
                    "can pirancisko",
                    "jiu jin shan",
                    "saenpeulan",
                    "saenpeulansiseuko",
                    "saina pharansisako",
                    "saina phransisko",
                    "san f ran si s ko",
                    "san fan shi",
                    "san fransskw",
                    "san fransyskw",
                    "san fransyskۆ",
                    "san phransisko",
                    "sana phransisako ka'unti",
                    "sana phransisko",
                    "sanfuranshisuko",
                    "sena phransisko",
                    "sn prnsysqw",
                    "syana phransisko",
                    "Σαν Φρανσίσκο",
                    "Горад Сан-Францыска",
                    "Сан Франсиско",
                    "Сан Франциско",
                    "Сан-Франциско",
                    "Сан-Франціско",
                    "Սան Ֆրանցիսկո",
                    "סאן פראנציסקא",
                    "סן פרנסיסקו",
                    "سان فرانسسکو",
                    "سان فرانسيسكو",
                    "سان فرانسیسکو",
                    "سان فرانسیسکۆ",
                    "सॅन फ्रान्सिस्को",
                    "सैन फ्रांसिस्को",
                    "स्यान फ्रान्सिस्को",
                    "সান ফ্রান্সিসকো কাউন্টি",
                    "সান ফ্রান্সিস্কো",
                    "ਸੈਨ ਫਰਾਂਸਿਸਕੋ",
                    "சான் பிரான்சிஸ்கோ",
                    "శాన్ ఫ్రాన్సిస్కో",
                    "സാൻ ഫ്രാൻസിസ്കോ",
                    "සැන් ෆ්‍රැන්සිස්කෝ",
                    "ซานฟรานซิสโก",
                    "སན་ཧྥུ་རན་སིས་ཁོ",
                    "ဆန်ဖရန်စစ္စကိုမြို့",
                    "სან-ფრანცისკო",
                    "サンフランシスコ",
                    "三藩市",
                    "旧金山",
                    "舊金山",
                    "샌프란",
                    "샌프란시스코"
                ],
                "ascii_name": "San Francisco",
                "coordinates": "37.77493,-122.41942",
                "country": {
                    "country_code_2": "US",
                    "country_code_3": "USA",
                    "country_numeric_code": "840",
                    "name": "United States",
                    "official_name": "United States of America"
                },
                "dem": "28",
                "elevation": 16,
                "feature_class": "P",
                "feature_code": "PPLA2",
                "geonameid": "5391959",
                "id": "Geoname_5391959",
                "modification_date": "2017-06-15",
                "name": "San Francisco",
                "population": 864816,
                "subdivision": {
                    "country_code_2": "US",
                    "name": "California",
                    "subdivision_code": "US-CA",
                    "type": "State"
                },
                "timezone": "America/Los_Angeles"
            },
            "features": {
                "clouds_percent": 56,
                "humidity_percent": 100,
                "pressure": {
                    "hPa": 1027.28,
                    "inHg": 30.34,
                    "mmHg": 770.52
                },
                "rain": {
                    "inch_hour": 0,
                    "mm_hour": 0.06
                },
                "snow": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "temperature": {
                    "celsius": 5.04,
                    "fahrenheit": 32
                },
                "wind_direction_degrees": 73.5038,
                "wind_speed": {
                    "meters_per_second": 1.87,
                    "miles_per_hour": 4.18
                }
            },
            "is_current": false,
            "measure_time": {
                "countdown": 84030,
                "datetime": "2018-02-21T15:00:00+0000",
                "timestamp": 1519225200
            },
            "start_datetime": {
                "countdown": 80430,
                "datetime": "2018-02-21T14:00:00+0000",
                "timestamp": 1519221600
            },
            "weather_conditions": [
                {
                    "description": "light rain",
                    "icon": "10d",
                    "icon_url": "http://openweathermap.org/img/w/10d",
                    "id": 500,
                    "main": "Rain"
                }
            ]
        },
        {
            "_entity_type": "WeatherStatus",
            "_id": "WeatherStatus_Geoname_5391959-1519225200",
            "city": {
                "_entity_type": "City",
                "_id": "Geoname_5391959",
                "admin1_code": "CA",
                "admin2_code": "075",
                "admin3_code": null,
                "admin4_code": null,
                "alternative_names": [
                    "Franciscopolis",
                    "Frisco",
                    "Gorad San-Francyska",
                    "Kapalakiko",
                    "Khiu-kim-san",
                    "Khiu-kîm-sân",
                    "Lungsod ng San Francisco",
                    "New Albion",
                    "SF",
                    "SFO",
                    "San Francisco",
                    "San Franciscu",
                    "San Francisko",
                    "San Fransisco",
                    "San Fransiskas",
                    "San Fransisko",
                    "San Frantzisko",
                    "San Phransisko",
                    "San-Francisko",
                    "San-Fransisko",
                    "Sanfrancisko",
                    "Sao Francisco",
                    "São Francisco",
                    "Yerba Buena",
                    "can pirancisko",
                    "jiu jin shan",
                    "saenpeulan",
                    "saenpeulansiseuko",
                    "saina pharansisako",
                    "saina phransisko",
                    "san f ran si s ko",
                    "san fan shi",
                    "san fransskw",
                    "san fransyskw",
                    "san fransyskۆ",
                    "san phransisko",
                    "sana phransisako ka'unti",
                    "sana phransisko",
                    "sanfuranshisuko",
                    "sena phransisko",
                    "sn prnsysqw",
                    "syana phransisko",
                    "Σαν Φρανσίσκο",
                    "Горад Сан-Францыска",
                    "Сан Франсиско",
                    "Сан Франциско",
                    "Сан-Франциско",
                    "Сан-Франціско",
                    "Սան Ֆրանցիսկո",
                    "סאן פראנציסקא",
                    "סן פרנסיסקו",
                    "سان فرانسسکو",
                    "سان فرانسيسكو",
                    "سان فرانسیسکو",
                    "سان فرانسیسکۆ",
                    "सॅन फ्रान्सिस्को",
                    "सैन फ्रांसिस्को",
                    "स्यान फ्रान्सिस्को",
                    "সান ফ্রান্সিসকো কাউন্টি",
                    "সান ফ্রান্সিস্কো",
                    "ਸੈਨ ਫਰਾਂਸਿਸਕੋ",
                    "சான் பிரான்சிஸ்கோ",
                    "శాన్ ఫ్రాన్సిస్కో",
                    "സാൻ ഫ്രാൻസിസ്കോ",
                    "සැන් ෆ්‍රැන්සිස්කෝ",
                    "ซานฟรานซิสโก",
                    "སན་ཧྥུ་རན་སིས་ཁོ",
                    "ဆန်ဖရန်စစ္စကိုမြို့",
                    "სან-ფრანცისკო",
                    "サンフランシスコ",
                    "三藩市",
                    "旧金山",
                    "舊金山",
                    "샌프란",
                    "샌프란시스코"
                ],
                "ascii_name": "San Francisco",
                "coordinates": "37.77493,-122.41942",
                "country": {
                    "country_code_2": "US",
                    "country_code_3": "USA",
                    "country_numeric_code": "840",
                    "name": "United States",
                    "official_name": "United States of America"
                },
                "dem": "28",
                "elevation": 16,
                "feature_class": "P",
                "feature_code": "PPLA2",
                "geonameid": "5391959",
                "id": "Geoname_5391959",
                "modification_date": "2017-06-15",
                "name": "San Francisco",
                "population": 864816,
                "subdivision": {
                    "country_code_2": "US",
                    "name": "California",
                    "subdivision_code": "US-CA",
                    "type": "State"
                },
                "timezone": "America/Los_Angeles"
            },
            "features": {
                "clouds_percent": 56,
                "humidity_percent": 100,
                "pressure": {
                    "hPa": 1027.28,
                    "inHg": 30.34,
                    "mmHg": 770.52
                },
                "rain": {
                    "inch_hour": 0,
                    "mm_hour": 0.06
                },
                "snow": {
                    "inch_hour": 0,
                    "mm_hour": 0
                },
                "temperature": {
                    "celsius": 5.04,
                    "fahrenheit": 32
                },
                "wind_direction_degrees": 73.5038,
                "wind_speed": {
                    "meters_per_second": 1.87,
                    "miles_per_hour": 4.18
                }
            },
            "is_current": false,
            "measure_time": {
                "countdown": 84030,
                "datetime": "2018-02-21T15:00:00+0000",
                "timestamp": 1519225200
            },
            "start_datetime": {
                "countdown": 84030,
                "datetime": "2018-02-21T15:00:00+0000",
                "timestamp": 1519225200
            },
            "weather_conditions": [
                {
                    "description": "light rain",
                    "icon": "10d",
                    "icon_url": "http://openweathermap.org/img/w/10d",
                    "id": 500,
                    "main": "Rain"
                }
            ]
        }
    ]
}

The above query returns 9 light drops of rain in San Francisco in the next 24 hours. You can customize the exact type of rain you need using the WeatherStatus object in the WHERE clause.

Step 3: Create subscription

To create a subscription you just need to send an HQL query and a title of your choice to the subscriptions endpoint:

curl -H "Content-type: application/json" -d '{
	"query": "SELECT * FROM WeatherByCity
(geonameid = \'5391959\')
WHERE weather_conditions.main = \'Rain\' and
start_datetime.countdown <= 86400" }' 'http://api.hooksdata.io/v1/subscriptions'

Hooks will then create a subscription on our servers and call your webhook once new data is available for your query.

Examples

Using HQL you can customize what data you want to select from a datasource and also filter the output using a WHERE clause. The following examples show how you can use HQL to choose just the data you need:

Get an update 24 hours before a heavy rain in San Francisco:

SELECT * FROM WeatherByCity
(geonameid = '5391959') 
WHERE weather_conditions.main = 'Rain' 
AND weather_conditions.description = 'heavy rain'
AND start_datetime.countdown <= 86400

Get update 24 hours before it snows in San Francisco:

SELECT * FROM WeatherByCity
(geonameid = '5391959') 
WHERE weather_conditions.main = 'Rain'
AND weather_conditions.description = 'heavy rain'
AND start_datetime.countdown <= 86400