Downside's financial data extraction

Connecting to database

ALEXION PHARMACEUTICALS INC

SEC Form 10-Q filed 2010-07-30 for the period ending 2010-06-30

(Debug messages on)

Selected tables from the SEC filing

Table 0

Financial table in standard format


		Page
PART I.	FINANCIAL INFORMATION

Item 1.	Condensed Consolidated Financial Statements (Unaudited)

	Condensed Consolidated Balance Sheets as of June 30, 2010 and December 31, 2009	2

	Condensed Consolidated Statements of Operations for the three and six months ended June 30, 2010 and 2009	3

	Condensed Consolidated Statements of Cash Flows for the six months ended June 30, 2010 and 2009	4

	Notes to Condensed Consolidated Financial Statements	5

Item 2.	Managements Discussion and Analysis of Financial Condition and Results of Operations	15

Item 3.	Quantitative and Qualitative Disclosures about Market Risk	25

Item 4.	Controls and Procedures	27

PART II.	OTHER INFORMATION	28

Item 1A.	Risk Factors	28

Item 5.	Other Information	46

Item 6.	Exhibits	46

SIGNATURES		48

ALEXION PHARMACEUTICALS INC CIK:899866

Notes to Condensed Consolidated Financial Statements		5
Item 2.		15
Item 3.		25
Item 4.		27
PART II.		28
Item 1A.		28
Item 5.		46
Item 6.		46
SIGNATURES		48

Data column 1: "numyear" is ambiguous (2010 or 2009 or 2010 or 2009 or 2010 or 2009)
Data column 1: "month" is ambiguous (6 or 12 or 6 or 6)
Data column 1: "dayofmonth" is ambiguous (30 or 31 or 30 or 30)
Data column 1: Unable to interpret date in column header
Data column 2: Unable to interpret date in column header
Row "SIGNATURES": Multi-column field in a numeric row

Table 1

Table column format standardization was unsuccessful.


	Asset Derivatives			Liability Derivatives
	Balance Sheet Location	Fair Value		Balance Sheet Location	Fair Value

Derivatives designated as hedging instruments:
Foreign exchange forward contracts	Other current assets	$	23,832	Other current liabilities	$	871

Foreign exchange forward contracts	Other non-current assets		4,829	Other non-current liabilities		842

Derivatives not designated as hedging instruments:

Foreign exchange forward contracts	Other current assets		802	Other current liabilities		434

Total fair value of derivative instruments		$	29,463		$	2,147

Unable to find the column headers.

Table internal representation dump (debug use)

First numeric data row: 0
First row with column header attributes: 
Last row with column header attributes:  

Row 0

Row 1
    (2..5)   [1..2] (stub): 'Asset Derivatives'
   (7..10)   [3..4] (stub): 'Liability Derivatives'

Row 2
    (2..2)   [1..1] (stub): 'Balance Sheet Location'
    (4..5)   [2..2] (stub): 'FairValue'
    (7..7)   [3..3] (stub): 'Balance Sheet Location'
   (9..10)   [4..4] (stub): 'FairValue'

Row 3

Row 4
    [0..0)   [0..0] (stub): 'Derivatives designated as hedging instruments:'

Row 5
    [0..0)   [0..0] (stub): 'Foreign exchange forward contracts'
    [2..2)   [1..1] (stub): 'Other current assets'
    [4..5]   [2..2] ( num): '$23,832'
      Attributes: num=>832 [2..2]  
    [7..7)   [3..3] (stub): 'Other current liabilities'
   [9..10]   [4..4] ( num): '$871'

Row 6

Row 7
    [0..0)   [0..0] (stub): 'Foreign exchange forward contracts'
    [2..2)   [1..1] (stub): 'Other non-current assets'
    (5..5]   [2..2] ( num): '4,829'
      Attributes: num=>4 [2..2]  num=>829 [2..2]  
    [7..7)   [3..3] (stub): 'Other non-current liabilities'
  (10..10]   [4..4] ( num): '842'
      Attributes: num=>842 [4..4]  

Row 8

Row 9
    [0..0)   [0..0] (stub): 'Derivatives not designated as hedging instruments:'

Row 10

Row 11
    [0..0)   [0..0] (stub): 'Foreign exchange forward contracts'
    [2..2)   [1..1] (stub): 'Other current assets'
    (5..5]   [2..2] ( num): '802'
      Attributes: num=>802 [2..2]  
    [7..7)   [3..3] (stub): 'Other current liabilities'
  (10..10]   [4..4] ( num): '434'
      Attributes: num=>434 [4..4]  

Row 12

Row 13
    [0..0)   [0..0] (stub): 'Total fair value of derivative instruments'
    [4..5]   [2..2] ( num): '$29,463'
      Attributes: num=>463 [2..2]  
   [9..10]   [4..4] ( num): '$2,147'
      Attributes: num=>147 [4..4]  

Row 14



Prototype ranges:
4 rows: 11 7 5 14 
    [0..0)   [0..0] (stub): ''
    [2..2)   [1..1] (stub): ''
    [4..5]   [2..2] ( num): ''
    [7..7)   [3..3] (stub): ''
   [9..10]   [4..4] ( num): ''
Row 13
    [0..0)          (stub): ''
    [4..5]          ( num): ''
   [9..10]          ( num): ''

Best data column prototype:
4 rows: 11 7 5 14 
    [0..0)   [0..0] (stub): ''
    [2..2)   [1..1] (stub): ''
    [4..5]   [2..2] ( num): ''
    [7..7)   [3..3] (stub): ''
   [9..10]   [4..4] ( num): ''

Table attributes: balancesheet,assets,liabilities

Table 2

Financial table in standard format


		Fair Value Measurement at June 30, 2010
Balance Sheet Classification	Type of Instrument	Total		Level 1	Level 2		Level 3

Cash equivalents	Money market funds	$	96,695	$	$	96,695	$

Marketable securities	Federal agency obligations	$	10,009	$	$	10,009	$

Marketable securities	U.S. Corporate bonds	$	26,712	$	$	26,712	$

Other current assets	Foreign exchange forward contracts	$	24,634	$	$	24,634	$

Other assets	Foreign exchange forward contracts	$	4,829	$	$	4,829	$

Other current liabilities	Foreign exchange forward contracts	$	1,305	$	$	1,305	$

Other liabilities	Foreign exchange forward contracts	$	842	$	$	842	$

ALEXION PHARMACEUTICALS INC CIK:899866
	2010-06-30	2010-06-30	2010-06-30	2010-06-30	2010-06-30
Balance Sheet Classification
Cash equivalents		$96,695		$96,695
Marketable securities		$10,009		$10,009
Marketable securities		$26,712		$26,712
Other current assets		$24,634		$24,634
Other assets		$4,829		$4,829
Other current liabilities		$1,305		$1,305
Other liabilities		$842		$842

Original filing from SEC EDGAR system.