names

35 rows where place_id = 828151

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4824528 2303719 2303719 defendant Bodrugan William   828151 828151 Bodrugan, William, of Bodrugan, knight 0
4867582 2316831 2316831 defendant Bodrugan William   828151 828151 Bodrugan, William, of Bodrugan, knight 0
4867585 2316832 2316832 defendant Bodrugan William   828151 828151 Bodrugan, William, of Bodrugan, knight 0
4902879 2327515 2327515 defendant Bodrugan William   828151 828151 Bodrugan, William, of Bodrugan, knight 0
4964457 2346282 2346282 plaintiff Clerk William yeoman or tanner 828151 828151 Clerk, William, of Bodrugan, yeoman or tanner 0
5040484 2368761 2368761 defendant Bodrugan Henry gent 828151 828151 Bodrugan, Henry, of Bodrugan, gent 0
5077505 2379772 2379772 defendant Bodrugan Henry gent 828151 828151 Bodrugan, Henry, of Bodrugan, gent 0
5077643 2379810 2379810 defendant Bodrugan Hery gent 828151 828151 Bodrugan, Hery, of Bodrugan, gent 0
5215199 2420173 2420173 defendant Bodrugan Henry esq 828151 828151 Bodrugan, Henry, of Bodrugan, esq 0
5229832 2424344 2424344 defendant Olyver William yeoman 828151 828151 Olyver, William, of Bodrugan, yeoman 4
5229876 2424358 2424358 defendant Olyver William yeoman 828151 828151 Olyver, William, of Bodrugan, yeoman 2
5229880 2424359 2424359 defendant Olyver William yeoman 828151 828151 Olyver, William, of Bodrugan, yeoman 2
5254613 2431563 2431563 defendant Tremern Henry yeoman 828151 828151 Tremern, Henry, of Bodrugan, yeoman 2
5254620 2431565 2431565 defendant Tremern Henry yeoman 828151 828151 Tremern, Henry, of Bodrugan, yeoman 0
5255742 2431914 2431914 defendant Bodrugan Henry esq 828151 828151 Bodrugan, Henry, of Bodrugan, esq 0
5273439 2437305 2437305 defendant Bodrugan Henry esq & Lord Bodrugan 828151 828151 Bodrugan, Henry, of Bodrugan, esq & Lord Bodrugan 0
5273561 2437343 2437343 defendant Orton John yeoman 828151 828151 Orton, John, of Bodrugan & Westminster, yeoman 1
5273564 2437344 2437344 defendant Orton John yeoman 828151 828151 Orton, John, of Bodrugan, yeoman 1
5298376 2444499 2444499 defendant Bodrugan Henry esq 828151 828151 Bodrugan, Henry, of Bodrugan, esq 0
5323780 2452198 2452198 defendant Bodrugan Henry esq 828151 828151 together with Bodrugan, Henry, of Bodrugan, esq 5
5323781 2452198 2452198 defendant Beamond John esq 828151 828151 Beamond, John, of Bodrugan, esq 6
5323783 2452199 2452199 defendant Bodrugan Henry esq 828151 828151 Bodrugan, Henry, of Bodrugan, esq 0
5323784 2452199 2452199 defendant Beamond John esq 828151 828151 Beamond, John, of Bodrugan, esq 1
5323826 2452210 2452210 defendant Beamond John   828151 828151 Beamond, John, of Bodrugan esq 1
5323834 2452211 2452211 defendant Beamond John   828151 828151 Beamond, John, of Bodrugan esq 1
5323842 2452212 2452212 defendant Beamond John esq 828151 828151 Beamond, John, of Bodrugan, esq 1
5349515 2459978 2459978 defendant Mason John yeoman 828151 828151 Mason, John, of Bodrugan, yeoman 0
5349516 2459978 2459978 defendant Stonard Richard gent 828151 828151 Stonard, Richard, of Bodrugan, gent 1
5349518 2459979 2459979 defendant Mason John yeoman 828151 828151 Mason, John, of Bodrugan, yeoman 0
5349519 2459979 2459979 defendant Stonard Richard gent 828151 828151 Stonard, Richard, of Bodrugan, gent 1
5349520 2459979 2459979 defendant Davy John yeoman 828151 828151 Davy, John, of Bodrugan, yeoman 2
5349524 2459980 2459980 defendant Stonard Richard gent 828151 828151 together with Stonard, Richard, of Bodrugan, gent 2
5349526 2459981 2459981 defendant Stonard Richard gent 828151 828151 Stonard, Richard, of Bodrugan, gent 0
5484673 2500339 2500339 defendant Blakney Owen yeoman 828151 828151 Blakney, Owen, of Bodrugan, yeoman 12
5567804 2525160 2525160 defendant Brodrugan Owen gent 828151 828151 Brodrugan, Owen, of Bodrugan, gent 0

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);