names

41 rows where place_id = 588880

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595886 1866348 1866348 defendant Lambert of Thomas butcher 588880 588880 Lambert, of Thomas, of Thrysk, butcher 3
4479967 2194400 2194400 plaintiff Keppewyk William   588880 588880 Keppewyk, William, of Thrysk, on his own account 0
4548964 2215608 2215608 defendant Shupton John de   588880 588880 Shupton, John de, of Thrysk 0
4574181 2223450 2223450 defendant Bagby William   588880 588880 Bagby, William, of Thrysk 0
4574182 2223450 2223450 defendant Hynderwell Thomas   588880 588880 Hynderwell, Thomas, of Thrysk 1
4586055 2227063 2227063 plaintiff Hecok Richard   588880 588880 Hecok, Richard, of Thrysk 0
4957156 2344100 2344100 defendant Kilburn William dyer 588880 588880 Kilburn, William, of Thrysk, dyer 0
4957160 2344101 2344101 defendant Kylburn William dyer 588880 588880 Kylburn, William, of Thrysk, dyer 0
4999345 2356674 2356674 defendant Croppeld William sadler 588880 588880 Croppeld, William, of Thrysk, sadler 0
5034299 2366890 2366890 defendant Hyne or Hyve John barker 588880 588880 Hyne or Hyve, John, of Thrysk, barker 0
5034621 2366985 2366985 defendant Smelte Christopher yeoman 588880 588880 Smelte, Christopher, of Thrysk, yeoman 0
5113735 2390412 2390412 defendant Butterworth Roger yeoman 588880 588880 Butterworth, Roger, of Thrysk, yeoman 0
5113736 2390412 2390412 defendant Mariot John mercer 588880 588880 Mariot, John, of Thrysk, mercer 1
5113737 2390412 2390412 defendant Saunderson Robert barker 588880 588880 Saunderson, Robert, of Thrysk, barker 2
5113738 2390412 2390412 defendant Colson Robert berker 588880 588880 Colson, Robert, of Thrysk, berker 3
5113739 2390412 2390412 defendant Smyth John laborer 588880 588880 Smyth, John, of Thrysk, laborer 4
5113740 2390412 2390412 defendant Wode John weaver 588880 588880 Wode, John, of Thrysk, weaver 5
5113741 2390412 2390412 defendant Adamson Robert tailor 588880 588880 Adamson, Robert, of Thrysk, tailor 6
5113742 2390412 2390412 defendant Dey William weaver 588880 588880 Dey, William, of Thrysk, weaver 7
5113743 2390412 2390412 defendant Bayly Richard tailor 588880 588880 Bayly, Richard, of Thrysk, tailor 8
5113745 2390413 2390413 defendant Grenewode John gent 588880 588880 Grenewode, John, of Thrysk, gent 0
5181317 2410277 2410277 defendant Ploket John yeoman 588880 588880 Ploket, John, of Thrysk, yeoman 1
5192373 2413504 2413504 defendant Harland Henry shoemaker 588880 588880 Harland, Henry, of Thrysk, shoemaker 1
5213823 2419771 2419771 defendant Lytster Richard dyer 588880 588880 Lytster, Richard, of Thrysk, dyer 2
5241377 2427672 2427672 defendant Lokwod Henry yeoman 588880 588880 Lokwod, Henry, of Thrysk, yeoman 0
5241378 2427672 2427672 defendant Caubeton John yeoman 588880 588880 Caubeton, John, of Thrysk, yeoman 1
5241379 2427672 2427672 defendant Abbot John laborer 588880 588880 Abbot, John, of Thrysk, laborer 2
5241380 2427672 2427672 defendant Buttyrwyk Roger yeoman 588880 588880 Buttyrwyk, Roger, of Thrysk, yeoman 3
5241381 2427672 2427672 defendant Squier Richard chaplain 588880 588880 Squier, Richard, of Thrysk, chaplain 4
5288044 2441519 2441519 defendant Spycer John mercer 588880 588880 Spycer, John, of Thrysk, mercer 0
5288235 2441573 2441573 defendant Fox Robert yeoman 588880 588880 Fox, Robert, of Thrysk, yeoman 0
5301473 2445393 2445393 defendant Boterworth Roger yeoman 588880 588880 Boterworth, Roger, of Thrysk, yeoman 3
5318686 2450681 2450681 defendant Fauconer Thomas yeoman 588880 588880 Fauconer, Thomas, of Thrysk, yeoman 3
5326361 2452971 2452971 defendant Boterworth Roger yeoman 588880 588880 Boterworth, Roger, of Thrysk, yeoman 1
5326365 2452971 2452971 defendant Maryot John husbandman 588880 588880 Maryot, John, of Thrysk, husbandman 5
5326367 2452971 2452971 defendant Lassell Henry gent 588880 588880 (Lassell, Henry, of Thrysk, gent 7
5327201 2453208 2453208 defendant Mariot John, senior yeoman 588880 588880 Mariot, John, senior, of Thrysk, yeoman 0
5341585 2457559 2457559 defendant Rande Robert tailor 588880 588880 Rande, Robert, of Thrysk, tailor 0
5489183 2501647 2501647 defendant Sclater Thomas slater 588880 588880 Sclater, Thomas, of Thrysk, slater 1
5560631 2523075 2523075 defendant Archer William yeoman 588880 588880 Archer, William, of Thrysk, yeoman 0
5567176 2524978 2524978 defendant Emerson Leonard yeoman 588880 588880 Emerson, Leonard, of Thrysk, 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);