names

67 rows where place_id = 597864

✎ 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
3630159 1904281 1904281 defendant Hegge Thomas clerk 597864 597864 Hegge, Thomas, of Felsham, clerk 0
3637748 1906622 1906622 defendant Tylle Edmund husbandman 597864 597864 Tylle, Edmund, of Felsham, husbandman 0
3637754 1906624 1906624 defendant Wood John husbandman 597864 597864 Wood, John, of Felsham, husbandman 0
3645138 1908887 1908887 defendant Goche Thomas smith 597864 597864 Goche, Thomas, of Felsham, smith 0
3703564 1927390 1927390 defendant Awoode John husbandman 597864 597864 Awoode, John, of Felsham, husbandman 0
3763679 1946283 1946283 defendant Whelbely Robert husbandman 597864 597864 Whelbely, Robert, of Felsham, husbandman 2
3779390 1951275 1951275 defendant Brundysshe William husbandman 597864 597864 Brundysshe, William, of Felsham, husbandman 3
3781633 1951992 1951992 defendant Coche Thomas smith 597864 597864 Coche, Thomas, of Felsham, smith 0
3796423 1956750 1956750 defendant Candler Peter husbandman 597864 597864 Candler, Peter, of Felsham, husbandman 3
3801348 1958349 1958349 defendant Candeler Peter husbandman 597864 597864 Candeler, Peter, of Felsham, husbandman 0
3814722 1962517 1962517 defendant Edward Andrew husbandman 597864 597864 Edward, Andrew, of Felsham, husbandman 2
3854495 1975045 1975045 defendant Ede Elias sherman 597864 597864 Ede, Elias, of Felsham, sherman 2
3877891 1982848 1982848 defendant Gardyner John husbandman 597864 597864 Gardyner, John, of Felsham, husbandman 2
3890114 1986927 1986927 defendant Lumkyn William weaver 597864 597864 Lumkyn, William, of Felsham, weaver 0
3910296 1993760 1993760 defendant Gyde Elizha sherman 597864 597864 Gyde, Elizha, of Felsham, sherman 2
3941918 2004308 2004308 defendant Lyllesy Robert clothier 597864 597864 Lyllesy, Robert, of Felsham, clothier 1
3945978 2005672 2005672 defendant Alexander Richard (legal representative) 597864 597864 Alexander, Richard, of Felsham, administratrix of 0
3945979 2005672 2005672 defendant Alexander Margaret widow 597864 597864 Alexander, Margaret, of Felsham, widow 1
3960422 2010743 2010743 defendant Browne Henry husbandman 597864 597864 Browne, Henry, of Felsham, husbandman 0
3985985 2019755 2019755 defendant Ede Elias sherman 597864 597864 Ede, Elias, of Felsham, sherman 0
3985987 2019756 2019756 defendant Ede Elias sherman 597864 597864 Ede, Elias, of Felsham, sherman 0
4028540 2034859 2034859 defendant Kent William   597864 597864 Kent, William, of Felsham, linen weaver 0
4159344 2081338 2081338 defendant Crome Edward yeoman 597864 597864 Crome, Edward, of Felsham, yeoman 1
4276081 2121582 2121582 defendant Sargent Roger husbandman 597864 597864 Sargent, Roger, of Felsham, husbandman 1
4353949 2148608 2148608 defendant Cock Thomas husbandman 597864 597864 Cock, Thomas, of Felsham, husbandman 1
4383310 2159132 2159132 defendant Leache William fisherman 597864 597864 Leache, William, of Felsham, fisherman 0
4479794 2194342 2194342 defendant Tylle Thomas   597864 597864 Tylle, Thomas, of Felsham 0
4505764 2202313 2202313 defendant Raunde Geoffrey chaplain 597864 597864 Raunde, Geoffrey, of Felsham, chaplain 1
4531896 2210242 2210242 plaintiff Pirye John   597864 597864 Pirye, John, of Felsham 0
4564991 2220618 2220618 defendant Bregge John smith 597864 597864 Bregge, John, of Felsham, smith 3
4572566 2222954 2222954 defendant Cok John   597864 597864 Cok, John, of Felsham 1
4609374 2234031 2234031 defendant Tille Thomas   597864 597864 Tille, Thomas, of Felsham 3
4631318 2240687 2240687 defendant Wryght John   597864 597864 Wryght, John, of Felsham 4
4686690 2261449 2261449 defendant Tylle Thomas husbandman 597864 597864 Tylle, Thomas, of Felsham, husbandman 0
4726845 2273664 2273664 defendant Tylle Thomas husbandman 597864 597864 Tylle, Thomas, of Felsham, husbandman 0
4735132 2276136 2276136 defendant Tylle Thomas husbandman 597864 597864 Tylle, Thomas, of Felsham, husbandman 3
4754567 2281810 2281810 defendant S_ustr John yeoman 597864 597864 S_ustr, John, of Felsham, yeoman 0
4755475 2282091 2282091 defendant Drout Peter   597864 597864 Drout, Peter, of Felsham, shoe maker 0
4778861 2289364 2289364 defendant Gardener Simon butcher 597864 597864 Gardener, Simon, of Felsham, butcher 0
4816407 2301226 2301226 plaintiff Machon John   597864 597864 Machon, John, of Felsham 1
4844887 2309921 2309921 defendant Seman Robert husbandman 597864 597864 Seman, Robert, of Felsham, husbandman 2
4911039 2329963 2329963 defendant Carter William yeoman 597864 597864 Carter, William, of Felsham, yeoman 3
4954062 2343180 2343180 defendant Beteryng Richard butcher 597864 597864 Beteryng, Richard, of Felsham, butcher 0
5038041 2368009 2368009 defendant Hoode Thomas, junior husbandman 597864 597864 Hoode, Thomas, junior, of Felsham, husbandman 2
5056714 2373580 2373580 defendant Hood Thomas husbandman 597864 597864 Hood, Thomas, of Felsham, husbandman 0
5084679 2381932 2381932 defendant Carter John laborer 597864 597864 Carter, John, of Felsham, laborer 5
5085415 2382123 2382123 defendant Carter John laborer 597864 597864 Carter, John, of Felsham, laborer 6
5119469 2392124 2392124 defendant Clere John barker 597864 597864 Clere, John, of Felsham, barker 0
5119470 2392124 2392124 defendant Bryon John laborer 597864 597864 Bryon, John, of Felsham, laborer 1
5119471 2392124 2392124 defendant Broun Thomas laborer 597864 597864 Broun, Thomas,of Felsham, laborer 2
5128920 2394944 2394944 defendant Drought Peter yeoman 597864 597864 Drought, Peter, of Felsham,yeoman 0
5160529 2404170 2404170 defendant Hood Thomas husbandman 597864 597864 Hood, Thomas, of Felsham, husbandman 0
5175299 2408467 2408467 defendant Hood Thomas husbandman 597864 597864 Hood, Thomas, of Felsham, husbandman 0
5196385 2414694 2414694 defendant Hood Thomas husbandman 597864 597864 Hood, Thomas, of Felsham, husbandman 0
5196388 2414695 2414695 defendant Hood Thomas husbandman 597864 597864 Hood, Thomas, of Felsham, husbandman 0
5215512 2420260 2420260 defendant Gundry John dyer 597864 597864 Gundry, John, of Felsham, dyer 3
5281167 2439568 2439568 plaintiff Coksedge Baldwin (legal representative) 597864 597864 Coksedge, Baldwin, of Felsham, gent, executors of 0
5290470 2442217 2442217 plaintiff Nunne John   597864 597864 Nunne, John, of Felsham 2
5300715 2445178 2445178 plaintiff Coksedge Baldwin (legal representative) 597864 597864 Coksedge, Baldwin, of Felsham, gent, executors of 0
5307014 2447097 2447097 plaintiff Nunne John   597864 597864 Nunne, John, of Felsham 2
5385420 2470906 2470906 defendant Brese Robert husbandman 597864 597864 Brese, Robert, of Felsham, husbandman 12
5387131 2471388 2471388 defendant Cobald John husbandman 597864 597864 Cobald, John, of Felsham, husbandman 0
5397560 2474374 2474374 defendant Brese Robert husbandman 597864 597864 Brese, Robert, of Felsham, husbandman 12
5421060 2481230 2481230 defendant Broun Peter shoemaker 597864 597864 Broun, Peter, of Felsham, shoemaker 2
5499797 2504886 2504886 defendant Goodrich John husbandman 597864 597864 Goodrich, John, of Felsham, husbandman 1
5568822 2525432 2525432 defendant Messenger Robert husbandman 597864 597864 Messenger, Robert, of Felsham, husbandman 0
5605379 2536563 2536563 defendant Skerpe Robert   597864 597864 Skerpe, Robert, of Felsham, brick maker 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);