From a 500-row sample across 12 columns.
facility| srcincidentid | lockinid | facility | lockinha | lockin_hatype | lockintype | lockinreason | lockincategory | lockin_start_dttm | lockin_end_dttm | lock_in_duration | inmatecount |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 180750 | 520219 | RNDC | 1UN | GP | HA LOCK-IN | Investigation-other | EMERGENCY_LOCKIN | 2023-01-01T05:00:00.000 | 2023-01-01T07:00:00.000 | 120 | 18 |
| 180750 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
srcincidentid | integer | This is the primary key column that uniquely identifies each incident. | 0% | 187089181236181227 |
lockinid | integer | This is the primary key column that uniquely identifies each housing area within an incident. | 0% | 573352587033524004 |
facility | categorical | The name of facility the incident occurred. | 0% | RNDCGRVCOBCCof 8 |
lockinha | text | The housing area involved in the incident. | 0% | 6CN2US6UN |
GET /api/datasets/9dab-x6kn GET /api/datasets/9dab-x6kn/quality GET /api/datasets/9dab-x6kn/related GET /api/columns?dataset=9dab-x6kn
| 520219 |
| RNDC |
| 1UN |
| GP |
| HA LOCK-IN |
| Investigation-other |
| SCHEDULED_LOCKIN |
| 2023-01-01T07:00:00.000 |
| 2023-01-01T08:00:00.000 |
| 60 |
| 18 |
| 180750 | 520331 | RNDC | 6UN | GP | HA LOCK-IN | Investigation-other | EMERGENCY_LOCKIN | 2023-01-01T05:00:00.000 | 2023-01-01T07:00:00.000 | 120 | 16 |
| 180750 | 520331 | RNDC | 6UN | GP | HA LOCK-IN | Investigation-other | SCHEDULED_LOCKIN | 2023-01-01T07:00:00.000 | 2023-01-01T08:00:00.000 | 60 | 16 |
| 180757 | 520268 | RNDC | 4CN | GP | HA LOCK-IN | UOF Investigation | EMERGENCY_LOCKIN | 2023-01-01T10:10:00.000 | 2023-01-01T15:00:00.000 | 290 | 14 |
| 180757 | 520268 | RNDC | 4CN | GP | HA LOCK-IN | UOF Investigation | SCHEDULED_LOCKIN | 2023-01-01T15:00:00.000 | 2023-01-01T16:00:00.000 | 60 | 14 |
| 180764 | 520065 | GRVC | 3A-LOWER | GP | HA LOCK-IN | SRG Activity | SCHEDULED_LOCKIN | 2023-01-01T15:00:00.000 | 2023-01-01T16:00:00.000 | 60 | 2 |
| 180764 | 520065 | GRVC | 3A-LOWER | GP | HA LOCK-IN | SRG Activity | EMERGENCY_LOCKIN | 2023-01-01T16:00:00.000 | 2023-01-01T21:00:00.000 | 300 | 2 |
| 180764 | 520065 | GRVC | 3A-LOWER | GP | HA LOCK-IN | SRG Activity | SCHEDULED_LOCKIN | 2023-01-01T21:00:00.000 | 2023-01-02T05:00:00.000 | 480 | 2 |
| 180764 | 520069 | GRVC | 3A-UPPER | GP | HA LOCK-IN | SRG Activity | SCHEDULED_LOCKIN | 2023-01-01T15:00:00.000 | 2023-01-01T16:00:00.000 | 60 | 3 |
lockin_hatype | categorical | Type of the housing area | 0% | GPRESTRICTIVEof 2 |
lockintype | categorical | Type of emergency lock-in | 0% | HA LOCK-INPARTIAL FACILITY LOCK-INFACILITY LOCK-INof 4 |
lockinreason | categorical | Reason for the emergency lock-in. | 0% | Slashing/StabbingUOF InvestigationOtherof 10 |
lockincategory | categorical | Type of lock-in category | 0% | SCHEDULED_LOCKINEMERGENCY_LOCKINof 2 |
lockin_start_dttm | datetime | Start date & time of the lock-in. | 0% | 2023-01-11T07:00:00.0002023-01-10T21:00:00.0002023-01-11T15:00:00.000 |
lockin_end_dttm | datetime | End date & time of the lock-in | 0% | 2023-01-11T08:00:00.0002023-01-11T05:00:00.0002023-01-11T16:00:00.000 |
lock_in_duration | integer | Duration of lock-in category (minutes) | 0% | 60480120 |
inmatecount | integer | Counts of PICs residing the housing area at time of incident. | 0% | 231822 |