{"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":"1401302","name":"De Soto Sand"},"operator":{"type":"operator","id":"L16197","name":"Martin Marietta Materials, Inc."},"controller":{"type":"controller","id":"M00174","name":"Martin Marietta Materials Inc"},"source":{"datasetId":"msha-mines","observedAt":"2026-10-13T11:19:05.459773+00:00"}},"edges":[{"type":"controller_controls_mine","subject":{"type":"controller","id":"M00174","name":"Martin Marietta Materials Inc"},"object":{"type":"mine","id":"1401302","name":"De Soto Sand"},"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":"1401302|M00174|1950-01-01|"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M00252","name":"N R  Hamm"},"object":{"type":"mine","id":"1401302","name":"De Soto Sand"},"validFrom":"1950-01-01","validTo":"2012-02-08","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401302|M00252|1950-01-01|2012-02-08"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L35115","name":"Kaw Sand Company Inc"},"object":{"type":"mine","id":"1401302","name":"De Soto Sand"},"validFrom":"1979-01-01","validTo":"1995-03-31","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401302|L35115|1979-01-01|1995-03-31"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M35115","name":"David  Penny"},"object":{"type":"mine","id":"1401302","name":"De Soto Sand"},"validFrom":"1979-01-01","validTo":"1995-03-31","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401302|M35115|1979-01-01|1995-03-31"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M35115","name":"David  Penny"},"object":{"type":"operator","id":"L35115","name":"Kaw Sand Company Inc"},"validFrom":"1979-01-01","validTo":"1995-03-31","current":false,"derived":true,"evidenceMineId":"1401302","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401302|L35115|1979-01-01|M35115|1979-01-01|163988"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M09756","name":"Marlene  Penny et al"},"object":{"type":"mine","id":"1401302","name":"De Soto Sand"},"validFrom":"1988-10-01","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401302|M09756|1988-10-01|"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L12726","name":"Penny's Concrete, Inc."},"object":{"type":"mine","id":"1401302","name":"De Soto Sand"},"validFrom":"1995-04-01","validTo":"2011-06-30","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401302|L12726|1995-04-01|2011-06-30"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M09756","name":"Marlene  Penny et al"},"object":{"type":"operator","id":"L12726","name":"Penny's Concrete, Inc."},"validFrom":"1995-04-01","validTo":"2011-06-30","current":false,"derived":true,"evidenceMineId":"1401302","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401302|L12726|1995-04-01|M09756|1988-10-01|147451"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M09756","name":"William  Penny et al"},"object":{"type":"operator","id":"L12726","name":"Penny's Concrete, Inc."},"validFrom":"1995-04-01","validTo":"2011-06-30","current":false,"derived":true,"evidenceMineId":"1401302","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401302|L12726|1995-04-01|M09756|1988-10-01|147452"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"0119098","name":"Penny's Aggregates, Inc."},"object":{"type":"mine","id":"1401302","name":"De Soto Sand"},"validFrom":"2011-07-01","validTo":"2016-12-31","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401302|0119098|2011-07-01|2016-12-31"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M09756","name":"Marlene  Penny et al"},"object":{"type":"mine","id":"1401302","name":"De Soto Sand"},"validFrom":"2011-07-01","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401302|M09756|2011-07-01|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M09756","name":"Marlene  Penny et al"},"object":{"type":"operator","id":"0119098","name":"Penny's Aggregates, Inc."},"validFrom":"2011-07-01","validTo":"2016-12-31","current":false,"derived":true,"evidenceMineId":"1401302","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401302|0119098|2011-07-01|M09756|2011-07-01|147461"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M09756","name":"William  Penny et al"},"object":{"type":"operator","id":"0119098","name":"Penny's Aggregates, Inc."},"validFrom":"2011-07-01","validTo":"2016-12-31","current":false,"derived":true,"evidenceMineId":"1401302","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401302|0119098|2011-07-01|M09756|2011-07-01|147462"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M02046","name":"Summit Materials LLC"},"object":{"type":"mine","id":"1401302","name":"De Soto Sand"},"validFrom":"2012-02-09","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401302|M02046|2012-02-09|"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"0149974","name":"Sahara Sand"},"object":{"type":"mine","id":"1401302","name":"De Soto Sand"},"validFrom":"2017-01-01","validTo":"2021-06-10","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401302|0149974|2017-01-01|2021-06-10"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0132001","name":"Michael  Penny"},"object":{"type":"mine","id":"1401302","name":"De Soto Sand"},"validFrom":"2017-01-01","validTo":"2019-01-31","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401302|0132001|2017-01-01|2019-01-31"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0132001","name":"Michael  Penny"},"object":{"type":"operator","id":"0149974","name":"Sahara Sand"},"validFrom":"2017-01-01","validTo":"2019-01-31","current":false,"derived":true,"evidenceMineId":"1401302","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401302|0149974|2017-01-01|0132001|2017-01-01|26486"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0151861","name":"David M Penny et al"},"object":{"type":"mine","id":"1401302","name":"De Soto Sand"},"validFrom":"2019-02-01","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401302|0151861|2019-02-01|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0151861","name":"David M Penny et al"},"object":{"type":"operator","id":"0149974","name":"Sahara Sand"},"validFrom":"2019-02-01","validTo":"2021-06-10","current":false,"derived":true,"evidenceMineId":"1401302","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401302|0149974|2017-01-01|0151861|2019-02-01|31428"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0151861","name":"Carmiletta  Penny et al"},"object":{"type":"operator","id":"0149974","name":"Sahara Sand"},"validFrom":"2019-02-01","validTo":"2021-06-10","current":false,"derived":true,"evidenceMineId":"1401302","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401302|0149974|2017-01-01|0151861|2019-02-01|31429"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L00313","name":"N R Hamm Quarry LLC"},"object":{"type":"mine","id":"1401302","name":"De Soto Sand"},"validFrom":"2021-06-11","validTo":"2026-03-22","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401302|L00313|2021-06-11|2026-03-22"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M00252","name":"N R  Hamm"},"object":{"type":"operator","id":"L00313","name":"N R Hamm Quarry LLC"},"validFrom":"2021-06-11","validTo":"2012-02-08","current":false,"derived":true,"evidenceMineId":"1401302","intervalAnomaly":true,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401302|L00313|2021-06-11|M00252|1950-01-01|108254"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M02046","name":"Summit Materials LLC"},"object":{"type":"operator","id":"L00313","name":"N R Hamm Quarry LLC"},"validFrom":"2021-06-11","validTo":"2026-03-22","current":false,"derived":true,"evidenceMineId":"1401302","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401302|L00313|2021-06-11|M02046|2012-02-09|122953"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L16197","name":"Martin Marietta Materials, Inc."},"object":{"type":"mine","id":"1401302","name":"De Soto Sand"},"validFrom":"2026-03-23","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401302|L16197|2026-03-23|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M00174","name":"Martin Marietta Materials Inc"},"object":{"type":"operator","id":"L16197","name":"Martin Marietta Materials, Inc."},"validFrom":"2026-03-23","validTo":null,"current":true,"derived":true,"evidenceMineId":"1401302","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401302|L16197|2026-03-23|M00174|1950-01-01|105911"}}],"coverage":{"historyRecords":11,"edgeCount":25,"intervalAnomalies":1,"sourceDatasetId":"msha-controller-operator-history"}},"meta":{"mineId":"1401302","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"}}