names

55 rows where place_id = 773715

✎ 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
4603636 2232322 2232322 defendant Kyng John   773715 773715 Kyng, John, of Halysworth 3
4678122 2258768 2258768 defendant Baxtere Beatrice widow 773715 773715 Baxtere, Beatrice, of Halysworth, widow 2
4723628 2272695 2272695 defendant Dobbys William husbandman 773715 773715 Dobbys, William, of Halysworth, husbandman 0
4758182 2282933 2282933 defendant Gonyld John laborer 773715 773715 Gonyld, John, of Halysworth, laborer 0
4780372 2289858 2289858 defendant Gonyld alias Bentard John laborer 773715 773715 Gonyld alias Bentard, John, of Halysworth, laborer 0
4809101 2299024 2299024 defendant Barkere Thomas yeoman 773715 773715 Barkere, Thomas, of Halysworth, yeoman 2
4827359 2304603 2304603 defendant Reve John chaplain 773715 773715 Reve, John, of Halysworth, chaplain 2
5028694 2365268 2365268 defendant Skut John yeoman 773715 773715 Skut, John, of Halysworth, yeoman 2
5036090 2367408 2367408 defendant Skut John yeoman 773715 773715 Skut, John, of Halysworth, yeoman 0
5036095 2367409 2367409 defendant Skut John yeoman 773715 773715 Skut, John, of Halysworth, yeoman 0
5069306 2377307 2377307 defendant Roo William chandler 773715 773715 Roo, William, of Halysworth, chandler 0
5078719 2380124 2380124 defendant Palmer Thomas weaver 773715 773715 Palmer, Thomas, of Halysworth, weaver 0
5078984 2380197 2380197 defendant Roo Walter husbandman 773715 773715 Roo, Walter, of Halysworth, husbandman 0
5080253 2380583 2380583 defendant Kesewyk John husbandman 773715 773715 Kesewyk, John, of Halysworth, husbandman 0
5080893 2380778 2380778 defendant Lother Richard butcher 773715 773715 Lother, Richard, of Halysworth, butcher 0
5080894 2380778 2380778 defendant Kesewyk John pedder 773715 773715 Kesewyk, John, of Halysworth, pedder 1
5092394 2384153 2384153 defendant Broke Richard yeoman 773715 773715 Broke, Richard, of Halysworth, yeoman 0
5095156 2384998 2384998 defendant Wysk William barker 773715 773715 Wysk, William, of Halysworth, barker 0
5100361 2386546 2386546 defendant Canell or Cavell Henry   773715 773715 Canell or Cavell, Henry, of Halysworth, administrators of 4
5100362 2386546 2386546 defendant Randolf William yeoman 773715 773715 (Randolf, William, of Halysworth, yeoman 5
5100363 2386546 2386546 defendant Canell or Cavell Joan widow 773715 773715 Canell or Cavell, Joan, of Halysworth, widow 6
5109009 2389052 2389052 defendant Randolf Robert yeoman 773715 773715 Randolf, Robert, of Halysworth, yeoman 0
5128384 2394778 2394778 defendant Waytes John yeoman 773715 773715 Waytes, John, of Halysworth, yeoman 0
5128385 2394778 2394778 defendant Spachet John husbandman 773715 773715 Spachet, John, of Halysworth, husbandman 1
5139152 2397944 2397944 defendant Spachet John yeoman 773715 773715 Spachet, John, of Halysworth, yeoman 0
5147473 2400408 2400408 defendant Waytes John yeoman 773715 773715 Waytes, John, of Halysworth, yeoman 0
5147474 2400408 2400408 defendant Spachet John husbandman 773715 773715 Spachet, John, of Halysworth, husbandman 1
5147478 2400409 2400409 defendant Waytes John yeoman 773715 773715 Waytes, John, of Halysworth, yeoman 0
5147479 2400409 2400409 defendant Spachet John husbandman 773715 773715 Spachet, John, of Halysworth, husbandman 1
5148174 2400612 2400612 plaintiff Covele Thomas   773715 773715 Covele, Thomas, of Halysworth 0
5201780 2416286 2416286 defendant Brooke Richard mercer 773715 773715 Brooke, Richard, of Halysworth, mercer 3
5230579 2424557 2424557 defendant Flecher William fletcher 773715 773715 Flecher, William, of Halysworth, fletcher 0
5230580 2424557 2424557 defendant Potter John shoemaker 773715 773715 Potter, John, of Halysworth, shoemaker 1
5246214 2429052 2429052 defendant Lyster William husbandman 773715 773715 Lyster, William, of Halysworth, husbandman 2
5282063 2439827 2439827 defendant Dentard Adam husbandman 773715 773715 Dentard, Adam, of Halysworth, husbandman 1
5286158 2440960 2440960 defendant Broke Richard yeoman 773715 773715 Broke, Richard, of Halysworth, yeoman 0
5301407 2445372 2445372 defendant Auncell John laborer 773715 773715 Auncell, John, of Halysworth, laborer 2
5303422 2446019 2446019 defendant Randolff Robert (legal representative) 773715 773715 Randolff, Robert, of Halysworth, executors of 0
5303423 2446019 2446019 defendant Pyght John yeoman 773715 773715 (Pyght, John, of Halysworth, yeoman 1
5303425 2446019 2446019 defendant Fraunceys W_ yeoman 773715 773715 together with Fraunceys, W_, of Halysworth, yeoman 3
5334845 2455490 2455490 defendant Goodreche Richard, junior husbandman 773715 773715 Goodreche, Richard, junior, of Halysworth, husbandman 2
5340186 2457137 2457137 defendant Randolf Robert (legal representative) 773715 773715 Randolf, Robert, of Halysworth, yeoman, executors of 0
5340187 2457137 2457137 defendant Pygot Joan   773715 773715 (Pygot, Joan, of Halysworth, widow of Randolf, Robert 1
5340188 2457137 2457137 defendant Fraunceys William yeoman 773715 773715 Fraunceys, William, of Halysworth, yeoman 2
5390359 2472305 2472305 defendant Donyaunt William chandler 773715 773715 Donyaunt, William, of Halysworth, chandler 15
5403197 2475997 2475997 defendant Ponyaunt William chandler 773715 773715 Ponyaunt, William, of Halysworth, chandler 11
5408589 2477535 2477535 defendant Warner Henry tailor 773715 773715 Warner, Henry, of Halysworth, tailor 0
5416685 2479908 2479908 defendant Goodrych Richard yeoman 773715 773715 Goodrych, Richard, of Halysworth, yeoman 0
5432969 2484826 2484826 defendant Ponyaunt William chandler 773715 773715 Ponyaunt, William, of Halysworth, chandler 4
5433578 2485005 2485005 defendant Goderich Richard yeoman 773715 773715 Goderich, Richard, of Halysworth, yeoman 0
5433582 2485007 2485007 defendant Goodrich Richard butcher 773715 773715 Goodrich, Richard, of Halysworth, butcher 0
5539098 2516711 2516711 plaintiff Fyn William clerk 773715 773715 Fyn, William, of Halysworth, clerk 0
5539099 2516711 2516711 defendant Franceys Robert yeoman 773715 773715 Franceys, Robert, of Halysworth, yeoman 0
5539100 2516712 2516712 plaintiff Fyn William clerk 773715 773715 Fyn, William, of Halysworth, clerk 0
5539101 2516712 2516712 defendant Fraunceys Robert yeoman 773715 773715 Fraunceys, Robert, of Halysworth, yeoman 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);