names

83 rows where place_id = 608388

✎ 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
3673500 1917737 1917737 plaintiff Fayerford Robert   608388 608388 Fayerford, Robert, of Chalgrave 0
3708848 1929061 1929061 defendant Burnam William husbandman 608388 608388 Burnam, William, of Chalgrave, husbandman 0
3708850 1929061 1929061 defendant Sped Thomas husbandman 608388 608388 Sped, Thomas, of Chalgrave, husbandman 2
3708856 1929062 1929062 defendant Wygyn John husbandman 608388 608388 Wygyn, John, of Chalgrave, husbandman 2
3909264 1993391 1993391 defendant Osbournbye John clerk 608388 608388 Osbournbye, John, of Chalgrave, clerk 0
3909265 1993391 1993391 defendant Luter William yeoman 608388 608388 Luter, William, of Chalgrave, yeoman 1
3911535 1994175 1994175 defendant Cardell William husbandman 608388 608388 Cardell, William, of Chalgrave, husbandman 0
3993320 2022350 2022350 defendant Grey Thomas husbandman 608388 608388 Grey, Thomas, of Chalgrave, husbandman 0
3993321 2022350 2022350 defendant Heyns Edward husbandman 608388 608388 Heyns, Edward, of Chalgrave, husbandman 1
3993322 2022350 2022350 defendant Welssheman John husbandman 608388 608388 Welssheman, John, of Chalgrave, husbandman 2
4439705 2181690 2181690 plaintiff Barentyne Thomas esq 608388 608388 Barentyne, Thomas, of Chalgrave, esq, on his own account 0
4439707 2181691 2181691 plaintiff Barentyne Thomas esq 608388 608388 Barentyne, Thomas, of Chalgrave, esq, on his own account 0
4439709 2181692 2181692 plaintiff Barentyne Thomas   608388 608388 Barentyne, Thomas, of Chalgrave, esquire 0
4535704 2211447 2211447 plaintiff Smyth William farmer 608388 608388 Smyth, William, of Chalgrave, farmer 0
4554900 2217461 2217461 defendant Catermayn John   608388 608388 Catermayn, John, of Chalgrave 0
4554901 2217461 2217461 defendant Rose Henry   608388 608388 Rose, Henry, of Chalgrave 1
4565538 2220793 2220793 plaintiff Smyth William   608388 608388 Smyth, William, of Chalgrave 0
4606410 2233120 2233120 defendant Tayllour Simon   608388 608388 Tayllour, Simon, of Chalgrave 2
4652876 2246835 2246835 defendant Nereford Jordan laborer 608388 608388 Nereford, Jordan, of Chalgrave, laborer 0
4692702 2263226 2263226 defendant (illegible) John husbandman 608388 608388 _, John, of Chalgrave, husbandman 1
4692704 2263227 2263227 defendant Roos John husbandman 608388 608388 Roos, John, of Chalgrave, husbandman 0
4692705 2263227 2263227 defendant Gretory John husbandman 608388 608388 Gretory, John, of Chalgrave, husbandman 1
4693160 2263362 2263362 defendant Rose John, senior husbandman 608388 608388 Rose, John, senior, of Chalgrave, husbandman 0
4693464 2263456 2263456 defendant Goldsmyth Thomas husbandman 608388 608388 Goldsmyth, Thomas, of Chalgrave, husbandman 0
4707783 2267800 2267800 defendant Goldsmyth Thomas husbandman 608388 608388 Goldsmyth, Thomas, of Chalgrave, husbandman 0
4712308 2269164 2269164 defendant Goldsmyth Thomas yeoman 608388 608388 Goldsmyth, Thomas, of Chalgrave, yeoman 0
4716178 2270370 2270370 defendant Neveraford Jordan husbandman 608388 608388 Neveraford, Jordan, of Chalgrave, husbandman 1
4724256 2272882 2272882 defendant Bartelmewe Richard husbandman 608388 608388 Bartelmewe, Richard, of Chalgrave, husbandman 0
4767233 2285738 2285738 defendant Barentyn Reginald gent 608388 608388 Barentyn, Reginald, of Chalgrave, gent 0
4778651 2289306 2289306 defendant Barentyne Thomas   608388 608388 Barentyne, Thomas, of Chalgrave 0
4829500 2305266 2305266 defendant Busshop William husbandman 608388 608388 Busshop, William, of Chalgrave, husbandman 1
4845221 2310017 2310017 defendant Dodde Thomas husbandman 608388 608388 Dodde, Thomas, of Chalgrave, husbandman 0
4932091 2336430 2336430 defendant Stevenesson Thomas yeoman 608388 608388 Stevenesson, Thomas, of Chalgrave, yeoman 1
4992355 2354603 2354603 defendant Catermayne William husbandman 608388 608388 Catermayne, William, of Chalgrave, husbandman 0
5039136 2368351 2368351 defendant Pury John husbandman 608388 608388 Pury, John, of Chalgrave, husbandman 0
5039137 2368351 2368351 defendant bucher John husbandman 608388 608388 bucher, John, of Chalgrave, husbandman 1
5093928 2384623 2384623 defendant Quatermayns William husbandman 608388 608388 Quatermayns, William, of Chalgrave, husbandman 2
5093929 2384623 2384623 defendant Colman Richard husbandman 608388 608388 Colman, Richard, of Chalgrave, husbandman 3
5137904 2397598 2397598 defendant Davy William husbandman 608388 608388 Davy, William, of Chalgrave, husbandman 0
5137907 2397599 2397599 defendant Dodde John husbandman 608388 608388 Dodde, John, of Chalgrave, husbandman 0
5137918 2397603 2397603 defendant Wygan Richard husbandman 608388 608388 Wygan, Richard, of Chalgrave, husbandman 0
5137919 2397603 2397603 defendant Wygan William husbandman 608388 608388 Wygan, William, of Chalgrave, husbandman 1
5152026 2401728 2401728 defendant Bosenho William gent 608388 608388 Bosenho, William, of Chalgrave, gent 0
5158620 2403641 2403641 defendant Davy William husbandman 608388 608388 Davy, William, of Chalgrave, husbandman 0
5158621 2403641 2403641 defendant Vycary John laborer 608388 608388 Vycary, John, of Chalgrave, laborer 1
5158623 2403642 2403642 defendant Dodde John husbandman 608388 608388 Dodde, John, of Chalgrave, husbandman 0
5158636 2403648 2403648 defendant Wygan Richard husbandman 608388 608388 Wygan, Richard, of Chalgrave, husbandman 0
5158637 2403648 2403648 defendant Wygan William husbandman 608388 608388 Wygan, William, of Chalgrave, husbandman 1
5232261 2425012 2425012 defendant North Elias chaplain 608388 608388 North, Elias, of Chalgrave, chaplain 2
5232272 2425015 2425015 defendant North Elias chaplain 608388 608388 North, Elias, of Chalgrave, chaplain 2
5240635 2427474 2427474 defendant Berne Thomas husbandman 608388 608388 Berne, Thomas, of Chalgrave, husbandman 0
5261322 2433649 2433649 defendant Shepard John yeoman 608388 608388 Shepard, John, of Chalgrave, yeoman 4
5261501 2433707 2433707 defendant Shepard John yeoman 608388 608388 Shepard, John, of Chalgrave, yeoman 4
5308030 2447423 2447423 defendant Colman Richard yeoman 608388 608388 Colman, Richard, of Chalgrave, yeoman 0
5316562 2450039 2450039 defendant Catermayn John yeoman 608388 608388 Catermayn, John, of Chalgrave, yeoman 0
5372781 2467089 2467089 defendant Aleyn John butcher 608388 608388 Aleyn, John, of Chalgrave, butcher 3
5499823 2504895 2504895 defendant Carver John husbandman 608388 608388 Carver, John, of Chalgrave, husbandman 3
5522286 2511788 2511788 defendant Robyns Thomas husbandman 608388 608388 Robyns, Thomas, of Chalgrave, husbandman 0
5522287 2511788 2511788 defendant Freman John husbandman 608388 608388 Freman, John, of Chalgrave, husbandman 1
5545620 2518704 2518704 defendant Robyns Thomas husbandman 608388 608388 Robyns, Thomas, of Chalgrave, husbandman 0
5545622 2518705 2518705 defendant Robyns Thomas husbandman 608388 608388 Robyns, Thomas, of Chalgrave, husbandman 0
5549752 2519959 2519959 defendant Shanke John husbandman 608388 608388 Shanke, John, of Chalgrave, husbandman 1
5560413 2523004 2523004 defendant Molyneux Robert husbandman 608388 608388 Molyneux, Robert, of Chalgrave, husbandman 2
5563080 2523799 2523799 defendant Wodeward Thomas merchant 608388 608388 Wodeward, Thomas, of Chalgrave, merchant 0
5563102 2523807 2523807 defendant Woodeward Thomas merchant 608388 608388 Woodeward, Thomas, of Chalgrave, merchant 0
5563103 2523807 2523807 defendant Woodeward Leonard yeoman 608388 608388 Woodeward, Leonard, of Chalgrave, yeoman 1
5563107 2523807 2523807 defendant Stafford Edmund glover 608388 608388 Stafford, Edmund, of Chalgrave, glover 5
5563108 2523807 2523807 defendant Childe William husbandman 608388 608388 Childe, William, of Chalgrave, husbandman 6
5563109 2523807 2523807 defendant Emmottys John laborer 608388 608388 Emmottys, John, of Chalgrave, laborer 7
5563110 2523807 2523807 defendant Goddard Richard tailor 608388 608388 Goddard, Richard, of Chalgrave, tailor 8
5563112 2523808 2523808 defendant Wodeward Thomas merchant 608388 608388 Wodeward, Thomas, of Chalgrave, merchant 0
5563113 2523808 2523808 defendant Woodward Leonard yeoman 608388 608388 Woodward, Leonard, of Chalgrave, yeoman 1
5563117 2523808 2523808 defendant Stafford Edmund glover 608388 608388 Stafford, Edmund, of Chalgrave, glover 5
5563118 2523808 2523808 defendant Childe William husbandman 608388 608388 Childe, William, of Chalgrave, husbandman 6
5563119 2523808 2523808 defendant Emmottys John laborer 608388 608388 Emmottys, John, of Chalgrave, laborer 7
5563120 2523808 2523808 defendant Goddard Richard tailor 608388 608388 Goddard, Richard, of Chalgrave, tailor 8
5563673 2523985 2523985 defendant Childe William husbandman 608388 608388 Childe, William, of Chalgrave, husbandman 0
5563674 2523985 2523985 defendant Laurence John carpenter 608388 608388 Laurence, John, of Chalgrave, carpenter 1
5563675 2523985 2523985 defendant Smyth John collier 608388 608388 Smyth, John, of Chalgrave, collier 2
5577674 2528086 2528086 defendant Aleyn Thomas carpenter 608388 608388 Aleyn, Thomas, of Chalgrave, carpenter 0
5577686 2528091 2528091 defendant Aleyn Thomas carpenter 608388 608388 Aleyn, Thomas, of Chalgrave, carpenter 0
5599502 2534736 2534736 defendant Bekwyth Thomas husbandman 608388 608388 Bekwyth, Thomas, of Chalgrave, husbandman 0
5617282 2549222 2549222 defendant Whityng John   608388 608388 Whityng, John, of Chalgrave 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);