names

107 rows where place_id = 597296

✎ 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
3628001 1903613 1903613 defendant Sekker Robert husbandman 597296 597296 Sekker, Robert, of Shropham, husbandman 0
3628002 1903613 1903613 defendant Wylkyns Edmund husbandman 597296 597296 Wylkyns, Edmund, of Shropham, husbandman 1
3628003 1903613 1903613 defendant Gall John husbandman 597296 597296 Gall, John, of Shropham, husbandman 2
3628004 1903613 1903613 defendant Aleyn Henry husbandman 597296 597296 Aleyn, Henry, of Shropham, husbandman 3
3628005 1903613 1903613 defendant Kyng Nicholas husbandman 597296 597296 Kyng, Nicholas, of Shropham, husbandman 4
3641400 1907764 1907764 defendant Galle John butcher 597296 597296 Galle, John, of Shropham, butcher 0
3641696 1907859 1907859 defendant Layte Thomas husbandman 597296 597296 Layte, Thomas, of Shropham, husbandman 2
3653589 1911389 1911389 defendant Mabeley John, senior yeoman 597296 597296 Mabeley, John, senior, of Shropham, yeoman 0
3762213 1945828 1945828 plaintiff Galle Thomas husbandman 597296 597296 Galle, Thomas, of Shropham, husbandman 0
3762214 1945828 1945828 defendant Plantyng John husbandman 597296 597296 Plantyng, John, of Shropham, husbandman 0
3762215 1945828 1945828 defendant Mannyng William husbandman 597296 597296 Mannyng, William, of Shropham, husbandman 1
3766239 1947094 1947094 defendant Rowhede Robert husbandman 597296 597296 Rowhede, Robert, of Shropham, husbandman 0
3867495 1979362 1979362 defendant Mably Robert (legal representative) 597296 597296 Mably, Robert, of Shropham, husbandman, executors of 0
3892866 1987861 1987861 defendant Burton Hugh mercer 597296 597296 Burton, Hugh, of Shropham, mercer 0
3955261 2008906 2008906 defendant Hawsted George clerk 597296 597296 Hawsted, George, of Shropham, clerk 0
3967520 2013275 2013275 defendant Wix John husbandman 597296 597296 Wix, John, of Shropham, husbandman 0
3969220 2013844 2013844 defendant Olyver Edmund husbandman 597296 597296 Olyver, Edmund, of Shropham, husbandman 0
3980664 2017848 2017848 defendant Wyck John husbandman 597296 597296 Wyck, John, of Shropham, husbandman 3
3980744 2017875 2017875 defendant Oliver Edmund husbandman 597296 597296 Oliver, Edmund, of Shropham, husbandman 1
4000614 2024993 2024993 defendant Olyver Edmund husbandman 597296 597296 Olyver, Edmund, of Shropham, husbandman 2
4005876 2026871 2026871 defendant Olyver Edmund yeoman 597296 597296 Olyver, Edmund, of Shropham, yeoman 0
4006793 2027207 2027207 defendant Olyver Edmund yeoman 597296 597296 Olyver, Edmund, of Shropham, yeoman 0
4006796 2027208 2027208 defendant Wylkens John yeoman 597296 597296 Wylkens, John, of Shropham, yeoman 0
4021787 2032522 2032522 defendant Olyver Edmund yeoman 597296 597296 Olyver, Edmund, of Shropham, yeoman 0
4057788 2045170 2045170 defendant Olyver Thomas husbandman 597296 597296 Olyver, Thomas, of Shropham, husbandman 1
4070382 2049704 2049704 defendant Smyth Stephen husbandman 597296 597296 Smyth, Stephen, of Shropham, husbandman 0
4070493 2049737 2049737 defendant Levett John husbandman 597296 597296 Levett, John, of Shropham, husbandman 0
4072255 2050378 2050378 plaintiff Oliver Thomas husbandman 597296 597296 Oliver, Thomas, of Shropham, husbandman 0
4072256 2050378 2050378 defendant Parker Edward husbandman 597296 597296 Parker, Edward, of Shropham, husbandman 0
4072257 2050378 2050378 defendant Olyver Richard husbandman 597296 597296 Olyver, Richard, of Shropham, husbandman 1
4072259 2050379 2050379 defendant Wylkyns John yeoman 597296 597296 Wylkyns, John, of Shropham, yeoman 0
4072260 2050379 2050379 defendant Rowghead Peter husbandman 597296 597296 Rowghead, Peter, of Shropham, husbandman 1
4072563 2050492 2050492 defendant Secker John husbandman 597296 597296 Secker, John, of Shropham, husbandman 2
4076581 2051922 2051922 defendant Broundytche Roger husbandman 597296 597296 Broundytche, Roger, of Shropham, husbandman 0
4076582 2051923 2051923 plaintiff Skott John   597296 597296 Skott, John, of Shropham 0
4109221 2063555 2063555 defendant Bromdytche Roger husbandman 597296 597296 Bromdytche, Roger, of Shropham, husbandman 0
4110668 2064072 2064072 defendant Secker Robert husbandman 597296 597296 Secker, Robert, of Shropham, husbandman 1
4111455 2064344 2064344 defendant Wylkyns John husbandman 597296 597296 Wylkyns, John, of Shropham, husbandman 0
4188000 2091302 2091302 defendant Oliver alias Holliser Edmund yeoman 597296 597296 Oliver alias Holliser, Edmund, of Shropham, yeoman 2
4215426 2100891 2100891 defendant Parker Edward yeoman 597296 597296 Parker, Edward, of Shropham, yeoman 0
4218449 2101952 2101952 defendant Parker Edward husbandman 597296 597296 Parker, Edward, of Shropham, husbandman 2
4229946 2105957 2105957 defendant Parker Edward husbandman 597296 597296 Parker, Edward, of Shropham, husbandman 0
4244670 2111201 2111201 defendant Parker Edward husbandman 597296 597296 Parker, Edward, of Shropham, husbandman 2
4258474 2115801 2115801 defendant Burdes Thomas sawyer 597296 597296 Burdes, Thomas, of Shropham, sawyer 3
4286153 2125101 2125101 defendant Coldham John yeoman 597296 597296 Coldham, John, of Shropham, yeoman 0
4330943 2140649 2140649 defendant Wilkyns Thomas husbandman 597296 597296 Wilkyns, Thomas, of Shropham, husbandman 0
4332589 2141187 2141187 defendant Parker Edward husbandman 597296 597296 Parker, Edward, of Shropham, husbandman 2
4333715 2141556 2141556 defendant Webster Ambrose weaver 597296 597296 Webster, Ambrose, of Shropham, weaver 0
4342317 2144589 2144589 defendant Lovett John yeoman 597296 597296 Lovett, John, of Shropham, yeoman 0
4342318 2144589 2144589 defendant Lovett Thomas, junior husbandman 597296 597296 Lovett, Thomas, junior, of Shropham, husbandman 1
4404345 2166023 2166023 defendant Norrice John husbandman 597296 597296 Norrice, John, of Shropham, husbandman 0
4408830 2167552 2167552 defendant Norrys John yeoman 597296 597296 Norrys, John, of Shropham, yeoman 0
4410750 2168186 2168186 defendant Norrice John husbandman 597296 597296 Norrice, John, of Shropham, husbandman 0
4410846 2168216 2168216 defendant Sacker Robert yeoman 597296 597296 Sacker, Robert, of Shropham, yeoman 3
4411980 2168602 2168602 defendant Parker Edward husbandman 597296 597296 Parker, Edward, of Shropham, husbandman 0
4411984 2168603 2168603 defendant Oliver Peter husbandman 597296 597296 Oliver, Peter, of Shropham, husbandman 1
4481651 2194957 2194957 defendant atte Medwe John   597296 597296 atte Medwe, John, of Shropham 0
4499026 2200338 2200338 defendant Fisshere William   597296 597296 Fisshere, William, of Shropham 0
4533992 2210900 2210900 defendant Palmere Thomas   597296 597296 Palmere, Thomas, of Shropham 1
4548942 2215599 2215599 defendant Carter Richard   597296 597296 Carter, Richard, of Shropham 0
4575209 2223767 2223767 defendant Mannyng John, sen   597296 597296 Mannyng, John, sen, of Shropham 2
4582910 2226082 2226082 defendant Muddyng Richard   597296 597296 Muddyng, Richard, of Shropham 0
4599208 2230964 2230964 plaintiff Stokes Henry   597296 597296 Stokes, Henry, of Shropham, vicar 0
4610606 2234385 2234385 defendant Rous Peter   597296 597296 Rous, Peter, of Shropham 1
4611657 2234706 2234706 defendant Rythup John (legal representative) 597296 597296 Rythup, John, of Shropham, executors of 5
4611658 2234706 2234706 defendant Mannyng John   597296 597296 (Mannyng, John, of Shropham 6
4611661 2234707 2234707 defendant Sawer John   597296 597296 Sawer, John, of Shropham 0
4639241 2242994 2242994 defendant Sawere John   597296 597296 Sawere, John, of Shropham 1
4652346 2246685 2246685 defendant Mowyng Richard laborer 597296 597296 Mowyng, Richard, of Shropham, laborer 3
4656476 2247923 2247923 plaintiff Caus Roger   597296 597296 Caus, Roger, of Shropham 0
4657543 2248250 2248250 defendant Sawere John   597296 597296 Sawere, John, of Shropham 0
4657556 2248254 2248254 defendant Sawer John husbandman 597296 597296 Sawer, John, of Shropham, husbandman 2
4657561 2248255 2248255 defendant atte Medwe John yeoman 597296 597296 atte Medwe, John, of Shropham, yeoman 0
4724304 2272898 2272898 defendant Sawer John husbandman 597296 597296 Sawer, John, of Shropham, husbandman 2
4735113 2276131 2276131 defendant (not given) William vicar of Snell 597296 597296 Snell, William, of Shropham, vicar of St Peter's church 1
4791717 2293505 2293505 defendant Pakenham Henry gent 597296 597296 Pakenham, Henry, of Shropham, gent 0
4791720 2293506 2293506 defendant Pakenham Henry gent 597296 597296 Pakenham, Henry, of Shropham, gent 0
4831234 2305798 2305798 defendant Sawere John yeoman 597296 597296 Sawere, John, of Shropham, yeoman 0
4831484 2305877 2305877 defendant Harlewyn James   597296 597296 together with Harlewyn, James, of Shropham 3
4857101 2313601 2313601 defendant Sawere John yeoman 597296 597296 Sawere, John, of Shropham, yeoman 0
4876086 2319480 2319480 defendant Mannyng John yeoman 597296 597296 Mannyng, John, of Shropham, yeoman 3
4921057 2333097 2333097 defendant Loft Thomas husbandman 597296 597296 Loft, Thomas, of Shropham, husbandman 2
4925899 2334531 2334531 defendant Loft Thomas husbandman 597296 597296 Loft, Thomas, of Shropham, husbandman 1
4990375 2354032 2354032 plaintiff Caws Roger gent 597296 597296 Caws, Roger, of Shropham, gent 0
5051124 2371948 2371948 plaintiff Lalle John   597296 597296 Lalle, John, of Shropham, vicar 1
5067714 2376841 2376841 defendant Lalle John clerk 597296 597296 Lalle, John, of Shropham, clerk 0
5082234 2381179 2381179 defendant Pakenham Robert esq 597296 597296 Pakenham, Robert, of Shropham, esq 0
5090147 2383490 2383490 defendant Pakenham Robert esq 597296 597296 Pakenham, Robert, of Shropham, esq 0
5090149 2383491 2383491 defendant Pakenham Robert esq 597296 597296 Pakenham, Robert, of Shropham, esq 0
5090151 2383492 2383492 defendant Pakenham Robert esq 597296 597296 Pakenham, Robert, of Shropham, esq 0
5090154 2383493 2383493 defendant Pakenham Robert esq 597296 597296 together with Pakenham, Robert, of Shropham, esq 1
5123990 2393469 2393469 defendant Mabe- William laborer 597296 597296 Mabe-, William, of Shropham, laborer 1
5190897 2413084 2413084 defendant Pakenham Robert esq 597296 597296 Pakenham, Robert, of Shropham, esq 0
5207143 2417830 2417830 defendant Pakynham Robert esq 597296 597296 Pakynham, Robert, of Shropham, esq 0
5233276 2425321 2425321 defendant Rous John husbandman 597296 597296 Rous, John, of Shropham, husbandman 0
5233277 2425321 2425321 defendant Sekker John, junior husbandman 597296 597296 Sekker, John, junior, of Shropham, husbandman 1
5233278 2425321 2425321 defendant Luster Henry laborer 597296 597296 Luster, Henry, of Shropham, laborer 2
5269466 2436168 2436168 defendant Beny Henry husbandman 597296 597296 Beny, Henry, of Shropham, husbandman 1
5277676 2438554 2438554 defendant Caus Gregory gent 597296 597296 Caus, Gregory, of Shropham, gent 2
5300235 2445036 2445036 defendant Pakenham Henry gent 597296 597296 Pakenham, Henry, of Shropham, gent 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);