names

82 rows where place_id = 597283

✎ 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
3627966 1903602 1903602 defendant Bryghtmere Robert yeoman 597283 597283 Bryghtmere, Robert, of Metyngham, yeoman 1
3634952 1905733 1905733 defendant Bonde John laborer 597283 597283 Bonde, John, of Metyngham, laborer 1
3645779 1909082 1909082 defendant Newman Walter husbandman 597283 597283 Newman, Walter, of Metyngham, husbandman 1
3664885 1914963 1914963 plaintiff Shelton Richard clerk & Master of College of St Mary 597283 597283 Shelton, Richard, of Metyngham, clerk & Master of College of St Mary 0
3664887 1914964 1914964 plaintiff Shelton Richard clerk & Master of College of St Mary 597283 597283 Shelton, Richard, of Metyngham, clerk & Master of College of St Mary 0
3664889 1914965 1914965 plaintiff Shelton Richard clerk & Master of St Mary's College 597283 597283 Shelton, Richard, of Metyngham, clerk & Master of St Mary's College 0
3664894 1914966 1914966 plaintiff Shelton Richard clerk & Master of St Mary's College 597283 597283 Shelton, Richard, of Metyngham, clerk & Master of St Mary's College 0
3664897 1914967 1914967 plaintiff Shelton Richard clerk & master of the College 597283 597283 Shelton, Richard, of Metyngham, clerk & master of the College 0
3664899 1914968 1914968 plaintiff Shelton Richard clerk & master of the College 597283 597283 Shelton, Richard, of Metyngham, clerk & master of the College 0
3664901 1914969 1914969 plaintiff Shelton Richard clerk & Master of the College of St Mary 597283 597283 Shelton, Richard, of Metyngham, clerk & Master of the College of St Mary 0
3664906 1914970 1914970 plaintiff Shelton Richard clerk & Master of the College of St Mary 597283 597283 Shelton, Richard, of Metyngham, clerk & Master of the College of St Mary 0
3664911 1914971 1914971 plaintiff Shelton Richard clerk & Master of the College of St Mary 597283 597283 Shelton, Richard, of Metyngham, clerk & Master of the College of St Mary 0
3664914 1914972 1914972 plaintiff Shelton Richard clerk & Master of the College of St Mary 597283 597283 Shelton, Richard, of Metyngham, clerk & Master of the College of St Mary 0
3664917 1914973 1914973 plaintiff Shelton Richard clerk & Master of the College of St Mary 597283 597283 Shelton, Richard, of Metyngham, clerk & Master of the College of St Mary 0
3677812 1919112 1919112 defendant Wylkynson John laborer 597283 597283 Wylkynson, John, of Metyngham, laborer 1
3691175 1923402 1923402 defendant Gosler Robert husbandman 597283 597283 Gosler, Robert, of Metyngham, husbandman 2
3695866 1924942 1924942 defendant Arward Robert husbandman 597283 597283 Arward, Robert, of Metyngham, husbandman 1
3709761 1929366 1929366 defendant Arward Robert husbandman 597283 597283 Arward, Robert, of Metyngham, husbandman 1
3711571 1929929 1929929 plaintiff More Thomas   597283 597283 More, Thomas, of Metyngham 3
3711577 1929930 1929930 plaintiff More Thomas   597283 597283 More, Thomas, of Metyngham 3
3750942 1942218 1942218 defendant Rolf Henry baker 597283 597283 Rolf, Henry, of Metyngham, baker 2
3800121 1957961 1957961 defendant More Thomas yeoman 597283 597283 More, Thomas, of Metyngham, yeoman 0
3812760 1961884 1961884 defendant Gybson John husbandman 597283 597283 Gybson, John, of Metyngham, husbandman 0
3862540 1977665 1977665 defendant Wheler Thomas husbandman 597283 597283 Wheler, Thomas, of Metyngham, husbandman 3
3862942 1977802 1977802 plaintiff Shelton Richard clerk 597283 597283 Shelton, Richard, of Metyngham, clerk 2
3892460 1987724 1987724 plaintiff Moryss John (legal representative) 597283 597283 Moryss, John, of Metyngham, clerk, executor of 0
3903149 1991282 1991282 plaintiff Frosteyn Thomas (legal representative) 597283 597283 Frosteyn, Thomas, of Metyngham, executor of 0
3929049 2000055 2000055 defendant More Thomas yeoman 597283 597283 More, Thomas, of Metyngham, yeoman 0
3929050 2000055 2000055 defendant Tybynham Feliz yeoman 597283 597283 Tybynham, Feliz, of Metyngham, yeoman 1
3988491 2020628 2020628 defendant Bateley William husbandman 597283 597283 Bateley, William, of Metyngham, husbandman 0
4001617 2025358 2025358 plaintiff Harlynge Robert (legal representative) 597283 597283 Harlynge, Robert, of Metyngham, husbandman, administratrix of 0
4116654 2066250 2066250 defendant Bateley Leonard yeoman 597283 597283 Bateley, Leonard, of Metyngham, yeoman 3
4647114 2245210 2245210 defendant Wilbeye John master of the chantry 597283 597283 Wilbeye, John, of Metyngham, master of the chantry 8
4802491 2296967 2296967 defendant Multon Robert miller 597283 597283 Multon, Robert, of Metyngham, miller 0
4812776 2300112 2300112 plaintiff Hardy Nicholas   597283 597283 Hardy, Nicholas, of Metyngham 0
4911448 2330083 2330083 plaintiff Bronbrygge Roger Master of the College of the Blessed Mary 597283 597283 Bronbrygge, Roger, of Metyngham, Master of the College of the Blessed Mary 0
4912327 2330356 2330356 defendant Wyard Robert   597283 597283 Wyard, Robert, of Metyngham, son of Thomas 1
4955885 2343727 2343727 defendant Metyngham Nicholas gent 597283 597283 Metyngham, Nicholas, of Metyngham, gent 0
4957812 2344308 2344308 plaintiff Brigeham William chaplain 597283 597283 (Brigeham, William, of Metyngham, chaplain 1
4957813 2344308 2344308 plaintiff Waryn John chaplain 597283 597283 Waryn, John, of Metyngham, chaplain 2
4976073 2349804 2349804 defendant Thurton John husbandman 597283 597283 Thurton, John, of Metyngham, husbandman 2
5017149 2361915 2361915 defendant Pentok John laborer 597283 597283 Pentok, John, of Metyngham, laborer 0
5043448 2369664 2369664 plaintiff Fraunsham William Master or Warden of St Mary's College 597283 597283 Fraunsham, William, of Metyngham, Master or Warden of St Mary's College 0
5052338 2372301 2372301 defendant Shreder Roger husbandman 597283 597283 Shreder, Roger, of Metyngham, husbandman 0
5052342 2372302 2372302 defendant Wellys John husbandman 597283 597283 Wellys, John, of Metyngham, husbandman 0
5105354 2388009 2388009 defendant Banyard John esq 597283 597283 Banyard, John, of Metyngham, esq 0
5130999 2395550 2395550 plaintiff Fra--m William Master singer of the college of BM 597283 597283 Fra--m, William, of Metyngham, Master singer of the college of BM 0
5131025 2395560 2395560 plaintiff Fraunsham alias Fraunces William clerk & Master 597283 597283 Fraunsham alias Fraunces, William, of Metyngham, clerk & Master 0
5147515 2400416 2400416 defendant Banyard John esq 597283 597283 Banyard, John, of Metyngham, esq 0
5150531 2401295 2401295 plaintiff Fraunsham William clerk & master 597283 597283 Fraunsham, William, of Metyngham, clerk & master 0
5167181 2406136 2406136 defendant Banyard John esq 597283 597283 Banyard, John, of Metyngham, esq 0
5185425 2411484 2411484 plaintiff Fraunsham William master of the chantry 597283 597283 Fraunsham, William, of Metyngham, master of the chantry 0
5201572 2416221 2416221 plaintiff Banyard John esq 597283 597283 Banyard, John, of Metyngham, esq 0
5204769 2417142 2417142 plaintiff Fraunsham William master of the chantry 597283 597283 Fraunsham, William, of Metyngham, master of the chantry 0
5276478 2438191 2438191 defendant Pek Thomas chaplain 597283 597283 Pek, Thomas, of Metyngham, chaplain 2
5276482 2438192 2438192 defendant Pek Thomas chaplain 597283 597283 Pek, Thomas, of Metyngham, chaplain 2
5291477 2442512 2442512 defendant Rowelond Robert husbandman 597283 597283 Rowelond, Robert, of Metyngham, husbandman 0
5302770 2445812 2445812 plaintiff Fraunsham William master or warden of the College 597283 597283 Fraunsham, William, of Metyngham, master or warden of the College 0
5366538 2465187 2465187 defendant Goldsmyth William yeoman 597283 597283 Goldsmyth, William, of Metyngham, yeoman 1
5383124 2470246 2470246 defendant Goldsmyth John merchant 597283 597283 Goldsmyth, John, of Metyngham, merchant 0
5383125 2470246 2470246 defendant Goldsmyth William yeoman 597283 597283 Goldsmyth, William, of Metyngham, yeoman 1
5384803 2470729 2470729 plaintiff Braunch Richard master of the College of the BM 597283 597283 Braunch, Richard, of Metyngham, master of the College of the BM 0
5384892 2470753 2470753 defendant Goldsmyth William yeoman 597283 597283 Goldsmyth, William, of Metyngham, yeoman 1
5396826 2474176 2474176 plaintiff Braunch Richard Master of the College of the BVM 597283 597283 Braunch, Richard, of Metyngham, Master of the College of the BVM 0
5396828 2474177 2474177 plaintiff Braunche Richard clerk & Master of Blessed Mary's College 597283 597283 Braunche, Richard, of Metyngham, clerk & Master of Blessed Mary's College 0
5396830 2474178 2474178 plaintiff Braunche Richard clerk & Master of the College of the BM 597283 597283 Braunche, Richard, of Metyngham, clerk & Master of the College of the BM 0
5410066 2477970 2477970 plaintiff Braunch Richard master of the college of the BM 597283 597283 Braunch, Richard, of Metyngham, master of the college of the BM 0
5410068 2477971 2477971 plaintiff Braunch Richard master of the college of the BM 597283 597283 Braunch, Richard, of Metyngham, master of the college of the BM 0
5410070 2477972 2477972 plaintiff Braunch Richard master of the college of the BM 597283 597283 Braunch, Richard, of Metyngham, master of the college of the BM 0
5410470 2478077 2478077 defendant Goldsmyth William yeoman 597283 597283 Goldsmyth, William, of Metyngham, yeoman 1
5423720 2482058 2482058 plaintiff Braunch Richard master of the college of the BM 597283 597283 Braunch, Richard, of Metyngham, master of the college of the BM 0
5423722 2482059 2482059 plaintiff Braunche Richard clerk & master of the college of the BM 597283 597283 Braunche, Richard, of Metyngham, clerk & master of the college of the BM 0
5423724 2482060 2482060 plaintiff Braunche Richard master of the college of the BM 597283 597283 Braunche, Richard, of Metyngham, master of the college of the BM 0
5423726 2482061 2482061 plaintiff Braunche Richard master of the college of the BM 597283 597283 Braunche, Richard, of Metyngham, master of the college of the BM 0
5442913 2487792 2487792 plaintiff Braunche Richard clerk & master of the college of the BM 597283 597283 Braunche, Richard, of Metyngham, clerk & master of the college of the BM 0
5455683 2491601 2491601 plaintiff Braunche Richard master of the college of the BM 597283 597283 Braunche, Richard, of Metyngham, master of the college of the BM 0
5455685 2491602 2491602 plaintiff Braunche Richard master of the college of the BM 597283 597283 Braunche, Richard, of Metyngham, master of the college of the BM 0
5486834 2500963 2500963 defendant Wodeherd William husbandman 597283 597283 Wodeherd, William, of Metyngham, husbandman 0
5505656 2506689 2506689 defendant Goldsmyth William yeoman 597283 597283 Goldsmyth, William, of Metyngham, yeoman 0
5553222 2520983 2520983 defendant Geddyng Robert husbandman 597283 597283 Geddyng, Robert, of Metyngham, husbandman 0
5580826 2529081 2529081 defendant Sibely William yeoman 597283 597283 Sibely, William, of Metyngham, yeoman 2
5580831 2529082 2529082 defendant Sybeley William yeoman 597283 597283 Sybeley, William, of Metyngham, yeoman 2

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