names

80 rows where place_id = 643592

✎ 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
3874735 1981768 1981768 defendant Heron John miller 643592 643592 Heron, John, of Bradenynche, miller 1
3874738 1981769 1981769 defendant Heron John miller 643592 643592 Heron, John, of Bradenynche, miller 1
3896498 1989034 1989034 defendant Cobdon Edward tailor 643592 643592 Cobdon, Edward, of Bradenynche, tailor 3
3988753 2020724 2020724 defendant Denver Thomas gent 643592 643592 Denver, Thomas, of Bradenynche, gent 0
4600802 2231475 2231475 defendant Smyth William   643592 643592 Smyth, William, of Bradenynche 1
4615286 2235785 2235785 defendant Rokke John   643592 643592 Rokke, John, of Bradenynche 0
4615287 2235785 2235785 defendant Southcote William   643592 643592 Southcote, William, of Bradenynche 1
4662996 2249891 2249891 defendant Jurdan Roger   643592 643592 Jurdan, Roger, of Bradenynche 0
4664078 2250253 2250253 defendant Creule Joan widow 643592 643592 (Creule, Joan, of Bradenynche, gentlewoman, widow 1
4664079 2250253 2250253 defendant Rokke John tanner 643592 643592 Rokke, John, of Bradenynche, tanner 2
4676097 2258136 2258136 defendant Jordan Roger clerk & bailiff 643592 643592 Jordan, Roger, of Bradenynche, clerk & bailiff 0
4678356 2258839 2258839 defendant Borne John smith 643592 643592 Borne, John, of Bradenynche, smith 1
4687750 2261740 2261740 defendant Mate Robert husbandman 643592 643592 Mate, Robert, of Bradenynche, husbandman 2
4701382 2265834 2265834 defendant Jordan Roger clerk & bailiff 643592 643592 Jordan, Roger, of Bradenynche, clerk & bailiff 0
4706241 2267332 2267332 defendant Fraunceys John esq 643592 643592 Fraunceys, John, of Bradenynche, esq 0
4760190 2283536 2283536 defendant Lympynge John   643592 643592 Lympynge, John, of Bradenynche, shoe maker 2
4842063 2309056 2309056 plaintiff Langton John   643592 643592 Langton, John, of Bradenynche, parson 0
4842140 2309078 2309078 plaintiff Laughton John   643592 643592 Laughton, John, of Bradenynche, parson 0
4844136 2309677 2309677 defendant Prat Stephen butcher 643592 643592 Prat, Stephen, of Bradenynche, butcher 1
4909345 2329462 2329462 defendant Barland John laborer 643592 643592 Barland, John, of Bradenynche, laborer 3
4926901 2334843 2334843 defendant Vykery William husbandman 643592 643592 Vykery, William, of Bradenynche, husbandman 4
4951813 2342518 2342518 plaintiff Rede Joan (legal representative) 643592 643592 Rede, Joan, of Bradenynche, husbandman, executrix of 0
4964337 2346247 2346247 defendant Thwygge William tucker 643592 643592 Thwygge, William, of Bradenynche, tucker 0
4966815 2346998 2346998 defendant Frensshe Robert chapman 643592 643592 Frensshe, Robert, of Bradenynche, chapman 1
4976984 2350070 2350070 defendant Story Robert laborer 643592 643592 Story, Robert, of Bradenynche, laborer 0
4987852 2353334 2353334 defendant Colman alias Vycary William husbandman 643592 643592 Colman alias Vycary, William, of Bradenynche, husbandman 0
4989707 2353837 2353837 defendant Hewe John husbandman 643592 643592 Hewe, John, of Bradenynche, husbandman 0
4991426 2354320 2354320 defendant Jurdan Margaret widow 643592 643592 Jurdan, Margaret, of Bradenynche, widow 0
5001747 2357405 2357405 defendant Pyle John husbandman 643592 643592 Pyle, John, of Bradenynche, husbandman 0
5004595 2358245 2358245 defendant Story Robert butcher 643592 643592 Story, Robert, of Bradenynche, butcher 0
5018100 2362178 2362178 defendant Jurdan Margaret widow 643592 643592 Jurdan, Margaret, of Bradenynche, widow 0
5024562 2364097 2364097 defendant Clerk John fisher 643592 643592 Clerk, John, of Bradenynche, fisher 3
5041560 2369078 2369078 defendant Jurdan Margaret widow 643592 643592 Jurdan, Margaret, of Bradenynche, widow 0
5056974 2373665 2373665 defendant Vycary William yeoman 643592 643592 Vycary, William, of Bradenynche, yeoman 0
5060444 2374702 2374702 defendant Glade Thomas husbandman 643592 643592 Glade, Thomas, of Bradenynche, husbandman 3
5083998 2381716 2381716 defendant Twygge William husbandman 643592 643592 Twygge, William, of Bradenynche, husbandman 0
5100390 2386554 2386554 defendant Baker Thomas baker 643592 643592 Baker, Thomas, of Bradenynche, baker 3
5116384 2391220 2391220 defendant Russell Walter tanner 643592 643592 Russell, Walter, of Bradenynche, tanner 1
5130220 2395324 2395324 defendant Rygge William husbandman 643592 643592 Rygge, William, of Bradenynche, husbandman 0
5155732 2402837 2402837 defendant Bolehede John smith 643592 643592 Bolehede, John, of Bradenynche, smith 0
5162191 2404675 2404675 defendant Comer John   643592 643592 Comer, John, of Bradenynche, hoop maker 0
5164373 2405313 2405313 defendant Baker Thomas baker 643592 643592 Baker, Thomas, of Bradenynche, baker 3
5169224 2406737 2406737 defendant North John husbandman 643592 643592 North, John, of Bradenynche, husbandman 0
5185841 2411605 2411605 defendant North John husbandman 643592 643592 North, John, of Bradenynche, husbandman 0
5185842 2411605 2411605 defendant Facy John   643592 643592 Facy, John, of Bradenynche, groom 1
5204768 2417141 2417141 defendant Lucas William fuller 643592 643592 Lucas, William, of Bradenynche, fuller 0
5204956 2417196 2417196 defendant North John husbandman 643592 643592 North, John, of Bradenynche, husbandman 0
5204957 2417196 2417196 defendant Facy John   643592 643592 Facy, John, of Bradenynche, groom 1
5218213 2421055 2421055 defendant Story Robert butcher 643592 643592 Story, Robert, of Bradenynche, butcher 0
5237654 2426594 2426594 defendant Hydon Richard cordwainer 643592 643592 Hydon, Richard, of Bradenynche, cordwainer 0
5237655 2426594 2426594 defendant Dokyn John husbandman 643592 643592 Dokyn, John, of Bradenynche, husbandman 1
5249360 2429931 2429931 defendant Payse John husbandman 643592 643592 Payse, John, of Bradenynche, husbandman 0
5270139 2436369 2436369 defendant Twygge John fuller 643592 643592 Twygge, John, of Bradenynche, fuller 0
5309750 2447952 2447952 defendant Pope John husbandman 643592 643592 Pope, John, of Bradenynche, husbandman 4
5310245 2448098 2448098 defendant Wotton William husbandman 643592 643592 Wotton, William, of Bradenynche, husbandman 1
5321215 2451442 2451442 defendant Bulhed Thomas smith 643592 643592 Bulhed, Thomas, of Bradenynche, smith 2
5329630 2453931 2453931 defendant Burner William cordainer 643592 643592 Burner, William, of Bradenynche, cordainer 1
5329631 2453931 2453931 defendant Glader Richard miller 643592 643592 Glader, Richard, of Bradenynche, miller 2
5356181 2462011 2462011 defendant Vycary William husbandman 643592 643592 Vycary, William, of Bradenynche, husbandman 2
5359570 2463029 2463029 defendant atte More John butcher 643592 643592 atte More, John, of Bradenynche, butcher 0
5361031 2463474 2463474 defendant Whytsyde John tanner 643592 643592 Whytsyde, John, of Bradenynche, tanner 0
5361032 2463474 2463474 defendant Ley Walter hooper 643592 643592 Ley, Walter, of Bradenynche, hooper 1
5394192 2473399 2473399 defendant Lemyngton John, junior husbandman 643592 643592 Lemyngton, John, junior, of Bradenynche, husbandman 0
5405717 2476709 2476709 defendant Whyttsyde John yeoman 643592 643592 Whyttsyde, John, of Bradenynche, yeoman 3
5407343 2477165 2477165 defendant Lemyngton John, junior husbandman 643592 643592 Lemyngton, John, junior, of Bradenynche, husbandman 0
5409399 2477778 2477778 defendant Baylly Robert husbandman 643592 643592 Baylly, Robert, of Bradenynche, husbandman 0
5420601 2481086 2481086 defendant Levyngton John husbandman 643592 643592 Levyngton, John, of Bradenynche, husbandman 0
5420928 2481188 2481188 defendant Whytesyde John yeoman 643592 643592 Whytesyde, John, of Bradenynche, yeoman 3
5422933 2481815 2481815 defendant Baylly Robert husbandman 643592 643592 Baylly, Robert, of Bradenynche, husbandman 0
5423987 2482127 2482127 defendant Dever William smith 643592 643592 Dever, William, of Bradenynche, smith 0
5423989 2482128 2482128 defendant Dyver William smith 643592 643592 Dyver, William, of Bradenynche, smith 0
5440589 2487090 2487090 defendant Whiteside John yeoman 643592 643592 Whiteside, John, of Bradenynche, yeoman 1
5440594 2487091 2487091 defendant Whytesyde John yeoman 643592 643592 Whytesyde, John, of Bradenynche, yeoman 2
5440723 2487134 2487134 defendant Whitesyde John yeoman 643592 643592 Whitesyde, John, of Bradenynche, yeoman 2
5441303 2487313 2487313 defendant (illegible) John husbandman 643592 643592 _, John, of Bradenynche, husbandman 0
5482849 2499817 2499817 defendant Hylle John husbandman 643592 643592 Hylle, John, of Bradenynche, husbandman 0
5482850 2499817 2499817 defendant Rede John tailor 643592 643592 Rede, John, of Bradenynche, tailor 1
5482851 2499817 2499817 defendant Wodelegh Robert laborer 643592 643592 Wodelegh, Robert, of Bradenynche, laborer 2
5482852 2499817 2499817 defendant Wythecombe Robert clerk 643592 643592 Wythecombe, Robert, of Bradenynche, clerk 3
5517256 2510231 2510231 defendant Wotton William yeoman 643592 643592 Wotton, William, of Bradenynche, yeoman 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);