names

71 rows where place_id = 591576

✎ 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
3604875 1869189 1869189 defendant Croft John yeoman 591576 591576 Croft, John, of Smalburgh, yeoman 3
3625691 1875572 1875572 defendant Fulburn Thomas yeoman 591576 591576 Fulburn, Thomas, of Smalburgh, yeoman 0
3629512 1904087 1904087 defendant Mathewe John husbandman 591576 591576 Mathewe, John, of Smalburgh, husbandman 1
3651073 1910701 1910701 defendant Auncell Thomas husbandman 591576 591576 Auncell, Thomas, of Smalburgh, husbandman 0
3651074 1910701 1910701 defendant Folbergh Thomas carver 591576 591576 Folbergh, Thomas, of Smalburgh, carver 1
3661393 1913837 1913837 defendant Bery William   591576 591576 Bery, William, of Smalburgh, wheelwright 2
3662848 1914296 1914296 defendant Rumpe John husbandman 591576 591576 Rumpe, John,of Smalburgh, husbandman 0
3680187 1919876 1919876 defendant Deve Richard gent 591576 591576 Deve, Richard, of Smalburgh, gent 0
3696155 1925019 1925019 defendant Mathewe John butcher 591576 591576 Mathewe, John, of Smalburgh, butcher 1
3699289 1925993 1925993 defendant Auncell John husbandman 591576 591576 Auncell, John, of Smalburgh, husbandman 0
3738188 1938156 1938156 defendant Runhale Richard   591576 591576 Runhale, Richard, of Smalburgh, worsted weaver 4
3750704 1942144 1942144 defendant Runhale Richard   591576 591576 Runhale, Richard, of Smalburgh, worsted weaver 3
3755160 1943565 1943565 defendant Runhale Richard husbandman 591576 591576 Runhale, Richard, of Smalburgh, husbandman 0
3755462 1943661 1943661 defendant Norgate John   591576 591576 Norgate, John, of Smalburgh, worsted weaver 0
3758138 1944531 1944531 defendant Jurdan Robert husbandman 591576 591576 Jurdan, Robert, of Smalburgh, husbandman 2
3758756 1944727 1944727 defendant Woodthorp Robert   591576 591576 Woodthorp, Robert, of Smalburgh, worsted weaver 0
3758757 1944727 1944727 defendant Runnale Thomas carpenter 591576 591576 Runnale, Thomas, of Smalburgh, carpenter 1
3758758 1944727 1944727 defendant Carman Robert husbandman 591576 591576 Carman, Robert, of Smalburgh, husbandman 2
3758761 1944728 1944728 defendant Woodthorp Robert   591576 591576 Woodthorp, Robert, of Smalburgh, worsted weaver 0
3758762 1944728 1944728 defendant Runnale Thomas carpenter 591576 591576 Runnale, Thomas, of Smalburgh, carpenter 1
3758763 1944728 1944728 defendant Carman Robert husbandman 591576 591576 Carman, Robert, of Smalburgh, husbandman 2
3769175 1948017 1948017 defendant Mathewe John butcher 591576 591576 Mathewe, John, of Smalburgh, butcher 1
3821954 1964760 1964760 defendant Colt John husbandman 591576 591576 Colt, John, of Smalburgh, husbandman 3
3830140 1967325 1967325 defendant Dawes William pedder 591576 591576 Dawes, William, of Smalburgh, pedder 3
3868734 1979783 1979783 defendant Styward Thomas husbandman 591576 591576 Styward, Thomas, of Smalburgh, husbandman 1
3880335 1983677 1983677 defendant Wynne John smith 591576 591576 Wynne, John, of Smalburgh, smith 1
3884625 1985129 1985129 defendant Bangys William yeoman 591576 591576 Bangys, William, of Smalburgh, yeoman 0
3919229 1996760 1996760 defendant Runhall Robert husbandman 591576 591576 Runhall, Robert, of Smalburgh, husbandman 0
3923528 1998178 1998178 defendant Broun Richard yeoman 591576 591576 Broun, Richard, of Smalburgh, yeoman 0
3923530 1998179 1998179 defendant Broun Richard yeoman 591576 591576 Broun, Richard, of Smalburgh, yeoman 0
3925580 1998867 1998867 defendant Umfrey William smith 591576 591576 Umfrey, William, of Smalburgh, smith 4
3942020 2004343 2004343 defendant Bauges Thomas tanner 591576 591576 Bauges, Thomas, of smalburgh, tanner 0
3948785 2006642 2006642 defendant Wright Nicholas husbandman 591576 591576 Wright, Nicholas, of Smalburgh, husbandman 7
3992674 2022129 2022129 defendant Toly Richard yeoman 591576 591576 Toly, Richard, of Smalburgh, yeoman 0
3996601 2023543 2023543 defendant Norgate Edmund yeoman 591576 591576 Norgate, Edmund, of Smalburgh, yeoman 5
4088787 2056291 2056291 defendant Toley William yeoman 591576 591576 Toley, William, of Smalburgh, yeoman 0
4088789 2056292 2056292 defendant Toly William yeoman 591576 591576 Toly, William, of Smalburgh, yeoman 0
4116196 2066084 2066084 defendant Tolye William yeoman 591576 591576 Tolye, William, of Smalburgh, yeoman 1
4147728 2077348 2077348 defendant Toley William yeoman 591576 591576 Toley, William, of Smalburgh, yeoman 0
4159334 2081334 2081334 defendant Poyte Edward husbandman 591576 591576 Poyte, Edward, of Smalburgh, husbandman 2
4265595 2118129 2118129 defendant Fresyll Thomas husbandman 591576 591576 Fresyll, Thomas, of Smalburgh, husbandman 3
4311708 2134237 2134237 defendant Baker John husbandman 591576 591576 Baker, John, of Smalburgh, husbandman 1
4329369 2140133 2140133 defendant Bridge William husbandman 591576 591576 Bridge, William, of Smalburgh, husbandman 0
4329370 2140133 2140133 defendant Norgate Edmund yeoman 591576 591576 Norgate, Edmund, of Smalburgh, yeoman 1
4356450 2149485 2149485 defendant Gase of Ease Robert   591576 591576 Gase of Ease, Robert, of Smalburgh, worsted weaver 1
4857162 2313624 2313624 defendant Joye John woolman 591576 591576 Joye, John, of Smalburgh, woolman 0
5214259 2419902 2419902 defendant Felymont John husbandman 591576 591576 Felymont, John, of Smalburgh, husbandman 5
5217959 2420987 2420987 defendant Praty Thomas spicer 591576 591576 Praty, Thomas, of Smalburgh, spicer 0
5367840 2465568 2465568 defendant Coowper John husbandman 591576 591576 Coowper, John, of Smalburgh, husbandman 2
5370199 2466264 2466264 defendant Partrik John, junior smith 591576 591576 Partrik, John, junior, of Smalburgh, smith 0
5370200 2466264 2466264 defendant Tatishale John baker 591576 591576 Tatishale, John, of Smalburgh, baker 1
5393528 2473207 2473207 defendant Rumpe Isaac loader 591576 591576 Rumpe, Isaac, of Smalburgh, loader 0
5453984 2491082 2491082 defendant Crofte John butcher 591576 591576 Crofte, John, of Smalburgh, butcher 1
5533726 2515097 2515097 defendant Fanye John butcher 591576 591576 Fanye, John, of Smalburgh, butcher 0
5534760 2515414 2515414 defendant Wodecroft Robert   591576 591576 Wodecroft, Robert, of Smalburgh, worsted weaver 1
5535378 2515590 2515590 defendant Partryke John smith 591576 591576 Partryke, John, of Smalburgh, smith 0
5535579 2515657 2515657 defendant Fulburgh Thomas engraver 591576 591576 Fulburgh, Thomas, of Smalburgh, engraver 3
5536931 2516039 2516039 plaintiff Clyfford Edward   591576 591576 Clyfford, Edward, of Smalburgh 0
5550428 2520145 2520145 defendant Woodthorpe Robert   591576 591576 Woodthorpe, Robert, of Smalburgh, worsted weaver 0
5550429 2520145 2520145 defendant Runhale Thomas carpenter 591576 591576 Runhale, Thomas, of Smalburgh, carpenter 1
5550430 2520145 2520145 defendant Carman John husbandman 591576 591576 Carman, John, of Smalburgh, husbandman 2
5552039 2520637 2520637 defendant Partryche John, senior smith 591576 591576 Partryche, John, senior, of Smalburgh, smith 1
5555707 2521663 2521663 defendant Woodthorp Robert husbandman 591576 591576 Woodthorp, Robert, of Smalburgh, husbandman 5
5565636 2524541 2524541 defendant Smalwode Richard husbandman 591576 591576 Smalwode, Richard, of Smalburgh, husbandman 0
5577671 2528085 2528085 defendant Smalwode Richard   591576 591576 Smalwode, Richard, of Smalburgh, worsted weaver 0
5586052 2530679 2530679 defendant Partryk John smith 591576 591576 Partryk, John, of Smalburgh, smith 3
5593672 2533006 2533006 defendant Becher John butcher 591576 591576 Becher, John, of Smalburgh, butcher 2
5596152 2533712 2533712 defendant Wodthorp Robert   591576 591576 Wodthorp, Robert, of Smalburgh, worsted weaver 0
5596153 2533712 2533712 defendant Ovy Geoffrey yeoman 591576 591576 Ovy, Geoffrey, of Smalburgh, yeoman 1
5597175 2534021 2534021 defendant Partryk John, senior smith 591576 591576 Partryk, John, senior, of Smalburgh, smith 3
5599452 2534718 2534718 defendant Wodethorp Robert   591576 591576 Wodethorp, Robert, of Smalburgh, worsted weaver 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);