names

49 rows where place_id = 608793

✎ 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
3675423 1918350 1918350 defendant Pawe Thomas, junior gent 608793 608793 Pawe, Thomas, junior, of West Bylney, gent 0
3675424 1918350 1918350 defendant Pawe William gent 608793 608793 Pawe, William, of West Bylney, gent 1
3711560 1929926 1929926 defendant Pawe Thomas gent 608793 608793 Pawe, Thomas, of West Bylney, gent 0
3747592 1941164 1941164 defendant Russell Robert yeoman 608793 608793 Russell, Robert, of West Bylney, yeoman 0
3753264 1942961 1942961 defendant Sterre Thomas smith 608793 608793 Sterre, Thomas, of West Bylney, smith 0
3753267 1942961 1942961 defendant Boddys John husbandman 608793 608793 Boddys, John, of West Bylney, husbandman 3
3761411 1945581 1945581 defendant Russell Robert yeoman 608793 608793 Russell, Robert, of West Bylney, yeoman 0
3779610 1951352 1951352 defendant Russell Robert yeoman 608793 608793 Russell, Robert, of West Bylney, yeoman 0
3834136 1968618 1968618 defendant Shaxton John gent 608793 608793 Shaxton, John, of West Bylney, gent 1
3875378 1982011 1982011 defendant Draper Thomas yeoman 608793 608793 Draper, Thomas, of West Bylney, yeoman 0
3876286 1982309 1982309 defendant Spany Thomas husbandman 608793 608793 Spany, Thomas, of West Bylney, husbandman 0
3876288 1982310 1982310 defendant Starre Thomas husbandman 608793 608793 Starre, Thomas, of West Bylney, husbandman 0
3880671 1983800 1983800 defendant Draper Thomas yeoman 608793 608793 Draper, Thomas, of West Bylney, yeoman 0
3914432 1995171 1995171 defendant Draper Thomas yeoman 608793 608793 Draper, Thomas, of West Bylney, yeoman 0
3940349 2003793 2003793 defendant Barker John yeoman 608793 608793 Barker, John, of West Bylney, yeoman 0
3970223 2014183 2014183 defendant Bolton Richard laborer 608793 608793 Bolton, Richard, of West Bylney, laborer 1
3971967 2014752 2014752 defendant Danby John yeoman 608793 608793 Danby, John, of West Bylney, yeoman 0
3982805 2018623 2018623 defendant Penyston Michael gent 608793 608793 Penyston, Michael, of West Bylney, gent 0
3987101 2020132 2020132 plaintiff Wright John   608793 608793 Wright, John, of West Bylney 0
4023258 2033025 2033025 defendant Kyng Richard   608793 608793 Kyng, Richard, of West Bylney, hat maker 0
4032207 2036192 2036192 plaintiff Galt Stephen yeoman 608793 608793 Galt, Stephen, of West Bylney, yeoman 0
4032208 2036192 2036192 defendant Barker Thomas yeoman 608793 608793 Barker, Thomas, of West Bylney, yeoman 0
4037987 2038231 2038231 defendant Barker Thomas yeoman 608793 608793 Barker, Thomas, of West Bylney, yeoman 0
4084370 2054681 2054681 defendant Shaxton Leonard gent 608793 608793 Shaxton, Leonard, of West Bylney, gent 0
4084371 2054681 2054681 defendant Heydon Robert   608793 608793 Heydon, Robert, of West Bylney, shepherd 1
4094958 2058525 2058525 defendant Shaxton Leonard gent 608793 608793 Shaxton, Leonard, of West Bylney, gent 1
4107543 2062984 2062984 defendant Wylson William   608793 608793 Wylson, William, of West Bylney, 2
4107829 2063076 2063076 defendant Wyseman Thomas   608793 608793 Wyseman, Thomas, of West Bylney, shepherd 1
4142897 2075691 2075691 defendant Shaxton Leonard gent 608793 608793 Shaxton, Leonard, of West Bylney, gent 1
4142902 2075692 2075692 defendant Shaxton Leonard gent 608793 608793 Shaxton, Leonard, of West Bylney, gent 1
4143721 2075962 2075962 defendant Stonard Edmund husbandman 608793 608793 Stonard, Edmund, of West Bylney, husbandman 0
4161575 2082117 2082117 defendant Hardgrave Robert warrener 608793 608793 Hardgrave, Robert, of West Bylney, warrener 0
4174742 2086635 2086635 defendant Barker Thomas yeoman 608793 608793 Barker, Thomas, of West Bylney, yeoman 1
4192032 2092771 2092771 defendant Amyson William husbandman 608793 608793 Amyson, William, of West Bylney, husbandman 1
4198114 2094886 2094886 defendant Barker Thomas yeoman 608793 608793 Barker, Thomas, of West Bylney, yeoman 1
4214500 2100582 2100582 defendant Carman Thomas yeoman 608793 608793 Carman, Thomas, of West Bylney, yeoman 0
4214501 2100582 2100582 defendant Ellyson Cuthbert yeoman 608793 608793 Ellyson, Cuthbert, of West Bylney, yeoman 1
4258522 2115815 2115815 defendant Ellyson Cuthbert husbandman 608793 608793 Ellyson, Cuthbert, of West Bylney, husbandman 1
4284126 2124368 2124368 defendant Symond Abraham husbandman 608793 608793 Symond, Abraham, of West Bylney, husbandman 0
4292823 2127497 2127497 defendant Symond Abraham husbandman 608793 608793 Symond, Abraham, of West Bylney, husbandman 0
4331435 2140811 2140811 defendant Ellyson Cuthbert husbandman 608793 608793 Ellyson, Cuthbert, of West Bylney, husbandman 0
4331437 2140811 2140811 defendant Hawes George yeoman 608793 608793 Hawes, George, of West Bylney, yeoman 2
4333279 2141414 2141414 defendant Haukyn Christopher laborer 608793 608793 Haukyn, Christopher, of West Bylney, laborer 0
4333280 2141414 2141414 defendant Barber Richard yeoman 608793 608793 Barber, Richard, of West Bylney, yeoman 1
4333281 2141414 2141414 defendant Elleson Cuthbert laborer 608793 608793 Elleson, Cuthbert, of West Bylney, laborer 2
5009582 2359681 2359681 plaintiff Noreys Geoffrey   608793 608793 Noreys, Geoffrey, of West Bylney 1
5063950 2375748 2375748 defendant Norys Geoffrey yeoman 608793 608793 Norys, Geoffrey, of West Bylney, yeoman 0
5294799 2443462 2443462 defendant Baker William husbandman 608793 608793 Baker, William, of West Bylney, husbandman 0
5294800 2443462 2443462 defendant Barker Margery spinster 608793 608793 Barker, Margery, of West Bylney, spinster 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);