names

29 rows where place_id = 669122

✎ 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
3991896 2021858 2021858 defendant Hassarde William yeoman 669122 669122 Hassarde, William, of Burporte, yeoman 0
3995544 2023152 2023152 defendant Mone Walter (legal representative) 669122 669122 Mone, Walter, of Burporte, yeoman, executrix of 1
3995545 2023152 2023152 defendant Mone Edith widow 669122 669122 Mone, Edith, of Burporte, widow 2
4150888 2078443 2078443 defendant Waye John draper 669122 669122 Waye, John, of Burporte, draper 1
4151621 2078681 2078681 defendant Webber William weaver 669122 669122 Webber, William, of Burporte, weaver 0
4151622 2078681 2078681 defendant Payne Richard weaver 669122 669122 Payne, Richard, of Burporte, weaver 1
4157326 2080628 2080628 defendant Collyns alias Hellyer Christopher hellyer or roofer 669122 669122 Collyns alias Hellyer, Christopher, of Burporte, hellyer or roofer 0
4165196 2083335 2083335 defendant Mynson James husbandman 669122 669122 Mynson, James, of Burporte, husbandman 1
4165197 2083335 2083335 defendant Gillett Thomas carpenter 669122 669122 Gillett, Thomas, of Burporte, carpenter 2
4170747 2085261 2085261 defendant Gillett Thomas carpenter 669122 669122 Gillett, Thomas, of Burporte, carpenter 2
4174548 2086567 2086567 defendant Peache Robert butcher 669122 669122 Peache, Robert, of Burporte, butcher 0
4186519 2090769 2090769 defendant Alforde William victualer 669122 669122 Alforde, William, of Burporte, victualer 1
4186935 2090918 2090918 defendant Woodes John yeoman 669122 669122 Woodes, John, of Burporte, yeoman 0
4194138 2093501 2093501 defendant Gillett Thomas carpenter 669122 669122 Gillett, Thomas, of Burporte, carpenter 2
4197952 2094833 2094833 defendant Peache Robert butcher 669122 669122 Peache, Robert, of Burporte, butcher 0
4199394 2095338 2095338 defendant Stracheleighe Nicholas gent 669122 669122 Stracheleighe, Nicholas, of Burporte, gent 2
4199395 2095338 2095338 defendant Balston John merchant 669122 669122 Balston, John, of Burporte, merchant 3
4199400 2095340 2095340 defendant Durke John shoemaker 669122 669122 Durke, John, of Burporte, shoemaker 0
4206324 2097758 2097758 defendant Alford John yeoman 669122 669122 Alford, John, of Burporte, yeoman 0
4210202 2099129 2099129 defendant Alford William victualer 669122 669122 Alford William, of Burporte, victualer 1
4210408 2099198 2099198 defendant Alforde Richard yeoman 669122 669122 Alforde, Richard, of Burporte, yeoman 0
4212941 2100054 2100054 defendant Goselinge William shoemaker 669122 669122 Goselinge, William, of Burporte, shoemaker 0
4241119 2110015 2110015 defendant Tiggens Richard merchant 669122 669122 Tiggens, Richard, of Burporte, merchant 2
4241120 2110015 2110015 defendant Moone Morgan gent 669122 669122 Moone, Morgan, of Burporte, gent 3
4250063 2113003 2113003 defendant Moone Morgan gent 669122 669122 Moone, Morgan, of Burporte, gent 2
4285893 2125006 2125006 defendant Tyggens John merchant 669122 669122 Tyggens, John, of Burporte, merchant 0
4306974 2132581 2132581 defendant Mone Gilbert chapman 669122 669122 Mone, Gilbert, of Burporte, chapman 1
4324446 2138570 2138570 defendant Moone Morgan yeoman 669122 669122 Moone, Morgan, of Burporte, yeoman 1
4331296 2140762 2140762 defendant Davidge Richard, senior merchant 669122 669122 Davidge, Richard, senior, of Burporte, merchant 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);