names

32 rows where place_id = 620148

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3733988 1936877 1936877 defendant Burton Richard cordwainer 620148 620148 Burton, Richard, of Skypton in Craven, cordwainer 3
3733989 1936877 1936877 defendant Wederherd Mathew cordwainer 620148 620148 Wederherd, Mathew, of Skypton in Craven, cordwainer 4
3733990 1936877 1936877 defendant Shyres Brian blacksmith 620148 620148 Shyres, Brian, of Skypton in Craven, blacksmith 5
3926280 1999113 1999113 defendant Evanson John chapman 620148 620148 Evanson, John, of Skypton in Craven, chapman 0
4074553 2051201 2051201 defendant Tomlynson George chapman 620148 620148 Tomlynson, George, of Skypton in Craven, chapman 2
4147550 2077285 2077285 defendant Venham John   620148 620148 Venham, John, of Skypton in Craven, physician 0
4252063 2113678 2113678 defendant Barwis George yeoman 620148 620148 Barwis, George, of Skypton in Craven, yeoman 3
4364412 2152330 2152330 defendant Moorehowse John husbandman 620148 620148 Moorehowse, John, of Skypton in Craven, husbandman 0
4395206 2162985 2162985 defendant Gawthorpe Thomas yeoman 620148 620148 Gawthorpe, Thomas, of Skypton in Craven, yeoman 0
4395233 2162989 2162989 defendant Cundray Thomas shoemaker 620148 620148 Cundray, Thomas, of Skypton in Craven, shoemaker 1
4461360 2188635 2188635 defendant Chaundeler John   620148 620148 Chaundeler, John, of Skypton in Craven 0
4670774 2256538 2256538 defendant Morys Wilalim chapman 620148 620148 Morys, Wilalim, of Skypton in Craven, chapman 0
4754521 2281795 2281795 defendant Lambe Adam gent 620148 620148 Lambe, Adam, of Skypton in Craven, gent 0
4890495 2323791 2323791 defendant de Garthe William esq 620148 620148 de Garthe, William, of Skypton in Craven, esq 1
5037666 2367889 2367889 defendant Stanrop or Staurop Richard yeoman 620148 620148 Stanrop or Staurop, Richard, of Skypton in Craven, yeoman 0
5214714 2420031 2420031 defendant Preston Henry yeoman 620148 620148 Preston, Henry, of Skypton in Craven, yeoman 5
5214715 2420031 2420031 defendant Penelton or Pevelton Richard yeoman 620148 620148 Penelton or Pevelton, Richard, of Skypton in Craven, yeoman 6
5214716 2420031 2420031 defendant Brerehay John yeoman 620148 620148 Brerehay, John, of Skypton in Craven, yeoman 7
5214718 2420031 2420031 defendant Kechyn William yeoman 620148 620148 Kechyn, William, of Skypton in Craven, yeoman 9
5227106 2423580 2423580 defendant Jenkynson Richard yeoman 620148 620148 together with Jenkynson, Richard, of Skypton in Craven, yeoman 2
5227111 2423580 2423580 defendant Kechyn Thomas yeoman 620148 620148 Kechyn, Thomas, of Skypton in Craven, yeoman 7
5227112 2423580 2423580 defendant Kechyn Robert yeoman 620148 620148 Kechyn, Robert, of Skypton in Craven, yeoman 8
5227113 2423580 2423580 defendant Jenkynson Thomas yeoman 620148 620148 Jenkynson, Thomas, of Skypton in Craven, yeoman 9
5227114 2423580 2423580 defendant Taillour Henry yeoman 620148 620148 Taillour, Henry, of Skypton in Craven, yeoman 10
5255361 2431792 2431792 defendant Dacre George gent 620148 620148 Dacre, George, of Skypton in Craven, gent 2
5379421 2469154 2469154 defendant Herryson John yeoman 620148 620148 Herryson, John, of Skypton in Craven, yeoman 0
5379424 2469155 2469155 defendant Herryson John yeoman 620148 620148 Herryson, John, of Skypton in Craven, yeoman 0
5497474 2504186 2504186 defendant Wedderherd James husbandman 620148 620148 Wedderherd, James, of Skypton in Craven, husbandman 0
5497475 2504186 2504186 defendant Wedderherd Thomas husbandman 620148 620148 Wedderherd, Thomas, of Skypton in Craven, husbandman 1
5497476 2504186 2504186 defendant Luge John husbandman 620148 620148 Luge, John, of Skypton in Craven, husbandman 2
5538935 2516668 2516668 defendant Clyfford Henry   620148 620148 Clyfford, Henry, of Skypton in Craven, knight, Lord Clyfford 0
5616615 2548999 2548999 defendant Lyghtfote William   620148 620148 Lyghtfote, William, of Skypton in Craven 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);