names

19 rows where place_id = 596329

✎ 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
3624233 1875110 1875110 defendant Drewerey Thomas husbandman 596329 596329 Drewerey, Thomas, of Bredgare, husbandman 1
3636361 1906163 1906163 defendant Alyn Geoffrey husbandman 596329 596329 Alyn, Geoffrey, of Bredgare, husbandman 4
3639636 1907205 1907205 defendant Carter William laborer 596329 596329 Carter, William, of Bredgare, laborer 0
3640475 1907453 1907453 defendant Alen Geoffrey husbandman 596329 596329 Alen, Geoffrey, of Bredgare, husbandman 2
3640481 1907454 1907454 defendant Aleyn Geoffrey husbandman 596329 596329 Aleyn, Geoffrey, of Bredgare, husbandman 2
3671654 1917122 1917122 defendant Aleyn Geoffrey husbandman 596329 596329 Aleyn, Geoffrey, of Bredgare, husbandman 0
3671655 1917122 1917122 defendant Davy John husbandman 596329 596329 Davy, John, of Bredgare, husbandman 1
3696433 1925109 1925109 defendant Reder John husbandman 596329 596329 Reder, John, of Bredgare, husbandman 0
3838568 1969989 1969989 defendant Brokhole James husbandman 596329 596329 Brokhole, James, of Bredgare, husbandman 0
3854815 1975150 1975150 defendant Brokhole James husbandman 596329 596329 Brokhole, James, of Bredgare, husbandman 0
3869088 1979908 1979908 defendant Brokhole James husbandman 596329 596329 Brokhole, James, of Bredgare, husbandman 0
4012883 2029335 2029335 plaintiff Reder William gent 596329 596329 Reder, William, of Bredgare, gent 0
4012885 2029336 2029336 plaintiff Reder William gent 596329 596329 Reder, William, of Bredgare, gent 0
4712589 2269256 2269256 defendant Hogge John laborer 596329 596329 Hogge, John, of Bredgare, laborer 1
5373348 2467264 2467264 defendant Denwey Thomas clerk 596329 596329 Denwey, Thomas, of Bredgare, clerk 1
5460368 2493041 2493041 defendant Penteney Richard chaplain 596329 596329 Penteney, Richard, of Bredgare, chaplain 0
5519560 2510955 2510955 defendant Drewery Thomas husbandman 596329 596329 Drewery, Thomas, of Bredgare, husbandman 0
5539945 2516976 2516976 defendant Roger Richard smith 596329 596329 Roger, Richard, of Bredgare, smith 2
5621391 2550581 2550581 defendant Lompette Robert   596329 596329 Lompette, Robert, of Bredgare 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);