codebook contents
This page gives a full accounting of all the tables and fields in the database. For reference of how the fields relate to tables, visit the individual table-pages.
Available Tables
Article
article
LBIO sources
Entity
entity
Companies, organisatons and people
Exploiter
exploiter
Linking innovatons to names of entities exploiting the innovation
Innovation to Article
innovation_article
Connecting table between innovations and articles
Innovation to Entity
innovation_entity
Companies, people and organisations
Origin
origin
Innovation origin
Spinoff
spinoff
Linking innovatons to names of entities of which the innovation spunoff
Technological Knowhow
techknow
Technological Knowhow (ADD DEF)
Use Sector
sector
Innovation to SNI-use sector table.
VariantName
name_variant
Companies, organisatons and people
innovation
innovation
The heart of the SWINNO database
Available Fields
Additional_info_if_Origin__2a_Official_regulation,_legislation_and_standards.
ori_2a_note
Additional information if Origin Official regulation legislation and standards
Additional_information_if_Origin__1a_New_scientific_discovery
ori_1a_note
Additional information if Origin New scientific discovery
Additional_information_if_Origin__1b_New_technologies_or_materials
ori_1b_note
Additional information if Origin New technologies or materials
Additional_information_if_Origin__20_Other
ori_20_note
Additional information if Origin Other
Additional_information_if_Origin__5b_Solution_for_a_problem
ori_5b_note
Additional information if Origin Solution for a problem
Additional_information_if_Origin__7_Performance
ori_7_note
Additional information if Origin Performance
Annex_or_supplement
annex
The article s annex or supplement if any
Article ID
article_id
Unique, stable identifier for the source article.
Article ID
id
Unique, stable identifier for the source article.
Article title
title
The title of the source article.
Article type
type
A characterisation of the source content
Artifactual_complexity
art_comp
What is the complexity of the innovation as artifact as opposed to the development of the innovation
Commissioner
commissioner
Name of the agent company governmental agency etc that has commissioned the innovation
Corporate_group
corp
In the SWINNO extension collection Name of the corporate group of the firm as stated in the source article
Country
country
In which country was the collaborating actor located during the collaboration. ISO 3166-1 alpha-3 codes with amendments.
Description_in_Swedish
desc_sv
Description of the innovation in Swedish This may include the purpose or function of the innovation and what is new about it and how it works
Developed_in_collaboration_with_other_actors
collaboration
Has the development of the innovation included collaboration with others
Developmental_complexity
dev_comp
Complexity of the development of the innovation
Entity ID
entity_id
Unique, stable identifier for the entity.
External_financing_received
ext_financed
Has external funding been received
Firm_founded_for_development_or_commercialization
firm_launched_development
Was the firm founded to develop or commercialize the innovation
Firm_only_produces_the_innovation
prod_only
If the firm recorded as Innovating firm produces the innovation but has not developed it this variable has the value 1
Id
id
Unique, stable identifier for the link between innovation and article.
Innovation ID
innovation_id
The SINNO ID uniquely identifies an item in the database so even between collections there are no doubles The ID consists of a follow number plus a three digit extension that indicates what kind of thing it is
Innovation Status
status
Status of the innovation
Innovation to Article ID
id
The SINNO ID uniquely identifies an item in the database so even between collections there are no doubles The ID consists of a follow number plus a three digit extension that indicates what kind of thing it is
Innovation to Entity ID
id
The SINNO ID uniquely identifies an item in the database so even between collections there are no doubles The ID consists of a follow number plus a three digit extension that indicates what kind of thing it is
Innovation_name_in_English
name_en
Name of the innovation in English if any and if different from the Swedish name
Innovation_name_in_Swedish
name_sv
Name of the innovation if any
Issue
issue
The journal s or annex issue that contains the article
Journal_or_magazine
journal_magazine
The journal or magazine that contains the article This could be a standardized rather than a literal name
Literal Name
name
Literal name of an entity, as written in the article.
Location
loc
Location of the innovating firm
Name variant
text
The a variant name
Notes
notes
Additional notes about the article.
Novelty_from_firm_perspective
novelty_firm
Degree of novelty from the firm perspective
Novelty_from_market_perspective
novelty_mkt
Degree of novelty from the perspective of the Swedish and the global market respectively
Origins
origin
Which factors contributed to the origin of the innovation
Pages
pages
On which pages does the article occur
Patented
patented
Whether the innovation, or parts thereof, are patented according to the method explained in Johansson, M., Nyqvist, J., & Taalbi, J. (2022).
Person
person
Boolean, true|1 if the entity is a person. -- not part of the public dataset.
Previously_developing_firms
prev_dev
Name of firm previously responsible for the development of the innovation
Product_code
prod_code
Product code of the innovation according to Svensk Näringslivsindelning SNI 2002 In principle a five digit code is entered where possible
Public_technology_program's_name
pub_tech_prog
If there is a public technology program involved then what is the name
Public_technology_program_involved
used_pub_prog
Has a public technology program been involved in the development of the innovation
Relationship subtype
subtype
The subtype of relationship between the innovaiton and collaborating or funding organizations
Relationship type
type
The type of relationship between the innovaiton and entity
SINNO's_common_name
name
The common name of the firm or organization
Science_spin-off
science_spin
Is the company a spinoff from a university or research institute
Spinoff
spinoff
The university or research institute that that the innovation spun off from
Start_year_of_development
year_dev
In which year did the development of the innovation start
Technical Knowhow
techknow
Technican knowhow
Use_sectors
use_sector
User sector of the innovation according to Svensk Näringslivsindelning SNI 2002, with a few custom codes.
Volume
vol
The volume of the source article
Year of issue
year
The year in which the article was published.
Year_of_commercialization
year
Commercialization year of the innovation This is either the year as mentioned in the sources or if no year is mentioned the year of the earliest article that reports that the innovation is for sale
Year_of_first_presentation
yr_first_present
The year that the basic idea of the innovation was presented
Year_of_first_prototype
year_proto
The year in which the first prototype was introduced
a_patent_application_exists
pat_applied
A patent application exists for the innovation.
export_has_started
exported
Export of the innovation has started.
firm_applying_for_patent
pat_firm_applying
The name of the firm that is applying for a patent related to the innovation.
name variant ID
id
Unique, stable identifier for the name.
patent_granted
pat_granted
At least one patent had been granted.
start_year_of_export
yr_export
The year in which the innovation was first exported