From a 500-row sample across 22 columns.
boroughboroughlotborougheasement+1Has borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| record_type | borough | block | lot | account_type | date_account_period_begins | date_account_period_ends | tax_class | building_class | status | transaction_records_counter | id_internal |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 00001 | 0010 | 013 | 2017-08-21 | 2017-08-21 | 4 | Y4 | 0 | 005 | 1000010010360 |
| 1 | 1 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
record_type | text | Record Type | 0% | 1of 1 |
borough | categorical | Borough where property is located | 0% | 341of 5 |
block | text | — | 0% | 000160394401833 |
lot | text | — | 0% | 000100060020 |
easement | categorical | E = Primary standard easement on the property; F thru M = more than one easements are placed on the property; A = Air Rights; B = Non Air Rights; N = Non Transit; P = Piers; R = Railroads; S = Street ; U = U.S. Government |
GET /api/datasets/paab-n3s5 GET /api/datasets/paab-n3s5/quality GET /api/datasets/paab-n3s5/related GET /api/columns?dataset=paab-n3s5
boroughlotboroughblock| 00001 |
| 0010 |
| 270 |
| 2016-07-01 |
| 2016-12-31 |
| 4 |
| Y4 |
| 0 |
| 001 |
| 1000010010360 |
| 1 | 1 | 00001 | 0010 | 270 | 2017-01-01 | 2017-06-30 | 4 | Y4 | 0 | 001 | 1000010010360 |
| 1 | 1 | 00001 | 0010 | 270 | 2017-07-01 | 2017-12-31 | 4 | Y4 | 0 | 001 | 1000010010360 |
| 1 | 1 | 00001 | 0010 | 270 | 2018-01-01 | 2018-06-30 | 4 | Y4 | 0 | 001 | 1000010010360 |
| 1 | 1 | 00001 | 0010 | 270 | 2018-07-01 | 2018-12-31 | 4 | Y4 | 0 | 001 | 1000010010360 |
| 1 | 1 | 00001 | 0010 | 270 | 2019-01-01 | 2019-06-30 | 4 | Y4 | 0 | 001 | 1000010010360 |
| 1 | 1 | 00001 | 0101 | 270 | 2016-07-01 | 2016-12-31 | 4 | P7 | 0 | 001 | 1000010101360 |
| 1 | 1 | 00001 | 0101 | 270 | 2017-01-01 | 2017-06-30 | 4 | P7 | 0 | 001 | 1000010101360 |
| 1 | 1 | 00001 | 0101 | 270 | 2017-07-01 | 2017-12-31 | 4 | P7 | 0 | 001 | 1000010101360 |
Showing 12 of 21 columns. All of them are listed below.
| 46% |
EFof 10 |
account_type | text | Numeric code to indicate the type of charge; 270 - 280 indicate Real Estate Charges | 0% | 270241231 |
id_account | text | Unique identification for selected accounts; E.g. Meter # for water charges | 41% | 40001000000000000 |
date_account_period_begins | date | Beginning data of tax period for the charge | 0% | 2018-01-012017-01-012018-07-01 |
date_account_period_ends | date | Ending date of tax period for the charge | 0% | 2019-06-302018-06-302017-06-30 |
tax_class | categorical | Property classification type used to determine the tax rate for calculating taxes | 0% | 1 12of 17 |
building_class | text | 1 = 1 - 3 Unit Residences; 1A = 1-3 Story Condominiums; 1B = Residential Vacant Land; 1C = 1-3 Unit Condominium (originally Tax Class 1); 1D = Select Bungalow Colonies;2 = Apartments;2A = Apartments with 4 - 6 Units; 2B = Apartments with 7 - 10 Units; 2C = Coops/Condos with 2 -10 Units; 3 = Utilities (Except Ceiling Rail Roads); 4A = Utilities - Ceiling Rail Roads; 4 = All Others | 0% | R4A1 A5 |
status | categorical | C = Period has a credit Balance; D = Period has a debit balance; O = period has zero balance | 0% | 0DCof 3 |
transaction_records_counter | text | The number of transaction records that exist for this period | 0% | 005004007 |
id_internal | text | Borough, block, lot, easement formatted as one number; Position 1 = Borough; Position 2 - 6 = Block; Position 7 -10 = Lot; Position 11 - 13 = Easement; Standard Easements; E = 140; F = 150 ; G = 160; H = 170; I = 180 ; J = 190; K = 200 ; L = 000, M = 000; A = 000 (Air Rights); B = 000 (Non Air Rights) ; N = 230 (Non Transit); P = 250 (Piers); R = 000 (Railroads); S = 000 (Street); U = 000 (U.S. Government); Blank = 360 (No easement) | 0% | 100972000136030146700013602051410120360 |
date_grace_period_end | date | Date after which a payment is considered late. Interest will be charged after this date. | 0% | 2019-01-152019-04-152018-04-16 |
amount_liability | coordinate | Total liability for this period | 0% | 00000000000.0000000000013.0000000000100.00 |
amount_collections | coordinate | Total collections for the period | 0% | 00000000000.0000000000013.0000000000100.00 |
amount_initial_total | coordinate | Total interest posted for this period. Interest is posted when the quarterly Statement of Account is generated or when a payment is made. The Date PI Thru Post field will give the interest calculated through date | 0% | 00000000000.0000000000004.6400000000000.01 |
amount_discount_early_pay | coordinate | Discount applied due to early payment | 0% | 00000000000.0000000000000.0100000000000.02 |
amount_balance | coordinate | Current balance due; If zero, the period is fully paid if positive, there is an outstanding liability for the period if negative, there is a credit balance for the period | 0% | 00000000000.0000000000013.0000000000068.05 |
date_update | date | Date of the last transaction for this period (equals to the process date of the last transaction) | 0% | 2018-11-162018-06-012018-08-24 |
date_due_period | date | Current due date for this period | 0% | 2017-07-012018-07-012019-01-01 |
date_penalty_and_interest | date | Interest has been forecasted through this date | 0% | 2019-01-012016-06-302017-06-29 |