names

21 rows where place_id = 618681

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3725927 1934385 1934385 defendant Lee William gent 618681 618681 Lee, William, of Rychemond, Yorks, gent 8
3727363 1934832 1934832 defendant Browghe John gent 618681 618681 Browghe, John, of Rychemond, Yorks, gent 4
3777389 1950672 1950672 defendant Warcopp George gent 618681 618681 Warcopp, George, of Rychemond, Yorks, gent 0
3780347 1951586 1951586 defendant Eston Christopher gent 618681 618681 Eston, Christopher, of Rychemond, Yorks, gent 0
3829159 1967003 1967003 defendant Johnson Charles merchant 618681 618681 Johnson, Charles, of Rychemond, Yorks, merchant 0
3852047 1974231 1974231 defendant Thomson Richard chapman 618681 618681 Thomson, Richard, of Rychemond, Yorks, chapman 0
3855384 1975325 1975325 defendant Johnson Charles mercer 618681 618681 Johnson, Charles, of Rychemond, Yorks, mercer 0
3919503 1996854 1996854 defendant Ullock John cordwainer 618681 618681 Ullock, John, of Rychemond, Yorks, cordwainer 0
3950184 2007147 2007147 defendant Hodshon John merchant 618681 618681 Hodshon, John, of Rychemond, Yorks, merchant 0
3975102 2015854 2015854 defendant Burres William yeoman 618681 618681 Burres, William, of Rychemond, Yorks, yeoman 0
4007030 2027291 2027291 defendant Johnson John draper 618681 618681 Johnson, John, of Rychemond, Yorks, draper 0
4857247 2313654 2313654 defendant Nesse John weaver 618681 618681 Nesse, John, of Rychemond, Yorks, weaver 0
4926029 2334570 2334570 defendant Kirkeby Robert chapman 618681 618681 Kirkeby, Robert, of Rychemond, Yorks, chapman 3
4993607 2354962 2354962 defendant Rychardson John   618681 618681 Rychardson, John, of Rychemond, Yorks, card maker 0
5030020 2365650 2365650 defendant Frank Margaret widow 618681 618681 Frank, Margaret, of Rychemond, Yorks, widow 4
5100058 2386455 2386455 defendant Weltden John gent 618681 618681 Weltden, John, of Rychemond, Yorks, gent 0
5100063 2386456 2386456 defendant Weltden John gent 618681 618681 Weltden, John, of Rychemond, Yorks, gent 0
5111862 2389859 2389859 defendant Asby Thomas chapman 618681 618681 Asby, Thomas, of Rychemond, Yorks, chapman 0
5172045 2407539 2407539 defendant Gaynesford John chapman 618681 618681 Gaynesford, John, of Rychemond, Yorks, chapman 3
5191020 2413115 2413115 defendant Gaynesford John chapman 618681 618681 Gaynesford, John, of Rychemond, Yorks, chapman 3
5191027 2413117 2413117 defendant Gaynesford John chapman 618681 618681 Gaynesford, John, of Rychemond, Yorks, chapman 3

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);