names

21 rows where place_id = 616084

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3712425 1930203 1930203 defendant Baker Richard wheeler 616084 616084 Baker, Richard, of Kings Norton, wheeler 1
3715968 1931282 1931282 defendant Vytter Richard weaver 616084 616084 Vytter, Richard, of Kings Norton, weaver 0
3716825 1931549 1931549 defendant Lette Baldwin laborer 616084 616084 Lette, Baldwin, of Kings Norton, laborer 0
3737402 1937937 1937937 defendant Let Baldwin laborer 616084 616084 Let, Baldwin, of Kings Norton, laborer 1
3737403 1937937 1937937 defendant Carter William husbandman 616084 616084 Carter, William, of Kings Norton, husbandman 2
3737404 1937937 1937937 defendant Slough John wheeler 616084 616084 Slough, John, of Kings Norton, wheeler 3
3737412 1937938 1937938 defendant Mylward Humphrey wheeler 616084 616084 Mylward, Humphrey, of Kings Norton, wheeler 0
3738900 1938373 1938373 defendant Male William sherman 616084 616084 Male, William, of Kings Norton, sherman 0
3769379 1948079 1948079 defendant Harper William husbandman 616084 616084 Harper, William, of Kings Norton, husbandman 1
3797140 1956989 1956989 plaintiff Fyld Henry mercer 616084 616084 Fyld, Henry, of Kings Norton, mercer 0
3797141 1956989 1956989 plaintiff Lyndon John mercer 616084 616084 Lyndon, John, of Kings Norton, mercer 1
3797146 1956990 1956990 defendant Lett Thomas smith 616084 616084 Lett, Thomas, of Kings Norton, smith 2
3814365 1962407 1962407 plaintiff Fylde Henry mercer 616084 616084 Fylde, Henry, of Kings Norton, mercer 0
3814366 1962407 1962407 plaintiff Lyndon John mercer 616084 616084 Lyndon, John, of Kings Norton, mercer 1
3903256 1991314 1991314 plaintiff Fyld John mercer 616084 616084 Fyld, John, of Kings Norton, mercer 0
3903260 1991314 1991314 defendant Symons Thomas butcher 616084 616084 Symons, Thomas, of Kings Norton, butcher 3
4057692 2045134 2045134 plaintiff Byssell William   616084 616084 Byssell, William, of Kings Norton, wheelwright 0
4057694 2045134 2045134 defendant Fytter Richard   616084 616084 Fytter, Richard, of Kings Norton, husbandman, his brother 1
4169434 2084812 2084812 defendant Mylward William yeoman 616084 616084 Mylward, William, of Kings Norton, yeoman 0
4638173 2242706 2242706 defendant Hedeley Robert   616084 616084 Hedeley, Robert, of Kings Norton 0
4699636 2265338 2265338 defendant Helyoke John gent 616084 616084 Helyoke, John, of Kings Norton, gent 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);