names

30 rows where place_id = 757060

✎ 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
4442866 2182727 2182727 defendant Sergeant Simon   757060 757060 Sergeant, Simon, of Setryngton 0
4488613 2197160 2197160 defendant Wodbrig John   757060 757060 Wodbrig, John, of Setryngton 0
4492478 2198334 2198334 defendant Wodburgh John   757060 757060 Wodburgh, John, of Setryngton 0
4495525 2199282 2199282 defendant Halmby Adam de clerk 757060 757060 Halmby, Adam de, of Setryngton, clerk 0
4520234 2206668 2206668 defendant Wetewang William   757060 757060 Wetewang, William, of Setryngton 0
4542378 2213507 2213507 defendant Wodeburgh John   757060 757060 Wodeburgh, John, of Setryngton 0
4552366 2216693 2216693 defendant Wetewang William   757060 757060 Wetewang, William, of Setryngton 0
4566671 2221150 2221150 defendant Wettewang William de   757060 757060 Wettewang, William de, of Setryngton 0
4617534 2236496 2236496 defendant Ferrour John   757060 757060 Ferrour, John, of Setryngton 0
4617542 2236497 2236497 defendant Westby William forester 757060 757060 Westby, William, of Setryngton, forester 6
4617543 2236497 2236497 defendant Mauby Robert   757060 757060 Mauby, Robert, of Setryngton 7
4617544 2236497 2236497 defendant Birkhede John   757060 757060 Birkhede, John, of Setryngton 8
4617545 2236497 2236497 defendant Hirde Adam   757060 757060 Hirde, Adam, of Setryngton 9
4617546 2236497 2236497 defendant Boteller Thomas   757060 757060 Boteller, Thomas, of Setryngton 10
4617554 2236501 2236501 defendant Huland Thomas   757060 757060 Huland, Thomas, of Setryngton 0
4648289 2245561 2245561 defendant Wetwang William   757060 757060 Wetwang, William, of Setryngton 1
4650209 2246083 2246083 plaintiff Wetwang William de   757060 757060 Wetwang, William de, of Setryngton 0
4664103 2250260 2250260 defendant Loweson Thomas husbandman 757060 757060 Loweson, Thomas, of Setryngton, husbandman 0
4805629 2297969 2297969 defendant Welton John laborer 757060 757060 Welton, John, of Setryngton, laborer 0
4859052 2314211 2314211 defendant Brymlay John laborer 757060 757060 Brymlay, John, of Setryngton, laborer 0
5032842 2366492 2366492 defendant Bukton Thomas esq 757060 757060 Bukton, Thomas, of Setryngton, esq 0
5032843 2366492 2366492 defendant Bukton John gent 757060 757060 Bukton, John, of Setryngton, gent 1
5035647 2367283 2367283 defendant Pykerynge Thomas esq 757060 757060 Pykerynge, Thomas, of Setryngton, esq 0
5048902 2371306 2371306 defendant Bukton Thomas esq 757060 757060 Bukton, Thomas, of Setryngton, esq 0
5048903 2371306 2371306 defendant Bukton John gent 757060 757060 Bukton, John, of Setryngton, gent 1
5112109 2389925 2389925 defendant Wodcok John yeoman 757060 757060 Wodcok, John, of Setryngton, yeoman 1
5112110 2389925 2389925 defendant Willyamson John yeoman 757060 757060 Willyamson, John, of Setryngton, yeoman 2
5112111 2389925 2389925 defendant Leverok John yeoman 757060 757060 Leverok, John, of Setryngton, yeoman 3
5127446 2394502 2394502 defendant Wodcok John yeoman 757060 757060 Wodcok, John, of Setryngton, yeoman 1
5144684 2399602 2399602 defendant Wodecok John yeoman 757060 757060 Wodecok, John, of Setryngton, 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);