From a 500-row sample across 8 columns.
organization_namedoing_business_start_datedoing_business_start_date| mocs_peopleid | organization_name | person_name_first | person_name_middle | person_name_last | relationship_type_code | doing_business_start_date |
|---|---|---|---|---|---|---|
| 113068 | 1 JOHN STREET LLC | JARED | R | DELLA VALLE | MRP | 2013-09-09T00:00:00.000 |
| 113068 | 1 JOHN STREET LLC | JARED | R | DELLA VALLE | CEO | 2013-09-09T00:00:00.000 |
| 59904 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
mocs_peopleid | text | — | 0% | 916805419123150 |
organization_name | text | — | 0% | LEGAL SERVICES NEW YORK …MAKE THE ROAD NEW YORKTHE LEGAL AID SOCIETY |
person_name_first | text | — | 3% | MICHAELJOHNDAVID |
person_name_middle | text | — | 67% | JAM |
person_name_last |
GET /api/datasets/2sps-j9st GET /api/datasets/2sps-j9st/quality GET /api/datasets/2sps-j9st/related GET /api/columns?dataset=2sps-j9st
| 1 REWE STREET REALTY LLC |
| BENJAMIN |
| — |
| GOLDSTEIN |
| OWN |
| 2008-07-31T00:00:00.000 |
| 59905 | 1 REWE STREET REALTY LLC | DAVID | — | GOLDSTEIN | OWN | 2008-07-31T00:00:00.000 |
| 59903 | 1 REWE STREET REALTY LLC | EMERICH | — | GOLDSTEIN | CEO | 2008-07-31T00:00:00.000 |
| 59903 | 1 REWE STREET REALTY LLC | EMERICH | — | GOLDSTEIN | MED | 2008-07-31T00:00:00.000 |
| 176124 | 1 SULLIVAN RESIDENCES LLC | ARIANA | — | WIENER | MRP | 2023-10-31T00:00:00.000 |
| 176124 | 1 SULLIVAN RESIDENCES LLC | ARIANA | — | WIENER | COO | 2023-10-31T00:00:00.000 |
| 169055 | 1 SULLIVAN RESIDENCES LLC | ARTHUR | — | WEINER | CEO | 2022-03-31T00:00:00.000 |
| 169056 | 1 SULLIVAN RESIDENCES LLC | BRANDON | — | FALCHIERE | CFO | 2022-03-31T00:00:00.000 |
| text |
| — |
| 0% |
SMITHWILLIAMSLEE |
person_name_suffix | text | — | 99% | JRIIIJR. |
relationship_type_code | categorical | — | 0% | MCTCEOOWNof 14 |
doing_business_start_date | datetime | — | 0% | 2008-07-31T00:00:00.0002026-01-01T00:00:00.0002023-03-01T00:00:00.000 |
doing_business_end_date | datetime | — | 100% | — |