names

118 rows where place_id = 589534

✎ 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
3597894 1866962 1866962 plaintiff Seman William, senior   589534 589534 Seman, William, senior, of Depham 0
3602704 1868508 1868508 defendant Rogers John husbandman 589534 589534 Rogers, John, of Depham, husbandman 3
3603437 1868740 1868740 defendant Bury Richard husbandman 589534 589534 Bury, Richard, of Depham, husbandman 6
3625489 1875511 1875511 defendant Walter Richard husbandman 589534 589534 Walter, Richard, of Depham, husbandman 0
3643516 1908401 1908401 defendant Seman William, junior   589534 589534 Seman, William, junior, of Depham, "sewkar" 4
3710172 1929496 1929496 defendant Wylkynson John husbandman 589534 589534 Wylkynson, John, of Depham, husbandman 0
3732803 1936489 1936489 defendant Cuttys Nicholas yeoman 589534 589534 Cuttys, Nicholas, of Depham, yeoman 0
3820790 1964393 1964393 defendant Fysk John fishmonger 589534 589534 Fysk, John, of Depham, fishmonger 1
3850509 1973748 1973748 defendant Cuttys James husbandman 589534 589534 Cuttys, James, of Depham, husbandman 0
3850510 1973748 1973748 defendant Cuttys John husbandman 589534 589534 Cuttys, John, of Depham, husbandman 1
3941781 2004264 2004264 defendant Seman Robert   589534 589534 Seman, Robert, of Depham 0
3982668 2018570 2018570 plaintiff Seman William yeoman 589534 589534 Seman, William, of Depham, yeoman 0
4005425 2026720 2026720 defendant Colman John husbandman 589534 589534 Colman, John, of Depham, husbandman 3
4022028 2032608 2032608 plaintiff Amyas Thomas gent 589534 589534 Amyas, Thomas, of Depham, gent 0
4053925 2043781 2043781 defendant Duffeld Henry yeoman 589534 589534 Duffeld, Henry, of Depham, yeoman 2
4058704 2045504 2045504 defendant Gyldensleve John clerk 589534 589534 Gyldensleve, John, of Depham, clerk 3
4059600 2045824 2045824 defendant Lane Roger laborer 589534 589534 Lane, Roger, of Depham, laborer 2
4075925 2051693 2051693 defendant Cressye John husbandman 589534 589534 Cressye, John, of Depham, husbandman 0
4078258 2052525 2052525 defendant Gyldyngsleve John clerk 589534 589534 Gyldyngsleve, John, of Depham, clerk 2
4115666 2065889 2065889 plaintiff Walker Elizabeth   589534 589534 Elizabeth his wife, alias Elizabeth Carsey, of Depham 1
4135566 2073045 2073045 defendant Davye Thomas husbandman 589534 589534 Davye, Thomas, of Depham, husbandman 0
4143500 2075886 2075886 plaintiff Barnham William husbandman 589534 589534 Barnham, William, of Depham, husbandman 0
4143818 2075999 2075999 defendant Browne Thomas laborer 589534 589534 Browne, Thomas, of Depham, laborer 0
4143820 2076000 2076000 defendant Browne Thomas laborer 589534 589534 Browne, Thomas, of Depham, laborer 0
4171796 2085595 2085595 defendant Cressey John thatcher 589534 589534 Cressey, John, of Depham, husbandman, thatcher 0
4172750 2085927 2085927 defendant Twaytes Anthony gent 589534 589534 Twaytes, Anthony, of Depham, gent 0
4172810 2085946 2085946 defendant Davy Thomas husbandman 589534 589534 Davy, Thomas, of Depham, husbandman 2
4194914 2093784 2093784 defendant Cressey John thatcher 589534 589534 Cressey, John, of Depham, husbandman, thatcher 0
4201018 2095914 2095914 defendant Graves William clerk 589534 589534 Graves, William, of Depham, clerk 0
4201019 2095914 2095914 defendant Davy Thomas husbandman 589534 589534 Davy, Thomas, of Depham, husbandman 1
4216165 2101145 2101145 defendant Coleman John, senior yeoman 589534 589534 Coleman, John, senior, of Depham, yeoman 0
4216166 2101145 2101145 defendant Coleman John, junior   589534 589534 Coleman, John, junior, of Depham, yeoman, "tapmaker" 1
4223654 2103760 2103760 defendant Longe John husbandman 589534 589534 Longe, John, of Depham, husbandman 0
4228540 2105464 2105464 defendant Webbyster Thomas yeoman 589534 589534 Webbyster, Thomas, of Depham, yeoman 0
4245716 2111547 2111547 defendant Webster Thomas yeoman 589534 589534 Webster, Thomas, of Depham, yeoman 0
4271092 2119907 2119907 defendant Carsey Thomas husbandman 589534 589534 Carsey, Thomas, of Depham, husbandman 2
4428856 2173827 2173827 defendant Huberd John   589534 589534 Huberd, John, of Depham 0
4461174 2188575 2188575 defendant Crouge Robert   589534 589534 Crouge, Robert, of Depham 0
4502985 2201502 2201502 defendant Cors John   589534 589534 Cors, John, of Depham, son of John Cros 0
4502987 2201503 2201503 defendant Cros John   589534 589534 Cros, John, of Depham 0
4502989 2201504 2201504 defendant Cros John   589534 589534 Cros, John, of Depham 0
4502991 2201505 2201505 defendant Cros John   589534 589534 Cros, John, of Depham, son of John 0
4529499 2209508 2209508 defendant Lynte Richard chaplain 589534 589534 Lynte, Richard, of Depham, chaplain 0
4555473 2217647 2217647 defendant atte Cros John   589534 589534 atte Cros, John, of Depham 0
4560026 2219085 2219085 defendant Pytte Geoffrey   589534 589534 Pytte, Geoffrey, of Depham 0
4560339 2219173 2219173 defendant Pytte Geoffrey   589534 589534 Pytte, Geoffrey, of Depham 0
4611601 2234693 2234693 defendant Bakere Richard   589534 589534 Bakere, Richard, of Depham 1
4614350 2235499 2235499 defendant Cros John   589534 589534 Cros, John, of Depham 3
4616960 2236312 2236312 defendant atte Crosse John   589534 589534 atte Crosse, John, of Depham 0
4616962 2236313 2236313 defendant atte Crosse John   589534 589534 atte Crosse, John, of Depham 0
4616964 2236314 2236314 defendant Crosse John   589534 589534 Crosse, John, of Depham 0
4639224 2242990 2242990 defendant Seman Thomas   589534 589534 Seman, Thomas, of Depham 6
4674088 2257504 2257504 defendant Dunnynges John butcher 589534 589534 Dunnynges, John, of Depham, butcher 3
4686031 2261220 2261220 defendant Pittes John carpenter 589534 589534 Pittes, John, of Depham, carpenter 0
4699421 2265278 2265278 defendant Pyttes John   589534 589534 Pyttes, John, of Depham, wright 1
4710525 2268651 2268651 defendant Pyttes John husbandman 589534 589534 Pyttes, John, of Depham, husbandman 0
4716917 2270624 2270624 defendant Pyttes John   589534 589534 Pyttes, John, of Depham, wright 0
4741578 2278032 2278032 defendant Dunnyng William butcher 589534 589534 Dunnyng, William, of Depham, butcher 3
4741579 2278032 2278032 defendant Baker Richard husbandman 589534 589534 Baker, Richard, of Depham, husbandman 4
4754489 2281784 2281784 defendant Hert Walter clerk 589534 589534 Hert, Walter, of Depham, clerk 1
4754892 2281910 2281910 defendant atte Chamber John yeoman 589534 589534 atte Chamber, John, of Depham, yeoman 0
4754893 2281910 2281910 defendant Houmfrey William yeoman 589534 589534 Houmfrey, William, of Depham, yeoman 1
4754894 2281910 2281910 defendant Walter Thomas yeoman 589534 589534 Walter, Thomas, of Depham, yeoman 2
4773809 2287785 2287785 defendant Baker Richard husbandman 589534 589534 Baker, Richard, of Depham, husbandman 1
4778252 2289181 2289181 defendant Bery Richard   589534 589534 Bery, Richard, of Depham, wright 1
4803405 2297255 2297255 defendant Prynce John clerk 589534 589534 Prynce, John, of Depham, clerk 0
4809544 2299151 2299151 defendant Waryn Thomas yeoman 589534 589534 Waryn, Thomas, of Depham, yeoman 3
4852943 2312343 2312343 defendant Dobbes Thomas yeoman 589534 589534 Dobbes, Thomas, of Depham, yeoman 0
4861586 2314995 2314995 plaintiff Crosse John   589534 589534 Crosse, John, of Depham 0
4861589 2314995 2314995 defendant Prys John clerk 589534 589534 Prys, John, of Depham, clerk 0
4872449 2318345 2318345 defendant Pyttes John yeoman 589534 589534 together with Pyttes, John, of Depham, yeoman 10
4887218 2322842 2322842 defendant Mey Richard laborer 589534 589534 Mey, Richard, of Depham, laborer 2
4895694 2325330 2325330 plaintiff Crosse John   589534 589534 Crosse, John, of Depham 0
4895697 2325330 2325330 defendant Pittys John carpenter 589534 589534 Pittys, John, of Depham, carpenter 0
4899088 2326357 2326357 defendant Prat Thomas husbandman 589534 589534 Prat, Thomas, of Depham, husbandman 0
5028464 2365197 2365197 defendant Prat Thomas husbandman 589534 589534 Prat, Thomas, of Depham, husbandman 1
5036557 2367555 2367555 plaintiff Colyour Geoffrey   589534 589534 Colyour, Geoffrey, of Depham 2
5073229 2378480 2378480 plaintiff Walter John, junior   589534 589534 Walter, John, junior, of Depham 1
5073230 2378480 2378480 defendant Cryour Stephen husbandman 589534 589534 Cryour, Stephen, of Depham, husbandman 0
5073232 2378481 2378481 plaintiff Walter John, junior   589534 589534 Walter, John, junior, of Depham 1
5073233 2378481 2378481 defendant Seman John father of Richard 589534 589534 Seman, John, of Depham, husbandman, father of Richard 0
5073234 2378481 2378481 defendant Seman Richard husbandman 589534 589534 Seman, Richard, of Depham, husbandman 1
5114621 2390689 2390689 defendant Seman Richard husbandman 589534 589534 Seman, Richard, of Depham, husbandman 1
5123726 2393399 2393399 defendant Pyttys Nicholas husbandman 589534 589534 Pyttys, Nicholas, of Depham, husbandman 0
5159968 2404014 2404014 plaintiff Seman William   589534 589534 Seman, William, of Depham, the fuller 0
5159969 2404014 2404014 defendant Davy William   589534 589534 Davy, William, of Depham, le suker or farrow maker 0
5159970 2404015 2404015 plaintiff Seman William   589534 589534 Seman, William, of Depham, the fuller 0
5159971 2404015 2404015 defendant Davy William   589534 589534 Davy, William, of Depham, le suker or farrow maker 0
5159972 2404015 2404015 defendant Estan William husbandman 589534 589534 Estan, William, of Depham, husbandman 1
5175450 2408510 2408510 defendant Cogman William carpenter 589534 589534 Cogman, William, of Depham, carpenter 5
5179628 2409777 2409777 defendant Dunyng John husbandman 589534 589534 Dunyng, John, of Depham, husbandman 0
5179886 2409854 2409854 defendant Smyth John laborer 589534 589534 Smyth, John, of Depham, laborer 1
5201983 2416347 2416347 defendant Smyth John laborer 589534 589534 Smyth, John, of Depham, laborer 1
5210322 2418746 2418746 defendant Walter John husbandman 589534 589534 Walter, John, of Depham, husbandman 2
5215719 2420322 2420322 defendant Nyker John mercer 589534 589534 Nyker, John, of Depham, mercer 0
5242746 2428085 2428085 defendant Seman Richard husbandman 589534 589534 Seman, Richard, of Depham, husbandman 0
5242747 2428085 2428085 defendant Seman Nicholas laborer 589534 589534 Seman, Nicholas, of Depham, laborer 1
5242748 2428085 2428085 defendant Broun John laborer 589534 589534 Broun, John, of Depham, laborer 2
5242750 2428085 2428085 defendant Carter John husbandman 589534 589534 Carter, John, of Depham, husbandman 4
5249616 2430006 2430006 plaintiff Umfrey Richard   589534 589534 Umfrey, Richard, of Depham 0

Next page

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