names

29 rows where place_id = 686712

✎ 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
4068122 2048905 2048905 defendant Fawkner Humphrey yeoman 686712 686712 Fawkner, Humphrey, of Roppesley, yeoman 0
4221086 2102870 2102870 defendant Newton Richard yeoman 686712 686712 Newton, Richard, of Roppesley, yeoman 0
4523236 2207591 2207591 defendant Welby Richard de   686712 686712 Welby, Richard de, of Roppesley 0
4578894 2224879 2224879 plaintiff Colby Alice   686712 686712 Colby, Alice, of Roppesley 0
4593554 2229261 2229261 defendant Pynder Nicholas   686712 686712 Pynder, Nicholas, of Roppesley 10
4593556 2229261 2229261 defendant Smyth William   686712 686712 Smyth, William, of Roppesley 12
4633542 2241345 2241345 defendant Welby Richard de   686712 686712 Welby, Richard de, of Roppesley 0
4657133 2248121 2248121 defendant Smyth Thomas yeoman 686712 686712 Smyth, Thomas, of Roppesley, yeoman 6
4692546 2263183 2263183 defendant Welby Richard gent 686712 686712 Welby, Richard, of Roppesley, gent 0
4738143 2277029 2277029 defendant Colby William husbandman 686712 686712 Colby, William, of Roppesley, husbandman 0
4768030 2285968 2285968 defendant Welby Richard   686712 686712 Welby, Richard, of Roppesley 0
4792493 2293739 2293739 defendant Welby Richard   686712 686712 Welby, Richard, of Roppesley 0
4919317 2332550 2332550 plaintiff Hewet William   686712 686712 Hewet, William, of Roppesley 0
4976659 2349976 2349976 defendant Colsterworth Robert husbandman 686712 686712 Colsterworth, Robert, of Roppesley, husbandman 2
4976664 2349977 2349977 defendant Colsterworth Robert husbandman 686712 686712 Colsterworth, Robert, of Roppesley, husbandman 2
4992194 2354560 2354560 defendant Howet William husbandman 686712 686712 Howet, William, of Roppesley, husbandman 0
4992195 2354560 2354560 defendant Masard William husbandman 686712 686712 Masard, William, of Roppesley, husbandman 1
4992196 2354560 2354560 defendant Parsons William husbandman 686712 686712 Parsons, William, of Roppesley, husbandman 2
4992197 2354560 2354560 defendant Welles Thomas husbandman 686712 686712 Welles, Thomas, of Roppesley, husbandman 3
4992198 2354560 2354560 defendant Frost William, sen husbandman 686712 686712 Frost, William, sen, of Roppesley, husbandman 4
4992199 2354560 2354560 defendant Agas Thomas husbandman 686712 686712 Agas, Thomas, of Roppesley, husbandman 5
4992200 2354560 2354560 defendant Frost John husbandman 686712 686712 Frost, John, of Roppesley, husbandman 6
5018837 2362398 2362398 defendant Howet William husbandman 686712 686712 Howet, William, of Roppesley, husbandman 0
5018838 2362398 2362398 defendant Masard William husbandman 686712 686712 Masard, William, of Roppesley, husbandman 1
5018839 2362398 2362398 defendant Persons William husbandman 686712 686712 Persons, William, of Roppesley, husbandman 2
5018840 2362398 2362398 defendant Wellys Thomas husbandman 686712 686712 Wellys, Thomas, of Roppesley, husbandman 3
5018841 2362398 2362398 defendant Frost William, senior husbandman 686712 686712 Frost, William, senior, of Roppesley, husbandman 4
5018842 2362398 2362398 defendant Agas Thomas husbandman 686712 686712 Agas, Thomas, of Roppesley, husbandman 5
5018843 2362398 2362398 defendant Frost John husbandman 686712 686712 Frost, John, of Roppesley, husbandman 6

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