WebScraping Data

[Brawnystaff]

I am trying to download data from a website that gives a hospital name and, when you click on the hospital name, the hospital address, into an Excel sheet. There are 350 hospital names/addresses, and I have tried using Power Query but had had no luck. Any idea on how I can accomplish this?

The website address is as follows:

http://gis.oshpd.ca.gov/atlas/topics/er_dashboard

[MarvinP]

Hi Brawnystaff,

If you ViewSource of the web page you linked above the address isn't in the HTML. That means they are pulling it from a database and only showing a pointer to the address. This is common practice with newer web tools.

I suggest you look at another page where the address might be actually put in the HTML like
http://gis.oshpd.ca.gov/atlas/places/facility/306196888