{"data":{"schemaVersion":"realm.mine-profile.v1","generatedAt":"2026-10-13T11:26:59.401Z","identity":{"mine_id":"2200619","name":"HAMILTON PIT","status":"Abandoned","status_date":"2001-02-26","mine_type":"Surface","coal_metal":"M","commodity":"Construction Sand and Gravel","state":"MS","county":"Lowndes","nearest_town":"","operator_id":"L11632","operator_name":"Golden Triangle Sand & Gravel Inc","controller_id":"M08990","controller_name":"W G  Cook III","district":"M3","office":"Birmingham AL Field Office (A)","employees":0,"latitude":null,"longitude":null},"coverage":{"contributingSources":7,"registeredSources":20,"sourceRows":13},"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":"2200619","name":"HAMILTON PIT"},"operator":{"type":"operator","id":"L11632","name":"Golden Triangle Sand & Gravel Inc"},"controller":{"type":"controller","id":"M08990","name":"W G  Cook III"},"source":{"datasetId":"msha-mines","observedAt":"2026-10-13T11:19:05.459773+00:00"}},"edges":[{"type":"operator_operates_mine","subject":{"type":"operator","id":"L11632","name":"Golden Triangle Sand & Gravel Inc"},"object":{"type":"mine","id":"2200619","name":"HAMILTON PIT"},"validFrom":"1990-05-01","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"2200619|L11632|1990-05-01|"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M08990","name":"W G  Cook III"},"object":{"type":"mine","id":"2200619","name":"HAMILTON PIT"},"validFrom":"1990-05-01","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"2200619|M08990|1990-05-01|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M08990","name":"W G  Cook III"},"object":{"type":"operator","id":"L11632","name":"Golden Triangle Sand & Gravel Inc"},"validFrom":"1990-05-01","validTo":null,"current":true,"derived":true,"evidenceMineId":"2200619","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"2200619|L11632|1990-05-01|M08990|1990-05-01|144832"}}],"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":"2000-01-31","lastDate":"2000-01-31","metrics":{"daysLost":4,"injuries":1,"fatalities":0,"recentRows":0,"restrictedDays":0,"contractorRecords":0},"periods":{},"recentRecords":[{"SOURCE_ROW_NUMBER":"126257","DOCUMENT_NO":"220000450018","ACCIDENT_DT":"01/31/2000","DEGREE_INJURY":"DAYS AWAY FROM WORK ONLY","CLASSIFICATION":"POWERED HAULAGE","ACCIDENT_TYPE":"Caught in, under or between a moving and a stationary object","OCCUPATION":"Front-end loader, Scraper-loader operator, Pan operator, Payloader, Scraper rig operator","NO_INJURIES":"1","DAYS_LOST":"4","NARRATIVE":"VICTIM WAS IN BOAT UNHOOKING CHAIN FROM PIPELINE, WHEN OPERATOR LIFTED. CHAIN WITH LOADER TO MOVE OVER HOOK CAUGHT CAUSING CHAIN TO MASH VICTIMS FINGER BTWEEN CHAIN AND SIDE OF BOAT. WE DID NT THINK HE WAS HURT BADY BUT SWELLING A FEW DAYS LATER CAUSED US TO SENT TO DR ON 2-7-00.","sourceDate":"2000-01-31"}]},{"id":"msha-addresses","name":"Addresses of Record","domains":["identity","logistics"],"products":["entity resolution","address history","facility geocoding"],"rowCount":1,"firstDate":"2001-02-26","lastDate":"2001-02-26","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":1,"firstDate":"1990-05-01","lastDate":"1990-05-01","metrics":{"recentRows":0,"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":2,"firstDate":"2000-01-05","lastDate":"2000-04-13","metrics":{"inspectors":2,"recentRows":0,"onSiteHours":10,"inspectionHours":22,"inspectionSamples":0},"periods":{},"recentRecords":[{"SOURCE_ROW_NUMBER":"412698","EVENT_NO":"0668113","INSPECTION_BEGIN_DT":"04/13/2000","INSPECTION_END_DT":"04/13/2000","ACTIVITY_CODE":"01","ACTIVITY":"REGULAR INSPECTION","NBR_INSPECTOR":"1","SUM_TOTAL_INSP_HOURS":"9","SUM_TOTAL_ON_SITE_HOURS":"4","sourceDate":"2000-04-13"},{"SOURCE_ROW_NUMBER":"1068766","EVENT_NO":"0751754","INSPECTION_BEGIN_DT":"01/05/2000","INSPECTION_END_DT":"01/05/2000","ACTIVITY_CODE":"01","ACTIVITY":"REGULAR INSPECTION","NBR_INSPECTOR":"1","SUM_TOTAL_INSP_HOURS":"13","SUM_TOTAL_ON_SITE_HOURS":"6","sourceDate":"2000-01-05"}]},{"id":"msha-mine-production-quarterly","name":"Mine Employment and Production — Quarterly","domains":["production","safety","compliance"],"products":["production trend","employee hours","rate denominators","seasonality"],"rowCount":6,"firstDate":null,"lastDate":null,"metrics":{},"periods":{"2001-Q2":{"hours":0,"employees":0,"production":0},"2001-Q1":{"hours":0,"employees":0,"production":0},"2000-Q4":{"hours":0,"employees":0,"production":0},"2000-Q3":{"hours":1054,"employees":3,"production":0},"2000-Q2":{"hours":1806,"employees":3,"production":0},"2000-Q1":{"hours":1815,"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":1,"firstDate":null,"lastDate":null,"metrics":{},"periods":{"2000":{"hours":4675,"employees":3,"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/2200619/safety","description":"Full-period safety series, top CFR sections and paginated activity. Requires PostgreSQL."},"silica":{"href":"/api/v1/mines/2200619/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":"2200619","dataSource":"postgres","snapshotId":"2026-10-13T11:19:05.459773+00:00","completedAt":"2026-10-13T11:26:59.401Z","sourceCount":20,"totalRows":17906804}}