names

39 rows where place_id = 627579

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3777107 1950589 1950589 defendant Hastard Matthew yeoman 627579 627579 Hastard, Matthew, of Prees, yeoman 1
3928390 1999832 1999832 defendant Pace John yeoman 627579 627579 Pace, John, of Prees, yeoman 6
4008793 2027905 2027905 defendant Castre George laborer 627579 627579 Castre, George, of Prees, laborer 1
4053599 2043660 2043660 defendant Harryson William shoemaker 627579 627579 Harryson, William, of Prees, shoemaker 1
4076896 2052024 2052024 defendant Tagg John husbandman 627579 627579 Tagg, John, of Prees, husbandman 0
4076898 2052024 2052024 defendant Harry or Harryes John husbandman 627579 627579 Harry or Harryes, John, of Prees, husbandman 2
4076997 2052055 2052055 defendant Cole George chapman 627579 627579 Cole, George, of Prees, chapman 2
4329795 2140262 2140262 defendant Harryson John butcher 627579 627579 Harryson, John, of Prees, butcher 0
4329796 2140262 2140262 defendant Cole Peter butcher 627579 627579 Cole, Peter, of Prees, butcher 1
4329864 2140290 2140290 defendant Kilbart or Kilvart Roger yeoman 627579 627579 Kilbart or Kilvart, Roger, of Prees, yeoman 0
4329865 2140290 2140290 defendant Tayler Roger yeoman 627579 627579 Tayler, Roger, of Prees, yeoman 1
4329866 2140290 2140290 defendant Pace Richard yeoman 627579 627579 Pace Richard, of Prees, yeoman 2
4329867 2140290 2140290 defendant Sergeant John yeoman 627579 627579 Sergeant, John, of Prees, yeoman 3
4329869 2140291 2140291 defendant Overton Thomas yeoman 627579 627579 Overton, Thomas, of Prees, yeoman 0
4329870 2140291 2140291 defendant Cowley Peter yeoman 627579 627579 Cowley, Peter, of Prees, yeoman 1
4329871 2140291 2140291 defendant Roe Hugh yeoman 627579 627579 Roe, Hugh, of Prees, yeoman 2
4329872 2140291 2140291 defendant Syngler Thomas yeoman 627579 627579 Syngler, Thomas, of Prees, yeoman 3
4335879 2142278 2142278 defendant Sarjant Hugh yeoman 627579 627579 Sarjant, Hugh, of Prees, yeoman 1
4341038 2144141 2144141 defendant Taylor George   627579 627579 Taylor, George, of Prees, button maker 1
4341039 2144141 2144141 defendant Taylor Roger husbandman 627579 627579 Taylor, Roger, of Prees, husbandman 2
4345969 2145852 2145852 defendant Sheppard Edward yeoman 627579 627579 Sheppard, Edward, of Prees, yeoman 0
4348508 2146730 2146730 defendant Brayne William yeoman 627579 627579 Brayne, William, of Prees, yeoman 0
4348509 2146730 2146730 defendant Hitchyn George yeoman 627579 627579 Hitchyn, George, of Prees, yeoman 1
4348510 2146730 2146730 defendant Pecocke William yeoman 627579 627579 Pecocke, William, of Prees, yeoman 2
4355399 2149112 2149112 defendant Harwood Francis husbandman 627579 627579 Harwood, Francis, of Prees, husbandman 1
4473114 2192255 2192255 defendant Mason Henry   627579 627579 Mason, Henry, of Prees 6
4473124 2192255 2192255 defendant Hayward Richard   627579 627579 Hayward, Richard, of Prees 16
4663836 2250173 2250173 plaintiff Grene John   627579 627579 Grene, John, of Prees 0
4691205 2262770 2262770 defendant Corley William   627579 627579 Corley, William, of Prees, vicar 1
4756502 2282400 2282400 defendant Scot Richard yeoman 627579 627579 Scot, Richard, of Prees, yeoman 4
4762411 2284229 2284229 defendant Cornle William   627579 627579 Cornle, William, of Prees, vicar 2
4762412 2284229 2284229 defendant Coke Richard husbandman 627579 627579 Coke, Richard, of Prees, husbandman 3
4788771 2292546 2292546 defendant Barker John yeoman 627579 627579 Barker, John, of Prees, yeoman 0
4788773 2292547 2292547 defendant Crowe John smith 627579 627579 Crowe, John, of Prees, smith 0
4813440 2300316 2300316 defendant Wotnell Nicholas husbandman 627579 627579 Wotnell, Nicholas, of Prees, husbandman 0
4922032 2333302 2333302 defendant Coton William esq 627579 627579 Coton, William, of Prees, esq 0
4922033 2333302 2333302 defendant Gamull John husbandman 627579 627579 Gamull, John, of Prees, husbandman 1
4922034 2333302 2333302 defendant Seriant William husbandman 627579 627579 Seriant, William, of Prees, husbandman 2
5099946 2386421 2386421 defendant Shirewod William yeoman 627579 627579 Shirewod, William, of Prees, yeoman 2

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