names

24 rows where place_id = 608026

✎ 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
3671884 1917202 1917202 defendant Cleydysshe Richard husbandman 608026 608026 Cleydysshe, Richard, of Hanwell, husbandman 0
4221531 2103021 2103021 defendant Maye William schoolmaster 608026 608026 Maye, William, of Hanwell, gent, schoolmaster 0
4339961 2143752 2143752 defendant Cope Anthony   608026 608026 Cope, Anthony, of Hanwell, Oxon knight 0
5325241 2452638 2452638 defendant Thorneby John (legal representative) 608026 608026 Thorneby, John, of Hanwell, clerk, executors of 2
5325243 2452638 2452638 defendant Thorneby Robert husbandman 608026 608026 Thorneby, Robert, of Hanwell, husbandman 4
5363829 2464339 2464339 defendant Ewyk or Gwyk Thomas husbandman 608026 608026 Ewyk or Gwyk, Thomas, of Hanwell, husbandman 1
5367126 2465365 2465365 defendant Thorneby Robert yeoman 608026 608026 Thorneby, Robert, of Hanwell, yeoman 0
5383271 2470291 2470291 defendant Thorneby Robert   608026 608026 Thorneby, Robert, of Hanwell 0
5385729 2470990 2470990 defendant Thorneby Robert yeoman 608026 608026 Thorneby, Robert, of Hanwell, yeoman 0
5397925 2474481 2474481 defendant Thorneby Robert   608026 608026 Thorneby, Robert, of Hanwell 0
5408301 2477450 2477450 defendant Thorenby Robert yeoman 608026 608026 Thorenby, Robert, of Hanwell, yeoman 0
5421242 2481285 2481285 defendant Fox William husbandman 608026 608026 Fox, William, of Hanwell, husbandman 3
5422439 2481658 2481658 defendant Noys Thomas husbandman 608026 608026 Noys, Thomas, of Hanwell, husbandman 4
5422440 2481658 2481658 defendant Fox William husbandman 608026 608026 Fox, William, of Hanwell, husbandman 5
5440474 2487053 2487053 defendant Fox William husbandman 608026 608026 Fox, William, of Hanwell, husbandman 3
5442101 2487555 2487555 defendant Nois Thomas   608026 608026 Nois, Thomas, of Hanwell 3
5442102 2487555 2487555 defendant Fox William husbandman 608026 608026 Fox, William, of Hanwell, husbandman 4
5442108 2487556 2487556 defendant Nois Thomas   608026 608026 Nois, Thomas, of Hanwell 3
5442109 2487556 2487556 defendant Fox Thomas husbandman 608026 608026 Fox, Thomas, of Hanwell, husbandman 4
5454843 2491366 2491366 defendant Nors Thomas husbandman 608026 608026 Nors, Thomas, of Hanwell, husbandman 4
5454844 2491366 2491366 defendant Fox William husbandman 608026 608026 Fox, William, of Hanwell, husbandman 5
5581564 2529308 2529308 defendant Andrewes William clerk 608026 608026 Andrewes, William, of Hanwell, clerk 0
5581583 2529315 2529315 defendant Andrewes William clerk 608026 608026 Andrewes, William, of Hanwell, clerk 0
5608522 2537566 2537566 defendant Thorneby Robert yeoman 608026 608026 Thorneby, Robert, of Hanwell, yeoman 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);