Input
- Input Table: nermem_sports_test, which has rows of sports news
- model_file: location.sports, output by NamedEntityFinderTrainer Example
id | content |
---|---|
3 | <START:LOCATION> LONDON <END> 1996-08-30 |
4 | West Indian all-rounder <START:PER> Phil Simmons <END> took four for 38 on Friday as <START:ORG> Leicestershire <END> beat <START:ORG> Somerset <END> by an innings and 39 runs in two days to take over at the head of the county championship . |
6 | After bowling <START:ORG> Somerset <END> out for 83 on the opening morning at <START:LOCATION> Grace Road <END> |
9 | <START:PER> Hussain <END> |
10 | By the close <START:ORG> Yorkshire <END> had turned that into a 37-run advantage but off-spinner <START:PER> Such <END> had scuttled their hopes |
11 | At the <START:LOCATION> Oval <END> |
12 | He was well backed by <START:LOCATION> England <END> hopeful <START:PER> Mark Butcher <END> who made 70 as <START:ORG> Surrey <END> closed on 429 for seven |
14 | Australian <START:PER> Tom Moody <END> took six for 82 but <START:PER> Chris Adams <END> |
16 | They were held up by a gritty 84 from <START:PER> Paul Johnson <END> but ex-England fast bowler <START:PER> Martin McCague <END> took four for 55 . |
20 | <START:LOCATION> LONDON <END> 1996-08-30 |
22 | <START:LOCATION> Leicester <END> : <START:ORG> Leicestershire <END> beat <START:ORG> Somerset <END> by an innings and 39 runs . |
... | ... |
SQL Call
SELECT * FROM NamedEntityFinderEvaluatorReduce ( ON NamedEntityFinderEvaluatorMap ( ON nermem_sports_test USING InputModelFile ('location.sports') TextColumn ('content') ) PARTITION BY 1 ) AS dt;
Output
precision_val recall f_measure ----------------- ------------------ ----------------- 0.847457627118644 0.7936507936507936 0.819672131147541
Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.