names

62 rows where place_id = 615362

✎ 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
3708480 1928951 1928951 defendant Cowper Stephen mercer 615362 615362 Cowper, Stephen, of Disse, mercer 1
3710149 1929489 1929489 defendant Coke Robert mercer 615362 615362 Coke, Robert, of Disse, mercer 0
3737794 1938042 1938042 defendant Smyth Walter shoemaker 615362 615362 Smyth, Walter, of Disse, shoemaker 0
3766238 1947094 1947094 plaintiff Mably Robert   615362 615362 Mably, Robert, of Disse 0
3779955 1951456 1951456 defendant Harvy John husbandman 615362 615362 Harvy, John, of Disse, husbandman 0
3783120 1952477 1952477 defendant Chapman John courser 615362 615362 Chapman, John, of Disse, courser 1
3790373 1954805 1954805 defendant Chapman John husbandman 615362 615362 Chapman, John, of Disse, husbandman 0
3802714 1958745 1958745 defendant Goos John   615362 615362 Goos, John, of Disse, wheelwright 2
3921043 1997387 1997387 defendant Bek Thomas yeoman 615362 615362 Bek, Thomas, of Disse, yeoman 0
3921045 1997388 1997388 defendant Hunt Robert yeoman 615362 615362 Hunt, Robert, of Disse, yeoman 0
3969169 2013825 2013825 defendant Browne George butcher 615362 615362 Browne, George, of Disse, butcher 1
3982299 2018440 2018440 defendant Harrold John fishmonger 615362 615362 Harrold, John, of Disse, fishmonger 0
4021611 2032455 2032455 defendant Godeare Michael husbandman 615362 615362 Godeare, Michael, of Disse, husbandman 2
4057364 2045015 2045015 defendant Crispe Robert husbandman 615362 615362 Crispe, Robert, of Disse, husbandman 0
4100959 2060659 2060659 defendant Dane Henry   615362 615362 Dane, Henry, of Disse, hatter, or of London, felt maker 1
4123386 2068667 2068667 defendant Oke Robert saddler 615362 615362 Oke, Robert, of Disse, saddler 0
4144309 2076170 2076170 defendant Downes John   615362 615362 Downes, John, of Disse, wheelwright 3
4184933 2090237 2090237 defendant Wisman Avery blacksmith 615362 615362 Wisman, Avery, of Disse, blacksmith 0
4226090 2104596 2104596 defendant Rix William yeoman 615362 615362 Rix, William, of Disse, yeoman 0
4236244 2108245 2108245 defendant Fulcher Henry innholder 615362 615362 Fulcher, Henry, of Disse, innholder 3
4245507 2111472 2111472 defendant Folzier Andrew yeoman 615362 615362 Folzier, Andrew, of Disse, yeoman 1
4277128 2121934 2121934 defendant Bennett Thomas glover 615362 615362 Bennett, Thomas, of Disse, glover 0
4284815 2124614 2124614 defendant Godfrye William yeoman 615362 615362 Godfrye, William, of Disse, yeoman 3
4284819 2124615 2124615 defendant Aldred Roger yeoman 615362 615362 Aldred, Roger, of Disse, yeoman 2
4285701 2124935 2124935 defendant Garboldeysham Andrew yeoman 615362 615362 Garboldeysham, Andrew, of Disse, yeoman 2
4315481 2135523 2135523 defendant Coxe Richard clerk 615362 615362 Coxe, Richard, of Disse, clerk 0
4468655 2190868 2190868 defendant Bacoun John   615362 615362 Bacoun, John, of Disse 0
4517838 2205966 2205966 defendant Smyth John   615362 615362 Smyth, John, of Disse 1
4525151 2208207 2208207 defendant Edward John   615362 615362 Edward, John, of Disse 4
4544208 2214106 2214106 plaintiff Barkere (illegible)   615362 615362 Barkere, _, of Disse 0
4546249 2214769 2214769 defendant Wymere Reginald   615362 615362 Wymere, Reginald, of Disse 4
4546250 2214769 2214769 defendant Alrede William   615362 615362 Alrede, William, of Disse 5
4546251 2214769 2214769 defendant Camp John   615362 615362 Camp, John, of Disse 6
4570396 2222315 2222315 defendant Stokke Nicholas clerk 615362 615362 Stokke, Nicholas, of Disse, clerk 0
4570401 2222316 2222316 defendant Stok Nicholas clerk 615362 615362 Stok, Nicholas, of Disse, clerk 0
4570482 2222341 2222341 defendant Skowedere William   615362 615362 Skowedere, William, of Disse 4
4593911 2229371 2229371 defendant Barker John   615362 615362 Barker, John, of Disse 1
4598349 2230724 2230724 defendant Barkere John   615362 615362 Barkere, John, of Disse 0
4598353 2230726 2230726 defendant Barkere John   615362 615362 Barkere, John, of Disse 0
4620862 2237504 2237504 defendant Melton John   615362 615362 Melton, John, of Disse 1
4672446 2257034 2257034 defendant Selot William dyer 615362 615362 Selot, William, of Disse, dyer 1
4772405 2287336 2287336 defendant Gyssyng Ralph yeoman 615362 615362 Gyssyng, Ralph, of Disse, yeoman 1
4784986 2291318 2291318 defendant Reyner Henry baker 615362 615362 Reyner, Henry, of Disse, baker 1
4793236 2293980 2293980 defendant Hore John carpenter 615362 615362 Hore, John, of Disse, carpenter 0
4949857 2341940 2341940 defendant Buskard Walter husbandman 615362 615362 Buskard, Walter, of Disse, husbandman 9
5143541 2399246 2399246 defendant Spycer Edmund mercer 615362 615362 Spycer, Edmund, of Disse, mercer 2
5146260 2400036 2400036 defendant Tateshale Richard clerk 615362 615362 Tateshale, Richard, of Disse, clerk 0
5147446 2400400 2400400 defendant Purchas Edmund chapman 615362 615362 Purchas, Edmund, of Disse, chapman 0
5147447 2400400 2400400 defendant Walsham John tailor 615362 615362 Walsham, John, of Disse, tailor 1
5156899 2403166 2403166 defendant Tateshale Richard clerk 615362 615362 Tateshale, Richard, of Disse, clerk 1
5165434 2405635 2405635 defendant Tateshale Richard clerk 615362 615362 Tateshale, Richard, of Disse, clerk 0
5208085 2418096 2418096 defendant Smyth John yeoman 615362 615362 Smyth, John, of Disse, yeoman 3
5320905 2451340 2451340 defendant Couper Richard husbandman 615362 615362 Couper, Richard, of Disse, husbandman 1
5351489 2460562 2460562 plaintiff Debenham Stephen yeoman 615362 615362 Debenham, Stephen, of Disse, yeoman 0
5563708 2523994 2523994 defendant Yonger Thomas yeoman 615362 615362 Yonger, Thomas, of Disse, yeoman 0
5573859 2526923 2526923 plaintiff Pryke John, senior (legal representative) 615362 615362 Pryke, John, senior, of Disse, executors of 0
5574039 2526969 2526969 defendant Hodyrsall Adam (legal representative) 615362 615362 Hodyrsall, Adam, of Disse, gent, executors of 0
5578319 2528289 2528289 plaintiff Anour or Avour Edmund   615362 615362 (Anour or Avour, Edmund, of Disse 1
5597880 2534237 2534237 defendant Rebet Robert, senior husbandman 615362 615362 Rebet, Robert, senior, of Disse, husbandman 0
5600008 2534885 2534885 plaintiff Harman Reginald (legal representative) 615362 615362 Harman, Reginald, of Disse, executrix of 0
5611060 2547180 2547180 plaintiff Berkyng John de   615362 615362 Berkyng, John de, of Disse, parson 0
5612392 2547622 2547622 defendant Adam Stephen   615362 615362 Adam, Stephen, of Disse 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);