{"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-17T05:35:58.500035+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":"3002517","name":"NORWICH"},"operator":{"type":"operator","id":"L16384","name":"BURRELL'S EXCAVATING INC"},"controller":{"type":"controller","id":"M12532","name":"Dave  Burrell"},"source":{"datasetId":"msha-mines","observedAt":"2026-10-17T05:35:58.500035+00:00"}},"edges":[{"type":"operator_operates_mine","subject":{"type":"operator","id":"L04931","name":"Du Bois Sand & Gravel"},"object":{"type":"mine","id":"3002517","name":"NORWICH"},"validFrom":"1980-05-01","validTo":"1981-03-18","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"3002517|L04931|1980-05-01|1981-03-18"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M03980","name":"Dick  Du Bois"},"object":{"type":"mine","id":"3002517","name":"NORWICH"},"validFrom":"1980-05-01","validTo":"1981-03-18","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"3002517|M03980|1980-05-01|1981-03-18"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M03980","name":"Dick  Du Bois"},"object":{"type":"operator","id":"L04931","name":"Du Bois Sand & Gravel"},"validFrom":"1980-05-01","validTo":"1981-03-18","current":false,"derived":true,"evidenceMineId":"3002517","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"3002517|L04931|1980-05-01|M03980|1980-05-01|130676"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L04932","name":"Lynk Construction"},"object":{"type":"mine","id":"3002517","name":"NORWICH"},"validFrom":"1981-03-19","validTo":"1984-06-30","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"3002517|L04932|1981-03-19|1984-06-30"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M03981","name":"Lynk Gary A"},"object":{"type":"mine","id":"3002517","name":"NORWICH"},"validFrom":"1981-03-19","validTo":"1984-06-30","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"3002517|M03981|1981-03-19|1984-06-30"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M03981","name":"Lynk Gary A"},"object":{"type":"operator","id":"L04932","name":"Lynk Construction"},"validFrom":"1981-03-19","validTo":"1984-06-30","current":false,"derived":true,"evidenceMineId":"3002517","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"3002517|L04932|1981-03-19|M03981|1981-03-19|130678"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L07373","name":"Gorton Construction Company"},"object":{"type":"mine","id":"3002517","name":"NORWICH"},"validFrom":"1984-07-01","validTo":"1997-10-22","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"3002517|L07373|1984-07-01|1997-10-22"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M05871","name":"Mc Nitt James"},"object":{"type":"mine","id":"3002517","name":"NORWICH"},"validFrom":"1984-07-01","validTo":"1997-10-22","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"3002517|M05871|1984-07-01|1997-10-22"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M05871","name":"Mc Nitt James"},"object":{"type":"operator","id":"L07373","name":"Gorton Construction Company"},"validFrom":"1984-07-01","validTo":"1997-10-22","current":false,"derived":true,"evidenceMineId":"3002517","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"3002517|L07373|1984-07-01|M05871|1984-07-01|135667"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L15570","name":"J B M Construction Company"},"object":{"type":"mine","id":"3002517","name":"NORWICH"},"validFrom":"1997-10-23","validTo":"2005-08-08","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"3002517|L15570|1997-10-23|2005-08-08"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M11874","name":"Barbara E  Ryan"},"object":{"type":"mine","id":"3002517","name":"NORWICH"},"validFrom":"1997-10-23","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"3002517|M11874|1997-10-23|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M11874","name":"Barbara E  Ryan"},"object":{"type":"operator","id":"L15570","name":"J B M Construction Company"},"validFrom":"1997-10-23","validTo":"2005-08-08","current":false,"derived":true,"evidenceMineId":"3002517","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"3002517|L15570|1997-10-23|M11874|1997-10-23|152645"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M12532","name":"Dave  Burrell  et al"},"object":{"type":"mine","id":"3002517","name":"NORWICH"},"validFrom":"1999-04-01","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"3002517|M12532|1999-04-01|"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L16384","name":"Burrell's Excavating Inc"},"object":{"type":"mine","id":"3002517","name":"NORWICH"},"validFrom":"2005-08-09","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"3002517|L16384|2005-08-09|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M12532","name":"Dave  Burrell  et al"},"object":{"type":"operator","id":"L16384","name":"Burrell's Excavating Inc"},"validFrom":"2005-08-09","validTo":null,"current":true,"derived":true,"evidenceMineId":"3002517","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"3002517|L16384|2005-08-09|M12532|1999-04-01|153986"}}],"coverage":{"historyRecords":5,"edgeCount":15,"intervalAnomalies":0,"sourceDatasetId":"msha-controller-operator-history"}},"meta":{"mineId":"3002517","dataSource":"postgres","snapshotId":"2026-10-17T05:35:58.500035+00:00","completedAt":"2026-10-17T06:17:15.228Z","sourceCount":20,"totalRows":15450873,"relationshipSemantics":"valid time; null validTo means current or open-ended in the source"}}