{"schemaVersion":"realm.silica.v1","mineId":"4800154","mineName":"Big Island Mine & Refinery","filters":{"year":"2026","dataset":"all","status":"all"},"options":{"years":["2026","2025","2024","2023","2022","2021","2019","2018","2014","2012","2011","2010","2005","2004"],"datasets":{"coal":{"id":"msha-quartz-samples","label":"Coal quartz","definitionUrl":"https://arlweb.msha.gov/OpenGovernmentData/DataSets/Quartz_Samples_Definition_File.txt"},"personal":{"id":"msha-personal-health-samples","label":"Metal/nonmetal personal","definitionUrl":"https://arlweb.msha.gov/OpenGovernmentData/DataSets/Personal_Health_Samples_Definition_File.txt"},"area":{"id":"msha-area-samples","label":"Metal/nonmetal area","definitionUrl":"https://arlweb.msha.gov/OpenGovernmentData/DataSets/Area_Samples_Definition_File.txt"}},"statuses":{"not_voided":"Not voided","voided":"Voided","not_reported":"Not reported"}},"coverage":{"scope":"full_mine_history","totalSilicaRows":70,"sourceCoverage":[{"dataset":"coal","sourceRows":0,"retainedRows":0},{"dataset":"personal","sourceRows":255,"retainedRows":255},{"dataset":"area","sourceRows":7,"retainedRows":7}],"invalidOrFutureDateRows":0,"firstDate":"2026-02-03","lastDate":"2026-08-24"},"summary":{"total":12,"coal":0,"personal":12,"area":0,"notVoided":0,"voided":0,"statusNotReported":12,"coalMeasured":0,"coalMissingConcentration":0,"coalMeanUgM3":null,"coalMaxUgM3":null,"personalMeasured":12,"personalAbovePublishedLimit":0},"quarters":[{"quarter":"2026-Q1","coalMeanUgM3":null,"coalMeasurementCount":0,"personalMeanExposureRatio":0.4075,"personalMeasurementCount":4,"partialQuarter":false},{"quarter":"2026-Q2","coalMeanUgM3":null,"coalMeasurementCount":0,"personalMeanExposureRatio":0.25,"personalMeasurementCount":5,"partialQuarter":false},{"quarter":"2026-Q3","coalMeanUgM3":null,"coalMeasurementCount":0,"personalMeanExposureRatio":0.08333333333333333,"personalMeasurementCount":3,"partialQuarter":false},{"quarter":"2026-Q4","coalMeanUgM3":null,"coalMeasurementCount":0,"personalMeanExposureRatio":null,"personalMeasurementCount":0,"partialQuarter":true}],"data":[{"key":"msha-personal-health-samples:315307","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"315307","sampleId":"000000202603475000","laboratoryId":null,"date":"2026-08-24","dateRaw":"08/24/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Belt Crew","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0000.63","sourceExposureLimit":"0002.56","sourceConcentrationUnit":null,"exposureRatio":0.25,"action":"NO ACTION","eventId":"F03CC85","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"315307","SAMPLE_NO":"000000202603475000","SAMPLE_DATE":"08/24/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0000.63","EXPOSURE_LIMIT":" 0002.56","C_OVER_E":" 00.25","JOB_CD_DESC":"Belt Crew","EVENT_NO":"F03CC85","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}},{"key":"msha-personal-health-samples:315315","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"315315","sampleId":"000000202603475100","laboratoryId":null,"date":"2026-08-24","dateRaw":"08/24/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Belt Crew","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0000.52","sourceExposureLimit":"0000.00","sourceConcentrationUnit":null,"exposureRatio":0,"action":"NO ACTION","eventId":"F03CC85","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"315315","SAMPLE_NO":"000000202603475100","SAMPLE_DATE":"08/24/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0000.52","EXPOSURE_LIMIT":" 0000.00","C_OVER_E":" 00.00","JOB_CD_DESC":"Belt Crew","EVENT_NO":"F03CC85","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}},{"key":"msha-personal-health-samples:315562","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"315562","sampleId":"000000202603475200","laboratoryId":null,"date":"2026-08-24","dateRaw":"08/24/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Belt Crew","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0000.41","sourceExposureLimit":"0000.00","sourceConcentrationUnit":null,"exposureRatio":0,"action":"NO ACTION","eventId":"F03CC85","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"315562","SAMPLE_NO":"000000202603475200","SAMPLE_DATE":"08/24/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0000.41","EXPOSURE_LIMIT":" 0000.00","C_OVER_E":" 00.00","JOB_CD_DESC":"Belt Crew","EVENT_NO":"F03CC85","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}},{"key":"msha-personal-health-samples:311855","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"311855","sampleId":"000000202601606600","laboratoryId":null,"date":"2026-04-20","dateRaw":"04/20/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Cleanup Man","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0000.52","sourceExposureLimit":"0000.00","sourceConcentrationUnit":null,"exposureRatio":0,"action":"NO ACTION","eventId":"F014CED","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"311855","SAMPLE_NO":"000000202601606600","SAMPLE_DATE":"04/20/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0000.52","EXPOSURE_LIMIT":" 0000.00","C_OVER_E":" 00.00","JOB_CD_DESC":"Cleanup Man","EVENT_NO":"F014CED","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}},{"key":"msha-personal-health-samples:311559","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"311559","sampleId":"000000202601562200","laboratoryId":null,"date":"2026-04-15","dateRaw":"04/15/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Mechanic","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0000.88","sourceExposureLimit":"0002.86","sourceConcentrationUnit":null,"exposureRatio":0.31,"action":"NO ACTION","eventId":"F014CED","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"311559","SAMPLE_NO":"000000202601562200","SAMPLE_DATE":"04/15/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0000.88","EXPOSURE_LIMIT":" 0002.86","C_OVER_E":" 00.31","JOB_CD_DESC":"Mechanic","EVENT_NO":"F014CED","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}},{"key":"msha-personal-health-samples:311560","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"311560","sampleId":"000000202601562300","laboratoryId":null,"date":"2026-04-15","dateRaw":"04/15/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Mechanic","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0001.16","sourceExposureLimit":"0002.70","sourceConcentrationUnit":null,"exposureRatio":0.43,"action":"NO ACTION","eventId":"F014CED","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"311560","SAMPLE_NO":"000000202601562300","SAMPLE_DATE":"04/15/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0001.16","EXPOSURE_LIMIT":" 0002.70","C_OVER_E":" 00.43","JOB_CD_DESC":"Mechanic","EVENT_NO":"F014CED","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}},{"key":"msha-personal-health-samples:311561","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"311561","sampleId":"000000202601562400","laboratoryId":null,"date":"2026-04-15","dateRaw":"04/15/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Mechanic","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0000.67","sourceExposureLimit":"0000.00","sourceConcentrationUnit":null,"exposureRatio":0,"action":"NO ACTION","eventId":"F014CED","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"311561","SAMPLE_NO":"000000202601562400","SAMPLE_DATE":"04/15/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0000.67","EXPOSURE_LIMIT":" 0000.00","C_OVER_E":" 00.00","JOB_CD_DESC":"Mechanic","EVENT_NO":"F014CED","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}},{"key":"msha-personal-health-samples:311562","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"311562","sampleId":"000000202601562500","laboratoryId":null,"date":"2026-04-15","dateRaw":"04/15/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Mechanic","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0001.37","sourceExposureLimit":"0002.70","sourceConcentrationUnit":null,"exposureRatio":0.51,"action":"NO ACTION","eventId":"F014CED","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"311562","SAMPLE_NO":"000000202601562500","SAMPLE_DATE":"04/15/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0001.37","EXPOSURE_LIMIT":" 0002.70","C_OVER_E":" 00.51","JOB_CD_DESC":"Mechanic","EVENT_NO":"F014CED","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}},{"key":"msha-personal-health-samples:307573","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"307573","sampleId":"000000202601091900","laboratoryId":null,"date":"2026-03-17","dateRaw":"03/17/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Roof Bolter, Mounted","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0002.31","sourceExposureLimit":"0003.13","sourceConcentrationUnit":null,"exposureRatio":0.74,"action":"NO ACTION","eventId":"F02708A","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"307573","SAMPLE_NO":"000000202601091900","SAMPLE_DATE":"03/17/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0002.31","EXPOSURE_LIMIT":" 0003.13","C_OVER_E":" 00.74","JOB_CD_DESC":"Roof Bolter, Mounted","EVENT_NO":"F02708A","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}},{"key":"msha-personal-health-samples:303490","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"303490","sampleId":"000000202600465300","laboratoryId":null,"date":"2026-02-10","dateRaw":"02/10/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Crusher Oper/Worker","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0000.47","sourceExposureLimit":"0000.00","sourceConcentrationUnit":null,"exposureRatio":0,"action":"NO ACTION","eventId":"F0264E8","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"303490","SAMPLE_NO":"000000202600465300","SAMPLE_DATE":"02/10/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0000.47","EXPOSURE_LIMIT":" 0000.00","C_OVER_E":" 00.00","JOB_CD_DESC":"Crusher Oper/Worker","EVENT_NO":"F0264E8","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}},{"key":"msha-personal-health-samples:303493","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"303493","sampleId":"000000202600465600","laboratoryId":null,"date":"2026-02-10","dateRaw":"02/10/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Dump Operator","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0000.53","sourceExposureLimit":"0000.00","sourceConcentrationUnit":null,"exposureRatio":0,"action":"NO ACTION","eventId":"F0264E8","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"303493","SAMPLE_NO":"000000202600465600","SAMPLE_DATE":"02/10/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0000.53","EXPOSURE_LIMIT":" 0000.00","C_OVER_E":" 00.00","JOB_CD_DESC":"Dump Operator","EVENT_NO":"F0264E8","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}},{"key":"msha-personal-health-samples:303663","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"303663","sampleId":"000000202600403100","laboratoryId":null,"date":"2026-02-03","dateRaw":"02/03/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Shuttle Car Operator (diesel)","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0002.71","sourceExposureLimit":"0003.03","sourceConcentrationUnit":null,"exposureRatio":0.89,"action":"NO ACTION","eventId":"F0264E8","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"303663","SAMPLE_NO":"000000202600403100","SAMPLE_DATE":"02/03/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0002.71","EXPOSURE_LIMIT":" 0003.03","C_OVER_E":" 00.89","JOB_CD_DESC":"Shuttle Car Operator (diesel)","EVENT_NO":"F0264E8","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}}],"pagination":{"page":1,"pageSize":20,"totalRows":12,"totalPages":1},"units":{"quartzPercent":"%","quartzConcentrationUgM3":"µg/m³","exposureRatio":"concentration / published exposure limit","sourceConcentration":"Unit not specified in MSHA personal/area data dictionary; retained as reported"},"notes":["Coal means use numeric concentrations from samples marked not voided, excluding control/invalid sample types and dates after the snapshot. Missing values remain null; reported zeroes remain zero.","Quarterly means describe available samples, not mine-wide or worker-average exposure. Quarters with no eligible measurements remain empty; the current quarter is partial.","Personal C/E is MSHA's published concentration-to-limit ratio. A value above 1 is not by itself a citation or a determination under the 2024 silica rule. Personal and area files do not publish a void-status field.","Area records include bulk-dust analyses and are kept separate from personal exposure results. Their concentration units are not specified in the source dictionary.","Missing samples do not establish safe conditions. Coal quartz percentage and concentration are separate measures. No compliance threshold is inferred for coal samples."],"meta":{"dataSource":"postgres","snapshotId":"2026-10-17T05:35:58.500035+00:00","completedAt":"2026-10-17T06:17:15.000Z","sourceCount":20,"totalRows":15450873,"snapshotAt":"2026-10-17T05:35:58.500035+00:00"}}