names

15 rows where place_id = 596691

✎ 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
3625792 1875605 1875605 defendant Ingram John husbandman 596691 596691 Ingram, John, of Stanley St Leonard, husbandman 1
3934919 2001983 2001983 defendant Nycollys Robert weaver 596691 596691 Nycollys, Robert, of Stanley St Leonard, weaver 0
4149177 2077839 2077839 defendant Partridge Richard, junior yeoman 596691 596691 Partridge, Richard, junior, of Stanley St Leonard, yeoman 0
4149179 2077840 2077840 defendant Partridge Richard yeoman 596691 596691 Partridge, Richard, of Stanley St Leonard, yeoman 0
4501268 2201002 2201002 defendant Maunfeld Nicholas   596691 596691 Maunfeld, Nicholas, of Stanley St Leonard 0
4746526 2279476 2279476 defendant Walssh Walter husbandman 596691 596691 Walssh, Walter, of Stanley St Leonard, husbandman 0
4874164 2318860 2318860 defendant Meryk William husbandman 596691 596691 Meryk, William, of Stanley St Leonard, husbandman 1
5267512 2435599 2435599 defendant Tooppe Philip husbandman 596691 596691 Tooppe, Philip, of Stanley St Leonard, husbandman 0
5267513 2435599 2435599 defendant Carpenter John husbandman 596691 596691 Carpenter, John, of Stanley St Leonard, husbandman 1
5429451 2483739 2483739 defendant Mason Thomas husbandman 596691 596691 Mason, Thomas, of Stanley St Leonard, husbandman 15
5441853 2487493 2487493 defendant Bedyll John husbandman 596691 596691 Bedyll, John, of Stanley St Leonard, husbandman 0
5446444 2488828 2488828 defendant Mason Thomas   596691 596691 Mason, Thomas, of Stanley St Leonard 15
5446469 2488831 2488831 defendant Mason Thomas   596691 596691 Mason, Thomas, of Stanley St Leonard 15
5481251 2499339 2499339 defendant Seycell John husbandman 596691 596691 Seycell, John, of Stanley St Leonard, husbandman 1
5499011 2504639 2504639 defendant Bedyll John husbandman 596691 596691 Bedyll, John, of Stanley St Leonard, 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);