names

33 rows where place_id = 757540

✎ 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
4446760 2183902 2183902 defendant Belle Richard   757540 757540 Belle, Richard, of Ottelay 0
4458621 2187744 2187744 defendant Baildon Richard   757540 757540 Baildon, Richard, of Ottelay 0
4458622 2187744 2187744 defendant Forester Adam   757540 757540 Forester, Adam, of Ottelay 1
4458627 2187745 2187745 defendant Baildon Richard de   757540 757540 Baildon, Richard de, of Ottelay 2
4486659 2196538 2196538 defendant Bank William   757540 757540 Bank, William, of Ottelay 3
4514501 2204956 2204956 defendant Skalwra William   757540 757540 Skalwra, William, of Ottelay 0
4620965 2237538 2237538 defendant Thuresby John de   757540 757540 Thuresby, John de, of Ottelay 0
4663279 2249984 2249984 defendant Corneburgh William husbandman 757540 757540 Corneburgh, William, of Ottelay, husbandman 0
4797758 2295478 2295478 defendant Thoresby John yeoman 757540 757540 Thoresby, John, of Ottelay, yeoman 1
4854376 2312768 2312768 defendant Cornburgh William husbandman 757540 757540 Cornburgh, William, of Ottelay, husbandman 4
4873737 2318727 2318727 defendant Scoles Richard yeoman 757540 757540 Scoles, Richard, of Ottelay, yeoman 3
4873738 2318727 2318727 defendant Dade John tailor 757540 757540 Dade, John, of Ottelay, tailor 4
4873739 2318727 2318727 defendant Wade John tailor 757540 757540 Wade, John, of Ottelay, tailor 5
4873740 2318727 2318727 defendant Wade Richard butcher 757540 757540 Wade, Richard, of Ottelay, butcher 6
4877033 2319789 2319789 defendant Cornburgh William husbandman 757540 757540 Cornburgh, William, of Ottelay, husbandman 2
4890545 2323802 2323802 defendant Pycard Hugh yeoman 757540 757540 Pycard, Hugh, of Ottelay, yeoman 0
4931198 2336142 2336142 defendant Plommer Richard yeoman 757540 757540 Plommer, Richard, of Ottelay, yeoman 0
4931199 2336142 2336142 defendant Piper William yeoman 757540 757540 Piper, William, of Ottelay, yeoman 1
5132876 2396110 2396110 defendant Wady Richard yeoman 757540 757540 Wady, Richard, of Ottelay, yeoman 0
5132877 2396110 2396110 defendant Wady Thomas yeoman 757540 757540 Wady, Thomas, of Ottelay, yeoman 1
5153057 2402039 2402039 defendant Wady Robert yeoman 757540 757540 Wady, Robert, of Ottelay, yeoman 0
5153062 2402039 2402039 defendant Rodes William yeoman 757540 757540 Rodes, William, of Ottelay, yeoman 5
5153063 2402039 2402039 defendant Cravyn Thomas yeoman 757540 757540 Cravyn, Thomas, of Ottelay, yeoman 6
5153065 2402039 2402039 defendant Ayssh William smith 757540 757540 Ayssh, William, of Ottelay, smith 8
5170613 2407128 2407128 defendant Wady Richard yeoman 757540 757540 Wady, Richard, of Ottelay, yeoman 0
5170614 2407128 2407128 defendant Wady Thomas yeoman 757540 757540 Wady, Thomas, of Ottelay, yeoman 1
5170619 2407128 2407128 defendant Rodes William yeoman 757540 757540 Rodes, William, of Ottelay, yeoman 6
5170620 2407128 2407128 defendant Cravyn Thomas yeoman 757540 757540 Cravyn, Thomas, of Ottelay, yeoman 7
5188403 2412324 2412324 defendant Wady Richard yeoman 757540 757540 Wady, Richard, of Ottelay, yeoman 0
5188404 2412324 2412324 defendant Wady Thomas yeoman 757540 757540 Wady, Thomas, of Ottelay, yeoman 1
5610595 2547041 2547041 plaintiff Barker William   757540 757540 Barker, William, of Ottelay, son of Nicholas 0
5610596 2547041 2547041 defendant Baildon Richard de   757540 757540 Baildon, Richard de, of Ottelay 0
5611391 2547295 2547295 plaintiff Bonefaunt Robert   757540 757540 Bonefaunt, Robert, of Ottelay, vicar 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);