names

97 rows where place_id = 604831

✎ 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
3659417 1913206 1913206 defendant Baker John husbandman 604831 604831 Baker, John, of Somersham, husbandman 3
3685483 1921613 1921613 plaintiff Barker Thomas yeoman 604831 604831 Barker, Thomas, of Somersham, yeoman 0
3687970 1922399 1922399 plaintiff Cooke Richard yeoman 604831 604831 Cooke, Richard, of Somersham, yeoman 0
3702882 1927173 1927173 plaintiff Cook Richard yeoman 604831 604831 Cook, Richard, of Somersham, yeoman 0
3759938 1945104 1945104 plaintiff Cooke Richard   604831 604831 Cooke, Richard, of Somersham 0
3762425 1945892 1945892 plaintiff Gilbert Richard yeoman 604831 604831 Gilbert, Richard, of Somersham, yeoman 0
3812227 1961727 1961727 plaintiff Cooke Richard   604831 604831 Cooke, Richard, of Somersham 0
3812230 1961728 1961728 plaintiff Cooke Richard   604831 604831 Cooke, Richard, of Somersham 0
3837575 1969659 1969659 defendant Hart Thomas yeoman 604831 604831 Hart, Thomas, of Somersham, yeoman 3
3861857 1977425 1977425 plaintiff Gilberd Richard yeoman 604831 604831 Gilberd, Richard, of Somersham, yeoman 0
3862334 1977591 1977591 plaintiff Gylbert Richard yeoman 604831 604831 Gylbert, Richard, of Somersham, yeoman 0
3865164 1978554 1978554 defendant Clyfford Edward husbandman 604831 604831 Clyfford, Edward, of Somersham, husbandman 0
3874303 1981631 1981631 plaintiff Courtnall Nicholas tailor 604831 604831 Courtnall, Nicholas, of Somersham, tailor 0
3875998 1982225 1982225 defendant Justuce William husbandman 604831 604831 Justuce, William, of Somersham, husbandman 0
3882445 1984394 1984394 defendant Cole William husbandman 604831 604831 Cole, William, of Somersham, husbandman 0
3903890 1991539 1991539 plaintiff Gylberd Richard yeoman 604831 604831 Gylberd, Richard, of Somersham, yeoman 0
3917049 1996060 1996060 plaintiff Gilberd Richard yeoman 604831 604831 Gilberd, Richard, of Somersham, yeoman 0
3924128 1998381 1998381 defendant Stegold Robert laborer 604831 604831 Stegold, Robert, of Somersham, laborer 1
3924129 1998381 1998381 defendant Cole Thomas laborer 604831 604831 Cole, Thomas, of Somersham, laborer 2
3935921 2002330 2002330 defendant Cooke John chapman 604831 604831 Cooke, John, of Somersham, chapman 0
4002150 2025553 2025553 defendant Barker John butcher 604831 604831 Barker, John, of Somersham, butcher 0
4002152 2025554 2025554 defendant Barker John butcher 604831 604831 Barker, John, of Somersham, butcher 0
4071208 2050006 2050006 defendant Pratt Alexander husbandman 604831 604831 Pratt, Alexander, of Somersham, husbandman 0
4165634 2083480 2083480 defendant Cole John yeoman 604831 604831 Cole, John, of Somersham, yeoman 3
4195658 2094036 2094036 defendant Jackson John butcher 604831 604831 Jackson, John, of Somersham, butcher 0
4211022 2099412 2099412 defendant Sapster Edward husbandman 604831 604831 Sapster, Edward, of Somersham, husbandman 0
4211023 2099412 2099412 defendant Madenheade William husbandman 604831 604831 Madenheade, William, of Somersham, husbandman 1
4286905 2125370 2125370 defendant Ashwood Nicholas husbandman 604831 604831 Ashwood, Nicholas, of Somersham, husbandman 3
4294090 2127967 2127967 defendant Hobson Tobias husbandman 604831 604831 Hobson, Tobias, of Somersham, husbandman 0
4294091 2127967 2127967 defendant Harman Edmund butcher 604831 604831 Harman, Edmund, of Somersham, butcher 1
4294092 2127967 2127967 defendant Burges Oringer husbandman 604831 604831 Burges, Oringer, of Somersham, husbandman 2
4294093 2127967 2127967 defendant Jackson Leonard husbandman 604831 604831 Jackson, Leonard, of Somersham, husbandman 3
4294126 2127977 2127977 defendant Ashewood Nicholas husbandman 604831 604831 Ashewood, Nicholas, of Somersham, husbandman 1
4294127 2127977 2127977 defendant Turner William husbandman 604831 604831 Turner, William, of Somersham, husbandman 2
4297639 2129260 2129260 defendant Martyn Thomas husbandman 604831 604831 Martyn, Thomas, of Somersham, husbandman 0
4306740 2132496 2132496 defendant Horne Thomas yeoman 604831 604831 Horne, Thomas, of Somersham, yeoman 0
4308894 2133261 2133261 defendant Vascatt Richard gent 604831 604831 Vascatt, Richard, of Somersham, gent 0
4353986 2148620 2148620 defendant Ladbrooke James weaver 604831 604831 Ladbrooke, James, of Somersham, weaver 0
4354021 2148634 2148634 defendant Bettes Robert yeoman 604831 604831 Bettes, Robert, of Somersham, yeoman 0
4407608 2167111 2167111 defendant Seame Thomas yeoman 604831 604831 Seame, Thomas, of Somersham, yeoman 0
4407610 2167111 2167111 defendant Martyn Thomas yeoman 604831 604831 Martyn, Thomas, of Somersham, yeoman 2
4414596 2169471 2169471 plaintiff Edmund Nicholas   604831 604831 Edmund, Nicholas, of Somersham 0
4439619 2181658 2181658 defendant Brampton John   604831 604831 Brampton, John, of Somersham 0
4441709 2182344 2182344 defendant Engs John, senior   604831 604831 Engs, John, senior, of Somersham 0
4469098 2191002 2191002 plaintiff Bilholte John   604831 604831 Bilholte, John, of Somersham, parson 0
4474158 2192571 2192571 plaintiff Deleholt John   604831 604831 Deleholt, John, of Somersham, parson 0
4521397 2207036 2207036 defendant Gardyner Rose   604831 604831 Gardyner, Rose, of Somersham 0
4583242 2226184 2226184 defendant Lawe Alan   604831 604831 Lawe, Alan, of Somersham 0
4594392 2229505 2229505 plaintiff Pollard Thomas   604831 604831 Pollard, Thomas, of Somersham 0
4618867 2236897 2236897 plaintiff Hemyngton John   604831 604831 Hemyngton, John, of Somersham 0
4639447 2243053 2243053 plaintiff Cook Walter   604831 604831 Cook, Walter, of Somersham, parson 0
4656456 2247915 2247915 defendant Webster John husbandman 604831 604831 Webster, John, of Somersham, husbandman 0
4658077 2248406 2248406 defendant Cokfeld Andrew husbandman 604831 604831 Cokfeld, Andrew, of Somersham, husbandman 0
4693030 2263328 2263328 defendant Dey Hugh butcher 604831 604831 Dey, Hugh, of Somersham, butcher 5
4693031 2263328 2263328 defendant Roway John husbandman 604831 604831 Roway, John, of Somersham, husbandman 6
4693032 2263328 2263328 defendant Norman Nicholas yeoman 604831 604831 Norman, Nicholas, of Somersham, yeoman 7
4706943 2267551 2267551 defendant Deye Hugh butcher 604831 604831 Deye, Hugh, of Somersham, butcher 0
4706945 2267551 2267551 defendant Spenser John butcher 604831 604831 Spenser, John, of Somersham, butcher 2
4736446 2276532 2276532 plaintiff Taillour Robert (legal representative) 604831 604831 Taillour, Robert, of Somersham, executors of 0
4736448 2276532 2276532 plaintiff Taillour John   604831 604831 Taillour, John, of Somersham, son of Robert 2
4747096 2279657 2279657 defendant Baldesman Alan husbandman 604831 604831 Baldesman, Alan, of Somersham, husbandman 0
4780364 2289855 2289855 defendant Wodward John butcher 604831 604831 Wodward, John, of Somersham, butcher 0
4785295 2291418 2291418 defendant Lodere Robert husbandman 604831 604831 Lodere, Robert, of Somersham, husbandman 2
4905998 2328477 2328477 defendant Dodyngton Richard husbandman 604831 604831 Dodyngton, Richard, of Somersham, husbandman 0
4908553 2329232 2329232 defendant Baker William husbandman 604831 604831 Baker, William, of Somersham, husbandman 1
4908569 2329236 2329236 defendant Baker William husbandman 604831 604831 Baker, William, of Somersham, husbandman 1
4961490 2345399 2345399 defendant Budmo Thomas husbandman 604831 604831 Budmo, Thomas, of Somersham, husbandman 1
4961491 2345399 2345399 defendant Aleyn John husbandman 604831 604831 Aleyn, John, of Somersham, husbandman 2
4961495 2345400 2345400 defendant Budnoo Thomas husbandman 604831 604831 Budnoo, Thomas, of Somersham, husbandman 1
4961496 2345400 2345400 defendant Aleyn John husbandman 604831 604831 Aleyn, John, of Somersham, husbandman 2
4969395 2347801 2347801 defendant Hervy John husbandman 604831 604831 Hervy, John, of Somersham, husbandman 2
5001091 2357196 2357196 defendant Vyncent Alice widow 604831 604831 Vyncent, Alice, of Somersham, widow 0
5001093 2357196 2357196 defendant Goldyngham John yeoman 604831 604831 Goldyngham, John, of Somersham, yeoman 2
5030164 2365691 2365691 defendant Brygges Thomas husbandman 604831 604831 Brygges, Thomas, of Somersham, husbandman 2
5031725 2366148 2366148 defendant Deye Thomas butcher 604831 604831 Deye, Thomas, of Somersham, butcher 0
5057383 2373776 2373776 defendant Pilbergh John butcher 604831 604831 Pilbergh, John, of Somersham, butcher 4
5058806 2374198 2374198 defendant Felyp John husbandman 604831 604831 Felyp, John, of Somersham, husbandman 2
5059888 2374524 2374524 defendant Phelipp Thomas husbandman 604831 604831 Phelipp, Thomas, of Somersham, husbandman 0
5059889 2374524 2374524 defendant Phelipp John husbandman 604831 604831 Phelipp, John, of Somersham, husbandman 1
5116074 2391130 2391130 defendant Pylbarowe John yeoman 604831 604831 Pylbarowe, John, of Somersham, yeoman 1
5211952 2419234 2419234 defendant Fuller John husbandman 604831 604831 Fuller, John, of Somersham, husbandman 0
5247488 2429420 2429420 defendant Pope John husbandman 604831 604831 Pope, John, of Somersham, husbandman 0
5254551 2431545 2431545 defendant Rowey Richard husbandman 604831 604831 Rowey, Richard, of Somersham, husbandman 1
5519441 2510930 2510930 plaintiff Berd John   604831 604831 Berd, John, of Somersham 0
5555157 2521514 2521514 defendant Benet William husbandman 604831 604831 Benet, William, of Somersham, husbandman 0
5555158 2521514 2521514 defendant Hye John husbandman 604831 604831 Hye, John, of Somersham, husbandman 1
5555159 2521514 2521514 defendant Clerk Thomas husbandman 604831 604831 Clerk, Thomas, of Somersham, husbandman 2
5555160 2521514 2521514 defendant Corbet John husbandman 604831 604831 Corbet, John, of Somersham, husbandman 3
5555161 2521514 2521514 defendant Harvy John husbandman 604831 604831 Harvy, John, of Somersham, husbandman 4
5555162 2521514 2521514 defendant Baven Thomas husbandman 604831 604831 Baven, Thomas, of Somersham, husbandman 5
5555163 2521514 2521514 defendant Day John, junior husbandman 604831 604831 Day, John, junior, of Somersham, husbandman 6
5565921 2524635 2524635 plaintiff Chaplen William   604831 604831 Chaplen, William, of Somersham 0
5569926 2525780 2525780 defendant Jemys John chaplain 604831 604831 Jemys, John, of Somersham, chaplain 0
5592829 2532758 2532758 defendant Haynys William husbandman 604831 604831 Haynys, William, of Somersham, husbandman 0
5615172 2548539 2548539 defendant Carpenter John   604831 604831 Carpenter, John, of Somersham 1
5633217 2554393 2554393 plaintiff Taillour Robert   604831 604831 Taillour, Robert, of Somersham 0
5633377 2554434 2554434 plaintiff Tayllour Robert   604831 604831 Tayllour, Robert, of Somersham 0

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