| Name |
approved-research-projects-by-the-committee-for-the-protection-of-human-subjects |
|---|
| Updated |
2024-08-28 |
|---|
| 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 --> None
cphs-data-dictionary-acronyms.xlsx --> None
cphs-approved-research-projects-2017.csv --> cphs_approved_research_projects_2017
cphs-approved-research-projects-2018.csv --> cphs_approved_research_projects_2018
cphs-approved-research-projects-2019.csv --> cphs_approved_research_projects_2019
cphs-approved-research-projects-20190.csv --> cphs_approved_research_projects_20190
cphs-approved-research-projects-2020.csv --> cphs_approved_research_projects_2020
cphs-approved-research-projects-20200.csv --> cphs_approved_research_projects_20200
cphs-approved-research-projects-2021.csv --> cphs_approved_research_projects_2021
cphs-approved-research-projects-20210.csv --> cphs_approved_research_projects_20210
cphs-approved-research-projects-20211.csv --> cphs_approved_research_projects_20211
cphs-approved-research-projects-2022.csv --> cphs_approved_research_projects_2022
|
|---|
| Updates |
| 2025-02-02 17:20:58 |
|
0 |
| 2025-01-31 15:09:34 |
|
0 |
| 2024-12-27 18:04:57 |
|
0 |
| 2024-12-15 15:53:08 |
|
0 |
| 2024-12-15 15:46:07 |
|
0 |
| 2024-11-14 22:11:42 |
|
None |
| 2024-11-13 17:19:47 |
|
None |
| 2024-09-18 10:53:17 |
|
None |
| 2024-09-18 08:54:48 |
|
None |
| 2024-09-17 20:06:15 |
|
None |
| 2024-09-09 21:26:06 |
|
None |
| 2024-09-09 14:16:58 |
|
None |
| 2024-09-09 12:11:31 |
|
None |
| 2024-09-03 16:28:53 |
|
None |
|
|---|