names

29 rows where place_id = 609837

✎ 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
3680603 1920014 1920014 defendant Morton Charles gent 609837 609837 Morton, Charles, of Bautre, gent 0
3680765 1920065 1920065 defendant Morton Charles gent 609837 609837 Morton, Charles, of Bautre, gent 0
4460833 2188451 2188451 plaintiff Smyth Robert   609837 609837 Smyth, Robert, of Bautre 0
4522646 2207422 2207422 plaintiff Gull Margaret   609837 609837 Gull, Margaret, of Bautre 0
4524671 2208052 2208052 defendant Cook Thomas   609837 609837 Cook, Thomas, of Bautre 1
4524672 2208052 2208052 defendant Castre John   609837 609837 Castre, John, of Bautre 2
4527191 2208784 2208784 defendant Morton Robert (legal representative) 609837 609837 Morton, Robert, of Bautre, executrix of 0
4549188 2215684 2215684 defendant Wyston Richard   609837 609837 Wyston, Richard, of Bautre, ferry man 0
4551954 2216562 2216562 defendant Taverner William   609837 609837 Taverner, William, of Bautre 6
4558573 2218637 2218637 defendant Taverner William   609837 609837 Taverner, William, of Bautre 0
4565180 2220682 2220682 plaintiff Skynner John   609837 609837 Skynner, John, of Bautre 0
4595177 2229746 2229746 defendant Huberd John   609837 609837 Huberd, John, of Bautre 0
4606337 2233097 2233097 defendant Dugmanton Henry   609837 609837 Dugmanton, Henry, of Bautre 2
4614609 2235577 2235577 defendant Hoberd John   609837 609837 Hoberd, John, of Bautre 0
4619963 2237225 2237225 plaintiff Hubert John   609837 609837 Hubert, John, of Bautre 0
4633361 2241288 2241288 defendant Kychyn Richard de   609837 609837 Kychyn, Richard de, of Bautre 0
4753617 2281502 2281502 plaintiff Wath Thomas de   609837 609837 Wath, Thomas de, of Bautre 0
4826500 2304326 2304326 defendant Morton Charles gent 609837 609837 Morton, Charles, of Bautre, gent 0
4826504 2304327 2304327 defendant Morton Charles gent 609837 609837 Morton, Charles, of Bautre, gent 0
4880538 2320823 2320823 defendant Justice John chapman 609837 609837 Justice, John, of Bautre, chapman 0
4918167 2332202 2332202 defendant Bysshop Thomas husbandman 609837 609837 Bysshop, Thomas, of Bautre, husbandman 3
5011107 2360100 2360100 defendant Smyth Nicholas smith 609837 609837 Smyth, Nicholas, of Bautre, smith 0
5228757 2424022 2424022 defendant Phelip John shipman 609837 609837 Phelip, John, of Bautre, shipman 2
5304917 2446476 2446476 defendant Byrley William husbandman 609837 609837 Byrley, William, of Bautre, husbandman 0
5324476 2452406 2452406 defendant Byreley William yeoman 609837 609837 Byreley, William, of Bautre, yeoman 0
5324477 2452406 2452406 defendant Draper Richard draper 609837 609837 Draper, Richard, of Bautre, draper 1
5351854 2460683 2460683 defendant Fulwode Thomas shipman 609837 609837 Fulwode, Thomas, of Bautre, shipman 0
5502921 2505826 2505826 defendant Dugmanton John gent 609837 609837 Dugmanton, John, of Bautre, gent 2
5502922 2505826 2505826 defendant Whitladale John yeoman 609837 609837 Whitladale, John, of Bautre, yeoman 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);