{"data":{"schemaVersion":"realm.temporal-relationships.v1","temporalSemantics":{"validTime":{"granularity":"date","bounds":"inclusive","nullStart":"start date not published in the upstream history row","nullEnd":"open-ended in the upstream history row; not independent proof of present control"},"transactionTime":{"observedAt":"2026-10-13T11:19:05.459773+00:00","meaning":"time the checksum-addressed MDRS artifacts were observed by the PostgreSQL ingestion"},"derivation":{"controllerControlsOperator":"intersection of controller and operator valid-time intervals evidenced through this mine","currentIdentity":"current controller and operator are asserted only by the MDRS Mines snapshot"}},"current":{"mine":{"type":"mine","id":"0405727","name":"Orosi Quarry"},"operator":{"type":"operator","id":"L00039","name":"Granite Construction Company"},"controller":{"type":"controller","id":"M00079","name":"Granite Construction Inc"},"source":{"datasetId":"msha-mines","observedAt":"2026-10-13T11:19:05.459773+00:00"}},"edges":[{"type":"controller_controls_mine","subject":{"type":"controller","id":"M00079","name":"Granite Construction Inc"},"object":{"type":"mine","id":"0405727","name":"Orosi Quarry"},"validFrom":"1950-01-01","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0405727|M00079|1950-01-01|"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"0082104","name":"Orosi Rock, LLC"},"object":{"type":"mine","id":"0405727","name":"Orosi Quarry"},"validFrom":"2007-07-17","validTo":"2010-07-11","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0405727|0082104|2007-07-17|2010-07-11"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0069211","name":"Jim  Wood et al"},"object":{"type":"mine","id":"0405727","name":"Orosi Quarry"},"validFrom":"2007-07-17","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0405727|0069211|2007-07-17|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0069211","name":"Jim  Wood et al"},"object":{"type":"operator","id":"0082104","name":"Orosi Rock, LLC"},"validFrom":"2007-07-17","validTo":"2010-07-11","current":false,"derived":true,"evidenceMineId":"0405727","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0405727|0082104|2007-07-17|0069211|2007-07-17|9813"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0069211","name":"Dave  Pinnezatto et al"},"object":{"type":"operator","id":"0082104","name":"Orosi Rock, LLC"},"validFrom":"2007-07-17","validTo":"2010-07-11","current":false,"derived":true,"evidenceMineId":"0405727","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0405727|0082104|2007-07-17|0069211|2007-07-17|9814"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"0111645","name":"Haynes Equipment LLC"},"object":{"type":"mine","id":"0405727","name":"Orosi Quarry"},"validFrom":"2010-07-12","validTo":"2011-09-26","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0405727|0111645|2010-07-12|2011-09-26"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0094473","name":"Casey  Haynes"},"object":{"type":"mine","id":"0405727","name":"Orosi Quarry"},"validFrom":"2010-07-12","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0405727|0094473|2010-07-12|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0094473","name":"Casey  Haynes"},"object":{"type":"operator","id":"0111645","name":"Haynes Equipment LLC"},"validFrom":"2010-07-12","validTo":"2011-09-26","current":false,"derived":true,"evidenceMineId":"0405727","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0405727|0111645|2010-07-12|0094473|2010-07-12|15455"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"0120629","name":"Sigma Rock"},"object":{"type":"mine","id":"0405727","name":"Orosi Quarry"},"validFrom":"2011-09-27","validTo":"2012-09-30","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0405727|0120629|2011-09-27|2012-09-30"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0069211","name":"Dave  Pinnezatto et al"},"object":{"type":"mine","id":"0405727","name":"Orosi Quarry"},"validFrom":"2011-09-27","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0405727|0069211|2011-09-27|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0069211","name":"Dave  Pinnezatto et al"},"object":{"type":"operator","id":"0120629","name":"Sigma Rock"},"validFrom":"2011-09-27","validTo":"2012-09-30","current":false,"derived":true,"evidenceMineId":"0405727","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0405727|0120629|2011-09-27|0069211|2011-09-27|9815"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0069211","name":"Jim  Wood et al"},"object":{"type":"operator","id":"0120629","name":"Sigma Rock"},"validFrom":"2011-09-27","validTo":"2012-09-30","current":false,"derived":true,"evidenceMineId":"0405727","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0405727|0120629|2011-09-27|0069211|2011-09-27|9816"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"0125554","name":"Papich Construction Company Inc"},"object":{"type":"mine","id":"0405727","name":"Orosi Quarry"},"validFrom":"2012-10-01","validTo":"2026-01-27","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0405727|0125554|2012-10-01|2026-01-27"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0106761","name":"Jason  Papich et al"},"object":{"type":"mine","id":"0405727","name":"Orosi Quarry"},"validFrom":"2012-10-01","validTo":"2025-08-05","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0405727|0106761|2012-10-01|2025-08-05"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0106761","name":"Jason  Papich et al"},"object":{"type":"operator","id":"0125554","name":"Papich Construction Company Inc"},"validFrom":"2012-10-01","validTo":"2025-08-05","current":false,"derived":true,"evidenceMineId":"0405727","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0405727|0125554|2012-10-01|0106761|2012-10-01|18932"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0106761","name":"April  Papich et al"},"object":{"type":"operator","id":"0125554","name":"Papich Construction Company Inc"},"validFrom":"2012-10-01","validTo":"2025-08-05","current":false,"derived":true,"evidenceMineId":"0405727","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0405727|0125554|2012-10-01|0106761|2012-10-01|18933"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M00079","name":"Granite Construction Inc"},"object":{"type":"mine","id":"0405727","name":"Orosi Quarry"},"validFrom":"2025-08-06","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0405727|M00079|2025-08-06|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M00079","name":"Granite Construction Inc"},"object":{"type":"operator","id":"0125554","name":"Papich Construction Company Inc"},"validFrom":"2025-08-06","validTo":"2026-01-27","current":false,"derived":true,"evidenceMineId":"0405727","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0405727|0125554|2012-10-01|M00079|2025-08-06|103744"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L00039","name":"Granite Construction Company"},"object":{"type":"mine","id":"0405727","name":"Orosi Quarry"},"validFrom":"2026-01-28","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0405727|L00039|2026-01-28|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M00079","name":"Granite Construction Inc"},"object":{"type":"operator","id":"L00039","name":"Granite Construction Company"},"validFrom":"2026-01-28","validTo":null,"current":true,"derived":true,"evidenceMineId":"0405727","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0405727|L00039|2026-01-28|M00079|1950-01-01|103636"}}],"coverage":{"historyRecords":9,"edgeCount":20,"intervalAnomalies":0,"sourceDatasetId":"msha-controller-operator-history"}},"meta":{"mineId":"0405727","dataSource":"postgres","snapshotId":"2026-10-13T11:19:05.459773+00:00","completedAt":"2026-10-13T11:26:59.401Z","sourceCount":20,"totalRows":17906804,"relationshipSemantics":"valid time; null validTo means current or open-ended in the source"}}