names

43 rows where place_id = 590548

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3601583 1868150 1868150 defendant Multon John gent 590548 590548 Multon, John, of Thryske, gent 0
3813272 1962062 1962062 defendant Ello John glover 590548 590548 Ello, John, of Thryske, glover 1
4025979 2033941 2033941 defendant Smythe William yeoman 590548 590548 Smythe, William, of Thryske, yeoman 0
4480126 2194442 2194442 defendant Smyth Nicholas   590548 590548 Smyth, Nicholas, of Thryske 0
4584290 2226498 2226498 defendant Carter William   590548 590548 Carter, William, of Thryske 1
4663033 2249904 2249904 defendant Lyster John dyer 590548 590548 Lyster, John, of Thryske, dyer 2
4864611 2315904 2315904 defendant Dalton John flesshewer or butcher 590548 590548 Dalton, John, of Thryske, flesshewer or butcher 2
4887638 2322966 2322966 defendant Grenewod William gent 590548 590548 Grenewod, William, of Thryske, gent 0
4887640 2322966 2322966 defendant Grenewod John gent 590548 590548 Grenewod, John, of Thryske, gent 2
4898873 2326290 2326290 defendant Palyser John yeoman 590548 590548 Palyser, John, of Thryske, yeoman 0
4898875 2326290 2326290 defendant Spofford William laborer 590548 590548 Spofford, William, of Thryske, laborer 2
4903169 2327601 2327601 defendant Palyser John yeoman 590548 590548 Palyser, John, of Thryske, yeoman 1
5010584 2359969 2359969 defendant Kilburn William dyer 590548 590548 Kilburn, William, of Thryske, dyer 0
5041288 2368999 2368999 defendant Kilburn William dyer 590548 590548 Kilburn, William, of Thryske, dyer 2
5110058 2389359 2389359 defendant Wyghall John gent 590548 590548 Wyghall, John, of Thryske, gent 0
5110060 2389360 2389360 defendant Wyghall John yeoman 590548 590548 Wyghall, John, of Thryske, yeoman 0
5110062 2389360 2389360 defendant Crosseby Robert clerk 590548 590548 Crosseby, Robert, of Thryske, clerk 2
5110064 2389360 2389360 defendant Crosseby John yeoman 590548 590548 Crosseby, John, of Thryske, yeoman 4
5110065 2389360 2389360 defendant Crosseby William yeoman 590548 590548 Crosseby, William, of Thryske, yeoman 5
5110066 2389360 2389360 defendant Jonson William yeoman 590548 590548 Jonson, William, of Thryske, yeoman 6
5110067 2389360 2389360 defendant Lambert Thomas yeoman 590548 590548 Lambert, Thomas, of Thryske, yeoman 7
5110068 2389360 2389360 defendant Mariote John yeoman 590548 590548 Mariote, John, of Thryske, yeoman 8
5110069 2389360 2389360 defendant Litster John yeoman 590548 590548 Litster, John, of Thryske, yeoman 9
5110072 2389361 2389361 defendant Buttirworth Roger yeoman 590548 590548 Buttirworth, Roger, of Thryske, yeoman 0
5110073 2389361 2389361 defendant Johnson William husbandman 590548 590548 Johnson, William, of Thryske, husbandman 1
5110074 2389361 2389361 defendant Lambart Thomas husbandman 590548 590548 Lambart, Thomas, of Thryske, husbandman 2
5110075 2389361 2389361 defendant Maryot John husbandman 590548 590548 Maryot, John, of Thryske, husbandman 3
5110076 2389361 2389361 defendant Crosby John husbandman 590548 590548 Crosby, John, of Thryske, husbandman 4
5110077 2389361 2389361 defendant Crosby William husbandman 590548 590548 Crosby, William, of Thryske, husbandman 5
5110078 2389361 2389361 defendant Crosby Robert chaplain 590548 590548 Crosby, Robert, of Thryske, chaplain 6
5113669 2390389 2390389 defendant Buttyrworth Roger yeoman 590548 590548 Buttyrworth, Roger, of Thryske, yeoman 1
5113921 2390460 2390460 defendant Butterworth Roger yeoman 590548 590548 Butterworth, Roger, of Thryske, yeoman 0
5113922 2390460 2390460 defendant Webster Thomas chaplain 590548 590548 Webster, Thomas, of Thryske, chaplain 1
5113923 2390460 2390460 defendant Calton John   590548 590548 Calton, John, of Thryske, parish clerk 2
5113924 2390460 2390460 defendant Colson Robert barker 590548 590548 Colson, Robert, of Thryske, barker 3
5113925 2390460 2390460 defendant Mariot John mercer 590548 590548 Mariot, John, of Thryske, mercer 4
5113926 2390460 2390460 defendant Saunderson Robert berker 590548 590548 Saunderson, Robert, of Thryske, berker 5
5113927 2390460 2390460 defendant Grenewode William gent 590548 590548 Grenewode, William, of Thryske, gent 6
5154205 2402386 2402386 defendant Butterworth Roger yeoman 590548 590548 Butterworth, Roger, of Thryske, yeoman 4
5275673 2437951 2437951 defendant Kydder John milner 590548 590548 Kydder, John, of Thryske, milner 0
5293534 2443076 2443076 defendant Bank Richard chapman 590548 590548 Bank, Richard, of Thryske, chapman 0
5314417 2449338 2449338 defendant Well Thomas cooper 590548 590548 Well, Thomas, of Thryske, cooper 0
5314419 2449339 2449339 defendant Well Thomas cooper 590548 590548 Well, Thomas, of Thryske, cooper 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);