names

47 rows where place_id = 586680

✎ 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
3589357 1864312 1864312 defendant Wright John cordwainer 586680 586680 Wright, John, of Lowth, cordwainer 0
3633861 1905401 1905401 defendant Lincoln William mercer 586680 586680 Lincoln, William, of Lowth, mercer 0
3682273 1920554 1920554 plaintiff Beverley Richard mercer 586680 586680 Beverley, Richard, of Lowth, mercer 1
3778507 1950994 1950994 defendant Brampton Robert shoemaker 586680 586680 Brampton, Robert, of Lowth, shoemaker 0
3778508 1950994 1950994 defendant Nuttyn William butcher 586680 586680 Nuttyn, William, of Lowth, butcher 1
3785046 1953106 1953106 defendant Holton Richard yeoman 586680 586680 Holton, Richard, of Lowth, yeoman 0
3790595 1954882 1954882 plaintiff West William dyer 586680 586680 West, William, of Lowth, dyer 0
3899541 1990062 1990062 defendant Colyngwood Robert yeoman 586680 586680 Colyngwood, Robert, of Lowth, yeoman 0
3899542 1990062 1990062 defendant Browne William barber 586680 586680 Browne, William, of Lowth, barber 1
3909695 1993551 1993551 plaintiff Spencer Robert draper 586680 586680 Spencer, Robert, of Lowth, draper 0
3918338 1996469 1996469 defendant Collyngwode John weaver 586680 586680 Collyngwode, John, of Lowth, weaver 0
4002843 2025785 2025785 plaintiff Hochinson Thomas draper 586680 586680 Hochinson, Thomas, of Lowth, draper 0
4021212 2032306 2032306 defendant Smyth Thomas butcher 586680 586680 Smyth, Thomas, of Lowth, butcher 0
4041647 2039506 2039506 plaintiff North Thomas mercer 586680 586680 North, Thomas, of Lowth, mercer 0
4075418 2051511 2051511 plaintiff Rusheford Thomas dyer 586680 586680 Rusheford, Thomas, of Lowth, dyer 0
4096796 2059187 2059187 defendant Langton John gent 586680 586680 Langton, John, of Lowth, gent 0
4096797 2059187 2059187 defendant Haven William yeoman 586680 586680 Haven, William, of Lowth, yeoman 1
4141365 2075137 2075137 defendant Wrighte George laborer 586680 586680 Wrighte, George, of Lowth, laborer 1
4169183 2084723 2084723 defendant Wood alias Doffe Thomas tailor 586680 586680 Wood alias Doffe, Thomas, of Lowth, tailor 0
4169184 2084723 2084723 defendant Balaye Thomas yeoman 586680 586680 Balaye, Thomas, of Lowth, yeoman 1
4169187 2084724 2084724 defendant Balay Thomas yeoman 586680 586680 Balay, Thomas, of Lowth, yeoman 1
4170142 2085050 2085050 defendant Williamson Robert butcher 586680 586680 Williamson, Robert, of Lowth, butcher 0
4172868 2085964 2085964 defendant Bradley Thomas gent 586680 586680 Bradley Thomas, of Lowth, gent 0
4176135 2087128 2087128 defendant Smyth Thomas butcher 586680 586680 Smyth, Thomas, of Lowth, butcher 1
4186481 2090758 2090758 defendant North John yeoman 586680 586680 North, John, of Lowth, yeoman 0
4195605 2094012 2094012 defendant Barrett Edward yeoman 586680 586680 Barrett, Edward, of Lowth, yeoman 0
4232455 2106860 2106860 defendant Farbankes George, senior clother 586680 586680 Farbankes, George, senior, of Lowth, clother 0
4232456 2106860 2106860 defendant Farbankes George, junior   586680 586680 Farbankes, George, junior, of Lowth 1
4232465 2106863 2106863 defendant Somerscales John glover 586680 586680 Somerscales, John, of Lowth, glover 0
4237272 2108624 2108624 defendant Hurrell John grocer 586680 586680 Hurrell, John, of Lowth, or of Brantre, essex, grocer 0
4238712 2109159 2109159 defendant Reade Thomas gent 586680 586680 Reade, Thomas, of Lowth, gent 0
4239272 2109358 2109358 defendant Hudson John chandler 586680 586680 Hudson, John, of Lowth, husbandman, chandler 0
4239273 2109358 2109358 defendant Cutlove Thomas butcher 586680 586680 Cutlove, Thomas, of Lowth, butcher 1
4239274 2109358 2109358 defendant Brayforth George sherman 586680 586680 Brayforth, George, of Lowth, sherman 2
4239275 2109358 2109358 defendant Buck Walter weaver 586680 586680 Buck, Walter, of Lowth, weaver 3
4245563 2111493 2111493 defendant Lusby Robert carpenter 586680 586680 Lusby, Robert, of Lowth, carpenter 2
4245908 2111611 2111611 defendant Hurrell John grocer 586680 586680 Hurrell, John, of Lowth, or of Brantre, Essex, grocer 0
4264242 2117688 2117688 defendant Swathorpe William laborer 586680 586680 Swathorpe, William, of Lowth, laborer 2
4264525 2117777 2117777 defendant Bostocke alias Boston Thomas carpenter 586680 586680 Bostocke alias Boston, Thomas, of Lowth, carpenter 1
4267042 2118618 2118618 defendant Grene Alan glover 586680 586680 Grene, Alan, of Lowth, glover 0
4360717 2151004 2151004 defendant Thomas John vintner 586680 586680 Thomas, John, of Lowth, vintner 0
4370644 2154552 2154552 defendant Bellow Stephen glover 586680 586680 Bellow, Stephen, of Lowth, yeoman, or of Caister, glover 0
4382271 2158769 2158769 defendant Ward Ralph yeoman 586680 586680 Ward, Ralph, of Lowth, yeoman 0
4974556 2349354 2349354 defendant Bukton Thomas esq 586680 586680 Bukton, Thomas, of Lowth, or of Bukton juxta Seteryngton, Yorks, esq 0
4974557 2349354 2349354 defendant Wyhom Richard yeoman 586680 586680 Wyhom, Richard, of Lowth, yeoman 1
5306850 2447047 2447047 plaintiff Neweton John gent 586680 586680 Neweton, John, of Lowth, gent 1
5603412 2535956 2535956 defendant Wythys Richard dyer 586680 586680 Wythys, Richard, of Lowth, dyer 0

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