{"data":{"schemaVersion":"realm.mine-profile.v1","generatedAt":"2026-10-13T11:26:59.401Z","identity":{"mine_id":"0404761","name":"Red Rock Quarry","status":"Abandoned","status_date":"2004-08-04","mine_type":"Surface","coal_metal":"M","commodity":"Construction Sand and Gravel","state":"CA","county":"Mendocino","nearest_town":"Ukiah","operator_id":"L00039","operator_name":"Granite Construction Co","controller_id":"M00079","controller_name":"Granite Construction Inc","district":"M7","office":"Vacaville CA Field Office","employees":0,"latitude":39.156644,"longitude":-123.222444},"coverage":{"contributingSources":7,"registeredSources":20,"sourceRows":43},"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":"0404761","name":"Red Rock Quarry"},"operator":{"type":"operator","id":"L00039","name":"Granite Construction Co"},"controller":{"type":"controller","id":"M00079","name":"Granite Construction Inc"},"source":{"datasetId":"msha-mines","observedAt":"2026-10-13T11:19:05.459773+00:00"}},"edges":[{"type":"controller_controls_mine","subject":{"type":"controller","id":"M00079","name":"Granite Construction Inc"},"object":{"type":"mine","id":"0404761","name":"Red Rock Quarry"},"validFrom":"1950-01-01","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0404761|M00079|1950-01-01|"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M06428","name":"Robert J  King"},"object":{"type":"mine","id":"0404761","name":"Red Rock Quarry"},"validFrom":"1950-01-01","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0404761|M06428|1950-01-01|"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L08088","name":"Parnum Paving Inc"},"object":{"type":"mine","id":"0404761","name":"Red Rock Quarry"},"validFrom":"1985-07-01","validTo":"1996-01-24","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0404761|L08088|1985-07-01|1996-01-24"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M06428","name":"Robert J  King"},"object":{"type":"operator","id":"L08088","name":"Parnum Paving Inc"},"validFrom":"1985-07-01","validTo":"1996-01-24","current":false,"derived":true,"evidenceMineId":"0404761","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0404761|L08088|1985-07-01|M06428|1950-01-01|138505"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M10896","name":"C Dean  Rasmussen"},"object":{"type":"mine","id":"0404761","name":"Red Rock Quarry"},"validFrom":"1995-07-07","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0404761|M10896|1995-07-07|"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L14270","name":"Parnum Paving,  Inc."},"object":{"type":"mine","id":"0404761","name":"Red Rock Quarry"},"validFrom":"1996-01-25","validTo":"2002-05-31","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0404761|L14270|1996-01-25|2002-05-31"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M10896","name":"C Dean  Rasmussen"},"object":{"type":"operator","id":"L14270","name":"Parnum Paving,  Inc."},"validFrom":"1996-01-25","validTo":"2002-05-31","current":false,"derived":true,"evidenceMineId":"0404761","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0404761|L14270|1996-01-25|M10896|1995-07-07|150228"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L00039","name":"Granite Construction Co"},"object":{"type":"mine","id":"0404761","name":"Red Rock Quarry"},"validFrom":"2002-06-01","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0404761|L00039|2002-06-01|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M00079","name":"Granite Construction Inc"},"object":{"type":"operator","id":"L00039","name":"Granite Construction Co"},"validFrom":"2002-06-01","validTo":null,"current":true,"derived":true,"evidenceMineId":"0404761","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0404761|L00039|2002-06-01|M00079|1950-01-01|103606"}}],"coverage":{"historyRecords":3,"edgeCount":9,"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":"2001-10-29","lastDate":"2001-10-29","metrics":{"daysLost":165,"injuries":1,"fatalities":0,"recentRows":0,"restrictedDays":0,"contractorRecords":0},"periods":{},"recentRecords":[{"SOURCE_ROW_NUMBER":"228475","DOCUMENT_NO":"220013170127","ACCIDENT_DT":"10/29/2001","DEGREE_INJURY":"DAYS AWAY FROM WORK ONLY","CLASSIFICATION":"SLIP OR FALL OF PERSON","ACCIDENT_TYPE":"Fall from machine","OCCUPATION":"Bulldozer operator, Universal operator, Heavy equipment operator, Operating engineer","NO_INJURIES":"1","DAYS_LOST":"165","NARRATIVE":"EMPLOYEE WAS WORKING ON C-84 CAT IN WET, RAINY WEATHER; SLIPPED AND FELL OFF CAT ONTO TRACKS AND THEN ONTO GROUND, INJURING HIS BACK, NECK, LEFT ARM AND RIGHT WRIST. EMPLOYEE DID NOT REPORT AC CIDENT OR SEEK MEDICAL ATTENTION UNTIL 11/7/01.","sourceDate":"2001-10-29"}]},{"id":"msha-addresses","name":"Addresses of Record","domains":["identity","logistics"],"products":["entity resolution","address history","facility geocoding"],"rowCount":1,"firstDate":"2004-08-04","lastDate":"2004-08-04","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":"1985-07-01","lastDate":"2002-06-01","metrics":{"recentRows":0,"currentOperatorTenures":1,"completedOperatorTenures":2},"periods":{},"recentRecords":[]},{"id":"msha-inspections","name":"Inspections","domains":["safety","compliance"],"products":["inspection mix","on-site hours","event context","citation rate denominator"],"rowCount":8,"firstDate":"2000-06-21","lastDate":"2004-08-03","metrics":{"inspectors":7,"recentRows":0,"onSiteHours":19,"inspectionHours":33,"inspectionSamples":0},"periods":{},"recentRecords":[{"SOURCE_ROW_NUMBER":"142535","EVENT_NO":"1121925","INSPECTION_BEGIN_DT":"08/03/2004","INSPECTION_END_DT":"08/03/2004","ACTIVITY_CODE":"37","ACTIVITY":"MISCELLANEOUS INSPECTION/INVESTIGATION","NBR_INSPECTOR":"1","SUM_TOTAL_INSP_HOURS":"3","SUM_TOTAL_ON_SITE_HOURS":"1","sourceDate":"2004-08-03"},{"SOURCE_ROW_NUMBER":"851989","EVENT_NO":"1121014","INSPECTION_BEGIN_DT":"09/18/2003","INSPECTION_END_DT":"09/18/2003","ACTIVITY_CODE":"01","ACTIVITY":"REGULAR INSPECTION","NBR_INSPECTOR":"1","SUM_TOTAL_INSP_HOURS":"5","SUM_TOTAL_ON_SITE_HOURS":"3","sourceDate":"2003-09-18"},{"SOURCE_ROW_NUMBER":"406336","EVENT_NO":"0615693","INSPECTION_BEGIN_DT":"07/09/2002","INSPECTION_END_DT":"07/09/2002","ACTIVITY_CODE":"37","ACTIVITY":"MISCELLANEOUS INSPECTION/INVESTIGATION","NBR_INSPECTOR":"0","SUM_TOTAL_INSP_HOURS":"0","SUM_TOTAL_ON_SITE_HOURS":"0","sourceDate":"2002-07-09"},{"SOURCE_ROW_NUMBER":"980750","EVENT_NO":"0768005","INSPECTION_BEGIN_DT":"04/25/2002","INSPECTION_END_DT":"04/25/2002","ACTIVITY_CODE":"01","ACTIVITY":"REGULAR INSPECTION","NBR_INSPECTOR":"1","SUM_TOTAL_INSP_HOURS":"5","SUM_TOTAL_ON_SITE_HOURS":"2","sourceDate":"2002-04-25"},{"SOURCE_ROW_NUMBER":"66955","EVENT_NO":"0767881","INSPECTION_BEGIN_DT":"10/04/2001","INSPECTION_END_DT":"10/04/2001","ACTIVITY_CODE":"01","ACTIVITY":"REGULAR INSPECTION","NBR_INSPECTOR":"1","SUM_TOTAL_INSP_HOURS":"8","SUM_TOTAL_ON_SITE_HOURS":"6","sourceDate":"2001-10-04"},{"SOURCE_ROW_NUMBER":"1119425","EVENT_NO":"0645202","INSPECTION_BEGIN_DT":"06/04/2001","INSPECTION_END_DT":"06/06/2001","ACTIVITY_CODE":"01","ACTIVITY":"REGULAR INSPECTION","NBR_INSPECTOR":"1","SUM_TOTAL_INSP_HOURS":"7","SUM_TOTAL_ON_SITE_HOURS":"4","sourceDate":"2001-06-04"},{"SOURCE_ROW_NUMBER":"411792","EVENT_NO":"0615861","INSPECTION_BEGIN_DT":"12/13/2000","INSPECTION_END_DT":"12/14/2000","ACTIVITY_CODE":"16","ACTIVITY":"PART 50 AUDIT","NBR_INSPECTOR":"1","SUM_TOTAL_INSP_HOURS":"2","SUM_TOTAL_ON_SITE_HOURS":"2","sourceDate":"2000-12-13"},{"SOURCE_ROW_NUMBER":"70958","EVENT_NO":"0635837","INSPECTION_BEGIN_DT":"06/21/2000","INSPECTION_END_DT":"06/21/2000","ACTIVITY_CODE":"10","ACTIVITY":"ATTEMPTED INSPECTION","NBR_INSPECTOR":"1","SUM_TOTAL_INSP_HOURS":"3","SUM_TOTAL_ON_SITE_HOURS":"1","sourceDate":"2000-06-21"}]},{"id":"msha-mine-production-quarterly","name":"Mine Employment and Production — Quarterly","domains":["production","safety","compliance"],"products":["production trend","employee hours","rate denominators","seasonality"],"rowCount":25,"firstDate":null,"lastDate":null,"metrics":{},"periods":{"2004-Q3":{"hours":0,"employees":0,"production":0},"2004-Q1":{"hours":59,"employees":1,"production":0},"2003-Q4":{"hours":0,"employees":0,"production":0},"2003-Q3":{"hours":0,"employees":0,"production":0},"2003-Q2":{"hours":0,"employees":0,"production":0},"2003-Q1":{"hours":0,"employees":0,"production":0},"2002-Q4":{"hours":256,"employees":1,"production":0},"2002-Q3":{"hours":391,"employees":1,"production":0},"2002-Q2":{"hours":615,"employees":2,"production":0},"2002-Q1":{"hours":0,"employees":0,"production":0},"2001-Q4":{"hours":645,"employees":2,"production":0},"2001-Q3":{"hours":501,"employees":2,"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":4,"firstDate":null,"lastDate":null,"metrics":{},"periods":{"2000":{"hours":1640,"employees":3,"production":0},"2001":{"hours":1146,"employees":2,"production":0},"2002":{"hours":1262,"employees":1,"production":0},"2004":{"hours":59,"employees":1,"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/0404761/safety","description":"Full-period safety series, top CFR sections and paginated activity. Requires PostgreSQL."},"silica":{"href":"/api/v1/mines/0404761/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":"0404761","dataSource":"postgres","snapshotId":"2026-10-13T11:19:05.459773+00:00","completedAt":"2026-10-13T11:26:59.401Z","sourceCount":20,"totalRows":17906804}}