names

11 rows where place_id = 609845

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3680654 1920027 1920027 defendant Clerke William yeoman 609845 609845 Clerke, William, of Cray St Mary, yeoman 1
3718116 1931956 1931956 defendant Gardyner Richard husbandman 609845 609845 Gardyner, Richard, of Cray St Mary, husbandman 0
3722092 1933172 1933172 plaintiff Clerke William   609845 609845 Clerke, William, of Cray St Mary 1
3725633 1934306 1934306 defendant Gardyner Richard yeoman 609845 609845 Gardyner, Richard, of Cray St Mary, yeoman 0
3813877 1962249 1962249 defendant Polle John yeoman 609845 609845 Polle, John, of Cray St Mary, yeoman 0
5114731 2390722 2390722 defendant Walssh Richard husbandman 609845 609845 Walssh, Richard, of Cray St Mary, husbandman 3
5114738 2390722 2390722 defendant Stable Thomas husbandman 609845 609845 Stable, Thomas, of Cray St Mary, husbandman 10
5213090 2419564 2419564 plaintiff Miller Richard   609845 609845 Miller, Richard, of Cray St Mary 1
5339676 2456982 2456982 defendant Chaunceller Richard husbandman 609845 609845 Chaunceller, Richard, of Cray St Mary, husbandman 0
5488590 2501470 2501470 defendant Nicoll William miller 609845 609845 Nicoll, William, of Cray St Mary, miller 2
5511027 2508287 2508287 defendant Wybarn Richard husbandman 609845 609845 Wybarn, Richard, of Cray St Mary, husbandman 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);