HCAI

Home

Dataset:

Name

approved-research-projects-by-the-committee-for-the-protection-of-human-subjects

Updated

2024-08-28

CA Dataset

link

Current

True

Tables

cphs_approved_research_projects_2017

protocol_id - varchar(11)
pi_last_name - varchar(18)
pi_first_name - varchar(13)
application_type - varchar(16)
pi_organization - varchar(75)
data_source - varchar(192)
project_title - varchar(251)

cphs_approved_research_projects_2018

project_site - varchar(59)
project_type - varchar(68)
type_of_activity - varchar(16)
pi - varchar(65)
institution - varchar(66)
title - varchar(776)
data_source - varchar(18)
affiliation_and_data_source - varchar(2946)

cphs_approved_research_projects_2019

protocol_id - varchar(59)
pi_last_name - varchar(15)
pi_first_name - varchar(14)
application_type - varchar(16)
pi_organization - varchar(66)
data_source - varchar(721)
project_title - varchar(776)
completed - varchar(10)
initial_approval - varchar(16)
latest_approval - varchar(15)

cphs_approved_research_projects_20190

id - varchar(3)
protocol_id - varchar(55)
pi_last_name - varchar(18)
pi_first_name - varchar(13)
application_type - varchar(16)
pi_organization - varchar(64)
data_source - varchar(1616)
project_title - varchar(279)
completed - varchar(9)
initial_approval - varchar(16)
latest_approval - varchar(15)

cphs_approved_research_projects_2020

protocol_id - varchar(59)
project_type - varchar(79)
application_type - varchar(16)
pi_name - varchar(66)
pi_organization - varchar(66)
project_title - varchar(326)
data_source - varchar(725)
defined - varchar(10)
completed - varchar(10)

cphs_approved_research_projects_20200

protocol_id - varchar(58)
project_type - varchar(96)
application_type - varchar(16)
pi_name - varchar(70)
pi_organization - varchar(64)
project_title - varchar(329)
data_source - varchar(1611)
defined - varchar(9)
completed - varchar(9)

cphs_approved_research_projects_2021

protocol_id - varchar(59)
project_type - varchar(78)
application_type - varchar(16)
name - varchar(66)
pi_organization - varchar(58)
project_title - varchar(275)
data_source - varchar(723)
defined - varchar(10)
completed - varchar(10)

cphs_approved_research_projects_20210

protocol_id - varchar(59)
project_type - varchar(79)
application_type - varchar(16)
name - varchar(66)
pi_organization - varchar(66)
project_title - varchar(290)
data_source - varchar(1622)
defined - varchar(9)
completed - varchar(9)

cphs_approved_research_projects_20211

protocol_id - varchar(59)
project_type - varchar(79)
application_type - varchar(35)
name - varchar(70)
pi_organization - varchar(71)
project_title - varchar(287)
data_source - varchar(1609)
defined - varchar(9)
completed - varchar(9)

cphs_approved_research_projects_2022

protocol_id - varchar(59)
name - varchar(70)
application_type - varchar(16)
pi_organization - varchar(66)
project_type - varchar(61)
data_source - varchar(1622)
project_title - varchar(260)
defined - varchar(9)
completed - varchar(9)

Sources

cphs-approved-projects-datadictionary.pdf	-
cphs-data-dictionary-acronyms.xlsx	-
datapackage.json	-
cphs-approved-research-projects-2017.csv	-	Table: cphs_approved_research_projects_2017	Updated: 2025-10-11
cphs-approved-research-projects-2018.csv	-	Table: cphs_approved_research_projects_2018	Fails: 3
cphs-approved-research-projects-2019.csv	-	Table: cphs_approved_research_projects_2019	Updated: 2025-10-11
cphs-approved-research-projects-20190.csv	-	Table: cphs_approved_research_projects_20190	Updated: 2025-10-11
cphs-approved-research-projects-2020.csv	-	Table: cphs_approved_research_projects_2020	Updated: 2025-10-11
cphs-approved-research-projects-20200.csv	-	Table: cphs_approved_research_projects_20200	Updated: 2025-10-11
cphs-approved-research-projects-2021.csv	-	Table: cphs_approved_research_projects_2021	Updated: 2025-10-11
cphs-approved-research-projects-20210.csv	-	Table: cphs_approved_research_projects_20210	Updated: 2025-10-11
cphs-approved-research-projects-20211.csv	-	Table: cphs_approved_research_projects_20211	Updated: 2025-10-11
cphs-approved-research-projects-2022.csv	-	Table: cphs_approved_research_projects_2022	Updated: 2025-10-11

Updated