{"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":"4503268","name":"Spike Quarry"},"operator":{"type":"operator","id":"L15456","name":"Northwest Rock, Inc."},"controller":{"type":"controller","id":"0137981","name":"Jason  Messmer; Randy  Rognlin"},"source":{"datasetId":"msha-mines","observedAt":"2026-10-13T11:19:05.459773+00:00"}},"edges":[{"type":"controller_controls_mine","subject":{"type":"controller","id":"M02326","name":"John D  Friend et al"},"object":{"type":"mine","id":"4503268","name":"Spike Quarry"},"validFrom":"1950-01-01","validTo":"2006-02-28","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4503268|M02326|1950-01-01|2006-02-28"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L38666","name":"Spradlin Rock Products Inc"},"object":{"type":"mine","id":"4503268","name":"Spike Quarry"},"validFrom":"1992-06-01","validTo":"2012-03-31","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4503268|L38666|1992-06-01|2012-03-31"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M38666","name":"Thomas J  Spradlin et al"},"object":{"type":"mine","id":"4503268","name":"Spike Quarry"},"validFrom":"1992-06-01","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4503268|M38666|1992-06-01|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M38666","name":"Thomas J  Spradlin et al"},"object":{"type":"operator","id":"L38666","name":"Spradlin Rock Products Inc"},"validFrom":"1992-06-01","validTo":"2012-03-31","current":false,"derived":true,"evidenceMineId":"4503268","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4503268|L38666|1992-06-01|M38666|1992-06-01|168100"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M11262","name":"Randy  Rognlin"},"object":{"type":"mine","id":"4503268","name":"Spike Quarry"},"validFrom":"2006-03-01","validTo":"2017-12-28","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4503268|M11262|2006-03-01|2017-12-28"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"0123551","name":"Spradlin Rock, Inc."},"object":{"type":"mine","id":"4503268","name":"Spike Quarry"},"validFrom":"2012-04-01","validTo":"2017-11-27","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4503268|0123551|2012-04-01|2017-11-27"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M38666","name":"Thomas J  Spradlin et al"},"object":{"type":"mine","id":"4503268","name":"Spike Quarry"},"validFrom":"2012-04-01","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4503268|M38666|2012-04-01|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M38666","name":"Thomas J  Spradlin et al"},"object":{"type":"operator","id":"0123551","name":"Spradlin Rock, Inc."},"validFrom":"2012-04-01","validTo":"2017-11-27","current":false,"derived":true,"evidenceMineId":"4503268","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4503268|0123551|2012-04-01|M38666|2012-04-01|168101"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L15456","name":"Northwest Rock, Inc."},"object":{"type":"mine","id":"4503268","name":"Spike Quarry"},"validFrom":"2017-11-28","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4503268|L15456|2017-11-28|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M02326","name":"John D  Friend et al"},"object":{"type":"operator","id":"L15456","name":"Northwest Rock, Inc."},"validFrom":"2017-11-28","validTo":"2006-02-28","current":false,"derived":true,"evidenceMineId":"4503268","intervalAnomaly":true,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4503268|L15456|2017-11-28|M02326|1950-01-01|124804"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M11262","name":"Randy  Rognlin"},"object":{"type":"operator","id":"L15456","name":"Northwest Rock, Inc."},"validFrom":"2017-11-28","validTo":"2017-12-28","current":false,"derived":true,"evidenceMineId":"4503268","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4503268|L15456|2017-11-28|M11262|2006-03-01|151049"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0137981","name":"Randy  Rognlin et al"},"object":{"type":"mine","id":"4503268","name":"Spike Quarry"},"validFrom":"2017-12-29","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4503268|0137981|2017-12-29|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0137981","name":"Randy  Rognlin et al"},"object":{"type":"operator","id":"L15456","name":"Northwest Rock, Inc."},"validFrom":"2017-12-29","validTo":null,"current":true,"derived":true,"evidenceMineId":"4503268","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4503268|L15456|2017-11-28|0137981|2017-12-29|27884"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0137981","name":"Jason  Messmer et al"},"object":{"type":"operator","id":"L15456","name":"Northwest Rock, Inc."},"validFrom":"2017-12-29","validTo":null,"current":true,"derived":true,"evidenceMineId":"4503268","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4503268|L15456|2017-11-28|0137981|2017-12-29|27885"}}],"coverage":{"historyRecords":6,"edgeCount":14,"intervalAnomalies":1,"sourceDatasetId":"msha-controller-operator-history"}},"meta":{"mineId":"4503268","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"}}