names

28 rows where place_id = 588009

✎ 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
3593088 1865466 1865466 defendant Ruggeley Richard esq 588009 588009 Ruggeley, Richard, of Longdon, Staffs, esq 0
3801442 1958371 1958371 defendant Ruggeley Humphrey gent 588009 588009 Ruggeley, Humphrey, of Longdon, Staffs, gent 0
4042264 2039713 2039713 defendant Broughton Edward gent 588009 588009 Broughton, Edward, of Longdon, Staffs, gent 0
4103710 2061600 2061600 defendant Massey William yeoman 588009 588009 Massey, William, of Longdon, Staffs, yeoman 0
4111675 2064425 2064425 defendant Midlemore William merchant 588009 588009 Midlemore, William, of Longdon, Staffs, merchant 0
4111677 2064426 2064426 defendant Myddelmore William gent 588009 588009 Myddelmore, William, of Longdon, Staffs, gent 0
4111684 2064428 2064428 defendant Myddlemore William gent 588009 588009 Myddlemore, William, of Longdon, Staffs, gent 0
4111685 2064428 2064428 defendant Barnes William gent 588009 588009 Barnes, William, of Longdon, Staffs, gent 1
4155030 2079850 2079850 defendant Browghton Richard gent 588009 588009 Browghton, Richard, of Longdon, Staffs, gent 0
4245347 2111420 2111420 defendant Marshall John yeoman 588009 588009 Marshall, John, of Longdon, Staffs, yeoman 1
4245352 2111421 2111421 defendant Marshall John yeoman 588009 588009 Marshall, John, of Longdon, Staffs, yeoman 1
4258919 2115955 2115955 defendant Lynacre John gent 588009 588009 Lynacre, John, of Longdon, Staffs, gent 1
4270766 2119799 2119799 defendant Lynacre John gent 588009 588009 Lynacre, John, of Longdon, Staffs, gent 1
4364362 2152314 2152314 defendant Littleton Thomas gent 588009 588009 Littleton, Thomas, of Longdon, Staffs, gent 0
4708816 2268127 2268127 defendant Knave William husbandman 588009 588009 Knave, William, of Longdon, Staffs, husbandman 2
4946859 2341025 2341025 defendant Broughton William gent 588009 588009 Broughton, William, of Longdon, Staffs, gent 1
4951783 2342509 2342509 defendant Arblaster Thomas, junior gent 588009 588009 Arblaster, Thomas, junior, of Longdon, Staffs, gent 0
5181506 2410333 2410333 defendant Arblaster Thomas esq 588009 588009 Arblaster, Thomas, of Longdon, Staffs, esq 2
5181609 2410363 2410363 defendant Arblaster Thomas esq 588009 588009 Arblaster, Thomas, of Longdon, Staffs, esq 2
5203031 2416646 2416646 defendant Arblaster Thomas esq 588009 588009 Arblaster, Thomas, of Longdon, Staffs, esq 2
5251297 2430508 2430508 defendant Arblastre Thomas gent 588009 588009 Arblastre, Thomas, of Longdon, Staffs, gent 0
5290898 2442343 2442343 defendant Alblaster Thomas esq 588009 588009 Alblaster, Thomas, of Longdon, Staffs, esq 2
5356236 2462028 2462028 defendant Arblaster Thomas esq 588009 588009 Arblaster, Thomas, of Longdon, Staffs, esq 2
5415679 2479633 2479633 defendant Arblaster Thomas esq 588009 588009 Arblaster, Thomas, of Longdon, Staffs, esq 3
5432388 2484658 2484658 defendant Arblaster Thomas esq 588009 588009 Arblaster, Thomas, of Longdon, Staffs, esq 3
5510349 2508075 2508075 defendant Ruggeley Richard esq 588009 588009 Ruggeley, Richard, of Longdon, Staffs, esq 0
5510351 2508076 2508076 defendant Ruggeley Richard esq 588009 588009 Ruggeley, Richard, of Longdon, Staffs, esq 0
5514829 2509483 2509483 plaintiff Ruggeley Richard esq 588009 588009 Ruggeley, Richard, of Longdon, Staffs, esq 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);