From a 500-row sample across 40 columns.
job_filing_number| unique_id | work_id | floor_id | sign_id | job_filing_number | work_description | item | item_quantity | item_cost | fee_amount | item_detail | floor_fixtures |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0000715E-4E3C-E911-811F-005056B627E6.0.0 | 0000715E-4E3C-E911-811F-005056B627E6 | 0 | 0 | Q00136970-I1-EL | Panels | 1Ø up to 20-1 or 10-2 pole breakers | 1.00 | 15 | 15 | '' | 0 |
| 000073DD-9766-E911-8120-005056B627E6.0.0 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
unique_id | text | — | 0% | AC0EA219-CA49-EA11-8125-…B8B6CB6E-CA49-EF11-A45A-…F8117698-ECC0-EE11-A94C-… |
work_id | text | A unique identifier assigned to each item listed under work description | 0% | E774A76A-287E-E811-811A-…8742F994-638D-EB11-A8B9-…D437BD90-6BCF-EB11-A406-… |
floor_id | text | A unique identifier assigned to each floor description under a work description | 0% | 01077E9C2-653E-E811-8117-…9C4D3E8B-1FB5-E811-811B-… |
sign_id | text | A unique identifier assigned to each electrical sig decscription under work description |
GET /api/datasets/xmmq-y7za GET /api/datasets/xmmq-y7za/quality GET /api/datasets/xmmq-y7za/related GET /api/columns?dataset=xmmq-y7za
| 000073DD-9766-E911-8120-005056B627E6 |
| 0 |
| 0 |
| B00128799-P3 |
| Service Switches |
| Up to 100 amps |
| 2.00 |
| 8 |
| 16 |
| '' |
| 0 |
| 000188C7-3161-E911-8120-005056B627E6.49B48E1D-3161-E911-8120-005056B627E6.0 | 000188C7-3161-E911-8120-005056B627E6 | 49B48E1D-3161-E911-8120-005056B627E6 | 0 | Q00156035-I1-EL | Floor Descriptions | Floor Descriptions - Total Units | 178.00 | 0.25 | 44.5 | '' | 17 |
| 000188C7-3161-E911-8120-005056B627E6.81BAC337-3161-E911-8120-005056B627E6.0 | 000188C7-3161-E911-8120-005056B627E6 | 81BAC337-3161-E911-8120-005056B627E6 | 0 | Q00156035-I1-EL | Floor Descriptions | Floor Descriptions - Total Units | 178.00 | 0.25 | 44.5 | '' | 19 |
| 000188C7-3161-E911-8120-005056B627E6.F71803B9-3161-E911-8120-005056B627E6.0 | 000188C7-3161-E911-8120-005056B627E6 | F71803B9-3161-E911-8120-005056B627E6 | 0 | Q00156035-I1-EL | Floor Descriptions | Floor Descriptions - Total Units | 178.00 | 0.25 | 44.5 | '' | 11 |
| 000188C7-3161-E911-8120-005056B627E6.FF0088C7-3161-E911-8120-005056B627E6.0 | 000188C7-3161-E911-8120-005056B627E6 | FF0088C7-3161-E911-8120-005056B627E6 | 0 | Q00156035-I1-EL | Floor Descriptions | Floor Descriptions - Total Units | 178.00 | 0.25 | 44.5 | '' | 11 |
| 0001EC5E-202D-E811-8117-005056B627E4.FE00EC5E-202D-E811-8117-005056B627E4.0 | 0001EC5E-202D-E811-8117-005056B627E4 | FE00EC5E-202D-E811-8117-005056B627E4 | 0 | M00024967-P1 | Floor Descriptions | Floor Descriptions - Total Units | 33.00 | 0.25 | 8.25 | '' | 28 |
| 0002E7DE-5196-E811-8119-005056B627E6.0.0 | 0002E7DE-5196-E811-8119-005056B627E6 | 0 | 0 | M00067271-I1-EL | Service Entrance and Feeder Conductors. List Each Set | Over 1/0 to 250MCM | 1.00 | 45 | 45 | '3/0' | 0 |
| 000303A4-3C39-E911-811F-005056B627E6.02D85795-3C39-E911-811F-005056B627E6.0 | 000303A4-3C39-E911-811F-005056B627E6 | 02D85795-3C39-E911-811F-005056B627E6 | 0 | M00134987-I1-EL | Floor Descriptions | Floor Descriptions - Total Units | 30.00 | 0.25 | 7.5 | '' | 5 |
| 000303A4-3C39-E911-811F-005056B627E6.5B2E7087-3C39-E911-811F-005056B627E6.0 | 000303A4-3C39-E911-811F-005056B627E6 | 5B2E7087-3C39-E911-811F-005056B627E6 | 0 | M00134987-I1-EL | Floor Descriptions | Floor Descriptions - Total Units | 30.00 | 0.25 | 7.5 | '' | 5 |
Showing 12 of 33 columns. All of them are listed below.
| 0% |
06F3B8230-BE03-ED11-A3ED-…22D73973-824D-EE11-A427-… |
job_filing_number | text | A unique identifier assigned to a job filing. It consists of job number (a letter indicating the borough followed by an 8-digit number) hyphenated with Filing Number (a 2-digit code identifying the filing type). Once the permit is issued, a suffix "-EL" is added to the job filing number. (Example: M00000001-I1-EL) | 0% | Q01143726-I1-ELQ00275367-I1-ELQ00386745-P1 |
work_description | text | Indicates a header for each group of items listed under work description. Example: Panels | 0% | Floor DescriptionsService Entrance and Fee…Panels |
item | text | Indicates name of each cost item listed under work description. Example: 1∅ up to 20-1 or 10-2 pole breakers | 0% | Floor Descriptions - Tot…Up to #2 conductor1Ø up to 20-1 or 10-2 po… |
item_quantity | coordinate | Indicates quantity of each cost item listed under work description | 0% | 1.002.003.00 |
item_cost | float | Indicates cost of each item listed under work description | 0% | 0.25158 |
fee_amount | float | Indicates total fee amount (quantity * cost) | 0% | 15308 |
item_detail | text | Includes more information to describe each item | 0% | '''80 AMP''60A' |
floor_name | text | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Floor Descriptions", this will indicate the name of the floor of the building. (Example: Mezzanine, Lobby, Basement) If the floor doesn't have a name, this field will display "Floor Number(s)". | 63% | Floor Number(s)Ground FloorBasement |
from_floor | text | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Floor Descriptions", and the FLOORNAME is "Floor Number(s)", this will indicate the floor on which the work will be performed. (Or in the case of a range of floors, this will be the lowest floor number.) | 78% | 123 |
to_floor | text | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Floor Descriptions", and the FLOORNAME is "Floor Number(s)", this will indicate the floor on which the work will be performed. (Or in the case of a range of floors, this will be the highest floor number.) | 78% | 213 |
floor_detail | text | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Floor Descriptions", this will provide more detail about the floor on which the work will be performed. This field is free text. | 77% | BASEMENTBasementCellar |
floor_fixtures | text | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Floor Descriptions", this will indicate the number of fixtures involved in the work on that floor. | 0% | 01020 |
floor_ac_receptacles | text | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Floor Descriptions", this will indicate the number of A/C Receptacles involved in the work on that floor. | 0% | 012 |
floor_att_receptacles | text | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Floor Descriptions", this will indicate the number of ATT Receptacles involved in the work on that floor. | 0% | 02010 |
floor_switches | integer | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Floor Descriptions", this will indicate the number of switches involved in the work on that floor. | 0% | 0102 |
floor_outlets | integer | Indicates number of outlets in the specified floor | 0% | 0112 |
floor_motors_generators | integer | Indicates number of motors or generators in the specified floor | 0% | 012 |
floor_hpkw | integer | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Floor Descriptions", this will indicate the total hpkw of motors or generators involved in the work on that floor. | 0% | 012 |
floor_heaters | integer | Indicates number of heaters in the specified floor | 0% | 012 |
floor_kw | integer | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Floor Descriptions", this will indicate the total kw of heaters involved in the work on that floor. | 0% | 023 |
floor_transformers | integer | Indicates number of transformers in the specified floor | 0% | 012 |
floor_kva | integer | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Floor Descriptions", this will indicate the total kva of transformers involved in the work on that floor. | 0% | 07545 |
sign_dimensions | text | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the dimensions of the sign in feet. This field is free text. | 99% | 3'-6' X 4'-0'2'-0' X 16'-0'5'-0' X 5'-1' |
sign_sq_footage | integer | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the total square footage of the sign. | 0% | 05014 |
sign_circuits | integer | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the total number of circuits in the sign. | 0% | 012 |
sign_lamps | integer | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the total number of lamps on the sign. | 0% | 01001 |
sign_lamp_wattage | integer | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the wattage of the lamps on the sign. | 0% | 0164 |
sign_transformers | integer | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate number of transformers for the sign. | 0% | 012 |
sign_va_per_transformer | float | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate V.A. of each transformer. | 0% | 012060 |
sign_total_watts_va | float | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the total watts or V.A. (Volt Ampere) of the sign. | 0% | 0120102 |
sign_total_aw_guage | text | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the number of (American wire) AWG gauge of wire. | 99% | 1214#12 |
sign_sockets_per_circuit | integer | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the number of sockets per circuit. | 0% | 01100 |
sign_materials_guage | text | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the details of the material and gauge used in the sign construction. | 99% | .063 ALUMINUM.040 GAUGE ALUMINUM CHAN…040 AL and 3/16' Plexigl… |
sign_text | text | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the text on the sign. | 99% | CHANNEL LETTERSSIGN ON WALL(LOGO) RITE AID |
sign_manufacturer | text | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the manufacturer of the sign. | 99% | NATIONAL SIGN & LIGHTINGDK SignSPACE SIGN |
sign_manufacturer_address | text | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the sign manufacturer's address. | 99% | 25-20 BQE West Woodside …169 Lodi Street Hackensa…15-25 132 STREET, COLLEG… |