Contents

Scimago Journals

Scimago Journals

A dataset of Scimago journal ratings.

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 journal { VARCHAR country VARCHAR coverage VARCHAR issn VARCHAR publisher VARCHAR region VARCHAR title VARCHAR type INTEGER sourceid PK } journal_area { VARCHAR area INTEGER journal__sourceid FK } journal_record { VARCHAR categories INTEGER citable_docs_3years INTEGER h_index FLOAT journal_rating INTEGER rank FLOAT ref_per_doc VARCHAR sjr_best_quartile INTEGER total_cites_3years INTEGER total_docs INTEGER total_docs_3years INTEGER total_refs INTEGER journal__sourceid PK INTEGER year PK } journal_area ||--|{ journal : "journal__sourceid -> sourceid" journal_record ||--|{ journal : "journal__sourceid -> sourceid"

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.

Field Analysis

Open Notebook

Count values by fields
Q Q1 Q2 Q3 Q4
field        
Medicine (miscellaneous) 389.000000 426.000000 374.000000 307.000000
Sociology and Political Science 197.000000 97.000000 58.000000 50.000000
Mechanical Engineering 114.000000 87.000000 64.000000 68.000000
Geography, Planning and Development 98.000000 86.000000 75.000000 74.000000
Electrical and Electronic Engineering 96.000000 71.000000 60.000000 66.000000
History 111.000000 77.000000 63.000000 63.000000
Ecology, Evolution, Behavior and Systematics 99.000000 92.000000 82.000000 39.000000
Economics and Econometrics 127.000000 87.000000 48.000000 35.000000
Condensed Matter Physics 75.000000 79.000000 73.000000 57.000000
Education 152.000000 66.000000 31.000000 25.000000
Psychiatry and Mental Health 95.000000 76.000000 60.000000 38.000000
Chemistry (miscellaneous) 57.000000 78.000000 69.000000 48.000000
Materials Science (miscellaneous) 62.000000 72.000000 60.000000 52.000000
Public Health, Environmental and Occupational Health 71.000000 69.000000 62.000000 37.000000
Mechanics of Materials 76.000000 52.000000 52.000000 45.000000
Mean values of fields
  h_index journal_rating total_docs_3years
Q Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4
field                        
Medicine (miscellaneous) 138.403599 80.525822 49.620321 21.368078 1.952355 0.664251 0.375511 0.157072 850.737789 573.298122 381.534759 283.853420
Sociology and Political Science 84.091371 38.340206 20.431034 11.320000 1.497914 0.387918 0.193000 0.117420 203.984772 143.391753 106.000000 75.180000
Mechanical Engineering 128.877193 60.908046 29.718750 17.382353 1.562754 0.529828 0.290672 0.141176 1171.219298 559.816092 387.484375 410.220588
Geography, Planning and Development 76.653061 38.674419 22.093333 12.635135 1.229337 0.454767 0.242347 0.128973 281.775510 120.046512 87.600000 63.054054
Electrical and Electronic Engineering 144.250000 78.830986 36.816667 19.000000 1.906833 0.556042 0.295233 0.145561 1155.656250 1001.690141 454.650000 320.575758
History 35.720721 16.350649 10.095238 7.126984 0.477171 0.159545 0.114698 0.101079 112.414414 88.675325 69.015873 46.412698
Ecology, Evolution, Behavior and Systematics 124.878788 63.684783 40.231707 23.871795 1.492626 0.575076 0.357134 0.184308 480.070707 210.891304 152.597561 76.692308
Economics and Econometrics 113.039370 53.011494 29.229167 12.857143 3.441748 0.702667 0.331229 0.157029 327.795276 207.195402 130.604167 140.171429
Condensed Matter Physics 147.466667 93.075949 55.657534 27.543860 1.747840 0.582481 0.351151 0.177912 1605.626667 1041.101266 535.136986 514.263158
Education 79.598684 48.287879 28.064516 19.040000 1.390322 0.531803 0.292581 0.147240 246.184211 210.606061 151.548387 81.280000
Psychiatry and Mental Health 130.978947 70.657895 39.466667 19.105263 1.728611 0.767684 0.393933 0.173316 498.705263 255.776316 173.266667 144.526316
Chemistry (miscellaneous) 214.175439 80.064103 40.144928 18.979167 2.458158 0.513449 0.269188 0.129687 2317.754386 935.679487 393.000000 311.312500
Materials Science (miscellaneous) 158.161290 84.777778 38.533333 15.384615 2.168565 0.602625 0.296500 0.130538 1294.870968 810.875000 420.283333 345.923077
Public Health, Environmental and Occupational Health 120.873239 69.753623 41.919355 20.324324 1.721803 0.656087 0.375726 0.170622 744.901408 322.884058 291.112903 171.324324
Mechanics of Materials 135.750000 67.711538 34.807692 20.888889 1.629092 0.560462 0.314923 0.167733 1215.657895 567.288462 375.269231 516.933333
Concentration metrics by fields
  country publisher
  gini top5 gini top5
Q Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4
field                                
Medicine (miscellaneous) 0.784429 0.771248 0.722648 0.634130 0.899743 0.821596 0.681818 0.472313 0.542272 0.549157 0.409589 0.192732 0.246787 0.215962 0.227273 0.114007
Sociology and Political Science 0.690355 0.678538 0.551724 0.458000 0.989848 0.907216 0.689655 0.600000 0.593788 0.432317 0.294430 0.108182 0.482234 0.412371 0.379310 0.220000
Mechanical Engineering 0.558897 0.647783 0.595703 0.562092 0.973684 0.873563 0.796875 0.750000 0.543344 0.413282 0.198342 0.079696 0.535088 0.425287 0.234375 0.147059
Geography, Planning and Development 0.648980 0.729875 0.589444 0.536383 1.000000 0.895349 0.706667 0.635135 0.554731 0.468520 0.294422 0.088745 0.642857 0.534884 0.306667 0.162162
Electrical and Electronic Engineering 0.489583 0.600939 0.557143 0.586453 1.000000 0.943662 0.816667 0.772727 0.709491 0.425822 0.338542 0.069548 0.833333 0.464789 0.383333 0.151515
History 0.674389 0.614719 0.502924 0.507937 0.981982 0.805195 0.666667 0.730159 0.530346 0.347165 0.199546 0.112554 0.531532 0.324675 0.285714 0.174603
Ecology, Evolution, Behavior and Systematics 0.664830 0.631884 0.560976 0.495192 0.939394 0.858696 0.682927 0.717949 0.528313 0.381100 0.232707 0.024966 0.545455 0.336957 0.256098 0.153846
Economics and Econometrics 0.301181 0.535304 0.607639 0.386555 1.000000 0.977011 0.854167 0.600000 0.526772 0.466749 0.314655 0.053680 0.543307 0.540230 0.416667 0.200000
Condensed Matter Physics 0.586667 0.526899 0.610212 0.491228 0.933333 0.962025 0.904110 0.877193 0.482581 0.451008 0.416770 0.202951 0.546667 0.481013 0.452055 0.280702
Education 0.515789 0.647727 0.562212 0.445000 1.000000 0.954545 0.935484 0.880000 0.603659 0.409091 0.256598 0.148571 0.559211 0.454545 0.451613 0.360000
Psychiatry and Mental Health 0.685167 0.678947 0.614286 0.386997 0.915789 0.934211 0.816667 0.578947 0.366819 0.411483 0.314530 0.136513 0.315789 0.434211 0.400000 0.289474
Chemistry (miscellaneous) 0.491228 0.477564 0.516371 0.455729 0.964912 0.923077 0.608696 0.687500 0.507849 0.459135 0.315217 0.020390 0.666667 0.487179 0.362319 0.125000
Materials Science (miscellaneous) 0.510753 0.603535 0.573333 0.464744 0.983871 0.916667 0.800000 0.826923 0.539589 0.395623 0.265079 0.107023 0.677419 0.416667 0.333333 0.211538
Public Health, Environmental and Occupational Health 0.632238 0.668116 0.585253 0.378378 0.943662 0.927536 0.806452 0.594595 0.343357 0.357764 0.261815 0.026276 0.323944 0.347826 0.306452 0.162162
Mechanics of Materials 0.548872 0.569930 0.582418 0.464815 0.973684 0.846154 0.826923 0.777778 0.505639 0.366864 0.267094 0.061905 0.578947 0.461538 0.365385 0.177778

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 3 tables and the sources are checked for updates at 08:00 am, only on tuesday

Journal Area Table

Download CSV

Open Table Profile

Size: 121234 × 2 (3.24 MB)

Last Changed: 2023-04-06 17:25

area journal__sourceid
0 Biochemistry 16801
1 Genetics and Molecular Biology 16801
2 Biochemistry 18434
3 Genetics and Molecular Biology 18434
4 Immunology and Microbiology 20651

Journal Record Table

Download CSV

Open Table Profile

Size: 620540 × 13 (74.24 MB)

Last Changed: 2023-04-06 17:26

journal__sourceid year categories citable_docs_3years h_index journal_rating rank ref_per_doc sjr_best_quartile total_cites_3years total_docs total_docs_3years total_refs
0 16801 1999 Biochemistry (Q1) 80 305 50.518 1 197.10 Q1 3513 30 80 5913
1 18434 1999 Biochemistry, Genetics and Molecular Biology (... 1332 814 43.449 2 45.48 Q1 48292 351 1340 15964
2 20651 1999 Immunology (Q1); Immunology and Allergy (Q1) 81 309 43.020 3 180.55 Q1 4116 29 81 5236
3 18395 1999 Cell Biology (Q1); Developmental Biology (Q1) 60 226 35.051 4 165.36 Q1 1815 25 61 4134
4 14181 1999 Neuroscience (miscellaneous) (Q1) 60 248 25.760 5 162.81 Q1 1631 21 60 3419

Journal Table

Download CSV

Open Table Profile

Size: 70227 × 8 (10.99 MB)

Last Changed: 2023-04-06 15:10

sourceid country coverage issn publisher region title type
0 12000 United States 1999-2003, 2005, 2008 15276228 Columbus State University Northern America Journal of Technology in Counseling journal
1 12001 United States 1958-2021 00225002, 19383711 Wiley-Blackwell Northern America Journal of the Experimental Analysis of Behavior journal
2 12002 United States 1969-2021 00225061, 15206696 John Wiley & Sons Inc. Northern America Journal of the History of the Behavioral Sciences journal
3 12004 United States 2000-2021 15299740, 15299732 Routledge Northern America Journal of Trauma and Dissociation journal
4 12005 United States 1988-2021 15736598, 08949867 Wiley-Blackwell Northern America Journal of Traumatic Stress journal

previous

Explore Waves and Conditions

next

Field Analysis