names

26 rows where place_id = 625004

✎ 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
3761554 1945626 1945626 defendant Pekett Thomas husbandman 625004 625004 Pekett, Thomas, of Raynham St Mary, husbandman 0
3871636 1980751 1980751 defendant Wulny Thomas yeoman 625004 625004 Wulny, Thomas, of Raynham St Mary, yeoman 1
3946328 2005789 2005789 defendant Jenyson Robert yeoman 625004 625004 Jenyson, Robert, of Raynham St Mary, yeoman 2
3946332 2005790 2005790 defendant Jenyson Robert yeoman 625004 625004 Jenyson, Robert, of Raynham St Mary, yeoman 2
3970962 2014401 2014401 defendant Dorrant Robert husbandman 625004 625004 Dorrant, Robert, of Raynham St Mary, husbandman 2
3996028 2023333 2023333 defendant Jenyson Robert yeoman 625004 625004 Jenyson, Robert, of Raynham St Mary, yeoman 2
3996029 2023333 2023333 defendant Parker Richard yeoman 625004 625004 Parker, Richard, of Raynham St Mary, yeoman 3
3996037 2023335 2023335 defendant Jenyson Robert yeoman 625004 625004 Jenyson, Robert, of Raynham St Mary, yeoman 2
3996038 2023335 2023335 defendant Parker Richard yeoman 625004 625004 Parker, Richard, of Raynham St Mary, yeoman 3
4011990 2029018 2029018 defendant Barsham William husbandman 625004 625004 Barsham, William, of Raynham St Mary, husbandman 0
4017853 2031096 2031096 defendant Rothewell Hugh yeoman 625004 625004 Rothewell, Hugh, of Raynham St Mary, yeoman 0
4017864 2031100 2031100 defendant Rothwell Hugh yeoman 625004 625004 Rothwell, Hugh, of Raynham St Mary, yeoman 0
4026764 2034220 2034220 defendant Meryall Christopher husbandman 625004 625004 Meryall, Christopher, of Raynham St Mary, husbandman 0
4026767 2034220 2034220 defendant Medcalfe Thomas husbandman 625004 625004 Medcalfe, Thomas, of Raynham St Mary, husbandman 3
4026769 2034221 2034221 defendant Meryall Christopher husbandman 625004 625004 Meryall, Christopher, of Raynham St Mary, husbandman 0
4029317 2035128 2035128 defendant Jenyson Robert yeoman 625004 625004 Jenyson, Robert, of Raynham St Mary, yeoman 1
4029318 2035128 2035128 defendant Parker Richard yeoman 625004 625004 Parker, Richard, of Raynham St Mary, yeoman 2
4029322 2035129 2035129 defendant Jenyson Robert yeoman 625004 625004 Jenyson, Robert, of Raynham St Mary, yeoman 2
4029323 2035129 2035129 defendant Parker Richard yeoman 625004 625004 Parker, Richard, of Raynham St Mary, yeoman 3
4043548 2040152 2040152 defendant Marshall Robert husbandman 625004 625004 Marshall, Robert, of Raynham St Mary, husbandman 1
4150777 2078409 2078409 defendant Addamson William clerk 625004 625004 Addamson, William, of Raynham St Mary, clerk 0
4150808 2078416 2078416 defendant Addamson William clerk 625004 625004 Addamson, William, of Raynham St Mary, clerk 2
4217226 2101522 2101522 defendant Maddock John miller 625004 625004 Maddock, John, of Raynham St Mary, miller 1
4217229 2101523 2101523 defendant Jenyson alias Jeningson Robert yeoman 625004 625004 Jenyson alias Jeningson, Robert, of Raynham St Mary, yeoman 0
4230007 2105983 2105983 defendant Jenyson Robert yeoman 625004 625004 Jenyson, Robert, of Raynham St Mary, yeoman 0
4278580 2122443 2122443 defendant Bassham William yeoman 625004 625004 Bassham, William, of Raynham St Mary, yeoman 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);