| |
DatabaseTables
Page history last edited by Steven Morris 1 yr ago
Database tables
working table
| Field | Type | Note | | citing_key | int | paper key | | Title | text (255) | title text | | Source | text (255) | paper journal | | DT | text (50) | document type | | Year | date/time | publication date | | Author1 | text (50) | first author | | Vol | text (50) | journal volume | | Is | text (50) | journal issue | | PN | text (50) | journal part number | | UT | text (50) | WOS paper identifier |
citations
| Field | Type | Note | | citing | int | paper key | | citation | text (255) | reference in WOS format |
cite_keys
| Field | Type | Note | | CiteID | int | reference key | | citation | text (255) | reference in WOS format | | year | date/time | reference year | | author | text (80) | reference author | | BP | text (80) | beginning page | | Vol | text (80) | reference journal volume | | So | text (80) | reference journal |
id
| Field | Type | Note | | citing_key | int | paper key | | id | text (50) | WOS ID term |
institution
| Field | Type | Note | | citing_key | int | paper key | | Institution | text (100) | single line from WOS institution field, not parsed |
abstract
| Field | Type | Note | | citing_key | int | paper key | | line_no | int | abstract line number | | abstract | text (80) | single line WOS abstract |
citing_authors
| Field | Type | Note | | citing_key | int | paper key | | author | text (50) | paper author | | author_no | int | position in paper's author list |
derwent_keys
| Field | Type | Note | | d_key | int | derwent paper from Liying's Excel file | | UT | text (50) | WOS paper identifier |
inst__keys
| Field | Type | Note | | i_index | int | institution key | | inst | text (100) | Institution |
diva_country
| Field | Type | Note | | citing_key | int | paper key | | c_index | int | country key |
diva_inst
| Field | Type | Note | | citing_key | int | paper key | | i_index | int | institution key |
de
| Field | Type | Note | | citing_key | int | paper key | | de | text (100) | WOS DE term |
diva_keys
| Field | Type | Note | | de_key | int | DE term key | | de | text (50) | WOS DE term |
pj_keys
| Field | Type | Note | | pj_key | int | paper journal key | | source | text (50) | paper journal |
ref_journal_keys
| Field | Type | Note | | ref_journal_key | int | reference journal key | | jr | text (50) | WOS | reference journal | | count | int | ref journal citation count |
ref_author_keys
| Field | Type | Note | | ref_author_key | int | reference author key | | author | text (50) | reference author | | count | int | ref author citation count |
author_keys
| Field | Type | Note | | author_key | int | paper author key | | author | text (50) | paper author |
cite_table
| Field | Type | Note | | CiteID | int | reference key | | citing_key | int | paper key |
cluster_coc
| Field | Type | Note | | citeid | int | reference key | | cluster | int | cocitation cluster number |
den_ord_tab
| Field | Type | Note | | cluster | int | cocitation cluster number | | dend_ord | int | order of cocitation cluster on dendrogram |
view1
| Field | Type | Note | | citing_key | int | paper key |
DatabaseTables
|
|
Tip: To turn text into a link, highlight the text, then click on a page or file from the list above.
|
|
|
Comments (0)
You don't have permission to comment on this page.