-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathjhu_covid_19.view.lkml
98 lines (83 loc) · 1.47 KB
/
jhu_covid_19.view.lkml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
view: jhu_covid_19 {
sql_table_name: "PUBLIC"."JHU_COVID_19"
;;
dimension: case_type {
type: string
sql: ${TABLE}."CASE_TYPE" ;;
}
dimension: cases {
type: number
sql: ${TABLE}."CASES" ;;
}
dimension: country_region {
type: string
sql: ${TABLE}."COUNTRY_REGION" ;;
}
dimension: county {
type: string
sql: ${TABLE}."COUNTY" ;;
}
dimension_group: date {
type: time
timeframes: [
raw,
date,
week,
month,
quarter,
year
]
convert_tz: no
datatype: date
sql: ${TABLE}."DATE" ;;
}
dimension: difference {
type: number
sql: ${TABLE}."DIFFERENCE" ;;
}
dimension: fips {
type: string
sql: ${TABLE}."FIPS" ;;
}
dimension: iso3166_1 {
type: string
sql: ${TABLE}."ISO3166_1" ;;
}
dimension: iso3166_2 {
type: string
sql: ${TABLE}."ISO3166_2" ;;
}
dimension: last_reported_flag {
type: yesno
sql: ${TABLE}."LAST_REPORTED_FLAG" ;;
}
dimension_group: last_updated {
type: time
timeframes: [
raw,
time,
date,
week,
month,
quarter,
year
]
sql: ${TABLE}."LAST_UPDATED_DATE" ;;
}
dimension: lat {
type: number
sql: ${TABLE}."LAT" ;;
}
dimension: long {
type: number
sql: ${TABLE}."LONG" ;;
}
dimension: province_state {
type: string
sql: ${TABLE}."PROVINCE_STATE" ;;
}
measure: count {
type: count
drill_fields: []
}
}