{"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":"1401026","name":"STERLING SAND PIT"},"operator":{"type":"operator","id":"L17126","name":"Sterling Sand & Gravel"},"controller":{"type":"controller","id":"M13058","name":"Marc D  Westhoff"},"source":{"datasetId":"msha-mines","observedAt":"2026-10-13T11:19:05.459773+00:00"}},"edges":[{"type":"operator_operates_mine","subject":{"type":"operator","id":"L01995","name":"Tobias & Birchenough Inc"},"object":{"type":"mine","id":"1401026","name":"STERLING SAND PIT"},"validFrom":"1950-01-01","validTo":"1985-02-28","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401026|L01995|1950-01-01|1985-02-28"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M01795","name":"John H  Middleton"},"object":{"type":"mine","id":"1401026","name":"STERLING SAND PIT"},"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":"1401026|M01795|1950-01-01|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M01795","name":"John H  Middleton"},"object":{"type":"operator","id":"L01995","name":"Tobias & Birchenough Inc"},"validFrom":"1950-01-01","validTo":"1985-02-28","current":false,"derived":true,"evidenceMineId":"1401026","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401026|L01995|1950-01-01|M01795|1950-01-01|121201"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L08022","name":"Sterling Sand & Gravel"},"object":{"type":"mine","id":"1401026","name":"STERLING SAND PIT"},"validFrom":"1985-03-01","validTo":"1991-04-14","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401026|L08022|1985-03-01|1991-04-14"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M06379","name":"James O  Campbell"},"object":{"type":"mine","id":"1401026","name":"STERLING SAND PIT"},"validFrom":"1985-03-01","validTo":"1991-04-14","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401026|M06379|1985-03-01|1991-04-14"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M06379","name":"James O  Campbell"},"object":{"type":"operator","id":"L08022","name":"Sterling Sand & Gravel"},"validFrom":"1985-03-01","validTo":"1991-04-14","current":false,"derived":true,"evidenceMineId":"1401026","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401026|L08022|1985-03-01|M06379|1985-03-01|138378"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L12328","name":"Sterling Sand & Gravel"},"object":{"type":"mine","id":"1401026","name":"STERLING SAND PIT"},"validFrom":"1991-04-15","validTo":"1999-09-22","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401026|L12328|1991-04-15|1999-09-22"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M09468","name":"Edward N  Altvater"},"object":{"type":"mine","id":"1401026","name":"STERLING SAND PIT"},"validFrom":"1991-04-15","validTo":"1999-09-22","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401026|M09468|1991-04-15|1999-09-22"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M09468","name":"Edward N  Altvater"},"object":{"type":"operator","id":"L12328","name":"Sterling Sand & Gravel"},"validFrom":"1991-04-15","validTo":"1999-09-22","current":false,"derived":true,"evidenceMineId":"1401026","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401026|L12328|1991-04-15|M09468|1991-04-15|146442"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L17126","name":"Sterling Sand & Gravel"},"object":{"type":"mine","id":"1401026","name":"STERLING SAND PIT"},"validFrom":"1999-09-23","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401026|L17126|1999-09-23|"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M13058","name":"Marc D  Westhoff"},"object":{"type":"mine","id":"1401026","name":"STERLING SAND PIT"},"validFrom":"1999-09-23","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401026|M13058|1999-09-23|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M13058","name":"Marc D  Westhoff"},"object":{"type":"operator","id":"L17126","name":"Sterling Sand & Gravel"},"validFrom":"1999-09-23","validTo":null,"current":true,"derived":true,"evidenceMineId":"1401026","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401026|L17126|1999-09-23|M13058|1999-09-23|155367"}}],"coverage":{"historyRecords":4,"edgeCount":12,"intervalAnomalies":0,"sourceDatasetId":"msha-controller-operator-history"}},"meta":{"mineId":"1401026","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"}}