{"data":{"schemaVersion":"realm.mine-profile.v1","generatedAt":"2026-10-13T11:26:59.401Z","identity":{"mine_id":"2003621","name":"Findlay","status":"Intermittent","status_date":"2021-09-17","mine_type":"Surface","coal_metal":"M","commodity":"Construction Sand and Gravel","state":"MI","county":"Berrien","nearest_town":"Buchanan","operator_id":"L14299","operator_name":"Michiana Aggregate","controller_id":"M40417","controller_name":"John S  Yerington II","district":"M4","office":"Lansing MI Field Office","employees":2,"latitude":41.856389,"longitude":-86.312778},"coverage":{"contributingSources":10,"registeredSources":20,"sourceRows":51},"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":"2003621","name":"Findlay"},"operator":{"type":"operator","id":"L14299","name":"Michiana Aggregate"},"controller":{"type":"controller","id":"M40417","name":"John S  Yerington II"},"source":{"datasetId":"msha-mines","observedAt":"2026-10-13T11:19:05.459773+00:00"}},"edges":[{"type":"controller_controls_mine","subject":{"type":"controller","id":"M40417","name":"John S  Yerington II"},"object":{"type":"mine","id":"2003621","name":"Findlay"},"validFrom":"1994-07-01","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"2003621|M40417|1994-07-01|"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L14299","name":"Michiana Aggregate"},"object":{"type":"mine","id":"2003621","name":"Findlay"},"validFrom":"2021-09-16","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"2003621|L14299|2021-09-16|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M40417","name":"John S  Yerington II"},"object":{"type":"operator","id":"L14299","name":"Michiana Aggregate"},"validFrom":"2021-09-16","validTo":null,"current":true,"derived":true,"evidenceMineId":"2003621","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"2003621|L14299|2021-09-16|M40417|1994-07-01|170131"}}],"coverage":{"historyRecords":1,"edgeCount":3,"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":"2025-01-06","lastDate":"2025-01-06","metrics":{"daysLost":0,"injuries":1,"fatalities":0,"recentRows":1,"restrictedDays":0,"contractorRecords":0},"periods":{},"recentRecords":[{"SOURCE_ROW_NUMBER":"23286","DOCUMENT_NO":"220250070013","ACCIDENT_DT":"01/06/2025","DEGREE_INJURY":"NO DYS AWY FRM WRK,NO RSTR ACT","CLASSIFICATION":"POWERED HAULAGE","ACCIDENT_TYPE":"Struck against stationary object","OCCUPATION":"Beltman, Conveyor man,  Conveyor belt worker, Mobile bridge carrierman, Feeder operator, Conveyor rider","NO_INJURIES":"1","DAYS_LOST":"0","NARRATIVE":"The drive pulleys on the conveyor had become built up with frozen material. The conveyor was started to make sure all of the frozen material had been removed. A large pry bar was left on the conveyor belt when it was started. EE saw it and reached in to grab it when it was grabbed by the drive pulley and smashed EE's hand against the side of the conveyor frame.","sourceDate":"2025-01-06"}]},{"id":"msha-addresses","name":"Addresses of Record","domains":["identity","logistics"],"products":["entity resolution","address history","facility geocoding"],"rowCount":1,"firstDate":"2021-09-17","lastDate":"2021-09-17","metrics":{},"periods":{},"recentRecords":[]},{"id":"msha-assessed-violations","name":"Assessed Violations","domains":["compliance","legal"],"products":["penalty lifecycle","paid and outstanding amounts","assessment aging"],"rowCount":5,"firstDate":"2021-10-13","lastDate":"2025-01-16","metrics":{"ss":2,"delinquent":5,"recentRows":5,"paidPenalty":719,"proposedPenalty":719,"currentAssessment":719},"periods":{},"recentRecords":[{"SOURCE_ROW_NUMBER":"2932055","VIOLATION_NO":"9485752","ISSUE_DT":"01/16/2025","CFR_STANDARD_CD":"56.20003(a)","SIG_SUB_IND":"Y","CITATION_TYPE_CD":"Citation","PROPOSED_PENALTY_AMT":"151.00","CURRENT_ASSESSMENT_AMT":"151.00","ASSESS_CASE_STATUS_CD":"Closed","sourceDate":"2025-01-16"},{"SOURCE_ROW_NUMBER":"2932054","VIOLATION_NO":"9485751","ISSUE_DT":"01/15/2025","CFR_STANDARD_CD":"56.14105","SIG_SUB_IND":"Y","CITATION_TYPE_CD":"Citation","PROPOSED_PENALTY_AMT":"177.00","CURRENT_ASSESSMENT_AMT":"177.00","ASSESS_CASE_STATUS_CD":"Closed","sourceDate":"2025-01-15"},{"SOURCE_ROW_NUMBER":"2691319","VIOLATION_NO":"9623289","ISSUE_DT":"11/09/2022","CFR_STANDARD_CD":"56.14100(b)","SIG_SUB_IND":"N","CITATION_TYPE_CD":"Citation","PROPOSED_PENALTY_AMT":"133.00","CURRENT_ASSESSMENT_AMT":"133.00","ASSESS_CASE_STATUS_CD":"Closed","sourceDate":"2022-11-09"},{"SOURCE_ROW_NUMBER":"2691318","VIOLATION_NO":"9623288","ISSUE_DT":"11/09/2022","CFR_STANDARD_CD":"56.12004","SIG_SUB_IND":"N","CITATION_TYPE_CD":"Citation","PROPOSED_PENALTY_AMT":"133.00","CURRENT_ASSESSMENT_AMT":"133.00","ASSESS_CASE_STATUS_CD":"Closed","sourceDate":"2022-11-09"},{"SOURCE_ROW_NUMBER":"2690893","VIOLATION_NO":"9389956","ISSUE_DT":"10/13/2021","CFR_STANDARD_CD":"56.12008","SIG_SUB_IND":"N","CITATION_TYPE_CD":"Citation","PROPOSED_PENALTY_AMT":"125.00","CURRENT_ASSESSMENT_AMT":"125.00","ASSESS_CASE_STATUS_CD":"Closed","sourceDate":"2021-10-13"}]},{"id":"msha-controller-operator-history","name":"Controller and Operator History","domains":["identity","compliance"],"products":["historical ownership attribution","operator transitions","valid-time joins"],"rowCount":1,"firstDate":"2021-09-16","lastDate":"2021-09-16","metrics":{"recentRows":1,"currentOperatorTenures":1,"completedOperatorTenures":0},"periods":{},"recentRecords":[]},{"id":"msha-inspections","name":"Inspections","domains":["safety","compliance"],"products":["inspection mix","on-site hours","event context","citation rate denominator"],"rowCount":7,"firstDate":"2021-09-22","lastDate":"2026-03-17","metrics":{"inspectors":7,"recentRows":7,"onSiteHours":49,"inspectionHours":93,"inspectionSamples":0},"periods":{},"recentRecords":[{"SOURCE_ROW_NUMBER":"521033","EVENT_NO":"F030DD4","INSPECTION_BEGIN_DT":"03/17/2026","INSPECTION_END_DT":"03/18/2026","ACTIVITY_CODE":"E01","ACTIVITY":"Regular Safety and Health Inspection","NBR_INSPECTOR":"1","SUM_TOTAL_INSP_HOURS":"22.5","SUM_TOTAL_ON_SITE_HOURS":"14.25","sourceDate":"2026-03-17"},{"SOURCE_ROW_NUMBER":"313487","EVENT_NO":"F00A14E","INSPECTION_BEGIN_DT":"01/15/2025","INSPECTION_END_DT":"01/17/2025","ACTIVITY_CODE":"E01","ACTIVITY":"Regular Safety and Health Inspection","NBR_INSPECTOR":"1","SUM_TOTAL_INSP_HOURS":"14","SUM_TOTAL_ON_SITE_HOURS":"6.5","sourceDate":"2025-01-15"},{"SOURCE_ROW_NUMBER":"915912","EVENT_NO":"6953065","INSPECTION_BEGIN_DT":"05/07/2024","INSPECTION_END_DT":"05/08/2024","ACTIVITY_CODE":"E01","ACTIVITY":"Regular Safety and Health Inspection","NBR_INSPECTOR":"1","SUM_TOTAL_INSP_HOURS":"5.5","SUM_TOTAL_ON_SITE_HOURS":"4.25","sourceDate":"2024-05-07"},{"SOURCE_ROW_NUMBER":"736533","EVENT_NO":"6902800","INSPECTION_BEGIN_DT":"11/21/2022","INSPECTION_END_DT":"11/21/2022","ACTIVITY_CODE":"E15","ACTIVITY":"Compliance Follow-up Inspection","NBR_INSPECTOR":"1","SUM_TOTAL_INSP_HOURS":"9","SUM_TOTAL_ON_SITE_HOURS":"1.75","sourceDate":"2022-11-21"},{"SOURCE_ROW_NUMBER":"925319","EVENT_NO":"6902797","INSPECTION_BEGIN_DT":"11/09/2022","INSPECTION_END_DT":"11/09/2022","ACTIVITY_CODE":"E01","ACTIVITY":"Regular Safety and Health Inspection","NBR_INSPECTOR":"1","SUM_TOTAL_INSP_HOURS":"11.5","SUM_TOTAL_ON_SITE_HOURS":"6.5","sourceDate":"2022-11-09"},{"SOURCE_ROW_NUMBER":"1133327","EVENT_NO":"6902606","INSPECTION_BEGIN_DT":"10/12/2021","INSPECTION_END_DT":"10/13/2021","ACTIVITY_CODE":"E01","ACTIVITY":"Regular Safety and Health Inspection","NBR_INSPECTOR":"1","SUM_TOTAL_INSP_HOURS":"17.75","SUM_TOTAL_ON_SITE_HOURS":"10.5","sourceDate":"2021-10-12"},{"SOURCE_ROW_NUMBER":"722914","EVENT_NO":"6902200","INSPECTION_BEGIN_DT":"09/22/2021","INSPECTION_END_DT":"09/23/2021","ACTIVITY_CODE":"E01","ACTIVITY":"Regular Safety and Health Inspection","NBR_INSPECTOR":"1","SUM_TOTAL_INSP_HOURS":"12.75","SUM_TOTAL_ON_SITE_HOURS":"5.25","sourceDate":"2021-09-22"}]},{"id":"msha-mine-production-quarterly","name":"Mine Employment and Production — Quarterly","domains":["production","safety","compliance"],"products":["production trend","employee hours","rate denominators","seasonality"],"rowCount":20,"firstDate":null,"lastDate":null,"metrics":{},"periods":{"2026-Q2":{"hours":1281,"employees":2,"production":0},"2026-Q1":{"hours":1156,"employees":2,"production":0},"2025-Q4":{"hours":1602,"employees":2,"production":0},"2025-Q3":{"hours":1113,"employees":2,"production":0},"2025-Q2":{"hours":2030,"employees":3,"production":0},"2025-Q1":{"hours":2091,"employees":4,"production":0},"2024-Q4":{"hours":3096,"employees":4,"production":0},"2024-Q3":{"hours":1749,"employees":3,"production":0},"2024-Q2":{"hours":1750,"employees":4,"production":0},"2024-Q1":{"hours":2234,"employees":3,"production":0},"2023-Q4":{"hours":2048,"employees":3,"production":0},"2023-Q3":{"hours":2188,"employees":3,"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":6,"firstDate":null,"lastDate":null,"metrics":{},"periods":{"2021":{"hours":1241,"employees":2,"production":0},"2022":{"hours":4975,"employees":2,"production":0},"2023":{"hours":6621,"employees":3,"production":0},"2024":{"hours":8829,"employees":4,"production":0},"2025":{"hours":6836,"employees":3,"production":0},"2026":{"hours":2437,"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":4,"firstDate":"2021-10-13","lastDate":"2026-03-18","metrics":{"recentRows":4,"actionTaken":4,"maxExposureRatio":0,"overExposureLimit":0,"exposureRatioTotal":0},"periods":{},"recentRecords":[{"SOURCE_ROW_NUMBER":"306373","EVENT_NO":"F030DD4","SAMPLE_NO":"000000202601134900","SAMPLE_DATE":"03/18/2026","CONTAMINANT_DESC":"Respirable dust, <.1mg","CONCENTRATION":"0000.00","EXPOSURE_LIMIT":"0000.00","C_OVER_E":"00.00","JOB_CD_DESC":"Front-end Loader Operator","ACTION_TAKEN_DESC":"NO ACTION","sourceDate":"2026-03-18"},{"SOURCE_ROW_NUMBER":"306372","EVENT_NO":"F030DD4","SAMPLE_NO":"000000202601134800","SAMPLE_DATE":"03/18/2026","CONTAMINANT_DESC":"Respirable dust, <.1mg","CONCENTRATION":"0000.00","EXPOSURE_LIMIT":"0000.00","C_OVER_E":"00.00","JOB_CD_DESC":"Front-end Loader Operator","ACTION_TAKEN_DESC":"NO ACTION","sourceDate":"2026-03-18"},{"SOURCE_ROW_NUMBER":"282685","EVENT_NO":"6953065","SAMPLE_NO":"000000202402017100","SAMPLE_DATE":"05/08/2024","CONTAMINANT_DESC":"Respirable dust, <.1mg","CONCENTRATION":"0000.00","EXPOSURE_LIMIT":"0000.00","C_OVER_E":"00.00","JOB_CD_DESC":"Front-end Loader Operator","ACTION_TAKEN_DESC":"NO ACTION","sourceDate":"2024-05-08"},{"SOURCE_ROW_NUMBER":"255741","EVENT_NO":"6902606","SAMPLE_NO":"000000202104318700","SAMPLE_DATE":"10/13/2021","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":"2021-10-13"}]},{"id":"msha-violations","name":"Violations","domains":["compliance","safety","legal"],"products":["citation and order record","condition text","Title 30 linkage","abatement patterns"],"rowCount":5,"firstDate":"2021-10-13","lastDate":"2025-01-16","metrics":{"ss":2,"amountDue":719,"contested":0,"amountPaid":719,"recentRows":5,"section104d":0,"unterminated":0,"proposedPenalty":719},"periods":{},"recentRecords":[{"SOURCE_ROW_NUMBER":"1327690","VIOLATION_NO":"9485752","VIOLATION_ISSUE_DT":"01/16/2025","SIG_SUB":"Y","PART_SECTION":"56.20003(a)","CIT_ORD_SAFE":"Citation","LIKELIHOOD":"Reasonably","INJ_ILLNESS":"LostDays","NO_AFFECTED":"1","NEGLIGENCE":"ModNegligence","TERMINATION_DT":"01/16/2025","PROPOSED_PENALTY":"151","AMOUNT_DUE":"151","AMOUNT_PAID":"151","CONTESTED_IND":"N","sourceDate":"2025-01-16"},{"SOURCE_ROW_NUMBER":"1327689","VIOLATION_NO":"9485751","VIOLATION_ISSUE_DT":"01/15/2025","SIG_SUB":"Y","PART_SECTION":"56.14105","CIT_ORD_SAFE":"Citation","LIKELIHOOD":"Reasonably","INJ_ILLNESS":"Permanent","NO_AFFECTED":"1","NEGLIGENCE":"ModNegligence","TERMINATION_DT":"01/16/2025","PROPOSED_PENALTY":"177","AMOUNT_DUE":"177","AMOUNT_PAID":"177","CONTESTED_IND":"N","sourceDate":"2025-01-15"},{"SOURCE_ROW_NUMBER":"1327693","VIOLATION_NO":"9623289","VIOLATION_ISSUE_DT":"11/09/2022","SIG_SUB":"N","PART_SECTION":"56.14100(b)","CIT_ORD_SAFE":"Citation","LIKELIHOOD":"Unlikely","INJ_ILLNESS":"LostDays","NO_AFFECTED":"1","NEGLIGENCE":"LowNegligence","TERMINATION_DT":"11/21/2022","PROPOSED_PENALTY":"133","AMOUNT_DUE":"133","AMOUNT_PAID":"133","CONTESTED_IND":"N","sourceDate":"2022-11-09"},{"SOURCE_ROW_NUMBER":"1327692","VIOLATION_NO":"9623288","VIOLATION_ISSUE_DT":"11/09/2022","SIG_SUB":"N","PART_SECTION":"56.12004","CIT_ORD_SAFE":"Citation","LIKELIHOOD":"Unlikely","INJ_ILLNESS":"Fatal","NO_AFFECTED":"1","NEGLIGENCE":"LowNegligence","TERMINATION_DT":"11/09/2022","PROPOSED_PENALTY":"133","AMOUNT_DUE":"133","AMOUNT_PAID":"133","CONTESTED_IND":"N","sourceDate":"2022-11-09"},{"SOURCE_ROW_NUMBER":"1327691","VIOLATION_NO":"9389956","VIOLATION_ISSUE_DT":"10/13/2021","SIG_SUB":"N","PART_SECTION":"56.12008","CIT_ORD_SAFE":"Citation","LIKELIHOOD":"Unlikely","INJ_ILLNESS":"LostDays","NO_AFFECTED":"1","NEGLIGENCE":"LowNegligence","TERMINATION_DT":"10/13/2021","PROPOSED_PENALTY":"125","AMOUNT_DUE":"125","AMOUNT_PAID":"125","CONTESTED_IND":"N","sourceDate":"2021-10-13"}]}],"safety":{"href":"/api/v1/mines/2003621/safety","description":"Full-period safety series, top CFR sections and paginated activity. Requires PostgreSQL."},"silica":{"href":"/api/v1/mines/2003621/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":[{"chapter":"I","heading":"Housekeeping.","officialUrl":"https://www.ecfr.gov/current/title-30/chapter-I/subchapter-K/part-56/subpart-S/section-56.20003","part":"56","subchapter":"K","subpart":"S","id":"56.20003","citation":"30 CFR 56.20003","chapterHeading":"CHAPTER I—MINE SAFETY AND HEALTH ADMINISTRATION, DEPARTMENT OF LABOR","subchapterHeading":"SUBCHAPTER K—METAL AND NONMETAL MINE SAFETY AND HEALTH","partHeading":"PART 56—SAFETY AND HEALTH STANDARDS—SURFACE METAL AND NONMETAL MINES","subpartHeading":"","text":null,"occurrenceCount":1},{"chapter":"I","heading":"Procedures during repairs or maintenance.","officialUrl":"https://www.ecfr.gov/current/title-30/chapter-I/subchapter-K/part-56/subpart-M/section-56.14105","part":"56","subchapter":"K","subpart":"M","id":"56.14105","citation":"30 CFR 56.14105","chapterHeading":"CHAPTER I—MINE SAFETY AND HEALTH ADMINISTRATION, DEPARTMENT OF LABOR","subchapterHeading":"SUBCHAPTER K—METAL AND NONMETAL MINE SAFETY AND HEALTH","partHeading":"PART 56—SAFETY AND HEALTH STANDARDS—SURFACE METAL AND NONMETAL MINES","subpartHeading":"","text":null,"occurrenceCount":1},{"chapter":"I","heading":"Safety defects; examination, correction and records.","officialUrl":"https://www.ecfr.gov/current/title-30/chapter-I/subchapter-K/part-56/subpart-M/section-56.14100","part":"56","subchapter":"K","subpart":"M","id":"56.14100","citation":"30 CFR 56.14100","chapterHeading":"CHAPTER I—MINE SAFETY AND HEALTH ADMINISTRATION, DEPARTMENT OF LABOR","subchapterHeading":"SUBCHAPTER K—METAL AND NONMETAL MINE SAFETY AND HEALTH","partHeading":"PART 56—SAFETY AND HEALTH STANDARDS—SURFACE METAL AND NONMETAL MINES","subpartHeading":"","text":null,"occurrenceCount":1},{"chapter":"I","heading":"Electrical conductors.","officialUrl":"https://www.ecfr.gov/current/title-30/chapter-I/subchapter-K/part-56/subpart-K/section-56.12004","part":"56","subchapter":"K","subpart":"K","id":"56.12004","citation":"30 CFR 56.12004","chapterHeading":"CHAPTER I—MINE SAFETY AND HEALTH ADMINISTRATION, DEPARTMENT OF LABOR","subchapterHeading":"SUBCHAPTER K—METAL AND NONMETAL MINE SAFETY AND HEALTH","partHeading":"PART 56—SAFETY AND HEALTH STANDARDS—SURFACE METAL AND NONMETAL MINES","subpartHeading":"","text":null,"occurrenceCount":1},{"chapter":"I","heading":"Insulation and fittings for power wires and cables.","officialUrl":"https://www.ecfr.gov/current/title-30/chapter-I/subchapter-K/part-56/subpart-K/section-56.12008","part":"56","subchapter":"K","subpart":"K","id":"56.12008","citation":"30 CFR 56.12008","chapterHeading":"CHAPTER I—MINE SAFETY AND HEALTH ADMINISTRATION, DEPARTMENT OF LABOR","subchapterHeading":"SUBCHAPTER K—METAL AND NONMETAL MINE SAFETY AND HEALTH","partHeading":"PART 56—SAFETY AND HEALTH STANDARDS—SURFACE METAL AND NONMETAL MINES","subpartHeading":"","text":null,"occurrenceCount":1}],"fullCorpus":"/data/title30-sections.json"}}},"meta":{"representation":"json","mineId":"2003621","dataSource":"postgres","snapshotId":"2026-10-13T11:19:05.459773+00:00","completedAt":"2026-10-13T11:26:59.401Z","sourceCount":20,"totalRows":17906804}}