{"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-18T09:31:49.615908+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":"3102191","name":"Blue Water Sand & Gravel, Inc."},"operator":{"type":"operator","id":"0134053","name":"Blue Water Sand & Gravel, Inc."},"controller":{"type":"controller","id":"0143281","name":"Ronnie G  Kirkpatrick Jr"},"source":{"datasetId":"msha-mines","observedAt":"2026-10-18T09:31:49.615908+00:00"}},"edges":[{"type":"operator_operates_mine","subject":{"type":"operator","id":"0051021","name":"Mill Creek Mining Co., Inc."},"object":{"type":"mine","id":"3102191","name":"Blue Water Sand & Gravel, Inc."},"validFrom":"2003-02-24","validTo":"2006-10-01","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-18T09:31:49.615908+00:00","recordKey":"3102191|0051021|2003-02-24|2006-10-01"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0041387","name":"Gary S  Johnson"},"object":{"type":"mine","id":"3102191","name":"Blue Water Sand & Gravel, Inc."},"validFrom":"2003-02-24","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-18T09:31:49.615908+00:00","recordKey":"3102191|0041387|2003-02-24|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0041387","name":"Gary S  Johnson"},"object":{"type":"operator","id":"0051021","name":"Mill Creek Mining Co., Inc."},"validFrom":"2003-02-24","validTo":"2006-10-01","current":false,"derived":true,"evidenceMineId":"3102191","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-18T09:31:49.615908+00:00","recordKey":"3102191|0051021|2003-02-24|0041387|2003-02-24|2533"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0046891","name":"Bert D  May"},"object":{"type":"mine","id":"3102191","name":"Blue Water Sand & Gravel, Inc."},"validFrom":"2004-11-15","validTo":"2020-02-04","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-18T09:31:49.615908+00:00","recordKey":"3102191|0046891|2004-11-15|2020-02-04"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"0056418","name":"Mar Mac Aggregates, LLC"},"object":{"type":"mine","id":"3102191","name":"Blue Water Sand & Gravel, Inc."},"validFrom":"2006-10-02","validTo":"2014-06-23","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-18T09:31:49.615908+00:00","recordKey":"3102191|0056418|2006-10-02|2014-06-23"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0046891","name":"Bert D  May"},"object":{"type":"operator","id":"0056418","name":"Mar Mac Aggregates, LLC"},"validFrom":"2006-10-02","validTo":"2014-06-23","current":false,"derived":true,"evidenceMineId":"3102191","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-18T09:31:49.615908+00:00","recordKey":"3102191|0056418|2006-10-02|0046891|2004-11-15|5729"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"0134053","name":"Blue Water Sand & Gravel, Inc."},"object":{"type":"mine","id":"3102191","name":"Blue Water Sand & Gravel, Inc."},"validFrom":"2014-06-24","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-18T09:31:49.615908+00:00","recordKey":"3102191|0134053|2014-06-24|"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0114141","name":"Adrian Jack  Bailey"},"object":{"type":"mine","id":"3102191","name":"Blue Water Sand & Gravel, Inc."},"validFrom":"2014-06-24","validTo":"2022-10-10","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-18T09:31:49.615908+00:00","recordKey":"3102191|0114141|2014-06-24|2022-10-10"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0114141","name":"Adrian Jack  Bailey"},"object":{"type":"operator","id":"0134053","name":"Blue Water Sand & Gravel, Inc."},"validFrom":"2014-06-24","validTo":"2022-10-10","current":false,"derived":true,"evidenceMineId":"3102191","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-18T09:31:49.615908+00:00","recordKey":"3102191|0134053|2014-06-24|0114141|2014-06-24|21424"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0155821","name":"Anthony  Broome et al"},"object":{"type":"mine","id":"3102191","name":"Blue Water Sand & Gravel, Inc."},"validFrom":"2020-02-05","validTo":"2021-09-30","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-18T09:31:49.615908+00:00","recordKey":"3102191|0155821|2020-02-05|2021-09-30"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0155821","name":"Anthony  Broome et al"},"object":{"type":"operator","id":"0056418","name":"Mar Mac Aggregates, LLC"},"validFrom":"2020-02-05","validTo":"2014-06-23","current":false,"derived":true,"evidenceMineId":"3102191","intervalAnomaly":true,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-18T09:31:49.615908+00:00","recordKey":"3102191|0056418|2006-10-02|0155821|2020-02-05|32316"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0155821","name":"Bert Deems  May et al"},"object":{"type":"operator","id":"0056418","name":"Mar Mac Aggregates, LLC"},"validFrom":"2020-02-05","validTo":"2014-06-23","current":false,"derived":true,"evidenceMineId":"3102191","intervalAnomaly":true,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-18T09:31:49.615908+00:00","recordKey":"3102191|0056418|2006-10-02|0155821|2020-02-05|32317"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0155821","name":"Art  Cates et al"},"object":{"type":"operator","id":"0056418","name":"Mar Mac Aggregates, LLC"},"validFrom":"2020-02-05","validTo":"2014-06-23","current":false,"derived":true,"evidenceMineId":"3102191","intervalAnomaly":true,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-18T09:31:49.615908+00:00","recordKey":"3102191|0056418|2006-10-02|0155821|2020-02-05|32318"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0165301","name":"Johnny  Barbee"},"object":{"type":"mine","id":"3102191","name":"Blue Water Sand & Gravel, Inc."},"validFrom":"2021-10-01","validTo":"2025-02-13","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-18T09:31:49.615908+00:00","recordKey":"3102191|0165301|2021-10-01|2025-02-13"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0165301","name":"Johnny  Barbee"},"object":{"type":"operator","id":"0056418","name":"Mar Mac Aggregates, LLC"},"validFrom":"2021-10-01","validTo":"2014-06-23","current":false,"derived":true,"evidenceMineId":"3102191","intervalAnomaly":true,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-18T09:31:49.615908+00:00","recordKey":"3102191|0056418|2006-10-02|0165301|2021-10-01|34651"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0143281","name":"Ronnie G  Kirkpatrick Jr"},"object":{"type":"mine","id":"3102191","name":"Blue Water Sand & Gravel, Inc."},"validFrom":"2022-10-11","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-18T09:31:49.615908+00:00","recordKey":"3102191|0143281|2022-10-11|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0143281","name":"Ronnie G  Kirkpatrick Jr"},"object":{"type":"operator","id":"0134053","name":"Blue Water Sand & Gravel, Inc."},"validFrom":"2022-10-11","validTo":null,"current":true,"derived":true,"evidenceMineId":"3102191","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-18T09:31:49.615908+00:00","recordKey":"3102191|0134053|2014-06-24|0143281|2022-10-11|29068"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0194861","name":"Adan P Sanchez"},"object":{"type":"mine","id":"3102191","name":"Blue Water Sand & Gravel, Inc."},"validFrom":"2025-02-14","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-18T09:31:49.615908+00:00","recordKey":"3102191|0194861|2025-02-14|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0194861","name":"Adan P Sanchez"},"object":{"type":"operator","id":"0056418","name":"Mar Mac Aggregates, LLC"},"validFrom":"2025-02-14","validTo":"2014-06-23","current":false,"derived":true,"evidenceMineId":"3102191","intervalAnomaly":true,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-18T09:31:49.615908+00:00","recordKey":"3102191|0056418|2006-10-02|0194861|2025-02-14|41642"}}],"coverage":{"historyRecords":9,"edgeCount":19,"intervalAnomalies":5,"sourceDatasetId":"msha-controller-operator-history"}},"meta":{"mineId":"3102191","dataSource":"postgres","snapshotId":"2026-10-18T09:31:49.615908+00:00","completedAt":"2026-10-18T09:31:49.615Z","sourceCount":20,"totalRows":17915666,"relationshipSemantics":"valid time; null validTo means current or open-ended in the source"}}