datadiscovery-nlm-nih-gov/health-services-research-projects-in-progress-rysd-8s3y
Icon for Socrata external plugin
 
Preview
  • health_services_research_projects_in_progress
     
 
Readme
Updated 22 days ago
Indexed 2 hours ago

Health Services Research Projects in Progress (HSRProj) (retired September 14, 2021)

Health Services Research Projects in Progress (HSRProj) is a database of health services research and public health projects in progress, related to research in quality, cost, and access to health care. Includes behavioral health research and public health research. Currently includes over 38,000 projects with information back to the 1990s.

This resource was retired on September 14, 2021 and is no longer updated.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
HSR_NUM_SUBJECTShsr_num_subjectshsr_num_subjectsText
HSR_DATA_SOURCEhsr_data_sourcehsr_data_sourceText
KEYWORDSkeywordskeywordsText
GET_GRANT_ID(A.NLMUNIQUE_ID)get_grant_id_a_nlmuniqueget_grant_id_a_nlmuniqueText
HSR_TOTAL_AWARD_AMOUNThsr_total_award_amounthsr_total_award_amountNumber
HSR_AWARD_TYPEhsr_award_typehsr_award_typeText
HSR_FINAL_YEARhsr_final_yearhsr_final_yearText
HSR_INITIAL_MONTHhsr_initial_monthhsr_initial_monthText
GET_SOURCE_AWARD_COMPLETE(A.NLMUNIQUE_ID)get_source_award_completeget_source_award_completeText
GET_PO_LIST_COMPLETE(A.NLMUNIQUE_ID)get_po_list_complete_aget_po_list_complete_aText
HSR_PROJECTTITLEhsr_projecttitlehsr_projecttitleText
HSR_DATE_PUBLISHEDhsr_date_publishedhsr_date_publishedText
GET_INVESTIGATORLIST_COMPLETE(A.NLMUNIQUE_ID)get_investigatorlist_completeget_investigatorlist_completeText
GET_SA_LIST_COMPLETE(A.NLMUNIQUE_ID)get_sa_list_complete_aget_sa_list_complete_aURL
GET_PROJECT_STATUS(A.NLMUNIQUE_ID)get_project_status_a_nlmuniqueget_project_status_a_nlmuniqueText
ABSTRACTabstractabstractText
MESHTERMSmeshtermsmeshtermsText
HSR_DATE_COMPLETEDhsr_date_completedhsr_date_completedText
HSR_DATE_CREATEDhsr_date_createdhsr_date_createdText
LPAD(A.NLMUNIQUE_ID,8,'0')lpad_a_nlmunique_id_8_0lpad_a_nlmunique_id_8_0Text
NLMUNIQUE_IDnlmunique_idnlmunique_idText
GET_AWARD_INFORMATION_COMPLETE(A.NLMUNIQUE_ID)get_award_information_completeget_award_information_completeURL
GET_RELATED_LIST_COMPLETE(A.NLMUNIQUE_ID)get_related_list_completeget_related_list_completeText
GET_PO_ZIP(A.NLMUNIQUE_ID)get_po_zip_a_nlmunique_idget_po_zip_a_nlmunique_idText
GET_PO_STATE(A.NLMUNIQUE_ID)get_po_state_a_nlmuniqueget_po_state_a_nlmuniqueText
GET_PO_COUNTRY(A.NLMUNIQUE_ID)get_po_country_a_nlmuniqueget_po_country_a_nlmuniqueText
ARCHIVED_YNarchived_ynarchived_ynCheckbox
HSR_STUDYPOPULATIONhsr_studypopulationhsr_studypopulationText
HSR_POPULATION_BASEhsr_population_basehsr_population_baseText
HSR_FINAL_MONTHhsr_final_monthhsr_final_monthText
HSR_INITIAL_YEARhsr_initial_yearhsr_initial_yearText
HSR_DATE_REVISEDhsr_date_revisedhsr_date_revisedText
'HSRPROJECT'hsrprojecthsrprojectText
Upstream Metadata