names

36 rows where place_id = 621071

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3739409 1938535 1938535 defendant Shyngler Richard weaver 621071 621071 Shyngler, Richard, of West Bromwich, weaver 0
3739410 1938535 1938535 defendant Depyng William lorimer 621071 621071 Depyng, William, of West Bromwich, lorimer 1
3860366 1976964 1976964 defendant Hadley Robert yeoman 621071 621071 Hadley, Robert, of West Bromwich, yeoman 3
3954965 2008799 2008799 defendant Asteley Humphrey yeoman 621071 621071 Asteley, Humphrey, of West Bromwich, yeoman 0
3985948 2019740 2019740 defendant Hophyns or Hopkyns John cooper 621071 621071 Hophyns or Hopkyns, John, of West Bromwich, cooper 0
4044455 2040472 2040472 defendant Watson Francis husbandman 621071 621071 Watson, Francis, of West Bromwich, husbandman 1
4052080 2043168 2043168 defendant Asteley Humphrey ironmonger 621071 621071 Asteley, Humphrey, of West Bromwich, ironmonger 0
4146533 2076938 2076938 defendant Taylor William yeoman 621071 621071 Taylor, William, of West Bromwich, yeoman 3
4156713 2080426 2080426 defendant Burcott George smith 621071 621071 Burcott, George, of West Bromwich, or of Newport Pagnell, Bucks, smith 0
4156714 2080426 2080426 defendant Richard Humphrey   621071 621071 Richard, Humphrey, of West Bromwich, or of Wotton, Warks, "wherler" 1
4156715 2080426 2080426 defendant Tybbat or Tybbattes John smith 621071 621071 Tybbat or Tybbattes, John, of West Bromwich, or of Oldburye, Salop, smith 2
4186106 2090628 2090628 defendant Taylor William yeoman 621071 621071 Taylor, William, of West Bromwich, yeoman 0
4186220 2090665 2090665 defendant Taylor William yeoman 621071 621071 Taylor, William, of West Bromwich, yeoman 0
4189173 2091706 2091706 plaintiff While William (legal representative) 621071 621071 While, William, of West Bromwich, blacksmith, executors of 0
4210413 2099199 2099199 defendant Cowper alias Piddocke Edward clerk 621071 621071 Cowper alias Piddocke, Edward, of West Bromwich, clerk 2
4218103 2101830 2101830 defendant Hunt Richard lorimer 621071 621071 Hunt, Richard, of West Bromwich, husbandman, lorimer 0
4218104 2101830 2101830 defendant Morrys John lorimer 621071 621071 Morrys, John, of West Bromwich, lorimer 1
4219955 2102483 2102483 defendant Ashmore Edward nailer 621071 621071 Ashmore, Edward, of West Bromwich, nailer 0
4233894 2107383 2107383 defendant Woodward John yeoman 621071 621071 Woodward, John, of West Bromwich, yeoman 0
4265992 2118265 2118265 defendant Woodward John yeoman 621071 621071 Woodward, John, of West Bromwich, yeoman 0
4328267 2139769 2139769 defendant Langam alias Langwood William sawyer 621071 621071 Langam alias Langwood, William, of West Bromwich, sawyer 0
4328268 2139769 2139769 defendant Willyams Richard sawyer 621071 621071 Willyams, Richard, of West Bromwich, sawyer 1
4328269 2139769 2139769 defendant Cornes John sawyer 621071 621071 Cornes, John, of West Bromwich, sawyer 2
4329216 2140084 2140084 defendant Woodward John yeoman 621071 621071 Woodward, John, of West Bromwich, yeoman 0
4333043 2141338 2141338 defendant Sparrye Anthony nailer 621071 621071 Sparrye, Anthony, of West Bromwich, nailer 0
4333044 2141338 2141338 defendant Newey William nailer 621071 621071 Newey, William, of West Bromwich, nailer 1
4387774 2160549 2160549 defendant Weeke alias Broome James smith 621071 621071 Weeke alias Broome, James, of West Bromwich, smith 0
4403030 2165601 2165601 defendant Pearshall Richard carpenter 621071 621071 Pearshall, Richard, of West Bromwich, carpenter 0
4409472 2167764 2167764 defendant Norris John nailer 621071 621071 Norris, John, of West Bromwich, nailer 2
4412067 2168627 2168627 defendant Dudley Edward cooper 621071 621071 Dudley, Edward, of West Bromwich, cooper 0
5001643 2357373 2357373 defendant Gefson Henry drover 621071 621071 Gefson, Henry, of West Bromwich, drover 0
5007073 2358963 2358963 defendant Playnmore John husbandman 621071 621071 Playnmore, John, of West Bromwich, husbandman 0
5196489 2414725 2414725 defendant Haukes John husbandman 621071 621071 Haukes, John, of West Bromwich, husbandman 0
5196492 2414726 2414726 defendant Haukes John husbandman 621071 621071 Haukes, John, of West Bromwich, husbandman 0
5271085 2436637 2436637 defendant Hobon John laborer 621071 621071 Hobon, John, of West Bromwich, laborer 0
5271086 2436637 2436637 defendant Hunt John laborer 621071 621071 Hunt, John, of West Bromwich, laborer 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);