Last active
May 10, 2016 18:47
-
-
Save erikcs/34c8b00c2e27ca3b64728f9d3bf19787 to your computer and use it in GitHub Desktop.
wrds-formtypes
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
>>dbGetQuery(wrds, wrap("SELECT periodEndDate, companyId, TotTermLoans, | |
periodTypeName, formType | |
FROM CIQ.WRDS_SUMMARY | |
WHERE companyId=18527 AND YEAR(periodEndDate)=2008 | |
ORDER BY periodEndDate, formType")) | |
periodEndDate companyId TotTermLoans periodTypeName formType | |
1 2008-03-31 18527 NA YTD 6-K | |
2 2008-03-31 18527 NA YTD 6-K | |
3 2008-03-31 18527 NA LTM 6-K | |
4 2008-03-31 18527 NA Quarterly 6-K | |
5 2008-03-31 18527 NA LTM 6-K | |
6 2008-03-31 18527 NA Quarterly 6-K | |
7 2008-06-30 18527 NA YTD 6-K | |
8 2008-06-30 18527 NA LTM 6-K | |
9 2008-06-30 18527 NA Quarterly 6-K | |
10 2008-06-30 18527 NA Semi-Annual 6-K | |
11 2008-06-30 18527 NA Quarterly 6-K | |
12 2008-06-30 18527 NA YTD 6-K | |
13 2008-06-30 18527 NA LTM 6-K | |
14 2008-09-30 18527 NA Quarterly 6-K | |
15 2008-09-30 18527 NA LTM 6-K | |
16 2008-09-30 18527 NA YTD 6-K | |
17 2008-09-30 18527 NA YTD Interim PR | |
18 2008-09-30 18527 NA Quarterly Interim PR | |
19 2008-09-30 18527 NA LTM Interim PR | |
20 2008-12-31 18527 6.7287 LTM 20-F | |
21 2008-12-31 18527 6.7287 YTD 20-F | |
22 2008-12-31 18527 NA Semi-Annual 20-F | |
23 2008-12-31 18527 9.0986 YTD 20-F | |
24 2008-12-31 18527 6.7287 YTD 20-F | |
25 2008-12-31 18527 6.7287 Annual 20-F | |
26 2008-12-31 18527 9.0986 Quarterly 20-F | |
27 2008-12-31 18527 6.7287 Quarterly 20-F | |
28 2008-12-31 18527 6.7287 LTM 20-F | |
29 2008-12-31 18527 9.0986 LTM 20-F | |
30 2008-12-31 18527 6.7287 Annual 20-F | |
31 2008-12-31 18527 9.0986 Annual 20-F | |
32 2008-12-31 18527 NA Quarterly 6-K | |
33 2008-12-31 18527 NA LTM Annual PR | |
34 2008-12-31 18527 NA YTD Annual PR | |
35 2008-12-31 18527 NA Annual Annual PR | |
36 2008-12-31 18527 NA Semi-Annual Annual PR | |
37 2008-12-31 18527 NA LTM Annual PR | |
38 2008-12-31 18527 NA Annual Annual PR | |
39 2008-12-31 18527 NA YTD Annual PR | |
40 2008-12-31 18527 NA Quarterly Interim PR |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment