Demo: Public Company Bankruptcy Cases, Fiscal Year 2009

From Data-gov Wiki

Jump to: navigation, search

Infobox (stable demo) edit with form
  • name: Demo: Public Company Bankruptcy Cases, Fiscal Year 2009

  • description: This demo is built upon SEC data about bankruptcy cases of public companies in fiscal year 2009. The map visualizes the total debt over asset ratio at the state level. Upon clicking on a state, a bar chart shows the details of each company that went bankrupt.
  • keyword(s): Finance
  • creator(s): Xian Li
  • created: 2010/04/08
  • modified: 2010-5-18

live demo here

Contents

Facts about this Demonstration

Live Demo(s)
Video Demo(s)
Data.gov Data source(s)
Other Data source(s)
Technology Used
Related SPARQL
Related Demo(s)

Interesting Observations

  • Most highly bankrupt companies are financial companies which have very large amounts of debts, as is in accordance with what people talk about regulations over financial industry.
  • It would gain more insights on the situation if combined with tax rate of each state to look at the payoff from the debt.
  • More data about the stock prices of those public companies would shed lights on the changes of equity assets.


Technology Highlights

Make SEC data linkable by querying the 'state' graph (Dataset 10011)

We created a dataset Dataset 10011 (us-location, Rensselaer Polytechnic Institute) for US states and it covers a lot of alternative labels of a state. Such label can uniquely identify a location which is known to be a US state. Therefore, we can use skos:altLabel as a key (given the context where we are talking about US state) to clarify which US states were actually mentioned in dataset 1580.

SPARQL endpoint: http://data-gov.tw.rpi.edu/sparql

SPARQL query

PREFIX odg1580: <http://data-gov.tw.rpi.edu/vocab/p/1580/>
prefix skos:  <http://www.w3.org/2004/02/skos/core#> 
prefix dgtwc: <http://data-gov.tw.rpi.edu/2009/data-gov-twc.rdf#> 
prefix foaf:  <http://xmlns.com/foaf/0.1/> 

SELECT ?state_name ?company ?asset ?liabilities
WHERE {
graph <http://data-gov.tw.rpi.edu/vocab/Dataset_1580>
{
  ?s odg1580:state ?state.
  ?s odg1580:company_name ?company.
  ?s odg1580:assets_millions ?asset.
  ?s odg1580:liabilities_millions ?liabilities.
}
graph <http://data-gov.tw.rpi.edu/vocab/Dataset_10011>
{        
         ?uri_dgtwc skos:altLabel ?state .
         ?uri_dgtwc dgtwc:abbreviation ?state_abbrev .
         ?uri_dgtwc foaf:name ?state_name .
}
}
Facts about Demo: Public Company Bankruptcy Cases, Fiscal Year 2009RDF feed
Data sourceDataset 1580  +
Dcterms:created8 April 2010  +
Dcterms:creatorXian Li  +
Dcterms:descriptionThis demo is built upon SEC data about ban This demo is built upon SEC data about bankruptcy cases of public companies in fiscal year 2009. The map visualizes the total debt over asset ratio at the state level. Upon clicking on a state, a bar chart shows the details of each company that went bankrupt. etails of each company that went bankrupt.
Dcterms:modified2010-5-18
Dcterms:subjectFinance  +
Foaf:depictionhttps://data-gov.tw.rpi.edu/w/images/8/80/Screen_shot_2010-04-08_at_1.20.28_AM.png  +
Foaf:nameDemo: Public Company Bankruptcy Cases, Fiscal Year 2009
ImageScreen shot 2010-04-08 at 1.20.28 AM.png  +
Live demohttp://data-gov.tw.rpi.edu/demo/stable/demo-1580-bankruptcy.html  +
Skos:altLabelDemo: Public Company Bankruptcy Cases, Fiscal Year 2009  +, demo: public company bankruptcy cases, fiscal year 2009  +, and DEMO: PUBLIC COMPANY BANKRUPTCY CASES, FISCAL YEAR 2009  +
Sparqlhttp://data-gov.tw.rpi.edu/demo/stable/demo-1580-bankruptcy.sparql  +
Technology usedRDF  +, SPARQL  +, SparqlProxy  +, Google Visualization API  +, TDB Triple Store  +, Google Visualization GeoMap  +, and Google Visualization ColumnChart  +
Personal tools
internal pages