names

71 rows where place_id = 603786

✎ 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
3655765 1912064 1912064 plaintiff Broun John   603786 603786 Broun, John, of Dersham 0
3686405 1921901 1921901 defendant Broun John yeoman 603786 603786 Broun, John, of Dersham, yeoman 0
3745359 1940455 1940455 plaintiff Broun John   603786 603786 Broun, John, of Dersham 0
3793762 1955913 1955913 plaintiff Browne John   603786 603786 Browne, John, of Dersham 0
3812302 1961742 1961742 defendant Brown John yeoman 603786 603786 Brown, John, of Dersham, yeoman 0
3842226 1971113 1971113 defendant Browne John yeoman 603786 603786 Browne, John, of Dersham, yeoman 0
3842448 1971175 1971175 plaintiff Brown John yeoman 603786 603786 Brown, John, of Dersham, yeoman 0
3842450 1971176 1971176 plaintiff Brown John yeoman 603786 603786 Brown, John, of Dersham, yeoman 0
3842452 1971177 1971177 plaintiff Brown John yeoman 603786 603786 Brown, John, of Dersham, yeoman 0
3880830 1983857 1983857 plaintiff Reve Henry (legal representative) 603786 603786 Reve, Henry, of Dersham, executors of 0
3881819 1984171 1984171 defendant Drane Thomas smith 603786 603786 Drane, Thomas, of Dersham, smith 3
3887006 1985917 1985917 defendant Barnard Reginald gent 603786 603786 Barnard, Reginald, of Dersham, gent 2
3890041 1986904 1986904 defendant Capon William carpenter 603786 603786 Capon, William, of Dersham, carpenter 2
3899823 1990153 1990153 defendant Baldewyn John (legal representative) 603786 603786 Baldewyn, John, of Dersham, executors of 0
3965636 2012595 2012595 defendant Guybon John gent 603786 603786 Guybon, John, of Dersham, gent 1
3965639 2012597 2012597 plaintiff Bedyngfeld Edmund esq 603786 603786 Bedyngfeld, Edmund, of Dersham, esq 0
3971606 2014630 2014630 defendant Eyre Thomas gent 603786 603786 Eyre, Thomas, of Dersham, gent 0
3980709 2017862 2017862 defendant Guybon John gent 603786 603786 Guybon, John, of Dersham, gent 0
3985415 2019544 2019544 defendant Robson Reginald husbandman 603786 603786 Robson, Reginald, of Dersham, husbandman 0
3985420 2019545 2019545 defendant Robson Reginald husbandman 603786 603786 Robson, Reginald, of Dersham, husbandman 0
4305077 2131917 2131917 defendant Ellis Arthur yeoman 603786 603786 Ellis, Arthur, of Dersham, yeoman 0
4305078 2131917 2131917 defendant Pyckeringe Henry yeoman 603786 603786 Pyckeringe, Henry, of Dersham, yeoman 1
4481070 2194762 2194762 defendant Turkes Henry   603786 603786 Turkes, Henry, of Dersham 0
4781067 2290086 2290086 defendant Pollard John husbandman 603786 603786 Pollard, John, of Dersham, husbandman 1
4793021 2293908 2293908 defendant Polard John embroiderer 603786 603786 Polard, John, of Dersham, yeoman, or of London, embroiderer 0
4820412 2302456 2302456 plaintiff Smyth John   603786 603786 Smyth, John, of Dersham 1
4822577 2303138 2303138 plaintiff Smyth John   603786 603786 Smyth, John, of Dersham 0
4822580 2303139 2303139 plaintiff Smyth John   603786 603786 Smyth, John, of Dersham 0
4824089 2303608 2303608 defendant Smyth John   603786 603786 Smyth, John, of Dersham, bailiff 0
4835061 2306967 2306967 plaintiff Smyth John   603786 603786 Smyth, John, of Dersham 1
4835386 2307064 2307064 plaintiff Smyth John   603786 603786 Smyth, John, of Dersham 2
4861791 2315061 2315061 defendant Parkyr William, junior yeoman 603786 603786 Parkyr, William, junior, of Dersham, yeoman 2
4862743 2315333 2315333 plaintiff Smyth John   603786 603786 Smyth, John, of Dersham 2
4894263 2324892 2324892 defendant Parker William husbandman 603786 603786 Parker, William, of Dersham, husbandman 2
4932076 2336425 2336425 defendant Castell John   603786 603786 Castell, John, of Dersham 3
4944980 2340417 2340417 defendant Smyth John yeoman 603786 603786 Smyth, John, of Dersham, yeoman 1
4979921 2350952 2350952 plaintiff Smyth John   603786 603786 Smyth, John, of Dersham 0
4997774 2356189 2356189 defendant Smyth John yeoman 603786 603786 Smyth, John, of Dersham, yeoman 0
5008786 2359460 2359460 defendant Ston Richard husbandman 603786 603786 Ston, Richard, of Dersham, husbandman 0
5109083 2389078 2389078 defendant Reve Thomas husbandman 603786 603786 Reve, Thomas, of Dersham, husbandman 0
5111910 2389871 2389871 defendant Reve William yeoman 603786 603786 Reve, William, of Dersham, yeoman 0
5139154 2397944 2397944 defendant Gosse Michael   603786 603786 Gosse, Michael, of Dersham, vicar 2
5146425 2400085 2400085 defendant Ston Richard yeoman 603786 603786 Ston, Richard, of Dersham, yeoman 4
5166576 2405943 2405943 defendant Ston Richard yeoman 603786 603786 Ston, Richard, of Dersham, yeoman 4
5181465 2410317 2410317 defendant Ston Richard yeoman 603786 603786 Ston, Richard, of Dersham, yeoman 4
5202942 2416622 2416622 defendant Ston Richard yeoman 603786 603786 Ston, Richard, of Dersham, yeoman 4
5214064 2419843 2419843 defendant Cambregge Henry painter 603786 603786 Cambregge, Henry, of Dersham, painter 0
5215060 2420127 2420127 defendant Reve John, senior husbandman 603786 603786 Reve, John, senior, of Dersham, husbandman 2
5297440 2444253 2444253 defendant Reve Thomas, sen husbandman 603786 603786 Reve, Thomas, sen, of Dersham, husbandman 0
5307799 2447349 2447349 defendant Bokyll William husbandman 603786 603786 Bokyll, William, of Dersham, husbandman 0
5307800 2447349 2447349 defendant Reve William yeoman 603786 603786 Reve, William, of Dersham, yeoman 1
5307801 2447349 2447349 defendant Molette Thomas husbandman 603786 603786 Molette, Thomas, of Dersham, husbandman 2
5307802 2447349 2447349 defendant Leveryche William yeoman 603786 603786 Leveryche, William, of Dersham, yeoman 3
5380183 2469379 2469379 defendant Kydman Robert husbandman 603786 603786 Kydman, Robert, of Dersham, husbandman 1
5383621 2470398 2470398 defendant Reve William   603786 603786 Reve, William, of Dersham 0
5418096 2480338 2480338 defendant Leveriche Thomas, sen husbandman 603786 603786 Leveriche, Thomas, sen, of Dersham, husbandman 1
5422161 2481574 2481574 defendant Reve William yeoman 603786 603786 Reve, William, of Dersham, yeoman 0
5435841 2485661 2485661 defendant Leveriche Thomas, sen husbandman 603786 603786 Leveriche, Thomas, sen, of Dersham, husbandman 1
5435845 2485662 2485662 defendant Leveriche Thomas, sen husbandman 603786 603786 Leveriche, Thomas, sen, of Dersham, husbandman 1
5451629 2490358 2490358 defendant Couper Robert yeoman 603786 603786 Couper, Robert, of Dersham, yeoman 0
5499689 2504851 2504851 defendant Reve William husbandman 603786 603786 Reve, William, of Dersham, husbandman 0
5514212 2509290 2509290 defendant Reve William husbandman 603786 603786 Reve, William, of Dersham, husbandman 0
5514509 2509385 2509385 plaintiff Reve William   603786 603786 Reve, William, of Dersham 0
5520791 2511323 2511323 defendant Reve John husbandman 603786 603786 Reve, John, of Dersham, husbandman 0
5520793 2511324 2511324 defendant Reve John husbandman 603786 603786 Reve, John, of Dersham, husbandman 0
5546490 2518974 2518974 defendant Rem- John husbandman 603786 603786 Rem-, John, of Dersham, husbandman 0
5588035 2531268 2531268 defendant Bocle or Boole John   603786 603786 Bocle or Boole, John, of Dersham 1
5590145 2531892 2531892 defendant Wynston William clerk 603786 603786 Wynston, William, of Dersham, clerk 1
5592724 2532718 2532718 defendant Boole John   603786 603786 Boole, John, of Dersham 1
5597935 2534258 2534258 defendant Reve John husbandman 603786 603786 Reve, John, of Dersham, husbandman 0
5619879 2550078 2550078 defendant Broun Henry   603786 603786 Broun, Henry, of Dersham 1

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);