Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: Re: Web APIs and JSON file format reading

From   Sergiy Radyakin <>
Subject   Re: st: Re: Web APIs and JSON file format reading
Date   Mon, 20 Dec 2010 02:40:25 -0500

On Sun, Dec 19, 2010 at 7:40 PM, Andrew Dyck <> wrote:
> Hi Stata users,
> I'm interested in using Stata to access data from web APIs such as
> or Twiter. I use 64-bit Stata MP for Windows and

Dear Andrew,
the data from the World Bank also comes in a CSV format, archived in
ZIP files. You can download the data of your interest with -copy- from
the web address to your local drive, then unpack with the -unzipfile-
command (undocumented in Stata 10, documented in Stata 11). Then
-insheet- the data tables you want.

If you are up to the "Apps for development" competition: good luck!

The data catalog with direct links to databases is available here:

Best regards,
     Sergiy Radyakin
     Economist, Research Department, The World Bank

PS: what data is available on Twitter?

> Linux.
> I'm aware of the -net-, -copy- and -webuse- commands, however, my
> searches so far haven't uncovered any tools for reading in data
> directly from an API. At this time it seems that this may not be
> possible in Stata without using an external python or perl script.
> However, if you have any experience in using JSON with Stata I'd be
> very happy to hear from you.
> I have begun research into writing a native Stata module (using mata)
> for reading JSON data from a web API but I thought I'd tap the
> Statalist knowledge bank first to:
> 1) stop me early if it's just not possible or already done;
> 2) suggest any strategies for how to go about this; and
> 3) see if there is any interest in such a feature or if users are
> already using some other methods that would work better than something
> native to Stata.
> Any help, advice or links to more info would be greatly appreciated.
> Thanks,
> Andrew
> *
> *   For searches and help try:
> *
> *
> *

*   For searches and help try:

© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index