{"data":{"schemaVersion":"realm.mine-profile.v1","generatedAt":"2026-10-13T11:26:59.401Z","identity":{"mine_id":"0901273","name":"Sandy Cross Blue Quarry","status":"New Mine","status_date":"2025-11-21","mine_type":"Surface","coal_metal":"M","commodity":"","state":"GA","county":"Oglethorpe","nearest_town":"","operator_id":"L11017","operator_name":"QUARRIES, INC","controller_id":"0140541","controller_name":"Doris Ann  Gunter; Mark  Hill","district":"C07","office":"Knoxville TN Field Office","employees":0,"latitude":null,"longitude":null},"coverage":{"contributingSources":3,"registeredSources":20,"sourceRows":5},"relationships":{"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":"0901273","name":"Sandy Cross Blue Quarry"},"operator":{"type":"operator","id":"L11017","name":"QUARRIES, INC"},"controller":{"type":"controller","id":"0140541","name":"Doris Ann  Gunter; Mark  Hill"},"source":{"datasetId":"msha-mines","observedAt":"2026-10-13T11:19:05.459773+00:00"}},"edges":[{"type":"controller_controls_mine","subject":{"type":"controller","id":"M08529","name":"Calvin  Hill et al"},"object":{"type":"mine","id":"0901273","name":"Sandy Cross Blue Quarry"},"validFrom":"1950-01-01","validTo":"2018-04-29","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0901273|M08529|1950-01-01|2018-04-29"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0140541","name":"Doris Ann  Gunter et al"},"object":{"type":"mine","id":"0901273","name":"Sandy Cross Blue Quarry"},"validFrom":"2018-04-30","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0901273|0140541|2018-04-30|"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L11017","name":"QUARRIES, INC"},"object":{"type":"mine","id":"0901273","name":"Sandy Cross Blue Quarry"},"validFrom":"2026-08-26","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0901273|L11017|2026-08-26|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0140541","name":"Doris Ann  Gunter et al"},"object":{"type":"operator","id":"L11017","name":"QUARRIES, INC"},"validFrom":"2026-08-26","validTo":null,"current":true,"derived":true,"evidenceMineId":"0901273","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0901273|L11017|2026-08-26|0140541|2018-04-30|28461"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0140541","name":"Mark  Hill et al"},"object":{"type":"operator","id":"L11017","name":"QUARRIES, INC"},"validFrom":"2026-08-26","validTo":null,"current":true,"derived":true,"evidenceMineId":"0901273","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0901273|L11017|2026-08-26|0140541|2018-04-30|28462"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M08529","name":"Calvin  Hill et al"},"object":{"type":"operator","id":"L11017","name":"QUARRIES, INC"},"validFrom":"2026-08-26","validTo":"2018-04-29","current":false,"derived":true,"evidenceMineId":"0901273","intervalAnomaly":true,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0901273|L11017|2026-08-26|M08529|1950-01-01|143579"}}],"coverage":{"historyRecords":3,"edgeCount":6,"intervalAnomalies":1,"sourceDatasetId":"msha-controller-operator-history"}},"sources":[{"id":"msha-addresses","name":"Addresses of Record","domains":["identity","logistics"],"products":["entity resolution","address history","facility geocoding"],"rowCount":1,"firstDate":"2025-11-21","lastDate":"2025-11-21","metrics":{},"periods":{},"recentRecords":[]},{"id":"msha-controller-operator-history","name":"Controller and Operator History","domains":["identity","compliance"],"products":["historical ownership attribution","operator transitions","valid-time joins"],"rowCount":3,"firstDate":"2026-08-26","lastDate":"2026-08-26","metrics":{"recentRows":3,"currentOperatorTenures":3,"completedOperatorTenures":0},"periods":{},"recentRecords":[]},{"id":"msha-mines","name":"Mines","domains":["identity","production","logistics"],"products":["mine identity","status","commodity","location","operator and controller"],"rowCount":1,"firstDate":null,"lastDate":null,"metrics":{},"periods":{},"recentRecords":[]}],"safety":{"href":"/api/v1/mines/0901273/safety","description":"Full-period safety series, top CFR sections and paginated activity. Requires PostgreSQL."},"silica":{"href":"/api/v1/mines/0901273/silica","description":"Dedicated silica records, measurements, sample status and trends. Defaults to the snapshot year; use year=all for history."},"externalContext":{"eia":null,"title30":{"snapshot":{"chapterCount":6,"featuredSectionCount":100,"latestAmendedOn":"2026-08-14","latestIssueDate":"2026-08-14","partCount":206,"sectionCount":5954,"upToDateAsOf":"2026-08-19"},"regulations":[],"fullCorpus":"/data/title30-sections.json"}}},"meta":{"representation":"json","mineId":"0901273","dataSource":"postgres","snapshotId":"2026-10-13T11:19:05.459773+00:00","completedAt":"2026-10-13T11:26:59.401Z","sourceCount":20,"totalRows":17906804}}