names

48 rows where place_id = 609338

✎ 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
3678017 1919168 1919168 defendant Launcell John yeoman 609338 609338 Launcell, John, of Hamerton, yeoman 0
3713590 1930561 1930561 defendant Say John yeoman 609338 609338 Say, John, of Hamerton, yeoman 0
3834033 1968584 1968584 defendant Benson John yeoman 609338 609338 Benson, John, of Hamerton, yeoman 3
4067258 2048589 2048589 defendant Breers John gent 609338 609338 Breers, John, of Hamerton, gent 0
4298830 2129679 2129679 defendant Bradley John yeoman 609338 609338 Bradley, John, of Hamerton, yeoman 0
4298831 2129679 2129679 defendant Bayes John husbandman 609338 609338 Bayes, John, of Hamerton, husbandman 1
4298832 2129679 2129679 defendant Gorram Robert yeoman 609338 609338 Gorram, Robert, of Hamerton, yeoman 2
4496001 2199426 2199426 defendant Blakne Richard   609338 609338 Blakne, Richard, of Hamerton 2
4499220 2200405 2200405 defendant Theyn William   609338 609338 Theyn, William, of Hamerton 0
4499221 2200406 2200406 plaintiff Gyddyng John   609338 609338 Gyddyng, John, of Hamerton 0
4499222 2200406 2200406 defendant Theyn William   609338 609338 Theyn, William, of Hamerton 0
4499223 2200407 2200407 plaintiff Gyddyng John   609338 609338 Gyddyng, John, of Hamerton 0
4499224 2200407 2200407 defendant Theyn William   609338 609338 Theyn, William, of Hamerton 0
4509239 2203368 2203368 defendant Theyn William   609338 609338 Theyn, William, of Hamerton 1
4564509 2220462 2220462 defendant Plattyng Robert   609338 609338 Plattyng, Robert, of Hamerton 2
4582778 2226050 2226050 defendant Lokyer John   609338 609338 Lokyer, John, of Hamerton 1
4604175 2232474 2232474 defendant Theyn William   609338 609338 Theyn, William, of Hamerton 0
4655490 2247611 2247611 defendant Hogeson John yeoman 609338 609338 Hogeson, John, of Hamerton, yeoman 4
4753755 2281548 2281548 defendant Wene or Weve John husbandman 609338 609338 Wene or Weve, John, of Hamerton, husbandman 0
4760440 2283619 2283619 defendant Nulby Thomas husbandman 609338 609338 Nulby, Thomas, of Hamerton, husbandman 0
4810189 2299331 2299331 defendant --ull-- Thomas husbandman 609338 609338 --ull--, Thomas, of Hamerton, husbandman 1
4852644 2312247 2312247 defendant fitz John Henry husbandman 609338 609338 fitz John, Henry, of Hamerton, husbandman 0
4880553 2320829 2320829 defendant FitzJohn Henry husbandman 609338 609338 FitzJohn, Henry, of Hamerton, husbandman 0
4899182 2326386 2326386 defendant Halom John husbandman 609338 609338 Halom, John, of Hamerton, husbandman 1
4908396 2329181 2329181 defendant Marchall John clerk 609338 609338 Marchall, John, of Hamerton, clerk 0
4918969 2332446 2332446 defendant Reynold Simon husbandman 609338 609338 Reynold, Simon, of Hamerton, husbandman 0
4965154 2346502 2346502 defendant Hoggeson John husbandman 609338 609338 Hoggeson, John, of Hamerton, husbandman 2
5024197 2363990 2363990 defendant Hennesson John husbandman 609338 609338 Hennesson, John, of Hamerton, husbandman 0
5032412 2366361 2366361 defendant Cant John husbandman 609338 609338 Cant, John, of Hamerton, husbandman 0
5035345 2367195 2367195 defendant Elweden John   609338 609338 (Elweden, John, of Hamerton, notary 4
5062918 2375441 2375441 defendant Cawyt John carpenter 609338 609338 Cawyt, John, of Hamerton, carpenter 11
5065588 2376241 2376241 defendant Ive alias Hendesone John husbandman 609338 609338 Ive alias Hendesone, John, of Hamerton, husbandman 4
5065590 2376242 2376242 defendant Garly or Early Thomas husbandman 609338 609338 Garly or Early, Thomas, of Hamerton, husbandman 0
5065591 2376242 2376242 defendant Hoggesson William husbandman 609338 609338 Hoggesson, William, of Hamerton, husbandman 1
5065592 2376242 2376242 defendant Barbour John husbandman 609338 609338 Barbour, John, of Hamerton, husbandman 2
5065593 2376242 2376242 defendant Ive John husbandman 609338 609338 Ive, John, of Hamerton, husbandman 3
5065595 2376242 2376242 defendant FitzJohn Henry husbandman 609338 609338 FitzJohn, Henry, of Hamerton, husbandman 5
5065596 2376242 2376242 defendant Carter Thomas husbandman 609338 609338 Carter, Thomas, of Hamerton, husbandman 6
5065597 2376242 2376242 defendant Hoggesson Richard husbandman 609338 609338 Hoggesson, Richard, of Hamerton, husbandman 7
5101136 2386745 2386745 defendant FitzJohn John husbandman 609338 609338 FitzJohn, John, of Hamerton, husbandman 2
5251677 2430628 2430628 defendant Barbour John smith 609338 609338 Barbour, John, of Hamerton, smith 2
5295531 2443684 2443684 defendant FitzJohn John husbandman 609338 609338 together with FitzJohn, John, of Hamerton, husbandman 1
5500989 2505243 2505243 defendant Forest William gent 609338 609338 Forest, William, of Hamerton, gent 3
5529579 2513750 2513750 defendant Spenser Thomas husbandman 609338 609338 Spenser, Thomas, of Hamerton, husbandman 0
5529580 2513750 2513750 defendant Hodgesun William husbandman 609338 609338 Hodgesun, William, of Hamerton, husbandman 1
5543371 2518045 2518045 defendant Hodgeson William husbandman 609338 609338 Hodgeson, William, of Hamerton, husbandman 0
5573475 2526802 2526802 defendant Malham Richard clerk 609338 609338 Malham, Richard, of Hamerton, clerk 0
5612997 2547841 2547841 defendant Causton Michael de   609338 609338 Causton, Michael de, of Hamerton, parson 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);