names

57 rows where place_id = 587648

✎ 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
3592041 1865126 1865126 defendant Yerdeley John husbandman 587648 587648 Yerdeley, John, of Lydgate, husbandman 0
3603556 1868783 1868783 defendant Personice Thomas husbandman 587648 587648 Personice, Thomas, of Lydgate, husbandman 0
3629793 1904170 1904170 defendant Taylour Thomas husbandman 587648 587648 (Taylour, Thomas, of Lydgate, husbandman 1
3638318 1906801 1906801 defendant Yerdeley Andrew husbandman 587648 587648 Yerdeley, Andrew, of Lydgate, husbandman 0
3638331 1906805 1906805 defendant Yerdeley Andrew husbandman 587648 587648 Yerdeley, Andrew, of Lydgate, husbandman 0
3650990 1910679 1910679 defendant Avyse Thomas, senior husbandman 587648 587648 Avyse, Thomas, senior, of Lydgate, husbandman 0
3650991 1910679 1910679 defendant Avyse John, junior husbandman 587648 587648 Avyse, John, junior, of Lydgate, husbandman 1
3681128 1920179 1920179 defendant Andrewe Thomas yeoman 587648 587648 Andrewe, Thomas, of Lydgate, yeoman 1
3681129 1920179 1920179 defendant Egyll Edward woolman 587648 587648 Egyll, Edward, of Lydgate, woolman 2
3695664 1924876 1924876 defendant Andrewe Thomas husbandman 587648 587648 Andrewe, Thomas, of Lydgate, husbandman 0
3695672 1924877 1924877 defendant Ballard William husbandman 587648 587648 Ballard, William, of Lydgate, husbandman 3
3709684 1929340 1929340 defendant Eggyll Edward woolman 587648 587648 Eggyll, Edward, of Lydgate, woolman 1
3761166 1945496 1945496 plaintiff Egill Edward   587648 587648 Egill, Edward, of Lydgate 0
3779382 1951274 1951274 plaintiff Egill Edward   587648 587648 Egill, Edward, of Lydgate 0
3831676 1967805 1967805 defendant Derysley John husbandman 587648 587648 Derysley, John, of Lydgate, husbandman 0
3868661 1979760 1979760 plaintiff Taylour Thomas   587648 587648 Taylour, Thomas, of Lydgate 0
3895401 1988672 1988672 defendant Burdon Robert yeoman 587648 587648 Burdon, Robert, of Lydgate, yeoman 0
3915315 1995488 1995488 defendant Otley William husbandman 587648 587648 Otley, William, of Lydgate, husbandman 3
3915364 1995505 1995505 defendant Caley William yeoman 587648 587648 Caley, William, of Lydgate, yeoman 2
3924840 1998627 1998627 defendant Ottle William husbandman 587648 587648 Ottle, William, of Lydgate, husbandman 0
3924842 1998627 1998627 defendant Thurston Thomas husbandman 587648 587648 Thurston, Thomas, of Lydgate, husbandman 2
4116340 2066131 2066131 defendant Halles Thomas yeoman 587648 587648 Halles, Thomas, of Lydgate, yeoman 1
4194089 2093487 2093487 defendant Lyllye George yeoman 587648 587648 Lyllye, George, of Lydgate, yeoman 0
4406865 2166864 2166864 defendant Warren Thomas yeoman 587648 587648 Warren, Thomas, of Lydgate, yeoman 1
4594128 2229426 2229426 defendant Lymynge Robert   587648 587648 Lymynge, Robert, of Lydgate 1
4676092 2258134 2258134 defendant Reed Thomas laborer 587648 587648 Reed, Thomas, of Lydgate, laborer 0
4681922 2259962 2259962 defendant Wellys Robert clerk & parson 587648 587648 Wellys, Robert, of Lydgate, clerk & parson 1
4691946 2263015 2263015 defendant Hymmyng Robert husbandman 587648 587648 Hymmyng, Robert, of Lydgate, husbandman 0
4691947 2263015 2263015 defendant Webbe Thomas husbandman 587648 587648 Webbe, Thomas, of Lydgate, husbandman 1
4702037 2266048 2266048 defendant Catour Stephen yeoman 587648 587648 Catour, Stephen, of Lydgate, yeoman 0
4717641 2270853 2270853 defendant Lymmynge Roger husbandman 587648 587648 Lymmynge, Roger, of Lydgate, husbandman 0
4717642 2270853 2270853 defendant Webbe Thomas husbandman 587648 587648 Webbe, Thomas, of Lydgate, husbandman 1
4753817 2281569 2281569 defendant Wryghte Robert parker 587648 587648 Wryghte, Robert, of Lydgate, parker 1
4775058 2288191 2288191 defendant Webbe Thomas husbandman 587648 587648 Webbe, Thomas, of Lydgate, husbandman 2
4843897 2309610 2309610 defendant Webbe Thomas weaver 587648 587648 Webbe, Thomas, of Lydgate, weaver 0
4885567 2322366 2322366 defendant Meyre John husbandman 587648 587648 Meyre, John, of Lydgate, husbandman 0
4911690 2330157 2330157 defendant Lank Thomas   587648 587648 Lank, Thomas, of Lydgate, parson 2
5092019 2384044 2384044 defendant Veske Ralph clerk 587648 587648 Veske, Ralph, of Lydgate, clerk 1
5298405 2444509 2444509 defendant Chaunceler William husbandman 587648 587648 Chaunceler, William, of Lydgate, husbandman 0
5361531 2463629 2463629 defendant Tayllard Giles husbandman 587648 587648 Tayllard, Giles, of Lydgate, husbandman 1
5373493 2467306 2467306 defendant Webbe Adam husbandman 587648 587648 Webbe, Adam, of Lydgate, husbandman 2
5403388 2476042 2476042 defendant Webbe Adam husbandman 587648 587648 Webbe, Adam, of Lydgate, husbandman 2
5416483 2479847 2479847 defendant (illegible) Adam husbandman 587648 587648 _, Adam, of Lydgate, husbandman 2
5550398 2520137 2520137 defendant Tayllour Thomas yeoman 587648 587648 Tayllour, Thomas, of Lydgate, yeoman 0
5550399 2520137 2520137 defendant Derysley Walter husbandman 587648 587648 Derysley, Walter, of Lydgate, husbandman 1
5567243 2524995 2524995 defendant Ladyman John panier maker 587648 587648 Ladyman, John, of Lydgate, panier maker 1
5577944 2528175 2528175 defendant Thurston John carpenter 587648 587648 Thurston, John, of Lydgate, carpenter 1
5579450 2528651 2528651 defendant Thurstone John carpenter 587648 587648 Thurstone, John, of Lydgate, carpenter 0
5579451 2528651 2528651 defendant Sakyn Thomas laborer 587648 587648 Sakyn, Thomas, of Lydgate, laborer 1
5582234 2529516 2529516 defendant Belton Geoffrey yeoman 587648 587648 Belton, Geoffrey, of Lydgate, yeoman 1
5586035 2530675 2530675 defendant Balard William smith 587648 587648 Balard, William, of Lydgate, smith 0
5586042 2530677 2530677 defendant Balard William smith 587648 587648 Balard, William, of Lydgate, smith 1
5586045 2530678 2530678 defendant Balard William smith 587648 587648 Balard, William, of Lydgate, smith 1
5587922 2531232 2531232 defendant Dekman Edmund clerk 587648 587648 Dekman, Edmund, of Lydgate, clerk 0
5601382 2535322 2535322 defendant Balard William smith 587648 587648 Balard, William, of Lydgate, smith 2
5629919 2553360 2553360 defendant Weny or Wevy John yeoman 587648 587648 Weny or Wevy, John, of Lydgate, yeoman 3
5629920 2553360 2553360 defendant Squyrell John yeoman 587648 587648 Squyrell, John, of Lydgate, yeoman 4

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