{"entity":{"kind":"operator","id":"L00020","name":"Fisher Sand & Gravel Company"},"query":{"period":"latest-8","status":"all"},"data":[{"quarter":"2025-Q1","production":0,"hours":47317,"employees":205,"productivity":0,"reportedMineCount":45,"includedMineCount":45,"coverage":"reported","incompleteQuarter":false},{"quarter":"2025-Q2","production":0,"hours":94425,"employees":249,"productivity":0,"reportedMineCount":45,"includedMineCount":45,"coverage":"reported","incompleteQuarter":false},{"quarter":"2025-Q3","production":0,"hours":94105,"employees":222,"productivity":0,"reportedMineCount":45,"includedMineCount":45,"coverage":"reported","incompleteQuarter":false},{"quarter":"2025-Q4","production":0,"hours":78172,"employees":188,"productivity":0,"reportedMineCount":44,"includedMineCount":45,"coverage":"partial","incompleteQuarter":false},{"quarter":"2026-Q1","production":0,"hours":79395,"employees":400,"productivity":0,"reportedMineCount":41,"includedMineCount":45,"coverage":"partial","incompleteQuarter":false},{"quarter":"2026-Q2","production":0,"hours":130192,"employees":303,"productivity":0,"reportedMineCount":37,"includedMineCount":45,"coverage":"partial","incompleteQuarter":false},{"quarter":"2026-Q3","production":null,"hours":null,"employees":null,"productivity":null,"reportedMineCount":0,"includedMineCount":45,"coverage":"missing","incompleteQuarter":false},{"quarter":"2026-Q4","production":null,"hours":null,"employees":null,"productivity":null,"reportedMineCount":0,"includedMineCount":45,"coverage":"missing","incompleteQuarter":true}],"options":[{"value":"latest-8","label":"Last 8 quarters · through snapshot"},{"value":"latest-4","label":"Last 4 quarters · through snapshot"},{"value":"3y","label":"Last 12 quarters"},{"value":"4y","label":"Last 16 quarters"},{"value":"5y","label":"Last 20 quarters"},{"value":"10y","label":"Last 40 quarters"},{"value":"all","label":"All available years · since 1994"},{"value":"2026","label":"2026"},{"value":"2025","label":"2025"},{"value":"2024","label":"2024"},{"value":"2023","label":"2023"},{"value":"2022","label":"2022"},{"value":"2021","label":"2021"},{"value":"2020","label":"2020"},{"value":"2019","label":"2019"},{"value":"2018","label":"2018"},{"value":"2017","label":"2017"},{"value":"2016","label":"2016"},{"value":"2015","label":"2015"},{"value":"2014","label":"2014"},{"value":"2013","label":"2013"},{"value":"2012","label":"2012"},{"value":"2011","label":"2011"},{"value":"2010","label":"2010"},{"value":"2009","label":"2009"},{"value":"2008","label":"2008"},{"value":"2007","label":"2007"},{"value":"2006","label":"2006"},{"value":"2005","label":"2005"},{"value":"2004","label":"2004"},{"value":"2003","label":"2003"},{"value":"2002","label":"2002"},{"value":"2001","label":"2001"},{"value":"2000","label":"2000"},{"value":"1999","label":"1999"},{"value":"1998","label":"1998"},{"value":"1997","label":"1997"},{"value":"1996","label":"1996"},{"value":"1995","label":"1995"},{"value":"1994","label":"1994"}],"summary":{"production":0,"hours":523606,"productivity":0,"productivityQuarters":["2025-Q1","2025-Q2","2025-Q3","2025-Q4","2026-Q1","2026-Q2"],"reportedQuarters":6},"meta":{"dataSource":"postgres","snapshotAt":"2026-10-18T09:31:49.615Z","sourceDatasetId":"msha-mine-production-quarterly","totalMineCount":59,"includedMineCount":45,"includedMineIds":["0203166","0203183","0301938","2400499","2401603","2402535","2902186","2902187","2902336","2902340","3200099","3200156","3200157","3200158","3200507","3200543","3200547","3200550","3200580","3200583","3200596","3200640","3200677","3200732","3200880","3201022","3201024","3201025","3901224","3901265","3901268","3901303","3901317","3901319","3901359","3901382","3901396","3901397","3901398","4105730","4105736","4801400","4801487","4801488","4801489"],"scope":"current_operator_portfolio","entityAttribution":"current_operator","controllerAttribution":null,"units":{"production":"short tons","hours":"employee hours","productivity":"short tons per employee hour","employees":"sum of quarterly average employees across reported subunits"},"safetySeriesAvailable":false,"periodLabel":"2025 Q1 – 2026 Q4","quarters":["2025-Q1","2025-Q2","2025-Q3","2025-Q4","2026-Q1","2026-Q2","2026-Q3","2026-Q4"],"missingQuarters":["2026-Q3","2026-Q4"],"partialQuarters":["2025-Q4","2026-Q1","2026-Q2","2026-Q4"],"calculation":"Totals sum available reports. Productivity is total coal production divided by total employee hours for the same reported quarters; it is null when the measures cover different quarters or hours are zero. Missing reports are null, not zero. Portfolio membership is current, not historical."},"window":{"period":"latest-8","label":"2025-01-01 – 2026-10-18","start":"2025-01-01","end":"2026-10-18","quarters":["2025-Q1","2025-Q2","2025-Q3","2025-Q4","2026-Q1","2026-Q2","2026-Q3","2026-Q4"],"options":[{"value":"latest-8","label":"Last 8 quarters · through snapshot"},{"value":"latest-4","label":"Last 4 quarters · through snapshot"},{"value":"3y","label":"Last 12 quarters"},{"value":"4y","label":"Last 16 quarters"},{"value":"5y","label":"Last 20 quarters"},{"value":"10y","label":"Last 40 quarters"},{"value":"all","label":"All available years · since 1994"},{"value":"2026","label":"2026"},{"value":"2025","label":"2025"},{"value":"2024","label":"2024"},{"value":"2023","label":"2023"},{"value":"2022","label":"2022"},{"value":"2021","label":"2021"},{"value":"2020","label":"2020"},{"value":"2019","label":"2019"},{"value":"2018","label":"2018"},{"value":"2017","label":"2017"},{"value":"2016","label":"2016"},{"value":"2015","label":"2015"},{"value":"2014","label":"2014"},{"value":"2013","label":"2013"},{"value":"2012","label":"2012"},{"value":"2011","label":"2011"},{"value":"2010","label":"2010"},{"value":"2009","label":"2009"},{"value":"2008","label":"2008"},{"value":"2007","label":"2007"},{"value":"2006","label":"2006"},{"value":"2005","label":"2005"},{"value":"2004","label":"2004"},{"value":"2003","label":"2003"},{"value":"2002","label":"2002"},{"value":"2001","label":"2001"},{"value":"2000","label":"2000"},{"value":"1999","label":"1999"},{"value":"1998","label":"1998"},{"value":"1997","label":"1997"},{"value":"1996","label":"1996"},{"value":"1995","label":"1995"},{"value":"1994","label":"1994"}]},"mineMetrics":[{"mineId":"0203166","production":0,"hours":14037,"reportingQuarters":6,"expectedQuarters":8},{"mineId":"0203183","production":0,"hours":3886,"reportingQuarters":6,"expectedQuarters":8},{"mineId":"0301938","production":0,"hours":2546,"reportingQuarters":6,"expectedQuarters":8},{"mineId":"2400499","production":0,"hours":15496,"reportingQuarters":6,"expectedQuarters":8},{"mineId":"2401603","production":0,"hours":14160,"reportingQuarters":6,"expectedQuarters":8},{"mineId":"2402535","production":0,"hours":27272,"reportingQuarters":6,"expectedQuarters":8},{"mineId":"2902186","production":0,"hours":11866,"reportingQuarters":6,"expectedQuarters":8},{"mineId":"2902187","production":0,"hours":0,"reportingQuarters":4,"expectedQuarters":8},{"mineId":"2902336","production":0,"hours":32312,"reportingQuarters":5,"expectedQuarters":8},{"mineId":"2902340","production":0,"hours":15712,"reportingQuarters":6,"expectedQuarters":8},{"mineId":"3200099","production":0,"hours":10628,"reportingQuarters":6,"expectedQuarters":8},{"mineId":"3200156","production":0,"hours":15145,"reportingQuarters":6,"expectedQuarters":8},{"mineId":"3200157","production":0,"hours":4921,"reportingQuarters":6,"expectedQuarters":8},{"mineId":"3200158","production":0,"hours":20427,"reportingQuarters":6,"expectedQuarters":8},{"mineId":"3200507","production":0,"hours":1694,"reportingQuarters":6,"expectedQuarters":8},{"mineId":"3200543","production":0,"hours":0,"reportingQuarters":4,"expectedQuarters":8},{"mineId":"3200547","production":0,"hours":15158,"reportingQuarters":6,"expectedQuarters":8},{"mineId":"3200550","production":0,"hours":16431,"reportingQuarters":6,"expectedQuarters":8},{"mineId":"3200580","production":0,"hours":13240,"reportingQuarters":6,"expectedQuarters":8},{"mineId":"3200583","production":0,"hours":9849,"reportingQuarters":6,"expectedQuarters":8},{"mineId":"3200596","production":0,"hours":17507,"reportingQuarters":6,"expectedQuarters":8},{"mineId":"3200640","production":0,"hours":17043,"reportingQuarters":6,"expectedQuarters":8},{"mineId":"3200677","production":0,"hours":12424,"reportingQuarters":6,"expectedQuarters":8},{"mineId":"3200732","production":0,"hours":0,"reportingQuarters":6,"expectedQuarters":8},{"mineId":"3200880","production":0,"hours":5470,"reportingQuarters":6,"expectedQuarters":8},{"mineId":"3201022","production":0,"hours":19730,"reportingQuarters":6,"expectedQuarters":8},{"mineId":"3201024","production":0,"hours":0,"reportingQuarters":4,"expectedQuarters":8},{"mineId":"3201025","production":0,"hours":9274,"reportingQuarters":6,"expectedQuarters":8},{"mineId":"3901224","production":0,"hours":0,"reportingQuarters":5,"expectedQuarters":8},{"mineId":"3901265","production":0,"hours":37783,"reportingQuarters":6,"expectedQuarters":8},{"mineId":"3901268","production":0,"hours":3124,"reportingQuarters":5,"expectedQuarters":8},{"mineId":"3901303","production":0,"hours":27235,"reportingQuarters":6,"expectedQuarters":8},{"mineId":"3901317","production":0,"hours":20390,"reportingQuarters":6,"expectedQuarters":8},{"mineId":"3901319","production":0,"hours":10262,"reportingQuarters":6,"expectedQuarters":8},{"mineId":"3901359","production":0,"hours":18789,"reportingQuarters":6,"expectedQuarters":8},{"mineId":"3901382","production":0,"hours":12045,"reportingQuarters":6,"expectedQuarters":8},{"mineId":"3901396","production":0,"hours":4050,"reportingQuarters":6,"expectedQuarters":8},{"mineId":"3901397","production":0,"hours":0,"reportingQuarters":4,"expectedQuarters":8},{"mineId":"3901398","production":0,"hours":0,"reportingQuarters":5,"expectedQuarters":8},{"mineId":"4105730","production":0,"hours":12899,"reportingQuarters":6,"expectedQuarters":8},{"mineId":"4105736","production":0,"hours":3448,"reportingQuarters":5,"expectedQuarters":8},{"mineId":"4801400","production":0,"hours":0,"reportingQuarters":6,"expectedQuarters":8},{"mineId":"4801487","production":0,"hours":25607,"reportingQuarters":6,"expectedQuarters":8},{"mineId":"4801488","production":0,"hours":1538,"reportingQuarters":6,"expectedQuarters":8},{"mineId":"4801489","production":0,"hours":20208,"reportingQuarters":6,"expectedQuarters":8}]}