names

14 rows where place_id = 688915

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3696741 1925206 1925206 defendant Burnham Thomas   688915 688915 Burnham, Thomas, of Becles, vestment maker 0
4078032 2052445 2052445 defendant Hadnam or Hedenham Thomas yeoman 688915 688915 Hadnam or Hedenham, Thomas, of Becles, yeoman 1
4194369 2093581 2093581 defendant Middleton Richard tailor 688915 688915 Middleton, Richard, of Becles, tailor 0
4194370 2093581 2093581 defendant Brigg Roger tailor 688915 688915 Brigg, Roger, of Becles, tailor 1
4194371 2093581 2093581 defendant Waters Henry fishmonger 688915 688915 Waters, Henry, of Becles, fishmonger 2
4202740 2096502 2096502 defendant Smythe Francis yeoman 688915 688915 Smythe, Francis, of Becles, yeoman 0
4274362 2120977 2120977 defendant Broun William carpenter 688915 688915 Broun, William, of Becles, carpenter 2
4519479 2206451 2206451 plaintiff Ely William master & parson 688915 688915 Ely, William, of Becles, master & parson 0
4562796 2219923 2219923 defendant Hole Henry   688915 688915 Hole, Henry, of Becles 0
4583821 2226357 2226357 plaintiff Fysshere Robert   688915 688915 Fysshere, Robert, of Becles 0
4658494 2248534 2248534 defendant Lyster John mercer 688915 688915 Lyster, John, of Becles, mercer 6
4666444 2250982 2250982 defendant Roode John (legal representative) 688915 688915 Roode, John, of Becles, executors of 0
4666445 2250982 2250982 defendant Roode Walter   688915 688915 (Roode, Walter, of Becles 1
5615232 2548560 2548560 defendant Bra Richard de fuller 688915 688915 Bra, Richard de, of Becles, fuller 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);