names

36 rows where place_id = 633639

✎ 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
3813923 1962263 1962263 defendant Croft John husbandman 633639 633639 Croft, John, of Tydde St Giles, husbandman 0
3817419 1963362 1963362 defendant Ferrour Thomas yeoman 633639 633639 Ferrour, Thomas, of Tydde St Giles, yeoman 0
3903509 1991401 1991401 defendant Whytred John husbandman 633639 633639 Whytred, John, of Tydde St Giles, husbandman 0
3903510 1991401 1991401 defendant Whytred Thomas husbandman 633639 633639 Whytred, Thomas, of Tydde St Giles, husbandman 1
4422441 2171877 2171877 defendant Neuport William de   633639 633639 Neuport, William de, of Tydde St Giles 0
4422442 2171877 2171877 defendant Andreu William   633639 633639 Andreu, William, of Tydde St Giles 1
4756771 2282482 2282482 defendant Wanton Thomas husbandman 633639 633639 Wanton, Thomas, of Tydde St Giles, husbandman 1
4879387 2320483 2320483 defendant Wryght Henry husbandman 633639 633639 Wryght, Henry, of Tydde St Giles, husbandman 1
4879388 2320483 2320483 defendant Poundeyl Simon husbandman 633639 633639 Poundeyl, Simon, of Tydde St Giles, husbandman 2
4908165 2329107 2329107 defendant Howesold John yeoman 633639 633639 Howesold, John, of Tydde St Giles, yeoman 1
4908166 2329107 2329107 defendant Cok Thomas yeoman 633639 633639 Cok, Thomas, of Tydde St Giles, yeoman 2
4908167 2329107 2329107 defendant Wytrat John yeoman 633639 633639 Wytrat, John, of Tydde St Giles, yeoman 3
4943404 2339908 2339908 defendant Cotte Fulk husbandman 633639 633639 Cotte, Fulk, of Tydde St Giles, husbandman 0
4996912 2355931 2355931 defendant Warner William husbandman 633639 633639 Warner, William, of Tydde St Giles, husbandman 2
5018190 2362208 2362208 defendant Tatersale John chaplain 633639 633639 Tatersale, John, of Tydde St Giles, chaplain 1
5130054 2395276 2395276 defendant Clerk William gent 633639 633639 Clerk, William, of Tydde St Giles, gent 2
5149337 2400939 2400939 defendant Clerk William gent 633639 633639 Clerk, William, of Tydde St Giles, gent 2
5149341 2400940 2400940 defendant Clerk William gent 633639 633639 Clerk, William, of Tydde St Giles, gent 2
5168315 2406449 2406449 defendant Clerk William gent 633639 633639 Clerk, William, of Tydde St Giles, gent 1
5212886 2419514 2419514 plaintiff Clerk William   633639 633639 Clerk, William, of Tydde St Giles 2
5212895 2419515 2419515 plaintiff Clerk William   633639 633639 Clerk, William, of Tydde St Giles 2
5212904 2419516 2419516 plaintiff Clerk William   633639 633639 Clerk, William, of Tydde St Giles 2
5215614 2420289 2420289 defendant Agge Richard   633639 633639 Agge, Richard, of Tydde St Giles, husbandman, or of Aylyswythorpe, Norf 0
5218990 2421283 2421283 defendant Houshold Simon chaplain 633639 633639 Houshold, Simon, of Tydde St Giles, chaplain 4
5234119 2425571 2425571 defendant Agge Richard husbandman 633639 633639 Agge, Richard, of Tydde St Giles, husbandman 0
5249077 2429850 2429850 defendant Pantry Thomas husbandman 633639 633639 Pantry, Thomas, of Tydde St Giles, husbandman 4
5249083 2429851 2429851 defendant Pantry Thoms husbandman 633639 633639 Pantry, Thoms, of Tydde St Giles, husbandman 4
5281026 2439528 2439528 plaintiff Clerk William, senior   633639 633639 Clerk, William, senior, of Tydde St Giles 0
5281029 2439529 2439529 plaintiff Clerk William, senior   633639 633639 Clerk, William, senior, of Tydde St Giles 0
5344291 2458396 2458396 plaintiff Thurston John   633639 633639 Thurston, John, of Tydde St Giles 0
5452635 2490673 2490673 plaintiff Thurston John   633639 633639 Thurston, John, of Tydde St Giles 0
5463119 2493883 2493883 plaintiff Ruttyr Thomas   633639 633639 Ruttyr, Thomas, of Tydde St Giles 0
5463902 2494121 2494121 defendant Hyrn John husbandman 633639 633639 Hyrn, John, of Tydde St Giles, husbandman 0
5464582 2494325 2494325 plaintiff Thurston John   633639 633639 Thurston, John, of Tydde St Giles 0
5487569 2501176 2501176 plaintiff Thurston John (legal representative) 633639 633639 Thurston, John, of Tydde St Giles, yeoman, executors of 0
5487573 2501176 2501176 plaintiff Ferrour Richard   633639 633639 Ferrour, Richard, of Tydde St Giles 4

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