names

47 rows where place_id = 633201

✎ 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
3800497 1958078 1958078 defendant Gayford Thomas   633201 633201 Gayford, Thomas, of Ikelyngham, shepherd 0
3811285 1961426 1961426 defendant Lowedam William laborer 633201 633201 Lowedam, William, of Ikelyngham, laborer 0
4415792 2169827 2169827 defendant Illeye John de   633201 633201 (Illeye, John de, of Ikelyngham, parson 1
4536461 2211679 2211679 defendant Tyd Henry   633201 633201 Tyd, Henry, of Ikelyngham 6
4546905 2214965 2214965 defendant Buntyng Henry   633201 633201 Buntyng, Henry, of Ikelyngham 0
4546906 2214965 2214965 defendant Warde John   633201 633201 Warde, John, of Ikelyngham 1
4614647 2235592 2235592 plaintiff Edons Thomas   633201 633201 Edons, Thomas, of Ikelyngham 0
4617068 2236346 2236346 defendant Cartere John   633201 633201 Cartere, John, of Ikelyngham 3
4617988 2236633 2236633 defendant Cartere John   633201 633201 Cartere, John, of Ikelyngham 3
4618857 2236894 2236894 defendant Aas John   633201 633201 Aas, John, of Ikelyngham 0
4626173 2239144 2239144 plaintiff Aas John   633201 633201 Aas, John, of Ikelyngham 2
4626183 2239145 2239145 plaintiff Aas John   633201 633201 Aas, John, of Ikelyngham 2
4664945 2250517 2250517 defendant Aas John   633201 633201 Aas, John, of Ikelyngham 0
4667934 2255673 2255673 plaintiff Baker Nicholas   633201 633201 Baker, Nicholas, of Ikelyngham 0
4794540 2294431 2294431 defendant Barbour John yeoman 633201 633201 Barbour, John, of Ikelyngham, yeoman 0
4886666 2322693 2322693 defendant Quamell Ralph yeoman 633201 633201 Quamell, Ralph, of Ikelyngham, yeoman 0
4886667 2322693 2322693 defendant Holond William yeoman 633201 633201 Holond, William, of Ikelyngham, yeoman 1
4906461 2328608 2328608 defendant Bacot Nicholas clerk 633201 633201 Bacot, Nicholas, of Ikelyngham, clerk 1
5053171 2372545 2372545 defendant Collys William husbandman 633201 633201 Collys, William, of Ikelyngham, husbandman 3
5126715 2394290 2394290 defendant Ingham John   633201 633201 Ingham, John, of Ikelyngham 0
5126716 2394290 2394290 defendant Hoy John fuller 633201 633201 Hoy, John, of Ikelyngham, fuller 1
5126717 2394290 2394290 defendant Sweghey Thomas weaver 633201 633201 Sweghey, Thomas, of Ikelyngham, weaver 2
5145407 2399802 2399802 defendant Ingham John fuller 633201 633201 Ingham, John, of Ikelyngham, fuller 0
5145408 2399802 2399802 defendant Hoy John fuller 633201 633201 Hoy, John, of Ikelyngham, fuller 1
5145409 2399802 2399802 defendant Qweghey Thomas weaver 633201 633201 Qweghey, Thomas, of Ikelyngham, weaver 2
5191848 2413350 2413350 defendant Walkard John husbandman 633201 633201 Walkard, John, of Ikelyngham, husbandman 3
5222631 2422335 2422335 defendant Walkerd John husbandman 633201 633201 Walkerd, John, of Ikelyngham, husbandman 2
5224464 2422824 2422824 defendant Tynte John husbandman 633201 633201 Tynte, John, of Ikelyngham, husbandman 1
5231948 2424914 2424914 defendant Hegge John husbandman 633201 633201 Hegge, John, of Ikelyngham, husbandman 0
5231949 2424914 2424914 defendant Randolf Simon husbandman 633201 633201 Randolf, Simon, of Ikelyngham, husbandman 1
5231950 2424914 2424914 defendant Withand John, junior husbandman 633201 633201 Withand, John, junior, of Ikelyngham, husbandman 2
5231951 2424914 2424914 defendant Legat John husbandman 633201 633201 Legat, John, of Ikelyngham, husbandman 3
5231952 2424914 2424914 defendant Hardegrey John husbandman 633201 633201 Hardegrey, John, of Ikelyngham, husbandman 4
5231953 2424914 2424914 defendant Copanger William husbandman 633201 633201 Copanger, William, of Ikelyngham, husbandman 5
5255675 2431893 2431893 defendant Onghey or Oughey William laborer 633201 633201 Onghey or Oughey, William, of Ikelyngham, laborer 1
5262902 2434138 2434138 defendant Hardegrey John yeoman 633201 633201 Hardegrey, John, of Ikelyngham, yeoman 2
5271788 2436844 2436844 defendant Broun William   633201 633201 Broun, William, of Ikelyngham, wool man 3
5280726 2439439 2439439 defendant Hardegrey John husbandman 633201 633201 Hardegrey, John, of Ikelyngham, husbandman 2
5295141 2443569 2443569 defendant Broun William husbandman 633201 633201 Broun, William, of Ikelyngham, husbandman 1
5295142 2443569 2443569 defendant Lenton Robert chaplain 633201 633201 Lenton, Robert, of Ikelyngham, chaplain 2
5341106 2457409 2457409 defendant Chircheman John woolman 633201 633201 Chircheman, John, of Ikelyngham, woolman 1
5396069 2473962 2473962 defendant Melton Thomas fuller 633201 633201 Melton, Thomas, of Ikelyngham, fuller 4
5442302 2487618 2487618 defendant Coppynge Roger husbandman 633201 633201 Coppynge, Roger, of Ikelyngham, husbandman 2
5443329 2487922 2487922 defendant Burgoyn Simon clerk 633201 633201 Burgoyn, Simon, of Ikelyngham, clerk 2
5480013 2499014 2499014 defendant Gerard Thomas yeoman 633201 633201 Gerard, Thomas, of Ikelyngham, yeoman 0
5507268 2507171 2507171 defendant Gerard Thomas yeoman 633201 633201 Gerard, Thomas, of Ikelyngham, yeoman 0
5507270 2507172 2507172 defendant Roger Nicholas shoemaker 633201 633201 Roger, Nicholas, of Ikelyngham, shoemaker 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);