names

15 rows where place_id = 651652

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3919056 1996698 1996698 plaintiff Justice Richard gent 651652 651652 Justice, Richard, of Redynge, Berks, gent 0
3950637 2007296 2007296 plaintiff Gateley John yeoman 651652 651652 Gateley, John, of Redynge, Berks, yeoman 0
3951578 2007608 2007608 defendant Bigges Henry butcher 651652 651652 Bigges, Henry, of Redynge, Berks, butcher 1
3959843 2010534 2010534 defendant Beryngton Thomas gent 651652 651652 Beryngton, Thomas, of Redynge, Berks, gent 0
3980286 2017715 2017715 defendant Constable Richard yeoman 651652 651652 Constable, Richard, of Redynge, Berks, yeoman 0
3984402 2019179 2019179 plaintiff Synglton Thomas (legal representative) 651652 651652 Synglton, Thomas, of Redynge, Berks, baker, executor of 0
3992654 2022121 2022121 defendant Pratt Thomas clother 651652 651652 Pratt, Thomas, of Redynge, Berks, clother 0
4011217 2028784 2028784 defendant Rydgys John yeoman 651652 651652 Rydgys, John, of Redynge, Berks, yeoman 1
4011915 2028989 2028989 defendant Beryngton Christopher gent 651652 651652 Beryngton, Christopher, of Redynge, Berks, innholder, gent 0
4117221 2066466 2066466 defendant Drewe Richard chapman 651652 651652 Drewe, Richard, of Redynge, Berks, chapman 1
4126928 2069924 2069924 defendant Waller Thomas chapman 651652 651652 Waller, Thomas, of Redynge, Berks, chapman 1
4368224 2153686 2153686 defendant Harrys Robert gent 651652 651652 Harrys, Robert, of Redynge, Berks, gent 2
4674130 2257516 2257516 defendant Wyly alias Carpenter William yeoman 651652 651652 Wyly alias Carpenter, William, of Redynge, Berks, yeoman 0
5526283 2512800 2512800 defendant Nasshe Simon innholder 651652 651652 Nasshe, Simon, of Redynge, Berks, innholder 0
5626151 2552143 2552143 defendant Benfeld Roger yeoman 651652 651652 Benfeld, Roger, of Redynge, Berks, yeoman 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);