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

DCWP Payments Received

2xab-argnBusiness14 columns
This dataset represents all payments DCWP received from businesses beginning 7/1/2023 . It includes but is not limited to payments for civil penalties resulting from violations, license application fees, and inspection fees.
View on NYC Open Data↗

Quality

A91.5 / 100

From a 500-row sample across 12 columns.

completeness93/ 25% weight
consistency83/ 20% weight
accuracy88/ 20% weight
timeliness100/ 15% weight
usability95/ 20% weight

Related datasets

  • DCWP Charges0.41
    joins onbusiness_unique_idbusiness_namedba_trade_name+1
  • DCWP Fines and Fees (Historical)0.39
    joins onrecord_typefee_amountfee_status+2
  • Historical Licenses0.38
    joins onbusiness_name
  • License Applications0.36
    joins onbusiness_unique_idbusiness_namedba_trade_name
  • DCWP Consumer Complaints0.35

Sample rows

record_idrecord_typefee_sequence_numberfee_code_namefee_statuspayment_datefee_amountpayment_typepayment_amountbusiness_unique_idbusiness_name
00001-2023-AELEdcwp_licenseapplication3672646Electronic Store License FeeInvoiced2023-07-23T00:00:00.000255Payment Applied255BA-1603198-2023Test BA Business 072023
00001-2023-AELE

Columns

14 queryable · 14 profiled

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

FieldTypeDescriptionNullValues
payment_sequence_numbertextUnique Identifier for each payment on a fee.5%D0V0B7C4F6M0Q0C7J6
record_idtextAn identification number assigned by DCWP to record inspections, applications, adjudication cases, etc. For DCWP office tracking purposes.0%43233-2025-ADJC897-2022-ADJC25414-2024-ADJC
record_typecategoricalIdentifies the record type that the fee is being applied towards.0%dcwp_licenseapplicationdcwp_adjudicationdcwp_devicepaymentof 4
inspectiontextThe number of the inspection that incurred the device fee.89%

Query this from your own app

GET /api/datasets/2xab-argn
GET /api/datasets/2xab-argn/quality
GET /api/datasets/2xab-argn/related
GET /api/columns?dataset=2xab-argn
joins onbusiness_unique_idbusiness_namerecord_id
  • Issued Licenses0.35
    joins onbusiness_unique_idbusiness_namedba_trade_name
  • DCWP Inspections0.35
    joins onbusiness_unique_idbusiness_namedba_trade_name
  • Small Business Services (SBS) Equal Employment Opportunity (EO 50) Certified Businesses0.34
    joins onbusiness_name
    • dcwp_licenseapplication
    3672646
    Electronic Store License Fee
    Invoiced
    2023-07-24T00:00:00.000
    255
    Void Payment Applied
    -255
    BA-1603198-2023
    Test BA Business 072023
    10004-2023-ADJCdcwp_adjudication3680070WM - W&M ViolationInvoiced2023-09-14T00:00:00.00025Payment Applied25BA-1308469-2022GENTILE'S FINE FOODS SINCE 1927, INC.
    10008-2023-ADJCdcwp_adjudication3680098PL - Padlock ViolationInvoiced2023-09-21T00:00:00.000500Payment Applied500BA-1428491-2022ORGANIC GOURMET DELI CORP
    10008-2023-ADJCdcwp_adjudication3680099OL - Other ViolationInvoiced2023-09-21T00:00:00.0001500Payment Applied1500BA-1428491-2022ORGANIC GOURMET DELI CORP
    10008-2023-ADJCdcwp_adjudication3680100TS - State Fines (Tobacco)Invoiced2023-09-21T00:00:00.00075Payment Applied75BA-1428491-2022ORGANIC GOURMET DELI CORP
    10008-2023-ADJCdcwp_adjudication3680101SS - State Surcharge (Tobacco)Invoiced2023-09-21T00:00:00.000250Payment Applied250BA-1428491-2022ORGANIC GOURMET DELI CORP
    10011-2023-ADJCdcwp_adjudication3680008OL - Other ViolationInvoiced2023-09-21T00:00:00.000350Payment Applied350BA-1428491-2022ORGANIC GOURMET DELI CORP
    10013-2022-ADJCdcwp_adjudication3676839'TO - Tobacco OtherInvoiced2023-07-28T00:00:00.0002000Payment Applied2000BA-1318255-2022HIGHFLIX EXOTICS CORP.
    10013-2022-ADJCdcwp_adjudication3676839'TO - Tobacco OtherInvoiced2023-08-07T00:00:00.0002000Void Payment Applied-2000BA-1318255-2022HIGHFLIX EXOTICS CORP.
    INS-000963157INS-000808478INS-000741427
    fee_sequence_numbertextUnique system generated identification number for the fee item.0%384836631499233263950
    fee_code_nametextDescription of the fee item.0%SCALE TO 33 LBSTrust Fund Enrollment Fe…OL - Other Violation
    fee_statuscategoricalThe status of the fee.0%InvoicedCreditedVoidof 4
    payment_datedatetimeDate when the payment was applied to the record.0%2025-02-27T00:00:00.0002025-02-24T00:00:00.0002024-12-20T00:00:00.000
    fee_amountintegerThe total amount of the fee.0%20010050
    payment_typecategoricalThe type of transaction indicating whether payment was received, refunded, or voided.0%Payment AppliedVoid Payment Appliedof 2
    payment_amountintegerDollar amount of the payment being applied towards the fee.0%20010050
    business_unique_idtextAn identification number assigned by DCWP to track unique businesses across its systems.0%BA-1387208-2022BA-1398447-2022BA-1353670-2022
    business_nametextThe legal business name as filed with the New York State Secretary of State or County Clerk.0%SP PLUS CORPORATIONBOLLA OPERATING CORP.SPEEDWAY LLC
    dba_trade_nametextIf applicable, the Doing-Business-As (DBA), or trade name of the business.82%METROPOLISBPKEY FOOD