names

53 rows where place_id = 682794

✎ 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
4051179 2042859 2042859 defendant Barvell Nicholas husbandman 682794 682794 Barvell, Nicholas, of Middleton, husbandman 2
4064034 2047419 2047419 plaintiff Grene Richard yeoman 682794 682794 Grene, Richard, of Middleton, yeoman 0
4069250 2049290 2049290 defendant Barvell Robert, senior husbandman 682794 682794 Barvell, Robert, senior, of Middleton, husbandman 0
4073361 2050763 2050763 plaintiff Phipps William yeoman 682794 682794 Phipps, William, of Middleton, yeoman 0
4088682 2056253 2056253 defendant Middleton Christopher chapman 682794 682794 Middleton, Christopher, of Middleton, chapman 1
4095598 2058753 2058753 defendant Goodyth Richard husbandman 682794 682794 Goodyth, Richard, of Middleton, husbandman 0
4150608 2078346 2078346 defendant Tomlynson George yeoman 682794 682794 Tomlynson, George, of Middleton, or of Yowgrive, Derbs, yeoman 0
4154458 2079651 2079651 defendant Cocke John yeoman 682794 682794 Cocke, John, of Middleton, yeoman 4
4158782 2081146 2081146 defendant Browne alias Synger Thomas yeoman 682794 682794 Browne alias Synger, Thomas, of Middleton, yeoman 0
4211275 2099496 2099496 defendant Hill Henry cooper 682794 682794 Hill, Henry, of Middleton, cooper 0
4214503 2100582 2100582 defendant Flight Edward yeoman 682794 682794 Flight, Edward, of Middleton, yeoman 3
4221330 2102958 2102958 defendant Gyll Humphrey   682794 682794 (Gyll, Humphrey, of Middleton, wheelwright 1
4240080 2109655 2109655 defendant Moore Edward chapman 682794 682794 Moore, Edward, of Middleton, chapman 1
4250450 2113135 2113135 defendant Nowell William yeoman 682794 682794 Nowell, William, of Middleton, yeoman 1
4254277 2114431 2114431 defendant Melton Robert   682794 682794 Melton, Robert, of Middleton, shepherd 1
4254278 2114431 2114431 defendant Tompson Thomas husbandman 682794 682794 Tompson, Thomas, of Middleton, husbandman 2
4254281 2114432 2114432 defendant Russell Peter husbandman 682794 682794 Russell, Peter, of Middleton, husbandman 0
4254282 2114432 2114432 defendant Rolfe Edmund husbandman 682794 682794 Rolfe, Edmund, of Middleton, husbandman 1
4254724 2114573 2114573 defendant Ridding Richard chapman 682794 682794 Ridding, Richard, of Middleton, yeoman, chapman 0
4254725 2114573 2114573 defendant Hodgson Robert husbandman 682794 682794 Hodgson, Robert, of Middleton, husbandman 1
4254727 2114574 2114574 defendant Ridding Richard chapman 682794 682794 Ridding, Richard, of Middleton, yeoman, chapman 0
4254728 2114574 2114574 defendant Hodgson Robert husbandman 682794 682794 Hodgson, Robert, of Middleton, husbandman 1
4260489 2116475 2116475 defendant Baynes Robert shoemaker 682794 682794 Baynes, Robert, of Middleton, shoemaker 3
4262760 2117213 2117213 defendant More Edward chapman 682794 682794 More, Edward, of Middleton, chapman 1
4264157 2117663 2117663 defendant Barvell Robert (legal representative) 682794 682794 Barvell, Robert, of Middleton, husbandman, executors of 0
4266951 2118588 2118588 defendant Lee Thomas gent 682794 682794 Lee, Thomas, of Middleton, gent 2
4283417 2124105 2124105 defendant Burley Philip yeoman 682794 682794 Burley, Philip, of Middleton, yeoman 0
4283418 2124105 2124105 defendant Mansill John husbandman 682794 682794 Mansill, John, of Middleton, husbandman 1
4286930 2125379 2125379 defendant Knyght John yeoman 682794 682794 Knyght, John, of Middleton, yeoman 0
4287047 2125420 2125420 defendant Hill Thomas gent 682794 682794 Hill, Thomas, of Middleton, gent 0
4292061 2127235 2127235 defendant Burley Philip yeoman 682794 682794 Burley, Philip, of Middleton, yeoman 0
4292062 2127235 2127235 defendant Mansill John yeoman 682794 682794 Mansill, John, of Middleton, yeoman 1
4302374 2130951 2130951 defendant Amye William yeoman 682794 682794 Amye, William, of Middleton, yeoman 1
4322327 2137882 2137882 defendant Middleton Richard clerk 682794 682794 Middleton, Richard, of Middleton, clerk 1
4325561 2138923 2138923 defendant Smythe Richard yeoman 682794 682794 Smythe, Richard, of Middleton, yeoman 2
4350145 2147308 2147308 defendant Tiror John yeoman 682794 682794 Tiror, John, of Middleton, yeoman 1
4353170 2148336 2148336 defendant Skarfe William husbandman 682794 682794 Skarfe, William, of Middleton, husbandman 3
4368984 2153970 2153970 defendant Foxe Geoffrey gent 682794 682794 Foxe, Geoffrey, of Middleton, gent 0
4373232 2155494 2155494 defendant Marsengale Thomas carpenter 682794 682794 Marsengale, Thomas,of Middleton, carpenter 0
4375274 2156211 2156211 defendant Reye William yeoman 682794 682794 Reye, William, of Middleton, yeoman 0
4380099 2157986 2157986 defendant Tyrer John yeoman 682794 682794 Tyrer, John, of Middleton, yeoman 0
4380100 2157986 2157986 defendant Goodere Francis yeoman 682794 682794 Goodere, Francis, of Middleton, yeoman 1
4392235 2162028 2162028 defendant Bartlett Thomas yeoman 682794 682794 Bartlett, Thomas, of Middleton, yeoman 0
4393561 2162449 2162449 defendant Hallam John husbandman 682794 682794 Hallam, John, of Middleton, husbandman 0
4394447 2162740 2162740 defendant Welles Edmund clerk 682794 682794 Welles, Edmund, of Middleton, clerk 0
4396059 2163258 2163258 defendant Elwood Thomas gent 682794 682794 Elwood, Thomas, of Middleton, gent 2
4399129 2164293 2164293 defendant Wriglesworth Thomas yeoman 682794 682794 Wriglesworth, Thomas, of Middleton, yeoman 0
4433120 2175111 2175111 defendant Warde Thomas   682794 682794 Warde, Thomas, of Middleton 0
4814442 2300624 2300624 defendant Smyth Thomas husbandman 682794 682794 Smyth, Thomas, of Middleton, husbandman 2
4846909 2310542 2310542 defendant Haybergh William yeoman 682794 682794 Haybergh, William, of Middleton, yeoman 0
4846910 2310542 2310542 defendant Haybergh Edmund yeoman 682794 682794 Haybergh, Edmund, of Middleton, yeoman 1
5141789 2398713 2398713 defendant Heryng Robert clerk 682794 682794 Heryng, Robert, of Middleton, clerk 0
5195427 2414413 2414413 plaintiff Sale William (legal representative) 682794 682794 Sale, William, of Middleton, executors of 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);