names

44 rows where place_id = 623178

✎ 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
3645688 1909055 1909055 defendant Syday Walter   623178 623178 Syday, Walter, of Sudbery, Suff, wax chandler 0
3751026 1942253 1942253 defendant Leng Robert draper 623178 623178 Leng, Robert, of Sudbery, Suff, draper 0
3793544 1955842 1955842 defendant Cole John clothier 623178 623178 Cole, John, of Sudbery, Suff, clothier 1
3887074 1985940 1985940 defendant Brett Thomas clothier 623178 623178 Brett, Thomas, of Sudbery, Suff, clothier 0
3913106 1994715 1994715 defendant Lock William merchant 623178 623178 Lock, William, of Sudbery, Suff, merchant 0
3917719 1996281 1996281 defendant Parmenter Bartholomew clothier 623178 623178 Parmenter, Bartholomew, of Sudbery, Suff, clothier 1
3929521 2000221 2000221 defendant Bryan Robert mercer 623178 623178 Bryan, Robert, of Sudbery, Suff, mercer 1
3973922 2015449 2015449 defendant Graye Thomas chapman 623178 623178 Graye, Thomas, of Sudbery, Suff, chapman 1
4119739 2067347 2067347 defendant Godfrey Thomas vintner 623178 623178 Godfrey, Thomas, of Sudbery, Suff, vintner 1
4264441 2117747 2117747 defendant Fulthorpp John clerk 623178 623178 Fulthorpp, John, of Sudbery, Suff, clerk 2
4267942 2118908 2118908 defendant Jarvys Robert merchant 623178 623178 Jarvys, Robert, of Sudbery, Suff, merchant 1
4267955 2118910 2118910 defendant Goldinge Richard clothier 623178 623178 Goldinge, Richard, of Sudbery, Suff, clothier 0
4294383 2128073 2128073 defendant Wylde Edmund chapman 623178 623178 Wylde, Edmund, of Sudbery, Suff, chapman 0
4663549 2250078 2250078 defendant Scaldere Roger spicer 623178 623178 Scaldere, Roger, of Sudbery, Suff, spicer 0
4812762 2300106 2300106 defendant Bryon John butcher 623178 623178 Bryon, John, of Sudbery, Suff, butcher 2
4864217 2315785 2315785 defendant Prentys Adam weaver 623178 623178 Prentys, Adam, of Sudbery, Suff, weaver 0
4912900 2330530 2330530 defendant Hunte John gent 623178 623178 Hunte, John, of Sudbery, Suff, gent 0
4989695 2353835 2353835 defendant Bray William tanner 623178 623178 Bray, William, of Sudbery, Suff, tanner 3
4989696 2353835 2353835 defendant Croydon John   623178 623178 Croydon, John, of Sudbery, Suff, ash burner 4
5021204 2363101 2363101 defendant Bachot Edmund scrivener 623178 623178 Bachot, Edmund, of Sudbery, Suff, scrivener 2
5023785 2363862 2363862 defendant Barbour Stephen weaver 623178 623178 Barbour, Stephen, of Sudbery, Suff, weaver 3
5057702 2373871 2373871 defendant Gange or Gauge Thomas yeoman 623178 623178 Gange or Gauge, Thomas, of Sudbery, Suff, yeoman 1
5067386 2376754 2376754 defendant Hyne or Hyve John dyer 623178 623178 Hyne or Hyve, John, of Sudbery, Suff, dyer 0
5076572 2379496 2379496 defendant Bust John   623178 623178 Bust, John, of Sudbery, Suff, gent, attorney 0
5077372 2379731 2379731 defendant Bust John   623178 623178 Bust, John, of Sudbery, Suff, gent, attorney 0
5077374 2379732 2379732 defendant Bust John   623178 623178 Bust, John, of Sudbery, Suff, gent, attorney 0
5077376 2379733 2379733 defendant Bust John   623178 623178 Bust, John, of Sudbery, Suff, gent, attorney 0
5079095 2380235 2380235 defendant West Ralph gent 623178 623178 West, Ralph, of Sudbery, Suff, gent 0
5092059 2384054 2384054 defendant Hyne or Hyve John weaver 623178 623178 Hyne or Hyve, John, of Sudbery, Suff, weaver 0
5102864 2387257 2387257 defendant Eston Thomas chapman 623178 623178 Eston, Thomas, of Sudbery, Suff, chapman 0
5116315 2391202 2391202 defendant Bust John gent 623178 623178 Bust, John, of Sudbery, Suff, gent 3
5126916 2394349 2394349 defendant Fychys John husbandman 623178 623178 Fychys, John, of Sudbery, Suff, husbandman 0
5212125 2419285 2419285 defendant Bust John gent 623178 623178 Bust, John, of Sudbery, Suff, gent 0
5212130 2419286 2419286 defendant Bust John gent 623178 623178 Bust, John, of Sudbery, Suff, gent 0
5224768 2422914 2422914 defendant West William yeoman 623178 623178 West, William, of Sudbery, Suff, yeoman 1
5232771 2425170 2425170 defendant Erle William weaver 623178 623178 Erle, William, of Sudbery, Suff, weaver 0
5302554 2445738 2445738 defendant Smyth John clothmaker 623178 623178 Smyth, John, of Sudbery, Suff, clothmaker 0
5311221 2448382 2448382 defendant Howard Thomas yeoman 623178 623178 Howard, Thomas, of Sudbery, Suff, yeoman 0
5433368 2484940 2484940 defendant Ferot Peter chapman 623178 623178 Ferot, Peter, of Sudbery, Suff, chapman 1
5443670 2488028 2488028 plaintiff Chapman John gent 623178 623178 Chapman, John, of Sudbery, Suff, gent 0
5449169 2489637 2489637 defendant Ferot Peter chapman 623178 623178 Ferot, Peter, of Sudbery, Suff, chapman 1
5517739 2510390 2510390 plaintiff Wellys Thomas (legal representative) 623178 623178 Wellys, Thomas, of Sudbery, Suff, clothmaker or merchant, executors of 0
5532960 2514851 2514851 defendant Laneham alias Cutteler William yeoman 623178 623178 Laneham alias Cutteler, William, of Sudbery, Suff, yeoman 4
5548505 2519601 2519601 plaintiff Ayloff Thomas (legal representative) 623178 623178 Ayloff, Thomas, of Sudbery, Suff, executor of 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);