ORMs¶

SQLAlchemy ORMs for the routines, which allows easy integration of testing (including automatic setup of test databases and tables).

Meetup¶

class Group(**kwargs)[source]¶

Bases: sqlalchemy.ext.declarative.api.Base

id¶

urlname¶

category_name¶

category_shortname¶

city¶

country¶

created¶

description¶

lat¶

lon¶

members¶

name¶

topics¶

category_id¶

country_name¶

timestamp¶

class GroupMember(**kwargs)[source]¶

Bases: sqlalchemy.ext.declarative.api.Base

Note: no foreign key constraint, since unknown groups will be found in the member expansion phase

group_id¶

group_urlname¶

member_id¶

NIH schema¶

The schema for the World RePORTER data.

class Projects(**kwargs)[source]¶

Bases: sqlalchemy.ext.declarative.api.Base

application_id¶

activity¶

administering_ic¶

application_type¶

arra_funded¶

award_notice_date¶

budget_start¶

budget_end¶

cfda_code¶

core_project_num¶

ed_inst_type¶

foa_number¶

full_project_num¶

funding_ics¶

funding_mechanism¶

fy¶

ic_name¶

org_city¶

org_country¶

org_dept¶

org_district¶

org_duns¶

org_fips¶

org_ipf_code¶

org_name¶

org_state¶

org_zipcode¶

phr¶

pi_ids¶

pi_names¶

program_officer_name¶

project_start¶

project_end¶

project_terms¶

project_title¶

serial_number¶

study_section¶

study_section_name¶

suffix¶

support_year¶

direct_cost_amt¶

indirect_cost_amt¶

total_cost¶

subproject_id¶

total_cost_sub_project¶

nih_spending_cats¶

class Abstracts(**kwargs)[source]¶

Bases: sqlalchemy.ext.declarative.api.Base

application_id¶

abstract_text¶

class Publications(**kwargs)[source]¶

Bases: sqlalchemy.ext.declarative.api.Base

pmid¶

author_name¶

affiliation¶

author_list¶

country¶

issn¶

journal_issue¶

journal_title¶

journal_title_abbr¶

journal_volume¶

lang¶

page_number¶

pub_date¶

pub_title¶

pub_year¶

pmc_id¶

class Patents(**kwargs)[source]¶

Bases: sqlalchemy.ext.declarative.api.Base

patent_id¶

patent_title¶

project_id¶

patent_org_name¶

class LinkTables(**kwargs)[source]¶

Bases: sqlalchemy.ext.declarative.api.Base

pmid¶

project_number¶

class ClinicalStudies(**kwargs)[source]¶

Bases: sqlalchemy.ext.declarative.api.Base

clinicaltrials_gov_id¶

core_project_number¶

study¶

study_status¶