{ "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "datesInUnknownTimezone": false, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1755873375022}, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.7.0", "isDataArchived": false, "id": 2, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "data_axle_2024", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "title_description__email_": null, "naics_code": null, "yellow_page_code": null, "csa_code": null, "subsidairy_abi_number": null, "primarysic6_description": null, "suspect_reason_code": null, "thursday_open": null, "domain_name": null, "wednesday_close": null, "parent_abi_number": null, "census_block": null, "location_sales_volume_code": null, "state": null, "office_size_code": null, "filing_flag": null, "stock_exchange_code": null, "abi_number": null, "friday_open": null, "tuesday_open": null, "new_add_date": null, "title_code": null, "industry_specific_firstbyte": null, "smmed_bus_seg1": null, "franchise_code_2__one_byte_": null, "smmed_bus_seg2": null, "corporate_sales_volume_range_de": null, "thursday_close": null, "import_export_flag": null, "sales_volume_type_code": null, "purchased_print_expense": null, "site_number": null, "franchise_code_1__3_bytes_": null, "professional_title": null, "franchise_code_1__one_byte_": null, "delivery_point_barcode1": null, "sales_volume_2": null, "adsize_code": null, "gender": null, "multitenant_code": null, "fleetsize": null, "city": null, "corporate_employee_range": null, "county_code": null, "delivery_point_barcode2": null, "purchase_mgmtadmin_svc_expense": null, "franchise_code_5__3_bytes_": null, "legal_expense": null, "sunday_close": null, "ein": null, "true_franchise_flag": null, "package_container_expense": null, "tele_research_update_date": null, "saturday_close": null, "credit_alpha_score": null, "wealth_code": null, "payat_pump": null, "corporate_employee_range_descri": null, "credit_numeric_score": null, "high_tech_business_flag": null, "census_tract": null, "company_holding_status": null, "year_established": null, "mail_confidence": null, "address": null, "franchise_code_2__3_bytes_": null, "address_type": null, "fortune_ranking": null, "last_name": null, "technology_expense": null, "number_of_corporate_employees": null, "stockticker_symbol": null, "property_management_abi": null, "government_flag": null, "zip__5_": null, "email_address": null, "telecommunications_expense": null, "acronym_flag": null, "filler": null, "friday_close": null, "mailing_carrier_route_code": null, "location_employee_size_code": null, "sales_volume_1": null, "building_number": null, "franchise_code__email_": null, "identification_code": null, "franchise_code_3__3_bytes_": null, "v_id2": null, "cbsa_level": null, "call_status_code": null, "siccode4_description": null, "business_status_code": null, "matchcode": null, "white_collar_flag": null, "state_description": null, "title_code_description": null, "siccode3_description": null, "primary_sic_desiginator": null, "sunday_open": null, "ownor_lease": null, "big_business_segmentation_code": null, "monday_open": null, "franchise_code_3__one_byte_": null, "payroll_expense": null, "square_footage": null, "true_new_add": null, "individual_matchcode": null, "siccode1_description": null, "book_number": null, "company_matchcode": null, "siccode2_description": null, "high_income_exec_flag": null, "pc_code": null, "rent_leasing_expense": null, "web_address": null, "sales_volume_location_decode": null, "mailing_zip_four": null, "franchise_code_4__3_bytes_": null, "mail_confidence_mailing": null, "mailing_address": null, "advertising_expense": null, "foreign_parent_flag": null, "utilities_expense": null, "office_equipment_expense": null, "year_first_appeared": null, "phone_number": null, "accounting_expense": null, "salutation": null, "email_flag": null, "carrier_route_code": null, "royalty_emails": null, "tollfree_phonenumber": null, "ad_size_description": null, "cottage_code": null, "corporate_sales_volume_range": null, "female_exec_flag": null, "franchise_code_4__one_byte_": null, "business_status_code_descriptio": null, "modeled_employee_size_flag": null, "white_collar": null, "population_code": null, "wednesday_open": null, "valid_email_flag": null, "multi_tenant_code_description": null, "company": null, "sic_code_4": null, "sic_code_2": null, "first_name": null, "sic_code_3": null, "email_v_id": null, "sic_code_1": null, "mailing_city": null, "date_in_database": null, "saturday_open": null, "domain_type": null, "mailing_state": null, "countystate_description": null, "mailing_zip_code": null, "primary_sic_2": null, "contract_labor_expense": null, "primary_sic_4": null, "franchise_code_6__one_byte_": null, "insurance_expense": null, "executive_source_code": null, "primary_sic_6": null, "fulfillment_flag": null, "tuesday_close": null, "employeesize_location_descripti": null, "infogroup_emails": null, "franchise_code_6__3_bytes_": null, "number_of_employees": null, "service_type": null, "key_code_1": null, "monday_close": null, "multi_tenant_number": null, "zipfour": null, "growing_business_flag": null, "cbsa_code": null, "franchise_code_5__one_byte_": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.5, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "name": "data_axle_2024", "displayField": "first_name", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "ObjectID" }, { "modelName": "email_address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "email_address", "length": 255, "alias": "email address", "type": "esriFieldTypeString" }, { "modelName": "first_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "first_name", "length": 255, "alias": "first name", "type": "esriFieldTypeString" }, { "modelName": "last_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "last_name", "length": 255, "alias": "last name", "type": "esriFieldTypeString" }, { "modelName": "address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address", "length": 255, "alias": "address", "type": "esriFieldTypeString" }, { "modelName": "city", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "city", "length": 255, "alias": "city", "type": "esriFieldTypeString" }, { "modelName": "state", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "state", "length": 255, "alias": "state", "type": "esriFieldTypeString" }, { "modelName": "state_description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "state_description", "length": 255, "alias": "state description", "type": "esriFieldTypeString" }, { "modelName": "zip__5_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "zip__5_", "length": 255, "alias": "zip (5)", "type": "esriFieldTypeString" }, { "modelName": "zipfour", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "zipfour", "length": 255, "alias": "zipfour", "type": "esriFieldTypeString" }, { "modelName": "company", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "company", "length": 255, "alias": "company", "type": "esriFieldTypeString" }, { "modelName": "title_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "title_code", "length": 255, "alias": "title code", "type": "esriFieldTypeString" }, { "modelName": "title_code_description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "title_code_description", "length": 255, "alias": "title code description", "type": "esriFieldTypeString" }, { "modelName": "title_description__email_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "title_description__email_", "length": 255, "alias": "title description (email)", "type": "esriFieldTypeString" }, { "modelName": "mailing_address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mailing_address", "length": 255, "alias": "mailing address", "type": "esriFieldTypeString" }, { "modelName": "mailing_carrier_route_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mailing_carrier_route_code", "length": 255, "alias": "mailing carrier route code", "type": "esriFieldTypeString" }, { "modelName": "mailing_city", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mailing_city", "length": 255, "alias": "mailing city", "type": "esriFieldTypeString" }, { "modelName": "mailing_state", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mailing_state", "length": 255, "alias": "mailing state", "type": "esriFieldTypeString" }, { "modelName": "mailing_zip_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mailing_zip_code", "length": 255, "alias": "mailing zip code", "type": "esriFieldTypeString" }, { "modelName": "mailing_zip_four", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mailing_zip_four", "length": 255, "alias": "mailing zip four", "type": "esriFieldTypeString" }, { "modelName": "abi_number", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "abi_number", "length": 255, "alias": "abi number", "type": "esriFieldTypeString" }, { "modelName": "primary_sic_6", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "primary_sic_6", "length": 255, "alias": "primary sic 6", "type": "esriFieldTypeString" }, { "modelName": "primarysic6_description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "primarysic6_description", "length": 255, "alias": "primarysic6 description", "type": "esriFieldTypeString" }, { "modelName": "primary_sic_4", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "primary_sic_4", "length": 255, "alias": "primary sic 4", "type": "esriFieldTypeString" }, { "modelName": "primary_sic_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "primary_sic_2", "length": 255, "alias": "primary sic 2", "type": "esriFieldTypeString" }, { "modelName": "primary_sic_desiginator", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "primary_sic_desiginator", "length": 255, "alias": "primary sic desiginator", "type": "esriFieldTypeString" }, { "modelName": "sic_code_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sic_code_1", "length": 255, "alias": "sic code 1", "type": "esriFieldTypeString" }, { "modelName": "siccode1_description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "siccode1_description", "length": 255, "alias": "siccode1 description", "type": "esriFieldTypeString" }, { "modelName": "sic_code_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sic_code_2", "length": 255, "alias": "sic code 2", "type": "esriFieldTypeString" }, { "modelName": "siccode2_description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "siccode2_description", "length": 255, "alias": "siccode2 description", "type": "esriFieldTypeString" }, { "modelName": "sic_code_3", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sic_code_3", "length": 255, "alias": "sic code 3", "type": "esriFieldTypeString" }, { "modelName": "siccode3_description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "siccode3_description", "length": 255, "alias": "siccode3 description", "type": "esriFieldTypeString" }, { "modelName": "sic_code_4", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sic_code_4", "length": 255, "alias": "sic code 4", "type": "esriFieldTypeString" }, { "modelName": "siccode4_description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "siccode4_description", "length": 255, "alias": "siccode4 description", "type": "esriFieldTypeString" }, { "modelName": "franchise_code_1__3_bytes_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "franchise_code_1__3_bytes_", "length": 255, "alias": "franchise code 1 (3 bytes)", "type": "esriFieldTypeString" }, { "modelName": "franchise_code_1__one_byte_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "franchise_code_1__one_byte_", "length": 255, "alias": "franchise code 1 (one byte)", "type": "esriFieldTypeString" }, { "modelName": "franchise_code_2__3_bytes_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "franchise_code_2__3_bytes_", "length": 255, "alias": "franchise code 2 (3 bytes)", "type": "esriFieldTypeString" }, { "modelName": "franchise_code_2__one_byte_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "franchise_code_2__one_byte_", "length": 255, "alias": "franchise code 2 (one byte)", "type": "esriFieldTypeString" }, { "modelName": "franchise_code_3__3_bytes_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "franchise_code_3__3_bytes_", "length": 255, "alias": "franchise code 3 (3 bytes)", "type": "esriFieldTypeString" }, { "modelName": "franchise_code_3__one_byte_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "franchise_code_3__one_byte_", "length": 255, "alias": "franchise code 3 (one byte)", "type": "esriFieldTypeString" }, { "modelName": "franchise_code_4__3_bytes_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "franchise_code_4__3_bytes_", "length": 255, "alias": "franchise code 4 (3 bytes)", "type": "esriFieldTypeString" }, { "modelName": "franchise_code_4__one_byte_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "franchise_code_4__one_byte_", "length": 255, "alias": "franchise code 4 (one byte)", "type": "esriFieldTypeString" }, { "modelName": "franchise_code_5__3_bytes_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "franchise_code_5__3_bytes_", "length": 255, "alias": "franchise code 5 (3 bytes)", "type": "esriFieldTypeString" }, { "modelName": "franchise_code_5__one_byte_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "franchise_code_5__one_byte_", "length": 255, "alias": "franchise code 5 (one byte)", "type": "esriFieldTypeString" }, { "modelName": "franchise_code_6__3_bytes_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "franchise_code_6__3_bytes_", "length": 255, "alias": "franchise code 6 (3 bytes)", "type": "esriFieldTypeString" }, { "modelName": "franchise_code_6__one_byte_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "franchise_code_6__one_byte_", "length": 255, "alias": "franchise code 6 (one byte)", "type": "esriFieldTypeString" }, { "modelName": "true_franchise_flag", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "true_franchise_flag", "length": 255, "alias": "true franchise flag", "type": "esriFieldTypeString" }, { "modelName": "accounting_expense", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "accounting_expense", "length": 255, "alias": "accounting expense", "type": "esriFieldTypeString" }, { "modelName": "acronym_flag", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "acronym_flag", "length": 255, "alias": "acronym flag", "type": "esriFieldTypeString" }, { "modelName": "filler", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "filler", "length": 255, "alias": "filler", "type": "esriFieldTypeString" }, { "modelName": "address_type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address_type", "length": 255, "alias": "address type", "type": "esriFieldTypeString" }, { "modelName": "adsize_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "adsize_code", "length": 255, "alias": "adsize code", "type": "esriFieldTypeString" }, { "modelName": "ad_size_description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ad_size_description", "length": 255, "alias": "ad size description", "type": "esriFieldTypeString" }, { "modelName": "advertising_expense", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "advertising_expense", "length": 255, "alias": "advertising expense", "type": "esriFieldTypeString" }, { "modelName": "big_business_segmentation_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "big_business_segmentation_code", "length": 255, "alias": "big business segmentation code", "type": "esriFieldTypeString" }, { "modelName": "business_status_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "business_status_code", "length": 255, "alias": "business status code", "type": "esriFieldTypeString" }, { "modelName": "business_status_code_descriptio", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "business_status_code_descriptio", "length": 255, "alias": "business status code description", "type": "esriFieldTypeString" }, { "modelName": "call_status_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "call_status_code", "length": 255, "alias": "call status code", "type": "esriFieldTypeString" }, { "modelName": "carrier_route_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "carrier_route_code", "length": 255, "alias": "carrier route code", "type": "esriFieldTypeString" }, { "modelName": "cbsa_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cbsa_code", "length": 255, "alias": "cbsa code", "type": "esriFieldTypeString" }, { "modelName": "cbsa_level", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cbsa_level", "length": 255, "alias": "cbsa level", "type": "esriFieldTypeString" }, { "modelName": "census_block", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "census_block", "length": 255, "alias": "census block", "type": "esriFieldTypeString" }, { "modelName": "census_tract", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "census_tract", "length": 255, "alias": "census tract", "type": "esriFieldTypeString" }, { "modelName": "company_holding_status", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "company_holding_status", "length": 255, "alias": "company holding status", "type": "esriFieldTypeString" }, { "modelName": "contract_labor_expense", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contract_labor_expense", "length": 255, "alias": "contract labor expense", "type": "esriFieldTypeString" }, { "modelName": "corporate_employee_range", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "corporate_employee_range", "length": 255, "alias": "corporate employee range", "type": "esriFieldTypeString" }, { "modelName": "corporate_employee_range_descri", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "corporate_employee_range_descri", "length": 255, "alias": "corporate employee range description", "type": "esriFieldTypeString" }, { "modelName": "corporate_sales_volume_range", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "corporate_sales_volume_range", "length": 255, "alias": "corporate sales volume range", "type": "esriFieldTypeString" }, { "modelName": "corporate_sales_volume_range_de", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "corporate_sales_volume_range_de", "length": 255, "alias": "corporate sales volume range description", "type": "esriFieldTypeString" }, { "modelName": "cottage_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cottage_code", "length": 255, "alias": "cottage code", "type": "esriFieldTypeString" }, { "modelName": "county_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "county_code", "length": 255, "alias": "county code", "type": "esriFieldTypeString" }, { "modelName": "countystate_description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "countystate_description", "length": 255, "alias": "countystate description", "type": "esriFieldTypeString" }, { "modelName": "credit_alpha_score", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "credit_alpha_score", "length": 255, "alias": "credit alpha score", "type": "esriFieldTypeString" }, { "modelName": "matchcode", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "matchcode", "length": 255, "alias": "matchcode", "type": "esriFieldTypeString" }, { "modelName": "phone_number", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "phone_number", "length": 255, "alias": "phone number", "type": "esriFieldTypeString" }, { "modelName": "tollfree_phonenumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "tollfree_phonenumber", "length": 255, "alias": "tollfree phonenumber", "type": "esriFieldTypeString" }, { "modelName": "credit_numeric_score", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "credit_numeric_score", "length": 255, "alias": "credit numeric score", "type": "esriFieldTypeString" }, { "modelName": "female_exec_flag", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "female_exec_flag", "length": 255, "alias": "female exec flag", "type": "esriFieldTypeString" }, { "modelName": "filing_flag", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "filing_flag", "length": 255, "alias": "filing flag", "type": "esriFieldTypeString" }, { "modelName": "foreign_parent_flag", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "foreign_parent_flag", "length": 255, "alias": "foreign parent flag", "type": "esriFieldTypeString" }, { "modelName": "fortune_ranking", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fortune_ranking", "length": 255, "alias": "fortune ranking", "type": "esriFieldTypeString" }, { "modelName": "fulfillment_flag", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fulfillment_flag", "length": 255, "alias": "fulfillment flag", "type": "esriFieldTypeString" }, { "modelName": "gender", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gender", "length": 255, "alias": "gender", "type": "esriFieldTypeString" }, { "modelName": "government_flag", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "government_flag", "length": 255, "alias": "government flag", "type": "esriFieldTypeString" }, { "modelName": "suspect_reason_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "suspect_reason_code", "length": 255, "alias": "suspect reason code", "type": "esriFieldTypeString" }, { "modelName": "growing_business_flag", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "growing_business_flag", "length": 255, "alias": "growing business flag", "type": "esriFieldTypeString" }, { "modelName": "high_income_exec_flag", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "high_income_exec_flag", "length": 255, "alias": "high income exec flag", "type": "esriFieldTypeString" }, { "modelName": "high_tech_business_flag", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "high_tech_business_flag", "length": 255, "alias": "high tech business flag", "type": "esriFieldTypeString" }, { "modelName": "identification_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "identification_code", "length": 255, "alias": "identification code", "type": "esriFieldTypeString" }, { "modelName": "import_export_flag", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "import_export_flag", "length": 255, "alias": "import export flag", "type": "esriFieldTypeString" }, { "modelName": "individual_matchcode", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "individual_matchcode", "length": 255, "alias": "individual matchcode", "type": "esriFieldTypeString" }, { "modelName": "industry_specific_firstbyte", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "industry_specific_firstbyte", "length": 255, "alias": "industry specific firstbyte", "type": "esriFieldTypeString" }, { "modelName": "naics_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "naics_code", "length": 255, "alias": "naics code", "type": "esriFieldTypeString" }, { "modelName": "smmed_bus_seg1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "smmed_bus_seg1", "length": 255, "alias": "smmed bus seg1", "type": "esriFieldTypeString" }, { "modelName": "smmed_bus_seg2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "smmed_bus_seg2", "length": 255, "alias": "smmed bus seg2", "type": "esriFieldTypeString" }, { "modelName": "insurance_expense", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "insurance_expense", "length": 255, "alias": "insurance expense", "type": "esriFieldTypeString" }, { "modelName": "legal_expense", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "legal_expense", "length": 255, "alias": "legal expense", "type": "esriFieldTypeString" }, { "modelName": "location_employee_size_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "location_employee_size_code", "length": 255, "alias": "location employee size code", "type": "esriFieldTypeString" }, { "modelName": "employeesize_location_descripti", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "employeesize_location_descripti", "length": 255, "alias": "employeesize location description", "type": "esriFieldTypeString" }, { "modelName": "location_sales_volume_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "location_sales_volume_code", "length": 255, "alias": "location sales volume code", "type": "esriFieldTypeString" }, { "modelName": "sales_volume_location_decode", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sales_volume_location_decode", "length": 255, "alias": "sales volume location decode", "type": "esriFieldTypeString" }, { "modelName": "mail_confidence", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mail_confidence", "length": 255, "alias": "mail confidence", "type": "esriFieldTypeString" }, { "modelName": "mail_confidence_mailing", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mail_confidence_mailing", "length": 255, "alias": "mail confidence mailing", "type": "esriFieldTypeString" }, { "modelName": "book_number", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "book_number", "length": 255, "alias": "book number", "type": "esriFieldTypeString" }, { "modelName": "date_in_database", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "date_in_database", "length": 255, "alias": "date in database", "type": "esriFieldTypeString" }, { "modelName": "delivery_point_barcode1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "delivery_point_barcode1", "length": 255, "alias": "delivery point barcode1", "type": "esriFieldTypeString" }, { "modelName": "modeled_employee_size_flag", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "modeled_employee_size_flag", "length": 255, "alias": "modeled employee size flag", "type": "esriFieldTypeString" }, { "modelName": "multitenant_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "multitenant_code", "length": 255, "alias": "multitenant code", "type": "esriFieldTypeString" }, { "modelName": "multi_tenant_code_description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "multi_tenant_code_description", "length": 255, "alias": "multi tenant code description", "type": "esriFieldTypeString" }, { "modelName": "new_add_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "new_add_date", "length": 255, "alias": "new add date", "type": "esriFieldTypeString" }, { "modelName": "number_of_corporate_employees", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "number_of_corporate_employees", "length": 255, "alias": "number of corporate employees", "type": "esriFieldTypeString" }, { "modelName": "number_of_employees", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "number_of_employees", "alias": "number of employees", "type": "esriFieldTypeDouble" }, { "modelName": "office_equipment_expense", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "office_equipment_expense", "length": 255, "alias": "office equipment expense", "type": "esriFieldTypeString" }, { "modelName": "office_size_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "office_size_code", "length": 255, "alias": "office size code", "type": "esriFieldTypeString" }, { "modelName": "ownor_lease", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ownor_lease", "length": 255, "alias": "ownor lease", "type": "esriFieldTypeString" }, { "modelName": "package_container_expense", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "package_container_expense", "length": 255, "alias": "package container expense", "type": "esriFieldTypeString" }, { "modelName": "parent_abi_number", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parent_abi_number", "length": 255, "alias": "parent abi number", "type": "esriFieldTypeString" }, { "modelName": "payat_pump", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "payat_pump", "length": 255, "alias": "payat pump", "type": "esriFieldTypeString" }, { "modelName": "payroll_expense", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "payroll_expense", "length": 255, "alias": "payroll expense", "type": "esriFieldTypeString" }, { "modelName": "pc_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pc_code", "length": 255, "alias": "pc code", "type": "esriFieldTypeString" }, { "modelName": "sales_volume_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sales_volume_1", "length": 255, "alias": "sales volume 1", "type": "esriFieldTypeString" }, { "modelName": "sales_volume_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sales_volume_2", "length": 255, "alias": "sales volume 2", "type": "esriFieldTypeString" }, { "modelName": "sales_volume_type_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sales_volume_type_code", "length": 255, "alias": "sales volume type code", "type": "esriFieldTypeString" }, { "modelName": "stockticker_symbol", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "stockticker_symbol", "length": 255, "alias": "stockticker symbol", "type": "esriFieldTypeString" }, { "modelName": "web_address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "web_address", "length": 255, "alias": "web address", "type": "esriFieldTypeString" }, { "modelName": "year_established", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "year_established", "length": 255, "alias": "year established", "type": "esriFieldTypeString" }, { "modelName": "year_first_appeared", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "year_first_appeared", "length": 255, "alias": "year first appeared", "type": "esriFieldTypeString" }, { "modelName": "yellow_page_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "yellow_page_code", "length": 255, "alias": "yellow page code", "type": "esriFieldTypeString" }, { "modelName": "delivery_point_barcode2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "delivery_point_barcode2", "length": 255, "alias": "delivery point barcode2", "type": "esriFieldTypeString" }, { "modelName": "building_number", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "building_number", "length": 255, "alias": "building number", "type": "esriFieldTypeString" }, { "modelName": "multi_tenant_number", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "multi_tenant_number", "length": 255, "alias": "multi tenant number", "type": "esriFieldTypeString" }, { "modelName": "population_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "population_code", "length": 255, "alias": "population code", "type": "esriFieldTypeString" }, { "modelName": "professional_title", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "professional_title", "length": 255, "alias": "professional title", "type": "esriFieldTypeString" }, { "modelName": "property_management_abi", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "property_management_abi", "length": 255, "alias": "property management abi", "type": "esriFieldTypeString" }, { "modelName": "rent_leasing_expense", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "rent_leasing_expense", "length": 255, "alias": "rent leasing expense", "type": "esriFieldTypeString" }, { "modelName": "csa_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "csa_code", "length": 255, "alias": "csa code", "type": "esriFieldTypeString" }, { "modelName": "monday_close", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "monday_close", "length": 255, "alias": "monday close", "type": "esriFieldTypeString" }, { "modelName": "monday_open", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "monday_open", "length": 255, "alias": "monday open", "type": "esriFieldTypeString" }, { "modelName": "salutation", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "salutation", "length": 255, "alias": "salutation", "type": "esriFieldTypeString" }, { "modelName": "service_type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "service_type", "length": 255, "alias": "service type", "type": "esriFieldTypeString" }, { "modelName": "site_number", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "site_number", "length": 255, "alias": "site number", "type": "esriFieldTypeString" }, { "modelName": "square_footage", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "square_footage", "length": 255, "alias": "square footage", "type": "esriFieldTypeString" }, { "modelName": "stock_exchange_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "stock_exchange_code", "length": 255, "alias": "stock exchange code", "type": "esriFieldTypeString" }, { "modelName": "subsidairy_abi_number", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "subsidairy_abi_number", "length": 255, "alias": "subsidairy abi number", "type": "esriFieldTypeString" }, { "modelName": "technology_expense", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "technology_expense", "length": 255, "alias": "technology expense", "type": "esriFieldTypeString" }, { "modelName": "tele_research_update_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "tele_research_update_date", "length": 255, "alias": "tele research update date", "type": "esriFieldTypeString" }, { "modelName": "telecommunications_expense", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "telecommunications_expense", "length": 255, "alias": "telecommunications expense", "type": "esriFieldTypeString" }, { "modelName": "true_new_add", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "true_new_add", "length": 255, "alias": "true new add", "type": "esriFieldTypeString" }, { "modelName": "tuesday_close", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "tuesday_close", "length": 255, "alias": "tuesday close", "type": "esriFieldTypeString" }, { "modelName": "tuesday_open", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "tuesday_open", "length": 255, "alias": "tuesday open", "type": "esriFieldTypeString" }, { "modelName": "utilities_expense", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "utilities_expense", "length": 255, "alias": "utilities expense", "type": "esriFieldTypeString" }, { "modelName": "wednesday_close", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "wednesday_close", "length": 255, "alias": "wednesday close", "type": "esriFieldTypeString" }, { "modelName": "wednesday_open", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "wednesday_open", "length": 255, "alias": "wednesday open", "type": "esriFieldTypeString" }, { "modelName": "white_collar", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "white_collar", "length": 255, "alias": "white collar", "type": "esriFieldTypeString" }, { "modelName": "white_collar_flag", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "white_collar_flag", "length": 255, "alias": "white collar flag", "type": "esriFieldTypeString" }, { "modelName": "thursday_close", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "thursday_close", "length": 255, "alias": "thursday close", "type": "esriFieldTypeString" }, { "modelName": "thursday_open", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "thursday_open", "length": 255, "alias": "thursday open", "type": "esriFieldTypeString" }, { "modelName": "friday_close", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "friday_close", "length": 255, "alias": "friday close", "type": "esriFieldTypeString" }, { "modelName": "friday_open", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "friday_open", "length": 255, "alias": "friday open", "type": "esriFieldTypeString" }, { "modelName": "saturday_close", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "saturday_close", "length": 255, "alias": "saturday close", "type": "esriFieldTypeString" }, { "modelName": "saturday_open", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "saturday_open", "length": 255, "alias": "saturday open", "type": "esriFieldTypeString" }, { "modelName": "sunday_close", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sunday_close", "length": 255, "alias": "sunday close", "type": "esriFieldTypeString" }, { "modelName": "sunday_open", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sunday_open", "length": 255, "alias": "sunday open", "type": "esriFieldTypeString" }, { "modelName": "wealth_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "wealth_code", "length": 255, "alias": "wealth code", "type": "esriFieldTypeString" }, { "modelName": "company_matchcode", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "company_matchcode", "length": 255, "alias": "company matchcode", "type": "esriFieldTypeString" }, { "modelName": "executive_source_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "executive_source_code", "length": 255, "alias": "executive source code", "type": "esriFieldTypeString" }, { "modelName": "purchase_mgmtadmin_svc_expense", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "purchase_mgmtadmin_svc_expense", "length": 255, "alias": "purchase mgmtadmin svc expense", "type": "esriFieldTypeString" }, { "modelName": "purchased_print_expense", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "purchased_print_expense", "length": 255, "alias": "purchased print expense", "type": "esriFieldTypeString" }, { "modelName": "ein", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ein", "length": 255, "alias": "ein", "type": "esriFieldTypeString" }, { "modelName": "domain_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "domain_name", "length": 255, "alias": "domain name", "type": "esriFieldTypeString" }, { "modelName": "domain_type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "domain_type", "length": 255, "alias": "domain type", "type": "esriFieldTypeString" }, { "modelName": "email_flag", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "email_flag", "length": 255, "alias": "email flag", "type": "esriFieldTypeString" }, { "modelName": "email_v_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "email_v_id", "length": 255, "alias": "email v_id", "type": "esriFieldTypeString" }, { "modelName": "v_id2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "v_id2", "length": 255, "alias": "v_id2", "type": "esriFieldTypeString" }, { "modelName": "infogroup_emails", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "infogroup_emails", "length": 255, "alias": "infogroup emails", "type": "esriFieldTypeString" }, { "modelName": "valid_email_flag", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "valid_email_flag", "length": 255, "alias": "valid email flag", "type": "esriFieldTypeString" }, { "modelName": "royalty_emails", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "royalty_emails", "length": 255, "alias": "royalty emails", "type": "esriFieldTypeString" }, { "modelName": "franchise_code__email_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "franchise_code__email_", "length": 255, "alias": "franchise code (email)", "type": "esriFieldTypeString" }, { "modelName": "fleetsize", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fleetsize", "length": 255, "alias": "fleetsize", "type": "esriFieldTypeString" }, { "modelName": "key_code_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "key_code_1", "length": 255, "alias": "key code 1", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "r674_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportsFirstDayOfWeek": false, "supportedNormalizationTypes": [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ], "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsNormalization": true, "supportsSnapToData": true, "supportsFixedIntervalBin": true, "supportsStackBy": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true, "supportsSplitBy": true, "supportsReturnFullIntervalBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsOperator": true, "supportsSearchOperator": true }, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsLod": false, "supportsSpatialAggregationStatistics": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1194437b8f0b4b35a174f3abbd36207e", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }