names

80 rows where place_id = 592205

✎ 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
3606922 1869830 1869830 defendant Stanley Robert gent 592205 592205 Stanley, Robert, of Hyndon, gent 0
3613352 1871822 1871822 defendant Baker Henry baker 592205 592205 Baker, Henry, of Hyndon, baker 0
3624589 1875227 1875227 defendant Affeld Richard husbandman 592205 592205 Affeld, Richard, of Hyndon, husbandman 0
3624591 1875228 1875228 defendant Affeld Richard husbandman 592205 592205 Affeld, Richard, of Hyndon, husbandman 0
3624593 1875229 1875229 defendant Affeld Richard husbandman 592205 592205 Affeld, Richard, of Hyndon, husbandman 0
3624595 1875230 1875230 defendant Sexcy John husbandman 592205 592205 Sexcy, John, of Hyndon, husbandman 0
3624597 1875231 1875231 defendant Sexcy John husbandman 592205 592205 Sexcy, John, of Hyndon, husbandman 0
3624599 1875232 1875232 defendant Sexcy John husbandman 592205 592205 Sexcy, John, of Hyndon, husbandman 0
3726646 1934595 1934595 defendant Matnard Thomas innholder 592205 592205 Matnard, Thomas, of Hyndon, innholder 0
3765315 1946815 1946815 defendant Sexe John husbandman 592205 592205 Sexe, John, of Hyndon, husbandman 0
3796578 1956803 1956803 defendant Bewmond William yeoman 592205 592205 Bewmond, William, of Hyndon, yeoman 1
3813724 1962205 1962205 defendant Bewmond William yeoman 592205 592205 Bewmond, William, of Hyndon, yeoman 1
3813727 1962206 1962206 defendant Bewmond William yeoman 592205 592205 Bewmond, William, of Hyndon, yeoman 1
3813730 1962207 1962207 defendant Bewmond William yeoman 592205 592205 Bewmond, William, of Hyndon, yeoman 1
3813733 1962208 1962208 defendant Bewmond William yeoman 592205 592205 Bewmond, William, of Hyndon, yeoman 1
3815610 1962798 1962798 defendant Beamound William innholder 592205 592205 Beamound, William, of Hyndon, innholder 0
3817896 1963514 1963514 defendant Maynard Richard innholder 592205 592205 Maynard, Richard, of Hyndon, innholder 0
3840065 1970462 1970462 defendant Davell Robert yeoman 592205 592205 Davell, Robert, of Hyndon, yeoman 2
3840066 1970462 1970462 defendant Davell John yeoman 592205 592205 Davell, John, of Hyndon, yeoman 3
3925387 1998805 1998805 defendant Gully Robert fisher 592205 592205 Gully, Robert, of Hyndon, fisher 0
3929499 2000213 2000213 defendant Woburne Richard butcher 592205 592205 Woburne, Richard, of Hyndon, butcher 0
3929501 2000214 2000214 defendant Woborne Richard butcher 592205 592205 Woborne, Richard, of Hyndon, butcher 0
4177994 2087774 2087774 defendant Oram Richard butcher 592205 592205 Oram, Richard, of Hyndon, victualer, butcher 0
4177996 2087774 2087774 defendant Fyce Thomas husbandman 592205 592205 Fyce, Thomas, of Hyndon, husbandman, or of East Pennard, Soms, husbandman 2
4251498 2113479 2113479 defendant Ellington Silvester butcher 592205 592205 Ellington, Silvester, of Hyndon, butcher 0
4357211 2149750 2149750 defendant Newbery Edward yeoman 592205 592205 Newbery, Edward, of Hyndon, yeoman 1
4468595 2190850 2190850 plaintiff Bedell Thomas   592205 592205 Bedell, Thomas, of Hyndon 0
4469325 2191079 2191079 plaintiff Bodell Thomas   592205 592205 Bodell, Thomas, of Hyndon 0
4613875 2235353 2235353 defendant Cotes Robert   592205 592205 Cotes, Robert, of Hyndon 2
4720641 2271789 2271789 plaintiff Bryt John   592205 592205 Bryt, John, of Hyndon 0
4759191 2283218 2283218 defendant Ermyte Richard husbandman 592205 592205 Ermyte, Richard, of Hyndon, husbandman 0
4781297 2290164 2290164 defendant Ermyte Richard husbandman 592205 592205 Ermyte, Richard, of Hyndon, husbandman 0
4784574 2291180 2291180 defendant Persons Edmund that was Jonesservant yeoman 592205 592205 Persons, Edmund that was Jonesservant, of Hyndon, yeoman 6
4797932 2295535 2295535 defendant Stoyt John husbandman 592205 592205 Stoyt, John, of Hyndon, husbandman 0
4805573 2297956 2297956 plaintiff Bryt John   592205 592205 Bryt, John, of Hyndon, on his own account 0
4817010 2301420 2301420 defendant Holbeme John shoemaker 592205 592205 Holbeme, John, of Hyndon, shoemaker 1
4834015 2306644 2306644 defendant Holbeme William   592205 592205 Holbeme, William, of Hyndon, bailiff 1
4893070 2324550 2324550 defendant Holbem William yeoman 592205 592205 Holbem, William, of Hyndon, yeoman 4
4898353 2326141 2326141 defendant Holbem William shoemaker 592205 592205 Holbem, William, of Hyndon, shoemaker 1
4899148 2326377 2326377 defendant Martyn John laborer 592205 592205 Martyn, John, of Hyndon, laborer 0
4919076 2332478 2332478 defendant Holbeme William husbandman 592205 592205 Holbeme, William, of Hyndon, husbandman 1
4929375 2335605 2335605 defendant Holbem William yeoman 592205 592205 Holbem, William, of Hyndon, yeoman 0
4932936 2336691 2336691 defendant Holbeme William yeoman 592205 592205 Holbeme, William, of Hyndon, yeoman 0
4936398 2337775 2337775 defendant Man William husbandman 592205 592205 Man, William, of Hyndon, or of Chekelade, husbandman 1
4944923 2340402 2340402 defendant Peret Thomas (legal representative) 592205 592205 Peret, Thomas, of Hyndon, executors of 0
4944925 2340402 2340402 defendant Holbeme William yeoman 592205 592205 Holbeme, William, of Hyndon, yeoman 2
4948180 2341403 2341403 defendant Holbeme William husbandman 592205 592205 Holbeme, William, of Hyndon, husbandman 3
4952848 2342810 2342810 defendant Holbem William yeoman 592205 592205 Holbem, William, of Hyndon, yeoman 1
4952850 2342811 2342811 defendant Holbeme William   592205 592205 Holbeme, William, of Hyndon, bailiff 0
4959603 2344831 2344831 defendant Holbem William husbandman 592205 592205 Holbem, William, of Hyndon, husbandman 1
4971368 2348364 2348364 defendant Holbem William yeoman 592205 592205 Holbem, William, of Hyndon, yeoman 2
4977917 2350357 2350357 defendant Walbrond John husbandman 592205 592205 Walbrond, John, of Hyndon, husbandman 0
4998676 2356488 2356488 defendant Holbeme William husbandman 592205 592205 Holbeme, William, of Hyndon, husbandman 0
5007924 2359207 2359207 defendant Holbem William husbandman 592205 592205 Holbem, William, of Hyndon, husbandman 1
5009417 2359638 2359638 defendant Fysshe Robert husbandman 592205 592205 Fysshe, Robert, of Hyndon, husbandman 1
5029554 2365512 2365512 defendant Holbeme William yeoman 592205 592205 Holbeme, William, of Hyndon, yeoman 1
5029558 2365513 2365513 defendant Holbeme William yeoman 592205 592205 Holbeme, William, of Hyndon, yeoman 1
5044895 2370108 2370108 defendant Holbeme William yeoman 592205 592205 Holbeme, William, of Hyndon, yeoman 0
5060485 2374714 2374714 defendant Basyn John yeoman 592205 592205 Basyn, John, of Hyndon, yeoman 0
5084138 2381760 2381760 defendant Basyn John yeoman 592205 592205 Basyn, John, of Hyndon, yeoman 0
5087172 2382627 2382627 defendant Obourne Robert yeoman 592205 592205 Obourne, Robert, of Hyndon, yeoman 0
5109377 2389171 2389171 defendant Holbeme William yeoman 592205 592205 Holbeme, William, of Hyndon, yeoman 3
5135573 2396914 2396914 defendant Holbeme William husbandman 592205 592205 Holbeme, William, of Hyndon, husbandman 0
5197924 2415133 2415133 defendant Holbem William yeoman 592205 592205 Holbem, William, of Hyndon, yeoman 0
5211474 2419090 2419090 defendant Gradgrave James esq 592205 592205 Gradgrave, James, of Hyndon, esq 0
5242519 2428017 2428017 defendant Holbeme William   592205 592205 Holbeme, William, of Hyndon, bailiff 3
5242524 2428018 2428018 defendant Holbeme Willim   592205 592205 Holbeme, Willim, of Hyndon, bailiff 2
5242529 2428019 2428019 defendant Holbeme Willim   592205 592205 Holbeme, Willim, of Hyndon, bailiff 2
5249400 2429939 2429939 defendant Payn John butcher 592205 592205 Payn, John, of Hyndon, butcher 0
5249401 2429939 2429939 defendant Sexfy William husbandman 592205 592205 Sexfy, William, of Hyndon, husbandman 1
5249402 2429939 2429939 defendant Stybbe William carpenter 592205 592205 Stybbe, William, of Hyndon, carpenter 2
5261568 2433730 2433730 defendant Holbem William husbandman 592205 592205 Holbem, William, of Hyndon, husbandman 0
5265337 2434915 2434915 defendant Oburn Robert gent 592205 592205 Oburn, Robert, of Hyndon, gent 1
5266284 2435207 2435207 defendant Holbeme William yeoman 592205 592205 Holbeme, William, of Hyndon, yeoman 3
5328496 2453599 2453599 plaintiff Wotton Robert   592205 592205 Wotton, Robert, of Hyndon 0
5363809 2464333 2464333 plaintiff Wotton Robert   592205 592205 Wotton, Robert, of Hyndon 0
5363815 2464334 2464334 plaintiff Wotton Robert gent 592205 592205 Wotton, Robert, of Hyndon, gent 0
5363818 2464335 2464335 plaintiff Wotton Robert gent 592205 592205 Wotton, Robert, of Hyndon, gent 0
5521177 2511440 2511440 defendant Payn or Pydyn William butcher 592205 592205 Payn or Pydyn, William, of Hyndon, butcher 0
5521179 2511441 2511441 defendant Payn William butcher 592205 592205 Payn, William, of Hyndon, butcher 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);