names

79 rows where place_id = 587053

✎ 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
3590343 1864621 1864621 defendant Wright Henry yeoman 587053 587053 Wright, Henry, of Sutton, Lincs, yeoman 0
3645531 1908999 1908999 defendant Pory William husbandman 587053 587053 Pory, William, of Sutton, Lincs, husbandman 0
3647745 1909686 1909686 plaintiff Mann John   587053 587053 Mann, John, of Sutton, Lincs, single man 0
3693368 1924139 1924139 defendant Joppes William husbandman 587053 587053 Joppes, William, of Sutton, Lincs, husbandman 2
3693514 1924179 1924179 defendant Holden Simon husbandman 587053 587053 Holden, Simon, of Sutton, Lincs, husbandman 0
3701289 1926649 1926649 defendant Park William tailor 587053 587053 Park, William, of Sutton, Lincs, tailor 0
3719780 1932450 1932450 defendant Chelton John yeoman 587053 587053 Chelton, John, of Sutton, Lincs, yeoman 0
3722049 1933159 1933159 defendant Calowe Henry husbandman 587053 587053 Calowe, Henry, of Sutton, Lincs, husbandman 0
3733894 1936848 1936848 defendant Partryk John yeoman 587053 587053 Partryk, John, of Sutton, Lincs, yeoman 2
3745069 1940364 1940364 defendant Wright John yeoman 587053 587053 Wright, John, of Sutton, Lincs, yeoman 4
3747787 1941228 1941228 defendant Bynderslaugh Simon (legal representative) 587053 587053 Bynderslaugh, Simon, of Sutton, Lincs, executors of 0
3761726 1945677 1945677 defendant Wright Robert, junior yeoman 587053 587053 Wright, Robert, junior, of Sutton, Lincs, yeoman 0
3762172 1945812 1945812 defendant Man John yeoman 587053 587053 Man, John, of Sutton, Lincs, yeoman 0
3795553 1956490 1956490 defendant Wilson Thomas yeoman 587053 587053 Wilson, Thomas, of Sutton, Lincs, yeoman 0
3795555 1956491 1956491 defendant Wylson Thomas yeoman 587053 587053 Wylson, Thomas, of Sutton, Lincs, yeoman 0
3806273 1959882 1959882 defendant Ogle Henry chaplain 587053 587053 Ogle, Henry, of Sutton, Lincs, chaplain 0
3826666 1966186 1966186 defendant Wylson Thomas yeoman 587053 587053 Wylson, Thomas, of Sutton, Lincs, yeoman 0
3831403 1967710 1967710 defendant Wylson Thomas yeoman 587053 587053 (Wylson, Thomas, of Sutton, Lincs, yeoman 1
3839848 1970395 1970395 defendant Wylson Thomas yeoman 587053 587053 Wylson, Thomas, of Sutton, Lincs, yeoman 0
3840987 1970751 1970751 defendant Wylson Thomas   587053 587053 (Wylson, Thomas, of Sutton, Lincs 1
3846805 1972551 1972551 defendant Wylson Thomas husbandman 587053 587053 (Wylson, Thomas, of Sutton, Lincs, husbandman 1
3849250 1973358 1973358 defendant Croxston alias Lutton James husbandman 587053 587053 Croxston alias Lutton, James, of Sutton, Lincs, husbandman 1
3850088 1973622 1973622 defendant Lambart Henry yeoman 587053 587053 Lambart, Henry, of Sutton, Lincs, yeoman 0
3850090 1973623 1973623 defendant Lambart Henry yeoman 587053 587053 Lambart, Henry, of Sutton, Lincs, yeoman 0
3920066 1997048 1997048 plaintiff Manne John yeoman 587053 587053 Manne, John, of Sutton, Lincs, yeoman 0
3920073 1997049 1997049 plaintiff Manne John yeoman 587053 587053 Manne, John, of Sutton, Lincs, yeoman 0
3923520 1998175 1998175 defendant Daye Robert husbandman 587053 587053 Daye, Robert, of Sutton, Lincs, husbandman 0
3930699 2000617 2000617 defendant Taylour Francis husbandman 587053 587053 Taylour, Francis, of Sutton, Lincs, husbandman 3
3935464 2002170 2002170 defendant Johnson Hugh yeoman 587053 587053 Johnson, Hugh, of Sutton, Lincs, yeoman 13
3966638 2012967 2012967 defendant Blackburne Thomas farmer of the parsonage 587053 587053 Blackburne, Thomas, of Sutton, Lincs, gent, farmer of the parsonage 0
3975604 2016031 2016031 defendant Parkynson Robert husbandman 587053 587053 Parkynson, Robert, of Sutton, Lincs, husbandman 1
4021830 2032536 2032536 defendant Foster John yeoman 587053 587053 Foster, John, of Sutton, Lincs, yeoman 0
4172555 2085861 2085861 defendant Chapman Nicholas husbandman 587053 587053 Chapman, Nicholas, of Sutton, Lincs, husbandman 2
4172573 2085866 2085866 defendant Brightman John, junior gent 587053 587053 Brightman, John, junior, of Sutton, Lincs, gent 1
4173889 2086324 2086324 defendant Bootye John yeoman 587053 587053 Bootye, John, of Sutton, Lincs, yeoman 0
4195768 2094073 2094073 defendant Brightman John, junior gent 587053 587053 Brightman, John, junior, of Sutton, Lincs, gent 1
4275984 2121549 2121549 defendant Chapman Nicholas yeoman 587053 587053 Chapman, Nicholas, of Sutton, Lincs, yeoman 1
4284922 2124656 2124656 defendant Diggell Joan widow 587053 587053 Diggell, Joan, of Sutton, Lincs, widow 1
4301446 2130621 2130621 defendant Buttye John yeoman 587053 587053 Buttye, John, of Sutton, Lincs, yeoman 0
4340471 2143934 2143934 defendant Brightman Thomas yeoman 587053 587053 Brightman, Thomas, of Sutton, Lincs, yeoman 0
4354597 2148843 2148843 defendant Crowe John yeoman 587053 587053 Crowe, John, of Sutton, Lincs, yeoman 1
4384064 2159369 2159369 defendant Blancke Richard gent 587053 587053 Blancke, Richard, of Sutton, Lincs, gent 3
4638557 2242813 2242813 defendant Bakon John   587053 587053 Bakon, John, of Sutton, Lincs 0
4644356 2244442 2244442 defendant Bacon John   587053 587053 Bacon, John, of Sutton, Lincs 0
4669370 2256128 2256128 defendant Becon John husbandman 587053 587053 Becon, John, of Sutton, Lincs, husbandman 0
4669371 2256128 2256128 defendant Grene William husbandman 587053 587053 Grene, William, of Sutton, Lincs, husbandman 1
4694590 2263804 2263804 defendant Grene Willaam husbandman 587053 587053 Grene, Willaam, of Sutton, Lincs, husbandman 0
4717210 2270712 2270712 defendant Loverd John husbandman 587053 587053 Loverd, John, of Sutton, Lincs, husbandman 1
4773682 2287743 2287743 defendant Tomson Robert husbandman 587053 587053 Tomson, Robert, of Sutton, Lincs, husbandman 0
4877958 2320060 2320060 defendant Wylkyn Robert yeoman 587053 587053 Wylkyn, Robert, of Sutton, Lincs, yeoman 0
4877959 2320060 2320060 defendant Welkes John yeoman 587053 587053 Welkes, John, of Sutton, Lincs, yeoman 1
4977526 2350242 2350242 defendant Dod Thomas draper 587053 587053 Dod, Thomas, of Sutton, Lincs, draper 3
5185197 2411417 2411417 defendant Forsett Robert   587053 587053 Forsett, Robert, of Sutton, Lincs, gent, administrators of 4
5185198 2411417 2411417 defendant Pory William draper 587053 587053 (Pory, William, of Sutton, Lincs, draper 5
5218552 2421157 2421157 defendant Scalys Robert   587053 587053 Scalys, Robert, of Sutton, Lincs, swan herd 0
5218555 2421158 2421158 defendant Scalys Robert   587053 587053 Scalys, Robert, of Sutton, Lincs, swan herd 0
5245069 2428726 2428726 defendant Pery Richard yeoman 587053 587053 Pery, Richard, of Sutton, Lincs, yeoman 0
5249075 2429850 2429850 defendant Fyssher Richard husbandman 587053 587053 Fyssher, Richard, of Sutton, Lincs, husbandman 2
5249081 2429851 2429851 defendant Fissher Richard husbandman 587053 587053 Fissher, Richard, of Sutton, Lincs, husbandman 2
5254967 2431667 2431667 defendant Archer John husbandman 587053 587053 Archer, John, of Sutton, Lincs, husbandman 1
5291884 2442631 2442631 defendant Hardy William husbandman 587053 587053 Hardy, William, of Sutton, Lincs, husbandman 0
5291889 2442633 2442633 defendant Pory Richard yeoman 587053 587053 Pory, Richard, of Sutton, Lincs, yeoman 0
5341130 2457418 2457418 defendant Gent John clerk 587053 587053 Gent, John, of Sutton, Lincs, clerk 2
5347342 2459331 2459331 defendant Pory Richard husbandman 587053 587053 Pory, Richard, of Sutton, Lincs, husbandman 0
5362229 2463852 2463852 defendant Fyssher Richard husbandman 587053 587053 Fyssher, Richard, of Sutton, Lincs, husbandman 2
5435370 2485519 2485519 defendant Stynte John husbandman 587053 587053 Stynte, John, of Sutton, Lincs, husbandman 2
5497091 2504068 2504068 defendant Nygale Edmund husbandman 587053 587053 Nygale, Edmund, of Sutton, Lincs, husbandman 0
5497095 2504069 2504069 defendant Nygale Edmund husbandman 587053 587053 Nygale, Edmund, of Sutton, Lincs, husbandman 0
5498593 2504521 2504521 defendant Thurston Robert yeoman 587053 587053 Thurston, Robert, of Sutton, Lincs, yeoman 4
5500166 2505002 2505002 defendant Foreste Robert yeoman 587053 587053 Foreste, Robert, of Sutton, Lincs, yeoman 0
5502489 2505699 2505699 defendant Tomlynson Richard husbandman 587053 587053 Tomlynson, Richard, of Sutton, Lincs, husbandman 0
5507242 2507165 2507165 defendant Wilkyn John yeoman 587053 587053 Wilkyn, John, of Sutton, Lincs, yeoman 13
5511971 2508601 2508601 defendant Nigale Edmund husbandman 587053 587053 Nigale, Edmund, of Sutton, Lincs, husbandman 0
5512267 2508698 2508698 plaintiff Male John   587053 587053 Male, John, of Sutton, Lincs 0
5515065 2509557 2509557 defendant Carter Robert husbandman 587053 587053 Carter, Robert, of Sutton, Lincs, husbandman 0
5539154 2516731 2516731 defendant Mason Robert husbandman 587053 587053 Mason, Robert, of Sutton, Lincs, husbandman 0
5570510 2525947 2525947 defendant Hyppe William gent 587053 587053 Hyppe, William, of Sutton, Lincs, gent 0
5588016 2531263 2531263 defendant Danyell William yeoman 587053 587053 Danyell, William, of Sutton, Lincs, yeoman 0
5593237 2532865 2532865 defendant Lambard Henry husbandman 587053 587053 Lambard, Henry, of Sutton, Lincs, husbandman 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);