names

31 rows where place_id = 619325

✎ 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
3729329 1935426 1935426 defendant Dyke John husbandman 619325 619325 Dyke, John, of Bulmere, husbandman 0
4419962 2171148 2171148 defendant Knyght Richard   619325 619325 Knyght, Richard, of Bulmere 0
4419963 2171148 2171148 defendant Smyth John le, senior   619325 619325 Smyth, John le, senior, of Bulmere, son of John 1
4518704 2206223 2206223 defendant Smyth Thomas   619325 619325 Smyth, Thomas, of Bulmere 2
4520062 2206605 2206605 defendant Flaxton William   619325 619325 Flaxton, William, of Bulmere 0
4522123 2207261 2207261 plaintiff Goffe Richard   619325 619325 Goffe, Richard, of Bulmere, on his own account 0
4681735 2259899 2259899 defendant Smyth alias Eston John yeoman 619325 619325 Smyth alias Eston, John, of Bulmere, yeoman 4
4696227 2264304 2264304 plaintiff Calypooll Geoffrey   619325 619325 Calypooll, Geoffrey, of Bulmere 0
4728318 2274100 2274100 defendant Eston John de   619325 619325 Eston, John de, of Bulmere 8
4728334 2274101 2274101 defendant Eston John de   619325 619325 Eston, John de, of Bulmere 8
5017359 2361967 2361967 defendant Smyth William husbandman 619325 619325 Smyth, William, of Bulmere, husbandman 0
5017360 2361967 2361967 defendant Smyth John farmer 619325 619325 Smyth, John, of Bulmere, farmer 1
5017361 2361967 2361967 defendant Broun John yeoman 619325 619325 Broun, John, of Bulmere, yeoman 2
5056687 2373573 2373573 defendant Frenssh William husbandman 619325 619325 Frenssh, William, of Bulmere, husbandman 1
5056688 2373573 2373573 defendant Gugge John husbandman 619325 619325 Gugge, John, of Bulmere, husbandman 2
5067772 2376861 2376861 defendant Hereward John husbandman 619325 619325 Hereward, John, of Bulmere, husbandman 3
5095344 2385059 2385059 defendant Smyth William smith 619325 619325 Smyth, William, of Bulmere, smith 0
5127989 2394662 2394662 defendant Smyth Henry husbandman 619325 619325 Smyth, Henry, of Bulmere, husbandman 0
5135931 2397021 2397021 defendant Smyth William yeoman 619325 619325 Smyth, William, of Bulmere, yeoman 1
5135932 2397021 2397021 defendant Brown Thomas yeoman 619325 619325 Brown, Thomas, of Bulmere, yeoman 2
5142601 2398964 2398964 defendant Brygge John husbandman 619325 619325 Brygge, John, of Bulmere, husbandman 2
5164197 2405268 2405268 defendant Brygge John husbandman 619325 619325 Brygge, John, of Bulmere, husbandman 3
5245924 2428967 2428967 defendant Coppydook Thomas carpenter 619325 619325 Coppydook, Thomas, of Bulmere, carpenter 3
5250430 2430244 2430244 defendant Choloner John husbandman 619325 619325 Choloner, John, of Bulmere, husbandman 1
5250433 2430244 2430244 defendant Portelowe William husbandman 619325 619325 Portelowe, William, of Bulmere, husbandman 4
5264407 2434623 2434623 defendant Freot Robert husbandman 619325 619325 Freot, Robert, of Bulmere, husbandman 2
5266225 2435190 2435190 defendant Goldyngham Joan widow 619325 619325 Goldyngham, Joan, of Bulmere, widow 1
5364200 2464460 2464460 plaintiff (illegible) (illegible) husbandman 619325 619325 ---, ----, of Bulmere, husbandman 0
5379388 2469145 2469145 defendant Walssh John   619325 619325 Walssh, John, of Bulmere 0
5596111 2533699 2533699 defendant Russhey John husbandman 619325 619325 Russhey, John, of Bulmere, husbandman 0
5607257 2537159 2537159 defendant Russhey John husbandman 619325 619325 Russhey, John, of Bulmere, husbandman 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);