names

71 rows where place_id = 598626

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3633352 1905244 1905244 defendant Gylys John, senior husbandman 598626 598626 Gylys, John, senior, of Stanstede, husbandman 5
3639368 1907121 1907121 defendant Gives or Gibes John husbandman 598626 598626 Gives or Gibes, John, of Stanstede, husbandman 0
3710753 1929684 1929684 defendant Coppyng Thomas yeoman 598626 598626 Coppyng, Thomas, of Stanstede, yeoman 0
3710756 1929684 1929684 defendant Rukwood Robert gent 598626 598626 Rukwood, Robert, of Stanstede, gent 3
3710759 1929685 1929685 defendant Coppynge Thomas yeoman 598626 598626 Coppynge, Thomas, of Stanstede, yeoman 0
3710762 1929685 1929685 defendant Rukwood Robert gent 598626 598626 Rukwood, Robert, of Stanstede, gent 3
3710766 1929686 1929686 defendant Rukwood Robert   598626 598626 Rukwood, Robert, of Stanstede 1
3710768 1929686 1929686 defendant Coppynge Thomas yeoman 598626 598626 Coppynge, Thomas, of Stanstede, yeoman 3
3712705 1930289 1930289 defendant Godfrey Thomas husbandman 598626 598626 Godfrey, Thomas, of Stanstede, husbandman 0
3712706 1930289 1930289 defendant Elyott Thomas husbandman 598626 598626 Elyott, Thomas, of Stanstede, husbandman 1
3859637 1976718 1976718 defendant Palsyer alias Palsey John, senior husbandman 598626 598626 Palsyer alias Palsey, John, senior, of Stanstede, husbandman 0
4331151 2140717 2140717 defendant Payne Thomas clothier 598626 598626 Payne, Thomas, of Stanstede, clothier 1
4403007 2165593 2165593 defendant Wakelinge Richard yeoman 598626 598626 Wakelinge, Richard, of Stanstede, yeoman 0
4411102 2168300 2168300 defendant Wakelyn Richard yeoman 598626 598626 Wakelyn, Richard, of Stanstede, yeoman 0
4429112 2173913 2173913 defendant Pole John   598626 598626 Pole, John, of Stanstede 1
4482068 2195103 2195103 defendant Eyton John   598626 598626 Eyton, John, of Stanstede 1
4507355 2202762 2202762 defendant Hook John   598626 598626 Hook, John, of Stanstede 6
4508931 2203270 2203270 defendant Chaunderye Thomas   598626 598626 Chaunderye, Thomas, of Stanstede 1
4587538 2227505 2227505 defendant Germayn Walter   598626 598626 Germayn, Walter, of Stanstede 3
4589857 2228191 2228191 defendant Litelion John   598626 598626 Litelion, John, of Stanstede 6
4608272 2233696 2233696 defendant Porter William   598626 598626 Porter, William, of Stanstede 0
4611543 2234670 2234670 defendant Porter William   598626 598626 Porter, William, of Stanstede 1
4648315 2245566 2245566 defendant Barbor John   598626 598626 Barbor, John, of Stanstede 7
4652910 2246843 2246843 defendant Germayn John husbandman 598626 598626 Germayn, John, of Stanstede, husbandman 3
4690321 2262528 2262528 defendant Hayton Richard husbandman 598626 598626 Hayton, Richard, of Stanstede, husbandman 2
4736698 2276607 2276607 defendant Bere John husbandman 598626 598626 Bere, John, of Stanstede, husbandman 2
4740566 2277755 2277755 defendant Dale John laborer 598626 598626 Dale, John, of Stanstede, laborer 0
4740567 2277755 2277755 defendant Galaunt Robert laborer 598626 598626 Galaunt, Robert, of Stanstede, laborer 1
4741718 2278071 2278071 defendant Belcham John yeoman 598626 598626 Belcham, John, of Stanstede, yeoman 2
4741719 2278071 2278071 defendant Fuller Robert yeoman 598626 598626 Fuller, Robert, of Stanstede, yeoman 3
4742763 2278390 2278390 defendant Chelmesey John carpenter 598626 598626 Chelmesey, John, of Stanstede, carpenter 0
4806874 2298356 2298356 defendant Rokesburgh William esq 598626 598626 Rokesburgh, William, of Stanstede, esq 0
4825806 2304107 2304107 defendant Jermayn Walter husbandman 598626 598626 Jermayn, Walter, of Stanstede, husbandman 0
4831429 2305864 2305864 defendant atte Moor Walter weaver 598626 598626 atte Moor, Walter, of Stanstede, weaver 0
4832658 2306236 2306236 defendant More Walter weaver 598626 598626 More, Walter, of Stanstede, weaver 0
4833479 2306478 2306478 defendant Mour Walter weaver 598626 598626 Mour, Walter, of Stanstede, weaver 0
4833480 2306478 2306478 defendant Owatlok Henry fuller 598626 598626 Owatlok, Henry, of Stanstede, fuller 1
4833481 2306478 2306478 defendant Fullere Robert yeoman 598626 598626 Fullere, Robert, of Stanstede, yeoman 2
4833486 2306479 2306479 defendant Dytton Robert yeoman 598626 598626 Dytton, Robert, of Stanstede, yeoman 0
4833488 2306479 2306479 defendant Mour Richard yeoman 598626 598626 Mour, Richard, of Stanstede, yeoman 2
4833489 2306479 2306479 defendant Mour John yeoman 598626 598626 Mour, John, of Stanstede, yeoman 3
4852070 2312078 2312078 defendant Whatlok Henry fuller 598626 598626 Whatlok, Henry, of Stanstede, fuller 0
4852766 2312284 2312284 defendant Whatlok Henry fuller 598626 598626 Whatlok, Henry, of Stanstede, fuller 2
4867186 2316697 2316697 defendant Whatlok Henry fuller 598626 598626 Whatlok, Henry, of Stanstede, fuller 1
4875195 2319195 2319195 defendant Bere Thomas butcher 598626 598626 Bere, Thomas, of Stanstede, butcher 2
4880027 2320667 2320667 defendant Whotlok Henry fuller 598626 598626 Whotlok, Henry, of Stanstede, fuller 0
4880686 2320869 2320869 defendant Whatlok Henry fuller 598626 598626 Whatlok, Henry, of Stanstede, fuller 2
4887388 2322891 2322891 defendant Bere Thomas butcher 598626 598626 Bere, Thomas, of Stanstede, butcher 3
4971812 2348497 2348497 defendant Moor Walter weaver 598626 598626 Moor, Walter, of Stanstede, weaver 0
4984415 2352271 2352271 defendant Bull William husbandman 598626 598626 Bull, William, of Stanstede Abbot, husbandman 0
4986472 2352880 2352880 defendant Whatlek Henry husbandman 598626 598626 Whatlek, Henry, of Stanstede, husbandman 3
5023242 2363701 2363701 defendant Estdoune Walter husbandman 598626 598626 Estdoune, Walter, of Stanstede, husbandman 0
5063070 2375492 2375492 defendant Cok John   598626 598626 Cok, John, of Stanstede, cook 0
5063071 2375492 2375492 defendant Watlok Henry husbandman 598626 598626 Watlok, Henry, of Stanstede, husbandman 1
5087858 2382829 2382829 defendant Assh Richard laborer 598626 598626 Assh, Richard, of Stanstede, laborer 1
5103289 2387392 2387392 defendant Norman William husbandman 598626 598626 Norman, William, of Stanstede Abbot, husbandman 2
5179373 2409704 2409704 defendant Warde John tailor 598626 598626 Warde, John, of Stanstede, tailor 0
5186070 2411675 2411675 defendant Knolle John husbandman 598626 598626 Knolle, John, of Stanstede, husbandman 0
5201868 2416312 2416312 defendant Warde John tailor 598626 598626 Warde, John, of Stanstede, tailor 0
5205059 2417236 2417236 defendant Knowe John husbandman 598626 598626 Knowe, John, of Stanstede, husbandman 0
5211487 2419096 2419096 defendant Warde John tailor 598626 598626 Warde, John, of Stanstede, tailor 0
5276117 2438090 2438090 defendant Benfeld Richard husbandman 598626 598626 Benfeld, Richard, of Stanstede, husbandman 0
5318011 2450474 2450474 defendant Northhacche John husbandman 598626 598626 Northhacche, John, of Stanstede, husbandman 2
5319420 2450900 2450900 defendant Lane John husbandman 598626 598626 Lane, John, of Stanstede, husbandman 2
5328163 2453496 2453496 defendant Clerk Thomas husbandman 598626 598626 Clerk, Thomas, of Stanstede, or of Parva Halyngbery, husbandman 4
5352901 2460993 2460993 defendant Large John husbandman 598626 598626 Large, John, of Stanstede, husbandman 0
5365060 2464742 2464742 defendant Barell Henry husbandman 598626 598626 Barell, Henry, of Stanstede, husbandman 2
5542332 2517725 2517725 defendant Bargeyn Nicholas husbandman 598626 598626 Bargeyn, Nicholas, of Stanstede Abbot, husbandman 1
5611196 2547230 2547230 defendant Rye John le   598626 598626 Rye, John le, of Stanstede 0
5628550 2552899 2552899 defendant Neweman Thomas   598626 598626 Neweman, Thomas, of Stanstede 0
5632629 2554227 2554227 defendant de Moore Robert husbandman 598626 598626 de Moore, Robert, of Stanstede, husbandman 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);