names

18 rows where place_id = 623297

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3751684 1942443 1942443 defendant Govulle Henry bbutcher 623297 623297 Govulle, Henry, of Gysburn, bbutcher 1
3861172 1977213 1977213 defendant Lowde Edward yeoman 623297 623297 Lowde, Edward, of Gysburn, yeoman 0
4642184 2243828 2243828 defendant Clerk Richard   623297 623297 Clerk, Richard, of Gysburn 1
4707606 2267739 2267739 defendant Ingelby Margaret widow 623297 623297 Ingelby, Margaret, of Gysburn, widow 0
4707607 2267739 2267739 defendant Ingleby Alice laborer 623297 623297 Ingleby, Alice, of Gysburn, laborer 1
4766168 2285411 2285411 defendant Thomson John butcher 623297 623297 Thomson, John, of Gysburn, butcher 0
4766169 2285411 2285411 defendant Litister Richard dyer 623297 623297 Litister, Richard, of Gysburn, dyer 1
4794936 2294561 2294561 defendant Cornay William tailor 623297 623297 Cornay, William, of Gysburn, tailor 0
4794937 2294561 2294561 defendant Flesshewer William butcher 623297 623297 Flesshewer, William, of Gysburn, butcher 1
4794940 2294561 2294561 defendant Mason Alice Walter 623297 623297 Mason, Alice, of Gysburn, widow of Mason, Walter 4
4796081 2294929 2294929 defendant Thomson John flesshewer or butcher 623297 623297 Thomson, John, of Gysburn, flesshewer or butcher 0
4796082 2294929 2294929 defendant Wyneyard William flesshewer or butcher 623297 623297 Wyneyard, William, of Gysburn, flesshewer or butcher 1
4961811 2345496 2345496 defendant Neweham William flesshewer or butcher 623297 623297 Neweham, William, of Gysburn, flesshewer or butcher 0
4961812 2345496 2345496 defendant Coke John flesshewer or butcher 623297 623297 Coke, John, of Gysburn, flesshewer or butcher 1
5015806 2361509 2361509 defendant Bywell Agnes widow 623297 623297 Bywell, Agnes, of Gysburn, widow 1
5484539 2500295 2500295 defendant Thomson John mercer 623297 623297 Thomson, John, of Gysburn, mercer 0
5512890 2508886 2508886 defendant Lytster John yeoman 623297 623297 Lytster, John, of Gysburn, yeoman 0
5513114 2508958 2508958 defendant Faireweder Robert yeoman 623297 623297 Faireweder, Robert, of Gysburn, 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);