names

33 rows where place_id = 647984

✎ 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
3899249 1989959 1989959 defendant Smythe William, junior merchant 647984 647984 Smythe, William, junior, of Woodbridge, Suff, merchant 0
3927094 1999397 1999397 defendant Stalworthye Thomas chapman 647984 647984 Stalworthye, Thomas, of Woodbridge, Suff, chapman 3
3927751 1999620 1999620 defendant Flyck Edmund merchant 647984 647984 Flyck, Edmund, of Woodbridge, Suff, merchant 1
3927754 1999621 1999621 defendant Flyke Edmund merchant 647984 647984 Flyke, Edmund, of Woodbridge, Suff, merchant 1
3938849 2003334 2003334 defendant Bramford William gent 647984 647984 Bramford, William, of Woodbridge, Suff, gent 0
3941628 2004212 2004212 defendant Blauncheflowre William   647984 647984 Blauncheflowre, William, of Woodbridge, Suff, inn keeper 1
3945104 2005382 2005382 defendant Page John mercer 647984 647984 Page, John, of Woodbridge, Suff, mercer 0
3949725 2006981 2006981 defendant Johnson Nicholas chapman 647984 647984 Johnson, Nicholas, of Woodbridge, Suff, chapman 0
3953748 2008386 2008386 plaintiff Jolye Thomas merchant 647984 647984 Jolye, Thomas, of Woodbridge, Suff, merchant 0
3977669 2016756 2016756 defendant Swymborne William clothier 647984 647984 Swymborne, William, of Woodbridge, Suff, clothier 4
3998620 2024243 2024243 defendant Brighte Thomas mercer 647984 647984 Brighte, Thomas, of Woodbridge, Suff, mercer 3
4014778 2029998 2029998 defendant Webbe Thomas clothier 647984 647984 Webbe, Thomas, of Woodbridge, Suff, clothier 0
4033150 2036504 2036504 defendant Skrytton John chapman 647984 647984 Skrytton, John, of Woodbridge, Suff, chapman 0
4048280 2041827 2041827 defendant Crapne Thomas yeoman 647984 647984 Crapne, Thomas, of Woodbridge, Suff, yeoman 1
4054870 2044133 2044133 defendant Freston Robert innholder 647984 647984 Freston, Robert, of Woodbridge, Suff, innholder 1
4106678 2062679 2062679 defendant Partryche Christian widow 647984 647984 (Partryche, Christian, of Woodbridge, Suff, widow 1
4112985 2064913 2064913 defendant Rypton Alan chapman 647984 647984 (Rypton, Alan, of Woodbridge, Suff, chapman 1
4114736 2065557 2065557 defendant Hamond Mathew   647984 647984 Hamond, Mathew, of Woodbridge, Suff, linen draper 0
4120809 2067729 2067729 defendant Smythe William merchant 647984 647984 Smythe, William, of Woodbridge, Suff, merchant 1
4131942 2071736 2071736 defendant Bushe Thomas merchant 647984 647984 Bushe, Thomas, of Woodbridge, Suff, merchant 0
4132060 2071778 2071778 defendant Gardener John merchant 647984 647984 Gardener, John, of Woodbridge, Suff, merchant 1
4148668 2077658 2077658 defendant Gardyner John yeoman 647984 647984 Gardyner, John, of Woodbridge, Suff, yeoman 0
4156500 2080349 2080349 defendant Haumond Mathew chapman 647984 647984 Haumond, Mathew, of Woodbridge, Suff, chapman 2
4201640 2096117 2096117 defendant Turritt John leather dresser 647984 647984 Turritt, John, of Woodbridge, Suff, leather dresser 0
4261464 2116797 2116797 defendant Hubbarde Thomas   647984 647984 Hubbarde, Thomas, of Woodbridge, Suff, shipwright 1
4303998 2131529 2131529 defendant Rocke or Rowe Jonah yeoman 647984 647984 Rocke or Rowe, Jonah, of Woodbridge, Suff, yeoman 2
4308454 2133109 2133109 defendant Jurden Thomas blacksmith 647984 647984 Jurden, Thomas, of Woodbridge, Suff, blacksmith 1
4310740 2133900 2133900 defendant Webbe Thomas chapman 647984 647984 Webbe, Thomas, of Woodbridge, Suff, chapman 2
4354755 2148885 2148885 defendant Wolshawe Edward chapman 647984 647984 Wolshawe, Edward, of Woodbridge, Suff, chapman 0
4848584 2311031 2311031 defendant Neuport John gent 647984 647984 Neuport, John, of Woodbridge, Suff, gent 3
5157653 2403368 2403368 defendant Kempe Joan widow 647984 647984 (Kempe, Joan, of Woodbridge, Suff, widow 1
5159525 2403902 2403902 defendant Balle William spicer 647984 647984 Balle, William, of Woodbridge, Suff, spicer 1
5168687 2406568 2406568 defendant Sekford Margaret widow 647984 647984 Sekford, Margaret, of Woodbridge, Suff, widow 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);