I've gone through the schema for dbSNP 132 quite thoroughly and it looks like it is not possible to find the genotype for individuals for a particular SNP submission.
I am using the dbSNP-q resource to look at the schema and query the database directly so it is possible there are tables missing. I have tried the dbSNP website but the schema diagram on the dbSNP website is 7 years old. I dont have a local installation of dbSNP to examine the schema manually and as far as I know dbSNP don't provide direct access to their database server.
I can find out what individuals are in a population for a SNP submission (i.e. an ss entry). I can find out the allele frequency and genotype frequency for all the populations related to a SNP submission but I cannot find the specific genotypes for specific individuals for a specific subSNP (ss). There are no tables linking indidivuals, ss records and genotypes to give the information in question (the tables AlleleFreqbySSPop and GtyFreyBySSPop give you the allele and genotype frequencies for the populations as a whole). I have a paper that says dbSNP provides the information in question 'per chromosome' with relevant fields chromosomeid, indid, genotypeid and subsnpid. The tables are named SubSNPInd_chr1 etc but I cannot find any tables matching this description if i use the dbSNP-Q website to query the database
Please can you answer this question with respect to the dbSNP schema and not the website.
thanks a lot