Use long-term trend sheet

[anuveyatsu]

If you take a look at the chart on website (https://data.london.gov.uk/), you'd notice that it is using "Long-term trend" sheet. We can convert date in the following way:

Sep-Nov 2018 => Nov 2018 => 2018-11-01

so that the data would look like this:

date,region,unemployed,unemployment rate
2018-11-01,London,227000,4.5
2018-11-01,UK,1372000,4.0
...

Also, can we scrape UK data as well?