names

103 rows where place_id = 606209

✎ 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
3664443 1914826 1914826 defendant Lovyk John yeoman 606209 606209 Lovyk, John, of Wyndham, yeoman 0
3694986 1924644 1924644 defendant Chirche William husbandman 606209 606209 Chirche, William, of Wyndham, husbandman 1
3704996 1927856 1927856 defendant Yerham William miller 606209 606209 Yerham, William, of Wyndham, miller 0
3704997 1927856 1927856 defendant Borell Stephen yeoman 606209 606209 Borell, Stephen, of Wyndham, yeoman 1
3732022 1936247 1936247 defendant Newton John embroiderer 606209 606209 Newton, John, of Wyndham, embroiderer 0
3761877 1945723 1945723 defendant Bale Robert   606209 606209 Bale, Robert, of Wyndham, rough mason 0
3769287 1948048 1948048 defendant Seger Christopher mercer 606209 606209 Seger, Christopher, of Wyndham, mercer 1
3787116 1953764 1953764 defendant Seger Christopher mercer 606209 606209 Seger, Christopher, of Wyndham, mercer 1
3797674 1957169 1957169 defendant Cokkys John hardwareman 606209 606209 Cokkys, John, of Wyndham, hardwareman 0
3798481 1957426 1957426 defendant Knygth alias Kett John butcher 606209 606209 Knygth alias Kett, John, of Wyndham, butcher 0
3807923 1960367 1960367 defendant Colston Peter yeoman 606209 606209 Colston, Peter, of Wyndham, yeoman 1
3807932 1960370 1960370 defendant Colston Peter yeoman 606209 606209 Colston, Peter, of Wyndham, yeoman 1
3822463 1964925 1964925 defendant Verdon Stephen husbandman 606209 606209 Verdon, Stephen, of Wyndham, husbandman 2
3822464 1964925 1964925 defendant Syger Christopher husbandman 606209 606209 Syger, Christopher, of Wyndham, husbandman 3
3832738 1968164 1968164 defendant Stockton Nicholas smith 606209 606209 Stockton, Nicholas, of Wyndham, smith 0
3832739 1968164 1968164 defendant Stockton Robert husbandman 606209 606209 Stockton, Robert, of Wyndham, husbandman 1
3846928 1972578 1972578 defendant Brown Thomas butcher 606209 606209 Brown, Thomas, of Wyndham, butcher 0
3849917 1973560 1973560 defendant Parker John, junior husbandman 606209 606209 Parker, John, junior, of Wyndham, husbandman 1
3854174 1974943 1974943 defendant Brown Thomas butcher 606209 606209 Brown, Thomas, of Wyndham, butcher 0
3854175 1974943 1974943 defendant Wysman Robert   606209 606209 Wysman, Robert, of Wyndham, wheel wright 1
3857143 1975863 1975863 defendant Knyght alias Kett Thomas butcher 606209 606209 Knyght alias Kett, Thomas, of Wyndham, butcher 0
3866445 1979008 1979008 defendant Elsyng Robert gent 606209 606209 Elsyng, Robert, of Wyndham, gent 0
3879770 1983491 1983491 defendant Tenche Simon   606209 606209 Tenche, Simon, of Wyndham, worsted weaver 0
3879795 1983497 1983497 defendant Gysborne Florence mercer 606209 606209 Gysborne, Florence, of Wyndham, mercer 0
3932934 2001304 2001304 defendant Josse Robert   606209 606209 Josse, Robert, of Wyndham, "sponer" 2
3938235 2003125 2003125 defendant Crosse Robert husbandman 606209 606209 Crosse, Robert, of Wyndham, husbandman 3
3948842 2006661 2006661 defendant Pery Edward yeoman 606209 606209 Pery, Edward, of Wyndham, yeoman 0
4059979 2045964 2045964 defendant Kellam or Kylham Thomas beer brewer 606209 606209 Kellam or Kylham, Thomas, of Wyndham, beer brewer 0
4062650 2046940 2046940 defendant Pelles John   606209 606209 Pelles, John, of Wyndham, Norf, taylor 0
4062653 2046941 2046941 defendant Pelles John   606209 606209 Pelles, John, of Wyndham, Norf, taylor 0
4067668 2048749 2048749 defendant Wyseman William   606209 606209 Wyseman, William, of Wyndham, wheelwright 1
4162764 2082535 2082535 defendant Gedny John mercer 606209 606209 Gedny, John, of Wyndham, mercer 0
4162766 2082535 2082535 defendant Fox Christopher mercer 606209 606209 Fox, Christopher, of Wyndham, mercer 2
4176002 2087085 2087085 defendant Shinckwin John clerk 606209 606209 Shinckwin, John, of Wyndham, clerk 3
4193418 2093264 2093264 defendant Burwell Robert brewer 606209 606209 Burwell, Robert, of Wyndham, brewer 2
4193419 2093264 2093264 defendant Browne Robert huasbandman 606209 606209 Browne, Robert, of Wyndham, huasbandman 3
4212450 2099902 2099902 defendant Jernegan Walter gent 606209 606209 Jernegan, Walter, of Wyndham, gent 2
4223579 2103735 2103735 defendant Wetherbye Robert chandler 606209 606209 Wetherbye, Robert, of Wyndham, chandler 0
4278563 2122437 2122437 defendant Haste Thomas yeoman 606209 606209 Haste, Thomas, of Wyndham, yeoman 2
4285270 2124782 2124782 defendant Ward Robert yeoman 606209 606209 Ward, Robert, of Wyndham, yeoman 0
4332132 2141046 2141046 defendant Earle Thomas gardiner 606209 606209 Earle, Thomas, of Wyndham, gardiner 0
4332133 2141046 2141046 defendant Mann Charles tailor 606209 606209 Mann, Charles, of Wyndham, tailor 1
4393723 2162503 2162503 defendant Stone Henry yeoman 606209 606209 Stone, Henry, of Wyndham, or of Banham, yeoman 0
4654642 2247331 2247331 defendant Heye Thomas smith 606209 606209 Heye, Thomas, of Wyndham, smith 0
4654643 2247331 2247331 defendant Heye John husbandman 606209 606209 Heye, John, of Wyndham, husbandman 1
4755250 2282030 2282030 defendant Western John yeoman 606209 606209 Western, John, of Wyndham, yeoman 1
4842414 2309163 2309163 defendant atte Chirche John   606209 606209 atte Chirche, John, of Wyndham, mason 1
4974616 2349374 2349374 defendant Ferour or Smith John husbandman 606209 606209 Ferour or Smith, John, of Wyndham, husbandman 4
4982199 2351598 2351598 defendant Payn Alexander yeoman 606209 606209 Payn, Alexander, of Wyndham, yeoman 0
4991562 2354360 2354360 defendant Watker John husbandman 606209 606209 Watker, John, of Wyndham, husbandman 0
4991563 2354360 2354360 defendant Reve Richard yeoman 606209 606209 Reve, Richard, of Wyndham, yeoman 1
4994209 2355144 2355144 defendant Walter Richard butcher 606209 606209 Walter, Richard, of Wyndham, butcher 0
4994210 2355144 2355144 defendant Plomer John husbandman 606209 606209 Plomer, John, of Wyndham, husbandman 1
4994537 2355231 2355231 defendant Glover alias Denton Henry husbandman 606209 606209 Glover alias Denton, Henry, of Wyndham, husbandman 1
4996886 2355926 2355926 defendant Turnour John turner 606209 606209 Turnour, John, of Wyndham, turner 7
4996890 2355926 2355926 defendant Wysman John husbandman 606209 606209 Wysman, John, of Wyndham, husbandman 11
5004157 2358107 2358107 defendant Wetherby Walter yeoman 606209 606209 Wetherby, Walter, of Wyndham, yeoman 0
5005806 2358596 2358596 defendant but William yeoman 606209 606209 but, William, of Wyndham, yeoman 1
5007833 2359183 2359183 defendant Anne or Aune Geoffrey yeoman 606209 606209 Anne or Aune, Geoffrey, of Wyndham, yeoman 0
5009651 2359702 2359702 plaintiff Turnour John   606209 606209 Turnour, John, of Wyndham 0
5009652 2359702 2359702 defendant Denton Henry husbandman 606209 606209 Denton, Henry, of Wyndham, husbandman 0
5009653 2359702 2359702 defendant Baxter Simon husbandman 606209 606209 Baxter, Simon, of Wyndham, husbandman 1
5041022 2368941 2368941 defendant Carter Nicholas merchant 606209 606209 Carter, Nicholas, of Wyndham, merchant 0
5049863 2371584 2371584 defendant Herde Robert butcher 606209 606209 Herde, Robert, of Wyndham, butcher 1
5053326 2372598 2372598 defendant Bocher William butcher 606209 606209 Bocher, William, of Wyndham, butcher 0
5076319 2379419 2379419 defendant Davy John husbandman 606209 606209 Davy, John, of Wyndham, husbandman 2
5077378 2379734 2379734 plaintiff Blakeneye Richard   606209 606209 Blakeneye, Richard, of Wyndham 1
5079855 2380452 2380452 defendant Motte Alan yeoman 606209 606209 Motte, Alan, of Wyndham, yeoman 1
5089318 2383242 2383242 defendant Pennys John baker 606209 606209 Pennys, John, of Wyndham, baker 4
5097750 2385764 2385764 defendant Motte Alan husbandman 606209 606209 Motte, Alan, of Wyndham, husbandman 4
5106823 2388424 2388424 plaintiff Davy John   606209 606209 Davy, John, of Wyndham 0
5106829 2388425 2388425 plaintiff Davy John   606209 606209 Davy, John, of Wyndham 0
5106830 2388425 2388425 defendant Nelyng Thomas husbandman 606209 606209 Nelyng, Thomas, of Wyndham, husbandman 0
5116357 2391211 2391211 defendant Lowes Thomas husbandman 606209 606209 Lowes, Thomas, of Wyndham, husbandman 5
5118641 2391883 2391883 defendant Lombe John husbandman 606209 606209 Lombe, John, of Wyndham, husbandman 0
5118642 2391883 2391883 defendant Denton Henry husbandman 606209 606209 Denton, Henry, of Wyndham, husbandman 1
5118644 2391884 2391884 defendant Lombe John husbandman 606209 606209 Lombe, John, of Wyndham, husbandman 0
5118645 2391884 2391884 defendant Dents- Henry husbandman 606209 606209 Dents-, Henry, of Wyndham, husbandman 1
5134506 2396587 2396587 defendant Motte Alan   606209 606209 Motte, Alan, of Wyndham 1
5154391 2402440 2402440 defendant Motte Alan husbandman 606209 606209 Motte, Alan, of Wyndham, husbandman 1
5171490 2407383 2407383 defendant Motte Alan husbandman 606209 606209 Motte, Alan, of Wyndham, husbandman 1
5214659 2420015 2420015 defendant Baker John husbandman 606209 606209 Baker, John, of Wyndham, husbandman 6
5235268 2425892 2425892 plaintiff Davy John   606209 606209 Davy, John, of Wyndham 0
5269775 2436269 2436269 defendant Curteys John bleacher of cloth 606209 606209 Curteys, John, of Wyndham, bleacher of cloth 0
5285006 2440637 2440637 defendant Bysshop Richard husbandman 606209 606209 Bysshop, Richard, of Wyndham, husbandman 0
5296304 2443909 2443909 defendant Edryche James yeoman 606209 606209 Edryche, James, of Wyndham, yeoman 0
5299082 2444714 2444714 defendant Metyngham John husbandman 606209 606209 Metyngham, John, of Wyndham, husbandman 3
5300657 2445158 2445158 defendant Mayden Richard husbandman 606209 606209 Mayden, Richard, of Wyndham, husbandman 1
5328697 2453663 2453663 defendant Whytby Stephen esq 606209 606209 Whytby, Stephen, of Wyndham, esq 0
5376060 2468104 2468104 defendant Elys John laborer 606209 606209 Elys, John, of Wyndham, laborer 0
5390034 2472211 2472211 defendant Townyford Alexander beer brewer 606209 606209 Townyford, Alexander, of Wyndham, beer brewer 2
5436253 2485779 2485779 defendant Elys John husbandman 606209 606209 Elys, John, of Wyndham, husbandman 1
5450986 2490186 2490186 defendant Elys Thomas husbandman 606209 606209 Elys, Thomas, of Wyndham, husbandman 1
5475465 2497660 2497660 defendant Swete Henry laborer 606209 606209 Swete, Henry, of Wyndham, laborer 2
5480488 2499137 2499137 plaintiff Davy William raffman 606209 606209 Davy, William, of Wyndham, raffman 0
5496878 2503996 2503996 defendant Say John (legal representative) 606209 606209 Say, John, of Wyndham, mercer, executors of 0
5496879 2503996 2503996 defendant Stede John husbandman 606209 606209 (Stede, John, of Wyndham, husbandman 1
5496881 2503997 2503997 defendant Say John (legal representative) 606209 606209 Say, John, of Wyndham, mercer, executors of 0
5496882 2503997 2503997 defendant Steede or Stoode John husbandman 606209 606209 (Steede or Stoode, John, of Wyndham, husbandman 1
5496884 2503998 2503998 defendant Davy William mercer 606209 606209 Davy, William, of Wyndham, mercer 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);