Data Dictionary (Variable Level)

Contains the data dictionary for the Library Bill Tracking repository.

3KB

LIS 546 Library Bills MAP - Variable Level.csv

Open

Field	Schema Mapping	Expected Value or Range	Definition	Required?	Repeatable?
bill_number	Legislation Identifier	string, free-text entry	The identifier assigned to the bill by the house of government in which it was proposed.	TRUE	FALSE
house_of_government	Legislation passedBy	string, controlled vocabulary	The house of government in which the bill was introduced; either Senate or House.	TRUE	FALSE
status_desc	DCMI Description	string, free-text entry	A description of the current status of the bill (e.g. introduced, passed, vetoed).	TRUE	FALSE
date_proposed	DCMI dateSubmitted	datetime	The date the bill was originally submitted to the house of government in which it was introduced.	TRUE	FALSE
title	DCMI Title	string, free-text entry	The title given to the bill by its sponsor(s).	TRUE	TRUE
description	DCMI Description	string, free-text entry	A description of the bill's content.	TRUE	TRUE
last_action_date	DCMI Date	datetime	The date of the most recent action taken on the bill.	FALSE	FALSE
last_action	DCMI Description	string, free-text entry	The most recent action taken on the bill by the state government in which it was proposed.	FALSE	FALSE
primary_sponsor_name	DCMI Creator	string	The name of the politician(s) who primarily sponsored the bill.	TRUE	TRUE
primary_sponsor_party	Legislation sourceOrganization	string, controlled vocabulary	The political party to which the bill's primary sponsor belongs; from the ICPSR subject thesaurus.	TRUE	TRUE
primary_sponsor_district	Legislation Jurisdiction	string, free-text entry	The legislative district which the bill's primary sponsor represents.	TRUE	TRUE
url	Legislation URL	string, URL	The URL from which the bill data was initially collected, if different from the bill's URL on its state government website.	FALSE	FALSE
state_link	Legislation URL	string, URL	The URL identifying the bill on the website of the state government by which it was introduced.	TRUE	FALSE

Field	Schema Mapping	Expected Value or Range	Definition	Required?	Repeatable?
date	Legislation dateVersion	datetime	The date of a particular action taken on the bill.	TRUE	TRUE
chamber	Legislation passedBy	string, controlled vocabulary	The house of government in which the relevant action on the bill took place, either Senate or House.	TRUE	TRUE
sequence	N/A	integer	The order in which actions on a given bill were taken.	TRUE	TRUE
action	DCMI Description	string, free-text entry	An action taken on the bill by the state government in which it was proposed.	TRUE	TRUE