names

43 rows where place_id = 587174

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590658 1864721 1864721 defendant Fryman John baker 587174 587174 Fryman, John, of Bryghtlyng, baker 0
3591248 1864889 1864889 defendant Croche Simon husbandman 587174 587174 Croche, Simon, of Bryghtlyng, husbandman 0
3591249 1864889 1864889 defendant Erle John husbandman 587174 587174 Erle, John, of Bryghtlyng, husbandman 1
3734721 1937107 1937107 defendant Erle Thomas laborer 587174 587174 Erle, Thomas, of Bryghtlyng, laborer 0
3734722 1937107 1937107 defendant Hawkyn Simon miller 587174 587174 Hawkyn, Simon, of Bryghtlyng, miller 1
3775149 1949961 1949961 defendant Harvy David   587174 587174 Harvy, David, of Bryghtlyng 0
3789852 1954653 1954653 defendant Browne John husbandman 587174 587174 Browne, John, of Bryghtlyng, husbandman 1
3802957 1958822 1958822 defendant Downe John husbandman 587174 587174 Downe, John, of Bryghtlyng, husbandman 1
3823610 1965282 1965282 defendant Broun John husbandman 587174 587174 Broun, John, of Bryghtlyng, husbandman 1
3887234 1985998 1985998 defendant Garrard Anthony collier 587174 587174 Garrard, Anthony, of Bryghtlyng, collier 0
3887235 1985998 1985998 defendant Gewe John collier 587174 587174 Gewe, John, of Bryghtlyng, collier 1
3887236 1985998 1985998 defendant Golthere John collier 587174 587174 Golthere, John, of Bryghtlyng, collier 2
3887237 1985998 1985998 defendant Deson Thomas collier 587174 587174 Deson, Thomas, of Bryghtlyng, collier 3
3887238 1985998 1985998 defendant Blewette Thomas collier 587174 587174 Blewette, Thomas, of Bryghtlyng, collier 4
3961611 2011161 2011161 defendant May George gent 587174 587174 May, George, of Bryghtlyng, gent 2
3985370 2019526 2019526 defendant Rabbett Stephen   587174 587174 Rabbett, Stephen, of Bryghtlyng husbandman 1
4095225 2058614 2058614 defendant Whyte Isaac laborer 587174 587174 Whyte, Isaac, of Bryghtlyng, laborer 3
4097613 2059473 2059473 defendant Alye John yeoman 587174 587174 Alye, John, of Bryghtlyng, yeoman 1
4165058 2083285 2083285 defendant Carpenter Richard husbandman 587174 587174 Carpenter, Richard, of Bryghtlyng, husbandman 0
4170789 2085274 2085274 defendant Alye John yeoman 587174 587174 Alye, John, of Bryghtlyng, yeoman 0
4170790 2085274 2085274 defendant Jones Robert clerk 587174 587174 Jones, Robert, of Bryghtlyng, clerk 1
4186282 2090687 2090687 defendant Jones Robert clerk 587174 587174 Jones, Robert, of Bryghtlyng, clerk 0
4795582 2294770 2294770 defendant Odyk Richard laborer 587174 587174 Odyk, Richard, of Bryghtlyng, laborer 1
4854944 2312900 2312900 defendant Borden Thomas tailor 587174 587174 Borden, Thomas, of Bryghtlyng, tailor 0
4925366 2334368 2334368 defendant Kenne John laborer 587174 587174 Kenne, John, of Bryghtlyng, laborer 0
4986254 2352817 2352817 defendant Wodelond John laborer 587174 587174 Wodelond, John, of Bryghtlyng, laborer 2
4986255 2352817 2352817 defendant Poweke Henry laborer 587174 587174 Poweke, Henry, of Bryghtlyng, laborer 3
4986262 2352819 2352819 defendant Wodelond John laborer 587174 587174 Wodelond, John, of Bryghtlyng, laborer 1
4986263 2352819 2352819 defendant Poweke Henry laborer 587174 587174 Poweke, Henry, of Bryghtlyng, laborer 2
5003719 2357980 2357980 defendant Crothole Stephen husbandman 587174 587174 Crothole, Stephen, of Bryghtlyng, husbandman 0
5003720 2357980 2357980 defendant Twyford Thomas husbandman 587174 587174 Twyford, Thomas, of Bryghtlyng, husbandman 1
5092649 2384229 2384229 defendant Meryfeld William husbandman 587174 587174 Meryfeld, William, of Bryghtlyng, husbandman 0
5108080 2388803 2388803 defendant M- John smith 587174 587174 M-, John, of Bryghtlyng, smith 1
5108081 2388803 2388803 defendant Crothole John thatcher 587174 587174 Crothole, John, of Bryghtlyng, thatcher 2
5109186 2389111 2389111 defendant Prest Richard husbandman 587174 587174 Prest, Richard, of Bryghtlyng, husbandman 0
5383646 2470406 2470406 defendant Water Thomas carpenter 587174 587174 Water, Thomas, of Bryghtlyng, carpenter 1
5408771 2477581 2477581 defendant Walter Thomas carpenter 587174 587174 Walter, Thomas, of Bryghtlyng, carpenter 1
5454564 2491279 2491279 defendant Walier Thomas carpenter 587174 587174 Walier, Thomas, of Bryghtlyng, carpenter 1
5496723 2503941 2503941 defendant Erle Stephen husbandman 587174 587174 Erle, Stephen, of Bryghtlyng, husbandman 0
5578248 2528265 2528265 defendant Kymber William choemaker 587174 587174 Kymber, William, of Bryghtlyng, choemaker 0
5588751 2531493 2531493 defendant Smalfeld John husbandman 587174 587174 Smalfeld, John, of Bryghtlyng, husbandman 0
5593706 2533020 2533020 defendant Hepthen Elizabeth widow 587174 587174 Hepthen, Elizabeth, of Bryghtlyng, widow 0
5593707 2533020 2533020 defendant Hepthen Thomas husbandman 587174 587174 Hepthen, Thomas, of Bryghtlyng, husbandman 1

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