Park Run Data - Scotland

[GorD]

I have created a query to pull all the park run data from all the scottish park runs which works ok

it uses 43ish urls in a table (a few tables as website didn't like all together) like below

https://www.parkrun.org.uk/standrews/results/latestresults/


I get all the data coming through fine , but the table of data doesn't contain a date - which is visible on the webpage above the data table.

My concern is that if a particular park run didn't happen one week i would not know and pull the data through as this weeks

So how can i load the data from the above url and include the date

Thanks for any help

 

[sandy666]

You are welcome

but as I said before, I am not sure they will keep the same structure of the page all the time

 

[citizenbh]

This is Excel file with data Connection only!

https://www.dropbox.com/s/mkpcpihjci6ga0a/Park Run Data Scotland_All_Races.xlsx?dl=0