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

DOF: Refund List - Real Property Tax

w5ea-ydu3City Government8 columns
Details about refund checks for overpaid Property Tax accounts. DOF issues property refund checks by request if there are tax credits on a property tax account.
View on NYC Open Data↗

Quality

A90.8 / 100

From a 500-row sample across 8 columns.

completeness100/ 25% weight
consistency63/ 20% weight
accuracy94/ 20% weight
timeliness97/ 15% weight
usability100/ 20% weight
  • · Has geographic keys — joinable to other NYC datasets

Related datasets

  • DOF: Refund List - Real property Tax0.60
    joins onbblcheck_numbercase_number
  • NYW Bond Issuance0.31
  • Debt Issuance by Issuer0.30
  • Civil List0.29
  • Property Tax Rates by Tax Class0.28
  • NYC Permitted Event Information0.28
  • Civil Service List (Terminated)0.28

Sample rows

case_numberissue_datecheck_numberbbleffective_daterefund_yearrefund_numberamount
1000012020-10-22T00:00:00.00021034141-01553-01042020-07-01T00:00:00.00020213106651128.18
1000022020-10-22T00:00:00.00021034311-01561-00092020-07-01T00:00:00.0002021310666704.72

Columns

8 queryable · 8 profiled

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

FieldTypeDescriptionNullValues
case_numbertextCASE NUMBER0%3148552034315586165
issue_datedatetimeDate Check was Issued0%2019-10-03T00:00:00.0002019-10-17T00:00:00.0002020-06-25T00:00:00.000
check_numbertextCHECK NUMBER0%ACH20119812003283
bbltextBorough Block Lot. Borough 1 = Manhattan; 2 = Bronx; 3 = Brooklyn ; 4 = Queens; 5 = Staten Island0%4-09806-00201-99999-00092-02381-1044

Query this from your own app

GET /api/datasets/w5ea-ydu3
GET /api/datasets/w5ea-ydu3/quality
GET /api/datasets/w5ea-ydu3/related
GET /api/columns?dataset=w5ea-ydu3
Legal Defense Trust Refunded Donations0.28
100003
2020-10-22T00:00:00.000
2103383
3-00154-0028
2020-07-01T00:00:00.000
2021
302354
22272.06
1000042020-10-22T00:00:00.00021034321-01561-00112020-07-01T00:00:00.00020213106671603.4
1000052020-10-22T00:00:00.00021034321-01561-00122020-07-01T00:00:00.00020213106681022.16
1000062020-10-22T00:00:00.00021034291-01562-00422020-07-01T00:00:00.0002021310669858.76
1000082020-10-22T00:00:00.00021034073-00165-00222020-07-01T00:00:00.000202130235532279.04
1000092020-10-22T00:00:00.00021034301-01568-00432020-07-01T00:00:00.0002021310670740.28
1000112020-10-22T00:00:00.00021034401-01580-00102019-07-01T00:00:00.00020213106711411.92
1000112020-10-22T00:00:00.00021034401-01580-00102020-07-01T00:00:00.00020213106721720.66
effective_datedatetimeEffective Date0%2019-07-01T00:00:00.0002020-07-01T00:00:00.0002022-07-01T00:00:00.000
refund_yeartextRefund Tax Year0%202020212023
refund_numbertext—0%381971710969251016
amountfloatAmount of the Refund0%14.940.010.02