About this Dataset

Legal Defense Trust Expenditures

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.
Organization: City of New York
Last updated: 2024-12-27T21:51:37.573707
Tags: donations, expenditures, ldt, legal-defense-trust

Tables

Table 1

@usgov.city_of_new_york_legal_defense_trust_expenditures.table_1

20.38 kB
122 rows
20 columns

CREATE TABLE table_1 (
  "trust_name" VARCHAR,
  "expenditure_name" VARCHAR,
  "amount" DOUBLE,
  "date_of_incurrence" TIMESTAMP,
  "purpose_of_expenditure" VARCHAR,
  "attested_by" VARCHAR,
  "payee_name" VARCHAR,
  "payee_address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT,
  "borough" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "community_board" DOUBLE,
  "council_district" DOUBLE,
  "bin" DOUBLE,
  "bbl" DOUBLE,
  "census_tract_2020" DOUBLE  -- Census Tract (2020),
  "neighborhood_tabulation_area_nta_2020" VARCHAR  -- Neighborhood Tabulation Area (NTA) (2020)
);