names

32 rows where place_id = 605968

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3663550 1914526 1914526 defendant Hyll John laborer 605968 605968 Hyll, John, of Tostoke, laborer 0
3681516 1920310 1920310 defendant Gylle Walter husbandman 605968 605968 Gylle, Walter, of Tostoke, husbandman 0
3710241 1929519 1929519 defendant Dey George shoemaker 605968 605968 Dey, George, of Tostoke, shoemaker 0
3907101 1992664 1992664 defendant Somer John butcher 605968 605968 Somer, John, of Tostoke, butcher 0
3934634 2001878 2001878 defendant Nune George   605968 605968 Nune, George, of Tostoke, cloth maker 0
3950634 2007294 2007294 defendant Bumpsted John clothier 605968 605968 Bumpsted, John, of Tostoke, clothier 0
4133889 2072457 2072457 defendant Bumpsted John yeoman 605968 605968 Bumpsted, John, of Tostoke, yeoman 0
4156226 2080251 2080251 defendant Bumpsted John yeoman 605968 605968 Bumpsted, John, of Tostoke, yeoman 1
4225151 2104267 2104267 defendant Bumpsted John, senior yeoman 605968 605968 Bumpsted, John, senior, of Tostoke, yeoman 0
4711138 2268838 2268838 defendant Fuller Robert husbandman 605968 605968 Fuller, Robert, of Tostoke, husbandman 2
4754598 2281821 2281821 defendant Fuller Robert fuller 605968 605968 Fuller, Robert, of Tostoke, fuller 2
4853013 2312361 2312361 defendant Whytehand William   605968 605968 Whytehand, William, of Tostoke, parson 0
4875801 2319393 2319393 defendant Buntyng John husbandman 605968 605968 Buntyng, John, of Tostoke, husbandman 0
5013408 2360756 2360756 defendant Curteys William yeoman 605968 605968 Curteys, William, of Tostoke, yeoman 1
5056716 2373580 2373580 defendant Rowe William husbandman 605968 605968 Rowe, William, of Tostoke, husbandman 2
5057381 2373776 2373776 defendant Lenys Ralph butcher 605968 605968 Lenys, Ralph, of Tostoke, butcher 2
5089904 2383426 2383426 defendant Lenys or Levys Ralph   605968 605968 Lenys or Levys, Ralph, of Tostoke 1
5104024 2387602 2387602 defendant Lenys or Levys Ralph butcher 605968 605968 Lenys or Levys, Ralph, of Tostoke, butcher 1
5165602 2405680 2405680 defendant Lenys or Levys Ralph butcher 605968 605968 Lenys or Levys, Ralph, of Tostoke, butcher 3
5215514 2420261 2420261 defendant Lenys or Levys or Leuys Ralph husbandman 605968 605968 Lenys or Levys or Leuys, Ralph, of Tostoke, husbandman 0
5251505 2430575 2430575 defendant Schamberleyn Henry tailor 605968 605968 Schamberleyn, Henry, of Tostoke, tailor 0
5251506 2430575 2430575 defendant Tyllye Henry laborer 605968 605968 Tyllye, Henry, of Tostoke, laborer 1
5254120 2431411 2431411 defendant Tylle John husbandman 605968 605968 Tylle, John, of Tostoke, husbandman 0
5256294 2432090 2432090 defendant Schambyrleyn Henry tailor 605968 605968 Schambyrleyn, Henry, of Tostoke, tailor 0
5256666 2432206 2432206 plaintiff Dybold John   605968 605968 Dybold, John, of Tostoke 0
5256667 2432206 2432206 plaintiff Nunne John   605968 605968 Nunne, John, of Tostoke 1
5268143 2435806 2435806 defendant Rowe William husbandman 605968 605968 Rowe, William, of Tostoke, husbandman 1
5301429 2445379 2445379 defendant Munnyng Nicholas husbandman 605968 605968 Munnyng, Nicholas, of Tostoke, husbandman 2
5566695 2524855 2524855 plaintiff Rosbrook Anderew   605968 605968 Rosbrook, Anderew, of Tostoke 1
5566698 2524856 2524856 plaintiff Rosshbrook Andrew   605968 605968 Rosshbrook, Andrew, of Tostoke 1
5574241 2527030 2527030 defendant Gylly Walter husbandman 605968 605968 Gylly, Walter, of Tostoke, husbandman 2
5631387 2553820 2553820 defendant Berdewell John chapman 605968 605968 Berdewell, John, of Tostoke, chapman 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);