names

91 rows where place_id = 588910

✎ 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
3595986 1866374 1866374 defendant Hardyng Thomas tailor 588910 588910 Hardyng, Thomas, of Wytham, Essex, tailor 2
3619506 1873667 1873667 defendant Quyk John yeoman 588910 588910 Quyk, John, of Wytham, Essex, yeoman 0
3628927 1903924 1903924 defendant Mone Giles yeoman 588910 588910 Mone, Giles, of Wytham, Essex, yeoman 1
3665219 1915077 1915077 defendant Mone John yeoman 588910 588910 Mone, John, of wytham, Essex, yeoman 0
3950385 2007217 2007217 defendant Songer Jerome gent 588910 588910 Songer, Jerome, of Wytham, Essex, gent 0
3954531 2008655 2008655 defendant Weston Robert husbandman 588910 588910 Weston, Robert, of Wytham, Essex, husbandman 0
3981436 2018126 2018126 defendant Songer Jerome gent 588910 588910 Songer, Jerome, of Wytham, Essex, gent 0
3983764 2018968 2018968 defendant Songar Jerome gent 588910 588910 Songar, Jerome, of Wytham, Essex, gent 0
3984794 2019317 2019317 defendant Dawny Edward tailor 588910 588910 Dawny, Edward, of Wytham, Essex, tailor 2
3985430 2019548 2019548 defendant Songer Jerome gent 588910 588910 Songer, Jerome, of Wytham, Essex, gent 0
3993103 2022282 2022282 defendant Riche Barnard gent 588910 588910 Riche, Barnard, of Wytham, Essex, gent 2
4093586 2058024 2058024 defendant Beere Thomas yeoman 588910 588910 Beere, Thomas, of Wytham, Essex, yeoman 0
4123597 2068741 2068741 defendant Songer Rokus yeoman 588910 588910 Songer, Rokus, of Wytham, Essex, yeoman 0
4128806 2070596 2070596 defendant Gentrie John (legal representative) 588910 588910 Gentrie, John, of Wytham, Essex, miller, executor of 1
4192620 2092975 2092975 defendant Cortes Vincent chapman 588910 588910 Cortes, Vincent, of Wytham, Essex, chapman 1
4198337 2094969 2094969 defendant Hunt Thomas gent 588910 588910 Hunt, Thomas, of Wytham, Essex, gent 0
4321318 2137548 2137548 defendant Armor Robert yeoman 588910 588910 Armor, Robert, of Wytham, Essex, yeoman 0
4522946 2207508 2207508 defendant Maygod William   588910 588910 Maygod, William, of Wytham, Essex 0
4522950 2207509 2207509 defendant Maygode William   588910 588910 Maygode, William, of Wytham, Essex 0
4618208 2236703 2236703 defendant Maygode William   588910 588910 Maygode, William, of Wytham, Essex 0
4662770 2249813 2249813 defendant Goodyeer John, junior yeoman 588910 588910 Goodyeer, John, junior, of Wytham, Essex, yeoman 1
4720132 2271640 2271640 defendant Escourt William clerk 588910 588910 Escourt, William, of Wytham, Essex, clerk 1
4740691 2277796 2277796 defendant Herde John butcher 588910 588910 Herde, John, of Wytham, Essex, butcher 1
4762727 2284322 2284322 defendant atte Wode William drover 588910 588910 atte Wode, William, of Wytham, Essex, drover 0
4780295 2289838 2289838 defendant atte Wode William yteoman 588910 588910 atte Wode, William, of Wytham, Essex, yteoman 2
4783130 2290738 2290738 defendant Basset Thomas gent 588910 588910 Basset, Thomas, of Wytham, Essex, gent 0
4785527 2291494 2291494 defendant atte Wode William yeoman 588910 588910 atte Wode, William, of Wytham, Essex, yeoman 0
4811892 2299833 2299833 defendant Smyth Thomas clerk 588910 588910 Smyth, Thomas, of Wytham, Essex, clerk 0
4835704 2307163 2307163 defendant atte Wode William yeoman 588910 588910 atte Wode, William, of Wytham, Essex, yeoman 0
4845965 2310244 2310244 defendant Lane Thomas   588910 588910 Lane, Thomas, of Wytham, Essex, blade smith 1
4871144 2317952 2317952 defendant atte Wode William husbandman 588910 588910 atte Wode, William, of Wytham, Essex, husbandman 1
4879023 2320366 2320366 defendant Cryer John embroiderer 588910 588910 Cryer, John, of Wytham, Essex, embroiderer 1
4880340 2320758 2320758 defendant Keryell John gent 588910 588910 (Keryell, John, of Wytham, Essex, gent 1
4881867 2321227 2321227 defendant Keriell John embroiderer 588910 588910 Keriell, John, of Wytham, Essex, embroiderer 0
4889799 2323601 2323601 defendant Borell John chapman 588910 588910 Borell, John, of Wytham, Essex, chapman 3
4894853 2325056 2325056 defendant Borell John chapman 588910 588910 Borell, John, of Wytham, Essex, chapman 3
4899263 2326411 2326411 defendant Basset Thomas gent 588910 588910 (Basset, Thomas, of Wytham, Essex, gent 1
4904693 2328076 2328076 defendant Debenham John woolman 588910 588910 Debenham, John, of Wytham, Essex, woolman 2
4907535 2328919 2328919 defendant Debenham John woolman 588910 588910 Debenham, John, of Wytham, Essex, woolman 1
4907559 2328925 2328925 defendant Debenham John woolman 588910 588910 Debenham, John, of Wytham, Essex, woolman 1
4916425 2331636 2331636 defendant Sesman William shoemaker 588910 588910 Sesman, William, of Wytham, Essex, shoemaker 1
4916429 2331637 2331637 defendant Seman William shoemaker 588910 588910 Seman, William, of Wytham, Essex, shoemaker 1
4941943 2339464 2339464 defendant Borell John chapman 588910 588910 Borell, John, of Wytham, Essex, chapman 0
4952145 2342610 2342610 defendant Debenham John merchant 588910 588910 Debenham, John, of Wytham, Essex, merchant 0
4952149 2342611 2342611 defendant Debenham John merchant 588910 588910 Debenham, John, of Wytham, Essex, merchant 0
4952153 2342612 2342612 defendant Debenham John merchant 588910 588910 Debenham, John, of Wytham, Essex, merchant 0
4993823 2355023 2355023 defendant Basset Thomas gent 588910 588910 Basset, Thomas, of Wytham, Essex, gent 0
4994481 2355216 2355216 defendant Basset Thomas gent 588910 588910 together with Basset, Thomas, of Wytham, Essex, gent 2
4994487 2355217 2355217 defendant Basset Thomas gent 588910 588910 (Basset, Thomas, of Wytham, Essex, gent 1
4998101 2356296 2356296 defendant Basset Thomas gent 588910 588910 (Basset, Thomas, of Wytham, Essex, gent 1
4998109 2356297 2356297 defendant Basset Thomas gent 588910 588910 together with Basset, Thomas, of Wytham, Essex, gent 2
4999094 2356606 2356606 defendant Basset Thomas gent 588910 588910 together with Basset, Thomas, of Wytham, Essex, gent 2
5000982 2357166 2357166 defendant Bernard William smith 588910 588910 Bernard, William, of Wytham, Essex, smith 3
5000987 2357167 2357167 defendant Bernard William smith 588910 588910 Bernard, William, of Wytham, Essex, smith 3
5021438 2363179 2363179 defendant Lamport William gent 588910 588910 Lamport, William, of Wytham, Essex, gent 0
5023874 2363893 2363893 defendant Huntyngton John osrtler 588910 588910 Huntyngton, John, of Wytham, Essex, osrtler 1
5062249 2375269 2375269 defendant Basset Thomas gent 588910 588910 Basset, Thomas, of Wytham, Essex, gent 0
5062251 2375270 2375270 defendant Basset Thomas gent 588910 588910 Basset, Thomas, of Wytham, Essex, gent 0
5063163 2375518 2375518 defendant Rykedon Thomas esq 588910 588910 Rykedon, Thomas, of Wytham, Essex, esq 0
5082177 2381165 2381165 defendant Sprodborough Richard clerk 588910 588910 Sprodborough, Richard, of Wytham, Essex, clerk 1
5087350 2382681 2382681 defendant Hardesore William tailor 588910 588910 Hardesore, William, of Wytham, Essex, tailor 0
5101916 2386982 2386982 defendant Latche Thomas dyer 588910 588910 Latche, Thomas, of Wytham, Essex, dyer 0
5110597 2389499 2389499 defendant Tyler John glover 588910 588910 Tyler, John, of Wytham, Essex, glover 1
5137392 2397448 2397448 defendant Cole Robert dyer 588910 588910 Cole, Robert, of Wytham, Essex, dyer 0
5139527 2398048 2398048 defendant Sayer Andrew husbandman 588910 588910 Sayer, Andrew, of Wytham, Essex, husbandman 0
5155403 2402732 2402732 defendant Lamport Joan widow 588910 588910 Lamport, Joan, of Wytham, Essex, widow 0
5158026 2403470 2403470 defendant Cole Robert dyer 588910 588910 Cole, Robert, of Wytham, Essex, dyer 0
5163973 2405201 2405201 defendant Hardyng William tailor 588910 588910 (Hardyng, William, of Wytham, Essex, tailor 1
5163977 2405202 2405202 defendant Hardyng William tailor 588910 588910 (Hardyng, William, of Wytham, Essex, tailor 1
5168008 2406353 2406353 defendant Cole Robert dyer 588910 588910 Cole, Robert, of Wytham, Essex, dyer 0
5173748 2408018 2408018 defendant Cole Robert dyer 588910 588910 Cole, Robert, of Wytham, Essex, dyer 0
5175285 2408464 2408464 defendant Sayer Andrew husbandman 588910 588910 Sayer, Andrew, of Wytham, Essex, husbandman 0
5198616 2415355 2415355 defendant Dowene Robert gent 588910 588910 Dowene, Robert, of Wytham, Essex, gent 0
5198618 2415356 2415356 defendant Downe Robert gent 588910 588910 Downe, Robert, of Wytham, Essex, gent 0
5210632 2418851 2418851 defendant Dowene Robert gent 588910 588910 Dowene, Robert, of Wytham, Essex, gent 0
5216858 2420670 2420670 defendant Rede Richard butcher 588910 588910 Rede, Richard, of Wytham, Essex, butcher 0
5221750 2422057 2422057 defendant Smyth John fuller 588910 588910 Smyth, John, of Wytham, Essex, fuller 0
5295992 2443815 2443815 defendant Warner John yeoman 588910 588910 Warner, John, of Wytham, Essex, yeoman 0
5332786 2454873 2454873 defendant Tatweder John fuller 588910 588910 Tatweder, John, of Wytham, Essex, fuller 0
5332788 2454874 2454874 defendant Upton William gent 588910 588910 Upton, William, of Wytham, Essex, gent 0
5332805 2454879 2454879 defendant Upton William gent 588910 588910 Upton, William, of Wytham, Essex, gent 0
5352691 2460932 2460932 defendant Houlot or Honlot Robert butcher 588910 588910 Houlot or Honlot, Robert, of Wytham, Essex, butcher 1
5356278 2462041 2462041 defendant Quyntyn Robert hosteler 588910 588910 Quyntyn, Robert, of Wytham, Essex, hosteler 1
5492660 2502718 2502718 defendant Clyfton Robert husbandman 588910 588910 Clyfton, Robert, of Wytham, Essex, husbandman 1
5529367 2513699 2513699 defendant Cheseman John yeoman 588910 588910 Cheseman, John, of Wytham, Essex, yeoman 0
5545191 2518596 2518596 defendant Brygeman William smith 588910 588910 Brygeman, William, of Wytham, Essex, smith 2
5547986 2519442 2519442 defendant Nicollys Edward yeoman 588910 588910 Nicollys, Edward, of Wytham, Essex, yeoman 3
5548413 2519570 2519570 defendant Nycollys Edward yeoman 588910 588910 Nycollys, Edward, of Wytham, Essex, yeoman 3
5551384 2520440 2520440 defendant Quyk John yeoman 588910 588910 Quyk, John, of Wytham, Essex, yeoman 0
5558344 2522391 2522391 defendant Grene William gent 588910 588910 Grene, William, of Wytham, Essex, gent 0
5587522 2531112 2531112 defendant Grene William gent 588910 588910 Grene, William, of Wytham, Essex, gent 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);