names

37 rows where place_id = 610062

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3681757 1920394 1920394 defendant Lobrige John husbandman 610062 610062 Lobrige, John, of Clent, husbandman 0
3708023 1928807 1928807 defendant Birchenhed Richard weaver 610062 610062 Birchenhed, Richard, of Clent, weaver 1
3711288 1929834 1929834 defendant White Thomas yeoman 610062 610062 White, Thomas, of Clent, yeoman 0
3711292 1929834 1929834 defendant Cockys William clerk 610062 610062 Cockys, William, of Clent, clerk 4
3715403 1931102 1931102 defendant Colyns John smith 610062 610062 Colyns, John, of Clent, smith 0
3715404 1931102 1931102 defendant Sparry Richard yeoman 610062 610062 Sparry, Richard, of Clent, yeoman 1
3722571 1933319 1933319 defendant Birchenhed Henry weaver 610062 610062 Birchenhed, Henry, of Clent, weaver 1
3737339 1937914 1937914 defendant Hyll John husbandman 610062 610062 Hyll, John, of Clent, husbandman 0
3738358 1938210 1938210 defendant Byrchenhed Henry warrener 610062 610062 Byrchenhed, Henry, of Clent, warrener 1
3770185 1948342 1948342 defendant Hyll John husbandman 610062 610062 Hyll, John, of Clent, husbandman 1
3842871 1971302 1971302 defendant Cookys John drover 610062 610062 Cookys, John, of Clent, drover 0
3900272 1990320 1990320 defendant Hurkett Richard husbandman 610062 610062 Hurkett, Richard, of Clent, husbandman 2
3902330 1991010 1991010 defendant Penne Edmund yeoman 610062 610062 Penne, Edmund, of Clent, yeoman 0
3913162 1994735 1994735 defendant Cox John husbandman 610062 610062 Cox, John, of Clent, husbandman 3
3921860 1997655 1997655 defendant Waleys Thomas husbandman 610062 610062 Waleys, Thomas, of Clent, husbandman 0
3941524 2004176 2004176 defendant Underhyll Roger husbandman 610062 610062 Underhyll, Roger,of Clent, husbandman 0
3976782 2016446 2016446 defendant Cordewan John husbandman 610062 610062 Cordewan, John, of Clent, husbandman 1
4012684 2029260 2029260 defendant Cropper Richard yeoman 610062 610062 Cropper, Richard, of Clent, yeoman 0
4012689 2029262 2029262 defendant Cordywen John husbandman 610062 610062 Cordywen, John, of Clent, husbandman 0
4021448 2032395 2032395 defendant Cordywene John, junior   610062 610062 Cordywene, John, junior, of Clent, yeoman, his son 1
4021449 2032395 2032395 defendant Hurcott Robert husbandman 610062 610062 Hurcott, Robert, of Clent, husbandman 2
4035484 2037364 2037364 defendant Cropper Richard yeoman 610062 610062 Cropper, Richard, of Clent, yeoman 0
4035486 2037365 2037365 defendant Cropper Richard yeoman 610062 610062 Cropper, Richard, of Clent, yeoman 0
4054853 2044128 2044128 defendant Cordewen John, senior yeoman 610062 610062 Cordewen, John, senior, of Clent, yeoman 0
4120816 2067732 2067732 defendant Deryngton Walter yeoman 610062 610062 Deryngton, Walter, of Clent, yeoman 0
4238034 2108907 2108907 defendant Cordnell John husbandman 610062 610062 Cordnell, John, of Clent, husbandman 2
4319578 2136958 2136958 defendant Bodeley Richard   610062 610062 Bodeley, Richard, of Clent, scythe smith 2
4346954 2146186 2146186 defendant Penn John smith 610062 610062 Penn, John, of Clent, smith 1
5193608 2413856 2413856 defendant Paget William turner 610062 610062 Paget, William, of Clent, turner 0
5193609 2413856 2413856 defendant Hill John husbandman 610062 610062 Hill, John, of Clent, son of John, husbandman 1
5288730 2441721 2441721 defendant Hill John, junior husbandman 610062 610062 Hill, John, junior, of Clent, husbandman 1
5288731 2441721 2441721 defendant Hull Thomas yeoman 610062 610062 Hull, Thomas, of Clent, yeoman 2
5288732 2441721 2441721 defendant Lovebrygge Thomas husbandman 610062 610062 Lovebrygge, Thomas, of Clent, husbandman 3
5538355 2516482 2516482 defendant Sparre John yeoman 610062 610062 Sparre, John, of Clent,yeoman 0
5538361 2516484 2516484 defendant Sparre John yeoman 610062 610062 Sparre, John, of Clent, yeoman 0
5538363 2516485 2516485 defendant Sparre John yeoman 610062 610062 Sparre, John, of Clent,yeoman 0
5607905 2537378 2537378 defendant Heth Richard yeoman 610062 610062 Heth, Richard, of Clent, 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);