Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

Legal Defense Trust Expenditures

mhyv-6izaCity Government20 columns
Pursuant to the City's Legal Defense Trusts Law, found in Chapter 11 of Title 3 of the New York City Administrative Code, a public servant (or someone acting on behalf of a public servant) may set up a legal defense trust to raise funds to pay for certain legal bills and expenses connected with the public servant’s City employment. This dataset lists information about expenditures made by legal defense trusts in accordance with the City's Legal Defense Trusts Law. Specifically, it includes the names and addresses of each entity paid for expenses incurred by the legal defense trust; the amount and purpose of the expenses; and the date the expenses were incurred. For more information about legal defense trusts and the laws that govern them, visit https://www.nyc.gov/site/coib/the-law/legal-defense-trusts-law.page.
View on NYC Open Data↗

Quality

B87.6 / 100

From a 166-row sample across 20 columns.

completeness78/ 25% weight
consistency75/ 20% weight
accuracy94/ 20% weight
timeliness95/ 15% weight
usability100/ 20% weight
  • · Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

  • Legal Defense Trust Donations0.66
    joins ontrust_namecityamount+1
  • Legal Defense Trust Refunded Donations0.64
    joins ontrust_namecitystate
  • Donations to Not-for-Profit Organizations Affiliated with Elected Officials0.34
  • Civil Service List Certification0.33
  • Civil Service List (Terminated)0.33
  • Evictions0.33
    joins on

Geography

Mappable — coordinate pair `latitude` / `longitude`.

Open on the map →

Sample rows

trust_nameexpenditure_nameamountdate_of_incurrencepurpose_of_expenditureattested_bypayee_namepayee_addresscitystatepostcodeborough
Eric Adams Legal Defense TrustLDT-EXP-000000006397188.892023-12-15T00:00:00.000Legal servicesVito R. PittaWilmer Cutler Pickering Hale and Dorr LLP7 World Trade Center 250 Greenwich StreetNew YorkNew York - NY10007MANHATTAN

Columns

20 queryable · 20 profiled

The machine field names SoQL needs, with the publisher's own description of each.

FieldTypeDescriptionNullValues
trust_namecategoricalThe name of the legal defense trust making the expenditure0%Eric Adams Legal Defense…Susan Zhuang Legal Defen…of 2
expenditure_nametextUnique identifying number for the expenditure0%LDT-EXP-000000027LDT-EXP-000000128LDT-EXP-000000159
amountfloatAmount of the expenditure0%10.005000.0016.28
date_of_incurrencedatetimeDate the expenses were incurred0%2024-02-01T00:00:00.000

Query this from your own app

GET /api/datasets/mhyv-6iza
GET /api/datasets/mhyv-6iza/quality
GET /api/datasets/mhyv-6iza/related
GET /api/columns?dataset=mhyv-6iza
bbl
bin
longitude
+4
  • Civil Service List (Active)0.32
  • Off-Year and Special Elections Financial Analysis0.30
    • Eric Adams Legal Defense TrustLDT-EXP-0000000076431.642023-12-30T00:00:00.000Forensic data collectionVito R. PittaHaystack200 W. Jackson Boulevard Suite 250ChicagoIllinois - IL60606—
    Eric Adams Legal Defense TrustLDT-EXP-00000000818664.432024-01-03T00:00:00.000Vetting and investigative servicesVito R. PittaArtus GroupPO Box 62MadisonConnecticut - CT6443—
    Eric Adams Legal Defense TrustLDT-EXP-0000000092500.002023-11-30T00:00:00.000Legal servicesVito R. PittaPitta LLP120 Broadway 28th FloorNew YorkNew York - NY10271MANHATTAN
    Eric Adams Legal Defense TrustLDT-EXP-0000000105000.002023-12-31T00:00:00.000Legal servicesVito R. PittaPitta LLP120 Broadway 28th FloorNew YorkNew York - NY10271MANHATTAN
    Eric Adams Legal Defense TrustLDT-EXP-00000001130.002024-01-11T00:00:00.000Wire transfer feeVito R. PittaTD Bank211 Montague StreetBrooklynNew York - NY11201BROOKLYN
    Eric Adams Legal Defense TrustLDT-EXP-00000001230.002024-01-11T00:00:00.000Wire transfer fee.Vito R. PittaTD Bank211 Montague StreetBrooklynNew York - NY11201BROOKLYN
    Eric Adams Legal Defense TrustLDT-EXP-0000000139750.002023-12-31T00:00:00.000Fundraising servicesVito R. PittaBedford Grove LLC1 City Pt Apt. 38JBrooklynNew York - NY11201BROOKLYN
    Eric Adams Legal Defense TrustLDT-EXP-0000000145000.002024-01-31T00:00:00.000January 2024 legal feesVito R. PittaPitta LLP120 Broadway 28th FloorNew YorkNew York - NY10271MANHATTAN
    Eric Adams Legal Defense TrustLDT-EXP-0000000154541.812024-02-01T00:00:00.000Vetting and investigative servicesVito R. PittaArtus GroupPO Box 62MadisonConnecticut - CT6443—

    Showing 12 of 20 columns. All of them are listed below.

    2024-06-25T00:00:00.000
    2024-07-31T00:00:00.000
    purpose_of_expendituretextDescription of the expenses0%ACH feeLegal servicesForensic data collection
    attested_bycategoricalPerson from the legal defense trust reporting the information about the expenditure2%Vito R. PittaVito R PittaAiming Fengof 4
    payee_nametextName of entity to receive payment for expenses0%Pitta LLPTD BankHaystack
    payee_addresstextAddress of entity to receive payment for expenses0%211 Montague Street120 Broadway 28th Floor200 W. Jackson Boulevard…
    citycategoricalCity of entity to receive payment0%New YorkBrooklynChicagoof 15
    statecategoricalState of entity to receive payment0%New York - NYIllinois - ILWisconsin - WIof 7
    postcodetextZip Code of entity to receive payment0%112011027160606
    boroughcategoricalNew York City’s boroughs are five county-level administrative divisions, with each one also being a state county. (Manhattan - New York County; Bronx - Bronx County; Brooklyn - Kings County; Queens - Queens County; Staten Island - Richmond County). NYC’s boroughs have existed since the consolidation of the city in 1898.48%MANHATTANBROOKLYNQUEENSof 3
    latitudecategoricalLatitude of the site's location48%40.70854640.69385440.71322of 16
    longitudecategoricalLongitude of the site's location48%-74.011041-73.990887-74.011709of 16
    community_boardcategoricalCommunity Boards are volunteer-run neighborhood organizations that work on all kinds of issues pertinent to their communities, often working with elected city officials in doing so. Community Board members, who can be as young as 16, are appointed by Borough Presidents and City Council representatives. They serve two-year terms. There are 59 Community Boards in NYC, each of which represents a unique geographical area, known as a Community District. Note: as a column header, “Community Board” (48%101302105of 9
    council_districtcategoricalThe City Council is the lawmaking body of NYC, on equal footing with the mayor in terms of governing power. Besides legislating, the Council has sole approval power over the city budget, and is the final decision-maker in land use matters. There are 51 City Council members in total, each representing a unique geographical area, called a Council District.48%13338of 8
    bincategoricalThe BIN (Building Identification Number) is a unique 7-digit number assigned to every known building by the Department of City Planning (DCP), the first digit of which is the borough code. BINs allow city agencies to process and match building-related data easily and in a consistent manner.48%100102630020071086510of 16
    bblcategoricalThe BBL (Borough, Block, and Lot) is a combination of three numeric codes -- a 1-digit borough number, a block number (up to 5 digits) and a lot number (up to 4 digits) - designated and modified by the Department of Finance (DOF). BBLs are used by various city agencies to identify real estate for taxes, zoning, construction, and other purposes.48%100047750130024400011000840036of 16
    ct2020categoricalThe Census Tract (Census 2020) is a small, relatively permanent statistical subdivisions of a county uniquely numbered in each county with a numeric code. Please note that as part of the geocoding process, leading and trailing zeros are dropped.48%7921of 15
    nta2020categoricalThe Neighborhood Tabulation Area (Census 2020) are small area boundaries, created by the Department of City Planning (DCP) to aggregate population projections in a small area. Each NTA approximates a minimum population of 15,000. While NTAs were initially created to support PlaNYC, the thirty-year (2000-2030) sustainability plan for NYC, NTAs are now also being used to present data from the Decennial Census and American Community Survey. NTA boundaries and their associated names do not definitiv48%MN0101BK0201MN0102of 12