lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
142,736 rows where filing_year = 2013 sorted by filing_year descending
This data as json, CSV (advanced)
Suggested facets: is_termination, received_date (date)
| id | filing_uuid | filing_type | registrant_name | registrant_id | client_name | filing_year ▲ | filing_period | issue_code | specific_issues | government_entities | income_amount | expense_amount | is_no_activity | is_termination | received_date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1368176 | BALLARD SPAHR LLP 995503b0-d75e-4187-ae72-bc74e295769d | Q1Y | BALLARD SPAHR LLP | 400552654 | MONTGOMERY COUNTY, MARYLAND | 2013 | first_quarter | 0 | 0 | 2013-01-08T15:27:04.380000-05:00 | |||||
| 1368177 | THE TUGGEY GROUP, LLP F/K/A TUGGEY MCCUTCHEON, LLP 48e25110-6a59-46d3-a1cc-1c3b3d3848af | 1A | THE TUGGEY GROUP, LLP F/K/A TUGGEY MCCUTCHEON, LLP | 400758263 | SAN ANTONIO RIVER AUTHORITY | 2013 | first_quarter | ECN | Issues related to water development, environmental protection, financing of river basin improvements and appropriations. | Army, Dept of (Corps of Engineers),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE | 0 | 0 | 2013-01-15T15:39:50.237000-05:00 | ||
| 1368178 | THE TUGGEY GROUP, LLP F/K/A TUGGEY MCCUTCHEON, LLP 48e25110-6a59-46d3-a1cc-1c3b3d3848af | 1A | THE TUGGEY GROUP, LLP F/K/A TUGGEY MCCUTCHEON, LLP | 400758263 | SAN ANTONIO RIVER AUTHORITY | 2013 | first_quarter | NAT | Issues related to water development, environmental protection, financing of river basin improvements and appropriations. | Army, Dept of (Corps of Engineers),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE | 0 | 0 | 2013-01-15T15:39:50.237000-05:00 | ||
| 1368179 | THE TUGGEY GROUP, LLP F/K/A TUGGEY MCCUTCHEON, LLP 48e25110-6a59-46d3-a1cc-1c3b3d3848af | 1A | THE TUGGEY GROUP, LLP F/K/A TUGGEY MCCUTCHEON, LLP | 400758263 | SAN ANTONIO RIVER AUTHORITY | 2013 | first_quarter | BUD | Issues related to water development, environmental protection, financing of river basin improvements and appropriations. | Army, Dept of (Corps of Engineers),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE | 0 | 0 | 2013-01-15T15:39:50.237000-05:00 | ||
| 1368180 | THE TUGGEY GROUP, LLP F/K/A TUGGEY MCCUTCHEON, LLP 48e25110-6a59-46d3-a1cc-1c3b3d3848af | 1A | THE TUGGEY GROUP, LLP F/K/A TUGGEY MCCUTCHEON, LLP | 400758263 | SAN ANTONIO RIVER AUTHORITY | 2013 | first_quarter | ENV | Issues related to water development, environmental protection, financing of river basin improvements and appropriations. | Army, Dept of (Corps of Engineers),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE | 0 | 0 | 2013-01-15T15:39:50.237000-05:00 | ||
| 1368181 | THE TUGGEY GROUP, LLP F/K/A TUGGEY MCCUTCHEON, LLP 48e25110-6a59-46d3-a1cc-1c3b3d3848af | 1A | THE TUGGEY GROUP, LLP F/K/A TUGGEY MCCUTCHEON, LLP | 400758263 | SAN ANTONIO RIVER AUTHORITY | 2013 | first_quarter | CAW | Issues related to water development, environmental protection, financing of river basin improvements and appropriations. | Army, Dept of (Corps of Engineers),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE | 0 | 0 | 2013-01-15T15:39:50.237000-05:00 | ||
| 1368182 | THE TUGGEY GROUP, LLP F/K/A TUGGEY MCCUTCHEON, LLP 48e25110-6a59-46d3-a1cc-1c3b3d3848af | 1A | THE TUGGEY GROUP, LLP F/K/A TUGGEY MCCUTCHEON, LLP | 400758263 | SAN ANTONIO RIVER AUTHORITY | 2013 | first_quarter | URB | Issues related to water development, environmental protection, financing of river basin improvements and appropriations. | Army, Dept of (Corps of Engineers),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE | 0 | 0 | 2013-01-15T15:39:50.237000-05:00 | ||
| 1368183 | THE TUGGEY GROUP, LLP F/K/A TUGGEY MCCUTCHEON, LLP 48e25110-6a59-46d3-a1cc-1c3b3d3848af | 1A | THE TUGGEY GROUP, LLP F/K/A TUGGEY MCCUTCHEON, LLP | 400758263 | SAN ANTONIO RIVER AUTHORITY | 2013 | first_quarter | DIS | Issues related to water development, environmental protection, financing of river basin improvements and appropriations. | Army, Dept of (Corps of Engineers),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE | 0 | 0 | 2013-01-15T15:39:50.237000-05:00 | ||
| 1368184 | THE TUGGEY GROUP, LLP F/K/A TUGGEY MCCUTCHEON, LLP 48e25110-6a59-46d3-a1cc-1c3b3d3848af | 1A | THE TUGGEY GROUP, LLP F/K/A TUGGEY MCCUTCHEON, LLP | 400758263 | SAN ANTONIO RIVER AUTHORITY | 2013 | first_quarter | RES | Issues related to water development, environmental protection, financing of river basin improvements and appropriations. | Army, Dept of (Corps of Engineers),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE | 0 | 0 | 2013-01-15T15:39:50.237000-05:00 | ||
| 1368185 | THE TUGGEY GROUP, LLP F/K/A TUGGEY MCCUTCHEON, LLP 1aac7142-9a8e-44e7-ba07-663fcbe1063e | 1A | THE TUGGEY GROUP, LLP F/K/A TUGGEY MCCUTCHEON, LLP | 400758263 | TEXAS AGGREGATES AND CONCRETE ASSOCIATION | 2013 | first_quarter | ROD | Advocacy and education relating to issues affecting the aggregates and concrete industry within the State of Texas. | Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2013-01-15T15:50:03.343000-05:00 | ||
| 1368186 | THE TUGGEY GROUP, LLP F/K/A TUGGEY MCCUTCHEON, LLP 1aac7142-9a8e-44e7-ba07-663fcbe1063e | 1A | THE TUGGEY GROUP, LLP F/K/A TUGGEY MCCUTCHEON, LLP | 400758263 | TEXAS AGGREGATES AND CONCRETE ASSOCIATION | 2013 | first_quarter | TRA | Advocacy and education relating to issues affecting the aggregates and concrete industry within the State of Texas. | Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2013-01-15T15:50:03.343000-05:00 | ||
| 1368187 | THE TUGGEY GROUP, LLP F/K/A TUGGEY MCCUTCHEON, LLP 1aac7142-9a8e-44e7-ba07-663fcbe1063e | 1A | THE TUGGEY GROUP, LLP F/K/A TUGGEY MCCUTCHEON, LLP | 400758263 | TEXAS AGGREGATES AND CONCRETE ASSOCIATION | 2013 | first_quarter | ENV | Advocacy and education relating to issues affecting the aggregates and concrete industry within the State of Texas. | Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2013-01-15T15:50:03.343000-05:00 | ||
| 1368188 | THE TUGGEY GROUP, LLP F/K/A TUGGEY MCCUTCHEON, LLP 1aac7142-9a8e-44e7-ba07-663fcbe1063e | 1A | THE TUGGEY GROUP, LLP F/K/A TUGGEY MCCUTCHEON, LLP | 400758263 | TEXAS AGGREGATES AND CONCRETE ASSOCIATION | 2013 | first_quarter | CAW | Advocacy and education relating to issues affecting the aggregates and concrete industry within the State of Texas. | Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2013-01-15T15:50:03.343000-05:00 | ||
| 1368189 | SRG & ASSOCIATES fe6d2774-0d5b-4ac2-bab5-4215ffd71aa5 | 1TY | SRG & ASSOCIATES | 36413 | MILLIKEN & COMPANY | 2013 | first_quarter | 0 | 1 | 2013-01-15T18:00:07.090000-05:00 | |||||
| 1368190 | COLLEGE OF WILLIAM & MARY ac81d9c2-a5d6-4051-ad52-6fb98db8fdfb | Q1 | COLLEGE OF WILLIAM & MARY | 400614862 | COLLEGE OF WILLIAM & MARY | 2013 | first_quarter | TRA | Explore possible interest in university technology to avoid bird strikes on civilian and military aircraft | Agriculture, Dept of (USDA),Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES,Office of the Vice President of the United States,SENATE,White House Office | 25000 | 0 | 0 | 2013-01-18T15:47:41.127000-05:00 | |
| 1368191 | COLLEGE OF WILLIAM & MARY ac81d9c2-a5d6-4051-ad52-6fb98db8fdfb | Q1 | COLLEGE OF WILLIAM & MARY | 400614862 | COLLEGE OF WILLIAM & MARY | 2013 | first_quarter | ENV | Discuss potential Congressional funding mechanisms with regard to the funding of water projects | Agriculture, Dept of (USDA),Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES,Office of the Vice President of the United States,SENATE,White House Office | 25000 | 0 | 0 | 2013-01-18T15:47:41.127000-05:00 | |
| 1368192 | COLLEGE OF WILLIAM & MARY ac81d9c2-a5d6-4051-ad52-6fb98db8fdfb | Q1 | COLLEGE OF WILLIAM & MARY | 400614862 | COLLEGE OF WILLIAM & MARY | 2013 | first_quarter | VET | Meeting to discuss White House support for the Veterans Benefits Clinic at the W&M Law School. | Agriculture, Dept of (USDA),Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES,Office of the Vice President of the United States,SENATE,White House Office | 25000 | 0 | 0 | 2013-01-18T15:47:41.127000-05:00 | |
| 1368193 | HEALTH INDUSTRY DISTRIBUTORS ASSOCIATION d59dc0de-e9dd-42f0-b257-54a6f4085640 | Q1 | HEALTH INDUSTRY DISTRIBUTORS ASSOCIATION | 40011087 | HEALTH INDUSTRY DISTRIBUTORS ASSOCIATION | 2013 | first_quarter | HCR | DMEPOS Competitive Bidding; Excise Tax on Medical Devices; Pharmaceutical Pedigree; Unique Device Identification | Centers For Medicare and Medicaid Services (CMS),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE | 30522 | 0 | 0 | 2013-01-18T16:22:20.043000-05:00 | |
| 1368194 | AMERICAN ACADEMY OF SLEEP MEDICINE 058eed5b-3e30-4aa3-8e24-b734fa3cbff3 | 1AY | AMERICAN ACADEMY OF SLEEP MEDICINE | 3333 | AMERICAN ACADEMY OF SLEEP MEDICINE | 2013 | first_quarter | 0 | 0 | 2013-01-23T16:46:10.343000-05:00 | |||||
| 1368195 | PAUL MARCONE & ASSOCIATES, LLC 8869e0a5-e437-4429-b697-95eab90b8878 | 1TY | PAUL MARCONE & ASSOCIATES, LLC | 283732 | NATIONAL LAW ENFORCEMENT OFFICERS MEMORIAL FUND | 2013 | first_quarter | 0 | 1 | 2013-01-25T16:04:00.717000-05:00 | |||||
| 1368196 | CYBER SECURITY RESEARCH CONSULTANTS, LLC 474c724d-e521-4449-ae34-b97d3c7c8651 | 1TY | CYBER SECURITY RESEARCH CONSULTANTS, LLC | 91694 | THE LIVINGSTON GROUP (ON BEHALF OF U.S. CHAMBER OF COMMERCE) | 2013 | first_quarter | 0 | 1 | 2013-01-28T07:18:39.287000-05:00 | |||||
| 1368197 | TALBERT & EITEL, PLLC 97513f3a-ea2e-4eb9-ac4a-9b61a12a3973 | 1@Y | TALBERT & EITEL, PLLC | 400732198 | TUTOR OUR CHILDREN | 2013 | first_quarter | 0 | 1 | 2013-01-29T22:54:39.913000-05:00 | |||||
| 1368198 | LIEBMAN & ASSOCIATES, INC. 96cb809a-f49a-46b8-8bc4-53fc9c782a9e | 1TY | LIEBMAN & ASSOCIATES, INC. | 46585 | RENTECH, INC. | 2013 | first_quarter | 0 | 1 | 2013-01-30T10:18:17.047000-05:00 | |||||
| 1368199 | GEOEYE, INC. 46e4def4-29fc-4e5e-80ae-fc4bdd77c7f8 | 1T | GEOEYE, INC. | 400276319 | GEOEYE, INC. | 2013 | first_quarter | AER | Support for US commercial satellite imagery providers | HOUSE OF REPRESENTATIVES,SENATE,White House Office | 7000 | 0 | 1 | 2013-01-30T18:42:54.060000-05:00 | |
| 1368200 | THE MADISON GROUP 4ad4b721-70b6-49bf-9375-b482d55b2dd8 | 1T | THE MADISON GROUP | 284050 | GENWORTH FINANCIAL | 2013 | first_quarter | FIN | Issues pertaining to regulatory reform, financial reform and risk retention. | HOUSE OF REPRESENTATIVES,SENATE | 13000 | 0 | 1 | 2013-02-01T10:26:43.387000-05:00 | |
| 1368201 | ITOCHU AVIATION, INC. de5bf096-9707-4dd0-acce-d055b66ca897 | 1TY | ITOCHU AVIATION, INC. | 20265 | ITOCHU AVIATION INC | 2013 | first_quarter | 0 | 1 | 2013-02-01T10:26:45.167000-05:00 | |||||
| 1368202 | VAN SCOYOC ASSOCIATES 6ca96535-eedb-434c-b4d1-257dd3abe70b | 1TY | VAN SCOYOC ASSOCIATES | 39837 | VILF CONSULTANTS, LLC | 2013 | first_quarter | 0 | 1 | 2013-02-01T10:26:47.037000-05:00 | |||||
| 1368203 | VAN SCOYOC ASSOCIATES 330d18ff-adc2-407b-a5b6-82c7bb503681 | 1TY | VAN SCOYOC ASSOCIATES | 39837 | METHODIST HOSPITAL SYSTEM | 2013 | first_quarter | 0 | 1 | 2013-02-01T10:26:47.070000-05:00 | |||||
| 1368204 | VAN SCOYOC ASSOCIATES fc02b30c-8b8d-4f07-9847-c32e79b5c705 | 1@Y | VAN SCOYOC ASSOCIATES | 39837 | THE WASHINGTON CENTER FOR INTERNSHIPS AND ACADEMIC SEMINARS | 2013 | first_quarter | 0 | 1 | 2013-02-01T10:26:47.117000-05:00 | |||||
| 1368205 | MARK KNOUSE e54688f7-6040-4e87-a921-784e4ffafcba | 1TY | MARK KNOUSE | 312155 | FAMILY HOSPICE AND PALLIATIVE CARE | 2013 | first_quarter | 6000 | 0 | 1 | 2013-02-01T12:59:55.713000-05:00 | ||||
| 1368206 | MARK KNOUSE 70997166-85d1-4488-b7ce-915095058df1 | 1TY | MARK KNOUSE | 312155 | IOWA HEALTHCARE COLLABORATIVE | 2013 | first_quarter | 0 | 1 | 2013-02-01T12:59:55.883000-05:00 | |||||
| 1368207 | MARK KNOUSE 9b123252-209a-4328-bd54-9a2fabbef445 | 1TY | MARK KNOUSE | 312155 | VINCENTIAN COLLABORATIVE SYSTEM | 2013 | first_quarter | 0 | 1 | 2013-02-01T12:59:56.040000-05:00 | |||||
| 1368208 | CHARLES CRAGIN a48ea29b-89be-417f-8d83-dca392749119 | 1T | CHARLES CRAGIN | 400631914 | HEALTH NET FEDERAL SERVICES, LLC | 2013 | first_quarter | HCR | Providing information to and encouragining utilization of HNFS services and products by federal agencies. | 0 | 1 | 2013-02-01T12:59:56.540000-05:00 | |||
| 1368209 | AIR TRANSPORT ASSOCIATION OF AMERICA, INC. (D/B/A AIRLINES FOR AMERICA) 40eae814-9d5f-4682-b7a3-8a8e31c48288 | 1TY | AIR TRANSPORT ASSOCIATION OF AMERICA, INC. (D/B/A AIRLINES FOR AMERICA) | 614 | AIR TRANSPORT ASSOCIATION OF AMERICA, INC. (D/B/A AIRLINES FOR AMERICA) | 2013 | first_quarter | 0 | 1 | 2013-02-02T13:13:54.733000-05:00 | |||||
| 1368210 | BEHAR & KALMAN, LLP 68bc4029-98a3-4055-b460-3c5161fd29ef | 1T | BEHAR & KALMAN, LLP | 5791 | CALVARY HOSPITAL | 2013 | first_quarter | HCR | Medicare Payment Policy | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2013-02-02T15:30:27.490000-05:00 | ||
| 1368211 | BEHAR & KALMAN, LLP cc23810c-03fa-494b-a87c-56ca3b224e9e | 1T | BEHAR & KALMAN, LLP | 5791 | NATIONAL ASSOCIATION OF LONG TERM HOSPITALS | 2013 | first_quarter | HCR | Medicare payment and certification policy | HOUSE OF REPRESENTATIVES,Medicare Payment Advisory Commission (MedPAC),SENATE | 0 | 1 | 2013-02-02T15:36:30.407000-05:00 | ||
| 1368212 | NANDOGROUP LLC 4e8d7c7e-d9b4-4b66-b3de-f7872009b07a | Q1 | NANDOGROUP LLC | 400430085 | NANDOGROUP LLC | 2013 | first_quarter | SMB | Small Business programs | Architect of the Capitol (AOC),Army, Dept of (Corps of Engineers),Defense, Dept of (DOD),Veterans Affairs, Dept of (VA) | 0 | 0 | 2013-02-07T13:14:19.170000-05:00 | ||
| 1368213 | ALEXANDER, BOROVICKA & O'SHEA GOVERNMENT SOLUTIONS (FKA ALEXANDER & BOROVICKA GO 38e1dbe4-d2f5-4c77-a84d-6d48b712b1c0 | 1T | ALEXANDER, BOROVICKA & O'SHEA GOVERNMENT SOLUTIONS (FKA ALEXANDER & BOROVICKA GO | 40025213 | RASS HOSPITALITY, LLC | 2013 | first_quarter | ECN | The focus of this engagement will concentrate on working with the Federal legislators and the U.S. Customs & Immigration services (USCIC) to acquire rulings on EB-5 Investor applications that have been, and will continue to be, made by the agency. | Bureau of Citizenship & Immigration Services (BCIS) | 20000 | 0 | 1 | 2013-02-11T11:53:29.727000-05:00 | |
| 1368214 | ALEXANDER, BOROVICKA & O'SHEA GOVERNMENT SOLUTIONS (FKA ALEXANDER & BOROVICKA GO 38e1dbe4-d2f5-4c77-a84d-6d48b712b1c0 | 1T | ALEXANDER, BOROVICKA & O'SHEA GOVERNMENT SOLUTIONS (FKA ALEXANDER & BOROVICKA GO | 40025213 | RASS HOSPITALITY, LLC | 2013 | first_quarter | IMM | The focus of this engagement will concentrate on working with the Federal legislators and the U.S. Customs & Immigration services (USCIC) to acquire rulings on EB-5 Investor applications that have been, and will continue to be, made by the agency. | Bureau of Citizenship & Immigration Services (BCIS) | 20000 | 0 | 1 | 2013-02-11T11:53:29.727000-05:00 | |
| 1368215 | TRUCKLOAD CARRIERS ASSOCIATION 57e712f2-b715-4d65-8e5a-2f8f451a4d1c | Q1 | TRUCKLOAD CARRIERS ASSOCIATION | 400421011 | TRUCKLOAD CARRIERS ASSOCIATION | 2013 | first_quarter | TRA | Highway Bill Reauthorization, Tolling & Electronic On-Board Recorders | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2013-02-12T10:11:04.253000-05:00 | ||
| 1368216 | GRAY & OSCAR, LLC (FORMERLY BOB GRAY, LLC) 673ebf66-e152-4656-b1ea-69142dd5dbd2 | 1T | GRAY & OSCAR, LLC (FORMERLY BOB GRAY, LLC) | 33124 | INTERNATIONAL UNION OF PAINTERS AND ALLIED TRADES | 2013 | first_quarter | LBR | Assisted in identifying grant opportunities with the U.S. Department of Labor | HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE | 0 | 1 | 2013-02-12T13:22:27.333000-05:00 | ||
| 1368217 | GRAY & OSCAR, LLC (FORMERLY BOB GRAY, LLC) c0598236-4853-4d04-a7a4-b22536d0de7f | Q1 | GRAY & OSCAR, LLC (FORMERLY BOB GRAY, LLC) | 33124 | INTERNATIONAL UNION OF PAINTERS AND ALLIED TRADES | 2013 | first_quarter | LBR | Continued to monitor various DoL programs and other federal agency programs for grant funding opportunities | HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE | 0 | 0 | 2013-02-12T13:28:28.110000-05:00 | ||
| 1368218 | GRAY & OSCAR, LLC (FORMERLY BOB GRAY, LLC) d28526ed-f3d7-4ee8-b013-68c01eb4c749 | 1T | GRAY & OSCAR, LLC (FORMERLY BOB GRAY, LLC) | 33124 | INTERNATIONAL UNION OF PAINTERS AND ALLIED TRADES | 2013 | first_quarter | LBR | Assisted in identifying grant opportunities with the U.S. Department of Labor | HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE | 0 | 1 | 2013-02-12T17:05:48-05:00 | ||
| 1368219 | CAPITOL DECISIONS, INC. d87c1350-8c10-4b55-9d68-fbcabdff7b84 | 1TY | CAPITOL DECISIONS, INC. | 55165 | SORENSON COMMUNICATIONS, INC. | 2013 | first_quarter | 0 | 1 | 2013-02-13T14:39:09.733000-05:00 | |||||
| 1368220 | CAPITOL DECISIONS, INC. 15b08a3d-c7bb-4f89-9d1c-c8724479a51b | 1TY | CAPITOL DECISIONS, INC. | 55165 | VAN SCOYOC ASSOCIATES (TECORE NETWORKS) | 2013 | first_quarter | 0 | 1 | 2013-02-13T14:41:10.530000-05:00 | |||||
| 1368221 | VAN SCOYOC ASSOCIATES f0434bc5-95dd-4d2a-a776-88db8a139f7c | 1TY | VAN SCOYOC ASSOCIATES | 39837 | CAPITOL DECISIONS, INC. (SORENSON COMMUNICATIONS, INC.) | 2013 | first_quarter | 0 | 1 | 2013-02-13T15:04:12.203000-05:00 | |||||
| 1368222 | GHAZAL & ASSOCIATES, LLC 1993cbd3-5bf9-41cf-98c2-bf5428907c9f | 1TY | GHAZAL & ASSOCIATES, LLC | 45414 | MIKEL INC | 2013 | first_quarter | 0 | 1 | 2013-02-13T16:25:15.847000-05:00 | |||||
| 1368223 | LIEBMAN & ASSOCIATES, INC. 29f8d93f-976d-408f-b04d-a7391c1c831b | 1T | LIEBMAN & ASSOCIATES, INC. | 46585 | TIGO ENERGY, INC. | 2013 | first_quarter | ENG | Clean and sustainable energy technology research, development and demonstration | Energy, Dept of | 0 | 1 | 2013-02-14T12:20:39.363000-05:00 | ||
| 1368224 | SABISTON CONSULTANTS, LLC 67f43319-a3ec-4688-b431-0adc1958d186 | Q1Y | SABISTON CONSULTANTS, LLC | 323557 | NEW ORLEANS FEDERAL ALLIANCE (NOFA) | 2013 | first_quarter | 0 | 0 | 2013-02-14T18:09:50.660000-05:00 | |||||
| 1368225 | U.S. NAVAL SEA CADET CORPS d38d3881-ec3a-4193-a7aa-e9cb20242f53 | 1A | U.S. NAVAL SEA CADET CORPS | 51467 | U S NAVAL SEA CADET CORPS | 2013 | first_quarter | BUD | Seek funding support to assist in training programs for Naval Sea Cadet Corps. | HOUSE OF REPRESENTATIVES,Navy, Dept of,SENATE,U.S. Coast Guard (USCG) | 20000 | 0 | 0 | 2013-02-19T15:53:12.807000-05:00 | |
| 1368226 | COMPASS STRATEGIES, LLC cc914bc7-fe04-4ccd-8587-d108bc585282 | Q1 | COMPASS STRATEGIES, LLC | 299172 | PTC | 2013 | first_quarter | DEF | Issues pertaining to software engineering and application lifecycle management | Army, Dept of (Other) | 20000 | 0 | 0 | 2013-02-20T05:11:38.677000-05:00 | |
| 1368227 | COMPASS STRATEGIES, LLC a49614ea-df16-42a4-b216-46682193ea4f | Q1 | COMPASS STRATEGIES, LLC | 299172 | IMMUNETICS, INC. | 2013 | first_quarter | MED | Issues pertaining to blood supply safety and the promotion of blood platelet bacterial contamination detection | Veterans Affairs, Dept of (VA) | 0 | 0 | 2013-02-20T05:16:43.533000-05:00 | ||
| 1368228 | ALPINE GROUP PARTNERS, LLC. 5097151a-89e8-404e-b3c5-86255210090f | 1T | ALPINE GROUP PARTNERS, LLC. | 1171 | ARNOLD & PORTER LLP ON BEHALF OF TEXAS TECH UNIVERSITY | 2013 | first_quarter | DEF | Issues related to center for strategic studies | HOUSE OF REPRESENTATIVES | 10000 | 0 | 1 | 2013-02-20T10:49:18.630000-05:00 | |
| 1368229 | MCCONNELL VALDES PLLC c2660626-4c64-4e95-91d9-649a8b40b595 | 1TY | MCCONNELL VALDES PLLC | 40043343 | CITY OF SAN JUAN | 2013 | first_quarter | 0 | 1 | 2013-02-20T12:11:20.427000-05:00 | |||||
| 1368230 | MCCONNELL VALDES PLLC df3823c1-6863-4154-adeb-36395c3e0a74 | 1TY | MCCONNELL VALDES PLLC | 40043343 | PUERTO RICO DEPARTMENT OF CORRECTION AND REHABILITATION | 2013 | first_quarter | 0 | 1 | 2013-02-20T12:15:21.017000-05:00 | |||||
| 1368231 | PINNEY ASSOCIATES 7bd5084a-557f-4fe1-96bc-e937c87c3e90 | Q1Y | PINNEY ASSOCIATES | 317195 | PINNEY ASSOCIATES | 2013 | first_quarter | 0 | 0 | 2013-02-22T07:50:07.560000-05:00 | |||||
| 1368232 | PUBLIC POLICY PARTNERS 099bba30-a555-4e72-9e13-cc5a6f657405 | 1TY | PUBLIC POLICY PARTNERS | 400504486 | PUBLIC POLICY PARTNERS | 2013 | first_quarter | 0 | 1 | 2013-02-22T12:51:39.233000-05:00 | |||||
| 1368233 | UPSTREAM CONSULTING, INC. 186314cb-b17d-423b-be0e-8e2d4d2e249f | 1TY | UPSTREAM CONSULTING, INC. | 88278 | ARMORWORKS | 2013 | first_quarter | 0 | 1 | 2013-02-26T14:04:45.173000-05:00 | |||||
| 1368234 | JCP ASSOCIATES c01b4c60-a8d8-4597-84b0-4db1374ed020 | 1T | JCP ASSOCIATES | 48430 | UNIVERSITY OF SOUTH FLORIDA | 2013 | first_quarter | EDU | Appropriation and policy issues relevant to higher education. | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 1 | 2013-02-28T11:57:14.077000-05:00 | |
| 1368235 | BROWN RUDNICK LLP b65702c5-cb0c-4532-be43-a6cbb85f22b2 | 1TY | BROWN RUDNICK LLP | 287895 | GUARDIAN LIFE INSURANCE COMPANY OF AMERICA | 2013 | first_quarter | 0 | 1 | 2013-03-01T15:06:33.993000-05:00 | |||||
| 1368236 | BROWN RUDNICK LLP 7fc13280-28dc-48ee-a226-19366b23f29a | 1TY | BROWN RUDNICK LLP | 287895 | MUTUAL OF OMAHA | 2013 | first_quarter | 0 | 1 | 2013-03-01T15:14:36.130000-05:00 | |||||
| 1368237 | BROWN RUDNICK LLP ef3b2888-5e05-4b4d-bdb2-95114ebfdbbd | 1TY | BROWN RUDNICK LLP | 287895 | PRINCIPAL FINANCIAL GROUP | 2013 | first_quarter | 0 | 1 | 2013-03-01T15:24:36.923000-05:00 | |||||
| 1368238 | BROWN RUDNICK LLP 30064a41-b718-4c9c-9cfb-d82ff4a20634 | 1TY | BROWN RUDNICK LLP | 287895 | ORACLE CORPORATION | 2013 | first_quarter | 20000 | 0 | 1 | 2013-03-01T15:32:38.530000-05:00 | ||||
| 1368239 | BROWN RUDNICK LLP c4ed0764-7b79-4ad0-b215-96f32787354e | 1T | BROWN RUDNICK LLP | 287895 | PARENT-CHILD HOME PROGRAM | 2013 | first_quarter | EDU | Early childhood education legislation ESEA Reauthorization | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2013-03-01T15:37:39.247000-05:00 | ||
| 1368240 | BROWN RUDNICK LLP 39006c6a-4b93-4350-9336-ffbd3d0efc61 | 1T | BROWN RUDNICK LLP | 287895 | HORACE BUSHNELL MEMORIAL HALL CORPORATION | 2013 | first_quarter | TRD | H.R. 950- Ticket Act | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2013-03-01T15:41:40.310000-05:00 | ||
| 1368241 | BROWN RUDNICK LLP 39006c6a-4b93-4350-9336-ffbd3d0efc61 | 1T | BROWN RUDNICK LLP | 287895 | HORACE BUSHNELL MEMORIAL HALL CORPORATION | 2013 | first_quarter | TRA | General Transportation Issues | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2013-03-01T15:41:40.310000-05:00 | ||
| 1368242 | BROWN RUDNICK LLP 39006c6a-4b93-4350-9336-ffbd3d0efc61 | 1T | BROWN RUDNICK LLP | 287895 | HORACE BUSHNELL MEMORIAL HALL CORPORATION | 2013 | first_quarter | BUD | FY 2013 Labor-HHS-Education Appropriations FY 2013 Transportation-HUD Appropriations | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2013-03-01T15:41:40.310000-05:00 | ||
| 1368243 | J.A. GREEN AND COMPANY (FORMERLY LLC) e2e7642f-4c61-4095-a07d-cc4cc0698252 | 1T | J.A. GREEN AND COMPANY (FORMERLY LLC) | 313511 | ARNOLD MAGNETIC TECHNOLOGIES | 2013 | first_quarter | DEF | Issues related to specialty metals and rare earth materials | HOUSE OF REPRESENTATIVES | 0 | 1 | 2013-03-04T10:12:01.513000-05:00 | ||
| 1368244 | ASSET & EQUITY CORPORATION ea0199ce-a1b0-468b-b35e-f90afff9983a | Q1 | ASSET & EQUITY CORPORATION | 4403 | MOUNT OLIVE COLLEGE | 2013 | first_quarter | EDU | education/health issues | HOUSE OF REPRESENTATIVES,SENATE | 8000 | 0 | 0 | 2013-03-06T13:22:23.197000-05:00 | |
| 1368245 | MILLER & WENHOLD CAPITOL STRATEGIES 125299f6-4672-4bd7-b520-e77bc06ec335 | 1TY | MILLER & WENHOLD CAPITOL STRATEGIES | 307034 | ANIMAL DEFENDERS INTERNATIONAL | 2013 | first_quarter | 0 | 1 | 2013-03-07T09:30:24.637000-05:00 | |||||
| 1368246 | HALEY & ASSOCIATES 4ddd9a35-cbcf-4712-8117-b7e1258a4a73 | 1T | HALEY & ASSOCIATES | 17328 | CALIFORNIA CANNING PEACH ASSN | 2013 | first_quarter | AGR | USDA Fresh Fruit and Vegetable Program | Agriculture, Dept of (USDA),HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2013-03-07T12:10:42.600000-05:00 | ||
| 1368247 | HALEY & ASSOCIATES d34d7159-0cf5-41d0-839e-a9e9b4e6e17d | 1TY | HALEY & ASSOCIATES | 17328 | DIAMOND OF CALIFORNIA | 2013 | first_quarter | 0 | 1 | 2013-03-07T12:12:43.193000-05:00 | |||||
| 1368248 | CARLYLE CONSULTING b45bdcb8-7f86-40e6-b53f-0340276ab7eb | Q1 | CARLYLE CONSULTING | 8293 | SEMINOLE TRIBE OF FLORIDA INCORPORATED (STOFI) | 2013 | first_quarter | IND | Advisory Opinion concerning the Native Lands Lottery before the National Indian Gaming Commission and all government affairs and public policy initiatives on Capitol Hill that would affect the interests of the Seminole Tribe of Florida Incorporated. | HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE | 40000 | 0 | 0 | 2013-03-07T17:13:44.777000-05:00 | |
| 1368249 | SEGUNDO MERCADO-LLORENS d964aca8-6040-4514-9f99-b33c5e2c2426 | 1T | SEGUNDO MERCADO-LLORENS | 67557 | GLOBAL EXCHANGE | 2013 | first_quarter | FOR | Lobbied against the Administration's drone polices including, but not limted to, targetting criteria. | HOUSE OF REPRESENTATIVES,SENATE | 5500 | 0 | 1 | 2013-03-08T14:55:01.107000-05:00 | |
| 1368250 | L. E. HAEFNER ENTERPRISES, INC. 6689c9a6-3e9c-407c-b54c-fb3e7808d754 | 1T | L. E. HAEFNER ENTERPRISES, INC. | 17261 | TERMINAL RAILROAD ASSOCIATION OF ST. LOUIS, MISSOURI | 2013 | first_quarter | TRA | PUBLIC AND PRIVATE FUNDING OF SHORT-LINE TERMINAL RAILROAD CRITICAL RAILROAD BRIDGE LINKING MISSOURI AND ILLINOIS IN THE GREATER ST. LOUIS BI-STATE METROPOLITAN REGION | Transportation, Dept of (DOT) | 0 | 1 | 2013-03-09T16:51:18.300000-05:00 | ||
| 1368251 | METHANOL INSTITUTE 6a714f62-6300-4e92-b879-2e85f2a54c90 | Q1 | METHANOL INSTITUTE | 2902 | METHANOL INSTITUTE | 2013 | first_quarter | ENG | Alternative Transportation Fuels | HOUSE OF REPRESENTATIVES,SENATE | 45000 | 0 | 0 | 2013-03-13T05:22:06.193000-04:00 | |
| 1368252 | METHANOL INSTITUTE 6a714f62-6300-4e92-b879-2e85f2a54c90 | Q1 | METHANOL INSTITUTE | 2902 | METHANOL INSTITUTE | 2013 | first_quarter | CHM | Chemical Safety, Chemicals and the Environment | HOUSE OF REPRESENTATIVES,SENATE | 45000 | 0 | 0 | 2013-03-13T05:22:06.193000-04:00 | |
| 1368253 | METHANOL INSTITUTE 6132cae8-22f7-40aa-9f0b-20bd77f5de30 | Q1 | METHANOL INSTITUTE | 2902 | METHANOL INSTITUTE | 2013 | first_quarter | CHM | Methanol Health Assessment under Environmental Protection Agency's Integrated Risk Information System | Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2013-03-13T05:40:07.467000-04:00 | ||
| 1368254 | METHANOL INSTITUTE 6132cae8-22f7-40aa-9f0b-20bd77f5de30 | Q1 | METHANOL INSTITUTE | 2902 | METHANOL INSTITUTE | 2013 | first_quarter | ENG | Alternative Transportation Fuels | Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2013-03-13T05:40:07.467000-04:00 | ||
| 1368255 | METHANOL INSTITUTE 958059cc-bd5c-4c26-a81c-8da04e4b7ca7 | Q1 | METHANOL INSTITUTE | 2902 | METHANOL INSTITUTE | 2013 | first_quarter | CHM | Toxic Substances Control Act, Enivronmental Protection Agency Assessment under it's Integrated Risk Information System | HOUSE OF REPRESENTATIVES,SENATE | 45000 | 0 | 0 | 2013-03-13T05:48:08.233000-04:00 | |
| 1368256 | METHANOL INSTITUTE 958059cc-bd5c-4c26-a81c-8da04e4b7ca7 | Q1 | METHANOL INSTITUTE | 2902 | METHANOL INSTITUTE | 2013 | first_quarter | ENG | Alternative Fuels | HOUSE OF REPRESENTATIVES,SENATE | 45000 | 0 | 0 | 2013-03-13T05:48:08.233000-04:00 | |
| 1368257 | OSF HEALTHCARE SYSTEM 75f6f5f7-4457-40cc-8e58-cfa0ae95c7bc | Q1 | OSF HEALTHCARE SYSTEM | 56394 | OSF HEALTHCARE SYSTEM | 2013 | first_quarter | HCR | Lobbied the House and Senate for hospital and physician payment reform. Also lobbied for support of ACO activities and adoption in Medicare. | HOUSE OF REPRESENTATIVES,SENATE | 110000 | 0 | 0 | 2013-03-13T13:12:36.563000-04:00 | |
| 1368258 | THE MITA GROUP, INC. 4693bca3-83f9-44e7-841f-0d4c6741f06f | 1TY | THE MITA GROUP, INC. | 301254 | ADVANCED SYSTEMS TECHNOLOGY | 2013 | first_quarter | 0 | 1 | 2013-03-13T14:16:41.143000-04:00 | |||||
| 1368259 | THE MITA GROUP, INC. f02f267c-2490-40b2-847b-d3d6d2736f2c | 1T | THE MITA GROUP, INC. | 301254 | NUMBERSUSA.COM | 2013 | first_quarter | IMM | Immigration Matters | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2013-03-13T14:25:42.110000-04:00 | |
| 1368260 | THE MITA GROUP, INC. e4beb4f1-8395-4905-8776-c8ea6afd1aa0 | 1T | THE MITA GROUP, INC. | 301254 | NATIONAL ASSOCIATION OF SMALL TRUCKING COMPANIES | 2013 | first_quarter | TRA | Commercial motor vehicle regulatory policy issues | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2013-03-13T14:43:43.860000-04:00 | |
| 1368261 | MR. GARY BARBOUR 8516f159-4f21-4fbe-a66d-f78b9cfdbcaf | 1T | MR. GARY BARBOUR | 44550 | NUSCALE POWER, INC. | 2013 | first_quarter | ENG | Small modular nuclear reactor appropriations | Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE | 25000 | 0 | 1 | 2013-03-14T14:55:56.620000-04:00 | |
| 1368262 | THE JUNTO COMPANY b8c69aee-fece-440d-8794-b9b66ac2e772 | Q1 | THE JUNTO COMPANY | 400459274 | ENERGY INDUSTRIES OF OHIO | 2013 | first_quarter | ENG | Worked to maintain funding for the Advanced Ultra Super Critical Clean Coal Project within FY 2013 Energy and Water section in US Department of Energy, HJ Res117, H933 | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2013-03-15T10:19:10.153000-04:00 | |
| 1368263 | AMERICAN BIRD CONSERVANCY d9ae8653-0bc3-4e2d-8bd5-48548217bc48 | Q1 | AMERICAN BIRD CONSERVANCY | 1810 | AMERICAN BIRD CONSERVANCY | 2013 | first_quarter | ENV | Interior Appropriations, Western Oregon Plan Revision, Northwest Forest Plan, PCV Pipes as Mine Markers, TSCA | Bureau of Land Management (BLM),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE,U.S. Fish & Wildlife Service (USFWS),U.S. Forest Service | 0 | 0 | 2013-03-15T15:33:32.813000-04:00 | ||
| 1368264 | BROWN RUDNICK LLP 3d693229-6012-4fad-bd2f-7b91cda92f32 | 1T | BROWN RUDNICK LLP | 287895 | NATIONAL ASSOCIATION OF ORDNANCE AND EXPLOSIVE WASTE CONTRACTORS | 2013 | first_quarter | DEF | H.R. 5856 - FY 2013 Defense Appropriations Act; H.R. 5854 & S. 3215 - FY 2013 Military Construction, Veterans Affairs and Related Agencies Appropriations Act; H.R. 933 - Department of Defense, Military Construction and Veterans Affairs, and Full-Year Continuing Appropriations Act, 2013; FY 2014 Defense Authorization | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 1 | 2013-03-18T12:24:18.140000-04:00 | |
| 1368265 | BROWN RUDNICK LLP 3d693229-6012-4fad-bd2f-7b91cda92f32 | 1T | BROWN RUDNICK LLP | 287895 | NATIONAL ASSOCIATION OF ORDNANCE AND EXPLOSIVE WASTE CONTRACTORS | 2013 | first_quarter | BUD | H.R. 5856 - FY 2013 Defense Appropriations Act; H.R. 5854 & S. 3215 - FY 2013 Military Construction, Veterans Affairs and Related Agencies Appropriations Act; H.R. 933 - Department of Defense, Military Construction and Veterans Affairs, and Full-Year Continuing Appropriations Act, 2013 | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 1 | 2013-03-18T12:24:18.140000-04:00 | |
| 1368266 | BROWN RUDNICK LLP 3d693229-6012-4fad-bd2f-7b91cda92f32 | 1T | BROWN RUDNICK LLP | 287895 | NATIONAL ASSOCIATION OF ORDNANCE AND EXPLOSIVE WASTE CONTRACTORS | 2013 | first_quarter | ENV | H.R. 5856 - FY 2013 Defense Appropriations Act; H.R. 5854 & S. 3215 - FY 2013 Military Construction, Veterans Affairs and Related Agencies Appropriations Act; H.R. 933 - Department of Defense, Military Construction and Veterans Affairs, and Full-Year Continuing Appropriations Act, 2013; FY 2014 Defense Authorization | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 1 | 2013-03-18T12:24:18.140000-04:00 | |
| 1368267 | BARBARA KENNELLY ASSOCIATES, LLC b5d7be9f-9912-402d-b133-299303b6e5ea | 1TY | BARBARA KENNELLY ASSOCIATES, LLC | 400779344 | THE ADVOCACY FUND | 2013 | first_quarter | 0 | 1 | 2013-03-18T15:04:24.547000-04:00 | |||||
| 1368268 | BARBARA KENNELLY ASSOCIATES, LLC f43d82d1-2e90-44c7-b0b0-7b75f2ecd645 | Q1Y | BARBARA KENNELLY ASSOCIATES, LLC | 400779344 | HEALTHCARE LEADERSHIP COUNCIL | 2013 | first_quarter | 0 | 0 | 2013-03-18T15:09:26.497000-04:00 | |||||
| 1368269 | MARIA FREESE 083b539c-685a-4b44-9ce8-537d4ec82336 | 1TY | MARIA FREESE | 400861526 | BARBARA KENNELLY ASSOCIATES, ON BEHALF OF THE ADVOCACY FUND | 2013 | first_quarter | 0 | 1 | 2013-03-18T15:29:27.753000-04:00 | |||||
| 1368270 | IDEMIA IDENTITY & SECURITY USA, LLC 91535a08-1915-4120-a3dc-5e7e9f4124b2 | Q1 | IDEMIA IDENTITY & SECURITY USA, LLC | 40013100 | IDEMIA IDENTITY & SECURITY USA LLC | 2013 | first_quarter | HOM | immigration reform | HOUSE OF REPRESENTATIVES,SENATE | 90000 | 0 | 0 | 2013-03-18T17:27:31.927000-04:00 | |
| 1368271 | IDEMIA IDENTITY & SECURITY USA, LLC ca846044-9d24-405c-abaa-ce144dd4bb5f | 1A | IDEMIA IDENTITY & SECURITY USA, LLC | 40013100 | IDEMIA IDENTITY & SECURITY USA LLC | 2013 | first_quarter | HOM | immigration reform | HOUSE OF REPRESENTATIVES,SENATE | 90000 | 0 | 0 | 2013-03-18T18:12:33.470000-04:00 | |
| 1368272 | PUBLIC KNOWLEDGE 8aac3f45-95e3-4e79-959c-cbe0331d69f2 | Q1 | PUBLIC KNOWLEDGE | 315012 | PUBLIC KNOWLEDGE | 2013 | first_quarter | CPT | IRFA, Cellphone Unlocking, SHEILD Act | 0 | 0 | 2013-03-20T11:24:27.207000-04:00 | |||
| 1368273 | THOMPSON HINE LLP fe5728fa-c250-4dfa-bc88-0f95cae16703 | 1TY | THOMPSON HINE LLP | 38051 | WILLKIE FARR & GALLAGHER LLP | 2013 | first_quarter | 0 | 1 | 2013-03-21T12:42:02.697000-04:00 | |||||
| 1368274 | THOMPSON HINE LLP 94df7913-4c3b-40cb-86c8-551bb6a83d05 | 1TY | THOMPSON HINE LLP | 38051 | NORANDA ALUMINUM INC | 2013 | first_quarter | 0 | 1 | 2013-03-21T12:49:04.800000-04:00 | |||||
| 1368275 | TIMMONS CONSULTING a70ec408-a5ca-4e82-8832-ff9ad31c37d3 | Q1 | TIMMONS CONSULTING | 400880576 | UNIVERSITY OF MIAMI | 2013 | first_quarter | BUD | Appropriations issues affecting universities. | HOUSE OF REPRESENTATIVES,SENATE | 55000 | 0 | 0 | 2013-03-21T15:16:11.753000-04: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);