lobbying_filings_raw: 0ebdf1d9-5e2c-40b3-adeb-a9c8e8fae83e
This data as json
| 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 | raw_json | registrant_state | registrant_country | registrant_house_id | client_state | client_ppb_state | client_country | client_ppb_country | client_general_description | client_government_entity | affiliated_org_count | client_entity_id | client_government_unit_id | client_match_method | client_match_confidence |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0ebdf1d9-5e2c-40b3-adeb-a9c8e8fae83e | 1@ | 315513 | ROBERTI ASSOCIATES | 185388 | ORACLE AMERICA, INC. | 2012 | first_quarter | 2012-09-24T09:15:43.983000-04:00 | 40000.0 | 0 | 0 | 1 | {"url": "https://lda.senate.gov/api/v1/filings/0ebdf1d9-5e2c-40b3-adeb-a9c8e8fae83e/", "filing_uuid": "0ebdf1d9-5e2c-40b3-adeb-a9c8e8fae83e", "filing_type": "1@", "filing_type_display": "1st Quarter - Termination Amendment", "filing_year": 2012, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/0ebdf1d9-5e2c-40b3-adeb-a9c8e8fae83e/print/", "filing_document_content_type": "text/html", "income": "40000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Vincent A. Roberti Sr., Chairman", "dt_posted": "2012-09-24T09:15:43.983000-04:00", "termination_date": "2012-02-23", "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1455 Pennsylvania Avenue NW", "registrant_address_2": "Suite 250", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20004", "registrant": {"id": 315513, "url": "https://lda.senate.gov/api/v1/registrants/315513/", "house_registrant_id": 39209, "name": "ROBERTI ASSOCIATES", "description": "Lobbying House & Senate", "address_1": "1455 Pennsylvania Avenue NW", "address_2": "Suite 250", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20004", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "VINCENT A. ROBERTI, SR.", "contact_telephone": "+1 202-624-0395", "dt_updated": "2022-04-06T16:07:55.576037-04:00"}, "client": {"id": 185388, "url": "https://lda.senate.gov/api/v1/clients/185388/", "client_id": 24, "name": "ORACLE AMERICA, INC.", "general_description": "Computers/Internet", "client_government_entity": false, "client_self_select": false, "state": "DC", "state_display": "District of Columbia", "country": "US", "country_display": "United States of America", "ppb_state": "DC", "ppb_state_display": "District of Columbia", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2011-02-14"}, "lobbying_activities": [{"general_issue_code": "HOM", "general_issue_code_display": "Homeland Security", "description": "Cyber security general issues", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 836, "prefix": "mr", "prefix_display": "MR.", "first_name": "VINCENT", "nickname": null, "middle_name": "A.", "last_name": "ROBERTI, SR.", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 53530, "prefix": null, "prefix_display": null, "first_name": "MEGHAN", "nickname": null, "middle_name": null, "last_name": "JOHNSON", "suffix": null, "suffix_display": null}, "covered_position": "Chief of Staff, Rep. Linda Sanchez", "new": false}, {"lobbyist": {"id": 54452, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": null, "last_name": "WHITE", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Coordinator, Sen. John Chaffee", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "INT", "general_issue_code_display": "Intelligence", "description": "Cyber security general issues", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 836, "prefix": "mr", "prefix_display": "MR.", "first_name": "VINCENT", "nickname": null, "middle_name": "A.", "last_name": "ROBERTI, SR.", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 53530, "prefix": null, "prefix_display": null, "first_name": "MEGHAN", "nickname": null, "middle_name": null, "last_name": "JOHNSON", "suffix": null, "suffix_display": null}, "covered_position": "Chief of Staff, Rep. Linda Sanchez", "new": false}, {"lobbyist": {"id": 54452, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": null, "last_name": "WHITE", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Coordinator, Sen. John Chaffee", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TAR", "general_issue_code_display": "Tariff (miscellaneous tariff bills)", "description": "Issues relating to repatriation", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 836, "prefix": "mr", "prefix_display": "MR.", "first_name": "VINCENT", "nickname": null, "middle_name": "A.", "last_name": "ROBERTI, SR.", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 53530, "prefix": null, "prefix_display": null, "first_name": "MEGHAN", "nickname": null, "middle_name": null, "last_name": "JOHNSON", "suffix": null, "suffix_display": null}, "covered_position": "Chief of Staff, Rep. Linda Sanchez", "new": false}, {"lobbyist": {"id": 54452, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": null, "last_name": "WHITE", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Coordinator, Sen. John Chaffee", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CPI", "general_issue_code_display": "Computer Industry", "description": "S. 417, Cyber security and Internet Freedom Act, provisions relating to regulating the IT industry and supply chain. General issues involving standards for computer software, technology products, and competitiveness in the software industry. General issues involving information security, common criteria and cyber security policy.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 836, "prefix": "mr", "prefix_display": "MR.", "first_name": "VINCENT", "nickname": null, "middle_name": "A.", "last_name": "ROBERTI, SR.", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 53530, "prefix": null, "prefix_display": null, "first_name": "MEGHAN", "nickname": null, "middle_name": null, "last_name": "JOHNSON", "suffix": null, "suffix_display": null}, "covered_position": "Chief of Staff, Rep. Linda Sanchez", "new": false}, {"lobbyist": {"id": 54452, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": null, "last_name": "WHITE", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Coordinator, Sen. John Chaffee", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} | DC | US | 39209 | DC | DC | US | US | Computers/Internet | 0 | 0 | 2225569 | normalized_name_dc_fallback | 0.8 |