{"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":"1102895","name":"Madison County Sand LLC"},"operator":{"type":"operator","id":"0116265","name":"Madison County Sand LLC"},"controller":{"type":"controller","id":"M01605","name":"T & T Oil Company Inc; Shakespeare Oil Company Inc"},"source":{"datasetId":"msha-mines","observedAt":"2026-10-13T11:19:05.459773+00:00"}},"edges":[{"type":"controller_controls_mine","subject":{"type":"controller","id":"M03604","name":"Sand Inc"},"object":{"type":"mine","id":"1102895","name":"Madison County Sand LLC"},"validFrom":"1980-07-24","validTo":"2002-07-31","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1102895|M03604|1980-07-24|2002-07-31"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L04471","name":"Quality Sand, Inc."},"object":{"type":"mine","id":"1102895","name":"Madison County Sand LLC"},"validFrom":"1990-05-01","validTo":"2010-12-28","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1102895|L04471|1990-05-01|2010-12-28"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M03604","name":"Sand Inc"},"object":{"type":"operator","id":"L04471","name":"Quality Sand, Inc."},"validFrom":"1990-05-01","validTo":"2002-07-31","current":false,"derived":true,"evidenceMineId":"1102895","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1102895|L04471|1990-05-01|M03604|1980-07-24|129468"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M07265","name":"Fred Weber, Inc."},"object":{"type":"mine","id":"1102895","name":"Madison County Sand LLC"},"validFrom":"2002-08-01","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1102895|M07265|2002-08-01|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M07265","name":"Fred Weber, Inc."},"object":{"type":"operator","id":"L04471","name":"Quality Sand, Inc."},"validFrom":"2002-08-01","validTo":"2010-12-28","current":false,"derived":true,"evidenceMineId":"1102895","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1102895|L04471|1990-05-01|M07265|2002-08-01|140534"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"0116265","name":"Madison County Sand LLC"},"object":{"type":"mine","id":"1102895","name":"Madison County Sand LLC"},"validFrom":"2010-12-29","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1102895|0116265|2010-12-29|"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M01605","name":"Shakespeare Oil Company Inc et al"},"object":{"type":"mine","id":"1102895","name":"Madison County Sand LLC"},"validFrom":"2010-12-29","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1102895|M01605|2010-12-29|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M01605","name":"Shakespeare Oil Company Inc et al"},"object":{"type":"operator","id":"0116265","name":"Madison County Sand LLC"},"validFrom":"2010-12-29","validTo":null,"current":true,"derived":true,"evidenceMineId":"1102895","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1102895|0116265|2010-12-29|M01605|2010-12-29|119592"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M01605","name":"T & T Oil Company Inc et al"},"object":{"type":"operator","id":"0116265","name":"Madison County Sand LLC"},"validFrom":"2010-12-29","validTo":null,"current":true,"derived":true,"evidenceMineId":"1102895","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1102895|0116265|2010-12-29|M01605|2010-12-29|119593"}}],"coverage":{"historyRecords":4,"edgeCount":9,"intervalAnomalies":0,"sourceDatasetId":"msha-controller-operator-history"}},"meta":{"mineId":"1102895","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"}}