names

150 rows where place_id = 595281

✎ 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
3619829 1873778 1873778 defendant Payne Walter laborer 595281 595281 Payne, Walter, of Dounton, laborer 0
3619830 1873778 1873778 defendant Nutbeyme John laborer 595281 595281 Nutbeyme, John, of Dounton, laborer 1
3678988 1919498 1919498 defendant Semer Thomas gent 595281 595281 Semer, Thomas, of Dounton, gent 0
3693271 1924105 1924105 defendant Semar Walter yeoman 595281 595281 Semar, Walter, of Dounton, yeoman 0
3693272 1924105 1924105 defendant Semar Thomas yeoman 595281 595281 Semar, Thomas, of Dounton, yeoman 1
3697403 1925405 1925405 defendant Payne Walter husbandman 595281 595281 Payne, Walter, of Dounton, husbandman 0
3697406 1925406 1925406 defendant Payne Walter husbandman 595281 595281 Payne, Walter, of Dounton, husbandman 0
3814604 1962479 1962479 defendant Woddeshawe Thomas gent 595281 595281 Woddeshawe, Thomas, of Dounton, gent 0
3814605 1962479 1962479 defendant Kent John, senior husbandman 595281 595281 Kent, John, senior, of Dounton, husbandman 1
3818502 1963687 1963687 defendant Mapull John husbandman 595281 595281 Mapull, John, of Dounton, husbandman 0
3818507 1963689 1963689 defendant Mapull John husbandman 595281 595281 Mapull, John, of Dounton, husbandman 0
3890513 1987086 1987086 defendant Kent John husbandman 595281 595281 Kent, John, of Dounton, husbandman 0
3920626 1997246 1997246 defendant Stodeley Richard yeoman 595281 595281 Stodeley, Richard, of Dounton, yeoman 0
4003401 2025979 2025979 defendant Studley Robert yeoman 595281 595281 Studley, Robert, of Dounton, yeoman 0
4003402 2025979 2025979 defendant Fursbye Maurice husbandman 595281 595281 Fursbye, Maurice, of Dounton, husbandman 1
4003403 2025979 2025979 defendant Fursbye William husbandman 595281 595281 Fursbye, William, of Dounton, husbandman 2
4003404 2025979 2025979 defendant Frye Richard tailor 595281 595281 Frye, Richard, of Dounton, tailor 3
4067669 2048749 2048749 defendant Buttall Thomas husbandman 595281 595281 Buttall, Thomas, of Dounton, husbandman 2
4224547 2104065 2104065 defendant Stanbrooke Francis husbandman 595281 595281 Stanbrooke, Francis, of Dounton, husbandman 1
4415214 2169653 2169653 plaintiff Gove William le   595281 595281 Gove, William le, of Dounton 0
4415216 2169653 2169653 defendant Chopman Robert le   595281 595281 Chopman, Robert le, of Dounton 0
4447384 2184092 2184092 plaintiff Edyngdon Thomas   595281 595281 Edyngdon, Thomas, of Dounton 0
4447386 2184093 2184093 plaintiff Edyngdon Thomas   595281 595281 Edyngdon, Thomas, of Dounton, parson 0
4468387 2190777 2190777 defendant Cook Simon   595281 595281 Cook, Simon, of Dounton 0
4478684 2193996 2193996 defendant Upton William haulier 595281 595281 Upton, William, of Dounton, haulier 0
4483889 2195657 2195657 defendant Holewey Robert   595281 595281 Holewey, Robert, of Dounton 2
4512298 2204286 2204286 plaintiff Bosset Robert   595281 595281 Bosset, Robert, of Dounton 0
4512299 2204286 2204286 defendant Warner Robert   595281 595281 Warner, Robert, of Dounton 0
4527462 2208868 2208868 defendant Patyn John   595281 595281 Patyn, John, of Dounton 0
4549237 2215701 2215701 defendant Dekene John   595281 595281 Dekene, John, of Dounton 0
4567051 2221251 2221251 defendant Helyere William   595281 595281 Helyere, William, of Dounton 0
4567059 2221252 2221252 defendant Helyere William   595281 595281 together with Helyere, William, of Dounton 3
4569187 2221953 2221953 defendant Heliere John   595281 595281 Heliere, John, of Dounton 2
4610765 2234435 2234435 defendant Ryngewode Thomas   595281 595281 Ryngewode, Thomas, of Dounton 0
4610767 2234436 2234436 defendant Ryngwode Thomas   595281 595281 Ryngwode, Thomas, of Dounton 0
4628734 2239913 2239913 defendant Carlton William   595281 595281 Carlton, William, of Dounton 0
4641682 2243670 2243670 defendant atte Thrope Philip   595281 595281 atte Thrope, Philip, of Dounton 1
4651496 2246472 2246472 defendant Bochere John butcher 595281 595281 Bochere, John, of Dounton, butcher 1
4651986 2246555 2246555 defendant Waterton John barber 595281 595281 Waterton, John, of Dounton, barber 0
4656574 2247950 2247950 defendant Wynter John weaver 595281 595281 Wynter, John, of Dounton, weaver 0
4686176 2261272 2261272 defendant Holewey John husbandman 595281 595281 Holewey, John, of Dounton, husbandman 0
4700048 2265436 2265436 defendant Rugshawe John   595281 595281 Rugshawe, John, of Dounton, park man 0
4704266 2266711 2266711 defendant Tongle Alice widow 595281 595281 Tongle, Alice, of Dounton, widow 0
4712546 2269241 2269241 defendant Solas John carpenter 595281 595281 Solas, John, of Dounton, carpenter 0
4712550 2269242 2269242 defendant Solas John carpenter 595281 595281 Solas, John, of Dounton, carpenter 0
4725405 2273239 2273239 defendant Paternoster John husbandman 595281 595281 Paternoster, John, of Dounton, husbandman 1
4737813 2276931 2276931 defendant Upton John haulier 595281 595281 Upton, John, of Dounton, haulier 0
4737817 2276931 2276931 defendant Langport John, sen clerk 595281 595281 (Langport, John, sen, of Dounton, clerk 4
4749147 2280233 2280233 defendant Rys Thomas tailor 595281 595281 Rys, Thomas, of Dounton, tailor 0
4753483 2281467 2281467 defendant Lamport John yeoman 595281 595281 Lamport, John, of Dounton, yeoman 0
4757937 2282859 2282859 defendant Baker Thomas baker 595281 595281 Baker, Thomas, of Dounton, baker 0
4760639 2283671 2283671 defendant Vale Walter butcher 595281 595281 Vale, Walter, of Dounton, butcher 0
4763440 2284552 2284552 defendant Ball William husbandman 595281 595281 Ball, William, of Dounton, husbandman 0
4769305 2286376 2286376 defendant Lamport John clerk 595281 595281 (Lamport, John, of Dounton, clerk 2
4798867 2295821 2295821 defendant Artour John smith 595281 595281 Artour, John, of Dounton, smith 0
4798868 2295821 2295821 defendant Gie Thomas tailor 595281 595281 Gie, Thomas, of Dounton, tailor 1
4798870 2295822 2295822 defendant Wilkyn Roger husbandman 595281 595281 Wilkyn, Roger, of Dounton, husbandman 0
4798871 2295822 2295822 defendant Gardyner John tiler 595281 595281 Gardyner, John, of Dounton, tiler 1
4810890 2299524 2299524 defendant Grene Robert husbandman 595281 595281 Grene, Robert, of Dounton, husbandman 0
4810891 2299524 2299524 defendant Burton William husbandman 595281 595281 Burton, William, of Dounton, husbandman 1
4810892 2299524 2299524 defendant Holewey John tailor 595281 595281 Holewey, John, of Dounton, tailor 2
4811173 2299604 2299604 defendant James John husbandman 595281 595281 James, John, of Dounton, husbandman 2
4813719 2300400 2300400 defendant Davy John husbandman 595281 595281 Davy, John, of Dounton, husbandman 0
4818294 2301800 2301800 defendant Tresilyan Thomas tailor 595281 595281 Tresilyan, Thomas, of Dounton, tailor 0
4822274 2303046 2303046 defendant Holewey John tailor 595281 595281 Holewey, John, of Dounton, tailor 3
4822276 2303047 2303047 defendant Davy John husbandman 595281 595281 Davy, John, of Dounton, husbandman 0
4826748 2304400 2304400 defendant Lamport John husbandman 595281 595281 Lamport, John, of Dounton, husbandman 0
4852323 2312148 2312148 defendant Chalke William husbandman 595281 595281 Chalke, William, of Dounton, husbandman 2
4856647 2313459 2313459 defendant Shillyng William husbandman 595281 595281 Shillyng, William, of Dounton, husbandman 0
4859331 2314299 2314299 defendant Love Ralph carpenter 595281 595281 Love, Ralph, of Dounton, carpenter 0
4859332 2314299 2314299 defendant Hole Nicholas butcher 595281 595281 Hole, Nicholas, of Dounton, butcher 1
4859333 2314299 2314299 defendant Hole Thomas butcher 595281 595281 Hole, Thomas, of Dounton, butcher 2
4898312 2326130 2326130 defendant Gailhorn John clerk 595281 595281 Gailhorn, John, of Dounton, clerk 2
4901555 2327086 2327086 defendant Fynemark John husbandman 595281 595281 Fynemark, John, of Dounton, husbandman 9
4904393 2327988 2327988 plaintiff Bakere Thomas   595281 595281 Bakere, Thomas, of Dounton 0
4908218 2329121 2329121 defendant Artour John smith 595281 595281 Artour, John, of Dounton, smith 0
4928156 2335236 2335236 defendant Hurde William husbandman 595281 595281 Hurde, William, of Dounton, husbandman 1
4928157 2335236 2335236 defendant Boldyng William husbandman 595281 595281 Boldyng, William, of Dounton, husbandman 2
4931090 2336115 2336115 plaintiff Burton William   595281 595281 Burton, William, of Dounton 1
4933812 2336954 2336954 defendant Shillyng William husbandman 595281 595281 Shillyng, William, of Dounton, husbandman 0
4957579 2344240 2344240 defendant Shillyng William husbandman 595281 595281 Shillyng, William, of Dounton, husbandman 0
4970495 2348120 2348120 defendant Bathon Peter husbandman 595281 595281 Bathon, Peter, of Dounton, husbandman 1
4979474 2350818 2350818 plaintiff Shelyng William   595281 595281 Shelyng, William, of Dounton 0
4979541 2350839 2350839 defendant Drayton Simon yeoman 595281 595281 Drayton, Simon, of Dounton, yeoman 1
4979543 2350839 2350839 defendant Warde John carpenter 595281 595281 Warde, John, of Dounton, carpenter 3
4979551 2350841 2350841 defendant Lamport John yeoman 595281 595281 Lamport, John, of Dounton, yeoman 0
4981518 2351383 2351383 defendant Kyrkeby John butcher 595281 595281 Kyrkeby, John, of Dounton, butcher 1
4984444 2352280 2352280 defendant Ilond John butcher 595281 595281 Ilond, John, of Dounton, butcher 2
4987020 2353060 2353060 defendant Fusshe Robert husbandman 595281 595281 Fusshe, Robert, of Dounton, husbandman 1
5004259 2358138 2358138 defendant Cole Benovus husbandman 595281 595281 Cole, Benovus, of Dounton, husbandman 0
5004271 2358142 2358142 defendant Hisshecok Henry tiler 595281 595281 Hisshecok, Henry, of Dounton, tiler 2
5004273 2358142 2358142 defendant Hasteley John   595281 595281 Hasteley, John, of Dounton, mason 4
5025535 2364371 2364371 defendant Culman John clerk 595281 595281 Culman, John, of Dounton, clerk 0
5025537 2364371 2364371 defendant Wegge William husbandman 595281 595281 Wegge, William, of Dounton, husbandman 2
5030133 2365682 2365682 defendant Mapill Thomas husbandman 595281 595281 Mapill, Thomas, of Dounton, husbandman 3
5030709 2365851 2365851 defendant Hurst William husbandman 595281 595281 Hurst, William, of Dounton, husbandman 0
5046120 2370468 2370468 defendant Bachette Peter husbandman 595281 595281 Bachette, Peter, of Dounton, husbandman 0
5050739 2371846 2371846 defendant Baker Henry baker 595281 595281 Baker, Henry, of Dounton, baker 0
5050746 2371847 2371847 defendant Baker Henry baker 595281 595281 with Baker, Henry, of Dounton, baker 1
5064527 2375927 2375927 defendant Pacok Robert husbandman 595281 595281 Pacok, Robert, of Dounton, husbandman 2

Next page

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);