names

16 rows where place_id = 699318

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4128372 2070436 2070436 defendant Mayle William yeoman 699318 699318 Mayle, William, of Payneswicke, yeoman 1
4150330 2078247 2078247 defendant Barnes Henry husbandman 699318 699318 Barnes, Henry, of Payneswicke, husbandman 0
4150331 2078247 2078247 defendant Danyells Edward tucker 699318 699318 Danyells, Edward, of Payneswicke, tucker 1
4150332 2078247 2078247 defendant Copner William   699318 699318 Copner, William, of Payneswicke, mason 2
4154541 2079681 2079681 defendant Whityne Arthur yeoman 699318 699318 Whityne, Arthur, of Payneswicke, yeoman 1
4178281 2087874 2087874 defendant Rawling William butcher 699318 699318 Rawling, William, of Payneswicke, butcher 0
4247924 2112290 2112290 defendant Chambers William husbandman 699318 699318 Chambers, William, of Payneswicke, husbandman 0
4247925 2112290 2112290 defendant Jeide John husbandman 699318 699318 Jeide, John, of Payneswicke, husbandman 1
4247926 2112290 2112290 defendant Poole John husbandman 699318 699318 Poole, John, of Payneswicke, husbandman 2
4248686 2112546 2112546 defendant Twynnynge John broadweaver 699318 699318 Twynnynge, John, of Payneswicke, broadweaver 1
4295371 2128430 2128430 defendant Kynge John husbandman 699318 699318 Kynge, John, of Payneswicke, husbandman 0
4372323 2155167 2155167 defendant Osborne John yeoman 699318 699318 Osborne, John, of Payneswicke, yeoman 0
4372324 2155167 2155167 defendant Gill Thomas yeoman 699318 699318 Gill, Thomas, of Payneswicke, yeoman 1
4376081 2156509 2156509 defendant Beard John chapman 699318 699318 Beard, John, of Payneswicke, chapman 1
4409012 2167617 2167617 defendant Blisse Thomas gent 699318 699318 Blisse, Thomas, of Payneswicke, gent 0
4409013 2167617 2167617 defendant Webbe John yeoman 699318 699318 Webbe, John, of Payneswicke, yeoman 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);