names

16 rows where case_id = 1984605

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3883077 1984605 1984605 plaintiff Uttyng Nicholas     Uttyng, Nicholas 0
3883078 1984605 1984605 plaintiff Edwardis Robert     Edwardis, Robert 1
3883079 1984605 1984605 defendant Whitered Geoffrey yeoman 613621 613621 Whitered, Geoffrey, of Barneham Brome, yeoman 0
3883080 1984605 1984605 defendant Debney John husbandman 613621 613621 Debney, John, of Barneham Brome, husbandman 1
3883081 1984605 1984605 defendant Debney George husbandman 613621 613621 Debney, George, of Barneham Brome, husbandman 2
3883082 1984605 1984605 defendant Lawes John husbandman 613621 613621 Lawes, John, of Barneham Brome, husbandman 3
3883083 1984605 1984605 defendant Shank Thomas husbandman 600379 600379 Shank, Thomas, of Est Denham, husbandman 4
3883084 1984605 1984605 defendant Wryght John yeoman 613621 613621 Wryght, John, of Barneham Brome, yeoman 5
3883085 1984605 1984605 defendant Ascue Hugh yeoman 613621 613621 Ascue, Hugh, of Barneham Brome, yeoman 6
3883086 1984605 1984605 defendant Aldred Edmund husbandman 613621 613621 Aldred, Edmund, of Barneham Brome, husbandman 7
3883087 1984605 1984605 defendant Whitacre Henry tailor 613621 613621 Whitacre, Henry, of Barneham Brome, tailor 8
3883088 1984605 1984605 defendant Cooke John husbandman 600379 600379 Cooke, John, of Est Denham, husbandman 9
3883089 1984605 1984605 defendant Baye William husbandman 613621 613621 Baye, William, of Barneham Brome, husbandman 10
3883090 1984605 1984605 defendant Darby Robert tailor 613621 613621 Darby, Robert, of Barneham Brome, tailor 11
3883091 1984605 1984605 defendant Frany John smith 644979 644979 Frany, John, of Bykerston, smith 12
3883092 1984605 1984605 defendant Sparrowe John smith 644979 644979 Sparrowe, John, of Bykerston, smith 13

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