ORMs¶
SQLAlchemy
ORMs for the routines, which allows easy integration of testing (including automatic setup of test databases and tables).
Meetup¶
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
¶
-
affiliation
¶
-
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
¶
-