Eurostat European Commission: Difference between revisions

From Pardee Wiki
Jump to navigation Jump to search
mNo edit summary
 
(12 intermediate revisions by the same user not shown)
Line 5: Line 5:


== SUMMARY ==
== SUMMARY ==
THIS PAGE EXPLAINS THE STEPS TAKEN TO PULL DATA SERIES FROM THE EUROSTAT EUROPEAN COMMISSION DATABASE.
[https://ec.europa.eu/eurostat/web/main/home Eurostat] is a Directorate-General of the European Commission which is the statistical office of the European Union (EU). Eurostat collects and publishes aggregate data on various variables in EU countries. Users can rely on the Eurostat database to find a number of data series and variables such as: SeriesICTCybEnterprises%ISDNConnection, SeriesICTCybEnterprises%MobileBroadbandConnection, SeriesICTCybEnterprises%SecFacOffStorage, and SeriesICTCybEnterprisesC%SecPolicyDataLoss.
 
== STEPS TO PULL DATA FROM EUROSTAT EUROPEAN COMMISSION ==
== STEPS TO PULL DATA FROM EUROSTAT EUROPEAN COMMISSION ==


1. First, navigate to https://ec.europa.eu/eurostat/web/main/home.
1. First, navigate to https://ec.europa.eu/eurostat/web/main/home.
[[File:Screenshot 20230121 123939.png|center|thumb|767x767px|Screenshot of landing page for the link above.]]
[[File:SOURCE IMG STEP 01.png|center|thumb|779x779px|Landing page for link above]]


2. Hover over the "Data" tab with your cursor to expand the data tab options.
2. Hover over the "Data" tab with your cursor to expand the data tab options.[[File:Step2.jpg|center|thumb|774x774px]]
[[File:Step2.jpg|alt=Screenshot of expanded data tab.|center|thumb|768x768px|Screenshot of expanded data tab.]]


3. Under Data, click on the database tab which will take you to a new page.[[File:Step3.jpg|alt=Screenshot of database tab|center|thumb|771x771px|Screenshot of the database tab.]]4. In the database landing page, you will see two tabs. One called "NEW DATA NAVIGATION TREE" and another tab called "DATABASE" which contains different themes and topic for data series. The New Data Navigation Tree tool under the first tab is user friendly and allows you to easily find data series by general topics, so we will rely on it in this example. See screenshot below.
3. Under Data, click on the database tab which will take you to a new page.[[File:Step3.jpg|alt=Screenshot of database tab|center|thumb|771x771px|Screenshot of the database tab.]]4. In the database landing page, you will see two tabs. One called "NEW DATA NAVIGATION TREE" and another tab called "DATABASE" which contains different themes and topic for data series. The New Data Navigation Tree tool under the first tab is user friendly and allows you to easily find data series by general topics, so we will rely on it in this example. See screenshot below.
[[File:Step 4 .jpg|center|thumb|771x771px|Screenshot of first and second tab and Eurostat's New Navigation Tree tool.]]
[[File:Step 4 .jpg|center|thumb|771x771px|Screenshot of first and second tab and Eurostat's New Navigation Tree tool.]]
5. Click on Eurostat's new data navigation tree hyperlink.
 
[[File:Step5.jpg|center|thumb|769x769px|Screenshot of Eurostat's new data navigation tree hyperlink.]]
5. Click on Eurostat's new data navigation tree hyperlink. [[File:Step5.jpg|center|thumb|769x769px|Screenshot of Eurostat's new data navigation tree hyperlink.]]6. Once you are on the new data navigation tree page, you may choose the category your series is in.[[File:SOURCE IMG STEP 05.png|center|thumb|766x766px|Category selection]]
6. Once on the new landing page, you may choose any of the topics to find your data series. In this example, we will click on the "Transport" tab to find the data series "Railway transport - length of tacks".
 
[[File:Step 6.jpg|center|thumb|765x765px|Screenshot of Transport tab.]]
== VARIABLE EXAMPLE: SeriesICTBroadbandHouseholdEStat ==
7. After clicking on Transport, we will expand the Railway Transport tab by clicking on the + symbol on the left.
 
[[File:Step 7.jpg|center|thumb|765x765px|Screenshot of Railway Transport.]]
7. Once on the new landing page, you may choose any of the topics to find your data series. In this example, we will click on the "Science, technology, digital society" tab to find the variable SeriesICTBroadbandHouseholdEStat.[[File:SOURCE IMG STEP 07.jpg|center|thumb|758x758px|Category selection]]8. After clicking on "Science, technology, and digital society", we will expand the "Digital economy and society" tab by clicking on the + symbol on the left.[[File:SOURCE IMG STEP 08.jpg|center|thumb|763x763px|Click + symbol]]
8. Click on "Railway transport infrastructure", then click on "Railway transport - length of tracks" on the right-hand side of the tool.
 
[[File:Step 8.jpg|center|thumb|765x765px|Screenshot of tabs.]]
 
9. After clicking on "Railway transport - length of tracks", you will be able to see the data series and may manipulate the country and years selection by clicking on the drop down menu for each.
9. After expanding the tab, series will populate on the right-hand side of the screen. Find your series and click on the hyperlink to view the data.[[File:SOURCE IMG STEP 09.jpg|center|thumb|750x750px|Click on hyperlink for series]]
10. After clicking on "Households with broadband access", you will be able to see the data series and may manipulate the country and years selection by clicking on the drop down menu for each.[[File:SOURCE IMG STEP 10.jpg|center|thumb|750x750px|Change year/country selection]]
11. To download the desired selection, click on download and select the desired file type (e.g., csv).[[File:SOURCE IMG STEP 11.jpg|center|thumb|750x750px|Format and download]]

Latest revision as of 22:05, 24 January 2023


SUMMARY

Eurostat is a Directorate-General of the European Commission which is the statistical office of the European Union (EU). Eurostat collects and publishes aggregate data on various variables in EU countries. Users can rely on the Eurostat database to find a number of data series and variables such as: SeriesICTCybEnterprises%ISDNConnection, SeriesICTCybEnterprises%MobileBroadbandConnection, SeriesICTCybEnterprises%SecFacOffStorage, and SeriesICTCybEnterprisesC%SecPolicyDataLoss.

STEPS TO PULL DATA FROM EUROSTAT EUROPEAN COMMISSION

1. First, navigate to https://ec.europa.eu/eurostat/web/main/home.

Landing page for link above
2. Hover over the "Data" tab with your cursor to expand the data tab options.
Step2.jpg
3. Under Data, click on the database tab which will take you to a new page.
Screenshot of database tab
Screenshot of the database tab.
4. In the database landing page, you will see two tabs. One called "NEW DATA NAVIGATION TREE" and another tab called "DATABASE" which contains different themes and topic for data series. The New Data Navigation Tree tool under the first tab is user friendly and allows you to easily find data series by general topics, so we will rely on it in this example. See screenshot below.
Screenshot of first and second tab and Eurostat's New Navigation Tree tool.
5. Click on Eurostat's new data navigation tree hyperlink.
Screenshot of Eurostat's new data navigation tree hyperlink.
6. Once you are on the new data navigation tree page, you may choose the category your series is in.
Category selection

VARIABLE EXAMPLE: SeriesICTBroadbandHouseholdEStat

7. Once on the new landing page, you may choose any of the topics to find your data series. In this example, we will click on the "Science, technology, digital society" tab to find the variable SeriesICTBroadbandHouseholdEStat.
Category selection
8. After clicking on "Science, technology, and digital society", we will expand the "Digital economy and society" tab by clicking on the + symbol on the left.
Click + symbol


9. After expanding the tab, series will populate on the right-hand side of the screen. Find your series and click on the hyperlink to view the data.
Click on hyperlink for series
10. After clicking on "Households with broadband access", you will be able to see the data series and may manipulate the country and years selection by clicking on the drop down menu for each.
Change year/country selection
11. To download the desired selection, click on download and select the desired file type (e.g., csv).
Format and download