names

92 rows where place_id = 592104

✎ 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
3606586 1869733 1869733 defendant Launder William husbandman 592104 592104 Launder, William, of Langtoft, husbandman 0
3624300 1875135 1875135 defendant Assheley William yeoman 592104 592104 Assheley, William, of Langtoft, yeoman 0
3624301 1875135 1875135 defendant Gryndell Thomas yeoman 592104 592104 Gryndell, Thomas, of Langtoft, yeoman 1
3672160 1917290 1917290 defendant Cook Christopher husbandman 592104 592104 Cook, Christopher, of Langtoft, husbandman 1
3727528 1934889 1934889 defendant Cooke Richard gent 592104 592104 Cooke, Richard, of Langtoft, gent 0
3746066 1940674 1940674 defendant Shallok John husbandman 592104 592104 Shallok, John, of Langtoft, husbandman 0
3773363 1949382 1949382 defendant Cope Thomas husbandman 592104 592104 Cope, Thomas, of Langtoft, husbandman 0
3791131 1955060 1955060 defendant Cope Thomas husbandman 592104 592104 Cope, Thomas, of Langtoft, husbandman 0
3855686 1975416 1975416 defendant Wryght John laborer 592104 592104 Wryght, John, of Langtoft, laborer 0
3861853 1977423 1977423 defendant Harvy Thomas husbandman 592104 592104 Harvy, Thomas, of Langtoft, husbandman 1
3861854 1977423 1977423 defendant Benett Robert husbandman 592104 592104 Benett, Robert, of Langtoft, husbandman 2
3879759 1983488 1983488 defendant Addyngton Alexander laborer 592104 592104 Addyngton, Alexander, of Langtoft, laborer 0
3879760 1983488 1983488 defendant Addyngton Henry laborer 592104 592104 Addyngton, Henry, of Langtoft, laborer 1
3911716 1994243 1994243 defendant Lock Henry husbandman 592104 592104 Lock, Henry, of Langtoft, husbandman 2
4022740 2032856 2032856 defendant Dunmoe Thomas husbandman 592104 592104 Dunmoe, Thomas, of Langtoft, or of Peykirke, Nhants, husbandman 0
4358868 2150337 2150337 defendant Fairfax John husbandman 592104 592104 Fairfax, John, of Langtoft, husbandman 0
4361322 2151210 2151210 defendant Wharton Diconson yeoman 592104 592104 Wharton, Diconson, of Langtoft, yeoman 2
4461082 2188541 2188541 defendant Dobel Robert   592104 592104 Dobel, Robert, of Langtoft 0
4471353 2191707 2191707 defendant Burton Nicholas de chapman 592104 592104 Burton, Nicholas de, of Langtoft, chapman 2
4504450 2201949 2201949 plaintiff Rouland William   592104 592104 Rouland, William, of Langtoft 0
4523427 2207648 2207648 defendant Spenser William   592104 592104 Spenser, William, of Langtoft 0
4549721 2215848 2215848 plaintiff Couper John   592104 592104 Couper, John, of Langtoft 0
4686098 2261244 2261244 defendant Bailly John husbandman 592104 592104 Bailly, John, of Langtoft, husbandman 0
4708977 2268177 2268177 defendant Pers Lucas husbandman 592104 592104 Pers, Lucas, of Langtoft, husbandman 0
4772852 2287481 2287481 defendant Jonesson Robert husbandman 592104 592104 Jonesson, Robert, of Langtoft, husbandman 1
4778294 2289197 2289197 plaintiff Bele Robert   592104 592104 Bele, Robert, of Langtoft 0
4778296 2289198 2289198 plaintiff Bele Robert   592104 592104 Bele, Robert, of Langtoft 0
4789893 2292908 2292908 defendant Holme John husbandman 592104 592104 Holme, John, of Langtoft, husbandman 0
4789894 2292908 2292908 defendant Clerk Thomas   592104 592104 Clerk, Thomas, of Langtoft, parish clerk 1
4789895 2292908 2292908 defendant Halum William   592104 592104 Halum, William, of Langtoft, shepherd 2
4806584 2298272 2298272 defendant Gresaker Richard husbandman 592104 592104 Gresaker, Richard, of Langtoft, husbandman 0
4806585 2298272 2298272 defendant Bele Robert husbandman 592104 592104 Bele, Robert, of Langtoft, husbandman 1
4806586 2298272 2298272 defendant Judde John husbandman 592104 592104 Judde, John, of Langtoft, husbandman 2
4819412 2302146 2302146 defendant Squyere Simon husbandman 592104 592104 Squyere, Simon, of Langtoft, husbandman 0
4819413 2302146 2302146 defendant Snet or Suet John laborer 592104 592104 Snet or Suet, John, of Langtoft, laborer 1
4830810 2305665 2305665 defendant Richardson John husbandman 592104 592104 Richardson, John, of Langtoft, husbandman 2
4834730 2306862 2306862 defendant Lucas John husbandman 592104 592104 Lucas, John, of Langtoft, husbandman 0
4835059 2306966 2306966 defendant Richardson John husbandman 592104 592104 Richardson, John, of Langtoft, husbandman 0
4836740 2307457 2307457 defendant Surdewell John husbandman 592104 592104 Surdewell, John, of Langtoft, husbandman 0
4839261 2308205 2308205 defendant Baldelwyn John husbandman 592104 592104 Baldelwyn, John, of Langtoft, husbandman 0
4843854 2309597 2309597 defendant Pers Margaret widow 592104 592104 Pers, Margaret, of Langtoft, widow 0
4843855 2309597 2309597 defendant Pers John husbandman 592104 592104 Pers, John, of Langtoft, husbandman 1
4856711 2313474 2313474 defendant Perys Thomas husbandman 592104 592104 Perys, Thomas, of Langtoft, husbandman 2
4866526 2316491 2316491 defendant Baldewyn John husbandman 592104 592104 Baldewyn, John, of Langtoft, husbandman 0
4877981 2320066 2320066 defendant Bole Robert husbandman 592104 592104 Bole, Robert, of Langtoft, husbandman 1
4897450 2325864 2325864 defendant Ive John husbandman 592104 592104 Ive, John, of Langtoft, husbandman 0
4900627 2326835 2326835 defendant Ive John husbandman 592104 592104 Ive, John, of Langtoft, husbandman 3
4901020 2326946 2326946 defendant Perys John husbandman 592104 592104 Perys, John, of Langtoft, husbandman 0
4928818 2335434 2335434 defendant Duffeld John husbandman 592104 592104 Duffeld, John, of Langtoft, husbandman 0
4943479 2339930 2339930 defendant Ive John husbandman 592104 592104 Ive, John, of Langtoft, husbandman 1
4945393 2340538 2340538 defendant Mayse William husbandman 592104 592104 Mayse, William, of Langtoft, husbandman 0
4968481 2347540 2347540 defendant Barton Thomas husbandman 592104 592104 Barton, Thomas, of Langtoft, husbandman 4
4990539 2354077 2354077 defendant Spencer John husbandman 592104 592104 Spencer, John, of Langtoft, husbandman 0
5018947 2362431 2362431 defendant Tomlynson John husbandman 592104 592104 Tomlynson, John, of Langtoft, husbandman 0
5021951 2363316 2363316 defendant Bawedewyn John husbandman 592104 592104 Bawedewyn, John, of Langtoft, husbandman 0
5027983 2365062 2365062 defendant Pers John husbandman 592104 592104 Pers, John, of Langtoft, husbandman 0
5029700 2365557 2365557 defendant Ive John husbandman 592104 592104 Ive, John, of Langtoft, husbandman 0
5029732 2365568 2365568 defendant Whitehede Thomas husbandman 592104 592104 Whitehede, Thomas, of Langtoft, husbandman 0
5030383 2365758 2365758 defendant Serll William   592104 592104 Serll, William, of Langtoft, servant 0
5036884 2367662 2367662 defendant Gresacre Richard husbandman 592104 592104 Gresacre, Richard, of Langtoft, husbandman 0
5041523 2369067 2369067 defendant Futyt John yeoman 592104 592104 Futyt, John, of Langtoft, yeoman 0
5041524 2369067 2369067 defendant (illegible) Robert yeoman 592104 592104 ---, Robert, of Langtoft, yeoman 1
5042124 2369251 2369251 defendant Peers John husbandman 592104 592104 Peers, John, of Langtoft, husbandman 0
5042126 2369252 2369252 defendant Peers John husbandman 592104 592104 Peers, John, of Langtoft, husbandman 0
5052143 2372254 2372254 defendant Bele Robert husbandman 592104 592104 Bele, Robert, of Langtoft, husbandman 0
5062294 2375284 2375284 defendant Pyers John husbandman 592104 592104 Pyers, John, of Langtoft, husbandman 0
5076054 2379336 2379336 defendant Beld or Bele Robert husbandman 592104 592104 Beld or Bele, Robert, of Langtoft, husbandman 1
5076055 2379336 2379336 defendant Hoppyng John husbandman 592104 592104 Hoppyng, John, of Langtoft, husbandman 2
5095508 2385104 2385104 defendant Barton Robert husbandman 592104 592104 Barton, Robert, of Langtoft, husbandman 0
5095509 2385104 2385104 defendant Waren Thomas husbandman 592104 592104 Waren, Thomas, of Langtoft, husbandman 1
5095510 2385104 2385104 defendant Barton Simon husbandman 592104 592104 Barton, Simon, of Langtoft, husbandman 2
5120333 2392375 2392375 defendant Bele John husbandman 592104 592104 Bele, John, of Langtoft, husbandman 2
5125885 2394057 2394057 defendant Hardgrave John yeoman 592104 592104 Hardgrave, John, of Langtoft, yeoman 1
5138932 2397884 2397884 defendant Bele Robert husbandman 592104 592104 Bele, Robert, of Langtoft, husbandman 1
5159834 2403974 2403974 defendant Bele Robert husbandman 592104 592104 Bele, Robert, of Langtoft, husbandman 1
5159835 2403974 2403974 defendant Bele John husbandman 592104 592104 Bele, John, of Langtoft, husbandman 2
5176196 2408730 2408730 defendant Middelton William   592104 592104 Middelton, William, of Langtoft, vicar 0
5176198 2408730 2408730 defendant Johnson Onor husbandman 592104 592104 Johnson, Onor, of Langtoft, husbandman 2
5191062 2413127 2413127 defendant Fayrefax Robert husbandman 592104 592104 Fayrefax, Robert, of Langtoft, husbandman 0
5198135 2415202 2415202 defendant Middelton William   592104 592104 Middelton, William, of Langtoft, vicar 0
5198137 2415202 2415202 defendant Johnson Onor husbandman 592104 592104 Johnson, Onor, of Langtoft, husbandman 2
5286136 2440953 2440953 defendant Adamson Richard   592104 592104 Adamson, Richard, of Langtoft, "griselibber" 0
5292476 2442798 2442798 defendant Middilton William clerk 592104 592104 Middilton, William, of Langtoft, clerk 0
5292477 2442798 2442798 defendant Adamson Richard husbandman 592104 592104 Adamson, Richard, of Langtoft, husbandman 1
5299388 2444794 2444794 defendant Hoghton William yeoman 592104 592104 Hoghton, William, of Langtoft, yeoman 2
5370546 2466373 2466373 defendant Depe William husbandman 592104 592104 Depe, William, of Langtoft, husbandman 1
5426555 2482888 2482888 defendant Gryndyll Thomas yeoman 592104 592104 Gryndyll, Thomas, of Langtoft, yeoman 0
5538325 2516471 2516471 defendant Bedeman Richard husbandman 592104 592104 Bedeman, Richard, of Langtoft, husbandman 2
5569850 2525756 2525756 defendant Scarborowe William husbandman 592104 592104 Scarborowe, William, of Langtoft, husbandman 1
5581279 2529216 2529216 defendant Symson Robert husbandman 592104 592104 Symson, Robert, of Langtoft, husbandman 0
5590280 2531931 2531931 defendant Whitwell Thomas yeoman 592104 592104 Whitwell, Thomas, of Langtoft, yeoman 1
5590773 2532085 2532085 defendant Gryndell Thomas (legal representative) 592104 592104 Gryndell, Thomas, of Langtoft, husbandman, executors of 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);