{"columns":[{"name":"source_id","type":"string"},{"name":"source_family","type":"string"},{"name":"issuing_organization","type":"string"},{"name":"canonical_domains","type":"string"},{"name":"content_classes","type":"string"},{"name":"published_surface","type":"string"},{"name":"redistribution_scope","type":"string"},{"name":"rights_status","type":"string"},{"name":"rights_basis","type":"string"},{"name":"terms_url","type":"string"},{"name":"attribution_text","type":"string"},{"name":"legal_review_required","type":"int64"},{"name":"reviewed_at","type":"string"},{"name":"notes","type":"string"}],"n_rows":9,"rows_kept":9,"cut":false,"text_format":"parquet-jsonl-2026-10-02","bounds":{"document_bytes":16777216,"package_text_limit_bytes":33554432,"package_text_slack_bytes":1024,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096,"vector_min":64,"vector_head_fixed":16,"vector_head_variable":64,"kv_value_chars":1048576,"nesting_max":64,"binary_text":true},"cells_cut":0,"cells_bad_utf8":0,"cells_raw":0,"cells_binary":0,"cells_binary_text":0,"cells_vector":0,"n_row_groups":1,"reader":"pyarrow 23.0.1, python 3.13","created_by":"parquet-cpp-arrow version 25.0.0","schema":{"fields":[{"name":"source_id","type":"string","nullable":false,"metadata":null,"children":null},{"name":"source_family","type":"string","nullable":false,"metadata":null,"children":null},{"name":"issuing_organization","type":"string","nullable":false,"metadata":null,"children":null},{"name":"canonical_domains","type":"string","nullable":false,"metadata":null,"children":null},{"name":"content_classes","type":"string","nullable":false,"metadata":null,"children":null},{"name":"published_surface","type":"string","nullable":false,"metadata":null,"children":null},{"name":"redistribution_scope","type":"string","nullable":false,"metadata":null,"children":null},{"name":"rights_status","type":"string","nullable":false,"metadata":null,"children":null},{"name":"rights_basis","type":"string","nullable":false,"metadata":null,"children":null},{"name":"terms_url","type":"string","nullable":false,"metadata":null,"children":null},{"name":"attribution_text","type":"string","nullable":false,"metadata":null,"children":null},{"name":"legal_review_required","type":"int64","nullable":false,"metadata":null,"children":null},{"name":"reviewed_at","type":"string","nullable":false,"metadata":null,"children":null},{"name":"notes","type":"string","nullable":false,"metadata":null,"children":null}],"parquet":"required group field_id=-1 schema {\n  required binary field_id=-1 source_id (String);\n  required binary field_id=-1 source_family (String);\n  required binary field_id=-1 issuing_organization (String);\n  required binary field_id=-1 canonical_domains (String);\n  required binary field_id=-1 content_classes (String);\n  required binary field_id=-1 published_surface (String);\n  required binary field_id=-1 redistribution_scope (String);\n  required binary field_id=-1 rights_status (String);\n  required binary field_id=-1 rights_basis (String);\n  required binary field_id=-1 terms_url (String);\n  required binary field_id=-1 attribution_text (String);\n  required int64 field_id=-1 legal_review_required;\n  required binary field_id=-1 reviewed_at (String);\n  required binary field_id=-1 notes (String);\n}\n"},"kv_metadata":[["ARROW:schema",{"$cut":{"chars":1280,"head":""}}],["export_schema_version","1.7.0"],["table","source_register"]]}
["source-legislative-council","Michigan Legislature records","Michigan Legislative Council and Legislative Service Bureau","legislature.mi.gov, www.legislature.mi.gov, renderpdf.legislature.mi.gov","calendars; journals; bills and resolutions; bill status; votes","Structured facts, identifiers, official links, hashes, and bounded evidence excerpts appear in the public database. Full official documents are linked rather than republished.","Metadata, factual observations, project classifications, hashes, and short source-located excerpts only. No grant to redistribute the underlying official documents is asserted.","state_interest_expressly_reserved","MCL 4.1204 through 4.1204f require Internet availability while expressly preserving State copyright and other proprietary interests.","https://www.legislature.mi.gov/Laws/MCL?objectName=mcl-4-1204f","Source: Michigan Legislature. This independent project is not an official State of Michigan publication.",1,"2026-07-27","Internet availability and fee-free access are not treated as an open license. Final publication policy requires legal review."]
["source-house","Michigan House records and media","Michigan House of Representatives","house.mi.gov, www.house.mi.gov","member profiles; schedules; committee meetings; minutes; agendas; testimony; audio and video","Structured facts, official links, hashes, media metadata, and project-generated transcript search text appear in the public database. Source documents and recordings are not included as bulk artifacts.","Metadata, factual observations, hashes, and links may be published. Document bodies, recordings, and derived transcript redistribution remain pending source-specific review.","state_interest_expressly_reserved","No source-wide open license was located. Legislative Council Act provisions preserve State interests in legislative information, and some committee files contain third-party submissions.","https://www.house.mi.gov/","Source: Michigan House of Representatives. Linked materials remain subject to their source-specific rights.",1,"2026-07-27","The register does not assume that House-hosted content is wholly government-authored or freely redistributable."]
["source-senate","Michigan Senate records and media","Michigan Senate","senate.michigan.gov, committeeaudio.senate.michigan.gov, committeemintestimony.senate.michigan.gov, tv.senate.michigan.gov","committee schedules; minutes; agendas; testimony; committee audio; member and chamber information","Structured facts, official links, hashes, media metadata, and project-generated transcript search text appear in the public database. Source documents and recordings are not included as bulk artifacts.","Metadata, factual observations, hashes, and links may be published. Document bodies, recordings, and derived transcript redistribution remain pending source-specific review.","state_interest_expressly_reserved","The official Senate disclaimer describes the site as a public service but states Copyright 2026, all rights reserved, and warns that some content comes from external sources.","https://senate.michigan.gov/web-support-and-disclaimers/","Source: Michigan Senate. This independent project is not endorsed by the Senate.",1,"2026-07-27","Third-party testimony and attachments require a separate authorship review even when hosted by the Senate."]
["source-caucus-member-sites","Caucus and member-office websites","Legislative caucus or individual member office","gophouse.org, housedems.com, senatedems.com, www.senator*.com","member profile pages; office contact links; portrait image links","Public member and service records retain source profile URLs and portrait-image URLs. The project does not include local copies of those pages or images in release artifacts.","Link and factual identity/service metadata only. Page text, branding, and images are not approved for republication without source-specific permission or another applicable legal basis.","third_party_rights_unresolved","Caucus and member-branded websites do not share a single observed open license, and may contain party, campaign, photographer, or vendor material distinct from official legislative records.","https://gophouse.org/","Member profile or image linked to the publishing caucus or member office; no endorsement is implied.",1,"2026-07-27","The pipeline should eventually record publisher and license terms per profile/image URL rather than relying on this conservative family default."]
["source-youtube","YouTube-hosted legislative media","Video uploader and YouTube","youtube.com, www.youtube.com","House and Senate recordings hosted on YouTube","Video identifiers, titles, official source links, durations, proceeding associations, and project-generated transcript search text appear in the public database. Video files are not redistributed.","Link and metadata only for the hosted recording. Downloaded media and full derived transcripts are not approved for redistribution unless a specific upload is separately licensed or permission is obtained.","platform_terms_restrict_reuse","YouTube's standard terms restrict downloading, reproducing, and distributing content except through service features, permission, or applicable law. Individual uploads may instead use CC BY.","https://www.youtube.com/static?template=terms","Source recording linked through YouTube; rights remain with the uploader and applicable rights holders.",1,"2026-07-27","The pipeline does not currently preserve a per-video YouTube license observation; therefore it applies the conservative default."]
["source-castus","CASTUS-hosted legislative media","Michigan Senate or House media publisher and CASTUS","cloud.castus.tv","House and Senate recordings hosted through CASTUS","Video identifiers, titles, source links, durations, proceeding associations, and project-generated transcript search text appear in the public database. Video files are not redistributed.","Link and metadata only for the hosted recording. Downloaded media and full derived transcripts remain pending publisher and platform review.","platform_terms_restrict_reuse","No source-specific open license or affirmative redistribution grant was located during review.","https://cloud.castus.tv/","Source recording linked through the official legislative publisher's CASTUS service; no endorsement is implied.",1,"2026-07-27","Obtain publisher/platform confirmation before distributing recordings or full transcripts derived from them."]
["source-third-party-submissions","Third-party committee submissions","Individual submitting organization or author","house.mi.gov, www.house.mi.gov, committeemintestimony.senate.michigan.gov","written testimony; slide decks; letters; reports; attachments","Document metadata, official links, content classifications, measure relations, and reviewed member attributions appear in the public database. Normalized bodies are withheld.","Metadata, factual relations, hashes, and links only. Full text and files are excluded until authorship and permission are established.","third_party_rights_unresolved","Hosting by a legislative body does not establish government authorship or a license from the submitting author.","https://senate.michigan.gov/web-support-and-disclaimers/","Source document linked from the relevant Michigan House or Senate committee record; rights may belong to the submitting author.",1,"2026-07-27","This family is separated from government-authored minutes and agendas because the rights analysis differs."]
["source-project-transcripts","Project-generated automated transcripts","Michigan Legislative Activity Ledger research project","local research pipeline","automated speech-to-text segments; timestamps; model metadata","Transcript segments and timestamps are available for search and API inspection in the public SQLite read model. No standalone transcript bulk package is published.","Publication is provisional and source-dependent. Do not redistribute full transcripts until the underlying recording rights and legal basis are reviewed.","third_party_rights_unresolved","The transcript files are project-generated, but they are derived from recordings whose source-specific rights are not uniformly resolved.","https://github.com/mjbommar/mi-legislature-data","Automated transcript generated by the Michigan Legislative Activity Ledger; verify against the linked source recording.",1,"2026-07-27","Automated text can contain recognition, timing, and speaker errors. Search access is not a representation that reuse rights are cleared."]
["source-project-compilation","Project-created compilation and measures","Michigan Legislative Activity Ledger research project","mi-legislature-data release artifacts","public identifiers; normalized relations; evidence states; metrics; coverage ledgers; codebook; manifests","The public database and curated table exports contain project-created selection, arrangement, classifications, and documentation alongside source-derived facts.","Research inspection and citation are supported. No software, database, or compilation license is granted while the manifest says NOASSERTION.","project_license_pending","The repository has not yet adopted separate software and data licenses. The release manifest therefore records SPDX NOASSERTION.","https://github.com/mjbommar/mi-legislature-data","Michigan Legislative Activity Ledger, release-specific citation required; preserve source attributions and uncertainty states.",1,"2026-07-27","A later license decision must not retroactively imply rights in third-party source content."]