names

141 rows where place_id = 596372

✎ 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
3624471 1875189 1875189 defendant Barker Richard husbandman 596372 596372 Barker, Richard, of hillyngton, husbandman 1
3688389 1922526 1922526 defendant Pepyr Richard gent 596372 596372 Pepyr, Richard, of Hillyngton, gent 0
3693364 1924138 1924138 defendant Wilson William clerk 596372 596372 Wilson, William, of Hillyngton, clerk 1
3700245 1926311 1926311 defendant Veysie John husbandman 596372 596372 Veysie, John, of Hillyngton, husbandman 0
3853054 1974574 1974574 defendant Ferror John laborer 596372 596372 Ferror, John, of Hillyngton, laborer 3
3867583 1979393 1979393 defendant Bower Thomas chaplain 596372 596372 Bower, Thomas, of Hillyngton, chaplain 1
3881535 1984085 1984085 defendant Bower Thomas chaplain 596372 596372 Bower, Thomas, of Hillyngton, chaplain 1
3904315 1991692 1991692 defendant Seele Robert husbandman 596372 596372 Seele, Robert, of Hillyngton, husbandman 1
4209950 2099043 2099043 defendant Longe Walter laborer 596372 596372 Longe, Walter, of Hillyngton, laborer 0
4289790 2126409 2126409 defendant Stede William gent 596372 596372 Stede, William, of Hillyngton, gent 0
4292205 2127283 2127283 defendant Steede William yeoman 596372 596372 Steede, William, of Hillyngton, yeoman 0
4556842 2218075 2218075 defendant Baroun John   596372 596372 Baroun, John, of Hillyngton 0
4556843 2218075 2218075 defendant Deye John   596372 596372 Deye, John, of Hillyngton 1
4556844 2218075 2218075 defendant Syggen Robert baker 596372 596372 Syggen, Robert, of Hillyngton, baker 2
4618038 2236652 2236652 plaintiff Haddenham John   596372 596372 Haddenham, John, of Hillyngton 0
4618040 2236652 2236652 defendant Smyth Giles   596372 596372 Smyth, Giles, of Hillyngton 1
4618041 2236652 2236652 defendant Bladys John   596372 596372 Bladys, John, of Hillyngton 2
4637796 2242593 2242593 defendant Avys Reginald   596372 596372 Avys, Reginald, of Hillyngton 1
4637797 2242593 2242593 defendant Avys John   596372 596372 Avys, John, of Hillyngton 2
4644225 2244406 2244406 defendant Hadenham John   596372 596372 Hadenham, John, of Hillyngton 4
4679173 2259095 2259095 defendant Webstere John weaver 596372 596372 Webstere, John, of Hillyngton, weaver 0
4709219 2268250 2268250 defendant Cawald John husbandman 596372 596372 Cawald, John, of Hillyngton, husbandman 4
4716517 2270486 2270486 defendant Hert William butcher 596372 596372 Hert, William, of Hillyngton, butcher 0
4766393 2285480 2285480 plaintiff Mughell John   596372 596372 Mughell, John, of Hillyngton 1
4809513 2299147 2299147 defendant Amys John husbandman 596372 596372 Amys, John, of Hillyngton, husbandman 2
4809514 2299147 2299147 defendant Webster Adam husbandman 596372 596372 Webster, Adam, of Hillyngton, husbandman 3
4813344 2300289 2300289 defendant Yepe John yeoman 596372 596372 Yepe, John, of Hillyngton, yeoman 1
4813345 2300289 2300289 defendant Gumere Robert yeoman 596372 596372 Gumere, Robert, of Hillyngton, yeoman 2
4825300 2303954 2303954 defendant Hoome Thomas gent 596372 596372 Hoome, Thomas, of Hillyngton, gent 0
4841130 2308760 2308760 defendant Webster Adam husbandman 596372 596372 Webster, Adam, of Hillyngton, husbandman 0
4853675 2312566 2312566 defendant Bailly John yeoman 596372 596372 Bailly, John, of Hillyngton, yeoman 0
4862876 2315373 2315373 defendant Lawes John yeoman 596372 596372 Lawes, John, of Hillyngton, yeoman 2
4872458 2318347 2318347 defendant Home Thomas gent 596372 596372 Home, Thomas, of Hillyngton, gent 0
4881567 2321136 2321136 defendant Baily John yeoman 596372 596372 Baily, John, of Hillyngton, yeoman 0
4902455 2327382 2327382 defendant Anys or Avys John husbandman 596372 596372 Anys or Avys, John, of Hillyngton, husbandman 1
4905028 2328181 2328181 defendant Gymere Robert   596372 596372 Gymere, Robert, of Hillyngton, bailiff 0
4914609 2331087 2331087 defendant Mayne William husbandman 596372 596372 Mayne, William, of Hillyngton, husbandman 0
4914611 2331088 2331088 defendant Mayne William husbandman 596372 596372 Mayne, William, of Hillyngton, husbandman 0
4919297 2332543 2332543 defendant Eymere Robert yeoman 596372 596372 Eymere, Robert, of Hillyngton, yeoman 3
4936759 2337875 2337875 defendant Gymere Robert husbandman 596372 596372 Gymere, Robert, of Hillyngton, husbandman 0
4942220 2339556 2339556 defendant Sygon Thomas   596372 596372 Sygon, Thomas, of Hillyngton baker 0
4965171 2346509 2346509 plaintiff Benet Edmund   596372 596372 Benet, Edmund, of Hillyngton 1
4965172 2346509 2346509 defendant Sygyn Thomas yeoman 596372 596372 Sygyn, Thomas, of Hillyngton, yeoman 0
4965651 2346650 2346650 defendant Home Thomas gent 596372 596372 Home, Thomas, of Hillyngton, gent 0
4967093 2347090 2347090 defendant Martyn Richard chaplain 596372 596372 Martyn, Richard, of Hillyngton, chaplain 1
4983174 2351868 2351868 defendant Small William, junior miller 596372 596372 Small, William, junior, of Hillyngton, miller 1
4996114 2355694 2355694 defendant Sporle Thomas clerk 596372 596372 Sporle, Thomas, of Hillyngton, clerk 0
5009555 2359674 2359674 defendant Home Thomas gent 596372 596372 Home, Thomas, of Hillyngton, gent 0
5037044 2367705 2367705 defendant Ingylger John husbandman 596372 596372 Ingylger, John, of Hillyngton, husbandman 0
5057546 2373826 2373826 defendant Yoope John, senior husbandman 596372 596372 Yoope, John, senior, of Hillyngton, husbandman 0
5057547 2373826 2373826 defendant Pollard John husbandman 596372 596372 Pollard, John, of Hillyngton, husbandman 1
5057711 2373874 2373874 defendant Dyttenotte John, senior husbandman 596372 596372 Dyttenotte, John, senior, of Hillyngton, husbandman 0
5057813 2373907 2373907 defendant Ingelger or Jugelger John laborer 596372 596372 Ingelger or Jugelger, John, of Hillyngton, laborer 0
5080445 2380640 2380640 defendant Karvyle Thomas   596372 596372 Karvyle, Thomas, of Hillyngton, shepherd 0
5080998 2380818 2380818 plaintiff Cosyn Richard clerk 596372 596372 Cosyn, Richard, of Hillyngton, clerk 0
5080999 2380818 2380818 defendant Home Thomas gent 596372 596372 Home, Thomas, of Hillyngton, gent 0
5081001 2380818 2380818 defendant Home John, junior gent 596372 596372 Home, John, junior, of Hillyngton, gent 2
5081002 2380819 2380819 plaintiff Cosyn Richard clerk 596372 596372 Cosyn, Richard, of Hillyngton, clerk 0
5081003 2380819 2380819 defendant Sygon Thomas yeoman 596372 596372 Sygon, Thomas, of Hillyngton, yeoman 0
5081004 2380819 2380819 defendant Yope John, senior yeoman 596372 596372 Yope, John, senior, of Hillyngton, yeoman 1
5090744 2383681 2383681 defendant Saundre John husbandman 596372 596372 Saundre, John, of Hillyngton, husbandman 0
5090745 2383681 2383681 defendant Saundre Robert husbandman 596372 596372 Saundre, Robert, of Hillyngton, husbandman 1
5092697 2384242 2384242 defendant Smert John miller 596372 596372 Smert, John, of Hillyngton, miller 1
5105646 2388102 2388102 defendant Appilton William gent 596372 596372 Appilton, William,of Hillyngton, gent 0
5110863 2389574 2389574 defendant Stylton Henry yeoman 596372 596372 Stylton, Henry, of Hillyngton, yeoman 0
5110864 2389574 2389574 defendant Pollard John yeoman 596372 596372 Pollard, John, of Hillyngton, yeoman 1
5119735 2392211 2392211 plaintiff Smert John   596372 596372 Smert, John, of Hillyngton 0
5124243 2393542 2393542 defendant Home Thomas gent 596372 596372 Home, Thomas, of Hillyngton, gent 1
5125216 2393853 2393853 defendant Sygon Thomas husbandman 596372 596372 Sygon, Thomas, of Hillyngton, husbandman 0
5125217 2393853 2393853 defendant Hobert John husbandman 596372 596372 Hobert, John, of HIllyngton, husbandman 1
5125218 2393853 2393853 defendant Yope John husbandman 596372 596372 Yope, John, of Hillyngton, husbandman 2
5127560 2394541 2394541 defendant Hoberd John husbandman 596372 596372 Hoberd, John, of Hillyngton, husbandman 0
5127561 2394541 2394541 defendant Thewyt Thomas husbandman 596372 596372 Thewyt, Thomas, of Hillyngton, husbandman 1
5128454 2394795 2394795 defendant (illegible) Thomas   596372 596372 --, Thomas, of Hillyngton, shepherd 9
5129021 2394973 2394973 defendant Prowet Robert   596372 596372 Prowet, Robert, of Hillyngton, shepherd 0
5129022 2394973 2394973 defendant Cook Thomas husbandman 596372 596372 Cook, Thomas, of Hillyngton, husbandman 1
5132239 2395926 2395926 defendant Hoberd John husbandman 596372 596372 Hoberd, John, of Hillyngton, husbandman 0
5132240 2395926 2395926 defendant Smert (illegible) husbandman 596372 596372 Smert, ----, of Hillyngton, husbandman 1
5135280 2396818 2396818 defendant Yope John, senior (legal representative) 596372 596372 Yope, John, senior, of Hillyngton, husbandman, executors of 2
5135282 2396818 2396818 defendant Yope Margery widow 596372 596372 Yope, Margery, of Hillyngton, widow 4
5140513 2398331 2398331 plaintiff Sygon Thomas   596372 596372 Sygon, Thomas, of Hillyngton 0
5144756 2399621 2399621 defendant Theyte Thomas husbandman 596372 596372 Theyte, Thomas, of Hillyngton, husbandman 0
5146487 2400105 2400105 defendant Hoberd John husbandman 596372 596372 Hoberd, John, of Hillyngton, husbandman 0
5146488 2400105 2400105 defendant Theweyt Thomas husbandman 596372 596372 Theweyt, Thomas, of Hillyngton, husbandman 1
5146491 2400106 2400106 defendant Hoberd John husbandman 596372 596372 Hoberd, John, of Hillyngton, husbandman 0
5146492 2400106 2400106 defendant Theweyt Thomas husbandman 596372 596372 Theweyt, Thomas, of Hillyngton, husbandman 1
5147536 2400422 2400422 defendant Hoberd Thomas yeoman 596372 596372 Hoberd, Thomas, of Hillyngton, yeoman 0
5147537 2400422 2400422 defendant Thwayte Thomas yeoman 596372 596372 Thwayte, Thomas, of Hillyngton, yeoman 1
5147551 2400423 2400423 defendant Kervyle Thomas   596372 596372 Kervyle, Thomas, of Hillyngton, shepherd 9
5147662 2400454 2400454 defendant Prowet Robert   596372 596372 Prowet, Robert, of Hillyngton, shepherd 0
5147668 2400456 2400456 defendant Prowet Robert   596372 596372 Prowet, Robert, of Hillyngton, shepherd 0
5147669 2400456 2400456 defendant Cook Thomas husbandman 596372 596372 Cook, Thomas, of Hillyngton, husbandman 1
5148056 2400578 2400578 defendant Twayte Thomas yeoman 596372 596372 Twayte, Thomas, of Hillyngton, yeoman 0
5148693 2400742 2400742 defendant Yope John laborer 596372 596372 Yope, John, of Hillyngton, laborer 0
5151983 2401716 2401716 defendant Hoberd John husbandman 596372 596372 Hoberd, John, of Hillyngton, husbandman 0
5151984 2401716 2401716 defendant Smert John husbandman 596372 596372 Smert, John, of Hillyngton, husbandman 1
5155430 2402743 2402743 defendant Yope John, sen (legal representative) 596372 596372 Yope, John, sen, of Hillyngton, husbandman, executors of 2
5157307 2403277 2403277 defendant Theweyt Thomas yeoman 596372 596372 Theweyt, Thomas, of Hillyngton, yeoman 0
5165461 2405643 2405643 defendant Theyte Thomas husbandman 596372 596372 Theyte, Thomas, of Hillyngton, husbandman 0
5166615 2405955 2405955 defendant Hoberd John husbandman 596372 596372 Hoberd, John, of Hillyngton, husbandman 0

Next page

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