{"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":"1401414","name":"Hanover Sand Plant"},"operator":{"type":"operator","id":"0210033","name":"Capital Ready-Mix, LLC"},"controller":{"type":"controller","id":"0201180","name":"Eric  Bettis"},"source":{"datasetId":"msha-mines","observedAt":"2026-10-13T11:19:05.459773+00:00"}},"edges":[{"type":"controller_controls_mine","subject":{"type":"controller","id":"M05018","name":"Mueller Emil H"},"object":{"type":"mine","id":"1401414","name":"Hanover Sand Plant"},"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":"1401414|M05018|1950-01-01|"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L06291","name":"Mueller Sand & Gravel Company Inc"},"object":{"type":"mine","id":"1401414","name":"Hanover Sand Plant"},"validFrom":"1981-12-01","validTo":"1996-10-31","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401414|L06291|1981-12-01|1996-10-31"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M05018","name":"Mueller Emil H"},"object":{"type":"operator","id":"L06291","name":"Mueller Sand & Gravel Company Inc"},"validFrom":"1981-12-01","validTo":"1996-10-31","current":false,"derived":true,"evidenceMineId":"1401414","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401414|L06291|1981-12-01|M05018|1950-01-01|133450"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L14999","name":"Midwest Materials By Mueller Inc"},"object":{"type":"mine","id":"1401414","name":"Hanover Sand Plant"},"validFrom":"1996-11-01","validTo":"2026-06-30","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401414|L14999|1996-11-01|2026-06-30"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M11417","name":"Jay  Holle et al"},"object":{"type":"mine","id":"1401414","name":"Hanover Sand Plant"},"validFrom":"1996-11-01","validTo":"2020-10-12","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401414|M11417|1996-11-01|2020-10-12"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M11417","name":"Jay  Holle et al"},"object":{"type":"operator","id":"L14999","name":"Midwest Materials By Mueller Inc"},"validFrom":"1996-11-01","validTo":"2020-10-12","current":false,"derived":true,"evidenceMineId":"1401414","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401414|L14999|1996-11-01|M11417|1996-11-01|151367"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M11417","name":"Manetha  Holle et al"},"object":{"type":"operator","id":"L14999","name":"Midwest Materials By Mueller Inc"},"validFrom":"1996-11-01","validTo":"2020-10-12","current":false,"derived":true,"evidenceMineId":"1401414","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401414|L14999|1996-11-01|M11417|1996-11-01|151368"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0159021","name":"Jay  Holle"},"object":{"type":"mine","id":"1401414","name":"Hanover Sand Plant"},"validFrom":"2020-10-13","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401414|0159021|2020-10-13|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0159021","name":"Jay  Holle"},"object":{"type":"operator","id":"L14999","name":"Midwest Materials By Mueller Inc"},"validFrom":"2020-10-13","validTo":"2026-06-30","current":false,"derived":true,"evidenceMineId":"1401414","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401414|L14999|1996-11-01|0159021|2020-10-13|33037"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"0210033","name":"Capital Ready-Mix, LLC"},"object":{"type":"mine","id":"1401414","name":"Hanover Sand Plant"},"validFrom":"2026-07-01","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401414|0210033|2026-07-01|"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0201180","name":"Eric  Bettis"},"object":{"type":"mine","id":"1401414","name":"Hanover Sand Plant"},"validFrom":"2026-07-01","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401414|0201180|2026-07-01|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0201180","name":"Eric  Bettis"},"object":{"type":"operator","id":"0210033","name":"Capital Ready-Mix, LLC"},"validFrom":"2026-07-01","validTo":null,"current":true,"derived":true,"evidenceMineId":"1401414","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401414|0210033|2026-07-01|0201180|2026-07-01|42739"}}],"coverage":{"historyRecords":5,"edgeCount":12,"intervalAnomalies":0,"sourceDatasetId":"msha-controller-operator-history"}},"meta":{"mineId":"1401414","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"}}