-
Notifications
You must be signed in to change notification settings - Fork 0
/
table_format.txt
29 lines (26 loc) · 2.68 KB
/
table_format.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
Fields you need to scrape from Scopus in order to answer your questions about influence and networks: Scraping is important because you need author names of the people who cited him. Because every question centers on that information -- where were they, who used him as a reference.
Article title Year
Doi
Co-author
outlet /publication
Institution of person who cites (make sure it's clear how institutional affiliation is define)
Eventual dataset will consist of four tables. IDAH will help you turn your csv output from scraping Scopus into this relational format.
TABLE_1:
uses information from the Scopus scrape, e.g. citation for the articles that cite Isaac.
article
discipline (if you want to assign it by journal)
-----
TABLE 2:
Uses information scraped from Scopus author list & some manually-entered information.
person
type (type = student y/n)
discipline (if you want to assign it by author. assumes it stays the same their whole career)
----
TABLE_3
institution_name (make sure these are normalized, e.g. that U.C. Berkeley and University of California, Berkeley don't both appear in spreadsheet)
geolocation
----
TABLE_4
Table for article info using primary keys (IDs) from other tables and adding type, and year.
article_ID person_ID institution_ID article_type
discipline (this is the hardest way to show discipline) year