search

opentrials / cochrane-schizophrenia-data

Cleaned data from the Cochrane schizophrenia database
5 stars 3 forks source link

Participant entity/field #10

Closed roll closed 9 years ago

roll commented 9 years ago

Background As a part of the #2 issue we have to discuss with @danfowler and the team some parts of the ideal data model. It's a subtask named "Analyze the data we have, in comparison to the ideal model".

Topic

Participant - a man involved in a trial as a part of a research

As mentioned in okfn/opentrials-prototype#7 we want to have number of participants, age range and sex. The Cochrane database handles it as having Participant entity with types of participants and m2m relation with Trial entity:

It doesn't look as the best way to organize this data (where is a number of participants?).

Thoughts

See also - https://github.com/okfn/opentrials-cochrane-schizophrenia-data/wiki

pwalsh commented 9 years ago

Are these Participants then further related to the participant descriptions (which i believe are in there somewhere)? Are you saying that by summing on the m2m relation you can get a count?

roll commented 9 years ago

I'll provide some ideas a little bit later on it.

It looks like the Cochrane database doesn't have a participant count or I can't find it. I see only data like this - Trial XXX use males and females (thru m2m table).

@danfowler would you like to take a look on it?

danfowler commented 9 years ago

@roll @pwalsh tblStudy.UDef1 contains the number of randomized participants in a trial. It doesn't look like you can sum the participant descriptions to get a count per study; you will just get a count of types of participants.

roll commented 9 years ago

Great! Thanks.

roll commented 9 years ago

@pwalsh

Are you OK (from the app side) if we start from this fields about participants:

https://github.com/okfn/opentrials-cochrane-schizophrenia-data/blob/master/archive/clean/sql/schema.sql#L26-L31

It looks like Cochrane database hasn't any other usefull data and current version of the schema syncs with your okfn/opentrials-prototype#7 pictures

pwalsh commented 9 years ago

yes, looks good to me.