names

55 rows where place_id = 589513

✎ 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
3597828 1866938 1866938 defendant Butte William shoemaker 589513 589513 Butte, William, of Leyston, shoemaker 4
3656218 1912192 1912192 defendant Unkyll John yeoman 589513 589513 Unkyll, John, of Leyston, yeoman 0
3690072 1923056 1923056 plaintiff Furmage Edmund   589513 589513 Furmage, Edmund, of Leyston 0
3690074 1923056 1923056 defendant Looff Richard yeoman 589513 589513 Looff, Richard, of Leyston, yeoman 1
3814909 1962580 1962580 defendant Furmage Joan widow 589513 589513 Furmage, Joan, of Leyston, widow 2
3814911 1962581 1962581 defendant Holmes John mariner 589513 589513 Holmes, John, of Leyston, mariner 0
3862879 1977778 1977778 plaintiff Hermer John (legal representative) 589513 589513 Hermer, John, of Leyston, executors of 0
3867853 1979480 1979480 defendant Webber John warrener 589513 589513 Webber, John, of Leyston, warrener 2
3872739 1981096 1981096 defendant Chever Nicholas painter 589513 589513 Chever, Nicholas, of Leyston, painter 0
3880832 1983857 1983857 defendant Huntman Thomas husbandman 589513 589513 Huntman, Thomas, of Leyston, husbandman 0
3910573 1993851 1993851 defendant Sprotts William beer brewer 589513 589513 Sprotts, William, of Leyston, beer brewer 0
3912051 1994353 1994353 defendant Gladon Henry yeoman 589513 589513 Gladon, Henry, of Leyston, yeoman 1
3947998 2006363 2006363 defendant Browne Robert (legal representative) 589513 589513 Browne, Robert, of Leyston, gent, executor of 0
3982994 2018694 2018694 defendant Hasleye William husbandman 589513 589513 Hasleye, William, of Leyston, husbandman 1
4004518 2026390 2026390 defendant Waller James husbandman 589513 589513 Waller, James, of Leyston, husbandman 0
4004519 2026390 2026390 defendant Reve Martin husbandman 589513 589513 Reve, Martin, of Leyston, husbandman 1
4045416 2040813 2040813 defendant Taylor Ralph husbandman 589513 589513 Taylor, Ralph, of Leyston, husbandman 0
4045419 2040813 2040813 defendant Cryspe Robert yeoman 589513 589513 Cryspe, Robert, of Leyston, yeoman 3
4045421 2040813 2040813 defendant Taylor Ralph yeoman 589513 589513 Taylor, Ralph, of Leyston, yeoman 5
4052410 2043283 2043283 defendant Smythe Roger yeoman 589513 589513 Smythe, Roger, of Leyston, yeoman 0
4052411 2043283 2043283 defendant Lonsse or Lousse George husbandman 589513 589513 Lonsse or Lousse, George, of Leyston, husbandman 1
4061151 2046396 2046396 defendant Crispe Mathew gent 589513 589513 Crispe, Mathew, of Leyston, gent 2
4077202 2052131 2052131 defendant Brooke Mary spinster 589513 589513 Brooke, Mary, of Leyston, spinster 3
4155823 2080116 2080116 defendant Sadler John yeoman 589513 589513 Sadler, John, of Leyston, yeoman 2
4187221 2091022 2091022 defendant Colby Francis gent 589513 589513 Colby, Francis, of Leyston, gent 0
4187227 2091025 2091025 defendant Grinlinge alias Girling Thomas husbandman 589513 589513 Grinlinge alias Girling, Thomas, of Leyston, husbandman 0
4208951 2098681 2098681 defendant Colbye Francis, junior gent 589513 589513 Colbye, Francis, junior, of Leyston, gent 0
4208953 2098682 2098682 defendant Colbye Francis, junior gent 589513 589513 Colbye, Francis, junior, of Leyston, gent 0
4307182 2132649 2132649 defendant Walker Thomas   589513 589513 Walker, Thomas, of Leyston, sailor 1
4453760 2186187 2186187 defendant Bokele Richard   589513 589513 Bokele, Richard, of Leyston 0
4453762 2186187 2186187 defendant Russe Adam   589513 589513 Russe, Adam, of Leyston 2
4676081 2258131 2258131 defendant Stacere William husbandman 589513 589513 Stacere, William, of Leyston, husbandman 1
4772562 2287387 2287387 defendant Catteworth John   589513 589513 Catteworth, John, of Leyston, bailiff 0
4861903 2315100 2315100 defendant Flykke William yeoman 589513 589513 Flykke, William, of Leyston, yeoman 1
4873469 2318661 2318661 plaintiff Perys John   589513 589513 Perys, John, of Leyston 0
4991793 2354428 2354428 defendant Jaksy John yeoman 589513 589513 Jaksy, John, of Leyston, yeoman 0
5033370 2366640 2366640 defendant Northey Henry   589513 589513 Northey, Henry, of Leyston, servant 1
5053321 2372596 2372596 defendant Shorte John yeoman 589513 589513 Shorte, John, of Leyston, yeoman 1
5088849 2383116 2383116 defendant Shanke William shoemaker 589513 589513 Shanke, William, of Leyston, shoemaker 0
5088850 2383116 2383116 defendant Kelyng John laborer 589513 589513 Kelyng, John, of Leyston, laborer 1
5088851 2383116 2383116 defendant Chever Robert laborer 589513 589513 Chever, Robert, of Leyston, laborer 2
5125870 2394053 2394053 defendant Sawer William roper 589513 589513 Sawer, William, of Leyston, roper 0
5154179 2402378 2402378 defendant Shanke William shoemaker 589513 589513 Shanke, William, of Leyston, shoemaker 4
5171332 2407340 2407340 defendant Shanke William shoemaker 589513 589513 Shanke, William, of Leyston, shoemaker 4
5195199 2414339 2414339 defendant Sawere William   589513 589513 Sawere, William, of Leyston, rope maker 0
5209145 2418403 2418403 defendant Sawere William   589513 589513 Sawere, William, of Leyston, rope maker 0
5230907 2424647 2424647 defendant Sawer William roper 589513 589513 Sawer, William, of Leyston, roper 0
5511375 2508403 2508403 defendant Clerk Thomas laborer 589513 589513 Clerk, Thomas, of Leyston, laborer 2
5520364 2511190 2511190 defendant Kydman William shoemaker 589513 589513 Kydman, William, of Leyston, shoemaker 2
5570768 2526011 2526011 defendant Skarborough Robert clerk 589513 589513 Skarborough, Robert, of Leyston, clerk 0
5578991 2528499 2528499 defendant Man Robert yeoman 589513 589513 Man, Robert, of Leyston, yeoman 1
5578992 2528499 2528499 defendant Looff Richard yeoman 589513 589513 Looff, Richard, of Leyston, yeoman 2
5578995 2528500 2528500 defendant Aleyn Thomas husbandman 589513 589513 Aleyn, Thomas, of Leyston, husbandman 0
5578996 2528500 2528500 defendant Looff Richard yeoman 589513 589513 Looff, Richard, of Leyston, yeoman 1
5578997 2528500 2528500 defendant Man Robert yeoman 589513 589513 Man, Robert, of Leyston, yeoman 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);