Genetic Evaluations of Dairy Animals Available from AIPL

Genetic evaluations available from AIPL

Internet animal queries || Dairy cattle summaries, tables, lists || Dairy goat data tables, lists || Evaluation files || Interim summary files

For detailed information about evaluations including schedules, data exchange formats, and explanation of evaluation calculations, please refer to the Documentations page.

Evaluations available on the AIPL internet site

Publicly available queries for individual cows, bulls, and goats
Queries available to industry cooperators

Dairy cattle evaluation summaries, tables, and lists

Available prior to release day:

Comparison of active AI bull evaluations between this evaluation and the previous release
Percentile tables of net merit (NM$), fluid merit (FM$), and cheese merit (CM$) for bulls and NM$ for cows by breed
Elite cow statistics
Breed means, bases, and heterosis
Genetic and phenotypic trend (1960 to present) by breed for milk, fat, protein, productive life (PL), somatic cell score (SCS), daughter pregnancy rate (DPR), calving ease, and stillbirth
Genetic marker effects from genomic prediction
Comparison of Genomic and Traditional evaluations

Available at noon on release day:

Complete sire list sorted by breed and identification (ID) number
ERCR evaluations (May 2006 - January 2008) (spreadsheet format available)
SCR evaluations (August 2008 - current) (spreadsheet format available)
Elite cow list (registered and grade) sorted by breed and herd code
Holstein high daughters list (Holstein bulls with the most evaluated daughters)
Top sires with official evaluations sorted by NM$, CM$, and FM$ by breed (includes bulls that may not have semen available in the United States; lists for available bulls are available Thursday following release day)
Average evaluations by country of most daughters
Source of top 100 bulls on each country's scale

Available at 1 pm Eastern time on the Thursday following release day:

Bull lists
- Top sires and available sires lists sorted by NM$, CM$, and FM$ by breed
- Active AI, Foreign Available, and Genomically Tested Young Bulls lists
- Status of AI bulls (explanation of status codes)

Genetic evaluation summary [average bull predicted transmitting abilities(PTAs) and standard deviations]

Inbreeding information by breed including:
- Inbreeding coefficients and trends
- Bulls most related to breed
- Bulls least related to breed (outcrosses)

Dairy goat data tables and lists

Goat yield evaluations are updated in July; type evaluations are updated in January

Evaluation files

Bulls · Cows · Herd info · Goats

Bull and cow evaluation files are available for download at 1 pm on the Monday before release but are password protected to allow for download prior to official release

The password for unencrypting the files is available to the public at 7 am on the day of release. See the evaluation schedule for the complete listing of evaluation availability times. A complete description of evaluation distribution is also available.

A mirror site with copies of the evaluation files is available from Dairy Records Management Systems (ftp://ftp.drpc.ncsu.edu).

Official bull evaluation files (ftp://aipl.arsusda.gov/pub/bulls) Format 38
File name¹	Records (no.)	File size (bytes)	Date	Bulls included^*
38alloff.zip	287,611	38,631,002	Jan 21 2010	All domestic and foreign bulls with official evaluations
38coff.zip	57,141	7,263,070	Jan 21 2010	All bulls except Holsteins and Red & Whites
38off.zip	181,674	27,313,680	Jan 21 2010	Bulls with U.S. daughters OR enrolled with the National Association of Animal Breeders (NAAB)
38ai.zip	70,073	11,106,822	Jan 21 2010	All bulls enrolled with NAAB
38s.zip	3,487	597,562	Jan 21 2010	Bulls enrolled with NAAB, likely to have semen available
^The status code* of bulls that had been active (A) status after the preceding evaluation are set to inactive (I) status and the status code of bulls that had been genomically tested (G) status is set to multiherd sampled (P) status because AI status is updated by NAAB after evaluations are released. The status updates are provided in a separate file (status of AI bulls) by NAAB by the Thurday following each evaluation release. This text file includes the ID and status code of all bulls with a status of active (A); foreign-sampled, semen available (F); genomically tested that will be marketed (G); or limited use (L).

Nonofficial bull evaluation files² (ftp://aipl.arsusda.gov/pub/bulls) Format 38
File name¹	Records (no.)	File size (bytes)	Date	Evaluations included^*
38usnoff.zip	10,018	1,417,612	Jan 21 2010	U.S.-only evaluations for bulls with official Interbull evaluations
38ibnoff.zip	26,242	4,414,939	Jan 21 2010	Interbull evaluations for bulls with official U.S.-only evaluations
38all.trad.zip	181,674	26,918,335	Jan 21 2010	U.S.-only traditional evaluations without genomics for all bulls
^The status code* of bulls that had been active (A) status after the preceding evaluation are set to inactive (I) status and the status code of bulls that had been genomically tested (G) status is set to multiherd sampled (P) status because AI status is updated by NAAB after evaluations are released. The status updates are provided in a separate file (status of AI bulls) by NAAB by the Thurday following each evaluation release. This text file includes the ID and status code of all bulls with a status of active (A); foreign-sampled, semen available (F); genomically tested that will be marketed (G); or limited use (L).

Interim summary files (ftp://aipl.arsusda.gov/pub/bulls) Format 38
File Name¹	Records (no.)	File size (bytes)	Date	Summaries Included^*
38i.zip	1,147	96,986	Nov 16 2009	Interim summaries for progeny-test bulls
38i.B07.xml	1,147	1,141,846	Nov 21 2007	Interim summaries for progeny-test bulls (XML)
38i.B07.xls	1,147	539,136	Nov 21 2007	Interim summaries for progeny-test bulls (spreadsheet .xls)
^*Based on first-lactation records of cows in herds with progeny-test daughters during the latest 18 months.

Official cow evaluation files (ftp://aipl.arsusda.gov/pub/cows) Format 105
File name¹	Records (no.)	File size (bytes)	Date	Evaluations included
105el.zip	22,545	2,586,642	Jan 11 2010	Evaluations for elite cows and high-ranking grades based on NM$ percentile
105hi5.zip	107,119	12,659,264	Jan 11 2010	Evaluations for the top 5% of cows based on NM$ (registered and grade)

Herd-owner names and addresses (ftp://aipl.arsusda.gov/pub/cows) Format 2
File Name¹	Records (no.)	File size (bytes)	Date	Herds included
2nel.zip	3,999	137,681	Jan 11 2010	Herds with elite cows and high-ranking grades based on NM$ percentile
2nhi5.zip³	8,608	280,869	Jan 11 2010	Herds for the top 5% of cows based on NM$ (registered and grade)

*Goat yield evaluations are updated in July; type evaluations are updated in January* Sign up to receive e-mail notification of file updates
Goat evaluation files (ftp://aipl.arsusda.gov/pub/adga)
File name¹	File format	File size (bytes)	Date	File description
38G.zip	Format 38	1,315,256	Nov 19 2009	All buck yield evaluations
105G.zip	Format 105	18,963,820	Nov 19 2009	All doe yield evaluations
topbuck		23,037	Nov 14 2009	Top 15% of bucks (for yield) with recent daughters
topdoe		83,630	Nov 14 2009	Top 5% of does (for yield) with recent kiddings
105Gavail.zip	Format 105	890,534	Nov 19 2009	Doe evaluations for all does with recent kiddings
buckname		137,826	Nov 14 2009	Yield evaluations for bucks with recent daughters

¹Compressed (zipped) files have .zip extension. Uncompressed files have the extension .myy where m is the month (Nov=B) and yy the year of the evaluation (e.g., B02 indicates November, 2002).

²For bulls with both a U.S.-only and an Interbull evaluation available, the Interbull evaluation is official if it includes data from an additional country or if Interbull excludes U.S. data but has higher reliability than the U.S.-only evaluation.

³Password administered by National Dairy Herd Improvement Association.