names

36 rows where place_id = 598750

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3633908 1905415 1905415 defendant Pychen Joan widow 598750 598750 Pychen, Joan, of Wylden, widow 1
3823752 1965326 1965326 defendant Russhe Richard husbandman 598750 598750 Russhe, Richard, of Wylden, husbandman 0
3823753 1965326 1965326 defendant Suttell Robert   598750 598750 Suttell, Robert, of Wylden, shepherd 1
3876799 1982482 1982482 defendant Russhe Christopher husbandman 598750 598750 Russhe, Christopher, of Wylden, husbandman 0
3876800 1982482 1982482 defendant Russhe William husbandman 598750 598750 Russhe, William, of Wylden, husbandman 1
3878663 1983112 1983112 defendant Hardyng Thomas yeoman 598750 598750 Hardyng, Thomas, of Wylden, yeoman 0
4342466 2144637 2144637 defendant Smyth Richard, junior husbandman 598750 598750 Smyth, Richard, junior, of Wylden, husbandman 1
4342467 2144637 2144637 defendant Warde Edmund husbandman 598750 598750 Warde, Edmund, of Wylden, husbandman 2
4347964 2146539 2146539 defendant Kyng Thomas laborer 598750 598750 Kyng, Thomas, of Wylden, laborer 1
4571687 2222723 2222723 plaintiff Amy John   598750 598750 Amy, John, of Wylden, parson 0
4713891 2269669 2269669 defendant Fynche William   598750 598750 Fynche, William, of Wylden 0
4758251 2282955 2282955 defendant Bene Henry husbandman 598750 598750 Bene, Henry, of Wylden, husbandman 1
4771964 2287204 2287204 plaintiff Smyth John   598750 598750 Smyth, John, of Wylden 0
4802181 2296873 2296873 defendant Pestell Thomas husbandman 598750 598750 Pestell, Thomas, of Wylden, husbandman 1
4867096 2316672 2316672 defendant Mors John husbandman 598750 598750 Mors, John, of Wylden, husbandman 0
4868654 2317170 2317170 plaintiff Joykyn William husbandman 598750 598750 Joykyn, William, of Wylden, husbandman 0
4942812 2339722 2339722 defendant Smyth John, junior husbandman 598750 598750 Smyth, John, junior, of Wylden, husbandman 0
4979291 2350765 2350765 plaintiff Sere Margery   598750 598750 Sere, Margery, of Wylden 0
5083669 2381616 2381616 defendant Smyth John husbandman 598750 598750 Smyth, John, of Wylden, husbandman 9
5111364 2389716 2389716 defendant Burre Thomas husbandman 598750 598750 Burre, Thomas, of Wylden, husbandman 0
5111365 2389716 2389716 defendant Burre Henry husbandman 598750 598750 Burre, Henry, of Wylden, husbandman 1
5111366 2389716 2389716 defendant Burre Richard laborer 598750 598750 Burre, Richard, of Wylden, laborer 2
5186432 2411787 2411787 defendant Banns or Bauns Thomas smith 598750 598750 Banns or Bauns, Thomas, of Wylden, smith 0
5205185 2417277 2417277 defendant Bauns or Banns Thomas smith 598750 598750 Bauns or Banns, Thomas, of Wylden, smith 0
5230631 2424571 2424571 plaintiff Basyn Stephen   598750 598750 Basyn, Stephen, of Wylden 0
5248108 2429581 2429581 defendant Joykyn William laborer 598750 598750 Joykyn, William, of Wylden, laborer 0
5268697 2435960 2435960 defendant Cole Thomas yeoman 598750 598750 Cole, Thomas, of Wylden, yeoman 3
5284521 2440484 2440484 defendant Tayllour Richard husbandman 598750 598750 Tayllour, Richard, of Wylden, husbandman 1
5284522 2440484 2440484 defendant Fote Robert husbandman 598750 598750 Fote, Robert, of Wylden, husbandman 2
5492917 2502790 2502790 defendant Kyng John husbandman 598750 598750 Kyng, John, of Wylden, husbandman 3
5497276 2504125 2504125 defendant Aleyn John husbandman 598750 598750 Aleyn, John, of Wylden, husbandman 0
5497277 2504125 2504125 defendant Gaugue John husbandman 598750 598750 Gaugue, John, of Wylden, husbandman 1
5497279 2504126 2504126 defendant Aleyn John husbandman 598750 598750 Aleyn, John, of Wylden, husbandman 0
5497280 2504126 2504126 defendant Langno John husbandman 598750 598750 Langno, John, of Wylden, husbandman 1
5571449 2526203 2526203 defendant Hardyng Thomas husbandman 598750 598750 Hardyng, Thomas, of Wylden, husbandman 1
5571450 2526203 2526203 defendant Hardyng Gilbert husbandman 598750 598750 Hardyng, Gilbert, of Wylden, 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);