{"status":"OK","data":[{"id":751671,"datasetId":6889429,"datasetPersistentId":"doi:10.7910/DVN/NJTBEM","datasetType":"dataset","storageIdentifier":"s3://10.7910/DVN/NJTBEM","versionNumber":20,"internalVersionNumber":11,"versionMinorNumber":0,"versionState":"RELEASED","latestVersionPublishingState":"RELEASED","UNF":"UNF:6:3rGeZDgPBzA5D3fizkqrGw==","lastUpdateTime":"2026-10-12T04:38:03Z","releaseTime":"2026-10-12T04:38:03Z","createTime":"2026-10-12T04:35:05Z","publicationDate":"2023-01-13","citationDate":"2023-01-13","effectiveDatasetFileCountLimit":1000,"datasetFileUploadsAvailable":843,"license":{"name":"CC0 1.0","uri":"http://creativecommons.org/publicdomain/zero/1.0","iconUri":"https://licensebuttons.net/p/zero/1.0/88x31.png","rightsIdentifier":"CC0-1.0","rightsIdentifierScheme":"SPDX","schemeUri":"https://spdx.org/licenses/","languageCode":"en"},"fileAccessRequest":true,"metadataBlocks":{"citation":{"displayName":"Citation Metadata","name":"citation","fields":[{"typeName":"title","multiple":false,"typeClass":"primitive","value":"LocalView Public Meetings Database"},{"typeName":"author","multiple":true,"typeClass":"compound","value":[{"authorName":{"typeName":"authorName","multiple":false,"typeClass":"primitive","value":"Barari, Soubhik"},"authorAffiliation":{"typeName":"authorAffiliation","multiple":false,"typeClass":"primitive","value":"Harvard University"},"authorIdentifierScheme":{"typeName":"authorIdentifierScheme","multiple":false,"typeClass":"controlledVocabulary","value":"ORCID"},"authorIdentifier":{"typeName":"authorIdentifier","multiple":false,"typeClass":"primitive","value":"0000-0002-0126-7351"}},{"authorName":{"typeName":"authorName","multiple":false,"typeClass":"primitive","value":"Simko, Tyler"},"authorAffiliation":{"typeName":"authorAffiliation","multiple":false,"typeClass":"primitive","value":"https://ror.org/00jmfr291","expandedvalue":{"scheme":"http://www.grid.ac/ontology/","termName":"University of Michigan","@type":"https://schema.org/Organization"}},"authorIdentifierScheme":{"typeName":"authorIdentifierScheme","multiple":false,"typeClass":"controlledVocabulary","value":"ORCID"},"authorIdentifier":{"typeName":"authorIdentifier","multiple":false,"typeClass":"primitive","value":"0000-0001-9382-7346"}},{"authorName":{"typeName":"authorName","multiple":false,"typeClass":"primitive","value":"Reece, Mason"},"authorAffiliation":{"typeName":"authorAffiliation","multiple":false,"typeClass":"primitive","value":"https://ror.org/042nb2s44","expandedvalue":{"scheme":"http://www.grid.ac/ontology/","termName":"Massachusetts Institute of Technology","@type":"https://schema.org/Organization"}},"authorIdentifierScheme":{"typeName":"authorIdentifierScheme","multiple":false,"typeClass":"controlledVocabulary","value":"ORCID"},"authorIdentifier":{"typeName":"authorIdentifier","multiple":false,"typeClass":"primitive","value":"https://orcid.org/0009-0009-8761-2344","expandedvalue":{"personName":"Reece, Mason","@id":"https://orcid.org/0009-0009-8761-2344","scheme":"ORCID","@type":"https://schema.org/Person"}}}]},{"typeName":"datasetContact","multiple":true,"typeClass":"compound","value":[{"datasetContactName":{"typeName":"datasetContactName","multiple":false,"typeClass":"primitive","value":"Barari, Soubhik"},"datasetContactAffiliation":{"typeName":"datasetContactAffiliation","multiple":false,"typeClass":"primitive","value":"Harvard University"},"datasetContactEmail":{"typeName":"datasetContactEmail","multiple":false,"typeClass":"primitive","value":"sbarari@g.harvard.edu"}},{"datasetContactName":{"typeName":"datasetContactName","multiple":false,"typeClass":"primitive","value":"Simko, Tyler"},"datasetContactAffiliation":{"typeName":"datasetContactAffiliation","multiple":false,"typeClass":"primitive","value":"University of Michigan"},"datasetContactEmail":{"typeName":"datasetContactEmail","multiple":false,"typeClass":"primitive","value":"tsimko@umich.edu"}},{"datasetContactName":{"typeName":"datasetContactName","multiple":false,"typeClass":"primitive","value":"Reece, Mason"},"datasetContactAffiliation":{"typeName":"datasetContactAffiliation","multiple":false,"typeClass":"primitive","value":"Massachusetts Institute of Technology"},"datasetContactEmail":{"typeName":"datasetContactEmail","multiple":false,"typeClass":"primitive","value":"mpreece@mit.edu"}}]},{"typeName":"dsDescription","multiple":true,"typeClass":"compound","value":[{"dsDescriptionValue":{"typeName":"dsDescriptionValue","multiple":false,"typeClass":"primitive","value":"<h3>LocalView is a database co-created by <a href:\"mailto:sbarari@g.harvard.edu\">Soubhik Barari</a>, <a href=\"mailto:tsimko@umich.edu\">Tyler Simko</a>, and <a href=\"mailto:mpreece@mit.edu\">Mason Reece</a> to advance the study of local government in the United States.</h3><br>\n\nIt is the <i>largest existing dataset of local government public meetings</i>— the central policy-making process in American local government — as they are captured on video. <br><br>\n\nTo get started, select the file(s) that you'd like for your use case based on the year that the meeting took place. Note: we are no longer supporting file formats other than <code>.parquet</code> for space considerations. <br><br>\n\nFor potential use cases or further guidance on downloading the data in bulk, visit the companion website: <a href=\"https://www.localview.net\">localview.net</a>.\n\n<h1>Change Log</h1>\n\n<p>Scraping, parsing, identifying, and merging together meetings\ninvolves a large number of non-trivial decisions, many of which need to\nbe adjusted over time particularly as the YouTube API changes.</p>\n\n<p>As such, when such decisions notably deviate from process or the\noutputs documented in the <a href=\"https://soubhikbarari.com/writings/localview.pdf\">first version of\nthis database</a>, it will be logged here.</p>\n\n<div id=\"version-3.0-2026-05\" class=\"section level2\">\n  <h2>Version 3.0 (2026-05)</h2>\n\n  <ul>\n    <li>\n      Data updated until November 2025. Moving forward, data will be automatically updated to always be six months behind present.\n    </li>\n\n    <li>\n      Some new channels have been added. Please reach out to us via email if there are new local meeting channels not featured that we should include.\n    </li>\n\n    <li>\n      Codebook has been updated and simplified. ACS related columns have been removed.\n    </li>\n\n    <li>\n      Data format has been modified to separate transcripts from metadata\n      <ul>\n        <li>\n          First, download <code>meta_localview.parquet</code>, then filter to the channels and/or videos of interest.\n        </li>\n        <li>\n          Then, merge in transcripts as desired from <code>transcripts_localview_*.zip</code>. Transcript file names are identified as \"<code>channel_id</code>__<code>id</code>.txt.gz\".\n        </li>\n        <li>\n          The transcript files have been separated into two parts only because of Dataverse size constraints, otherwise they are identical.\n        </li>\n      </ul>\n    </li>\n  </ul>\n</div>\n\n<div id=\"version-2.0-2023-10\" class=\"section level2\">\n<h2>Version 2.0 (2023-10)</h2>\n<ul>\n<li>Data updated up until September 2023.\n<ul>\n<li>~10,000 new videos added, all belonging to existing channels in\ndatabase.</li>\n</ul></li>\n<li>Change in data format:\n<ul>\n<li><code>channelType</code> column changed to\n<code>channel_type</code>.</li>\n<li><code>ST_FIPS</code> correctly padded to be 7 characters (2 digit\nstate code + 5 digit place FIPS code).</li>\n<li>videos with no caption available from YouTube are explicitly marked\nas “<No caption available>” in <code>caption_text</code>.</li>\n<li><code>caption_text_cleaned</code> is actually consistently cleaned\n(previously stray timestamps/pause markers in some entries).</li>\n<li><code>acs_2018_*</code> columns now prefixed as\n<code>acs_18</code>.</li>\n<li>additional ACS variables now available for each place:\n<ul>\n<li><code>acs_18_median_gross_rent</code>: Median gross rent in FIPS\nplace.</li>\n<li><code>acs_18_median_hh_inc</code>: Median household income in FIPS\nplace.</li>\n<li><code>acs_18_median_age</code>: Median age in FIPS place.</li>\n<li><code>acs_18_amind</code>: American Indian population in FIPS\nplace.</li>\n<li><code>acs_18_asian</code>: Asian population in FIPS place.</li>\n<li><code>acs_18_nhapi</code>: Native Hawaiian or Pacific Islander\npopulation in FIPS place.</li>\n</ul></li>\n<li><code>census_2015_*</code> columns removed for redundancy.</li>\n<li>to avoid confusion and possible conflicts, <code>.json</code> and\n<code>.csv</code> file formats eliminated in favor of\n<code>.parquet</code> format.</li>\n<li>municipal voteshare (<code>_dem2pv</code>) variables have been\nremoved from the public use files for a number of reasons: (1) high\ndegree of missingness, (2) no columns estimates available, (3) potential\nsensitivity</li>\n</ul></li>\n<li>The matching process of videos to ST-FIPS and government types is as\nfollows:\n<ul>\n<li>videos are matched to channels’ previous ST-FIPS codes and/or\ngovernment types <em>if</em> there is an umambiguous match, otherwise a\n(1) series of regex matches with video title/description are used to\nattempt to match video to the government and (2) state/place names are\nextracted from each video’s title/description/caption and used to match\nto an ST-FIPS entity <em>if</em> an unambiguous match; only identified\nvideos are then uploaded to the database.</li>\n<li>to identify the date of the meeting that the video captures, we\nfirst try to extract the date from the title, otherwise we try to\nextract the date from the description, otherwise it is discarded.</li>\n</ul></li>\n</ul>\n</div>\n<div id=\"version-1.0-2023-02\" class=\"section level2\">\n<h2>Version 1.0 (2023-02)</h2>\n<p>See <a href=\"https://soubhikbarari.com/writings/localview.pdf\">publication</a>\nfor full details on methodology choices for the Version 1.0\ndatabase.</p>\n</div>\n</div>"}}]},{"typeName":"subject","multiple":true,"typeClass":"controlledVocabulary","value":["Social Sciences"]},{"typeName":"keyword","multiple":true,"typeClass":"compound","value":[{"keywordValue":{"typeName":"keywordValue","multiple":false,"typeClass":"primitive","value":"local politics"}},{"keywordValue":{"typeName":"keywordValue","multiple":false,"typeClass":"primitive","value":"political communication"}},{"keywordValue":{"typeName":"keywordValue","multiple":false,"typeClass":"primitive","value":"deliberative democracy"}}]},{"typeName":"depositor","multiple":false,"typeClass":"primitive","value":"Barari, Soubhik"},{"typeName":"dateOfDeposit","multiple":false,"typeClass":"primitive","value":"2023-01-13"},{"typeName":"software","multiple":true,"typeClass":"compound","value":[{"softwareVersion":{"typeName":"softwareVersion","multiple":false,"typeClass":"primitive","value":"2.0"}}]}]}},"files":[{"description":"Codebook describing different variables in the data + example code","label":"codebook.md","restricted":false,"version":1,"datasetVersionId":751671,"dataFile":{"id":14077924,"persistentId":"","filename":"codebook.md","contentType":"text/markdown","friendlyType":"Markdown Text","filesize":6387,"description":"Codebook describing different variables in the data + example code","storageIdentifier":"s3://dvn-cloud-iqss:19f66db7722-8cfca0a72b54","rootDataFileId":-1,"md5":"ebc5d2ed9f72f5921db2229ad5516fa3","checksum":{"type":"MD5","value":"ebc5d2ed9f72f5921db2229ad5516fa3"},"tabularData":false,"creationDate":"2026-07-15","publicationDate":"2026-07-21","lastUpdateTime":"2026-10-12T04:38:03Z","fileAccessRequest":true}},{"description":"","label":"meta_localview.parquet","restricted":false,"version":1,"datasetVersionId":751671,"dataFile":{"id":14327242,"persistentId":"","filename":"meta_localview.parquet","contentType":"application/octet-stream","friendlyType":"Unknown","filesize":35699703,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:1a12e649a43-497f64656953","rootDataFileId":-1,"md5":"60e6d14341a8be314f1faeaeb2ce2923","checksum":{"type":"MD5","value":"60e6d14341a8be314f1faeaeb2ce2923"},"tabularData":false,"creationDate":"2026-10-12","publicationDate":"2026-10-12","lastUpdateTime":"2026-10-12T04:38:03Z","fileAccessRequest":true}},{"description":"","label":"transcripts_localview_part1.tar","restricted":false,"version":1,"datasetVersionId":751671,"dataFile":{"id":14327243,"persistentId":"","filename":"transcripts_localview_part1.tar","contentType":"application/x-tar","friendlyType":"TAR Archive","filesize":2135511040,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:1a12e65415a-b38323c3e58a","rootDataFileId":-1,"md5":"b1aff541c23e97dd59f263a718569039","checksum":{"type":"MD5","value":"b1aff541c23e97dd59f263a718569039"},"tabularData":false,"creationDate":"2026-10-12","publicationDate":"2026-10-12","lastUpdateTime":"2026-10-12T04:38:03Z","fileAccessRequest":true}},{"description":"","label":"transcripts_localview_part2.tar","restricted":false,"version":1,"datasetVersionId":751671,"dataFile":{"id":14327244,"persistentId":"","filename":"transcripts_localview_part2.tar","contentType":"application/x-tar","friendlyType":"TAR Archive","filesize":2135644160,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:1a12e664bda-4feb8cf773e3","rootDataFileId":-1,"md5":"c88b83b5b70d153371014c891f689c17","checksum":{"type":"MD5","value":"c88b83b5b70d153371014c891f689c17"},"tabularData":false,"creationDate":"2026-10-12","publicationDate":"2026-10-12","lastUpdateTime":"2026-10-12T04:38:03Z","fileAccessRequest":true}},{"description":"","label":"transcripts_localview_part3.tar","restricted":false,"version":1,"datasetVersionId":751671,"dataFile":{"id":14327245,"persistentId":"","filename":"transcripts_localview_part3.tar","contentType":"application/x-tar","friendlyType":"TAR Archive","filesize":1101537280,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:1a12e670b9b-335ec09964af","rootDataFileId":-1,"md5":"72b63dd2da00df3916dcc594355139e3","checksum":{"type":"MD5","value":"72b63dd2da00df3916dcc594355139e3"},"tabularData":false,"creationDate":"2026-10-12","publicationDate":"2026-10-12","lastUpdateTime":"2026-10-12T04:38:03Z","fileAccessRequest":true}}]},{"id":750864,"datasetId":6889429,"datasetPersistentId":"doi:10.7910/DVN/NJTBEM","datasetType":"dataset","storageIdentifier":"s3://10.7910/DVN/NJTBEM","versionNumber":19,"internalVersionNumber":11,"versionMinorNumber":0,"versionState":"RELEASED","latestVersionPublishingState":"RELEASED","UNF":"UNF:6:3rGeZDgPBzA5D3fizkqrGw==","lastUpdateTime":"2026-10-05T04:26:25Z","releaseTime":"2026-10-05T04:26:25Z","createTime":"2026-10-05T04:23:29Z","publicationDate":"2023-01-13","citationDate":"2023-01-13","effectiveDatasetFileCountLimit":1000,"datasetFileUploadsAvailable":843,"license":{"name":"CC0 1.0","uri":"http://creativecommons.org/publicdomain/zero/1.0","iconUri":"https://licensebuttons.net/p/zero/1.0/88x31.png","rightsIdentifier":"CC0-1.0","rightsIdentifierScheme":"SPDX","schemeUri":"https://spdx.org/licenses/","languageCode":"en"},"fileAccessRequest":true,"metadataBlocks":{"citation":{"displayName":"Citation Metadata","name":"citation","fields":[{"typeName":"title","multiple":false,"typeClass":"primitive","value":"LocalView Public Meetings Database"},{"typeName":"author","multiple":true,"typeClass":"compound","value":[{"authorName":{"typeName":"authorName","multiple":false,"typeClass":"primitive","value":"Barari, Soubhik"},"authorAffiliation":{"typeName":"authorAffiliation","multiple":false,"typeClass":"primitive","value":"Harvard University"},"authorIdentifierScheme":{"typeName":"authorIdentifierScheme","multiple":false,"typeClass":"controlledVocabulary","value":"ORCID"},"authorIdentifier":{"typeName":"authorIdentifier","multiple":false,"typeClass":"primitive","value":"0000-0002-0126-7351"}},{"authorName":{"typeName":"authorName","multiple":false,"typeClass":"primitive","value":"Simko, Tyler"},"authorAffiliation":{"typeName":"authorAffiliation","multiple":false,"typeClass":"primitive","value":"https://ror.org/00jmfr291","expandedvalue":{"scheme":"http://www.grid.ac/ontology/","termName":"University of Michigan","@type":"https://schema.org/Organization"}},"authorIdentifierScheme":{"typeName":"authorIdentifierScheme","multiple":false,"typeClass":"controlledVocabulary","value":"ORCID"},"authorIdentifier":{"typeName":"authorIdentifier","multiple":false,"typeClass":"primitive","value":"0000-0001-9382-7346"}},{"authorName":{"typeName":"authorName","multiple":false,"typeClass":"primitive","value":"Reece, Mason"},"authorAffiliation":{"typeName":"authorAffiliation","multiple":false,"typeClass":"primitive","value":"https://ror.org/042nb2s44","expandedvalue":{"scheme":"http://www.grid.ac/ontology/","termName":"Massachusetts Institute of Technology","@type":"https://schema.org/Organization"}},"authorIdentifierScheme":{"typeName":"authorIdentifierScheme","multiple":false,"typeClass":"controlledVocabulary","value":"ORCID"},"authorIdentifier":{"typeName":"authorIdentifier","multiple":false,"typeClass":"primitive","value":"https://orcid.org/0009-0009-8761-2344","expandedvalue":{"personName":"Reece, Mason","@id":"https://orcid.org/0009-0009-8761-2344","scheme":"ORCID","@type":"https://schema.org/Person"}}}]},{"typeName":"datasetContact","multiple":true,"typeClass":"compound","value":[{"datasetContactName":{"typeName":"datasetContactName","multiple":false,"typeClass":"primitive","value":"Barari, Soubhik"},"datasetContactAffiliation":{"typeName":"datasetContactAffiliation","multiple":false,"typeClass":"primitive","value":"Harvard University"},"datasetContactEmail":{"typeName":"datasetContactEmail","multiple":false,"typeClass":"primitive","value":"sbarari@g.harvard.edu"}},{"datasetContactName":{"typeName":"datasetContactName","multiple":false,"typeClass":"primitive","value":"Simko, Tyler"},"datasetContactAffiliation":{"typeName":"datasetContactAffiliation","multiple":false,"typeClass":"primitive","value":"University of Michigan"},"datasetContactEmail":{"typeName":"datasetContactEmail","multiple":false,"typeClass":"primitive","value":"tsimko@umich.edu"}},{"datasetContactName":{"typeName":"datasetContactName","multiple":false,"typeClass":"primitive","value":"Reece, Mason"},"datasetContactAffiliation":{"typeName":"datasetContactAffiliation","multiple":false,"typeClass":"primitive","value":"Massachusetts Institute of Technology"},"datasetContactEmail":{"typeName":"datasetContactEmail","multiple":false,"typeClass":"primitive","value":"mpreece@mit.edu"}}]},{"typeName":"dsDescription","multiple":true,"typeClass":"compound","value":[{"dsDescriptionValue":{"typeName":"dsDescriptionValue","multiple":false,"typeClass":"primitive","value":"<h3>LocalView is a database co-created by <a href:\"mailto:sbarari@g.harvard.edu\">Soubhik Barari</a>, <a href=\"mailto:tsimko@umich.edu\">Tyler Simko</a>, and <a href=\"mailto:mpreece@mit.edu\">Mason Reece</a> to advance the study of local government in the United States.</h3><br>\n\nIt is the <i>largest existing dataset of local government public meetings</i>— the central policy-making process in American local government — as they are captured on video. <br><br>\n\nTo get started, select the file(s) that you'd like for your use case based on the year that the meeting took place. Note: we are no longer supporting file formats other than <code>.parquet</code> for space considerations. <br><br>\n\nFor potential use cases or further guidance on downloading the data in bulk, visit the companion website: <a href=\"https://www.localview.net\">localview.net</a>.\n\n<h1>Change Log</h1>\n\n<p>Scraping, parsing, identifying, and merging together meetings\ninvolves a large number of non-trivial decisions, many of which need to\nbe adjusted over time particularly as the YouTube API changes.</p>\n\n<p>As such, when such decisions notably deviate from process or the\noutputs documented in the <a href=\"https://soubhikbarari.com/writings/localview.pdf\">first version of\nthis database</a>, it will be logged here.</p>\n\n<div id=\"version-3.0-2026-05\" class=\"section level2\">\n  <h2>Version 3.0 (2026-05)</h2>\n\n  <ul>\n    <li>\n      Data updated until November 2025. Moving forward, data will be automatically updated to always be six months behind present.\n    </li>\n\n    <li>\n      Some new channels have been added. Please reach out to us via email if there are new local meeting channels not featured that we should include.\n    </li>\n\n    <li>\n      Codebook has been updated and simplified. ACS related columns have been removed.\n    </li>\n\n    <li>\n      Data format has been modified to separate transcripts from metadata\n      <ul>\n        <li>\n          First, download <code>meta_localview.parquet</code>, then filter to the channels and/or videos of interest.\n        </li>\n        <li>\n          Then, merge in transcripts as desired from <code>transcripts_localview_*.zip</code>. Transcript file names are identified as \"<code>channel_id</code>__<code>id</code>.txt.gz\".\n        </li>\n        <li>\n          The transcript files have been separated into two parts only because of Dataverse size constraints, otherwise they are identical.\n        </li>\n      </ul>\n    </li>\n  </ul>\n</div>\n\n<div id=\"version-2.0-2023-10\" class=\"section level2\">\n<h2>Version 2.0 (2023-10)</h2>\n<ul>\n<li>Data updated up until September 2023.\n<ul>\n<li>~10,000 new videos added, all belonging to existing channels in\ndatabase.</li>\n</ul></li>\n<li>Change in data format:\n<ul>\n<li><code>channelType</code> column changed to\n<code>channel_type</code>.</li>\n<li><code>ST_FIPS</code> correctly padded to be 7 characters (2 digit\nstate code + 5 digit place FIPS code).</li>\n<li>videos with no caption available from YouTube are explicitly marked\nas “<No caption available>” in <code>caption_text</code>.</li>\n<li><code>caption_text_cleaned</code> is actually consistently cleaned\n(previously stray timestamps/pause markers in some entries).</li>\n<li><code>acs_2018_*</code> columns now prefixed as\n<code>acs_18</code>.</li>\n<li>additional ACS variables now available for each place:\n<ul>\n<li><code>acs_18_median_gross_rent</code>: Median gross rent in FIPS\nplace.</li>\n<li><code>acs_18_median_hh_inc</code>: Median household income in FIPS\nplace.</li>\n<li><code>acs_18_median_age</code>: Median age in FIPS place.</li>\n<li><code>acs_18_amind</code>: American Indian population in FIPS\nplace.</li>\n<li><code>acs_18_asian</code>: Asian population in FIPS place.</li>\n<li><code>acs_18_nhapi</code>: Native Hawaiian or Pacific Islander\npopulation in FIPS place.</li>\n</ul></li>\n<li><code>census_2015_*</code> columns removed for redundancy.</li>\n<li>to avoid confusion and possible conflicts, <code>.json</code> and\n<code>.csv</code> file formats eliminated in favor of\n<code>.parquet</code> format.</li>\n<li>municipal voteshare (<code>_dem2pv</code>) variables have been\nremoved from the public use files for a number of reasons: (1) high\ndegree of missingness, (2) no columns estimates available, (3) potential\nsensitivity</li>\n</ul></li>\n<li>The matching process of videos to ST-FIPS and government types is as\nfollows:\n<ul>\n<li>videos are matched to channels’ previous ST-FIPS codes and/or\ngovernment types <em>if</em> there is an umambiguous match, otherwise a\n(1) series of regex matches with video title/description are used to\nattempt to match video to the government and (2) state/place names are\nextracted from each video’s title/description/caption and used to match\nto an ST-FIPS entity <em>if</em> an unambiguous match; only identified\nvideos are then uploaded to the database.</li>\n<li>to identify the date of the meeting that the video captures, we\nfirst try to extract the date from the title, otherwise we try to\nextract the date from the description, otherwise it is discarded.</li>\n</ul></li>\n</ul>\n</div>\n<div id=\"version-1.0-2023-02\" class=\"section level2\">\n<h2>Version 1.0 (2023-02)</h2>\n<p>See <a href=\"https://soubhikbarari.com/writings/localview.pdf\">publication</a>\nfor full details on methodology choices for the Version 1.0\ndatabase.</p>\n</div>\n</div>"}}]},{"typeName":"subject","multiple":true,"typeClass":"controlledVocabulary","value":["Social Sciences"]},{"typeName":"keyword","multiple":true,"typeClass":"compound","value":[{"keywordValue":{"typeName":"keywordValue","multiple":false,"typeClass":"primitive","value":"local politics"}},{"keywordValue":{"typeName":"keywordValue","multiple":false,"typeClass":"primitive","value":"political communication"}},{"keywordValue":{"typeName":"keywordValue","multiple":false,"typeClass":"primitive","value":"deliberative democracy"}}]},{"typeName":"depositor","multiple":false,"typeClass":"primitive","value":"Barari, Soubhik"},{"typeName":"dateOfDeposit","multiple":false,"typeClass":"primitive","value":"2023-01-13"},{"typeName":"software","multiple":true,"typeClass":"compound","value":[{"softwareVersion":{"typeName":"softwareVersion","multiple":false,"typeClass":"primitive","value":"2.0"}}]}]}},"files":[{"description":"Codebook describing different variables in the data + example code","label":"codebook.md","restricted":false,"version":1,"datasetVersionId":750864,"dataFile":{"id":14077924,"persistentId":"","filename":"codebook.md","contentType":"text/markdown","friendlyType":"Markdown Text","filesize":6387,"description":"Codebook describing different variables in the data + example code","storageIdentifier":"s3://dvn-cloud-iqss:19f66db7722-8cfca0a72b54","rootDataFileId":-1,"md5":"ebc5d2ed9f72f5921db2229ad5516fa3","checksum":{"type":"MD5","value":"ebc5d2ed9f72f5921db2229ad5516fa3"},"tabularData":false,"creationDate":"2026-07-15","publicationDate":"2026-07-21","lastUpdateTime":"2026-10-05T04:26:25Z","fileAccessRequest":true}},{"description":"","label":"meta_localview.parquet","restricted":false,"version":1,"datasetVersionId":750864,"dataFile":{"id":14309969,"persistentId":"","filename":"meta_localview.parquet","contentType":"application/octet-stream","friendlyType":"Unknown","filesize":35580243,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:1a10a4d765f-78c0f8e7076f","rootDataFileId":-1,"md5":"053706f17db7aa53d720478ba040a0f3","checksum":{"type":"MD5","value":"053706f17db7aa53d720478ba040a0f3"},"tabularData":false,"creationDate":"2026-10-05","publicationDate":"2026-10-05","lastUpdateTime":"2026-10-05T04:26:25Z","fileAccessRequest":true}},{"description":"","label":"transcripts_localview_part1.tar","restricted":false,"version":1,"datasetVersionId":750864,"dataFile":{"id":14309970,"persistentId":"","filename":"transcripts_localview_part1.tar","contentType":"application/x-tar","friendlyType":"TAR Archive","filesize":2135715840,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:1a10a4e1d49-abc898d39e58","rootDataFileId":-1,"md5":"2568172a9c8431cc6da69b883bf15c00","checksum":{"type":"MD5","value":"2568172a9c8431cc6da69b883bf15c00"},"tabularData":false,"creationDate":"2026-10-05","publicationDate":"2026-10-05","lastUpdateTime":"2026-10-05T04:26:25Z","fileAccessRequest":true}},{"description":"","label":"transcripts_localview_part2.tar","restricted":false,"version":1,"datasetVersionId":750864,"dataFile":{"id":14309971,"persistentId":"","filename":"transcripts_localview_part2.tar","contentType":"application/x-tar","friendlyType":"TAR Archive","filesize":2135552000,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:1a10a4f2795-0c9b0ebe3242","rootDataFileId":-1,"md5":"4deeebe77c133574d9d25f335894db70","checksum":{"type":"MD5","value":"4deeebe77c133574d9d25f335894db70"},"tabularData":false,"creationDate":"2026-10-05","publicationDate":"2026-10-05","lastUpdateTime":"2026-10-05T04:26:25Z","fileAccessRequest":true}},{"description":"","label":"transcripts_localview_part3.tar","restricted":false,"version":1,"datasetVersionId":750864,"dataFile":{"id":14309972,"persistentId":"","filename":"transcripts_localview_part3.tar","contentType":"application/x-tar","friendlyType":"TAR Archive","filesize":1079705600,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:1a10a4fe2fa-d22b3cc0b18a","rootDataFileId":-1,"md5":"fcbc7b6fa74963b459b1ebcff783f2e5","checksum":{"type":"MD5","value":"fcbc7b6fa74963b459b1ebcff783f2e5"},"tabularData":false,"creationDate":"2026-10-05","publicationDate":"2026-10-05","lastUpdateTime":"2026-10-05T04:26:25Z","fileAccessRequest":true}}]},{"id":750007,"datasetId":6889429,"datasetPersistentId":"doi:10.7910/DVN/NJTBEM","datasetType":"dataset","storageIdentifier":"s3://10.7910/DVN/NJTBEM","versionNumber":18,"internalVersionNumber":11,"versionMinorNumber":0,"versionState":"RELEASED","latestVersionPublishingState":"RELEASED","UNF":"UNF:6:3rGeZDgPBzA5D3fizkqrGw==","lastUpdateTime":"2026-09-28T04:25:44Z","releaseTime":"2026-09-28T04:25:44Z","createTime":"2026-09-28T04:22:41Z","publicationDate":"2023-01-13","citationDate":"2023-01-13","effectiveDatasetFileCountLimit":1000,"datasetFileUploadsAvailable":843,"license":{"name":"CC0 1.0","uri":"http://creativecommons.org/publicdomain/zero/1.0","iconUri":"https://licensebuttons.net/p/zero/1.0/88x31.png","rightsIdentifier":"CC0-1.0","rightsIdentifierScheme":"SPDX","schemeUri":"https://spdx.org/licenses/","languageCode":"en"},"fileAccessRequest":true,"metadataBlocks":{"citation":{"displayName":"Citation Metadata","name":"citation","fields":[{"typeName":"title","multiple":false,"typeClass":"primitive","value":"LocalView Public Meetings Database"},{"typeName":"author","multiple":true,"typeClass":"compound","value":[{"authorName":{"typeName":"authorName","multiple":false,"typeClass":"primitive","value":"Barari, Soubhik"},"authorAffiliation":{"typeName":"authorAffiliation","multiple":false,"typeClass":"primitive","value":"Harvard University"},"authorIdentifierScheme":{"typeName":"authorIdentifierScheme","multiple":false,"typeClass":"controlledVocabulary","value":"ORCID"},"authorIdentifier":{"typeName":"authorIdentifier","multiple":false,"typeClass":"primitive","value":"0000-0002-0126-7351"}},{"authorName":{"typeName":"authorName","multiple":false,"typeClass":"primitive","value":"Simko, Tyler"},"authorAffiliation":{"typeName":"authorAffiliation","multiple":false,"typeClass":"primitive","value":"https://ror.org/00jmfr291","expandedvalue":{"scheme":"http://www.grid.ac/ontology/","termName":"University of Michigan","@type":"https://schema.org/Organization"}},"authorIdentifierScheme":{"typeName":"authorIdentifierScheme","multiple":false,"typeClass":"controlledVocabulary","value":"ORCID"},"authorIdentifier":{"typeName":"authorIdentifier","multiple":false,"typeClass":"primitive","value":"0000-0001-9382-7346"}},{"authorName":{"typeName":"authorName","multiple":false,"typeClass":"primitive","value":"Reece, Mason"},"authorAffiliation":{"typeName":"authorAffiliation","multiple":false,"typeClass":"primitive","value":"https://ror.org/042nb2s44","expandedvalue":{"scheme":"http://www.grid.ac/ontology/","termName":"Massachusetts Institute of Technology","@type":"https://schema.org/Organization"}},"authorIdentifierScheme":{"typeName":"authorIdentifierScheme","multiple":false,"typeClass":"controlledVocabulary","value":"ORCID"},"authorIdentifier":{"typeName":"authorIdentifier","multiple":false,"typeClass":"primitive","value":"https://orcid.org/0009-0009-8761-2344","expandedvalue":{"personName":"Reece, Mason","@id":"https://orcid.org/0009-0009-8761-2344","scheme":"ORCID","@type":"https://schema.org/Person"}}}]},{"typeName":"datasetContact","multiple":true,"typeClass":"compound","value":[{"datasetContactName":{"typeName":"datasetContactName","multiple":false,"typeClass":"primitive","value":"Barari, Soubhik"},"datasetContactAffiliation":{"typeName":"datasetContactAffiliation","multiple":false,"typeClass":"primitive","value":"Harvard University"},"datasetContactEmail":{"typeName":"datasetContactEmail","multiple":false,"typeClass":"primitive","value":"sbarari@g.harvard.edu"}},{"datasetContactName":{"typeName":"datasetContactName","multiple":false,"typeClass":"primitive","value":"Simko, Tyler"},"datasetContactAffiliation":{"typeName":"datasetContactAffiliation","multiple":false,"typeClass":"primitive","value":"University of Michigan"},"datasetContactEmail":{"typeName":"datasetContactEmail","multiple":false,"typeClass":"primitive","value":"tsimko@umich.edu"}},{"datasetContactName":{"typeName":"datasetContactName","multiple":false,"typeClass":"primitive","value":"Reece, Mason"},"datasetContactAffiliation":{"typeName":"datasetContactAffiliation","multiple":false,"typeClass":"primitive","value":"Massachusetts Institute of Technology"},"datasetContactEmail":{"typeName":"datasetContactEmail","multiple":false,"typeClass":"primitive","value":"mpreece@mit.edu"}}]},{"typeName":"dsDescription","multiple":true,"typeClass":"compound","value":[{"dsDescriptionValue":{"typeName":"dsDescriptionValue","multiple":false,"typeClass":"primitive","value":"<h3>LocalView is a database co-created by <a href:\"mailto:sbarari@g.harvard.edu\">Soubhik Barari</a>, <a href=\"mailto:tsimko@umich.edu\">Tyler Simko</a>, and <a href=\"mailto:mpreece@mit.edu\">Mason Reece</a> to advance the study of local government in the United States.</h3><br>\n\nIt is the <i>largest existing dataset of local government public meetings</i>— the central policy-making process in American local government — as they are captured on video. <br><br>\n\nTo get started, select the file(s) that you'd like for your use case based on the year that the meeting took place. Note: we are no longer supporting file formats other than <code>.parquet</code> for space considerations. <br><br>\n\nFor potential use cases or further guidance on downloading the data in bulk, visit the companion website: <a href=\"https://www.localview.net\">localview.net</a>.\n\n<h1>Change Log</h1>\n\n<p>Scraping, parsing, identifying, and merging together meetings\ninvolves a large number of non-trivial decisions, many of which need to\nbe adjusted over time particularly as the YouTube API changes.</p>\n\n<p>As such, when such decisions notably deviate from process or the\noutputs documented in the <a href=\"https://soubhikbarari.com/writings/localview.pdf\">first version of\nthis database</a>, it will be logged here.</p>\n\n<div id=\"version-3.0-2026-05\" class=\"section level2\">\n  <h2>Version 3.0 (2026-05)</h2>\n\n  <ul>\n    <li>\n      Data updated until November 2025. Moving forward, data will be automatically updated to always be six months behind present.\n    </li>\n\n    <li>\n      Some new channels have been added. Please reach out to us via email if there are new local meeting channels not featured that we should include.\n    </li>\n\n    <li>\n      Codebook has been updated and simplified. ACS related columns have been removed.\n    </li>\n\n    <li>\n      Data format has been modified to separate transcripts from metadata\n      <ul>\n        <li>\n          First, download <code>meta_localview.parquet</code>, then filter to the channels and/or videos of interest.\n        </li>\n        <li>\n          Then, merge in transcripts as desired from <code>transcripts_localview_*.zip</code>. Transcript file names are identified as \"<code>channel_id</code>__<code>id</code>.txt.gz\".\n        </li>\n        <li>\n          The transcript files have been separated into two parts only because of Dataverse size constraints, otherwise they are identical.\n        </li>\n      </ul>\n    </li>\n  </ul>\n</div>\n\n<div id=\"version-2.0-2023-10\" class=\"section level2\">\n<h2>Version 2.0 (2023-10)</h2>\n<ul>\n<li>Data updated up until September 2023.\n<ul>\n<li>~10,000 new videos added, all belonging to existing channels in\ndatabase.</li>\n</ul></li>\n<li>Change in data format:\n<ul>\n<li><code>channelType</code> column changed to\n<code>channel_type</code>.</li>\n<li><code>ST_FIPS</code> correctly padded to be 7 characters (2 digit\nstate code + 5 digit place FIPS code).</li>\n<li>videos with no caption available from YouTube are explicitly marked\nas “<No caption available>” in <code>caption_text</code>.</li>\n<li><code>caption_text_cleaned</code> is actually consistently cleaned\n(previously stray timestamps/pause markers in some entries).</li>\n<li><code>acs_2018_*</code> columns now prefixed as\n<code>acs_18</code>.</li>\n<li>additional ACS variables now available for each place:\n<ul>\n<li><code>acs_18_median_gross_rent</code>: Median gross rent in FIPS\nplace.</li>\n<li><code>acs_18_median_hh_inc</code>: Median household income in FIPS\nplace.</li>\n<li><code>acs_18_median_age</code>: Median age in FIPS place.</li>\n<li><code>acs_18_amind</code>: American Indian population in FIPS\nplace.</li>\n<li><code>acs_18_asian</code>: Asian population in FIPS place.</li>\n<li><code>acs_18_nhapi</code>: Native Hawaiian or Pacific Islander\npopulation in FIPS place.</li>\n</ul></li>\n<li><code>census_2015_*</code> columns removed for redundancy.</li>\n<li>to avoid confusion and possible conflicts, <code>.json</code> and\n<code>.csv</code> file formats eliminated in favor of\n<code>.parquet</code> format.</li>\n<li>municipal voteshare (<code>_dem2pv</code>) variables have been\nremoved from the public use files for a number of reasons: (1) high\ndegree of missingness, (2) no columns estimates available, (3) potential\nsensitivity</li>\n</ul></li>\n<li>The matching process of videos to ST-FIPS and government types is as\nfollows:\n<ul>\n<li>videos are matched to channels’ previous ST-FIPS codes and/or\ngovernment types <em>if</em> there is an umambiguous match, otherwise a\n(1) series of regex matches with video title/description are used to\nattempt to match video to the government and (2) state/place names are\nextracted from each video’s title/description/caption and used to match\nto an ST-FIPS entity <em>if</em> an unambiguous match; only identified\nvideos are then uploaded to the database.</li>\n<li>to identify the date of the meeting that the video captures, we\nfirst try to extract the date from the title, otherwise we try to\nextract the date from the description, otherwise it is discarded.</li>\n</ul></li>\n</ul>\n</div>\n<div id=\"version-1.0-2023-02\" class=\"section level2\">\n<h2>Version 1.0 (2023-02)</h2>\n<p>See <a href=\"https://soubhikbarari.com/writings/localview.pdf\">publication</a>\nfor full details on methodology choices for the Version 1.0\ndatabase.</p>\n</div>\n</div>"}}]},{"typeName":"subject","multiple":true,"typeClass":"controlledVocabulary","value":["Social Sciences"]},{"typeName":"keyword","multiple":true,"typeClass":"compound","value":[{"keywordValue":{"typeName":"keywordValue","multiple":false,"typeClass":"primitive","value":"local politics"}},{"keywordValue":{"typeName":"keywordValue","multiple":false,"typeClass":"primitive","value":"political communication"}},{"keywordValue":{"typeName":"keywordValue","multiple":false,"typeClass":"primitive","value":"deliberative democracy"}}]},{"typeName":"depositor","multiple":false,"typeClass":"primitive","value":"Barari, Soubhik"},{"typeName":"dateOfDeposit","multiple":false,"typeClass":"primitive","value":"2023-01-13"},{"typeName":"software","multiple":true,"typeClass":"compound","value":[{"softwareVersion":{"typeName":"softwareVersion","multiple":false,"typeClass":"primitive","value":"2.0"}}]}]}},"files":[{"description":"Codebook describing different variables in the data + example code","label":"codebook.md","restricted":false,"version":1,"datasetVersionId":750007,"dataFile":{"id":14077924,"persistentId":"","filename":"codebook.md","contentType":"text/markdown","friendlyType":"Markdown Text","filesize":6387,"description":"Codebook describing different variables in the data + example code","storageIdentifier":"s3://dvn-cloud-iqss:19f66db7722-8cfca0a72b54","rootDataFileId":-1,"md5":"ebc5d2ed9f72f5921db2229ad5516fa3","checksum":{"type":"MD5","value":"ebc5d2ed9f72f5921db2229ad5516fa3"},"tabularData":false,"creationDate":"2026-07-15","publicationDate":"2026-07-21","lastUpdateTime":"2026-09-28T04:25:44Z","fileAccessRequest":true}},{"description":"","label":"meta_localview.parquet","restricted":false,"version":1,"datasetVersionId":750007,"dataFile":{"id":14290476,"persistentId":"","filename":"meta_localview.parquet","contentType":"application/octet-stream","friendlyType":"Unknown","filesize":35509268,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:1a0e6403953-86004924f738","rootDataFileId":-1,"md5":"67c65acdc8c7d0bfd969c6f7754dcc6d","checksum":{"type":"MD5","value":"67c65acdc8c7d0bfd969c6f7754dcc6d"},"tabularData":false,"creationDate":"2026-09-28","publicationDate":"2026-09-28","lastUpdateTime":"2026-09-28T04:25:44Z","fileAccessRequest":true}},{"description":"","label":"transcripts_localview_part1.tar","restricted":false,"version":1,"datasetVersionId":750007,"dataFile":{"id":14290477,"persistentId":"","filename":"transcripts_localview_part1.tar","contentType":"application/x-tar","friendlyType":"TAR Archive","filesize":2135777280,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:1a0e640f34e-2a4936e0b88e","rootDataFileId":-1,"md5":"73115d6ac6551e2707a0999b695f6522","checksum":{"type":"MD5","value":"73115d6ac6551e2707a0999b695f6522"},"tabularData":false,"creationDate":"2026-09-28","publicationDate":"2026-09-28","lastUpdateTime":"2026-09-28T04:25:44Z","fileAccessRequest":true}},{"description":"","label":"transcripts_localview_part2.tar","restricted":false,"version":1,"datasetVersionId":750007,"dataFile":{"id":14290478,"persistentId":"","filename":"transcripts_localview_part2.tar","contentType":"application/x-tar","friendlyType":"TAR Archive","filesize":2135592960,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:1a0e64201f5-0aa1ccf558f8","rootDataFileId":-1,"md5":"c601490f3d5bf461162bf706f35c8bcb","checksum":{"type":"MD5","value":"c601490f3d5bf461162bf706f35c8bcb"},"tabularData":false,"creationDate":"2026-09-28","publicationDate":"2026-09-28","lastUpdateTime":"2026-09-28T04:25:44Z","fileAccessRequest":true}},{"description":"","label":"transcripts_localview_part3.tar","restricted":false,"version":1,"datasetVersionId":750007,"dataFile":{"id":14290480,"persistentId":"","filename":"transcripts_localview_part3.tar","contentType":"application/x-tar","friendlyType":"TAR Archive","filesize":1068441600,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:1a0e642bed3-203c477ad482","rootDataFileId":-1,"md5":"8f5bab65528e0484b4ef18a03edef646","checksum":{"type":"MD5","value":"8f5bab65528e0484b4ef18a03edef646"},"tabularData":false,"creationDate":"2026-09-28","publicationDate":"2026-09-28","lastUpdateTime":"2026-09-28T04:25:44Z","fileAccessRequest":true}}]},{"id":749258,"datasetId":6889429,"datasetPersistentId":"doi:10.7910/DVN/NJTBEM","datasetType":"dataset","storageIdentifier":"s3://10.7910/DVN/NJTBEM","versionNumber":17,"internalVersionNumber":11,"versionMinorNumber":0,"versionState":"RELEASED","latestVersionPublishingState":"RELEASED","UNF":"UNF:6:3rGeZDgPBzA5D3fizkqrGw==","lastUpdateTime":"2026-09-21T04:27:17Z","releaseTime":"2026-09-21T04:27:17Z","createTime":"2026-09-21T04:24:27Z","publicationDate":"2023-01-13","citationDate":"2023-01-13","effectiveDatasetFileCountLimit":1000,"datasetFileUploadsAvailable":843,"license":{"name":"CC0 1.0","uri":"http://creativecommons.org/publicdomain/zero/1.0","iconUri":"https://licensebuttons.net/p/zero/1.0/88x31.png","rightsIdentifier":"CC0-1.0","rightsIdentifierScheme":"SPDX","schemeUri":"https://spdx.org/licenses/","languageCode":"en"},"fileAccessRequest":true,"metadataBlocks":{"citation":{"displayName":"Citation Metadata","name":"citation","fields":[{"typeName":"title","multiple":false,"typeClass":"primitive","value":"LocalView Public Meetings Database"},{"typeName":"author","multiple":true,"typeClass":"compound","value":[{"authorName":{"typeName":"authorName","multiple":false,"typeClass":"primitive","value":"Barari, Soubhik"},"authorAffiliation":{"typeName":"authorAffiliation","multiple":false,"typeClass":"primitive","value":"Harvard University"},"authorIdentifierScheme":{"typeName":"authorIdentifierScheme","multiple":false,"typeClass":"controlledVocabulary","value":"ORCID"},"authorIdentifier":{"typeName":"authorIdentifier","multiple":false,"typeClass":"primitive","value":"0000-0002-0126-7351"}},{"authorName":{"typeName":"authorName","multiple":false,"typeClass":"primitive","value":"Simko, Tyler"},"authorAffiliation":{"typeName":"authorAffiliation","multiple":false,"typeClass":"primitive","value":"https://ror.org/00jmfr291","expandedvalue":{"scheme":"http://www.grid.ac/ontology/","termName":"University of Michigan","@type":"https://schema.org/Organization"}},"authorIdentifierScheme":{"typeName":"authorIdentifierScheme","multiple":false,"typeClass":"controlledVocabulary","value":"ORCID"},"authorIdentifier":{"typeName":"authorIdentifier","multiple":false,"typeClass":"primitive","value":"0000-0001-9382-7346"}},{"authorName":{"typeName":"authorName","multiple":false,"typeClass":"primitive","value":"Reece, Mason"},"authorAffiliation":{"typeName":"authorAffiliation","multiple":false,"typeClass":"primitive","value":"https://ror.org/042nb2s44","expandedvalue":{"scheme":"http://www.grid.ac/ontology/","termName":"Massachusetts Institute of Technology","@type":"https://schema.org/Organization"}},"authorIdentifierScheme":{"typeName":"authorIdentifierScheme","multiple":false,"typeClass":"controlledVocabulary","value":"ORCID"},"authorIdentifier":{"typeName":"authorIdentifier","multiple":false,"typeClass":"primitive","value":"https://orcid.org/0009-0009-8761-2344","expandedvalue":{"personName":"Reece, Mason","@id":"https://orcid.org/0009-0009-8761-2344","scheme":"ORCID","@type":"https://schema.org/Person"}}}]},{"typeName":"datasetContact","multiple":true,"typeClass":"compound","value":[{"datasetContactName":{"typeName":"datasetContactName","multiple":false,"typeClass":"primitive","value":"Barari, Soubhik"},"datasetContactAffiliation":{"typeName":"datasetContactAffiliation","multiple":false,"typeClass":"primitive","value":"Harvard University"},"datasetContactEmail":{"typeName":"datasetContactEmail","multiple":false,"typeClass":"primitive","value":"sbarari@g.harvard.edu"}},{"datasetContactName":{"typeName":"datasetContactName","multiple":false,"typeClass":"primitive","value":"Simko, Tyler"},"datasetContactAffiliation":{"typeName":"datasetContactAffiliation","multiple":false,"typeClass":"primitive","value":"University of Michigan"},"datasetContactEmail":{"typeName":"datasetContactEmail","multiple":false,"typeClass":"primitive","value":"tsimko@umich.edu"}},{"datasetContactName":{"typeName":"datasetContactName","multiple":false,"typeClass":"primitive","value":"Reece, Mason"},"datasetContactAffiliation":{"typeName":"datasetContactAffiliation","multiple":false,"typeClass":"primitive","value":"Massachusetts Institute of Technology"},"datasetContactEmail":{"typeName":"datasetContactEmail","multiple":false,"typeClass":"primitive","value":"mpreece@mit.edu"}}]},{"typeName":"dsDescription","multiple":true,"typeClass":"compound","value":[{"dsDescriptionValue":{"typeName":"dsDescriptionValue","multiple":false,"typeClass":"primitive","value":"<h3>LocalView is a database co-created by <a href:\"mailto:sbarari@g.harvard.edu\">Soubhik Barari</a>, <a href=\"mailto:tsimko@umich.edu\">Tyler Simko</a>, and <a href=\"mailto:mpreece@mit.edu\">Mason Reece</a> to advance the study of local government in the United States.</h3><br>\n\nIt is the <i>largest existing dataset of local government public meetings</i>— the central policy-making process in American local government — as they are captured on video. <br><br>\n\nTo get started, select the file(s) that you'd like for your use case based on the year that the meeting took place. Note: we are no longer supporting file formats other than <code>.parquet</code> for space considerations. <br><br>\n\nFor potential use cases or further guidance on downloading the data in bulk, visit the companion website: <a href=\"https://www.localview.net\">localview.net</a>.\n\n<h1>Change Log</h1>\n\n<p>Scraping, parsing, identifying, and merging together meetings\ninvolves a large number of non-trivial decisions, many of which need to\nbe adjusted over time particularly as the YouTube API changes.</p>\n\n<p>As such, when such decisions notably deviate from process or the\noutputs documented in the <a href=\"https://soubhikbarari.com/writings/localview.pdf\">first version of\nthis database</a>, it will be logged here.</p>\n\n<div id=\"version-3.0-2026-05\" class=\"section level2\">\n  <h2>Version 3.0 (2026-05)</h2>\n\n  <ul>\n    <li>\n      Data updated until November 2025. Moving forward, data will be automatically updated to always be six months behind present.\n    </li>\n\n    <li>\n      Some new channels have been added. Please reach out to us via email if there are new local meeting channels not featured that we should include.\n    </li>\n\n    <li>\n      Codebook has been updated and simplified. ACS related columns have been removed.\n    </li>\n\n    <li>\n      Data format has been modified to separate transcripts from metadata\n      <ul>\n        <li>\n          First, download <code>meta_localview.parquet</code>, then filter to the channels and/or videos of interest.\n        </li>\n        <li>\n          Then, merge in transcripts as desired from <code>transcripts_localview_*.zip</code>. Transcript file names are identified as \"<code>channel_id</code>__<code>id</code>.txt.gz\".\n        </li>\n        <li>\n          The transcript files have been separated into two parts only because of Dataverse size constraints, otherwise they are identical.\n        </li>\n      </ul>\n    </li>\n  </ul>\n</div>\n\n<div id=\"version-2.0-2023-10\" class=\"section level2\">\n<h2>Version 2.0 (2023-10)</h2>\n<ul>\n<li>Data updated up until September 2023.\n<ul>\n<li>~10,000 new videos added, all belonging to existing channels in\ndatabase.</li>\n</ul></li>\n<li>Change in data format:\n<ul>\n<li><code>channelType</code> column changed to\n<code>channel_type</code>.</li>\n<li><code>ST_FIPS</code> correctly padded to be 7 characters (2 digit\nstate code + 5 digit place FIPS code).</li>\n<li>videos with no caption available from YouTube are explicitly marked\nas “<No caption available>” in <code>caption_text</code>.</li>\n<li><code>caption_text_cleaned</code> is actually consistently cleaned\n(previously stray timestamps/pause markers in some entries).</li>\n<li><code>acs_2018_*</code> columns now prefixed as\n<code>acs_18</code>.</li>\n<li>additional ACS variables now available for each place:\n<ul>\n<li><code>acs_18_median_gross_rent</code>: Median gross rent in FIPS\nplace.</li>\n<li><code>acs_18_median_hh_inc</code>: Median household income in FIPS\nplace.</li>\n<li><code>acs_18_median_age</code>: Median age in FIPS place.</li>\n<li><code>acs_18_amind</code>: American Indian population in FIPS\nplace.</li>\n<li><code>acs_18_asian</code>: Asian population in FIPS place.</li>\n<li><code>acs_18_nhapi</code>: Native Hawaiian or Pacific Islander\npopulation in FIPS place.</li>\n</ul></li>\n<li><code>census_2015_*</code> columns removed for redundancy.</li>\n<li>to avoid confusion and possible conflicts, <code>.json</code> and\n<code>.csv</code> file formats eliminated in favor of\n<code>.parquet</code> format.</li>\n<li>municipal voteshare (<code>_dem2pv</code>) variables have been\nremoved from the public use files for a number of reasons: (1) high\ndegree of missingness, (2) no columns estimates available, (3) potential\nsensitivity</li>\n</ul></li>\n<li>The matching process of videos to ST-FIPS and government types is as\nfollows:\n<ul>\n<li>videos are matched to channels’ previous ST-FIPS codes and/or\ngovernment types <em>if</em> there is an umambiguous match, otherwise a\n(1) series of regex matches with video title/description are used to\nattempt to match video to the government and (2) state/place names are\nextracted from each video’s title/description/caption and used to match\nto an ST-FIPS entity <em>if</em> an unambiguous match; only identified\nvideos are then uploaded to the database.</li>\n<li>to identify the date of the meeting that the video captures, we\nfirst try to extract the date from the title, otherwise we try to\nextract the date from the description, otherwise it is discarded.</li>\n</ul></li>\n</ul>\n</div>\n<div id=\"version-1.0-2023-02\" class=\"section level2\">\n<h2>Version 1.0 (2023-02)</h2>\n<p>See <a href=\"https://soubhikbarari.com/writings/localview.pdf\">publication</a>\nfor full details on methodology choices for the Version 1.0\ndatabase.</p>\n</div>\n</div>"}}]},{"typeName":"subject","multiple":true,"typeClass":"controlledVocabulary","value":["Social Sciences"]},{"typeName":"keyword","multiple":true,"typeClass":"compound","value":[{"keywordValue":{"typeName":"keywordValue","multiple":false,"typeClass":"primitive","value":"local politics"}},{"keywordValue":{"typeName":"keywordValue","multiple":false,"typeClass":"primitive","value":"political communication"}},{"keywordValue":{"typeName":"keywordValue","multiple":false,"typeClass":"primitive","value":"deliberative democracy"}}]},{"typeName":"depositor","multiple":false,"typeClass":"primitive","value":"Barari, Soubhik"},{"typeName":"dateOfDeposit","multiple":false,"typeClass":"primitive","value":"2023-01-13"},{"typeName":"software","multiple":true,"typeClass":"compound","value":[{"softwareVersion":{"typeName":"softwareVersion","multiple":false,"typeClass":"primitive","value":"2.0"}}]}]}},"files":[{"description":"Codebook describing different variables in the data + example code","label":"codebook.md","restricted":false,"version":1,"datasetVersionId":749258,"dataFile":{"id":14077924,"persistentId":"","filename":"codebook.md","contentType":"text/markdown","friendlyType":"Markdown Text","filesize":6387,"description":"Codebook describing different variables in the data + example code","storageIdentifier":"s3://dvn-cloud-iqss:19f66db7722-8cfca0a72b54","rootDataFileId":-1,"md5":"ebc5d2ed9f72f5921db2229ad5516fa3","checksum":{"type":"MD5","value":"ebc5d2ed9f72f5921db2229ad5516fa3"},"tabularData":false,"creationDate":"2026-07-15","publicationDate":"2026-07-21","lastUpdateTime":"2026-09-21T04:27:17Z","fileAccessRequest":true}},{"description":"","label":"meta_localview.parquet","restricted":false,"version":1,"datasetVersionId":749258,"dataFile":{"id":14256728,"persistentId":"","filename":"meta_localview.parquet","contentType":"application/octet-stream","friendlyType":"Unknown","filesize":35421656,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:1a0c23552e6-c397bdd8042e","rootDataFileId":-1,"md5":"4e79d593cba19086520217cd028728f9","checksum":{"type":"MD5","value":"4e79d593cba19086520217cd028728f9"},"tabularData":false,"creationDate":"2026-09-21","publicationDate":"2026-09-21","lastUpdateTime":"2026-09-21T04:27:17Z","fileAccessRequest":true}},{"description":"","label":"transcripts_localview_part1.tar","restricted":false,"version":1,"datasetVersionId":749258,"dataFile":{"id":14256729,"persistentId":"","filename":"transcripts_localview_part1.tar","contentType":"application/x-tar","friendlyType":"TAR Archive","filesize":2135848960,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:1a0c235f1a0-31340fee5d24","rootDataFileId":-1,"md5":"2d8e055fe567c159d6b96452a8dce951","checksum":{"type":"MD5","value":"2d8e055fe567c159d6b96452a8dce951"},"tabularData":false,"creationDate":"2026-09-21","publicationDate":"2026-09-21","lastUpdateTime":"2026-09-21T04:27:17Z","fileAccessRequest":true}},{"description":"","label":"transcripts_localview_part2.tar","restricted":false,"version":1,"datasetVersionId":749258,"dataFile":{"id":14256730,"persistentId":"","filename":"transcripts_localview_part2.tar","contentType":"application/x-tar","friendlyType":"TAR Archive","filesize":2135777280,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:1a0c236f4af-49e0d611a910","rootDataFileId":-1,"md5":"501e2ad868d1ada707639589311b6b82","checksum":{"type":"MD5","value":"501e2ad868d1ada707639589311b6b82"},"tabularData":false,"creationDate":"2026-09-21","publicationDate":"2026-09-21","lastUpdateTime":"2026-09-21T04:27:17Z","fileAccessRequest":true}},{"description":"","label":"transcripts_localview_part3.tar","restricted":false,"version":1,"datasetVersionId":749258,"dataFile":{"id":14256732,"persistentId":"","filename":"transcripts_localview_part3.tar","contentType":"application/x-tar","friendlyType":"TAR Archive","filesize":1055590400,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:1a0c237aa90-8cb59590c685","rootDataFileId":-1,"md5":"c2b2dc43925b60951d11a0dcd5f1b2d1","checksum":{"type":"MD5","value":"c2b2dc43925b60951d11a0dcd5f1b2d1"},"tabularData":false,"creationDate":"2026-09-21","publicationDate":"2026-09-21","lastUpdateTime":"2026-09-21T04:27:17Z","fileAccessRequest":true}}]},{"id":748560,"datasetId":6889429,"datasetPersistentId":"doi:10.7910/DVN/NJTBEM","datasetType":"dataset","storageIdentifier":"s3://10.7910/DVN/NJTBEM","versionNumber":16,"internalVersionNumber":11,"versionMinorNumber":0,"versionState":"RELEASED","latestVersionPublishingState":"RELEASED","UNF":"UNF:6:3rGeZDgPBzA5D3fizkqrGw==","lastUpdateTime":"2026-09-14T04:28:23Z","releaseTime":"2026-09-14T04:28:23Z","createTime":"2026-09-14T04:25:30Z","publicationDate":"2023-01-13","citationDate":"2023-01-13","effectiveDatasetFileCountLimit":1000,"datasetFileUploadsAvailable":843,"license":{"name":"CC0 1.0","uri":"http://creativecommons.org/publicdomain/zero/1.0","iconUri":"https://licensebuttons.net/p/zero/1.0/88x31.png","rightsIdentifier":"CC0-1.0","rightsIdentifierScheme":"SPDX","schemeUri":"https://spdx.org/licenses/","languageCode":"en"},"fileAccessRequest":true,"metadataBlocks":{"citation":{"displayName":"Citation Metadata","name":"citation","fields":[{"typeName":"title","multiple":false,"typeClass":"primitive","value":"LocalView Public Meetings Database"},{"typeName":"author","multiple":true,"typeClass":"compound","value":[{"authorName":{"typeName":"authorName","multiple":false,"typeClass":"primitive","value":"Barari, Soubhik"},"authorAffiliation":{"typeName":"authorAffiliation","multiple":false,"typeClass":"primitive","value":"Harvard University"},"authorIdentifierScheme":{"typeName":"authorIdentifierScheme","multiple":false,"typeClass":"controlledVocabulary","value":"ORCID"},"authorIdentifier":{"typeName":"authorIdentifier","multiple":false,"typeClass":"primitive","value":"0000-0002-0126-7351"}},{"authorName":{"typeName":"authorName","multiple":false,"typeClass":"primitive","value":"Simko, Tyler"},"authorAffiliation":{"typeName":"authorAffiliation","multiple":false,"typeClass":"primitive","value":"https://ror.org/00jmfr291","expandedvalue":{"scheme":"http://www.grid.ac/ontology/","termName":"University of Michigan","@type":"https://schema.org/Organization"}},"authorIdentifierScheme":{"typeName":"authorIdentifierScheme","multiple":false,"typeClass":"controlledVocabulary","value":"ORCID"},"authorIdentifier":{"typeName":"authorIdentifier","multiple":false,"typeClass":"primitive","value":"0000-0001-9382-7346"}},{"authorName":{"typeName":"authorName","multiple":false,"typeClass":"primitive","value":"Reece, Mason"},"authorAffiliation":{"typeName":"authorAffiliation","multiple":false,"typeClass":"primitive","value":"https://ror.org/042nb2s44","expandedvalue":{"scheme":"http://www.grid.ac/ontology/","termName":"Massachusetts Institute of Technology","@type":"https://schema.org/Organization"}},"authorIdentifierScheme":{"typeName":"authorIdentifierScheme","multiple":false,"typeClass":"controlledVocabulary","value":"ORCID"},"authorIdentifier":{"typeName":"authorIdentifier","multiple":false,"typeClass":"primitive","value":"https://orcid.org/0009-0009-8761-2344","expandedvalue":{"personName":"Reece, Mason","@id":"https://orcid.org/0009-0009-8761-2344","scheme":"ORCID","@type":"https://schema.org/Person"}}}]},{"typeName":"datasetContact","multiple":true,"typeClass":"compound","value":[{"datasetContactName":{"typeName":"datasetContactName","multiple":false,"typeClass":"primitive","value":"Barari, Soubhik"},"datasetContactAffiliation":{"typeName":"datasetContactAffiliation","multiple":false,"typeClass":"primitive","value":"Harvard University"},"datasetContactEmail":{"typeName":"datasetContactEmail","multiple":false,"typeClass":"primitive","value":"sbarari@g.harvard.edu"}},{"datasetContactName":{"typeName":"datasetContactName","multiple":false,"typeClass":"primitive","value":"Simko, Tyler"},"datasetContactAffiliation":{"typeName":"datasetContactAffiliation","multiple":false,"typeClass":"primitive","value":"University of Michigan"},"datasetContactEmail":{"typeName":"datasetContactEmail","multiple":false,"typeClass":"primitive","value":"tsimko@umich.edu"}},{"datasetContactName":{"typeName":"datasetContactName","multiple":false,"typeClass":"primitive","value":"Reece, Mason"},"datasetContactAffiliation":{"typeName":"datasetContactAffiliation","multiple":false,"typeClass":"primitive","value":"Massachusetts Institute of Technology"},"datasetContactEmail":{"typeName":"datasetContactEmail","multiple":false,"typeClass":"primitive","value":"mpreece@mit.edu"}}]},{"typeName":"dsDescription","multiple":true,"typeClass":"compound","value":[{"dsDescriptionValue":{"typeName":"dsDescriptionValue","multiple":false,"typeClass":"primitive","value":"<h3>LocalView is a database co-created by <a href:\"mailto:sbarari@g.harvard.edu\">Soubhik Barari</a>, <a href=\"mailto:tsimko@umich.edu\">Tyler Simko</a>, and <a href=\"mailto:mpreece@mit.edu\">Mason Reece</a> to advance the study of local government in the United States.</h3><br>\n\nIt is the <i>largest existing dataset of local government public meetings</i>— the central policy-making process in American local government — as they are captured on video. <br><br>\n\nTo get started, select the file(s) that you'd like for your use case based on the year that the meeting took place. Note: we are no longer supporting file formats other than <code>.parquet</code> for space considerations. <br><br>\n\nFor potential use cases or further guidance on downloading the data in bulk, visit the companion website: <a href=\"https://www.localview.net\">localview.net</a>.\n\n<h1>Change Log</h1>\n\n<p>Scraping, parsing, identifying, and merging together meetings\ninvolves a large number of non-trivial decisions, many of which need to\nbe adjusted over time particularly as the YouTube API changes.</p>\n\n<p>As such, when such decisions notably deviate from process or the\noutputs documented in the <a href=\"https://soubhikbarari.com/writings/localview.pdf\">first version of\nthis database</a>, it will be logged here.</p>\n\n<div id=\"version-3.0-2026-05\" class=\"section level2\">\n  <h2>Version 3.0 (2026-05)</h2>\n\n  <ul>\n    <li>\n      Data updated until November 2025. Moving forward, data will be automatically updated to always be six months behind present.\n    </li>\n\n    <li>\n      Some new channels have been added. Please reach out to us via email if there are new local meeting channels not featured that we should include.\n    </li>\n\n    <li>\n      Codebook has been updated and simplified. ACS related columns have been removed.\n    </li>\n\n    <li>\n      Data format has been modified to separate transcripts from metadata\n      <ul>\n        <li>\n          First, download <code>meta_localview.parquet</code>, then filter to the channels and/or videos of interest.\n        </li>\n        <li>\n          Then, merge in transcripts as desired from <code>transcripts_localview_*.zip</code>. Transcript file names are identified as \"<code>channel_id</code>__<code>id</code>.txt.gz\".\n        </li>\n        <li>\n          The transcript files have been separated into two parts only because of Dataverse size constraints, otherwise they are identical.\n        </li>\n      </ul>\n    </li>\n  </ul>\n</div>\n\n<div id=\"version-2.0-2023-10\" class=\"section level2\">\n<h2>Version 2.0 (2023-10)</h2>\n<ul>\n<li>Data updated up until September 2023.\n<ul>\n<li>~10,000 new videos added, all belonging to existing channels in\ndatabase.</li>\n</ul></li>\n<li>Change in data format:\n<ul>\n<li><code>channelType</code> column changed to\n<code>channel_type</code>.</li>\n<li><code>ST_FIPS</code> correctly padded to be 7 characters (2 digit\nstate code + 5 digit place FIPS code).</li>\n<li>videos with no caption available from YouTube are explicitly marked\nas “<No caption available>” in <code>caption_text</code>.</li>\n<li><code>caption_text_cleaned</code> is actually consistently cleaned\n(previously stray timestamps/pause markers in some entries).</li>\n<li><code>acs_2018_*</code> columns now prefixed as\n<code>acs_18</code>.</li>\n<li>additional ACS variables now available for each place:\n<ul>\n<li><code>acs_18_median_gross_rent</code>: Median gross rent in FIPS\nplace.</li>\n<li><code>acs_18_median_hh_inc</code>: Median household income in FIPS\nplace.</li>\n<li><code>acs_18_median_age</code>: Median age in FIPS place.</li>\n<li><code>acs_18_amind</code>: American Indian population in FIPS\nplace.</li>\n<li><code>acs_18_asian</code>: Asian population in FIPS place.</li>\n<li><code>acs_18_nhapi</code>: Native Hawaiian or Pacific Islander\npopulation in FIPS place.</li>\n</ul></li>\n<li><code>census_2015_*</code> columns removed for redundancy.</li>\n<li>to avoid confusion and possible conflicts, <code>.json</code> and\n<code>.csv</code> file formats eliminated in favor of\n<code>.parquet</code> format.</li>\n<li>municipal voteshare (<code>_dem2pv</code>) variables have been\nremoved from the public use files for a number of reasons: (1) high\ndegree of missingness, (2) no columns estimates available, (3) potential\nsensitivity</li>\n</ul></li>\n<li>The matching process of videos to ST-FIPS and government types is as\nfollows:\n<ul>\n<li>videos are matched to channels’ previous ST-FIPS codes and/or\ngovernment types <em>if</em> there is an umambiguous match, otherwise a\n(1) series of regex matches with video title/description are used to\nattempt to match video to the government and (2) state/place names are\nextracted from each video’s title/description/caption and used to match\nto an ST-FIPS entity <em>if</em> an unambiguous match; only identified\nvideos are then uploaded to the database.</li>\n<li>to identify the date of the meeting that the video captures, we\nfirst try to extract the date from the title, otherwise we try to\nextract the date from the description, otherwise it is discarded.</li>\n</ul></li>\n</ul>\n</div>\n<div id=\"version-1.0-2023-02\" class=\"section level2\">\n<h2>Version 1.0 (2023-02)</h2>\n<p>See <a href=\"https://soubhikbarari.com/writings/localview.pdf\">publication</a>\nfor full details on methodology choices for the Version 1.0\ndatabase.</p>\n</div>\n</div>"}}]},{"typeName":"subject","multiple":true,"typeClass":"controlledVocabulary","value":["Social Sciences"]},{"typeName":"keyword","multiple":true,"typeClass":"compound","value":[{"keywordValue":{"typeName":"keywordValue","multiple":false,"typeClass":"primitive","value":"local politics"}},{"keywordValue":{"typeName":"keywordValue","multiple":false,"typeClass":"primitive","value":"political communication"}},{"keywordValue":{"typeName":"keywordValue","multiple":false,"typeClass":"primitive","value":"deliberative democracy"}}]},{"typeName":"depositor","multiple":false,"typeClass":"primitive","value":"Barari, Soubhik"},{"typeName":"dateOfDeposit","multiple":false,"typeClass":"primitive","value":"2023-01-13"},{"typeName":"software","multiple":true,"typeClass":"compound","value":[{"softwareVersion":{"typeName":"softwareVersion","multiple":false,"typeClass":"primitive","value":"2.0"}}]}]}},"files":[{"description":"Codebook describing different variables in the data + example code","label":"codebook.md","restricted":false,"version":1,"datasetVersionId":748560,"dataFile":{"id":14077924,"persistentId":"","filename":"codebook.md","contentType":"text/markdown","friendlyType":"Markdown Text","filesize":6387,"description":"Codebook describing different variables in the data + example code","storageIdentifier":"s3://dvn-cloud-iqss:19f66db7722-8cfca0a72b54","rootDataFileId":-1,"md5":"ebc5d2ed9f72f5921db2229ad5516fa3","checksum":{"type":"MD5","value":"ebc5d2ed9f72f5921db2229ad5516fa3"},"tabularData":false,"creationDate":"2026-07-15","publicationDate":"2026-07-21","lastUpdateTime":"2026-09-14T04:28:23Z","fileAccessRequest":true}},{"description":"","label":"meta_localview.parquet","restricted":false,"version":1,"datasetVersionId":748560,"dataFile":{"id":14233652,"persistentId":"","filename":"meta_localview.parquet","contentType":"application/octet-stream","friendlyType":"Unknown","filesize":35339621,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:1a09e29c424-2cf1d557986d","rootDataFileId":-1,"md5":"2cb76ebe925cf83f06dcc9cf0db07fd0","checksum":{"type":"MD5","value":"2cb76ebe925cf83f06dcc9cf0db07fd0"},"tabularData":false,"creationDate":"2026-09-14","publicationDate":"2026-09-14","lastUpdateTime":"2026-09-14T04:28:23Z","fileAccessRequest":true}},{"description":"","label":"transcripts_localview_part1.tar","restricted":false,"version":1,"datasetVersionId":748560,"dataFile":{"id":14233653,"persistentId":"","filename":"transcripts_localview_part1.tar","contentType":"application/x-tar","friendlyType":"TAR Archive","filesize":2135971840,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:1a09e2a6852-1b2daaacb974","rootDataFileId":-1,"md5":"0dea72d71ee84270aed9e6f3f021d66f","checksum":{"type":"MD5","value":"0dea72d71ee84270aed9e6f3f021d66f"},"tabularData":false,"creationDate":"2026-09-14","publicationDate":"2026-09-14","lastUpdateTime":"2026-09-14T04:28:23Z","fileAccessRequest":true}},{"description":"","label":"transcripts_localview_part2.tar","restricted":false,"version":1,"datasetVersionId":748560,"dataFile":{"id":14233654,"persistentId":"","filename":"transcripts_localview_part2.tar","contentType":"application/x-tar","friendlyType":"TAR Archive","filesize":2136422400,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:1a09e2b6eae-41f00308c2b4","rootDataFileId":-1,"md5":"96da7fb362c0bbbd9c7b6d9a36bf69be","checksum":{"type":"MD5","value":"96da7fb362c0bbbd9c7b6d9a36bf69be"},"tabularData":false,"creationDate":"2026-09-14","publicationDate":"2026-09-14","lastUpdateTime":"2026-09-14T04:28:23Z","fileAccessRequest":true}},{"description":"","label":"transcripts_localview_part3.tar","restricted":false,"version":1,"datasetVersionId":748560,"dataFile":{"id":14233655,"persistentId":"","filename":"transcripts_localview_part3.tar","contentType":"application/x-tar","friendlyType":"TAR Archive","filesize":1038776320,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:1a09e2c27f2-c3aa64380e17","rootDataFileId":-1,"md5":"487e5e111e714e8637676e79e668fea0","checksum":{"type":"MD5","value":"487e5e111e714e8637676e79e668fea0"},"tabularData":false,"creationDate":"2026-09-14","publicationDate":"2026-09-14","lastUpdateTime":"2026-09-14T04:28:23Z","fileAccessRequest":true}}]},{"id":747565,"datasetId":6889429,"datasetPersistentId":"doi:10.7910/DVN/NJTBEM","datasetType":"dataset","storageIdentifier":"s3://10.7910/DVN/NJTBEM","versionNumber":15,"internalVersionNumber":11,"versionMinorNumber":0,"versionState":"RELEASED","latestVersionPublishingState":"RELEASED","UNF":"UNF:6:3rGeZDgPBzA5D3fizkqrGw==","lastUpdateTime":"2026-09-07T04:23:11Z","releaseTime":"2026-09-07T04:23:11Z","createTime":"2026-09-07T04:20:14Z","publicationDate":"2023-01-13","citationDate":"2023-01-13","effectiveDatasetFileCountLimit":1000,"datasetFileUploadsAvailable":843,"license":{"name":"CC0 1.0","uri":"http://creativecommons.org/publicdomain/zero/1.0","iconUri":"https://licensebuttons.net/p/zero/1.0/88x31.png","rightsIdentifier":"CC0-1.0","rightsIdentifierScheme":"SPDX","schemeUri":"https://spdx.org/licenses/","languageCode":"en"},"fileAccessRequest":true,"metadataBlocks":{"citation":{"displayName":"Citation Metadata","name":"citation","fields":[{"typeName":"title","multiple":false,"typeClass":"primitive","value":"LocalView Public Meetings Database"},{"typeName":"author","multiple":true,"typeClass":"compound","value":[{"authorName":{"typeName":"authorName","multiple":false,"typeClass":"primitive","value":"Barari, Soubhik"},"authorAffiliation":{"typeName":"authorAffiliation","multiple":false,"typeClass":"primitive","value":"Harvard University"},"authorIdentifierScheme":{"typeName":"authorIdentifierScheme","multiple":false,"typeClass":"controlledVocabulary","value":"ORCID"},"authorIdentifier":{"typeName":"authorIdentifier","multiple":false,"typeClass":"primitive","value":"0000-0002-0126-7351"}},{"authorName":{"typeName":"authorName","multiple":false,"typeClass":"primitive","value":"Simko, Tyler"},"authorAffiliation":{"typeName":"authorAffiliation","multiple":false,"typeClass":"primitive","value":"https://ror.org/00jmfr291","expandedvalue":{"scheme":"http://www.grid.ac/ontology/","termName":"University of Michigan","@type":"https://schema.org/Organization"}},"authorIdentifierScheme":{"typeName":"authorIdentifierScheme","multiple":false,"typeClass":"controlledVocabulary","value":"ORCID"},"authorIdentifier":{"typeName":"authorIdentifier","multiple":false,"typeClass":"primitive","value":"0000-0001-9382-7346"}},{"authorName":{"typeName":"authorName","multiple":false,"typeClass":"primitive","value":"Reece, Mason"},"authorAffiliation":{"typeName":"authorAffiliation","multiple":false,"typeClass":"primitive","value":"https://ror.org/042nb2s44","expandedvalue":{"scheme":"http://www.grid.ac/ontology/","termName":"Massachusetts Institute of Technology","@type":"https://schema.org/Organization"}},"authorIdentifierScheme":{"typeName":"authorIdentifierScheme","multiple":false,"typeClass":"controlledVocabulary","value":"ORCID"},"authorIdentifier":{"typeName":"authorIdentifier","multiple":false,"typeClass":"primitive","value":"https://orcid.org/0009-0009-8761-2344","expandedvalue":{"personName":"Reece, Mason","@id":"https://orcid.org/0009-0009-8761-2344","scheme":"ORCID","@type":"https://schema.org/Person"}}}]},{"typeName":"datasetContact","multiple":true,"typeClass":"compound","value":[{"datasetContactName":{"typeName":"datasetContactName","multiple":false,"typeClass":"primitive","value":"Barari, Soubhik"},"datasetContactAffiliation":{"typeName":"datasetContactAffiliation","multiple":false,"typeClass":"primitive","value":"Harvard University"},"datasetContactEmail":{"typeName":"datasetContactEmail","multiple":false,"typeClass":"primitive","value":"sbarari@g.harvard.edu"}},{"datasetContactName":{"typeName":"datasetContactName","multiple":false,"typeClass":"primitive","value":"Simko, Tyler"},"datasetContactAffiliation":{"typeName":"datasetContactAffiliation","multiple":false,"typeClass":"primitive","value":"University of Michigan"},"datasetContactEmail":{"typeName":"datasetContactEmail","multiple":false,"typeClass":"primitive","value":"tsimko@umich.edu"}},{"datasetContactName":{"typeName":"datasetContactName","multiple":false,"typeClass":"primitive","value":"Reece, Mason"},"datasetContactAffiliation":{"typeName":"datasetContactAffiliation","multiple":false,"typeClass":"primitive","value":"Massachusetts Institute of Technology"},"datasetContactEmail":{"typeName":"datasetContactEmail","multiple":false,"typeClass":"primitive","value":"mpreece@mit.edu"}}]},{"typeName":"dsDescription","multiple":true,"typeClass":"compound","value":[{"dsDescriptionValue":{"typeName":"dsDescriptionValue","multiple":false,"typeClass":"primitive","value":"<h3>LocalView is a database co-created by <a href:\"mailto:sbarari@g.harvard.edu\">Soubhik Barari</a>, <a href=\"mailto:tsimko@umich.edu\">Tyler Simko</a>, and <a href=\"mailto:mpreece@mit.edu\">Mason Reece</a> to advance the study of local government in the United States.</h3><br>\n\nIt is the <i>largest existing dataset of local government public meetings</i>— the central policy-making process in American local government — as they are captured on video. <br><br>\n\nTo get started, select the file(s) that you'd like for your use case based on the year that the meeting took place. Note: we are no longer supporting file formats other than <code>.parquet</code> for space considerations. <br><br>\n\nFor potential use cases or further guidance on downloading the data in bulk, visit the companion website: <a href=\"https://www.localview.net\">localview.net</a>.\n\n<h1>Change Log</h1>\n\n<p>Scraping, parsing, identifying, and merging together meetings\ninvolves a large number of non-trivial decisions, many of which need to\nbe adjusted over time particularly as the YouTube API changes.</p>\n\n<p>As such, when such decisions notably deviate from process or the\noutputs documented in the <a href=\"https://soubhikbarari.com/writings/localview.pdf\">first version of\nthis database</a>, it will be logged here.</p>\n\n<div id=\"version-3.0-2026-05\" class=\"section level2\">\n  <h2>Version 3.0 (2026-05)</h2>\n\n  <ul>\n    <li>\n      Data updated until November 2025. Moving forward, data will be automatically updated to always be six months behind present.\n    </li>\n\n    <li>\n      Some new channels have been added. Please reach out to us via email if there are new local meeting channels not featured that we should include.\n    </li>\n\n    <li>\n      Codebook has been updated and simplified. ACS related columns have been removed.\n    </li>\n\n    <li>\n      Data format has been modified to separate transcripts from metadata\n      <ul>\n        <li>\n          First, download <code>meta_localview.parquet</code>, then filter to the channels and/or videos of interest.\n        </li>\n        <li>\n          Then, merge in transcripts as desired from <code>transcripts_localview_*.zip</code>. Transcript file names are identified as \"<code>channel_id</code>__<code>id</code>.txt.gz\".\n        </li>\n        <li>\n          The transcript files have been separated into two parts only because of Dataverse size constraints, otherwise they are identical.\n        </li>\n      </ul>\n    </li>\n  </ul>\n</div>\n\n<div id=\"version-2.0-2023-10\" class=\"section level2\">\n<h2>Version 2.0 (2023-10)</h2>\n<ul>\n<li>Data updated up until September 2023.\n<ul>\n<li>~10,000 new videos added, all belonging to existing channels in\ndatabase.</li>\n</ul></li>\n<li>Change in data format:\n<ul>\n<li><code>channelType</code> column changed to\n<code>channel_type</code>.</li>\n<li><code>ST_FIPS</code> correctly padded to be 7 characters (2 digit\nstate code + 5 digit place FIPS code).</li>\n<li>videos with no caption available from YouTube are explicitly marked\nas “<No caption available>” in <code>caption_text</code>.</li>\n<li><code>caption_text_cleaned</code> is actually consistently cleaned\n(previously stray timestamps/pause markers in some entries).</li>\n<li><code>acs_2018_*</code> columns now prefixed as\n<code>acs_18</code>.</li>\n<li>additional ACS variables now available for each place:\n<ul>\n<li><code>acs_18_median_gross_rent</code>: Median gross rent in FIPS\nplace.</li>\n<li><code>acs_18_median_hh_inc</code>: Median household income in FIPS\nplace.</li>\n<li><code>acs_18_median_age</code>: Median age in FIPS place.</li>\n<li><code>acs_18_amind</code>: American Indian population in FIPS\nplace.</li>\n<li><code>acs_18_asian</code>: Asian population in FIPS place.</li>\n<li><code>acs_18_nhapi</code>: Native Hawaiian or Pacific Islander\npopulation in FIPS place.</li>\n</ul></li>\n<li><code>census_2015_*</code> columns removed for redundancy.</li>\n<li>to avoid confusion and possible conflicts, <code>.json</code> and\n<code>.csv</code> file formats eliminated in favor of\n<code>.parquet</code> format.</li>\n<li>municipal voteshare (<code>_dem2pv</code>) variables have been\nremoved from the public use files for a number of reasons: (1) high\ndegree of missingness, (2) no columns estimates available, (3) potential\nsensitivity</li>\n</ul></li>\n<li>The matching process of videos to ST-FIPS and government types is as\nfollows:\n<ul>\n<li>videos are matched to channels’ previous ST-FIPS codes and/or\ngovernment types <em>if</em> there is an umambiguous match, otherwise a\n(1) series of regex matches with video title/description are used to\nattempt to match video to the government and (2) state/place names are\nextracted from each video’s title/description/caption and used to match\nto an ST-FIPS entity <em>if</em> an unambiguous match; only identified\nvideos are then uploaded to the database.</li>\n<li>to identify the date of the meeting that the video captures, we\nfirst try to extract the date from the title, otherwise we try to\nextract the date from the description, otherwise it is discarded.</li>\n</ul></li>\n</ul>\n</div>\n<div id=\"version-1.0-2023-02\" class=\"section level2\">\n<h2>Version 1.0 (2023-02)</h2>\n<p>See <a href=\"https://soubhikbarari.com/writings/localview.pdf\">publication</a>\nfor full details on methodology choices for the Version 1.0\ndatabase.</p>\n</div>\n</div>"}}]},{"typeName":"subject","multiple":true,"typeClass":"controlledVocabulary","value":["Social Sciences"]},{"typeName":"keyword","multiple":true,"typeClass":"compound","value":[{"keywordValue":{"typeName":"keywordValue","multiple":false,"typeClass":"primitive","value":"local politics"}},{"keywordValue":{"typeName":"keywordValue","multiple":false,"typeClass":"primitive","value":"political communication"}},{"keywordValue":{"typeName":"keywordValue","multiple":false,"typeClass":"primitive","value":"deliberative democracy"}}]},{"typeName":"depositor","multiple":false,"typeClass":"primitive","value":"Barari, Soubhik"},{"typeName":"dateOfDeposit","multiple":false,"typeClass":"primitive","value":"2023-01-13"},{"typeName":"software","multiple":true,"typeClass":"compound","value":[{"softwareVersion":{"typeName":"softwareVersion","multiple":false,"typeClass":"primitive","value":"2.0"}}]}]}},"files":[{"description":"Codebook describing different variables in the data + example code","label":"codebook.md","restricted":false,"version":1,"datasetVersionId":747565,"dataFile":{"id":14077924,"persistentId":"","filename":"codebook.md","contentType":"text/markdown","friendlyType":"Markdown Text","filesize":6387,"description":"Codebook describing different variables in the data + example code","storageIdentifier":"s3://dvn-cloud-iqss:19f66db7722-8cfca0a72b54","rootDataFileId":-1,"md5":"ebc5d2ed9f72f5921db2229ad5516fa3","checksum":{"type":"MD5","value":"ebc5d2ed9f72f5921db2229ad5516fa3"},"tabularData":false,"creationDate":"2026-07-15","publicationDate":"2026-07-21","lastUpdateTime":"2026-09-07T04:23:11Z","fileAccessRequest":true}},{"description":"","label":"meta_localview.parquet","restricted":false,"version":1,"datasetVersionId":747565,"dataFile":{"id":14214554,"persistentId":"","filename":"meta_localview.parquet","contentType":"application/octet-stream","friendlyType":"Unknown","filesize":35200750,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:1a07a186f64-8e470ca120d1","rootDataFileId":-1,"md5":"230fad4a9e55ebb3f7efabd39578c824","checksum":{"type":"MD5","value":"230fad4a9e55ebb3f7efabd39578c824"},"tabularData":false,"creationDate":"2026-09-07","publicationDate":"2026-09-07","lastUpdateTime":"2026-09-07T04:23:11Z","fileAccessRequest":true}},{"description":"","label":"transcripts_localview_part1.tar","restricted":false,"version":1,"datasetVersionId":747565,"dataFile":{"id":14214555,"persistentId":"","filename":"transcripts_localview_part1.tar","contentType":"application/x-tar","friendlyType":"TAR Archive","filesize":2136033280,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:1a07a19142f-e3615a5ef5a6","rootDataFileId":-1,"md5":"cb7434b7e0b6178d1d9bbda636f27fba","checksum":{"type":"MD5","value":"cb7434b7e0b6178d1d9bbda636f27fba"},"tabularData":false,"creationDate":"2026-09-07","publicationDate":"2026-09-07","lastUpdateTime":"2026-09-07T04:23:11Z","fileAccessRequest":true}},{"description":"","label":"transcripts_localview_part2.tar","restricted":false,"version":1,"datasetVersionId":747565,"dataFile":{"id":14214556,"persistentId":"","filename":"transcripts_localview_part2.tar","contentType":"application/x-tar","friendlyType":"TAR Archive","filesize":2136606720,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:1a07a1a21b4-b46f999871fb","rootDataFileId":-1,"md5":"2fa9b17daaa469926e0d7df126c0dcec","checksum":{"type":"MD5","value":"2fa9b17daaa469926e0d7df126c0dcec"},"tabularData":false,"creationDate":"2026-09-07","publicationDate":"2026-09-07","lastUpdateTime":"2026-09-07T04:23:11Z","fileAccessRequest":true}},{"description":"","label":"transcripts_localview_part3.tar","restricted":false,"version":1,"datasetVersionId":747565,"dataFile":{"id":14214557,"persistentId":"","filename":"transcripts_localview_part3.tar","contentType":"application/x-tar","friendlyType":"TAR Archive","filesize":1021030400,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:1a07a1ade7c-cfe8ed60a675","rootDataFileId":-1,"md5":"d477d6be7693341054b77934cff1c101","checksum":{"type":"MD5","value":"d477d6be7693341054b77934cff1c101"},"tabularData":false,"creationDate":"2026-09-07","publicationDate":"2026-09-07","lastUpdateTime":"2026-09-07T04:23:11Z","fileAccessRequest":true}}]},{"id":746734,"datasetId":6889429,"datasetPersistentId":"doi:10.7910/DVN/NJTBEM","datasetType":"dataset","storageIdentifier":"s3://10.7910/DVN/NJTBEM","versionNumber":14,"internalVersionNumber":11,"versionMinorNumber":0,"versionState":"RELEASED","latestVersionPublishingState":"RELEASED","UNF":"UNF:6:3rGeZDgPBzA5D3fizkqrGw==","lastUpdateTime":"2026-08-31T04:31:26Z","releaseTime":"2026-08-31T04:31:26Z","createTime":"2026-08-31T04:28:32Z","publicationDate":"2023-01-13","citationDate":"2023-01-13","effectiveDatasetFileCountLimit":1000,"datasetFileUploadsAvailable":843,"license":{"name":"CC0 1.0","uri":"http://creativecommons.org/publicdomain/zero/1.0","iconUri":"https://licensebuttons.net/p/zero/1.0/88x31.png","rightsIdentifier":"CC0-1.0","rightsIdentifierScheme":"SPDX","schemeUri":"https://spdx.org/licenses/","languageCode":"en"},"fileAccessRequest":true,"metadataBlocks":{"citation":{"displayName":"Citation Metadata","name":"citation","fields":[{"typeName":"title","multiple":false,"typeClass":"primitive","value":"LocalView Public Meetings Database"},{"typeName":"author","multiple":true,"typeClass":"compound","value":[{"authorName":{"typeName":"authorName","multiple":false,"typeClass":"primitive","value":"Barari, Soubhik"},"authorAffiliation":{"typeName":"authorAffiliation","multiple":false,"typeClass":"primitive","value":"Harvard University"},"authorIdentifierScheme":{"typeName":"authorIdentifierScheme","multiple":false,"typeClass":"controlledVocabulary","value":"ORCID"},"authorIdentifier":{"typeName":"authorIdentifier","multiple":false,"typeClass":"primitive","value":"0000-0002-0126-7351"}},{"authorName":{"typeName":"authorName","multiple":false,"typeClass":"primitive","value":"Simko, Tyler"},"authorAffiliation":{"typeName":"authorAffiliation","multiple":false,"typeClass":"primitive","value":"https://ror.org/00jmfr291","expandedvalue":{"scheme":"http://www.grid.ac/ontology/","termName":"University of Michigan","@type":"https://schema.org/Organization"}},"authorIdentifierScheme":{"typeName":"authorIdentifierScheme","multiple":false,"typeClass":"controlledVocabulary","value":"ORCID"},"authorIdentifier":{"typeName":"authorIdentifier","multiple":false,"typeClass":"primitive","value":"0000-0001-9382-7346"}},{"authorName":{"typeName":"authorName","multiple":false,"typeClass":"primitive","value":"Reece, Mason"},"authorAffiliation":{"typeName":"authorAffiliation","multiple":false,"typeClass":"primitive","value":"https://ror.org/042nb2s44","expandedvalue":{"scheme":"http://www.grid.ac/ontology/","termName":"Massachusetts Institute of Technology","@type":"https://schema.org/Organization"}},"authorIdentifierScheme":{"typeName":"authorIdentifierScheme","multiple":false,"typeClass":"controlledVocabulary","value":"ORCID"},"authorIdentifier":{"typeName":"authorIdentifier","multiple":false,"typeClass":"primitive","value":"https://orcid.org/0009-0009-8761-2344","expandedvalue":{"personName":"Reece, Mason","@id":"https://orcid.org/0009-0009-8761-2344","scheme":"ORCID","@type":"https://schema.org/Person"}}}]},{"typeName":"datasetContact","multiple":true,"typeClass":"compound","value":[{"datasetContactName":{"typeName":"datasetContactName","multiple":false,"typeClass":"primitive","value":"Barari, Soubhik"},"datasetContactAffiliation":{"typeName":"datasetContactAffiliation","multiple":false,"typeClass":"primitive","value":"Harvard University"},"datasetContactEmail":{"typeName":"datasetContactEmail","multiple":false,"typeClass":"primitive","value":"sbarari@g.harvard.edu"}},{"datasetContactName":{"typeName":"datasetContactName","multiple":false,"typeClass":"primitive","value":"Simko, Tyler"},"datasetContactAffiliation":{"typeName":"datasetContactAffiliation","multiple":false,"typeClass":"primitive","value":"University of Michigan"},"datasetContactEmail":{"typeName":"datasetContactEmail","multiple":false,"typeClass":"primitive","value":"tsimko@umich.edu"}},{"datasetContactName":{"typeName":"datasetContactName","multiple":false,"typeClass":"primitive","value":"Reece, Mason"},"datasetContactAffiliation":{"typeName":"datasetContactAffiliation","multiple":false,"typeClass":"primitive","value":"Massachusetts Institute of Technology"},"datasetContactEmail":{"typeName":"datasetContactEmail","multiple":false,"typeClass":"primitive","value":"mpreece@mit.edu"}}]},{"typeName":"dsDescription","multiple":true,"typeClass":"compound","value":[{"dsDescriptionValue":{"typeName":"dsDescriptionValue","multiple":false,"typeClass":"primitive","value":"<h3>LocalView is a database co-created by <a href:\"mailto:sbarari@g.harvard.edu\">Soubhik Barari</a>, <a href=\"mailto:tsimko@umich.edu\">Tyler Simko</a>, and <a href=\"mailto:mpreece@mit.edu\">Mason Reece</a> to advance the study of local government in the United States.</h3><br>\n\nIt is the <i>largest existing dataset of local government public meetings</i>— the central policy-making process in American local government — as they are captured on video. <br><br>\n\nTo get started, select the file(s) that you'd like for your use case based on the year that the meeting took place. Note: we are no longer supporting file formats other than <code>.parquet</code> for space considerations. <br><br>\n\nFor potential use cases or further guidance on downloading the data in bulk, visit the companion website: <a href=\"https://www.localview.net\">localview.net</a>.\n\n<h1>Change Log</h1>\n\n<p>Scraping, parsing, identifying, and merging together meetings\ninvolves a large number of non-trivial decisions, many of which need to\nbe adjusted over time particularly as the YouTube API changes.</p>\n\n<p>As such, when such decisions notably deviate from process or the\noutputs documented in the <a href=\"https://soubhikbarari.com/writings/localview.pdf\">first version of\nthis database</a>, it will be logged here.</p>\n\n<div id=\"version-3.0-2026-05\" class=\"section level2\">\n  <h2>Version 3.0 (2026-05)</h2>\n\n  <ul>\n    <li>\n      Data updated until November 2025. Moving forward, data will be automatically updated to always be six months behind present.\n    </li>\n\n    <li>\n      Some new channels have been added. Please reach out to us via email if there are new local meeting channels not featured that we should include.\n    </li>\n\n    <li>\n      Codebook has been updated and simplified. ACS related columns have been removed.\n    </li>\n\n    <li>\n      Data format has been modified to separate transcripts from metadata\n      <ul>\n        <li>\n          First, download <code>meta_localview.parquet</code>, then filter to the channels and/or videos of interest.\n        </li>\n        <li>\n          Then, merge in transcripts as desired from <code>transcripts_localview_*.zip</code>. Transcript file names are identified as \"<code>channel_id</code>__<code>id</code>.txt.gz\".\n        </li>\n        <li>\n          The transcript files have been separated into two parts only because of Dataverse size constraints, otherwise they are identical.\n        </li>\n      </ul>\n    </li>\n  </ul>\n</div>\n\n<div id=\"version-2.0-2023-10\" class=\"section level2\">\n<h2>Version 2.0 (2023-10)</h2>\n<ul>\n<li>Data updated up until September 2023.\n<ul>\n<li>~10,000 new videos added, all belonging to existing channels in\ndatabase.</li>\n</ul></li>\n<li>Change in data format:\n<ul>\n<li><code>channelType</code> column changed to\n<code>channel_type</code>.</li>\n<li><code>ST_FIPS</code> correctly padded to be 7 characters (2 digit\nstate code + 5 digit place FIPS code).</li>\n<li>videos with no caption available from YouTube are explicitly marked\nas “<No caption available>” in <code>caption_text</code>.</li>\n<li><code>caption_text_cleaned</code> is actually consistently cleaned\n(previously stray timestamps/pause markers in some entries).</li>\n<li><code>acs_2018_*</code> columns now prefixed as\n<code>acs_18</code>.</li>\n<li>additional ACS variables now available for each place:\n<ul>\n<li><code>acs_18_median_gross_rent</code>: Median gross rent in FIPS\nplace.</li>\n<li><code>acs_18_median_hh_inc</code>: Median household income in FIPS\nplace.</li>\n<li><code>acs_18_median_age</code>: Median age in FIPS place.</li>\n<li><code>acs_18_amind</code>: American Indian population in FIPS\nplace.</li>\n<li><code>acs_18_asian</code>: Asian population in FIPS place.</li>\n<li><code>acs_18_nhapi</code>: Native Hawaiian or Pacific Islander\npopulation in FIPS place.</li>\n</ul></li>\n<li><code>census_2015_*</code> columns removed for redundancy.</li>\n<li>to avoid confusion and possible conflicts, <code>.json</code> and\n<code>.csv</code> file formats eliminated in favor of\n<code>.parquet</code> format.</li>\n<li>municipal voteshare (<code>_dem2pv</code>) variables have been\nremoved from the public use files for a number of reasons: (1) high\ndegree of missingness, (2) no columns estimates available, (3) potential\nsensitivity</li>\n</ul></li>\n<li>The matching process of videos to ST-FIPS and government types is as\nfollows:\n<ul>\n<li>videos are matched to channels’ previous ST-FIPS codes and/or\ngovernment types <em>if</em> there is an umambiguous match, otherwise a\n(1) series of regex matches with video title/description are used to\nattempt to match video to the government and (2) state/place names are\nextracted from each video’s title/description/caption and used to match\nto an ST-FIPS entity <em>if</em> an unambiguous match; only identified\nvideos are then uploaded to the database.</li>\n<li>to identify the date of the meeting that the video captures, we\nfirst try to extract the date from the title, otherwise we try to\nextract the date from the description, otherwise it is discarded.</li>\n</ul></li>\n</ul>\n</div>\n<div id=\"version-1.0-2023-02\" class=\"section level2\">\n<h2>Version 1.0 (2023-02)</h2>\n<p>See <a href=\"https://soubhikbarari.com/writings/localview.pdf\">publication</a>\nfor full details on methodology choices for the Version 1.0\ndatabase.</p>\n</div>\n</div>"}}]},{"typeName":"subject","multiple":true,"typeClass":"controlledVocabulary","value":["Social Sciences"]},{"typeName":"keyword","multiple":true,"typeClass":"compound","value":[{"keywordValue":{"typeName":"keywordValue","multiple":false,"typeClass":"primitive","value":"local politics"}},{"keywordValue":{"typeName":"keywordValue","multiple":false,"typeClass":"primitive","value":"political communication"}},{"keywordValue":{"typeName":"keywordValue","multiple":false,"typeClass":"primitive","value":"deliberative democracy"}}]},{"typeName":"depositor","multiple":false,"typeClass":"primitive","value":"Barari, Soubhik"},{"typeName":"dateOfDeposit","multiple":false,"typeClass":"primitive","value":"2023-01-13"},{"typeName":"software","multiple":true,"typeClass":"compound","value":[{"softwareVersion":{"typeName":"softwareVersion","multiple":false,"typeClass":"primitive","value":"2.0"}}]}]}},"files":[{"description":"Codebook describing different variables in the data + example code","label":"codebook.md","restricted":false,"version":1,"datasetVersionId":746734,"dataFile":{"id":14077924,"persistentId":"","filename":"codebook.md","contentType":"text/markdown","friendlyType":"Markdown Text","filesize":6387,"description":"Codebook describing different variables in the data + example code","storageIdentifier":"s3://dvn-cloud-iqss:19f66db7722-8cfca0a72b54","rootDataFileId":-1,"md5":"ebc5d2ed9f72f5921db2229ad5516fa3","checksum":{"type":"MD5","value":"ebc5d2ed9f72f5921db2229ad5516fa3"},"tabularData":false,"creationDate":"2026-07-15","publicationDate":"2026-07-21","lastUpdateTime":"2026-08-31T04:31:26Z","fileAccessRequest":true}},{"description":"","label":"meta_localview.parquet","restricted":false,"version":1,"datasetVersionId":746734,"dataFile":{"id":14194734,"persistentId":"","filename":"meta_localview.parquet","contentType":"application/octet-stream","friendlyType":"Unknown","filesize":35093177,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:1a056138241-46569e426b72","rootDataFileId":-1,"md5":"89e056db6129a11dd7adcf4644042228","checksum":{"type":"MD5","value":"89e056db6129a11dd7adcf4644042228"},"tabularData":false,"creationDate":"2026-08-31","publicationDate":"2026-08-31","lastUpdateTime":"2026-08-31T04:31:26Z","fileAccessRequest":true}},{"description":"","label":"transcripts_localview_part1.tar","restricted":false,"version":1,"datasetVersionId":746734,"dataFile":{"id":14194735,"persistentId":"","filename":"transcripts_localview_part1.tar","contentType":"application/x-tar","friendlyType":"TAR Archive","filesize":2136350720,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:1a05614281a-cd9999667dc0","rootDataFileId":-1,"md5":"9b9debf14b00c9be1e40dd4c4752ef1a","checksum":{"type":"MD5","value":"9b9debf14b00c9be1e40dd4c4752ef1a"},"tabularData":false,"creationDate":"2026-08-31","publicationDate":"2026-08-31","lastUpdateTime":"2026-08-31T04:31:26Z","fileAccessRequest":true}},{"description":"","label":"transcripts_localview_part2.tar","restricted":false,"version":1,"datasetVersionId":746734,"dataFile":{"id":14194736,"persistentId":"","filename":"transcripts_localview_part2.tar","contentType":"application/x-tar","friendlyType":"TAR Archive","filesize":2136412160,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:1a05615329e-efe4d4a43ba2","rootDataFileId":-1,"md5":"dfd9bd7f9e126c3006e01fcdf1819eac","checksum":{"type":"MD5","value":"dfd9bd7f9e126c3006e01fcdf1819eac"},"tabularData":false,"creationDate":"2026-08-31","publicationDate":"2026-08-31","lastUpdateTime":"2026-08-31T04:31:26Z","fileAccessRequest":true}},{"description":"","label":"transcripts_localview_part3.tar","restricted":false,"version":1,"datasetVersionId":746734,"dataFile":{"id":14194737,"persistentId":"","filename":"transcripts_localview_part3.tar","contentType":"application/x-tar","friendlyType":"TAR Archive","filesize":1002946560,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:1a05615eb7b-2156542cb981","rootDataFileId":-1,"md5":"900a8b43ca9a6d0bf6c3a7f5d39be562","checksum":{"type":"MD5","value":"900a8b43ca9a6d0bf6c3a7f5d39be562"},"tabularData":false,"creationDate":"2026-08-31","publicationDate":"2026-08-31","lastUpdateTime":"2026-08-31T04:31:26Z","fileAccessRequest":true}}]},{"id":745840,"datasetId":6889429,"datasetPersistentId":"doi:10.7910/DVN/NJTBEM","datasetType":"dataset","storageIdentifier":"s3://10.7910/DVN/NJTBEM","versionNumber":13,"internalVersionNumber":11,"versionMinorNumber":0,"versionState":"RELEASED","latestVersionPublishingState":"RELEASED","UNF":"UNF:6:3rGeZDgPBzA5D3fizkqrGw==","lastUpdateTime":"2026-08-24T04:03:09Z","releaseTime":"2026-08-24T04:03:09Z","createTime":"2026-08-24T03:59:59Z","publicationDate":"2023-01-13","citationDate":"2023-01-13","effectiveDatasetFileCountLimit":1000,"datasetFileUploadsAvailable":843,"license":{"name":"CC0 1.0","uri":"http://creativecommons.org/publicdomain/zero/1.0","iconUri":"https://licensebuttons.net/p/zero/1.0/88x31.png","rightsIdentifier":"CC0-1.0","rightsIdentifierScheme":"SPDX","schemeUri":"https://spdx.org/licenses/","languageCode":"en"},"fileAccessRequest":true,"metadataBlocks":{"citation":{"displayName":"Citation Metadata","name":"citation","fields":[{"typeName":"title","multiple":false,"typeClass":"primitive","value":"LocalView Public Meetings Database"},{"typeName":"author","multiple":true,"typeClass":"compound","value":[{"authorName":{"typeName":"authorName","multiple":false,"typeClass":"primitive","value":"Barari, Soubhik"},"authorAffiliation":{"typeName":"authorAffiliation","multiple":false,"typeClass":"primitive","value":"Harvard University"},"authorIdentifierScheme":{"typeName":"authorIdentifierScheme","multiple":false,"typeClass":"controlledVocabulary","value":"ORCID"},"authorIdentifier":{"typeName":"authorIdentifier","multiple":false,"typeClass":"primitive","value":"0000-0002-0126-7351"}},{"authorName":{"typeName":"authorName","multiple":false,"typeClass":"primitive","value":"Simko, Tyler"},"authorAffiliation":{"typeName":"authorAffiliation","multiple":false,"typeClass":"primitive","value":"https://ror.org/00jmfr291","expandedvalue":{"scheme":"http://www.grid.ac/ontology/","termName":"University of Michigan","@type":"https://schema.org/Organization"}},"authorIdentifierScheme":{"typeName":"authorIdentifierScheme","multiple":false,"typeClass":"controlledVocabulary","value":"ORCID"},"authorIdentifier":{"typeName":"authorIdentifier","multiple":false,"typeClass":"primitive","value":"0000-0001-9382-7346"}},{"authorName":{"typeName":"authorName","multiple":false,"typeClass":"primitive","value":"Reece, Mason"},"authorAffiliation":{"typeName":"authorAffiliation","multiple":false,"typeClass":"primitive","value":"https://ror.org/042nb2s44","expandedvalue":{"scheme":"http://www.grid.ac/ontology/","termName":"Massachusetts Institute of Technology","@type":"https://schema.org/Organization"}},"authorIdentifierScheme":{"typeName":"authorIdentifierScheme","multiple":false,"typeClass":"controlledVocabulary","value":"ORCID"},"authorIdentifier":{"typeName":"authorIdentifier","multiple":false,"typeClass":"primitive","value":"https://orcid.org/0009-0009-8761-2344","expandedvalue":{"personName":"Reece, Mason","@id":"https://orcid.org/0009-0009-8761-2344","scheme":"ORCID","@type":"https://schema.org/Person"}}}]},{"typeName":"datasetContact","multiple":true,"typeClass":"compound","value":[{"datasetContactName":{"typeName":"datasetContactName","multiple":false,"typeClass":"primitive","value":"Barari, Soubhik"},"datasetContactAffiliation":{"typeName":"datasetContactAffiliation","multiple":false,"typeClass":"primitive","value":"Harvard University"},"datasetContactEmail":{"typeName":"datasetContactEmail","multiple":false,"typeClass":"primitive","value":"sbarari@g.harvard.edu"}},{"datasetContactName":{"typeName":"datasetContactName","multiple":false,"typeClass":"primitive","value":"Simko, Tyler"},"datasetContactAffiliation":{"typeName":"datasetContactAffiliation","multiple":false,"typeClass":"primitive","value":"University of Michigan"},"datasetContactEmail":{"typeName":"datasetContactEmail","multiple":false,"typeClass":"primitive","value":"tsimko@umich.edu"}},{"datasetContactName":{"typeName":"datasetContactName","multiple":false,"typeClass":"primitive","value":"Reece, Mason"},"datasetContactAffiliation":{"typeName":"datasetContactAffiliation","multiple":false,"typeClass":"primitive","value":"Massachusetts Institute of Technology"},"datasetContactEmail":{"typeName":"datasetContactEmail","multiple":false,"typeClass":"primitive","value":"mpreece@mit.edu"}}]},{"typeName":"dsDescription","multiple":true,"typeClass":"compound","value":[{"dsDescriptionValue":{"typeName":"dsDescriptionValue","multiple":false,"typeClass":"primitive","value":"<h3>LocalView is a database co-created by <a href:\"mailto:sbarari@g.harvard.edu\">Soubhik Barari</a>, <a href=\"mailto:tsimko@umich.edu\">Tyler Simko</a>, and <a href=\"mailto:mpreece@mit.edu\">Mason Reece</a> to advance the study of local government in the United States.</h3><br>\n\nIt is the <i>largest existing dataset of local government public meetings</i>— the central policy-making process in American local government — as they are captured on video. <br><br>\n\nTo get started, select the file(s) that you'd like for your use case based on the year that the meeting took place. Note: we are no longer supporting file formats other than <code>.parquet</code> for space considerations. <br><br>\n\nFor potential use cases or further guidance on downloading the data in bulk, visit the companion website: <a href=\"https://www.localview.net\">localview.net</a>.\n\n<h1>Change Log</h1>\n\n<p>Scraping, parsing, identifying, and merging together meetings\ninvolves a large number of non-trivial decisions, many of which need to\nbe adjusted over time particularly as the YouTube API changes.</p>\n\n<p>As such, when such decisions notably deviate from process or the\noutputs documented in the <a href=\"https://soubhikbarari.com/writings/localview.pdf\">first version of\nthis database</a>, it will be logged here.</p>\n\n<div id=\"version-3.0-2026-05\" class=\"section level2\">\n  <h2>Version 3.0 (2026-05)</h2>\n\n  <ul>\n    <li>\n      Data updated until November 2025. Moving forward, data will be automatically updated to always be six months behind present.\n    </li>\n\n    <li>\n      Some new channels have been added. Please reach out to us via email if there are new local meeting channels not featured that we should include.\n    </li>\n\n    <li>\n      Codebook has been updated and simplified. ACS related columns have been removed.\n    </li>\n\n    <li>\n      Data format has been modified to separate transcripts from metadata\n      <ul>\n        <li>\n          First, download <code>meta_localview.parquet</code>, then filter to the channels and/or videos of interest.\n        </li>\n        <li>\n          Then, merge in transcripts as desired from <code>transcripts_localview_*.zip</code>. Transcript file names are identified as \"<code>channel_id</code>__<code>id</code>.txt.gz\".\n        </li>\n        <li>\n          The transcript files have been separated into two parts only because of Dataverse size constraints, otherwise they are identical.\n        </li>\n      </ul>\n    </li>\n  </ul>\n</div>\n\n<div id=\"version-2.0-2023-10\" class=\"section level2\">\n<h2>Version 2.0 (2023-10)</h2>\n<ul>\n<li>Data updated up until September 2023.\n<ul>\n<li>~10,000 new videos added, all belonging to existing channels in\ndatabase.</li>\n</ul></li>\n<li>Change in data format:\n<ul>\n<li><code>channelType</code> column changed to\n<code>channel_type</code>.</li>\n<li><code>ST_FIPS</code> correctly padded to be 7 characters (2 digit\nstate code + 5 digit place FIPS code).</li>\n<li>videos with no caption available from YouTube are explicitly marked\nas “<No caption available>” in <code>caption_text</code>.</li>\n<li><code>caption_text_cleaned</code> is actually consistently cleaned\n(previously stray timestamps/pause markers in some entries).</li>\n<li><code>acs_2018_*</code> columns now prefixed as\n<code>acs_18</code>.</li>\n<li>additional ACS variables now available for each place:\n<ul>\n<li><code>acs_18_median_gross_rent</code>: Median gross rent in FIPS\nplace.</li>\n<li><code>acs_18_median_hh_inc</code>: Median household income in FIPS\nplace.</li>\n<li><code>acs_18_median_age</code>: Median age in FIPS place.</li>\n<li><code>acs_18_amind</code>: American Indian population in FIPS\nplace.</li>\n<li><code>acs_18_asian</code>: Asian population in FIPS place.</li>\n<li><code>acs_18_nhapi</code>: Native Hawaiian or Pacific Islander\npopulation in FIPS place.</li>\n</ul></li>\n<li><code>census_2015_*</code> columns removed for redundancy.</li>\n<li>to avoid confusion and possible conflicts, <code>.json</code> and\n<code>.csv</code> file formats eliminated in favor of\n<code>.parquet</code> format.</li>\n<li>municipal voteshare (<code>_dem2pv</code>) variables have been\nremoved from the public use files for a number of reasons: (1) high\ndegree of missingness, (2) no columns estimates available, (3) potential\nsensitivity</li>\n</ul></li>\n<li>The matching process of videos to ST-FIPS and government types is as\nfollows:\n<ul>\n<li>videos are matched to channels’ previous ST-FIPS codes and/or\ngovernment types <em>if</em> there is an umambiguous match, otherwise a\n(1) series of regex matches with video title/description are used to\nattempt to match video to the government and (2) state/place names are\nextracted from each video’s title/description/caption and used to match\nto an ST-FIPS entity <em>if</em> an unambiguous match; only identified\nvideos are then uploaded to the database.</li>\n<li>to identify the date of the meeting that the video captures, we\nfirst try to extract the date from the title, otherwise we try to\nextract the date from the description, otherwise it is discarded.</li>\n</ul></li>\n</ul>\n</div>\n<div id=\"version-1.0-2023-02\" class=\"section level2\">\n<h2>Version 1.0 (2023-02)</h2>\n<p>See <a href=\"https://soubhikbarari.com/writings/localview.pdf\">publication</a>\nfor full details on methodology choices for the Version 1.0\ndatabase.</p>\n</div>\n</div>"}}]},{"typeName":"subject","multiple":true,"typeClass":"controlledVocabulary","value":["Social Sciences"]},{"typeName":"keyword","multiple":true,"typeClass":"compound","value":[{"keywordValue":{"typeName":"keywordValue","multiple":false,"typeClass":"primitive","value":"local politics"}},{"keywordValue":{"typeName":"keywordValue","multiple":false,"typeClass":"primitive","value":"political communication"}},{"keywordValue":{"typeName":"keywordValue","multiple":false,"typeClass":"primitive","value":"deliberative democracy"}}]},{"typeName":"depositor","multiple":false,"typeClass":"primitive","value":"Barari, Soubhik"},{"typeName":"dateOfDeposit","multiple":false,"typeClass":"primitive","value":"2023-01-13"},{"typeName":"software","multiple":true,"typeClass":"compound","value":[{"softwareVersion":{"typeName":"softwareVersion","multiple":false,"typeClass":"primitive","value":"2.0"}}]}]}},"files":[{"description":"Codebook describing different variables in the data + example code","label":"codebook.md","restricted":false,"version":1,"datasetVersionId":745840,"dataFile":{"id":14077924,"persistentId":"","filename":"codebook.md","contentType":"text/markdown","friendlyType":"Markdown Text","filesize":6387,"description":"Codebook describing different variables in the data + example code","storageIdentifier":"s3://dvn-cloud-iqss:19f66db7722-8cfca0a72b54","rootDataFileId":-1,"md5":"ebc5d2ed9f72f5921db2229ad5516fa3","checksum":{"type":"MD5","value":"ebc5d2ed9f72f5921db2229ad5516fa3"},"tabularData":false,"creationDate":"2026-07-15","publicationDate":"2026-07-21","lastUpdateTime":"2026-08-24T04:03:09Z","fileAccessRequest":true}},{"description":"","label":"meta_localview.parquet","restricted":false,"version":1,"datasetVersionId":745840,"dataFile":{"id":14164854,"persistentId":"","filename":"meta_localview.parquet","contentType":"application/octet-stream","friendlyType":"Unknown","filesize":35000857,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:1a031ecd9ed-171e79e8a149","rootDataFileId":-1,"md5":"89a0f81f53c7d28cabf06949d4e739af","checksum":{"type":"MD5","value":"89a0f81f53c7d28cabf06949d4e739af"},"tabularData":false,"creationDate":"2026-08-24","publicationDate":"2026-08-24","lastUpdateTime":"2026-08-24T04:03:09Z","fileAccessRequest":true}},{"description":"","label":"transcripts_localview_part1.tar","restricted":false,"version":1,"datasetVersionId":745840,"dataFile":{"id":14164856,"persistentId":"","filename":"transcripts_localview_part1.tar","contentType":"application/x-tar","friendlyType":"TAR Archive","filesize":2136504320,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:1a031ed800e-bf3e8c23ae7c","rootDataFileId":-1,"md5":"0e80c397f95680a3177bf2cbca7eb415","checksum":{"type":"MD5","value":"0e80c397f95680a3177bf2cbca7eb415"},"tabularData":false,"creationDate":"2026-08-24","publicationDate":"2026-08-24","lastUpdateTime":"2026-08-24T04:03:09Z","fileAccessRequest":true}},{"description":"","label":"transcripts_localview_part2.tar","restricted":false,"version":1,"datasetVersionId":745840,"dataFile":{"id":14164857,"persistentId":"","filename":"transcripts_localview_part2.tar","contentType":"application/x-tar","friendlyType":"TAR Archive","filesize":2136504320,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:1a031eea50d-b5cb21078bd7","rootDataFileId":-1,"md5":"03f2a4f59883e9ecdfd1c494a3122100","checksum":{"type":"MD5","value":"03f2a4f59883e9ecdfd1c494a3122100"},"tabularData":false,"creationDate":"2026-08-24","publicationDate":"2026-08-24","lastUpdateTime":"2026-08-24T04:03:09Z","fileAccessRequest":true}},{"description":"","label":"transcripts_localview_part3.tar","restricted":false,"version":1,"datasetVersionId":745840,"dataFile":{"id":14164858,"persistentId":"","filename":"transcripts_localview_part3.tar","contentType":"application/x-tar","friendlyType":"TAR Archive","filesize":984504320,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:1a031ef7c34-6bfb7031d9e4","rootDataFileId":-1,"md5":"50c3485867be5ff973274f27ec36e3e1","checksum":{"type":"MD5","value":"50c3485867be5ff973274f27ec36e3e1"},"tabularData":false,"creationDate":"2026-08-24","publicationDate":"2026-08-24","lastUpdateTime":"2026-08-24T04:03:09Z","fileAccessRequest":true}}]},{"id":744520,"datasetId":6889429,"datasetPersistentId":"doi:10.7910/DVN/NJTBEM","datasetType":"dataset","storageIdentifier":"s3://10.7910/DVN/NJTBEM","versionNumber":12,"internalVersionNumber":11,"versionMinorNumber":0,"versionState":"RELEASED","latestVersionPublishingState":"RELEASED","UNF":"UNF:6:3rGeZDgPBzA5D3fizkqrGw==","lastUpdateTime":"2026-08-10T03:53:34Z","releaseTime":"2026-08-10T03:53:34Z","createTime":"2026-08-10T03:49:55Z","publicationDate":"2023-01-13","citationDate":"2023-01-13","effectiveDatasetFileCountLimit":1000,"datasetFileUploadsAvailable":843,"license":{"name":"CC0 1.0","uri":"http://creativecommons.org/publicdomain/zero/1.0","iconUri":"https://licensebuttons.net/p/zero/1.0/88x31.png","rightsIdentifier":"CC0-1.0","rightsIdentifierScheme":"SPDX","schemeUri":"https://spdx.org/licenses/","languageCode":"en"},"fileAccessRequest":true,"metadataBlocks":{"citation":{"displayName":"Citation Metadata","name":"citation","fields":[{"typeName":"title","multiple":false,"typeClass":"primitive","value":"LocalView Public Meetings Database"},{"typeName":"author","multiple":true,"typeClass":"compound","value":[{"authorName":{"typeName":"authorName","multiple":false,"typeClass":"primitive","value":"Barari, Soubhik"},"authorAffiliation":{"typeName":"authorAffiliation","multiple":false,"typeClass":"primitive","value":"Harvard University"},"authorIdentifierScheme":{"typeName":"authorIdentifierScheme","multiple":false,"typeClass":"controlledVocabulary","value":"ORCID"},"authorIdentifier":{"typeName":"authorIdentifier","multiple":false,"typeClass":"primitive","value":"0000-0002-0126-7351"}},{"authorName":{"typeName":"authorName","multiple":false,"typeClass":"primitive","value":"Simko, Tyler"},"authorAffiliation":{"typeName":"authorAffiliation","multiple":false,"typeClass":"primitive","value":"https://ror.org/00jmfr291","expandedvalue":{"scheme":"http://www.grid.ac/ontology/","termName":"University of Michigan","@type":"https://schema.org/Organization"}},"authorIdentifierScheme":{"typeName":"authorIdentifierScheme","multiple":false,"typeClass":"controlledVocabulary","value":"ORCID"},"authorIdentifier":{"typeName":"authorIdentifier","multiple":false,"typeClass":"primitive","value":"0000-0001-9382-7346"}},{"authorName":{"typeName":"authorName","multiple":false,"typeClass":"primitive","value":"Reece, Mason"},"authorAffiliation":{"typeName":"authorAffiliation","multiple":false,"typeClass":"primitive","value":"https://ror.org/042nb2s44","expandedvalue":{"scheme":"http://www.grid.ac/ontology/","termName":"Massachusetts Institute of Technology","@type":"https://schema.org/Organization"}},"authorIdentifierScheme":{"typeName":"authorIdentifierScheme","multiple":false,"typeClass":"controlledVocabulary","value":"ORCID"},"authorIdentifier":{"typeName":"authorIdentifier","multiple":false,"typeClass":"primitive","value":"https://orcid.org/0009-0009-8761-2344","expandedvalue":{"personName":"Reece, Mason","@id":"https://orcid.org/0009-0009-8761-2344","scheme":"ORCID","@type":"https://schema.org/Person"}}}]},{"typeName":"datasetContact","multiple":true,"typeClass":"compound","value":[{"datasetContactName":{"typeName":"datasetContactName","multiple":false,"typeClass":"primitive","value":"Barari, Soubhik"},"datasetContactAffiliation":{"typeName":"datasetContactAffiliation","multiple":false,"typeClass":"primitive","value":"Harvard University"},"datasetContactEmail":{"typeName":"datasetContactEmail","multiple":false,"typeClass":"primitive","value":"sbarari@g.harvard.edu"}},{"datasetContactName":{"typeName":"datasetContactName","multiple":false,"typeClass":"primitive","value":"Simko, Tyler"},"datasetContactAffiliation":{"typeName":"datasetContactAffiliation","multiple":false,"typeClass":"primitive","value":"University of Michigan"},"datasetContactEmail":{"typeName":"datasetContactEmail","multiple":false,"typeClass":"primitive","value":"tsimko@umich.edu"}},{"datasetContactName":{"typeName":"datasetContactName","multiple":false,"typeClass":"primitive","value":"Reece, Mason"},"datasetContactAffiliation":{"typeName":"datasetContactAffiliation","multiple":false,"typeClass":"primitive","value":"Massachusetts Institute of Technology"},"datasetContactEmail":{"typeName":"datasetContactEmail","multiple":false,"typeClass":"primitive","value":"mpreece@mit.edu"}}]},{"typeName":"dsDescription","multiple":true,"typeClass":"compound","value":[{"dsDescriptionValue":{"typeName":"dsDescriptionValue","multiple":false,"typeClass":"primitive","value":"<h3>LocalView is a database co-created by <a href:\"mailto:sbarari@g.harvard.edu\">Soubhik Barari</a>, <a href=\"mailto:tsimko@umich.edu\">Tyler Simko</a>, and <a href=\"mailto:mpreece@mit.edu\">Mason Reece</a> to advance the study of local government in the United States.</h3><br>\n\nIt is the <i>largest existing dataset of local government public meetings</i>— the central policy-making process in American local government — as they are captured on video. <br><br>\n\nTo get started, select the file(s) that you'd like for your use case based on the year that the meeting took place. Note: we are no longer supporting file formats other than <code>.parquet</code> for space considerations. <br><br>\n\nFor potential use cases or further guidance on downloading the data in bulk, visit the companion website: <a href=\"https://www.localview.net\">localview.net</a>.\n\n<h1>Change Log</h1>\n\n<p>Scraping, parsing, identifying, and merging together meetings\ninvolves a large number of non-trivial decisions, many of which need to\nbe adjusted over time particularly as the YouTube API changes.</p>\n\n<p>As such, when such decisions notably deviate from process or the\noutputs documented in the <a href=\"https://soubhikbarari.com/writings/localview.pdf\">first version of\nthis database</a>, it will be logged here.</p>\n\n<div id=\"version-3.0-2026-05\" class=\"section level2\">\n  <h2>Version 3.0 (2026-05)</h2>\n\n  <ul>\n    <li>\n      Data updated until November 2025. Moving forward, data will be automatically updated to always be six months behind present.\n    </li>\n\n    <li>\n      Some new channels have been added. Please reach out to us via email if there are new local meeting channels not featured that we should include.\n    </li>\n\n    <li>\n      Codebook has been updated and simplified. ACS related columns have been removed.\n    </li>\n\n    <li>\n      Data format has been modified to separate transcripts from metadata\n      <ul>\n        <li>\n          First, download <code>meta_localview.parquet</code>, then filter to the channels and/or videos of interest.\n        </li>\n        <li>\n          Then, merge in transcripts as desired from <code>transcripts_localview_*.zip</code>. Transcript file names are identified as \"<code>channel_id</code>__<code>id</code>.txt.gz\".\n        </li>\n        <li>\n          The transcript files have been separated into two parts only because of Dataverse size constraints, otherwise they are identical.\n        </li>\n      </ul>\n    </li>\n  </ul>\n</div>\n\n<div id=\"version-2.0-2023-10\" class=\"section level2\">\n<h2>Version 2.0 (2023-10)</h2>\n<ul>\n<li>Data updated up until September 2023.\n<ul>\n<li>~10,000 new videos added, all belonging to existing channels in\ndatabase.</li>\n</ul></li>\n<li>Change in data format:\n<ul>\n<li><code>channelType</code> column changed to\n<code>channel_type</code>.</li>\n<li><code>ST_FIPS</code> correctly padded to be 7 characters (2 digit\nstate code + 5 digit place FIPS code).</li>\n<li>videos with no caption available from YouTube are explicitly marked\nas “<No caption available>” in <code>caption_text</code>.</li>\n<li><code>caption_text_cleaned</code> is actually consistently cleaned\n(previously stray timestamps/pause markers in some entries).</li>\n<li><code>acs_2018_*</code> columns now prefixed as\n<code>acs_18</code>.</li>\n<li>additional ACS variables now available for each place:\n<ul>\n<li><code>acs_18_median_gross_rent</code>: Median gross rent in FIPS\nplace.</li>\n<li><code>acs_18_median_hh_inc</code>: Median household income in FIPS\nplace.</li>\n<li><code>acs_18_median_age</code>: Median age in FIPS place.</li>\n<li><code>acs_18_amind</code>: American Indian population in FIPS\nplace.</li>\n<li><code>acs_18_asian</code>: Asian population in FIPS place.</li>\n<li><code>acs_18_nhapi</code>: Native Hawaiian or Pacific Islander\npopulation in FIPS place.</li>\n</ul></li>\n<li><code>census_2015_*</code> columns removed for redundancy.</li>\n<li>to avoid confusion and possible conflicts, <code>.json</code> and\n<code>.csv</code> file formats eliminated in favor of\n<code>.parquet</code> format.</li>\n<li>municipal voteshare (<code>_dem2pv</code>) variables have been\nremoved from the public use files for a number of reasons: (1) high\ndegree of missingness, (2) no columns estimates available, (3) potential\nsensitivity</li>\n</ul></li>\n<li>The matching process of videos to ST-FIPS and government types is as\nfollows:\n<ul>\n<li>videos are matched to channels’ previous ST-FIPS codes and/or\ngovernment types <em>if</em> there is an umambiguous match, otherwise a\n(1) series of regex matches with video title/description are used to\nattempt to match video to the government and (2) state/place names are\nextracted from each video’s title/description/caption and used to match\nto an ST-FIPS entity <em>if</em> an unambiguous match; only identified\nvideos are then uploaded to the database.</li>\n<li>to identify the date of the meeting that the video captures, we\nfirst try to extract the date from the title, otherwise we try to\nextract the date from the description, otherwise it is discarded.</li>\n</ul></li>\n</ul>\n</div>\n<div id=\"version-1.0-2023-02\" class=\"section level2\">\n<h2>Version 1.0 (2023-02)</h2>\n<p>See <a href=\"https://soubhikbarari.com/writings/localview.pdf\">publication</a>\nfor full details on methodology choices for the Version 1.0\ndatabase.</p>\n</div>\n</div>"}}]},{"typeName":"subject","multiple":true,"typeClass":"controlledVocabulary","value":["Social Sciences"]},{"typeName":"keyword","multiple":true,"typeClass":"compound","value":[{"keywordValue":{"typeName":"keywordValue","multiple":false,"typeClass":"primitive","value":"local politics"}},{"keywordValue":{"typeName":"keywordValue","multiple":false,"typeClass":"primitive","value":"political communication"}},{"keywordValue":{"typeName":"keywordValue","multiple":false,"typeClass":"primitive","value":"deliberative democracy"}}]},{"typeName":"depositor","multiple":false,"typeClass":"primitive","value":"Barari, Soubhik"},{"typeName":"dateOfDeposit","multiple":false,"typeClass":"primitive","value":"2023-01-13"},{"typeName":"software","multiple":true,"typeClass":"compound","value":[{"softwareVersion":{"typeName":"softwareVersion","multiple":false,"typeClass":"primitive","value":"2.0"}}]}]}},"files":[{"description":"Codebook describing different variables in the data + example code","label":"codebook.md","restricted":false,"version":1,"datasetVersionId":744520,"dataFile":{"id":14077924,"persistentId":"","filename":"codebook.md","contentType":"text/markdown","friendlyType":"Markdown Text","filesize":6387,"description":"Codebook describing different variables in the data + example code","storageIdentifier":"s3://dvn-cloud-iqss:19f66db7722-8cfca0a72b54","rootDataFileId":-1,"md5":"ebc5d2ed9f72f5921db2229ad5516fa3","checksum":{"type":"MD5","value":"ebc5d2ed9f72f5921db2229ad5516fa3"},"tabularData":false,"creationDate":"2026-07-15","publicationDate":"2026-07-21","lastUpdateTime":"2026-08-10T03:53:34Z","fileAccessRequest":true}},{"description":"","label":"meta_localview.parquet","restricted":false,"version":1,"datasetVersionId":744520,"dataFile":{"id":14129502,"persistentId":"","filename":"meta_localview.parquet","contentType":"application/octet-stream","friendlyType":"Unknown","filesize":34764587,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:19fe9caaf86-b4701f15be30","rootDataFileId":-1,"md5":"2871c584b4f5fbc33f667fa242239016","checksum":{"type":"MD5","value":"2871c584b4f5fbc33f667fa242239016"},"tabularData":false,"creationDate":"2026-08-09","publicationDate":"2026-08-09","lastUpdateTime":"2026-08-10T03:53:34Z","fileAccessRequest":true}},{"description":"","label":"transcripts_localview_part1.tar","restricted":false,"version":1,"datasetVersionId":744520,"dataFile":{"id":14129503,"persistentId":"","filename":"transcripts_localview_part1.tar","contentType":"application/x-tar","friendlyType":"TAR Archive","filesize":2136842240,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:19fe9cba017-dcdfe9158471","rootDataFileId":-1,"md5":"f4278879d46fee475cec26c1b6e8d40d","checksum":{"type":"MD5","value":"f4278879d46fee475cec26c1b6e8d40d"},"tabularData":false,"creationDate":"2026-08-09","publicationDate":"2026-08-09","lastUpdateTime":"2026-08-10T03:53:34Z","fileAccessRequest":true}},{"description":"","label":"transcripts_localview_part2.tar","restricted":false,"version":1,"datasetVersionId":744520,"dataFile":{"id":14129504,"persistentId":"","filename":"transcripts_localview_part2.tar","contentType":"application/x-tar","friendlyType":"TAR Archive","filesize":2136320000,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:19fe9ccf966-6c1296f6640a","rootDataFileId":-1,"md5":"3a744e1ed9358246f0466f59e003614c","checksum":{"type":"MD5","value":"3a744e1ed9358246f0466f59e003614c"},"tabularData":false,"creationDate":"2026-08-09","publicationDate":"2026-08-09","lastUpdateTime":"2026-08-10T03:53:34Z","fileAccessRequest":true}},{"description":"","label":"transcripts_localview_part3.tar","restricted":false,"version":1,"datasetVersionId":744520,"dataFile":{"id":14129505,"persistentId":"","filename":"transcripts_localview_part3.tar","contentType":"application/x-tar","friendlyType":"TAR Archive","filesize":952657920,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:19fe9cdb5c4-b821620f2d25","rootDataFileId":-1,"md5":"fd26bbc4d2cdcaa786faf24a57679cab","checksum":{"type":"MD5","value":"fd26bbc4d2cdcaa786faf24a57679cab"},"tabularData":false,"creationDate":"2026-08-09","publicationDate":"2026-08-09","lastUpdateTime":"2026-08-10T03:53:34Z","fileAccessRequest":true}}]},{"id":743899,"datasetId":6889429,"datasetPersistentId":"doi:10.7910/DVN/NJTBEM","datasetType":"dataset","storageIdentifier":"s3://10.7910/DVN/NJTBEM","versionNumber":11,"internalVersionNumber":11,"versionMinorNumber":0,"versionState":"RELEASED","latestVersionPublishingState":"RELEASED","UNF":"UNF:6:3rGeZDgPBzA5D3fizkqrGw==","lastUpdateTime":"2026-08-03T03:53:49Z","releaseTime":"2026-08-03T03:53:49Z","createTime":"2026-08-03T03:50:03Z","publicationDate":"2023-01-13","citationDate":"2023-01-13","effectiveDatasetFileCountLimit":1000,"datasetFileUploadsAvailable":843,"license":{"name":"CC0 1.0","uri":"http://creativecommons.org/publicdomain/zero/1.0","iconUri":"https://licensebuttons.net/p/zero/1.0/88x31.png","rightsIdentifier":"CC0-1.0","rightsIdentifierScheme":"SPDX","schemeUri":"https://spdx.org/licenses/","languageCode":"en"},"fileAccessRequest":true,"metadataBlocks":{"citation":{"displayName":"Citation Metadata","name":"citation","fields":[{"typeName":"title","multiple":false,"typeClass":"primitive","value":"LocalView Public Meetings Database"},{"typeName":"author","multiple":true,"typeClass":"compound","value":[{"authorName":{"typeName":"authorName","multiple":false,"typeClass":"primitive","value":"Barari, Soubhik"},"authorAffiliation":{"typeName":"authorAffiliation","multiple":false,"typeClass":"primitive","value":"Harvard University"},"authorIdentifierScheme":{"typeName":"authorIdentifierScheme","multiple":false,"typeClass":"controlledVocabulary","value":"ORCID"},"authorIdentifier":{"typeName":"authorIdentifier","multiple":false,"typeClass":"primitive","value":"0000-0002-0126-7351"}},{"authorName":{"typeName":"authorName","multiple":false,"typeClass":"primitive","value":"Simko, Tyler"},"authorAffiliation":{"typeName":"authorAffiliation","multiple":false,"typeClass":"primitive","value":"https://ror.org/00jmfr291","expandedvalue":{"scheme":"http://www.grid.ac/ontology/","termName":"University of Michigan","@type":"https://schema.org/Organization"}},"authorIdentifierScheme":{"typeName":"authorIdentifierScheme","multiple":false,"typeClass":"controlledVocabulary","value":"ORCID"},"authorIdentifier":{"typeName":"authorIdentifier","multiple":false,"typeClass":"primitive","value":"0000-0001-9382-7346"}},{"authorName":{"typeName":"authorName","multiple":false,"typeClass":"primitive","value":"Reece, Mason"},"authorAffiliation":{"typeName":"authorAffiliation","multiple":false,"typeClass":"primitive","value":"https://ror.org/042nb2s44","expandedvalue":{"scheme":"http://www.grid.ac/ontology/","termName":"Massachusetts Institute of Technology","@type":"https://schema.org/Organization"}},"authorIdentifierScheme":{"typeName":"authorIdentifierScheme","multiple":false,"typeClass":"controlledVocabulary","value":"ORCID"},"authorIdentifier":{"typeName":"authorIdentifier","multiple":false,"typeClass":"primitive","value":"https://orcid.org/0009-0009-8761-2344","expandedvalue":{"personName":"Reece, Mason","@id":"https://orcid.org/0009-0009-8761-2344","scheme":"ORCID","@type":"https://schema.org/Person"}}}]},{"typeName":"datasetContact","multiple":true,"typeClass":"compound","value":[{"datasetContactName":{"typeName":"datasetContactName","multiple":false,"typeClass":"primitive","value":"Barari, Soubhik"},"datasetContactAffiliation":{"typeName":"datasetContactAffiliation","multiple":false,"typeClass":"primitive","value":"Harvard University"},"datasetContactEmail":{"typeName":"datasetContactEmail","multiple":false,"typeClass":"primitive","value":"sbarari@g.harvard.edu"}},{"datasetContactName":{"typeName":"datasetContactName","multiple":false,"typeClass":"primitive","value":"Simko, Tyler"},"datasetContactAffiliation":{"typeName":"datasetContactAffiliation","multiple":false,"typeClass":"primitive","value":"University of Michigan"},"datasetContactEmail":{"typeName":"datasetContactEmail","multiple":false,"typeClass":"primitive","value":"tsimko@umich.edu"}},{"datasetContactName":{"typeName":"datasetContactName","multiple":false,"typeClass":"primitive","value":"Reece, Mason"},"datasetContactAffiliation":{"typeName":"datasetContactAffiliation","multiple":false,"typeClass":"primitive","value":"Massachusetts Institute of Technology"},"datasetContactEmail":{"typeName":"datasetContactEmail","multiple":false,"typeClass":"primitive","value":"mpreece@mit.edu"}}]},{"typeName":"dsDescription","multiple":true,"typeClass":"compound","value":[{"dsDescriptionValue":{"typeName":"dsDescriptionValue","multiple":false,"typeClass":"primitive","value":"<h3>LocalView is a database co-created by <a href:\"mailto:sbarari@g.harvard.edu\">Soubhik Barari</a>, <a href=\"mailto:tsimko@umich.edu\">Tyler Simko</a>, and <a href=\"mailto:mpreece@mit.edu\">Mason Reece</a> to advance the study of local government in the United States.</h3><br>\n\nIt is the <i>largest existing dataset of local government public meetings</i>— the central policy-making process in American local government — as they are captured on video. <br><br>\n\nTo get started, select the file(s) that you'd like for your use case based on the year that the meeting took place. Note: we are no longer supporting file formats other than <code>.parquet</code> for space considerations. <br><br>\n\nFor potential use cases or further guidance on downloading the data in bulk, visit the companion website: <a href=\"https://www.localview.net\">localview.net</a>.\n\n<h1>Change Log</h1>\n\n<p>Scraping, parsing, identifying, and merging together meetings\ninvolves a large number of non-trivial decisions, many of which need to\nbe adjusted over time particularly as the YouTube API changes.</p>\n\n<p>As such, when such decisions notably deviate from process or the\noutputs documented in the <a href=\"https://soubhikbarari.com/writings/localview.pdf\">first version of\nthis database</a>, it will be logged here.</p>\n\n<div id=\"version-3.0-2026-05\" class=\"section level2\">\n  <h2>Version 3.0 (2026-05)</h2>\n\n  <ul>\n    <li>\n      Data updated until November 2025. Moving forward, data will be automatically updated to always be six months behind present.\n    </li>\n\n    <li>\n      Some new channels have been added. Please reach out to us via email if there are new local meeting channels not featured that we should include.\n    </li>\n\n    <li>\n      Codebook has been updated and simplified. ACS related columns have been removed.\n    </li>\n\n    <li>\n      Data format has been modified to separate transcripts from metadata\n      <ul>\n        <li>\n          First, download <code>meta_localview.parquet</code>, then filter to the channels and/or videos of interest.\n        </li>\n        <li>\n          Then, merge in transcripts as desired from <code>transcripts_localview_*.zip</code>. Transcript file names are identified as \"<code>channel_id</code>__<code>id</code>.txt.gz\".\n        </li>\n        <li>\n          The transcript files have been separated into two parts only because of Dataverse size constraints, otherwise they are identical.\n        </li>\n      </ul>\n    </li>\n  </ul>\n</div>\n\n<div id=\"version-2.0-2023-10\" class=\"section level2\">\n<h2>Version 2.0 (2023-10)</h2>\n<ul>\n<li>Data updated up until September 2023.\n<ul>\n<li>~10,000 new videos added, all belonging to existing channels in\ndatabase.</li>\n</ul></li>\n<li>Change in data format:\n<ul>\n<li><code>channelType</code> column changed to\n<code>channel_type</code>.</li>\n<li><code>ST_FIPS</code> correctly padded to be 7 characters (2 digit\nstate code + 5 digit place FIPS code).</li>\n<li>videos with no caption available from YouTube are explicitly marked\nas “<No caption available>” in <code>caption_text</code>.</li>\n<li><code>caption_text_cleaned</code> is actually consistently cleaned\n(previously stray timestamps/pause markers in some entries).</li>\n<li><code>acs_2018_*</code> columns now prefixed as\n<code>acs_18</code>.</li>\n<li>additional ACS variables now available for each place:\n<ul>\n<li><code>acs_18_median_gross_rent</code>: Median gross rent in FIPS\nplace.</li>\n<li><code>acs_18_median_hh_inc</code>: Median household income in FIPS\nplace.</li>\n<li><code>acs_18_median_age</code>: Median age in FIPS place.</li>\n<li><code>acs_18_amind</code>: American Indian population in FIPS\nplace.</li>\n<li><code>acs_18_asian</code>: Asian population in FIPS place.</li>\n<li><code>acs_18_nhapi</code>: Native Hawaiian or Pacific Islander\npopulation in FIPS place.</li>\n</ul></li>\n<li><code>census_2015_*</code> columns removed for redundancy.</li>\n<li>to avoid confusion and possible conflicts, <code>.json</code> and\n<code>.csv</code> file formats eliminated in favor of\n<code>.parquet</code> format.</li>\n<li>municipal voteshare (<code>_dem2pv</code>) variables have been\nremoved from the public use files for a number of reasons: (1) high\ndegree of missingness, (2) no columns estimates available, (3) potential\nsensitivity</li>\n</ul></li>\n<li>The matching process of videos to ST-FIPS and government types is as\nfollows:\n<ul>\n<li>videos are matched to channels’ previous ST-FIPS codes and/or\ngovernment types <em>if</em> there is an umambiguous match, otherwise a\n(1) series of regex matches with video title/description are used to\nattempt to match video to the government and (2) state/place names are\nextracted from each video’s title/description/caption and used to match\nto an ST-FIPS entity <em>if</em> an unambiguous match; only identified\nvideos are then uploaded to the database.</li>\n<li>to identify the date of the meeting that the video captures, we\nfirst try to extract the date from the title, otherwise we try to\nextract the date from the description, otherwise it is discarded.</li>\n</ul></li>\n</ul>\n</div>\n<div id=\"version-1.0-2023-02\" class=\"section level2\">\n<h2>Version 1.0 (2023-02)</h2>\n<p>See <a href=\"https://soubhikbarari.com/writings/localview.pdf\">publication</a>\nfor full details on methodology choices for the Version 1.0\ndatabase.</p>\n</div>\n</div>"}}]},{"typeName":"subject","multiple":true,"typeClass":"controlledVocabulary","value":["Social Sciences"]},{"typeName":"keyword","multiple":true,"typeClass":"compound","value":[{"keywordValue":{"typeName":"keywordValue","multiple":false,"typeClass":"primitive","value":"local politics"}},{"keywordValue":{"typeName":"keywordValue","multiple":false,"typeClass":"primitive","value":"political communication"}},{"keywordValue":{"typeName":"keywordValue","multiple":false,"typeClass":"primitive","value":"deliberative democracy"}}]},{"typeName":"depositor","multiple":false,"typeClass":"primitive","value":"Barari, Soubhik"},{"typeName":"dateOfDeposit","multiple":false,"typeClass":"primitive","value":"2023-01-13"},{"typeName":"software","multiple":true,"typeClass":"compound","value":[{"softwareVersion":{"typeName":"softwareVersion","multiple":false,"typeClass":"primitive","value":"2.0"}}]}]}},"files":[{"description":"Codebook describing different variables in the data + example code","label":"codebook.md","restricted":false,"version":1,"datasetVersionId":743899,"dataFile":{"id":14077924,"persistentId":"","filename":"codebook.md","contentType":"text/markdown","friendlyType":"Markdown Text","filesize":6387,"description":"Codebook describing different variables in the data + example code","storageIdentifier":"s3://dvn-cloud-iqss:19f66db7722-8cfca0a72b54","rootDataFileId":-1,"md5":"ebc5d2ed9f72f5921db2229ad5516fa3","checksum":{"type":"MD5","value":"ebc5d2ed9f72f5921db2229ad5516fa3"},"tabularData":false,"creationDate":"2026-07-15","publicationDate":"2026-07-21","lastUpdateTime":"2026-08-03T03:53:49Z","fileAccessRequest":true}},{"description":"","label":"meta_localview.parquet","restricted":false,"version":1,"datasetVersionId":743899,"dataFile":{"id":14117301,"persistentId":"","filename":"meta_localview.parquet","contentType":"application/octet-stream","friendlyType":"Unknown","filesize":34659964,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:19fc5be6728-046c04ce8c2b","rootDataFileId":-1,"md5":"babfdc8f005e2b02b534d56082e28b9c","checksum":{"type":"MD5","value":"babfdc8f005e2b02b534d56082e28b9c"},"tabularData":false,"creationDate":"2026-08-02","publicationDate":"2026-08-02","lastUpdateTime":"2026-08-03T03:53:49Z","fileAccessRequest":true}},{"description":"","label":"transcripts_localview_part1.tar","restricted":false,"version":1,"datasetVersionId":743899,"dataFile":{"id":14117302,"persistentId":"","filename":"transcripts_localview_part1.tar","contentType":"application/x-tar","friendlyType":"TAR Archive","filesize":2136852480,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:19fc5bf45fc-48ac5661f57c","rootDataFileId":-1,"md5":"010eda1635be13311f70622587bc322f","checksum":{"type":"MD5","value":"010eda1635be13311f70622587bc322f"},"tabularData":false,"creationDate":"2026-08-02","publicationDate":"2026-08-02","lastUpdateTime":"2026-08-03T03:53:49Z","fileAccessRequest":true}},{"description":"","label":"transcripts_localview_part2.tar","restricted":false,"version":1,"datasetVersionId":743899,"dataFile":{"id":14117303,"persistentId":"","filename":"transcripts_localview_part2.tar","contentType":"application/x-tar","friendlyType":"TAR Archive","filesize":2136145920,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:19fc5c09f8d-1f91e59a7ad7","rootDataFileId":-1,"md5":"5316e043c454b4b99a9e948462761c66","checksum":{"type":"MD5","value":"5316e043c454b4b99a9e948462761c66"},"tabularData":false,"creationDate":"2026-08-02","publicationDate":"2026-08-02","lastUpdateTime":"2026-08-03T03:53:49Z","fileAccessRequest":true}},{"description":"","label":"transcripts_localview_part3.tar","restricted":false,"version":1,"datasetVersionId":743899,"dataFile":{"id":14117304,"persistentId":"","filename":"transcripts_localview_part3.tar","contentType":"application/x-tar","friendlyType":"TAR Archive","filesize":938823680,"description":"","storageIdentifier":"s3://dvn-cloud-iqss:19fc5c16954-416373f77d80","rootDataFileId":-1,"md5":"9dd60bfefaff185be5ef724d7f7be9fe","checksum":{"type":"MD5","value":"9dd60bfefaff185be5ef724d7f7be9fe"},"tabularData":false,"creationDate":"2026-08-02","publicationDate":"2026-08-02","lastUpdateTime":"2026-08-03T03:53:49Z","fileAccessRequest":true}}]}]}