{"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":"4500671","name":"Avery Pit"},"operator":{"type":"operator","id":"L18224","name":"Pacific Northwest Aggregates Inc"},"controller":{"type":"controller","id":"M37998","name":"R B Pamplin Corp"},"source":{"datasetId":"msha-mines","observedAt":"2026-10-13T11:19:05.459773+00:00"}},"edges":[{"type":"operator_operates_mine","subject":{"type":"operator","id":"L12306","name":"Pacific Northwest Aggregates Inc"},"object":{"type":"mine","id":"4500671","name":"Avery Pit"},"validFrom":"1950-01-01","validTo":"1990-11-30","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4500671|L12306|1950-01-01|1990-11-30"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M09453","name":"Craig  Warnock"},"object":{"type":"mine","id":"4500671","name":"Avery Pit"},"validFrom":"1950-01-01","validTo":"1994-10-03","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4500671|M09453|1950-01-01|1994-10-03"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M09453","name":"Craig  Warnock"},"object":{"type":"operator","id":"L12306","name":"Pacific Northwest Aggregates Inc"},"validFrom":"1950-01-01","validTo":"1990-11-30","current":false,"derived":true,"evidenceMineId":"4500671","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4500671|L12306|1950-01-01|M09453|1950-01-01|146413"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L12307","name":"Dalles Concrete Inc"},"object":{"type":"mine","id":"4500671","name":"Avery Pit"},"validFrom":"1990-12-01","validTo":"1992-10-26","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4500671|L12307|1990-12-01|1992-10-26"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M09454","name":"Fred W  Ashley"},"object":{"type":"mine","id":"4500671","name":"Avery Pit"},"validFrom":"1990-12-01","validTo":"1996-11-30","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4500671|M09454|1990-12-01|1996-11-30"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M09454","name":"Fred W  Ashley"},"object":{"type":"operator","id":"L12307","name":"Dalles Concrete Inc"},"validFrom":"1990-12-01","validTo":"1992-10-26","current":false,"derived":true,"evidenceMineId":"4500671","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4500671|L12307|1990-12-01|M09454|1990-12-01|146415"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L12306","name":"Pacific Northwest Aggregates Inc"},"object":{"type":"mine","id":"4500671","name":"Avery Pit"},"validFrom":"1992-10-27","validTo":"1994-10-03","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4500671|L12306|1992-10-27|1994-10-03"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M09453","name":"Craig  Warnock"},"object":{"type":"operator","id":"L12306","name":"Pacific Northwest Aggregates Inc"},"validFrom":"1992-10-27","validTo":"1994-10-03","current":false,"derived":true,"evidenceMineId":"4500671","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4500671|L12306|1992-10-27|M09453|1950-01-01|146414"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L12307","name":"Dalles Concrete Inc"},"object":{"type":"mine","id":"4500671","name":"Avery Pit"},"validFrom":"1994-10-04","validTo":"1996-11-30","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4500671|L12307|1994-10-04|1996-11-30"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M09454","name":"Fred W  Ashley"},"object":{"type":"operator","id":"L12307","name":"Dalles Concrete Inc"},"validFrom":"1994-10-04","validTo":"1996-11-30","current":false,"derived":true,"evidenceMineId":"4500671","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4500671|L12307|1994-10-04|M09454|1990-12-01|146416"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L15444","name":"Pacific Northwest Aggregates Inc"},"object":{"type":"mine","id":"4500671","name":"Avery Pit"},"validFrom":"1996-12-01","validTo":"1999-02-23","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4500671|L15444|1996-12-01|1999-02-23"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M11775","name":"Randy A Dyche et al"},"object":{"type":"mine","id":"4500671","name":"Avery Pit"},"validFrom":"1996-12-01","validTo":"1999-02-23","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4500671|M11775|1996-12-01|1999-02-23"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M11775","name":"Randy A Dyche et al"},"object":{"type":"operator","id":"L15444","name":"Pacific Northwest Aggregates Inc"},"validFrom":"1996-12-01","validTo":"1999-02-23","current":false,"derived":true,"evidenceMineId":"4500671","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4500671|L15444|1996-12-01|M11775|1996-12-01|152379"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L16394","name":"Tripco Inc"},"object":{"type":"mine","id":"4500671","name":"Avery Pit"},"validFrom":"1999-02-24","validTo":"2000-06-30","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4500671|L16394|1999-02-24|2000-06-30"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M12540","name":"Ross  Triplett"},"object":{"type":"mine","id":"4500671","name":"Avery Pit"},"validFrom":"1999-02-24","validTo":"2021-06-29","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4500671|M12540|1999-02-24|2021-06-29"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M12540","name":"Ross  Triplett"},"object":{"type":"operator","id":"L16394","name":"Tripco Inc"},"validFrom":"1999-02-24","validTo":"2000-06-30","current":false,"derived":true,"evidenceMineId":"4500671","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4500671|L16394|1999-02-24|M12540|1999-02-24|153975"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L17736","name":"Pacific Northwest Aggregates Inc"},"object":{"type":"mine","id":"4500671","name":"Avery Pit"},"validFrom":"2000-07-01","validTo":"2001-03-18","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4500671|L17736|2000-07-01|2001-03-18"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M13528","name":"Ty  Ross et al"},"object":{"type":"mine","id":"4500671","name":"Avery Pit"},"validFrom":"2000-07-01","validTo":"2001-03-18","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4500671|M13528|2000-07-01|2001-03-18"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M13528","name":"Ty  Ross et al"},"object":{"type":"operator","id":"L17736","name":"Pacific Northwest Aggregates Inc"},"validFrom":"2000-07-01","validTo":"2001-03-18","current":false,"derived":true,"evidenceMineId":"4500671","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4500671|L17736|2000-07-01|M13528|2000-07-01|156425"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L18224","name":"Pacific Northwest Aggregates Inc"},"object":{"type":"mine","id":"4500671","name":"Avery Pit"},"validFrom":"2001-03-19","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4500671|L18224|2001-03-19|"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M14011","name":"Ross Island Sand & Gravel Company"},"object":{"type":"mine","id":"4500671","name":"Avery Pit"},"validFrom":"2001-03-19","validTo":"2001-12-31","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4500671|M14011|2001-03-19|2001-12-31"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M14011","name":"Ross Island Sand & Gravel Company"},"object":{"type":"operator","id":"L18224","name":"Pacific Northwest Aggregates Inc"},"validFrom":"2001-03-19","validTo":"2001-12-31","current":false,"derived":true,"evidenceMineId":"4500671","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4500671|L18224|2001-03-19|M14011|2001-03-19|157306"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M37998","name":"R B Pamplin Corp"},"object":{"type":"mine","id":"4500671","name":"Avery Pit"},"validFrom":"2002-01-01","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4500671|M37998|2002-01-01|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M37998","name":"R B Pamplin Corp"},"object":{"type":"operator","id":"L18224","name":"Pacific Northwest Aggregates Inc"},"validFrom":"2002-01-01","validTo":null,"current":true,"derived":true,"evidenceMineId":"4500671","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4500671|L18224|2001-03-19|M37998|2002-01-01|167329"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0144021","name":"Case E  Stedham"},"object":{"type":"mine","id":"4500671","name":"Avery Pit"},"validFrom":"2021-06-30","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4500671|0144021|2021-06-30|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0144021","name":"Case E  Stedham"},"object":{"type":"operator","id":"L16394","name":"Tripco Inc"},"validFrom":"2021-06-30","validTo":"2000-06-30","current":false,"derived":true,"evidenceMineId":"4500671","intervalAnomaly":true,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4500671|L16394|1999-02-24|0144021|2021-06-30|29192"}}],"coverage":{"historyRecords":10,"edgeCount":26,"intervalAnomalies":1,"sourceDatasetId":"msha-controller-operator-history"}},"meta":{"mineId":"4500671","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"}}