names

29 rows where place_id = 705166

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4156160 2080228 2080228 defendant Wylbore Robert yeoman 705166 705166 Wylbore, Robert, of Glynton, yeoman 0
4156161 2080228 2080228 defendant Fooe John yeoman 705166 705166 Fooe, John, of Glynton, yeoman 1
4210985 2099400 2099400 defendant Bocher John yeoman 705166 705166 Bocher, John, of Glynton, yeoman 2
4426771 2173188 2173188 defendant Andreu John   705166 705166 Andreu, John, of Glynton 0
4730319 2274681 2274681 defendant Adkyn John husbandman 705166 705166 Adkyn, John, of Glynton, husbandman 1
4730321 2274682 2274682 defendant Smyth Nicholas husbandman 705166 705166 Smyth, Nicholas, of Glynton, husbandman 0
4730322 2274682 2274682 defendant Bluntesham William husbandman 705166 705166 Bluntesham, William, of Glynton, husbandman 1
4730323 2274682 2274682 defendant Lesse Richard husbandman 705166 705166 Lesse, Richard, of Glynton, husbandman 2
4730324 2274682 2274682 defendant Wattesson John husbandman 705166 705166 Wattesson, John, of Glynton, husbandman 3
4901600 2327103 2327103 defendant Drus Robert husbandman 705166 705166 Drus, Robert, of Glynton, husbandman 2
5071100 2377849 2377849 defendant Hareby Peter husbandman 705166 705166 Hareby, Peter, of Glynton, husbandman 1
5071101 2377849 2377849 defendant Western John husbandman 705166 705166 Western, John, of Glynton, husbandman 2
5071104 2377850 2377850 defendant Hareby Peter husbandman 705166 705166 Hareby, Peter, of Glynton, husbandman 1
5071105 2377850 2377850 defendant Western John husbandman 705166 705166 Western, John, of Glynton, husbandman 2
5121742 2392788 2392788 defendant Spaldyng William husbandman 705166 705166 Spaldyng, William, of Glynton, husbandman 1
5233079 2425258 2425258 defendant Spaldyng William husbandman 705166 705166 Spaldyng, William, of Glynton, husbandman 4
5245067 2428725 2428725 defendant North William husbandman 705166 705166 North, William, of Glynton, husbandman 0
5574437 2527089 2527089 defendant Walgot Thomas husbandman 705166 705166 Walgot, Thomas, of Glynton, husbandman 0
5574438 2527089 2527089 defendant Halleman Richard husbandman 705166 705166 Halleman, Richard, of Glynton, husbandman 1
5574439 2527089 2527089 defendant Marcham Robert husbandman 705166 705166 Marcham, Robert, of Glynton, husbandman 2
5574440 2527089 2527089 defendant Hawe William husbandman 705166 705166 Hawe, William, of Glynton, husbandman 3
5574441 2527089 2527089 defendant Hawe Robert husbandman 705166 705166 Hawe, Robert, of Glynton, husbandman 4
5574442 2527089 2527089 defendant Hakeman Nicholas husbandman 705166 705166 Hakeman, Nicholas, of Glynton, husbandman 5
5589492 2531715 2531715 defendant Walgott Thomas husbandman 705166 705166 Walgott, Thomas, of Glynton, husbandman 0
5589493 2531715 2531715 defendant Hackman Richard husbandman 705166 705166 Hackman, Richard, of Glynton, husbandman 1
5589494 2531715 2531715 defendant Marham William husbandman 705166 705166 Marham, William, of Glynton, husbandman 2
5589495 2531715 2531715 defendant Hawe William husbandman 705166 705166 Hawe, William, of Glynton, husbandman 3
5589496 2531715 2531715 defendant Hawe Robert husbandman 705166 705166 Hawe, Robert, of Glynton, husbandman 4
5618960 2549771 2549771 defendant Taillor Richard   705166 705166 Taillor, Richard, of Glynton 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);