From a 500-row sample across 33 columns.
extractdtparidtaxyearparid| rectype | parid | code | dt_pd_begin | dt_pd_end | valclass | luc | trans_ctr | prior_owner_flag | city_owned_flag | hi_lo_int | act_install |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2045270018 | CHG | 2023-10-01T00:00:00.000 | 2023-12-31T00:00:00.000 | 1 | A5 | 002 | Y | N | L | N |
| 1 | 2045270018 | CHG |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
rectype | text | RECORD TYPE | 0% | 1of 1 |
parid | text | Parcel ID = BBLE [Borough (Length 1), Block (Length 5), Lot (Length 4), Easement (Length 1)] | 0% | 202748750120300000103040880051 |
code | categorical | Numeric code to indicate the type of charge | 0% | CHGSACSAFof 8 |
projno | text | Unique identification for special assessment charge | 83% | 24100000022410034428200001 |
GET /api/datasets/scjx-j6np GET /api/datasets/scjx-j6np/quality GET /api/datasets/scjx-j6np/related GET /api/columns?dataset=scjx-j6np
extractdtparidrectype| 2024-01-01T00:00:00.000 |
| 2024-03-31T00:00:00.000 |
| 1 |
| A5 |
| 002 |
| Y |
| N |
| L |
| N |
| 1 | 2045270018 | CHG | 2024-04-01T00:00:00.000 | 2024-06-30T00:00:00.000 | 1 | A5 | 002 | Y | N | L | N |
| 1 | 2045270019 | CHG | 2023-07-01T00:00:00.000 | 2023-09-30T00:00:00.000 | 1 | B1 | 003 | Y | N | L | N |
| 1 | 2045270019 | CHG | 2023-10-01T00:00:00.000 | 2023-12-31T00:00:00.000 | 1 | B1 | 002 | Y | N | L | N |
| 1 | 2045270019 | CHG | 2024-01-01T00:00:00.000 | 2024-03-31T00:00:00.000 | 1 | B1 | 003 | Y | N | L | N |
| 1 | 2045270019 | CHG | 2024-04-01T00:00:00.000 | 2024-06-30T00:00:00.000 | 1 | B1 | 002 | Y | N | L | N |
| 1 | 2045270020 | CHG | 2023-07-01T00:00:00.000 | 2023-09-30T00:00:00.000 | 1 | B1 | 003 | Y | N | L | N |
| 1 | 2045270020 | CHG | 2023-10-01T00:00:00.000 | 2023-12-31T00:00:00.000 | 1 | B1 | 003 | Y | N | L | N |
| 1 | 2045270020 | CHG | 2024-01-01T00:00:00.000 | 2024-03-31T00:00:00.000 | 1 | B1 | 005 | Y | N | L | N |
Showing 12 of 28 columns. All of them are listed below.
account_id| text |
| A unique ID for selected account types. Example Meter # for water charges |
| 87% |
0000000000004000140002 |
dt_pd_begin | datetime | Beginning data of tax period for the charge. The date is based on Tax Year which starts in July and ends in June. The begin date is based on whether the tax payer is billed semi-annually or quarterly. For example, if the taxpayer is billed quarterly, the begin date will be the first day of the quarter. Note that special assessment charges can be billed at any time. | 0% | 2023-07-01T00:00:00.0002024-07-01T00:00:00.0002020-07-01T00:00:00.000 |
dt_pd_end | datetime | Ending date of tax period for the charge. The date is based on Tax Year which starts in July and ends in June. The end date is based on whether the tax payer is billed semi-annually or quarterly. For example, if the taxpayer is billed quarterly, the end date will be the last day of the quarter. Note that special assessment charges can be billed at any time. | 0% | 2023-12-31T00:00:00.0002024-06-30T00:00:00.0002024-12-31T00:00:00.000 |
valclass | categorical | Property classification type used to determine the tax rate to be used when calculating the taxes for calculating taxes. | 12% | 124of 12 |
luc | text | Building class for the property | 0% | R4A1C0 |
trans_ctr | text | The number of transaction records that exist for this period (Does not include a transaction for forecasted interest) | 0% | 0010021 |
prior_owner_flag | text | Prior owner flag. Current year owner is same as previous year owner then - 'Y" | 0% | Yof 1 |
city_owned_flag | categorical | City owned flag. Current year owner is flagged if city owned - 'Y' | 0% | NYof 2 |
hi_lo_int | categorical | H - for High Interest (semi annual taxpayers) L - for Low Interest (quarterly taxpayers), only for CHG and SAC codes. F - for anything other than CHG and SAC code | 0% | LFHof 4 |
pet_ind | text | "Petition Indicator. Y - If billing year in Assessment has reason code as COURT ORDER. " | 100% | Yof 1 |
act_install | categorical | Active Payment Contract = Y | 0% | NYof 2 |
int_agree | text | In Payment Contract - Y (ever had a payment contract agreement) | 98% | Yof 1 |
type_acct | text | DOF account type for other agency charges only. | 84% | 241231222 |
sum_liab | float | Total Liability for the period | 0% | 13.000.0062.50 |
sum_coll | float | Total Collections for this period | 0% | 0.0013.00175.00 |
sum_int | float | Total interest posted and or forecasted for this period. | 0% | 0.000.010.02 |
sum_dsc | float | Discount applied due to early payment | 0% | 0.000.060.12 |
sum_bal | float | Current balance due; If zero, the period is fully paid If positive, there is an outstanding liability for the Period | 0% | 0.0013.005.54 |
up_date | datetime | Date of the last transaction for this period (equals to the process date of the last transaction) YYYY-MM-DD | 0% | 2024-06-01T00:00:00.0002021-01-01T00:00:00.0002021-06-05T00:00:00.000 |
due_date | datetime | Current Due Date for this period YYYY-MM-DD | 0% | 2023-07-01T00:00:00.0002021-01-01T00:00:00.0002024-07-01T00:00:00.000 |
post_thru | datetime | Interest has been forecasted through this date (parameter date) for past due charges YYYY-MM-DD | 0% | 2024-04-01T00:00:00.0002025-04-01T00:00:00.0002025-01-01T00:00:00.000of 17 |
dt_grace | datetime | This is the date after which a payment is considered late. After this date interest will be charged. | 0% | 2023-07-01T00:00:00.0002021-01-01T00:00:00.0002024-07-01T00:00:00.000 |
id_block | text | Same as Block - Uses the block field at beginning of the record | 0% | 03944039433944 |
id_lot | text | Same as Lot - Uses the lot field at beginning of the record | 0% | 000100200006 |
rolltype | categorical | RP_NY FOR Ordinary Real Estate / REUC for REUC records / RP_SF for REUC Special Franchise | 0% | RP_NYREUCRP_SFof 3 |
taxyear | categorical | — | 0% | 202520242021of 5 |
prioryear | text | — | 0% | 202420212025 |
cycle | text | Period 1Q, 2Q, 3Q and 4Q for Quarterly periods and 1S and 3S for Semi annual periods | 0% | 1Q3Q4Q |
accode | categorical | Agency code for other agency charges only | 83% | 806816810of 16 |
extractdt | datetime | This is the date of the data extract. | 0% | 2024-02-17T00:00:00.0002025-02-15T00:00:00.0002024-11-17T00:00:00.000 |