PEDSnet Production Database (2025-10)

Created

Submission Date

2025-07

Data Collection

2025-07 - 2025-10

Files

Data Source

PEDSnet Common Data Model, v5.9
Created:2025-07-14Affiliation:PEDSnet Data Coordinating Center
This document provides the ETL processing assumptions and conventions developed by the PEDSnet data partners that a data partner should use to ensure common ETL business rules.

Tags

Abstract

PEDSnet production database containing de-identified aggregate electronic healthcare information for ten contributing pediatric healthcare institutions. This database corresponds to Version 5.9 of the PEDSnet data model.

You may learn more about how to access PEDSnet data for research on the PEDSnet main website or, submit a collaboration request here.

Provenance

Description

This database uses the PEDSnet Common Data Model and consists of 24 tables that represent over 14 million patients. PEDSnet’s data network is one of the valuable resources it brings to accelerating the study of child health. The PEDSnet Coordinating Center partners with the informatics teams at each PEDSnet institution to continually assess current network data and strengthen the data infrastructure for a wide range of studies.

PEDSnet Summary Statistics
N = 15,452,366

Summary Variables Visit Counts (N) Percent Recent Visit (in the last 3 months)
Total Emergency Department (ED) Visits 18,514,557
Total Emergency Department (ED) Visits in the Last 3 Months 293,462 1.59%
Total Hospitalizations 3,793,749 **
Total Hospitalizations in the Last 3 Months 83,247 2.19%
Total Outpatient Visits 184,993,562 **
Total Outpatient Visits in the Last 3 Months 4,052,135 2.19%

** Indicates total counts across all time periods for comparison with recent 3-month activity


PEDSnet Database Population

Total Database Population
Active (visit in last 18 months) Overall
N= 5,764,049 N= 15,452,366

Database Population by Collaborating Institution
Institution Active (visit in last 18 months) Overall
CCHMC 514,216 (8.9%) 1,160,846 (7.5%)
CHOP 695,442 (12.1%) 1,778,540 (11.5%)
Colorado 450,376 (7.8%) 1,500,678 (9.7%)
Lurie 311,570 (5.4%) 1,063,145 (6.9%)
National 715,550 (12.4%) 1,844,190 (11.9%)
Nationwide 520,202 (9.0%) 1,250,434 (8.1%)
Nemours 726,016 (12.6%) 2,011,022 (13.0%)
Seattle 270,082 (4.7%) 944,647 (6.1%)
Stanford 402,230 (7.0%) 967,127 (6.3%)
Texas 1,158,365 (20.1%) 2,931,737 (19.0%)

Age at first Visit
Age (in years) Active (visit in last 18 months) Overall
0 2,764,309 (48.0%) 5,147,804 (33.3%)
1 - 4 1,288,672 (22.4%) 3,425,416 (22.2%)
5 - 11 981,984 (17.0%) 3,349,111 (21.7%)
12 - 17 427,566 (7.4%) 2,102,680 (13.6%)
18 - 24 61,403 (1.1%) 339,698 (2.2%)
25+ 240,115 (4.2%) 1,060,893 (6.9%)
Mean 4.8 7.5
Median [Q1, Q3] 1.1 [0.0, 6.4] 3.6 [0.3, 11.1]

Age at Last Visit
Age (in years) Active (visit in last 18 months) Overall
0 343,370 (6.0%) 965,329 (6.2%)
1 - 4 1,163,604 (20.2%) 2,822,284 (18.3%)
5 - 11 1,857,251 (32.2%) 4,230,051 (27.4%)
12 - 17 1,532,645 (26.6%) 4,158,160 (26.9%)
18 - 24 509,846 (8.8%) 1,877,147 (12.1%)
25+ 357,333 (6.2%) 1,372,631 (8.9%)
Mean 11.4 12.7
Median [Q1, Q3] 10.1 [4.7, 15.8] 11.5 [5.1, 17.3]

Duration of Follow-up (in years)
Active (visit in last 18 months) Overall
Mean 6.6 5.3
Median [Q1, Q3] 5.3 [1.6, 10.5] 3.4 [0.4, 8.7]

Duration of Follow-up for All Chronic Patients (in years)
Active (visit in last 18 months) Overall
Mean 8 7.5
Median [Q1, Q3] 7.1 [3.2, 12.0] 6.3 [2.6, 11.4]

Year of Cohort Entry
Active (visit in last 18 months) Overall
Mean 2018 2015
Median [Q1, Q3] 2019 [2014, 2023] 2016 [2011, 2020]

Insurance
Payer Active (visit in last 18 months) Overall
Medicare/Medicaid 1,907,391 (33.1%) 4,836,238 (31.3%)
Private 2,736,278 (47.5%) 7,443,215 (48.2%)
Other/Unknown 1,120,380 (19.4%) 3,172,913 (20.5%)

Medical Complexity
PMCA Active (visit in last 18 months) Overall
Complex Chronic (malignant, progressive, or 2+ body systems) 513,357 (8.9%) 769,065 (5.0%)
Noncomplex Chronic 827,512 (14.4%) 1,332,624 (8.6%)
No Chronic Disorders 4,423,180 (76.7%) 13,323,913 (86.2%)


Demographics
Sex Active (visit in last 18 months) Overall
Female 2,911,538 (50.5%) 7,809,551 (50.5%)
Male 2,851,587 (49.5%) 7,627,656 (49.4%)

Race Active (visit in last 18 months) Overall
American Indian or Alaska Native 19,471 (0.3%) 53,351 (0.3%)
Asian/Native Hawaiian/Other Pacific Islander 355,167 (6.2%) 822,841 (5.3%)
Black/African American 961,279 (16.7%) 2,320,195 (15.0%)
White 2,976,975 (51.6%) 8,154,020 (52.8%)
Multiple race 289,357 (5.0%) 590,703 (3.8%)
Other** 991,461 (17.2%) 2,578,682 (16.7%)
Unknown 170,339 (3.0%) 932,574 (6.0%)

Ethnicity Active (visit in last 18 months) Overall
Hispanic 1,296,809 (22.5%) 3,118,137 (20.2%)
Not Hispanic 3,913,066 (67.9%) 10,225,641 (66.2%)
Other/Unknown 554,174 (9.6%) 2,107,588 (13.6%)


Prevalence of Common Health Conditions
Health Condition N Prevalence per 10,000 patients in database
Appendicitis 109,218 71
Juvenile Idiopathic Arthritis 28,120 18
Asthma 1,391,864 901
Bronchopulmonary dysplasia 36,767 24
Brain tumor 36,393 24
Chronic Granulomatous Disease 519 0
Cystic Fibrosis 13,853 9
Duchenne muscular dystrophy 12,406 8
Inflammatory bowel disease (Ulcerative Colitis + Crohn’s Disease) 47,587 31
Immune Thrombocytopenic Purpura 3,014 2
Leukemia + Lymphoma 50,412 33
Lyme Disease 26,776 17
Sickle Cell Anemia 22,357 14
Seizure Disorder 465,144 301
Type 1 Diabetes 88,190 57

Vocabulary

Related Publications

Creative Commons license

Except where otherwised noted, this item's license is described as a BSD 2-Clause License.

Cite this Documentation

PEDSnet. (2025, September). PEDSnet Production Database (2025-10). [Documentation]. PEDSpace Knowledge Bank. https://hdl.handle.net/20.500.14642/1017.8

Search Results

Version History

Now showing 1 - 8 of 8
VersionDateSummary
8*
2025-09-04 10:30:45
V5.9
2025-09-04 10:21:31
V5.8
2025-05-09 11:29:39
V5.7
2025-05-05 13:27:19
V5.6
2025-05-05 13:24:15
V5.5
2025-05-05 13:19:19
V5.4
2025-05-05 13:09:52
V5.3
2025-05-05 11:26:46
V5.2
* Selected version