{"schemaVersion":"realm.silica.v1","mineId":"2602512","mineName":"Leeville","filters":{"year":"2026","dataset":"all","status":"all"},"options":{"years":["2026","2025","2024","2023","2022","2020","2019","2017","2015","2014","2013","2011","2010","2008","2007","2003"],"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":63,"sourceCoverage":[{"dataset":"coal","sourceRows":0,"retainedRows":0},{"dataset":"personal","sourceRows":358,"retainedRows":358},{"dataset":"area","sourceRows":7,"retainedRows":7}],"invalidOrFutureDateRows":0,"firstDate":"2026-01-22","lastDate":"2026-09-03"},"summary":{"total":10,"coal":0,"personal":10,"area":0,"notVoided":0,"voided":0,"statusNotReported":10,"coalMeasured":0,"coalMissingConcentration":0,"coalMeanUgM3":null,"coalMaxUgM3":null,"personalMeasured":10,"personalAbovePublishedLimit":3},"quarters":[{"quarter":"2026-Q1","coalMeanUgM3":null,"coalMeasurementCount":0,"personalMeanExposureRatio":1.122,"personalMeasurementCount":5,"partialQuarter":false},{"quarter":"2026-Q2","coalMeanUgM3":null,"coalMeasurementCount":0,"personalMeanExposureRatio":0.7366666666666667,"personalMeasurementCount":3,"partialQuarter":false},{"quarter":"2026-Q3","coalMeanUgM3":null,"coalMeasurementCount":0,"personalMeanExposureRatio":1.065,"personalMeasurementCount":2,"partialQuarter":false},{"quarter":"2026-Q4","coalMeanUgM3":null,"coalMeasurementCount":0,"personalMeanExposureRatio":null,"personalMeasurementCount":0,"partialQuarter":true}],"data":[{"key":"msha-personal-health-samples:314622","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"314622","sampleId":"000000202603700300","laboratoryId":null,"date":"2026-09-03","dateRaw":"09/03/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Mechanic","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0000.27","sourceExposureLimit":"0000.61","sourceConcentrationUnit":null,"exposureRatio":0.44,"action":"NO ACTION","eventId":"F011AEA","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"314622","SAMPLE_NO":"000000202603700300","SAMPLE_DATE":"09/03/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0000.27","EXPOSURE_LIMIT":" 0000.61","C_OVER_E":" 00.44","JOB_CD_DESC":"Mechanic","EVENT_NO":"F011AEA","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}},{"key":"msha-personal-health-samples:313874","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"313874","sampleId":"000000202603091800","laboratoryId":null,"date":"2026-07-30","dateRaw":"07/30/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Supervisor, Co. Official","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0000.81","sourceExposureLimit":"0000.48","sourceConcentrationUnit":null,"exposureRatio":1.69,"action":"CITATION/ORDER EXTENDED","eventId":"F013EC8","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"313874","SAMPLE_NO":"000000202603091800","SAMPLE_DATE":"07/30/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0000.81","EXPOSURE_LIMIT":" 0000.48","C_OVER_E":" 01.69","JOB_CD_DESC":"Supervisor, Co. Official","EVENT_NO":"F013EC8","ACTION_TAKEN_DESC":"CITATION/ORDER EXTENDED                                                        "}},{"key":"msha-personal-health-samples:309399","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"309399","sampleId":"000000202602092400","laboratoryId":null,"date":"2026-05-19","dateRaw":"05/19/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Supervisor, Co. Official","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0000.21","sourceExposureLimit":"0000.77","sourceConcentrationUnit":null,"exposureRatio":0.27,"action":"NO ACTION","eventId":"F011FCF","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"309399","SAMPLE_NO":"000000202602092400","SAMPLE_DATE":"05/19/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0000.21","EXPOSURE_LIMIT":" 0000.77","C_OVER_E":" 00.27","JOB_CD_DESC":"Supervisor, Co. Official","EVENT_NO":"F011FCF","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}},{"key":"msha-personal-health-samples:309400","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"309400","sampleId":"000000202602092500","laboratoryId":null,"date":"2026-05-19","dateRaw":"05/19/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Pump, Slurry Mix Operator","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0000.32","sourceExposureLimit":"0000.49","sourceConcentrationUnit":null,"exposureRatio":0.65,"action":"NO ACTION","eventId":"F011FCF","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"309400","SAMPLE_NO":"000000202602092500","SAMPLE_DATE":"05/19/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0000.32","EXPOSURE_LIMIT":" 0000.49","C_OVER_E":" 00.65","JOB_CD_DESC":"Pump, Slurry Mix Operator","EVENT_NO":"F011FCF","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}},{"key":"msha-personal-health-samples:309401","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"309401","sampleId":"000000202602092600","laboratoryId":null,"date":"2026-05-19","dateRaw":"05/19/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Supervisor, Co. Official","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0000.67","sourceExposureLimit":"0000.52","sourceConcentrationUnit":null,"exposureRatio":1.29,"action":"CITATION/ORDER ISSUED","eventId":"F011FCF","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"309401","SAMPLE_NO":"000000202602092600","SAMPLE_DATE":"05/19/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0000.67","EXPOSURE_LIMIT":" 0000.52","C_OVER_E":" 01.29","JOB_CD_DESC":"Supervisor, Co. Official","EVENT_NO":"F011FCF","ACTION_TAKEN_DESC":"CITATION/ORDER ISSUED                                                          "}},{"key":"msha-personal-health-samples:306155","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"306155","sampleId":"000000202601178700","laboratoryId":null,"date":"2026-03-19","dateRaw":"03/19/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Drill Operator, Rotary","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0000.35","sourceExposureLimit":"0000.74","sourceConcentrationUnit":null,"exposureRatio":0.47,"action":"CITATION/ORDER TERMINATED","eventId":"F011ACD","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"306155","SAMPLE_NO":"000000202601178700","SAMPLE_DATE":"03/19/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0000.35","EXPOSURE_LIMIT":" 0000.74","C_OVER_E":" 00.47","JOB_CD_DESC":"Drill Operator, Rotary","EVENT_NO":"F011ACD","ACTION_TAKEN_DESC":"CITATION/ORDER TERMINATED                                                      "}},{"key":"msha-personal-health-samples:302474","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"302474","sampleId":"000000202600238200","laboratoryId":null,"date":"2026-01-22","dateRaw":"01/22/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Diamond Drill Operator","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0001.86","sourceExposureLimit":"0000.58","sourceConcentrationUnit":null,"exposureRatio":3.21,"action":"CITATION/ORDER ISSUED","eventId":"F011AC9","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"302474","SAMPLE_NO":"000000202600238200","SAMPLE_DATE":"01/22/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0001.86","EXPOSURE_LIMIT":" 0000.58","C_OVER_E":" 03.21","JOB_CD_DESC":"Diamond Drill Operator","EVENT_NO":"F011AC9","ACTION_TAKEN_DESC":"CITATION/ORDER ISSUED                                                          "}},{"key":"msha-personal-health-samples:302475","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"302475","sampleId":"000000202600238300","laboratoryId":null,"date":"2026-01-22","dateRaw":"01/22/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Utility Man","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0000.73","sourceExposureLimit":"0000.89","sourceConcentrationUnit":null,"exposureRatio":0.82,"action":"NO ACTION","eventId":"F011AC9","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"302475","SAMPLE_NO":"000000202600238300","SAMPLE_DATE":"01/22/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0000.73","EXPOSURE_LIMIT":" 0000.89","C_OVER_E":" 00.82","JOB_CD_DESC":"Utility Man","EVENT_NO":"F011AC9","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}},{"key":"msha-personal-health-samples:302476","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"302476","sampleId":"000000202600238400","laboratoryId":null,"date":"2026-01-22","dateRaw":"01/22/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Utility Man","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0000.74","sourceExposureLimit":"0000.86","sourceConcentrationUnit":null,"exposureRatio":0.86,"action":"NO ACTION","eventId":"F011AC9","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"302476","SAMPLE_NO":"000000202600238400","SAMPLE_DATE":"01/22/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0000.74","EXPOSURE_LIMIT":" 0000.86","C_OVER_E":" 00.86","JOB_CD_DESC":"Utility Man","EVENT_NO":"F011AC9","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}},{"key":"msha-personal-health-samples:302477","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"302477","sampleId":"000000202600238500","laboratoryId":null,"date":"2026-01-22","dateRaw":"01/22/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Diamond Drill Operator","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0000.19","sourceExposureLimit":"0000.77","sourceConcentrationUnit":null,"exposureRatio":0.25,"action":"NO ACTION","eventId":"F011AC9","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"302477","SAMPLE_NO":"000000202600238500","SAMPLE_DATE":"01/22/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0000.19","EXPOSURE_LIMIT":" 0000.77","C_OVER_E":" 00.25","JOB_CD_DESC":"Diamond Drill Operator","EVENT_NO":"F011AC9","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}}],"pagination":{"page":1,"pageSize":20,"totalRows":10,"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-13T11:19:05.459773+00:00","completedAt":"2026-10-13T11:26:59.000Z","sourceCount":20,"totalRows":17906804,"snapshotAt":"2026-10-13T11:19:05.459773+00:00"}}