Demographics

view: demographics {
  sql_table_name: public.experian ;;

  dimension: address_line_1 {
    sql: ${TABLE}.address_line_1 ;;
  }

  dimension: address_line_2 {
    sql: ${TABLE}.address_line_2 ;;
  }

  dimension: aid {
    type: int
    sql: ${TABLE}.aid ;;
  }

  dimension: ams {
    label: "Number of Hybrid Cars"
    type: number
    sql: ${TABLE}.ams ;;
  }

  dimension: aqi {
    label: "Address Quality"
  }

  dimension: auto_new {
    label: "New Automobile Purchase (next 6 months)"
  }

  dimension: auto_used {
    label: "Used Automobile Purchase (next 6 months)"
  }

  dimension: auto_used0005 {
    label: "Used (0-5 yr old) Automobile Purchase (next 6 months)"
  }

  dimension: auto_used0610 {
    label: "Used (6-10 yr old) Automobile Purchase (next 6 months)"
  }

  dimension: auto_used11up {
    label: "Used (11+ yr old) Automobile Purchase (next 6 months)"
  }

  dimension: bdat_bdat_1 {
    label: "Person 1 Birthdate"
    type: time
    sql: TO_DATE (${TABLE}.bdat_bdat_1, 'YYYYMM') ;;
  }

  dimension: bdat_bdat_2 {
    label: "Person 2 Birthdate"
    type: time
    sql: TO_DATE (${TABLE}.bdat_bdat_2, 'YYYYMM') ;;
  }

  dimension: bdat_bdat_3 {
    label: "Person 3 Birthdate"
    type: time
    sql: TO_DATE (${TABLE}.bdat_bdat_3, 'YYYYMM') ;;
  }

  dimension: bdat_bdat_4 {
    label: "Person 4 Birthdate"
    type: time
    sql: TO_DATE (${TABLE}.bdat_bdat_4, 'YYYYMM') ;;
  }

  dimension: bdat_bdat_5 {
    label: "Person 5 Birthdate"
    type: time
    sql: TO_DATE (${TABLE}.bdat_bdat_5, 'YYYYMM') ;;
  }

  dimension: bdat_bdat_6 {
    label: "Person 6 Birthdate"
    type: time
    sql: TO_DATE (${TABLE}.bdat_bdat_6, 'YYYYMM') ;;
  }

  dimension: bdat_bdat_7 {
    label: "Person 7 Birthdate"
    type: time
    sql: TO_DATE (${TABLE}.bdat_bdat_7, 'YYYYMM') ;;
  }

  dimension: bdat_bdat_8 {
    label: "Person 8 Birthdate"
    type: time
    sql: TO_DATE (${TABLE}.bdat_bdat_8, 'YYYYMM') ;;
  }

  dimension: biz_owner_1 {
    sql: ${TABLE}.biz_owner_1 ;;
  }

  dimension: biz_owner_2 {
    sql: ${TABLE}.biz_owner_2 ;;
  }

  dimension: biz_owner_3 {
    sql: ${TABLE}.biz_owner_3 ;;
  }

  dimension: biz_owner_4 {
    sql: ${TABLE}.biz_owner_4 ;;
  }

  dimension: biz_owner_5 {
    sql: ${TABLE}.biz_owner_5 ;;
  }

  dimension: biz_owner_6 {
    sql: ${TABLE}.biz_owner_6 ;;
  }

  dimension: biz_owner_7 {
    sql: ${TABLE}.biz_owner_7 ;;
  }

  dimension: biz_owner_8 {
    sql: ${TABLE}.biz_owner_8 ;;
  }

  dimension: cape_hh_sz {
    type: number
    sql: ${TABLE}.cape_hh_sz ;;
  }

  dimension: cape_medage {
    type: number
    sql: ${TABLE}.cape_medage ;;
  }

  dimension: cape_mededu {
    type: number
    sql: ${TABLE}.cape_mededu ;;
  }

  dimension: cape_medhua {
    type: number
    sql: ${TABLE}.cape_medhua ;;
  }

  dimension: cape_medhv {
    type: int
    sql: ${TABLE}.cape_medhv ;;
  }

  dimension: cape_mfhi {
    type: int
    sql: ${TABLE}.cape_mfhi ;;
  }

  dimension: cape_perc_017 {
    type: number
    sql: ${TABLE}.cape_perc_017 ;;
  }

  dimension: cape_perc_1899 {
    type: number
    sql: ${TABLE}.cape_perc_1899 ;;
  }

  dimension: cape_perc_6599 {
    type: number
    sql: ${TABLE}.cape_perc_6599 ;;
  }

  dimension: cape_perc_asn {
    type: number
    sql: ${TABLE}.cape_perc_asn ;;
  }

  dimension: cape_perc_blk {
    type: number
    sql: ${TABLE}.cape_perc_blk ;;
  }

  dimension: cape_perc_fam_chld {
    type: number
    sql: ${TABLE}.cape_perc_fam_chld ;;
  }

  dimension: cape_perc_fam_nochld {
    type: number
    sql: ${TABLE}.cape_perc_fam_nochld ;;
  }

  dimension: cape_perc_his {
    type: number
    sql: ${TABLE}.cape_perc_his ;;
  }

  dimension: cape_perc_lt18 {
    type: number
    sql: ${TABLE}.cape_perc_lt18 ;;
  }

  dimension: cape_perc_mobile {
    type: number
    sql: ${TABLE}.cape_perc_mobile ;;
  }

  dimension: cape_perc_mrdcpl {
    type: number
    sql: ${TABLE}.cape_perc_mrdcpl ;;
  }

  dimension: cape_perc_occ {
    type: number
    sql: ${TABLE}.cape_perc_occ ;;
  }

  dimension: cape_perc_rent {
    type: number
    sql: ${TABLE}.cape_perc_rent ;;
  }

  dimension: cape_perc_spnspk {
    type: number
    sql: ${TABLE}.cape_perc_spnspk ;;
  }

  dimension: cape_perc_wht {
    type: number
    sql: ${TABLE}.cape_perc_wht ;;
  }

  dimension: cape_pph {
    type: number
    sql: ${TABLE}.cape_pph ;;
  }

  dimension: cbsa {
    sql: ${TABLE}.cbsa ;;
  }

  dimension: cbsa_type {
    sql: ${TABLE}.cbsa_type ;;
  }

  dimension: census_bg {
    sql: ${TABLE}.census_bg ;;
  }

  dimension: census_id {
    sql: ${TABLE}.census_id ;;
  }

  dimension: census_trt {
    sql: ${TABLE}.census_trt ;;
  }

  dimension: city_cnab {
    sql: ${TABLE}.city_cnab ;;
  }

  dimension: city_plac {
    label: "City"
    sql: ${TABLE}.city_plac ;;
  }

  dimension: cnty_2000 {
    type: number
    sql: ${TABLE}.cnty_2000 ;;
  }

  dimension: combined_age_1 {
    sql: ${TABLE}.combined_age_1 ;;
  }

  dimension: combined_age_2 {
    sql: ${TABLE}.combined_age_2 ;;
  }

  dimension: combined_age_3 {
    sql: ${TABLE}.combined_age_3 ;;
  }

  dimension: combined_age_4 {
    sql: ${TABLE}.combined_age_4 ;;
  }

  dimension: combined_age_5 {
    sql: ${TABLE}.combined_age_5 ;;
  }

  dimension: combined_age_6 {
    sql: ${TABLE}.combined_age_6 ;;
  }

  dimension: combined_age_7 {
    sql: ${TABLE}.combined_age_7 ;;
  }

  dimension: combined_age_8 {
    sql: ${TABLE}.combined_age_8 ;;
  }

  dimension: conf_flag {
    label: "Year Built Confidence"
    sql: ${TABLE}.conf_flag ;;
  }

  dimension: countyname {
    sql: ${TABLE}.countyname ;;
  }

  dimension: digdad {
    type: number
    sql: ${TABLE}.digdad ;;
  }

  dimension: digmom {
    type: number
    sql: ${TABLE}.digmom ;;
  }

  dimension: du_size {
    sql: ${TABLE}.du_size ;;
  }

  dimension: dwelling_type {
    sql: ${TABLE}.dwelling_type ;;
  }

  dimension: echv {
    type: int
    sql: ${TABLE}.echv ;;
  }

  dimension: educ_model_1 {
    sql: ${TABLE}.educ_model_1 ;;
  }

  dimension: educ_model_2 {
    sql: ${TABLE}.educ_model_2 ;;
  }

  dimension: educ_model_3 {
    sql: ${TABLE}.educ_model_3 ;;
  }

  dimension: educ_model_4 {
    sql: ${TABLE}.educ_model_4 ;;
  }

  dimension: educ_model_5 {
    sql: ${TABLE}.educ_model_5 ;;
  }

  dimension: educ_model_6 {
    sql: ${TABLE}.educ_model_6 ;;
  }

  dimension: educ_model_7 {
    sql: ${TABLE}.educ_model_7 ;;
  }

  dimension: educ_model_8 {
    sql: ${TABLE}.educ_model_8 ;;
  }

  dimension: filler_1 {
    sql: ${TABLE}.filler_1 ;;
  }

  dimension: filler_10 {
    sql: ${TABLE}.filler_10 ;;
  }

  dimension: filler_11 {
    sql: ${TABLE}.filler_11 ;;
  }

  dimension: filler_12 {
    sql: ${TABLE}.filler_12 ;;
  }

  dimension: filler_13 {
    sql: ${TABLE}.filler_13 ;;
  }

  dimension: filler_14 {
    sql: ${TABLE}.filler_14 ;;
  }

  dimension: filler_15 {
    sql: ${TABLE}.filler_15 ;;
  }

  dimension: filler_17 {
    sql: ${TABLE}.filler_17 ;;
  }

  dimension: filler_18 {
    sql: ${TABLE}.filler_18 ;;
  }

  dimension: filler_19 {
    sql: ${TABLE}.filler_19 ;;
  }

  dimension: filler_2 {
    sql: ${TABLE}.filler_2 ;;
  }

  dimension: filler_20 {
    sql: ${TABLE}.filler_20 ;;
  }

  dimension: filler_21 {
    sql: ${TABLE}.filler_21 ;;
  }

  dimension: filler_22 {
    sql: ${TABLE}.filler_22 ;;
  }

  dimension: filler_23 {
    sql: ${TABLE}.filler_23 ;;
  }

  dimension: filler_24 {
    sql: ${TABLE}.filler_24 ;;
  }

  dimension: filler_25 {
    sql: ${TABLE}.filler_25 ;;
  }

  dimension: filler_26 {
    sql: ${TABLE}.filler_26 ;;
  }

  dimension: filler_27 {
    sql: ${TABLE}.filler_27 ;;
  }

  dimension: filler_28 {
    sql: ${TABLE}.filler_28 ;;
  }

  dimension: filler_3 {
    sql: ${TABLE}.filler_3 ;;
  }

  dimension: filler_3a {
    sql: ${TABLE}.filler_3a ;;
  }

  dimension: filler_3b {
    sql: ${TABLE}.filler_3b ;;
  }

  dimension: filler_3c {
    sql: ${TABLE}.filler_3c ;;
  }

  dimension: filler_3d {
    sql: ${TABLE}.filler_3d ;;
  }

  dimension: filler_4b {
    sql: ${TABLE}.filler_4b ;;
  }

  dimension: filler_6a {
    sql: ${TABLE}.filler_6a ;;
  }

  dimension: filler_6b {
    sql: ${TABLE}.filler_6b ;;
  }

  dimension: filler_6c {
    sql: ${TABLE}.filler_6c ;;
  }

  dimension: filler_7 {
    sql: ${TABLE}.filler_7 ;;
  }

  dimension: filler_8 {
    sql: ${TABLE}.filler_8 ;;
  }

  dimension: filler_9 {
    sql: ${TABLE}.filler_9 ;;
  }

  dimension: filler_geo {
    type: number
    sql: ${TABLE}.filler_geo ;;
  }

  dimension: fnam_fnam_1 {
    sql: ${TABLE}.fnam_fnam_1 ;;
  }

  dimension: fnam_fnam_2 {
    sql: ${TABLE}.fnam_fnam_2 ;;
  }

  dimension: fnam_fnam_3 {
    sql: ${TABLE}.fnam_fnam_3 ;;
  }

  dimension: fnam_fnam_4 {
    sql: ${TABLE}.fnam_fnam_4 ;;
  }

  dimension: fnam_fnam_5 {
    sql: ${TABLE}.fnam_fnam_5 ;;
  }

  dimension: fnam_fnam_6 {
    sql: ${TABLE}.fnam_fnam_6 ;;
  }

  dimension: fnam_fnam_7 {
    sql: ${TABLE}.fnam_fnam_7 ;;
  }

  dimension: fnam_fnam_8 {
    sql: ${TABLE}.fnam_fnam_8 ;;
  }

  dimension: geo_level {
    sql: ${TABLE}.geo_level ;;
  }

  dimension: geoc_stat_2000 {
    label: "State Code"
    type: number
    sql: ${TABLE}.geoc_stat_2000 ;;
  }

  dimension: gndr_gndr_1 {
    sql: ${TABLE}.gndr_gndr_1 ;;
  }

  dimension: gndr_gndr_2 {
    sql: ${TABLE}.gndr_gndr_2 ;;
  }

  dimension: gndr_gndr_3 {
    sql: ${TABLE}.gndr_gndr_3 ;;
  }

  dimension: gndr_gndr_4 {
    sql: ${TABLE}.gndr_gndr_4 ;;
  }

  dimension: gndr_gndr_5 {
    sql: ${TABLE}.gndr_gndr_5 ;;
  }

  dimension: gndr_gndr_6 {
    sql: ${TABLE}.gndr_gndr_6 ;;
  }

  dimension: gndr_gndr_7 {
    sql: ${TABLE}.gndr_gndr_7 ;;
  }

  dimension: gndr_gndr_8 {
    sql: ${TABLE}.gndr_gndr_8 ;;
  }

  dimension: green_aware {
  }

  dimension: green_aware_tier {
    type: number
    sql: ${TABLE}.green_aware_tier ;;
  }

  dimension: hbi {
    sql: ${TABLE}.hbi ;;
  }

  dimension: hh_composition_code {
    sql: ${TABLE}.hh_composition_code ;;
  }

  dimension: ho_rent {
    sql: ${TABLE}.ho_rent ;;
  }

  dimension: hop {
    sql: ${TABLE}.hop ;;
  }

  dimension: home_ownership {
  }

  dimension: inc_state_dec {
    type: number
    sql: ${TABLE}.inc_state_dec ;;
  }

  dimension: ispsa {
    type: number
    sql: ${TABLE}.ispsa ;;
  }

  dimension: ispsa_dec {
    type: number
    sql: ${TABLE}.ispsa_dec ;;
  }

  dimension: location {
    type: location
  }

  dimension: latitude {
    type: number
    sql: ${TABLE}.latitude ;;
  }

  dimension: lngth_of_res {
    type: number
    sql: ${TABLE}.lngth_of_res ;;
  }

  dimension: longitude {
    type: number
    sql: ${TABLE}.longitude ;;
  }

  dimension: lu_a_adat {
    label: "Last Activity"
    type: time
    sql: TO_DATE (${TABLE}.lu_a_adat, 'YYYYMMDD') ;;
  }

  dimension: lu_ehi_v5 {
    label: "Household Income"
    sql: ${TABLE}.lu_ehi_v5 ;;
  }

  dimension: lu_ehi_v5_amt {
    type: number
    sql: ${TABLE}.lu_ehi_v5_amt ;;
  }

  dimension: lu_mailresp {
    sql: ${TABLE}.lu_mailresp ;;
  }

  dimension: luid {
    sql: ${TABLE}.luid ;;
  }

  dimension: mnam_mnam_1 {
    sql: ${TABLE}.mnam_mnam_1 ;;
  }

  dimension: mnam_mnam_2 {
    sql: ${TABLE}.mnam_mnam_2 ;;
  }

  dimension: mnam_mnam_3 {
    sql: ${TABLE}.mnam_mnam_3 ;;
  }

  dimension: mnam_mnam_4 {
    sql: ${TABLE}.mnam_mnam_4 ;;
  }

  dimension: mnam_mnam_5 {
    sql: ${TABLE}.mnam_mnam_5 ;;
  }

  dimension: mnam_mnam_6 {
    sql: ${TABLE}.mnam_mnam_6 ;;
  }

  dimension: mnam_mnam_7 {
    sql: ${TABLE}.mnam_mnam_7 ;;
  }

  dimension: mnam_mnam_8 {
    sql: ${TABLE}.mnam_mnam_8 ;;
  }

  dimension: mobj {
    sql: ${TABLE}.mobj ;;
  }

  dimension: mor_bookbuyer {
    type: number
    sql: ${TABLE}.mor_bookbuyer ;;
  }

  dimension: mor_collectibles {
    type: number
    sql: ${TABLE}.mor_collectibles ;;
  }

  dimension: mor_contributor {
    type: number
    sql: ${TABLE}.mor_contributor ;;
  }

  dimension: mor_crafts {
    type: number
    sql: ${TABLE}.mor_crafts ;;
  }

  dimension: mor_culinary {
    type: number
    sql: ${TABLE}.mor_culinary ;;
  }

  dimension: mor_dedupcatcnt {
    type: number
    sql: ${TABLE}.mor_dedupcatcnt ;;
  }

  dimension: mor_doityourself {
    type: number
    sql: ${TABLE}.mor_doityourself ;;
  }

  dimension: mor_familymag {
    type: number
    sql: ${TABLE}.mor_familymag ;;
  }

  dimension: mor_femmag {
    type: number
    sql: ${TABLE}.mor_femmag ;;
  }

  dimension: mor_femmerch {
    type: number
    sql: ${TABLE}.mor_femmerch ;;
  }

  dimension: mor_gardenbuy {
    type: number
    sql: ${TABLE}.mor_gardenbuy ;;
  }

  dimension: mor_gardenmag {
    type: number
    sql: ${TABLE}.mor_gardenmag ;;
  }

  dimension: mor_giftbuyer {
    type: number
    sql: ${TABLE}.mor_giftbuyer ;;
  }

  dimension: mor_healthcontrib {
    type: number
    sql: ${TABLE}.mor_healthcontrib ;;
  }

  dimension: mor_healthmag {
    type: number
    sql: ${TABLE}.mor_healthmag ;;
  }

  dimension: mor_malemag {
    type: number
    sql: ${TABLE}.mor_malemag ;;
  }

  dimension: mor_malemerch {
    type: number
    sql: ${TABLE}.mor_malemerch ;;
  }

  dimension: mor_merchbuyer {
    type: number
    sql: ${TABLE}.mor_merchbuyer ;;
  }

  dimension: mor_misc {
    type: number
    sql: ${TABLE}.mor_misc ;;
  }

  dimension: mor_news_fin {
    type: number
    sql: ${TABLE}.mor_news_fin ;;
  }

  dimension: mor_nondedupcnt {
    type: number
    sql: ${TABLE}.mor_nondedupcnt ;;
  }

  dimension: mor_odds_ends {
    type: number
    sql: ${TABLE}.mor_odds_ends ;;
  }

  dimension: mor_opportunity {
    type: number
    sql: ${TABLE}.mor_opportunity ;;
  }

  dimension: mor_photo {
    type: number
    sql: ${TABLE}.mor_photo ;;
  }

  dimension: mor_polcontrib {
    type: number
    sql: ${TABLE}.mor_polcontrib ;;
  }

  dimension: mor_religcontrib {
    type: number
    sql: ${TABLE}.mor_religcontrib ;;
  }

  dimension: mor_religmag {
    type: number
    sql: ${TABLE}.mor_religmag ;;
  }

  dimension: mor_upscalbuy {
    type: number
    sql: ${TABLE}.mor_upscalbuy ;;
  }

  dimension: mort_ddate {
    label: "Mortgage Change Date"
    type: time
    sql: TO_DATE (${TABLE}.mort_ddate, 'YYYYMMDD') ;;
  }

  dimension: mosaci_hh {
    label: "Mosaic Household"
  }

  dimension: mosaic_glb_hh {
  }

  dimension: mosaic_z4 {
    label: "Mosaic Zip+4"
  }

  dimension: mosaic_z4_glb {
  }

  dimension: mrtl_model_1 {
    sql: ${TABLE}.mrtl_model_1 ;;
  }

  dimension: mrtl_model_2 {
    sql: ${TABLE}.mrtl_model_2 ;;
  }

  dimension: mrtl_model_3 {
    sql: ${TABLE}.mrtl_model_3 ;;
  }

  dimension: mrtl_model_4 {
    sql: ${TABLE}.mrtl_model_4 ;;
  }

  dimension: mrtl_model_5 {
    sql: ${TABLE}.mrtl_model_5 ;;
  }

  dimension: mrtl_model_6 {
    sql: ${TABLE}.mrtl_model_6 ;;
  }

  dimension: mrtl_model_7 {
    sql: ${TABLE}.mrtl_model_7 ;;
  }

  dimension: mrtl_model_8 {
    sql: ${TABLE}.mrtl_model_8 ;;
  }

  dimension: occup_v2_1 {
    sql: ${TABLE}.occup_v2_1 ;;
  }

  dimension: occup_v2_2 {
    sql: ${TABLE}.occup_v2_2 ;;
  }

  dimension: occup_v2_3 {
    sql: ${TABLE}.occup_v2_3 ;;
  }

  dimension: occup_v2_4 {
    sql: ${TABLE}.occup_v2_4 ;;
  }

  dimension: occup_v2_5 {
    sql: ${TABLE}.occup_v2_5 ;;
  }

  dimension: occup_v2_6 {
    sql: ${TABLE}.occup_v2_6 ;;
  }

  dimension: occup_v2_7 {
    sql: ${TABLE}.occup_v2_7 ;;
  }

  dimension: occup_v2_8 {
    sql: ${TABLE}.occup_v2_8 ;;
  }

  dimension: ocup_model_4 {
    sql: ${TABLE}.ocup_model_4 ;;
  }

  dimension: ocup_ocup_1 {
    type: number
    sql: ${TABLE}.ocup_ocup_1 ;;
  }

  dimension: ocup_ocup_2 {
    type: number
    sql: ${TABLE}.ocup_ocup_2 ;;
  }

  dimension: ocup_ocup_3 {
    type: number
    sql: ${TABLE}.ocup_ocup_3 ;;
  }

  dimension: ocup_ocup_4 {
    type: number
    sql: ${TABLE}.ocup_ocup_4 ;;
  }

  dimension: ocup_ocup_5 {
    type: number
    sql: ${TABLE}.ocup_ocup_5 ;;
  }

  dimension: ocup_ocup_6 {
    type: number
    sql: ${TABLE}.ocup_ocup_6 ;;
  }

  dimension: ocup_ocup_7 {
    type: number
    sql: ${TABLE}.ocup_ocup_7 ;;
  }

  dimension: ocup_ocup_8 {
    type: number
    sql: ${TABLE}.ocup_ocup_8 ;;
  }

  dimension: perstype_1 {
    sql: ${TABLE}.perstype_1 ;;
  }

  dimension: perstype_2 {
    sql: ${TABLE}.perstype_2 ;;
  }

  dimension: perstype_3 {
    sql: ${TABLE}.perstype_3 ;;
  }

  dimension: perstype_4 {
    sql: ${TABLE}.perstype_4 ;;
  }

  dimension: perstype_5 {
    sql: ${TABLE}.perstype_5 ;;
  }

  dimension: perstype_6 {
    sql: ${TABLE}.perstype_6 ;;
  }

  dimension: perstype_7 {
    sql: ${TABLE}.perstype_7 ;;
  }

  dimension: perstype_8 {
    sql: ${TABLE}.perstype_8 ;;
  }

  dimension: pfxt_pfxt_1 {
    sql: ${TABLE}.pfxt_pfxt_1 ;;
  }

  dimension: pfxt_pfxt_2 {
    sql: ${TABLE}.pfxt_pfxt_2 ;;
  }

  dimension: pfxt_pfxt_3 {
    sql: ${TABLE}.pfxt_pfxt_3 ;;
  }

  dimension: pfxt_pfxt_4 {
    sql: ${TABLE}.pfxt_pfxt_4 ;;
  }

  dimension: pfxt_pfxt_5 {
    sql: ${TABLE}.pfxt_pfxt_5 ;;
  }

  dimension: pfxt_pfxt_6 {
    sql: ${TABLE}.pfxt_pfxt_6 ;;
  }

  dimension: pfxt_pfxt_7 {
    sql: ${TABLE}.pfxt_pfxt_7 ;;
  }

  dimension: pfxt_pfxt_8 {
    sql: ${TABLE}.pfxt_pfxt_8 ;;
  }

  dimension: pid_1 {
    sql: ${TABLE}.pid_1 ;;
  }

  dimension: pid_2 {
    sql: ${TABLE}.pid_2 ;;
  }

  dimension: pid_3 {
    sql: ${TABLE}.pid_3 ;;
  }

  dimension: pid_4 {
    sql: ${TABLE}.pid_4 ;;
  }

  dimension: pid_5 {
    sql: ${TABLE}.pid_5 ;;
  }

  dimension: pid_6 {
    sql: ${TABLE}.pid_6 ;;
  }

  dimension: pid_7 {
    sql: ${TABLE}.pid_7 ;;
  }

  dimension: pid_8 {
    sql: ${TABLE}.pid_8 ;;
  }

  dimension: poc03_v3_code {
    sql: ${TABLE}.poc03_v3_code ;;
  }

  dimension: poc1012_v3_code {
    sql: ${TABLE}.poc1012_v3_code ;;
  }

  dimension: poc1315_v3_code {
    sql: ${TABLE}.poc1315_v3_code ;;
  }

  dimension: poc1618_v3_code {
    sql: ${TABLE}.poc1618_v3_code ;;
  }

  dimension: poc46_v3_code {
    sql: ${TABLE}.poc46_v3_code ;;
  }

  dimension: poc79_v3_code {
    sql: ${TABLE}.poc79_v3_code ;;
  }

  dimension: poc_v3_code {
    sql: ${TABLE}.poc_v3_code ;;
  }

  dimension: pol_aff_1 {
    sql: ${TABLE}.pol_aff_1 ;;
  }

  dimension: pol_aff_2 {
    sql: ${TABLE}.pol_aff_2 ;;
  }

  dimension: pol_aff_3 {
    sql: ${TABLE}.pol_aff_3 ;;
  }

  dimension: pol_aff_4 {
    sql: ${TABLE}.pol_aff_4 ;;
  }

  dimension: pol_aff_5 {
    sql: ${TABLE}.pol_aff_5 ;;
  }

  dimension: pol_aff_6 {
    sql: ${TABLE}.pol_aff_6 ;;
  }

  dimension: pol_aff_7 {
    sql: ${TABLE}.pol_aff_7 ;;
  }

  dimension: pol_aff_8 {
    sql: ${TABLE}.pol_aff_8 ;;
  }

  dimension: pol_per_1 {
    type: number
    sql: ${TABLE}.pol_per_1 ;;
  }

  dimension: pol_per_2 {
    type: number
    sql: ${TABLE}.pol_per_2 ;;
  }

  dimension: pol_per_3 {
    type: number
    sql: ${TABLE}.pol_per_3 ;;
  }

  dimension: pol_per_4 {
    type: number
    sql: ${TABLE}.pol_per_4 ;;
  }

  dimension: pol_per_5 {
    type: number
    sql: ${TABLE}.pol_per_5 ;;
  }

  dimension: pol_per_6 {
    type: number
    sql: ${TABLE}.pol_per_6 ;;
  }

  dimension: pol_per_7 {
    type: number
    sql: ${TABLE}.pol_per_7 ;;
  }

  dimension: pol_per_8 {
    type: number
    sql: ${TABLE}.pol_per_8 ;;
  }

  dimension: post_carr {
    sql: ${TABLE}.post_carr ;;
  }

  dimension: post_pcde {
    sql: ${TABLE}.post_pcde ;;
  }

  dimension: post_zip4 {
    sql: ${TABLE}.post_zip4 ;;
  }

  dimension: prmy_numb {
    label: "House Number"
    sql: ${TABLE}.prmy_numb ;;
  }

  dimension: rchr_airc {
    label: "Cooling Type"
  }

  dimension: rchr_bdat {
    label: "Year Built Actual"
    type: time
    sql: TO_DATE (${TABLE}.rchr_bdat, 'YYYY') ;;
  }

  dimension: rchr_bldc {
    label: "Building Construction"
  }

  dimension: rchr_extw {
    label: "Exterior Wall Type"
  }

  dimension: rchr_flrc {
    type: number
    sql: ${TABLE}.rchr_flrc ;;
  }

  dimension: rchr_frpl {
    label: "Fireplaces"
    type: number
    sql: ${TABLE}.rchr_frpl ;;
  }

  dimension: rchr_heat {
    label: "Heat Type"
  }

  dimension: has_pool {
    label: "Has Swimming Pool"
    type: yesno
    sql: ${TABLE}.rchr_swim = 'Y' ;;
  }

  dimension: rchr_swim {
    label: "Swimming Pool Indicator"
    sql: ${TABLE}.rchr_swim ;;
  }

  dimension: reading {
    sql: ${TABLE}.reading ;;
  }

  dimension: rec_adultcnt {
    type: number
    sql: ${TABLE}.rec_adultcnt ;;
  }

  dimension: rec_childcnt {
    type: number
    sql: ${TABLE}.rec_childcnt ;;
  }

  dimension: rec_reliable_code {
    type: number
    sql: ${TABLE}.rec_reliable_code ;;
  }

  dimension: recd_zipc {
    label: "Postal Code"
    type: zipcode
    sql: ${TABLE}.recd_zipc ;;
  }

  dimension: rsiz_basf {
    type: number
    sql: ${TABLE}.rsiz_basf ;;
  }

  dimension: rsiz_bedr {
    label: "Number of Bedrooms"
    type: number
    sql: ${TABLE}.rsiz_bedr ;;
  }

  dimension: rsiz_bthr {
    label: "Number of Bathrooms"
    type: number
    value_format: "#.0"
    sql: ${TABLE}.rsiz_bthr / 10 ;;
  }

  dimension: rsiz_busf {
    label: "Square Footage"
    type: number
    sql: ${TABLE}.rsiz_busf ;;
  }

  dimension: rsiz_ladf {
    label: "Land Depth Footage (Thousands)"
    type: number
    sql: ${TABLE}.rsiz_ladf ;;
  }

  dimension: rsiz_laff {
    label: "Land Front Footage (Thousands)"
    type: number
    sql: ${TABLE}.rsiz_laff ;;
  }

  dimension: rsiz_lasf {
    label: "Land Square Footage (Thousands)"
    type: number
    sql: ${TABLE}.rsiz_lasf ;;
  }

  dimension: rsiz_prop {
    label: "Property Type"
  }

  dimension: rsiz_stor {
    label: "Number of Stories"
    type: number
    sql: ${TABLE}.rsiz_stor ;;
  }

  dimension: rsiz_totr {
    label: "Number of Rooms"
    type: number
    sql: ${TABLE}.rsiz_totr ;;
  }

  dimension: rural_urban_cntysz {
    type: number
    sql: ${TABLE}.rural_urban_cntysz ;;
  }

  dimension: rval_impr {
    label: "Property/Realty: Home Improvement Value (Thousands)"
    type: number
    sql: ${TABLE}.rval_impr ;;
  }

  dimension: rval_land {
    type: number
    sql: ${TABLE}.rval_land ;;
  }

  dimension: rval_tax {
    type: number
    sql: ${TABLE}.rval_tax ;;
  }

  dimension: rval_totl {
    label: "Property/Realty: Home Total Value (Thousands)"
    type: number
    sql: ${TABLE}.rval_totl ;;
  }

  dimension: scdy_desg {
    sql: ${TABLE}.scdy_desg ;;
  }

  dimension: scdy_numb {
    sql: ${TABLE}.scdy_numb ;;
  }

  dimension: sfxt_sfxt_1 {
    sql: ${TABLE}.sfxt_sfxt_1 ;;
  }

  dimension: sfxt_sfxt_2 {
    sql: ${TABLE}.sfxt_sfxt_2 ;;
  }

  dimension: sfxt_sfxt_3 {
    sql: ${TABLE}.sfxt_sfxt_3 ;;
  }

  dimension: sfxt_sfxt_4 {
    sql: ${TABLE}.sfxt_sfxt_4 ;;
  }

  dimension: sfxt_sfxt_5 {
    sql: ${TABLE}.sfxt_sfxt_5 ;;
  }

  dimension: sfxt_sfxt_6 {
    sql: ${TABLE}.sfxt_sfxt_6 ;;
  }

  dimension: sfxt_sfxt_7 {
    sql: ${TABLE}.sfxt_sfxt_7 ;;
  }

  dimension: sfxt_sfxt_8 {
    sql: ${TABLE}.sfxt_sfxt_8 ;;
  }

  dimension: snam_snam_1 {
    sql: ${TABLE}.snam_snam_1 ;;
  }

  dimension: snam_snam_2 {
    sql: ${TABLE}.snam_snam_2 ;;
  }

  dimension: snam_snam_3 {
    sql: ${TABLE}.snam_snam_3 ;;
  }

  dimension: snam_snam_4 {
    sql: ${TABLE}.snam_snam_4 ;;
  }

  dimension: snam_snam_5 {
    sql: ${TABLE}.snam_snam_5 ;;
  }

  dimension: snam_snam_6 {
    sql: ${TABLE}.snam_snam_6 ;;
  }

  dimension: snam_snam_7 {
    sql: ${TABLE}.snam_snam_7 ;;
  }

  dimension: snam_snam_8 {
    sql: ${TABLE}.snam_snam_8 ;;
  }

  dimension: stat_abbr {
    label: "State"
    sql: ${TABLE}.stat_abbr ;;
  }

  dimension: strt_name {
    sql: ${TABLE}.strt_name ;;
  }

  dimension: strt_post {
    sql: ${TABLE}.strt_post ;;
  }

  dimension: strt_pred {
    sql: ${TABLE}.strt_pred ;;
  }

  dimension: strt_sufx {
    sql: ${TABLE}.strt_sufx ;;
  }

  dimension: tran_amnt {
    type: number
    sql: ${TABLE}.tran_amnt ;;
  }

  dimension: year_built {
    label: "Year Built"
    type: time
    sql: TO_DATE (${TABLE}.year_built, 'YYYY') ;;
  }

  dimension: z_act_military {
    sql: ${TABLE}.z_act_military ;;
  }

  dimension: z_aff_life {
    sql: ${TABLE}.z_aff_life ;;
  }

  dimension: z_arts {
    sql: ${TABLE}.z_arts ;;
  }

  dimension: z_astrolgy {
    sql: ${TABLE}.z_astrolgy ;;
  }

  dimension: z_boatng {
    sql: ${TABLE}.z_boatng ;;
  }

  dimension: z_buys_by_phone {
    sql: ${TABLE}.z_buys_by_phone ;;
  }

  dimension: z_buys_by_tv {
    sql: ${TABLE}.z_buys_by_tv ;;
  }

  dimension: z_cat {
    sql: ${TABLE}.z_cat ;;
  }

  dimension: z_charites {
    sql: ${TABLE}.z_charites ;;
  }

  dimension: z_child_parent {
    sql: ${TABLE}.z_child_parent ;;
  }

  dimension: z_christian {
    sql: ${TABLE}.z_christian ;;
  }

  dimension: z_classical {
    sql: ${TABLE}.z_classical ;;
  }

  dimension: z_clothing {
    sql: ${TABLE}.z_clothing ;;
  }

  dimension: z_collects {
    sql: ${TABLE}.z_collects ;;
  }

  dimension: z_commun {
    sql: ${TABLE}.z_commun ;;
  }

  dimension: z_computer {
    sql: ${TABLE}.z_computer ;;
  }

  dimension: z_computers {
    sql: ${TABLE}.z_computers ;;
  }

  dimension: z_contact {
    sql: ${TABLE}.z_contact ;;
  }

  dimension: likes_country_music {
    label: "Country Music Enthusiast"
    type: yesno
    sql: ${TABLE}.z_country = 'Y' ;;
  }

  dimension: z_country {
    sql: ${TABLE}.z_country ;;
  }

  dimension: z_crafts {
    sql: ${TABLE}.z_crafts ;;
  }

  dimension: z_credit_card {
    sql: ${TABLE}.z_credit_card ;;
  }

  dimension: z_cruise {
    sql: ${TABLE}.z_cruise ;;
  }

  dimension: z_diy {
    sql: ${TABLE}.z_diy ;;
  }

  dimension: z_dog {
    sql: ${TABLE}.z_dog ;;
  }

  dimension: z_environment_donor {
    sql: ${TABLE}.z_environment_donor ;;
  }

  dimension: z_fitness {
    sql: ${TABLE}.z_fitness ;;
  }

  dimension: z_garden {
    sql: ${TABLE}.z_garden ;;
  }

  dimension: z_golf {
    sql: ${TABLE}.z_golf ;;
  }

  dimension: z_gourmet {
    sql: ${TABLE}.z_gourmet ;;
  }

  dimension: z_grandp {
    sql: ${TABLE}.z_grandp ;;
  }

  dimension: z_healthy {
    sql: ${TABLE}.z_healthy ;;
  }

  dimension: z_hi_tech {
    sql: ${TABLE}.z_hi_tech ;;
  }

  dimension: z_home_decorating {
    sql: ${TABLE}.z_home_decorating ;;
  }

  dimension: z_home_entertain {
    sql: ${TABLE}.z_home_entertain ;;
  }

  dimension: z_inact_military {
    sql: ${TABLE}.z_inact_military ;;
  }

  dimension: z_int_dvd {
    sql: ${TABLE}.z_int_dvd ;;
  }

  dimension: z_internet {
    sql: ${TABLE}.z_internet ;;
  }

  dimension: z_investor {
    sql: ${TABLE}.z_investor ;;
  }

  dimension: z_kitchen {
    sql: ${TABLE}.z_kitchen ;;
  }

  dimension: z_mailorder_buyer {
    sql: ${TABLE}.z_mailorder_buyer ;;
  }

  dimension: z_mob {
    sql: ${TABLE}.z_mob ;;
  }

  dimension: z_mob_books {
    sql: ${TABLE}.z_mob_books ;;
  }

  dimension: z_mob_garden {
    sql: ${TABLE}.z_mob_garden ;;
  }

  dimension: z_mob_gifts {
    sql: ${TABLE}.z_mob_gifts ;;
  }

  dimension: z_mob_ins {
    sql: ${TABLE}.z_mob_ins ;;
  }

  dimension: z_mob_jew {
    sql: ${TABLE}.z_mob_jew ;;
  }

  dimension: z_mob_music {
    sql: ${TABLE}.z_mob_music ;;
  }

  dimension: z_mob_shoes {
    sql: ${TABLE}.z_mob_shoes ;;
  }

  dimension: z_music {
    sql: ${TABLE}.z_music ;;
  }

  dimension: z_mutual {
    sql: ${TABLE}.z_mutual ;;
  }

  dimension: z_oldies {
    sql: ${TABLE}.z_oldies ;;
  }

  dimension: z_online {
    sql: ${TABLE}.z_online ;;
  }

  dimension: z_outdoor {
    sql: ${TABLE}.z_outdoor ;;
  }

  dimension: z_personal {
    sql: ${TABLE}.z_personal ;;
  }

  dimension: z_pet {
    sql: ${TABLE}.z_pet ;;
  }

  dimension: z_photo {
    sql: ${TABLE}.z_photo ;;
  }

  dimension: z_politic {
    sql: ${TABLE}.z_politic ;;
  }

  dimension: z_premium_credit {
    sql: ${TABLE}.z_premium_credit ;;
  }

  dimension: z_pres_auto {
    sql: ${TABLE}.z_pres_auto ;;
  }

  dimension: z_pres_of_cell {
    sql: ${TABLE}.z_pres_of_cell ;;
  }

  dimension: z_reading {
    sql: ${TABLE}.z_reading ;;
  }

  dimension: z_reg_drugs {
    sql: ${TABLE}.z_reg_drugs ;;
  }

  dimension: z_religion {
    sql: ${TABLE}.z_religion ;;
  }

  dimension: z_rock {
    sql: ${TABLE}.z_rock ;;
  }

  dimension: z_self_improv {
    sql: ${TABLE}.z_self_improv ;;
  }

  dimension: z_skiing {
    sql: ${TABLE}.z_skiing ;;
  }

  dimension: z_sports {
    sql: ${TABLE}.z_sports ;;
  }

  dimension: z_sweeps {
    sql: ${TABLE}.z_sweeps ;;
  }

  dimension: z_tennis {
    sql: ${TABLE}.z_tennis ;;
  }

  dimension: z_travel {
    sql: ${TABLE}.z_travel ;;
  }

  dimension: z_travel_domestic {
    sql: ${TABLE}.z_travel_domestic ;;
  }

  dimension: z_travel_foreign {
    sql: ${TABLE}.z_travel_foreign ;;
  }

  dimension: z_volunteer {
    sql: ${TABLE}.z_volunteer ;;
  }

  dimension: z_weight {
    sql: ${TABLE}.z_weight ;;
  }

  measure: count_with_sq_footage {
    type: count
    filters: [rsiz_lasf: ">0"]
  }

  measure: count_with_building_construction {
    type: count
    filters: [rchr_bldc: "-Unknown,-Unexpected"]
  }

  measure: percent_with_sq_footage {
    type: number
    sql: 100.0 * ${count_with_sq_footage} / NULLIF(${count}, 0) ;;
  }

  measure: percent_with_building_construction {
    type: number
    sql: 100.0 * ${count_with_building_construction} / NULLIF(${count}, 0) ;;
  }

  measure: dwelling_single_family_count {
    type: count
    filters: [dwelling_type: "S"]
  }

  measure: dwelling_multi_family_count {
    type: count
    filters: [dwelling_type: "A"]
  }

  measure: astrology_interest_count {
    type: count
    filters: [z_astrolgy: "Y"]
  }

  measure: count_with_home_ownership_data {
    type: count
    filters: [home_ownership: "-unknown"]
  }

  measure: percent_with_home_ownership_data {
    type: number
    sql: 100.0 * ${count_with_home_ownership_data} / NULLIF(${count}, 0) ;;
  }

  measure: count {
    type: count
    drill_fields: [stat_abbr, countyname, rchr_airc, rchr_heat]
  }
}

- view: demographics
  sql_table_name: public.experian
  fields:
  - dimension: address_line_1
    sql: ${TABLE}.address_line_1
  - dimension: address_line_2
    sql: ${TABLE}.address_line_2
  - dimension: aid
    type: int
    sql: ${TABLE}.aid
  - dimension: ams
    type: number
    label: Number of Hybrid Cars
    sql: ${TABLE}.ams
  - dimension: aqi
    label: Address Quality
  - dimension: auto_new
    label: New Automobile Purchase (next 6 months)
  - dimension: auto_used
    label: Used Automobile Purchase (next 6 months)
  - dimension: auto_used0005
    label: Used (0-5 yr old) Automobile Purchase (next 6 months)
  - dimension: auto_used0610
    label: Used (6-10 yr old) Automobile Purchase (next 6 months)
  - dimension: auto_used11up
    label: Used (11+ yr old) Automobile Purchase (next 6 months)
  - dimension: bdat_bdat_1
    type: time
    label: Person 1 Birthdate
    sql: TO_DATE (${TABLE}.bdat_bdat_1, 'YYYYMM')
  - dimension: bdat_bdat_2
    type: time
    label: Person 2 Birthdate
    sql: TO_DATE (${TABLE}.bdat_bdat_2, 'YYYYMM')
  - dimension: bdat_bdat_3
    type: time
    label: Person 3 Birthdate
    sql: TO_DATE (${TABLE}.bdat_bdat_3, 'YYYYMM')
  - dimension: bdat_bdat_4
    type: time
    label: Person 4 Birthdate
    sql: TO_DATE (${TABLE}.bdat_bdat_4, 'YYYYMM')
  - dimension: bdat_bdat_5
    type: time
    label: Person 5 Birthdate
    sql: TO_DATE (${TABLE}.bdat_bdat_5, 'YYYYMM')
  - dimension: bdat_bdat_6
    type: time
    label: Person 6 Birthdate
    sql: TO_DATE (${TABLE}.bdat_bdat_6, 'YYYYMM')
  - dimension: bdat_bdat_7
    type: time
    label: Person 7 Birthdate
    sql: TO_DATE (${TABLE}.bdat_bdat_7, 'YYYYMM')
  - dimension: bdat_bdat_8
    type: time
    label: Person 8 Birthdate
    sql: TO_DATE (${TABLE}.bdat_bdat_8, 'YYYYMM')
  - dimension: biz_owner_1
    sql: ${TABLE}.biz_owner_1
  - dimension: biz_owner_2
    sql: ${TABLE}.biz_owner_2
  - dimension: biz_owner_3
    sql: ${TABLE}.biz_owner_3
  - dimension: biz_owner_4
    sql: ${TABLE}.biz_owner_4
  - dimension: biz_owner_5
    sql: ${TABLE}.biz_owner_5
  - dimension: biz_owner_6
    sql: ${TABLE}.biz_owner_6
  - dimension: biz_owner_7
    sql: ${TABLE}.biz_owner_7
  - dimension: biz_owner_8
    sql: ${TABLE}.biz_owner_8
  - dimension: cape_hh_sz
    type: number
    sql: ${TABLE}.cape_hh_sz
  - dimension: cape_medage
    type: number
    sql: ${TABLE}.cape_medage
  - dimension: cape_mededu
    type: number
    sql: ${TABLE}.cape_mededu
  - dimension: cape_medhua
    type: number
    sql: ${TABLE}.cape_medhua
  - dimension: cape_medhv
    type: int
    sql: ${TABLE}.cape_medhv
  - dimension: cape_mfhi
    type: int
    sql: ${TABLE}.cape_mfhi
  - dimension: cape_perc_017
    type: number
    sql: ${TABLE}.cape_perc_017
  - dimension: cape_perc_1899
    type: number
    sql: ${TABLE}.cape_perc_1899
  - dimension: cape_perc_6599
    type: number
    sql: ${TABLE}.cape_perc_6599
  - dimension: cape_perc_asn
    type: number
    sql: ${TABLE}.cape_perc_asn
  - dimension: cape_perc_blk
    type: number
    sql: ${TABLE}.cape_perc_blk
  - dimension: cape_perc_fam_chld
    type: number
    sql: ${TABLE}.cape_perc_fam_chld
  - dimension: cape_perc_fam_nochld
    type: number
    sql: ${TABLE}.cape_perc_fam_nochld
  - dimension: cape_perc_his
    type: number
    sql: ${TABLE}.cape_perc_his
  - dimension: cape_perc_lt18
    type: number
    sql: ${TABLE}.cape_perc_lt18
  - dimension: cape_perc_mobile
    type: number
    sql: ${TABLE}.cape_perc_mobile
  - dimension: cape_perc_mrdcpl
    type: number
    sql: ${TABLE}.cape_perc_mrdcpl
  - dimension: cape_perc_occ
    type: number
    sql: ${TABLE}.cape_perc_occ
  - dimension: cape_perc_rent
    type: number
    sql: ${TABLE}.cape_perc_rent
  - dimension: cape_perc_spnspk
    type: number
    sql: ${TABLE}.cape_perc_spnspk
  - dimension: cape_perc_wht
    type: number
    sql: ${TABLE}.cape_perc_wht
  - dimension: cape_pph
    type: number
    sql: ${TABLE}.cape_pph
  - dimension: cbsa
    sql: ${TABLE}.cbsa
  - dimension: cbsa_type
    sql: ${TABLE}.cbsa_type
  - dimension: census_bg
    sql: ${TABLE}.census_bg
  - dimension: census_id
    sql: ${TABLE}.census_id
  - dimension: census_trt
    sql: ${TABLE}.census_trt
  - dimension: city_cnab
    sql: ${TABLE}.city_cnab
  - dimension: city_plac
    label: City
    sql: ${TABLE}.city_plac
  - dimension: cnty_2000
    type: number
    sql: ${TABLE}.cnty_2000
  - dimension: combined_age_1
    sql: ${TABLE}.combined_age_1
  - dimension: combined_age_2
    sql: ${TABLE}.combined_age_2
  - dimension: combined_age_3
    sql: ${TABLE}.combined_age_3
  - dimension: combined_age_4
    sql: ${TABLE}.combined_age_4
  - dimension: combined_age_5
    sql: ${TABLE}.combined_age_5
  - dimension: combined_age_6
    sql: ${TABLE}.combined_age_6
  - dimension: combined_age_7
    sql: ${TABLE}.combined_age_7
  - dimension: combined_age_8
    sql: ${TABLE}.combined_age_8
  - dimension: conf_flag
    label: Year Built Confidence
    sql: ${TABLE}.conf_flag
  - dimension: countyname
    sql: ${TABLE}.countyname
  - dimension: digdad
    type: number
    sql: ${TABLE}.digdad
  - dimension: digmom
    type: number
    sql: ${TABLE}.digmom
  - dimension: du_size
    sql: ${TABLE}.du_size
  - dimension: dwelling_type
    sql: ${TABLE}.dwelling_type
  - dimension: echv
    type: int
    sql: ${TABLE}.echv
  - dimension: educ_model_1
    sql: ${TABLE}.educ_model_1
  - dimension: educ_model_2
    sql: ${TABLE}.educ_model_2
  - dimension: educ_model_3
    sql: ${TABLE}.educ_model_3
  - dimension: educ_model_4
    sql: ${TABLE}.educ_model_4
  - dimension: educ_model_5
    sql: ${TABLE}.educ_model_5
  - dimension: educ_model_6
    sql: ${TABLE}.educ_model_6
  - dimension: educ_model_7
    sql: ${TABLE}.educ_model_7
  - dimension: educ_model_8
    sql: ${TABLE}.educ_model_8
  - dimension: filler_1
    sql: ${TABLE}.filler_1
  - dimension: filler_10
    sql: ${TABLE}.filler_10
  - dimension: filler_11
    sql: ${TABLE}.filler_11
  - dimension: filler_12
    sql: ${TABLE}.filler_12
  - dimension: filler_13
    sql: ${TABLE}.filler_13
  - dimension: filler_14
    sql: ${TABLE}.filler_14
  - dimension: filler_15
    sql: ${TABLE}.filler_15
  - dimension: filler_17
    sql: ${TABLE}.filler_17
  - dimension: filler_18
    sql: ${TABLE}.filler_18
  - dimension: filler_19
    sql: ${TABLE}.filler_19
  - dimension: filler_2
    sql: ${TABLE}.filler_2
  - dimension: filler_20
    sql: ${TABLE}.filler_20
  - dimension: filler_21
    sql: ${TABLE}.filler_21
  - dimension: filler_22
    sql: ${TABLE}.filler_22
  - dimension: filler_23
    sql: ${TABLE}.filler_23
  - dimension: filler_24
    sql: ${TABLE}.filler_24
  - dimension: filler_25
    sql: ${TABLE}.filler_25
  - dimension: filler_26
    sql: ${TABLE}.filler_26
  - dimension: filler_27
    sql: ${TABLE}.filler_27
  - dimension: filler_28
    sql: ${TABLE}.filler_28
  - dimension: filler_3
    sql: ${TABLE}.filler_3
  - dimension: filler_3a
    sql: ${TABLE}.filler_3a
  - dimension: filler_3b
    sql: ${TABLE}.filler_3b
  - dimension: filler_3c
    sql: ${TABLE}.filler_3c
  - dimension: filler_3d
    sql: ${TABLE}.filler_3d
  - dimension: filler_4b
    sql: ${TABLE}.filler_4b
  - dimension: filler_6a
    sql: ${TABLE}.filler_6a
  - dimension: filler_6b
    sql: ${TABLE}.filler_6b
  - dimension: filler_6c
    sql: ${TABLE}.filler_6c
  - dimension: filler_7
    sql: ${TABLE}.filler_7
  - dimension: filler_8
    sql: ${TABLE}.filler_8
  - dimension: filler_9
    sql: ${TABLE}.filler_9
  - dimension: filler_geo
    type: number
    sql: ${TABLE}.filler_geo
  - dimension: fnam_fnam_1
    sql: ${TABLE}.fnam_fnam_1
  - dimension: fnam_fnam_2
    sql: ${TABLE}.fnam_fnam_2
  - dimension: fnam_fnam_3
    sql: ${TABLE}.fnam_fnam_3
  - dimension: fnam_fnam_4
    sql: ${TABLE}.fnam_fnam_4
  - dimension: fnam_fnam_5
    sql: ${TABLE}.fnam_fnam_5
  - dimension: fnam_fnam_6
    sql: ${TABLE}.fnam_fnam_6
  - dimension: fnam_fnam_7
    sql: ${TABLE}.fnam_fnam_7
  - dimension: fnam_fnam_8
    sql: ${TABLE}.fnam_fnam_8
  - dimension: geo_level
    sql: ${TABLE}.geo_level
  - dimension: geoc_stat_2000
    type: number
    label: State Code
    sql: ${TABLE}.geoc_stat_2000
  - dimension: gndr_gndr_1
    sql: ${TABLE}.gndr_gndr_1
  - dimension: gndr_gndr_2
    sql: ${TABLE}.gndr_gndr_2
  - dimension: gndr_gndr_3
    sql: ${TABLE}.gndr_gndr_3
  - dimension: gndr_gndr_4
    sql: ${TABLE}.gndr_gndr_4
  - dimension: gndr_gndr_5
    sql: ${TABLE}.gndr_gndr_5
  - dimension: gndr_gndr_6
    sql: ${TABLE}.gndr_gndr_6
  - dimension: gndr_gndr_7
    sql: ${TABLE}.gndr_gndr_7
  - dimension: gndr_gndr_8
    sql: ${TABLE}.gndr_gndr_8
  - dimension: green_aware
  - dimension: green_aware_tier
    type: number
    sql: ${TABLE}.green_aware_tier
  - dimension: hbi
    sql: ${TABLE}.hbi
  - dimension: hh_composition_code
    sql: ${TABLE}.hh_composition_code
  - dimension: ho_rent
    sql: ${TABLE}.ho_rent
  - dimension: hop
    sql: ${TABLE}.hop
  - dimension: home_ownership
  - dimension: inc_state_dec
    type: number
    sql: ${TABLE}.inc_state_dec
  - dimension: ispsa
    type: number
    sql: ${TABLE}.ispsa
  - dimension: ispsa_dec
    type: number
    sql: ${TABLE}.ispsa_dec
  - dimension: location
    type: location
  - dimension: latitude
    type: number
    sql: ${TABLE}.latitude
  - dimension: lngth_of_res
    type: number
    sql: ${TABLE}.lngth_of_res
  - dimension: longitude
    type: number
    sql: ${TABLE}.longitude
  - dimension: lu_a_adat
    type: time
    label: Last Activity
    sql: TO_DATE (${TABLE}.lu_a_adat, 'YYYYMMDD')
  - dimension: lu_ehi_v5
    label: Household Income
    sql: ${TABLE}.lu_ehi_v5
  - dimension: lu_ehi_v5_amt
    type: number
    sql: ${TABLE}.lu_ehi_v5_amt
  - dimension: lu_mailresp
    sql: ${TABLE}.lu_mailresp
  - dimension: luid
    sql: ${TABLE}.luid
  - dimension: mnam_mnam_1
    sql: ${TABLE}.mnam_mnam_1
  - dimension: mnam_mnam_2
    sql: ${TABLE}.mnam_mnam_2
  - dimension: mnam_mnam_3
    sql: ${TABLE}.mnam_mnam_3
  - dimension: mnam_mnam_4
    sql: ${TABLE}.mnam_mnam_4
  - dimension: mnam_mnam_5
    sql: ${TABLE}.mnam_mnam_5
  - dimension: mnam_mnam_6
    sql: ${TABLE}.mnam_mnam_6
  - dimension: mnam_mnam_7
    sql: ${TABLE}.mnam_mnam_7
  - dimension: mnam_mnam_8
    sql: ${TABLE}.mnam_mnam_8
  - dimension: mobj
    sql: ${TABLE}.mobj
  - dimension: mor_bookbuyer
    type: number
    sql: ${TABLE}.mor_bookbuyer
  - dimension: mor_collectibles
    type: number
    sql: ${TABLE}.mor_collectibles
  - dimension: mor_contributor
    type: number
    sql: ${TABLE}.mor_contributor
  - dimension: mor_crafts
    type: number
    sql: ${TABLE}.mor_crafts
  - dimension: mor_culinary
    type: number
    sql: ${TABLE}.mor_culinary
  - dimension: mor_dedupcatcnt
    type: number
    sql: ${TABLE}.mor_dedupcatcnt
  - dimension: mor_doityourself
    type: number
    sql: ${TABLE}.mor_doityourself
  - dimension: mor_familymag
    type: number
    sql: ${TABLE}.mor_familymag
  - dimension: mor_femmag
    type: number
    sql: ${TABLE}.mor_femmag
  - dimension: mor_femmerch
    type: number
    sql: ${TABLE}.mor_femmerch
  - dimension: mor_gardenbuy
    type: number
    sql: ${TABLE}.mor_gardenbuy
  - dimension: mor_gardenmag
    type: number
    sql: ${TABLE}.mor_gardenmag
  - dimension: mor_giftbuyer
    type: number
    sql: ${TABLE}.mor_giftbuyer
  - dimension: mor_healthcontrib
    type: number
    sql: ${TABLE}.mor_healthcontrib
  - dimension: mor_healthmag
    type: number
    sql: ${TABLE}.mor_healthmag
  - dimension: mor_malemag
    type: number
    sql: ${TABLE}.mor_malemag
  - dimension: mor_malemerch
    type: number
    sql: ${TABLE}.mor_malemerch
  - dimension: mor_merchbuyer
    type: number
    sql: ${TABLE}.mor_merchbuyer
  - dimension: mor_misc
    type: number
    sql: ${TABLE}.mor_misc
  - dimension: mor_news_fin
    type: number
    sql: ${TABLE}.mor_news_fin
  - dimension: mor_nondedupcnt
    type: number
    sql: ${TABLE}.mor_nondedupcnt
  - dimension: mor_odds_ends
    type: number
    sql: ${TABLE}.mor_odds_ends
  - dimension: mor_opportunity
    type: number
    sql: ${TABLE}.mor_opportunity
  - dimension: mor_photo
    type: number
    sql: ${TABLE}.mor_photo
  - dimension: mor_polcontrib
    type: number
    sql: ${TABLE}.mor_polcontrib
  - dimension: mor_religcontrib
    type: number
    sql: ${TABLE}.mor_religcontrib
  - dimension: mor_religmag
    type: number
    sql: ${TABLE}.mor_religmag
  - dimension: mor_upscalbuy
    type: number
    sql: ${TABLE}.mor_upscalbuy
  - dimension: mort_ddate
    type: time
    label: Mortgage Change Date
    sql: TO_DATE (${TABLE}.mort_ddate, 'YYYYMMDD')
  - dimension: mosaci_hh
    label: Mosaic Household
  - dimension: mosaic_glb_hh
  - dimension: mosaic_z4
    label: Mosaic Zip+4
  - dimension: mosaic_z4_glb
  - dimension: mrtl_model_1
    sql: ${TABLE}.mrtl_model_1
  - dimension: mrtl_model_2
    sql: ${TABLE}.mrtl_model_2
  - dimension: mrtl_model_3
    sql: ${TABLE}.mrtl_model_3
  - dimension: mrtl_model_4
    sql: ${TABLE}.mrtl_model_4
  - dimension: mrtl_model_5
    sql: ${TABLE}.mrtl_model_5
  - dimension: mrtl_model_6
    sql: ${TABLE}.mrtl_model_6
  - dimension: mrtl_model_7
    sql: ${TABLE}.mrtl_model_7
  - dimension: mrtl_model_8
    sql: ${TABLE}.mrtl_model_8
  - dimension: occup_v2_1
    sql: ${TABLE}.occup_v2_1
  - dimension: occup_v2_2
    sql: ${TABLE}.occup_v2_2
  - dimension: occup_v2_3
    sql: ${TABLE}.occup_v2_3
  - dimension: occup_v2_4
    sql: ${TABLE}.occup_v2_4
  - dimension: occup_v2_5
    sql: ${TABLE}.occup_v2_5
  - dimension: occup_v2_6
    sql: ${TABLE}.occup_v2_6
  - dimension: occup_v2_7
    sql: ${TABLE}.occup_v2_7
  - dimension: occup_v2_8
    sql: ${TABLE}.occup_v2_8
  - dimension: ocup_model_4
    sql: ${TABLE}.ocup_model_4
  - dimension: ocup_ocup_1
    type: number
    sql: ${TABLE}.ocup_ocup_1
  - dimension: ocup_ocup_2
    type: number
    sql: ${TABLE}.ocup_ocup_2
  - dimension: ocup_ocup_3
    type: number
    sql: ${TABLE}.ocup_ocup_3
  - dimension: ocup_ocup_4
    type: number
    sql: ${TABLE}.ocup_ocup_4
  - dimension: ocup_ocup_5
    type: number
    sql: ${TABLE}.ocup_ocup_5
  - dimension: ocup_ocup_6
    type: number
    sql: ${TABLE}.ocup_ocup_6
  - dimension: ocup_ocup_7
    type: number
    sql: ${TABLE}.ocup_ocup_7
  - dimension: ocup_ocup_8
    type: number
    sql: ${TABLE}.ocup_ocup_8
  - dimension: perstype_1
    sql: ${TABLE}.perstype_1
  - dimension: perstype_2
    sql: ${TABLE}.perstype_2
  - dimension: perstype_3
    sql: ${TABLE}.perstype_3
  - dimension: perstype_4
    sql: ${TABLE}.perstype_4
  - dimension: perstype_5
    sql: ${TABLE}.perstype_5
  - dimension: perstype_6
    sql: ${TABLE}.perstype_6
  - dimension: perstype_7
    sql: ${TABLE}.perstype_7
  - dimension: perstype_8
    sql: ${TABLE}.perstype_8
  - dimension: pfxt_pfxt_1
    sql: ${TABLE}.pfxt_pfxt_1
  - dimension: pfxt_pfxt_2
    sql: ${TABLE}.pfxt_pfxt_2
  - dimension: pfxt_pfxt_3
    sql: ${TABLE}.pfxt_pfxt_3
  - dimension: pfxt_pfxt_4
    sql: ${TABLE}.pfxt_pfxt_4
  - dimension: pfxt_pfxt_5
    sql: ${TABLE}.pfxt_pfxt_5
  - dimension: pfxt_pfxt_6
    sql: ${TABLE}.pfxt_pfxt_6
  - dimension: pfxt_pfxt_7
    sql: ${TABLE}.pfxt_pfxt_7
  - dimension: pfxt_pfxt_8
    sql: ${TABLE}.pfxt_pfxt_8
  - dimension: pid_1
    sql: ${TABLE}.pid_1
  - dimension: pid_2
    sql: ${TABLE}.pid_2
  - dimension: pid_3
    sql: ${TABLE}.pid_3
  - dimension: pid_4
    sql: ${TABLE}.pid_4
  - dimension: pid_5
    sql: ${TABLE}.pid_5
  - dimension: pid_6
    sql: ${TABLE}.pid_6
  - dimension: pid_7
    sql: ${TABLE}.pid_7
  - dimension: pid_8
    sql: ${TABLE}.pid_8
  - dimension: poc03_v3_code
    sql: ${TABLE}.poc03_v3_code
  - dimension: poc1012_v3_code
    sql: ${TABLE}.poc1012_v3_code
  - dimension: poc1315_v3_code
    sql: ${TABLE}.poc1315_v3_code
  - dimension: poc1618_v3_code
    sql: ${TABLE}.poc1618_v3_code
  - dimension: poc46_v3_code
    sql: ${TABLE}.poc46_v3_code
  - dimension: poc79_v3_code
    sql: ${TABLE}.poc79_v3_code
  - dimension: poc_v3_code
    sql: ${TABLE}.poc_v3_code
  - dimension: pol_aff_1
    sql: ${TABLE}.pol_aff_1
  - dimension: pol_aff_2
    sql: ${TABLE}.pol_aff_2
  - dimension: pol_aff_3
    sql: ${TABLE}.pol_aff_3
  - dimension: pol_aff_4
    sql: ${TABLE}.pol_aff_4
  - dimension: pol_aff_5
    sql: ${TABLE}.pol_aff_5
  - dimension: pol_aff_6
    sql: ${TABLE}.pol_aff_6
  - dimension: pol_aff_7
    sql: ${TABLE}.pol_aff_7
  - dimension: pol_aff_8
    sql: ${TABLE}.pol_aff_8
  - dimension: pol_per_1
    type: number
    sql: ${TABLE}.pol_per_1
  - dimension: pol_per_2
    type: number
    sql: ${TABLE}.pol_per_2
  - dimension: pol_per_3
    type: number
    sql: ${TABLE}.pol_per_3
  - dimension: pol_per_4
    type: number
    sql: ${TABLE}.pol_per_4
  - dimension: pol_per_5
    type: number
    sql: ${TABLE}.pol_per_5
  - dimension: pol_per_6
    type: number
    sql: ${TABLE}.pol_per_6
  - dimension: pol_per_7
    type: number
    sql: ${TABLE}.pol_per_7
  - dimension: pol_per_8
    type: number
    sql: ${TABLE}.pol_per_8
  - dimension: post_carr
    sql: ${TABLE}.post_carr
  - dimension: post_pcde
    sql: ${TABLE}.post_pcde
  - dimension: post_zip4
    sql: ${TABLE}.post_zip4
  - dimension: prmy_numb
    label: House Number
    sql: ${TABLE}.prmy_numb
  - dimension: rchr_airc
    label: Cooling Type
  - dimension: rchr_bdat
    type: time
    label: Year Built Actual
    sql: TO_DATE (${TABLE}.rchr_bdat, 'YYYY')
  - dimension: rchr_bldc
    label: Building Construction
  - dimension: rchr_extw
    label: Exterior Wall Type
  - dimension: rchr_flrc
    type: number
    sql: ${TABLE}.rchr_flrc
  - dimension: rchr_frpl
    type: number
    label: Fireplaces
    sql: ${TABLE}.rchr_frpl
  - dimension: rchr_heat
    label: Heat Type
  - dimension: has_pool
    type: yesno
    label: Has Swimming Pool
    sql: ${TABLE}.rchr_swim = 'Y'
  - dimension: rchr_swim
    label: Swimming Pool Indicator
    sql: ${TABLE}.rchr_swim
  - dimension: reading
    sql: ${TABLE}.reading
  - dimension: rec_adultcnt
    type: number
    sql: ${TABLE}.rec_adultcnt
  - dimension: rec_childcnt
    type: number
    sql: ${TABLE}.rec_childcnt
  - dimension: rec_reliable_code
    type: number
    sql: ${TABLE}.rec_reliable_code
  - dimension: recd_zipc
    type: zipcode
    label: Postal Code
    sql: ${TABLE}.recd_zipc
  - dimension: rsiz_basf
    type: number
    sql: ${TABLE}.rsiz_basf
  - dimension: rsiz_bedr
    type: number
    label: Number of Bedrooms
    sql: ${TABLE}.rsiz_bedr
  - dimension: rsiz_bthr
    type: number
    label: Number of Bathrooms
    value_format: '#.0'
    sql: ${TABLE}.rsiz_bthr / 10
  - dimension: rsiz_busf
    type: number
    label: Square Footage
    sql: ${TABLE}.rsiz_busf
  - dimension: rsiz_ladf
    type: number
    label: Land Depth Footage (Thousands)
    sql: ${TABLE}.rsiz_ladf
  - dimension: rsiz_laff
    type: number
    label: Land Front Footage (Thousands)
    sql: ${TABLE}.rsiz_laff
  - dimension: rsiz_lasf
    type: number
    label: Land Square Footage (Thousands)
    sql: ${TABLE}.rsiz_lasf
  - dimension: rsiz_prop
    label: Property Type
  - dimension: rsiz_stor
    type: number
    label: Number of Stories
    sql: ${TABLE}.rsiz_stor
  - dimension: rsiz_totr
    type: number
    label: Number of Rooms
    sql: ${TABLE}.rsiz_totr
  - dimension: rural_urban_cntysz
    type: number
    sql: ${TABLE}.rural_urban_cntysz
  - dimension: rval_impr
    type: number
    label: 'Property/Realty: Home Improvement Value (Thousands)'
    sql: ${TABLE}.rval_impr
  - dimension: rval_land
    type: number
    sql: ${TABLE}.rval_land
  - dimension: rval_tax
    type: number
    sql: ${TABLE}.rval_tax
  - dimension: rval_totl
    type: number
    label: 'Property/Realty: Home Total Value (Thousands)'
    sql: ${TABLE}.rval_totl
  - dimension: scdy_desg
    sql: ${TABLE}.scdy_desg
  - dimension: scdy_numb
    sql: ${TABLE}.scdy_numb
  - dimension: sfxt_sfxt_1
    sql: ${TABLE}.sfxt_sfxt_1
  - dimension: sfxt_sfxt_2
    sql: ${TABLE}.sfxt_sfxt_2
  - dimension: sfxt_sfxt_3
    sql: ${TABLE}.sfxt_sfxt_3
  - dimension: sfxt_sfxt_4
    sql: ${TABLE}.sfxt_sfxt_4
  - dimension: sfxt_sfxt_5
    sql: ${TABLE}.sfxt_sfxt_5
  - dimension: sfxt_sfxt_6
    sql: ${TABLE}.sfxt_sfxt_6
  - dimension: sfxt_sfxt_7
    sql: ${TABLE}.sfxt_sfxt_7
  - dimension: sfxt_sfxt_8
    sql: ${TABLE}.sfxt_sfxt_8
  - dimension: snam_snam_1
    sql: ${TABLE}.snam_snam_1
  - dimension: snam_snam_2
    sql: ${TABLE}.snam_snam_2
  - dimension: snam_snam_3
    sql: ${TABLE}.snam_snam_3
  - dimension: snam_snam_4
    sql: ${TABLE}.snam_snam_4
  - dimension: snam_snam_5
    sql: ${TABLE}.snam_snam_5
  - dimension: snam_snam_6
    sql: ${TABLE}.snam_snam_6
  - dimension: snam_snam_7
    sql: ${TABLE}.snam_snam_7
  - dimension: snam_snam_8
    sql: ${TABLE}.snam_snam_8
  - dimension: stat_abbr
    label: State
    sql: ${TABLE}.stat_abbr
  - dimension: strt_name
    sql: ${TABLE}.strt_name
  - dimension: strt_post
    sql: ${TABLE}.strt_post
  - dimension: strt_pred
    sql: ${TABLE}.strt_pred
  - dimension: strt_sufx
    sql: ${TABLE}.strt_sufx
  - dimension: tran_amnt
    type: number
    sql: ${TABLE}.tran_amnt
  - dimension: year_built
    type: time
    label: Year Built
    sql: TO_DATE (${TABLE}.year_built, 'YYYY')
  - dimension: z_act_military
    sql: ${TABLE}.z_act_military
  - dimension: z_aff_life
    sql: ${TABLE}.z_aff_life
  - dimension: z_arts
    sql: ${TABLE}.z_arts
  - dimension: z_astrolgy
    sql: ${TABLE}.z_astrolgy
  - dimension: z_boatng
    sql: ${TABLE}.z_boatng
  - dimension: z_buys_by_phone
    sql: ${TABLE}.z_buys_by_phone
  - dimension: z_buys_by_tv
    sql: ${TABLE}.z_buys_by_tv
  - dimension: z_cat
    sql: ${TABLE}.z_cat
  - dimension: z_charites
    sql: ${TABLE}.z_charites
  - dimension: z_child_parent
    sql: ${TABLE}.z_child_parent
  - dimension: z_christian
    sql: ${TABLE}.z_christian
  - dimension: z_classical
    sql: ${TABLE}.z_classical
  - dimension: z_clothing
    sql: ${TABLE}.z_clothing
  - dimension: z_collects
    sql: ${TABLE}.z_collects
  - dimension: z_commun
    sql: ${TABLE}.z_commun
  - dimension: z_computer
    sql: ${TABLE}.z_computer
  - dimension: z_computers
    sql: ${TABLE}.z_computers
  - dimension: z_contact
    sql: ${TABLE}.z_contact
  - dimension: likes_country_music
    type: yesno
    label: Country Music Enthusiast
    sql: ${TABLE}.z_country = 'Y'
  - dimension: z_country
    sql: ${TABLE}.z_country
  - dimension: z_crafts
    sql: ${TABLE}.z_crafts
  - dimension: z_credit_card
    sql: ${TABLE}.z_credit_card
  - dimension: z_cruise
    sql: ${TABLE}.z_cruise
  - dimension: z_diy
    sql: ${TABLE}.z_diy
  - dimension: z_dog
    sql: ${TABLE}.z_dog
  - dimension: z_environment_donor
    sql: ${TABLE}.z_environment_donor
  - dimension: z_fitness
    sql: ${TABLE}.z_fitness
  - dimension: z_garden
    sql: ${TABLE}.z_garden
  - dimension: z_golf
    sql: ${TABLE}.z_golf
  - dimension: z_gourmet
    sql: ${TABLE}.z_gourmet
  - dimension: z_grandp
    sql: ${TABLE}.z_grandp
  - dimension: z_healthy
    sql: ${TABLE}.z_healthy
  - dimension: z_hi_tech
    sql: ${TABLE}.z_hi_tech
  - dimension: z_home_decorating
    sql: ${TABLE}.z_home_decorating
  - dimension: z_home_entertain
    sql: ${TABLE}.z_home_entertain
  - dimension: z_inact_military
    sql: ${TABLE}.z_inact_military
  - dimension: z_int_dvd
    sql: ${TABLE}.z_int_dvd
  - dimension: z_internet
    sql: ${TABLE}.z_internet
  - dimension: z_investor
    sql: ${TABLE}.z_investor
  - dimension: z_kitchen
    sql: ${TABLE}.z_kitchen
  - dimension: z_mailorder_buyer
    sql: ${TABLE}.z_mailorder_buyer
  - dimension: z_mob
    sql: ${TABLE}.z_mob
  - dimension: z_mob_books
    sql: ${TABLE}.z_mob_books
  - dimension: z_mob_garden
    sql: ${TABLE}.z_mob_garden
  - dimension: z_mob_gifts
    sql: ${TABLE}.z_mob_gifts
  - dimension: z_mob_ins
    sql: ${TABLE}.z_mob_ins
  - dimension: z_mob_jew
    sql: ${TABLE}.z_mob_jew
  - dimension: z_mob_music
    sql: ${TABLE}.z_mob_music
  - dimension: z_mob_shoes
    sql: ${TABLE}.z_mob_shoes
  - dimension: z_music
    sql: ${TABLE}.z_music
  - dimension: z_mutual
    sql: ${TABLE}.z_mutual
  - dimension: z_oldies
    sql: ${TABLE}.z_oldies
  - dimension: z_online
    sql: ${TABLE}.z_online
  - dimension: z_outdoor
    sql: ${TABLE}.z_outdoor
  - dimension: z_personal
    sql: ${TABLE}.z_personal
  - dimension: z_pet
    sql: ${TABLE}.z_pet
  - dimension: z_photo
    sql: ${TABLE}.z_photo
  - dimension: z_politic
    sql: ${TABLE}.z_politic
  - dimension: z_premium_credit
    sql: ${TABLE}.z_premium_credit
  - dimension: z_pres_auto
    sql: ${TABLE}.z_pres_auto
  - dimension: z_pres_of_cell
    sql: ${TABLE}.z_pres_of_cell
  - dimension: z_reading
    sql: ${TABLE}.z_reading
  - dimension: z_reg_drugs
    sql: ${TABLE}.z_reg_drugs
  - dimension: z_religion
    sql: ${TABLE}.z_religion
  - dimension: z_rock
    sql: ${TABLE}.z_rock
  - dimension: z_self_improv
    sql: ${TABLE}.z_self_improv
  - dimension: z_skiing
    sql: ${TABLE}.z_skiing
  - dimension: z_sports
    sql: ${TABLE}.z_sports
  - dimension: z_sweeps
    sql: ${TABLE}.z_sweeps
  - dimension: z_tennis
    sql: ${TABLE}.z_tennis
  - dimension: z_travel
    sql: ${TABLE}.z_travel
  - dimension: z_travel_domestic
    sql: ${TABLE}.z_travel_domestic
  - dimension: z_travel_foreign
    sql: ${TABLE}.z_travel_foreign
  - dimension: z_volunteer
    sql: ${TABLE}.z_volunteer
  - dimension: z_weight
    sql: ${TABLE}.z_weight
  - measure: count_with_sq_footage
    type: count
    filters:
    - rsiz_lasf: '>0'
  - measure: count_with_building_construction
    type: count
    filters:
    - rchr_bldc: -Unknown,-Unexpected
  - measure: percent_with_sq_footage
    type: number
    sql: 100.0 * ${count_with_sq_footage} / NULLIF(${count}, 0)
  - measure: percent_with_building_construction
    type: number
    sql: 100.0 * ${count_with_building_construction} / NULLIF(${count}, 0)
  - measure: dwelling_single_family_count
    type: count
    filters:
    - dwelling_type: S
  - measure: dwelling_multi_family_count
    type: count
    filters:
    - dwelling_type: A
  - measure: astrology_interest_count
    type: count
    filters:
    - z_astrolgy: Y
  - measure: count_with_home_ownership_data
    type: count
    filters:
    - home_ownership: -unknown
  - measure: percent_with_home_ownership_data
    type: number
    sql: 100.0 * ${count_with_home_ownership_data} / NULLIF(${count}, 0)
  - measure: count
    type: count
    drill_fields:
    - stat_abbr
    - countyname
    - rchr_airc
    - rchr_heat