{"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":"2100693","name":"Coons Aggregate Supply, LLC"},"operator":{"type":"operator","id":"0125113","name":"Coon's Aggregate Supply, LLC"},"controller":{"type":"controller","id":"0106281","name":"Rick  Schulke; Mark  Hawkinson"},"source":{"datasetId":"msha-mines","observedAt":"2026-10-13T11:19:05.459773+00:00"}},"edges":[{"type":"operator_operates_mine","subject":{"type":"operator","id":"L01328","name":"Wissota Sand & Gravel Co."},"object":{"type":"mine","id":"2100693","name":"Coons Aggregate Supply, LLC"},"validFrom":"1950-01-01","validTo":"2012-08-12","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"2100693|L01328|1950-01-01|2012-08-12"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M01174","name":"Wissota Sand & Gravel Company"},"object":{"type":"mine","id":"2100693","name":"Coons Aggregate Supply, LLC"},"validFrom":"1950-01-01","validTo":"2019-10-30","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"2100693|M01174|1950-01-01|2019-10-30"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M01174","name":"Wissota Sand & Gravel Company"},"object":{"type":"operator","id":"L01328","name":"Wissota Sand & Gravel Co."},"validFrom":"1950-01-01","validTo":"2012-08-12","current":false,"derived":true,"evidenceMineId":"2100693","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"2100693|L01328|1950-01-01|M01174|1950-01-01|117218"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"0125113","name":"Coon's Aggregate Supply, LLC"},"object":{"type":"mine","id":"2100693","name":"Coons Aggregate Supply, LLC"},"validFrom":"2012-08-13","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"2100693|0125113|2012-08-13|"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0106281","name":"Rick  Schulke et al"},"object":{"type":"mine","id":"2100693","name":"Coons Aggregate Supply, LLC"},"validFrom":"2012-08-13","validTo":"2021-07-11","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"2100693|0106281|2012-08-13|2021-07-11"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0106281","name":"Rick  Schulke et al"},"object":{"type":"operator","id":"0125113","name":"Coon's Aggregate Supply, LLC"},"validFrom":"2012-08-13","validTo":"2021-07-11","current":false,"derived":true,"evidenceMineId":"2100693","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"2100693|0125113|2012-08-13|0106281|2012-08-13|18771"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0106281","name":"Mark  Hawkinson et al"},"object":{"type":"operator","id":"0125113","name":"Coon's Aggregate Supply, LLC"},"validFrom":"2012-08-13","validTo":"2021-07-11","current":false,"derived":true,"evidenceMineId":"2100693","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"2100693|0125113|2012-08-13|0106281|2012-08-13|18772"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0154201","name":"WSG Acquisition Corp"},"object":{"type":"mine","id":"2100693","name":"Coons Aggregate Supply, LLC"},"validFrom":"2019-10-31","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"2100693|0154201|2019-10-31|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0154201","name":"WSG Acquisition Corp"},"object":{"type":"operator","id":"L01328","name":"Wissota Sand & Gravel Co."},"validFrom":"2019-10-31","validTo":"2012-08-12","current":false,"derived":true,"evidenceMineId":"2100693","intervalAnomaly":true,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"2100693|L01328|1950-01-01|0154201|2019-10-31|31965"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0165381","name":"Rick  Schulke et al"},"object":{"type":"mine","id":"2100693","name":"Coons Aggregate Supply, LLC"},"validFrom":"2021-07-12","validTo":"2024-05-05","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"2100693|0165381|2021-07-12|2024-05-05"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0165381","name":"Rick  Schulke et al"},"object":{"type":"operator","id":"0125113","name":"Coon's Aggregate Supply, LLC"},"validFrom":"2021-07-12","validTo":"2024-05-05","current":false,"derived":true,"evidenceMineId":"2100693","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"2100693|0125113|2012-08-13|0165381|2021-07-12|34652"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0165381","name":"Paul  Hawkinson et al"},"object":{"type":"operator","id":"0125113","name":"Coon's Aggregate Supply, LLC"},"validFrom":"2021-07-12","validTo":"2024-05-05","current":false,"derived":true,"evidenceMineId":"2100693","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"2100693|0125113|2012-08-13|0165381|2021-07-12|34653"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0106281","name":"Mark  Hawkinson et al"},"object":{"type":"mine","id":"2100693","name":"Coons Aggregate Supply, LLC"},"validFrom":"2024-05-06","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"2100693|0106281|2024-05-06|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0106281","name":"Mark  Hawkinson et al"},"object":{"type":"operator","id":"0125113","name":"Coon's Aggregate Supply, LLC"},"validFrom":"2024-05-06","validTo":null,"current":true,"derived":true,"evidenceMineId":"2100693","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"2100693|0125113|2012-08-13|0106281|2024-05-06|18777"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0106281","name":"Rick  Schulke et al"},"object":{"type":"operator","id":"0125113","name":"Coon's Aggregate Supply, LLC"},"validFrom":"2024-05-06","validTo":null,"current":true,"derived":true,"evidenceMineId":"2100693","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"2100693|0125113|2012-08-13|0106281|2024-05-06|18778"}}],"coverage":{"historyRecords":8,"edgeCount":15,"intervalAnomalies":1,"sourceDatasetId":"msha-controller-operator-history"}},"meta":{"mineId":"2100693","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"}}