names

34 rows where place_id = 588343

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3594168 1865818 1865818 defendant atte Wode William husbandman 588343 588343 atte Wode, William, of Est Ham, Essex, husbandman 1
3595786 1866316 1866316 defendant Bere Robert husbandman 588343 588343 Bere, Robert, of Est Ham, Essex, husbandman 0
3659783 1913313 1913313 defendant Hatton Thomas tailor 588343 588343 Hatton, Thomas, of East Ham, Essex, tailor 0
3665833 1915250 1915250 defendant Googe Thomas yeoman 588343 588343 Googe, Thomas, of East Ham, Essex, yeoman 5
4030607 2035607 2035607 plaintiff Eggelsfeld Francis gent 588343 588343 Eggelsfeld, Francis, of Est Ham, Essex, gent 0
4030609 2035608 2035608 plaintiff Eggelsfeld Francis gent 588343 588343 Eggelsfeld, Francis, of Est Ham, Essex, gent 0
4052704 2043397 2043397 defendant Pulliver Edward yeoman 588343 588343 Pulliver, Edward, of East Ham, Essex, yeoman 1
4065786 2048058 2048058 defendant Barker Ambrose gent 588343 588343 Barker, Ambrose, of East Ham, Essex, gent 0
4070797 2049850 2049850 defendant Ambrye John (legal representative) 588343 588343 Ambrye, John, of East Ham, Essex, yeoman, executor of 0
4072384 2050426 2050426 defendant Barker Ambrose yeoman 588343 588343 Barker, Ambrose, of East Ham, Essex, yeoman 3
4092591 2057657 2057657 defendant Rooke William gent 588343 588343 Rooke, William, of Est Ham, Essex, gent 1
4135101 2072873 2072873 defendant Walker William yeoman 588343 588343 Walker, William, of East Ham, Essex, yeoman 1
4193681 2093357 2093357 defendant Ratcliff Edmund gent 588343 588343 Ratcliff, Edmund, of East Ham, Essex, gent 2
4206698 2097882 2097882 defendant Milborne Peter yeoman 588343 588343 Milborne, Peter, of Est Ham, Essex, yeoman 0
4241355 2110093 2110093 defendant Walford Christopher yeoman 588343 588343 Walford, Christopher, of Est Ham, Essex, yeoman 2
4364012 2152186 2152186 defendant Dove William gent 588343 588343 Dove, William, of East Ham, Essex, gent 1
4782865 2290660 2290660 defendant Fotyng John husbandman 588343 588343 Fotyng, John, of Est Ham, Essex, husbandman 0
5094209 2384711 2384711 defendant Ba- Richard tailor 588343 588343 Ba-, Richard, of Est Ham, Essex, tailor 2
5126548 2394240 2394240 defendant Treblans William tailor 588343 588343 Treblans, William, of East Ham, Essex, tailor 2
5276763 2438286 2438286 defendant Tadymer John husbandman 588343 588343 Tadymer, John, of East Ham, Essex, husbandman 4
5321095 2451405 2451405 defendant Asshe John yeoman 588343 588343 Asshe, John, of Est Ham, Essex, yeoman 0
5321546 2451531 2451531 defendant Asshe John yeoman 588343 588343 Asshe, John, of Est Ham, Essex, yeoman 0
5324990 2452554 2452554 defendant Staunton John husbandman 588343 588343 Staunton, John, of Est Ham, Essex, husbandman 3
5333884 2455209 2455209 defendant Cole John laborer 588343 588343 Cole, John, of Est Ham, essex, laborer 1
5333889 2455210 2455210 defendant Cole John laborer 588343 588343 Cole, John, of Est Ham, Essex, laborer 1
5335927 2455814 2455814 defendant Toddemer John husbandman 588343 588343 Toddemer, John, of Est Ham, Essex, husbandman 2
5335931 2455815 2455815 defendant Toddemer John husbandman 588343 588343 Toddemer, John, of Est Ham, Essex, husbandman 2
5351594 2460598 2460598 defendant Baldewyn William yeoman 588343 588343 Baldewyn, William, of Est Ham, essex, yeoman 0
5351596 2460599 2460599 defendant Baldewyn William yeoman 588343 588343 Baldewyn, William, of Est Ham, essex, yeoman 0
5365533 2464893 2464893 defendant Baldewyn William husbandman 588343 588343 Baldewyn, William, of East Ham, Essex, husbandman 0
5366902 2465298 2465298 defendant Baldewyn William, senior husbandman 588343 588343 Baldewyn, William, senior, of East Ham, Essex, husbandman 0
5456208 2491769 2491769 defendant Baldewyn William, sen husbandman 588343 588343 Baldewyn, William, sen, of East Ham, Essex, husbandman 2
5467990 2495370 2495370 defendant Baldewyn William, sen husbandman 588343 588343 Baldewyn, William, sen, of East Ham, Essex, husbandman 2
5467996 2495371 2495371 defendant Baldewyn William, sen husbandman 588343 588343 Baldewyn, William, sen, of East Ham, Essex, husbandman 2

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