names

111 rows where place_id = 598937

✎ 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
3634592 1905624 1905624 defendant Marveyn John husbandman 598937 598937 Marveyn, John, of Leyham, husbandman 2
3643609 1908432 1908432 defendant Marvyn John husbandman 598937 598937 Marvyn, John, of Leyham, husbandman 0
3651940 1910953 1910953 defendant Dunnyng Thomas smith 598937 598937 Dunnyng, Thomas, of Leyham, smith 0
3651941 1910953 1910953 defendant Brykhed Henry husbandman 598937 598937 Brykhed, Henry, of Leyham, husbandman 1
3651942 1910953 1910953 defendant Marven John husbandman 598937 598937 Marven, John, of Leyham, husbandman 2
3654699 1911727 1911727 defendant Wylys Robert husbandman 598937 598937 Wylys, Robert, of Leyham, husbandman 2
3667924 1915909 1915909 defendant Frost Richard clerk 598937 598937 Frost, Richard, of Leyham, clerk 1
3667925 1915909 1915909 defendant Frost Richard husbandman 598937 598937 Frost, Richard, of Leyham, husbandman 2
3667930 1915910 1915910 defendant Frost Richard clerk 598937 598937 Frost, Richard, of Leyham, clerk 1
3667931 1915910 1915910 defendant Frost Richard husbandman 598937 598937 Frost, Richard, of Leyham, husbandman 2
3676375 1918656 1918656 defendant Luson Augustine husbandman 598937 598937 Luson, Augustine, of Leyham, husbandman 1
3684512 1921290 1921290 defendant Holte Thomas, junior weaver 598937 598937 Holte, Thomas, junior, of Leyham, weaver 1
3687585 1922292 1922292 defendant Osbern Walter laborer 598937 598937 Osbern, Walter, of Leyham, laborer 1
3708208 1928861 1928861 defendant Holmys Thomas laborer 598937 598937 Holmys, Thomas, of Leyham, laborer 1
3723535 1933631 1933631 defendant Holmes Thomas laborer 598937 598937 Holmes, Thomas, of Leyham, laborer 2
3731365 1936032 1936032 defendant Paynter John husbandman 598937 598937 Paynter, John, of Leyham, husbandman 0
3742687 1939585 1939585 defendant Luson Augustine husbandman 598937 598937 Luson, Augustine, of Leyham, husbandman 0
3757392 1944293 1944293 defendant Lewson Augustine husbandman 598937 598937 Lewson, Augustine, of Leyham, husbandman 1
3763677 1946283 1946283 defendant Smyth Hugh husbandman 598937 598937 Smyth, Hugh, of Leyham, husbandman 0
3765853 1946985 1946985 defendant Gravener John husbandman 598937 598937 Gravener, John, of Leyham, husbandman 4
3788268 1954126 1954126 defendant Luson Augustine husbandman 598937 598937 Luson, Augustine, of Leyham, husbandman 4
3795001 1956301 1956301 defendant Wulward Richard husbandman 598937 598937 Wulward, Richard, of Leyham, husbandman 1
3800282 1958009 1958009 defendant Warde John husbandman 598937 598937 Warde, John, of Leyham, husbandman 2
3800283 1958009 1958009 defendant Lewson John husbandman 598937 598937 Lewson, John, of Leyham, husbandman 3
3803970 1959157 1959157 defendant Gravener John husbandman 598937 598937 Gravener, John, of Leyham, husbandman 3
3830583 1967443 1967443 defendant Carter John husbandman 598937 598937 Carter, John, of Leyham, husbandman 0
3830769 1967506 1967506 defendant Estey William husbandman 598937 598937 Estey, William, of Leyham, husbandman 1
3845662 1972189 1972189 defendant Cartar John husbandman 598937 598937 Cartar, John, of Leyham, husbandman 0
3852834 1974495 1974495 defendant Smyth Hugh husbandman 598937 598937 Smyth, Hugh, of Leyham, husbandman 0
3859793 1976776 1976776 defendant Martyn Thomas tiler 598937 598937 Martyn, Thomas, of Leyham, tiler 0
3861679 1977366 1977366 defendant Startup William yeoman 598937 598937 Startup, William, of Leyham, yeoman 0
3905724 1992192 1992192 defendant Smyth Hugh husbandman 598937 598937 Smyth, Hugh, of Leyham, husbandman 2
3994927 2022936 2022936 defendant Rolfe William sherman 598937 598937 Rolfe, William, of Leyham, sherman 2
3995422 2023104 2023104 defendant Warde Ralph husbandman 598937 598937 Warde, Ralph, of Leyham, husbandman 0
3995423 2023104 2023104 defendant Waynwright Richard yeoman 598937 598937 Waynwright, Richard, of Leyham, yeoman 1
4036777 2037840 2037840 defendant Weynwright Richard husbandman 598937 598937 Weynwright, Richard, of Leyham, husbandman 2
4053318 2043562 2043562 defendant Wooderoff William clerk 598937 598937 Wooderoff, William, of Leyham, clerk 0
4138992 2074317 2074317 defendant Woodroff William clerk 598937 598937 Woodroff, William, of Leyham, clerk 1
4195053 2093834 2093834 defendant Munnyng Robert yeoman 598937 598937 Munnyng, Robert, of Leyham, yeoman 1
4195062 2093836 2093836 defendant Monnyng Robert yeoman 598937 598937 Monnyng, Robert, of Leyham, yeoman 1
4393435 2162405 2162405 defendant Heyward John yeoman 598937 598937 Heyward, John, of Leyham, yeoman 0
4414245 2169364 2169364 plaintiff Costyn John   598937 598937 Costyn, John, of Leyham, son of Idonia 0
4422413 2171874 2171874 defendant Moubray John   598937 598937 Moubray, John, of Leyham 0
4422415 2171875 2171875 defendant Moumbray John   598937 598937 Moumbray, John, of Leyham 0
4432950 2175050 2175050 defendant Moumbray John   598937 598937 Moumbray, John, of Leyham 0
4432952 2175051 2175051 defendant Moumbray John   598937 598937 Moumbray, John, of Leyham 0
4474017 2192525 2192525 defendant Harberd John   598937 598937 Harberd, John, of Leyham 0
4579188 2224973 2224973 defendant Bedeford John   598937 598937 Bedeford, John, of Leyham, parson 0
4583571 2226282 2226282 defendant Bedeforde John   598937 598937 Bedeforde, John, of Leyham, parson 0
4584273 2226493 2226493 defendant Goybe Thomas   598937 598937 Goybe, Thomas, of Leyham 0
4584461 2226555 2226555 defendant Lorkyn John   598937 598937 Lorkyn, John, of Leyham 1
4596009 2230000 2230000 defendant Goyle John   598937 598937 Goyle, John, of Leyham 4
4609409 2234043 2234043 defendant Shepherede William   598937 598937 Shepherede, William, of Leyham 1
4618970 2236926 2236926 plaintiff Herberd John   598937 598937 Herberd, John, of Leyham 0
4646238 2244971 2244971 defendant Bedeforde John   598937 598937 Bedeforde, John, of Leyham, parson 3
4704934 2266919 2266919 defendant Bedford John   598937 598937 Bedford, John, of Leyham, parson 4
4713287 2269481 2269481 defendant atte Watyr Robert yeoman 598937 598937 atte Watyr, Robert, of Leyham, yeoman 2
4807630 2298576 2298576 defendant Dwyte John yeoman 598937 598937 Dwyte, John, of Leyham, yeoman 1
4834229 2306716 2306716 defendant Mud Richard   598937 598937 Mud, Richard, of Leyham, plough man 2
4898515 2326186 2326186 defendant Pryk John butcher 598937 598937 Pryk, John, of Leyham, butcher 0
4902281 2327324 2327324 defendant Prykke John butcher 598937 598937 Prykke, John, of Leyham, butcher 0
4908424 2329191 2329191 defendant Prykke John butcher 598937 598937 Prykke, John, of Leyham, butcher 1
4915960 2331488 2331488 defendant Prykke John butcher 598937 598937 Prykke, John, of Leyham, butcher 2
4919403 2332578 2332578 defendant Prykke John butcher 598937 598937 Prykke, John, of Leyham, butcher 0
4933964 2337002 2337002 defendant Pryke John butcher 598937 598937 Pryke, John, of Leyham, butcher 0
4933966 2337003 2337003 defendant Pryke John butcher 598937 598937 Pryke, John, of Leyham, butcher 0
4935493 2337499 2337499 defendant Peke Nicholas gent 598937 598937 Peke, Nicholas, of Leyham, franklin, or of Colchester, gent 0
4938228 2338333 2338333 defendant Pryke John butcher 598937 598937 Pryke, John, of Leyham, butcher 0
4943763 2340018 2340018 defendant Lylye John carpenter 598937 598937 Lylye, John, of Leyham, carpenter 1
4945896 2340700 2340700 defendant Prykke John butcher 598937 598937 Prykke, John, of Leyham, butcher 0
4946677 2340962 2340962 defendant Pyntyng John carter 598937 598937 Pyntyng, John, of Leyham, carter 2
4948000 2341359 2341359 defendant Schomere John husbandman 598937 598937 Schomere, John, of Leyham, husbandman 0
4950719 2342192 2342192 defendant Reymond Thomas laborer 598937 598937 Reymond, Thomas, of Leyham, laborer 2
4953052 2342879 2342879 plaintiff Schomere John   598937 598937 Schomere, John, of Leyham 0
4960883 2345217 2345217 defendant Peke Nicholas gent 598937 598937 Peke, Nicholas, of Leyham, franklin, or of Colchester, gent 0
4990076 2353940 2353940 defendant Prykke John butcher 598937 598937 Prykke, John, of Leyham, butcher 2
4990079 2353941 2353941 defendant Prykke John butcher 598937 598937 Prykke, John, of Leyham, butcher 1
4993400 2354895 2354895 defendant Shomere John husbandman 598937 598937 Shomere, John, of Leyham, husbandman 4
5008033 2359239 2359239 defendant Wellys John laborer 598937 598937 Wellys, John, of Leyham, laborer 5
5008034 2359239 2359239 defendant Wellys Thomas laborer 598937 598937 Wellys, Thomas, of Leyham, laborer 6
5030209 2365705 2365705 defendant Pyntyng Joan widow 598937 598937 Pyntyng, Joan, of Leyham, widow 3
5041692 2369115 2369115 defendant Potter William laborer 598937 598937 Potter, William, of Leyham, laborer 0
5093351 2384454 2384454 defendant Bullyngton John yeoman 598937 598937 Bullyngton, John, of Leyham, yeoman 0
5112190 2389948 2389948 defendant Weston Gregory laborer 598937 598937 Weston, Gregory, of Leyham, laborer 0
5117689 2391609 2391609 defendant Bolyngton Roger yeoman 598937 598937 Bolyngton, Roger, of Leyham, yeoman 0
5117696 2391611 2391611 defendant Bolyngton Roger   598937 598937 Bolyngton, Roger, of Leyham 0
5136520 2397195 2397195 defendant Bowe John husbandman 598937 598937 Bowe, John, of Leyham, husbandman 1
5149560 2401000 2401000 defendant Bowe John husbandman 598937 598937 Bowe, John, of Leyham, husbandman 1
5177284 2409050 2409050 defendant Seriaunt William husbandman 598937 598937 Seriaunt, William, of Leyham, husbandman 0
5177285 2409050 2409050 defendant Wever John husbandman 598937 598937 Wever, John, of Leyham, husbandman 1
5177287 2409050 2409050 defendant Terboll Robert laborer 598937 598937 Terboll, Robert, of Leyham, laborer 3
5192959 2413668 2413668 defendant Bolyngton Robert yeoman 598937 598937 Bolyngton, Robert, of Leyham, yeoman 0
5211404 2419069 2419069 defendant Seriaunt William husbandman 598937 598937 Seriaunt, William, of Leyham, husbandman 0
5211405 2419069 2419069 defendant Wever John husbandman 598937 598937 Wever, John, of Leyham, husbandman 1
5211407 2419069 2419069 defendant Terboll Robert laborer 598937 598937 Terboll, Robert, of Leyham, laborer 3
5238074 2426725 2426725 defendant Seriaunt William laborer 598937 598937 Seriaunt, William, of Leyham, laborer 0
5243593 2428319 2428319 defendant Carter Augustine husbandman 598937 598937 Carter, Augustine, of Leyham, husbandman 0
5247657 2429474 2429474 defendant Rowynton Thomas yeoman 598937 598937 Rowynton, Thomas, of Leyham, yeoman 1
5247667 2429475 2429475 defendant Rowynton Thomas yeoman 598937 598937 Rowynton, Thomas, of Leyham, yeoman 1
5255792 2431933 2431933 defendant Water Robert weaver 598937 598937 Water, Robert, of Leyham, weaver 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);