names

16 rows where place_id = 643846

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3876163 1982275 1982275 defendant Alman Thomas clerk 643846 643846 Alman, Thomas, of Beston, Norf, clerk 0
4005671 2026801 2026801 defendant Nune James gent 643846 643846 Nune, James, of Beston, Norf, gent 1
4006931 2027252 2027252 defendant Peerson Richard laborer 643846 643846 Peerson, Richard, of Beston, Norf, laborer 2
4119267 2067185 2067185 defendant Leman Walter grocer 643846 643846 Leman, Walter, of Beston, Norf, grocer 0
4119271 2067186 2067186 defendant Leman Walter grocer 643846 643846 Leman, Walter, of Beston, Norf, grocer 0
4167025 2083969 2083969 defendant Allen Roger, senior husbandman 643846 643846 Allen, Roger, senior, of Beston, Norf, husbandman 0
4167027 2083970 2083970 defendant Ashyll William carpenter 643846 643846 Ashyll, William, of Beston, Norf, carpenter 0
4167029 2083971 2083971 defendant Lenam Walter grocer 643846 643846 Lenam, Walter, of Beston, Norf, grocer 0
4196124 2094192 2094192 defendant Collyn John grocer 643846 643846 Collyn, John, of Beston, Norf, grocer 0
4333484 2141479 2141479 defendant Wadelowe Edward yeoman 643846 643846 Wadelowe, Edward, of Beston, Norf, yeoman 1
4684312 2260696 2260696 defendant Thomkyn John yeoman 643846 643846 Thomkyn, John, of Beston, Norf, yeoman 0
4738106 2277021 2277021 defendant Buk John yeoman 643846 643846 Buk, John, of Beston, Norf, yeoman 4
4738112 2277022 2277022 defendant Buk John yeoman 643846 643846 Buk, John, of Beston, Norf, yeoman 4
4828589 2304983 2304983 plaintiff Arnold John shipman 643846 643846 Arnold, John, of Beston, Norf, shipman 0
4830229 2305491 2305491 defendant Smyth Thomas fishmonger 643846 643846 Smyth, Thomas, of Beston, Norf, fishmonger 4
4830237 2305493 2305493 defendant Smyth Thomas fishmonger 643846 643846 Smyth, Thomas, of Beston, Norf, fishmonger 4

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