names

42 rows where place_id = 593655

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3612807 1871655 1871655 defendant Hogeson Nicholas butcher 593655 593655 Hogeson, Nicholas, of Eton, Bucks, butcher 4
3695412 1924788 1924788 defendant Coldrey John waterman 593655 593655 Coldrey, John, of Eton, Bucks, waterman 0
3709333 1929216 1929216 defendant Coldrey John waterman 593655 593655 Coldrey, John, of Eton, Bucks, waterman 0
3792905 1955633 1955633 defendant Furnes John trumpeter 593655 593655 Furnes, John, of Eton, Bucks, trumpeter 4
3810691 1961242 1961242 defendant Stokys Robert nrewer 593655 593655 Stokys, Robert, of Eton, Bucks, nrewer 0
3810693 1961243 1961243 defendant Thomas Robert chaplain 593655 593655 Thomas, Robert, of Eton, Bucks, chaplain 0
3853998 1974887 1974887 defendant Lupton Roger   593655 593655 Lupton, Roger, of Eton, Bucks, clerk, prepositor of Eton College 0
3875812 1982163 1982163 defendant Udall Nicholas clerk 593655 593655 Udall, Nicholas, of Eton, Bucks, clerk 0
3875814 1982164 1982164 defendant Udall Nicholas clerk 593655 593655 Udall, Nicholas, of Eton, Bucks, clerk 0
3876372 1982343 1982343 defendant Udale Nicholas clerk 593655 593655 Udale, Nicholas, of Eton, Bucks, clerk 0
3932765 2001262 2001262 plaintiff Gardener William   593655 593655 Gardener, William, of Eton, Bucks, student 0
4730098 2274614 2274614 defendant Parker William yeoman 593655 593655 Parker, William, of Eton, Bucks, yeoman 2
4868132 2317007 2317007 defendant Capron Thomas tanner 593655 593655 Capron, Thomas, of Eton, Bucks, tanner 0
4868134 2317008 2317008 defendant Capron Thomas tanner 593655 593655 Capron, Thomas, of Eton, Bucks, tanner 0
4953781 2343091 2343091 defendant Jurdeley Thomas husbandman 593655 593655 Jurdeley, Thomas, of Eton, Bucks, husbandman 0
5066403 2376479 2376479 defendant Baldok John maltman 593655 593655 Baldok, John, of Eton, Bucks, maltman 2
5077856 2379865 2379865 defendant Haynes John yeoman 593655 593655 together with Haynes, John, of Eton, Bucks, yeoman 1
5077872 2379866 2379866 defendant Haynes John yeoman 593655 593655 Haynes, John, of Eton, Bucks, yeoman 0
5112834 2390149 2390149 plaintiff Jourdeley Thomas   593655 593655 Jourdeley, Thomas, of Eton, Bucks 0
5134819 2396687 2396687 defendant Burton Richard gent 593655 593655 Burton, Richard, of Eton, Bucks, gent 0
5154720 2402534 2402534 defendant Pete Thomas smith 593655 593655 Pete, Thomas, of Eton, Bucks, smith 0
5154721 2402534 2402534 defendant Lane Thomas smith 593655 593655 Lane, Thomas, of Eton, Bucks, smith 1
5154809 2402564 2402564 defendant Burton Richard gent 593655 593655 Burton, Richard, of Eton, Bucks, gent 0
5154811 2402565 2402565 defendant Burton Richard gent 593655 593655 Burton, Richard, of Eton, Bucks, gent 0
5154813 2402566 2402566 defendant Burton Richard gent 593655 593655 Burton, Richard, of Eton, Bucks, gent 0
5171665 2407432 2407432 defendant Pete Thomas smith 593655 593655 Pete, Thomas, of Eton, Bucks, smith 0
5171666 2407432 2407432 defendant Lane Thomas smith 593655 593655 Lane, Thomas, of Eton, Bucks, smith 1
5182146 2410531 2410531 defendant Harrys John skinner 593655 593655 Harrys, John, of Eton, Bucks, skinner 0
5190330 2412914 2412914 defendant Pete Thomas smith 593655 593655 Pete, Thomas, of Eton, Bucks, smith 0
5190331 2412914 2412914 defendant Lane Thomas smith 593655 593655 Lane, Thomas, of Eton, Bucks, smith 1
5190334 2412915 2412915 defendant Pete Thomas smith 593655 593655 Pete, Thomas, of Eton, Bucks, smith 0
5190338 2412916 2412916 defendant Pete Thomas smith 593655 593655 Pete, Thomas, of Eton, Bucks, smith 0
5223296 2422506 2422506 defendant Burton John gent 593655 593655 Burton, John, of Eton, Bucks, gent 1
5249234 2429896 2429896 defendant Buknell John chapman 593655 593655 Buknell, John, of Eton, Bucks, chapman 0
5329357 2453865 2453865 defendant Osbarne John yeoman 593655 593655 Osbarne, John, of Eton, Bucks, yeoman 3
5364300 2464495 2464495 defendant Tauton or Tanton Thomas yeoman 593655 593655 Tauton or Tanton, Thomas, of Eton, Bucks, yeoman 1
5364309 2464497 2464497 defendant Tanton Thomas yeoman 593655 593655 Tanton, Thomas, of Eton, Bucks, yeoman 0
5385723 2470988 2470988 defendant Swanne William gent 593655 593655 Swanne, William, of Eton, Bucks, gent 0
5411061 2478264 2478264 defendant Swanne William gent 593655 593655 Swanne, William, of Eton, Bucks, gent 0
5479522 2498887 2498887 defendant Greywylton John   593655 593655 Greywylton, John, of Eton, Bucks, knight 0
5589947 2531839 2531839 defendant Dyer William brewer 593655 593655 Dyer, William, of Eton, Bucks, brewer 0
5597915 2534251 2534251 defendant Grey Edmund (legal representative) 593655 593655 Grey, Edmund, of Eton, Bucks, knight, Lord Grey of Wylton, executors of 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);