names

48 rows where place_id = 607926

✎ 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
3671504 1917070 1917070 defendant Browne John yeoman 607926 607926 Browne, John, of Darsham, yeoman 0
3753583 1943063 1943063 defendant Bokell John gent 607926 607926 Bokell, John, of Darsham, gent 0
3753585 1943064 1943064 defendant Bokell John gent 607926 607926 Bokell, John, of Darsham, gent 0
3793739 1955908 1955908 defendant Aunsell John yeoman 607926 607926 Aunsell, John, of Darsham, yeoman 0
3793740 1955908 1955908 defendant Gunnell Simon laborer 607926 607926 Gunnell, Simon, of Darsham, laborer 1
3793741 1955908 1955908 defendant Gunnell Roger   607926 607926 Gunnell, Roger, of Darsham 2
3934081 2001693 2001693 defendant Mollett Thomas husbandman 607926 607926 Mollett, Thomas, of Darsham, husbandman 0
3934082 2001693 2001693 defendant Mollett John, senior turner 607926 607926 Mollett, John, senior, of Darsham, turner 1
3939669 2003574 2003574 defendant Mollett Thomas yeoman 607926 607926 Mollett, Thomas, of Darsham, yeoman 0
3950393 2007220 2007220 plaintiff Fyske Geoffrey husbandman 607926 607926 Fyske, Geoffrey, of Darsham, husbandman 0
3958240 2009955 2009955 defendant Stapleton Robert tailor 607926 607926 Stapleton, Robert, of Darsham, tailor 0
3965640 2012597 2012597 defendant Gybon John gent 607926 607926 Gybon, John, of Darsham, gent 0
3999738 2024664 2024664 defendant Reve Reginald husbandman 607926 607926 Reve, Reginald, of Darsham, husbandman 1
4000889 2025090 2025090 defendant Reve Thomas husbandman 607926 607926 Reve, Thomas, of Darsham, husbandman 0
4000890 2025090 2025090 defendant Reve Robert singleman 607926 607926 Reve, Robert, of Darsham, singleman 1
4000891 2025090 2025090 defendant Hayward Thomas husbandman 607926 607926 Hayward, Thomas, of Darsham, husbandman 2
4000893 2025091 2025091 defendant Reve Thomas husbandman 607926 607926 Reve, Thomas, of Darsham, husbandman 0
4000894 2025091 2025091 defendant Reve Robert singleman 607926 607926 Reve, Robert, of Darsham, singleman 1
4000895 2025091 2025091 defendant Hayward Thomas husbandman 607926 607926 Hayward, Thomas, of Darsham, husbandman 2
4006706 2027177 2027177 defendant Beckett William yeoman 607926 607926 Beckett, William, of Darsham, yeoman 1
4025289 2033705 2033705 defendant Elles Nicholas yeoman 607926 607926 Elles, Nicholas, of Darsham, yeoman 1
4027150 2034357 2034357 defendant Smyth Thomas husbandman 607926 607926 Smyth, Thomas, of Darsham, husbandman 1
4028054 2034684 2034684 defendant Gibon John gent 607926 607926 Gibon, John, of Darsham, gent 0
4029676 2035253 2035253 defendant Reve Reginald husbandman 607926 607926 Reve, Reginald, of Darsham, husbandman 0
4096183 2058962 2058962 defendant Wentworth Geoffrey yeoman 607926 607926 Wentworth, Geoffrey, of Darsham, yeoman 3
4101042 2060687 2060687 defendant Waynflete John yeoman 607926 607926 Waynflete, John, of Darsham, yeoman 1
4105263 2062161 2062161 defendant Waynflet John yeoman 607926 607926 Waynflet, John, of Darsham, yeoman 0
4122730 2068423 2068423 defendant Browne Richard yeoman 607926 607926 Browne, Richard, of Darsham, yeoman 0
4122731 2068423 2068423 defendant Uttinge John butcher 607926 607926 Uttinge, John, of Darsham, butcher 1
4149497 2077950 2077950 defendant Reve Robert yeoman 607926 607926 Reve, Robert, of Darsham, yeoman 1
4150948 2078461 2078461 defendant Reve Robert yeoman 607926 607926 Reve, Robert, of Darsham, yeoman 2
4150981 2078474 2078474 defendant Waynflete John yeoman 607926 607926 Waynflete, John, of Darsham, yeoman 0
4195468 2093959 2093959 defendant Weynflete John yeoman 607926 607926 Weynflete, John, of Darsham, yeoman 1
4241605 2110178 2110178 defendant Smyth Richard tanner 607926 607926 Smyth, Richard, of Darsham, tanner 0
4242235 2110396 2110396 defendant Smyth Richard husbandman 607926 607926 Smyth, Richard, of Darsham, husbandman 3
4275033 2121221 2121221 defendant Haddenham William yeoman 607926 607926 Haddenham, William, of Darsham, yeoman 1
4278438 2122394 2122394 defendant Fermly Robert yeoman 607926 607926 Fermly, Robert, of Darsham, yeoman 0
4283372 2124090 2124090 defendant Estowe John yeoman 607926 607926 Estowe, John, of Darsham, yeoman 1
4302376 2130951 2130951 defendant Reve Robert tailor 607926 607926 Reve, Robert, of Darsham, tailor 3
4302947 2131153 2131153 defendant Harcock Robert tailor 607926 607926 Harcock, Robert, of Darsham, tailor 1
4303132 2131225 2131225 defendant Reve Robert tailor 607926 607926 Reve, Robert, of Darsham, tailor 1
4303147 2131228 2131228 defendant Andrewes Thomas yeoman 607926 607926 Andrewes, Thomas, of Darsham, yeoman 3
4326453 2139208 2139208 defendant Walker Henry maltster 607926 607926 Walker, Henry, of Darsham, or of Trouse, Norf, maltster 0
4331323 2140773 2140773 defendant Thurketle John yeoman 607926 607926 Thurketle, John, of Darsham, yeoman 0
4335937 2142302 2142302 plaintiff Baldwyn John (legal representative) 607926 607926 Baldwyn, John, of Darsham, executor of 0
4335939 2142302 2142302 defendant Reve John yeoman 607926 607926 Reve, John, of Darsham, or of Beccles, yeoman 0
4400493 2164758 2164758 defendant Fleminge William singleman 607926 607926 Fleminge, William, of Darsham, yeoman, singleman 2
5597936 2534258 2534258 defendant Love John husbandman 607926 607926 Love, John, of Darsham, husbandman 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);