names

26 rows where place_id = 609748

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3680097 1919842 1919842 defendant Waryn Thomas husbandman 609748 609748 Waryn, Thomas, of Salcombe, husbandman 0
3729795 1935576 1935576 defendant Perot John   609748 609748 Perot, John, of Salcombe, fish driver 0
3740263 1938818 1938818 defendant Pennyng John fisher 609748 609748 Pennyng, John, of Salcombe, fisher 0
3761407 1945579 1945579 defendant Perett John   609748 609748 Perett, John, of Salcombe, fish drover 2
3794495 1956156 1956156 defendant Fayerwether Roger fisherman 609748 609748 Fayerwether, Roger, of Salcombe, fisherman 0
3794496 1956156 1956156 defendant Clowter John fisherman 609748 609748 Clowter, John, of Salcombe, fisherman 1
3822605 1964976 1964976 defendant Bonsestor John mercer 609748 609748 Bonsestor, John, of Salcombe, mercer 0
3822606 1964976 1964976 defendant Cockeworthy Nicholas husbandman 609748 609748 Cockeworthy, Nicholas, of Salcombe, husbandman 1
4036795 2037848 2037848 defendant Whitemore John carpenter 609748 609748 Whitemore, John, of Salcombe, carpenter 0
4103053 2061382 2061382 defendant Listen Roger fisherman 609748 609748 Listen, Roger, of Salcombe, fisherman 1
4162408 2082410 2082410 defendant Bonfester or Bonfasser John gent 609748 609748 Bonfester or Bonfasser, John, of Salcombe, gent 0
4204825 2097230 2097230 defendant Luckham Roger mariner 609748 609748 Luckham, Roger, of Salcombe, mariner 0
4207352 2098124 2098124 defendant Everye Nicholas merchant 609748 609748 Everye, Nicholas, of Salcombe, merchant 0
4207354 2098125 2098125 defendant Everye Nicholas merchant 609748 609748 Everye, Nicholas, of Salcombe, merchant 0
4302594 2131025 2131025 defendant Robbins John husbandman 609748 609748 Robbins, John, of Salcombe, husbandman 0
4302595 2131025 2131025 defendant Courtis Edmund weaver 609748 609748 Courtis, Edmund, of Salcombe, weaver 1
4302602 2131028 2131028 defendant Robbyns John husbandman 609748 609748 Robbyns, John, of Salcombe, husbandman 0
4361240 2151183 2151183 defendant Ball Roger seafaringman 609748 609748 Ball, Roger, of Salcombe, yeoman, seafaringman 0
4377360 2156979 2156979 defendant Swayne John gent 609748 609748 Swayne, John, of Salcombe, gent 0
4406811 2166844 2166844 defendant Warren Mathew yeoman 609748 609748 Warren, Mathew, of Salcombe, yeoman 0
4406813 2166845 2166845 defendant Swayne John gent 609748 609748 Swayne, John, of Salcombe, gent 0
4769485 2286435 2286435 defendant Holewey John husbandman 609748 609748 Holewey, John, of Salcombe, husbandman 0
4948581 2341536 2341536 defendant Mark John fisher 609748 609748 Mark, John, of Salcombe, fisher 0
5416795 2479938 2479938 defendant Cheef William maltman 609748 609748 Cheef, William, of Salcombe, maltman 0
5577818 2528132 2528132 defendant Hayton Richard husbandman 609748 609748 Hayton, Richard, of Salcombe, husbandman 1
5582808 2529695 2529695 defendant Harrys Thomas husbandman 609748 609748 Harrys, Thomas, of Salcombe, husbandman 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);