names

30 rows where place_id = 618239

✎ 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
3723538 1933632 1933632 defendant Bull Alexander smith 618239 618239 Bull, Alexander, of Magna Wenden, smith 1
3761344 1945556 1945556 defendant Felsted John husbandman 618239 618239 Felsted, John, of Magna Wenden, husbandman 0
3787326 1953827 1953827 defendant Felsted John husbandman 618239 618239 Felsted, John, of Magna Wenden, husbandman 2
3791690 1955246 1955246 defendant Jen William husbandman 618239 618239 Jen, William, of Magna Wenden, husbandman 1
3894474 1988359 1988359 defendant Maunsfeld John carpenter 618239 618239 Maunsfeld, John, of Magna Wenden, carpenter 0
3902456 1991052 1991052 defendant Watson Robert husbandman 618239 618239 Watson, Robert, of Magna Wenden, husbandman 0
3902457 1991052 1991052 defendant Kyng John, senior   618239 618239 Kyng, John, senior, of Magna Wenden, wheelwright 1
4002857 2025789 2025789 plaintiff Hockley Thomas yeoman 618239 618239 Hockley, Thomas, of Magna Wenden, yeoman 0
4090188 2056778 2056778 defendant Holden William   618239 618239 Holden, William, of Magna Wenden, yeoman, bailiff 1
4801403 2296624 2296624 defendant Norton Reginald husbandman 618239 618239 Norton, Reginald, of Magna Wenden, husbandman 2
4801429 2296627 2296627 defendant Norton Reginald husbandman 618239 618239 Norton, Reginald, of Magna Wenden, husbandman 2
4937096 2337974 2337974 defendant Elys William husbandman 618239 618239 Elys, William, of Magna Wenden, husbandman 0
4937097 2337974 2337974 defendant Neuman Andrew husbandman 618239 618239 Neuman, Andrew, of Magna Wenden, husbandman 1
4945324 2340514 2340514 defendant Martyn William smith 618239 618239 Martyn, William, of Magna Wenden, smith 0
4946787 2340998 2340998 defendant Neweman Andrew husbandman 618239 618239 Neweman, Andrew, of Magna Wenden, husbandman 0
4953882 2343125 2343125 defendant Neweman Andrew husbandman 618239 618239 Neweman, Andrew, of Magna Wenden, husbandman 1
4953885 2343126 2343126 defendant Neweman Andrew husbandman 618239 618239 Neweman, Andrew, of Magna Wenden, husbandman 1
4962503 2345687 2345687 defendant Pecok John carpenter 618239 618239 Pecok, John, of Magna Wenden, carpenter 4
4962519 2345693 2345693 defendant Newman Andrew husbandman 618239 618239 Newman, Andrew, of Magna Wenden, husbandman 0
4968137 2347418 2347418 defendant Neweman Andrew husbandman 618239 618239 Neweman, Andrew, of Magna Wenden, husbandman 0
4972840 2348814 2348814 defendant Neweman Andrew husbandman 618239 618239 Neweman, Andrew, of Magna Wenden, husbandman 0
4979787 2350910 2350910 defendant Neuman Andrew husbandman 618239 618239 Neuman, Andrew, of Magna Wenden, husbandman 3
4980062 2350987 2350987 defendant Neweman Andrew farmer 618239 618239 Neweman, Andrew, of Magna Wenden, farmer 2
5064427 2375900 2375900 defendant Elyce William husbandman 618239 618239 Elyce, William, of Magna Wenden, husbandman 0
5078784 2380142 2380142 defendant Elys Nicholas ywoman 618239 618239 Elys, Nicholas, of Magna Wenden, ywoman 0
5257577 2432488 2432488 defendant Perton John husbandman 618239 618239 Perton, John, of Magna Wenden, husbandman 0
5545571 2518688 2518688 defendant Rycard William husbandman 618239 618239 Rycard, William, of Magna Wenden, husbandman 1
5603025 2535831 2535831 defendant Page John laborer 618239 618239 Page, John, of Magna Wenden, laborer 1
5603026 2535831 2535831 defendant Totenham John, senior laborer 618239 618239 Totenham, John, senior, of Magna Wenden, laborer 2
5603027 2535831 2535831 defendant Totenham Thomas laborer 618239 618239 Totenham, Thomas, of Magna Wenden, laborer 3

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