names

26 rows where place_id = 671822

✎ 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
4003191 2025903 2025903 defendant Manwoode James weaver 671822 671822 Manwoode, James, of Boxstede, weaver 0
4214803 2100682 2100682 defendant Blomfeilde or Blomvile Lucy widow 671822 671822 Blomfeilde or Blomvile, Lucy, of Boxstede, widow 0
4241188 2110041 2110041 defendant Blomfilde or Blomvile Lucy widow 671822 671822 Blomfilde or Blomvile, Lucy, of Boxstede, widow 0
4457156 2187248 2187248 defendant Knyt John smith 671822 671822 Knyt, John, of Boxstede, smith 0
4457159 2187249 2187249 defendant Knyt John smith 671822 671822 Knyt, John, of Boxstede, smith 0
4457162 2187250 2187250 defendant Knyt John smith 671822 671822 Knyt, John, of Boxstede, smith 0
4488774 2197212 2197212 defendant atte Milne Thomas   671822 671822 atte Milne, Thomas, of Boxstede 0
4488776 2197212 2197212 defendant Wynter William   671822 671822 Wynter, William, of Boxstede 2
4488777 2197212 2197212 defendant Peryman (illegible)   671822 671822 Peryman, ----, of Boxstede 3
4488778 2197212 2197212 defendant atte ---- John   671822 671822 atte ----, John, of Boxstede 4
4497464 2199852 2199852 defendant Revere John   671822 671822 Revere, John, of Boxstede 2
4652163 2246614 2246614 defendant Cotull John chaplain 671822 671822 Cotull, John, of Boxstede, chaplain 0
4656368 2247884 2247884 defendant Herde Thomas yeoman 671822 671822 Herde, Thomas, of Boxstede, yeoman 0
4663045 2249907 2249907 defendant Heerde Thomas yeoman 671822 671822 Heerde, Thomas, of Boxstede, yeoman 0
4666997 2255410 2255410 defendant Clobbe Robert husbandman 671822 671822 Clobbe, Robert, of Boxstede, husbandman 0
4680903 2259650 2259650 defendant Whyssh Thomas husbandman 671822 671822 Whyssh, Thomas, of Boxstede, husbandman 0
4707862 2267828 2267828 defendant Miller John miller 671822 671822 Miller, John, of Boxstede, miller 0
4717482 2270803 2270803 defendant Gladman John laborer 671822 671822 Gladman, John, of Boxstede, laborer 0
4763155 2284460 2284460 defendant Badewell John gent 671822 671822 Badewell, John, of Boxstede, gent 0
4894281 2324896 2324896 defendant Badewell Elizabeth widow 671822 671822 Badewell, Elizabeth, of Boxstede, widow 0
4894282 2324896 2324896 defendant Fyrmyn John laborer 671822 671822 Fyrmyn, John, of Boxstede, laborer 1
4906972 2328758 2328758 defendant Badwell Elizabeth widow 671822 671822 Badwell, Elizabeth, of Boxstede, widow 0
4906973 2328758 2328758 defendant Fyrmyn John laborer 671822 671822 Fyrmyn, John, of Boxstede, laborer 1
4988686 2353572 2353572 defendant Ive Miles husbandman 671822 671822 Ive, Miles, of Boxstede, husbandman 0
4988688 2353573 2353573 defendant Obre John, sen husbandman 671822 671822 Obre, John, sen, of Boxstede, husbandman 0
4996064 2355677 2355677 defendant Reygate Simon husbandman 671822 671822 Reygate, Simon, of Boxstede, husbandman 2

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);