names

18 rows where place_id = 706952

✎ 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
3767572 1947495 1947495 defendant Mynnet Thomas husbandman 706952 706952 Mynnet, Thomas, of Est Drayton, husbandman 0
3923372 1998124 1998124 defendant Sampson Thomas husbandman 706952 706952 Sampson, Thomas, of Est Drayton, husbandman 0
4165477 2083427 2083427 defendant Mynett Thomas yeoman 706952 706952 Mynett, Thomas, of East Drayton, yeoman 2
4525000 2208160 2208160 plaintiff Hure John   706952 706952 Hure, John, of East Drayton 0
4628633 2239878 2239878 plaintiff Seger William   706952 706952 Seger, William, of East Drayton, vicar 0
4628636 2239879 2239879 plaintiff Seger William   706952 706952 Seger, William, of East Drayton, vicar 0
4734111 2275853 2275853 plaintiff Rypers Thomas (legal representative) 706952 706952 Rypers, Thomas, of East Drayton, executors of 0
4734112 2275853 2275853 plaintiff Seger William   706952 706952 (Seger, William, of East Drayton 1
4952995 2342860 2342860 defendant Barthorp John husbandman 706952 706952 Barthorp, John, of Est Drayton, husbandman 0
5105180 2387954 2387954 defendant Rayner John yeoman 706952 706952 Rayner, John, of Est Drayton, yeoman 1
5277793 2438590 2438590 defendant Smyth Thomas husbandman 706952 706952 Smyth, Thomas, of Est Drayton, husbandman 1
5277797 2438591 2438591 defendant Smyth Thoms husbandman 706952 706952 Smyth, Thoms, of Est Drayton, husbandman 1
5412482 2478679 2478679 defendant Barthorp John husbandman 706952 706952 Barthorp, John, of East Drayton, husbandman 0
5427283 2483104 2483104 defendant Barthorp John husbandman 706952 706952 Barthorp, John, of East Drayton, husbandman 0
5427285 2483105 2483105 defendant Barthorp John husbandman 706952 706952 Barthorp, John, of East Drayton, husbandman 0
5447657 2489171 2489171 defendant Mynet John, senior husbandman 706952 706952 Mynet, John, senior, of East Drayton, husbandman 0
5604327 2536216 2536216 plaintiff Rayner Robert yeoman 706952 706952 Rayner, Robert, of Est Drayton, yeoman 0
5616051 2548814 2548814 defendant Neel Robert   706952 706952 Neel, Robert, of East Drayton 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);