names

32 rows where place_id = 624096

✎ 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
3756116 1943870 1943870 defendant Wythe William   624096 624096 Wythe, William, of Aylsham, worsted weaver 2
3756117 1943870 1943870 defendant Hoberd William scrivener 624096 624096 Hoberd, William, of Aylsham, scrivener 3
3826551 1966152 1966152 defendant Mihell John carpenter 624096 624096 Mihell, John, of Aylsham, carpenter 0
3826552 1966152 1966152 defendant Alborough John fuller 624096 624096 Alborough, John, of Aylsham, fuller 1
3857073 1975845 1975845 defendant Chosyll Edward butcher 624096 624096 Chosyll, Edward, of Aylsham, butcher 1
3943230 2004756 2004756 plaintiff Aleyn John   624096 624096 Aleyn, John, of Aylsham, servant to Thomas Woddhowe, knight 0
3963600 2011880 2011880 plaintiff Abbes Nicholas tailor 624096 624096 Abbes, Nicholas, of Aylsham, tailor 0
3979716 2017499 2017499 plaintiff Orwell Thomas   624096 624096 Orwell, Thomas, of Aylsham 0
3984213 2019121 2019121 defendant Clarke William husbandman 624096 624096 Clarke, William, of Aylsham, husbandman 1
4021510 2032420 2032420 defendant Woodwarde John yeoman 624096 624096 Woodwarde, John, of Aylsham, yeoman 2
4074156 2051054 2051054 defendant Callowe Clement tailor 624096 624096 Callowe, Clement, of Aylsham, tailor 0
4116877 2066333 2066333 defendant Hawnde Gregory   624096 624096 Hawnde, Gregory, of Aylsham, worsted weaver 0
4164139 2082983 2082983 defendant Towting John yeoman 624096 624096 Towting, John, of Aylsham, yeoman 1
4170658 2085237 2085237 defendant Davys William   624096 624096 Davys, William, of Aylsham, Norf yeoman 0
4283737 2124223 2124223 defendant Burwaygh Clement   624096 624096 Burwaygh, Clement, of Aylsham, worsted weaver 0
4283857 2124265 2124265 defendant Downes Robert gent 624096 624096 Downes, Robert, of Aylsham, gent 1
4394849 2162863 2162863 defendant Gynn Hugh gent 624096 624096 Gynn, Hugh, of Aylsham, gent 3
4396646 2163442 2163442 defendant Burway Clement   624096 624096 Burway, Clement, of Aylsham, yeoman, worsted weaver 2
4470085 2191294 2191294 defendant Portlond Alan   624096 624096 Portlond, Alan, of Aylsham 0
4547833 2215260 2215260 defendant Stokes Nicholas   624096 624096 Stokes, Nicholas, of Aylsham, vicar 2
4563426 2220132 2220132 defendant Page alias Traton Gregory   624096 624096 Page alias Traton, Gregory, of Aylsham 1
4599124 2230940 2230940 defendant Cook Nicholas   624096 624096 Cook, Nicholas, of Aylsham, vicar 0
4630286 2240382 2240382 defendant Stok Nicholas   624096 624096 Stok, Nicholas, of Aylsham, vicar 0
4666039 2250849 2250849 defendant Hegge John yeoman 624096 624096 Hegge, John, of Aylsham, yeoman 5
4887231 2322846 2322846 defendant Dawebeneye Simon husbandman 624096 624096 Dawebeneye, Simon, of Aylsham, husbandman 0
5024053 2363945 2363945 defendant Ponyaunt or Povyaunt William yeoman 624096 624096 Ponyaunt or Povyaunt, William, of Aylsham, yeoman 1
5033708 2366735 2366735 defendant Pyrt John yeoman 624096 624096 Pyrt, John, of Aylsham, yeoman 6
5120093 2392315 2392315 defendant Cony John husbandman 624096 624096 Cony, John, of Aylsham, husbandman 0
5350343 2460229 2460229 plaintiff Collet John   624096 624096 Collet, John, of Aylsham 0
5421874 2481480 2481480 defendant Basse John smith 624096 624096 Basse, John, of Aylsham, smith 0
5425968 2482724 2482724 defendant Basse John smith 624096 624096 Basse, John, of Aylsham, smith 0
5496120 2503737 2503737 plaintiff Howard Richard baker 624096 624096 Howard, Richard, of Aylsham, baker 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);