names

47 rows where place_id = 755996

✎ 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
4433304 2175170 2175170 defendant Mogge John merchant 755996 755996 Mogge, John, of Wroxhale, merchant 0
4444597 2183286 2183286 plaintiff Cole John merchant 755996 755996 Cole, John, of Wroxhale, merchant 0
4445857 2183647 2183647 defendant Waleys John   755996 755996 Waleys, John, of Wroxhale 0
4487416 2196774 2196774 defendant Neuman John   755996 755996 Neuman, John, of Wroxhale 0
4504383 2201922 2201922 defendant Shothowe Robert   755996 755996 Shothowe, Robert, of Wroxhale 1
4550282 2216034 2216034 defendant Mayhewe John   755996 755996 Mayhewe, John, of Wroxhale 1
4551623 2216451 2216451 defendant Foulour Pepter   755996 755996 Foulour, Pepter, of Wroxhale 0
4598380 2230732 2230732 defendant Berall John   755996 755996 Berall, John, of Wroxhale 0
4680558 2259532 2259532 defendant Druet Thomas husbandman 755996 755996 Druet, Thomas, of Wroxhale, husbandman 0
4680559 2259532 2259532 defendant Bryght John clerk 755996 755996 Bryght, John, of Wroxhale, clerk 1
4680560 2259532 2259532 defendant Anesteys John husbandman 755996 755996 Anesteys, John, of Wroxhale, husbandman 2
4687604 2261708 2261708 defendant Phelip John husbandman 755996 755996 Phelip, John, of Wroxhale, husbandman, husbandman 1
4687605 2261708 2261708 defendant James Richard husbandman 755996 755996 James, Richard, of Wroxhale, husbandman 2
4698531 2265013 2265013 defendant Saundres John husbandman 755996 755996 Saundres, John, of Wroxhale, husbandman 1
4713317 2269491 2269491 defendant White John husbandman 755996 755996 White, John, of Wroxhale, husbandman 0
4713318 2269491 2269491 defendant Phelip John husbandman 755996 755996 Phelip, John, of Wroxhale, husbandman 1
4713319 2269491 2269491 defendant Innes Richard husbandman 755996 755996 Innes, Richard, of Wroxhale, husbandman 2
4718065 2270991 2270991 defendant Bryght John clerk 755996 755996 Bryght, John, of Wroxhale, clerk 0
4751911 2281052 2281052 plaintiff Clerk Walter   755996 755996 Clerk, Walter, of Wroxhale 3
4806620 2298280 2298280 defendant William John husbandman 755996 755996 William, John, of Wroxhale, husbandman 0
4824846 2303808 2303808 defendant Stoky Thomas yeoman 755996 755996 Stoky, Thomas, of Wroxhale, yeoman 1
4834144 2306687 2306687 defendant Gorges Theobald   755996 755996 Gorges, Theobald, of Wroxhale, knight, formerly esquire 0
4847302 2310658 2310658 defendant Gorges Theobald   755996 755996 Gorges, Theobald, of Wroxhale, knight, lord of Wroxhale 0
4875039 2319142 2319142 defendant Gorges Theobald   755996 755996 Gorges, Theobald, of Wroxhale, knight 0
4913573 2330742 2330742 defendant Baly John fuller 755996 755996 Baly, John, of Wroxhale, fuller 0
4943812 2340028 2340028 defendant Lake Thomas laborer 755996 755996 Lake, Thomas, of Wroxhale, laborer 9
5028341 2365170 2365170 defendant Dodesham Richard laborer 755996 755996 Dodesham, Richard, of Wroxhale, laborer 0
5028350 2365174 2365174 defendant Tynte William yeoman 755996 755996 Tynte, William, of Wroxhale, yeoman 0
5055981 2373360 2373360 defendant Gorges Theobald   755996 755996 Gorges, Theobald, of Wroxhale, knight 0
5057971 2373957 2373957 defendant Pegeon Thomas   755996 755996 Pegeon, Thomas, of Wroxhale, mason, Shakspere, Ralph, of Wroxhale, mason 3
5077311 2379715 2379715 defendant Hukyns Thomas, junior   755996 755996 Hukyns, Thomas, junior, of Wroxhale, mason 1
5077313 2379715 2379715 defendant Eboralde Robert husandman 755996 755996 Eboralde, Robert, of Wroxhale, husandman 3
5112267 2389970 2389970 defendant Yevan Richard yeoman 755996 755996 Yevan, Richard, of Wroxhale, yeoman 0
5113221 2390260 2390260 defendant Bradnoke Robert tailor 755996 755996 Bradnoke, Robert, of Wroxhale, tailor 0
5122878 2393124 2393124 defendant Dowell John husbandman 755996 755996 Dowell, John, of Wroxhale, husbandman 0
5123470 2393314 2393314 defendant Shirwyn Thomas husbandman 755996 755996 Shirwyn, Thomas, of Wroxhale, husbandman 0
5123472 2393315 2393315 defendant Shirwyn Thomas husbandman 755996 755996 Shirwyn, Thomas, of Wroxhale, husbandman 0
5126414 2394200 2394200 defendant Croke (illegible) husbandman 755996 755996 Croke, ---, of Wroxhale, husbandman 1
5133344 2396243 2396243 defendant Cokes Roger husbandman 755996 755996 Cokes, Roger, of Wroxhale, husbandman 0
5133345 2396243 2396243 defendant Ive William husbandman 755996 755996 Ive, William, of Wroxhale, husbandman 1
5133346 2396243 2396243 defendant Lok Thomas husbandman 755996 755996 Lok, Thomas, of Wroxhale, husbandman 2
5202184 2416401 2416401 defendant Croke John husbandman 755996 755996 Croke, John, of Wroxhale, husbandman 1
5306382 2446892 2446892 defendant Foxland (illegible) gent 755996 755996 Foxland, _, of Wroxhale, gent 0
5313373 2449040 2449040 defendant Bendale John husbandman 755996 755996 Bendale, John, of Wroxhale, husbandman 0
5404255 2476294 2476294 defendant Nyter John gent 755996 755996 Nyter, John, of Wroxhale, gent 0
5417385 2480119 2480119 defendant Nyter John gent 755996 755996 Nyter, John, of Wroxhale, gent 0
5434732 2485324 2485324 defendant Niyter John gent 755996 755996 Niyter, John, of Wroxhale, gent 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);