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

59.96 MB
42461 rows
33 columns


CREATE TABLE table_1 (
  "nlmunique_id" BIGINT,
  "lpad_a_nlmunique_id_8_0" BIGINT,
  "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_po_list_complete_a_nlmunique_id" VARCHAR,
  "get_source_award_complete_a_nlmunique_id" VARCHAR,
  "get_sa_list_complete_a_nlmunique_id" VARCHAR,
  "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_project_status_a_nlmunique_id" VARCHAR,
  "abstract" VARCHAR,
  "meshterms" VARCHAR,
  "keywords" VARCHAR,
  "hsr_data_source" VARCHAR,
  "hsr_num_subjects" VARCHAR,
  "hsr_population_base" VARCHAR,
  "hsr_studypopulation" VARCHAR,
  "n__hsrproject" VARCHAR,
  "archived_yn" VARCHAR,
  "get_po_country_a_nlmunique_id" VARCHAR,
  "get_po_state_a_nlmunique_id" VARCHAR,
  "get_po_zip_a_nlmunique_id" VARCHAR,
  "get_related_list_complete_a_nlmunique_id" VARCHAR,
  "get_award_information_complete_a_nlmunique_id" VARCHAR
);