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 Donations

jsiv-zh9rCity Government10 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 donations made to legal defense trusts in accordance with the City's Legal Defense Trusts Law. Specifically, it includes the names and addresses of all persons who made a donation of $100 or more; the date of the donation; the value of the donation; and, if applicable, a description of an in-kind donation or pro bono assistance. 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

A94.1 / 100

From a 500-row sample across 9 columns.

completeness100/ 25% weight
consistency83/ 20% weight
accuracy91/ 20% weight
timeliness94/ 15% weight
usability100/ 20% weight
  • · Has geographic keys — joinable to other NYC datasets

Related datasets

  • Legal Defense Trust Refunded Donations0.71
    joins oncitylast_namestate+2
  • Legal Defense Trust Expenditures0.66
    joins oncitystateamount+1
  • Donations to Not-for-Profit Organizations Affiliated with Elected Officials0.39
    joins ondate_of_donation
  • Official Fundraising by City Agencies0.33
  • Donations Received by City Agencies0.30
  • Civil Service List (Terminated)

Geography

Has zip codes (`zip_code`) — joinable, but needs boundary shapes to draw.

Sample rows

trust_namedonation_nameamountdate_of_donationfirst_namelast_namecitystatezip_code
Eric Adams Legal Defense TrustLDT_Don-0000000085000.002023-12-01T00:00:00.000OlgaRovtBrooklynNew York - NY11234
Eric Adams Legal Defense TrustLDT_Don-0000000092500.002023-12-01T00:00:00.000HermanLebovitch

Columns

10 queryable · 10 profiled

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

FieldTypeDescriptionNullValues
trust_namecategoricalThe name of the legal defense trust that received the donation0%Eric Adams Legal Defense…Susan Zhuang Legal Defen…of 2
donation_nametextUnique identifying number for the donation0%LDT_Don-000000065LDT_Don-000000550LDT_Don-000000812
descriptiontextDescription if the donation is an in-kind donation or pro bono assistance100%—
amountintegerValue of the donation0%5000.002500.001000.00

Query this from your own app

GET /api/datasets/jsiv-zh9r
GET /api/datasets/jsiv-zh9r/quality
GET /api/datasets/jsiv-zh9r/related
GET /api/columns?dataset=jsiv-zh9r
0.30
joins onlast_namefirst_name
  • Civil Service List Certification0.30
    joins onlast_namefirst_name
  • DSNY Monthly Tonnage Data0.30
    • Brooklyn
    New York - NY
    11234
    Eric Adams Legal Defense TrustLDT_Don-0000000115000.002023-12-01T00:00:00.000MaxwellRovtBrooklynNew York - NY11234
    Eric Adams Legal Defense TrustLDT_Don-0000000125000.002023-12-01T00:00:00.000PhilipRothBal HalbourFlorida - FL33154
    Eric Adams Legal Defense TrustLDT_Don-0000000135000.002023-12-01T00:00:00.000AnthonyClemenzaBrooklynNew York - NY11234
    Eric Adams Legal Defense TrustLDT_Don-0000000145000.002023-12-01T00:00:00.000SaraMalyshevBal HarbourFlorida - FL33154
    Eric Adams Legal Defense TrustLDT_Don-0000000155000.002023-12-01T00:00:00.000AlexanderRovtBrooklynNew York - NY11234
    Eric Adams Legal Defense TrustLDT_Don-0000000165000.002023-12-01T00:00:00.000NurjahanBegumMassapequaNew York - NY11758
    Eric Adams Legal Defense TrustLDT_Don-0000000175000.002023-12-01T00:00:00.000TanzilaKhanMassapequaNew York - NY11758
    Eric Adams Legal Defense TrustLDT_Don-0000000195000.002023-12-01T00:00:00.000MunmunBariDix HillsNew York - NY11746
    date_of_donation
    datetime
    Date the donation was made
    0%
    2024-11-16T00:00:00.0002024-11-17T00:00:00.0002023-12-12T00:00:00.000
    first_nametextDonor's first name0%MichaelDavidJoseph
    last_nametextDonor's last name0%CHENLINChen
    citytextDonor's city0%BROOKLYNNew YorkBrooklyn
    statecategoricalDonor's state0%New York - NYFlorida - FLNew Jersey - NJof 19
    zip_codetextDonor's Zip Code0%112141122311204