names

10 rows where place_id = 605671

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3662523 1914196 1914196 defendant Wryght Ralph husbandman 605671 605671 Wryght, Ralph, of Bryxworth, husbandman 0
3806425 1959920 1959920 defendant Hall John husbandman 605671 605671 Hall, John, of Bryxworth, husbandman 0
3876521 1982393 1982393 defendant Pye Richard husbandman 605671 605671 Pye, Richard, of Bryxworth, husbandman 0
3936861 2002662 2002662 defendant Prestwood John yeoman 605671 605671 Prestwood, John, of Bryxworth, yeoman 3
4661181 2249322 2249322 defendant Wryght John   605671 605671 Wryght, John, of Bryxworth, wright 5
4696439 2264363 2264363 defendant Prist John gent 605671 605671 Prist, John, of Bryxworth, gent 2
5309227 2447795 2447795 defendant Brydgose John butcher 605671 605671 Brydgose, John, of Bryxworth, butcher 3
5325297 2452654 2452654 defendant Jakus Thomas husbandman 605671 605671 Jakus, Thomas, of Bryxworth, husbandman 0
5332009 2454648 2454648 defendant Lubbenham John gent 605671 605671 Lubbenham, John, of Bryxworth, gent 0
5364216 2464465 2464465 defendant Tarre Richard tailor 605671 605671 Tarre, Richard, of Bryxworth, tailor 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);