# State Marketplace content-addressed artifact history

`medicare_silver.fact_hix_state_artifact_revision_history` · Provenance · status partial · 524 rows

Common Bronze-first physical-history contract for heterogeneous state Marketplace PDFs, workbooks, JSON feeds and dashboard exports; the exact first candidate plan contains 367 occurrences and 366 unique source bodies.

**Grain.** One source and logical-release revision at an exact content SHA, with separate source-native observation and reviewed-pointer histories.

| column | type | meaning |
|---|---|---|
| artifact_id | string |  |
| source_id | string |  |
| state | string |  |
| family | string |  |
| release_key | string |  |
| content_sha256 | string |  |
| content_bytes | bigint |  |
| media_type | string |  |
| extension | string |  |
| source_url | string |  |
| request_url | string |  |
| bronze_object_key | string |  |
| bronze_version_id | string |  |
| observed_at | string |  |
| parser_id | string |  |
| parser_version | string |  |
| expected_observation_rows | bigint |  |
| physical_snapshot_id | bigint |  |
| supersedes_artifact_id | string |  |

Query it: `query_substrate` with `SELECT ... FROM medicare_silver.fact_hix_state_artifact_revision_history WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.fact_hix_state_artifact_revision_history")` first.