names

29 rows where place_id = 658910

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3950320 2007194 2007194 defendant Garret alias Funder Nicholas laborer 658910 658910 Garret alias Funder, Nicholas, of Battle, Sussex, laborer 6
4151074 2078506 2078506 defendant Fynche Anthony gent 658910 658910 Fynche, Anthony, of Battle, Sussex, gent 0
4157240 2080601 2080601 defendant Foote John yeoman 658910 658910 Foote, John, of Battle, Sussex, yeoman 0
4213940 2100397 2100397 defendant Garton William gent 658910 658910 Garton, William, of Battle, Sussex, gent 0
4242608 2110520 2110520 defendant Carter Nicholas yeoman 658910 658910 Carter, Nicholas, of Battle, Sussex, yeoman 0
4244007 2110976 2110976 defendant Carter Nicholas keeper of the great park in Battell 658910 658910 Carter, Nicholas, of Battle, Sussex, yeoman, keeper of the great park in Battell 0
4253220 2114072 2114072 defendant Oxenbredge Thomas yeoman 658910 658910 Oxenbredge, Thomas, of Battle, Sussex, yeoman 1
4383279 2159126 2159126 defendant Sadler Richard chapman 658910 658910 Sadler, Richard, of Battle, Sussex, chapman 0
4519845 2206558 2206558 defendant Penbrok John   658910 658910 Penbrok, John, of Battle, Sussex 1
4657946 2248369 2248369 defendant Morton William schoolmaster 658910 658910 Morton, William, of Battle, Sussex, schoolmaster 2
4658184 2248437 2248437 defendant Morton William schoolmaster 658910 658910 Morton, William, of Battle, Sussex, schoolmaster 2
5000000 2356882 2356882 plaintiff Lonesford William (legal representative) 658910 658910 Lonesford, William, of Battle, Sussex, executors of 0
5042525 2369369 2369369 plaintiff Dertmouth Richard   658910 658910 Dertmouth, Richard, of Battle, Sussex, abbot of St Martin's monastery 0
5067503 2376779 2376779 defendant Ludoes John hosier 658910 658910 Ludoes, John, of Battle, Sussex, hosier 0
5129898 2395232 2395232 plaintiff Dertmouth Richard   658910 658910 Dertmouth, Richard, of Battle, Sussex, abbot 0
5156014 2402915 2402915 defendant Colman Richard yeoman 658910 658910 Colman, Richard, of Battle, Sussex, yeoman 1
5156017 2402916 2402916 defendant Colman Richard yeoman 658910 658910 Colman, Richard, of Battle, Sussex, yeoman 1
5159117 2403783 2403783 defendant Erche William carpenter 658910 658910 Erche, William, of Battle, Sussex, carpenter 1
5172362 2407641 2407641 defendant Colman Richard yeoman 658910 658910 Colman, Richard, of Battle, Sussex, yeoman 1
5172530 2407691 2407691 defendant Colman Richard yeoman 658910 658910 Colman, Richard, of Battle, Sussex, yeoman 1
5395259 2473717 2473717 defendant Bayle Denise   658910 658910 Bayle, Denise, of Battle, Sussex, coryour 4
5403892 2476185 2476185 plaintiff Newton John   658910 658910 Newton, John, of Battle, Sussex, abbot of St Martin's Monastery 0
5403894 2476186 2476186 plaintiff Newton John   658910 658910 Newton, John, of Battle, Sussex, abbot of St Martin's Monastery 0
5408526 2477514 2477514 defendant Bayle Denis currier 658910 658910 Bayle, Denis, of Battle, Sussex, currier 4
5421697 2481426 2481426 defendant Bayle Denis skinner 658910 658910 Bayle, Denis, of Battle, Sussex, skinner 4
5528755 2513513 2513513 defendant Wildegose William yeoman 658910 658910 Wildegose, William, of Battle, Sussex, yeoman 2
5528763 2513516 2513516 defendant Wildegose William yeoman 658910 658910 Wildegose, William, of Battle, Sussex, yeoman 2
5566580 2524820 2524820 defendant Forde John yeoman 658910 658910 Forde, John, of Battle, Sussex, yeoman 1
5575331 2527374 2527374 defendant Kyngeswell John barber 658910 658910 Kyngeswell, John, of Battle, Sussex, barber 1

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);