About this Dataset

Approved Research Projects By The Committee For The Protection Of Human Subjects

This dataset contains research projects approved by the California Health and Human Services Agency (CalHHS) Committee for the Protection of Human Subjects (CPHS). CPHS is the CalHHS institutional review board and reviews all research involving human participants conducted or supported by the CalHHS and all research using private information held by CalHHS and all other state agencies.
Organization: State of California
Last updated: 2024-11-27T01:07:53.692259
Tags: california-health-and-human-services-agency, confidential-data, cphs, human-subjects, institutional-review-board, irb, principal-investigator, protocol, research-projects, researchers, university-research

Tables

CPHS Approved Research Projects - 2017

@usgov.ca_gov_approved_research_projects_by_the_committee_for_c3b6f82a.cphs_approved_research_projects_2017

70.44 kB
1,002 rows
7 columns

CREATE TABLE cphs_approved_research_projects_2017 (
  "protocol_id" VARCHAR,
  "pi_last_name" VARCHAR,
  "pi_first_name" VARCHAR,
  "application_type" VARCHAR,
  "pi_organization" VARCHAR,
  "data_source" VARCHAR,
  "project_title" VARCHAR
);

CPHS Approved Research Projects - 2018

@usgov.ca_gov_approved_research_projects_by_the_committee_for_c3b6f82a.cphs_approved_research_projects_2018

93.68 kB
1,781 rows
8 columns

CREATE TABLE cphs_approved_research_projects_2018 (
  "project_site" VARCHAR,
  "project_type" VARCHAR,
  "type_of_activity" VARCHAR,
  "pi" VARCHAR,
  "institution" VARCHAR,
  "title" VARCHAR,
  "data_source" VARCHAR,
  "affiliation_and_data_source" VARCHAR
);

CPHS Approved Research Projects - 2019

@usgov.ca_gov_approved_research_projects_by_the_committee_for_c3b6f82a.cphs_approved_research_projects_2019

60.35 kB
607 rows
10 columns

CREATE TABLE cphs_approved_research_projects_2019 (
  "protocol_id" VARCHAR,
  "pi_last_name" VARCHAR,
  "pi_first_name" VARCHAR,
  "application_type" VARCHAR,
  "pi_organization" VARCHAR,
  "data_source" VARCHAR,
  "project_title" VARCHAR,
  "completed" TIMESTAMP,
  "initial_approval" TIMESTAMP,
  "latest_approval" TIMESTAMP
);

CPHS Approved Research Projects - 2020

@usgov.ca_gov_approved_research_projects_by_the_committee_for_c3b6f82a.cphs_approved_research_projects_2020

74.56 kB
796 rows
9 columns

CREATE TABLE cphs_approved_research_projects_2020 (
  "protocol_id" VARCHAR,
  "project_type" VARCHAR,
  "application_type" VARCHAR,
  "pi_name" VARCHAR,
  "pi_organization" VARCHAR,
  "project_title" VARCHAR,
  "data_source" VARCHAR,
  "defined" TIMESTAMP,
  "completed" TIMESTAMP
);

CPHS Approved Research Projects - 2021

@usgov.ca_gov_approved_research_projects_by_the_committee_for_c3b6f82a.cphs_approved_research_projects_2021

49.25 kB
410 rows
9 columns

CREATE TABLE cphs_approved_research_projects_2021 (
  "protocol_id" VARCHAR,
  "project_type" VARCHAR,
  "application_type" VARCHAR,
  "name" VARCHAR,
  "pi_organization" VARCHAR,
  "project_title" VARCHAR,
  "data_source" VARCHAR,
  "defined" TIMESTAMP,
  "completed" TIMESTAMP
);