names

32 rows where place_id = 606505

✎ 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
3665432 1915138 1915138 defendant Wattys Lawrence yeoman 606505 606505 Wattys, Lawrence, of Mulso, yeoman 6
3665433 1915138 1915138 defendant Bettys Thomas yeoman 606505 606505 Bettys, Thomas, of Mulso, yeoman 7
3788728 1954277 1954277 defendant Bacon Richard clerk 606505 606505 Bacon, Richard, of Mulso, clerk 1
4587828 2227596 2227596 plaintiff Jeffeson William   606505 606505 Jeffeson, William, of Mulso 0
4635071 2241816 2241816 defendant Hobson John   606505 606505 Hobson, John, of Mulso 0
4641272 2243541 2243541 defendant Hobbes Nicholas   606505 606505 Hobbes, Nicholas, of Mulso 0
4746839 2279577 2279577 defendant Haytour Henry husbandman 606505 606505 Haytour, Henry, of Mulso, husbandman 0
4766924 2285645 2285645 defendant Milton John husbandman 606505 606505 Milton, John, of Mulso, husbandman 2
4767182 2285721 2285721 defendant Castelton John husbandman 606505 606505 Castelton, John, of Mulso, husbandman 0
4768358 2286074 2286074 plaintiff Mulso John   606505 606505 Mulso, John, of Mulso 2
4790144 2292998 2292998 defendant Moreton John gent 606505 606505 Moreton, John, of Mulso, gent 0
4800540 2296350 2296350 defendant Hobbes Nicholas husbandman 606505 606505 Hobbes, Nicholas, of Mulso, husbandman 0
4801904 2296780 2296780 defendant Morton John gent 606505 606505 Morton, John, of Mulso, gent 4
4813585 2300356 2300356 defendant Hobsone Thomas husbandman 606505 606505 Hobsone, Thomas, of Mulso, husbandman 0
4813590 2300358 2300358 defendant Haytour Henry husbandman 606505 606505 Haytour, Henry, of Mulso, husbandman 0
4813592 2300358 2300358 defendant Hobbesson Hugh husbandman 606505 606505 with Hobbesson, Hugh, of Mulso, husbandman 2
4813593 2300358 2300358 defendant Clerk Richard husbandman 606505 606505 Clerk, Richard, of Mulso, husbandman 3
4909011 2329361 2329361 defendant Valet John husbandman 606505 606505 Valet, John, of Mulso, husbandman 4
4922776 2333536 2333536 defendant Hobbes Thomas husbandman 606505 606505 Hobbes, Thomas, of Mulso, husbandman 0
4944256 2340177 2340177 defendant Hobbesson Hugh husbandman 606505 606505 Hobbesson, Hugh, of Mulso, husbandman 0
4944258 2340178 2340178 defendant Hobbesson Nicholas husbandman 606505 606505 Hobbesson, Nicholas, of Mulso, husbandman 0
4960100 2344988 2344988 defendant Kent John yeoman 606505 606505 Kent, John, of Mulso, yeoman 0
4991607 2354372 2354372 defendant Archer Richard husbandman 606505 606505 Archer, Richard, of Mulso, husbandman 0
5031864 2366191 2366191 defendant Adam Robert yeoman 606505 606505 Adam, Robert, of Mulso, yeoman 4
5038029 2368005 2368005 defendant Wyllemot Richard maltman 606505 606505 Wyllemot, Richard, of Mulso, maltman 1
5070146 2377565 2377565 defendant Pagot John husbandman 606505 606505 Pagot, John, of Mulso, husbandman 0
5084358 2381831 2381831 defendant Hobbys Joan widow 606505 606505 (Hobbys, Joan, of Mulso, widow 5
5097533 2385708 2385708 defendant Adam Robert yeoman 606505 606505 Adam, Robert, of Mulso, yeoman 1
5220496 2421690 2421690 defendant Hobbes Richard gent 606505 606505 Hobbes, Richard, of Mulso, gent 0
5627088 2552439 2552439 defendant Morton John husbandman 606505 606505 Morton, John, of Mulso, husbandman 0
5627089 2552439 2552439 defendant Hayton Henry husbandman 606505 606505 Hayton, Henry, of Mulso, husbandman 1
5627090 2552439 2552439 defendant Charche John husbandman 606505 606505 Charche, John, of Mulso, husbandman 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);