names

82 rows where place_id = 589445

✎ 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
3597668 1866897 1866897 defendant Lemyng Robert yeoman 589445 589445 Lemyng, Robert, of Arnall, yeoman 0
3618767 1873486 1873486 defendant Lemyng Robert yeoman 589445 589445 Lemyng, Robert, of Arnall, yeoman 0
3648047 1909786 1909786 defendant Clerke Hugh carpenter 589445 589445 Clerke, Hugh, of Arnall, carpenter 0
3648048 1909786 1909786 defendant Clerke Thomas yeoman or scholar 589445 589445 Clerke, Thomas, of Arnall, yeoman or scholar 1
3648049 1909786 1909786 defendant Clerke Richard carpenter 589445 589445 Clerke, Richard, of Arnall, carpenter 2
3677853 1919126 1919126 defendant Hydde Roger yeoman 589445 589445 Hydde, Roger, of Arnall, yeoman 0
3677854 1919126 1919126 defendant Hydde Nicholas yeoman 589445 589445 Hydde, Nicholas, of Arnall, yeoman 1
3677855 1919126 1919126 defendant Slak William yeoman 589445 589445 Slak, William, of Arnall, yeoman 2
3774553 1949767 1949767 defendant Hyde Nicholas yeoman 589445 589445 Hyde, Nicholas, of Arnall, yeoman 1
3774557 1949768 1949768 defendant Hyde Nicholas yeoman 589445 589445 Hyde, Nicholas, of Arnall, yeoman 2
3839518 1970286 1970286 defendant Keywood Edward gent 589445 589445 Keywood, Edward, of Arnall, gent 0
3971500 2014592 2014592 defendant Nasshe Humphrey yeoman 589445 589445 Nasshe, Humphrey, of Arnall, or of "Armytayche of Brampton", Nhants, yeoman 0
3971501 2014592 2014592 defendant Nasshe Arthur   589445 589445 Nasshe, Arthur, of Arnall, yeoman, his son 1
3979221 2017318 2017318 defendant Barker Adam husbandman 589445 589445 Barker, Adam, of Arnall, husbandman 1
3979222 2017318 2017318 defendant Gybson Henry husbandman 589445 589445 Gybson, Henry, of Arnall, husbandman 2
3979223 2017318 2017318 defendant Sully Richard husbandman 589445 589445 Sully, Richard, of Arnall, husbandman 3
4009305 2028092 2028092 defendant Holland Robert yeoman 589445 589445 Holland, Robert, of Arnall, yeoman 0
4182387 2089313 2089313 defendant Meadley Richard yeoman 589445 589445 Meadley, Richard, of Arnall, yeoman 0
4217822 2101727 2101727 defendant Berdsley Richard carpenter 589445 589445 Berdsley, Richard, of Arnall, carpenter 0
4492923 2198488 2198488 defendant Smyth Thomas   589445 589445 Smyth, Thomas, of Arnall 0
4498874 2200283 2200283 plaintiff Gladewyn John   589445 589445 Gladewyn, John, of Arnall 0
4498875 2200283 2200283 defendant Smyth Thomas   589445 589445 Smyth, Thomas, of Arnall 0
4505714 2202297 2202297 plaintiff Stanton John de   589445 589445 Stanton, John de, of Arnall 0
4505715 2202297 2202297 defendant Smyth Thomas   589445 589445 Smyth, Thomas, of Arnall 0
4524230 2207914 2207914 plaintiff Hildlyerd Maud   589445 589445 Hildlyerd, Maud, of Arnall, formerly wife of Peter, on her own account 0
4531987 2210269 2210269 plaintiff Plouman John   589445 589445 Plouman, John, of Arnall 0
4531990 2210269 2210269 defendant Bryghtye Margaret   589445 589445 Bryghtye, Margaret, of Arnall 2
4560770 2219323 2219323 defendant Ploweman John   589445 589445 Ploweman, John, of Arnall 0
4619314 2237034 2237034 defendant Hildeard Robert   589445 589445 Hildeard, Robert, of Arnall 0
4619318 2237035 2237035 defendant Hildeard Robert   589445 589445 Hildeard, Robert, of Arnall 0
4641885 2243733 2243733 defendant Walweyn William   589445 589445 Walweyn, William, of Arnall 1
4751555 2280941 2280941 plaintiff Smyth William   589445 589445 Smyth, William, of Arnall, vicar 0
4774621 2288051 2288051 plaintiff Walwayn Henry   589445 589445 Walwayn, Henry, of Arnall 0
4784190 2291053 2291053 defendant Walwyn Margaret   589445 589445 Walwyn, Margaret, of Arnall, widow of Walwyn, William 3
4791567 2293456 2293456 defendant Taperell Richard husbandman 589445 589445 Taperell, Richard, of Arnall, husbandman 0
4817042 2301428 2301428 defendant Hevenson or Hevenson John husbandman 589445 589445 Hevenson or Hevenson, John, of Arnall, husbandman 3
4821672 2302853 2302853 defendant Smyth William   589445 589445 Smyth, William, of Arnall, vicar 5
4843752 2309567 2309567 defendant Hebenson John husbandman 589445 589445 Hebenson, John, of Arnall, husbandman 4
4856869 2313526 2313526 defendant Stapulford William yeoman 589445 589445 Stapulford, William, of Arnall, yeoman 1
4875532 2319301 2319301 defendant Clyfton John gent 589445 589445 Clyfton, John, of Arnall, gent 0
4886513 2322645 2322645 defendant Clyfton John esq 589445 589445 Clyfton, John, of Arnall, esq 0
4949975 2341962 2341962 defendant Ballard Richard husbandman 589445 589445 Ballard, Richard, of Arnall, husbandman 0
4949976 2341962 2341962 defendant Boteler William   589445 589445 Boteler, William, of Arnall, servant 1
4960843 2345203 2345203 defendant Stapulford John hushandman 589445 589445 Stapulford, John, of Arnall, hushandman 1
5011450 2360213 2360213 defendant Couper Robert husbandman 589445 589445 Couper, Robert, of Arnall, husbandman 4
5029251 2365435 2365435 defendant Arnall Richard gent 589445 589445 Arnall, Richard, of Arnall, gent 0
5029261 2365436 2365436 defendant Nicolson John carpenter 589445 589445 Nicolson, John, of Arnall, carpenter 4
5038880 2368273 2368273 defendant Smyth Robert husbandman 589445 589445 Smyth, Robert, of Arnall, husbandman 3
5046752 2370651 2370651 defendant Balard Robert husbandman 589445 589445 Balard, Robert, of Arnall, husbandman 1
5046753 2370651 2370651 defendant Boteler William husbandman 589445 589445 Boteler, William, of Arnall, husbandman 2
5087617 2382762 2382762 defendant Arnall Richard yeoman 589445 589445 Arnall, Richard, of Arnall, yeoman 0
5087620 2382763 2382763 defendant Arnall Richard yeoman 589445 589445 Arnall, Richard, of Arnall, yeoman 0
5093880 2384611 2384611 defendant Ballard John yeoman 589445 589445 Ballard, John, of Arnall, yeoman 0
5093897 2384615 2384615 defendant Holond Charles yeoman 589445 589445 Holond, Charles, of Arnall, yeoman 0
5097558 2385716 2385716 defendant Arnall Richard yeoman 589445 589445 Arnall, Richard, of Arnall, yeoman 0
5097559 2385716 2385716 defendant Ballard Robert husbandman 589445 589445 Ballard, Robert, of Arnall, husbandman 1
5151429 2401568 2401568 defendant Holand Charles yeoman 589445 589445 Holand, Charles, of Arnall, yeoman 0
5186556 2411817 2411817 defendant Holand Charles yeoman 589445 589445 Holand, Charles, of Arnall, yeoman 0
5194770 2414212 2414212 defendant Holand Charles yeoman 589445 589445 Holand, Charles, of Arnall, yeoman 0
5194771 2414212 2414212 defendant Nundy John husbandman 589445 589445 Nundy, John, of Arnall, husbandman 1
5224804 2422925 2422925 defendant Bokylby John husbandman 589445 589445 Bokylby, John, of Arnall, husbandman 0
5224806 2422925 2422925 defendant Walley Robert husbandman 589445 589445 (Walley, Robert, of Arnall, husbandman 2
5224811 2422927 2422927 defendant Blakewell Eliabeth widow 589445 589445 Blakewell, Eliabeth, of Arnall, widow 1
5226503 2423415 2423415 defendant Holand Charles yeoman 589445 589445 Holand, Charles, of Arnall, yeoman 2
5240470 2427425 2427425 defendant Arnall Richard yeoman 589445 589445 Arnall, Richard, of Arnall, yeoman 1
5243181 2428206 2428206 defendant Holand Charles yeoman 589445 589445 Holand, Charles, of Arnall, yeoman 1
5243185 2428207 2428207 defendant Stapul- Edmund husbandman 589445 589445 Stapul-, Edmund, of Arnall, husbandman 0
5245635 2428883 2428883 defendant Turnour Robert husbandman 589445 589445 Turnour, Robert, of Arnall, husbandman 0
5245636 2428883 2428883 defendant Smyth Robert husbandman 589445 589445 Smyth, Robert, of Arnall, husbandman 1
5245643 2428883 2428883 defendant Hull Robert husbandman 589445 589445 Hull, Robert, of Arnall, husbandman 8
5289912 2442055 2442055 defendant Broun William husbandman 589445 589445 Broun, William, of Arnall, husbandman 11
5324693 2452455 2452455 defendant Arnall Richard gent 589445 589445 Arnall, Richard, of Arnall, gent 2
5498358 2504470 2504470 defendant Lemyng Robert yeoman 589445 589445 Lemyng, Robert, of Arnall, yeoman 0
5616584 2548988 2548988 defendant Hildeyard Thomas   589445 589445 Hildeyard, Thomas, of Arnall 0
5618291 2549538 2549538 defendant Hyldyard Peter   589445 589445 Hyldyard, Peter, of Arnall 0
5618296 2549539 2549539 defendant Rypon Thomas de   589445 589445 Rypon, Thomas de, of Arnall 3
5618299 2549540 2549540 defendant Hyldyard Peter   589445 589445 Hyldyard, Peter, of Arnall 0
5618302 2549540 2549540 defendant Rypon Thomas de   589445 589445 Rypon, Thomas de, of Arnall 3
5618304 2549541 2549541 defendant Poyde Thomas   589445 589445 Poyde, Thomas, of Arnall 0
5629417 2553184 2553184 defendant Turkill Robert husbandman 589445 589445 Turkill, Robert, of Arnall, husbandman 1
5629418 2553184 2553184 defendant Clubwell William husbandman 589445 589445 Clubwell, William, of Arnall, husbandman 2
5629419 2553184 2553184 defendant de Aspeley William husbandman 589445 589445 de Aspeley, William, of Arnall, husbandman 3

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