names

42 rows where place_id = 592081

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3606494 1869704 1869704 defendant Leveley or Leneley Robert husbandman 592081 592081 Leveley or Leneley, Robert, of Remmesbury, husbandman 1
4447879 2184262 2184262 defendant Louf John   592081 592081 Louf, John, of Remmesbury 0
4566640 2221138 2221138 defendant Milleward Richard   592081 592081 Milleward, Richard, of Remmesbury 0
4570575 2222371 2222371 defendant Mulle John   592081 592081 Mulle, John, of Remmesbury 0
4570577 2222372 2222372 defendant Mulle John   592081 592081 Mulle, John, of Remmesbury 0
4578034 2224635 2224635 plaintiff Cherleford John   592081 592081 Cherleford, John, of Remmesbury 0
4587160 2227389 2227389 defendant Milward Richard   592081 592081 Milward, Richard, of Remmesbury 0
4587162 2227389 2227389 defendant Clerk John   592081 592081 Clerk, John, of Remmesbury, son of Henry 2
4589633 2228126 2228126 defendant Kene alias Creydon Richard   592081 592081 Kene alias Creydon, Richard, of Remmesbury 0
4653774 2247096 2247096 defendant Quacche William laborer 592081 592081 Quacche, William, of Remmesbury, laborer 10
4696183 2264286 2264286 defendant Shepherd Stephen laborer 592081 592081 Shepherd, Stephen, of Remmesbury, laborer 5
4696995 2264537 2264537 defendant Milleward Richard husbandman 592081 592081 Milleward, Richard, of Remmesbury, husbandman 0
4739040 2277302 2277302 defendant Treweman Giles husbandman 592081 592081 Treweman, Giles, of Remmesbury, husbandman 0
4746052 2279346 2279346 defendant Mildenale Richard husbandman 592081 592081 Mildenale, Richard, of Remmesbury, husbandman 0
4746053 2279346 2279346 defendant Eweyn William husabndman 592081 592081 Eweyn, William, of Remmesbury, husabndman 1
4746054 2279346 2279346 defendant Milward John   592081 592081 Milward, John, of Remmesbury, milward 2
4754193 2281691 2281691 plaintiff Wotton Nicholas   592081 592081 Wotton, Nicholas, of Remmesbury, on his own account 0
4757850 2282833 2282833 defendant Eweyn Thomas husbandman 592081 592081 Eweyn, Thomas, of Remmesbury, husbandman 0
4769188 2286340 2286340 defendant Treweman Giles husbandman 592081 592081 Treweman, Giles, of Remmesbury, husbandman 0
4775622 2288370 2288370 defendant Eweyn Thomas husbandman 592081 592081 Eweyn, Thomas, of Remmesbury, husbandman 0
4775624 2288371 2288371 defendant Treweman Giles husbandman 592081 592081 Treweman, Giles, of Remmesbury, husbandman 0
4775625 2288371 2288371 defendant Benet Thomas husbandman 592081 592081 Benet, Thomas, of Remmesbury, husbandman 1
4775626 2288371 2288371 defendant Venant Richard husbandman 592081 592081 Venant, Richard, of Remmesbury, husbandman 2
4775627 2288371 2288371 defendant Milward John husbandman 592081 592081 Milward, John, of Remmesbury, husbandman 3
4775629 2288372 2288372 plaintiff Wotton Nicholas   592081 592081 Wotton, Nicholas, of Remmesbury 0
4793693 2294141 2294141 defendant Treweman Giles husbandman 592081 592081 Treweman, Giles, of Remmesbury, husbandman 0
4801519 2296656 2296656 defendant Eweyn Thomas husbandman 592081 592081 Eweyn, Thomas, of Remmesbury, husbandman 0
4802454 2296958 2296958 defendant Sonpul or Soupull William   592081 592081 Sonpul or Soupull, William, of Remmesbury 0
4881458 2321104 2321104 defendant Mulle Nicholas husbandman 592081 592081 Mulle, Nicholas, of Remmesbury, husbandman 0
4934295 2337113 2337113 defendant Wotton Nicholas gent 592081 592081 Wotton, Nicholas, of Remmesbury, gent 0
4994633 2355253 2355253 defendant Mildenale John husbandman 592081 592081 Mildenale, John, of Remmesbury, husbandman 0
4996152 2355707 2355707 defendant Milward Thomas husbandman 592081 592081 Milward, Thomas, of Remmesbury, husbandman 0
5019317 2362539 2362539 defendant Wotton Nicholas gent 592081 592081 Wotton, Nicholas, of Remmesbury, gent 0
5053721 2372712 2372712 defendant Brounyng Henry chaplain 592081 592081 Brounyng, Henry, of Remmesbury, chaplain 0
5223482 2422559 2422559 defendant Godale Thomas laborer 592081 592081 Godale, Thomas, of Remmesbury, laborer 1
5223483 2422559 2422559 defendant Collys John laborer 592081 592081 Collys, John, of Remmesbury, laborer 2
5223484 2422559 2422559 defendant Mildenhale Nicholas laborer 592081 592081 Mildenhale, Nicholas, of Remmesbury, laborer 3
5359536 2463016 2463016 defendant Yorke John esq 592081 592081 Yorke, John, of remmesbury, esq 0
5622089 2550820 2550820 defendant Tabetter John   592081 592081 Tabetter, John, of Remmesbury 1
5622091 2550821 2550821 defendant Tabletter John   592081 592081 Tabletter, John, of Remmesbury 0
5636258 2555299 2555299 defendant Charlese John husbandman 592081 592081 Charlese, John, of Remmesbury, husbandman 0
5636294 2555308 2555308 defendant Veyn Thomas ploughman 592081 592081 Veyn, Thomas, of Remmesbury, ploughman 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);