names

55 rows where place_id = 587064

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590362 1864626 1864626 defendant Kyng Robert husbandman 587064 587064 Kyng, Robert, of Denston, husbandman 0
3590365 1864626 1864626 defendant Toppysfeld William butcher 587064 587064 Toppysfeld, William, of Denston, butcher 3
3628233 1903689 1903689 defendant Fermour John husbandman 587064 587064 Fermour, John, of Denston, husbandman 0
3680548 1919997 1919997 defendant Wall Richard husbandman 587064 587064 Wall, Richard, of Denston, husbandman 0
3732382 1936364 1936364 defendant Colman John yeoman 587064 587064 Colman, John, of Denston, yeoman 0
3732383 1936364 1936364 defendant Hall Thomas husbandman 587064 587064 Hall, Thomas, of Denston, husbandman 1
3732384 1936364 1936364 defendant Everard Henry gent 587064 587064 Everard, Henry, of Denston, gent 2
3732386 1936365 1936365 defendant Everard Henry gent 587064 587064 Everard, Henry, of Denston, gent 0
3732387 1936365 1936365 defendant Colman John yeoman 587064 587064 Colman, John, of Denston, yeoman 1
3732388 1936365 1936365 defendant Hall Thomas husbandman 587064 587064 Hall, Thomas, of Denston, husbandman 2
3732390 1936366 1936366 defendant Everard Henry gent 587064 587064 Everard, Henry, of Denston, gent 0
3732391 1936366 1936366 defendant Colman John yeoman 587064 587064 Colman, John, of Denston, yeoman 1
3732392 1936366 1936366 defendant Hall Thomas yeoman 587064 587064 Hall, Thomas, of Denston, yeoman 2
3732394 1936367 1936367 defendant Everard Henry gent 587064 587064 Everard, Henry, of Denston, gent 0
3732395 1936367 1936367 defendant Colman John yeoman 587064 587064 Colman, John, of Denston, yeoman 1
3732396 1936367 1936367 defendant Hall Thomas yeoman 587064 587064 Hall, Thomas, of Denston, yeoman 2
3732402 1936369 1936369 defendant Colman John yeoman 587064 587064 Colman, John, of Denston, yeoman 0
3732403 1936369 1936369 defendant Hall Thomas yeoman 587064 587064 Hall, Thomas, of Denston, yeoman 1
3732404 1936369 1936369 defendant Swetyng John husbandman 587064 587064 Swetyng, John, of Denston, husbandman 2
3732405 1936369 1936369 defendant Everard Henry gent 587064 587064 Everard, Henry, of Denston, gent 3
3732407 1936370 1936370 defendant Everard Henry gent 587064 587064 Everard, Henry, of Denston, gent 0
3732408 1936370 1936370 defendant Colman John yeoman 587064 587064 Colman, John, of Denston, yeoman 1
3732409 1936370 1936370 defendant Hall Thomas yeoman 587064 587064 Hall, Thomas, of Denston, yeoman 2
3732410 1936370 1936370 defendant Swetyng John husbandman 587064 587064 Swetyng, John, of Denston, husbandman 3
3732412 1936371 1936371 defendant Everard Henry gent 587064 587064 Everard, Henry, of Denston, gent 0
3732413 1936371 1936371 defendant Colman John yeoman 587064 587064 Colman, John, of Denston, yeoman 1
3732414 1936371 1936371 defendant Hall Thomas yeoman 587064 587064 Hall, Thomas, of Denston, yeoman 2
3732415 1936371 1936371 defendant Swetyng John husbandman 587064 587064 Swetyng, John, of Denston, husbandman 3
3866744 1979114 1979114 plaintiff Ray John yeoman 587064 587064 Ray, John, of Denston, yeoman 0
3870349 1980331 1980331 defendant Ilger William husbandman 587064 587064 Ilger, William, of Denston, husbandman 6
3890695 1987154 1987154 defendant Fyssher Richard husbandman 587064 587064 Fyssher, Richard, of Denston, husbandman 1
3894075 1988234 1988234 defendant Fyssher Richard weaver 587064 587064 Fyssher, Richard, of Denston, weaver 2
3921984 1997698 1997698 plaintiff Raye Robert yeoman 587064 587064 Raye, Robert, of Denston, yeoman 0
4055362 2044316 2044316 defendant Madeley Thomas gent 587064 587064 Madeley, Thomas, of Denston, gent 0
4058653 2045485 2045485 defendant Bott Thomas husbandman 587064 587064 Bott, Thomas, of Denston, husbandman 1
4127666 2070186 2070186 defendant Abbott John husbandman 587064 587064 Abbott, John, of Denston, husbandman 0
4407348 2167019 2167019 defendant Neetam John husbandman 587064 587064 Neetam, John, of Denston, husbandman 2
4765537 2285213 2285213 defendant Wylke Thomas   587064 587064 Wylke, Thomas, of Denston, hoop maker 1
4837823 2307762 2307762 defendant Broune Richard   587064 587064 Broune, Richard, of Denston, wool man 0
4837824 2307762 2307762 defendant Frere John tailor 587064 587064 Frere, John, of Denston, tailor 1
4853189 2312413 2312413 defendant Broun Richard   587064 587064 Broun, Richard, of Denston, wool man 0
4906984 2328761 2328761 defendant Madeley Thomas yeoman 587064 587064 Madeley, Thomas, of Denston, yeoman 0
4909446 2329494 2329494 defendant Madeley Thomas gent 587064 587064 Madeley, Thomas, of Denston, gent 0
4959509 2344810 2344810 defendant Madeley Thomas gent 587064 587064 Madeley, Thomas, of Denston, gent 1
4986159 2352783 2352783 defendant Maddeley Thomas gent 587064 587064 Maddeley, Thomas, of Denston, gent 1
5036904 2367669 2367669 plaintiff Welwen John husbandman 587064 587064 Welwen, John, of Denston, husbandman 0
5341839 2457640 2457640 defendant Sendrell John chaplain 587064 587064 Sendrell, John, of Denston, chaplain 1
5373096 2467180 2467180 plaintiff Madeley Thomas (legal representative) 587064 587064 Madeley, Thomas, of Denston, executor of 0
5451352 2490280 2490280 defendant Sendale John clerk 587064 587064 Sendale, John, of Denston, clerk 2
5473466 2497025 2497025 defendant Tyddswall Richard husbandman 587064 587064 Tyddswall, Richard, of Denston, husbandman 0
5515070 2509558 2509558 defendant Godhelpe Thomas husbandman 587064 587064 Godhelpe, Thomas, of Denston, husbandman 1
5550322 2520114 2520114 defendant Clerke Michael tailor 587064 587064 Clerke, Michael, of Denston, tailor 1
5550323 2520114 2520114 defendant Jekman Margaret widow 587064 587064 Jekman, Margaret, of Denston, widow 2
5571126 2526117 2526117 defendant Spaldyng Henry yeoman 587064 587064 Spaldyng, Henry, of Denston, yeoman 2
5592007 2532489 2532489 defendant Coggessall John gent 587064 587064 Coggessall, John, of Denston, gent 1

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