names

18 rows where place_id = 774045

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4607599 2233484 2233484 defendant Sclater John   774045 774045 Sclater, John, of Newebiggyng 1
4613162 2235171 2235171 defendant del Halle William   774045 774045 del Halle, William, of Newebiggyng 12
4613188 2235174 2235174 defendant Graveson or Graneson John   774045 774045 Graveson or Graneson, John, of Newebiggyng 0
4613189 2235174 2235174 defendant Richardson John   774045 774045 Richardson, John, of Newebiggyng 1
4613191 2235174 2235174 defendant Yonson William, sen   774045 774045 Yonson, William, sen, of Newebiggyng 3
4613192 2235174 2235174 defendant Farlam Thomas de   774045 774045 Farlam, Thomas de, of Newebiggyng 4
4613193 2235174 2235174 defendant Wilson John   774045 774045 Wilson, John, of Newebiggyng 5
4613194 2235174 2235174 defendant Wilson Adam   774045 774045 Wilson, Adam, of Newebiggyng 6
4613195 2235174 2235174 defendant Atkynson William   774045 774045 Atkynson, William, of Newebiggyng 7
4671160 2256642 2256642 defendant Todde Robert yeoman 774045 774045 Todde, Robert, of Newebiggyng, yeoman 4
4671163 2256642 2256642 defendant Haskhed William de husbandman 774045 774045 Haskhed, William de, of Newebiggyng, husbandman 7
4698515 2265010 2265010 defendant Wilston John husbandman 774045 774045 Wilston, John, of Newebiggyng, husbandman 4
4698516 2265010 2265010 defendant Thomson Adam husbandman 774045 774045 Thomson, Adam, of Newebiggyng, husbandman 5
4834448 2306781 2306781 plaintiff Crakenthorp John, sen   774045 774045 Crakenthorp, John, sen, of Newebiggyng 0
4854290 2312750 2312750 defendant Hobkynson John husbandman 774045 774045 Hobkynson, John, of Newebiggyng, husbandman 4
5007985 2359225 2359225 defendant Crakanthorp John esq 774045 774045 Crakanthorp, John, of Newebiggyng, esq 0
5528398 2513420 2513420 defendant Salvayn Ralph esq 774045 774045 Salvayn, Ralph, of Newebiggyng, esq 5
5631455 2553845 2553845 defendant Wangforth John yeoman 774045 774045 Wangforth, John, of Newebiggyng, 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);