names

32 rows where place_id = 665848

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3978640 2017107 2017107 defendant Rawlyns William tanner 665848 665848 Rawlyns, William, of Westburye, tanner 0
3988998 2020806 2020806 plaintiff Awyntell Richard   665848 665848 Awyntell, Richard, of Westburye 0
3988999 2020806 2020806 plaintiff Brether John   665848 665848 Brether, John, of Westburye 1
3989001 2020807 2020807 plaintiff Awyntell Richard   665848 665848 Awyntell, Richard, of Westburye 0
4013303 2029492 2029492 plaintiff Rodney George esq 665848 665848 Rodney, George, of Westburye, esq 0
4015177 2030120 2030120 defendant Ishure George husbandman 665848 665848 Ishure, George, of Westburye, husbandman 0
4015178 2030120 2030120 defendant Wallis Mathew draper 665848 665848 Wallis, Mathew, of Westburye, or of Salisbury, draper 1
4022796 2032876 2032876 plaintiff Brether John   665848 665848 Brether, John, of Westburye 1
4089486 2056527 2056527 defendant Weaver William yeoman 665848 665848 Weaver, William, of Westburye, yeoman 1
4092175 2057500 2057500 defendant Sharde or Shorte John smith 665848 665848 Sharde or Shorte, John, of Westburye, smith 0
4095054 2058558 2058558 defendant Adlam George yeoman 665848 665848 Adlam, George, of Westburye, yeoman 1
4102451 2061175 2061175 defendant Iston John clerk 665848 665848 Iston, John, of Westburye, clerk 0
4102507 2061194 2061194 defendant Iston John clerk 665848 665848 Iston, John, of Westburye, clerk 0
4102509 2061195 2061195 defendant Iston John clerk 665848 665848 Iston, John, of Westburye, clerk 0
4113938 2065268 2065268 defendant Greene Thomas yeoman 665848 665848 (Greene, Thomas, of Westburye, yeoman 2
4148236 2077514 2077514 defendant Okforde Robert glover 665848 665848 Okforde, Robert, of Westburye, glover 0
4149129 2077821 2077821 defendant Stevens Richard gent 665848 665848 Stevens, Richard, of Westburye, gent 0
4149377 2077908 2077908 defendant Beacher Bartholomew   665848 665848 Beacher, Bartholomew, of Westburye, gent, assign of Thomas Palmer, of Angmerynge, knight 0
4177622 2087649 2087649 defendant Chocke Francis husbandman 665848 665848 Chocke, Francis, of Westburye, husbandman 1
4194415 2093597 2093597 defendant Grenehill Nicholas clerk 665848 665848 Grenehill, Nicholas, of Westburye, clerk 3
4218812 2102078 2102078 defendant Presswell Henry laborer 665848 665848 Presswell, Henry, of Westburye, husbandman, laborer 0
4218829 2102082 2102082 defendant Presswell Henry husbandman 665848 665848 Presswell, Henry, of Westburye, husbandman 0
4225362 2104339 2104339 defendant Bullocke Francis shoemaker 665848 665848 Bullocke, Francis, of Westburye, shoemaker 2
4232977 2107042 2107042 defendant Holsted James yeoman 665848 665848 Holsted, James, of Westburye, yeoman 2
4236207 2108233 2108233 defendant Shalden Nicholas yeoman 665848 665848 Shalden, Nicholas, of Westburye under Plaine, yeoman 1
4305001 2131889 2131889 defendant Heynes Thomas gent 665848 665848 Heynes, Thomas, of Westburye, or of Southemeade, Glos, gent 0
4307279 2132685 2132685 defendant Chocke Francis gent 665848 665848 Chocke, Francis, of Westburye, gent 0
4307280 2132685 2132685 defendant Gould Thomas husbandman 665848 665848 Gould, Thomas, of Westburye, husbandman 1
4307281 2132685 2132685 defendant Hurton Ambrose husbandman 665848 665848 Hurton, Ambrose, of Westburye, husbandman 2
4327193 2139422 2139422 defendant Cleyton Thomas yeoman 665848 665848 Cleyton, Thomas, of Westburye, yeoman 0
4366306 2152989 2152989 defendant Coddington Thomas husbandman 665848 665848 Coddington, Thomas, of Westburye, husbandman 0
4376772 2156761 2156761 defendant Plumley William tailor 665848 665848 Plumley, William, of Westburye, 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);