{"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-17T05:35:58.500035+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":"3800130","name":"Columbia Sand"},"operator":{"type":"operator","id":"L16897","name":"Heidelberg Materials SE Agg., LLC"},"controller":{"type":"controller","id":"M00004","name":"Heidelberg Materials AG"},"source":{"datasetId":"msha-mines","observedAt":"2026-10-17T05:35:58.500035+00:00"}},"edges":[{"type":"operator_operates_mine","subject":{"type":"operator","id":"L13217","name":"Foster Dixiana Corporation"},"object":{"type":"mine","id":"3800130","name":"Columbia Sand"},"validFrom":"1950-01-01","validTo":"2007-10-19","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"3800130|L13217|1950-01-01|2007-10-19"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M01263","name":"Larry  Forsell  et al"},"object":{"type":"mine","id":"3800130","name":"Columbia Sand"},"validFrom":"1950-01-01","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"3800130|M01263|1950-01-01|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M01263","name":"Larry  Forsell  et al"},"object":{"type":"operator","id":"L13217","name":"Foster Dixiana Corporation"},"validFrom":"1950-01-01","validTo":"2007-10-19","current":false,"derived":true,"evidenceMineId":"3800130","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"3800130|L13217|1950-01-01|M01263|1950-01-01|117730"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M00521","name":"Hanson PLC"},"object":{"type":"mine","id":"3800130","name":"Columbia Sand"},"validFrom":"1988-11-14","validTo":"2007-08-22","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"3800130|M00521|1988-11-14|2007-08-22"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M00004","name":"Heidelberg Materials AG"},"object":{"type":"mine","id":"3800130","name":"Columbia Sand"},"validFrom":"2007-08-23","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"3800130|M00004|2007-08-23|"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"0084824","name":"South Carolina Minerals Inc."},"object":{"type":"mine","id":"3800130","name":"Columbia Sand"},"validFrom":"2007-10-20","validTo":"2013-07-28","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"3800130|0084824|2007-10-20|2013-07-28"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M00838","name":"F Browne Gregg Trust"},"object":{"type":"mine","id":"3800130","name":"Columbia Sand"},"validFrom":"2007-10-20","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"3800130|M00838|2007-10-20|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M00838","name":"F Browne Gregg Trust"},"object":{"type":"operator","id":"0084824","name":"South Carolina Minerals Inc."},"validFrom":"2007-10-20","validTo":"2013-07-28","current":false,"derived":true,"evidenceMineId":"3800130","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"3800130|0084824|2007-10-20|M00838|2007-10-20|115269"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"0129393","name":"Carolina Aggregates, LLC"},"object":{"type":"mine","id":"3800130","name":"Columbia Sand"},"validFrom":"2013-07-29","validTo":"2016-08-15","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"3800130|0129393|2013-07-29|2016-08-15"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0110061","name":"Sand Flea LLC et al"},"object":{"type":"mine","id":"3800130","name":"Columbia Sand"},"validFrom":"2013-07-29","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"3800130|0110061|2013-07-29|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0110061","name":"Sand Flea LLC et al"},"object":{"type":"operator","id":"0129393","name":"Carolina Aggregates, LLC"},"validFrom":"2013-07-29","validTo":"2016-08-15","current":false,"derived":true,"evidenceMineId":"3800130","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"3800130|0129393|2013-07-29|0110061|2013-07-29|20117"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0110061","name":"Good Dirt LLC et al"},"object":{"type":"operator","id":"0129393","name":"Carolina Aggregates, LLC"},"validFrom":"2013-07-29","validTo":"2016-08-15","current":false,"derived":true,"evidenceMineId":"3800130","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"3800130|0129393|2013-07-29|0110061|2013-07-29|20118"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L16897","name":"Heidelberg Materials SE Agg., LLC"},"object":{"type":"mine","id":"3800130","name":"Columbia Sand"},"validFrom":"2016-08-16","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"3800130|L16897|2016-08-16|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M00004","name":"Heidelberg Materials AG"},"object":{"type":"operator","id":"L16897","name":"Heidelberg Materials SE Agg., LLC"},"validFrom":"2016-08-16","validTo":null,"current":true,"derived":true,"evidenceMineId":"3800130","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"3800130|L16897|2016-08-16|M00004|2007-08-23|101022"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M00521","name":"Hanson PLC"},"object":{"type":"operator","id":"L16897","name":"Heidelberg Materials SE Agg., LLC"},"validFrom":"2016-08-16","validTo":"2007-08-22","current":false,"derived":true,"evidenceMineId":"3800130","intervalAnomaly":true,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"3800130|L16897|2016-08-16|M00521|1988-11-14|112411"}}],"coverage":{"historyRecords":6,"edgeCount":15,"intervalAnomalies":1,"sourceDatasetId":"msha-controller-operator-history"}},"meta":{"mineId":"3800130","dataSource":"postgres","snapshotId":"2026-10-17T05:35:58.500035+00:00","completedAt":"2026-10-17T06:17:15.228Z","sourceCount":20,"totalRows":15450873,"relationshipSemantics":"valid time; null validTo means current or open-ended in the source"}}