names

59 rows where place_id = 590423

✎ 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
3601159 1868026 1868026 defendant Bageler or Bayeler John laborer 590423 590423 Bageler or Bayeler, John, of Edwardeston, laborer 2
3800618 1958104 1958104 defendant Cowper Robert miller 590423 590423 Cowper, Robert, of Edwardeston, miller 0
3825006 1965694 1965694 defendant Bogas William clothier 590423 590423 (Bogas, William, of Edwardeston, clothier 1
3825007 1965694 1965694 defendant Bogas John clothier 590423 590423 Bogas, John, of Edwardeston, clothier 2
3949340 2006840 2006840 defendant Aleyn John husbandman 590423 590423 Aleyn, John, of Edwardeston, husbandman 0
3949341 2006840 2006840 defendant Aleyn William husbandman 590423 590423 Aleyn, William, of Edwardeston, husbandman 1
4102222 2061086 2061086 defendant Gostling Philip clothier 590423 590423 Gostling, Philip, of Edwardeston, clothier 1
4432277 2174876 2174876 defendant Mellere Glbert le   590423 590423 Mellere, Glbert le, of Edwardeston, son of John 0
4508555 2203152 2203152 defendant Cros John fuller 590423 590423 Cros, John, of Edwardeston, fuller 3
4522584 2207402 2207402 defendant Boulde John   590423 590423 Boulde, John, of Edwardeston 0
4531898 2210242 2210242 defendant Calle William   590423 590423 Calle, William, of Edwardeston 1
4542696 2213603 2213603 defendant Davy William   590423 590423 Davy, William, of Edwardeston 2
4542697 2213603 2213603 defendant Davy Walter   590423 590423 Davy, Walter, of Edwardeston 3
4542703 2213604 2213604 defendant Davy William   590423 590423 Davy, William, of Edwardeston 2
4542704 2213604 2213604 defendant Davy Walter   590423 590423 Davy, Walter, of Edwardeston 3
4575036 2223715 2223715 defendant Waltham John   590423 590423 Waltham, John, of Edwardeston 0
4582569 2225990 2225990 plaintiff Faconer John   590423 590423 Faconer, John, of Edwardeston 0
4590276 2228329 2228329 plaintiff Pottere Roger   590423 590423 Pottere, Roger, of Edwardeston 1
4661985 2249590 2249590 defendant Buk Thomas ploughman 590423 590423 Buk, Thomas, of Edwardeston, ploughman 0
4661988 2249590 2249590 defendant Pottere Roger weaver 590423 590423 Pottere, Roger, of Edwardeston, weaver 3
4661989 2249590 2249590 defendant Plodder John carter 590423 590423 Plodder, John, of Edwardeston, carter 4
4661990 2249590 2249590 defendant Joyer John courser 590423 590423 Joyer, John, of Edwardeston, courser 5
4661991 2249590 2249590 defendant Millere Thomas laborer 590423 590423 Millere, Thomas, of Edwardeston, laborer 6
4661992 2249590 2249590 defendant Waltham Agnes widow of John Waltham 590423 590423 Waltham, Agnes, of Edwardeston, widow of John Waltham 7
4764086 2284756 2284756 defendant Cros John fuller 590423 590423 Cros, John, of Edwardeston, fuller 1
4765354 2285148 2285148 defendant Gugge Seamus butcher 590423 590423 Gugge, Seamus, of Edwardeston, butcher 0
4867998 2316959 2316959 defendant Howet John husbandman 590423 590423 Howet, John, of Edwardeston, husbandman 0
4871390 2318020 2318020 defendant Fakon Richard yeoman 590423 590423 Fakon, Richard, of Edwardeston, yeoman 2
4871400 2318022 2318022 defendant Bette John shoemaker 590423 590423 Bette, John, of Edwardeston, shoemaker 0
4871401 2318022 2318022 defendant Hersent Stephen yeoman 590423 590423 Hersent, Stephen, of Edwardeston, yeoman 1
4876741 2319699 2319699 defendant Smyth Thomas smith 590423 590423 Smyth, Thomas, of Edwardeston, smith 0
4885586 2322371 2322371 defendant Quyk William yeoman 590423 590423 Quyk, William, of Edwardeston, yeoman 3
4885638 2322382 2322382 defendant Gale John, senior husbandman 590423 590423 Gale, John, senior, of Edwardeston, husbandman 0
4885639 2322382 2322382 defendant Gale John, junior husbandman 590423 590423 Gale, John, junior, of Edwardeston, husbandman 1
4896830 2325666 2325666 defendant Fakon Richard fuller 590423 590423 Fakon, Richard, of Edwardeston, fuller 0
4908256 2329133 2329133 defendant Cros Thomas fuller 590423 590423 Cros, Thomas, of Edwardeston, fuller 0
4915244 2331274 2331274 defendant Quyk William yeoman 590423 590423 Quyk, William, of Edwardeston, yeoman 1
4923997 2333946 2333946 defendant Freman John butcher 590423 590423 Freman, John, of Edwardeston, butcher 2
4936027 2337670 2337670 plaintiff Bogays Thomas   590423 590423 Bogays, Thomas, of Edwardeston 0
4977327 2350178 2350178 defendant Quyke William husbandman 590423 590423 Quyke, William, of Edwardeston, husbandman 2
4989701 2353836 2353836 defendant Potter John fuller 590423 590423 Potter, John, of Edwardeston, fuller 3
5094007 2384644 2384644 defendant Deyne William butcher 590423 590423 Deyne, William, of Edwardeston, butcher 3
5112191 2389948 2389948 defendant Hersent William weaver 590423 590423 Hersent, William, of Edwardeston, weaver 1
5233753 2425460 2425460 defendant Spelyng Henry husbandman 590423 590423 (Spelyng, Henry, of Edwardeston, husbandman 1
5233754 2425460 2425460 defendant Bogeys William husbandman 590423 590423 Bogeys, William, of Edwardeston, husbandman 2
5233756 2425460 2425460 defendant Quyk Henry husbandman 590423 590423 Quyk, Henry, of Edwardeston, husbandman 4
5250425 2430243 2430243 defendant Quyk John husbandman 590423 590423 Quyk, John, of Edwardeston, husbandman 0
5265705 2435026 2435026 defendant Hewat John husbandman 590423 590423 Hewat, John, of Edwardeston, husbandman 0
5265706 2435026 2435026 defendant Lyndholt John husbandman 590423 590423 Lyndholt, John, of Edwardeston, husbandman 1
5320784 2451306 2451306 defendant Prat Thomas husbandman 590423 590423 Prat, Thomas, of Edwardeston, husbandman 2
5512464 2508761 2508761 defendant Fakon Richard husbandman 590423 590423 Fakon, Richard, of Edwardeston, husbandman 3
5514035 2509240 2509240 plaintiff Potter Simon   590423 590423 Potter, Simon, of Edwardeston 0
5517521 2510321 2510321 defendant Arnold Richard carpenter 590423 590423 Arnold, Richard, of Edwardeston, carpenter 3
5517747 2510391 2510391 defendant Doget John clothmaker 590423 590423 Doget, John, of Edwardeston, clothmaker 2
5517990 2510470 2510470 defendant Game Robert husbandman 590423 590423 Game, Robert, of Edwardeston, husbandman 3
5517991 2510470 2510470 defendant Potter Simon husbandman 590423 590423 Potter, Simon, of Edwardeston, husbandman 4
5544253 2518306 2518306 defendant Potter William laborer 590423 590423 Potter, William, of Edwardeston, laborer 4
5552812 2520873 2520873 defendant Daysshe John laborer 590423 590423 Daysshe, John, of Edwardeston, laborer 1
5624278 2551541 2551541 defendant Coo Henry fuller 590423 590423 Coo, Henry, of Edwardeston, fuller 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);