Contents

RePEc via NEP

RePEc via NEP

A dataset of RePEc (Research Papers in Economics)

Entity Relationship Diagram (ERD)

What is an Entity Relationship Diagram (ERD)?

An entity relationship diagram (ERD) shows the relationships of entity sets stored in a database. An entity in this context is an object, a component of data, for example a variable. An entity set is a collection of similar entities. These entities can have attributes that define their properties.

By defining the entities, and their attributes, and showing the relationships between them, an ER diagram illustrates the logical structure of databases.

Each table demonstrates an entity set, where the rows represent the entities. Each entity set contains a primary key (PK) which is unique in the table. A primary key can be one entity, for example, a tax number or a set of entities like longitude and latitude in spatial data.

An entity set may have got a foreign key (FK). It means that the table is connected to another table’s primary key. This relationship can be represented by a line with a sign on its every ending. The sign specifies how many instances of an entity relate to one instance of another entity:

  • double lines (one)

  • branching line (more)

erDiagram authorship { VARCHAR author__aid PK VARCHAR paper__pid PK } paper { VARCHAR abstract VARCHAR institution VARCHAR keywords VARCHAR link VARCHAR title FLOAT year VARCHAR pid PK } nep { VARCHAR info VARCHAR title VARCHAR nid PK } nep_inclusion { VARCHAR paper__pid FK INTEGER ind PK VARCHAR issue__neid PK } nep_issue { VARCHAR nep__nid FK DATETIME published VARCHAR neid PK } authorship ||--|{ paper : "paper__pid -> pid" nep_inclusion ||--|{ nep_issue : "issue__neid -> neid" nep_inclusion ||--|{ paper : "paper__pid -> pid" nep_issue ||--|{ nep : "nep__nid -> nid"

Exploratory Data Analysis (EDA)

What does exploratory data analysis contain?

These are some summaries of the initial analyses we conducted on the tables of the dataset. They are based on our ideas that we think can be further explored in a research project.

The exploration notebooks can be checked by clicking on the Open Notebook button. If you just want to see the output figures of the analysis, then open them with the Figures button.

Papers Analysis

Open Notebook

../_images/out-61.png ../_images/out-111.png
Top 10 institutions by published papers
  count
institution  
University Library of Munich, Germany 30027
National Bureau of Economic Research, Inc 20463
Institute of Labor Economics (IZA) 14808
HAL 13249
arXiv.org 10906
C.E.P.R. Discussion Papers 10373
Agricultural and Applied Economics Association 5529
The World Bank 5236
CESifo 4575
Center for Open Science 4359
Top 10 authors by published papers
  count
author__aid  
Asongu Simplice 1559
Bank World 907
Gupta Rangan 748
Mcaleer Michael 644
Fund International Monetary 622
Oecd 508
Tol Richard 397
Odhiambo Nicholas 358
Van Reenen John 316
Yogyakarta Perpustakaan Stipram 305
Top 10 authors affilieated with the most institution
  institution
author__aid  
Ongena Steven 46
Ottaviano Gianmarco 40
Peri Giovanni 39
Clark Andrew 39
Eichengreen Barry 39
Verdier Thierry 39
Devereux Michael 38
Cabrales Antonio 37
Schularick Moritz 36
Spagnolo Giancarlo 36

Tables

How should I use this?

Table information

Each table has a Table Profile, generated by pandas-profiling. This includes descriptive statistics based on the table data and metadata, which can save significant time during the pre-analysis. Each profiling contains descriptives of the variables and additionally may show interactions, correlations, missing data information, and samples of the data. To see the profiling click on Open Table Profile.

Furthermore, you can check the first 5 rows of the tables by clicking on the First 5 rows button.

Download links

The table data can be downloaded in CSV format with Download CSV button. Before this step, we recommend checking the table profile!

Updating information

Some datasets are updated periodically. In this case, you can check the updating period at the top of this section.

There are 5 tables and the sources are checked for updates at 08:00 am, only on tuesday

Authorship Table

Download CSV

Open Table Profile

Size: 789715 × 2 (26.18 MB)

Last Changed: 2023-04-06 15:10

author__aid paper__pid
0 kakizawa:hisanobu ospwpaper/22j004
1 morgan:peter risadbiwp/1312
2 marouani:mohamed ergwpaper/sprr20222
3 krafft:caroline ergwpaper/swp20225
4 green:colin nstsamfok/19422

Nep Inclusion Table

Download CSV

Open Table Profile

Size: 844213 × 3 (31.92 MB)

Last Changed: 2023-04-06 15:10

ind issue__neid paper__pid
0 22 nepenv-2022-12-05 bdrborrec/1218
1 23 nepenv-2022-12-05 fipfedhwp/95078
2 24 nepenv-2022-12-05 cesceswps/_5f10053
3 25 nepenv-2022-12-05 fipfedgfe/2022-73
4 26 nepenv-2022-12-05 fipfedgfe/2022-68

Nep Issue Table

Download CSV

Open Table Profile

Size: 82992 × 3 (2.99 MB)

Last Changed: 2023-04-06 15:10

neid nep__nid published
0 nepenv-2022-12-05 nepenv 2022-12-05
1 nepure-2022-10-31 nepure 2022-10-31
2 nepure-2023-01-09 nepure 2023-01-09
3 nepenv-2023-01-16 nepenv 2023-01-16
4 nepenv-2022-11-21 nepenv 2022-11-21

Nep Table

Download CSV

Open Table Profile

Size: 95 × 3 (11.11 kB)

Last Changed: 2023-04-06 15:10

nid info title
0 nep-acc Alexander Harin, Modern University for the Hum... Accounting and Auditing
1 nep-afr Sam Sarpong, Xiamen University Malaysia Campus... Africa
2 nep-age Claudia Villosio, LABORatorio R. Revelli, Ital... Economics of Ageing
3 nep-agr Angelo Zago, Università degli Studi di Verona,... Agricultural Economics
4 nep-ara Paul Makdissi, Université d’Ottawa, Canada, 21... MENA - Middle East and North Africa

Paper Table

Download CSV

Open Table Profile

Size: 393543 × 7 (162.22 MB)

Last Changed: 2023-04-06 15:11

pid abstract institution keywords link title year
0 ospwpaper/22j004 This study aims to describe the extent to whic... Osaka School of International Public Policy, O... class size; deviation value; panel data https://econpapers.repec.org/paper/ospwpaper/2... The Effects of Class Size on Primary and Secon... 2022.0
1 risadbiwp/1312 The outbreak of the COVID-19 virus and the res... Asian Development Bank Institute COVID-19; ASEAN; household income; employment;... https://econpapers.repec.org/paper/risadbiwp/1... Impacts of COVID-19 on Households in ASEAN Cou... 2022.0
2 ergwpaper/sprr20222 Morocco adopted a very stringent lockdown regi... Economic Research Forum None https://econpapers.repec.org/paper/ergwpaper/s... Morocco COVID-19 Country Case Study 2022.0
3 ergwpaper/swp20225 The COVID-19 pandemic has been accompanied by ... Economic Research Forum None https://econpapers.repec.org/paper/ergwpaper/s... The Impact of the COVID-19 Pandemic on Women’s... 2022.0
4 nstsamfok/19422 How much young children should be tested and g... Department of Economics, Norwegian University ... student assessment; testing; student achievement https://econpapers.repec.org/paper/nstsamfok/1... How does testing young children influence educ... NaN

previous

Usage Analysis

next

Papers Analysis