names

38 rows where place_id = 631017

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3797975 1957265 1957265 defendant Halsewyll John husbandman 631017 631017 Halsewyll, John, of Stokenham, husbandman 0
3822129 1964817 1964817 defendant Westlake John carpenter 631017 631017 Westlake, John, of Stokenham, carpenter 0
3822130 1964817 1964817 defendant Hunt Thomasine widow 631017 631017 Hunt, Thomasine, of Stokenham, widow 1
3822132 1964818 1964818 defendant Westlake John carpenter 631017 631017 Westlake, John, of Stokenham, carpenter 0
3822133 1964818 1964818 defendant Hunt Thomasine widow 631017 631017 Hunt, Thomasine, of Stokenham, widow 1
3930210 2000452 2000452 defendant Rondall Joan spinter 631017 631017 Rondall, Joan, of Stokenham, spinter 0
3940419 2003814 2003814 defendant Pynhaye John clerk 631017 631017 Pynhaye, John, of Stokenham, clerk 0
3940420 2003814 2003814 defendant Colles Nicholas husbandman 631017 631017 Colles, Nicholas, of Stokenham, husbandman 1
4080696 2053405 2053405 defendant jeffrey Peter husbandman 631017 631017 jeffrey, Peter, of Stokenham, husbandman 8
4088123 2056046 2056046 defendant Salter William smith 631017 631017 (Salter, William, of Stokenham, smith 1
4215847 2101041 2101041 defendant Luscombe Philip gent 631017 631017 Luscombe, Philip, of Stokenham, gent 0
4290346 2126602 2126602 defendant Luscombe Philip (legal representative) 631017 631017 Luscombe, Philip, of Stokenham, gent, executor of 0
4290347 2126602 2126602 defendant Luscombe Oliver gent 631017 631017 Luscombe, Oliver, of Stokenham, gent 1
4330688 2140560 2140560 defendant Geffrey Michael   631017 631017 Geffrey, Michael, of Stokenham, sailor 0
4330691 2140561 2140561 defendant Tolchard George glover 631017 631017 Tolchard, George, of Stokenham, glover 0
4391488 2161767 2161767 defendant Gould William yeoman 631017 631017 Gould, William, of Stokenham, yeoman 1
4398905 2164216 2164216 defendant Newman Peter yeoman 631017 631017 (Newman, Peter, of Stokenham, yeoman 1
4399025 2164255 2164255 defendant Saunders John smith 631017 631017 Saunders, John, of Stokenham, smith 1
4399026 2164255 2164255 defendant Forde John smith 631017 631017 Forde, John, of Stokenham, smith 2
4584775 2226664 2226664 defendant Prentys Richard   631017 631017 Prentys, Richard, of Stokenham 0
4645237 2244676 2244676 defendant Smyth William   631017 631017 Smyth, William, of Stokenham 4
4843665 2309542 2309542 defendant Clement Peter clerk 631017 631017 Clement, Peter, of Stokenham, clerk 0
4876408 2319581 2319581 defendant Andrewe Richard husbandman 631017 631017 (Andrewe, Richard, of Stokenham, husbandman 1
5001161 2357217 2357217 defendant Cornysshe John tailor 631017 631017 Cornysshe, John, of Stokenham, tailor 4
5043489 2369675 2369675 defendant Medelond John yeoman 631017 631017 Medelond, John, of Stokenham, yeoman 0
5083761 2381645 2381645 defendant Waryn Walter husbandman 631017 631017 Waryn, Walter, of Stokenham, husbandman 3
5093786 2384581 2384581 defendant Harry John husbandman 631017 631017 Harry, John, of Stokenham, husbandman 0
5241979 2427852 2427852 defendant Brouse John husbandman 631017 631017 Brouse, John, of Stokenham, husbandman 0
5345911 2458853 2458853 defendant Tabbe Michael butcher 631017 631017 Tabbe, Michael, of Stokenham, butcher 0
5351760 2460651 2460651 defendant Shirhill Reginald quarryman 631017 631017 Shirhill, Reginald, of Stokenham, quarryman 0
5351761 2460651 2460651 defendant Roper Thomas quarryman 631017 631017 Roper, Thomas, of Stokenham, quarryman 1
5481576 2499418 2499418 defendant Harlyngton Roger gent 631017 631017 Harlyngton, Roger, of Stokenham, gent 1
5488008 2501304 2501304 defendant Hartlyngton Roger gent 631017 631017 Hartlyngton, Roger, of Stokenham, gent 0
5488009 2501304 2501304 defendant Godeyere John husbandman 631017 631017 Godeyere, John, of Stokenham, husbandman 1
5488010 2501304 2501304 defendant Hunt Robert husbandman 631017 631017 Hunt, Robert, of Stokenham, husbandman 2
5488011 2501304 2501304 defendant Pope John husbandman 631017 631017 Pope, John, of Stokenham, husbandman 3
5554287 2521292 2521292 defendant Beke Nicholas yeoman 631017 631017 Beke, Nicholas, of Stokenham, yeoman 1
5558010 2522300 2522300 defendant Bryant Thomas   631017 631017 Bryant, Thomas, of Stokenham, parson of South Pole 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);