names

50 rows where place_id = 611521

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3688747 1922641 1922641 defendant Goddyng Edward husbandman 611521 611521 Goddyng, Edward, of Thursford, husbandman 3
3827961 1966612 1966612 defendant Barret John warrener 611521 611521 Barret, John, of Thursford, warrener 0
3889600 1986752 1986752 defendant Foxe John husbandman 611521 611521 Foxe, John, of Thursford, husbandman 0
3896314 1988979 1988979 defendant Barrett John yeoman 611521 611521 Barrett, John, of Thursford, yeoman 3
3911946 1994320 1994320 defendant Barrett John husbandman 611521 611521 Barrett, John, of Thursford, husbandman 0
3913198 1994746 1994746 defendant Symson Robert yeoman 611521 611521 Symson, Robert, of Thursford, yeoman 0
3913199 1994746 1994746 defendant Howse William husbandman 611521 611521 Howse, William, of Thursford, husbandman 1
3913200 1994746 1994746 defendant Seman Robert tailor 611521 611521 Seman, Robert, of Thursford, tailor 2
3965287 2012476 2012476 defendant Sherman John yeoman 611521 611521 Sherman, John, of Thursford, yeoman 0
3965288 2012476 2012476 defendant Bonde Nicholas yeoman 611521 611521 Bonde, Nicholas, of Thursford, yeoman 1
3965300 2012479 2012479 defendant Sherman John yeoman 611521 611521 Sherman, John, of Thursford, yeoman 0
3965301 2012479 2012479 defendant Bonde Nicholas yeoman 611521 611521 Bonde, Nicholas, of Thursford, yeoman 1
3985553 2019597 2019597 defendant Stylbert John husbandman 611521 611521 Stylbert, John, of Thursford, husbandman 1
4055917 2044496 2044496 defendant Grene Richard husbandman 611521 611521 Grene, Richard, of Thursford, husbandman 0
4058389 2045386 2045386 defendant Bawles Thomas husbandman 611521 611521 Bawles, Thomas, of Thursford, husbandman 0
4093288 2057915 2057915 defendant Weston Gregory clerk 611521 611521 Weston, Gregory, of Thursford, clerk 2
4122297 2068283 2068283 defendant Weston Gregory clerk 611521 611521 Weston, Gregory, of Thursford, clerk 0
4132369 2071891 2071891 defendant Weston Gregory clerk 611521 611521 Weston, Gregory, of Thursford, clerk 0
4146239 2076835 2076835 defendant Maye William husbandman 611521 611521 Maye, William, of Thursford, husbandman 1
4148370 2077561 2077561 defendant Weston Gregory clerk 611521 611521 Weston, Gregory, of Thursford, clerk 1
4170469 2085163 2085163 defendant Weston Gregory clerk 611521 611521 Weston, Gregory, of Thursford, clerk 0
4172469 2085832 2085832 defendant Weston Gregory clerk 611521 611521 Weston, Gregory, of Thursford, clerk 3
4172971 2085999 2085999 defendant Wrytington Richard malster 611521 611521 Wrytington, Richard, of Thursford, yeoman, malster 0
4179776 2088401 2088401 defendant Weston Gregory clerk 611521 611521 Weston, Gregory, of Thursford, clerk 0
4180190 2088554 2088554 defendant Weston Gregory clerk 611521 611521 Weston, Gregory, of Thursford, clerk 0
4189863 2091953 2091953 defendant Comer John yeoman 611521 611521 Comer, John, of Thursford, yeoman 0
4215952 2101073 2101073 defendant Wrytington Richard yeoman 611521 611521 Wrytington, Richard, of Thursford, or of Blicklynge, yeoman 0
4225283 2104309 2104309 defendant Wrytington Richard   611521 611521 Wrytington, Richard, of Thursford, or of Blicjlyngm yeoman 0
4229736 2105881 2105881 defendant Wryghtyngton Richard yeoman 611521 611521 Wryghtyngton, Richard, of Thursford, yeoman 0
4242586 2110513 2110513 defendant Wryttington Richard yeoman 611521 611521 Wryttington, Richard, of Thursford, yeoman 1
4242591 2110514 2110514 defendant Wryttington Richard yeoman 611521 611521 Wryttington, Richard, of Thursford, yeoman 1
4250468 2113143 2113143 defendant Weston George clerk 611521 611521 Weston, George, of Thursford, clerk 0
4251273 2113401 2113401 defendant Chapman Martin yeoman 611521 611521 Chapman, Martin, of Thursford, yeoman 0
4255177 2114718 2114718 defendant Sabbe John gent 611521 611521 Sabbe, John, of Thursford, gent 1
4256233 2115064 2115064 defendant Fysshe Oliver husbandman 611521 611521 Fysshe, Oliver, of Thursford, husbandman 1
4257013 2115319 2115319 defendant Foxe Christopher yeoman 611521 611521 Foxe, Christopher, of Thursford, yeoman 0
4260447 2116462 2116462 defendant Fyshe John miller 611521 611521 Fyshe, John, of Thursford, miller 0
4274962 2121195 2121195 defendant Wrytington Richard yeoman 611521 611521 Wrytington, Richard, of Thursford, yeoman 2
4275621 2121417 2121417 defendant Weston Gregory clerk 611521 611521 Weston, Gregory, of Thursford, clerk 0
4281234 2123346 2123346 defendant Writington Richard yeoman 611521 611521 Writington, Richard, of Thursford, yeoman 0
4281485 2123427 2123427 defendant Rolf Henry gent 611521 611521 Rolf, Henry, of Thursford, gent 0
4311918 2134305 2134305 defendant Weston Gregory clerk 611521 611521 Weston, Gregory, of Thursford, clerk 0
4311969 2134322 2134322 defendant Comber John husbandman 611521 611521 Comber, John, of Thursford, husbandman 0
4316921 2136033 2136033 defendant Foxe Christopher husbandman 611521 611521 Foxe, Christopher, of Thursford, husbandman 0
4323165 2138161 2138161 defendant Foxe Christopher yeoman 611521 611521 Foxe, Christopher, of Thursford, yeoman 1
4332582 2141185 2141185 defendant Mondy Robert carpenter 611521 611521 Mondy, Robert, of Thursford, carpenter 1
4357499 2149853 2149853 defendant Foxe Christopher yeoman 611521 611521 Foxe, Christopher, of Thursford, yeoman 0
4387563 2160480 2160480 defendant Gryffyn Robert carpenter 611521 611521 Gryffyn, Robert, of Thursford, carpenter 0
4387564 2160480 2160480 defendant Dodman Martin laborer 611521 611521 Dodman, Martin, of Thursford, laborer 1
4393268 2162353 2162353 defendant Danham Edmund laborer 611521 611521 Danham, Edmund, of Thursford, laborer 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);