Baselight
Sign In

Data From: Changes In Genetic Selection Differentials And Generation Intervals In US Holstein Dairy Cattle As A Result Of Genomic Selection

Department of Agriculture

@usgov.usda_gov_data_from_changes_in_genetic_selection_differ_5130dc38

Loading...
Loading...

About this Dataset

Data From: Changes In Genetic Selection Differentials And Generation Intervals In US Holstein Dairy Cattle As A Result Of Genomic Selection

Aggregate means for six traits (milk, fat, and protein yields, somatic cell score, length of productive life, and daughter pregnancy rate)

Resources in this dataset:

  • Resource Title: Holstein Milk Yield.

File Name: HO_M.csv

Resource Description: Aggregate means of Holstein predicted breeding values for milk yield and birth dates

  • Resource Title: Holstein Fat Yield.

File Name: HO_f.csv

Resource Description: Aggregate means of Holstein predicted breeding values for fat yield and birth dates

  • Resource Title: Holstein Protein Yield.

File Name: HO_p.csv

Resource Description: Aggregate means of Holstein predicted breeding values for protein yield and birth dates

  • Resource Title: Holstein Somatic Cell Score.

File Name: HO_scs.csv

Resource Description: Aggregate means of Holstein predicted breeding values for somatic cell score and birth dates

  • Resource Title: Holstein Productive Life.

File Name: HO_pl.csv

Resource Description: Aggregate means of Holstein predicted breeding values for productive life and birth dates

  • Resource Title: Holstein Daughter Pregnancy Rate.

File Name: HO_DPR.csv

Resource Description: Aggregate means of Holstein predicted breeding values for daughter pregnancy rate and birth dates

  • Resource Title: Data Dictionary.

File Name: data_dictionary.csv

Resource Description: Defines variables / sub-components with examples as used in column headers. Filenames:

* Holstein Productive Life: HO_pl.csv
* Holstein Daughter Pregnancy Rate: HO_DPR.csv
* Holstein Somatic Cell Score: HO_scs.csv
* Holstein Protein Yield: HO_p.csv
* Holstein Fat Yield: HO_f.csv
* Holstein Milk Yield: HO_M.csv

Organization: Department of Agriculture
Last updated: 2024-03-30T11:10:52.861705
Tags: ars, bulls, cows, dairy-cattle, data-gov, genetic-improvement, genetic-traits, genetic-trend, heritability, holstein, marker-assisted-selection, milk, np101, sires

Tables

Data Dictionary

@usgov.usda_gov_data_from_changes_in_genetic_selection_differ_5130dc38.data_dictionary
  • 8.42 KB
  • 36 rows
  • 8 columns
Loading... 

CREATE TABLE data_dictionary (
  "data_files_that_contain_the_variable_sub_component" VARCHAR,
  "variable_sub_component" VARCHAR,
  "definition_example_col_header" VARCHAR,
  "data_type_of_col_variable" VARCHAR,
  "character_length" BIGINT,
  "accepted_values" VARCHAR,
  "required" VARCHAR,
  "accepts_null_value" VARCHAR
);

HO DPR

@usgov.usda_gov_data_from_changes_in_genetic_selection_differ_5130dc38.ho_dpr
  • 138.96 KB
  • 41 rows
  • 132 columns
Loading... 

CREATE TABLE ho_dpr (
  "yob1" BIGINT,
  "w_ho_pta_dpr_sb" VARCHAR,
  "uw_ho_pta_dpr_sb" VARCHAR,
  "t_w_ho_pta_dpr_sb" VARCHAR,
  "t_uw_ho_pta_dpr_sb" VARCHAR,
  "ho_ptadpr_regcow_1" DOUBLE,
  "w_ho_sd_dpr_sb" VARCHAR,
  "w_by1_ho_sd_dpr_sb" VARCHAR,
  "uw_ho_sd_dpr_sb" VARCHAR,
  "uw_by1_ho_sd_dpr_sb" VARCHAR,
  "t_w_ho_sd_dpr_sb" VARCHAR,
  "t_uw_ho_sd_dpr_sb" VARCHAR,
  "w_by1_ho_pta_dpr_sb" VARCHAR,
  "ho_ptadpr_regcow_4" DOUBLE,
  "w_ho_rel_dpr_sb" VARCHAR,
  "uw_ho_rel_dpr_sb" VARCHAR,
  "t_w_ho_rel_dpr_sb" VARCHAR,
  "t_uw_ho_rel_dpr_sb" VARCHAR,
  "w_by1_ho_rel_dpr_sb" VARCHAR,
  "w_ho_num_pta_sb" VARCHAR,
  "uw_ho_num_pta_sb" VARCHAR,
  "t_w_ho_num_pta_sb" VARCHAR,
  "t_uw_ho_num_pta_sb" VARCHAR,
  "w_by1_ho_num_pta_sb" VARCHAR,
  "yob2" BIGINT,
  "w_ho_pta_dpr_sc" VARCHAR,
  "uw_ho_pta_dpr_sc" VARCHAR,
  "t_w_ho_pta_dpr_sc" VARCHAR,
  "t_uw_ho_pta_dpr_sc" VARCHAR,
  "ho_ptadpr_regcow_2" DOUBLE,
  "w_ho_sd_dpr_sc" VARCHAR,
  "w_by1_ho_sd_dpr_sc" DOUBLE,
  "uw_ho_sd_dpr_sc" VARCHAR,
  "uw_by1_ho_sd_dpr_sc" VARCHAR,
  "t_w_ho_sd_dpr_sc" VARCHAR,
  "t_uw_ho_sd_dpr_sc" VARCHAR,
  "w_by1_ho_pta_dpr_sc" DOUBLE,
  "ho_ptadpr_regcow_5" DOUBLE,
  "w_ho_rel_dpr_sc" VARCHAR,
  "uw_ho_rel_dpr_sc" VARCHAR,
  "t_w_ho_rel_dpr_sc" VARCHAR,
  "t_uw_ho_rel_dpr_sc" VARCHAR,
  "w_by1_ho_rel_dpr_sc" DOUBLE,
  "w_ho_num_pta_sc" VARCHAR,
  "uw_ho_num_pta_sc" VARCHAR,
  "t_w_ho_num_pta_sc" VARCHAR,
  "t_uw_ho_num_pta_sc" VARCHAR,
  "w_by1_ho_num_pta_sc" BIGINT,
  "yob3" BIGINT,
  "w_ho_pta_dpr_db" VARCHAR,
  "uw_ho_pta_dpr_db" VARCHAR,
  "t_w_ho_pta_dpr_db" VARCHAR,
  "t_uw_ho_pta_dpr_db" VARCHAR,
  "ho_ptadpr_regcow_3" DOUBLE,
  "w_ho_sd_dpr_db" VARCHAR,
  "w_by1_ho_sd_dpr_db" VARCHAR,
  "uw_ho_sd_dpr_db" VARCHAR,
  "uw_by1_ho_sd_dpr_db" VARCHAR,
  "t_w_ho_sd_dpr_db" VARCHAR,
  "t_uw_ho_sd_dpr_db" VARCHAR,
  "w_by1_ho_pta_dpr_db" VARCHAR,
  "ho_ptadpr_regcow_6" DOUBLE,
  "w_ho_rel_dpr_db" VARCHAR,
  "uw_ho_rel_dpr_db" VARCHAR,
  "t_w_ho_rel_dpr_db" VARCHAR,
  "t_uw_ho_rel_dpr_db" VARCHAR,
  "w_by1_ho_rel_dpr_db" VARCHAR,
  "w_ho_num_pta_db" VARCHAR,
  "uw_ho_num_pta_db" VARCHAR,
  "t_w_ho_num_pta_db" VARCHAR,
  "t_uw_ho_num_pta_db" VARCHAR,
  "w_by1_ho_num_pta_db" VARCHAR,
  "yob4" BIGINT,
  "w_ho_pta_dpr_dc" VARCHAR,
  "uw_ho_pta_dpr_dc" VARCHAR,
  "t_w_ho_pta_dpr_dc" VARCHAR,
  "t_uw_ho_pta_dpr_dc" VARCHAR,
  "ho_ptadpr_allcow_1" DOUBLE,
  "w_ho_sd_dpr_dc" VARCHAR,
  "w_by1_ho_sd_dpr_dc" DOUBLE,
  "uw_ho_sd_dpr_dc" VARCHAR,
  "uw_by1_ho_sd_dpr_dc" DOUBLE,
  "t_w_ho_sd_dpr_dc" VARCHAR,
  "t_uw_ho_sd_dpr_dc" VARCHAR,
  "w_by1_ho_pta_dpr_dc" DOUBLE,
  "ho_ptadpr_allcow_2" DOUBLE,
  "w_ho_rel_dpr_dc" VARCHAR,
  "uw_ho_rel_dpr_dc" VARCHAR,
  "t_w_ho_rel_dpr_dc" VARCHAR,
  "t_uw_ho_rel_dpr_dc" VARCHAR,
  "w_by1_ho_rel_dpr_dc" DOUBLE,
  "w_ho_num_pta_dc" VARCHAR,
  "uw_ho_num_pta_dc" VARCHAR,
  "t_w_ho_num_pta_dc" VARCHAR,
  "t_uw_ho_num_pta_dc" VARCHAR,
  "w_by1_ho_num_pta_dc" BIGINT,
  "yob5" BIGINT,
  "w_by1_ho_sd_dpr_sb_1" VARCHAR,
  "w_by1_ho_sd_dpr_sc_1" DOUBLE,
  "w_by1_ho_sd_dpr_db_1" VARCHAR
);

HO F

@usgov.usda_gov_data_from_changes_in_genetic_selection_differ_5130dc38.ho_f
  • 138.77 KB
  • 41 rows
  • 132 columns
Loading... 

CREATE TABLE ho_f (
  "yob1" BIGINT,
  "w_ho_pta_f_sb" VARCHAR,
  "uw_ho_pta_f_sb" VARCHAR,
  "t_w_ho_pta_f_sb" VARCHAR,
  "t_uw_ho_pta_f_sb" VARCHAR,
  "ho_ptaf_regcow_1" DOUBLE,
  "w_ho_sd_f_sb" VARCHAR,
  "w_by1_ho_sd_f_sb" VARCHAR,
  "uw_ho_sd_f_sb" VARCHAR,
  "uw_by1_ho_sd_f_sb" VARCHAR,
  "t_w_ho_sd_f_sb" VARCHAR,
  "t_uw_ho_sd_f_sb" VARCHAR,
  "w_by1_ho_pta_f_sb" VARCHAR,
  "ho_ptaf_regcow_4" DOUBLE,
  "w_ho_rel_f_sb" VARCHAR,
  "uw_ho_rel_f_sb" VARCHAR,
  "t_w_ho_rel_f_sb" VARCHAR,
  "t_uw_ho_rel_f_sb" VARCHAR,
  "w_by1_ho_rel_f_sb" VARCHAR,
  "w_ho_num_pta_sb" VARCHAR,
  "uw_ho_num_pta_sb" VARCHAR,
  "t_w_ho_num_pta_sb" VARCHAR,
  "t_uw_ho_num_pta_sb" VARCHAR,
  "w_by1_ho_num_pta_sb" VARCHAR,
  "yob2" BIGINT,
  "w_ho_pta_f_sc" VARCHAR,
  "uw_ho_pta_f_sc" VARCHAR,
  "t_w_ho_pta_f_sc" VARCHAR,
  "t_uw_ho_pta_f_sc" VARCHAR,
  "ho_ptaf_regcow_2" DOUBLE,
  "w_ho_sd_f_sc" VARCHAR,
  "w_by1_ho_sd_f_sc" DOUBLE,
  "uw_ho_sd_f_sc" VARCHAR,
  "uw_by1_ho_sd_f_sc" VARCHAR,
  "t_w_ho_sd_f_sc" VARCHAR,
  "t_uw_ho_sd_f_sc" VARCHAR,
  "w_by1_ho_pta_f_sc" DOUBLE,
  "ho_ptaf_regcow_5" DOUBLE,
  "w_ho_rel_f_sc" VARCHAR,
  "uw_ho_rel_f_sc" VARCHAR,
  "t_w_ho_rel_f_sc" VARCHAR,
  "t_uw_ho_rel_f_sc" VARCHAR,
  "w_by1_ho_rel_f_sc" DOUBLE,
  "w_ho_num_pta_sc" VARCHAR,
  "uw_ho_num_pta_sc" VARCHAR,
  "t_w_ho_num_pta_sc" VARCHAR,
  "t_uw_ho_num_pta_sc" VARCHAR,
  "w_by1_ho_num_pta_sc" BIGINT,
  "yob3" BIGINT,
  "w_ho_pta_f_db" VARCHAR,
  "uw_ho_pta_f_db" VARCHAR,
  "t_w_ho_pta_f_db" VARCHAR,
  "t_uw_ho_pta_f_db" VARCHAR,
  "ho_ptaf_regcow_3" DOUBLE,
  "w_ho_sd_f_db" VARCHAR,
  "w_by1_ho_sd_f_db" VARCHAR,
  "uw_ho_sd_f_db" VARCHAR,
  "uw_by1_ho_sd_f_db" VARCHAR,
  "t_w_ho_sd_f_db" VARCHAR,
  "t_uw_ho_sd_f_db" VARCHAR,
  "w_by1_ho_pta_f_db" VARCHAR,
  "ho_ptaf_regcow_6" DOUBLE,
  "w_ho_rel_f_db" VARCHAR,
  "uw_ho_rel_f_db" VARCHAR,
  "t_w_ho_rel_f_db" VARCHAR,
  "t_uw_ho_rel_f_db" VARCHAR,
  "w_by1_ho_rel_f_db" VARCHAR,
  "w_ho_num_pta_db" VARCHAR,
  "uw_ho_num_pta_db" VARCHAR,
  "t_w_ho_num_pta_db" VARCHAR,
  "t_uw_ho_num_pta_db" VARCHAR,
  "w_by1_ho_num_pta_db" VARCHAR,
  "yob4" BIGINT,
  "w_ho_pta_f_dc" VARCHAR,
  "uw_ho_pta_f_dc" VARCHAR,
  "t_w_ho_pta_f_dc" VARCHAR,
  "t_uw_ho_pta_f_dc" VARCHAR,
  "ho_ptaf_allcow_1" DOUBLE,
  "w_ho_sd_f_dc" VARCHAR,
  "w_by1_ho_sd_f_dc" DOUBLE,
  "uw_ho_sd_f_dc" VARCHAR,
  "uw_by1_ho_sd_f_dc" DOUBLE,
  "t_w_ho_sd_f_dc" VARCHAR,
  "t_uw_ho_sd_f_dc" VARCHAR,
  "w_by1_ho_pta_f_dc" DOUBLE,
  "ho_ptaf_allcow_2" DOUBLE,
  "w_ho_rel_f_dc" VARCHAR,
  "uw_ho_rel_f_dc" VARCHAR,
  "t_w_ho_rel_f_dc" VARCHAR,
  "t_uw_ho_rel_f_dc" VARCHAR,
  "w_by1_ho_rel_f_dc" DOUBLE,
  "w_ho_num_pta_dc" VARCHAR,
  "uw_ho_num_pta_dc" VARCHAR,
  "t_w_ho_num_pta_dc" VARCHAR,
  "t_uw_ho_num_pta_dc" VARCHAR,
  "w_by1_ho_num_pta_dc" BIGINT,
  "yob5" BIGINT,
  "w_by1_ho_sd_f_sb_1" VARCHAR,
  "w_by1_ho_sd_f_sc_1" DOUBLE,
  "w_by1_ho_sd_f_db_1" VARCHAR
);

HO P

@usgov.usda_gov_data_from_changes_in_genetic_selection_differ_5130dc38.ho_p
  • 138.8 KB
  • 41 rows
  • 132 columns
Loading... 

CREATE TABLE ho_p (
  "yob1" BIGINT,
  "w_ho_pta_p_sb" VARCHAR,
  "uw_ho_pta_p_sb" VARCHAR,
  "t_w_ho_pta_p_sb" VARCHAR,
  "t_uw_ho_pta_p_sb" VARCHAR,
  "ho_ptap_regcow_1" DOUBLE,
  "w_ho_sd_p_sb" VARCHAR,
  "w_by1_ho_sd_p_sb" VARCHAR,
  "uw_ho_sd_p_sb" VARCHAR,
  "uw_by1_ho_sd_p_sb" VARCHAR,
  "t_w_ho_sd_p_sb" VARCHAR,
  "t_uw_ho_sd_p_sb" VARCHAR,
  "w_by1_ho_pta_p_sb" VARCHAR,
  "ho_ptap_regcow_4" DOUBLE,
  "w_ho_rel_p_sb" VARCHAR,
  "uw_ho_rel_p_sb" VARCHAR,
  "t_w_ho_rel_p_sb" VARCHAR,
  "t_uw_ho_rel_p_sb" VARCHAR,
  "w_by1_ho_rel_p_sb" VARCHAR,
  "w_ho_num_pta_sb" VARCHAR,
  "uw_ho_num_pta_sb" VARCHAR,
  "t_w_ho_num_pta_sb" VARCHAR,
  "t_uw_ho_num_pta_sb" VARCHAR,
  "w_by1_ho_num_pta_sb" VARCHAR,
  "yob2" BIGINT,
  "w_ho_pta_p_sc" VARCHAR,
  "uw_ho_pta_p_sc" VARCHAR,
  "t_w_ho_pta_p_sc" VARCHAR,
  "t_uw_ho_pta_p_sc" VARCHAR,
  "ho_ptap_regcow_2" DOUBLE,
  "w_ho_sd_p_sc" VARCHAR,
  "w_by1_ho_sd_p_sc" DOUBLE,
  "uw_ho_sd_p_sc" VARCHAR,
  "uw_by1_ho_sd_p_sc" VARCHAR,
  "t_w_ho_sd_p_sc" VARCHAR,
  "t_uw_ho_sd_p_sc" VARCHAR,
  "w_by1_ho_pta_p_sc" DOUBLE,
  "ho_ptap_regcow_5" DOUBLE,
  "w_ho_rel_p_sc" VARCHAR,
  "uw_ho_rel_p_sc" VARCHAR,
  "t_w_ho_rel_p_sc" VARCHAR,
  "t_uw_ho_rel_p_sc" VARCHAR,
  "w_by1_ho_rel_p_sc" DOUBLE,
  "w_ho_num_pta_sc" VARCHAR,
  "uw_ho_num_pta_sc" VARCHAR,
  "t_w_ho_num_pta_sc" VARCHAR,
  "t_uw_ho_num_pta_sc" VARCHAR,
  "w_by1_ho_num_pta_sc" BIGINT,
  "yob3" BIGINT,
  "w_ho_pta_p_db" VARCHAR,
  "uw_ho_pta_p_db" VARCHAR,
  "t_w_ho_pta_p_db" VARCHAR,
  "t_uw_ho_pta_p_db" VARCHAR,
  "ho_ptap_regcow_3" DOUBLE,
  "w_ho_sd_p_db" VARCHAR,
  "w_by1_ho_sd_p_db" VARCHAR,
  "uw_ho_sd_p_db" VARCHAR,
  "uw_by1_ho_sd_p_db" VARCHAR,
  "t_w_ho_sd_p_db" VARCHAR,
  "t_uw_ho_sd_p_db" VARCHAR,
  "w_by1_ho_pta_p_db" VARCHAR,
  "ho_ptap_regcow_6" DOUBLE,
  "w_ho_rel_p_db" VARCHAR,
  "uw_ho_rel_p_db" VARCHAR,
  "t_w_ho_rel_p_db" VARCHAR,
  "t_uw_ho_rel_p_db" VARCHAR,
  "w_by1_ho_rel_p_db" VARCHAR,
  "w_ho_num_pta_db" VARCHAR,
  "uw_ho_num_pta_db" VARCHAR,
  "t_w_ho_num_pta_db" VARCHAR,
  "t_uw_ho_num_pta_db" VARCHAR,
  "w_by1_ho_num_pta_db" VARCHAR,
  "yob4" BIGINT,
  "w_ho_pta_p_dc" VARCHAR,
  "uw_ho_pta_p_dc" VARCHAR,
  "t_w_ho_pta_p_dc" VARCHAR,
  "t_uw_ho_pta_p_dc" VARCHAR,
  "ho_ptap_allcow_1" DOUBLE,
  "w_ho_sd_p_dc" VARCHAR,
  "w_by1_ho_sd_p_dc" DOUBLE,
  "uw_ho_sd_p_dc" VARCHAR,
  "uw_by1_ho_sd_p_dc" DOUBLE,
  "t_w_ho_sd_p_dc" VARCHAR,
  "t_uw_ho_sd_p_dc" VARCHAR,
  "w_by1_ho_pta_p_dc" DOUBLE,
  "ho_ptap_allcow_2" DOUBLE,
  "w_ho_rel_p_dc" VARCHAR,
  "uw_ho_rel_p_dc" VARCHAR,
  "t_w_ho_rel_p_dc" VARCHAR,
  "t_uw_ho_rel_p_dc" VARCHAR,
  "w_by1_ho_rel_p_dc" DOUBLE,
  "w_ho_num_pta_dc" VARCHAR,
  "uw_ho_num_pta_dc" VARCHAR,
  "t_w_ho_num_pta_dc" VARCHAR,
  "t_uw_ho_num_pta_dc" VARCHAR,
  "w_by1_ho_num_pta_dc" BIGINT,
  "yob5" BIGINT,
  "w_by1_ho_sd_p_sb_1" VARCHAR,
  "w_by1_ho_sd_p_sc_1" DOUBLE,
  "w_by1_ho_sd_p_db_1" VARCHAR
);

HO Pl

@usgov.usda_gov_data_from_changes_in_genetic_selection_differ_5130dc38.ho_pl
  • 137.72 KB
  • 41 rows
  • 132 columns
Loading... 

CREATE TABLE ho_pl (
  "yob1" BIGINT,
  "w_ho_pta_pl_sb" VARCHAR,
  "uw_ho_pta_pl_sb" VARCHAR,
  "t_w_ho_pta_pl_sb" VARCHAR,
  "t_uw_ho_pta_pl_sb" VARCHAR,
  "ho_ptapl_regcow_1" DOUBLE,
  "w_ho_sd_pl_sb" VARCHAR,
  "w_by1_ho_sd_pl_sb" VARCHAR,
  "uw_ho_sd_pl_sb" VARCHAR,
  "uw_by1_ho_sd_pl_sb" VARCHAR,
  "t_w_ho_sd_pl_sb" VARCHAR,
  "t_uw_ho_sd_pl_sb" VARCHAR,
  "w_by1_ho_pta_pl_sb" VARCHAR,
  "ho_ptapl_regcow_4" DOUBLE,
  "w_ho_rel_pl_sb" VARCHAR,
  "uw_ho_rel_pl_sb" VARCHAR,
  "t_w_ho_rel_pl_sb" VARCHAR,
  "t_uw_ho_rel_pl_sb" VARCHAR,
  "w_by1_ho_rel_pl_sb" VARCHAR,
  "w_ho_num_pta_sb" VARCHAR,
  "uw_ho_num_pta_sb" VARCHAR,
  "t_w_ho_num_pta_sb" VARCHAR,
  "t_uw_ho_num_pta_sb" VARCHAR,
  "w_by1_ho_num_pta_sb" VARCHAR,
  "yob2" BIGINT,
  "w_ho_pta_pl_sc" VARCHAR,
  "uw_ho_pta_pl_sc" VARCHAR,
  "t_w_ho_pta_pl_sc" VARCHAR,
  "t_uw_ho_pta_pl_sc" VARCHAR,
  "ho_ptapl_regcow_2" DOUBLE,
  "w_ho_sd_pl_sc" VARCHAR,
  "w_by1_ho_sd_pl_sc" DOUBLE,
  "uw_ho_sd_pl_sc" VARCHAR,
  "uw_by1_ho_sd_pl_sc" VARCHAR,
  "t_w_ho_sd_pl_sc" VARCHAR,
  "t_uw_ho_sd_pl_sc" VARCHAR,
  "w_by1_ho_pta_pl_sc" DOUBLE,
  "ho_ptapl_regcow_5" DOUBLE,
  "w_ho_rel_pl_sc" VARCHAR,
  "uw_ho_rel_pl_sc" VARCHAR,
  "t_w_ho_rel_pl_sc" VARCHAR,
  "t_uw_ho_rel_pl_sc" VARCHAR,
  "w_by1_ho_rel_pl_sc" DOUBLE,
  "w_ho_num_pta_sc" VARCHAR,
  "uw_ho_num_pta_sc" VARCHAR,
  "t_w_ho_num_pta_sc" VARCHAR,
  "t_uw_ho_num_pta_sc" VARCHAR,
  "w_by1_ho_num_pta_sc" BIGINT,
  "yob3" BIGINT,
  "w_ho_pta_pl_db" VARCHAR,
  "uw_ho_pta_pl_db" VARCHAR,
  "t_w_ho_pta_pl_db" VARCHAR,
  "t_uw_ho_pta_pl_db" VARCHAR,
  "ho_ptapl_regcow_3" DOUBLE,
  "w_ho_sd_pl_db" VARCHAR,
  "w_by1_ho_sd_pl_db" VARCHAR,
  "uw_ho_sd_pl_db" VARCHAR,
  "uw_by1_ho_sd_pl_db" VARCHAR,
  "t_w_ho_sd_pl_db" VARCHAR,
  "t_uw_ho_sd_pl_db" VARCHAR,
  "w_by1_ho_pta_pl_db" VARCHAR,
  "ho_ptapl_regcow_6" DOUBLE,
  "w_ho_rel_pl_db" VARCHAR,
  "uw_ho_rel_pl_db" VARCHAR,
  "t_w_ho_rel_pl_db" VARCHAR,
  "t_uw_ho_rel_pl_db" VARCHAR,
  "w_by1_ho_rel_pl_db" VARCHAR,
  "w_ho_num_pta_db" VARCHAR,
  "uw_ho_num_pta_db" VARCHAR,
  "t_w_ho_num_pta_db" VARCHAR,
  "t_uw_ho_num_pta_db" VARCHAR,
  "w_by1_ho_num_pta_db" VARCHAR,
  "yob4" BIGINT,
  "w_ho_pta_pl_dc" VARCHAR,
  "uw_ho_pta_pl_dc" VARCHAR,
  "t_w_ho_pta_pl_dc" VARCHAR,
  "t_uw_ho_pta_pl_dc" VARCHAR,
  "ho_ptapl_allcow_1" DOUBLE,
  "w_ho_sd_pl_dc" VARCHAR,
  "w_by1_ho_sd_pl_dc" DOUBLE,
  "uw_ho_sd_pl_dc" VARCHAR,
  "uw_by1_ho_sd_pl_dc" DOUBLE,
  "t_w_ho_sd_pl_dc" VARCHAR,
  "t_uw_ho_sd_pl_dc" VARCHAR,
  "w_by1_ho_pta_pl_dc" DOUBLE,
  "ho_ptapl_allcow_2" DOUBLE,
  "w_ho_rel_pl_dc" VARCHAR,
  "uw_ho_rel_pl_dc" VARCHAR,
  "t_w_ho_rel_pl_dc" VARCHAR,
  "t_uw_ho_rel_pl_dc" VARCHAR,
  "w_by1_ho_rel_pl_dc" DOUBLE,
  "w_ho_num_pta_dc" VARCHAR,
  "uw_ho_num_pta_dc" VARCHAR,
  "t_w_ho_num_pta_dc" VARCHAR,
  "t_uw_ho_num_pta_dc" VARCHAR,
  "w_by1_ho_num_pta_dc" BIGINT,
  "yob5" BIGINT,
  "w_by1_ho_sd_pl_sb_1" VARCHAR,
  "w_by1_ho_sd_pl_sc_1" DOUBLE,
  "w_by1_ho_sd_pl_db_1" VARCHAR
);

HO Scs

@usgov.usda_gov_data_from_changes_in_genetic_selection_differ_5130dc38.ho_scs
  • 136.04 KB
  • 41 rows
  • 132 columns
Loading... 

CREATE TABLE ho_scs (
  "yob1" BIGINT,
  "w_ho_pta_scs_sb" VARCHAR,
  "uw_ho_pta_scs_sb" VARCHAR,
  "t_w_ho_pta_scs_sb" VARCHAR,
  "t_uw_ho_pta_scs_sb" VARCHAR,
  "ho_ptascs_regcow_1" DOUBLE,
  "w_ho_sd_scs_sb" VARCHAR,
  "w_by1_ho_sd_scs_sb" VARCHAR,
  "uw_ho_sd_scs_sb" VARCHAR,
  "uw_by1_ho_sd_scs_sb" VARCHAR,
  "t_w_ho_sd_scs_sb" VARCHAR,
  "t_uw_ho_sd_scs_sb" VARCHAR,
  "w_by1_ho_pta_scs_sb" VARCHAR,
  "ho_ptascs_regcow_4" DOUBLE,
  "w_ho_rel_scs_sb" VARCHAR,
  "uw_ho_rel_scs_sb" VARCHAR,
  "t_w_ho_rel_scs_sb" VARCHAR,
  "t_uw_ho_rel_scs_sb" VARCHAR,
  "w_by1_ho_rel_scs_sb" VARCHAR,
  "w_ho_num_pta_sb" VARCHAR,
  "uw_ho_num_pta_sb" VARCHAR,
  "t_w_ho_num_pta_sb" VARCHAR,
  "t_uw_ho_num_pta_sb" VARCHAR,
  "w_by1_ho_num_pta_sb" VARCHAR,
  "yob2" BIGINT,
  "w_ho_pta_scs_sc" VARCHAR,
  "uw_ho_pta_scs_sc" VARCHAR,
  "t_w_ho_pta_scs_sc" VARCHAR,
  "t_uw_ho_pta_scs_sc" VARCHAR,
  "ho_ptascs_regcow_2" DOUBLE,
  "w_ho_sd_scs_sc" VARCHAR,
  "w_by1_ho_sd_scs_sc" DOUBLE,
  "uw_ho_sd_scs_sc" VARCHAR,
  "uw_by1_ho_sd_scs_sc" VARCHAR,
  "t_w_ho_sd_scs_sc" VARCHAR,
  "t_uw_ho_sd_scs_sc" VARCHAR,
  "w_by1_ho_pta_scs_sc" DOUBLE,
  "ho_ptascs_regcow_5" DOUBLE,
  "w_ho_rel_scs_sc" VARCHAR,
  "uw_ho_rel_scs_sc" VARCHAR,
  "t_w_ho_rel_scs_sc" VARCHAR,
  "t_uw_ho_rel_scs_sc" VARCHAR,
  "w_by1_ho_rel_scs_sc" DOUBLE,
  "w_ho_num_pta_sc" VARCHAR,
  "uw_ho_num_pta_sc" VARCHAR,
  "t_w_ho_num_pta_sc" VARCHAR,
  "t_uw_ho_num_pta_sc" VARCHAR,
  "w_by1_ho_num_pta_sc" BIGINT,
  "yob3" BIGINT,
  "w_ho_pta_scs_db" VARCHAR,
  "uw_ho_pta_scs_db" VARCHAR,
  "t_w_ho_pta_scs_db" VARCHAR,
  "t_uw_ho_pta_scs_db" VARCHAR,
  "ho_ptascs_regcow_3" DOUBLE,
  "w_ho_sd_scs_db" VARCHAR,
  "w_by1_ho_sd_scs_db" VARCHAR,
  "uw_ho_sd_scs_db" VARCHAR,
  "uw_by1_ho_sd_scs_db" VARCHAR,
  "t_w_ho_sd_scs_db" VARCHAR,
  "t_uw_ho_sd_scs_db" VARCHAR,
  "w_by1_ho_pta_scs_db" VARCHAR,
  "ho_ptascs_regcow_6" DOUBLE,
  "w_ho_rel_scs_db" VARCHAR,
  "uw_ho_rel_scs_db" VARCHAR,
  "t_w_ho_rel_scs_db" VARCHAR,
  "t_uw_ho_rel_scs_db" VARCHAR,
  "w_by1_ho_rel_scs_db" VARCHAR,
  "w_ho_num_pta_db" VARCHAR,
  "uw_ho_num_pta_db" VARCHAR,
  "t_w_ho_num_pta_db" VARCHAR,
  "t_uw_ho_num_pta_db" VARCHAR,
  "w_by1_ho_num_pta_db" VARCHAR,
  "yob4" BIGINT,
  "w_ho_pta_scs_dc" VARCHAR,
  "uw_ho_pta_scs_dc" VARCHAR,
  "t_w_ho_pta_scs_dc" VARCHAR,
  "t_uw_ho_pta_scs_dc" VARCHAR,
  "ho_ptascs_allcow_1" DOUBLE,
  "w_ho_sd_scs_dc" VARCHAR,
  "w_by1_ho_sd_scs_dc" DOUBLE,
  "uw_ho_sd_scs_dc" VARCHAR,
  "uw_by1_ho_sd_scs_dc" DOUBLE,
  "t_w_ho_sd_scs_dc" VARCHAR,
  "t_uw_ho_sd_scs_dc" VARCHAR,
  "w_by1_ho_pta_scs_dc" DOUBLE,
  "ho_ptascs_allcow_2" DOUBLE,
  "w_ho_rel_scs_dc" VARCHAR,
  "uw_ho_rel_scs_dc" VARCHAR,
  "t_w_ho_rel_scs_dc" VARCHAR,
  "t_uw_ho_rel_scs_dc" VARCHAR,
  "w_by1_ho_rel_scs_dc" DOUBLE,
  "w_ho_num_pta_dc" VARCHAR,
  "uw_ho_num_pta_dc" VARCHAR,
  "t_w_ho_num_pta_dc" VARCHAR,
  "t_uw_ho_num_pta_dc" VARCHAR,
  "w_by1_ho_num_pta_dc" BIGINT,
  "yob5" BIGINT,
  "w_by1_ho_sd_scs_sb_1" VARCHAR,
  "w_by1_ho_sd_scs_sc_1" DOUBLE,
  "w_by1_ho_sd_scs_db_1" VARCHAR
);

Share link

Anyone who has the link will be able to view this.