From a 500-row sample across 15 columns.
unitidcontractcodepersonid+2| transactionid | relatedtransactionid | propertyid | unitid | personid | contractcode | operatorlastname | totalamount | transactiontype | transactionstatus | transactionpostdate | transactiondate |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 600155596.0 | -99.0 | 1493.0 | 938.0 | 5779.0 | q0940008 | GALLOP NYC Q94-ST | 0.0 | 6.0 | 0.0 | 2020-04-01T00:00:00.000 | 2020-04-01T00:00:00.000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
transactionid | integer | — | 0% | 700141142.0700192432.0600061507.0 |
relatedtransactionid | integer | — | 0% | -1.00.0-99.0 |
propertyid | integer | — | 0% | 271.0454.01878.0 |
unitid | integer | — | 0% | 1663.0113.0265.0 |
personid | integer | — |
GET /api/datasets/vmkw-p55f GET /api/datasets/vmkw-p55f/quality GET /api/datasets/vmkw-p55f/related GET /api/columns?dataset=vmkw-p55f
| 600172222.0 |
| -99.0 |
| 1860.0 |
| 1293.0 |
| 5860.0 |
| b0190006 |
| NEIRA B19-MT |
| 0.0 |
| 6.0 |
| 0.0 |
| 2025-07-01T00:00:00.000 |
| 2025-07-18T00:00:00.000 |
| 600136244.0 | -1.0 | 1840.0 | 1258.0 | 5498.0 | b0540012 | JORDAN B54-TP | 0.0 | 6.0 | 0.0 | 2017-06-01T00:00:00.000 | 2017-06-01T00:00:00.000 |
| 600123920.0 | -1.0 | 497.0 | 1450.0 | 5400.0 | x1040010 | ABRIL X104-2-C | 0.0 | 6.0 | 0.0 | 2015-07-01T00:00:00.000 | 2015-07-01T00:00:00.000 |
| 700185944.0 | 0.0 | 2291.0 | 2299.0 | 5772.0 | x0150001 | VEGA X15-C | 298.96 | 7.0 | -1.0 | 2020-09-01T00:00:00.000 | 2020-09-01T00:00:00.000 |
| 600096781.0 | -1.0 | 235.0 | 380.0 | 4801.0 | x0350006 | ZOULIS X35-AC | 0.0 | 6.0 | 0.0 | 2011-06-01T00:00:00.000 | 2011-06-01T00:00:00.000 |
| 600130485.0 | -1.0 | 2121.0 | 1836.0 | 5543.0 | x3070002 | CONTE X307-MT | 0.0 | 6.0 | 0.0 | 2016-07-01T00:00:00.000 | 2016-07-01T00:00:00.000 |
| 600095411.0 | -1.0 | 673.0 | 1384.0 | 4581.0 | b0540008 | LOPEZ B54-C | 0.0 | 6.0 | 0.0 | 2011-04-01T00:00:00.000 | 2011-04-01T00:00:00.000 |
| 600089020.0 | -1.0 | 644.0 | 1057.0 | 4564.0 | b0160005 | RIVERA B16-C | 0.0 | 6.0 | 0.0 | 2010-04-01T00:00:00.000 | 2010-04-01T00:00:00.000 |
| 600118004.0 | -1.0 | 2121.0 | 1836.0 | 5543.0 | x3070002 | CONTE X307-MT | 0.0 | 6.0 | 0.0 | 2014-08-01T00:00:00.000 | 2014-08-01T00:00:00.000 |
Showing 12 of 13 columns. All of them are listed below.
| 0% |
3309.02495.03201.0 |
contractcode | text | — | 0% | q4110005m0100275q0100012 |
operatorlastname | text | — | 0% | DOUGLASTON GOLF LLC Q411…WOLLMAN RINK OPERATIONS,…CRYSTAL BALL GROUP, INC.… |
totalamount | integer | — | 0% | 0.01000.0500.0 |
amountpaid | float | — | 10% | 0.0250.0200.0 |
transactiontype | categorical | — | 0% | 6.07.015.0of 3 |
transactionstatus | categorical | — | 0% | 0.0-1.0of 2 |
transactionpostdate | datetime | — | 0% | 2013-08-01T00:00:00.0002013-09-01T00:00:00.0002013-07-01T00:00:00.000 |
transactiondate | datetime | — | 0% | 2016-09-01T00:00:00.0002013-08-01T00:00:00.0002019-07-01T00:00:00.000 |
transactiondesc | text | — | 79% | Minimum FeesPayout License FeeGasoline&Fuels Min. Fee |
chargetype | coordinate | — | 79% | 2.03.01.0of 3 |