names

20 rows where place_id = 611069

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3686655 1921980 1921980 defendant Greneslade William husbandman 611069 611069 Greneslade, William, of Brompton Regis, husbandman 0
4079490 2052963 2052963 defendant Dey Thomas husbandman 611069 611069 Dey, Thomas, of Brompton Regis, husbandman 0
4079492 2052964 2052964 defendant Dey Thomas husbandman 611069 611069 Dey, Thomas, of Brompton Regis, husbandman 0
4205863 2097596 2097596 defendant Playce John weaver 611069 611069 Playce, John, of Brompton Regis, weaver 0
4368726 2153866 2153866 defendant Wood John yeoman 611069 611069 Wood, John, of Brompton Regis, yeoman 0
4368729 2153867 2153867 defendant Wood Roger   611069 611069 Wood, Roger, of Brompton Regis 0
4370857 2154632 2154632 defendant Wood John yeoman 611069 611069 Wood, John, of Brompton Regis, yeoman 0
4379252 2157660 2157660 defendant Westlake alias Comyne John husbandman 611069 611069 Westlake alias Comyne, John, of Brompton Regis, husbandman 0
4733041 2275513 2275513 defendant Hoper Adam husbandman 611069 611069 Hoper, Adam, of Brompton Regis, husbandman 0
4873083 2318536 2318536 defendant Wyther Walter husbandman 611069 611069 Wyther, Walter, of Brompton Regis, husbandman 1
4873084 2318536 2318536 defendant Kempe William husbandman 611069 611069 Kempe, William, of Brompton Regis, husbandman 2
4873085 2318536 2318536 defendant Bryan John husbandman 611069 611069 Bryan, John, of Brompton Regis, husbandman 3
4873086 2318536 2318536 defendant Smalemore Robert husbandman 611069 611069 Smalemore, Robert, of Brompton Regis, husbandman 4
4873087 2318536 2318536 defendant Lyncombe Richard husbandman 611069 611069 Lyncombe, Richard, of Brompton Regis, husbandman 5
4873088 2318536 2318536 defendant Walsheman John husbandman 611069 611069 Walsheman, John, of Brompton Regis, husbandman 6
5478296 2498536 2498536 defendant Bryan Thomas husbandman 611069 611069 Bryan, Thomas, of Brompton Regis, husbandman 0
5507076 2507123 2507123 defendant Shurcombe Robert husbandman 611069 611069 Shurcombe, Robert, of Brompton Regis, husbandman 0
5507077 2507123 2507123 defendant Joce William husbandman 611069 611069 Joce, William, of Brompton Regis, husbandman 1
5507078 2507123 2507123 defendant Yendall John husbandman 611069 611069 Yendall, John, of Brompton Regis, husbandman 2
5518359 2510569 2510569 defendant Yendover John husbandman 611069 611069 Yendover, John, of Brompton Regis, husbandman 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);