house_cand_cont

31 rows where candidate contains "mcaleb" sorted by rowid

- remove filter - rowid district candidate affiliation contribution_amount contribution_date contributor city state zip employer occupation contributor_type contribution_type explanation

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- column - rowid district candidate affiliation contribution_amount contribution_date contributor city state zip employer occupation contributor_type contribution_type explanation

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

Sort... Sort by rowid Sort by district Sort by candidate Sort by affiliation Sort by contribution_amount Sort by contribution_date Sort by contributor Sort by city Sort by state Sort by zip Sort by employer Sort by occupation Sort by contributor_type Sort by contribution_type Sort by explanation

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: contribution_amount, contribution_date, contributor, city, state, zip, employer, occupation, contributor_type, explanation

Link	rowid ▼	district	candidate	affiliation	contribution_amount	contribution_date	contributor	city	state	zip	employer	occupation	contributor_type	contribution_type	explanation
2043	2043	House District 06	Mcaleb, William	Republican	50	6/25/20 0:00	Denny Yeung	Houston	TX	77079	Black & Veatch	Consultant	Individual	Monetary (Itemized)	Campaign Contribution
2044	2044	House District 06	Mcaleb, William	Republican	100	7/27/20 0:00	Judy Case	Denver	CO	80231	Retired	Homemaker	Individual	Monetary (Itemized)	Campaign Contribution
2045	2045	House District 06	Mcaleb, William	Republican	29.95	7/27/20 0:00	Barbara Fallon	Denver	CO	80224	Retired	Homemaker	Individual	Monetary (Itemized)	Campaign Contribution
2046	2046	House District 06	Mcaleb, William	Republican	20	7/27/20 0:00	Marisa Showalter	Denver	CO	80210	Homemaker	Homemaker	Individual	Monetary (Itemized)	Campaign Contribution
2047	2047	House District 06	Mcaleb, William	Republican	75	7/27/20 0:00	Gerald Bodine	Denver	CO	80209	Retired	General Business	Individual	Monetary (Itemized)	Campaign Contribution
2048	2048	House District 06	Mcaleb, William	Republican	100	7/27/20 0:00	Osborne Dykes	Denver	CO	80209	Retired	Attorney/Legal	Individual	Monetary (Itemized)	Campaign Contribution
2049	2049	House District 06	Mcaleb, William	Republican	100	7/28/20 0:00	Timothy Mchugh	Denver	CO	80210	Retired	General Business	Individual	Monetary (Itemized)	Campaign Contribution
2050	2050	House District 06	Mcaleb, William	Republican	20	7/28/20 0:00	Scott Peterson	Denver	CO	80210	Retired	General Business	Individual	Monetary (Itemized)	Campaign Contribution
2051	2051	House District 06	Mcaleb, William	Republican	100	8/11/20 0:00	Laurie Chahbandour	Denver	CO	80209	Self Employed Architect	General Business	Individual	Monetary (Itemized)	Campaign Contribution
2052	2052	House District 06	Mcaleb, William	Republican	400	8/11/20 0:00	Robert Lowdermilk	Denver	CO	80220	Retired	Retired	Individual	Monetary (Itemized)	Campaign Contribution - Max-Out
2053	2053	House District 06	Mcaleb, William	Republican	100	8/15/20 0:00	Rosina Kovar	Denver	CO	80220	Retired		Individual	Monetary (Itemized)	Campaign Contribution
2054	2054	House District 06	Mcaleb, William	Republican	400	8/17/20 0:00	David Brittain	Denver	CO	80220	Retired	Retired	Individual	Monetary (Itemized)	Campaign Contribution - Max-Out
2055	2055	House District 06	Mcaleb, William	Republican	250	9/3/20 0:00	Amy Naes	Devver	CO	80209	City Of Broomfield	Attorney/Legal	Individual	Monetary (Itemized)	Revv
2056	2056	House District 06	Mcaleb, William	Republican	400	9/3/20 0:00	Jennifer S Laird	Denver	CO	80210	Pharma Sales	Healthcare/Medical	Individual	Monetary (Itemized)	Check # 5929
2057	2057	House District 06	Mcaleb, William	Republican	100	9/3/20 0:00	Joan French	Denver	CO	80220	Retired	Retired	Individual	Monetary (Itemized)	Check #9653
2058	2058	House District 06	Mcaleb, William	Republican	100	9/3/20 0:00	Philip Quintana	Denver	CO	80209	Real Estate	Real Estate Professional	Individual	Monetary (Itemized)	Check # 778
2059	2059	House District 06	Mcaleb, William	Republican	50	9/3/20 0:00	Gerald Bodine	Denver	CO	80209	Retired	General Business	Individual	Monetary (Itemized)	Check #8701
2060	2060	House District 06	Mcaleb, William	Republican	50	9/3/20 0:00	Wendy Warner	Denver	CO	80209	Retired	Retired	Individual	Monetary (Itemized)	Check # 9810
2061	2061	House District 06	Mcaleb, William	Republican	100	9/3/20 0:00	Kim Mcaleb	Denver	CO	80210	Mortgage Banker	Financial/Investment	Individual	Monetary (Itemized)	Check # 3245
2062	2062	House District 06	Mcaleb, William	Republican	400	9/8/20 0:00	Valerie E Chandler	Denver	CO	90206	Retired	Retired	Individual	Monetary (Itemized)	Campaign Contribution
2063	2063	House District 06	Mcaleb, William	Republican	191.4	9/10/20 0:00	Jim Walter	Denver	CO	80207	President Roof Systems	Construction/Engineering	Individual	Monetary (Itemized)	Campaign Contribution
2064	2064	House District 06	Mcaleb, William	Republican	47.7	9/14/20 0:00	Julie Percy	Denver	CO	90220	Retired	Retired	Individual	Monetary (Itemized)	Campaign Contribution
2065	2065	House District 06	Mcaleb, William	Republican	20	9/16/20 0:00	William Miller	Denver	CO	80203	Slawson	Construction/Engineering	Individual	Monetary (Itemized)	Campaign Contribution
2066	2066	House District 06	Mcaleb, William	Republican	9.3	9/21/20 0:00	Michelle Cooper	Centennial	CO	80112	Retired	Retired	Individual	Monetary (Itemized)	Contribution On Revv
2067	2067	House District 06	Mcaleb, William	Republican	383.7	9/23/20 0:00	Michael Landa	Denver	CO	80209	Retired	Retired	Individual	Monetary (Itemized)	Contribution By Revv
2068	2068	House District 06	Mcaleb, William	Republican	47.7	9/30/20 0:00	Melissa Mcauley	Denver	CO	80206	Pharmd @ Healthcare	Healthcare/Medical	Individual	Monetary (Itemized)	Contribution On Revv
2069	2069	House District 06	Mcaleb, William	Republican	47.7	10/2/20 0:00	Reuben Drebenstedt	Denver	CO	80224	Pastor	Clergy/Faith-based	Individual	Monetary (Itemized)	Contribution On Revv
2070	2070	House District 06	Mcaleb, William	Republican	239.7	10/7/20 0:00	Gregg Siepman	Denver	CO	80209	Retired	Retired	Individual	Monetary (Itemized)	Campaign Contribution Revv
2071	2071	House District 06	Mcaleb, William	Republican	47.7	10/8/20 0:00	Ken Carson	Lakewood	CO	80120	Sales @ Xybix	Science/Technology	Individual	Monetary (Itemized)	Campaign Contribution Revv
2072	2072	House District 06	Mcaleb, William	Republican	4.5	10/9/20 0:00	Gayle Jones	Brighton	CO	80602	Retired	Retired	Individual	Monetary (Itemized)	Campaign Contribution Revv
2073	2073	House District 06	Mcaleb, William	Republican	400	10/14/20 0:00	Denver Rep Women Political Comm	Denver	CO	80237			Business	Monetary (Itemized)	Check 1010 Contribution

CREATE TABLE "house_cand_cont" (
	"district"	TEXT,
	"candidate"	TEXT,
	"affiliation"	TEXT,
	"contribution_amount"	INTEGER,
	"contribution_date"	TEXT,
	"contributor"	TEXT,
	"city"	TEXT,
	"state"	TEXT,
	"zip"	INTEGER,
	"employer"	TEXT,
	"occupation"	TEXT,
	"contributor_type"	TEXT,
	"contribution_type"	TEXT,
	"explanation"	TEXT
);