names

42 rows where place_id = 588729

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595392 1866189 1866189 defendant Staffe Thomas yeoman 588729 588729 Staffe, Thomas, of Ewell, Surrey, yeoman 0
3595394 1866190 1866190 defendant Staffe Thomas yeoman 588729 588729 Staffe, Thomas, of Ewell, Surrey, yeoman 0
3644772 1908770 1908770 defendant Saunder Micholas gent 588729 588729 (Saunder, Micholas, of Ewell, Surrey, gent 1
3651269 1910764 1910764 defendant Maney Henry clerk 588729 588729 Maney, Henry, of Ewell, Surrey, clerk 1
3652648 1911162 1911162 defendant Saunders Nicholas gent 588729 588729 Saunders, Nicholas, of Ewell, Surrey, gent 1
3682195 1920536 1920536 defendant Johnson Agnes widow 588729 588729 Johnson, Agnes, of Ewell, Surrey, widow 1
3739208 1938481 1938481 defendant Hayton Thomas yeoman 588729 588729 Hayton, Thomas, of Ewell, Surrey, yeoman 0
3740415 1938863 1938863 defendant Saunder William gent 588729 588729 Saunder, William, of Ewell, Surrey, gent 1
3769757 1948195 1948195 defendant Saunder William gent 588729 588729 Saunder, William, of Ewell, Surrey, gent 1
3791862 1955301 1955301 defendant Saunder William gent 588729 588729 Saunder, William, of Ewell, Surrey, gent 0
3859710 1976748 1976748 defendant Saunder William gent 588729 588729 Saunder, William, of Ewell, Surrey, gent 1
3859737 1976758 1976758 defendant Saunder William gent 588729 588729 Saunder, William, of Ewell, Surrey, gent 1
3881280 1984008 1984008 plaintiff Saunder Henry (legal representative) 588729 588729 Saunder, Henry, of Ewell, Surrey, gent, executors of 0
3902274 1990995 1990995 plaintiff Dowse George husbandman 588729 588729 Dowse, George, of Ewell, Surrey, husbandman 0
3926685 1999259 1999259 defendant Saunder William esq 588729 588729 Saunder, William, of Ewell, Surrey, esq 0
3976911 2016492 2016492 defendant Alderton Thomas glover 588729 588729 Alderton, Thomas, of Ewell, Surrey, glover 8
4032225 2036197 2036197 defendant Saunder Nicholas esq 588729 588729 Saunder, Nicholas, of Ewell, Surrey, esq 2
4094674 2058432 2058432 defendant Saunder Nicholas esq 588729 588729 Saunder, Nicholas, of Ewell, Surrey, esq 2
4094690 2058437 2058437 defendant Saunder Nicholas esq 588729 588729 Saunder, Nicholas, of Ewell, Surrey, esq 0
4094693 2058438 2058438 defendant Saunder Nicholas esq 588729 588729 Saunder, Nicholas, of Ewell, Surrey, esq 0
4104112 2061744 2061744 defendant Smyth John clerk 588729 588729 Smyth, John, of Ewell, Surrey, clerk 0
4107819 2063073 2063073 defendant Smyth John   588729 588729 Smyth, John, of Ewell, Surrey, clerk, curate of Slingefeld, Sussex 0
4109779 2063757 2063757 defendant Smyth John clerk 588729 588729 Smyth, John, of Ewell, Surrey, clerk 0
4241069 2109998 2109998 defendant Hopkinson Edward yeoman 588729 588729 Hopkinson, Edward, of Ewell, Surrey, yeoman 0
4249951 2112964 2112964 defendant Koskynson Edward yeoman 588729 588729 Koskynson, Edward, of Ewell, Surrey, yeoman 1
4329972 2140325 2140325 defendant Smythe William tailor 588729 588729 Smythe, William, of Ewell, Surrey, tailor 1
4765834 2285313 2285313 defendant Janyng James   588729 588729 Janyng, James, of Ewell, Surrey, baillif 2
4814056 2300501 2300501 defendant Padeley John husbandman 588729 588729 Padeley, John, of Ewell, Surrey, husbandman 0
4979492 2350823 2350823 defendant Houchon John husbandman 588729 588729 Houchon, John, of Ewell, Surrey, husbandman 0
4981363 2351346 2351346 defendant Mortemer Edmund chapman 588729 588729 Mortemer, Edmund, of Ewell, Surrey, chapman 2
5054544 2372930 2372930 defendant Seton Thomas yeoman 588729 588729 Seton, Thomas, of Ewell, Surrey, yeoman 0
5102285 2387086 2387086 defendant Norman John husbandman 588729 588729 Norman, John, of Ewell, Surrey, husbandman 2
5120741 2392493 2392493 defendant White John husbandman 588729 588729 White, John, of Ewell, Surrey, husbandman 0
5179248 2409670 2409670 defendant Manser Robert yeoman 588729 588729 Manser, Robert, of Ewell, Surrey, yeoman 0
5201813 2416297 2416297 defendant Manfer or Manser Richard yeoman 588729 588729 Manfer or Manser, Richard, of Ewell, Surrey, yeoman 0
5201819 2416298 2416298 defendant Manser Robert yeoman 588729 588729 Manser, Robert, of Ewell, Surrey, yeoman 0
5321252 2451454 2451454 defendant Offyngton John yeoman 588729 588729 Offyngton, John, of Ewell, Surrey, yeoman 2
5329166 2453800 2453800 defendant Seke John yeoman 588729 588729 Seke, John, of Ewell, Surrey, yeoman 1
5441485 2487377 2487377 defendant Hoke John   588729 588729 Hoke, John, of Ewell, Surrey 0
5550453 2520153 2520153 defendant Saunder Henry gent 588729 588729 Saunder, Henry, of Ewell, Surrey, gent 0
5559530 2522747 2522747 defendant Iwardby John   588729 588729 Iwardby, John, of Ewell, Surrey, knight 1
5579693 2528730 2528730 defendant Penycord William yeoman 588729 588729 Penycord, William, of Ewell, Surrey, yeoman 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);