{"schemaVersion":"realm.silica.v1","mineId":"4200769","mineName":"La Sal Complex","filters":{"year":"2026","dataset":"all","status":"all"},"options":{"years":["2026","2025","2024","2023","2019","2018","2011"],"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":56,"sourceCoverage":[{"dataset":"coal","sourceRows":0,"retainedRows":0},{"dataset":"personal","sourceRows":208,"retainedRows":208},{"dataset":"area","sourceRows":27,"retainedRows":27}],"invalidOrFutureDateRows":0,"firstDate":"2026-02-11","lastDate":"2026-08-11"},"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":0},"quarters":[{"quarter":"2026-Q1","coalMeanUgM3":null,"coalMeasurementCount":0,"personalMeanExposureRatio":0.5075,"personalMeasurementCount":4,"partialQuarter":false},{"quarter":"2026-Q2","coalMeanUgM3":null,"coalMeasurementCount":0,"personalMeanExposureRatio":0.3333333333333333,"personalMeasurementCount":3,"partialQuarter":false},{"quarter":"2026-Q3","coalMeanUgM3":null,"coalMeasurementCount":0,"personalMeanExposureRatio":0.19999999999999998,"personalMeasurementCount":3,"partialQuarter":false},{"quarter":"2026-Q4","coalMeanUgM3":null,"coalMeasurementCount":0,"personalMeanExposureRatio":null,"personalMeasurementCount":0,"partialQuarter":true}],"data":[{"key":"msha-personal-health-samples:314534","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"314534","sampleId":"000000202603264700","laboratoryId":null,"date":"2026-08-11","dateRaw":"08/11/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Truck Driver","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0000.38","sourceExposureLimit":"0001.33","sourceConcentrationUnit":null,"exposureRatio":0.29,"action":"NO ACTION","eventId":"F0211FA","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"314534","SAMPLE_NO":"000000202603264700","SAMPLE_DATE":"08/11/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0000.38","EXPOSURE_LIMIT":" 0001.33","C_OVER_E":" 00.29","JOB_CD_DESC":"Truck Driver","EVENT_NO":"F0211FA","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}},{"key":"msha-personal-health-samples:314585","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"314585","sampleId":"000000202603264500","laboratoryId":null,"date":"2026-08-11","dateRaw":"08/11/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Truck Driver","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0000.52","sourceExposureLimit":"0001.67","sourceConcentrationUnit":null,"exposureRatio":0.31,"action":"NO ACTION","eventId":"F0211FA","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"314585","SAMPLE_NO":"000000202603264500","SAMPLE_DATE":"08/11/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0000.52","EXPOSURE_LIMIT":" 0001.67","C_OVER_E":" 00.31","JOB_CD_DESC":"Truck Driver","EVENT_NO":"F0211FA","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}},{"key":"msha-personal-health-samples:314662","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"314662","sampleId":"000000202603264800","laboratoryId":null,"date":"2026-08-11","dateRaw":"08/11/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Mucking Mach. Operator","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0000.30","sourceExposureLimit":"0000.00","sourceConcentrationUnit":null,"exposureRatio":0,"action":"NO ACTION","eventId":"F0211FA","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"314662","SAMPLE_NO":"000000202603264800","SAMPLE_DATE":"08/11/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0000.30","EXPOSURE_LIMIT":" 0000.00","C_OVER_E":" 00.00","JOB_CD_DESC":"Mucking Mach. Operator","EVENT_NO":"F0211FA","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}},{"key":"msha-personal-health-samples:311060","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"311060","sampleId":"000000202601999300","laboratoryId":null,"date":"2026-05-13","dateRaw":"05/13/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Truck Driver","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0000.41","sourceExposureLimit":"0000.91","sourceConcentrationUnit":null,"exposureRatio":0.45,"action":"NO ACTION","eventId":"F00AC92","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"311060","SAMPLE_NO":"000000202601999300","SAMPLE_DATE":"05/13/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0000.41","EXPOSURE_LIMIT":" 0000.91","C_OVER_E":" 00.45","JOB_CD_DESC":"Truck Driver","EVENT_NO":"F00AC92","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}},{"key":"msha-personal-health-samples:311061","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"311061","sampleId":"000000202601999400","laboratoryId":null,"date":"2026-05-13","dateRaw":"05/13/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Truck Driver","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0000.27","sourceExposureLimit":"0000.83","sourceConcentrationUnit":null,"exposureRatio":0.33,"action":"NO ACTION","eventId":"F00AC92","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"311061","SAMPLE_NO":"000000202601999400","SAMPLE_DATE":"05/13/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0000.27","EXPOSURE_LIMIT":" 0000.83","C_OVER_E":" 00.33","JOB_CD_DESC":"Truck Driver","EVENT_NO":"F00AC92","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}},{"key":"msha-personal-health-samples:311062","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"311062","sampleId":"000000202601999500","laboratoryId":null,"date":"2026-05-13","dateRaw":"05/13/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Skip tender","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0000.16","sourceExposureLimit":"0000.74","sourceConcentrationUnit":null,"exposureRatio":0.22,"action":"NO ACTION","eventId":"F00AC92","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"311062","SAMPLE_NO":"000000202601999500","SAMPLE_DATE":"05/13/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0000.16","EXPOSURE_LIMIT":" 0000.74","C_OVER_E":" 00.22","JOB_CD_DESC":"Skip tender","EVENT_NO":"F00AC92","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}},{"key":"msha-personal-health-samples:304500","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"304500","sampleId":"000000202600505200","laboratoryId":null,"date":"2026-02-11","dateRaw":"02/11/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Truck Driver","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0000.44","sourceExposureLimit":"0001.11","sourceConcentrationUnit":null,"exposureRatio":0.4,"action":"NO ACTION","eventId":"F008085","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"304500","SAMPLE_NO":"000000202600505200","SAMPLE_DATE":"02/11/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0000.44","EXPOSURE_LIMIT":" 0001.11","C_OVER_E":" 00.40","JOB_CD_DESC":"Truck Driver","EVENT_NO":"F008085","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}},{"key":"msha-personal-health-samples:304501","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"304501","sampleId":"000000202600505300","laboratoryId":null,"date":"2026-02-11","dateRaw":"02/11/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Bobcat Operator","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0000.57","sourceExposureLimit":"0000.94","sourceConcentrationUnit":null,"exposureRatio":0.61,"action":"NO ACTION","eventId":"F008085","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"304501","SAMPLE_NO":"000000202600505300","SAMPLE_DATE":"02/11/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0000.57","EXPOSURE_LIMIT":" 0000.94","C_OVER_E":" 00.61","JOB_CD_DESC":"Bobcat Operator","EVENT_NO":"F008085","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}},{"key":"msha-personal-health-samples:304776","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"304776","sampleId":"000000202600505400","laboratoryId":null,"date":"2026-02-11","dateRaw":"02/11/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Complete Load-Haul-Dump","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0000.62","sourceExposureLimit":"0000.87","sourceConcentrationUnit":null,"exposureRatio":0.71,"action":"NO ACTION","eventId":"F008085","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"304776","SAMPLE_NO":"000000202600505400","SAMPLE_DATE":"02/11/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0000.62","EXPOSURE_LIMIT":" 0000.87","C_OVER_E":" 00.71","JOB_CD_DESC":"Complete Load-Haul-Dump","EVENT_NO":"F008085","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}},{"key":"msha-personal-health-samples:304777","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"304777","sampleId":"000000202600505500","laboratoryId":null,"date":"2026-02-11","dateRaw":"02/11/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.27","sourceExposureLimit":"0000.86","sourceConcentrationUnit":null,"exposureRatio":0.31,"action":"NO ACTION","eventId":"F008085","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"304777","SAMPLE_NO":"000000202600505500","SAMPLE_DATE":"02/11/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0000.27","EXPOSURE_LIMIT":" 0000.86","C_OVER_E":" 00.31","JOB_CD_DESC":"Drill Operator, Rotary","EVENT_NO":"F008085","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"}}