names

55 rows where place_id = 592367

✎ 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
3607477 1869998 1869998 defendant Bampton Agnes widow 592367 592367 Bampton, Agnes, of Kensyngton, widow 0
3624132 1875075 1875075 defendant Bolton William yeoman 592367 592367 Bolton, William, of Kensyngton, yeoman 0
3709901 1929411 1929411 defendant Greynfeld John gent 592367 592367 Greynfeld, John, of Kensyngton, gent 2
3720115 1932568 1932568 defendant Cudde William husbandman 592367 592367 Cudde, William, of Kensyngton, husbandman 0
3726852 1934667 1934667 defendant Geffrey John yeoman 592367 592367 Geffrey, John, of Kensyngton, yeoman 0
3726853 1934667 1934667 defendant Thaccher John yeoman 592367 592367 Thaccher, John, of Kensyngton, yeoman 1
3726854 1934667 1934667 defendant Genyns Jerard yeoman 592367 592367 Genyns, Jerard, of Kensyngton, yeoman 2
3745767 1940577 1940577 defendant Graynfeld John gent 592367 592367 Graynfeld, John, of Kensyngton, gent 0
3747471 1941125 1941125 plaintiff Empson Thomas esq 592367 592367 Empson, Thomas, of Kensyngton, esq 0
3760596 1945313 1945313 defendant Warberton Peter husbandman 592367 592367 Warberton, Peter, of Kensyngton, husbandman 1
3760597 1945313 1945313 defendant Harrowe John husbandman 592367 592367 Harrowe, John, of Kensyngton, husbandman 2
3773221 1949333 1949333 defendant Hampton John carpenter 592367 592367 Hampton, John, of Kensyngton, carpenter 1
3773222 1949333 1949333 defendant Teyller John innholder 592367 592367 Teyller, John, of Kensyngton, innholder 2
3773223 1949333 1949333 defendant Preste Geoffrey yeoman 592367 592367 Preste, Geoffrey, of Kensyngton, yeoman 3
3773228 1949335 1949335 defendant Hampton John carpenter 592367 592367 Hampton, John, of Kensyngton, carpenter 1
3773229 1949335 1949335 defendant Teyler John innholder 592367 592367 Teyler, John, of Kensyngton, innholder 2
3773230 1949335 1949335 defendant Preste Geoffrey yeoman 592367 592367 Preste, Geoffrey, of Kensyngton, yeoman 3
3778892 1951113 1951113 defendant Harrys Robert yeoman 592367 592367 Harrys, Robert, of Kensyngton, yeoman 0
3781006 1951790 1951790 defendant Harrys Robert yeoman 592367 592367 Harrys, Robert, of Kensyngton, yeoman 0
3794174 1956048 1956048 defendant Culver John husbandman 592367 592367 Culver, John, of Kensyngton, husbandman 0
3838941 1970108 1970108 defendant Glover John husbandman 592367 592367 Glover, John, of Kensyngton, husbandman 1
4413831 2169222 2169222 plaintiff Burlee Geoffrey de   592367 592367 Burlee, Geoffrey de, of Kensyngton 0
4418717 2170721 2170721 defendant Borle Geoffrey de   592367 592367 Borle, Geoffrey de, of Kensyngton, vicar 0
4692888 2263282 2263282 plaintiff Bacon John   592367 592367 Bacon, John, of Kensyngton 0
4742268 2278227 2278227 defendant Cowmbe James husbandman 592367 592367 Cowmbe, James, of Kensyngton, husbandman 0
4742269 2278227 2278227 defendant Cowmbe John ploughman 592367 592367 Cowmbe, John, of Kensyngton, ploughman 1
4742272 2278228 2278228 defendant Cowmbe James husbandman 592367 592367 Cowmbe, James, of Kensyngton, husbandman 0
4742273 2278228 2278228 defendant Kowmbe John ploughman 592367 592367 Kowmbe, John, of Kensyngton, ploughman 1
4785637 2291536 2291536 defendant Shepherd Walter   592367 592367 Shepherd, Walter, of Kensyngton, shepherd 0
4785639 2291537 2291537 defendant Shepherd Walter   592367 592367 Shepherd, Walter, of Kensyngton, shepherd 0
4789099 2292646 2292646 defendant Grene Thomas skinner 592367 592367 Grene, Thomas, of Kensyngton, skinner 0
4789218 2292686 2292686 defendant Bras Thomas skinner 592367 592367 Bras, Thomas, of Kensyngton, skinner 0
4831088 2305754 2305754 defendant Haus or Hans John husbandman 592367 592367 Haus or Hans, John, of Kensyngton, husbandman 0
4839886 2308386 2308386 plaintiff Chapman John   592367 592367 Chapman, John, of Kensyngton 1
4844679 2309852 2309852 defendant Twyford John husbandman 592367 592367 Twyford, John, of Kensyngton, husbandman 0
4864718 2315935 2315935 defendant Hans or Haus John husbandman 592367 592367 Hans or Haus, John, of Kensyngton, husbandman 1
4896271 2325498 2325498 defendant Walker Alan collier 592367 592367 Walker, Alan, of Kensyngton, collier 1
4936596 2337829 2337829 defendant Hans or Haus John husbandman 592367 592367 Hans or Haus, John, of Kensyngton, husbandman 2
4936601 2337830 2337830 defendant Hans or Haus John husbandman 592367 592367 Hans or Haus, John, of Kensyngton, husbandman 2
4940149 2338949 2338949 defendant Boteler Robert yeoman 592367 592367 Boteler, Robert, of Kensyngton, yeoman 0
4975658 2349679 2349679 defendant Combe James husbandman 592367 592367 Combe, James, of Kensyngton, husbandman 1
4975659 2349679 2349679 defendant Bouche Thomas husbandman 592367 592367 Bouche, Thomas, of Kensyngton, husbandman 2
4982615 2351712 2351712 defendant Botheley Thomas laborer 592367 592367 Botheley, Thomas, of Kensyngton, laborer 2
5086464 2382434 2382434 defendant Staunton Andrew husbandman 592367 592367 Staunton, Andrew, of Kensyngton, husbandman 15
5086481 2382435 2382435 defendant Staunton Andrew husbandman 592367 592367 Staunton, Andrew, of Kensyngton, husbandman 15
5192673 2413592 2413592 defendant Bertlot Robert husbandman 592367 592367 Bertlot, Robert, of Kensyngton, husbandman 1
5301917 2445525 2445525 defendant Crosse John yeoman 592367 592367 Crosse, John, of Kensyngton, yeoman 0
5302303 2445655 2445655 defendant Blome Thomas   592367 592367 Blome, Thomas, of Kensyngton, tile maker 1
5351353 2460520 2460520 defendant Bedford Robert yeoman 592367 592367 Bedford, Robert, of Kensyngton, yeoman 0
5381031 2469630 2469630 defendant Sutcle Henry carpenter 592367 592367 Sutcle, Henry, of Kensyngton, carpenter 0
5509984 2507961 2507961 defendant Thatcher John yeoman 592367 592367 Thatcher, John, of Kensyngton, yeoman 1
5514640 2509425 2509425 defendant Brampton John husbandman 592367 592367 Brampton, John,of Kensyngton, husbandman 0
5514642 2509426 2509426 defendant Brampton John husbandman 592367 592367 Brampton, John,of Kensyngton, husbandman 0
5545784 2518758 2518758 plaintiff Stodham William yeoman 592367 592367 Stodham, William, of Kensyngton, yeoman 0
5607817 2537351 2537351 defendant Harrys Robert husbandman 592367 592367 Harrys, Robert, of Kensyngton, husbandman 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);