names

26 rows where place_id = 618022

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3722459 1933284 1933284 defendant Dey Robert husbandman 618022 618022 Dey, Robert, of Gelston, husbandman 0
3738227 1938170 1938170 defendant Dey Robert husbandman 618022 618022 Dey, Robert, of Gelston, husbandman 0
3872317 1980966 1980966 defendant Crysted Robert sherman 618022 618022 Crysted, Robert, of Gelston, sherman 1
3937828 2002985 2002985 defendant Mayhewe John husbandman 618022 618022 Mayhewe, John, of Gelston, husbandman 0
3947593 2006220 2006220 defendant Seman Thomas husbandman 618022 618022 Seman, Thomas, of Gelston, husbandman 2
4062766 2046983 2046983 defendant Collon William weaver 618022 618022 Collon, William, of Gelston, weaver 2
4064844 2047713 2047713 defendant Wurledge Thomas husbandman 618022 618022 Wurledge, Thomas, of Gelston, husbandman 2
4089762 2056635 2056635 defendant Bownde John yeoman 618022 618022 Bownde, John, of Gelston, yeoman 0
4089763 2056635 2056635 defendant Davye William yeoman 618022 618022 Davye, William, of Gelston, yeoman 1
4089765 2056636 2056636 defendant Davye William yeoman 618022 618022 Davye, William, of Gelston, yeoman 0
4089766 2056636 2056636 defendant Bownde John yeoman 618022 618022 together with Bownde, John, of Gelston, yeoman 1
4098018 2059620 2059620 defendant Davye William yeoman 618022 618022 Davye, William, of Gelston, yeoman 0
4098019 2059620 2059620 defendant Bownde John yeoman 618022 618022 together with Bownde, John, of Gelston, yeoman 1
4383850 2159303 2159303 defendant Both alias Bone Edward yeoman 618022 618022 Both alias Bone, Edward, of Gelston, yeoman 0
4955066 2343467 2343467 defendant Proktour Robert husbandman 618022 618022 Proktour, Robert, of Gelston, husbandman 1
4962218 2345602 2345602 defendant Garveys Ralph esq 618022 618022 Garveys, Ralph, of Gelston, esq 0
4976002 2349789 2349789 defendant Bonde Geoffrey yeoman 618022 618022 Bonde, Geoffrey, of Gelston, yeoman 0
4985020 2352451 2352451 defendant Proktour Robert husbandman 618022 618022 Proktour, Robert, of Gelston, husbandman 2
5002347 2357593 2357593 defendant Garveys Ralph esq 618022 618022 Garveys, Ralph, of Gelston, esq 0
5007853 2359187 2359187 defendant Proktour Robert husbandman 618022 618022 Proktour, Robert, of Gelston, husbandman 3
5122764 2393093 2393093 plaintiff Warde Richard clerk 618022 618022 Warde, Richard, of Gelston, clerk 0
5278935 2438951 2438951 plaintiff Bonde Geoffrey   618022 618022 Bonde, Geoffrey, of Gelston, chapman, administrators of 0
5331639 2454545 2454545 defendant Munkton William husbandman 618022 618022 Munkton, William, of Gelston, husbandman 0
5347973 2459507 2459507 plaintiff Bonde Geoffrey (legal representative) 618022 618022 Bonde, Geoffrey, of Gelston, administrator of 0
5549702 2519951 2519951 defendant Deye John laborer 618022 618022 Deye, John, of Gelston, laborer 4
5585328 2530478 2530478 defendant Doye Robert husbandman 618022 618022 Doye, Robert, of Gelston, husbandman 1

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