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. Note that the schema was automatically generated based on an IPython hack session using the limits and properties of the data from the World ExPORTER (which explains the unusual VARCHAR limits).

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¶