{"data":{"schemaVersion":"realm.mine-profile.v1","generatedAt":"2026-10-13T11:26:59.401Z","identity":{"mine_id":"3401766","name":"Portable #3","status":"Intermittent","status_date":"2017-11-15","mine_type":"Surface","coal_metal":"M","commodity":"Construction Sand and Gravel","state":"OK","county":"Ottawa","nearest_town":"Picher OK","operator_id":"L00392","operator_name":"Wlliams Diversified Materials, Inc.","controller_id":"0107845","controller_name":"Sandra Lee Williams","district":"C10","office":"Rolla MO Field Office","employees":1,"latitude":36.983056,"longitude":-94.812778},"coverage":{"contributingSources":8,"registeredSources":20,"sourceRows":102},"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":"3401766","name":"Portable #3"},"operator":{"type":"operator","id":"L00392","name":"Wlliams Diversified Materials, Inc."},"controller":{"type":"controller","id":"0107845","name":"Sandra Lee Williams"},"source":{"datasetId":"msha-mines","observedAt":"2026-10-13T11:19:05.459773+00:00"}},"edges":[{"type":"controller_controls_mine","subject":{"type":"controller","id":"M00326","name":"Larry L  Bingham"},"object":{"type":"mine","id":"3401766","name":"Portable #3"},"validFrom":"1950-01-01","validTo":"2012-12-27","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3401766|M00326|1950-01-01|2012-12-27"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L00392","name":"Wlliams Diversified Materials, Inc."},"object":{"type":"mine","id":"3401766","name":"Portable #3"},"validFrom":"1992-01-01","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3401766|L00392|1992-01-01|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M00326","name":"Larry L  Bingham"},"object":{"type":"operator","id":"L00392","name":"Wlliams Diversified Materials, Inc."},"validFrom":"1992-01-01","validTo":"2012-12-27","current":false,"derived":true,"evidenceMineId":"3401766","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3401766|L00392|1992-01-01|M00326|1950-01-01|109436"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0107845","name":"Sandra Lee Williams et al"},"object":{"type":"mine","id":"3401766","name":"Portable #3"},"validFrom":"2012-12-28","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3401766|0107845|2012-12-28|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0107845","name":"Sandra Lee Williams et al"},"object":{"type":"operator","id":"L00392","name":"Wlliams Diversified Materials, Inc."},"validFrom":"2012-12-28","validTo":null,"current":true,"derived":true,"evidenceMineId":"3401766","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3401766|L00392|1992-01-01|0107845|2012-12-28|19355"}}],"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":"2022-06-24","lastDate":"2022-06-24","metrics":{"daysLost":1,"injuries":1,"fatalities":0,"recentRows":1,"restrictedDays":0,"contractorRecords":0},"periods":{},"recentRecords":[{"SOURCE_ROW_NUMBER":"165975","DOCUMENT_NO":"220221860010","ACCIDENT_DT":"06/24/2022","DEGREE_INJURY":"DAYS AWAY FROM WORK ONLY","CLASSIFICATION":"HANDLING OF MATERIALS","ACCIDENT_TYPE":"Fall onto or against objects","OCCUPATION":"Maintenance man, Mechanic,  Repair/Serviceman, Boilermaker, Fueler, Tire tech, Field service tech","NO_INJURIES":"1","DAYS_LOST":"1","NARRATIVE":"Diesel fuel spilled on the portable plant because someone left the handles open. When employee stepped on the rail of the plant, boot slipped on the rail causing them to fall striking the plant rail on right shin.","sourceDate":"2022-06-24"}]},{"id":"msha-addresses","name":"Addresses of Record","domains":["identity","logistics"],"products":["entity resolution","address history","facility geocoding"],"rowCount":1,"firstDate":"2017-11-15","lastDate":"2017-11-15","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":"1992-01-01","lastDate":"1992-01-01","metrics":{"recentRows":0,"currentOperatorTenures":2,"completedOperatorTenures":0},"periods":{},"recentRecords":[]},{"id":"msha-inspections","name":"Inspections","domains":["safety","compliance"],"products":["inspection mix","on-site hours","event context","citation rate denominator"],"rowCount":9,"firstDate":"2018-05-09","lastDate":"2026-02-18","metrics":{"inspectors":9,"recentRows":6,"onSiteHours":22.25,"inspectionHours":55,"inspectionSamples":0},"periods":{},"recentRecords":[{"SOURCE_ROW_NUMBER":"19441","EVENT_NO":"F034C7A","INSPECTION_BEGIN_DT":"02/18/2026","INSPECTION_END_DT":"02/18/2026","ACTIVITY_CODE":"E01","ACTIVITY":"Regular Safety and Health Inspection","NBR_INSPECTOR":"1","SUM_TOTAL_INSP_HOURS":"1.5","SUM_TOTAL_ON_SITE_HOURS":".25","sourceDate":"2026-02-18"},{"SOURCE_ROW_NUMBER":"266827","EVENT_NO":"7101588","INSPECTION_BEGIN_DT":"03/24/2025","INSPECTION_END_DT":"03/27/2025","ACTIVITY_CODE":"E01","ACTIVITY":"Regular Safety and Health Inspection","NBR_INSPECTOR":"1","SUM_TOTAL_INSP_HOURS":"7.75","SUM_TOTAL_ON_SITE_HOURS":".5","sourceDate":"2025-03-24"},{"SOURCE_ROW_NUMBER":"135413","EVENT_NO":"6934792","INSPECTION_BEGIN_DT":"11/16/2023","INSPECTION_END_DT":"11/16/2023","ACTIVITY_CODE":"E01","ACTIVITY":"Regular Safety and Health Inspection","NBR_INSPECTOR":"1","SUM_TOTAL_INSP_HOURS":"3.75","SUM_TOTAL_ON_SITE_HOURS":"1.5","sourceDate":"2023-11-16"},{"SOURCE_ROW_NUMBER":"990427","EVENT_NO":"6932931","INSPECTION_BEGIN_DT":"02/14/2023","INSPECTION_END_DT":"02/15/2023","ACTIVITY_CODE":"E01","ACTIVITY":"Regular Safety and Health Inspection","NBR_INSPECTOR":"1","SUM_TOTAL_INSP_HOURS":"18.75","SUM_TOTAL_ON_SITE_HOURS":"11.5","sourceDate":"2023-02-14"},{"SOURCE_ROW_NUMBER":"220615","EVENT_NO":"6888339","INSPECTION_BEGIN_DT":"11/02/2021","INSPECTION_END_DT":"11/02/2021","ACTIVITY_CODE":"E01","ACTIVITY":"Regular Safety and Health Inspection","NBR_INSPECTOR":"1","SUM_TOTAL_INSP_HOURS":"1.5","SUM_TOTAL_ON_SITE_HOURS":"1.25","sourceDate":"2021-11-02"},{"SOURCE_ROW_NUMBER":"591085","EVENT_NO":"6886535","INSPECTION_BEGIN_DT":"03/29/2021","INSPECTION_END_DT":"03/31/2021","ACTIVITY_CODE":"E01","ACTIVITY":"Regular Safety and Health Inspection","NBR_INSPECTOR":"1","SUM_TOTAL_INSP_HOURS":"8.25","SUM_TOTAL_ON_SITE_HOURS":"1","sourceDate":"2021-03-29"},{"SOURCE_ROW_NUMBER":"867501","EVENT_NO":"6807855","INSPECTION_BEGIN_DT":"11/05/2019","INSPECTION_END_DT":"11/05/2019","ACTIVITY_CODE":"E01","ACTIVITY":"Regular Safety and Health Inspection","NBR_INSPECTOR":"1","SUM_TOTAL_INSP_HOURS":"2.25","SUM_TOTAL_ON_SITE_HOURS":"1.25","sourceDate":"2019-11-05"},{"SOURCE_ROW_NUMBER":"197320","EVENT_NO":"6651252","INSPECTION_BEGIN_DT":"02/25/2019","INSPECTION_END_DT":"02/25/2019","ACTIVITY_CODE":"E01","ACTIVITY":"Regular Safety and Health Inspection","NBR_INSPECTOR":"1","SUM_TOTAL_INSP_HOURS":"5","SUM_TOTAL_ON_SITE_HOURS":"2","sourceDate":"2019-02-25"},{"SOURCE_ROW_NUMBER":"47166","EVENT_NO":"6805006","INSPECTION_BEGIN_DT":"05/09/2018","INSPECTION_END_DT":"05/09/2018","ACTIVITY_CODE":"E01","ACTIVITY":"Regular Safety and Health Inspection","NBR_INSPECTOR":"1","SUM_TOTAL_INSP_HOURS":"6.25","SUM_TOTAL_ON_SITE_HOURS":"3","sourceDate":"2018-05-09"}]},{"id":"msha-mine-production-quarterly","name":"Mine Employment and Production — Quarterly","domains":["production","safety","compliance"],"products":["production trend","employee hours","rate denominators","seasonality"],"rowCount":69,"firstDate":null,"lastDate":null,"metrics":{},"periods":{"2026-Q2":{"hours":606,"employees":2,"production":0},"2026-Q1":{"hours":164,"employees":2,"production":0},"2025-Q4":{"hours":1,"employees":1,"production":0},"2025-Q3":{"hours":92,"employees":2,"production":0},"2025-Q2":{"hours":17,"employees":2,"production":0},"2025-Q1":{"hours":1,"employees":1,"production":0},"2024-Q4":{"hours":11,"employees":2,"production":0},"2024-Q3":{"hours":115,"employees":2,"production":0},"2024-Q2":{"hours":60,"employees":2,"production":0},"2024-Q1":{"hours":255,"employees":2,"production":0},"2023-Q4":{"hours":38,"employees":2,"production":0},"2023-Q3":{"hours":1,"employees":1,"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":18,"firstDate":null,"lastDate":null,"metrics":{},"periods":{"2018":{"hours":729,"employees":2,"production":0},"2019":{"hours":855,"employees":2,"production":0},"2020":{"hours":210,"employees":2,"production":0},"2021":{"hours":34,"employees":2,"production":0},"2022":{"hours":646,"employees":2,"production":0},"2023":{"hours":360,"employees":2,"production":0},"2024":{"hours":441,"employees":2,"production":0},"2025":{"hours":111,"employees":2,"production":0},"2026":{"hours":770,"employees":2,"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":[]},{"id":"msha-personal-health-samples","name":"Metal and Nonmetal Personal Health Samples","domains":["health","safety"],"products":["personal exposure trend","occupation patterns","analyte coverage"],"rowCount":1,"firstDate":"2023-02-15","lastDate":"2023-02-15","metrics":{"recentRows":1,"actionTaken":1,"maxExposureRatio":0,"overExposureLimit":0,"exposureRatioTotal":0},"periods":{},"recentRecords":[{"SOURCE_ROW_NUMBER":"265872","EVENT_NO":"6932931","SAMPLE_NO":"000000202300718800","SAMPLE_DATE":"02/15/2023","CONTAMINANT_DESC":"Respirable dust, <.1mg","CONCENTRATION":"0000.00","EXPOSURE_LIMIT":"0000.00","C_OVER_E":"00.00","JOB_CD_DESC":"Dry Screen Plant Operator","ACTION_TAKEN_DESC":"NO ACTION","sourceDate":"2023-02-15"}]}],"safety":{"href":"/api/v1/mines/3401766/safety","description":"Full-period safety series, top CFR sections and paginated activity. Requires PostgreSQL."},"silica":{"href":"/api/v1/mines/3401766/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":"3401766","dataSource":"postgres","snapshotId":"2026-10-13T11:19:05.459773+00:00","completedAt":"2026-10-13T11:26:59.401Z","sourceCount":20,"totalRows":17906804}}