names

15 rows where place_id = 606025

✎ 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
3663735 1914593 1914593 defendant Broun William weaver 606025 606025 Broun, William, of Witley, weaver 0
3940802 2003929 2003929 defendant Wood Henry husbandman 606025 606025 Wood, Henry, of Witley, husbandman 1
4178338 2087894 2087894 defendant Mellershe William sherman 606025 606025 Mellershe, William, of Witley, sherman 2
4237314 2108641 2108641 defendant Ireland William husbandman 606025 606025 Ireland, William, of Witley, husbandman 0
4288927 2126094 2126094 defendant Bradfeld John clothier 606025 606025 Bradfeld, John, of Witley, clothier 3
4318594 2136616 2136616 defendant Page Robert husbandman 606025 606025 Page, Robert, of Witley, husbandman 0
4331338 2140778 2140778 defendant Page Robert husbandman 606025 606025 Page, Robert, of Witley, husbandman 0
4345373 2145657 2145657 defendant Parker Francis yeoman 606025 606025 Parker, Francis, of Witley, yeoman 0
4363355 2151965 2151965 defendant Baylie Richard yeoman 606025 606025 Baylie, Richard, of Witley, yeoman 0
4389800 2161213 2161213 defendant Baylie Richard yeoman 606025 606025 Baylie, Richard, of Witley, yeoman 0
5145554 2399845 2399845 defendant Astolf John butcher 606025 606025 Astolf, John, of Witley, butcher 0
5165940 2405784 2405784 defendant Astolff John butcher 606025 606025 Astolff, John, of Witley, butcher 0
5180599 2410069 2410069 defendant Astolf John butcher 606025 606025 Astolf, John, of Witley, butcher 0
5180605 2410070 2410070 defendant Astolf John butcher 606025 606025 Astolf, John, of Witley, butcher 0
5419678 2480802 2480802 defendant Weylond Henry husbandman 606025 606025 Weylond, Henry, of Witley, 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);