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.
Contributor:

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 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 .
}
}
Uses Dataset: 
Uses Technology: 
Uses Technology: 
Uses Technology: 
Uses Technology: 
Uses Technology: 
Uses Technology: 
Thumbnail: 
No votes yet