names

42 rows where place_id = 589702

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3598455 1867146 1867146 defendant Pulco Henry husbandman 589702 589702 Pulco, Henry, of Fynchyngfeld, Essex, husbandman 0
3598459 1867147 1867147 defendant Pulco Henry husbandman 589702 589702 Pulco, Henry, of Fynchyngfeld, Essex, husbandman 0
3598463 1867148 1867148 defendant Pulco Henry husbandman 589702 589702 Pulco, Henry, of Fynchyngfeld, Essex, husbandman 0
3669946 1916544 1916544 defendant Kempe Christopher gent 589702 589702 Kempe, Christopher, of Fynchyngfeld, Essex, gent 4
3669953 1916545 1916545 defendant Kempe Christopher gent 589702 589702 Kempe, Christopher, of Fynchyngfeld, Essex, gent 4
3784041 1952788 1952788 defendant Barners John esq 589702 589702 Barners, John, of Fynchyngfeld, Essex, esq 0
3914210 1995098 1995098 defendant Mascall William yeoman 589702 589702 Mascall, William, of Fynchyngfeld, Essex, yeoman 0
4011176 2028766 2028766 defendant Barners Francis esq 589702 589702 Barners, Francis, of Fynchyngfeld, Essex, esq 0
4018878 2031483 2031483 defendant Hamond Thomas husbandman 589702 589702 Hamond, Thomas, of Fynchyngfeld, Essex, husbandman 0
4018880 2031484 2031484 defendant Hamond Thomas husbandman 589702 589702 Hamond, Thomas, of Fynchyngfeld, Essex, husbandman 0
4086188 2055333 2055333 defendant Locker John chapman 589702 589702 Locker, John, of Fynchyngfeld, Essex, chapman 0
4501518 2201077 2201077 defendant Bilderygge William   589702 589702 Bilderygge, William, of fynchyngfeld, Essex 0
4626919 2239365 2239365 defendant Kempe Richard   589702 589702 Kempe, Richard, of Fynchyngfeld, Essex 0
4654155 2247182 2247182 defendant Kempe Richard esq 589702 589702 Kempe, Richard, of Fynchyngfeld, Essex, esq 0
4654158 2247183 2247183 defendant Kempe Richard   589702 589702 Kempe, Richard, of Fynchyngfeld, Essex 0
4655851 2247707 2247707 defendant Colbayn Thomas husbandman 589702 589702 Colbayn, Thomas, of Fynchyngfeld, Essex, husbandman 0
4655853 2247708 2247708 defendant Colbayn Thomas husbandman 589702 589702 Colbayn, Thomas, of Fynchyngfeld, Essex, husbandman 0
4664423 2250352 2250352 defendant Coupere Edmund clerk 589702 589702 Coupere, Edmund, of Fynchyngfeld, Essex, clerk 1
4664510 2250379 2250379 defendant Coupere Edmund clerk 589702 589702 Coupere, Edmund, of Fynchyngfeld, Essex, clerk 1
4691095 2262736 2262736 defendant Colbayn Thomas gent 589702 589702 Colbayn, Thomas, of Fynchyngfeld, Essex, gent 0
4753355 2281425 2281425 defendant Shelford John husbandman 589702 589702 Shelford, John, of fynchyngfeld, Essex, husbandman 3
4756837 2282503 2282503 defendant Kempe Richard esq 589702 589702 Kempe, Richard, of Fynchyngfeld, Essex, esq 0
4780676 2289954 2289954 defendant Kempe Richard esq 589702 589702 Kempe, Richard, of Fynchyngfeld, Essex, esq 0
4814296 2300576 2300576 defendant Kempe Richard husbandman 589702 589702 Kempe, Richard, of Fynchyngfeld, Essex, Bel---, William, of Suffolk, husbandman 0
4848954 2311140 2311140 defendant Brokhull John husbandman 589702 589702 Brokhull, John, of Fynchyngfeld, Essex, husbandman 1
4848962 2311141 2311141 defendant Brokhull Thomas husbandman 589702 589702 Brokhull, Thomas, of Fynchyngfeld, Essex, husbandman 2
4906209 2328533 2328533 defendant Brokhole Thomas yeoman 589702 589702 Brokhole, Thomas, of Fynchyngfeld, Essex, yeoman 4
4953078 2342887 2342887 defendant Jelion John   589702 589702 Jelion, John, of Fynchyngfeld, Essex 1
4953093 2342890 2342890 defendant Helyon John esq 589702 589702 Helyon, John, of Fynchyngfeld, Essex, esq 0
5047360 2370828 2370828 defendant Helyon John esq 589702 589702 Helyon, John, of Fynchyngfeld, Essex, esq 1
5222651 2422341 2422341 defendant Kempe William gent 589702 589702 Kempe, William, of Fynchyngfeld, Essex, gent 1
5347290 2459319 2459319 defendant Bull John laborer 589702 589702 Bull, John, of Fynchyngfeld, Essex, laborer 2
5363193 2464142 2464142 defendant Clayton Bartholomew yeoman 589702 589702 Clayton, Bartholomew, of Fynchyngfeld, Essex, yeoman 0
5410807 2478180 2478180 defendant Fynche John yeoman 589702 589702 Fynche, John, of Fynchyngfeld, Essex, yeoman 0
5424900 2482412 2482412 defendant Fycche John yeoman 589702 589702 Fycche, John, of Fynchyngfeld, Essex, yeoman 0
5425295 2482537 2482537 defendant Fycche John yeoman 589702 589702 Fycche, John, of Fynchyngfeld, Essex, yeoman 0
5462753 2493771 2493771 defendant Cleydon Bartholomew yeoman 589702 589702 Cleydon, Bartholomew, of Fynchyngfeld, Essex, yeoman 0
5521469 2511532 2511532 defendant Darkyn Thomas yeoman 589702 589702 Darkyn, Thomas, of Fynchyngfeld, Essex, yeoman 1
5522252 2511777 2511777 defendant Tabbard John husbandman 589702 589702 Tabbard, John, of Fynchyngfeld, Essex, husbandman 2
5531216 2514278 2514278 defendant Blythe John husbandman 589702 589702 Blythe, John, of Fynchyngfeld, Essex, husbandman 1
5555779 2521679 2521679 defendant Parker William husbandman 589702 589702 Parker, William, of Fynchyngfeld, Essex, husbandman 3
5606093 2536796 2536796 defendant Rande William maltman 589702 589702 Rande, William, of Fynchyngfeld, Essex, maltman 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);