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
Comparison of genomic young 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
Elite cows for NM$ sorted by breed and herd code
High-ranking grade cows for NM$ sorted by breed and herd code
Elite heifers for NM$
High-ranking grade heifers for NM$
Top sires with official evaluations sorted by NM$, CM$, and FM$ by breed
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
- SCR evaluations (August 2008 - current) (spreadsheet format available)
- 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)

Discontinued reports from prior runs:

ERCR evaluations (May 2006 - January 2008) (spreadsheet format available)

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 Friday 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	361,708	50,137,067	Apr 9 2013	All domestic and foreign bulls with official evaluations
38coff.zip	67,636	9,222,727	Apr 5 2013	All bulls except Holsteins and Red & Whites
38off.zip	250,949	37,280,418	Apr 5 2013	Bulls with U.S. daughters OR enrolled with the National Association of Animal Breeders (NAAB)
38ai.zip	78,703	13,454,882	Apr 5 2013	All bulls enrolled with NAAB
38s.zip	2,559	491,205	Apr 5 2013	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	25,399	3,377,531	Apr 5 2013	U.S.-only evaluations for bulls with official Interbull evaluations
38ibnoff.zip	29,754	5,390,722	Apr 5 2013	Interbull evaluations for bulls with official U.S.-only evaluations
38all.trad.zip	194,024	30,787,072	Apr 5 2013	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	789	61,935	Jan 16 2013	Interim summaries for progeny-test bulls
38i.113.xml	795	529,762	Jan 16 2013	Interim summaries for progeny-test bulls (XML)
38i.113.xlsx	754	202,834	Jan 16 2013	Interim summaries for progeny-test bulls (spreadsheet .xlsx)
^*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	67,068	6,821,792	Apr 5 2013	Evaluations for elite cows and high-ranking grades based on NM$ percentile
105hi5.zip	204,973	23,007,611	Apr 5 2013	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,769	129,691	Apr 5 2013	Herds with elite cows and high-ranking grades based on NM$ percentile
2nhi5.zip³	7,467	246,023	Apr 5 2013	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
f941.zip	Format 941	2,301,309	Nov 27 2012	941 doe
f940.zip	Format 940s	499,947	Nov 27 2012	940 buck
38G.zip	Format 38	1,389,220	Nov 27 2012	All buck yield evaluations
105G.zip	Format 105	20,520,900	Nov 27 2012	All doe yield evaluations
topbuck		23,815	Nov 10 2012	Top 15% of bucks (for yield) with recent daughters
topdoe		90,284	Nov 10 2012	Top 5% of does (for yield) with recent kiddings
105Gavail.zip	Format 105	992,201	Nov 27 2012	Doe evaluations for all does with recent kiddings
buckname		139,655	Nov 10 2012	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.