data.ml
LKML Education university

Court Sentence

Court Sentence model for education university.

inferred

Blocks

court_sentence.view.lkml · 50 lines
inferred 
view: court_sentence {
  sql_table_name: poc_db.PUBLIC.COURT_SENTENCE ;;

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

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

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

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

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

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

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

  dimension: sentenceeventid {
    sql: ${TABLE}.SENTENCEEVENTID ;;
  }

  dimension: sentenceid {
    sql: ${TABLE}.SENTENCEID ;;
  }

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

  measure: count {
    type: count
  }
}
court_sentence.view.lookml · 31 lines
source-preserved 
- view: court_sentence
  sql_table_name: poc_db.PUBLIC.COURT_SENTENCE
  fields:
  - dimension: caseid
    sql: ${TABLE}.CASEID
  - dimension: casenumber
    sql: ${TABLE}.CASENUMBER
  - dimension: chargeid
    sql: ${TABLE}.CHARGEID
  - dimension: judge
    sql: ${TABLE}.JUDGE
  - dimension: judgeid
    sql: ${TABLE}.JUDGEID
  - dimension: offensehistoryid
    sql: ${TABLE}.OFFENSEHISTORYID
  - dimension: offensestageid
    sql: ${TABLE}.OFFENSESTAGEID
  - dimension: sentenceeventid
    sql: ${TABLE}.SENTENCEEVENTID
  - dimension: sentenceid
    sql: ${TABLE}.SENTENCEID
  - dimension_group: sentencedate
    type: time
    timeframes:
    - date
    - week
    - month
    convert_tz: false
    sql: ${TABLE}.SENTENCEDATE
  - measure: count
    type: count

Contents

  • court_sentence.view.lkml
  • court_sentence.view.lookml