JDBC Driver for EdgarOnline

Build 20.0.7655

Companies

Query from the Companies resource.

Columns

Name Type Description
RowNumber Int
EntityId Int
cik String
primarysymbol String
industry String
sector String
primaryexchange String
siccode String
city String
zipcode String
country String
state String
primarycusip String
companyname String
isactivecompany Bool
isDeleted Bool
ModifiedSince Date
companynameshort String
MarketOperator String
MarketTier String
MarketOperatorShort String
MarketTierShort String
IndustryShort String
SectorShort String
WebSiteURL String
LAStAnnualNetIncome Float
PublicFloat Float
BusinessDescription String
StreetAddress1 String
LAStAnnualRevenue Float
PhoneNumber String
LAStAnnualEPS Float
LAStAnnualTotalAssets Float
SICDescription String
StreetAddress2 String
StateofIncorporation String
Formername String
PhoneCountryCode String
duration String
PublicFloatDate Datetime
InvRelationsEmail String
PhoneAreaCode String
TaxID String
TotalSharesOutstandingDate Datetime

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
filter String parameter to filter the result set
entityids String parameter to filter the result set by entityId
ciks String parameter to filter the result set by cik
primarysymbols String parameter to filter the result set by primarysymbol
industries String parameter to filter the result set by industry
sectors String parameter to filter the result set by sector
primaryexchanges String parameter to filter the result set by primaryexchange
siccodes String parameter to filter the result set by siccode
cities String parameter to filter the result set by city
zipcodes String parameter to filter the result set by zipCodes
countries String parameter to filter the result set by countriy
states String parameter to filter the result set by state
primarycusips String parameter to filter the result set by PrimaryCusip
companynames String parameter to filter the result set by companyname
activecompanies String parameter to filter the result set by activecompany
deleted String parameter to filter the result set by IsDeleted
modifiedsince String parameter to filter the result set by modifiedSince
marketoperators String parameter to filter the result set by MarketOperator
markettiers String parameter to filter the result set by MarketTier

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7655