names

56 rows where place_id = 594671

✎ 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
3617126 1872981 1872981 defendant Godale John clerk 594671 594671 Godale, John, of Felthorp, clerk 0
3626746 1903210 1903210 defendant Fawner John   594671 594671 Fawner, John, of Felthorp, worsted weaver 0
3628049 1903625 1903625 defendant Russell John husbandman 594671 594671 Russell, John, of Felthorp, husbandman 2
3648714 1909984 1909984 defendant Cutbald Thomas husbandman 594671 594671 Cutbald, Thomas, of Felthorp, husbandman 3
3650183 1910427 1910427 defendant Davy William yeoman 594671 594671 Davy, William, of Felthorp, yeoman 0
3650184 1910427 1910427 defendant Barker Robert (legal representative) 594671 594671 Barker, Robert, of Felthorp, husbandman, executors of 1
3708759 1929036 1929036 defendant Bundy Henry husbandman 594671 594671 Bundy, Henry, of Felthorp, husbandman 1
3734932 1937163 1937163 defendant Russell John husbandman 594671 594671 Russell, John, of Felthorp, husbandman 6
3815451 1962749 1962749 defendant Wenne Thomas, junior laborer 594671 594671 Wenne, Thomas, junior, of Felthorp, laborer 2
3815452 1962749 1962749 defendant Palmer John husbandman 594671 594671 Palmer, John, of Felthorp, husbandman 3
3825859 1965937 1965937 defendant Russell Thomas husbandman 594671 594671 Russell, Thomas, of Felthorp, husbandman 1
3852695 1974451 1974451 defendant Grove John husbandman 594671 594671 Grove, John, of Felthorp, husbandman 1
3862442 1977633 1977633 defendant Wenne Peter husbandman 594671 594671 Wenne, Peter, of Felthorp, husbandman 0
3867236 1979279 1979279 defendant Wenne Peter husbandman 594671 594671 Wenne, Peter, of Felthorp, husbandman 0
3867237 1979279 1979279 defendant Hastynge Robert husbandman 594671 594671 Hastynge, Robert, of Felthorp, husbandman 1
3867238 1979279 1979279 defendant Emondes Robert husbandman 594671 594671 Emondes, Robert, of Felthorp, husbandman 2
3966146 2012787 2012787 defendant Lyon Henry husbandman 594671 594671 Lyon, Henry, of Felthorp, husbandman 0
3967392 2013225 2013225 defendant Lyon Henry husbandman 594671 594671 Lyon, Henry, of Felthorp, husbandman 0
3967402 2013229 2013229 defendant Lyon Henry husbandman 594671 594671 Lyon, Henry, of Felthorp, husbandman 0
3982434 2018490 2018490 defendant Lyon Henry husbandman 594671 594671 Lyon, Henry, of Felthorp, husbandman 0
4112378 2064685 2064685 defendant Grene Robert husbandman 594671 594671 Grene, Robert, of Felthorp, husbandman 2
4241432 2110118 2110118 defendant Flegg William clerk 594671 594671 Flegg, William, of Felthorp, clerk 1
4241436 2110119 2110119 defendant Flegg William clerk 594671 594671 Flegg, William, of Felthorp, clerk 1
4638724 2242855 2242855 defendant Yernemuth Thomas de   594671 594671 Yernemuth, Thomas de, of Felthorp, son of Thomas 1
4650637 2246205 2246205 defendant Cok Robert   594671 594671 Cok, Robert, of Felthorp 1
4699739 2265361 2265361 defendant shepherd Nicholas   594671 594671 shepherd, Nicholas, of Felthorp, shepherd 2
4710809 2268735 2268735 defendant Hunte Richard yeoman 594671 594671 Hunte, Richard, of Felthorp, yeoman 2
4740109 2277624 2277624 plaintiff atte Chirche William   594671 594671 atte Chirche, William, of Felthorp, on his own account 0
4741526 2278017 2278017 defendant Shell John yeoman 594671 594671 Shell, John, of felthorp, yeoman 1
4741527 2278017 2278017 defendant atte Chirche Thomas yeoman 594671 594671 atte Chirche, Thomas, of Felthorp, yeoman 2
4741528 2278017 2278017 defendant Todenham John, junior yeoman 594671 594671 Todenham, John, junior, of Felthorp, yeoman 3
4741638 2278046 2278046 defendant atte Cherche Thomas husbandman 594671 594671 atte Cherche, Thomas, of Felthorp, husbandman 12
4782122 2290408 2290408 defendant Egeleyn Thomas yeoman 594671 594671 Egeleyn, Thomas, of Felthorp, yeoman 0
4901223 2326991 2326991 defendant Snape Nicholas laborer 594671 594671 Snape, Nicholas, of Felthorp, laborer 0
4946672 2340961 2340961 defendant Den Thomas husbandman 594671 594671 Den, Thomas, of Felthorp, husbandman 0
5008639 2359423 2359423 defendant Grene William yeoman 594671 594671 Grene, William, of Felthorp, yeoman 3
5016859 2361826 2361826 defendant Grene William husbandman 594671 594671 Grene, William, of Felthorp, husbandman 4
5078725 2380126 2380126 defendant Bettys Thomas clerk 594671 594671 Bettys, Thomas, of Felthorp, clerk 0
5321027 2451383 2451383 defendant Feld William   594671 594671 Feld, William, of Felthorp, tile burner 0
5321031 2451384 2451384 defendant Feld William   594671 594671 Feld, William, of Felthorp, tile burner 2
5395105 2473668 2473668 defendant Trewe John husbandman 594671 594671 Trewe, John, of Felthorp, husbandman 3
5418084 2480334 2480334 defendant Trewe John husbandman 594671 594671 Trewe, John, of Felthorp, husbandman 2
5435809 2485652 2485652 defendant Trewe John husbandman 594671 594671 Trewe, John, of Felthorp, husbandman 2
5438727 2486513 2486513 defendant Randolf Thomas husbandman 594671 594671 Randolf, Thomas, of Felthorp, husbandman 4
5452629 2490670 2490670 defendant Ra_ John (legal representative) 594671 594671 Ra_, John, of Felthorp, executor of 3
5464554 2494319 2494319 defendant Randolf John (legal representative) 594671 594671 Randolf, John, of Felthorp, executor of 3
5464555 2494319 2494319 defendant Randolf Thomas husbandman 594671 594671 Randolf, Thomas, of Felthorp, husbandman 4
5544569 2518413 2518413 defendant Harward Thomas husbandman 594671 594671 Harward, Thomas, of Felthorp, husbandman 0
5565585 2524526 2524526 defendant Harward Thomas husbandman 594671 594671 Harward, Thomas, of Felthorp, husbandman 0
5567278 2525007 2525007 defendant Bernard John husbandman 594671 594671 Bernard, John, of Felthorp, husbandman 0
5567569 2525087 2525087 defendant Baker Richard husbandman 594671 594671 Baker, Richard, of Felthorp, husbandman 0
5567571 2525087 2525087 defendant Randolff Thomas husbandman 594671 594671 Randolff, Thomas, of Felthorp, husbandman 2
5573301 2526748 2526748 defendant Barnard John husbandman 594671 594671 Barnard, John, of Felthorp, husbandman 1
5582160 2529491 2529491 defendant Harward John husbandman 594671 594671 Harward, John, of Felthorp, husbandman 0
5583035 2529767 2529767 defendant Russell John yeoman 594671 594671 Russell, John, of Felthorp, yeoman 1
5594154 2533148 2533148 defendant Russell John husbandman 594671 594671 Russell, John, of Felthorp, husbandman 4

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