names

10 rows where place_id = 762082

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4484408 2195815 2195815 defendant Melton John shoemaker 762082 762082 Melton, John, of Oakham, shoemaker 0
4693453 2263454 2263454 plaintiff Flore Roger   762082 762082 Flore, Roger, of Oakham 2
4693459 2263455 2263455 plaintiff Flore Roger   762082 762082 Flore, Roger, of Oakham 2
4715942 2270301 2270301 defendant Ednam John   762082 762082 Ednam, John, of Oakham, glove maker 0
4766337 2285464 2285464 defendant Campe Robert yeoman 762082 762082 Campe, Robert, of Oakham, formerly of Barlithorp or Barleythorpe, Rutland, yeoman 0
4833888 2306607 2306607 defendant Kendale Thomas   762082 762082 Kendale, Thomas, of Oakham, horse master 0
4844058 2309652 2309652 defendant Milner Robert miller 762082 762082 Milner, Robert, of Oakham, miller 0
4844059 2309652 2309652 defendant Coke Maud widow 762082 762082 Coke, Maud, of Oakham, widow 1
5209021 2418372 2418372 defendant Ryngston Thomas husbandman 762082 762082 Ryngston, Thomas, of Oakham, husbandman 0
5209022 2418372 2418372 defendant Bardolf Robert walker 762082 762082 Bardolf, Robert, of Oakham, walker 1

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