names

24 rows where place_id = 602373

✎ 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
3649837 1910312 1910312 defendant Reve Gilbert husbandman 602373 602373 Reve, Gilbert, of Staunton St John, husbandman 0
3666972 1915613 1915613 defendant Petye Percival clerk 602373 602373 Petye, Percival, of Staunton St John, clerk 4
3673181 1917625 1917625 defendant Rede Kenelm gent 602373 602373 Rede, Kenelm, of Staunton St John, gent 0
3700230 1926306 1926306 defendant Pety Percival clerk 602373 602373 Pety, Percival, of Staunton St John, clerk 1
3994586 2022810 2022810 plaintiff Colls Mathew yeoman 602373 602373 Colls, Mathew, of Staunton St John, yeoman 0
4285774 2124965 2124965 defendant Hopper William yeoman 602373 602373 Hopper, William, of Staunton St John, yeoman 1
4302312 2130926 2130926 defendant White John yeoman 602373 602373 White, John, of Staunton St John, yeoman 0
4420452 2171302 2171302 defendant Bernard Maud   602373 602373 Bernard, Maud, of Staunton St John 0
4533162 2210638 2210638 plaintiff Baillyf Peter   602373 602373 Baillyf, Peter, of Staunton St John 1
4533671 2210800 2210800 plaintiff Baillif Peter   602373 602373 Baillif, Peter, of Staunton St John 1
4766795 2285609 2285609 defendant Mundy William husbandman 602373 602373 Mundy, William, of Staunton St John, husbandman 0
4865756 2316254 2316254 defendant Denmore Thomas   602373 602373 Denmore, Thomas, of Staunton St John 3
4872804 2318443 2318443 defendant Denmore Thomas   602373 602373 Denmore, Thomas, of Staunton St John 3
4881705 2321177 2321177 defendant Denmore Thomas   602373 602373 Denmore, Thomas, of Staunton St John 3
4881851 2321222 2321222 defendant Denmore Thomas   602373 602373 Denmore, Thomas, of Staunton St John 3
5048882 2371298 2371298 defendant Danyell John, senior husbandman 602373 602373 Danyell, John, senior, of Staunton St John, husbandman 0
5252245 2430811 2430811 defendant Haddon Robert yeoman 602373 602373 Haddon, Robert, of Staunton St John, yeoman 0
5252246 2430811 2430811 defendant Ady John yeoman 602373 602373 Ady, John, of Staunton St John, yeoman 1
5430001 2483912 2483912 defendant Haddon Robert husbandman 602373 602373 Haddon, Robert, of Staunton St John, husbandman 0
5430002 2483912 2483912 defendant Haddon William yeoman 602373 602373 Haddon, William, of Staunton St John, yeoman 1
5446860 2488956 2488956 defendant Haddon Robert husbandman 602373 602373 Haddon, Robert, of Staunton St John, husbandman 0
5446861 2488956 2488956 defendant Haddon William yeoman 602373 602373 Haddon, William, of Staunton St John, yeoman 1
5572479 2526495 2526495 defendant Diker Robert clerk 602373 602373 Diker, Robert, of Staunton St John, clerk 0
5576656 2527746 2527746 defendant Diker Robert clerk 602373 602373 Diker, Robert, of Staunton St John, clerk 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);