19  开通google账户

19.1 注册google邮箱

hulovehou@gmail.com

19.2 用google邮箱注册physionet.org账号

hulovehou/Excuseme!***?

19.3 创建项目

19.4 申请权限

https://physionet.org/content/eicu-crd/2.0/

绑定orcid有利于通过审核。

Application Date: March 23, 2024

User: hulovehou
My first (given) name(s): hulove
My last (family) name(s): hou
Suffix (e.g., Jr.), if applicable:
PhysioNet e-mail: hulovehou@gmail.com
Researcher's Category: Hospital Researcher
Organization Name: Maoming People‘s Hospital
Job title or position: Dr.
City: Maoming
State/Province:
ZIP/postal code: 525200
Country: China
Webpage:

Reference Category: Colleague
Reference's Name: Linhui Hu
Reference's Email: hulinhui@live.cn
Reference's Organization: Maoming People's Hospital
Reference's job title or position: Dr.

Research Topic: The project is aiming to establish an early warning model for sepsis in intensive care unit to support physician's decision on diagnosis and intervention.

Date of this agreement: March 23, 2024, 1:03 p.m.
Decision: Pending



Application Date: March 22, 2024

User: hulovehou
My first (given) name(s): hulove
My last (family) name(s): hou
Suffix (e.g., Jr.), if applicable:
PhysioNet e-mail: hulovehou@gmail.com
Researcher's Category: Hospital Researcher
Organization Name: Maoming People's Hospital
Job title or position: Doctor
City: Maoming
State/Province:
ZIP/postal code: 525000
Country: China
Webpage:

Reference Category: Colleague
Reference's Name: Linhui Hu
Reference's Email: hulinhui@jnu.edu.cn
Reference's Organization: Jinan University
Reference's job title or position: Doctor

Research Topic: This project is to setup an early warning model of sepsis in intesive care unit to support the physican's decision on diagnosis and intervention.

Date of this agreement: March 22, 2024, 6:26 a.m.
Decision Date: March 23, 2024
Decision: Withdrawn

注意:Reference’s Email: hulinhui@jnu.edu.cn 这个是虚假的邮箱。可能会影响注册,故又撤回申请,重新填了真实邮箱(不一定需要机构邮箱)。

19.5 邮箱通知上传科研伦理学习记录

19.5.1 学习方法

详细介绍: https://physionet.org/about/citi-course/ citiprogram账号:跟hulovehou@gmail.com一样

chat可以辅助做题,完成任务后会得到两个文件,分别是completion record和certificate.

返回https://physionet.org/settings/training/上传完成报告,等待审核。可以在https://physionet.org/settings/certification/查看审核状态。

19.6 等待通过

awating-review ## 通过

2天即通过。

图 19.1— application-approved

19.7 Google Cloud Storage

https://console.cloud.google.com/storage/browser/eicu-crd-2.0.physionet.org/ 用hulovehou@gmail.com登录 数据是跟physionet网站上一致的,没有derived数据表

19.8 Big query

https://console.cloud.google.com/bigquery

  • 先开通权限,需提供信用卡和地址,邮箱等,信用卡填Visa卡即可,地址和邮箱填写美国随意一个就行。Big query提供300美元的免费使用额度,用完之后如果不手动开启权限,不会自动从信用卡扣费。

  • 将physionet-data添加至big query

将physionet-data添加至bigquery - 导出数据

导出数据 {#fig-export_data}

  • 提取数据

直接导出只是前500行数据,提取数据后才能获取完整数据

提取全部数
  • 下载数据至csv文件

下载数据至csv文件 - ventilation_events.csv

注意:上述方法也只能导出前5万行数据,总共有9万多行数据。