California Physical Fitness Test Research Data

These research files contain results from the Physical Fitness Test (PFT) program. Each file contains the same information presented in the Reports section of this site and is provided to allow for more complex analyses and customized reporting of the data. The data files, including file layout, entities, and subgroup files, are comma-delimited text files provided in a zip format.

cde.ca.gov-fitnessgram-1999e-ca-1.3.1. Modified 2021-03-11T00:48:56

Resources | Packages | Documentation| Contacts| Data Dictionary

Resources

• entities99. 1999 PFT Entities
• entities01. 2001 PFT Entities
• entities02. 2002 PFT Entities
• entities03. 2003 PFT Entities
• entities04. 2004 PFT Entities
• entities05. 2005 PFT Entities
• entities06. 2006 PFT Entities
• entities07. 2007 PFT Entities
• entities08. 2008 PFT Entities
• entities09. 2009 PFT Entities
• entities10. 2010 PFT Entities
• entities11. 2011 PFT Entities
• entities12. 2011-12 Physical Fitness Entities
• entities13. 2012-13 Physical Fitness Entities
• entities14. 2013-14 Physical Fitness Entities
• entities15. 2014-15 Physical Fitness Entities
• entities16. 2015-16 Physical Fitness Entities
• physfit99. 1999 PFT Fitness Results
• physfit01. 2001 PFT Fitness Results
• physfit02. 2002 PFT Fitness Results
• physfit03. 2003 PFT Fitness Results
• physfit04. 2004 PFT Fitness Results
• physfit05. 2005 PFT Fitness Results
• physfit06. 2006 PFT Fitness Results
• physfit07. 2007 PFT Fitness Results
• physfit08. 2008 PFT Fitness Results
• physfit09. 2009 PFT Fitness Results
• physfit10. 2010 PFT Fitness Results
• physfit11. 2011 PFT Fitness Results
• physfit12. 2011-12 Physical Fitness Research
• physfit13. 2012-13 Physical Fitness Research
• physfit14. 2013-14 Physical Fitness Research
• physfit15. 2014-15 Physical Fitness Research
• physfit16. 2015-16 Physical Fitness Research
• subgroup99. 1999 PFT Subgroup
• subgroup01. 2001 PFT Subgroup
• subgroup02. 2002 PFT Subgroup
• subgroup03. 2003 PFT Subgroup
• subgroup04. 2004 PFT Subgroup
• subgroup05. 2005 PFT Subgroup
• subgroup06. 2006 PFT Subgroup
• subgroup07. 2007 PFT Subgroup
• subgroup08. 2008 PFT Subgroup
• subgroup09. 2009 PFT Subgroup
• subgroup10. 2010 PFT Subgroup
• subgroup11. 2011 PFT Subgroup
• subgroup12. 2011-12 Physical Fitness Subgroups
• subgroup13. 2012-13 Physical Fitness Subgroups
• subgroup14. 2013-14 Physical Fitness Subgroups
• subgroup15. 2014-15 Physical Fitness Subgroups
• subgroup16. 2015-16 Physical Fitness Subgroups

Documentation

Documentation Links

• Physical Fitness Testing (PFT) Home page for the PFT program
• PFT Statewide Research Files Download page with links to research file archives
• Additional Resources Additional resources for the Physical Fitness Test, including links to the Cooper Institute, San Joaquin County Office of Education, and Human Kinetics.
• File Layout 2001 Text form data dictionary, including common code values
• File Layout 2002 Text form data dictionary, including common code values
• File Layout 2003 Text form data dictionary, including common code values
• File Layout 2004 Text form data dictionary, including common code values
• File Layout 2005 Text form data dictionary, including common code values
• File Layout 2006 Text form data dictionary, including common code values
• File Layout 2007 Text form data dictionary, including common code values
• File Layout 2008 Text form data dictionary, including common code values
• File Layout 2009 Text form data dictionary, including common code values
• File Layout 2010 Text form data dictionary, including common code values
• File Layout 2011 Text form data dictionary, including common code values
• File Layout 2012 Text form data dictionary, including common code values
• File Layout 2013 Text form data dictionary, including common code values
• File Layout 2014 Text form data dictionary, including common code values
• File Layout 2015 Text form data dictionary, including common code values
• File Layout 2016 Text form data dictionary, including common code values
• File Layout 1999 Text form data dictionary, including common code values
• Documentation Page

Contacts

• Creator

  High School and Physical Fitness Assessment Office, California Department of Education

• Wrangler

  Eric Busboom, Civic Knowledge

Data Dictionary

entities_1999e2002 | entities_2002e2010 | entities_2011e | subgroups_2011e | subgroups_1999e2010 | physfit_1999e2002 | physfit_2002e2010 | physfit_2011 | physfit_2012e

entities_1999e2002

Column Name	Data Type	Description
ccode	int	County code, defined byt the Secretary of state, not FIPS
dcode	int	District Code
scode	int	Scode
cds_code	str	cds_code
county	str	County
district	str	District
school	str	school

entities_2002e2010

Column Name	Data Type	Description
ccode	int	County code, defined byt the Secretary of state, not FIPS
dcode	int	District Code
charternum	str	charternum
scode	int	Scode
cds_code	str	cds_code
county	str	County
district	str	District
school	str	school

entities_2011e

Column Name	Data Type	Description
ccode	int	County code, defined byt the Secretary of state, not FIPS
dcode	int	dcode
chrtnum	str	chrtnum
scode	int	scode
cdscode	str	cdscode
county	str	County name
district	str	District
school	str	School

subgroups_2011e

Column Name	Data Type	Description
level_number	int	Level_Number
report_number	int	Report_Number
table_number	int	Table_Number
line_number	int	Line_Number
line_text	str	Line_Text
table_type	str	Table_Type
subgroup	str	Subgroup

subgroups_1999e2010

Column Name	Data Type	Description
subgrp	int	SubGrp
rpttype	int	RptType
linenum	int	LineNum
reporttype	str	ReportType
subgroup	str	SubGroup
line_text	str	line_text

physfit_1999e2002

Column Name	Data Type	Description
level	int	Level
subgrp	int	SubGrp
rpttype	int	RptType
line_num	int	line_num
ccode	int	County code, defined byt the Secretary of state, not FIPS
dcode	int	Dcode
scode	int	Scode
cds_code	str	cds_code
gr05_stu	int	Gr05_Stu
gr5pctin	float	Gr5PctIn
gr5pctnotin	float	Gr5PctNotIn
gr07_stu	int	Gr07_Stu
gr7pctin	float	Gr7PctIn
gr7pctnotin	float	Gr7PctNotIn
gr09_stu	int	Gr09_Stu
gr9pctin	float	Gr9PctIn
gr9pctnotin	float	Gr9PctNotIn

physfit_2002e2010

Column Name	Data Type	Description
level	int	Level
subgrp	int	SubGrp
rpttype	int	RptType
line_num	int	line_num
ccode	int	County code, defined byt the Secretary of state, not FIPS
dcode	int	Dcode
charternum	str	charternum
scode	int	Scode
cds_code	str	cds_code
gr05_stu	int	Gr05_Stu
gr5pctin	float	Gr5PctIn
gr5pctnotin	float	Gr5PctNotIn
gr07_stu	int	Gr07_Stu
gr7pctin	float	Gr7PctIn
gr7pctnotin	float	Gr7PctNotIn
gr09_stu	int	Gr09_Stu
gr9pctin	float	Gr9PctIn
gr9pctnotin	float	Gr9PctNotIn

physfit_2011

Column Name	Data Type	Description
id	int	Physical Fitness Research, 2010 to 2014
level_number	int	1 = school 2 = district 3 = county 4 = state
report_number	int	Codes for demographic category of values in report: gender, race, ethnicity, etc. See source documentation for codes.
table_number	int	Table_Number
line_number	int	Line Number in Table
co	int	County code, defined by the Secretary of state, not FIPS
dist	int	District Code
schl	int	School Code
line_text	str	Line Text
nostud5	int	Number of Grade 5
nohfz5	int	Number of Grade 5
perc5a	float	Percent of Grade 5 students in Healthy Fitness Zone
perc5b	float	Percent of Grade 5 Students in Needs Improvement
perc5c	float	Percent of Grade 5 Students in Needs Improvement – High Risk
nostud7	int	Number of Grade 7 Students Tested
nohfz7	int	Number of Grade 7 Students in Healthy Fitness Zone
perc7a	float	Percent of Grade 7 students in Healthy Fitness Zone
perc7b	float	Percent of Grade 7 Students in Needs Improvement
perc7c	float	Percent of Grade 7 Students in Needs Improvement – High Risk
nostud9	int	Number of Grade 9 Students Tested
nohfz9	int	Number of Grade 9 Students in Healthy Fitness Zone
perc9a	float	Percent of Grade 9 students in Healthy Fitness Zone
perc9b	float	Percent of Grade 9 Students in Needs Improvement
perc9c	float	Percent of Grade 9 Students in Needs Improvement – High Risk
chrtnum	str	ChrtNum

physfit_2012e

Column Name	Data Type	Description
level_number	int	1 = school 2 = district 3 = county 4 = state
report_number	int	Codes for demographic category of values in report: gender, race, ethnicity, etc. See source documentation for codes.
table_number	int	Table_Number
line_number	int	Line Number in Table
co	int	County code, defined by the Secretary of state, not FIPS
dist	int	District Code
schl	int	School Code
line_text	str	Line Text
nostud5	int	Number of Grade 5
nohfz5	int	Number of Grade 5
perc5a	float	Percent of Grade 5 students in Healthy Fitness Zone
perc5b	float	Percent of Grade 5 Students in Needs Improvement
perc5c	float	Percent of Grade 5 Students in Needs Improvement – High Risk
nostud7	int	Number of Grade 7 Students Tested
nohfz7	int	Number of Grade 7 Students in Healthy Fitness Zone
perc7a	float	Percent of Grade 7 students in Healthy Fitness Zone
perc7b	float	Percent of Grade 7 Students in Needs Improvement
perc7c	float	Percent of Grade 7 Students in Needs Improvement – High Risk
nostud9	int	Number of Grade 9 Students Tested
nohfz9	int	Number of Grade 9 Students in Healthy Fitness Zone
perc9a	float	Percent of Grade 9 students in Healthy Fitness Zone
perc9b	float	Percent of Grade 9 Students in Needs Improvement
perc9c	float	Percent of Grade 9 Students in Needs Improvement – High Risk
chrtnum	str	ChrtNum

Packages

• s3 s3://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1.csv
• csv http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1.csv
• source https://github.com/metatab-packages/cde.ca.gov-fitnessgram-1999e-ca.git

Accessing Data in Vanilla Pandas

import pandas as pd


entities99_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/entities99.csv')
entities01_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/entities01.csv')
entities02_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/entities02.csv')
entities03_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/entities03.csv')
entities04_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/entities04.csv')
entities05_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/entities05.csv')
entities06_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/entities06.csv')
entities07_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/entities07.csv')
entities08_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/entities08.csv')
entities09_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/entities09.csv')
entities10_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/entities10.csv')
entities11_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/entities11.csv')
entities12_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/entities12.csv')
entities13_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/entities13.csv')
entities14_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/entities14.csv')
entities15_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/entities15.csv')
entities16_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/entities16.csv')
physfit99_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/physfit99.csv')
physfit01_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/physfit01.csv')
physfit02_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/physfit02.csv')
physfit03_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/physfit03.csv')
physfit04_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/physfit04.csv')
physfit05_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/physfit05.csv')
physfit06_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/physfit06.csv')
physfit07_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/physfit07.csv')
physfit08_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/physfit08.csv')
physfit09_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/physfit09.csv')
physfit10_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/physfit10.csv')
physfit11_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/physfit11.csv')
physfit12_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/physfit12.csv')
physfit13_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/physfit13.csv')
physfit14_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/physfit14.csv')
physfit15_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/physfit15.csv')
physfit16_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/physfit16.csv')
subgroup99_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/subgroup99.csv')
subgroup01_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/subgroup01.csv')
subgroup02_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/subgroup02.csv')
subgroup03_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/subgroup03.csv')
subgroup04_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/subgroup04.csv')
subgroup05_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/subgroup05.csv')
subgroup06_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/subgroup06.csv')
subgroup07_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/subgroup07.csv')
subgroup08_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/subgroup08.csv')
subgroup09_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/subgroup09.csv')
subgroup10_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/subgroup10.csv')
subgroup11_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/subgroup11.csv')
subgroup12_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/subgroup12.csv')
subgroup13_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/subgroup13.csv')
subgroup14_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/subgroup14.csv')
subgroup15_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/subgroup15.csv')
subgroup16_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1/data/subgroup16.csv')

Accessing Package in Metapack

import metapack as mp
pkg = mp.open_package('http://cde.metatab.org/cde.ca.gov-fitnessgram-1999e-ca-1.3.1.csv')

# Create Dataframes
entities99_df = pkg.resource('entities99').dataframe()
entities01_df = pkg.resource('entities01').dataframe()
entities02_df = pkg.resource('entities02').dataframe()
entities03_df = pkg.resource('entities03').dataframe()
entities04_df = pkg.resource('entities04').dataframe()
entities05_df = pkg.resource('entities05').dataframe()
entities06_df = pkg.resource('entities06').dataframe()
entities07_df = pkg.resource('entities07').dataframe()
entities08_df = pkg.resource('entities08').dataframe()
entities09_df = pkg.resource('entities09').dataframe()
entities10_df = pkg.resource('entities10').dataframe()
entities11_df = pkg.resource('entities11').dataframe()
entities12_df = pkg.resource('entities12').dataframe()
entities13_df = pkg.resource('entities13').dataframe()
entities14_df = pkg.resource('entities14').dataframe()
entities15_df = pkg.resource('entities15').dataframe()
entities16_df = pkg.resource('entities16').dataframe()
physfit99_df = pkg.resource('physfit99').dataframe()
physfit01_df = pkg.resource('physfit01').dataframe()
physfit02_df = pkg.resource('physfit02').dataframe()
physfit03_df = pkg.resource('physfit03').dataframe()
physfit04_df = pkg.resource('physfit04').dataframe()
physfit05_df = pkg.resource('physfit05').dataframe()
physfit06_df = pkg.resource('physfit06').dataframe()
physfit07_df = pkg.resource('physfit07').dataframe()
physfit08_df = pkg.resource('physfit08').dataframe()
physfit09_df = pkg.resource('physfit09').dataframe()
physfit10_df = pkg.resource('physfit10').dataframe()
physfit11_df = pkg.resource('physfit11').dataframe()
physfit12_df = pkg.resource('physfit12').dataframe()
physfit13_df = pkg.resource('physfit13').dataframe()
physfit14_df = pkg.resource('physfit14').dataframe()
physfit15_df = pkg.resource('physfit15').dataframe()
physfit16_df = pkg.resource('physfit16').dataframe()
subgroup99_df = pkg.resource('subgroup99').dataframe()
subgroup01_df = pkg.resource('subgroup01').dataframe()
subgroup02_df = pkg.resource('subgroup02').dataframe()
subgroup03_df = pkg.resource('subgroup03').dataframe()
subgroup04_df = pkg.resource('subgroup04').dataframe()
subgroup05_df = pkg.resource('subgroup05').dataframe()
subgroup06_df = pkg.resource('subgroup06').dataframe()
subgroup07_df = pkg.resource('subgroup07').dataframe()
subgroup08_df = pkg.resource('subgroup08').dataframe()
subgroup09_df = pkg.resource('subgroup09').dataframe()
subgroup10_df = pkg.resource('subgroup10').dataframe()
subgroup11_df = pkg.resource('subgroup11').dataframe()
subgroup12_df = pkg.resource('subgroup12').dataframe()
subgroup13_df = pkg.resource('subgroup13').dataframe()
subgroup14_df = pkg.resource('subgroup14').dataframe()
subgroup15_df = pkg.resource('subgroup15').dataframe()
subgroup16_df = pkg.resource('subgroup16').dataframe()