names

22 rows where place_id = 594581

✎ 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
3616681 1872847 1872847 defendant Herward Thomas butcher 594581 594581 Herward, Thomas, of Southcreyk, butcher 0
4783162 2290750 2290750 defendant Godfrey Edmund husbandman 594581 594581 Godfrey, Edmund, of Southcreyk, husbandman 0
4784685 2291216 2291216 defendant Harde Thomas yeoman 594581 594581 Harde, Thomas, of Southcreyk, yeoman 0
4784686 2291216 2291216 defendant Harde William yeoman 594581 594581 Harde, William, of Southcreyk, yeoman 1
4784687 2291216 2291216 defendant Auntell John yeoman 594581 594581 Auntell, John, of Southcreyk, yeoman 2
4784688 2291216 2291216 defendant Lysse John yeoman 594581 594581 Lysse, John, of Southcreyk, yeoman 3
4787903 2292284 2292284 plaintiff Hard William   594581 594581 Hard, William, of Southcreyk 0
4874548 2318984 2318984 defendant Hard William yeoman 594581 594581 Hard, William, of Southcreyk, yeoman 0
4943159 2339832 2339832 defendant Legge John gent 594581 594581 Legge, John, of Southcreyk, gent 0
4957264 2344137 2344137 defendant Harde William yeoman 594581 594581 Harde, William, of Southcreyk, yeoman 0
4970088 2348005 2348005 plaintiff Hard William yeoman 594581 594581 Hard, William, of Southcreyk, yeoman 0
5057067 2373692 2373692 defendant Lyne John yeoman 594581 594581 Lyne, John, of Southcreyk, yeoman 1
5060039 2374566 2374566 defendant Lyne John husbandman 594581 594581 Lyne, John, of Southcreyk, husbandman 0
5116069 2391129 2391129 plaintiff Norton John   594581 594581 Norton, John, of Southcreyk 0
5238368 2426809 2426809 plaintiff Hard William   594581 594581 Hard, William, of Southcreyk 2
5277290 2438439 2438439 plaintiff Allard John   594581 594581 Allard, John, of Southcreyk 0
5325560 2452721 2452721 defendant Denys Edmund husbandman 594581 594581 Denys, Edmund, of Southcreyk, husbandman 0
5496113 2503734 2503734 defendant Norton John yeoman 594581 594581 Norton, John, of Southcreyk, yeoman 1
5522754 2511943 2511943 defendant Legge Edmund yeoman 594581 594581 Legge, Edmund, of Southcreyk, yeoman 0
5530834 2514158 2514158 defendant Fyske Robert husbandman 594581 594581 Fyske, Robert, of Southcreyk, husbandman 2
5544795 2518483 2518483 defendant Suffolk Richard   594581 594581 Suffolk, Richard, of Southcreyk, shepherd 0
5544796 2518483 2518483 defendant Bryght William   594581 594581 Bryght, William, of Southcreyk, shepherd 1

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