names

42 rows where place_id = 650142

✎ 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
3758283 1944586 1944586 defendant Bassowe or Dassowe Ralph   650142 650142 Bassowe or Dassowe, Ralph, of Staplehurst, "odesetter" 0
3910416 1993800 1993800 defendant Marden Peter clothier 650142 650142 Marden, Peter, of Staplehurst, clothier 1
4014614 2029948 2029948 defendant Hartnapp Thomas carpenter 650142 650142 Hartnapp, Thomas, of Staplehurst, carpenter 2
4039940 2038907 2038907 plaintiff Mascall Walter   650142 650142 Mascall, Walter, of Staplehurst, yeoman, administrators of 0
4330147 2140382 2140382 defendant Barnes Thomas   650142 650142 Barnes, Thomas, of Staplehurst, mason 2
4369976 2154318 2154318 defendant Elridge Thomas husbandman 650142 650142 Elridge, Thomas, of Staplehurst, husbandman 0
4437525 2176492 2176492 defendant Welde Nicholas de la   650142 650142 Welde, Nicholas de la, of Staplehurst 0
4543576 2213882 2213882 defendant Larke John   650142 650142 Larke, John, of Staplehurst 0
4609028 2233925 2233925 defendant Tyman Richard   650142 650142 Tyman, Richard, of Staplehurst 1
4669738 2256237 2256237 defendant atte Cherch John gent 650142 650142 atte Cherch, John, of Staplehurst, gent 0
4686748 2261466 2261466 defendant Eytherst William laborer 650142 650142 Eytherst, William, of Staplehurst, laborer 0
4694063 2263645 2263645 defendant Mapesden Thomas butcher 650142 650142 Mapesden, Thomas, of Staplehurst, butcher 1
4694929 2263905 2263905 defendant atte Cherche John gent 650142 650142 atte Cherche, John, of Staplehurst, gent 0
4703129 2266355 2266355 defendant Augeherst or Angeherst Thomas barber 650142 650142 Augeherst or Angeherst, Thomas, of Staplehurst, barber 2
4703232 2266391 2266391 defendant Roberd Thomas husbandman 650142 650142 Roberd, Thomas, of Staplehurst, husbandman 0
4711105 2268827 2268827 defendant Turbut James tailor 650142 650142 Turbut, James, of Staplehurst, tailor 1
4712739 2269297 2269297 defendant Bytherst or Gytherst William laborer 650142 650142 Bytherst or Gytherst, William, of Staplehurst, laborer 0
4712741 2269298 2269298 defendant Wolford John sawyer 650142 650142 Wolford, John, of Staplehurst, sawyer 0
4721357 2272011 2272011 defendant Ropere Joan   650142 650142 Ropere, Joan, of Staplehurst, formerly wife of John 0
4733187 2275558 2275558 defendant Godard Richard baker 650142 650142 Godard, Richard, of Staplehurst, baker 0
4757622 2282761 2282761 defendant Cobbeham William esq 650142 650142 Cobbeham, William, of Staplehurst, esq 0
4757735 2282794 2282794 defendant Potyn Walter   650142 650142 Potyn, Walter, of Staplehurst, wheel wright 0
4834898 2306915 2306915 defendant Boureman John   650142 650142 Boureman, John, of Staplehurst, shoe maker 2
4840004 2308423 2308423 plaintiff Herynden Stephen   650142 650142 Herynden, Stephen, of Staplehurst 0
4840332 2308522 2308522 defendant Chirche John husbandman 650142 650142 Chirche, John, of Staplehurst, husbandman 4
4840338 2308523 2308523 defendant Cherche John husbandman 650142 650142 Cherche, John, of Staplehurst, husbandman 4
4847211 2310627 2310627 defendant atte Forthe John butcher 650142 650142 atte Forthe, John, of Staplehurst, butcher 0
4987618 2353259 2353259 defendant Lodynden Osbert husbandman 650142 650142 Lodynden, Osbert, of Staplehurst, husbandman 0
4987619 2353259 2353259 defendant Lodynden Thomas laborer 650142 650142 Lodynden, Thomas, of Staplehurst, laborer 1
5047747 2370941 2370941 defendant Mays John husbandman 650142 650142 Mays, John, of Staplehurst, husbandman 2
5152331 2401813 2401813 defendant Chirche John husbandman 650142 650142 Chirche, John, of Staplehurst, husbandman 0
5170151 2407001 2407001 defendant Chirche John husbandman 650142 650142 Chirche, John, of Staplehurst, husbandman 0
5301171 2445310 2445310 defendant Goldham William carpenter 650142 650142 Goldham, William, of Staplehurst, carpenter 1
5379906 2469301 2469301 defendant Atcok William   650142 650142 Atcok, William, of Staplehurst 0
5401558 2475516 2475516 plaintiff Herenden John gent 650142 650142 Herenden, John, of Staplehurst, gent 0
5401956 2475617 2475617 defendant Ilchynden William   650142 650142 Ilchynden, William, of Staplehurst, coth maker 0
5409748 2477892 2477892 defendant Champe Peter (legal representative) 650142 650142 Champe, Peter, of Staplehurst, husbandman, executrix of 2
5414598 2479303 2479303 plaintiff Wanden Richard   650142 650142 Wanden, Richard, of Staplehurst 2
5419759 2480826 2480826 plaintiff Suthland Robert   650142 650142 Suthland, Robert, of Staplehurst 0
5459856 2492877 2492877 defendant Ilchynden William clothmaker 650142 650142 Ilchynden, William, of Staplehurst, clothmaker 0
5461181 2493291 2493291 defendant Hoggis Simon yeoman 650142 650142 Hoggis, Simon, of Staplehurst, yeoman 3
5472707 2496803 2496803 defendant Hoggys Simon yeoman 650142 650142 Hoggys, Simon, of Staplehurst, yeoman 3

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