lobbying_filings

Senate Lobbying Disclosure Act filings (1999–2026). LD-1 registrations and LD-2 quarterly activity reports. 1.5M+ filings.

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

75,821 rows where filing_year = 2013 sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

filing_year 1

  • 2013 · 75,821 ✖
filing_uuid filing_type registrant_id registrant_name client_id client_name filing_year ▲ filing_period received_date amount_reported is_amendment is_no_activity is_termination
8405cd40-23a7-4c71-9a5d-667e3b9201d1 RR 400319495 POTOMAC CURRENTS, LLC 189238 AMERICAN SOCIETY OF BARIATRIC PHYSICIANS 2013 first_quarter 2013-01-02T12:05:16.340000-05:00   0 0 0
471ba6ed-5ffd-4ac5-923a-f014dd059f11 RR 400319495 POTOMAC CURRENTS, LLC 189237 THE OBESITY SOCIETY 2013 first_quarter 2013-01-02T12:09:18.120000-05:00   0 0 0
5593710b-cb90-4972-94e3-494651d5596a RA 40025196 AMERICAN ASSOCIATION OF VETERINARY MEDICAL COLLEGES (FKA ASSOCIATION OF AMERICAN 188083 AMERICAN ASSOCIATION OF VETERINARY MEDICAL COLLEGES (FKA ASSOCIATION OF AMERICAN 2013 first_quarter 2013-01-02T14:29:25.327000-05:00   1 0 0
309e1672-f3a0-462c-891a-eb3b4714b9d3 RR 8316 CARMEN GROUP INCORPORATED 111649 LOS ANGELES RIVER REVITALIZATION CORPORATION 2013 first_quarter 2013-01-02T16:55:55.880000-05:00   0 0 0
95fee357-bbe5-4e3e-8757-88d6eee0ab3f RR 283696 BECKER & POLIAKOFF, P.A. 174905 CITY OF HIALEAH GARDENS 2013 first_quarter 2013-01-03T13:19:08.957000-05:00   0 0 0
0a9200ba-f3ba-42f6-8067-071210af9f95 RR 22746 THE MICHAEL LEWAN COMPANY 129620 BLUE CROSS BLUE SHIELD ASSOCIATION 2013 first_quarter 2013-01-03T18:37:11.353000-05:00   0 0 0
eebc577d-3b50-47c6-80cf-36a89f1a6d1b RR 22746 THE MICHAEL LEWAN COMPANY 129618 GUARDIAN LIFE INSURANCE COMPANY OF AMERICA 2013 first_quarter 2013-01-03T18:38:12.087000-05:00   0 0 0
648fd201-c3d5-452a-80f9-9bf093545044 RR 22746 THE MICHAEL LEWAN COMPANY 129624 TRAVELERS COMPANIES INC AND SUBSIDIARIES 2013 first_quarter 2013-01-03T18:40:12.867000-05:00   0 0 0
1518f8b4-d570-4bea-a43b-0a6c0ef26cac RR 22746 THE MICHAEL LEWAN COMPANY 129619 UNITED CONCORDIA COMPANIES, INC. 2013 first_quarter 2013-01-03T18:41:13.617000-05:00   0 0 0
af723430-1a9d-44e3-9bdd-385af344dda9 RA 22746 THE MICHAEL LEWAN COMPANY 129591 THE PHOENIX COMPANIES 2013 first_quarter 2013-01-03T18:42:14.350000-05:00   1 0 0
09cc5a55-b6ba-4948-a7bc-58ad86c8f6ec RA 22746 THE MICHAEL LEWAN COMPANY 129607 IDAHO POWER 2013 first_quarter 2013-01-03T18:47:15.037000-05:00   1 0 0
8844e1ea-cc57-40a2-a7b5-c59f2c31628d RA 22746 THE MICHAEL LEWAN COMPANY 129593 ORACLE CORPORATION 2013 first_quarter 2013-01-03T18:49:15.863000-05:00   1 0 0
f2dab79b-ec42-437a-ba5f-a1f36744b3c4 RA 22746 THE MICHAEL LEWAN COMPANY 129601 MUTUAL OF OMAHA 2013 first_quarter 2013-01-03T18:50:16.580000-05:00   1 0 0
b86f4760-1afb-423b-8661-f7293966c631 RR 22781 LEWIS-BURKE ASSOCIATES, LLC 129680 HUMAN FACTORS AND ERGONOMICS SOCIETY 2013 first_quarter 2013-01-04T12:38:21.500000-05:00   0 0 0
4d604e18-2b92-4fe0-897c-0908a00bd87f RR 292573 MCALLISTER & QUINN, LLC 178206 ATMI CORPORATION 2013 first_quarter 2013-01-04T14:55:00.663000-05:00   0 0 0
4293775c-1b07-4589-9e8f-43f52b7ca7f0 RR 292573 MCALLISTER & QUINN, LLC 178207 AMERICAN AVIONIC TECHNOLOGY CORPORATION 2013 first_quarter 2013-01-04T15:00:03.003000-05:00   0 0 0
240a07e3-397f-4348-bed5-6adafc0d0d48 RR 292573 MCALLISTER & QUINN, LLC 178208 MASSIF 2013 first_quarter 2013-01-04T15:07:05.453000-05:00   0 0 0
b815337a-f848-4ce0-b859-0baa788b2912 RA 400790382 BOB RILEY & ASSOCIATES 195326 EADS NORTH AMERICA, INC. 2013 first_quarter 2013-01-04T15:15:10.233000-05:00   1 0 0
5c32d4a1-5daa-472d-b79e-387be56ef7bc RA 400790382 BOB RILEY & ASSOCIATES 195328 AUSTAL USA, LLC 2013 first_quarter 2013-01-04T15:26:14.337000-05:00   1 0 0
feede876-041d-47fc-9bac-9d088bc569df RA 400790382 BOB RILEY & ASSOCIATES 195321 VT SYSTEMS, INC. 2013 first_quarter 2013-01-04T15:49:17.217000-05:00   1 0 0
8fc714e6-611b-4739-9ffe-55991f37ae38 RA 22746 THE MICHAEL LEWAN COMPANY 129591 THE PHOENIX COMPANIES 2013 first_quarter 2013-01-04T17:02:31.173000-05:00   1 0 0
ae0e4451-7c7e-43f5-9d8b-9d370462d8f9 RR 60550 STRATEGIC MARKETING INNOVATIONS 161246 AMERICAN ENGINEERING AND MANUFACTURING 2013 first_quarter 2013-01-07T15:01:33.397000-05:00   0 0 0
dfa712ca-ff4d-46ad-8521-85fa0da2a175 RR 60550 STRATEGIC MARKETING INNOVATIONS 161248 GAUTIER STELL, LTD. & GAUTIER SPECIALTY METALS, LLC 2013 first_quarter 2013-01-07T15:08:36.097000-05:00   0 0 0
07b0e788-6c3e-4d15-b135-d9da5dd61ecc RA 400728185 COMMERCE BANK 194756 COMMERCE BANK 2013 first_quarter 2013-01-07T16:15:14.007000-05:00   1 0 0
ac0f3513-e306-4e19-a0cb-d2b57d1dd89d RA 27720 EASTERSEALS, INC 134315 EASTERSEALS, INC. 2013 first_quarter 2013-01-08T11:50:37.107000-05:00   1 0 0
2bb8335c-2829-44c1-9244-824c75512156 RR 7257 BROWNSTEIN HYATT FARBER SCHRECK, LLP 110085 CHRYSALIS HOLDINGS, INC. (D.B.A. NEWDAY) 2013 first_quarter 2013-01-08T15:07:47.060000-05:00   0 0 0
f76932c0-c680-40ec-88a5-e3127ab8b27d RR 284573 CARDENAS PARTNERS, LLC 175397 ASSOCIATION OF POOL AND SPA PROFESSIONALS 2013 first_quarter 2013-01-08T15:09:48.730000-05:00   0 0 0
be90c031-32b1-417f-854e-e27b85de5515 RR 401010854 ALLIANCE FOR AGING RESEARCH 196811 ALLIANCE FOR AGING RESEARCH 2013 first_quarter 2013-01-08T15:26:01.443000-05:00   0 0 0
995503b0-d75e-4187-ae72-bc74e295769d Q1Y 400552654 BALLARD SPAHR LLP 192791 MONTGOMERY COUNTY, MARYLAND 2013 first_quarter 2013-01-08T15:27:04.380000-05:00   0 0 0
a7d980a5-16dc-4228-b0dc-127706e05a0f RR 401009848 RPS ADVOCACY, LLC 196798 COALITION FOR FAIR PARTICIPATION AND COVERAGE 2013 first_quarter 2013-01-08T16:04:37.320000-05:00   0 0 0
845a8d5c-812b-4702-b439-c48e6cbeb4e0 RR 305635 MONUMENT STRATEGIES, LLC 181591 PATRIOT TAXIWAY INDUSTRIES 2013 first_quarter 2013-01-08T16:12:41.863000-05:00   0 0 0
e278997a-53e9-4d51-9ae1-514fba2d77de RR 40025213 ALEXANDER, BOROVICKA & O'SHEA GOVERNMENT SOLUTIONS (FKA ALEXANDER & BOROVICKA GO 188127 SWEDISH AMERICAN HEALTH SYSTEM 2013 first_quarter 2013-01-08T16:14:43.317000-05:00   0 0 0
c70801df-89e9-4e61-a354-c93ff7c1fd78 RR 400534596 THORN RUN PARTNERS 192526 GREENBERRY INDUSTRIAL 2013 first_quarter 2013-01-09T09:59:52.280000-05:00   0 0 0
91349811-fb68-4b18-b211-5a45e4f9ca76 RR 24486 MCGUIREWOODS CONSULTING (A SUBSIDIARY OF MCGUIREWOODS LLP) 132273 AMERICAN TRANSMISSION COMPANY 2013 first_quarter 2013-01-09T10:12:52.820000-05:00   0 0 0
83f53f53-481a-435d-9c04-7ff5777a474e RR 400565690 56 CMD (FORMERLY KNOWN AS BENJAMIN SHRODINGER LLC) 192903 BRAC GLOBAL 2013 first_quarter 2013-01-09T16:12:21.623000-05:00   0 0 0
c7ec3485-ec66-4df5-8f63-4e2a2fad866c RR 287155 KATHARINE ARMSTRONG, INC. 176596 NATURAL RESOUCES SOLUTIONS, L.C. 2013 first_quarter 2013-01-09T16:33:11.240000-05:00   0 0 0
7c0e400f-bab8-45ee-9898-479f1c764eee RR 401008845 MR. VINCENT A. PANVINI 196797 PHRMA 2013 first_quarter 2013-01-09T16:45:25.330000-05:00   0 0 0
6d80281e-c196-4254-b19a-97d3095fea3c RA 8316 CARMEN GROUP INCORPORATED 111644 EVANS DISTRIBUTION SYSTEMS 2013 first_quarter 2013-01-10T09:10:50.330000-05:00   1 0 0
7aeaf209-1ba4-453c-af60-d052708bdd88 RR 401011856 KIRK FERRELL 196817 ELI LILLY AND COMPANY 2013 first_quarter 2013-01-10T17:54:35.883000-05:00   0 0 0
bfca2bb1-4260-4ea1-9df0-4f94bdc8afa9 RR 39837 VAN SCOYOC ASSOCIATES 148456 KRONOS INCORPORATED 2013 first_quarter 2013-01-11T12:23:25.873000-05:00   0 0 0
6c5f7b3a-72ff-48fb-8a53-3f60f634efd4 RR 47198 WHEAT GOVERNMENT RELATIONS 154738 COUNCIL OF GRADUATE SCHOOLS 2013 first_quarter 2013-01-11T13:11:34.620000-05:00   0 0 0
12305bd4-4790-4654-994e-37942a630e5d RR 314911 POLSINELLI PC 185197 CARPET & RUG INSTITUTE 2013 first_quarter 2013-01-11T14:32:48.803000-05:00   0 0 0
082228ea-4253-4c42-8458-f9eab7dc6055 RR 76992 CGCN GROUP, LLC 169751 JPMORGAN CHASE & CO 2013 first_quarter 2013-01-11T21:22:10.027000-05:00   0 0 0
588f0d50-da1a-4016-9ad1-33d77f66d465 RR 84673 HART HEALTH STRATEGIES 172494 AMERICAN PODIATRIC MEDICAL ASSOCIATION 2013 first_quarter 2013-01-13T15:49:57.980000-05:00   0 0 0
463087ad-26f3-4d2c-8e51-c67b20a94fdf RR 401014864 PETER BLOCKLIN 196839 INSTITUTE OF INTERNATIONAL BANKERS 2013 first_quarter 2013-01-14T10:22:29.807000-05:00   0 0 0
56a513af-0670-4bba-a42c-b4d01c955753 RR 33124 GRAY & OSCAR, LLC (FORMERLY BOB GRAY, LLC) 141496 INTERNATIONAL UNION OF PAINTERS AND ALLIED TRADES 2013 first_quarter 2013-01-14T11:47:29.647000-05:00   0 0 0
f77b0c69-8d95-429a-a17d-0430ae86635a RR 39837 VAN SCOYOC ASSOCIATES 148460 MACERICH 2013 first_quarter 2013-01-14T13:24:25.270000-05:00   0 0 0
723d82b7-3f8e-48ae-b863-87c6d4d7b266 RR 400406912 ENGAGE, LLC 190259 HALLMARK CARDS, INC. 2013 first_quarter 2013-01-14T13:36:39.550000-05:00   0 0 0
0833aec4-3914-4949-8f76-2baa070e5f91 RA 53538 SUSAN STOHR 158420 VILLAGE OF ROCKVILLE CENTRE 2013 first_quarter 2013-01-14T16:19:07.217000-05:00   1 0 0
a013676c-437b-4475-a97c-7523cddcc483 RR 314911 POLSINELLI PC 185195 ELEKTA INC. 2013 first_quarter 2013-01-14T17:32:20.217000-05:00   0 0 0
93124a4f-868e-4f08-84d8-2c03f160f5e0 RR 40002018 CANSLER CONSULTING, LLC 187449 CARE CONCEPTS LA, INC. 2013 first_quarter 2013-01-15T05:06:05.193000-05:00   0 0 0
4edd683c-4fe4-496f-b40c-e7c1fb4280ed RR 307034 MILLER & WENHOLD CAPITOL STRATEGIES 182215 CAREPAYMENT TECHNOLIGIES, INC. 2013 first_quarter 2013-01-15T07:57:07.520000-05:00   0 0 0
04a7ca4b-98b0-4917-8f6d-f84e11f42406 RA 41454 WILLIAMS AND JENSEN, PLLC 151518 CONCHO RESOURCES, INC. 2013 first_quarter 2013-01-15T08:53:32.870000-05:00   1 0 0
7534421d-1afd-4ccc-82cb-5d23e2e2a875 RR 308811 LNE GROUP 183084 MICHELMAN, INC. 2013 first_quarter 2013-01-15T09:29:49.510000-05:00   0 0 0
b121f737-8293-4b2d-a131-e647f58668db RR 283732 PAUL MARCONE & ASSOCIATES, LLC 175003 SUSTAINABLE MARINE INFRASTRUCTURE 2013 first_quarter 2013-01-15T10:09:21.087000-05:00   0 0 0
a68a61b2-173e-44bd-81d4-94bdf8f76ee8 RR 308811 LNE GROUP 183086 MCKEE FOODS 2013 first_quarter 2013-01-15T10:29:46.167000-05:00   0 0 0
0ce7b21d-49cf-4e6c-9670-1ad5cfe791f7 RR 300572 CG TECHNOLOGIES INC. 180401 EDGE INVESTMENT INC. 2013 first_quarter 2013-01-15T11:35:53.943000-05:00   0 0 0
48e25110-6a59-46d3-a1cc-1c3b3d3848af 1A 400758263 THE TUGGEY GROUP, LLP F/K/A TUGGEY MCCUTCHEON, LLP 194970 SAN ANTONIO RIVER AUTHORITY 2013 first_quarter 2013-01-15T15:39:50.237000-05:00   1 0 0
d17cbca3-364b-419b-b713-80bb994c98ad RR 400711132 THE PICARD GROUP, LLC 194508 CITY OF SCOTT 2013 first_quarter 2013-01-15T15:42:55.093000-05:00   0 0 0
1aac7142-9a8e-44e7-ba07-663fcbe1063e 1A 400758263 THE TUGGEY GROUP, LLP F/K/A TUGGEY MCCUTCHEON, LLP 194967 TEXAS AGGREGATES AND CONCRETE ASSOCIATION 2013 first_quarter 2013-01-15T15:50:03.343000-05:00   1 0 0
fe6d2774-0d5b-4ac2-bab5-4215ffd71aa5 1TY 36413 SRG & ASSOCIATES 145450 MILLIKEN & COMPANY 2013 first_quarter 2013-01-15T18:00:07.090000-05:00   0 0 1
012b7607-dae4-492f-a690-96c57102eaed RR 5073 DALRYMPLE & ASSOCIATES, LLC 105004 INTERCELL INC VALNEVA 2013 first_quarter 2013-01-16T08:47:54.857000-05:00   0 0 0
8d88c857-2e4e-49e5-b59e-326d6efe489b RR 400867541 DUANE MORRIS GOVERNMENT STRATEGIES 195803 PA NANOMATERIALS COMMERCIALIZATION CENTER 2013 first_quarter 2013-01-16T11:06:14.107000-05:00   0 0 0
30a03efa-bb3b-40ec-839d-7fb78c156fce RR 400867541 DUANE MORRIS GOVERNMENT STRATEGIES 195801 SDLC PARTNERS 2013 first_quarter 2013-01-16T11:09:18.667000-05:00   0 0 0
f649c876-5dfd-4cfe-bfc7-d42f3af89004 RR 401012858 OHIO NATIONAL GUARD ASSOCIATION 196818 OHIO NATIONAL GUARD ASSOCIATION 2013 first_quarter 2013-01-16T11:29:57.183000-05:00   0 0 0
65e118a4-2354-4b8e-8619-a4203f3f29b9 RR 11388 CROWELL GLOBAL ADVISORS 115649 E.I. DU PONT DE NEMOURS & CO. 2013 first_quarter 2013-01-16T11:50:14.510000-05:00   0 0 0
3c416cbb-8cb1-474b-a1d4-16fcb0d582ec RR 314738 GORDON THOMAS HONEYWELL GOVERNMENTAL AFFAIRS 185062 F5 2013 first_quarter 2013-01-16T13:39:23.040000-05:00   0 0 0
a1031fd1-2149-4740-a366-a382db558943 RR 400275281 LIBERTY PARTNERS GROUP, LLC 188722 AFROC 2013 first_quarter 2013-01-16T16:53:00.497000-05:00   0 0 0
98799c6f-e667-44e4-9c9f-40359b560966 RR 294930 THE WASHINGTON TAX & PUBLIC POLICY GROUP 178999 INTEL CORPORATION 2013 first_quarter 2013-01-16T18:21:07.667000-05:00   0 0 0
603386a3-6d2b-4e50-ae55-fde9732373d4 RR 17443 HANCE SCARBOROUGH 123125 ALLIANCE OF INDEPENDENT PHARMACISTS - TEXAS 2013 first_quarter 2013-01-16T18:22:09.133000-05:00   0 0 0
cfddee7f-8de6-4088-a183-df11ca11ccbf RR 401014866 THE INTERNET ASSOCIATION 196858 THE INTERNET ASSOCIATION 2013 first_quarter 2013-01-16T21:03:53.237000-05:00   0 0 0
3220f609-f840-4092-aaf4-cbce7b505bad RR 39837 VAN SCOYOC ASSOCIATES 148461 VESSELVANGUARD 2013 first_quarter 2013-01-17T05:09:05.223000-05:00   0 0 0
ab761885-1996-4f12-8877-a9ddf62f85e0 RR 48827 OGR 155944 MEDIMMUNE 2013 first_quarter 2013-01-17T10:10:10.333000-05:00   0 0 0
9f983ed8-321f-40ae-8852-651c42cdb67e RA 400947737 STEPHANIE MERCIER 196372 UNITED EGG PRODUCERS 2013 first_quarter 2013-01-17T11:28:36.183000-05:00   1 0 0
d79ac5d8-05d0-41a2-b1eb-c84d6b04bd5b RR 401016871 REPUBLIC CONSULTING, LLC 196861 AMGEN USA INC. 2013 first_quarter 2013-01-17T12:37:28.073000-05:00   0 0 0
5f40d05b-09ca-4425-8f5a-33bba1c9d252 RR 401016871 REPUBLIC CONSULTING, LLC 196864 CONNECTED NATION DEVELOPMENT CORPORATION 2013 first_quarter 2013-01-17T13:31:33.790000-05:00   0 0 0
675e90e1-70b6-4674-9970-51c981d7bb25 RR 401016871 REPUBLIC CONSULTING, LLC 196862 NATIONAL CABLE AND TELECOMMUNICATIONS ASSOCIATION 2013 first_quarter 2013-01-17T13:36:34.900000-05:00   0 0 0
da530cf3-f460-4875-a662-c78ddecce5f6 RR 400278335 PHILIP W. JOHNSTON ASSOCIATES 188867 LUMARA HEALTH (FKA KV PHARMACEUTICAL COMPANY) 2013 first_quarter 2013-01-17T14:29:10.853000-05:00   0 0 0
54ef6536-106f-4d30-a06b-5f843885932a RR 401016871 REPUBLIC CONSULTING, LLC 196865 PILLGUARD (FORMERLY KNOWN AS RAMM TECHNOLOGIES) 2013 first_quarter 2013-01-17T15:09:25.993000-05:00   0 0 0
6f512477-25da-40c5-a285-0dd63e0f982c RR 401016871 REPUBLIC CONSULTING, LLC 196866 R.J. CORMAN RAILROAD GROUP 2013 first_quarter 2013-01-17T15:13:29.303000-05:00   0 0 0
c5a0a909-d6ea-4f67-aa39-9b51a774e760 RR 47201 WILLIAMS MULLEN 154750 OWENS & MINOR 2013 first_quarter 2013-01-17T15:14:33.510000-05:00   0 0 0
f88c3495-ba68-4277-ab45-53dfefa67e99 RR 401016871 REPUBLIC CONSULTING, LLC 196867 UNITED PARCEL SERVICE 2013 first_quarter 2013-01-17T15:52:44.337000-05:00   0 0 0
7d9da7c9-1e70-4d7b-868e-31b1dd3cdfa5 RA 39815 VAN NESS FELDMAN, LLP 147342 BARRON COLLIER COMPANY 2013 first_quarter 2013-01-17T15:56:32.947000-05:00   1 0 0
67c85085-2fed-4a7b-bdaf-e6f806e30dc1 RR 401016871 REPUBLIC CONSULTING, LLC 196868 BATES CAPITOL GROUP (ON BEHALF OF BROWN-FORMAN CORPORATION) 2013 first_quarter 2013-01-17T16:29:09.383000-05:00   0 0 0
c1907c17-4143-4af5-a140-945a92bd1e41 RA 41727 ALLIANT ENERGY CORPORATION 152205 ALLIANT ENERGY CORPORATION 2013 first_quarter 2013-01-17T16:43:37.727000-05:00   1 0 0
c3888d09-be09-4de9-9c3b-ad0e7df97783 RR 401016871 REPUBLIC CONSULTING, LLC 196869 BATES CAPITOL GROUP, INC. (ON BEHALF OF LG&E AND KU ENERGY LLC) 2013 first_quarter 2013-01-17T16:51:23.197000-05:00   0 0 0
04a20275-da1d-4b44-ad3e-733092d302db RA 41113 WEXLER | WALKER, A UNIT OF HILL+KNOWLTON STRATEGIES, LLC 150677 SPORTS AND FITNESS INDUSTRY ASSOC. (FORMER SPORTING GOODS MANUFACTURERS ASSOC.) 2013 first_quarter 2013-01-17T18:40:33.770000-05:00   1 0 0
27846078-b49d-4f4c-a0f2-607203d632ec RR 400826452 PORTER GORDON SILVER COMMUNICATIONS, LLC 195528 LAS VEGAS CHAMBER OF COMMERCE 2013 first_quarter 2013-01-18T09:08:35.620000-05:00   0 0 0
00ee654b-825e-4b02-8237-67f584846342 RR 7257 BROWNSTEIN HYATT FARBER SCHRECK, LLP 110086 NEW YORK CITY REGIONAL CENTER 2013 first_quarter 2013-01-18T09:34:46.417000-05:00   0 0 0
c3343c2a-ba35-4c2a-b4e5-8f10ef22d5a9 RR 401016871 REPUBLIC CONSULTING, LLC 196870 BATES CAPITOL GROUP, INC. (ON BEHALF OF U.S. CHAMBER OF COMMERCE-ILR) 2013 first_quarter 2013-01-18T10:41:11.187000-05:00   0 0 0
8d98a045-1c9f-43ec-af84-610d8fecc36f RR 401016871 REPUBLIC CONSULTING, LLC 196871 BIOTECHNOLOGY INDUSTRY ORGANIZATION 2013 first_quarter 2013-01-18T10:47:14.470000-05:00   0 0 0
d83f009b-14a6-481e-af2c-e5ec4788f2a1 RR 44812 FIERCE, ISAKOWITZ & BLALOCK 153433 METLIFE GROUP, INC. 2013 first_quarter 2013-01-18T10:50:18.403000-05:00   0 0 0
d2917d80-9bf5-4186-bc42-a3f93472c926 RR 400816427 D SQUARED TAX STRATEGIES, LLC 195487 AFTON CHEMICAL CORPORATION 2013 first_quarter 2013-01-18T11:12:31.860000-05:00   0 0 0
80e12dce-9b59-4e37-8b27-800675e419b7 RR 285871 NELSON MULLINS RILEY & SCARBOROUGH 176304 ALLEN-VANGUARD CORPORATION 2013 first_quarter 2013-01-18T12:50:00.887000-05:00   0 0 0
61506423-f386-4124-ab9f-db3c14b9f0a6 RR 401008846 SYNERGY CONSUMER DATA CONCEPTS 196801 SYNERGY CONSUMER DATA CONCEPTS 2013 first_quarter 2013-01-18T12:55:25.577000-05:00   0 0 0
b3fb9d7f-4c9d-4814-8ae0-fbd2c4371645 RR 285255 STRATEGIC HEALTH CARE 175917 CRAIG HOSPITAL 2013 first_quarter 2013-01-18T13:27:06.347000-05:00   0 0 0
cbc1f2ee-cdd5-4b2b-8400-793810199abe RR 400697080 VANDOR STRATEGIES, LLC 194345 AMERICAN PUBLIC TRANSPORTATION ASSOCIATION 2013 first_quarter 2013-01-18T13:51:48.860000-05:00   0 0 0
e9105655-c164-4558-8544-e32148397f81 RR 76491 WITT O'BRIEN'S, LLC (F/K/A WITT GROUP HOLDINGS, LLC) 168931 CHICAGO BRIDGE & IRON COMPANY N V (CB&I) F/K/A SHAW GROUP 2013 first_quarter 2013-01-18T13:59:40.190000-05:00   0 0 0
f68e9fb8-b534-4585-b16c-8051ef55ea78 RR 401016871 REPUBLIC CONSULTING, LLC 196873 ALLIANCE OF AUTOMOBILE MANUFACTURERS 2013 first_quarter 2013-01-18T15:18:00.960000-05:00   0 0 0
b8ce08a8-0da5-4dc4-a7c2-e68704d21246 RR 285255 STRATEGIC HEALTH CARE 175921 CENTRACARE HEALTH SYSTEM 2013 first_quarter 2013-01-18T15:19:03.693000-05:00   0 0 0

Next page

Advanced export

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

CSV options: 

CREATE TABLE lobbying_filings (
    filing_uuid TEXT PRIMARY KEY,
    filing_type TEXT NOT NULL,
    registrant_id INTEGER,
    registrant_name TEXT,
    client_id INTEGER,
    client_name TEXT,
    filing_year INTEGER,
    filing_period TEXT,
    received_date TEXT,
    amount_reported REAL,
    is_amendment INTEGER DEFAULT 0,
    is_no_activity INTEGER DEFAULT 0,
    is_termination INTEGER DEFAULT 0
);
CREATE INDEX idx_lobby_filing_type ON lobbying_filings(filing_type);
CREATE INDEX idx_lobby_client ON lobbying_filings(client_name);
CREATE INDEX idx_lobby_year ON lobbying_filings(filing_year);