| Column | Verbose Name | Type | Groupable | Filterable | Is temporal | |
|---|---|---|---|---|---|---|
| Date | None | DATE | ||||
| ZipCode | None | BLOB | ||||
| InspectionCount | None | LONG | ||||
| PositiveCount | None | LONG | ||||
| city | None | BLOB | ||||
| lat | None | DOUBLE | ||||
| lng | None | DOUBLE |
| Metric | Verbose Name | Type | |
|---|---|---|---|
| count | None | None | |
| boost_InspectionCount | boost_InspectionCount | None |
| Table Name | public_LatLng |
|---|---|
| Sql | SELECT Date, UserInfo.ZipCode, InspectionCount, PositiveCount, city, lat, lng FROM UserInfo INNER JOIN LatLngList on UserInfo.ZipCode = LatLngList.zip INNER JOIN InspectionLog on UserInfo.UserId = InspectionLog.UserID |
| Enable Filter Select | False |
| Fetch Values Predicate | None |
| Database | Covit19DB_public |
| Schema | db_covit19 |
| Description | None |
| Owners | [] |
| Main Datetime Column | None |
| Default Endpoint | None |
| Offset | 0 |
| Cache Timeout | None |
| SQL Lab View | True |
| Template parameters | {} |
| Perm | [Covit19DB_public].[public_LatLng](id:11) |
| Associated Charts | [陽性者分布, 検査数分布] |