names

39 rows where place_id = 596537

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3625158 1875404 1875404 plaintiff Weke William   596537 596537 Weke, William, of Magna Totteneys 0
4943910 2340060 2340060 defendant Knap John   596537 596537 Knap, John, of Magna Totteneys, mason 0
4954761 2343378 2343378 defendant Serle Walter husbandman 596537 596537 Serle, Walter, of Magna Totteneys, husbandman 0
4968725 2347616 2347616 defendant Hamelyn Thomas yeoman 596537 596537 Hamelyn, Thomas, of Magna Totteneys, yeoman 0
4968726 2347616 2347616 defendant Hamelyn John butcher 596537 596537 Hamelyn, John, of Magna Totteneys, butcher 1
5019576 2362611 2362611 defendant Welyngton Richard yeoman 596537 596537 Welyngton, Richard, of Magna Totteneys, yeoman 0
5092912 2384311 2384311 defendant Cohn Isabel   596537 596537 Cohn, Isabel, of Magna Totteneys, widow of Cohn, Nicholas 0
5092913 2384311 2384311 defendant Yeonge John clerk 596537 596537 Yeonge, John, of Magna Totteneys, clerk 1
5092914 2384311 2384311 defendant Coleton William husbandman 596537 596537 Coleton, William, of Magna Totteneys, husbandman 2
5092915 2384311 2384311 defendant Robyn Henry husbandman 596537 596537 Robyn, Henry, of Magna Totteneys, husbandman 3
5116987 2391394 2391394 defendant Hert William mercer 596537 596537 together with Hert, William, of Magna Totteneys, mercer 1
5116988 2391394 2391394 defendant Hamelyn John butcher 596537 596537 Hamelyn, John, of Magna Totteneys, butcher 2
5116989 2391394 2391394 defendant Coleton John mercer 596537 596537 Coleton, John, of Magna Totteneys, mercer 3
5214214 2419888 2419888 defendant Apeer John merchant 596537 596537 Apeer, John, of Magna Totteneys, or of Isle of Garnesey, Hants, merchant 0
5228882 2424054 2424054 defendant Davy William yeoman 596537 596537 Davy, William, of Magna Totteneys, yeoman 0
5229516 2424245 2424245 defendant William Robert   596537 596537 (William, Robert, of Magna Totteneys, "helyer" 3
5230847 2424630 2424630 defendant Bastard Joan widow 596537 596537 Bastard, Joan, of Magna Totteneys, widow 1
5230848 2424630 2424630 defendant Anteron Walter sherman 596537 596537 Anteron, Walter, of Magna Totteneys, sherman 2
5230849 2424630 2424630 defendant Cowyke John weaver 596537 596537 Cowyke, John, of Magna Totteneys, weaver 3
5230850 2424630 2424630 defendant Foyys Barholomew smith 596537 596537 Foyys, Barholomew, of Magna Totteneys, smith 4
5231898 2424903 2424903 defendant Wody Andrew brewer 596537 596537 Wody, Andrew, of Magna Totteneys, brewer 0
5231899 2424903 2424903 defendant Dert John smith 596537 596537 Dert, John, of Magna Totteneys, smith 1
5231900 2424903 2424903 defendant Lucas John laborer 596537 596537 Lucas, John, of Magna Totteneys, laborer 2
5231901 2424903 2424903 defendant Rouse Richard laborer 596537 596537 Rouse, Richard, of Magna Totteneys, laborer 3
5252881 2431014 2431014 defendant Rawe William gent 596537 596537 Rawe, William, of Magna Totteneys, gent 0
5256156 2432049 2432049 defendant Boughton Robert gent 596537 596537 Boughton, Robert, of Magna Totteneys, gent 0
5260117 2433287 2433287 defendant Worthy John gent 596537 596537 Worthy, John, of Magna Totteneys, gent 0
5261457 2433694 2433694 defendant Pyttys Robert gent 596537 596537 Pyttys, Robert, of Magna Totteneys, gent 1
5282196 2439858 2439858 defendant Swete John tailor 596537 596537 Swete, John, of Magna Totteneys, tailor 0
5282197 2439858 2439858 defendant Lambert John skinner 596537 596537 Lambert, John, of Magna Totteneys, skinner 1
5289343 2441884 2441884 defendant Helyer Robert   596537 596537 Helyer, Robert, of Magna Totteneys, "helyer" 0
5289345 2441885 2441885 defendant Helyer Robert   596537 596537 Helyer, Robert, of Magna Totteneys, "helyer" 0
5332596 2454816 2454816 defendant Pulsford John merchant 596537 596537 Pulsford, John, of Magna Totteneys, merchant 1
5332598 2454816 2454816 defendant Danyell David baker 596537 596537 Danyell, David, of Magna Totteneys, baker 3
5347611 2459408 2459408 defendant Colyngton William, junior husbandman 596537 596537 Colyngton, William, junior, of Magna Totteneys, husbandman 0
5347612 2459408 2459408 defendant Belleworthy William husbandman 596537 596537 Belleworthy, William, of Magna Totteneys, husbandman 1
5347613 2459408 2459408 defendant William William yeoman 596537 596537 William, William, of Magna Totteneys, yeoman 2
5507337 2507189 2507189 defendant Kyng John weaver 596537 596537 Kyng, John, of Magna Totteneys, weaver 0
5587670 2531159 2531159 defendant Hokemore William gent 596537 596537 Hokemore, William, of Magna Totteneys, 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);