{"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":"3500454","name":"Alsea Quarries"},"operator":{"type":"operator","id":"0109346","name":"Alsea Quarries 1 LLC"},"controller":{"type":"controller","id":"0092477","name":"George R  Foster; Tracy L  Foster"},"source":{"datasetId":"msha-mines","observedAt":"2026-10-13T11:19:05.459773+00:00"}},"edges":[{"type":"operator_operates_mine","subject":{"type":"operator","id":"L03772","name":"Alsea Lumber Company"},"object":{"type":"mine","id":"3500454","name":"Alsea Quarries"},"validFrom":"1950-01-01","validTo":"1979-07-15","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3500454|L03772|1950-01-01|1979-07-15"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M03021","name":"Norman  Sapp  et al"},"object":{"type":"mine","id":"3500454","name":"Alsea Quarries"},"validFrom":"1950-01-01","validTo":"1979-07-15","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3500454|M03021|1950-01-01|1979-07-15"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M03021","name":"Norman  Sapp  et al"},"object":{"type":"operator","id":"L03772","name":"Alsea Lumber Company"},"validFrom":"1950-01-01","validTo":"1979-07-15","current":false,"derived":true,"evidenceMineId":"3500454","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3500454|L03772|1950-01-01|M03021|1950-01-01|127668"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L03773","name":"Philomath Construction Inc"},"object":{"type":"mine","id":"3500454","name":"Alsea Quarries"},"validFrom":"1979-07-16","validTo":"1981-10-31","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3500454|L03773|1979-07-16|1981-10-31"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M03022","name":"Hobin Leslie R"},"object":{"type":"mine","id":"3500454","name":"Alsea Quarries"},"validFrom":"1979-07-16","validTo":"1981-10-31","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3500454|M03022|1979-07-16|1981-10-31"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M03022","name":"Hobin Leslie R"},"object":{"type":"operator","id":"L03773","name":"Philomath Construction Inc"},"validFrom":"1979-07-16","validTo":"1981-10-31","current":false,"derived":true,"evidenceMineId":"3500454","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3500454|L03773|1979-07-16|M03022|1979-07-16|127669"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L06016","name":"Alsea Quarries"},"object":{"type":"mine","id":"3500454","name":"Alsea Quarries"},"validFrom":"1981-11-01","validTo":"1997-11-18","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3500454|L06016|1981-11-01|1997-11-18"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M02313","name":"Ray  Perin"},"object":{"type":"mine","id":"3500454","name":"Alsea Quarries"},"validFrom":"1981-11-01","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3500454|M02313|1981-11-01|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M02313","name":"Ray  Perin"},"object":{"type":"operator","id":"L06016","name":"Alsea Quarries"},"validFrom":"1981-11-01","validTo":"1997-11-18","current":false,"derived":true,"evidenceMineId":"3500454","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3500454|L06016|1981-11-01|M02313|1981-11-01|124754"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M08953","name":"Lloyd S  Hockema"},"object":{"type":"mine","id":"3500454","name":"Alsea Quarries"},"validFrom":"1990-01-17","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3500454|M08953|1990-01-17|"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L11588","name":"Lloyd S Hockema Inc"},"object":{"type":"mine","id":"3500454","name":"Alsea Quarries"},"validFrom":"1997-11-19","validTo":"2000-09-30","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3500454|L11588|1997-11-19|2000-09-30"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M08953","name":"Lloyd S  Hockema"},"object":{"type":"operator","id":"L11588","name":"Lloyd S Hockema Inc"},"validFrom":"1997-11-19","validTo":"2000-09-30","current":false,"derived":true,"evidenceMineId":"3500454","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3500454|L11588|1997-11-19|M08953|1990-01-17|144720"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L06016","name":"Alsea Quarries"},"object":{"type":"mine","id":"3500454","name":"Alsea Quarries"},"validFrom":"2000-10-01","validTo":"2010-04-08","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3500454|L06016|2000-10-01|2010-04-08"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M02313","name":"Ray  Perin"},"object":{"type":"operator","id":"L06016","name":"Alsea Quarries"},"validFrom":"2000-10-01","validTo":"2010-04-08","current":false,"derived":true,"evidenceMineId":"3500454","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3500454|L06016|2000-10-01|M02313|1981-11-01|124755"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"0109346","name":"Alsea Quarries 1 LLC"},"object":{"type":"mine","id":"3500454","name":"Alsea Quarries"},"validFrom":"2010-04-09","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3500454|0109346|2010-04-09|"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0092477","name":"Tracy L  Foster et al"},"object":{"type":"mine","id":"3500454","name":"Alsea Quarries"},"validFrom":"2010-04-09","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3500454|0092477|2010-04-09|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0092477","name":"Tracy L  Foster et al"},"object":{"type":"operator","id":"0109346","name":"Alsea Quarries 1 LLC"},"validFrom":"2010-04-09","validTo":null,"current":true,"derived":true,"evidenceMineId":"3500454","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3500454|0109346|2010-04-09|0092477|2010-04-09|15160"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0092477","name":"George R  Foster et al"},"object":{"type":"operator","id":"0109346","name":"Alsea Quarries 1 LLC"},"validFrom":"2010-04-09","validTo":null,"current":true,"derived":true,"evidenceMineId":"3500454","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3500454|0109346|2010-04-09|0092477|2010-04-09|15161"}}],"coverage":{"historyRecords":7,"edgeCount":18,"intervalAnomalies":0,"sourceDatasetId":"msha-controller-operator-history"}},"meta":{"mineId":"3500454","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"}}