names

51 rows where place_id = 669443

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3993242 2022326 2022326 defendant Bodnam John nailer or yeoman 669443 669443 Bodnam, John, of Rowley Regis, nailer or yeoman 0
4027096 2034336 2034336 defendant Compen or Compane William yeoman 669443 669443 Compen or Compane, William, of Rowley Regis, yeoman 0
4027098 2034337 2034337 defendant Compen or Compayne William nailer or yeoman 669443 669443 Compen or Compayne, William, of Rowley Regis, nailer or yeoman 0
4027100 2034338 2034338 defendant Compen or Compayne William nailer or yeoman 669443 669443 Compen or Compayne, William, of Rowley Regis, nailer or yeoman 0
4037162 2037952 2037952 defendant Sheldon John nailer 669443 669443 Sheldon, John, of Rowley Regis, nailer 0
4052850 2043455 2043455 defendant Hypkys Lawrence nailer 669443 669443 Hypkys, Lawrence, of Rowley Regis, nailer 0
4052851 2043455 2043455 defendant Symons John nailer 669443 669443 Symons, John, of Rowley Regis, nailer 1
4052852 2043455 2043455 defendant Sheldon William nailer 669443 669443 Sheldon, William, of Rowley Regis, nailer 2
4052853 2043455 2043455 defendant Sheldon Thomas nailer 669443 669443 Sheldon, Thomas, of Rowley Regis, nailer 3
4064184 2047464 2047464 defendant Lubridge John nailer 669443 669443 Lubridge, John, of Rowley Regis, nailer 1
4067701 2048760 2048760 defendant Bodnam William nailer 669443 669443 Bodnam, William, of Rowley Regis, nailer 0
4067703 2048760 2048760 defendant Bateson Richard laborer 669443 669443 Bateson, Richard, of Rowley Regis, laborer 2
4094737 2058451 2058451 defendant Alchurch John yeoman 669443 669443 Alchurch, John, of Rowley Regis, yeoman 0
4094739 2058451 2058451 defendant Ley Roger yeoman or stringer 669443 669443 Ley, Roger, of Rowley Regis, yeoman or stringer 2
4130203 2071111 2071111 defendant Aynesworthe William nailer 669443 669443 Aynesworthe, William, of Rowley Regis, nailer 1
4142274 2075475 2075475 defendant Walker Thomas husbandman 669443 669443 Walker, Thomas, of Rowley Regis, husbandman 0
4142275 2075475 2075475 defendant Asteley John nailer 669443 669443 Asteley, John, of Rowley Regis, nailer 1
4142279 2075476 2075476 defendant Wood Walter gent 669443 669443 Wood, Walter, of Rowley Regis, gent 0
4153609 2079355 2079355 defendant Parkes John nailer 669443 669443 Parkes, John, of Rowley Regis, nailer 0
4153629 2079362 2079362 defendant Aynesworthe William nailer 669443 669443 Aynesworthe, William, of Rowley Regis, nailer 1
4158110 2080904 2080904 defendant Staresmore Sabius gent 669443 669443 Staresmore, Sabius, of Rowley Regis, gent 0
4167137 2084012 2084012 defendant Wood Walter gent 669443 669443 Wood, Walter, of Rowley Regis, gent 0
4170735 2085257 2085257 defendant Jones alias Martyn Richard yeoman 669443 669443 Jones alias Martyn, Richard, of Rowley Regis, yeoman 0
4173600 2086220 2086220 defendant Staresmore Sabin gent 669443 669443 Staresmore, Sabin, of Rowley Regis, gent 1
4178574 2087985 2087985 defendant Perke John nailer 669443 669443 Perke, John, of Rowley Regis, nailer 1
4187131 2090991 2090991 defendant Wood Walter gent 669443 669443 Wood, Walter, of Rowley Regis, gent 0
4190408 2092184 2092184 defendant Humfrey Peter gent 669443 669443 Humfrey, Peter, of Rowley Regis, or of Worcester, gent 0
4204115 2096992 2096992 defendant Ofchurch Roger nailer 669443 669443 Ofchurch, Roger, of Rowley Regis, nailer 0
4207647 2098233 2098233 defendant Cocke Thomas husbandman 669443 669443 Cocke, Thomas, of Rowley Regis, or of Tardebyge, Warks, husbandman 0
4210749 2099316 2099316 defendant Wood Walter gent 669443 669443 Wood, Walter, of Rowley Regis, gent 0
4216224 2101164 2101164 defendant Aynsworthe John husbandman 669443 669443 Aynsworthe, John, of Rowley Regis, husbandman 1
4222301 2103290 2103290 defendant Peppole or Pepwall Thomas nailer 669443 669443 Peppole or Pepwall, Thomas, of Rowley Regis, nailer 3
4239206 2109337 2109337 defendant Russell Thomas yeoman 669443 669443 Russell, Thomas, of Rowley Regis, yeoman 0
4256106 2115022 2115022 defendant Grove William, junior   669443 669443 Grove, William, junior, of Rowley Regis, yeoman, his son 1
4268445 2119048 2119048 defendant Grove William, junior   669443 669443 Grove, William, junior, of Rowley Regis, yeoman, his son 1
4272391 2120340 2120340 defendant Russell Thomas yeoman 669443 669443 Russell, Thomas, of Rowley Regis, yeoman 0
4279416 2122721 2122721 defendant Pepwall Thomas nailer 669443 669443 Pepwall, Thomas, of Rowley Regis, nailer 0
4318254 2136493 2136493 defendant Willett Thomas nailer 669443 669443 Willett, Thomas, of Rowley Regis, yeoman, nailer 0
4318255 2136493 2136493 defendant Derby William yeoman 669443 669443 Derby, William, of Rowley Regis, yeoman 1
4321610 2137647 2137647 defendant Pepwell Thomas nailer 669443 669443 Pepwell, Thomas, of Rowley Regis, nailer 0
4321613 2137647 2137647 defendant Hawk Humphrey nailer 669443 669443 Hawk, Humphrey, of Rowley Regis, nailer 3
4341143 2144175 2144175 defendant Grove Philip yeoman 669443 669443 Grove, Philip, of Rowley Regis, yeoman 0
4341144 2144175 2144175 defendant Pepwall Thomas nailer 669443 669443 Pepwall, Thomas, of Rowley Regis, nailer 1
4350518 2147444 2147444 defendant Alchurche Roger husbandman 669443 669443 Alchurche, Roger, of Rowley Regis, husbandman 0
4350519 2147444 2147444 defendant Bridgwater John nailer 669443 669443 Bridgwater, John, of Rowley Regis, nailer 1
4350677 2147488 2147488 defendant Alchurche Roger husbandman 669443 669443 Alchurche, Roger, of Rowley Regis, husbandman 0
4350678 2147488 2147488 defendant Bridgwater John nailer 669443 669443 Bridgwater, John, of Rowley Regis, nailer 1
4357115 2149715 2149715 defendant Gorton Thomas yeoman 669443 669443 Gorton, Thomas, of Rowley Regis, yeoman 0
4388568 2160817 2160817 defendant Smyth William nailer 669443 669443 Smyth, William, of Rowley Regis, nailer 1
4409470 2167764 2167764 defendant Pepwall Thomas nailer 669443 669443 Pepwall, Thomas, of Rowley Regis, nailer 0
4409473 2167764 2167764 defendant Hawkes Humphrey nailer 669443 669443 Hawkes, Humphrey, of Rowley Regis, nailer 3

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);