from solvebio import Dataset, Filter

clinvar = Dataset.retrieve('Clinvar/Clinvar')
variants = Dataset.retrieve('Clinvar/Variants')
submissions = Dataset.retrieve('Clinvar/Submissions')

clinvar.query(genome_build='GRCh37').range(1,156104629,156104629, exact=True)

scvs = clinvar.query(genome_build='GRCh37').range(1,156104629,156104629, exact=True)[0].get('scv_accession')
print scvs

submissions.query().filter(scv_accession__in=scvs)

pubmed_ids = [submission_record.get('pubmed_id') for submission_record in submissions.query().filter(scv_accession__in=scvs)
              if submission_record.get('pubmed_id') is not None]
print pubmed_ids