names

18 rows where place_id = 629733

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3790076 1954713 1954713 defendant Loveryng Geoffrey husbandman 629733 629733 Loveryng, Geoffrey, of South Petherton, Soms, husbandman 0
3790079 1954714 1954714 defendant Loveryng Geoffrey husbandman 629733 629733 Loveryng, Geoffrey, of South Petherton, Soms, husbandman 0
3857436 1975960 1975960 defendant Sym John husbandman 629733 629733 Sym, John, of South Petherton, Soms, husbandman 2
3868604 1979738 1979738 defendant Michell Elizabeth widow 629733 629733 Michell, Elizabeth, of South Petherton, Soms, widow 1
3940788 2003925 2003925 defendant Wescott Michael husbandman 629733 629733 (Wescott, Michael, of South Petherton, Soms, husbandman 1
3974478 2015650 2015650 defendant Sand Francis yeoman 629733 629733 Sand, Francis, of South Petherton, Soms, yeoman 0
3980789 2017892 2017892 defendant Rapse John smith 629733 629733 Rapse, John, of South Petherton, Soms, smith 0
4109942 2063812 2063812 defendant Baker John husbandman 629733 629733 Baker, John, of South Petherton, Soms, husbandman 0
4111986 2064538 2064538 defendant Pratt Thomas yeoman 629733 629733 Pratt, Thomas, of South Petherton, Soms, yeoman 0
4113470 2065093 2065093 defendant Baker John husbandman 629733 629733 Baker, John, of South Petherton, Soms, husbandman 0
4117554 2066574 2066574 defendant Deane Francis chapman 629733 629733 Deane, Francis, of South Petherton, Soms, chapman 1
4121109 2067842 2067842 defendant Jones John chapman 629733 629733 Jones, John, of South Petherton, Soms, chapman 0
4123671 2068769 2068769 defendant Baker John, senior husbandman 629733 629733 Baker, John, senior, of South Petherton, Soms, husbandman 0
4125777 2069501 2069501 defendant Anstys or Austys Thomas, junior brasier 629733 629733 Anstys or Austys, Thomas, junior, of South Petherton, Soms, brasier 0
4162863 2082542 2082542 defendant Newton Christopher gent 629733 629733 Newton, Christopher, of South Petherton, Soms, gent 49
4203967 2096940 2096940 defendant Jones John draper 629733 629733 Jones, John, of South Petherton, Soms, draper 0
4246239 2111720 2111720 defendant Porker John husbandman 629733 629733 Porker, John, of South Petherton, Soms, husbandman 0
4928014 2335195 2335195 defendant Solanste or Solauste Henry   629733 629733 Solanste or Solauste, Henry, of South Petherton, Soms, fysshe ioweter or fish-hawker 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);