names

43 rows where place_id = 671067

✎ 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
4000068 2024791 2024791 plaintiff Glynne David yeoman 671067 671067 Glynne, David, of Kingston on Thames, yeoman 0
4016642 2030658 2030658 defendant Cooke John yeoman 671067 671067 Cooke, John, of Kingston on Thames, yeoman 0
4019326 2031646 2031646 plaintiff Watlington Henry (legal representative) 671067 671067 Watlington, Henry, of Kingston on Thames, carpenter, administrator of 0
4042197 2039690 2039690 plaintiff Palcocke or Paltocke Robert   671067 671067 Palcocke or Paltocke, Robert, of Kingston on Thames, woollen draper 0
4047908 2041697 2041697 defendant Smeaton William   671067 671067 Smeaton, William, of Kingston on Thames, wheelwright 0
4047909 2041697 2041697 defendant Croswell Thomas   671067 671067 Croswell, Thomas, of Kingston on Thames, wheelwright 1
4051562 2042976 2042976 defendant Rawson Peter clothier 671067 671067 Rawson, Peter, of Kingston on Thames, clothier 0
4084660 2054786 2054786 defendant Goodchilde Edmund clerk 671067 671067 Goodchilde, Edmund, of Kingston on Thames, or of Wandesworth, Surrey, clerk 1
4084661 2054786 2054786 defendant Godfrey Ralph beer brewer 671067 671067 Godfrey, Ralph, of Kingston on Thames, beer brewer 2
4275456 2121353 2121353 defendant Huberstie James yeoman 671067 671067 Huberstie, James, of Kingston on Thames, yeoman 0
4374082 2155801 2155801 defendant Glover Robert gent 671067 671067 Glover, Robert, of Kingston on Thames, gent 1
4374096 2155805 2155805 defendant Woodfall or Woodsall William haberdasher 671067 671067 Woodfall or Woodsall, William, of Kingston on Thames, haberdasher 1
4784854 2291272 2291272 plaintiff Dyamaund John   671067 671067 Dyamaund, John, of Kingston on Thames 0
4788774 2292548 2292548 plaintiff Hicklyng Edmund (legal representative) 671067 671067 Hicklyng, Edmund, of Kingston on Thames, executors of 0
4788776 2292548 2292548 plaintiff Wulfe John   671067 671067 Wulfe, John, of Kingston on Thames 2
4791495 2293434 2293434 plaintiff Studeley William   671067 671067 Studeley, William, of Kingston on Thames 1
4797021 2295230 2295230 plaintiff Skeren or Skerne Robert   671067 671067 Skeren or Skerne, Robert, of Kingston on Thames 0
4798042 2295576 2295576 defendant Broker Thomas   671067 671067 Broker, Thomas, of Kingston on Thames, franklin 0
4870212 2317652 2317652 defendant Olyver Clement laborer 671067 671067 Olyver, Clement, of Kingston on Thames, laborer 0
4870213 2317652 2317652 defendant Frenshman John laborer 671067 671067 Frenshman, John, of Kingston on Thames, laborer 1
4877984 2320067 2320067 defendant Cretell William husbandman 671067 671067 Cretell, William, of Kingston on Thames, husbandman 0
4892835 2324490 2324490 defendant Symond Clement husbandman 671067 671067 Symond, Clement, of Kingston on Thames, husbandman 0
4892836 2324490 2324490 defendant Purveour Thomas ostler 671067 671067 Purveour, Thomas, of Kingston on Thames, ostler 1
4970112 2348012 2348012 defendant Denton William husbandman 671067 671067 Denton, William, of Kingston on Thames, husbandman 0
4970271 2348061 2348061 defendant Saundres John yeoman 671067 671067 (Saundres, John, of Kingston on Thames, yeoman 4
4970280 2348062 2348062 defendant Saundres John yeoman 671067 671067 (Saundres, John, of Kingston on Thames, yeoman 4
4974793 2349431 2349431 defendant Walter Thomas fuller 671067 671067 Walter, Thomas, of Kingston on Thames, fuller 0
4978025 2350394 2350394 defendant Hoke John yeoman 671067 671067 Hoke, John, of Kingston on Thames, yeoman 0
4984827 2352392 2352392 defendant Reynold John husbandman 671067 671067 Reynold, John, of Kingston on Thames, husbandman 5
5075842 2379266 2379266 defendant Broke alias Parchemener John   671067 671067 Broke alias Parchemener, John, of Kingston on Thames, parchment maker 2
5087325 2382673 2382673 defendant Bekenore alias Saunder John husbandman 671067 671067 Bekenore alias Saunder, John, of Kingston on Thames, husbandman 1
5087326 2382673 2382673 defendant Forde William husbandman 671067 671067 Forde, William, of Kingston on Thames, husbandman 2
5118103 2391728 2391728 plaintiff Rawelot Robert   671067 671067 Rawelot, Robert, of Kingston on Thames 0
5118106 2391729 2391729 defendant Sleythe John carpenter 671067 671067 Sleythe, John, of Kingston on Thames, carpenter 0
5200277 2415840 2415840 defendant Symond Clement yeoman 671067 671067 Symond, Clement, of Kingston on Thames, yeoman 0
5216923 2420690 2420690 defendant Skern William gent 671067 671067 Skern, William, of Kingston on Thames, gent 0
5216927 2420691 2420691 defendant Skern William gent 671067 671067 Skern, William, of Kingston on Thames, gent 0
5219772 2421508 2421508 defendant Freys John sawyer 671067 671067 Freys, John, of Kingston on Thames, sawyer 0
5254377 2431498 2431498 defendant Wilkes John yeoman 671067 671067 Wilkes, John, of Kingston on Thames, yeoman 0
5254378 2431498 2431498 defendant Hert John yeoman 671067 671067 Hert, John, of Kingston on Thames, yeoman 1
5254379 2431498 2431498 defendant Raulet Robert yeoman 671067 671067 Raulet, Robert, of Kingston on Thames, yeoman 2
5254380 2431498 2431498 defendant Hampton John yeoman 671067 671067 Hampton, John, of Kingston on Thames, yeoman 3
5259346 2433043 2433043 defendant Hutte John miller 671067 671067 Hutte, John, of Kingston on Thames, miller 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);