names

49 rows where place_id = 603017

✎ 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
3652722 1911172 1911172 defendant Clerk Robert yeoman 603017 603017 Clerk, Robert, of Flete, Lincs, yeoman 0
3658642 1912958 1912958 defendant Roberdys William gent 603017 603017 Roberdys, William, of Flete, Lincs, gent 0
3940994 2003994 2003994 defendant Sowter William husbandman 603017 603017 Sowter, William, of Flete, Lincs, husbandman 1
3947102 2006053 2006053 plaintiff Chewne John   603017 603017 Chewne, John, of Flete, Lincs 0
3959871 2010544 2010544 defendant Egar Anthony gent 603017 603017 Egar, Anthony, of Flete, Lincs, gent 0
3959873 2010545 2010545 defendant Egar Anthony   603017 603017 Egar, Anthony, of Flete, Lincs, gent, seneschal of Thomas Earl of Sussex 0
3967861 2013386 2013386 defendant Thomas Edward husbandman 603017 603017 Thomas, Edward, of Flete, Lincs, husbandman 11
4544293 2214130 2214130 defendant Storme John, sen   603017 603017 Storme, John, sen, of Flete, Lincs 0
4587204 2227404 2227404 defendant Hood Thomas   603017 603017 Hood, Thomas, of Flete, Lincs 0
4651475 2246464 2246464 defendant de Grene John esq 603017 603017 de Grene, John, of Flete, Lincs, esq 0
4651478 2246465 2246465 defendant de Grene John esq 603017 603017 de Grene, John, of Flete, Lincs, esq 0
4658908 2248657 2248657 defendant Breton Alan husbandman 603017 603017 Breton, Alan, of Flete, Lincs, husbandman 1
4713810 2269645 2269645 defendant Grene William husbandman 603017 603017 Grene, William, of Flete, Lincs, husbandman 4
4773741 2287761 2287761 defendant Grene John gent 603017 603017 Grene, John, of Flete, Lincs, gent 0
4810503 2299431 2299431 defendant Braunche John   603017 603017 Braunche, John, of Flete, Lincs, esq, son & heir of Philip Brauche, knight 0
4818420 2301842 2301842 defendant Grene Robert husbandman 603017 603017 Grene, Robert, of Flete, Lincs, husbandman 0
4849832 2311420 2311420 defendant Braunch William gent 603017 603017 Braunch, William, of Flete, Lincs, gent 1
4856719 2313475 2313475 defendant Gammon John husbandman 603017 603017 Gammon, John, of Flete, Lincs, husbandman 2
4858086 2313899 2313899 defendant Braunche William gent 603017 603017 Braunche, William, of Flete, Lincs, gent 0
4858088 2313900 2313900 defendant Braunche William gent 603017 603017 Braunche, William, of Flete, Lincs, gent 0
4889114 2323385 2323385 defendant Tolle Simon weaver 603017 603017 Tolle, Simon, of Flete, Lincs, weaver 0
4900074 2326653 2326653 defendant Couper Simon yeoman 603017 603017 Couper, Simon, of Flete, Lincs, yeoman 3
4904496 2328014 2328014 defendant Couper Simon yeoman 603017 603017 Couper, Simon, of Flete, Lincs, yeoman 3
4909578 2329531 2329531 defendant Hummyng John chapman 603017 603017 Hummyng, John, of Flete, Lincs, chapman 0
4921024 2333087 2333087 defendant Grene Robert yeoman 603017 603017 Grene, Robert, of Flete, Lincs, yeoman 0
4946232 2340808 2340808 defendant Hunnyng John yeoman 603017 603017 Hunnyng, John, of Flete, Lincs, yeoman 0
4994954 2355350 2355350 defendant Williamson John yeoman 603017 603017 Williamson, John, of Flete, Lincs, yeoman 0
4995426 2355474 2355474 defendant Michell William husbandman 603017 603017 Michell, William, of Flete, Lincs, husbandman 0
4997520 2356110 2356110 defendant Margeretson Roger husbandman 603017 603017 Margeretson, Roger, of Flete, Lincs, husbandman 0
5034569 2366970 2366970 defendant Cokeney John carpenter 603017 603017 Cokeney, John, of Flete, Lincs, carpenter 1
5077423 2379746 2379746 defendant Haryngton John esq 603017 603017 Haryngton, John, of Flete, Lincs, esq 0
5103243 2387378 2387378 defendant Cotte John, junior husbandman 603017 603017 Cotte, John, junior, of Flete, Lincs, husbandman 0
5132456 2395986 2395986 defendant Teryngton William yeoman 603017 603017 Teryngton, William, of Flete, Lincs, yeoman 0
5132778 2396082 2396082 defendant Haryngton John   603017 603017 Haryngton, John, of Flete, Lincs 0
5141342 2398589 2398589 defendant Kyng Thomas chaplain 603017 603017 Kyng, Thomas, of Flete, Lincs, chaplain 8
5154674 2402521 2402521 defendant Johnson Gilbert chapman 603017 603017 Johnson, Gilbert, of Flete, Lincs, chapman 0
5157217 2403252 2403252 defendant Haryngton John esq 603017 603017 Haryngton, John, of Flete, Lincs, esq 0
5169785 2406906 2406906 defendant Hunnyng John husbandman 603017 603017 Hunnyng, John, of Flete, Lincs, husbandman 2
5173214 2407879 2407879 defendant Haryngton John esq 603017 603017 Haryngton, John, of Flete, Lincs, esq 0
5187476 2412055 2412055 defendant Braunche Henry esq 603017 603017 Braunche, Henry, of Flete, Lincs, esq 0
5205591 2417381 2417381 defendant Braunche Henry esq 603017 603017 Braunche, Henry, of Flete, Lincs, esq 0
5218143 2421040 2421040 defendant Talbot Brian esq 603017 603017 (Talbot, Brian, of Flete, Lincs, esq 4
5237404 2426524 2426524 defendant Austyn John husbandman 603017 603017 Austyn, John, of Flete, Lincs, husbandman 3
5237634 2426586 2426586 defendant Braunche Henry esq 603017 603017 Braunche, Henry, of Flete, Lincs, esq 0
5244740 2428635 2428635 defendant Cotte John husbandman 603017 603017 Cotte, John, of Flete, Lincs, husbandman 1
5245129 2428738 2428738 defendant Cotte John husbandman 603017 603017 Cotte, John, of Flete, Lincs, husbandman 1
5256408 2432130 2432130 defendant Austyn Roger husbandman 603017 603017 Austyn, Roger, of Flete, Lincs, husbandman 3
5340898 2457349 2457349 defendant Mychell Robert husbandman 603017 603017 Mychell, Robert, of Flete, Lincs, husbandman 0
5444016 2488128 2488128 defendant Pauke William yeoman 603017 603017 Pauke, William, of Flete, Lincs, yeoman 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);