Lobbyist Data - Lobbyist Registry - 2012 to present (Deprecated October 2015)

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.cityofchicago.org
Id ypez-j3yg
Name Lobbyist Data - Lobbyist Registry - 2012 to present (Deprecated October 2015)
Attribution City of Chicago
Category Ethics
Tags lobbyists, ethics, deprecated
Created 2012-06-06T19:26:31Z
Publication Date 2016-12-09T10:34:31Z

Description

OUTDATED. See similar current data at https://data.cityofchicago.org/d/tq3e-t5yq – All lobbyist registration filings submitted to the Board of Ethics beginning with the 2012 reporting period. / All lobbyists must register with the City of Chicago Board of Ethics by filing a Statement of Registration within five business days of engaging in lobbying activity and annually thereafter by January 20th. Lobbyist registration information is submitted to the Board of Ethics in paper form and is available in its entirety in the Board’s offices. The Board has, since 2000, compiled and posted static lists of all lobbyists and their clients online. Previous policy did not require the Board of Ethics to prioritize the reporting of all data available from paper filings. From this point forward, the Board of Ethics will electronically compile more data about lobbyists and their activities and automatically report this information online.

Columns

| Included | Schema Type    | Field Name                    | Name                          | Data Type     | Render Type   |
| ======== | ============== | ============================= | ============================= | ============= | ============= |
| No       |                | filing_year                   | FILING YEAR                   | number        | number        |
| Yes      | series tag     | lobbyist_id                   | LOBBYIST ID                   | text          | number        |
| Yes      | series tag     | lobbyist_salutation           | LOBBYIST SALUTATION           | text          | text          |
| Yes      | series tag     | lobbyist_last_name            | LOBBYIST LAST NAME            | text          | text          |
| Yes      | series tag     | lobbyist_first_name           | LOBBYIST FIRST NAME           | text          | text          |
| Yes      | series tag     | lobbyist_middle_initial       | LOBBYIST MIDDLE INITIAL       | text          | text          |
| No       |                | lobbyist_address              | LOBBYIST ADDRESS              | text          | text          |
| No       |                | lobbyist_address_2            | LOBBYIST ADDRESS 2            | text          | text          |
| Yes      | series tag     | lobbyist_city                 | LOBBYIST CITY                 | text          | text          |
| Yes      | series tag     | lobbyist_state                | LOBBYIST STATE                | text          | text          |
| Yes      | series tag     | lobbyist_zip                  | LOBBYIST ZIP                  | text          | number        |
| Yes      | series tag     | lobbyist_country              | LOBBYIST COUNTRY              | text          | text          |
| Yes      | series tag     | lobbyist_phone                | LOBBYIST PHONE                | text          | text          |
| Yes      | series tag     | lobbyist_fax                  | LOBBYIST FAX                  | text          | text          |
| Yes      | series tag     | lobbyist_email                | LOBBYIST EMAIL                | text          | text          |
| Yes      | series tag     | email                         | EMAIL                         | text          | text          |
| Yes      | series tag     | employer_name                 | EMPLOYER NAME                 | text          | text          |
| No       |                | employer_address              | EMPLOYER ADDRESS              | text          | text          |
| No       |                | employer_address_2            | EMPLOYER ADDRESS 2            | text          | text          |
| Yes      | series tag     | employer_city                 | EMPLOYER CITY                 | text          | text          |
| Yes      | series tag     | employer_state                | EMPLOYER STATE                | text          | text          |
| Yes      | series tag     | employer_zip                  | EMPLOYER ZIP                  | text          | number        |
| Yes      | series tag     | employer_country              | EMPLOYER COUNTRY              | text          | text          |
| Yes      | series tag     | employer_phone                | EMPLOYER PHONE                | text          | text          |
| Yes      | series tag     | employer_fax                  | EMPLOYER FAX                  | text          | text          |
| Yes      | series tag     | correspondent_salutation      | CORRESPONDENT SALUTATION      | text          | text          |
| Yes      | series tag     | correspondent_last_name       | CORRESPONDENT LAST NAME       | text          | text          |
| Yes      | series tag     | correspondent_first_name      | CORRESPONDENT FIRST NAME      | text          | text          |
| Yes      | series tag     | correspondent_middle_initial  | CORRESPONDENT MIDDLE INITIAL  | text          | text          |
| No       |                | correspondent_address         | CORRESPONDENT ADDRESS         | text          | text          |
| No       |                | correspondent_address_2       | CORRESPONDENT ADDRESS 2       | text          | text          |
| Yes      | series tag     | correspondent_city            | CORRESPONDENT CITY            | text          | text          |
| Yes      | series tag     | correspondent_state           | CORRESPONDENT STATE           | text          | text          |
| Yes      | series tag     | correspondent_zip             | CORRESPONDENT ZIP             | text          | number        |
| Yes      | series tag     | correspondent_country         | CORRESPONDENT COUNTRY         | text          | text          |
| Yes      | series tag     | correspondent_phone           | CORRESPONDENT PHONE           | text          | text          |
| Yes      | series tag     | correspondent_fax             | CORRESPONDENT FAX             | text          | text          |
| Yes      | series tag     | correspondent_email           | CORRESPONDENT EMAIL           | text          | text          |
| Yes      | series tag     | client_name                   | CLIENT NAME                   | text          | text          |
| Yes      | series tag     | client_industry               | CLIENT INDUSTRY               | text          | text          |
| Yes      | series tag     | client_other_industry         | CLIENT OTHER INDUSTRY         | text          | text          |
| No       |                | client_address                | CLIENT ADDRESS                | text          | text          |
| No       |                | client_address_2              | CLIENT ADDRESS 2              | text          | text          |
| Yes      | series tag     | client_city                   | CLIENT CITY                   | text          | text          |
| Yes      | series tag     | client_state                  | CLIENT STATE                  | text          | text          |
| Yes      | series tag     | client_zip                    | CLIENT ZIP                    | text          | number        |
| Yes      | series tag     | client_phone                  | CLIENT PHONE                  | text          | text          |
| Yes      | numeric metric | registration_version          | REGISTRATION VERSION          | number        | number        |
| No       |                | registration_filed_date       | REGISTRATION FILED DATE       | calendar_date | calendar_date |
| No       |                | lobbyist_terminated_date      | LOBBYIST TERMINATED DATE      | calendar_date | calendar_date |
| Yes      | series tag     | lobbied_department_name       | LISTED DEPARTMENT NAME        | text          | text          |
| Yes      | series tag     | other_lobbied_department_name | OTHER LOBBIED DEPARTMENT NAME | text          | text          |
| Yes      | time           | client_contract_date          | CLIENT CONTRACT DATE          | calendar_date | calendar_date |
| Yes      | series tag     | incured_expenses              | INCURRED EXPENSES?            | text          | text          |
| Yes      | series tag     | received_compensation         | RECEIVED COMPENSATION?        | text          | text          |
| Yes      | series tag     | written_agreement             | WRITTEN AGREEMENT?            | text          | text          |

Time Field

Value = client_contract_date
Format & Zone = yyyy-MM-dd'T'HH:mm:ss

Series Fields

Excluded Fields = lobbyist_address,lobbyist_address_2,employer_address,employer_address_2,correspondent_address,correspondent_address_2,client_address,client_address_2,lobbyist_terminated_date,registration_filed_date,filing_year

Data Commands

series e:ypez-j3yg d:2012-01-01T00:00:00.000Z t:lobbyist_id=5771 t:correspondent_salutation=Ms t:lobbyist_state=IL t:correspondent_state=IL t:employer_city=Chicago t:correspondent_zip=60606 t:lobbyist_first_name=David t:lobbyist_zip=60606 t:employer_zip=60606 t:lobbied_department_name="DEPT OF HOUSING" t:employer_country="United States" t:correspondent_city=Chicago t:correspondent_country="United States" t:employer_state=IL t:lobbyist_email=dabel@williamblair.com t:employer_fax=312-236-0174 t:client_name="William Blair & Co., LLC" t:incured_expenses=Y t:lobbyist_middle_initial=A t:correspondent_fax=312-236-0174 t:lobbyist_salutation=Mr t:client_other_industry="On File with BOE" t:correspondent_phone=312-364-8078 t:employer_name="William Blair and Co." t:correspondent_last_name=Savage t:correspondent_first_name=Joan t:employer_phone=312-236-1600 t:lobbyist_phone=312-236-1600 t:lobbyist_country="United States" t:lobbyist_fax=312-236-0174 t:client_zip=60606 t:email=dabel@williamblair.com t:correspondent_email=jsavage@williamblair.com t:lobbyist_city=Chicago t:written_agreement=Y t:client_industry=OTHER t:lobbyist_last_name=Abel t:client_state=IL t:received_compensation=Y t:client_city=Chicago m:registration_version=1

series e:ypez-j3yg d:2012-01-01T00:00:00.000Z t:lobbyist_id=5746 t:correspondent_salutation=Mr t:lobbyist_state=IL t:correspondent_state=IL t:employer_city=Chicago t:correspondent_zip=60606 t:lobbyist_first_name=Michael t:lobbyist_zip=60606 t:employer_zip=60606 t:lobbied_department_name="CITY COUNCIL" t:employer_country="United States" t:correspondent_city=Chicago t:correspondent_country="United States" t:employer_state=IL t:lobbyist_email=MAAbramson@arnstein.com t:employer_fax=312-876-0288 t:client_name="Pooh-Bah Enterprises Inc" t:incured_expenses=Y t:lobbyist_middle_initial=A t:correspondent_fax=312-876-6255 t:lobbyist_salutation=Mr t:client_other_industry="On File with BOE" t:correspondent_phone=312-876-7155 t:employer_name="Arnstein & Lehr LLP" t:correspondent_last_name=Abramson t:correspondent_first_name=Michael t:employer_phone=312-876-7100 t:lobbyist_phone=312-876-7155 t:lobbyist_country="United States" t:lobbyist_fax=312-876-6255 t:client_zip=60622 t:email=MAAbramson@arnstein.com t:correspondent_email=MAAbramson@arnstein.com t:lobbyist_city=Chicago t:written_agreement=Y t:client_industry=OTHER t:lobbyist_last_name=Abramson t:client_state=IL t:received_compensation=Y t:client_city=Chicago m:registration_version=1

series e:ypez-j3yg d:2012-06-15T00:00:00.000Z t:lobbyist_id=11821 t:correspondent_salutation=Mr. t:lobbyist_state=IL t:correspondent_state=IL t:correspondent_middle_initial=R t:employer_city=Chicago t:correspondent_zip=60625 t:lobbyist_first_name=Rolando t:lobbyist_zip=60625 t:employer_zip=60625 t:lobbied_department_name="LAW DEPARTMENT" t:employer_country="United States" t:correspondent_city=Chicago t:correspondent_country="United States" t:employer_state=IL t:lobbyist_email=rolando@acostalawpc.com t:employer_fax=312-253-4440 t:client_name="1300 Exchange LLC" t:incured_expenses=Y t:lobbyist_middle_initial=R t:correspondent_fax=312-253-4440 t:lobbyist_salutation=Mr. t:correspondent_phone=312-636-6937 t:employer_name="Law Offices of Rolando R Acosta PC" t:correspondent_last_name=Acosta t:correspondent_first_name=Rolando t:employer_phone=312-636-6937 t:lobbyist_phone=312-636-6937 t:lobbyist_country="United States" t:lobbyist_fax=312-253-4440 t:client_zip=60609 t:email=rolando@acostaezgur.com t:correspondent_email=rolando@acostalawpc.com t:lobbyist_city=Chicago t:written_agreement=N t:client_industry="WASTE MANAGEMENT/RECYCLING" t:lobbyist_last_name=Acosta t:client_state=IL t:received_compensation=Y t:client_city=Chicago m:registration_version=3

Meta Commands

metric m:registration_version p:integer l:"REGISTRATION VERSION" t:dataTypeName=number

entity e:ypez-j3yg l:"Lobbyist Data - Lobbyist Registry - 2012 to present (Deprecated October 2015)" t:attribution="City of Chicago" t:url=https://data.cityofchicago.org/api/views/ypez-j3yg

property e:ypez-j3yg t:meta.view v:id=ypez-j3yg v:category=Ethics v:attributionLink=http://www.cityofchicago.org v:averageRating=0 v:name="Lobbyist Data - Lobbyist Registry - 2012 to present (Deprecated October 2015)" v:attribution="City of Chicago"

property e:ypez-j3yg t:meta.view.owner v:id=scy9-9wg4 v:profileImageUrlMedium=/api/users/scy9-9wg4/profile_images/THUMB v:profileImageUrlLarge=/api/users/scy9-9wg4/profile_images/LARGE v:screenName=cocadmin v:profileImageUrlSmall=/api/users/scy9-9wg4/profile_images/TINY v:displayName=cocadmin v:privilegesDisabled=false

property e:ypez-j3yg t:meta.view.tableauthor v:id=scy9-9wg4 v:profileImageUrlMedium=/api/users/scy9-9wg4/profile_images/THUMB v:profileImageUrlLarge=/api/users/scy9-9wg4/profile_images/LARGE v:screenName=cocadmin v:profileImageUrlSmall=/api/users/scy9-9wg4/profile_images/TINY v:roleName=administrator v:displayName=cocadmin v:privilegesDisabled=false

Top Records

| filing_year | lobbyist_id | lobbyist_salutation | lobbyist_last_name | lobbyist_first_name | lobbyist_middle_initial | lobbyist_address             | lobbyist_address_2 | lobbyist_city | lobbyist_state | lobbyist_zip | lobbyist_country | lobbyist_phone | lobbyist_fax | lobbyist_email          | email                   | employer_name                      | employer_address             | employer_address_2 | employer_city | employer_state | employer_zip | employer_country | employer_phone | employer_fax | correspondent_salutation | correspondent_last_name | correspondent_first_name | correspondent_middle_initial | correspondent_address        | correspondent_address_2 | correspondent_city | correspondent_state | correspondent_zip | correspondent_country | correspondent_phone | correspondent_fax | correspondent_email      | client_name              | client_industry            | client_other_industry | client_address       | client_address_2 | client_city | client_state | client_zip | client_phone | registration_version | registration_filed_date | lobbyist_terminated_date | lobbied_department_name          | other_lobbied_department_name | client_contract_date | incured_expenses | received_compensation | written_agreement | 
| =========== | =========== | =================== | ================== | =================== | ======================= | ============================ | ================== | ============= | ============== | ============ | ================ | ============== | ============ | ======================= | ======================= | ================================== | ============================ | ================== | ============= | ============== | ============ | ================ | ============== | ============ | ======================== | ======================= | ======================== | ============================ | ============================ | ======================= | ================== | =================== | ================= | ===================== | =================== | ================= | ======================== | ======================== | ========================== | ===================== | ==================== | ================ | =========== | ============ | ========== | ============ | ==================== | ======================= | ======================== | ================================ | ============================= | ==================== | ================ | ===================== | ================= | 
| 2012        | 5771        | Mr                  | Abel               | David               | A                       | 222 W. Adams St.             |                    | Chicago       | IL             | 60606        | United States    | 312-236-1600   | 312-236-0174 | dabel@williamblair.com  | dabel@williamblair.com  | William Blair and Co.              | 222 W. Adams St.             |                    | Chicago       | IL             | 60606        | United States    | 312-236-1600   | 312-236-0174 | Ms                       | Savage                  | Joan                     |                              | 222 W. Adams St.             |                         | Chicago            | IL                  | 60606             | United States         | 312-364-8078        | 312-236-0174      | jsavage@williamblair.com | William Blair & Co., LLC | OTHER                      | On File with BOE      | 222 W. Adams St.     |                  | Chicago     | IL           | 60606      |              | 1                    | 2012-01-01T00:00:00     |                          | DEPT OF HOUSING                  |                               | 2012-01-01T00:00:00  | Y                | Y                     | Y                 | 
| 2012        | 5746        | Mr                  | Abramson           | Michael             | A                       | 120 S. Riverside Plaza #1200 |                    | Chicago       | IL             | 60606        | United States    | 312-876-7155   | 312-876-6255 | MAAbramson@arnstein.com | MAAbramson@arnstein.com | Arnstein & Lehr LLP                | 120 S. Riverside Plaza #1200 |                    | Chicago       | IL             | 60606        | United States    | 312-876-7100   | 312-876-0288 | Mr                       | Abramson                | Michael                  |                              | 120 S. Riverside Plaza #1200 |                         | Chicago            | IL                  | 60606             | United States         | 312-876-7155        | 312-876-6255      | MAAbramson@arnstein.com  | Pooh-Bah Enterprises Inc | OTHER                      | On File with BOE      | 1531 N. Kingsbury St |                  | Chicago     | IL           | 60622      |              | 1                    | 2012-01-01T00:00:00     |                          | CITY COUNCIL                     |                               | 2012-01-01T00:00:00  | Y                | Y                     | Y                 | 
| 2012        | 11821       | Mr.                 | Acosta             | Rolando             | R                       | 2949 W Gregory St            |                    | Chicago       | IL             | 60625        | United States    | 312-636-6937   | 312-253-4440 | rolando@acostalawpc.com | rolando@acostaezgur.com | Law Offices of Rolando R Acosta PC | 2949 W Gregory St            |                    | Chicago       | IL             | 60625        | United States    | 312-636-6937   | 312-253-4440 | Mr.                      | Acosta                  | Rolando                  | R                            | 2949 W Gregory St            |                         | Chicago            | IL                  | 60625             | United States         | 312-636-6937        | 312-253-4440      | rolando@acostalawpc.com  | 1300 Exchange LLC        | WASTE MANAGEMENT/RECYCLING |                       | 4137 S Packers Ave   |                  | Chicago     | IL           | 60609      |              | 3                    | 2013-02-13T00:00:00     |                          | LAW DEPARTMENT                   |                               | 2012-06-15T00:00:00  | Y                | Y                     | N                 | 
| 2012        | 11821       | Mr.                 | Acosta             | Rolando             | R                       | 2949 W Gregory St            |                    | Chicago       | IL             | 60625        | United States    | 312-636-6937   | 312-253-4440 | rolando@acostalawpc.com | rolando@acostaezgur.com | Law Offices of Rolando R Acosta PC | 2949 W Gregory St            |                    | Chicago       | IL             | 60625        | United States    | 312-636-6937   | 312-253-4440 | Mr.                      | Acosta                  | Rolando                  | R                            | 2949 W Gregory St            |                         | Chicago            | IL                  | 60625             | United States         | 312-636-6937        | 312-253-4440      | rolando@acostalawpc.com  | 1300 Exchange LLC        | WASTE MANAGEMENT/RECYCLING |                       | 4137 S Packers Ave   |                  | Chicago     | IL           | 60609      |              | 3                    | 2013-02-13T00:00:00     |                          | HOUSING AND ECONOMIC DEVELOPMENT |                               | 2012-06-15T00:00:00  | Y                | Y                     | N                 | 
| 2012        | 11821       | Mr.                 | Acosta             | Rolando             | R                       | 2949 W Gregory St            |                    | Chicago       | IL             | 60625        | United States    | 312-636-6937   | 312-253-4440 | rolando@acostalawpc.com | rolando@acostaezgur.com | Law Offices of Rolando R Acosta PC | 2949 W Gregory St            |                    | Chicago       | IL             | 60625        | United States    | 312-636-6937   | 312-253-4440 | Mr.                      | Acosta                  | Rolando                  | R                            | 2949 W Gregory St            |                         | Chicago            | IL                  | 60625             | United States         | 312-636-6937        | 312-253-4440      | rolando@acostalawpc.com  | 1300 Exchange LLC        | WASTE MANAGEMENT/RECYCLING |                       | 4137 S Packers Ave   |                  | Chicago     | IL           | 60609      |              | 3                    | 2013-02-13T00:00:00     |                          | CITY COUNCIL / ALDERMEN          |                               | 2012-06-15T00:00:00  | Y                | Y                     | N                 | 
| 2012        | 11821       | Mr.                 | Acosta             | Rolando             | R                       | 2949 W Gregory St            |                    | Chicago       | IL             | 60625        | United States    | 312-636-6937   | 312-253-4440 | rolando@acostalawpc.com | rolando@acostaezgur.com | Law Offices of Rolando R Acosta PC | 2949 W Gregory St            |                    | Chicago       | IL             | 60625        | United States    | 312-636-6937   | 312-253-4440 | Mr.                      | Acosta                  | Rolando                  | R                            | 2949 W Gregory St            |                         | Chicago            | IL                  | 60625             | United States         | 312-636-6937        | 312-253-4440      | rolando@acostalawpc.com  | 1601 West Division LLC   | REAL ESTATE & CONSTRUCTION |                       | 1237 W. Fullerton    |                  | Chicago     | IL           | 60614      |              | 3                    | 2013-02-13T00:00:00     |                          | LAW DEPARTMENT                   |                               | 2012-06-15T00:00:00  | Y                | Y                     | N                 | 
| 2012        | 11821       | Mr.                 | Acosta             | Rolando             | R                       | 2949 W Gregory St            |                    | Chicago       | IL             | 60625        | United States    | 312-636-6937   | 312-253-4440 | rolando@acostalawpc.com | rolando@acostaezgur.com | Law Offices of Rolando R Acosta PC | 2949 W Gregory St            |                    | Chicago       | IL             | 60625        | United States    | 312-636-6937   | 312-253-4440 | Mr.                      | Acosta                  | Rolando                  | R                            | 2949 W Gregory St            |                         | Chicago            | IL                  | 60625             | United States         | 312-636-6937        | 312-253-4440      | rolando@acostalawpc.com  | 1601 West Division LLC   | REAL ESTATE & CONSTRUCTION |                       | 1237 W. Fullerton    |                  | Chicago     | IL           | 60614      |              | 3                    | 2013-02-13T00:00:00     |                          | HOUSING AND ECONOMIC DEVELOPMENT |                               | 2012-06-15T00:00:00  | Y                | Y                     | N                 | 
| 2012        | 11821       | Mr.                 | Acosta             | Rolando             | R                       | 2949 W Gregory St            |                    | Chicago       | IL             | 60625        | United States    | 312-636-6937   | 312-253-4440 | rolando@acostalawpc.com | rolando@acostaezgur.com | Law Offices of Rolando R Acosta PC | 2949 W Gregory St            |                    | Chicago       | IL             | 60625        | United States    | 312-636-6937   | 312-253-4440 | Mr.                      | Acosta                  | Rolando                  | R                            | 2949 W Gregory St            |                         | Chicago            | IL                  | 60625             | United States         | 312-636-6937        | 312-253-4440      | rolando@acostalawpc.com  | 1601 West Division LLC   | REAL ESTATE & CONSTRUCTION |                       | 1237 W. Fullerton    |                  | Chicago     | IL           | 60614      |              | 3                    | 2013-02-13T00:00:00     |                          | CITY COUNCIL / ALDERMEN          |                               | 2012-06-15T00:00:00  | Y                | Y                     | N                 | 
| 2012        | 11821       | Mr.                 | Acosta             | Rolando             | R                       | 2949 W Gregory St            |                    | Chicago       | IL             | 60625        | United States    | 312-636-6937   | 312-253-4440 | rolando@acostalawpc.com | rolando@acostaezgur.com | Law Offices of Rolando R Acosta PC | 2949 W Gregory St            |                    | Chicago       | IL             | 60625        | United States    | 312-636-6937   | 312-253-4440 | Mr.                      | Acosta                  | Rolando                  | R                            | 2949 W Gregory St            |                         | Chicago            | IL                  | 60625             | United States         | 312-636-6937        | 312-253-4440      | rolando@acostalawpc.com  | 1815 W. Division LLC     | REAL ESTATE & CONSTRUCTION |                       | 400 W Huron          |                  | Chicago     | IL           | 60654      |              | 3                    | 2013-02-13T00:00:00     |                          | LAW DEPARTMENT                   |                               | 2012-06-15T00:00:00  | Y                | Y                     | N                 | 
| 2012        | 11821       | Mr.                 | Acosta             | Rolando             | R                       | 2949 W Gregory St            |                    | Chicago       | IL             | 60625        | United States    | 312-636-6937   | 312-253-4440 | rolando@acostalawpc.com | rolando@acostaezgur.com | Law Offices of Rolando R Acosta PC | 2949 W Gregory St            |                    | Chicago       | IL             | 60625        | United States    | 312-636-6937   | 312-253-4440 | Mr.                      | Acosta                  | Rolando                  | R                            | 2949 W Gregory St            |                         | Chicago            | IL                  | 60625             | United States         | 312-636-6937        | 312-253-4440      | rolando@acostalawpc.com  | 1815 W. Division LLC     | REAL ESTATE & CONSTRUCTION |                       | 400 W Huron          |                  | Chicago     | IL           | 60654      |              | 3                    | 2013-02-13T00:00:00     |                          | HOUSING AND ECONOMIC DEVELOPMENT |                               | 2012-06-15T00:00:00  | Y                | Y                     | N                 |