{"data":{"schemaVersion":"realm.temporal-relationships.v1","temporalSemantics":{"validTime":{"granularity":"date","bounds":"inclusive","nullStart":"start date not published in the upstream history row","nullEnd":"open-ended in the upstream history row; not independent proof of present control"},"transactionTime":{"observedAt":"2026-10-13T11:19:05.459773+00:00","meaning":"time the checksum-addressed MDRS artifacts were observed by the PostgreSQL ingestion"},"derivation":{"controllerControlsOperator":"intersection of controller and operator valid-time intervals evidenced through this mine","currentIdentity":"current controller and operator are asserted only by the MDRS Mines snapshot"}},"current":{"mine":{"type":"mine","id":"3001712","name":"Philmont"},"operator":{"type":"operator","id":"L13101","name":"Cranesville Aggregate"},"controller":{"type":"controller","id":"M05813","name":"Joseph Charles Tesiero; John A Tesiero III"},"source":{"datasetId":"msha-mines","observedAt":"2026-10-13T11:19:05.459773+00:00"}},"edges":[{"type":"operator_operates_mine","subject":{"type":"operator","id":"L03380","name":"Columbia Sand & Gravel Inc"},"object":{"type":"mine","id":"3001712","name":"Philmont"},"validFrom":"1950-01-01","validTo":"1979-04-30","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3001712|L03380|1950-01-01|1979-04-30"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M02703","name":"Columbia Sand & Gravel Inc"},"object":{"type":"mine","id":"3001712","name":"Philmont"},"validFrom":"1950-01-01","validTo":"1979-04-30","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3001712|M02703|1950-01-01|1979-04-30"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M02703","name":"Columbia Sand & Gravel Inc"},"object":{"type":"operator","id":"L03380","name":"Columbia Sand & Gravel Inc"},"validFrom":"1950-01-01","validTo":"1979-04-30","current":false,"derived":true,"evidenceMineId":"3001712","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3001712|L03380|1950-01-01|M02703|1950-01-01|126666"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M05813","name":"Joseph Charles Tesiero et al"},"object":{"type":"mine","id":"3001712","name":"Philmont"},"validFrom":"1950-01-01","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3001712|M05813|1950-01-01|"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L03381","name":"Quality Aggregates Inc"},"object":{"type":"mine","id":"3001712","name":"Philmont"},"validFrom":"1979-05-01","validTo":"1990-06-18","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3001712|L03381|1979-05-01|1990-06-18"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M02704","name":"William  Weigelt"},"object":{"type":"mine","id":"3001712","name":"Philmont"},"validFrom":"1979-05-01","validTo":"1990-06-18","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3001712|M02704|1979-05-01|1990-06-18"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M02704","name":"William  Weigelt"},"object":{"type":"operator","id":"L03381","name":"Quality Aggregates Inc"},"validFrom":"1979-05-01","validTo":"1990-06-18","current":false,"derived":true,"evidenceMineId":"3001712","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3001712|L03381|1979-05-01|M02704|1979-05-01|126667"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M12360","name":"John A  Tesiero Jr"},"object":{"type":"mine","id":"3001712","name":"Philmont"},"validFrom":"1987-10-01","validTo":"2016-10-05","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3001712|M12360|1987-10-01|2016-10-05"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L11815","name":"Quality Aggregates Inc"},"object":{"type":"mine","id":"3001712","name":"Philmont"},"validFrom":"1990-06-19","validTo":"1995-10-22","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3001712|L11815|1990-06-19|1995-10-22"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M09113","name":"Clark  Ede"},"object":{"type":"mine","id":"3001712","name":"Philmont"},"validFrom":"1990-06-19","validTo":"1995-10-22","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3001712|M09113|1990-06-19|1995-10-22"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M09113","name":"Clark  Ede"},"object":{"type":"operator","id":"L11815","name":"Quality Aggregates Inc"},"validFrom":"1990-06-19","validTo":"1995-10-22","current":false,"derived":true,"evidenceMineId":"3001712","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3001712|L11815|1990-06-19|M09113|1990-06-19|145110"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L11472","name":"Cranesville Block Company"},"object":{"type":"mine","id":"3001712","name":"Philmont"},"validFrom":"1995-10-23","validTo":"2002-05-28","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3001712|L11472|1995-10-23|2002-05-28"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M12360","name":"John A  Tesiero Jr"},"object":{"type":"operator","id":"L11472","name":"Cranesville Block Company"},"validFrom":"1995-10-23","validTo":"2002-05-28","current":false,"derived":true,"evidenceMineId":"3001712","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3001712|L11472|1995-10-23|M12360|1987-10-01|153570"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"0050930","name":"Cranesville-Quality Aggregates Co. Inc."},"object":{"type":"mine","id":"3001712","name":"Philmont"},"validFrom":"2002-05-29","validTo":"2003-05-01","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3001712|0050930|2002-05-29|2003-05-01"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M12360","name":"John A  Tesiero Jr"},"object":{"type":"mine","id":"3001712","name":"Philmont"},"validFrom":"2002-05-29","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3001712|M12360|2002-05-29|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M12360","name":"John A  Tesiero Jr"},"object":{"type":"operator","id":"0050930","name":"Cranesville-Quality Aggregates Co. Inc."},"validFrom":"2002-05-29","validTo":"2003-05-01","current":false,"derived":true,"evidenceMineId":"3001712","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3001712|0050930|2002-05-29|M12360|2002-05-29|153576"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L13101","name":"Cranesville Aggregate"},"object":{"type":"mine","id":"3001712","name":"Philmont"},"validFrom":"2003-05-02","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3001712|L13101|2003-05-02|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M05813","name":"Joseph Charles Tesiero et al"},"object":{"type":"operator","id":"L13101","name":"Cranesville Aggregate"},"validFrom":"2003-05-02","validTo":null,"current":true,"derived":true,"evidenceMineId":"3001712","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3001712|L13101|2003-05-02|M05813|1950-01-01|135453"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M05813","name":"John A Tesiero III et al"},"object":{"type":"operator","id":"L13101","name":"Cranesville Aggregate"},"validFrom":"2003-05-02","validTo":null,"current":true,"derived":true,"evidenceMineId":"3001712","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3001712|L13101|2003-05-02|M05813|1950-01-01|135454"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M05813","name":"Joseph Charles Tesiero et al"},"object":{"type":"mine","id":"3001712","name":"Philmont"},"validFrom":"2016-10-06","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3001712|M05813|2016-10-06|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M05813","name":"Joseph Charles Tesiero et al"},"object":{"type":"operator","id":"L11472","name":"Cranesville Block Company"},"validFrom":"2016-10-06","validTo":"2002-05-28","current":false,"derived":true,"evidenceMineId":"3001712","intervalAnomaly":true,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3001712|L11472|1995-10-23|M05813|2016-10-06|135473"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M05813","name":"John A Tesiero III et al"},"object":{"type":"operator","id":"L11472","name":"Cranesville Block Company"},"validFrom":"2016-10-06","validTo":"2002-05-28","current":false,"derived":true,"evidenceMineId":"3001712","intervalAnomaly":true,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3001712|L11472|1995-10-23|M05813|2016-10-06|135474"}}],"coverage":{"historyRecords":9,"edgeCount":22,"intervalAnomalies":2,"sourceDatasetId":"msha-controller-operator-history"}},"meta":{"mineId":"3001712","dataSource":"postgres","snapshotId":"2026-10-13T11:19:05.459773+00:00","completedAt":"2026-10-13T11:26:59.401Z","sourceCount":20,"totalRows":17906804,"relationshipSemantics":"valid time; null validTo means current or open-ended in the source"}}