names

68 rows where place_id = 612044

✎ 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
3691292 1923435 1923435 defendant Stanley William clerk 612044 612044 Stanley, William, of Elyngton, clerk 0
3696124 1925011 1925011 defendant North William husbandman 612044 612044 North, William, of Elyngton, husbandman 0
3719685 1932423 1932423 defendant Stanley William clerk 612044 612044 Stanley, William, of Elyngton, clerk 0
3736133 1937543 1937543 defendant Parker Richard husbandman 612044 612044 Parker, Richard, of Elyngton, husbandman 0
3736134 1937543 1937543 defendant Hynson John, senior husbandman 612044 612044 Hynson, John, senior, of Elyngton, husbandman 1
3736135 1937543 1937543 defendant Hynson John, junior husbandman 612044 612044 Hynson, John, junior, of Elyngton, husbandman 2
3773681 1949487 1949487 defendant Howlett Roger husbandman 612044 612044 Howlett, Roger, of Elyngton, husbandman 0
3792305 1955451 1955451 defendant Howlatt Roger husbandman 612044 612044 Howlatt, Roger, of Elyngton, husbandman 0
3795405 1956435 1956435 defendant Howlett Roger husbandman 612044 612044 Howlett, Roger, of Elyngton, husbandman 1
3806790 1960027 1960027 defendant Northe William yeoman 612044 612044 Northe, William, of Elyngton, yeoman 1
3811802 1961593 1961593 defendant Stanley William clerk 612044 612044 Stanley, William, of Elyngton, clerk 1
3811803 1961593 1961593 defendant Saby Thomas husbandman 612044 612044 Saby, Thomas, of Elyngton, husbandman 2
3811851 1961610 1961610 defendant Stanley William clerk 612044 612044 Stanley, William, of Elyngton, clerk 1
3811852 1961610 1961610 defendant Saby Thomas husbandman 612044 612044 Saby, Thomas, of Elyngton, husbandman 2
3829916 1967249 1967249 defendant Stokes Thomas gent 612044 612044 Stokes, Thomas, of Elyngton, gent 0
3829917 1967249 1967249 defendant Gaytt Richard yeoman 612044 612044 Gaytt, Richard,of Elyngton, yeoman 1
3879383 1983357 1983357 defendant Howlatt Roger husbandman 612044 612044 Howlatt, Roger, of Elyngton, husbandman 2
3886769 1985834 1985834 defendant Gate Richard husbandman 612044 612044 Gate, Richard, of Elyngton, husbandman 0
3888105 1986278 1986278 defendant Panter Robert weaver 612044 612044 Panter, Robert, of Elyngton, weaver 0
4342288 2144582 2144582 defendant Nobbs Robert thatcher 612044 612044 Nobbs, Robert, of Elyngton, thatcher 0
4414069 2169303 2169303 plaintiff Clerk Nicholas le   612044 612044 Clerk, Nicholas le, of Elyngton 0
4433731 2175315 2175315 plaintiff Hale Joan in the   612044 612044 Hale, Joan in the, of Elyngton, formerly wife of Richard 0
4492216 2198247 2198247 defendant Umfray John   612044 612044 Umfray, John, of Elyngton, vicar 0
4502097 2201253 2201253 defendant Hoggeson Richard   612044 612044 Hoggeson, Richard, of Elyngton 0
4512379 2204315 2204315 defendant Shephyrd John   612044 612044 Shephyrd, John, of Elyngton 0
4525865 2208387 2208387 plaintiff Kelfold Henry   612044 612044 Kelfold, Henry, of Elyngton 0
4541919 2213361 2213361 defendant Gerard Thomas   612044 612044 Gerard, Thomas, of Elyngton 0
4570900 2222464 2222464 plaintiff Wyne John   612044 612044 Wyne, John, of Elyngton 0
4570903 2222465 2222465 defendant Hundesley John   612044 612044 Hundesley, John, of Elyngton 0
4690926 2262692 2262692 defendant Tykeregge John parker 612044 612044 Tykeregge, John, of Elyngton, parker 0
4733274 2275584 2275584 defendant Holme William husbandman 612044 612044 Holme, William, of Elyngton, husbandman 2
4753756 2281548 2281548 defendant Eyre Reginald husbandman 612044 612044 Eyre, Reginald, of Elyngton, husbandman 1
4806434 2298223 2298223 defendant Gegge Ralph husbandman 612044 612044 Gegge, Ralph, of Elyngton, husbandman 0
4824675 2303760 2303760 defendant Kyrlyngton Robert de husbandman 612044 612044 Kyrlyngton, Robert de, of Elyngton, husbandman 0
4824676 2303760 2303760 defendant de Kyrlyngton William husbandman 612044 612044 de Kyrlyngton, William, of Elyngton, husbandman 1
4838723 2308036 2308036 defendant Bayly Roger husbandman 612044 612044 Bayly, Roger, of Elyngton, husbandman 0
4841299 2308815 2308815 defendant Tomson Thomas husbandman 612044 612044 Tomson, Thomas, of Elyngton, husbandman 0
4868391 2317084 2317084 defendant Gegge Ralph husbandman 612044 612044 Gegge, Ralph, of Elyngton, husbandman 2
4882065 2321286 2321286 defendant Brewehouse Richard husbandman 612044 612044 Brewehouse, Richard, of Elyngton, husbandman 2
4950949 2342263 2342263 plaintiff Petyt John husbandman 612044 612044 Petyt, John, of Elyngton, husbandman 0
5062908 2375441 2375441 defendant Bateman John husbandman 612044 612044 Bateman, John, of Elyngton, husbandman 1
5062909 2375441 2375441 defendant Penyell William husbandman 612044 612044 Penyell, William, of Elyngton, husbandman 2
5062910 2375441 2375441 defendant Couper John cooper 612044 612044 Couper, John, of Elyngton, cooper 3
5062911 2375441 2375441 defendant Kyng Thomas husbandman 612044 612044 Kyng, Thomas, of Elyngton, husbandman 4
5062912 2375441 2375441 defendant Elgare John yeoman 612044 612044 Elgare, John, of Elyngton, yeoman 5
5062913 2375441 2375441 defendant Stanwey Ralph yeoman 612044 612044 Stanwey, Ralph, of Elyngton, yeoman 6
5062914 2375441 2375441 defendant Mokke Richard husbandman 612044 612044 Mokke, Richard, of Elyngton, husbandman 7
5236681 2426312 2426312 defendant Kyng Thomas yeoman 612044 612044 Kyng, Thomas, of Elyngton, yeoman 0
5236682 2426312 2426312 defendant Kyng Thomas husbandman 612044 612044 Kyng, Thomas, of Elyngton, husbandman 1
5236683 2426312 2426312 defendant Kyng Richard husbandman 612044 612044 Kyng, Richard, of Elyngton, husbandman 2
5248232 2429616 2429616 defendant Clerke William husbandman 612044 612044 Clerke, William, of Elyngton, husbandman 1
5252615 2430933 2430933 defendant Malkyn William (legal representative) 612044 612044 Malkyn, William, of Elyngton, executors of 1
5252616 2430933 2430933 defendant More John husbandman 612044 612044 (More, John, of Elyngton, husbandman 2
5314070 2449225 2449225 defendant Lane Richard husbandman 612044 612044 Lane, Richard, of Elyngton, husbandman 1
5314071 2449225 2449225 defendant Saby John husbandman 612044 612044 Saby, John, of Elyngton, husbandman 2
5365100 2464757 2464757 defendant Judde Henry husbandman 612044 612044 Judde, Henry, of Elyngton, husbandman 0
5365101 2464757 2464757 defendant Broune Thomas husbandman 612044 612044 Broune, Thomas, of Elyngton, husbandman 1
5384059 2470528 2470528 defendant Judde Henry husbandman 612044 612044 Judde, Henry, of Elyngton, husbandman 0
5384060 2470528 2470528 defendant Broune Thomas husbandman 612044 612044 Broune, Thomas, of Elyngton, husbandman 1
5395868 2473904 2473904 defendant Judde Henry husbandman 612044 612044 Judde, Henry, of Elyngton, husbandman 0
5395869 2473904 2473904 defendant Broune Thomas husbandman 612044 612044 Broune, Thomas, of Elyngton, husbandman 1
5409460 2477794 2477794 defendant Judde Henry husbandman 612044 612044 Judde, Henry, of Elyngton, husbandman 0
5409461 2477794 2477794 defendant Broun Thomas husbandman 612044 612044 Broun, Thomas, of Elyngton, husbandman 1
5430797 2484149 2484149 defendant Hensone Richard husbandman 612044 612044 Hensone, Richard, of Elyngton, husbandman 0
5481307 2499354 2499354 defendant Wylles William yeoman 612044 612044 Wylles, William, of Elyngton, yeoman 7
5528100 2513353 2513353 defendant Hulkot John yeoman 612044 612044 Hulkot, John, of Elyngton, yeoman 3
5601614 2535401 2535401 defendant Raddeley William yeoman 612044 612044 Raddeley, William, of Elyngton, yeoman 0
5606018 2536770 2536770 defendant Radley William yeoman 612044 612044 Radley, William, of Elyngton, yeoman 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);