names

39 rows where place_id = 664374

✎ 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
3972620 2014998 2014998 defendant Watman Henry shoemaker 664374 664374 Watman, Henry, of Hallifax, shoemaker 3
3985902 2019723 2019723 plaintiff Waterhouse Robert gent 664374 664374 Waterhouse, Robert, of Hallifax, gent 0
3985903 2019723 2019723 defendant Ferrour Brian yeoman 664374 664374 Ferrour, Brian, of Hallifax, yeoman 0
3985905 2019723 2019723 defendant Ferrour Ursula widow 664374 664374 Ferrour, Ursula, of Hallifax, widow 2
3991531 2021731 2021731 plaintiff Brige Richard clothier 664374 664374 Brige, Richard, of Hallifax, clothier 0
4027715 2034560 2034560 defendant Nicholas Gilbert clothier 664374 664374 Nicholas, Gilbert, of Hallifax, clothier 3
4040512 2039099 2039099 plaintiff Milner Edward clothier 664374 664374 Milner, Edward, of Hallifax, clothier 0
4040513 2039099 2039099 defendant Lyster John chapman 664374 664374 Lyster, John, of Hallifax, chapman 0
4063438 2047211 2047211 plaintiff Gibson Richard clothier 664374 664374 Gibson, Richard, of Hallifax, clothier 0
4106050 2062455 2062455 plaintiff Otes Walter clothier 664374 664374 Otes, Walter, of Hallifax, clothier 0
4114282 2065392 2065392 defendant Thorpe Robert tailor 664374 664374 Thorpe, Robert, of Hallifax, tailor 0
4117287 2066486 2066486 defendant Brodley Thomas yeoman 664374 664374 Brodley, Thomas, of Hallifax, yeoman 0
4117288 2066486 2066486 defendant Otes Mathew yeoman 664374 664374 Otes, Mathew, of Hallifax, yeoman 1
4128288 2070401 2070401 defendant Hayley John yeoman 664374 664374 Hayley, John, of Hallifax, yeoman 0
4133400 2072270 2072270 defendant Hyll Edward dyer 664374 664374 Hyll, Edward, of Hallifax, dyer 0
4144982 2076404 2076404 defendant Rydynge Humphrey yeoman 664374 664374 Rydynge, Humphrey, of Hallifax, yeoman 2
4144988 2076405 2076405 defendant Waterhouse George gent 664374 664374 Waterhouse, George, of Hallifax, gent 2
4157309 2080622 2080622 defendant Hill Edward gent 664374 664374 Hill, Edward, of Hallifax, dyer, gent 0
4158037 2080881 2080881 defendant Beckwithe Leonard merchant 664374 664374 Beckwithe, Leonard, of Hallifax, merchant 1
4160654 2081800 2081800 defendant Heaton Robert clothier 664374 664374 Heaton, Robert, of Hallifax, clothier 2
4160655 2081800 2081800 defendant Feyldyn Edward clothier 664374 664374 Feyldyn, Edward, of Hallifax, clothier 3
4165852 2083554 2083554 defendant Hill Edward, senior dyer 664374 664374 Hill, Edward, senior, of Hallifax, dyer 0
4171968 2085657 2085657 defendant Gremesfeilde John clothier 664374 664374 Gremesfeilde, John, of Hallifax, clothier 0
4176465 2087249 2087249 defendant Turner Ellen spinster 664374 664374 Turner, Ellen, of Hallifax, spinster 1
4184518 2090094 2090094 defendant Bayrstowe Richard butcher 664374 664374 Bayrstowe, Richard, of Hallifax, butcher 0
4216730 2101344 2101344 defendant Crampton Alexander yeoman 664374 664374 Crampton, Alexander, of Hallifax, yeoman 1
4216733 2101345 2101345 defendant Wayvell or Wyvell William yeoman 664374 664374 Wayvell or Wyvell, William, of Hallifax, yeoman 0
4238185 2108965 2108965 defendant Brigge or Brigges Henry (legal representative) 664374 664374 Brigge or Brigges, Henry, of Hallifax, clothier, executor of 0
4269564 2119409 2119409 defendant Fethergyll Thomas mercer 664374 664374 Fethergyll, Thomas, of Hallifax, mercer 0
4313556 2134850 2134850 defendant Brigge Henry (legal representative) 664374 664374 Brigge, Henry, of Hallifax, clothier, executor of 0
4313557 2134850 2134850 defendant Brigges or Brigge John clothier 664374 664374 Brigges or Brigge, John, of Hallifax, clothier 1
4323405 2138245 2138245 defendant Grenefeild John yeoman 664374 664374 Grenefeild, John, of Hallifax, yeoman 0
4355082 2148994 2148994 defendant Hardie Peter yeoman 664374 664374 Hardie, Peter, of Hallifax, yeoman 1
4384595 2159536 2159536 defendant Barker Gilbert yeoman 664374 664374 Barker, Gilbert, of Hallifax, yeoman 1
4384596 2159536 2159536 defendant Ackroyde Edward yeoman 664374 664374 Ackroyde, Edward, of Hallifax, yeoman 2
4384597 2159536 2159536 defendant Noble John yeoman 664374 664374 Noble, John, of Hallifax, yeoman 3
4392243 2162031 2162031 defendant Chambers Jane widow 664374 664374 Chambers, Jane, of Hallifax, widow 0
4394340 2162704 2162704 defendant Warde Thomas mercer 664374 664374 (Warde, Thomas, of Hallifax, mercer 1
4396327 2163345 2163345 defendant Stafford George   664374 664374 Stafford, George, of Hallifax yeoman 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);