Number of hospitals in the dataset

[theonesp]

The number of hospitals in the 'hospital' table is 459, nevertheless, there is no way to join the hospitals from this table with actual patients since this table only has 4 columns: hospitalid, numbedscategory, teachingstatus, region.

If we look in the 'patient' table and then the field hospitalid, it goes up to 364 unique hospitals.

[jraffa]

Yes, some hospitals are not available in the public subset for a variety of reasons.

There should be no problem with joining the hospitalid in this table to the patient table. But perhaps I am misunderstanding something.

[alistairewj]

I think it's more there is no point in having these hospitals in the table since they don't exist in the data.

[theonesp]

I agree, it's confusing having different number of total hospitals depending on the table you are looking at, specially if some of them don't exist in the rest of the data. Miguel

…

------------------------------ [image: MIT][image: imes] *Miguel Ángel Armengol de la Hoz **✉* <[email protected]> / Senior Research Associate *MIT - Institute for Medical Engineering and Science * *Laboratory for Computational Physiology* MIT, E25-235- 53 Carleton St. Cambridge, MA 02139 [image: LinkedIn logo] <https://www.linkedin.com/in/miguelangelarmengol/?locale=en_US>

On Wed, Nov 22, 2017 at 5:19 PM, Alistair Johnson ***@***.***> wrote: I think it's more there is no point in having these hospitals in the table since they don't exist in the data. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#40 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AH-Y_ncbmvbMU_SD9zP2uvSARsNfl-LTks5s5J33gaJpZM4QmoN8> .