Schema for hapmapSnpsCHB
  Database: hg18    Primary Table: hapmapSnpsCHB    Row Count: 3,871,247   Data last updated: 2007-05-22
Format description: HapMap genotype summary
On download server: MariaDB table dump directory
fieldexampleSQL type description
bin 585int(10) unsigned Indexing field to speed chromosome range queries.
chrom chr1varchar(255) Chromosome
chromStart 45161int(10) unsigned Start position in chrom (0 based)
chromEnd 45162int(10) unsigned End position in chrom (1 based)
name rs10399749varchar(255) Reference SNP identifier from dbSnp
score 0int(10) unsigned Minor allele frequency normalized (0-500)
strand +enum('+', '-', '?') Which genomic strand contains the observed alleles
observed C/Tvarchar(255) Observed string from genotype file
allele1 Cenum('A', 'C', 'G', 'T') This allele has been observed
homoCount1 44int(10) unsigned Count of individuals who are homozygous for allele1
allele2  enum('C', 'G', 'T', 'none') This allele may not have been observed
homoCount2 0int(10) unsigned Count of individuals who are homozygous for allele2
heteroCount 0int(10) unsigned Count of individuals who are heterozygous

Connected Tables and Joining Fields
        hg18.hapmapAllelesChimp.name (via hapmapSnpsCHB.name)
      hg18.hapmapAllelesMacaque.name (via hapmapSnpsCHB.name)
      hg18.hapmapLdPhCeu.name (via hapmapSnpsCHB.name)
      hg18.hapmapLdPhChbJpt.name (via hapmapSnpsCHB.name)
      hg18.hapmapLdPhYri.name (via hapmapSnpsCHB.name)
      hg18.hapmapSnpsCEU.name (via hapmapSnpsCHB.name)
      hg18.hapmapSnpsJPT.name (via hapmapSnpsCHB.name)
      hg18.hapmapSnpsYRI.name (via hapmapSnpsCHB.name)

Sample Rows
 
binchromchromStartchromEndnamescorestrandobservedallele1homoCount1allele2homoCount2heteroCount
585chr14516145162rs103997490+C/TC4400
585chr14525645257rs29494200+A/TT4500
585chr17243372434rs403030312-C/TC44T01
585chr17251472515rs40303000-G/TG4300
585chr17768877689rs38559520-C/TT3800
585chr17803178032rs94055012+C/TC0T441
585chr18146781468rs133287140+C/TC4500
586chr1222076222077rs114909370+A/GG4500
589chr1524445524446rs66834660+C/GC4500
589chr1530302530303rs15389410+C/TT4500

Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.