names

25 rows where place_id = 772296

✎ 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
4587319 2227443 2227443 plaintiff Hulle Roger   772296 772296 Hulle, Roger, of Great Brickhill 0
4907802 2329001 2329001 defendant Merydale William yeoman 772296 772296 Merydale, William, of Great Brickhill, yeoman 0
4911206 2330012 2330012 defendant Hille John yeoman 772296 772296 Hille, John, of Great Brickhill, yeoman 0
5010681 2359991 2359991 defendant Hobbes Geoffrey yeoman 772296 772296 Hobbes, Geoffrey, of Great Brickhill, yeoman 2
5010747 2360000 2360000 defendant Hobbes Geoffrey yeoman 772296 772296 Hobbes, Geoffrey, of Great Brickhill, yeoman 1
5044903 2370112 2370112 defendant Hobbys Roger maltman 772296 772296 Hobbys, Roger, of Great Brickhill, maltman 0
5155780 2402853 2402853 defendant Howes John husbandman 772296 772296 Howes, John, of Great Brickhill, husbandman 0
5160226 2404087 2404087 defendant Merydale William yeoman 772296 772296 Merydale, William, of Great Brickhill, yeoman 0
5172261 2407611 2407611 defendant Howes John husbandman 772296 772296 Howes, John, of Great Brickhill, husbandman 0
5175073 2408404 2408404 defendant Merydale William yeoman 772296 772296 Merydale, William, of Great Brickhill, yeoman 0
5197731 2415080 2415080 defendant Merydale William yeoman 772296 772296 Merydale, William, of Great Brickhill, yeoman 0
5210258 2418728 2418728 defendant Merydale William yeoman 772296 772296 Merydale, William, of Great Brickhill, yeoman 0
5211246 2419017 2419017 defendant Hunt John yeoman 772296 772296 Hunt, John, of Great Brickhill, yeoman 3
5268680 2435957 2435957 defendant Merydale Robert clerk 772296 772296 Merydale, Robert, of Great Brickhill, clerk 3
5273046 2437191 2437191 defendant Meridale Thomas yeoman 772296 772296 Meridale, Thomas, of Great Brickhill, yeoman 2
5304722 2446408 2446408 defendant Spenser William yeoman 772296 772296 Spenser, William, of Great Brickhill, yeoman 0
5305271 2446580 2446580 defendant Merydale Thomas yeoman 772296 772296 Merydale, Thomas, of Great Brickhill, yeoman 0
5450685 2490091 2490091 defendant Sheperd William   772296 772296 Sheperd, William, of Great Brickhill 1
5450686 2490091 2490091 defendant H_ William husbandman 772296 772296 H_, William, of Great Brickhill, husbandman 2
5450687 2490091 2490091 defendant Spenser John husbandman 772296 772296 Spenser, John, of Great Brickhill, husbandman 3
5450688 2490091 2490091 defendant Clerk Thomas husbandman 772296 772296 Clerk,Thomas, of Great Brickhill, husbandman 4
5462826 2493791 2493791 defendant Sheperd William husbandman 772296 772296 Sheperd, William, of Great Brickhill, husbandman 1
5462827 2493791 2493791 defendant Hill William husbandman 772296 772296 Hill, William, of Great Brickhill, husbandman 2
5462828 2493791 2493791 defendant Spenser John husbandman 772296 772296 Spenser, John, of Great Brickhill, husbandman 3
5462829 2493791 2493791 defendant Clerke Thomas husbandman 772296 772296 Clerke, Thomas, of Great Brickhill, husbandman 4

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