names

27 rows where place_id = 611703

✎ 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
3689715 1922940 1922940 defendant Rose Nicholas butcher 611703 611703 Rose, Nicholas, of Alderwas, butcher 0
3717059 1931621 1931621 defendant Harley Thomas miller 611703 611703 Harley, Thomas, of Alderwas, miller 0
3717060 1931621 1931621 defendant Hachett John, senior husbandman 611703 611703 Hachett, John, senior, of Alderwas, husbandman 1
3779535 1951325 1951325 defendant Clerke William yeoman 611703 611703 Clerke, William, of Alderwas, yeoman 0
3787613 1953915 1953915 defendant Parker John husbandman 611703 611703 Parker, John, of Alderwas, husbandman 0
3794878 1956266 1956266 defendant Towres Robert bagger 611703 611703 Towres, Robert, of Alderwas, bagger 0
3796522 1956785 1956785 defendant Clerke William yeoman 611703 611703 Clerke, William, of Alderwas, yeoman 0
3825671 1965882 1965882 defendant Curson George yeoman 611703 611703 Curson, George, of Alderwas, yeoman 0
3828644 1966838 1966838 plaintiff Clerke William   611703 611703 Clerke, William, of Alderwas 0
3836741 1969391 1969391 defendant Clerk William yeoman 611703 611703 Clerk, William, of Alderwas, yeoman 0
3838736 1970044 1970044 defendant Clerke William yeoman 611703 611703 Clerke, William, of Alderwas, yeoman 0
3891014 1987258 1987258 defendant Curson George gent 611703 611703 Curson, George, of Alderwas, gent 0
3914007 1995029 1995029 defendant Ryddynge Thomas yeoman 611703 611703 Ryddynge, Thomas, of Alderwas, yeoman 0
3937620 2002913 2002913 defendant Roos Walter yeoman 611703 611703 Roos, Walter, of Alderwas, yeoman 1
3937621 2002913 2002913 defendant Walker Henry yeoman 611703 611703 Walker, Henry, of Alderwas, yeoman 2
4214899 2100712 2100712 defendant Butler John yeoman 611703 611703 Butler, John, of Alderwas, yeoman 0
4685256 2260985 2260985 defendant Walton Nicholas de husbandman 611703 611703 Walton, Nicholas de, of Alderwas, husbandman 0
4685257 2260985 2260985 defendant Huberd William husbandman 611703 611703 Huberd, William, of Alderwas, husbandman 1
4849815 2311413 2311413 defendant Berde Robert butcher 611703 611703 Berde, Robert, of Alderwas, butcher 0
4864805 2315967 2315967 defendant Prest John fisher 611703 611703 Prest, John, of Alderwas, fisher 0
4941203 2339271 2339271 defendant Tarlton Ellen widow 611703 611703 Tarlton, Ellen, of Alderwas, widow 2
5078118 2379940 2379940 defendant Spenlove William yeoman 611703 611703 Spenlove, William, of Alderwas, yeoman 0
5087354 2382683 2382683 defendant Darynton William husbandman 611703 611703 Darynton, William, of Alderwas, husbandman 0
5116709 2391320 2391320 defendant Boteler William yeoman 611703 611703 Boteler, William, of Alderwas, yeoman 4
5585379 2530495 2530495 defendant Aleyn Ralph chaplain 611703 611703 Aleyn, Ralph, of Alderwas, chaplain 0
5591060 2532183 2532183 defendant Boteler Nicholas husbandman 611703 611703 Boteler, Nicholas, of Alderwas, husbandman 2
5591071 2532186 2532186 defendant Beteler Nicholas husbandman 611703 611703 Beteler, Nicholas, of Alderwas, husbandman 1

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