names

20 rows where place_id = 650801

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3914016 1995031 1995031 defendant Mensworth William husbandman 650801 650801 Mensworth, William, of Sudbroke, husbandman 1
3955978 2009161 2009161 defendant ap Owen John husbandman 650801 650801 ap Owen, John, of Sudbroke, husbandman 2
3960955 2010930 2010930 defendant Corell John husbandman 650801 650801 Corell, John, of Sudbroke, husbandman 0
4081637 2053735 2053735 defendant Robert John husbandman 650801 650801 Robert, John, of Sudbroke, husbandman 0
4573436 2223221 2223221 defendant Dorley Thomas   650801 650801 Dorley, Thomas, of Sudbroke 0
4646957 2245171 2245171 defendant Sudbroke Simon de   650801 650801 Sudbroke, Simon de, of Sudbroke 1
4725807 2273357 2273357 defendant Holme Simon husbandman 650801 650801 Holme, Simon, of Sudbroke, husbandman 0
5076403 2379443 2379443 defendant Cokson William   650801 650801 Cokson, William,of Sudbroke, wright 0
5101772 2386942 2386942 defendant Hoby Robert husbandman 650801 650801 Hoby, Robert, of Sudbroke, husbandman 0
5120199 2392349 2392349 defendant Wryght alias Coke William husbandman 650801 650801 Wryght alias Coke, William, of Sudbroke, husbandman 0
5267431 2435575 2435575 defendant Cokson William husbandman 650801 650801 Cokson, William, of Sudbroke juxta Ancaster, husbandman 10
5412526 2478693 2478693 defendant Calnarte Richard yeoman 650801 650801 Calnarte, Richard, of Sudbroke by Ancaster, yeoman 0
5427099 2483045 2483045 defendant Calvarte Richard yeoman 650801 650801 Calvarte, Richard, of Sudbroke by Ancaster, yeoman 0
5457823 2492236 2492236 defendant Calnarte Richard yeoman 650801 650801 Calnarte, Richard, of Sudbroke by Ancaster, yeoman 0
5457826 2492237 2492237 defendant Calnarte Richard yeoman 650801 650801 Calnarte, Richard, of Sudbroke by Ancaster, yeoman 0
5461225 2493305 2493305 defendant Calmere Richard yeoman 650801 650801 Calmere, Richard, of Sudbroke, yeoman 0
5472774 2496823 2496823 defendant Calvere Richard yeoman 650801 650801 Calvere, Richard, of Sudbroke, yeoman 0
5472780 2496824 2496824 defendant Calvere Richard   650801 650801 Calvere, Richard, of Sudbroke 0
5472786 2496825 2496825 defendant Calvere Richard   650801 650801 Calvere, Richard, of Sudbroke 0
5484362 2500243 2500243 defendant Calvere Richard yeoman 650801 650801 Calvere, Richard, of Sudbroke, yeoman 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);