names

12 rows where place_id = 677648

✎ 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
3789377 1954499 1954499 defendant Aprys Robert yeoman 677648 677648 Aprys, Robert, of Fysherton, yeoman 1
3847359 1972735 1972735 defendant Knyght Thomas clerk 677648 677648 Knyght, Thomas, of Fysherton, clerk 0
3923830 1998278 1998278 defendant Marshall John   677648 677648 Marshall, John, of Fysherton Anger, yeoman, warden of Fysherton Anger gaol 0
3926896 1999328 1999328 defendant Marshall John   677648 677648 Marshall, John, of Fysherton Anger, yeoman, warden of Fysherton Anger gaol 0
4027966 2034651 2034651 plaintiff Cole John innolder 677648 677648 Cole, John, of Fysherton Anger, innolder 0
4044242 2040394 2040394 plaintiff Randall John drover 677648 677648 Randall, John, of Fysherton Anger, drover 0
4168677 2084532 2084532 defendant Wolfries Giles gent 677648 677648 Wolfries, Giles, of Fysherton, gent 1
4171310 2085428 2085428 defendant Appowell Roger   677648 677648 Appowell, Roger, of Fysherton Anger, gent, surgeon 0
4182192 2089251 2089251 defendant Crowch Thomas innholder 677648 677648 Crowch, Thomas, of Fysherton Anger, innholder 0
4351393 2147737 2147737 defendant Bastard Giles husbandman 677648 677648 Bastard, Giles, of Fysherton Anger, husbandman 0
4613407 2235211 2235211 defendant Taillour Mathew   677648 677648 Taillour, Mathew, of Fysherton 3
5414205 2479185 2479185 defendant Stranford Thomas yeoman 677648 677648 Stranford, Thomas, of Fysherton Anger, yeoman 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);