names

25 rows where place_id = 586333

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588452 1864036 1864036 defendant Alye Richard tailor 586333 586333 Alye, Richard, of Magna Badowe, Essex, tailor 0
3635771 1905988 1905988 defendant Amys Edward gent 586333 586333 Amys, Edward, of Magna Badowe, Essex, gent 1
3687160 1922160 1922160 defendant Naylynghurst John gent 586333 586333 Naylynghurst, John, of Magna Badowe, Essex, gent 0
3822059 1964793 1964793 defendant Taverner William yeoman 586333 586333 Taverner, William, of Magna Badowe, Essex, yeoman 2
3828006 1966625 1966625 defendant Clowes John clerk 586333 586333 Clowes, John, of Magna Badowe, Essex, clerk 0
3828009 1966626 1966626 defendant Clowes John clerk 586333 586333 Clowes, John, of Magna Badowe, Essex, clerk 0
3842804 1971282 1971282 defendant Clowes John clerk 586333 586333 Clowes, John, of Magna Badowe, Essex, clerk 0
3850663 1973795 1973795 defendant Butler John gent 586333 586333 Butler, John, of Magna Badowe, Essex, gent 3
3951935 2007740 2007740 defendant Trewlove John yeoman 586333 586333 Trewlove, John, of Magna Badowe, Essex, yeoman 0
4100943 2060653 2060653 defendant Grave Henry yeoman 586333 586333 Grave, Henry, of Magna Badowe, Essex, yeoman 0
4101027 2060683 2060683 defendant Cooke Robert yeoman 586333 586333 Cooke, Robert, of Magna Badowe, Essex, yeoman 0
4354738 2148882 2148882 defendant Malden John chapman 586333 586333 Malden, John, of Magna Badowe, Essex, chapman 1
4883639 2321796 2321796 defendant Banstret Thomas husbandman 586333 586333 Banstret, Thomas, of Magna Badowe, Essex, husbandman 2
4889203 2323410 2323410 defendant Banstret Thomas husbandman 586333 586333 Banstret, Thomas, of Magna Badowe, Essex, husbandman 2
5223533 2422571 2422571 defendant Selby John   586333 586333 Selby, John, of Magna Badowe, Essex, chaplain, parson of Bulnest, Beds 2
5294588 2443395 2443395 defendant Sandon John husbandman 586333 586333 Sandon, John, of Magna Badowe, Essex, husbandman 0
5314027 2449218 2449218 defendant Gryme John barker 586333 586333 Gryme, John, of Magna Badowe, Essex, barker 0
5487393 2501123 2501123 defendant Baker Thomas sheather 586333 586333 Baker, Thomas, of Magna Badowe, Essex, sheather 3
5509814 2507905 2507905 defendant Wheler John tanner 586333 586333 Wheler, John, of Magna Badowe, Essex, tanner 0
5509817 2507906 2507906 defendant Wheler John tanner 586333 586333 Wheler, John, of Magna Badowe, Essex, tanner 0
5518771 2510706 2510706 defendant Sabright William gent 586333 586333 Sabright, William, of Magna Badowe, Essex, gent 0
5525697 2512628 2512628 defendant Naylyngherst Clement gent 586333 586333 Naylyngherst, Clement, of Magna Badowe, Essex, gent 3
5529528 2513734 2513734 defendant Hull John blacksmith 586333 586333 Hull, John, of Magna Badowe, Essex, blacksmith 2
5573579 2526838 2526838 defendant Artour John (legal representative) 586333 586333 Artour, John, of Magna Badowe, Essex, yeoman, executor of 4
5573586 2526839 2526839 defendant Artour John (legal representative) 586333 586333 Artour, John, of Magna Badowe, Essex, yeoman, executor of 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);