names

32 rows where place_id = 586062

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587833 1863840 1863840 defendant Hobbes Richard gent 586062 586062 Hobbes, Richard, of Mulso, Bucks, gent 0
4768356 2286074 2286074 plaintiff Mulso alias Mulsho John, sen (legal representative) 586062 586062 Mulso alias Mulsho, John, sen, of Mulso, Bucks, maltman, executors of 0
4815444 2300933 2300933 defendant Hobbesson Nicholas maltman 586062 586062 Hobbesson, Nicholas, of Mulso, Bucks, maltman 1
4815459 2300939 2300939 defendant Hobbesson Nicholas maltman 586062 586062 Hobbesson, Nicholas, of Mulso, Bucks, maltman 1
4819168 2302074 2302074 defendant Hobbes Nicholas husbandman 586062 586062 Hobbes, Nicholas, of Mulso, Bucks, husbandman 0
4830742 2305643 2305643 defendant Pent Robert   586062 586062 Pent, Robert, of Mulso, Bucks, parson 0
4830745 2305644 2305644 defendant Pent Robert   586062 586062 Pent, Robert, of Mulso, Bucks, parson 0
4830748 2305645 2305645 defendant Pent Robert   586062 586062 Pent, Robert, of Mulso, Bucks, parson 0
4841985 2309032 2309032 defendant Wryght Thomas husbandman 586062 586062 Wryght, Thomas, of Mulso, Bucks, husbandman 2
4841991 2309033 2309033 defendant Wryght Thomas husbandman 586062 586062 Wryght, Thomas, of Mulso, Bucks, husbandman 2
4870270 2317674 2317674 defendant Hobbesson Thomas husbandman 586062 586062 Hobbesson, Thomas, of Mulso, Bucks, husbandman 1
4894032 2324834 2324834 defendant Hobbys Nicholas yeoman 586062 586062 Hobbys, Nicholas, of Mulso, Bucks, yeoman 0
4924031 2333955 2333955 defendant Hobbesson Hugh husbandman 586062 586062 Hobbesson, Hugh, of Mulso, Bucks, husbandman 0
4949353 2341784 2341784 defendant Hobson Hugh maltman 586062 586062 Hobson, Hugh, of Mulso, Bucks, maltman 1
4955365 2343561 2343561 defendant Everard John husbandman 586062 586062 Everard, John, of Mulso, Bucks, husbandman 0
4998350 2356380 2356380 defendant Halby John   586062 586062 Halby, John, of Mulso, Bucks, parson of the church 0
4998352 2356381 2356381 defendant Halby John   586062 586062 Halby, John, of Mulso, Bucks, parson of the church 0
5023697 2363837 2363837 defendant Wode Thomas husbandman 586062 586062 Wode, Thomas, of Mulso, Bucks, husbandman 2
5083517 2381571 2381571 defendant Hobbys Nicholas (legal representative) 586062 586062 Hobbys, Nicholas, of Mulso, Bucks, husbandman, executors of 4
5084357 2381831 2381831 defendant Hobbys Nicholas (legal representative) 586062 586062 Hobbys, Nicholas, of Mulso, Bucks, husbandman, executors of 4
5103604 2387481 2387481 defendant Eyre Richard husbandman 586062 586062 Eyre, Richard, of Mulso, Bucks, husbandman 0
5141065 2398509 2398509 defendant Paget (illegible) husbandman 586062 586062 Paget, ---, of Mulso, Bucks, husbandman 3
5162230 2404682 2404682 defendant Pagat John husbandman 586062 586062 Pagat, John, of Mulso, Bucks, husbandman 2
5162236 2404683 2404683 defendant Pagat John husbandman 586062 586062 Pagat, John, of Mulso, Bucks, husbandman 2
5163768 2405137 2405137 defendant Hobbes Richard gent 586062 586062 Hobbes, Richard, of Mulso, Bucks, gent 1
5176381 2408779 2408779 defendant Pagat John husbandman 586062 586062 Pagat, John, of Mulso, Bucks, husbandman 2
5186200 2411713 2411713 defendant Hobbys Richard gent 586062 586062 Hobbys, Richard, of Mulso, Bucks, gent 0
5205120 2417255 2417255 defendant Hobbys Richard gent 586062 586062 Hobbys, Richard, of Mulso, Bucks, gent 0
5380437 2469454 2469454 defendant Hobbys Richard gent 586062 586062 Hobbys, Richard, of Mulso, Bucks, gent 0
5384996 2470783 2470783 defendant Hobbys Richard gent 586062 586062 Hobbys, Richard, of Mulso, Bucks, gent 0
5384998 2470784 2470784 defendant Hobbys Richard gent 586062 586062 Hobbys, Richard, of Mulso, Bucks, gent 0
5455797 2491635 2491635 defendant Hobbys Richard gent 586062 586062 Hobbys, Richard, of Mulso, Bucks, gent 0

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