names

71 rows where place_id = 598490

✎ 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
3632748 1905056 1905056 defendant Lambard William husbandman 598490 598490 Lambard, William, of Wode Norton, husbandman 0
3689612 1922911 1922911 defendant Harryson Thomas husbandman 598490 598490 Harryson, Thomas, of Wode Norton, husbandman 0
3724349 1933903 1933903 defendant Skynner John butcher 598490 598490 Skynner, John, of Wode Norton, butcher 0
3857978 1976142 1976142 defendant Holley Andrew husbandman 598490 598490 Holley, Andrew, of Wode Norton, husbandman 0
4440795 2182038 2182038 defendant Gyn Nicholas   598490 598490 Gyn, Nicholas, of Wode Norton 0
4440797 2182039 2182039 defendant Byn Nicholas   598490 598490 Byn, Nicholas, of Wode Norton 0
4559261 2218850 2218850 defendant Baxtere Thomas   598490 598490 Baxtere, Thomas, of Wode Norton 1
4559262 2218850 2218850 defendant Taillour Thomas   598490 598490 Taillour, Thomas, of Wode Norton 2
4559263 2218850 2218850 defendant Fullere Thomas   598490 598490 Fullere, Thomas, of Wode Norton 3
4559269 2218852 2218852 defendant Makhayt Simon   598490 598490 Makhayt, Simon, of Wode Norton 0
4559270 2218852 2218852 defendant Baxtere Thomas   598490 598490 Baxtere, Thomas, of Wode Norton 1
4559271 2218852 2218852 defendant Taillor Thomas   598490 598490 Taillor, Thomas, of Wode Norton 2
4559272 2218852 2218852 defendant Fullere Thomas   598490 598490 Fullere, Thomas, of Wode Norton 3
4590268 2228326 2228326 defendant Julery Thomas   598490 598490 Julery, Thomas, of Wode Norton 5
4590389 2228353 2228353 defendant Baxtere Thomas   598490 598490 Baxtere, Thomas, of Wode Norton 0
4601811 2231787 2231787 defendant Bulmen Lawrence   598490 598490 Bulmen, Lawrence, of Wode Norton 1
4601812 2231787 2231787 defendant Bulman John   598490 598490 Bulman, John, of Wode Norton 2
4671035 2256609 2256609 defendant bulman John yeoman 598490 598490 bulman, John, of Wode Norton, yeoman 4
4681484 2259824 2259824 defendant Rye Simon yeoman 598490 598490 Rye, Simon, of Wode Norton, yeoman 1
4709380 2268286 2268286 defendant Gebon William husbandman 598490 598490 Gebon, William, of Wode Norton, husbandman 0
4726187 2273473 2273473 defendant Skoul John husbandman 598490 598490 Skoul, John, of Wode Norton, husbandman 0
4726190 2273473 2273473 defendant Bekeswell Peter laborer 598490 598490 Bekeswell, Peter, of Wode Norton, laborer 3
4730144 2274629 2274629 defendant Gebon William yeoman 598490 598490 Gebon, William, of Wode Norton, yeoman 1
4742224 2278215 2278215 defendant Bulman William yeoman 598490 598490 Bulman, William, of Wode Norton, yeoman 1
4744180 2278824 2278824 defendant Bulman William yeoman 598490 598490 Bulman, William, of Wode Norton, yeoman 3
4752083 2281091 2281091 defendant Marchys John yeoman 598490 598490 Marchys, John, of Wode Norton, yeoman 7
4754488 2281784 2281784 defendant Scowyl Robert yeoman 598490 598490 Scowyl, Robert, of Wode Norton, yeoman 0
4762299 2284189 2284189 defendant Crane John gent 598490 598490 Crane, John, of Wode Norton, gent 0
4874521 2318974 2318974 defendant Bulman John yeoman 598490 598490 Bulman, John, of Wode Norton, yeoman 2
4913976 2330882 2330882 defendant Skoul Robert yeoman 598490 598490 Skoul, Robert, of Wode Norton, yeoman 0
4913977 2330882 2330882 defendant Bulman William yeoman 598490 598490 Bulman, William, of Wode Norton, yeoman 1
4929499 2335642 2335642 defendant Valentyn Andrew clerk 598490 598490 Valentyn, Andrew, of Wode Norton, clerk 2
4940304 2338989 2338989 defendant Balleman William yeoman 598490 598490 Balleman, William, of Wode Norton, yeoman 1
4949647 2341887 2341887 defendant Bulman William husbandman 598490 598490 Bulman, William, of Wode Norton, husbandman 3
4952097 2342595 2342595 defendant Crane John gent 598490 598490 Crane, John, of Wode Norton, gent 0
4952098 2342595 2342595 defendant Durant Robert Frenchman 598490 598490 Durant, Robert, of Wode Norton, Frenchman 1
4952099 2342595 2342595 defendant Ivy William laborer 598490 598490 Ivy, William, of Wode Norton, laborer 2
4952100 2342595 2342595 defendant Thressher John laborer 598490 598490 Thressher, John, of Wode Norton, laborer 3
4953223 2342924 2342924 defendant Halle William husbandman 598490 598490 Halle, William, of Wode Norton, husbandman 0
4955046 2343460 2343460 defendant Valentyn Andrew clerk 598490 598490 Valentyn, Andrew, of Wode Norton, clerk 2
4974615 2349374 2349374 defendant Bulman Thomas husbandman 598490 598490 Bulman, Thomas, of Wode Norton, husbandman 3
4974963 2349484 2349484 defendant Bulman Thomas husbandman 598490 598490 Bulman, Thomas, of Wode Norton, husbandman 0
4977451 2350220 2350220 defendant Holle Thomas yeoman 598490 598490 Holle, Thomas, of Wode Norton, yeoman 0
4979445 2350808 2350808 defendant Bulman Thomas husbandman 598490 598490 Bulman, Thomas, of Wode Norton, husbandman 1
4981396 2351355 2351355 defendant Crane John gent 598490 598490 Crane, John, of Wode Norton, gent 0
5025642 2364408 2364408 defendant Crane John esq 598490 598490 Crane, John, of Wode Norton, esq 3
5039542 2368475 2368475 defendant Crane John esq 598490 598490 Crane, John, of Wode Norton, esq 0
5048932 2371314 2371314 defendant Crane John esq 598490 598490 Crane, John, of Wode Norton, esq 0
5048935 2371314 2371314 defendant Halle William husbandman 598490 598490 Halle, William, of Wode Norton, husbandman 3
5070290 2377606 2377606 defendant Halle William husbandman 598490 598490 Halle, William, of Wode Norton, husbandman 0
5108916 2389028 2389028 defendant Skynner John husbandman 598490 598490 Skynner, John, of Wode Norton, husbandman 1
5109212 2389119 2389119 defendant Souter Adam husbandman 598490 598490 Souter, Adam, of Wode Norton, husbandman 0
5109215 2389119 2389119 defendant Ulf- John husbandman 598490 598490 Ulf-, John, of Wode Norton, husbandman 3
5111779 2389836 2389836 defendant Gebons William yeoman 598490 598490 Gebons, William, of Wode Norton, yeoman 0
5183500 2410911 2410911 defendant Grene Richard yeoman 598490 598490 Grene, Richard, of Wode Norton, yeoman 1
5297341 2444219 2444219 defendant Holley Robert husbandman 598490 598490 Holley, Robert, of Wode Norton, husbandman 1
5297894 2444392 2444392 defendant Holle William yeoman 598490 598490 Holle, William, of Wode Norton, yeoman 0
5331001 2454337 2454337 defendant Holle William husbandman 598490 598490 Holle, William, of Wode Norton, husbandman 1
5368799 2465832 2465832 defendant Holle William yeoman 598490 598490 Holle, William, of Wode Norton, yeoman 1
5449706 2489800 2489800 defendant Mason John yeoman 598490 598490 Mason, John, of Wode Norton, yeoman 1
5461846 2493486 2493486 defendant Martyn Thomas husbandman 598490 598490 Martyn, Thomas, of Wode Norton, husbandman 0
5461847 2493486 2493486 defendant Mason John yeoman 598490 598490 Mason, John, of Wode Norton, yeoman 1
5461850 2493487 2493487 defendant Martyn Thomas husbandman 598490 598490 Martyn, Thomas, of Wode Norton, husbandman 0
5461851 2493487 2493487 defendant Mason John yeoman 598490 598490 Mason, John, of Wode Norton, yeoman 1
5473384 2497001 2497001 defendant Martyns Thomas husbandman 598490 598490 Martyns, Thomas, of Wode Norton, husbandman 0
5473385 2497001 2497001 defendant Mason John yeoman 598490 598490 Mason, John, of Wode Norton, yeoman 1
5474950 2497489 2497489 defendant Yook Simon tailor 598490 598490 Yook, Simon, of Wode Norton, tailor 5
5478491 2498596 2498596 defendant Martyns Thomas husbandman 598490 598490 Martyns, Thomas, of Wode Norton, husbandman 0
5478492 2498596 2498596 defendant Mason John yeoman 598490 598490 Mason, John, of Wode Norton, yeoman 1
5499692 2504851 2504851 defendant Holley Robert (legal representative) 598490 598490 Holley, Robert, of Wode Norton, executor of 3
5634840 2554891 2554891 plaintiff Wallere or Walkere Simon   598490 598490 Wallere or Walkere, Simon, of Wode Norton 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);