{"schemaVersion":"realm.silica.v1","mineId":"2302171","mineName":"Sugar Creek Ug Mine","filters":{"year":"2026","dataset":"all","status":"all"},"options":{"years":["2026","2024","2020","2017","2014","2013","2012","2009","2008","2006","2005","2004","2002","2001"],"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":51,"sourceCoverage":[{"dataset":"coal","sourceRows":0,"retainedRows":0},{"dataset":"personal","sourceRows":507,"retainedRows":507},{"dataset":"area","sourceRows":35,"retainedRows":35}],"invalidOrFutureDateRows":0,"firstDate":"2026-01-13","lastDate":"2026-01-14"},"summary":{"total":10,"coal":0,"personal":7,"area":3,"notVoided":0,"voided":0,"statusNotReported":10,"coalMeasured":0,"coalMissingConcentration":0,"coalMeanUgM3":null,"coalMaxUgM3":null,"personalMeasured":7,"personalAbovePublishedLimit":0},"quarters":[{"quarter":"2026-Q1","coalMeanUgM3":null,"coalMeasurementCount":0,"personalMeanExposureRatio":0.07428571428571429,"personalMeasurementCount":7,"partialQuarter":false},{"quarter":"2026-Q2","coalMeanUgM3":null,"coalMeasurementCount":0,"personalMeanExposureRatio":null,"personalMeasurementCount":0,"partialQuarter":false},{"quarter":"2026-Q3","coalMeanUgM3":null,"coalMeasurementCount":0,"personalMeanExposureRatio":null,"personalMeasurementCount":0,"partialQuarter":false},{"quarter":"2026-Q4","coalMeanUgM3":null,"coalMeasurementCount":0,"personalMeanExposureRatio":null,"personalMeasurementCount":0,"partialQuarter":true}],"data":[{"key":"msha-area-samples:2802","dataset":"area","sourceId":"msha-area-samples","sourceRowNumber":"2802","sampleId":"000000202600114374","laboratoryId":null,"date":"2026-01-14","dateRaw":"01/14/2026","dateStatus":"reported","analyte":"QUARTZ (BULK DUST)","occupation":"SF ORE TRANSFER","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0000.0000","sourceExposureLimit":null,"sourceConcentrationUnit":null,"exposureRatio":null,"action":"NO ACTION","eventId":"F01EB36","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"2802","SAMPLE_NO":"000000202600114374","SAMPLE_DATE":"01/14/2026","CONTAMINANT_CD":"00931","CONTAMINANT_CD_DESC":"QUARTZ (BULK DUST)","CONCENTRATION":" 0000.0000","AREA_SAMPLED":"SF ORE TRANSFER","EVENT_NO":"F01EB36","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}},{"key":"msha-area-samples:6161","dataset":"area","sourceId":"msha-area-samples","sourceRowNumber":"6161","sampleId":"000000202600114474","laboratoryId":null,"date":"2026-01-14","dateRaw":"01/14/2026","dateStatus":"reported","analyte":"QUARTZ (BULK DUST)","occupation":"SF SHOP","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0000.0000","sourceExposureLimit":null,"sourceConcentrationUnit":null,"exposureRatio":null,"action":"NO ACTION","eventId":"F01EB36","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"6161","SAMPLE_NO":"000000202600114474","SAMPLE_DATE":"01/14/2026","CONTAMINANT_CD":"00931","CONTAMINANT_CD_DESC":"QUARTZ (BULK DUST)","CONCENTRATION":" 0000.0000","AREA_SAMPLED":"SF SHOP","EVENT_NO":"F01EB36","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}},{"key":"msha-personal-health-samples:302413","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"302413","sampleId":"000000202600114000","laboratoryId":null,"date":"2026-01-14","dateRaw":"01/14/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Front-end Loader Operator","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0000.56","sourceExposureLimit":"0002.27","sourceConcentrationUnit":null,"exposureRatio":0.25,"action":"NO ACTION","eventId":"F01EB36","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"302413","SAMPLE_NO":"000000202600114000","SAMPLE_DATE":"01/14/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0000.56","EXPOSURE_LIMIT":" 0002.27","C_OVER_E":" 00.25","JOB_CD_DESC":"Front-end Loader Operator","EVENT_NO":"F01EB36","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}},{"key":"msha-personal-health-samples:302414","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"302414","sampleId":"000000202600114100","laboratoryId":null,"date":"2026-01-14","dateRaw":"01/14/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Laborer, Bullgang","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0000.38","sourceExposureLimit":"0000.00","sourceConcentrationUnit":null,"exposureRatio":0,"action":"NO ACTION","eventId":"F01EB36","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"302414","SAMPLE_NO":"000000202600114100","SAMPLE_DATE":"01/14/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0000.38","EXPOSURE_LIMIT":" 0000.00","C_OVER_E":" 00.00","JOB_CD_DESC":"Laborer, Bullgang","EVENT_NO":"F01EB36","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}},{"key":"msha-personal-health-samples:302415","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"302415","sampleId":"000000202600114200","laboratoryId":null,"date":"2026-01-14","dateRaw":"01/14/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Laborer, Bullgang","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0000.56","sourceExposureLimit":"0002.04","sourceConcentrationUnit":null,"exposureRatio":0.27,"action":"NO ACTION","eventId":"F01EB36","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"302415","SAMPLE_NO":"000000202600114200","SAMPLE_DATE":"01/14/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0000.56","EXPOSURE_LIMIT":" 0002.04","C_OVER_E":" 00.27","JOB_CD_DESC":"Laborer, Bullgang","EVENT_NO":"F01EB36","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}},{"key":"msha-area-samples:3907","dataset":"area","sourceId":"msha-area-samples","sourceRowNumber":"3907","sampleId":"000000202600113674","laboratoryId":null,"date":"2026-01-13","dateRaw":"01/13/2026","dateStatus":"reported","analyte":"QUARTZ (BULK DUST)","occupation":"UG ACTIVE MINING","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0000.0000","sourceExposureLimit":null,"sourceConcentrationUnit":null,"exposureRatio":null,"action":"NO ACTION","eventId":"F01EB36","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"3907","SAMPLE_NO":"000000202600113674","SAMPLE_DATE":"01/13/2026","CONTAMINANT_CD":"00931","CONTAMINANT_CD_DESC":"QUARTZ (BULK DUST)","CONCENTRATION":" 0000.0000","AREA_SAMPLED":"UG ACTIVE MINING","EVENT_NO":"F01EB36","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}},{"key":"msha-personal-health-samples:307961","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"307961","sampleId":"000000202600113100","laboratoryId":null,"date":"2026-01-13","dateRaw":"01/13/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Blaster, Powder Gang","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0000.31","sourceExposureLimit":"0000.00","sourceConcentrationUnit":null,"exposureRatio":0,"action":"NO ACTION","eventId":"F01EB36","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"307961","SAMPLE_NO":"000000202600113100","SAMPLE_DATE":"01/13/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0000.31","EXPOSURE_LIMIT":" 0000.00","C_OVER_E":" 00.00","JOB_CD_DESC":"Blaster, Powder Gang","EVENT_NO":"F01EB36","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}},{"key":"msha-personal-health-samples:307962","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"307962","sampleId":"000000202600113200","laboratoryId":null,"date":"2026-01-13","dateRaw":"01/13/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Drill Operator, Jumbo Perc.","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0000.17","sourceExposureLimit":"0000.00","sourceConcentrationUnit":null,"exposureRatio":0,"action":"NO ACTION","eventId":"F01EB36","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"307962","SAMPLE_NO":"000000202600113200","SAMPLE_DATE":"01/13/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0000.17","EXPOSURE_LIMIT":" 0000.00","C_OVER_E":" 00.00","JOB_CD_DESC":"Drill Operator, Jumbo Perc.","EVENT_NO":"F01EB36","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}},{"key":"msha-personal-health-samples:307963","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"307963","sampleId":"000000202600113300","laboratoryId":null,"date":"2026-01-13","dateRaw":"01/13/2026","dateStatus":"reported","analyte":"Quartz, respirable, >1% Qtz","occupation":"Blaster, Powder Gang","sampleType":null,"status":"not_reported","statusDetail":null,"quartzPercent":null,"quartzConcentrationUgM3":null,"sourceConcentration":"0000.43","sourceExposureLimit":"0000.00","sourceConcentrationUnit":null,"exposureRatio":0,"action":"NO ACTION","eventId":"F01EB36","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"307963","SAMPLE_NO":"000000202600113300","SAMPLE_DATE":"01/13/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0000.43","EXPOSURE_LIMIT":" 0000.00","C_OVER_E":" 00.00","JOB_CD_DESC":"Blaster, Powder Gang","EVENT_NO":"F01EB36","ACTION_TAKEN_DESC":"NO ACTION                                                                      "}},{"key":"msha-personal-health-samples:307964","dataset":"personal","sourceId":"msha-personal-health-samples","sourceRowNumber":"307964","sampleId":"000000202600113400","laboratoryId":null,"date":"2026-01-13","dateRaw":"01/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.17","sourceExposureLimit":"0000.00","sourceConcentrationUnit":null,"exposureRatio":0,"action":"NO ACTION","eventId":"F01EB36","controlOrInvalid":false,"raw":{"SOURCE_ROW_NUMBER":"307964","SAMPLE_NO":"000000202600113400","SAMPLE_DATE":"01/13/2026","CONTAMINANT_CD":"00523","CONTAMINANT_DESC":"Quartz, respirable, >1% Qtz","CONCENTRATION":" 0000.17","EXPOSURE_LIMIT":" 0000.00","C_OVER_E":" 00.00","JOB_CD_DESC":"Truck Driver","EVENT_NO":"F01EB36","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"}}