names

19 rows where place_id = 757600

✎ 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
4447240 2184046 2184046 defendant Webbe Robert   757600 757600 Webbe, Robert, of Aldebourne 0
4513100 2204531 2204531 defendant Smythes Agnes   757600 757600 Smythes, Agnes, of Aldebourne 0
4639048 2242938 2242938 plaintiff Clerk John   757600 757600 Clerk, John, of Aldebourne 0
4639049 2242938 2242938 defendant Tomas Richard   757600 757600 Tomas, Richard, of Aldebourne 0
4680505 2259516 2259516 defendant Tammys William butcher 757600 757600 Tammys, William, of Aldebourne, butcher 1
4689733 2262352 2262352 plaintiff Walrand John   757600 757600 Walrand, John, of Aldebourne 0
4699631 2265337 2265337 defendant Goldyng William clerk 757600 757600 Goldyng, William, of Aldebourne, clerk 0
4715626 2270215 2270215 plaintiff Warner John   757600 757600 Warner, John, of Aldebourne 0
4733191 2275560 2275560 defendant Osmere John husbandman 757600 757600 Osmere, John, of Aldebourne, husbandman 0
4744328 2278864 2278864 defendant Goldyng William clerk 757600 757600 Goldyng, William, of Aldebourne, clerk 0
4745687 2279251 2279251 defendant Amys Peter husbandman 757600 757600 Amys, Peter, of Aldebourne, husbandman 0
4752460 2281181 2281181 defendant Amys Peter husbandman 757600 757600 Amys, Peter, of Aldebourne, husbandman 2
4765974 2285348 2285348 defendant Hardepie John husbandman 757600 757600 Hardepie, John, of Aldebourne, husbandman 0
4922261 2333377 2333377 defendant Barbour Nicholas yeoman 757600 757600 Barbour, Nicholas, of Aldebourne, yeoman 1
4922263 2333377 2333377 defendant Bonore John husbandman 757600 757600 Bonore, John, of Aldebourne, husbandman 3
4959900 2344923 2344923 defendant Walrond Ingelram gent 757600 757600 Walrond, Ingelram, of Aldebourne, gent 0
4984721 2352357 2352357 defendant Strangge John   757600 757600 Strangge, John, of Aldebourne, shepherd 0
5048365 2371148 2371148 defendant Morley Robert yeoman 757600 757600 Morley, Robert, of Aldebourne, yeoman 0
5128800 2394908 2394908 defendant Appulby John husbandman 757600 757600 Appulby, John, of Aldebourne, 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);