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

Available at noon on release day:

Complete sire list sorted by breed and identification (ID) number
SCR evaluations (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	280,464	36,074,054	Apr 3 2009	All domestic and foreign bulls with official evaluations
38coff.zip	55,805	6,896,827	Apr 3 2009	All bulls except Holsteins and Red & Whites
38off.zip	178,831	26,111,697	Apr 3 2009	Bulls with U.S. daughters OR enrolled with the National Association of Animal Breeders (NAAB)
38ai.zip	68,140	10,309,696	Apr 3 2009	All bulls enrolled with NAAB
38s.zip	3,232	536,714	Apr 3 2009	Bulls enrolled with NAAB, likely to have semen available
^The status codes (explanation of status codes) of all bulls that had active (A) status* after the preceding evaluation are set to inactive (I) 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 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); or limited use (L).

Official bull evaluation files for cow and heifer conception rates (ftp://aipl.arsusda.gov/pub/bulls)
File name¹	Records (no.)	File size (bytes)	Date	Bulls included^*

CRalloff.zip	42,181	1,253,474	Apr 3 2009	All domestic and foreign bulls with official evaluations

Nonofficial bull evaluation files² ( ftp://aipl.arsusda.gov/pub/bulls) Format 38
File name¹	Records (no.)	File size (bytes)	Date	Evaluations included^*

38usnoff.zip	9,490	1,257,924	Apr 3 2009	U.S.-only evaluations for bulls with official Interbull evaluations
38ibnoff.zip	25,328	4,084,776	Apr 3 2009	Interbull evaluations for bulls with official U.S.-only evaluations
38all.trad.zip	178,830	25,776,694	Apr 3 2009	U.S.-only traditional evaluations without genomics for all bulls
^The status codes (explanation of status codes) of all bulls that had active (A) status* after the preceding evaluation are set to inactive (I) 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 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); 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	85,197	Nov 19 2008	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	19,921	2,371,344	Apr 3 2009	Evaluations for elite cows and high-ranking grades based on NM$ percentile
105hi5.zip	101,805	12,173,491	Apr 3 2009	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	4,128	140,839	Apr 3 2009	Herds with elite cows and high-ranking grades based on NM$ percentile
2nhi5.zip³	9,024	292,266	Apr 3 2009	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,270,892	Nov 17 2008	All buck yield evaluations
105G.zip	Format 105	18,620,504	Nov 17 2008	All doe yield evaluations
topbuck		23,560	Nov 12 2008	Top 15% of bucks (for yield) with recent daughters
topdoe		87,444	Nov 12 2008	Top 5% of does (for yield) with recent kiddings
105Gavail.zip	Format 105	935,050	Nov 17 2008	Doe evaluations for all does with recent kiddings
buckname		143,190	Nov 12 2008	Yield evaluations for bucks with recent daughters

f940g.zip	Format 940	983,189	Nov 5 2007	All buck type evaluations
f941g.zip	Format 941	1,777,798	Nov 5 2007	All doe type evaluations

¹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.