names

41 rows where place_id = 609299

✎ 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
3677864 1919129 1919129 defendant Showell Thomas clothman 609299 609299 Showell, Thomas, of Echyngham, Sussex, clothman 2
4666375 2250958 2250958 defendant Harmere William yeoman 609299 609299 Harmere, William, of Echyngham, Sussex, yeoman 0
4703648 2266519 2266519 defendant Harmere William husbandman 609299 609299 Harmere, William, of Echyngham, Sussex, husbandman 0
4704211 2266692 2266692 defendant Harmere William husbandman 609299 609299 Harmere, William, of Echyngham, Sussex, husbandman 0
4704214 2266693 2266693 defendant Payn Thomas husbandman 609299 609299 Payn, Thomas, of Echyngham, Sussex, husbandman 1
4813655 2300378 2300378 defendant Harmere William yeoman 609299 609299 Harmere, William, of Echyngham, Sussex, yeoman 0
4813665 2300382 2300382 defendant Harmere William yeoman 609299 609299 Harmere, William, of Echyngham, Sussex, yeoman 0
4833599 2306517 2306517 defendant Echyngham Thomas   609299 609299 Echyngham, Thomas, of Echyngham, Sussex, knight 0
4840576 2308593 2308593 defendant Harmer William husbandman 609299 609299 Harmer, William, of Echyngham, Sussex, husbandman 0
4880419 2320785 2320785 defendant Harmere John husbandman 609299 609299 Harmere, John, of Echyngham, Sussex, husbandman 0
4916604 2331700 2331700 defendant Harmere John yeoman 609299 609299 Harmere, John, of Echyngham, Sussex, yeoman 3
4951382 2342395 2342395 defendant Echyngham Thomas   609299 609299 Echyngham, Thomas, of Echyngham, Sussex, knight 0
4951402 2342400 2342400 defendant Echyngham Thomas   609299 609299 Echyngham, Thomas, of Echyngham, Sussex, knight 0
4962822 2345792 2345792 defendant Echyngham Thomas   609299 609299 Echyngham, Thomas, of Echyngham, Sussex, knight 0
4977167 2350128 2350128 defendant Sheeswell William gent 609299 609299 Sheeswell, William, of Echyngham, Sussex, gent 0
4977169 2350129 2350129 defendant Shoeswell William gent 609299 609299 Shoeswell, William, of Echyngham, Sussex, gent 0
4996699 2355869 2355869 defendant Shoyswell William gent 609299 609299 Shoyswell, William, of Echyngham, Sussex, gent 0
5109734 2389274 2389274 defendant Echyngham Thomas esq 609299 609299 Echyngham, Thomas, of Echyngham, Sussex, esq 1
5109885 2389318 2389318 defendant Echyngham Thomas esq 609299 609299 Echyngham, Thomas, of Echyngham, Sussex, esq 1
5142084 2398805 2398805 defendant Echyngham Thomas esq 609299 609299 Echyngham, Thomas, of Echyngham, sussex, esq 1
5163242 2404980 2404980 defendant Echyngham Thomas esq 609299 609299 Echyngham, Thomas, of Echyngham, Sussex, esq 1
5221404 2421960 2421960 defendant Echyngham Thomas   609299 609299 Echyngham, Thomas, of Echyngham, Sussex, knight 0
5228585 2423967 2423967 defendant Echyngham Thomas esq 609299 609299 Echyngham, Thomas, of Echyngham, Sussex, esq 0
5237872 2426660 2426660 defendant Echyngham Thomas   609299 609299 Echyngham, Thomas, of Echyngham, Sussex, knight 1
5237877 2426661 2426661 defendant Echyngham Thomas   609299 609299 Echyngham, Thomas, of Echyngham, Sussex, knight 1
5274292 2437562 2437562 defendant Echyngham Thomas   609299 609299 Echyngham, Thomas, of Echyngham, Sussex, knight 0
5278871 2438931 2438931 defendant Echyngham Thomas   609299 609299 Echyngham, Thomas, of Echyngham, Sussex, knight 0
5278875 2438932 2438932 defendant Echyngham Thomas   609299 609299 Echyngham, Thomas, of Echyngham, Sussex, knight 0
5288128 2441546 2441546 defendant Echyngham Thomas   609299 609299 Echyngham, Thomas, of Echyngham, Sussex, knight 0
5302784 2445815 2445815 defendant Echyngham Thomas   609299 609299 Echyngham, Thomas, of Echyngham, Sussex, knight, formerly esquire 0
5340534 2457237 2457237 defendant Juddes John gent 609299 609299 Juddes, John, of Echyngham, Sussex, gent 0
5344089 2458330 2458330 defendant Echyngham Thomas esq 609299 609299 Echyngham, Thomas, of Echyngham, Sussex, esq 0
5361732 2463698 2463698 defendant Echyngham Thomas   609299 609299 Echyngham, Thomas, of Echyngham, Sussex, knight 0
5370344 2466313 2466313 defendant Shoswell John, junior   609299 609299 Shoswell, John, junior, of Echyngham, Sussex, gent & son of John, senior 0
5377915 2468668 2468668 defendant Echyngham Thomas   609299 609299 Echyngham, Thomas, of Echyngham, Sussex, knight 0
5429136 2483641 2483641 defendant Shoswell John   609299 609299 Shoswell, John, of Echyngham, Sussex, gent, son of John 0
5455336 2491513 2491513 defendant Benyn William chaplain 609299 609299 Benyn, William, of Echyngham, Sussex, chaplain 1
5455339 2491514 2491514 defendant Benyn William chaplain 609299 609299 Benyn, William, of Echyngham, Sussex, chaplain 1
5470512 2496100 2496100 defendant Benyn William chaplain 609299 609299 Benyn, William, of Echyngham, Sussex, chaplain 1
5481921 2499524 2499524 defendant Shoswell John, junior gent 609299 609299 Shoswell, John, junior, of Echyngham, Sussex, gent, son of Shoswell, John, senior, of Echyngham, gent 0
5602609 2535708 2535708 defendant Oxenbrygge Godard   609299 609299 Oxenbrygge, Godard, of Echyngham, Sussex, knight 2

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