names

14 rows where place_id = 756340

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4436848 2176266 2176266 defendant Taillour John le   756340 756340 Taillour, John le, of Saltmerssh 1
4540988 2213088 2213088 plaintiff Wilkynson Jonson John   756340 756340 Wilkynson Jonson, John, of Saltmerssh 0
4661520 2249434 2249434 defendant Saltmerssh John fisher 756340 756340 Saltmerssh, John, of Saltmerssh, fisher 2
4694578 2263799 2263799 defendant Puddesay John   756340 756340 Puddesay, John, of Saltmerssh, knight 0
4694580 2263800 2263800 defendant Watteson John husbandman 756340 756340 Watteson, John, of Saltmerssh, husbandman 0
4796271 2294980 2294980 defendant Skegge Robert husbandman 756340 756340 Skegge, Robert, of Saltmerssh, husbandman 0
4841110 2308753 2308753 defendant Frende Robert   756340 756340 Frende, Robert, of Saltmerssh, prebendary 0
5147317 2400358 2400358 defendant Rede John husbandman 756340 756340 Rede, John, of Saltmerssh, husbandman 0
5399413 2474907 2474907 defendant Parke Joan widow 756340 756340 (Parke, Joan, of Saltmerssh, widow 1
5412389 2478651 2478651 defendant Paarke Joan widow 756340 756340 (Paarke, Joan, of Saltmerssh, widow 1
5502160 2505601 2505601 defendant Lanty Thomas butcher 756340 756340 Lanty, Thomas, of Saltmerssh, butcher 0
5502162 2505602 2505602 defendant Lanty Thomas butcher 756340 756340 Lanty, Thomas, of Saltmerssh, butcher 0
5542450 2517762 2517762 defendant Gyrlyngton Nicholas gent 756340 756340 Gyrlyngton, Nicholas, of Saltmerssh, gent 0
5542453 2517763 2517763 defendant Gyrlyngton William gent 756340 756340 Gyrlyngton, William, of Saltmerssh, 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);