names

37 rows where place_id = 597625

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3629233 1904011 1904011 defendant Payn Simon yeoman 597625 597625 Payn, Simon, of Eggeware, yeoman 3
3646240 1909215 1909215 defendant Smylte Thomas tailor 597625 597625 Smylte, Thomas, of Eggeware, tailor 0
3646241 1909215 1909215 defendant Stambrigge John carpenter 597625 597625 Stambrigge, John, of Eggeware, carpenter 1
3646242 1909215 1909215 defendant Hopcop Simon laborer 597625 597625 Hopcop, Simon, of Eggeware, laborer 2
3646243 1909215 1909215 defendant Cristemas William laborer 597625 597625 Cristemas, William, of Eggeware, laborer 3
3646244 1909215 1909215 defendant Frenche Roger collier 597625 597625 Frenche, Roger, of Eggeware, collier 4
3646245 1909215 1909215 defendant Lawrence Thomas collier 597625 597625 Lawrence, Thomas, of Eggeware, collier 5
3646628 1909350 1909350 defendant Sheppard Robert yeoman 597625 597625 Sheppard, Robert, of Eggeware, yeoman 0
3646630 1909351 1909351 defendant Sheppard Robert yeoman 597625 597625 Sheppard, Robert, of Eggeware, yeoman 0
3662957 1914326 1914326 defendant Mowse John   597625 597625 (Mowse, John, of Eggeware, malt man 3
3760751 1945363 1945363 defendant Colman Humphrey yeoman 597625 597625 Colman, Humphrey, of Eggeware, yeoman 0
3885211 1985305 1985305 defendant Hoddysdon Simon yeoman 597625 597625 Hoddysdon, Simon, of Eggeware, yeoman 0
4492829 2198463 2198463 defendant Ireby John   597625 597625 Ireby, John, of Eggeware 1
4764964 2285018 2285018 defendant Alcote William husbandman 597625 597625 Alcote, William, of Eggeware, husbandman 1
4882093 2321298 2321298 defendant Cotes William husbandman 597625 597625 Cotes, William, of Eggeware, husbandman 0
4974067 2349206 2349206 defendant Dawe William yeoman 597625 597625 Dawe, William, of Eggeware, yeoman 4
4991903 2354466 2354466 defendant Stanet John yeoman 597625 597625 Stanet, John, of Eggeware, yeoman 0
5028324 2365165 2365165 defendant Hychcok Walter (legal representative) 597625 597625 Hychcok, Walter, of Eggeware, husbandman, executrix of 0
5029364 2365465 2365465 defendant Walkere John tilemaker 597625 597625 Walkere, John, of Eggeware, tilemaker 1
5106040 2388203 2388203 defendant Grafton John laborer 597625 597625 Grafton, John, of Eggeware, laborer 0
5150580 2401313 2401313 defendant Robert John laborer 597625 597625 Robert, John, of Eggeware, laborer 0
5293977 2443210 2443210 defendant Ayleward Richard husbandman 597625 597625 Ayleward, Richard, of Eggeware, husbandman 0
5303029 2445895 2445895 defendant Bunde William laborer 597625 597625 Bunde, William, of Eggeware, laborer 2
5325603 2452735 2452735 defendant Edmond William (legal representative) 597625 597625 Edmond, William, of Eggeware, maltman, executor of 0
5333706 2455154 2455154 defendant Byrde Thomas husbandman 597625 597625 Byrde, Thomas, of Eggeware, husbandman 2
5333707 2455154 2455154 defendant Byrde Richard husbandman 597625 597625 Byrde, Richard, of Eggeware, husbandman 3
5354541 2461494 2461494 defendant Shepherd Richard wheeler 597625 597625 Shepherd, Richard, of Eggeware, wheeler 1
5363902 2464361 2464361 defendant Chalkhyll Peter husbandman 597625 597625 Chalkhyll, Peter, of Eggeware, husbandman 0
5386355 2471164 2471164 defendant Coke Thomas tanner 597625 597625 Coke, Thomas, of Eggeware, tanner 1
5396517 2474096 2474096 defendant Burton Bartholomew gent 597625 597625 Burton, Bartholomew, of Eggeware, gent 3
5409786 2477901 2477901 defendant Burton Bartholomew gent 597625 597625 Burton, Bartholomew, of Eggeware, gent 3
5409792 2477902 2477902 defendant Burton Bartholomew gent 597625 597625 Burton, Bartholomew, of Eggeware, gent 3
5411733 2478461 2478461 defendant Coke Thomas tanner 597625 597625 Coke,Thomas, of Eggeware, tanner 1
5462944 2493829 2493829 defendant Hopcote John collier 597625 597625 Hopcote, John, of Eggeware, collier 0
5495120 2503438 2503438 defendant Holbek Bartholomew gent 597625 597625 Holbek, Bartholomew, of Eggeware, gent 0
5499710 2504855 2504855 defendant Habcok John husbandman 597625 597625 Habcok, John, of Eggeware, husbandman 4
5633589 2554500 2554500 defendant Lestraunge Roger   597625 597625 Lestraunge, Roger, of Eggeware, knight 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);