names

82 rows where place_id = 756295

✎ 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
4415912 2169860 2169860 defendant Cobbe Richard   756295 756295 Cobbe, Richard, of Andevere or Andover 0
4436393 2176121 2176121 plaintiff Selyde John   756295 756295 Selyde, John, of Andevere 0
4436394 2176121 2176121 defendant Foxcote John de   756295 756295 Foxcote, John de, of Andevere 0
4436395 2176121 2176121 defendant Asselyn Thomas   756295 756295 Asselyn, Thomas, of Andevere 1
4437199 2176379 2176379 defendant Foxcote John de   756295 756295 Foxcote, John de, of Andevere 0
4437200 2176379 2176379 defendant Asselyn Thomas   756295 756295 Asselyn, Thomas, of Andevere 1
4443547 2182948 2182948 defendant Diere Simon   756295 756295 Diere, Simon, of Andevere 0
4446946 2183962 2183962 plaintiff Draper Nichola   756295 756295 Draper, Nichola, of Andevere, on her own account 0
4449382 2184752 2184752 plaintiff Glovere William   756295 756295 Glovere, William, of Andevere or Andover 0
4459477 2188015 2188015 defendant Pensay John   756295 756295 Pensay, John, of Andevere or Andover 0
4475932 2193145 2193145 defendant Joce Henry   756295 756295 Joce, Henry, of Andevere 0
4476451 2193299 2193299 defendant Chyld Robert   756295 756295 Chyld, Robert, of Andevere, millward 0
4556631 2218006 2218006 defendant Short John dyer 756295 756295 Short, John, of Andevere, dyer 1
4559680 2218983 2218983 defendant Premer William   756295 756295 Premer, William, of Andevere 0
4562896 2219960 2219960 defendant Pypere William   756295 756295 Pypere, William, of Andevere 2
4606282 2233076 2233076 defendant Bailly John   756295 756295 Bailly, John, of andevere 2
4666190 2250896 2250896 defendant Robus or Robins John tailor 756295 756295 Robus or Robins, John, of Andevere, tailor 0
4668655 2255909 2255909 defendant Crane William chapman 756295 756295 Crane, William, of Andevere, chapman 0
4668656 2255909 2255909 defendant Blake John hosier 756295 756295 Blake, John, of Andevere, hosier 1
4687074 2261561 2261561 defendant Fort John shoemaker 756295 756295 Fort, John, of Andevere, shoemaker 9
4687075 2261561 2261561 defendant Danyell John carpenter 756295 756295 Danyell, John, of Andevere, carpenter 10
4687134 2261581 2261581 plaintiff Stacy Robert   756295 756295 Stacy, Robert, of Andevere 0
4687135 2261581 2261581 defendant Lucas Thomas gent 756295 756295 Lucas, Thomas, of Andevere, gent 0
4687136 2261581 2261581 defendant Baunebury Ralph husbandman 756295 756295 Baunebury, Ralph, of Andevere, husbandman 1
4688792 2262050 2262050 defendant Bayly John chapman 756295 756295 Bayly, John, of Andevere, chapman 3
4689416 2262249 2262249 defendant Stacy Robert husbandman 756295 756295 Stacy, Robert, of Andevere, husbandman 0
4689417 2262249 2262249 defendant Hale William husbandman 756295 756295 Hale, William, of Andevere, husbandman 1
4691214 2262772 2262772 defendant Stacy Robert husbandman 756295 756295 Stacy, Robert, of Andevere, husbandman 0
4691215 2262772 2262772 defendant Hale William husbandman 756295 756295 Hale, William, of Andevere, husbandman 1
4740943 2277860 2277860 defendant Smyth Alexander husbandman 756295 756295 Smyth, Alexander, of Andevere, husbandman 0
4740944 2277860 2277860 defendant Edward John husbandman 756295 756295 Edward, John, of Andevere, husbandman 1
4741499 2278008 2278008 defendant Edwardes John husbandman 756295 756295 Edwardes, John, of Andevere, husbandman 0
4752641 2281234 2281234 defendant Smyth Alexander husbandman 756295 756295 Smyth, Alexander, of Andevere, husbandman 0
4776933 2288773 2288773 defendant Baker Philip baker 756295 756295 Baker, Philip, of Andevere, baker 4
4777550 2288974 2288974 defendant Bastard William baker 756295 756295 Bastard, William, of Andevere, baker 0
4779622 2289613 2289613 defendant Crikkelade Nicholas gent 756295 756295 Crikkelade, Nicholas, of Andevere, gent 0
4779623 2289613 2289613 defendant Hayne Thomas chandler 756295 756295 Hayne, Thomas, of Andevere, chandler 1
4779625 2289613 2289613 defendant Milward Walter   756295 756295 Milward, Walter, of Andevere, millward 3
4779626 2289613 2289613 defendant Dyker John laborer 756295 756295 Dyker, John, of Andevere, laborer 4
4779627 2289613 2289613 defendant Crikkelade William Nicolasservant   756295 756295 Crikkelade, William Nicolasservant, of Andevere, servant 5
4779636 2289617 2289617 defendant Knave William husbandman 756295 756295 Knave, William, of Andevere, husbandman 0
4779749 2289659 2289659 defendant Hayne Thomas chandler 756295 756295 Hayne, Thomas, of Andevere, chandler 0
4779750 2289659 2289659 defendant Hayne Alice   756295 756295 Alice his wife, alias Alice Fugh, of Andevere 1
4782732 2290615 2290615 defendant Fyge John   756295 756295 Fyge, John, of Andevere, Hantsm hosteler 1
4784240 2291069 2291069 defendant Eyre George mercer 756295 756295 Eyre, George, of Andevere, mercer 0
4793870 2294207 2294207 defendant Wallop Henry fishmonger 756295 756295 Wallop, Henry, of Andevere, fishmonger 0
4793871 2294207 2294207 defendant Wallop Thomas   756295 756295 Wallop, Thomas, of Andevere, servant 1
4793872 2294207 2294207 defendant Stevenes William   756295 756295 Stevenes, William, of Andevere, millward 2
4798662 2295757 2295757 defendant Bayly John chapman 756295 756295 Bayly, John, of Andevere, chapman 0
4798890 2295827 2295827 defendant Fugge John hosteler 756295 756295 Fugge, John, of Andevere, hosteler 0
4798891 2295827 2295827 defendant Lylie Robert draper 756295 756295 Lylie, Robert, of Andevere, draper 1
4800467 2296329 2296329 defendant Fuge John hosteler 756295 756295 Fuge, John, of Andevere, hosteler 0
4801668 2296705 2296705 defendant Baron Thomas husbandman 756295 756295 Baron, Thomas, of Andevere, husbandman 0
4855034 2312927 2312927 defendant Baker Philip baker 756295 756295 Baker, Philip, of Andevere, baker 0
4855035 2312927 2312927 defendant Bastard William baker 756295 756295 Bastard, William, of Andevere, baker 1
4855036 2312927 2312927 defendant de Grove John yeoman 756295 756295 de Grove, John, of Andevere, yeoman 2
4858200 2313934 2313934 defendant Fugh John ostler 756295 756295 Fugh, John, of Andevere, ostler 0
4863985 2315711 2315711 defendant Clerk John husbandman 756295 756295 Clerk, John, of Andevere, husbandman 0
4867704 2316869 2316869 plaintiff Holte Nicholas (legal representative) 756295 756295 Holte, Nicholas, of Andevere, executor of 0
4867706 2316869 2316869 defendant Bregh Nicholas (legal representative) 756295 756295 Bregh, Nicholas, of Andevere, executor of 0
4869027 2317284 2317284 plaintiff Knave William   756295 756295 Knave, William, of Andevere 0
4870382 2317713 2317713 defendant Rykeman John smith 756295 756295 Rykeman, John, of Andevere, smith 0
4870383 2317713 2317713 defendant Bastard William baker 756295 756295 Bastard, William, of Andevere, baker 1
4870384 2317713 2317713 defendant Fyge John ostler 756295 756295 Fyge, John, of Andevere, ostler 2
4871901 2318189 2318189 defendant Fyge John hosteler 756295 756295 Fyge, John, of Andevere, hosteler 0
4876669 2319674 2319674 defendant Fuge John hosteler 756295 756295 Fuge, John, of Andevere, hosteler 0
4878691 2320274 2320274 defendant Shoppare Walter husbandman 756295 756295 Shoppare, Walter, of Andevere, husbandman 1
4880142 2320701 2320701 defendant Mylbury John chapman 756295 756295 Mylbury, John, of Andevere, chapman 0
4882012 2321272 2321272 defendant Fyge John husbandman 756295 756295 Fyge, John, of Andevere, husbandman 0
4935065 2337375 2337375 defendant Knave John, junior husbandman 756295 756295 Knave, John, junior, of Andevere, husbandman 0
4952647 2342749 2342749 defendant Bastard William baker 756295 756295 Bastard, William, of Andevere, baker 0
4952648 2342749 2342749 defendant Alisaundre Richard   756295 756295 Alisaundre, Richard, of Andevere, wire drawer 1
4952649 2342749 2342749 defendant Basynge Thomas draper 756295 756295 Basynge, Thomas, of Andevere, draper 2
5031341 2366024 2366024 defendant Sampson John husbandman 756295 756295 Sampson, John, of Andevere, husbandman 0
5116434 2391241 2391241 defendant Bedford William fuller 756295 756295 Bedford, William, of Andevere, fuller 0
5116435 2391241 2391241 defendant Moraunt John husbandman 756295 756295 Moraunt, John, of Andevere, husbandman 1
5529704 2513795 2513795 defendant Ayssheton Richard fisher 756295 756295 Ayssheton, Richard, of Andevere, fisher 0
5618673 2549678 2549678 defendant Fisshere John   756295 756295 Fisshere, John, of Andevere 2
5620814 2550378 2550378 plaintiff Sifride Edward   756295 756295 Sifride, Edward, of Andevere or Andover 0
5621223 2550522 2550522 defendant Wallop Roger   756295 756295 Wallop, Roger, of Andevere 1
5625378 2551874 2551874 defendant Breche William husbandman 756295 756295 Breche, William, of Andevere, husbandman 0
5635885 2555182 2555182 defendant Blake John tailor 756295 756295 Blake, John, of Andevere, tailor 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);