names

119 rows where place_id = 594726

✎ 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
3615737 1872563 1872563 defendant Betyll William yeoman of the crown 594726 594726 Betyll, William, of Orford, yeoman of the crown 1
3617298 1873035 1873035 defendant Wylde John yeoman 594726 594726 Wylde, John, of Orford, yeoman 1
3617299 1873035 1873035 defendant Fyssher Peter yeoman 594726 594726 Fyssher, Peter, of Orford, yeoman 2
3617526 1873102 1873102 defendant Maryot John yeoman 594726 594726 Maryot, John, of Orford, yeoman 0
3619294 1873637 1873637 defendant Betyll William mariner 594726 594726 Betyll, William, of Orford, mariner 0
3690465 1923184 1923184 defendant Hunt Richard yeoman 594726 594726 Hunt, Richard, of Orford, yeoman 4
3731067 1935943 1935943 defendant Bokyll Robert yeoman 594726 594726 Bokyll, Robert, of Orford, yeoman 3
3763822 1946330 1946330 defendant Noluff John yeoman 594726 594726 Noluff, John, of Orford, yeoman 0
3812117 1961701 1961701 defendant Garnon John yeoman 594726 594726 Garnon, John, of Orford, yeoman 0
3816545 1963076 1963076 defendant Jacob John mercer 594726 594726 Jacob, John, of Orford, mercer 1
3830855 1967531 1967531 defendant Chester Richard mariner 594726 594726 Chester, Richard, of Orford, mariner 0
3830856 1967531 1967531 defendant Harward William mariner 594726 594726 Harward, William, of Orford, mariner 1
3830857 1967531 1967531 defendant Johnson John mariner 594726 594726 Johnson, John, of Orford, mariner 2
3860528 1977014 1977014 defendant Chetylbergh John yeoman 594726 594726 Chetylbergh, John, of Orford, yeoman 0
3860529 1977014 1977014 defendant Pye John husbandman 594726 594726 Pye, John, of Orford, husbandman 1
3860869 1977128 1977128 defendant Edy Robert cordwainer 594726 594726 Edy, Robert, of Orford, cordwainer 2
3898906 1989838 1989838 defendant Pawlyng Robert butcher 594726 594726 Pawlyng, Robert, of Orford, butcher 0
3907517 1992809 1992809 defendant Partriche Robert butcher 594726 594726 Partriche, Robert, of Orford, butcher 2
3934980 2002002 2002002 defendant Edmundes alias Cooke Robert mariner 594726 594726 Edmundes alias Cooke, Robert, of Orford, mariner 1
3937646 2002923 2002923 defendant Shemyng John smith 594726 594726 Shemyng, John, of Orford, smith 2
3947881 2006323 2006323 defendant Spycer Thomas yeoman 594726 594726 Spycer, Thomas, of Orford, yeoman 0
3992026 2021913 2021913 defendant Cawson Augustine husbandman 594726 594726 Cawson, Augustine, of Orford, husbandman 1
4136089 2073249 2073249 defendant Agas Thomas clerk 594726 594726 Agas, Thomas, of Orford, clerk 0
4150930 2078456 2078456 defendant Cossett Reginald weaver 594726 594726 Cossett, Reginald, of Orford, weaver 1
4213350 2100185 2100185 defendant Pootye James innholder 594726 594726 Pootye, James, of Orford, sailor, son of John Pootye, of Woodbridge, innholder 0
4236975 2108511 2108511 defendant Gouldes Robert gent 594726 594726 Gouldes, Robert, of Orford, gent 0
4237346 2108650 2108650 defendant Clifton John brewer 594726 594726 Clifton, John, of Orford, brewer 2
4240899 2109942 2109942 defendant Cuttinge John gent 594726 594726 Cuttinge, John, of Orford, gent 0
4270346 2119662 2119662 defendant Clifton John brewer 594726 594726 Clifton, John, of Orford, brewer 2
4357427 2149826 2149826 defendant Slade Geoffrey weaver 594726 594726 Slade, Geoffrey, of Orford, or of Layston Sysewell, weaver 1
4436544 2176168 2176168 plaintiff Spicer William le   594726 594726 Spicer, William le, of Orford 0
4436550 2176169 2176169 plaintiff Spicer William le   594726 594726 Spicer, William le, of Orford 0
4496224 2199494 2199494 plaintiff Cokerell John   594726 594726 Cokerell, John, of Orford, on his own account 0
4496230 2199495 2199495 defendant Magges John   594726 594726 Magges, John, of Orford 1
4505983 2202382 2202382 defendant Spycer William   594726 594726 Spycer, William, of Orford 0
4505986 2202383 2202383 defendant Spisour Richard   594726 594726 Spisour, Richard, of Orford 0
4516277 2205501 2205501 plaintiff Cokerell John   594726 594726 Cokerell, John, of Orford 0
4516280 2205502 2205502 plaintiff Cokerell John   594726 594726 Cokerell, John, of Orford 0
4516283 2205503 2205503 plaintiff Cokerell John   594726 594726 Cokerell, John, of Orford 0
4517303 2205813 2205813 plaintiff Cokerell John   594726 594726 (Cokerell, John, of Orford 1
4540819 2213034 2213034 defendant Magges John   594726 594726 Magges, John, of Orford 2
4540827 2213036 2213036 defendant Magges John   594726 594726 Magges, John, of Orford 1
4548986 2215616 2215616 plaintiff Cokerell John   594726 594726 Cokerell, John, of Orford 0
4627981 2239674 2239674 defendant Stovene Robert (legal representative) 594726 594726 Stovene, Robert, of Orford, executors of 2
4634321 2241578 2241578 defendant Heigham John   594726 594726 Heigham, John, of Orford 0
4649311 2245848 2245848 defendant Ulveston Richard   594726 594726 Ulveston, Richard, of Orford 3
4657637 2248280 2248280 defendant Letylgrome John, junior pedder 594726 594726 Letylgrome, John, junior, of Orford, pedder 4
4657638 2248280 2248280 defendant Heygham John ploughman 594726 594726 Heygham, John, of Orford, ploughman 5
4657639 2248280 2248280 defendant Heygham Hugh shipman 594726 594726 Heygham, Hugh, of Orford, shipman 6
4657642 2248281 2248281 defendant Litylgrome John, junior pedder 594726 594726 Litylgrome, John, junior, of Orford, pedder 1
4657643 2248281 2248281 defendant Heygham John ploughman 594726 594726 Heygham, John, of Orford, ploughman 2
4657644 2248281 2248281 defendant Heygham Hugh shipman 594726 594726 Heygham, Hugh, of Orford, shipman 3
4672405 2257022 2257022 defendant Magges John husbandman 594726 594726 Magges, John, of Orford, husbandman 0
4703246 2266394 2266394 plaintiff Heigham Richard   594726 594726 Heigham, Richard, of Orford 0
4703248 2266394 2266394 defendant Halle Robert husbandman 594726 594726 Halle, Robert, of Orford, husbandman 1
4706657 2267463 2267463 plaintiff Magges John   594726 594726 Magges, John, of Orford 0
4761435 2283920 2283920 defendant Hygham William yeoman 594726 594726 Hygham, William, of Orford, yeoman 1
4761436 2283920 2283920 defendant Hygham Augustine yeoman 594726 594726 Hygham, Augustine, of Orford, yeoman 2
4761437 2283920 2283920 defendant Hygham John yeoman 594726 594726 Hygham, John, of Orford, yeoman 3
4765350 2285146 2285146 defendant gotte John laborer 594726 594726 gotte, John, of Orford, laborer 1
4788788 2292550 2292550 defendant Audele Peter clerk 594726 594726 Audele, Peter, of Orford, clerk 1
4788789 2292550 2292550 defendant Rydde Robert husbandman 594726 594726 Rydde, Robert, of Orford, husbandman 2
4788790 2292550 2292550 defendant Magges John husbandman 594726 594726 Magges, John, of Orford, husbandman 3
4788791 2292550 2292550 defendant Bullyng John laborer 594726 594726 Bullyng, John, of Orford, laborer 4
4792314 2293684 2293684 defendant Bayer John yeoman 594726 594726 Bayer, John, of Orford, yeoman 0
4796027 2294907 2294907 plaintiff Rydde Robert   594726 594726 Rydde, Robert, of Orford 0
4796028 2294907 2294907 plaintiff Magges John   594726 594726 Magges, John, of Orford 1
4800408 2296307 2296307 defendant Heigham William draper 594726 594726 Heigham, William, of Orford, draper 0
4804657 2297652 2297652 defendant Coteller Edmund yeoman 594726 594726 Coteller, Edmund, of Orford, yeoman 2
4843068 2309363 2309363 defendant Bury Thomas yeoman 594726 594726 Bury, Thomas, of Orford, yeoman 1
4843070 2309363 2309363 defendant Talnas Robert yeoman 594726 594726 Talnas, Robert, of Orford, yeoman 3
4843071 2309363 2309363 defendant Baspall Augustine mariner 594726 594726 Baspall, Augustine, of Orford, mariner 4
4884058 2321926 2321926 defendant Leveson John tailor 594726 594726 Leveson, John, of Orford, tailor 1
4898498 2326181 2326181 defendant Baspall Thomas shipman 594726 594726 Baspall, Thomas, of Orford, shipman 0
4926816 2334810 2334810 defendant Mannyng John   594726 594726 Mannyng, John, of Orford, bailiff 0
4959640 2344844 2344844 defendant Rolf Richard husbandman 594726 594726 (Rolf, Richard, of Orford, husbandman 1
4972045 2348575 2348575 defendant Rennard or Renward William chaplain 594726 594726 Rennard or Renward, William, of Orford, chaplain 2
4989324 2353741 2353741 plaintiff Bullyng John   594726 594726 Bullyng, John, of Orford 0
5086672 2382493 2382493 defendant Mannyng William   594726 594726 Mannyng, William, of Orford, bailiff 2
5086676 2382494 2382494 defendant Mannyng William   594726 594726 Mannyng, William, of Orford, bailiff 1
5094548 2384817 2384817 plaintiff Rydde John   594726 594726 Rydde, John, of Orford 0
5094549 2384817 2384817 plaintiff Bullyng John   594726 594726 Bullyng, John, of Orford 1
5120978 2392569 2392569 defendant Rydde John husbandman 594726 594726 Rydde, John, of Orford, husbandman 0
5228064 2423814 2423814 defendant Mannyng Richard yeoman 594726 594726 Mannyng, Richard, of Orford, yeoman 0
5267960 2435744 2435744 defendant Gesard John husbandman 594726 594726 Gesard, John, of Orford, husbandman 0
5277725 2438572 2438572 defendant Gesard John husbandman 594726 594726 Gesard, John, of Orford, husbandman 1
5289019 2441796 2441796 defendant Gefard John husbandman 594726 594726 Gefard, John, of Orford, husbandman 0
5291207 2442431 2442431 defendant Mannyng Richard yeoman 594726 594726 Mannyng, Richard, of Orford, yeoman 1
5291210 2442432 2442432 defendant Mannyng Richard yeoman 594726 594726 Mannyng, Richard, of Orford, yeoman 1
5311565 2448483 2448483 defendant Talnas John husbandman 594726 594726 Talnas, John, of Orford, husbandman 0
5318563 2450647 2450647 defendant Gesard or Gefard John husbandman 594726 594726 Gesard or Gefard, John, of Orford, husbandman 0
5345413 2458737 2458737 defendant Kelwyn John thatcher 594726 594726 Kelwyn, John, of Orford, thatcher 0
5371087 2466545 2466545 plaintiff Haukyn John yeoman 594726 594726 Haukyn, John, of Orford, yeoman 0
5385369 2470893 2470893 defendant Martyn John mariner 594726 594726 Martyn, John, of Orford, mariner 0
5408572 2477528 2477528 defendant Childerous Walter yeoman 594726 594726 Childerous, Walter, of Orford, yeoman 1
5413706 2479026 2479026 defendant Cotyngham Robert mariner 594726 594726 Cotyngham, Robert, of Orford, mariner 0
5421784 2481451 2481451 defendant Childerous Walter   594726 594726 Childerous, Walter, of Orford 1
5421788 2481452 2481452 defendant Childerous Walter yeoman 594726 594726 Childerous, Walter, of Orford, yeoman 1
5421792 2481453 2481453 defendant Childerous Walter yeoman 594726 594726 Childerous, Walter, of Orford, yeoman 1
5442672 2487722 2487722 plaintiff Bokyll Richard (legal representative) 594726 594726 Bokyll, Richard, of Orford, executor of 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);