2 new features in Junar API -> page & limit

Hi everyone!

Today we have released two new features for the Junar API which I would like to talk about.

First of all we have added a new output format of type XML for API´s invoke method. You can now enable the XML output for your calls just by adding the argument output=xml. This will return a standard XML document structure which then you can manipulate.

The other new cool feature we have added to our API is the ability to page through our Data stream invocation calls. This will enable you to properly manipulate and display big data sets with faster response times than requesting the whole dataset in one call.

We have added to following to parameters to our invoke method:

  • page: Is of type Integer and represents the page number your requesting starting by 0.  
  • limit: Is of type Integer and represents the amount of rows or records to be retrieved per page.

If your invocation call does not provide given parameters the whole dataset will be returned, if one of the above parameters is not provided the request response will be a 400 error.

Hope these new features come in handy in your applications and for any help or support on the new features please contact Junar support.

A belated happy global entrepreneur week!

Hello! Bonjour! Hola! Shalom!

We just finished Global Entrepreneur Week (#GEW on Twitter). No matter where you were last week, there were events focused on entrepreneurs! We think this is awesome (Junar is, after all, a start-up and we’re entrepreneurs ourselves).

To continue the spirit of last week's celebrations, we’d like to share with you some data on global  entrepreneurship, including this data stream about the events that took place last  week.   

We also want to mention that most of the  data we are sharing in this post comes from the research done by our friends at Global Entrepreneur Monitor (aka our “GEM” friends).

So, without further ado: some data on all of the entrepreneurs in the world.

This dashboard  is a great place to check out  lots of great stats and graphs about entrepreneurship.

Meanwhile, this is a good round-up of some world entrepreneurship indicators for 2010.

We also have some country specific entrepreunership indicators. Check out the business start-up scene in Israel, Latin America, and France, for example.


 

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

 

Analysts: enhance your data experience with Junar

Do you spend countless hours collecting data from the web?

Analysts spend over 70% of their time collecting data for their every day work and only 30% in analysis.

Maximize your productivity with Junar and let us do the hard part.

What's Junar?

Junar is a platform that allows users to extract data from the web and manage it from one single site. It's designed to be very easy to collect data from webpages, just add your URL in the collect page and start creating your own data streams (conections between Junar and a website or file on the web). 

Stop wasting time copy/pasting values, downloading files or going back everytime you need to update: Junar keeps your data updated automatically and in real-time.

Integrate data in Junar to your everyday tools like Google Spreadsheets or MS Excel. Let us update your documents for you, no more copy pasting, no more errors, no more time consuming in updating your data.

Create your own dashboards for easy access, add 'live' graphs and embed them to your websites. Certainly your blog/website visitors will bennefit from fresh data and graphs.

Change the way you collect, track and use data forever.

 

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

Insert live Junar Data in Google Docs

A new feature released by Junar, here it is: Insert live data streams into your Google Spreadsheets.

Very simple

1. Find the Data Stream you like (in this example a LinkSV sourced Data Stream on investments in Silicon Valley)

2. Click on ´Actions´ and then on ´Google Spreadsheets´ to get the ´code´

   -> =ImportHtml("http://www.junar.com/datastreams/html/34755/top-10-largest-vc-rounds-in-2011-linksv-investments-summary/" ; "table" ; 1)

3. Then, just go to your google Doc and insert the code in a cell

Slide2

4. The Data Stream coming from a site in the web (or from a computer of a Junar Data Publisher) will be updated by Junar in your google doc

Slide4

For sharing Spreadsheets you certainly use Google Docs... Start embedding live data from the web that you find in the Junar growing catalog of pre-curated data. Let us know what you think (support@junar.com).

 

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.