names

62 rows where place_id = 597361

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3628273 1903704 1903704 defendant Grey Thomas yeoman 597361 597361 Grey, Thomas, of Thrandeston, yeoman 1
3642215 1908012 1908012 defendant Grey Thomas yeoman 597361 597361 Grey, Thomas, of Thrandeston, yeoman 1
3646877 1909421 1909421 plaintiff Kene Robert   597361 597361 Kene, Robert, of Thrandeston 0
3646880 1909422 1909422 plaintiff Kene Robert   597361 597361 Kene, Robert, of Thrandeston 0
3656527 1912292 1912292 defendant Crane Nicholas husbandman 597361 597361 Crane, Nicholas, of Thrandeston, husbandman 0
3684202 1921195 1921195 defendant Joly Nicholas husbandman 597361 597361 Joly, Nicholas, of Thrandeston, husbandman 0
3736665 1937721 1937721 defendant Joly Nicholas husbandman 597361 597361 Joly, Nicholas, of Thrandeston, husbandman 0
3856391 1975620 1975620 defendant Kene Robert yeoman 597361 597361 Kene, Robert, of Thrandeston, yeoman 0
3867251 1979283 1979283 defendant Fesaunt Henry yeoman 597361 597361 Fesaunt, Henry, of Thrandeston, yeoman 1
3874251 1981607 1981607 defendant Grey Thomas gent 597361 597361 Grey, Thomas, of Thrandeston, gent 0
3878081 1982914 1982914 plaintiff Kene Robert gent 597361 597361 Kene, Robert, of Thrandeston, gent 0
3878083 1982915 1982915 plaintiff Kene Robert gent 597361 597361 Kene, Robert, of Thrandeston, gent 0
3895039 1988550 1988550 defendant Grey Thomas gent 597361 597361 Grey, Thomas, of Thrandeston, gent 0
3895041 1988551 1988551 defendant Grey Thomas gent 597361 597361 Grey, Thomas, of Thrandeston, gent 0
3909298 1993404 1993404 defendant Grey Thomas gent 597361 597361 Grey, Thomas, of Thrandeston, gent 0
3923150 1998049 1998049 defendant Grey Thomas gent 597361 597361 Grey, Thomas, of Thrandeston, gent 0
3923152 1998050 1998050 defendant Grey Thomas gent 597361 597361 Grey, Thomas, of Thrandeston, gent 0
3923153 1998050 1998050 defendant Crane Robert husbandman 597361 597361 Crane, Robert, of Thrandeston, husbandman 1
3930438 2000527 2000527 defendant Crane Robert laborer 597361 597361 Crane, Robert, of Thrandeston, laborer 0
3930441 2000528 2000528 defendant Grave or Crane Robert laborer 597361 597361 Grave or Crane, Robert, of Thrandeston, laborer 0
3959374 2010360 2010360 defendant Graye Thomas gent 597361 597361 Graye, Thomas, of Thrandeston, gent 0
3959377 2010361 2010361 defendant Grey Thomas gent 597361 597361 Grey, Thomas, of Thrandeston, gent 0
3959378 2010361 2010361 defendant Grey Henry   597361 597361 Grey, Henry, of Thrandeston, gent, his son 1
4016854 2030725 2030725 defendant Sheparde John yeoman 597361 597361 Sheparde, John, of Thrandeston, yeoman 2
4092999 2057808 2057808 defendant Bendall Thomas yeoman 597361 597361 Bendall, Thomas, of Thrandeston, yeoman 1
4127961 2070290 2070290 defendant Coppuldyke Edward gent 597361 597361 Coppuldyke, Edward, of Thrandeston, gent 1
4131001 2071402 2071402 defendant Cooper James husbandman 597361 597361 Cooper, James, of Thrandeston, husbandman 0
4166392 2083742 2083742 defendant Crane Henry weaver 597361 597361 Crane, Henry, of Thrandeston, weaver 0
4189851 2091948 2091948 defendant Crane Henry weaver 597361 597361 Crane, Henry, of Thrandeston, weaver 0
4213347 2100184 2100184 defendant Crane Henry weaver 597361 597361 Crane, Henry, of Thrandeston, weaver 0
4225682 2104447 2104447 defendant Kene Thomas gent 597361 597361 Kene, Thomas, of Thrandeston, or of Ipswich, gent 0
4234400 2107572 2107572 defendant Keene Thomas gent 597361 597361 Keene, Thomas, of Thrandeston, gent 0
4234401 2107572 2107572 defendant Keene John singleman 597361 597361 Keene, John, of Thrandeston, gent, singleman 1
4240913 2109946 2109946 defendant Kirke William yeoman 597361 597361 Kirke, William, of Thrandeston, yeoman 2
4282775 2123881 2123881 defendant Keane Thomas gent 597361 597361 Keane, Thomas, of Thrandeston, gent 0
4282776 2123881 2123881 defendant Quynten Thomas yeoman 597361 597361 Quynten, Thomas, of Thrandeston, yeoman 1
4345363 2145654 2145654 defendant Kene Thomas gent 597361 597361 Kene, Thomas, of Thrandeston, gent 0
4390405 2161412 2161412 defendant Keene Thomas gent 597361 597361 Keene, Thomas, of Thrandeston, gent 3
4408147 2167294 2167294 defendant Dixe William husbandman 597361 597361 Dixe, William, of Thrandeston, husbandman 0
4408148 2167294 2167294 defendant Lynge James clerk 597361 597361 Lynge, James, of Thrandeston, clerk 1
4821557 2302825 2302825 plaintiff Rygge Margaret (legal representative) 597361 597361 Rygge, Margaret, of Thrandeston, formerly wife of Robert Rygge, executor of 0
4943199 2339843 2339843 plaintiff Gepweyth James   597361 597361 Gepweyth, James, of Thrandeston 0
4978039 2350397 2350397 defendant Thweyt James husbandman 597361 597361 Thweyt, James, of Thrandeston, husbandman 2
5045128 2370172 2370172 defendant Harfray Peter gent 597361 597361 Harfray, Peter, of Thrandeston, gent 3
5100787 2386652 2386652 defendant Thweyt James husbandman 597361 597361 Thweyt, James, of Thrandeston, husbandman 8
5128839 2394920 2394920 defendant Herfrey Peter   597361 597361 Herfrey, Peter, of Thrandeston 0
5128841 2394920 2394920 defendant Wright John yeoman 597361 597361 Wright, John, of Thrandeston, yeoman 2
5137202 2397393 2397393 defendant Joyntour John clerk 597361 597361 Joyntour, John, of Thrandeston, clerk 0
5137204 2397394 2397394 defendant Joyntour John husbandman & parson 597361 597361 Joyntour, John, of Thrandeston, husbandman & parson 0
5148042 2400574 2400574 defendant Herfrey Peter gent 597361 597361 Herfrey, Peter, of Thrandeston, gent 0
5183008 2410776 2410776 defendant Herfrey Peter gent 597361 597361 Herfrey, Peter, of Thrandeston, gent 0
5183010 2410776 2410776 defendant Wright John yeoman 597361 597361 Wright, John, of Thrandeston, yeoman 2
5184456 2411193 2411193 plaintiff Edon Richard   597361 597361 Edon, Richard, of Thrandeston 0
5184459 2411194 2411194 plaintiff Edon Richard   597361 597361 Edon, Richard, of Thrandeston 0
5259021 2432938 2432938 defendant Herfrey Peter gent 597361 597361 Herfrey, Peter, of Thrandeston, gent 0
5262355 2433974 2433974 defendant Herfrey Peter gent 597361 597361 Herfrey, Peter, of Thrandeston, gent 0
5264656 2434702 2434702 defendant Grene Robert gent 597361 597361 Grene, Robert, of Thrandeston, gent 0
5276020 2438060 2438060 defendant Carman Robert laborer 597361 597361 Carman, Robert, of Thrandeston, laborer 0
5348486 2459667 2459667 defendant Crane William husbandman 597361 597361 Crane, William, of Thrandeston, husbandman 0
5492782 2502758 2502758 defendant Morell John carpenter 597361 597361 Morell, John, of Thrandeston, carpenter 1
5589384 2531679 2531679 defendant Grey Thomas gent 597361 597361 (Grey, Thomas, of Thrandeston, gent 1
5591693 2532388 2532388 defendant Fulcher Thomas husbandman 597361 597361 Fulcher, Thomas, of Thrandeston, husbandman 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);