names

34 rows where place_id = 646960

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3893682 1988113 1988113 defendant Wygley Roger hackneyman 646960 646960 Wygley, Roger, of Hackney, Middx, hackneyman 0
3944179 2005070 2005070 defendant Dixon James yeoman 646960 646960 Dixon, James, of Hackney, Middx, yeoman 0
3947371 2006154 2006154 plaintiff Cobbe Stephen esq 646960 646960 Cobbe, Stephen, of Hackney, Middx, esq 0
3966924 2013064 2013064 defendant Gowrley or Gorley John gent 646960 646960 Gowrley or Gorley, John, of Hackney, Middx, gent 1
3966937 2013067 2013067 defendant Gowrley or Gorley John gent 646960 646960 Gowrley or Gorley, John, of Hackney, Middx, gent 1
3968511 2013619 2013619 plaintiff Clarke John yeoman 646960 646960 Clarke, John, of Hackney, Middx, yeoman 0
3975677 2016052 2016052 plaintiff Hyde Robert   646960 646960 Hyde, Robert, of Hackney, Middx, hackneyman, administrators of 0
3976847 2016473 2016473 defendant Muns John moneyer 646960 646960 Muns, John, of Hackney, Middx, gent, moneyer 0
3977244 2016611 2016611 defendant Archer George yeoman 646960 646960 Archer, George, of Hackney, Middx, yeoman 0
3998404 2024167 2024167 defendant Knell Thomas clerk 646960 646960 Knell, Thomas, of Hackney, Middx, clerk 5
4029720 2035269 2035269 plaintiff Dedycott Arthur (legal representative) 646960 646960 Dedycott, Arthur, of Hackney, Middx, gent, or of London, draper, executor of 0
4040109 2038963 2038963 defendant Elrington Robert gent 646960 646960 Elrington, Robert, of Hackney, Middx, gent 1
4044697 2040551 2040551 plaintiff Rigby Alexander gent 646960 646960 Rigby, Alexander, of Hackney, Middx, gent 0
4051435 2042934 2042934 defendant Eldrington Robert gent 646960 646960 Eldrington, Robert, of Hackney, Middx, gent 1
4056835 2044826 2044826 defendant Stone Walter grocer 646960 646960 Stone, Walter, of Hackney, Middx, grocer 0
4059322 2045727 2045727 defendant Stone Walter   646960 646960 Stone, Walter, of Hackney, Middx, groom 1
4060288 2046078 2046078 defendant Harper John gent 646960 646960 Harper, John, of Hackney, Middx, gent 0
4074895 2051324 2051324 plaintiff Rigbye Alexander gent 646960 646960 Rigbye, Alexander, of Hackney, Middx, gent 0
4082126 2053907 2053907 defendant Lynnett Hipolitus yeoman 646960 646960 Lynnett, Hipolitus, of Hackney, Middx, yeoman 0
4115260 2065749 2065749 defendant Kaye John esq 646960 646960 (Kaye, John, of Hackney, Middx, esq 1
4161170 2081983 2081983 defendant Elrington Henry yeoman 646960 646960 Elrington, Henry, of Hackney, Middx, yeoman 2
4266188 2118331 2118331 defendant Lynnett Francis   646960 646960 Lynnett, Francis, of Hackney, Middx, gent, son of Ipolitus 0
4294393 2128075 2128075 defendant Bell Ralph yeoman 646960 646960 Bell, Ralph, of Hackney, Middx, yeoman 1
4316144 2135758 2135758 defendant Lynnett Francis gent 646960 646960 Lynnett, Francis, of Hackney, Middx, gent 0
4328211 2139750 2139750 defendant Brounker Anne singlewoman 646960 646960 Anne his wife, formerly Anne Parker, of Hackney, Middx, singlewoman 1
4352548 2148129 2148129 defendant Kaye John gent 646960 646960 Kaye, John, of Hackney, Middx, or of Whitley, Berks, gent 0
4371965 2155035 2155035 defendant Hunn Reginald yeoman 646960 646960 Hunn, Reginald, of Hackney, Middx, yeoman 0
4378790 2157488 2157488 defendant Bell Ralph yeoman 646960 646960 Bell, Ralph, of Hackney, Middx, yeoman 0
4388553 2160813 2160813 defendant Kay John gent 646960 646960 Kay, John, of Hackney, Middx, or of Whytley, Berks, gent 0
4395896 2163205 2163205 defendant Machell John, junior gent 646960 646960 Machell, John, junior, of Hackney, Middx, gent 1
4397110 2163602 2163602 defendant Sturtivant John gent 646960 646960 Sturtivant, John, of Hackney, Middx, gent 0
4401114 2164967 2164967 defendant Machell John esq 646960 646960 Machell, John, of Hackney, Middx, esq 0
4411195 2168331 2168331 defendant Gowrey Lawrence yeoman 646960 646960 Gowrey, Lawrence, of Hackney, Middx, yeoman 1
4773928 2287825 2287825 defendant Anstone Thomas husbandman 646960 646960 Anstone, Thomas, of Hackney, Middx, husbandman 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);