names

35 rows where place_id = 591271

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3603902 1868893 1868893 defendant Symond Robert merchant 591271 591271 Symond, Robert, of Barstaple, Devon, merchant 0
3665612 1915195 1915195 defendant Thomas John merchant 591271 591271 Thomas, John, of Barstaple, Devon, merchant 0
3665615 1915196 1915196 defendant Thomas John merchant 591271 591271 Thomas, John, of Barstaple, Devon, merchant 0
3950348 2007203 2007203 defendant Parker Edward clothier 591271 591271 Parker, Edward, of Barstaple, Devon, clothier 2
3979487 2017419 2017419 plaintiff Norrys John merchant 591271 591271 Norrys, John, of Barstaple, Devon, servant to Nicholas Wyghehals, merchant 0
4655135 2247487 2247487 defendant Skynner John chaplain 591271 591271 Skynner, John, of Barstaple, Devon, chaplain 8
4688909 2262085 2262085 defendant Mayour John merchant 591271 591271 Mayour, John, of Barstaple, Devon, merchant 3
4744317 2278859 2278859 defendant More John gent 591271 591271 More, John, of Barstaple, Devon, gent 0
4744319 2278860 2278860 defendant More John gent 591271 591271 More, John, of Barstaple, Devon, gent 0
4791017 2293283 2293283 defendant More John gent 591271 591271 More, John, of Barstaple, Devon, gent 0
4795517 2294750 2294750 defendant Dydmay Richard merchant 591271 591271 Dydmay, Richard, of Barstaple, Devon, merchant 4
4867927 2316938 2316938 defendant Hertescote William chapman 591271 591271 Hertescote, William, of Barstaple, Devon, chapman 3
4902957 2327541 2327541 defendant Cole John merchant 591271 591271 Cole, John, of Barstaple, Devon, merchant 0
4932011 2336400 2336400 defendant Hayne Walter husbandman 591271 591271 Hayne, Walter, of Barstaple, Devon, husbandman 2
4948829 2341616 2341616 defendant Furlong John chapman 591271 591271 Furlong, John, of Barstaple, Devon, chapman 0
4970886 2348237 2348237 defendant Tregyll Thomas merchant 591271 591271 Tregyll, Thomas, of Barstaple, Devon, merchant 0
4975493 2349637 2349637 defendant Joce William merchant 591271 591271 Joce, William, of Barstaple, Devon, merchant 3
5004062 2358073 2358073 defendant Upcote William merchant 591271 591271 (Upcote, William, of Barstaple, Devon, merchant 3
5031925 2366209 2366209 defendant Upcote Walter merchant 591271 591271 (Upcote, Walter, of Barstaple, Devon, merchant 1
5059028 2374264 2374264 defendant Holme William dyer 591271 591271 Holme, William, of Barstaple, Devon, dyer 4
5062689 2375398 2375398 defendant Holme William dyer 591271 591271 Holme, William, of Barstaple, Devon, dyer 3
5062694 2375399 2375399 defendant Holme William dyer 591271 591271 Holme, William, of Barstaple, Devon, dyer 2
5083924 2381694 2381694 defendant Touker Nicholas tucker 591271 591271 Touker, Nicholas, of Barstaple, Devon, tucker 2
5097112 2385588 2385588 defendant Neucombe Richard husbandman 591271 591271 Neucombe, Richard, of Barstaple, Devon, husbandman 0
5100671 2386621 2386621 defendant Lidicot William merchant 591271 591271 Lidicot, William, of Barstaple, Devon, merchant 0
5140500 2398326 2398326 defendant Davron Richard merchant 591271 591271 Davron, Richard, of Barstaple, Devon, merchant 0
5304195 2446262 2446262 defendant Brewete Thomas   591271 591271 Brewete, Thomas, of Barstaple, Devon, soap maker 1
5304199 2446263 2446263 defendant Cory Thomas chapman 591271 591271 Cory, Thomas, of Barstaple, Devon, chapman 0
5349120 2459854 2459854 defendant Brayban or Braybone William merchant 591271 591271 Brayban or Braybone, William,of Barstaple, Devon, merchant 3
5365554 2464899 2464899 defendant Bremilcombe Henry yeoman 591271 591271 Bremilcombe, Henry, of Barstaple, Devon, yeoman 3
5514358 2509341 2509341 defendant Alowe Nicholas merchant 591271 591271 Alowe, Nicholas, of Barstaple, Devon, merchant 0
5544896 2518510 2518510 defendant Cruse Amise widow 591271 591271 Cruse, Amise, of Barstaple, Devon, widow 1
5548938 2519728 2519728 defendant Flemmyng Christopher   591271 591271 Flemmyng, Christopher, of Barstaple, Devon, knight, Baron of Slayne 0
5561678 2523402 2523402 defendant Flemmyng Christopher   591271 591271 Flemmyng, Christopher, of Barstaple, Devon, Baron of Slane 0
5565067 2524370 2524370 defendant Symon Robert merchant 591271 591271 Symon, Robert, of Barstaple, Devon, merchant 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);