names

52 rows where place_id = 594032

✎ 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
3614256 1872125 1872125 defendant Giles Robert husbandman 594032 594032 Giles, Robert, of Narford, husbandman 1
3614257 1872125 1872125 defendant Giles Bartholomew husbandman 594032 594032 Giles, Bartholomew, of Narford, husbandman 2
3614258 1872125 1872125 defendant att Wode Thomas husbandman 594032 594032 att Wode, Thomas, of Narford, husbandman 3
3614259 1872125 1872125 defendant att Wode John husbandman 594032 594032 att Wode, John, of Narford, husbandman 4
3614260 1872125 1872125 defendant Broun Thomas husbandman 594032 594032 Broun, Thomas, of Narford, husbandman 5
3667007 1915625 1915625 defendant Sutton Robert husbandman 594032 594032 Sutton, Robert, of Narford, husbandman 0
3741849 1939316 1939316 plaintiff Sutton Robert (legal representative) 594032 594032 Sutton, Robert, of Narford, administratrix of 0
3741852 1939316 1939316 defendant Skepper Henry husbandman 594032 594032 Skepper, Henry, of Narford, husbandman 1
3829001 1966955 1966955 defendant Stratweyth William clerk 594032 594032 Stratweyth, William, of Narford, clerk 0
3837372 1969600 1969600 defendant Rogerson John chaplain 594032 594032 Rogerson, John, of Narford, chaplain 0
3882109 1984275 1984275 plaintiff Sterwats alias Stertwayte William clerk 594032 594032 Sterwats alias Stertwayte, William, of Narford, clerk 0
3933777 2001591 2001591 defendant Stede William yeoman 594032 594032 Stede, William, of Narford, yeoman 0
3954646 2008691 2008691 defendant Hunt Hugh husbandman 594032 594032 Hunt, Hugh, of Narford, husbandman 1
4046581 2041230 2041230 defendant Chapman Edward   594032 594032 Chapman, Edward, of Narford, shepherd 1
4179199 2088200 2088200 defendant Rowse Christopher husbandman 594032 594032 Rowse, Christopher, of Narford, husbandman 1
4452517 2185785 2185785 defendant Snellyng Thomas   594032 594032 Snellyng, Thomas, of Narford 2
4503442 2201647 2201647 defendant Mason Thomas   594032 594032 Mason, Thomas, of Narford 0
4510173 2203667 2203667 defendant Bocher Roger   594032 594032 Bocher, Roger, of Narford 0
4510174 2203667 2203667 defendant Herne Robert in the   594032 594032 Herne, Robert in the, of Narford, vicar 1
4592625 2229045 2229045 defendant Edward Robert   594032 594032 Edward, Robert, of Narford 0
4592626 2229045 2229045 defendant Cressyngham John   594032 594032 Cressyngham, John, of Narford 1
4667393 2255523 2255523 defendant Deward Robert husbandman 594032 594032 Deward, Robert, of Narford, husbandman 0
4689820 2262375 2262375 defendant Rede Walter husbandman 594032 594032 Rede, Walter, of Narford, husbandman 3
4716086 2270338 2270338 defendant Cressyngham John   594032 594032 Cressyngham, John, of Narford, bailiff 2
4720444 2271730 2271730 defendant Caunceller William fuller 594032 594032 Caunceller, William, of Narford, fuller 2
4731621 2275082 2275082 defendant Fuller Reginald fuller 594032 594032 Fuller, Reginald, of Narford, fuller 1
4738364 2277095 2277095 defendant Cressyngham John husbandman 594032 594032 Cressyngham, John, of Narford, husbandman 0
4763588 2284596 2284596 defendant Smyth Walter yeoman 594032 594032 Smyth, Walter, of Narford, yeoman 0
4880632 2320851 2320851 defendant atte Croft Nicholas yeoman 594032 594032 atte Croft, Nicholas, of Narford, yeoman 0
4924133 2333990 2333990 defendant Dynghill John   594032 594032 Dynghill, John, of Narford, shepherd 0
4959932 2344932 2344932 defendant Chapman John laborer 594032 594032 Chapman, John, of Narford, laborer 0
4972123 2348602 2348602 defendant Broun Lawrence husbandman 594032 594032 Broun, Lawrence, of Narford, husbandman 0
5030371 2365756 2365756 defendant Deyne William miller 594032 594032 Deyne, William, of Narford, miller 2
5047710 2370932 2370932 defendant Joye Robert   594032 594032 Joye, Robert, of Narford, plough wright 1
5051944 2372194 2372194 defendant Clerk Thomas husbandman 594032 594032 Clerk, Thomas, of Narford, husbandman 0
5060960 2374849 2374849 defendant Thede Giles husbandman 594032 594032 Thede, Giles, of Narford, husbandman 0
5107816 2388720 2388720 defendant Oldeman John laborer 594032 594032 Oldeman, John, of Narford, laborer 0
5137104 2397365 2397365 defendant Joye Robert husbandman 594032 594032 Joye, Robert, of Narford, husbandman 1
5157728 2403389 2403389 defendant Joye Robert husbandman 594032 594032 Joye, Robert, of Narford, husbandman 1
5234414 2425655 2425655 defendant Croft Walter husbandman 594032 594032 Croft, Walter, of Narford, husbandman 0
5234415 2425655 2425655 defendant Curteys Thomas husbandman 594032 594032 Curteys, Thomas, of Narford, husbandman 1
5234419 2425657 2425657 defendant Croft Walter husbandman 594032 594032 Croft, Walter, of Narford, husbandman 0
5234420 2425657 2425657 defendant Curteys Thomas husbandman 594032 594032 Curteys, Thomas, of Narford, husbandman 1
5234425 2425659 2425659 defendant Croft Walter husbandman 594032 594032 Croft, Walter, of Narford, husbandman 0
5234426 2425659 2425659 defendant Curteys Thomas husbandman 594032 594032 Curteys, Thomas, of Narford, husbandman 1
5262562 2434033 2434033 defendant Clerk John (legal representative) 594032 594032 Clerk, John, of Narford, husbandman, executor of 2
5262563 2434033 2434033 defendant Joye William husbandman 594032 594032 Joye, William, of Narford, husbandman 3
5267253 2435519 2435519 defendant Dyngyll John husbandman 594032 594032 Dyngyll, John, of Narford, husbandman 0
5356993 2462249 2462249 defendant Gerard Richard husbandman 594032 594032 Gerard, Richard, of Narford, husbandman 1
5490502 2502052 2502052 defendant Myte John, junior husbandman 594032 594032 Myte, John, junior, of Narford, husbandman 2
5506941 2507086 2507086 defendant Frost William yeoman 594032 594032 Frost, William, of Narford, yeoman 0
5530279 2513979 2513979 defendant Crofte Walter yeoman 594032 594032 Crofte, Walter, of Narford, yeoman 1

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);