Downloading data from internet

[Irene Solmone]

Hello, I need to download data from this website. Technically, to download data one is supposed to click on "query data" or "all data", which sends to this link, which downloads the data. However, I can't seem to do it on Stata. Is there a way to do it automatically? I have tried infield, insheet and import commands.

[Andrew Musau]

Unless you know that the dataset is a Stata dataset (i.e., a .dta file), then it is easier to download it to a directory on your computer and import it to Stata. If it is an Excel file, see

help import excel

If it is text-delimited data, see

help import delimited

and so on. For imports, I rarely use code the first time around as you will want to know certain details, e.g,, whether the data starts in the first row, where the variable names are, etc. So after reading the documentation, click on File \(\rightarrow\) Import \(\rightarrow \; \cdots \)

[Irene Solmone]

Thank you. It is an excel file, but the problem is that the link does not seem to work on stata directly. I know I can import and then upload in Stata, but I need to do it directly.

[Andrew Musau]

The data is stored in a ZIP file, so you need a few steps. But something like

copy "https://api.unhcr.org/population/v1/asylum-decisions/?download=true#_ga=2.211754517.1436380706.1633434402-1680802646.1633434402" query_data.zip, replace
unzipfile query_data.zip, replace
import delimited  "asylum-decisions.csv", delimiter(comma) clear

[Irene Solmone]

Thank you so much! This works

[Irene Solmone]

Andrew Musau (or anybody), is it possible to download data as a table from this website: https://app.powerbi.com/view?r=eyJrI...BiZSIsImMiOjh9 ?

[Andrew Musau]

I do not see how you do it without writing some web scraping code, but I may be wrong. Maybe others will have better ideas.

[Desalegn Hibstu]

May I get a data set on ordinal logistic regression for teaching purpose

[Andrew Musau]

The Stata manual has examples and datasets included in the entries of commands. In this case, see

help ologit