names

93 rows where place_id = 613071

✎ 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
3696496 1925132 1925132 defendant Bawnet Richard carpenter 613071 613071 Bawnet, Richard, of Elmedon, carpenter 0
3710319 1929543 1929543 defendant Bawnet Richard carpenter 613071 613071 Bawnet, Richard, of Elmedon, carpenter 0
3710321 1929544 1929544 defendant Bawnet Richard carpenter 613071 613071 Bawnet, Richard, of Elmedon, carpenter 0
3792863 1955621 1955621 defendant Ulseby alias Wyllysby John husbandman 613071 613071 Ulseby alias Wyllysby, John, of Elmedon, husbandman 0
3810349 1961127 1961127 defendant Dalog Thomas husbandman 613071 613071 Dalog, Thomas, of Elmedon, husbandman 1
3810651 1961229 1961229 defendant Dalog Thomas husbandman 613071 613071 Dalog, Thomas, of Elmedon, husbandman 1
3859279 1976595 1976595 defendant Wyllesby John husbandman 613071 613071 Wyllesby, John, of Elmedon, husbandman 1
3864095 1978175 1978175 defendant Nasshe Richard husbandman 613071 613071 Nasshe, Richard, of Elmedon, husbandman 2
3864096 1978175 1978175 defendant More John laborer 613071 613071 More, John, of Elmedon, laborer 3
3881760 1984151 1984151 defendant More John husbandman 613071 613071 More, John, of Elmedon, husbandman 0
3882915 1984551 1984551 defendant Thurgood John husbandman 613071 613071 Thurgood, John, of Elmedon, husbandman 0
3885584 1985431 1985431 plaintiff Bendysshe John gent 613071 613071 Bendysshe, John, of Elmedon, gent 0
3889968 1986880 1986880 defendant Hylle Thomas butcher 613071 613071 Hylle, Thomas, of Elmedon, butcher 2
3899337 1989991 1989991 plaintiff Bendysshe John gent 613071 613071 Bendysshe, John, of Elmedon, gent 0
3901018 1990568 1990568 defendant Drever Robert yeoman 613071 613071 Drever, Robert, of Elmedon, yeoman 0
3901020 1990569 1990569 defendant Drever Robert yeoman 613071 613071 Drever, Robert, of Elmedon, yeoman 0
3906546 1992484 1992484 plaintiff Mede Thomas yeoman 613071 613071 Mede, Thomas, of Elmedon, yeoman 0
3909483 1993473 1993473 defendant Dryver Robert yeoman 613071 613071 Dryver, Robert, of Elmedon, yeoman 0
3923324 1998110 1998110 defendant Wolsby John husbandman 613071 613071 Wolsby, John, of Elmedon, husbandman 1
3936967 2002693 2002693 plaintiff Smyth John   613071 613071 Smyth, John, of Elmedon, black smith 1
3970173 2014166 2014166 defendant Sewyster Geoffrey gent 613071 613071 Sewyster, Geoffrey, of Elmedon, gent 1
4056050 2044548 2044548 defendant Boes Robert   613071 613071 Boes, Robert, of Elmedon, or of Netherwood Heyth, wheelwright 1
4056294 2044636 2044636 defendant Maxon Hugh yeoman 613071 613071 Maxon, Hugh, of Elmedon, yeoman 0
4103998 2061703 2061703 defendant Graves Robert laborer 613071 613071 Graves, Robert, of Elmedon, laborer 0
4104000 2061704 2061704 defendant Graves Robert laborer 613071 613071 Graves, Robert, of Elmedon, laborer 0
4104001 2061704 2061704 defendant Hunt Richard laborer 613071 613071 together with Hunt, Richard, of Elmedon, laborer 1
4232189 2106762 2106762 defendant Ketteridge John, senior blacksmith 613071 613071 Ketteridge, John, senior, of Elmedon, blacksmith 1
4294620 2128160 2128160 defendant Brooke Richard yeoman 613071 613071 Brooke, Richard, of Elmedon, yeoman 0
4408808 2167543 2167543 defendant Yate John husbandman 613071 613071 Yate, John, of Elmedon, husbandman 0
4451102 2185309 2185309 defendant atte Gate John   613071 613071 atte Gate, John, of Elmedon 3
4451365 2185396 2185396 defendant Hore Thomas le   613071 613071 Hore, Thomas le, of Elmedon 0
4456988 2187197 2187197 plaintiff Davy John   613071 613071 Davy, John, of Elmedon 1
4458418 2187674 2187674 defendant Hoore Thomas   613071 613071 Hoore, Thomas, of Elmedon 0
4539004 2212467 2212467 plaintiff Upstret John   613071 613071 Upstret, John, of Elmedon 0
4545408 2214488 2214488 defendant Garlond Andrewe   613071 613071 Garlond, Andrewe, of Elmedon 1
4545413 2214488 2214488 defendant Hecheman Richard   613071 613071 Hecheman, Richard, of Elmedon 6
4556971 2218109 2218109 defendant West William   613071 613071 West, William, of Elmedon 1
4580968 2225523 2225523 defendant Averey Henry   613071 613071 Averey, Henry, of Elmedon 1
4596386 2230120 2230120 defendant Frost John   613071 613071 Frost, John, of Elmedon 2
4600554 2231396 2231396 defendant Gerland Andrew   613071 613071 Gerland, Andrew, of Elmedon 0
4646863 2245145 2245145 defendant Lorkyn John   613071 613071 Lorkyn, John, of Elmedon 0
4674029 2257488 2257488 defendant Twyn Richard butcher 613071 613071 Twyn, Richard, of Elmedon, butcher 3
4683446 2260424 2260424 defendant Serle John husbandman 613071 613071 Serle, John, of Elmedon, husbandman 0
4711617 2268961 2268961 defendant Huchonson Alan yeoman 613071 613071 Huchonson, Alan, of Elmedon, yeoman 2
4734269 2275892 2275892 defendant Huchonson Alan husbandman 613071 613071 Huchonson, Alan, of Elmedon, husbandman 2
4735176 2276148 2276148 defendant Smyth John smith 613071 613071 Smyth, John, of Elmedon, smith 2
4748264 2280000 2280000 defendant Lucas William yeoman 613071 613071 Lucas, William, of Elmedon, yeoman 0
4811088 2299577 2299577 defendant Wildeman Robert husbandman 613071 613071 Wildeman, Robert, of Elmedon, husbandman 1
4866830 2316590 2316590 defendant Huchonson Alan yeoman 613071 613071 Huchonson, Alan, of Elmedon, yeoman 0
4899054 2326346 2326346 defendant Upstrete alias Strete Thomas husbandman 613071 613071 Upstrete alias Strete, Thomas, of Elmedon, husbandman 1
4907751 2328986 2328986 defendant Wolmer John husbandman 613071 613071 Wolmer, John, of Elmedon, husbandman 4
4934895 2337316 2337316 defendant Cok William husbandman 613071 613071 Cok, William, of Elmedon, husbandman 0
4953228 2342925 2342925 defendant Cok William husbandman 613071 613071 Cok, William, of Elmedon, husbandman 3
4953233 2342926 2342926 defendant Cok William husbandman 613071 613071 Cok, William, of Elmedon, husbandman 3
4972453 2348693 2348693 defendant Wenham Richard, senior husbandman 613071 613071 Wenham, Richard, senior, of Elmedon, husbandman 5
4972454 2348693 2348693 defendant Wenham Richard, junior husbandman 613071 613071 Wenham, Richard, junior, of Elmedon, husbandman 6
4972455 2348693 2348693 defendant Wolmar William husbandman 613071 613071 Wolmar, William, of Elmedon, husbandman 7
4976321 2349876 2349876 defendant Kyngton John collier 613071 613071 Kyngton, John, of Elmedon, collier 0
4979261 2350754 2350754 defendant Cok William husbandman 613071 613071 Cok, William, of Elmedon, husbandman 0
4980063 2350987 2350987 defendant Cok William husbandman 613071 613071 Cok, William, of Elmedon, husbandman 3
4980064 2350987 2350987 defendant Droste William husbandman 613071 613071 Droste, William, of Elmedon, husbandman 4
5014482 2361097 2361097 defendant Frost William husbandman 613071 613071 Frost, William, of Elmedon, husbandman 0
5018809 2362388 2362388 defendant Palmer John husbandman 613071 613071 Palmer, John, of Elmedon, husbandman 0
5042498 2369361 2369361 defendant Whetcok Robert husbandman 613071 613071 Whetcok, Robert, of Elmedon, husbandman 0
5044613 2370021 2370021 defendant Froft John yeoman 613071 613071 Froft, John, of Elmedon, yeoman 1
5054342 2372877 2372877 defendant Mille Richard husbandman 613071 613071 Mille, Richard, of Elmedon, husbandman 0
5070568 2377693 2377693 defendant Wenham Simon husbandman 613071 613071 Wenham, Simon, of Elmedon, husbandman 0
5076562 2379494 2379494 defendant Frost William husbandman 613071 613071 Frost, William, of Elmedon, husbandman 1
5274103 2437504 2437504 defendant Parker Robert husbandman 613071 613071 Parker, Robert, of Elmedon, husbandman 0
5274104 2437504 2437504 defendant Parker William laborer 613071 613071 Parker, William, of Elmedon, laborer 1
5274105 2437504 2437504 defendant Seerle John, junior laborer 613071 613071 Seerle, John, junior, of Elmedon, laborer 2
5274106 2437504 2437504 defendant Foster William husbandman 613071 613071 Foster, William, of Elmedon, husbandman 3
5274108 2437504 2437504 defendant Seerle John, senior butcher 613071 613071 Seerle, John, senior, of Elmedon, butcher 5
5274109 2437504 2437504 defendant Sparowe John laborer 613071 613071 Sparowe, John, of Elmedon, laborer 6
5274110 2437505 2437505 plaintiff Parker Thomas   613071 613071 Parker, Thomas, of Elmedon 0
5274111 2437505 2437505 defendant Parker Robert husbandman 613071 613071 Parker, Robert, of Elmedon, husbandman 0
5275065 2437787 2437787 defendant Parker Thomas husbandman 613071 613071 Parker, Thomas, of Elmedon, husbandman 4
5325337 2452666 2452666 plaintiff Searle John, senior butcher 613071 613071 Searle, John, senior, of Elmedon, butcher 0
5325338 2452666 2452666 defendant Parker Thomas (legal representative) 613071 613071 Parker, Thomas, of Elmedon, husbandman, executors of 0
5325339 2452666 2452666 defendant Serle John   613071 613071 (Serle, John, of Elmedon, husbandman, son of Serle, William 1
5325340 2452666 2452666 defendant Parker Margaret widow 613071 613071 Parker, Margaret, of Elmedon, widow 2
5327448 2453281 2453281 plaintiff Twyn John, senior   613071 613071 Twyn, John, senior, of Elmedon 0
5370327 2466307 2466307 defendant Robynet Thomas husbandman 613071 613071 Robynet, Thomas, of Elmedon, husbandman 2
5419096 2480638 2480638 defendant Parker John husbandman 613071 613071 Parker, John, of Elmedon, husbandman 0
5419097 2480638 2480638 defendant Parker William husbandman 613071 613071 Parker, William, of Elmedon, husbandman 1
5437261 2486085 2486085 defendant Parker John husbandman 613071 613071 Parker, John, of Elmedon, husbandman 0
5437262 2486085 2486085 defendant parker William husbandman 613071 613071 parker, William, of Elmedon, husbandman 1
5487486 2501150 2501150 defendant Twyn John husbandman 613071 613071 Twyn, John, of Elmedon, husbandman 1
5522024 2511705 2511705 defendant Twynne John husbandman 613071 613071 Twynne, John, of Elmedon, husbandman 3
5564966 2524339 2524339 defendant Smert John gent 613071 613071 Smert, John, of Elmedon, gent 1
5616414 2548931 2548931 defendant le -- Hore Thomas   613071 613071 le -- Hore, Thomas, of Elmedon 0
5622372 2550919 2550919 defendant Dunmowe John   613071 613071 Dunmowe, John, of Elmedon 1
5634736 2554861 2554861 defendant Lucas Robert farmer 613071 613071 Lucas, Robert, of Elmedon, farmer 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);