data.ml
LKML Education university

Court Offhist

Court Offhist model for education university.

inferred

Blocks

court_offhist.view.lkml · 106 lines
inferred 
view: court_offhist {
  sql_table_name: poc_db.PUBLIC.COURT_OFFHIST ;;

  dimension: caseid {
    sql: ${TABLE}.CASEID ;;
  }

  dimension: casenumber {
    sql: ${TABLE}.CASENUMBER ;;
  }

  dimension: chargeid {
    sql: ${TABLE}.CHARGEID ;;
  }

  dimension: chargenumber {
    sql: ${TABLE}.CHARGENUMBER ;;
  }

  dimension: degree {
    sql: ${TABLE}.DEGREE ;;
  }

  dimension: degreecodeid {
    sql: ${TABLE}.DEGREECODEID ;;
  }

  dimension: description {
    sql: ${TABLE}.DESCRIPTION ;;
  }

  dimension: dispcode {
    sql: ${TABLE}.DISPCODE ;;
  }

  dimension: dispcodeid {
    sql: ${TABLE}.DISPCODEID ;;
  }

  dimension: disposition {
    sql: ${TABLE}.DISPOSITION ;;
  }

  dimension: eventid {
    sql: ${TABLE}.EVENTID ;;
  }

  dimension: judge {
    sql: ${TABLE}.JUDGE ;;
  }

  dimension: judgeid {
    sql: ${TABLE}.JUDGEID ;;
  }

  dimension: offensecode {
    sql: ${TABLE}.OFFENSECODE ;;
  }

  dimension: offensehistoryid {
    sql: ${TABLE}.OFFENSEHISTORYID ;;
  }

  dimension: offenseid {
    sql: ${TABLE}.OFFENSEID ;;
  }

  dimension: offensestage {
    sql: ${TABLE}.OFFENSESTAGE ;;
  }

  dimension: offensestageid {
    sql: ${TABLE}.OFFENSESTAGEID ;;
  }

  dimension: partyid {
    sql: ${TABLE}.PARTYID ;;
  }

  dimension: plea {
    sql: ${TABLE}.PLEA ;;
  }

  dimension: pleacode {
    sql: ${TABLE}.PLEACODE ;;
  }

  dimension: pleacodeid {
    sql: ${TABLE}.PLEACODEID ;;
  }

  dimension: statute {
    sql: ${TABLE}.STATUTE ;;
  }

  dimension_group: eventdate {
    type: time
    timeframes: [date, week, month]
    convert_tz: no
    sql: ${TABLE}.EVENTDATE ;;
  }

  measure: count {
    type: count
  }
}
court_offhist.view.lookml · 59 lines
source-preserved 
- view: court_offhist
  sql_table_name: poc_db.PUBLIC.COURT_OFFHIST
  fields:
  - dimension: caseid
    sql: ${TABLE}.CASEID
  - dimension: casenumber
    sql: ${TABLE}.CASENUMBER
  - dimension: chargeid
    sql: ${TABLE}.CHARGEID
  - dimension: chargenumber
    sql: ${TABLE}.CHARGENUMBER
  - dimension: degree
    sql: ${TABLE}.DEGREE
  - dimension: degreecodeid
    sql: ${TABLE}.DEGREECODEID
  - dimension: description
    sql: ${TABLE}.DESCRIPTION
  - dimension: dispcode
    sql: ${TABLE}.DISPCODE
  - dimension: dispcodeid
    sql: ${TABLE}.DISPCODEID
  - dimension: disposition
    sql: ${TABLE}.DISPOSITION
  - dimension: eventid
    sql: ${TABLE}.EVENTID
  - dimension: judge
    sql: ${TABLE}.JUDGE
  - dimension: judgeid
    sql: ${TABLE}.JUDGEID
  - dimension: offensecode
    sql: ${TABLE}.OFFENSECODE
  - dimension: offensehistoryid
    sql: ${TABLE}.OFFENSEHISTORYID
  - dimension: offenseid
    sql: ${TABLE}.OFFENSEID
  - dimension: offensestage
    sql: ${TABLE}.OFFENSESTAGE
  - dimension: offensestageid
    sql: ${TABLE}.OFFENSESTAGEID
  - dimension: partyid
    sql: ${TABLE}.PARTYID
  - dimension: plea
    sql: ${TABLE}.PLEA
  - dimension: pleacode
    sql: ${TABLE}.PLEACODE
  - dimension: pleacodeid
    sql: ${TABLE}.PLEACODEID
  - dimension: statute
    sql: ${TABLE}.STATUTE
  - dimension_group: eventdate
    type: time
    timeframes:
    - date
    - week
    - month
    convert_tz: false
    sql: ${TABLE}.EVENTDATE
  - measure: count
    type: count

Contents

  • court_offhist.view.lkml
  • court_offhist.view.lookml