{"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":"0801342","name":"SG&G Sand LLC"},"operator":{"type":"operator","id":"0123371","name":"SG&G Sand LLC"},"controller":{"type":"controller","id":"0104795","name":"Ginger  Spivey"},"source":{"datasetId":"msha-mines","observedAt":"2026-10-13T11:19:05.459773+00:00"}},"edges":[{"type":"operator_operates_mine","subject":{"type":"operator","id":"0076084","name":"Brown & Hamilton LLC"},"object":{"type":"mine","id":"0801342","name":"SG&G Sand LLC"},"validFrom":"2006-10-17","validTo":"2008-07-07","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0801342|0076084|2006-10-17|2008-07-07"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0063869","name":"Carl T  Hamilton  et al"},"object":{"type":"mine","id":"0801342","name":"SG&G Sand LLC"},"validFrom":"2006-10-17","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0801342|0063869|2006-10-17|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0063869","name":"Carl T  Hamilton  et al"},"object":{"type":"operator","id":"0076084","name":"Brown & Hamilton LLC"},"validFrom":"2006-10-17","validTo":"2008-07-07","current":false,"derived":true,"evidenceMineId":"0801342","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0801342|0076084|2006-10-17|0063869|2006-10-17|8728"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0063869","name":"Owen C  Brown  et al"},"object":{"type":"operator","id":"0076084","name":"Brown & Hamilton LLC"},"validFrom":"2006-10-17","validTo":"2008-07-07","current":false,"derived":true,"evidenceMineId":"0801342","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0801342|0076084|2006-10-17|0063869|2006-10-17|8729"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"0092065","name":"Brown Sand Company"},"object":{"type":"mine","id":"0801342","name":"SG&G Sand LLC"},"validFrom":"2008-07-08","validTo":"2009-08-18","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0801342|0092065|2008-07-08|2009-08-18"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0077253","name":"Owen C  Brown"},"object":{"type":"mine","id":"0801342","name":"SG&G Sand LLC"},"validFrom":"2008-07-08","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0801342|0077253|2008-07-08|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0077253","name":"Owen C  Brown"},"object":{"type":"operator","id":"0092065","name":"Brown Sand Company"},"validFrom":"2008-07-08","validTo":"2009-08-18","current":false,"derived":true,"evidenceMineId":"0801342","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0801342|0092065|2008-07-08|0077253|2008-07-08|12110"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"0103545","name":"SG&G Sand LLC"},"object":{"type":"mine","id":"0801342","name":"SG&G Sand LLC"},"validFrom":"2009-08-19","validTo":"2012-05-20","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0801342|0103545|2009-08-19|2012-05-20"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0087593","name":"Carl  Hamilton"},"object":{"type":"mine","id":"0801342","name":"SG&G Sand LLC"},"validFrom":"2009-08-19","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0801342|0087593|2009-08-19|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0087593","name":"Carl  Hamilton"},"object":{"type":"operator","id":"0103545","name":"SG&G Sand LLC"},"validFrom":"2009-08-19","validTo":"2012-05-20","current":false,"derived":true,"evidenceMineId":"0801342","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0801342|0103545|2009-08-19|0087593|2009-08-19|14091"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"0123371","name":"SG&G Sand LLC"},"object":{"type":"mine","id":"0801342","name":"SG&G Sand LLC"},"validFrom":"2012-05-21","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0801342|0123371|2012-05-21|"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0104795","name":"Ginger  Spivey"},"object":{"type":"mine","id":"0801342","name":"SG&G Sand LLC"},"validFrom":"2012-05-21","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0801342|0104795|2012-05-21|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0104795","name":"Ginger  Spivey"},"object":{"type":"operator","id":"0123371","name":"SG&G Sand LLC"},"validFrom":"2012-05-21","validTo":null,"current":true,"derived":true,"evidenceMineId":"0801342","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0801342|0123371|2012-05-21|0104795|2012-05-21|18313"}}],"coverage":{"historyRecords":5,"edgeCount":13,"intervalAnomalies":0,"sourceDatasetId":"msha-controller-operator-history"}},"meta":{"mineId":"0801342","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"}}