names

50 rows where place_id = 598657

✎ 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
3633426 1905268 1905268 defendant Couper John husbandman 598657 598657 Couper, John, of Laxfeld, Suff, husbandman 3
3707125 1928515 1928515 defendant Pyers John husbandman 598657 598657 Pyers, John, of Laxfeld, Suff, husbandman 2
3710163 1929493 1929493 defendant Cowper John husbandman 598657 598657 Cowper, John, of Laxfeld, Suff, husbandman 1
3780679 1951687 1951687 defendant Sancroft William husbandman 598657 598657 Sancroft, William, of Laxfeld, Suff, husbandman 0
3848785 1973205 1973205 defendant Dery Thomas husbandman 598657 598657 Dery, Thomas, of Laxfeld, Suff, husbandman 3
3931534 2000846 2000846 defendant Jarveys William yeoman 598657 598657 Jarveys, William, of Laxfeld, Suff, yeoman 0
3956374 2009292 2009292 defendant Smyth Nicholas yeoman 598657 598657 Smyth, Nicholas, of Laxfeld, Suff, yeoman 0
3959599 2010450 2010450 defendant Lovell Thomas gent 598657 598657 Lovell, Thomas, of Laxfeld, Suff, gent 0
3959601 2010451 2010451 defendant Lovell Thomas gent 598657 598657 Lovell, Thomas, of Laxfeld, Suff, gent 0
3971963 2014751 2014751 defendant Albye Geoffrey yeoman 598657 598657 Albye, Geoffrey, of Laxfeld, Suff, yeoman 0
3975717 2016067 2016067 plaintiff Hyll John   598657 598657 Hyll, John, of Laxfeld, Suff 0
3984865 2019341 2019341 defendant Artes Simon singleman 598657 598657 Artes, Simon, of Laxfeld, Suff, yeoman, singleman 1
3984868 2019342 2019342 defendant Artes Simon singleman 598657 598657 Artes, Simon, of Laxfeld, Suff, yeoman, singleman 1
3987856 2020403 2020403 defendant Borrett John yeoman 598657 598657 Borrett, John, of Laxfeld, Suff, yeoman 0
3996005 2023326 2023326 defendant Borrett John yeoman 598657 598657 Borrett, John, of Laxfeld, Suff, yeoman 0
3996008 2023327 2023327 defendant Jacobbe Godfrey yeoman 598657 598657 Jacobbe, Godfrey, of Laxfeld, Suff, yeoman 1
3996012 2023328 2023328 defendant Jacobbe Godfrey yeoman 598657 598657 Jacobbe, Godfrey, of Laxfeld, Suff, yeoman 0
3996016 2023330 2023330 defendant Noller John yeoman 598657 598657 Noller, John, of Laxfeld, Suff, yeoman 0
4035844 2037491 2037491 defendant Fyske Mathew   598657 598657 Fyske, Mathew, of Laxfeld, Suff, ploughwright 1
4037080 2037926 2037926 plaintiff Jenour John yeoman 598657 598657 Jenour, John, of Laxfeld, Suff, yeoman 0
4202626 2096461 2096461 defendant Butcher Edward yeoman 598657 598657 Butcher, Edward, of Laxfeld, Suff, yeoman 0
4823846 2303538 2303538 defendant Seman Edmund yeoman 598657 598657 Seman, Edmund, of Laxfeld, Suff, yeoman 1
4863498 2315555 2315555 plaintiff Ede William   598657 598657 Ede, William, of Laxfeld, Suff 0
4890926 2323909 2323909 plaintiff Ede William   598657 598657 Ede, William, of Laxfeld, Suff 0
4897318 2325820 2325820 defendant Ede William yeoman 598657 598657 Ede, William, of Laxfeld, Suff, yeoman 0
4903874 2327828 2327828 defendant Thrower Robert husbandman 598657 598657 Thrower, Robert, of Laxfeld, Suff, husbandman 0
4981408 2351356 2351356 defendant Ede William yeoman 598657 598657 Ede, William, of Laxfeld, Suff, yeoman 2
5007147 2358978 2358978 defendant Balstan William husbandman 598657 598657 Balstan, William, of Laxfeld, Suff, husbandman 0
5009184 2359573 2359573 defendant Sewale John chapman 598657 598657 Sewale, John, of Laxfeld, Suff, chapman 0
5035145 2367143 2367143 defendant Hardyment Joohn yeoman 598657 598657 Hardyment, Joohn, of Laxfeld, Suff, yeoman 1
5042813 2369458 2369458 defendant Smyth Roger yeoman 598657 598657 Smyth, Roger, of Laxfeld, Suff, yeoman 4
5072413 2378238 2378238 defendant Hardyment John yeoman 598657 598657 Hardyment, John, of Laxfeld, Suff, yeoman 0
5091979 2384034 2384034 defendant Kempe Godfrey (legal representative) 598657 598657 Kempe, Godfrey, of Laxfeld, Suff, widow, executors of 0
5096463 2385399 2385399 defendant Sewall John chapman 598657 598657 Sewall, John, of Laxfeld, Suff, chapman 0
5096467 2385400 2385400 defendant Sewall John chapman 598657 598657 Sewall, John, of Laxfeld, Suff, chapman 0
5097289 2385639 2385639 defendant Covele Thomas yeoman 598657 598657 Covele, Thomas, of Laxfeld, Suff, yeoman 0
5102402 2387106 2387106 defendant Bryggys William yeoman 598657 598657 Bryggys, William, of Laxfeld, Suff, yeoman 2
5136771 2397274 2397274 defendant Whyte William carpenter 598657 598657 Whyte, William, of Laxfeld, Suff, carpenter 0
5136774 2397275 2397275 defendant Whyte William carpenter 598657 598657 Whyte, William, of Laxfeld, suff, carpenter 0
5193230 2413749 2413749 defendant Whyte Thomas carpenter 598657 598657 Whyte, Thomas, of Laxfeld, Suff, carpenter 0
5195799 2414519 2414519 defendant Stannard Thomas carpenter 598657 598657 Stannard, Thomas, of Laxfeld, Suff, carpenter 0
5195803 2414520 2414520 defendant Stannard Thomas carpenter 598657 598657 Stannard, Thomas, of Laxfeld, Suff, carpenter 0
5209401 2418485 2418485 defendant Staunard Thomas carpenter 598657 598657 Staunard, Thomas, of Laxfeld, Suff, carpenter 0
5216759 2420637 2420637 defendant Thrower John husbandman 598657 598657 Thrower, John, of Laxfeld, Suff, husbandman 0
5272497 2437028 2437028 defendant Kimwold William husbandman 598657 598657 Kimwold, William, of Laxfeld, Suff, husbandman 3
5287260 2441295 2441295 defendant Kunwold William husbandman 598657 598657 Kunwold, William, of Laxfeld, Suff, husbandman 1
5315538 2449714 2449714 defendant Balston William yeoman 598657 598657 Balston, William, of Laxfeld, Suff, yeoman 2
5473184 2496938 2496938 defendant Seffrey Robert clerk 598657 598657 Seffrey, Robert, of Laxfeld, Suff, clerk 0
5503497 2506005 2506005 defendant Arteys John, junior yeoman 598657 598657 Arteys, John, junior, of Laxfeld, Suff, yeoman 1
5516318 2509937 2509937 defendant Kyrspe John   598657 598657 Kyrspe, John, of Laxfeld, Suff, smyth 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);