names

38 rows where place_id = 653684

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3929441 2000191 2000191 plaintiff Byrde John   653684 653684 Byrde, John, of Shobdon 0
3985814 2019690 2019690 defendant Pitte Hugh husbandman 653684 653684 Pitte, Hugh, of Shobdon, husbandman 0
3985815 2019690 2019690 defendant Woodhose John husbandman 653684 653684 Woodhose, John, of Shobdon, husbandman 1
4042200 2039691 2039691 defendant Grynsyll or Grynfyll William yeoman 653684 653684 Grynsyll or Grynfyll, William, of Shobdon, yeoman 0
4042202 2039692 2039692 defendant Grynsyll William yeoman 653684 653684 Grynsyll, William, of Shobdon, yeoman 0
4052695 2043396 2043396 defendant Woodhowse John husbandman 653684 653684 Woodhowse, John, of Shobdon, husbandman 1
4052696 2043396 2043396 defendant Perkyn Edward yeoman 653684 653684 Perkyn, Edward, of Shobdon, yeoman 2
4053446 2043608 2043608 defendant Styrry John clerk 653684 653684 Styrry, John, of Shobdon, clerk 0
4089503 2056534 2056534 defendant Orney John yeoman 653684 653684 Orney, John, of Shobdon, yeoman 0
4089504 2056534 2056534 defendant Coccombe John yeoman 653684 653684 Coccombe, John, of Shobdon, yeoman 1
4105594 2062283 2062283 defendant Taylor Humphrey yeoman 653684 653684 Taylor, Humphrey, of Shobdon, yeoman 0
4105596 2062284 2062284 defendant Taylor Humphrey yeoman 653684 653684 Taylor, Humphrey, of Shobdon, yeoman 0
4187972 2091293 2091293 defendant Higgyns John husbandman 653684 653684 Higgyns, John, of Shobdon, husbandman 0
4187973 2091293 2091293 defendant Stirrye John clerk 653684 653684 Stirrye, John, of Shobdon, clerk 1
4187974 2091293 2091293 defendant Higgins Henry husbandman 653684 653684 Higgins, Henry, of Shobdon, husbandman 2
4229149 2105676 2105676 defendant Byrde Walter yeoman 653684 653684 Byrde, Walter, of Shobdon, yeoman 0
4230546 2106178 2106178 defendant Byrde Walter yeoman 653684 653684 Byrde, Walter, of Shobdon, yeoman 0
4230547 2106178 2106178 defendant ap Powell Hugh yeoman 653684 653684 ap Powell, Hugh, of Shobdon, yeoman 1
4245541 2111484 2111484 defendant Davys Hugh yeoman 653684 653684 Davys, Hugh, of Shobdon, yeoman 0
4276279 2121647 2121647 defendant Tayler Thomas yeoman 653684 653684 Tayler, Thomas, of Shobdon, yeoman 0
4279445 2122731 2122731 defendant Dee James yeoman 653684 653684 Dee, James, of Shobdon, yeoman 0
4296363 2128797 2128797 defendant Welshe Hugh gent 653684 653684 (Welshe, Hugh, of Shobdon, gent 3
4296365 2128797 2128797 defendant Garnons James gent 653684 653684 Garnons, James, of Shobdon, gent 5
4298454 2129549 2129549 defendant Taylor Thomas yeoman 653684 653684 Taylor, Thomas, of Shobdon, yeoman 0
4305656 2132114 2132114 defendant Gallete John, junior yeoman 653684 653684 Gallete, John, junior, of Shobdon, yeoman 1
4318573 2136609 2136609 defendant Perkyns Edward husbandman 653684 653684 Perkyns, Edward, of Shobdon, husbandman 0
4331867 2140950 2140950 defendant Thomas Robert yeoman 653684 653684 Thomas, Robert, of Shobdon, yeoman 0
4377643 2157079 2157079 defendant Lewes Thomas yeoman 653684 653684 Lewes, Thomas, of Shobdon, yeoman 1
4390184 2161339 2161339 defendant Taylor Thomas yeoman 653684 653684 Taylor, Thomas, of Shobdon, yeoman 1
4402885 2165550 2165550 defendant Marten Peter yeoman 653684 653684 Marten, Peter, of Shobdon, yeoman 0
4403866 2165863 2165863 defendant Taylor Thomas yeoman 653684 653684 Taylor, Thomas, of Shobdon, yeoman 0
4404441 2166052 2166052 defendant Morris William yeoman 653684 653684 Morris, William, of Shobdon, yeoman 1
5312670 2448827 2448827 defendant Bole Agnes widow 653684 653684 Bole, Agnes, of Shobdon, widow 1
5312671 2448827 2448827 defendant Bole Richard husbandman 653684 653684 Bole, Richard, of Shobdon, husbandman 2
5312672 2448827 2448827 defendant Bola Hugh tailor 653684 653684 Bola, Hugh, of Shobdon, tailor 3
5415011 2479422 2479422 defendant Proude John chapman 653684 653684 Proude, John, of Shobdon, chapman 0
5599538 2534749 2534749 defendant ap Cadogant John yeoman 653684 653684 ap Cadogant, John, of Shobdon, yeoman 0
5599541 2534750 2534750 defendant ap Jenin Maurice yeoman 653684 653684 ap Jenin, Maurice, of Shobdon, 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);