names

63 rows where place_id = 595865

✎ 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
3622159 1874465 1874465 defendant Brande William husbandman 595865 595865 Brande, William, of Gedlyng, husbandman 1
3622160 1874465 1874465 defendant Grene John husbandman 595865 595865 Grene, John, of Gedlyng, husbandman 2
3622161 1874465 1874465 defendant Warde John husbandman 595865 595865 Warde, John, of Gedlyng, husbandman 3
3622164 1874466 1874466 defendant Brande William husbandman 595865 595865 Brande, William, of Gedlyng, husbandman 1
3622165 1874466 1874466 defendant Grene John husbandman 595865 595865 Grene, John, of Gedlyng, husbandman 2
3622166 1874466 1874466 defendant Warde John husbandman 595865 595865 Warde, John, of Gedlyng, husbandman 3
3622169 1874467 1874467 defendant Brande William husbandman 595865 595865 Brande, William, of Gedlyng, husbandman 1
3622170 1874467 1874467 defendant Grene John husbandman 595865 595865 Grene, John, of Gedlyng, husbandman 2
3622171 1874467 1874467 defendant Warde John husbandman 595865 595865 Warde, John, of Gedlyng, husbandman 3
3633625 1905328 1905328 defendant Maynell Brian clerk 595865 595865 Maynell, Brian, of Gedlyng, clerk 0
3633626 1905328 1905328 defendant Maynell Patrick yeoman 595865 595865 Maynell, Patrick, of Gedlyng, yeoman 1
3633628 1905328 1905328 defendant Brumley John husbandman 595865 595865 Brumley, John, of Gedlyng, husbandman 3
3633629 1905328 1905328 defendant Maynell Richard husbandman 595865 595865 Maynell, Richard, of Gedlyng, husbandman 4
3633631 1905329 1905329 defendant Meynell Brian clerk 595865 595865 Meynell, Brian, of Gedlyng, clerk 0
3633632 1905329 1905329 defendant Meynell Patrick yeoman 595865 595865 Meynell, Patrick, of Gedlyng, yeoman 1
3633634 1905329 1905329 defendant Broumley John husbandman 595865 595865 Broumley, John, of Gedlyng, husbandman 3
3633635 1905329 1905329 defendant Michell Richard husbandman 595865 595865 Michell, Richard, of Gedlyng, husbandman 4
3640002 1907327 1907327 defendant Langford Thomas yeoman 595865 595865 Langford, Thomas, of Gedlyng, yeoman 0
3640003 1907327 1907327 defendant Langford Richard yeoman 595865 595865 Langford, Richard, of Gedlyng, yeoman 1
3647196 1909513 1909513 defendant Meynell Brian clerk 595865 595865 Meynell, Brian, of Gedlyng, clerk 0
3647197 1909513 1909513 defendant Meynell Patrick yeoman 595865 595865 Meynell, Patrick, of Gedlyng, yeoman 1
3647199 1909513 1909513 defendant Brumley John husbandman 595865 595865 Brumley, John, of Gedlyng, husbandman 3
3647200 1909513 1909513 defendant Michell John husbandman 595865 595865 Michell, John, of Gedlyng, husbandman 4
3738896 1938371 1938371 defendant Hogekynson Roger tailor 595865 595865 Hogekynson, Roger, of Gedlyng, tailor 0
3739519 1938569 1938569 defendant Hogekynson Roger   595865 595865 Hogekynson, Roger, of Gedlyng 0
3739520 1938569 1938569 defendant Hochekyn Richard yeoman 595865 595865 Hochekyn, Richard, of Gedlyng, yeoman 1
3928117 1999743 1999743 defendant Garten Richard husbandman 595865 595865 Garten, Richard, of Gedlyng, husbandman 0
4495996 2199425 2199425 plaintiff Clerk William   595865 595865 Clerk, William, of Gedlyng 0
4497119 2199759 2199759 plaintiff del Ston Henry   595865 595865 del Ston, Henry, of Gedlyng 0
4500876 2200895 2200895 plaintiff Kyllum Richard   595865 595865 Kyllum, Richard, of Gedlyng, parson 0
4500878 2200896 2200896 plaintiff Kyllum Richard   595865 595865 Kyllum, Richard, of Gedlyng, parson 0
4526473 2208560 2208560 defendant Clerk William   595865 595865 Clerk, William, of Gedlyng 0
4550074 2215962 2215962 defendant Clerk Wiliam   595865 595865 Clerk, Wiliam, of Gedlyng 0
4557297 2218219 2218219 plaintiff Kyllome Richard   595865 595865 Kyllome, Richard, of Gedlyng, parson 0
4640980 2243457 2243457 defendant Wodeburgh Robert   595865 595865 Wodeburgh, Robert, of Gedlyng 6
4670809 2256549 2256549 defendant Clerk William merchant 595865 595865 Clerk, William, of Gedlyng, merchant 0
4672221 2256960 2256960 plaintiff Clerk William   595865 595865 Clerk, William, of Gedlyng 0
4695875 2264193 2264193 defendant Clerk William merchant 595865 595865 Clerk, William, of Gedlyng, merchant 0
4697219 2264611 2264611 defendant Spicer Roger husbandman 595865 595865 Spicer, Roger, of Gedlyng, husbandman 0
4720047 2271618 2271618 plaintiff Brampton William de   595865 595865 Brampton, William de, of Gedlyng, parson 0
4722080 2272235 2272235 defendant Gybson William husbandman 595865 595865 Gybson, William, of Gedlyng, husbandman 3
4775361 2288289 2288289 plaintiff Willyamson Roger   595865 595865 Willyamson, Roger, of Gedlyng 0
4775363 2288289 2288289 defendant Roo Thomas   595865 595865 Roo, Thomas, of Gedlyng 0
4808521 2298834 2298834 defendant Rowe Thomas husbandman 595865 595865 Rowe, Thomas, of Gedlyng, husbandman 0
4808522 2298834 2298834 defendant Goke Richard husbandman 595865 595865 Goke, Richard, of Gedlyng, husbandman 1
4866224 2316404 2316404 defendant Whteley Thomas husbandman 595865 595865 Whteley, Thomas, of Gedlyng, husbandman 5
4894169 2324870 2324870 defendant Colyngham John yeoman 595865 595865 Colyngham, John, of Gedlyng, yeoman 1
4964481 2346283 2346283 plaintiff Clerk William   595865 595865 Clerk, William, of Gedlyng 0
5263673 2434387 2434387 defendant Hogan William husbandman 595865 595865 Hogan, William, of Gedlyng, husbandman 2
5274657 2437665 2437665 defendant Grandon Thomas   595865 595865 Grandon, Thomas, of Gedlyng, plough wright 3
5383207 2470271 2470271 defendant Byot Thomas husbandman 595865 595865 Byot, Thomas, of Gedlyng, husbandman 8
5383209 2470271 2470271 defendant Nobull Robert husbandman 595865 595865 Nobull, Robert, of Gedlyng, husbandman 10
5383210 2470271 2470271 defendant Stere Robert husbandman 595865 595865 Stere, Robert, of Gedlyng, husbandman 11
5383211 2470271 2470271 defendant Bayley Richard husbandman 595865 595865 Bayley, Richard, of Gedlyng, husbandman 12
5383212 2470271 2470271 defendant Nowell John husbandman 595865 595865 Nowell, John, of Gedlyng, husbandman 13
5383213 2470271 2470271 defendant Norwell William husbandman 595865 595865 Norwell, William, of Gedlyng, husbandman 14
5391433 2472626 2472626 defendant By_e Thomas husbandman 595865 595865 By_e, Thomas, of Gedlyng, husbandman 8
5391435 2472626 2472626 defendant (illegible) Robert husbandman 595865 595865 _, Robert, of Gedlyng, husbandman 10
5391436 2472626 2472626 defendant Stere Robert husbandman 595865 595865 Stere, Robert, of Gedlyng, husbandman 11
5391437 2472626 2472626 defendant Baylye Richard husbandman 595865 595865 Baylye, Richard, of Gedlyng, husbandman 12
5391438 2472626 2472626 defendant Norwell John husbandman 595865 595865 Norwell, John, of Gedlyng, husbandman 13
5391439 2472626 2472626 defendant Norwell William husbandman 595865 595865 Norwell, William, of Gedlyng, husbandman 14
5569165 2525534 2525534 defendant Dryffeld Walter clerk 595865 595865 Dryffeld, Walter, of Gedlyng, clerk 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);