names

15 rows where place_id = 631799

✎ 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
3802787 1958767 1958767 defendant Fylder William husbandman 631799 631799 Fylder, William, of Shorwell, Isle of Wight, husbandman 0
3802789 1958768 1958768 defendant Fylder William husbandman 631799 631799 Fylder, William, of Shorwell, Isle of Wight, husbandman 0
3907668 1992855 1992855 defendant Holbroke Thomas husbandman 631799 631799 Holbroke, Thomas, of Shorwell, Isle of Wight, husbandman 0
4058442 2045406 2045406 defendant Marchant Thomas smith 631799 631799 Marchant, Thomas, of Shorwell, Isle of Wight, smith 0
4674312 2257573 2257573 defendant Holbrok George husbandman 631799 631799 Holbrok, George, of Shorwell, Isle of Wight, husbandman 0
4674314 2257574 2257574 defendant Holbrok William husbandman 631799 631799 Holbrok, William, of Shorwell, Isle of Wight, husbandman 0
4778869 2289366 2289366 defendant Jacob John laborer 631799 631799 Jacob, John, of Shorwell, Isle of Wight, laborer 1
5001823 2357431 2357431 defendant Moryng William husbandman 631799 631799 Moryng, William, of Shorwell, Isle of Wight, husbandman 1
5067783 2376865 2376865 defendant Mory John husbandman 631799 631799 Mory, John, of Shorwell, Isle of Wight, husbandman 0
5190241 2412888 2412888 defendant Payn Thomas husbandman 631799 631799 Payn, Thomas, of Shorwell, Isle of Wight, husbandman 1
5220760 2421762 2421762 defendant Smyth Richard smith 631799 631799 Smyth, Richard, of Shorwell, Isle of Wight, smith 0
5220761 2421762 2421762 defendant Moryng William husbandman 631799 631799 together with Moryng, William, of Shorwell, Isle of Wight, husbandman 1
5230215 2424457 2424457 defendant Bartelot Thomas   631799 631799 Bartelot, Thomas, of Shorwell, Isle of Wight, mason 0
5261738 2433780 2433780 defendant White William yeoman 631799 631799 White, William, of Shorwell, Isle of Wight, yeoman 0
5499100 2504671 2504671 plaintiff Pend John yeoman 631799 631799 Pend, John, of Shorwell, Isle of Wight, yeoman 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);