names

23 rows where place_id = 600342

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3596373 1866498 1866498 defendant Ryther Thomas gent 600342 600342 Ryther, Thomas, of Ryther, Yorks, gent 0
3640682 1907527 1907527 defendant Ryther Ralph   600342 600342 Ryther, Ralph, of Ryther, Yorks, knight 0
4329620 2140206 2140206 defendant Saltmarshe Charles gent 600342 600342 Saltmarshe, Charles, of Ryther, Yorks, gent 1
4344917 2145501 2145501 defendant Aske John esq 600342 600342 Aske, John, of Ryther, Yorks, esq 1
4388018 2160622 2160622 defendant Aske John esq 600342 600342 Aske, John, of Ryther, Yorks, esq 0
4890793 2323869 2323869 defendant Ryther William, junior esq 600342 600342 Ryther, William, junior, of Ryther, Yorks, esq 2
5001429 2357303 2357303 defendant Ryther William   600342 600342 Ryther, William, of Ryther, Yorks, knight & lord 1
5061992 2375187 2375187 defendant Ryther William   600342 600342 Ryther, William, of Ryther, Yorks, knight 4
5080260 2380585 2380585 defendant Ryther William   600342 600342 Ryther, William, of Ryther, Yorks, knight 0
5081279 2380911 2380911 defendant Ryther William   600342 600342 Ryther, William, of Ryther, Yorks, knight 0
5183262 2410848 2410848 defendant Ryther William   600342 600342 Ryther, William, of Ryther, Yorks, knight 0
5183264 2410848 2410848 defendant Heton Richard yeoman 600342 600342 Heton, Richard, of Ryther, Yorks, yeoman 2
5187277 2412006 2412006 defendant Rythe William   600342 600342 Rythe, William, of Ryther, Yorks, knight 0
5187279 2412007 2412007 defendant Ryther William   600342 600342 Ryther, William, of Ryther, Yorks, knight 0
5205554 2417370 2417370 defendant Ryther William   600342 600342 Ryther, William, of Ryther, Yorks, knight 0
5205556 2417371 2417371 defendant Ryther William   600342 600342 Ryther, William, of Ryther, Yorks, knight 0
5218864 2421241 2421241 defendant Ryther William   600342 600342 Ryther, William, of Ryther, Yorks, knight 0
5218870 2421242 2421242 defendant Ryther William   600342 600342 Ryther, William, of Ryther, Yorks, knight 0
5219236 2421349 2421349 defendant Ryther William   600342 600342 Ryther, William, of Ryther, Yorks, knight 0
5395013 2473638 2473638 defendant Ryther Thomas esq 600342 600342 Ryther, Thomas, of Ryther, Yorks, esq 2
5405080 2476530 2476530 defendant Ryther Robert clerk 600342 600342 Ryther, Robert, of Ryther, Yorks, clerk 0
5408280 2477444 2477444 defendant Ryther Thomas esq 600342 600342 Ryther, Thomas, of Ryther, Yorks, esq 1
5436348 2485806 2485806 defendant Ryther Robert clerk 600342 600342 Ryther, Robert, of Ryther, Yorks, clerk 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);