Lists

List view
Voter Registration and Quality Control
Organizing
Petitions and Quality Control
Admin
Phone Banking
 

Lists


 
This table displays information about lists of people created in Blocks
 

Field
Type
Description
Joins
id
primary key (int)
id of list
list_id in lists_people table
name
text
name of list
unique to table
search_params
jsonb
list of filters added to list
unique to table
created_at
timestamp
date&time list was created
unique to table
updated_at
timestamp
date&time list was last updated
unique to table
people_count
integer
count of people records on list
unique to table
refreshed_at
timestamp
date&time list was last refreshed
unique to table
list_folder_id
foreign key (int)
id of folder the list is stored in
id in list_folders table
user_id
foreign key (int)
id of user who created the list
id in users table
phones_count
integer
count of phone numbers on people records in list
unique to table
households_count
integer
count of unique households in list
unique to table
repopulation_status
text
idle/error
unique to table