names

35 rows where place_id = 692434

✎ 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
3714542 1930845 1930845 defendant Hawkyn Mathew husbandman 692434 692434 Hawkyn, Mathew, of Booton under Blean, husbandman 0
4003419 2025985 2025985 defendant Croche John   692434 692434 Croche, John, of Booton, wool chapman 0
4091014 2057076 2057076 defendant Shacke Peter yeoman 692434 692434 Shacke, Peter, of Booton, or of Wychyngham Magna, yeoman 0
4094909 2058510 2058510 defendant Pearne William gent 692434 692434 Pearne, William, of Booton, gent 0
4108776 2063391 2063391 defendant Arnolde William gent 692434 692434 Arnolde, William, of Booton, gent 0
4108781 2063393 2063393 defendant Arnolde William gent 692434 692434 Arnolde, William, of Booton, gent 0
4112370 2064682 2064682 defendant Grotche William   692434 692434 Grotche, William, of Booton, wool chapman 1
4113284 2065018 2065018 defendant Pearne William gent 692434 692434 Pearne, William, of Booton, gent 0
4113285 2065018 2065018 defendant Jubbes John yeoman 692434 692434 Jubbes, John, of Booton, yeoman 1
4120574 2067635 2067635 defendant Crotche William   692434 692434 Crotche, William, of Booton, wool chapman 0
4122176 2068237 2068237 defendant Crotche William yeoman 692434 692434 Crotche, William, of Booton, yeoman 0
4126245 2069677 2069677 defendant Crotche William   692434 692434 Crotche, William, of Booton, wool chapman 1
4126246 2069677 2069677 defendant Crotche Robert husbandman 692434 692434 Crotche, Robert, of Booton, husbandman 2
4161368 2082056 2082056 defendant Arnold William gent 692434 692434 Arnold, William, of Booton, gent 0
4171607 2085534 2085534 defendant Frarye Christopher husbandman 692434 692434 Frarye, Christopher, of Booton, husbandman 0
4171608 2085534 2085534 defendant Callarde Emanuel gent 692434 692434 together with Callarde, Emanuel, of Booton, gent 1
4171610 2085535 2085535 defendant Frarye Christopher husbandman 692434 692434 Frarye, Christopher, of Booton, husbandman 0
4171611 2085535 2085535 defendant Callarde Emanuel gent 692434 692434 together with Callarde, Emanuel, of Booton, gent 1
4172459 2085830 2085830 defendant Crotche William yeoman 692434 692434 Crotche, William, of Booton, yeoman 0
4182202 2089254 2089254 defendant Crotch William   692434 692434 Crotch, William, of Booton, wool chapman 0
4190717 2092315 2092315 defendant Blackborne James husbandman 692434 692434 Blackborne, James, of Booton, husbandman 2
4191510 2092594 2092594 defendant Perne William gent 692434 692434 Perne, William, of Booton, gent 2
4229552 2105824 2105824 defendant Kynge Christopher laborer 692434 692434 Kynge, Christopher, of Booton, laborer 0
4243348 2110767 2110767 defendant Perne William gent 692434 692434 Perne, William, of Booton, gent 0
4252890 2113961 2113961 defendant Crotche William yeoman 692434 692434 Crotche, William, of Booton, yeoman 0
4258466 2115799 2115799 defendant Fenton Edward clerk 692434 692434 Fenton, Edward, of Booton, clerk 0
4286233 2125131 2125131 defendant Crotche William   692434 692434 Crotche, William, of Booton, wool chapman 1
4291332 2126973 2126973 defendant Claxton Thomas gent 692434 692434 Claxton, Thomas, of Booton, gent 0
4352550 2148130 2148130 defendant Claxton Thomas gent 692434 692434 Claxton, Thomas, of Booton, gent 0
4361530 2151284 2151284 defendant Claxton Thomas yeoman 692434 692434 Claxton, Thomas, of Booton, yeoman 0
4386795 2160253 2160253 defendant Claxton Thomas gent 692434 692434 Claxton, Thomas, of Booton, gent 0
4387350 2160418 2160418 defendant Claxton Thomas gent 692434 692434 Claxton, Thomas, of Booton, gent 0
4387543 2160474 2160474 defendant Claxton Thomas gent 692434 692434 Claxton, Thomas, of Booton, gent 0
4396753 2163482 2163482 defendant Gray Peter husbandman 692434 692434 Gray, Peter, of Booton, husbandman 0
5559035 2522602 2522602 defendant Haukyn Thomas husbandman 692434 692434 Haukyn, Thomas, of Booton under Blean, husbandman 2

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