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 Refunded Donations

t3pj-3dguCity Government11 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 refunded by legal defense trusts in accordance with the City's Legal Defense Trusts Law. Specifically, it includes the names and addresses of each person who donated and was refunded by the legal defense trust; the amount of the donation and refund; and the date of the donation and refund. 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

A90.7 / 100

From a 59-row sample across 11 columns.

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

Related datasets

  • Legal Defense Trust Donations0.71
    joins ontrust_namestatelast_name+2
  • Legal Defense Trust Expenditures0.64
    joins ontrust_namestatecity
  • Donations to Not-for-Profit Organizations Affiliated with Elected Officials0.35
  • NYW Bond Issuance0.31
  • Debt Issuance by Issuer0.30
  • Civil Service List Certification0.28

Geography

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

Sample rows

trust_namefirst_namelast_namecitystatezipdonation_datedonation_amountrefund_daterefund_amountdonation_number
Eric Adams Legal Defense TrustSarahPatJackson HeightsNew York - NY113722023-12-01T00:00:00.000$ 2,500.002024-01-11T00:00:00.000$ 2,500.00LDT_Don-000000021
Eric Adams Legal Defense TrustMohammad

Columns

11 queryable · 11 profiled

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

FieldTypeDescriptionNullValues
trust_nametextThe name of the legal defense trust refunding the donation0%Eric Adams Legal Defense…of 1
first_nametextFirst name of the donor being refunded0%JacobMarkMichael
last_nametextLast name of the donor being refunded0%MarcoviciDolanMiller
citytextDonor's city0%New YorkBrooklynJupiter
state

Query this from your own app

GET /api/datasets/t3pj-3dgu
GET /api/datasets/t3pj-3dgu/quality
GET /api/datasets/t3pj-3dgu/related
GET /api/columns?dataset=t3pj-3dgu
joins on
last_name
first_name
  • DSNY Monthly Tonnage Data0.28
  • Civil Service List (Terminated)0.28
    joins onlast_namefirst_name
    • Aminmian
    Jamaica
    New York - NY
    11432
    2023-12-01T00:00:00.000
    $ 1,000.00
    2024-01-11T00:00:00.000
    $ 1,000.00
    LDT_Don-000000024
    Eric Adams Legal Defense TrustAngeloAcquistaNew YorkNew York - NY100222023-11-28T00:00:00.000$ 5,000.002024-01-11T00:00:00.000$ 5,000.00LDT_Don-000000036
    Eric Adams Legal Defense TrustSonyaPurpera-ChodryNew YorkNew York - NY100242023-11-29T00:00:00.000$ 2,000.002024-03-29T00:00:00.000$ 2,000.00LDT_Don-000000038
    Eric Adams Legal Defense TrustStaceyPaschowNew YorkNew York - NY100652023-12-07T00:00:00.000$ 750.002024-01-23T00:00:00.000$ 750.00LDT_Don-000000068
    Eric Adams Legal Defense TrustSarahCayreNew YorkNew York - NY100102023-12-19T00:00:00.000$ 5,000.002024-01-19T00:00:00.000$ 5,000.00LDT_Don-000000084
    Eric Adams Legal Defense TrustTrinaCayreNew YorkNew York - NY100102023-12-19T00:00:00.000$ 5,000.002024-01-19T00:00:00.000$ 5,000.00LDT_Don-000000085
    Eric Adams Legal Defense TrustLudovicMarcoviciLido BeachNew York - NY115612024-03-15T00:00:00.000$ 5,000.002024-03-23T00:00:00.000$ 5,000.00LDT_Don-000000395
    Eric Adams Legal Defense TrustMarkMillerJupiterFlorida - FL334772024-01-23T00:00:00.000$ 5,000.002024-02-09T00:00:00.000$ 5,000.00LDT_Don-000000442
    Eric Adams Legal Defense TrustMarkMillerJupiterFlorida - FL334772024-01-23T00:00:00.000$ 5,000.002024-02-09T00:00:00.000$ 5,000.00LDT_Don-000000443
    categorical
    Donor's state
    0%
    New York - NYNew Jersey - NJFlorida - FLof 6
    ziptextDonor's Zip Code0%334771001011561
    donation_datedatetimeDate the donation was made0%2024-03-15T00:00:00.0002024-07-10T00:00:00.0002024-01-23T00:00:00.000
    donation_amountcategoricalAmount of the donation0%$ 5,000.00$ 2,000.00$ 2,500.00of 14
    refund_datedatetimeDate the refund was made0%2024-03-23T00:00:00.0002026-02-04T00:00:00.0002024-07-25T00:00:00.000
    refund_amountcategoricalAmount of the refund0%$ 5,000.00$ 2,000.00$ 2,500.00of 14
    donation_numbertextUnique identifying number for the donation0%LDT_Don-000000555LDT_Don-000000316LDT_Don-000000552