...
| Kenttä | tyyppi | kuvaus |
|---|---|---|
| Jufo_ID | int(11) | Unique channel identifier |
| Level | int(4) | Current level |
| Name | varchar(255) | Name |
| Abbreviation | varchar(100) | Conference abbreviation |
| Other_Title | varchar(255) | Other language title or form |
| Title_Details | varchar(255) | Comments on the title |
| ISSNL | varchar(45) | ISSNL |
| ISSN1 | varchar(45) | ISSN-print |
| ISSN2 | varchar(45) | ISSN-online |
| ISBN | varchar(200) | ISBN-codes |
| Continues | varchar(255) | Jufo_ID of the predecessor |
| Continued_by | varchar(255) | Jufo_ID of the successor |
| Type | varchar(45) | Journal/series, Conference, or Book publisher |
| Website | varchar(1000) | WWW-link |
| Country | varchar(45) | Publishing country |
| Publisher | varchar(170) | Publisher (and society) |
| Language | varchar(200) | Publishing languages |
| Year_Start | int(11) | Start year |
| Year_End | int(11) | End year |
| Active | varchar(45) | Active if no end year, Inactive if end year |
| Norway_Level | int(4) | |
| Denmark_Level | int(4) | |
| SJR_SJR | decimal(6,3) | |
| SNIP | varchar(45) | |
| IPP | varchar(45) | |
| DOAJ_Index | int(11) | 1 indicates channels indexed in DOAJ |
| Jfi_Index | int(11) | 1 indicates channels indexed in Journal.fi |
| Bfeld_Index | int(11) | 1 indicates channels indexed in Bielefeld list |
| Virta_Gold | int(11) | 1 indicates Virta gold channel |
| Virta_Hybrid | int(11) | 1 indicates Virta hybrid channel |
| Virta_Green | int(11) | 1 indicates Virta green channel |
| Sherpa_Romeo_Code | varchar(45) | Green, Blue, Yellow, White |
| CreatedAt | datetime | Date of creation of Jufo_ID (2012-12-12 12:12:12) |
| ModifiedAt | datetime | Date of latest modification Jufo_ID (2012-12-12 12:12:12) |
| Active_Binary | int(1) | 1 indicates included, 0 excluded channels (e.g. duplicates) |
| Jufo_2012 | int(4) | 2012 level |
| Jufo_2013 | int(4) | 2013 level |
| Jufo_2014 | int(4) | 2014 level |
| Jufo_2015 | int(4) | 2015 level |
| Jufo_2016 | int(4) | 2016 level |
| Jufo_2017 | int(4) | 2017 level |
| Jufo_2018 | int(4) | 2018 level |
| Jufo_2019 | int(4) | 2019 level |
| Fields | varchar(100) | Codes for ERIH, Norwegian, Danish, WOS, Sopus, and MinEdu -fields |
| Scientific | int(1) | 1 Indicates scientific publications channel |
| Professional | int(1) | 1 indicates professional publication channel |
| General | int(1) | 1 indicates genera public publication channel |
| Jufo_History | varchar(300) | All time jufo levels |
| Code Block | ||||
|---|---|---|---|---|
| ||||
[{"Jufo_ID":"64592","Level":"2","Name":"Oxford journal of archaeology","Abbreviation":"","Other_Title":"","Title_Details":"","ISSNL":"","ISSN1":"0262-5253","ISSN2":"1468-0092","ISBN":"","Continues":"","Continued_by":"","Type":"Lehti\/sarja","Field":";5 Yhteiskuntatieteet;6 Humanistiset tieteet;","Subfield":";519 Yhteiskuntamaantiede, talousmaantiede;615 Historia ja arkeologia;616 Muut humanistiset tieteet;","Website":"","Country":"UNITED KINGDOM","Publisher":"Wiley-Blackwell Publishing Ltd.; Oxford University","Language":"English","Year_Start":"1982","Year_End":"","Active":"Active","Norway_Level":"2","Denmark_Level":"2","SJR_SJR":"0.540","SNIP":"0.996","IPP":"0.831","DOAJ_Index":"0","Sherpa_Romeo_Code":"Yellow","CreatedAt":"2012-12-12 12:12:12","ModifiedAt":"2015-05-25 15:29:38","Active_Binary":"1","Predator":"0","Jufo_2012":"3","Jufo_2013":"3","Jufo_2014":"3","Jufo_2015":"2","Fields":"519 Yhteiskuntamaantiede, talousmaantiede; 615 Historia ja arkeologia; 616 Muut humanistiset tieteet","Scientific":"0","Professional":"0"}] |
...