names

44 rows where place_id = 759694

✎ 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
3616526 1872805 1872805 defendant Thurston Richard (legal representative) 759694 759694 Thurston, Richard, of Brundyssh, husbandman or yeoman, executors of 0
4463542 2189290 2189290 defendant Parker Edmund   759694 759694 Parker, Edmund, of Brundyssh 0
4465591 2189912 2189912 plaintiff Wryghte Nicholas le   759694 759694 Wryghte, Nicholas le, of Brundyssh 0
4617266 2236412 2236412 defendant Pottere John   759694 759694 Pottere, John, of Brundyssh 1
4840476 2308559 2308559 defendant Wylby William clerk 759694 759694 Wylby, William, of Brundyssh, clerk 0
4853921 2312638 2312638 plaintiff Wylughby William master of the chantry 759694 759694 Wylughby, William, of Brundyssh, master of the chantry 0
4865149 2316074 2316074 defendant Davy Robert clerk 759694 759694 Davy, Robert, of Brundyssh, clerk 0
4947479 2341207 2341207 defendant Noyse William butcher 759694 759694 Noyse, William, of Brundyssh, butcher 0
4979869 2350935 2350935 defendant Cullum Robert yeoman 759694 759694 Cullum, Robert, of Brundyssh, yeoman 0
4979870 2350935 2350935 defendant Popy Roger skinner 759694 759694 Popy, Roger, of Brundyssh, skinner 1
5019151 2362490 2362490 defendant Gerlyng John husbandman 759694 759694 Gerlyng, John, of Brundyssh, husbandman 0
5019152 2362490 2362490 defendant Alvard Robert   759694 759694 Alvard, Robert, of Brundyssh, wheelwright 1
5107570 2388644 2388644 defendant Cok Roger husbandman 759694 759694 Cok, Roger, of Brundyssh, husbandman 1
5149307 2400928 2400928 defendant Cok Roger yeoman 759694 759694 Cok, Roger, of Brundyssh, yeoman 0
5162287 2404698 2404698 defendant Collom John yeoman 759694 759694 Collom, John, of Brundyssh, yeoman 0
5162290 2404699 2404699 defendant Collom John yeoman 759694 759694 Collom, John, of Brundyssh, yeoman 0
5168278 2406437 2406437 defendant Cok Roger yeoman 759694 759694 Cok, Roger, of Brundyssh, yeoman 0
5186082 2411680 2411680 defendant Cullum John yeoman 759694 759694 Cullum, John, of Brundyssh, yeoman 1
5198448 2415303 2415303 defendant Collom John yeoman 759694 759694 Collom, John, of Brundyssh, yeoman 0
5219567 2421457 2421457 defendant Cullum John husbandman 759694 759694 Cullum, John, of Brundyssh, husbandman 0
5232806 2425179 2425179 defendant Cullom John yeoman 759694 759694 Cullom, John, of Brundyssh, yeoman 2
5239246 2427066 2427066 defendant Cullum John husbandman 759694 759694 Cullum, John, of Brundyssh, husbandman 0
5239248 2427067 2427067 defendant Cullum John husbandman 759694 759694 Cullum, John, of Brundyssh, husbandman 0
5250939 2430399 2430399 defendant Godbold Roger yeoman 759694 759694 Godbold, Roger, of Brundyssh, yeoman 1
5254346 2431488 2431488 defendant Cullom John   759694 759694 Cullom, John, of Brundyssh 6
5299762 2444899 2444899 defendant Cullom John yeoman 759694 759694 Cullom, John, of Brundyssh, yeoman 2
5300810 2445200 2445200 defendant Cullum John yeoman 759694 759694 Cullum, John, of Brundyssh, yeoman 0
5301403 2445371 2445371 defendant Alnard Robert   759694 759694 Alnard, Robert, of Brundyssh, wheel wright 0
5301405 2445372 2445372 defendant Curklyn Edmund   759694 759694 Curklyn, Edmund, of Brundyssh, wheel wright 0
5314428 2449342 2449342 defendant Cullom John yeoman 759694 759694 Cullom, John, of Brundyssh, yeoman 0
5319836 2451026 2451026 defendant Culham John   759694 759694 Culham, John, of Brundyssh 0
5320570 2451242 2451242 defendant Shepherd Simon weaver 759694 759694 Shepherd, Simon, of Brundyssh, weaver 0
5397473 2474357 2474357 defendant Goodwyn William butcher 759694 759694 Goodwyn, William, of Brundyssh, butcher 14
5424438 2482277 2482277 defendant Alverd Robert yeoman 759694 759694 Alverd, Robert, of Brundyssh, yeoman 0
5424646 2482336 2482336 defendant Goodwyn William butcher 759694 759694 Goodwyn, William, of Brundyssh, butcher 14
5454133 2491133 2491133 defendant Goodwyn William butcher 759694 759694 Goodwyn, William, of Brundyssh, butcher 14
5477617 2498323 2498323 defendant Cullum John, senior yeoman 759694 759694 Cullum, John, senior, of Brundyssh, yeoman 0
5477618 2498323 2498323 defendant Alvard Robert yeoman 759694 759694 Alvard, Robert, of Brundyssh, yeoman 1
5492753 2502748 2502748 defendant Alvard Robert   759694 759694 Alvard, Robert, of Brundyssh, wheelwright 0
5495994 2503694 2503694 defendant Andrew Richard yeoman 759694 759694 Andrew, Richard, of Brundyssh, yeoman 3
5507654 2507297 2507297 defendant Alnard or Alvard Robert   759694 759694 Alnard or Alvard, Robert, of Brundyssh, wheel wright 0
5507656 2507298 2507298 defendant Alvard or Alnard Robert   759694 759694 Alvard or Alnard, Robert, of Brundyssh, wheelwright 0
5511377 2508404 2508404 defendant Smyth Thomas husbandman 759694 759694 Smyth, Thomas, of Brundyssh, husbandman 0
5622293 2550890 2550890 defendant Parker Edmund le   759694 759694 Parker, Edmund le, of Brundyssh 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);