names

12 rows where place_id = 620455

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3735747 1937418 1937418 defendant Atherton Mathew yeoman 620455 620455 Atherton, Mathew, of Wannesworth, Surrey, yeoman 0
3956734 2009423 2009423 defendant Potter Elias baker 620455 620455 Potter, Elias, of Wannesworth, Surrey, baker 1
4273190 2120594 2120594 defendant White Thomas clothworker 620455 620455 White, Thomas, of Wannesworth, Surrey, yeoman, clothworker 0
4651647 2246501 2246501 defendant Savage Robert husbandman 620455 620455 Savage, Robert, of Wannesworth, Surrey, husbandman 16
4651823 2246513 2246513 defendant Savage Robert husbandman 620455 620455 Savage, Robert, of Wannesworth, Surrey, husbandman 17
4701364 2265828 2265828 defendant Paternoster Robert smith 620455 620455 Paternoster, Robert, of Wannesworth, Surrey, smith 3
5089727 2383370 2383370 defendant Shirfote John husbandman 620455 620455 Shirfote, John, of Wannesworth, Surrey, husbandman 0
5104770 2387832 2387832 defendant Hert Thomas fuller 620455 620455 Hert, Thomas, of Wannesworth, Surrey, fuller 4
5223762 2422634 2422634 defendant atte Pytte William   620455 620455 atte Pytte, William, of Wannesworth, Surrey, husbandman, administrators of 3
5316333 2449970 2449970 defendant Hypworth Edmund mercer 620455 620455 Hypworth, Edmund, of Wannesworth, Surrey, mercer 0
5316338 2449971 2449971 defendant Hypworth Edmund mercer 620455 620455 Hypworth, Edmund, of Wannesworth, Surrey, mercer 0
5605739 2536682 2536682 defendant Morgan John baker 620455 620455 Morgan, John, of Wannesworth, Surrey, baker 3

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