names

46 rows where place_id = 596725

✎ 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
3625905 1902956 1902956 defendant Morgan Hugh yeoman 596725 596725 Morgan, Hugh, of Borstall, yeoman 1
3648335 1909880 1909880 defendant Rede William   596725 596725 Rede, William, of Borstall, knight 0
3670601 1916767 1916767 defendant Corke John yeoman 596725 596725 Corke, John, of Borstall, yeoman 0
3684111 1921166 1921166 defendant Brown Robert smith 596725 596725 Brown, Robert, of Borstall, smith 0
3692905 1923979 1923979 defendant Multeney William yeoman 596725 596725 Multeney, William, of Borstall, yeoman 0
3721800 1933089 1933089 defendant Rede Leonard gent 596725 596725 Rede, Leonard, of Borstall, gent 1
3721922 1933120 1933120 defendant Rede Leonard gent 596725 596725 Rede, Leonard, of Borstall, gent 1
3772532 1949099 1949099 defendant Hunter Thomas yeoman 596725 596725 Hunter, Thomas, of Borstall, yeoman 0
3800187 1957978 1957978 defendant Mountey or Mountery William yeoman 596725 596725 Mountey or Mountery, William, of Borstall, yeoman 2
3800188 1957978 1957978 defendant Newenton alias Newton John clerk 596725 596725 Newenton alias Newton, John, of Borstall, clerk 3
3814411 1962422 1962422 defendant Reede Leonard gent 596725 596725 Reede, Leonard, of Borstall, gent 1
3829566 1967138 1967138 defendant Rede William (legal representative) 596725 596725 Rede, William, of Borstall, knight, executor of 0
3948203 2006434 2006434 defendant Fraunc William yeoman 596725 596725 Fraunc, William, of Borstall, yeoman 0
4424974 2172648 2172648 defendant Clere William   596725 596725 Clere, William, of Borstall 7
4502219 2201290 2201290 defendant Brewere William   596725 596725 Brewere, William, of Borstall 3
4549532 2215800 2215800 defendant Breware William   596725 596725 Breware, William, of Borstall by Rochester 0
4557453 2218271 2218271 defendant Bedyl Thomas   596725 596725 Bedyl, Thomas, of Borstall 0
4577596 2224502 2224502 defendant Bedell Thomas   596725 596725 Bedell, Thomas, of Borstall 0
4637730 2242576 2242576 defendant Gerveys Thomas   596725 596725 Gerveys, Thomas, of Borstall 2
4637731 2242576 2242576 defendant Bedell Thomas   596725 596725 Bedell, Thomas, of Borstall 3
4660937 2249246 2249246 defendant Lynstede Thomas laborer 596725 596725 Lynstede, Thomas, of Borstall, laborer 3
4661393 2249387 2249387 defendant Gerveys Thomas laborer 596725 596725 Gerveys, Thomas, of Borstall, laborer 3
4661394 2249387 2249387 defendant Bedell Thomas laborer 596725 596725 Bedell, Thomas, of Borstall, laborer 4
4662031 2249599 2249599 defendant Bedell Thomas laborer 596725 596725 Bedell, Thomas, of Borstall, laborer 4
4674367 2257591 2257591 plaintiff Dugge Richard   596725 596725 Dugge, Richard, of Borstall 0
4676590 2258295 2258295 defendant Benet Robert laborer 596725 596725 Benet, Robert, of Borstall, laborer 0
4676592 2258296 2258296 defendant Botellere Thomas husbandman 596725 596725 Botellere, Thomas, of Borstall, husbandman 0
4694851 2263879 2263879 defendant Potter John husbandman 596725 596725 Potter, John, of Borstall, husbandman 0
4694852 2263879 2263879 defendant Tounesende William husbandman 596725 596725 Tounesende, William, of Borstall, husbandman 1
4694853 2263879 2263879 defendant Bocher John butcher 596725 596725 Bocher, John, of Borstall, butcher 2
4722546 2272365 2272365 defendant Coldhord William yeoman 596725 596725 Coldhord, William, of Borstall, yeoman 1
4742768 2278392 2278392 defendant Goldhord William   596725 596725 Goldhord, William, of Borstall 0
4743160 2278524 2278524 defendant Boldhord William yeoman 596725 596725 Boldhord, William, of Borstall, yeoman 1
4745670 2279246 2279246 defendant Gore John shipman 596725 596725 Gore, John, of Borstall by Rochester, shipman 1
4871951 2318206 2318206 defendant Dugg Thomas   596725 596725 Dugg, Thomas, of Borstall, servant 2
4950234 2342037 2342037 defendant Borwyn John husbandman 596725 596725 Borwyn, John, of Borstall, husbandman 0
5067630 2376813 2376813 defendant Barowe William husbadman 596725 596725 Barowe, William, of Borstall, husbadman 0
5067632 2376813 2376813 defendant Barowe Margery single woman 596725 596725 Barowe, Margery, of Borstall, single woman 2
5093279 2384432 2384432 defendant Amery John yeoman 596725 596725 Amery, John, of Borstall, yeoman 2
5099610 2386321 2386321 defendant Peyntour William husbandman 596725 596725 Peyntour, William, of Borstall, husbandman 6
5111152 2389650 2389650 defendant Clement John smith 596725 596725 Clement, John, of Borstall, smith 2
5166012 2405801 2405801 plaintiff Lorymer Robert   596725 596725 Lorymer, Robert, of Borstall 1
5180780 2410116 2410116 plaintiff Lorymer Robert   596725 596725 Lorymer, Robert, of Borstall 1
5180783 2410117 2410117 plaintiff Lorymer Robert   596725 596725 Lorymer, Robert, of Borstall 1
5180786 2410118 2410118 plaintiff Lorymer Robert   596725 596725 Lorymer, Robert, of Borstall 1
5549114 2519784 2519784 defendant Abyngton Thomas   596725 596725 Abyngton, Thomas, of Borstall, mason 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);