names

15 rows where place_id = 651783

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3919711 1996931 1996931 plaintiff Long Thomas clothmaker 651783 651783 Long, Thomas, of Trowbridge, Wilts, clothmaker 0
3995781 2023239 2023239 defendant Chever Roger yeoman 651783 651783 Chever, Roger, of Trowbridge, Wilts, yeoman 0
4044420 2040457 2040457 defendant Langeford Edward   651783 651783 Langeford, Edward, of Trowbridge, Wilts, gent, son of Alexander 0
4077398 2052203 2052203 defendant Langford Alexander gent 651783 651783 Langford, Alexander, of Trowbridge, Wilts, gent 0
4078341 2052553 2052553 defendant Erbery William clothier 651783 651783 Erbery, William, of Trowbridge, Wilts, clothier 1
4117167 2066447 2066447 defendant Saige John yeoman or servant 651783 651783 Saige, John, of trowbridge, Wilts, yeoman or servant 0
4131833 2071699 2071699 defendant Langford Richard draper 651783 651783 Langford, Richard, of Trowbridge, Wilts, yeoman, draper 1
4147512 2077272 2077272 defendant Horlock Thomas yeoman 651783 651783 Horlock, Thomas, of Trowbridge, Wilts, yeoman 1
4155650 2080058 2080058 defendant Langeford Richard yeoman 651783 651783 Langeford, Richard, of Trowbridge, Wilts, yeoman 1
4230904 2106307 2106307 defendant Erberye Thomas clothier 651783 651783 Erberye, Thomas, of Trowbridge, Wilts, clothier 0
4248845 2112603 2112603 defendant Westwood William carpenter 651783 651783 Westwood, William, of Trowbridge, Wilts, carpenter 1
4567936 2221540 2221540 defendant Lyndesey Peter   651783 651783 Lyndesey, Peter, of Trowbridge, Wilts 2
4989065 2353668 2353668 defendant Hembury William butcher 651783 651783 Hembury, William, of Trowbridge, Wilts, butcher 0
4998721 2356506 2356506 defendant Broun Geoffrey dyer 651783 651783 Broun, Geoffrey, of Trowbridge, Wilts, dyer 1
5273566 2437345 2437345 defendant Guatte John husbandman 651783 651783 Guatte, John, of Trowbridge, Wilts, husbandman 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);