names

27 rows where place_id = 611197

✎ 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
3687310 1922212 1922212 defendant Rothe Simon husbandman 611197 611197 Rothe, Simon, of Wymbysshe, husbandman 0
3687313 1922212 1922212 defendant Marten Nicholas husbandman 611197 611197 Marten, Nicholas, of Wymbysshe, husbandman 3
3744426 1940159 1940159 defendant Seryche John husbandman 611197 611197 Seryche, John, of Wymbysshe, husbandman 0
3744427 1940159 1940159 defendant Berden Robert laborer 611197 611197 Berden, Robert, of Wymbysshe, laborer 1
3748782 1941554 1941554 defendant Pympille John husbandman 611197 611197 Pympille, John, of Wymbysshe, husbandman 0
3748783 1941554 1941554 defendant Pympille Stephen husbandman 611197 611197 Pympille, Stephen, of Wymbysshe, husbandman 1
3751201 1942300 1942300 defendant Tyrtell Thomas husbandman 611197 611197 Tyrtell, Thomas,of Wymbysshe, husbandman 1
3756288 1943927 1943927 defendant Pympull Stephen husbandman 611197 611197 Pympull, Stephen, of Wymbysshe, husbandman 5
3838301 1969894 1969894 defendant Barker Thomas husbandman 611197 611197 Barker, Thomas, of Wymbysshe, husbandman 0
3848795 1973208 1973208 defendant Serecche William husbandman 611197 611197 Serecche, William, of Wymbysshe, husbandman 0
3848796 1973208 1973208 defendant Seryche John husbandman 611197 611197 Seryche, John, of Wymbysshe, husbandman 1
3848797 1973208 1973208 defendant Cunstable John, senior husbandman 611197 611197 Cunstable, John, senior, of Wymbysshe, husbandman 2
3861599 1977339 1977339 defendant Pypell Stephen husbandman 611197 611197 Pypell, Stephen, of Wymbysshe, husbandman 0
3891164 1987311 1987311 defendant Wylsemer John, junior laborer 611197 611197 Wylsemer, John, junior, of Wymbysshe, laborer 3
3894475 1988359 1988359 defendant Seryche John husbandman 611197 611197 Seryche, John, of Wymbysshe, husbandman 1
3905370 1992064 1992064 defendant Seryche John, senior yeoman 611197 611197 Seryche, John, senior, of Wymbysshe, yeoman 0
3905376 1992067 1992067 defendant Serytche John yeoman 611197 611197 Serytche, John, of Wymbysshe, yeoman 0
3918408 1996485 1996485 defendant Cunstable Robert yeoman 611197 611197 Cunstable, Robert, of Wymbysshe, yeoman 1
4554918 2217468 2217468 defendant Felowe Walter   611197 611197 Felowe, Walter, of Wymbysshe 0
4554920 2217468 2217468 defendant Felowe John   611197 611197 Felowe, John, of Wymbysshe 2
5010298 2359877 2359877 defendant Grygge John, sen husbandman 611197 611197 Grygge, John, sen, of Wymbysshe, husbandman 0
5045518 2370288 2370288 defendant Becrkere John, senior yeoman 611197 611197 Becrkere, John, senior, of Wymbysshe, yeoman 0
5259759 2433177 2433177 defendant Orlage Simon yeoman 611197 611197 Orlage, Simon, of Wymbysshe, yeoman 0
5305334 2446601 2446601 defendant Colwell William yeoman 611197 611197 Colwell, William, of Wymbysshe, yeoman 2
5544753 2518470 2518470 defendant Neweman John husbandman 611197 611197 Neweman, John, of Wymbysshe, husbandman 3
5578878 2528458 2528458 defendant Constable John husbandman 611197 611197 Constable, John, of Wymbysshe, husbandman 0
5607496 2537240 2537240 defendant Wright Thomas husbandman 611197 611197 Wright, Thomas, of Wymbysshe, husbandman 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);