names

41 rows where place_id = 600982

✎ 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
3643417 1908366 1908366 defendant Beche Lawrence tanner 600982 600982 Beche, Lawrence, of Penshurst, tanner 0
3689444 1922857 1922857 defendant Wodegate Walter yeoman 600982 600982 Wodegate, Walter, of Penshurst, yeoman 1
3689445 1922857 1922857 defendant Williamson George laborer 600982 600982 Williamson, George, of Penshurst, laborer 2
3690403 1923163 1923163 defendant Cobham Reginald gent 600982 600982 Cobham, Reginald, of Penshurst, gent 0
3690404 1923163 1923163 defendant Sevar Henry laborer 600982 600982 Sevar, Henry, of Penshurst, laborer 1
3725627 1934305 1934305 plaintiff Stapull Stephen (legal representative) 600982 600982 Stapull, Stephen, of Penshurst, executor of 0
3865018 1978500 1978500 defendant Saxby Joan widow 600982 600982 Saxby, Joan, of Penshurst, widow 2
3954849 2008762 2008762 defendant Cowdrey William gent 600982 600982 Cowdrey, William, of Penshurst, gent 0
4170780 2085272 2085272 defendant Maynard Richard yeoman 600982 600982 Maynard, Richard, of Penshurst, yeoman 1
4515014 2205104 2205104 defendant Salman William   600982 600982 Salman, William, of Penshurst 0
4638182 2242710 2242710 defendant Cook John   600982 600982 Cook, John, of Penshurst 0
4700332 2265520 2265520 defendant Lad William husbandman 600982 600982 Lad, William, of Penshurst, husbandman 0
4707766 2267797 2267797 defendant Bakere John husbandman 600982 600982 Bakere, John, of Penshurst, husbandman 0
4707767 2267797 2267797 defendant Sweyneslond William husbandman 600982 600982 Sweyneslond, William, of Penshurst, husbandman 1
4707768 2267797 2267797 defendant atte Grene John thatcher 600982 600982 atte Grene, John, of Penshurst, thatcher 2
4707772 2267797 2267797 defendant Vedde Richard husbandman 600982 600982 Vedde, Richard, of Penshurst, husbandman 6
4707773 2267797 2267797 defendant Hamond Richard   600982 600982 Hamond, Richard, of Penshurst, shoe maker 7
4711588 2268949 2268949 defendant Michell John   600982 600982 Michell, John, of Penshurst, cook 0
4711590 2268950 2268950 defendant Handen John laborer 600982 600982 Handen, John, of Penshurst, laborer 0
4724155 2272848 2272848 defendant Fyssher John   600982 600982 Fyssher, John, of Penshurst, of farmer 1
4769105 2286316 2286316 defendant Kyng Roger husbandman 600982 600982 Kyng, Roger, of Penshurst, husbandman 11
4807832 2298635 2298635 defendant Astan Joan spinster 600982 600982 Astan, Joan, of Penshurst, spinster 0
4818190 2301763 2301763 defendant Hampton Thomas shoemaker 600982 600982 Hampton, Thomas, of Penshurst, shoemaker 0
4822750 2303195 2303195 defendant Bolt John husbandman 600982 600982 Bolt, John, of Penshurst, husbandman 0
4822751 2303195 2303195 defendant Brundwell Nicholas husbandman 600982 600982 Brundwell, Nicholas, of Penshurst, husbandman 1
4902195 2327296 2327296 defendant Hampton John husbandman 600982 600982 Hampton, John, of Penshurst, husbandman 1
4913146 2330609 2330609 defendant Wellys Geoffrey husbandman 600982 600982 Wellys, Geoffrey, of Penshurst, husbandman 0
5010319 2359887 2359887 defendant Foster John husbandman 600982 600982 Foster, John, of Penshurst, husbandman 0
5020137 2362778 2362778 plaintiff Dorkynhole Robert   600982 600982 Dorkynhole, Robert, of Penshurst 0
5081474 2380957 2380957 plaintiff Crudde Richard, junior   600982 600982 Crudde, Richard, junior, of Penshurst 0
5165691 2405707 2405707 defendant Derkyngholl Walter gent 600982 600982 Derkyngholl, Walter, of Penshurst, gent 0
5183394 2410883 2410883 defendant atte Chambre Richard yeoman 600982 600982 atte Chambre, Richard, of Penshurst, yeoman 2
5202181 2416400 2416400 defendant Derkyngholl Walter gent 600982 600982 Derkyngholl, Walter, of Penshurst, gent 0
5203876 2416885 2416885 defendant atte Chambre Richard yeoman 600982 600982 atte Chambre, Richard, of Penshurst, yeoman 4
5377221 2468462 2468462 defendant Bolt John, junior laborer 600982 600982 Bolt, John, junior, of Penshurst, laborer 4
5377222 2468462 2468462 defendant Hert John yeoman 600982 600982 Hert, John, of Penshurst, yeoman 5
5426561 2482890 2482890 defendant Dorkynghole Walter husbandman 600982 600982 Dorkynghole, Walter, of Penshurst, husbandman 0
5590886 2532124 2532124 defendant Eden Paul gent 600982 600982 Eden, Paul, of Penshurst, gent 1
5608638 2537602 2537602 defendant (illegible) (illegible) husbandman 600982 600982 --, --, of Penshurst, husbandman 0
5624079 2551478 2551478 defendant Sorell William husbandman 600982 600982 Sorell, William, of Penshurst, husbandman 0
5629168 2553096 2553096 defendant Sorell William husbandman 600982 600982 Sorell, William, of Penshurst, husbandman 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);