names

25 rows where place_id = 595614

✎ 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
3621162 1874164 1874164 defendant Fyncheley John yeoman 595614 595614 Fyncheley, John, of Penkeriche, yeoman 5
3673198 1917630 1917630 defendant Alen Roger   595614 595614 Alen, Roger, of Penkeriche 1
3673206 1917632 1917632 defendant Tayller William yeoman 595614 595614 Tayller, William, of Penkeriche, yeoman 0
3682795 1920723 1920723 defendant Kyng Alexander husbandman 595614 595614 Kyng, Alexander, of Penkeriche, husbandman 0
3682797 1920724 1920724 defendant Kyng Alexander husbandman 595614 595614 Kyng, Alexander, of Penkeriche, husbandman 0
3692966 1924000 1924000 defendant Aleyn Roger yeoman 595614 595614 Aleyn, Roger, of Penkeriche, yeoman 0
3720469 1932685 1932685 defendant Preston Hugh husbandman 595614 595614 Preston, Hugh, of Penkeriche, husbandman 0
3822424 1964911 1964911 defendant Corbet Robert   595614 595614 Corbet, Robert, of Penkeriche, tile maker 2
3823055 1965120 1965120 defendant Fyncheley John yeoman 595614 595614 Fyncheley, John, of Penkeriche, yeoman 0
3875255 1981963 1981963 defendant Emson Robert tailor 595614 595614 Emson, Robert,of Penkeriche, tailor 0
3875258 1981963 1981963 defendant Venables John butcher 595614 595614 Venables, John, of Penkeriche, butcher 3
3879192 1983293 1983293 defendant Venabils John butcher 595614 595614 Venabils, John, of Penkeriche, butcher 3
3898586 1989734 1989734 defendant Alen Roger yeoman 595614 595614 Alen, Roger,of Penkeriche, yeoman 3
3911464 1994151 1994151 defendant Browne Stephen shoemaker 595614 595614 Browne, Stephen, of Penkeriche, shoemaker 0
4105725 2062335 2062335 defendant Smyth Joan widow 595614 595614 Smyth, Joan, of Penkeriche, widow 2
4131105 2071443 2071443 defendant Hare Thomas yeoman 595614 595614 Hare, Thomas, of Penkeriche, yeoman 0
4964490 2346285 2346285 defendant Eltam William husbandman 595614 595614 Eltam, William, of Penkeriche, husbandman 0
4964491 2346285 2346285 defendant Eltam John husbandman 595614 595614 Eltam, John, of Penkeriche, husbandman 1
4964492 2346285 2346285 defendant Syrell John husbandman 595614 595614 Syrell, John, of Penkeriche, husbandman 2
4964493 2346285 2346285 defendant Syrell Walter husbandman 595614 595614 Syrell, Walter, of Penkeriche, husbandman 3
5093572 2384519 2384519 defendant Yens William yeoman 595614 595614 Yens, William, of Penkeriche, yeoman 1
5361225 2463537 2463537 defendant Sparry John, junior yeoman 595614 595614 Sparry, John, junior, of Penkeriche, yeoman 0
5361226 2463537 2463537 defendant Umbursley Richard yeoman 595614 595614 Umbursley, Richard, of Penkeriche, yeoman 1
5400302 2475161 2475161 defendant Kyng William yeoman 595614 595614 Kyng, William, of Penkeriche, yeoman 1
5509832 2507913 2507913 defendant Aleyn John miller 595614 595614 Aleyn, John, of Penkeriche, miller 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);