From a 65-row sample across 18 columns.
fy_2015_registration_yes_nosolicitation_award_methoddoc_agency_code+6agency| agency | fy_2015_award_or_transaction_yes_no | fy_2015_registration_yes_no | franchisee | registration_date_or_date_sent_to_comptroller_for_registration | registration_value_for_fy_2015_transactions | doc_cd_e_g_rct1 | doc_agency_code | doc_id_automatically_generated_contract_id_number_from_fms | franchise_type_specific_category | franchise_type_general_category | solicitation_award_method |
|---|---|---|---|---|---|---|---|---|---|---|---|
| DOT | No | No | PRIVATE TRANSPORTATION CORP. | 7/19/11 | N/A | RCT1 | 841 | 20128000075 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
agency | categorical | — | 0% | DOITTDOTof 2 |
fy_2015_award_or_transaction_yes_no | categorical | — | 0% | NoYes No.of 3 |
fy_2015_registration_yes_no | categorical | — | 0% | NoYesof 2 |
franchisee | text | — | 0% | UNITED FEDERAL DATA OF N…METRO FIBER CO., LLCPHOENIX FIBER NETWORK, L… |
GET /api/datasets/rbvx-jqnh GET /api/datasets/rbvx-jqnh/quality GET /api/datasets/rbvx-jqnh/related GET /api/columns?dataset=rbvx-jqnh
| Bus Service |
| Transportation |
| RFP |
| DOT | No | No | VEOLIA TRANSPORTATION SERVICES, INC. | 6/15/11 | N/A | RCT1 | 841 | 20118205446 | Bus Service | Transportation | RFP |
| DOT | No | No | LIBERTY LINES TRANSIT | NOT REGISTERED | N/A | N/A | — | — | Bus Service | Transportation | Board of Estimate |
| DOT | No | No | PSE&G for LIPA | NOT REGISTERED | N/A | N/A | — | — | Distribution of Gas in Fifth Ward, Staten Island | Miscellaneous Utilities | Board of Estimate |
| DOT | No | No | PSE&G for LIPA | NOT REGISTERED | N/A | N/A | — | — | Historic Gas and Electric Franchises | Miscellaneous Utilities | Board of Estimate |
| DOT | No | No | CONSOLIDATED EDISON CO., INC. | NOT REGISTERED | N/A | N/A | — | — | Historic Gas and Electric Franchises | Miscellaneous Utilities | Board of Estimate |
| DOT | No | No | CEMUSA | 4/11/05 | N/A | RCT1 | 841 | 20060041570 | Maintenance of Bus Stop Shelters, Newsstand and Public Toilets | Street Furniture | Request for Proposal |
| DOT | No | No | NATIONAL RAILROAD PASSENGER CORP (Amtrak) | NOT REGISTERED | N/A | N/A | — | — | Railroad | Transportation | Board of Estimate |
| DOT | No | No | PORT AUTHORITY OF NY & NJ | NOT REGISTERED | N/A | N/A | — | — | Railroad | Transportation | Board of Estimate |
| DOT | No | No | ROOSEVELT ISLAND OPERATING CORP. | NOT REGISTERED | N/A | N/A | — | — | Roosevelt Island Tramway (Railroad) | Transportation | Board of Estimate |
Showing 12 of 18 columns. All of them are listed below.
registration_date_or_date_sent_to_comptroller_for_registration |
| text |
| — |
| 0% |
10/20/11NOT REGISTERED1/6/94 |
registration_value_for_fy_2015_transactions | categorical | — | 0% | N/A$816,250.00$0.00of 4 |
doc_cd_e_g_rct1 | categorical | — | 0% | RCT1N/Aof 2 |
doc_agency_code | categorical | — | 11% | 858841of 2 |
doc_id_automatically_generated_contract_id_number_from_fms | integer | — | 17% | 200000117912006003078820000016632 |
franchise_type_specific_category | categorical | — | 0% | Hi-CAPPublic Pay TelephoneMobileof 12 |
franchise_type_general_category | categorical | — | 0% | Other TelecommunicationsCable TelevisionTransportation of 5 |
solicitation_award_method | text | — | 0% | CSPRFP (CSP)CSP/Renewal |
start_date | text | — | 0% | 10/16/199911/30/201112/20/1993 |
expiration_date | text | — | 0% | 10/15/20146/30/202111/14/2019 |
actual_fee_revenue_collected_in_fy2015 | integer | — | 3% | 0496753125663 |
public_hearing_date_if_applicable | text | — | 0% | N/A8/8/20118/9/1999 |
public_meeting_date_if_applicable | text | — | 0% | 8/10/2011N/A8/11/1999 |
brief_description_of_franchise_award_or_fy2015_transaction | categorical | — | 0% | N/AFCRC approved transfer o…Award of franchiseof 11 |