names

12 rows where place_id = 597016

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3626955 1903285 1903285 defendant Walter Robert husbandman 597016 597016 Walter, Robert, of Cullesdon, husbandman 0
3807550 1960269 1960269 defendant A Wodde Nicholas yeoman 597016 597016 A Wodde, Nicholas, of Cullesdon, yeoman 0
3830736 1967497 1967497 defendant Hayes Richard husbandman 597016 597016 Hayes, Richard, of Cullesdon, husbandman 0
5025281 2364288 2364288 defendant Basset Thomas husbandman 597016 597016 Basset, Thomas, of Cullesdon, husbandman 0
5358785 2462808 2462808 defendant Ropkyn Robert yeoman 597016 597016 Ropkyn, Robert, of Cullesdon, yeoman 0
5476412 2497946 2497946 defendant Ropkyn William yeoman 597016 597016 Ropkyn, William, of Cullesdon, yeoman 5
5487916 2501276 2501276 defendant Ropkyn John (legal representative) 597016 597016 Ropkyn, John, of Cullesdon, yeoman, executor of 2
5487917 2501276 2501276 defendant Ropkyn William yeoman 597016 597016 Ropkyn, William, of Cullesdon, yeoman 3
5565673 2524550 2524550 defendant Wode Nicholas husbandman 597016 597016 Wode, Nicholas, of Cullesdon, husbandman 2
5577681 2528089 2528089 defendant Wode Nicholas husbandman 597016 597016 Wode, Nicholas, of Cullesdon, husbandman 0
5602047 2535539 2535539 defendant Pender William husbandman 597016 597016 Pender, William, of Cullesdon, husbandman 0
5602049 2535539 2535539 defendant Rokynham Richard husbandman 597016 597016 Rokynham, Richard, of Cullesdon, husbandman 2

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