names

35 rows where place_id = 688142

✎ 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
4074352 2051130 2051130 plaintiff Pytt Richard merchant 688142 688142 Pytt, Richard, of Waymouth Melcombe Regis, merchant 0
4090718 2056968 2056968 defendant James alias Ledore or Ledos William yeoman 688142 688142 James alias Ledore or Ledos, William, of Waymouth Melcombe Regis, yeoman 0
4105373 2062202 2062202 defendant Samwayes Thomas yeoman 688142 688142 Samwayes, Thomas, of Waymouth Melcombe Regis, yeoman 0
4116442 2066170 2066170 defendant Samwayes Thomas yeoman 688142 688142 Samwayes, Thomas, of Waymouth Melcombe Regis, yeoman 0
4116443 2066170 2066170 defendant Dodrell William yeoman 688142 688142 Dodrell, William, of Waymouth Melcombe Regis, yeoman 1
4116444 2066170 2066170 defendant Collens Edward yeoman 688142 688142 Collens, Edward, of Waymouth Melcombe Regis, yeoman 2
4119345 2067212 2067212 defendant Cowarde William mariner 688142 688142 Cowarde, William, of Waymouth Melcombe Regis, mariner 0
4123179 2068590 2068590 defendant Cleves John yeoman 688142 688142 Cleves, John, of Waymouth Melcombe Regis, yeoman 0
4133524 2072319 2072319 defendant Buckler John gent 688142 688142 Buckler, John, of Waymouth Melcombe Regis, gent 0
4136127 2073265 2073265 defendant Eyer Roger shipmaster 688142 688142 Eyer, Roger, of Waymouth Melcombe Regis, mariner, shipmaster 1
4137676 2073829 2073829 defendant Wade John merchant 688142 688142 Wade, John, of Waymouth Melcombe Regis, merchant 0
4139181 2074379 2074379 defendant Randall Hugh merchant 688142 688142 Randall, Hugh, of Waymouth Melcombe Regis, merchant 0
4142127 2075422 2075422 defendant Randoll Hugh merchant 688142 688142 Randoll, Hugh, of Waymouth Melcombe Regis, merchant 3
4147178 2077151 2077151 defendant Randall William merchant 688142 688142 Randall, William, of Waymouth Melcombe Regis, merchant 2
4157224 2080595 2080595 defendant Wade John merchant 688142 688142 Wade, John, of Waymouth Melcombe Regis, merchant 2
4164481 2083095 2083095 defendant Jorden Richard gent 688142 688142 Jorden, Richard, of Waymouth Melcombe Regis, gent 0
4192844 2093060 2093060 defendant Waltham William merchant 688142 688142 Waltham, William, of Waymouth Melcombe Regis, merchant 0
4192846 2093061 2093061 defendant Waltham William merchant 688142 688142 Waltham, William, of Waymouth Melcombe Regis, merchant 0
4196587 2094353 2094353 defendant Jurdayne Richard gent 688142 688142 Jurdayne, Richard, of Waymouth Melcombe Regis, gent 1
4204485 2097116 2097116 defendant Gregorye Robert merchant 688142 688142 Gregorye, Robert, of Waymouth Melcombe Regis, merchant 0
4207242 2098081 2098081 defendant Ledore alias James William merchant 688142 688142 Ledore alias James, William, of Waymouth Melcombe Regis, merchant 2
4209699 2098945 2098945 defendant Harrys Francis merchant 688142 688142 Harrys, Francis, of Waymouth Melcombe Regis, merchant 0
4223720 2103781 2103781 defendant Holman William merchant 688142 688142 Holman, William, of Waymouth Melcombe Regis, merchant 1
4278131 2122286 2122286 defendant Foster John   688142 688142 Foster, John, of Waymouth Melcombe Regis, sailor 0
4278132 2122286 2122286 defendant Ames edward yeoman 688142 688142 together with Ames, edward, of Waymouth Melcombe Regis, yeoman 1
4303845 2131477 2131477 defendant Muster Hugh tailor 688142 688142 Muster, Hugh, of Waymouth Melcombe Regis, tailor 0
4303846 2131477 2131477 defendant Gilbert Robert   688142 688142 Gilbert, Robert, of Waymouth Melcombe Regis, sailor 1
4315716 2135606 2135606 defendant Jourden Richard gent 688142 688142 Jourden, Richard, of Waymouth Melcombe Regis, gent 0
4325358 2138862 2138862 defendant Hingston John butcher 688142 688142 Hingston, John, of Waymouth Melcombe Regis, butcher 2
4329335 2140122 2140122 defendant Welborne George gent 688142 688142 Welborne, George, of Waymouth Melcombe Regis, or of Athlington, Dorset, gent 0
4332380 2141120 2141120 defendant Johnson William vintner 688142 688142 Johnson William, of Waymouth Melcombe Regis, vintner 0
4334469 2141804 2141804 defendant Skynner Richard merchant 688142 688142 Skynner, Richard, of Waymouth Melcombe Regis, merchant 0
4367834 2153546 2153546 defendant Phippen Robert joiner 688142 688142 Phippen, Robert, of Waymouth Melcombe Regis, joiner 1
4372304 2155158 2155158 defendant Chivers Alexander   688142 688142 Chivers, Alexander, of Waymouth Melcombe Regis, apothecary 0
4403299 2165675 2165675 defendant Welborne William gent 688142 688142 (Welborne, William, of Waymouth Melcombe Regis, gent 1

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);