names

25 rows where place_id = 600820

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3642691 1908159 1908159 defendant Lowther Nicholas chaplain 600820 600820 Lowther, Nicholas, of Wigton, chaplain 1
4046557 2041220 2041220 plaintiff Smyth John gent 600820 600820 Smyth, John, of Wigton, gent 0
4314478 2135177 2135177 defendant Granger John yeoman 600820 600820 Granger, John, of Wigton, yeoman 0
4314479 2135177 2135177 defendant Nicholson Agnes spinster 600820 600820 Nicholson, Agnes, of Wigton, spinster 1
4314480 2135177 2135177 defendant Nicholson Elizabeth spinster 600820 600820 Nicholson, Elizabeth, of Wigton, spinster 2
4321500 2137609 2137609 defendant Sanderson Robert yeoman 600820 600820 Sanderson, Robert, of Wigton, yeoman 0
4321501 2137609 2137609 defendant Sanderson David yeoman 600820 600820 Sanderson, David, of Wigton, yeoman 1
4321502 2137609 2137609 defendant Granger Thomas yeoman 600820 600820 Granger, Thomas, of Wigton, yeoman 2
4342200 2144554 2144554 defendant Burdhead or Burdett Ralph gent 600820 600820 Burdhead or Burdett, Ralph, of Wigton, gent 0
4342201 2144554 2144554 defendant Walker Henry   600820 600820 Walker, Henry, of Wigton, wheelwright 1
4365707 2152781 2152781 defendant Granger Edward yeoman 600820 600820 Granger, Edward, of Wigton, yeoman 4
4369598 2154183 2154183 defendant Singleton Mathew yeoman 600820 600820 Singleton, Mathew, of Wigton, yeoman 2
4393030 2162280 2162280 defendant Burdhead or Burdett Ralph gent 600820 600820 Burdhead or Burdett, Ralph, of Wigton, gent 0
4393031 2162280 2162280 defendant Walker Henry   600820 600820 Walker, Henry, of Wigton, wheelwright 1
4624809 2238742 2238742 plaintiff Okeham William   600820 600820 Okeham, William, of Wigton 0
4659632 2248866 2248866 defendant de Qwynsell Henry yeoman 600820 600820 de Qwynsell, Henry, of Wigton, yeoman 0
4672615 2257077 2257077 defendant Slake William de yeoman 600820 600820 Slake, William de, of Wigton, yeoman 1
4714260 2269790 2269790 defendant Quynsell Henry yeoman 600820 600820 Quynsell, Henry, of Wigton, yeoman 0
4766162 2285408 2285408 defendant Barre Geoffrey yeoman 600820 600820 Barre, Geoffrey, of Wigton, yeoman 0
4803792 2297367 2297367 defendant Feman John yeoman 600820 600820 Feman, John, of Wigton, yeoman 3
4831240 2305799 2305799 defendant Waweyne John   600820 600820 Waweyne, John, of Wigton, vicar 1
4879947 2320643 2320643 defendant Robynson William yeoman 600820 600820 together with Robynson, William, of Wigton, yeoman 2
4937228 2338011 2338011 defendant Waweyn John clerk 600820 600820 together with Waweyn, John, of Wigton, Cumber, clerk 1
4992381 2354608 2354608 defendant Atkynson Nicholas yeoman 600820 600820 Atkynson, Nicholas, of wigton, yeoman 0
5623814 2551389 2551389 defendant Launder John yeoman 600820 600820 Launder, John, of Wigton, yeoman 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);