This Week’s Data Dosage: You’re One in 7 Billion!

By Lizzie Cranberry

 

On November 1st, the world’s population officially reached the 7 billion mark. This week, we take a look at the data behind that figure. Who are the 7 billion? Where do most of them live? Which countries are growing the fastest, which are declining? And which of them are the happiest? Have more info you want to share? Please let us know and we’ll create some more data streams.

 

Click here if you want to know which are the most populated  (aka most crowded) countries.

 

And a chart to follow, showing which of the most crowded countries are growing the fastest:

Powered by Junar

Meanwhile, you can check the top 10 countries with the fastest population growth.

 

How about the country with the most smiling faces? Check out the happiest countries.

 

And the grand finale: our population data round-up in the form of a Dashboard.

 

That’s today’s Data Dosage. Thanks for being our Data Amigo. It’s a big world out there and we love having you as our friend. J

 

Right to information: How does your country rate?

By Mark Boyd

Junar user, freelance writer based in Barcelona, who specializes in using data to tell stories and share information. 


Two international human rights organizations have recently published a report ranking the world’s right to information laws. Access Info Europe and the Centre for Law and Democracy are dedicated to ensuring citizens have open access to data and information from public authorities. In their surprise research findings, it is the member states of the European Union that fall way behind other countries in enabling citizens to easily access public data and government information.

 

89 countries were assessed in the study. Researchers scored each nation’s right to information laws using 7 indicators. These indicators assess how well the laws define rights to information access, how complicated the processes are when requesting information, what information authorities can refuse to provide, how citizens and community groups can appeal, and other elements.

 

In the Right to Information Ranking Study, the total score for each country reflects the strength of citizen rights in accessing data and documents held by public authorities. Key findings included:

·      The more recent the law, the greater the likelihood that it details better information rights for citizens.

·      This meant laws in Serbia, India, Slovenia and other countries who have updated their right to information laws since 2000 scored the highest results.

·      15 of the bottom 20 scoring nations were European member states which have more antiquated legislation.

·      Junar’s home country of Chile, which introduced right to information laws in 2008, scored 93 out of 150 – falling behind 4 nations in the Americas that scored above 100 and coming in 7th among all nations in the Americas.

 

Helen Darbishire, Executive Director of Access Info Europe, spoke to Junar in between attending sessions at the International Conference of Information Commissioners currently being held in Ottawa, Canada. She explained how data advocates who use Junar to manage their data can make use of the research. In particular, she pointed to the detailed excel data available for each country that shows individual nation’s scores for each of the 7 indicators:

We hope that [individuals and communities] will use the data in advocacy in their countries. One of the strengths of the research is being able to take a particular indicator and compare across the 89 countries. So, for example, if a country is planning to introduce fees for filing requests, it can be demonstrated that this is very rarely done (Canada, Ireland, India – that’s about it). And we hope that Ireland and Canada will see sense to abolish fees using this comparative information.”

 

Ms Darbishire encouraged Junar users to mine the data to make local comparisons and advocate for better right to information laws. “Some nice data visualisations showing how a country lags behind its neighbours on a specific indicator should be useful for advocacy work,” she suggested.

 

One effort to use the results to improve access to data has already emerged. The findings demonstrated that many European nations need to update their right to information legislation to reflect contemporary standards for access to data and government documents. Access Info Europe has followed up the findings with a new advocacy push and web portal, “AsktheEU.org” which aims to document Europe’s openness and responsiveness to new information requests. At present, the human rights group estimates only 0.0024% of Europeans (or 12,000 of the 500 million residents) are exercising their right to access public documents and data.

 

Access to information is seen as fundamental to human rights and the availability of open government data is increasingly essential for political transparency and economic development in societies around the globe.

 

The robust methodology of the research project involved scoring each nation’s legislation against the seven key indicators that measure rights of local citizens to access government information. This was then followed by a process of double-checking the scores with a leading expert in each nation, and finally by rigorous independent assessment of the results by a global Advisory Council committed to international standards on the right to information.

 

The study could only assess legislative rights to information and has not been able – at this stage – to measure how well governments implement their laws. It is hoped that a new body growing out of this agenda – the Open Government Partnership – will be able to focus more closely on how well countries implement right to information laws and how well they respond to individual requests for access to data.

 

How well does your nation rank in the right to information debate? Have you needed access to data from public authorities? Review the Junar dashboard on World Rankings of Right to Information and share your thoughts with us.

Powered by Junar

Freeze rows on embedded Data Streams for a better visualization

Viewing large sets of data is many times painfull. This problem is worst whenever you have a table with a header and when you scroll down you loose sight of it. Now, whenever you embed a Junar data stream you can freeze as many rows as you want so viewing them it's a breeze. For example, here we have a data stream that's particularly long (...most common men names in the US) and lets say I want to embed it on my blog but keep the first row frozen, so Name, % Frecuency, Aprox Number and Rank can be fixed on top and don't move as users scroll down the data.

Ds

Now if you are on a data stream details (viewing a single data stream) you can click ACTIONS>EMBED and now you'll have a new field called Freeze that allows you to set how many rows you want to stay frozen (fixed)

Rows

Finally the data stream is now embedded and if you scroll down the first row (now in grey) will remain fixed for your viewing comfort. 

Screen-capture-2

Enjoy,

 

PS: you can view this DS embedded on the 'test blog' here: http://bit.ly/pSKPbe

Disclaimer: the frozen rows feature appears only when viewing a single data stream (or as we call it -Data Stream Detail). It won't appear if you select the embed option on a data stream placed on a dashboard.

 

Junar lets you create graphs to give life to your Data

Some Junar news for you all... a lot of users asked us for graphs, and here they are. We tweeted about this a few days ago but below is a more detailed description on how to make your Dashboards look even better with good graphs and visualizations.

Step #1 - Go to one of your dashboards and pick one of those Data Streams that you can use to tell a story from the Data. For this example, I'm using my VC investments Dashboard and my latest 10 Emergence Capital investments Data Stream.

3_db_wo_graphs_with_arrows

 

Step #2 - In the Dashboard View, go to the Data Stream you want to use to create a graph, click first on Actions and then on 

5_ds_w_actions_and_create_chart_signaled

Step #3 - Follow the steps to create the graph you want. Start by selecting the figures to be displayed and then select chart type, and add some clarifications and labels

9_creating_the_chart

Step #4 - Organize and enjoy your new Dashboard brought to life !

92_db_w_graphs

... and if you enjoyed doing this even half as much as Mati enjoyed coding this for you, please share your cool graphed Dashboard with the world !

Please contact us if you have any question,

Junar Team 

Publish Data from Google Spreadsheet

A week ago we announced how to bring Junar Data Streams into Google Spreadsheets.

Google insisted on returning the favor so it is possible now to publish Data Streams from pieces of Tables in your Google Spreadsheets !

Say you are passionate about Venture Capital, you have extracted some interesting information from LinkSV, and you now want to publish this data to the world. Here´s what you do:

#1 - You create the table you are interested in publishing and to honor the sources you write them below

1_table_w_source

#2 - You ensure that there are no protected areas in the document. This means that the column and row freeze bars are in the top left corner as you can see in the image above.

#3 - You need to publish the sheet in which the table is located. Ensure that you (i) publish as a webpage, (ii) select ONLY the one sheet.

2_publishing

#4 - You can get the link of this public sheet

3_link_to_collect

#5 - And now you go to Junar to "collect a new Data Stream" as you already know, or you just use our bookmarklet if you are a Junar Ninja

4_paste_link_in_junar

And in case you want to check out this Data Stream, just go visit "Last 50 VC investments distribution"

Untitled

 

Cheers, 

The Junar team

Junar in Hacks & Hackers San Francisco event on DATA

Join us on Wednesday, August 24 at 6:30pm in Storify´s office (149 9th street, Suite 404, San Francisco, CA)

Click to join Hacks and Hackers San Francisco Meetup.

Event Agenda:

The latest Hacks/Hackers panel will showcase companies that are solving the challenges of this Age of Data. We are living in a data deluge where every day, governments are opening up datasets and unleashing massive amounts of information to the public. This is creating a snowball effect where data continues to pile up far more quickly than ever before.

Each panelist will give a short demo of the technologies and tools they are building to help cope with data overload. Demos will be followed by a Q&A.

Presenters:

-Eva Ho, VP of Marketing Operations at Factual

-Diego May, CEO of Junar

-Tasneem Raja, Interactive editor of data apps at Mother Jones, formerly at The Bay Citizen.