names

61 rows where place_id = 660592

✎ 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
3957123 2009557 2009557 defendant Chestar Thomas chapman 660592 660592 Chestar, Thomas, of Kingston on Thames, Surrey, chapman 3
3964640 2012240 2012240 defendant Snellyng George, senior chapman 660592 660592 Snellyng, George, senior, of Kingston on Thames, Surrey, chapman 0
3974971 2015808 2015808 defendant Stevens William chapman 660592 660592 Stevens, William, of Kingston on Thames, Surrey, chapman 0
3983386 2018833 2018833 defendant Snellyng George   660592 660592 Snellyng, George, of Kingston on Thames, Surrey, linen draper 0
3985800 2019685 2019685 plaintiff Ware James innholder 660592 660592 Ware, James, of Kingston on Thames, Surrey, innholder 0
4006788 2027205 2027205 defendant Gardener Robert gent 660592 660592 Gardener, Robert, of Kingston on Thames, Surrey, gent 0
4009221 2028065 2028065 defendant Harvye Thomas   660592 660592 Harvye, Thomas, of Kingston on Thames, Surrey, gent, Queen's Ordinary Footman 0
4012240 2029101 2029101 plaintiff Pyckerynge Robert (legal representative) 660592 660592 Pyckerynge, Robert, of Kingston on Thames, Surrey, yeoman, administratrix of 0
4019328 2031646 2031646 defendant Dowsett William mercer 660592 660592 Dowsett, William, of Kingston on Thames, Surrey, mercer 0
4032843 2036401 2036401 plaintiff Glynne David gent or yeoman 660592 660592 Glynne, David, of Kingston on Thames, Surrey, gent or yeoman 0
4039370 2038705 2038705 defendant Gould John husbandman 660592 660592 Gould, John, of Kingston on Thames, Surrey, husbandman 1
4040751 2039187 2039187 defendant Paltock Robert   660592 660592 Paltock, Robert, of Kingston on Thames, Surrey, woollen draper 0
4079191 2052863 2052863 plaintiff Towlarge Jertritt (legal representative) 660592 660592 Towlarge, Jertritt, of Kingston on Thames, Surrey, yeoman, executors of 0
4097832 2059555 2059555 defendant Godfrey Ralph beer brewer 660592 660592 Godfrey, Ralph, of Kingston on Thames, Surrey, beer brewer 0
4105692 2062323 2062323 defendant Tavernor Richard gent 660592 660592 Tavernor, Richard, of Kingston on Thames, Surrey, gent 3
4140708 2074915 2074915 defendant Childe Edmund mercer 660592 660592 Childe, Edmund, of Kingston on Thames, Surrey, mercer 0
4192926 2093090 2093090 defendant Blackmore Raccionabile or Rational   660592 660592 Blackmore, Raccionabile or Rational, of Kingston on Thames, Surrey, silk weaver 2
4219591 2102357 2102357 defendant Saunder Thomas esq 660592 660592 Saunder, Thomas, of Kingston on Thames, Surrey, esq 0
4252153 2113706 2113706 defendant Saunders Thomas gent 660592 660592 Saunders, Thomas, of Kingston on Thames, Surrey, gent 0
4265911 2118236 2118236 defendant Sanders Thomas gent 660592 660592 Sanders, Thomas, of Kingston on Thames, Surrey, gent 0
4280739 2123169 2123169 defendant Stoughton William butcher 660592 660592 Stoughton, William, of Kingston on Thames, Surrey, butcher 0
4289443 2126281 2126281 defendant Smythe Stephen barber surgeon 660592 660592 Smythe, Stephen, of Kingston on Thames, Surrey, barber surgeon 0
4289783 2126407 2126407 defendant Stoughton William butcher 660592 660592 Stoughton, William, of Kingston on Thames, Surrey, butcher 0
4290997 2126845 2126845 defendant Man Thomas draper 660592 660592 Man, Thomas, of Kingston on Thames, Surrey, draper 0
4294750 2128208 2128208 defendant Fetherston Leonard clerk 660592 660592 Fetherston, Leonard, of Kingston on Thames, Surrey, clerk 0
4295110 2128334 2128334 defendant Fox John butcher 660592 660592 Fox, John, of Kingston on Thames, Surrey, butcher 0
4295958 2128653 2128653 defendant Man Thomas draper 660592 660592 Man, Thomas, of Kingston on Thames, Surrey, draper 0
4357984 2150034 2150034 defendant Browne Thomas tailor 660592 660592 Browne, Thomas, of Kingston on Thames, Surrey, tailor 3
4360331 2150862 2150862 defendant Chatfeilde Stephen clerk 660592 660592 Chatfeilde, Stephen, of Kingston on Thames, Surrey, clerk 2
4371796 2154973 2154973 defendant Bignall George tailor 660592 660592 Bignall, George, of Kingston on Thames, Surrey, tailor 0
4374550 2155955 2155955 defendant Man Thomas chapman 660592 660592 Man, Thomas, of Kingston on Thames, Surrey, chapman 0
4382377 2158806 2158806 defendant Grove Thomas   660592 660592 Grove, Thomas, of Kingston on Thames, Surrey 3
4652330 2246680 2246680 defendant Somnour William summoner 660592 660592 Somnour, William, of Kingston on Thames, Surrey, summoner 2
4652363 2246687 2246687 defendant Somnour William summoner 660592 660592 Somnour, William, of Kingston on Thames, Surrey, summoner 2
4869756 2317511 2317511 defendant Dameot William husbandman 660592 660592 Dameot, William, of Kingston on Thames, Surrey, husbandman 0
4896097 2325439 2325439 defendant Tryscok John butcher 660592 660592 Tryscok, John, of Kingston on Thames, Surrey, butcher 0
4897428 2325854 2325854 defendant Credell William husbandman 660592 660592 Credell, William, of Kingston on Thames, Surrey, husbandman 0
4899226 2326400 2326400 defendant Trystok John butcher 660592 660592 Trystok, John, of Kingston on Thames, Surrey, butcher 0
4942408 2339610 2339610 defendant Dryffeld John esq 660592 660592 Dryffeld, John, of Kingston on Thames, Surrey, or of King's household, esq 3
4970272 2348061 2348061 defendant Austyn Thomas husbandman 660592 660592 Austyn, Thomas, of Kingston on Thames, Surrey, husbandman 5
4970281 2348062 2348062 defendant Austyn Thomas husbandman 660592 660592 Austyn, Thomas, of Kingston on Thames, Surrey, husbandman 5
4980928 2351231 2351231 defendant London John ironmonger 660592 660592 London, John, of Kingston on Thames, Surrey, ironmonger 0
4980932 2351232 2351232 defendant London John ironmonger 660592 660592 London, John, of Kingston on Thames, Surrey, ironmonger 0
4984826 2352392 2352392 defendant Longe Peter husbandman 660592 660592 (Longe, Peter, of Kingston on Thames, Surrey, husbandman 4
4984833 2352393 2352393 defendant Longe Peter husbandman 660592 660592 (Longe, Peter, of Kingston on Thames, Surrey, husbandman 4
5025771 2364434 2364434 defendant Corbell John dyer 660592 660592 Corbell, John, of Kingston on Thames, Surrey, dyer 1
5083915 2381692 2381692 defendant Comersall Richard chapman 660592 660592 Comersall, Richard, of Kingston on Thames, Surrey, chapman 1
5087324 2382673 2382673 defendant Bylgyn John husbandman 660592 660592 Bylgyn, John, of Kingston on Thames, Surrey, husbandman 0
5088353 2382967 2382967 defendant Gregory Thomas dyer 660592 660592 Gregory, Thomas, of Kingston on Thames, Surrey, dyer 0
5090280 2383533 2383533 defendant Merston Richard esq 660592 660592 Merston, Richard, of Kingston on Thames, Surrey, esq 0
5094177 2384701 2384701 defendant Fayreford Alexander esq 660592 660592 Fayreford, Alexander, of Kingston on Thames, Surrey, esq 4
5118104 2391728 2391728 defendant Slaythe John carpenter 660592 660592 Slaythe, John, of Kingston on Thames, Surrey, carpenter 0
5118105 2391729 2391729 plaintiff Rawelot Robert   660592 660592 Rawelot, Robert, of Kingston on Thames, Surrey 0
5119480 2392127 2392127 defendant Hampton John yeoman 660592 660592 Hampton, John, of Kingston on Thames, Surrey, yeoman 0
5119484 2392128 2392128 defendant Hampton John yeoman 660592 660592 Hampton, John, of Kingston on Thames, Surrey, yeoman 0
5119488 2392129 2392129 defendant Hampton John yeoman 660592 660592 Hampton, John, of Kingston on Thames, Surrey, yeoman 0
5216993 2420710 2420710 defendant Clerk Edmund husbandman 660592 660592 Clerk, Edmund, of Kingston on Thames, Surrey, husbandman 1
5259616 2433127 2433127 defendant Skern Robert esq 660592 660592 Skern, Robert, of Kingston on Thames, Surrey, esq 0
5259618 2433128 2433128 defendant Skern Robert esq 660592 660592 Skern, Robert, of Kingston on Thames, Surrey, esq 0
5285261 2440711 2440711 defendant Skerne Robert gent 660592 660592 Skerne, Robert, of Kingston on Thames, Surrey, gent 3
5285267 2440712 2440712 defendant Skerne Robert gent 660592 660592 Skerne, Robert, of Kingston on Thames, Surrey, gent 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);