names

26 rows where place_id = 613109

✎ 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
3696673 1925185 1925185 defendant Baldok Richard husbandman 613109 613109 Baldok, Richard, of Neweland, husbandman 0
4409009 2167616 2167616 defendant Wylkinsone William laborer 613109 613109 Wylkinsone, William, of Neweland, laborer 0
4409010 2167616 2167616 defendant Markam William fisher 613109 613109 Markam, William, of Neweland, fisher 1
4480979 2194728 2194728 defendant West Stephen   613109 613109 West, Stephen, of Neweland 0
4522832 2207481 2207481 defendant Frere William   613109 613109 Frere, William, of Neweland 0
4525691 2208334 2208334 plaintiff Jonkynson William   613109 613109 Jonkynson, William, of Neweland 0
4595367 2229803 2229803 defendant Thomson William   613109 613109 Thomson, William, of Neweland 0
4688010 2261821 2261821 defendant Hobson Richard husbandman 613109 613109 Hobson, Richard, of Neweland, husbandman 0
4713633 2269587 2269587 defendant Hobson Richard husbandman 613109 613109 Hobson, Richard, of Neweland, husbandman 0
4756712 2282463 2282463 defendant Stewart Robert yeoman 613109 613109 Stewart, Robert, of Neweland, yeoman 1
4778617 2289295 2289295 defendant Stewart Robert yeoman 613109 613109 Stewart, Robert, of Neweland, yeoman 1
4786306 2291762 2291762 plaintiff Frost Walter   613109 613109 Frost Walter, of Neweland 0
4820808 2302591 2302591 defendant Manyngham John gent 613109 613109 Manyngham, John, of Neweland, gent 0
4834919 2306924 2306924 defendant Rawelyn William yeoman 613109 613109 Rawelyn, William, of Neweland, yeoman 1
4857980 2313864 2313864 defendant Cartwryght Stephen husbandman 613109 613109 Cartwryght, Stephen, of Neweland, husbandman 0
4859676 2314399 2314399 defendant Frost Walter gent 613109 613109 together with Frost, Walter, of Neweland, gent 1
4861457 2314954 2314954 defendant Manyngham John, junior (legal representative) 613109 613109 Manyngham, John, junior, of Neweland, executors of 0
4896704 2325633 2325633 defendant Palmer Thomas yeoman 613109 613109 Palmer, Thomas, of Neweland, yeoman 0
4896705 2325633 2325633 defendant Willyamson Stephen yeoman 613109 613109 Willyamson, Stephen, of Neweland, yeoman 1
4896706 2325633 2325633 defendant Robynson William yeoman 613109 613109 Robynson, William, of Neweland, yeoman 2
4951380 2342394 2342394 defendant Megson William husbandman 613109 613109 Megson, William, of Neweland, husbandman 1
4974534 2349346 2349346 defendant Frost Walter gent 613109 613109 Frost, Walter, of Neweland, gent 1
5007212 2359001 2359001 defendant Warde John husbandman 613109 613109 Warde, John, of Neweland, husbandman 0
5129584 2395140 2395140 defendant Neweland Thomas husbandman 613109 613109 Neweland, Thomas, of Neweland, husbandman 0
5191460 2413242 2413242 defendant Froste Thomas gent 613109 613109 Froste, Thomas, of Neweland, gent 1
5537725 2516285 2516285 defendant Pele Thomas yeoman 613109 613109 Pele, Thomas, of Neweland, yeoman 6

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