names

60 rows where place_id = 586074

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587860 1863851 1863851 defendant Sutcliff John yeoman 586074 586074 Sutcliff, John, of Heptonstall, yeoman 1
3587863 1863852 1863852 defendant Sutclyff John yeoman 586074 586074 Sutclyff, John,of Heptonstall, yeoman 1
3587866 1863853 1863853 defendant Sutclyf John yeoman 586074 586074 Sutclyf, John, of Heptonstall, yeoman 1
3597718 1866908 1866908 defendant Bentley Lawrence mercer 586074 586074 Bentley, Lawrence, of Heptonstall, mercer 0
3597719 1866908 1866908 defendant Bentley William sherman 586074 586074 Bentley, William, of Heptonstall, sherman 1
3597720 1866908 1866908 defendant Bentley Robert sherman 586074 586074 Bentley, Robert, of Heptonstall, sherman 2
3597721 1866908 1866908 defendant Marcroft Thomas butcher 586074 586074 Marcroft, Thomas, of Heptonstall, butcher 3
3597722 1866908 1866908 defendant Crosley Thomas laborer 586074 586074 Crosley, Thomas, of Heptonstall, laborer 4
3597723 1866908 1866908 defendant Gybson John yeoman 586074 586074 Gybson, John, of Heptonstall, yeoman 5
3603769 1868849 1868849 defendant Sutclyffe John yeoman 586074 586074 Sutclyffe, John, of Heptonstall, yeoman 1
3623925 1875012 1875012 defendant Stanfeld Robert laborer 586074 586074 Stanfeld, Robert, of Heptonstall, laborer 0
3750783 1942169 1942169 defendant Crabtre William yeoman 586074 586074 Crabtre, William, of Heptonstall, yeoman 2
3778329 1950935 1950935 defendant Sutclyff Robert clothier 586074 586074 Sutclyff, Robert, of Heptonstall, clothier 0
3995570 2023160 2023160 defendant Staveley John clothworker 586074 586074 Staveley, John, of Heptonstall, clothworker 0
3995571 2023160 2023160 defendant Staveley James clothworker 586074 586074 Staveley, James, of Heptonstall, clothworker 1
3995572 2023160 2023160 defendant Thomas John tailor 586074 586074 Thomas, John, of Heptonstall, tailor 2
4032323 2036232 2036232 defendant Kyllyngbecke Robert yeoman 586074 586074 Kyllyngbecke, Robert, of Heptonstall, yeoman 0
4055339 2044309 2044309 plaintiff Bentley Michael mercer 586074 586074 Bentley, Michael, of Heptonstall, mercer 0
4114283 2065392 2065392 defendant Ingame Lawrence laborer 586074 586074 Ingame, Lawrence, of Heptonstall, laborer 1
4114284 2065392 2065392 defendant Sowtell Richard butcher 586074 586074 Sowtell, Richard, of Heptonstall, butcher 2
4166234 2083688 2083688 defendant Mytchell Edward clerk 586074 586074 Mytchell, Edward, of Heptonstall, clerk 1
4667858 2255649 2255649 defendant Horneclyff William yeoman 586074 586074 Horneclyff, William, of Heptonstall, yeoman 3
4667861 2255649 2255649 defendant Tomas Thomas yeoman 586074 586074 Tomas, Thomas, of Heptonstall, yeoman 6
4685846 2261164 2261164 defendant del Brigg John walker 586074 586074 del Brigg, John, of Heptonstall, walker 1
4977846 2350333 2350333 defendant Crosseley John yeoman 586074 586074 Crosseley, John, of Heptonstall, yeoman 0
4977847 2350333 2350333 defendant Crosseley Geoffrey yeoman 586074 586074 Crosseley, Geoffrey, of Heptonstall, yeoman 1
4977848 2350333 2350333 defendant Crosseley Thomas yeoman 586074 586074 Crosseley, Thomas, of Heptonstall, yeoman 2
4977849 2350333 2350333 defendant Crosseley Peter yeoman 586074 586074 Crosseley, Peter, of Heptonstall, yeoman 3
4977851 2350334 2350334 defendant Stansfeld Peter gent 586074 586074 Stansfeld, Peter, of Heptonstall, gent 0
4977852 2350334 2350334 defendant Alotson William husbandman 586074 586074 Alotson, William, of Heptonstall, husbandman 1
4977853 2350334 2350334 defendant Hoffall John husbandman 586074 586074 Hoffall, John, of Heptonstall, husbandman 2
4977854 2350335 2350335 plaintiff Radclyff Thomas   586074 586074 Radclyff, Thomas, of Heptonstall 0
5021576 2363209 2363209 defendant Aykrode Henry yeoman 586074 586074 Aykrode, Henry, of Heptonstall, yeoman 1
5031190 2366002 2366002 defendant de Robertsschag Thomas yeoman 586074 586074 de Robertsschag, Thomas, of Heptonstall, yeoman 0
5031191 2366002 2366002 defendant de Robertsschag Richard, senior husbandman 586074 586074 de Robertsschag, Richard, senior, of Heptonstall, husbandman 1
5031193 2366002 2366002 defendant de Robertsschag William husbandman 586074 586074 de Robertsschag, William, of Heptonstall, husbandman 3
5031194 2366002 2366002 defendant de Robertsschag Robert, junior husbandman 586074 586074 de Robertsschag, Robert, junior, of Heptonstall, husbandman 4
5031210 2366003 2366003 defendant Robertshagh Richard husbandman 586074 586074 Robertshagh, Richard, of Heptonstall, husbandman 14
5031211 2366003 2366003 defendant Richard son of Robertshagh Richard husbandman 586074 586074 Richard son of Robertshagh, Richard, of Heptonstall, husbandman 15
5031212 2366003 2366003 defendant Thomas son of Robertshagh Richard yeoman 586074 586074 Thomas son of Robertshagh, Richard, of Heptonstall, yeoman 16
5031239 2366004 2366004 defendant Robertshagh Richard husbandman 586074 586074 Robertshagh, Richard, of Heptonstall, husbandman 13
5031240 2366004 2366004 defendant Richard son of Robertshagh Richard husbandman 586074 586074 Richard son of Robertshagh, Richard, of Heptonstall, husbandman 14
5031269 2366005 2366005 defendant Robertshagh Richard husbandman 586074 586074 Robertshagh, Richard, of Heptonstall, husbandman 13
5031270 2366005 2366005 defendant Richard son of Robertshagh Richard husbandman 586074 586074 Richard son of Robertshagh, Richard, of Heptonstall, husbandman 14
5034162 2366855 2366855 defendant Machon Emma widow 586074 586074 Machon, Emma, of Heptonstall, widow 7
5034163 2366855 2366855 defendant Machon James laborer 586074 586074 Machon, James, of Heptonstall, laborer 8
5082843 2381374 2381374 defendant Brigge Richard walker 586074 586074 Brigge, Richard, of Heptonstall, son of Brygge, William, walker 0
5141637 2398665 2398665 plaintiff Wadesworth William   586074 586074 Wadesworth, William, of Heptonstall 0
5141638 2398665 2398665 plaintiff Aykeroyde John   586074 586074 Aykeroyde, John, of Heptonstall 1
5149677 2401035 2401035 defendant Horsall John yeoman 586074 586074 Horsall, John, of Heptonstall, yeoman 0
5162724 2404819 2404819 plaintiff Wadesworth William   586074 586074 Wadesworth, William, of Heptonstall 0
5162725 2404819 2404819 plaintiff Aykerode John   586074 586074 Aykerode, John, of Heptonstall 1
5168533 2406512 2406512 defendant Horssall John yeoman 586074 586074 Horssall, John, of Heptonstall, yeoman 0
5176637 2408851 2408851 plaintiff Waddesworth William   586074 586074 Waddesworth, William, of Heptonstall 0
5176638 2408851 2408851 plaintiff Aykerode John   586074 586074 Aykerode, John, of Heptonstall 1
5416918 2479975 2479975 defendant Sampfeld James gent 586074 586074 Sampfeld, James, of Heptonstall, gent 1
5436862 2485955 2485955 defendant Brig Richard yeoman 586074 586074 Brig, Richard, of Heptonstall, yeoman 0
5487080 2501032 2501032 defendant Bentley Lawrence yeoman 586074 586074 Bentley, Lawrence, of Heptonstall, yeoman 3
5578185 2528248 2528248 defendant Sutcliff Robert yeoman 586074 586074 Sutcliff, Robert, of Heptonstall, yeoman 0
5592703 2532710 2532710 defendant Ferrowre Henry yeoman 586074 586074 Ferrowre, Henry, of Heptonstall, 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);