names

66 rows where place_id = 603803

✎ 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
3655825 1912077 1912077 defendant Elmer William husbandman 603803 603803 Elmer, William, of Bromyerd, husbandman 0
3668251 1916016 1916016 defendant ap Hoell Thomas yeoman 603803 603803 ap Hoell, Thomas, of Bromyerd, yeoman 0
3668252 1916016 1916016 defendant Byrd John, senior cordwainer 603803 603803 Byrd, John, senior, of Bromyerd, cordwainer 1
3668253 1916016 1916016 defendant Byrd John, junior cordwainer 603803 603803 Byrd, John, junior, of Bromyerd, cordwainer 2
3668320 1916040 1916040 defendant Bosewod Thomas carpenter 603803 603803 Bosewod, Thomas, of Bromyerd, carpenter 0
3770575 1948480 1948480 defendant Symsons John miller 603803 603803 Symsons, John, of Bromyerd, miller 0
3889962 1986879 1986879 defendant Walker George butcher 603803 603803 Walker, George, of Bromyerd, butcher 0
3889963 1986879 1986879 defendant Byrde William weaver 603803 603803 Byrde, William, of Bromyerd, weaver 1
3889964 1986879 1986879 defendant Walker Elizabeth widow 603803 603803 Walker, Elizabeth, of Bromyerd, widow 2
3894212 1988282 1988282 defendant Blunte John gent 603803 603803 Blunte, John, of Bromyerd, gent 0
3897430 1989353 1989353 defendant Walker George butcher 603803 603803 Walker, George, of Bromyerd, butcher 0
3904994 1991934 1991934 defendant Wyght Joan widow 603803 603803 Wyght, Joan, of Bromyerd, widow 3
3905505 1992111 1992111 defendant Cole Thomas butcher 603803 603803 Cole, Thomas, of Bromyerd, butcher 0
3905506 1992111 1992111 defendant Heth Thomas tanner 603803 603803 Heth, Thomas, of Bromyerd, tanner 1
3905507 1992111 1992111 defendant Walker George butcher 603803 603803 Walker, George, of Bromyerd, butcher 2
3905991 1992290 1992290 defendant Walcrofte Roger husbandman 603803 603803 Walcrofte, Roger, of Bromyerd, husbandman 3
3905998 1992292 1992292 defendant Walker George butcher 603803 603803 Walker, George, of Bromyerd, butcher 0
3905999 1992292 1992292 defendant Heth John yeoman 603803 603803 Heth, John, of Bromyerd, yeoman 1
3906000 1992292 1992292 defendant Byrd John, junior yeoman 603803 603803 Byrd, John, junior, of Bromyerd, yeoman 2
3908426 1993113 1993113 defendant Blunt John gent 603803 603803 Blunt, John, of Bromyerd, gent 0
3922242 1997749 1997749 defendant Blount John gent 603803 603803 Blount, John, of Bromyerd, gent 0
4013402 2029528 2029528 defendant Monyngton Roger gent 603803 603803 Monyngton, Roger, of Bromyerd, gent 0
4013403 2029528 2029528 defendant Uvett or Vuett William gent 603803 603803 Uvett or Vuett, William, of Bromyerd, gent 1
4013404 2029528 2029528 defendant Wedmyster Richard gent 603803 603803 Wedmyster, Richard, of Bromyerd, gent 2
4013405 2029528 2029528 defendant Gorwey Edward shoemaker 603803 603803 Gorwey, Edward, of Bromyerd, shoemaker 3
4240811 2109910 2109910 defendant Heathe Meredith gent 603803 603803 Heathe, Meredith, of Bromyerd, gent 0
4240812 2109910 2109910 defendant Bennett Robert yeoman 603803 603803 Bennett, Robert, of Bromyerd, yeoman 1
4425675 2172841 2172841 defendant Masoun John le   603803 603803 Masoun, John le, of Bromyerd, son of John 2
4504127 2201842 2201842 plaintiff Ranes William   603803 603803 Ranes, William, of Bromyerd 0
4504130 2201843 2201843 plaintiff Ranes William   603803 603803 Ranes, William, of Bromyerd 0
4585286 2226823 2226823 defendant Balle John   603803 603803 Balle, John, of Bromyerd 0
4658651 2248580 2248580 defendant Stanford Robert husbandman 603803 603803 Stanford, Robert, of Bromyerd, husbandman 0
4658652 2248580 2248580 defendant Grey John laborer 603803 603803 togehter with Grey, John, of Bromyerd, laborer 1
4688390 2261936 2261936 defendant Knight Richard chapman 603803 603803 Knight, Richard, of Bromyerd, chapman 1
4688396 2261937 2261937 defendant Knight Richard chapman 603803 603803 Knight, Richard, of Bromyerd, chapman 1
4752729 2281255 2281255 defendant Sumnour Simon chaplain 603803 603803 Sumnour, Simon, of Bromyerd, chaplain 0
4752730 2281255 2281255 defendant Broun Stephen yeoman 603803 603803 Broun, Stephen, of Bromyerd, yeoman 1
4752731 2281255 2281255 defendant Clerk John yeoman 603803 603803 Clerk, John, of Bromyerd, yeoman 2
4774533 2288021 2288021 defendant Horsenet Richard butcher 603803 603803 Horsenet, Richard, of Bromyerd, butcher 1
4786272 2291749 2291749 defendant Clerk John husbandman 603803 603803 Clerk, John, of Bromyerd, husbandman 2
4794456 2294403 2294403 defendant Broun Stephen husbandman 603803 603803 Broun, Stephen, of Bromyerd, husbandman 4
4798764 2295793 2295793 defendant Eliot Giles harper 603803 603803 Eliot, Giles, of Bromyerd, harper 0
4798765 2295793 2295793 defendant Eliot Robert weaver 603803 603803 Eliot, Robert, of Bromyerd, weaver 1
4798766 2295793 2295793 defendant Reell Hugh husbandman 603803 603803 Reell, Hugh, of Bromyerd, husbandman 2
4798768 2295793 2295793 defendant Tyler William tiler 603803 603803 Tyler, William, of Bromyerd, tiler 4
4798769 2295793 2295793 defendant Tyler John laborer 603803 603803 Tyler, John, of Bromyerd, laborer 5
4798770 2295793 2295793 defendant Strynger Richard strginger 603803 603803 Strynger, Richard, of Bromyerd, strginger 6
4798771 2295793 2295793 defendant Walker John laborer 603803 603803 Walker, John, of Bromyerd, laborer 7
4798772 2295793 2295793 defendant Sadeler John saddler 603803 603803 Sadeler, John, of Bromyerd, saddler 8
4799451 2296009 2296009 defendant Mason Walter harper 603803 603803 Mason, Walter, of Bromyerd, harper 0
4799452 2296009 2296009 defendant Strethe William pardoner 603803 603803 Strethe, William, of Bromyerd, pardoner 1
4941287 2339298 2339298 defendant Fleccher Richard weaver 603803 603803 Fleccher, Richard, of Bromyerd, weaver 1
4941288 2339298 2339298 defendant Bole Thomas husbandman 603803 603803 Bole, Thomas, of Bromyerd, husbandman 2
5028023 2365075 2365075 defendant Broun Richard gent 603803 603803 Broun, Richard, of Bromyerd, gent 0
5036496 2367535 2367535 defendant Bonde Richard smith 603803 603803 Bonde, Richard, of Bromyerd, smith 2
5273597 2437354 2437354 defendant Rowedon John gent 603803 603803 Rowedon, John, of Bromyerd, gent 0
5273599 2437354 2437354 defendant Herper Robert husbandman 603803 603803 Herper, Robert, of Bromyerd, husbandman 2
5273600 2437354 2437354 defendant Adams John butcher 603803 603803 Adams, John, of Bromyerd, butcher 3
5318061 2450489 2450489 defendant Godyng Richard smith 603803 603803 Godyng, Richard, of Bromyerd, smith 0
5318062 2450489 2450489 defendant Hill Thomas husbandman 603803 603803 Hill, Thomas, of Bromyerd, husbandman 1
5328080 2453466 2453466 defendant Wacheham William yeoman 603803 603803 Wacheham, William, of Bromyerd, yeoman 4
5550610 2520203 2520203 defendant Hardewyke Roger gent 603803 603803 Hardewyke, Roger, of Bromyerd, gent 1
5550611 2520203 2520203 defendant Pery Richard yeoman 603803 603803 Pery, Richard, of Bromyerd, yeoman 2
5624811 2551690 2551690 defendant Stodyer Stephen, junior husbandman 603803 603803 Stodyer, Stephen, junior, of Bromyerd, husbandman 0
5636748 2555437 2555437 defendant Broun Stephen husbandman 603803 603803 Broun, Stephen, of Bromyerd, husbandman 0
5636749 2555437 2555437 defendant John son of Stephen Broun ploughman 603803 603803 John, son of Stephen Broun, of Bromyerd, ploughman 1

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