About this Dataset

Health Services Research Projects In Progress (HSRProj)

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

This resource was retired on September 14, 2021 and is no longer updated.
Organization: U.S. Department of Health & Human Services
Last updated: 2021-09-19T12:17:46.260411
Tags: health-services-research, public-health

Tables

Table 1

@usgov.hhs_gov_health_services_research_projects_in_progress__ca01e472.table_1

62.87 MB
42,461 rows
33 columns

CREATE TABLE table_1 (
  "nlmunique_id" BIGINT,
  "lpad_a_nlmunique_id_8_0" BIGINT  -- LPAD(A.NLMUNIQUE ID,8,'0'),
  "hsr_date_created" TIMESTAMP,
  "hsr_date_completed" TIMESTAMP,
  "hsr_date_revised" TIMESTAMP,
  "hsr_date_published" TIMESTAMP,
  "hsr_projecttitle" VARCHAR,
  "get_investigatorlist_complete_a_nlmunique_id" VARCHAR  -- GET INVESTIGATORLIST COMPLETE(A.NLMUNIQUE ID),
  "get_po_list_complete_a_nlmunique_id" VARCHAR  -- GET PO LIST COMPLETE(A.NLMUNIQUE ID),
  "get_source_award_complete_a_nlmunique_id" VARCHAR  -- GET SOURCE AWARD COMPLETE(A.NLMUNIQUE ID),
  "get_sa_list_complete_a_nlmunique_id" VARCHAR  -- GET SA LIST COMPLETE(A.NLMUNIQUE ID),
  "hsr_initial_year" BIGINT,
  "hsr_initial_month" DOUBLE,
  "hsr_final_year" BIGINT,
  "hsr_final_month" DOUBLE,
  "hsr_award_type" VARCHAR,
  "hsr_total_award_amount" DOUBLE,
  "get_grant_id_a_nlmunique_id" VARCHAR  -- GET GRANT ID(A.NLMUNIQUE ID),
  "get_project_status_a_nlmunique_id" VARCHAR  -- GET PROJECT STATUS(A.NLMUNIQUE ID),
  "abstract" VARCHAR,
  "meshterms" VARCHAR,
  "keywords" VARCHAR,
  "hsr_data_source" VARCHAR,
  "hsr_num_subjects" VARCHAR,
  "hsr_population_base" VARCHAR,
  "hsr_studypopulation" VARCHAR,
  "n__hsrproject" VARCHAR  -- 'HSRPROJECT',
  "archived_yn" VARCHAR,
  "get_po_country_a_nlmunique_id" VARCHAR  -- GET PO COUNTRY(A.NLMUNIQUE ID),
  "get_po_state_a_nlmunique_id" VARCHAR  -- GET PO STATE(A.NLMUNIQUE ID),
  "get_po_zip_a_nlmunique_id" VARCHAR  -- GET PO ZIP(A.NLMUNIQUE ID),
  "get_related_list_complete_a_nlmunique_id" VARCHAR  -- GET RELATED LIST COMPLETE(A.NLMUNIQUE ID),
  "get_award_information_complete_a_nlmunique_id" VARCHAR  -- GET AWARD INFORMATION COMPLETE(A.NLMUNIQUE ID)
);