names

46 rows where place_id = 600515

✎ 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
3641323 1907738 1907738 defendant Palle John husbandman 600515 600515 Palle, John, of Polruan, husbandman 0
3641324 1907738 1907738 defendant Lawrens Richard husbandman 600515 600515 Lawrens, Richard, of Polruan, husbandman 1
3646039 1909159 1909159 defendant Walshe Thomas mariner 600515 600515 Walshe, Thomas, of Polruan, mariner 1
3780193 1951530 1951530 plaintiff Frye William, senior merchant 600515 600515 Frye, William, senior, of Polruan, merchant 0
3869687 1980104 1980104 plaintiff Waymond Edward merchant 600515 600515 Waymond, Edward, of Polruan, merchant 0
3869722 1980112 1980112 defendant Frye William merchant 600515 600515 Frye, William, of Polruan, merchant 0
3869994 1980207 1980207 defendant Frye William merchant 600515 600515 Frye, William, of Polruan, merchant 0
3887113 1985954 1985954 defendant Veysey Richard mariner 600515 600515 Veysey, Richard, of Polruan, mariner 0
3891133 1987301 1987301 defendant Pall John fisher 600515 600515 Pall, John, of Polruan, fisher 0
3921955 1997686 1997686 defendant Leve John mariner 600515 600515 Leve, John, of Polruan, mariner 0
3925812 1998951 1998951 plaintiff Wymond Edward mariner 600515 600515 Wymond, Edward, of Polruan, mariner 0
4190099 2092041 2092041 defendant Carra William mariner 600515 600515 Carra, William, of Polruan, mariner 0
4190100 2092041 2092041 defendant Carra Elizabeth spinster 600515 600515 Carra, Elizabeth, of Polruan, spinster 1
4190102 2092042 2092042 defendant Carra William mariner 600515 600515 Carra, William, of Polruan, mariner 0
4190103 2092042 2092042 defendant Carra Elizabeth spinster 600515 600515 Carra, Elizabeth, of Polruan, spinster 1
4548243 2215391 2215391 defendant Philip Henry   600515 600515 Philip, Henry, of Polruan 1
4559711 2218991 2218991 defendant Boion William   600515 600515 Boion, William, of Polruan 3
4618628 2236836 2236836 defendant Helyer Robert   600515 600515 Helyer, Robert, of Polruan 1
4669239 2256084 2256084 defendant Hikka Robert shipman 600515 600515 Hikka, Robert, of Polruan, shipman 1
4711344 2268882 2268882 defendant Ode Richard husbandman 600515 600515 Ode, Richard, of Polruan, husbandman 0
4711345 2268882 2268882 defendant Ode Stepehn husbandman 600515 600515 Ode, Stepehn, of Polruan, husbandman 1
4982466 2351673 2351673 defendant Joshep John smith 600515 600515 Joshep, John, of Polruan, smith 3
4992677 2354692 2354692 defendant Hygowe John mariner 600515 600515 Hygowe, John, of Polruan, mariner 0
5002312 2357581 2357581 plaintiff Nicoll John (legal representative) 600515 600515 Nicoll, John, of Polruan, executrix of 0
5025662 2364412 2364412 defendant Gegge Isabel widow 600515 600515 Gegge, Isabel, of Polruan, widow 4
5130075 2395284 2395284 defendant Phylyp John mariner 600515 600515 Phylyp, John, of Polruan, mariner 3
5130076 2395284 2395284 defendant Clerk William weaver 600515 600515 Clerk, William, of Polruan, weaver 4
5149371 2400950 2400950 defendant Fylyp John mariner 600515 600515 Fylyp, John, of Polruan, mariner 3
5149372 2400950 2400950 defendant Clerk William weaver 600515 600515 Clerk, William, of Polruan, weaver 4
5149378 2400951 2400951 defendant Fylyp John mariner 600515 600515 Fylyp, John, of Polruan, mariner 3
5149379 2400951 2400951 defendant Clerk William weaver 600515 600515 Clerk, William, of Polruan, weaver 4
5168334 2406456 2406456 defendant Phylyp John mariner 600515 600515 Phylyp, John, of Polruan, mariner 2
5168335 2406456 2406456 defendant Clerk William weaver 600515 600515 Clerk, William, of Polruan, weaver 3
5171437 2407370 2407370 defendant Hokkyn Richard merchant 600515 600515 Hokkyn, Richard, of Polruan, merchant 2
5171441 2407371 2407371 defendant Hokkyn Richard merchant 600515 600515 Hokkyn, Richard, of Polruan, merchant 2
5176652 2408857 2408857 defendant William Otto shipman 600515 600515 William, Otto, of Polruan, shipman 1
5176658 2408858 2408858 defendant William Otto shipman 600515 600515 William, Otto, of Polruan, shipman 1
5240896 2427543 2427543 defendant Hopkyn Richard shipman 600515 600515 Hopkyn, Richard, of Polruan, shipman 0
5269960 2436322 2436322 defendant Tounna Walter mariner 600515 600515 Tounna, Walter, of Polruan, mariner 1
5487925 2501278 2501278 defendant A More John mariner 600515 600515 A More, John, of Polruan, mariner 4
5577964 2528180 2528180 defendant Frye William merchant 600515 600515 Frye, William, of Polruan, merchant 0
5577965 2528180 2528180 defendant Gomell John mariner 600515 600515 Gomell, John, of Polruan, mariner 1
5577966 2528180 2528180 defendant Rychard Joan spinster 600515 600515 Rychard, Joan, of Polruan, spinster 2
5623592 2551316 2551316 defendant Fox Walter yeoman 600515 600515 Fox, Walter, of Polruan, yeoman 0
5623594 2551316 2551316 defendant Bogyn John yeoman 600515 600515 Bogyn, John, of Polruan, yeoman 2
5623595 2551316 2551316 defendant Hore John yeoman 600515 600515 Hore, John, of Polruan, yeoman 3

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