List of hospitals/trusts with wifi, especially free for patients & visitors

[Malcolm Teague (at Janet)]

Further to the wifi survey led by Marcus last May, John Popham's campaign for free wireless at Trusts for patients has created a self-reporting page to show whether Trusts have wireless or not. Campaign on facebook at https://www.facebook.com/groups/hospitalwifi/ , the list is at https://docs.google.com/document/d/1s6KWeZQ8moUUTKk3E8rSmPV2E5EYoCc9uvcrSGJyUzc/edit?pli=1 . It would be great if there could be more contributions to make it even more useful (plus checking some contributions already as I'm not sure they are all right). It would be better on NHS Choices perhaps but this could be a really helpful community resource.

[John Pyle]

I have added a hospital and set the first row of the table as a page header, which makes the front page ugly but helps on subsequent pages . Please feel free to undo. Not sure how you will keep the running totals at the bottom up to date - is it the job of each contributor?

[Malcolm Teague (at Janet)]

On Thursday, March 6, 2014 1:48:55 PM UTC, John Pyle wrote:

I have added a hospital and set the first row of the table as a page header, which makes the front page ugly but helps on subsequent pages . Please feel free to undo. Not sure how you will keep the running totals at the bottom up to date - is it the job of each contributor?

That's great, thanks John. I've just added my local Trust as well. Trying to make contact with John Popham, as it is his table, to join this conversation. Looks like the totals should be removed for now in the hope that more data will be entered and then they can be adjusted.  

[Helga J Perry]

Nice to see my Trust is already on there

Sent from my iPad Mini

--
You received this message because you are subscribed to the Google Groups "nhshackday" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nhshackday+...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[Malcolm Teague (at Janet)]

That's good. 4 hospitals have been added since yesterday, could do with more if possible.

[Marcus Baw]

I’ve added the trust I was at on Thursday which had open WiFi for staff and patients.

Does anyone else think that this way of collecting data is a bit, well, wobbly? (Table within a “word” type document)

Even a spreadsheet would be better than a table on a document.

(I was actually planning a 2014 follow up to last year’s WiFi survey and was going to collect patient wifi info, trust data and postcode data in order to Name & Shame and also Map the Wifi - I would do this with LimeSurvey and that outputs almost anything - much better for subsequent data analysis)

M

For more options, visit https://groups.google.com/d/optout.

[John Pyle]

I was thinking of a SharePoint site...

Regards
John Pyle
07920236120

You received this message because you are subscribed to a topic in the Google Groups "nhshackday" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/nhshackday/fWPTzLwCCYQ/unsubscribe.
To unsubscribe from this group and all its topics, send an email to nhshackday+...@googlegroups.com.

[Malcolm Teague (at Janet)]

Hi, have to agree that the it is a bit vulnerable. Anyone could log on and delete or mess up all the information. I'm taking copies occasionally and possibly John is too.

 

There needs to be an easy process for adding information but somehow keep what is already there secure. Also alphabetical order would be quite helpful now. And it would not be too difficult to have all the NHS Trusts and Health Boards listed whether they have an entry or not so the gaps are easier to see.  Not sure of the best approach though.

 

I've drafted a brief note, as attached, on the current position with wireless in the NHS as a potential contribution to Health Education England's Technology Enhanced Learning project, it draws on the survey and Marcus has kindly provided me with the data for further analysis. Any thoughts and contributions gratefully received. A follow up survey sounds good but I do think John's idea of a central list of the status of NHS hospitals/organisations providing free wifi is very useful indeed.

 

Best wishes, Malcolm  

[Marcus Baw]

This could be done in LimeSurvey very easily, it would allow us to develop a comprehensive database of true patient and staff experiences of WiFi at trusts. I can help with this but I can’t do it right away, perhaps during the coming week though.

Doing it in Limesurvey significantly simplifies the data entry, removes the vulnerability to vandalism, and does a lot of the stats and I/O stuff nicely OOTB. Can export to CVS, SQL, R, SPSS etc

I have a CSV list of all acute trusts (attached), but wonder if anyone else has a better/more up to date list and/or one that details hospitals rather than trusts (as many trusts have more than one hospital)

M

[VJ]

Here you go.
It's about a year old but lists sites rather than Trusts.

Just matched it to the GoogleDoc so let me know if you want more fields in
the query e.g. NACS, Postcode etc.

VJ

[Marcus Baw]

Thanks VJ

[VJ]

I just noticed that some of the columns were empty for town/city - see amended distinct list.

(I was using coalesce but the fields were empty, not null)

[Chris Casey]

I am thinking of setting up an interactive web site holding this and other information about UK hospitals.

I am just thinking through the security mechanisms to enable people to add to it easily without leaving it open to abuse.

[Chris Casey]

Ok, guys, I have started work on this and hope to have something (though might be a bit rough and ready at first) to show this week

[Malcolm Teague (at Janet)]

Sounds good to me, looking forward to seeing the first draft. Also can then possibly consider whether Marcus' suggestion of a new survey/database fits in.

[VJ]

Hi Chris,

 

What “other” information were you thinking about?

 

Best,
VJ

[Chris Casey]

Basically anything that people wanted or would find useful to know about a hospital (parking charges comes to mind!)

[Malcolm Teague (at Janet)]

VJ, really useful list. Any chance you could add the postcode of the hospital address, as Marcus' survey captured that for a significant number of responses. Many thanks, Malcolm

[Omer Moghraby]

Hi guys 

great list this - just added my own set of hospitals before seeing the developments subsequently :S hopefully it can still be added on to this new webstie/ list. 

anyway was just thinking that in the first column about the wifi for staff or patients .....some are not accesible by staff unless they have a trust device and even then ....unlike in uni where if you are an affiliated member you can log onto wifi. is it worth putting that in??? 

"wifi for trust devices"

"wifi for staff passwork protected"

wifi for patients/visitors 

UCLH cio at a talk i went to recently was going to great lengths to explain how they would accept non-trust devices on their secure network but woudl require log in and if staff could give more access....

omer

                         

Dr Omer Moghraby
Consultant Child & Adolescent Psychiatrist (in Lewisham)
South London & the Maudsley NHS Foundation trust (SLaM)

www.myhealthlocker.nhs.uk  follow @myhealthlocker 

Finance Officer, Informatics Committee, RCPsych
http://www.rcpsych.ac.uk/college/specialinterestgroups/mentalhealthinformatics.aspx

Chairman, WNMCP
www.wnmcp.org.uk   follow @wnmcp

(+44) 7968775698
@moghraby

[Chris Casey]

I will be allowing search by postcode, trust, hospital, town/city so will be capturing that data from various spreadsheets that I have been pointed to 

[Malcolm Teague (at Janet)]

5 in one go is a great result! I think it is still useful to fill in the existing table as the results can be added later to the website. Direct feedback is invaluable.

[VJ]

Morning Omer,

 

At home, I run a guest SSID, in addition to my trusted network which is locked down by MAC.

Would something as simple as this work?

 

(Good to see you on the mailing group)

 

Best,

VJ

[VJ]

Aren’t you describing the NHS Choices’ database?

Are we better off to just get an API key from them?

 

(This is not to say I can’t give you postcode etc.)

 

Just a thought: perhaps we should speak to them about adding Wi-Fi availability (etc.) into their fields?

 

Best,

VJ

[Marcus Baw]

I’d be happy for NHS Choices to have the data produced by my survey and others.

BUT they are not going to be the only place my data is available. I don’t trust their independence (because they’re not) and they are too amenable to swaying by political imperatives at any and every level (NHSEng, HSCIC, SoS, PM) into changing or hiding unpalatable data.

I also object to spending my time doing free work on something that, if it were commissioned work by NHS England would easily swallow £100K in its first 6 months, and would take a year to output anything. We are able, through our independence and agile working practices, to do it for almost nothing - but it still sticks in my throat to hand it all over to NHS Choices.

M

[VJ]

Unfortunately very true.

 

See attached for my previous file, now with postcodes.

 

VJ

[Omer Moghraby]

Thanks VJ 

yes I guess that would work ...except some of the trusts make great play on either a free for all on what you can do and others saying its just for checking email and browsing. 

btw Agree with NHS Choices bit - they are very open about adding things in and appear to be collaborative as individuals ...but the monster will take over eventually! 

bw

omer

[Chris Casey]

Quick update.

Hoping to have a very rough enquiry-only version of the site up tomorrow or Thursday.

I will then look for comments as I take it forward from there.

It will probably be blown away and redone at least once.

I will warn you in advance I am more on the functional side than the artistic!

Chris

[Marcus Baw]

Great Chris. I'll take a look in a couple of days. Feel free to contact me off list in the interim. marc...@gmail.com

M

--

[Neville Dastur]

Hi Chris

Is the source up on GitHub etc?  Others could help.

Thanks

Neville

--

Surgeons Net Education: http://www.surgeons.org.uk

Clinical Software Solutions: http://www.clinsoftsolutions.com

Find our free and paid apps on the iTunes Apple store and Android Google Play store

LinkedIn: http://www.linkedin.com/profile/view?id=49617062

[Chris Casey]

 

Ok, here we go.

THIS IS VERY MUCH A FIRST DRAFT!!!!!!

Constructive comments only please.

aboutmyhospital.co.uk

I have tested this site on Chrome on a PC and also on an iPad and it looks ok so far but testing has not been extensive.

A few caveats...

1. I changed the DNS about 4 hours ago. If you see an SSL error it means you are seeing the old one. Just remove the s from the https and refresh.
2. The list of hospitals is off the official NHS site. There seems to be quite a bit of duplication but I haven't had chance to weed them out.
   
3. There are some 23000 entries in the database.
4. There may also be a few dead ones. I haven't processed the indicators from the file yet.
5. It would appear that the NHS files do not include Scotland????!!!! Anyone Know where I can get a csv file in the same format for Scotland?
6. I have used the updating facilities have built to manually enter the wifi data from the original document. I could not find all the entries (In particular the Scottish ones).
7. I have built wifi update facilities but am not enabling the logon/update features yet as I have not yet decided on the best mechanism for controlling this.
8. This is running on a T1 micro so if everyone jumps on it might slow down a bit

Let me know what you think

Chris

[Marcus Baw]

Looks fine in Firefox on OSX

I’ll put the feelers out about Scottish Trust info. I know some people who may help.

Nice work. What are you coding it in? And is the code on GitHub? I may be able to help (if it’s Rails)

M

On 12 Mar 2014, at 20:53, Chris Casey <boroc...@gmail.com> wrote:

aboutmyhospital.co.uk

[Chris Casey]

Thanks Marcus,

the code isn't on github as yet, it really is just too rough and ready at the moment.

I am using only javascript with a bootstrap front end, Node.js and GT.m at the back end with EWD.js doing everything in between.

Chris

[Neville Dastur]

Chris

I wouldn’t worry about rough and ready code. I have plenty of nodes experience and could help.

Neville

[Gavin Jamie]

Best place to get details is at http://systems.hscic.gov.uk/data/ods/datadownloads where everything is published as nice digestible CSV files. Also includes a lot of other information including trusts with several sites.

[Chris Casey]

Thanks, will have a go at loading the Scottish data now (after doing a backup)

[Chris Casey]

Scottish data now loaded.

There is quite a bit of rubbish in there unfortunately, and of course the file was in a different format (groan).

I will try and do some cleaning up tomorrow.

I think I am about at the point where it is dangerous for me to be playing much more tonight though.

Chris

[Marcus Baw]

OK.

as an unrelated aside, the stack you are using (GT.M, EWD) is similar to that used for some versions of the VistA EHR project by the veterans association in USA. Have you seen VistA? There is an NHS VistA project ongoing (Google nhsvista)

M

[Chris Casey]

Yes,

my paid work is mainly based around VistA.

Actively supporting NHS VistA, which is more than can be said for the NHS.

Chris

[Chris Casey]

The stack is actually the exact same one that will be used to advance the VA systems and is being used for many exciting VistA projects right now.

I don't know if you have seen it but I was the one who developed the NHS VistA demonstrator using this same technology.

I will be putting a public version of that up on my demonstrator site soon.

Chris

On Thursday, 13 March 2014 07:37:33 UTC, Marcus Baw wrote:

[Chris Casey]

First cut code now up on github github.com/borochris/aboutMyHospital

[Chris Casey]

Unfortunately events have got on top of me so not been able to progress things as quickly as I would have liked.

In order to keeps things moving until I can set up a proper request mechanism if people would like the ability to add wifi details to the hospitals in the database then email me from this message with your requested username and I will set you up with passwords to do that.

I am struggling a bit in trying to ignore non-hospitals from the lookups as the data I got from the NHS site to load the database does not have any identifiers that I can use to ignore (e.g. clinics individually identified in the data but belonging to a hospital also identified) them. I am thinking through ways to do this systematically.

[VJ]

How about just using the dataset that I sent the group?

Clinics and the like are already excluded.

--

[Chris Casey]

VJ,

unfortunately your dataset is quite limited for my long term purposes.
I am intending to expand this site for many other things and as such I need to use a dataset with as much data as possible and one maintained by the NHS so that I can refresh it on a regular basis.

I currently have about 24,000 sites detailed in the database.

Chris

[VJ]

Just let me know what fields you need and I’ll add them into my query.

If I don’t have them then it’s time to reinvent the wheel.

 

As previously discussed, I only kept it limited to mimic the original Google Doc.

[Chris Casey]

Ah ok, sorry didn't re-read the original posting well enough.

The database is now populated from the NHS CSV file with all of it's fields so without rebuilding I am stuck with that.

If you have identified a way to determine actual hospitals from that data then I could possibly apply that.

[VJ]

Try an inner join on a select distinct NACS from HES_extract

VJ,

I am struggling a bit in tryin g to ignore non-hospitals from the lookups as the data I got from the NHS site to load the database does not have any identifiers that I can use to ignore (e.g. clinics individually identified in the data but belonging to a hospital also identified) them. I am thinking through ways to do this systematically.

On Thursday, 13 March 2014 09:59:19 UTC, Chris Casey wrote:

First cut code now up on github github.com/borochris/aboutMyHospital

--
You received this message because you are subscribed to the Google Groups "nhshackday" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nhshackday+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "nhshackday" group.

To unsubsc ribe from this group and stop receiving emails from it, send an email to nhshackday+...@googlegroups.com.

[Chris Casey]

A few minor improvements...

1. Removed most clinics and other odd bits that are at the same site as a hospital so lookups should be cleaner 
   
2. Postcode lookup now allows you to select based on just the first part of a postcode rather than the whole thing (e.g. SG1 will show all hospitals within that postcode section)

[Chris Casey]

Also now tidied up details panel and added tab containing Hospital details

[Chris Casey]

Ok, last changes for today.
I have added some stats and the main change is that I have now allowed wifi details to be added without a login.

This means that anyone can now add wifi details for any hospital.

Chris

[Chris Casey]

Just to clarify last night's posting.

You can now add/amend wifi details by choosing and clicking on a hospital and then entering the details.

The form requires that you enter a username but this can be one of your choosing and does not requires you to have registered or logged in with it first.

Chris

[Chris Casey]

I am still trying to get into that facebook group to tell them about the new web page/database but it seems to be taking ages.

If you are able to to can you please mention the new system on there.

Chris

On Thursday, 6 March 2014 12:12:25 UTC, Malcolm Teague (at Janet) wrote:

Further to the wifi survey led by Marcus last May, John Popham's campaign for free wireless at Trusts for patients has created a self-reporting page to show whether Trusts have wireless or not. Campaign on facebook at https://www.facebook.com/groups/hospitalwifi/ , the list is at https://docs.google.com/document/d/1s6KWeZQ8moUUTKk3E8rSmPV2E5EYoCc9uvcrSGJyUzc/edit?pli=1 . It would be great if there could be more contributions to make it even more useful (plus checking some contributions already as I'm not sure they are all right). It would be better on NHS Choices perhaps but this could be a really helpful community resource.

[Omer Moghraby]

Sorry Chris - sort of lost the thread a bit ..
Where is the dataset now? Did u post website or are we still to refer to Google doc?

bw
Omer

Dr Omer Moghraby
Consultant C&A Psychiatrist, SLaM

Informatics Committee, RCPsych

Chairman, WNMCP
sent from my mobile device

--

[Rob Tweed]

Chris has created an online application - http://aboutmyhospital.co.uk

[Kenny Kennington]

Chris,

Still can't login to change anything, just comes up with invalid credentials, and I have to then close the tab to re-open it. Can this be made simpler?

--