names

43 rows where place_id = 599961

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3639053 1907037 1907037 plaintiff Walle John   599961 599961 Walle, John, of Aldeby 0
3656457 1912266 1912266 defendant Elyse William husbandman 599961 599961 Elyse, William, of Aldeby, husbandman 0
3703397 1927338 1927338 defendant Walle Ralph gent 599961 599961 Walle, Ralph, of Aldeby, gent 0
3703398 1927338 1927338 defendant Fenne Thomas laborer 599961 599961 Fenne, Thomas, of Aldeby, laborer 1
3712562 1930244 1930244 defendant Purry John husbandman 599961 599961 Purry, John, of Aldeby, husbandman 0
3841282 1970855 1970855 plaintiff Bayspole Thomas (legal representative) 599961 599961 Bayspole, Thomas, of Aldeby, executors of 0
3864666 1978380 1978380 defendant Stocon Robert husbandman 599961 599961 Stocon, Robert, of Aldeby, husbandman 0
3881733 1984141 1984141 defendant Lynde Thomas husbandman 599961 599961 Lynde, Thomas, of Aldeby, husbandman 0
3883417 1984721 1984721 defendant Bayspole Thomas yeoman 599961 599961 Bayspole, Thomas, of Aldeby, yeoman 4
3924830 1998623 1998623 defendant Celys John laborer 599961 599961 Celys, John, of Aldeby, laborer 2
3924831 1998623 1998623 defendant Gay John laborer 599961 599961 Gay, John, of Aldeby, laborer 3
4001032 2025143 2025143 defendant Acton Edmund yeoman 599961 599961 Acton, Edmund, of Aldeby, yeoman 0
4275416 2121337 2121337 defendant Baspoole Richard gent 599961 599961 Baspoole, Richard, of Aldeby, gent 0
4327920 2139662 2139662 defendant Eastgate John yeoman 599961 599961 Eastgate, John, of Aldeby, yeoman 0
4388445 2160773 2160773 defendant Joyse William husbandman 599961 599961 Joyse, William, of Aldeby, yeoman: Mawtill, John, of Aldeby, husbandman 0
4399112 2164287 2164287 defendant Osborne Mathew husbandman 599961 599961 Osborne, Mathew, of Aldeby, husbandman 1
4399113 2164287 2164287 defendant Burton Jasper husbandman 599961 599961 Burton, Jasper, of Aldeby, husbandman 2
4500633 2200820 2200820 defendant Warant Robert   599961 599961 Warant, Robert, of Aldeby 2
4561238 2219476 2219476 defendant Faldyate Peter   599961 599961 Faldyate, Peter, of Aldeby 1
4576485 2224158 2224158 defendant Sergeaunt Robert   599961 599961 Sergeaunt, Robert, of Aldeby, bailiff of the manor 0
4600533 2231388 2231388 defendant Mason Adam   599961 599961 Mason, Adam, of Aldeby 2
4683285 2260376 2260376 defendant Madour John yeoman 599961 599961 Madour, John, of Aldeby, yeoman 0
4688094 2261845 2261845 defendant Glaunvyle John, senior yeoman 599961 599961 Glaunvyle, John, senior, of Aldeby, yeoman 2
4688095 2261845 2261845 defendant Glaunvyle John, junior yeoman 599961 599961 Glaunvyle, John, junior, of Aldeby, yeoman 3
4709045 2268196 2268196 defendant Madour John yeoman 599961 599961 Madour, John, of Aldeby, yeoman 0
4725567 2273284 2273284 defendant Corpesty John yeoman 599961 599961 Corpesty, John, of Aldeby, yeoman 1
4730434 2274714 2274714 defendant Seriaunt Robert husbandman 599961 599961 Seriaunt, Robert, of Aldeby, husbandman 0
4748308 2280013 2280013 defendant Serviaunt Robert yeoman 599961 599961 Serviaunt, Robert, of Aldeby, yeoman 0
4889683 2323567 2323567 plaintiff Claumvyle Maud   599961 599961 Claumvyle, Maud, of Aldeby, administrators of 0
4967554 2347238 2347238 defendant Britth John husbandman 599961 599961 Britth, John, of Aldeby, husbandman 0
4969055 2347709 2347709 defendant Blome John, junior husbandman 599961 599961 Blome, John, junior, of Aldeby, husbandman 1
5016666 2361764 2361764 defendant Bocher William butcher 599961 599961 Bocher, William, of Aldeby, butcher 2
5384744 2470722 2470722 defendant Joye Thomas husbandman 599961 599961 Joye, Thomas, of Aldeby, husbandman 2
5395143 2473677 2473677 defendant Joye Thomas husbandman 599961 599961 Joye, Thomas, of Aldeby, husbandman 1
5409977 2477954 2477954 defendant (illegible) Thomas husbandman 599961 599961 _, Thomas, of Aldeby, husbandman 2
5409981 2477955 2477955 defendant Joye Thomas husbandman 599961 599961 Joye, Thomas, of Aldeby, husbandman 2
5423686 2482048 2482048 defendant Joye Thomas husbandman 599961 599961 Joye, Thomas, of Aldeby, husbandman 2
5561769 2523428 2523428 plaintiff Walle John   599961 599961 Walle, John, of Aldeby 0
5561770 2523428 2523428 defendant Dexter John carpenter 599961 599961 Dexter, John, of Aldeby, carpenter 0
5561771 2523428 2523428 defendant Joure Edmund husbandman 599961 599961 Joure, Edmund, of Aldeby, husbandman 1
5561791 2523434 2523434 plaintiff Wallys John   599961 599961 Wallys, John, of Aldeby 0
5561797 2523435 2523435 plaintiff Wallys John   599961 599961 Wallys, John, of Aldeby 0
5626881 2552380 2552380 defendant Holdelyne Geoffrey esq 599961 599961 Holdelyne, Geoffrey, of Aldeby, esq 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);