{
  "fields": [{"id":"_id","type":"int"},{"id":"Local Authority: Dublin City Council","type":"text"},{"id":"17/08/2012","type":"text"}],
  "records": [
    [1,"",""],
    [2,"Analysis of Current Assets - Table No 1A.",""],
    [3,""," Quarter 2"],
    [4,"","30/06/2012"],
    [5,"","€"],
    [6,"Stock"," 5,093,077 "],
    [7,"Urban Account",""],
    [8,"",""],
    [9,"Trade Debtors & Prepayments",""],
    [10,"   - Development  Levy Debtors"," 46,251,603 "],
    [11,"   -  Agency  Debtors"," -   "],
    [12,"   - Rates Debtors"," 242,742,748 "],
    [13,"   -  Other Debtors"," 189,582,780 "],
    [14,"Amounts due within I year"," 20,300,000 "],
    [15," Total Debtors  Gross Debtors"," 498,877,131 "],
    [16,"",""],
    [17,"Less Provision for Doubtful Debts",""],
    [18,"       -  Development Debtors "," 27,750,961 "],
    [19,"       - Other Debtors"," 70,059,904 "],
    [20,"",""],
    [21,"Add Prepayments",""],
    [22,"",""],
    [23,"      - Prepayments"," 17,085,896 "],
    [24,"",""],
    [25,"Debtors ( Per AFS )"," 418,152,162 "],
    [26,"",""],
    [27,"Bank Investments"," 31,494,762 "],
    [28,"Cash at Bank"," -   "],
    [29,"Cash on Hand"," 314,102 "],
    [30,"Total Cash Balances"," 31,808,864 "],
    [31,"",""],
    [32," Total Curent Assets"," 455,054,103 "],
    [33,"",""],
    [34,"                               Deposits Invested    Table No 1B",""],
    [35,"","  Quarter 2 "],
    [36,"","30/06/2012"],
    [37,""," € "],
    [38,"NTMA"," -   "],
    [39,"Other Local Authorities"," -   "],
    [40,"Holdings of Short-term paper issued by HFA"," -   "],
    [41,"Other Financial Institutions"," 31,494,762 "],
    [42,"Total"," 31,494,762 "],
    [43,"",""],
    [44,"",""],
    [45,"Analysis of Current Liabilities  - Table 2",""],
    [46,""," Quarter 2"],
    [47,"","30/06/2012"],
    [48,"","€"],
    [49,"Bank Overdraft"," 15,514,588 "],
    [50,"",""],
    [51,"Creditors and Accruals",""],
    [52,"General Creditors"," 46,168,722 "],
    [53,"Accruals"," 87,239,842 "],
    [54,"Deferred Income - Rates"," 170,630,254 "],
    [55,"Deferred Income - Non Development Debtors (Other)"," 37,921,008 "],
    [56,"Amounts due within I year"," 28,500,000 "],
    [57," Total Creditors (per afs)"," 370,459,826 "],
    [58,"",""],
    [59,"Urban Account"," -   "],
    [60,"Finance Leases"," -   "],
    [61,"",""],
    [62,"Total Current Liabilities"," 385,974,414 "],
    [63,"",""],
    [64,"Analysis of  Creditors (More than one year)  Table 3",""],
    [65,""," Quarter 2"],
    [66,"","30/06/2012"],
    [67,"","€"],
    [68,"",""],
    [69,"Loans Payable"," 879,842,667 "],
    [70,"Finance Leases"," -   "],
    [71,"Refundable Deposits"," 3,494,762 "],
    [72,"Deferred Income - Development Debtors ( Must Match Line 118)"," 36,100,944 "],
    [73,"",""],
    [74,"Total"," 919,438,373 "],
    [75,"",""],
    [76,"",""],
    [77,"Analysis of Long-Term Loans Payable by Lender  - Table no 3A.",""],
    [78,""," Quarter 2"],
    [79,"","30/06/2012"],
    [80,"","€"],
    [81,"HFA "," 879,486,320 "],
    [82,"OPW"," -   "],
    [83,"NTMA"," -   "],
    [84,"National Development Finance Agency"," -   "],
    [85,"Other Local Authorities"," -   "],
    [86,"Other Financial Institutions"," 28,856,347 "],
    [87,"Other"," -   "],
    [88,"Sub Total"," 908,342,667 "],
    [89,"Less amounts falling due within one year"," 28,500,000 "],
    [90,"Total Amounts Due after one year( Must agree with total @ row 63"," 879,842,667 "],
    [91,"",""],
    [92,"Application of Loans  of Loans Payable    -Table 3B",""],
    [93,""," Quarter 2"],
    [94,"","30/06/2012"],
    [95,"","€"],
    [96,"Mortgage Loans"," 217,014,573 "],
    [97,"Assets/Grants"," 200,022,787 "],
    [98,"Revenue Funding"," -   "],
    [99,"Bridging Finance"," 91,641,989 "],
    [100,"Recoupable"," -   "],
    [101,"Shared Ownership - Rented Equity"," 133,675,170 "],
    [102,"Inter Local Authority"," -   "],
    [103,"Voluntary Housing"," 265,988,148 "],
    [104,"Sub Total"," 908,342,667 "],
    [105,"Less amounts falling due within one year"," 28,500,000 "],
    [106,"Total Amounts Due after one year( Must agree with total @ row 63"," 879,842,667 "],
    [107,"",""],
    [108,"Analysis of Long Term Debtors  - Table No 4.",""],
    [109,""," Quarter 2"],
    [110,"","30/06/2012"],
    [111,"","€"],
    [112,"Long Term Mortgage Related Advances"," 230,217,263 "],
    [113,"Tenant Purchases Advances"," 9,349,526 "],
    [114,"Shared Ownership Rented Equity"," 129,190,983 "],
    [115,"Voluntary Housing"," 265,988,148 "],
    [116,"Inter local Authority Loans"," -   "],
    [117,"Development Debtors (Must Match Line 73)"," 36,100,944 "],
    [118,"Long Term Investments",""],
    [119,"      - Cash"," -   "],
    [120,"      - Associated companies"," -   "],
    [121,"Other"," -   "],
    [122,"Sub Total"," 670,846,864 "],
    [123,"Less amounts due within one year"," 20,300,000 "],
    [124,"Total Amounts Due after more than one year"," 650,546,864 "],
    [125,"",""],
    [126,"Net Balance GGB Balance","-199,811,820 "],
    [127,"Change in GGB"," 384,140 "],
    [128,"",""],
    [129,"",""],
    [130,"                       Projected Change in Borrowings   Table No 5.",""],
    [131,"",""],
    [132,"",""],
    [133,"","€"],
    [134," Quarter 3 2012"," 5,000,000 "],
    [135,"",""],
    [136,"",""],
    [137,"",""],
    [138,"                     Forecast Development Contributions - Table No 6",""],
    [139,"",""],
    [140,"",""],
    [141," ",""],
    [142," "," Outturn 2012 "],
    [143," Income Development Contributions"," 12,000,000 "]
]}