names

41 rows where place_id = 756561

✎ 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
4438771 2181419 2181419 defendant Bysshop Richard   756561 756561 Bysshop, Richard, of Partenay 0
4477689 2193689 2193689 plaintiff Brune John de clerk 756561 756561 Brune, John de, of Partenay, clerk 4
4566990 2221235 2221235 defendant Holand Richard   756561 756561 Holand, Richard, of Partenay 4
4634284 2241565 2241565 defendant Chaloner Richard butcher 756561 756561 Chaloner, Richard, of Partenay, butcher 0
4634652 2241683 2241683 defendant atte Hall John   756561 756561 atte Hall, John, of Partenay 1
4648746 2245693 2245693 defendant Tut Thomas   756561 756561 Tut, Thomas, of Partenay 0
4682529 2260160 2260160 defendant Holand Richard   756561 756561 Holand, Richard, of Partenay, bailiff 0
4682549 2260163 2260163 defendant Otteware Henry husbandman 756561 756561 Otteware, Henry, of partenay, husbandman 0
4682550 2260163 2260163 defendant Castell John husbandman 756561 756561 Castell, John, of Partenay, husbandman 1
4750709 2280693 2280693 defendant Holand Richard   756561 756561 Holand, Richard, of Partenay, bailiff 2
4750720 2280696 2280696 defendant Turnour Thomas husbandman 756561 756561 Turnour, Thomas, of Partenay, husbandman 0
4766441 2285496 2285496 defendant Thorp Robert de   756561 756561 Thorp, Robert de, of Partenay, shoe maker 1
4815005 2300804 2300804 plaintiff Knotte Thomas   756561 756561 Knotte, Thomas, of Partenay, parson 0
4815644 2300998 2300998 defendant Daude or Dande John husbandman 756561 756561 Daude or Dande, John, of Partenay, husbandman 0
4821872 2302916 2302916 plaintiff Saunderson John   756561 756561 Saunderson, John, of Partenay 0
4845555 2310118 2310118 defendant Dandy John husbandman 756561 756561 Dandy, John, of Partenay, husbandman 1
4863235 2315476 2315476 defendant Dandy John husbandman 756561 756561 Dandy, John, of Partenay, husbandman 2
4935251 2337427 2337427 defendant Flesshewer Hugh flesshewer or buthcer 756561 756561 Flesshewer, Hugh, of Partenay, flesshewer or buthcer 2
4980810 2351191 2351191 defendant Burgh Simon husbandman 756561 756561 Burgh, Simon, of Partenay, husbandman 0
4986957 2353041 2353041 defendant Dandy John yeoman 756561 756561 Dandy, John, of Partenay, yeoman 0
4987130 2353100 2353100 defendant Dandy John husbandman 756561 756561 Dandy, John, of Partenay, husbandman 0
5004863 2358321 2358321 plaintiff Dandy John   756561 756561 Dandy, John, of Partenay 1
5004864 2358321 2358321 defendant Comberton John tailor 756561 756561 Comberton, John, of Partenay, tailor 0
5009939 2359780 2359780 defendant Borell William merchant 756561 756561 Borell, William, of Partenay, merchant 0
5010425 2359919 2359919 defendant Borell William merchant 756561 756561 Borell, William, of Partenay, merchant 0
5012161 2360404 2360404 defendant Comberton John tailor 756561 756561 Comberton, John, of Partenay, tailor 0
5048018 2371027 2371027 defendant Danby John yeoman 756561 756561 Danby, John, of Partenay, yeoman 2
5096948 2385538 2385538 defendant Goldyng Ralph weaver 756561 756561 Goldyng, Ralph, of Partenay, weaver 1
5115817 2391051 2391051 defendant Pormard William yeoman 756561 756561 Pormard, William, of Partenay, yeoman 0
5117938 2391673 2391673 defendant Pormard William yeoman 756561 756561 Pormard, William, of Partenay, yeoman 0
5117939 2391673 2391673 defendant Dandy or Daudy John yeoman 756561 756561 Dandy or Daudy, John, of Partenay, yeoman 1
5129451 2395099 2395099 defendant Grene William husbandman 756561 756561 Grene, William, of Partenay, husbandman 1
5164175 2405261 2405261 defendant Lune Stephen butcher 756561 756561 Lune, Stephen, of Partenay, butcher 0
5199058 2415475 2415475 defendant Dandy John husbandman 756561 756561 Dandy, John, of Partenay, husbandman 0
5200618 2415938 2415938 defendant Lune Stephen butcher 756561 756561 Lune, Stephen, of Partenay, butcher 0
5216173 2420462 2420462 defendant Barker William (legal representative) 756561 756561 Barker, William,of Partenay, butcher, executor of 0
5216174 2420462 2420462 defendant Barbour John husbandman 756561 756561 Barbour, John, of Partenay, husbandman 1
5240868 2427534 2427534 defendant Barbour John husbandman 756561 756561 Barbour, John, of Partenay, husbandman 3
5289237 2441856 2441856 defendant Cumberton Thomas tailor 756561 756561 Cumberton, Thomas, of Partenay, tailor 0
5289238 2441856 2441856 defendant Brigge William butcher 756561 756561 Brigge, William, of Partenay, butcher 1
5627897 2552695 2552695 defendant de Lune Stephen husbandman 756561 756561 de Lune, Stephen, of Partenay, husbandman 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);