Home

Filer ID: 1377834

Table: cvr_campaign_disclosure

filing_id		2042281		2011973		1981392		1981392		2011973		2060996		2045830		2081699		2045830		2096233		2171128		2154602		2126371		2207147		2270162		2392439		2337855		2479929		2439603		2549980		2602323		2670773		2637277		2723988		2720470		2720739		2685311		2741604
amend_id		0		0		1		0		1		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR
form_type		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F460
filer_id		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834
entity_cd		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP
filer_naml		Ryan LLC Political Action Committee (RyanPAC)		Ryan LLC Political Action Committee (RyanPAC)		Ryan LLC Political Action Committee (RyanPAC)		Ryan LLC Political Action Committee (RyanPAC)		Ryan LLC Political Action Committee (RyanPAC)		Ryan LLC Political Action Committee (RyanPAC)		Ryan LLC Political Action Committee (RyanPAC)		Ryan LLC Political Action Committee (RyanPAC)		Ryan LLC Political Action Committee (RyanPAC)		Ryan LLC Political Action Committee (RyanPAC)		Ryan LLC Political Action Committee (RyanPAC) Fed PAC - C00574921		Ryan LLC Political Action Committee (RyanPAC) Fed PAC - C00574921		Ryan LLC Political Action Committee (RyanPAC)		Ryan LLC Political Action Committee (RyanPAC) Fed PAC - C00574921		Ryan LLC Political Action Committee (RyanPAC) Fed PAC - C00574921		Ryan LLC Political Action Committee (RyanPAC) Fed PAC - C00574921		Ryan LLC Political Action Committee (RyanPAC) Fed PAC - C00574921		Ryan LLC Political Action Committee (RyanPAC) Fed PAC - C00574921		Ryan LLC Political Action Committee (RyanPAC) Fed PAC - C00574921		Ryan LLC Political Action Committee (RyanPAC) Fed PAC - C00574921		Ryan LLC Political Action Committee (RyanPAC) Fed PAC - C00574921		Ryan LLC Political Action Committee (RyanPAC) Fed PAC - C00574921		Ryan LLC Political Action Committee (RyanPAC) Fed PAC - C00574921		Ryan LLC Political Action Committee (RyanPAC) Fed PAC - C00574921		Ryan LLC Political Action Committee (RyanPAC) Fed PAC - C00574921		Ryan LLC Political Action Committee (RyanPAC) Fed PAC - C00574921		Ryan LLC Political Action Committee (RyanPAC) Fed PAC - C00574921		Ryan LLC Political Action Committee (RyanPAC) Fed PAC - C00574921
filer_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filer_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filer_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
report_num		000		000		001		000		001		000		000		000		001		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000
rpt_date		2016-05-12 00:00:00		2016-01-28 00:00:00		2015-07-16 00:00:00		2015-07-16 00:00:00		2016-01-28 00:00:00		2016-07-27 00:00:00		2016-05-23 00:00:00		2016-09-26 00:00:00		2016-05-23 00:00:00		2016-10-25 00:00:00		2017-07-19 00:00:00		2017-04-26 00:00:00		2017-01-23 00:00:00		2018-01-23 00:00:00		2018-07-17 00:00:00		2019-07-22 00:00:00		2019-01-10 00:00:00		2020-07-17 00:00:00		2020-01-24 00:00:00		2021-01-28 00:00:00		2021-07-27 00:00:00		2022-04-26 00:00:00		2022-01-25 00:00:00		2022-09-26 00:00:00		2022-07-26 00:00:00		2022-09-15 00:00:00		2022-05-23 00:00:00		2022-10-22 00:00:00
stmt_type		None		SA		SA		SA		SA		SA		PE		PE		PE		PE		SA		SY		SA		SA		SA		SA		SA		SA		SA		SA		SA		PE		SA		PE		SA		None		PE		PE
late_rptno		13432		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		29467		None		None
from_date		2016-05-12 00:00:00		2015-07-01 00:00:00		2015-01-01 00:00:00		2015-04-01 00:00:00		2015-07-01 00:00:00		2016-05-22 00:00:00		2016-01-01 00:00:00		2016-07-01 00:00:00		2016-01-01 00:00:00		2016-09-25 00:00:00		2017-04-01 00:00:00		2017-01-01 00:00:00		2016-10-23 00:00:00		2017-07-01 00:00:00		2018-01-01 00:00:00		2019-01-01 00:00:00		2018-07-01 00:00:00		2020-01-01 00:00:00		2019-07-01 00:00:00		2020-07-01 00:00:00		2021-01-01 00:00:00		2022-01-01 00:00:00		2021-07-01 00:00:00		2022-07-01 00:00:00		2022-05-22 00:00:00		2022-09-15 00:00:00		2022-04-24 00:00:00		2022-09-25 00:00:00
thru_date		2016-05-12 00:00:00		2015-12-31 00:00:00		2015-06-30 00:00:00		2015-06-30 00:00:00		2015-12-31 00:00:00		2016-06-30 00:00:00		2016-05-21 00:00:00		2016-09-24 00:00:00		2016-05-21 00:00:00		2016-10-22 00:00:00		2017-06-30 00:00:00		2017-03-31 00:00:00		2016-12-31 00:00:00		2017-12-31 00:00:00		2018-06-30 00:00:00		2019-06-30 00:00:00		2018-12-31 00:00:00		2020-06-30 00:00:00		2019-12-31 00:00:00		2020-12-31 00:00:00		2021-06-30 00:00:00		2022-04-23 00:00:00		2021-12-31 00:00:00		2022-09-24 00:00:00		2022-06-30 00:00:00		2022-09-15 00:00:00		2022-05-21 00:00:00		2022-10-22 00:00:00
elect_date		2016-05-12 00:00:00		None		None		None		None		2016-11-08 00:00:00		2016-06-07 00:00:00		2016-11-08 00:00:00		2016-06-07 00:00:00		2016-11-08 00:00:00		None		None		2016-11-08 00:00:00		None		None		None		None		None		None		2020-11-03 00:00:00		None		2022-06-07 00:00:00		None		2022-11-08 00:00:00		None		2022-09-15 00:00:00		2022-06-07 00:00:00		2022-11-08 00:00:00
filer_city		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas
filer_st		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX
filer_zip4		75240		75240		75240		75240		75240		75240		75240		75240		75240		75240		75240		75240		75240		75240		75240		75240		75240		75240		75240		75240		75240		75240		75240		75240		75240		75240		75240		75240
filer_phon		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022
filer_fax		972-725-0439		972-725-0439		972-725-0439		972-725-0439		972-725-0439		972-725-0439		972-725-0439		972-725-0439		972-725-0439		972-725-0439		972-725-0439		972-725-0439		972-725-0439		972-725-0439		972-725-0439		972-725-0439		972-725-0439		972-725-0439		972-725-0439		972-725-0439		972-725-0439		972-725-0439		972-725-0439		972-725-0439		972-725-0439		972-725-0439		972-725-0439		972-725-0439
file_email		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]
mail_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
mail_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
mail_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_naml		None		Lee Ridgely		Lee Ridgely		Lee Ridgely		Lee Ridgely		Lee Ridgely		Lee Ridgely		Lee Ridgely		Lee Ridgely		Lee Ridgely		Lee Ridgely		Lee Ridgely		Lee Ridgely		Lee Ridgely		Lee Ridgely		Lee Ridgely		Lee Ridgely		Lee Ridgely		Lee Ridgely		Lee Ridgely		Lee Ridgely		Lee Ridgely		Lee Ridgely		Lee Ridgely		Lee Ridgely		None		Lee Ridgely		Lee Ridgely
tres_namf		None		Gerald		Gerald		Gerald		Gerald		Gerald		Gerald		Gerald		Gerald		Gerald		Gerald		Gerald		Gerald		Gerald		Gerald		Gerald		Gerald		Gerald		Gerald		Gerald		Gerald		Gerald		Gerald		Gerald		Gerald		None		Gerald		Gerald
tres_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_nams		None		Jr		Jr		Jr		Jr		Jr		Jr		Jr		Jr		Jr		Jr		Jr		Jr		Jr		Jr		Jr		Jr		Jr		Jr		Jr		Jr		Jr		Jr		Jr		Jr		None		Jr		Jr
tres_city		None		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		None		Dallas		Dallas
tres_st		None		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		None		TX		TX
tres_zip4		None		75240		75240		75240		75240		75240		75240		75240		75240		75240		75240		75240		75240		75240		75240		75240		75240		75240		75240		75240		75240		75240		75240		75240		75240		None		75240		75240
tres_phon		None		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		972-934-0022		None		972-934-0022		972-934-0022
tres_fax		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_email		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]
cmtte_type		None		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		None		G		G
control_yn		None		N		N		N		N		N		N		N		N		N		N		N		N		N		N		N		N		N		N		N		N		N		N		N		N		None		N		N
sponsor_yn		None		N		N		N		N		N		N		N		N		N		N		N		N		N		N		N		N		N		N		N		N		N		N		N		N		None		N		N
primfrm_yn		None		N		N		N		N		N		N		N		N		N		N		N		N		N		N		N		N		N		N		N		N		N		N		N		N		None		N		N
brdbase_yn		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
amendexp_1		None		None		Beginning date of first report (semi-annual) was incorrect. Although the federal PAC began later and		None		Amended as a result of first Semi-Annual report January 1 through June 30, 2015 amended report.		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
amendexp_2		None		None		the original Calif. report was from April 1 through June 30, 2015; it needed to be from the beginni		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
amendexp_3		None		None		ng of the year January 1, 2015 per California Ethics Commission.		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rpt_att_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cmtte_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
reportname		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rptfromdt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rptthrudt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
emplbus_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bus_name		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bus_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bus_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bus_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bus_inter		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
busact_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
busactvity		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
assoc_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
assoc_int		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
other_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
other_int		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_phon		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_fax		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_email		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_name		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_num		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_juris		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
office_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
offic_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
dist_no		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
off_s_h_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sup_opp_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
employer		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
occupation		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
selfemp_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: filer_acronyms

acronym		RYANPAC
filer_id		1377834

Table: filer_address

filer_id		1377834
adrid		2362703
effect_dt		2015-06-08 00:00:00
add_type		7051
session_id		2015

Table: filer_filings

filer_id		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834
filing_id		1981392		1970423		1984280		2392439		2270162		2217449		2492048		2549980		2439603		2011973		2011973		1981392		2042281		1984280		2045830		2052091		2060996		2045830		2042113		2081699		2095027		2096233		2107830		2052091		2126371		2108659		2148734		2154602		2129936		2145650		2174204		2171128		2353331		2217194		2222911		2337855		2207147		2401762		2446769		2271677		2602323		2574974		2651007		2479929		2637277		2676392		2616886		2720470		2720739		2723988		2685311		2693499		2670773		2732988		2732992		2742737		2741604
period_id		222		None		None		237		233		None		None		243		239		223		223		221		226		None		225		None		226		225		None		227		None		227		None		None		228		None		None		229		None		None		None		230		None		None		None		235		231		None		None		None		245		None		None		241		247		None		None		250		251		251		250		None		249		None		None		None		251
form_id		F460		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F460		F460		F460		F460		F460		F460		F460
filing_sequence		0		0		0		0		0		0		0		0		0		1		0		1		0		1		0		0		0		1		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
filing_date		2015-07-31 00:00:00		2015-06-08 00:00:00		2015-07-31 00:00:00		2019-07-24 00:00:00		2018-07-26 00:00:00		2018-01-31 00:00:00		2020-07-28 00:00:00		2021-01-29 00:00:00		2020-01-30 00:00:00		2016-02-16 00:00:00		2016-02-01 00:00:00		2016-02-16 00:00:00		2016-05-12 00:00:00		2016-02-22 00:00:00		2016-05-25 00:00:00		2016-05-25 00:00:00		2016-07-29 00:00:00		2016-07-29 00:00:00		2016-02-22 00:00:00		2016-09-27 00:00:00		2016-09-28 00:00:00		2016-10-26 00:00:00		2016-08-01 00:00:00		2016-08-01 00:00:00		2017-01-30 00:00:00		2016-10-27 00:00:00		2017-03-23 00:00:00		2017-04-27 00:00:00		2017-01-24 00:00:00		2017-01-31 00:00:00		2017-07-26 00:00:00		2017-07-25 00:00:00		2019-01-23 00:00:00		2018-01-26 00:00:00		2017-04-28 00:00:00		2019-01-23 00:00:00		2018-01-29 00:00:00		2019-07-24 00:00:00		2020-01-30 00:00:00		2018-07-27 00:00:00		2021-08-02 00:00:00		2021-01-29 00:00:00		2022-01-26 00:00:00		2020-07-22 00:00:00		2022-01-25 00:00:00		2022-04-27 00:00:00		2021-07-29 00:00:00		2022-09-15 00:00:00		2022-09-16 00:00:00		2022-09-27 00:00:00		2022-05-24 00:00:00		2022-05-31 00:00:00		2022-04-26 00:00:00		2022-07-28 00:00:00		2022-07-28 00:00:00		2022-09-28 00:00:00		2022-10-26 00:00:00
stmnt_type		10001		10005		10005		10001		10001		10005		10005		10001		10001		10002		10001		10002		10001		10006		10001		10005		10001		10002		10005		10001		10005		10001		10005		10006		10001		10005		10006		10001		10006		10005		10005		10001		10005		10005		10005		10001		10001		10005		10005		10005		10001		10005		10005		10001		10001		10005		10005		10001		10001		10001		10001		10005		10001		10005		10005		10005		10001
stmnt_status		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11003		11001		11001		11001		11003		11003		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003
session_id		2015		2015		2015		2019		2017		2017		2019		2019		2019		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2017		2017		2015		2017		2017		2017		2017		2017		2017		2017		2019		2019		2017		2021		2021		2021		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		MDIGRAZIA		CPON		MDIGRAZIA		VUKSTINA		HSTOVALL		LBARTHOL		IMEDINA		AXIONG		SARRIAGA		CAFILER		CAFILER		CAFILER		PDEO		MPACHECO		DMCCASTL		SMCCONNAN		LLEONG		CAFILER		GCLARA		SARRIAGA		SARRIAGA		GPEREZ		LLEONG		MPACHECO		LPALMER		GPEREZ		LPALMER		HSTOVALL		TRAMON		HCOURSEY		LBARTHOL		LBARTHOL		CSAGABAEN		LPALMER		HSTOVALL		CSAGABAEN		LBARTHOL		VUKSTINA		SARRIAGA		HSTOVALL		DCODY		AXIONG		KRUSSELL		IMEDINA		KRUSSELL		CPON		DCODY		LPHEAV		CAFILER		CAFILER		LPHEAV		LPHEAV		CPON		JMAVES		JMAVES		LPHEAV		CAFILER
special_audit		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11001		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11001		11001		11003		11003		11003		11003		11003
rpt_start		2015-04-01 00:00:00		None		2015-04-01 00:00:00		2019-01-01 00:00:00		2018-01-01 00:00:00		2017-07-01 00:00:00		2020-01-01 00:00:00		2020-07-01 00:00:00		2019-07-01 00:00:00		2015-07-01 00:00:00		2015-07-01 00:00:00		2015-01-01 00:00:00		2016-05-12 00:00:00		2015-01-01 00:00:00		2016-01-01 00:00:00		2016-01-01 00:00:00		2016-05-22 00:00:00		2016-01-01 00:00:00		2015-07-01 00:00:00		2016-07-01 00:00:00		2016-07-01 00:00:00		2016-09-25 00:00:00		2016-05-22 00:00:00		2016-01-01 00:00:00		2016-10-23 00:00:00		2016-09-25 00:00:00		None		2017-01-01 00:00:00		None		2016-10-23 00:00:00		2017-04-01 00:00:00		2017-04-01 00:00:00		2018-07-01 00:00:00		2017-07-01 00:00:00		2017-01-01 00:00:00		2018-07-01 00:00:00		2017-07-01 00:00:00		2019-01-01 00:00:00		2019-07-01 00:00:00		2018-01-01 00:00:00		2021-01-01 00:00:00		2020-07-01 00:00:00		2021-07-01 00:00:00		2020-01-01 00:00:00		2021-07-01 00:00:00		2022-01-01 00:00:00		2021-01-01 00:00:00		2022-05-22 00:00:00		2022-09-15 00:00:00		2022-07-01 00:00:00		2022-04-24 00:00:00		2022-04-24 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-05-22 00:00:00		2022-07-01 00:00:00		2022-09-25 00:00:00
rpt_end		2015-06-30 00:00:00		None		2015-06-30 00:00:00		2019-06-30 00:00:00		2018-06-30 00:00:00		2017-12-31 00:00:00		2020-06-30 00:00:00		2020-12-31 00:00:00		2019-12-31 00:00:00		2015-12-31 00:00:00		2015-12-31 00:00:00		2015-06-30 00:00:00		2016-05-12 00:00:00		2015-06-30 00:00:00		2016-05-21 00:00:00		2016-05-21 00:00:00		2016-06-30 00:00:00		2016-05-21 00:00:00		2015-12-31 00:00:00		2016-09-24 00:00:00		2016-09-24 00:00:00		2016-10-22 00:00:00		2016-06-30 00:00:00		2016-05-21 00:00:00		2016-12-31 00:00:00		2016-10-22 00:00:00		None		2017-03-31 00:00:00		None		2016-12-31 00:00:00		2017-06-30 00:00:00		2017-06-30 00:00:00		2018-12-31 00:00:00		2017-12-31 00:00:00		2017-03-31 00:00:00		2018-12-31 00:00:00		2017-12-31 00:00:00		2019-06-30 00:00:00		2019-12-31 00:00:00		2018-06-30 00:00:00		2021-06-30 00:00:00		2020-12-31 00:00:00		2021-12-31 00:00:00		2020-06-30 00:00:00		2021-12-31 00:00:00		2022-04-23 00:00:00		2021-06-30 00:00:00		2022-06-30 00:00:00		2022-09-15 00:00:00		2022-09-24 00:00:00		2022-05-21 00:00:00		2022-05-21 00:00:00		2022-04-23 00:00:00		2022-04-23 00:00:00		2022-04-23 00:00:00		2022-09-24 00:00:00		2022-10-22 00:00:00
rpt_date		2015-07-16 00:00:00		None		None		2019-07-22 00:00:00		2018-07-17 00:00:00		None		None		2021-01-28 00:00:00		2020-01-24 00:00:00		2016-01-28 00:00:00		2016-01-28 00:00:00		2015-07-16 00:00:00		2016-05-12 00:00:00		None		2016-05-23 00:00:00		None		2016-07-27 00:00:00		2016-05-23 00:00:00		None		2016-09-26 00:00:00		None		2016-10-25 00:00:00		None		None		2017-01-23 00:00:00		None		None		2017-04-26 00:00:00		None		None		None		2017-07-19 00:00:00		None		None		None		2019-01-10 00:00:00		2018-01-23 00:00:00		None		None		None		2021-07-27 00:00:00		None		None		2020-07-17 00:00:00		2022-01-25 00:00:00		None		None		2022-07-26 00:00:00		2022-09-15 00:00:00		2022-09-26 00:00:00		2022-05-23 00:00:00		None		2022-04-26 00:00:00		None		None		None		2022-10-22 00:00:00
filing_type		22001		None		None		22001		22001		None		None		22001		22001		22001		22001		22001		22001		None		22001		None		22001		22001		None		22001		None		22001		None		None		22001		None		None		22001		None		None		None		22001		None		None		None		22001		22001		None		None		None		22001		None		None		22001		22001		None		None		22001		22001		22001		22001		None		22001		None		None		None		22001

Table: filer_to_filer_type

filer_id		1377834		1377834
filer_type		16		16
active		Y		Y
race		0		0
session_id		2015		2017
category		0		0
category_type		40502		40502
sub_category		40103		40103
effect_dt		2015-06-08 00:00:00		2017-01-24 00:00:00
sub_category_type		40208		40208
election_type		0		0
sub_category_a		None		None
nyq_dt		None		2015-04-01 00:00:00
party_cd		0		0
county_cd		18026		18026
district_cd		0		0

Table: filer_xref

filer_id		1377834
xref_id		1377834
effect_dt		2015-06-09 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1377834
filer_id		1377834
filer_type		RECIPIENT COMMITTEE
status		ACTIVE
effect_dt		2017-01-24 00:00:00
naml		RYAN LLC POLITICAL ACTION COMMITTEE (RYANPAC) FED PAC - C00574921
namf		None
namt		None
nams		None
adr1		None
adr2		None
city		DALLAS
st		TX
zip4		75240
phon		9729340022
fax		9727250439
email		[email protected]

Table: filers

filer_id		1377834

Table: received_filings

filer_id		1377834		1377834		1377834		1377834		1377834		1377834		1377834		1377834
filing_file_name		37102.cal		37248.cal		37498.cal		38785.cal		39187.cal		39926.cal		2042281_0.cal		2720739_0.cal
received_date		2017-03-20 00:00:00		2017-03-20 00:00:00		2017-03-20 00:00:00		2017-03-20 00:00:00		2017-03-20 00:00:00		2017-03-20 00:00:00		2016-05-12 00:00:00		2022-09-16 00:00:00
filing_directory		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		None		None		None		None		None		None		2042281		2720739
form_id		None		None		None		None		None		None		F497		F497
receive_comment		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted