names

15 rows where place_id = 759615

✎ 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
4462810 2189066 2189066 defendant Rayner Robert   759615 759615 Rayner, Robert, of Graynesby 0
4583377 2226222 2226222 defendant North Thomas   759615 759615 North, Thomas, of Graynesby 0
4583379 2226223 2226223 defendant North Thomas   759615 759615 North, Thomas, of Graynesby 0
4674448 2257618 2257618 defendant Davy Robert chaplain 759615 759615 Davy, Robert, of Graynesby, chaplain 0
4678924 2259012 2259012 plaintiff Phillip John   759615 759615 Phillip, John, of Graynesby 1
4678925 2259012 2259012 plaintiff Phillip Robert   759615 759615 Phillip, Robert, of Graynesby, son of John 2
4678926 2259012 2259012 plaintiff Keill William   759615 759615 Keill, William, of Graynesby 3
4678927 2259012 2259012 plaintiff Bynbroke John   759615 759615 Bynbroke, John, of Graynesby 4
4678929 2259012 2259012 plaintiff Brig William   759615 759615 Brig, William, of Graynesby 6
4681191 2259745 2259745 defendant Phillipp John husbandman 759615 759615 Phillipp, John, of Graynesby, husbandman 0
4681192 2259745 2259745 defendant Ivry Richard husbandman 759615 759615 Ivry, Richard, of Graynesby, husbandman 1
4752543 2281204 2281204 defendant Rayner Robert husbandman 759615 759615 Rayner, Robert, of Graynesby, husbandman 1
4880525 2320819 2320819 defendant Rote William husbandman 759615 759615 Rote, William, of Graynesby, husbandman 4
4887779 2323009 2323009 defendant Phelyp John husbandman 759615 759615 Phelyp, John, of Graynesby, husbandman 3
4890389 2323762 2323762 defendant Philypp John husbandman 759615 759615 Philypp, John, of Graynesby, husbandman 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);