{"data":{"schemaVersion":"realm.mine-profile.v1","generatedAt":"2026-10-13T11:26:59.401Z","identity":{"mine_id":"6900001","name":"Obyan Quarry","status":"Active","status_date":"2025-11-13","mine_type":"Surface","coal_metal":"M","commodity":"Construction Sand and Gravel","state":"MP","county":"Northern Islands","nearest_town":"Garapan","operator_id":"0142593","operator_name":"Hawaiian Rock Products","controller_id":"M07893","controller_name":"Mitsubishi Corp","district":"M3","office":"San Juan PR Field Office","employees":70,"latitude":15.115833,"longitude":-145.748611},"coverage":{"contributingSources":6,"registeredSources":20,"sourceRows":111},"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":"6900001","name":"Obyan Quarry"},"operator":{"type":"operator","id":"0142593","name":"Hawaiian Rock Products"},"controller":{"type":"controller","id":"M07893","name":"Mitsubishi Corp"},"source":{"datasetId":"msha-mines","observedAt":"2026-10-13T11:19:05.459773+00:00"}},"edges":[{"type":"operator_operates_mine","subject":{"type":"operator","id":"0142593","name":"Hawaiian Rock Products"},"object":{"type":"mine","id":"6900001","name":"Obyan Quarry"},"validFrom":"2015-12-22","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"6900001|0142593|2015-12-22|"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0122161","name":"Jerrold Clay  Johnson"},"object":{"type":"mine","id":"6900001","name":"Obyan Quarry"},"validFrom":"2015-12-22","validTo":"2026-06-30","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"6900001|0122161|2015-12-22|2026-06-30"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0122161","name":"Jerrold Clay  Johnson"},"object":{"type":"operator","id":"0142593","name":"Hawaiian Rock Products"},"validFrom":"2015-12-22","validTo":"2026-06-30","current":false,"derived":true,"evidenceMineId":"6900001","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"6900001|0142593|2015-12-22|0122161|2015-12-22|23759"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M07893","name":"Mitsubishi Corp"},"object":{"type":"mine","id":"6900001","name":"Obyan Quarry"},"validFrom":"2026-07-01","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"6900001|M07893|2026-07-01|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M07893","name":"Mitsubishi Corp"},"object":{"type":"operator","id":"0142593","name":"Hawaiian Rock Products"},"validFrom":"2026-07-01","validTo":null,"current":true,"derived":true,"evidenceMineId":"6900001","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"6900001|0142593|2015-12-22|M07893|2026-07-01|142193"}}],"coverage":{"historyRecords":2,"edgeCount":5,"intervalAnomalies":0,"sourceDatasetId":"msha-controller-operator-history"}},"sources":[{"id":"msha-accidents","name":"Accident, Injuries, and Illnesses","domains":["safety","contractors"],"products":["incident trends","severity rates","equipment patterns","peer denominators"],"rowCount":1,"firstDate":"2017-08-21","lastDate":"2017-08-21","metrics":{"daysLost":3,"injuries":1,"fatalities":0,"recentRows":0,"restrictedDays":14,"contractorRecords":0},"periods":{},"recentRecords":[{"SOURCE_ROW_NUMBER":"219446","DOCUMENT_NO":"220172480002","ACCIDENT_DT":"08/21/2017","DEGREE_INJURY":"DYS AWY FRM WRK & RESTRCTD ACT","CLASSIFICATION":"SLIP OR FALL OF PERSON","ACCIDENT_TYPE":"Fall from machine","OCCUPATION":"Utility man, Shift tech, Service/Dump truck operator","NO_INJURIES":"1","DAYS_LOST":"3","NARRATIVE":"Hand hold on dump truck for access to cab had grease or oil residue on the surface. When the employee reached for the grab bar their hand slipped off causing them to fall backwards. Employee reached out with their hand to break their fall which resulted in their hand striking the ground.","sourceDate":"2017-08-21"}]},{"id":"msha-addresses","name":"Addresses of Record","domains":["identity","logistics"],"products":["entity resolution","address history","facility geocoding"],"rowCount":1,"firstDate":"2025-11-13","lastDate":"2025-11-13","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":2,"firstDate":"2015-12-22","lastDate":"2015-12-22","metrics":{"recentRows":0,"currentOperatorTenures":2,"completedOperatorTenures":0},"periods":{},"recentRecords":[]},{"id":"msha-mine-production-quarterly","name":"Mine Employment and Production — Quarterly","domains":["production","safety","compliance"],"products":["production trend","employee hours","rate denominators","seasonality"],"rowCount":84,"firstDate":null,"lastDate":null,"metrics":{},"periods":{"2026-Q2":{"hours":45815,"employees":70,"production":0},"2026-Q1":{"hours":38461,"employees":71,"production":0},"2025-Q4":{"hours":37212,"employees":72,"production":0},"2025-Q3":{"hours":36465,"employees":70,"production":0},"2025-Q2":{"hours":35658,"employees":77,"production":0},"2025-Q1":{"hours":40915,"employees":72,"production":0},"2024-Q4":{"hours":39751,"employees":71,"production":0},"2024-Q3":{"hours":38137,"employees":77,"production":0},"2024-Q2":{"hours":41983,"employees":74,"production":0},"2024-Q1":{"hours":40085,"employees":76,"production":0},"2023-Q4":{"hours":49274,"employees":89,"production":0},"2023-Q3":{"hours":39618,"employees":77,"production":0}},"recentRecords":[]},{"id":"msha-mine-production-yearly","name":"Mine Employment and Production — Yearly","domains":["production","safety","compliance"],"products":["annual trend","backfill","quarterly reconciliation"],"rowCount":22,"firstDate":null,"lastDate":null,"metrics":{},"periods":{"2017":{"hours":209593,"employees":92,"production":0},"2018":{"hours":222017,"employees":91,"production":0},"2019":{"hours":189046,"employees":97,"production":0},"2020":{"hours":157737,"employees":86,"production":0},"2021":{"hours":151091,"employees":82,"production":0},"2022":{"hours":156300,"employees":84,"production":0},"2023":{"hours":162145,"employees":79,"production":0},"2024":{"hours":159956,"employees":75,"production":0},"2025":{"hours":150250,"employees":73,"production":0},"2026":{"hours":84276,"employees":71,"production":0}},"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/6900001/safety","description":"Full-period safety series, top CFR sections and paginated activity. Requires PostgreSQL."},"silica":{"href":"/api/v1/mines/6900001/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":"6900001","dataSource":"postgres","snapshotId":"2026-10-13T11:19:05.459773+00:00","completedAt":"2026-10-13T11:26:59.401Z","sourceCount":20,"totalRows":17906804}}