names

36 rows where place_id = 608020

✎ 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
3671866 1917200 1917200 defendant Lyrcoke Thomas yeoman 608020 608020 Lyrcoke, Thomas, of Clent, Staffs, yeoman 4
3731359 1936030 1936030 defendant Sparry William husbandman 608020 608020 Sparry, William, of Clent, Staffs, husbandman 2
3746368 1940782 1940782 defendant Lircok Thomas yeoman 608020 608020 Lircok, Thomas, of Clent, Staffs, yeoman 2
3753165 1942930 1942930 defendant Underhill William husbandman 608020 608020 Underhill, William, of Clent, Staffs, husbandman 0
3753166 1942930 1942930 defendant Hyll John husbandman 608020 608020 Hyll, John, of Clent, Staffs, husbandman 1
3753625 1943077 1943077 defendant Hyll John husbandman 608020 608020 Hyll, John, of Clent, Staffs, husbandman 0
3759553 1944980 1944980 defendant Lyrcok Thomas yeoman 608020 608020 Lyrcok, Thomas, of Clent, Staffs, yeoman 2
3770184 1948342 1948342 defendant Hunderhyll William husbandman 608020 608020 Hunderhyll, William, of Clent, Staffs, husbandman 0
3770764 1948544 1948544 defendant Hyll John husbandman 608020 608020 Hyll, John, of Clent, Staffs, husbandman 0
3777536 1950725 1950725 defendant Lyrcok Thomas yeoman 608020 608020 Lyrcok, Thomas, of Clent, Staffs, yeoman 5
3846729 1972533 1972533 defendant Hart William husbandman 608020 608020 Hart, William, of Clent, Staffs, husbandman 2
3847285 1972712 1972712 defendant Hyll John husbandman 608020 608020 Hyll, John, of Clent, Staffs, husbandman 0
3909241 1993386 1993386 defendant Cockys Philip yeoman 608020 608020 Cockys, Philip, of Clent, Staffs, yeoman 0
3976777 2016444 2016444 defendant Cordewan or Cordewell John husbandman 608020 608020 Cordewan or Cordewell, John, of Clent, Staffs, husbandman 0
3976781 2016446 2016446 defendant Hurcote Robert husbandman 608020 608020 Hurcote, Robert, of Clent, Staffs, husbandman 0
4005624 2026787 2026787 defendant Cropper Richard yeoman 608020 608020 Cropper, Richard, of Clent, Staffs, yeoman 2
4005628 2026788 2026788 defendant Cropper Richard yeoman 608020 608020 Cropper, Richard, of Clent, Staffs, yeoman 1
4010480 2028521 2028521 defendant Cordywener John, junior yeoman 608020 608020 Cordywener, John, junior, of Clent, Staffs, yeoman 0
4013005 2029384 2029384 defendant Cropper Richard yeoman 608020 608020 Cropper, Richard, of Clent, Staffs, yeoman 0
4021447 2032395 2032395 defendant Cordywene John, senior yeoman 608020 608020 Cordywene, John, senior, of Clent, Staffs, yeoman 0
4021454 2032396 2032396 defendant Cropper Richard yeoman 608020 608020 Cropper, Richard, of Clent, Staffs, yeoman 2
4021671 2032479 2032479 defendant Cordewyn John yeoman 608020 608020 Cordewyn, John, of Clent, Staffs, yeoman 0
4021680 2032480 2032480 defendant Cordewen John yeoman 608020 608020 Cordewen, John, of Clent, Staffs, yeoman 0
4044139 2040358 2040358 defendant Cordowen John, junior husbandman 608020 608020 Cordowen, John, junior, of Clent, Staffs, husbandman 2
4044144 2040359 2040359 defendant Cordywen John, junior husbandman 608020 608020 Cordywen, John, junior, of Clent, Staffs, husbandman 3
4052277 2043238 2043238 defendant Hurcott Robert husbandman 608020 608020 Hurcott, Robert, of Clent, Staffs, husbandman 0
4101096 2060705 2060705 defendant Cardiwan John yeoman 608020 608020 Cardiwan, John, of Clent, Staffs, yeoman 3
4188831 2091571 2091571 defendant Cock John   608020 608020 Cock, John, of Clent, Staffs, scythe smith 0
4217484 2101608 2101608 defendant Chapman William laborer 608020 608020 Chapman, William, of Clent, Staffs, laborer 2
4238937 2109238 2109238 defendant Cordyan John yeoman 608020 608020 Cordyan, John, of Clent, Staffs, yeoman 1
4254246 2114418 2114418 defendant Chapman William laborer 608020 608020 Chapman, William, of Clent, Staffs, laborer 2
4310553 2133841 2133841 defendant Moseley Henry gent 608020 608020 Moseley, Henry, of Clent, Staffs, gent 1
4353984 2148619 2148619 defendant Coxe Thomas   608020 608020 Coxe, Thomas, of Clent, Staffs, scythe smith 0
5079120 2380241 2380241 defendant Sparry William yeoman 608020 608020 Sparry, William, of Clent, Staffs, yeoman 1
5238822 2426943 2426943 defendant Sparry William husbandman 608020 608020 Sparry, William, of Clent, Staffs, husbandman 0
5288729 2441721 2441721 defendant Pachet William yeoman 608020 608020 Pachet, William, of Clent, Staffs, 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);