names

38 rows where place_id = 609712

✎ 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
3634086 1905459 1905459 defendant Geyffrey Thomas   609712 609712 Geyffrey, Thomas, of Yardeley, Worcs, wheelwright 2
3679941 1919792 1919792 defendant ap Thomas Godfrey yeoman 609712 609712 ap Thomas, Godfrey, of Yardeley, Worcs, yeoman 1
3816721 1963136 1963136 defendant Norres Hugh   609712 609712 Norres, Hugh, of yardeley, Worcs, tile maker 0
3834964 1968873 1968873 defendant Thomas Griffin gent 609712 609712 Thomas, Griffin, of Yardeley, Worcs, gent 2
3834969 1968874 1968874 defendant Thomas Griffin gent 609712 609712 Thomas, Griffin, of Yardeley, Worcs, gent 2
3836727 1969388 1969388 defendant Prattye John yeoman 609712 609712 Prattye, John, of Yardeley, Worcs, yeoman 0
3846772 1972543 1972543 defendant Han William husbandman 609712 609712 Han, William, of Yardeley, Worcs, husbandman 0
3862271 1977568 1977568 defendant Han William husbandman 609712 609712 Han, William, of Yardeley, Worcs, husbandman 0
3893903 1988183 1988183 defendant Knyght Humphrey yeoman 609712 609712 Knyght, Humphrey, of Yardeley, Worcs, yeoman 0
3895489 1988699 1988699 defendant Corser Thomas yeoman 609712 609712 Corser, Thomas, of Yardeley, Worcs, yeoman 1
3921728 1997610 1997610 plaintiff Prattye John gent 609712 609712 Prattye, John, of Yardeley, Worcs, gent 0
3954117 2008513 2008513 defendant Holmes Isabel widow 609712 609712 Holmes, Isabel, of Yardeley, Worcs, widow 1
3969135 2013814 2013814 defendant Swyfte William yeoman 609712 609712 Swyfte, William, of Yardeley, Worcs, yeoman 0
3975995 2016171 2016171 plaintiff Jefferey John yeoman 609712 609712 Jefferey, John, of Yardeley, Worcs, yeoman 0
3976779 2016445 2016445 defendant Est Edward esq 609712 609712 Est, Edward, of Yardeley, Worcs, esq 0
4000763 2025040 2025040 defendant Astell William gent 609712 609712 Astell, William, of Yardeley, Worcs, gent 1
4025384 2033737 2033737 defendant Raynold Richard butcher 609712 609712 Raynold, Richard, of Yardeley, Worcs, butcher 1
4037289 2038000 2038000 defendant Swyfte Simon yeoman or blacksmith 609712 609712 Swyfte, Simon, of Yardeley, Worcs, yeoman or blacksmith 0
4037293 2038001 2038001 defendant Swyfte Simon blacksmith 609712 609712 Swyfte, Simon, of Yardeley, Worcs, yeoman, blacksmith 0
4061842 2046631 2046631 defendant Dolphyn Ralph husbandman 609712 609712 Dolphyn, Ralph, of Yardeley, Worcs, husbandman 2
4061843 2046631 2046631 defendant Barrowe or Borrowe Thomas husbandman 609712 609712 Barrowe or Borrowe, Thomas, of Yardeley, Worcs, husbandman 3
4068332 2048973 2048973 defendant Heythe Humphrey   609712 609712 Heythe, Humphrey, of Yardeley, Worcs, wheelwright 2
4101189 2060735 2060735 defendant Heath Humphrey   609712 609712 Heath, Humphrey, of Yardeley, Worcs, wheelwright 1
4103415 2061505 2061505 defendant Brocke William   609712 609712 Brocke, William, of Yardeley, Worcs, scythe smith 0
4171953 2085653 2085653 defendant Mytchell Robert yeoman 609712 609712 Mytchell, Robert, of Yardeley, Worcs, yeoman 0
4219159 2102197 2102197 defendant Hann or Hannes William yeoman 609712 609712 Hann or Hannes, William, of Yardeley, Worcs, yeoman 0
4225233 2104294 2104294 defendant Barrowe Thomas yeoman 609712 609712 Barrowe, Thomas, of Yardeley, Worcs, yeoman 0
4228175 2105336 2105336 defendant Hann or Hannes William yeoman 609712 609712 Hann or Hannes, William, of Yardeley, Worcs, yeoman 0
4286021 2125054 2125054 defendant Orpwood Thomas yeoman 609712 609712 Orpwood, Thomas, of Yardeley, Worcs, yeoman 0
4297929 2129360 2129360 defendant Holmes Elizabeth widow 609712 609712 Holmes, Elizabeth, of Yardeley, Worcs, widow 3
4379701 2157836 2157836 defendant Richard John yeoman 609712 609712 Richard, John, of Yardeley, Worcs, yeoman 0
4957782 2344299 2344299 defendant Fulleford John tailor 609712 609712 Fulleford, John, of Yardeley, Worcs, tailor 2
5323396 2452073 2452073 defendant Fox William   609712 609712 Fox, William, of Yardeley, Worcs 0
5365031 2464734 2464734 defendant Farre Thomas yeoman 609712 609712 Farre, Thomas, of Yardeley, Worcs, yeoman 0
5408471 2477503 2477503 defendant Colchester John husbandman 609712 609712 Colchester, John, of Yardeley, Worcs, husbandman 4
5535437 2515612 2515612 defendant Hygyns John carpenter 609712 609712 Hygyns, John, of Yardeley, Worcs, carpenter 0
5573806 2526905 2526905 defendant Belame Robert   609712 609712 Belame, Robert, of Yardeley, Worcs, wheelwright 0
5587993 2531256 2531256 defendant Cotrell John   609712 609712 Cotrell, John, of Yardeley, Worcs, husbandman, son of Cotrell, William 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);