names

22 rows where place_id = 596095

✎ 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
3623111 1874750 1874750 defendant Stephyn Nicholas butcher 596095 596095 Stephyn, Nicholas, of Lamporte, butcher 1
3651782 1910914 1910914 defendant Aphowell John yeoman 596095 596095 Aphowell, John, of Lamporte, yeoman 1
3653132 1911311 1911311 defendant Beld Thomas innholder 596095 596095 Beld, Thomas, of Lamporte Estover, innholder 0
3766321 1947120 1947120 defendant Northe Thomas husbandman 596095 596095 Northe, Thomas, of Lamporte, husbandman 0
3766323 1947121 1947121 defendant Northe Thomas husbandman 596095 596095 Northe, Thomas, of Lamporte, husbandman 0
3787846 1953987 1953987 defendant Hyllesdon John husbandman 596095 596095 Hyllesdon, John, of Lamporte, husbandman 0
3816102 1962936 1962936 defendant Spenser Richard tanner 596095 596095 Spenser, Richard, of Lamporte Estover, tanner 0
3883209 1984645 1984645 defendant Cole John husbandman 596095 596095 Cole, John, of Lamporte, husbandman 2
3978584 2017087 2017087 defendant Gane William innholder 596095 596095 Gane, William, of Lamporte, innholder 0
3978587 2017087 2017087 defendant Rede William tanner 596095 596095 Rede, William, of Lamporte, tanner 3
4123284 2068630 2068630 defendant Moggridge Nicholas hosier 596095 596095 Moggridge, Nicholas, of Lamporte, hosier 0
4129522 2070863 2070863 defendant Gyles John husbandman 596095 596095 Gyles, John, of Lamporte, husbandman 0
4134474 2072661 2072661 defendant Wynterhaye Philip husbandman 596095 596095 Wynterhaye, Philip, of Lamporte, husbandman 0
4143724 2075963 2075963 defendant Cox John clothier 596095 596095 Cox, John, of Lamporte, gent, clothier 0
4164163 2082993 2082993 defendant Walshe Walter tucker 596095 596095 Walshe, Walter, of Lamporte, tucker 1
4355742 2149229 2149229 defendant Lichfeild Richard   596095 596095 Lichfeild, Richard, of Lamporte, shepherd 0
4889334 2323455 2323455 defendant Ande or Aude john   596095 596095 Ande or Aude, john, of Lamporte, "axbrenner" or ash burner 1
4945866 2340691 2340691 defendant Combe Thomas tucker 596095 596095 Combe, Thomas, of Lamporte Estover, tucker 4
5032235 2366307 2366307 defendant Hardyng Robert husbandman 596095 596095 Hardyng, Robert, of Lamporte, husbandman 2
5032241 2366308 2366308 defendant Hardyng Robert husbandman 596095 596095 Hardyng, Robert, of Lamporte, husbandman 2
5364886 2464687 2464687 plaintiff Rye Simon   596095 596095 Rye, Simon, of Lamporte 1
5540644 2517201 2517201 defendant Witcombe John gent 596095 596095 Witcombe, John, of Lamporte Estover, gent 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);