names

78 rows where place_id = 677885

✎ 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
4028955 2035001 2035001 plaintiff Crewe Arthur   677885 677885 Crewe, Arthur, of Gloucestershire 0
4411665 2168498 2168498 defendant Byshopps Thomas gent 677885 677885 Byshopps, Thomas, of Gloucestershire, gent 2
4427392 2173404 2173404 plaintiff Ryvere John de la   677885 677885 Ryvere, John de la, of Gloucestershire 0
4432712 2174985 2174985 defendant Ryvere John de la   677885 677885 Ryvere, John de la, of Gloucestershire, knight 0
4436252 2176079 2176079 plaintiff Ryvere John de la   677885 677885 Ryvere, John de la, of Gloucestershire 0
4436254 2176080 2176080 plaintiff Ryvere John de la   677885 677885 Ryvere, John de la, of Gloucestershire 0
4476194 2193217 2193217 defendant Parfyt Nicholas   677885 677885 Parfyt, Nicholas, of Gloucestershire 0
4479569 2194270 2194270 defendant Hamelyn Thomas   677885 677885 Hamelyn, Thomas, of Gloucestershire 3
4479574 2194271 2194271 defendant Hamelyn Thomas   677885 677885 Hamelyn, Thomas, of Gloucestershire 3
4492627 2198396 2198396 defendant Bradston John   677885 677885 Bradston, John, of Gloucestershire 3
4510167 2203664 2203664 defendant Doughton Roger   677885 677885 Doughton, Roger, of Gloucestershire 1
4511317 2203984 2203984 defendant Beauchamp William   677885 677885 Beauchamp, William, of Gloucestershire, knight 1
4513141 2204539 2204539 defendant Burley John (legal representative) 677885 677885 Burley, John, of Gloucestershire, executors of 2
4513143 2204539 2204539 defendant Streynesham Thomas   677885 677885 Streynesham, Thomas, of Gloucestershire 4
4514388 2204920 2204920 defendant Foliet Thomas   677885 677885 Foliet, Thomas, of Gloucestershire 0
4537622 2212041 2212041 defendant Chaunsey Henry   677885 677885 Chaunsey, Henry, of Gloucestershire 1
4546066 2214711 2214711 defendant Curteys Nicholas   677885 677885 Curteys, Nicholas, of Gloucestershire 0
4559333 2218870 2218870 defendant Pekke Stephen   677885 677885 Pekke, Stephen, of Gloucestershire 2
4563489 2220153 2220153 defendant Axbrigge William   677885 677885 Axbrigge, William, of Gloucestershire 0
4570125 2222229 2222229 defendant Bechamp William   677885 677885 Bechamp, William, of Gloucestershire, knight 0
4570131 2222230 2222230 defendant Bechamp William   677885 677885 Bechamp, William, of Gloucestershire, knight 0
4575163 2223752 2223752 defendant Rothewell John   677885 677885 Rothewell, John, of Gloucestershire 2
4583758 2226335 2226335 defendant Gyse Amice   677885 677885 Gyse, Amice, of Gloucestershire, formerly wife of Anselm 1
4583760 2226336 2226336 defendant Rye William   677885 677885 Rye, William, of Gloucestershire 0
4583762 2226337 2226337 defendant Gyse Anselm (legal representative) 677885 677885 Gyse, Anselm, of Gloucestershire, esq, administratrix of 0
4584427 2226544 2226544 defendant Jose John   677885 677885 Jose, John, of Gloucestershire 2
4584433 2226545 2226545 defendant Jose John esq 677885 677885 Jose, John, of Gloucestershire, esq 2
4588222 2227711 2227711 defendant Beauchamp Walter esq 677885 677885 Beauchamp, Walter, of Gloucestershire, esq 0
4588226 2227712 2227712 defendant Beauchamp Walter   677885 677885 Beauchamp, Walter, of Gloucestershire 0
4596108 2230033 2230033 defendant Beauchamp Walter esq 677885 677885 Beauchamp, Walter, of Gloucestershire, esq 0
4599236 2230974 2230974 defendant Bestford Walter   677885 677885 Bestford, Walter, of Gloucestershire 1
4610023 2234222 2234222 defendant Gerard John   677885 677885 Gerard, John, of Gloucestershire 0
4611576 2234682 2234682 defendant Wynslade John   677885 677885 Wynslade, John, of Gloucestershire 0
4613471 2235228 2235228 defendant Clerteys William   677885 677885 Clerteys, William, of Gloucestershire 0
4616311 2236093 2236093 defendant Cowele John esq 677885 677885 Cowele, John, of Gloucestershire, esq 5
4617269 2236413 2236413 defendant Manchestre Philip   677885 677885 Manchestre, Philip, of Gloucestershire 0
4618566 2236815 2236815 defendant Eyton John   677885 677885 Eyton, John, of Gloucestershire 0
4622330 2237963 2237963 defendant Wotton John   677885 677885 Wotton, John, of Gloucestershire, adminstrator of 3
4626365 2239198 2239198 defendant Cutler John   677885 677885 Cutler, John, of Gloucestershire 2
4630809 2240526 2240526 plaintiff Surrey John   677885 677885 Surrey, John, of Gloucestershire 0
4642038 2243779 2243779 defendant Draper Richard   677885 677885 Draper, Richard, of Gloucestershire 3
4642490 2243927 2243927 defendant Algar John   677885 677885 Algar, John, of Gloucestershire 0
4642492 2243928 2243928 defendant Algar John   677885 677885 Algar, John, of Gloucestershire 0
4643815 2244286 2244286 defendant Bradston John esq 677885 677885 Bradston, John, of Gloucestershire, esq 3
4646652 2245085 2245085 defendant Clifford Mathew esq 677885 677885 Clifford, Mathew, of Gloucestershire, esq 1
4646973 2245175 2245175 defendant Pulham Robert   677885 677885 Pulham, Robert, of Gloucestershire 1
4647248 2245250 2245250 defendant Bysyle Hugh   677885 677885 Bysyle, Hugh, of Gloucestershire 0
4649206 2245820 2245820 defendant Shenyton Richard   677885 677885 Shenyton, Richard, of Gloucestershire 0
4649209 2245821 2245821 defendant Shenyton Richard   677885 677885 Shenyton, Richard, of Gloucestershire 0
4663731 2250142 2250142 defendant Draper Richard   677885 677885 Draper, Richard, of Gloucestershire 0
4669803 2256258 2256258 plaintiff Bradeston Thomas esq 677885 677885 Bradeston, Thomas, of Gloucestershire, esq 0
4684202 2260662 2260662 defendant Brounyng John (legal representative) 677885 677885 Brounyng, John, of Gloucestershire, esq, executors of 0
4710098 2268514 2268514 plaintiff Poyntz Nicholas esq 677885 677885 Poyntz, Nicholas, of Gloucestershire, esq 0
4710099 2268514 2268514 defendant Brounyng John (legal representative) 677885 677885 Brounyng, John, of Gloucestershire, esq, executors of 0
4721428 2272035 2272035 defendant Beauchamp William (legal representative) 677885 677885 Beauchamp, William, of Gloucestershire, knight, & of Poywyk, Worcs, gent, executrix of 0
4721433 2272036 2272036 defendant Beauchamp William (legal representative) 677885 677885 Beauchamp, William, of Gloucestershire, knight, executrix of: 1
4726083 2273445 2273445 defendant Burford Robert de goldsmith 677885 677885 Burford, Robert de, of Gloucestershire, goldsmith 1
4733051 2275517 2275517 defendant Brounyng John (legal representative) 677885 677885 Brounyng, John, of Gloucestershire, esq, executors of 0
4745780 2279273 2279273 plaintiff Grayndour Robert esq 677885 677885 Grayndour, Robert, of Gloucestershire, esq 0
4755988 2282256 2282256 defendant Cheyne John (legal representative) 677885 677885 Cheyne, John, of Gloucestershire, knight formerly esquire, executor of 2
4758980 2283160 2283160 defendant Cheyne John (legal representative) 677885 677885 Cheyne, John, of Gloucestershire, knight, administrator of 0
4771086 2286938 2286938 plaintiff Russell Robert   677885 677885 Russell, Robert, of Gloucestershire 0
4773606 2287714 2287714 plaintiff Terry John   677885 677885 Terry, John, of Gloucestershire, free mason 0
4822783 2303207 2303207 plaintiff Somerset Gillbert   677885 677885 Somerset, Gillbert, of Gloucestershire 0
4910347 2329753 2329753 plaintiff Blonte Edmund gent 677885 677885 Blonte, Edmund, of Gloucestershire, gent, on his own account 0
4997112 2355989 2355989 defendant Danyell John yeoman 677885 677885 Danyell, John, of Gloucestershire, yeoman 1
5127687 2394581 2394581 plaintiff Carsy John esq 677885 677885 Carsy, John, of Gloucestershire, esq 0
5274410 2437595 2437595 plaintiff Poyntz Nicholas (legal representative) 677885 677885 Poyntz, Nicholas, of Gloucestershire, esq, executrix of 0
5301390 2445368 2445368 defendant Blount Edmund gent 677885 677885 Blount, Edmund, of Gloucestershire, gent 0
5389079 2471926 2471926 defendant Lee William gent 677885 677885 Lee, William, of Gloucestershire, gent 1
5402778 2475872 2475872 defendant Gyes Thomas gent 677885 677885 Gyes, Thomas, of Gloucestershire, gent 1
5403934 2476198 2476198 defendant (illegible) Nicholas yeoman 677885 677885 ----, Nicholas, of Gloucestershire, yeoman 2
5403935 2476198 2476198 defendant Danyell William yeoman 677885 677885 Danyell, William, of Gloucestershire, yeoman 3
5441165 2487269 2487269 defendant F_ John chapman 677885 677885 F_, John, of Gloucestershire, chapman 1
5441166 2487269 2487269 defendant (illegible) John chapman 677885 677885 _, John, of Gloucestershire, chapman 2
5441212 2487283 2487283 defendant Comyn Henry yeoman 677885 677885 Comyn, Henry, of Gloucestershire, yeoman 0
5449634 2489784 2489784 defendant (illegible) John clothmaker 677885 677885 _, John, of Gloucestershire, clothmaker 2
5617640 2549344 2549344 defendant Monemouth Richard   677885 677885 Monemouth, Richard, of Gloucestershire 2

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