names

19 rows where place_id = 607014

✎ 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
3667336 1915721 1915721 plaintiff Wilson Robert   607014 607014 Wilson, Robert, of Westgate 0
3939943 2003659 2003659 defendant Bell John   607014 607014 Bell, John, of Westgate, tallow chandler 4
4484129 2195733 2195733 defendant Gate John   607014 607014 Gate, John, of Westgate 0
4486136 2196365 2196365 plaintiff Ropere John   607014 607014 Ropere, John, of Westgate 0
4486141 2196366 2196366 plaintiff Ropere John   607014 607014 Ropere, John, of Westgate 0
4491975 2198177 2198177 defendant Lyster Geoffrey   607014 607014 Lyster, Geoffrey, of Westgate 0
4496280 2199510 2199510 defendant Ropere John   607014 607014 Ropere, John, of Westgate 0
4576221 2224064 2224064 defendant Hamon John   607014 607014 Hamon, John, of Westgate 0
4593104 2229152 2229152 plaintiff Pachet John   607014 607014 Pachet, John, of Westgate 0
4593107 2229152 2229152 defendant Colyn Gervase   607014 607014 Colyn, Gervase, of Westgate 2
4624834 2238746 2238746 defendant Colyn John   607014 607014 Colyn, John, of Westgate 0
4624837 2238747 2238747 defendant Colyn John   607014 607014 Colyn, John, of Westgate 0
4650884 2246279 2246279 defendant Bertlot John   607014 607014 Bertlot, John, of Westgate 5
4666241 2250912 2250912 defendant Wynter Thomas tanner 607014 607014 Wynter, Thomas, of Westgate, tanner 0
4699840 2265395 2265395 defendant Aymer Henry skinner 607014 607014 Aymer, Henry, of Westgate, skinner 0
4711860 2269039 2269039 defendant Spyser William tanner 607014 607014 Spyser, William, of Westgate, tanner 4
5053931 2372771 2372771 defendant Heler Edmund laborer 607014 607014 Heler, Edmund, of Westgate, laborer 0
5599037 2534584 2534584 defendant Crotall Thomas dyer 607014 607014 Crotall, Thomas, of Westgate, dyer 0
5599038 2534584 2534584 defendant Rede Gerard   607014 607014 Rede, Gerard, of Westgate, brick maker 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);