lobbying: lobbying_activities: 47,816 rows where filing_year = 1999 sorted by filing

Individual lobbying activities reported in quarterly filings. Each row is one issue area for one client — includes the specific issues lobbied on, government entities contacted, and income/expense amounts.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

47,816 rows where filing_year = 1999 sorted by filing_year descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id	filing_uuid	filing_type	registrant_name	registrant_id	client_name	filing_year ▲	filing_period	issue_code	government_entities	income_amount	expense_amount	received_date
1	CHURCHILL GROUP 455edc06-55d1-41ed-878e-70a4040f953c	MM	CHURCHILL GROUP	9181	AMERICAN FAMILY BUSINESS INST	1999	mid_year	TAX	HOUSE OF REPRESENTATIVES,SENATE			1905-06-24T00:00:00-05:00
2	AMERICAN COTTON SHIPPERS ASSOCIATION 897fdada-c393-4de3-b506-9342a34c5073	YY	AMERICAN COTTON SHIPPERS ASSOCIATION	2070	AMERICAN COTTON SHIPPERS ASSOCIATION	1999	year_end	AGR	Agriculture, Dept of (USDA),Commodity Futures Trading Commission (CFTC),HOUSE OF REPRESENTATIVES,SENATE			1999-01-05T00:00:00-05:00
3	HOGAN LOVELLS US LLP 6cc9c1e4-c0bd-43a4-aea3-9d66201a59cd	M@Y	HOGAN LOVELLS US LLP	18422	INTERNET CONTENT COALITION	1999	mid_year					1999-01-05T00:00:00-05:00
4	RAY & CO, BRUCE 50e3e8b2-9976-4cab-bb14-f3a86135704f	YY	RAY & CO, BRUCE	32748	FAIRVIEW HEALTH SYSTEM	1999	year_end	DEF	Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,SENATE	20000		1999-01-05T00:00:00-05:00
5	MITCHELL COOPER 99b45f08-c763-4a75-8e9e-b6db554d47a4	YY	MITCHELL COOPER	10742	RUBBER AND PLASTIC FOOTWEAR MANUFACTURERS ASSOCIATION (RPFMA)	1999	year_end	TRD	Commerce, Dept of (DOC),SENATE,U.S. Trade Representative (USTR)	20000		1999-01-05T00:00:00-05:00
6	ALICIA DUGAN-SYKES 0240d802-06d5-4a92-90f5-221b52904a91	MAY	ALICIA DUGAN-SYKES	47757	EDISON ELECTRIC INSTITUTE	1999	mid_year					1999-01-05T00:00:00-05:00
7	BUILDING OWNERS AND MANAGERS ASSOCIATION INTERNATIONAL 106c2c6e-f0e1-46e3-9409-294e0bd27878	YY	BUILDING OWNERS AND MANAGERS ASSOCIATION INTERNATIONAL	7394	BUILDING OWNERS AND MANAGERS ASSOCIATION INTERNATIONAL	1999	year_end	RES	Energy, Dept of,Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Energy Regulatory Commission (FERC),HOUSE OF REPRESENTATIVES,SENATE		40000	1999-01-05T00:00:00-05:00
8	LONG, ROBERT MICHAEL f89c3a24-ff68-46c5-be4e-59e41962cb09	YTY	LONG, ROBERT MICHAEL	23122	SPRINT	1999	year_end					1999-01-10T00:00:00-05:00
9	THOMPSON AND NAUGHTON INC. ef0e2816-268a-4e3e-952e-9aeff8ce65df	YY	THOMPSON AND NAUGHTON INC.	38038	GENERAL MOTORS	1999	year_end	ENG	HOUSE OF REPRESENTATIVES,SENATE	40000		1999-01-10T00:00:00-05:00
10	BICKERSTAFF HEATH SMILEY POLLAN KEVER & MCDANIEL f7859dd9-113e-47e8-87bc-56765517d046	YY	BICKERSTAFF HEATH SMILEY POLLAN KEVER & MCDANIEL	47861	TEXAS COUNTY STORM WATER COALITION	1999	year_end	ENV				1999-01-10T00:00:00-05:00
11	THOMPSON AND NAUGHTON INC. 4a036cde-bfc7-4921-9bd0-299f9f1a2add	YY	THOMPSON AND NAUGHTON INC.	38038	PROCESS GAS CONSUMERS GROUP	1999	year_end	ENG	HOUSE OF REPRESENTATIVES,SENATE	20000		1999-01-10T00:00:00-05:00
12	APCO WORLDWIDE LLC b1dcdc66-f4d1-4a09-96d0-b315994a59b9	MA	APCO WORLDWIDE LLC	4117	GOLBORNE ENTERPRISES	1999	mid_year					1999-01-10T00:00:00-05:00
13	FINCH, WILLIAM J. fff29969-fdec-4125-809e-0d8d2d8e73fc	YY	FINCH, WILLIAM J.	14542	COOK GROUP	1999	year_end	MED	Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE			1999-01-10T00:00:00-05:00
14	THOMPSON AND NAUGHTON INC. f2b23337-3088-4a81-badd-405130271343	YY	THOMPSON AND NAUGHTON INC.	38038	BELLSOUTH CORP	1999	year_end	COM	HOUSE OF REPRESENTATIVES,SENATE	12000		1999-01-10T00:00:00-05:00
15	APCO WORLDWIDE LLC ba15ccfa-8854-498d-9db1-f245e095d17f	MA	APCO WORLDWIDE LLC	4117	COSCO AMERICAS INC (F/K/A COSCO NORTH AMERICA)	1999	mid_year					1999-01-10T00:00:00-05:00
16	CONGRESS OF NEUROLOGICAL SURGEONS dfc76bdc-7d7d-4673-85b6-fab625385e41	MM	CONGRESS OF NEUROLOGICAL SURGEONS	10445	CONGRESS OF NEUROLOGICAL SURGEONS	1999	mid_year	MMM	HOUSE OF REPRESENTATIVES,SENATE		40000	1999-01-10T00:00:00-05:00
17	CONGRESS OF NEUROLOGICAL SURGEONS dfc76bdc-7d7d-4673-85b6-fab625385e41	MM	CONGRESS OF NEUROLOGICAL SURGEONS	10445	CONGRESS OF NEUROLOGICAL SURGEONS	1999	mid_year	HCR	HOUSE OF REPRESENTATIVES,SENATE		40000	1999-01-10T00:00:00-05:00
18	CONGRESS OF NEUROLOGICAL SURGEONS dfc76bdc-7d7d-4673-85b6-fab625385e41	MM	CONGRESS OF NEUROLOGICAL SURGEONS	10445	CONGRESS OF NEUROLOGICAL SURGEONS	1999	mid_year	BUD	HOUSE OF REPRESENTATIVES,SENATE		40000	1999-01-10T00:00:00-05:00
19	CONGRESS OF NEUROLOGICAL SURGEONS dfc76bdc-7d7d-4673-85b6-fab625385e41	MM	CONGRESS OF NEUROLOGICAL SURGEONS	10445	CONGRESS OF NEUROLOGICAL SURGEONS	1999	mid_year	LBR	HOUSE OF REPRESENTATIVES,SENATE		40000	1999-01-10T00:00:00-05:00
20	CONGRESS OF NEUROLOGICAL SURGEONS dfc76bdc-7d7d-4673-85b6-fab625385e41	MM	CONGRESS OF NEUROLOGICAL SURGEONS	10445	CONGRESS OF NEUROLOGICAL SURGEONS	1999	mid_year	MED	HOUSE OF REPRESENTATIVES,SENATE		40000	1999-01-10T00:00:00-05:00
21	SULLIVAN & CROMWELL LLP 9f05779c-daa4-4927-a460-6f39707a5f66	MM	SULLIVAN & CROMWELL LLP	37232	SECURITIES INDUSTRY ASSOCIATION	1999	mid_year	TAX	HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of	120000		1999-01-10T00:00:00-05:00
22	APCO WORLDWIDE LLC 2bac6dac-8576-4999-8dfa-b34b1fa24dde	MA	APCO WORLDWIDE LLC	4117	ORCON CORP	1999	mid_year					1999-01-10T00:00:00-05:00
23	SYSTEM PLANNING CORP 0c064aae-3e12-48a6-8f0e-18d1157b0613	YY	SYSTEM PLANNING CORP	37562	CONEXOR	1999	year_end	ECN	HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS)			1999-01-10T00:00:00-05:00
24	APCO WORLDWIDE LLC 2d3aa007-751a-4422-8ae7-2ac3b8f0e4c9	MA	APCO WORLDWIDE LLC	4117	BANGLADESH GARMENT MANUFACTURERS & EXPORTERS ASSOC	1999	mid_year					1999-01-10T00:00:00-05:00
25	FRIEDLOB SANDERSON PAULSON & TOURTILLOTT,LLC 97f98772-9843-4b96-bd2c-87330d0a6b8a	MM	FRIEDLOB SANDERSON PAULSON & TOURTILLOTT,LLC	15508	CITY & COUNTY OF DENVER DENVER INTL AIRPORT	1999	mid_year	TRA	HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT)	80000		1999-01-10T00:00:00-05:00
26	LONG, ROBERT MICHAEL 99db1e88-4e95-4133-af7e-ddf8ba3a7b2a	YYY	LONG, ROBERT MICHAEL	23122	BROADWING COMMUNICATIONS INC	1999	year_end					1999-01-10T00:00:00-05:00
27	BICKERSTAFF HEATH SMILEY POLLAN KEVER & MCDANIEL 3b605825-4d1b-4ea3-847d-e45c06825333	YTY	BICKERSTAFF HEATH SMILEY POLLAN KEVER & MCDANIEL	47861	MONTGOMERY COUNTY HOSPITAL DIST	1999	year_end					1999-01-10T00:00:00-05:00
28	BICKERSTAFF HEATH SMILEY POLLAN KEVER & MCDANIEL b1929e76-35c9-46d6-900f-f421225c8897	YTY	BICKERSTAFF HEATH SMILEY POLLAN KEVER & MCDANIEL	47861	TARRANT COUNTY HOSPITAL DIST	1999	year_end					1999-01-10T00:00:00-05:00
29	DIAGEO NORTH AMERICA d58e6d69-0cc9-456e-9939-a0f2372ac076	MM	DIAGEO NORTH AMERICA	49830	DIAGEO NORTH AMERICA	1999	mid_year	TRD	Agriculture, Dept of (USDA),Bureau of Alcohol Tobacco Firearms & Explosives,Commerce, Dept of (DOC),Defense, Dept of (DOD),Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),Natl Institute on Alcohol Abuse & Alcoholism (NIAA),Office of Natl Drug Control Policy (NDCP),SENATE,State, Dept of (DOS),Substance Abuse & Mental Health Services Administration (SAMHSA),Treasury, Dept of,U.S. Customs & Border Protection,U.S. Trade Representative (USTR),White House Office		200000	1999-01-10T00:00:00-05:00
30	DIAGEO NORTH AMERICA d58e6d69-0cc9-456e-9939-a0f2372ac076	MM	DIAGEO NORTH AMERICA	49830	DIAGEO NORTH AMERICA	1999	mid_year	ALC	Agriculture, Dept of (USDA),Bureau of Alcohol Tobacco Firearms & Explosives,Commerce, Dept of (DOC),Defense, Dept of (DOD),Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),Natl Institute on Alcohol Abuse & Alcoholism (NIAA),Office of Natl Drug Control Policy (NDCP),SENATE,State, Dept of (DOS),Substance Abuse & Mental Health Services Administration (SAMHSA),Treasury, Dept of,U.S. Customs & Border Protection,U.S. Trade Representative (USTR),White House Office		200000	1999-01-10T00:00:00-05:00
31	DIAGEO NORTH AMERICA d58e6d69-0cc9-456e-9939-a0f2372ac076	MM	DIAGEO NORTH AMERICA	49830	DIAGEO NORTH AMERICA	1999	mid_year	CAW	Agriculture, Dept of (USDA),Bureau of Alcohol Tobacco Firearms & Explosives,Commerce, Dept of (DOC),Defense, Dept of (DOD),Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),Natl Institute on Alcohol Abuse & Alcoholism (NIAA),Office of Natl Drug Control Policy (NDCP),SENATE,State, Dept of (DOS),Substance Abuse & Mental Health Services Administration (SAMHSA),Treasury, Dept of,U.S. Customs & Border Protection,U.S. Trade Representative (USTR),White House Office		200000	1999-01-10T00:00:00-05:00
32	DIAGEO NORTH AMERICA d58e6d69-0cc9-456e-9939-a0f2372ac076	MM	DIAGEO NORTH AMERICA	49830	DIAGEO NORTH AMERICA	1999	mid_year	TAX	Agriculture, Dept of (USDA),Bureau of Alcohol Tobacco Firearms & Explosives,Commerce, Dept of (DOC),Defense, Dept of (DOD),Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),Natl Institute on Alcohol Abuse & Alcoholism (NIAA),Office of Natl Drug Control Policy (NDCP),SENATE,State, Dept of (DOS),Substance Abuse & Mental Health Services Administration (SAMHSA),Treasury, Dept of,U.S. Customs & Border Protection,U.S. Trade Representative (USTR),White House Office		200000	1999-01-10T00:00:00-05:00
33	SYSTEM PLANNING CORP 0b698bc4-d5c9-4cd4-aa18-1b3ca74c7d3b	YY	SYSTEM PLANNING CORP	37562	HEBREW UNIV OF JERUSALEM	1999	year_end	SCI	HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS)			1999-01-10T00:00:00-05:00
34	THOMPSON AND NAUGHTON INC. f967fa50-3292-4bc8-a9c8-9c3f40f9fe7d	YY	THOMPSON AND NAUGHTON INC.	38038	ITRON	1999	year_end	COM	HOUSE OF REPRESENTATIVES,SENATE	40000		1999-01-10T00:00:00-05:00
35	BINGHAM MCCUTCHEN LLP a6454328-c954-4a99-b7cf-4deb686e1209	YA	BINGHAM MCCUTCHEN LLP	51560	FLEET BOSTON FINANCIAL CORP	1999	year_end	BAN	HOUSE OF REPRESENTATIVES,SENATE	40000		1999-01-10T00:00:00-05:00
36	BINGHAM MCCUTCHEN LLP a6454328-c954-4a99-b7cf-4deb686e1209	YA	BINGHAM MCCUTCHEN LLP	51560	FLEET BOSTON FINANCIAL CORP	1999	year_end	BNK	HOUSE OF REPRESENTATIVES,SENATE	40000		1999-01-10T00:00:00-05:00
37	HARRIS & ASSOC, WILLIAM D. fe6b4ee2-998c-4d85-acb1-d9d3ca5cf984	MM	HARRIS & ASSOC, WILLIAM D.	17614	GOVERNMENT DEVELOPMENT BANK OF PUERTO RICO	1999	mid_year	GOV	HOUSE OF REPRESENTATIVES,SENATE	40000		1999-01-10T00:00:00-05:00
38	TECO HOLDINGS INC., FORMERLY KNOWN AS TECO ENERGY, INC. 6baf49df-7ff0-4369-a274-3b41eaa685d0	YY	TECO HOLDINGS INC., FORMERLY KNOWN AS TECO ENERGY, INC.	37675	TECO HOLDINGS INC., FORMERLY KNOWN AS ENERGY, INC.	1999	year_end	ENV	HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS)		340000	1999-01-10T00:00:00-05:00
39	TECO HOLDINGS INC., FORMERLY KNOWN AS TECO ENERGY, INC. 6baf49df-7ff0-4369-a274-3b41eaa685d0	YY	TECO HOLDINGS INC., FORMERLY KNOWN AS TECO ENERGY, INC.	37675	TECO HOLDINGS INC., FORMERLY KNOWN AS ENERGY, INC.	1999	year_end	UTI	HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS)		340000	1999-01-10T00:00:00-05:00
40	TECO HOLDINGS INC., FORMERLY KNOWN AS TECO ENERGY, INC. 6baf49df-7ff0-4369-a274-3b41eaa685d0	YY	TECO HOLDINGS INC., FORMERLY KNOWN AS TECO ENERGY, INC.	37675	TECO HOLDINGS INC., FORMERLY KNOWN AS ENERGY, INC.	1999	year_end	TAX	HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS)		340000	1999-01-10T00:00:00-05:00
41	TECO HOLDINGS INC., FORMERLY KNOWN AS TECO ENERGY, INC. 6baf49df-7ff0-4369-a274-3b41eaa685d0	YY	TECO HOLDINGS INC., FORMERLY KNOWN AS TECO ENERGY, INC.	37675	TECO HOLDINGS INC., FORMERLY KNOWN AS ENERGY, INC.	1999	year_end	HCR	HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS)		340000	1999-01-10T00:00:00-05:00
42	TECO HOLDINGS INC., FORMERLY KNOWN AS TECO ENERGY, INC. 6baf49df-7ff0-4369-a274-3b41eaa685d0	YY	TECO HOLDINGS INC., FORMERLY KNOWN AS TECO ENERGY, INC.	37675	TECO HOLDINGS INC., FORMERLY KNOWN AS ENERGY, INC.	1999	year_end	MAR	HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS)		340000	1999-01-10T00:00:00-05:00
43	ROGERS & WELLS be3a7c8a-3108-43af-b261-dd4528a51804	YT	ROGERS & WELLS	33603	PARIBAS (NY BRANCH)	1999	year_end	BAN	HOUSE OF REPRESENTATIVES,SENATE			1999-01-10T00:00:00-05:00
44	AMERICAN ASSOCIATION OF NEUROLOGICAL SURGEONS 31f070e4-ca07-4532-a05b-7b872511407b	MM	AMERICAN ASSOCIATION OF NEUROLOGICAL SURGEONS	1648	AMERICAN ASSOCIATION OF NEUROLOGICAL SURGEONS	1999	mid_year	HCR	HOUSE OF REPRESENTATIVES,SENATE		40000	1999-01-10T00:00:00-05:00
45	AMERICAN ASSOCIATION OF NEUROLOGICAL SURGEONS 31f070e4-ca07-4532-a05b-7b872511407b	MM	AMERICAN ASSOCIATION OF NEUROLOGICAL SURGEONS	1648	AMERICAN ASSOCIATION OF NEUROLOGICAL SURGEONS	1999	mid_year	MMM	HOUSE OF REPRESENTATIVES,SENATE		40000	1999-01-10T00:00:00-05:00
46	AMERICAN ASSOCIATION OF NEUROLOGICAL SURGEONS 31f070e4-ca07-4532-a05b-7b872511407b	MM	AMERICAN ASSOCIATION OF NEUROLOGICAL SURGEONS	1648	AMERICAN ASSOCIATION OF NEUROLOGICAL SURGEONS	1999	mid_year	BUD	HOUSE OF REPRESENTATIVES,SENATE		40000	1999-01-10T00:00:00-05:00
47	AMERICAN ASSOCIATION OF NEUROLOGICAL SURGEONS 31f070e4-ca07-4532-a05b-7b872511407b	MM	AMERICAN ASSOCIATION OF NEUROLOGICAL SURGEONS	1648	AMERICAN ASSOCIATION OF NEUROLOGICAL SURGEONS	1999	mid_year	LBR	HOUSE OF REPRESENTATIVES,SENATE		40000	1999-01-10T00:00:00-05:00
48	AMERICAN ASSOCIATION OF NEUROLOGICAL SURGEONS 31f070e4-ca07-4532-a05b-7b872511407b	MM	AMERICAN ASSOCIATION OF NEUROLOGICAL SURGEONS	1648	AMERICAN ASSOCIATION OF NEUROLOGICAL SURGEONS	1999	mid_year	MED	HOUSE OF REPRESENTATIVES,SENATE		40000	1999-01-10T00:00:00-05:00
49	MORSE CONSULTING e977c1a9-c2dc-479b-9762-79a2287d12ad	YY	MORSE CONSULTING	47074	FIRST DATA CORP	1999	year_end	BAN	HOUSE OF REPRESENTATIVES,SENATE	60000		1999-01-13T00:00:00-05:00
50	ENS RESOURCES, INC. 89c3d3a6-725e-4812-9b00-69a62275c56c	YY	ENS RESOURCES, INC.	13610	SACRAMENTO REGIONAL COUNTY SANITATION DISTRICT	1999	year_end	BUD	HOUSE OF REPRESENTATIVES,SENATE			1999-01-13T00:00:00-05:00
51	ENS RESOURCES, INC. d382587a-65fc-4f4a-b050-bdd2ad63d93c	YY	ENS RESOURCES, INC.	13610	SOUTH TAHOE PUBLIC UTILITY DISTRICT	1999	year_end	BUD	HOUSE OF REPRESENTATIVES,SENATE	20000		1999-01-13T00:00:00-05:00
52	ENS RESOURCES, INC. 205da590-4647-494e-aa26-0f5817e8b2fd	YY	ENS RESOURCES, INC.	13610	WATEREUSE ASSOCIATION	1999	year_end	BUD	HOUSE OF REPRESENTATIVES,SENATE	10000		1999-01-13T00:00:00-05:00
53	ENS RESOURCES, INC. 85bf5bcf-9416-4bf5-9d9a-6c090591d02d	YY	ENS RESOURCES, INC.	13610	EAST BAY MUNICIPAL UTILITY DISTRICT	1999	year_end	BUD	HOUSE OF REPRESENTATIVES,SENATE	20000		1999-01-13T00:00:00-05:00
54	ENS RESOURCES, INC. 85bf5bcf-9416-4bf5-9d9a-6c090591d02d	YY	ENS RESOURCES, INC.	13610	EAST BAY MUNICIPAL UTILITY DISTRICT	1999	year_end	ENV	HOUSE OF REPRESENTATIVES,SENATE	20000		1999-01-13T00:00:00-05:00
55	ENS RESOURCES, INC. 85bf5bcf-9416-4bf5-9d9a-6c090591d02d	YY	ENS RESOURCES, INC.	13610	EAST BAY MUNICIPAL UTILITY DISTRICT	1999	year_end	CAW	HOUSE OF REPRESENTATIVES,SENATE	20000		1999-01-13T00:00:00-05:00
56	ENS RESOURCES, INC. 9cc7e198-9534-4064-a02d-87591730e07e	YY	ENS RESOURCES, INC.	13610	CITY OF SACRAMENTO DEPARTMENT OF UTILITIES	1999	year_end	BUD	HOUSE OF REPRESENTATIVES,SENATE	10000		1999-01-13T00:00:00-05:00
57	MR. ROBERT BUCKLER 6172e52d-b223-484c-b159-612b2a04f107	YYY	MR. ROBERT BUCKLER	7348	UPM-KYMMENE INC	1999	year_end					1999-01-13T00:00:00-05:00
58	STRATACOMM LLC 26f7bf91-9709-4f80-b787-d85a383d23f5	YYY	STRATACOMM LLC	36925	AMERICAN COALITION FOR TRAFFIC SAFETY	1999	year_end					1999-01-13T00:00:00-05:00
59	ALLIANCE FOR CHILDREN AND FAMILIES c72f34b6-7742-4942-9b30-ca2abec4ccf8	YY	ALLIANCE FOR CHILDREN AND FAMILIES	47826	ALLIANCE FOR CHILDREN AND FAMILIES	1999	year_end	BUD	HOUSE OF REPRESENTATIVES,SENATE		20000	1999-01-13T00:00:00-05:00
60	ALLIANCE FOR CHILDREN AND FAMILIES c72f34b6-7742-4942-9b30-ca2abec4ccf8	YY	ALLIANCE FOR CHILDREN AND FAMILIES	47826	ALLIANCE FOR CHILDREN AND FAMILIES	1999	year_end	FAM	HOUSE OF REPRESENTATIVES,SENATE		20000	1999-01-13T00:00:00-05:00
61	ALLIANCE FOR CHILDREN AND FAMILIES c72f34b6-7742-4942-9b30-ca2abec4ccf8	YY	ALLIANCE FOR CHILDREN AND FAMILIES	47826	ALLIANCE FOR CHILDREN AND FAMILIES	1999	year_end	WEL	HOUSE OF REPRESENTATIVES,SENATE		20000	1999-01-13T00:00:00-05:00
62	ALLIANCE FOR CHILDREN AND FAMILIES c72f34b6-7742-4942-9b30-ca2abec4ccf8	YY	ALLIANCE FOR CHILDREN AND FAMILIES	47826	ALLIANCE FOR CHILDREN AND FAMILIES	1999	year_end	LAW	HOUSE OF REPRESENTATIVES,SENATE		20000	1999-01-13T00:00:00-05:00
63	ALLIANCE FOR CHILDREN AND FAMILIES c72f34b6-7742-4942-9b30-ca2abec4ccf8	YY	ALLIANCE FOR CHILDREN AND FAMILIES	47826	ALLIANCE FOR CHILDREN AND FAMILIES	1999	year_end	TAX	HOUSE OF REPRESENTATIVES,SENATE		20000	1999-01-13T00:00:00-05:00
64	ALLIANCE FOR CHILDREN AND FAMILIES c72f34b6-7742-4942-9b30-ca2abec4ccf8	YY	ALLIANCE FOR CHILDREN AND FAMILIES	47826	ALLIANCE FOR CHILDREN AND FAMILIES	1999	year_end	HCR	HOUSE OF REPRESENTATIVES,SENATE		20000	1999-01-13T00:00:00-05:00
65	ENS RESOURCES, INC. ab501fe5-0a39-40ec-9856-e20020487f99	YY	ENS RESOURCES, INC.	13610	WESTERN RESEARCH INSTITUTE	1999	year_end	BUD	Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE	10000		1999-01-13T00:00:00-05:00
66	ENS RESOURCES, INC. 3bc9a45f-b07e-47fd-88ac-68ffd2fd7192	YY	ENS RESOURCES, INC.	13610	CALIFORNIA ASSOCIATION OF SANITATION AGENCIES	1999	year_end	BUD	Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE	20000		1999-01-13T00:00:00-05:00
67	ENS RESOURCES, INC. 3bc9a45f-b07e-47fd-88ac-68ffd2fd7192	YY	ENS RESOURCES, INC.	13610	CALIFORNIA ASSOCIATION OF SANITATION AGENCIES	1999	year_end	ENV	Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE	20000		1999-01-13T00:00:00-05:00
68	ENS RESOURCES, INC. 3bc9a45f-b07e-47fd-88ac-68ffd2fd7192	YY	ENS RESOURCES, INC.	13610	CALIFORNIA ASSOCIATION OF SANITATION AGENCIES	1999	year_end	CAW	Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE	20000		1999-01-13T00:00:00-05:00
69	ENS RESOURCES, INC. 5d000056-eb64-462e-a8f8-62a57787aad5	YY	ENS RESOURCES, INC.	13610	COUNTY OF SACRAMENTO-PUBLIC WORKS AGENCY-TRANSPORTATION DIV	1999	year_end	BUD	HOUSE OF REPRESENTATIVES,SENATE	10000		1999-01-13T00:00:00-05:00
70	ENS RESOURCES, INC. 5d000056-eb64-462e-a8f8-62a57787aad5	YY	ENS RESOURCES, INC.	13610	COUNTY OF SACRAMENTO-PUBLIC WORKS AGENCY-TRANSPORTATION DIV	1999	year_end	NAT	HOUSE OF REPRESENTATIVES,SENATE	10000		1999-01-13T00:00:00-05:00
71	ENS RESOURCES, INC. 7f3a56d2-48f1-4156-9902-32d6f9bcc48d	YY	ENS RESOURCES, INC.	13610	COUNTY SANITATION DISTRICTS OF ORANGE COUNTY	1999	year_end	BUD	HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE	20000		1999-01-13T00:00:00-05:00
72	ENS RESOURCES, INC. 7f3a56d2-48f1-4156-9902-32d6f9bcc48d	YY	ENS RESOURCES, INC.	13610	COUNTY SANITATION DISTRICTS OF ORANGE COUNTY	1999	year_end	NAT	HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE	20000		1999-01-13T00:00:00-05:00
73	ENS RESOURCES, INC. c849c800-92fb-4788-8ec2-af260ea329b0	YY	ENS RESOURCES, INC.	13610	INFILCO DEGREMONT	1999	year_end	CAW	HOUSE OF REPRESENTATIVES,SENATE	10000		1999-01-13T00:00:00-05:00
74	THE LAXALT CORPORATION fea40e1a-26f9-4a25-9486-d88bcf062a89	MA	THE LAXALT CORPORATION	22314	ALLIANCE FOR AMERICAN INNOVATION	1999	mid_year	DEF	HOUSE OF REPRESENTATIVES	10000		1999-01-13T00:00:00-05:00
75	THE LAXALT CORPORATION fea40e1a-26f9-4a25-9486-d88bcf062a89	MA	THE LAXALT CORPORATION	22314	ALLIANCE FOR AMERICAN INNOVATION	1999	mid_year	CPT	HOUSE OF REPRESENTATIVES	10000		1999-01-13T00:00:00-05:00
76	STRATACOMM LLC 9b752cc8-afaf-47bb-8808-1f97c6d7d969	YYY	STRATACOMM LLC	36925	COALITION FOR VEHICLE CHOICE	1999	year_end					1999-01-13T00:00:00-05:00
77	MORSE CONSULTING 67f4fcf6-a0fd-48a1-a533-ce4a2f127b1c	YY	MORSE CONSULTING	47074	AXCESS FINANCIAL	1999	year_end	BAN	HOUSE OF REPRESENTATIVES			1999-01-13T00:00:00-05:00
78	MORSE CONSULTING ec083ee2-3082-4111-aa36-867c9a2ac93e	YY	MORSE CONSULTING	47074	KNICKERBOCKER MANAGEMENT	1999	year_end	BUD	HOUSE OF REPRESENTATIVES	10000		1999-01-13T00:00:00-05:00
79	STRATACOMM LLC 26f06bb4-e1d4-4677-aaa6-e8929338b04c	YYY	STRATACOMM LLC	36925	CONTINENTAL TEVES	1999	year_end					1999-01-13T00:00:00-05:00
80	STRATACOMM LLC 92112f29-e6c4-48e9-b666-88d2060a8b9a	YYY	STRATACOMM LLC	36925	WINE & SPIRITS WHOLESALERS OF AMERICA	1999	year_end					1999-01-13T00:00:00-05:00
81	BUSINESS EXECUTIVES FOR NATL SECURITY cc9cfdcd-a700-4427-ba6d-b3254eb0648e	YY	BUSINESS EXECUTIVES FOR NATL SECURITY	7521	BUSINESS EXECUTIVES FOR NATL SECURITY	1999	year_end	DEF	Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Natl Security Council (NSC),SENATE			1999-01-13T00:00:00-05:00
82	MORSE CONSULTING cf65d7c0-1355-4c1d-9b27-eb0c85842f3d	YY	MORSE CONSULTING	47074	HOUSEHOLD FINANCIAL GROUP	1999	year_end	BUD	HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE	60000		1999-01-13T00:00:00-05:00
83	MORSE CONSULTING cf65d7c0-1355-4c1d-9b27-eb0c85842f3d	YY	MORSE CONSULTING	47074	HOUSEHOLD FINANCIAL GROUP	1999	year_end	BNK	HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE	60000		1999-01-13T00:00:00-05:00
84	NEW JEWISH NARRATIVE (FKA AMERICANS FOR PEACE NOW) e2dc182d-6e2c-4a3c-a542-fb6ce0150c20	YY	NEW JEWISH NARRATIVE (FKA AMERICANS FOR PEACE NOW)	3798	NEW JEWISH NARRATIVE (FKA AMERICANS FOR PEACE NOW)	1999	year_end	FOR	HOUSE OF REPRESENTATIVES,Natl Security Council (NSC),SENATE,State, Dept of (DOS)		40000	1999-01-13T00:00:00-05:00
85	ENS RESOURCES, INC. 6397527d-2740-4e65-8295-2f21bc165a93	YY	ENS RESOURCES, INC.	13610	UNION SANITARY DISTRICT	1999	year_end	NAT	HOUSE OF REPRESENTATIVES,SENATE	10000		1999-01-13T00:00:00-05:00
86	ENS RESOURCES, INC. 6397527d-2740-4e65-8295-2f21bc165a93	YY	ENS RESOURCES, INC.	13610	UNION SANITARY DISTRICT	1999	year_end	BUD	HOUSE OF REPRESENTATIVES,SENATE	10000		1999-01-13T00:00:00-05:00
87	KIDSPEACE CORPORATION 9d3b5670-e16d-4fc6-a167-d9dd07b73f77	YY	KIDSPEACE CORPORATION	45471	KIDSPEACE CORPORATION	1999	year_end	BUD	Defense, Dept of (DOD),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,SENATE		98200	1999-01-14T00:00:00-05:00
88	THE ACCORD GROUP 3a954c05-a5f0-46a3-a346-4b3b7f42c148	MAY	THE ACCORD GROUP	42785	SAVE RAILBANKING COALITION	1999	mid_year					1999-01-14T00:00:00-05:00
89	WASHINGTON RESOURCE ASSOC 7094514b-440a-48cc-848b-a7df1363568b	MM	WASHINGTON RESOURCE ASSOC	48166	SABRE GROUP	1999	mid_year	TRA	HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT)			1999-01-25T00:00:00-05:00
90	WASHINGTON RESOURCE ASSOC 7094514b-440a-48cc-848b-a7df1363568b	MM	WASHINGTON RESOURCE ASSOC	48166	SABRE GROUP	1999	mid_year	LBR	HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT)			1999-01-25T00:00:00-05:00
91	LONG LAW FIRM 940b2536-ba24-41f8-b3cf-c3bacf567bf7	M@	LONG LAW FIRM	23111	AT&T	1999	mid_year					1999-01-27T00:00:00-05:00
92	LONG LAW FIRM 15eb71fa-6de9-463c-9093-4b2c62a2330d	M@	LONG LAW FIRM	23111	UNITED COS FINANCIAL CORP	1999	mid_year					1999-01-27T00:00:00-05:00
93	SULLIVAN ASSOC, RICHARD J. b66de90d-a476-40c8-9c29-5229673ea753	MTY	SULLIVAN ASSOC, RICHARD J.	37265	UNION PACIFIC	1999	mid_year					1999-02-02T00:00:00-05:00
94	THE ROYER LAW FIRM (FORMERLY ROYER & BROOKS) 7ed9506d-06e9-4c8e-bf76-cf614d7fa579	YY	THE ROYER LAW FIRM (FORMERLY ROYER & BROOKS)	33875	RENT-A-CENTER	1999	year_end	BAN	HOUSE OF REPRESENTATIVES,SENATE	40000		1999-02-07T00:00:00-05:00
95	THE ROYER LAW FIRM (FORMERLY ROYER & BROOKS) 144c611c-6937-48ac-9303-d85d3ab66cd6	YYY	THE ROYER LAW FIRM (FORMERLY ROYER & BROOKS)	33875	CONFERENCE OF STATE BANK SUPERVISORS	1999	year_end					1999-02-07T00:00:00-05:00
96	THE ROYER LAW FIRM (FORMERLY ROYER & BROOKS) 961ab94f-da9e-4042-85d4-cd00ccbd3da1	YY	THE ROYER LAW FIRM (FORMERLY ROYER & BROOKS)	33875	AMERICAN NAMES ASSN	1999	year_end	FIN	HOUSE OF REPRESENTATIVES,SENATE	40000		1999-02-07T00:00:00-05:00
97	IT GROUP, INC 87009120-fa9a-4bf6-b4a2-c4f0aa20845d	YY	IT GROUP, INC	20061	IT GROUP INC	1999	year_end	ENV	Army, Dept of (Corps of Engineers),Army, Dept of (Other),Defense, Dept of (DOD),Energy, Dept of,HOUSE OF REPRESENTATIVES,Navy, Dept of,SENATE	20000		1999-02-07T00:00:00-05:00
98	TERRY, JOHN H. eebce0a1-6412-4eea-8f53-5652d510ca65	YY	TERRY, JOHN H.	37824	NIAGARA MOHAWK POWER CORP	1999	year_end	UTI	HOUSE OF REPRESENTATIVES,SENATE	26080		1999-02-07T00:00:00-05:00
99	INTL COUNCIL OF CRUISE LINES 961c981e-d0bb-4a38-8287-955969d4878e	YY	INTL COUNCIL OF CRUISE LINES	19913	INTL COUNCIL OF CRUISE LINES	1999	year_end	TRA	Agriculture, Dept of (USDA),Bureau of Citizenship & Immigration Services (BCIS),Defense, Dept of (DOD),Government Accountability Office (GAO),Justice, Dept of (DOJ),Natl Institutes of Health (NIH),Panama Canal Commission,State, Dept of (DOS),Transportation, Dept of (DOT),U.S. Coast Guard (USCG)	279601		1999-02-07T00:00:00-05:00
100	INTL COUNCIL OF CRUISE LINES 961c981e-d0bb-4a38-8287-955969d4878e	YY	INTL COUNCIL OF CRUISE LINES	19913	INTL COUNCIL OF CRUISE LINES	1999	year_end	HCR	Agriculture, Dept of (USDA),Bureau of Citizenship & Immigration Services (BCIS),Defense, Dept of (DOD),Government Accountability Office (GAO),Justice, Dept of (DOJ),Natl Institutes of Health (NIH),Panama Canal Commission,State, Dept of (DOS),Transportation, Dept of (DOT),U.S. Coast Guard (USCG)	279601		1999-02-07T00:00:00-05:00

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE lobbying_activities (
            id INTEGER PRIMARY KEY,
            filing_uuid TEXT NOT NULL,
            filing_type TEXT NOT NULL,
            registrant_name TEXT NOT NULL,
            registrant_id INTEGER,
            client_name TEXT NOT NULL,
            filing_year INTEGER NOT NULL,
            filing_period TEXT NOT NULL,
            issue_code TEXT,
            specific_issues TEXT,
            government_entities TEXT,
            income_amount INTEGER,
            expense_amount INTEGER,
            is_no_activity INTEGER DEFAULT 0,
            is_termination INTEGER DEFAULT 0,
            received_date TEXT,
            CONSTRAINT fk_activity_filing FOREIGN KEY (filing_uuid)
                REFERENCES lobbying_filings_raw(filing_uuid)
        );
CREATE INDEX idx_act_client_name ON lobbying_activities(client_name COLLATE NOCASE);
CREATE INDEX idx_act_issue_code ON lobbying_activities(issue_code);
CREATE INDEX idx_act_filing_year ON lobbying_activities(filing_year);
CREATE INDEX idx_act_filing_uuid ON lobbying_activities(filing_uuid);