names

8 rows where place_id = 797197

✎ 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
4754899 2281912 2281912 defendant Pars John husbandman 797197 797197 Pars, John, of Great Comberton, husbandman 0
4754900 2281912 2281912 defendant Taillour Edmund yeoman 797197 797197 Taillour, Edmund, of Great Comberton, yeoman 1
5047684 2370925 2370925 defendant Bruell John yeoman 797197 797197 Bruell, John, of Great Comberton, yeoman 2
5141390 2398601 2398601 defendant Pollard Simon husbandman 797197 797197 Pollard, Simon, of Great Comberton, husbandman 12
5162547 2404770 2404770 defendant Pollard Simon husbandman 797197 797197 Pollard, Simon, of Great Comberton, husbandman 13
5162553 2404770 2404770 defendant Smyth Thomas husbandman 797197 797197 Smyth, Thomas, of Great Comberton, husbandman 19
5176538 2408824 2408824 defendant Pollard Simon husbandman 797197 797197 Pollard, Simon, of Great Comberton, husbandman 12
5176544 2408824 2408824 defendant Smyth Thomas husbandman 797197 797197 Smyth, Thomas, of Great Comberton, husbandman 18

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