Home

Indholdsfortegnelse

Hvor mange patenter er der udtaget af danske virksomheder?

csvgrep -d ';' -c 66 -e latin1 -r B[0-9] samletData.txt|wc -l
9342 (minus 1 til header)

Sekundær metode i R:

# Applications
a <- read.csv("samletData.txt",header=T,sep=";")
# Patents
p <- a[grepl("B",p$Last.publication.kind),]
dim(p)[1]
[1] 9341

Tertiær metode i Excel:

Hvor mange patenter udtaget af danske virksomheder designerer ikke DK?

I R:

# Applications
a <- read.csv("samletData.txt",header=T,sep=";")
# Patents
p <- a[grepl("B",a$Last.publication.kind),]
antal_patenter <- dim(p)[1]
# DK som designated
dk <- p[grepl("DK",p$Designated.contracting.states),]
antal_design_dk <- dim(dk)[1]
antal_patenter-antal_design_dk
[1] 2081

Sekundær metode:

cat input.txt | cut -d';' -f13 | grep -v DK | wc -l

Input-filen indeholder alle godkendte patenter fra vores data-fil.

Søjlediagram over alle lande contra antal patenter

I R:

# Applications
a <- read.csv("samletData.txt",header=T,sep=";")
# Patents
p <- a[grepl("B",a$Last.publication.kind),]
antal_patenter <- dim(p)[1]
antal_patenter
# DK som designated
dk <- p[grepl("DK",p$Designated.contracting.states),]
antal_design_dk <- dim(dk)[1]
antal_design_dk 
antal_patenter-antal_design_dk

# Hvormange patenter designerer et land?
des <- p[c("Designated.contracting.states")]
design_country <- table(unlist(strsplit(as.vector(as.character(des[,1]))," ")))
design_country
plot(design_country)

  AL   AT   BE   BG   CH   CY   CZ   DE   DK   EE   ES   FI   FR   GB   GR   HR 
 184 7952 8154 3397 8057 5049 3402 9215 7260 3397 7614 5722 9109 9136 6726  968 
  HU   IE   IS   IT   LI   LT   LU   LV   MC   MK   MT   NL   NO   PL   PT   RO 
3164 6280 2300 8593 8015 2256 7025 1975 5685  584 1280 8548  968 2607 6232 3092 
  RS   SE   SI   SK   SM   TR 
 116 8406 3219 3396  410 4166

Sekundær metode:

Baseret på fil med indhold på følgende form (fra kolonnen "Designated contracting states"):

BE DE FR GB NL SE  
BE DE FR GB LU NL  
AT BE CH DE ES FR GB GR IT LI LU NL SE  
BE DE FR GB IT NL SE

Kommando

cat input.csv | tr -d "\r" | tr " " "\n" | sort | uniq -c

Output:

 184 AL
7953 AT
8155 BE
3398 BG
8058 CH
5050 CY
3403 CZ
9216 DE
7261 DK
3398 EE
7615 ES
5723 FI
9110 FR
9137 GB
6727 GR
 968 HR
3165 HU
6281 IE
2300 IS
8594 IT
8016 LI
2256 LT
7026 LU
1975 LV
5686 MC
 584 MK
1280 MT
8549 NL
 968 NO
2608 PL
6233 PT
3093 RO
 116 RS
8407 SE
3220 SI
3397 SK
 410 SM
4167 TR

Flere eller færre end fire lande

I R (indlæsning som ovenfor)

des_count <- sapply(strsplit(as.vector(as.character(des[,1]))," "),length)
des_count_table <- table(des_count)
# 4 eller færre lande (dvs. EP-patent billigere end EU-patent)
sum(des_count_table[1:4])
[1] 458
# 5 eller flere lande
sum(des_count_table[5:length(des_count_table)])
[1] 8883

Hvor mange af de udtagne danske patenter er lavet med bidrag fra udenlandsk(e) opfinder(e)?

Excel (beskriv hvordan det er gjort):

Hvilke lande udfordrer oftest danske patenter?

Excel (beskriv hvordan det er gjort): http://cf.datawrapper.de/pZTWH/1/

DE	410
US	146
DK	130
NL	94
SE	62
CH	44
GB	44
FR	42
FI	29
AT	21
BE	11
IT	10
ES	5
NO	5
IS	4
JP	4
SG	3
HU	2
IL	2
PL	2
AU	1
CZ	1
HK	1
HR	1
IE	1

Antal udstedte patenter i perioden 2009-2013 opgjort pr. 1000 indbyggere for de 38 EPO medlemslande

http://cf.datawrapper.de/54FUZ/3/

Hvilke typer af patenter udtages der?

Baseret på kategorierne fra http://web2.wipo.int/ipcpub/.

3419   A   HUMAN NECESSITIES
2324   B   PERFORMING OPERATIONS; TRANSPORTING
3122   C   CHEMISTRY; METALLURGY
 288   D   TEXTILES; PAPER
 798   E   FIXED CONSTRUCTIONS
1535   F   MECHANICAL ENGINEERING; LIGHTING; HEATING; WEAPONS; BLASTING
1135   G   PHYSICS
1037   H   ELECTRICITY

Med underkategorier:

 341   A01   AGRICULTURE; FORESTRY; ANIMAL HUSBANDRY; HUNTING; TRAPPING; FISHING
  76   A21   BAKING; EQUIPMENT FOR MAKING OR PROCESSING DOUGHS; DOUGHS FOR BAKING
 104   A22   BUTCHERING; MEAT TREATMENT; PROCESSING POULTRY OR FISH
 494   A23   FOODS OR FOODSTUFFS; THEIR TREATMENT, NOT COVERED BY OTHER CLASSES
  13   A24   TOBACCO; CIGARS; CIGARETTES; SMOKERS REQUISITES
  22   A41   WEARING APPAREL
  14   A43   FOOTWEAR
   7   A44   HABERDASHERY; JEWELLERY
  17   A45   HAND OR TRAVELLING ARTICLES
   8   A46   BRUSHWARE
 192   A47   FURNITURE; DOMESTIC ARTICLES OR APPLIANCES; COFFEE MILLS; SPICE MILLS; SUCTION CLEANERS IN GENERAL
1990   A61   MEDICAL OR VETERINARY SCIENCE; HYGIENE
  15   A62   LIFE-SAVING; FIRE-FIGHTING
 126   A63   SPORTS; GAMES; AMUSEMENTS
 437   B01   PHYSICAL OR CHEMICAL PROCESSES OR APPARATUS IN GENERAL
  51   B02   CRUSHING, PULVERISING, OR DISINTEGRATING; PREPARATORY TREATMENT OF GRAIN FOR MILLING
  31   B03   SEPARATION OF SOLID MATERIALS USING LIQUIDS OR USING PNEUMATIC TABLES OR JIGS; MAGNETIC OR ELECTROSTATIC SEPARATION OF SOLID MATERIALS FROM SOLID MATERIALS OR FLUIDS; SEPARATION BY HIGH-VOLTAGE ELECTRIC FIELDS
  22   B04   CENTRIFUGAL APPARATUS OR MACHINES FOR CARRYING-OUT PHYSICAL OR CHEMICAL PROCESSES
  79   B05   SPRAYING OR ATOMISING IN GENERAL; APPLYING LIQUIDS OR OTHER FLUENT MATERIALS TO SURFACES, IN GENERAL
   4   B06   GENERATING OR TRANSMITTING MECHANICAL VIBRATIONS IN GENERAL
  31   B07   SEPARATING SOLIDS FROM SOLIDS; SORTING
  50   B08   CLEANING
  17   B09   DISPOSAL OF SOLID WASTE; RECLAMATION OF CONTAMINATED SOIL
  44   B21   MECHANICAL METAL-WORKING WITHOUT ESSENTIALLY REMOVING MATERIAL; PUNCHING METAL
  61   B22   CASTING; POWDER METALLURGY
  73   B23   MACHINE TOOLS; METAL-WORKING NOT OTHERWISE PROVIDED FOR
  39   B24   GRINDING; POLISHING
  23   B25   HAND TOOLS; PORTABLE POWER-DRIVEN TOOLS; HANDLES FOR HAND IMPLEMENTS; WORKSHOP EQUIPMENT; MANIPULATORS
  28   B26   HAND CUTTING TOOLS; CUTTING; SEVERING
  53   B27   WORKING OR PRESERVING WOOD OR SIMILAR MATERIAL; NAILING OR STAPLING MACHINES IN GENERAL
  38   B28   WORKING CEMENT, CLAY, OR STONE
 171   B29   WORKING OF PLASTICS; WORKING OF SUBSTANCES IN A PLASTIC STATE IN GENERAL
  12   B30   PRESSES
  20   B31   MAKING PAPER ARTICLES; WORKING PAPER
  59   B32   LAYERED PRODUCTS
  46   B41   PRINTING; LINING MACHINES; TYPEWRITERS; STAMPS
  12   B42   BOOKBINDING; ALBUMS; FILES; SPECIAL PRINTED MATTER
   3   B43   WRITING OR DRAWING IMPLEMENTS; BUREAU ACCESSORIES
  18   B44   DECORATIVE ARTS
 117   B60   VEHICLES IN GENERAL
  21   B61   RAILWAYS
  60   B62   LAND VEHICLES FOR TRAVELLING OTHERWISE THAN ON RAILS
  56   B63   SHIPS OR OTHER WATERBORNE VESSELS; RELATED EQUIPMENT
  32   B64   AIRCRAFT; AVIATION; COSMONAUTICS
 502   B65   CONVEYING; PACKING; STORING; HANDLING THIN OR FILAMENTARY MATERIAL
  46   B66   HOISTING; LIFTING; HAULING
  56   B67   OPENING OR CLOSING BOTTLES, JARS OR SIMILAR CONTAINERS; LIQUID HANDLING
   4   B68   SADDLERY; UPHOLSTERY
   6   B81   MICRO-STRUCTURAL TECHNOLOGY
   2   B82   NANO-TECHNOLOGY
 111   C01   INORGANIC CHEMISTRY
  88   C02   TREATMENT OF WATER, WASTE WATER, SEWAGE, OR SLUDGE
  73   C03   GLASS; MINERAL OR SLAG WOOL
 106   C04   CEMENTS; CONCRETE; ARTIFICIAL STONE; CERAMICS; REFRACTORIES
  15   C05   FERTILISERS; MANUFACTURE THEREOF
1039   C07   ORGANIC CHEMISTRY
 196   C08   ORGANIC MACROMOLECULAR COMPOUNDS; THEIR PREPARATION OR CHEMICAL WORKING-UP; COMPOSITIONS BASED THEREON
 101   C09   DYES; PAINTS; POLISHES; NATURAL RESINS; ADHESIVES; COMPOSITIONS NOT OTHERWISE PROVIDED FOR; APPLICATIONS OF MATERIALS NOT OTHERWISE PROVIDED FOR
  61   C10   PETROLEUM, GAS OR COKE INDUSTRIES; TECHNICAL GASES CONTAINING CARBON MONOXIDE; FUELS; LUBRICANTS; PEAT
 216   C11   ANIMAL OR VEGETABLE OILS, FATS, FATTY SUBSTANCES OR WAXES; FATTY ACIDS THEREFROM; DETERGENTS; CANDLES
 991   C12   BIOCHEMISTRY; BEER; SPIRITS; WINE; VINEGAR; MICROBIOLOGY; ENZYMOLOGY; MUTATION OR GENETIC ENGINEERING
  18   C13   SUGAR INDUSTRY
  12   C14   SKINS; HIDES; PELTS; LEATHER
   3   C21   METALLURGY OF IRON
  22   C22   METALLURGY; FERROUS OR NON-FERROUS ALLOYS; TREATMENT OF ALLOYS OR NON-FERROUS METALS
  37   C23   COATING METALLIC MATERIAL; COATING MATERIAL WITH METALLIC MATERIAL; CHEMICAL SURFACE TREATMENT; DIFFUSION TREATMENT OF METALLIC MATERIAL; COATING BY VACUUM EVAPORATION, BY SPUTTERING, BY ION IMPLANTATION OR BY CHEMICAL VAPOUR DEPOSITION, IN GENERAL; INHIBITING CORROSION OF METALLIC MATERIAL OR INCRUSTATION IN GENERAL
  18   C25   ELECTROLYTIC OR ELECTROPHORETIC PROCESSES; APPARATUS THEREFOR
   7   C30   CRYSTAL GROWTH
   8   C40   COMBINATORIAL TECHNOLOGY
  29   D01   NATURAL OR MAN-MADE THREADS OR FIBRES; SPINNING
   5   D02   YARNS; MECHANICAL FINISHING OF YARNS OR ROPES; WARPING OR BEAMING
   5   D03   WEAVING
  76   D04   BRAIDING; LACE-MAKING; KNITTING; TRIMMINGS; NON-WOVEN FABRICS
   3   D05   SEWING; EMBROIDERING; TUFTING
  89   D06   TREATMENT OF TEXTILES OR THE LIKE; LAUNDERING; FLEXIBLE MATERIALS NOT OTHERWISE PROVIDED FOR
   2   D07   ROPES; CABLES OTHER THAN ELECTRIC
  79   D21   PAPER-MAKING; PRODUCTION OF CELLULOSE
  36   E01   CONSTRUCTION OF ROADS, RAILWAYS, OR BRIDGES
  40   E02   HYDRAULIC ENGINEERING; FOUNDATIONS; SOIL-SHIFTING
  32   E03   WATER SUPPLY; SEWERAGE
 309   E04   BUILDING
 135   E05   LOCKS; KEYS; WINDOW OR DOOR FITTINGS; SAFES
 176   E06   DOORS, WINDOWS, SHUTTERS, OR ROLLER BLINDS, IN GENERAL; LADDERS
  70   E21   EARTH OR ROCK DRILLING; MINING
  99   F01   MACHINES OR ENGINES IN GENERAL; ENGINE PLANTS IN GENERAL; STEAM ENGINES
  71   F02   COMBUSTION ENGINES; HOT-GAS OR COMBUSTION-PRODUCT ENGINE PLANTS
 226   F03   MACHINES OR ENGINES FOR LIQUIDS; WIND, SPRING, OR WEIGHT MOTORS; PRODUCING MECHANICAL POWER OR A REACTIVE PROPULSIVE THRUST, NOT OTHERWISE PROVIDED FOR
 174   F04   POSITIVE-DISPLACEMENT MACHINES FOR LIQUIDS; PUMPS FOR LIQUIDS OR ELASTIC FLUIDS
  31   F15   FLUID-PRESSURE ACTUATORS; HYDRAULICS OR PNEUMATICS IN GENERAL
 457   F16   ENGINEERING ELEMENTS OR UNITS; GENERAL MEASURES FOR PRODUCING AND MAINTAINING EFFECTIVE FUNCTIONING OF MACHINES OR INSTALLATIONS; THERMAL INSULATION IN GENERAL
  11   F17   STORING OR DISTRIBUTING GASES OR LIQUIDS
  35   F21   LIGHTING
  14   F22   STEAM GENERATION
  79   F23   COMBUSTION APPARATUS; COMBUSTION PROCESSES
 113   F24   HEATING; RANGES; VENTILATING
  58   F25   REFRIGERATION OR COOLING; COMBINED HEATING AND REFRIGERATION SYSTEMS; HEAT PUMP SYSTEMS; MANUFACTURE OR STORAGE OF ICE; LIQUEFACTION OR SOLIDIFICATION OF GASES
  55   F26   DRYING
  57   F27   FURNACES; KILNS; OVENS; RETORTS
  42   F28   HEAT EXCHANGE IN GENERAL
  11   F41   WEAPONS
   2   F42   AMMUNITION; BLASTING
 609   G01   MEASURING; TESTING
  74   G02   OPTICS
  36   G03   PHOTOGRAPHY; CINEMATOGRAPHY; ANALOGOUS TECHNIQUES USING WAVES OTHER THAN OPTICAL WAVES; ELECTROGRAPHY; HOLOGRAPHY
   4   G04   HOROLOGY
  95   G05   CONTROLLING; REGULATING
 128   G06   COMPUTING; CALCULATING; COUNTING
  36   G07   CHECKING-DEVICES
  51   G08   SIGNALLING
  51   G09   EDUCATING; CRYPTOGRAPHY; DISPLAY; ADVERTISING; SEALS
  28   G10   MUSICAL INSTRUMENTS; ACOUSTICS
  19   G11   INFORMATION STORAGE
   1   G12   INSTRUMENT DETAILS
   3   G21   NUCLEAR PHYSICS; NUCLEAR ENGINEERING
 256   H01   BASIC ELECTRIC ELEMENTS
 198   H02   GENERATION, CONVERSION, OR DISTRIBUTION OF ELECTRIC POWER
  70   H03   BASIC ELECTRONIC CIRCUITRY
 460   H04   ELECTRIC COMMUNICATION TECHNIQUE
  53   H05   ELECTRIC TECHNIQUES NOT OTHERWISE PROVIDED FOR

Kunne man lave listen, med tal for patenter med DK-ejere?

Antal patenter udtaget i landende, der tilslutter sig patentdomstolen

Der findes ingen patenter - udtaget af danskere - der er gyldige i præcis de lande, som forventes at tilslutte sig patentdomstolen (herunder Danmark). Der findes tilsvarende ingen danske ansøgninger om patenter målrettet præcis denne gruppe af lande.

Provide feedback

Saved searches

Use saved searches to filter your results more quickly