names

60 rows where place_id = 754558

✎ 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
4421071 2171483 2171483 defendant Barkere John   754558 754558 Barkere, John, of Hadeleye 0
4458225 2187612 2187612 plaintiff Pyket John   754558 754558 Pyket, John, of Hadeleye 0
4467935 2190650 2190650 plaintiff Barbour Walter   754558 754558 Barbour, Walter, of Hadeleye 0
4468475 2190804 2190804 plaintiff Bawedre John   754558 754558 Bawedre, John, of Hadeleye 0
4468477 2190805 2190805 plaintiff Bawedre John   754558 754558 Bawedre, John, of Hadeleye 0
4469008 2190982 2190982 plaintiff Beton William (legal representative) 754558 754558 Beton, William, of Hadeleye, executors of 0
4469023 2190983 2190983 plaintiff Beton William (legal representative) 754558 754558 Beton, William, of Hadeleye, executors of 0
4469029 2190983 2190983 defendant Seman John   754558 754558 Seman, John, of Hadeleye 1
4469035 2190984 2190984 plaintiff Beton William (legal representative) 754558 754558 Beton, William, of Hadeleye, executors of 0
4477954 2193774 2193774 plaintiff Hardheved Philip   754558 754558 Hardheved, Philip, of Hadeleye 0
4477955 2193774 2193774 defendant Plat John taverner 754558 754558 Plat, John, of Hadeleye, taverner 0
4477958 2193774 2193774 defendant Payn Edmund fuller 754558 754558 Payn, Edmund, of Hadeleye, fuller 3
4477962 2193775 2193775 defendant Plat John taverner 754558 754558 Plat, John, of Hadeleye, taverner 0
4477965 2193775 2193775 defendant Payn Edmund fuller 754558 754558 Payn, Edmund, of Hadeleye, fuller 3
4478459 2193938 2193938 plaintiff Hert John   754558 754558 Hert, John, of Hadeleye 0
4478461 2193939 2193939 plaintiff Hert John   754558 754558 Hert, John, of Hadeleye 0
4478463 2193940 2193940 plaintiff Hert John   754558 754558 Hert, John, of Hadeleye 0
4478467 2193941 2193941 plaintiff Hert John   754558 754558 Hert, John, of Hadeleye 0
4481163 2194791 2194791 defendant Tymyot Richard miller 754558 754558 Tymyot, Richard, of Hadeleye, miller 0
4481164 2194791 2194791 defendant Mellere Richard   754558 754558 Mellere, Richard, of Hadeleye 1
4481165 2194791 2194791 defendant Lorkyn John baker 754558 754558 Lorkyn, John, of Hadeleye, baker 2
4483007 2195381 2195381 defendant Kempston John chapman 754558 754558 Kempston, John, of Hadeleye, chapman 0
4488420 2197099 2197099 plaintiff Stonke or Stouke Andrew   754558 754558 Stonke or Stouke, Andrew, of Hadeleye 0
4488452 2197108 2197108 plaintiff Stouke Andrew   754558 754558 Stouke, Andrew, of Hadeleye 0
4497442 2199847 2199847 defendant Sugge William   754558 754558 Sugge, William, of Hadeleye 0
4501269 2201003 2201003 plaintiff Levene John   754558 754558 Levene, John, of Hadeleye, on his own account 0
4501271 2201003 2201003 defendant Man Richard   754558 754558 Man, Richard, of Hadeleye 1
4501272 2201003 2201003 defendant Bardyner Robert smith 754558 754558 Bardyner, Robert, of Hadeleye, smith 2
4509948 2203598 2203598 plaintiff Bakere Henry   754558 754558 Bakere, Henry, of Hadeleye 0
4509949 2203598 2203598 defendant Wade John fuller 754558 754558 Wade, John, of Hadeleye, fuller 0
4509954 2203599 2203599 plaintiff Bakere Henry   754558 754558 Bakere, Henry, of Hadeleye, on his own account 0
4509955 2203599 2203599 defendant Wade John fuller 754558 754558 Wade, John, of Hadeleye, fuller 0
4512089 2204223 2204223 defendant _shaft Mathew dyer 754558 754558 _shaft, Mathew, of Hadeleye, dyer 0
4512092 2204224 2204224 defendant Ramesholt Mathew dyer 754558 754558 Ramesholt, Mathew, of Hadeleye, dyer 0
4521449 2207051 2207051 defendant Huntyngfild John   754558 754558 Huntyngfild, John, of Hadeleye 1
4525908 2208403 2208403 plaintiff Kempton John   754558 754558 Kempton, John, of Hadeleye, on his own account 0
4525913 2208403 2208403 defendant Lenyng John dyer 754558 754558 Lenyng, John, of Hadeleye, dyer 4
4526078 2208453 2208453 plaintiff Kimpton John   754558 754558 Kimpton, John, of Hadeleye 0
4526080 2208453 2208453 defendant Hillory Robert   754558 754558 Hillory, Robert, of Hadeleye 1
4526083 2208453 2208453 defendant Lenyng John dyer 754558 754558 Lenyng, John, of Hadeleye, dyer 4
4537640 2212044 2212044 defendant Dobyl Richard   754558 754558 Dobyl, Richard, of Hadeleye 0
4537641 2212044 2212044 defendant Gardener Robert smith 754558 754558 Gardener, Robert, of Hadeleye, smith 1
4537642 2212045 2212045 plaintiff Talbot John   754558 754558 Talbot, John, of Hadeleye 0
4537644 2212045 2212045 defendant Gardener Robert smith 754558 754558 Gardener, Robert, of Hadeleye, smith 1
4557879 2218396 2218396 defendant Ax Peter fuller 754558 754558 Ax, Peter, of Hadeleye, fuller 0
4563777 2220240 2220240 defendant Lemyng John woodman 754558 754558 Lemyng, John, of Hadeleye, woodman 0
4563779 2220241 2220241 defendant Levyng John   754558 754558 Levyng, John, of Hadeleye, woad worker 0
4579729 2225147 2225147 plaintiff Crembyl Nicholas   754558 754558 Crembyl, Nicholas, of Hadeleye 0
4579730 2225147 2225147 plaintiff Boston Richard   754558 754558 Boston, Richard, of Hadeleye 1
4579733 2225148 2225148 plaintiff Crembyl Nicholas   754558 754558 Crembyl, Nicholas, of Hadeleye 0
4579734 2225148 2225148 plaintiff Boston Richard   754558 754558 Boston, Richard, of Hadeleye 1
4588048 2227661 2227661 defendant Baudewene John   754558 754558 Baudewene, John, of Hadeleye 3
4588055 2227662 2227662 defendant Hert John   754558 754558 Hert, John, of Hadeleye 4
4604961 2232712 2232712 defendant Cranele William   754558 754558 Cranele, William, of Hadeleye 4
4609306 2234012 2234012 plaintiff Bryan John, sen   754558 754558 Bryan, John, sen, of Hadeleye 0
4613977 2235386 2235386 plaintiff Dilston Thomas   754558 754558 Dilston, Thomas, of Hadeleye 0
4660775 2249194 2249194 plaintiff dil Ston Thomas   754558 754558 dil Ston, Thomas, of Hadeleye 0
4997925 2356238 2356238 defendant Hogman Peter hairman 754558 754558 Hogman, Peter, of Hadeleye, hairman 1
5610131 2546877 2546877 defendant atte Bourne William   754558 754558 atte Bourne, William, of Hadeleye 0
5622411 2550934 2550934 defendant Lambe Henry   754558 754558 Lambe, Henry, of Hadeleye, formerly servant to John Mandyon 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);