names

53 rows where place_id = 588730

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595400 1866193 1866193 defendant Hudson Robert tailor 588730 588730 Hudson, Robert, of Kyghley, tailor 0
3754452 1943350 1943350 defendant Taylyour Thomas innholder 588730 588730 Taylyour, Thomas, of Kyghley, innholder 0
3886965 1985904 1985904 defendant Brygg Richard clothman 588730 588730 Brygg, Richard, of Kyghley, clothman 1
3907540 1992818 1992818 defendant Sugdon William husbandman 588730 588730 Sugdon, William, of Kyghley, husbandman 0
3935279 2002110 2002110 defendant Holme Christopher yeoman 588730 588730 (Holme, Christopher, of Kyghley, yeoman 1
4069051 2049222 2049222 defendant Rooper Christopher yeoman 588730 588730 Rooper, Christopher, of Kyghley, yeoman 0
4069052 2049222 2049222 defendant Rooper John husbandman 588730 588730 Rooper, John, of Kyghley, husbandman 1
4092373 2057574 2057574 defendant Wyddopp Adam husbandman 588730 588730 Wyddopp, Adam, of Kyghley, husbandman 0
4092375 2057575 2057575 defendant Wyddoppe Adam clothier 588730 588730 Wyddoppe, Adam, of Kyghley, clothier 0
4092376 2057575 2057575 defendant Wyddoppe Thomas clothier 588730 588730 Wyddoppe, Thomas, of Kyghley, clothier 1
4098695 2059866 2059866 defendant Sugden Isabel spinster 588730 588730 Sugden, Isabel, of Kyghley, spinster 0
4138476 2074127 2074127 defendant Bothomley Christopher clothier 588730 588730 Bothomley, Christopher, of Kyghley, clothier 0
4322720 2138014 2138014 defendant Bothomley Thomas yeoman 588730 588730 Bothomley, Thomas, of Kyghley, yeoman 0
4384192 2159405 2159405 defendant Bothomley Thomas yeoman 588730 588730 Bothomley, Thomas, of Kyghley, yeoman 0
4384194 2159406 2159406 defendant Bothomley Thomas yeoman 588730 588730 Bothomley, Thomas, of Kyghley, yeoman 0
4765960 2285345 2285345 defendant Wilson Robert yeoman 588730 588730 Wilson, Robert, of Kyghley, yeoman 0
4878711 2320282 2320282 defendant de Hall William husbandman 588730 588730 de Hall, William, of Kyghley, husbandman 0
4969311 2347781 2347781 defendant Taillour John husbandman 588730 588730 Taillour, John, of Kyghley, husbandman 2
4982258 2351610 2351610 defendant Sugden James husbandman 588730 588730 Sugden, James, of Kyghley, husbandman 6
5070659 2377723 2377723 defendant Hudson John husbandman 588730 588730 Hudson, John, of Kyghley, husbandman 0
5070661 2377724 2377724 defendant Hudson John husbandman 588730 588730 Hudson, John, of Kyghley, husbandman 0
5088393 2382982 2382982 defendant Raynford Elias yeoman 588730 588730 Raynford, Elias, of Kyghley, yeoman 0
5105856 2388155 2388155 defendant Underwode John shoemaker 588730 588730 Underwode, John, of Kyghley, shoemaker 0
5105857 2388155 2388155 defendant Rycroft John fuller 588730 588730 Rycroft, John, of Kyghley, fuller 1
5105858 2388155 2388155 defendant Sharp Henry husbandman 588730 588730 Sharp, Henry, of Kyghley, husbandman 2
5105859 2388155 2388155 defendant Hertley William weaver 588730 588730 Hertley, William, of Kyghley, weaver 3
5105860 2388155 2388155 defendant Sugden Robert tailor 588730 588730 Sugden, Robert, of Kyghley, tailor 4
5105861 2388155 2388155 defendant Shakylton Geoffrey yeoman 588730 588730 Shakylton, Geoffrey, of Kyghley, yeoman 5
5105862 2388155 2388155 defendant Raulyn John, junior yeoman 588730 588730 Raulyn, John, junior, of Kyghley, yeoman 6
5105863 2388155 2388155 defendant Raulyn John, senior yeoman 588730 588730 Raulyn, John, senior, of Kyghley, yeoman 7
5105866 2388156 2388156 defendant Underwode John shoemaker 588730 588730 Underwode, John, of Kyghley, shoemaker 0
5105867 2388156 2388156 defendant Rycroft John fuller 588730 588730 Rycroft, John, of Kyghley, fuller 1
5105868 2388156 2388156 defendant Sharp Henry husbandman 588730 588730 Sharp, Henry, of Kyghley, husbandman 2
5105869 2388156 2388156 defendant Hertley William weaver 588730 588730 Hertley, William, of Kyghley, weaver 3
5105870 2388156 2388156 defendant Sugden Robert tailor 588730 588730 Sugden, Robert, of Kyghley, tailor 4
5105871 2388156 2388156 defendant Shakylton Geoffrey yeoman 588730 588730 Shakylton, Geoffrey, of Kyghley, yeoman 5
5105872 2388156 2388156 defendant Raulyn John, junior yeoman 588730 588730 Raulyn, John, junior, of Kyghley, yeoman 6
5105873 2388156 2388156 defendant Raulyn John, senior yeoman 588730 588730 Raulyn, John, senior, of Kyghley, yeoman 7
5225457 2423121 2423121 defendant Shawe Richard yeoman 588730 588730 Shawe, Richard, of Kyghley, yeoman 4
5305419 2446627 2446627 defendant Shagh Richard yeoman 588730 588730 Shagh, Richard, of Kyghley, yeoman 5
5305426 2446628 2446628 defendant Shagh Richard yeoman 588730 588730 Shagh, Richard, of Kyghley, yeoman 3
5355793 2461887 2461887 defendant Bryg John yeoman 588730 588730 Bryg, John, of Kyghley, yeoman 0
5355794 2461887 2461887 defendant Shawe William smith 588730 588730 Shawe, William, of Kyghley, smith 1
5355795 2461887 2461887 defendant Kychyn Robert husbandman 588730 588730 Kychyn, Robert, of Kyghley, husbandman 2
5355796 2461887 2461887 defendant Underwod John miller 588730 588730 Underwod, John, of Kyghley, miller 3
5356128 2461993 2461993 defendant Hardere John smith 588730 588730 Hardere, John, of Kyghley, smith 4
5402346 2475744 2475744 defendant Vudney John yeoman 588730 588730 Vudney, John, of Kyghley, yeoman 0
5402348 2475744 2475744 defendant Dynnys John husbandman 588730 588730 Dynnys, John, of Kyghley, husbandman 2
5402447 2475770 2475770 defendant Underwode John, senior yeoman 588730 588730 Underwode, John, senior, of Kyghley, yeoman 0
5402448 2475770 2475770 defendant Brig John yeoman 588730 588730 Brig, John, of Kyghley, yeoman 1
5402451 2475771 2475771 defendant Underwode John, senior yeoman 588730 588730 Underwode, John, senior, of Kyghley, yeoman 0
5448199 2489355 2489355 defendant Shay William yeoman 588730 588730 Shay, William, of Kyghley, yeoman 1
5448205 2489356 2489356 defendant Shay William yeoman 588730 588730 Shay, William, of Kyghley, yeoman 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);