names

100 rows where place_id = 592252

✎ 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
3607105 1869887 1869887 defendant Freke John husbandman 592252 592252 Freke, John, of Dunmowe, husbandman 1
3662002 1914047 1914047 defendant Brower John butcher 592252 592252 Brower, John, of Dunmowe, butcher 0
3683117 1920837 1920837 defendant Johnson Thomas yeoman 592252 592252 Johnson, Thomas, of Dunmowe, yeoman 2
3693252 1924099 1924099 defendant Barrell John butcher 592252 592252 Barrell, John, of Dunmowe, butcher 2
3709233 1929184 1929184 defendant Pomfrett Miles butcher 592252 592252 Pomfrett, Miles, of Dunmowe, butcher 0
3757383 1944290 1944290 defendant Bowyer Richard tanner 592252 592252 Bowyer, Richard, of Dunmowe, tanner 0
3800101 1957956 1957956 defendant Busshopp alias Coke Robert husbandman 592252 592252 Busshopp alias Coke, Robert, of Dunmowe, husbandman 0
3805634 1959705 1959705 defendant Prentyce Joan widow 592252 592252 Prentyce, Joan, of Dunmowe, widow 1
3902043 1990913 1990913 defendant Dowe William yeoman 592252 592252 Dowe, William, of Dunmowe, yeoman 0
3950888 2007376 2007376 defendant Hawkyns Thomas yeoman 592252 592252 Hawkyns, Thomas, of Dunmowe, yeoman 4
3950889 2007376 2007376 defendant Wilson Brice smith 592252 592252 Wilson, Brice, of Dunmowe, smith 5
4240809 2109909 2109909 defendant Mortlacke John gent 592252 592252 Mortlacke, John, of Dunmowe, gent 0
4282280 2123703 2123703 defendant Glascock William yeoman 592252 592252 Glascock, William, of Dunmowe, yeoman 0
4282281 2123703 2123703 defendant Fletcher John yeoman 592252 592252 Fletcher, John, of Dunmowe, yeoman 1
4282282 2123703 2123703 defendant Revell John yeoman 592252 592252 Revell, John, of Dunmowe, yeoman 2
4282283 2123703 2123703 defendant More Thomas yeoman 592252 592252 More, Thomas, of Dunmowe, yeoman 3
4327496 2139517 2139517 defendant Carver Robert tailor 592252 592252 Carver, Robert, of Dunmowe, tailor 0
4354728 2148880 2148880 defendant Inman Edward chapman 592252 592252 Inman, Edward, of Dunmowe, chapman 3
4400066 2164610 2164610 defendant Biston Thomas gent 592252 592252 Biston, Thomas, of Dunmowe, gent 2
4441508 2182281 2182281 defendant Love William   592252 592252 Love, William, of Dunmowe 0
4441855 2182386 2182386 defendant Michel William   592252 592252 Michel, William, of Dunmowe 1
4455151 2186611 2186611 defendant Wysman William   592252 592252 Wysman, William, of Dunmowe 0
4458017 2187535 2187535 defendant Loveday Roger   592252 592252 Loveday, Roger, of Dunmowe 0
4460461 2188338 2188338 defendant Bygood John   592252 592252 Bygood, John, of Dunmowe 0
4480018 2194421 2194421 plaintiff Kiechebole Robert   592252 592252 Kiechebole, Robert, of Dunmowe 0
4493619 2198706 2198706 defendant Chercheman John   592252 592252 Chercheman, John, of Dunmowe 0
4495914 2199402 2199402 defendant Milcent William tanner 592252 592252 Milcent, William, of Dunmowe, tanner 0
4500743 2200847 2200847 defendant Sayote John   592252 592252 Sayote, John, of Dunmowe 3
4521253 2206994 2206994 defendant Chercheman John   592252 592252 Chercheman, John, of Dunmowe 3
4524770 2208086 2208086 defendant Dod Henry   592252 592252 Dod, Henry, of Dunmowe 0
4528326 2209134 2209134 defendant Dod Henry   592252 592252 Dod, Henry, of Dunmowe 3
4532503 2210432 2210432 defendant Hobbe John   592252 592252 Hobbe, John, of Dunmowe, tile maker 2
4532509 2210433 2210433 defendant Hobbe John   592252 592252 Hobbe, John, of Dunmowe, tile maker 2
4532515 2210434 2210434 defendant Hobbe John tiler 592252 592252 Hobbe, John, of Dunmowe, tiler 2
4537713 2212072 2212072 plaintiff Tannere John cooper 592252 592252 Tannere, John, of Dunmowe, cooper 0
4537715 2212073 2212073 plaintiff Tannere John cooper 592252 592252 Tannere, John, of Dunmowe, cooper 0
4584334 2226509 2226509 defendant Chercheman John   592252 592252 Chercheman, John, of Dunmowe 2
4605752 2232916 2232916 defendant Martel John   592252 592252 Martel, John, of Dunmowe 1
4607571 2233476 2233476 defendant Bocher John   592252 592252 Bocher, John, of Dunmowe 3
4618899 2236905 2236905 defendant Chepe John   592252 592252 together with Chepe, John, of Dunmowe 1
4622482 2238013 2238013 defendant Gosprest Henry   592252 592252 Gosprest, Henry, of Dunmowe 0
4643535 2244210 2244210 plaintiff Kere John   592252 592252 Kere, John, of Dunmowe 0
4643536 2244210 2244210 defendant Bryd John smith 592252 592252 Bryd, John, of Dunmowe, smith 0
4647793 2245416 2245416 defendant Arnald John   592252 592252 Arnald, John, of Dunmowe, son of Richard 3
4674383 2257598 2257598 defendant Milcent William husbandman 592252 592252 Milcent, William, of Dunmowe, husbandman 0
4677831 2258682 2258682 defendant Edward John carpetner 592252 592252 Edward, John, of Dunmowe, carpetner 1
4683461 2260429 2260429 defendant London William yeoman 592252 592252 London, William, of Dunmowe, yeoman 0
4685384 2261023 2261023 defendant Stonherd John brewer 592252 592252 Stonherd, John, of Dunmowe, brewer 1
4688302 2261909 2261909 defendant Fordham Robert   592252 592252 Fordham, Robert, of Dunmowe, prior 0
4697713 2264777 2264777 defendant Sayor John butcher 592252 592252 Sayor, John, of Dunmowe, butcher 1
4697715 2264778 2264778 plaintiff Conesby or Covesby Thomas   592252 592252 Conesby or Covesby, Thomas, of Dunmowe 0
4710795 2268732 2268732 defendant Fysshe Richard carpenter 592252 592252 Fysshe, Richard, of Dunmowe, carpenter 0
4726144 2273463 2273463 defendant Covesby Thomas yeoman 592252 592252 Covesby, Thomas, of Dunmowe, yeoman 6
4730053 2274601 2274601 defendant Arnold John husbandman 592252 592252 Arnold, John, of Dunmowe, husbandman 0
4734047 2275833 2275833 defendant Fyshe John husbandman 592252 592252 Fyshe, John, of Dunmowe, husbandman 1
4734049 2275833 2275833 defendant atte Wode John husbandman 592252 592252 atte Wode, John, of Dunmowe, husbandman 3
4744828 2279008 2279008 defendant Bocher Simon butcher 592252 592252 Bocher, Simon, of Dunmowe, butcher 2
4768784 2286215 2286215 defendant Teston Richard   592252 592252 Teston, Richard, of Dunmowe, bailiff 2
4770751 2286831 2286831 defendant Orney John husbandman 592252 592252 Orney, John, of Dunmowe, husbandman 0
4805969 2298076 2298076 defendant (not given) Richard prior of Gloucester 592252 592252 Gloucester, Richard, of Dunmowe, prior of the priory & successor to Augustine, of Dunmowe, former prior 0
4838345 2307908 2307908 plaintiff (not given) Richard prior of Gloucestre 592252 592252 Gloucestre, Richard, of Dunmowe, prior of St Mary's 0
4838375 2307916 2307916 plaintiff (not given) Richard prior of Glowecestre 592252 592252 Glowecestre, Richard, of Dunmowe, prior of the St Mary's church 0
4842656 2309239 2309239 plaintiff London William   592252 592252 London, William, of Dunmowe 0
4870040 2317596 2317596 plaintiff London William   592252 592252 London, William, of Dunmowe 0
4870204 2317649 2317649 defendant Glover Alexander husbandman 592252 592252 Glover, Alexander, of Dunmowe, husbandman 1
4870205 2317649 2317649 defendant Derby John laborer 592252 592252 Derby, John, of Dunmowe, laborer 2
4889359 2323464 2323464 defendant Ponde William   592252 592252 Ponde, William, of Dunmowe 0
4935595 2337524 2337524 defendant Myddelyng John husbandman 592252 592252 Myddelyng, John, of Dunmowe, husbandman 0
4950690 2342181 2342181 plaintiff Pecche John (legal representative) 592252 592252 Pecche, John, of Dunmowe, executor of 0
4950692 2342181 2342181 defendant Parker Nicholas husbandman 592252 592252 Parker, Nicholas, of Dunmowe, husbandman 0
4989464 2353784 2353784 defendant Dayrell Thomas gent 592252 592252 Dayrell, Thomas, of Dunmowe, gent 0
4989964 2353907 2353907 plaintiff (not given) John prior of Canon 592252 592252 Canon, John, of Dunmowe, prior of the church of the BM 0
4989966 2353908 2353908 plaintiff (not given) John prior of Canon 592252 592252 Canon, John, of Dunmowe, prior of the church of the BM 0
5051446 2372047 2372047 defendant Canon John   592252 592252 Canon, John, of Dunmowe, prior 0
5054758 2373000 2373000 plaintiff Boteler John yeoman 592252 592252 Boteler, John, of Dunmowe, yeoman 0
5058245 2374022 2374022 defendant Fuller William yeoman 592252 592252 Fuller, William, of Dunmowe, yeoman 7
5058246 2374022 2374022 defendant London John yeoman 592252 592252 London, John, of Dunmowe, yeoman 8
5084311 2381815 2381815 defendant Bate Robert weaver 592252 592252 Bate, Robert, of Dunmowe, weaver 0
5131032 2395562 2395562 defendant (not given) John prior of Orwell 592252 592252 Orwell, John, of Dunmowe, prior of the House & Church 0
5132931 2396124 2396124 defendant de Hely William   592252 592252 de Hely, William, of Dunmowe, Essex, prior 0
5152722 2401938 2401938 defendant Hely William de   592252 592252 Hely, William de, of Dunmowe, Essex, prior 0
5168106 2406383 2406383 defendant Freman Thomas yeoman 592252 592252 Freman, Thomas, of Dunmowe, yeoman 0
5188089 2412230 2412230 defendant Hely William   592252 592252 Hely, William, of Dunmowe, Essex, prior 0
5279868 2439191 2439191 defendant Joy John husbandman 592252 592252 Joy, John, of Dunmowe, husbandman 2
5279874 2439192 2439192 defendant Joy John husbandman 592252 592252 Joy, John, of Dunmowe, husbandman 2
5332388 2454752 2454752 defendant Mors Richard husbandman 592252 592252 Mors, Richard, of Dunmowe, husbandman 2
5332390 2454752 2454752 defendant Tarnet John husbandman 592252 592252 Tarnet, John, of Dunmowe, husbandman 4
5342035 2457699 2457699 defendant Ponde John butcher 592252 592252 Ponde, John, of Dunmowe, butcher 0
5371654 2466722 2466722 defendant Nele John husbandman 592252 592252 Nele, John, of Dunmowe, husbandman 0
5394531 2473495 2473495 defendant Barbour Robert fisher 592252 592252 Barbour, Robert, of Dunmowe, fisher 3
5428715 2483502 2483502 plaintiff Fuller Richard   592252 592252 Fuller, Richard, of Dunmowe 0
5445943 2488675 2488675 plaintiff Fuller Richard   592252 592252 Fuller, Richard, of Dunmowe 0
5527502 2513182 2513182 defendant Henden William yeoman 592252 592252 Henden, William, of Dunmowe, yeoman 0
5552276 2520712 2520712 defendant Forster John smith 592252 592252 Forster, John, of Dunmowe, smith 0
5591943 2532467 2532467 defendant Palgave Robert carpenter 592252 592252 Palgave, Robert, of Dunmowe, carpenter 0
5605314 2536540 2536540 defendant Bysshop Robert yeoman 592252 592252 Bysshop, Robert, of Dunmowe Prior, yeoman 0
5608992 2537714 2537714 defendant Nele John husbandman 592252 592252 Nele, John, of Dunmowe, husbandman 0
5610359 2546948 2546948 defendant Chapman Robert   592252 592252 Chapman, Robert, of Dunmowe 1
5622130 2550835 2550835 defendant Scryveyn John   592252 592252 Scryveyn, John, of Dunmowe 0
5634985 2554929 2554929 defendant Orney John husbandman 592252 592252 Orney, John, of Dunmowe, 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);