names

73 rows where place_id = 771482

✎ 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
4578695 2224826 2224826 defendant Crese Richard   771482 771482 Crese, Richard, of Plympton Earls 0
4806628 2298282 2298282 defendant Silverlok John baker 771482 771482 Silverlok, John, of Plympton Earls, baker 1
4806629 2298282 2298282 defendant Rowe Gregory merchant 771482 771482 Rowe, Gregory, of Plympton Earls, merchant 2
4806632 2298283 2298283 defendant Taillour Richard helyer 771482 771482 Taillour, Richard, of Plympton Earls, helyer 0
4833333 2306435 2306435 defendant Selman Walter merchant 771482 771482 Selman, Walter, of Plympton Earls, merchant 0
4834553 2306815 2306815 defendant Tayllour Richard haulier 771482 771482 Tayllour, Richard, of Plympton Earls, haulier 0
4848279 2310933 2310933 defendant Saleys Robert chaplain 771482 771482 Saleys, Robert, of Plympton Earls, chaplain 0
4853473 2312495 2312495 defendant More Robert sheerman 771482 771482 More, Robert, of Plympton Earls, sheerman 0
4917637 2332031 2332031 defendant Dyker Thomas yeoman 771482 771482 Dyker, Thomas, of Plympton Earls, yeoman 0
4927951 2335173 2335173 defendant Wollecombe Baldwin husbandman 771482 771482 Wollecombe, Baldwin, of Plympton Earls, husbandman 0
4928612 2335378 2335378 plaintiff Snelle John (legal representative) 771482 771482 Snelle, John, of Plympton Earls, executrix of 0
4928614 2335378 2335378 defendant Porde Baldwin barber 771482 771482 Porde, Baldwin, of Plympton Earls, barber 0
4930429 2335916 2335916 defendant Marleburgh David yeoman 771482 771482 Marleburgh, David, of Plympton Earls, yeoman 3
4931017 2336096 2336096 defendant Brendon William tanner 771482 771482 Brendon, William, of Plympton Earls, tanner 1
4990737 2354138 2354138 defendant Yeme Peter carpenter 771482 771482 Yeme, Peter, of Plympton Earls, carpenter 0
4990745 2354139 2354139 defendant Yeme Peter carpenter 771482 771482 Yeme, Peter, of Plympton Earls, carpenter 0
4997067 2355976 2355976 defendant Comyng John haulier 771482 771482 Comyng, John, of Plympton Earls, haulier 0
4997070 2355976 2355976 defendant Wyse Robert yeoman 771482 771482 together with Wyse, Robert, of Plympton Earls, yeoman 3
4997072 2355977 2355977 defendant Comyng John haulier 771482 771482 Comyng, John, of Plympton Earls, haulier 0
4997075 2355977 2355977 defendant Wyse Robert yeoman 771482 771482 together with Wyse, Robert, of Plympton Earls, yeoman 3
5001160 2357217 2357217 defendant Yeme Peter yeoman 771482 771482 Yeme, Peter, of Plympton Earls, yeoman 3
5003492 2357917 2357917 defendant Yeme Peter carpenter 771482 771482 Yeme, Peter, of Plympton Earls, carpenter 0
5004137 2358099 2358099 defendant Yeme Peter husbandman 771482 771482 Yeme, Peter, of Plympton Earls, husbandman 0
5127935 2394648 2394648 defendant Steynlake John husbandman 771482 771482 with Steynlake, John, of Plympton Earls, husbandman 3
5127938 2394649 2394649 defendant Steynlake John husbandman 771482 771482 Steynlake, John, of Plympton Earls, husbandman 0
5129174 2395022 2395022 defendant Tyle Thomas tailor 771482 771482 Tyle, Thomas, of Plympton Earls, tailor 0
5137413 2397455 2397455 defendant Raynold alias Rovell Thomas yeoman 771482 771482 Raynold alias Rovell, Thomas, of Plympton Earls, yeoman 0
5137872 2397591 2397591 defendant Trewathe Martin yeoman 771482 771482 Trewathe, Martin, of Plympton Earls, yeoman 0
5137873 2397591 2397591 defendant Herward John   771482 771482 Herward, John, of Plympton Earls, shoe maker 1
5142310 2398870 2398870 defendant Mylward John baker 771482 771482 Mylward, John, of Plympton Earls, baker 4
5148379 2400663 2400663 defendant Tyle Thomas tailor 771482 771482 Tyle, Thomas, of Plympton Earls, tailor 0
5148380 2400663 2400663 defendant Tyle Richard tailor 771482 771482 Tyle, Richard, of Plympton Earls, tailor 1
5155238 2402680 2402680 defendant Bonde Ivan baker 771482 771482 Bonde, Ivan, of Plympton Earls, baker 2
5157392 2403298 2403298 defendant Milward John baker 771482 771482 Milward, John, of Plympton Earls, baker 0
5158052 2403478 2403478 defendant Raynold Thomas yeoman 771482 771482 Raynold, Thomas, of Plympton Earls, yeoman 0
5166207 2405841 2405841 defendant Wegge John butcher 771482 771482 Wegge, John, of Plympton Earls, butcher 0
5168339 2406457 2406457 defendant Worsford Nicholas baker 771482 771482 together with Worsford, Nicholas, of Plympton Earls, baker 1
5168340 2406457 2406457 defendant Cornysshe William baker 771482 771482 Cornysshe, William, of Plympton Earls, baker 2
5178426 2409398 2409398 defendant Wyllyam John laborer 771482 771482 Wyllyam, John, of Plympton Earls, laborer 2
5193883 2413935 2413935 defendant Raynold Thomas yeoman 771482 771482 Raynold, Thomas, of Plympton Earls, yeoman 0
5195781 2414514 2414514 defendant Poneflet John yeoman 771482 771482 Poneflet, John, of Plympton Earls, yeoman 0
5195782 2414514 2414514 defendant John Thomas tailor 771482 771482 John, Thomas, of Plympton Earls, tailor 1
5200206 2415818 2415818 defendant Davy John fuller 771482 771482 Davy, John, of Plympton Earls, fuller 3
5208438 2418194 2418194 defendant Rayhold Thomas yeoman 771482 771482 Rayhold, Thomas, of Plympton Earls, yeoman 0
5210805 2418892 2418892 defendant Serle John gent 771482 771482 Serle, John, of Plympton Earls, gent 0
5210976 2418942 2418942 defendant Nunnecote Thomas carpenter 771482 771482 Nunnecote, Thomas, of Plympton Earls, carpenter 0
5211392 2419065 2419065 defendant Davy John fuller 771482 771482 Davy, John, of Plympton Earls, fuller 3
5234657 2425725 2425725 defendant Tyly Thomas tailor 771482 771482 Tyly, Thomas, of Plympton Earls, tailor 2
5239097 2427027 2427027 defendant Hoigge John   771482 771482 Hoigge, John, of Plympton Earls yeoman 0
5272367 2436988 2436988 defendant Chalons Thomas gent 771482 771482 Chalons, Thomas, of Plympton Earls, gent 0
5272368 2436988 2436988 defendant Chalons William gent 771482 771482 Chalons, William, of Plympton Earls, gent 1
5272371 2436988 2436988 defendant Symondes (illegible) yeoman 771482 771482 Symondes, ---, of Plympton Earls, yeoman 4
5302366 2445677 2445677 defendant Weryng John, sen husbandman 771482 771482 Weryng, John, sen, of Plympton Earls, husbandman 0
5302367 2445677 2445677 defendant Chalons William gent 771482 771482 Chalons, William, of Plympton Earls, gent 1
5375423 2467901 2467901 defendant Mayde Andrew husbandman 771482 771482 Mayde, Andrew, of Plympton Earls, husbandman 0
5375424 2467901 2467901 defendant Baudyn William husbandman 771482 771482 Baudyn, William, of Plympton Earls, husbandman 1
5375427 2467901 2467901 defendant Mayowe Walter husbandman 771482 771482 Mayowe, Walter, of Plympton Earls, husbandman 4
5411743 2478464 2478464 defendant Sole William yeoman 771482 771482 Sole, William, of Plympton Earls, yeoman 1
5426191 2482787 2482787 defendant Parker John yeoman 771482 771482 Parker, John, of Plympton Earls, yeoman 0
5426192 2482787 2482787 defendant Selman William yeoman 771482 771482 Selman, William, of Plympton Earls, yeoman 1
5426194 2482788 2482788 defendant Parker John yeoman 771482 771482 Parker, John, of Plympton Earls, yeoman 0
5426195 2482788 2482788 defendant Selman William yeoman 771482 771482 Selman, William, of Plympton Earls, yeoman 1
5444408 2488231 2488231 defendant Selman William yeoman 771482 771482 Selman, William, of Plympton Earls, yeoman 0
5444409 2488231 2488231 defendant Parker John yeoman 771482 771482 Parker, John, of Plympton Earls, yeoman 1
5448523 2489455 2489455 defendant Hogg John, junior   771482 771482 Hogg, John, junior, of Plympton Earls 0
5450405 2490009 2490009 defendant Wely Thomas tailor 771482 771482 Wely, Thomas, of Plympton Earls, tailor 0
5457111 2492025 2492025 defendant Parker John yeoman 771482 771482 Parker, John, of Plympton Earls, yeoman 0
5459954 2492907 2492907 defendant Clynch Richard merchant 771482 771482 Clynch, Richard, of Plympton Earls, merchant 0
5462566 2493715 2493715 defendant Wely Thomas tailor 771482 771482 Wely, Thomas, of Plympton Earls, tailor 0
5462568 2493716 2493716 defendant Wely Thomas tailor 771482 771482 Wely, Thomas, of Plympton Earls, tailor 0
5471566 2496442 2496442 defendant Clynch Richard merchant 771482 771482 Clynch, Richard, of Plympton Earls, merchant 0
5471604 2496455 2496455 defendant Clynch Richard merchant 771482 771482 Clynch, Richard, of Plympton Earls, merchant 0
5474101 2497233 2497233 defendant Wely Thomas tailor 771482 771482 Wely, Thomas, of Plympton Earls, tailor 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);