names

38 rows where place_id = 586089

✎ 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
3587903 1863867 1863867 defendant Aysshebery Thomas mariner 586089 586089 Aysshebery, Thomas, of Brixham, mariner 2
3587908 1863868 1863868 defendant Aysshebery Thomas mariner 586089 586089 Aysshebery, Thomas, of Brixham, mariner 2
3587913 1863869 1863869 defendant Aysshebery Thomas mariner 586089 586089 Aysshebery, Thomas, of Brixham, mariner 2
3627544 1903474 1903474 defendant Elwyll John clerk 586089 586089 Elwyll, John, of Brixham, clerk 1
3644795 1908779 1908779 defendant Lake Richard gent 586089 586089 Lake, Richard, of Brixham, gent 0
3673479 1917729 1917729 defendant Lake Richard yeoman 586089 586089 Lake, Richard, of Brixham, yeoman 0
3688083 1922434 1922434 defendant Jeme Robert husbandman 586089 586089 Jeme, Robert, of Brixham, husbandman 1
3695915 1924959 1924959 defendant Turpyn Vincent   586089 586089 Turpyn, Vincent, of Brixham 0
3764121 1946427 1946427 defendant Lake John butcher 586089 586089 Lake, John, of Brixham, butcher 0
3768155 1947677 1947677 defendant Dunstepyll Robert mariner 586089 586089 Dunstepyll, Robert, of Brixham, mariner 1
3786509 1953573 1953573 defendant Bowdon William (legal representative) 586089 586089 Bowdon, William, of Brixham, mariner, executrix of 0
3796920 1956916 1956916 defendant Upton Thomas gent 586089 586089 Upton, Thomas, of Brixham, gent 0
3796921 1956916 1956916 defendant Ley Richard gent 586089 586089 Ley, Richard, of Brixham, gent 1
3796927 1956917 1956917 defendant Key or Ley Richard gent 586089 586089 Key or Ley, Richard, of Brixham, gent 2
3875500 1982048 1982048 defendant Lake John yeoman 586089 586089 Lake, John, of Brixham, yeoman 0
3985408 2019542 2019542 defendant Petteyjohn Richard husbandman 586089 586089 Petteyjohn, Richard, of Brixham, husbandman 0
3999634 2024634 2024634 defendant Upton John, junior gent 586089 586089 Upton, John, junior, of Brixham, gent 1
3999636 2024634 2024634 defendant Prowse John, junior merchant 586089 586089 Prowse, John, junior, of Brixham, merchant 3
4253817 2114272 2114272 defendant Tulie Peter yeoman 586089 586089 Tulie, Peter, of Brixham, yeoman 0
4629495 2240153 2240153 defendant Bubbund Henry   586089 586089 Bubbund, Henry, of Brixham, shoe maker 0
4735634 2276296 2276296 plaintiff Steven John   586089 586089 Steven, John, of Brixham 0
4836006 2307243 2307243 defendant Waryn William merchant 586089 586089 Waryn, William, of Brixham, merchant 0
4838232 2307878 2307878 defendant Lucas Richard shipman 586089 586089 Lucas, Richard, of Brixham, shipman 4
4909328 2329459 2329459 defendant Burgeys Richard husbandman 586089 586089 (Burgeys, Richard, of Brixham, husbandman 4
4909329 2329459 2329459 defendant Marshall William   586089 586089 Marshall, William, of Brixham 5
4948574 2341533 2341533 defendant Cole Richard fisher 586089 586089 Cole, Richard, of Brixham, fisher 4
5060448 2374703 2374703 defendant Reve Thomas merchant 586089 586089 Reve, Thomas, of Brixham, merchant 1
5079821 2380444 2380444 defendant William William merchant 586089 586089 William, William, of Brixham, merchant 1
5132975 2396136 2396136 defendant Jule William   586089 586089 Jule, William, of Brixham 3
5132978 2396136 2396136 defendant Stevyn (illegible) mariner 586089 586089 Stevyn, ---, of Brixham, mariner 6
5132983 2396136 2396136 defendant William John mariner 586089 586089 William, John, of Brixham, mariner 11
5164533 2405359 2405359 defendant Mason John yeoman 586089 586089 Mason, John, of Brixham, yeoman 0
5177811 2409213 2409213 defendant Mason John yeoman 586089 586089 Mason, John, of Brixham, yeoman 0
5201105 2416083 2416083 defendant Mason John yeoman 586089 586089 Mason, John, of Brixham, yeoman 0
5289454 2441917 2441917 defendant Dolbeare Richard   586089 586089 Dolbeare, Richard, of Brixham 0
5507017 2507108 2507108 defendant Bowyte Richard butcher 586089 586089 Bowyte, Richard, of Brixham, butcher 1
5508347 2507484 2507484 defendant Rowe Richard husbandman 586089 586089 Rowe, Richard, of Brixham, husbandman 0
5527638 2513223 2513223 defendant Grygge John   586089 586089 Grygge, John, of Brixham, mason 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);