names

8 rows where place_id = 595762

✎ 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
3621785 1874352 1874352 plaintiff Padnale John yeoman 595762 595762 Padnale, John, of Crandon, Bucks, yeoman 0
3621787 1874353 1874353 plaintiff Padnall John yeoman 595762 595762 Padnall, John, of Crandon, Bucks, yeoman 0
5244063 2428451 2428451 defendant Grange Robert tailor 595762 595762 Grange, Robert, of Crandon, Bucks, tailor 0
5244065 2428452 2428452 defendant Grange Robert tailor 595762 595762 Grange, Robert, of Crandon, Bucks, tailor 0
5371284 2466601 2466601 defendant Loveden or Loneden Margaret widow 595762 595762 (Loveden or Loneden, Margaret, of Crandon, Bucks, widow 1
5388963 2471899 2471899 defendant Loveden Thomas (legal representative) 595762 595762 Loveden, Thomas, of Crandon, Bucks, gent, executors of 9
5388964 2471899 2471899 defendant Loveden Margaret widow 595762 595762 (Loveden, Margaret, of Crandon, Bucks, widow 10
5540424 2517136 2517136 defendant Pednall John yeoman 595762 595762 Pednall, John, of Crandon, Bucks, yeoman 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);