search

MIT-LCP / eicu-website

Repository moved
https://github.com/MIT-LCP/eicu-code
MIT License
3 stars 3 forks source link

Number of hospitals in the dataset #40

Open theonesp opened 6 years ago

theonesp commented 6 years ago

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 commented 6 years ago

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 commented 6 years ago

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 commented 6 years ago

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 *✉ maarmeng@mit.edu / 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 notifications@github.com 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 https://github.com/MIT-LCP/eicu-website/issues/40#issuecomment-346488343, or mute the thread https://github.com/notifications/unsubscribe-auth/AH-Y_ncbmvbMU_SD9zP2uvSARsNfl-LTks5s5J33gaJpZM4QmoN8 .