names

39 rows where place_id = 599551

✎ 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
3637245 1906451 1906451 defendant Johnson Robert yeoman 599551 599551 Johnson, Robert, of Ashford, yeoman 2
3637246 1906451 1906451 defendant Thorpe Robert yeoman 599551 599551 Thorpe, Robert, of Ashford, yeoman 3
4143011 2075724 2075724 defendant Evant Robert clothier 599551 599551 Evant, Robert, of Ashford, clothier 1
4192682 2092998 2092998 defendant Prince John yeoman 599551 599551 Prince, John, of Ashford, yeoman 3
4265854 2118221 2118221 defendant Amoye or Amysse or Amye Thomas   599551 599551 Amoye or Amysse or Amye, Thomas, of Ashford, yeoman, his son 1
4267762 2118850 2118850 defendant Amye George weaver 599551 599551 Amye, George, of Ashford, weaver 0
4274397 2120989 2120989 defendant Stone Robert smith 599551 599551 Stone, Robert, of Ashford, smith 2
4309112 2133342 2133342 defendant Scott Thomas tailor 599551 599551 Scott, Thomas, of Ashford, tailor 1
4321298 2137541 2137541 defendant Dillowe Edmund yeoman 599551 599551 Dillowe, Edmund, of Ashford, yeoman 1
4571769 2222755 2222755 defendant Stace William   599551 599551 Stace, William, of Ashford 0
4644638 2244519 2244519 defendant Bournman Thomas   599551 599551 Bournman, Thomas, of Ashford 5
4720404 2271716 2271716 defendant Fayerd John chandler 599551 599551 Fayerd, John, of Ashford, chandler 0
4734307 2275904 2275904 plaintiff Sandre Thomas (legal representative) 599551 599551 Sandre, Thomas, of Ashford, executors of 0
4734310 2275904 2275904 plaintiff Sandre Elizabeth   599551 599551 Sandre, Elizabeth, of Ashford, formerly wife of Thomas 3
4743423 2278606 2278606 defendant Richard-servant-Dyche Elizabeth spinster 599551 599551 Richard-servant-Dyche, Elizabeth, of Ashford, spinster 2
4760472 2283627 2283627 defendant Sprot Thomas tanner 599551 599551 Sprot, Thomas, of Ashford, tanner 1
4775821 2288438 2288438 defendant Brokman William gent 599551 599551 Brokman, William, of Ashford, gent 0
4843631 2309531 2309531 defendant May William farmer 599551 599551 May, William, of Ashford, farmer 0
4843633 2309531 2309531 defendant Peter servant of William May laborer 599551 599551 Peter, servant of William May, of Ashford, laborer 2
4847216 2310628 2310628 defendant Sprot John butcher 599551 599551 Sprot, John, of Ashford, butcher 3
4851345 2311868 2311868 defendant Sprot John butcher 599551 599551 Sprot, John, of Ashford, butcher 0
4923456 2333765 2333765 defendant Egerynden William butcher 599551 599551 Egerynden, William, of Ashford, butcher 0
5042377 2369328 2369328 defendant Wevar John chapman 599551 599551 Wevar, John, of Ashford, chapman 0
5051917 2372186 2372186 defendant Sprotte Richard yeoman 599551 599551 Sprotte, Richard, of Ashford, yeoman 1
5128826 2394916 2394916 defendant Seete Richard yeoman 599551 599551 Seete, Richard, of Ashford, yeoman 0
5146608 2400145 2400145 defendant Harry William husbandman 599551 599551 Harry, William, of Ashford, husbandman 1
5147233 2400333 2400333 defendant Sander John yeoman 599551 599551 Sander, John, of Ashford, yeoman 0
5166671 2405976 2405976 defendant Harry William husbandman 599551 599551 Harry, William, of Ashford, husbandman 1
5166681 2405979 2405979 defendant Sander John yeoman 599551 599551 Sander, John, of Ashford, yeoman 0
5171105 2407272 2407272 defendant Melle William chapman 599551 599551 Melle, William, of Ashford, chapman 0
5181638 2410371 2410371 defendant Harry William husbandman 599551 599551 Harry, William, of Ashford, husbandman 1
5200275 2415839 2415839 defendant Bordyll William husbandman 599551 599551 Bordyll, William, of Ashford, husbandman 4
5200343 2415860 2415860 defendant Sprot Richard yeoman 599551 599551 Sprot, Richard, of Ashford, yeoman 0
5418265 2480389 2480389 defendant Cote Julia widow 599551 599551 (Cote, Julia, of Ashford, widow 3
5418266 2480389 2480389 defendant Thursteyn William butcher 599551 599551 Thursteyn, William, of Ashford, butcher 4
5470440 2496079 2496079 defendant Hoke John potter 599551 599551 Hoke, John, of Ashford, potter 0
5470441 2496079 2496079 defendant Hoke Thomas potter 599551 599551 Hoke, Thomas, of Ashford, potter 1
5470442 2496079 2496079 defendant West John potter 599551 599551 West, John, of Ashford, potter 2
5470443 2496079 2496079 defendant Curle John laborer 599551 599551 Curle, John, of Ashford, laborer 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);