names

52 rows where place_id = 755248

✎ 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
4426775 2173190 2173190 defendant Stayard John   755248 755248 Stayard, John, of Feltewell 0
4435754 2175926 2175926 defendant Stayard John   755248 755248 Stayard, John, of Feltewell 0
4439647 2181667 2181667 defendant Warde Henry   755248 755248 Warde, Henry, of Feltewell 0
4443435 2182908 2182908 defendant Fynch Richard   755248 755248 Fynch, Richard, of Feltewell 0
4449037 2184643 2184643 defendant Henalen Geoffrey   755248 755248 Henalen, Geoffrey, of Feltewell 0
4449038 2184643 2184643 defendant Dongere Walter   755248 755248 Dongere, Walter, of Feltewell 1
4452308 2185709 2185709 plaintiff Janyns Margaret   755248 755248 Janyns, Margaret, of Feltewell 0
4452309 2185709 2185709 defendant Byntyng William   755248 755248 Byntyng, William, of Feltewell 0
4471441 2191728 2191728 defendant Cook John   755248 755248 Cook, John, of Feltewell 2
4525337 2208266 2208266 defendant Thakester Thomas   755248 755248 Thakester, Thomas, of Feltewell 0
4525338 2208266 2208266 defendant Thakester William   755248 755248 Thakester, William, of Feltewell 1
4539774 2212701 2212701 plaintiff Walter Katherine   755248 755248 Walter, Katherine, of Feltewell, formerly wife of Oliver Walter 0
4544198 2214101 2214101 defendant Lyle William   755248 755248 Lyle, William, of Feltewell 2
4554390 2217301 2217301 defendant Bocher William   755248 755248 Bocher, William, of Feltewell 3
4560579 2219249 2219249 plaintiff Noreys William   755248 755248 Noreys, William, of Feltewell 0
4609335 2234019 2234019 defendant Spencer John   755248 755248 Spencer, John, of Feltewell 4
4680800 2259614 2259614 defendant Peers Thomas husbandman 755248 755248 Peers, Thomas, of Feltewell, husbandman 0
4809499 2299144 2299144 defendant Norye Richard yeoman 755248 755248 Norye, Richard, of Feltewell, yeoman 1
4817549 2301579 2301579 defendant Lawe John smith 755248 755248 Lawe, John, of Feltewell, smith 0
4834662 2306844 2306844 plaintiff Crowe Robert   755248 755248 Crowe, Robert, of Feltewell, parson of St Nicholas' church 0
4850917 2311737 2311737 defendant Randolf Thomas husbandman 755248 755248 Randolf, Thomas, of Feltewell, husbandman 0
4886206 2322547 2322547 defendant Mey John chaplain 755248 755248 Mey, John, of Feltewell, chaplain 0
4914431 2331031 2331031 plaintiff Crowe Robert   755248 755248 Crowe, Robert, of Feltewell, parson of the church of St Nicholas 0
4928073 2335214 2335214 defendant Ostelyn John husbandman 755248 755248 Ostelyn, John, of Feltewell, husbandman 0
4928076 2335214 2335214 defendant Grigge John   755248 755248 Grigge, John, of Feltewell, shepherd 3
4929228 2335558 2335558 defendant Graunfeld William husbandman 755248 755248 Graunfeld, William, of Feltewell, husbandman 0
4939806 2338838 2338838 defendant Dalydy William husbandman 755248 755248 Dalydy, William, of Feltewell, husbandman 0
5003831 2358013 2358013 defendant Multon Richard husbandman 755248 755248 Multon, Richard, of Feltewell, husbandman 1
5003832 2358013 2358013 defendant Man John husbandman 755248 755248 Man, John, of Feltewell, husbandman 2
5053347 2372605 2372605 defendant Dunham Edmund mercer 755248 755248 Dunham, Edmund, of Feltewell, mercer 0
5053348 2372605 2372605 defendant Man John husbandman 755248 755248 Man, John, of Feltewell, husbandman 1
5053349 2372605 2372605 defendant Dunham Robert husbandman 755248 755248 Dunham, Robert, of Feltewell, husbandman 2
5053350 2372605 2372605 defendant Ostelyn John laborer 755248 755248 Ostelyn, John, of Feltewell, laborer 3
5053351 2372605 2372605 defendant Carle Robert laborer 755248 755248 Carle, Robert, of Feltewell, laborer 4
5232192 2424992 2424992 defendant Mathewe John, junior yeoman 755248 755248 Mathewe, John, junior, of Feltewell, yeoman 0
5232194 2424993 2424993 defendant Dey John yeoman 755248 755248 Dey, John, of Feltewell, yeoman 0
5235639 2426004 2426004 plaintiff Dey John   755248 755248 Dey, John, of Feltewell 0
5235640 2426004 2426004 plaintiff Gybyn Richard   755248 755248 Gybyn, Richard, of Feltewell 1
5325763 2452785 2452785 defendant Mundeford Gilbert gent 755248 755248 Mundeford, Gilbert, of Feltewell, gent 0
5333713 2455157 2455157 plaintiff Deye John (legal representative) 755248 755248 Deye, John, of Feltewell, executors of 0
5394538 2473497 2473497 defendant Cowale Edmund husbandman 755248 755248 Cowale, Edmund, of Feltewell, husbandman 1
5431580 2484399 2484399 defendant Chyncheball William husbandman 755248 755248 Chyncheball, William, of Feltewell, husbandman 0
5447968 2489275 2489275 defendant Chyncheball William husbandman 755248 755248 Chyncheball, William, of Feltewell, husbandman 0
5460357 2493036 2493036 defendant Chyncheball William husbandman 755248 755248 Chyncheball, William, of Feltewell, husbandman 0
5471958 2496571 2496571 defendant Chyncheball William husbandman 755248 755248 Chyncheball, William, of Feltewell, husbandman 0
5471961 2496572 2496572 defendant Chyncheball William husbandman 755248 755248 Chyncheball, William, of Feltewell, husbandman 0
5483375 2499974 2499974 defendant Chyncheball or Chynchevall William husbandman 755248 755248 Chyncheball or Chynchevall, William, of Feltewell, husbandman 0
5487864 2501258 2501258 defendant Mathewe John yeoman 755248 755248 Mathewe, John, of Feltewell, yeoman 1
5617889 2549412 2549412 plaintiff Lexham Thomas   755248 755248 (Lexham, Thomas, of Feltewell, parson of St Mary's church 1
5620011 2550120 2550120 plaintiff Reve John   755248 755248 Reve, John, of Feltewell 0
5623166 2551182 2551182 plaintiff Lexham Thomas de   755248 755248 (Lexham, Thomas de, of Feltewell, parson of the church of the BM 1
5625221 2551827 2551827 defendant Wryghte Thomas carpenter 755248 755248 Wryghte, Thomas, of Feltewell, carpenter 1

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