names

53 rows where place_id = 596414

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3624663 1875250 1875250 defendant Deyman Thomas tucker 596414 596414 Deyman, Thomas, of Chard, Soms, tucker 0
3675224 1918286 1918286 defendant Whithorne William clothmaker 596414 596414 Whithorne, William, of Chard, Soms, clothmaker 0
3676020 1918537 1918537 defendant Seymes Thomas yeoman 596414 596414 Seymes, Thomas, of Chard, Soms, yeoman 3
3691097 1923378 1923378 defendant Whytthorne John yeoman 596414 596414 Whytthorne, John, of Chard, Soms, yeoman 0
3711111 1929788 1929788 defendant Cogon Nicholas pinner 596414 596414 Cogon, Nicholas, of Chard, Soms, pinner 0
3714203 1930740 1930740 defendant Care John mercer 596414 596414 Care, John, of Chard, Soms, mercer 3
3720133 1932573 1932573 defendant Clappe John mercer 596414 596414 Clappe, John, of Chard, Soms, mercer 0
3720135 1932574 1932574 defendant Clappe John mercer 596414 596414 Clappe, John, of Chard, Soms, mercer 0
3805458 1959645 1959645 defendant North John husbandman 596414 596414 North, John, of Chard, Soms, husbandman 1
3805461 1959646 1959646 defendant North John husbandman 596414 596414 North, John, of Chard, Soms, husbandman 1
3816484 1963062 1963062 defendant Symmys John yeoman 596414 596414 Symmys, John, of Chard, Soms, yeoman 2
3840087 1970472 1970472 defendant Cogam Robert merchant 596414 596414 Cogam, Robert, of Chard, Soms, merchant 0
3844927 1971957 1971957 defendant Peter Robert chapman 596414 596414 Peter, Robert, of Chard, Soms, chapman 0
3862178 1977535 1977535 defendant Dene Thomas husbandman 596414 596414 Dene, Thomas, of Chard, Soms, husbandman 3
3902182 1990965 1990965 defendant Alston Thomas chapman 596414 596414 Alston, Thomas, of Chard, Soms, chapman 0
3917908 1996352 1996352 defendant Cogan Thomas chapman 596414 596414 Cogan, Thomas, of Chard, Soms, chapman 0
3942255 2004423 2004423 defendant Cogen Thomas mercer 596414 596414 Cogen, Thomas, of Chard, soms, mercer 1
3952090 2007799 2007799 defendant Dalwood Thomas chapman 596414 596414 Dalwood, Thomas, of Chard, Soms, chapman 0
3961772 2011218 2011218 defendant Whythorne John clothier 596414 596414 Whythorne, John, of Chard, Soms, clothier 0
3992822 2022186 2022186 defendant James Richard carrier 596414 596414 James, Richard, of Chard, Soms, carrier 3
3994387 2022746 2022746 plaintiff Cogan Thomas clothier 596414 596414 Cogan, Thomas, of Chard, Soms, clothier 0
3994389 2022747 2022747 plaintiff Cogan Thomas gent 596414 596414 Cogan, Thomas, of Chard, Soms, gent 0
4002129 2025544 2025544 defendant Peter Robert merchant 596414 596414 Peter, Robert, of Chard, Soms, merchant 0
4003070 2025861 2025861 defendant Furser Thomas carrier 596414 596414 Furser, Thomas, of Chard, Soms, carrier 4
4005564 2026763 2026763 defendant Gregorye John merchant 596414 596414 Gregorye, John, of Chard, Soms, merchant 0
4005566 2026764 2026764 defendant Gregorye John merchant 596414 596414 Gregorye, John, of Chard, Soms, merchant 0
4005568 2026765 2026765 defendant Gregorye John merchant 596414 596414 Gregorye, John, of Chard, Soms, merchant 0
4027885 2034623 2034623 plaintiff Cogan Thomas clothier 596414 596414 Cogan, Thomas, of Chard, Soms, clothier 0
4027887 2034624 2034624 plaintiff Cogan Thomas clothier 596414 596414 Cogan, Thomas, of Chard, Soms, clothier 0
4027889 2034625 2034625 plaintiff Cogan Thomas clothier 596414 596414 Cogan, Thomas, of Chard, Soms, clothier 0
4027891 2034626 2034626 plaintiff Cogan Thomas clothier 596414 596414 Cogan, Thomas, of Chard, Soms, clothier 0
4027893 2034627 2034627 plaintiff Cogan Thomas clothier 596414 596414 Cogan, Thomas, of Chard, Soms, clothier 0
4031584 2035958 2035958 defendant Cogan Thomas mercer 596414 596414 Cogan, Thomas, of Chard, Soms, mercer 0
4033270 2036553 2036553 defendant Michell Richard chapman 596414 596414 Michell, Richard, of Chard, Soms, chapman 1
4033273 2036554 2036554 defendant Mychell Richard chapman 596414 596414 Mychell, Richard, of Chard, Soms, chapman 1
4033586 2036662 2036662 defendant Elsden William merchant 596414 596414 (Elsden, William, of Chard, Soms, merchant 4
4059019 2045622 2045622 plaintiff Cogan Thomas merchant or clothier 596414 596414 Cogan, Thomas, of Chard, Soms, merchant or clothier 0
4061024 2046350 2046350 defendant Cogan Thomas chapman 596414 596414 Cogan, Thomas, of Chard, Soms, chapman 0
4061861 2046638 2046638 defendant Mychell Richard merchant 596414 596414 Mychell, Richard, of Chard, Soms, merchant 0
4061908 2046657 2046657 defendant Mychell Richard merchant 596414 596414 Mychell, Richard, of Chard, Soms, merchant 0
4101172 2060728 2060728 defendant Gregorye John merchant 596414 596414 Gregorye, John, of Chard, Soms, merchant 0
4168660 2084526 2084526 defendant Grymstede Thomas clothier 596414 596414 Grymstede, Thomas, of Chard, Soms, clothier 0
4168667 2084528 2084528 defendant Sprake Thomas clothier 596414 596414 Sprake, Thomas, of Chard, Soms, clothier 0
4176008 2087087 2087087 defendant Starre William dyer 596414 596414 Starre, William, of Chard, Soms, dyer 2
4176819 2087362 2087362 defendant Sprake John clothier 596414 596414 Sprake, John, of Chard, Soms, clothier 0
4306618 2132453 2132453 defendant Pulman William merchant 596414 596414 Pulman, William, of Chard, Soms, merchant 0
4312208 2134408 2134408 defendant Cooke Patroclus vintner 596414 596414 Cooke, Patroclus, of Chard, Soms, vintner 0
4347819 2146485 2146485 defendant Browne Edward chapman 596414 596414 Browne, Edward, of Chard, Soms, chapman 0
4402710 2165490 2165490 defendant Tucker John merchant 596414 596414 Tucker, John, of Chard, Soms, merchant 0
4720390 2271712 2271712 defendant Stronge Robert glasier 596414 596414 Stronge, Robert, of Chard, Soms, glasier 0
4730229 2274657 2274657 defendant Sadeler Walter husbandman 596414 596414 Sadeler, Walter, of Chard, Soms, husbandman 0
4760160 2283525 2283525 defendant Russell Walter chapman 596414 596414 Russell, Walter, of Chard, Soms, chapman 0
5049523 2371486 2371486 defendant Taverner John gent 596414 596414 Taverner, John, of Chard, Soms, gent 2

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